Revision 13583
Added by Aaron Marcuse-Kubitza about 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 706 | 706 |
|
| 707 | 707 |
|
| 708 | 708 |
-- |
| 709 |
-- Name: tnrs_Name_submitted_key; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace: |
|
| 709 |
-- Name: tnrs_Name_submitted_Name_matched_key; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace:
|
|
| 710 | 710 |
-- |
| 711 | 711 |
|
| 712 | 712 |
ALTER TABLE ONLY tnrs |
| 713 |
ADD CONSTRAINT "tnrs_Name_submitted_key" UNIQUE ("Name_submitted");
|
|
| 713 |
ADD CONSTRAINT "tnrs_Name_submitted_Name_matched_key" UNIQUE ("Name_submitted", "Name_matched");
|
|
| 714 | 714 |
|
| 715 | 715 |
|
| 716 | 716 |
-- |
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 13552 | 13552 |
|
| 13553 | 13553 |
|
| 13554 | 13554 |
-- |
| 13555 |
-- Name: tnrs_Name_submitted_key; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace: |
|
| 13555 |
-- Name: tnrs_Name_submitted_Name_matched_key; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace:
|
|
| 13556 | 13556 |
-- |
| 13557 | 13557 |
|
| 13558 | 13558 |
ALTER TABLE tnrs |
| 13559 |
ADD CONSTRAINT `tnrs_Name_submitted_key` UNIQUE (`Name_submitted`);
|
|
| 13559 |
ADD CONSTRAINT `tnrs_Name_submitted_Name_matched_key` UNIQUE (`Name_submitted`, `Name_matched`);
|
|
| 13560 | 13560 |
|
| 13561 | 13561 |
|
| 13562 | 13562 |
-- |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 17589 | 17589 |
|
| 17590 | 17590 |
|
| 17591 | 17591 |
-- |
| 17592 |
-- Name: tnrs_Name_submitted_key; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace: |
|
| 17592 |
-- Name: tnrs_Name_submitted_Name_matched_key; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace:
|
|
| 17593 | 17593 |
-- |
| 17594 | 17594 |
|
| 17595 | 17595 |
ALTER TABLE ONLY tnrs |
| 17596 |
ADD CONSTRAINT "tnrs_Name_submitted_key" UNIQUE ("Name_submitted");
|
|
| 17596 |
ADD CONSTRAINT "tnrs_Name_submitted_Name_matched_key" UNIQUE ("Name_submitted", "Name_matched");
|
|
| 17597 | 17597 |
|
| 17598 | 17598 |
|
| 17599 | 17599 |
-- |
Also available in: Unified diff
inputs/.TNRS/schema.sql: unique constraint on Name_submitted: added Name_matched to allow multiple matches per name, as is needed to implement #917