3 INSERT INTO config.upgrade_log (version) VALUES ('0396'); -- senator
5 INSERT INTO permission.perm_list (code, description) VALUES
6 ('VIEW_CREDIT_CARD_PROCESSING',
7 'View org unit settings related to credit card processing'),
8 ('ADMIN_CREDIT_CARD_PROCESSING',
9 'Update org unit settings related to credit card processing');
11 INSERT INTO config.org_unit_setting_type (
12 name, label, description, datatype
14 ('credit.processor.payflowpro.enabled',
15 'Credit card processing: Enable PayflowPro payments',
16 'This is NOT the same thing as the settings labeled with just "PayPal."',
19 ('credit.processor.payflowpro.login',
20 'Credit card processing: PayflowPro login/merchant ID',
21 'Often the same thing as the PayPal manager login',
24 ('credit.processor.payflowpro.password',
25 'Credit card processing: PayflowPro password',
26 'PayflowPro password',
29 ('credit.processor.payflowpro.testmode',
30 'Credit card processing: PayflowPro test mode',
31 'Do not really process transactions, but stay in test mode - uses pilot-payflowpro.paypal.com instead of the usual host',
34 ('credit.processor.payflowpro.vendor',
35 'Credit card processing: PayflowPro vendor',
36 'Often the same thing as the login',
39 ('credit.processor.payflowpro.partner',
40 'Credit card processing: PayflowPro partner',
41 'Often "PayPal" or "VeriSign", sometimes others',
45 UPDATE config.org_unit_setting_type
46 SET description = 'This can be "AuthorizeNet", "PayPal" (for the Website Payment Pro API), or "PayflowPro".'
47 WHERE name = 'credit.processor.default';
49 UPDATE config.org_unit_setting_type
50 SET view_perm = (SELECT id FROM permission.perm_list
51 WHERE code = 'VIEW_CREDIT_CARD_PROCESSING' LIMIT 1)
52 WHERE name LIKE 'credit.processor%' AND view_perm IS NULL;
54 UPDATE config.org_unit_setting_type
55 SET update_perm = (SELECT id FROM permission.perm_list
56 WHERE code = 'ADMIN_CREDIT_CARD_PROCESSING' LIMIT 1)
57 WHERE name LIKE 'credit.processor%' AND update_perm IS NULL;