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 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'DB/Himmel.sql')

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`),
-- 
cgit v1.2.3-54-g00ecf