From 86a72bd934c408ad558368a6b4c0fcb9cc8e7892 Mon Sep 17 00:00:00 2001
From: Philip Häusler <msquare@notrademark.de>
Date: Tue, 11 Oct 2011 23:43:44 +0200
Subject: update sql fix

---
 db/update.sql | 6 ++----
 1 file changed, 2 insertions(+), 4 deletions(-)

(limited to 'db/update.sql')

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` ,
-- 
cgit v1.2.3-70-g09d2

