qi6_app/db/migrate/20160211144349_create_specific_map_items.rb
2019-05-17 12:30:45 +02:00

26 lines
677 B
Ruby

class CreateSpecificMapItems < ActiveRecord::Migration[6.0]
def change
create_table :specific_map_items do |t|
t.references :specific_map, index: true
t.decimal :g_latitude, :precision=>10, :scale=>6
t.decimal :g_longitude, :precision=>10, :scale=>6
t.string :g_text
t.string :titre
t.string :name
t.string :firstname
t.string :organisation
t.string :address
t.string :cp
t.string :city
t.string :country
t.string :tel
t.string :email
t.string :website
t.string :notes
t.timestamps null: false
end
add_foreign_key :specific_map_items, :specific_maps
end
end