Revision 7057
Added by Aaron Marcuse-Kubitza almost 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 5612 | 5612 |
|
| 5613 | 5613 |
|
| 5614 | 5614 |
-- |
| 5615 |
-- Name: place_placename_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5616 |
-- |
|
| 5617 |
|
|
| 5618 |
CREATE INDEX place_placename_id_idx ON place (placename_id); |
|
| 5619 |
|
|
| 5620 |
|
|
| 5621 |
-- |
|
| 5615 | 5622 |
-- Name: place_unique_within_creator_by_name; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5616 | 5623 |
-- |
| 5617 | 5624 |
|
| ... | ... | |
| 5955 | 5962 |
|
| 5956 | 5963 |
|
| 5957 | 5964 |
-- |
| 5965 |
-- Name: taxondetermination_reference_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5966 |
-- |
|
| 5967 |
|
|
| 5968 |
CREATE INDEX taxondetermination_reference_id_idx ON taxondetermination (reference_id); |
|
| 5969 |
|
|
| 5970 |
|
|
| 5971 |
-- |
|
| 5958 | 5972 |
-- Name: taxondetermination_single_current_determination; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5959 | 5973 |
-- |
| 5960 | 5974 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added covering indexes where needed, as described at <https://projects.nceas.ucsb.edu/nceas/issues/549>