summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorPhilip Häusler <msquare@notrademark.de>2011-10-11 23:43:44 +0200
committerPhilip Häusler <msquare@notrademark.de>2011-10-11 23:43:44 +0200
commit86a72bd934c408ad558368a6b4c0fcb9cc8e7892 (patch)
tree9ebcc29f6c459ee1d57104d4f60fef668fdd803f /db
parenta06ffd2e49320c9602993394e5ff2ab5be2a68d6 (diff)
update sql fix
Diffstat (limited to 'db')
-rw-r--r--db/update.sql6
1 files changed, 2 insertions, 4 deletions
diff --git a/db/update.sql b/db/update.sql
index c2ebf441..dc254a02 100644
--- a/db/update.sql
+++ b/db/update.sql
@@ -1,8 +1,6 @@
/* Update für #27, iCal-Export */
-ALTER TABLE `User` ADD `ical_key` VARCHAR( 32 ) NOT NULL ,
-ADD UNIQUE (
-`ical_key`
-);
+ALTER TABLE `User` ADD `ical_key` VARCHAR( 32 ) NOT NULL;
+ALTER TABLE `User` ADD INDEX ( `ical_key` )
INSERT INTO `engelsystem`.`Privileges` (
`id` ,