Changeset 81 for trunk

Timestamp:

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

Author:

chronos

Message:

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

Location:

trunk/Application

Files:

• UpdateTrace.php (modified) (1 diff)
• View.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"');

trunk/Application/View.php

@@ -19 +19 @@
     $Output .= $Content;
     $Output .= '<br/><div style="text-align: center; font-size: small;">Verze: '.$Revision.' ('.HumanDate($ReleaseTime).')'.
-      ' &nbsp; <a href="http://svn.zdechov.net/trac/statistic/browser/trunk">Zdrojový kód</a> &nbsp; '.
-      '<a href="http://svn.zdechov.net/trac/statistic/log/trunk?verbose=on">Historie změn</a></div>';
+      ' &nbsp; <a href="http://svn.zdechov.net/trac/estetistic/browser/trunk">Zdrojový kód</a> &nbsp; '.
+      '<a href="http://svn.zdechov.net/trac/estetistic/log/trunk?verbose=on">Historie změn</a></div>';
     $Output .= '</body></html>';
     echo($Output);