diff options
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) ); |