Revision 6791
Added by Aaron Marcuse-Kubitza almost 12 years ago
| test.xml.ref | ||
|---|---|---|
| 162 | 162 |
</_join> |
| 163 | 163 |
</collectioncode_dwc> |
| 164 | 164 |
<institution_id> |
| 165 |
<sourcename> |
|
| 166 |
<matched_source_id> |
|
| 167 |
<source> |
|
| 168 |
<shortname> |
|
| 169 |
<_alt> |
|
| 170 |
<0>$conceptual_darwin_2003_1_0_InstitutionCode</0> |
|
| 171 |
<1>$dwc_dwcore_InstitutionCode</1> |
|
| 172 |
<2>$dwc_terms_institutionCode</2> |
|
| 173 |
</_alt> |
|
| 174 |
</shortname> |
|
| 175 |
</source> |
|
| 176 |
</matched_source_id> |
|
| 165 |
<sourcelist> |
|
| 177 | 166 |
<name> |
| 178 | 167 |
<_alt> |
| 179 | 168 |
<0>$conceptual_darwin_2003_1_0_InstitutionCode</0> |
| ... | ... | |
| 181 | 170 |
<2>$dwc_terms_institutionCode</2> |
| 182 | 171 |
</_alt> |
| 183 | 172 |
</name> |
| 184 |
</sourcename> |
|
| 173 |
<sourcename> |
|
| 174 |
<matched_source_id> |
|
| 175 |
<source> |
|
| 176 |
<shortname> |
|
| 177 |
<_alt> |
|
| 178 |
<0>$conceptual_darwin_2003_1_0_InstitutionCode</0> |
|
| 179 |
<1>$dwc_dwcore_InstitutionCode</1> |
|
| 180 |
<2>$dwc_terms_institutionCode</2> |
|
| 181 |
</_alt> |
|
| 182 |
</shortname> |
|
| 183 |
</source> |
|
| 184 |
</matched_source_id> |
|
| 185 |
<name> |
|
| 186 |
<_alt> |
|
| 187 |
<0>$conceptual_darwin_2003_1_0_InstitutionCode</0> |
|
| 188 |
<1>$dwc_dwcore_InstitutionCode</1> |
|
| 189 |
<2>$dwc_terms_institutionCode</2> |
|
| 190 |
</_alt> |
|
| 191 |
</name> |
|
| 192 |
</sourcename> |
|
| 193 |
</sourcelist> |
|
| 185 | 194 |
</institution_id> |
| 186 | 195 |
<sourceaccessioncode>$dwc_dwcore_GlobalUniqueIdentifier</sourceaccessioncode> |
| 187 | 196 |
</specimenreplicate> |
| ... | ... | |
| 750 | 759 |
</path> |
| 751 | 760 |
</_setDefault> |
| 752 | 761 |
</VegBIEN> |
| 753 |
Inserted 47 new rows into database |
|
| 762 |
Inserted 48 new rows into database |
|
Also available in: Unified diff
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)