ALTER TABLE COMMENTS ADD (PROJECT NUMBER(10) DEFAULT NULL NULL)
/
ALTER TABLE COMMENTS MODIFY (TASK NUMBER(10) DEFAULT NULL NULL)
/
ALTER TABLE COMMENTS ADD CONSTRAINT COMMENTS_PROJECT_FK FOREIGN KEY (PROJECT) REFERENCES PROJECT (ID)
/
ALTER TABLE MEETING_TASK_STATUS ADD (TYPE VARCHAR2(1) DEFAULT 'T' NOT NULL)
/
ALTER TABLE MEETING_TASK_STATUS
ADD CONSTRAINT CK_MEETING_TASK_STATUS_TYPE CHECK (TYPE in ('T','I'))
/
