1 files changed, 14 insertions, 0 deletions
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