--ABS-139000

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

COMMENT ON COLUMN EMBLEMTEMPLATELINE.ACTIVE IS 'Y/N';

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

COMMENT ON COLUMN CONTRACTEMBTEMPLINE.ACTIVE IS 'Y/N';
