-<?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">
- 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
- </table>
- <table type="special-key" base-name="MANIF2_SK" 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>
- <table type="list-bc" base-name="MANIF2_LBC" 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),
- PARENT_COLL1 VARCHAR(15),
- PARENT_COLL1_LIB VARCHAR(200),
- PARENT_COLL2 VARCHAR(3),
- PARENT_COLL2_LIB VARCHAR(3),
- 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>
+<?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">
+ 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
+ </table>
+ <table type="special-key" base-name="MANIF2_SK" 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>
+ <table type="list-bc" base-name="MANIF2_LBC" 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),
+ PARENT_COLL1 VARCHAR(15),
+ PARENT_COLL1_LIB VARCHAR(200),
+ PARENT_COLL2 VARCHAR(3),
+ PARENT_COLL2_LIB VARCHAR(3),
+ 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>
- <etat id="fakes" import-xslt-file="manifeste2/manifeste-import-mysql.xsl">
- <table type="document" base-name="MANIF2_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,
- DOC LONGBLOB,
- ENCODING VARCHAR(20),
- ARCHIVE_NAME VARCHAR(100),
- INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
- INDEX ${base-name}_AN (ARCHIVE_NAME)
- ) ENGINE MYISAM
- </table>
+ <etat id="fakes" import-xslt-file="manifeste2/manifeste-import-mysql.xsl">
+ <table type="document" base-name="MANIF2_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,
+ DOC LONGBLOB,
+ ENCODING VARCHAR(20),
+ ARCHIVE_NAME VARCHAR(100),
+ INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
+ INDEX ${base-name}_AN (ARCHIVE_NAME)
+ ) ENGINE MYISAM
+ </table>
- <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,
- EXERCICE VARCHAR(4) ,
- CG_CODE_COLL VARCHAR(3) ,
- CG_CODIC VARCHAR(6) ,
- CG_ID_COLL VARCHAR(15) ,
- DATE_VALIDATION DATE ,
- NOM_VALIDEUR VARCHAR(255) ,
- DATE_PRODUCTION DATE ,
- DATE_TRANSFERT DATE,
- DATE_DEBUT DATE,
- FILENAME VARCHAR(150) ,
- 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
- </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_DATE_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 /manifeste/volume -->
- <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_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 -->
- </etat>
- </document>
- </layer>
-<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} (
+ <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,
+ EXERCICE VARCHAR(4) ,
+ CG_CODE_COLL VARCHAR(3) ,
+ CG_CODIC VARCHAR(6) ,
+ CG_ID_COLL VARCHAR(15) ,
+ DATE_VALIDATION DATE ,
+ NOM_VALIDEUR VARCHAR(255) ,
+ DATE_PRODUCTION DATE ,
+ DATE_TRANSFERT DATE,
+ DATE_DEBUT DATE,
+ FILENAME VARCHAR(150) ,
+ 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
+ </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_DATE_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 /manifeste/volume -->
+ <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_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 -->
+ </etat>
+ </document>
+ </layer>
+ <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),
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} (
+)</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,
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} (
+)</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} (
+)</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} (
+)</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,
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
+)</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_DATE_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