--UPDATE FROM 8.8.4.6 TO 8.8.4.7


DROP TABLE VERSION_8_8_4_6;


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

ALTER TABLE XCMS ADD XCMS_BATCHID NUMBER(30);

COMMENT ON COLUMN XCMS.XCMS_BATCHID IS 'used for grouping profiles for batch processing. ie for duplicate search';

ALTER TABLE COUP MODIFY COUP_DESCRIPTION VARCHAR2(4000);

ALTER TABLE CART MODIFY CART_COUPONDESCR VARCHAR2(4000);

ALTER TABLE WEDA MODIFY(WEDA_ROLE NUMBER(2));

ALTER TABLE XCEE MODIFY(XCEE_MODULE NUMBER(2));

ALTER TABLE WSCM MODIFY(WSCM_MODULE NUMBER(2));

ALTER TABLE WEDA ADD WEDA_WTXT_ID NUMBER(30);

ALTER TABLE XSCD ADD XSCD_ADDDEFAULTATTACHMENTS NUMBER(1);

ALTER TABLE RRES ADD RRES_PRICE NUMBER(30,4);

COMMENT ON COLUMN RRES.RRES_PRICE IS 'Price of the resource reservation. Not available for tables';

ALTER TABLE ZWIN ADD ZWIN_NOBONUSPOINTS NUMBER(1) DEFAULT 0 NOT NULL;

ALTER TABLE SMAN ADD SMAN_ROOMS_OCC_E1P_D NUMBER(5);

ALTER TABLE SMAN ADD SMAN_ROOMS_OCC_E1P_M NUMBER(5);

ALTER TABLE SMAN ADD SMAN_ROOMS_OCC_E1P_Y NUMBER(7);

ALTER TABLE SMAN ADD SMAN_ROOMS_OCC_M1P_D NUMBER(5);

ALTER TABLE SMAN ADD SMAN_ROOMS_OCC_M1P_M NUMBER(5);

ALTER TABLE SMAN ADD SMAN_ROOMS_OCC_M1P_Y NUMBER(7);
