Sequel.migration do
  change do
    alter_table(:projects) do
      drop_column :data
    end

    create_table(:hunts) do
      primary_key :id
      foreign_key :project_id, :projects, null: false, on_delete: :cascade
      foreign_key :pokemon_id, :pokemon, null: false, on_delete: :cascade
      Integer :encounters
      DateTime :started_at
      TrueClass :complete, default: false
      DateTime :completed_at
      TrueClass :verified, default: false
      DateTime :created_at, default: Sequel::CURRENT_TIMESTAMP
      DateTime :updated_at, default: Sequel::CURRENT_TIMESTAMP
      File :proof
    end
  end
end