From 79b9f9448e4f3ad7abb8d795c1404b3221c95bf9 Mon Sep 17 00:00:00 2001
From: jwacalex <aboehm@dompfaffenweg.de>
Date: Thu, 17 Nov 2016 23:14:39 +0100
Subject: initial commit and functionality for no self sign up

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

(limited to 'db/update.sql')

diff --git a/db/update.sql b/db/update.sql
index 93f29e89..5682f1ee 100644
--- a/db/update.sql
+++ b/db/update.sql
@@ -3,4 +3,7 @@ INSERT INTO `GroupPrivileges` (`id`, `group_id`, `privilege_id`) VALUES (NULL, '
 
 ALTER TABLE `UserAngelTypes` CHANGE `coordinator` `supporter` BOOLEAN;
 
-ALTER TABLE `User` ADD COLUMN `email_by_human_allowed` BOOLEAN NOT NULL;
\ No newline at end of file
+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
-- 
cgit v1.2.3-54-g00ecf

