From deac80e700d69a56992fec70997a9d54716bdafa Mon Sep 17 00:00:00 2001
From: msquare <msquare@notrademark.de>
Date: Tue, 13 Dec 2016 17:58:41 +0100
Subject: merge #253

---
 db/update.sql | 11 ++++++++++-
 1 file changed, 10 insertions(+), 1 deletion(-)

(limited to 'db/update.sql')

diff --git a/db/update.sql b/db/update.sql
index 5682f1ee..3e455e86 100644
--- a/db/update.sql
+++ b/db/update.sql
@@ -6,4 +6,13 @@ ALTER TABLE `UserAngelTypes` CHANGE `coordinator` `supporter` BOOLEAN;
 ALTER TABLE `User` ADD COLUMN `email_by_human_allowed` BOOLEAN NOT NULL;
 
 -- No Self Sign Up for some Angel Types
-ALTER TABLE engelsystem.AngelTypes ADD no_self_signup TINYINT(1) NOT NULL;
\ No newline at end of file
+ALTER TABLE engelsystem.AngelTypes ADD no_self_signup TINYINT(1) NOT NULL;
+
+ALTER TABLE `AngelTypes`  
+  ADD `contact_user_id` INT NULL,  
+  ADD `contact_name` VARCHAR(250) NULL,  
+  ADD `contact_dect` VARCHAR(5) NULL,  
+  ADD `contact_email` VARCHAR(250) NULL,  
+  ADD INDEX  (`contact_user_id`);
+ALTER TABLE `AngelTypes` 
+  ADD  FOREIGN KEY (`contact_user_id`) REFERENCES `User`(`UID`) ON DELETE SET NULL ON UPDATE CASCADE;
-- 
cgit v1.2.3-54-g00ecf

