summaryrefslogtreecommitdiff
path: root/DB/change_db_to_v180.sql
blob: d834fd2d29de1b70d6c4f8d59b0a8e52385d12d3 (plain)
1
2
3
ALTER TABLE `User` ADD `CreateDate` DATETIME NULL AFTER `lastLogIn`;
ALTER TABLE `User` CHANGE `lastLogIn` `lastLogIn` DATETIME NOT NULL DEFAULT 'NOW()',
CHANGE `CreateDate` `CreateDate` DATETIME NOT NULL DEFAULT 'NOW()';