--UPDATE FROM 8.6.0.6 TO 8.6.0.8


DROP TABLE VERSION_8_6_0_6;



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


UPDATE ZFAG SET ZFAG_TYPE=0 WHERE ZFAG_TYPE IS NULL;


ALTER TABLE ZFAG ADD ( ZFAG_AUTOCHECKOUT NUMBER(1) NULL  );

ALTER TABLE ZFAG ADD ( ZFAG_AUTOCHECKOUT_ZDCO_ID NUMBER(30,4) NULL  );

ALTER TABLE MCFG ADD ( MCFG_HTTP_STATUS_INTERVAL NUMBER(5) NULL  );

ALTER TABLE MMOD ADD ( MMOD_HTTP_PROXYSERVER VARCHAR2(100) NULL  );

ALTER TABLE MMOD ADD ( MMOD_HTTP_STATUS_URL VARCHAR2(100) NULL  );

ALTER TABLE MMOD ADD ( MMOD_HTTP_STATUS_PROXYSERVER VARCHAR2(100) NULL  );

ALTER TABLE MMOD ADD ( MMOD_HTTP_STATUS_PROXYUSER VARCHAR2(30) NULL  );

ALTER TABLE MMOD ADD ( MMOD_HTTP_STATUS_PROXYPWD VARCHAR2(30) NULL  );

ALTER TABLE MMOD ADD ( MMOD_RES_DOWNLOAD NUMBER(1) NULL  );

ALTER TABLE MMOD ADD ( MMOD_RATES_DOWNLOAD NUMBER(1) NULL  );

ALTER TABLE MMOD ADD ( MMOD_RAVL_DOWNLOAD NUMBER(1) NULL  );

ALTER TABLE MMOD ADD ( MMOD_BLOCK_DOWNLOAD NUMBER(1) NULL  );

ALTER TABLE WSPS ADD ( WSPS_DISABLED NUMBER(1) NULL  );
