--ABS-90401 Clean up code related to WEARERWEB module
ALTER TABLE CUSTOMERINTERNETOPTIONS
DROP CONSTRAINT WEBWEARERSEMAILADDRESSFILLED;

ALTER TABLE CUSTOMERINTERNETOPTIONS
DROP CONSTRAINT WEBWEARERSPASSWORDFILLED;

ALTER TABLE CUSTOMERINTERNETOPTIONS
DROP CONSTRAINT YN_VALIDATIONFIELD229;

ALTER TABLE CUSTOMERINTERNETOPTIONS
DROP COLUMN ALLOWWEBWEARERS;

ALTER TABLE CUSTOMERINTERNETOPTIONS
DROP COLUMN WEBWEARERSEMAILADDRESS;

ALTER TABLE CUSTOMERINTERNETOPTIONS
DROP COLUMN WEBWEARERSPASSWORD;

ALTER TABLE WEBUSER
DROP CONSTRAINT USEFORWEARERWEB_VALID1_1;

ALTER TABLE WEBUSER
DROP COLUMN USEFORWEARERWEB;

ALTER TABLE WEARERFUNCTION
DROP CONSTRAINT ALLOWORDERINGVIAWEBMODE_VALID1;

ALTER TABLE WEARERFUNCTION
DROP CONSTRAINT ALLOWORDERINGVIAWEB_VALID1;

ALTER TABLE WEARERFUNCTION
DROP COLUMN ALLOWORDERINGVIAWEB;

ALTER TABLE WEARERFUNCTION
DROP COLUMN ALLOWORDERINGVIAWEBMODE;

ALTER TABLE WEARER
DROP CONSTRAINT ALLOWORDERINGVIAWEB_VALID1_1;

ALTER TABLE WEARER
DROP COLUMN ALLOWORDERINGVIAWEB;

ALTER TABLE CONTRACTWEARERFUNCTION
DROP CONSTRAINT ALLOWORDERINGVIAWEBMODE_VALID2;

ALTER TABLE CONTRACTWEARERFUNCTION
DROP CONSTRAINT ALLOWORDERINGVIAWEB_VALID1_2;

ALTER TABLE CONTRACTWEARERFUNCTION
DROP COLUMN ALLOWORDERINGVIAWEB;

ALTER TABLE CONTRACTWEARERFUNCTION
DROP COLUMN ALLOWORDERINGVIAWEBMODE;

DELETE FROM SYSTEMSETTING 
WHERE NAME='SHOWSUPPLSIZECHART';
COMMIT;

