diff options
Diffstat (limited to 'htdocs/docs')
| -rw-r--r-- | htdocs/docs/schema.html | 5 | ||||
| -rw-r--r-- | htdocs/docs/upgrade3.html | 9 |
2 files changed, 13 insertions, 1 deletions
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. |