summaryrefslogtreecommitdiffstats
path: root/db updates.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db updates.sql')
-rw-r--r--db updates.sql6
1 files changed, 5 insertions, 1 deletions
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