X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=htdocs%2Fdocs%2Fupgrade3.html;h=0837e0207cac41e94789c76a13f9be2b0c65a6a4;hb=12debb17cbd12e68261dc7f98e39bfbc3915e6f6;hp=539fe5d821a3cc084a302f1343c6d2fcea7b7e03;hpb=c93520accf00e15095e7af5fcb59caed2bd9e556;p=freeside.git
diff --git a/htdocs/docs/upgrade3.html b/htdocs/docs/upgrade3.html
index 539fe5d82..0837e0207 100644
--- a/htdocs/docs/upgrade3.html
+++ b/htdocs/docs/upgrade3.html
@@ -2,7 +2,7 @@
Upgrading to 1.2.x
-Upgrading to 1.1.x from 1.2.x
+Upgrading to 1.2.x from 1.1.x
- If migrating from 1.0.0, see these instructions first.
- If migrating from less than 1.1.4, see these instructions first.
@@ -19,6 +19,7 @@ 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);
+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 = "";