summaryrefslogtreecommitdiffstats
path: root/db updates.sql
diff options
context:
space:
mode:
authorPatrick Davison <snapwilliam@gmail.com>2013-01-15 01:22:39 -0800
committerPatrick Davison <snapwilliam@gmail.com>2013-01-15 01:22:39 -0800
commitcc579e91af8adbef5ddda979dbbe5db93a8c32ef (patch)
treee7acbf3108c0bc315ac858129c0eda62e4c0fd23 /db updates.sql
parent43067b7e18c0bd44f703a8bee8770bcdab674f20 (diff)
parent4617f928718883862000aedc6c915e9161bfb35f (diff)
downloadpathery-cc579e91af8adbef5ddda979dbbe5db93a8c32ef.tar.xz
Merge branch 'HEAD' of ssh://git@git.raylu.net/pathery
Diffstat (limited to 'db updates.sql')
-rw-r--r--db updates.sql5
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'
+