From d92f642810dc3125515d64f953d2bee840de1cc1 Mon Sep 17 00:00:00 2001
From: fusion32 <marcopuzziello@gmail.com>
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

