summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorGitLab Bot <gitlab-bot@gitlab.com>2023-05-03 18:08:43 +0000
committerGitLab Bot <gitlab-bot@gitlab.com>2023-05-03 18:08:43 +0000
commit03717bbc9fa4112a0cbc48f613f416f2aa1c6cbb (patch)
treea7b2d1c4175d725538e0b72e6f5aec33dc9b3d4d /db
parent27a5080c34c64a84219d855d652b994c5e344a0a (diff)
downloadgitlab-ce-03717bbc9fa4112a0cbc48f613f416f2aa1c6cbb.tar.gz
Add latest changes from gitlab-org/gitlab@master
Diffstat (limited to 'db')
-rw-r--r--db/post_migrate/20230503032750_remove_redundant_index_from_container_repositories.rb15
-rw-r--r--db/schema_migrations/202305030327501
-rw-r--r--db/structure.sql2
3 files changed, 16 insertions, 2 deletions
diff --git a/db/post_migrate/20230503032750_remove_redundant_index_from_container_repositories.rb b/db/post_migrate/20230503032750_remove_redundant_index_from_container_repositories.rb
new file mode 100644
index 00000000000..a538dc054bb
--- /dev/null
+++ b/db/post_migrate/20230503032750_remove_redundant_index_from_container_repositories.rb
@@ -0,0 +1,15 @@
+# frozen_string_literal: true
+
+class RemoveRedundantIndexFromContainerRepositories < Gitlab::Database::Migration[2.1]
+ disable_ddl_transaction!
+
+ INDEX_NAME = 'index_container_repositories_on_project_id'
+
+ def up
+ remove_concurrent_index_by_name :container_repositories, INDEX_NAME
+ end
+
+ def down
+ add_concurrent_index :container_repositories, :project_id, name: INDEX_NAME
+ end
+end
diff --git a/db/schema_migrations/20230503032750 b/db/schema_migrations/20230503032750
new file mode 100644
index 00000000000..fd4a7dff047
--- /dev/null
+++ b/db/schema_migrations/20230503032750
@@ -0,0 +1 @@
+1d8dc513156e6fcdfdd8670eb92c67fc261135527398310a089b8d6c5d70c213 \ No newline at end of file
diff --git a/db/structure.sql b/db/structure.sql
index 7f07a820220..ce4aadefaeb 100644
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -30482,8 +30482,6 @@ CREATE INDEX index_container_repositories_on_greatest_completed_at ON container_
CREATE INDEX index_container_repositories_on_migration_state_import_done_at ON container_repositories USING btree (migration_state, migration_import_done_at);
-CREATE INDEX index_container_repositories_on_project_id ON container_repositories USING btree (project_id);
-
CREATE INDEX index_container_repositories_on_project_id_and_id ON container_repositories USING btree (project_id, id);
CREATE UNIQUE INDEX index_container_repositories_on_project_id_and_name ON container_repositories USING btree (project_id, name);