Changeset 867 for trunk/Application/UpdateTrace.php

Timestamp:

Feb 6, 2016, 12:54:26 AM (9 years ago)

Author:

chronos

Message:

• Added: Export task TimeQueued time which is different to TimeStart time which is actual time when task was started to be processed.
• Fixed: Updated also export of DBC files.

File:

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

trunk/Application/UpdateTrace.php

@@ -2938 +2938 @@
 }
 
+function UpdateTo867($Manager)
+{
+  $Manager->Execute('ALTER TABLE `ExportTask` ADD `TimeQueued` DATETIME NOT NULL AFTER `Id`;');
+  $Manager->Execute('UPDATE `ExportTask` SET `TimeQueued` = `TimeStart`');
+  $Manager->Execute('ALTER TABLE `ExportTask` CHANGE `TimeStart` `TimeStart` DATETIME NULL;');
+}
+
 class Updates
 {
@@ -2974 +2981 @@
   848 => array('Revision' => 849, 'Function' => 'UpdateTo849'),
   849 => array('Revision' => 857, 'Function' => 'UpdateTo857'),
+  857 => array('Revision' => 867, 'Function' => 'UpdateTo867'),
     ));
   }