summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/update.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/db/update.sql b/db/update.sql
index e69de29b..93f29e89 100644
--- a/db/update.sql
+++ b/db/update.sql
@@ -0,0 +1,6 @@
+INSERT INTO `Privileges` (`id`, `name`, `desc`) VALUES (40, 'view_rooms', 'User can view rooms');
+INSERT INTO `GroupPrivileges` (`id`, `group_id`, `privilege_id`) VALUES (NULL, '-2', '40');
+
+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