CREATE VIEW SVPM01R6_SUB1 AS (SELECT CODCLI, CINCID, COUNT(XVPM05) AS NDIACL FROM              
 SVPM05P0 GROUP BY CODCLI, CINCID) ;
CREATE VIEW SVPM01R6_SUB2 AS (SELECT CODCLI, CINCID, COUNT(XUMREL)    
 AS NRELAN FROM SVPM04P0 GROUP BY CODCLI, CINCID) ;                            
CREATE VIEW SVPM01R6_SUB3 AS (             
 SELECT CODCLI, CINCID, COUNT(XVPD01) AS NDOCUM FROM SVPD01P0                 
 GROUP BY CODCLI, CINCID);

CREATE VIEW SVPM01R6 ( CINCID , CODCLI , CGRPCL , CDPROJ , CODLOT ,      
CPRODU , CMODUL , CARCAD , CDEMAN , LEMAIL , DDEMAN , HDEMAN , CTELDI    
 , CSDOMA , CTITRE , LCODEM , CODMEN , CJSP , LSODEM , NSEVER , NPRIOR   
 , CQACLI , NSEVA3 , CPROA3 , CMODA3 , NPRIA3 , CQAINT , BFACTU ,        
 BDPUOK , CTITA3 , LINFCO , DAVANC , NODAVA , LREPON , DPLANI , BMOJAV   
 , BMORPG , BMOSQL , BMOJSP , BMODIC , BMODWD , BMOMAP , BMOPAR ,        
BMOAUT , CODORI , CCLIPE , OSTS01 , OSTS02 , TOUVER , NRELAN , NDOCUM    
, NDIACL, LINFRE ,OBOO01)                                                
AS SELECT M01.CINCID, M01.CODCLI, M01.CGRPCL, M01.CDPROJ                 
, M01.CODLOT, M01.CPRODU, M01.CMODUL, M01.CARCAD, M01.CDEMAN, M01.LEMAIL 
, M01.DDEMAN, M01.HDEMAN, M01.CTELDI, M01.CSDOMA, M01.CTITRE, M01.LCODEM 
, M01.CODMEN, M01.CJSP, M01.LSODEM, M01.NSEVER, M01.NPRIOR,              
M01.CQACLI, M01.NSEVA3, M01.CPROA3, M01.CMODA3, M01.NPRIA3, M01.CQAINT   
, M01.BFACTU, M01.BDPUOK, M01.CTITA3, M01.LINFCO, M01.DAVANC, M01.NODAVA 
, M01.LREPON, M01.DPLANI, M01.BMOJAV, M01.BMORPG, M01.BMOSQL,            
M01.BMOJSP, M01.BMODIC, M01.BMODWD, M01.BMOMAP, M01.BMOPAR, M01.BMOAUT   
, M01.CODORI, M01.CCLIPE, M01.OSTS01, M01.OSTS02,                        
TIMESTAMP(M01.DDEMAN, M01.HDEMAN)                                        
, C.NRELAN, D.NDOCUM, B.NDIACL, M01.LINFRE, M01.OBOO01                   
FROM SVPM01P0 M01    
  LEFT JOIN SVPM01R6_SUB1 B ON M01.CINCID = B.CINCID                 
 AND M01.CODCLI = B.CODCLI LEFT JOIN SVPM01R6_SUB2                            
 C ON M01.CINCID = C.CINCID AND M01.CODCLI = C.CODCLI LEFT JOIN 
SVPM01R6_SUB3 D ON M01.CODCLI = D.CODCLI AND M01.CINCID= D.CINCID;  


CREATE view SVPC03R2 (CODCLI, LIBCLI, CPRODU, CMODUL, LLIBEL) AS select a.codcli, a.libcli, b.cprodu, b.cmodul, c.llibel from SVPC01P0  a 
join SVPC03P0 b on a.codcli = b.codcli 
join SVPP02P0 c on b.cprodu = c.cprodu and b.cmodul = c.cmodul where b.bannul = 0


CREATE VIEW SVPC01R1 (                                                   
 CODCLI , LIBCLI , LADR1 , LADR2 , CCPOST , LVILLE , CTELEP , CODFAX ,   
 LSIWEB , LEMAIL , CGRPCL , CRESP1 , BRECM1 , CRESP2 , CRESP3 , BSURVE , 
 BGROUP , LINSTR , LINTMA , LCOMME , LISTML , BANNUL , DANNUL , CUSRCR , 
 CPGMCR , TCREAT , CUSRMO , CPGMMO , TMODIF , OBOO01 , OBOO02 ,          
 OBOO03 , OBOO04 , OBOO05 , OSTS01 , OSTS02 , OSTS03 , OSTS04 ,          
 CDUSER)                                                                 
AS                                                                       
SELECT SVPC01P0.CODCLI, SVPC01P0.LIBCLI                                  
  , SVPC01P0.LADR1, SVPC01P0.LADR2, SVPC01P0.CCPOST, SVPC01P0.LVILLE,    
   SVPC01P0.CTELEP, SVPC01P0.CODFAX, SVPC01P0.LSIWEB, SVPC01P0.LEMAIL,   
   SVPC01P0.CGRPCL, SVPC01P0.CRESP1, SVPC01P0.BRECM1, SVPC01P0.CRESP2,   
   SVPC01P0.CRESP3, SVPC01P0.BSURVE, SVPC01P0.BGROUP, SVPC01P0.LINSTR,   
   SVPC01P0.LINTMA, SVPC01P0.LCOMME, SVPC01P0.LISTML, SVPC01P0.BANNUL,   
   SVPC01P0.DANNUL, SVPC01P0.CUSRCR, SVPC01P0.CPGMCR, SVPC01P0.TCREAT,   
   SVPC01P0.CUSRMO, SVPC01P0.CPGMMO, SVPC01P0.TMODIF, SVPC01P0.OBOO01,   
   SVPC01P0.OBOO02, SVPC01P0.OBOO03, SVPC01P0.OBOO04, SVPC01P0.OBOO05,   
   SVPC01P0.OSTS01, SVPC01P0.OSTS02, SVPC01P0.OSTS03, SVPC01P0.OSTS04,   
   SVPI01P0.CDUSER FROM SVPC01P0 INNER JOIN                              
   SVPI01P0 ON SVPC01P0.CODCLI = SVPI01P0.CODCLI ; 


show index in SVPM01P0;
+----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table    | Non_unique | Key_name         | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| svpm01p0 |          0 | PRIMARY          |            1 | CINCID      | A         |        1096 |     NULL | NULL   |      | BTREE      |         |               |
| svpm01p0 |          0 | PRIMARY          |            2 | CODCLI      | A         |       20825 |     NULL | NULL   |      | BTREE      |         |               |
| svpm01p0 |          1 | FK_SVPM01_SVPL01 |            1 | CDPROJ      | A         |           2 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpm01p0 |          1 | FK_SVPM01_SVPL01 |            2 | CODLOT      | A         |           2 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpm01p0 |          1 | FK_SVPM01_SVPC03 |            1 | CODCLI      | A         |        1225 |     NULL | NULL   |      | BTREE      |         |               |
| svpm01p0 |          1 | FK_SVPM01_SVPC03 |            2 | CPRODU      | A         |        2313 |     NULL | NULL   |      | BTREE      |         |               |
| svpm01p0 |          1 | FK_SVPM01_SVPC03 |            3 | CMODUL      | A         |        3470 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpm01p0 |          1 | M01CDPROJ        |            1 | CDPROJ      | A         |           2 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpm01p0 |          1 | M01DDEMAN        |            1 | DDEMAN      | A         |        1225 |     NULL | NULL   |      | BTREE      |         |               |
| svpm01p0 |          1 | M01CODCLI        |            1 | CODCLI      | A         |        1601 |     NULL | NULL   |      | BTREE      |         |               |
| svpm01p0 |          1 | M01NODAVA        |            1 | NODAVA      | A         |          14 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpm01p0 |          1 | M01CINCID        |            1 | CINCID      | A         |        1487 |     NULL | NULL   |      | BTREE      |         |               |
| svpm01p0 |          1 | M01CPRODU        |            1 | CPRODU      | A         |          28 |     NULL | NULL   |      | BTREE      |         |               |
| svpm01p0 |          1 | M01CMODUL        |            1 | CMODUL      | A         |          98 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpm01p0 |          1 | M01CTITRE        |            1 | CTITRE      | A         |       20825 |     NULL | NULL   |      | BTREE      |         |               |
| svpm01p0 |          1 | M01NSEVER        |            1 | NSEVER      | A         |           4 |     NULL | NULL   |      | BTREE      |         |               |
| svpm01p0 |          1 | M01CQACLI        |            1 | CQACLI      | A         |          10 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpm01p0 |          1 | M01NPRIOR        |            1 | NPRIOR      | A         |           4 |     NULL | NULL   |      | BTREE      |         |               |
| svpm01p0 |          1 | M01NSEVA3        |            1 | NSEVA3      | A         |           4 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpm01p0 |          1 | M01NPRIA3        |            1 | NPRIA3      | A         |           4 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpm01p0 |          1 | M01CPROA3        |            1 | CPROA3      | A         |          28 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpm01p0 |          1 | M01CMODA3        |            1 | CMODA3      | A         |          88 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpm01p0 |          1 | SVPM01YTOUVER    |            1 | DDEMAN      | A         |        1388 |     NULL | NULL   |      | BTREE      |         |               |
| svpm01p0 |          1 | SVPM01YTOUVER    |            2 | HDEMAN      | A         |       20825 |     NULL | NULL   |      | BTREE      |         |               |
+----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+


+----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table    | Non_unique | Key_name         | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| svpm04p0 |          0 | PRIMARY          |            1 | XUMREL      | A         |          24 |     NULL | NULL   |      | BTREE      |         |               |
| svpm04p0 |          0 | PRIMARY          |            2 | CINCID      | A         |         947 |     NULL | NULL   |      | BTREE      |         |               |
| svpm04p0 |          0 | PRIMARY          |            3 | CODCLI      | A         |         947 |     NULL | NULL   |      | BTREE      |         |               |
| svpm04p0 |          1 | FK_SVPM04_SVPM01 |            1 | CINCID      | A         |         947 |     NULL | NULL   |      | BTREE      |         |               |
| svpm04p0 |          1 | FK_SVPM04_SVPM01 |            2 | CODCLI      | A         |         947 |     NULL | NULL   |      | BTREE      |         |               |
| svpm04p0 |          1 | M04CINCID        |            1 | CINCID      | A         |         947 |     NULL | NULL   |      | BTREE      |         |               |
| svpm04p0 |          1 | M04CODCLI        |            1 | CODCLI      | A         |         315 |     NULL | NULL   |      | BTREE      |         |               |
| svpm04p0 |          1 | M04DRELAN        |            1 | DRELAN      | A         |         947 |     NULL | NULL   |      | BTREE      |         |               |
| svpm04p0 |          1 | M04HRELAN        |            1 | HRELAN      | A         |         947 |     NULL | NULL   |      | BTREE      |         |               |
| svpm04p0 |          1 | M04LCOMME        |            1 | LCOMME      | A         |         947 |      255 | NULL   | YES  | BTREE      |         |               |
| svpm04p0 |          1 | M04CRELAN        |            1 | CRELAN      | A         |         473 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpm04p0 |          1 | SVPM04Y0         |            1 | CODCLI      | A         |         315 |     NULL | NULL   |      | BTREE      |         |               |
| svpm04p0 |          1 | SVPM04Y0         |            2 | CINCID      | A         |         947 |     NULL | NULL   |      | BTREE      |         |               |
| svpm04p0 |          1 | SVPM04Y0         |            3 | XUMREL      | A         |         947 |     NULL | NULL   |      | BTREE      |         |               |
+----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

  

+----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table    | Non_unique | Key_name         | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| svpm05p0 |          0 | PRIMARY          |            1 | XVPM05      | A         |       42083 |     NULL | NULL   |      | BTREE      |         |               |
| svpm05p0 |          0 | PRIMARY          |            2 | CINCID      | A         |       42083 |     NULL | NULL   |      | BTREE      |         |               |
| svpm05p0 |          0 | PRIMARY          |            3 | CODCLI      | A         |       42083 |     NULL | NULL   |      | BTREE      |         |               |
| svpm05p0 |          1 | FK_SVPM05_SVPM01 |            1 | CINCID      | A         |        1451 |     NULL | NULL   |      | BTREE      |         |               |
| svpm05p0 |          1 | FK_SVPM05_SVPM01 |            2 | CODCLI      | A         |       42083 |     NULL | NULL   |      | BTREE      |         |               |
| svpm05p0 |          1 | M05CINCID        |            1 | CINCID      | A         |        1451 |     NULL | NULL   |      | BTREE      |         |               |
| svpm05p0 |          1 | M05CODCLI        |            1 | CODCLI      | A         |        1558 |     NULL | NULL   |      | BTREE      |         |               |
| svpm05p0 |          1 | M05LDIALO        |            1 | LDIALO      | A         |       42083 |      255 | NULL   |      | BTREE      |         |               |
| svpm05p0 |          1 | M05NODAVA        |            1 | NODAVA      | A         |          12 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpm05p0 |          1 | M05CDUSER        |            1 | CDUSER      | A         |         914 |     NULL | NULL   |      | BTREE      |         |               |
| svpm05p0 |          1 | M05LEMAIL        |            1 | LEMAIL      | A         |        7013 |     NULL | NULL   |      | BTREE      |         |               |
| svpm05p0 |          1 | M05TCREAT        |            1 | TCREAT      | A         |       42083 |     NULL | NULL   |      | BTREE      |         |               |
| svpm05p0 |          1 | SVPM05Y0         |            1 | TCREAT      | A         |       42083 |     NULL | NULL   |      | BTREE      |         |               |
| svpm05p0 |          1 | SVPM05Y1         |            1 | CODCLI      | A         |        1618 |     NULL | NULL   |      | BTREE      |         |               |
| svpm05p0 |          1 | SVPM05Y1         |            2 | CINCID      | A         |       42083 |     NULL | NULL   |      | BTREE      |         |               |
| svpm05p0 |          1 | SVPM05Y1         |            3 | XVPM05      | A         |       42083 |     NULL | NULL   |      | BTREE      |         |               |
+----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

show index in SVPD01P0;
+----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table    | Non_unique | Key_name         | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| svpd01p0 |          0 | PRIMARY          |            1 | XVPD01      | A         |        5362 |     NULL | NULL   |      | BTREE      |         |               |
| svpd01p0 |          1 | FK_SVPD01_SVPM01 |            1 | CINCID      | A         |         595 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpd01p0 |          1 | FK_SVPD01_SVPM01 |            2 | CODCLI      | A         |        5362 |     NULL | NULL   |      | BTREE      |         |               |
| svpd01p0 |          1 | D01CINCID        |            1 | CINCID      | A         |         595 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpd01p0 |          1 | D01CODCLI        |            1 | CODCLI      | A         |         766 |     NULL | NULL   |      | BTREE      |         |               |
| svpd01p0 |          1 | SVPD01Y0         |            1 | CODCLI      | A         |         766 |     NULL | NULL   |      | BTREE      |         |               |
| svpd01p0 |          1 | SVPD01Y0         |            2 | CINCID      | A         |        5362 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpd01p0 |          1 | SVPD01Y0         |            3 | XVPD01      | A         |        5362 |     NULL | NULL   |      | BTREE      |         |               |
+----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+



+----------+------------+--------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table    | Non_unique | Key_name           | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------+------------+--------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| svpc01p0 |          0 | PRIMARY            |            1 | CODCLI      | A         |        1411 |     NULL | NULL   |      | BTREE      |         |               |
| svpc01p0 |          1 | FK_SVPC01_CFGG02_1 |            1 | CRESP1      | A         |          56 |     NULL | NULL   |      | BTREE      |         |               |
| svpc01p0 |          1 | FK_SVPC01_CFGG02_2 |            1 | CRESP2      | A         |           6 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpc01p0 |          1 | FK_SVPC01_CFGG02_3 |            1 | CRESP3      | A         |          14 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpc01p0 |          1 | C01CODCLI          |            1 | CODCLI      | A         |        1411 |     NULL | NULL   |      | BTREE      |         |               |
| svpc01p0 |          1 | C01LIBCLI          |            1 | LIBCLI      | A         |        1411 |     NULL | NULL   |      | BTREE      |         |               |
+----------+------------+--------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

show index in SVPC03P0;
+----------+------------+--------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table    | Non_unique | Key_name           | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------+------------+--------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| svpc03p0 |          0 | PRIMARY            |            1 | CODCLI      | A         |        3993 |     NULL | NULL   |      | BTREE      |         |               |
| svpc03p0 |          0 | PRIMARY            |            2 | CPRODU      | A         |        3993 |     NULL | NULL   |      | BTREE      |         |               |
| svpc03p0 |          0 | PRIMARY            |            3 | CMODUL      | A         |        3993 |     NULL | NULL   |      | BTREE      |         |               |
| svpc03p0 |          1 | FK_SVPC03_SVPP02   |            1 | CPRODU      | A         |          38 |     NULL | NULL   |      | BTREE      |         |               |
| svpc03p0 |          1 | FK_SVPC03_SVPP02   |            2 | CMODUL      | A         |         234 |     NULL | NULL   |      | BTREE      |         |               |
| svpc03p0 |          1 | FK_SVPC03_CFGG02_1 |            1 | CRESP1      | A         |         110 |     NULL | NULL   |      | BTREE      |         |               |
| svpc03p0 |          1 | FK_SVPC03P0_CFGG02 |            1 | CRESP2      | A         |           2 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpc03p0 |          1 | FK_SVPC03_CFGG02_3 |            1 | CRESP3      | A         |           2 |     NULL | NULL   | YES  | BTREE      |         |               |
+----------+------------+--------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+



+----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table    | Non_unique | Key_name         | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| svpp02p0 |          0 | PRIMARY          |            1 | CPRODU      | A         |          46 |     NULL | NULL   |      | BTREE      |         |               |
| svpp02p0 |          0 | PRIMARY          |            2 | CMODUL      | A         |         139 |     NULL | NULL   |      | BTREE      |         |               |
| svpp02p0 |          1 | FK_SVPP02_CFGG02 |            1 | CRESMO      | A         |          46 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpp02p0 |          1 | P02CPRODU        |            1 | CPRODU      | A         |          46 |     NULL | NULL   |      | BTREE      |         |               |
| svpp02p0 |          1 | P02CMODUL        |            1 | CMODUL      | A         |         139 |     NULL | NULL   |      | BTREE      |         |               |
+----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+


+----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table    | Non_unique | Key_name         | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| svpi02p0 |          0 | PRIMARY          |            1 | XVPI02      | A         |         342 |     NULL | NULL   |      | BTREE      |         |               |
| svpi02p0 |          1 | FK_SVPI02_SVPC03 |            1 | CODCLI      | A         |          16 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpi02p0 |          1 | FK_SVPI02_SVPC03 |            2 | CPRODU      | A         |          57 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpi02p0 |          1 | FK_SVPI02_SVPC03 |            3 | CMODUL      | A         |          85 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpi02p0 |          1 | I02CDUSER        |            1 | CDUSER      | A         |         171 |     NULL | NULL   |      | BTREE      |         |               |
| svpi02p0 |          1 | I02CPRODU        |            1 | CPRODU      | A         |          42 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpi02p0 |          1 | I02CMODUL        |            1 | CMODUL      | A         |          22 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpi02p0 |          1 | I02CODCLI        |            1 | CODCLI      | A         |          16 |     NULL | NULL   | YES  | BTREE      |         |               |
| svpi02p0 |          1 | I02CINCTY        |            1 | CINCTY      | A         |           6 |     NULL | NULL   | YES  | BTREE      |         |               |
+----------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

show index in CFGG02P0;
+----------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table    | Non_unique | Key_name       | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| cfgg02p0 |          0 | PRIMARY        |            1 | CDUSER      | A         |        1620 |     NULL | NULL   |      | BTREE      |         |               |
| cfgg02p0 |          1 | Ind_CFGG02P0_1 |            1 | CENVIR      | A         |           4 |     NULL | NULL   | YES  | BTREE      |         |               |
| cfgg02p0 |          1 | Ind_CFGG02P0_1 |            2 | CDIVIS      | A         |           4 |     NULL | NULL   | YES  | BTREE      |         |               |
| cfgg02p0 |          1 | Ind_CFGG02P0_2 |            1 | CPOOLC      | A         |           2 |     NULL | NULL   | YES  | BTREE      |         |               |
| cfgg02p0 |          1 | Ind_CFGG02P0_3 |            1 | CENVIR      | A         |           4 |     NULL | NULL   | YES  | BTREE      |         |               |
| cfgg02p0 |          1 | Ind_CFGG02P0_4 |            1 | CDGROU      | A         |          12 |     NULL | NULL   |      | BTREE      |         |               |
| cfgg02p0 |          1 | cfgg02Y0       |            1 | CDUSER      | A         |        1620 |     NULL | NULL   |      | BTREE      |         |               |
| cfgg02p0 |          1 | cfgg02Y1       |            1 | CDUSER      | A         |        1620 |     NULL | NULL   |      | BTREE      |         |               |
| cfgg02p0 |          1 | cfgg02Y1       |            2 | CDGROU      | A         |        1620 |     NULL | NULL   |      | BTREE      |         |               |
+----------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| SVPM01P0 | CREATE TABLE `svpm01p0` (
  `CINCID` varchar(20) NOT NULL COMMENT 'Code incident',
  `CODCLI` varchar(10) NOT NULL COMMENT 'Code Client',
  `CGRPCL` varchar(10) DEFAULT NULL COMMENT 'Groupe client',
  `CDPROJ` varchar(3) DEFAULT NULL COMMENT 'Code projet',
  `CODLOT` varchar(10) DEFAULT NULL COMMENT 'Code lot',
  `CPRODU` varchar(20) NOT NULL COMMENT 'Code produit',
  `CMODUL` varchar(10) DEFAULT NULL COMMENT 'Code module',
  `CARCAD` varchar(30) DEFAULT NULL COMMENT 'Ref ARCAD',
  `CDEMAN` varchar(35) NOT NULL COMMENT 'Demandeur',
  `LEMAIL` varchar(200) DEFAULT NULL COMMENT 'Email demandeur',
  `DDEMAN` date NOT NULL COMMENT 'Date demande',
  `HDEMAN` time NOT NULL COMMENT 'Heure demande',
  `CTELDI` varchar(20) DEFAULT NULL COMMENT 'Téléphone direct',
  `CSDOMA` varchar(20) DEFAULT NULL COMMENT 'Sous Domaine',
  `CTITRE` varchar(100) NOT NULL COMMENT 'Titre incident',
  `LCODEM` varchar(1000) DEFAULT NULL COMMENT 'Commentaire demande',
  `CODMEN` varchar(20) DEFAULT NULL COMMENT 'Code menu',
  `CJSP` varchar(20) DEFAULT NULL COMMENT 'Nom écran',
  `LSODEM` varchar(1000) DEFAULT NULL COMMENT 'Solution démandé',
  `NSEVER` char(1) NOT NULL COMMENT 'Sévérité',
  `NPRIOR` char(1) NOT NULL COMMENT 'Priorité',
  `CQACLI` varchar(2) DEFAULT NULL COMMENT 'Qualification client',
  `NSEVA3` char(1) DEFAULT NULL COMMENT 'Sévérité A3',
  `NPRIA3` char(1) DEFAULT NULL COMMENT 'Priorité A3',
  `CQAINT` varchar(2) DEFAULT NULL COMMENT 'Qualification A3',
  `BFACTU` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Incident à facturer',
  `BDPUOK` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'DPU incident signée',
  `CTITA3` varchar(100) DEFAULT NULL COMMENT 'Titre incident A3',
  `LINFCO` varchar(2000) DEFAULT NULL COMMENT 'Info complémentaire A3',
  `DAVANC` date DEFAULT NULL COMMENT 'Date avancement en cours',
  `NODAVA` decimal(3,0) DEFAULT NULL COMMENT 'Avancement',
  `LREPON` varchar(2000) DEFAULT NULL COMMENT 'Réponse A3',
  `DPLANI` date DEFAULT NULL COMMENT 'Date planifiée',
  `BMOJAV` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Modif Java',
  `BMORPG` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Modif RPG',
  `BMOSQL` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Modif SQL',
  `BMOJSP` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Modif Ecran',
  `BMODIC` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Modif Dictionnaire',
  `BMODWD` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Modif WINDEV',
  `BMOMAP` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Modif Mapping',
  `BMOPAR` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Modif Paramétrage',
  `BMOAUT` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Modif Autre',
  `CODORI` char(1) NOT NULL COMMENT 'Origine',
  `CSTAT1` varchar(5) DEFAULT NULL COMMENT 'Code analytique 1',
  `CSTAT2` varchar(5) DEFAULT NULL COMMENT 'Code analytique 2',
  `CSTAT3` varchar(5) DEFAULT NULL COMMENT 'Code analytique 3',
  `CCLIPE` varchar(10) DEFAULT NULL COMMENT 'Client Père',
  `BANNUL` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'désactivation',
  `DANNUL` date DEFAULT NULL COMMENT 'date désactivation',
  `CUSRCR` varchar(10) DEFAULT NULL COMMENT 'UTILISATEUR CREATION',
  `CPGMCR` varchar(10) DEFAULT NULL COMMENT 'programme cre',
  `TCREAT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Horodatage Creation',
  `CUSRMO` varchar(10) DEFAULT NULL COMMENT 'utilisateur modif',
  `CPGMMO` varchar(10) DEFAULT NULL COMMENT 'programme modif',
  `TMODIF` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date modification',
  `OBOO01` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 1',
  `OBOO02` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 2',
  `OBOO03` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 3',
  `OBOO04` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 4',
  `OBOO05` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 5',
  `OSTS01` varchar(10) DEFAULT NULL COMMENT 'Type dispo 1',
  `OSTS02` varchar(10) DEFAULT NULL COMMENT 'Type dispo 2',
  `OSTS03` varchar(10) DEFAULT NULL COMMENT 'Type dispo 3',
  `OSTS04` varchar(10) DEFAULT NULL COMMENT 'Type dispo 4',
  `OSTS05` varchar(10) DEFAULT NULL COMMENT 'Type dispo 5',
  `CPROA3` varchar(10) DEFAULT NULL COMMENT 'Qualification Produit A3',
  `CMODA3` varchar(10) DEFAULT NULL COMMENT 'Qualification Module A3',
  `LDIALO` varchar(2000) DEFAULT NULL COMMENT 'Zone dialogue',
  `CINCPE` varchar(20) DEFAULT NULL COMMENT 'Incident père',
  `NTICKE` decimal(5,0) DEFAULT NULL COMMENT 'Nombre ticket',
  `LINFRE` varchar(2000) DEFAULT NULL COMMENT 'Info reste à faire',
  `CUSRRE` varchar(10) DEFAULT NULL COMMENT 'Reste à faire Qui?',
  `CUSROR` varchar(10) DEFAULT NULL COMMENT 'Utilisateur origine',
  `CCLIOR` varchar(10) DEFAULT NULL COMMENT 'Client origine',
  `CPROOR` varchar(10) DEFAULT NULL COMMENT 'Produit application origine',
  PRIMARY KEY (`CINCID`,`CODCLI`),
  KEY `FK_SVPM01_SVPL01` (`CDPROJ`,`CODLOT`),
  KEY `FK_SVPM01_SVPC03` (`CODCLI`,`CPRODU`,`CMODUL`),
  KEY `M01CDPROJ` (`CDPROJ`),
  KEY `M01DDEMAN` (`DDEMAN`),
  KEY `M01CODCLI` (`CODCLI`),
  KEY `M01NODAVA` (`NODAVA`),
  KEY `M01CINCID` (`CINCID`),
  KEY `M01CPRODU` (`CPRODU`),
  KEY `M01CMODUL` (`CMODUL`),
  KEY `M01CTITRE` (`CTITRE`),
  KEY `M01NSEVER` (`NSEVER`),
  KEY `M01CQACLI` (`CQACLI`),
  KEY `M01NPRIOR` (`NPRIOR`),
  KEY `M01NSEVA3` (`NSEVA3`),
  KEY `M01NPRIA3` (`NPRIA3`),
  KEY `M01CPROA3` (`CPROA3`),
  KEY `M01CMODA3` (`CMODA3`),
  KEY `SVPM01YTOUVER` (`DDEMAN`,`HDEMAN`),
  CONSTRAINT `FK_SVPM01_SVPC03` FOREIGN KEY (`CODCLI`, `CPRODU`, `CMODUL`) REFERENCES `svpc03p0` (`CODCLI`, `CPRODU`, `CMODUL`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_SVPM01_SVPL01` FOREIGN KEY (`CDPROJ`, `CODLOT`) REFERENCES `svpl01p0` (`CDPROJ`, `CODLOT`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `PK_SVPM01_SVPC01` FOREIGN KEY (`CODCLI`) REFERENCES `svpc01p0` (`CODCLI`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Incidents'


CREATE TABLE `svpm04p0` (
  `XUMREL` decimal(4,0) NOT NULL,
  `CINCID` varchar(20) NOT NULL,
  `CODCLI` varchar(10) NOT NULL,
  `DRELAN` date NOT NULL,
  `HRELAN` time NOT NULL,
  `LCOMME` varchar(1000) DEFAULT NULL,
  `CRELAN` varchar(50) DEFAULT NULL,
  `LREMAI` varchar(200) DEFAULT NULL,
  `LRETEL` varchar(50) NOT NULL,
  `BANNUL` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'désactivation',
  `DANNUL` date DEFAULT NULL COMMENT 'date désactivation',
  `CUSRCR` varchar(10) DEFAULT NULL COMMENT 'UTILISATEUR CREATION',
  `CPGMCR` varchar(10) DEFAULT NULL COMMENT 'programme cre',
  `TCREAT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `CUSRMO` varchar(10) DEFAULT NULL COMMENT 'utilisateur modif',
  `CPGMMO` varchar(10) DEFAULT NULL COMMENT 'programme modif',
  `TMODIF` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `OBOO01` decimal(1,0) NOT NULL,
  `OBOO02` decimal(1,0) NOT NULL,
  `OBOO03` decimal(1,0) NOT NULL,
  `OBOO04` decimal(1,0) NOT NULL,
  `OBOO05` decimal(1,0) NOT NULL,
  `OSTS01` varchar(10) DEFAULT NULL,
  `OSTS02` varchar(10) DEFAULT NULL,
  `OSTS03` varchar(10) DEFAULT NULL,
  `OSTS04` varchar(10) DEFAULT NULL,
  `OSTS05` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`XUMREL`,`CINCID`,`CODCLI`),
  KEY `FK_SVPM04_SVPM01` (`CINCID`,`CODCLI`),
  KEY `M04CINCID` (`CINCID`),
  KEY `M04CODCLI` (`CODCLI`),
  KEY `M04DRELAN` (`DRELAN`),
  KEY `M04HRELAN` (`HRELAN`),
  KEY `M04LCOMME` (`LCOMME`(255)),
  KEY `M04CRELAN` (`CRELAN`),
  KEY `SVPM04Y0` (`CODCLI`,`CINCID`,`XUMREL`),
  CONSTRAINT `FK_SVPM04_SVPM01` FOREIGN KEY (`CINCID`, `CODCLI`) REFERENCES `svpm01p0` (`CINCID`, `CODCLI`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Relance client ' 


CREATE TABLE `svpm05p0` (
  `XVPM05` decimal(8,0) NOT NULL COMMENT 'Compteur',
  `CINCID` varchar(20) NOT NULL COMMENT 'Code incident',
  `CODCLI` varchar(10) NOT NULL COMMENT 'Code Client',
  `LDIALO` varchar(2000) NOT NULL COMMENT 'Zone de dialogue',
  `NODAVA` decimal(3,0) DEFAULT NULL COMMENT 'Avancement',
  `CDUSER` varchar(10) NOT NULL COMMENT 'Utilisateur',
  `LEMAIL` varchar(200) NOT NULL COMMENT 'Email',
  `DENVOI` date NOT NULL COMMENT 'Date d''envoi',
  `BANNUL` decimal(1,0) NOT NULL,
  `DANNUL` date DEFAULT NULL COMMENT 'date désactivation',
  `CUSRCR` varchar(10) DEFAULT NULL COMMENT 'UTILISATEUR CREATION',
  `CPGMCR` varchar(10) DEFAULT NULL COMMENT 'programme cre',
  `TCREAT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `CUSRMO` varchar(10) DEFAULT NULL COMMENT 'utilisateur modif',
  `CPGMMO` varchar(10) DEFAULT NULL COMMENT 'programme modif',
  `TMODIF` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `OBOO01` decimal(1,0) NOT NULL,
  `OBOO02` decimal(1,0) NOT NULL,
  `OBOO03` decimal(1,0) NOT NULL,
  `OBOO04` decimal(1,0) NOT NULL,
  `OBOO05` decimal(1,0) NOT NULL,
  `OSTS01` varchar(10) DEFAULT NULL COMMENT 'Type dispo 1',
  `OSTS02` varchar(10) DEFAULT NULL COMMENT 'Type dispo 2',
  `OSTS03` varchar(10) DEFAULT NULL COMMENT 'Type dispo 3',
  `OSTS04` varchar(10) DEFAULT NULL COMMENT 'Type dispo 4',
  `OSTS05` varchar(10) DEFAULT NULL COMMENT 'Type dispo 5',
  PRIMARY KEY (`XVPM05`,`CINCID`,`CODCLI`),
  KEY `FK_SVPM05_SVPM01` (`CINCID`,`CODCLI`),
  KEY `M05CINCID` (`CINCID`),
  KEY `M05CODCLI` (`CODCLI`),
  KEY `M05LDIALO` (`LDIALO`(255)),
  KEY `M05NODAVA` (`NODAVA`),
  KEY `M05CDUSER` (`CDUSER`),
  KEY `M05LEMAIL` (`LEMAIL`),
  KEY `M05TCREAT` (`TCREAT`),
  KEY `SVPM05Y0` (`TCREAT`),
  KEY `SVPM05Y1` (`CODCLI`,`CINCID`,`XVPM05`),
  CONSTRAINT `FK_SVPM05_SVPM01` FOREIGN KEY (`CINCID`, `CODCLI`) REFERENCES `svpm01p0` (`CINCID`, `CODCLI`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Historisation dialogue client' 

SVPD01P0 | CREATE TABLE `svpd01p0` (
  `XVPD01` decimal(15,0) NOT NULL,
  `CODCLI` varchar(10) NOT NULL,
  `CINCID` varchar(20) DEFAULT NULL,
  `XUMREL` decimal(4,0) DEFAULT NULL,
  `CODLOT` varchar(10) DEFAULT NULL,
  `CTYDOC` varchar(2) DEFAULT NULL,
  `CODVER` varchar(20) DEFAULT NULL,
  `DCRDOC` date NOT NULL,
  `CHEMIN` varchar(200) DEFAULT NULL,
  `LDESCR` varchar(200) DEFAULT NULL,
  `BREPON` decimal(1,0) NOT NULL DEFAULT '0',
  `BANNUL` decimal(1,0) NOT NULL,
  `DANNUL` date DEFAULT NULL COMMENT 'date désactivation',
  `CUSRCR` varchar(10) DEFAULT NULL COMMENT 'UTILISATEUR CREATION',
  `CPGMCR` varchar(10) DEFAULT NULL COMMENT 'programme cre',
  `TCREAT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `CUSRMO` varchar(10) DEFAULT NULL COMMENT 'utilisateur modif',
  `CPGMMO` varchar(10) DEFAULT NULL COMMENT 'programme modif',
  `TMODIF` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `OBOO01` decimal(1,0) NOT NULL,
  `OBOO02` decimal(1,0) NOT NULL,
  `OBOO03` decimal(1,0) NOT NULL,
  `OBOO04` decimal(1,0) NOT NULL,
  `OBOO05` decimal(1,0) NOT NULL,
  `OSTS01` varchar(10) DEFAULT NULL,
  `OSTS02` varchar(10) DEFAULT NULL,
  `OSTS03` varchar(10) DEFAULT NULL,
  `OSTS04` varchar(10) DEFAULT NULL,
  `OSTS05` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`XVPD01`),
  KEY `FK_SVPD01_SVPM01` (`CINCID`,`CODCLI`),
  KEY `D01CINCID` (`CINCID`),
  KEY `D01CODCLI` (`CODCLI`),
  KEY `SVPD01Y0` (`CODCLI`,`CINCID`,`XVPD01`),
  CONSTRAINT `FK_SVPD01_SVPC01` FOREIGN KEY (`CODCLI`) REFERENCES `svpc01p0` (`CODCLI`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_SVPD01_SVPM01` FOREIGN KEY (`CINCID`, `CODCLI`) REFERENCES `svpm01p0` (`CINCID`, `CODCLI`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Documents liés' 

CREATE TABLE `svpc01p0` (
  `CODCLI` varchar(10) NOT NULL COMMENT 'Code client',
  `LIBCLI` varchar(35) NOT NULL COMMENT 'Nom client',
  `LADR1` varchar(35) DEFAULT NULL COMMENT 'Adresse',
  `LADR2` varchar(35) DEFAULT NULL COMMENT 'Adress 2',
  `CCPOST` varchar(10) DEFAULT NULL COMMENT 'Code postal',
  `LVILLE` varchar(50) DEFAULT NULL COMMENT 'Ville',
  `CTELEP` varchar(20) DEFAULT NULL COMMENT 'Téléphone',
  `CODFAX` varchar(20) DEFAULT NULL COMMENT 'FAX',
  `LSIWEB` varchar(200) DEFAULT NULL COMMENT 'Site web',
  `LEMAIL` varchar(200) DEFAULT NULL COMMENT 'Email général',
  `CGRPCL` varchar(10) DEFAULT NULL COMMENT 'Code Groupe client',
  `CRESP1` varchar(10) NOT NULL COMMENT 'Reponsable A3',
  `BRECM1` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Reception EMail',
  `CRESP2` varchar(10) DEFAULT NULL COMMENT 'Responsable 2 A3',
  `CRESP3` varchar(10) DEFAULT NULL COMMENT 'Responsable 3 A3',
  `BSURVE` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'A surveiller',
  `BGROUP` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Groupe client',
  `LINSTR` varchar(500) DEFAULT NULL COMMENT 'Intsruction particulière',
  `LINTMA` varchar(500) DEFAULT NULL COMMENT 'Infos TMA',
  `LINTLV` varchar(500) DEFAULT NULL COMMENT 'Infos Livraison',
  `LCOMME` varchar(500) DEFAULT NULL COMMENT 'Commentaire',
  `LISTML` varchar(500) DEFAULT 'NULL',
  `BANNUL` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'désactivation',
  `DANNUL` date DEFAULT NULL COMMENT 'date désactivation',
  `CUSRCR` varchar(10) DEFAULT NULL COMMENT 'UTILISATEUR CREATION',
  `CPGMCR` varchar(10) DEFAULT NULL COMMENT 'programme cre',
  `TCREAT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `CUSRMO` varchar(10) DEFAULT NULL COMMENT 'utilisateur modif',
  `CPGMMO` varchar(10) DEFAULT NULL COMMENT 'programme modif',
  `TMODIF` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `OBOO01` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 1',
  `OBOO02` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 2',
  `OBOO03` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 3',
  `OBOO04` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 4',
  `OBOO05` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 5',
  `OSTS01` varchar(10) DEFAULT NULL,
  `OSTS02` varchar(10) DEFAULT NULL,
  `OSTS03` varchar(10) DEFAULT NULL,
  `OSTS04` varchar(10) DEFAULT NULL,
  `OSTS05` varchar(10) DEFAULT NULL,
  `LMAIRE` varchar(200) DEFAULT NULL,
  `CATOME` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`CODCLI`),
  KEY `FK_SVPC01_CFGG02_1` (`CRESP1`),
  KEY `FK_SVPC01_CFGG02_2` (`CRESP2`),
  KEY `FK_SVPC01_CFGG02_3` (`CRESP3`),
  KEY `C01CODCLI` (`CODCLI`),
  KEY `C01LIBCLI` (`LIBCLI`),
  CONSTRAINT `FK_SVPC01_CFGG02_1` FOREIGN KEY (`CRESP1`) REFERENCES `cfgg02p0` (`CDUSER`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_SVPC01_CFGG02_2` FOREIGN KEY (`CRESP2`) REFERENCES `cfgg02p0` (`CDUSER`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_SVPC01_CFGG02_3` FOREIGN KEY (`CRESP3`) REFERENCES `cfgg02p0` (`CDUSER`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Client' 

CREATE TABLE `svpc02p0` (
  `CODCLI` varchar(10) NOT NULL,
  `CPRODU` varchar(20) NOT NULL,
  `CURVER` varchar(10) DEFAULT NULL,
  `CDPROJ` varchar(3) DEFAULT NULL,
  `DPRINS` date DEFAULT NULL,
  `DINSVE` date DEFAULT NULL,
  `CRESP1` varchar(10) NOT NULL,
  `BRECM1` decimal(1,0) NOT NULL DEFAULT '0',
  `CRESP2` varchar(10) DEFAULT NULL,
  `CRESP3` varchar(10) DEFAULT NULL,
  `CRESCL` varchar(10) DEFAULT NULL,
  `BMACLI` decimal(1,0) NOT NULL DEFAULT '0',
  `NBUSER` varchar(10) DEFAULT NULL,
  `DDEMAR` date DEFAULT NULL,
  `DFIGAR` date DEFAULT NULL,
  `DTMADE` date DEFAULT NULL,
  `DTMAFI` date DEFAULT NULL,
  `BSURVE` decimal(1,0) NOT NULL,
  `BCOTMA` decimal(1,0) NOT NULL DEFAULT '0',
  `BSVPSP` decimal(1,0) NOT NULL DEFAULT '0',
  `BSVPET` decimal(1,0) NOT NULL DEFAULT '0',
  `LINSTR` varchar(500) DEFAULT NULL,
  `LINTMA` varchar(500) DEFAULT NULL,
  `LCOMME` varchar(500) DEFAULT NULL,
  `LISTML` varchar(500) DEFAULT NULL,
  `BANNUL` decimal(1,0) NOT NULL,
  `DANNUL` date DEFAULT NULL COMMENT 'date désactivation',
  `CUSRCR` varchar(10) DEFAULT NULL COMMENT 'UTILISATEUR CREATION',
  `CPGMCR` varchar(10) DEFAULT NULL COMMENT 'programme cre',
  `TCREAT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `CUSRMO` varchar(10) DEFAULT NULL COMMENT 'utilisateur modif',
  `CPGMMO` varchar(10) DEFAULT NULL COMMENT 'programme modif',
  `TMODIF` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `OBOO01` decimal(1,0) NOT NULL,
  `OBOO02` decimal(1,0) NOT NULL,
  `OBOO03` decimal(1,0) NOT NULL,
  `OBOO04` decimal(1,0) NOT NULL,
  `OBOO05` decimal(1,0) NOT NULL,
  `OSTS01` varchar(10) DEFAULT NULL,
  `OSTS02` varchar(10) DEFAULT NULL,
  `OSTS03` varchar(10) DEFAULT NULL,
  `OSTS04` varchar(10) DEFAULT NULL,
  `OSTS05` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`CODCLI`,`CPRODU`),
  KEY `FK_SVPC02_SVPP01` (`CPRODU`),
  KEY `FK_SVPC02_SVPR01` (`CDPROJ`),
  KEY `FK_SVPC02_CFGG02_1` (`CRESP1`),
  KEY `FK_SVPC02_CFGG02_2` (`CRESP2`),
  KEY `FK_SVPC02_CFGG02_3` (`CRESP3`),
  CONSTRAINT `FK_SVPC01_SVPP01` FOREIGN KEY (`CODCLI`) REFERENCES `svpc01p0` (`CODCLI`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_SVPC02_CFGG02_1` FOREIGN KEY (`CRESP1`) REFERENCES `cfgg02p0` (`CDUSER`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_SVPC02_CFGG02_2` FOREIGN KEY (`CRESP2`) REFERENCES `cfgg02p0` (`CDUSER`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_SVPC02_CFGG02_3` FOREIGN KEY (`CRESP3`) REFERENCES `cfgg02p0` (`CDUSER`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_SVPC02_SVPP01` FOREIGN KEY (`CPRODU`) REFERENCES `svpp01p0` (`CPRODU`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_SVPC02_SVPR01` FOREIGN KEY (`CDPROJ`) REFERENCES `svpr01p0` (`CDPROJ`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Client Produit' 

CREATE TABLE `svpc03p0` (
  `CODCLI` varchar(10) NOT NULL,
  `CPRODU` varchar(20) NOT NULL,
  `CMODUL` varchar(10) NOT NULL,
  `CURVER` varchar(10) DEFAULT NULL,
  `DPRINS` date DEFAULT NULL,
  `DINSVE` date DEFAULT NULL,
  `CRESP1` varchar(10) NOT NULL,
  `BRECM1` decimal(1,0) NOT NULL DEFAULT '0',
  `CRESP2` varchar(10) DEFAULT NULL,
  `CRESP3` varchar(10) DEFAULT NULL,
  `CRESCL` varchar(10) DEFAULT NULL,
  `BMACLI` decimal(1,0) NOT NULL DEFAULT '0',
  `DDEMAR` date DEFAULT NULL,
  `BSURVE` decimal(1,0) NOT NULL DEFAULT '0',
  `BSVPSP` decimal(1,0) NOT NULL DEFAULT '0',
  `BSVPET` decimal(1,0) NOT NULL DEFAULT '0',
  `LINSTR` varchar(500) DEFAULT NULL,
  `LINTMA` varchar(500) DEFAULT NULL,
  `LCOMME` varchar(500) DEFAULT NULL,
  `LISTML` varchar(500) DEFAULT NULL,
  `BANNUL` decimal(1,0) NOT NULL,
  `DANNUL` date DEFAULT NULL COMMENT 'date désactivation',
  `CUSRCR` varchar(10) DEFAULT NULL COMMENT 'UTILISATEUR CREATION',
  `CPGMCR` varchar(10) DEFAULT NULL COMMENT 'programme cre',
  `TCREAT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `CUSRMO` varchar(10) DEFAULT NULL COMMENT 'utilisateur modif',
  `CPGMMO` varchar(10) DEFAULT NULL COMMENT 'programme modif',
  `TMODIF` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `OBOO01` decimal(1,0) NOT NULL,
  `OBOO02` decimal(1,0) NOT NULL,
  `OBOO03` decimal(1,0) NOT NULL,
  `OBOO04` decimal(1,0) NOT NULL,
  `OBOO05` decimal(1,0) NOT NULL,
  `OSTS01` varchar(10) DEFAULT NULL,
  `OSTS02` varchar(10) DEFAULT NULL,
  `OSTS03` varchar(10) DEFAULT NULL,
  `OSTS04` varchar(10) DEFAULT NULL,
  `OSTS05` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`CODCLI`,`CPRODU`,`CMODUL`),
  KEY `FK_SVPC03_SVPP02` (`CPRODU`,`CMODUL`),
  KEY `FK_SVPC03_CFGG02_1` (`CRESP1`),
  KEY `FK_SVPC03P0_CFGG02` (`CRESP2`),
  KEY `FK_SVPC03_CFGG02_3` (`CRESP3`),
  CONSTRAINT `FK_SVPC03P0_CFGG02` FOREIGN KEY (`CRESP2`) REFERENCES `cfgg02p0` (`CDUSER`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_SVPC03_CFGG02_1` FOREIGN KEY (`CRESP1`) REFERENCES `cfgg02p0` (`CDUSER`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_SVPC03_CFGG02_3` FOREIGN KEY (`CRESP3`) REFERENCES `cfgg02p0` (`CDUSER`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_SVPC03_SVPC02` FOREIGN KEY (`CODCLI`, `CPRODU`) REFERENCES `svpc02p0` (`CODCLI`, `CPRODU`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_SVPC03_SVPP01` FOREIGN KEY (`CPRODU`) REFERENCES `svpp01p0` (`CPRODU`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_SVPC03_SVPP02` FOREIGN KEY (`CPRODU`, `CMODUL`) REFERENCES `svpp02p0` (`CPRODU`, `CMODUL`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Client Produit Modules'

SVPP02P0 | CREATE TABLE `svpp02p0` (
  `CPRODU` varchar(20) NOT NULL,
  `CMODUL` varchar(10) NOT NULL,
  `LLIBEL` varchar(35) DEFAULT NULL,
  `CRESMO` varchar(10) DEFAULT NULL,
  `CODVER` varchar(10) DEFAULT NULL,
  `BANNUL` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'désactivation',
  `DANNUL` date DEFAULT NULL COMMENT 'date désactivation',
  `CUSRCR` varchar(10) DEFAULT NULL COMMENT 'UTILISATEUR CREATION',
  `CPGMCR` varchar(10) DEFAULT NULL COMMENT 'programme cre',
  `TCREAT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `CUSRMO` varchar(10) DEFAULT NULL COMMENT 'utilisateur modif',
  `CPGMMO` varchar(10) DEFAULT NULL COMMENT 'programme modif',
  `TMODIF` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `OBOO01` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 1',
  `OBOO02` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 2',
  `OBOO03` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 3',
  `OBOO04` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 4',
  `OBOO05` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 5',
  `OSTS01` varchar(10) DEFAULT NULL,
  `OSTS02` varchar(10) DEFAULT NULL,
  `OSTS03` varchar(10) DEFAULT NULL,
  `OSTS04` varchar(10) DEFAULT NULL,
  `OSTS05` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`CPRODU`,`CMODUL`),
  KEY `FK_SVPP02_CFGG02` (`CRESMO`),
  KEY `P02CPRODU` (`CPRODU`),
  KEY `P02CMODUL` (`CMODUL`),
  CONSTRAINT `FK_SVPP02_CFGG02` FOREIGN KEY (`CRESMO`) REFERENCES `cfgg02p0` (`CDUSER`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_SVPP02_SVPP01` FOREIGN KEY (`CPRODU`) REFERENCES `svpp01p0` (`CPRODU`) ON DELETE NO ACTION ON UPDATE NO ACTION


CREATE TABLE `svpp01p0` (
  `CPRODU` varchar(20) NOT NULL,
  `LIBPRO` varchar(35) NOT NULL,
  `CODVER` varchar(10) DEFAULT NULL,
  `CRESPO` varchar(10) DEFAULT NULL,
  `BANNUL` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'désactivation',
  `DANNUL` date DEFAULT NULL COMMENT 'date désactivation',
  `CUSRCR` varchar(10) DEFAULT NULL COMMENT 'UTILISATEUR CREATION',
  `CPGMCR` varchar(10) DEFAULT NULL COMMENT 'programme cre',
  `TCREAT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `CUSRMO` varchar(10) DEFAULT NULL COMMENT 'utilisateur modif',
  `CPGMMO` varchar(10) DEFAULT NULL COMMENT 'programme modif',
  `TMODIF` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `OBOO01` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 1',
  `OBOO02` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 2',
  `OBOO03` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 3',
  `OBOO04` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 4',
  `OBOO05` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 5',
  `OSTS01` varchar(10) DEFAULT NULL,
  `OSTS02` varchar(10) DEFAULT NULL,
  `OSTS03` varchar(10) DEFAULT NULL,
  `OSTS04` varchar(10) DEFAULT NULL,
  `OSTS05` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`CPRODU`),
  KEY `FK_SVPP01_CFGG02` (`CRESPO`),
  KEY `P01CPRODU` (`CPRODU`),
  KEY `P01CODVER` (`CODVER`),
  CONSTRAINT `FK_SVPP01_CFGG02` FOREIGN KEY (`CRESPO`) REFERENCES `cfgg02p0` (`CDUSER`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Produits A3'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Module par produit' 

CREATE TABLE `svpi02p0` (
  `XVPI02` decimal(8,0) NOT NULL COMMENT 'Compteur',
  `CDUSER` varchar(10) NOT NULL COMMENT 'Utilisateur',
  `CPRODU` varchar(20) DEFAULT NULL COMMENT 'Code produit',
  `CMODUL` varchar(10) DEFAULT NULL COMMENT 'Code Module',
  `CODCLI` varchar(10) DEFAULT NULL COMMENT 'Code client',
  `CINCTY` varchar(3) DEFAULT NULL COMMENT 'Type incident',
  `DDATIN` date NOT NULL COMMENT 'Date d''inscrption',
  `BINACT` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Inscription active',
  `BANNUL` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'désactivation',
  `DANNUL` date DEFAULT NULL COMMENT 'date désactivation',
  `CUSRCR` varchar(10) DEFAULT NULL COMMENT 'UTILISATEUR CREATION',
  `CPGMCR` varchar(10) DEFAULT NULL COMMENT 'programme cre',
  `TCREAT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `CUSRMO` varchar(10) DEFAULT NULL COMMENT 'utilisateur modif',
  `CPGMMO` varchar(10) DEFAULT NULL COMMENT 'programme modif',
  `TMODIF` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `OBOO01` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 1',
  `OBOO02` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 2',
  `OBOO03` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 3',
  `OBOO04` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 4',
  `OBOO05` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Booleen dispo 5',
  `OSTS01` varchar(10) DEFAULT NULL COMMENT 'Type dispo 1',
  `OSTS02` varchar(10) DEFAULT NULL COMMENT 'Type dispo 2',
  `OSTS03` varchar(10) DEFAULT NULL COMMENT 'Type dispo 3',
  `OSTS04` varchar(10) DEFAULT NULL COMMENT 'Type dispo 4',
  `OSTS05` varchar(10) DEFAULT NULL COMMENT 'Type dispo 5',
  PRIMARY KEY (`XVPI02`),
  KEY `FK_SVPI02_SVPC03` (`CODCLI`,`CPRODU`,`CMODUL`),
  KEY `I02CDUSER` (`CDUSER`),
  KEY `I02CPRODU` (`CPRODU`),
  KEY `I02CMODUL` (`CMODUL`),
  KEY `I02CODCLI` (`CODCLI`),
  KEY `I02CINCTY` (`CINCTY`),
  CONSTRAINT `FK_SVPI02_SVPC01` FOREIGN KEY (`CODCLI`) REFERENCES `svpc01p0` (`CODCLI`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_SVPI02_SVPC02` FOREIGN KEY (`CODCLI`, `CPRODU`) REFERENCES `svpc02p0` (`CODCLI`, `CPRODU`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_SVPI02_SVPC03` FOREIGN KEY (`CODCLI`, `CPRODU`, `CMODUL`) REFERENCES `svpc03p0` (`CODCLI`, `CPRODU`, `CMODUL`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_SVPI02_SVPG02` FOREIGN KEY (`CDUSER`) REFERENCES `cfgg02p0` (`CDUSER`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_SVPI02_SVPP01` FOREIGN KEY (`CPRODU`) REFERENCES `svpp01p0` (`CPRODU`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Inscription SVP'

CREATE TABLE `cfgg02p0` (
  `CDUSER` varchar(10) NOT NULL DEFAULT '',
  `CDGROU` varchar(10) NOT NULL DEFAULT '',
  `LUSER` varchar(35) DEFAULT NULL,
  `CDPAWD` varchar(10) DEFAULT NULL,
  `CDLANG` char(2) DEFAULT NULL,
  `CREGIO` char(2) DEFAULT NULL,
  `CFONTO` char(2) DEFAULT NULL,
  `CFORDA` varchar(10) NOT NULL DEFAULT '',
  `CFORDS` varchar(10) NOT NULL DEFAULT '',
  `CENVIR` char(2) DEFAULT NULL,
  `CDIVIS` char(1) DEFAULT NULL,
  `CAPPLI` char(3) DEFAULT NULL,
  `CPOLIC` varchar(50) DEFAULT NULL,
  `CTAILL` varchar(10) DEFAULT NULL,
  `CCOCLE` varchar(15) DEFAULT NULL,
  `CCOOBL` varchar(15) DEFAULT NULL,
  `CCOFAC` varchar(15) DEFAULT NULL,
  `CCOGR1` varchar(15) DEFAULT NULL,
  `CCOGR2` varchar(15) DEFAULT NULL,
  `LEMAIL` varchar(100) DEFAULT NULL,
  `BGESTC` decimal(1,0) NOT NULL DEFAULT '0',
  `BGBURE` decimal(1,0) NOT NULL DEFAULT '0',
  `BGBUOP` decimal(1,0) NOT NULL DEFAULT '0',
  `DANNUL` date DEFAULT NULL,
  `BANNUL` decimal(1,0) NOT NULL DEFAULT '0',
  `CUSRCR` varchar(10) DEFAULT NULL,
  `TCREAT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `CPGMCR` varchar(10) DEFAULT NULL,
  `CUSRMO` varchar(10) DEFAULT NULL,
  `TMODIF` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `CPGMMO` varchar(10) DEFAULT NULL,
  `GSPDEC` char(1) DEFAULT NULL,
  `GBROUV` char(1) DEFAULT NULL,
  `CPOOLC` varchar(20) DEFAULT NULL,
  `GTYMEN` char(2) DEFAULT NULL,
  `BPWPER` decimal(1,0) NOT NULL DEFAULT '0',
  `BPWAUT` decimal(1,0) NOT NULL DEFAULT '0',
  `NPWDUR` decimal(3,0) NOT NULL DEFAULT '0',
  `DPWVAL` date NOT NULL DEFAULT '0000-00-00',
  `NPWHIS` decimal(2,0) NOT NULL DEFAULT '0',
  `LPWHIS` text,
  `OSTS01` char(1) DEFAULT NULL,
  `OSTS02` char(1) DEFAULT NULL,
  `OSTS03` char(1) DEFAULT NULL,
  `OSTS04` char(1) DEFAULT NULL,
  `OSTS05` char(1) DEFAULT NULL,
  `OBOO01` decimal(1,0) NOT NULL DEFAULT '0',
  `OBOO02` decimal(1,0) NOT NULL DEFAULT '0',
  `OBOO03` decimal(1,0) NOT NULL DEFAULT '0',
  `OBOO04` decimal(1,0) NOT NULL DEFAULT '0',
  `OBOO05` decimal(1,0) NOT NULL DEFAULT '0',
  PRIMARY KEY (`CDUSER`),
  KEY `Ind_CFGG02P0_1` (`CENVIR`,`CDIVIS`),
  KEY `Ind_CFGG02P0_2` (`CPOOLC`),
  KEY `Ind_CFGG02P0_3` (`CENVIR`),
  KEY `Ind_CFGG02P0_4` (`CDGROU`),
  KEY `cfgg02Y0` (`CDUSER`),
  KEY `cfgg02Y1` (`CDUSER`,`CDGROU`),
  CONSTRAINT `FK_CFGG02_CFGG09` FOREIGN KEY (`CDGROU`) REFERENCES `cfgg09p0` (`CDGROU`),
  CONSTRAINT `FK_CFGG02_CFGG11` FOREIGN KEY (`CPOOLC`) REFERENCES `cfgg11p0` (`CPOOLC`),
  CONSTRAINT `FK_CFGG02_CFGG25` FOREIGN KEY (`CENVIR`) REFERENCES `cfgg25p0` (`CENVIG`),
  CONSTRAINT `FK_CFGG02_GENT21` FOREIGN KEY (`CENVIR`, `CDIVIS`) REFERENCES `gent21p0` (`CENVIG`, `CDIVIS`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8