userid/refid do now allow 'null'

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

diff --git a/inc/extensions/ext-online.php b/inc/extensions/ext-online.php
index 5359cdff6e7755e1a11f9e59c7d6f044479ef602..05badce02cce7a4cc1223023e27355b432bb5d4e 100644 (file)
--- a/inc/extensions/ext-online.php
+++ b/inc/extensions/ext-online.php
@@ -41,10 +41,10 @@ if (!defined('__SECURITY')) {
 } // END - if
 
 // Version number
-setThisExtensionVersion('0.0.5');
+setThisExtensionVersion('0.0.6');
 
 // Version history array (add more with , '0.1.0' and so on)
-setExtensionVersionHistory(array('0.0', '0.0.1', '0.0.2', '0.0.3', '0.0.4', '0.0.5'));
+setExtensionVersionHistory(array('0.0', '0.0.1', '0.0.2', '0.0.3', '0.0.4', '0.0.5', '0.0.6'));
 
 switch (getExtensionMode()) {
        case 'register': // Do stuff when installation is running (modules.php?module=admin is called)
@@ -54,8 +54,8 @@ switch (getExtensionMode()) {
 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `sid` VARCHAR(32) NOT NULL DEFAULT '',
 `ip` VARCHAR(15) NOT NULL DEFAULT '',
-`userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`refid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`userid` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
+`refid` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
 `module` VARCHAR(255) NOT NULL DEFAULT '',
 `action` VARCHAR(255) NOT NULL DEFAULT '',
 `what` VARCHAR(255) NOT NULL DEFAULT '',
@@ -122,6 +122,14 @@ INDEX `admin_member` (`is_admin`, `is_member`)
                                // Update notes (these will be set as task text!)
                                setExtensionUpdateNotes("Hinzufügen des Menüpunktes "Jetzt Online" wird nun von dieser Erweiterung erledigt. Filter hinzugefügt.");
                                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');
+
+                               // Update notes (these will be set as task text!)
+                               setExtensionUpdateNotes("Spalten userid und refid erlauben nun <stron>null</strong>.");
+                               break;
                } // END - switch
                break;