Class: AddGeocodableTables

Inherits:
ActiveRecord::Migration
  • Object
show all
Defined in:
lib/generators/acts_as_geocodable/templates/migration.rb

Class Method Summary collapse

Class Method Details

.down ⇒ Object 



36
37
38
39
 
# File 'lib/generators/acts_as_geocodable/templates/migration.rb', line 36

def self.down
  drop_table  :geocodes
  drop_table  :geocodings
end

.up ⇒ Object 



2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
 
# File 'lib/generators/acts_as_geocodable/templates/migration.rb', line 2

def self.up
  create_table "geocodes" do |t|
    t.column "latitude", :decimal, :precision => 15, :scale => 12
    t.column "longitude", :decimal, :precision => 15, :scale => 12
    t.column "query", :string
    t.column "street", :string
    t.column "locality", :string
    t.column "region", :string
    t.column "postal_code", :string
    t.column "country", :string
    t.column "precision", :string
  end

  add_index "geocodes", ["longitude"], :name => "geocodes_longitude_index"
  add_index "geocodes", ["latitude"], :name => "geocodes_latitude_index"
  add_index "geocodes", ["query"], :name => "geocodes_query_index", :unique => true
  add_index "geocodes", ["locality"], :name => "geocodes_locality_index"
  add_index "geocodes", ["region"], :name => "geocodes_region_index"
  add_index "geocodes", ["postal_code"], :name => "geocodes_postal_code_index"
  add_index "geocodes", ["country"], :name => "geocodes_country_index"
  add_index "geocodes", ["precision"], :name => "geocodes_precision_index"


  create_table "geocodings" do |t|
    t.column "geocodable_id", :integer
    t.column "geocode_id", :integer
    t.column "geocodable_type", :string
  end

  add_index "geocodings", ["geocodable_type"], :name => "geocodings_geocodable_type_index"
  add_index "geocodings", ["geocode_id"], :name => "geocodings_geocode_id_index"
  add_index "geocodings", ["geocodable_id"], :name => "geocodings_geocodable_id_index"
end