Revision 11171
Added by Aaron Marcuse-Kubitza almost 11 years ago
| vegbank.~.clean_up.sql | ||
|---|---|---|
| 446 | 446 |
ALTER TABLE plantname RENAME reference_id TO plantname_reference_id; |
| 447 | 447 |
|
| 448 | 448 |
-- indicate required columns |
| 449 |
ALTER TABLE comminterpretation ALTER COLUMN commname SET NOT NULL; |
|
| 449 |
--ALTER TABLE comminterpretation ALTER COLUMN commname SET NOT NULL; -- now NULL in 10 rows, where commconcept_id is also NULL |
|
Also available in: Unified diff
inputs/VegBank/: refreshed VegBank so that all of Mike Lee's sample plots would be included in the input data. (VegBank was last refreshed from the live DB on 2012-8-30.) split vegbank.sql into vegbank.schema.sql and vegbank.data.sql so that the schema can be examined and imported separately, like for MySQL datasources. inputs/VegBank/vegbank.~.clean_up.sql: commented out setting comminterpretation.commname to NOT NULL, because after the refresh it is now NULL in 10 rows, where commconcept_id is also NULL.