Refs #3047: Associate RoutingConstraintZone with StopPoints

2 files changed, 8 insertions, 2 deletions

diff --git a/db/migrate/20170405122823_rm_stop_areas_add_stop_points_to_routing_constraint_zone.rb b/db/migrate/20170405122823_rm_stop_areas_add_stop_points_to_routing_constraint_zone.rb
new file mode 100644
index 000000000..67bc2623c
--- /dev/null
+++ b/db/migrate/20170405122823_rm_stop_areas_add_stop_points_to_routing_constraint_zone.rb
@@ -0,0 +1,6 @@
+class RmStopAreasAddStopPointsToRoutingConstraintZone < ActiveRecord::Migration
+  def change
+    remove_column :routing_constraint_zones, :stop_area_ids, :integer, array: true
+    add_column :routing_constraint_zones, :stop_point_ids, :bigint, array: true
+  end
+end
diff --git a/db/schema.rb b/db/schema.rb
index 53e3ad57c..967722d5c 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -11,7 +11,7 @@
 #
 # It's strongly recommended that you check this file into your version control system.
 
-ActiveRecord::Schema.define(version: 20170404122930) do
+ActiveRecord::Schema.define(version: 20170405122823) do
 
   # These are extensions that must be enabled in order to support this database
   enable_extension "plpgsql"
@@ -542,13 +542,13 @@ ActiveRecord::Schema.define(version: 20170404122930) do
 
   create_table "routing_constraint_zones", force: true do |t|
     t.string   "name"
-    t.integer  "stop_area_ids",                         array: true
     t.datetime "created_at"
     t.datetime "updated_at"
     t.string   "objectid",                 null: false
     t.integer  "object_version", limit: 8
     t.string   "creator_id"
     t.integer  "route_id",       limit: 8
+    t.integer  "stop_point_ids", limit: 8,              array: true
   end
 
   create_table "routing_constraints_lines", id: false, force: true do |t|