Revision 13589
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 725 | 725 |
|
| 726 | 726 |
|
| 727 | 727 |
-- |
| 728 |
-- Name: tnrs_Name_submitted_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 729 |
-- |
|
| 730 |
|
|
| 731 |
CREATE INDEX "tnrs_Name_submitted_idx" ON tnrs USING btree ("Name_submitted");
|
|
| 732 |
|
|
| 733 |
|
|
| 734 |
-- |
|
| 728 | 735 |
-- Name: tnrs__valid_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
| 729 | 736 |
-- |
| 730 | 737 |
|
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 13587 | 13587 |
|
| 13588 | 13588 |
|
| 13589 | 13589 |
-- |
| 13590 |
-- Name: tnrs_Name_submitted_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 13591 |
-- |
|
| 13592 |
|
|
| 13593 |
CREATE INDEX `tnrs_Name_submitted_idx` ON tnrs (`Name_submitted`); |
|
| 13594 |
|
|
| 13595 |
|
|
| 13596 |
-- |
|
| 13590 | 13597 |
-- Name: tnrs__valid_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
| 13591 | 13598 |
-- |
| 13592 | 13599 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 17623 | 17623 |
|
| 17624 | 17624 |
|
| 17625 | 17625 |
-- |
| 17626 |
-- Name: tnrs_Name_submitted_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
|
| 17627 |
-- |
|
| 17628 |
|
|
| 17629 |
CREATE INDEX "tnrs_Name_submitted_idx" ON tnrs USING btree ("Name_submitted");
|
|
| 17630 |
|
|
| 17631 |
|
|
| 17632 |
-- |
|
| 17626 | 17633 |
-- Name: tnrs__valid_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
| 17627 | 17634 |
-- |
| 17628 | 17635 |
|
Also available in: Unified diff
fix: inputs/.TNRS/schema.sql: added back index on Name_submitted, which is needed for tnrs_input_name to work properly (now that there is no automatic index created by a unique constraint)