From fe99f2ab76c6f941e0bad94bc50a41933bf59f3f Mon Sep 17 00:00:00 2001
From: Ivan Kohler <ivan@freeside.biz>
Date: Fri, 30 Jun 2017 13:39:11 -0700
Subject: [PATCH] prefixes should be unique

---
 FS/FS/Schema.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index 34be1a00d..b3ef4095a 100644
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -5204,7 +5204,7 @@ sub tables_hashref {
         'ocn',         'char',    'NULL',       4, '', '', 
       ],
       'primary_key'  => 'prefixnum',
-      'unique'       => [],
+      'unique'       => [ [ 'countrycode', 'npa', 'nxx' ] ],
       'index'        => [ [ 'countrycode' ], [ 'npa' ], [ 'regionnum' ] ],
       'foreign_keys' => [
                           { columns    => [ 'regionnum' ],
-- 
2.20.1