Introduced wrapper function addCreateTableSql(), fixed parameter order:

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

diff --git a/inc/extensions/ext-newsletter.php b/inc/extensions/ext-newsletter.php
index 5729ed7cfba93727005c255ce478fd5411bc4c24..aed01066fb85533b6dbc77e3cd1605ee192da9e0 100644 (file)
--- a/inc/extensions/ext-newsletter.php
+++ b/inc/extensions/ext-newsletter.php
@@ -140,7 +140,7 @@ switch (getExtensionMode()) {
                                // Tables:
                                // - Main data table
                                addDropTableSql('newsletter_data');
-                               addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_newsletter_data` (
+                               addCreateTableSql('newsletter_data', "(
 `nl_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `nl_subject` VARCHAR(255) NOT NULL DEFAULT '{OPEN_CONFIG}nl_default_subject{CLOSE_CONFIG}',
 `nl_header_text` MEDIUMTEXT,
@@ -159,7 +159,7 @@ PRIMARY KEY (`nl_id`)
 
                                // - Topics data table
                                addDropTableSql('newsletter_topics');
-                               addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_newsletter_topics` (
+                               addCreateTableSql('newsletter_topics', "(
 `nl_topic_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `nl_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `nl_topic_title` VARCHAR(255) NOT NULL DEFAULT '',
@@ -171,7 +171,7 @@ PRIMARY KEY (`nl_topic_id`)
 
                                // - Sponsor orders data table
                                addDropTableSql('newsletter_orders');
-                               addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_newsletter_orders` (
+                               addCreateTableSql('newsletter_orders', "(
 `nl_order_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `nl_sponsor_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `nl_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,