--UPDATE FROM 8.7.4.9 TO 8.7.4.10


DROP TABLE VERSION_8_7_4_9;



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

ALTER TABLE WNEB ADD WNEB_HOTELDATE DATE;

ALTER TABLE WNAE ADD WNAE_DISPLORDER NUMBER(3);

UPDATE WNAE W SET W.WNAE_DISPLORDER=(SELECT COUNT(1) FROM WNAE WW WHERE WW.WNAE_ID<W.WNAE_ID);
