ALTER TABLE PRODUCT_FILES ADD (
  STATE VARCHAR2(1) DEFAULT 'P' NOT NULL
)
/
ALTER TABLE PRODUCT_FILES MODIFY (
  IS_REQUIRED VARCHAR2(1) DEFAULT 'Y', 
  IS_ACTIVE VARCHAR2(1) DEFAULT 'Y'
)
/
ALTER TABLE PRODUCT_FILES ADD CONSTRAINT CKC_PRODUCT_FILES_STATE CHECK (STATE in ('A','P'))
/
ALTER TABLE SERVER ADD (
  ONLY_APPROVED_SCRIPTS VARCHAR2(1) DEFAULT 'Y' NOT NULL
)
/
ALTER TABLE SERVER ADD CONSTRAINT CKC_SERVER_ONLY_APPROV_SCRIPTS CHECK (ONLY_APPROVED_SCRIPTS in ('Y','N'))
/