From f8fbc9c0cf182963e92a176dd84c569b00ab42f5 Mon Sep 17 00:00:00 2001
From: cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8>
Date: Tue, 28 Nov 2006 10:09:05 +0000
Subject: UserCreateDate wird abgelegt und angezeigt

git-svn-id: svn://svn.cccv.de/engel-system@180 29ba0400-6e00-0410-a75a-ca02368028f8
---
 DB/Himmel.sql            | 3 ++-
 DB/change_db_to_v180.sql | 3 +++
 2 files changed, 5 insertions(+), 1 deletion(-)
 create mode 100644 DB/change_db_to_v180.sql

(limited to 'DB')

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()';
-- 
cgit v1.2.3-54-g00ecf