--UPDATE FROM 8.8.0.1 TO 8.8.0.2


DROP TABLE VERSION_8_8_0_1;



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


ALTER TABLE YRCH MODIFY YRCH_FOLIOTEXT VARCHAR2 (60);

ALTER TABLE XJET ADD XJET_ENCODING NUMBER(1);

ALTER TABLE WSQL ADD WSQL_HTMLFILE VARCHAR2(200);

ALTER TABLE WSQL ADD WSQL_HTMLIDFIELD VARCHAR2(60); 

ALTER TABLE MMOD ADD MMOD_COMBINE_DEF_TENT NUMBER(1,0);

COMMENT ON COLUMN MMOD.MMOD_COMBINE_DEF_TENT IS 'indicates whether we should upload definite and tentative avl in one field';

ALTER TABLE MMOD ADD MMOD_CHILD_RATE_BUCKETS NUMBER(1,0);

COMMENT ON COLUMN MMOD.MMOD_CHILD_RATE_BUCKETS IS 'Indicates use of child rate buckets for myfidelio';

CREATE TABLE MQU5
(
  MQU5_ID             NUMBER(30)                NOT NULL,
  MQU5_VENDOR_NO      NUMBER(30),
  MQU5_GUID           VARCHAR2(40 BYTE),
  MQU5_TYPE           VARCHAR2(5 BYTE),
  MQU5_PROPERTY_NAME  VARCHAR2(30 BYTE),
  MQU5_FILENAME       VARCHAR2(50 BYTE),
  MQU5_BUILDING       VARCHAR2(3 BYTE),
  MQU5_MESSAGE        CLOB,
  MQU5_HTTPVALUES     VARCHAR2(200 BYTE),
  MQU5_RECEIVED       DATE,
  CONSTRAINT MQU5_PK PRIMARY KEY (MQU5_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8LARGE;

COMMENT ON COLUMN MQU5.MQU5_ID IS 'unique id';

COMMENT ON COLUMN MQU5.MQU5_VENDOR_NO IS 'Vendor number of the vendor to whom the message belongs';

COMMENT ON COLUMN MQU5.MQU5_GUID IS 'GUID identifies message later for deletion';

COMMENT ON COLUMN MQU5.MQU5_TYPE IS 'Type of message like RES, RTAV etc.';

COMMENT ON COLUMN MQU5.MQU5_PROPERTY_NAME IS 'hotel code identifies the hotel to whom message belongs';

COMMENT ON COLUMN MQU5.MQU5_FILENAME IS 'file name of message used for file based interfaces for backups, request messages';

COMMENT ON COLUMN MQU5.MQU5_BUILDING IS 'only used by MyTravel';

COMMENT ON COLUMN MQU5.MQU5_MESSAGE IS 'request message send by the crs';

COMMENT ON COLUMN MQU5.MQU5_HTTPVALUES IS 'contains special query strings for http communication';

COMMENT ON COLUMN MQU5.MQU5_RECEIVED IS 'timestamp when message received';

CREATE SEQUENCE SEQ_MQU5 INCREMENT BY 1 START WITH 1000 NOMAXVALUE NOCYCLE NOCACHE NOORDER;

COMMENT ON COLUMN ZCCS.ZCCS_SCHEMA IS 'hardcoded schema ids, refer zccs_schema_name for description.';

COMMENT ON TABLE ZPO2 IS ' Storage for removed postings - used with the Parameter Polish Faktura Korekta';

ALTER TABLE XCAC ADD XCAC_XGCA_ID NUMBER(30);
