<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table RedirectEntry (
	mvccVersion LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	redirectEntryId LONG not null primary key,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	destinationURL STRING null,
	expirationDate DATE null,
	lastOccurrenceDate DATE null,
	permanent_ BOOLEAN,
	sourceURL STRING null
);

create table RedirectNotFoundEntry (
	mvccVersion LONG default 0 not null,
	redirectNotFoundEntryId LONG not null primary key,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	ignored BOOLEAN,
	url STRING null
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_106FBFC3 on RedirectEntry (groupId, destinationURL[$COLUMN_LENGTH:4000$]);
create unique index IX_5040C136 on RedirectEntry (groupId, sourceURL[$COLUMN_LENGTH:4000$]);
create unique index IX_E33009E6 on RedirectEntry (groupId, uuid_[$COLUMN_LENGTH:75$]);
create index IX_90CD5218 on RedirectEntry (uuid_[$COLUMN_LENGTH:75$]);

create unique index IX_84671762 on RedirectNotFoundEntry (groupId, url[$COLUMN_LENGTH:4000$]);]]></indexes-sql>
</data>