class EnsureIndexesInPlace < ActiveRecord::Migration def change #users_perms remove_foreign_key :users_perms, :perms remove_foreign_key :users_perms, :users remove_index :users_perms, name: 'index_users_perms_on_user_id_and_perm_id' add_index :users_perms, :user_id add_foreign_key :users_perms, :perms add_foreign_key :users_perms, :users #user_identifiers add_index :user_identifiers, :user_id #roles add_index :roles, :user_id add_index :roles, :plan_id #org_token_permissions add_index :org_token_permissions, :org_id #users add_index :users, :org_id remove_index :users, :confirmation_token remove_index :users, :invitation_token remove_index :users, :reset_password_token #notes add_index :notes, :answer_id #guidance_groups add_index :guidance_groups, :org_id #guidance add_index :guidances, :guidance_group_id #themes_in_guidance add_index :themes_in_guidance, :theme_id add_index :themes_in_guidance, :guidance_id #annotations add_index :annotations, :question_id #question_themes remove_foreign_key :questions_themes, :questions remove_foreign_key :questions_themes, :themes remove_index :questions_themes, name: 'question_theme_index' remove_index :questions_themes, name: 'theme_question_index' add_index :questions_themes, :question_id add_foreign_key :questions_themes, :questions add_foreign_key :questions_themes, :themes #question_options add_index :question_options, :question_id #answers_question_options remove_foreign_key :answers_question_options, :answers remove_foreign_key :answers_question_options, :question_options remove_index :answers_question_options, name: 'answer_question_option_index' remove_index :answers_question_options, name: 'question_option_answer_index' add_index :answers_question_options, :answer_id add_foreign_key :answers_question_options, :answers add_foreign_key :answers_question_options, :question_options end end