Project

General

Profile

« Previous | Next » 

Revision 11865

bugfix: inputs/CTFS/import_order.txt: added *.src so that these would be installed under new-style import as well. this means that their columns will now be automapped, requiring the names to be renamed to VegCore names in */create.sql. note that VegCore taxonOccurrenceID has been renamed to taxonObservationID since this was last run.

View differences:

create.sql
1 1
SELECT *
2 2
FROM "StemObservation.src"
3
LEFT JOIN "Stem.src" USING ("TreeID", "StemID")
4
LEFT JOIN "Organism.src" USING ("TreeID")
5
LEFT JOIN "InfraspecificEpithet.src" USING ("SpeciesID", "SubSpeciesID")
6
LEFT JOIN "SpecificEpithet.src" USING ("SpeciesID")
7
LEFT JOIN "Genus.src" USING ("GenusID")
8
LEFT JOIN "Family.src" USING ("FamilyID")
3
LEFT JOIN "Stem.src" USING ("*TreeID", "authorStemCode")
4
LEFT JOIN "Organism.src" USING ("*TreeID")
5
LEFT JOIN "InfraspecificEpithet.src" USING ("*SpeciesID", "*SubSpeciesID")
6
LEFT JOIN "SpecificEpithet.src" USING ("*SpeciesID")
7
LEFT JOIN "Genus.src" USING ("*GenusID")
8
LEFT JOIN "Family.src" USING ("*FamilyID")

Also available in: Unified diff