-<?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">
+<?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="edmn"
- repository-import-xslt-file=""
- collectivite-code-colname="COLLECTIVITE"
- collectivite-lib-colname="COLLECTIVITE_LIB"
- budget-code-colname="BUDGET"
+ <document id="edmn" repository-import-xslt-file="" collectivite-code-colname="COLLECTIVITE"
+ collectivite-lib-colname="COLLECTIVITE_LIB" budget-code-colname="BUDGET"
budget-lib-colname="BUDGET_LIB">
- <table type="repository" base-name="EDMN_REPOSITORY" version="2"> 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 <patch from-version="1">
+ <table type="repository" base-name="EDMN_REPOSITORY" version="2"> 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 <patch
+ from-version="1">
<sql failonerror="false">ALTER TABLE ${base-name} ADD ID VARCHAR(25)</sql>
<sql failonerror="false">ALTER TABLE ${base-name} ADD LIBELLE VARCHAR(100)</sql>
</patch>
</table>
- <table type="list-bc" base-name="EDMN_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), 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>
- <table type="special-key" base-name="EDMN_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="EDMN_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), 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>
+ <table type="special-key" base-name="EDMN_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>
<etat id="etatEdmn" import-xslt-file="edmn/edmn-import-mysql.xsl">
<key1>
<path>/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseNationale/n:Liasse/@added:generated-id</path>
</key1>
- <table type="document" base-name="EDMN_ETATEDMN_DOCUMENTS" version="2">
- 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),
- ANNEE_GESTION INTEGER,
- INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
- INDEX IX_EDMN_DOC_ANNEE_GESTION(COLLECTIVITE,BUDGET,ANNEE_GESTION),
- ARCHIVE_NAME VARCHAR(100),
- INDEX ${base-name}_AN (ARCHIVE_NAME)
- ) ENGINE MYISAM
- <patch from-version="1">
- <sql failonerror="false">ALTER TABLE EDMN_ETATEDMN_DOCUMENTS ADD ANNEE_GESTION INTEGER, ADD INDEX IX_EDMN_DOC_ANNEE_GESTION(COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql>
+ <table type="document" base-name="EDMN_ETATEDMN_DOCUMENTS" version="2"> 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), ANNEE_GESTION
+ INTEGER, INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INDEX
+ IX_EDMN_DOC_ANNEE_GESTION(COLLECTIVITE,BUDGET,ANNEE_GESTION), ARCHIVE_NAME
+ VARCHAR(100), INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM <patch
+ from-version="1">
+ <sql failonerror="false">ALTER TABLE EDMN_ETATEDMN_DOCUMENTS ADD
+ ANNEE_GESTION INTEGER, ADD INDEX
+ IX_EDMN_DOC_ANNEE_GESTION(COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql>
</patch>
-
</table>
- <table type="index" id="T1" base-name="EDMN_ETATEDMN_INDEX_EDMN" version="9" main="true">
- CREATE TABLE IF NOT EXISTS ${base-name} (
- COLLECTIVITE VARCHAR(15) NOT NULL,
- BUDGET VARCHAR(24) NOT NULL,
- DOC_ID VARCHAR(100) NOT NULL,
- ANNEE_BUDG INTEGER,
- ART_BUDG VARCHAR(2),
- ART_BUDG_PREV VARCHAR(2),
- CHAP_BUDG VARCHAR(4),
- CHAP_CLASS VARCHAR(4),
- CODE_OPER_EXC VARCHAR(32),
- COMPTABLE VARCHAR(6),
- DATE_CREA DATE,
- DATE_PAIEMENT DATE,
- IMPUTATION CHAR(1),
- LIB_ACTION VARCHAR(250),
- LIB_COMPTABLE VARCHAR(250),
- LIB_MINISTERE VARCHAR(250),
- LIB_ORDO VARCHAR(250),
- LIB_PROGRAMME VARCHAR(250),
- MINISTERE VARCHAR(3),
- MT_PJ DECIMAL(14,2),
- NUM_ENGAG VARCHAR(6),
- NUM_LIASSE_DEB VARCHAR(4),
- NUM_LIASSE_FIN VARCHAR(4),
- NUM_LIASSE_LOC VARCHAR(8),
- NUM_MANDAT VARCHAR(6),
- NUM_PIECE_COMPTA VARCHAR(32),
- OPE_INVEST VARCHAR(8),
- ORDO VARCHAR(10),
- PARAG_BUDG VARCHAR(2),
- TRIMESTRE INTEGER,
- TYPE_EVT VARCHAR(3),
- TYPE_PAIEMENT VARCHAR(3),
- CHORUS_NOM_SOCIETE VARCHAR(25),
- CHORUS_FOURNISSEUR_NOM VARCHAR(35),
- CHORUS_FOURNISSEUR_SIRET VARCHAR(16),
- CHORUS_PAYEUR_NOM VARCHAR(35),
- CHORUS_PAYEUR_SIRET VARCHAR(16),
- CHORUS_RIB_PAYS VARCHAR(3),
- CHORUS_RIB_BANC VARCHAR(15),
- CHORUS_RIB_COMPTE VARCHAR(18),
- CHORUS_RIB_CLE VARCHAR(2),
- CHORUS_DOMAINE_FONCTIONNEL VARCHAR(16),
- CHORUS_NUM_EJ_LONG VARCHAR(40),
- CHORUS_WITH_PJ INTEGER,
- INDEX IX_ETATEDMN_ANNEE_BUDG (ANNEE_BUDG),
- INDEX IX_ETATEDMN_ART_BUDG (ART_BUDG),
- INDEX IX_ETATEDMN_ART_BDG_P (ART_BUDG_PREV),
- INDEX IX_ETATEDMN_CHAP_BUDG (CHAP_BUDG),
- INDEX IX_ETATEDMN_CHAP_CLASS (CHAP_CLASS),
- INDEX IX_ETATEDMN_OPER_EXC (CODE_OPER_EXC),
- INDEX IX_ETATEDMN_COMPTA (COMPTABLE),
- INDEX IX_ETATEDMN_DATE_CREA (DATE_CREA),
- INDEX IX_ETATEDMN_DTE_PAY (DATE_PAIEMENT),
- INDEX IX_IMPUTATION (IMPUTATION),
- INDEX IX_ETATEDMN_LIB_ACTION (LIB_ACTION),
- INDEX IX_LIB_COMPTA (COLLECTIVITE,BUDGET,LIB_COMPTABLE),
- INDEX IX_LIB_MINISTERE (COLLECTIVITE,BUDGET,LIB_MINISTERE),
- INDEX IX_LIB_ORDO (COLLECTIVITE,BUDGET,LIB_ORDO),
- INDEX IX_ETATEDMN_LIB_PROG (LIB_PROGRAMME),
- INDEX IX_ETATEDMN_MINISTERE (MINISTERE),
- INDEX IX_ETATEDMN_MT_PJ (MT_PJ),
- INDEX IX_ETATEDMN_NUM_ENGAG (NUM_ENGAG),
- INDEX IX_ETATEDMN_LIASSE_LOC (NUM_LIASSE_LOC),
- INDEX IX_ETATEDMN_LIASSE_LOC_DEB (NUM_LIASSE_DEB),
- INDEX IX_ETATEDMN_LIASSE_LOC_FIN (NUM_LIASSE_FIN),
- INDEX IX_ETATEDMN_PIECE_COMPTA (NUM_PIECE_COMPTA),
- INDEX IX_ETATEDMN_ORDO (ORDO),
- INDEX IX_ETATEDMN_PARAG_BUDG (PARAG_BUDG),
- INDEX IX_ETATEDMN_TRIM (TRIMESTRE),
- INDEX IX_ETATEDMN_TYPE_EVT (TYPE_EVT),
- INDEX IX_ETATEDMN_TYPE_PAY (TYPE_PAIEMENT),
- INDEX IX_CHORUS_NOM_SOCIETE (CHORUS_NOM_SOCIETE),
- INDEX IX_CHORUS_FOURNISSEUR_NOM (CHORUS_FOURNISSEUR_NOM),
- INDEX IX_CHORUS_FOURNISSEUR_SIRET (CHORUS_FOURNISSEUR_SIRET),
- INDEX IX_CHORUS_PAYEUR_NOM (CHORUS_PAYEUR_NOM),
- INDEX IX_CHORUS_PAYEUR_SIRET (CHORUS_PAYEUR_SIRET),
- INDEX IX_CHORUS_RIB_PAYS (CHORUS_RIB_PAYS),
- INDEX IX_CHORUS_RIB_BANC (CHORUS_RIB_BANC),
- INDEX IX_CHORUS_RIB_COMPTE (CHORUS_RIB_COMPTE),
- INDEX IX_CHORUS_RIB_CLE (CHORUS_RIB_CLE),
- INDEX IX_CHORUS_DOMAINE_FONCTIONNEL (CHORUS_DOMAINE_FONCTIONNEL),
- INDEX IX_CHORUS_NUM_EJ_LONG (CHORUS_NUM_EJ_LONG),
- INDEX IX_CHORUS_WITH_PJ (CHORUS_WITH_PJ),
- INITIAL_DOC_NAME VARCHAR(100),
- INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
- ARCHIVE_NAME VARCHAR(100),
- INDEX ${base-name}_AN (ARCHIVE_NAME)
- ) ENGINE MYISAM
- <patch from-version="1">
- <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_COMPTABLE VARCHAR(250)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_ORDO VARCHAR(250)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_MINISTERE VARCHAR(250)</sql>
- <sql failonerror="false">CREATE INDEX IX_LIB_COMPTA ON ${base-name} (COLLECTIVITE,BUDGET,LIB_COMPTABLE)</sql>
- <sql failonerror="false">CREATE INDEX IX_LIB_MINISTERE ON ${base-name} (COLLECTIVITE,BUDGET,LIB_MINISTERE)</sql>
- <sql failonerror="false">CREATE INDEX IX_LIB_ORDO ON ${base-name} (COLLECTIVITE,BUDGET,LIB_ORDO)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_PROGRAMME VARCHAR(250)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_ACTION VARCHAR(250)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD CODE_OPER_EXC VARCHAR(32)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_PIECE_COMPTA VARCHAR(32)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_PROG ON ${base-name} (LIB_PROGRAMME)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_ACTION ON ${base-name} (LIB_ACTION)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_OPER_EXC ON ${base-name} (CODE_OPER_EXC)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_PIECE_COMPTA ON ${base-name} (NUM_PIECE_COMPTA)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_DEB VARCHAR(4)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_FIN VARCHAR(4)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_DEB ON ${base-name} (NUM_LIASSE_DEB)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_FIN ON ${base-name} (NUM_LIASSE_FIN)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD DATE_PAIEMENT DATE</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_DTE_PAY ON ${base-name} (DATE_PAIEMENT)</sql>
+ <table type="index" id="T1" base-name="EDMN_ETATEDMN_INDEX_EDMN" version="9"
+ main="true"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(15)
+ NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL, ANNEE_BUDG
+ INTEGER, ART_BUDG VARCHAR(2), ART_BUDG_PREV VARCHAR(2), CHAP_BUDG VARCHAR(4),
+ CHAP_CLASS VARCHAR(4), CODE_OPER_EXC VARCHAR(32), COMPTABLE VARCHAR(6),
+ DATE_CREA DATE, DATE_PAIEMENT DATE, IMPUTATION CHAR(1), LIB_ACTION VARCHAR(250),
+ LIB_COMPTABLE VARCHAR(250), LIB_MINISTERE VARCHAR(250), LIB_ORDO VARCHAR(250),
+ LIB_PROGRAMME VARCHAR(250), MINISTERE VARCHAR(3), MT_PJ DECIMAL(14,2), NUM_ENGAG
+ VARCHAR(6), NUM_LIASSE_DEB VARCHAR(4), NUM_LIASSE_FIN VARCHAR(4), NUM_LIASSE_LOC
+ VARCHAR(8), NUM_MANDAT VARCHAR(6), NUM_PIECE_COMPTA VARCHAR(32), OPE_INVEST
+ VARCHAR(8), ORDO VARCHAR(10), PARAG_BUDG VARCHAR(2), TRIMESTRE INTEGER, TYPE_EVT
+ VARCHAR(3), TYPE_PAIEMENT VARCHAR(3), CHORUS_NOM_SOCIETE VARCHAR(25),
+ CHORUS_FOURNISSEUR_NOM VARCHAR(35), CHORUS_FOURNISSEUR_SIRET VARCHAR(16),
+ CHORUS_PAYEUR_NOM VARCHAR(35), CHORUS_PAYEUR_SIRET VARCHAR(16), CHORUS_RIB_PAYS
+ VARCHAR(3), CHORUS_RIB_BANC VARCHAR(15), CHORUS_RIB_COMPTE VARCHAR(18),
+ CHORUS_RIB_CLE VARCHAR(2), CHORUS_DOMAINE_FONCTIONNEL VARCHAR(16),
+ CHORUS_NUM_EJ_LONG VARCHAR(40), CHORUS_WITH_PJ INTEGER, INDEX
+ IX_ETATEDMN_ANNEE_BUDG (ANNEE_BUDG), INDEX IX_ETATEDMN_ART_BUDG (ART_BUDG),
+ INDEX IX_ETATEDMN_ART_BDG_P (ART_BUDG_PREV), INDEX IX_ETATEDMN_CHAP_BUDG
+ (CHAP_BUDG), INDEX IX_ETATEDMN_CHAP_CLASS (CHAP_CLASS), INDEX
+ IX_ETATEDMN_OPER_EXC (CODE_OPER_EXC), INDEX IX_ETATEDMN_COMPTA (COMPTABLE),
+ INDEX IX_ETATEDMN_DATE_CREA (DATE_CREA), INDEX IX_ETATEDMN_DTE_PAY
+ (DATE_PAIEMENT), INDEX IX_IMPUTATION (IMPUTATION), INDEX IX_ETATEDMN_LIB_ACTION
+ (LIB_ACTION), INDEX IX_LIB_COMPTA (COLLECTIVITE,BUDGET,LIB_COMPTABLE), INDEX
+ IX_LIB_MINISTERE (COLLECTIVITE,BUDGET,LIB_MINISTERE), INDEX IX_LIB_ORDO
+ (COLLECTIVITE,BUDGET,LIB_ORDO), INDEX IX_ETATEDMN_LIB_PROG (LIB_PROGRAMME),
+ INDEX IX_ETATEDMN_MINISTERE (MINISTERE), INDEX IX_ETATEDMN_MT_PJ (MT_PJ), INDEX
+ IX_ETATEDMN_NUM_ENGAG (NUM_ENGAG), INDEX IX_ETATEDMN_LIASSE_LOC
+ (NUM_LIASSE_LOC), INDEX IX_ETATEDMN_LIASSE_LOC_DEB (NUM_LIASSE_DEB), INDEX
+ IX_ETATEDMN_LIASSE_LOC_FIN (NUM_LIASSE_FIN), INDEX IX_ETATEDMN_PIECE_COMPTA
+ (NUM_PIECE_COMPTA), INDEX IX_ETATEDMN_ORDO (ORDO), INDEX IX_ETATEDMN_PARAG_BUDG
+ (PARAG_BUDG), INDEX IX_ETATEDMN_TRIM (TRIMESTRE), INDEX IX_ETATEDMN_TYPE_EVT
+ (TYPE_EVT), INDEX IX_ETATEDMN_TYPE_PAY (TYPE_PAIEMENT), INDEX
+ IX_CHORUS_NOM_SOCIETE (CHORUS_NOM_SOCIETE), INDEX IX_CHORUS_FOURNISSEUR_NOM
+ (CHORUS_FOURNISSEUR_NOM), INDEX IX_CHORUS_FOURNISSEUR_SIRET
+ (CHORUS_FOURNISSEUR_SIRET), INDEX IX_CHORUS_PAYEUR_NOM (CHORUS_PAYEUR_NOM),
+ INDEX IX_CHORUS_PAYEUR_SIRET (CHORUS_PAYEUR_SIRET), INDEX IX_CHORUS_RIB_PAYS
+ (CHORUS_RIB_PAYS), INDEX IX_CHORUS_RIB_BANC (CHORUS_RIB_BANC), INDEX
+ IX_CHORUS_RIB_COMPTE (CHORUS_RIB_COMPTE), INDEX IX_CHORUS_RIB_CLE
+ (CHORUS_RIB_CLE), INDEX IX_CHORUS_DOMAINE_FONCTIONNEL
+ (CHORUS_DOMAINE_FONCTIONNEL), INDEX IX_CHORUS_NUM_EJ_LONG (CHORUS_NUM_EJ_LONG),
+ INDEX IX_CHORUS_WITH_PJ (CHORUS_WITH_PJ), INITIAL_DOC_NAME VARCHAR(100), INDEX
+ ${base-name}_IDN (INITIAL_DOC_NAME), ARCHIVE_NAME VARCHAR(100), INDEX
+ ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM <patch from-version="1">
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_COMPTABLE
+ VARCHAR(250)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_ORDO
+ VARCHAR(250)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_MINISTERE
+ VARCHAR(250)</sql>
+ <sql failonerror="false">CREATE INDEX IX_LIB_COMPTA ON ${base-name}
+ (COLLECTIVITE,BUDGET,LIB_COMPTABLE)</sql>
+ <sql failonerror="false">CREATE INDEX IX_LIB_MINISTERE ON ${base-name}
+ (COLLECTIVITE,BUDGET,LIB_MINISTERE)</sql>
+ <sql failonerror="false">CREATE INDEX IX_LIB_ORDO ON ${base-name}
+ (COLLECTIVITE,BUDGET,LIB_ORDO)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_PROGRAMME
+ VARCHAR(250)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_ACTION
+ VARCHAR(250)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CODE_OPER_EXC
+ VARCHAR(32)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_PIECE_COMPTA
+ VARCHAR(32)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_PROG ON ${base-name}
+ (LIB_PROGRAMME)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_ACTION ON ${base-name}
+ (LIB_ACTION)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_OPER_EXC ON ${base-name}
+ (CODE_OPER_EXC)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_PIECE_COMPTA ON
+ ${base-name} (NUM_PIECE_COMPTA)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_DEB
+ VARCHAR(4)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_FIN
+ VARCHAR(4)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_DEB ON
+ ${base-name} (NUM_LIASSE_DEB)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_FIN ON
+ ${base-name} (NUM_LIASSE_FIN)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD DATE_PAIEMENT
+ DATE</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_DTE_PAY ON ${base-name}
+ (DATE_PAIEMENT)</sql>
</patch>
<patch from-version="2">
- <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_MINISTERE VARCHAR(250)</sql>
- <sql failonerror="false">CREATE INDEX IX_LIB_COMPTA ON ${base-name} (COLLECTIVITE,BUDGET,LIB_COMPTABLE)</sql>
- <sql failonerror="false">CREATE INDEX IX_LIB_MINISTERE ON ${base-name} (COLLECTIVITE,BUDGET,LIB_MINISTERE)</sql>
- <sql failonerror="false">CREATE INDEX IX_LIB_ORDO ON ${base-name} (COLLECTIVITE,BUDGET,LIB_ORDO)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_PROGRAMME VARCHAR(250)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_ACTION VARCHAR(250)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD CODE_OPER_EXC VARCHAR(32)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_PIECE_COMPTA VARCHAR(32)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_PROG ON ${base-name} (LIB_PROGRAMME)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_ACTION ON ${base-name} (LIB_ACTION)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_OPER_EXC ON ${base-name} (CODE_OPER_EXC)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_PIECE_COMPTA ON ${base-name} (NUM_PIECE_COMPTA)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_DEB VARCHAR(4)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_FIN VARCHAR(4)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_DEB ON ${base-name} (NUM_LIASSE_DEB)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_FIN ON ${base-name} (NUM_LIASSE_FIN)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD DATE_PAIEMENT DATE</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_DTE_PAY ON ${base-name} (DATE_PAIEMENT)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_MINISTERE
+ VARCHAR(250)</sql>
+ <sql failonerror="false">CREATE INDEX IX_LIB_COMPTA ON ${base-name}
+ (COLLECTIVITE,BUDGET,LIB_COMPTABLE)</sql>
+ <sql failonerror="false">CREATE INDEX IX_LIB_MINISTERE ON ${base-name}
+ (COLLECTIVITE,BUDGET,LIB_MINISTERE)</sql>
+ <sql failonerror="false">CREATE INDEX IX_LIB_ORDO ON ${base-name}
+ (COLLECTIVITE,BUDGET,LIB_ORDO)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_PROGRAMME
+ VARCHAR(250)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_ACTION
+ VARCHAR(250)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CODE_OPER_EXC
+ VARCHAR(32)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_PIECE_COMPTA
+ VARCHAR(32)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_PROG ON ${base-name}
+ (LIB_PROGRAMME)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_ACTION ON ${base-name}
+ (LIB_ACTION)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_OPER_EXC ON ${base-name}
+ (CODE_OPER_EXC)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_PIECE_COMPTA ON
+ ${base-name} (NUM_PIECE_COMPTA)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_DEB
+ VARCHAR(4)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_FIN
+ VARCHAR(4)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_DEB ON
+ ${base-name} (NUM_LIASSE_DEB)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_FIN ON
+ ${base-name} (NUM_LIASSE_FIN)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD DATE_PAIEMENT
+ DATE</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_DTE_PAY ON ${base-name}
+ (DATE_PAIEMENT)</sql>
</patch>
<patch from-version="3">
- <sql failonerror="false">CREATE INDEX IX_LIB_COMPTA ON ${base-name} (COLLECTIVITE,BUDGET,LIB_COMPTABLE)</sql>
- <sql failonerror="false">CREATE INDEX IX_LIB_MINISTERE ON ${base-name} (COLLECTIVITE,BUDGET,LIB_MINISTERE)</sql>
- <sql failonerror="false">CREATE INDEX IX_LIB_ORDO ON ${base-name} (COLLECTIVITE,BUDGET,LIB_ORDO)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_PROGRAMME VARCHAR(250)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_ACTION VARCHAR(250)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD CODE_OPER_EXC VARCHAR(32)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_PIECE_COMPTA VARCHAR(32)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_PROG ON ${base-name} (LIB_PROGRAMME)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_ACTION ON ${base-name} (LIB_ACTION)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_OPER_EXC ON ${base-name} (CODE_OPER_EXC)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_PIECE_COMPTA ON ${base-name} (NUM_PIECE_COMPTA)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_DEB VARCHAR(4)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_FIN VARCHAR(4)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_DEB ON ${base-name} (NUM_LIASSE_DEB)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_FIN ON ${base-name} (NUM_LIASSE_FIN)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD DATE_PAIEMENT DATE</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_DTE_PAY ON ${base-name} (DATE_PAIEMENT)</sql>
+ <sql failonerror="false">CREATE INDEX IX_LIB_COMPTA ON ${base-name}
+ (COLLECTIVITE,BUDGET,LIB_COMPTABLE)</sql>
+ <sql failonerror="false">CREATE INDEX IX_LIB_MINISTERE ON ${base-name}
+ (COLLECTIVITE,BUDGET,LIB_MINISTERE)</sql>
+ <sql failonerror="false">CREATE INDEX IX_LIB_ORDO ON ${base-name}
+ (COLLECTIVITE,BUDGET,LIB_ORDO)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_PROGRAMME
+ VARCHAR(250)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_ACTION
+ VARCHAR(250)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CODE_OPER_EXC
+ VARCHAR(32)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_PIECE_COMPTA
+ VARCHAR(32)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_PROG ON ${base-name}
+ (LIB_PROGRAMME)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_ACTION ON ${base-name}
+ (LIB_ACTION)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_OPER_EXC ON ${base-name}
+ (CODE_OPER_EXC)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_PIECE_COMPTA ON
+ ${base-name} (NUM_PIECE_COMPTA)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_DEB
+ VARCHAR(4)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_FIN
+ VARCHAR(4)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_DEB ON
+ ${base-name} (NUM_LIASSE_DEB)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_FIN ON
+ ${base-name} (NUM_LIASSE_FIN)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD DATE_PAIEMENT
+ DATE</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_DTE_PAY ON ${base-name}
+ (DATE_PAIEMENT)</sql>
</patch>
<patch from-version="4">
- <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_PROGRAMME VARCHAR(250)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_ACTION VARCHAR(250)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD CODE_OPER_EXC VARCHAR(32)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_PIECE_COMPTA VARCHAR(32)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_PROG ON ${base-name} (LIB_PROGRAMME)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_ACTION ON ${base-name} (LIB_ACTION)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_OPER_EXC ON ${base-name} (CODE_OPER_EXC)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_PIECE_COMPTA ON ${base-name} (NUM_PIECE_COMPTA)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_DEB VARCHAR(4)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_FIN VARCHAR(4)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_DEB ON ${base-name} (NUM_LIASSE_DEB)</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_FIN ON ${base-name} (NUM_LIASSE_FIN)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD DATE_PAIEMENT DATE</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_DTE_PAY ON ${base-name} (DATE_PAIEMENT)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_PROGRAMME
+ VARCHAR(250)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD LIB_ACTION
+ VARCHAR(250)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CODE_OPER_EXC
+ VARCHAR(32)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_PIECE_COMPTA
+ VARCHAR(32)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_PROG ON ${base-name}
+ (LIB_PROGRAMME)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIB_ACTION ON ${base-name}
+ (LIB_ACTION)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_OPER_EXC ON ${base-name}
+ (CODE_OPER_EXC)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_PIECE_COMPTA ON
+ ${base-name} (NUM_PIECE_COMPTA)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_DEB
+ VARCHAR(4)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NUM_LIASSE_FIN
+ VARCHAR(4)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_DEB ON
+ ${base-name} (NUM_LIASSE_DEB)</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_LIASSE_LOC_FIN ON
+ ${base-name} (NUM_LIASSE_FIN)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD DATE_PAIEMENT
+ DATE</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_DTE_PAY ON ${base-name}
+ (DATE_PAIEMENT)</sql>
</patch>
<patch from-version="5">
- <sql failonerror="false">ALTER TABLE ${base-name} ADD IMPUTATION CHAR(1)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD INDEX IX_IMPUTATION(IMPUTATION)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD DATE_PAIEMENT DATE</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_DTE_PAY ON ${base-name} (DATE_PAIEMENT)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD IMPUTATION
+ CHAR(1)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD INDEX
+ IX_IMPUTATION(IMPUTATION)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD DATE_PAIEMENT
+ DATE</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_DTE_PAY ON ${base-name}
+ (DATE_PAIEMENT)</sql>
</patch>
<patch from-version="6">
- <sql failonerror="false">ALTER TABLE ${base-name} ADD DATE_PAIEMENT DATE</sql>
- <sql failonerror="false">CREATE INDEX IX_ETATEDMN_DTE_PAY ON ${base-name} (DATE_PAIEMENT)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD DATE_PAIEMENT
+ DATE</sql>
+ <sql failonerror="false">CREATE INDEX IX_ETATEDMN_DTE_PAY ON ${base-name}
+ (DATE_PAIEMENT)</sql>
</patch>
<patch from-version="7">
- <sql failonerror="false">ALTER TABLE ${base-name} MODIFY MT_PJ DECIMAL(17,2)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} MODIFY MT_PJ
+ DECIMAL(17,2)</sql>
</patch>
<patch from-version="8">
- <sql failonerror="false">DROP INDEX IX_ETATEDMN_ANNEE_ENGAG ON ${base-name}</sql>
+ <sql failonerror="false">DROP INDEX IX_ETATEDMN_ANNEE_ENGAG ON
+ ${base-name}</sql>
<sql failonerror="false">ALTER TABLE ${base-name} DROP ANNEE_ENGAG</sql>
- <sql failonerror="false">DROP INDEX IX_ETATEDMN_CPTE_TRESOR ON ${base-name}</sql>
+ <sql failonerror="false">DROP INDEX IX_ETATEDMN_CPTE_TRESOR ON
+ ${base-name}</sql>
<sql failonerror="false">ALTER TABLE ${base-name} DROP CPTE_TRESOR</sql>
<sql failonerror="false">DROP INDEX IX_ETATEDMN_ECO1 ON ${base-name}</sql>
<sql failonerror="false">ALTER TABLE ${base-name} DROP SUIVI_ECO1</sql>
<sql failonerror="false">DROP INDEX IX_ETATEDMN_ECO3 ON ${base-name}</sql>
<sql failonerror="false">ALTER TABLE ${base-name} DROP SUIVI_ECO3</sql>
<sql failonerror="false">DROP INDEX IX_ETATEDMN_MOIS ON ${base-name}</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} DROP MOIS</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} DROP MOIS</sql>
<sql failonerror="false">ALTER TABLE ${base-name} DROP ZONE24</sql>
<sql failonerror="false">ALTER TABLE ${base-name} DROP ZONE32</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} DROP SIGNE_MT</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} DROP SIGNE_MT</sql>
<sql failonerror="false">ALTER TABLE ${base-name} DROP CODE_CORR</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} DROP CODE_MANIP</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} DROP CODE_MANIP</sql>
<sql failonerror="false">ALTER TABLE ${base-name} DROP NUM_LIASSE</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_NOM_SOCIETE VARCHAR(25)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_FOURNISSEUR_NOM VARCHAR(35)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_FOURNISSEUR_SIRET VARCHAR(16)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_PAYEUR_NOM VARCHAR(35)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_PAYEUR_SIRET VARCHAR(16)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_RIB_PAYS VARCHAR(3)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_RIB_BANC VARCHAR(15)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_RIB_COMPTE VARCHAR(18)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_RIB_CLE VARCHAR(2)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_DOMAINE_FONCTIONNEL VARCHAR(16)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_NUM_EJ_LONG VARCHAR(40)</sql>
- <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_WITH_PJ INTEGER</sql>
- <sql failonerror="false">CREATE INDEX IX_CHORUS_NOM_SOCIETE ON ${base-name} (CHORUS_NOM_SOCIETE)</sql>
- <sql failonerror="false">CREATE INDEX IX_CHORUS_FOURNISSEUR_NOM ON ${base-name} (CHORUS_FOURNISSEUR_NOM)</sql>
- <sql failonerror="false">CREATE INDEX IX_CHORUS_FOURNISSEUR_SIRET ON ${base-name} (CHORUS_FOURNISSEUR_SIRET)</sql>
- <sql failonerror="false">CREATE INDEX IX_CHORUS_PAYEUR_NOM ON ${base-name} (CHORUS_PAYEUR_NOM)</sql>
- <sql failonerror="false">CREATE INDEX IX_CHORUS_PAYEUR_SIRET ON ${base-name} (CHORUS_PAYEUR_SIRET)</sql>
- <sql failonerror="false">CREATE INDEX IX_CHORUS_RIB_PAYS ON ${base-name} (CHORUS_RIB_PAYS)</sql>
- <sql failonerror="false">CREATE INDEX IX_CHORUS_RIB_BANC ON ${base-name} (CHORUS_RIB_BANC)</sql>
- <sql failonerror="false">CREATE INDEX IX_CHORUS_RIB_COMPTE ON ${base-name} (CHORUS_RIB_COMPTE)</sql>
- <sql failonerror="false">CREATE INDEX IX_CHORUS_RIB_CLE ON ${base-name} (CHORUS_RIB_CLE)</sql>
- <sql failonerror="false">CREATE INDEX IX_CHORUS_DOMAINE_FONCTIONNEL ON ${base-name} (CHORUS_DOMAINE_FONCTIONNEL)</sql>
- <sql failonerror="false">CREATE INDEX IX_CHORUS_NUM_EJ_LONG ON ${base-name} (CHORUS_NUM_EJ_LONG)</sql>
- <sql failonerror="false">CREATE INDEX IX_CHORUS_WITH_PJ ON ${base-name} (CHORUS_WITH_PJ)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_NOM_SOCIETE
+ VARCHAR(25)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_FOURNISSEUR_NOM
+ VARCHAR(35)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD
+ CHORUS_FOURNISSEUR_SIRET VARCHAR(16)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_PAYEUR_NOM
+ VARCHAR(35)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_PAYEUR_SIRET
+ VARCHAR(16)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_RIB_PAYS
+ VARCHAR(3)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_RIB_BANC
+ VARCHAR(15)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_RIB_COMPTE
+ VARCHAR(18)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_RIB_CLE
+ VARCHAR(2)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD
+ CHORUS_DOMAINE_FONCTIONNEL VARCHAR(16)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_NUM_EJ_LONG
+ VARCHAR(40)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD CHORUS_WITH_PJ
+ INTEGER</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_NOM_SOCIETE ON ${base-name}
+ (CHORUS_NOM_SOCIETE)</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_FOURNISSEUR_NOM ON
+ ${base-name} (CHORUS_FOURNISSEUR_NOM)</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_FOURNISSEUR_SIRET ON
+ ${base-name} (CHORUS_FOURNISSEUR_SIRET)</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_PAYEUR_NOM ON ${base-name}
+ (CHORUS_PAYEUR_NOM)</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_PAYEUR_SIRET ON ${base-name}
+ (CHORUS_PAYEUR_SIRET)</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_RIB_PAYS ON ${base-name}
+ (CHORUS_RIB_PAYS)</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_RIB_BANC ON ${base-name}
+ (CHORUS_RIB_BANC)</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_RIB_COMPTE ON ${base-name}
+ (CHORUS_RIB_COMPTE)</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_RIB_CLE ON ${base-name}
+ (CHORUS_RIB_CLE)</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_DOMAINE_FONCTIONNEL ON
+ ${base-name} (CHORUS_DOMAINE_FONCTIONNEL)</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_NUM_EJ_LONG ON ${base-name}
+ (CHORUS_NUM_EJ_LONG)</sql>
+ <sql failonerror="false">CREATE INDEX IX_CHORUS_WITH_PJ ON ${base-name}
+ (CHORUS_WITH_PJ)</sql>
</patch>
</table>
- <table id="T2" base-name="EDMN_ETATEDMN_IX_EDMN_LIASSES" type="index" version="3" 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,
- NUM_LIASSE VARCHAR(6) NOT NULL,
- ANNEE_GESTION INTEGER,
- INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
- INDEX IX_${base-name}_DC (DOC_ID),
- INDEX IX_EDMN_ETATEDMN_LIASSES_ANGEST (COLLECTIVITE,BUDGET,ANNEE_GESTION),
- INDEX IX_EDMN_ETATEDMN_LIASSES_LIASSE_CENTRALE (NUM_LIASSE),
- INITIAL_DOC_NAME VARCHAR(100),
- INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
- ARCHIVE_NAME VARCHAR(100),
- INDEX ${base-name}_AN (ARCHIVE_NAME)
- ) ENGINE MYISAM
- <patch from-version="1">
- <sql failonerror="false">ALTER TABLE EDMN_ETATEDMN_IX_EDMN_LIASSES ADD ANNEE_GESTION INTEGER, ADD INDEX IX_EDMN_ETATEDMN_LIASSES_ANGEST(COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql>
- </patch>
- <patch from-version="2">
- <sql failonerror="false">CREATE INDEX IX_EDMN_ETATEDMN_LIASSES_LIASSE_CENTRALE ON ${base-name} (NUM_LIASSE)</sql>
- </patch>
+ <table id="T2" base-name="EDMN_ETATEDMN_IX_EDMN_LIASSES" type="index" version="3"
+ 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,
+ NUM_LIASSE VARCHAR(6) NOT NULL, ANNEE_GESTION INTEGER, INDEX IX_${base-name}_BC
+ (COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID), INDEX
+ IX_EDMN_ETATEDMN_LIASSES_ANGEST (COLLECTIVITE,BUDGET,ANNEE_GESTION), INDEX
+ IX_EDMN_ETATEDMN_LIASSES_LIASSE_CENTRALE (NUM_LIASSE), INITIAL_DOC_NAME
+ VARCHAR(100), INDEX ${base-name}_IDN (INITIAL_DOC_NAME), ARCHIVE_NAME
+ VARCHAR(100), INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM <patch
+ from-version="1">
+ <sql failonerror="false">ALTER TABLE EDMN_ETATEDMN_IX_EDMN_LIASSES ADD
+ ANNEE_GESTION INTEGER, ADD INDEX
+ IX_EDMN_ETATEDMN_LIASSES_ANGEST(COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql>
+ </patch>
+ <patch from-version="2">
+ <sql failonerror="false">CREATE INDEX
+ IX_EDMN_ETATEDMN_LIASSES_LIASSE_CENTRALE ON ${base-name}
+ (NUM_LIASSE)</sql>
+ </patch>
</table>
<criteria id="comptable" sql-index-id="comptable">
<where-clause>fn:date-compare(${table}.${column},datePaie)</where-clause>
</criteria>
<criteria id="typeEvt" sql-index-id="typeEvt">
- <where-clause>${table}.${column}='##VALEUR:typeEvt##'</where-clause>
+ <where-clause>${table}.${column}='##VALEUR:typeEvt##'</where-clause>
</criteria>
<criteria id="liasseLocale" sql-index-id="numLiasseLocale">
<where-clause>fn:string-compare(${table}.${column},numLiasse)</where-clause>
<criteria id="with_pj" sql-index-id="chorus_with_pj">
<where-clause>${table}.${column}='##VALEUR:with_pj##'</where-clause>
</criteria>
-
-
+
+
<!-- LIGNES EDMN -->
- <sql-index id="anneeBudget" table="T1" column="ANNEE_BUDG" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:AnneeBudget/@V" datatype="integer"/>
- <sql-index id="action" table="T1" column="ART_BUDG" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ArtBudgExec/@V" datatype="string" format="uppercase"/>
- <sql-index id="artPrev" table="T1" column="ART_BUDG_PREV" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ArtBudgPrev/@V" datatype="string" format="uppercase"/>
- <sql-index id="programme" table="T1" column="CHAP_BUDG" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ChapBudg/@V" datatype="string" format="uppercase"/>
- <sql-index id="chapClassPJ" table="T1" column="CHAP_CLASS" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ChapClassPJ/@V" datatype="string"/>
- <sql-index id="codOperExc" table="T1" column="CODE_OPER_EXC" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:CodeOperExc/@V" datatype="string" format="uppercase"/>
- <sql-index id="comptable" table="T1" column="COMPTABLE" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Comptable/@V" datatype="string" format="uppercase"/>
- <sql-index id="dateCrea" table="T1" column="DATE_CREA" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:DateCreation/@V" datatype="date" format="yyyy-MM-dd"/>
- <sql-index id="datePaiement" table="T1" column="DATE_PAIEMENT" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:DatePaiement/@V" datatype="date" format="yyyy-MM-dd"/>
- <sql-index id="imputation" table="T1" column="IMPUTATION" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Imputation/@V" datatype="string"/>
- <sql-index id="libAction" table="T1" column="LIB_ACTION" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleAction/@V" datatype="string" format="uppercase"/>
- <sql-index id="lib-comptable" table="T1" column="LIB_COMPTABLE" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleComptable/@V" datatype="string" format="uppercase"/>
- <sql-index id="lib-ministere" table="T1" column="LIB_MINISTERE" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Ministere/@LibelleMinistere" datatype="string" format="uppercase"/>
- <sql-index id="lib-ordo" table="T1" column="LIB_ORDO" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleOrdonnateur/@V" datatype="string" format="uppercase"/>
- <sql-index id="libProgramme" table="T1" column="LIB_PROGRAMME" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleProgramme/@V" datatype="string" format="uppercase"/>
- <sql-index id="ministere" table="T1" column="MINISTERE" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Ministere/@V" datatype="string" format="uppercase"/>
- <sql-index id="mtPj" table="T1" column="MT_PJ" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:MtPJ/@V" datatype="decimal"/>
- <sql-index id="numLiasseLocale" table="T1" column="NUM_LIASSE_LOC" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasse/@V" datatype="string" format="uppercase"/>
- <sql-index id="numLiasseLocaleDeb" table="T1" column="NUM_LIASSE_DEB" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseDeb/@V" datatype="string" format="uppercase"/>
- <sql-index id="numLiasseLocaleFin" table="T1" column="NUM_LIASSE_FIN" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseFin/@V" datatype="string" format="uppercase"/>
- <sql-index id="numMandat" table="T1" column="NUM_MANDAT" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumMandat/@V" datatype="string" format="uppercase"/>
- <sql-index id="ordo" table="T1" column="ORDO" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Ordo/@V" datatype="string" format="uppercase"/>
- <sql-index id="numOpeInvest" table="T1" column="OPE_INVEST" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumOpeInvest/@V" datatype="string" format="uppercase"/>
- <sql-index id="cpce" table="T1" column="PARAG_BUDG" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ParagBudgExec/@V" datatype="string" format="uppercase"/>
- <sql-index id="trimestre" table="T1" column="TRIMESTRE" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Trimestre/@V" datatype="integer"/>
- <sql-index id="typeEvt" table="T1" column="TYPE_EVT" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:TypeEvt/@V" datatype="string"/>
- <sql-index id="typePaiement" table="T1" column="TYPE_PAIEMENT" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:TypePaiement/@V" datatype="string"/>
- <sql-index id="numPieceCompta" table="T1" column="NUM_PIECE_COMPTA" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumPieceCompta/@V" datatype="string" format="uppercase"/>
- <sql-index id="chorus_nom_societe" table="T1" column="CHORUS_NOM_SOCIETE" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@NomSociete" datatype="string" format="uppercase"/>
- <sql-index id="chorus_fournisseur_nom" table="T1" column="CHORUS_FOURNISSEUR_NOM" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@FournisseurNom" datatype="string" format="uppercase"/>
- <sql-index id="chorus_fournisseur_siret" table="T1" column="CHORUS_FOURNISSEUR_SIRET" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@FournisseurSiret" datatype="string" format="uppercase"/>
- <sql-index id="chorus_payeur_nom" table="T1" column="CHORUS_PAYEUR_NOM" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@PayeurNom" datatype="string" format="uppercase"/>
- <sql-index id="chorus_payeur_siret" table="T1" column="CHORUS_PAYEUR_SIRET" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@PayeurSiret" datatype="string" format="uppercase"/>
- <sql-index id="chorus_rib_pays" table="T1" column="CHORUS_RIB_PAYS" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibPays" datatype="string" format="uppercase"/>
- <sql-index id="chorus_rib_banc" table="T1" column="CHORUS_RIB_BANC" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibBanc" datatype="string" format="uppercase"/>
- <sql-index id="chorus_rib_compte" table="T1" column="CHORUS_RIB_COMPTE" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibCompte" datatype="string" format="uppercase"/>
- <sql-index id="chorus_rib_cle" table="T1" column="CHORUS_RIB_CLE" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibCle" datatype="string" format="uppercase"/>
- <sql-index id="chorus_domaine_fonctionnel" table="T1" column="CHORUS_DOMAINE_FONCTIONNEL" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@DomaineFonctionnel" datatype="string" format="uppercase"/>
- <sql-index id="chorus_num_ej_long" table="T1" column="CHORUS_NUM_EJ_LONG" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@NumEJLong" datatype="string" format="uppercase"/>
- <sql-index id="chorus_with_pj" table="T1" column="CHORUS_WITH_PJ" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/@added:withPJ" datatype="integer"/>
-
+ <sql-index id="anneeBudget" table="T1" column="ANNEE_BUDG"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:AnneeBudget/@V" datatype="integer"/>
+ <sql-index id="action" table="T1" column="ART_BUDG"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ArtBudgExec/@V" datatype="string"
+ format="uppercase"/>
+ <sql-index id="artPrev" table="T1" column="ART_BUDG_PREV"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ArtBudgPrev/@V" datatype="string"
+ format="uppercase"/>
+ <sql-index id="programme" table="T1" column="CHAP_BUDG"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ChapBudg/@V" datatype="string"
+ format="uppercase"/>
+ <sql-index id="chapClassPJ" table="T1" column="CHAP_CLASS"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ChapClassPJ/@V" datatype="string"/>
+ <sql-index id="codOperExc" table="T1" column="CODE_OPER_EXC"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:CodeOperExc/@V" datatype="string"
+ format="uppercase"/>
+ <sql-index id="comptable" table="T1" column="COMPTABLE"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Comptable/@V" datatype="string"
+ format="uppercase"/>
+ <sql-index id="dateCrea" table="T1" column="DATE_CREA"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:DateCreation/@V" datatype="date"
+ format="yyyy-MM-dd"/>
+ <sql-index id="datePaiement" table="T1" column="DATE_PAIEMENT"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:DatePaiement/@V" datatype="date"
+ format="yyyy-MM-dd"/>
+ <sql-index id="imputation" table="T1" column="IMPUTATION"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Imputation/@V" datatype="string"/>
+ <sql-index id="libAction" table="T1" column="LIB_ACTION"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleAction/@V" datatype="string"
+ format="uppercase"/>
+ <sql-index id="lib-comptable" table="T1" column="LIB_COMPTABLE"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleComptable/@V" datatype="string"
+ format="uppercase"/>
+ <sql-index id="lib-ministere" table="T1" column="LIB_MINISTERE"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Ministere/@LibelleMinistere"
+ datatype="string" format="uppercase"/>
+ <sql-index id="lib-ordo" table="T1" column="LIB_ORDO"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleOrdonnateur/@V" datatype="string"
+ format="uppercase"/>
+ <sql-index id="libProgramme" table="T1" column="LIB_PROGRAMME"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleProgramme/@V" datatype="string"
+ format="uppercase"/>
+ <sql-index id="ministere" table="T1" column="MINISTERE"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Ministere/@V" datatype="string"
+ format="uppercase"/>
+ <sql-index id="mtPj" table="T1" column="MT_PJ"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:MtPJ/@V" datatype="decimal"/>
+ <sql-index id="numLiasseLocale" table="T1" column="NUM_LIASSE_LOC"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasse/@V" datatype="string"
+ format="uppercase"/>
+ <sql-index id="numLiasseLocaleDeb" table="T1" column="NUM_LIASSE_DEB"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseDeb/@V" datatype="string"
+ format="uppercase"/>
+ <sql-index id="numLiasseLocaleFin" table="T1" column="NUM_LIASSE_FIN"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseFin/@V" datatype="string"
+ format="uppercase"/>
+ <sql-index id="numMandat" table="T1" column="NUM_MANDAT"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumMandat/@V" datatype="string"
+ format="uppercase"/>
+ <sql-index id="ordo" table="T1" column="ORDO"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Ordo/@V" datatype="string"
+ format="uppercase"/>
+ <sql-index id="numOpeInvest" table="T1" column="OPE_INVEST"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumOpeInvest/@V" datatype="string"
+ format="uppercase"/>
+ <sql-index id="cpce" table="T1" column="PARAG_BUDG"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ParagBudgExec/@V" datatype="string"
+ format="uppercase"/>
+ <sql-index id="trimestre" table="T1" column="TRIMESTRE"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Trimestre/@V" datatype="integer"/>
+ <sql-index id="typeEvt" table="T1" column="TYPE_EVT"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:TypeEvt/@V" datatype="string"/>
+ <sql-index id="typePaiement" table="T1" column="TYPE_PAIEMENT"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:TypePaiement/@V" datatype="string"/>
+ <sql-index id="numPieceCompta" table="T1" column="NUM_PIECE_COMPTA"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumPieceCompta/@V" datatype="string"
+ format="uppercase"/>
+ <sql-index id="chorus_nom_societe" table="T1" column="CHORUS_NOM_SOCIETE"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@NomSociete" datatype="string"
+ format="uppercase"/>
+ <sql-index id="chorus_fournisseur_nom" table="T1" column="CHORUS_FOURNISSEUR_NOM"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@FournisseurNom"
+ datatype="string" format="uppercase"/>
+ <sql-index id="chorus_fournisseur_siret" table="T1"
+ column="CHORUS_FOURNISSEUR_SIRET"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@FournisseurSiret"
+ datatype="string" format="uppercase"/>
+ <sql-index id="chorus_payeur_nom" table="T1" column="CHORUS_PAYEUR_NOM"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@PayeurNom" datatype="string"
+ format="uppercase"/>
+ <sql-index id="chorus_payeur_siret" table="T1" column="CHORUS_PAYEUR_SIRET"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@PayeurSiret" datatype="string"
+ format="uppercase"/>
+ <sql-index id="chorus_rib_pays" table="T1" column="CHORUS_RIB_PAYS"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibPays" datatype="string"
+ format="uppercase"/>
+ <sql-index id="chorus_rib_banc" table="T1" column="CHORUS_RIB_BANC"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibBanc" datatype="string"
+ format="uppercase"/>
+ <sql-index id="chorus_rib_compte" table="T1" column="CHORUS_RIB_COMPTE"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibCompte" datatype="string"
+ format="uppercase"/>
+ <sql-index id="chorus_rib_cle" table="T1" column="CHORUS_RIB_CLE"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibCle" datatype="string"
+ format="uppercase"/>
+ <sql-index id="chorus_domaine_fonctionnel" table="T1"
+ column="CHORUS_DOMAINE_FONCTIONNEL"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@DomaineFonctionnel"
+ datatype="string" format="uppercase"/>
+ <sql-index id="chorus_num_ej_long" table="T1" column="CHORUS_NUM_EJ_LONG"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@NumEJLong" datatype="string"
+ format="uppercase"/>
+ <sql-index id="chorus_with_pj" table="T1" column="CHORUS_WITH_PJ"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/@added:withPJ" datatype="integer"/>
+
<!-- LIASSES -->
- <sql-index id="numLiasseCentrale" table="T2" column="NUM_LIASSE" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseNationale/n:Liasse/@national" datatype="string" format="uppercase"/>
- <sql-index id="liasseAnneeGestion" table="T2" column="ANNEE_GESTION" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:AnneeBudget/@V" datatype="integer" use-in-criteria="false"/>
+ <sql-index id="numLiasseCentrale" table="T2" column="NUM_LIASSE"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseNationale/n:Liasse/@national"
+ datatype="string" format="uppercase"/>
+ <sql-index id="liasseAnneeGestion" table="T2" column="ANNEE_GESTION"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:AnneeBudget/@V" datatype="integer"
+ use-in-criteria="false"/>
<!-- chap class -->
</etat>
<etat id="budgets" import-xslt-file="edmn/edmn-import-mysql.xsl">
- <table base-name="EDMN_BUDG_DOCUMENTS" type="document" 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),
- INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
- ARCHIVE_NAME VARCHAR(100),
- INDEX ${base-name}_AN (ARCHIVE_NAME)
- ) ENGINE MYISAM
- </table>
- <table id="B1" base-name="EDMN_BUDG_INDEX" type="index" version="3" main="true" ignoreConstraintError="true">
- CREATE TABLE IF NOT EXISTS ${base-name} (
- COLLECTIVITE VARCHAR(15) NOT NULL,
- BUDGET VARCHAR(24) NOT NULL,
- DOC_ID VARCHAR(100) NOT NULL,
- ANNEE INTEGER NOT NULL,
- DATA VARCHAR(9) NOT NULL,
- MINISTERE VARCHAR(6) NOT NULL,
- PROGRAMME VARCHAR(6),
- ACTION VARCHAR(6),
- ART_REGROUP VARCHAR(6),
- CPCE VARCHAR(6),
- LIBELLE VARCHAR(150),
- INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
- UNIQUE INDEX IX_${base-name}_PK (COLLECTIVITE,BUDGET,ANNEE,DATA,MINISTERE,PROGRAMME,ACTION,ART_REGROUP),
- INITIAL_DOC_NAME VARCHAR(100),
- INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
- ARCHIVE_NAME VARCHAR(100),
- INDEX ${base-name}_AN (ARCHIVE_NAME)
- ) ENGINE MYISAM
- <patch from-version="1">
+ <table base-name="EDMN_BUDG_DOCUMENTS" type="document" 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), INDEX IX_${base-name}_BC
+ (COLLECTIVITE,BUDGET,DOC_ID), ARCHIVE_NAME VARCHAR(100), INDEX ${base-name}_AN
+ (ARCHIVE_NAME) ) ENGINE MYISAM </table>
+ <table id="B1" base-name="EDMN_BUDG_INDEX" type="index" version="3" main="true"
+ ignoreConstraintError="true"> CREATE TABLE IF NOT EXISTS ${base-name} (
+ COLLECTIVITE VARCHAR(15) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID
+ VARCHAR(100) NOT NULL, ANNEE INTEGER NOT NULL, DATA VARCHAR(9) NOT NULL,
+ MINISTERE VARCHAR(6) NOT NULL, PROGRAMME VARCHAR(6), ACTION VARCHAR(6),
+ ART_REGROUP VARCHAR(6), CPCE VARCHAR(6), LIBELLE VARCHAR(150), INDEX
+ IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), UNIQUE INDEX IX_${base-name}_PK
+ (COLLECTIVITE,BUDGET,ANNEE,DATA,MINISTERE,PROGRAMME,ACTION,ART_REGROUP),
+ INITIAL_DOC_NAME VARCHAR(100), INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
+ ARCHIVE_NAME VARCHAR(100), INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM
+ <patch from-version="1">
<sql failonerror="false">drop table EDMN_BUDG_INDEX</sql>
- <sql>CREATE TABLE IF NOT EXISTS ${base-name} (
- COLLECTIVITE VARCHAR(15) NOT NULL,
- BUDGET VARCHAR(24) NOT NULL,
- DOC_ID VARCHAR(100) NOT NULL,
- ANNEE INTEGER NOT NULL,
- DATA VARCHAR(9) NOT NULL,
- MINISTERE VARCHAR(6) NOT NULL,
- PROGRAMME VARCHAR(6),
- ACTION VARCHAR(6),
- CPCE VARCHAR(6),
- ART_REGROUP VARCHAR(6),
- LIBELLE VARCHAR(150),
- INDEX IX_EDMN_BUDG_INDEX_BC (COLLECTIVITE,BUDGET,DOC_ID),
- UNIQUE INDEX IX_EDMN_BUDG_INDEX_PK (COLLECTIVITE,BUDGET,ANNEE,DATA,MINISTERE,PROGRAMME,ACTION,ART_REGROUP),
- INITIAL_DOC_NAME VARCHAR(100),
- INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
- ARCHIVE_NAME VARCHAR(100),
- INDEX ${base-name}_AN (ARCHIVE_NAME)
- ) ENGINE MYISAM
- </sql>
+ <sql>CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(15) NOT
+ NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL, ANNEE
+ INTEGER NOT NULL, DATA VARCHAR(9) NOT NULL, MINISTERE VARCHAR(6) NOT
+ NULL, PROGRAMME VARCHAR(6), ACTION VARCHAR(6), CPCE VARCHAR(6),
+ ART_REGROUP VARCHAR(6), LIBELLE VARCHAR(150), INDEX
+ IX_EDMN_BUDG_INDEX_BC (COLLECTIVITE,BUDGET,DOC_ID), UNIQUE INDEX
+ IX_EDMN_BUDG_INDEX_PK
+ (COLLECTIVITE,BUDGET,ANNEE,DATA,MINISTERE,PROGRAMME,ACTION,ART_REGROUP),
+ INITIAL_DOC_NAME VARCHAR(100), INDEX ${base-name}_IDN
+ (INITIAL_DOC_NAME), ARCHIVE_NAME VARCHAR(100), INDEX ${base-name}_AN
+ (ARCHIVE_NAME) ) ENGINE MYISAM </sql>
</patch>
<patch from-version="2">
<sql failonerror="false">drop table EDMN_BUDG_INDEX</sql>
- <sql>CREATE TABLE IF NOT EXISTS ${base-name} (
- COLLECTIVITE VARCHAR(15) NOT NULL,
- BUDGET VARCHAR(24) NOT NULL,
- DOC_ID VARCHAR(100) NOT NULL,
- ANNEE INTEGER NOT NULL,
- DATA VARCHAR(9) NOT NULL,
- MINISTERE VARCHAR(6) NOT NULL,
- PROGRAMME VARCHAR(6),
- ACTION VARCHAR(6),
- CPCE VARCHAR(6),
- ART_REGROUP VARCHAR(6),
- LIBELLE VARCHAR(150),
- INDEX IX_EDMN_BUDG_INDEX_BC (COLLECTIVITE,BUDGET,DOC_ID),
- UNIQUE INDEX IX_EDMN_BUDG_INDEX_PK (COLLECTIVITE,BUDGET,ANNEE,DATA,MINISTERE,PROGRAMME,ACTION,ART_REGROUP),
- INITIAL_DOC_NAME VARCHAR(100),
- INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
- ARCHIVE_NAME VARCHAR(100),
- INDEX ${base-name}_AN (ARCHIVE_NAME)
- ) ENGINE MYISAM
- </sql>
+ <sql>CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(15) NOT
+ NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL, ANNEE
+ INTEGER NOT NULL, DATA VARCHAR(9) NOT NULL, MINISTERE VARCHAR(6) NOT
+ NULL, PROGRAMME VARCHAR(6), ACTION VARCHAR(6), CPCE VARCHAR(6),
+ ART_REGROUP VARCHAR(6), LIBELLE VARCHAR(150), INDEX
+ IX_EDMN_BUDG_INDEX_BC (COLLECTIVITE,BUDGET,DOC_ID), UNIQUE INDEX
+ IX_EDMN_BUDG_INDEX_PK
+ (COLLECTIVITE,BUDGET,ANNEE,DATA,MINISTERE,PROGRAMME,ACTION,ART_REGROUP),
+ INITIAL_DOC_NAME VARCHAR(100), INDEX ${base-name}_IDN
+ (INITIAL_DOC_NAME), ARCHIVE_NAME VARCHAR(100), INDEX ${base-name}_AN
+ (ARCHIVE_NAME) ) ENGINE MYISAM </sql>
</patch>
</table>
<criteria id="typeData" sql-index-id="typeData">
<criteria id="libBudget" sql-index-id="budg.lib">
<where-clause>fn:string-compare(${table}.${column},libBudg)</where-clause>
</criteria>
-
-
-
- <sql-index id="typeData" table="B1" column="DATA" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Data/@V" datatype="string"/>
- <sql-index id="annee" table="B1" column="ANNEE" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Annee/@V" datatype="integer"/>
- <sql-index id="min" table="B1" column="MINISTERE" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Ministere/@V" datatype="string"/>
- <sql-index id="prog" table="B1" column="PROGRAMME" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Programme/@V" datatype="string"/>
- <sql-index id="act" table="B1" column="ACTION" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Action/@V" datatype="string"/>
- <sql-index id="artRegroupt" table="B1" column="ART_REGROUP" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:ArticleRegroupt/@V" datatype="string" format="uppercase"/>
- <sql-index id="cpce2" table="B1" column="CPCE" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Cpce/@V" datatype="string" format="uppercase"/>
- <sql-index id="budg.lib" table="B1" column="LIBELLE" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Libelle/@V" datatype="string"/>
+
+
+
+ <sql-index id="typeData" table="B1" column="DATA"
+ path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Data/@V" datatype="string"/>
+ <sql-index id="annee" table="B1" column="ANNEE"
+ path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Annee/@V" datatype="integer"/>
+ <sql-index id="min" table="B1" column="MINISTERE"
+ path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Ministere/@V" datatype="string"/>
+ <sql-index id="prog" table="B1" column="PROGRAMME"
+ path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Programme/@V" datatype="string"/>
+ <sql-index id="act" table="B1" column="ACTION"
+ path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Action/@V" datatype="string"/>
+ <sql-index id="artRegroupt" table="B1" column="ART_REGROUP"
+ path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:ArticleRegroupt/@V"
+ datatype="string" format="uppercase"/>
+ <sql-index id="cpce2" table="B1" column="CPCE"
+ path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Cpce/@V" datatype="string"
+ format="uppercase"/>
+ <sql-index id="budg.lib" table="B1" column="LIBELLE"
+ path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Libelle/@V" datatype="string"/>
</etat>
<etat id="ordos" import-xslt-file="edmn/edmn-import-mysql.xsl">
- <table base-name="EDMN_ORDOS_DOCUMENTS" type="document" 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),
- INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
- ARCHIVE_NAME VARCHAR(100),
- INDEX ${base-name}_AN (ARCHIVE_NAME)
- ) ENGINE MYISAM
- </table>
- <table id="O1" base-name="EDMN_ORDOS_INDEX" type="index" version="2" main="true" ignoreConstraintError="true">
- CREATE TABLE IF NOT EXISTS ${base-name} (
- COLLECTIVITE VARCHAR(15) NOT NULL,
- BUDGET VARCHAR(24) NOT NULL,
- DOC_ID VARCHAR(100) NOT NULL,
- ANNEE INTEGER NOT NULL,
- TRIMESTRE INTEGER NOT NULL,
- MINISTERE VARCHAR(6) NOT NULL,
- CPTE_SPE_TRES VARCHAR(6),
- CODE VARCHAR(6) NOT NULL,
- LIBELLE VARCHAR(150),
- INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
- UNIQUE INDEX IX_${base-name}_PK (COLLECTIVITE,BUDGET,ANNEE,TRIMESTRE,MINISTERE,CPTE_SPE_TRES,CODE),
- INITIAL_DOC_NAME VARCHAR(100),
- INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
- ARCHIVE_NAME VARCHAR(100),
- INDEX ${base-name}_AN (ARCHIVE_NAME)
- ) ENGINE MYISAM
- <patch from-version="1">
+ <table base-name="EDMN_ORDOS_DOCUMENTS" type="document" 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), INDEX IX_${base-name}_BC
+ (COLLECTIVITE,BUDGET,DOC_ID), ARCHIVE_NAME VARCHAR(100), INDEX ${base-name}_AN
+ (ARCHIVE_NAME) ) ENGINE MYISAM </table>
+ <table id="O1" base-name="EDMN_ORDOS_INDEX" type="index" version="2" main="true"
+ ignoreConstraintError="true"> CREATE TABLE IF NOT EXISTS ${base-name} (
+ COLLECTIVITE VARCHAR(15) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID
+ VARCHAR(100) NOT NULL, ANNEE INTEGER NOT NULL, TRIMESTRE INTEGER NOT NULL,
+ MINISTERE VARCHAR(6) NOT NULL, CPTE_SPE_TRES VARCHAR(6), CODE VARCHAR(6) NOT
+ NULL, LIBELLE VARCHAR(150), INDEX IX_${base-name}_BC
+ (COLLECTIVITE,BUDGET,DOC_ID), UNIQUE INDEX IX_${base-name}_PK
+ (COLLECTIVITE,BUDGET,ANNEE,TRIMESTRE,MINISTERE,CPTE_SPE_TRES,CODE),
+ INITIAL_DOC_NAME VARCHAR(100), INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
+ ARCHIVE_NAME VARCHAR(100), INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM
+ <patch from-version="1">
<sql failonerror="false">drop table EDMN_ORDOS_INDEX</sql>
- <sql>CREATE TABLE IF NOT EXISTS EDMN_ORDOS_INDEX (
- COLLECTIVITE VARCHAR(15) NOT NULL,
- BUDGET VARCHAR(24) NOT NULL,
- DOC_ID VARCHAR(100) NOT NULL,
- ANNEE INTEGER NOT NULL,
- TRIMESTRE INTEGER NOT NULL,
- MINISTERE VARCHAR(6) NOT NULL,
- CPTE_SPE_TRES VARCHAR(6),
- CODE VARCHAR(6) NOT NULL,
- LIBELLE VARCHAR(150),
- INDEX IX_EDMN_ORDOS_INDEX_BC (COLLECTIVITE,BUDGET,DOC_ID),
- UNIQUE INDEX IX_EDMN_ORDOS_INDEX_PK (COLLECTIVITE,BUDGET,ANNEE,TRIMESTRE,MINISTERE,CPTE_SPE_TRES,CODE),
- INITIAL_DOC_NAME VARCHAR(100),
- INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
- ARCHIVE_NAME VARCHAR(100),
- INDEX ${base-name}_AN (ARCHIVE_NAME)
- ) ENGINE MYISAM</sql>
+ <sql>CREATE TABLE IF NOT EXISTS EDMN_ORDOS_INDEX ( COLLECTIVITE VARCHAR(15)
+ NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
+ ANNEE INTEGER NOT NULL, TRIMESTRE INTEGER NOT NULL, MINISTERE VARCHAR(6)
+ NOT NULL, CPTE_SPE_TRES VARCHAR(6), CODE VARCHAR(6) NOT NULL, LIBELLE
+ VARCHAR(150), INDEX IX_EDMN_ORDOS_INDEX_BC (COLLECTIVITE,BUDGET,DOC_ID),
+ UNIQUE INDEX IX_EDMN_ORDOS_INDEX_PK
+ (COLLECTIVITE,BUDGET,ANNEE,TRIMESTRE,MINISTERE,CPTE_SPE_TRES,CODE),
+ INITIAL_DOC_NAME VARCHAR(100), INDEX ${base-name}_IDN
+ (INITIAL_DOC_NAME), ARCHIVE_NAME VARCHAR(100), INDEX ${base-name}_AN
+ (ARCHIVE_NAME) ) ENGINE MYISAM</sql>
</patch>
-
</table>
<criteria id="ordo.annee" sql-index-id="ordo.annee">
<where-clause>${table}.${column}##OPERATEUR:annee####VALEUR:annee##</where-clause>
<criteria id="ordo.code" sql-index-id="ordo.code">
<where-clause>fn:string-compare(${table}.${column},code)</where-clause>
</criteria>
-
-
-
- <sql-index id="ordo.annee" table="O1" column="ANNEE" path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:Annee/@V" datatype="integer"/>
- <sql-index id="ordo.min" table="O1" column="MINISTERE" path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:CodeMinistere/@V" datatype="string"/>
- <sql-index id="ordo.code" table="O1" column="CODE" path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:CodeOrdo/@V" datatype="string"/>
- <sql-index id="ordo.compte" table="O1" column="CPTE_SPE_TRES" path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:CompteSpeTresor/@V" datatype="string"/>
- <sql-index id="ordo.lib" table="O1" column="LIBELLE" path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:Libelle/@V" datatype="string" format="uppercase"/>
+
+
+
+ <sql-index id="ordo.annee" table="O1" column="ANNEE"
+ path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:Annee/@V"
+ datatype="integer"/>
+ <sql-index id="ordo.min" table="O1" column="MINISTERE"
+ path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:CodeMinistere/@V"
+ datatype="string"/>
+ <sql-index id="ordo.code" table="O1" column="CODE"
+ path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:CodeOrdo/@V"
+ datatype="string"/>
+ <sql-index id="ordo.compte" table="O1" column="CPTE_SPE_TRES"
+ path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:CompteSpeTresor/@V"
+ datatype="string"/>
+ <sql-index id="ordo.lib" table="O1" column="LIBELLE"
+ path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:Libelle/@V"
+ datatype="string" format="uppercase"/>
</etat>
<etat id="comptables" import-xslt-file="edmn/edmn-import-mysql.xsl">
- <table base-name="EDMN_COMPTA_DOCUMENTS" type="document" 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),
- INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
- ARCHIVE_NAME VARCHAR(100),
- INDEX ${base-name}_AN (ARCHIVE_NAME)
- ) ENGINE MYISAM
- </table>
- <table id="C1" base-name="EDMN_COMPTA_INDEX" type="index" version="3" main="true" ignoreConstraintError="true">
- CREATE TABLE IF NOT EXISTS ${base-name} (
- COLLECTIVITE VARCHAR(15) NOT NULL,
- BUDGET VARCHAR(24) NOT NULL,
- DOC_ID VARCHAR(100) NOT NULL,
- ANNEE INTEGER NOT NULL,
- CODE VARCHAR(6) NOT NULL,
- LIBELLE VARCHAR(150),
- UNIQUE INDEX IX_${base-name}_PK (COLLECTIVITE,BUDGET,CODE,ANNEE),
- INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
- INITIAL_DOC_NAME VARCHAR(100),
- INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
- ARCHIVE_NAME VARCHAR(100),
- INDEX ${base-name}_AN (ARCHIVE_NAME)
- ) ENGINE MYISAM
- <patch from-version="1">
+ <table base-name="EDMN_COMPTA_DOCUMENTS" type="document" 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), INDEX
+ IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), ARCHIVE_NAME VARCHAR(100),
+ INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM </table>
+ <table id="C1" base-name="EDMN_COMPTA_INDEX" type="index" version="3" main="true"
+ ignoreConstraintError="true"> CREATE TABLE IF NOT EXISTS ${base-name} (
+ COLLECTIVITE VARCHAR(15) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID
+ VARCHAR(100) NOT NULL, ANNEE INTEGER NOT NULL, CODE VARCHAR(6) NOT NULL, LIBELLE
+ VARCHAR(150), UNIQUE INDEX IX_${base-name}_PK (COLLECTIVITE,BUDGET,CODE,ANNEE),
+ INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INITIAL_DOC_NAME
+ VARCHAR(100), INDEX ${base-name}_IDN (INITIAL_DOC_NAME), ARCHIVE_NAME
+ VARCHAR(100), INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM <patch
+ from-version="1">
<sql failonerror="false">drop table EDMN_COMPTA_INDEX</sql>
- <sql>CREATE TABLE IF NOT EXISTS EDMN_COMPTA_INDEX (
- COLLECTIVITE VARCHAR(15) NOT NULL,
- BUDGET VARCHAR(24) NOT NULL,
- DOC_ID VARCHAR(100) NOT NULL,
- ANNEE INTEGER NOT NULL,
- CODE VARCHAR(6) NOT NULL,
- LIBELLE VARCHAR(150),
+ <sql>CREATE TABLE IF NOT EXISTS EDMN_COMPTA_INDEX ( COLLECTIVITE VARCHAR(15)
+ NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
+ ANNEE INTEGER NOT NULL, CODE VARCHAR(6) NOT NULL, LIBELLE VARCHAR(150),
UNIQUE INDEX IX_EDMN_COMPTA_INDEX_PK (COLLECTIVITE,BUDGET,CODE,ANNEE),
INDEX IX_EDMN_COMPTA_INDEX_BC (COLLECTIVITE,BUDGET,DOC_ID),
- INITIAL_DOC_NAME VARCHAR(100),
- INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
- ARCHIVE_NAME VARCHAR(100),
- INDEX ${base-name}_AN (ARCHIVE_NAME)
- ) ENGINE MYISAM</sql>
+ INITIAL_DOC_NAME VARCHAR(100), INDEX ${base-name}_IDN
+ (INITIAL_DOC_NAME), ARCHIVE_NAME VARCHAR(100), INDEX ${base-name}_AN
+ (ARCHIVE_NAME) ) ENGINE MYISAM</sql>
</patch>
<patch from-version="2">
<sql failonerror="false">drop table EDMN_COMPTA_INDEX</sql>
- <sql>CREATE TABLE IF NOT EXISTS EDMN_COMPTA_INDEX (
- COLLECTIVITE VARCHAR(15) NOT NULL,
- BUDGET VARCHAR(24) NOT NULL,
- DOC_ID VARCHAR(100) NOT NULL,
- ANNEE INTEGER NOT NULL,
- CODE VARCHAR(6) NOT NULL,
- LIBELLE VARCHAR(150),
+ <sql>CREATE TABLE IF NOT EXISTS EDMN_COMPTA_INDEX ( COLLECTIVITE VARCHAR(15)
+ NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
+ ANNEE INTEGER NOT NULL, CODE VARCHAR(6) NOT NULL, LIBELLE VARCHAR(150),
UNIQUE INDEX IX_EDMN_COMPTA_INDEX_PK (COLLECTIVITE,BUDGET,CODE,ANNEE),
INDEX IX_EDMN_COMPTA_INDEX_BC (COLLECTIVITE,BUDGET,DOC_ID),
- INITIAL_DOC_NAME VARCHAR(100),
- INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
- ARCHIVE_NAME VARCHAR(100),
- INDEX ${base-name}_AN (ARCHIVE_NAME)
- ) ENGINE MYISAM</sql>
+ INITIAL_DOC_NAME VARCHAR(100), INDEX ${base-name}_IDN
+ (INITIAL_DOC_NAME), ARCHIVE_NAME VARCHAR(100), INDEX ${base-name}_AN
+ (ARCHIVE_NAME) ) ENGINE MYISAM</sql>
</patch>
-
</table>
<criteria id="compta.annee" sql-index-id="compta.annee">
<where-clause>${table}.${column}##OPERATEUR:annee####VALEUR:annee##</where-clause>
<criteria id="compta.libelle" sql-index-id="compta.lib">
<where-clause>fn:string-compare(${table}.${column},libelle)</where-clause>
</criteria>
-
- <sql-index id="compta.annee" table="C1" column="ANNEE" path="/n:Edmn/n:NomenclatureComptables/n:Comptable/n:Annee/@V" datatype="integer"/>
- <sql-index id="compta.code" table="C1" column="CODE" path="/n:Edmn/n:NomenclatureComptables/n:Comptable/n:Code/@V" datatype="string" format="uppercase"/>
- <sql-index id="compta.lib" table="C1" column="LIBELLE" path="/n:Edmn/n:NomenclatureComptables/n:Comptable/n:Libelle/@V" datatype="string" format="uppercase"/>
+
+ <sql-index id="compta.annee" table="C1" column="ANNEE"
+ path="/n:Edmn/n:NomenclatureComptables/n:Comptable/n:Annee/@V"
+ datatype="integer"/>
+ <sql-index id="compta.code" table="C1" column="CODE"
+ path="/n:Edmn/n:NomenclatureComptables/n:Comptable/n:Code/@V" datatype="string"
+ format="uppercase"/>
+ <sql-index id="compta.lib" table="C1" column="LIBELLE"
+ path="/n:Edmn/n:NomenclatureComptables/n:Comptable/n:Libelle/@V"
+ datatype="string" format="uppercase"/>
+ </etat>
+
+ </document>
+ </layer>
+ <layer name="oracle" persistence-model="xemelios-sql">
+ <document id="edmn" repository-import-xslt-file="">
+ <table base-name="EDMN_SPECIAL_KEYS" 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 ${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"
+ ><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ BUDGET_LIB VARCHAR(1000),
+ INITIAL_DOC_NAME VARCHAR(1000) NOT NULL,
+ COLLECTIVITE_LIB VARCHAR(1000)
+)</sql><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_REPOSITORY" 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="comptables" import-xslt-file="edmn/edmn-import-mysql.xsl">
+ <table base-name="EDMN_COMPTA_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 ${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="EDMN_COMPTA" id="C1" type="index" main="true"
+ ignoreConstraintError="true" 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,
+ ANNEE NUMBER NOT NULL,
+ INITIAL_DOC_NAME VARCHAR(1000),
+ LIBELLE VARCHAR(1000),
+ CODE VARCHAR(1000) NOT NULL
+)</sql><sql>CREATE
+ INDEX ${base-name}_BC ON ${base-name}
+ (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_IDN ON
+ ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON
+ ${base-name} (ARCHIVE_NAME)</sql><sql>CREATE UNIQUE INDEX IX_${base-name}_PK
+ ON ${base-name} (COLLECTIVITE,BUDGET,CODE,ANNEE)</sql></table>
+ <criteria id="compta.annee" sql-index-id="compta.annee">
+ <where-clause>${table}.${column}##OPERATEUR:annee####VALEUR:annee##</where-clause>
+ </criteria>
+ <criteria id="compta.code" sql-index-id="compta.code">
+ <where-clause>fn:string-compare(${table}.${column},code)</where-clause>
+ </criteria>
+ <criteria id="compta.libelle" sql-index-id="compta.lib">
+ <where-clause>fn:string-compare(${table}.${column},libelle)</where-clause>
+ </criteria>
+ <sql-index id="compta.annee"
+ path="/n:Edmn/n:NomenclatureComptables/n:Comptable/n:Annee/@V"
+ datatype="integer" table="C1" column="ANNEE"/>
+ <sql-index id="compta.code"
+ path="/n:Edmn/n:NomenclatureComptables/n:Comptable/n:Code/@V" datatype="string"
+ table="C1" column="CODE" format="uppercase"/>
+ <sql-index id="compta.lib"
+ path="/n:Edmn/n:NomenclatureComptables/n:Comptable/n:Libelle/@V"
+ datatype="string" table="C1" column="LIBELLE" format="uppercase"/>
+ </etat>
+ <etat id="etatEdmn" import-xslt-file="edmn/edmn-import-mysql.xsl">
+ <key1>
+ <path>/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseNationale/n:Liasse/@added:generated-id</path>
+ </key1>
+ <table base-name="EDMN_ETAT" id="T1" type="index" main="true" version="1"
+ ><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ CHORUS_NOM_SOCIETE VARCHAR(1000),
+ CHAP_CLASS VARCHAR(1000),
+ LIB_PROGRAMME VARCHAR(1000),
+ NUM_PIECE_COMPTA VARCHAR(1000),
+ CHORUS_RIB_COMPTE VARCHAR(1000),
+ COMPTABLE VARCHAR(1000),
+ INITIAL_DOC_NAME VARCHAR(1000),
+ ORDO VARCHAR(1000),
+ OPE_INVEST VARCHAR(1000),
+ LIB_MINISTERE VARCHAR(1000),
+ ARCHIVE_NAME VARCHAR(1000),
+ TYPE_PAIEMENT VARCHAR(1000),
+ MT_PJ NUMBER,
+ NUM_LIASSE_DEB VARCHAR(1000),
+ CHORUS_PAYEUR_NOM VARCHAR(1000),
+ CHORUS_WITH_PJ NUMBER,
+ CHORUS_RIB_PAYS VARCHAR(1000),
+ PARAG_BUDG VARCHAR(1000),
+ CODE_OPER_EXC VARCHAR(1000),
+ NUM_LIASSE_FIN VARCHAR(1000),
+ LIB_COMPTABLE VARCHAR(1000),
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ NUM_LIASSE_LOC VARCHAR(1000),
+ NUM_MANDAT VARCHAR(1000),
+ ANNEE_BUDG NUMBER,
+ DOC_ID VARCHAR(1000) NOT NULL,
+ CHORUS_PAYEUR_SIRET VARCHAR(1000),
+ ART_BUDG_PREV VARCHAR(1000),
+ LIB_ORDO VARCHAR(1000),
+ DATE_PAIEMENT DATE,
+ IMPUTATION CHAR(1),
+ ART_BUDG VARCHAR(1000),
+ CHORUS_NUM_EJ_LONG VARCHAR(1000),
+ LIB_ACTION VARCHAR(1000),
+ CHAP_BUDG VARCHAR(1000),
+ CHORUS_FOURNISSEUR_SIRET VARCHAR(1000),
+ MINISTERE VARCHAR(1000),
+ NUM_ENGAG VARCHAR(1000),
+ DATE_CREA DATE,
+ CHORUS_RIB_CLE VARCHAR(1000),
+ CHORUS_RIB_BANC VARCHAR(1000),
+ CHORUS_DOMAINE_FONCTIONNEL VARCHAR(1000),
+ CHORUS_FOURNISSEUR_NOM VARCHAR(1000),
+ TYPE_EVT VARCHAR(1000),
+ TRIMESTRE NUMBER
+)</sql><sql>CREATE
+ INDEX ETATEDMN_ANNEE_BUDG ON ${base-name} (ANNEE_BUDG)</sql><sql>CREATE
+ INDEX ETATEDMN_ART_BUDG ON ${base-name} (ART_BUDG)</sql><sql>CREATE INDEX
+ ETATEDMN_ART_BDG_P ON ${base-name} (ART_BUDG_PREV)</sql><sql>CREATE INDEX
+ ETATEDMN_CHAP_BUDG ON ${base-name} (CHAP_BUDG)</sql><sql>CREATE INDEX
+ ETATEDMN_CHAP_CLASS ON ${base-name} (CHAP_CLASS)</sql><sql>CREATE INDEX
+ ETATEDMN_OPER_EXC ON ${base-name} (CODE_OPER_EXC)</sql><sql>CREATE INDEX
+ ETATEDMN_COMPTA ON ${base-name} (COMPTABLE)</sql><sql>CREATE INDEX
+ ETATEDMN_DATE_CREA ON ${base-name} (DATE_CREA)</sql><sql>CREATE INDEX
+ ETATEDMN_DTE_PAY ON ${base-name} (DATE_PAIEMENT)</sql><sql>CREATE INDEX
+ IMPUTATION ON ${base-name} (IMPUTATION)</sql><sql>CREATE INDEX
+ ETATEDMN_LIB_ACTION ON ${base-name} (LIB_ACTION)</sql><sql>CREATE INDEX
+ LIB_COMPTA ON ${base-name}
+ (COLLECTIVITE,BUDGET,LIB_COMPTABLE)</sql><sql>CREATE INDEX LIB_MINISTERE ON
+ ${base-name} (COLLECTIVITE,BUDGET,LIB_MINISTERE)</sql><sql>CREATE INDEX
+ LIB_ORDO ON ${base-name} (COLLECTIVITE,BUDGET,LIB_ORDO)</sql><sql>CREATE
+ INDEX ETATEDMN_LIB_PROG ON ${base-name} (LIB_PROGRAMME)</sql><sql>CREATE
+ INDEX ETATEDMN_MINISTERE ON ${base-name} (MINISTERE)</sql><sql>CREATE INDEX
+ ETATEDMN_MT_PJ ON ${base-name} (MT_PJ)</sql><sql>CREATE INDEX
+ ETATEDMN_NUM_ENGAG ON ${base-name} (NUM_ENGAG)</sql><sql>CREATE INDEX
+ ETATEDMN_LIASSE_LOC ON ${base-name} (NUM_LIASSE_LOC)</sql><sql>CREATE INDEX
+ ETATEDMN_LIASSE_LOC_DEB ON ${base-name} (NUM_LIASSE_DEB)</sql><sql>CREATE
+ INDEX ETATEDMN_LIASSE_LOC_FIN ON ${base-name}
+ (NUM_LIASSE_FIN)</sql><sql>CREATE INDEX ETATEDMN_PIECE_COMPTA ON
+ ${base-name} (NUM_PIECE_COMPTA)</sql><sql>CREATE INDEX ETATEDMN_ORDO ON
+ ${base-name} (ORDO)</sql><sql>CREATE INDEX ETATEDMN_PARAG_BUDG ON
+ ${base-name} (PARAG_BUDG)</sql><sql>CREATE INDEX ETATEDMN_TRIM ON
+ ${base-name} (TRIMESTRE)</sql><sql>CREATE INDEX ETATEDMN_TYPE_EVT ON
+ ${base-name} (TYPE_EVT)</sql><sql>CREATE INDEX ETATEDMN_TYPE_PAY ON
+ ${base-name} (TYPE_PAIEMENT)</sql><sql>CREATE INDEX CHORUS_NOM_SOCIETE ON
+ ${base-name} (CHORUS_NOM_SOCIETE)</sql><sql>CREATE INDEX
+ CHORUS_FOURNISSEUR_NOM ON ${base-name}
+ (CHORUS_FOURNISSEUR_NOM)</sql><sql>CREATE INDEX CHORUS_FOURNISSEUR_SIRET ON
+ ${base-name} (CHORUS_FOURNISSEUR_SIRET)</sql><sql>CREATE INDEX
+ CHORUS_PAYEUR_NOM ON ${base-name} (CHORUS_PAYEUR_NOM)</sql><sql>CREATE INDEX
+ CHORUS_PAYEUR_SIRET ON ${base-name} (CHORUS_PAYEUR_SIRET)</sql><sql>CREATE
+ INDEX CHORUS_RIB_PAYS ON ${base-name} (CHORUS_RIB_PAYS)</sql><sql>CREATE
+ INDEX CHORUS_RIB_BANC ON ${base-name} (CHORUS_RIB_BANC)</sql><sql>CREATE
+ INDEX CHORUS_RIB_COMPTE ON ${base-name} (CHORUS_RIB_COMPTE)</sql><sql>CREATE
+ INDEX CHORUS_RIB_CLE ON ${base-name} (CHORUS_RIB_CLE)</sql><sql>CREATE INDEX
+ CHORUS_DOMAINE_FONCTIONNEL ON ${base-name}
+ (CHORUS_DOMAINE_FONCTIONNEL)</sql><sql>CREATE INDEX CHORUS_NUM_EJ_LONG ON
+ ${base-name} (CHORUS_NUM_EJ_LONG)</sql><sql>CREATE INDEX CHORUS_WITH_PJ ON
+ ${base-name} (CHORUS_WITH_PJ)</sql><sql>CREATE INDEX ${base-name}_IDN ON
+ ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON
+ ${base-name} (ARCHIVE_NAME)</sql></table>
+ <table base-name="EDMN_ETAT_LIASSES" id="T2" type="index" based-on="key1"
+ 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,
+ NUM_LIASSE VARCHAR(1000) NOT NULL,
+ ANNEE_GESTION NUMBER,
+ INITIAL_DOC_NAME VARCHAR(1000)
+)</sql><sql>CREATE
+ INDEX ${base-name}_BC ON ${base-name}
+ (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_DC ON
+ ${base-name} (DOC_ID)</sql><sql>CREATE INDEX LIASSE_ANNEE_GEST ON
+ ${base-name} (COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql><sql>CREATE INDEX
+ EDMN_LIASSE_CENTRALE ON ${base-name} (NUM_LIASSE)</sql><sql>CREATE INDEX
+ ${base-name}_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX
+ ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql></table>
+ <table base-name="EDMN_ETAT_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,
+ 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></table>
+ <criteria id="comptable" sql-index-id="comptable">
+ <where-clause>fn:string-compare(${table}.${column},comptable)</where-clause>
+ </criteria>
+ <criteria id="lib-comptable" sql-index-id="lib-comptable">
+ <where-clause>fn:string-compare(${table}.${column},libComptable)</where-clause>
+ </criteria>
+ <criteria id="ministere" sql-index-id="ministere">
+ <where-clause>fn:string-compare(${table}.${column},ministere)</where-clause>
+ </criteria>
+ <criteria id="libministere" sql-index-id="lib-ministere">
+ <where-clause>fn:string-compare(${table}.${column},ministereLib)</where-clause>
+ </criteria>
+ <criteria id="ordo" sql-index-id="ordo">
+ <where-clause>fn:string-compare(${table}.${column},ordo)</where-clause>
+ </criteria>
+ <criteria id="lib-ordo" sql-index-id="lib-ordo">
+ <where-clause>fn:string-compare(${table}.${column},libOrdo)</where-clause>
+ </criteria>
+ <criteria id="anneeBudget" sql-index-id="anneeBudget">
+ <where-clause>${table}.${column}##OPERATEUR:annee####VALEUR:annee##</where-clause>
+ </criteria>
+ <criteria id="numMandat" sql-index-id="numMandat">
+ <where-clause>fn:string-compare(${table}.${column},numMandat)</where-clause>
+ </criteria>
+ <criteria id="numOpeInvest" sql-index-id="numOpeInvest">
+ <where-clause>fn:string-compare(${table}.${column},numOpeInvest)</where-clause>
+ </criteria>
+ <criteria id="mtPj" sql-index-id="mtPj">
+ <where-clause>${table}.${column}##OPERATEUR:mtPj####VALEUR:mtPj##</where-clause>
+ </criteria>
+ <criteria id="dateCrea" sql-index-id="dateCrea">
+ <where-clause>fn:date-compare(${table}.${column},dateCrea)</where-clause>
+ </criteria>
+ <criteria id="datePaie" sql-index-id="datePaiement">
+ <where-clause>fn:date-compare(${table}.${column},datePaie)</where-clause>
+ </criteria>
+ <criteria id="typeEvt" sql-index-id="typeEvt">
+ <where-clause>${table}.${column}='##VALEUR:typeEvt##'</where-clause>
+ </criteria>
+ <criteria id="liasseLocale" sql-index-id="numLiasseLocale">
+ <where-clause>fn:string-compare(${table}.${column},numLiasse)</where-clause>
+ </criteria>
+ <criteria id="liasseLocaleDeb" sql-index-id="numLiasseLocaleDeb">
+ <where-clause>fn:string-compare(${table}.${column},numLiasse)</where-clause>
+ </criteria>
+ <criteria id="liasseLocaleFin" sql-index-id="numLiasseLocaleFin">
+ <where-clause>fn:string-compare(${table}.${column},numLiasse)</where-clause>
+ </criteria>
+ <criteria id="liasseCentrale" sql-index-id="numLiasseCentrale">
+ <where-clause>fn:string-compare(${table}.${column},numLiasse)</where-clause>
+ </criteria>
+ <criteria id="programme" sql-index-id="programme">
+ <where-clause>fn:string-compare(${table}.${column},programme)</where-clause>
+ </criteria>
+ <criteria id="action" sql-index-id="action">
+ <where-clause>fn:string-compare(${table}.${column},action)</where-clause>
+ </criteria>
+ <criteria id="cpce" sql-index-id="cpce">
+ <where-clause>fn:string-compare(${table}.${column},cpce)</where-clause>
+ </criteria>
+ <criteria id="artPrev" sql-index-id="artPrev">
+ <where-clause>fn:string-compare(${table}.${column},artPrev)</where-clause>
+ </criteria>
+ <criteria id="libProgramme" sql-index-id="libProgramme">
+ <where-clause>fn:string-compare(${table}.${column},libProgramme)</where-clause>
+ </criteria>
+ <criteria id="libAction" sql-index-id="libAction">
+ <where-clause>fn:string-compare(${table}.${column},libAction)</where-clause>
+ </criteria>
+ <criteria id="codeOperExc" sql-index-id="codOperExc">
+ <where-clause>fn:string-compare(${table}.${column},codeOperExc)</where-clause>
+ </criteria>
+ <criteria id="numPieceCompta" sql-index-id="numPieceCompta">
+ <where-clause>fn:string-compare(${table}.${column},numPieceCompta)</where-clause>
+ </criteria>
+ <criteria id="typePaiement" sql-index-id="typePaiement">
+ <where-clause>fn:string-compare(${table}.${column},typePaiement)</where-clause>
+ </criteria>
+ <criteria id="chapClassPJ" sql-index-id="chapClassPJ">
+ <where-clause>fn:string-compare(${table}.${column},chapClassPJ)</where-clause>
+ </criteria>
+ <criteria id="trimestre" sql-index-id="trimestre">
+ <where-clause>${table}.${column}##OPERATEUR:trimestre####VALEUR:trimestre##</where-clause>
+ </criteria>
+ <criteria id="nom_societe" sql-index-id="chorus_nom_societe">
+ <where-clause>fn:string-compare(${table}.${column},nom_societe)</where-clause>
+ </criteria>
+ <criteria id="fournisseur_nom" sql-index-id="chorus_fournisseur_nom">
+ <where-clause>fn:string-compare(${table}.${column},fournisseur_nom)</where-clause>
+ </criteria>
+ <criteria id="fournisseur_siret" sql-index-id="chorus_fournisseur_siret">
+ <where-clause>fn:string-compare(${table}.${column},fournisseur_siret)</where-clause>
+ </criteria>
+ <criteria id="payeur_nom" sql-index-id="chorus_payeur_nom">
+ <where-clause>fn:string-compare(${table}.${column},payeur_nom)</where-clause>
+ </criteria>
+ <criteria id="payeur_siret" sql-index-id="chorus_payeur_siret">
+ <where-clause>fn:string-compare(${table}.${column},payeur_siret)</where-clause>
+ </criteria>
+ <criteria id="rib_pays" sql-index-id="chorus_rib_pays">
+ <where-clause>fn:string-compare(${table}.${column},rib_pays)</where-clause>
+ </criteria>
+ <criteria id="rib_banc" sql-index-id="chorus_rib_banc">
+ <where-clause>fn:string-compare(${table}.${column},rib_banc)</where-clause>
+ </criteria>
+ <criteria id="rib_compte" sql-index-id="chorus_rib_compte">
+ <where-clause>fn:string-compare(${table}.${column},rib_compte)</where-clause>
+ </criteria>
+ <criteria id="rib_cle" sql-index-id="chorus_rib_cle">
+ <where-clause>fn:string-compare(${table}.${column},rib_cle)</where-clause>
+ </criteria>
+ <criteria id="domaine_fonctionnel" sql-index-id="chorus_domaine_fonctionnel">
+ <where-clause>fn:string-compare(${table}.${column},domaine_fonctionnel)</where-clause>
+ </criteria>
+ <criteria id="num_ej_long" sql-index-id="chorus_num_ej_long">
+ <where-clause>fn:string-compare(${table}.${column},num_ej_long)</where-clause>
+ </criteria>
+ <criteria id="with_pj" sql-index-id="chorus_with_pj">
+ <where-clause>${table}.${column}='##VALEUR:with_pj##'</where-clause>
+ </criteria>
+ <sql-index id="anneeBudget" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:AnneeBudget/@V"
+ datatype="integer" table="T1" column="ANNEE_BUDG"/>
+ <sql-index id="action" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ArtBudgExec/@V"
+ datatype="string" table="T1" column="ART_BUDG" format="uppercase"/>
+ <sql-index id="artPrev" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ArtBudgPrev/@V"
+ datatype="string" table="T1" column="ART_BUDG_PREV" format="uppercase"/>
+ <sql-index id="programme" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ChapBudg/@V"
+ datatype="string" table="T1" column="CHAP_BUDG" format="uppercase"/>
+ <sql-index id="chapClassPJ" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ChapClassPJ/@V"
+ datatype="string" table="T1" column="CHAP_CLASS"/>
+ <sql-index id="codOperExc" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:CodeOperExc/@V"
+ datatype="string" table="T1" column="CODE_OPER_EXC" format="uppercase"/>
+ <sql-index id="comptable" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Comptable/@V"
+ datatype="string" table="T1" column="COMPTABLE" format="uppercase"/>
+ <sql-index id="dateCrea" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:DateCreation/@V"
+ datatype="date" table="T1" column="DATE_CREA" format="yyyy-MM-dd"/>
+ <sql-index id="datePaiement" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:DatePaiement/@V"
+ datatype="date" table="T1" column="DATE_PAIEMENT" format="yyyy-MM-dd"/>
+ <sql-index id="imputation" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Imputation/@V"
+ datatype="string" table="T1" column="IMPUTATION"/>
+ <sql-index id="libAction" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleAction/@V"
+ datatype="string" table="T1" column="LIB_ACTION" format="uppercase"/>
+ <sql-index id="lib-comptable"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleComptable/@V" datatype="string"
+ table="T1" column="LIB_COMPTABLE" format="uppercase"/>
+ <sql-index id="lib-ministere"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Ministere/@LibelleMinistere"
+ datatype="string" table="T1" column="LIB_MINISTERE" format="uppercase"/>
+ <sql-index id="lib-ordo"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleOrdonnateur/@V" datatype="string"
+ table="T1" column="LIB_ORDO" format="uppercase"/>
+ <sql-index id="libProgramme"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:LibelleProgramme/@V" datatype="string"
+ table="T1" column="LIB_PROGRAMME" format="uppercase"/>
+ <sql-index id="ministere" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Ministere/@V"
+ datatype="string" table="T1" column="MINISTERE" format="uppercase"/>
+ <sql-index id="mtPj" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:MtPJ/@V"
+ datatype="decimal" table="T1" column="MT_PJ"/>
+ <sql-index id="numLiasseLocale" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasse/@V"
+ datatype="string" table="T1" column="NUM_LIASSE_LOC" format="uppercase"/>
+ <sql-index id="numLiasseLocaleDeb"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseDeb/@V" datatype="string"
+ table="T1" column="NUM_LIASSE_DEB" format="uppercase"/>
+ <sql-index id="numLiasseLocaleFin"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseFin/@V" datatype="string"
+ table="T1" column="NUM_LIASSE_FIN" format="uppercase"/>
+ <sql-index id="numMandat" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumMandat/@V"
+ datatype="string" table="T1" column="NUM_MANDAT" format="uppercase"/>
+ <sql-index id="ordo" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Ordo/@V"
+ datatype="string" table="T1" column="ORDO" format="uppercase"/>
+ <sql-index id="numOpeInvest" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumOpeInvest/@V"
+ datatype="string" table="T1" column="OPE_INVEST" format="uppercase"/>
+ <sql-index id="cpce" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:ParagBudgExec/@V"
+ datatype="string" table="T1" column="PARAG_BUDG" format="uppercase"/>
+ <sql-index id="trimestre" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Trimestre/@V"
+ datatype="integer" table="T1" column="TRIMESTRE"/>
+ <sql-index id="typeEvt" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:TypeEvt/@V"
+ datatype="string" table="T1" column="TYPE_EVT"/>
+ <sql-index id="typePaiement" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:TypePaiement/@V"
+ datatype="string" table="T1" column="TYPE_PAIEMENT"/>
+ <sql-index id="numPieceCompta"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumPieceCompta/@V" datatype="string"
+ table="T1" column="NUM_PIECE_COMPTA" format="uppercase"/>
+ <sql-index id="chorus_nom_societe"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@NomSociete" datatype="string"
+ table="T1" column="CHORUS_NOM_SOCIETE" format="uppercase"/>
+ <sql-index id="chorus_fournisseur_nom"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@FournisseurNom"
+ datatype="string" table="T1" column="CHORUS_FOURNISSEUR_NOM" format="uppercase"/>
+ <sql-index id="chorus_fournisseur_siret"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@FournisseurSiret"
+ datatype="string" table="T1" column="CHORUS_FOURNISSEUR_SIRET"
+ format="uppercase"/>
+ <sql-index id="chorus_payeur_nom"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@PayeurNom" datatype="string"
+ table="T1" column="CHORUS_PAYEUR_NOM" format="uppercase"/>
+ <sql-index id="chorus_payeur_siret"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@PayeurSiret" datatype="string"
+ table="T1" column="CHORUS_PAYEUR_SIRET" format="uppercase"/>
+ <sql-index id="chorus_rib_pays"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibPays" datatype="string"
+ table="T1" column="CHORUS_RIB_PAYS" format="uppercase"/>
+ <sql-index id="chorus_rib_banc"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibBanc" datatype="string"
+ table="T1" column="CHORUS_RIB_BANC" format="uppercase"/>
+ <sql-index id="chorus_rib_compte"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibCompte" datatype="string"
+ table="T1" column="CHORUS_RIB_COMPTE" format="uppercase"/>
+ <sql-index id="chorus_rib_cle"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@RibCle" datatype="string"
+ table="T1" column="CHORUS_RIB_CLE" format="uppercase"/>
+ <sql-index id="chorus_domaine_fonctionnel"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@DomaineFonctionnel"
+ datatype="string" table="T1" column="CHORUS_DOMAINE_FONCTIONNEL"
+ format="uppercase"/>
+ <sql-index id="chorus_num_ej_long"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:Depense/@NumEJLong" datatype="string"
+ table="T1" column="CHORUS_NUM_EJ_LONG" format="uppercase"/>
+ <sql-index id="chorus_with_pj" path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/@added:withPJ"
+ datatype="integer" table="T1" column="CHORUS_WITH_PJ"/>
+ <sql-index id="numLiasseCentrale"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:NumLiasseNationale/n:Liasse/@national"
+ datatype="string" table="T2" column="NUM_LIASSE" format="uppercase"/>
+ <sql-index id="liasseAnneeGestion"
+ path="/n:Edmn/n:EtatEdmn/n:LigneEdmn/n:AnneeBudget/@V" datatype="integer"
+ table="T2" column="ANNEE_GESTION" use-in-criteria="false"/>
+ </etat>
+ <etat id="ordos" import-xslt-file="edmn/edmn-import-mysql.xsl">
+ <table base-name="EDMN_ORDOS_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 ${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="EDMN_ORDOS_INDEX" id="O1" type="index" main="true"
+ ignoreConstraintError="true" version="1"
+ ><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ BUDGET VARCHAR(1000) NOT NULL,
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ ARCHIVE_NAME VARCHAR(1000),
+ CPTE_SPE_TRES VARCHAR(1000),
+ MINISTERE VARCHAR(1000) NOT NULL,
+ DOC_ID VARCHAR(1000) NOT NULL,
+ ANNEE NUMBER NOT NULL,
+ INITIAL_DOC_NAME VARCHAR(1000),
+ LIBELLE VARCHAR(1000),
+ CODE VARCHAR(1000) NOT NULL,
+ TRIMESTRE NUMBER NOT NULL
+)</sql><sql>CREATE
+ INDEX ${base-name}_BC ON ${base-name}
+ (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_IDN ON
+ ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON
+ ${base-name} (ARCHIVE_NAME)</sql><sql>CREATE UNIQUE INDEX IX_${base-name} ON
+ ${base-name}
+ (COLLECTIVITE,BUDGET,ANNEE,TRIMESTRE,MINISTERE,CPTE_SPE_TRES,CODE)</sql></table>
+ <criteria id="ordo.annee" sql-index-id="ordo.annee">
+ <where-clause>${table}.${column}##OPERATEUR:annee####VALEUR:annee##</where-clause>
+ </criteria>
+ <criteria id="ordo.ministere" sql-index-id="ordo.min">
+ <where-clause>fn:string-compare(${table}.${column},ministere)</where-clause>
+ </criteria>
+ <criteria id="programme" sql-index-id="prog">
+ <where-clause>fn:string-compare(${table}.${column},programme)</where-clause>
+ </criteria>
+ <criteria id="action" sql-index-id="act">
+ <where-clause>fn:string-compare(${table},${column},action)</where-clause>
+ </criteria>
+ <criteria id="artRegroupt" sql-index-id="artRegroupt">
+ <where-clause>fn:string-compare(${table}.${column},artRegroupt)</where-clause>
+ </criteria>
+ <criteria id="ordo.cpte.spe.tres" sql-index-id="ordo.compte">
+ <where-clause>fn:string-compare(${table}.${column},compte)</where-clause>
+ </criteria>
+ <criteria id="ordo.libelle" sql-index-id="ordo.lib">
+ <where-clause>fn:string-compare(${table}.${column},lib)</where-clause>
+ </criteria>
+ <criteria id="ordo.code" sql-index-id="ordo.code">
+ <where-clause>fn:string-compare(${table}.${column},code)</where-clause>
+ </criteria>
+ <sql-index id="ordo.annee"
+ path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:Annee/@V"
+ datatype="integer" table="O1" column="ANNEE"/>
+ <sql-index id="ordo.min"
+ path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:CodeMinistere/@V"
+ datatype="string" table="O1" column="MINISTERE"/>
+ <sql-index id="ordo.code"
+ path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:CodeOrdo/@V"
+ datatype="string" table="O1" column="CODE"/>
+ <sql-index id="ordo.compte"
+ path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:CompteSpeTresor/@V"
+ datatype="string" table="O1" column="CPTE_SPE_TRES"/>
+ <sql-index id="ordo.lib"
+ path="/n:Edmn/n:NomenclatureOrdonnateurs/n:Ordonnateur/n:Libelle/@V"
+ datatype="string" table="O1" column="LIBELLE" format="uppercase"/>
+ </etat>
+ <etat id="budgets" import-xslt-file="edmn/edmn-import-mysql.xsl">
+ <table base-name="EDMN_BUDG_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 ${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="EDMN_BUDG" id="B1" type="index" main="true"
+ ignoreConstraintError="true" version="1"
+ ><sql xml:space="preserve">CREATE TABLE ${base-name} (
+ COLLECTIVITE VARCHAR(1000) NOT NULL,
+ BUDGET VARCHAR(1000) NOT NULL,
+ CPCE VARCHAR(1000),
+ DOC_ID VARCHAR(1000) NOT NULL,
+ ANNEE NUMBER NOT NULL,
+ PROGRAMME VARCHAR(1000),
+ INITIAL_DOC_NAME VARCHAR(1000),
+ ARCHIVE_NAME VARCHAR(1000),
+ MINISTERE VARCHAR(1000) NOT NULL,
+ ART_REGROUP VARCHAR(1000),
+ DATA VARCHAR(1000) NOT NULL,
+ ACTION VARCHAR(1000),
+ LIBELLE VARCHAR(1000)
+)</sql><sql>CREATE
+ INDEX ${base-name}_BC ON ${base-name}
+ (COLLECTIVITE,BUDGET,DOC_ID)</sql><sql>CREATE INDEX ${base-name}_IDN ON
+ ${base-name} (INITIAL_DOC_NAME)</sql><sql>CREATE INDEX ${base-name}_AN ON
+ ${base-name} (ARCHIVE_NAME)</sql><sql>CREATE UNIQUE INDEX IX_${base-name}_PK
+ ON ${base-name}
+ (COLLECTIVITE,BUDGET,ANNEE,DATA,MINISTERE,PROGRAMME,ACTION,ART_REGROUP)</sql></table>
+ <criteria id="typeData" sql-index-id="typeData">
+ <where-clause>${table}.${column}='##VALEUR:data##'</where-clause>
+ </criteria>
+ <criteria id="annee" sql-index-id="annee">
+ <where-clause>${table}.${column}##OPERATEUR:annee####VALEUR:annee##</where-clause>
+ </criteria>
+ <criteria id="ministere" sql-index-id="min">
+ <where-clause>fn:string-compare(${table}.${column},ministere)</where-clause>
+ </criteria>
+ <criteria id="programme" sql-index-id="prog">
+ <where-clause>fn:string-compare(${table}.${column},programme)</where-clause>
+ </criteria>
+ <criteria id="action" sql-index-id="act">
+ <where-clause>fn:string-compare(${table}.${column},action)</where-clause>
+ </criteria>
+ <criteria id="artRegroupt" sql-index-id="artRegroupt">
+ <where-clause>fn:string-compare(${table}.${column},artRegroupt)</where-clause>
+ </criteria>
+ <criteria id="cpce" sql-index-id="cpce2">
+ <where-clause>fn:string-compare(${table}.${column},cpce)</where-clause>
+ </criteria>
+ <criteria id="libBudget" sql-index-id="budg.lib">
+ <where-clause>fn:string-compare(${table}.${column},libBudg)</where-clause>
+ </criteria>
+ <sql-index id="typeData" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Data/@V"
+ datatype="string" table="B1" column="DATA"/>
+ <sql-index id="annee" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Annee/@V"
+ datatype="integer" table="B1" column="ANNEE"/>
+ <sql-index id="min" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Ministere/@V"
+ datatype="string" table="B1" column="MINISTERE"/>
+ <sql-index id="prog" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Programme/@V"
+ datatype="string" table="B1" column="PROGRAMME"/>
+ <sql-index id="act" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Action/@V"
+ datatype="string" table="B1" column="ACTION"/>
+ <sql-index id="artRegroupt"
+ path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:ArticleRegroupt/@V"
+ datatype="string" table="B1" column="ART_REGROUP" format="uppercase"/>
+ <sql-index id="cpce2" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Cpce/@V"
+ datatype="string" table="B1" column="CPCE" format="uppercase"/>
+ <sql-index id="budg.lib" path="/n:Edmn/n:NomenclatureBudgets/n:Budget/n:Libelle/@V"
+ datatype="string" table="B1" column="LIBELLE"/>
</etat>
-
</document>
</layer>
</persistence-config>