Add latest changes from gitlab-org/gitlab@master

31 files changed, 426 insertions, 0 deletions

diff --git a/db/post_migrate/20230524135543_replace_ci_build_pending_states_foreign_key.rb b/db/post_migrate/20230524135543_replace_ci_build_pending_states_foreign_key.rb
new file mode 100644
index 00000000000..deceb923a48
--- /dev/null
+++ b/db/post_migrate/20230524135543_replace_ci_build_pending_states_foreign_key.rb
@@ -0,0 +1,23 @@
+# frozen_string_literal: true
+
+class ReplaceCiBuildPendingStatesForeignKey < Gitlab::Database::Migration[2.1]
+  disable_ddl_transaction!
+
+  def up
+    add_concurrent_foreign_key :ci_build_pending_states, :p_ci_builds,
+      name: 'temp_fk_861cd17da3_p',
+      column: [:partition_id, :build_id],
+      target_column: [:partition_id, :id],
+      on_update: :cascade,
+      on_delete: :cascade,
+      validate: false,
+      reverse_lock_order: true
+
+    prepare_async_foreign_key_validation :ci_build_pending_states, name: 'temp_fk_861cd17da3_p'
+  end
+
+  def down
+    unprepare_async_foreign_key_validation :ci_build_pending_states, name: 'temp_fk_861cd17da3_p'
+    remove_foreign_key :ci_build_pending_states, name: 'temp_fk_861cd17da3_p'
+  end
+end
diff --git a/db/post_migrate/20230524135555_replace_ci_build_trace_chunks_foreign_key.rb b/db/post_migrate/20230524135555_replace_ci_build_trace_chunks_foreign_key.rb
new file mode 100644
index 00000000000..d5e4dddd0fc
--- /dev/null
+++ b/db/post_migrate/20230524135555_replace_ci_build_trace_chunks_foreign_key.rb
@@ -0,0 +1,24 @@
+# frozen_string_literal: true
+
+class ReplaceCiBuildTraceChunksForeignKey < Gitlab::Database::Migration[2.1]
+  disable_ddl_transaction!
+
+  def up
+    add_concurrent_foreign_key :ci_build_trace_chunks, :p_ci_builds,
+      name: 'temp_fk_89e29fa5ee_p',
+      column: [:partition_id, :build_id],
+      target_column: [:partition_id, :id],
+      on_update: :cascade,
+      on_delete: :cascade,
+      validate: false,
+      reverse_lock_order: true
+
+    prepare_async_foreign_key_validation :ci_build_trace_chunks,
+      name: 'temp_fk_89e29fa5ee_p'
+  end
+
+  def down
+    unprepare_async_foreign_key_validation :ci_build_trace_chunks, name: 'temp_fk_89e29fa5ee_p'
+    remove_foreign_key :ci_build_trace_chunks, name: 'temp_fk_89e29fa5ee_p'
+  end
+end
diff --git a/db/post_migrate/20230524135607_replace_ci_unit_test_failures_foreign_key.rb b/db/post_migrate/20230524135607_replace_ci_unit_test_failures_foreign_key.rb
new file mode 100644
index 00000000000..5319118b9ef
--- /dev/null
+++ b/db/post_migrate/20230524135607_replace_ci_unit_test_failures_foreign_key.rb
@@ -0,0 +1,24 @@
+# frozen_string_literal: true
+
+class ReplaceCiUnitTestFailuresForeignKey < Gitlab::Database::Migration[2.1]
+  disable_ddl_transaction!
+
+  def up
+    add_concurrent_foreign_key :ci_unit_test_failures, :p_ci_builds,
+      name: 'temp_fk_9e0fc58930_p',
+      column: [:partition_id, :build_id],
+      target_column: [:partition_id, :id],
+      on_update: :cascade,
+      on_delete: :cascade,
+      validate: false,
+      reverse_lock_order: true
+
+    prepare_async_foreign_key_validation :ci_unit_test_failures,
+      name: 'temp_fk_9e0fc58930_p'
+  end
+
+  def down
+    unprepare_async_foreign_key_validation :ci_unit_test_failures, name: 'temp_fk_9e0fc58930_p'
+    remove_foreign_key :ci_unit_test_failures, name: 'temp_fk_9e0fc58930_p'
+  end
+end
diff --git a/db/post_migrate/20230524135620_replace_ci_sources_pipelines_foreign_key.rb b/db/post_migrate/20230524135620_replace_ci_sources_pipelines_foreign_key.rb
new file mode 100644
index 00000000000..b0251de7f00
--- /dev/null
+++ b/db/post_migrate/20230524135620_replace_ci_sources_pipelines_foreign_key.rb
@@ -0,0 +1,24 @@
+# frozen_string_literal: true
+
+class ReplaceCiSourcesPipelinesForeignKey < Gitlab::Database::Migration[2.1]
+  disable_ddl_transaction!
+
+  def up
+    add_concurrent_foreign_key :ci_sources_pipelines, :p_ci_builds,
+      name: 'temp_fk_be5624bf37_p',
+      column: [:source_partition_id, :source_job_id],
+      target_column: [:partition_id, :id],
+      on_update: :cascade,
+      on_delete: :cascade,
+      validate: false,
+      reverse_lock_order: true
+
+    prepare_async_foreign_key_validation :ci_sources_pipelines,
+      name: 'temp_fk_be5624bf37_p'
+  end
+
+  def down
+    unprepare_async_foreign_key_validation :ci_sources_pipelines, name: 'temp_fk_be5624bf37_p'
+    remove_foreign_key :ci_sources_pipelines, name: 'temp_fk_be5624bf37_p'
+  end
+end
diff --git a/db/post_migrate/20230524135632_replace_ci_resources_foreign_key.rb b/db/post_migrate/20230524135632_replace_ci_resources_foreign_key.rb
new file mode 100644
index 00000000000..adf99e73fdb
--- /dev/null
+++ b/db/post_migrate/20230524135632_replace_ci_resources_foreign_key.rb
@@ -0,0 +1,24 @@
+# frozen_string_literal: true
+
+class ReplaceCiResourcesForeignKey < Gitlab::Database::Migration[2.1]
+  disable_ddl_transaction!
+
+  def up
+    add_concurrent_foreign_key :ci_resources, :p_ci_builds,
+      name: 'temp_fk_e169a8e3d5_p',
+      column: [:partition_id, :build_id],
+      target_column: [:partition_id, :id],
+      on_update: :cascade,
+      on_delete: :nullify,
+      validate: false,
+      reverse_lock_order: true
+
+    prepare_async_foreign_key_validation :ci_resources,
+      name: 'temp_fk_e169a8e3d5_p'
+  end
+
+  def down
+    unprepare_async_foreign_key_validation :ci_resources, name: 'temp_fk_e169a8e3d5_p'
+    remove_foreign_key :ci_resources, name: 'temp_fk_e169a8e3d5_p'
+  end
+end
diff --git a/db/post_migrate/20230524135645_replace_ci_build_report_results_foreign_key.rb b/db/post_migrate/20230524135645_replace_ci_build_report_results_foreign_key.rb
new file mode 100644
index 00000000000..9e54d1e2885
--- /dev/null
+++ b/db/post_migrate/20230524135645_replace_ci_build_report_results_foreign_key.rb
@@ -0,0 +1,24 @@
+# frozen_string_literal: true
+
+class ReplaceCiBuildReportResultsForeignKey < Gitlab::Database::Migration[2.1]
+  disable_ddl_transaction!
+
+  def up
+    add_concurrent_foreign_key :ci_build_report_results, :p_ci_builds,
+      name: 'temp_fk_rails_16cb1ff064_p',
+      column: [:partition_id, :build_id],
+      target_column: [:partition_id, :id],
+      on_update: :cascade,
+      on_delete: :cascade,
+      validate: false,
+      reverse_lock_order: true
+
+    prepare_async_foreign_key_validation :ci_build_report_results,
+      name: 'temp_fk_rails_16cb1ff064_p'
+  end
+
+  def down
+    unprepare_async_foreign_key_validation :ci_build_report_results, name: 'temp_fk_rails_16cb1ff064_p'
+    remove_foreign_key :ci_build_report_results, name: 'temp_fk_rails_16cb1ff064_p'
+  end
+end
diff --git a/db/post_migrate/20230524135658_replace_ci_build_needs_foreign_key.rb b/db/post_migrate/20230524135658_replace_ci_build_needs_foreign_key.rb
new file mode 100644
index 00000000000..a41bd6d78bf
--- /dev/null
+++ b/db/post_migrate/20230524135658_replace_ci_build_needs_foreign_key.rb
@@ -0,0 +1,24 @@
+# frozen_string_literal: true
+
+class ReplaceCiBuildNeedsForeignKey < Gitlab::Database::Migration[2.1]
+  disable_ddl_transaction!
+
+  def up
+    add_concurrent_foreign_key :ci_build_needs, :p_ci_builds,
+      name: 'temp_fk_rails_3cf221d4ed_p',
+      column: [:partition_id, :build_id],
+      target_column: [:partition_id, :id],
+      on_update: :cascade,
+      on_delete: :cascade,
+      validate: false,
+      reverse_lock_order: true
+
+    prepare_async_foreign_key_validation :ci_build_needs,
+      name: 'temp_fk_rails_3cf221d4ed_p'
+  end
+
+  def down
+    unprepare_async_foreign_key_validation :ci_build_needs, name: 'temp_fk_rails_3cf221d4ed_p'
+    remove_foreign_key :ci_build_needs, name: 'temp_fk_rails_3cf221d4ed_p'
+  end
+end
diff --git a/db/post_migrate/20230524135711_replace_ci_builds_runner_session_foreign_key.rb b/db/post_migrate/20230524135711_replace_ci_builds_runner_session_foreign_key.rb
new file mode 100644
index 00000000000..9ae6a84d28c
--- /dev/null
+++ b/db/post_migrate/20230524135711_replace_ci_builds_runner_session_foreign_key.rb
@@ -0,0 +1,24 @@
+# frozen_string_literal: true
+
+class ReplaceCiBuildsRunnerSessionForeignKey < Gitlab::Database::Migration[2.1]
+  disable_ddl_transaction!
+
+  def up
+    add_concurrent_foreign_key :ci_builds_runner_session, :p_ci_builds,
+      name: 'temp_fk_rails_70707857d3_p',
+      column: [:partition_id, :build_id],
+      target_column: [:partition_id, :id],
+      on_update: :cascade,
+      on_delete: :cascade,
+      validate: false,
+      reverse_lock_order: true
+
+    prepare_async_foreign_key_validation :ci_builds_runner_session,
+      name: 'temp_fk_rails_70707857d3_p'
+  end
+
+  def down
+    unprepare_async_foreign_key_validation :ci_builds_runner_session, name: 'temp_fk_rails_70707857d3_p'
+    remove_foreign_key :ci_builds_runner_session, name: 'temp_fk_rails_70707857d3_p'
+  end
+end
diff --git a/db/post_migrate/20230524135724_replace_ci_pending_builds_foreign_key.rb b/db/post_migrate/20230524135724_replace_ci_pending_builds_foreign_key.rb
new file mode 100644
index 00000000000..6717ea27237
--- /dev/null
+++ b/db/post_migrate/20230524135724_replace_ci_pending_builds_foreign_key.rb
@@ -0,0 +1,24 @@
+# frozen_string_literal: true
+
+class ReplaceCiPendingBuildsForeignKey < Gitlab::Database::Migration[2.1]
+  disable_ddl_transaction!
+
+  def up
+    add_concurrent_foreign_key :ci_pending_builds, :p_ci_builds,
+      name: 'temp_fk_rails_725a2644a3_p',
+      column: [:partition_id, :build_id],
+      target_column: [:partition_id, :id],
+      on_update: :cascade,
+      on_delete: :cascade,
+      validate: false,
+      reverse_lock_order: true
+
+    prepare_async_foreign_key_validation :ci_pending_builds,
+      name: 'temp_fk_rails_725a2644a3_p'
+  end
+
+  def down
+    unprepare_async_foreign_key_validation :ci_pending_builds, name: 'temp_fk_rails_725a2644a3_p'
+    remove_foreign_key :ci_pending_builds, name: 'temp_fk_rails_725a2644a3_p'
+  end
+end
diff --git a/db/post_migrate/20230524135737_replace_ci_build_trace_metadata_foreign_key.rb b/db/post_migrate/20230524135737_replace_ci_build_trace_metadata_foreign_key.rb
new file mode 100644
index 00000000000..abf5700ec98
--- /dev/null
+++ b/db/post_migrate/20230524135737_replace_ci_build_trace_metadata_foreign_key.rb
@@ -0,0 +1,24 @@
+# frozen_string_literal: true
+
+class ReplaceCiBuildTraceMetadataForeignKey < Gitlab::Database::Migration[2.1]
+  disable_ddl_transaction!
+
+  def up
+    add_concurrent_foreign_key :ci_build_trace_metadata, :p_ci_builds,
+      name: 'temp_fk_rails_aebc78111f_p',
+      column: [:partition_id, :build_id],
+      target_column: [:partition_id, :id],
+      on_update: :cascade,
+      on_delete: :cascade,
+      validate: false,
+      reverse_lock_order: true
+
+    prepare_async_foreign_key_validation :ci_build_trace_metadata,
+      name: 'temp_fk_rails_aebc78111f_p'
+  end
+
+  def down
+    unprepare_async_foreign_key_validation :ci_build_trace_metadata, name: 'temp_fk_rails_aebc78111f_p'
+    remove_foreign_key :ci_build_trace_metadata, name: 'temp_fk_rails_aebc78111f_p'
+  end
+end
diff --git a/db/post_migrate/20230524135750_replace_ci_job_artifacts_foreign_key.rb b/db/post_migrate/20230524135750_replace_ci_job_artifacts_foreign_key.rb
new file mode 100644
index 00000000000..8bd4dadc891
--- /dev/null
+++ b/db/post_migrate/20230524135750_replace_ci_job_artifacts_foreign_key.rb
@@ -0,0 +1,24 @@
+# frozen_string_literal: true
+
+class ReplaceCiJobArtifactsForeignKey < Gitlab::Database::Migration[2.1]
+  disable_ddl_transaction!
+
+  def up
+    add_concurrent_foreign_key :ci_job_artifacts, :p_ci_builds,
+      name: 'temp_fk_rails_c5137cb2c1_p',
+      column: [:partition_id, :job_id],
+      target_column: [:partition_id, :id],
+      on_update: :cascade,
+      on_delete: :cascade,
+      validate: false,
+      reverse_lock_order: true
+
+    prepare_async_foreign_key_validation :ci_job_artifacts,
+      name: 'temp_fk_rails_c5137cb2c1_p'
+  end
+
+  def down
+    unprepare_async_foreign_key_validation :ci_job_artifacts, name: 'temp_fk_rails_c5137cb2c1_p'
+    remove_foreign_key :ci_job_artifacts, name: 'temp_fk_rails_c5137cb2c1_p'
+  end
+end
diff --git a/db/post_migrate/20230524135803_replace_ci_running_builds_foreign_key.rb b/db/post_migrate/20230524135803_replace_ci_running_builds_foreign_key.rb
new file mode 100644
index 00000000000..0e2d2bd34d0
--- /dev/null
+++ b/db/post_migrate/20230524135803_replace_ci_running_builds_foreign_key.rb
@@ -0,0 +1,24 @@
+# frozen_string_literal: true
+
+class ReplaceCiRunningBuildsForeignKey < Gitlab::Database::Migration[2.1]
+  disable_ddl_transaction!
+
+  def up
+    add_concurrent_foreign_key :ci_running_builds, :p_ci_builds,
+      name: 'temp_fk_rails_da45cfa165_p',
+      column: [:partition_id, :build_id],
+      target_column: [:partition_id, :id],
+      on_update: :cascade,
+      on_delete: :cascade,
+      validate: false,
+      reverse_lock_order: true
+
+    prepare_async_foreign_key_validation :ci_running_builds,
+      name: 'temp_fk_rails_da45cfa165_p'
+  end
+
+  def down
+    unprepare_async_foreign_key_validation :ci_running_builds, name: 'temp_fk_rails_da45cfa165_p'
+    remove_foreign_key :ci_running_builds, name: 'temp_fk_rails_da45cfa165_p'
+  end
+end
diff --git a/db/post_migrate/20230524135815_replace_ci_job_variables_foreign_key.rb b/db/post_migrate/20230524135815_replace_ci_job_variables_foreign_key.rb
new file mode 100644
index 00000000000..c846c7f437c
--- /dev/null
+++ b/db/post_migrate/20230524135815_replace_ci_job_variables_foreign_key.rb
@@ -0,0 +1,24 @@
+# frozen_string_literal: true
+
+class ReplaceCiJobVariablesForeignKey < Gitlab::Database::Migration[2.1]
+  disable_ddl_transaction!
+
+  def up
+    add_concurrent_foreign_key :ci_job_variables, :p_ci_builds,
+      name: 'temp_fk_rails_fbf3b34792_p',
+      column: [:partition_id, :job_id],
+      target_column: [:partition_id, :id],
+      on_update: :cascade,
+      on_delete: :cascade,
+      validate: false,
+      reverse_lock_order: true
+
+    prepare_async_foreign_key_validation :ci_job_variables,
+      name: 'temp_fk_rails_fbf3b34792_p'
+  end
+
+  def down
+    unprepare_async_foreign_key_validation :ci_job_variables, name: 'temp_fk_rails_fbf3b34792_p'
+    remove_foreign_key :ci_job_variables, name: 'temp_fk_rails_fbf3b34792_p'
+  end
+end
diff --git a/db/post_migrate/20230524135828_replace_p_ci_builds_metadata_foreign_key.rb b/db/post_migrate/20230524135828_replace_p_ci_builds_metadata_foreign_key.rb
new file mode 100644
index 00000000000..6ad2a932a3a
--- /dev/null
+++ b/db/post_migrate/20230524135828_replace_p_ci_builds_metadata_foreign_key.rb
@@ -0,0 +1,29 @@
+# frozen_string_literal: true
+
+class ReplacePCiBuildsMetadataForeignKey < Gitlab::Database::Migration[2.1]
+  include Gitlab::Database::PartitioningMigrationHelpers
+
+  disable_ddl_transaction!
+
+  def up
+    add_concurrent_partitioned_foreign_key :p_ci_builds_metadata, :p_ci_builds,
+      name: 'temp_fk_e20479742e_p',
+      column: [:partition_id, :build_id],
+      target_column: [:partition_id, :id],
+      on_update: :cascade,
+      on_delete: :cascade,
+      validate: false,
+      reverse_lock_order: true
+
+    prepare_partitioned_async_foreign_key_validation :p_ci_builds_metadata,
+      name: 'temp_fk_e20479742e_p'
+  end
+
+  def down
+    unprepare_partitioned_async_foreign_key_validation :p_ci_builds_metadata, name: 'temp_fk_e20479742e_p'
+
+    Gitlab::Database::PostgresPartitionedTable.each_partition(:p_ci_builds_metadata) do |partition|
+      execute "ALTER TABLE #{partition.identifier} DROP CONSTRAINT IF EXISTS temp_fk_e20479742e_p"
+    end
+  end
+end
diff --git a/db/post_migrate/20230524135840_replace_p_ci_runner_machine_builds_foreign_key.rb b/db/post_migrate/20230524135840_replace_p_ci_runner_machine_builds_foreign_key.rb
new file mode 100644
index 00000000000..7ac4b79d0db
--- /dev/null
+++ b/db/post_migrate/20230524135840_replace_p_ci_runner_machine_builds_foreign_key.rb
@@ -0,0 +1,29 @@
+# frozen_string_literal: true
+
+class ReplacePCiRunnerMachineBuildsForeignKey < Gitlab::Database::Migration[2.1]
+  include Gitlab::Database::PartitioningMigrationHelpers
+
+  disable_ddl_transaction!
+
+  def up
+    add_concurrent_partitioned_foreign_key :p_ci_runner_machine_builds, :p_ci_builds,
+      name: 'temp_fk_bb490f12fe_p',
+      column: [:partition_id, :build_id],
+      target_column: [:partition_id, :id],
+      on_update: :cascade,
+      on_delete: :cascade,
+      validate: false,
+      reverse_lock_order: true
+
+    prepare_partitioned_async_foreign_key_validation :p_ci_runner_machine_builds,
+      name: 'temp_fk_bb490f12fe_p'
+  end
+
+  def down
+    unprepare_partitioned_async_foreign_key_validation :p_ci_runner_machine_builds, name: 'temp_fk_bb490f12fe_p'
+
+    Gitlab::Database::PostgresPartitionedTable.each_partition(:p_ci_runner_machine_builds) do |partition|
+      execute "ALTER TABLE #{partition.identifier} DROP CONSTRAINT IF EXISTS temp_fk_bb490f12fe_p"
+    end
+  end
+end
diff --git a/db/schema_migrations/20230524135543 b/db/schema_migrations/20230524135543
new file mode 100644
index 00000000000..6f8f62289e8
--- /dev/null
+++ b/db/schema_migrations/20230524135543
@@ -0,0 +1 @@
+95b28bcaa72d53bfdc7430407c89eac7a59016b9317e44214dbb968cc3b41723
\ No newline at end of file
diff --git a/db/schema_migrations/20230524135555 b/db/schema_migrations/20230524135555
new file mode 100644
index 00000000000..70746a5ad83
--- /dev/null
+++ b/db/schema_migrations/20230524135555
@@ -0,0 +1 @@
+ee90ed971ac9b67e539e367621b5bcefdf583ae9e53a1add59a70c3168035e26
\ No newline at end of file
diff --git a/db/schema_migrations/20230524135607 b/db/schema_migrations/20230524135607
new file mode 100644
index 00000000000..f4e535a7736
--- /dev/null
+++ b/db/schema_migrations/20230524135607
@@ -0,0 +1 @@
+88c6b1d18c6c9b74b7be1831cd692f5004d04ca0d1e190eb5e1a2e079cfed50d
\ No newline at end of file
diff --git a/db/schema_migrations/20230524135620 b/db/schema_migrations/20230524135620
new file mode 100644
index 00000000000..1d09b6cc98a
--- /dev/null
+++ b/db/schema_migrations/20230524135620
@@ -0,0 +1 @@
+a04c487f7d900c7108fcdd6957ac70ff1f00797bb2d503c50849edaeb500f561
\ No newline at end of file
diff --git a/db/schema_migrations/20230524135632 b/db/schema_migrations/20230524135632
new file mode 100644
index 00000000000..14610334452
--- /dev/null
+++ b/db/schema_migrations/20230524135632
@@ -0,0 +1 @@
+ecd3ca58470c44d3138416b77e9af8ad5583debe55e925d7ada4e9694c2ebc9f
\ No newline at end of file
diff --git a/db/schema_migrations/20230524135645 b/db/schema_migrations/20230524135645
new file mode 100644
index 00000000000..97083156370
--- /dev/null
+++ b/db/schema_migrations/20230524135645
@@ -0,0 +1 @@
+47468406daedd3dbfc3dcc7841d8139fa8a6981acd71343ff873d83cd8dc7a66
\ No newline at end of file
diff --git a/db/schema_migrations/20230524135658 b/db/schema_migrations/20230524135658
new file mode 100644
index 00000000000..1167d0d3db3
--- /dev/null
+++ b/db/schema_migrations/20230524135658
@@ -0,0 +1 @@
+4f8cf41b2f65f2033769788fd271ea8b77b998c5ce186cc332942417e2bf9b62
\ No newline at end of file
diff --git a/db/schema_migrations/20230524135711 b/db/schema_migrations/20230524135711
new file mode 100644
index 00000000000..58f892c964a
--- /dev/null
+++ b/db/schema_migrations/20230524135711
@@ -0,0 +1 @@
+157a4ab1510c029cc65e78bd7f41446fb39be4504f39362eda7e2552fd3f3697
\ No newline at end of file
diff --git a/db/schema_migrations/20230524135724 b/db/schema_migrations/20230524135724
new file mode 100644
index 00000000000..bd8039b1547
--- /dev/null
+++ b/db/schema_migrations/20230524135724
@@ -0,0 +1 @@
+89ed7b769afadb76236dd9392cf06656177fa572ffc26c9e4c19035c28bdc445
\ No newline at end of file
diff --git a/db/schema_migrations/20230524135737 b/db/schema_migrations/20230524135737
new file mode 100644
index 00000000000..af46dc6fe38
--- /dev/null
+++ b/db/schema_migrations/20230524135737
@@ -0,0 +1 @@
+463414e049c5e3ddf7eb61e33cd08d66bf0cb244de7e6395feacb4ed4b7885fe
\ No newline at end of file
diff --git a/db/schema_migrations/20230524135750 b/db/schema_migrations/20230524135750
new file mode 100644
index 00000000000..ef09aa2412f
--- /dev/null
+++ b/db/schema_migrations/20230524135750
@@ -0,0 +1 @@
+df54efbd38edbea5409cd01d3c82457dfae985ae475db5fa4076ee99eeda320c
\ No newline at end of file
diff --git a/db/schema_migrations/20230524135803 b/db/schema_migrations/20230524135803
new file mode 100644
index 00000000000..604664e0291
--- /dev/null
+++ b/db/schema_migrations/20230524135803
@@ -0,0 +1 @@
+f348cf0f6dab2252143f802d85983a660fe21501a17b771bdbc5507e5ff6a5ca
\ No newline at end of file
diff --git a/db/schema_migrations/20230524135815 b/db/schema_migrations/20230524135815
new file mode 100644
index 00000000000..85aa04da3a9
--- /dev/null
+++ b/db/schema_migrations/20230524135815
@@ -0,0 +1 @@
+9914afc99657b855caba9e083c66c71863c199c0e0fe3d1331a87a12b327cf7d
\ No newline at end of file
diff --git a/db/schema_migrations/20230524135828 b/db/schema_migrations/20230524135828
new file mode 100644
index 00000000000..557404d10bd
--- /dev/null
+++ b/db/schema_migrations/20230524135828
@@ -0,0 +1 @@
+f885a506e2176cec1de13d708dbd68a1ae6912f738079d6f5cce272687c2afb9
\ No newline at end of file
diff --git a/db/schema_migrations/20230524135840 b/db/schema_migrations/20230524135840
new file mode 100644
index 00000000000..2d50808bfd8
--- /dev/null
+++ b/db/schema_migrations/20230524135840
@@ -0,0 +1 @@
+52632ee5e346f88fa1e00c8d99a210e79aa2718da09ebe1c0aa468b872779dd4
\ No newline at end of file
diff --git a/db/structure.sql b/db/structure.sql
index 8fe5a4c0011..5891df1a250 100644
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -38070,6 +38070,48 @@ ALTER TABLE issue_search_data
 ALTER TABLE product_analytics_events_experimental
     ADD CONSTRAINT product_analytics_events_experimental_project_id_fkey FOREIGN KEY (project_id) REFERENCES projects(id) ON DELETE CASCADE;
 
+ALTER TABLE ONLY ci_build_pending_states
+    ADD CONSTRAINT temp_fk_861cd17da3_p FOREIGN KEY (partition_id, build_id) REFERENCES p_ci_builds(partition_id, id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;
+
+ALTER TABLE ONLY ci_build_trace_chunks
+    ADD CONSTRAINT temp_fk_89e29fa5ee_p FOREIGN KEY (partition_id, build_id) REFERENCES p_ci_builds(partition_id, id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;
+
+ALTER TABLE ONLY ci_unit_test_failures
+    ADD CONSTRAINT temp_fk_9e0fc58930_p FOREIGN KEY (partition_id, build_id) REFERENCES p_ci_builds(partition_id, id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;
+
+ALTER TABLE ONLY ci_sources_pipelines
+    ADD CONSTRAINT temp_fk_be5624bf37_p FOREIGN KEY (source_partition_id, source_job_id) REFERENCES p_ci_builds(partition_id, id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;
+
+ALTER TABLE ONLY ci_resources
+    ADD CONSTRAINT temp_fk_e169a8e3d5_p FOREIGN KEY (partition_id, build_id) REFERENCES p_ci_builds(partition_id, id) ON UPDATE CASCADE ON DELETE SET NULL NOT VALID;
+
+ALTER TABLE ONLY ci_builds_metadata
+    ADD CONSTRAINT temp_fk_e20479742e_p FOREIGN KEY (partition_id, build_id) REFERENCES p_ci_builds(partition_id, id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;
+
+ALTER TABLE ONLY ci_build_report_results
+    ADD CONSTRAINT temp_fk_rails_16cb1ff064_p FOREIGN KEY (partition_id, build_id) REFERENCES p_ci_builds(partition_id, id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;
+
+ALTER TABLE ONLY ci_build_needs
+    ADD CONSTRAINT temp_fk_rails_3cf221d4ed_p FOREIGN KEY (partition_id, build_id) REFERENCES p_ci_builds(partition_id, id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;
+
+ALTER TABLE ONLY ci_builds_runner_session
+    ADD CONSTRAINT temp_fk_rails_70707857d3_p FOREIGN KEY (partition_id, build_id) REFERENCES p_ci_builds(partition_id, id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;
+
+ALTER TABLE ONLY ci_pending_builds
+    ADD CONSTRAINT temp_fk_rails_725a2644a3_p FOREIGN KEY (partition_id, build_id) REFERENCES p_ci_builds(partition_id, id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;
+
+ALTER TABLE ONLY ci_build_trace_metadata
+    ADD CONSTRAINT temp_fk_rails_aebc78111f_p FOREIGN KEY (partition_id, build_id) REFERENCES p_ci_builds(partition_id, id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;
+
+ALTER TABLE ONLY ci_job_artifacts
+    ADD CONSTRAINT temp_fk_rails_c5137cb2c1_p FOREIGN KEY (partition_id, job_id) REFERENCES p_ci_builds(partition_id, id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;
+
+ALTER TABLE ONLY ci_running_builds
+    ADD CONSTRAINT temp_fk_rails_da45cfa165_p FOREIGN KEY (partition_id, build_id) REFERENCES p_ci_builds(partition_id, id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;
+
+ALTER TABLE ONLY ci_job_variables
+    ADD CONSTRAINT temp_fk_rails_fbf3b34792_p FOREIGN KEY (partition_id, job_id) REFERENCES p_ci_builds(partition_id, id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;
+
 ALTER TABLE ONLY user_follow_users
     ADD CONSTRAINT user_follow_users_followee_id_fkey FOREIGN KEY (followee_id) REFERENCES users(id) ON DELETE CASCADE;