From b47f4a57b637533d8a4e0645b1303b0d5af50a8e Mon Sep 17 00:00:00 2001
From: Marc Florisson
Date: Fri, 3 Jul 2015 16:28:47 +0200
Subject: add migration coming from ninoxe

---
 ...ueness_for_registration_number.ninoxe_engine.rb | 23 ++++++++++++++++++++++
 1 file changed, 23 insertions(+)
 create mode 100644 db/migrate/20150703141935_remove_uniqueness_for_registration_number.ninoxe_engine.rb

(limited to 'db')

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
-- 
cgit v1.2.3