From 049b89c4773ae560e0a38e6bd5cd9faf9233f48d Mon Sep 17 00:00:00 2001
From: Mark Wells <mark@freeside.biz>
Date: Thu, 6 Mar 2014 20:40:42 -0800
Subject: [PATCH] respect payment gatewaynum

---
 bin/test_scrub_sql | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

diff --git a/bin/test_scrub_sql b/bin/test_scrub_sql
index fe66805d3..30ee1d277 100755
--- a/bin/test_scrub_sql
+++ b/bin/test_scrub_sql
@@ -16,7 +16,6 @@
 foreach my $table (qw(
   part_export_option
   payment_gateway_option
-  payment_gateway
   agent_payment_gateway
   queue_arg
   queue
@@ -26,6 +25,11 @@ foreach my $table (qw(
   print "DELETE FROM h_$table;\n";
 }
 
+# don't break foreign keys in cust_pay_*, just scrub fields that could be
+# used to access the gateway
+print "UPDATE payment_gateway SET gateway_module = 'Test', disabled = 'Y', gateway_username = NULL, gateway_password = 'NULL';\n";
+print "DELETE FROM h_payment_gateway;\n";
+
 foreach my $table (qw(
   part_export
   export_svc
@@ -38,6 +42,7 @@ print "DELETE FROM cust_main_invoice WHERE dest != 'POST';\n";
 foreach my $item (qw(
   business-onlinepayment
   business-onlinepayment-ach
+  smtpmachine
 )) {
   print "DELETE FROM conf WHERE name = '$item';\n";
   print "DELETE FROM h_conf WHERE name = '$item';\n";
-- 
2.11.0