Project

General

Profile

« Previous | Next » 

Revision 5655

schemas/vegbien.sql: taxonlabel: Moved non-scoping fields to new taxonverbatim subclass table, which contains the component parts of the taxonlabel

View differences:

test.xml.ref
131 131
                                            </identifyingtaxonomicname>
132 132
                                        </taxonlabel>
133 133
                                    </matched_label_id>
134
                                    <author>$scientificNameAuthorship</author>
135
                                    <binomial>$scientificName</binomial>
136 134
                                    <creationdate><_date><date><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></date></_date></creationdate>
137 135
                                    <creator_id>
138 136
                                        <_simplifyPath>
......
140 138
                                            <path><party><fullname>$identifiedBy</fullname></party></path>
141 139
                                        </_simplifyPath>
142 140
                                    </creator_id>
143
                                    <family>$family</family>
144
                                    <genus>$genus</genus>
145 141
                                    <identifyingtaxonomicname>
146 142
                                        <_join_words>
147 143
                                            <1>
......
173 169
                                    <parent_id>
174 170
                                        <taxonlabel>
175 171
                                            <rank>$taxonRank</rank>
176
                                            <verbatimrank>$taxonRank</verbatimrank>
172
                                            <taxonverbatim><verbatimrank>$taxonRank</verbatimrank></taxonverbatim>
177 173
                                            <parent_id>
178 174
                                                <taxonlabel>
179 175
                                                    <rank>cultivar</rank>
......
240 236
                                        </taxonlabel>
241 237
                                    </parent_id>
242 238
                                    <rank>$taxonRank</rank>
243
                                    <species>$specificEpithet</species>
244
                                    <verbatimrank>$taxonRank</verbatimrank>
239
                                    <taxonverbatim>
240
                                        <author>$scientificNameAuthorship</author>
241
                                        <binomial>$scientificName</binomial>
242
                                        <family>$family</family>
243
                                        <genus>$genus</genus>
244
                                        <species>$specificEpithet</species>
245
                                        <verbatimrank>$taxonRank</verbatimrank>
246
                                    </taxonverbatim>
245 247
                                </taxonlabel>
246 248
                            </taxonlabel_id>
247 249
                            <determinationdate><_date><date><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></date></_date></determinationdate>
......
276 278
        </path>
277 279
    </_simplifyPath>
278 280
</VegBIEN>
279
Inserted 34 new rows into database
281
Inserted 36 new rows into database

Also available in: Unified diff