ALTER TABLE TASK_STATUS 
ADD USED_IN_TASK VARCHAR2(1) DEFAULT 'Y' NOT NULL
CONSTRAINT CKC_TASK_STATUS_USED_IN_TASK CHECK (USED_IN_TASK in ('Y','N'))
/ 
ALTER TABLE TASK_STATUS 
ADD USED_IN_ISSUE VARCHAR2(1) DEFAULT 'Y' NOT NULL
CONSTRAINT CKC_TASK_STATUS_USED_IN_ISSUE CHECK (USED_IN_ISSUE in ('Y','N'))
/