External Pre-auths need ccpay_card_pan_trunc and ccpay_card_type to remove need for...

diff --git a/foundation-database/manifest.js b/foundation-database/manifest.js
index 8d5351b..82d6e51 100644 (file)
--- a/foundation-database/manifest.js
+++ b/foundation-database/manifest.js
@@ -1012,6 +1012,7 @@
 
     "public/tables/bankrecitem.sql",
     "public/tables/cashrcpt.sql",
+    "public/tables/ccpay.sql",
     "public/tables/metric.sql",
     "public/tables/payco.sql",
     "public/tables/priv.sql",

diff --git a/foundation-database/public/tables/ccpay.sql b/foundation-database/public/tables/ccpay.sql
new file mode 100644 (file)
index 0000000..9336fa3
--- /dev/null
+++ b/foundation-database/public/tables/ccpay.sql
@@ -0,0 +1,5 @@
+-- Add columns for data needed for external pre-auths that will have no ccpay_ccard_id.
+select xt.add_column('ccpay','ccpay_card_pan_trunc', 'text', null, 'public', 'External Pre-Auth truncated PAN. Last four digits of the card.');
+-- TODO: PayPal
+--select xt.add_column('ccpay','ccpay_card_type', 'text', null, 'public', 'External Pre-Auth card type: V=Visa, M=MasterCard, A=American Express, D=Discover, P=Paypal.');
+select xt.add_column('ccpay','ccpay_card_type', 'text', null, 'public', 'External Pre-Auth card type: V=Visa, M=MasterCard, A=American Express, D=Discover.');