Fixes: #5505@0.25h; Invesitgating the failure to compute a distinct join on vehicle_journeys

  Solution: custom_field_values: json -> jsonb

2 files changed, 7 insertions, 2 deletions

diff --git a/db/migrate/20180110071946_change_custom_fields_from_json_to_text_in_vehicle_journeys.rb b/db/migrate/20180110071946_change_custom_fields_from_json_to_text_in_vehicle_journeys.rb
new file mode 100644
index 000000000..c43620b32
--- /dev/null
+++ b/db/migrate/20180110071946_change_custom_fields_from_json_to_text_in_vehicle_journeys.rb
@@ -0,0 +1,5 @@
+class ChangeCustomFieldsFromJsonToTextInVehicleJourneys < ActiveRecord::Migration
+  def change
+    change_column :vehicle_journeys, :custom_field_values, :jsonb
+  end
+end
diff --git a/db/schema.rb b/db/schema.rb
index e415d4b83..e50a1c146 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: 20180109180350) do
+ActiveRecord::Schema.define(version: 20180110071946) do
 
   # These are extensions that must be enabled in order to support this database
   enable_extension "plpgsql"
@@ -973,7 +973,7 @@ ActiveRecord::Schema.define(version: 20180109180350) do
     t.string   "checksum"
     t.text     "checksum_source"
     t.string   "data_source_ref"
-    t.json     "custom_field_values"
+    t.jsonb    "custom_field_values"
   end
 
   add_index "vehicle_journeys", ["objectid"], name: "vehicle_journeys_objectid_key", unique: true, using: :btree