class CreateUsZipcodeModels
Public Class Methods
down()
click to toggle source
# File lib/generators/us_zipcode/templates/migration.rb, line 36 def self.down drop_table :counties drop_table :states drop_table :zipcodes end
up()
click to toggle source
# File lib/generators/us_zipcode/templates/migration.rb, line 2 def self.up # Zipcodes Table create_table :zipcodes do |t| t.string :code t.string :city t.integer :state_id, foreign_key: true t.integer :county_id, foreign_key: true t.decimal :lat, :precision => 15, :scale => 10 t.decimal :lon, :precision => 15, :scale => 10 t.timestamps end add_index :zipcodes, :code add_index :zipcodes, :county_id add_index :zipcodes, :state_id add_index :zipcodes, [:lat, :lon] # States Table create_table :states do |t| t.string :abbr, :limit => 2 t.string :name t.timestamps end add_index :states, :abbr # Counties Table create_table :counties do |t| t.integer :state_id t.string :name t.timestamps end add_index :counties, :name add_index :counties, :state_id end