Index: trunk/ippTools/share/pxadmin_drop_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_drop_tables.sql	(revision 17854)
+++ trunk/ippTools/share/pxadmin_drop_tables.sql	(revision 17880)
@@ -1,53 +1,55 @@
 SET FOREIGN_KEY_CHECKS=0;
-DROP TABLE pzDataStore;
-DROP TABLE summitExp;
-DROP TABLE summitImfile;
-DROP TABLE pzDownloadExp;
-DROP TABLE pzDownloadImfile;
-DROP TABLE newExp;
-DROP TABLE newImfile;
-DROP TABLE rawExp;
-DROP TABLE rawImfile;
-DROP TABLE guidePendingExp;
-DROP TABLE chipRun;
-DROP TABLE chipProcessedImfile;
-DROP TABLE chipMask;
-DROP TABLE camRun;
-DROP TABLE camProcessedExp;
-DROP TABLE camMask;
-DROP TABLE detRun;
-DROP TABLE detInputExp;
-DROP TABLE detProcessedImfile;
-DROP TABLE detProcessedExp;
-DROP TABLE detStackedImfile;
-DROP TABLE detNormalizedStatImfile;
-DROP TABLE detNormalizedImfile;
-DROP TABLE detNormalizedExp;
-DROP TABLE detResidImfile;
-DROP TABLE detResidExp;
-DROP TABLE detRunSummary;
-DROP TABLE detRegisteredImfile;
-DROP TABLE warpRun;
-DROP TABLE warpSkyCellMap;
-DROP TABLE warpSkyfile;
-DROP TABLE warpMask;
-DROP TABLE diffRun;
-DROP TABLE diffInputSkyfile;
-DROP TABLE diffSkyfile;
-DROP TABLE stackRun;
-DROP TABLE stackInputSkyfile;
-DROP TABLE stackSumSkyfile;
-DROP TABLE magicRun;
-DROP TABLE magicInputSkyfile;
-DROP TABLE magicTree;
-DROP TABLE magicNodeResult;
-DROP TABLE magicMask;
-DROP TABLE magicSkyfileMask;
-DROP TABLE calDB;
-DROP TABLE calRun;
-DROP TABLE flatcorrRun;
-DROP TABLE flatcorrExp;
-DROP TABLE pstampDataStore;
-DROP TABLE pstampRequest;
-DROP TABLE pstampJob;
+DROP TABLE IF EXISTS pzDataStore;
+DROP TABLE IF EXISTS summitExp;
+DROP TABLE IF EXISTS summitImfile;
+DROP TABLE IF EXISTS pzDownloadExp;
+DROP TABLE IF EXISTS pzDownloadImfile;
+DROP TABLE IF EXISTS newExp;
+DROP TABLE IF EXISTS newImfile;
+DROP TABLE IF EXISTS rawExp;
+DROP TABLE IF EXISTS rawImfile;
+DROP TABLE IF EXISTS guidePendingExp;
+DROP TABLE IF EXISTS chipRun;
+DROP TABLE IF EXISTS chipProcessedImfile;
+DROP TABLE IF EXISTS chipMask;
+DROP TABLE IF EXISTS camRun;
+DROP TABLE IF EXISTS camProcessedExp;
+DROP TABLE IF EXISTS camMask;
+DROP TABLE IF EXISTS detRun;
+DROP TABLE IF EXISTS detInputExp;
+DROP TABLE IF EXISTS fakeRun;
+DROP TABLE IF EXISTS fakeProcessedImfile;
+DROP TABLE IF EXISTS detProcessedImfile;
+DROP TABLE IF EXISTS detProcessedExp;
+DROP TABLE IF EXISTS detStackedImfile;
+DROP TABLE IF EXISTS detNormalizedStatImfile;
+DROP TABLE IF EXISTS detNormalizedImfile;
+DROP TABLE IF EXISTS detNormalizedExp;
+DROP TABLE IF EXISTS detResidImfile;
+DROP TABLE IF EXISTS detResidExp;
+DROP TABLE IF EXISTS detRunSummary;
+DROP TABLE IF EXISTS detRegisteredImfile;
+DROP TABLE IF EXISTS warpRun;
+DROP TABLE IF EXISTS warpSkyCellMap;
+DROP TABLE IF EXISTS warpSkyfile;
+DROP TABLE IF EXISTS warpMask;
+DROP TABLE IF EXISTS diffRun;
+DROP TABLE IF EXISTS diffInputSkyfile;
+DROP TABLE IF EXISTS diffSkyfile;
+DROP TABLE IF EXISTS stackRun;
+DROP TABLE IF EXISTS stackInputSkyfile;
+DROP TABLE IF EXISTS stackSumSkyfile;
+DROP TABLE IF EXISTS magicRun;
+DROP TABLE IF EXISTS magicInputSkyfile;
+DROP TABLE IF EXISTS magicTree;
+DROP TABLE IF EXISTS magicNodeResult;
+DROP TABLE IF EXISTS magicMask;
+DROP TABLE IF EXISTS magicSkyfileMask;
+DROP TABLE IF EXISTS calDB;
+DROP TABLE IF EXISTS calRun;
+DROP TABLE IF EXISTS flatcorrRun;
+DROP TABLE IF EXISTS flatcorrExp;
+DROP TABLE IF EXISTS pstampDataStore;
+DROP TABLE IF EXISTS pstampRequest;
+DROP TABLE IF EXISTS pstampJob;
 SET FOREIGN_KEY_CHECKS=1
