Project

General

Profile

« Previous | Next » 

Revision 3742

schemas/vegbien.sql: 1_to_1 and *_unique_within unique indexes with a `WHERE sourceaccessioncode IS NULL` filter: Added IS NULL filters for other unique keys, so that these fallback indexes would only be used if there was no (or no other) way to uniquely identify their tables. For *_1_to_1 unique indexes, this is the case for specimens data.

View differences:

inputs/CVS/test/import.organisms.xml.ref
90 90
        </aggregateoccurrence_id>
91 91
    </plantobservation>
92 92
</VegBIEN>
93
Inserted 18 new rows into database
93
Inserted 19 new rows into database

Also available in: Unified diff