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