cust_main.paydate should be varchar(10), not @date_type ; problem reported

by Ben Leibig <leibig@colorado.edu>

diff --git a/bin/fs-setup b/bin/fs-setup
index f028c6e..7a5403b 100755 (executable)
--- a/bin/fs-setup
+++ b/bin/fs-setup
@@ -1,6 +1,6 @@
 #!/usr/bin/perl -Tw
 #
 #!/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
 #
 #
 # ivan@sisd.com 97-nov-8,9
 #


@@ -32,7 +32,11 @@
 # fix radius attributes ivan@sisd.com 98-sep-27
 #
 # $Log: fs-setup,v $
 # 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 <leibig@colorado.edu>
+#
+# 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
 # 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,
         '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,
         '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 539fe5d..815652a 100644 (file)
--- 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 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 (
 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 (