--UPDATE FROM 8.6.4.3 TO 8.6.4.4


DROP TABLE VERSION_8_6_4_3;



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


ALTER TABLE MMOD ADD (MMOD_ADD_OVERBOOK NUMBER(1,0) NULL);

ALTER TABLE MMOD ADD (MMOD_HOTEL_KEY VARCHAR2(128) NULL);

COMMENT ON COLUMN MMOD.MMOD_ADD_OVERBOOK Is 'indicates whether overbooking values are used for rtav';

COMMENT ON COLUMN MMOD.MMOD_HOTEL_KEY Is 'extra hotel key for WebRes';

ALTER TABLE MMOD ADD (MMOD_WEBS_WSDL VARCHAR2(200) NULL);

ALTER TABLE MMOD ADD (MMOD_WEBS_SERVICE VARCHAR2(50) NULL);

ALTER TABLE MMOD ADD (MMOD_WEBS_PORT VARCHAR2(50) NULL);

COMMENT ON COLUMN MMOD.MMOD_WEBS_WSDL Is 'WSDL for WebService used by the mapper';

COMMENT ON COLUMN MMOD.MMOD_WEBS_SERVICE Is 'Service for WebService used by the mapper';

COMMENT ON COLUMN MMOD.MMOD_WEBS_PORT Is 'Port for WebService used by the mapper';

 