Introduced wrapper function addCreateTableSql(), fixed parameter order:

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

diff --git a/inc/extensions/ext-doubler.php b/inc/extensions/ext-doubler.php
index da931e12c5bdf45f7fb39002482a0ce53fed818a..43a732d7293c45a4ac34373cfefc49ba70150141 100644 (file)
--- a/inc/extensions/ext-doubler.php
+++ b/inc/extensions/ext-doubler.php
@@ -50,7 +50,7 @@ switch (getExtensionMode()) {
        case 'register': // Do stuff when installation is running (modules.php?module=admin is called)
                // Doubler table
                addDropTableSql('doubler');
-               addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_doubler` (
+               addCreateTableSql('doubler', "(
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `refid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
@@ -62,7 +62,7 @@ switch (getExtensionMode()) {
 KEY (`refid`),
 KEY (`userid`),
 PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci");
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'User doubler data'");
 
                //
                // --- SETTINGS ---
@@ -145,7 +145,7 @@ PRIMARY KEY (`id`)
 
                        case '0.0.2': // SQL queries for v0.0.2
                                // Total used points
-                               addConfigAddSql("doubler_used FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000");
+                               addConfigAddSql('doubler_user', "FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000");
 
                                // Update notes (these will be set as task text!)
                                setExtensionUpdateNotes("Gebühr wird vom Verdoppler-Pott abgezogen.");
@@ -158,7 +158,7 @@ PRIMARY KEY (`id`)
 
                        case '0.0.4': // SQL queries for v0.0.4
                                // Shall I use the doubler's account to take points from? (Y/N, default=Y)
-                               addConfigAddSql("doubler_own ENUM('Y','N') NOT NULL DEFAULT 'Y'");
+                               addConfigAddSql('doubler_own', "ENUM('Y','N') NOT NULL DEFAULT 'Y'");
 
                                // Update notes (these will be set as task text!)
                                setExtensionUpdateNotes("{?POINTS?}-Guthaben des Verdopplers kann optional nicht mit einbezogen werden.");