diff options
| author | msquare <msquare@notrademark.de> | 2016-12-24 17:00:03 +0100 |
|---|---|---|
| committer | msquare <msquare@notrademark.de> | 2016-12-24 17:00:03 +0100 |
| commit | e86d75b4d9c2c5559ccf7e0a796c07ebb23f02ec (patch) | |
| tree | 95cba7e59deb28ced41c30860f099056a7e2f07e /db | |
| parent | 11bea2a3ce09d17ce96a8af03618e4182fe05ce6 (diff) | |
begin #298 add privilege and add users to shifts by angeltype supporter
Diffstat (limited to 'db')
| -rw-r--r-- | db/update.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/db/update.sql b/db/update.sql index f5955f32..9a665566 100644 --- a/db/update.sql +++ b/db/update.sql @@ -16,3 +16,6 @@ ALTER TABLE `AngelTypes` ADD INDEX (`contact_user_id`); ALTER TABLE `AngelTypes` ADD FOREIGN KEY (`contact_user_id`) REFERENCES `User`(`UID`) ON DELETE SET NULL ON UPDATE CASCADE; + + +INSERT INTO `Privileges` (`id`, `name`, `desc`) VALUES (NULL, 'shiftentry_edit_angeltype_supporter', 'If user with this privilege is angeltype supporter, he can put users in shifts for their angeltype'); |