ALTER TABLE CLASSIFICATION ADD USED_IN_NEWS VARCHAR2(1) DEFAULT 'N' NOT NULL
/
ALTER TABLE CLASSIFICATION ADD CONSTRAINT CKC_CLASSIF_USED_IN_NEWS CHECK (USED_IN_NEWS IN ('Y', 'N'))
/
ALTER TABLE DEPLOY ADD PREVIOUS_PRODUCT_VERSION_ID NUMBER