diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/update.sql | 11 |
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; |