Changeset 948 for trunk/Application

Timestamp:

Apr 10, 2023, 7:44:01 PM (19 months ago)

Author:

chronos

Message:

• Fixed: IP address database field size in News table for IPv6.

Location:

trunk/Application

Files:

• UpdateTrace.php (modified) (4 diffs)
• Version.php (modified) (1 diff)

trunk/Application/UpdateTrace.php

@@ -2184 +2184 @@
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
   $Manager->Execute('ALTER TABLE `NetworkMac` ADD PRIMARY KEY (`Id`), ADD KEY `MAC` (`MAC`);');
-  $Manager->Execute('ALTER TABLE `NetworkMac` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;');  
+  $Manager->Execute('ALTER TABLE `NetworkMac` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;');
 
   // Convert NetworkSignal MAC from string into reference
@@ -2220 +2220 @@
 
 function UpdateTo939(UpdateManager $Manager): void
-{  
+{
   $Manager->Execute('ALTER TABLE `Member` ADD `PaymentEmailTime` DATETIME NULL DEFAULT NULL AFTER `Contract`;');
   $Manager->Execute('UPDATE `Member` SET `PaymentEmailTime`=DATE_SUB(`BillingPeriodLastDate`, INTERVAL 1 MONTH) WHERE BillingPeriod=2 AND BillingPeriodLastDate<>"0000-00-00"');
@@ -2227 +2227 @@
   $Manager->Execute('UPDATE `Member` SET `PaymentEmailTime`=DATE_SUB(`BillingPeriodLastDate`, INTERVAL 12 MONTH) WHERE BillingPeriod=5 AND BillingPeriodLastDate<>"0000-00-00"');
   $Manager->Execute('ALTER TABLE `UserOnline` ENGINE = InnoDB;');
+}
+
+function UpdateTo948(UpdateManager $Manager): void
+{
+  $Manager->Execute('ALTER TABLE `News` CHANGE `IP` `IP` VARCHAR(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL;');
 }
 
@@ -2339 +2344 @@
       921 => array('Revision' => 933, 'Function' => 'UpdateTo933'),
       933 => array('Revision' => 939, 'Function' => 'UpdateTo939'),
+      939 => array('Revision' => 948, 'Function' => 'UpdateTo948'),
     );
   }

trunk/Application/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 945; // Subversion revision
-$DatabaseRevision = 939; // SQL structure revision
+$Revision = 948; // Subversion revision
+$DatabaseRevision = 948; // SQL structure revision
 $ReleaseTime = strtotime('2022-12-06');