<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table BatchPlannerMapping (
	mvccVersion LONG default 0 not null,
	batchPlannerMappingId LONG not null primary key,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	batchPlannerPlanId LONG,
	externalFieldName VARCHAR(75) null,
	externalFieldType VARCHAR(75) null,
	internalFieldName VARCHAR(75) null,
	internalFieldType VARCHAR(75) null,
	script TEXT null
);

create table BatchPlannerPlan (
	mvccVersion LONG default 0 not null,
	batchPlannerPlanId LONG not null primary key,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	active_ BOOLEAN,
	export BOOLEAN,
	externalType VARCHAR(75) null,
	externalURL STRING null,
	internalClassName VARCHAR(75) null,
	name VARCHAR(75) null,
	size_ INTEGER,
	taskItemDelegateName VARCHAR(75) null,
	total INTEGER,
	template BOOLEAN,
	status INTEGER
);

create table BatchPlannerPolicy (
	mvccVersion LONG default 0 not null,
	batchPlannerPolicyId LONG not null primary key,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	batchPlannerPlanId LONG,
	name VARCHAR(75) null,
	value VARCHAR(75) null
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create unique index IX_E025DC1A on BatchPlannerMapping (batchPlannerPlanId, externalFieldName[$COLUMN_LENGTH:75$], internalFieldName[$COLUMN_LENGTH:75$]);

create index IX_18CD7477 on BatchPlannerPlan (companyId, export, template);
create index IX_221A54A0 on BatchPlannerPlan (companyId, name[$COLUMN_LENGTH:75$]);
create index IX_F2F05D4F on BatchPlannerPlan (companyId, template);
create index IX_874FA8DB on BatchPlannerPlan (companyId, userId);

create unique index IX_A8E0209F on BatchPlannerPolicy (batchPlannerPlanId, name[$COLUMN_LENGTH:75$]);]]></indexes-sql>
</data>