ALTER TABLE COMMENTS ADD (
  COMMENT_TYPE_ID NUMBER(10) DEFAULT NULL NULL
)
/
ALTER TABLE COMMENTS ADD CONSTRAINT COMMENTS_COMMENT_TYPE_FK FOREIGN KEY (COMMENT_TYPE_ID) REFERENCES COMMENT_TYPE (ID)
/
ALTER TABLE TASK_TYPE ADD (
  ALLOW_PLAY_TASK VARCHAR2(1) DEFAULT 'Y' NOT NULL, 
  DESCRIPTION_AUTO_CHANGE_STATUS VARCHAR2(255) DEFAULT NULL NULL
)
/
ALTER TABLE TASK_TYPE ADD CONSTRAINT CKC_TASK_TYPE_ALLOW_PLAY_TASK CHECK (ALLOW_PLAY_TASK in ('Y', 'N'))
/
ALTER TABLE TASK_TYPE_COMMENT_TYPE ADD (
  COMMENT_DESCRIPTION VARCHAR2(255) DEFAULT NULL NULL
)
/