diff --git a/db/post_migrate/20240617160520_remove_imported_column_on_design_management_designs.rb b/db/post_migrate/20240617160520_remove_imported_column_on_design_management_designs.rb new file mode 100644 index 0000000000000000000000000000000000000000..8cb37f471d68db631001c68222e64df81f356613 --- /dev/null +++ b/db/post_migrate/20240617160520_remove_imported_column_on_design_management_designs.rb @@ -0,0 +1,13 @@ +# frozen_string_literal: true + +class RemoveImportedColumnOnDesignManagementDesigns < Gitlab::Database::Migration[2.2] + milestone '17.2' + + def up + remove_column :design_management_designs, :imported + end + + def down + add_column :design_management_designs, :imported, :integer, default: 0, null: false, limit: 2 + end +end diff --git a/db/post_migrate/20240617161159_remove_imported_column_on_events.rb b/db/post_migrate/20240617161159_remove_imported_column_on_events.rb new file mode 100644 index 0000000000000000000000000000000000000000..900f845068b145488c53e410fae75ba5ff9c80ac --- /dev/null +++ b/db/post_migrate/20240617161159_remove_imported_column_on_events.rb @@ -0,0 +1,13 @@ +# frozen_string_literal: true + +class RemoveImportedColumnOnEvents < Gitlab::Database::Migration[2.2] + milestone '17.2' + + def up + remove_column :events, :imported + end + + def down + add_column :events, :imported, :integer, default: 0, null: false, limit: 2 + end +end diff --git a/db/post_migrate/20240617161346_remove_imported_column_on_issues.rb b/db/post_migrate/20240617161346_remove_imported_column_on_issues.rb new file mode 100644 index 0000000000000000000000000000000000000000..0865320a157ba0f535cd7f65364981d887a8a240 --- /dev/null +++ b/db/post_migrate/20240617161346_remove_imported_column_on_issues.rb @@ -0,0 +1,13 @@ +# frozen_string_literal: true + +class RemoveImportedColumnOnIssues < Gitlab::Database::Migration[2.2] + milestone '17.2' + + def up + remove_column :issues, :imported + end + + def down + add_column :issues, :imported, :integer, default: 0, null: false, limit: 2 + end +end diff --git a/db/post_migrate/20240617161502_remove_imported_column_on_merge_requests.rb b/db/post_migrate/20240617161502_remove_imported_column_on_merge_requests.rb new file mode 100644 index 0000000000000000000000000000000000000000..e0eebc63a044922713cdfa8f32f1f714919a7ce5 --- /dev/null +++ b/db/post_migrate/20240617161502_remove_imported_column_on_merge_requests.rb @@ -0,0 +1,13 @@ +# frozen_string_literal: true + +class RemoveImportedColumnOnMergeRequests < Gitlab::Database::Migration[2.2] + milestone '17.2' + + def up + remove_column :merge_requests, :imported + end + + def down + add_column :merge_requests, :imported, :integer, default: 0, null: false, limit: 2 + end +end diff --git a/db/post_migrate/20240617161555_remove_imported_column_on_notes.rb b/db/post_migrate/20240617161555_remove_imported_column_on_notes.rb new file mode 100644 index 0000000000000000000000000000000000000000..af67649b44919da6d61d739b32f735b3d5f3743b --- /dev/null +++ b/db/post_migrate/20240617161555_remove_imported_column_on_notes.rb @@ -0,0 +1,13 @@ +# frozen_string_literal: true + +class RemoveImportedColumnOnNotes < Gitlab::Database::Migration[2.2] + milestone '17.2' + + def up + remove_column :notes, :imported + end + + def down + add_column :notes, :imported, :integer, default: 0, null: false, limit: 2 + end +end diff --git a/db/post_migrate/20240617161643_remove_imported_column_on_resource_label_events.rb b/db/post_migrate/20240617161643_remove_imported_column_on_resource_label_events.rb new file mode 100644 index 0000000000000000000000000000000000000000..520677c8a2f6c215398f3e74fcbe28a198190a75 --- /dev/null +++ b/db/post_migrate/20240617161643_remove_imported_column_on_resource_label_events.rb @@ -0,0 +1,13 @@ +# frozen_string_literal: true + +class RemoveImportedColumnOnResourceLabelEvents < Gitlab::Database::Migration[2.2] + milestone '17.2' + + def up + remove_column :resource_label_events, :imported + end + + def down + add_column :resource_label_events, :imported, :integer, default: 0, null: false, limit: 2 + end +end diff --git a/db/post_migrate/20240617161753_remove_imported_column_on_resource_milestone_events.rb b/db/post_migrate/20240617161753_remove_imported_column_on_resource_milestone_events.rb new file mode 100644 index 0000000000000000000000000000000000000000..ee7e48e0bffa0af91ca32308fd9717cb4848c57f --- /dev/null +++ b/db/post_migrate/20240617161753_remove_imported_column_on_resource_milestone_events.rb @@ -0,0 +1,13 @@ +# frozen_string_literal: true + +class RemoveImportedColumnOnResourceMilestoneEvents < Gitlab::Database::Migration[2.2] + milestone '17.2' + + def up + remove_column :resource_milestone_events, :imported + end + + def down + add_column :resource_milestone_events, :imported, :integer, default: 0, null: false, limit: 2 + end +end diff --git a/db/post_migrate/20240617161845_remove_imported_column_on_resource_state_events.rb b/db/post_migrate/20240617161845_remove_imported_column_on_resource_state_events.rb new file mode 100644 index 0000000000000000000000000000000000000000..ab73afdbfa5a04d285fbaca38838b63adad52b36 --- /dev/null +++ b/db/post_migrate/20240617161845_remove_imported_column_on_resource_state_events.rb @@ -0,0 +1,13 @@ +# frozen_string_literal: true + +class RemoveImportedColumnOnResourceStateEvents < Gitlab::Database::Migration[2.2] + milestone '17.2' + + def up + remove_column :resource_state_events, :imported + end + + def down + add_column :resource_state_events, :imported, :integer, default: 0, null: false, limit: 2 + end +end diff --git a/db/post_migrate/20240617161951_remove_imported_column_on_snippets.rb b/db/post_migrate/20240617161951_remove_imported_column_on_snippets.rb new file mode 100644 index 0000000000000000000000000000000000000000..4adb2b5c09b4a8d39d4f33d0dc4bd5a663e915cd --- /dev/null +++ b/db/post_migrate/20240617161951_remove_imported_column_on_snippets.rb @@ -0,0 +1,13 @@ +# frozen_string_literal: true + +class RemoveImportedColumnOnSnippets < Gitlab::Database::Migration[2.2] + milestone '17.2' + + def up + remove_column :snippets, :imported + end + + def down + add_column :snippets, :imported, :integer, default: 0, null: false, limit: 2 + end +end diff --git a/db/schema_migrations/20240617160520 b/db/schema_migrations/20240617160520 new file mode 100644 index 0000000000000000000000000000000000000000..032c6fe0e6490eca527ff5a0e3ed828dab358e01 --- /dev/null +++ b/db/schema_migrations/20240617160520 @@ -0,0 +1 @@ +8db45462581d0bdce23eb2da53af92f6e9f707eed2569746ddc0d0b01be0047c \ No newline at end of file diff --git a/db/schema_migrations/20240617161159 b/db/schema_migrations/20240617161159 new file mode 100644 index 0000000000000000000000000000000000000000..d20a75b35fd93eac5eec1d0266c74c2182465691 --- /dev/null +++ b/db/schema_migrations/20240617161159 @@ -0,0 +1 @@ +3c3413b504d4db871b1162a3456263944f03e7efc5207cb2ddbe8602597db7ee \ No newline at end of file diff --git a/db/schema_migrations/20240617161346 b/db/schema_migrations/20240617161346 new file mode 100644 index 0000000000000000000000000000000000000000..734cab59ec0519d9675a43b4a524d7ee9e8822f3 --- /dev/null +++ b/db/schema_migrations/20240617161346 @@ -0,0 +1 @@ +e5a6467d186ec85b38feb7fb94231ca63714bcf4867a76da74c71ed5e7e01b05 \ No newline at end of file diff --git a/db/schema_migrations/20240617161502 b/db/schema_migrations/20240617161502 new file mode 100644 index 0000000000000000000000000000000000000000..16cdf81c7bc538cbf3c11890286b1f79f4b8ba9c --- /dev/null +++ b/db/schema_migrations/20240617161502 @@ -0,0 +1 @@ +6688efd3cafd26994ec14b7460914cddf74af6f636de9148494c774305b20373 \ No newline at end of file diff --git a/db/schema_migrations/20240617161555 b/db/schema_migrations/20240617161555 new file mode 100644 index 0000000000000000000000000000000000000000..5ed3433f83c4e3ec119b967b32b7f8a52b00b5e2 --- /dev/null +++ b/db/schema_migrations/20240617161555 @@ -0,0 +1 @@ +6b188bd456daf99f88e52b846c99edf3ccfdf099354d34bcc0429cbcac2b3768 \ No newline at end of file diff --git a/db/schema_migrations/20240617161643 b/db/schema_migrations/20240617161643 new file mode 100644 index 0000000000000000000000000000000000000000..04e5da458ae0ef711193568f0edbfeccb4ce2bf4 --- /dev/null +++ b/db/schema_migrations/20240617161643 @@ -0,0 +1 @@ +0d2c85e9d3a0f5a3e63908575ee45486cec9b1aa70b292ad184cd5a9e372788f \ No newline at end of file diff --git a/db/schema_migrations/20240617161753 b/db/schema_migrations/20240617161753 new file mode 100644 index 0000000000000000000000000000000000000000..5de2f419d5cd4cc78f9ff771500925bff0f6d5ac --- /dev/null +++ b/db/schema_migrations/20240617161753 @@ -0,0 +1 @@ +2c4b550ac5fad69332a56ddaca7492586ae11dcab4e686853fe9df1813c265ae \ No newline at end of file diff --git a/db/schema_migrations/20240617161845 b/db/schema_migrations/20240617161845 new file mode 100644 index 0000000000000000000000000000000000000000..c92da8fab524a4c7229861324d5404088971ba1f --- /dev/null +++ b/db/schema_migrations/20240617161845 @@ -0,0 +1 @@ +0e15662b9ec2d99b242661070a52ac2fd19d00113778d5b660a232cbc595b18d \ No newline at end of file diff --git a/db/schema_migrations/20240617161951 b/db/schema_migrations/20240617161951 new file mode 100644 index 0000000000000000000000000000000000000000..7c7251e34608d04b508e265a016853c5eb176307 --- /dev/null +++ b/db/schema_migrations/20240617161951 @@ -0,0 +1 @@ +6cfe6d8fc12d0d259a53518decfbe6e053a98947f69e5d3a1ab9eefd1ddc902c \ No newline at end of file diff --git a/db/structure.sql b/db/structure.sql index 10e5c317d34b23032f1c96ed98cb87544777f01b..2b558c7bc6fc107c6d4cd7dacf8a79fda4164221 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -9441,7 +9441,6 @@ CREATE TABLE design_management_designs ( cached_markdown_version integer, description text, description_html text, - imported smallint DEFAULT 0 NOT NULL, imported_from smallint DEFAULT 0 NOT NULL, namespace_id bigint, CONSTRAINT check_07155e2715 CHECK ((char_length((filename)::text) <= 255)), @@ -10060,7 +10059,6 @@ CREATE TABLE events ( fingerprint bytea, id bigint NOT NULL, target_id bigint, - imported smallint DEFAULT 0 NOT NULL, imported_from smallint DEFAULT 0 NOT NULL, CONSTRAINT check_97e06e05ad CHECK ((octet_length(fingerprint) <= 128)) ); @@ -11538,7 +11536,6 @@ CREATE TABLE issues ( namespace_id bigint, start_date date, tmp_epic_id bigint, - imported smallint DEFAULT 0 NOT NULL, imported_from smallint DEFAULT 0 NOT NULL, CONSTRAINT check_2addf801cd CHECK ((work_item_type_id IS NOT NULL)), CONSTRAINT check_c33362cd43 CHECK ((namespace_id IS NOT NULL)), @@ -12448,7 +12445,6 @@ CREATE TABLE merge_requests ( merged_commit_sha bytea, override_requested_changes boolean DEFAULT false NOT NULL, head_pipeline_id_convert_to_bigint bigint, - imported smallint DEFAULT 0 NOT NULL, imported_from smallint DEFAULT 0 NOT NULL, CONSTRAINT check_970d272570 CHECK ((lock_version IS NOT NULL)) ); @@ -13147,7 +13143,6 @@ CREATE TABLE notes ( internal boolean DEFAULT false NOT NULL, id bigint NOT NULL, namespace_id bigint, - imported smallint DEFAULT 0 NOT NULL, imported_from smallint DEFAULT 0 NOT NULL, CONSTRAINT check_1244cbd7d0 CHECK ((noteable_type IS NOT NULL)) ); @@ -16415,7 +16410,6 @@ CREATE TABLE resource_label_events ( cached_markdown_version integer, reference text, reference_html text, - imported smallint DEFAULT 0 NOT NULL, imported_from smallint DEFAULT 0 NOT NULL ); @@ -16456,7 +16450,6 @@ CREATE TABLE resource_milestone_events ( action smallint NOT NULL, state smallint NOT NULL, created_at timestamp with time zone NOT NULL, - imported smallint DEFAULT 0 NOT NULL, imported_from smallint DEFAULT 0 NOT NULL ); @@ -16481,7 +16474,6 @@ CREATE TABLE resource_state_events ( close_after_error_tracking_resolve boolean DEFAULT false NOT NULL, close_auto_resolve_prometheus_alert boolean DEFAULT false NOT NULL, source_merge_request_id bigint, - imported smallint DEFAULT 0 NOT NULL, imported_from smallint DEFAULT 0 NOT NULL, CONSTRAINT check_f0bcfaa3a2 CHECK ((char_length(source_commit) <= 40)), CONSTRAINT state_events_must_belong_to_issue_or_merge_request_or_epic CHECK ((((issue_id <> NULL::bigint) AND (merge_request_id IS NULL) AND (epic_id IS NULL)) OR ((issue_id IS NULL) AND (merge_request_id <> NULL::bigint) AND (epic_id IS NULL)) OR ((issue_id IS NULL) AND (merge_request_id IS NULL) AND (epic_id <> NULL::integer)))) @@ -17346,7 +17338,6 @@ CREATE TABLE snippets ( encrypted_secret_token_iv character varying(255), secret boolean DEFAULT false NOT NULL, repository_read_only boolean DEFAULT false NOT NULL, - imported smallint DEFAULT 0 NOT NULL, imported_from smallint DEFAULT 0 NOT NULL, organization_id bigint DEFAULT 1 );