1 files changed, 23 insertions, 0 deletions
diff --git a/db/post_migrate/20240117070946_validate_fk_on_resource_link_events_system_note_metadata_id_for_com.rb b/db/post_migrate/20240117070946_validate_fk_on_resource_link_events_system_note_metadata_id_for_com.rb
new file mode 100644
index 00000000000..890b0c95d2a
--- /dev/null
+++ b/db/post_migrate/20240117070946_validate_fk_on_resource_link_events_system_note_metadata_id_for_com.rb
@@ -0,0 +1,23 @@
+# frozen_string_literal: true
+
+class ValidateFkOnResourceLinkEventsSystemNoteMetadataIdForCom < Gitlab::Database::Migration[2.2]
+  include Gitlab::Database::MigrationHelpers::ConvertToBigint # for the method `com_or_dev_or_test_but_not_jh?`
+
+  milestone '16.9'
+
+  TABLE_NAME = :resource_link_events
+  COLUMN = :system_note_metadata_id
+  FK_NAME = 'fk_system_note_metadata_id_convert_to_bigint'
+
+  def up
+    return unless com_or_dev_or_test_but_not_jh?
+
+    prepare_async_foreign_key_validation TABLE_NAME, COLUMN, name: FK_NAME
+  end
+
+  def down
+    return unless com_or_dev_or_test_but_not_jh?
+
+    unprepare_async_foreign_key_validation TABLE_NAME, COLUMN, name: FK_NAME
+  end
+end