From cac86ef509de8543d473db421898b80ca3b8f8e3 Mon Sep 17 00:00:00 2001
From: Philip Häusler <msquare@notrademark.de>
Date: Sat, 15 Aug 2015 14:54:25 +0200
Subject: add planned date of departure

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

(limited to 'db')

diff --git a/db/update.sql b/db/update.sql
index 4ae7d295..594969f9 100644
--- a/db/update.sql
+++ b/db/update.sql
@@ -1,3 +1,6 @@
+/* Introduce planned departure date */
+ALTER TABLE `User` ADD `planned_departure_date` INT NULL, ADD INDEX ( `planned_departure_date` );
+
 /* Allow longer angeltype names */
 ALTER TABLE `AngelTypes` CHANGE `name` `name` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
 
-- 
cgit v1.2.3-54-g00ecf