diff options
| author | ivan <ivan> | 2002-11-20 09:07:31 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2002-11-20 09:07:31 +0000 |
| commit | 57e6dca948e9d9afffb584645503d6bd2602139c (patch) | |
| tree | 07791a29fc9e408cef31fd4ef5c10942cdf23266 | |
| parent | 51a85d0841e09edf685519153139fcdb4f6d5749 (diff) | |
ugh... need to increase length of payinfo field in cust_pay and cust_refund
for ACH
| -rwxr-xr-x | FS/bin/freeside-setup | 4 | ||||
| -rwxr-xr-x | bin/fs-setup | 6 | ||||
| -rw-r--r-- | httemplate/docs/upgrade9.html | 1 |
3 files changed, 6 insertions, 5 deletions
diff --git a/FS/bin/freeside-setup b/FS/bin/freeside-setup index 9418a3c79..133d248b8 100755 --- a/FS/bin/freeside-setup +++ b/FS/bin/freeside-setup @@ -547,7 +547,7 @@ sub tables_hash_hack { '_date', @date_type, 'payby', 'char', '', 4, # CARD/BILL/COMP, should be index into # payment type table. - 'payinfo', 'varchar', 'NULL', 16, #see cust_main above + 'payinfo', 'varchar', 'NULL', $char_d, #see cust_main above 'paybatch', 'varchar', 'NULL', $char_d, #for auditing purposes. 'closed', 'char', 'NULL', 1, ], @@ -624,7 +624,7 @@ sub tables_hash_hack { 'reason', 'varchar', '', $char_d, 'payby', 'char', '', 4, # CARD/BILL/COMP, should be index # into payment type table. - 'payinfo', 'varchar', 'NULL', 16, #see cust_main above + 'payinfo', 'varchar', 'NULL', $char_d, #see cust_main above 'paybatch', 'varchar', 'NULL', $char_d, 'closed', 'char', 'NULL', 1, ], diff --git a/bin/fs-setup b/bin/fs-setup index 946b95003..7cfaafa4b 100755 --- a/bin/fs-setup +++ b/bin/fs-setup @@ -1,6 +1,6 @@ #!/usr/bin/perl -Tw # -# $Id: fs-setup,v 1.96.4.2 2002-11-19 20:36:46 ivan Exp $ +# $Id: fs-setup,v 1.96.4.3 2002-11-20 09:07:30 ivan Exp $ #to delay loading dbdef until we're ready BEGIN { $FS::Record::setup_hack = 1; } @@ -545,7 +545,7 @@ sub tables_hash_hack { '_date', @date_type, 'payby', 'char', '', 4, # CARD/BILL/COMP, should be index into # payment type table. - 'payinfo', 'varchar', 'NULL', 16, #see cust_main above + 'payinfo', 'varchar', 'NULL', $char_d, #see cust_main above 'paybatch', 'varchar', 'NULL', $char_d, #for auditing purposes. 'closed', 'char', 'NULL', 1, ], @@ -622,7 +622,7 @@ sub tables_hash_hack { 'reason', 'varchar', '', $char_d, 'payby', 'char', '', 4, # CARD/BILL/COMP, should be index # into payment type table. - 'payinfo', 'varchar', 'NULL', 16, #see cust_main above + 'payinfo', 'varchar', 'NULL', $char_d, #see cust_main above 'paybatch', 'varchar', 'NULL', $char_d, 'closed', 'char', 'NULL', 1, ], diff --git a/httemplate/docs/upgrade9.html b/httemplate/docs/upgrade9.html index bcd3f4d5a..da5b643fb 100644 --- a/httemplate/docs/upgrade9.html +++ b/httemplate/docs/upgrade9.html @@ -15,5 +15,6 @@ INSERT INTO msgcat ( msgnum, msgcode, locale, msg ) VALUES ( 18, 'daytime', 'en_US', 'Day Phone' ); INSERT INTO msgcat ( msgnum, msgcode, locale, msg ) VALUES ( 19, 'night', 'en_US', 'Night Phone' ); </pre> + <li>If you want to use ACH (electronic checks), you will need to make changes to your database. The easiest way to make these changes is to dump your database (with pg_dump), change the payinfo field in the cust_pay, cust_refund, h_cust_pay and h_cust_refund tables from varchar(16) to varchar(80), reload the database from the dump, and run dbdef-create <li>Restart Apache and freeside-queued. </body> |