db/migrate/20180223120443_create_user_interacted_projects_table.rb


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

class CreateUserInteractedProjectsTable < ActiveRecord::Migration[4.2]
  include Gitlab::Database::MigrationHelpers

  DOWNTIME = false

  INDEX_NAME = 'user_interacted_projects_non_unique_index'

  def up
    create_table :user_interacted_projects, id: false do |t|
      t.references :user, null: false
      t.references :project, null: false
    end

    add_index :user_interacted_projects, [:project_id, :user_id], name: INDEX_NAME
  end

  def down
    drop_table :user_interacted_projects
  end
end