21 lines
928 B
PL/PgSQL
21 lines
928 B
PL/PgSQL
-- NOTE(fusion): This file contains index adjustments for the `CharacterDeaths`
|
|
-- table. It is not strictly necessary as there are no modified tables but should
|
|
-- help with queries such as the most recent deaths/kills from a specific character
|
|
-- or overall.
|
|
-- It's inside a transaction to avoid errors from leaving the database in some
|
|
-- partial state. The changes are already present in the latest `schema.sql`, so
|
|
-- trying to apply them on a newly created database will result in errors.
|
|
--==============================================================================
|
|
|
|
BEGIN;
|
|
|
|
DROP INDEX CharacterDeathsCharacterIndex;
|
|
DROP INDEX CharacterDeathsOffenderIndex;
|
|
|
|
CREATE INDEX CharacterDeathsCharacterIndex ON CharacterDeaths(CharacterID, Timestamp);
|
|
CREATE INDEX CharacterDeathsOffenderIndex ON CharacterDeaths(OffenderID, Timestamp);
|
|
CREATE INDEX CharacterDeathsTimeIndex ON CharacterDeaths(Timestamp);
|
|
|
|
COMMIT;
|
|
|