diff options
| author | Patrick Davison <snapwilliam@gmail.com> | 2013-03-10 16:57:02 -0700 |
|---|---|---|
| committer | Patrick Davison <snapwilliam@gmail.com> | 2013-03-10 16:57:02 -0700 |
| commit | 8cc65436b7d5552af54c8d93feed85f63ad7fa4e (patch) | |
| tree | 5c1fd1ceaf3977b58248a76cd8077c2a93887de2 | |
| parent | 0de9fd4ce81392508ce9648e2ae279912d7f9ed5 (diff) | |
| download | pathery-8cc65436b7d5552af54c8d93feed85f63ad7fa4e.tar.xz | |
Remove on update CURRENT_TIMESTAMP on dateLogin
| -rw-r--r-- | db updates.sql | 3 |
1 files changed, 3 insertions, 0 deletions
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` ); |