--Order 20014961

ALTER TABLE WEBUSER
	ADD (SIZESELECTION  NUMBER DEFAULT 0 NOT NULL CONSTRAINT SIZESELECTION_valid CHECK (SIZESELECTION IN (0, 1)));


COMMENT ON COLUMN WEBUSER.WEARERACCESS IS '0 = Full access on all sizes
1 = Limited access to sizes
';


--Order 20014978

ALTER TABLE WEBUSER
	ADD (WEBREPORTCUSTOMERSELECTION  NUMBER DEFAULT 0 NOT NULL CONSTRAINT WEBRPTCUSTSELCT_valid CHECK (WEBREPORTCUSTOMERSELECTION IN (0, 1, 2)));


COMMENT ON COLUMN WEBUSER.WEARERACCESS IS '0 = Single Customer Fixed
1 = Single Customer Default
2 = Multiple Customers
';