/ - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 537

Added by Aaron Marcuse-Kubitza about 13 years ago

PostgreSQL-MySQL.csv: Use \g<0> instead of \0 in replacements because \0 not supported. Replace fulltext with fulltext__ (note fulltext_ doesn't work).

     -- Existing tables
     CREATE TABLE aux_role
+    (
       role_id int(11) NOT NULL AUTO_INCREMENT,
       rolecode character varying(30) NOT NULL,
       roledescription character varying(200),
       CONSTRAINT aux_role_pkey PRIMARY KEY (role_id )
     );
     CREATE TABLE reference
+    (
       reference_id int(11) NOT NULL AUTO_INCREMENT,
       shortname character varying(250),
       fulltext__ text,
       referencetype character varying(250)
     );
     CREATE TABLE party
+    (
       party_id int(11) NOT NULL AUTO_INCREMENT,
       salutation character varying(20),
       givenname character varying(50),
       middlename character varying(50),
       surname character varying(50),
       organizationname character varying(100)
     );
     CREATE TABLE plantname
+    (
       plantname_id int(11) NOT NULL AUTO_INCREMENT,
       plantname character varying(255) NOT NULL,
       reference_id int(11),
       dateentered timestamp DEFAULT now(),
       CONSTRAINT plantname_pkey PRIMARY KEY (plantname_id ),
       CONSTRAINT plantname_reference_id FOREIGN KEY (reference_id)
           REFERENCES reference (reference_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE
     );
     CREATE TABLE plantconcept
+    (
       plantconcept_id int(11) NOT NULL AUTO_INCREMENT,
       plantname_id int(11) NOT NULL,
       reference_id int(11) NOT NULL,
       plantname character varying(200),
       plantcode character varying(23),
       plantdescription text,
       d_obscount int(11),
       d_currentaccepted int(1),
       accessioncode character varying(255),
       CONSTRAINT plantconcept_pkey PRIMARY KEY (plantconcept_id ),
       CONSTRAINT plantconcept_plantname_id FOREIGN KEY (plantname_id)
           REFERENCES plantname (plantname_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT plantconcept_reference_id FOREIGN KEY (reference_id)
           REFERENCES reference (reference_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE
     );
     CREATE TABLE namedplace
+    (
       namedplace_id int(11) NOT NULL AUTO_INCREMENT,
       placesystem character varying(50),
       placename character varying(100) NOT NULL,
       placedescription text,
       placecode character varying(15),
       owner character varying(100),
       reference_id int(11),
       d_obscount int(11),
       accessioncode character varying(255),
       CONSTRAINT namedplace_pkey PRIMARY KEY (namedplace_id ),
       CONSTRAINT namedplace_reference_id FOREIGN KEY (reference_id)
           REFERENCES reference (reference_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT namedplace_keys UNIQUE (placesystem , placename )
     );
     CREATE TABLE project
+    (
       project_id int(11) NOT NULL AUTO_INCREMENT,
       projectname character varying(150) NOT NULL,
       projectdescription text,
       startdate timestamp,
       stopdate timestamp,
       d_obscount int(11),
       d_lastlocationaddeddate timestamp,
       accessioncode character varying(255),
       CONSTRAINT project_pkey PRIMARY KEY (project_id ),
       CONSTRAINT project_keys UNIQUE (projectname , startdate , stopdate )
     );
     -- New tables
     CREATE TABLE location
+    (
       location_id int(11) NOT NULL AUTO_INCREMENT,
-...
       CONSTRAINT stem_keys UNIQUE (individualplant_id , sourceid )
     );
     CREATE TABLE specimen -- A herbarium specimen. Contains Darwin Core specimen data.
+    (
       specimen_id int(11) NOT NULL AUTO_INCREMENT,
       individualplant_id int(11),
       reference_id int(11) NOT NULL,
       collectioncode_dwc character varying(255),
       catalognumber_dwc character varying(255),
       collectiondate timestamp,
       collector_id int(11),
       museum_id int(11),
       sourceaccessionnumber character varying(100),
       accessioncode character varying(255),
       taxonoccurrence_id int(11),
       CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ),
       CONSTRAINT specimen_collector_id FOREIGN KEY (collector_id)
           REFERENCES party (party_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_individualplant_id_fkey FOREIGN KEY (individualplant_id)
           REFERENCES individualplant (individualplant_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_museum_id FOREIGN KEY (museum_id)
           REFERENCES party (party_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_reference_id_fkey FOREIGN KEY (reference_id)
           REFERENCES reference (reference_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id)
           REFERENCES taxonoccurrence (taxonoccurrence_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_keys UNIQUE (reference_id , collectioncode_dwc , catalognumber_dwc )
     );
     CREATE TABLE taxondetermination -- VegBank's taxoninterpretation table.
+    (
       taxondetermination_id int(11) NOT NULL AUTO_INCREMENT,
-...
       notespublic int(1),
       notesmgt int(1),
       revisions int(1),
       determinationdate timestamp with time zone NOT NULL,
       determinationdate timestamp NOT NULL,
       emb_taxondetermination int(11),
       accessioncode character varying(255),
       CONSTRAINT taxondetermination_pkey PRIMARY KEY (taxondetermination_id ),
-...
           ON UPDATE CASCADE ON DELETE CASCADE
     );
     CREATE TABLE specimen -- A herbarium specimen. Contains Darwin Core specimen data.
     CREATE TABLE sizeclass -- A range of size measurements used to aggregate organisms.
+    (
       specimen_id int(11) NOT NULL AUTO_INCREMENT,
       individualplant_id int(11),
       reference_id int(11) NOT NULL,
       collectioncode_dwc character varying(255),
       catalognumber_dwc character varying(255),
       collectiondate timestamp with time zone,
       collector_id int(11),
       museum_id int(11),
       sourceaccessionnumber character varying(100),
       sizeclass_id int(11) NOT NULL AUTO_INCREMENT,
       mindiameter double precision,
       diameteraccuracy double precision,
       minheight double precision,
       heightaccuracy double precision,
       maxdiameter double precision,
       maxheight double precision,
       accessioncode character varying(255),
       taxonoccurrence_id int(11),
       CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ),
       CONSTRAINT specimen_collector_id FOREIGN KEY (collector_id)
           REFERENCES party (party_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_individualplant_id_fkey FOREIGN KEY (individualplant_id)
           REFERENCES individualplant (individualplant_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_museum_id FOREIGN KEY (museum_id)
           REFERENCES party (party_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_reference_id_fkey FOREIGN KEY (reference_id)
           REFERENCES reference (reference_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id)
           REFERENCES taxonoccurrence (taxonoccurrence_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_keys UNIQUE (reference_id , collectioncode_dwc , catalognumber_dwc )
       CONSTRAINT sizeclass_pkey PRIMARY KEY (sizeclass_id )
     );
     CREATE TABLE taxonbin -- Defines a set of aggregate measurements. Used by aggregateoccurrence to define how measurements were aggregated.
-...
           REFERENCES sizeclass (sizeclass_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE
     );
     CREATE TABLE sizeclass -- A range of size measurements used to aggregate organisms.
+    (
       sizeclass_id int(11) NOT NULL AUTO_INCREMENT,
       mindiameter double precision,
       diameteraccuracy double precision,
       minheight double precision,
       heightaccuracy double precision,
       maxdiameter double precision,
       maxheight double precision,
       accessioncode character varying(255),
       CONSTRAINT sizeclass_pkey PRIMARY KEY (sizeclass_id )
     );

         postalcode character varying(10),
         country character varying(50),
         currentflag int(1),
         addressstartdate timestamp with time zone
         addressstartdate timestamp
     );
-...
         commcode character varying(200),
         commframework character varying(200),
         commlevel character varying(200),
         classstartdate timestamp with time zone,
         classstopdate timestamp with time zone,
         classstartdate timestamp,
         classstopdate timestamp,
         emb_commclass int(11),
         expertsystem text,
         accessioncode character varying(255)
-...
         commstatus_id int(11) NOT NULL,
         commconcept_id int(11) NOT NULL,
         commconvergence character varying(20) NOT NULL,
         correlationstart timestamp with time zone NOT NULL,
         correlationstop timestamp with time zone
         correlationstart timestamp NOT NULL,
         correlationstop timestamp
     );
-...
         commname_id int(11) NOT NULL,
         commname text NOT NULL,
         reference_id int(11),
         dateentered timestamp with time zone DEFAULT now()
         dateentered timestamp DEFAULT now()
     );
-...
         commlevel character varying(80),
         commpartycomments text,
         party_id int(11) NOT NULL,
         startdate timestamp with time zone NOT NULL,
         stopdate timestamp with time zone,
         startdate timestamp NOT NULL,
         stopdate timestamp,
         accessioncode character varying(255)
     );
-...
         classsystem character varying(50),
         party_id int(11),
         commstatus_id int(11),
         usagestart timestamp with time zone,
         usagestop timestamp with time zone
         usagestart timestamp,
         usagestop timestamp
     );
-...
     CREATE TABLE dba_datamodelversion (
         dba_datamodelversion_id int(11) NOT NULL,
         versiontext character varying(20) NOT NULL,
         versionimplemented timestamp with time zone DEFAULT now()
         versionimplemented timestamp DEFAULT now()
     );
-...
     CREATE TABLE dba_dbstatstime (
         stat_id int(11) NOT NULL,
         statdate timestamp with time zone,
         statdate timestamp,
         statpkg int(11),
         statname text,
         stattable character varying(100),
-...
         location_id int(11) NOT NULL,
         embargoreason text NOT NULL,
         defaultstatus int(11) NOT NULL,
         embargostart timestamp with time zone NOT NULL,
         embargostop timestamp with time zone NOT NULL
         embargostart timestamp NOT NULL,
         embargostop timestamp NOT NULL
     );
-...
         graphicdescription text,
         graphictype character varying(20),
         graphicdata oid,
         graphicdate timestamp with time zone,
         graphicdate timestamp,
         accessioncode character varying(255)
     );
-...
         notespublic int(1),
         notesmgt int(1),
         revisions int(1),
         dateentered timestamp with time zone DEFAULT now(),
         dateentered timestamp DEFAULT now(),
         emb_location int(11),
         locationrationalenarrative text,
         accessioncode character varying(255),
-...
         notespublic int(1),
         notesmgt int(1),
         revisions int(1),
         obsstartdate timestamp with time zone,
         obsenddate timestamp with time zone,
         dateentered timestamp with time zone DEFAULT now(),
         obsstartdate timestamp,
         obsenddate timestamp,
         dateentered timestamp DEFAULT now(),
         emb_locationevent int(11),
         interp_orig_ci_id int(11),
         interp_orig_cc_id int(11),
-...
         locationevent_id int(11) NOT NULL,
         party_id int(11) NOT NULL,
         role_id int(11) NOT NULL,
         contributiondate timestamp with time zone
         contributiondate timestamp
     );
-...
         party_id int(11) NOT NULL,
         role_id int(11) NOT NULL,
         synonymcomment text,
         classstartdate timestamp with time zone DEFAULT now() NOT NULL,
         classstopdate timestamp with time zone,
         classstartdate timestamp DEFAULT now() NOT NULL,
         classstopdate timestamp,
         accessioncode character varying(255)
     );
-...
         role_id int(11) NOT NULL,
         notetype character varying(20) NOT NULL,
         notetext text NOT NULL,
         notedate timestamp with time zone,
         notedate timestamp,
         accessioncode character varying(255)
     );
-...
         parentparty_id int(11) NOT NULL,
         childparty_id int(11) NOT NULL,
         role_id int(11),
         memberstart timestamp with time zone DEFAULT now() NOT NULL,
         memberstop timestamp with time zone
         memberstart timestamp DEFAULT now() NOT NULL,
         memberstop timestamp
     );
-...
         plantstatus_id int(11) NOT NULL,
         plantconcept_id int(11) NOT NULL,
         plantconvergence character varying(20) NOT NULL,
         correlationstart timestamp with time zone NOT NULL,
         correlationstop timestamp with time zone
         correlationstart timestamp NOT NULL,
         correlationstop timestamp
     );
-...
         plantname_id int(11) NOT NULL,
         plantname character varying(255) NOT NULL,
         reference_id int(11),
         dateentered timestamp with time zone DEFAULT now()
         dateentered timestamp DEFAULT now()
     );
-...
         plantparent_id int(11),
         plantlevel character varying(80),
         party_id int(11) NOT NULL,
         startdate timestamp with time zone NOT NULL,
         stopdate timestamp with time zone,
         startdate timestamp NOT NULL,
         stopdate timestamp,
         accessioncode character varying(255)
     );
-...
         acceptedsynonym character varying(220),
         party_id int(11),
         plantstatus_id int(11),
         usagestart timestamp with time zone,
         usagestop timestamp with time zone
         usagestart timestamp,
         usagestop timestamp
     );
-...
         project_id int(11) NOT NULL,
         projectname character varying(150) NOT NULL,
         projectdescription text,
         startdate timestamp with time zone,
         stopdate timestamp with time zone,
         startdate timestamp,
         stopdate timestamp,
         d_obscount int(11),
         d_lastlocationaddeddate timestamp with time zone,
         d_lastlocationaddeddate timestamp,
         accessioncode character varying(255)
     );
-...
     CREATE TABLE reference (
         reference_id int(11) NOT NULL,
         shortname character varying(250),
         fulltext text,
         fulltext__ text,
         referencetype character varying(250),
         title character varying(250),
         titlesuperior character varying(250),
-...
         url text,
         doi text,
         additionalinfo text,
         pubdate timestamp with time zone,
         accessdate timestamp with time zone,
         conferencedate timestamp with time zone,
         pubdate timestamp,
         accessdate timestamp,
         conferencedate timestamp,
         accessioncode character varying(255)
     );
-...
         previousvaluetext text NOT NULL,
         previousvaluetype character varying(20) NOT NULL,
         previousrevision_id int(11),
         revisiondate timestamp with time zone NOT NULL
         revisiondate timestamp NOT NULL
     );
-...
         reference_id int(11) NOT NULL,
         collectioncode_dwc character varying(255),
         catalognumber_dwc character varying(255),
         collectiondate timestamp with time zone,
         collectiondate timestamp,
         collector_id int(11),
         museum_id int(11),
         sourceaccessionnumber character varying(100),
-...
         notespublic int(1),
         notesmgt int(1),
         revisions int(1),
         determinationdate timestamp with time zone NOT NULL,
         determinationdate timestamp NOT NULL,
         emb_taxondetermination int(11),
         accessioncode character varying(255)
     );
-...
         datasettype character varying(50),
         datasetsharing character varying(30),
         datasetpassword character varying(50),
         datasetstop timestamp with time zone,
         datasetstart timestamp with time zone DEFAULT now(),
         datasetstop timestamp,
         datasetstart timestamp DEFAULT now(),
         accessioncode character varying(255)
     );
-...
         itemaccessioncode character varying(100) NOT NULL,
         itemtype character varying(50),
         notes text,
         itemstart timestamp with time zone DEFAULT now() NOT NULL,
         itemstop timestamp with time zone,
         itemstart timestamp DEFAULT now() NOT NULL,
         itemstop timestamp,
         externalaccessioncode character varying(100),
         itemdatabase character varying(50) NOT NULL,
         itemtable character varying(50) NOT NULL,
-...
         notifyname character varying(100),
         notifydescription text,
         notifysql text,
         notifystart timestamp with time zone DEFAULT now(),
         notifystop timestamp with time zone,
         lastcheckdate timestamp with time zone
         notifystart timestamp DEFAULT now(),
         notifystop timestamp,
         lastcheckdate timestamp
     );
-...
         usr_id int(11) NOT NULL,
         permissionstatus int(11) NOT NULL,
         permissionnotes text,
         permissionstop timestamp with time zone,
         permissionstart timestamp with time zone DEFAULT now() NOT NULL
         permissionstop timestamp,
         permissionstart timestamp DEFAULT now() NOT NULL
     );
-...
         preferencename character varying(100),
         preferencevalue text,
         preferencepriority double precision,
         preferencestop timestamp with time zone,
         preferencestart timestamp with time zone DEFAULT now()
         preferencestop timestamp,
         preferencestart timestamp DEFAULT now()
     );
-...
         querytype character varying(50),
         querysharing character varying(30),
         querypassword character varying(50),
         querystop timestamp with time zone,
         querystart timestamp with time zone DEFAULT now(),
         querystop timestamp,
         querystart timestamp DEFAULT now(),
         accessioncode character varying(255)
     );
-...
         tablename character varying(50) NOT NULL,
         tablerecord int(11) NOT NULL,
         ownertype character varying(30) NOT NULL,
         recordcreationdate timestamp with time zone NOT NULL,
         ownerstop timestamp with time zone,
         ownerstart timestamp with time zone DEFAULT now() NOT NULL
         recordcreationdate timestamp NOT NULL,
         ownerstop timestamp,
         ownerstart timestamp DEFAULT now() NOT NULL
     );
-...
         email_address character varying(100) NOT NULL,
         preferred_name character varying(100),
         remote_address character varying(100),
         last_connect timestamp with time zone,
         begin_time timestamp with time zone,
         last_connect timestamp,
         begin_time timestamp,
         password character varying(512)
     );

     -- Existing tables
     CREATE TABLE aux_role
+    (
       role_id serial NOT NULL,
       rolecode character varying(30) NOT NULL,
       roledescription character varying(200),
       CONSTRAINT aux_role_pkey PRIMARY KEY (role_id )
     );
     CREATE TABLE reference
+    (
       reference_id serial NOT NULL,
       shortname character varying(250),
       fulltext text,
       referencetype character varying(250)
     );
     CREATE TABLE party
+    (
       party_id serial NOT NULL,
       salutation character varying(20),
       givenname character varying(50),
       middlename character varying(50),
       surname character varying(50),
       organizationname character varying(100)
     );
     CREATE TABLE plantname
+    (
       plantname_id serial NOT NULL,
       plantname character varying(255) NOT NULL,
       reference_id integer,
       dateentered timestamp with time zone DEFAULT now(),
       CONSTRAINT plantname_pkey PRIMARY KEY (plantname_id ),
       CONSTRAINT plantname_reference_id FOREIGN KEY (reference_id)
           REFERENCES reference (reference_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE
     );
     CREATE TABLE plantconcept
+    (
       plantconcept_id serial NOT NULL,
       plantname_id integer NOT NULL,
       reference_id integer NOT NULL,
       plantname character varying(200),
       plantcode character varying(23),
       plantdescription text,
       d_obscount integer,
       d_currentaccepted boolean,
       accessioncode character varying(255),
       CONSTRAINT plantconcept_pkey PRIMARY KEY (plantconcept_id ),
       CONSTRAINT plantconcept_plantname_id FOREIGN KEY (plantname_id)
           REFERENCES plantname (plantname_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT plantconcept_reference_id FOREIGN KEY (reference_id)
           REFERENCES reference (reference_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE
     );
     CREATE TABLE namedplace
+    (
       namedplace_id serial NOT NULL,
       placesystem character varying(50),
       placename character varying(100) NOT NULL,
       placedescription text,
       placecode character varying(15),
       owner character varying(100),
       reference_id integer,
       d_obscount integer,
       accessioncode character varying(255),
       CONSTRAINT namedplace_pkey PRIMARY KEY (namedplace_id ),
       CONSTRAINT namedplace_reference_id FOREIGN KEY (reference_id)
           REFERENCES reference (reference_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT namedplace_keys UNIQUE (placesystem , placename )
     );
     CREATE TABLE project
+    (
       project_id serial NOT NULL,
       projectname character varying(150) NOT NULL,
       projectdescription text,
       startdate timestamp with time zone,
       stopdate timestamp with time zone,
       d_obscount integer,
       d_lastlocationaddeddate timestamp with time zone,
       accessioncode character varying(255),
       CONSTRAINT project_pkey PRIMARY KEY (project_id ),
       CONSTRAINT project_keys UNIQUE (projectname , startdate , stopdate )
     );
     -- New tables
     CREATE TABLE location
+    (
       location_id serial NOT NULL,
-...
       CONSTRAINT stem_keys UNIQUE (individualplant_id , sourceid )
     );
     CREATE TABLE specimen -- A herbarium specimen. Contains Darwin Core specimen data.
+    (
       specimen_id serial NOT NULL,
       individualplant_id integer,
       reference_id integer NOT NULL,
       collectioncode_dwc character varying(255),
       catalognumber_dwc character varying(255),
       collectiondate timestamp with time zone,
       collector_id integer,
       museum_id integer,
       sourceaccessionnumber character varying(100),
       accessioncode character varying(255),
       taxonoccurrence_id integer,
       CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ),
       CONSTRAINT specimen_collector_id FOREIGN KEY (collector_id)
           REFERENCES party (party_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_individualplant_id_fkey FOREIGN KEY (individualplant_id)
           REFERENCES individualplant (individualplant_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_museum_id FOREIGN KEY (museum_id)
           REFERENCES party (party_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_reference_id_fkey FOREIGN KEY (reference_id)
           REFERENCES reference (reference_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id)
           REFERENCES taxonoccurrence (taxonoccurrence_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_keys UNIQUE (reference_id , collectioncode_dwc , catalognumber_dwc )
     );
     CREATE TABLE taxondetermination -- VegBank's taxoninterpretation table.
+    (
       taxondetermination_id serial NOT NULL,
-...
           ON UPDATE CASCADE ON DELETE CASCADE
     );
     CREATE TABLE specimen -- A herbarium specimen. Contains Darwin Core specimen data.
     CREATE TABLE sizeclass -- A range of size measurements used to aggregate organisms.
+    (
       specimen_id serial NOT NULL,
       individualplant_id integer,
       reference_id integer NOT NULL,
       collectioncode_dwc character varying(255),
       catalognumber_dwc character varying(255),
       collectiondate timestamp with time zone,
       collector_id integer,
       museum_id integer,
       sourceaccessionnumber character varying(100),
       sizeclass_id serial NOT NULL,
       mindiameter double precision,
       diameteraccuracy double precision,
       minheight double precision,
       heightaccuracy double precision,
       maxdiameter double precision,
       maxheight double precision,
       accessioncode character varying(255),
       taxonoccurrence_id integer,
       CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ),
       CONSTRAINT specimen_collector_id FOREIGN KEY (collector_id)
           REFERENCES party (party_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_individualplant_id_fkey FOREIGN KEY (individualplant_id)
           REFERENCES individualplant (individualplant_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_museum_id FOREIGN KEY (museum_id)
           REFERENCES party (party_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_reference_id_fkey FOREIGN KEY (reference_id)
           REFERENCES reference (reference_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id)
           REFERENCES taxonoccurrence (taxonoccurrence_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE,
       CONSTRAINT specimen_keys UNIQUE (reference_id , collectioncode_dwc , catalognumber_dwc )
       CONSTRAINT sizeclass_pkey PRIMARY KEY (sizeclass_id )
     );
     CREATE TABLE taxonbin -- Defines a set of aggregate measurements. Used by aggregateoccurrence to define how measurements were aggregated.
-...
           REFERENCES sizeclass (sizeclass_id) MATCH SIMPLE
           ON UPDATE CASCADE ON DELETE CASCADE
     );
     CREATE TABLE sizeclass -- A range of size measurements used to aggregate organisms.
+    (
       sizeclass_id serial NOT NULL,
       mindiameter double precision,
       diameteraccuracy double precision,
       minheight double precision,
       heightaccuracy double precision,
       maxdiameter double precision,
       maxheight double precision,
       accessioncode character varying(255),
       CONSTRAINT sizeclass_pkey PRIMARY KEY (sizeclass_id )
     );

     "PostgreSQL","MySQL","Comments"
     "^--(?=\S)","$0 ",
     "^--(?=\S)","\g<0> ",
     "\bserial( NOT NULL\b)?","int(11)\1 AUTO_INCREMENT",
     "Integer","int(11)",
     "Boolean","int(1)",
     " with time zone\b","",
     "fulltext","\g<0>__"

Also available in: Unified diff

Project

General

Profile

Revision 537

Added by Aaron Marcuse-Kubitza about 13 years ago