<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table DispatchLog (
	mvccVersion LONG default 0 not null,
	dispatchLogId LONG not null primary key,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	dispatchTriggerId LONG,
	endDate DATE null,
	error TEXT null,
	output_ TEXT null,
	startDate DATE null,
	status INTEGER
);

create table DispatchTrigger (
	mvccVersion LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	dispatchTriggerId LONG not null primary key,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	active_ BOOLEAN,
	cronExpression VARCHAR(75) null,
	dispatchTaskClusterMode INTEGER,
	dispatchTaskExecutorType VARCHAR(75) null,
	dispatchTaskSettings TEXT null,
	endDate DATE null,
	name VARCHAR(75) null,
	overlapAllowed BOOLEAN,
	startDate DATE null,
	system_ BOOLEAN,
	timeZoneId VARCHAR(75) null
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_36F4EB5F on DispatchLog (dispatchTriggerId, status);

create index IX_71D6AFE9 on DispatchTrigger (active_, dispatchTaskClusterMode);
create index IX_1B108A04 on DispatchTrigger (companyId, dispatchTaskExecutorType[$COLUMN_LENGTH:75$]);
create unique index IX_10690B19 on DispatchTrigger (companyId, externalReferenceCode[$COLUMN_LENGTH:75$]);
create unique index IX_D86DCE63 on DispatchTrigger (companyId, name[$COLUMN_LENGTH:75$]);
create index IX_F6ABBDDE on DispatchTrigger (companyId, userId);
create index IX_EF08D30 on DispatchTrigger (uuid_[$COLUMN_LENGTH:75$]);]]></indexes-sql>
</data>