Revision 14645
Added by Aaron Marcuse-Kubitza about 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 4403 | 4403 |
|
| 4404 | 4404 |
|
| 4405 | 4405 |
-- |
| 4406 |
-- Name: TABLE iucn_red_list; Type: COMMENT; Schema: public; Owner: - |
|
| 4407 |
-- |
|
| 4408 |
|
|
| 4409 |
|
|
| 4410 |
|
|
| 4411 |
|
|
| 4412 |
-- |
|
| 4406 | 4413 |
-- Name: source; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 4407 | 4414 |
-- |
| 4408 | 4415 |
|
| ... | ... | |
| 12120 | 12127 |
|
| 12121 | 12128 |
|
| 12122 | 12129 |
-- |
| 12123 |
-- Name: iucn_red_list_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 12130 |
-- Name: iucn_red_list__new_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 12124 | 12131 |
-- |
| 12125 | 12132 |
|
| 12126 | 12133 |
ALTER TABLE iucn_red_list |
| 12127 |
ADD CONSTRAINT iucn_red_list_pkey PRIMARY KEY (accepted_family, accepted_species_binomial); |
|
| 12134 |
ADD CONSTRAINT iucn_red_list__new_pkey PRIMARY KEY (accepted_family, accepted_species_binomial);
|
|
| 12128 | 12135 |
|
| 12129 | 12136 |
|
| 12130 | 12137 |
-- |
| ... | ... | |
| 12320 | 12327 |
|
| 12321 | 12328 |
|
| 12322 | 12329 |
-- |
| 12323 |
-- Name: provider_count_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 12330 |
-- Name: provider_count__new_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
|
|
| 12324 | 12331 |
-- |
| 12325 | 12332 |
|
| 12326 | 12333 |
ALTER TABLE provider_count |
| 12327 |
ADD CONSTRAINT provider_count_pkey PRIMARY KEY (dataprovider, dataset); |
|
| 12334 |
ADD CONSTRAINT provider_count__new_pkey PRIMARY KEY (dataprovider, dataset);
|
|
| 12328 | 12335 |
|
| 12329 | 12336 |
|
| 12330 | 12337 |
-- |
| ... | ... | |
| 13416 | 13423 |
|
| 13417 | 13424 |
|
| 13418 | 13425 |
-- |
| 13419 |
-- Name: taxon_trait_scientificName_measurementType_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 13426 |
-- Name: taxon_trait__new_scientificName_measurementType_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 13420 | 13427 |
-- |
| 13421 | 13428 |
|
| 13422 |
CREATE INDEX `taxon_trait_scientificName_measurementType_idx` ON taxon_trait (`scientificName`, `measurementType`); |
|
| 13429 |
CREATE INDEX `taxon_trait__new_scientificName_measurementType_idx` ON taxon_trait (`scientificName`, `measurementType`);
|
|
| 13423 | 13430 |
|
| 13424 | 13431 |
|
| 13425 | 13432 |
-- |
| trunk/schemas/public_.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 |
-- |
| trunk/schemas/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()