diff options
Diffstat (limited to 'sqlite/schema.sql')
| -rw-r--r-- | sqlite/schema.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/sqlite/schema.sql b/sqlite/schema.sql index 2ee1a8b..9981976 100644 --- a/sqlite/schema.sql +++ b/sqlite/schema.sql @@ -94,8 +94,9 @@ CREATE TABLE CharacterDeaths ( Unjustified INTEGER NOT NULL, Timestamp INTEGER NOT NULL ); -CREATE INDEX CharacterDeathsCharacterIndex ON CharacterDeaths(CharacterID, Level); -CREATE INDEX CharacterDeathsOffenderIndex ON CharacterDeaths(OffenderID, Unjustified); +CREATE INDEX CharacterDeathsCharacterIndex ON CharacterDeaths(CharacterID, Timestamp); +CREATE INDEX CharacterDeathsOffenderIndex ON CharacterDeaths(OffenderID, Timestamp); +CREATE INDEX CharacterDeathsTimeIndex ON CharacterDeaths(Timestamp); CREATE TABLE Buddies ( WorldID INTEGER NOT NULL, |