<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table BlogPodcast_BlogCategory (
	categoryId LONG not null primary key,
	parentCategoryId LONG,
	channelId LONG,
	groupId LONG,
	userId LONG,
	title VARCHAR(75) null
);

create table BlogPodcast_BlogChannel (
	channelId LONG not null primary key,
	groupId LONG,
	userId LONG,
	title VARCHAR(75) null,
	description VARCHAR(75) null,
	pubDate DATE null,
	lastBuildDate DATE null,
	configuration VARCHAR(75) null,
	topBand VARCHAR(75) null,
	active_ BOOLEAN
);

create table BlogPodcast_BlogItem (
	itemId LONG not null primary key,
	companyId LONG,
	channelId LONG,
	groupId LONG,
	userId LONG,
	categoryId LONG,
	title VARCHAR(75) null,
	description VARCHAR(75) null,
	pubDate DATE null
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_336A1A2B on BlogPodcast_BlogCategory (channelId);
create index IX_7B22F867 on BlogPodcast_BlogCategory (groupId);
create index IX_379AFC1A on BlogPodcast_BlogCategory (parentCategoryId);
create index IX_FB1E8DD on BlogPodcast_BlogCategory (userId);

create index IX_C8983E20 on BlogPodcast_BlogChannel (groupId);
create index IX_8E108804 on BlogPodcast_BlogChannel (userId);

create index IX_1C64AAE5 on BlogPodcast_BlogItem (categoryId);
create index IX_EB6F5F76 on BlogPodcast_BlogItem (categoryId, pubDate);
create index IX_A50FEEB6 on BlogPodcast_BlogItem (channelId);
create index IX_9BB4D6C5 on BlogPodcast_BlogItem (channelId, pubDate);
create index IX_766B6130 on BlogPodcast_BlogItem (companyId);
create index IX_F4BA73B2 on BlogPodcast_BlogItem (groupId);
create index IX_A1EA2D49 on BlogPodcast_BlogItem (groupId, pubDate);
create index IX_5EB797C3 on BlogPodcast_BlogItem (pubDate);
create index IX_3CE85832 on BlogPodcast_BlogItem (userId);
create index IX_C9D558C9 on BlogPodcast_BlogItem (userId, pubDate);]]></indexes-sql>
</data>