switch (getExtensionMode()) {
case 'register': // Do stuff when installation is running (modules.php?module=admin is called)
// SQL commands to run
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_optimize_gain`(
- id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
- gain decimal(10,3) NOT NULL DEFAULT '0.000',
- PRIMARY KEY (id)
+ addExtensionSql("DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_optimize_gain`");
+ addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_optimize_gain` (
+`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`gain` decimal(10,3) NOT NULL DEFAULT '0.000',
+PRIMARY KEY (`id`)
) TYPE={?_TABLE_TYPE?}");
- addAdminMenuSql('misc','optimize','DB optimieren','Führen Sie dies ab und an aus, damit überflüssige Daten aus der Datenbank entfernt werden.',5);
+ 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`");
- addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `what`='optimize'");
+ addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `what`='optimize' LIMIT 1");
break;
case 'activate': // Do stuff when admin activates this extension