addCreateTableSql() is now more encapsulated

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

diff --git a/inc/extensions/ext-beg.php b/inc/extensions/ext-beg.php
index 99daece2fd2e259b55e3bbb9ed9c390cc245f3c5..183f82a66fba8424fcf83a6d6e372792f0a26da6 100644 (file)
--- a/inc/extensions/ext-beg.php
+++ b/inc/extensions/ext-beg.php
@@ -59,15 +59,15 @@ switch (getExtensionMode()) {
 
                // Table for IP locks
                addDropTableSql('beg_ips');
-               addCreateTableSql('beg_ips', "(
+               addCreateTableSql('beg_ips', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `remote_ip` VARCHAR(15) NOT NULL DEFAULT '0.0.0.0',
 `timeout` VARCHAR(10) NOT NULL DEFAULT '',
 `sid` VARCHAR(255) NOT NULL DEFAULT '',
-KEY (`userid`),
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'IP lock data for beg links'");
+PRIMARY KEY (`id`),
+INDEX (`userid`)",
+                       'IP lock data for beg links');
                break;
 
        case 'remove': // Do stuff when removing extension
@@ -278,14 +278,15 @@ PRIMARY KEY (`id`)
 
                        case '0.2.9': // SQL queries for v0.2.9
                                addDropTableSql('beg_referals');
-                               addCreateTableSql('beg_referals', "(
-`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
-`userid` BIGINT(20) UNSIGNED NULL DEFAULT NULL ,
+                               addCreateTableSql('beg_referals', "
+`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`userid` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
 `remote_ip` VARCHAR(15) NOT NULL DEFAULT '0.0.0.0',
-`timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
-`referal_url` TINYTEXT NOT NULL ,
-INDEX (`userid`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Recorded Referal URLs'");
+`timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+`referal_url` TINYTEXT NOT NULL,
+PRIMARY KEY (`id),
+INDEX (`userid`)",
+                                       'Recorded Referal URLs');
 
                                // Add admin menu
                                addAdminMenuSql('user','list_beg_referal_urls','Bettel-Referals auflisten','Listet alle Bettellink-Aufrufe inklusive Referal-URL auf.','13');