summaryrefslogtreecommitdiff
path: root/htdocs/docs/upgrade3.html
diff options
context:
space:
mode:
Diffstat (limited to 'htdocs/docs/upgrade3.html')
-rw-r--r--htdocs/docs/upgrade3.html9
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.