</table>
<table type="special-key" base-name="PES_FACTURE_SPECIAL_KEYS" version="1"> CREATE TABLE
IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(30) NOT NULL, BUDGET VARCHAR(24)
- NOT NULL, INITIAL_DOC_NAME VARCHAR(100) NOT NULL, KEY1 VARCHAR(100), LIB1
+ NOT NULL, INITIAL_DOC_NAME VARCHAR(300), LIB1
VARCHAR(200), KEY2 VARCHAR(100), LIB2 VARCHAR(200), KEY3 VARCHAR(100), LIB3
VARCHAR(200), KEY4 VARCHAR(100), LIB4 VARCHAR(200), KEY5 VARCHAR(100), LIB5
VARCHAR(200), KEY6 VARCHAR(100), LIB6 VARCHAR(200), KEY7 VARCHAR(100), LIB7
<table type="document" base-name="PES_FACTURE_DOCUMENTS" version="1"> CREATE TABLE
IF NOT EXISTS ${base-name} ( COLLECTIVITE VARCHAR(30) NOT NULL, BUDGET
- VARCHAR(24) NOT NULL, INITIAL_DOC_NAME VARCHAR(100) NOT NULL, DOC_ID
+ VARCHAR(24) NOT NULL, INITIAL_DOC_NAME VARCHAR(300) 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),
CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(30) NOT NULL,
BUDGET VARCHAR(24) NOT NULL,
- DOC_ID VARCHAR(100) NOT NULL,
+ DOC_ID VARCHAR(300) NOT NULL,
PRIMARY_KEY VARCHAR(100) NOT NULL,
NODE_ID VARCHAR(50) NOT NULL,
TYPEFACT VARCHAR(255) ,
MONTANT_TTC DECIMAL(14,2),
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
INDEX IX_${base-name}_DC (DOC_ID) ,
- INITIAL_DOC_NAME VARCHAR(100),
+ INITIAL_DOC_NAME VARCHAR(300),
INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
ARCHIVE_NAME VARCHAR(100),
INDEX ${base-name}_AN (ARCHIVE_NAME)
<table type="index" id="PES_FACTURE_PESFACTURE_TIERS_IX"
base-name="PES_FACTURE_PESFACTURE_TIERS_IX" version="1" main="false"
based-on="key2"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
- VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
+ VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(300) NOT NULL,
NODE_ID VARCHAR(50) NOT NULL, DTEBANC DATE , VILLE VARCHAR(38) , TYPADR
VARCHAR(255) , CP VARCHAR(5) , CATTIERS VARCHAR(255) , TYPETIERSFACTURE
VARCHAR(255) , NUMTVA VARCHAR(24) , IDTIERS VARCHAR(30) , CODRES VARCHAR(255) ,
DTEIDTIERS DATE , NATJUR VARCHAR(255) , DTEADR DATE , DTEMALADE DATE , CIVILITE
VARCHAR(10) , COMPLNOM VARCHAR(38) , INDEX IX_${base-name}_BC
(COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID),
- INITIAL_DOC_NAME VARCHAR(100),
+ INITIAL_DOC_NAME VARCHAR(300),
INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
ARCHIVE_NAME VARCHAR(100),
INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM </table>
<table type="index" id="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX"
base-name="PES_FACTURE_PESFACTURE_FACTUREINDIV_IX" version="3" main="false"
based-on="key3"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
- VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
+ VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(300) NOT NULL,
NODE_ID VARCHAR(50) NOT NULL, TYPEFACT VARCHAR(255) , CODPAYS INTEGER , SERVICE
VARCHAR(24) , COMPLNOM VARCHAR(38) , MTTOTALTTC DECIMAL(14,2), IDBANCINT
VARCHAR(11) , OBJET VARCHAR(160) , DATEEMISSION DATE , TEXTEGENERATEUR
NUMERO_COMMANDE VARCHAR(50), MOIS_DATE_EMISSION VARCHAR(2), ANNEE_DATE_EMISSION
VARCHAR(4), ID_LOGEMENT VARCHAR(30), INDEX IX_${base-name}_BC
(COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID),
- INITIAL_DOC_NAME VARCHAR(100),
+ INITIAL_DOC_NAME VARCHAR(300),
INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
ARCHIVE_NAME VARCHAR(100),
INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM
<table type="index" id="PES_FACTURE_FACTUREINDIV_REFERENCE_IX"
base-name="PES_FACTURE_FACTUREINDIV_REFERENCE_IX" version="1" main="false"
based-on="key4"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
- VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
+ VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(300) NOT NULL,
NODE_ID VARCHAR(50) NOT NULL, NUMEROPIECE VARCHAR(50) , TYPEPIECE VARCHAR(255) ,
NUMLIGNE INTEGER , INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INDEX
IX_${base-name}_DC (DOC_ID),
- INITIAL_DOC_NAME VARCHAR(100),
+ INITIAL_DOC_NAME VARCHAR(300),
INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
ARCHIVE_NAME VARCHAR(100),
INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM </table>
<table type="index" id="PES_FACTURE_FACTUREINDIV_TIERS_IX"
base-name="PES_FACTURE_FACTUREINDIV_TIERS_IX" version="1" main="false"
based-on="key5"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
- VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
+ VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(300) NOT NULL,
NODE_ID VARCHAR(50) NOT NULL, DTEBANC DATE , VILLE VARCHAR(38) , TYPADR
VARCHAR(255) , CP VARCHAR(5) , CATTIERS VARCHAR(255) , TYPETIERSFACTURE
VARCHAR(255) , NUMTVA VARCHAR(24) , IDTIERS VARCHAR(30) , CODRES VARCHAR(255) ,
DTEIDTIERS DATE , NATJUR VARCHAR(255) , DTEADR DATE , DTEMALADE DATE , CIVILITE
VARCHAR(10) , COMPLNOM VARCHAR(38) , INDEX IX_${base-name}_BC
(COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID),
- INITIAL_DOC_NAME VARCHAR(100),
+ INITIAL_DOC_NAME VARCHAR(300),
INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
ARCHIVE_NAME VARCHAR(100),
INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM </table>
<table type="index" id="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX"
base-name="PES_FACTURE_FACTUREINDIV_LIGNEFACTURE_IX" version="1" main="false"
based-on="key6"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
- VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
+ VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(300) NOT NULL,
NODE_ID VARCHAR(50) NOT NULL, ORDRE INTEGER , CODEFONCTION VARCHAR(24) , MTTTC
DECIMAL(14,2), TAUX DECIMAL(6,3), MTREMISE DECIMAL(14,2), MTHT DECIMAL(14,2),
TAUXTVA DECIMAL(5,2), MTTVA DECIMAL(14,2), ORDREEDITION INTEGER , CODEPRODUIT
VARCHAR(100) , UNITE VARCHAR(38), QUANTITE DECIMAL(14,2), MTUNITAIRE
DECIMAL(16,4), MTBASE DECIMAL(5,2), INDEX IX_${base-name}_BC
(COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID),
- INITIAL_DOC_NAME VARCHAR(100),
+ INITIAL_DOC_NAME VARCHAR(300),
INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
ARCHIVE_NAME VARCHAR(100),
INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM </table>
<table type="index" id="PES_FACTURE_LIGNEFACTURE_TIERS_IX"
base-name="PES_FACTURE_LIGNEFACTURE_TIERS_IX" version="1" main="false"
based-on="key7"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
- VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
+ VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(300) NOT NULL,
NODE_ID VARCHAR(50) NOT NULL, DTEBANC DATE , VILLE VARCHAR(38) , TYPADR
VARCHAR(255) , CP VARCHAR(5) , CATTIERS VARCHAR(255) , TYPETIERSFACTURE
VARCHAR(255) , NUMTVA VARCHAR(24) , IDTIERS VARCHAR(30) , CODRES VARCHAR(255) ,
DTEIDTIERS DATE , NATJUR VARCHAR(255) , DTEADR DATE , DTEMALADE DATE , CIVILITE
VARCHAR(10) , COMPLNOM VARCHAR(38) , INDEX IX_${base-name}_BC
(COLLECTIVITE,BUDGET,DOC_ID), INDEX IX_${base-name}_DC (DOC_ID),
- INITIAL_DOC_NAME VARCHAR(100),
+ INITIAL_DOC_NAME VARCHAR(300),
INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
ARCHIVE_NAME VARCHAR(100),
INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM </table>
<table type="index" id="PES_FACTURE_LIGNEFACTURE_REFERENCE_IX"
base-name="PES_FACTURE_LIGNEFACTURE_REFERENCE_IX" version="1" main="false"
based-on="key8"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
- VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
+ VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(300) NOT NULL,
NODE_ID VARCHAR(50) NOT NULL, NUMEROPIECE VARCHAR(50) , TYPEPIECE VARCHAR(255) ,
NUMLIGNE INTEGER , INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID), INDEX
IX_${base-name}_DC (DOC_ID),
- INITIAL_DOC_NAME VARCHAR(100),
+ INITIAL_DOC_NAME VARCHAR(300),
INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
ARCHIVE_NAME VARCHAR(100),
INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM </table>
<table type="index" id="PES_FACTURE_FACTUREINDIV_DETAILTVA_IX"
base-name="PES_FACTURE_FACTUREINDIV_DETAILTVA_IX" version="1" main="false"
based-on="key9"> CREATE TABLE IF NOT EXISTS ${base-name} ( COLLECTIVITE
- VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(100) NOT NULL,
+ VARCHAR(30) NOT NULL, BUDGET VARCHAR(24) NOT NULL, DOC_ID VARCHAR(300) NOT NULL,
NODE_ID VARCHAR(50) NOT NULL, TAUXTVA DECIMAL(5,2), MTTVA DECIMAL(14,2),
MTBASEHT DECIMAL(14,2), INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
INDEX IX_${base-name}_DC (DOC_ID),
- INITIAL_DOC_NAME VARCHAR(100),
+ INITIAL_DOC_NAME VARCHAR(300),
INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
ARCHIVE_NAME VARCHAR(100),
INDEX ${base-name}_AN (ARCHIVE_NAME) ) ENGINE MYISAM </table>