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
115 115
                                            </identifyingtaxonomicname>
116 116
                                        </taxonlabel>
117 117
                                    </matched_label_id>
118
                                    <author>$authors</author>
119
                                    <binomial>$SciName</binomial>
120
                                    <family>$family</family>
121
                                    <genus>$genus</genus>
122 118
                                    <identifyingtaxonomicname>
123 119
                                        <_join_words>
124 120
                                            <1>
......
160 156
                                                    <2>$infrarank</2>
161 157
                                                </_alt>
162 158
                                            </rank>
163
                                            <verbatimrank>
164
                                                <_alt>
165
                                                    <1>$usdaRank</1>
166
                                                    <2>$infrarank</2>
167
                                                </_alt>
168
                                            </verbatimrank>
159
                                            <taxonverbatim>
160
                                                <verbatimrank>
161
                                                    <_alt>
162
                                                        <1>$usdaRank</1>
163
                                                        <2>$infrarank</2>
164
                                                    </_alt>
165
                                                </verbatimrank>
166
                                            </taxonverbatim>
169 167
                                            <parent_id>
170 168
                                                <taxonlabel>
171 169
                                                    <rank>cultivar</rank>
......
213 211
                                            <2>$infrarank</2>
214 212
                                        </_alt>
215 213
                                    </rank>
216
                                    <species>$species</species>
217
                                    <verbatimrank>
218
                                        <_alt>
219
                                            <1>$usdaRank</1>
220
                                            <2>$infrarank</2>
221
                                        </_alt>
222
                                    </verbatimrank>
214
                                    <taxonverbatim>
215
                                        <author>$authors</author>
216
                                        <binomial>$SciName</binomial>
217
                                        <family>$family</family>
218
                                        <genus>$genus</genus>
219
                                        <species>$species</species>
220
                                        <verbatimrank>
221
                                            <_alt>
222
                                                <1>$usdaRank</1>
223
                                                <2>$infrarank</2>
224
                                            </_alt>
225
                                        </verbatimrank>
226
                                    </taxonverbatim>
223 227
                                </taxonlabel>
224 228
                            </taxonlabel_id>
225 229
                        </taxondetermination>
......
257 261
        </path>
258 262
    </_simplifyPath>
259 263
</VegBIEN>
260
Inserted 23 new rows into database
264
Inserted 25 new rows into database

Also available in: Unified diff