Revision 13581
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.sql | ||
|---|---|---|
| 17594 | 17594 |
-- |
| 17595 | 17595 |
|
| 17596 | 17596 |
ALTER TABLE ONLY tnrs |
| 17597 |
ADD CONSTRAINT tnrs_pkey PRIMARY KEY (batch, "Name_number");
|
|
| 17597 |
ADD CONSTRAINT tnrs_pkey PRIMARY KEY (batch, match_num);
|
|
| 17598 | 17598 |
|
| 17599 | 17599 |
|
| 17600 | 17600 |
SET search_path = geoscrub, pg_catalog; |
Also available in: Unified diff
inputs/.TNRS/schema.sql: tnrs: pkey: use match_num instead of Name_number to allow multiple matches per name, as is needed to implement #917