X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-optimize.php;h=5ee15e39ba2d5e9e8a05b17c68b977fd66266e12;hb=adb05fb6876bdca84e73f4ea04998c1400e2cfb7;hp=16aedbed5c0df27b23bf3624b56764c7735bf00a;hpb=9725980ca9c052e5c1a9edb8b815e8506b876448;p=mailer.git

diff --git a/inc/extensions/ext-optimize.php b/inc/extensions/ext-optimize.php
index 16aedbed5c..5ee15e39ba 100644
--- a/inc/extensions/ext-optimize.php
+++ b/inc/extensions/ext-optimize.php
@@ -43,27 +43,27 @@ if (!defined('__SECURITY')) {
 // Version number
 setThisExtensionVersion('0.0.6');
 
-// Version history array (add more with , '0.1.0' and so on)
-setExtensionVersionHistory(array('0.0', '0.0.1', '0.0.2', '0.0.3', '0.0.4', '0.0.5', '0.0.6'));
+// Version history array (add more with , '0.0.1' and so on)
+setExtensionVersionHistory(array('0.0.0', '0.0.1', '0.0.2', '0.0.3', '0.0.4', '0.0.5', '0.0.6'));
 
 // Keep this extension always active!
 setExtensionAlwaysActive('Y');
 
 switch (getExtensionMode()) {
-	case 'register': // Do stuff when installation is running (modules.php?module=admin is called)
+	case 'register': // Do stuff when installation is running
 		// SQL commands to run
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_optimize_gain`');
-		addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_optimize_gain` (
+		addDropTableSql('optimize_gain');
+		addCreateTableSql('optimize_gain', "(
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-`gain` decimal(10,3) NOT NULL DEFAULT '0.000',
+`gain` DECIMAL(10,3) NOT NULL DEFAULT 0.000,
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Optimization history data'");
 		addAdminMenuSql('misc', 'optimize', 'DB optimieren', 'Führen Sie dies ab und an aus, damit überflüssige Binärdaten aus der Datenbank entfernt werden.', 5);
 		break;
 
 	case 'remove': // Do stuff when removing extension
 		// SQL commands to run
-		addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_optimize_gain`');
+		addDropTableSql('optimize_gain');
 		addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `what`='optimize' LIMIT 1");
 		break;