summaryrefslogtreecommitdiff
path: root/db/migrate/20170623183807_add_group_id_to_milestones.rb
blob: ab98905ac53ed6bc090f603eff519395eade4110 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
class AddGroupIdToMilestones < ActiveRecord::Migration
  DOWNTIME = false

  def up
    change_column_null :milestones, :project_id, true

    add_column :milestones, :group_id, :integer
  end

  def down
    remove_column :milestones, :group_id
    change_column_null :milestones, :project_id, true

    # We cannot rollback project_id not null constraint if there are records
    # with null values.
    execute "DELETE from milestones WHERE project_id IS NULL"
  end
end