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

Timestamp:

Sep 23, 2014, 9:56:07 PM (10 years ago)

Author:

chronos

Message:

• Upraveno: Dobu trvání v tabulce NetworkInterfaceUpDown ukládat jako pevné číslo ihned při vkládání. Tím dojde ke zpomalení vkládání, ale zrychlení prohlížení tabulky stavu dostupnosti.

File:

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

trunk/Common/Setup/Updates.php

@@ -911 +911 @@
   $Manager->Execute('ALTER TABLE `User` DROP `PhoneNumber`;');
 }
+
+function UpdateTo696($Manager)
+{
+        $Manager->Execute('ALTER TABLE `NetworkInterfaceUpDown` ADD `Duration` INT NOT NULL ;');
+        $Manager->Execute('UPDATE `NetworkInterfaceUpDown` AS `TM` SET `Duration` = IFNULL(TIMESTAMPDIFF(SECOND,
+    (SELECT `Time` FROM (SELECT * FROM `NetworkInterfaceUpDown`) AS `TA` WHERE (`TA`.`Time` < `TM`.`Time`)
+    AND (`TA`.`Interface`=`TM`.`Interface`) ORDER BY `TA`.`Time` DESC LIMIT 1), `TM`.`Time`), 0)');
+}
+
 
 class Updates
@@ -962 +971 @@
       679 => array('Revision' => 688, 'Function' => 'UpdateTo688'),
       688 => array('Revision' => 692, 'Function' => 'UpdateTo692'),
+      692 => array('Revision' => 696, 'Function' => 'UpdateTo696'),
     ));
   }