Project

General

Profile

« Previous | Next » 

Revision 4947

Added by Aaron Marcuse-Kubitza over 12 years ago

schemas/vegbien.sql: party: Added check constraint to require at least an organizationname or surname. Previously, NULL entries for the collector or identifier incorrectly caused the creation of an empty party entry, hence the lower inserted row counts now that this is no longer created.

View differences:

inputs/NY/Specimen/test.xml.ref
204 204 
        </path>
205 205 
    </_simplifyPath>
206 206 
</VegBIEN>
207 
Inserted 27 new rows into database
207 
Inserted 26 new rows into database
inputs/Madidi/Organism/test.xml.ref
96 96 
        </path>
97 97 
    </_simplifyPath>
98 98 
</VegBIEN>
99 
Inserted 28 new rows into database
99 
Inserted 27 new rows into database
inputs/ACAD/Specimen/test.xml.ref
124 124 
        </path>
125 125 
    </_simplifyPath>
126 126 
</VegBIEN>
127 
Inserted 25 new rows into database
127 
Inserted 24 new rows into database
inputs/U/Specimen/test.xml.ref
131 131 
        </path>
132 132 
    </_simplifyPath>
133 133 
</VegBIEN>
134 
Inserted 24 new rows into database
134 
Inserted 23 new rows into database
inputs/ARIZ/Specimen/test.xml.ref
184 184 
        </path>
185 185 
    </_simplifyPath>
186 186 
</VegBIEN>
187 
Inserted 27 new rows into database
187 
Inserted 26 new rows into database
inputs/GBIF/Specimen/test.xml.ref
92 92 
        </path>
93 93 
    </_simplifyPath>
94 94 
</VegBIEN>
95 
Inserted 29 new rows into database
95 
Inserted 28 new rows into database
inputs/MO/Specimen/test.xml.ref
116 116 
        </path>
117 117 
    </_simplifyPath>
118 118 
</VegBIEN>
119 
Inserted 24 new rows into database
119 
Inserted 23 new rows into database
schemas/vegbien.sql
926 926 
    partytype text,
927 927 
    partypublic boolean DEFAULT true,
928 928 
    d_obscount integer,
929 
    accessioncode text
929 
    accessioncode text,
930 
    CONSTRAINT party_required_key CHECK (((organizationname IS NOT NULL) OR (surname IS NOT NULL)))
930 931 
);
931 932 

  		




  932
  933
  
    

  		












Also available in:  Unified diff