20140625115202_create_users_star_projects.rb 581 Bytes
Newer Older
1
# rubocop:disable all
2
class CreateUsersStarProjects < ActiveRecord::Migration[4.2]
3 4
  DOWNTIME = false

Ciro Santilli's avatar
Ciro Santilli committed
5 6 7 8
  def change
    create_table :users_star_projects do |t|
      t.integer :project_id, null: false
      t.integer :user_id, null: false
9
      t.timestamps null: true
Ciro Santilli's avatar
Ciro Santilli committed
10 11 12 13
    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
14 15 16

    add_column :projects, :star_count, :integer, default: 0, null: false
    add_index :projects, :star_count, using: :btree
Ciro Santilli's avatar
Ciro Santilli committed
17 18
  end
end