X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=htdocs%2Fdocs%2Fupgrade3.html;h=87f551d26e676e1214be60ba8d5a9700129eee28;hb=d1407e95ff695055c3609eeee7599b32f3b54c54;hp=181cf2a42ad62a278fabf384b2d112c7d862bb96;hpb=d8bb43c4735c6faab56eba98459d8732eb45fa68;p=freeside.git diff --git a/htdocs/docs/upgrade3.html b/htdocs/docs/upgrade3.html index 181cf2a42..87f551d26 100644 --- a/htdocs/docs/upgrade3.html +++ b/htdocs/docs/upgrade3.html @@ -9,5 +9,31 @@
+ALTER TABLE cust_main ADD middle varchar(80) NULL; +ALTER TABLE cust_main ADD titlenum int NULL; +ALTER TABLE cust_main CHANGE state state varchar(80) NULL; +ALTER TABLE cust_main_county CHANGE state state varchar(80) NULL; +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) 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 ) +); ++