<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table gestionMenus_EntityMenu (
	entityId LONG not null primary key,
	etabId LONG,
	entityName VARCHAR(75) null,
	appRoleId LONG,
	nodePath VARCHAR(75) null,
	isLeaf BOOLEAN,
	orderEntity INTEGER,
	styleEntity STRING null,
	imageId LONG,
	category VARCHAR(250) null,
	orderEntityFullScreen INTEGER,
	defaultIconClass VARCHAR(75) null
);

create table gestionMenus_InternationalMenu (
	iternationalMenuId LONG not null primary key,
	entityMenuId LONG,
	locale VARCHAR(75) null,
	menuName VARCHAR(75) null
);

create table gestionMenus_LinkEtab (
	linkEtabId LONG not null primary key,
	etabId LONG,
	name VARCHAR(75) null,
	url VARCHAR(255) null,
	style VARCHAR(200) null,
	orders INTEGER
);

create table gestionMenus_MenuIconMapping (
	appRoleId LONG not null primary key,
	defaultIconClass VARCHAR(75) null
);

create table gestionMenus_PronoteLink (
	pronoteLinkId LONG not null primary key,
	userId LONG,
	name VARCHAR(75) null,
	page VARCHAR(250) null
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_B0969CE6 on gestionMenus_EntityMenu (appRoleId);
create index IX_6A3C3D7B on gestionMenus_EntityMenu (etabId);
create index IX_87F3702D on gestionMenus_EntityMenu (etabId, category);
create index IX_7CC27A36 on gestionMenus_EntityMenu (etabId, nodePath);
create index IX_613C568A on gestionMenus_EntityMenu (imageId);

create index IX_39FCB0D0 on gestionMenus_InternationalMenu (entityMenuId);
create index IX_ACD7641E on gestionMenus_InternationalMenu (entityMenuId, locale);

create index IX_966BC4C3 on gestionMenus_LinkEtab (etabId);

create index IX_50AD513A on gestionMenus_MenuIconMapping (appRoleId);

create index IX_2D0B6AA5 on gestionMenus_PronoteLink (userId);]]></indexes-sql>
</data>