module Roqua::Scheduling::CronJobTable
  def self.create_cron_jobs_table(schema)
    schema.create_table :roqua_scheduling_cron_jobs, force: true do |t|
      t.string     :name, null: false
      t.datetime   :next_run_at, null: false
      t.datetime   :completed_at
      t.timestamps null: false
    end

    schema.add_index :roqua_scheduling_cron_jobs, :name, unique: true
  end
end