addCreateTableSql() is now more encapsulated

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

diff --git a/inc/extensions/ext-register.php b/inc/extensions/ext-register.php
index f50488707ba9f057fe141b233aad549ab6bea985..019915876bead85780ac77108b382619b250ce81 100644 (file)
--- a/inc/extensions/ext-register.php
+++ b/inc/extensions/ext-register.php
@@ -76,12 +76,12 @@ switch (getExtensionMode()) {
                switch (getCurrentExtensionVersion()) {
                        case '0.1.0': // SQL queries for v0.1
                                addDropTableSql('must_register');
-                               addCreateTableSql('must_register', "(
+                               addCreateTableSql('must_register', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `field_name` VARCHAR(255) NOT NULL DEFAULT '',
 `field_required` ENUM('Y','N') NOT NULL DEFAULT 'Y',
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Data which fields the user must fill out'");
+PRIMARY KEY (`id`)",
+                                       'Data which fields the user must fill out');
 
                                // Add all entries as required (DO NOT DELETE THEM FROM DATABASE!)
                                addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_must_register` (`field_name`, `field_required`) VALUES ('surname','Y')");