From 532db8ddd43eae7f09200ad25fbc542524f2093d Mon Sep 17 00:00:00 2001 From: ivan Date: Sat, 27 Feb 1999 21:06:48 +0000 Subject: cust_main.paydate should be varchar(10), not @date_type ; problem reported by Ben Leibig --- htdocs/docs/upgrade3.html | 1 + 1 file changed, 1 insertion(+) (limited to 'htdocs/docs') 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 = "";