-- ABS-31158

------------------ WORKSTATION ------------------
COMMENT ON COLUMN WORKSTATION.DELNOTEALLOWALLPRODUCTS
IS 'Not used anymore, replaced by DELNOTEALLOWADDPRODUCTS';

ALTER TABLE WORKSTATION ADD (DELNOTEALLOWADDPRODUCTS NUMBER DEFAULT 0  NOT NULL CONSTRAINT DELNOTEALLOWADDPRODUCTS_VALID CHECK (DELNOTEALLOWADDPRODUCTS IN (0,1,2)));

COMMENT ON COLUMN WORKSTATION.DELNOTEALLOWADDPRODUCTS 
IS '0 = Active products from PLPC
1 = All active products in activities from customer
2 = Active Clean Count Products from PLPC';

UPDATE WORKSTATION W
SET W.DELNOTEALLOWADDPRODUCTS = 1
WHERE W.DELNOTEALLOWALLPRODUCTS = 'Y';

COMMIT;

