From 4b2d8246c90af8c1c0296eb1b4bd01bed0e1b176 Mon Sep 17 00:00:00 2001
From: Marius Bobin <mbobin@gitlab.com>
Date: Thu, 23 Feb 2023 10:43:54 +0200
Subject: [PATCH] Schedule FK async validations for p_ci_builds_metadata
 partitions

Changelog: added
---
 ..._ci_builds_metadata_partitions_and_ci_builds.rb | 14 ++++++++++++++
 db/schema_migrations/20230223082752                |  1 +
 2 files changed, 15 insertions(+)
 create mode 100644 db/post_migrate/20230223082752_schedule_fk_validation_for_p_ci_builds_metadata_partitions_and_ci_builds.rb
 create mode 100644 db/schema_migrations/20230223082752

diff --git a/db/post_migrate/20230223082752_schedule_fk_validation_for_p_ci_builds_metadata_partitions_and_ci_builds.rb b/db/post_migrate/20230223082752_schedule_fk_validation_for_p_ci_builds_metadata_partitions_and_ci_builds.rb
new file mode 100644
index 00000000000000..583a9cd31f7a3d
--- /dev/null
+++ b/db/post_migrate/20230223082752_schedule_fk_validation_for_p_ci_builds_metadata_partitions_and_ci_builds.rb
@@ -0,0 +1,14 @@
+# frozen_string_literal: true
+
+class ScheduleFkValidationForPCiBuildsMetadataPartitionsAndCiBuilds < Gitlab::Database::Migration[2.1]
+  TABLE_NAME = :p_ci_builds_metadata
+  FK_NAME = :fk_e20479742e_p
+
+  def up
+    prepare_partitioned_async_foreign_key_validation TABLE_NAME, name: FK_NAME
+  end
+
+  def down
+    unprepare_partitioned_async_foreign_key_validation TABLE_NAME, name: FK_NAME
+  end
+end
diff --git a/db/schema_migrations/20230223082752 b/db/schema_migrations/20230223082752
new file mode 100644
index 00000000000000..83789c7ffe8161
--- /dev/null
+++ b/db/schema_migrations/20230223082752
@@ -0,0 +1 @@
+53f1003eeb8f961b37d90c73a71f75683077b9bcd0e495395033998530a363bd
\ No newline at end of file
-- 
GitLab