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

Timestamp:

Jul 19, 2014, 1:21:24 AM (10 years ago)

Author:

chronos

Message:

• Upraveno: Příprava pro sledování signálu bezdrátových spojů.

File:

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

trunk/Common/Setup/Updates.php

@@ -759 +759 @@
   $Manager->Execute("INSERT INTO `MenuItem` (`Id` ,`Name` ,`Parent` ,`Action` ,`Menu`) ".
     "VALUES (NULL , 'Kontakty', '12', '".$ActionId."', '1');");
-  $ConatctMenuId = $Manager->Database->insert_id;
+  $ContactMenuId = $Manager->Database->insert_id;
 
   $Manager->Execute("INSERT INTO `Action` (
@@ -767 +767 @@
   $ActionId = $Manager->Database->insert_id;
   $Manager->Execute("INSERT INTO `MenuItem` (`Id` ,`Name` ,`Parent` ,`Action` ,`Menu`) ".
-    "VALUES (NULL , 'Druhy kontaktů', ".$ConatctMenuId.", '".$ActionId."', '1');");
+    "VALUES (NULL , 'Druhy kontaktů', ".$ContactMenuId.", '".$ActionId."', '1');");
 
   $Manager->Execute("INSERT INTO `ContactCategory` (`Id` ,`Name`)
@@ -797 +797 @@
   $Manager->Execute('INSERT INTO `Module` (`Id` ,`Name` ,`Title`)
 VALUES (NULL , "RSS", "RSS kanály");');
+}
+
+function UpdateTo671($Manager)
+{
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkSignal` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Time` datetime NOT NULL,
+  `MAC` varchar(17) NOT NULL,
+  `Interface` int(11) DEFAULT NULL,
+  `Value` int(11) NOT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `Interface` (`Interface`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;');
+
+  $Manager->Execute('ALTER TABLE `NetworkSignal`
+  ADD CONSTRAINT `NetworkSignal_ibfk_1` FOREIGN KEY (`Interface`) REFERENCES `NetworkInterface` (`Id`);');
+  $Manager->Execute('INSERT INTO `Action` (`Id` ,`Name` ,`Title` ,`Type` ,`URL` ,
+`Group` ,`Icon` ,`PermissionOperation` ,`Enable`) VALUES (
+NULL , "", "Signál rozhraní", "1", "/is/?t=NetworkSignal&a=list", NULL , NULL , NULL , "1");');
+  $ActionId = $Manager->Database->insert_id;
+  $Manager->Execute("INSERT INTO `MenuItem` (`Id` ,`Name` ,`Parent` ,`Action` ,`Menu`) ".
+    "VALUES (NULL , 'Signál rozhraní', 4, '".$ActionId."', '1');");
+
+  $Manager->Execute('ALTER TABLE `NetworkDevice` ADD `API` INT NULL ,ADD INDEX ( `API` ) ;');
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `DeviceAPIType` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(255) NOT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;');
+
+  $Manager->Execute('INSERT INTO `DeviceAPIType` (`Id`, `Name`) VALUES
+(1, "RouterOS API"),
+(2, "AirOS");');
+  $Manager->Execute('ALTER TABLE `NetworkDevice` ADD FOREIGN KEY ( `API` ) REFERENCES `DeviceAPIType` (
+`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;');
+
 }
 
@@ -842 +878 @@
       661 => array('Revision' => 662, 'Function' => 'UpdateTo662'),
       662 => array('Revision' => 668, 'Function' => 'UpdateTo668'),
+      668 => array('Revision' => 671, 'Function' => 'UpdateTo671'),
     ));
   }