<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table MicroblogsEntry (
	microblogsEntryId LONG not null primary key,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	content STRING null,
	type_ INTEGER,
	receiverUserId LONG,
	receiverMicroblogsEntryId LONG,
	socialRelationType INTEGER
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_837C013D on MicroblogsEntry (companyId);
create index IX_36CA3D37 on MicroblogsEntry (type_, receiverMicroblogsEntryId);
create index IX_7ABB0AB3 on MicroblogsEntry (type_, receiverUserId);
create index IX_6C297B45 on MicroblogsEntry (userId);
create index IX_92BA6F0 on MicroblogsEntry (userId, type_);]]></indexes-sql>
</data>