From c8cc46886b4a163f9408df80c3bfbdcfa4ae2f7b Mon Sep 17 00:00:00 2001
From: Philip Häusler <msquare@notrademark.de>
Date: Tue, 16 Dec 2014 09:25:36 +0100
Subject: shift type list

---
 db/update.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'db/update.sql')

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` ;
-- 
cgit v1.2.3-54-g00ecf

