Changeset 818 for trunk/Application/UpdateTrace.php

Timestamp:

Mar 16, 2016, 10:01:02 PM (9 years ago)

Author:

chronos

Message:

• Added: UpDown history for network ports.

File:

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

trunk/Application/UpdateTrace.php

@@ -1988 +1988 @@
   $Manager->Execute('UPDATE `NetworkConfiguration` SET `SysName`="RouterosDNS" WHERE `Id`=13');
   $Manager->Execute('ALTER TABLE `NetworkConfiguration` DROP `Execute`;');
+}
+
+function UpdateTo818($Manager)
+{
+  $Manager->Execute('ALTER TABLE `NetworkPort` ADD `Protocol` INT NOT NULL AFTER `Enabled`;');
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkPortUpDown` (
+    `Id` int(11) NOT NULL AUTO_INCREMENT,
+    `Time` datetime NOT NULL,
+    `Port` int(11) NOT NULL,
+    `State` int(11) NOT NULL,
+    `Duration` int(11) DEFAULT NULL,
+    PRIMARY KEY (`Id`),
+    KEY `Port` (`Port`),
+    KEY `Time` (`Time`)
+    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;');
+   $Manager->Execute('ALTER TABLE `NetworkPortUpDown`
+     ADD CONSTRAINT `NetworkPortUpDown_ibfk_1` FOREIGN KEY (`Port`) REFERENCES `NetworkPort` (`Id`);');
 }
 
@@ -2080 +2097 @@
       808 => array('Revision' => 814, 'Function' => 'UpdateTo814'),
       814 => array('Revision' => 817, 'Function' => 'UpdateTo817'),
+      817 => array('Revision' => 818, 'Function' => 'UpdateTo818'),
     ));
   }