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
77 77
                                            </identifyingtaxonomicname>
78 78
                                        </taxonlabel>
79 79
                                    </matched_label_id>
80
                                    <author>$AuthorOfScientificName</author>
81
                                    <binomial>$ScientificName</binomial>
82 80
                                    <creator_id>
83 81
                                        <_simplifyPath>
84 82
                                            <next>creator_id</next>
85 83
                                            <path><party><fullname>$IdentifiedBy</fullname></party></path>
86 84
                                        </_simplifyPath>
87 85
                                    </creator_id>
88
                                    <family>$Family</family>
89
                                    <genus>$Genus</genus>
90 86
                                    <identifyingtaxonomicname>
91 87
                                        <_join_words>
92 88
                                            <1>
......
148 144
                                            <taxonepithet>$InfraspecificEpithet</taxonepithet>
149 145
                                        </taxonlabel>
150 146
                                    </parent_id>
151
                                    <species>$SpecificEpithet</species>
147
                                    <taxonverbatim>
148
                                        <author>$AuthorOfScientificName</author>
149
                                        <binomial>$ScientificName</binomial>
150
                                        <family>$Family</family>
151
                                        <genus>$Genus</genus>
152
                                        <species>$SpecificEpithet</species>
153
                                    </taxonverbatim>
152 154
                                </taxonlabel>
153 155
                            </taxonlabel_id>
154 156
                        </taxondetermination>
......
156 158
                            <isoriginal>true</isoriginal>
157 159
                            <taxonlabel_id>
158 160
                                <taxonlabel>
159
                                    <binomial>$ScientificNameOriginal</binomial>
160
                                    <family>$GBIFFamilyOriginal</family>
161
                                    <genus>$GBIFGenusOriginal</genus>
162 161
                                    <identifyingtaxonomicname>
163 162
                                        <_alt>
164 163
                                            <1>$ScientificNameOriginal</1>
......
232 231
                                            </parent_id>
233 232
                                        </taxonlabel>
234 233
                                    </parent_id>
234
                                    <taxonverbatim>
235
                                        <binomial>$ScientificNameOriginal</binomial>
236
                                        <family>$GBIFFamilyOriginal</family>
237
                                        <genus>$GBIFGenusOriginal</genus>
238
                                    </taxonverbatim>
235 239
                                </taxonlabel>
236 240
                            </taxonlabel_id>
237 241
                        </taxondetermination>
......
252 256
        </path>
253 257
    </_simplifyPath>
254 258
</VegBIEN>
255
Inserted 39 new rows into database
259
Inserted 43 new rows into database

Also available in: Unified diff