<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table LayoutSEOEntry (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	layoutSEOEntryId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	privateLayout BOOLEAN,
	layoutId LONG,
	canonicalURL STRING null,
	canonicalURLEnabled BOOLEAN,
	DDMStorageId LONG,
	openGraphDescription STRING null,
	openGraphDescriptionEnabled BOOLEAN,
	openGraphImageAlt STRING null,
	openGraphImageFileEntryId LONG,
	openGraphTitle STRING null,
	openGraphTitleEnabled BOOLEAN,
	lastPublishDate DATE null,
	primary key (layoutSEOEntryId, ctCollectionId)
);

create table LayoutSEOSite (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	layoutSEOSiteId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	openGraphEnabled BOOLEAN,
	openGraphImageAlt STRING null,
	openGraphImageFileEntryId LONG,
	primary key (layoutSEOSiteId, ctCollectionId)
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create unique index IX_962A7193 on LayoutSEOEntry (groupId, ctCollectionId, privateLayout, layoutId);
create unique index IX_63195F59 on LayoutSEOEntry (uuid_[$COLUMN_LENGTH:75$], groupId, ctCollectionId);

create unique index IX_E4DFAF28 on LayoutSEOSite (groupId, ctCollectionId);]]></indexes-sql>
</data>