db/migrate/20231010194809_correct_relation_members_primary_key.rb

   1 # frozen_string_literal: true
   2
   3 class CorrectRelationMembersPrimaryKey < ActiveRecord::Migration[7.0]
   4   disable_ddl_transaction!
   5
   6   def up
   7     alter_primary_key :current_relation_members, [:relation_id, :sequence_id], :algorithm => :concurrently
   8     alter_primary_key :relation_members, [:relation_id, :version, :sequence_id], :algorithm => :concurrently
   9   end
  10
  11   def down
  12     alter_primary_key :relation_members, [:relation_id, :version, :member_type, :member_id, :member_role, :sequence_id], :algorithm => :concurrently
  13     alter_primary_key :current_relation_members, [:relation_id, :member_type, :member_id, :member_role, :sequence_id], :algorithm => :concurrently
  14   end
  15 end