Revision 7057
Added by Aaron Marcuse-Kubitza almost 12 years ago
| 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>