Revision 14492
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 1747 | 1747 |
|
| 1748 | 1748 |
|
| 1749 | 1749 |
-- |
| 1750 |
-- Name: taxon_scrub_best_match_jerry_lu; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 1751 |
-- |
|
| 1752 |
|
|
| 1753 |
CREATE INDEX taxon_scrub_best_match_jerry_lu ON taxon_match USING btree ("*Name_submitted", "*Name_score" DESC, "*Overall_score" DESC);
|
|
| 1754 |
|
|
| 1755 |
|
|
| 1756 |
-- |
|
| 1750 | 1757 |
-- Name: taxon_scrub_by_family; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
| 1751 | 1758 |
-- |
| 1752 | 1759 |
|
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 16724 | 16724 |
|
| 16725 | 16725 |
|
| 16726 | 16726 |
-- |
| 16727 |
-- Name: taxon_scrub_best_match_jerry_lu; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 16728 |
-- |
|
| 16729 |
|
|
| 16730 |
CREATE INDEX taxon_scrub_best_match_jerry_lu ON taxon_match (`*Name_submitted`, `*Name_score` DESC, `*Overall_score` DESC); |
|
| 16731 |
|
|
| 16732 |
|
|
| 16733 |
-- |
|
| 16727 | 16734 |
-- Name: taxon_scrub_by_family; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
| 16728 | 16735 |
-- |
| 16729 | 16736 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 22277 | 22277 |
|
| 22278 | 22278 |
|
| 22279 | 22279 |
-- |
| 22280 |
-- Name: taxon_scrub_best_match_jerry_lu; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 22281 |
-- |
|
| 22282 |
|
|
| 22283 |
CREATE INDEX taxon_scrub_best_match_jerry_lu ON taxon_match USING btree ("*Name_submitted", "*Name_score" DESC, "*Overall_score" DESC);
|
|
| 22284 |
|
|
| 22285 |
|
|
| 22286 |
-- |
|
| 22280 | 22287 |
-- Name: taxon_scrub_by_family; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
| 22281 | 22288 |
-- |
| 22282 | 22289 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: taxon_match: added taxon_scrub_best_match_jerry_lu index to facilitate finding names affected by the match-picking bug (#943)