Revision 6864
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 2664 | 2664 |
|
| 2665 | 2665 |
|
| 2666 | 2666 |
-- |
| 2667 |
-- Name: provider_count_view; Type: VIEW; Schema: public; Owner: - |
|
| 2668 |
-- |
|
| 2669 |
|
|
| 2670 |
|
|
| 2671 |
|
|
| 2672 |
|
|
| 2673 |
-- |
|
| 2667 | 2674 |
-- Name: sourcename; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2668 | 2675 |
-- |
| 2669 | 2676 |
|
| ... | ... | |
| 7037 | 7044 |
|
| 7038 | 7045 |
|
| 7039 | 7046 |
-- |
| 7047 |
-- Name: provider_count_view; Type: ACL; Schema: public; Owner: - |
|
| 7048 |
-- |
|
| 7049 |
|
|
| 7050 |
|
|
| 7051 |
|
|
| 7052 |
|
|
| 7053 |
|
|
| 7054 |
|
|
| 7055 |
|
|
| 7056 |
|
|
| 7057 |
-- |
|
| 7040 | 7058 |
-- Name: sourcename; Type: ACL; Schema: public; Owner: - |
| 7041 | 7059 |
-- |
| 7042 | 7060 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 3630 | 3630 |
|
| 3631 | 3631 |
|
| 3632 | 3632 |
-- |
| 3633 |
-- Name: provider_count_view; Type: VIEW; Schema: public; Owner: - |
|
| 3634 |
-- |
|
| 3635 |
|
|
| 3636 |
CREATE VIEW provider_count_view AS |
|
| 3637 |
SELECT analytical_stem.datasource AS provider, count(*) AS count FROM analytical_stem GROUP BY analytical_stem.datasource; |
|
| 3638 |
|
|
| 3639 |
|
|
| 3640 |
-- |
|
| 3633 | 3641 |
-- Name: sourcename; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 3634 | 3642 |
-- |
| 3635 | 3643 |
|
| ... | ... | |
| 8171 | 8179 |
|
| 8172 | 8180 |
|
| 8173 | 8181 |
-- |
| 8182 |
-- Name: provider_count_view; Type: ACL; Schema: public; Owner: - |
|
| 8183 |
-- |
|
| 8184 |
|
|
| 8185 |
REVOKE ALL ON TABLE provider_count_view FROM PUBLIC; |
|
| 8186 |
REVOKE ALL ON TABLE provider_count_view FROM bien; |
|
| 8187 |
GRANT ALL ON TABLE provider_count_view TO bien; |
|
| 8188 |
GRANT SELECT ON TABLE provider_count_view TO bien_read; |
|
| 8189 |
GRANT SELECT ON TABLE provider_count_view TO public_; |
|
| 8190 |
|
|
| 8191 |
|
|
| 8192 |
-- |
|
| 8174 | 8193 |
-- Name: sourcename; Type: ACL; Schema: public; Owner: - |
| 8175 | 8194 |
-- |
| 8176 | 8195 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added provider_count_view for counts of occurrences per top-level provider