X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=6ea060963ae0bafea10401f09c61e2ddbf216623;hp=2a7a9d1774bce60a65620f754f318b33a47227e8;hb=25386efd0e3f725d6cef005eba729840d3b4b3cb;hpb=d5988a9f7a3617de33da3058f2e9f1151b24420e

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index 2a7a9d177..6ea060963 100644
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -4168,7 +4168,7 @@ sub tables_hashref {
         'note',     'text',    'NULL',      '', '', '',
       ],
       'primary_key'  => 'svcnum',
-      'unique'       => [],
+      'unique'       => [ ['typenum', 'serial'], ['ip_addr'], ['hw_addr'] ],
       'index'        => [],
       'foreign_keys' => [
                           { columns    => [ 'svcnum' ],
@@ -6902,7 +6902,7 @@ sub tables_hashref {
         'mac_addr',  'varchar', 'NULL',      12, '', '', 
       ],
       'primary_key'  => 'svcnum',
-      'unique'       => [ ['serialnum'] , ['mac_addr'] ],
+      'unique'       => [ ['modelnum', 'serialnum'] , ['mac_addr'] ],
       'index'        => [],
       'foreign_keys' => [
                           { columns    => [ 'svcnum' ],