Revision 7057
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/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 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 6725 | 6725 |
|
| 6726 | 6726 |
|
| 6727 | 6727 |
-- |
| 6728 |
-- Name: place_placename_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6729 |
-- |
|
| 6730 |
|
|
| 6731 |
CREATE INDEX place_placename_id_idx ON place USING btree (placename_id); |
|
| 6732 |
|
|
| 6733 |
|
|
| 6734 |
-- |
|
| 6728 | 6735 |
-- Name: place_unique_within_creator_by_name; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6729 | 6736 |
-- |
| 6730 | 6737 |
|
| ... | ... | |
| 7068 | 7075 |
|
| 7069 | 7076 |
|
| 7070 | 7077 |
-- |
| 7078 |
-- Name: taxondetermination_reference_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 7079 |
-- |
|
| 7080 |
|
|
| 7081 |
CREATE INDEX taxondetermination_reference_id_idx ON taxondetermination USING btree (reference_id); |
|
| 7082 |
|
|
| 7083 |
|
|
| 7084 |
-- |
|
| 7071 | 7085 |
-- Name: taxondetermination_single_current_determination; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 7072 | 7086 |
-- |
| 7073 | 7087 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added covering indexes where needed, as described at <https://projects.nceas.ucsb.edu/nceas/issues/549>