INDEX ${base-name}_AN (ARCHIVE_NAME)
) ENGINE MYISAM
</table>
- <table type="index" id="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" base-name="REF_COLL_SPL_COLLECTIVITESSPL_COLL_IX" version="3" main="true">
+ <table type="index" id="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" base-name="REF_COLL_SPL_COLLECTIVITESSPL_COLL_IX" version="4" main="true">
CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
BUDGET VARCHAR(24) NOT NULL,
JURI_FINAN VARCHAR(150) ,
GROUPE VARCHAR(150) ,
NOMENCL VARCHAR(150) ,
+ NATURE_CONTROLE VARCHAR(20) ,
ARCHIVE CHAR(3) ,
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
INDEX IX_${base-name}_DC (DOC_ID) ,
<patch from-version="2">
<sql failonerror="false">ALTER TABLE ${base-name} ADD ARCHIVE CHAR(3)</sql>
</patch>
-
+ <patch from-version="3">
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NATURE_CONTROLE VARCHAR(20)</sql>
+ </patch>
</table>
<criteria id="archive" sql-index-id="SQI_ARCHIVE">
<where-clause>${table}.${column}='##VALEUR:archive##'</where-clause>
</criteria>
+ <criteria id="natControl" sql-index-id="SQI_NATURE_CONTROLE">
+ <where-clause>${table}.${column}='##VALEUR:natControl##'</where-clause>
+ </criteria>
<sql-index id="SQI_JURI_FI" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@juri-finan" datatype="string" column="JURI_FINAN" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase"/>
<sql-index id="SQI_GROUPE" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@groupe" datatype="string" column="GROUPE" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase"/>
<sql-index id="SQI_NOMENCL" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@nomencl" datatype="string" column="NOMENCL" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" format="uppercase"/>
+ <sql-index id="SQI_NATURE_CONTROLE" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@nature-controle" datatype="string" column="NATURE_CONTROLE" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX"/>
<sql-index id="SQI_ARCHIVE" table="REFERENTIEL_COLLECTIVITESSPL_COLLECTIVITE_IX" column="ARCHIVE" path="/n:Referentiel/n:CollectivitesSPL/n:Collectivite/@archive" datatype="string"/>
</etat>
</document>