summaryrefslogtreecommitdiff
path: root/db/update.sql
diff options
context:
space:
mode:
authormsquare <msquare@notrademark.de>2016-12-13 17:58:41 +0100
committermsquare <msquare@notrademark.de>2016-12-13 17:58:41 +0100
commitdeac80e700d69a56992fec70997a9d54716bdafa (patch)
tree47cf3f58b6158667a6b5af35b4eba5559dae9232 /db/update.sql
parente7767af4c1551dacbeb1ef22ab193e334826c81e (diff)
merge #253
Diffstat (limited to 'db/update.sql')
-rw-r--r--db/update.sql11
1 files changed, 10 insertions, 1 deletions
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;