diff options
| author | BlueRaja <BlueRaja.admin@gmail.com> | 2013-03-20 02:02:38 -0500 |
|---|---|---|
| committer | BlueRaja <BlueRaja.admin@gmail.com> | 2013-03-20 02:02:38 -0500 |
| commit | 38d39346a3a9a49bf2c2927c8c79019b4098877b (patch) | |
| tree | 514b47d91a7d9aa9820394b5bf65b69f6ac2d137 /db updates.sql | |
| parent | b6680dd405fdf6cd2784facfe799742cfaf805ab (diff) | |
| download | pathery-38d39346a3a9a49bf2c2927c8c79019b4098877b.tar.xz | |
Snap comitting his db updates
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 |