--- /dev/null
+<?xml version="1.0" encoding="ISO-8859-1"?>
+<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">
+ <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">
+ <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>
+ </table>
+ <table type="list-bc" base-name="EDMN_LIST_BUDG_COLL" version="1"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(15) NOT NULL, BUDGET VARCHAR(24) NOT NULL, BUDGET_LIB VARCHAR(200), COLLECTIVITE_LIB VARCHAR(200), INITIAL_DOC_NAME VARCHAR(100) NOT NULL, INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM </table>
+ <table type="special-key" base-name="EDMN_SPECIAL_KEYS" version="1"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(15) NOT NULL, BUDGET VARCHAR(24) NOT NULL, INITIAL_DOC_NAME VARCHAR(100) NOT NULL, KEY1 VARCHAR(100) NOT NULL, LIB1 VARCHAR(200), KEY2 VARCHAR(100), LIB2 VARCHAR(200), KEY3 VARCHAR(100), LIB3 VARCHAR(200), INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM </table>
+ <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 type="document" base-name="EDMN_ETATEDMN_DOCUMENTS" version="2">
+ CREATE TABLE IF NOT EXISTS ${base-name} (
+ COLLECTIVITE VARCHAR(15) NOT NULL,
+ BUDGET VARCHAR(24) NOT NULL,
+ INITIAL_DOC_NAME VARCHAR(100) NOT NULL,
+ DOC_ID 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">
+ <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) 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),
+ DATE_CREA DATE,
+ DATE_PAIEMENT DATE,
+ IMPUTATION CHAR(1),
+ LIB_ACTION VARCHAR(250),
+ LIB_COMPTABLE VARCHAR(250),
+ LIB_MINISTERE VARCHAR(250),
+ LIB_ORDO VARCHAR(250),
+ LIB_PROGRAMME VARCHAR(250),
+ MINISTERE VARCHAR(3),
+ MT_PJ DECIMAL(14,2),
+ NUM_ENGAG VARCHAR(6),
+ NUM_LIASSE_DEB VARCHAR(4),
+ NUM_LIASSE_FIN VARCHAR(4),
+ NUM_LIASSE_LOC VARCHAR(8),
+ NUM_MANDAT VARCHAR(6),
+ NUM_PIECE_COMPTA VARCHAR(32),
+ OPE_INVEST VARCHAR(8),
+ ORDO VARCHAR(10),
+ PARAG_BUDG VARCHAR(2),
+ TRIMESTRE INTEGER,
+ TYPE_EVT VARCHAR(3),
+ TYPE_PAIEMENT VARCHAR(3),
+ CHORUS_NOM_SOCIETE VARCHAR(25),
+ CHORUS_FOURNISSEUR_NOM VARCHAR(35),
+ CHORUS_FOURNISSEUR_SIRET VARCHAR(16),
+ CHORUS_PAYEUR_NOM VARCHAR(35),
+ CHORUS_PAYEUR_SIRET VARCHAR(16),
+ CHORUS_RIB_PAYS VARCHAR(3),
+ CHORUS_RIB_BANC VARCHAR(15),
+ CHORUS_RIB_COMPTE VARCHAR(18),
+ CHORUS_RIB_CLE VARCHAR(2),
+ CHORUS_DOMAINE_FONCTIONNEL VARCHAR(16),
+ CHORUS_NUM_EJ_LONG VARCHAR(40),
+ CHORUS_WITH_PJ INTEGER,
+ INDEX IX_ETATEDMN_ANNEE_BUDG (ANNEE_BUDG),
+ INDEX IX_ETATEDMN_ART_BUDG (ART_BUDG),
+ INDEX IX_ETATEDMN_ART_BDG_P (ART_BUDG_PREV),
+ INDEX IX_ETATEDMN_CHAP_BUDG (CHAP_BUDG),
+ INDEX IX_ETATEDMN_CHAP_CLASS (CHAP_CLASS),
+ INDEX IX_ETATEDMN_OPER_EXC (CODE_OPER_EXC),
+ INDEX IX_ETATEDMN_COMPTA (COMPTABLE),
+ INDEX IX_ETATEDMN_DATE_CREA (DATE_CREA),
+ INDEX IX_ETATEDMN_DTE_PAY (DATE_PAIEMENT),
+ INDEX IX_IMPUTATION (IMPUTATION),
+ INDEX IX_ETATEDMN_LIB_ACTION (LIB_ACTION),
+ INDEX IX_LIB_COMPTA (COLLECTIVITE,BUDGET,LIB_COMPTABLE),
+ INDEX IX_LIB_MINISTERE (COLLECTIVITE,BUDGET,LIB_MINISTERE),
+ INDEX IX_LIB_ORDO (COLLECTIVITE,BUDGET,LIB_ORDO),
+ INDEX IX_ETATEDMN_LIB_PROG (LIB_PROGRAMME),
+ INDEX IX_ETATEDMN_MINISTERE (MINISTERE),
+ INDEX IX_ETATEDMN_MT_PJ (MT_PJ),
+ INDEX IX_ETATEDMN_NUM_ENGAG (NUM_ENGAG),
+ INDEX IX_ETATEDMN_LIASSE_LOC (NUM_LIASSE_LOC),
+ INDEX IX_ETATEDMN_LIASSE_LOC_DEB (NUM_LIASSE_DEB),
+ INDEX IX_ETATEDMN_LIASSE_LOC_FIN (NUM_LIASSE_FIN),
+ INDEX IX_ETATEDMN_PIECE_COMPTA (NUM_PIECE_COMPTA),
+ INDEX IX_ETATEDMN_ORDO (ORDO),
+ INDEX IX_ETATEDMN_PARAG_BUDG (PARAG_BUDG),
+ INDEX IX_ETATEDMN_TRIM (TRIMESTRE),
+ INDEX IX_ETATEDMN_TYPE_EVT (TYPE_EVT),
+ INDEX IX_ETATEDMN_TYPE_PAY (TYPE_PAIEMENT),
+ INDEX IX_CHORUS_NOM_SOCIETE (CHORUS_NOM_SOCIETE),
+ INDEX IX_CHORUS_FOURNISSEUR_NOM (CHORUS_FOURNISSEUR_NOM),
+ INDEX IX_CHORUS_FOURNISSEUR_SIRET (CHORUS_FOURNISSEUR_SIRET),
+ INDEX IX_CHORUS_PAYEUR_NOM (CHORUS_PAYEUR_NOM),
+ INDEX IX_CHORUS_PAYEUR_SIRET (CHORUS_PAYEUR_SIRET),
+ INDEX IX_CHORUS_RIB_PAYS (CHORUS_RIB_PAYS),
+ INDEX IX_CHORUS_RIB_BANC (CHORUS_RIB_BANC),
+ INDEX IX_CHORUS_RIB_COMPTE (CHORUS_RIB_COMPTE),
+ INDEX IX_CHORUS_RIB_CLE (CHORUS_RIB_CLE),
+ INDEX IX_CHORUS_DOMAINE_FONCTIONNEL (CHORUS_DOMAINE_FONCTIONNEL),
+ INDEX IX_CHORUS_NUM_EJ_LONG (CHORUS_NUM_EJ_LONG),
+ INDEX IX_CHORUS_WITH_PJ (CHORUS_WITH_PJ),
+ 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">
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_COMPTABLE VARCHAR(250)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_ORDO VARCHAR(250)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_MINISTERE VARCHAR(250)</sql>
+ <sql failonerror="false">CREATE INDEX IX_LIB_COMPTA ON ${base-name} (COLLECTIVITE,BUDGET,LIB_COMPTABLE)</sql>
+ <sql failonerror="false">CREATE INDEX IX_LIB_MINISTERE ON ${base-name} (COLLECTIVITE,BUDGET,LIB_MINISTERE)</sql>
+ <sql failonerror="false">CREATE INDEX IX_LIB_ORDO ON ${base-name} (COLLECTIVITE,BUDGET,LIB_ORDO)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_PROGRAMME VARCHAR(250)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_ACTION VARCHAR(250)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CODE_OPER_EXC VARCHAR(32)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_PIECE_COMPTA VARCHAR(32)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_PROG ON ${base-name} (LIB_PROGRAMME)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_ACTION ON ${base-name} (LIB_ACTION)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_OPER_EXC ON ${base-name} (CODE_OPER_EXC)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_PIECE_COMPTA ON ${base-name} (NUM_PIECE_COMPTA)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_DEB VARCHAR(4)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_FIN VARCHAR(4)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_DEB ON ${base-name} (NUM_LIASSE_DEB)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_FIN ON ${base-name} (NUM_LIASSE_FIN)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD DATE_PAIEMENT DATE</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_DTE_PAY ON ${base-name} (DATE_PAIEMENT)</sql>
+ </patch>
+ <patch from-version="2">
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_MINISTERE VARCHAR(250)</sql>
+ <sql failonerror="false">CREATE INDEX IX_LIB_COMPTA ON ${base-name} (COLLECTIVITE,BUDGET,LIB_COMPTABLE)</sql>
+ <sql failonerror="false">CREATE INDEX IX_LIB_MINISTERE ON ${base-name} (COLLECTIVITE,BUDGET,LIB_MINISTERE)</sql>
+ <sql failonerror="false">CREATE INDEX IX_LIB_ORDO ON ${base-name} (COLLECTIVITE,BUDGET,LIB_ORDO)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_PROGRAMME VARCHAR(250)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_ACTION VARCHAR(250)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CODE_OPER_EXC VARCHAR(32)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_PIECE_COMPTA VARCHAR(32)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_PROG ON ${base-name} (LIB_PROGRAMME)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_ACTION ON ${base-name} (LIB_ACTION)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_OPER_EXC ON ${base-name} (CODE_OPER_EXC)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_PIECE_COMPTA ON ${base-name} (NUM_PIECE_COMPTA)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_DEB VARCHAR(4)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_FIN VARCHAR(4)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_DEB ON ${base-name} (NUM_LIASSE_DEB)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_FIN ON ${base-name} (NUM_LIASSE_FIN)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD DATE_PAIEMENT DATE</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_DTE_PAY ON ${base-name} (DATE_PAIEMENT)</sql>
+ </patch>
+ <patch from-version="3">
+ <sql failonerror="false">CREATE INDEX IX_LIB_COMPTA ON ${base-name} (COLLECTIVITE,BUDGET,LIB_COMPTABLE)</sql>
+ <sql failonerror="false">CREATE INDEX IX_LIB_MINISTERE ON ${base-name} (COLLECTIVITE,BUDGET,LIB_MINISTERE)</sql>
+ <sql failonerror="false">CREATE INDEX IX_LIB_ORDO ON ${base-name} (COLLECTIVITE,BUDGET,LIB_ORDO)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_PROGRAMME VARCHAR(250)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_ACTION VARCHAR(250)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CODE_OPER_EXC VARCHAR(32)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_PIECE_COMPTA VARCHAR(32)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_PROG ON ${base-name} (LIB_PROGRAMME)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_ACTION ON ${base-name} (LIB_ACTION)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_OPER_EXC ON ${base-name} (CODE_OPER_EXC)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_PIECE_COMPTA ON ${base-name} (NUM_PIECE_COMPTA)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_DEB VARCHAR(4)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_FIN VARCHAR(4)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_DEB ON ${base-name} (NUM_LIASSE_DEB)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_FIN ON ${base-name} (NUM_LIASSE_FIN)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD DATE_PAIEMENT DATE</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_DTE_PAY ON ${base-name} (DATE_PAIEMENT)</sql>
+ </patch>
+ <patch from-version="4">
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_PROGRAMME VARCHAR(250)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_ACTION VARCHAR(250)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CODE_OPER_EXC VARCHAR(32)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_PIECE_COMPTA VARCHAR(32)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_PROG ON ${base-name} (LIB_PROGRAMME)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_ACTION ON ${base-name} (LIB_ACTION)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_OPER_EXC ON ${base-name} (CODE_OPER_EXC)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_PIECE_COMPTA ON ${base-name} (NUM_PIECE_COMPTA)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_DEB VARCHAR(4)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_FIN VARCHAR(4)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_DEB ON ${base-name} (NUM_LIASSE_DEB)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_FIN ON ${base-name} (NUM_LIASSE_FIN)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD DATE_PAIEMENT DATE</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_DTE_PAY ON ${base-name} (DATE_PAIEMENT)</sql>
+ </patch>
+ <patch from-version="5">
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD IMPUTATION CHAR(1)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD INDEX IX_IMPUTATION(IMPUTATION)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD DATE_PAIEMENT DATE</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_DTE_PAY ON ${base-name} (DATE_PAIEMENT)</sql>
+ </patch>
+ <patch from-version="6">
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD DATE_PAIEMENT DATE</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_DTE_PAY ON ${base-name} (DATE_PAIEMENT)</sql>
+ </patch>
+ <patch from-version="7">
+ <sql failonerror="false">ALTER TABLE ${base-name} MODIFY MT_PJ DECIMAL(17,2)</sql>
+ </patch>
+ <patch from-version="8">
+ <sql failonerror="false">DROP INDEX IX_ETATEDMN_ANNEE_ENGAG ON ${base-name}</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} DROP ANNEE_ENGAG</sql>
+ <sql failonerror="false">DROP INDEX IX_ETATEDMN_CPTE_TRESOR ON ${base-name}</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} DROP CPTE_TRESOR</sql>
+ <sql failonerror="false">DROP INDEX IX_ETATEDMN_ECO1 ON ${base-name}</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} DROP SUIVI_ECO1</sql>
+ <sql failonerror="false">DROP INDEX IX_ETATEDMN_ECO2 ON ${base-name}</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} DROP SUIVI_ECO2</sql>
+ <sql failonerror="false">DROP INDEX IX_ETATEDMN_ECO3 ON ${base-name}</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} DROP SUIVI_ECO3</sql>
+ <sql failonerror="false">DROP INDEX IX_ETATEDMN_MOIS ON ${base-name}</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} DROP MOIS</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} DROP ZONE24</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} DROP ZONE32</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} DROP SIGNE_MT</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} DROP CODE_CORR</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} DROP CODE_MANIP</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} DROP NUM_LIASSE</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_NOM_SOCIETE VARCHAR(25)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_FOURNISSEUR_NOM VARCHAR(35)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_FOURNISSEUR_SIRET VARCHAR(16)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_PAYEUR_NOM VARCHAR(35)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_PAYEUR_SIRET VARCHAR(16)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_RIB_PAYS VARCHAR(3)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_RIB_BANC VARCHAR(15)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_RIB_COMPTE VARCHAR(18)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_RIB_CLE VARCHAR(2)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_DOMAINE_FONCTIONNEL VARCHAR(16)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_NUM_EJ_LONG VARCHAR(40)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_WITH_PJ INTEGER</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_NOM_SOCIETE ON ${base-name} (CHORUS_NOM_SOCIETE)</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_FOURNISSEUR_NOM ON ${base-name} (CHORUS_FOURNISSEUR_NOM)</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_FOURNISSEUR_SIRET ON ${base-name} (CHORUS_FOURNISSEUR_SIRET)</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_PAYEUR_NOM ON ${base-name} (CHORUS_PAYEUR_NOM)</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_PAYEUR_SIRET ON ${base-name} (CHORUS_PAYEUR_SIRET)</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_RIB_PAYS ON ${base-name} (CHORUS_RIB_PAYS)</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_RIB_BANC ON ${base-name} (CHORUS_RIB_BANC)</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_RIB_COMPTE ON ${base-name} (CHORUS_RIB_COMPTE)</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_RIB_CLE ON ${base-name} (CHORUS_RIB_CLE)</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_DOMAINE_FONCTIONNEL ON ${base-name} (CHORUS_DOMAINE_FONCTIONNEL)</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_NUM_EJ_LONG ON ${base-name} (CHORUS_NUM_EJ_LONG)</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_WITH_PJ ON ${base-name} (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 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">
+ <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>
+ </patch>
+ <patch from-version="2">
+ <sql failonerror="false">CREATE INDEX IX_EDMN_ETATEDMN_LIASSES_LIASSE_CENTRALE ON ${base-name} (NUM_LIASSE)</sql>
+ </patch>
+ </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">
+ <where-clause>fn:string-compare(${table}.${column},libComptable)</where-clause>
+ </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">
+ <where-clause>fn:string-compare(${table}.${column},ministereLib)</where-clause>
+ </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">
+ <where-clause>fn:string-compare(${table}.${column},libOrdo)</where-clause>
+ </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">
+ <where-clause>fn:string-compare(${table}.${column},numMandat)</where-clause>
+ </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">
+ <where-clause>${table}.${column}##OPERATEUR:mtPj####VALEUR:mtPj##</where-clause>
+ </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">
+ <where-clause>fn:date-compare(${table}.${column},datePaie)</where-clause>
+ </criteria>
+ <criteria id="typeEvt" sql-index-id="typeEvt">
+ <where-clause>${table}.${column}='##VALEUR:typeEvt##'</where-clause>
+ </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">
+ <where-clause>fn:string-compare(${table}.${column},numLiasse)</where-clause>
+ </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">
+ <where-clause>fn:string-compare(${table}.${column},numLiasse)</where-clause>
+ </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">
+ <where-clause>fn:string-compare(${table}.${column},action)</where-clause>
+ </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">
+ <where-clause>fn:string-compare(${table}.${column},artPrev)</where-clause>
+ </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">
+ <where-clause>fn:string-compare(${table}.${column},libAction)</where-clause>
+ </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">
+ <where-clause>fn:string-compare(${table}.${column},numPieceCompta)</where-clause>
+ </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">
+ <where-clause>fn:string-compare(${table}.${column},chapClassPJ)</where-clause>
+ </criteria>
+ <criteria id="trimestre" sql-index-id="trimestre">
+ <where-clause>${table}.${column}##OPERATEUR:trimestre####VALEUR:trimestre##</where-clause>
+ </criteria>
+ <!-- CHORUS -->
+ <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">
+ <where-clause>fn:string-compare(${table}.${column},fournisseur_nom)</where-clause>
+ </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">
+ <where-clause>fn:string-compare(${table}.${column},payeur_nom)</where-clause>
+ </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">
+ <where-clause>fn:string-compare(${table}.${column},rib_pays)</where-clause>
+ </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">
+ <where-clause>fn:string-compare(${table}.${column},rib_compte)</where-clause>
+ </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">
+ <where-clause>fn:string-compare(${table}.${column},domaine_fonctionnel)</where-clause>
+ </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">
+ <where-clause>${table}.${column}='##VALEUR:with_pj##'</where-clause>
+ </criteria>
+
+
+ <!-- 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"/>
+
+ <!-- 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"/>
+
+ <!-- chap class -->
+ </etat>
+ <etat id="budgets" import-xslt-file="edmn/edmn-import-mysql.xsl">
+ <table base-name="EDMN_BUDG_DOCUMENTS" type="document" version="1">
+ CREATE TABLE IF NOT EXISTS ${base-name} (
+ COLLECTIVITE VARCHAR(15) NOT NULL,
+ BUDGET VARCHAR(24) NOT NULL,
+ INITIAL_DOC_NAME VARCHAR(100) NOT NULL,
+ DOC_ID 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="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),
+ ART_REGROUP VARCHAR(6),
+ CPCE VARCHAR(6),
+ LIBELLE VARCHAR(150),
+ INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
+ UNIQUE INDEX IX_${base-name}_PK (COLLECTIVITE,BUDGET,ANNEE,DATA,MINISTERE,PROGRAMME,ACTION,ART_REGROUP),
+ 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">
+ <sql failonerror="false">drop table EDMN_BUDG_INDEX</sql>
+ <sql>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),
+ CPCE VARCHAR(6),
+ ART_REGROUP VARCHAR(6),
+ LIBELLE VARCHAR(150),
+ INDEX IX_EDMN_BUDG_INDEX_BC (COLLECTIVITE,BUDGET,DOC_ID),
+ UNIQUE INDEX IX_EDMN_BUDG_INDEX_PK (COLLECTIVITE,BUDGET,ANNEE,DATA,MINISTERE,PROGRAMME,ACTION,ART_REGROUP),
+ INITIAL_DOC_NAME VARCHAR(100),
+ INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME)
+ ) ENGINE MYISAM
+ </sql>
+ </patch>
+ <patch from-version="2">
+ <sql failonerror="false">drop table EDMN_BUDG_INDEX</sql>
+ <sql>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),
+ CPCE VARCHAR(6),
+ ART_REGROUP VARCHAR(6),
+ LIBELLE VARCHAR(150),
+ INDEX IX_EDMN_BUDG_INDEX_BC (COLLECTIVITE,BUDGET,DOC_ID),
+ UNIQUE INDEX IX_EDMN_BUDG_INDEX_PK (COLLECTIVITE,BUDGET,ANNEE,DATA,MINISTERE,PROGRAMME,ACTION,ART_REGROUP),
+ INITIAL_DOC_NAME VARCHAR(100),
+ INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME)
+ ) ENGINE MYISAM
+ </sql>
+ </patch>
+ </table>
+ <criteria id="typeData" sql-index-id="typeData">
+ <where-clause>${table}.${column}='##VALEUR:data##'</where-clause>
+ </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">
+ <where-clause>fn:string-compare(${table}.${column},ministere)</where-clause>
+ </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">
+ <where-clause>fn:string-compare(${table}.${column},action)</where-clause>
+ </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">
+ <where-clause>fn:string-compare(${table}.${column},cpce)</where-clause>
+ </criteria>
+ <criteria id="libBudget" sql-index-id="budg.lib">
+ <where-clause>fn:string-compare(${table}.${column},libBudg)</where-clause>
+ </criteria>
+
+
+
+ <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 NOT EXISTS ${base-name} (
+ COLLECTIVITE VARCHAR(15) NOT NULL,
+ BUDGET VARCHAR(24) NOT NULL,
+ INITIAL_DOC_NAME VARCHAR(100) NOT NULL,
+ DOC_ID 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="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 NULL,
+ LIBELLE VARCHAR(150),
+ INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
+ UNIQUE INDEX IX_${base-name}_PK (COLLECTIVITE,BUDGET,ANNEE,TRIMESTRE,MINISTERE,CPTE_SPE_TRES,CODE),
+ 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">
+ <sql failonerror="false">drop table EDMN_ORDOS_INDEX</sql>
+ <sql>CREATE TABLE IF NOT EXISTS EDMN_ORDOS_INDEX (
+ 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 NULL,
+ LIBELLE VARCHAR(150),
+ INDEX IX_EDMN_ORDOS_INDEX_BC (COLLECTIVITE,BUDGET,DOC_ID),
+ UNIQUE INDEX IX_EDMN_ORDOS_INDEX_PK (COLLECTIVITE,BUDGET,ANNEE,TRIMESTRE,MINISTERE,CPTE_SPE_TRES,CODE),
+ INITIAL_DOC_NAME VARCHAR(100),
+ INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME)
+ ) ENGINE MYISAM</sql>
+ </patch>
+
+ </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">
+ <where-clause>fn:string-compare(${table}.${column},ministere)</where-clause>
+ </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">
+ <where-clause>fn:string-compare(${table},${column},action)</where-clause>
+ </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">
+ <where-clause>fn:string-compare(${table}.${column},compte)</where-clause>
+ </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">
+ <where-clause>fn:string-compare(${table}.${column},code)</where-clause>
+ </criteria>
+
+
+
+ <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 IF NOT EXISTS ${base-name} (
+ COLLECTIVITE VARCHAR(15) NOT NULL,
+ BUDGET VARCHAR(24) NOT NULL,
+ INITIAL_DOC_NAME VARCHAR(100) NOT NULL,
+ DOC_ID 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} (
+ 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">
+ <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,
+ ANNEE INTEGER NOT NULL,
+ CODE VARCHAR(6) NOT NULL,
+ LIBELLE VARCHAR(150),
+ UNIQUE INDEX IX_EDMN_COMPTA_INDEX_PK (COLLECTIVITE,BUDGET,CODE,ANNEE),
+ INDEX IX_EDMN_COMPTA_INDEX_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</sql>
+ </patch>
+ <patch from-version="2">
+ <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,
+ ANNEE INTEGER NOT NULL,
+ CODE VARCHAR(6) NOT NULL,
+ LIBELLE VARCHAR(150),
+ UNIQUE INDEX IX_EDMN_COMPTA_INDEX_PK (COLLECTIVITE,BUDGET,CODE,ANNEE),
+ INDEX IX_EDMN_COMPTA_INDEX_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</sql>
+ </patch>
+
+ </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">
+ <where-clause>fn:string-compare(${table}.${column},code)</where-clause>
+ </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" 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>
+</persistence-config>