<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table actualites_BlogEntryDelegate (
	blogEntryDelegateId LONG not null primary key,
	userId LONG,
	headMasterDelegate BOOLEAN,
	etabId LONG
);

create table actualites_BlogEntryInfos (
	blogEntryInfosId LONG not null primary key,
	blogEntryId LONG,
	headMaster BOOLEAN,
	highPriority BOOLEAN,
	groupId LONG,
	expirationDate DATE null,
	parutionDate DATE null,
	categorie INTEGER,
	imageId LONG,
	blogEntryGroup LONG,
	flashFileState VARCHAR(75) null,
	intranetNews BOOLEAN,
	lastEditorId LONG,
	priority BOOLEAN
);

create table actualites_ConfirmReadBlogEntry (
	confirmReadPK LONG not null primary key,
	blogEntryInfosId LONG,
	userId LONG
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_8445A362 on actualites_BlogEntryDelegate (etabId);
create index IX_D527109D on actualites_BlogEntryDelegate (userId);

create index IX_9BA729D6 on actualites_BlogEntryInfos (blogEntryGroup);
create index IX_488237C8 on actualites_BlogEntryInfos (blogEntryId);
create index IX_72F2A994 on actualites_BlogEntryInfos (categorie);
create index IX_7AC11EE4 on actualites_BlogEntryInfos (expirationDate);
create index IX_98F5BE57 on actualites_BlogEntryInfos (groupId);
create index IX_71C15CE7 on actualites_BlogEntryInfos (highPriority, headMaster, groupId);
create index IX_1C6263BF on actualites_BlogEntryInfos (highPriority, headMaster, groupId, priority);

create index IX_FA71457C on actualites_ConfirmReadBlogEntry (blogEntryInfosId);
create index IX_2A0E2B36 on actualites_ConfirmReadBlogEntry (userId, blogEntryInfosId);]]></indexes-sql>
</data>