--UPDATE FROM 8.7.4.1 TO 8.7.4.2


DROP TABLE VERSION_8_7_4_1;



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

CREATE TABLE ZCOX
(
  ZCOX_ID        NUMBER(30), 
  ZCOX_YRES_ID   NUMBER(30),
  ZCOX_ZFAC_ID   NUMBER(30),
  ZCOX_USER_XCMS_ID NUMBER(30),
  ZCOX_WPCA_ID   NUMBER(30),
  ZCOX_COSTART   DATE
  ,CONSTRAINT ZCOX_PK PRIMARY KEY (ZCOX_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8MAIN;
  
COMMENT ON TABLE ZCOX IS 'Track table for checkout, to see if V8 was killed during C/O and it wasn''t properly completed';  

CREATE SEQUENCE SEQ_ZCOX INCREMENT BY 1 START WITH 1000 NOMAXVALUE NOCYCLE NOCACHE NOORDER;
