Add data_source_ref for model Route, JourneyPattern, RoutingConstraintZone, VehicleJourney, Timetable, Footnote

Refs #4368

2 files changed, 18 insertions, 2 deletions

diff --git a/db/migrate/20170907082913_add_data_source_ref.rb b/db/migrate/20170907082913_add_data_source_ref.rb
new file mode 100644
index 000000000..93ca8eb5f
--- /dev/null
+++ b/db/migrate/20170907082913_add_data_source_ref.rb
@@ -0,0 +1,10 @@
+class AddDataSourceRef < ActiveRecord::Migration
+  def change
+    add_column :routes, :data_source_ref, :string
+    add_column :journey_patterns, :data_source_ref, :string
+    add_column :routing_constraint_zones, :data_source_ref, :string
+    add_column :vehicle_journeys, :data_source_ref, :string
+    add_column :time_tables, :data_source_ref, :string
+    add_column :footnotes, :data_source_ref, :string
+  end
+end
diff --git a/db/schema.rb b/db/schema.rb
index d1bd3bc2b..98e60c909 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: 20170901132253) do
+ActiveRecord::Schema.define(version: 20170907082913) do
 
   # These are extensions that must be enabled in order to support this database
   enable_extension "plpgsql"
@@ -221,6 +221,7 @@ ActiveRecord::Schema.define(version: 20170901132253) do
     t.datetime "updated_at"
     t.string   "checksum"
     t.text     "checksum_source"
+    t.string   "data_source_ref"
   end
 
   create_table "footnotes_vehicle_journeys", id: false, force: :cascade do |t|
@@ -292,9 +293,9 @@ ActiveRecord::Schema.define(version: 20170901132253) do
     t.string   "type"
     t.integer  "parent_id",             limit: 8
     t.string   "parent_type"
+    t.datetime "notified_parent_at"
     t.integer  "current_step",                    default: 0
     t.integer  "total_steps",                     default: 0
-    t.datetime "notified_parent_at"
     t.string   "creator"
   end
 
@@ -343,6 +344,7 @@ ActiveRecord::Schema.define(version: 20170901132253) do
     t.datetime "updated_at"
     t.string   "checksum"
     t.text     "checksum_source"
+    t.string   "data_source_ref"
   end
 
   add_index "journey_patterns", ["objectid"], name: "journey_patterns_objectid_key", unique: true, using: :btree
@@ -553,6 +555,7 @@ ActiveRecord::Schema.define(version: 20170901132253) do
     t.datetime "updated_at"
     t.string   "checksum"
     t.text     "checksum_source"
+    t.string   "data_source_ref"
   end
 
   add_index "routes", ["objectid"], name: "routes_objectid_key", unique: true, using: :btree
@@ -568,6 +571,7 @@ ActiveRecord::Schema.define(version: 20170901132253) do
     t.integer  "stop_point_ids",  limit: 8,              array: true
     t.string   "checksum"
     t.text     "checksum_source"
+    t.string   "data_source_ref"
   end
 
   create_table "routing_constraints_lines", id: false, force: :cascade do |t|
@@ -733,6 +737,7 @@ ActiveRecord::Schema.define(version: 20170901132253) do
     t.integer  "created_from_id"
     t.string   "checksum"
     t.text     "checksum_source"
+    t.string   "data_source_ref"
   end
 
   add_index "time_tables", ["calendar_id"], name: "index_time_tables_on_calendar_id", using: :btree
@@ -838,6 +843,7 @@ ActiveRecord::Schema.define(version: 20170901132253) do
     t.datetime "updated_at"
     t.string   "checksum"
     t.text     "checksum_source"
+    t.string   "data_source_ref"
   end
 
   add_index "vehicle_journeys", ["objectid"], name: "vehicle_journeys_objectid_key", unique: true, using: :btree