summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorPhilip Häusler <msquare@notrademark.de>2011-10-11 19:47:49 +0200
committerPhilip Häusler <msquare@notrademark.de>2011-10-11 19:47:49 +0200
commit304af8e8f015ac896ad0683c6407a3269e981d97 (patch)
tree32454b2c7eaa432c6cfabf3809e60d2f2d2d0d0b /db
parent1854e1455abcb23d3dc2c1ad206525227d08587d (diff)
#27 ical export, beginn
Diffstat (limited to 'db')
-rw-r--r--db/update.sql14
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