Revision 13879
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 852 | 852 |
|
| 853 | 853 |
|
| 854 | 854 |
-- |
| 855 |
-- Name: taxon_match_Name_submitted_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
|
|
| 855 |
-- Name: taxon_best_match__valid_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
|
|
| 856 | 856 |
-- |
| 857 | 857 |
|
| 858 |
CREATE INDEX "taxon_match_Name_submitted_idx" ON taxon_match USING btree ("Name_submitted");
|
|
| 858 |
CREATE INDEX taxon_best_match__valid_match ON taxon_match USING btree ("Name_submitted") WHERE (("Selected" = 'true'::text) AND is_valid_match);
|
|
| 859 | 859 |
|
| 860 | 860 |
|
| 861 | 861 |
-- |
| 862 |
-- Name: taxon_match__one_selected_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
|
|
| 862 |
-- Name: taxon_match_Name_submitted_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
|
|
| 863 | 863 |
-- |
| 864 | 864 |
|
| 865 |
CREATE UNIQUE INDEX taxon_match__one_selected_match ON taxon_match USING btree (batch, "Name_number") WHERE ("Selected" = 'true'::text);
|
|
| 865 |
CREATE INDEX "taxon_match_Name_submitted_idx" ON taxon_match USING btree ("Name_submitted");
|
|
| 866 | 866 |
|
| 867 | 867 |
|
| 868 | 868 |
-- |
| 869 |
-- Name: taxon_match__valid_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
|
|
| 869 |
-- Name: taxon_match__one_selected_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
|
|
| 870 | 870 |
-- |
| 871 | 871 |
|
| 872 |
CREATE INDEX taxon_match__valid_match ON taxon_match USING btree ("Name_submitted") WHERE is_valid_match;
|
|
| 872 |
CREATE UNIQUE INDEX taxon_match__one_selected_match ON taxon_match USING btree (batch, "Name_number") WHERE ("Selected" = 'true'::text);
|
|
| 873 | 873 |
|
| 874 | 874 |
|
| 875 | 875 |
-- |
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 15723 | 15723 |
|
| 15724 | 15724 |
|
| 15725 | 15725 |
-- |
| 15726 |
-- Name: taxon_match_Name_submitted_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
|
|
| 15726 |
-- Name: taxon_best_match__valid_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
|
|
| 15727 | 15727 |
-- |
| 15728 | 15728 |
|
| 15729 |
CREATE INDEX `taxon_match_Name_submitted_idx` ON taxon_match (`Name_submitted`); |
|
| 15730 | 15729 |
|
| 15731 | 15730 |
|
| 15731 |
|
|
| 15732 | 15732 |
-- |
| 15733 |
-- Name: taxon_match__one_selected_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
|
|
| 15733 |
-- Name: taxon_match_Name_submitted_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
|
|
| 15734 | 15734 |
-- |
| 15735 | 15735 |
|
| 15736 |
CREATE INDEX `taxon_match_Name_submitted_idx` ON taxon_match (`Name_submitted`); |
|
| 15736 | 15737 |
|
| 15737 | 15738 |
|
| 15738 |
|
|
| 15739 | 15739 |
-- |
| 15740 |
-- Name: taxon_match__valid_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
|
|
| 15740 |
-- Name: taxon_match__one_selected_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
|
|
| 15741 | 15741 |
-- |
| 15742 | 15742 |
|
| 15743 | 15743 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 19909 | 19909 |
|
| 19910 | 19910 |
|
| 19911 | 19911 |
-- |
| 19912 |
-- Name: taxon_match_Name_submitted_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
|
|
| 19912 |
-- Name: taxon_best_match__valid_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
|
|
| 19913 | 19913 |
-- |
| 19914 | 19914 |
|
| 19915 |
CREATE INDEX "taxon_match_Name_submitted_idx" ON taxon_match USING btree ("Name_submitted");
|
|
| 19915 |
CREATE INDEX taxon_best_match__valid_match ON taxon_match USING btree ("Name_submitted") WHERE (("Selected" = 'true'::text) AND is_valid_match);
|
|
| 19916 | 19916 |
|
| 19917 | 19917 |
|
| 19918 | 19918 |
-- |
| 19919 |
-- Name: taxon_match__one_selected_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
|
|
| 19919 |
-- Name: taxon_match_Name_submitted_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
|
|
| 19920 | 19920 |
-- |
| 19921 | 19921 |
|
| 19922 |
CREATE UNIQUE INDEX taxon_match__one_selected_match ON taxon_match USING btree (batch, "Name_number") WHERE ("Selected" = 'true'::text);
|
|
| 19922 |
CREATE INDEX "taxon_match_Name_submitted_idx" ON taxon_match USING btree ("Name_submitted");
|
|
| 19923 | 19923 |
|
| 19924 | 19924 |
|
| 19925 | 19925 |
-- |
| 19926 |
-- Name: taxon_match__valid_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
|
|
| 19926 |
-- Name: taxon_match__one_selected_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
|
|
| 19927 | 19927 |
-- |
| 19928 | 19928 |
|
| 19929 |
CREATE INDEX taxon_match__valid_match ON taxon_match USING btree ("Name_submitted") WHERE is_valid_match;
|
|
| 19929 |
CREATE UNIQUE INDEX taxon_match__one_selected_match ON taxon_match USING btree (batch, "Name_number") WHERE ("Selected" = 'true'::text);
|
|
| 19930 | 19930 |
|
| 19931 | 19931 |
|
| 19932 | 19932 |
SET search_path = geoscrub, pg_catalog; |
Also available in: Unified diff
inputs/.TNRS/schema.sql: taxon_match: taxon_match__valid_match: replaced with taxon_best_match__valid_match, which also applies taxon_best_match's filters, since taxon_match is now accessed through taxon_best_match