+++ /dev/null
-<?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">
- <layer name="mysql" persistence-model="xemelios-sql">
- <document id="manifeste">
- <table type="repository" base-name="MANIFESTE_REPOSITORY" 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="MANIFESTE_SPECIAL_KEYS" 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="MANIFESTE_LIST_BUDG_COLL" 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="volumes" import-xslt-file="manifeste/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="MANIFESTE_DOCUMENTS" 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="MANIFESTE_VOLUME_IX" version="2" main="true" based-on="key1">
- 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) ,
- CG_ID_COLL VARCHAR(15) ,
- DATE_VALIDATION DATE ,
- NOM_VALIDEUR VARCHAR(255) ,
- DATE_PRODUCTION DATE ,
- DATE_TRANSFERT 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="MANIFESTE_DOCUMENT_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 /manifeste/documents -->
-
- <!-- CRITERIA /manifeste/documents/document -->
- <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>
- <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>
- <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>
- <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>
- <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_CG_ID_COL" path="/n:manifeste/@cgIdCol" datatype="string" column="CG_ID_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_TRANSFERT" table="MANIFESTE_VOLUME_IX" column="DATE_TRANSFERT" path="/n:manifeste/n:resultatimport/@LastModify" datatype="date" format="yyyy-MM-dd'T'HH:mm:ss;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>