Add `costs` column to `Chouette::Route`

This allows us to store `WayCost`s for a route so we can use those
values as pre-filled defaults for a `JourneyPattern`'s costs.

Refs #6095

2 files changed, 8 insertions, 1 deletions

diff --git a/db/migrate/20180313110900_add_costs_to_routes.rb b/db/migrate/20180313110900_add_costs_to_routes.rb
new file mode 100644
index 000000000..d47e86cf0
--- /dev/null
+++ b/db/migrate/20180313110900_add_costs_to_routes.rb
@@ -0,0 +1,5 @@
+class AddCostsToRoutes < ActiveRecord::Migration
+  def change
+    add_column :routes, :costs, :json
+  end
+end
diff --git a/db/schema.rb b/db/schema.rb
index cf0a32a3b..cd7d66692 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -11,7 +11,8 @@
 #
 # It's strongly recommended that you check this file into your version control system.
 
-ActiveRecord::Schema.define(version: 20180308095116) do
+ActiveRecord::Schema.define(version: 20180313110900) do
+
   # These are extensions that must be enabled in order to support this database
   enable_extension "plpgsql"
   enable_extension "postgis"
@@ -742,6 +743,7 @@ ActiveRecord::Schema.define(version: 20180308095116) do
     t.string   "checksum"
     t.text     "checksum_source"
     t.string   "data_source_ref"
+    t.json     "costs"
   end
 
   add_index "routes", ["objectid"], name: "routes_objectid_key", unique: true, using: :btree