/*--------- EDMN 2012 -------------*/
+CREATE TABLE EDMN_2012_LIST_BUDG_COLL (
+ 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)
+);
+
+CREATE INDEX EDMN_2012_LIST_BUDG_COLL_BC ON EDMN_2012_LIST_BUDG_COLL (COLLECTIVITE,BUDGET);
+CREATE INDEX EDMN_2012_LIST_BUDG_COLL_AN ON EDMN_2012_LIST_BUDG_COLL (ARCHIVE_NAME);
+
+
CREATE TABLE EDMN_2012_SPECIAL_KEYS (
BUDGET VARCHAR(1000) NOT NULL,
ANNEE_GESTION NUMBER,
INITIAL_DOC_NAME VARCHAR(1000) NOT NULL );
-CREATE INDEX EDMN_2012_ETAT_DOCS_BC ON EDMN_2012_ETAT_DOCS (COLLECTIVITE,BUDGET,DOC_ID);
-CREATE INDEX EDMN_DOC_ANNEE_GESTION ON EDMN_2012_ETAT_DOCS (COLLECTIVITE,BUDGET,ANNEE_GESTION);
-CREATE INDEX EDMN_2012_ETAT_DOCS_AN ON EDMN_2012_ETAT_DOCS (ARCHIVE_NAME);
+CREATE INDEX EDMN2012_BC ON EDMN_2012_ETAT_DOCS (COLLECTIVITE,BUDGET,DOC_ID);
+CREATE INDEX EDMN2012_DOC_AG ON EDMN_2012_ETAT_DOCS (COLLECTIVITE,BUDGET,ANNEE_GESTION);
+CREATE INDEX EDMN2012_AN ON EDMN_2012_ETAT_DOCS (ARCHIVE_NAME);
IMPUTATION VARCHAR(1)
);
-CREATE INDEX ETATEDMN_BC ON EDMN_2012_ETAT (COLLECTIVITE,BUDGET,DOC_ID);
-CREATE INDEX ETATEDMN_IDN ON EDMN_2012_ETAT (INITIAL_DOC_NAME);
-CREATE INDEX ETATEDMN_AN ON EDMN_2012_ETAT (ARCHIVE_NAME);
-CREATE INDEX ETATEDMN_NODEID ON EDMN_2012_ETAT (NODEID);
-CREATE INDEX ETATEDMN_CODEEVT ON EDMN_2012_ETAT (CODEEVT);
-CREATE INDEX ETATEDMN_TYPEPCE ON EDMN_2012_ETAT (TYPEPCE);
-CREATE INDEX ETATEDMN_DESIGNTYPE ON EDMN_2012_ETAT (DESIGNTYPE);
-CREATE INDEX ETATEDMN_SOCIETE ON EDMN_2012_ETAT (SOCIETE);
-CREATE INDEX ETATEDMN_NOMSOC ON EDMN_2012_ETAT (NOMSOCIETE);
-CREATE INDEX ETATEDMN_NUMPCEFI ON EDMN_2012_ETAT (NUMPIECEFI);
-CREATE INDEX ETATEDMN_POSTE ON EDMN_2012_ETAT (POSTE);
-CREATE INDEX ETATEDMN_EXECOMPTA ON EDMN_2012_ETAT (EXERCICECOMPTA);
-CREATE INDEX ETATEDMN_REFFIN ON EDMN_2012_ETAT (REFERENCEFINANCIERE);
-CREATE INDEX ETATEDMN_TXTENTFIN ON EDMN_2012_ETAT (TXTENTETEFINANCIER);
-CREATE INDEX ETATEDMN_TXTFIN ON EDMN_2012_ETAT (TEXTEFINANCIER);
-CREATE INDEX ETATEDMN_MINBUDG ON EDMN_2012_ETAT (MINISTEREBUDGETAIRE);
-CREATE INDEX ETATEDMN_MINBUDGDES ON EDMN_2012_ETAT (MINISTEREBUDGETAIREDESIGN);
-CREATE INDEX ETATEDMN_DOMACT ON EDMN_2012_ETAT (DOMAINEACTIVITE);
-CREATE INDEX ETATEDMN_FOURNUM ON EDMN_2012_ETAT (FOURNISSEURNUM);
-CREATE INDEX ETATEDMN_FOURNOM ON EDMN_2012_ETAT (FOURNISSEURNOM);
-CREATE INDEX ETATEDMN_FOURSIRET ON EDMN_2012_ETAT (FOURNISSEURSIRET);
-CREATE INDEX ETATEDMN_BENEFNUM ON EDMN_2012_ETAT (BENEFICIAIRENUM);
-CREATE INDEX ETATEDMN_BENEFNOM ON EDMN_2012_ETAT (BENEFICIAIRENOM);
-CREATE INDEX ETATEDMN_BENEFSIRET ON EDMN_2012_ETAT (BENEFICIAIRESIRET);
-CREATE INDEX ETATEDMN_RIBPAYS ON EDMN_2012_ETAT (RIBPAYS);
-CREATE INDEX ETATEDMN_RIBBANC ON EDMN_2012_ETAT (RIBBANC);
-CREATE INDEX ETATEDMN_RIBCOMPTE ON EDMN_2012_ETAT (RIBCOMPTE);
-CREATE INDEX ETATEDMN_RIBCLE ON EDMN_2012_ETAT (RIBCLE);
-CREATE INDEX ETATEDMN_CPTEPCE ON EDMN_2012_ETAT (COMPTEPCE);
-CREATE INDEX ETATEDMN_LIBPCE ON EDMN_2012_ETAT (LIBELLEPCE);
-CREATE INDEX ETATEDMN_DEBCRED ON EDMN_2012_ETAT (DEBITCREDITPCE);
-CREATE INDEX ETATEDMN_CPTEBUDG ON EDMN_2012_ETAT (COMPTEBUDG);
-CREATE INDEX ETATEDMN_DTECOMPTA ON EDMN_2012_ETAT (DATECOMPTABLE);
-CREATE INDEX ETATEDMN_DTEPAIE ON EDMN_2012_ETAT (DATEPAIEMENT);
-CREATE INDEX ETATEDMN_MT ON EDMN_2012_ETAT (MTPCE);
-CREATE INDEX ETATEDMN_DOMFONC ON EDMN_2012_ETAT (DOMAINEFONCTIONNEL);
-CREATE INDEX ETATEDMN_CENTFIN ON EDMN_2012_ETAT (CENTREFINANCIER);
-CREATE INDEX ETATEDMN_DESIGNFIN ON EDMN_2012_ETAT (DESIGNATIONFINANCIER);
-CREATE INDEX ETATEDMN_CENTCOUT ON EDMN_2012_ETAT (CENTRECOUT);
-CREATE INDEX ETATEDMN_CENTCOUTDES ON EDMN_2012_ETAT (CENTRECOUTDESIGN);
-CREATE INDEX ETATEDMN_TYPEJ ON EDMN_2012_ETAT (TYPEEJ);
-CREATE INDEX ETATEDMN_TYPEJDES ON EDMN_2012_ETAT (TYPEEJDESIGN);
-CREATE INDEX ETATEDMN_NUMEJ ON EDMN_2012_ETAT (NUMEJ);
-CREATE INDEX ETATEDMN_NUMEJLONG ON EDMN_2012_ETAT (NUMEJLONG);
-CREATE INDEX ETATEDMN_DTEEJ ON EDMN_2012_ETAT (DATEEJ);
-CREATE INDEX ETATEDMN_TYPECR ON EDMN_2012_ETAT (TYPEECRITURE);
-CREATE INDEX ETATEDMN_PERFIN ON EDMN_2012_ETAT (PERIMFINANCIER);
-CREATE INDEX ETATEDMN_SEREXEC ON EDMN_2012_ETAT (SERVEXEC);
-CREATE INDEX ETATEDMN_PJ ON EDMN_2012_ETAT (PJ);
-CREATE INDEX ETATEDMN_ESPCE ON EDMN_2012_ETAT (ESPACEMENT);
-CREATE INDEX ETATEDMN_COMPT ON EDMN_2012_ETAT (COMPTABLE);
-CREATE INDEX ETATEDMN_LIBCOMPT ON EDMN_2012_ETAT (LIBELLECOMPTABLE);
-CREATE INDEX ETATEDMN_NUMLIASSEDEB ON EDMN_2012_ETAT (NUMLIASSEDEB);
-CREATE INDEX ETATEDMN_NUMLIASSEFIN ON EDMN_2012_ETAT (NUMLIASSEFIN);
-CREATE INDEX ETATEDMN_ANNEE ON EDMN_2012_ETAT (ANNEE);
-CREATE INDEX ETATEDMN_MOIS ON EDMN_2012_ETAT (MOIS);
-CREATE INDEX ETATEDMN_TRIM ON EDMN_2012_ETAT (TRIMESTRE);
-CREATE INDEX ETATEDMN_IMP ON EDMN_2012_ETAT (IMPUTATION);
+CREATE INDEX ETATEDMN2012_BC ON EDMN_2012_ETAT (COLLECTIVITE,BUDGET,DOC_ID);
+CREATE INDEX ETATEDMN2012_IDN ON EDMN_2012_ETAT (INITIAL_DOC_NAME);
+CREATE INDEX ETATEDMN2012_AN ON EDMN_2012_ETAT (ARCHIVE_NAME);
+CREATE INDEX ETATEDMN2012_NODEID ON EDMN_2012_ETAT (NODEID);
+CREATE INDEX ETATEDMN2012_CODEEVT ON EDMN_2012_ETAT (CODEEVT);
+CREATE INDEX ETATEDMN2012_TYPEPCE ON EDMN_2012_ETAT (TYPEPCE);
+CREATE INDEX ETATEDMN2012_DESIGNTYPE ON EDMN_2012_ETAT (DESIGNTYPE);
+CREATE INDEX ETATEDMN2012_SOCIETE ON EDMN_2012_ETAT (SOCIETE);
+CREATE INDEX ETATEDMN2012_NOMSOC ON EDMN_2012_ETAT (NOMSOCIETE);
+CREATE INDEX ETATEDMN2012_NUMPCEFI ON EDMN_2012_ETAT (NUMPIECEFI);
+CREATE INDEX ETATEDMN2012_POSTE ON EDMN_2012_ETAT (POSTE);
+CREATE INDEX ETATEDMN2012_EXECOMPTA ON EDMN_2012_ETAT (EXERCICECOMPTA);
+CREATE INDEX ETATEDMN2012_REFFIN ON EDMN_2012_ETAT (REFERENCEFINANCIERE);
+CREATE INDEX ETATEDMN2012_TXTENTFIN ON EDMN_2012_ETAT (TXTENTETEFINANCIER);
+CREATE INDEX ETATEDMN2012_TXTFIN ON EDMN_2012_ETAT (TEXTEFINANCIER);
+CREATE INDEX ETATEDMN2012_MINBUDG ON EDMN_2012_ETAT (MINISTEREBUDGETAIRE);
+CREATE INDEX ETATEDMN2012_MINBUDGDES ON EDMN_2012_ETAT (MINISTEREBUDGETAIREDESIGN);
+CREATE INDEX ETATEDMN2012_DOMACT ON EDMN_2012_ETAT (DOMAINEACTIVITE);
+CREATE INDEX ETATEDMN2012_FOURNUM ON EDMN_2012_ETAT (FOURNISSEURNUM);
+CREATE INDEX ETATEDMN2012_FOURNOM ON EDMN_2012_ETAT (FOURNISSEURNOM);
+CREATE INDEX ETATEDMN2012_FOURSIRET ON EDMN_2012_ETAT (FOURNISSEURSIRET);
+CREATE INDEX ETATEDMN2012_BENEFNUM ON EDMN_2012_ETAT (BENEFICIAIRENUM);
+CREATE INDEX ETATEDMN2012_BENEFNOM ON EDMN_2012_ETAT (BENEFICIAIRENOM);
+CREATE INDEX ETATEDMN2012_BENEFSIRET ON EDMN_2012_ETAT (BENEFICIAIRESIRET);
+CREATE INDEX ETATEDMN2012_RIBPAYS ON EDMN_2012_ETAT (RIBPAYS);
+CREATE INDEX ETATEDMN2012_RIBBANC ON EDMN_2012_ETAT (RIBBANC);
+CREATE INDEX ETATEDMN2012_RIBCOMPTE ON EDMN_2012_ETAT (RIBCOMPTE);
+CREATE INDEX ETATEDMN2012_RIBCLE ON EDMN_2012_ETAT (RIBCLE);
+CREATE INDEX ETATEDMN2012_CPTEPCE ON EDMN_2012_ETAT (COMPTEPCE);
+CREATE INDEX ETATEDMN2012_LIBPCE ON EDMN_2012_ETAT (LIBELLEPCE);
+CREATE INDEX ETATEDMN2012_DEBCRED ON EDMN_2012_ETAT (DEBITCREDITPCE);
+CREATE INDEX ETATEDMN2012_CPTEBUDG ON EDMN_2012_ETAT (COMPTEBUDG);
+CREATE INDEX ETATEDMN2012_DTECOMPTA ON EDMN_2012_ETAT (DATECOMPTABLE);
+CREATE INDEX ETATEDMN2012_DTEPAIE ON EDMN_2012_ETAT (DATEPAIEMENT);
+CREATE INDEX ETATEDMN2012_MT ON EDMN_2012_ETAT (MTPCE);
+CREATE INDEX ETATEDMN2012_DOMFONC ON EDMN_2012_ETAT (DOMAINEFONCTIONNEL);
+CREATE INDEX ETATEDMN2012_CENTFIN ON EDMN_2012_ETAT (CENTREFINANCIER);
+CREATE INDEX ETATEDMN2012_DESIGNFIN ON EDMN_2012_ETAT (DESIGNATIONFINANCIER);
+CREATE INDEX ETATEDMN2012_CENTCOUT ON EDMN_2012_ETAT (CENTRECOUT);
+CREATE INDEX ETATEDMN2012_CENTCOUTDES ON EDMN_2012_ETAT (CENTRECOUTDESIGN);
+CREATE INDEX ETATEDMN2012_TYPEJ ON EDMN_2012_ETAT (TYPEEJ);
+CREATE INDEX ETATEDMN2012_TYPEJDES ON EDMN_2012_ETAT (TYPEEJDESIGN);
+CREATE INDEX ETATEDMN2012_NUMEJ ON EDMN_2012_ETAT (NUMEJ);
+CREATE INDEX ETATEDMN2012_NUMEJLONG ON EDMN_2012_ETAT (NUMEJLONG);
+CREATE INDEX ETATEDMN2012_DTEEJ ON EDMN_2012_ETAT (DATEEJ);
+CREATE INDEX ETATEDMN2012_TYPECR ON EDMN_2012_ETAT (TYPEECRITURE);
+CREATE INDEX ETATEDMN2012_PERFIN ON EDMN_2012_ETAT (PERIMFINANCIER);
+CREATE INDEX ETATEDMN2012_SEREXEC ON EDMN_2012_ETAT (SERVEXEC);
+CREATE INDEX ETATEDMN2012_PJ ON EDMN_2012_ETAT (PJ);
+CREATE INDEX ETATEDMN2012_ESPCE ON EDMN_2012_ETAT (ESPACEMENT);
+CREATE INDEX ETATEDMN2012_COMPT ON EDMN_2012_ETAT (COMPTABLE);
+CREATE INDEX ETATEDMN2012_LIBCOMPT ON EDMN_2012_ETAT (LIBELLECOMPTABLE);
+CREATE INDEX ETATEDMN2012_NUMLIASSEDEB ON EDMN_2012_ETAT (NUMLIASSEDEB);
+CREATE INDEX ETATEDMN2012_NUMLIASSEFIN ON EDMN_2012_ETAT (NUMLIASSEFIN);
+CREATE INDEX ETATEDMN2012_ANNEE ON EDMN_2012_ETAT (ANNEE);
+CREATE INDEX ETATEDMN2012_MOIS ON EDMN_2012_ETAT (MOIS);
+CREATE INDEX ETATEDMN2012_TRIM ON EDMN_2012_ETAT (TRIMESTRE);
+CREATE INDEX ETATEDMN2012_IMP ON EDMN_2012_ETAT (IMPUTATION);
CREATE INDEX ETATEDMN2012_LIASSE_BC ON EDMN_2012_ETAT_LIASSES (COLLECTIVITE,BUDGET,DOC_ID);
CREATE INDEX ETATEDMN2012_LIASSE_DC ON EDMN_2012_ETAT_LIASSES (DOC_ID);
CREATE INDEX ETATEDMN2012_LIASSE_NODEID ON EDMN_2012_ETAT_LIASSES (NODEID);
-CREATE INDEX LIASSE_ANNEE_GEST ON EDMN_2012_ETAT_LIASSES (COLLECTIVITE,BUDGET,ANNEE_GESTION);
+CREATE INDEX ETATEDMN2012_LIASSE_AG ON EDMN_2012_ETAT_LIASSES (COLLECTIVITE,BUDGET,ANNEE_GESTION);
CREATE INDEX ETATEDMN2012_LIASSE_CENTRALE ON EDMN_2012_ETAT_LIASSES (NUM_LIASSE);
CREATE INDEX ETATEDMN2012_LIASSE_IDN ON EDMN_2012_ETAT_LIASSES (INITIAL_DOC_NAME);
CREATE INDEX ETATEDMN2012_LIASSE_AN ON EDMN_2012_ETAT_LIASSES (ARCHIVE_NAME);
+INSERT INTO TABLES_VERSIONS(TABLE_NAME, VERSION) VALUES ('EDMN_2012_LIST_BUDG_COLL' ,1);
INSERT INTO TABLES_VERSIONS(TABLE_NAME, VERSION) VALUES ('EDMN_2012_SPECIAL_KEYS' ,1);
-INSERT INTO TABLES_VERSIONS(TABLE_NAME, VERSION) VALUES ('EDMN_LIST_BUDG_COLL' ,1);
INSERT INTO TABLES_VERSIONS(TABLE_NAME, VERSION) VALUES ('EDMN_2012_ETAT_DOCS' ,1);
INSERT INTO TABLES_VERSIONS(TABLE_NAME, VERSION) VALUES ('EDMN_2012_ETAT' ,1);
INSERT INTO TABLES_VERSIONS(TABLE_NAME, VERSION) VALUES ('EDMN_2012_ETAT_LIASSES' ,1);