Revision 14467
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 1747 | 1747 |
|
| 1748 | 1748 |
|
| 1749 | 1749 |
-- |
| 1750 |
-- Name: taxon_scrub_by_family; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 1751 |
-- |
|
| 1752 |
|
|
| 1753 |
CREATE INDEX taxon_scrub_by_family ON taxon_match USING btree ("Accepted_family__@TNRS__@vegpath.org") WHERE (("*Selected" = 'true'::text) AND is_valid_match);
|
|
| 1754 |
|
|
| 1755 |
|
|
| 1756 |
-- |
|
| 1750 | 1757 |
-- Name: taxon_scrub_by_species_binomial; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
| 1751 | 1758 |
-- |
| 1752 | 1759 |
|
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 16565 | 16565 |
|
| 16566 | 16566 |
|
| 16567 | 16567 |
-- |
| 16568 |
-- Name: taxon_scrub_by_family; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 16569 |
-- |
|
| 16570 |
|
|
| 16571 |
|
|
| 16572 |
|
|
| 16573 |
|
|
| 16574 |
-- |
|
| 16568 | 16575 |
-- Name: taxon_scrub_by_species_binomial; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
| 16569 | 16576 |
-- |
| 16570 | 16577 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 21788 | 21788 |
|
| 21789 | 21789 |
|
| 21790 | 21790 |
-- |
| 21791 |
-- Name: taxon_scrub_by_family; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 21792 |
-- |
|
| 21793 |
|
|
| 21794 |
CREATE INDEX taxon_scrub_by_family ON taxon_match USING btree ("Accepted_family__@TNRS__@vegpath.org") WHERE (("*Selected" = 'true'::text) AND is_valid_match);
|
|
| 21795 |
|
|
| 21796 |
|
|
| 21797 |
-- |
|
| 21791 | 21798 |
-- Name: taxon_scrub_by_species_binomial; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
| 21792 | 21799 |
-- |
| 21793 | 21800 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: taxon_match: added taxon_scrub_by_family index