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

Timestamp:

Dec 7, 2013, 10:54:21 PM (11 years ago)

Author:

chronos

Message:

• Přidáno: Tabulka pro evidenci bezdrátovách rozhraní.

File:

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

trunk/Common/Setup/Updates.php

@@ -463 +463 @@
 }
 
+function UpdateTo601($Manager)
+{
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkInterfaceWireless` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `NetworkInterface` int(11) NOT NULL,
+  `TxPower` int(11) NOT NULL,
+  `CableAttenuation` int(11) NOT NULL,
+  `AntenaGain` int(11) NOT NULL,
+  `Frequency` float NOT NULL,
+  `ChannelWidth` int(11) NOT NULL,
+  `SSID` varchar(255) NOT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `NetworkInterface` (`NetworkInterface`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;');
+
+  $Manager->Execute('ALTER TABLE `NetworkInterfaceWireless`
+  ADD CONSTRAINT `NetworkInterfaceWireless_ibfk_1` FOREIGN KEY (`NetworkInterface`) REFERENCES `NetworkInterface` (`Id`);');
+  $Manager->Execute("INSERT INTO `centrala_big`.`Action` (
+`Id` ,`Name` ,`Title` ,`Type` ,`URL` ,`Group` ,`Icon` ,`PermissionOperation` ,
+`Enable`) VALUES (NULL , '', 'Wifi rozhraní', '1', '/is/?t=NetworkInterfaceWireless&a=list', NULL , NULL , NULL , '1'
+);");
+  $ActionId = $Manager->Database->insert_id;
+  $Manager->Execute("INSERT INTO `MenuItem` (`Id` ,`Name` ,`Parent` ,`Action` ,`Menu`) ".
+    "VALUES (NULL , 'Bezdrátové rozhraní', '1', '".$ActionId."', '1');");
+}
+
 class Updates
 {
@@ -492 +518 @@
       584 => array('Revision' => 591, 'Function' => 'UpdateTo591'),
       591 => array('Revision' => 597, 'Function' => 'UpdateTo597'),
+      597 => array('Revision' => 601, 'Function' => 'UpdateTo601'),
     ));
   }