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 /postgres/schema.sql | |
| parent | 27a0df43b33b712462ab5be65462162b9e4bcd29 (diff) | |
| download | querymanager-6aa13394a12c1931990b91e62210cba72706920d.tar.gz querymanager-6aa13394a12c1931990b91e62210cba72706920d.zip | |
adjust character death indexes for common queries
Diffstat (limited to 'postgres/schema.sql')
| -rw-r--r-- | postgres/schema.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/postgres/schema.sql b/postgres/schema.sql index 08837c5..bce1b35 100644 --- a/postgres/schema.sql +++ b/postgres/schema.sql @@ -109,8 +109,9 @@ CREATE TABLE CharacterDeaths ( Unjustified BOOLEAN NOT NULL, Timestamp TIMESTAMPTZ 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, |