DOC LONGBLOB, ENCODING VARCHAR(20),
ANNEE_GESTION INTEGER,
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
- INDEX IX_EDMN_DOC_ANNEE_GESTION(COLLECTIVITE,BUDGET,ANNEE_GESTION),
+ INDEX IX_EDMN2012_DOC_ANNEE_GESTION(COLLECTIVITE,BUDGET,ANNEE_GESTION),
ARCHIVE_NAME VARCHAR(100), INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM
</table>
+
<table type="index" id="T1" base-name="EDMN_2012_ETATEDMN_IX" version="2" main="true">
CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
<sql failonerror="false">ALTER TABLE ${base-name} ADD IMPUTATION VARCHAR(1)</sql>
</patch>
</table>
- <table id="T2" base-name="EDMN_2012_LIASSES_IX" type="index" version="2" based-on="key1">
+
+ <table id="T2" base-name="EDMN_2012_LIASSES_IX" type="index" version="3" based-on="key1">
CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
BUDGET VARCHAR(24) NOT NULL,
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
INDEX IX_${base-name}_DC (DOC_ID),
INDEX ${base-name}_NODEID (NODEID),
- INDEX IX_EDMN_ETATEDMN_LIASSES_ANGEST (COLLECTIVITE,BUDGET,ANNEE_GESTION),
- INDEX IX_EDMN_ETATEDMN_LIASSES_LIASSE_CENTRALE (NUM_LIASSE),
+ INDEX IX_${base-name}_ANGEST (COLLECTIVITE,BUDGET,ANNEE_GESTION),
+ INDEX IX_${base-name}_LIASSES_LIASSE_CENTRALE (NUM_LIASSE),
INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM
<patch from-version="1">
<sql failonerror="false">ALTER TABLE ${base-name} ADD NODEID VARCHAR(10)</sql>
- </patch>
+ </patch>
+ <patch from-version="2">
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD NODEID VARCHAR(10)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} DROP INDEX IX_EDMN_ETATEDMN_LIASSES_ANGEST</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} DROP INDEX IX_EDMN_ETATEDMN_LIASSES_LIASSE_CENTRALE</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD INDEX IX_${base-name}_ANGEST (COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql>
+ <sql failonerror="false">ALTER TABLE ${base-name} ADD INDEX IX_${base-name}_LIASSE_CENTRALE (NUM_LIASSE)</sql>
+ </patch>
</table>
+
<table id="T3" base-name="EDMN_2012_PJ_IX" type="index" version="2" based-on="key2">
CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
</layer>
<layer name="oracle" persistence-model="xemelios-sql">
+
<document id="edmn2012" repository-import-xslt-file="">
+
<table base-name="EDMN_2012_SPECIAL_KEYS" type="special-key" version="1">
<sql xml:space="preserve">
CREATE TABLE ${base-name} (
<sql>CREATE INDEX ${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET)</sql>
<sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql>
</table>
- <table base-name="EDMN_LIST_BUDG_COLL" type="list-bc" version="1">
+
+ <table base-name="EDMN_2012_LIST_BUDG_COLL" type="list-bc" version="1">
<sql xml:space="preserve">
CREATE TABLE ${base-name} (
BUDGET VARCHAR(1000) NOT NULL,
ANNEE_GESTION NUMBER,
INITIAL_DOC_NAME VARCHAR(1000) NOT NULL )
</sql>
- <sql>CREATE INDEX ${base-name}_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
- <sql>CREATE INDEX EDMN_DOC_ANNEE_GESTION ON ${base-name} (COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql>
- <sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql>
+ <sql>CREATE INDEX EDMN2012_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
+ <sql>CREATE INDEX EDMN2012_DOC_AG ON ${base-name} (COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql>
+ <sql>CREATE INDEX EDMN2012_AN ON ${base-name} (ARCHIVE_NAME)</sql>
</table>
<table base-name="EDMN_2012_ETAT" id="T1" type="index" main="true" version="2">
<sql xml:space="preserve">
TRIMESTRE NUMBER,
IMPUTATION VARCHAR(1) )
</sql>
- <sql>CREATE INDEX ETATEDMN_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
- <sql>CREATE INDEX ETATEDMN_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql>
- <sql>CREATE INDEX ETATEDMN_AN ON ${base-name} (ARCHIVE_NAME)</sql>
- <sql>CREATE INDEX ETATEDMN_NODEID ON ${base-name} (NODEID)</sql>
- <sql>CREATE INDEX ETATEDMN_CODEEVT ON ${base-name} (CODEEVT)</sql>
- <sql>CREATE INDEX ETATEDMN_TYPEPCE ON ${base-name} (TYPEPCE)</sql>
- <sql>CREATE INDEX ETATEDMN_DESIGNTYPE ON ${base-name} (DESIGNTYPE)</sql>
- <sql>CREATE INDEX ETATEDMN_SOCIETE ON ${base-name} (SOCIETE)</sql>
- <sql>CREATE INDEX ETATEDMN_NOMSOC ON ${base-name} (NOMSOCIETE)</sql>
- <sql>CREATE INDEX ETATEDMN_NUMPCEFI ON ${base-name} (NUMPIECEFI)</sql>
- <sql>CREATE INDEX ETATEDMN_POSTE ON ${base-name} (POSTE)</sql>
- <sql>CREATE INDEX ETATEDMN_EXECOMPTA ON ${base-name} (EXERCICECOMPTA)</sql>
- <sql>CREATE INDEX ETATEDMN_REFFIN ON ${base-name} (REFERENCEFINANCIERE)</sql>
- <sql>CREATE INDEX ETATEDMN_TXTENTFIN ON ${base-name} (TXTENTETEFINANCIER)</sql>
- <sql>CREATE INDEX ETATEDMN_TXTFIN ON ${base-name} (TEXTEFINANCIER)</sql>
- <sql>CREATE INDEX ETATEDMN_MINBUDG ON ${base-name} (MINISTEREBUDGETAIRE)</sql>
- <sql>CREATE INDEX ETATEDMN_MINBUDGDES ON ${base-name} (MINISTEREBUDGETAIREDESIGN)</sql>
- <sql>CREATE INDEX ETATEDMN_DOMACT ON ${base-name} (DOMAINEACTIVITE)</sql>
- <sql>CREATE INDEX ETATEDMN_FOURNUM ON ${base-name} (FOURNISSEURNUM)</sql>
- <sql>CREATE INDEX ETATEDMN_FOURNOM ON ${base-name} (FOURNISSEURNOM)</sql>
- <sql>CREATE INDEX ETATEDMN_FOURSIRET ON ${base-name} (FOURNISSEURSIRET)</sql>
- <sql>CREATE INDEX ETATEDMN_BENEFNUM ON ${base-name} (BENEFICIAIRENUM)</sql>
- <sql>CREATE INDEX ETATEDMN_BENEFNOM ON ${base-name} (BENEFICIAIRENOM)</sql>
- <sql>CREATE INDEX ETATEDMN_BENEFSIRET ON ${base-name} (BENEFICIAIRESIRET)</sql>
- <sql>CREATE INDEX ETATEDMN_RIBPAYS ON ${base-name} (RIBPAYS)</sql>
- <sql>CREATE INDEX ETATEDMN_RIBBANC ON ${base-name} (RIBBANC)</sql>
- <sql>CREATE INDEX ETATEDMN_RIBCOMPTE ON ${base-name} (RIBCOMPTE)</sql>
- <sql>CREATE INDEX ETATEDMN_RIBCLE ON ${base-name} (RIBCLE)</sql>
- <sql>CREATE INDEX ETATEDMN_CPTEPCE ON ${base-name} (COMPTEPCE)</sql>
- <sql>CREATE INDEX ETATEDMN_LIBPCE ON ${base-name} (LIBELLEPCE)</sql>
- <sql>CREATE INDEX ETATEDMN_DEBCRED ON ${base-name} (DEBITCREDITPCE)</sql>
- <sql>CREATE INDEX ETATEDMN_CPTEBUDG ON ${base-name} (COMPTEBUDG)</sql>
- <sql>CREATE INDEX ETATEDMN_DTECOMPTA ON ${base-name} (DATECOMPTABLE)</sql>
- <sql>CREATE INDEX ETATEDMN_DTEPAIE ON ${base-name} (DATEPAIEMENT)</sql>
- <sql>CREATE INDEX ETATEDMN_MT ON ${base-name} (MTPCE)</sql>
- <sql>CREATE INDEX ETATEDMN_DOMFONC ON ${base-name} (DOMAINEFONCTIONNEL)</sql>
- <sql>CREATE INDEX ETATEDMN_CENTFIN ON ${base-name} (CENTREFINANCIER)</sql>
- <sql>CREATE INDEX ETATEDMN_DESIGNFIN ON ${base-name} (DESIGNATIONFINANCIER)</sql>
- <sql>CREATE INDEX ETATEDMN_CENTCOUT ON ${base-name} (CENTRECOUT)</sql>
- <sql>CREATE INDEX ETATEDMN_CENTCOUTDES ON ${base-name} (CENTRECOUTDESIGN)</sql>
- <sql>CREATE INDEX ETATEDMN_TYPEJ ON ${base-name} (TYPEEJ)</sql>
- <sql>CREATE INDEX ETATEDMN_TYPEJDES ON ${base-name} (TYPEEJDESIGN)</sql>
- <sql>CREATE INDEX ETATEDMN_NUMEJ ON ${base-name} (NUMEJ)</sql>
- <sql>CREATE INDEX ETATEDMN_NUMEJLONG ON ${base-name} (NUMEJLONG)</sql>
- <sql>CREATE INDEX ETATEDMN_DTEEJ ON ${base-name} (DATEEJ)</sql>
- <sql>CREATE INDEX ETATEDMN_TYPECR ON ${base-name} (TYPEECRITURE)</sql>
- <sql>CREATE INDEX ETATEDMN_PERFIN ON ${base-name} (PERIMFINANCIER)</sql>
- <sql>CREATE INDEX ETATEDMN_SEREXEC ON ${base-name} (SERVEXEC)</sql>
- <sql>CREATE INDEX ETATEDMN_PJ ON ${base-name} (PJ)</sql>
- <sql>CREATE INDEX ETATEDMN_ESPCE ON ${base-name} (ESPACEMENT)</sql>
- <sql>CREATE INDEX ETATEDMN_COMPT ON ${base-name} (COMPTABLE)</sql>
- <sql>CREATE INDEX ETATEDMN_LIBCOMPT ON ${base-name} (LIBELLECOMPTABLE)</sql>
- <sql>CREATE INDEX ETATEDMN_NUMLIASSEDEB ON ${base-name} (NUMLIASSEDEB)</sql>
- <sql>CREATE INDEX ETATEDMN_NUMLIASSEFIN ON ${base-name} (NUMLIASSEFIN)</sql>
- <sql>CREATE INDEX ETATEDMN_ANNEE ON ${base-name} (ANNEE)</sql>
- <sql>CREATE INDEX ETATEDMN_MOIS ON ${base-name} (MOIS)</sql>
- <sql>CREATE INDEX ETATEDMN_TRIM ON ${base-name} (TRIMESTRE)</sql>
- <sql>CREATE INDEX ETATEDMN_IMP ON ${base-name} (IMPUTATION)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_AN ON ${base-name} (ARCHIVE_NAME)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_NODEID ON ${base-name} (NODEID)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_CODEEVT ON ${base-name} (CODEEVT)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_TYPEPCE ON ${base-name} (TYPEPCE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DESIGNTYPE ON ${base-name} (DESIGNTYPE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_SOCIETE ON ${base-name} (SOCIETE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_NOMSOC ON ${base-name} (NOMSOCIETE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_NUMPCEFI ON ${base-name} (NUMPIECEFI)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_POSTE ON ${base-name} (POSTE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_EXECOMPTA ON ${base-name} (EXERCICECOMPTA)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_REFFIN ON ${base-name} (REFERENCEFINANCIERE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_TXTENTFIN ON ${base-name} (TXTENTETEFINANCIER)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_TXTFIN ON ${base-name} (TEXTEFINANCIER)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_MINBUDG ON ${base-name} (MINISTEREBUDGETAIRE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_MINBUDGDES ON ${base-name} (MINISTEREBUDGETAIREDESIGN)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DOMACT ON ${base-name} (DOMAINEACTIVITE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_FOURNUM ON ${base-name} (FOURNISSEURNUM)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_FOURNOM ON ${base-name} (FOURNISSEURNOM)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_FOURSIRET ON ${base-name} (FOURNISSEURSIRET)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_BENEFNUM ON ${base-name} (BENEFICIAIRENUM)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_BENEFNOM ON ${base-name} (BENEFICIAIRENOM)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_BENEFSIRET ON ${base-name} (BENEFICIAIRESIRET)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_RIBPAYS ON ${base-name} (RIBPAYS)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_RIBBANC ON ${base-name} (RIBBANC)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_RIBCOMPTE ON ${base-name} (RIBCOMPTE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_RIBCLE ON ${base-name} (RIBCLE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_CPTEPCE ON ${base-name} (COMPTEPCE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_LIBPCE ON ${base-name} (LIBELLEPCE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DEBCRED ON ${base-name} (DEBITCREDITPCE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_CPTEBUDG ON ${base-name} (COMPTEBUDG)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DTECOMPTA ON ${base-name} (DATECOMPTABLE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DTEPAIE ON ${base-name} (DATEPAIEMENT)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_MT ON ${base-name} (MTPCE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DOMFONC ON ${base-name} (DOMAINEFONCTIONNEL)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_CENTFIN ON ${base-name} (CENTREFINANCIER)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DESIGNFIN ON ${base-name} (DESIGNATIONFINANCIER)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_CENTCOUT ON ${base-name} (CENTRECOUT)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_CENTCOUTDES ON ${base-name} (CENTRECOUTDESIGN)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_TYPEJ ON ${base-name} (TYPEEJ)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_TYPEJDES ON ${base-name} (TYPEEJDESIGN)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_NUMEJ ON ${base-name} (NUMEJ)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_NUMEJLONG ON ${base-name} (NUMEJLONG)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_DTEEJ ON ${base-name} (DATEEJ)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_TYPECR ON ${base-name} (TYPEECRITURE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_PERFIN ON ${base-name} (PERIMFINANCIER)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_SEREXEC ON ${base-name} (SERVEXEC)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_PJ ON ${base-name} (PJ)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_ESPCE ON ${base-name} (ESPACEMENT)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_COMPT ON ${base-name} (COMPTABLE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_LIBCOMPT ON ${base-name} (LIBELLECOMPTABLE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_NUMLIASSEDEB ON ${base-name} (NUMLIASSEDEB)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_NUMLIASSEFIN ON ${base-name} (NUMLIASSEFIN)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_ANNEE ON ${base-name} (ANNEE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_MOIS ON ${base-name} (MOIS)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_TRIM ON ${base-name} (TRIMESTRE)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_IMP ON ${base-name} (IMPUTATION)</sql>
<patch from-version="1">
<sql>ALTER TABLE ${base-name} ADD IMPUTATION VARCHAR(1)</sql>
- <sql>CREATE INDEX ETATEDMN_IMP ON ${base-name} (IMPUTATION)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_IMP ON ${base-name} (IMPUTATION)</sql>
</patch>
</table>
<table base-name="EDMN_2012_ETAT_LIASSES" id="T2" type="index" based-on="key1" version="1">
<sql>CREATE INDEX ETATEDMN2012_LIASSE_BC ON ${base-name} (COLLECTIVITE,BUDGET,DOC_ID)</sql>
<sql>CREATE INDEX ETATEDMN2012_LIASSE_DC ON ${base-name} (DOC_ID)</sql>
<sql>CREATE INDEX ETATEDMN2012_LIASSE_NODEID ON ${base-name} (NODEID)</sql>
- <sql>CREATE INDEX LIASSE_ANNEE_GEST ON ${base-name} (COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql>
+ <sql>CREATE INDEX ETATEDMN2012_LIASSE_AG ON ${base-name} (COLLECTIVITE,BUDGET,ANNEE_GESTION)</sql>
<sql>CREATE INDEX ETATEDMN2012_LIASSE_CENTRALE ON ${base-name} (NUM_LIASSE)</sql>
<sql>CREATE INDEX ETATEDMN2012_LIASSE_IDN ON ${base-name} (INITIAL_DOC_NAME)</sql>
<sql>CREATE INDEX ETATEDMN2012_LIASSE_AN ON ${base-name} (ARCHIVE_NAME)</sql>