--Orders 20014959, 20014960, 20014962


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

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

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

COMMENT ON COLUMN WEBUSER.WEARERACCESS IS '0 = Unlimited
1 = Limited: allow only modifying as long as there are no items in circulation.
';

COMMENT ON COLUMN WEBUSER.EMBLEMTEMPLATEACCESS IS '0 = Modifiable
1 = Not modifiable
';

COMMENT ON COLUMN WEBUSER.EXTENDEDWEARERSEARCH IS '0 = Extended wearer search is not available
1 = Extended wearer search is available
';