debian-mirror-gitlab/db/post_migrate/20230309085547_prepare_ci_builds_constraints_for_list_partitioning.rb
2023-06-20 00:43:36 +05:30

16 lines
537 B
Ruby

# frozen_string_literal: true
class PrepareCiBuildsConstraintsForListPartitioning < Gitlab::Database::Migration[2.1]
disable_ddl_transaction!
def up
add_check_constraint(:ci_builds, 'partition_id = 100', 'partitioning_constraint', validate: false)
prepare_async_check_constraint_validation(:ci_builds, name: 'partitioning_constraint')
end
def down
unprepare_async_check_constraint_validation(:ci_builds, name: 'partitioning_constraint')
remove_check_constraint(:ci_builds, 'partitioning_constraint')
end
end