X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=htdocs%2Fdocs%2Fupgrade3.html;fp=htdocs%2Fdocs%2Fupgrade3.html;h=815652aaf16bef81d7b5cfa127ab2a0fdb9d116e;hb=532db8ddd43eae7f09200ad25fbc542524f2093d;hp=539fe5d821a3cc084a302f1343c6d2fcea7b7e03;hpb=510d2f9647c0651a82760e456b46505e8050d6ed;p=freeside.git diff --git a/htdocs/docs/upgrade3.html b/htdocs/docs/upgrade3.html index 539fe5d82..815652aaf 100644 --- a/htdocs/docs/upgrade3.html +++ b/htdocs/docs/upgrade3.html @@ -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 = "";