From 8c518d4c3496ce9c72e4eed400923bd978b4e6a5 Mon Sep 17 00:00:00 2001
From: Philip Häusler <msquare@notrademark.de>
Date: Sun, 12 Jul 2015 14:45:58 +0200
Subject: add arrival date feature

---
 db/update.sql | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'db/update.sql')

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 ;
 
-- 
cgit v1.2.3-70-g09d2

