diff --git a/db/post_migrate/20250926194922_add_multi_column_not_null_constraint_to_snippet_repositories.rb b/db/post_migrate/20250926194922_add_multi_column_not_null_constraint_to_snippet_repositories.rb new file mode 100644 index 0000000000000000000000000000000000000000..db1732ea1ef0b844f31da729b033936ea5baa48f --- /dev/null +++ b/db/post_migrate/20250926194922_add_multi_column_not_null_constraint_to_snippet_repositories.rb @@ -0,0 +1,14 @@ +# frozen_string_literal: true + +class AddMultiColumnNotNullConstraintToSnippetRepositories < Gitlab::Database::Migration[2.3] + disable_ddl_transaction! + milestone '18.5' + + def up + add_multi_column_not_null_constraint(:snippet_repositories, :snippet_project_id, :snippet_organization_id) + end + + def down + remove_multi_column_not_null_constraint(:snippet_repositories, :snippet_project_id, :snippet_organization_id) + end +end diff --git a/db/schema_migrations/20250926194922 b/db/schema_migrations/20250926194922 new file mode 100644 index 0000000000000000000000000000000000000000..390d1f2d9728993b15ef1f2a72fe140ea024aaa8 --- /dev/null +++ b/db/schema_migrations/20250926194922 @@ -0,0 +1 @@ +1163af9dea85227364debc6f2457733a3b5b8d10cbc56be0484ba98c11ac3afe \ No newline at end of file diff --git a/db/structure.sql b/db/structure.sql index c772285ef9dfb80ed4c826951c9b00a9ae68f5be..edf226525c145b1369ef50774a740156e9f925ca 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -22585,6 +22585,7 @@ CREATE TABLE snippet_repositories ( verification_started_at timestamp with time zone, snippet_project_id bigint, snippet_organization_id bigint, + CONSTRAINT check_0d1a38de4c CHECK ((num_nonnulls(snippet_organization_id, snippet_project_id) = 1)), CONSTRAINT snippet_repositories_verification_failure_text_limit CHECK ((char_length(verification_failure) <= 255)) );