/schemas/vegbien.my.sql - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 537

Added by Aaron Marcuse-Kubitza almost 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).

         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)
     );

Also available in: Unified diff

Project

General

Profile

Revision 537

Added by Aaron Marcuse-Kubitza almost 13 years ago