summaryrefslogtreecommitdiffstats
path: root/db updates.sql
diff options
context:
space:
mode:
authorPatrick Davison <snapwilliam@gmail.com>2013-05-28 00:01:06 -0700
committerPatrick Davison <snapwilliam@gmail.com>2013-05-28 00:01:06 -0700
commit9f2aa0767634648e4813c8e6d10fc6b8dbeff293 (patch)
tree7bedb03cf3d23ae81804c655ba613a7c40232d28 /db updates.sql
parent048138970237ac1a0784ac779bc74b73b04d49be (diff)
parent77b0bd5e51aeefb0d09e7a5bcab633657f299d22 (diff)
downloadpathery-9f2aa0767634648e4813c8e6d10fc6b8dbeff293.tar.xz
Merge branch 'HEAD' of ssh://git@git.raylu.net/pathery
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