From 8cc65436b7d5552af54c8d93feed85f63ad7fa4e Mon Sep 17 00:00:00 2001 From: Patrick Davison Date: Sun, 10 Mar 2013 16:57:02 -0700 Subject: Remove on update CURRENT_TIMESTAMP on dateLogin --- db updates.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/db updates.sql b/db updates.sql index 7bd16c1..2e04942 100644 --- a/db updates.sql +++ b/db updates.sql @@ -1,3 +1,6 @@ +-- Remove 'on update CURRENT_TIMESTAMP' from dateLogin +ALTER TABLE `users` CHANGE `dateLogin` `dateLogin` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP + ALTER TABLE `mapOfTheDay` DROP INDEX `UniqueTypeDate` , ADD UNIQUE `UniqueTypeDate` ( `mapDate` , `mapType` ); -- cgit v1.2.3