--Order 20013062.100

ALTER TABLE WEBUSER ADD (LINENASSISTANTINUSE VARCHAR2(1) DEFAULT 'N' NOT NULL);
ALTER TABLE WEBUSER ADD (GARMENTASSISTANTINUSE VARCHAR2(1) DEFAULT 'N' NOT NULL);
 
COMMENT ON COLUMN WEBUSER.LINENASSISTANTINUSE
  IS 'Set to Y when this web user logs on with the Linen Assistant App';
COMMENT ON COLUMN WEBUSER.GARMENTASSISTANTINUSE
  IS 'Set to Y when this web user logs on with the Garment Assistant App';

ALTER TABLE WEBUSER
  ADD CONSTRAINT YN_VALIDATIONFIELD232
  CHECK (LINENASSISTANTINUSE IN ('Y','N'));
ALTER TABLE WEBUSER
  ADD CONSTRAINT YN_VALIDATIONFIELD233
  CHECK (GARMENTASSISTANTINUSE IN ('Y','N'));