From 6b5d8b17e28741bccf31029633cc5af7ceab1486 Mon Sep 17 00:00:00 2001 From: GitLab Bot Date: Wed, 18 May 2022 18:08:05 +0000 Subject: Add latest changes from gitlab-org/gitlab@master --- db/structure.sql | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) (limited to 'db/structure.sql') diff --git a/db/structure.sql b/db/structure.sql index fa9d9e8f778..396cf191475 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -11767,6 +11767,8 @@ CREATE TABLE batched_background_migrations ( max_batch_size integer, started_at timestamp with time zone, on_hold_until timestamp with time zone, + gitlab_schema text NOT NULL, + CONSTRAINT check_0406d9776f CHECK ((char_length(gitlab_schema) <= 255)), CONSTRAINT check_5bb0382d6f CHECK ((char_length(column_name) <= 63)), CONSTRAINT check_6b6a06254a CHECK ((char_length(table_name) <= 63)), CONSTRAINT check_batch_size_in_range CHECK ((batch_size >= sub_batch_size)), @@ -26911,6 +26913,8 @@ CREATE INDEX index_batched_jobs_by_batched_migration_id_and_id ON batched_backgr CREATE INDEX index_batched_jobs_on_batched_migration_id_and_status ON batched_background_migration_jobs USING btree (batched_background_migration_id, status); +CREATE UNIQUE INDEX index_batched_migrations_on_gl_schema_and_unique_configuration ON batched_background_migrations USING btree (gitlab_schema, job_class_name, table_name, column_name, job_arguments); + CREATE INDEX index_board_assignees_on_assignee_id ON board_assignees USING btree (assignee_id); CREATE UNIQUE INDEX index_board_assignees_on_board_id_and_assignee_id ON board_assignees USING btree (board_id, assignee_id); @@ -28425,6 +28429,8 @@ CREATE INDEX index_notes_on_author_id_and_created_at_and_id ON notes USING btree CREATE INDEX index_notes_on_commit_id ON notes USING btree (commit_id); +CREATE INDEX index_notes_on_confidential ON notes USING btree (confidential) WHERE (confidential = true); + CREATE INDEX index_notes_on_created_at ON notes USING btree (created_at); CREATE INDEX index_notes_on_discussion_id ON notes USING btree (discussion_id); @@ -33118,9 +33124,6 @@ ALTER TABLE ONLY approval_project_rules_users ALTER TABLE ONLY lists ADD CONSTRAINT fk_rails_baed5f39b7 FOREIGN KEY (milestone_id) REFERENCES milestones(id) ON DELETE CASCADE; -ALTER TABLE web_hook_logs - ADD CONSTRAINT fk_rails_bb3355782d FOREIGN KEY (web_hook_id) REFERENCES web_hooks(id) ON DELETE CASCADE; - ALTER TABLE ONLY security_findings ADD CONSTRAINT fk_rails_bb63863cf1 FOREIGN KEY (scan_id) REFERENCES security_scans(id) ON DELETE CASCADE; -- cgit v1.2.3