diff options
| author | ivan <ivan> | 1999-02-27 21:06:48 +0000 |
|---|---|---|
| committer | ivan <ivan> | 1999-02-27 21:06:48 +0000 |
| commit | 532db8ddd43eae7f09200ad25fbc542524f2093d (patch) | |
| tree | 8a33970101f4f8e802638798bd6f155f247c74e4 /htdocs/docs | |
| parent | 510d2f9647c0651a82760e456b46505e8050d6ed (diff) | |
cust_main.paydate should be varchar(10), not @date_type ; problem reported
by Ben Leibig <leibig@colorado.edu>
Diffstat (limited to 'htdocs/docs')
| -rw-r--r-- | htdocs/docs/upgrade3.html | 1 |
1 files changed, 1 insertions, 0 deletions
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 = ""; <!--CREATE TABLE part_title ( |