LNP improvements, RT9527

[freeside.git] / FS / FS / Schema.pm

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index b8ba5b2..393d05f 100644 (file)
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -352,8 +352,8 @@ sub tables_hashref {
         'invoice_template', 'varchar', 'NULL', $char_d, '', '',
         'agent_custnum',        'int', 'NULL',      '', '', '',
         'disabled',            'char', 'NULL',       1, '', '', 
-        'username',         'varchar', 'NULL', $char_d, '', '', #deprecated
-        '_password',        'varchar', 'NULL', $char_d, '', '', #deprecated
+        'username',         'varchar', 'NULL', $char_d, '', '',
+        '_password',        'varchar', 'NULL', $char_d, '', '',
         'freq',              'int', 'NULL', '', '', '', #deprecated (never used)
         'prog',                     @perl_type, '', '', #deprecated (never used)
       ],
@@ -1601,6 +1601,7 @@ sub tables_hashref {
         'svcpart',    'int',    '',   '', '', '', 
         'quantity',   'int',    '',   '', '', '', 
         'primary_svc','char', 'NULL',  1, '', '', 
+        'hidden',     'char', 'NULL',  1, '', '',
       ],
       'primary_key' => 'pkgsvcnum',
       'unique' => [ ['pkgpart', 'svcpart'] ],
@@ -1701,6 +1702,8 @@ sub tables_hashref {
         'pbxsvc',    'int', 'NULL', '', '', '',
         'last_login',  @date_type, '', '', 
         'last_logout', @date_type, '', '', 
+        #cardfortress field(s)
+        'cf_privatekey',      'text', 'NULL',      '', '', '',
         #communigate pro fields (quota = MaxAccountSize)
         'cgp_aliases',     'varchar', 'NULL',     255, '', '',
         #settings
@@ -2768,6 +2771,14 @@ sub tables_hashref {
         'pbxsvc',           'int', 'NULL',      '', '', '',
         'domsvc',           'int', 'NULL',      '', '', '', 
         'locationnum',      'int', 'NULL', '', '', '',
+        'lnp_status',   'varchar', 'NULL', $char_d, '', '',
+        'portable',    'char', 'NULL',       1,  '', '', 
+        'lrn',     'char',     'NULL',      10, '', '', 
+       'lnp_desired_due_date',     'int', 'NULL',       '', '', '',
+       'lnp_due_date',     'int', 'NULL',       '', '', '',
+        'lnp_other_provider', 'varchar', 'NULL', $char_d,  '', '',
+        'lnp_other_provider_account', 'varchar', 'NULL', $char_d,  '', '',
+        'lnp_reject_reason', 'varchar', 'NULL', $char_d,  '', '',
       ],
       'primary_key' => 'svcnum',
       'unique' => [],
@@ -2992,7 +3003,43 @@ sub tables_hashref {
       'unique' => [],
       'index'  => [], #recnum
     },
+
+    '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