Changeset 870 for trunk/Application/UpdateTrace.php

Timestamp:

Apr 3, 2020, 12:30:49 AM (5 years ago)

Author:

chronos

Message:

• Added: IPv6 mangle firewall configuration.

File:

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

trunk/Application/UpdateTrace.php

@@ -2102 +2102 @@
         "VALUES (NULL , 'Omezení rychlosti', ".$DbRow['Id'].", '".$ActionId."', '1');");
   }
+}
+
+function UpdateTo870($Manager)
+{
+  $Manager->Execute('ALTER TABLE `NetworkSubnet`ADD COLUMN `MaskIPv6` INT(11) NOT NULL AFTER `AddressRangeIPv6`;');
+  $Manager->Execute('UPDATE `NetworkSubnet` SET `MaskIPv6`=64 WHERE `AddressRangeIPv6` != ""');
+  $Manager->Execute('UPDATE `NetworkSubnet` SET `AddressRangeIPv6` = REPLACE(`AddressRangeIPv6`, "/64", "")');
 }
 
@@ -2203 +2210 @@
       862 => array('Revision' => 867, 'Function' => 'UpdateTo867'),
       867 => array('Revision' => 869, 'Function' => 'UpdateTo869'),
+      869 => array('Revision' => 870, 'Function' => 'UpdateTo870'),
     ));
   }