diff options
| author | cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8> | 2006-11-28 10:09:05 +0000 |
|---|---|---|
| committer | cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8> | 2006-11-28 10:09:05 +0000 |
| commit | f8fbc9c0cf182963e92a176dd84c569b00ab42f5 (patch) | |
| tree | 623f6c6abea9c077f3eb3642ea823e7795c59e06 /DB/change_db_to_v180.sql | |
| parent | 705d511183d976e77db7772f60c7809403a21b49 (diff) | |
UserCreateDate wird abgelegt und angezeigt
git-svn-id: svn://svn.cccv.de/engel-system@180 29ba0400-6e00-0410-a75a-ca02368028f8
Diffstat (limited to 'DB/change_db_to_v180.sql')
| -rw-r--r-- | DB/change_db_to_v180.sql | 3 |
1 files changed, 3 insertions, 0 deletions
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()'; |