22 lines
622 B
Ruby
22 lines
622 B
Ruby
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
|