Index: trunk/ippToPsps/test/mkgpc1.sh
===================================================================
--- trunk/ippToPsps/test/mkgpc1.sh	(revision 39015)
+++ trunk/ippToPsps/test/mkgpc1.sh	(revision 39021)
@@ -68,4 +68,39 @@
 endif
 
+if ("$1" == "forcedelete") then
+  if ($#argv < 4) goto usage;
+  set dbhost = $2
+  set dbname = $3
+  set dbuser = $4
+  if ($#argv == 5) then
+    set dbpass = "-p$5"
+  else 
+    set dbpass = "-p"
+  endif
+
+  (mysql -B -h $dbhost -u $dbuser $dbpass -e "show databases" | grep ^$dbname\$) >& /dev/null
+  if ($status) then
+    echo "database $dbname does not yet exist"
+    exit 0
+  endif
+
+  mysql -h $dbhost -u $dbuser $dbpass $dbname -e "describe ippToPspsFake" >& /dev/null
+  if ($status) then
+    echo "database does not contain ippToPspsFake, not deleting"
+    exit 1;
+  endif
+
+  set ntable = `mysql -B -h $dbhost -u $dbuser $dbpass $dbname -e "show tables" | wc -l`
+  echo ntable: $ntable
+  if ($ntable != 28) then
+    echo "warning: expected 28 lines (27 tables), but got $ntable; still deleting"
+  else
+    echo "database is valid, deleting"
+  endif
+
+  mysql -h $dbhost -u $dbuser $dbpass -e "drop database $dbname"
+  exit 0;
+endif
+
 usage:
   echo "USAGE: mkgpc1.sh (options)"