Revision 11813
Added by Aaron Marcuse-Kubitza about 11 years ago
| cvs.~.clean_up.sql | ||
|---|---|---|
| 3 | 3 |
|
| 4 | 4 |
-- Prevent "column name specified more than once" errors when tables are joined |
| 5 | 5 |
ALTER TABLE "observationContributor" RENAME "dba_src_ID" TO "observationContributor--dba_src_ID"; |
| 6 |
ALTER TABLE "commClass" RENAME "dba_src_ID" TO "commClass--dba_src_ID"; |
|
| 6 | 7 |
ALTER TABLE "soilObs" RENAME "dba_src_ID" TO "soilObs_dba_src_ID"; |
| 7 | 8 |
ALTER TABLE "taxonObservation" RENAME "reference_ID" TO "taxonObservation_reference_ID"; |
| 8 | 9 |
ALTER TABLE "taxonObservation" RENAME "accessionCode" TO "taxonObservation_accessionCode"; |
Also available in: Unified diff
inputs/CVS/cvs.~.clean_up.sql: commClass.dba_src_ID: prepend table name to avoid inter-table collisions upon join