check for indexes that might not exist

1 files changed, 8 insertions, 2 deletions

diff --git a/db/migrate/20200227214439_modify_status_index.rb b/db/migrate/20200227214439_modify_status_index.rb
index df8ca263a..2f4e98da5 100644
--- a/db/migrate/20200227214439_modify_status_index.rb
+++ b/db/migrate/20200227214439_modify_status_index.rb
@@ -1,9 +1,15 @@
 class ModifyStatusIndex < ActiveRecord::Migration[5.2]
   def up
     remove_index :statuses, name: :index_statuses_20190820
-    remove_index :statuses, name: :index_statuses_on_account_id_and_id_and_visibility_not_hidden
+    if index_exists? :statuses, name: :index_statuses_on_account_id_and_id_and_visibility_not_hidden
+      remove_index :statuses, name: :index_statuses_on_account_id_and_id_and_visibility_not_hidden
+    end
+
     remove_index :statuses, name: :index_statuses_on_account_id_and_id_and_visibility
-    remove_index :statuses, name: :index_statuses_local_20190824
+
+    if index_exists? :statuses, name: :index_statuses_local_20190824
+      remove_index :statuses, name: :index_statuses_local_20190824
+    end
 
     safety_assured do
       add_index :statuses, [:account_id, :id, :visibility, :updated_at], where: '(deleted_at IS NULL) AND (NOT hidden)', order: { id: :desc }, name: :index_statuses_20200301