-- ABS-6639
ALTER TABLE COLOR ADD (USEFORRESIDENTIALSERVICES NUMBER DEFAULT 1 NOT NULL 
                       CONSTRAINT USEFORRESIDENTIALSERVICES_VAL CHECK (USEFORRESIDENTIALSERVICES IN (0,1)));
                       
COMMENT ON COLUMN COLOR.USEFORRESIDENTIALSERVICES 
IS '0 = Not used for Residential Services
1 = Used for Residential Services (Product.Color)';
