From cc1d8051f5eb7a53cbf9e11773f23e650ce88c5d Mon Sep 17 00:00:00 2001 From: BlueRaja 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(-) 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