--UPDATE FROM 8.9.6.4 TO 8.9.6.10


DROP TABLE VERSION_8_9_6_4;


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


INSERT INTO WUSS (WUSS_ID,
                  WUSS_XCMS_ID,
                  WUSS_NAME,
                  WUSS_VALUE)
SELECT seq_wuss.NEXTVAL,0,'BGS / FA group filters0',SUBSTR(WUSS_VALUE,1,60)
FROM WUSS
WHERE WUSS_NAME = 'BGS / FA group filters'
AND  NOT EXISTS (SELECT WUSS_ID FROM WUSS WHERE WUSS_NAME='BGS / FA group filters0');

ALTER TABLE MMOD ADD MMOD_CRS_CURRENCY NUMBER(30,0);

COMMENT ON COLUMN MMOD.MMOD_CRS_CURRENCY IS 'if it is set then the reservation price is exchanged to this currency if it is different to default hotel currency. Only for BW';

ALTER TABLE YHFS ADD (YHFS_HTLSGMTFILTER VARCHAR2(100 char), YHFS_ROOMTYPEFILTER VARCHAR2(100 char));

COMMENT ON COLUMN YHFS.YHFS_HTLSGMTFILTER IS 'place to save the hotel segments attendant screen filter';

COMMENT ON COLUMN YHFS.YHFS_ROOMTYPEFILTER IS 'place to save the room type attendant screen filter';

ALTER TABLE ZCHE ADD ZCHE_DOCUMENTFORMAT NUMBER(1);

COMMENT ON COLUMN ZCHE.ZCHE_DOCUMENTFORMAT IS 'Document format 0.Text, 1.PDF';




