Revision 14466
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.sql | ||
|---|---|---|
| 21787 | 21787 |
CREATE UNIQUE INDEX taxon_match__one_selected_match ON taxon_match USING btree (batch, "*Name_number") WHERE ("*Selected" = 'true'::text);
|
| 21788 | 21788 |
|
| 21789 | 21789 |
|
| 21790 |
-- |
|
| 21791 |
-- Name: taxon_scrub_by_species_binomial; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 21792 |
-- |
|
| 21793 |
|
|
| 21794 |
CREATE INDEX taxon_scrub_by_species_binomial ON taxon_match USING btree ("Accepted_species[_binomial]__@TNRS__@vegpath.org", "Accepted_family__@TNRS__@vegpath.org") WHERE (("*Selected" = 'true'::text) AND is_valid_match);
|
|
| 21795 |
|
|
| 21796 |
|
|
| 21790 | 21797 |
SET search_path = geoscrub, pg_catalog; |
| 21791 | 21798 |
|
| 21792 | 21799 |
-- |
Also available in: Unified diff
inputs/.TNRS/schema.sql: taxon_match: added taxon_scrub_by_species_binomial index