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
151 151
                                            </identifyingtaxonomicname>
152 152
                                        </taxonlabel>
153 153
                                    </matched_label_id>
154
                                    <author>$auth</author>
155
                                    <family>$Family</family>
156
                                    <genus>$Genus</genus>
157 154
                                    <identifyingtaxonomicname>
158 155
                                        <_join_words>
159 156
                                            <1>
......
180 177
                                    <parent_id>
181 178
                                        <taxonlabel>
182 179
                                            <rank>$infra_rank_1</rank>
183
                                            <verbatimrank>$infra_rank_1</verbatimrank>
180
                                            <taxonverbatim><verbatimrank>$infra_rank_1</verbatimrank></taxonverbatim>
184 181
                                            <parent_id>
185 182
                                                <taxonlabel>
186 183
                                                    <rank>cultivar</rank>
......
223 220
                                        </taxonlabel>
224 221
                                    </parent_id>
225 222
                                    <rank>$infra_rank_1</rank>
226
                                    <species>$Species</species>
227
                                    <verbatimrank>$infra_rank_1</verbatimrank>
223
                                    <taxonverbatim>
224
                                        <author>$auth</author>
225
                                        <family>$Family</family>
226
                                        <genus>$Genus</genus>
227
                                        <species>$Species</species>
228
                                        <verbatimrank>$infra_rank_1</verbatimrank>
229
                                    </taxonverbatim>
228 230
                                </taxonlabel>
229 231
                            </taxonlabel_id>
230 232
                            <taxonfit>$cfaff</taxonfit>
......
233 235
                            <isoriginal>true</isoriginal>
234 236
                            <taxonlabel_id>
235 237
                                <taxonlabel>
236
                                    <family>$OrigFamily</family>
237
                                    <genus>$OrigGenus</genus>
238 238
                                    <identifyingtaxonomicname>
239 239
                                        <_join_words>
240 240
                                            <1>$OrigFamily</1>
......
301 301
                                            </parent_id>
302 302
                                        </taxonlabel>
303 303
                                    </parent_id>
304
                                    <species>$OrigSpecies</species>
304
                                    <taxonverbatim>
305
                                        <family>$OrigFamily</family>
306
                                        <genus>$OrigGenus</genus>
307
                                        <species>$OrigSpecies</species>
308
                                    </taxonverbatim>
305 309
                                </taxonlabel>
306 310
                            </taxonlabel_id>
307 311
                        </taxondetermination>
......
339 343
        </path>
340 344
    </_simplifyPath>
341 345
</VegBIEN>
342
Inserted 45 new rows into database
346
Inserted 51 new rows into database

Also available in: Unified diff