--UPDATE FROM 8.7.4.8 TO 8.7.4.9


DROP TABLE VERSION_8_7_4_8;



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

ALTER TABLE WERR MODIFY WERR_HOTELID VARCHAR2(100);

ALTER TABLE WERR MODIFY WERR_DBID VARCHAR2(100);

CREATE TABLE WNEB (
   WNEB_TIMESTAMP DATE NOT NULL
) TABLESPACE V8MAIN;

COMMENT ON TABLE WNEB IS 'NIGHT AUDIT TEXT EXPORT BATCH TIMESTAMPS';

ALTER TABLE WNAE ADD WNAE_BATCHFILENAME VARCHAR2(500);

ALTER TABLE WNAE ADD WNAE_DELETEAFTERMOVEDTOBATCH NUMBER(1);
