Changeset 80 for trunk/Application

Timestamp:

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

Author:

chronos

Message:

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

Location:

trunk/Application

Files:

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

trunk/Application/Core.php

@@ -47 +47 @@
       $this->Database->ShowSQLQuery = $Config['Web']['ShowSQLQuery'];
     } catch (Exception $E) {
-
     }
 

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

trunk/Application/Version.php

@@ -6 +6 @@
 // and system will need database update.
 
-$Revision = 77;
-$DatabaseRevision = 67;
+$Revision = 79;
+$DatabaseRevision = 79;
 $ReleaseTime = strtotime('2016-12-31');