addCreateTableSql() is now more encapsulated

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

diff --git a/inc/extensions/ext-wernis.php b/inc/extensions/ext-wernis.php
index 34ae972a5c2b0a4ab14a0eccdf79935f6dd17d0a..3f6a9240ac9cd6ccae3f87cef770f7e7b51b8093 100644 (file)
--- a/inc/extensions/ext-wernis.php
+++ b/inc/extensions/ext-wernis.php
@@ -50,7 +50,7 @@ switch (getExtensionMode()) {
        case 'register': // Do stuff when installation is running
                // SQL commands to run
                addDropTableSql('user_wernis');
-               addCreateTableSql('user_wernis', "(
+               addCreateTableSql('user_wernis', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `wernis_account` VARCHAR(255) NOT NULL DEFAULT '',
@@ -59,9 +59,9 @@ switch (getExtensionMode()) {
 `wernis_type` ENUM('IN','OUT','FAILED') NOT NULL DEFAULT 'FAILED',
 `wernis_api_message` TINYTEXT,
 `wernis_api_status` VARCHAR(255) NULL DEFAULT NULL,
-INDEX (`userid`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Transfered Wernis per user'");
+INDEX (`userid`)",
+                       'Transfered Wernis per user');
 
                // Confiuration
                addConfigAddSql('wernis_min_payout', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT 40000');
@@ -89,8 +89,8 @@ PRIMARY KEY (`id`)
                // SQL commands to run
                addDropTableSql('user_wernis');
                addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `action`='wernis'");
-               addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE `what`='wernis'");
-               addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_guest_menu` WHERE `what`='wernis_portal'");
+               addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE `what`='wernis' LIMIT 1");
+               addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_guest_menu` WHERE `what`='wernis_portal' LIMIT 1");
                break;
 
        case 'activate': // Do stuff when admin activates this extension