summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorPhilip Häusler <msquare@notrademark.de>2014-12-16 09:25:36 +0100
committerPhilip Häusler <msquare@notrademark.de>2014-12-17 14:59:41 +0100
commitc8cc46886b4a163f9408df80c3bfbdcfa4ae2f7b (patch)
tree109544b122e6a2032a413633b78e5a40baa422e5 /db
parenta73e98a8e069074fe439d8d54c93fd35c46ace8e (diff)
shift type list
Diffstat (limited to 'db')
-rw-r--r--db/update.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/db/update.sql b/db/update.sql
index d7d91a80..8c9bdaec 100644
--- a/db/update.sql
+++ b/db/update.sql
@@ -5,7 +5,9 @@ CREATE TABLE IF NOT EXISTS `ShiftTypes` (
`angeltype_id` int(11) DEFAULT NULL,
`description` text NOT NULL,
PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
+INSERT INTO `engelsystem`.`Privileges` (`id`, `name`, `desc`) VALUES (NULL , 'shifttypes', 'Administrate shift types');
+INSERT INTO `GroupPrivileges` SET `group_id`=-5, `privilege_id`=(SELECT `id` FROM `Privileges` WHERE `name`='shifttypes');
/* cleanup */
ALTER TABLE `User` DROP `ICQ` ;