diff options
| -rw-r--r-- | db updates.sql | 16 |
1 files changed, 5 insertions, 11 deletions
diff --git a/db updates.sql b/db updates.sql index 26495b3..e3eea2c 100644 --- a/db updates.sql +++ b/db updates.sql @@ -1,13 +1,4 @@ --- db updates reset after patch on March 24th. - --- Dialog to challenges: -ALTER TABLE `challenges` ADD `dialogStart` VARCHAR( 200 ) DEFAULT NULL , -ADD `dialogFail` VARCHAR( 200 ) DEFAULT NULL , -ADD `dialogSuccess` VARCHAR( 200 ) DEFAULT NULL ; - --- Add index necessary for stats updates -ALTER TABLE `bluePathery`.`solutions` -ADD INDEX `mapIDMoves` ( `mapID` , `moves` ); +-- Updates required after 05-28-13: -- Remove unnecessary table DROP TABLE `guestSolutions`; @@ -57,4 +48,7 @@ ALTER TABLE `unlocks` ADD FOREIGN KEY ( `userID` ) REFERENCES `users` (`ID`) ON ALTER TABLE `userData` ENGINE = InnoDB; -- Looks like this was forgotten? ALTER TABLE `userData` ADD FOREIGN KEY ( `userID` ) REFERENCES `users` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE; --- END ADD FOREIGN KEY CONSTRAINTS
\ No newline at end of file +-- END ADD FOREIGN KEY CONSTRAINTS + +-- This table is depreciated too: +DROP TABLE userData; |