preliminary vitelity export, RT#4868

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

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index e8ab6bf..885eaaa 100644 (file)
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -2014,12 +2014,15 @@ sub tables_hashref {
         #NULL, done (or something)
         'freesidestatus', 'varchar',   'NULL',     32,   '', '', 
 
+        #NULL, done (or something)
+        'freesiderewritestatus', 'varchar',   'NULL',     32,   '', '', 
+
         'cdrbatch', 'varchar', 'NULL', $char_d, '', '',
 
       ],
       'primary_key' => 'acctid',
       'unique' => [],
-      'index' => [ [ 'calldate' ], [ 'src' ], [ 'dst' ], [ 'charged_party' ], [ 'accountcode' ], [ 'freesidestatus' ], [ 'cdrbatch' ], ],
+      'index' => [ [ 'calldate' ], [ 'src' ], [ 'dst' ], [ 'charged_party' ], [ 'accountcode' ], [ 'freesidestatus' ], [ 'freesiderewritestatus' ], [ 'cdrbatch' ], ],
     },
 
     'cdr_calltype' => {
@@ -2188,15 +2191,16 @@ sub tables_hashref {
 
     'phone_avail' => {
       'columns' => [
-        'availnum',    'serial',   '', '', '', '', 
-        'exportnum',   'int',      '', '', '', '', 
-        'countrycode', 'varchar',  '',  3, '', '', 
-        'state',       'char', 'NULL',  2, '', '', 
-        'npa',         'char',     '',  3, '', '', 
-        'nxx',         'char', 'NULL',  3, '', '', 
-        'station',     'char', 'NULL',  4, '', '',
+        'availnum',    'serial',      '',      '', '', '', 
+        'exportnum',   'int',         '',      '', '', '', 
+        'countrycode', 'varchar',     '',       3, '', '', 
+        'state',       'char',    'NULL',       2, '', '', 
+        'npa',         'char',        '',       3, '', '', 
+        'nxx',         'char',    'NULL',       3, '', '', 
+        'station',     'char',    'NULL',       4, '', '',
+        'name',        'varchar', 'NULL', $char_d, '', '',
         'svcnum',      'int',     'NULL',      '', '', '',
-        'availbatch', 'varchar', 'NULL', $char_d, '', '',
+        'availbatch', 'varchar',  'NULL', $char_d, '', '',
       ],
       'primary_key' => 'availnum',
       'unique' => [],