Revision 14466
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_species_binomial; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 1751 |
-- |
|
| 1752 |
|
|
| 1753 |
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);
|
|
| 1754 |
|
|
| 1755 |
|
|
| 1756 |
-- |
|
| 1750 | 1757 |
-- Name: batch__fill; Type: TRIGGER; Schema: TNRS; Owner: - |
| 1751 | 1758 |
-- |
| 1752 | 1759 |
|
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 16564 | 16564 |
|
| 16565 | 16565 |
|
| 16566 | 16566 |
|
| 16567 |
-- |
|
| 16568 |
-- Name: taxon_scrub_by_species_binomial; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 16569 |
-- |
|
| 16570 |
|
|
| 16571 |
|
|
| 16572 |
|
|
| 16573 |
|
|
| 16567 | 16574 |
USE geoscrub; |
| 16568 | 16575 |
|
| 16569 | 16576 |
-- |
| trunk/schemas/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