class CreateCities < ActiveRecord::Migration
  def self.up
    create_table :cities do |t|
      t.column :name, :string
      t.column :province, :string
    end

    self.add_city_id
  end

  def self.add_city_id
    # Some people belong to a city
    add_column :people, :city_id, :integer
  end

  def self.remove_city_id
    remove_column :people, :city_id
  end

  def self.down
    drop_table :cities
    self.remove_city_id
  end
end