27 lines
606 B
Ruby
27 lines
606 B
Ruby
|
Sequel.migration do
|
||
|
|
up do
|
||
|
|
create_table :mapcaps do
|
||
|
|
foreign_key :visualization_id, :visualizations, type: 'uuid', null: false, on_delete: :cascade
|
||
|
|
|
||
|
|
Uuid :id, primary_key: true, default: Sequel.lit('uuid_generate_v4()')
|
||
|
|
|
||
|
|
String :export_json, null: false, type: 'json'
|
||
|
|
String :ids_json, null: false, type: 'json'
|
||
|
|
|
||
|
|
DateTime :created_at, default: Sequel::CURRENT_TIMESTAMP
|
||
|
|
end
|
||
|
|
|
||
|
|
alter_table :mapcaps do
|
||
|
|
add_index :visualization_id
|
||
|
|
end
|
||
|
|
end
|
||
|
|
|
||
|
|
down do
|
||
|
|
alter_table :mapcaps do
|
||
|
|
drop_index :visualization_id
|
||
|
|
end
|
||
|
|
|
||
|
|
drop_table :mapcaps
|
||
|
|
end
|
||
|
|
end
|