<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table AnalyticsAssociation (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	analyticsAssociationId LONG not null,
	companyId LONG,
	createDate DATE null,
	modifiedDate DATE null,
	userId LONG,
	associationClassName VARCHAR(75) null,
	associationClassPK LONG,
	className VARCHAR(75) null,
	classPK LONG,
	primary key (analyticsAssociationId, ctCollectionId)
);

create table AnalyticsDeleteMessage (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	analyticsDeleteMessageId LONG not null,
	companyId LONG,
	userId LONG,
	createDate DATE null,
	modifiedDate DATE null,
	className VARCHAR(255) null,
	classPK LONG,
	primary key (analyticsDeleteMessageId, ctCollectionId)
);

create table AnalyticsMessage (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	analyticsMessageId LONG not null,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	body BLOB,
	primary key (analyticsMessageId, ctCollectionId)
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_F25E6543 on AnalyticsAssociation (companyId, associationClassName[$COLUMN_LENGTH:75$], associationClassPK);
create index IX_6431FFA8 on AnalyticsAssociation (companyId, associationClassName[$COLUMN_LENGTH:75$], modifiedDate);

create index IX_3BF42B97 on AnalyticsDeleteMessage (companyId, modifiedDate);

create index IX_3A69CC81 on AnalyticsMessage (companyId);]]></indexes-sql>
</data>