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
180 180
                                            </identifyingtaxonomicname>
181 181
                                        </taxonlabel>
182 182
                                    </matched_label_id>
183
                                    <author>$specific_authority</author>
184
                                    <family>$family</family>
185
                                    <genus>$genus</genus>
186 183
                                    <identifyingtaxonomicname>
187 184
                                        <_join_words>
188 185
                                            <1>
......
209 206
                                    <parent_id>
210 207
                                        <taxonlabel>
211 208
                                            <rank>$infra_rank_1</rank>
212
                                            <verbatimrank>$infra_rank_1</verbatimrank>
209
                                            <taxonverbatim><verbatimrank>$infra_rank_1</verbatimrank></taxonverbatim>
213 210
                                            <parent_id>
214 211
                                                <taxonlabel>
215 212
                                                    <rank>cultivar</rank>
......
252 249
                                        </taxonlabel>
253 250
                                    </parent_id>
254 251
                                    <rank>$infra_rank_1</rank>
255
                                    <species>$specific_epithet</species>
256
                                    <verbatimrank>$infra_rank_1</verbatimrank>
252
                                    <taxonverbatim>
253
                                        <author>$specific_authority</author>
254
                                        <family>$family</family>
255
                                        <genus>$genus</genus>
256
                                        <species>$specific_epithet</species>
257
                                        <verbatimrank>$infra_rank_1</verbatimrank>
258
                                    </taxonverbatim>
257 259
                                </taxonlabel>
258 260
                            </taxonlabel_id>
259 261
                            <taxonfit>$cf_aff</taxonfit>
......
262 264
                            <isoriginal>true</isoriginal>
263 265
                            <taxonlabel_id>
264 266
                                <taxonlabel>
265
                                    <family>$orig_family</family>
266 267
                                    <identifyingtaxonomicname>
267 268
                                        <_join_words>
268 269
                                            <1>$orig_family</1>
......
326 327
                                            </parent_id>
327 328
                                        </taxonlabel>
328 329
                                    </parent_id>
329
                                    <species>$orig_species</species>
330
                                    <taxonverbatim>
331
                                        <family>$orig_family</family>
332
                                        <species>$orig_species</species>
333
                                    </taxonverbatim>
330 334
                                </taxonlabel>
331 335
                            </taxonlabel_id>
332 336
                        </taxondetermination>
......
364 368
        </path>
365 369
    </_simplifyPath>
366 370
</VegBIEN>
367
Inserted 48 new rows into database
371
Inserted 52 new rows into database

Also available in: Unified diff