-- ABS-84013 / ABS-84019
--- UNIQUEITEMEMBLEM ---
ALTER TABLE UNIQUEITEMEMBLEM DROP CONSTRAINT EMBLEMTYPE_VALID;

ALTER TABLE UNIQUEITEMEMBLEM ADD CONSTRAINT CHK_UNIQUEITEMEMB_EMBTYPE CHECK (EMBLEMTYPE IN (1,2,3,4));

COMMENT ON COLUMN UNIQUEITEMEMBLEM.EMBLEMTYPE IS '1= Company
2 = Name
3 = Other/ Not Defined
4 = Title';