-<?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="manifeste2">
<table type="repository" base-name="MANIF2_REPO" version="1">
</table>
<etat id="fakes" import-xslt-file="manifeste2/manifeste-import-mysql.xsl">
- <key1>
- <path>/n:manifeste/n:volumes/n:volume/@added:generated-id</path>
- </key1>
- <key2>
- <path>/n:manifeste/n:volumes/n:volume/n:document/@added:generated-id</path>
- </key2>
-
<table type="document" base-name="MANIF2_DOCS" version="1">
CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
) ENGINE MYISAM
</table>
- <table type="index" id="MANIFESTE_VOLUME_IX" base-name="MANIF2_VOL_IX" version="2" main="true" based-on="key1">
+ <table type="index" id="MANIFESTE_VOLUME_IX" base-name="MANIF2_VOL_IX" version="1" main="true">
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,
- NODE_ID VARCHAR(50) NOT NULL,
EXERCICE VARCHAR(4) ,
CG_CODE_COLL VARCHAR(3) ,
CG_CODIC VARCHAR(6) ,
NOM_VALIDEUR VARCHAR(255) ,
DATE_PRODUCTION DATE ,
DATE_TRANSFERT DATE,
+ DATE_DEBUT DATE,
FILENAME VARCHAR(150) ,
- NUM_VOLUME INTEGER ,
ARCHIVE VARCHAR(3),
ARCHIVE_NAME VARCHAR(100),
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
INDEX IX_${base-name}_DC (DOC_ID),
INDEX ${base-name}_AN (ARCHIVE_NAME)
) ENGINE MYISAM
- <patch from-version="1">
- <sql>ALTER TABLE ${base-name} ADD DATE_TRANSFERT DATE</sql>
- </patch>
-
</table>
-
- <table type="index" id="MANIFESTE_DOCUMENT_IX" base-name="MANIF_DOC_IX" version="1" main="false" based-on="key2">
- 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,
- NODE_ID VARCHAR(50) NOT NULL,
- LIBBUDG VARCHAR(255) ,
- BUCODE VARCHAR(255) ,
- BULIBELLE VARCHAR(255) ,
- DEFAULT_OVERWRITE VARCHAR(255) ,
- VOLUME DECIMAL ,
- TYPE VARCHAR(255) ,
- DEBUT DATE ,
- FIN DATE ,
- DUREE VARCHAR(75) ,
- SKIP_IF_EXISTS VARCHAR(255) ,
- PATH VARCHAR(255) ,
- BUIDCOL VARCHAR(255) ,
- FILENAME VARCHAR(150) ,
- ARCHIVE_NAME VARCHAR(100),
- INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
- INDEX IX_${base-name}_DC (DOC_ID),
- INDEX ${base-name}_AN (ARCHIVE_NAME)
- ) ENGINE MYISAM
- </table>
- <criteria id="CRI_MANIFESTE_DOCUMENT_LIBBUDG" type="1" sql-index-id="SQI_MANIFESTE_DOCUMENT_LIBBUDG">
- <where-clause>fn:string-compare(${table}.${column},libBudg)</where-clause>
- </criteria>
- <criteria id="CRI_MANIFESTE_DOCUMENT_BUCODE" type="1" sql-index-id="SQI_MANIFESTE_DOCUMENT_BUCODE">
- <where-clause>fn:string-compare(${table}.${column},buCode)</where-clause>
+ <criteria id="CRI_MANIFESTE_DOCUMENT_EXERCICE" sql-index-id="SQI_MANIFESTE_DOCUMENT_EXERCICE">
+ <where-clause>${table}.${column}='##VALEUR:exercice##'</where-clause>
</criteria>
- <criteria id="CRI_MANIFESTE_DOCUMENT_DEFAULT_OVERWRITE" type="1" sql-index-id="SQI_MANIFESTE_DOCUMENT_DEFAULT-OVERWRITE">
- <where-clause>fn:string-compare(${table}.${column},default-overwrite)</where-clause>
- </criteria>
- <criteria id="CRI_MANIFESTE_DOCUMENT_VOLUME" type="1" sql-index-id="SQI_MANIFESTE_DOCUMENT_VOLUME">
- <where-clause>${table}.${column}##OPERATEUR:volume####VALEUR:volume##</where-clause>
- </criteria>
- <criteria id="CRI_MANIFESTE_DOCUMENT_BULIBELLE" type="1" sql-index-id="SQI_MANIFESTE_DOCUMENT_BULIBELLE">
- <where-clause>fn:string-compare(${table}.${column},buLibelle)</where-clause>
+ <criteria id="CRI_MANIFESTE_CODIC" type="1" sql-index-id="SQI_MANIFESTE_DOCUMENT_CG_CODIC">
+ <where-clause>fn:string-compare(${table}.${column},codic)</where-clause>
</criteria>
<criteria id="CRI_MANIFESTE_DOCUMENT_FILENAME" type="1" sql-index-id="SQI_MANIFESTE_DOCUMENT_FILENAME">
<where-clause>fn:string-compare(${table}.${column},filename)</where-clause>
</criteria>
- <criteria id="CRI_MANIFESTE_DOCUMENT_TYPE" type="1" sql-index-id="SQI_MANIFESTE_DOCUMENT_TYPE">
- <where-clause>${table}.${column}='##VALEUR:type##'</where-clause>
+ <criteria id="CRI_MANIFESTE_DOCUMENT_BUIDCOL" type="1" sql-index-id="SQI_MANIFESTE_DOCUMENT_CG_ID_COL">
+ <where-clause>fn:string-compare(${table}.${column},buIdCol)</where-clause>
</criteria>
<criteria id="CRI_MANIFESTE_DOCUMENT_DEBUT" type="1" sql-index-id="SQI_MANIFESTE_DOCUMENT_DEBUT">
<where-clause>fn:date-compare(${table}.${column},Debut)</where-clause>
</criteria>
- <criteria id="CRI_MANIFESTE_DOCUMENT_FIN" type="1" sql-index-id="SQI_MANIFESTE_DOCUMENT_FIN">
- <where-clause>fn:date-compare(${table}.${column},Fin)</where-clause>
- </criteria>
- <criteria id="CRI_MANIFESTE_DOCUMENT_DUREE" type="1" sql-index-id="SQI_MANIFESTE_DOCUMENT_DUREE">
- <where-clause>fn:string-compare(${table}.${column},Duree)</where-clause>
- </criteria>
- <criteria id="CRI_MANIFESTE_DOCUMENT_SKIP_IF_EXISTS" type="1" sql-index-id="SQI_MANIFESTE_DOCUMENT_SKIP_IF_EXISTS">
- <where-clause>fn:string-compare(${table}.${column},SKIP_IF_EXISTS)</where-clause>
- </criteria>
- <criteria id="CRI_MANIFESTE_DOCUMENT_PATH" type="1" sql-index-id="SQI_MANIFESTE_DOCUMENT_PATH">
- <where-clause>fn:string-compare(${table}.${column},path)</where-clause>
- </criteria>
- <criteria id="CRI_MANIFESTE_DOCUMENT_BUIDCOL" type="1" sql-index-id="SQI_MANIFESTE_DOCUMENT_BUIDCOL">
- <where-clause>fn:string-compare(${table}.${column},buIdCol)</where-clause>
- </criteria>
- <criteria id="CRI_MANIFESTE_DOCUMENT_EXERCICE" type="1" sql-index-id="SQI_MANIFESTE_DOCUMENT_EXERCICE">
- <where-clause>${table}.${column}=##VALEUR:exercice##</where-clause>
- </criteria>
- <criteria id="CRI_MANIFESTE_CODIC" type="1" sql-index-id="SQI_MANIFESTE_DOCUMENT_CG_CODIC">
- <where-clause>fn:string-compare(${table}.${column},codic)</where-clause>
+ <criteria id="DATE_TRANSFERT" sql-index-id="SQI_MANIFESTE_DOCUMENT_DATE_TRANSFERT">
+ <where-clause>fn:date-compare(${table}.${column},transfert)</where-clause>
</criteria>
<criteria id="PRESENT" sql-index-id="SQI_MANIFESTE_DOCUMENT_ARCHIVE">
<where-clause>${table}.${column}='##VALEUR:present##'</where-clause>
</criteria>
- <criteria id="DATE_TRANSFERT" sql-index-id="SQI_MANIFESTE_DOCUMENT_DATE_TRANSFERT">
- <where-clause>fn:date-compare(${table}.${column},transfert)</where-clause>
- </criteria>
-
-
-
<!-- SQL-INDEX /manifeste/volume -->
- <sql-index id="SQI_MANIFESTE_DOCUMENT_CG_CODE_COL" path="/n:manifeste/@cgCodeCol" datatype="string" column="CG_CODE_COLL" table="MANIFESTE_VOLUME_IX"/>
<sql-index id="SQI_MANIFESTE_DOCUMENT_CG_CODIC" path="/n:manifeste/@cgCodic" datatype="string" column="CG_CODIC" table="MANIFESTE_VOLUME_IX"/>
+ <sql-index id="SQI_MANIFESTE_DOCUMENT_FILENAME" path="/n:manifeste/@archive-name" datatype="string" column="FILENAME" table="MANIFESTE_VOLUME_IX"/>
<sql-index id="SQI_MANIFESTE_DOCUMENT_CG_ID_COL" path="/n:manifeste/@cgIdCol" datatype="string" column="CG_ID_COLL" table="MANIFESTE_VOLUME_IX"/>
+ <sql-index id="SQI_MANIFESTE_DOCUMENT_CG_CODE_COL" path="/n:manifeste/@cgCodeCol" datatype="string" column="CG_CODE_COLL" table="MANIFESTE_VOLUME_IX"/>
<sql-index id="SQI_MANIFESTE_DOCUMENT_DATE_VALIDATION" path="/n:manifeste/@dateValidation" datatype="date" format="yyyy-MM-dd'T'HH:mm:ss;yyyy-MM-dd" column="DATE_VALIDATION" table="MANIFESTE_VOLUME_IX"/>
<sql-index id="SQI_MANIFESTE_DOCUMENT_EXERCICE" path="/n:manifeste/@exercice" datatype="string" column="EXERCICE" table="MANIFESTE_VOLUME_IX"/>
<sql-index id="SQI_MANIFESTE_DOCUMENT_EXERCICEB" path="/manifeste/@exercice" datatype="string" column="EXERCICE" table="MANIFESTE_VOLUME_IX"/>
<sql-index id="SQI_MANIFESTE_DOCUMENT_NOM_VALIDEUR" path="/n:manifeste/@nomValideur" datatype="string" column="NOM_VALIDEUR" table="MANIFESTE_VOLUME_IX"/>
-
<sql-index id="SQI_MANIFESTE_DOCUMENT_DATE_PRODUCTION" path="/n:manifeste/n:volumes/n:volume/@dateProduction" datatype="date" column="DATE_PRODUCTION" format="yyyy-MM-dd'T'HH:mm:ss;yyyy-MM-dd" table="MANIFESTE_VOLUME_IX"/>
- <sql-index id="SQI_MANIFESTE_DOCUMENT_FILENAME" path="/n:manifeste/n:volumes/n:volume/@fichier" datatype="string" column="FILENAME" table="MANIFESTE_VOLUME_IX"/>
- <sql-index id="SQI_MANIFESTE_DOCUMENT_NUM_VOLUME" path="/n:manifeste/n:volumes/n:volume/@num" datatype="integer" column="NUM_VOLUME" table="MANIFESTE_VOLUME_IX"/>
- <sql-index id="SQI_MANIFESTE_DOCUMENT_ARCHIVE" path="/n:manifeste/n:volumes/n:volume/@added:archive" datatype="string" column="ARCHIVE" table="MANIFESTE_VOLUME_IX"/>
+ <sql-index id="SQI_MANIFESTE_DOCUMENT_DATE_DEBUT" path="/n:manifeste/n:resultatimport/@Debut" datatype="date" column="DATE_DEBUT" format="yyyy-MM-dd'T'HH:mm:ss;yyyy-MM-dd" table="MANIFESTE_VOLUME_IX"/>
+ <sql-index id="SQI_MANIFESTE_DOCUMENT_ARCHIVE" path="/n:manifeste/@added:archive" datatype="string" column="ARCHIVE" table="MANIFESTE_VOLUME_IX"/>
<sql-index id="SQI_MANIFESTE_DOCUMENT_DATE_TRANSFERT" table="MANIFESTE_VOLUME_IX" column="DATE_TRANSFERT" path="/n:manifeste/n:resultatimport/@LastModify" datatype="date" format="yyyy-MM-dd HH:mm:ss.Ms;yyyy-MM-dd"/>
<!-- SQL-INDEX /manifeste/documents/document -->
- <sql-index id="SQI_MANIFESTE_DOCUMENT__NODE_ID" path="/n:manifeste/n:volumes/n:volume/n:document/@added:generated-id" column="NODE_ID" datatype="string" table="MANIFESTE_DOCUMENT_IX"/>
- <sql-index id="SQI_MANIFESTE_DOCUMENT_LIBBUDG" path="/n:manifeste/n:volumes/n:volume/n:document/@libBudg" datatype="string" column="LIBBUDG" table="MANIFESTE_DOCUMENT_IX"/>
- <sql-index id="SQI_MANIFESTE_DOCUMENT_BUCODE" path="/n:manifeste/n:volumes/n:volume/n:document/@buCode" datatype="string" column="BUCODE" table="MANIFESTE_DOCUMENT_IX"/>
- <sql-index id="SQI_MANIFESTE_DOCUMENT_DEFAULT-OVERWRITE" path="/n:manifeste/n:volumes/n:volume/n:document/@default-overwrite" datatype="string" column="DEFAULT_OVERWRITE" table="MANIFESTE_DOCUMENT_IX" format="uppercase"/>
- <sql-index id="SQI_MANIFESTE_DOCUMENT_VOLUME" path="/n:manifeste/n:volumes/n:volume/n:document/@volume" datatype="decimal" column="VOLUME" table="MANIFESTE_DOCUMENT_IX"/>
- <sql-index id="SQI_MANIFESTE_DOCUMENT_BULIBELLE" path="/n:manifeste/n:volumes/n:volume/n:document/@buLibelle" datatype="string" column="BULIBELLE" table="MANIFESTE_DOCUMENT_IX"/>
- <sql-index id="SQI_MANIFESTE_DOCUMENT_TYPE" path="/n:manifeste/n:volumes/n:volume/n:document/@type" datatype="string" column="TYPE" table="MANIFESTE_DOCUMENT_IX" format="uppercase"/>
- <sql-index id="SQI_MANIFESTE_DOCUMENT_DEBUT" path="/n:manifeste/n:volumes/n:volume/n:document/n:resultatimport/@Debut" datatype="date" format="yyyy-MM-dd HH:mm:ss.Ms;yyyy-MM-dd" column="DEBUT" table="MANIFESTE_DOCUMENT_IX"/>
- <sql-index id="SQI_MANIFESTE_DOCUMENT_FIN" path="/n:manifeste/n:volumes/n:volume/n:document/n:resultatimport/@Fin" datatype="date" format="yyyy-MM-dd HH:mm:ss.Ms;yyyy-MM-dd" column="FIN" table="MANIFESTE_DOCUMENT_IX"/>
- <sql-index id="SQI_MANIFESTE_DOCUMENT_DUREE" path="/n:manifeste/n:volumes/n:volume/n:document/n:resultatimport/@Duree" datatype="string" column="DUREE" table="MANIFESTE_DOCUMENT_IX"/>
- <sql-index id="SQI_MANIFESTE_DOCUMENT_SKIP_IF_EXISTS" path="/n:manifeste/n:volumes/n:volume/n:document/@skip-if-exists" datatype="string" column="SKIP_IF_EXISTS" table="MANIFESTE_DOCUMENT_IX"/>
- <sql-index id="SQI_MANIFESTE_DOCUMENT_PATH" path="/n:manifeste/n:volumes/n:volume/n:document/@path" datatype="string" column="PATH" table="MANIFESTE_DOCUMENT_IX"/>
- <sql-index id="SQI_MANIFESTE_DOCUMENT_BUIDCOL" path="/n:manifeste/n:volumes/n:volume/n:document/@buIdCol" datatype="string" column="BUIDCOL" table="MANIFESTE_DOCUMENT_IX"/>
</etat>
</document>
</layer>
-</persistence-config>
\ No newline at end of file
+<layer name="oracle" persistence-model="xemelios-sql"><document id="manifeste2"><table base-name="MANIF2_SK" 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),
+ KEY2 VARCHAR(1000),
+ KEY1 VARCHAR(1000) NOT NULL,
+ KEY3 VARCHAR(1000),
+ LIB2 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="MANIF2_LBC" type="list-bc" version="1"><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ PARENT_COLL2_LIB VARCHAR(1000),
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ PARENT_COLL1_LIB VARCHAR(1000),
+ PARENT_COLL1 VARCHAR(1000),
+ PARENT_COLL2 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="MANIF2_REPO" 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="fakes" import-xslt-file="manifeste2/manifeste-import-mysql.xsl"><table base-name="MANIF2_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="MANIF2_VOL_IX" id="MANIFESTE_VOLUME_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,
+ DATE_TRANSFERT DATE,
+ DOC_ID VARCHAR(1000) NOT NULL,
+ DATE_DEBUT DATE,
+ CG_CODIC VARCHAR(1000),
+ ARCHIVE_PRESENT VARCHAR(1000),
+ NOM_VALIDEUR VARCHAR(1000),
+ FILENAME VARCHAR(1000),
+ DATE_PRODUCTION DATE,
+ CG_CODE_COLL VARCHAR(1000),
+ INITIAL_DOC_NAME VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ CG_ID_COLL VARCHAR(1000),
+ DATE_VALIDATION DATE,
+ EXERCICE 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}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table><criteria id="CRI_MANIFESTE_DOCUMENT_EXERCICE" sql-index-id="SQI_MANIFESTE_DOCUMENT_EXERCICE">
+ <where-clause>${table}.${column}='##VALEUR:exercice##'</where-clause>
+ </criteria><criteria id="CRI_MANIFESTE_CODIC" type="1" sql-index-id="SQI_MANIFESTE_DOCUMENT_CG_CODIC">
+ <where-clause>fn:string-compare(${table}.${column},codic)</where-clause>
+ </criteria><criteria id="CRI_MANIFESTE_DOCUMENT_FILENAME" type="1" sql-index-id="SQI_MANIFESTE_DOCUMENT_FILENAME">
+ <where-clause>fn:string-compare(${table}.${column},filename)</where-clause>
+ </criteria><criteria id="CRI_MANIFESTE_DOCUMENT_BUIDCOL" type="1" sql-index-id="SQI_MANIFESTE_DOCUMENT_CG_ID_COL">
+ <where-clause>fn:string-compare(${table}.${column},buIdCol)</where-clause>
+ </criteria><criteria id="CRI_MANIFESTE_DOCUMENT_DEBUT" type="1" sql-index-id="SQI_MANIFESTE_DOCUMENT_DEBUT">
+ <where-clause>fn:date-compare(${table}.${column},Debut)</where-clause>
+ </criteria><criteria id="DATE_TRANSFERT" sql-index-id="SQI_MANIFESTE_DOCUMENT_DATE_TRANSFERT">
+ <where-clause>fn:date-compare(${table}.${column},transfert)</where-clause>
+ </criteria><criteria id="PRESENT" sql-index-id="SQI_MANIFESTE_DOCUMENT_ARCHIVE">
+ <where-clause>${table}.${column}='##VALEUR:present##'</where-clause>
+ </criteria><sql-index id="SQI_MANIFESTE_DOCUMENT_CG_CODIC" path="/n:manifeste/@cgCodic" datatype="string" table="MANIFESTE_VOLUME_IX" column="CG_CODIC"/><sql-index id="SQI_MANIFESTE_DOCUMENT_FILENAME" path="/n:manifeste/@archive-name" datatype="string" table="MANIFESTE_VOLUME_IX" column="FILENAME"/><sql-index id="SQI_MANIFESTE_DOCUMENT_CG_ID_COL" path="/n:manifeste/@cgIdCol" datatype="string" table="MANIFESTE_VOLUME_IX" column="CG_ID_COLL"/><sql-index id="SQI_MANIFESTE_DOCUMENT_CG_CODE_COL" path="/n:manifeste/@cgCodeCol" datatype="string" table="MANIFESTE_VOLUME_IX" column="CG_CODE_COLL"/><sql-index id="SQI_MANIFESTE_DOCUMENT_DATE_VALIDATION" path="/n:manifeste/@dateValidation" datatype="date" table="MANIFESTE_VOLUME_IX" column="DATE_VALIDATION" format="yyyy-MM-dd'T'HH:mm:ss;yyyy-MM-dd"/><sql-index id="SQI_MANIFESTE_DOCUMENT_EXERCICE" path="/n:manifeste/@exercice" datatype="string" table="MANIFESTE_VOLUME_IX" column="EXERCICE"/><sql-index id="SQI_MANIFESTE_DOCUMENT_EXERCICEB" path="/manifeste/@exercice" datatype="string" table="MANIFESTE_VOLUME_IX" column="EXERCICE"/><sql-index id="SQI_MANIFESTE_DOCUMENT_NOM_VALIDEUR" path="/n:manifeste/@nomValideur" datatype="string" table="MANIFESTE_VOLUME_IX" column="NOM_VALIDEUR"/><sql-index id="SQI_MANIFESTE_DOCUMENT_DATE_PRODUCTION" path="/n:manifeste/n:volumes/n:volume/@dateProduction" datatype="date" table="MANIFESTE_VOLUME_IX" column="DATE_PRODUCTION" format="yyyy-MM-dd'T'HH:mm:ss;yyyy-MM-dd"/><sql-index id="SQI_MANIFESTE_DOCUMENT_DATE_DEBUT" path="/n:manifeste/n:resultatimport/@Debut" datatype="date" table="MANIFESTE_VOLUME_IX" column="DATE_DEBUT" format="yyyy-MM-dd'T'HH:mm:ss;yyyy-MM-dd"/><sql-index id="SQI_MANIFESTE_DOCUMENT_ARCHIVE" path="/n:manifeste/@added:archive" datatype="string" table="MANIFESTE_VOLUME_IX" column="ARCHIVE_PRESENT"/><sql-index id="SQI_MANIFESTE_DOCUMENT_DATE_TRANSFERT" path="/n:manifeste/n:resultatimport/@LastModify" datatype="date" table="MANIFESTE_VOLUME_IX" column="DATE_TRANSFERT" format="yyyy-MM-dd HH:mm:ss.Ms;yyyy-MM-dd"/></etat></document></layer></persistence-config>
\ No newline at end of file