From 8cc65436b7d5552af54c8d93feed85f63ad7fa4e Mon Sep 17 00:00:00 2001
From: Patrick Davison <snapwilliam@gmail.com>
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(+)

(limited to 'db updates.sql')

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

