--UPDATE FROM 8.13.3.3 TO 8.13.4.0
 	
DROP TABLE VERSION_8_13_3_3;


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


alter table weda add weda_ycad_id number(30);
comment on column weda.weda_ycad_id is 'Link to Hotel Segment';

alter table weda add weda_wlan_id number(30);
comment on column weda.weda_wlan_id is 'Link to Language';


ALTER TABLE ZDCO ADD ZDCO_ROUNDING NUMBER(1) DEFAULT 0;
COMMENT ON COLUMN ZDCO.ZDCO_ROUNDING IS 'Identifies if department code is configured for rounding. 0: No, 1: Yes';


INSERT INTO WUSS (WUSS_ID,WUSS_XCMS_ID,WUSS_NAME,WUSS_VALUE)
SELECT seq_wuss.NEXTVAL,0,'FA Profile Change','1'
FROM DUAL WHERE NOT EXISTS (SELECT WUSS_ID FROM WUSS WHERE WUSS_NAME='FA Profile Change');


alter table xcmt add xcmt_type_category number(1);
comment on column xcmt.xcmt_type_category is '0 : Business and 1: Private'; 


INSERT INTO WUSS (WUSS_ID,WUSS_XCMS_ID,WUSS_NAME,WUSS_VALUE)
SELECT seq_wuss.NEXTVAL,0,'GenderEnhancement','0'
FROM DUAL WHERE NOT EXISTS (SELECT WUSS_ID FROM WUSS WHERE WUSS_NAME='GenderEnhancement');


ALTER TABLE XDEV ADD XDEV_ENABLECOUNTRY NUMBER(1) DEFAULT 0;
COMMENT ON COLUMN XDEV.XDEV_ENABLECOUNTRY IS 'Flag for Creating address with country field from Scanner';