ADD UNIQUE ... what? INDEX now. And auto-unregistration of missing filter functions...

[mailer.git] / inc / extensions / ext-user.php

diff --git a/inc/extensions/ext-user.php b/inc/extensions/ext-user.php
index a8f0afbeb3407d5a3f81820d51c0548f77ae4c5f..9405d9104654237b9b3eda4c8fdf4a952696a4f0 100644 (file)
--- a/inc/extensions/ext-user.php
+++ b/inc/extensions/ext-user.php
@@ -372,7 +372,7 @@ INDEX (`userid`)",
 
                        case '0.3.6': // SQL queries for v0.3.6
                                addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_user_cats` DROP INDEX `userid`');
-                               addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_user_cats` ADD UNIQUE `userid_catid` (`userid` , `cat_id`)');
+                               addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_user_cats` ADD UNIQUE INDEX `userid_catid` (`userid` , `cat_id`)');
 
                                // Update notes (these will be set as task text!)
                                setExtensionUpdateNotes("Der Sperrgrund wird nun mit abgespeichert und beim Löschen des Users mit ausgesendet.");
@@ -464,7 +464,7 @@ INDEX (`userid`)",
 `level` smallINT(6) UNSIGNED NOT NULL DEFAULT 0,
 `refid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 PRIMARY KEY (`id`),
-UNIQUE `user_refid` (`userid`,`level`,`refid`),
+UNIQUE INDEX `user_refid` (`userid`,`level`,`refid`),
 INDEX (`level`),
 INDEX (`refid`)",
                                        'User referals');