<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table BookmarksEntry (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	entryId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	folderId LONG,
	treePath STRING null,
	name VARCHAR(255) null,
	url STRING null,
	description STRING null,
	priority INTEGER,
	lastPublishDate DATE null,
	status INTEGER,
	statusByUserId LONG,
	statusByUserName VARCHAR(75) null,
	statusDate DATE null,
	primary key (entryId, ctCollectionId)
);

create table BookmarksFolder (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	folderId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	parentFolderId LONG,
	treePath STRING null,
	name VARCHAR(75) null,
	description STRING null,
	lastPublishDate DATE null,
	status INTEGER,
	statusByUserId LONG,
	statusByUserName VARCHAR(75) null,
	statusDate DATE null,
	primary key (folderId, ctCollectionId)
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_1F90CA2D on BookmarksEntry (companyId);
create index IX_5200100C on BookmarksEntry (groupId, folderId);
create index IX_69D78EAC on BookmarksEntry (groupId, status, folderId, userId);
create index IX_37518B0F on BookmarksEntry (groupId, status, userId);
create unique index IX_788BA343 on BookmarksEntry (groupId, uuid_[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_F16A8A87 on BookmarksEntry (status, companyId);
create index IX_B670BA39 on BookmarksEntry (uuid_[$COLUMN_LENGTH:75$]);

create index IX_2ABA25D7 on BookmarksFolder (companyId);
create index IX_D16018A6 on BookmarksFolder (groupId, parentFolderId, status);
create unique index IX_F2715D9 on BookmarksFolder (groupId, uuid_[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_8C7A9C31 on BookmarksFolder (status, companyId);
create index IX_451E7AE3 on BookmarksFolder (uuid_[$COLUMN_LENGTH:75$]);]]></indexes-sql>
</data>