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
109 109
                                            </identifyingtaxonomicname>
110 110
                                        </taxonlabel>
111 111
                                    </matched_label_id>
112
                                    <author>$ScientificNameAuthor</author>
113
                                    <binomial>$ScientificName</binomial>
114 112
                                    <creator_id>
115 113
                                        <_simplifyPath>
116 114
                                            <next>creator_id</next>
117 115
                                            <path><party><fullname>$IdentifiedBy</fullname></party></path>
118 116
                                        </_simplifyPath>
119 117
                                    </creator_id>
120
                                    <family>$family</family>
121
                                    <genus>$genus</genus>
122 118
                                    <identifyingtaxonomicname>
123 119
                                        <_join_words>
124 120
                                            <1>
......
201 197
                                            </parent_id>
202 198
                                        </taxonlabel>
203 199
                                    </parent_id>
204
                                    <species>$species</species>
200
                                    <taxonverbatim>
201
                                        <author>$ScientificNameAuthor</author>
202
                                        <binomial>$ScientificName</binomial>
203
                                        <family>$family</family>
204
                                        <genus>$genus</genus>
205
                                        <species>$species</species>
206
                                    </taxonverbatim>
205 207
                                </taxonlabel>
206 208
                            </taxonlabel_id>
207 209
                        </taxondetermination>
......
223 225
        </path>
224 226
    </_simplifyPath>
225 227
</VegBIEN>
226
Inserted 34 new rows into database
228
Inserted 36 new rows into database

Also available in: Unified diff