Fix custom_fields migration on company to convert json to jsonb Refs #6426 @1

1 files changed, 4 insertions, 1 deletions

diff --git a/db/migrate/20180405133659_change_companies_custom_fields_values_type.rb b/db/migrate/20180405133659_change_companies_custom_fields_values_type.rb
index b2b6804c7..7248c29f6 100644
--- a/db/migrate/20180405133659_change_companies_custom_fields_values_type.rb
+++ b/db/migrate/20180405133659_change_companies_custom_fields_values_type.rb
@@ -1,5 +1,8 @@
 class ChangeCompaniesCustomFieldsValuesType < ActiveRecord::Migration
   def change
-     change_column :companies, :custom_field_values, :jsonb
+    reversible do |dir|
+      dir.up { change_column :companies, :custom_field_values, 'jsonb USING CAST(custom_field_values AS jsonb)', :default => {} }
+      dir.down { change_column :companies, :custom_field_values, 'json USING CAST(custom_field_values AS json)', :default => {} }
+    end
   end
 end