diff options
| author | BlueRaja <BlueRaja.admin@gmail.com> | 2013-03-24 16:59:17 -0500 |
|---|---|---|
| committer | BlueRaja <BlueRaja.admin@gmail.com> | 2013-03-24 17:04:03 -0500 |
| commit | 5ddccd86ab09b4536b82545700281f32e71680f5 (patch) | |
| tree | 515db123e76ba9e6cbb8725c59ff9fa9d6482916 /db updates.sql | |
| parent | a9dcb92d783a77b493d865c655244bb8e5d54a41 (diff) | |
| download | pathery-5ddccd86ab09b4536b82545700281f32e71680f5.tar.xz | |
Fixes for DB before releasing to production
Diffstat (limited to 'db updates.sql')
| -rw-r--r-- | db updates.sql | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/db updates.sql b/db updates.sql index 5afd88f..739c6e3 100644 --- a/db updates.sql +++ b/db updates.sql @@ -247,6 +247,9 @@ DROP INDEX `mapID` , ADD UNIQUE `mapID` ( `mapID` , `ordering` ); -- Optimizing the daily update queries -ALTER TABLE `solutions` ADD INDEX ( `isHighScore` ) +ALTER TABLE `solutions` ADD INDEX ( `isHighScore` ); -ALTER TABLE `users` ADD `wallOrientation` TINYINT NOT NULL DEFAULT '0' AFTER `wallEmblem`
\ No newline at end of file +ALTER TABLE `users` ADD `wallOrientation` TINYINT NOT NULL DEFAULT '0' AFTER `wallEmblem`; + +ALTER TABLE `solutions` DROP INDEX `userIDmapID` , +ADD UNIQUE `mapIDuserID` ( `mapID` , `userID` );
\ No newline at end of file |