From 60c10ab363668ec3016306e6069eaade9e04d544 Mon Sep 17 00:00:00 2001 From: ivan Date: Sat, 1 Sep 2001 22:18:38 +0000 Subject: add primary key --- bin/fs-setup | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) (limited to 'bin') diff --git a/bin/fs-setup b/bin/fs-setup index 8fbc67ef3..71d53ef85 100755 --- a/bin/fs-setup +++ b/bin/fs-setup @@ -1,6 +1,6 @@ #!/usr/bin/perl -Tw # -# $Id: fs-setup,v 1.46 2001-09-01 21:52:20 jeff Exp $ +# $Id: fs-setup,v 1.47 2001-09-01 22:18:38 ivan Exp $ #to delay loading dbdef until we're ready BEGIN { $FS::Record::setup_hack = 1; } @@ -319,14 +319,15 @@ sub tables_hash_hack { 'cust_credit_bill' => { 'columns' => [ + 'creditbillnum', 'int', '', '', 'crednum', 'int', '', '', 'invnum', 'int', '', '', '_date', @date_type, 'amount', @money_type, ], - 'primary_key' => 'crednum', + 'primary_key' => 'creditbillnum', 'unique' => [ [] ], - 'index' => [ ['invnum'] ], + 'index' => [ ['crednum'], ['invnum'] ], }, 'cust_main' => { @@ -420,7 +421,7 @@ sub tables_hash_hack { ], 'primary_key' => 'paynum', 'unique' => [ [] ], - 'index' => [ ['invnum'] ], + 'index' => [ [] ], }, 'cust_bill_pay' => { -- cgit v1.2.1