--UPDATE FROM 8.7.4.6 TO 8.7.4.7


DROP TABLE VERSION_8_7_4_6;



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

ALTER TABLE YPOL ADD YPOL_XCMS_ID NUMBER(30);

UPDATE YPOL SET YPOL_XCMS_ID = (SELECT YRES_XCMS_ID FROM YRES WHERE YRES_ID = YPOL_YRES_ID) WHERE YPOL_XCMS_ID IS NULL;

ALTER TABLE YPOL MODIFY YPOL_XCMS_ID NOT NULL;
