world startup/shutdown timestamps + adjust a few column names

2 files changed, 9 insertions, 7 deletions

diff --git a/sqlite/init.sql b/sqlite/init.sql
index dc30adf..9d561fc 100644
--- a/sqlite/init.sql
+++ b/sqlite/init.sql
@@ -19,7 +19,7 @@ INSERT INTO Accounts (AccountID, Email, Auth)
 INSERT INTO Characters (WorldID, CharacterID, AccountID, Name, Sex)
 	VALUES (1, 1, 111111, 'Gamemaster', 1), (1, 2, 111111, 'Player', 1);
 
-INSERT INTO CharacterRights (CharacterID, Right)
+INSERT INTO CharacterRights (CharacterID, Name)
 	VALUES
 		(1, 'NOTATION'),
 		(1, 'NAMELOCK'),
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 (