--UPDATE FROM 8.7.4.10 TO 8.7.4.11


DROP TABLE VERSION_8_7_4_10;



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

CREATE TABLE ZTAP 
  (ZTAP_ID       		NUMBER(30) NOT NULL
  ,ZTAP_ZTAA_ID  		NUMBER(30) NOT NULL
  ,ZTAP_ZTAK_ID  		NUMBER(30) NOT NULL
  ,ZTAP_CUSTOMER_ZDCO_ID  	NUMBER(30) NULL
  ,ZTAP_MASTER_ZDCO_ID  	NUMBER(30) NULL
  ,ZTAP_VALUE 	 		NUMBER(30,4) NOT NULL
  ,CONSTRAINT ZTAP_PK PRIMARY KEY (ZTAP_ID) USING INDEX TABLESPACE V8INDEX) TABLESPACE V8CONF;
  
CREATE SEQUENCE SEQ_ZTAP INCREMENT BY 1 START WITH 1000 NOMAXVALUE NOCYCLE NOCACHE NOORDER;
