From: Ivan Kohler <ivan@freeside.biz>
Date: Mon, 30 Dec 2013 22:27:43 +0000 (-0800)
Subject: unique contact emails, RT#25533
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=d535444f90993fb7b16928e3f2f342603016623b

unique contact emails, RT#25533
---

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index 301111d50..862e40afa 100644
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -1739,7 +1739,8 @@ sub tables_hashref {
         'emailaddress',   'varchar', '', $char_d, '', '',
       ],
       'primary_key'  => 'contactemailnum',
-      'unique'       => [ [ 'contactnum', 'emailaddress' ], ],
+      #'unique'       => [ [ 'contactnum', 'emailaddress' ], ],
+      'unique'       => [ [ 'emailaddress' ], ],
       'index'        => [],
       'foreign_keys' => [
                           { columns    => [ 'contactnum' ],