-- Name: source; Type: TABLE; Schema: public; Owner: -; Tablespace: 

CREATE TABLE source (

    source_id int(11) NOT NULL,

    matched_source_id int(11),

    parent_id int(11),

    shortname varchar(255) NOT NULL,

    citation varchar(255),

    sourcetype varchar(255),

    accesslevel varchar(255),

    accessconditions varchar(255),

    observationtype varchar(255),

    title varchar(255),

    titlesuperior varchar(255),

    volume varchar(255),

    issue varchar(255),

    pagerange varchar(255),

    totalpages int(11),

    publisher varchar(255),

    publicationplace varchar(255),

    isbn varchar(255),

    edition varchar(255),

    numberofvolumes int(11),

    chapternumber int(11),

    reportnumber int(11),

    communicationtype varchar(255),

    degree varchar(255),

    url varchar(255),

    doi varchar(255),

    additionalinfo varchar(255),

    pubdate date,

    accessdate date,

    conferencedate date,

    datecreated date  NOT NULL,

    createdby varchar(255),

    datelastmodified date  NOT NULL,

    lastmodifiedby varchar(255),

    import_revision varchar(255)

);

--

-- Name: datasource_rm(varchar(255), anyelement); Type: FUNCTION; Schema: public; Owner: -

--

-- Name: FUNCTION datasource_rm(datasource varchar(255), schema_null anyelement); Type: COMMENT; Schema: public; Owner: -

-- Name: delete_scrubbed_taxondeterminations(varchar(255)); Type: FUNCTION; Schema: public; Owner: -

-- Name: make_family_higher_plant_group(); Type: FUNCTION; Schema: public; Owner: -

--

-- Name: party_source_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -

--

-- Name: place_matched_place_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -

--

--

-- Name: source; Type: ACL; Schema: public; Owner: -

--

--

SET default_tablespace = '';

SET default_with_oids = false;

-- Name: source; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE source (

    source_id integer NOT NULL,

    matched_source_id integer,

    parent_id integer,

    shortname text NOT NULL,

    citation text,

    sourcetype sourcetype,

    accesslevel accesslevel,

    accessconditions text,

    observationtype observationtype,

    title text,

    titlesuperior text,

    volume text,

    issue text,

    pagerange text,

    totalpages integer,

    publisher text,

    publicationplace text,

    isbn text,

    edition text,

    numberofvolumes integer,

    chapternumber integer,

    reportnumber integer,

    communicationtype text,

    degree text,

    url text,

    doi text,

    additionalinfo text,

    pubdate date,

    accessdate date,

    conferencedate date,

    datecreated date DEFAULT now() NOT NULL,

    createdby text,

    datelastmodified date DEFAULT now() NOT NULL,

    lastmodifiedby text,

    import_revision text

);

--

-- Name: datasource_rm(text, anyelement); Type: FUNCTION; Schema: public; Owner: -

--

CREATE FUNCTION datasource_rm(datasource text, schema_null anyelement DEFAULT NULL::source) RETURNS void

    LANGUAGE sql

    AS $_$

SELECT set_config('search_path', util.schema_ident($2), is_local := true);

DELETE FROM source WHERE shortname = $1;

$_$;

--

-- Name: FUNCTION datasource_rm(datasource text, schema_null anyelement); Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON FUNCTION datasource_rm(datasource text, schema_null anyelement) IS 'secure against renamings of the public schema.

schema_null: identifies which schema''s tables to use. the default value is usually fine.';

--

-- Name: source; Type: ACL; Schema: public; Owner: -

--

REVOKE ALL ON TABLE source FROM PUBLIC;

REVOKE ALL ON TABLE source FROM bien;

GRANT ALL ON TABLE source TO bien;

GRANT SELECT ON TABLE source TO bien_read;

GRANT SELECT ON TABLE source TO public_;

--