<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table Marketplace_App (
	uuid_ VARCHAR(75) null,
	appId LONG not null primary key,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	remoteAppId LONG,
	title VARCHAR(75) null,
	description STRING null,
	category VARCHAR(75) null,
	iconURL STRING null,
	version VARCHAR(75) null,
	required BOOLEAN
);

create table Marketplace_Module (
	uuid_ VARCHAR(75) null,
	moduleId LONG not null primary key,
	companyId LONG,
	appId LONG,
	bundleSymbolicName VARCHAR(500) null,
	bundleVersion VARCHAR(75) null,
	contextName VARCHAR(75) null
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_94A7EF25 on Marketplace_App (category[$COLUMN_LENGTH:75$]);
create index IX_865B7BD5 on Marketplace_App (companyId);
create index IX_20F14D93 on Marketplace_App (remoteAppId);
create index IX_A7807DA7 on Marketplace_App (uuid_[$COLUMN_LENGTH:75$], companyId);

create index IX_5848F52D on Marketplace_Module (appId, bundleSymbolicName[$COLUMN_LENGTH:500$], bundleVersion[$COLUMN_LENGTH:75$]);
create index IX_C6938724 on Marketplace_Module (appId, contextName[$COLUMN_LENGTH:75$]);
create index IX_DD03D499 on Marketplace_Module (bundleSymbolicName[$COLUMN_LENGTH:500$]);
create index IX_F2F1E964 on Marketplace_Module (contextName[$COLUMN_LENGTH:75$]);
create index IX_896A375A on Marketplace_Module (uuid_[$COLUMN_LENGTH:75$], companyId);]]></indexes-sql>
</data>