From 5ddccd86ab09b4536b82545700281f32e71680f5 Mon Sep 17 00:00:00 2001 From: BlueRaja Date: Sun, 24 Mar 2013 16:59:17 -0500 Subject: Fixes for DB before releasing to production --- db updates.sql | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) (limited to 'db updates.sql') 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 -- cgit v1.2.3