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