/cdmlib-services/src/test/resources/dbscripts/001_cdm.ddl - Diff - EDIT - EDIT Project Management

« Previous | Next »

Revision 85ae680a

Added by Andreas Müller over 12 years ago

ID 85ae680a85fd5faa49f719be69a2aae69a9ddb24
Parent a188d161
Child 35672674

synchronize dlls and dtds for tests

         create table Address (
     	create table Address (
             id integer not null,
             created timestamp,
             uuid varchar(36),
-...
             titleCache varchar(255),
             createdby_id integer,
             updatedby_id integer,
             code varchar(255),
             name varchar(255),
             ispartof_id integer,
             nomenclaturaltitle varchar(255),
             firstname varchar(255),
             lastname varchar(255),
-...
             prefix varchar(255),
             suffix varchar(255),
             protectednomenclaturaltitlecache bit,
             code varchar(255),
             name varchar(255),
             ispartof_id integer,
             primary key (id, REV)
         );
-...
             primary key (CDM_VIEW_id, superviews_id),
             unique (superviews_id)
         );
         create table Classification (
             id integer not null,
             created timestamp,
             uuid varchar(36),
             updated timestamp,
             lsid_authority varchar(255),
             lsid_lsid varchar(255),
             lsid_namespace varchar(255),
             lsid_object varchar(255),
             lsid_revision varchar(255),
             protectedtitlecache bit not null,
             titleCache varchar(255),
             microreference varchar(255),
             createdby_id integer,
             updatedby_id integer,
             name_id integer,
             reference_id integer,
             primary key (id),
             unique (uuid)
         );
         create table Classification_AUD (
             id integer not null,
             REV integer not null,
             revtype tinyint,
             created timestamp,
             uuid varchar(36),
             updated timestamp,
             lsid_authority varchar(255),
             lsid_lsid varchar(255),
             lsid_namespace varchar(255),
             lsid_object varchar(255),
             lsid_revision varchar(255),
             protectedtitlecache bit,
             titleCache varchar(255),
             microreference varchar(255),
             createdby_id integer,
             updatedby_id integer,
             name_id integer,
             reference_id integer,
             primary key (id, REV)
         );
         create table Classification_Annotation (
             Classification_id integer not null,
             annotations_id integer not null,
             primary key (Classification_id, annotations_id),
             unique (annotations_id)
         );
         create table Classification_Annotation_AUD (
             REV integer not null,
             Classification_id integer not null,
             annotations_id integer not null,
             revtype tinyint,
             primary key (REV, Classification_id, annotations_id)
         );
         create table Classification_Credit (
             Classification_id integer not null,
             credits_id integer not null,
             sortIndex integer not null,
             primary key (Classification_id, sortIndex),
             unique (credits_id)
         );
         create table Classification_Credit_AUD (
             REV integer not null,
             Classification_id integer not null,
             credits_id integer not null,
             sortIndex integer not null,
             revtype tinyint,
             primary key (REV, Classification_id, credits_id, sortIndex)
         );
         create table Classification_Extension (
             Classification_id integer not null,
             extensions_id integer not null,
             primary key (Classification_id, extensions_id),
             unique (extensions_id)
         );
         create table Classification_Extension_AUD (
             REV integer not null,
             Classification_id integer not null,
             extensions_id integer not null,
             revtype tinyint,
             primary key (REV, Classification_id, extensions_id)
         );
         create table Classification_Marker (
             Classification_id integer not null,
             markers_id integer not null,
             primary key (Classification_id, markers_id),
             unique (markers_id)
         );
         create table Classification_Marker_AUD (
             REV integer not null,
             Classification_id integer not null,
             markers_id integer not null,
             revtype tinyint,
             primary key (REV, Classification_id, markers_id)
         );
         create table Classification_OriginalSourceBase (
             Classification_id integer not null,
             sources_id integer not null,
             primary key (Classification_id, sources_id),
             unique (sources_id)
         );
         create table Classification_OriginalSourceBase_AUD (
             REV integer not null,
             Classification_id integer not null,
             sources_id integer not null,
             revtype tinyint,
             primary key (REV, Classification_id, sources_id)
         );
         create table Classification_Rights (
             Classification_id integer not null,
             rights_id integer not null,
             primary key (Classification_id, rights_id),
             unique (rights_id)
         );
         create table Classification_Rights_AUD (
             REV integer not null,
             Classification_id integer not null,
             rights_id integer not null,
             revtype tinyint,
             primary key (REV, Classification_id, rights_id)
         );
         create table Classification_TaxonNode (
             Classification_id integer not null,
             rootnodes_id integer not null,
             primary key (Classification_id, rootnodes_id),
             unique (rootnodes_id)
         );
         create table Classification_TaxonNode_AUD (
             REV integer not null,
             Classification_id integer not null,
             rootnodes_id integer not null,
             revtype tinyint,
             primary key (REV, Classification_id, rootnodes_id)
         );
         create table Collection (
             id integer not null,
-...
             kindof_id integer,
             partof_id integer,
             vocabulary_id integer,
             istechnical bit,
             orderindex integer,
             iso639_1 varchar(2),
             iso639_2 varchar(3),
             orderindex integer,
             istechnical bit,
             symmetrical bit,
             transitive bit,
             pointapproximation_errorradius integer,
             pointapproximation_latitude double,
             pointapproximation_longitude double,
-...
             pointapproximation_referencesystem_id integer,
             shape_id integer,
             type_id integer,
             symmetrical bit,
             transitive bit,
             defaultcolor varchar(255),
             iso3166_a2 varchar(2),
             defaultcolor varchar(255),
             supportscategoricaldata bit,
             supportscommontaxonname bit,
             supportsdistribution bit,
-...
             createdby_id integer,
             updatedby_id integer,
             taxon_id integer,
             taxonName_id integer,
             taxonname_id integer,
             primary key (id),
             unique (uuid)
         );
-...
             createdby_id integer,
             updatedby_id integer,
             taxon_id integer,
             taxonName_id integer,
             taxonname_id integer,
             primary key (id, REV)
         );
-...
             updatedby_id integer,
             feature_id integer,
             indescription_id integer,
             format_id integer,
             unit_id integer,
             associatedspecimenorobservation_id integer,
             orderrelevant bit,
             taxon2_id integer,
             associatedspecimenorobservation_id integer,
             name varchar(255),
             language_id integer,
             taxon2_id integer,
             area_id integer,
             status_id integer,
             unit_id integer,
             format_id integer,
             primary key (id, REV)
         );
-...
             updated timestamp,
             createdby_id integer,
             updatedby_id integer,
             featureTree_id integer not null,
            	featureTree_id integer not null,
             feature_id integer,
             parent_id integer,
             primary key (id, REV)
-...
         );
         create table FeatureTree_AUD (
             DTYPE varchar(31) not null,
             id integer not null,
             REV integer not null,
             revtype tinyint,
-...
             primary key (REV, FeatureTree_id, rights_id)
         );
         create table FeatureTree_TaxonBase (
             FeatureTree_id integer not null,
             coveredtaxa_id integer not null,
             primary key (FeatureTree_id, coveredtaxa_id)
         );
         create table FeatureTree_TaxonBase_AUD (
             REV integer not null,
             FeatureTree_id integer not null,
             coveredtaxa_id integer not null,
             revtype tinyint,
             primary key (REV, FeatureTree_id, coveredtaxa_id)
         );
         create table GatheringEvent (
             id integer not null,
             created timestamp,
-...
             primary key (id),
             unique (uuid, authority)
         );
     	create table hibernate_sequences (
     		sequence_name varchar(255),
     		next_val integer,
-...
             person_id integer,
             primary key (id, REV)
         );
         create table KeyStatement (
             id integer not null,
             created timestamp,
             uuid varchar(36),
             updated timestamp,
             createdby_id integer,
             updatedby_id integer,
             primary key (id),
             unique (uuid)
         );
         create table KeyStatement (
             id integer not null,
             created timestamp,
             uuid varchar(36),
             updated timestamp,
             createdby_id integer,
             updatedby_id integer,
             primary key (id),
             unique (uuid)
         );
         create table KeyStatement_AUD (
             id integer not null,
             REV integer not null,
             revtype tinyint,
             created timestamp,
             uuid varchar(36),
             updated timestamp,
             createdby_id integer,
             updatedby_id integer,
             primary key (id, REV)
           );
          create table KeyStatement_LanguageString (
             keyStatement_id integer not null,
             label_id integer not null,
             label_mapkey_id integer not null,
             primary key (keyStatement_id, label_mapkey_id),
             unique (label_id)
         );
         create table KeyStatement_LanguageString_AUD (
             REV integer not null,
             keyStatement_id integer not null,
             label_id integer not null,
             label_mapkey_id integer not null,
             revtype tinyint,
             primary key (REV, keyStatement_id, label_id, label_mapkey_id)
         );
         create table KeyStatement_AUD (
             id integer not null,
             REV integer not null,
             revtype tinyint,
             created timestamp,
             uuid varchar(36),
             updated timestamp,
             createdby_id integer,
             updatedby_id integer,
             primary key (id, REV)
           );
          create table KeyStatement_LanguageString (
             keyStatement_id integer not null,
             label_id integer not null,
             label_mapkey_id integer not null,
             primary key (keyStatement_id, label_mapkey_id),
             unique (label_id)
         );
         create table KeyStatement_LanguageString_AUD (
             REV integer not null,
             keyStatement_id integer not null,
             label_id integer not null,
             label_mapkey_id integer not null,
             revtype tinyint,
             primary key (REV, keyStatement_id, label_id, label_mapkey_id)
         );
         create table LSIDAuthority (
             id integer not null,
-...
             primary key (REV, Media_id, coveredtaxa_id)
         );
         create table MultiAccessKey_NamedArea (
             WorkingSet_id integer not null,
             geographicalscope_id integer not null,
             primary key (WorkingSet_id, geographicalscope_id)
         );
         create table MultiAccessKey_NamedArea_AUD (
             REV integer not null,
             WorkingSet_id integer not null,
             geographicalscope_id integer not null,
             revtype tinyint,
             primary key (REV, WorkingSet_id, geographicalscope_id)
         );
         create table MultiAccessKey_Scope (
             WorkingSet_id integer not null,
             scoperestrictions_id integer not null,
             primary key (WorkingSet_id, scoperestrictions_id)
         );
         create table MultiAccessKey_Scope_AUD (
             REV integer not null,
             WorkingSet_id integer not null,
             scoperestrictions_id integer not null,
             revtype tinyint,
             primary key (REV, WorkingSet_id, scoperestrictions_id)
         );
         create table MultiAccessKey_Taxon (
             multiAccessKey_id integer not null,
             taxon_id integer not null,
             primary key (multiAccessKey_id, taxon_id)
         );
         create table MultiAccessKey_Taxon_AUD (
             REV integer not null,
             multiAccessKey_id integer not null,
             taxon_id integer not null,
             revtype tinyint,
             primary key (REV, multiAccessKey_id, taxon_id)
         );
         create table NameRelationship (
             id integer not null,
             created timestamp,
-...
             grantedauthorities_id integer not null,
             primary key (PermissionGroup_id, grantedauthorities_id)
         );
        create table PolytomousKey (
            	id integer not null,
             created timestamp,
             uuid varchar(36),
             updated timestamp,
             lsid_authority varchar(255),
             lsid_lsid varchar(255),
             lsid_namespace varchar(255),
             lsid_object varchar(255),
             lsid_revision varchar(255),
             protectedtitlecache bit not null,
             titleCache varchar(255),
             uri varchar(255),
             createdby_id integer,
             updatedby_id integer,
             root_id integer,
             primary key (id),
             unique (uuid)
         );
        create table PolytomousKey_AUD (
            	id integer not null,
             REV integer not null,
             revtype tinyint,
             created timestamp,
             uuid varchar(36),
             updated timestamp,
             lsid_authority varchar(255),
             lsid_lsid varchar(255),
             lsid_namespace varchar(255),
             lsid_object varchar(255),
             lsid_revision varchar(255),
             protectedtitlecache bit not null,
             titleCache varchar(255),
             uri varchar(255),
             createdby_id integer,
             updatedby_id integer,
             root_id integer,
             primary key (id, REV)
         );
         create table PolytomousKey_Annotation (
             PolytomousKey_id integer not null,
             annotations_id integer not null,
             primary key (PolytomousKey_id, annotations_id),
             unique (annotations_id)
         );
         create table PolytomousKey_Annotation_AUD (
             REV integer not null,
             PolytomousKey_id integer not null,
             annotations_id integer not null,
             revtype tinyint,
             primary key (REV, PolytomousKey_id, annotations_id)
         );
         create table PolytomousKey_Credit (
             PolytomousKey_id integer not null,
             credits_id integer not null,
             sortIndex integer not null,
             primary key (PolytomousKey_id, sortIndex),
             unique (credits_id)
         );
         create table PolytomousKey_Credit_AUD (
             REV integer not null,
             PolytomousKey_id integer not null,
             credits_id integer not null,
             sortIndex integer not null,
             revtype tinyint,
             primary key (REV, PolytomousKey_id, credits_id, sortIndex)
         );
         create table PolytomousKey_Extension (
             PolytomousKey_id integer not null,
             extensions_id integer not null,
             primary key (PolytomousKey_id, extensions_id),
             unique (extensions_id)
         );
         create table PolytomousKey_Extension_AUD (
             REV integer not null,
             PolytomousKey_id integer not null,
             extensions_id integer not null,
             revtype tinyint,
             primary key (REV, PolytomousKey_id, extensions_id)
         );
         create table PolytomousKey_Marker (
             PolytomousKey_id integer not null,
             markers_id integer not null,
             primary key (PolytomousKey_id, markers_id),
             unique (markers_id)
         );
         create table PolytomousKey_Marker_AUD (
             REV integer not null,
             PolytomousKey_id integer not null,
             markers_id integer not null,
             revtype tinyint,
             primary key (REV, PolytomousKey_id, markers_id)
         );
         create table PolytomousKey_NamedArea (
             PolytomousKey_id integer not null,
             geographicalscope_id integer not null,
             primary key (PolytomousKey_id, geographicalscope_id)
         );
         create table PolytomousKey_NamedArea_AUD (
             REV integer not null,
             PolytomousKey_id integer not null,
             geographicalscope_id integer not null,
             revtype tinyint,
             primary key (REV, PolytomousKey_id, geographicalscope_id)
         );
         create table PolytomousKey_OriginalSourceBase (
             PolytomousKey_id integer not null,
             sources_id integer not null,
             primary key (PolytomousKey_id, sources_id),
             unique (sources_id)
         );
         create table PolytomousKey_OriginalSourceBase_AUD (
             REV integer not null,
             PolytomousKey_id integer not null,
             sources_id integer not null,
             revtype tinyint,
             primary key (REV, PolytomousKey_id, sources_id)
         );
         create table PolytomousKey_Rights (
             PolytomousKey_id integer not null,
             rights_id integer not null,
             primary key (PolytomousKey_id, rights_id),
             unique (rights_id)
         );
         create table PolytomousKey_Rights_AUD (
             REV integer not null,
             PolytomousKey_id integer not null,
             rights_id integer not null,
             revtype tinyint,
             primary key (REV, PolytomousKey_id, rights_id)
         );
         create table PolytomousKey_Scope (
             PolytomousKey_id integer not null,
             scoperestrictions_id integer not null,
             primary key (PolytomousKey_id, scoperestrictions_id)
         );
         create table PolytomousKey_Scope_AUD (
             REV integer not null,
             PolytomousKey_id integer not null,
             scoperestrictions_id integer not null,
             revtype tinyint,
             primary key (REV, PolytomousKey_id, scoperestrictions_id)
         );
         create table PolytomousKey_Taxon (
             polytomousKey_id integer not null,
             taxon_id integer not null,
             primary key (polytomousKey_id, taxon_id)
         );
         create table PolytomousKey_Taxon_AUD (
             REV integer not null,
             polytomousKey_id integer not null,
             taxon_id integer not null,
             revtype tinyint,
             primary key (REV, polytomousKey_id, taxon_id)
         );
         create table PolytomousKeyNode (
             id integer not null,
             created timestamp,
             uuid varchar(36),
             updated timestamp,
             nodenumber integer,
     	sortindex integer,
             createdby_id integer,
             updatedby_id integer,
             key_id integer,
             parent_id integer,
             question_id integer,
             statement_id integer,
             feature_id integer,
             taxon_id integer,
             subkey_id integer,
             othernode_id integer,
             primary key (id),
             unique (uuid)
         );
         create table PolytomousKeyNode_AUD (
             id integer not null,
             REV integer not null,
             revtype tinyint,
             created timestamp,
             uuid varchar(36),
             updated timestamp,
             sortindex integer,
             nodenumber integer,
     	createdby_id integer,
             updatedby_id integer,
             key_id integer,
             parent_id integer,
             question_id integer,
             statement_id integer,
             feature_id integer,
             taxon_id integer,
             subkey_id integer,
             othernode_id integer,
             primary key (id, REV)
         );
         create table PolytomousKeyNode_PolytomousKeyNode_AUD(
         	id integer not null,
             REV integer not null,
             revtype tinyint,
             parent_id integer,
             sortIndex integer
+        )
         create table Reference (
             DTYPE varchar(31) not null,
             id integer not null,
        create table PolytomousKey (
            	id integer not null,
             created timestamp,
             uuid varchar(36),
             updated timestamp,
-...
             lsid_revision varchar(255),
             protectedtitlecache bit not null,
             titleCache varchar(255),
             datepublished_end varchar(255),
             datepublished_freetext varchar(255),
             datepublished_start varchar(255),
             edition varchar(255),
             editor varchar(255),
             isbn varchar(255),
             issn varchar(255),
             nomenclaturallyrelevant bit not null,
             organization varchar(255),
             pages varchar(255),
             parsingproblem integer not null,
             placepublished varchar(255),
             problemends integer not null,
             problemstarts integer not null,
             uri varchar(255),
             createdby_id integer,
             updatedby_id integer,
             root_id integer,
             primary key (id),
             unique (uuid)
         );
        create table PolytomousKey_AUD (
            	id integer not null,
             REV integer not null,
             revtype tinyint,
             created timestamp,
             uuid varchar(36),
             updated timestamp,
             lsid_authority varchar(255),
             lsid_lsid varchar(255),
             lsid_namespace varchar(255),
             lsid_object varchar(255),
             lsid_revision varchar(255),
             protectedtitlecache bit not null,
             titleCache varchar(255),
             uri varchar(255),
             createdby_id integer,
             updatedby_id integer,
             root_id integer,
             primary key (id, REV)
         );
         create table PolytomousKey_Annotation (
             PolytomousKey_id integer not null,
             annotations_id integer not null,
             primary key (PolytomousKey_id, annotations_id),
             unique (annotations_id)
         );
         create table PolytomousKey_Annotation_AUD (
             REV integer not null,
             PolytomousKey_id integer not null,
             annotations_id integer not null,
             revtype tinyint,
             primary key (REV, PolytomousKey_id, annotations_id)
         );
         create table PolytomousKey_Credit (
             PolytomousKey_id integer not null,
             credits_id integer not null,
             sortIndex integer not null,
             primary key (PolytomousKey_id, sortIndex),
             unique (credits_id)
         );
         create table PolytomousKey_Credit_AUD (
             REV integer not null,
             PolytomousKey_id integer not null,
             credits_id integer not null,
             sortIndex integer not null,
             revtype tinyint,
             primary key (REV, PolytomousKey_id, credits_id, sortIndex)
         );
         create table PolytomousKey_Extension (
             PolytomousKey_id integer not null,
             extensions_id integer not null,
             primary key (PolytomousKey_id, extensions_id),
             unique (extensions_id)
         );
         create table PolytomousKey_Extension_AUD (
             REV integer not null,
             PolytomousKey_id integer not null,
             extensions_id integer not null,
             revtype tinyint,
             primary key (REV, PolytomousKey_id, extensions_id)
         );
         create table PolytomousKey_Marker (
             PolytomousKey_id integer not null,
             markers_id integer not null,
             primary key (PolytomousKey_id, markers_id),
             unique (markers_id)
         );
         create table PolytomousKey_Marker_AUD (
             REV integer not null,
             PolytomousKey_id integer not null,
             markers_id integer not null,
             revtype tinyint,
             primary key (REV, PolytomousKey_id, markers_id)
         );
         create table PolytomousKey_NamedArea (
             PolytomousKey_id integer not null,
             geographicalscope_id integer not null,
             primary key (PolytomousKey_id, geographicalscope_id)
         );
         create table PolytomousKey_NamedArea_AUD (
             REV integer not null,
             PolytomousKey_id integer not null,
             geographicalscope_id integer not null,
             revtype tinyint,
             primary key (REV, PolytomousKey_id, geographicalscope_id)
         );
         create table PolytomousKey_OriginalSourceBase (
             PolytomousKey_id integer not null,
             sources_id integer not null,
             primary key (PolytomousKey_id, sources_id),
             unique (sources_id)
         );
         create table PolytomousKey_OriginalSourceBase_AUD (
             REV integer not null,
             PolytomousKey_id integer not null,
             sources_id integer not null,
             revtype tinyint,
             primary key (REV, PolytomousKey_id, sources_id)
         );
         create table PolytomousKey_Rights (
             PolytomousKey_id integer not null,
             rights_id integer not null,
             primary key (PolytomousKey_id, rights_id),
             unique (rights_id)
         );
         create table PolytomousKey_Rights_AUD (
             REV integer not null,
             PolytomousKey_id integer not null,
             rights_id integer not null,
             revtype tinyint,
             primary key (REV, PolytomousKey_id, rights_id)
         );
         create table PolytomousKey_Scope (
             PolytomousKey_id integer not null,
             scoperestrictions_id integer not null,
             primary key (PolytomousKey_id, scoperestrictions_id)
         );
         create table PolytomousKey_Scope_AUD (
             REV integer not null,
             PolytomousKey_id integer not null,
             scoperestrictions_id integer not null,
             revtype tinyint,
             primary key (REV, PolytomousKey_id, scoperestrictions_id)
         );
         create table PolytomousKey_Taxon (
             polytomousKey_id integer not null,
             taxon_id integer not null,
             primary key (polytomousKey_id, taxon_id)
         );
         create table PolytomousKey_Taxon_AUD (
             REV integer not null,
             polytomousKey_id integer not null,
             taxon_id integer not null,
             revtype tinyint,
             primary key (REV, polytomousKey_id, taxon_id)
         );
         create table PolytomousKey_TaxonBase (
             polytomousKey_id integer not null,
             coveredtaxa_id integer not null,
             primary key (polytomousKey_id, coveredtaxa_id)
         );
         create table PolytomousKey_TaxonBase_AUD (
             REV integer not null,
             polytomousKey_id integer not null,
             coveredtaxa_id integer not null,
             revtype tinyint,
             primary key (REV, polytomousKey_id, coveredtaxa_id)
         );
         create table PolytomousKeyNode (
             id integer not null,
             created timestamp,
             uuid varchar(36),
             updated timestamp,
             nodenumber integer,
             sortindex integer,
             createdby_id integer,
             updatedby_id integer,
             key_id integer,
             parent_id integer,
             question_id integer,
             statement_id integer,
             feature_id integer,
             taxon_id integer,
             subkey_id integer,
             othernode_id integer,
             primary key (id),
             unique (uuid)
         );
         create table PolytomousKeyNode_AUD (
             id integer not null,
             REV integer not null,
             revtype tinyint,
             created timestamp,
             uuid varchar(36),
             updated timestamp,
             nodenumber integer,
             sortindex integer,
             createdby_id integer,
             updatedby_id integer,
             key_id integer,
             parent_id integer,
             question_id integer,
             statement_id integer,
             feature_id integer,
             taxon_id integer,
             subkey_id integer,
             othernode_id integer,
             primary key (id, REV)
         );
         create table PolytomousKeyNode_PolytomousKeyNode_AUD(
         	id integer not null,
             REV integer not null,
             revtype tinyint,
             parent_id integer,
             sortIndex integer
+        )
         create table Reference (
             DTYPE varchar(31) not null,
             id integer not null,
             created timestamp,
             uuid varchar(36),
             updated timestamp,
             lsid_authority varchar(255),
             lsid_lsid varchar(255),
             lsid_namespace varchar(255),
             lsid_object varchar(255),
             lsid_revision varchar(255),
             protectedtitlecache bit not null,
             titleCache varchar(255),
             datepublished_end varchar(255),
             datepublished_freetext varchar(255),
             datepublished_start varchar(255),
             edition varchar(255),
             editor varchar(255),
             isbn varchar(255),
             issn varchar(255),
             nomenclaturallyrelevant bit not null,
             organization varchar(255),
             pages varchar(255),
             parsingproblem integer not null,
             placepublished varchar(255),
             problemends integer not null,
             problemstarts integer not null,
             publisher varchar(255),
             referenceAbstract longvarchar,
             series varchar(255),
-...
             inreference_id integer,
             institution_id integer,
             school_id integer,
            	abbreviatedReference_id integer,
             abbreviatedReference_id integer,
             fullReference_id integer,
     		primary key (id),
             primary key (id),
             unique (uuid)
         );
-...
             accessionnumber varchar(255),
             catalognumber varchar(255),
             collectorsnumber varchar(255),
             barcode varchar(255),
             fieldnotes varchar(255),
             fieldnumber varchar(255),
             barcode varchar(255),
             createdby_id integer,
             updatedby_id integer,
             lifestage_id integer,
             sex_id integer,
             sex_id integer,
             exsiccatum varchar(255),
         	primarycollector_id integer,
             collection_id integer,
             exsiccatum varchar(255),
         	primarycollector_id integer,
             derivedfrom_id integer,
             storedunder_id integer,
             preservation_id integer,
-...
             primary key (id),
             unique (uuid)
         );
         create table SpecimenOrObservationBase_AUD (
             DTYPE varchar(31) not null,
-...
             updatedby_id integer,
             lifestage_id integer,
             sex_id integer,
             fieldnotes varchar(255),
             fieldnumber varchar(255),
             barcode varchar(255),
             exsiccatum varchar(255),
             gatheringevent_id integer,
             accessionnumber varchar(255),
             catalognumber varchar(255),
             collectorsnumber varchar(255),
             exsiccatum varchar(255),
         	primarycollector_id integer,
             primarycollector_id integer,
             collection_id integer,
             derivedfrom_id integer,
             storedunder_id integer,
             preservation_id integer,
             fieldnotes varchar(255),
             fieldnumber varchar(255),
             barcode varchar(255),
             gatheringevent_id integer,
             primary key (id, REV)
         );
-...
             revtype tinyint,
             primary key (REV, SpecimenOrObservationBase_id, definition_id, definition_mapkey_id)
         );
         create table SpecimenOrObservationBase_Marker (
             SpecimenOrObservationBase_id integer not null,
             markers_id integer not null,
-...
             homotypicalgroup_id integer,
             nomenclaturalreference_id integer,
             rank_id integer,
             acronym varchar(255),
             authorshipcache varchar(255),
             binomhybrid bit,
             genusoruninomial varchar(255),
-...
             combinationauthorteam_id integer,
             exbasionymauthorteam_id integer,
             excombinationauthorteam_id integer,
             nameapprobation varchar(255),
             subgenusauthorship varchar(255),
             anamorphic bit,
             breed varchar(255),
             originalpublicationyear integer,
             publicationyear integer,
             acronym varchar(255),
             anamorphic bit,
             cultivarname varchar(255),
             nameapprobation varchar(255),
             subgenusauthorship varchar(255),
             primary key (id, REV)
         );
-...
             TaxonNode_id integer not null,
             markers_id integer not null,
             revtype tinyint,
             primary key (REV, TaxonNode_id, markers_id)
         );
         create table TaxonRelationship (
             id integer not null,
             created timestamp,
             uuid varchar(36),
             updated timestamp,
             citationmicroreference varchar(255),
             originalnamestring varchar(255),
             doubtful bit not null,
             createdby_id integer,
             updatedby_id integer,
             citation_id integer,
             relatedfrom_id integer,
             relatedto_id integer,
             type_id integer,
             primary key (id),
             unique (uuid)
         );
         create table TaxonRelationship_AUD (
             id integer not null,
             REV integer not null,
             revtype tinyint,
             created timestamp,
             uuid varchar(36),
             updated timestamp,
             citationmicroreference varchar(255),
             originalnamestring varchar(255),
             doubtful bit,
             createdby_id integer,
             updatedby_id integer,
             citation_id integer,
             relatedfrom_id integer,
             relatedto_id integer,
             type_id integer,
             primary key (id, REV)
         );
         create table TaxonRelationship_Annotation (
             TaxonRelationship_id integer not null,
             annotations_id integer not null,
             primary key (TaxonRelationship_id, annotations_id),
             unique (annotations_id)
         );
         create table TaxonRelationship_Annotation_AUD (
             REV integer not null,
             TaxonRelationship_id integer not null,
             annotations_id integer not null,
             revtype tinyint,
             primary key (REV, TaxonRelationship_id, annotations_id)
         );
         create table TaxonRelationship_Marker (
             TaxonRelationship_id integer not null,
             markers_id integer not null,
             primary key (TaxonRelationship_id, markers_id),
             unique (markers_id)
         );
         create table TaxonRelationship_Marker_AUD (
             REV integer not null,
             TaxonRelationship_id integer not null,
             markers_id integer not null,
             revtype tinyint,
             primary key (REV, TaxonRelationship_id, markers_id)
         );
         create table Classification (
             id integer not null,
             created timestamp,
             uuid varchar(36),
             updated timestamp,
             lsid_authority varchar(255),
             lsid_lsid varchar(255),
             lsid_namespace varchar(255),
             lsid_object varchar(255),
             lsid_revision varchar(255),
             protectedtitlecache bit not null,
             titleCache varchar(255),
             microreference varchar(255),
             createdby_id integer,
             updatedby_id integer,
             name_id integer,
             reference_id integer,
             primary key (id),
             unique (uuid)
         );
         create table Classification_AUD (
             id integer not null,
             REV integer not null,
             revtype tinyint,
             created timestamp,
             uuid varchar(36),
             updated timestamp,
             lsid_authority varchar(255),
             lsid_lsid varchar(255),
             lsid_namespace varchar(255),
             lsid_object varchar(255),
             lsid_revision varchar(255),
             protectedtitlecache bit,
             titleCache varchar(255),
             microreference varchar(255),
             createdby_id integer,
             updatedby_id integer,
             name_id integer,
             reference_id integer,
             primary key (id, REV)
         );
         create table Classification_Annotation (
             Classification_id integer not null,
             annotations_id integer not null,
             primary key (Classification_id, annotations_id),
             unique (annotations_id)
         );
         create table Classification_Annotation_AUD (
             REV integer not null,
             Classification_id integer not null,
             annotations_id integer not null,
             revtype tinyint,
             primary key (REV, Classification_id, annotations_id)
         );
         create table Classification_Credit (
             Classification_id integer not null,
             credits_id integer not null,
             sortIndex integer not null,
             primary key (Classification_id, sortIndex),
             unique (credits_id)
         );
         create table Classification_Credit_AUD (
             REV integer not null,
             Classification_id integer not null,
             credits_id integer not null,
             sortIndex integer not null,
             revtype tinyint,
             primary key (REV, Classification_id, credits_id, sortIndex)
         );
         create table Classification_Extension (
             Classification_id integer not null,
             extensions_id integer not null,
             primary key (Classification_id, extensions_id),
             unique (extensions_id)
         );
         create table Classification_Extension_AUD (
             REV integer not null,
             Classification_id integer not null,
             extensions_id integer not null,
             revtype tinyint,
             primary key (REV, Classification_id, extensions_id)
         );
         create table Classification_Marker (
             Classification_id integer not null,
             markers_id integer not null,
             primary key (Classification_id, markers_id),
             unique (markers_id)
         );
         create table Classification_Marker_AUD (
             REV integer not null,
             Classification_id integer not null,
             markers_id integer not null,
             revtype tinyint,
             primary key (REV, Classification_id, markers_id)
             primary key (REV, TaxonNode_id, markers_id)
         );
         create table Classification_OriginalSourceBase (
             Classification_id integer not null,
             sources_id integer not null,
             primary key (Classification_id, sources_id),
             unique (sources_id)
         create table TaxonRelationship (
             id integer not null,
             created timestamp,
             uuid varchar(36),
             updated timestamp,
             citationmicroreference varchar(255),
             originalnamestring varchar(255),
             doubtful bit not null,
             createdby_id integer,
             updatedby_id integer,
             citation_id integer,
             relatedfrom_id integer,
             relatedto_id integer,
             type_id integer,
             primary key (id),
             unique (uuid)
         );
         create table Classification_OriginalSourceBase_AUD (
         create table TaxonRelationship_AUD (
             id integer not null,
             REV integer not null,
             Classification_id integer not null,
             sources_id integer not null,
             revtype tinyint,
             primary key (REV, Classification_id, sources_id)
             created timestamp,
             uuid varchar(36),
             updated timestamp,
             citationmicroreference varchar(255),
             originalnamestring varchar(255),
             doubtful bit,
             createdby_id integer,
             updatedby_id integer,
             citation_id integer,
             relatedfrom_id integer,
             relatedto_id integer,
             type_id integer,
             primary key (id, REV)
         );
         create table Classification_Rights (
             Classification_id integer not null,
             rights_id integer not null,
             primary key (Classification_id, rights_id),
             unique (rights_id)
         create table TaxonRelationship_Annotation (
             TaxonRelationship_id integer not null,
             annotations_id integer not null,
             primary key (TaxonRelationship_id, annotations_id),
             unique (annotations_id)
         );
         create table Classification_Rights_AUD (
         create table TaxonRelationship_Annotation_AUD (
             REV integer not null,
             Classification_id integer not null,
             rights_id integer not null,
             TaxonRelationship_id integer not null,
             annotations_id integer not null,
             revtype tinyint,
             primary key (REV, Classification_id, rights_id)
             primary key (REV, TaxonRelationship_id, annotations_id)
         );
         create table Classification_TaxonNode (
             Classification_id integer not null,
             rootnodes_id integer not null,
             primary key (Classification_id, rootnodes_id),
             unique (rootnodes_id)
         create table TaxonRelationship_Marker (
             TaxonRelationship_id integer not null,
             markers_id integer not null,
             primary key (TaxonRelationship_id, markers_id),
             unique (markers_id)
         );
         create table Classification_TaxonNode_AUD (
         create table TaxonRelationship_Marker_AUD (
             REV integer not null,
             Classification_id integer not null,
             rootnodes_id integer not null,
             TaxonRelationship_id integer not null,
             markers_id integer not null,
             revtype tinyint,
             primary key (REV, Classification_id, rootnodes_id)
             primary key (REV, TaxonRelationship_id, markers_id)
         );
         create table TermVocabulary (
-...
             primary key (members_id, groups_id)
         );
         create table WorkingSet (
             DTYPE varchar(31) not null,
             id integer not null,
             created timestamp,
             uuid varchar(36),
             updated timestamp,
             createdby_id integer,
             updatedby_id integer,
             descriptivesystem_id integer,
             primary key (id),
             unique (uuid)
         );
         create table WorkingSet_AUD (
             DTYPE varchar(31) not null,
             id integer not null,
             REV integer not null,
             revtype tinyint,
             created timestamp,
             uuid varchar(36),
             updated timestamp,
             createdby_id integer,
             updatedby_id integer,
             descriptivesystem_id integer,
             primary key (id, REV)
         );
         create table WorkingSet_Annotation (
             WorkingSet_id integer not null,
             annotations_id integer not null,
             primary key (WorkingSet_id, annotations_id),
             unique (annotations_id)
         );
         create table WorkingSet_Annotation_AUD (
             REV integer not null,
             WorkingSet_id integer not null,
             annotations_id integer not null,
             revtype tinyint,
             primary key (REV, WorkingSet_id, annotations_id)
         );
         create table WorkingSet_DescriptionBase (
             WorkingSet_id integer not null,
             descriptions_id integer not null,
             primary key (WorkingSet_id, descriptions_id)
         );
         create table WorkingSet_DescriptionBase_AUD (
             REV integer not null,
             WorkingSet_id integer not null,
             descriptions_id integer not null,
             revtype tinyint,
             primary key (REV, WorkingSet_id, descriptions_id)
         );
         create table WorkingSet_Marker (
             WorkingSet_id integer not null,
             markers_id integer not null,
             primary key (WorkingSet_id, markers_id),
             unique (markers_id)
         );
         create table WorkingSet_Marker_AUD (
             REV integer not null,
             WorkingSet_id integer not null,
             markers_id integer not null,
             revtype tinyint,
             primary key (REV, WorkingSet_id, markers_id)
         );
         create table WorkingSet_Representation (
             WorkingSet_id integer not null,
             representations_id integer not null,
             primary key (WorkingSet_id, representations_id),
             unique (representations_id)
         );
         create table WorkingSet_Representation_AUD (
             REV integer not null,
             WorkingSet_id integer not null,
             representations_id integer not null,
             revtype tinyint,
             primary key (REV, WorkingSet_id, representations_id)
         );
         create table WorkingSet_TaxonBase (
             WorkingSet_id integer not null,
             coveredtaxa_id integer not null,
             primary key (WorkingSet_id, coveredtaxa_id)
         );
         create table WorkingSet_TaxonBase_AUD (
             REV integer not null,
             WorkingSet_id integer not null,
             coveredtaxa_id integer not null,
             revtype tinyint,
             primary key (REV, WorkingSet_id, coveredtaxa_id)
         );
         alter table Address
             add constraint FK1ED033D44FF2DB2C
             foreign key (createdby_id)
-...
         alter table DescriptionBase
             add constraint FKFF4D58CDDA93512F
             foreign key (taxonName_id)
             foreign key (taxonname_id)
             references TaxonNameBase;
         alter table DescriptionBase
-...
             add constraint FK4CEED9F8E0AD2C03
             foreign key (parent_id)
             references FeatureNode;
         alter table FeatureNode
             add constraint FK4CEED9F8DE9A3E39
             foreign key (featureTree_id)
         alter table FeatureNode
             add constraint FK4CEED9F8DE9A3E39
             foreign key (featureTree_id)
             references FeatureTree;
         alter table FeatureNode
-...
             foreign key (REV)
             references AuditEvent;
         alter table FeatureTree_TaxonBase
             add constraint FKEC78E5B0ED57882F
             foreign key (FeatureTree_id)
             references FeatureTree;
         alter table FeatureTree_TaxonBase
             add constraint FKEC78E5B07C3D0017
             foreign key (coveredtaxa_id)
             references TaxonBase;
         alter table FeatureTree_TaxonBase_AUD
             add constraint FK955ABB8134869AAE
             foreign key (REV)
             references AuditEvent;
         alter table GatheringEvent
             add constraint FK6F1286F38B455EC6
             foreign key (locality_id)
-...
             foreign key (REV)
             references AuditEvent;
         alter table MultiAccessKey_NamedArea
             add constraint FK1F5A74893FF8E7B2
             foreign key (geographicalscope_id)

... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff

Project

General

Profile

EDIT

Revision 85ae680a

Added by Andreas Müller over 12 years ago