1 files changed, 0 insertions, 43 deletions
diff --git a/db/migrate/20201111152859_add_missing_expression_indexes.rb b/db/migrate/20201111152859_add_missing_expression_indexes.rb
deleted file mode 100644
index e2742f7f3bc..00000000000
--- a/db/migrate/20201111152859_add_missing_expression_indexes.rb
+++ /dev/null
@@ -1,43 +0,0 @@
-# frozen_string_literal: true
-
-class AddMissingExpressionIndexes < ActiveRecord::Migration[6.0]
-  include Gitlab::Database::MigrationHelpers
-
-  DOWNTIME = false
-
-  disable_ddl_transaction!
-
-  INDEXES = [
-    [:namespaces, :index_on_namespaces_lower_name, 'LOWER(name)'],
-    [:namespaces, :index_on_namespaces_lower_path, 'LOWER(path)'],
-    [:projects, :index_on_projects_lower_path, 'LOWER(path)'],
-    [:routes, :index_on_routes_lower_path, 'LOWER(path)'],
-    [:users, :index_on_users_lower_username, 'LOWER(username)'],
-    [:users, :index_on_users_lower_email, 'LOWER(email)']
-  ]
-
-  def up
-    # Those indexes had been introduced before, but they haven't been
-    # captured in structure.sql. For installations that already have it,
-    # this is a no-op - others will get it retroactively with
-    # this migration.
-
-    tables = Set.new
-
-    INDEXES.each do |(table, name, expression)|
-      unless index_name_exists?(table, name)
-        add_concurrent_index table, expression, name: name
-        tables.add(table)
-      end
-    end
-
-    # Rebuild statistics on affected tables only
-    tables.each do |table|
-      execute("ANALYZE #{table}")
-    end
-  end
-
-  def down
-    # no-op
-  end
-end