/ - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 11667

Added by Aaron Marcuse-Kubitza about 11 years ago

schemas/*.sql: updated for PostgreSQL 9.3. this reorders some functions, adds empty comment headers for omitted SEQUENCE SET commands, and (best of all) finally splits view columns onto multiple lines, so that changes in the columns are actually legible (and produce their own svn diff!)

     --
     SET statement_timeout = 0;
     SET lock_timeout = 0;
     SET client_encoding = 'UTF8';
     SET standard_conforming_strings = on;
     SET check_function_bodies = false;
-...
     ALTER FUNCTION py_util._date(date timestamp with time zone) OWNER TO bien;
     --
     -- Name: _date(integer, integer, integer); Type: FUNCTION; Schema: py_util; Owner: bien
     --
     CREATE FUNCTION _date(year integer DEFAULT NULL::integer, month integer DEFAULT NULL::integer, day integer DEFAULT NULL::integer) RETURNS text
         LANGUAGE sql IMMUTABLE STRICT
         AS $_$
     SELECT py_util._date($1::text, $2::text, $3::text)
     $_$;
     ALTER FUNCTION py_util._date(year integer, month integer, day integer) OWNER TO bien;
     --
     -- Name: _date(text, text, text); Type: FUNCTION; Schema: py_util; Owner: bien
     --
-...
     ALTER FUNCTION py_util._date(year text, month text, day text) OWNER TO bien;
     --
     -- Name: _date(integer, integer, integer); Type: FUNCTION; Schema: py_util; Owner: bien
     --
     CREATE FUNCTION _date(year integer DEFAULT NULL::integer, month integer DEFAULT NULL::integer, day integer DEFAULT NULL::integer) RETURNS text
         LANGUAGE sql IMMUTABLE STRICT
         AS $_$
     SELECT py_util._date($1::text, $2::text, $3::text)
     $_$;
     ALTER FUNCTION py_util._date(year integer, month integer, day integer) OWNER TO bien;
     --
     -- Name: _dateRangeEnd(text); Type: FUNCTION; Schema: py_util; Owner: bien
     --

     --
     SET statement_timeout = 0;
     SET lock_timeout = 0;
     SET client_encoding = 'UTF8';
     SET standard_conforming_strings = on;
     SET check_function_bodies = false;
-...
     --
     -- Name: _map(hstore, anyelement); Type: FUNCTION; Schema: util; Owner: -
     --
     CREATE FUNCTION _map(map hstore, value anyelement) RETURNS anyelement
         LANGUAGE plpgsql IMMUTABLE STRICT
         AS $$
     DECLARE
         result value%TYPE := util._map(map, value::text)::unknown;
     BEGIN
         RETURN result;
     END;
     $$;
     --
     -- Name: _map(hstore, text); Type: FUNCTION; Schema: util; Owner: -
     --
-...
     --
     -- Name: _map(hstore, anyelement); Type: FUNCTION; Schema: util; Owner: -
     --
     CREATE FUNCTION _map(map hstore, value anyelement) RETURNS anyelement
         LANGUAGE plpgsql IMMUTABLE STRICT
         AS $$
     DECLARE
         result value%TYPE := util._map(map, value::text)::unknown;
     BEGIN
         RETURN result;
     END;
     $$;
     --
     -- Name: _max(anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement); Type: FUNCTION; Schema: util; Owner: -
     --
-...
     --
     -- Name: _nullIf(anyelement, text, text); Type: FUNCTION; Schema: util; Owner: -
     --
     CREATE FUNCTION "_nullIf"(value anyelement, "null" text, type text) RETURNS anyelement
         LANGUAGE sql IMMUTABLE
         AS $_$
     SELECT util."_nullIf"($1, $2, $3::util.datatype)
     $_$;
     --
     -- Name: _nullIf(anyelement, text, datatype); Type: FUNCTION; Schema: util; Owner: -
     --
-...
     --
     -- Name: _nullIf(anyelement, text, text); Type: FUNCTION; Schema: util; Owner: -
     --
     CREATE FUNCTION "_nullIf"(value anyelement, "null" text, type text) RETURNS anyelement
         LANGUAGE sql IMMUTABLE
         AS $_$
     SELECT util."_nullIf"($1, $2, $3::util.datatype)
     $_$;
     --
     -- Name: _or(boolean, boolean, boolean, boolean, boolean); Type: FUNCTION; Schema: util; Owner: -
     --
-...
     --
     -- Name: col_names(regtype); Type: FUNCTION; Schema: util; Owner: -
     --
     CREATE FUNCTION col_names(type regtype) RETURNS SETOF text
         LANGUAGE plpgsql STABLE STRICT
         AS $_$
     BEGIN
         RETURN QUERY EXECUTE $$SELECT skeys(hstore(NULL::$$||type||$$))$$;
     END;
     $_$;
     --
     -- Name: col_names(regclass); Type: FUNCTION; Schema: util; Owner: -
     --
-...
     --
     -- Name: col_names(regtype); Type: FUNCTION; Schema: util; Owner: -
     --
     CREATE FUNCTION col_names(type regtype) RETURNS SETOF text
         LANGUAGE plpgsql STABLE STRICT
         AS $_$
     BEGIN
         RETURN QUERY EXECUTE $$SELECT skeys(hstore(NULL::$$||type||$$))$$;
     END;
     $_$;
     --
     -- Name: col_type(col_ref); Type: FUNCTION; Schema: util; Owner: -
     --

     --
     -- Name: accesslevel; Type: TYPE; Schema: public; Owner: -
     --
-...
     --
     -- Name: address_address_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: aggregateoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: analytical_plot; Type: VIEW; Schema: public; Owner: -
     --
-...
     --
     -- Name: analytical_stem_taxon_occurrence__pkey_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: coordinates; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: commclass_commclass_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: commconcept; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: commconcept_commconcept_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: commcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: commdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: commlineage_commlineage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: commname_commname_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: commstatus_commstatus_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: commusage_commusage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: coordinates_coordinates_id_seq; Type: SEQUENCE; Schema: public; Owner: -
     --
-...
     --
     -- Name: coordinates_coordinates_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: coverindex_coverindex_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: covermethod_covermethod_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: -
     --
-...
     --
     -- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: geoscrub_input; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: graphic_graphic_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: higher_plant_group_nodes; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: location_location_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: locationevent_locationevent_id_seq; Type: SEQUENCE; Schema: public; Owner: -
     --
-...
     --
     -- Name: locationevent_locationevent_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: locationeventcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: locationeventsynonym; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: locationplace_locationplace_id_seq; Type: SEQUENCE; Schema: public; Owner: -
     --
-...
     --
     -- Name: locationplace_locationplace_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: -
     --
-...
     --
     -- Name: method_method_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: methodtaxonclass; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: note; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: note_note_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: notelink; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: notelink_notelink_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: party_party_id_seq; Type: SEQUENCE; Schema: public; Owner: -
     --
-...
     --
     -- Name: party_party_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: partymember; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: partymember_partymember_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: place_place_id_seq; Type: SEQUENCE; Schema: public; Owner: -
     --
-...
     --
     -- Name: place_place_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: placecorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: placecorrelation_placecorrelation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: placename; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: placename_placename_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: plant; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: plant_plant_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
     --
-...
     --
     -- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: project_project_id_seq; Type: SEQUENCE; Schema: public; Owner: -
     --
-...
     --
     -- Name: project_project_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: projectcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: provider_count; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: revision_revision_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: soilsample; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: soilsample_soilsample_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: soiltaxon; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: source_source_id_seq; Type: SEQUENCE; Schema: public; Owner: -
     --
-...
     --
     -- Name: source_source_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: sourcecontributor; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: sourcecontributor_sourcecontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: sourcelist_sourcelist_id_seq; Type: SEQUENCE; Schema: public; Owner: -
     --
-...
     --
     -- Name: sourcelist_sourcelist_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: specimen; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: specimen_specimen_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public; Owner: -
     --
-...
     --
     -- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
     --
-...
     --
     -- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: stratum_stratum_id_seq; Type: SEQUENCE; Schema: public; Owner: -
     --
-...
     --
     -- Name: stratum_stratum_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: taxon_trait; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: taxonconcept; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: taxonconcept_taxonlabel_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: taxoncorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
     --
-...
     --
     -- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: taxonlabel_relationship; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: taxonlineage; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
     --
-...
     --
     -- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: taxonstatus; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE; Schema: public; Owner: -
     --
-...
     --
     -- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: telephone_telephone_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: threatened_taxonlabel_view; Type: VIEW; Schema: public; Owner: -
     --
-...
     --
     -- Name: trait_trait_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: userdefined_userdefined_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace:
     --
-...
     --
     -- Name: voucher_voucher_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Name: address_id; Type: DEFAULT; Schema: public; Owner: -
     --
-...
     --
     -- Name: address_address_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: aggregateoccurrence; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: analytical_stem; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: analytical_stem_taxon_occurrence__pkey_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: classcontributor; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: commclass; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: commclass_commclass_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: commconcept; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: commconcept_commconcept_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: commcorrelation; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: commdetermination; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: commlineage; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: commlineage_commlineage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: commname; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: commname_commname_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: commstatus; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: commstatus_commstatus_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: commusage; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: commusage_commusage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: coordinates; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: coordinates_coordinates_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: coverindex; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: coverindex_coverindex_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: covermethod; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: covermethod_covermethod_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: cultivated_family_locations; Type: TABLE DATA; Schema: public; Owner: -
     --
-...
     --
     -- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: definedvalue; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: disturbanceobs; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: family_higher_plant_group; Type: TABLE DATA; Schema: public; Owner: -
     --
-...
     --
     -- Name: graphic_graphic_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: higher_plant_group_nodes; Type: TABLE DATA; Schema: public; Owner: -
     --
-...
     --
     -- Name: location_location_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: locationevent; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: locationevent_locationevent_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: locationeventcontributor; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: locationeventsynonym; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: locationplace; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: locationplace_locationplace_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: method; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: method_method_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: methodtaxonclass; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: note; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: note_note_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: notelink; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: notelink_notelink_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: party; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: party_party_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: partymember; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: partymember_partymember_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: place; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: place_place_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: placecorrelation; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: placecorrelation_placecorrelation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: placename; Type: TABLE DATA; Schema: public; Owner: -
     --
-...
     --
     -- Name: placename_placename_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: plant; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: plant_plant_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: plantobservation; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: project; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: project_project_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: projectcontributor; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: provider_count; Type: TABLE DATA; Schema: public; Owner: -
     --
-...
     --
     -- Name: revision_revision_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: soilsample; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: soilsample_soilsample_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: soiltaxon; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
     --
     --
     -- Data for Name: source; Type: TABLE DATA; Schema: public; Owner: -
     --
     --
     -- Name: source_source_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -

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

Also available in: Unified diff

Project

General

Profile

Revision 11667

Added by Aaron Marcuse-Kubitza about 11 years ago