<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table AssetListEntry (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	assetListEntryId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	assetListEntryKey VARCHAR(75) null,
	title VARCHAR(75) null,
	type_ INTEGER,
	assetEntrySubtype VARCHAR(255) null,
	assetEntryType VARCHAR(255) null,
	lastPublishDate DATE null,
	primary key (assetListEntryId, ctCollectionId)
);

create table AssetListEntryAssetEntryRel (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	assetListEntryAssetEntryRelId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	assetListEntryId LONG,
	assetEntryId LONG,
	segmentsEntryId LONG,
	position INTEGER,
	lastPublishDate DATE null,
	primary key (assetListEntryAssetEntryRelId, ctCollectionId)
);

create table AssetListEntrySegmentsEntryRel (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	alEntrySegmentsEntryRelId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	assetListEntryId LONG,
	priority INTEGER,
	segmentsEntryId LONG,
	typeSettings TEXT null,
	lastPublishDate DATE null,
	primary key (alEntrySegmentsEntryRelId, ctCollectionId)
);

create table AssetListEntryUsage (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	assetListEntryUsageId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	classNameId LONG,
	containerKey VARCHAR(255) null,
	containerType LONG,
	key_ VARCHAR(255) null,
	plid LONG,
	type_ INTEGER,
	lastPublishDate DATE null,
	primary key (assetListEntryUsageId, ctCollectionId)
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_D8D58598 on AssetListEntry (groupId, assetEntryType[$COLUMN_LENGTH:255$], assetEntrySubtype[$COLUMN_LENGTH:255$]);
create unique index IX_D3D0EE8D on AssetListEntry (groupId, ctCollectionId, assetListEntryKey[$COLUMN_LENGTH:75$]);
create unique index IX_5856D7F on AssetListEntry (groupId, ctCollectionId, externalReferenceCode[$COLUMN_LENGTH:75$]);
create unique index IX_E08A6DF6 on AssetListEntry (groupId, ctCollectionId, uuid_[$COLUMN_LENGTH:75$]);
create index IX_40A918D0 on AssetListEntry (groupId, title[$COLUMN_LENGTH:75$], assetEntryType[$COLUMN_LENGTH:255$], assetEntrySubtype[$COLUMN_LENGTH:255$]);
create unique index IX_5B95A9C6 on AssetListEntry (groupId, title[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_4FE08A35 on AssetListEntry (groupId, type_);
create index IX_5B11862A on AssetListEntry (uuid_[$COLUMN_LENGTH:75$]);

create index IX_622F04CA on AssetListEntryAssetEntryRel (assetEntryId);
create unique index IX_FAAE938C on AssetListEntryAssetEntryRel (assetListEntryId, segmentsEntryId, position, ctCollectionId);
create unique index IX_A46B1691 on AssetListEntryAssetEntryRel (uuid_[$COLUMN_LENGTH:75$], ctCollectionId, groupId);

create unique index IX_56302677 on AssetListEntrySegmentsEntryRel (assetListEntryId, segmentsEntryId, ctCollectionId);
create index IX_1C9A6A4C on AssetListEntrySegmentsEntryRel (segmentsEntryId);
create unique index IX_AE822E09 on AssetListEntrySegmentsEntryRel (uuid_[$COLUMN_LENGTH:75$], ctCollectionId, groupId);

create index IX_E1D6CA09 on AssetListEntryUsage (classNameId, key_[$COLUMN_LENGTH:255$], companyId);
create unique index IX_512AA275 on AssetListEntryUsage (groupId, classNameId, key_[$COLUMN_LENGTH:255$], plid, containerType, containerKey[$COLUMN_LENGTH:255$], ctCollectionId);
create index IX_10BA153A on AssetListEntryUsage (groupId, classNameId, key_[$COLUMN_LENGTH:255$], type_);
create unique index IX_57EC072B on AssetListEntryUsage (groupId, uuid_[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_BBE5024F on AssetListEntryUsage (plid, containerType, containerKey[$COLUMN_LENGTH:255$]);
create index IX_561E0151 on AssetListEntryUsage (uuid_[$COLUMN_LENGTH:75$]);]]></indexes-sql>
</data>