Changeset 869 for trunk/Application

Timestamp:

Apr 1, 2020, 12:43:07 AM (5 years ago)

Author:

chronos

Message:

• Added: New SpeedLimit table to support network speed limit groups.

Location:

trunk/Application

Files:

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

trunk/Application/UpdateTrace.php

@@ -2075 +2075 @@
     KEY `Time` (`Time`)
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
-
+}
+
+function UpdateTo869($Manager)
+{
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkSpeedLimit` (
+    `Id` int(11) NOT NULL AUTO_INCREMENT,
+    `Name` varchar(255) CHARACTER SET utf8 NOT NULL,
+    `SpeedMaxOut` bigint(20) NOT NULL DEFAULT 0,
+    `SpeedMaxIn` bigint(20) NOT NULL DEFAULT 0,
+    `Parent` int(11) DEFAULT 0,
+    PRIMARY KEY (`Id`),
+    KEY `Parent` (`Parent`)
+  ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;');
+  $Manager->Execute('ALTER TABLE `ServiceCustomerRel` ADD COLUMN `SpeedLimit` INT NULL AFTER `ChangeReplaceId`, ADD INDEX `SpeedLimit` (`SpeedLimit`);');
+
+  // IS menu item
+  $Manager->Execute('INSERT INTO `Action` (`Id` ,`Name` ,`Title` ,`Type` ,`URL` ,
+    `Group` ,`Icon` ,`PermissionOperation` ,`Enable`) VALUES (
+    NULL , "", "Omezení rychlosti", "1", "/is/?t=NetworkSpeedLimit&a=list", NULL , NULL , NULL , "1");');
+  $ActionId = $Manager->Database->insert_id;
+  $DbResult = $Manager->Execute('SELECT `Id` FROM `MenuItem` WHERE `Name`="Síť"');
+  if($DbResult->num_rows > 0)
+  {
+    $DbRow = $DbResult->fetch_assoc();
+    $Manager->Execute("INSERT INTO `MenuItem` (`Id` ,`Name` ,`Parent` ,`Action` ,`Menu`) ".
+        "VALUES (NULL , 'Omezení rychlosti', ".$DbRow['Id'].", '".$ActionId."', '1');");
+  }
 }
 
@@ -2176 +2202 @@
       855 => array('Revision' => 862, 'Function' => 'UpdateTo862'),
       862 => array('Revision' => 867, 'Function' => 'UpdateTo867'),
+      867 => array('Revision' => 869, 'Function' => 'UpdateTo869'),
     ));
   }

trunk/Application/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 868; // Subversion revision
-$DatabaseRevision = 867; // SQL structure revision
-$ReleaseTime = strtotime('2020-01-13');
+$Revision = 869; // Subversion revision
+$DatabaseRevision = 869; // SQL structure revision
+$ReleaseTime = strtotime('2020-03-31');