X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=sql%2Fcivicrm_dummy_processor.mysql;h=fed3c452bcf044b355f8c52040fc1181749f41bc;hb=17ea15063fd080480c9e8e9ee542009e99110e14;hp=30e2b1ef0bd7a2ac7cecf93e968c49c290216ce7;hpb=bcef009a812a47000001a506f7c37be87665e7b8;p=civicrm-core.git

diff --git a/sql/civicrm_dummy_processor.mysql b/sql/civicrm_dummy_processor.mysql
index 30e2b1ef0b..fed3c452bc 100644
--- a/sql/civicrm_dummy_processor.mysql
+++ b/sql/civicrm_dummy_processor.mysql
@@ -1,5 +1,7 @@
-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', '', 7, 1, 1, 0, 'dummy', NULL, NULL, 'http://dummy.com', NULL, 'http://dummyrecur.com', NULL, NULL, 'Payment_Dummy', 1, 1, 1);
-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', '', 7, 1, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Payment_Dummy', 1, 1, 1);
+SELECT @pptype := id FROM civicrm_payment_processor_type WHERE name='Dummy';
+
+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);
+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);
 
 SELECT @dp            := max(id) from civicrm_payment_processor where name = 'Test Processor' AND is_test = 0;
 SELECT @dpTest        := max(id) from civicrm_payment_processor where name = 'Test Processor' AND is_test = 1;
@@ -10,3 +12,5 @@ INSERT INTO `civicrm_entity_financial_account` (`entity_table`, `entity_id`, `ac
 UPDATE  `civicrm_contribution_page` SET payment_processor = @dp;
 
 UPDATE  `civicrm_event` SET payment_processor = @dp;
+
+UPDATE `civicrm_financial_trxn` SET payment_processor_id = @dp WHERE trxn_id IS NOT NULL;