<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table SiteNavigationMenu (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	siteNavigationMenuId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	name VARCHAR(75) null,
	type_ INTEGER,
	auto_ BOOLEAN,
	lastPublishDate DATE null,
	primary key (siteNavigationMenuId, ctCollectionId)
);

create table SiteNavigationMenuItem (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	siteNavigationMenuItemId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	siteNavigationMenuId LONG,
	parentSiteNavigationMenuItemId LONG,
	name VARCHAR(255) null,
	type_ VARCHAR(75) null,
	typeSettings TEXT null,
	order_ INTEGER,
	lastPublishDate DATE null,
	primary key (siteNavigationMenuItemId, ctCollectionId)
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_68E2B208 on SiteNavigationMenu (companyId);
create index IX_1D786176 on SiteNavigationMenu (groupId, auto_);
create unique index IX_710D4B55 on SiteNavigationMenu (groupId, ctCollectionId, externalReferenceCode[$COLUMN_LENGTH:75$]);
create unique index IX_4EE39EA7 on SiteNavigationMenu (groupId, ctCollectionId, name[$COLUMN_LENGTH:75$]);
create index IX_ECBADAC9 on SiteNavigationMenu (groupId, name[$COLUMN_LENGTH:75$]);
create index IX_1125400B on SiteNavigationMenu (groupId, type_);
create unique index IX_9BA6C248 on SiteNavigationMenu (groupId, uuid_[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_828EC794 on SiteNavigationMenu (uuid_[$COLUMN_LENGTH:75$]);

create index IX_B88C2AB5 on SiteNavigationMenuItem (companyId);
create unique index IX_6542AAC8 on SiteNavigationMenuItem (groupId, ctCollectionId, externalReferenceCode[$COLUMN_LENGTH:75$]);
create index IX_75495C39 on SiteNavigationMenuItem (parentSiteNavigationMenuItemId);
create index IX_9FA7003B on SiteNavigationMenuItem (siteNavigationMenuId, name[$COLUMN_LENGTH:255$]);
create index IX_2294C622 on SiteNavigationMenuItem (siteNavigationMenuId, parentSiteNavigationMenuItemId);
create unique index IX_CD998367 on SiteNavigationMenuItem (uuid_[$COLUMN_LENGTH:75$], groupId, ctCollectionId);]]></indexes-sql>
</data>