UserCreateDate wird abgelegt und angezeigt

git-svn-id: svn://svn.cccv.de/engel-system@180 29ba0400-6e00-0410-a75a-ca02368028f8

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()';