From: Ivan Kohler <ivan@freeside.biz>
Date: Sat, 26 Jul 2014 21:48:31 +0000 (-0700)
Subject: queue statistics, RT#30238
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=4faed517720e6ccf37e407dcf2856fd49a98a84b

queue statistics, RT#30238
---

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index 71442b6be..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', '', '', '', '',