diff options
| author | Philip Häusler <msquare@notrademark.de> | 2014-05-13 15:51:45 +0200 |
|---|---|---|
| committer | Philip Häusler <msquare@notrademark.de> | 2014-05-13 15:51:45 +0200 |
| commit | f1145b8a5e8630e0180d35ff1ced2e934b872f01 (patch) | |
| tree | c99e7b7a5f6e1ab3839777dbd8095f83a1c94f20 /db/update.sql | |
| parent | e107dff1ce417df779733667ad81d60755582779 (diff) | |
implemented team/angeltype coordinators
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` ); |