Class: CreatePinasTables

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

Instance Method Summary collapse

Instance Method Details

#change ⇒ Object 



2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
 
# File 'lib/generators/templates/migration.rb', line 2

def change
  create_table(:locations) do |t|
    t.references  :parent
    t.integer     :lft
    t.integer     :rgt
    t.string      :location_type
    t.string      :code
    t.string      :name
    t.boolean     :city,   :default => false, :null => false
    t.string      :income_class
    t.string      :urban_rural
    t.string      :district
    t.string      :postcode
    t.string      :longitude
    t.string      :latitude
    t.timestamps null: false
  end
  add_index :locations, :parent_id
  add_index :locations, :postcode
  add_index :locations, [:name, :location_type, :postcode]
end