From 4617f928718883862000aedc6c915e9161bfb35f Mon Sep 17 00:00:00 2001 From: BlueRaja Date: Tue, 15 Jan 2013 01:06:04 -0600 Subject: Adding a file containing all database changes made (since copying Snap's DB) --- db updates.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 db updates.sql (limited to 'db updates.sql') 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' + -- cgit v1.2.3