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"
+ <table id="O1" base-name="EDMN_ORDOS_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, TRIMESTRE INTEGER NOT NULL,
+ VARCHAR(100) NOT NULL, ANNEE 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
<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)
+ ANNEE 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
(INITIAL_DOC_NAME), ARCHIVE_NAME VARCHAR(100), INDEX ${base-name}_AN
(ARCHIVE_NAME) ) ENGINE MYISAM</sql>
</patch>
+ <patch from-version="2">
+ <sql failonerror="false">ALTER TABLE ${base-name} DROP COLUMN TRIMESTRE</sql>
+ </patch>
</table>
<criteria id="ordo.annee" sql-index-id="ordo.annee">
<where-clause>${table}.${column}##OPERATEUR:annee####VALEUR:annee##</where-clause>
<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">
+ ignoreConstraintError="true" version="2">
<sql xml:space="preserve">CREATE TABLE ${base-name} (
BUDGET VARCHAR(1000) NOT NULL,
COLLECTIVITE 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
+ 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} ON ${base-name} (COLLECTIVITE,BUDGET,ANNEE,TRIMESTRE,MINISTERE,CPTE_SPE_TRES,CODE)</sql>
+ <patch from-version="1">
+ <sql>ALTER TABLE ${base-name} DROP COLUMN TRIMESTRE</sql>
+ </patch>
</table>
<criteria id="ordo.annee" sql-index-id="ordo.annee">
<where-clause>${table}.${column}##OPERATEUR:annee####VALEUR:annee##</where-clause>