--UPDATE FROM 8.8.2.3 TO 8.8.2.4


DROP TABLE VERSION_8_8_2_3;



/*  VERSION_8_8_2_4  */
CREATE TABLE VERSION_8_8_2_4 (
	 DUMMY	NUMBER	    NULL
)
;

ALTER TABLE YRCH MODIFY YRCH_WEBINFO VARCHAR2(2000);

ALTER TABLE MMOD ADD MMOD_HTTP_URL2 VARCHAR2(100);

COMMENT ON COLUMN MMOD.MMOD_HTTP_URL2 IS '3rd URL used by Expedia for booking Confirmation reqeust';

ALTER TABLE MQU4 ADD MQU4_RESEND NUMBER(1,0);

COMMENT ON COLUMN MQU4.MQU4_RESEND IS 'Indicates whether message could not yet be sent';

ALTER TABLE ZDCO ADD ZDCO_COMMENTDISABLED NUMERIC(1) DEFAULT 0;

COMMENT ON COLUMN ZDCO.ZDCO_COMMENTDISABLED IS '0 = ZPOS_COMMENT shown on invoice, 1 = ZPOS_COMMENT hidden on invoice';

DELETE FROM WUSS WHERE WUSS.WUSS_NAME LIKE 'INFOFOLIOONLYONCE';

ALTER TABLE MCFG ADD MCFG_SVC_MAX_MEM NUMBER(4,0);

COMMENT ON COLUMN MCFG.MCFG_SVC_MAX_MEM IS 'Indicates the maximum memory amount a service can use before the monitor restarts the service';

ALTER TABLE MCFG ADD MCFG_MON_LOGLEVEL NUMBER(1,0);

COMMENT ON COLUMN MCFG.MCFG_MON_LOGLEVEL IS 'logging level for the interface monitor';
