X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=71442b6bed21dc039a87f97a47fdfccedc061e45;hb=8577c7ca4210f58be1d0188bd0d45d44f899ec40;hp=4ad9cec149e458d2f467843cad11a13028b11173;hpb=acc311a412cd8660572eb6de6712a1e0b2768ec1;p=freeside.git

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index 4ad9cec14..71442b6be 100644
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -2815,7 +2815,7 @@ sub tables_hashref {
       ],
       'primary_key' => 'prepaynum',
       'unique'      => [ ['identifier'] ],
-      'index'       => [],
+      'index'       => [ ['agentnum'] ],
     },
 
     'port' => {
@@ -4551,7 +4551,7 @@ sub tables_hashref {
         'exportnum',      'int',     '',      '', '', '',
         '_date',          'int',     '',      '', '', '',
         'status',     'varchar', 'NULL',      32, '', '',
-        'statustext', 'varchar', 'NULL', $char_d, '', '',
+        'statustext',    'text', 'NULL',      '', '', '',
       ],
       'primary_key'  => 'batchnum',
       'unique'       => [],
@@ -4569,7 +4569,7 @@ sub tables_hashref {
         'itemnum',     'serial',     '',      '', '', '',
         'batchnum',       'int',     '',      '', '', '',
         'svcnum',         'int',     '',      '', '', '',
-        'action',     'varchar',     32,      '', '', '',
+        'action',     'varchar',     '',      32, '', '',
         'data',          'text', 'NULL',      '', '', '',
         'frozen',        'char', 'NULL',       1, '', '',
       ],
@@ -4581,10 +4581,6 @@ sub tables_hashref {
                             table      => 'export_batch',
                             references => [ 'batchnum' ]
                           },
-                          { columns    => [ 'svcnum' ],
-                            table      => 'cust_svc',
-                            references => [ 'svcnum' ]
-                          },
                         ],
     },