13session var1 vaut :apb13
CREATE TABLE `capb13` ( `id_connect` smallint(6) NOT NULL, `type` varchar(1) NOT NULL, `typfav` varchar(2) DEFAULT NULL, `NTM1` varchar(2) NOT NULL, `NTM2` varchar(2) NOT NULL, `NTM3` text NOT NULL, `libelle_dossier` text NOT NULL, `url_params` varchar(250) NOT NULL, `url_libelle` varchar(250) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `un` varchar(50) NOT NULL, `pw` varchar(50) NOT NULL, `Code_Activ` varchar(50) NOT NULL `date_saisie` date NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;ALTER TABLE `capb13` ADD UNIQUE KEY `id_connect` (`id_connect`);ALTER TABLE `capb13` MODIFY `id_connect` smallint(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;INSERT INTO `capb13` (`id_connect`, `type`, `typfav`, `NTM1`, `NTM2`, `NTM3`, `libelle_dossier`, `url_params`, `url_libelle`, `un`, `pw`, `Code_Activ`, `date_saisie`) VALUES(2, 'L', 'F1', '09', '01', '0', '00 / Divers', 'http://www.swisscom.com/login', 'SWISSCOM LOGIN', 'michel_walter7', 'm...77', 'F4aLCtOOrc', '2022-03-10');CREATE TABLE `csapb13` ( `id_connect` smallint(6) NOT NULL, `type` varchar(1) NOT NULL, `NTM1` text NOT NULL, `NTM2` text NOT NULL, `NTM3` text NOT NULL, `libelle_dossier` text NOT NULL, `url_params` varchar(250) NOT NULL, `url_libelle` varchar(250) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `un` varchar(50) NOT NULL, `pw` varchar(50) NOT NULL, `Code_Activ` varchar(50) NOT NULL, `d_echeance` date NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;ALTER TABLE `csapb13` ADD UNIQUE KEY `id_connect` (`id_connect`);ALTER TABLE `csapb13` MODIFY `id_connect` smallint(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;INSERT INTO `csapb13` (`id_connect`, `type`, `NTM1`, `NTM2`, `NTM3`, `libelle_dossier`, `url_params`, `url_libelle`, `un`, `pw`, `Code_Activ`, `d_echeance`) VALUES(386, 'F', '01', '01', '', '', 'resources-1/01/01/161020_cosmetique.txt', '161020_cosmetique.txt', 'un1', '-', '-', '0000-00-00');CREATE TABLE `dsapb13` ( `id_dossier` int(11) NOT NULL, `Niveau` int(11) NOT NULL, `NTM1` varchar(2) NOT NULL, `NTM2` varchar(2) NOT NULL, `Nom_Dossier` text NOT NULL, `nbreclic` int(11) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;ALTER TABLE `dsapb13` ADD PRIMARY KEY (`id_dossier`), ADD UNIQUE KEY `id_dossier` (`id_dossier`), ADD KEY `id_dossier_2` (`id_dossier`);INSERT INTO `dsapb13` (`id_dossier`, `Niveau`, `NTM1`, `NTM2`, `Nom_Dossier`, `nbreclic`) VALUES(1, 1, '01', '00', 'DEVEL', 0),(2, 2, '01', '01', 'TXT', 0),(3, 2, '01', '02', 'Codes Sources', 0);ALTER TABLE `dsapb13` MODIFY `id_dossier` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;CREATE TABLE `m01apb13` ( `II` int(11) NOT NULL, `XX` text CHARACTER SET latin1 NOT NULL, `CPU` int(11) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;INSERT INTO `m01apb13` (`II`, `XX`, `CPU`) VALUES(1, '', 4676438);ALTER TABLE `m01apb13` ADD PRIMARY KEY (`II`);ALTER TABLE `m01apb13` CHANGE `II` `II` INT(11) NOT NULL AUTO_INCREMENT;CREATE TABLE `m02apb13` ( `II` int(11) NOT NULL, `SJ` text NOT NULL, `BoY` text NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;