<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table FragmentCollection (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	fragmentCollectionId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	fragmentCollectionKey VARCHAR(75) null,
	name VARCHAR(75) null,
	description STRING null,
	lastPublishDate DATE null,
	primary key (fragmentCollectionId, ctCollectionId)
);

create table FragmentComposition (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	fragmentCompositionId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	fragmentCollectionId LONG,
	fragmentCompositionKey VARCHAR(75) null,
	name VARCHAR(75) null,
	description STRING null,
	data_ TEXT null,
	previewFileEntryId LONG,
	lastPublishDate DATE null,
	status INTEGER,
	statusByUserId LONG,
	statusByUserName VARCHAR(75) null,
	statusDate DATE null,
	primary key (fragmentCompositionId, ctCollectionId)
);

create table FragmentEntry (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	headId LONG,
	head BOOLEAN,
	fragmentEntryId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	fragmentCollectionId LONG,
	fragmentEntryKey VARCHAR(75) null,
	name VARCHAR(75) null,
	css TEXT null,
	html TEXT null,
	js TEXT null,
	cacheable BOOLEAN,
	configuration TEXT null,
	icon VARCHAR(75) null,
	previewFileEntryId LONG,
	readOnly BOOLEAN,
	type_ INTEGER,
	typeOptions TEXT null,
	lastPublishDate DATE null,
	status INTEGER,
	statusByUserId LONG,
	statusByUserName VARCHAR(75) null,
	statusDate DATE null,
	primary key (fragmentEntryId, ctCollectionId)
);

create table FragmentEntryLink (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	fragmentEntryLinkId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	originalFragmentEntryLinkId LONG,
	fragmentEntryId LONG,
	segmentsExperienceId LONG,
	classNameId LONG,
	classPK LONG,
	plid LONG,
	css TEXT null,
	html TEXT null,
	js TEXT null,
	configuration TEXT null,
	deleted BOOLEAN,
	editableValues TEXT null,
	namespace VARCHAR(75) null,
	position INTEGER,
	rendererKey VARCHAR(200) null,
	type_ INTEGER,
	lastPropagationDate DATE null,
	lastPublishDate DATE null,
	primary key (fragmentEntryLinkId, ctCollectionId)
);

create table FragmentEntryVersion (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	fragmentEntryVersionId LONG not null,
	version INTEGER,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	fragmentEntryId LONG,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	fragmentCollectionId LONG,
	fragmentEntryKey VARCHAR(75) null,
	name VARCHAR(75) null,
	css TEXT null,
	html TEXT null,
	js TEXT null,
	cacheable BOOLEAN,
	configuration TEXT null,
	icon VARCHAR(75) null,
	previewFileEntryId LONG,
	readOnly BOOLEAN,
	type_ INTEGER,
	typeOptions TEXT null,
	lastPublishDate DATE null,
	status INTEGER,
	statusByUserId LONG,
	statusByUserName VARCHAR(75) null,
	statusDate DATE null,
	primary key (fragmentEntryVersionId, ctCollectionId)
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create unique index IX_3C778AA9 on FragmentCollection (groupId, ctCollectionId, externalReferenceCode[$COLUMN_LENGTH:75$]);
create unique index IX_9BFCBA4D on FragmentCollection (groupId, ctCollectionId, fragmentCollectionKey[$COLUMN_LENGTH:75$]);
create index IX_536510F5 on FragmentCollection (groupId, name[$COLUMN_LENGTH:75$]);
create unique index IX_AD02299C on FragmentCollection (groupId, uuid_[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_8FB7E9C0 on FragmentCollection (uuid_[$COLUMN_LENGTH:75$]);

create index IX_5C61E2DD on FragmentComposition (fragmentCollectionId);
create unique index IX_CE01B795 on FragmentComposition (groupId, ctCollectionId, externalReferenceCode[$COLUMN_LENGTH:75$]);
create unique index IX_9A26E9A1 on FragmentComposition (groupId, ctCollectionId, fragmentCompositionKey[$COLUMN_LENGTH:75$]);
create index IX_11001AAC on FragmentComposition (groupId, fragmentCollectionId, name[$COLUMN_LENGTH:75$], status);
create index IX_28248B2D on FragmentComposition (groupId, fragmentCollectionId, status);
create unique index IX_5D7BAE88 on FragmentComposition (groupId, uuid_[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_70029354 on FragmentComposition (uuid_[$COLUMN_LENGTH:75$]);

create unique index IX_25B5B355 on FragmentEntry (ctCollectionId, headId);
create index IX_DFBAF515 on FragmentEntry (externalReferenceCode[$COLUMN_LENGTH:75$]);
create index IX_ADC3EFB9 on FragmentEntry (fragmentCollectionId, head);
create index IX_8B622592 on FragmentEntry (groupId, fragmentCollectionId, head, name[$COLUMN_LENGTH:75$]);
create index IX_24159CF8 on FragmentEntry (groupId, fragmentCollectionId, head, status, name[$COLUMN_LENGTH:75$]);
create index IX_14AA0B48 on FragmentEntry (groupId, fragmentCollectionId, head, type_, status);
create index IX_18F9DFE on FragmentEntry (groupId, fragmentCollectionId, name[$COLUMN_LENGTH:75$]);
create index IX_BE29E964 on FragmentEntry (groupId, fragmentCollectionId, status, name[$COLUMN_LENGTH:75$]);
create index IX_BD1F4C5C on FragmentEntry (groupId, fragmentCollectionId, type_, status);
create index IX_7F3F0EB3 on FragmentEntry (groupId, fragmentEntryKey[$COLUMN_LENGTH:75$]);
create unique index IX_8DDC1989 on FragmentEntry (groupId, head, ctCollectionId, externalReferenceCode[$COLUMN_LENGTH:75$]);
create unique index IX_C3F2A8E5 on FragmentEntry (groupId, head, ctCollectionId, fragmentEntryKey[$COLUMN_LENGTH:75$]);
create unique index IX_A420787C on FragmentEntry (groupId, head, uuid_[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_515CC759 on FragmentEntry (head, type_);
create index IX_40CE21AD on FragmentEntry (type_);
create index IX_6E7DE18C on FragmentEntry (uuid_[$COLUMN_LENGTH:75$]);

create index IX_67FF823E on FragmentEntryLink (fragmentEntryId, deleted);
create index IX_2FB5437D on FragmentEntryLink (groupId, classNameId, classPK);
create unique index IX_3CAD70F7 on FragmentEntryLink (groupId, ctCollectionId, externalReferenceCode[$COLUMN_LENGTH:75$]);
create index IX_4A9E751A on FragmentEntryLink (groupId, fragmentEntryId, classNameId, classPK);
create index IX_3D731EF6 on FragmentEntryLink (groupId, plid, deleted);
create index IX_A234739A on FragmentEntryLink (groupId, plid, fragmentEntryId);
create index IX_22C863E3 on FragmentEntryLink (groupId, plid, originalFragmentEntryLinkId);
create index IX_EECD9CBD on FragmentEntryLink (groupId, plid, segmentsExperienceId, deleted);
create index IX_EAA73980 on FragmentEntryLink (groupId, plid, segmentsExperienceId, rendererKey[$COLUMN_LENGTH:200$]);
create index IX_EB688B56 on FragmentEntryLink (groupId, segmentsExperienceId, classNameId, classPK);
create unique index IX_BE3A6BEA on FragmentEntryLink (groupId, uuid_[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_352AE29E on FragmentEntryLink (rendererKey[$COLUMN_LENGTH:200$], companyId);
create index IX_17C15BB2 on FragmentEntryLink (uuid_[$COLUMN_LENGTH:75$]);

create index IX_7A6F05CF on FragmentEntryVersion (fragmentCollectionId, version);
create index IX_391FD151 on FragmentEntryVersion (fragmentEntryId);
create index IX_2509F8CA on FragmentEntryVersion (groupId, fragmentCollectionId, name[$COLUMN_LENGTH:75$]);
create index IX_FD32B830 on FragmentEntryVersion (groupId, fragmentCollectionId, status, name[$COLUMN_LENGTH:75$]);
create index IX_5F305710 on FragmentEntryVersion (groupId, fragmentCollectionId, type_, status);
create index IX_8D72731C on FragmentEntryVersion (groupId, fragmentCollectionId, version, name[$COLUMN_LENGTH:75$]);
create index IX_986CC082 on FragmentEntryVersion (groupId, fragmentCollectionId, version, status, name[$COLUMN_LENGTH:75$]);
create index IX_2B3758FE on FragmentEntryVersion (groupId, fragmentCollectionId, version, type_, status);
create index IX_519A387F on FragmentEntryVersion (groupId, fragmentEntryKey[$COLUMN_LENGTH:75$]);
create unique index IX_2D0AE389 on FragmentEntryVersion (groupId, version, ctCollectionId, fragmentEntryKey[$COLUMN_LENGTH:75$]);
create unique index IX_AF627C58 on FragmentEntryVersion (groupId, version, uuid_[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_850F2979 on FragmentEntryVersion (type_);
create index IX_B2BEE958 on FragmentEntryVersion (uuid_[$COLUMN_LENGTH:75$]);
create unique index IX_F81BA8E3 on FragmentEntryVersion (version, ctCollectionId, fragmentEntryId);
create index IX_75B533A9 on FragmentEntryVersion (version, type_);]]></indexes-sql>
</data>