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
107 107
                                            </identifyingtaxonomicname>
108 108
                                        </taxonlabel>
109 109
                                    </matched_label_id>
110
                                    <author>$scientificNameAuthorship</author>
111 110
                                    <creationdate><_date><date><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></date></_date></creationdate>
112 111
                                    <creator_id>
113 112
                                        <_simplifyPath>
......
115 114
                                            <path><party><fullname>$identifiedBy</fullname></party></path>
116 115
                                        </_simplifyPath>
117 116
                                    </creator_id>
118
                                    <family>$family</family>
119
                                    <genus>$genus</genus>
120 117
                                    <identifyingtaxonomicname>
121 118
                                        <_alt>
122 119
                                            <1>$scientificName</1>
......
148 145
                                    <parent_id>
149 146
                                        <taxonlabel>
150 147
                                            <rank>$taxonRank</rank>
151
                                            <verbatimrank>$taxonRank</verbatimrank>
148
                                            <taxonverbatim><verbatimrank>$taxonRank</verbatimrank></taxonverbatim>
152 149
                                            <parent_id>
153 150
                                                <taxonlabel>
154 151
                                                    <rank>cultivar</rank>
......
215 212
                                        </taxonlabel>
216 213
                                    </parent_id>
217 214
                                    <rank>$taxonRank</rank>
218
                                    <species>$specificEpithet</species>
219
                                    <taxonomicname>$scientificName</taxonomicname>
220
                                    <verbatimrank>$taxonRank</verbatimrank>
215
                                    <taxonverbatim>
216
                                        <author>$scientificNameAuthorship</author>
217
                                        <family>$family</family>
218
                                        <genus>$genus</genus>
219
                                        <species>$specificEpithet</species>
220
                                        <taxonomicname>$scientificName</taxonomicname>
221
                                        <verbatimrank>$taxonRank</verbatimrank>
222
                                    </taxonverbatim>
221 223
                                </taxonlabel>
222 224
                            </taxonlabel_id>
223 225
                            <determinationdate><_date><date><_dateRangeStart><value>$dateIdentified</value></_dateRangeStart></date></_date></determinationdate>
......
251 253
        </path>
252 254
    </_simplifyPath>
253 255
</VegBIEN>
254
Inserted 35 new rows into database
256
Inserted 39 new rows into database

Also available in: Unified diff