ALTER TABLE TASK_TYPE 
ADD ORDER_TO_FRAME NUMBER NULL
/
ALTER TABLE TASK_TYPE 
ADD ALLOW_CLOSE_ISSUE VARCHAR2(1) DEFAULT 'Y' NOT NULL
CONSTRAINT CKC_TASK_TYPE_ALLOW_CLOSE_ISSU CHECK (ALLOW_CLOSE_ISSUE in ('Y','N'))
/
