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

diff --git a/inc/extensions/ext-sql_patches.php b/inc/extensions/ext-sql_patches.php
index d9f1abbb6b..2c2ce2db01 100644
--- a/inc/extensions/ext-sql_patches.php
+++ b/inc/extensions/ext-sql_patches.php
@@ -116,7 +116,7 @@ switch (getExtensionMode()) {
 				break;
 
 			case '0.0.2': // SQL queries for v0.0.2
-				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` CHANGE `auto_purge` `auto_purge` BIGINT(20) UNSIGNED NOT NULL DEFAULT ".(getOneDay()*14)."");
+				addConfigChangeSql('auto_purge', 'auto_purge', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT ' . (getOneDay()*14));
 
 				// Update notes (these will be set as task text!)
 				setExtensionUpdateNotes("In der Tabelle <strong>{?_MYSQL_PREFIX?}_config</strong> musste die Spalte <strong>auto_purge</strong> (autom. L&ouml;schen von Best&auml;tigungsmails angepasst werden (war auf dem Testsystem auf TINYINT(4) gesetzt.)");
@@ -671,7 +671,7 @@ PRIMARY KEY (`filter_id`)
 				break;
 
 			case '0.6.5': // SQL queries for v0.6.5
-				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` CHANGE `css_php` `css_php` ENUM('DIRECT','FILE','INLINE') NOT NULL DEFAULT 'FILE'");
+				addConfigChangeSql('css_php', 'css_php', "ENUM('DIRECT','FILE','INLINE') NOT NULL DEFAULT 'FILE'");
 
 				// Update notes (these will be set as task text!)
 				setExtensionUpdateNotes("Ausgabe der CSS-Dateien entweder per css.php oder sie sind direkt eingebunden.");
@@ -687,7 +687,8 @@ PRIMARY KEY (`filter_id`)
 				break;
 
 			case '0.6.7': // SQL queries for v0.6.7
-				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` CHANGE `index_delay` `index_delay` TINYINT(3) NOT NULL DEFAULT 0");
+				addConfigChangeSql('index_delay', 'index_delay', 'TINYINT(3) NOT NULL DEFAULT 0');
+
 				// Update notes (these will be set as task text!)
 				setExtensionUpdateNotes("Die Weiterleitungseinstellung muss auch Werte kleiner Null akzeptieren.");
 				break;
@@ -724,7 +725,7 @@ INDEX (`ip`)
 ) ENGINE = {?_TABLE_TYPE?}");
 
 				// Configuration
-				addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `dns_cache_timeout` BIGINT(20) NOT NULL DEFAULT ' . (60*60*24));
+				addConfigAddSql('dns_cache_timeout', 'BIGINT(20) NOT NULL DEFAULT ' . (60*60*24));
 
 				// Register filter
 				registerFilter('reset', 'CLEANUP_DNS_CACHE', false, true, isExtensionDryRun());
@@ -771,8 +772,8 @@ INDEX (`ip`)
 				break;
 
 			case '0.7.6': // SQL queries for v0.7.6
-				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` CHANGE `last_month` `last_month` TINYINT(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00");
-				addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` CHANGE `last_week` `last_week` TINYINT(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00");
+				addConfigChangeSql('last_month', 'last_month', 'TINYINT(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00');
+				addConfigChangeSql('last_week', 'last_week', 'TINYINT(2) UNSIGNED ZEROFILL NOT NULL DEFAULT 00');
 
 				// Update notes (these will be set as task text!)
 				setExtensionUpdateNotes("Spaltentyp fuer kleine Zahlen sollten auch z.B. TINYINT sein.");