Project

General

Profile

« Previous | Next » 

Revision 6791

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
106 106
                                            <catalognumber_dwc>$CatalogNumber</catalognumber_dwc>
107 107
                                            <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
108 108
                                            <institution_id>
109
                                                <sourcename>
110
                                                    <matched_source_id><source><shortname>$InstitutionCode</shortname></source></matched_source_id>
109
                                                <sourcelist>
111 110
                                                    <name>$InstitutionCode</name>
112
                                                </sourcename>
111
                                                    <sourcename>
112
                                                        <matched_source_id><source><shortname>$InstitutionCode</shortname></source></matched_source_id>
113
                                                        <name>$InstitutionCode</name>
114
                                                    </sourcename>
115
                                                </sourcelist>
113 116
                                            </institution_id>
114 117
                                        </specimenreplicate>
115 118
                                    </plantobservation>
......
413 416
        </path>
414 417
    </_setDefault>
415 418
</VegBIEN>
416
Inserted 45 new rows into database
419
Inserted 46 new rows into database

Also available in: Unified diff