CREATE TABLE `svpi01p0` (
  `CODCLI` varchar(10) NOT NULL,
  `CDUSER` varchar(10) NOT NULL,
  `BCRLOT` decimal(1,0) NOT NULL DEFAULT '0',
  `BSULOT` decimal(1,0) NOT NULL DEFAULT '0',
  `BCREFA` decimal(1,0) NOT NULL DEFAULT '0',
  `BQUAFA` decimal(1,0) NOT NULL DEFAULT '0',
  `BREPFA` decimal(1,0) NOT NULL DEFAULT '0',
  `BCREVE` decimal(1,0) NOT NULL DEFAULT '0',
  `BUSRA3` decimal(1,0) NOT NULL DEFAULT '0',
  `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 'date heure cre',
  `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,
  `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`,`CDUSER`),
  KEY `I01CODCLI` (`CODCLI`),
  KEY `I01CDUSER` (`CDUSER`),
  CONSTRAINT `FK_SVPI01_CFGG02` FOREIGN KEY (`CDUSER`) REFERENCES `cfgg02p0` (`CDUSER`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_SVPI01_SVPC01` FOREIGN KEY (`CODCLI`) REFERENCES `svpc01p0` (`CODCLI`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Intervenant client'