diff options
Diffstat (limited to 'DB/change_db_to_v180.sql')
| -rw-r--r-- | DB/change_db_to_v180.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/DB/change_db_to_v180.sql b/DB/change_db_to_v180.sql new file mode 100644 index 00000000..d834fd2d --- /dev/null +++ b/DB/change_db_to_v180.sql @@ -0,0 +1,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()'; |