1 2DROP TABLE JOBSTATUS; 3 4DROP TABLE STEPSTATUS; 5 6DROP TABLE CHECKPOINTDATA; 7 8DROP TABLE JOBINSTANCEDATA; 9 10DROP TABLE EXECUTIONINSTANCEDATA; 11 12DROP TABLE STEPEXECUTIONINSTANCEDATA; 13 14CREATE TABLE JOBINSTANCEDATA( 15 jobinstanceid serial not null PRIMARY KEY, 16 name character varying (512), 17 apptag VARCHAR(512) 18); 19 20CREATE TABLE EXECUTIONINSTANCEDATA( 21 jobexecid serial not null PRIMARY KEY, 22 jobinstanceid bigint not null REFERENCES JOBINSTANCEDATA (jobinstanceid), 23 createtime timestamp, 24 starttime timestamp, 25 endtime timestamp, 26 updatetime timestamp, 27 parameters bytea, 28 batchstatus character varying (512), 29 exitstatus character varying (512) 30); 31 32CREATE TABLE STEPEXECUTIONINSTANCEDATA( 33 stepexecid serial not null PRIMARY KEY, 34 jobexecid bigint not null REFERENCES EXECUTIONINSTANCEDATA (jobexecid), 35 batchstatus character varying (512), 36 exitstatus character varying (512), 37 stepname character varying (512), 38 readcount integer, 39 writecount integer, 40 commitcount integer, 41 rollbackcount integer, 42 readskipcount integer, 43 processskipcount integer, 44 filtercount integer, 45 writeskipcount integer, 46 startTime timestamp, 47 endTime timestamp, 48 persistentData bytea 49); 50 51CREATE TABLE JOBSTATUS ( 52 id bigint not null REFERENCES JOBINSTANCEDATA (jobinstanceid), 53 obj bytea 54); 55 56CREATE TABLE STEPSTATUS( 57 id bigint not null REFERENCES STEPEXECUTIONINSTANCEDATA (stepexecid), 58 obj bytea 59); 60 61CREATE TABLE CHECKPOINTDATA( 62 id character varying (512), 63 obj bytea 64); 65 66 67