-- Migration from 070 to 071
ALTER TABLE CONTROLLED_VOCABULARY_TERMS ADD COLUMN IS_OFFICIAL BOOLEAN_CHAR NOT NULL DEFAULT 'T';

-- 
-- Virtual data set related changes
--
ALTER TABLE DATA_SET_TYPES ADD COLUMN IS_CONTAINER BOOLEAN_CHAR DEFAULT false;
ALTER TABLE DATA ADD COLUMN CTNR_ORDER INTEGER;
ALTER TABLE DATA ADD COLUMN CTNR_ID TECH_ID DEFAULT NULL;
ALTER TABLE DATA ADD CONSTRAINT DATA_CTNR_FK FOREIGN KEY (CTNR_ID) REFERENCES DATA(ID);