addCreateTableSql() is now more encapsulated

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

diff --git a/inc/extensions/ext-online.php b/inc/extensions/ext-online.php
index 18ab1d64074813788cbbc5193fd4d7088f967190..c1494a11a8423a7dda2b39b730782b4a07bcff7d 100644 (file)
--- a/inc/extensions/ext-online.php
+++ b/inc/extensions/ext-online.php
@@ -50,7 +50,7 @@ switch (getExtensionMode()) {
        case 'register': // Do stuff when installation is running
                // SQL commands to run
                addDropTableSql('online');
-               addCreateTableSql('online', "(
+               addCreateTableSql('online', "
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `sid` VARCHAR(32) NOT NULL DEFAULT '',
 `ip` VARCHAR(15) NOT NULL DEFAULT '',
@@ -65,8 +65,8 @@ switch (getExtensionMode()) {
 PRIMARY KEY (`id`),
 INDEX (`userid`),
 INDEX (`refid`),
-INDEX `admin_member` (`is_admin`, `is_member`)
-) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Who-is-where data'");
+INDEX `admin_member` (`is_admin`, `is_member`)",
+                       'Who-is-where data');
                addAdminMenuSql('misc','usr_online','Online-Statistik','Eine Liste von derzeit "Online" Usern. Doppelte Einträge könnte auf mangelnden Cookie-Support des Browsers oder auf einen Spider hindeuten.', 1);
                break;
 
@@ -124,8 +124,8 @@ INDEX `admin_member` (`is_admin`, `is_member`)
                                break;
 
                        case '0.0.6': // SQL queries for v0.0.6
-                               addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_online` CHANGE `userid` `userid` BIGINT( 20 ) UNSIGNED NULL DEFAULT NULL,
-CHANGE `refid` `refid` BIGINT( 20 ) UNSIGNED NULL DEFAULT NULL');
+                               addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_online` CHANGE `userid` `userid` BIGINT(20) UNSIGNED NULL DEFAULT NULL');
+                               addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_online` CHANGE `refid` `refid` BIGINT(20) UNSIGNED NULL DEFAULT NULL');
 
                                // Update notes (these will be set as task text!)
                                setExtensionUpdateNotes("Spalten userid und refid erlauben nun <stron>null</strong>.");