SET FOREIGN_KEY_CHECKS = 0;

drop table Warehouse;
drop table WIDTable;
drop table SpecialWIDTable;
drop table Enumeration;
drop table DataSet;
drop table DataSetHierarchy;
drop table Entry;
drop table GeneExpressionData;
drop table Element;
drop table Valence;
drop table LightSource;
drop table FlowCytometrySample;
drop table FlowCytometryProbe;
drop table TranscriptionUnit;
drop table TranscriptionUnitComponent;
drop table Chemical;
drop table Reaction;
drop table Interaction;
drop table Protein;
drop table Feature;
drop table Function;
drop table EnzymaticReaction;
drop table GeneticCode;
drop table Division;
drop table Taxon;
drop table BioSource;
drop table BioSubtype;
drop table NucleicAcid;
drop table Subsequence;
drop table Gene;
drop table Pathway;
drop table Term;
drop table Computation;
drop table Citation;
drop table Archive;
drop table Experiment;
drop table ExperimentData;
drop table Support;
drop table ChemicalAtom;
drop table ChemicalBond;
drop table EnzReactionCofactor;
drop table EnzReactionAltCompound;
drop table EnzReactionInhibitorActivator;
drop table Location;
drop table PathwayLink;
drop table PathwayReaction;
drop table Product;
drop table Reactant;
drop table InteractionParticipant;
drop table SequenceMatch;
drop table Subunit;
drop table SuperPathway;
drop table TermRelationship;
drop table RelatedTerm;
drop table CitationWIDOtherWID;
drop table CommentTable;
drop table CrossReference;
drop table Description;
drop table DBID;
drop table SynonymTable;
drop table ToolAdvice;
drop table BioSourceWIDBioSubtypeWID;
drop table BioSourceWIDGeneWID;
drop table BioSourceWIDProteinWID;
drop table GeneWIDNucleicAcidWID;
drop table GeneWIDProteinWID;
drop table ProteinWIDFunctionWID;
drop table ExperimentRelationship;
drop table GelLocation;
drop table ProteinWIDSpotWID;
drop table Spot;
drop table SpotIdMethod;
drop table SpotWIDSpotIdMethodWID;
drop table NameValueType;
drop table Contact;
drop table ArrayDesign;
drop table DesignElementGroup;
drop table Zone;
drop table ZoneGroup;
drop table ZoneLayout;
drop table ExperimentDesign;
drop table ExperimentalFactor;
drop table FactorValue;
drop table QuantitationType;
drop table Database_;
drop table Array_;
drop table ArrayGroup;
drop table ArrayManufacture;
drop table ArrayManufactureDeviation;
drop table FeatureDefect;
drop table Fiducial;
drop table ManufactureLIMS;
drop table PositionDelta;
drop table ZoneDefect;
drop table SeqFeatureLocation;
drop table SequencePosition;
drop table DesignElement;
drop table FeatureInformation;
drop table FeatureLocation;
drop table MismatchInformation;
drop table Position_;
drop table BioEvent;
drop table BioAssayData;
drop table BioAssayDimension;
drop table BioAssayMapping;
drop table BioAssayTuple;
drop table BioDataValues;
drop table DataExternal;
drop table DataInternal;
drop table Datum;
drop table DesignElementDimension;
drop table DesignElementMapping;
drop table DesignElementTuple;
drop table QuantitationTypeDimension;
drop table QuantitationTypeMapping;
drop table QuantitationTypeTuple;
drop table BioMaterialMeasurement;
drop table CompoundMeasurement;
drop table BioAssay;
drop table Channel;
drop table Image;
drop table BioAssayDataCluster;
drop table Node;
drop table NodeContents;
drop table NodeValue;
drop table Measurement;
drop table Unit;
drop table Parameter;
drop table ParameterValue;
drop table Parameterizable;
drop table ParameterizableApplication;
drop table ArrayDesignWIDReporterGroupWID;
drop table ArrayDesignWIDCompositeGrpWID;
drop table ArrayDesignWIDContactWID;
drop table ComposGrpWIDComposSequenceWID;
drop table ReporterGroupWIDReporterWID;
drop table ExperimentWIDContactWID;
drop table ExperimWIDBioAssayDataClustWID;
drop table ExperimentWIDBioAssayDataWID;
drop table ExperimentWIDBioAssayWID;
drop table ExperimentDesignWIDBioAssayWID;
drop table QuantTypeWIDConfidenceIndWID;
drop table QuantTypeWIDQuantTypeMapWID;
drop table DatabaseWIDContactWID;
drop table ArrayGroupWIDArrayWID;
drop table ArrayManufactureWIDArrayWID;
drop table ArrayManufactureWIDContactWID;
drop table CompositeSeqWIDBioSeqWID;
drop table ComposSeqWIDRepoComposMapWID;
drop table ComposSeqWIDComposComposMapWID;
drop table FeatureWIDFeatureWID;
drop table FeatureWIDFeatureWID2;
drop table ReporterWIDBioSequenceWID;
drop table ReporterWIDFeatureReporMapWID;
drop table BioAssayDimensioWIDBioAssayWID;
drop table BioAssayMapWIDBioAssayWID;
drop table BAssayMappingWIDBAssayMapWID;
drop table ComposSeqDimensWIDComposSeqWID;
drop table DesnElMappingWIDDesnElMapWID;
drop table FeatureDimensionWIDFeatureWID;
drop table QuantTypeDimensWIDQuantTypeWID;
drop table QuantTypeMapWIDQuantTypeWID;
drop table QuantTyMapWIDQuantTyMapWI;
drop table ReporterDimensWIDReporterWID;
drop table TransformWIDBioAssayDataWID;
drop table BioSourceWIDContactWID;
drop table LabeledExtractWIDCompoundWID;
drop table BioAssayWIDChannelWID;
drop table BioAssayWIDFactorValueWID;
drop table ChannelWIDCompoundWID;
drop table DerivBioAWIDDerivBioADataWID;
drop table DerivBioAssayWIDBioAssayMapWID;
drop table ImageWIDChannelWID;
drop table ImageAcquisitionWIDImageWID;
drop table MeasBAssayWIDMeasBAssayDataWID;
drop table HardwareWIDSoftwareWID;
drop table HardwareWIDContactWID;
drop table ProtocolWIDHardwareWID;
drop table ProtocolWIDSoftwareWID;
drop table ProtocolApplWIDPersonWID;
drop table SoftwareWIDSoftwareWID;
drop table SoftwareWIDContactWID;


SET FOREIGN_KEY_CHECKS = 1;


commit;
