X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-optimize.php;h=578a990b8cfe506d80dee2c70bcb368f6b5c21a2;hb=6c756fd5938d311b7d8b63b17cd12cadf166505b;hp=dc434dfbf9fd3360a8bd2b1d2f78ea97c42aa387;hpb=6f8a68c6c5ed9eeae1bf790f5d758c800b5d5d5d;p=mailer.git diff --git a/inc/extensions/ext-optimize.php b/inc/extensions/ext-optimize.php index dc434dfbf9..578a990b8c 100644 --- a/inc/extensions/ext-optimize.php +++ b/inc/extensions/ext-optimize.php @@ -43,21 +43,21 @@ 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 addDropTableSql('optimize_gain'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_optimize_gain` ( + addCreateTableSql('optimize_gain', " `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, -`gain` decimal(10,3) NOT NULL DEFAULT '0.000', -PRIMARY KEY (`id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Optimization history data'"); +`gain` DECIMAL(10,3) NOT NULL DEFAULT 0.000, +PRIMARY KEY (`id`)", + '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;