Final fixes?

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

diff --git a/inc/extensions/ext-sql_patches.php b/inc/extensions/ext-sql_patches.php
index 8cc9bbc63ab938270762d7a0e3090a7317faf901..756e873e5b1c1c5fdaa15cf7f43c8447dd705b61 100644 (file)
--- a/inc/extensions/ext-sql_patches.php
+++ b/inc/extensions/ext-sql_patches.php
@@ -73,7 +73,6 @@ IN (
        'list_unconfirmed',
        'config_refid',
        'config_title',
-       'sub_points',
        'config_admin',
        'config_proxy',
        'config_session',
@@ -298,10 +297,8 @@ IN (
                                break;
 
                        case '0.2.6': // SQL queries for v0.2.6
-                               addAdminMenuSql('user','sub_points','{OPEN_CONFIG}POINTS{CLOSE_CONFIG} abziehen','Allen oder einem Mitglied {OPEN_CONFIG}POINTS{CLOSE_CONFIG} abziehen.', 8);
-
                                // Update notes (these will be set as task text!)
-                               setExtensionUpdateNotes("Abzug von {?POINTS?} nun möglich.");
+                               setExtensionUpdateNotes("Verschoben nach <strong>ext-user</strong>.");
                                break;
 
                        case '0.2.7': // SQL queries for v0.2.7
@@ -338,13 +335,13 @@ IN (
                                break;
 
                        case '0.3.1': // SQL queries for v0.3.1
-                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_extensions` ADD UNIQUE KEY `ext_name` (`ext_name`)");
-                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_admins` ADD UNIQUE KEY `login` (`login`)");
+                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_extensions` ADD UNIQUE `ext_name` (`ext_name`)");
+                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_admins` ADD UNIQUE `login` (`login`)");
                                addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_refbanner` ADD INDEX `visible` (`visible`)");
-                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_refdepths` ADD UNIQUE KEY `level` (`level`)");
+                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_refdepths` ADD UNIQUE `level` (`level`)");
                                addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_refsystem` ADD INDEX `level` (`level`)");
                                addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_pool` ADD INDEX `data_type` (`data_type`)");
-                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_mod_reg` ADD UNIQUE KEY `module` (`module`)");
+                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_mod_reg` ADD UNIQUE `module` (`module`)");
                                addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_admin_menu` ADD INDEX `action` (`action`)");
                                addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_admin_menu` ADD INDEX `what` (`what`)");
                                addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_task_system` ADD INDEX `task_type` (`task_type`)");
@@ -366,7 +363,7 @@ IN (
                                addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_cats` ADD INDEX `sort` (`sort`)");
 
                                // Update notes (these will be set as task text!)
-                               setExtensionUpdateNotes("Eindeutige Schl&uuml;ssel (UNIQUE KEY) und normale Schl&uuml;ssel (INDEX) gesetzt.");
+                               setExtensionUpdateNotes("Eindeutige Schl&uuml;ssel (UNIQUE) und normale Schl&uuml;ssel (INDEX) gesetzt.");
                                break;
 
                        case '0.3.2': // SQL queries for v0.3.2
@@ -392,7 +389,7 @@ INDEX (`la_what`)",
 `la_posx` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `la_posy` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 PRIMARY KEY (`id`),
-UNIQUE KEY (`la_id`),
+UNIQUE (`la_id`),
 INDEX (`la_posx`),
 INDEX (`la_posy`)",
                                        'LAS position and title data');