<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table cartable_CasierEntry (
	casierEntryId LONG not null primary key,
	companyId LONG,
	groupId LONG,
	entryId LONG,
	isNew BOOLEAN,
	senderId LONG,
	sendDate DATE null,
	comment_ VARCHAR(75) null,
	replied BOOLEAN,
	replyable BOOLEAN
);

create table cartable_DlLink (
	dlLinkId LONG not null primary key,
	sourceId LONG,
	targetId LONG,
	type_ VARCHAR(75) null
);

create table cartable_FileTag (
	fileTagId LONG not null primary key,
	dlFileEntryId LONG,
	tagList VARCHAR(75) null,
	linkList VARCHAR(75) null,
	keywordList VARCHAR(75) null
);

create table cartable_FileVersion (
	fileVersionId LONG not null primary key,
	dlFileEntryId LONG,
	version DOUBLE,
	comment_ VARCHAR(75) null,
	downloadCount LONG,
	viewCount LONG
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_DD50AF4 on cartable_CasierEntry (companyId, groupId);
create index IX_448D5CA9 on cartable_CasierEntry (companyId, groupId, entryId);
create index IX_BA1E7FD2 on cartable_CasierEntry (companyId, groupId, isNew);

create index IX_CCA877FE on cartable_DlLink (sourceId, type_);
create index IX_55AD08C8 on cartable_DlLink (targetId, type_);

create index IX_68F57BDA on cartable_FileTag (dlFileEntryId);

create index IX_71B3A9DC on cartable_FileVersion (dlFileEntryId);
create index IX_D98823AC on cartable_FileVersion (dlFileEntryId, version);]]></indexes-sql>
</data>