<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table CPDVirtualSettingFileEntry (
	mvccVersion LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	CPDVirtualSettingFileEntryId LONG not null primary key,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	CPDefinitionVirtualSettingId LONG,
	fileEntryId LONG,
	url VARCHAR(255) null,
	version VARCHAR(75) null
);

create table CPDefinitionVirtualSetting (
	mvccVersion LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	CPDefinitionVirtualSettingId LONG not null primary key,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	classNameId LONG,
	classPK LONG,
	activationStatus INTEGER,
	duration LONG,
	maxUsages INTEGER,
	useSample BOOLEAN,
	sampleFileEntryId LONG,
	sampleURL VARCHAR(255) null,
	termsOfUseRequired BOOLEAN,
	termsOfUseContent STRING null,
	termsOfUseArticleResourcePK LONG,
	override BOOLEAN,
	lastPublishDate DATE null
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_C606354 on CPDVirtualSettingFileEntry (CPDefinitionVirtualSettingId);
create index IX_B9327D21 on CPDVirtualSettingFileEntry (fileEntryId);
create unique index IX_762A2056 on CPDVirtualSettingFileEntry (uuid_[$COLUMN_LENGTH:75$], groupId);

create unique index IX_19B2FD20 on CPDefinitionVirtualSetting (classNameId, classPK);
create unique index IX_8ED43481 on CPDefinitionVirtualSetting (uuid_[$COLUMN_LENGTH:75$], groupId);]]></indexes-sql>
</data>