From 304af8e8f015ac896ad0683c6407a3269e981d97 Mon Sep 17 00:00:00 2001 From: Philip Häusler Date: Tue, 11 Oct 2011 19:47:49 +0200 Subject: #27 ical export, beginn --- db/update.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 db/update.sql (limited to 'db') diff --git a/db/update.sql b/db/update.sql new file mode 100644 index 00000000..c2ebf441 --- /dev/null +++ b/db/update.sql @@ -0,0 +1,14 @@ +/* Update für #27, iCal-Export */ +ALTER TABLE `User` ADD `ical_key` VARCHAR( 32 ) NOT NULL , +ADD UNIQUE ( +`ical_key` +); + +INSERT INTO `engelsystem`.`Privileges` ( +`id` , +`name` , +`desc` +) +VALUES ( +NULL , 'ical', 'iCal Schicht Export' +); \ No newline at end of file -- cgit v1.2.3-54-g00ecf