Class: CreateTableJobs

Inherits:
ActiveRecord::Migration
  • Object
show all
Defined in:
lib/generators/workhorse/templates/create_table_jobs.rb

Instance Method Summary collapse

Instance Method Details

#changeObject



2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
# File 'lib/generators/workhorse/templates/create_table_jobs.rb', line 2

def change
  create_table :jobs, force: true do |t|
    t.string :state, null: false, default: 'waiting'
    t.string :queue, null: true
    t.text :handler, null: false, limit: 4_294_967_295

    t.string :locked_by
    t.datetime :locked_at

    t.datetime :started_at

    t.datetime :succeeded_at
    t.datetime :failed_at
    t.text :last_error, limit: 4_294_967_295

    t.timestamps null: false
  end

  add_index :jobs, :queue
  add_index :jobs, :state
end