/ - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 4489

schemas/vegbien.sql: project: Don't require projectname to be specified when sourceaccessioncode is provided

inputs/SALVIAS/plotMetadata/test.xml.ref
280	280	<slopegradient>$slope_gradient</slopegradient>
281	281	</location>
282	282	</VegBIEN>
283		Inserted 22 new rows into database
	283	Inserted 23 new rows into database

         project_id int(11) NOT NULL,
         datasource_id int(11) NOT NULL,
         sourceaccessioncode text,
         projectname text NOT NULL,
         projectname text,
         projectdescription text,
         startdate timestamp NULL,
         stopdate timestamp NULL,

         project_id integer NOT NULL,
         datasource_id integer NOT NULL,
         sourceaccessioncode text,
         projectname text NOT NULL,
         projectname text,
         projectdescription text,
         startdate timestamp with time zone,
         stopdate timestamp with time zone,
         d_obscount integer,
         d_lastlocationaddeddate timestamp with time zone,
         accessioncode text
         accessioncode text,
         CONSTRAINT project_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (projectname IS NOT NULL)))
     );

Also available in: Unified diff