diff options
| author | BlueRaja <BlueRaja.admin@gmail.com> | 2013-05-27 22:32:26 -0500 |
|---|---|---|
| committer | BlueRaja <BlueRaja.admin@gmail.com> | 2013-05-27 22:32:26 -0500 |
| commit | cc1d8051f5eb7a53cbf9e11773f23e650ce88c5d (patch) | |
| tree | 7e23df7112697d3e03d271029ca986ef2dc913b3 | |
| parent | cb825735697c8315049c747ea80ff3ad84194593 (diff) | |
| download | pathery-cc1d8051f5eb7a53cbf9e11773f23e650ce88c5d.tar.xz | |
Added index to increase speed of stats updating
| -rw-r--r-- | db updates.sql | 6 |
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 |