modules.cache now depends in ext-mods, some SQLs improved

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

diff --git a/inc/extensions/ext-payout.php b/inc/extensions/ext-payout.php
index 91b9fba016ab725df9bed7fbdb3ad2dd95dd473b..963246ade9a42068ea4be04822056ae2645f3180 100644 (file)
--- a/inc/extensions/ext-payout.php
+++ b/inc/extensions/ext-payout.php
@@ -50,7 +50,7 @@ switch (getExtensionMode()) {
        case 'register': // Do stuff when installation is running
                // SQL commands to run
                addDropTableSql('user_payouts');
-               addCreateTableSql('user_payouts', "(
+               addCreateTableSql('user_payouts', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `payout_total` FLOAT(22,3) UNSIGNED NOT NULL DEFAULT 0.000,
@@ -59,20 +59,25 @@ switch (getExtensionMode()) {
 `payout_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `payout_timestamp` VARCHAR(10) NOT NULL DEFAULT 0,
 `status` ENUM('NEW','ACCEPTED','REJECTED') NOT NULL DEFAULT 'NEW',
+PRIMARY KEY (`id`),
 INDEX (`userid`),
-INDEX (`payout_id`),
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Done user payouts (and status)'");
+INDEX (`payout_id`)",
+                       'Done user payouts (and status)');
+
                addDropTableSql('payout_types');
-               addCreateTableSql('payout_types', "(
+               addCreateTableSql('payout_types', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `type` VARCHAR(255) NOT NULL DEFAULT '',
 `rate` FLOAT(22,3) UNSIGNED NOT NULL DEFAULT 0.000,
 `min_points` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Payout types'");
+PRIMARY KEY (`id`)",
+                       'Payout types');
+
+               // Admin menu
                addAdminMenuSql('setup','config_payouts','Auszahlungen','Auszahlungsarten einstellen, neu anlegen oder löschen.',15);
                addAdminMenuSql('payouts','list_payouts','Anfragen auflisten','Listet alle Auszahlungsanfragen Ihrer Mitglieder auf.',16);
+
+               // Member menu
                addMemberMenuSql('main', 'payout', 'Auszahlungen', 11);
                break;
 
@@ -122,7 +127,7 @@ PRIMARY KEY (`id`)
                                break;
 
                        case '0.1.6': // SQL queries for v0.1.6
-                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_payout_types` CHANGE pass_enc pass_enc ENUM('md5','base64','xxx') NOT NULL DEFAULT 'xxx'");
+                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_payout_types` CHANGE `pass_enc` `pass_enc` ENUM('md5','base64','xxx') NOT NULL DEFAULT 'xxx'");
                                break;
 
                        case '0.1.8': // SQL queries for v0.1.8
@@ -141,8 +146,8 @@ PRIMARY KEY (`id`)
                                break;
 
                        case '0.2.1': // SQL queries for v0.2.1
-                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_payouts` CHANGE payout_total payout_total FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000");
-                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_payout_types` CHANGE rate rate FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000");
+                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_payouts` CHANGE `payout_total` `payout_total` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000");
+                               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_payout_types` CHANGE `rate` `rate` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000");
 
                                // Update notes (these will be set as task text!)
                                setExtensionUpdateNotes("Problem mit Speicherung der Einstellungen beseitigt.");