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

--

CREATE FUNCTION sync_owner_count_to_view() RETURNS void

    LANGUAGE sql

    AS $$

DROP TABLE IF EXISTS owner_count;

CREATE TABLE owner_count AS SELECT * FROM owner_count_view LIMIT 0;

GRANT SELECT ON TABLE owner_count TO bien_read;

GRANT SELECT ON TABLE owner_count TO public_;

GRANT SELECT ON TABLE owner_count_view TO bien_read;

GRANT SELECT ON TABLE owner_count_view TO public_;

ALTER TABLE owner_count ADD PRIMARY KEY (owner);

$$;

--

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

--

CREATE TABLE owner_count (

    owner text NOT NULL,

    count bigint

);

--

-- 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: owner_count_view; Type: VIEW; Schema: public; Owner: -

--

CREATE VIEW owner_count_view AS

    SELECT sourcename.name AS owner, count(*) AS count FROM ((sourcename JOIN sourcelist USING (sourcelist_id)) JOIN specimenreplicate ON ((specimenreplicate.institution_id = sourcelist.sourcelist_id))) GROUP BY sourcename.name;

--

-- Data for Name: owner_count; Type: TABLE DATA; Schema: public; Owner: -

--

--

-- Name: owner_count_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE ONLY owner_count

    ADD CONSTRAINT owner_count_pkey PRIMARY KEY (owner);

--

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

--

REVOKE ALL ON TABLE owner_count FROM PUBLIC;

REVOKE ALL ON TABLE owner_count FROM bien;

GRANT ALL ON TABLE owner_count TO bien;

GRANT SELECT ON TABLE owner_count TO bien_read;

GRANT SELECT ON TABLE owner_count TO public_;

--

-- 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: owner_count_view; Type: ACL; Schema: public; Owner: -

--

REVOKE ALL ON TABLE owner_count_view FROM PUBLIC;

REVOKE ALL ON TABLE owner_count_view FROM bien;

GRANT ALL ON TABLE owner_count_view TO bien;

GRANT SELECT ON TABLE owner_count_view TO bien_read;

GRANT SELECT ON TABLE owner_count_view TO public_;

--