Next batch of fixed language ids (renamed, see ticket #219)

[mailer.git] / inc / fix_filters.php

diff --git a/inc/fix_filters.php b/inc/fix_filters.php
index 547616edd52f9dac40c8988c0f3618538749ab35..d3d0b82354910ae325a679364d9225955da5ff4a 100644 (file)
--- a/inc/fix_filters.php
+++ b/inc/fix_filters.php
@@ -42,11 +42,13 @@ if (!defined('__SECURITY')) {
 
 // Get all filters
 $result = SQL_QUERY('SELECT
-       `filter_name`,`filter_function`
+       `filter_name`,
+       `filter_function`
 FROM
        `{?_MYSQL_PREFIX?}_filters`
 ORDER BY
-       `filter_name` ASC, `filter_function` ASC', __FILE__, __LINE__);
+       `filter_name` ASC,
+       `filter_function` ASC', __FILE__, __LINE__);
 
 // Do we have entries? (we should have!)
 if (!SQL_HASZERONUMS($result)) {
@@ -72,7 +74,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]
 ?>