EDIT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_ANNOTATION_AUD;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_CONTINENT(

    CONTINENTS_ID INTEGER NOT NULL

);

-- 242 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_CONTINENT;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_CONTINENT_AUD(

    REV INTEGER NOT NULL,

    CONTINENTS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_SCOPE_AUD;

    MEDIAKEY_ID INTEGER NOT NULL,

);

    REV INTEGER NOT NULL,

    MEDIAKEY_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

CREATE CACHED TABLE PUBLIC.MEDIAREPRESENTATION(

    ID INTEGER NOT NULL,

    CREATED TIMESTAMP,

ALTER TABLE PUBLIC.TAXONBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_BC2 PRIMARY KEY(TAXONBASE_ID, SOURCES_ID);

ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_33F PRIMARY KEY(REV, GATHERINGEVENT_ID, MARKERS_ID);

ALTER TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_7D7 PRIMARY KEY(TAXONNAMEBASE_ID, STATUS_ID);

ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_BAD PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, SEQUENCES_ID);

ALTER TABLE PUBLIC.DETERMINATIONEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_BB0 PRIMARY KEY(DETERMINATIONEVENT_ID, MARKERS_ID);

ALTER TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_33C PRIMARY KEY(REV, TAXONNAMEBASE_ID, SOURCES_ID);

ALTER TABLE PUBLIC.FEATURETREE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_F9 PRIMARY KEY(FEATURETREE_ID, RIGHTS_ID);

ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_368 PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, SOURCES_ID);

ALTER TABLE PUBLIC.CLASSIFICATION_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_F5 PRIMARY KEY(CLASSIFICATION_ID, RIGHTS_ID);

ALTER TABLE PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_F7 PRIMARY KEY(CLASSIFICATION_ID, SOURCES_ID);

ALTER TABLE PUBLIC.MEDIA_TAXONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_F6 PRIMARY KEY(REV, MEDIA_ID, COVEREDTAXA_ID);

ALTER TABLE PUBLIC.NAMERELATIONSHIP_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_D5 PRIMARY KEY(REV, NAMERELATIONSHIP_ID, MARKERS_ID);

ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_CE5 PRIMARY KEY(ORIGINALSOURCEBASE_ID, MARKERS_ID);

ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_880 PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.AGENTBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_4 PRIMARY KEY(ID);

ALTER TABLE PUBLIC.DESCRIPTIONBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_7E PRIMARY KEY(REV, DESCRIPTIONBASE_ID, SOURCES_ID);

ALTER TABLE PUBLIC.AGENTBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_B PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.DESCRIPTIONBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_9F PRIMARY KEY(REV, DESCRIPTIONBASE_ID, CREDITS_ID, SORTINDEX);

ALTER TABLE PUBLIC.REFERENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_6EF PRIMARY KEY(ID);

ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_9A PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, CREDITS_ID, SORTINDEX);

ALTER TABLE PUBLIC.LOCUS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_80 PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.MULTIACCESSKEY_TAXON_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_9D PRIMARY KEY(REV, MULTIACCESSKEY_ID, TAXON_ID);

ALTER TABLE PUBLIC.TERMVOCABULARY_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_CFF PRIMARY KEY(REV, TERMVOCABULARY_ID, RIGHTS_ID);

ALTER TABLE PUBLIC.REFERENCE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_85 PRIMARY KEY(REV, REFERENCE_ID, EXTENSIONS_ID);

ALTER TABLE PUBLIC.FEATURETREE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK13BD64E847C496CB FOREIGN KEY(FEATURETREE_ID) REFERENCES PUBLIC.FEATURETREE(ID) NOCHECK;

ALTER TABLE PUBLIC.AGENTBASE_ANNOTATION ADD CONSTRAINT PUBLIC.FK44D5F7D886EFC5D4 FOREIGN KEY(AGENTBASE_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.REFERENCE_ANNOTATION ADD CONSTRAINT PUBLIC.FKFC824E31E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;

ALTER TABLE PUBLIC.REPRESENTATION_MARKER_AUD ADD CONSTRAINT PUBLIC.FKD640BBBD34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.NAMERELATIONSHIP_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FKD1D59CDC34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.GATHERINGEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.FK76DDD01BF95F225A FOREIGN KEY(GATHERINGEVENT_ID) REFERENCES PUBLIC.GATHERINGEVENT(ID) NOCHECK;

	<xsd:element name="TYPEDESIGNATIONBASE_ANNOTATION" type="TYPEDESIGNATIONBASE_ANNOTATION__type" />

	<xsd:element name="NAMERELATIONSHIP_ANNOTATION" type="NAMERELATIONSHIP_ANNOTATION__type" />

	<xsd:element name="ADDRESS" type="ADDRESS__type" />

	<xsd:element name="TAXONBASE_AUD" type="TAXONBASE_AUD__type" />

	<xsd:element name="COLLECTION_MARKER_AUD" type="COLLECTION_MARKER_AUD__type" />

	<xsd:element name="POLYTOMOUSKEY_TAXON_AUD" type="POLYTOMOUSKEY_TAXON_AUD__type" />

		<xsd:attribute name="REVTYPE" use="optional" />

		<xsd:attribute name="MODIFIERS_ID" use="optional" />

	</xsd:complexType>

		<xsd:attribute name="REV" use="optional" />

		<xsd:attribute name="COVEREDTAXA_ID" use="optional" />

		<xsd:attribute name="WORKINGSET_ID" use="optional" />

		<xsd:attribute name="CREATEDBY_ID" use="optional" />

		<xsd:attribute name="REGION" use="optional" />

	</xsd:complexType>

		<xsd:attribute name="COVEREDTAXA_ID" use="optional" />

		<xsd:attribute name="WORKINGSET_ID" use="optional" />

	</xsd:complexType>