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/init.sql | 2 +- postgres/schema.sql | 6 ++++-- 2 files changed, 5 insertions(+), 3 deletions(-) (limited to 'postgres') diff --git a/postgres/init.sql b/postgres/init.sql index e3907bd..fbe40c7 100644 --- a/postgres/init.sql +++ b/postgres/init.sql @@ -112,6 +112,6 @@ INSERT INTO CharacterRights(CharacterID, Name) ('CLEANUP_FIELDS'), ('NO_STATISTICS') ) AS R (RightName) - WHERE C.Name ILIKE 'Gamemaster%' COLLATE "default"; + WHERE C.Name LIKE 'Gamemaster%' COLLATE "default"; COMMIT; 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