X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-optimize.php;h=478fa601664d55840596b92588380a45a8170ff2;hb=66ef19610daf4eff3fb395b4908d44d5c9a96b00;hp=34b68946ff0cd632c294c08f260c0fbabfaf38e1;hpb=64c8349613addc3da2242c5cd6b99d64e3fb5f8e;p=mailer.git

diff --git a/inc/extensions/ext-optimize.php b/inc/extensions/ext-optimize.php
index 34b68946ff..478fa60166 100644
--- a/inc/extensions/ext-optimize.php
+++ b/inc/extensions/ext-optimize.php
@@ -53,18 +53,19 @@ setExtensionAlwaysActive('Y');
 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?}");
-		addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('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