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/schema.sql | |
| parent | 63705942a366d39308251549a018451808c20ac8 (diff) | |
| download | querymanager-d92f642810dc3125515d64f953d2bee840de1cc1.tar.gz querymanager-d92f642810dc3125515d64f953d2bee840de1cc1.zip | |
world startup/shutdown timestamps + adjust a few column names
Diffstat (limited to 'postgres/schema.sql')
| -rw-r--r-- | postgres/schema.sql | 6 |
1 files changed, 4 insertions, 2 deletions
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) ); |