20240131013203_create_solid_queue_batch_table.rb

class CreateSolidQueueBatchTable < ActiveRecord::Migration[7.1]
  def change
    create_table :solid_queue_job_batches do |t|
      t.references :parent_job_batch, index: true # FIXME: foreign key
      t.text :on_finish_active_job
      t.text :on_success_active_job
      t.text :on_failure_active_job
      t.datetime :finished_at
      t.datetime :changed_at
      t.datetime :last_changed_at
      t.timestamps

      t.index [ :finished_at ]
      t.index [ :changed_at ]
      t.index [ :last_changed_at ]
    end

    add_reference :solid_queue_jobs, :batch, index: true
    add_foreign_key :solid_queue_jobs, :solid_queue_job_batches, column: :batch_id, on_delete: :cascade
  end
end