diff options
Diffstat (limited to 'DB')
-rwxr-xr-x | DB/Himmel.sql | 3 | ||||
-rw-r--r-- | DB/change_db_to_v180.sql | 3 |
2 files changed, 5 insertions, 1 deletions
diff --git a/DB/Himmel.sql b/DB/Himmel.sql index 265ee9b2..0fe5a6e9 100755 --- a/DB/Himmel.sql +++ b/DB/Himmel.sql @@ -195,7 +195,8 @@ CREATE TABLE IF NOT EXISTS `User` ( `color` tinyint(4) default '1', `Sprache` char(2) default 'EN', `Avatar` int(11) default '0', - `lastLogIn` datetime default NULL, + `lastLogIn` datetime NOT NULL default '0000-00-00 00:00:00', + `CreateDate` datetime NOT NULL default '0000-00-00 00:00:00', `Art` varchar(30) default NULL, `kommentar` text, PRIMARY KEY (`UID`,`Nick`), 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()'; |