From 62ef6406cd67170d3eb57d2a1d55fb074a9d603c Mon Sep 17 00:00:00 2001 From: Lerk Date: Thu, 25 Jun 2020 12:15:34 +0200 Subject: remove duplicated indexes according to pghero (#13695) --- .../20200510181721_remove_duplicated_indexes_pghero.rb | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 db/migrate/20200510181721_remove_duplicated_indexes_pghero.rb (limited to 'db/migrate') diff --git a/db/migrate/20200510181721_remove_duplicated_indexes_pghero.rb b/db/migrate/20200510181721_remove_duplicated_indexes_pghero.rb new file mode 100644 index 000000000..e2eaf46f1 --- /dev/null +++ b/db/migrate/20200510181721_remove_duplicated_indexes_pghero.rb @@ -0,0 +1,12 @@ +class RemoveDuplicatedIndexesPghero < ActiveRecord::Migration[5.2] + def change + remove_index :account_conversations, name: "index_account_conversations_on_account_id", column: :account_id + remove_index :account_identity_proofs, name: "index_account_identity_proofs_on_account_id", column: :account_id + remove_index :account_pins, name: "index_account_pins_on_account_id", column: :account_id + remove_index :announcement_mutes, name: "index_announcement_mutes_on_account_id", column: :account_id + remove_index :announcement_reactions, name: "index_announcement_reactions_on_account_id", column: :account_id + remove_index :bookmarks, name: "index_bookmarks_on_account_id", column: :account_id + remove_index :markers, name: "index_markers_on_user_id", column: :user_id + end +end + -- cgit