1 files changed, 17 insertions, 0 deletions
diff --git a/db updates.sql b/db updates.sql
index 50b6a97..efc21ce 100644
--- a/db updates.sql
+++ b/db updates.sql
@@ -15,3 +15,20 @@ ADD  `totalTies` INT DEFAULT  '0' NOT NULL ;
 
 ALTER TABLE  `solutions` ADD  `championPointsWorth` INT DEFAULT  '0' NOT NULL ,
 ADD  `isHighScore` TINYINT( 1 ) NOT NULL ;
+
+ALTER TABLE `solutions` ADD `isTiedForHighScore` BOOLEAN NOT NULL DEFAULT '0';
+
+-- Add the 'mapExpireTime' column
+ALTER TABLE `mapOfTheDay` ADD `mapExpireTime` DATETIME NULL DEFAULT NULL AFTER `mapDate`;
+
+UPDATE mapOfTheDay
+SET mapExpireTime = DATE_ADD(mapDate, INTERVAL 1 DAY)
+WHERE mapType <> 5;
+
+UPDATE mapOfTheDay
+SET mapExpireTime = DATE_ADD(mapDate, INTERVAL 2 DAY)
+WHERE mapType = 5;
+
+ALTER TABLE `mapOfTheDay` CHANGE `mapExpireTime` `mapExpireTime` DATETIME NOT NULL;
+
+ALTER TABLE `mapOfTheDay` ADD INDEX ( `mapExpireTime` , `mapType` );
+\ No newline at end of file