Project

General

Profile

« Previous | Next » 

Revision 11808

Added by Aaron Marcuse-Kubitza almost 11 years ago

inputs/CVS/cvs.~.clean_up.sql: don't rename taxonInterpretation.PARTY_ID, so that this can be USING-joined to party in inputs/CVS/taxonObservation_/create.sql

View differences:

inputs/CVS/cvs.~.clean_up.sql
15 15 
ALTER TABLE "stemCount" RENAME "entry_treeLineID" TO "stemCount_entry_treeLineID";
16 16 
ALTER TABLE "stemCount" RENAME "entry_sortOrder" TO "stemCount_entry_sortOrder";
17 17 
ALTER TABLE "stemLocation" RENAME "entry_sortOrder" TO "stemLocation_entry_sortOrder";
18 
ALTER TABLE "taxonInterpretation" RENAME "PARTY_ID" TO "taxonInterpretation_PARTY_ID";
19 18 
ALTER TABLE "taxonInterpretation" RENAME "PLANTNAME_ID" TO "taxonInterpretation_PLANTNAME_ID";
20 19 
ALTER TABLE "taxonInterpretation" RENAME "dba_src_ID" TO "taxonInterpretation_dba_src_ID";
21 20 
ALTER TABLE "taxonInterpretation" RENAME "accessionCode" TO "taxonInterpretation_accessionCode";
inputs/CVS/taxonObservation_/map.csv
25 25 
stemLocation_ID,stemID,,
26 26 
interpretationDate,dateIdentified,,
27 27 
taxonInterpretation_PLANTNAME_ID,*taxonObservation_--taxonInterpretation_PLANTNAME_ID,,
28 
taxonInterpretation_PARTY_ID,*taxonObservation_--taxonInterpretation_PARTY_ID,,
28 
PARTY_ID,*taxonObservation_--taxonInterpretation_PARTY_ID,,
29 29 
ROLE_ID,*taxonObservation_--ROLE_ID,,
30 30 
interpretationType,identificationType,,
31 31 
reference_ID,*taxonObservation_--reference_ID,,

Also available in: Unified diff