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

--

CREATE FUNCTION sync_provider_count_to_view() RETURNS void

    LANGUAGE sql

    AS $$

DROP TABLE IF EXISTS provider_count;

CREATE TABLE provider_count AS SELECT * FROM provider_count_view LIMIT 0;

GRANT SELECT ON TABLE provider_count TO bien_read;

GRANT SELECT ON TABLE provider_count TO public_;

GRANT SELECT ON TABLE provider_count_view TO bien_read;

GRANT SELECT ON TABLE provider_count_view TO public_;

ALTER TABLE provider_count ADD PRIMARY KEY (provider);

$$;

--

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

--

CREATE TABLE provider_count (

    provider text NOT NULL,

    count bigint

);

--

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

--

--

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

--

ALTER TABLE ONLY provider_count

    ADD CONSTRAINT provider_count_pkey PRIMARY KEY (provider);

--

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

--

REVOKE ALL ON TABLE provider_count FROM PUBLIC;

REVOKE ALL ON TABLE provider_count FROM bien;

GRANT ALL ON TABLE provider_count TO bien;

GRANT SELECT ON TABLE provider_count TO bien_read;

GRANT SELECT ON TABLE provider_count TO public_;

--