<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table InstitutionalList_ListeInst (
	listeInstId LONG not null primary key,
	listeInstName VARCHAR(75) null,
	orgId LONG,
	roleId LONG,
	orgFilter BOOLEAN,
	roleFilter VARCHAR(75) null,
	onameFind VARCHAR(75) null,
	onameNotFind VARCHAR(75) null,
	includeInOrgLoop BOOLEAN,
	includeHisOrgLoop BOOLEAN,
	active_ BOOLEAN,
	parentList BOOLEAN,
	childrenList BOOLEAN
);

create table InstitutionalList_ListeInstDetails (
	listeInstDetailsId LONG not null primary key,
	listeInstId LONG,
	listeInstDetailsName VARCHAR(75) null,
	orgId LONG,
	roleId LONG,
	subOrgId VARCHAR(75) null,
	roleFilter VARCHAR(75) null,
	parentList BOOLEAN,
	childrenList BOOLEAN
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_1FB00DDA on InstitutionalList_ListeInst (orgId);
create index IX_5555333F on InstitutionalList_ListeInst (orgId, roleId);
create index IX_7590DC4C on InstitutionalList_ListeInst (orgId, roleId, parentList, childrenList);

create index IX_1C4D6F7F on InstitutionalList_ListeInstDetails (listeInstId);
create index IX_FAC5F836 on InstitutionalList_ListeInstDetails (orgId);
create index IX_2179019B on InstitutionalList_ListeInstDetails (orgId, roleId);
create index IX_C08B312 on InstitutionalList_ListeInstDetails (orgId, roleId, listeInstId, subOrgId, roleFilter);
create index IX_60912FA8 on InstitutionalList_ListeInstDetails (orgId, roleId, parentList, childrenList);]]></indexes-sql>
</data>