diff options
author | GitLab Bot <gitlab-bot@gitlab.com> | 2024-01-13 18:08:01 +0300 |
---|---|---|
committer | GitLab Bot <gitlab-bot@gitlab.com> | 2024-01-13 18:08:01 +0300 |
commit | 771b1b5084e6f8826f85c6a6a2dd13e401755ed7 (patch) | |
tree | 2c9a095e5f016cd583144c377d4596c36274b9ea | |
parent | 966806833972e3ba3748e001acd8da1fc9c17fd7 (diff) |
Add latest changes from gitlab-org/gitlab@master
-rw-r--r-- | db/post_migrate/20240110132029_re_remove_requirements_ignored_columns.rb | 47 | ||||
-rw-r--r-- | db/schema_migrations/20240110132029 | 1 | ||||
-rw-r--r-- | db/structure.sql | 23 |
3 files changed, 48 insertions, 23 deletions
diff --git a/db/post_migrate/20240110132029_re_remove_requirements_ignored_columns.rb b/db/post_migrate/20240110132029_re_remove_requirements_ignored_columns.rb new file mode 100644 index 00000000000..e6d85761a14 --- /dev/null +++ b/db/post_migrate/20240110132029_re_remove_requirements_ignored_columns.rb @@ -0,0 +1,47 @@ +# frozen_string_literal: true + +class ReRemoveRequirementsIgnoredColumns < Gitlab::Database::Migration[2.2] + milestone '16.8' + + disable_ddl_transaction! + + CONSTRAINT_NAME = 'check_785ae25b9d' + NAME_INDEX = 'index_requirements_on_title_trigram' + FOREIGN_KEY = 'fk_rails_33fed8aa4e' + + def up + remove_column(:requirements, :created_at, if_exists: true) + remove_column(:requirements, :updated_at, if_exists: true) + remove_column(:requirements, :cached_markdown_version, if_exists: true) + remove_column(:requirements, :state, if_exists: true) + remove_column(:requirements, :title, if_exists: true) + remove_column(:requirements, :title_html, if_exists: true) + remove_column(:requirements, :description, if_exists: true) + remove_column(:requirements, :description_html, if_exists: true) + with_lock_retries do + remove_column(:requirements, :author_id, if_exists: true) + end + end + + def down + add_column(:requirements, :created_at, :datetime_with_timezone, if_not_exists: true) + add_column(:requirements, :updated_at, :datetime_with_timezone, if_not_exists: true) + add_column(:requirements, :author_id, :integer, if_not_exists: true) + add_column(:requirements, :cached_markdown_version, :integer, if_not_exists: true) + add_column(:requirements, :state, :smallint, default: 1, if_not_exists: true) + add_column(:requirements, :title, :string, limit: 255, if_not_exists: true) + add_column(:requirements, :title_html, :text, if_not_exists: true) + add_column(:requirements, :description, :text, if_not_exists: true) + add_column(:requirements, :description_html, :text, if_not_exists: true) + + add_check_constraint(:requirements, "char_length(description) <= 10000", CONSTRAINT_NAME) + + add_concurrent_foreign_key(:requirements, :users, column: :author_id, name: FOREIGN_KEY, on_delete: :nullify) + + add_concurrent_index(:requirements, :created_at) + add_concurrent_index(:requirements, :updated_at) + add_concurrent_index(:requirements, :author_id) + add_concurrent_index(:requirements, :state) + add_concurrent_index(:requirements, :title, name: NAME_INDEX, using: :gin, opclass: { name: :gin_trgm_ops }) + end +end diff --git a/db/schema_migrations/20240110132029 b/db/schema_migrations/20240110132029 new file mode 100644 index 00000000000..e707c5a4112 --- /dev/null +++ b/db/schema_migrations/20240110132029 @@ -0,0 +1 @@ +ac490ec281f23857fa6300678404895b20fbc60d9bc6ed22c46189df371f90d6
\ No newline at end of file diff --git a/db/structure.sql b/db/structure.sql index 26f7cac786d..b7368d8b289 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -23213,19 +23213,9 @@ ALTER SEQUENCE required_code_owners_sections_id_seq OWNED BY required_code_owner CREATE TABLE requirements ( id bigint NOT NULL, - created_at timestamp with time zone, - updated_at timestamp with time zone, project_id integer NOT NULL, - author_id integer, iid integer NOT NULL, - cached_markdown_version integer, - state smallint DEFAULT 1, - title character varying(255), - title_html text, - description text, - description_html text, issue_id bigint, - CONSTRAINT check_785ae25b9d CHECK ((char_length(description) <= 10000)), CONSTRAINT check_requirement_issue_not_null CHECK ((issue_id IS NOT NULL)) ); @@ -35139,22 +35129,12 @@ CREATE INDEX index_requirements_management_test_reports_on_build_id ON requireme CREATE INDEX index_requirements_management_test_reports_on_issue_id ON requirements_management_test_reports USING btree (issue_id); -CREATE INDEX index_requirements_on_author_id ON requirements USING btree (author_id); - -CREATE INDEX index_requirements_on_created_at ON requirements USING btree (created_at); - CREATE UNIQUE INDEX index_requirements_on_issue_id ON requirements USING btree (issue_id); CREATE INDEX index_requirements_on_project_id ON requirements USING btree (project_id); CREATE UNIQUE INDEX index_requirements_on_project_id_and_iid ON requirements USING btree (project_id, iid) WHERE (project_id IS NOT NULL); -CREATE INDEX index_requirements_on_state ON requirements USING btree (state); - -CREATE INDEX index_requirements_on_title_trigram ON requirements USING gin (title gin_trgm_ops); - -CREATE INDEX index_requirements_on_updated_at ON requirements USING btree (updated_at); - CREATE INDEX index_requirements_project_id_user_id_id_and_target_type ON todos USING btree (project_id, user_id, id, target_type); CREATE INDEX index_requirements_user_id_and_target_type ON todos USING btree (user_id, target_type); @@ -39624,9 +39604,6 @@ ALTER TABLE ONLY alert_management_alert_metric_images ALTER TABLE ONLY suggestions ADD CONSTRAINT fk_rails_33b03a535c FOREIGN KEY (note_id) REFERENCES notes(id) ON DELETE CASCADE; -ALTER TABLE ONLY requirements - ADD CONSTRAINT fk_rails_33fed8aa4e FOREIGN KEY (author_id) REFERENCES users(id) ON DELETE SET NULL; - ALTER TABLE ONLY metrics_dashboard_annotations ADD CONSTRAINT fk_rails_345ab51043 FOREIGN KEY (cluster_id) REFERENCES clusters(id) ON DELETE CASCADE; |