Revision 6173
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/VegBank/vegbank.~.clean_up.sql | ||
|---|---|---|
| 436 | 436 |
ALTER TABLE taxoninterpretation RENAME party_id TO taxoninterpretation_party_id; |
| 437 | 437 |
ALTER TABLE taxoninterpretation RENAME plantname_id TO taxoninterpretation_plantname_id; |
| 438 | 438 |
ALTER TABLE taxoninterpretation RENAME accessioncode TO taxoninterpretation_accessioncode; |
| 439 |
ALTER TABLE party RENAME d_obscount TO party_d_obscount; |
|
| 439 | 440 |
ALTER TABLE plantconcept RENAME reference_id TO plantconcept_reference_id; |
| 440 | 441 |
ALTER TABLE plantconcept RENAME accessioncode TO plantconcept_accessioncode; |
Also available in: Unified diff
inputs/VegBank/vegbank.~.clean_up.sql: Rename party.d_obscount to party_d_obscount to make it globally unique when joining with other tables