summaryrefslogtreecommitdiff
path: root/db/migrate/20180531185349_add_repository_languages.rb
blob: 26a01c3bb26ce0e424654c0f49d75b15bfd16208 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
class AddRepositoryLanguages < ActiveRecord::Migration[4.2]
  include Gitlab::Database::MigrationHelpers

  DOWNTIME = false

  def up
    create_table(:programming_languages) do |t|
      t.string :name, null: false
      t.string :color, null: false
      t.datetime_with_timezone :created_at, null: false
    end

    create_table(:repository_languages, id: false) do |t|
      t.references :project, null: false, foreign_key: { on_delete: :cascade }
      t.references :programming_language, null: false
      t.float :share, null: false
    end

    add_index :programming_languages, :name, unique: true
    add_index :repository_languages, [:project_id, :programming_language_id],
      unique: true, name: "index_repository_languages_on_project_and_languages_id"
  end

  def down
    drop_table :repository_languages
    drop_table :programming_languages
  end
end