X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=0a70eb6bc0a699bb428f8c482f69f55a7f731794;hb=ec863ef089ed20e21caeea235924de5b5d0e6fd7;hp=2444198b83278ad4c16d4884f7a5b794454486c6;hpb=1998865b297db76e541b4a144618bf9b9ef80aa2;p=freeside.git diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index 2444198b8..0a70eb6bc 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -820,10 +820,13 @@ sub tables_hashref { 'closed', 'char', 'NULL', 1, '', '', 'pkgnum', 'int', 'NULL', '', '', '', #desired pkgnum for pkg-balances 'eventnum', 'int', 'NULL', '', '', '', #triggering event for commission + 'credbatch', 'varchar', 'NULL', $char_d, '', '', ], 'primary_key' => 'crednum', 'unique' => [], - 'index' => [ ['custnum'], ['_date'], ['usernum'], ['eventnum'] ], + 'index' => [ ['custnum'], ['_date'], ['usernum'], ['eventnum'], + ['credbatch'], + ], }, 'cust_credit_bill' => {