diff options
author | GitLab Bot <gitlab-bot@gitlab.com> | 2023-05-03 18:08:43 +0000 |
---|---|---|
committer | GitLab Bot <gitlab-bot@gitlab.com> | 2023-05-03 18:08:43 +0000 |
commit | 03717bbc9fa4112a0cbc48f613f416f2aa1c6cbb (patch) | |
tree | a7b2d1c4175d725538e0b72e6f5aec33dc9b3d4d /db | |
parent | 27a5080c34c64a84219d855d652b994c5e344a0a (diff) | |
download | gitlab-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.rb | 15 | ||||
-rw-r--r-- | db/schema_migrations/20230503032750 | 1 | ||||
-rw-r--r-- | db/structure.sql | 2 |
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); |