ADD UNIQUE ... what? INDEX now. And auto-unregistration of missing filter functions...
[mailer.git] / inc / fix_filters.php
index 547616edd52f9dac40c8988c0f3618538749ab35..b7dc7a9f400394bd40a0b0596d141e6e685d115e 100644 (file)
@@ -72,7 +72,7 @@ SQL_FREERESULT($result);
 
 // Now insert our unqiue key
 addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_filters` DROP KEY `name_function`');
-addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_filters` ADD UNIQUE `name_function` (`filter_name` , `filter_function`)');
+addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_filters` ADD UNIQUE INDEX `name_function` (`filter_name` , `filter_function`)');
 
 // [EOF]
 ?>