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
64 64
                                            </identifyingtaxonomicname>
65 65
                                        </taxonlabel>
66 66
                                    </matched_label_id>
67
                                    <author>$SpeciesAuthority</author>
68
                                    <family>$Family</family>
69
                                    <genus>$Genus</genus>
70 67
                                    <identifyingtaxonomicname>
71 68
                                        <_join_words>
72 69
                                            <1>
......
123 120
                                            </parent_id>
124 121
                                        </taxonlabel>
125 122
                                    </parent_id>
126
                                    <species>$SpeciesName</species>
123
                                    <taxonverbatim>
124
                                        <author>$SpeciesAuthority</author>
125
                                        <family>$Family</family>
126
                                        <genus>$Genus</genus>
127
                                        <species>$SpeciesName</species>
128
                                    </taxonverbatim>
127 129
                                </taxonlabel>
128 130
                            </taxonlabel_id>
129 131
                        </taxondetermination>
......
133 135
        </path>
134 136
    </_simplifyPath>
135 137
</VegBIEN>
136
Inserted 19 new rows into database
138
Inserted 20 new rows into database

Also available in: Unified diff