Changeset 862 for trunk/Application

Timestamp:

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

Author:

chronos

Message:

• Modified: Optimized insertion of new NetworkInterfaceUpDown state records.

Location:

trunk/Application

Files:

• UpdateTrace.php (modified) (2 diffs)
• Version.php (modified) (1 diff)

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'),
     ));
   }

trunk/Application/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 857; // Subversion revision
-$DatabaseRevision = 855; // SQL structure revision
-$ReleaseTime = strtotime('2019-05-08');
+$Revision = 862; // Subversion revision
+$DatabaseRevision = 862; // SQL structure revision
+$ReleaseTime = strtotime('2019-10-04');