From d92f642810dc3125515d64f953d2bee840de1cc1 Mon Sep 17 00:00:00 2001 From: fusion32 Date: Fri, 17 Oct 2025 16:12:31 -0300 Subject: world startup/shutdown timestamps + adjust a few column names --- postgres/schema.sql | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'postgres/schema.sql') diff --git a/postgres/schema.sql b/postgres/schema.sql index bbc670f..32afe2c 100644 --- a/postgres/schema.sql +++ b/postgres/schema.sql @@ -42,8 +42,10 @@ CREATE TABLE Worlds ( PremiumPlayerBuffer SMALLINT NOT NULL, MaxNewbies SMALLINT NOT NULL, PremiumNewbieBuffer SMALLINT NOT NULL, - OnlineRecord SMALLINT NOT NULL DEFAULT 0, - OnlineRecordTimestamp TIMESTAMPTZ NOT NULL DEFAULT 'epoch', + OnlinePeak SMALLINT NOT NULL DEFAULT 0, + OnlinePeakTimestamp TIMESTAMPTZ NOT NULL DEFAULT 'epoch', + LastStartup TIMESTAMPTZ NOT NULL DEFAULT 'epoch', + LastShutdown TIMESTAMPTZ NOT NULL DEFAULT 'epoch', PRIMARY KEY (WorldID), UNIQUE (Name) ); -- cgit v1.2.3