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 |