Project

General

Profile

« Previous | Next » 

Revision 5313

schemas/vegbien.sql: taxonconcept: taxonconcept_required_key: Removed family and genus because these are now cached fields only, and are not used for scoping a taxonconcept. Instead, *taxonomicname and taxonname+parent_id are used for this purpose. This removes several leaf taxonconcepts with insufficient scoping information to create a taxonconcept separate from the main tree. With the upcoming population of creationdate, some of these taxonconcepts will reappear due to the date's additional distinguishing information.

View differences:

inputs/MT/Specimen/test.xml.ref
112 112
        </path>
113 113
    </_simplifyPath>
114 114
</VegBIEN>
115
Inserted 24 new rows into database
115
Inserted 23 new rows into database
inputs/TEAM/VL/test.xml.ref
116 116
        </path>
117 117
    </_simplifyPath>
118 118
</VegBIEN>
119
Inserted 32 new rows into database
119
Inserted 30 new rows into database
inputs/TEAM/VT/test.xml.ref
116 116
        </path>
117 117
    </_simplifyPath>
118 118
</VegBIEN>
119
Inserted 29 new rows into database
119
Inserted 27 new rows into database
inputs/Madidi/Organism/test.xml.ref
239 239
        </path>
240 240
    </_simplifyPath>
241 241
</VegBIEN>
242
Inserted 38 new rows into database
242
Inserted 36 new rows into database
inputs/UNCC/Specimen/test.xml.ref
224 224
        </path>
225 225
    </_simplifyPath>
226 226
</VegBIEN>
227
Inserted 23 new rows into database
227
Inserted 22 new rows into database
inputs/SALVIAS-CSV/Organism/test.xml.ref
335 335
        </path>
336 336
    </_simplifyPath>
337 337
</VegBIEN>
338
Inserted 50 new rows into database
338
Inserted 46 new rows into database
inputs/REMIB/Specimen/test.xml.ref
156 156
        </path>
157 157
    </_simplifyPath>
158 158
</VegBIEN>
159
Inserted 26 new rows into database
159
Inserted 25 new rows into database
inputs/CTFS/TaxonOccurrence/test.xml.ref
85 85
        </path>
86 86
    </_simplifyPath>
87 87
</VegBIEN>
88
Inserted 18 new rows into database
88
Inserted 16 new rows into database
inputs/FIA/Organism/test.xml.ref
133 133
        </path>
134 134
    </_simplifyPath>
135 135
</VegBIEN>
136
Inserted 21 new rows into database
136
Inserted 20 new rows into database
inputs/SALVIAS/plotObservations/test.xml.ref
309 309
        </path>
310 310
    </_simplifyPath>
311 311
</VegBIEN>
312
Inserted 45 new rows into database
312
Inserted 43 new rows into database
inputs/U/Specimen/test.xml.ref
199 199
        </path>
200 200
    </_simplifyPath>
201 201
</VegBIEN>
202
Inserted 30 new rows into database
202
Inserted 28 new rows into database
inputs/VegBank/taxonobservation_/test.xml.ref
149 149
        </path>
150 150
    </_simplifyPath>
151 151
</VegBIEN>
152
Inserted 34 new rows into database
152
Inserted 32 new rows into database

Also available in: Unified diff