X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=bin%2Ftest_scrub_sql;h=30ee1d277d6500c7fd4f3b574a37cf3b406432db;hb=ea749c5e875371d98bdcf173e19a2d57fa46481e;hp=fb26fe940288a00575e17046aa2ff97c00e47d09;hpb=b5c4237a34aef94976bc343c8d9e138664fc3984;p=freeside.git

diff --git a/bin/test_scrub_sql b/bin/test_scrub_sql
index fb26fe940..30ee1d277 100755
--- a/bin/test_scrub_sql
+++ b/bin/test_scrub_sql
@@ -15,17 +15,21 @@
 
 foreach my $table (qw(
   part_export_option
-  payment_gateway
   payment_gateway_option
   agent_payment_gateway
-  queue
   queue_arg
+  queue
   cust_pay_batch
 )) {
   print "DELETE FROM $table;\n";
   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";