Initial Contribution
Signed-off-by: Vinay Vishal <vinay.vishal@oracle.com>
diff --git a/appserver/tests/appserv-tests/devtests/batch/batch_derby.sql b/appserver/tests/appserv-tests/devtests/batch/batch_derby.sql
new file mode 100644
index 0000000..7a8f5c1
--- /dev/null
+++ b/appserver/tests/appserv-tests/devtests/batch/batch_derby.sql
@@ -0,0 +1,12 @@
+DROP TABLE JOBSTATUS
+CREATE TABLE JOBSTATUS(id BIGINT, obj BLOB)
+DROP TABLE STEPSTATUS
+CREATE TABLE STEPSTATUS(id VARCHAR(512), obj BLOB)
+DROP TABLE CHECKPOINTDATA
+CREATE TABLE CHECKPOINTDATA(id VARCHAR(512), obj BLOB)
+DROP TABLE JOBINSTANCEDATA
+CREATE TABLE JOBINSTANCEDATA(id VARCHAR(512), obj BLOB)
+DROP TABLE EXECUTIONINSTANCEDATA
+CREATE TABLE EXECUTIONINSTANCEDATA(id VARCHAR(512), createtime TIMESTAMP, starttime TIMESTAMP, endtime TIMESTAMP, updatetime TIMESTAMP, parameters BLOB, jobinstanceid VARCHAR(512), batchstatus BLOB, exitstatus BLOB)
+DROP TABLE STEPEXECUTIONINSTANCEDATA
+CREATE TABLE STEPEXECUTIONINSTANCEDATA(id VARCHAR(512), jobexecid VARCHAR(512), stepexecid VARCHAR(512))
\ No newline at end of file
