diff options
author | ivan <ivan> | 2002-05-04 15:00:18 +0000 |
---|---|---|
committer | ivan <ivan> | 2002-05-04 15:00:18 +0000 |
commit | f36b6a178c9811357ff5d5291874aa239d22bc2a (patch) | |
tree | 6d736d1e181ba0865ad739cc94c971a441d6a4d0 /bin | |
parent | 8af9903c96ca6a3d78e7779cbc4c5e773aaf3ae0 (diff) |
schema changes for proper texas tax
Diffstat (limited to 'bin')
-rwxr-xr-x | bin/fs-setup | 21 |
1 files changed, 20 insertions, 1 deletions
diff --git a/bin/fs-setup b/bin/fs-setup index 37ecf1b87..e05d44531 100755 --- a/bin/fs-setup +++ b/bin/fs-setup @@ -1,6 +1,6 @@ #!/usr/bin/perl -Tw # -# $Id: fs-setup,v 1.89 2002-04-20 06:33:03 ivan Exp $ +# $Id: fs-setup,v 1.90 2002-05-04 15:00:18 ivan Exp $ #to delay loading dbdef until we're ready BEGIN { $FS::Record::setup_hack = 1; } @@ -518,6 +518,8 @@ sub tables_hash_hack { 'state', 'varchar', 'NULL', $char_d, 'county', 'varchar', 'NULL', $char_d, 'country', 'char', '', 2, + 'taxclass', 'varchar', 'NULL', $char_d, + 'exempt_amount', @money_type, 'tax', 'real', '', '', #tax % ], 'primary_key' => 'taxnum', @@ -659,6 +661,7 @@ sub tables_hash_hack { 'plan', 'varchar', 'NULL', $char_d, 'plandata', 'text', 'NULL', '', 'disabled', 'char', 'NULL', 1, + 'taxclass', 'varchar', 'NULL', $char_d, ], 'primary_key' => 'pkgpart', 'unique' => [ [] ], @@ -989,6 +992,22 @@ sub tables_hash_hack { 'index' => [], }, + 'cust_tax_exempt' => { + 'columns' => [ + 'exemptnum', 'int', '', '', + 'custnum', 'int', '', '', + 'taxnum', 'int', '', '', + 'year', 'int', '', '', + 'month', 'int', '', '', + 'amount', @money_type, + ], + 'primary_key' => 'exemptnum', + 'unique' => [ [ 'custnum', 'taxnum', 'year', 'month' ] ], + 'index' => [], + }, + + + ); %tables; |