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/change_db_to_v180.sql | 3 +++
 1 file changed, 3 insertions(+)
 create mode 100644 DB/change_db_to_v180.sql

(limited to 'DB/change_db_to_v180.sql')

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

