diff options
| author | BlueRaja <BlueRaja.admin@gmail.com> | 2013-01-15 01:06:04 -0600 |
|---|---|---|
| committer | BlueRaja <BlueRaja.admin@gmail.com> | 2013-01-15 01:06:04 -0600 |
| commit | 4617f928718883862000aedc6c915e9161bfb35f (patch) | |
| tree | 97f7cf0128f73ed6be32a799d8f3a3ae20b1815c /db updates.sql | |
| parent | a6dd38b8debc789769fffd5c053d04bc888dcbbb (diff) | |
| download | pathery-4617f928718883862000aedc6c915e9161bfb35f.tar.xz | |
Adding a file containing all database changes made (since copying Snap's DB)
Diffstat (limited to 'db updates.sql')
| -rw-r--r-- | db updates.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/db updates.sql b/db updates.sql new file mode 100644 index 0000000..e038771 --- /dev/null +++ b/db updates.sql @@ -0,0 +1,5 @@ +ALTER TABLE `db428221563`.`mapOfTheDay` DROP INDEX `UniqueTypeDate` , +ADD UNIQUE `UniqueTypeDate` ( `mapDate` , `mapType` ) + +ALTER TABLE `mapOfTheDay` ADD `championPointsWorth` INT NOT NULL DEFAULT '0' + |