diff options
author | Mark Wells <mark@freeside.biz> | 2016-07-14 23:32:19 -0700 |
---|---|---|
committer | Mark Wells <mark@freeside.biz> | 2016-07-15 16:59:18 -0700 |
commit | 666c35e4745dc6b5518f53267aadb3233f7cddb8 (patch) | |
tree | 87a75619f0467ee522f21ec891710e0a6094874e /FS/FS/Schema.pm | |
parent | 2b71735a07f9d122660da05f8d24d2af0ddd1f03 (diff) |
store credit card type in cust_payby and transaction records, #71291, schema support
Diffstat (limited to 'FS/FS/Schema.pm')
-rw-r--r-- | FS/FS/Schema.pm | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index 748df8b..60593ad 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -2459,6 +2459,7 @@ sub tables_hashref { 'usernum', 'int', 'NULL', '', '', '', 'payby', 'char', '', 4, '', '', 'payinfo', 'varchar', 'NULL', 512, '', '', + 'cardtype', 'varchar', 'NULL', $char_d, '', '', 'paymask', 'varchar', 'NULL', $char_d, '', '', 'paydate', 'varchar', 'NULL', 10, '', '', 'paybatch', 'varchar', 'NULL', $char_d, '', '',#for auditing purposes @@ -2516,7 +2517,8 @@ sub tables_hashref { 'usernum', 'int', 'NULL', '', '', '', 'payby', 'char', '', 4, '', '', 'payinfo', 'varchar', 'NULL', 512, '', '', - 'paymask', 'varchar', 'NULL', $char_d, '', '', + 'cardtype', 'varchar', 'NULL', $char_d, '', '', + 'paymask', 'varchar', 'NULL', $char_d, '', '', #'paydate' ? 'paybatch', 'varchar', 'NULL', $char_d, '', '', #for auditing purposes. 'closed', 'char', 'NULL', 1, '', '', @@ -3076,7 +3078,8 @@ sub tables_hashref { # be index into payby # table eventually 'payinfo', 'varchar', 'NULL', 512, '', '', #see cust_main above - 'paymask', 'varchar', 'NULL', $char_d, '', '', + 'cardtype', 'varchar', 'NULL', $char_d, '', '', + 'paymask', 'varchar', 'NULL', $char_d, '', '', 'paybatch', 'varchar', 'NULL', $char_d, '', '', 'closed', 'char', 'NULL', 1, '', '', 'source_paynum', 'int', 'NULL', '', '', '', # link to cust_payby, to prevent unapply of gateway-generated refunds |