--UPDATE FROM 8.10.0.10 TO 8.10.0.20


DROP TABLE VERSION_8_10_0_10;


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


ALTER TABLE MMOD MODIFY MMOD_HTTP_PWD VARCHAR2(100);

ALTER TABLE MMOD MODIFY MMOD_AUTH_PWD VARCHAR2(100);

ALTER TABLE MMOD MODIFY MMOD_HTTP_PROXYPWD VARCHAR2(100);

ALTER TABLE WFTP MODIFY WFTP_PASSWORD VARCHAR2(100);

ALTER TABLE ZOTA MODIFY ZOTA_HTTP_PWD VARCHAR2(100);

ALTER TABLE ZOTA ADD ZOTA_XMLIFC_COMP NUMBER(1) default 0;

COMMENT ON COLUMN ZOTA.ZOTA_XMLIFC_COMP IS 'Indicates, whether OTA XML Interface uploads message from IXMLDocument text attribute or directly from the OTA XML object. Makes difference in handling of german umlaute -> UTF-8 versus ANSI'; 

ALTER TABLE YGCO ADD YGCO_NOTINBLOCK NUMBER(1) default 0 not null;

COMMENT ON COLUMN YGCO.YGCO_NOTINBLOCK IS 'Codes with this setting enabled are not shown in the drop down list in Policylist Edit in block header';

ALTER TABLE YCDP ADD YCDP_NOTINBLOCK NUMBER(1);

COMMENT ON COLUMN YCDP.YCDP_NOTINBLOCK is 'Codes with this setting enabled are not shown in the drop down list in Policylist Edit in block header';
