diff options
| -rwxr-xr-x | bin/fs-setup | 18 | ||||
| -rw-r--r-- | htdocs/docs/schema.html | 5 | ||||
| -rw-r--r-- | htdocs/docs/upgrade3.html | 9 |
3 files changed, 29 insertions, 3 deletions
diff --git a/bin/fs-setup b/bin/fs-setup index 19ac53377..9f8740093 100755 --- a/bin/fs-setup +++ b/bin/fs-setup @@ -1,6 +1,6 @@ #!/usr/bin/perl -Tw # -# $Id: fs-setup,v 1.9 1998-12-15 04:36:29 ivan Exp $ +# $Id: fs-setup,v 1.10 1998-12-16 06:05:38 ivan Exp $ # # ivan@sisd.com 97-nov-8,9 # @@ -32,7 +32,10 @@ # fix radius attributes ivan@sisd.com 98-sep-27 # # $Log: fs-setup,v $ -# Revision 1.9 1998-12-15 04:36:29 ivan +# Revision 1.10 1998-12-16 06:05:38 ivan +# add table cust_main_invoice +# +# Revision 1.9 1998/12/15 04:36:29 ivan # s/croak/die/; #oops # # Revision 1.8 1998/12/15 04:33:27 ivan @@ -368,6 +371,17 @@ sub tables_hash_hack { 'index' => [ ['last'], ], }, + 'cust_main_invoice' => { + 'columns' => [ + 'destnum', 'int', '', '', + 'custnum', 'int', '', '', + 'dest', 'varchar', '', $char_d, + ], + 'primary_key' => 'destnum', + 'unique' => [ [] ], + 'index' => [ ['custnum'], ], + }, + 'cust_main_county' => { #county+state+country are checked off the #cust_main_county for validation and to provide # a tax rate. diff --git a/htdocs/docs/schema.html b/htdocs/docs/schema.html index f7a9bc101..c561a5ab3 100644 --- a/htdocs/docs/schema.html +++ b/htdocs/docs/schema.html @@ -72,6 +72,11 @@ <li>tax - tax exempt, Y or null <li>otaker - order taker </ul> + <li><a name="cust_main_invoice">cust_main_invoice</a> - Invoice destinations for email invoices + <ul> + <li>destnum - primary key + <li>custnum - <a href="#cust_main">customer</a> + <li>dest - Invoice destination: <a href="#svc_acct">svcnum</a> if numeric, literal email address if string <li><a name="cust_main_county">cust_main_county</a> - Tax rates <ul> <li>taxnum - primary key diff --git a/htdocs/docs/upgrade3.html b/htdocs/docs/upgrade3.html index 15066423e..87f551d26 100644 --- a/htdocs/docs/upgrade3.html +++ b/htdocs/docs/upgrade3.html @@ -22,9 +22,16 @@ ALTER TABLE cust_main_county ADD country char(2); UPDATE cust_main_county SET country = "US" where country IS NULL; CREATE TABLE part_title ( titlenum int NOT NULL, - title varchar(80), + title varchar(80) NOT NULL, PRIMARY KEY (titlenum) ); +CREATE TABLE cust_main_invoice ( + destnum int NOT NULL, + custnum int NOT NULL, + dest varchar(80) NOT NULL, + PRIMARY KEY (destnum), + INDEX ( custnum ) +); </pre> <li>Run bin/dbdef-create. This file uses MySQL-specific syntax. If you are r unning a different database engine you will need to modify it slightly. |