diff options
Diffstat (limited to 'sqlite/schema.sql')
| -rw-r--r-- | sqlite/schema.sql | 14 |
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 ( |