<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table FriendlyURLEntry (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	defaultLanguageId VARCHAR(75) null,
	friendlyURLEntryId LONG not null,
	groupId LONG,
	companyId LONG,
	createDate DATE null,
	modifiedDate DATE null,
	classNameId LONG,
	classPK LONG,
	primary key (friendlyURLEntryId, ctCollectionId)
);

create table FriendlyURLEntryLocalization (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	friendlyURLEntryLocalizationId LONG not null,
	companyId LONG,
	friendlyURLEntryId LONG,
	languageId VARCHAR(75) null,
	urlTitle VARCHAR(255) null,
	groupId LONG,
	classNameId LONG,
	classPK LONG,
	primary key (friendlyURLEntryLocalizationId, ctCollectionId)
);

create table FriendlyURLEntryMapping (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	friendlyURLEntryMappingId LONG not null,
	companyId LONG,
	classNameId LONG,
	classPK LONG,
	friendlyURLEntryId LONG,
	primary key (friendlyURLEntryMappingId, ctCollectionId)
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_F3DC928B on FriendlyURLEntry (groupId, classNameId, classPK);
create unique index IX_D51F1A48 on FriendlyURLEntry (uuid_[$COLUMN_LENGTH:75$], groupId, ctCollectionId);

create index IX_2B00D1D3 on FriendlyURLEntryLocalization (classNameId, groupId, languageId[$COLUMN_LENGTH:75$], classPK);
create unique index IX_53B5CB4B on FriendlyURLEntryLocalization (classNameId, groupId, languageId[$COLUMN_LENGTH:75$], urlTitle[$COLUMN_LENGTH:255$], ctCollectionId);
create index IX_570320E6 on FriendlyURLEntryLocalization (classNameId, groupId, urlTitle[$COLUMN_LENGTH:255$]);
create index IX_310462C on FriendlyURLEntryLocalization (classNameId, urlTitle[$COLUMN_LENGTH:255$], ctCollectionId, companyId);
create index IX_BFA6E36A on FriendlyURLEntryLocalization (friendlyURLEntryId);
create unique index IX_5292D20F on FriendlyURLEntryLocalization (languageId[$COLUMN_LENGTH:75$], ctCollectionId, friendlyURLEntryId);

create unique index IX_5BE324B9 on FriendlyURLEntryMapping (classNameId, classPK, ctCollectionId);]]></indexes-sql>
</data>