Commit | Line | Data |
---|---|---|
205c15d4 | 1 | SELECT @pptype := id FROM civicrm_payment_processor_type WHERE name='Dummy'; |
2 | ||
3 | INSERT INTO `civicrm_payment_processor` (`domain_id`, `name`, `description`, `payment_processor_type_id`, `is_active`, `is_default`, `is_test`, `user_name`, `password`, `signature`, `url_site`, `url_api`, `url_recur`, `url_button`, `subject`, `class_name`, `billing_mode`, `is_recur`, `payment_type`) VALUES (1, 'Test Processor', '', @pptype, 1, 1, 0, 'dummy', NULL, NULL, 'http://dummy.com', NULL, 'http://dummyrecur.com', NULL, NULL, 'Payment_Dummy', 1, 1, 1); | |
4 | INSERT INTO `civicrm_payment_processor` (`domain_id`, `name`, `description`, `payment_processor_type_id`, `is_active`, `is_default`, `is_test`, `user_name`, `password`, `signature`, `url_site`, `url_api`, `url_recur`, `url_button`, `subject`, `class_name`, `billing_mode`, `is_recur`, `payment_type`) VALUES (1, 'Test Processor', '', @pptype, 1, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Payment_Dummy', 1, 1, 1); | |
f078ea51 DG |
5 | |
6 | SELECT @dp := max(id) from civicrm_payment_processor where name = 'Test Processor' AND is_test = 0; | |
7 | SELECT @dpTest := max(id) from civicrm_payment_processor where name = 'Test Processor' AND is_test = 1; | |
8 | ||
ce70d293 PJ |
9 | INSERT INTO `civicrm_entity_financial_account` (`entity_table`, `entity_id`, `account_relationship`, `financial_account_id`) VALUES ('civicrm_payment_processor', @dp, 6, 12); |
10 | INSERT INTO `civicrm_entity_financial_account` (`entity_table`, `entity_id`, `account_relationship`, `financial_account_id`) VALUES ('civicrm_payment_processor', @dpTest, 6, 12); | |
f078ea51 | 11 | |
ce70d293 | 12 | UPDATE `civicrm_contribution_page` SET payment_processor = @dp; |
f078ea51 | 13 | |
ce70d293 | 14 | UPDATE `civicrm_event` SET payment_processor = @dp; |
47ca44f4 SL |
15 | |
16 | UPDATE `civicrm_financial_trxn` SET payment_processor_id = @dp WHERE trxn_id IS NOT NULL; |