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