cirandas.net

ref: master

db/migrate/20140708123314_index_role_assignments_filtered_fields.rb


 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
class IndexRoleAssignmentsFilteredFields < ActiveRecord::Migration

  def self.up
    add_index :role_assignments, [:accessor_id, :accessor_type]
    add_index :role_assignments, [:accessor_id, :accessor_type, :role_id], name: :index_on_role_assigments_accessor_role
    add_index :role_assignments, [:resource_id, :resource_type]
    add_index :role_assignments, [:resource_id, :resource_type, :role_id], name: :index_on_role_assigments_resource_role
    add_index :role_assignments, [:accessor_id, :accessor_type, :resource_id, :resource_type], name: :index_on_role_assigments_accessor_resource_role
    add_index :profiles, [:type]
    add_index :profiles, [:visible]
    add_index :profiles, [:enabled]
    add_index :profiles, [:validated]
  end

end