diff options
author | ivan <ivan> | 2002-01-03 17:40:26 +0000 |
---|---|---|
committer | ivan <ivan> | 2002-01-03 17:40:26 +0000 |
commit | 69a0a7504f84aa9bb1f204d1f3522e1520e0885e (patch) | |
tree | de4cb175a70c7a7da58f84454fd29dfca55bd249 /bin | |
parent | e3f87d761538a0a21d26fc86b5bce7c9d737d590 (diff) |
more schema changes: part_bill_event and cust_bill_event tables
remove old 1.4.0pre READMEs
Diffstat (limited to 'bin')
-rwxr-xr-x | bin/fs-setup | 28 |
1 files changed, 27 insertions, 1 deletions
diff --git a/bin/fs-setup b/bin/fs-setup index e7aa3b0d9..c7335a8fb 100755 --- a/bin/fs-setup +++ b/bin/fs-setup @@ -1,6 +1,6 @@ #!/usr/bin/perl -Tw # -# $Id: fs-setup,v 1.68 2001-12-27 09:26:13 ivan Exp $ +# $Id: fs-setup,v 1.69 2002-01-03 17:40:26 ivan Exp $ #to delay loading dbdef until we're ready BEGIN { $FS::Record::setup_hack = 1; } @@ -299,6 +299,32 @@ sub tables_hash_hack { 'index' => [ ['custnum'] ], }, + 'cust_bill_event' => { + 'columns' => [ + 'eventnum', 'int', '', '', + 'invnum', 'int', '', '', + 'eventpart', 'int', '', '', + '_date', @date_type, + ], + 'primary_key' => 'eventnum', + 'unique' => [ [ 'eventpart', 'invnum' ] ], + 'index' => [ ['invnum'] ], + }, + + 'part_bill_event' => { + 'columns' => [ + 'eventpart', 'int', '', '', + 'payby', 'int', '', '', + 'event', 'varchar', '', $char_d, + 'eventcode', @perl_type, + 'seconds', 'int', 'NULL', '', + 'disabled', 'char', 'NULL', 1, + ], + 'primary_key' => 'eventpart', + 'unique' => [ [] ], + 'index' => [ ['payby'] ], + }, + 'cust_bill_pkg' => { 'columns' => [ 'pkgnum', 'int', '', '', |