<?xml version="1.0" encoding="ISO-8859-1"?>

<!--L
  Copyright Washington University at St. Louis

  Distributed under the OSI-approved BSD 3-Clause License.
  See http://ncip.github.com/geneconnect/LICENSE.txt for details.
L-->

<SQLSCRIPT>
        <!--SYSTEM TABLES -->
        <DATASOURCE>
		<NAME>TERMDATA</NAME>
				<CONSTRAINT_QUERY>ALTER TABLE SYSTEM_TERMTREE DROP FOREIGN KEY  FK_SYSTEM_TERMTREE</CONSTRAINT_QUERY>
				<CONSTRAINT_QUERY>ALTER TABLE SYSTEM_TERMTREE_U DROP PRIMARY KEY</CONSTRAINT_QUERY>
				<CONSTRAINT_QUERY>ALTER TABLE SYSTEM_TERMDATA_U DROP PRIMARY KEY</CONSTRAINT_QUERY>
        </DATASOURCE>
        <DATASOURCE>
		<NAME>ENTREZGENE</NAME>
                <CONSTRAINT_QUERY>ALTER TABLE ENTREZ_UNIGENE DROP FOREIGN KEY FK_ENTREZ_UNIGENE</CONSTRAINT_QUERY>
                <CONSTRAINT_QUERY>ALTER TABLE ENTREZ_MAP DROP FOREIGN KEY   FK_ENTREZ_MAP</CONSTRAINT_QUERY>
                <CONSTRAINT_QUERY>ALTER TABLE ENTREZ_STS DROP FOREIGN KEY   FK_ENTREZ_STS</CONSTRAINT_QUERY>
                <CONSTRAINT_QUERY>ALTER TABLE ENTREZ_GOID DROP FOREIGN KEY   FK_ENTREZ_GOID</CONSTRAINT_QUERY>
                <CONSTRAINT_QUERY>ALTER TABLE ENTREZ_OMIM DROP FOREIGN KEY   FK_ENTREZ_OMIM</CONSTRAINT_QUERY>
                <CONSTRAINT_QUERY>ALTER TABLE ENTREZ_PMIDS DROP FOREIGN KEY   FK_ENTREZ_PMIDS</CONSTRAINT_QUERY>
                <CONSTRAINT_QUERY>ALTER TABLE ENTREZ_GENENAMES DROP FOREIGN KEY   FK_ENTREZ_GENENAMES</CONSTRAINT_QUERY>
                <CONSTRAINT_QUERY>ALTER TABLE ENTREZ_FLY DROP FOREIGN KEY   FK_ENTREZ_FLY</CONSTRAINT_QUERY>
                <CONSTRAINT_QUERY>ALTER TABLE ENTREZ_PHENOTYPE DROP FOREIGN KEY   FK_ENTREZ_PHENOTYPE</CONSTRAINT_QUERY>
        </DATASOURCE>
        <DATASOURCE>
		<NAME>UNIGENE</NAME>
                <CONSTRAINT_QUERY>ALTER TABLE UG_EXPRESS DROP FOREIGN KEY   FK_UG_EXPRESS</CONSTRAINT_QUERY>
                <CONSTRAINT_QUERY>ALTER TABLE UG_SEQUENCE DROP FOREIGN KEY   FK_UG_SEQUENCE</CONSTRAINT_QUERY>
                <CONSTRAINT_QUERY>ALTER TABLE UG_PROTSIM DROP FOREIGN KEY   FK_UG_PROTSIM</CONSTRAINT_QUERY>
        </DATASOURCE>
        <DATASOURCE>
		 <NAME>UNISTS</NAME>
                <CONSTRAINT_QUERY>ALTER TABLE UNISTS_ACCESSION DROP FOREIGN KEY   FK_UNISTS_ACCESSION</CONSTRAINT_QUERY>
        </DATASOURCE>
        <DATASOURCE>
		 <NAME>SERVER_STATUS</NAME>
                <CONSTRAINT_QUERY>ALTER TABLE SERVER_FILE_STATUS DROP FOREIGN KEY   FK_SERVER_FILE_STATUS</CONSTRAINT_QUERY>
        </DATASOURCE>
        <DATASOURCE>
		 <NAME>DBSNP</NAME>
                                <CONSTRAINT_QUERY>ALTER TABLE CONTIG_INFO DROP FOREIGN KEY  FK_CONTIG_INFO</CONSTRAINT_QUERY>
		                <CONSTRAINT_QUERY>ALTER TABLE CONTIG_MAPLOC DROP FOREIGN KEY  FK_CONTIG_MAPLOC_SNPID</CONSTRAINT_QUERY>
		                <CONSTRAINT_QUERY>ALTER TABLE ENTREZ_SNP DROP FOREIGN KEY  FK_ENTREZ_SNP</CONSTRAINT_QUERY>
		                <CONSTRAINT_QUERY>ALTER TABLE FXNSET_CONTIGMAP DROP FOREIGN KEY  FK_FXNSET_CONTIGMAP_SNPID</CONSTRAINT_QUERY>
        </DATASOURCE>
</SQLSCRIPT>
