-<?xml version="1.0" encoding="UTF-8"?>
-<persistence-config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
- xsi:noNamespaceSchemaLocation="../../../../defs/config-metier/Persistence.xsd">
+<?xml version="1.0" encoding="UTF-8"?><persistence-config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../../defs/config-metier/Persistence.xsd">
<layer name="mysql" persistence-model="xemelios-sql">
- <document id="edmn" repository-import-xslt-file="" collectivite-code-colname="COLLECTIVITE"
- collectivite-lib-colname="COLLECTIVITE_LIB" budget-code-colname="BUDGET"
- budget-lib-colname="BUDGET_LIB">
+ <document id="edmn" repository-import-xslt-file="" collectivite-code-colname="COLLECTIVITE" collectivite-lib-colname="COLLECTIVITE_LIB" budget-code-colname="BUDGET" budget-lib-colname="BUDGET_LIB">
<table type="repository" base-name="EDMN_REPOSITORY" version="2"> CREATE TABLE IF NOT
EXISTS ${base-name} ( ID VARCHAR(25), LIBELLE VARCHAR(100), COLLECTIVITE VARCHAR(15)
- NOT NULL, REPOSITORY LONGBLOB, ENCODING VARCHAR(20) ) ENGINE MYISAM <patch
- from-version="1">
+ NOT NULL, REPOSITORY LONGBLOB, ENCODING VARCHAR(20) ) ENGINE MYISAM <patch from-version="1">
<sql failonerror="false">ALTER TABLE ${base-name} ADD ID VARCHAR(25)</sql>
<sql failonerror="false">ALTER TABLE ${base-name} ADD LIBELLE VARCHAR(100)</sql>
</patch>
VARCHAR(100) NOT NULL, DOC LONGBLOB, ENCODING VARCHAR(20), ANNEE_GESTION
INTEGER, INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INDEX
IX_EDMN_DOC_ANNEE_GESTION(COLLECTIVITE,BUDGET,ANNEE_GESTION), ARCHIVE_NAME
- VARCHAR(100), INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM <patch
- from-version="1">
+ VARCHAR(100), INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM <patch from-version="1">
<sql failonerror="false">ALTER TABLE EDMN_ETATEDMN_DOCUMENTS ADD
ANNEE_GESTION INTEGER, ADD INDEX
IX_EDMN_DOC_ANNEE_GESTION(COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql>
</patch>
</table>
- <table type="index" id="T1" base-name="EDMN_ETATEDMN_INDEX_EDMN" version="9"
- main="true"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(15)
+ <table type="index" id="T1" base-name="EDMN_ETATEDMN_INDEX_EDMN" version="9" main="true"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(15)
NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL, ANNEE_BUDG
INTEGER, ART_BUDG VARCHAR(2), ART_BUDG_PREV VARCHAR(2), CHAP_BUDG VARCHAR(4),
CHAP_CLASS VARCHAR(4), CODE_OPER_EXC VARCHAR(32), COMPTABLE VARCHAR(6),
(CHORUS_WITH_PJ)</sql>
</patch>
</table>
- <table id="T2" base-name="EDMN_ETATEDMN_IX_EDMN_LIASSES" type="index" version="3"
- based-on="key1"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
+ <table id="T2" base-name="EDMN_ETATEDMN_IX_EDMN_LIASSES" type="index" version="3" based-on="key1"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
VARCHAR(15) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
NUM_LIASSE VARCHAR(6) NOT NULL, ANNEE_GESTION INTEGER, INDEX IX_${base-name}_BC
(COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID), INDEX
IX_EDMN_ETATEDMN_LIASSES_ANGEST (COLLECTIVITE,BUDGET,ANNEE_GESTION), INDEX
IX_EDMN_ETATEDMN_LIASSES_LIASSE_CENTRALE (NUM_LIASSE), INITIAL_DOC_NAME
VARCHAR(100), INDEX ${base-name}_IDN (INITIAL_DOC_NAME), ARCHIVE_NAME
- VARCHAR(100), INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM <patch
- from-version="1">
+ VARCHAR(100), INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM <patch from-version="1">
<sql failonerror="false">ALTER TABLE EDMN_ETATEDMN_IX_EDMN_LIASSES ADD
ANNEE_GESTION INTEGER, ADD INDEX
IX_EDMN_ETATEDMN_LIASSES_ANGEST(COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql>
<!-- LIGNES EDMN -->
- <sql-index id="anneeBudget" table="T1" column="ANNEE_BUDG"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:AnneeBudget/@V" datatype="integer"/>
- <sql-index id="action" table="T1" column="ART_BUDG"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ArtBudgExec/@V" datatype="string"
- format="uppercase"/>
- <sql-index id="artPrev" table="T1" column="ART_BUDG_PREV"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ArtBudgPrev/@V" datatype="string"
- format="uppercase"/>
- <sql-index id="programme" table="T1" column="CHAP_BUDG"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ChapBudg/@V" datatype="string"
- format="uppercase"/>
- <sql-index id="chapClassPJ" table="T1" column="CHAP_CLASS"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ChapClassPJ/@V" datatype="string"/>
- <sql-index id="codOperExc" table="T1" column="CODE_OPER_EXC"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:CodeOperExc/@V" datatype="string"
- format="uppercase"/>
- <sql-index id="comptable" table="T1" column="COMPTABLE"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Comptable/@V" datatype="string"
- format="uppercase"/>
- <sql-index id="dateCrea" table="T1" column="DATE_CREA"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:DateCreation/@V" datatype="date"
- format="yyyy-MM-dd"/>
- <sql-index id="datePaiement" table="T1" column="DATE_PAIEMENT"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:DatePaiement/@V" datatype="date"
- format="yyyy-MM-dd"/>
- <sql-index id="imputation" table="T1" column="IMPUTATION"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Imputation/@V" datatype="string"/>
- <sql-index id="libAction" table="T1" column="LIB_ACTION"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleAction/@V" datatype="string"
- format="uppercase"/>
- <sql-index id="lib-comptable" table="T1" column="LIB_COMPTABLE"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleComptable/@V" datatype="string"
- format="uppercase"/>
- <sql-index id="lib-ministere" table="T1" column="LIB_MINISTERE"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Ministere/@LibelleMinistere"
- datatype="string" format="uppercase"/>
- <sql-index id="lib-ordo" table="T1" column="LIB_ORDO"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleOrdonnateur/@V" datatype="string"
- format="uppercase"/>
- <sql-index id="libProgramme" table="T1" column="LIB_PROGRAMME"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleProgramme/@V" datatype="string"
- format="uppercase"/>
- <sql-index id="ministere" table="T1" column="MINISTERE"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Ministere/@V" datatype="string"
- format="uppercase"/>
- <sql-index id="mtPj" table="T1" column="MT_PJ"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:MtPJ/@V" datatype="decimal"/>
- <sql-index id="numLiasseLocale" table="T1" column="NUM_LIASSE_LOC"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasse/@V" datatype="string"
- format="uppercase"/>
- <sql-index id="numLiasseLocaleDeb" table="T1" column="NUM_LIASSE_DEB"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseDeb/@V" datatype="string"
- format="uppercase"/>
- <sql-index id="numLiasseLocaleFin" table="T1" column="NUM_LIASSE_FIN"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseFin/@V" datatype="string"
- format="uppercase"/>
- <sql-index id="numMandat" table="T1" column="NUM_MANDAT"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumMandat/@V" datatype="string"
- format="uppercase"/>
- <sql-index id="ordo" table="T1" column="ORDO"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Ordo/@V" datatype="string"
- format="uppercase"/>
- <sql-index id="numOpeInvest" table="T1" column="OPE_INVEST"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumOpeInvest/@V" datatype="string"
- format="uppercase"/>
- <sql-index id="cpce" table="T1" column="PARAG_BUDG"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ParagBudgExec/@V" datatype="string"
- format="uppercase"/>
- <sql-index id="trimestre" table="T1" column="TRIMESTRE"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Trimestre/@V" datatype="integer"/>
- <sql-index id="typeEvt" table="T1" column="TYPE_EVT"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:TypeEvt/@V" datatype="string"/>
- <sql-index id="typePaiement" table="T1" column="TYPE_PAIEMENT"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:TypePaiement/@V" datatype="string"/>
- <sql-index id="numPieceCompta" table="T1" column="NUM_PIECE_COMPTA"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumPieceCompta/@V" datatype="string"
- format="uppercase"/>
- <sql-index id="chorus_nom_societe" table="T1" column="CHORUS_NOM_SOCIETE"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@NomSociete" datatype="string"
- format="uppercase"/>
- <sql-index id="chorus_fournisseur_nom" table="T1" column="CHORUS_FOURNISSEUR_NOM"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@FournisseurNom"
- datatype="string" format="uppercase"/>
- <sql-index id="chorus_fournisseur_siret" table="T1"
- column="CHORUS_FOURNISSEUR_SIRET"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@FournisseurSiret"
- datatype="string" format="uppercase"/>
- <sql-index id="chorus_payeur_nom" table="T1" column="CHORUS_PAYEUR_NOM"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@PayeurNom" datatype="string"
- format="uppercase"/>
- <sql-index id="chorus_payeur_siret" table="T1" column="CHORUS_PAYEUR_SIRET"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@PayeurSiret" datatype="string"
- format="uppercase"/>
- <sql-index id="chorus_rib_pays" table="T1" column="CHORUS_RIB_PAYS"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibPays" datatype="string"
- format="uppercase"/>
- <sql-index id="chorus_rib_banc" table="T1" column="CHORUS_RIB_BANC"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibBanc" datatype="string"
- format="uppercase"/>
- <sql-index id="chorus_rib_compte" table="T1" column="CHORUS_RIB_COMPTE"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibCompte" datatype="string"
- format="uppercase"/>
- <sql-index id="chorus_rib_cle" table="T1" column="CHORUS_RIB_CLE"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibCle" datatype="string"
- format="uppercase"/>
- <sql-index id="chorus_domaine_fonctionnel" table="T1"
- column="CHORUS_DOMAINE_FONCTIONNEL"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@DomaineFonctionnel"
- datatype="string" format="uppercase"/>
- <sql-index id="chorus_num_ej_long" table="T1" column="CHORUS_NUM_EJ_LONG"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@NumEJLong" datatype="string"
- format="uppercase"/>
- <sql-index id="chorus_with_pj" table="T1" column="CHORUS_WITH_PJ"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/@added:withPJ" datatype="integer"/>
+ <sql-index id="anneeBudget" table="T1" column="ANNEE_BUDG" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:AnneeBudget/@V" datatype="integer"/>
+ <sql-index id="action" table="T1" column="ART_BUDG" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ArtBudgExec/@V" datatype="string" format="uppercase"/>
+ <sql-index id="artPrev" table="T1" column="ART_BUDG_PREV" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ArtBudgPrev/@V" datatype="string" format="uppercase"/>
+ <sql-index id="programme" table="T1" column="CHAP_BUDG" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ChapBudg/@V" datatype="string" format="uppercase"/>
+ <sql-index id="chapClassPJ" table="T1" column="CHAP_CLASS" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ChapClassPJ/@V" datatype="string"/>
+ <sql-index id="codOperExc" table="T1" column="CODE_OPER_EXC" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:CodeOperExc/@V" datatype="string" format="uppercase"/>
+ <sql-index id="comptable" table="T1" column="COMPTABLE" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Comptable/@V" datatype="string" format="uppercase"/>
+ <sql-index id="dateCrea" table="T1" column="DATE_CREA" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:DateCreation/@V" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="datePaiement" table="T1" column="DATE_PAIEMENT" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:DatePaiement/@V" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="imputation" table="T1" column="IMPUTATION" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Imputation/@V" datatype="string"/>
+ <sql-index id="libAction" table="T1" column="LIB_ACTION" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleAction/@V" datatype="string" format="uppercase"/>
+ <sql-index id="lib-comptable" table="T1" column="LIB_COMPTABLE" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleComptable/@V" datatype="string" format="uppercase"/>
+ <sql-index id="lib-ministere" table="T1" column="LIB_MINISTERE" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Ministere/@LibelleMinistere" datatype="string" format="uppercase"/>
+ <sql-index id="lib-ordo" table="T1" column="LIB_ORDO" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleOrdonnateur/@V" datatype="string" format="uppercase"/>
+ <sql-index id="libProgramme" table="T1" column="LIB_PROGRAMME" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleProgramme/@V" datatype="string" format="uppercase"/>
+ <sql-index id="ministere" table="T1" column="MINISTERE" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Ministere/@V" datatype="string" format="uppercase"/>
+ <sql-index id="mtPj" table="T1" column="MT_PJ" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:MtPJ/@V" datatype="decimal"/>
+ <sql-index id="numLiasseLocale" table="T1" column="NUM_LIASSE_LOC" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasse/@V" datatype="string" format="uppercase"/>
+ <sql-index id="numLiasseLocaleDeb" table="T1" column="NUM_LIASSE_DEB" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseDeb/@V" datatype="string" format="uppercase"/>
+ <sql-index id="numLiasseLocaleFin" table="T1" column="NUM_LIASSE_FIN" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseFin/@V" datatype="string" format="uppercase"/>
+ <sql-index id="numMandat" table="T1" column="NUM_MANDAT" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumMandat/@V" datatype="string" format="uppercase"/>
+ <sql-index id="ordo" table="T1" column="ORDO" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Ordo/@V" datatype="string" format="uppercase"/>
+ <sql-index id="numOpeInvest" table="T1" column="OPE_INVEST" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumOpeInvest/@V" datatype="string" format="uppercase"/>
+ <sql-index id="cpce" table="T1" column="PARAG_BUDG" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ParagBudgExec/@V" datatype="string" format="uppercase"/>
+ <sql-index id="trimestre" table="T1" column="TRIMESTRE" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Trimestre/@V" datatype="integer"/>
+ <sql-index id="typeEvt" table="T1" column="TYPE_EVT" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:TypeEvt/@V" datatype="string"/>
+ <sql-index id="typePaiement" table="T1" column="TYPE_PAIEMENT" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:TypePaiement/@V" datatype="string"/>
+ <sql-index id="numPieceCompta" table="T1" column="NUM_PIECE_COMPTA" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumPieceCompta/@V" datatype="string" format="uppercase"/>
+ <sql-index id="chorus_nom_societe" table="T1" column="CHORUS_NOM_SOCIETE" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@NomSociete" datatype="string" format="uppercase"/>
+ <sql-index id="chorus_fournisseur_nom" table="T1" column="CHORUS_FOURNISSEUR_NOM" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@FournisseurNom" datatype="string" format="uppercase"/>
+ <sql-index id="chorus_fournisseur_siret" table="T1" column="CHORUS_FOURNISSEUR_SIRET" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@FournisseurSiret" datatype="string" format="uppercase"/>
+ <sql-index id="chorus_payeur_nom" table="T1" column="CHORUS_PAYEUR_NOM" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@PayeurNom" datatype="string" format="uppercase"/>
+ <sql-index id="chorus_payeur_siret" table="T1" column="CHORUS_PAYEUR_SIRET" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@PayeurSiret" datatype="string" format="uppercase"/>
+ <sql-index id="chorus_rib_pays" table="T1" column="CHORUS_RIB_PAYS" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibPays" datatype="string" format="uppercase"/>
+ <sql-index id="chorus_rib_banc" table="T1" column="CHORUS_RIB_BANC" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibBanc" datatype="string" format="uppercase"/>
+ <sql-index id="chorus_rib_compte" table="T1" column="CHORUS_RIB_COMPTE" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibCompte" datatype="string" format="uppercase"/>
+ <sql-index id="chorus_rib_cle" table="T1" column="CHORUS_RIB_CLE" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibCle" datatype="string" format="uppercase"/>
+ <sql-index id="chorus_domaine_fonctionnel" table="T1" column="CHORUS_DOMAINE_FONCTIONNEL" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@DomaineFonctionnel" datatype="string" format="uppercase"/>
+ <sql-index id="chorus_num_ej_long" table="T1" column="CHORUS_NUM_EJ_LONG" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@NumEJLong" datatype="string" format="uppercase"/>
+ <sql-index id="chorus_with_pj" table="T1" column="CHORUS_WITH_PJ" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/@added:withPJ" datatype="integer"/>
<!-- LIASSES -->
- <sql-index id="numLiasseCentrale" table="T2" column="NUM_LIASSE"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseNationale/n:Liasse/@national"
- datatype="string" format="uppercase"/>
- <sql-index id="liasseAnneeGestion" table="T2" column="ANNEE_GESTION"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:AnneeBudget/@V" datatype="integer"
- use-in-criteria="false"/>
+ <sql-index id="numLiasseCentrale" table="T2" column="NUM_LIASSE" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseNationale/n:Liasse/@national" datatype="string" format="uppercase"/>
+ <sql-index id="liasseAnneeGestion" table="T2" column="ANNEE_GESTION" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:AnneeBudget/@V" datatype="integer" use-in-criteria="false"/>
<!-- chap class -->
</etat>
DOC LONGBLOB, ENCODING VARCHAR(20), INDEX IX_${base-name}_BC
(COLLECTIVITE,BUDGET,DOC_ID), ARCHIVE_NAME VARCHAR(100), INDEX ${base-name}_AN
(ARCHIVE_NAME) ) ENGINE MYISAM </table>
- <table id="B1" base-name="EDMN_BUDG_INDEX" type="index" version="3" main="true"
- ignoreConstraintError="true"> CREATE TABLE IF NOT EXISTS ${base-name} (
+ <table id="B1" base-name="EDMN_BUDG_INDEX" type="index" version="3" main="true" ignoreConstraintError="true"> CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID
VARCHAR(100) NOT NULL, ANNEE INTEGER NOT NULL, DATA VARCHAR(9) NOT NULL,
MINISTERE VARCHAR(6) NOT NULL, PROGRAMME VARCHAR(6), ACTION VARCHAR(6),
- <sql-index id="typeData" table="B1" column="DATA"
- path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Data/@V" datatype="string"/>
- <sql-index id="annee" table="B1" column="ANNEE"
- path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Annee/@V" datatype="integer"/>
- <sql-index id="min" table="B1" column="MINISTERE"
- path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Ministere/@V" datatype="string"/>
- <sql-index id="prog" table="B1" column="PROGRAMME"
- path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Programme/@V" datatype="string"/>
- <sql-index id="act" table="B1" column="ACTION"
- path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Action/@V" datatype="string"/>
- <sql-index id="artRegroupt" table="B1" column="ART_REGROUP"
- path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:ArticleRegroupt/@V"
- datatype="string" format="uppercase"/>
- <sql-index id="cpce2" table="B1" column="CPCE"
- path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Cpce/@V" datatype="string"
- format="uppercase"/>
- <sql-index id="budg.lib" table="B1" column="LIBELLE"
- path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Libelle/@V" datatype="string"/>
+ <sql-index id="typeData" table="B1" column="DATA" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Data/@V" datatype="string"/>
+ <sql-index id="annee" table="B1" column="ANNEE" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Annee/@V" datatype="integer"/>
+ <sql-index id="min" table="B1" column="MINISTERE" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Ministere/@V" datatype="string"/>
+ <sql-index id="prog" table="B1" column="PROGRAMME" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Programme/@V" datatype="string"/>
+ <sql-index id="act" table="B1" column="ACTION" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Action/@V" datatype="string"/>
+ <sql-index id="artRegroupt" table="B1" column="ART_REGROUP" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:ArticleRegroupt/@V" datatype="string" format="uppercase"/>
+ <sql-index id="cpce2" table="B1" column="CPCE" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Cpce/@V" datatype="string" format="uppercase"/>
+ <sql-index id="budg.lib" table="B1" column="LIBELLE" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Libelle/@V" datatype="string"/>
</etat>
<etat id="ordos" import-xslt-file="edmn/edmn-import-mysql.xsl">
<table base-name="EDMN_ORDOS_DOCUMENTS" type="document" version="1"> CREATE TABLE IF
DOC LONGBLOB, ENCODING VARCHAR(20), INDEX IX_${base-name}_BC
(COLLECTIVITE,BUDGET,DOC_ID), ARCHIVE_NAME VARCHAR(100), INDEX ${base-name}_AN
(ARCHIVE_NAME) ) ENGINE MYISAM </table>
- <table id="O1" base-name="EDMN_ORDOS_INDEX" type="index" version="2" main="true"
- ignoreConstraintError="true"> CREATE TABLE IF NOT EXISTS ${base-name} (
+ <table id="O1" base-name="EDMN_ORDOS_INDEX" type="index" version="2" main="true" ignoreConstraintError="true"> CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID
VARCHAR(100) NOT NULL, ANNEE INTEGER NOT NULL, TRIMESTRE INTEGER NOT NULL,
MINISTERE VARCHAR(6) NOT NULL, CPTE_SPE_TRES VARCHAR(6), CODE VARCHAR(6) NOT
- <sql-index id="ordo.annee" table="O1" column="ANNEE"
- path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:Annee/@V"
- datatype="integer"/>
- <sql-index id="ordo.min" table="O1" column="MINISTERE"
- path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:CodeMinistere/@V"
- datatype="string"/>
- <sql-index id="ordo.code" table="O1" column="CODE"
- path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:CodeOrdo/@V"
- datatype="string"/>
- <sql-index id="ordo.compte" table="O1" column="CPTE_SPE_TRES"
- path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:CompteSpeTresor/@V"
- datatype="string"/>
- <sql-index id="ordo.lib" table="O1" column="LIBELLE"
- path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:Libelle/@V"
- datatype="string" format="uppercase"/>
+ <sql-index id="ordo.annee" table="O1" column="ANNEE" path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:Annee/@V" datatype="integer"/>
+ <sql-index id="ordo.min" table="O1" column="MINISTERE" path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:CodeMinistere/@V" datatype="string"/>
+ <sql-index id="ordo.code" table="O1" column="CODE" path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:CodeOrdo/@V" datatype="string"/>
+ <sql-index id="ordo.compte" table="O1" column="CPTE_SPE_TRES" path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:CompteSpeTresor/@V" datatype="string"/>
+ <sql-index id="ordo.lib" table="O1" column="LIBELLE" path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:Libelle/@V" datatype="string" format="uppercase"/>
</etat>
<etat id="comptables" import-xslt-file="edmn/edmn-import-mysql.xsl">
<table base-name="EDMN_COMPTA_DOCUMENTS" type="document" version="1"> CREATE TABLE
VARCHAR(100) NOT NULL, DOC LONGBLOB, ENCODING VARCHAR(20), INDEX
IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), ARCHIVE_NAME VARCHAR(100),
INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM </table>
- <table id="C1" base-name="EDMN_COMPTA_INDEX" type="index" version="3" main="true"
- ignoreConstraintError="true"> CREATE TABLE IF NOT EXISTS ${base-name} (
+ <table id="C1" base-name="EDMN_COMPTA_INDEX" type="index" version="3" main="true" ignoreConstraintError="true"> CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID
VARCHAR(100) NOT NULL, ANNEE INTEGER NOT NULL, CODE VARCHAR(6) NOT NULL, LIBELLE
VARCHAR(150), UNIQUE INDEX IX_${base-name}_PK (COLLECTIVITE,BUDGET,CODE,ANNEE),
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INITIAL_DOC_NAME
VARCHAR(100), INDEX ${base-name}_IDN (INITIAL_DOC_NAME), ARCHIVE_NAME
- VARCHAR(100), INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM <patch
- from-version="1">
+ VARCHAR(100), INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM <patch from-version="1">
<sql failonerror="false">drop table EDMN_COMPTA_INDEX</sql>
<sql>CREATE TABLE IF NOT EXISTS EDMN_COMPTA_INDEX ( COLLECTIVITE VARCHAR(15)
NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
<where-clause>fn:string-compare(${table}.${column},libelle)</where-clause>
</criteria>
- <sql-index id="compta.annee" table="C1" column="ANNEE"
- path="/n:Edmn/n:NomenclatureComptables/n:Comptable/n:Annee/@V"
- datatype="integer"/>
- <sql-index id="compta.code" table="C1" column="CODE"
- path="/n:Edmn/n:NomenclatureComptables/n:Comptable/n:Code/@V" datatype="string"
- format="uppercase"/>
- <sql-index id="compta.lib" table="C1" column="LIBELLE"
- path="/n:Edmn/n:NomenclatureComptables/n:Comptable/n:Libelle/@V"
- datatype="string" format="uppercase"/>
+ <sql-index id="compta.annee" table="C1" column="ANNEE" path="/n:Edmn/n:NomenclatureComptables/n:Comptable/n:Annee/@V" datatype="integer"/>
+ <sql-index id="compta.code" table="C1" column="CODE" path="/n:Edmn/n:NomenclatureComptables/n:Comptable/n:Code/@V" datatype="string" format="uppercase"/>
+ <sql-index id="compta.lib" table="C1" column="LIBELLE" path="/n:Edmn/n:NomenclatureComptables/n:Comptable/n:Libelle/@V" datatype="string" format="uppercase"/>
</etat>
</document>
</layer>
- <layer name="oracle" persistence-model="xemelios-sql">
- <document id="edmn" repository-import-xslt-file="">
- <table base-name="EDMN_SPECIAL_KEYS" type="special-key" version="1"
- ><sql xml:space="preserve">CREATE TABLE ${base-name} (
+
+<layer name="oracle" persistence-model="xemelios-sql"><document id="edmn" repository-import-xslt-file=""><table base-name="EDMN_SPECIAL_KEYS" type="special-key" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
BUDGET VARCHAR(1000) NOT NULL,
COLLECTIVITE VARCHAR(1000) NOT NULL,
ARCHIVE_NAME VARCHAR(1000),
LIB1 VARCHAR(1000),
LIB3 VARCHAR(1000),
INITIAL_DOC_NAME VARCHAR(1000) NOT NULL
-)</sql><sql>CREATE
- INDEX ${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET)</sql><sql>CREATE
- INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table>
- <table base-name="EDMN_LIST_BUDG_COLL" type="list-bc" version="1"
- ><sql xml:space="preserve">CREATE TABLE ${base-name} (
+)</sql><sql>CREATE INDEX ${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><table base-name="EDMN_LIST_BUDG_COLL" type="list-bc" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
BUDGET VARCHAR(1000) NOT NULL,
COLLECTIVITE VARCHAR(1000) NOT NULL,
ARCHIVE_NAME VARCHAR(1000),
BUDGET_LIB VARCHAR(1000),
INITIAL_DOC_NAME VARCHAR(1000) NOT NULL,
COLLECTIVITE_LIB VARCHAR(1000)
-)</sql><sql>CREATE
- INDEX ${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET)</sql><sql>CREATE
- INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table>
- <table base-name="EDMN_REPOSITORY" type="repository" version="1"
- ><sql xml:space="preserve">CREATE TABLE ${base-name} (
+)</sql><sql>CREATE INDEX ${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><table base-name="EDMN_REPOSITORY" type="repository" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
COLLECTIVITE VARCHAR(1000) NOT NULL,
ID VARCHAR(1000),
REPOSITORY BLOB,
LIBELLE VARCHAR(1000)
-)</sql></table>
- <etat id="comptables" import-xslt-file="edmn/edmn-import-mysql.xsl">
- <table base-name="EDMN_COMPTA_DOCS" type="document" version="1"
- ><sql xml:space="preserve">CREATE TABLE ${base-name} (
+)</sql></table><etat id="comptables" import-xslt-file="edmn/edmn-import-mysql.xsl"><table base-name="EDMN_COMPTA_DOCS" type="document" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
BUDGET VARCHAR(1000) NOT NULL,
COLLECTIVITE VARCHAR(1000) NOT NULL,
ARCHIVE_NAME VARCHAR(1000),
DOC_ID VARCHAR(1000) NOT NULL,
DOC BLOB,
INITIAL_DOC_NAME VARCHAR(1000) NOT NULL
-)</sql><sql>CREATE
- INDEX ${base-name}_BC ON ${base-name}
- (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_AN ON
- ${base-name} (ARCHIVE_NAME)</sql></table>
- <table base-name="EDMN_COMPTA" id="C1" type="index" main="true"
- ignoreConstraintError="true" version="1"
- ><sql xml:space="preserve">CREATE TABLE ${base-name} (
+)</sql><sql>CREATE INDEX ${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><table base-name="EDMN_COMPTA" id="C1" type="index" main="true" ignoreConstraintError="true" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
BUDGET VARCHAR(1000) NOT NULL,
COLLECTIVITE VARCHAR(1000) NOT NULL,
ARCHIVE_NAME VARCHAR(1000),
INITIAL_DOC_NAME VARCHAR(1000),
LIBELLE VARCHAR(1000),
CODE VARCHAR(1000) NOT NULL
-)</sql><sql>CREATE
- INDEX ${base-name}_BC ON ${base-name}
- (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_IDN ON
- ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON
- ${base-name} (ARCHIVE_NAME)</sql><sql>CREATE UNIQUE INDEX IX_${base-name}_PK
- ON ${base-name} (COLLECTIVITE,BUDGET,CODE,ANNEE)</sql></table>
- <criteria id="compta.annee" sql-index-id="compta.annee">
+)</sql><sql>CREATE INDEX ${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql><sql>CREATE UNIQUE INDEX IX_${base-name}_PK ON ${base-name} (COLLECTIVITE,BUDGET,CODE,ANNEE)</sql></table><criteria id="compta.annee" sql-index-id="compta.annee">
<where-clause>${table}.${column}##OPERATEUR:annee####VALEUR:annee##</where-clause>
- </criteria>
- <criteria id="compta.code" sql-index-id="compta.code">
+ </criteria><criteria id="compta.code" sql-index-id="compta.code">
<where-clause>fn:string-compare(${table}.${column},code)</where-clause>
- </criteria>
- <criteria id="compta.libelle" sql-index-id="compta.lib">
+ </criteria><criteria id="compta.libelle" sql-index-id="compta.lib">
<where-clause>fn:string-compare(${table}.${column},libelle)</where-clause>
- </criteria>
- <sql-index id="compta.annee"
- path="/n:Edmn/n:NomenclatureComptables/n:Comptable/n:Annee/@V"
- datatype="integer" table="C1" column="ANNEE"/>
- <sql-index id="compta.code"
- path="/n:Edmn/n:NomenclatureComptables/n:Comptable/n:Code/@V" datatype="string"
- table="C1" column="CODE" format="uppercase"/>
- <sql-index id="compta.lib"
- path="/n:Edmn/n:NomenclatureComptables/n:Comptable/n:Libelle/@V"
- datatype="string" table="C1" column="LIBELLE" format="uppercase"/>
- </etat>
- <etat id="etatEdmn" import-xslt-file="edmn/edmn-import-mysql.xsl">
- <key1>
+ </criteria><sql-index id="compta.annee" path="/n:Edmn/n:NomenclatureComptables/n:Comptable/n:Annee/@V" datatype="integer" table="C1" column="ANNEE"/><sql-index id="compta.code" path="/n:Edmn/n:NomenclatureComptables/n:Comptable/n:Code/@V" datatype="string" table="C1" column="CODE" format="uppercase"/><sql-index id="compta.lib" path="/n:Edmn/n:NomenclatureComptables/n:Comptable/n:Libelle/@V" datatype="string" table="C1" column="LIBELLE" format="uppercase"/></etat><etat id="etatEdmn" import-xslt-file="edmn/edmn-import-mysql.xsl"><key1>
<path>/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseNationale/n:Liasse/@added:generated-id</path>
- </key1>
- <table base-name="EDMN_ETAT" id="T1" type="index" main="true" version="1"
- ><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ </key1><table base-name="EDMN_ETAT" id="T1" type="index" main="true" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
BUDGET VARCHAR(1000) NOT NULL,
CHORUS_NOM_SOCIETE VARCHAR(1000),
CHAP_CLASS VARCHAR(1000),
CHORUS_FOURNISSEUR_NOM VARCHAR(1000),
TYPE_EVT VARCHAR(1000),
TRIMESTRE NUMBER
-)</sql><sql>CREATE
- INDEX ETATEDMN_ANNEE_BUDG ON ${base-name} (ANNEE_BUDG)</sql><sql>CREATE
- INDEX ETATEDMN_ART_BUDG ON ${base-name} (ART_BUDG)</sql><sql>CREATE INDEX
- ETATEDMN_ART_BDG_P ON ${base-name} (ART_BUDG_PREV)</sql><sql>CREATE INDEX
- ETATEDMN_CHAP_BUDG ON ${base-name} (CHAP_BUDG)</sql><sql>CREATE INDEX
- ETATEDMN_CHAP_CLASS ON ${base-name} (CHAP_CLASS)</sql><sql>CREATE INDEX
- ETATEDMN_OPER_EXC ON ${base-name} (CODE_OPER_EXC)</sql><sql>CREATE INDEX
- ETATEDMN_COMPTA ON ${base-name} (COMPTABLE)</sql><sql>CREATE INDEX
- ETATEDMN_DATE_CREA ON ${base-name} (DATE_CREA)</sql><sql>CREATE INDEX
- ETATEDMN_DTE_PAY ON ${base-name} (DATE_PAIEMENT)</sql><sql>CREATE INDEX
- IMPUTATION ON ${base-name} (IMPUTATION)</sql><sql>CREATE INDEX
- ETATEDMN_LIB_ACTION ON ${base-name} (LIB_ACTION)</sql><sql>CREATE INDEX
- LIB_COMPTA ON ${base-name}
- (COLLECTIVITE,BUDGET,LIB_COMPTABLE)</sql><sql>CREATE INDEX LIB_MINISTERE ON
- ${base-name} (COLLECTIVITE,BUDGET,LIB_MINISTERE)</sql><sql>CREATE INDEX
- LIB_ORDO ON ${base-name} (COLLECTIVITE,BUDGET,LIB_ORDO)</sql><sql>CREATE
- INDEX ETATEDMN_LIB_PROG ON ${base-name} (LIB_PROGRAMME)</sql><sql>CREATE
- INDEX ETATEDMN_MINISTERE ON ${base-name} (MINISTERE)</sql><sql>CREATE INDEX
- ETATEDMN_MT_PJ ON ${base-name} (MT_PJ)</sql><sql>CREATE INDEX
- ETATEDMN_NUM_ENGAG ON ${base-name} (NUM_ENGAG)</sql><sql>CREATE INDEX
- ETATEDMN_LIASSE_LOC ON ${base-name} (NUM_LIASSE_LOC)</sql><sql>CREATE INDEX
- ETATEDMN_LIASSE_LOC_DEB ON ${base-name} (NUM_LIASSE_DEB)</sql><sql>CREATE
- INDEX ETATEDMN_LIASSE_LOC_FIN ON ${base-name}
- (NUM_LIASSE_FIN)</sql><sql>CREATE INDEX ETATEDMN_PIECE_COMPTA ON
- ${base-name} (NUM_PIECE_COMPTA)</sql><sql>CREATE INDEX ETATEDMN_ORDO ON
- ${base-name} (ORDO)</sql><sql>CREATE INDEX ETATEDMN_PARAG_BUDG ON
- ${base-name} (PARAG_BUDG)</sql><sql>CREATE INDEX ETATEDMN_TRIM ON
- ${base-name} (TRIMESTRE)</sql><sql>CREATE INDEX ETATEDMN_TYPE_EVT ON
- ${base-name} (TYPE_EVT)</sql><sql>CREATE INDEX ETATEDMN_TYPE_PAY ON
- ${base-name} (TYPE_PAIEMENT)</sql><sql>CREATE INDEX CHORUS_NOM_SOCIETE ON
- ${base-name} (CHORUS_NOM_SOCIETE)</sql><sql>CREATE INDEX
- CHORUS_FOURNISSEUR_NOM ON ${base-name}
- (CHORUS_FOURNISSEUR_NOM)</sql><sql>CREATE INDEX CHORUS_FOURNISSEUR_SIRET ON
- ${base-name} (CHORUS_FOURNISSEUR_SIRET)</sql><sql>CREATE INDEX
- CHORUS_PAYEUR_NOM ON ${base-name} (CHORUS_PAYEUR_NOM)</sql><sql>CREATE INDEX
- CHORUS_PAYEUR_SIRET ON ${base-name} (CHORUS_PAYEUR_SIRET)</sql><sql>CREATE
- INDEX CHORUS_RIB_PAYS ON ${base-name} (CHORUS_RIB_PAYS)</sql><sql>CREATE
- INDEX CHORUS_RIB_BANC ON ${base-name} (CHORUS_RIB_BANC)</sql><sql>CREATE
- INDEX CHORUS_RIB_COMPTE ON ${base-name} (CHORUS_RIB_COMPTE)</sql><sql>CREATE
- INDEX CHORUS_RIB_CLE ON ${base-name} (CHORUS_RIB_CLE)</sql><sql>CREATE INDEX
- CHORUS_DOMAINE_FONCTIONNEL ON ${base-name}
- (CHORUS_DOMAINE_FONCTIONNEL)</sql><sql>CREATE INDEX CHORUS_NUM_EJ_LONG ON
- ${base-name} (CHORUS_NUM_EJ_LONG)</sql><sql>CREATE INDEX CHORUS_WITH_PJ ON
- ${base-name} (CHORUS_WITH_PJ)</sql><sql>CREATE INDEX ${base-name}_IDN ON
- ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON
- ${base-name} (ARCHIVE_NAME)</sql></table>
- <table base-name="EDMN_ETAT_LIASSES" id="T2" type="index" based-on="key1"
- version="1"
- ><sql xml:space="preserve">CREATE TABLE ${base-name} (
+)</sql><sql>CREATE INDEX ETATEDMN_ANNEE_BUDG ON ${base-name} (ANNEE_BUDG)</sql><sql>CREATE INDEX ETATEDMN_ART_BUDG ON ${base-name} (ART_BUDG)</sql><sql>CREATE INDEX ETATEDMN_ART_BDG_P ON ${base-name} (ART_BUDG_PREV)</sql><sql>CREATE INDEX ETATEDMN_CHAP_BUDG ON ${base-name} (CHAP_BUDG)</sql><sql>CREATE INDEX ETATEDMN_CHAP_CLASS ON ${base-name} (CHAP_CLASS)</sql><sql>CREATE INDEX ETATEDMN_OPER_EXC ON ${base-name} (CODE_OPER_EXC)</sql><sql>CREATE INDEX ETATEDMN_COMPTA ON ${base-name} (COMPTABLE)</sql><sql>CREATE INDEX ETATEDMN_DATE_CREA ON ${base-name} (DATE_CREA)</sql><sql>CREATE INDEX ETATEDMN_DTE_PAY ON ${base-name} (DATE_PAIEMENT)</sql><sql>CREATE INDEX IMPUTATION ON ${base-name} (IMPUTATION)</sql><sql>CREATE INDEX ETATEDMN_LIB_ACTION ON ${base-name} (LIB_ACTION)</sql><sql>CREATE INDEX LIB_COMPTA ON ${base-name} (COLLECTIVITE,BUDGET,LIB_COMPTABLE)</sql><sql>CREATE INDEX LIB_MINISTERE ON ${base-name} (COLLECTIVITE,BUDGET,LIB_MINISTERE)</sql><sql>CREATE INDEX LIB_ORDO ON ${base-name} (COLLECTIVITE,BUDGET,LIB_ORDO)</sql><sql>CREATE INDEX ETATEDMN_LIB_PROG ON ${base-name} (LIB_PROGRAMME)</sql><sql>CREATE INDEX ETATEDMN_MINISTERE ON ${base-name} (MINISTERE)</sql><sql>CREATE INDEX ETATEDMN_MT_PJ ON ${base-name} (MT_PJ)</sql><sql>CREATE INDEX ETATEDMN_NUM_ENGAG ON ${base-name} (NUM_ENGAG)</sql><sql>CREATE INDEX ETATEDMN_LIASSE_LOC ON ${base-name} (NUM_LIASSE_LOC)</sql><sql>CREATE INDEX ETATEDMN_LIASSE_LOC_DEB ON ${base-name} (NUM_LIASSE_DEB)</sql><sql>CREATE INDEX ETATEDMN_LIASSE_LOC_FIN ON ${base-name} (NUM_LIASSE_FIN)</sql><sql>CREATE INDEX ETATEDMN_PIECE_COMPTA ON ${base-name} (NUM_PIECE_COMPTA)</sql><sql>CREATE INDEX ETATEDMN_ORDO ON ${base-name} (ORDO)</sql><sql>CREATE INDEX ETATEDMN_PARAG_BUDG ON ${base-name} (PARAG_BUDG)</sql><sql>CREATE INDEX ETATEDMN_TRIM ON ${base-name} (TRIMESTRE)</sql><sql>CREATE INDEX ETATEDMN_TYPE_EVT ON ${base-name} (TYPE_EVT)</sql><sql>CREATE INDEX ETATEDMN_TYPE_PAY ON ${base-name} (TYPE_PAIEMENT)</sql><sql>CREATE INDEX CHORUS_NOM_SOCIETE ON ${base-name} (CHORUS_NOM_SOCIETE)</sql><sql>CREATE INDEX CHORUS_FOURNISSEUR_NOM ON ${base-name} (CHORUS_FOURNISSEUR_NOM)</sql><sql>CREATE INDEX CHORUS_FOURNISSEUR_SIRET ON ${base-name} (CHORUS_FOURNISSEUR_SIRET)</sql><sql>CREATE INDEX CHORUS_PAYEUR_NOM ON ${base-name} (CHORUS_PAYEUR_NOM)</sql><sql>CREATE INDEX CHORUS_PAYEUR_SIRET ON ${base-name} (CHORUS_PAYEUR_SIRET)</sql><sql>CREATE INDEX CHORUS_RIB_PAYS ON ${base-name} (CHORUS_RIB_PAYS)</sql><sql>CREATE INDEX CHORUS_RIB_BANC ON ${base-name} (CHORUS_RIB_BANC)</sql><sql>CREATE INDEX CHORUS_RIB_COMPTE ON ${base-name} (CHORUS_RIB_COMPTE)</sql><sql>CREATE INDEX CHORUS_RIB_CLE ON ${base-name} (CHORUS_RIB_CLE)</sql><sql>CREATE INDEX CHORUS_DOMAINE_FONCTIONNEL ON ${base-name} (CHORUS_DOMAINE_FONCTIONNEL)</sql><sql>CREATE INDEX CHORUS_NUM_EJ_LONG ON ${base-name} (CHORUS_NUM_EJ_LONG)</sql><sql>CREATE INDEX CHORUS_WITH_PJ ON ${base-name} (CHORUS_WITH_PJ)</sql><sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><table base-name="EDMN_ETAT_LIASSES" id="T2" type="index" based-on="key1" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
BUDGET VARCHAR(1000) NOT NULL,
COLLECTIVITE VARCHAR(1000) NOT NULL,
ARCHIVE_NAME VARCHAR(1000),
NUM_LIASSE VARCHAR(1000) NOT NULL,
ANNEE_GESTION NUMBER,
INITIAL_DOC_NAME VARCHAR(1000)
-)</sql><sql>CREATE
- INDEX ${base-name}_BC ON ${base-name}
- (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_DC ON
- ${base-name} (DOC_ID)</sql><sql>CREATE INDEX LIASSE_ANNEE_GEST ON
- ${base-name} (COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql><sql>CREATE INDEX
- EDMN_LIASSE_CENTRALE ON ${base-name} (NUM_LIASSE)</sql><sql>CREATE INDEX
- ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX
- ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table>
- <table base-name="EDMN_ETAT_DOCS" type="document" version="1"
- ><sql xml:space="preserve">CREATE TABLE ${base-name} (
+)</sql><sql>CREATE INDEX ${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_DC ON ${base-name} (DOC_ID)</sql><sql>CREATE INDEX LIASSE_ANNEE_GEST ON ${base-name} (COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql><sql>CREATE INDEX EDMN_LIASSE_CENTRALE ON ${base-name} (NUM_LIASSE)</sql><sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><table base-name="EDMN_ETAT_DOCS" type="document" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
BUDGET VARCHAR(1000) NOT NULL,
COLLECTIVITE VARCHAR(1000) NOT NULL,
ARCHIVE_NAME VARCHAR(1000),
DOC BLOB,
ANNEE_GESTION NUMBER,
INITIAL_DOC_NAME VARCHAR(1000) NOT NULL
-)</sql><sql>CREATE
- INDEX ${base-name}_BC ON ${base-name}
- (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX EDMN_DOC_ANNEE_GESTION
- ON ${base-name} (COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql><sql>CREATE INDEX
- ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table>
- <criteria id="comptable" sql-index-id="comptable">
+)</sql><sql>CREATE INDEX ${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX EDMN_DOC_ANNEE_GESTION ON ${base-name} (COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><criteria id="comptable" sql-index-id="comptable">
<where-clause>fn:string-compare(${table}.${column},comptable)</where-clause>
- </criteria>
- <criteria id="lib-comptable" sql-index-id="lib-comptable">
+ </criteria><criteria id="lib-comptable" sql-index-id="lib-comptable">
<where-clause>fn:string-compare(${table}.${column},libComptable)</where-clause>
- </criteria>
- <criteria id="ministere" sql-index-id="ministere">
+ </criteria><criteria id="ministere" sql-index-id="ministere">
<where-clause>fn:string-compare(${table}.${column},ministere)</where-clause>
- </criteria>
- <criteria id="libministere" sql-index-id="lib-ministere">
+ </criteria><criteria id="libministere" sql-index-id="lib-ministere">
<where-clause>fn:string-compare(${table}.${column},ministereLib)</where-clause>
- </criteria>
- <criteria id="ordo" sql-index-id="ordo">
+ </criteria><criteria id="ordo" sql-index-id="ordo">
<where-clause>fn:string-compare(${table}.${column},ordo)</where-clause>
- </criteria>
- <criteria id="lib-ordo" sql-index-id="lib-ordo">
+ </criteria><criteria id="lib-ordo" sql-index-id="lib-ordo">
<where-clause>fn:string-compare(${table}.${column},libOrdo)</where-clause>
- </criteria>
- <criteria id="anneeBudget" sql-index-id="anneeBudget">
+ </criteria><criteria id="anneeBudget" sql-index-id="anneeBudget">
<where-clause>${table}.${column}##OPERATEUR:annee####VALEUR:annee##</where-clause>
- </criteria>
- <criteria id="numMandat" sql-index-id="numMandat">
+ </criteria><criteria id="numMandat" sql-index-id="numMandat">
<where-clause>fn:string-compare(${table}.${column},numMandat)</where-clause>
- </criteria>
- <criteria id="numOpeInvest" sql-index-id="numOpeInvest">
+ </criteria><criteria id="numOpeInvest" sql-index-id="numOpeInvest">
<where-clause>fn:string-compare(${table}.${column},numOpeInvest)</where-clause>
- </criteria>
- <criteria id="mtPj" sql-index-id="mtPj">
+ </criteria><criteria id="mtPj" sql-index-id="mtPj">
<where-clause>${table}.${column}##OPERATEUR:mtPj####VALEUR:mtPj##</where-clause>
- </criteria>
- <criteria id="dateCrea" sql-index-id="dateCrea">
+ </criteria><criteria id="dateCrea" sql-index-id="dateCrea">
<where-clause>fn:date-compare(${table}.${column},dateCrea)</where-clause>
- </criteria>
- <criteria id="datePaie" sql-index-id="datePaiement">
+ </criteria><criteria id="datePaie" sql-index-id="datePaiement">
<where-clause>fn:date-compare(${table}.${column},datePaie)</where-clause>
- </criteria>
- <criteria id="typeEvt" sql-index-id="typeEvt">
+ </criteria><criteria id="typeEvt" sql-index-id="typeEvt">
<where-clause>${table}.${column}='##VALEUR:typeEvt##'</where-clause>
- </criteria>
- <criteria id="liasseLocale" sql-index-id="numLiasseLocale">
+ </criteria><criteria id="liasseLocale" sql-index-id="numLiasseLocale">
<where-clause>fn:string-compare(${table}.${column},numLiasse)</where-clause>
- </criteria>
- <criteria id="liasseLocaleDeb" sql-index-id="numLiasseLocaleDeb">
+ </criteria><criteria id="liasseLocaleDeb" sql-index-id="numLiasseLocaleDeb">
<where-clause>fn:string-compare(${table}.${column},numLiasse)</where-clause>
- </criteria>
- <criteria id="liasseLocaleFin" sql-index-id="numLiasseLocaleFin">
+ </criteria><criteria id="liasseLocaleFin" sql-index-id="numLiasseLocaleFin">
<where-clause>fn:string-compare(${table}.${column},numLiasse)</where-clause>
- </criteria>
- <criteria id="liasseCentrale" sql-index-id="numLiasseCentrale">
+ </criteria><criteria id="liasseCentrale" sql-index-id="numLiasseCentrale">
<where-clause>fn:string-compare(${table}.${column},numLiasse)</where-clause>
- </criteria>
- <criteria id="programme" sql-index-id="programme">
+ </criteria><criteria id="programme" sql-index-id="programme">
<where-clause>fn:string-compare(${table}.${column},programme)</where-clause>
- </criteria>
- <criteria id="action" sql-index-id="action">
+ </criteria><criteria id="action" sql-index-id="action">
<where-clause>fn:string-compare(${table}.${column},action)</where-clause>
- </criteria>
- <criteria id="cpce" sql-index-id="cpce">
+ </criteria><criteria id="cpce" sql-index-id="cpce">
<where-clause>fn:string-compare(${table}.${column},cpce)</where-clause>
- </criteria>
- <criteria id="artPrev" sql-index-id="artPrev">
+ </criteria><criteria id="artPrev" sql-index-id="artPrev">
<where-clause>fn:string-compare(${table}.${column},artPrev)</where-clause>
- </criteria>
- <criteria id="libProgramme" sql-index-id="libProgramme">
+ </criteria><criteria id="libProgramme" sql-index-id="libProgramme">
<where-clause>fn:string-compare(${table}.${column},libProgramme)</where-clause>
- </criteria>
- <criteria id="libAction" sql-index-id="libAction">
+ </criteria><criteria id="libAction" sql-index-id="libAction">
<where-clause>fn:string-compare(${table}.${column},libAction)</where-clause>
- </criteria>
- <criteria id="codeOperExc" sql-index-id="codOperExc">
+ </criteria><criteria id="codeOperExc" sql-index-id="codOperExc">
<where-clause>fn:string-compare(${table}.${column},codeOperExc)</where-clause>
- </criteria>
- <criteria id="numPieceCompta" sql-index-id="numPieceCompta">
+ </criteria><criteria id="numPieceCompta" sql-index-id="numPieceCompta">
<where-clause>fn:string-compare(${table}.${column},numPieceCompta)</where-clause>
- </criteria>
- <criteria id="typePaiement" sql-index-id="typePaiement">
+ </criteria><criteria id="typePaiement" sql-index-id="typePaiement">
<where-clause>fn:string-compare(${table}.${column},typePaiement)</where-clause>
- </criteria>
- <criteria id="chapClassPJ" sql-index-id="chapClassPJ">
+ </criteria><criteria id="chapClassPJ" sql-index-id="chapClassPJ">
<where-clause>fn:string-compare(${table}.${column},chapClassPJ)</where-clause>
- </criteria>
- <criteria id="trimestre" sql-index-id="trimestre">
+ </criteria><criteria id="trimestre" sql-index-id="trimestre">
<where-clause>${table}.${column}##OPERATEUR:trimestre####VALEUR:trimestre##</where-clause>
- </criteria>
- <criteria id="nom_societe" sql-index-id="chorus_nom_societe">
+ </criteria><criteria id="nom_societe" sql-index-id="chorus_nom_societe">
<where-clause>fn:string-compare(${table}.${column},nom_societe)</where-clause>
- </criteria>
- <criteria id="fournisseur_nom" sql-index-id="chorus_fournisseur_nom">
+ </criteria><criteria id="fournisseur_nom" sql-index-id="chorus_fournisseur_nom">
<where-clause>fn:string-compare(${table}.${column},fournisseur_nom)</where-clause>
- </criteria>
- <criteria id="fournisseur_siret" sql-index-id="chorus_fournisseur_siret">
+ </criteria><criteria id="fournisseur_siret" sql-index-id="chorus_fournisseur_siret">
<where-clause>fn:string-compare(${table}.${column},fournisseur_siret)</where-clause>
- </criteria>
- <criteria id="payeur_nom" sql-index-id="chorus_payeur_nom">
+ </criteria><criteria id="payeur_nom" sql-index-id="chorus_payeur_nom">
<where-clause>fn:string-compare(${table}.${column},payeur_nom)</where-clause>
- </criteria>
- <criteria id="payeur_siret" sql-index-id="chorus_payeur_siret">
+ </criteria><criteria id="payeur_siret" sql-index-id="chorus_payeur_siret">
<where-clause>fn:string-compare(${table}.${column},payeur_siret)</where-clause>
- </criteria>
- <criteria id="rib_pays" sql-index-id="chorus_rib_pays">
+ </criteria><criteria id="rib_pays" sql-index-id="chorus_rib_pays">
<where-clause>fn:string-compare(${table}.${column},rib_pays)</where-clause>
- </criteria>
- <criteria id="rib_banc" sql-index-id="chorus_rib_banc">
+ </criteria><criteria id="rib_banc" sql-index-id="chorus_rib_banc">
<where-clause>fn:string-compare(${table}.${column},rib_banc)</where-clause>
- </criteria>
- <criteria id="rib_compte" sql-index-id="chorus_rib_compte">
+ </criteria><criteria id="rib_compte" sql-index-id="chorus_rib_compte">
<where-clause>fn:string-compare(${table}.${column},rib_compte)</where-clause>
- </criteria>
- <criteria id="rib_cle" sql-index-id="chorus_rib_cle">
+ </criteria><criteria id="rib_cle" sql-index-id="chorus_rib_cle">
<where-clause>fn:string-compare(${table}.${column},rib_cle)</where-clause>
- </criteria>
- <criteria id="domaine_fonctionnel" sql-index-id="chorus_domaine_fonctionnel">
+ </criteria><criteria id="domaine_fonctionnel" sql-index-id="chorus_domaine_fonctionnel">
<where-clause>fn:string-compare(${table}.${column},domaine_fonctionnel)</where-clause>
- </criteria>
- <criteria id="num_ej_long" sql-index-id="chorus_num_ej_long">
+ </criteria><criteria id="num_ej_long" sql-index-id="chorus_num_ej_long">
<where-clause>fn:string-compare(${table}.${column},num_ej_long)</where-clause>
- </criteria>
- <criteria id="with_pj" sql-index-id="chorus_with_pj">
+ </criteria><criteria id="with_pj" sql-index-id="chorus_with_pj">
<where-clause>${table}.${column}='##VALEUR:with_pj##'</where-clause>
- </criteria>
- <sql-index id="anneeBudget" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:AnneeBudget/@V"
- datatype="integer" table="T1" column="ANNEE_BUDG"/>
- <sql-index id="action" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ArtBudgExec/@V"
- datatype="string" table="T1" column="ART_BUDG" format="uppercase"/>
- <sql-index id="artPrev" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ArtBudgPrev/@V"
- datatype="string" table="T1" column="ART_BUDG_PREV" format="uppercase"/>
- <sql-index id="programme" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ChapBudg/@V"
- datatype="string" table="T1" column="CHAP_BUDG" format="uppercase"/>
- <sql-index id="chapClassPJ" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ChapClassPJ/@V"
- datatype="string" table="T1" column="CHAP_CLASS"/>
- <sql-index id="codOperExc" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:CodeOperExc/@V"
- datatype="string" table="T1" column="CODE_OPER_EXC" format="uppercase"/>
- <sql-index id="comptable" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Comptable/@V"
- datatype="string" table="T1" column="COMPTABLE" format="uppercase"/>
- <sql-index id="dateCrea" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:DateCreation/@V"
- datatype="date" table="T1" column="DATE_CREA" format="yyyy-MM-dd"/>
- <sql-index id="datePaiement" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:DatePaiement/@V"
- datatype="date" table="T1" column="DATE_PAIEMENT" format="yyyy-MM-dd"/>
- <sql-index id="imputation" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Imputation/@V"
- datatype="string" table="T1" column="IMPUTATION"/>
- <sql-index id="libAction" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleAction/@V"
- datatype="string" table="T1" column="LIB_ACTION" format="uppercase"/>
- <sql-index id="lib-comptable"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleComptable/@V" datatype="string"
- table="T1" column="LIB_COMPTABLE" format="uppercase"/>
- <sql-index id="lib-ministere"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Ministere/@LibelleMinistere"
- datatype="string" table="T1" column="LIB_MINISTERE" format="uppercase"/>
- <sql-index id="lib-ordo"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleOrdonnateur/@V" datatype="string"
- table="T1" column="LIB_ORDO" format="uppercase"/>
- <sql-index id="libProgramme"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleProgramme/@V" datatype="string"
- table="T1" column="LIB_PROGRAMME" format="uppercase"/>
- <sql-index id="ministere" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Ministere/@V"
- datatype="string" table="T1" column="MINISTERE" format="uppercase"/>
- <sql-index id="mtPj" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:MtPJ/@V"
- datatype="decimal" table="T1" column="MT_PJ"/>
- <sql-index id="numLiasseLocale" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasse/@V"
- datatype="string" table="T1" column="NUM_LIASSE_LOC" format="uppercase"/>
- <sql-index id="numLiasseLocaleDeb"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseDeb/@V" datatype="string"
- table="T1" column="NUM_LIASSE_DEB" format="uppercase"/>
- <sql-index id="numLiasseLocaleFin"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseFin/@V" datatype="string"
- table="T1" column="NUM_LIASSE_FIN" format="uppercase"/>
- <sql-index id="numMandat" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumMandat/@V"
- datatype="string" table="T1" column="NUM_MANDAT" format="uppercase"/>
- <sql-index id="ordo" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Ordo/@V"
- datatype="string" table="T1" column="ORDO" format="uppercase"/>
- <sql-index id="numOpeInvest" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumOpeInvest/@V"
- datatype="string" table="T1" column="OPE_INVEST" format="uppercase"/>
- <sql-index id="cpce" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ParagBudgExec/@V"
- datatype="string" table="T1" column="PARAG_BUDG" format="uppercase"/>
- <sql-index id="trimestre" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Trimestre/@V"
- datatype="integer" table="T1" column="TRIMESTRE"/>
- <sql-index id="typeEvt" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:TypeEvt/@V"
- datatype="string" table="T1" column="TYPE_EVT"/>
- <sql-index id="typePaiement" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:TypePaiement/@V"
- datatype="string" table="T1" column="TYPE_PAIEMENT"/>
- <sql-index id="numPieceCompta"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumPieceCompta/@V" datatype="string"
- table="T1" column="NUM_PIECE_COMPTA" format="uppercase"/>
- <sql-index id="chorus_nom_societe"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@NomSociete" datatype="string"
- table="T1" column="CHORUS_NOM_SOCIETE" format="uppercase"/>
- <sql-index id="chorus_fournisseur_nom"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@FournisseurNom"
- datatype="string" table="T1" column="CHORUS_FOURNISSEUR_NOM" format="uppercase"/>
- <sql-index id="chorus_fournisseur_siret"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@FournisseurSiret"
- datatype="string" table="T1" column="CHORUS_FOURNISSEUR_SIRET"
- format="uppercase"/>
- <sql-index id="chorus_payeur_nom"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@PayeurNom" datatype="string"
- table="T1" column="CHORUS_PAYEUR_NOM" format="uppercase"/>
- <sql-index id="chorus_payeur_siret"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@PayeurSiret" datatype="string"
- table="T1" column="CHORUS_PAYEUR_SIRET" format="uppercase"/>
- <sql-index id="chorus_rib_pays"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibPays" datatype="string"
- table="T1" column="CHORUS_RIB_PAYS" format="uppercase"/>
- <sql-index id="chorus_rib_banc"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibBanc" datatype="string"
- table="T1" column="CHORUS_RIB_BANC" format="uppercase"/>
- <sql-index id="chorus_rib_compte"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibCompte" datatype="string"
- table="T1" column="CHORUS_RIB_COMPTE" format="uppercase"/>
- <sql-index id="chorus_rib_cle"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibCle" datatype="string"
- table="T1" column="CHORUS_RIB_CLE" format="uppercase"/>
- <sql-index id="chorus_domaine_fonctionnel"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@DomaineFonctionnel"
- datatype="string" table="T1" column="CHORUS_DOMAINE_FONCTIONNEL"
- format="uppercase"/>
- <sql-index id="chorus_num_ej_long"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@NumEJLong" datatype="string"
- table="T1" column="CHORUS_NUM_EJ_LONG" format="uppercase"/>
- <sql-index id="chorus_with_pj" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/@added:withPJ"
- datatype="integer" table="T1" column="CHORUS_WITH_PJ"/>
- <sql-index id="numLiasseCentrale"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseNationale/n:Liasse/@national"
- datatype="string" table="T2" column="NUM_LIASSE" format="uppercase"/>
- <sql-index id="liasseAnneeGestion"
- path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:AnneeBudget/@V" datatype="integer"
- table="T2" column="ANNEE_GESTION" use-in-criteria="false"/>
- </etat>
- <etat id="ordos" import-xslt-file="edmn/edmn-import-mysql.xsl">
- <table base-name="EDMN_ORDOS_DOCS" type="document" version="1"
- ><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ </criteria><sql-index id="anneeBudget" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:AnneeBudget/@V" datatype="integer" table="T1" column="ANNEE_BUDG"/><sql-index id="action" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ArtBudgExec/@V" datatype="string" table="T1" column="ART_BUDG" format="uppercase"/><sql-index id="artPrev" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ArtBudgPrev/@V" datatype="string" table="T1" column="ART_BUDG_PREV" format="uppercase"/><sql-index id="programme" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ChapBudg/@V" datatype="string" table="T1" column="CHAP_BUDG" format="uppercase"/><sql-index id="chapClassPJ" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ChapClassPJ/@V" datatype="string" table="T1" column="CHAP_CLASS"/><sql-index id="codOperExc" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:CodeOperExc/@V" datatype="string" table="T1" column="CODE_OPER_EXC" format="uppercase"/><sql-index id="comptable" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Comptable/@V" datatype="string" table="T1" column="COMPTABLE" format="uppercase"/><sql-index id="dateCrea" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:DateCreation/@V" datatype="date" table="T1" column="DATE_CREA" format="yyyy-MM-dd"/><sql-index id="datePaiement" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:DatePaiement/@V" datatype="date" table="T1" column="DATE_PAIEMENT" format="yyyy-MM-dd"/><sql-index id="imputation" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Imputation/@V" datatype="string" table="T1" column="IMPUTATION"/><sql-index id="libAction" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleAction/@V" datatype="string" table="T1" column="LIB_ACTION" format="uppercase"/><sql-index id="lib-comptable" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleComptable/@V" datatype="string" table="T1" column="LIB_COMPTABLE" format="uppercase"/><sql-index id="lib-ministere" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Ministere/@LibelleMinistere" datatype="string" table="T1" column="LIB_MINISTERE" format="uppercase"/><sql-index id="lib-ordo" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleOrdonnateur/@V" datatype="string" table="T1" column="LIB_ORDO" format="uppercase"/><sql-index id="libProgramme" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleProgramme/@V" datatype="string" table="T1" column="LIB_PROGRAMME" format="uppercase"/><sql-index id="ministere" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Ministere/@V" datatype="string" table="T1" column="MINISTERE" format="uppercase"/><sql-index id="mtPj" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:MtPJ/@V" datatype="decimal" table="T1" column="MT_PJ"/><sql-index id="numLiasseLocale" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasse/@V" datatype="string" table="T1" column="NUM_LIASSE_LOC" format="uppercase"/><sql-index id="numLiasseLocaleDeb" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseDeb/@V" datatype="string" table="T1" column="NUM_LIASSE_DEB" format="uppercase"/><sql-index id="numLiasseLocaleFin" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseFin/@V" datatype="string" table="T1" column="NUM_LIASSE_FIN" format="uppercase"/><sql-index id="numMandat" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumMandat/@V" datatype="string" table="T1" column="NUM_MANDAT" format="uppercase"/><sql-index id="ordo" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Ordo/@V" datatype="string" table="T1" column="ORDO" format="uppercase"/><sql-index id="numOpeInvest" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumOpeInvest/@V" datatype="string" table="T1" column="OPE_INVEST" format="uppercase"/><sql-index id="cpce" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ParagBudgExec/@V" datatype="string" table="T1" column="PARAG_BUDG" format="uppercase"/><sql-index id="trimestre" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Trimestre/@V" datatype="integer" table="T1" column="TRIMESTRE"/><sql-index id="typeEvt" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:TypeEvt/@V" datatype="string" table="T1" column="TYPE_EVT"/><sql-index id="typePaiement" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:TypePaiement/@V" datatype="string" table="T1" column="TYPE_PAIEMENT"/><sql-index id="numPieceCompta" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumPieceCompta/@V" datatype="string" table="T1" column="NUM_PIECE_COMPTA" format="uppercase"/><sql-index id="chorus_nom_societe" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@NomSociete" datatype="string" table="T1" column="CHORUS_NOM_SOCIETE" format="uppercase"/><sql-index id="chorus_fournisseur_nom" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@FournisseurNom" datatype="string" table="T1" column="CHORUS_FOURNISSEUR_NOM" format="uppercase"/><sql-index id="chorus_fournisseur_siret" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@FournisseurSiret" datatype="string" table="T1" column="CHORUS_FOURNISSEUR_SIRET" format="uppercase"/><sql-index id="chorus_payeur_nom" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@PayeurNom" datatype="string" table="T1" column="CHORUS_PAYEUR_NOM" format="uppercase"/><sql-index id="chorus_payeur_siret" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@PayeurSiret" datatype="string" table="T1" column="CHORUS_PAYEUR_SIRET" format="uppercase"/><sql-index id="chorus_rib_pays" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibPays" datatype="string" table="T1" column="CHORUS_RIB_PAYS" format="uppercase"/><sql-index id="chorus_rib_banc" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibBanc" datatype="string" table="T1" column="CHORUS_RIB_BANC" format="uppercase"/><sql-index id="chorus_rib_compte" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibCompte" datatype="string" table="T1" column="CHORUS_RIB_COMPTE" format="uppercase"/><sql-index id="chorus_rib_cle" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibCle" datatype="string" table="T1" column="CHORUS_RIB_CLE" format="uppercase"/><sql-index id="chorus_domaine_fonctionnel" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@DomaineFonctionnel" datatype="string" table="T1" column="CHORUS_DOMAINE_FONCTIONNEL" format="uppercase"/><sql-index id="chorus_num_ej_long" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@NumEJLong" datatype="string" table="T1" column="CHORUS_NUM_EJ_LONG" format="uppercase"/><sql-index id="chorus_with_pj" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/@added:withPJ" datatype="integer" table="T1" column="CHORUS_WITH_PJ"/><sql-index id="numLiasseCentrale" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseNationale/n:Liasse/@national" datatype="string" table="T2" column="NUM_LIASSE" format="uppercase"/><sql-index id="liasseAnneeGestion" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:AnneeBudget/@V" datatype="integer" table="T2" column="ANNEE_GESTION" use-in-criteria="false"/></etat><etat id="ordos" import-xslt-file="edmn/edmn-import-mysql.xsl"><table base-name="EDMN_ORDOS_DOCS" type="document" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
BUDGET VARCHAR(1000) NOT NULL,
COLLECTIVITE VARCHAR(1000) NOT NULL,
ARCHIVE_NAME VARCHAR(1000),
DOC_ID VARCHAR(1000) NOT NULL,
DOC BLOB,
INITIAL_DOC_NAME VARCHAR(1000) NOT NULL
-)</sql><sql>CREATE
- INDEX ${base-name}_BC ON ${base-name}
- (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_AN ON
- ${base-name} (ARCHIVE_NAME)</sql></table>
- <table base-name="EDMN_ORDOS_INDEX" id="O1" type="index" main="true"
- ignoreConstraintError="true" version="1"
- ><sql xml:space="preserve">CREATE TABLE ${base-name} (
+)</sql><sql>CREATE INDEX ${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><table base-name="EDMN_ORDOS_INDEX" id="O1" type="index" main="true" ignoreConstraintError="true" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
BUDGET VARCHAR(1000) NOT NULL,
COLLECTIVITE VARCHAR(1000) NOT NULL,
ARCHIVE_NAME VARCHAR(1000),
LIBELLE VARCHAR(1000),
CODE VARCHAR(1000) NOT NULL,
TRIMESTRE NUMBER NOT NULL
-)</sql><sql>CREATE
- INDEX ${base-name}_BC ON ${base-name}
- (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_IDN ON
- ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON
- ${base-name} (ARCHIVE_NAME)</sql><sql>CREATE UNIQUE INDEX IX_${base-name} ON
- ${base-name}
- (COLLECTIVITE,BUDGET,ANNEE,TRIMESTRE,MINISTERE,CPTE_SPE_TRES,CODE)</sql></table>
- <criteria id="ordo.annee" sql-index-id="ordo.annee">
+)</sql><sql>CREATE INDEX ${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql><sql>CREATE UNIQUE INDEX IX_${base-name} ON ${base-name} (COLLECTIVITE,BUDGET,ANNEE,TRIMESTRE,MINISTERE,CPTE_SPE_TRES,CODE)</sql></table><criteria id="ordo.annee" sql-index-id="ordo.annee">
<where-clause>${table}.${column}##OPERATEUR:annee####VALEUR:annee##</where-clause>
- </criteria>
- <criteria id="ordo.ministere" sql-index-id="ordo.min">
+ </criteria><criteria id="ordo.ministere" sql-index-id="ordo.min">
<where-clause>fn:string-compare(${table}.${column},ministere)</where-clause>
- </criteria>
- <criteria id="programme" sql-index-id="prog">
+ </criteria><criteria id="programme" sql-index-id="prog">
<where-clause>fn:string-compare(${table}.${column},programme)</where-clause>
- </criteria>
- <criteria id="action" sql-index-id="act">
+ </criteria><criteria id="action" sql-index-id="act">
<where-clause>fn:string-compare(${table},${column},action)</where-clause>
- </criteria>
- <criteria id="artRegroupt" sql-index-id="artRegroupt">
+ </criteria><criteria id="artRegroupt" sql-index-id="artRegroupt">
<where-clause>fn:string-compare(${table}.${column},artRegroupt)</where-clause>
- </criteria>
- <criteria id="ordo.cpte.spe.tres" sql-index-id="ordo.compte">
+ </criteria><criteria id="ordo.cpte.spe.tres" sql-index-id="ordo.compte">
<where-clause>fn:string-compare(${table}.${column},compte)</where-clause>
- </criteria>
- <criteria id="ordo.libelle" sql-index-id="ordo.lib">
+ </criteria><criteria id="ordo.libelle" sql-index-id="ordo.lib">
<where-clause>fn:string-compare(${table}.${column},lib)</where-clause>
- </criteria>
- <criteria id="ordo.code" sql-index-id="ordo.code">
+ </criteria><criteria id="ordo.code" sql-index-id="ordo.code">
<where-clause>fn:string-compare(${table}.${column},code)</where-clause>
- </criteria>
- <sql-index id="ordo.annee"
- path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:Annee/@V"
- datatype="integer" table="O1" column="ANNEE"/>
- <sql-index id="ordo.min"
- path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:CodeMinistere/@V"
- datatype="string" table="O1" column="MINISTERE"/>
- <sql-index id="ordo.code"
- path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:CodeOrdo/@V"
- datatype="string" table="O1" column="CODE"/>
- <sql-index id="ordo.compte"
- path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:CompteSpeTresor/@V"
- datatype="string" table="O1" column="CPTE_SPE_TRES"/>
- <sql-index id="ordo.lib"
- path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:Libelle/@V"
- datatype="string" table="O1" column="LIBELLE" format="uppercase"/>
- </etat>
- <etat id="budgets" import-xslt-file="edmn/edmn-import-mysql.xsl">
- <table base-name="EDMN_BUDG_DOCS" type="document" version="1"
- ><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ </criteria><sql-index id="ordo.annee" path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:Annee/@V" datatype="integer" table="O1" column="ANNEE"/><sql-index id="ordo.min" path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:CodeMinistere/@V" datatype="string" table="O1" column="MINISTERE"/><sql-index id="ordo.code" path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:CodeOrdo/@V" datatype="string" table="O1" column="CODE"/><sql-index id="ordo.compte" path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:CompteSpeTresor/@V" datatype="string" table="O1" column="CPTE_SPE_TRES"/><sql-index id="ordo.lib" path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:Libelle/@V" datatype="string" table="O1" column="LIBELLE" format="uppercase"/></etat><etat id="budgets" import-xslt-file="edmn/edmn-import-mysql.xsl"><table base-name="EDMN_BUDG_DOCS" type="document" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
BUDGET VARCHAR(1000) NOT NULL,
COLLECTIVITE VARCHAR(1000) NOT NULL,
ARCHIVE_NAME VARCHAR(1000),
DOC_ID VARCHAR(1000) NOT NULL,
DOC BLOB,
INITIAL_DOC_NAME VARCHAR(1000) NOT NULL
-)</sql><sql>CREATE
- INDEX ${base-name}_BC ON ${base-name}
- (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_AN ON
- ${base-name} (ARCHIVE_NAME)</sql></table>
- <table base-name="EDMN_BUDG" id="B1" type="index" main="true"
- ignoreConstraintError="true" version="1"
- ><sql xml:space="preserve">CREATE TABLE ${base-name} (
- COLLECTIVITE VARCHAR(1000) NOT NULL,
- BUDGET VARCHAR(1000) NOT NULL,
+)</sql><sql>CREATE INDEX ${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><table base-name="EDMN_BUDG" id="B1" type="index" main="true" ignoreConstraintError="true" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ COLLECTIVITE VARCHAR(14) NOT NULL,
+ BUDGET VARCHAR(5) NOT NULL,
CPCE VARCHAR(1000),
DOC_ID VARCHAR(1000) NOT NULL,
ANNEE NUMBER NOT NULL,
- PROGRAMME VARCHAR(1000),
+ PROGRAMME VARCHAR(10),
INITIAL_DOC_NAME VARCHAR(1000),
ARCHIVE_NAME VARCHAR(1000),
- MINISTERE VARCHAR(1000) NOT NULL,
- ART_REGROUP VARCHAR(1000),
- DATA VARCHAR(1000) NOT NULL,
- ACTION VARCHAR(1000),
+ MINISTERE VARCHAR(10) NOT NULL,
+ ART_REGROUP VARCHAR(10),
+ DATA VARCHAR(20) NOT NULL,
+ ACTION VARCHAR(10),
LIBELLE VARCHAR(1000)
-)</sql><sql>CREATE
- INDEX ${base-name}_BC ON ${base-name}
- (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_IDN ON
- ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON
- ${base-name} (ARCHIVE_NAME)</sql><sql>CREATE UNIQUE INDEX IX_${base-name}_PK
- ON ${base-name}
- (COLLECTIVITE,BUDGET,ANNEE,DATA,MINISTERE,PROGRAMME,ACTION,ART_REGROUP)</sql></table>
- <criteria id="typeData" sql-index-id="typeData">
+)</sql><sql>CREATE INDEX ${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql><sql>CREATE UNIQUE INDEX IX_${base-name}_PK ON ${base-name} (COLLECTIVITE,BUDGET,ANNEE,DATA,MINISTERE,PROGRAMME,ACTION,ART_REGROUP)</sql></table><criteria id="typeData" sql-index-id="typeData">
<where-clause>${table}.${column}='##VALEUR:data##'</where-clause>
- </criteria>
- <criteria id="annee" sql-index-id="annee">
+ </criteria><criteria id="annee" sql-index-id="annee">
<where-clause>${table}.${column}##OPERATEUR:annee####VALEUR:annee##</where-clause>
- </criteria>
- <criteria id="ministere" sql-index-id="min">
+ </criteria><criteria id="ministere" sql-index-id="min">
<where-clause>fn:string-compare(${table}.${column},ministere)</where-clause>
- </criteria>
- <criteria id="programme" sql-index-id="prog">
+ </criteria><criteria id="programme" sql-index-id="prog">
<where-clause>fn:string-compare(${table}.${column},programme)</where-clause>
- </criteria>
- <criteria id="action" sql-index-id="act">
+ </criteria><criteria id="action" sql-index-id="act">
<where-clause>fn:string-compare(${table}.${column},action)</where-clause>
- </criteria>
- <criteria id="artRegroupt" sql-index-id="artRegroupt">
+ </criteria><criteria id="artRegroupt" sql-index-id="artRegroupt">
<where-clause>fn:string-compare(${table}.${column},artRegroupt)</where-clause>
- </criteria>
- <criteria id="cpce" sql-index-id="cpce2">
+ </criteria><criteria id="cpce" sql-index-id="cpce2">
<where-clause>fn:string-compare(${table}.${column},cpce)</where-clause>
- </criteria>
- <criteria id="libBudget" sql-index-id="budg.lib">
+ </criteria><criteria id="libBudget" sql-index-id="budg.lib">
<where-clause>fn:string-compare(${table}.${column},libBudg)</where-clause>
- </criteria>
- <sql-index id="typeData" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Data/@V"
- datatype="string" table="B1" column="DATA"/>
- <sql-index id="annee" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Annee/@V"
- datatype="integer" table="B1" column="ANNEE"/>
- <sql-index id="min" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Ministere/@V"
- datatype="string" table="B1" column="MINISTERE"/>
- <sql-index id="prog" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Programme/@V"
- datatype="string" table="B1" column="PROGRAMME"/>
- <sql-index id="act" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Action/@V"
- datatype="string" table="B1" column="ACTION"/>
- <sql-index id="artRegroupt"
- path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:ArticleRegroupt/@V"
- datatype="string" table="B1" column="ART_REGROUP" format="uppercase"/>
- <sql-index id="cpce2" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Cpce/@V"
- datatype="string" table="B1" column="CPCE" format="uppercase"/>
- <sql-index id="budg.lib" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Libelle/@V"
- datatype="string" table="B1" column="LIBELLE"/>
- </etat>
- </document>
- </layer>
-</persistence-config>
+ </criteria><sql-index id="typeData" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Data/@V" datatype="string" table="B1" column="DATA"/><sql-index id="annee" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Annee/@V" datatype="integer" table="B1" column="ANNEE"/><sql-index id="min" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Ministere/@V" datatype="string" table="B1" column="MINISTERE"/><sql-index id="prog" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Programme/@V" datatype="string" table="B1" column="PROGRAMME"/><sql-index id="act" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Action/@V" datatype="string" table="B1" column="ACTION"/><sql-index id="artRegroupt" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:ArticleRegroupt/@V" datatype="string" table="B1" column="ART_REGROUP" format="uppercase"/><sql-index id="cpce2" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Cpce/@V" datatype="string" table="B1" column="CPCE" format="uppercase"/><sql-index id="budg.lib" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Libelle/@V" datatype="string" table="B1" column="LIBELLE"/></etat></document></layer></persistence-config>
\ No newline at end of file