class CreateSayWhenTables

# File lib/generators/say_when/migration/templates/migration.rb, line 47
def self.down
  drop_table :<%= prefix %>say_when_job_executions
  drop_table :<%= prefix %>say_when_jobs
end

# File lib/generators/say_when/migration/templates/migration.rb, line 5
def self.up

  create_table :<%= prefix %>say_when_jobs, :force => true do |t|
    t.string    :group
    t.string    :name

    t.string    :status

    t.string    :trigger_strategy
    t.text      :trigger_options

    t.timestamp :last_fire_at
    t.timestamp :next_fire_at

    t.timestamp :start_at
    t.timestamp :end_at

    t.string    :job_class
    t.string    :job_method
    t.text      :data

    t.string    :scheduled_type
    t.integer   :scheduled_id

    t.timestamps null: false
  end

  add_index :<%= prefix %>say_when_jobs, [:next_fire_at, :status]
  add_index :<%= prefix %>say_when_jobs, [:scheduled_type, :scheduled_id]

  create_table :<%= prefix %>say_when_job_executions, :force => true do |t|
    t.integer  :job_id
    t.string   :status
    t.text     :result
    t.datetime :start_at
    t.datetime :end_at
  end

  add_index :<%= prefix %>say_when_job_executions, :job_id
  add_index :<%= prefix %>say_when_job_executions, [:status, :start_at, :end_at]
end