From 940754c391903260ed41d8522f39ffc9e175a9d3 Mon Sep 17 00:00:00 2001
From: hustewart <hustewart@gitlab.com>
Date: Fri, 26 Sep 2025 15:51:50 -0400
Subject: [PATCH 1/3] Add snippet repo mulit column not null

---
 ..._not_null_constraint_to_snippet_repositories.rb | 14 ++++++++++++++
 db/schema_migrations/20250923185232                |  1 +
 2 files changed, 15 insertions(+)
 create mode 100644 db/post_migrate/20250926194922_add_multi_column_not_null_constraint_to_snippet_repositories.rb
 create mode 100644 db/schema_migrations/20250923185232

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 00000000000000..db1732ea1ef0b8
--- /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/20250923185232 b/db/schema_migrations/20250923185232
new file mode 100644
index 00000000000000..be42425d040176
--- /dev/null
+++ b/db/schema_migrations/20250923185232
@@ -0,0 +1 @@
+7b4a7b054b887a831fc49bd250486efd6429b0a63cb1cbd8dd8d82f3d022d731
\ No newline at end of file
-- 
GitLab


From 95052f8d84055c37af87f6bbc89d0b87c23ea766 Mon Sep 17 00:00:00 2001
From: hustewart <hustewart@gitlab.com>
Date: Fri, 26 Sep 2025 15:57:08 -0400
Subject: [PATCH 2/3] Add schema migration

---
 db/schema_migrations/20250923185232 | 1 -
 db/schema_migrations/20250926194922 | 1 +
 2 files changed, 1 insertion(+), 1 deletion(-)
 delete mode 100644 db/schema_migrations/20250923185232
 create mode 100644 db/schema_migrations/20250926194922

diff --git a/db/schema_migrations/20250923185232 b/db/schema_migrations/20250923185232
deleted file mode 100644
index be42425d040176..00000000000000
--- a/db/schema_migrations/20250923185232
+++ /dev/null
@@ -1 +0,0 @@
-7b4a7b054b887a831fc49bd250486efd6429b0a63cb1cbd8dd8d82f3d022d731
\ No newline at end of file
diff --git a/db/schema_migrations/20250926194922 b/db/schema_migrations/20250926194922
new file mode 100644
index 00000000000000..390d1f2d972899
--- /dev/null
+++ b/db/schema_migrations/20250926194922
@@ -0,0 +1 @@
+1163af9dea85227364debc6f2457733a3b5b8d10cbc56be0484ba98c11ac3afe
\ No newline at end of file
-- 
GitLab


From ef409aa9e57bbf53cf84da8c99fb60df31fec718 Mon Sep 17 00:00:00 2001
From: hustewart <hustewart@gitlab.com>
Date: Fri, 26 Sep 2025 15:59:00 -0400
Subject: [PATCH 3/3] Update structure sql

---
 db/structure.sql | 1 +
 1 file changed, 1 insertion(+)

diff --git a/db/structure.sql b/db/structure.sql
index c772285ef9dfb8..edf226525c145b 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))
 );
 
-- 
GitLab