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