-- ABS-86229 / ABS-89343
-------------WEARER ------------------------

ALTER TABLE WEARER DROP CONSTRAINT EMAILFILLED_VALIDATION;
ALTER TABLE WEARER DROP CONSTRAINT LANGUAGEFILLED_VALIDATION;
ALTER TABLE WEARER DROP CONSTRAINT PASSWORDFILLED_VALIDATION;

ALTER TABLE WEARER
  ADD CONSTRAINT EMAILFILLED_VALIDATION
  CHECK  ((WEBWEARER = 'Y' AND EMAILADDRESS IS NOT NULL) OR (WEBWEARER = 'N'));

ALTER TABLE WEARER
  ADD CONSTRAINT LANGUAGEFILLED_VALIDATION
  CHECK ((WEBWEARER = 'Y' AND LANGUAGE_ID IS NOT NULL) OR (WEBWEARER = 'N'));

ALTER TABLE WEARER
  ADD CONSTRAINT PASSWORDFILLED_VALIDATION
  CHECK ((WEBWEARER = 'Y' AND PASSWORD IS NOT NULL) OR (WEBWEARER = 'N'));
  
---------MUASETTINGS----------------

ALTER TABLE MUASETTINGS DROP COLUMN TIMEOUT;