From cc1d8051f5eb7a53cbf9e11773f23e650ce88c5d Mon Sep 17 00:00:00 2001
From: BlueRaja <BlueRaja.admin@gmail.com>
Date: Mon, 27 May 2013 22:32:26 -0500
Subject: Added index to increase speed of stats updating

---
 db updates.sql | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

(limited to 'db updates.sql')

diff --git a/db updates.sql b/db updates.sql
index d248ef2..9a20ade 100644
--- a/db updates.sql	
+++ b/db updates.sql	
@@ -3,4 +3,8 @@
 --Dialog to challenges:
 ALTER TABLE  `challenges` ADD  `dialogStart` VARCHAR( 200 ) DEFAULT NULL ,
 ADD  `dialogFail` VARCHAR( 200 ) DEFAULT NULL ,
-ADD  `dialogSuccess` VARCHAR( 200 ) DEFAULT NULL ;
\ No newline at end of file
+ADD  `dialogSuccess` VARCHAR( 200 ) DEFAULT NULL ;
+
+-- Add index necessary for stats updates
+ALTER TABLE `bluePathery`.`solutions`
+ADD INDEX `mapIDMoves` ( `mapID` , `moves` ) 
\ No newline at end of file
-- 
cgit v1.2.3

