Revision 11811
Added by Aaron Marcuse-Kubitza almost 11 years ago
| inputs/CVS/cvs.~.clean_up.sql | ||
|---|---|---|
| 2 | 2 |
ALTER TABLE "stemCount" RENAME "TAXONIMPORTANCE_ID" TO "taxonImportance_ID"; |
| 3 | 3 |
|
| 4 | 4 |
-- Prevent "column name specified more than once" errors when tables are joined |
| 5 |
ALTER TABLE "observationContributor" RENAME "dba_src_ID" TO "observationContributor--dba_src_ID"; |
|
| 5 | 6 |
ALTER TABLE "soilObs" RENAME "dba_src_ID" TO "soilObs_dba_src_ID"; |
| 6 | 7 |
ALTER TABLE "taxonObservation" RENAME "reference_ID" TO "taxonObservation_reference_ID"; |
| 7 | 8 |
ALTER TABLE "taxonObservation" RENAME "accessionCode" TO "taxonObservation_accessionCode"; |
Also available in: Unified diff
inputs/CVS/cvs.~.clean_up.sql: observationContributor.dba_src_ID: prepended table name to avoid collision when left-joining to party