diff options
Diffstat (limited to 'db updates.sql')
| -rw-r--r-- | db updates.sql | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/db updates.sql b/db updates.sql index 3cef782..f472392 100644 --- a/db updates.sql +++ b/db updates.sql @@ -244,4 +244,7 @@ ALTER TABLE `challengeMaps` ADD UNIQUE ( `challengeTier` , `challengeSuborder`); ALTER TABLE `challenges` DROP INDEX `mapID` , -ADD UNIQUE `mapID` ( `mapID` , `ordering` );
\ No newline at end of file +ADD UNIQUE `mapID` ( `mapID` , `ordering` ); + +-- Optimizing the daily update queries +ALTER TABLE `solutions` ADD INDEX ( `isHighScore` )
\ No newline at end of file |