CREATE TABLE IF NOT EXISTS ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
BUDGET VARCHAR(24) NOT NULL,
- INITIAL_DOC_NAME VARCHAR(300) NOT NULL,
- DOC_ID VARCHAR(300) NOT NULL,
+ INITIAL_DOC_NAME VARCHAR(100) NOT NULL,
+ DOC_ID VARCHAR(100) 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(300) NOT NULL,
+ DOC_ID VARCHAR(100) NOT NULL,
NODE_ID VARCHAR(50),
MOISMOUCOMPTA DATE ,
NUMCOMRAT VARCHAR(255) ,
FILE_NAME VARCHAR(255),
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
INDEX IX_${base-name}_DC (DOC_ID) ,
- INITIAL_DOC_NAME VARCHAR(300),
+ INITIAL_DOC_NAME VARCHAR(100),
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(300) NOT NULL,
+ DOC_ID VARCHAR(100) NOT NULL,
NODE_ID VARCHAR(50),
TYPE_LIGNE VARCHAR(50),
MTMOUCOMPTA DECIMAL(18,3) ,
DTTRAIMOUCOMPTA DATE ,
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
INDEX IX_${base-name}_DC (DOC_ID) ,
- INITIAL_DOC_NAME VARCHAR(300),
+ INITIAL_DOC_NAME VARCHAR(100),
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(300) NOT NULL,
- DOC_ID VARCHAR(300) NOT NULL,
+ INITIAL_DOC_NAME VARCHAR(100) NOT NULL,
+ DOC_ID VARCHAR(100) 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(300) NOT NULL,
+ DOC_ID VARCHAR(100) NOT NULL,
NODE_ID VARCHAR(50),
PERIODE DATE ,
FILE_NAME VARCHAR(255),
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
INDEX IX_${base-name}_DC (DOC_ID) ,
- INITIAL_DOC_NAME VARCHAR(300),
+ INITIAL_DOC_NAME VARCHAR(100),
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(300) NOT NULL,
+ DOC_ID VARCHAR(100) NOT NULL,
PARENT_NODE_ID VARCHAR(50),
NODE_ID VARCHAR(50),
TYPE_LIGNE VARCHAR(31) NOT NULL,
MTTOTRSA DECIMAL(18,3) ,
INDEX IX_${base-name}_BC (COLLECTIVITE,BUDGET,DOC_ID),
INDEX IX_${base-name}_DC (DOC_ID),
- INITIAL_DOC_NAME VARCHAR(300),
+ INITIAL_DOC_NAME VARCHAR(100),
INDEX ${base-name}_IDN (INITIAL_DOC_NAME),
ARCHIVE_NAME VARCHAR(100),
INDEX ${base-name}_AN (ARCHIVE_NAME)