-<?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">
+<?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="ref-collec-spl" repository-import-xslt-file="">
<table base-name="REF_COLL_SPL_LIST_BC" type="list-bc" version="1">
<sql-index id="SQI_REFERENTIEL_REFERENTIEL_EXERCICE" path="/n:Referentiel/n:Exercice/text()" datatype="integer" column="EXERCICE" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX"/>
<!-- SQL-INDEX /Referentiel/CollectivitesSPL/Collectivite -->
- <sql-index id="SQI_REFERENTIEL_COLLECTIVITE_BUDGET-PRINC" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@budget-princ" datatype="string" column="BUDGET_PRINC" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase" />
- <sql-index id="SQI_REFERENTIEL_COLLECTIVITE_CODCOLL" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@codColl" datatype="string" column="CODCOLL" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase" />
- <sql-index id="SQI_REFERENTIEL_COLLECTIVITE_IDCOLL" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@idColl" datatype="string" column="IDCOLL" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase" />
- <sql-index id="SQI_REFERENTIEL_COLLECTIVITE_CODBUDG" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@codBudg" datatype="string" column="CODBUDG" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase" />
- <sql-index id="SQI_REFERENTIEL_COLLECTIVITE_CODIC" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@codic" datatype="string" column="CODIC" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase" />
- <sql-index id="SQI_REFERENTIEL_COLLECTIVITE_LIBELLE" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@libelle" datatype="string" column="LIBELLE" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase" />
- <sql-index id="SQI_REFERENTIEL_COLLECTIVITE_LIBELLE-POSTE" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@libelle-poste" datatype="string" column="LIBELLE_POSTE" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase" />
- <sql-index id="SQI_REFERENTIEL_COLLECTIVITE_CODEINSEE" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@codeInsee" datatype="string" column="CODEINSEE" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase" />
+ <sql-index id="SQI_REFERENTIEL_COLLECTIVITE_BUDGET-PRINC" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@budget-princ" datatype="string" column="BUDGET_PRINC" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase"/>
+ <sql-index id="SQI_REFERENTIEL_COLLECTIVITE_CODCOLL" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@codColl" datatype="string" column="CODCOLL" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase"/>
+ <sql-index id="SQI_REFERENTIEL_COLLECTIVITE_IDCOLL" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@idColl" datatype="string" column="IDCOLL" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase"/>
+ <sql-index id="SQI_REFERENTIEL_COLLECTIVITE_CODBUDG" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@codBudg" datatype="string" column="CODBUDG" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase"/>
+ <sql-index id="SQI_REFERENTIEL_COLLECTIVITE_CODIC" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@codic" datatype="string" column="CODIC" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase"/>
+ <sql-index id="SQI_REFERENTIEL_COLLECTIVITE_LIBELLE" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@libelle" datatype="string" column="LIBELLE" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase"/>
+ <sql-index id="SQI_REFERENTIEL_COLLECTIVITE_LIBELLE-POSTE" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@libelle-poste" datatype="string" column="LIBELLE_POSTE" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase"/>
+ <sql-index id="SQI_REFERENTIEL_COLLECTIVITE_CODEINSEE" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@codeInsee" datatype="string" column="CODEINSEE" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase"/>
<sql-index id="SQI_JURI_FI" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@juri-finan" datatype="string" column="JURI_FINAN" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase"/>
<sql-index id="SQI_GROUPE" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@groupe" datatype="string" column="GROUPE" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase"/>
<sql-index id="SQI_NOMENCL" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@nomencl" datatype="string" column="NOMENCL" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase"/>
</document>
</layer>
-</persistence-config>
+
+<layer name="oracle" persistence-model="xemelios-sql"><document id="ref-collec-spl" repository-import-xslt-file=""><table base-name="REF_COLL_SPL_LIST_BC" 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><etat id="Referentiel" import-xslt-file="ref-collec-spl/ref-collec-spl-import-mysql.xsl"><table base-name="REF_COLL_SPL_IX" id="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" type="index" main="true" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ BUDGET VARCHAR(1000) NOT NULL,
+ DOC_ID VARCHAR(1000) NOT NULL,
+ CODIC VARCHAR(1000),
+ ARCHIVE_PRESENT VARCHAR(3),
+ GROUPE VARCHAR(1000),
+ INITIAL_DOC_NAME VARCHAR(1000),
+ LIBELLE_POSTE VARCHAR(1000),
+ ARCHIVE_NAME VARCHAR(1000),
+ NATURE_CONTROLE VARCHAR(1000),
+ BUDGET_PRINC VARCHAR(1000),
+ IDCOLL VARCHAR(1000),
+ CODBUDG VARCHAR(1000),
+ JURI_FINAN VARCHAR(1000),
+ NOMENCL VARCHAR(1000),
+ CODCOLL VARCHAR(1000),
+ EXERCICE INT NOT NULL,
+ CODEINSEE VARCHAR(1000),
+ LIBELLE 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 ${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="REF_COLL_SPL_DOCUMENTS" 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><criteria id="CRI_REFERENTIEL_COLLECTIVITE_BUDGET-PRINC" type="1" sql-index-id="SQI_REFERENTIEL_COLLECTIVITE_BUDGET-PRINC">
+ <where-clause>fn:string-compare(${table}.${column},budget-princ)</where-clause>
+ </criteria><criteria id="CRI_REFERENTIEL_COLLECTIVITE_CODCOLL" type="1" sql-index-id="SQI_REFERENTIEL_COLLECTIVITE_CODCOLL">
+ <where-clause>fn:string-compare(${table}.${column},codColl)</where-clause>
+ </criteria><criteria id="CRI_REFERENTIEL_COLLECTIVITE_IDCOLL" type="1" sql-index-id="SQI_REFERENTIEL_COLLECTIVITE_IDCOLL">
+ <where-clause>fn:string-compare(${table}.${column},idColl)</where-clause>
+ </criteria><criteria id="CRI_REFERENTIEL_COLLECTIVITE_CODBUDG" type="1" sql-index-id="SQI_REFERENTIEL_COLLECTIVITE_CODBUDG">
+ <where-clause>fn:string-compare(${table}.${column},codBudg)</where-clause>
+ </criteria><criteria id="CRI_REFERENTIEL_COLLECTIVITE_CODIC" type="1" sql-index-id="SQI_REFERENTIEL_COLLECTIVITE_CODIC">
+ <where-clause>fn:string-compare(${table}.${column},codic)</where-clause>
+ </criteria><criteria id="CRI_REFERENTIEL_COLLECTIVITE_LIBELLE" type="1" sql-index-id="SQI_REFERENTIEL_COLLECTIVITE_LIBELLE">
+ <where-clause>fn:string-compare(${table}.${column},libelle)</where-clause>
+ </criteria><criteria id="CRI_REFERENTIEL_COLLECTIVITE_LIBELLE-POSTE" type="1" sql-index-id="SQI_REFERENTIEL_COLLECTIVITE_LIBELLE-POSTE">
+ <where-clause>fn:string-compare(${table}.${column},libelle-poste)</where-clause>
+ </criteria><criteria id="CRI_REFERENTIEL_COLLECTIVITE_CODEINSEE" type="1" sql-index-id="SQI_REFERENTIEL_COLLECTIVITE_CODEINSEE">
+ <where-clause>fn:string-compare(${table}.${column},codeInsee)</where-clause>
+ </criteria><criteria id="CRI_EXERCICE" sql-index-id="SQI_REFERENTIEL_REFERENTIEL_EXERCICE">
+ <where-clause>${table}.${column}##OPERATEUR:exercice####VALEUR:exercice##</where-clause>
+ </criteria><criteria id="juriFi" sql-index-id="SQI_JURI_FI">
+ <where-clause>fn:string-compare(${table}.${column},juriFi)</where-clause>
+ </criteria><criteria id="groupe" sql-index-id="SQI_GROUPE">
+ <where-clause>fn:string-compare(${table}.${column},groupe)</where-clause>
+ </criteria><criteria id="nomencl" sql-index-id="SQI_NOMENCL">
+ <where-clause>fn:string-compare(${table}.${column},nomencl)</where-clause>
+ </criteria><criteria id="archive" sql-index-id="SQI_ARCHIVE">
+ <where-clause>${table}.${column}='##VALEUR:archive##'</where-clause>
+ </criteria><criteria id="natControl" sql-index-id="SQI_NATURE_CONTROLE">
+ <where-clause>${table}.${column}='##VALEUR:natControl##'</where-clause>
+ </criteria><sql-index id="SQI_REFERENTIEL_REFERENTIEL_EXERCICE" path="/n:Referentiel/n:Exercice/text()" datatype="integer" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" column="EXERCICE"/><sql-index id="SQI_REFERENTIEL_COLLECTIVITE_BUDGET-PRINC" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@budget-princ" datatype="string" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" column="BUDGET_PRINC" format="uppercase"/><sql-index id="SQI_REFERENTIEL_COLLECTIVITE_CODCOLL" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@codColl" datatype="string" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" column="CODCOLL" format="uppercase"/><sql-index id="SQI_REFERENTIEL_COLLECTIVITE_IDCOLL" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@idColl" datatype="string" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" column="IDCOLL" format="uppercase"/><sql-index id="SQI_REFERENTIEL_COLLECTIVITE_CODBUDG" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@codBudg" datatype="string" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" column="CODBUDG" format="uppercase"/><sql-index id="SQI_REFERENTIEL_COLLECTIVITE_CODIC" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@codic" datatype="string" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" column="CODIC" format="uppercase"/><sql-index id="SQI_REFERENTIEL_COLLECTIVITE_LIBELLE" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@libelle" datatype="string" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" column="LIBELLE" format="uppercase"/><sql-index id="SQI_REFERENTIEL_COLLECTIVITE_LIBELLE-POSTE" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@libelle-poste" datatype="string" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" column="LIBELLE_POSTE" format="uppercase"/><sql-index id="SQI_REFERENTIEL_COLLECTIVITE_CODEINSEE" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@codeInsee" datatype="string" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" column="CODEINSEE" format="uppercase"/><sql-index id="SQI_JURI_FI" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@juri-finan" datatype="string" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" column="JURI_FINAN" format="uppercase"/><sql-index id="SQI_GROUPE" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@groupe" datatype="string" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" column="GROUPE" format="uppercase"/><sql-index id="SQI_NOMENCL" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@nomencl" datatype="string" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" column="NOMENCL" format="uppercase"/><sql-index id="SQI_NATURE_CONTROLE" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@nature-controle" datatype="string" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" column="NATURE_CONTROLE"/><sql-index id="SQI_ARCHIVE" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@archive" datatype="string" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" column="ARCHIVE_PRESENT"/></etat></document></layer></persistence-config>
\ No newline at end of file