addCreateTableSql() is now more encapsulated

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

diff --git a/inc/extensions/ext-booking.php b/inc/extensions/ext-booking.php
index 300e2b2e8351c59f5e5b4b4f4c1c96b19c5303b3..8d649fd4cc00b1dcd4ebd8a7396260ad2fcdd942 100644 (file)
--- a/inc/extensions/ext-booking.php
+++ b/inc/extensions/ext-booking.php
@@ -57,7 +57,7 @@ switch (getExtensionMode()) {
 
                // Drop/create table for user bookings
                addDropTableSql('user_booking');
-               addCreateTableSql('user_booking', "(
+               addCreateTableSql('user_booking', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `subject` VARCHAR(255) NOT NULL DEFAULT 'missing',
@@ -65,9 +65,9 @@ switch (getExtensionMode()) {
 `points` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.0000,
 `comments` TINYTEXT NULL DEFAULT NULL,
 `recorded` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
-INDEX (`userid`),
-PRIMARY KEY (`id`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Member points booking table'");
+PRIMARY KEY (`id`),
+INDEX (`userid`)",
+                       'Member points booking table');
 
                // Admin menu
                addAdminMenuSql('setup','config_booking','Kontoauszug','Einstellungen am Kontoauszug für Mitglieder vornehmen.', 14);