add migration coming from ninoxe

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