</key1>
<key2>
<path>/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/n:PJ/@added:generated-id</path>
- </key2>
+ </key2>
+ <key3>
+ <path>/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012</path>
+ </key3>
<table type="document" base-name="EDMN_2012_ETATEDMN_DOCUMENTS" version="1">
CREATE TABLE IF NOT EXISTS ${base-name} (
DOC LONGBLOB, ENCODING VARCHAR(20),
ANNEE_GESTION INTEGER,
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
- INDEX IX_EDMN_DOC_ANNEE_GESTION(COLLECTIVITE,BUDGET,ANNEE_GESTION),
+ INDEX IX_EDMN2012_DOC_ANNEE_GESTION(COLLECTIVITE,BUDGET,ANNEE_GESTION),
ARCHIVE_NAME VARCHAR(100), INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM
</table>
- <table type="index" id="T1" base-name="EDMN_2012_ETATEDMN_IX" version="1" main="true">
+
+ <table type="index" id="T1" base-name="EDMN_2012_ETATEDMN_IX" version="2" main="true">
CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
BUDGET VARCHAR(24) NOT NULL,
ANNEE INTEGER,
MOIS INTEGER,
TRIMESTRE INTEGER,
+ IMPUTATION VARCHAR(1),
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
INDEX ${base-name}_AN (ARCHIVE_NAME),
INDEX ${base-name}_NUMLFIN (NUMLIASSEFIN),
INDEX ${base-name}_ANNEE (ANNEE),
INDEX ${base-name}_MOIS (MOIS),
- INDEX ${base-name}_TRIM (TRIMESTRE)) ENGINE MYISAM
+ INDEX ${base-name}_TRIM (TRIMESTRE),
+ INDEX ${base-name}_IMP (IMPUTATION)) ENGINE MYISAM
+ <patch from-version="1">
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD IMPUTATION VARCHAR(1)</sql>
+ </patch>
</table>
- <table id="T2" base-name="EDMN_2012_LIASSES_IX" type="index" version="2" based-on="key1">
+
+ <table id="T2" base-name="EDMN_2012_LIASSES_IX" type="index" version="3" based-on="key1">
CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
BUDGET VARCHAR(24) NOT NULL,
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
INDEX IX_${base-name}_DC (DOC_ID),
INDEX ${base-name}_NODEID (NODEID),
- INDEX IX_EDMN_ETATEDMN_LIASSES_ANGEST (COLLECTIVITE,BUDGET,ANNEE_GESTION),
- INDEX IX_EDMN_ETATEDMN_LIASSES_LIASSE_CENTRALE (NUM_LIASSE),
+ INDEX IX_${base-name}_ANGEST (COLLECTIVITE,BUDGET,ANNEE_GESTION),
+ INDEX IX_${base-name}_LIASSES_LIASSE_CENTRALE (NUM_LIASSE),
INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM
<patch from-version="1">
<sql failonerror="false">ALTER TABLE ${base-name} ADD NODEID VARCHAR(10)</sql>
- </patch>
+ </patch>
+ <patch from-version="2">
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NODEID VARCHAR(10)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} DROP INDEX IX_EDMN_ETATEDMN_LIASSES_ANGEST</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} DROP INDEX IX_EDMN_ETATEDMN_LIASSES_LIASSE_CENTRALE</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD INDEX IX_${base-name}_ANGEST (COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD INDEX IX_${base-name}_LIASSE_CENTRALE (NUM_LIASSE)</sql>
+ </patch>
</table>
+
<table id="T3" base-name="EDMN_2012_PJ_IX" type="index" version="2" based-on="key2">
CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
<criteria id="num_ej_long" sql-index-id="numEjLong">
<where-clause>fn:string-compare(${table}.${column},num_ej_long)</where-clause>
</criteria>
- <criteria id="with_pj" sql-index-id="pj">
- <where-clause>${table}.${column}='##VALEUR:with_pj##'</where-clause>
+ <criteria id="pj" sql-index-id="pj">
+ <where-clause>${table}.${column}='##VALEUR:pj##'</where-clause>
</criteria>
<sql-index id="annee" table="T1" column="ANNEE" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/@Annee" datatype="integer"/>
<sql-index id="mois" table="T1" column="MOIS" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/@Mois" datatype="integer"/>
<sql-index id="trim" table="T1" column="TRIMESTRE" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/@Trimestre" datatype="integer"/>
+ <sql-index id="imput" table="T1" column="IMPUTATION" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/@Imputation" datatype="string"/>
<!-- LIASSES -->
<sql-index id="nodeIdLiasse" table="T2" column="NODEID" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/n:NumLiasseNationale/n:Liasse/@added:generated-id" datatype="string"/>
<sql-index id="numLiasseCentrale" table="T2" column="NUM_LIASSE" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/n:NumLiasseNationale/n:Liasse/@national" datatype="string" format="uppercase"/>
- <sql-index id="liasseAnneeGestion" table="T2" column="ANNEE_GESTION" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/n:AnneeBudget/@V" datatype="integer" use-in-criteria="false"/>
+ <sql-index id="liasseAnneeGestion" table="T2" column="ANNEE_GESTION" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/@Annee" datatype="integer" reset-on="key3"/>
<!-- PJ -->
<sql-index id="nodeIdPj" table="T3" column="NODEID" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/n:PJ/@added:generated-id" datatype="string"/>
</layer>
<layer name="oracle" persistence-model="xemelios-sql">
- <document id="edmn" repository-import-xslt-file="">
+
+ <document id="edmn2012" repository-import-xslt-file="">
+
<table base-name="EDMN_2012_SPECIAL_KEYS" type="special-key" version="1">
<sql xml:space="preserve">
CREATE TABLE ${base-name} (
<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="EDMN_LIST_BUDG_COLL" type="list-bc" version="1">
+
+ <table base-name="EDMN_2012_LIST_BUDG_COLL" type="list-bc" version="1">
<sql xml:space="preserve">
CREATE TABLE ${base-name} (
BUDGET VARCHAR(1000) NOT NULL,
<sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql>
</table>
- <etat id="etatEdmn" import-xslt-file="edmn-2012/edmn-import-mysql.xsl">
+ <etat id="etatEdmn2012" import-xslt-file="edmn-2012/edmn-import-mysql.xsl">
<key1>
<path>/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/n:NumLiasseNationale/n:Liasse/@added:generated-id</path>
</key1>
<key2>
<path>/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/n:PJ/@added:generated-id</path>
</key2>
+ <key3>
+ <path>/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012</path>
+ </key3>
<table base-name="EDMN_2012_ETAT_DOCS" type="document" version="1">
<sql xml:space="preserve">
ANNEE_GESTION NUMBER,
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 EDMN_DOC_ANNEE_GESTION ON ${base-name} (COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql>
- <sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql>
+ <sql>CREATE INDEX EDMN2012_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
+ <sql>CREATE INDEX EDMN2012_DOC_AG ON ${base-name} (COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql>
+ <sql>CREATE INDEX EDMN2012_AN ON ${base-name} (ARCHIVE_NAME)</sql>
</table>
- <table base-name="EDMN_2012_ETAT" id="T1" type="index" main="true" version="1">
+ <table base-name="EDMN_2012_ETAT" id="T1" type="index" main="true" version="2">
<sql xml:space="preserve">
- CREATE TABLE IF NOT EXISTS ${base-name} (
+ CREATE TABLE ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
BUDGET VARCHAR(24) NOT NULL,
DOC_ID VARCHAR(100) NOT NULL,
NUMLIASSEFIN VARCHAR(4),
ANNEE NUMBER,
MOIS NUMBER,
- TRIMESTRE NUMBER )
+ TRIMESTRE NUMBER,
+ IMPUTATION VARCHAR(1) )
</sql>
- <sql>CREATE INDEX ETATEDMN_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
- <sql>CREATE INDEX ETATEDMN_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql>
- <sql>CREATE INDEX ETATEDMN_AN ON ${base-name} (ARCHIVE_NAME)</sql>
- <sql>CREATE INDEX ETATEDMN_NODEID ON ${base-name} (NODEID)</sql>
- <sql>CREATE INDEX ETATEDMN_CODEEVT ON ${base-name} (CODEEVT)</sql>
- <sql>CREATE INDEX ETATEDMN_TYPEPCE ON ${base-name} (TYPEPCE)</sql>
- <sql>CREATE INDEX ETATEDMN_DESIGNTYPE ON ${base-name} (DESIGNTYPE)</sql>
- <sql>CREATE INDEX ETATEDMN_SOCIETE ON ${base-name} (SOCIETE)</sql>
- <sql>CREATE INDEX ETATEDMN_NOMSOC ON ${base-name} (NOMSOCIETE)</sql>
- <sql>CREATE INDEX ETATEDMN_NUMPCEFI ON ${base-name} (NUMPIECEFI)</sql>
- <sql>CREATE INDEX ETATEDMN_POSTE ON ${base-name} (POSTE)</sql>
- <sql>CREATE INDEX ETATEDMN_EXECOMPTA ON ${base-name} (EXERCICECOMPTA)</sql>
- <sql>CREATE INDEX ETATEDMN_REFFIN ON ${base-name} (REFERENCEFINANCIERE)</sql>
- <sql>CREATE INDEX ETATEDMN_TXTENTFIN ON ${base-name} (TXTENTETEFINANCIER)</sql>
- <sql>CREATE INDEX ETATEDMN_TXTFIN ON ${base-name} (TEXTEFINANCIER)</sql>
- <sql>CREATE INDEX ETATEDMN_MINBUDG ON ${base-name} (MINISTEREBUDGETAIRE)</sql>
- <sql>CREATE INDEX ETATEDMN_MINBUDGDES ON ${base-name} (MINISTEREBUDGETAIREDESIGN)</sql>
- <sql>CREATE INDEX ETATEDMN_DOMACT ON ${base-name} (DOMAINEACTIVITE)</sql>
- <sql>CREATE INDEX ETATEDMN_FOURNUM ON ${base-name} (FOURNISSEURNUM)</sql>
- <sql>CREATE INDEX ETATEDMN_FOURNOM ON ${base-name} (FOURNISSEURNOM)</sql>
- <sql>CREATE INDEX ETATEDMN_FOURSIRET ON ${base-name} (FOURNISSEURSIRET)</sql>
- <sql>CREATE INDEX ETATEDMN_BENEFNUM ON ${base-name} (BENEFICIAIRENUM)</sql>
- <sql>CREATE INDEX ETATEDMN_BENEFNOM ON ${base-name} (BENEFICIAIRENOM)</sql>
- <sql>CREATE INDEX ETATEDMN_BENEFSIRET ON ${base-name} (BENEFICIAIRESIRET)</sql>
- <sql>CREATE INDEX ETATEDMN_RIBPAYS ON ${base-name} (RIBPAYS)</sql>
- <sql>CREATE INDEX ETATEDMN_RIBBANC ON ${base-name} (RIBBANC)</sql>
- <sql>CREATE INDEX ETATEDMN_RIBCOMPTE ON ${base-name} (RIBCOMPTE)</sql>
- <sql>CREATE INDEX ETATEDMN_RIBCLE ON ${base-name} (RIBCLE)</sql>
- <sql>CREATE INDEX ETATEDMN_CPTEPCE ON ${base-name} (COMPTEPCE)</sql>
- <sql>CREATE INDEX ETATEDMN_LIBPCE ON ${base-name} (LIBELLEPCE)</sql>
- <sql>CREATE INDEX ETATEDMN_DEBCRED ON ${base-name} (DEBITCREDITPCE)</sql>
- <sql>CREATE INDEX ETATEDMN_CPTEBUDG ON ${base-name} (COMPTEBUDG)</sql>
- <sql>CREATE INDEX ETATEDMN_DTECOMPTA ON ${base-name} (DATECOMPTABLE)</sql>
- <sql>CREATE INDEX ETATEDMN_DTEPAIE ON ${base-name} (DATEPAIEMENT)</sql>
- <sql>CREATE INDEX ETATEDMN_MT ON ${base-name} (MTPCE)</sql>
- <sql>CREATE INDEX ETATEDMN_DOMFONC ON ${base-name} (DOMAINEFONCTIONNEL)</sql>
- <sql>CREATE INDEX ETATEDMN_CENTFIN ON ${base-name} (CENTREFINANCIER)</sql>
- <sql>CREATE INDEX ETATEDMN_DESIGNFIN ON ${base-name} (DESIGNATIONFINANCIER)</sql>
- <sql>CREATE INDEX ETATEDMN_CENTCOUT ON ${base-name} (CENTRECOUT)</sql>
- <sql>CREATE INDEX ETATEDMN_CENTCOUTDES ON ${base-name} (CENTRECOUTDESIGN)</sql>
- <sql>CREATE INDEX ETATEDMN_TYPEJ ON ${base-name} (TYPEEJ)</sql>
- <sql>CREATE INDEX ETATEDMN_TYPEJDES ON ${base-name} (TYPEEJDESIGN)</sql>
- <sql>CREATE INDEX ETATEDMN_NUMEJ ON ${base-name} (NUMEJ)</sql>
- <sql>CREATE INDEX ETATEDMN_NUMEJLONG ON ${base-name} (NUMEJLONG)</sql>
- <sql>CREATE INDEX ETATEDMN_DTEEJ ON ${base-name} (DATEEJ)</sql>
- <sql>CREATE INDEX ETATEDMN_TYPECR ON ${base-name} (TYPEECRITURE)</sql>
- <sql>CREATE INDEX ETATEDMN_PERFIN ON ${base-name} (PERIMFINANCIER)</sql>
- <sql>CREATE INDEX ETATEDMN_SEREXEC ON ${base-name} (SERVEXEC)</sql>
- <sql>CREATE INDEX ETATEDMN_PJ ON ${base-name} (PJ)</sql>
- <sql>CREATE INDEX ETATEDMN_ESPCE ON ${base-name} (ESPACEMENT)</sql>
- <sql>CREATE INDEX ETATEDMN_COMPT ON ${base-name} (COMPTABLE)</sql>
- <sql>CREATE INDEX ETATEDMN_LIBCOMPT ON ${base-name} (LIBELLECOMPTABLE)</sql>
- <sql>CREATE INDEX ETATEDMN_NUMLIASSEDEB ON ${base-name} (NUMLIASSEDEB)</sql>
- <sql>CREATE INDEX ETATEDMN_NUMLIASSEFIN ON ${base-name} (NUMLIASSEFIN)</sql>
- <sql>CREATE INDEX ETATEDMN_ANNEE ON ${base-name} (ANNEE)</sql>
- <sql>CREATE INDEX ETATEDMN_MOIS ON ${base-name} (MOIS)</sql>
- <sql>CREATE INDEX ETATEDMN_TRIM ON ${base-name} (TRIMESTRE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_AN ON ${base-name} (ARCHIVE_NAME)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_NODEID ON ${base-name} (NODEID)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_CODEEVT ON ${base-name} (CODEEVT)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_TYPEPCE ON ${base-name} (TYPEPCE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DESIGNTYPE ON ${base-name} (DESIGNTYPE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_SOCIETE ON ${base-name} (SOCIETE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_NOMSOC ON ${base-name} (NOMSOCIETE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_NUMPCEFI ON ${base-name} (NUMPIECEFI)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_POSTE ON ${base-name} (POSTE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_EXECOMPTA ON ${base-name} (EXERCICECOMPTA)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_REFFIN ON ${base-name} (REFERENCEFINANCIERE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_TXTENTFIN ON ${base-name} (TXTENTETEFINANCIER)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_TXTFIN ON ${base-name} (TEXTEFINANCIER)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_MINBUDG ON ${base-name} (MINISTEREBUDGETAIRE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_MINBUDGDES ON ${base-name} (MINISTEREBUDGETAIREDESIGN)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DOMACT ON ${base-name} (DOMAINEACTIVITE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_FOURNUM ON ${base-name} (FOURNISSEURNUM)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_FOURNOM ON ${base-name} (FOURNISSEURNOM)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_FOURSIRET ON ${base-name} (FOURNISSEURSIRET)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_BENEFNUM ON ${base-name} (BENEFICIAIRENUM)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_BENEFNOM ON ${base-name} (BENEFICIAIRENOM)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_BENEFSIRET ON ${base-name} (BENEFICIAIRESIRET)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_RIBPAYS ON ${base-name} (RIBPAYS)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_RIBBANC ON ${base-name} (RIBBANC)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_RIBCOMPTE ON ${base-name} (RIBCOMPTE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_RIBCLE ON ${base-name} (RIBCLE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_CPTEPCE ON ${base-name} (COMPTEPCE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_LIBPCE ON ${base-name} (LIBELLEPCE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DEBCRED ON ${base-name} (DEBITCREDITPCE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_CPTEBUDG ON ${base-name} (COMPTEBUDG)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DTECOMPTA ON ${base-name} (DATECOMPTABLE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DTEPAIE ON ${base-name} (DATEPAIEMENT)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_MT ON ${base-name} (MTPCE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DOMFONC ON ${base-name} (DOMAINEFONCTIONNEL)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_CENTFIN ON ${base-name} (CENTREFINANCIER)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DESIGNFIN ON ${base-name} (DESIGNATIONFINANCIER)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_CENTCOUT ON ${base-name} (CENTRECOUT)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_CENTCOUTDES ON ${base-name} (CENTRECOUTDESIGN)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_TYPEJ ON ${base-name} (TYPEEJ)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_TYPEJDES ON ${base-name} (TYPEEJDESIGN)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_NUMEJ ON ${base-name} (NUMEJ)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_NUMEJLONG ON ${base-name} (NUMEJLONG)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DTEEJ ON ${base-name} (DATEEJ)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_TYPECR ON ${base-name} (TYPEECRITURE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_PERFIN ON ${base-name} (PERIMFINANCIER)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_SEREXEC ON ${base-name} (SERVEXEC)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_PJ ON ${base-name} (PJ)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_ESPCE ON ${base-name} (ESPACEMENT)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_COMPT ON ${base-name} (COMPTABLE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_LIBCOMPT ON ${base-name} (LIBELLECOMPTABLE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_NUMLIASSEDEB ON ${base-name} (NUMLIASSEDEB)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_NUMLIASSEFIN ON ${base-name} (NUMLIASSEFIN)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_ANNEE ON ${base-name} (ANNEE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_MOIS ON ${base-name} (MOIS)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_TRIM ON ${base-name} (TRIMESTRE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_IMP ON ${base-name} (IMPUTATION)</sql>
+ <patch from-version="1">
+ <sql>ALTER TABLE ${base-name} ADD IMPUTATION VARCHAR(1)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_IMP ON ${base-name} (IMPUTATION)</sql>
+ </patch>
</table>
<table base-name="EDMN_2012_ETAT_LIASSES" id="T2" type="index" based-on="key1" version="1">
<sql xml:space="preserve">
<sql>CREATE INDEX ETATEDMN2012_LIASSE_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
<sql>CREATE INDEX ETATEDMN2012_LIASSE_DC ON ${base-name} (DOC_ID)</sql>
<sql>CREATE INDEX ETATEDMN2012_LIASSE_NODEID ON ${base-name} (NODEID)</sql>
- <sql>CREATE INDEX LIASSE_ANNEE_GEST ON ${base-name} (COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_LIASSE_AG ON ${base-name} (COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql>
<sql>CREATE INDEX ETATEDMN2012_LIASSE_CENTRALE ON ${base-name} (NUM_LIASSE)</sql>
<sql>CREATE INDEX ETATEDMN2012_LIASSE_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql>
<sql>CREATE INDEX ETATEDMN2012_LIASSE_AN ON ${base-name} (ARCHIVE_NAME)</sql>
</table>
<table id="T3" base-name="EDMN_2012_ETAT_PJ" type="index" version="1" based-on="key2">
<sql xml:space="preserve">
- CREATE TABLE IF NOT EXISTS ${base-name} (
+ CREATE TABLE ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
BUDGET VARCHAR(24) NOT NULL,
DOC_ID VARCHAR(100) NOT NULL,
<criteria id="num_ej_long" sql-index-id="numEjLong">
<where-clause>fn:string-compare(${table}.${column},num_ej_long)</where-clause>
</criteria>
- <criteria id="with_pj" sql-index-id="pj">
- <where-clause>${table}.${column}='##VALEUR:with_pj##'</where-clause>
+ <criteria id="pj" sql-index-id="pj">
+ <where-clause>${table}.${column}='##VALEUR:pj##'</where-clause>
</criteria>
<!-- LIGNES EDMN -->
<sql-index id="annee" table="T1" column="ANNEE" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/@Annee" datatype="integer"/>
<sql-index id="mois" table="T1" column="MOIS" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/@Mois" datatype="integer"/>
<sql-index id="trim" table="T1" column="TRIMESTRE" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/@Trimestre" datatype="integer"/>
-
+ <sql-index id="imput" table="T1" column="IMPUTATION" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/@Imputation" datatype="string"/>
+
<!-- LIASSES -->
<sql-index id="nodeIdLiasse" table="T2" column="NODEID" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/n:NumLiasseNationale/n:Liasse/@added:generated-id" datatype="string"/>
<sql-index id="numLiasseCentrale" table="T2" column="NUM_LIASSE" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/n:NumLiasseNationale/n:Liasse/@national" datatype="string" format="uppercase"/>
- <sql-index id="liasseAnneeGestion" table="T2" column="ANNEE_GESTION" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/@Annee" datatype="integer" use-in-criteria="false"/>
+ <sql-index id="liasseAnneeGestion" table="T2" column="ANNEE_GESTION" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/@Annee" datatype="integer" reset-on="key3"/>
<!-- PJ -->
<sql-index id="nodeIdPj" table="T3" column="NODEID" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/n:PJ/@added:generated-id" datatype="string"/>