diff options
Diffstat (limited to 'db/update.sql')
| -rw-r--r-- | db/update.sql | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/db/update.sql b/db/update.sql index 0d706835..9457559a 100644 --- a/db/update.sql +++ b/db/update.sql @@ -1,5 +1,9 @@ +/* teamcoordinators */ +ALTER TABLE `UserAngelTypes` ADD `coordinator` BOOLEAN NOT NULL; +ALTER TABLE `UserAngelTypes` ADD INDEX ( `coordinator` ); + /* angeltype view */ -INSERT INTO `engelsystem`.`Privileges` (`id`, `name`, `desc`) VALUES (NULL , 'angeltypes', 'View angeltypes'); +INSERT INTO `Privileges` (`id`, `name`, `desc`) VALUES (NULL , 'angeltypes', 'View angeltypes'); /* force active */ ALTER TABLE `User` ADD `force_active` BOOLEAN NOT NULL AFTER `Aktiv`, ADD INDEX ( `force_active` ); |