diff options
Diffstat (limited to 'db updates.sql')
| -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` ); |