--UPDATE FROM 8.8.4.4 TO 8.8.4.5


DROP TABLE VERSION_8_8_4_4;



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


ALTER TABLE WRPD MODIFY WRPD_VALUE VARCHAR2(3000);

ALTER TABLE COUP MODIFY COUP_ISSUE NULL;

ALTER TABLE XCMM ADD XCMM_REPORT_GROUP NUMBER (1);

COMMENT ON COLUMN XCMM.XCMM_REPORT_GROUP IS 'Field is used to sum up categories in reports, possible values are 1, 2, 3 or 4';

ALTER TABLE YBLH ADD YBLH_ADDTOMEALPLAN NUMBER (1) DEFAULT 1 NOT NULL;

DELETE FROM WUSS WHERE WUSS_NAME = 'BlocksInMealplanForecast';

INSERT INTO WUSS (WUSS_ID,WUSS_XCMS_ID,WUSS_NAME,WUSS_VALUE) VALUES (SEQ_WUSS.NEXTVAL,0,'BlocksInMealplanForecast','1');

UPDATE YBLH SET YBLH_ADDTOMEALPLAN = 1;

COMMENT ON COLUMN MCNV.MCNV_TYPE IS 'RC= rate code, RT= room type, MC= market code, SC= source code, CH= channel, GT= guarantee type, PM= payment method, CC= credit card, CO= country, ST= state, CU= currency, LA= language, BC= block code, SP= specials, FE= features, CR= cancellation reason, DO= document type, CT= card type, AT= address type, CM= communication type, SA= Salutation codes, PA= Packages, II= Inventory Items, AL= Airlines, PT= Pickup types, RA= rate category, used for OXI rate code request, CA= child age category, VC= VIP code, DC= Department code, used for OXI rate code request, WL= Waitlist reason, NA= nationality, BI= Billing Instructions  -> this is not yet an conversion type, NT= Note Types, BS= Block Status, CD= Commission Code, TR= Traces, X0= user defined type, X1= user defined type, X2= user defined type, X3= user defined type, X4= user defined type, X5= user defined type, X6= user defined type, X7= user defined type, X8= user defined type, X9= user defined type ';

ALTER TABLE COUP MODIFY COUP_DESCRIPTION VARCHAR2(4000);

ALTER TABLE CART MODIFY CART_COUPONDESCR VARCHAR2(4000);
