55 lines
1.9 KiB
Ruby
55 lines
1.9 KiB
Ruby
class DropDuplicateIndexes < ActiveRecord::Migration[7.2]
|
|
def change
|
|
# already covered by index_domain_fa_fav_id_and_dates_on_user_id_and_post_fa_id
|
|
remove_index :domain_fa_fav_id_and_dates, :user_id
|
|
|
|
remove_index :domain_post_files_bluesky_aux,
|
|
:base_table_id,
|
|
name: :index_domain_post_files_bluesky_aux_on_base_table_id
|
|
|
|
remove_index :domain_post_files_inkbunny_aux,
|
|
:base_table_id,
|
|
name: :index_domain_post_files_inkbunny_aux_on_base_table_id
|
|
|
|
remove_index :domain_posts_bluesky_aux,
|
|
:base_table_id,
|
|
name: :index_domain_posts_bluesky_aux_on_base_table_id
|
|
|
|
remove_index :domain_posts_e621_aux,
|
|
:base_table_id,
|
|
name: :index_domain_posts_e621_aux_on_base_table_id
|
|
|
|
remove_index :domain_posts_fa_aux,
|
|
:base_table_id,
|
|
name: :index_domain_posts_fa_aux_on_base_table_id
|
|
|
|
remove_index :domain_posts_ib_aux,
|
|
:base_table_id,
|
|
name: :index_domain_posts_ib_aux_on_base_table_id
|
|
|
|
remove_index :domain_users_bluesky_aux,
|
|
:base_table_id,
|
|
name: :index_domain_users_bluesky_aux_on_base_table_id
|
|
|
|
remove_index :domain_users_e621_aux,
|
|
:base_table_id,
|
|
name: :index_domain_users_e621_aux_on_base_table_id
|
|
|
|
remove_index :domain_users_fa_aux,
|
|
:base_table_id,
|
|
name: :index_domain_users_fa_aux_on_base_table_id
|
|
|
|
remove_index :domain_users_inkbunny_aux,
|
|
:base_table_id,
|
|
name: :index_domain_users_inkbunny_aux_on_base_table_id
|
|
|
|
remove_index :telegram_bot_logs,
|
|
:telegram_user_id,
|
|
name: :index_telegram_bot_logs_on_telegram_user_id
|
|
|
|
remove_index :domain_user_search_names,
|
|
:user_id,
|
|
name: :index_domain_user_search_names_on_user_id
|
|
end
|
|
end
|