diff options
| author | fusion32 <marcopuzziello@gmail.com> | 2025-10-27 21:44:13 -0300 |
|---|---|---|
| committer | fusion32 <marcopuzziello@gmail.com> | 2025-10-27 21:44:13 -0300 |
| commit | 6aa13394a12c1931990b91e62210cba72706920d (patch) | |
| tree | d5a101e234cd7af61dc6d4573e897a1b4454410c /sqlite/schema.sql | |
| parent | 27a0df43b33b712462ab5be65462162b9e4bcd29 (diff) | |
| download | querymanager-6aa13394a12c1931990b91e62210cba72706920d.tar.gz querymanager-6aa13394a12c1931990b91e62210cba72706920d.zip | |
adjust character death indexes for common queries
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, |