diff options
| author | fusion32 <marcopuzziello@gmail.com> | 2025-10-17 16:12:31 -0300 |
|---|---|---|
| committer | fusion32 <marcopuzziello@gmail.com> | 2025-10-17 16:12:31 -0300 |
| commit | d92f642810dc3125515d64f953d2bee840de1cc1 (patch) | |
| tree | fbb497f3e65725a86366bc49aff0270e029d0316 /postgres | |
| parent | 63705942a366d39308251549a018451808c20ac8 (diff) | |
| download | querymanager-d92f642810dc3125515d64f953d2bee840de1cc1.tar.gz querymanager-d92f642810dc3125515d64f953d2bee840de1cc1.zip | |
world startup/shutdown timestamps + adjust a few column names
Diffstat (limited to 'postgres')
| -rw-r--r-- | postgres/init.sql | 2 | ||||
| -rw-r--r-- | postgres/schema.sql | 6 |
2 files changed, 5 insertions, 3 deletions
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) ); |