fix problem with concurrent writes + implement website queries

  There was a problem with concurrent writes not being visible
until after restart, due to how cached prepared statements work
with SQLite (see comment in `database.cc`).

1 files changed, 14 insertions, 0 deletions

diff --git a/sql/schema.sql b/sql/schema.sql
index c8a78ec..90f59a8 100644
--- a/sql/schema.sql
+++ b/sql/schema.sql
@@ -6,12 +6,16 @@ CREATE TABLE IF NOT EXISTS Worlds (
 	Type INTEGER NOT NULL,
 	RebootTime INTEGER NOT NULL,
 	IPAddress INTEGER NOT NULL,
+	-- TODO(fusion): Have some hostname resolution cache and send the resolved
+	-- addresses instead of hardcoding them into the database.
+	--Host TEXT NOT NULL,
 	Port INTEGER NOT NULL,
 	MaxPlayers INTEGER NOT NULL,
 	PremiumPlayerBuffer INTEGER NOT NULL,
 	MaxNewbies INTEGER NOT NULL,
 	PremiumNewbieBuffer INTEGER NOT NULL,
 	OnlineRecord INTEGER NOT NULL DEFAULT 0,
+	OnlineRecordTimestamp INTEGER NOT NULL DEFAULT 0,
 	PRIMARY KEY (WorldID),
 	UNIQUE (Name)
 );
@@ -275,6 +279,16 @@ 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);
 
+/*
+-- TODO(fusion): Have group rights instead of adding individual rights to characters?
+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)
+);
+*/
+
 INSERT INTO CharacterRights (CharacterID, Right)
 	VALUES
 		(1, 'NOTATION'),