X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=ff40cd6739088939e580643274ef3a113f402c4d;hp=3fc26b07154a2f294fbfbe8e00b91a41283ccf03;hb=8c450aab9bae89373c2c1b35c85597bb52299de3;hpb=2528cc7b182781a82844d8bbb1b555560487abc7 diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index 3fc26b071..ff40cd673 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -1408,6 +1408,7 @@ sub tables_hashref { 'depositor', 'varchar', 'NULL', $char_d, '', '', 'account', 'varchar', 'NULL', 20, '', '', 'teller', 'varchar', 'NULL', 20, '', '', + 'batchnum', 'int', 'NULL', '', '', '', #pay_batch foreign key ], 'primary_key' => 'paynum', #i guess not now, with cust_pay_pending, if we actually make it here, we _do_ want to record it# 'unique' => [ [ 'payunique' ] ], @@ -1487,10 +1488,11 @@ sub tables_hashref { 'columns' => [ 'batchnum', 'serial', '', '', '', '', 'agentnum', 'int', 'NULL', '', '', '', - 'payby', 'char', '', 4, '', '', # CARD/CHEK + 'payby', 'char', '', 4, '', '', # CARD/CHEK 'status', 'char', 'NULL', 1, '', '', 'download', @date_type, '', '', 'upload', @date_type, '', '', + 'title', 'varchar', 'NULL',255, '', '', ], 'primary_key' => 'batchnum', 'unique' => [],