X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=bin%2Ffs-setup;h=5e735294f5c2419fe76dda9f4244c380ecb5170d;hp=2cba840ef2c1dd24fd06a9368863291816f7090d;hb=8c1f9804d9a02c0c054eededeb500c72a640249a;hpb=cdd5aa1d86cd5b266e02bed58570c97c2d7698ba diff --git a/bin/fs-setup b/bin/fs-setup index 2cba840ef..5e735294f 100755 --- a/bin/fs-setup +++ b/bin/fs-setup @@ -1,6 +1,6 @@ #!/usr/bin/perl -Tw # -# $Id: fs-setup,v 1.45 2001-09-01 20:11:07 ivan Exp $ +# $Id: fs-setup,v 1.48 2001-09-02 02:46:55 ivan Exp $ #to delay loading dbdef until we're ready BEGIN { $FS::Record::setup_hack = 1; } @@ -317,6 +317,19 @@ sub tables_hash_hack { 'index' => [ ['custnum'] ], }, + 'cust_credit_bill' => { + 'columns' => [ + 'creditbillnum', 'int', '', '', + 'crednum', 'int', '', '', + 'invnum', 'int', '', '', + '_date', @date_type, + 'amount', @money_type, + ], + 'primary_key' => 'creditbillnum', + 'unique' => [ [] ], + 'index' => [ ['crednum'], ['invnum'] ], + }, + 'cust_main' => { 'columns' => [ 'custnum', 'int', '', '', @@ -399,6 +412,7 @@ sub tables_hash_hack { 'columns' => [ 'paynum', 'int', '', '', #now cust_bill_pay #'invnum', 'int', '', '', + 'custnum', 'int', '', '', 'paid', @money_type, '_date', @date_type, 'payby', 'char', '', 4, # CARD/BILL/COMP, should be index into @@ -408,7 +422,7 @@ sub tables_hash_hack { ], 'primary_key' => 'paynum', 'unique' => [ [] ], - 'index' => [ ['invnum'] ], + 'index' => [ [] ], }, 'cust_bill_pay' => { @@ -470,6 +484,7 @@ sub tables_hash_hack { 'columns' => [ 'refundnum', 'int', '', '', #now cust_credit_refund #'crednum', 'int', '', '', + 'custnum', 'int', '', '', '_date', @date_type, 'refund', @money_type, 'otaker', 'varchar', '', 8,