--  ABS-75841 / ABS-84267
--- CONTRACTCOMPONENTBGPROTECTION ---
ALTER TABLE CONTRACTCOMPONENTBGPROTECTION ADD (GARMENTEMBLEM VARCHAR2(1) NULL
					CONSTRAINT CHK_CONTRACTCOMPBG_GARMEMB CHECK (GARMENTEMBLEM IN ('Y','N')));

--- CONTRACTPRODUCTBGPROTECTION ---
ALTER TABLE CONTRACTPRODUCTBGPROTECTION ADD (GARMENTEMBLEM VARCHAR2(1) NULL
					CONSTRAINT CHK_CONTRACTPRODBG_GARMEMB CHECK (GARMENTEMBLEM IN ('Y','N')));

--- CUSTOMERBGPROTECTIONPRICE ---
ALTER TABLE CUSTOMERBGPROTECTIONPRICE DROP CONSTRAINT PRICECOMPONENT_VALID1;

ALTER TABLE CUSTOMERBGPROTECTIONPRICE ADD CONSTRAINT CHK_CUSTBGPROTECTION_PRICECOMP CHECK (PRICECOMPONENT IN (1,2,3,4,5,6));

COMMENT ON COLUMN CUSTOMERBGPROTECTIONPRICE.PRICECOMPONENT IS '1 = Garment Maintenance Protection (GMP)
2 = Garment Setup Protection (GSP)
3 = Garment Loss Protection (GLP)
4 = Garment Repair Protection (GRP)
5 = Merchandise Buyout Protection (MBYOP)
6 = Garment Emblem Protection (GEP)';

--- CUSTOMERBUDGETPROTECTION ---
ALTER TABLE CUSTOMERBUDGETPROTECTION ADD (GARMENTEMBLEM VARCHAR2(1) DEFAULT 'N' NOT NULL
					CONSTRAINT CHK_CUSTBUDGETPRO_GARMEMB CHECK (GARMENTEMBLEM IN ('Y','N')));

--- GENERALBGPROTECTIONPRICE ---
ALTER TABLE GENERALBGPROTECTIONPRICE DROP CONSTRAINT PRICECOMPONENT_VALID2;

ALTER TABLE GENERALBGPROTECTIONPRICE ADD CONSTRAINT CHK_GENBGPROTECTION_PRICECOMP CHECK (PRICECOMPONENT IN (1,2,3,4,5,6));

COMMENT ON COLUMN GENERALBGPROTECTIONPRICE.PRICECOMPONENT IS '1 = Garment Maintenance Protection (GMP)
2 = Garment Setup Protection (GSP)
3 = Garment Loss Protection (GLP)
4 = Garment Repair Protection (GRP)
5 = Merchandise Buyout Protection (MBYOP)
6 = Garment Emblem Protection (GEP)';

--- PLPCBUDGETPROTECTION ---
ALTER TABLE PLPCBUDGETPROTECTION ADD (GARMENTEMBLEM VARCHAR2(1) DEFAULT 'N' NOT NULL
				CONSTRAINT CHK_PLPCBUDGET_GARMEMB CHECK (GARMENTEMBLEM IN ('Y','N')));

--- DISTRIBPOINTBGPROTECTION ---
ALTER TABLE DISTRIBPOINTBGPROTECTION ADD (GARMENTEMBLEM VARCHAR2(1) DEFAULT 'N' NOT NULL
				CONSTRAINT CHK_DISTRIBBG_GARMEMB CHECK (GARMENTEMBLEM IN ('Y','N')));

