Revision 5546
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3985 | 3985 |
|
| 3986 | 3986 |
|
| 3987 | 3987 |
-- |
| 3988 |
-- Name: taxonconcept_ancestor_descendants; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3989 |
-- |
|
| 3990 |
|
|
| 3991 |
CREATE INDEX taxonconcept_ancestor_descendants ON taxonconcept_ancestor (ancestor_id, taxonconcept_id); |
|
| 3992 |
|
|
| 3993 |
|
|
| 3994 |
-- |
|
| 3988 | 3995 |
-- Name: taxonconcept_matched_concept_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3989 | 3996 |
-- |
| 3990 | 3997 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4689 | 4689 |
|
| 4690 | 4690 |
|
| 4691 | 4691 |
-- |
| 4692 |
-- Name: taxonconcept_ancestor_descendants; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4693 |
-- |
|
| 4694 |
|
|
| 4695 |
CREATE INDEX taxonconcept_ancestor_descendants ON taxonconcept_ancestor USING btree (ancestor_id, taxonconcept_id); |
|
| 4696 |
|
|
| 4697 |
|
|
| 4698 |
-- |
|
| 4692 | 4699 |
-- Name: taxonconcept_matched_concept_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4693 | 4700 |
-- |
| 4694 | 4701 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonconcept_ancestor: Added taxonconcept_ancestor_descendants index to support looking up all the descendants for a taxonconcept. This will be used by the new taxonconcept_update_ancestors() trigger, which will support inserting taxonconcepts out of dependency order (such as for NCBI).