Changeset 872 for trunk/Application/UpdateTrace.php

Timestamp:

Apr 9, 2017, 3:40:35 PM (7 years ago)

Author:

chronos

Message:

• Fixed: Allow to store IPv6 address in database for UserTrace and UserOnline tables.

File:

• trunk/Application/UpdateTrace.php (modified) (2 diffs)

trunk/Application/UpdateTrace.php

@@ -2945 +2945 @@
 }
 
+function UpdateTo872($Manager)
+{       
+  // Allow to store IPv6 addresses
+  $Manager->Execute('ALTER TABLE `UserOnline` CHANGE `IpAddress` `IpAddress` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT "";');
+  $Manager->Execute('ALTER TABLE `UserTrace` CHANGE `LastLogin` `LastLogin` DATETIME NULL;');
+  $Manager->Execute('ALTER TABLE `UserTrace` CHANGE `LastLogout` `LastLogout` DATETIME NULL;');
+  $Manager->Execute('UPDATE `UserTrace` SET LastLogin=NULL WHERE CAST(LastLogin AS CHAR(20))="0000-00-00 00:00:00"');
+  $Manager->Execute('UPDATE `UserTrace` SET LastLogout=NULL WHERE CAST(LastLogout AS CHAR(20))="0000-00-00 00:00:00"');
+  $Manager->Execute('ALTER TABLE `UserTrace` CHANGE `LastIP` `LastIP` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;');
+}
+
 class Updates
 {
@@ -2982 +2993 @@
   849 => array('Revision' => 857, 'Function' => 'UpdateTo857'),
   857 => array('Revision' => 867, 'Function' => 'UpdateTo867'),
+  867 => array('Revision' => 872, 'Function' => 'UpdateTo872'),
     ));
   }