summaryrefslogtreecommitdiff
path: root/db/migrate/20191205212923_support_multiple_milestones_for_issues.rb
blob: e0edd76c4b93f79700b1f57861303f08a3c025b0 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
# frozen_string_literal: true

class SupportMultipleMilestonesForIssues < ActiveRecord::Migration[5.2]
  DOWNTIME = false

  def change
    create_table :issue_milestones, id: false do |t|
      t.references :issue, foreign_key: { on_delete: :cascade }, index: { unique: true }, null: false
      t.references :milestone, foreign_key: { on_delete: :cascade }, index: true, null: false
    end

    add_index :issue_milestones, [:issue_id, :milestone_id], unique: true
  end
end