diff options
| -rw-r--r-- | db/migrate/20150703141935_remove_uniqueness_for_registration_number.ninoxe_engine.rb | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/db/migrate/20150703141935_remove_uniqueness_for_registration_number.ninoxe_engine.rb b/db/migrate/20150703141935_remove_uniqueness_for_registration_number.ninoxe_engine.rb new file mode 100644 index 000000000..a9e6d6d84 --- /dev/null +++ b/db/migrate/20150703141935_remove_uniqueness_for_registration_number.ninoxe_engine.rb @@ -0,0 +1,23 @@ +# This migration comes from ninoxe_engine (originally 20150630135517) +class RemoveUniquenessForRegistrationNumber < ActiveRecord::Migration + def up + remove_index "lines", name: "lines_registration_number_key" if index_exists?(:lines, :registration_number, name: "lines_registration_number_key") + add_index "lines", ["registration_number"], :name => "lines_registration_number_key" + + remove_index "companies", name: "companies_registration_number_key" if index_exists?(:companies, :registration_number, name: "companies_registration_number_key") + add_index "companies", ["registration_number"], :name => "companies_registration_number_key" + + remove_index "networks", name: "networks_registration_number_key" if index_exists?(:networks, :registration_number, name: "networks_registration_number_key") + add_index "networks", ["registration_number"], :name => "networks_registration_number_key" + end + def down + remove_index "lines", name: "lines_registration_number_key" if index_exists?(:lines, :registration_number, name: "lines_registration_number_key") + add_index "lines", ["registration_number"], :name => "lines_registration_number_key", :unique => true + + remove_index "companies", name: "companies_registration_number_key" if index_exists?(:companies, :registration_number, name: "companies_registration_number_key") + add_index "companies", ["registration_number"], :name => "companies_registration_number_key", :unique => true + + remove_index "networks", name: "networks_registration_number_key" if index_exists?(:networks, :registration_number, name: "networks_registration_number_key") + add_index "networks", ["registration_number"], :name => "networks_registration_number_key", :unique => true + end +end |