diff options
author | ivan <ivan> | 2001-09-01 22:18:38 +0000 |
---|---|---|
committer | ivan <ivan> | 2001-09-01 22:18:38 +0000 |
commit | 60c10ab363668ec3016306e6069eaade9e04d544 (patch) | |
tree | 1bafc60565d93299b827a777f2528ca43472b253 /bin | |
parent | f918ef6adbc3c19e705e2f5fda1efe135f3554c8 (diff) |
add primary key
Diffstat (limited to 'bin')
-rwxr-xr-x | bin/fs-setup | 9 |
1 files changed, 5 insertions, 4 deletions
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' => { |