INDEX ${base-name}_AN (ARCHIVE_NAME)
) ENGINE MYISAM
</table>
- <table type="index" id="RSA_TOTALISATION_INDEX" base-name="RSA_TOTALISATION_INDEX" version="1" main="true" based-on="key1">
+ <table type="index" id="RSA_TOTALISATION_INDEX" base-name="RSA_TOTALISATION_INDEX" version="2" main="true" based-on="key1">
CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
BUDGET VARCHAR(24) NOT NULL,
DOC_ID VARCHAR(100) NOT NULL,
NODE_ID VARCHAR(50),
PERIODE DATE ,
+ FILE_NAME VARCHAR(255),
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
INDEX IX_${base-name}_DC (DOC_ID) ,
INITIAL_DOC_NAME VARCHAR(100),
ARCHIVE_NAME VARCHAR(100),
INDEX ${base-name}_AN (ARCHIVE_NAME)
) ENGINE MYISAM
+ <patch from-version="1">
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD FILE_NAME VARCHAR(255)</sql>
+ </patch>
+
</table>
<table base-name="RSA_TOTALISATION_LIGNES_INDEX" type="index" version="1" id="RSA_TOTALISATION_LIGNES_INDEX" based-on="key2">
CREATE TABLE IF NOT EXISTS ${base-name} (
) ENGINE MYISAM
</table>
-
<!-- CRITERIA /Racine/Totalisations/TotalisationAcompte -->
- <criteria id="periode" sql-index-id="PERIODE">
+ <criteria id="periode" sql-index-id="PERIODE2">
<where-clause>fn:date-compare(${table}.${column},periode)</where-clause>
</criteria>
- <criteria id="periodeBornee" sql-index-id="PERIODE">
+ <criteria id="periodeBornee" sql-index-id="PERIODE2">
<where-clause>${table}.${column} >= STR_TO_DATE('##VALEUR:periode1##','%d/%m/%Y') AND ${table}.${column} <= STR_TO_DATE('##VALEUR:periode2##','%d/%m/%Y')</where-clause>
</criteria>
<criteria id="typeLigne" sql-index-id="SQI_TOTALISATIONACOMPTE_LIGNE_TYPE_1">
<criteria id="CRI_TOTALISATIONACOMPTE_TOTALISATIONACOMPTE_MTTOTRSA" sql-index-id="SQI_TOTALISATIONACOMPTE_LIGNE_MTTOTRSA_1">
<where-clause>${table}.${column}##OPERATEUR:mt####VALEUR:mt##</where-clause>
</criteria>
+ <criteria id="file.name" sql-index-id="FILE_NAME">
+ <where-clause>fn:string-compare(${table}.${column},file.name)</where-clause>
+ </criteria>
+ <sql-index id="FILE_NAME" table="RSA_TOTALISATION_INDEX" column="FILE_NAME" path="/n:Racine/@added:file-name" datatype="string" format="uppercase" />
<sql-index id="PERIODE2" table="RSA_TOTALISATION_INDEX" column="PERIODE" path="/n:Racine/n:Periode/text()" datatype="date" format="yyyy-MM-dd"/>
<sql-index id="SQI_TOTALISATIONACOMPTE_TOTALISATIONACOMPTE__NODE_ID" path="/n:Racine/n:Totalisations/n:TotalisationAcompte/@added:generated-id" column="NODE_ID" datatype="string" table="RSA_TOTALISATION_INDEX"/>