diff options
| -rw-r--r-- | FS/FS/Schema.pm | 45 |
1 files changed, 9 insertions, 36 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index 808006a9b..a2b13922c 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -3138,6 +3138,15 @@ sub tables_hashref { 'index' => [], #recnum }, + 'svc_port' => { + 'columns' => [ + 'svcnum', 'int', '', '', '', '', + ], + 'primary_key' => 'svcnum', + 'unique' => [], + 'index' => [], #recnum + }, + 'areacode' => { 'columns' => [ 'areanum', 'serial', '', '', '', '', @@ -3151,42 +3160,6 @@ sub tables_hashref { 'index' => [], }, - 'nms_device' => { - 'columns' => [ - 'nms_devicenum', 'serial', '', '', '', '', - #'agentnum', 'int', 'NULL', '', '', '', - 'devicename', 'varchar', '', $char_d, '', '', - 'ip', 'varchar', '', 15, '', '', - 'protocol', 'varchar', '', $char_d, '', '', -# 'last', 'int', '', '', '', '', - ], - 'primary_key' => 'nms_devicenum', - 'unique' => [], - 'index' => [], - }, - - 'nms_deviceport' => { - 'columns' => [ - 'portnum', 'serial', '', '', '', '', - 'nms_devicenum', 'int', '', '', '', '', - 'deviceport', 'int', '', '', '', '', - #'ip', 'varchar', 'NULL', 15, '', '', - 'svcnum', 'int', 'NULL', '', '', '', - ], - 'primary_key' => 'portnum', - 'unique' => [ [ 'nms_devicenum', 'deviceport' ] ], - 'index' => [ [ 'svcnum' ] ], - }, - - 'svc_port' => { - 'columns' => [ - 'svcnum', 'int', '', '', '', '', - ], - 'primary_key' => 'svcnum', - 'unique' => [], - 'index' => [], #recnum - }, - # name type nullability length default local |