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
49 49
                                        </taxonlabel>
50 50
                                    </matched_label_id>
51 51
                                    <creationdate><_date><date><_dateRangeStart><value>$interpretationdate</value></_dateRangeStart></date></_date></creationdate>
52
                                    <family>$Family</family>
53
                                    <genus>$Genus</genus>
54 52
                                    <identifyingtaxonomicname>
55 53
                                        <_join_words>
56 54
                                            <1>$Family</1>
......
139 137
                                            </parent_id>
140 138
                                        </taxonlabel>
141 139
                                    </parent_id>
142
                                    <species>$Species</species>
140
                                    <taxonverbatim>
141
                                        <family>$Family</family>
142
                                        <genus>$Genus</genus>
143
                                        <species>$Species</species>
144
                                    </taxonverbatim>
143 145
                                </taxonlabel>
144 146
                            </taxonlabel_id>
145 147
                            <determinationdate><_date><date><_dateRangeStart><value>$interpretationdate</value></_dateRangeStart></date></_date></determinationdate>
......
149 151
                            <isoriginal>true</isoriginal>
150 152
                            <taxonlabel_id>
151 153
                                <taxonlabel>
152
                                    <binomial>$authorplantname</binomial>
153 154
                                    <identifyingtaxonomicname>$authorplantname</identifyingtaxonomicname>
154 155
                                    <matched_label_id>
155 156
                                        <taxonlabel>
......
162 163
                                            <identifyingtaxonomicname>$authorplantname</identifyingtaxonomicname>
163 164
                                        </taxonlabel>
164 165
                                    </matched_label_id>
166
                                    <taxonverbatim><binomial>$authorplantname</binomial></taxonverbatim>
165 167
                                </taxonlabel>
166 168
                            </taxonlabel_id>
167 169
                        </taxondetermination>
......
171 173
        </path>
172 174
    </_simplifyPath>
173 175
</VegBIEN>
174
Inserted 22 new rows into database
176
Inserted 25 new rows into database

Also available in: Unified diff