Revision 6865
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 423 | 423 |
|
| 424 | 424 |
|
| 425 | 425 |
-- |
| 426 |
-- Name: sync_provider_count_to_view(); Type: FUNCTION; Schema: public; Owner: - |
|
| 427 |
-- |
|
| 428 |
|
|
| 429 |
|
|
| 430 |
|
|
| 431 |
|
|
| 432 |
-- |
|
| 426 | 433 |
-- Name: taxondetermination_set_iscurrent(); Type: FUNCTION; Schema: public; Owner: - |
| 427 | 434 |
-- |
| 428 | 435 |
|
| ... | ... | |
| 2664 | 2671 |
|
| 2665 | 2672 |
|
| 2666 | 2673 |
-- |
| 2674 |
-- Name: provider_count; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2675 |
-- |
|
| 2676 |
|
|
| 2677 |
CREATE TABLE provider_count ( |
|
| 2678 |
provider varchar(255) NOT NULL, |
|
| 2679 |
count varchar(255) |
|
| 2680 |
); |
|
| 2681 |
|
|
| 2682 |
|
|
| 2683 |
-- |
|
| 2667 | 2684 |
-- Name: provider_count_view; Type: VIEW; Schema: public; Owner: - |
| 2668 | 2685 |
-- |
| 2669 | 2686 |
|
| ... | ... | |
| 4150 | 4167 |
|
| 4151 | 4168 |
|
| 4152 | 4169 |
-- |
| 4170 |
-- Data for Name: provider_count; Type: TABLE DATA; Schema: public; Owner: - |
|
| 4171 |
-- |
|
| 4172 |
|
|
| 4173 |
|
|
| 4174 |
|
|
| 4175 |
-- |
|
| 4153 | 4176 |
-- Data for Name: revision; Type: TABLE DATA; Schema: public; Owner: - |
| 4154 | 4177 |
-- |
| 4155 | 4178 |
|
| ... | ... | |
| 4666 | 4689 |
|
| 4667 | 4690 |
|
| 4668 | 4691 |
-- |
| 4692 |
-- Name: provider_count_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4693 |
-- |
|
| 4694 |
|
|
| 4695 |
ALTER TABLE provider_count |
|
| 4696 |
ADD CONSTRAINT provider_count_pkey PRIMARY KEY (provider); |
|
| 4697 |
|
|
| 4698 |
|
|
| 4699 |
-- |
|
| 4669 | 4700 |
-- Name: revision_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4670 | 4701 |
-- |
| 4671 | 4702 |
|
| ... | ... | |
| 7044 | 7075 |
|
| 7045 | 7076 |
|
| 7046 | 7077 |
-- |
| 7078 |
-- Name: provider_count; Type: ACL; Schema: public; Owner: - |
|
| 7079 |
-- |
|
| 7080 |
|
|
| 7081 |
|
|
| 7082 |
|
|
| 7083 |
|
|
| 7084 |
|
|
| 7085 |
|
|
| 7086 |
|
|
| 7087 |
|
|
| 7088 |
-- |
|
| 7047 | 7089 |
-- Name: provider_count_view; Type: ACL; Schema: public; Owner: - |
| 7048 | 7090 |
-- |
| 7049 | 7091 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added materialized view provider_count, generated from provider_count_view