-- ABS-67454/ ABS-67460

--- SYSTEMUSERAPPDEFAULTS table ---
ALTER TABLE SYSTEMUSERAPPDEFAULTS ADD (PAMODE NUMBER DEFAULT 0 NOT NULL
                                       CONSTRAINT PAMODE_VALID1_1 CHECK (PAMODE IN (0, 1)));

COMMENT ON COLUMN SYSTEMUSERAPPDEFAULTS.PAMODE
  IS '0 = Packing note mode
1 = Paperless mode
';

--- DAY table ---
ALTER TABLE DAY ADD (COLOR VARCHAR2(6) NULL);

COMMENT ON COLUMN DAY.COLOR
  IS 'RGB Hex value';