Changeset 862 for trunk/Application/UpdateTrace.php

Timestamp:

Oct 4, 2019, 9:37:59 AM (6 years ago)

Author:

chronos

Message:

• Modified: Optimized insertion of new NetworkInterfaceUpDown state records.

File:

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

trunk/Application/UpdateTrace.php

@@ -2056 +2056 @@
   $Manager->Execute('ALTER TABLE `NetworkDeviceLog`
     ADD CONSTRAINT `NetworkDeviceLog_ibfk_1` FOREIGN KEY (`Device`) REFERENCES `NetworkDevice` (`Id`);');
+}
+
+function UpdateTo862($Manager)
+{
+  $Manager->Execute('ALTER TABLE `NetworkInterfaceUpDown` ADD `Previous` INT NULL AFTER `Duration`');
+  $Manager->Execute('ALTER TABLE `NetworkInterfaceUpDown` ADD INDEX ( `Previous` )');
+  $Manager->Execute('UPDATE `NetworkInterfaceUpDown` AS T1, `NetworkInterfaceUpDown` AS T2 SET T1.Previous = T2.Id WHERE (T1.Previous IS NULL) AND (T2.Interface=T1.Interface) AND (T1.Time = DATE_ADD(T2.Time, INTERVAL T2.Duration SECOND))');
 }
 
@@ -2154 +2161 @@
       838 => array('Revision' => 844, 'Function' => 'UpdateTo844'),
       844 => array('Revision' => 855, 'Function' => 'UpdateTo855'),
+      855 => array('Revision' => 862, 'Function' => 'UpdateTo862'),
     ));
   }