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

--

CREATE TABLE sourcename (

    sourcelist_id integer NOT NULL,

    name text NOT NULL,

    matched_source_id integer

);

--

-- Name: provider_view; Type: VIEW; Schema: public; Owner: -

--

CREATE VIEW provider_view AS

    (SELECT source.shortname AS name, source.sourcetype, source.observationtype FROM source ORDER BY source.sourcetype DESC, source.shortname) UNION ALL (SELECT sourcename.name, 'herbarium'::sourcetype AS sourcetype, 'specimen'::observationtype AS observationtype FROM sourcename WHERE (sourcename.matched_source_id IS NULL) ORDER BY sourcename.name);

--

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

--

REVOKE ALL ON TABLE sourcename FROM PUBLIC;

REVOKE ALL ON TABLE sourcename FROM bien;

GRANT ALL ON TABLE sourcename TO bien;

GRANT SELECT ON TABLE sourcename TO bien_read;

GRANT SELECT ON TABLE sourcename TO public_;

--

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

--

REVOKE ALL ON TABLE provider_view FROM PUBLIC;

REVOKE ALL ON TABLE provider_view FROM bien;

GRANT ALL ON TABLE provider_view TO bien;

GRANT SELECT ON TABLE provider_view TO bien_read;

GRANT SELECT ON TABLE provider_view TO public_;

--