Introduced wrapper function addCreateTableSql(), fixed parameter order:

[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 1549db5e50e4b9098d07613efa1c357a91f02531..d9f1abbb6b4994f2364c98758178c41d5d055303 100644 (file)
--- a/inc/extensions/ext-sql_patches.php
+++ b/inc/extensions/ext-sql_patches.php
@@ -197,7 +197,7 @@ switch (getExtensionMode()) {
                                break;
 
                        case '0.1.3': // SQL queries for v0.1.3
-                               addConfigAddSql("refid_target ENUM('register','index') NOT NULL DEFAULT 'register'");
+                               addConfigAddSql('refid_target', "ENUM('register','index') NOT NULL DEFAULT 'register'");
 
                                // Update notes (these will be set as task text!)
                                setExtensionUpdateNotes("Auf welche Seite soll der Ref-Link zeigen? Eingangsseite oder Anmeldeformular?");
@@ -369,7 +369,7 @@ switch (getExtensionMode()) {
                        case '0.3.2': // SQL queries for v0.3.2
                                // Connection table between the menu system and the "logical area system"
                                addDropTableSql('admin_menu_las');
-                               addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_admin_menu_las` (
+                               addCreateTableSql('admin_menu_las', "(
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `la_id` VARCHAR(255) NOT NULL DEFAULT '',
 `la_action` VARCHAR(255) NOT NULL DEFAULT '',
@@ -381,7 +381,7 @@ PRIMARY KEY (`id`)
 ) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Menu system -> LAS'");
                                // All "logical areas" together
                                addDropTableSql('admin_menu_las_data');
-                               addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_admin_menu_las_data` (
+                               addCreateTableSql('admin_menu_las_data', "(
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `la_id` VARCHAR(255) NOT NULL DEFAULT '',
 `la_title` VARCHAR(255) NOT NULL DEFAULT '',
@@ -408,7 +408,7 @@ PRIMARY KEY (`id`)
 
                                // The statistics table
                                addDropTableSql('admin_las_stats');
-                               addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_admin_las_stats` (
+                               addCreateTableSql('admin_las_stats', "(
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `admin_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `type` ENUM('la','action','what') NOT NULL DEFAULT 'what',
@@ -616,7 +616,7 @@ PRIMARY KEY (`id`)
 
                        case '0.5.9': // SQL queries for v0.5.9
                                addDropTableSql('filters');
-                               addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_filters` (
+                               addCreateTableSql('filters', "(
 `filter_id` BIGINT(20) UNSIGNED AUTO_INCREMENT,
 `filter_name` VARCHAR(50) NOT NULL DEFAULT '',
 `filter_function` VARCHAR(100) NOT NULL DEFAULT '',
@@ -715,7 +715,7 @@ PRIMARY KEY (`filter_id`)
                        case '0.7.0': // SQL queries for 0.7.0
                                // Table definition
                                addDropTableSql('dns_cache');
-                               addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_dns_cache` (
+                               addCreateTableSql('dns_cache', "(
 `hostname` VARCHAR(255) NOT NULL,
 `ip` VARCHAR(15) NOT NULL,
 `added` DATETIME NOT NULL,