Revision 13583
Added by Aaron Marcuse-Kubitza over 10 years ago
| 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 |
-- |
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