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
                                    <binomial>$ScientificName</binomial>
141 140
                                    <creationdate>
142 141
                                        <_date>
143 142
                                            <day>
......
169 168
                                            <path><party><fullname>$IdentifiedBy</fullname></party></path>
170 169
                                        </_simplifyPath>
171 170
                                    </creator_id>
172
                                    <family>$Family</family>
173
                                    <genus>$Genus</genus>
174 171
                                    <identifyingtaxonomicname>
175 172
                                        <_alt>
176 173
                                            <1>$ScientificNameAuthor</1>
......
256 253
                                            </parent_id>
257 254
                                        </taxonlabel>
258 255
                                    </parent_id>
259
                                    <species>$Species</species>
260
                                    <taxonomicname>$ScientificNameAuthor</taxonomicname>
256
                                    <taxonverbatim>
257
                                        <binomial>$ScientificName</binomial>
258
                                        <family>$Family</family>
259
                                        <genus>$Genus</genus>
260
                                        <species>$Species</species>
261
                                        <taxonomicname>$ScientificNameAuthor</taxonomicname>
262
                                    </taxonverbatim>
261 263
                                </taxonlabel>
262 264
                            </taxonlabel_id>
263 265
                            <determinationdate>
......
312 314
        </path>
313 315
    </_simplifyPath>
314 316
</VegBIEN>
315
Inserted 39 new rows into database
317
Inserted 41 new rows into database

Also available in: Unified diff