Project

General

Profile

« Previous | Next » 

Revision 6791

Added by Aaron Marcuse-Kubitza almost 12 years ago

schemas/vegbien.sql: Allow multiple institutionCodes for each specimenreplicate by linking new sourcelist table many-to-many to source via sourcename (which is now a linking table)

View differences:

test.xml.ref
30 30 
                                            <catalognumber_dwc>$CatalogNO</catalognumber_dwc>
31 31 
                                            <collectioncode_dwc>$CollectionCD</collectioncode_dwc>
32 32 
                                            <institution_id>
33 
                                                <sourcename>
34 
                                                    <matched_source_id><source><shortname>$InstitutionCD</shortname></source></matched_source_id>
33 
                                                <sourcelist>
35 34 
                                                    <name>$InstitutionCD</name>
36 
                                                </sourcename>
35 
                                                    <sourcename>
36 
                                                        <matched_source_id><source><shortname>$InstitutionCD</shortname></source></matched_source_id>
37 
                                                        <name>$InstitutionCD</name>
38 
                                                    </sourcename>
39 
                                                </sourcelist>
37 40 
                                            </institution_id>
38 41 
                                        </specimenreplicate>
39 42 
                                    </plantobservation>
......
328 331 
        </path>
329 332 
    </_setDefault>
330 333 
</VegBIEN>
331 
Inserted 47 new rows into database
334 
Inserted 48 new rows into database

Also available in: Unified diff