Revision 13581
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 711 | 711 |
-- |
| 712 | 712 |
|
| 713 | 713 |
ALTER TABLE ONLY tnrs |
| 714 |
ADD CONSTRAINT tnrs_pkey PRIMARY KEY (batch, "Name_number");
|
|
| 714 |
ADD CONSTRAINT tnrs_pkey PRIMARY KEY (batch, match_num);
|
|
| 715 | 715 |
|
| 716 | 716 |
|
| 717 | 717 |
-- |
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 13564 | 13564 |
-- |
| 13565 | 13565 |
|
| 13566 | 13566 |
ALTER TABLE tnrs |
| 13567 |
ADD CONSTRAINT tnrs_pkey PRIMARY KEY (batch, `Name_number`);
|
|
| 13567 |
ADD CONSTRAINT tnrs_pkey PRIMARY KEY (batch, match_num);
|
|
| 13568 | 13568 |
|
| 13569 | 13569 |
|
| 13570 | 13570 |
USE geoscrub; |
| trunk/schemas/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