Revision 13874
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 798 | 798 |
|
| 799 | 799 |
|
| 800 | 800 |
-- |
| 801 |
-- Name: taxon_match__one_selected_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 802 |
-- |
|
| 803 |
|
|
| 804 |
CREATE UNIQUE INDEX taxon_match__one_selected_match ON taxon_match USING btree (batch, "Name_number") WHERE ("Selected" = 'true'::text);
|
|
| 805 |
|
|
| 806 |
|
|
| 807 |
-- |
|
| 801 | 808 |
-- Name: taxon_match__valid_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
| 802 | 809 |
-- |
| 803 | 810 |
|
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 15716 | 15716 |
|
| 15717 | 15717 |
|
| 15718 | 15718 |
-- |
| 15719 |
-- Name: taxon_match__one_selected_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 15720 |
-- |
|
| 15721 |
|
|
| 15722 |
|
|
| 15723 |
|
|
| 15724 |
|
|
| 15725 |
-- |
|
| 15719 | 15726 |
-- Name: taxon_match__valid_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
| 15720 | 15727 |
-- |
| 15721 | 15728 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 19855 | 19855 |
|
| 19856 | 19856 |
|
| 19857 | 19857 |
-- |
| 19858 |
-- Name: taxon_match__one_selected_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 19859 |
-- |
|
| 19860 |
|
|
| 19861 |
CREATE UNIQUE INDEX taxon_match__one_selected_match ON taxon_match USING btree (batch, "Name_number") WHERE ("Selected" = 'true'::text);
|
|
| 19862 |
|
|
| 19863 |
|
|
| 19864 |
-- |
|
| 19858 | 19865 |
-- Name: taxon_match__valid_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
| 19859 | 19866 |
-- |
| 19860 | 19867 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: taxon_match: added taxon_match__one_selected_match unique index