Contents

class CreateStreetNumbers < ActiveRoad::Migration
  def self.up
    create_table :street_numbers do |t|
      t.string :number
      t.float :location_on_road
      t.belongs_to :physical_road
      t.point :geometry, :srid => ActiveRoad.srid
      t.timestamps
    end

    add_index :street_numbers, [:number, :physical_road_id]
    add_index :street_numbers, :physical_road_id
  end

  def self.down
    drop_table :street_numbers
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
active_road-0.0.3	db/migrate/20110914160756_create_street_numbers.rb
active_road-0.0.2	db/migrate/20110914160756_create_street_numbers.rb