X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=7cf4c72945477041ed93ea3f186dd267ac17bbc5;hb=4faed517720e6ccf37e407dcf2856fd49a98a84b;hp=c2d9595444490e9f7a0de2debb11afd76e994fca;hpb=14f73cfb3943afdadd37a5a4d5d765be55832305;p=freeside.git

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index c2d959544..7cf4c7294 100644
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -2901,6 +2901,21 @@ sub tables_hashref {
       'index'       => [ [ 'jobnum' ], [ 'depend_jobnum' ] ],
     },
 
+    'queue_stat' => {
+      'columns' => [
+        'statnum', 'bigserial',     '',  '', '', '',
+        'jobnum',     'bigint',     '',  '', '', '',
+        'job',       'varchar',     '', 512, '', '', 
+        'custnum',       'int', 'NULL',  '', '', '',
+        'insert_date', @date_type, '', '',
+        'start_date',  @date_type, '', '', 
+        'end_date',    @date_type, '', '', 
+      ],
+      'primary_key'  => 'statnum',
+      'unique'       => [], #[ ['jobnum'] ],
+      'index'        => [],
+    },
+
     'export_svc' => {
       'columns' => [
         'exportsvcnum' => 'serial', '', '', '', '', 
@@ -4551,7 +4566,7 @@ sub tables_hashref {
         'exportnum',      'int',     '',      '', '', '',
         '_date',          'int',     '',      '', '', '',
         'status',     'varchar', 'NULL',      32, '', '',
-        'statustext', 'varchar', 'NULL', $char_d, '', '',
+        'statustext',    'text', 'NULL',      '', '', '',
       ],
       'primary_key'  => 'batchnum',
       'unique'       => [],
@@ -4581,10 +4596,6 @@ sub tables_hashref {
                             table      => 'export_batch',
                             references => [ 'batchnum' ]
                           },
-                          { columns    => [ 'svcnum' ],
-                            table      => 'cust_svc',
-                            references => [ 'svcnum' ]
-                          },
                         ],
     },