Sha256: 95e6bbc5826fc24f7f9c7d9edfc25c08462728eccf1b683b0ac32731bdc4bf62

Contents?: true

Size: 547 Bytes

Versions: 1

Compression:

Stored size: 547 Bytes

Contents

class AddCheckedOutToSprintsTasks < ActiveRecord::Migration
  def up
    add_column :sprints_tasks, :checked_out_at, :timestamp
    add_column :sprints_tasks, :checked_out_by_id, :integer
    
    execute <<-SQL
      UPDATE sprints_tasks
        SET checked_out_at=tasks.checked_out_at,
            checked_out_by_id=tasks.checked_out_by_id
        FROM tasks
        WHERE sprints_tasks.task_id=tasks.id
    SQL
  end
  
  def down
    remove_column :sprints_tasks, :checked_out_at
    remove_column :sprints_tasks, :checked_out_by_id
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version Path
houston-core-0.5.0.beta1 db/migrate/20140921190022_add_checked_out_to_sprints_tasks.rb