Project

General

Profile

« Previous | Next » 

Revision 11158

inputs/VegBank/vegbank.~.clean_up.sql: indicate required column comminterpretation.commname

View differences:

inputs/VegBank/vegbank.~.clean_up.sql
442 442
ALTER TABLE plantconcept RENAME plantname  TO plantconcept_plantname;
443 443
ALTER TABLE plantconcept RENAME accessioncode  TO plantconcept_accessioncode;
444 444
ALTER TABLE plantname RENAME reference_id  TO plantname_reference_id;
445

  
446
-- indicate required columns
447
ALTER TABLE comminterpretation ALTER COLUMN commname SET NOT NULL;

Also available in: Unified diff