X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-sql_patches.php;h=d9f1abbb6b4994f2364c98758178c41d5d055303;hp=1549db5e50e4b9098d07613efa1c357a91f02531;hb=be39a7fb887473487fd2c5f8d550aa03b720cb73;hpb=6f8a68c6c5ed9eeae1bf790f5d758c800b5d5d5d;ds=sidebyside

diff --git a/inc/extensions/ext-sql_patches.php b/inc/extensions/ext-sql_patches.php
index 1549db5e50..d9f1abbb6b 100644
--- 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,