world startup/shutdown timestamps + adjust a few column names

1 files changed, 8 insertions, 6 deletions

diff --git a/sqlite/schema.sql b/sqlite/schema.sql
index 106c780..ead3908 100644
--- a/sqlite/schema.sql
+++ b/sqlite/schema.sql
@@ -11,8 +11,10 @@ CREATE TABLE IF NOT EXISTS Worlds (
 	PremiumPlayerBuffer INTEGER NOT NULL,
 	MaxNewbies INTEGER NOT NULL,
 	PremiumNewbieBuffer INTEGER NOT NULL,
-	OnlineRecord INTEGER NOT NULL DEFAULT 0,
-	OnlineRecordTimestamp INTEGER NOT NULL DEFAULT 0,
+	OnlinePeak INTEGER NOT NULL DEFAULT 0,
+	OnlinePeakTimestamp INTEGER NOT NULL DEFAULT 0,
+	LastStartup INTEGER NOT NULL DEFAULT 0,
+	LastShutdown INTEGER NOT NULL DEFAULT 0,
 	PRIMARY KEY (WorldID),
 	UNIQUE (Name)
 );
@@ -59,15 +61,15 @@ CREATE INDEX IF NOT EXISTS CharactersGuildIndex
 ALTER TABLE Characters ADD GroupID INTEGER NOT NULL;
 CREATE TABLE IF NOT EXISTS CharacterRights (
 	GroupID INTEGER NOT NULL,
-	Right TEXT NOT NULL COLLATE NOCASE,
-	PRIMARY KEY(GroupID, Right)
+	Name TEXT NOT NULL COLLATE NOCASE,
+	PRIMARY KEY(GroupID, Name)
 );
 */
 
 CREATE TABLE IF NOT EXISTS CharacterRights (
 	CharacterID INTEGER NOT NULL,
-	Right TEXT NOT NULL COLLATE NOCASE,
-	PRIMARY KEY(CharacterID, Right)
+	Name TEXT NOT NULL COLLATE NOCASE,
+	PRIMARY KEY(CharacterID, Name)
 );
 
 CREATE TABLE IF NOT EXISTS CharacterDeaths (