```ruby
class CreateJobs < ActiveRecord::Migration
  def self.up
    create_table :jobs do |t|
      t.string :path
      t.text :args
      t.text :result
      t.datetime :started_at
      t.datetime :cancelled_at
      t.datetime :completed_at
      t.string :status
      t.string :error_message
      t.text :error_backtrace

      t.string :employee_host
      t.string :employee_pid

      t.timestamps
    end

    add_index :jobs, :path
    add_index :jobs, :status
  end

  def self.down
    drop_table :jobs
  end
end
```

Store employee_pid as an Integer
user
```ruby
class CreateJobs < ActiveRecord::Migration
  def self.up
    create_table :jobs do |t|
      t.string :path
      t.text :args
      t.text :result
      t.datetime :started_at
      t.datetime :cancelled_at
      t.datetime :completed_at
      t.string :status
      t.string :error_message
      t.text :error_backtrace

      t.string :employee_host
      t.integer :employee_pid

      t.timestamps
    end

    add_index :jobs, :path
    add_index :jobs, :status
  end

  def self.down
    drop_table :jobs
  end
end
```
assistant