X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=htdocs%2Fdocs%2Fupgrade3.html;h=87f551d26e676e1214be60ba8d5a9700129eee28;hp=15066423e657e91500a2f1b2130e8ccbeecb4056;hb=56b98dd1587282585a92a93dbac5781da58154f1;hpb=21e5d64e7b583db49895a03ae7f485fcde3bcf88

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.