From 38d39346a3a9a49bf2c2927c8c79019b4098877b Mon Sep 17 00:00:00 2001
From: BlueRaja <BlueRaja.admin@gmail.com>
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(-)

(limited to 'db updates.sql')

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

