--- /dev/null
+<?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="rsa-rec">
+ <table base-name="RSA_REC_LBC" type="list-bc" version="1" xml:space="preserve">
+ 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,
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_BC (COLLECTIVITE,BUDGET),
+ INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM
+ </table>
+ <etat id="Creances" import-xslt-file="rsa/rsa-import-mysql.xsl">
+ <key1>
+ <path>/n:Racine/n:CreancesRSA/n:InfosCreanceFoyerRSA/@added:generated-id</path>
+ </key1>
+ <key2>
+ <path>/n:Racine/n:CreancesRSA/n:InfosCreanceFoyerRSA/n:Creance/n:CreancesTransferees/@added:generated-id</path>
+ </key2>
+ <table type="document" base-name="RSA_REC_DOCS" 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,
+ ENCODING VARCHAR(20),
+ DOC LONGBLOB,
+ INDEX ${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID) ,
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME)
+ ) ENGINE MYISAM
+ </table>
+ <table type="index" id="RSA_REC_CREANCIER" base-name="RSA_REC_CREANCIER" version="1" main="true" 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,
+ INITIAL_DOC_NAME VARCHAR(100),
+ ARCHIVE_NAME VARCHAR(100),
+ ALLOC_NOM VARCHAR(200),
+ ALLOC_NOM_NAI VARCHAR(200),
+ ALLOC_PRENOM VARCHAR(200),
+ ALLOC_NIR VARCHAR(15),
+ ALLOC_MATRICULE VARCHAR(100),
+ ALLOC_DATE_NAI DATE,
+ ALLOC_ADR_VOIE VARCHAR(150),
+ ALLOC_ADR_CP VARCHAR(10),
+ ALLOC_ADR_VILLE VARCHAR(150),
+ PART_ID VARCHAR(10),
+ PART_NAT VARCHAR(10),
+ FILE_NAME VARCHAR(250),
+ INDEX ${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
+ INDEX ${base-name}_DC (DOC_ID),
+ INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
+ INDEX ${base-name}_AN (ARCHIVE_NAME)
+ ) ENGINE MYISAM
+ </table>
+ <table id="RSA_REC_DETAIL" base-name="RSA_REC_DETAIL" type="index" version="1" based-on="key2">
+ CREATE TABLE IF NOT EXISTS ${base-name} (
+ COLLECTIVITE VARCHAR(15) NOT NULL,
+ BUDGET VARCHAR(24) NOT NULL,
+ DOC_ID VARCHAR(100) NOT NULL,
+ INITIAL_DOC_NAME VARCHAR(100),
+ ARCHIVE_NAME VARCHAR(100),
+ NAT_CREANCE VARCHAR(3),
+ MT_CREANCE_TRANSF DECIMAL(14,2),
+ MOIS_MOUV_COMPTA DATE,
+ MOTIF_INDU VARCHAR(2),
+ ORIGIN_INDU VARCHAR(2),
+ RESP_INDU VARCHAR(2),
+ INDEX ${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
+ INDEX ${base-name}_DC (DOC_ID),
+ INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
+ INDEX ${base-name}_AN (ARCHIVE_NAME)
+ ) ENGINE MYISAM
+ </table>
+ <criteria id="alloc.nom" sql-index-id="sql.alloc.nom">
+ <where-clause>fn:string-compare(${table}.${column},alloc.nom)</where-clause>
+ </criteria>
+ <criteria id="alloc.nom.nai" sql-index-id="sql.alloc.nom.nai">
+ <where-clause>fn:string-compare(${table}.${column},alloc.nom.nai)</where-clause>
+ </criteria>
+ <criteria id="alloc.prenom" sql-index-id="sql.alloc.prenom">
+ <where-clause>fn:string-compare(${table}.${column},alloc.prenom)</where-clause>
+ </criteria>
+ <criteria id="alloc.nir" sql-index-id="sql.alloc.nir">
+ <where-clause>fn:string-compare(${table}.${column},alloc.nir)</where-clause>
+ </criteria>
+ <criteria id="alloc.matricule" sql-index-id="sql.alloc.matricule">
+ <where-clause>fn:string-compare(${table}.${column},alloc.matricule)</where-clause>
+ </criteria>
+ <criteria id="alloc.date.naiss" sql-index-id="sql.alloc.date.naiss">
+ <where-clause>fn:date-compare(${table}.${column},alloc.date.naiss)</where-clause>
+ </criteria>
+ <criteria id="adr.nom.voie" sql-index-id="sql.adr.nom.voie">
+ <where-clause>fn:string-compare(${table}.${column},adr.nom.voie)</where-clause>
+ </criteria>
+ <criteria id="adr.cp" sql-index-id="sql.adr.cp">
+ <where-clause>fn:string-compare(${table}.${column},adr.cp)</where-clause>
+ </criteria>
+ <criteria id="adr.ville" sql-index-id="sql.adr.ville">
+ <where-clause>fn:string-compare(${table}.${column},adr.ville)</where-clause>
+ </criteria>
+ <criteria id="part.id" sql-index-id="sql.part.id">
+ <where-clause>fn:string-compare(${table}.column},id.part)</where-clause>
+ </criteria>
+ <criteria id="part.nat" sql-index-id="sql.part.nat">
+ <where-clause>${table}.${column}='##VALEUR:type.part##'</where-clause>
+ </criteria>
+ <criteria id="nom.fichier" sql-index-id="sql.file.name">
+ <where-clause>fn:string-compare(${table}.${column},file.name)</where-clause>
+ </criteria>
+ <criteria id="nature.creance" sql-index-id="sql.nat.creance">
+ <where-clause>${table}.${column}='##VALEUR:nat.creance##'</where-clause>
+ </criteria>
+ <criteria id="mt.creance.transferee" sql-index-id="sql.mt.creance.transf">
+ <where-clause>${table}.${column}##OPERATEUR:mt.creance.trans####VALEUR:mt.creance.trans##</where-clause>
+ </criteria>
+ <criteria id="mois.mouv.compta" sql-index-id="sql.mois.mouv.compta">
+ <where-clause>fn:date-compare(${table}.${column},mois.transf)</where-clause>
+ </criteria>
+ <criteria id="motif.indu" sql-index-id="sql.motif.indu">
+ <where-clause>${table}.${column}='##VALEUR:motif.indu##'</where-clause>
+ </criteria>
+ <criteria id="origine.indu" sql-index-id="sql.origine.indu">
+ <where-clause>${table}.${column}='##VALEUR:origine.indu##'</where-clause>
+ </criteria>
+ <criteria id="resp.indu" sql-index-id="sql.resp.indu">
+ <where-clause>${table}.${column}='##VALEUR:resp.indu##'</where-clause>
+ </criteria>
+ <sql-index id="sql.alloc.nom" table="RSA_REC_CREANCIER" column="ALLOC_NOM" path="/n:Racine/n:CreancesRSA/n:InfosCreanceFoyerRSA/n:Personne/n:Identification/n:NOM/text()" datatype="string" format="uppercase"/>
+ <sql-index id="sql.alloc.nom.nai" table="RSA_REC_CREANCIER" column="ALLOC_NOM_NAI" path="/n:Racine/n:CreancesRSA/n:InfosCreanceFoyerRSA/n:Personne/n:Identification/n:NOMNAI/text()" datatype="string" format="uppercase"/>
+ <sql-index id="sql.alloc.prenom" table="RSA_REC_CREANCIER" column="ALLOC_PRENOM" path="/n:Racine/n:CreancesRSA/n:InfosCreanceFoyerRSA/n:Personne/n:Identification/n:PRENOM/text()" datatype="string" format="uppercase"/>
+ <sql-index id="sql.alloc.nir" table="RSA_REC_CREANCIER" column="ALLOC_NIR" path="/n:Racine/n:CreancesRSA/n:InfosCreanceFoyerRSA/n:Personne/n:Identification/n:NIR/text()" datatype="string"/>
+ <sql-index id="sql.alloc.matricule" table="RSA_REC_CREANCIER" column="ALLOC_MATRICULE" path="/n:Racine/n:CreancesRSA/n:InfosCreanceFoyerRSA/n:IdentificationRSA/n:Organisme/n:MATRICULE/text()" datatype="string"/>
+ <sql-index id="sql.alloc.date.naiss" table="RSA_REC_CREANCIER" column="ALLOC_DATE_NAI" path="/n:Racine/n:CreancesRSA/n:InfosCreanceFoyerRSA/n:Personne/n:Identification/n:DTNAI/text()" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="sql.adr.nom.voie" table="RSA_REC_CREANCIER" column="ALLOC_ADR_VOIE" path="/n:Racine/n:CreancesRSA/n:InfosCreanceFoyerRSA/n:DonneesAdministratives/n:Adresse/n:NOMVOIE/text()" datatype="string" format="uppercase"/>
+ <sql-index id="sql.adr.cp" table="RSA_REC_CREANCIER" column="ALLOC_ADR_CP" path="/n:Racine/n:CreancesRSA/n:InfosCreanceFoyerRSA/n:DonneesAdministratives/n:Adresse/n:CODEPOS/text()" datatype="string"/>
+ <sql-index id="sql.adr.ville" table="RSA_REC_CREANCIER" column="ALLOC_ADR_VILLE" path="/n:Racine/n:CreancesRSA/n:InfosCreanceFoyerRSA/n:DonneesAdministratives/n:Adresse/n:LOCAADR/text()" datatype="string" format="uppercase"/>
+ <sql-index id="sql.part.id" table="RSA_REC_CREANCIER" column="PART_ID" path="/n:Racine/n:CreancesRSA/n:InfosCreanceFoyerRSA/n:IdentificationRSA/n:Partenaire/n:IDEPARTE/text()" datatype="string" format="uppercase"/>
+ <sql-index id="sql.part.nat" table="RSA_REC_CREANCIER" column="PART_NAT" path="/n:Racine/n:CreancesRSA/n:InfosCreanceFoyerRSA/n:IdentificationRSA/n:Partenaire/n:TYPEPARTE/text()" datatype="string"/>
+ <sql-index id="sql.file.name" table="RSA_REC_CREANCIER" column="FILE_NAME" path="/n:Racine/@added:file-name" datatype="string" format="uppercase"/>
+ <sql-index id="sql.nat.creance" table="RSA_REC_DETAIL" column="NAT_CREANCE" path="/n:Racine/n:CreancesRSA/n:InfosCreanceFoyerRSA/n:Creance/n:CreancesTransferees/n:IdentificationCreance/n:NATCRE/text()" datatype="string"/>
+ <sql-index id="sql.mt.creance.transf" table="RSA_REC_DETAIL" column="MT_CREANCE_TRANSF" path="/n:Racine/n:CreancesRSA/n:InfosCreanceFoyerRSA/n:Creance/n:CreancesTransferees/n:DetailCreance/n:MTSOLREELCRETRANS/text()" datatype="decimal"/>
+ <sql-index id="sql.mois.mouv.compta" table="RSA_REC_DETAIL" column="MOIS_MOUV_COMPTA" path="/n:Racine/n:CreancesRSA/n:InfosCreanceFoyerRSA/n:Creance/n:CreancesTransferees/n:DetailCreance/n:MOISMOUCOMPTA/text()" datatype="date" format="yyyy-MM-dd"/>
+ <sql-index id="sql.motif.indu" table="RSA_REC_DETAIL" column="MOTIF_INDU" path="/n:Racine/n:CreancesRSA/n:InfosCreanceFoyerRSA/n:Creance/n:CreancesTransferees/n:DetailCreance/n:MOTIINDU/text()" datatype="string"/>
+ <sql-index id="sql.origine.indu" table="RSA_REC_DETAIL" column="ORIGIN_INDU" path="/n:Racine/n:CreancesRSA/n:InfosCreanceFoyerRSA/n:Creance/n:CreancesTransferees/n:DetailCreance/n:ORIINDU/text()" datatype="string"/>
+ <sql-index id="sql.resp.indu" table="RSA_REC_DETAIL" column="RESP_INDU" path="/n:Racine/n:CreancesRSA/n:InfosCreanceFoyerRSA/n:Creance/n:CreancesTransferees/n:DetailCreance/n:RESPINDU/text()" datatype="string"/>
+ </etat>
+ </document>
+ </layer>
+</persistence-config>