-- ABS-82058 / ABS-84251
--------------------- WEBUSER --------------------

ALTER TABLE WEBUSER 
ADD (SHOWRESIDENTIALINSCANDATE VARCHAR2(1) DEFAULT 'N' NOT NULL CONSTRAINT CHK_WEBUSER_SHOWRESINSCANDATE CHECK (SHOWRESIDENTIALINSCANDATE IN ('Y','N')));

COMMENT ON COLUMN WEBUSER.SHOWRESIDENTIALINSCANDATE
IS 'This setting is only relevant when the modules PWBINTERNET is active';