Revision 11521
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbank.~.clean_up.sql | ||
|---|---|---|
| 436 | 436 |
ALTER TABLE commconcept RENAME commname TO commconcept__commname; |
| 437 | 437 |
ALTER TABLE taxonobservation RENAME reference_id TO taxonobservation_reference_id; |
| 438 | 438 |
ALTER TABLE taxonobservation RENAME accessioncode TO taxonobservation_accessioncode; |
| 439 |
ALTER TABLE taxoninterpretation RENAME party_id TO taxoninterpretation_party_id; |
|
| 440 | 439 |
ALTER TABLE taxoninterpretation RENAME plantname_id TO taxoninterpretation_plantname_id; |
| 441 | 440 |
ALTER TABLE taxoninterpretation RENAME accessioncode TO taxoninterpretation_accessioncode; |
| 442 | 441 |
ALTER TABLE party RENAME d_obscount TO party_d_obscount; |
Also available in: Unified diff
inputs/VegBank/vegbank.~.clean_up.sql: taxoninterpretation.party_id: don't rename to taxoninterpretation_party_id, so that this can be used directly in taxonobservation_/create.sql with a USING join