Revision 11956
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbank.~.clean_up.sql | ||
|---|---|---|
| 439 | 439 |
ALTER TABLE plantconcept RENAME plantname TO plantconcept_plantname; |
| 440 | 440 |
ALTER TABLE plantconcept RENAME accessioncode TO plantconcept_accessioncode; |
| 441 | 441 |
ALTER TABLE plantname RENAME reference_id TO plantname_reference_id; |
| 442 |
ALTER TABLE projectcontributor RENAME surname TO projectcontributor_surname; |
|
| 442 | 443 |
ALTER TABLE taxoninterpretation RENAME plantname_id TO taxoninterpretation_plantname_id; |
| 443 | 444 |
ALTER TABLE taxoninterpretation RENAME accessioncode TO taxoninterpretation_accessioncode; |
| 444 | 445 |
ALTER TABLE taxonobservation RENAME reference_id TO taxonobservation_reference_id; |
Also available in: Unified diff
inputs/VegBank/vegbank.~.clean_up.sql: projectcontributor.surname: prepend table name to avoid join collisions