X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=htdocs%2Fdocs%2Fupgrade3.html;h=0837e0207cac41e94789c76a13f9be2b0c65a6a4;hb=c30183b25bfe0f99b96bbe9f1baf099fec323d02;hp=15066423e657e91500a2f1b2130e8ccbeecb4056;hpb=ef834d58bfd2ce38c8bea73262c8091a5d88388f;p=freeside.git diff --git a/htdocs/docs/upgrade3.html b/htdocs/docs/upgrade3.html index 15066423e..0837e0207 100644 --- a/htdocs/docs/upgrade3.html +++ b/htdocs/docs/upgrade3.html @@ -2,7 +2,7 @@
-ALTER TABLE cust_main ADD middle varchar(80) 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 ( +ALTER TABLE cust_main CHANGE paydate paydate varchar(10); +UPDATE cust_main SET country = "US" where country IS NULL OR country = ''; +UPDATE cust_main_county SET country = "US" where country IS NULL OR country = ""; +CREATE TABLE cust_main_invoice ( + destnum int NOT NULL, + custnum int NOT NULL, + dest varchar(80) NOT NULL, + PRIMARY KEY (destnum), + INDEX ( custnum ) +);-