summaryrefslogtreecommitdiff
path: root/db/migrate/20140625115202_create_users_star_projects.rb
blob: d4f3fe5ac6226bf03fbc5666d3b4b446c5ce3f63 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
# rubocop:disable all
class CreateUsersStarProjects < ActiveRecord::Migration
  DOWNTIME = false

  def change
    create_table :users_star_projects do |t|
      t.integer :project_id, null: false
      t.integer :user_id, null: false
      t.timestamps null: true
    end
    add_index :users_star_projects, :user_id
    add_index :users_star_projects, :project_id
    add_index :users_star_projects, [:user_id, :project_id], unique: true

    add_column :projects, :star_count, :integer, default: 0, null: false
    add_index :projects, :star_count, using: :btree
  end
end