Revision 11158
Added by Aaron Marcuse-Kubitza about 11 years ago
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
inputs/VegBank/vegbank.~.clean_up.sql: indicate required column comminterpretation.commname