Revision 14645
Added by Aaron Marcuse-Kubitza about 10 years ago
| vegbien.sql | ||
|---|---|---|
| 6885 | 6885 |
|
| 6886 | 6886 |
|
| 6887 | 6887 |
-- |
| 6888 |
-- Name: TABLE iucn_red_list; Type: COMMENT; Schema: public; Owner: - |
|
| 6889 |
-- |
|
| 6890 |
|
|
| 6891 |
COMMENT ON TABLE iucn_red_list IS ' |
|
| 6892 |
after updating this: |
|
| 6893 |
SELECT iucn_red_list_view_modify(); |
|
| 6894 |
'; |
|
| 6895 |
|
|
| 6896 |
|
|
| 6897 |
-- |
|
| 6888 | 6898 |
-- Name: source; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 6889 | 6899 |
-- |
| 6890 | 6900 |
|
| ... | ... | |
| 16557 | 16567 |
|
| 16558 | 16568 |
|
| 16559 | 16569 |
-- |
| 16560 |
-- Name: iucn_red_list_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 16570 |
-- Name: iucn_red_list__new_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 16561 | 16571 |
-- |
| 16562 | 16572 |
|
| 16563 | 16573 |
ALTER TABLE ONLY iucn_red_list |
| 16564 |
ADD CONSTRAINT iucn_red_list_pkey PRIMARY KEY (accepted_family, accepted_species_binomial); |
|
| 16574 |
ADD CONSTRAINT iucn_red_list__new_pkey PRIMARY KEY (accepted_family, accepted_species_binomial);
|
|
| 16565 | 16575 |
|
| 16566 | 16576 |
|
| 16567 | 16577 |
-- |
| ... | ... | |
| 16757 | 16767 |
|
| 16758 | 16768 |
|
| 16759 | 16769 |
-- |
| 16760 |
-- Name: provider_count_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 16770 |
-- Name: provider_count__new_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 16761 | 16771 |
-- |
| 16762 | 16772 |
|
| 16763 | 16773 |
ALTER TABLE ONLY provider_count |
| 16764 |
ADD CONSTRAINT provider_count_pkey PRIMARY KEY (dataprovider, dataset); |
|
| 16774 |
ADD CONSTRAINT provider_count__new_pkey PRIMARY KEY (dataprovider, dataset);
|
|
| 16765 | 16775 |
|
| 16766 | 16776 |
|
| 16767 | 16777 |
-- |
| ... | ... | |
| 17853 | 17863 |
|
| 17854 | 17864 |
|
| 17855 | 17865 |
-- |
| 17856 |
-- Name: taxon_trait_scientificName_measurementType_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 17866 |
-- Name: taxon_trait__new_scientificName_measurementType_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 17857 | 17867 |
-- |
| 17858 | 17868 |
|
| 17859 |
CREATE INDEX "taxon_trait_scientificName_measurementType_idx" ON taxon_trait USING btree ("scientificName", "measurementType");
|
|
| 17869 |
CREATE INDEX "taxon_trait__new_scientificName_measurementType_idx" ON taxon_trait USING btree ("scientificName", "measurementType");
|
|
| 17860 | 17870 |
|
| 17861 | 17871 |
|
| 17862 | 17872 |
-- |
Also available in: Unified diff
schemas/public_.sql: *_view: re-ran *_view_modify(), which use the new non-blocking rematerialize_view()