From 38d39346a3a9a49bf2c2927c8c79019b4098877b Mon Sep 17 00:00:00 2001 From: BlueRaja Date: Wed, 20 Mar 2013 02:02:38 -0500 Subject: Snap comitting his db updates --- db updates.sql | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) 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 -- cgit v1.2.3