Revision 14468
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 1754 | 1754 |
|
| 1755 | 1755 |
|
| 1756 | 1756 |
-- |
| 1757 |
-- Name: taxon_scrub_by_name; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 1758 |
-- |
|
| 1759 |
|
|
| 1760 |
CREATE INDEX taxon_scrub_by_name ON taxon_match USING btree ("*Accepted_name") WHERE (("*Selected" = 'true'::text) AND is_valid_match);
|
|
| 1761 |
|
|
| 1762 |
|
|
| 1763 |
-- |
|
| 1757 | 1764 |
-- Name: taxon_scrub_by_species_binomial; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
| 1758 | 1765 |
-- |
| 1759 | 1766 |
|
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 16572 | 16572 |
|
| 16573 | 16573 |
|
| 16574 | 16574 |
-- |
| 16575 |
-- Name: taxon_scrub_by_name; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 16576 |
-- |
|
| 16577 |
|
|
| 16578 |
|
|
| 16579 |
|
|
| 16580 |
|
|
| 16581 |
-- |
|
| 16575 | 16582 |
-- Name: taxon_scrub_by_species_binomial; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
| 16576 | 16583 |
-- |
| 16577 | 16584 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 21795 | 21795 |
|
| 21796 | 21796 |
|
| 21797 | 21797 |
-- |
| 21798 |
-- Name: taxon_scrub_by_name; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 21799 |
-- |
|
| 21800 |
|
|
| 21801 |
CREATE INDEX taxon_scrub_by_name ON taxon_match USING btree ("*Accepted_name") WHERE (("*Selected" = 'true'::text) AND is_valid_match);
|
|
| 21802 |
|
|
| 21803 |
|
|
| 21804 |
-- |
|
| 21798 | 21805 |
-- Name: taxon_scrub_by_species_binomial; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
| 21799 | 21806 |
-- |
| 21800 | 21807 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: taxon_match: added taxon_scrub_by_name index