Contents

class CreatePrefectures < ActiveRecord::Migration
  def change
    create_table :prefectures do |t|
      t.string :name
      t.string :acronym
      t.string :cnpj
      t.references :city
      t.references :street
      t.references :neighborhood
      t.integer :number
      t.string :zip_code
      t.string :complement
      t.string :phone
      t.string :fax
      t.string :email
      t.string :mayor_name

      t.timestamps
    end
    add_index :prefectures, :city_id
    add_index :prefectures, :street_id
    add_index :prefectures, :neighborhood_id
    add_foreign_key :prefectures, :cities
    add_foreign_key :prefectures, :streets
    add_foreign_key :prefectures, :neighborhoods
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
unico-training-7.8.0	db/migrate/20110712135510_create_prefectures.rb