about summary refs log tree commit diff
path: root/db/migrate/20200510181721_remove_duplicated_indexes_pghero.rb
diff options
context:
space:
mode:
authorLerk <lukas@k40s.net>2020-06-25 12:15:34 +0200
committerGitHub <noreply@github.com>2020-06-25 12:15:34 +0200
commit62ef6406cd67170d3eb57d2a1d55fb074a9d603c (patch)
treeb6e9794659c837b284f5f03b24cb9c2eefeba45e /db/migrate/20200510181721_remove_duplicated_indexes_pghero.rb
parent0f8b8bf126b5c7f9a7257dc0c693827db1d4f436 (diff)
remove duplicated indexes according to pghero (#13695)
Diffstat (limited to 'db/migrate/20200510181721_remove_duplicated_indexes_pghero.rb')
-rw-r--r--db/migrate/20200510181721_remove_duplicated_indexes_pghero.rb12
1 files changed, 12 insertions, 0 deletions
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
+