Changeset 81 for trunk/Application/UpdateTrace.php

Timestamp:

Jan 1, 2017, 12:31:23 AM (8 years ago)

Author:

chronos

Message:

• Modified: Updated project home page links.
• Fixed: Remove rows with zero date from data tables before upgrade.

File:

• trunk/Application/UpdateTrace.php (modified) (1 diff)

trunk/Application/UpdateTrace.php

@@ -65 +65 @@
     $Table = $Measure['DataTable'];
     $Type = $Measure['DataType'];
-    $Manager->Execute('ALTER TABLE `'.$Table.'` CHANGE `time` `Time` DATETIME NULL DEFAULT NULL;');
-    $Manager->Execute('ALTER TABLE `'.$Table.'` CHANGE `measure` `Measure` SMALLINT(11) NOT NULL DEFAULT "0";');
+    $Manager->Execute('DELETE FROM `'.$Table.'` WHERE CAST(`time` AS CHAR(20))="0000-00-00 00:00:00"');
+    $Manager->Execute('ALTER TABLE `'.$Table.'` CHANGE `time` `Time` DATETIME NULL DEFAULT NULL');
+    $Manager->Execute('ALTER TABLE `'.$Table.'` CHANGE `measure` `Measure` SMALLINT(11) NOT NULL DEFAULT "0"');
     $Manager->Execute('ALTER TABLE `'.$Table.'` CHANGE `min` `Min` '.$Type.' NOT NULL DEFAULT "0"');
     $Manager->Execute('ALTER TABLE `'.$Table.'` CHANGE `avg` `Avg` '.$Type.' NOT NULL DEFAULT "0"');