Disable companies foreign keys. Refs #905

1 files changed, 17 insertions, 0 deletions

diff --git a/db/migrate/20160909125235_disable_company_foreign_keys.rb b/db/migrate/20160909125235_disable_company_foreign_keys.rb
new file mode 100644
index 000000000..1679a1ed5
--- /dev/null
+++ b/db/migrate/20160909125235_disable_company_foreign_keys.rb
@@ -0,0 +1,17 @@
+class DisableCompanyForeignKeys < ActiveRecord::Migration
+  def change
+    disable_foreign_key :companies, :vj_company_fkey
+  end
+
+  def disable_foreign_key(table, name)
+    if foreign_key?(table, name)
+      remove_foreign_key table, name: name
+    end
+  end
+
+  def foreign_key?(table, name)
+    @connection.foreign_keys(table).any? do |foreign_key|
+      foreign_key.options[:name] == name.to_s
+    end
+  end
+end