// 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;