# type the following at a command prompt:
# ruby script/generate migration create_zips_table
# and copy this file over the file that was generated:

class CreateZipsTable < ActiveRecord::Migration
  def self.up
    create_table :zips, :id => false do |t|
      t.column  :id,        :string
      t.column  :city,      :string
      t.column  :state,     :string
    end
    # load the zipcodes from a csv file
    execute "load data infile '#{RAILS_ROOT}/vendor/plugins/acts_as_zipcoded/zips.csv' into table zips fields terminated by ',' lines terminated by '\n'"
    # if this doesn't work for you for some reason you can always import them from the YAML file zips.yml.gz
  end

  def self.down
    drop_table :zips
  end
end