X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fextensions%2Fext-online.php;h=05badce02cce7a4cc1223023e27355b432bb5d4e;hb=c2baf8e3ea692fecac4d37d321368e2b85bbca06;hp=5359cdff6e7755e1a11f9e59c7d6f044479ef602;hpb=433a86a6c27009ba3c48a17b5befcc671b45d9a5;p=mailer.git

diff --git a/inc/extensions/ext-online.php b/inc/extensions/ext-online.php
index 5359cdff6e..05badce02c 100644
--- 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;