Revision 4535
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/VegBank/vegbank.~.clean_up.sql | ||
|---|---|---|
| 68 | 68 |
ALTER TABLE taxonobservation RENAME accessioncode TO taxonobservation_accessioncode; |
| 69 | 69 |
ALTER TABLE taxoninterpretation RENAME plantname_id TO taxoninterpretation_plantname_id; |
| 70 | 70 |
ALTER TABLE taxoninterpretation RENAME accessioncode TO taxoninterpretation_accessioncode; |
| 71 |
ALTER TABLE plantconcept_ RENAME reference_id TO plantconcept__reference_id; |
|
| 72 |
ALTER TABLE plantconcept_ RENAME accessioncode TO plantconcept__accessioncode; |
|
| 71 |
ALTER TABLE plantconcept RENAME reference_id TO plantconcept_reference_id; |
|
| 72 |
ALTER TABLE plantconcept RENAME accessioncode TO plantconcept_accessioncode; |
|
Also available in: Unified diff
inputs/VegBank/vegbank.~.clean_up.sql: Fixed bug where the original plantconcept table's columns needed to be renamed, rather than the derived table plantconcept_'s. Note that this script runs before any derived tables are created, so this would be the wrong place for these statements if the derived table's columns did need to be renamed.