--UPDATE FROM 8.7.3.2 TO 8.7.3.3


DROP TABLE VERSION_8_7_3_2;



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


DROP TABLE MWSV CASCADE CONSTRAINTS;

UPDATE YPAC SET YPAC_TOTIME=TO_DATE('30.12.1899 23:59:59','dd.mm.yyyy HH24:MI:SS') WHERE YPAC_ALLOWANCED=1 AND (YPAC_TOTIME IS NULL OR YPAC_TOTIME=TRUNC(YPAC_TOTIME));

UPDATE ZALL SET ZALL_TOTIME=TO_DATE('30.12.1899 23:59:59','dd.mm.yyyy HH24:MI:SS') WHERE ZALL_TOTIME=TRUNC(ZALL_TOTIME);

UPDATE MMOD SET MMOD.MMOD_HTTP_DOWNLOAD=MMOD.MMOD_ONEWAY WHERE MMOD.MMOD_HTTP_DOWNLOAD IS NULL;
