addCreateTableSql() is now more encapsulated

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

diff --git a/inc/extensions/ext-transfer.php b/inc/extensions/ext-transfer.php
index 8185e746b515d7020c6518a5d7cda8fd0c597c43..ebd9ba3152e6bf558d618bd7da9ad43e22bae073 100644 (file)
--- a/inc/extensions/ext-transfer.php
+++ b/inc/extensions/ext-transfer.php
@@ -50,7 +50,7 @@ switch (getExtensionMode()) {
        case 'register': // Do stuff when installation is running
                // Transfer from a member
                addDropTableSql('user_transfers_in');
-               addCreateTableSql('user_transfers_in', "(
+               addCreateTableSql('user_transfers_in', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `from_userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
@@ -58,14 +58,14 @@ switch (getExtensionMode()) {
 `reason` VARCHAR(255) NOT NULL DEFAULT '',
 `time_trans` VARCHAR(14) NOT NULL DEFAULT 0,
 `trans_id` VARCHAR(12) NOT NULL DEFAULT '',
+PRIMARY KEY (`id`),
 KEY (`userid`),
-KEY (`from_userid`),
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Ingoing points transfers'");
+KEY (`from_userid`)",
+                       'Ingoing points transfers');
 
                // Transfers to a member
                addDropTableSql('user_transfers_out');
-               addCreateTableSql('user_transfers_out', "(
+               addCreateTableSql('user_transfers_out', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `to_userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
@@ -73,10 +73,10 @@ PRIMARY KEY (`id`)
 `reason` VARCHAR(255) NOT NULL DEFAULT '',
 `time_trans` VARCHAR(14) NOT NULL DEFAULT 0,
 `trans_id` VARCHAR(12) NOT NULL DEFAULT '',
+PRIMARY KEY (`id`),
 KEY (`userid`),
-KEY (`to_userid`),
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Outgoing points transfers'");
+KEY (`to_userid`)",
+                       'Outgoing points transfers');
 
                // Admin menu
                addAdminMenuSql('transfer', NULL, '{OPEN_CONFIG}POINTS{CLOSE_CONFIG}-Transfer','Verwalten Sie hier die {OPEN_CONFIG}POINTS{CLOSE_CONFIG}-Transaktionen zwischen Ihren Mitgliedern.', 7);