New extension added, ext-uberwach rewritten (unfinished), some fixes

[mailer.git] / inc / extensions / ext-optimize.php

diff --git a/inc/extensions/ext-optimize.php b/inc/extensions/ext-optimize.php
index 34b68946ff0cd632c294c08f260c0fbabfaf38e1..478fa601664d55840596b92588380a45a8170ff2 100644 (file)
--- 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