class CreateSayWhenTables
Public Class Methods
down()
click to toggle source
# 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
up()
click to toggle source
# 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