Changeset 880 for trunk/Application/UpdateTrace.php

Timestamp:

Sep 4, 2020, 9:30:13 AM (4 years ago)

Author:

chronos

Message:

• Fixed: Allow to store IPv6 in IpAddress database field originally designed for IPv4.
• Fixed: Check if AppModule OnLoadModules method is defined as array.

File:

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

trunk/Application/UpdateTrace.php

@@ -2116 +2116 @@
   $Manager->Execute('ALTER TABLE `NewsImport` ADD PRIMARY KEY (`Id`);');
   $Manager->Execute('ALTER TABLE `NewsImport` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;');
+}
+
+function UpdateTo880($Manager)
+{
+  $Manager->Execute('ALTER TABLE `UserOnline` CHANGE `IpAddress` `IpAddress` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';');
+  $Manager->Execute('ALTER TABLE `User` CHANGE `LastIpAddress` `LastIpAddress` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';');
+  $Manager->Execute('ALTER TABLE `Log` CHANGE `IPAddress` `IPAddress` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;');
 }
 
@@ -2219 +2226 @@
       869 => array('Revision' => 870, 'Function' => 'UpdateTo870'),
       870 => array('Revision' => 878, 'Function' => 'UpdateTo878'),
+      878 => array('Revision' => 880, 'Function' => 'UpdateTo880'),
     );
   }