-- ABS-93934
comment on column ERP_I_PRICELIST.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)';
alter table ERP_I_PRICELIST
  drop constraint CHK_ERP_I_PRICELIST_PC;
alter table ERP_I_PRICELIST
  add constraint CHK_ERP_I_PRICELIST_PC
  check (PRICECOMPONENT IN (1,2,3,4,5,6));