diff options
| author | ivan <ivan> | 2002-11-20 09:07:27 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2002-11-20 09:07:27 +0000 |
| commit | cfd4d4d5fd2c64f0f0512905a465aeb4abce484c (patch) | |
| tree | 09af349b27da708e0f0c7be5d34acfb98ebae17e | |
| parent | 26da8f3994e58ca5cf80ac62f034b3ad64539e47 (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 | ||||
| -rw-r--r-- | httemplate/docs/upgrade9.html | 1 |
2 files changed, 3 insertions, 2 deletions
diff --git a/FS/bin/freeside-setup b/FS/bin/freeside-setup index 587f0158b..8f3d99fd5 100755 --- a/FS/bin/freeside-setup +++ b/FS/bin/freeside-setup @@ -541,7 +541,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, ], @@ -618,7 +618,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> |