3187: Migration to add started_at and finished_at to job_tasks and pipeline_instances.

[arvados.git] / services / api / db / migrate / 20140909183946_add_start_finish_time_to_tasks_and_pipelines.rb

diff --git a/services/api/db/migrate/20140909183946_add_start_finish_time_to_tasks_and_pipelines.rb b/services/api/db/migrate/20140909183946_add_start_finish_time_to_tasks_and_pipelines.rb
new file mode 100644 (file)
index 0000000..139cb8d
--- /dev/null
+++ b/services/api/db/migrate/20140909183946_add_start_finish_time_to_tasks_and_pipelines.rb
@@ -0,0 +1,15 @@
+class AddStartFinishTimeToTasksAndPipelines < ActiveRecord::Migration
+  def up
+    add_column :job_tasks, :started_at, :datetime
+    add_column :job_tasks, :finished_at, :datetime
+    add_column :pipeline_instances, :started_at, :datetime
+    add_column :pipeline_instances, :finished_at, :datetime
+  end
+
+  def down
+    remove_column :job_tasks, :started_at
+    remove_column :job_tasks, :finished_at
+    remove_column :pipeline_instances, :started_at
+    remove_column :pipeline_instances, :finished_at
+  end
+end