diff options
author | Philip Häusler <msquare@notrademark.de> | 2015-07-12 14:45:58 +0200 |
---|---|---|
committer | Philip Häusler <msquare@notrademark.de> | 2015-07-12 14:45:58 +0200 |
commit | 8c518d4c3496ce9c72e4eed400923bd978b4e6a5 (patch) | |
tree | 6d28b53c22f9716d79398f5616a634ed2db3a08b /db/update.sql | |
parent | 66c7e67a038b24ef9788d2550da15b2209c08123 (diff) |
add arrival date feature
Diffstat (limited to 'db/update.sql')
-rw-r--r-- | db/update.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/db/update.sql b/db/update.sql index 8364e2e5..2e03c3d9 100644 --- a/db/update.sql +++ b/db/update.sql @@ -1,3 +1,9 @@ + +/* introduce user arrival date */ +ALTER TABLE `User` ADD `arrival_date` INT NULL , +ADD `planned_arrival_date` INT NOT NULL , +ADD INDEX ( `arrival_date` , `planned_arrival_date` ) ; + /* fix log */ ALTER TABLE `LogEntries` CHANGE `nick` `nick` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ; |