CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
BUDGET VARCHAR(24) NOT NULL,
- INITIAL_DOC_NAME VARCHAR(100) NOT NULL,
+ INITIAL_DOC_NAME VARCHAR(300) NOT NULL,
KEY1 VARCHAR(100) NOT NULL,
LIB1 VARCHAR(200),
KEY2 VARCHAR(100),
BUDGET VARCHAR(24) NOT NULL,
BUDGET_LIB VARCHAR(200),
COLLECTIVITE_LIB VARCHAR(200),
- INITIAL_DOC_NAME VARCHAR(100) NOT NULL,
+ INITIAL_DOC_NAME VARCHAR(300) NOT NULL,
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET),
ARCHIVE_NAME VARCHAR(100),
INDEX ${base-name}_AN (ARCHIVE_NAME)
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,
+ INITIAL_DOC_NAME VARCHAR(300) NOT NULL,
+ DOC_ID VARCHAR(300) NOT NULL,
DOC LONGBLOB,
ENCODING VARCHAR(20),
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
BUDGET VARCHAR(24) NOT NULL,
- DOC_ID VARCHAR(100) NOT NULL,
+ DOC_ID VARCHAR(300) NOT NULL,
ANNEE INTEGER,
ID_VERST VARCHAR(50),
PRESTATION VARCHAR(50),
CODE_FONCTION VARCHAR(24),
MOIS VARCHAR(2),
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,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)
Create table IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
BUDGET VARCHAR(24) NOT NULL,
- DOC_ID VARCHAR(100) NOT NULL,
+ DOC_ID VARCHAR(300) NOT NULL,
ID_TIERS VARCHAR(30),
DATE_MALADE DATE,
TYPE_TIERS VARCHAR(2),
DATE_ADR DATE,
RIB VARCHAR(23),
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,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)
CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
BUDGET VARCHAR(24) NOT NULL,
- DOC_ID VARCHAR(100) NOT NULL,
+ DOC_ID VARCHAR(300) NOT NULL,
SUPPORT_PJ VARCHAR(2),
ID_UNIQUE_PJ VARCHAR(50),
NOM_PJ VARCHAR(100),
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,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)
CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
BUDGET VARCHAR(24) NOT NULL,
- DOC_ID VARCHAR(100) NOT NULL,
+ DOC_ID VARCHAR(300) NOT NULL,
NODE_ID VARCHAR(15) NOT NULL,
DATE_LIGNE DATE,
DATE_DEBUT DATE,
ORDRE INTEGER,
COMMENTAIRE VARCHAR(100),
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,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)
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,
+ INITIAL_DOC_NAME VARCHAR(300) NOT NULL,
+ DOC_ID VARCHAR(300) NOT NULL,
DOC LONGBLOB,
ENCODING VARCHAR(20),
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
BUDGET VARCHAR(24) NOT NULL,
- DOC_ID VARCHAR(100) NOT NULL,
+ DOC_ID VARCHAR(300) NOT NULL,
ANNEE INTEGER,
LIBELLE VARCHAR(100),
CODE_NATURE VARCHAR(24),
CODE_FONCTION VARCHAR(24),
CODE_BUDGET VARCHAR(24),
MONTANT DECIMAL(16,3),
- 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)
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,
+ INITIAL_DOC_NAME VARCHAR(300) NOT NULL,
+ DOC_ID VARCHAR(300) NOT NULL,
DOC LONGBLOB,
ENCODING VARCHAR(20),
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
BUDGET VARCHAR(24) NOT NULL,
- DOC_ID VARCHAR(100) NOT NULL,
+ DOC_ID VARCHAR(300) NOT NULL,
ANNEE INTEGER,
PRESTATION VARCHAR(50),
IDTIERS VARCHAR(30),
RIB VARCHAR(50),
MONTANT DECIMAL(16,3),
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,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)