Changeset 657 for trunk/Common/Setup/Updates.php

Timestamp:

May 25, 2014, 8:29:03 PM (10 years ago)

Author:

chronos

Message:

• Přidáno: Záznam změn online stavu dostupnosti rozhraní do tabulky.

File:

• trunk/Common/Setup/Updates.php (modified) (2 diffs)

trunk/Common/Setup/Updates.php

@@ -706 +706 @@
 }
 
+function UpdateTo657($Manager)
+{
+        $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkInterfaceUpDown` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Time` datetime NOT NULL,
+  `Interface` int(11) NOT NULL,
+  `State` int(11) NOT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `Interface` (`Interface`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;');
+  $Manager->Execute('ALTER TABLE `NetworkInterfaceUpDown`
+    ADD CONSTRAINT `NetworkInterfaceUpDown_ibfk_1` FOREIGN KEY (`Interface`) REFERENCES `NetworkInterface` (`Id`);');
+  $Manager->Execute("INSERT INTO `Action` (
+`Id` ,`Name` ,`Title` ,`Type` ,`URL` ,`Group` ,`Icon` ,`PermissionOperation` ,
+`Enable`) VALUES (NULL , '', 'Změny stavu rozhraní', '1', '/is/?t=NetworkInterfaceUpDown&a=list', NULL , NULL , NULL , '1'
+);");
+  $ActionId = $Manager->Database->insert_id;
+  $Manager->Execute("INSERT INTO `MenuItem` (`Id` ,`Name` ,`Parent` ,`Action` ,`Menu`) ".
+    "VALUES (NULL , 'Změny stavu rozhraní', 4, '".$ActionId."', '1');");
+}
+
 class Updates
 {
@@ -745 +766 @@
       645 => array('Revision' => 646, 'Function' => 'UpdateTo646'),
       646 => array('Revision' => 647, 'Function' => 'UpdateTo647'),
+      647 => array('Revision' => 657, 'Function' => 'UpdateTo657'),
     ));
   }