class CreateMyZipcodeGemModels
Public Class Methods
down()
click to toggle source
# File lib/generators/my_zipcode_gem/templates/migration.rb, line 39 def self.down drop_table :counties drop_table :states drop_table :zipcodes end
up()
click to toggle source
# File lib/generators/my_zipcode_gem/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 t.integer :county_id t.string :area_code 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 :abbr t.string :name t.string :county_seat t.timestamps end add_index :counties, :name add_index :counties, :state_id end