From 532db8ddd43eae7f09200ad25fbc542524f2093d Mon Sep 17 00:00:00 2001 From: ivan Date: Sat, 27 Feb 1999 21:06:48 +0000 Subject: [PATCH] cust_main.paydate should be varchar(10), not @date_type ; problem reported by Ben Leibig --- bin/fs-setup | 11 ++++++++--- htdocs/docs/upgrade3.html | 1 + 2 files changed, 9 insertions(+), 3 deletions(-) diff --git a/bin/fs-setup b/bin/fs-setup index f028c6e1d..7a5403b01 100755 --- a/bin/fs-setup +++ b/bin/fs-setup @@ -1,6 +1,6 @@ #!/usr/bin/perl -Tw # -# $Id: fs-setup,v 1.14 1999-02-07 09:59:14 ivan Exp $ +# $Id: fs-setup,v 1.15 1999-02-27 21:06:21 ivan Exp $ # # ivan@sisd.com 97-nov-8,9 # @@ -32,7 +32,11 @@ # fix radius attributes ivan@sisd.com 98-sep-27 # # $Log: fs-setup,v $ -# Revision 1.14 1999-02-07 09:59:14 ivan +# Revision 1.15 1999-02-27 21:06:21 ivan +# cust_main.paydate should be varchar(10), not @date_type ; problem reported +# by Ben Leibig +# +# Revision 1.14 1999/02/07 09:59:14 ivan # more mod_perl fixes, and bugfixes Peter Wemm sent via email # # Revision 1.13 1999/02/04 06:09:23 ivan @@ -385,7 +389,8 @@ sub tables_hash_hack { 'fax', 'varchar', 'NULL', 12, 'payby', 'char', '', 4, 'payinfo', 'varchar', 'NULL', 16, - 'paydate', @date_type, + #'paydate', @date_type, + 'paydate', 'varchar', 'NULL', 10, 'payname', 'varchar', 'NULL', $char_d, 'tax', 'char', 'NULL', 1, 'otaker', 'varchar', '', 8, 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 = "";