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
137 137
                                            </identifyingtaxonomicname>
138 138
                                        </taxonlabel>
139 139
                                    </matched_label_id>
140
                                    <author>$ScientificNameAuthor</author>
141
                                    <binomial>$ScientificName</binomial>
142 140
                                    <creationdate>
143 141
                                        <_date>
144 142
                                            <day>
......
170 168
                                            <path><party><fullname>$IdentifiedBy</fullname></party></path>
171 169
                                        </_simplifyPath>
172 170
                                    </creator_id>
173
                                    <family>$Family</family>
174
                                    <genus>$Genus</genus>
175 171
                                    <identifyingtaxonomicname>
176 172
                                        <_join_words>
177 173
                                            <1>
......
257 253
                                            </parent_id>
258 254
                                        </taxonlabel>
259 255
                                    </parent_id>
260
                                    <species>$Species</species>
256
                                    <taxonverbatim>
257
                                        <author>$ScientificNameAuthor</author>
258
                                        <binomial>$ScientificName</binomial>
259
                                        <family>$Family</family>
260
                                        <genus>$Genus</genus>
261
                                        <species>$Species</species>
262
                                    </taxonverbatim>
261 263
                                </taxonlabel>
262 264
                            </taxonlabel_id>
263 265
                            <determinationdate>
......
336 338
        </path>
337 339
    </_simplifyPath>
338 340
</VegBIEN>
339
Inserted 35 new rows into database
341
Inserted 37 new rows into database

Also available in: Unified diff