--- /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="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>
+
+ <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_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),
+ 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 IX_${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 IX_${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 IX_${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 IX_${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX IX_${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