-- ABS-53725 / ABS-61965
--- CUSTOMER ---
ALTER TABLE CUSTOMER ADD (STACKCHECKMIXEDPRODUCTS NUMBER DEFAULT 0 NOT NULL
			  CONSTRAINT STACKCHECKMIXEDPROD_VALI1_1 CHECK (STACKCHECKMIXEDPRODUCTS IN (0,1)));

COMMENT ON COLUMN CUSTOMER.STACKCHECKMIXEDPRODUCTS IS '0 = Not applicable / Mixed products not allowed
1 = Mixed products allowed';

--- PRODUCT ---
ALTER TABLE PRODUCT ADD (UHFTAGGED NUMBER DEFAULT 0 NOT NULL
			 CONSTRAINT UHFTAGGED_VALID1_1 CHECK (UHFTAGGED IN (0,1)));

COMMENT ON COLUMN PRODUCT.UHFTAGGED IS '0 = Not applicable / Fully tagged
1 = Partly tagged';

--- MULTIREADSCANBATCH ---
ALTER TABLE MULTIREADSCANBATCH ADD (MIXEDPRODUCTSALLOWED VARCHAR2(1) DEFAULT 'N' NOT NULL
				    CONSTRAINT YN_VALIDATIONFIELD410 CHECK (MIXEDPRODUCTSALLOWED IN ('Y','N')),
				    ITEMSPARTLYTAGGED VARCHAR2(1) DEFAULT 'N' NOT NULL
				    CONSTRAINT YN_VALIDATIONFIELD411 CHECK (ITEMSPARTLYTAGGED IN ('Y','N')));

COMMENT ON COLUMN MULTIREADSCANBATCH.MIXEDPRODUCTSALLOWED IS 'Defines if for a stack it is allowed to have mixed products';

COMMENT ON COLUMN MULTIREADSCANBATCH.ITEMSPARTLYTAGGED IS 'When set to Y the product, or at least one product in case of a mixed stack, is partly tagged, which means that the check on stack size is skipped';