Revision 13587
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 710 | 710 |
|
| 711 | 711 |
|
| 712 | 712 |
-- |
| 713 |
-- Name: tnrs_Name_submitted_Name_matched_key; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace: |
|
| 714 |
-- |
|
| 715 |
|
|
| 716 |
ALTER TABLE ONLY tnrs |
|
| 717 |
ADD CONSTRAINT "tnrs_Name_submitted_Name_matched_key" UNIQUE ("Name_submitted", "Name_matched");
|
|
| 718 |
|
|
| 719 |
|
|
| 720 |
-- |
|
| 721 | 713 |
-- Name: tnrs_pkey; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace: |
| 722 | 714 |
-- |
| 723 | 715 |
|
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 13552 | 13552 |
|
| 13553 | 13553 |
|
| 13554 | 13554 |
-- |
| 13555 |
-- Name: tnrs_Name_submitted_Name_matched_key; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace: |
|
| 13556 |
-- |
|
| 13557 |
|
|
| 13558 |
ALTER TABLE tnrs |
|
| 13559 |
ADD CONSTRAINT `tnrs_Name_submitted_Name_matched_key` UNIQUE (`Name_submitted`, `Name_matched`); |
|
| 13560 |
|
|
| 13561 |
|
|
| 13562 |
-- |
|
| 13563 | 13555 |
-- Name: tnrs_pkey; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace: |
| 13564 | 13556 |
-- |
| 13565 | 13557 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 17593 | 17593 |
|
| 17594 | 17594 |
|
| 17595 | 17595 |
-- |
| 17596 |
-- Name: tnrs_Name_submitted_Name_matched_key; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace: |
|
| 17597 |
-- |
|
| 17598 |
|
|
| 17599 |
ALTER TABLE ONLY tnrs |
|
| 17600 |
ADD CONSTRAINT "tnrs_Name_submitted_Name_matched_key" UNIQUE ("Name_submitted", "Name_matched");
|
|
| 17601 |
|
|
| 17602 |
|
|
| 17603 |
-- |
|
| 17604 | 17596 |
-- Name: tnrs_pkey; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace: |
| 17605 | 17597 |
-- |
| 17606 | 17598 |
|
Also available in: Unified diff
fix: inputs/.TNRS/schema.sql: tnrs: removed unique constraint on Name_submitted, Name_matched because there can be more than one match with the same Name_matched (but different accepted names, etc.)