<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table CSDiagramEntry (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	CSDiagramEntryId LONG not null,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	CPDefinitionId LONG,
	CPInstanceId LONG,
	CProductId LONG,
	diagram BOOLEAN,
	quantity INTEGER,
	sequence VARCHAR(75) null,
	sku VARCHAR(75) null,
	primary key (CSDiagramEntryId, ctCollectionId)
);

create table CSDiagramPin (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	CSDiagramPinId LONG not null,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	CPDefinitionId LONG,
	positionX DOUBLE,
	positionY DOUBLE,
	sequence VARCHAR(75) null,
	primary key (CSDiagramPinId, ctCollectionId)
);

create table CSDiagramSetting (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	CSDiagramSettingId LONG not null,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	CPAttachmentFileEntryId LONG,
	CPDefinitionId LONG,
	color VARCHAR(75) null,
	radius DOUBLE,
	type_ VARCHAR(75) null,
	primary key (CSDiagramSettingId, ctCollectionId)
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create unique index IX_4748C557 on CSDiagramEntry (CPDefinitionId, sequence[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_129C0EC6 on CSDiagramEntry (CPInstanceId);
create index IX_E1E7EA90 on CSDiagramEntry (CProductId);

create index IX_B0DD2127 on CSDiagramPin (CPDefinitionId);

create unique index IX_4F753100 on CSDiagramSetting (CPDefinitionId, ctCollectionId);
create index IX_BCB38741 on CSDiagramSetting (uuid_[$COLUMN_LENGTH:75$]);]]></indexes-sql>
</data>