Revision 6172
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbank.~.clean_up.sql | ||
|---|---|---|
| 433 | 433 |
-- Prevent "column name specified more than once" errors when tables are joined |
| 434 | 434 |
ALTER TABLE taxonobservation RENAME reference_id TO taxonobservation_reference_id; |
| 435 | 435 |
ALTER TABLE taxonobservation RENAME accessioncode TO taxonobservation_accessioncode; |
| 436 |
ALTER TABLE taxoninterpretation RENAME party_id TO taxoninterpretation_party_id; |
|
| 436 | 437 |
ALTER TABLE taxoninterpretation RENAME plantname_id TO taxoninterpretation_plantname_id; |
| 437 | 438 |
ALTER TABLE taxoninterpretation RENAME accessioncode TO taxoninterpretation_accessioncode; |
| 438 | 439 |
ALTER TABLE plantconcept RENAME reference_id TO plantconcept_reference_id; |
Also available in: Unified diff
inputs/VegBank/vegbank.~.clean_up.sql: Rename taxoninterpretation.party_id to taxoninterpretation_party_id to make it globally unique when joining taxoninterpretation to other tables