ALTER TABLE TASK DROP (ISSUE_VOTE)
/
ALTER TABLE ALLOCATION ADD (
  IS_RELEVANT VARCHAR2(1) DEFAULT 'N' NOT NULL
)
/
ALTER TABLE ALLOCATION ADD CONSTRAINT CKC_ALLOCATION_IS_RELEVANT CHECK (IS_RELEVANT in ('Y','N'))
/