SET FOREIGN_KEY_CHECKS=0;

DROP TABLE IF EXISTS dbversion;
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 chipRun;
DROP TABLE IF EXISTS chipProcessedImfile;
DROP TABLE IF EXISTS chipImfile;
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 addRun;
DROP TABLE IF EXISTS addProcessedExp;
DROP TABLE IF EXISTS addMask;
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 warpImfile;
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 magicDSRun;
DROP TABLE IF EXISTS magicDSFile;
DROP TABLE IF EXISTS calDB;
DROP TABLE IF EXISTS calRun;
DROP TABLE IF EXISTS flatcorrRun;
DROP TABLE IF EXISTS flatcorrExp;
DROP TABLE IF EXISTS flatcorrChipLink;
DROP TABLE IF EXISTS flatcorrCamLink;
DROP TABLE IF EXISTS flatcorrAddstarLink;
DROP TABLE IF EXISTS pstampDataStore;
DROP TABLE IF EXISTS pstampProject;
DROP TABLE IF EXISTS pstampRequest;
DROP TABLE IF EXISTS pstampJob;
DROP TABLE IF EXISTS distRun;
DROP TABLE IF EXISTS distTarget;
DROP TABLE IF EXISTS distComponent;
DROP TABLE IF EXISTS rcDSProduct;
DROP TABLE IF EXISTS rcDestination;
DROP TABLE IF EXISTS rcInterest;
DROP TABLE IF EXISTS rcDSFileset;
DROP TABLE IF EXISTS rcRun;
DROP TABLE IF EXISTS receiveSource;
DROP TABLE IF EXISTS receiveFileset;
DROP TABLE IF EXISTS receiveFile;
DROP TABLE IF EXISTS receiveResult;
DROP TABLE IF EXISTS publishClient;
DROP TABLE IF EXISTS publishRun;
DROP TABLE IF EXISTS publishDone;
DROP TABLE IF EXISTS pstampDependent;
DROP TABLE IF EXISTS staticskyInput;
DROP TABLE IF EXISTS staticskyResult;
DROP TABLE IF EXISTS staticskyRun;

SET FOREIGN_KEY_CHECKS=1
