Revision 10686
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/VegBank/vegbank.~.clean_up.sql | ||
|---|---|---|
| 438 | 438 |
ALTER TABLE taxoninterpretation RENAME accessioncode TO taxoninterpretation_accessioncode; |
| 439 | 439 |
ALTER TABLE party RENAME d_obscount TO party_d_obscount; |
| 440 | 440 |
ALTER TABLE plantconcept RENAME reference_id TO plantconcept_reference_id; |
| 441 |
ALTER TABLE plantconcept RENAME plantname TO plantconcept_plantname; |
|
| 441 | 442 |
ALTER TABLE plantconcept RENAME accessioncode TO plantconcept_accessioncode; |
| 443 |
ALTER TABLE plantname RENAME reference_id TO plantname_reference_id; |
|
Also available in: Unified diff
inputs/VegBank/vegbank.~.clean_up.sql: disambiguated plantconcept.plantname, plantname.reference_id to enable joining plantconcept_->plantname