Revision 5767
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/test_taxonomic_names/Taxon/test.xml.ref | ||
|---|---|---|
| 36 | 36 |
</path> |
| 37 | 37 |
</_simplifyPath> |
| 38 | 38 |
</VegBIEN> |
| 39 |
Inserted 11 new rows into database |
|
| 39 |
Inserted 8 new rows into database |
|
| inputs/.NCBI/nodes/test.xml.ref | ||
|---|---|---|
| 54 | 54 |
</path> |
| 55 | 55 |
</_simplifyPath> |
| 56 | 56 |
</VegBIEN> |
| 57 |
Inserted 11 new rows into database |
|
| 57 |
Inserted 8 new rows into database |
|
| inputs/.TNRS/tnrs/test.xml.ref | ||
|---|---|---|
| 213 | 213 |
</path> |
| 214 | 214 |
</_simplifyPath> |
| 215 | 215 |
</VegBIEN> |
| 216 |
Inserted 17 new rows into database |
|
| 216 |
Inserted 14 new rows into database |
|
| inputs/VegBank/stemcount/test.xml.ref | ||
|---|---|---|
| 23 | 23 |
</path> |
| 24 | 24 |
</_simplifyPath> |
| 25 | 25 |
</VegBIEN> |
| 26 |
Inserted 5 new rows into database |
|
| 26 |
Inserted 1 new rows into database |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1530 | 1530 |
iscultivated boolean, |
| 1531 | 1531 |
cultivatedbasis text, |
| 1532 | 1532 |
isnative boolean, |
| 1533 |
accessioncode text |
|
| 1533 |
accessioncode text, |
|
| 1534 |
CONSTRAINT taxonoccurrence_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (locationevent_id IS NOT NULL))) |
|
| 1534 | 1535 |
); |
| 1535 | 1536 |
|
| 1536 | 1537 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonoccurrence: Added taxonoccurrence_required_key check constraint to ensure that all taxonoccurrences are properly identified, and empty taxonoccurrences are properly pruned. This fixes a bug where taxon-only and stem-only data did not properly prune the taxonoccurrence that would otherwise get created because it's included in the mappings.