diff options
| author | BlueRaja <BlueRaja.admin@gmail.com> | 2013-01-15 22:36:27 -0600 |
|---|---|---|
| committer | BlueRaja <BlueRaja.admin@gmail.com> | 2013-01-15 22:36:27 -0600 |
| commit | 3990b65956331263b0963f695ddc88b4c3356af0 (patch) | |
| tree | 5a6c3c84f201c054437f056c6b13372becea260f /db updates.sql | |
| parent | c7d671712a9d5f90752475960c3a602aeb0da8d0 (diff) | |
| download | pathery-3990b65956331263b0963f695ddc88b4c3356af0.tar.xz | |
Added totalMoves and totalMazes to users; and isTiedForHighScore to solutions (for convenience)
Diffstat (limited to 'db updates.sql')
| -rw-r--r-- | db updates.sql | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/db updates.sql b/db updates.sql index e038771..b8b63a2 100644 --- a/db updates.sql +++ b/db updates.sql @@ -1,5 +1,9 @@ ALTER TABLE `db428221563`.`mapOfTheDay` DROP INDEX `UniqueTypeDate` , -ADD UNIQUE `UniqueTypeDate` ( `mapDate` , `mapType` ) +ADD UNIQUE `UniqueTypeDate` ( `mapDate` , `mapType` ); -ALTER TABLE `mapOfTheDay` ADD `championPointsWorth` INT NOT NULL DEFAULT '0' +ALTER TABLE `mapOfTheDay` ADD `championPointsWorth` INT NOT NULL DEFAULT '0'; +ALTER TABLE `users` ADD `totalMazes` INT NOT NULL DEFAULT '0', +ADD `totalMoves` INT NOT NULL DEFAULT '0'; + +ALTER TABLE `solutions` ADD `isTiedForHighScore` BOOLEAN NOT NULL DEFAULT '0';
\ No newline at end of file |