addCreateTableSql() is now more encapsulated

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

diff --git a/inc/extensions/ext-doubler.php b/inc/extensions/ext-doubler.php
index 80c327d91aefec31e3ad47c29167aa061244b442..e411c5432179c9213cca06d236638b9b26826335 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
                // Doubler table
                addDropTableSql('doubler');
-               addCreateTableSql('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,
@@ -59,10 +59,10 @@ switch (getExtensionMode()) {
 `timemark` BIGINT(10) NOT NULL DEFAULT 0,
 `completed` ENUM('Y','N') NOT NULL DEFAULT 'N',
 `is_ref` ENUM('Y','N') NOT NULL DEFAULT 'N',
-KEY (`refid`),
-KEY (`userid`),
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'User doubler data'");
+PRIMARY KEY (`id`),
+INDEX (`refid`),
+INDEX (`userid`)",
+                       'User doubler data');
 
                //
                // --- SETTINGS ---