Revision 11607
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/.TNRS/schema.sql | ||
|---|---|---|
| 444 | 444 |
|
| 445 | 445 |
|
| 446 | 446 |
-- |
| 447 |
-- Name: tnrs__valid_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 448 |
-- |
|
| 449 |
|
|
| 450 |
CREATE UNIQUE INDEX tnrs__valid_match ON tnrs USING btree ("Name_submitted") WHERE is_valid_match;
|
|
| 451 |
|
|
| 452 |
|
|
| 453 |
-- |
|
| 447 | 454 |
-- Name: tnrs_score_ok; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
| 448 | 455 |
-- |
| 449 | 456 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: tnrs: added tnrs__valid_match index to facilitate joining to only valid matches