Changeset 824 for trunk/Application/UpdateTrace.php

Timestamp:

Apr 4, 2016, 8:41:19 PM (8 years ago)

Author:

chronos

Message:

• Added: Network latency periodic measurement of network interfaces with local IP.

File:

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

trunk/Application/UpdateTrace.php

@@ -2005 +2005 @@
    $Manager->Execute('ALTER TABLE `NetworkPortUpDown`
      ADD CONSTRAINT `NetworkPortUpDown_ibfk_1` FOREIGN KEY (`Port`) REFERENCES `NetworkPort` (`Id`);');
+}
+
+function UpdateTo824($Manager)
+{
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkInterfaceLatency` (
+    `Id` int(11) NOT NULL AUTO_INCREMENT,
+    `Time` datetime NOT NULL,
+    `Interface` int(11) NOT NULL,
+    `Value` float NOT NULL,
+    PRIMARY KEY (`Id`),
+    KEY `Interface` (`Interface`)
+    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
+  $Manager->Execute('ALTER TABLE `NetworkInterfaceLatency`
+    ADD CONSTRAINT `NetworkInterfaceLatency_ibfk_1` FOREIGN KEY (`Interface`) REFERENCES `NetworkInterface` (`Id`);');
 }
 
@@ -2098 +2112 @@
       814 => array('Revision' => 817, 'Function' => 'UpdateTo817'),
       817 => array('Revision' => 818, 'Function' => 'UpdateTo818'),
+      818 => array('Revision' => 824, 'Function' => 'UpdateTo824'),
     ));
   }