ALTER TABLE DEPLOY ADD (
  TICKET_ID NUMBER(10) DEFAULT NULL NULL
)
/
ALTER TABLE SERVER ADD (
  IS_REQUIRED_TICKET VARCHAR2(1) DEFAULT 'N' NOT NULL
)
/
ALTER TABLE SERVER ADD CONSTRAINT SRV_CKC_IS_REQUIRED_TICKET CHECK (IS_REQUIRED_TICKET IN ('Y','N'))
/
ALTER TABLE TASK ADD (
  TASK_ORDER NUMBER(10) DEFAULT NULL NULL
)
/
ALTER TABLE CLASSIFICATION ADD (
  USED_IN_TIME_CONTROL VARCHAR2(1) DEFAULT 'Y' NOT NULL
)
/
ALTER TABLE CLASSIFICATION ADD CONSTRAINT CLA_CKC_USED_IN_TIME_CONTROL CHECK (USED_IN_TIME_CONTROL IN ('Y', 'N'))