From 9eb0b6b2d2c0e8a00071529767862aa21df3902c Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Tue, 25 Oct 2016 17:28:36 -0400 Subject: [PATCH] SQL demo server insert protection: payflow org settings Signed-off-by: Bill Erickson --- .../payflow-hosted-static-silent-post-url.sql | 27 ++++++++++++++-------- 1 file changed, 17 insertions(+), 10 deletions(-) diff --git a/KCLS/sql/schema/deploy/payflow-hosted-static-silent-post-url.sql b/KCLS/sql/schema/deploy/payflow-hosted-static-silent-post-url.sql index 92519038e8..75de9a46db 100644 --- a/KCLS/sql/schema/deploy/payflow-hosted-static-silent-post-url.sql +++ b/KCLS/sql/schema/deploy/payflow-hosted-static-silent-post-url.sql @@ -3,15 +3,22 @@ BEGIN; -INSERT INTO config.org_unit_setting_type - (name, label, description, datatype, view_perm, update_perm, grp) -VALUES - ( - 'credit.processor.payflowhosted.skip_silent_post_url', - 'PayflowHosted: Avoid dynamic Silent POST URL', - 'Let PP use the Silent Post URL configured in the PayPal Manager ' || - 'instead of sending our a dynamic (Apache host-based) URL', - 'bool', 1005, 1006, 'credit' - ); +DO $$ +BEGIN + IF evergreen.insert_on_deploy() THEN + + INSERT INTO config.org_unit_setting_type + (name, label, description, datatype, view_perm, update_perm, grp) + VALUES + ( + 'credit.processor.payflowhosted.skip_silent_post_url', + 'PayflowHosted: Avoid dynamic Silent POST URL', + 'Let PP use the Silent Post URL configured in the PayPal Manager ' || + 'instead of sending our a dynamic (Apache host-based) URL', + 'bool', 1005, 1006, 'credit' + ); + + END IF; -- insert_on_deploy +END $$; COMMIT; -- 2.11.0