Revision 14488
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 13682 | 13682 |
|
| 13683 | 13683 |
|
| 13684 | 13684 |
-- |
| 13685 |
-- Name: view_full_occurrence_individu_datasource_scrubbed_species_b_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 13686 |
-- |
|
| 13687 |
|
|
| 13688 |
CREATE INDEX view_full_occurrence_individu_datasource_scrubbed_species_b_idx ON view_full_occurrence_individual (datasource, scrubbed_species_binomial_with_morphospecies); |
|
| 13689 |
|
|
| 13690 |
|
|
| 13691 |
-- |
|
| 13685 | 13692 |
-- Name: view_full_occurrence_individu_scrubbed_species_binomial_wit_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 13686 | 13693 |
-- |
| 13687 | 13694 |
|
| ... | ... | |
| 13689 | 13696 |
|
| 13690 | 13697 |
|
| 13691 | 13698 |
-- |
| 13699 |
-- Name: view_full_occurrence_individual_datasource_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 13700 |
-- |
|
| 13701 |
|
|
| 13702 |
CREATE INDEX view_full_occurrence_individual_datasource_idx ON view_full_occurrence_individual (datasource); |
|
| 13703 |
|
|
| 13704 |
|
|
| 13705 |
-- |
|
| 13692 | 13706 |
-- Name: view_full_occurrence_individual_datasource_occurrence_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 13693 | 13707 |
-- |
| 13694 | 13708 |
|
| ... | ... | |
| 13696 | 13710 |
|
| 13697 | 13711 |
|
| 13698 | 13712 |
-- |
| 13713 |
-- Name: view_full_occurrence_individual_date_collected_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 13714 |
-- |
|
| 13715 |
|
|
| 13716 |
CREATE INDEX view_full_occurrence_individual_date_collected_idx ON view_full_occurrence_individual (date_collected); |
|
| 13717 |
|
|
| 13718 |
|
|
| 13719 |
-- |
|
| 13720 |
-- Name: view_full_occurrence_individual_event_date_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 13721 |
-- |
|
| 13722 |
|
|
| 13723 |
CREATE INDEX view_full_occurrence_individual_event_date_idx ON view_full_occurrence_individual (event_date); |
|
| 13724 |
|
|
| 13725 |
|
|
| 13726 |
-- |
|
| 13727 |
-- Name: view_full_occurrence_individual_is_cultivated_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 13728 |
-- |
|
| 13729 |
|
|
| 13730 |
CREATE INDEX view_full_occurrence_individual_is_cultivated_idx ON view_full_occurrence_individual (is_cultivated); |
|
| 13731 |
|
|
| 13732 |
|
|
| 13733 |
-- |
|
| 13734 |
-- Name: view_full_occurrence_individual_is_geovalid_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 13735 |
-- |
|
| 13736 |
|
|
| 13737 |
CREATE INDEX view_full_occurrence_individual_is_geovalid_idx ON view_full_occurrence_individual (is_geovalid); |
|
| 13738 |
|
|
| 13739 |
|
|
| 13740 |
-- |
|
| 13741 |
-- Name: view_full_occurrence_individual_is_new_world_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 13742 |
-- |
|
| 13743 |
|
|
| 13744 |
CREATE INDEX view_full_occurrence_individual_is_new_world_idx ON view_full_occurrence_individual (is_new_world); |
|
| 13745 |
|
|
| 13746 |
|
|
| 13747 |
-- |
|
| 13748 |
-- Name: view_full_occurrence_individual_latitude_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 13749 |
-- |
|
| 13750 |
|
|
| 13751 |
CREATE INDEX view_full_occurrence_individual_latitude_idx ON view_full_occurrence_individual (latitude); |
|
| 13752 |
|
|
| 13753 |
|
|
| 13754 |
-- |
|
| 13755 |
-- Name: view_full_occurrence_individual_longitude_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 13756 |
-- |
|
| 13757 |
|
|
| 13758 |
CREATE INDEX view_full_occurrence_individual_longitude_idx ON view_full_occurrence_individual (longitude); |
|
| 13759 |
|
|
| 13760 |
|
|
| 13761 |
-- |
|
| 13762 |
-- Name: view_full_occurrence_individual_plot_area_ha_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 13763 |
-- |
|
| 13764 |
|
|
| 13765 |
CREATE INDEX view_full_occurrence_individual_plot_area_ha_idx ON view_full_occurrence_individual (plot_area_ha); |
|
| 13766 |
|
|
| 13767 |
|
|
| 13768 |
-- |
|
| 13769 |
-- Name: view_full_occurrence_individual_scrubbed_species_binomial_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 13770 |
-- |
|
| 13771 |
|
|
| 13772 |
CREATE INDEX view_full_occurrence_individual_scrubbed_species_binomial_idx ON view_full_occurrence_individual (scrubbed_species_binomial); |
|
| 13773 |
|
|
| 13774 |
|
|
| 13775 |
-- |
|
| 13776 |
-- Name: view_full_occurrence_individual_taxonomic_status_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 13777 |
-- |
|
| 13778 |
|
|
| 13779 |
CREATE INDEX view_full_occurrence_individual_taxonomic_status_idx ON view_full_occurrence_individual (taxonomic_status); |
|
| 13780 |
|
|
| 13781 |
|
|
| 13782 |
-- |
|
| 13699 | 13783 |
-- Name: voucher_specimenreplicate_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 13700 | 13784 |
-- |
| 13701 | 13785 |
|
| trunk/schemas/public_.sql | ||
|---|---|---|
| 3493 | 3493 |
CREATE INDEX ON view_full_occurrence_individual (datasource, occurrence_id); |
| 3494 | 3494 |
CREATE INDEX ON view_full_occurrence_individual (datasource, custodial_institution_codes, collection_code, catalog_number); |
| 3495 | 3495 |
CREATE INDEX ON view_full_occurrence_individual (datasource, project_id, location_id, event_date); |
| 3496 |
CREATE INDEX ON view_full_occurrence_individual (scrubbed_species_binomial); |
|
| 3496 | 3497 |
CREATE INDEX ON view_full_occurrence_individual (scrubbed_species_binomial_with_morphospecies); |
| 3498 |
CREATE INDEX ON view_full_occurrence_individual (datasource, scrubbed_species_binomial_with_morphospecies); |
|
| 3499 |
CREATE INDEX ON view_full_occurrence_individual (latitude); |
|
| 3500 |
CREATE INDEX ON view_full_occurrence_individual (longitude); |
|
| 3501 |
CREATE INDEX ON view_full_occurrence_individual (plot_area_ha); |
|
| 3502 |
CREATE INDEX ON view_full_occurrence_individual (datasource); |
|
| 3503 |
CREATE INDEX ON view_full_occurrence_individual (date_collected); |
|
| 3504 |
CREATE INDEX ON view_full_occurrence_individual (event_date); |
|
| 3505 |
CREATE INDEX ON view_full_occurrence_individual (is_geovalid); |
|
| 3506 |
CREATE INDEX ON view_full_occurrence_individual (is_new_world); |
|
| 3507 |
CREATE INDEX ON view_full_occurrence_individual (is_cultivated); |
|
| 3508 |
CREATE INDEX ON view_full_occurrence_individual (taxonomic_status); |
|
| 3497 | 3509 |
$$, repopulate); |
| 3498 | 3510 |
END; |
| 3499 | 3511 |
$_$; |
| ... | ... | |
| 18096 | 18108 |
|
| 18097 | 18109 |
|
| 18098 | 18110 |
-- |
| 18111 |
-- Name: view_full_occurrence_individu_datasource_scrubbed_species_b_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18112 |
-- |
|
| 18113 |
|
|
| 18114 |
CREATE INDEX view_full_occurrence_individu_datasource_scrubbed_species_b_idx ON view_full_occurrence_individual USING btree (datasource, scrubbed_species_binomial_with_morphospecies); |
|
| 18115 |
|
|
| 18116 |
|
|
| 18117 |
-- |
|
| 18099 | 18118 |
-- Name: view_full_occurrence_individu_scrubbed_species_binomial_wit_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 18100 | 18119 |
-- |
| 18101 | 18120 |
|
| ... | ... | |
| 18103 | 18122 |
|
| 18104 | 18123 |
|
| 18105 | 18124 |
-- |
| 18125 |
-- Name: view_full_occurrence_individual_datasource_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18126 |
-- |
|
| 18127 |
|
|
| 18128 |
CREATE INDEX view_full_occurrence_individual_datasource_idx ON view_full_occurrence_individual USING btree (datasource); |
|
| 18129 |
|
|
| 18130 |
|
|
| 18131 |
-- |
|
| 18106 | 18132 |
-- Name: view_full_occurrence_individual_datasource_occurrence_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 18107 | 18133 |
-- |
| 18108 | 18134 |
|
| ... | ... | |
| 18110 | 18136 |
|
| 18111 | 18137 |
|
| 18112 | 18138 |
-- |
| 18139 |
-- Name: view_full_occurrence_individual_date_collected_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18140 |
-- |
|
| 18141 |
|
|
| 18142 |
CREATE INDEX view_full_occurrence_individual_date_collected_idx ON view_full_occurrence_individual USING btree (date_collected); |
|
| 18143 |
|
|
| 18144 |
|
|
| 18145 |
-- |
|
| 18146 |
-- Name: view_full_occurrence_individual_event_date_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18147 |
-- |
|
| 18148 |
|
|
| 18149 |
CREATE INDEX view_full_occurrence_individual_event_date_idx ON view_full_occurrence_individual USING btree (event_date); |
|
| 18150 |
|
|
| 18151 |
|
|
| 18152 |
-- |
|
| 18153 |
-- Name: view_full_occurrence_individual_is_cultivated_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18154 |
-- |
|
| 18155 |
|
|
| 18156 |
CREATE INDEX view_full_occurrence_individual_is_cultivated_idx ON view_full_occurrence_individual USING btree (is_cultivated); |
|
| 18157 |
|
|
| 18158 |
|
|
| 18159 |
-- |
|
| 18160 |
-- Name: view_full_occurrence_individual_is_geovalid_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18161 |
-- |
|
| 18162 |
|
|
| 18163 |
CREATE INDEX view_full_occurrence_individual_is_geovalid_idx ON view_full_occurrence_individual USING btree (is_geovalid); |
|
| 18164 |
|
|
| 18165 |
|
|
| 18166 |
-- |
|
| 18167 |
-- Name: view_full_occurrence_individual_is_new_world_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18168 |
-- |
|
| 18169 |
|
|
| 18170 |
CREATE INDEX view_full_occurrence_individual_is_new_world_idx ON view_full_occurrence_individual USING btree (is_new_world); |
|
| 18171 |
|
|
| 18172 |
|
|
| 18173 |
-- |
|
| 18174 |
-- Name: view_full_occurrence_individual_latitude_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18175 |
-- |
|
| 18176 |
|
|
| 18177 |
CREATE INDEX view_full_occurrence_individual_latitude_idx ON view_full_occurrence_individual USING btree (latitude); |
|
| 18178 |
|
|
| 18179 |
|
|
| 18180 |
-- |
|
| 18181 |
-- Name: view_full_occurrence_individual_longitude_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18182 |
-- |
|
| 18183 |
|
|
| 18184 |
CREATE INDEX view_full_occurrence_individual_longitude_idx ON view_full_occurrence_individual USING btree (longitude); |
|
| 18185 |
|
|
| 18186 |
|
|
| 18187 |
-- |
|
| 18188 |
-- Name: view_full_occurrence_individual_plot_area_ha_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18189 |
-- |
|
| 18190 |
|
|
| 18191 |
CREATE INDEX view_full_occurrence_individual_plot_area_ha_idx ON view_full_occurrence_individual USING btree (plot_area_ha); |
|
| 18192 |
|
|
| 18193 |
|
|
| 18194 |
-- |
|
| 18195 |
-- Name: view_full_occurrence_individual_scrubbed_species_binomial_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18196 |
-- |
|
| 18197 |
|
|
| 18198 |
CREATE INDEX view_full_occurrence_individual_scrubbed_species_binomial_idx ON view_full_occurrence_individual USING btree (scrubbed_species_binomial); |
|
| 18199 |
|
|
| 18200 |
|
|
| 18201 |
-- |
|
| 18202 |
-- Name: view_full_occurrence_individual_taxonomic_status_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18203 |
-- |
|
| 18204 |
|
|
| 18205 |
CREATE INDEX view_full_occurrence_individual_taxonomic_status_idx ON view_full_occurrence_individual USING btree (taxonomic_status); |
|
| 18206 |
|
|
| 18207 |
|
|
| 18208 |
-- |
|
| 18113 | 18209 |
-- Name: voucher_specimenreplicate_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 18114 | 18210 |
-- |
| 18115 | 18211 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 3493 | 3493 |
CREATE INDEX ON view_full_occurrence_individual (datasource, occurrence_id); |
| 3494 | 3494 |
CREATE INDEX ON view_full_occurrence_individual (datasource, custodial_institution_codes, collection_code, catalog_number); |
| 3495 | 3495 |
CREATE INDEX ON view_full_occurrence_individual (datasource, project_id, location_id, event_date); |
| 3496 |
CREATE INDEX ON view_full_occurrence_individual (scrubbed_species_binomial); |
|
| 3496 | 3497 |
CREATE INDEX ON view_full_occurrence_individual (scrubbed_species_binomial_with_morphospecies); |
| 3498 |
CREATE INDEX ON view_full_occurrence_individual (datasource, scrubbed_species_binomial_with_morphospecies); |
|
| 3499 |
CREATE INDEX ON view_full_occurrence_individual (latitude); |
|
| 3500 |
CREATE INDEX ON view_full_occurrence_individual (longitude); |
|
| 3501 |
CREATE INDEX ON view_full_occurrence_individual (plot_area_ha); |
|
| 3502 |
CREATE INDEX ON view_full_occurrence_individual (datasource); |
|
| 3503 |
CREATE INDEX ON view_full_occurrence_individual (date_collected); |
|
| 3504 |
CREATE INDEX ON view_full_occurrence_individual (event_date); |
|
| 3505 |
CREATE INDEX ON view_full_occurrence_individual (is_geovalid); |
|
| 3506 |
CREATE INDEX ON view_full_occurrence_individual (is_new_world); |
|
| 3507 |
CREATE INDEX ON view_full_occurrence_individual (is_cultivated); |
|
| 3508 |
CREATE INDEX ON view_full_occurrence_individual (taxonomic_status); |
|
| 3497 | 3509 |
$$, repopulate); |
| 3498 | 3510 |
END; |
| 3499 | 3511 |
$_$; |
| ... | ... | |
| 18096 | 18108 |
|
| 18097 | 18109 |
|
| 18098 | 18110 |
-- |
| 18111 |
-- Name: view_full_occurrence_individu_datasource_scrubbed_species_b_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18112 |
-- |
|
| 18113 |
|
|
| 18114 |
CREATE INDEX view_full_occurrence_individu_datasource_scrubbed_species_b_idx ON view_full_occurrence_individual USING btree (datasource, scrubbed_species_binomial_with_morphospecies); |
|
| 18115 |
|
|
| 18116 |
|
|
| 18117 |
-- |
|
| 18099 | 18118 |
-- Name: view_full_occurrence_individu_scrubbed_species_binomial_wit_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 18100 | 18119 |
-- |
| 18101 | 18120 |
|
| ... | ... | |
| 18103 | 18122 |
|
| 18104 | 18123 |
|
| 18105 | 18124 |
-- |
| 18125 |
-- Name: view_full_occurrence_individual_datasource_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18126 |
-- |
|
| 18127 |
|
|
| 18128 |
CREATE INDEX view_full_occurrence_individual_datasource_idx ON view_full_occurrence_individual USING btree (datasource); |
|
| 18129 |
|
|
| 18130 |
|
|
| 18131 |
-- |
|
| 18106 | 18132 |
-- Name: view_full_occurrence_individual_datasource_occurrence_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 18107 | 18133 |
-- |
| 18108 | 18134 |
|
| ... | ... | |
| 18110 | 18136 |
|
| 18111 | 18137 |
|
| 18112 | 18138 |
-- |
| 18139 |
-- Name: view_full_occurrence_individual_date_collected_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18140 |
-- |
|
| 18141 |
|
|
| 18142 |
CREATE INDEX view_full_occurrence_individual_date_collected_idx ON view_full_occurrence_individual USING btree (date_collected); |
|
| 18143 |
|
|
| 18144 |
|
|
| 18145 |
-- |
|
| 18146 |
-- Name: view_full_occurrence_individual_event_date_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18147 |
-- |
|
| 18148 |
|
|
| 18149 |
CREATE INDEX view_full_occurrence_individual_event_date_idx ON view_full_occurrence_individual USING btree (event_date); |
|
| 18150 |
|
|
| 18151 |
|
|
| 18152 |
-- |
|
| 18153 |
-- Name: view_full_occurrence_individual_is_cultivated_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18154 |
-- |
|
| 18155 |
|
|
| 18156 |
CREATE INDEX view_full_occurrence_individual_is_cultivated_idx ON view_full_occurrence_individual USING btree (is_cultivated); |
|
| 18157 |
|
|
| 18158 |
|
|
| 18159 |
-- |
|
| 18160 |
-- Name: view_full_occurrence_individual_is_geovalid_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18161 |
-- |
|
| 18162 |
|
|
| 18163 |
CREATE INDEX view_full_occurrence_individual_is_geovalid_idx ON view_full_occurrence_individual USING btree (is_geovalid); |
|
| 18164 |
|
|
| 18165 |
|
|
| 18166 |
-- |
|
| 18167 |
-- Name: view_full_occurrence_individual_is_new_world_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18168 |
-- |
|
| 18169 |
|
|
| 18170 |
CREATE INDEX view_full_occurrence_individual_is_new_world_idx ON view_full_occurrence_individual USING btree (is_new_world); |
|
| 18171 |
|
|
| 18172 |
|
|
| 18173 |
-- |
|
| 18174 |
-- Name: view_full_occurrence_individual_latitude_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18175 |
-- |
|
| 18176 |
|
|
| 18177 |
CREATE INDEX view_full_occurrence_individual_latitude_idx ON view_full_occurrence_individual USING btree (latitude); |
|
| 18178 |
|
|
| 18179 |
|
|
| 18180 |
-- |
|
| 18181 |
-- Name: view_full_occurrence_individual_longitude_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18182 |
-- |
|
| 18183 |
|
|
| 18184 |
CREATE INDEX view_full_occurrence_individual_longitude_idx ON view_full_occurrence_individual USING btree (longitude); |
|
| 18185 |
|
|
| 18186 |
|
|
| 18187 |
-- |
|
| 18188 |
-- Name: view_full_occurrence_individual_plot_area_ha_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18189 |
-- |
|
| 18190 |
|
|
| 18191 |
CREATE INDEX view_full_occurrence_individual_plot_area_ha_idx ON view_full_occurrence_individual USING btree (plot_area_ha); |
|
| 18192 |
|
|
| 18193 |
|
|
| 18194 |
-- |
|
| 18195 |
-- Name: view_full_occurrence_individual_scrubbed_species_binomial_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18196 |
-- |
|
| 18197 |
|
|
| 18198 |
CREATE INDEX view_full_occurrence_individual_scrubbed_species_binomial_idx ON view_full_occurrence_individual USING btree (scrubbed_species_binomial); |
|
| 18199 |
|
|
| 18200 |
|
|
| 18201 |
-- |
|
| 18202 |
-- Name: view_full_occurrence_individual_taxonomic_status_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 18203 |
-- |
|
| 18204 |
|
|
| 18205 |
CREATE INDEX view_full_occurrence_individual_taxonomic_status_idx ON view_full_occurrence_individual USING btree (taxonomic_status); |
|
| 18206 |
|
|
| 18207 |
|
|
| 18208 |
-- |
|
| 18113 | 18209 |
-- Name: voucher_specimenreplicate_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 18114 | 18210 |
-- |
| 18115 | 18211 |
|
Also available in: Unified diff
schemas/public_.sql: viewFullOccurrence_*: renamed to view_full_occurrence_* at Brian M's and Martha's request (e-mails from Martha on 2014-8-12 at 17:37PT, and from Brian M on 2014-8-13 at 16:21PT). note that this change has already been made on vegbiendev.