-- Autogenerated: do not edit this file

CREATE TABLE BATCH_JOB_INSTANCE  (
	JOB_INSTANCE_ID ${BIGINT} $!{IDENTITY} NOT NULL PRIMARY KEY $!{GENERATED},
	VERSION ${BIGINT} $!{NULL},
	JOB_NAME ${VARCHAR}(100) NOT NULL,
	JOB_KEY ${VARCHAR}(32) NOT NULL,
	constraint JOB_INST_UN unique (JOB_NAME, JOB_KEY)
) $!{VOODOO};

CREATE TABLE BATCH_JOB_EXECUTION  (
	JOB_EXECUTION_ID ${BIGINT} $!{IDENTITY} NOT NULL PRIMARY KEY $!{GENERATED},
	VERSION ${BIGINT}  $!{NULL},
	JOB_INSTANCE_ID ${BIGINT} NOT NULL,
	CREATE_TIME ${TIMESTAMP} NOT NULL,
	START_TIME ${TIMESTAMP} DEFAULT NULL $!{NULL},
	END_TIME ${TIMESTAMP} DEFAULT NULL $!{NULL},
	STATUS ${VARCHAR}(10) $!{NULL},
	EXIT_CODE ${VARCHAR}(2500) $!{NULL},
	EXIT_MESSAGE ${VARCHAR}(2500) $!{NULL},
	LAST_UPDATED ${TIMESTAMP},
	JOB_CONFIGURATION_LOCATION ${VARCHAR}(2500) $!{NULL},
	constraint JOB_INST_EXEC_FK foreign key (JOB_INSTANCE_ID)
	references BATCH_JOB_INSTANCE(JOB_INSTANCE_ID)
) $!{VOODOO};

CREATE TABLE BATCH_JOB_EXECUTION_PARAMS  (
	JOB_EXECUTION_ID ${BIGINT} NOT NULL ,
	TYPE_CD ${VARCHAR}(6) NOT NULL ,
	KEY_NAME ${VARCHAR}(100) NOT NULL ,
	STRING_VAL ${VARCHAR}(250) $!{NULL},
	DATE_VAL ${TIMESTAMP} DEFAULT NULL $!{NULL},
	LONG_VAL ${BIGINT} $!{NULL},
	DOUBLE_VAL ${DOUBLE} $!{NULL},
	IDENTIFYING ${CHAR}(1) NOT NULL ,
	constraint JOB_EXEC_PARAMS_FK foreign key (JOB_EXECUTION_ID)
	references BATCH_JOB_EXECUTION(JOB_EXECUTION_ID)
) $!{VOODOO};

CREATE TABLE BATCH_STEP_EXECUTION  (
	STEP_EXECUTION_ID ${BIGINT} $!{IDENTITY} NOT NULL PRIMARY KEY $!{GENERATED},
	VERSION ${BIGINT} NOT NULL,
	STEP_NAME ${VARCHAR}(100) NOT NULL,
	JOB_EXECUTION_ID ${BIGINT} NOT NULL,
	START_TIME ${TIMESTAMP} NOT NULL ,
	END_TIME ${TIMESTAMP} DEFAULT NULL $!{NULL},
	STATUS ${VARCHAR}(10) $!{NULL},
	COMMIT_COUNT ${BIGINT} $!{NULL},
	READ_COUNT ${BIGINT} $!{NULL},
	FILTER_COUNT ${BIGINT} $!{NULL},
	WRITE_COUNT ${BIGINT} $!{NULL},
	READ_SKIP_COUNT ${BIGINT} $!{NULL},
	WRITE_SKIP_COUNT ${BIGINT} $!{NULL},
	PROCESS_SKIP_COUNT ${BIGINT} $!{NULL},
	ROLLBACK_COUNT ${BIGINT} $!{NULL},
	EXIT_CODE ${VARCHAR}(2500) $!{NULL},
	EXIT_MESSAGE ${VARCHAR}(2500) $!{NULL},
	LAST_UPDATED ${TIMESTAMP},
	constraint JOB_EXEC_STEP_FK foreign key (JOB_EXECUTION_ID)
	references BATCH_JOB_EXECUTION(JOB_EXECUTION_ID)
) $!{VOODOO};

CREATE TABLE BATCH_STEP_EXECUTION_CONTEXT  (
	STEP_EXECUTION_ID ${BIGINT} NOT NULL PRIMARY KEY,
	SHORT_CONTEXT ${VARCHAR}(2500) NOT NULL,
	SERIALIZED_CONTEXT ${CLOB} $!{NULL},
	constraint STEP_EXEC_CTX_FK foreign key (STEP_EXECUTION_ID)
	references BATCH_STEP_EXECUTION(STEP_EXECUTION_ID)
) $!{VOODOO};

CREATE TABLE BATCH_JOB_EXECUTION_CONTEXT  (
	JOB_EXECUTION_ID ${BIGINT} NOT NULL PRIMARY KEY,
	SHORT_CONTEXT ${VARCHAR}(2500) NOT NULL,
	SERIALIZED_CONTEXT ${CLOB} $!{NULL},
	constraint JOB_EXEC_CTX_FK foreign key (JOB_EXECUTION_ID)
	references BATCH_JOB_EXECUTION(JOB_EXECUTION_ID)
) $!{VOODOO};

#sequence( "BATCH_STEP_EXECUTION_SEQ" 0)
#sequence( "BATCH_JOB_EXECUTION_SEQ" 0)
#sequence( "BATCH_JOB_SEQ" 0)
