diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2018-10-28 15:04:31 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2018-10-28 15:04:31 -0700 |
| commit | 57dd3d1026aca4c963df83e4208c9767755680f1 (patch) | |
| tree | c6fbf6ebd5185ddadcdfc49b72d0bbbb65b91819 /FS/FS/Schema.pm | |
| parent | 91367084a4d14bfc639d2675d20056377613ee4b (diff) | |
svc_hardware uniqueness checks, RT#81534
Diffstat (limited to 'FS/FS/Schema.pm')
| -rw-r--r-- | FS/FS/Schema.pm | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index 873c67e..8d54326 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -4134,7 +4134,7 @@ sub tables_hashref { 'note', 'text', 'NULL', '', '', '', ], 'primary_key' => 'svcnum', - 'unique' => [], + 'unique' => [ ['typenum', 'serial'], ['ip_addr'], ['hw_addr'] ], 'index' => [], 'foreign_keys' => [ { columns => [ 'svcnum' ], @@ -6844,7 +6844,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' ], |