SET FOREIGN_KEY_CHECKS=0;
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 fakeMask;
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 flatcorrChipLink;
DROP TABLE IF EXISTS flatcorrCamLink;
DROP TABLE IF EXISTS pstampDataStore;
DROP TABLE IF EXISTS pstampProject;
DROP TABLE IF EXISTS pstampRequest;
DROP TABLE IF EXISTS pstampJob;
SET FOREIGN_KEY_CHECKS=1
