Changeset 80 for trunk/Application/UpdateTrace.php

Timestamp:

Dec 31, 2016, 8:56:00 PM (7 years ago)

Author:

chronos

Message:

• Added: Upgrade code to rename columns to have first capital name in all data tables.

File:

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

trunk/Application/UpdateTrace.php

@@ -58 +58 @@
 }
 
+function UpdateTo79($Manager)
+{
+  $DbResult = $Manager->Execute('SELECT `DataTable`,`DataType` FROM `Measure`;');
+  while($Measure = $DbResult->fetch_assoc())
+  {
+    $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('ALTER TABLE `'.$Table.'` CHANGE `min` `Min` '.$Type.' NOT NULL DEFAULT "0"');
+    $Manager->Execute('ALTER TABLE `'.$Table.'` CHANGE `avg` `Avg` '.$Type.' NOT NULL DEFAULT "0"');
+    $Manager->Execute('ALTER TABLE `'.$Table.'` CHANGE `max` `Max` '.$Type.' NOT NULL DEFAULT "0"');
+    $Manager->Execute('ALTER TABLE `'.$Table.'` CHANGE `continuity` `Continuity` TINYINT(1) NOT NULL DEFAULT "0"');
+    $Manager->Execute('ALTER TABLE `'.$Table.'` CHANGE `level` `Level` TINYINT(4) NOT NULL DEFAULT "0"');
+  }
+}
+
 class Updates
 {
@@ -64 +81 @@
     return(array(
       65 => array('Revision' => 67, 'Function' => 'UpdateTo67'),
+      67 => array('Revision' => 79, 'Function' => 'UpdateTo79'),
     ));
   }