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
23 23
                                                </_join>
24 24
                                            </collectioncode_dwc>
25 25
                                            <institution_id>
26
                                                <sourcename>
27
                                                    <matched_source_id><source><shortname>$institutionCode</shortname></source></matched_source_id>
26
                                                <sourcelist>
28 27
                                                    <name>$institutionCode</name>
29
                                                </sourcename>
28
                                                    <sourcename>
29
                                                        <matched_source_id><source><shortname>$institutionCode</shortname></source></matched_source_id>
30
                                                        <name>$institutionCode</name>
31
                                                    </sourcename>
32
                                                </sourcelist>
30 33
                                            </institution_id>
31 34
                                            <sourceaccessioncode>$id</sourceaccessioncode>
32 35
                                        </specimenreplicate>
......
129 132
        </path>
130 133
    </_setDefault>
131 134
</VegBIEN>
132
Inserted 26 new rows into database
135
Inserted 27 new rows into database

Also available in: Unified diff