--ABSN-8972

--CONTACTCATEGORY TABLE
ALTER TABLE CONTACTCATEGORY ADD (ACTIVE VARCHAR2(1) DEFAULT 'Y' NOT NULL CONSTRAINT CHK_CONTACTCATEGORY_ACTIVE CHECK (ACTIVE IN ('Y', 'N')));

ALTER TABLE CONTACTCATEGORY ADD CONSTRAINT CHK_CONTACTCATEGORY_DEFCONCAT_ACTIVE CHECK ((DEFAULTCONTACTCATEGORY = 'Y' AND ACTIVE = 'Y') OR (DEFAULTCONTACTCATEGORY = 'N'));
