INSERT INTO `dginterior_details` (`id`, `duct_id`, `di`, `di2`, `nature_paroi`, `epais_paroi`, `rugo_paroi_int`, `isolant`, `epais_iso`, `cond_therm`, `resist_therm`, `rugo_paroi_air_int`, `largeur_air`, `rugo_paroi_air_ext`, `nature_paroi_ext`, `comp_ext`, `d_ext`, `dist_secu`, `mesure_dist_secu`, `dist_secu_en`, `mise_oeuvre_m`, `mise_oeuvre_l`, `created_at`, `updated_at`, `dist_secu2`) VALUES
(1262, 382, 200, NULL, 'L20 - Inox AISI 304 - X5CrNi 18-10', 0.4, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2020-08-28 08:06:00', '0000-00-00 00:00:00', NULL),
(1263, 383, 125, NULL, 'L20 - Inox AISI 304 - X5CrNi 18-10', 0.4, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2020-08-28 08:09:30', '0000-00-00 00:00:00', NULL),
(1264, 383, 139, NULL, 'L20 - Inox AISI 304 - X5CrNi 18-10', 0.4, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2020-08-28 08:09:30', '0000-00-00 00:00:00', NULL),
(1265, 383, 153, NULL, 'L20 - Inox AISI 304 - X5CrNi 18-10', 0.4, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2020-08-28 08:09:30', '0000-00-00 00:00:00', NULL),
(1266, 383, 180, NULL, 'L20 - Inox AISI 304 - X5CrNi 18-10', 0.4, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2020-08-28 08:09:30', '0000-00-00 00:00:00', NULL),
(1267, 383, 200, NULL, 'L20 - Inox AISI 304 - X5CrNi 18-10', 0.4, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2020-08-28 08:09:30', '0000-00-00 00:00:00', NULL),
(1268, 385, 80, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 86, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-08-28 08:21:38', '0000-00-00 00:00:00', NULL),
(1269, 385, 100, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 106, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-08-28 08:21:38', '0000-00-00 00:00:00', NULL),
(1270, 385, 125, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 131, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-08-28 08:21:38', '0000-00-00 00:00:00', NULL),
(1271, 385, 150, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 156, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-08-28 08:21:38', '0000-00-00 00:00:00', NULL),
(1272, 385, 180, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 186, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-08-28 08:21:38', '0000-00-00 00:00:00', NULL),
(1273, 385, 200, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 206, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-08-28 08:21:38', '0000-00-00 00:00:00', NULL),
(1274, 385, 250, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 256, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-08-28 08:21:38', '0000-00-00 00:00:00', NULL),
(1275, 386, 80, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-08-28 08:25:03', '0000-00-00 00:00:00', NULL),
(1276, 386, 100, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-08-28 08:25:15', '0000-00-00 00:00:00', NULL),
(1277, 386, 130, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-08-28 08:25:21', '0000-00-00 00:00:00', NULL),
(1278, 386, 150, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-08-28 08:25:35', '0000-00-00 00:00:00', NULL),
(1279, 386, 180, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-08-28 08:25:42', '0000-00-00 00:00:00', NULL),
(1280, 387, 80, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-08-28 08:25:52', '0000-00-00 00:00:00', NULL),
(1281, 387, 100, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-08-28 08:25:52', '0000-00-00 00:00:00', NULL),
(1282, 387, 130, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-08-28 08:25:52', '0000-00-00 00:00:00', NULL),
(1283, 387, 150, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-08-28 08:25:52', '0000-00-00 00:00:00', NULL),
(1284, 387, 180, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-08-28 08:25:52', '0000-00-00 00:00:00', NULL),
(1285, 377, 80, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, NULL, NULL, NULL, NULL, 1, 22.5, 1, 'Inox 304', 'Oui', 125, '100', NULL, NULL, NULL, NULL, '2020-08-29 16:49:01', '0000-00-00 00:00:00', NULL),
(1286, 377, 100, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, NULL, NULL, NULL, NULL, 1, 25, 1, 'Inox 304', 'Oui', 150, '100', NULL, NULL, NULL, NULL, '2020-08-29 16:49:43', '0000-00-00 00:00:00', NULL),
(1287, 377, 130, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, NULL, NULL, NULL, NULL, 1, 35, 1, 'Inox 304', 'Oui', 200, '100', NULL, NULL, NULL, NULL, '2020-08-29 16:50:14', '0000-00-00 00:00:00', NULL),
(1288, 377, 150, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, NULL, NULL, NULL, NULL, 1, 25, 1, 'Inox 304', 'Oui', 200, '100', NULL, NULL, NULL, NULL, '2020-08-29 16:50:44', '0000-00-00 00:00:00', NULL),
(1289, 377, 180, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, NULL, NULL, NULL, NULL, 1, 35, 1, 'Inox 304', 'Oui', 250, '100', NULL, NULL, NULL, NULL, '2020-08-29 16:51:09', '0000-00-00 00:00:00', NULL),
(1290, 378, 80, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, NULL, NULL, NULL, NULL, 1, 22.5, 1, 'Inox 304', 'Oui', 125, '100', NULL, NULL, NULL, NULL, '2020-08-29 17:01:40', '0000-00-00 00:00:00', NULL),
(1291, 378, 100, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, NULL, NULL, NULL, NULL, 1, 25, 1, 'Inox 304', 'Oui', 150, '100', NULL, NULL, NULL, NULL, '2020-08-29 17:02:16', '0000-00-00 00:00:00', NULL),
(1292, 378, 130, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, NULL, NULL, NULL, NULL, 1, 35, 1, 'Inox 304', 'Oui', 200, '100', NULL, NULL, NULL, NULL, '2020-08-29 17:02:36', '0000-00-00 00:00:00', NULL),
(1293, 378, 150, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, NULL, NULL, NULL, NULL, 1, 25, 1, 'Inox 304', 'Oui', 200, '100', NULL, NULL, NULL, NULL, '2020-08-29 17:02:55', '0000-00-00 00:00:00', NULL),
(1294, 378, 180, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, NULL, NULL, NULL, NULL, 1, 35, 1, 'Inox 304', 'Oui', 250, '100', NULL, NULL, NULL, NULL, '2020-08-29 17:03:20', '0000-00-00 00:00:00', NULL),
(1295, 379, 80, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, NULL, NULL, NULL, NULL, 1, 22.5, 1, 'Inox 304', 'Oui', 125, '100', NULL, NULL, NULL, NULL, '2020-08-29 17:06:05', '0000-00-00 00:00:00', NULL),
(1296, 379, 100, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, NULL, NULL, NULL, NULL, 1, 25, 1, 'Inox 304', 'Oui', 150, '100', NULL, NULL, NULL, NULL, '2020-08-29 17:06:34', '0000-00-00 00:00:00', NULL),
(1297, 379, 130, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, NULL, NULL, NULL, NULL, 1, 35, 1, 'Inox 304', 'Oui', 200, '100', NULL, NULL, NULL, NULL, '2020-08-29 17:06:56', '0000-00-00 00:00:00', NULL),
(1298, 379, 150, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, NULL, NULL, NULL, NULL, 1, 25, 1, 'Inox 304', 'Oui', 200, '100', NULL, NULL, NULL, NULL, '2020-08-29 17:07:14', '0000-00-00 00:00:00', NULL),
(1299, 379, 180, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, NULL, NULL, NULL, NULL, 1, 35, 1, 'Inox 304', 'Oui', 250, '100', NULL, NULL, NULL, NULL, '2020-08-29 17:07:36', '0000-00-00 00:00:00', NULL),
(1300, 380, 80, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, NULL, NULL, NULL, NULL, 1, 22.5, 1, 'Inox 304', 'Oui', 125, '100', NULL, NULL, NULL, NULL, '2020-08-29 17:10:03', '0000-00-00 00:00:00', NULL),
(1301, 380, 100, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, NULL, NULL, NULL, NULL, 1, 25, 1, 'Inox 304', 'Oui', 150, '100', NULL, NULL, NULL, NULL, '2020-08-29 17:10:27', '0000-00-00 00:00:00', NULL),
(1302, 380, 130, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, NULL, NULL, NULL, NULL, 1, 35, 1, 'Inox 304', 'Oui', 200, '100', NULL, NULL, NULL, NULL, '2020-08-29 17:10:49', '0000-00-00 00:00:00', NULL),
(1303, 380, 150, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, NULL, NULL, NULL, NULL, 1, 25, 1, 'Inox 304', 'Oui', 200, '100', NULL, NULL, NULL, NULL, '2020-08-29 17:11:07', '0000-00-00 00:00:00', NULL),
(1304, 380, 180, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, NULL, NULL, NULL, NULL, 1, 35, 1, 'Inox 304', 'Oui', 250, '100', NULL, NULL, NULL, NULL, '2020-08-29 17:11:27', '0000-00-00 00:00:00', NULL),
(1305, 221, 80, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 45, '2020-09-14 18:39:09', '0000-00-00 00:00:00', NULL),
(1306, 305, 100, NULL, 'L70 - Inox AISI 904L - X1NiCrMoCu 25-20-5', 0.1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 45, '2020-09-18 06:10:07', '0000-00-00 00:00:00', NULL),
(1307, 388, 80, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-10-02 07:10:08', '0000-00-00 00:00:00', NULL),
(1308, 388, 100, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-10-02 07:10:08', '0000-00-00 00:00:00', NULL),
(1309, 388, 130, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-10-02 07:10:08', '0000-00-00 00:00:00', NULL),
(1310, 388, 150, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-10-02 07:10:08', '0000-00-00 00:00:00', NULL),
(1311, 388, 180, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-10-02 07:10:08', '0000-00-00 00:00:00', NULL),
(1312, 389, 80, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-10-02 07:12:25', '0000-00-00 00:00:00', NULL),
(1313, 389, 100, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-10-02 07:12:25', '0000-00-00 00:00:00', NULL),
(1314, 389, 130, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-10-02 07:12:25', '0000-00-00 00:00:00', NULL),
(1315, 389, 150, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-10-02 07:12:25', '0000-00-00 00:00:00', NULL),
(1316, 389, 180, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-10-02 07:12:25', '0000-00-00 00:00:00', NULL),
(1317, 390, 80, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 25, 1.5, 'Laine de roche', 25, 0.42, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-10-26 13:28:24', '0000-00-00 00:00:00', NULL),
(1318, 390, 100, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 25, 1.5, 'Laine de roche', 25, 0.42, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-10-26 13:28:30', '0000-00-00 00:00:00', NULL),
(1319, 390, 130, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 25, 1.5, 'Laine de roche', 25, 0.42, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-10-26 13:28:39', '0000-00-00 00:00:00', NULL),
(1320, 390, 150, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 25, 1.5, 'Laine de roche', 25, 0.42, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-10-26 13:28:49', '0000-00-00 00:00:00', NULL),
(1321, 390, 180, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 25, 1.5, 'Laine de roche', 25, 0.42, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-10-26 13:29:04', '0000-00-00 00:00:00', NULL),
(1322, 391, 80, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1.5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-10-26 13:33:12', '0000-00-00 00:00:00', NULL),
(1323, 391, 100, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1.5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-10-26 13:33:23', '0000-00-00 00:00:00', NULL),
(1324, 391, 130, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1.5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-10-26 13:33:28', '0000-00-00 00:00:00', NULL),
(1325, 391, 150, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1.5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-10-26 13:33:32', '0000-00-00 00:00:00', NULL),
(1326, 391, 180, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1.5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-10-26 13:33:37', '0000-00-00 00:00:00', NULL),
(1327, 391, 200, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1.5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-10-26 13:33:42', '0000-00-00 00:00:00', NULL),
(1328, 392, 80, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.06, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 45, '2020-10-27 07:31:20', '0000-00-00 00:00:00', NULL),
(1329, 392, 100, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.06, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 45, '2020-10-27 07:31:24', '0000-00-00 00:00:00', NULL),
(1330, 392, 130, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.06, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 45, '2020-10-27 07:31:28', '0000-00-00 00:00:00', NULL),
(1331, 392, 150, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.06, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 45, '2020-10-27 07:31:32', '0000-00-00 00:00:00', NULL),
(1332, 392, 180, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, 'Laine de roche', 25, 0.06, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 45, '2020-10-27 07:31:36', '0000-00-00 00:00:00', NULL),
(1333, 293, 130, NULL, 'L80 - Acier émaillé par vitrification double face', 1.2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2020-11-06 18:42:16', '0000-00-00 00:00:00', NULL),
(1334, 293, 180, NULL, 'L80 - Acier émaillé par vitrification double face', 1.2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2020-11-06 18:42:41', '0000-00-00 00:00:00', NULL),
(1335, 293, 200, NULL, 'L80 - Acier émaillé par vitrification double face', 1.2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2020-11-06 18:43:09', '0000-00-00 00:00:00', NULL),
(1336, 393, 80, NULL, 'L80 - Acier émaillé par vitrification double face', 0.6, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2020-11-06 18:47:21', '0000-00-00 00:00:00', NULL),
(1337, 393, 100, NULL, 'L80 - Acier émaillé par vitrification double face', 0.6, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2020-11-06 18:47:32', '0000-00-00 00:00:00', NULL),
(1338, 227, 150, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, NULL, NULL, NULL, NULL, 1, 25, 1, 'Inox 304', 'Non', 200, '100', NULL, NULL, NULL, NULL, '2020-12-18 12:20:42', '0000-00-00 00:00:00', NULL),
(1339, 227, 130, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, NULL, NULL, NULL, NULL, 1, 35, 1, 'Inox 304', 'Non', 200, '100', NULL, NULL, NULL, NULL, '2020-12-18 12:21:56', '0000-00-00 00:00:00', NULL),
(1340, 227, 100, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, NULL, NULL, NULL, NULL, 1, 25, 1, 'Inox 304', 'Non', 150, '100', NULL, NULL, NULL, NULL, '2020-12-18 12:22:28', '0000-00-00 00:00:00', NULL),
(1341, 218, 100, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, 'Laine de roche', 25, 0.06, 0.42, NULL, NULL, NULL, 'Inox 304', 'Oui', 150, '80', NULL, NULL, NULL, NULL, '2021-01-23 18:44:16', '0000-00-00 00:00:00', NULL),
(1342, 218, 130, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, 'Laine de roche', 25, 0.06, 0.42, NULL, NULL, NULL, 'Inox 304', 'Oui', 180, '80', NULL, NULL, NULL, NULL, '2021-01-23 18:47:50', '0000-00-00 00:00:00', NULL),
(1343, 218, 150, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, 'Laine de roche', 25, 0.06, 0.42, NULL, NULL, NULL, 'Inox 304', 'Oui', 200, '80', NULL, NULL, NULL, NULL, '2021-01-23 18:48:16', '0000-00-00 00:00:00', NULL),
(1344, 218, 180, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, 'Laine de roche', 25, 0.06, 0.42, NULL, NULL, NULL, 'Inox 304', 'Oui', 230, '80', NULL, NULL, NULL, NULL, '2021-01-23 18:48:48', '0000-00-00 00:00:00', NULL),
(1345, 218, 80, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, 'Laine de roche', 25, 0.06, 0.42, NULL, NULL, NULL, 'Inox 304', 'Oui', 130, '80', NULL, NULL, NULL, NULL, '2021-01-23 18:49:04', '0000-00-00 00:00:00', NULL),
(1346, 218, 200, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, 'Laine de roche', 25, 0.06, 0.42, NULL, NULL, NULL, 'Inox 304', 'Oui', 250, '80', NULL, NULL, NULL, NULL, '2021-01-23 18:49:34', '0000-00-00 00:00:00', NULL),
(1347, 218, 250, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, 'Laine de roche', 25, 0.06, 0.42, NULL, NULL, NULL, 'Inox 304', 'Oui', 300, '80', NULL, NULL, NULL, NULL, '2021-01-23 18:49:50', '0000-00-00 00:00:00', NULL),
(1348, 218, 300, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, 'Laine de roche', 25, 0.06, 0.42, NULL, NULL, NULL, 'Inox 304', 'Oui', 350, '80', NULL, NULL, NULL, NULL, '2021-01-23 18:50:03', '0000-00-00 00:00:00', NULL),
(1349, 218, 350, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, 'Laine de roche', 25, 0.06, 0.42, NULL, NULL, NULL, 'Inox 304', 'Oui', 400, '80', NULL, NULL, NULL, NULL, '2021-01-23 18:50:18', '0000-00-00 00:00:00', NULL),
(1350, 219, 80, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 19:18:16', '0000-00-00 00:00:00', NULL),
(1351, 219, 100, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 19:21:17', '0000-00-00 00:00:00', NULL),
(1352, 219, 120, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 19:21:26', '0000-00-00 00:00:00', NULL),
(1353, 219, 130, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 19:21:35', '0000-00-00 00:00:00', NULL),
(1354, 219, 140, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 19:21:43', '0000-00-00 00:00:00', NULL),
(1355, 219, 150, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 19:21:54', '0000-00-00 00:00:00', NULL),
(1356, 219, 160, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 19:22:16', '0000-00-00 00:00:00', NULL),
(1357, 219, 180, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 19:22:24', '0000-00-00 00:00:00', NULL),
(1358, 219, 200, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 19:22:32', '0000-00-00 00:00:00', NULL),
(1359, 219, 220, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 19:22:41', '0000-00-00 00:00:00', NULL),
(1360, 219, 250, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 19:22:51', '0000-00-00 00:00:00', NULL),
(1361, 219, 300, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 19:23:07', '0000-00-00 00:00:00', NULL),
(1362, 219, 350, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 19:23:19', '0000-00-00 00:00:00', NULL),
(1363, 219, 400, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 19:23:26', '0000-00-00 00:00:00', NULL),
(1364, 219, 450, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 19:23:34', '0000-00-00 00:00:00', NULL),
(1365, 219, 500, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 19:23:46', '0000-00-00 00:00:00', NULL),
(1366, 219, 550, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 19:24:02', '0000-00-00 00:00:00', NULL),
(1367, 219, 600, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 19:24:09', '0000-00-00 00:00:00', NULL),
(1368, 219, 650, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 19:24:24', '0000-00-00 00:00:00', NULL),
(1369, 222, 80, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, 1, 25, 1, 'Inox 304', 'Oui', 130, '100', NULL, NULL, NULL, NULL, '2021-01-23 20:10:33', '0000-00-00 00:00:00', NULL),
(1370, 222, 100, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, 1, 25, 1, 'Inox 304', 'Oui', 150, '100', NULL, NULL, NULL, NULL, '2021-01-23 20:10:49', '0000-00-00 00:00:00', NULL),
(1371, 220, 80, NULL, 'L05 - Acier aluminié (revêtu d’une couche d’aluminium) - EN 10154', 1.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '450', NULL, '66        ', NULL, NULL, '2021-01-23 20:24:48', '0000-00-00 00:00:00', NULL),
(1372, 220, 100, NULL, 'L05 - Acier aluminié (revêtu d’une couche d’aluminium) - EN 10154', 1.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '450', NULL, '66        ', NULL, NULL, '2021-01-23 20:25:20', '0000-00-00 00:00:00', NULL),
(1373, 394, 80, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 20:59:27', '0000-00-00 00:00:00', NULL),
(1374, 394, 100, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 20:59:27', '0000-00-00 00:00:00', NULL),
(1375, 394, 120, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 20:59:27', '0000-00-00 00:00:00', NULL),
(1376, 394, 130, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 20:59:27', '0000-00-00 00:00:00', NULL),
(1377, 394, 140, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 20:59:27', '0000-00-00 00:00:00', NULL),
(1378, 394, 150, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 20:59:27', '0000-00-00 00:00:00', NULL),
(1379, 394, 160, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 20:59:27', '0000-00-00 00:00:00', NULL),
(1380, 394, 180, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 20:59:27', '0000-00-00 00:00:00', NULL),
(1381, 394, 200, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 20:59:27', '0000-00-00 00:00:00', NULL),
(1382, 394, 220, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 20:59:27', '0000-00-00 00:00:00', NULL),
(1383, 394, 250, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 20:59:27', '0000-00-00 00:00:00', NULL),
(1384, 394, 300, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 20:59:27', '0000-00-00 00:00:00', NULL),
(1385, 394, 350, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 20:59:27', '0000-00-00 00:00:00', NULL),
(1386, 394, 400, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 20:59:27', '0000-00-00 00:00:00', NULL),
(1387, 394, 450, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 20:59:27', '0000-00-00 00:00:00', NULL),
(1388, 394, 500, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 20:59:27', '0000-00-00 00:00:00', NULL),
(1389, 394, 550, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 20:59:28', '0000-00-00 00:00:00', NULL),
(1390, 394, 600, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 20:59:28', '0000-00-00 00:00:00', NULL),
(1391, 394, 650, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-01-23 20:59:28', '0000-00-00 00:00:00', NULL),
(1392, 399, 80, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-17 05:30:37', '0000-00-00 00:00:00', NULL),
(1393, 399, 100, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-17 05:30:37', '0000-00-00 00:00:00', NULL),
(1394, 399, 120, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-17 05:30:37', '0000-00-00 00:00:00', NULL),
(1395, 399, 130, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-17 05:30:37', '0000-00-00 00:00:00', NULL),
(1396, 399, 140, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-17 05:30:38', '0000-00-00 00:00:00', NULL),
(1397, 399, 150, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-17 05:30:38', '0000-00-00 00:00:00', NULL),
(1398, 399, 160, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-17 05:30:38', '0000-00-00 00:00:00', NULL),
(1399, 399, 180, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-17 05:30:38', '0000-00-00 00:00:00', NULL),
(1400, 399, 200, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-17 05:30:38', '0000-00-00 00:00:00', NULL),
(1401, 399, 220, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-17 05:30:38', '0000-00-00 00:00:00', NULL),
(1402, 399, 250, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-17 05:30:38', '0000-00-00 00:00:00', NULL),
(1403, 399, 300, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-17 05:30:38', '0000-00-00 00:00:00', NULL),
(1404, 399, 350, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-17 05:30:38', '0000-00-00 00:00:00', NULL),
(1405, 399, 400, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-17 05:30:38', '0000-00-00 00:00:00', NULL),
(1406, 399, 450, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-17 05:30:38', '0000-00-00 00:00:00', NULL),
(1407, 399, 500, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-17 05:30:38', '0000-00-00 00:00:00', NULL),
(1408, 399, 550, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-17 05:30:38', '0000-00-00 00:00:00', NULL),
(1409, 399, 600, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-17 05:30:38', '0000-00-00 00:00:00', NULL),
(1410, 399, 650, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-17 05:30:38', '0000-00-00 00:00:00', NULL),
(1411, 221, 100, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 45, '2021-02-17 05:39:59', '0000-00-00 00:00:00', NULL),
(1412, 221, 120, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 45, '2021-02-17 05:40:10', '0000-00-00 00:00:00', NULL),
(1413, 221, 130, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 45, '2021-02-17 05:40:21', '0000-00-00 00:00:00', NULL),
(1414, 221, 140, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 45, '2021-02-17 05:40:41', '0000-00-00 00:00:00', NULL),
(1415, 221, 150, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 45, '2021-02-17 05:40:51', '0000-00-00 00:00:00', NULL),
(1416, 221, 160, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 45, '2021-02-17 05:41:09', '0000-00-00 00:00:00', NULL),
(1417, 221, 180, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 45, '2021-02-17 05:41:18', '0000-00-00 00:00:00', NULL),
(1418, 221, 200, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 45, '2021-02-17 05:41:30', '0000-00-00 00:00:00', NULL),
(1419, 221, 220, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 45, '2021-02-17 05:41:39', '0000-00-00 00:00:00', NULL),
(1420, 221, 250, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 45, '2021-02-17 05:41:47', '0000-00-00 00:00:00', NULL),
(1421, 221, 300, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 45, '2021-02-17 05:43:49', '0000-00-00 00:00:00', NULL),
(1422, 400, 80, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-18 20:56:51', '0000-00-00 00:00:00', NULL),
(1423, 400, 100, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-18 20:56:51', '0000-00-00 00:00:00', NULL),
(1424, 400, 120, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-18 20:56:51', '0000-00-00 00:00:00', NULL),
(1425, 400, 130, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-18 20:56:51', '0000-00-00 00:00:00', NULL),
(1426, 400, 140, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-18 20:56:51', '0000-00-00 00:00:00', NULL),
(1427, 400, 150, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-18 20:56:51', '0000-00-00 00:00:00', NULL),
(1428, 400, 160, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-18 20:56:51', '0000-00-00 00:00:00', NULL),
(1429, 400, 180, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-18 20:56:51', '0000-00-00 00:00:00', NULL),
(1430, 400, 200, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-18 20:56:51', '0000-00-00 00:00:00', NULL),
(1431, 400, 220, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-18 20:56:51', '0000-00-00 00:00:00', NULL),
(1432, 400, 250, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-18 20:56:51', '0000-00-00 00:00:00', NULL),
(1433, 400, 300, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-18 20:56:51', '0000-00-00 00:00:00', NULL),
(1434, 400, 350, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-18 20:56:51', '0000-00-00 00:00:00', NULL),
(1435, 400, 400, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-18 20:56:51', '0000-00-00 00:00:00', NULL),
(1436, 400, 450, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-18 20:56:51', '0000-00-00 00:00:00', NULL),
(1437, 400, 500, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-18 20:56:51', '0000-00-00 00:00:00', NULL),
(1438, 400, 550, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-18 20:56:51', '0000-00-00 00:00:00', NULL),
(1439, 400, 600, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-18 20:56:51', '0000-00-00 00:00:00', NULL),
(1440, 400, 650, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '600', NULL, '66        ', NULL, NULL, '2021-02-18 20:56:51', '0000-00-00 00:00:00', NULL),
(1441, 401, 120, NULL, 'L05 - Acier aluminié (revêtu d’une couche d’aluminium) - EN 10154', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2021-02-18 21:09:54', '0000-00-00 00:00:00', NULL),
(1442, 401, 130, NULL, 'L05 - Acier aluminié (revêtu d’une couche d’aluminium) - EN 10154', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2021-02-18 21:10:18', '0000-00-00 00:00:00', NULL),
(1443, 401, 140, NULL, 'L05 - Acier aluminié (revêtu d’une couche d’aluminium) - EN 10154', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2021-02-18 21:10:25', '0000-00-00 00:00:00', NULL),
(1444, 401, 150, NULL, 'L05 - Acier aluminié (revêtu d’une couche d’aluminium) - EN 10154', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2021-02-18 21:10:33', '0000-00-00 00:00:00', NULL),
(1445, 401, 160, NULL, 'L05 - Acier aluminié (revêtu d’une couche d’aluminium) - EN 10154', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2021-02-18 21:10:41', '0000-00-00 00:00:00', NULL),
(1446, 401, 180, NULL, 'L05 - Acier aluminié (revêtu d’une couche d’aluminium) - EN 10154', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2021-02-18 21:10:49', '0000-00-00 00:00:00', NULL),
(1447, 401, 200, NULL, 'L05 - Acier aluminié (revêtu d’une couche d’aluminium) - EN 10154', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2021-02-18 21:10:57', '0000-00-00 00:00:00', NULL),
(1448, 401, 250, NULL, 'L05 - Acier aluminié (revêtu d’une couche d’aluminium) - EN 10154', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2021-02-18 21:11:02', '0000-00-00 00:00:00', NULL),
(1449, 402, 80, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, 'Laine de roche', 20, 0.056, NULL, 1, 30, 1, 'Galva', 'Non', 180, '50', NULL, NULL, NULL, NULL, '2021-02-27 18:00:48', '0000-00-00 00:00:00', NULL),
(1450, 402, 100, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, 'Laine de roche', 20, 0.056, NULL, 1, 30, 1, 'Galva', 'Non', 200, '50', NULL, NULL, NULL, NULL, '2021-02-27 18:00:48', '0000-00-00 00:00:00', NULL),
(1451, 402, 130, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, 'Laine de roche', 20, 0.056, NULL, 1, 30, 1, 'Galva', 'Non', 230, '50', NULL, NULL, NULL, NULL, '2021-02-27 18:00:48', '0000-00-00 00:00:00', NULL),
(1452, 402, 150, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, 'Laine de roche', 20, 0.056, NULL, 1, 30, 1, 'Galva', 'Non', 250, '50', NULL, NULL, NULL, NULL, '2021-02-27 18:00:48', '0000-00-00 00:00:00', NULL),
(1453, 402, 180, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, 'Laine de roche', 20, 0.056, NULL, 1, 30, 1, 'Galva', 'Non', 280, '50', NULL, NULL, NULL, NULL, '2021-02-27 18:00:48', '0000-00-00 00:00:00', NULL),
(1454, 402, 200, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, 'Laine de roche', 20, 0.056, NULL, 1, 30, 1, 'Galva', 'Non', 300, '50', NULL, NULL, NULL, NULL, '2021-02-27 18:00:48', '0000-00-00 00:00:00', NULL),
(1455, 403, 80, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, 'Laine de roche', 20, 0.056, NULL, 1, 30, 1, 'Inox 304', 'Oui', 180, '50', NULL, NULL, NULL, NULL, '2021-02-27 18:11:50', '0000-00-00 00:00:00', NULL),
(1456, 403, 100, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, 'Laine de roche', 20, 0.056, NULL, 1, 30, 1, 'Inox 304', 'Oui', 200, '50', NULL, NULL, NULL, NULL, '2021-02-27 18:11:50', '0000-00-00 00:00:00', NULL),
(1457, 403, 130, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, 'Laine de roche', 20, 0.056, NULL, 1, 30, 1, 'Inox 304', 'Oui', 230, '50', NULL, NULL, NULL, NULL, '2021-02-27 18:11:50', '0000-00-00 00:00:00', NULL),
(1458, 403, 150, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, 'Laine de roche', 20, 0.056, NULL, 1, 30, 1, 'Inox 304', 'Oui', 250, '50', NULL, NULL, NULL, NULL, '2021-02-27 18:11:50', '0000-00-00 00:00:00', NULL),
(1459, 403, 180, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, 'Laine de roche', 20, 0.056, NULL, 1, 30, 1, 'Inox 304', 'Oui', 280, '50', NULL, NULL, NULL, NULL, '2021-02-27 18:11:50', '0000-00-00 00:00:00', NULL);
INSERT INTO `dginterior_details` (`id`, `duct_id`, `di`, `di2`, `nature_paroi`, `epais_paroi`, `rugo_paroi_int`, `isolant`, `epais_iso`, `cond_therm`, `resist_therm`, `rugo_paroi_air_int`, `largeur_air`, `rugo_paroi_air_ext`, `nature_paroi_ext`, `comp_ext`, `d_ext`, `dist_secu`, `mesure_dist_secu`, `dist_secu_en`, `mise_oeuvre_m`, `mise_oeuvre_l`, `created_at`, `updated_at`, `dist_secu2`) VALUES
(1460, 403, 200, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.4, 1, 'Laine de roche', 20, 0.056, NULL, 1, 30, 1, 'Inox 304', 'Oui', 300, '50', NULL, NULL, NULL, NULL, '2021-02-27 18:11:50', '0000-00-00 00:00:00', NULL),
(1461, 384, 80, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-06-27 15:57:58', '0000-00-00 00:00:00', NULL),
(1462, 384, 100, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-06-27 15:58:16', '0000-00-00 00:00:00', NULL),
(1463, 384, 125, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-06-27 15:58:26', '0000-00-00 00:00:00', NULL),
(1464, 384, 150, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-06-27 15:58:37', '0000-00-00 00:00:00', NULL),
(1465, 384, 180, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-06-27 15:58:48', '0000-00-00 00:00:00', NULL),
(1466, 384, 200, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-06-27 15:58:55', '0000-00-00 00:00:00', NULL),
(1467, 384, 250, NULL, 'L50 - Inox AISI 316L ou 316Ti - X2CrNiMo 17-12-2 ou X6CrNiMoTi 17-12-2', 0.1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-06-27 15:59:09', '0000-00-00 00:00:00', NULL),
(1468, 174, 150, NULL, 'L20 - Inox AISI 304 - X5CrNi 18-10', 0.3, 1, 'Laine de roche', 25, 0.057, 0.44, NULL, NULL, NULL, '15;20', 'Oui', 200, '80', NULL, NULL, NULL, NULL, '2021-09-11 15:26:01', '0000-00-00 00:00:00', NULL),
(1469, 174, 180, NULL, 'L20 - Inox AISI 304 - X5CrNi 18-10', 0.3, 1, 'Laine de roche', 50, 0.056, 0.89, NULL, NULL, NULL, '15;20', 'Oui', 280, '80', NULL, NULL, NULL, NULL, '2021-09-11 15:27:22', '0000-00-00 00:00:00', NULL),
(1470, 174, 200, NULL, 'L20 - Inox AISI 304 - X5CrNi 18-10', 0.3, 1, 'Laine de roche', 40, 0.057, 0.7, NULL, NULL, NULL, '15;20', 'Oui', 280, '80', NULL, NULL, NULL, NULL, '2021-09-11 15:28:20', '0000-00-00 00:00:00', NULL),
(1471, 174, 230, NULL, 'L20 - Inox AISI 304 - X5CrNi 18-10', 0.3, 1, 'Laine de roche', 25, 0.057, 0.44, NULL, NULL, NULL, '15;20', 'Oui', 280, '80', NULL, NULL, NULL, NULL, '2021-09-11 15:28:53', '0000-00-00 00:00:00', NULL),
(1472, 174, 280, NULL, 'L20 - Inox AISI 304 - X5CrNi 18-10', 0.3, 1, 'Laine de roche', 25, 0.057, 0.44, NULL, NULL, NULL, '15;20', 'Oui', 330, '80', NULL, NULL, NULL, NULL, '2021-09-11 15:29:41', '0000-00-00 00:00:00', NULL),
(1473, 405, 120, NULL, 'L01 - Acier non allié - S 235 JRG 2', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2021-09-15 08:31:39', '0000-00-00 00:00:00', NULL),
(1474, 405, 130, NULL, 'L01 - Acier non allié - S 235 JRG 2', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2021-09-15 08:31:56', '0000-00-00 00:00:00', NULL),
(1475, 405, 150, NULL, 'L01 - Acier non allié - S 235 JRG 2', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2021-09-15 08:32:12', '0000-00-00 00:00:00', NULL),
(1476, 405, 180, NULL, 'L01 - Acier non allié - S 235 JRG 2', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2021-09-15 08:32:23', '0000-00-00 00:00:00', NULL),
(1477, 405, 200, NULL, 'L01 - Acier non allié - S 235 JRG 2', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '67        ', NULL, NULL, '2021-09-15 08:32:33', '0000-00-00 00:00:00', NULL),
(1478, 406, 80, NULL, 'L80 - Acier émaillé par vitrification double face', 0.6, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '90', NULL, '66        ', NULL, NULL, '2021-09-15 08:43:17', '0000-00-00 00:00:00', NULL),
(1479, 406, 100, NULL, 'L80 - Acier émaillé par vitrification double face', 0.6, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '90', NULL, '66        ', NULL, NULL, '2021-09-15 08:43:33', '0000-00-00 00:00:00', NULL);

-- --------------------------------------------------------

--
-- Structure de la table `duct`
--

CREATE TABLE `duct` (
  `id` int NOT NULL,
  `current_step` int NOT NULL,
  `third_party_of_user_created_by` int NOT NULL,
  `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `is_completed` tinyint(1) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `ref_manufacturer_ext_id` int DEFAULT NULL,
  `ref_brand_ext_id` int DEFAULT NULL,
  `brand_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `m_date_app` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `info` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `forme` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `certificat` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `dop` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `norme_controle` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `mail` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `coquille_isolante` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `dta` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `mise_oeuvre_a` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `mise_oeuvre_b` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `mise_oeuvre_c` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `mise_oeuvre_d` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `mise_oeuvre_e` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `mise_oeuvre_f` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `mise_oeuvre_g` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `mise_oeuvre_h` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `mise_oeuvre_i` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `mise_oeuvre_j` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `mise_oeuvre_k` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `mise_oeuvre_n` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `mise_oeuvre_o` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `other_norme_controle` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `other_coquille_isolante` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_only_for_entreprise` tinyint(1) NOT NULL,
  `online_at` datetime DEFAULT NULL COMMENT '(DC2Type:datetime)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `duct`
--

INSERT INTO `duct` (`id`, `current_step`, `third_party_of_user_created_by`, `label`, `is_completed`, `status`, `created_by`, `ref_manufacturer_ext_id`, `ref_brand_ext_id`, `brand_name`, `m_date_app`, `info`, `type`, `forme`, `certificat`, `dop`, `norme_controle`, `mail`, `coquille_isolante`, `dta`, `mise_oeuvre_a`, `mise_oeuvre_b`, `mise_oeuvre_c`, `mise_oeuvre_d`, `mise_oeuvre_e`, `mise_oeuvre_f`, `mise_oeuvre_g`, `mise_oeuvre_h`, `mise_oeuvre_i`, `mise_oeuvre_j`, `mise_oeuvre_k`, `mise_oeuvre_n`, `mise_oeuvre_o`, `created_at`, `updated_at`, `other_norme_controle`, `other_coquille_isolante`, `is_only_for_entreprise`, `online_at`) VALUES
(155, 0, 0, 'DPI', 1, 1, NULL, 14, 324, 'ISOTIP-JONCOUX', NULL, NULL, 'Double paroi isolé', '0', '0071-CPR-0004', 'DOP00710004-DPI', '47;', NULL, NULL, 'Oui', '44', '10', '2.5', '2.5', '1.5', '1.8', '3', '20', '20', '370', '370', 'Les tés, coudes et éléments ajustables ne doivent supporter aucune charge', '10', '2017-04-07 15:00:34', '2018-07-10 11:28:17', NULL, NULL, 0, NULL),
(161, 0, 0, 'DPInox', 1, 1, NULL, 14, 324, 'ISOTIP-JONCOUX', NULL, NULL, 'Double paroi isolé', '0', '0071-CPR-0004', 'DOP00710004-DPI', '47;', NULL, NULL, 'Oui', '44', '10', '2.5', '2.5', '1.5', '1.6', '3', '20', '20', '370', '370', 'Les tés, coudes et éléments ajustables ne doivent supporter aucune charge', '10', '2017-04-14 14:06:08', '2018-02-14 09:41:49', NULL, NULL, 0, NULL),
(163, 0, 0, 'DPI-peint', 1, 1, NULL, 14, 324, 'ISOTIP-JONCOUX', NULL, NULL, 'Double paroi isolé', '0', '0071-CPR-0004', 'DOP00710004-DPI', '47;', NULL, NULL, 'Oui', '44', '10', '2.5', '2.5', '1.5', '1.8', '3', '20', '20', '370', '370', 'Les tés, coudes et éléments ajustables ne doivent supporter aucune charge', '10', '2017-04-18 14:52:08', '2017-05-10 10:10:13', NULL, NULL, 0, NULL),
(164, 0, 0, 'FLEXLISSE 316', 1, 1, NULL, 14, 324, 'ISOTIP-JONCOUX', NULL, NULL, 'Tubage flexible', '0', '0071-CPR-0037', 'DOP2270024-FLEXLISSE', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RAYON MAXI DE COURBURE : \nØ80 à 200mm R = 1,5 x Ø\nØ 225 à 300mm R = 2 x Ø\nØ > 300 mm R = 3 x Ø', NULL, '2017-04-25 14:05:30', '2018-09-30 20:25:21', NULL, NULL, 0, NULL),
(165, 0, 0, 'OCTANS', 1, 1, NULL, 14, 324, 'ISOTIP-JONCOUX', NULL, NULL, 'Triple paroi (concentrique isolé)', '0', '0432-CPR-00095-320', 'DOP043200095320-OCTANS', '47;49;', NULL, NULL, 'Oui', '43', '2.5', '2.5', '2.5', '1.5', '2.5', '2.5', '20', '20', '370', '370', '', '10', '2017-04-25 15:43:10', '2021-09-09 15:55:20', NULL, NULL, 0, NULL),
(166, 0, 0, 'TYRAL INOX 304', 1, 1, NULL, 14, 324, 'ISOTIP-JONCOUX', NULL, NULL, 'Conduit de raccordement (simple paroi)', '0', '0071-CPR-0036', 'DOP00710036-TYRAL', '48;', NULL, NULL, 'Non', '45', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2017-05-02 06:19:44', '2020-11-08 18:02:31', NULL, NULL, 0, NULL),
(167, 0, 0, 'EMAIL 1.2MM', 1, 1, NULL, 14, 324, 'ISOTIP-JONCOUX', NULL, NULL, 'Conduit de raccordement (simple paroi)', '0', '0476-CPR-7862', 'DOP04767862-EMAIL12', '48;', NULL, NULL, 'Non', '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2017-05-02 06:29:17', '2021-01-29 09:43:22', NULL, NULL, 0, NULL),
(168, 0, 0, 'EMAIL 0.7MM', 1, 1, NULL, 14, 324, 'ISOTIP-JONCOUX', NULL, NULL, 'Conduit de raccordement (simple paroi)', '0', '0476-CPR-7862', 'DOP04767862-EMAIL07', '48;', NULL, NULL, 'Non', '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2017-05-02 06:35:44', '2020-11-08 18:02:06', NULL, NULL, 0, NULL),
(169, 0, 0, 'APOLLO PELLET', 1, 1, NULL, 14, 324, 'ISOTIP-JONCOUX', NULL, 'Version SANS joint 3 lèvres Viton de couleur verte classé T250. ', 'Concentrique (non isolé)', '0', '0071-CPR-0035; 0071-CPR-23062', 'DOP00710035-A-PELLET', '47;49;', NULL, NULL, 'Oui', '45', '10', '2.5', '2.5', '1.5', '1.8', '3', '20', '20', '370', '370', 'Option avec joint 3 lèvres Viton de couleur verte classé T250. ', '10', '2017-05-02 06:56:43', '2019-01-16 12:42:41', NULL, NULL, 0, NULL),
(170, 0, 0, 'PTR30', 1, 1, NULL, 11, 306, 'MODINOX', NULL, 'Sans joint - Installations intérieures et extérieures', 'Double paroi isolé', '0', '2270-CPR-017-Rev 05', '106-2PTI-RPC', '47;', NULL, NULL, 'Oui', '44', '10', '3', '2,50', '1,50', '1,50', '3,00', '20', '20', '750', '750', '', '10', '2017-05-12 09:11:41', '2021-07-12 21:08:51', NULL, NULL, 0, NULL),
(174, 0, 0, 'INOX-INOX et/ou INOX-GALVA', 1, 1, NULL, 27, 352, 'Cheminées Poujoulat', NULL, 'Conduit isolé polycombustible : montage extérieur\n\"INOX-INOX\" renseigné par Poujoulat puis converti en \"INOX-INOX et/ou INOX-GALVA\" par PhB car l\'EN 13384-1 et l\'appli ne font pas de différence.', 'Double paroi isolé', '0', '0071-CPR-0013', 'DOP 012011514FR', '47;', NULL, NULL, 'Oui', '44', '10', '10', '2,5', '2,5', '1,5', '1,5', '90', '90', '90', '90', '', '10', '2017-05-30 12:30:37', '2021-09-11 15:31:56', NULL, NULL, 0, NULL),
(175, 0, 0, 'EFFICIENCE pour bûches (D)', 1, 1, NULL, 27, 352, 'Cheminées Poujoulat', NULL, 'conduit concentrique étanche triple paroi isolé.\nFiche modifiée par PhB le 27/02/2021 pour la restreindre aux bûches après m\'être rappelé que le DTA spécifie W/granulés et D/bûches (initialement le responsable Poujoulat avait enregistré à la fois pour  bû', 'Triple paroi (concentrique isolé)', '0', '0071-CPR–24988', 'DOP 01401317FR', '49;', NULL, NULL, 'Oui', '44', '10', '10', '2.5', '2.5', '1.5', '1.5', '90', '90', '90', '90', '', '10', '2017-05-30 12:38:38', '2021-02-27 18:23:06', NULL, NULL, 0, NULL),
(176, 0, 0, 'PGI', 1, 1, NULL, 27, 352, 'Cheminées Poujoulat', NULL, 'Conduit de fumée inox concentrique.\nPhB a ajouté le 130/200 le 1/06/2020.', 'Concentrique (non isolé)', '0', '0071', 'DOP 015012713FR', '49;DTA CSTB 14/13-1943', NULL, NULL, 'Oui', '44', '10', '10', '2,5', '2,5', '1,2', '1,5', '180', '180', '180', '180', '', '10', '2017-05-30 12:40:50', '2021-04-03 17:41:24', NULL, NULL, 0, NULL),
(177, 0, 0, 'FUMISTERIE ÉMAILLÉE', 1, 1, NULL, 27, 352, 'Cheminées Poujoulat', NULL, 'Conduit de raccordement pour poêle à bois', 'Conduit de raccordement (simple paroi)', '0', '0407', 'DOP 12401917FR', '48;', NULL, NULL, 'Non', '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2017-05-30 12:43:48', '2019-08-13 19:37:42', NULL, NULL, 0, NULL),
(178, 0, 0, 'FUMISTERIE ACIER 2mm', 1, 1, NULL, 27, 352, 'Cheminées Poujoulat', NULL, 'Raccordement de poêles ou cuisinières à bûches', 'Conduit de raccordement (simple paroi)', '0', '0407', 'DOP 125012713FR', '48;', NULL, NULL, 'Non', '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2017-05-30 13:20:06', '2018-05-21 17:31:48', NULL, NULL, 0, NULL),
(179, 0, 0, 'FUMISTERIE ÉMAILLÉE pour poêle à granulés', 1, 1, NULL, 27, 352, 'Cheminées Poujoulat', NULL, 'Fumisterie Émaillée avec joints en fibre pour raccordement des poêles à granulés', 'Conduit de raccordement (simple paroi)', '0', '0407', 'DOP 12401917FR', '48;', NULL, NULL, 'Non', '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2017-05-30 13:23:47', '2018-07-12 22:20:32', NULL, NULL, 0, NULL),
(181, 0, 0, 'THERMINOX ZI', 1, 1, NULL, 27, 352, 'Cheminées Poujoulat', NULL, 'Conduit double paroi polycombustible, pour l\'intérieur des bâtiments', 'Double paroi isolé', '0', '0071-CPR-0011', 'DOP 002012713FR', '47;', NULL, NULL, 'Oui', '44', '16', '0', '4', '3', '2', '3', '20', '20', '90', '90', '', '10', '2017-06-02 08:11:48', '2021-02-27 15:01:43', NULL, NULL, 0, NULL),
(182, 0, 0, 'THERMINOX TI', 1, 1, NULL, 27, 352, 'Cheminées Poujoulat', NULL, 'Conduit double paroi polycombustible, pour l\'intérieur et extérieur des bâtiments', 'Double paroi isolé', '0', '0071-CPR-0011', 'DOP 001012713FR', '47;', NULL, NULL, 'Oui', '44', '16', '0', '4', '3', '2', '3', '20', '20', '90', '90', '', '10', '2017-06-02 08:49:07', '2021-02-27 15:01:33', NULL, NULL, 0, NULL),
(183, 0, 0, 'EFFICIENCE-Galva pour bûches (D)', 1, 1, NULL, 27, 352, 'Cheminées Poujoulat', NULL, 'conduit concentrique étanche triple paroi isolé.\nFiche modifiée par PhB le 27/02/2021 pour la restreindre aux bûches après m\'être rappelé que le DTA spécifie W/granulés et D/bûches (initialement le responsable Poujoulat avait enregistré à la fois pour  bû', 'Triple paroi (concentrique isolé)', '0', '0071-CPR–24988', 'DOP 01401317FR', '49;', NULL, NULL, 'Oui', '44', '10', '10', '2.5', '2.5', '1.5', '1.5', '90', '90', '90', '90', '', '10', '2017-06-15 08:25:07', '2021-02-27 18:23:17', NULL, NULL, 0, NULL),
(184, 0, 0, 'INOX - GALVA', 1, 1, NULL, 27, 352, 'Cheminées Poujoulat', NULL, 'Conduit isolé polycombustible : montage intérieur', 'Double paroi isolé', '0', '0071-CPR-0013', 'DOP 012011514FR', '47;', NULL, NULL, 'Oui', '44', '10', '10', '2,5', '2,5', '1,5', '1,5', '90', '90', '90', '90', '', '10', '2017-06-15 12:12:31', '2021-09-11 15:34:12', NULL, NULL, 0, NULL),
(185, 0, 0, 'PTR30 G', 1, 1, NULL, 11, 306, 'MODINOX', NULL, 'Sans joint - Installations intérieures et extérieures', 'Double paroi isolé', '0', '2270-CPR-017-Rev 05', '107-2PTG-RPC', '47;', NULL, NULL, 'Oui', '44', '10', '3', '2.50', '1.50', '1.50', '3.00', '20', '20', '750', '750', '', '10', '2017-06-21 09:48:31', '2021-07-12 21:09:02', NULL, NULL, 0, NULL),
(186, 0, 0, 'PTR30 Pellets', 1, 1, NULL, 11, 306, 'MODINOX', NULL, 'Avec joint fibre', 'Double paroi isolé', '0', '2270-CPR-017-Rev 05', '106-2PTI-RPC', '47;', NULL, NULL, 'Oui', '44', '10', '3', '2.50', '1.50', '1.50', '3.00', '20', '20', '750', '750', '', '10', '2017-06-21 09:55:37', '2021-07-12 21:09:12', NULL, NULL, 0, NULL),
(187, 0, 0, 'DI ( DOUBLINOX )', 1, 1, NULL, 11, 306, 'MODINOX', NULL, 'Sans joint - Installations intérieures et extérieures', 'Double paroi isolé', '0', '2270-CPR-016-Rev 02', '103-2DI-RPC', '47;', NULL, NULL, 'Oui', '44', '10', '3', '2.50', '1.50', '1.50', '3.00', '20', '20', '750', '750', '', '10', '2017-06-21 11:17:07', '2021-07-12 21:09:23', NULL, NULL, 0, NULL),
(188, 0, 0, 'GI ( GALVINOX )', 1, 1, NULL, 11, 306, 'MODINOX', NULL, 'Sans joint - Installations intérieures et extérieures', 'Double paroi isolé', '0', '2270-CPR-016-Rev 02', '100-2GI-RPC', '47;', NULL, NULL, 'Oui', '44', '10', '3', '2.50', '1.50', '1.50', '3.00', '20', '20', '750', '750', '', '10', '2017-06-21 12:37:57', '2021-07-12 21:09:42', NULL, NULL, 0, NULL),
(189, 0, 0, 'PTR 50', 1, 1, NULL, 11, 306, 'MODINOX', NULL, 'Sans joint - Installations intérieures et extérieures', 'Double paroi isolé', '0', '2270-CPR-017-Rev 05', '110-2PT5-RPC', '47;', NULL, NULL, 'Non', '44', '10', '3', '2.50', '1.50', '1.50', '1.50', '20', '20', NULL, NULL, '', '10', '2017-06-21 12:45:07', '2021-07-12 21:09:54', NULL, NULL, 0, NULL),
(190, 0, 0, 'POLYFLEX', 1, 1, NULL, 11, 306, 'MODINOX', NULL, NULL, 'Tubage flexible', '0', '2270-CPR-019', '130-2FLEPOFX-RPC', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2017-06-21 13:02:06', '2021-07-12 21:10:02', NULL, NULL, 0, NULL),
(191, 0, 0, 'EMAILLES PELLETS', 1, 1, NULL, 11, 306, 'MODINOX', NULL, NULL, 'Conduit de raccordement (simple paroi)', '0', '0476-CPR-7509', 'N° 3 PELLET', '48;', NULL, NULL, 'Non', '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2017-06-21 13:52:46', '2021-07-12 21:10:10', NULL, NULL, 0, NULL),
(192, 0, 0, 'EMAIL ligne +', 1, 1, NULL, 11, 306, 'MODINOX', NULL, NULL, 'Conduit de raccordement (simple paroi)', '0', '0476-CPR-7509', 'N° 2-PLUS-1.2 ', '48;', NULL, NULL, NULL, '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2017-06-21 14:10:43', '2021-07-12 21:10:18', NULL, NULL, 0, NULL),
(193, 0, 0, 'PRH PELLET', 1, 1, NULL, 11, 306, 'MODINOX', NULL, 'Avec joint fibre', 'Conduit de raccordement (simple paroi)', '0', '2270-CPR-021', '112-2PR-RPC', '48;', NULL, NULL, 'Non', '44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2017-06-22 06:13:15', '2021-07-12 21:10:26', NULL, NULL, 0, NULL),
(194, 0, 0, 'ATRINOX', 1, 1, NULL, 11, 306, 'MODINOX', NULL, NULL, 'Conduit de raccordement (simple paroi)', '0', '2270-CPR-021', '115-2ATR-RPC', '48;', NULL, NULL, 'Non', '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2017-06-22 06:20:47', '2021-07-12 21:10:33', NULL, NULL, 0, NULL),
(195, 0, 0, 'POLYGAINE', 1, 1, NULL, 11, 306, 'MODINOX', NULL, 'Tubage flexible double peau', 'Tubage flexible', '0', '2270-CPR-019', '125-2FLEPOGA-RPC', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2017-06-22 09:23:07', '2021-07-12 21:10:41', NULL, NULL, 0, NULL),
(196, 0, 0, 'POLYLISSE inox 904L', 1, 1, NULL, 11, 306, 'MODINOX', NULL, 'Tubage flexible double peau L70010', 'Tubage flexible', '0', '2270-CPR-019', '127-2FLEPOLI-RPC', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2017-06-22 09:36:40', '2021-07-12 21:10:48', NULL, NULL, 0, NULL),
(197, 0, 0, 'POLYGAINE G10', 1, 1, NULL, 11, 306, 'MODINOX', NULL, 'Tubage flexible double peau ', 'Tubage flexible', '0', '2270-CPR-019', '135-2FLEPOGA-RPC', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2017-06-22 09:52:05', '2021-07-12 21:10:55', NULL, NULL, 0, NULL),
(198, 0, 0, 'PRH PELLET', 1, 1, NULL, 11, 306, 'MODINOX', NULL, NULL, 'Tubage rigide (simple paroi)', '0', '2270-CPR-021-Rev04', '112-2PR-RPC', '48;', NULL, NULL, 'Non', '44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2017-06-22 13:24:09', '2021-07-12 21:11:04', NULL, NULL, 0, NULL),
(199, 0, 0, 'PRH ', 1, 1, NULL, 11, 306, 'MODINOX', NULL, NULL, 'Tubage rigide (simple paroi)', '0', '2270-CPR-021-Rev04', '112-2PR-RPC', '48;', NULL, NULL, 'Non', '44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2017-06-22 13:29:32', '2021-08-19 09:22:55', NULL, NULL, 0, NULL),
(200, 0, 0, 'ATRINOX', 1, 1, NULL, 11, 306, 'MODINOX', NULL, NULL, 'Tubage rigide (simple paroi)', '0', '2270-CPR-021-Rev04', '115-2ATR-RPC', '48;', NULL, NULL, 'Non', '44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2017-06-22 13:35:47', '2021-07-12 21:11:29', NULL, NULL, 0, NULL),
(201, 0, 0, 'OVALISE', 1, 1, NULL, 11, 306, 'MODINOX', NULL, NULL, 'Tubage rigide (simple paroi)', '0', '2270-CPR-021-Rev04', '143-2OV5-RPC', '48;', NULL, NULL, NULL, '44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2017-06-22 13:55:46', '2021-07-12 21:11:37', NULL, NULL, 0, NULL),
(202, 0, 0, 'PLA', 1, 1, NULL, 11, 306, 'MODINOX', NULL, 'Avec joint fibre - DTA 14/16-2222*V1', 'Concentrique (non isolé)', '0', '2270-CPR-020-REV03', '111-2PLA-RPC', '47;48;49;', NULL, NULL, 'Oui', '44', '10', '3', '2.5', '1.50', '1.50', '1.50', '572', '572', '572', '572', '', '10', '2017-06-22 14:15:53', '2021-07-12 21:14:06', NULL, NULL, 0, NULL),
(213, 0, 0, '2400 Tubage simple paroi', 1, 1, NULL, 30, 357, 'Eka simple Paroi', NULL, NULL, 'Tubage rigide (simple paroi)', '0', NULL, NULL, '48;', NULL, NULL, NULL, '45', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'J\'aurais bien aimé répondre \nObligatoire pour CdR et Facultative pour CF ', NULL, '2017-07-31 14:44:12', '2018-12-26 09:30:05', NULL, NULL, 0, NULL),
(214, 0, 0, '2250-Cheminée Double Paroi D 0,6mm isol. 25mm', 0, 0, NULL, 30, 0, 'Eka cheminées', NULL, NULL, 'Double paroi isolé', '0', 'D-0036 CDP 90216 001/2004', '001 DOP 90216 2013', '47;', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2017-08-21 17:27:50', '2017-08-28 16:39:21', NULL, NULL, 0, NULL),
(215, 0, 0, '2500-Cheminée Double Paroi D 0,6mm isol. 50mm', 0, 0, NULL, 30, 0, 'EKA - Cheminées Inox', NULL, NULL, 'Double paroi isolé', '0', ' D-0036 CPD 90216 001/2004', '001 DOP 90216 2013', '47;', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2017-09-10 15:38:40', '2019-01-29 13:49:06', NULL, NULL, 0, NULL),
(216, 0, 0, 'DIXINOX GALVA', 1, 1, NULL, 19, 343, 'DIXNEUF', NULL, NULL, 'Double paroi isolé', '0', NULL, 'DOP 011012713FR', '47;', NULL, NULL, 'Oui', '44', '10', '10', '2.5', '2.5', '1.5', '3', '20', '20', '90', '90', '', '10', '2017-09-21 07:07:51', '2019-06-21 12:41:16', NULL, NULL, 0, NULL),
(217, 0, 0, 'DIXINOX INOX', 1, 1, NULL, 19, 343, 'DIXNEUF', NULL, NULL, 'Double paroi isolé', '0', NULL, 'DOP 010012713FR', '47;', NULL, NULL, 'Oui', '44', '10', '10', '2.5', '2.5', '1.5', '3', '20', '20', '90', '90', '', '10', '2017-09-21 07:46:01', '2018-01-15 11:19:48', NULL, NULL, 0, NULL),
(218, 0, 0, 'MC DOPPIO', 1, 1, NULL, 47, 383, 'MC di Costa Moreno', NULL, 'Fiche renseignée par Chiara le 15/10/2020, validée par PhB le 23/01/2021.\nDIAMETRES INTERIEURS :      80 - 100 – 130 - 150 - 180 – 200 - 250 - 300 – 350\nDIAMETRES EXTERIEURES : 130 – 150 – 180 – 200 – 230 – 250 – 300 – 350 - 450\n• EPAISSEUR : 0,5 mm\n• MAT', 'Double paroi isolé', '0', ' 0407-CPR-422 (IG-094-2011)', '25ISO-CPR422', '47;', NULL, NULL, 'Oui', '44', '1', '', '2', '2', '', '', '20', '20', '600', '600', '', '1', '2017-09-28 17:51:49', '2021-01-23 20:55:59', NULL, NULL, 0, NULL),
(219, 0, 0, 'MC MONO', 1, 1, NULL, 47, 383, 'MC di Costa Moreno', NULL, 'Fiche renseignée par Chiara le 15/10/2020, validée par PhB le 23/01/2021.\nEPAISSEUR 0.5 mm \nDIAMETRES : 80 - 100 - 120 - 130 - 140 - 150 - 160 - 180 - 200 - 220 - 250 - 300 - 350 – 400 – 450 – 500 – 550 – 600 – 650\nProduction sur demande : \n- production e', 'Tubage rigide (simple paroi)', '0', '0407-CPR-422 (IG–094-2011)', '05MONO-CPR422', '48;', NULL, NULL, NULL, '44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2017-09-28 18:02:26', '2021-01-23 20:49:53', NULL, NULL, 0, NULL),
(220, 0, 0, 'MC PELLET', 1, 1, NULL, 47, 383, 'MC di Costa Moreno', NULL, 'Fiche renseignée par Chiara le 15/10/2020, validée par PhB le 23/01/2021.\nTUYAUX ET ACCESSOIRES POUR POELES ET CHEMINEES A GRANULES\n- Diamètres produits : 80 et 100\n- Entrée mâle-femelle avec emboîtement 50 mm qui contient le joint d’étanchéité\n- Joint si', 'Conduit de raccordement (simple paroi)', '0', '0476-CPR-7921', '12CPR07.13', '48;', NULL, NULL, 'Non', '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2017-09-28 18:07:41', '2021-01-23 21:14:35', NULL, NULL, 0, NULL),
(221, 0, 0, 'MC FLEX', 0, 0, NULL, 47, 0, 'MC di Costa Moreno', NULL, 'Fiche renseignée par Chiara le 15/10/2020, vue par PhB le 23/01/202 mais non validée car Chiara doit la dupliquer et ajouter les diamètres.\nEPAISSEUR DU PRODUIT : 0,10 mm intérieur lisse/extérieur froncé\nMATERIAU : INOX AISI 316 L. partie intérieure\n\nRACC', 'Tubage flexible', '0', ' 0407-CPR-422', '01FLEX-CPR422', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2017-09-28 18:10:59', '2021-02-17 05:45:01', NULL, NULL, 0, NULL),
(222, 0, 0, 'MC DUO', 1, 1, NULL, 47, 383, 'MC di Costa Moreno', NULL, 'Fiche renseignée par Chiara le 15/10/2020, validée par PhB le 23/01/2021.\nDiamètres Intérieurs : 80-100\nDiamètres Extérieurs : 130-150\nMatériau intérieur : inox AISI 316L, épaisseur 5/10\nMatériau Extérieur : inox AISI 304, épaisseur 5/10\nJonction : emboit', 'Concentrique (non isolé)', '0', '0407-CPR-422 (IG–094-2011)', '25AIR-CPR422', '49;', NULL, NULL, 'Oui', '44', '2', '', '2', '2', '', '', '20', '20', '300', '300', '', '2', '2017-09-28 18:18:28', '2021-01-23 20:55:20', NULL, NULL, 0, NULL),
(227, 0, 0, 'TWIN-BIOMASS 316L / 304', 1, 1, NULL, 26, 350, 'JEREMIAS TWIN-BIOMASS - Conduit concentrique', NULL, 'Variante 150/200 ajoutée le 18/12/2020 par PhB sur la demande de Benoit Clouet (+ correction sur l\'épaisseur de la lame d\'air des 100/150 et 150/200), ainsi que les coudes à 15°, 30°, 42°, 45°, 60°, 67°, et 90° en plus du seul 87° déjà saisi.\n', 'Concentrique (non isolé)', '0', '0036 CPR 9174 065', NULL, '49;DTA  14/16 - 2233', NULL, NULL, 'Non', '44', '6', '', '4', '', '', '', '', '', '', '', '', '6', '2017-11-04 10:04:20', '2020-12-18 15:21:56', NULL, NULL, 0, NULL),
(228, 0, 0, 'DW-ECO 2.0 316L / 304', 1, 1, NULL, 26, 350, 'JEREMIAS DW-ECO 2.0', NULL, 'ANNULE ET REMPLACE LIGNE 225. OK fait ce 4/11/2017 par PhB.', 'Double paroi isolé', '0', '0036CPD9174030', NULL, '47;48;', NULL, NULL, 'Oui', '44', '10', '', '4', '4', '3', '', '', '', '', '', '', '6', '2017-11-04 10:13:00', '2020-10-24 13:00:10', NULL, NULL, 0, NULL),
(229, 0, 0, 'DW-ECO 2.0 304 / GALVA', 1, 1, NULL, 26, 350, 'JEREMIAS DW-ECO 2.0', NULL, 'ANNULE ET REMPLACE LIGNE 226. OK fait ce 4/11/2017 par PhB.', 'Double paroi isolé', '0', '0036CPD9174030', NULL, '47;48;', NULL, NULL, 'Oui', '44', '10', '', '4', '4', '3', '', '', '', '', '', '', '6', '2017-11-04 10:21:43', '2020-10-26 21:14:18', NULL, NULL, 0, NULL),
(230, 0, 0, 'VITRO-PELLET noir', 1, 1, NULL, 26, 350, 'JEREMIAS VITRO-PELLET acier 1mm émaillé noir', NULL, NULL, 'Conduit de raccordement (simple paroi)', '0', '0476 CPR 8055', NULL, '47;48;', NULL, NULL, NULL, '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2017-11-04 10:38:01', '2018-03-28 07:22:56', NULL, NULL, 0, NULL),
(231, 0, 0, 'SET-BIOMASS', 1, 1, NULL, 26, 350, 'JEREMIAS SET-BIOMASS triple paroi inox ou noir', NULL, NULL, 'Triple paroi (concentrique isolé)', '0', '0036 CPD 9174 060', NULL, '47;48;', NULL, NULL, 'Non', '44', '6', '', '', '', '', '', '', '', '', '', '', '6', '2017-11-04 10:44:07', '2021-09-09 15:56:05', NULL, NULL, 0, NULL),
(232, 0, 0, 'TYRAL INOX 304-TUBAGE', 1, 1, NULL, 14, 324, 'ISOTIP-JONCOUX', NULL, NULL, 'Tubage rigide (simple paroi)', '0', '0071-CPR-0036', 'DOP00710036-TYRAL', '48;', NULL, NULL, 'Non', '45', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2017-11-27 11:18:42', '2017-12-04 15:20:25', NULL, NULL, 0, NULL),
(233, 0, 0, 'ISOBLONG 316', 1, 1, NULL, 14, 324, 'ISOTIP-JONCOUX', NULL, NULL, 'Tubage rigide (simple paroi)', '0', '0071-CPR-0022', 'DOP00710022-ISOBLONG', '48;', NULL, NULL, NULL, '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Deux grenouillères sont à utiliser pour remplacer la bride de sécurité. ', NULL, '2017-11-27 11:20:52', '2018-10-07 20:47:20', NULL, NULL, 0, NULL),
(234, 0, 0, 'DPI-W-Ext', 0, 0, NULL, 15, 0, 'A-MarqueDémo', NULL, 'Test 17/01/2018 avec des valeurs réalistes sauf les hauteurs de conduit entre brides.', 'Double paroi isolé', '0', NULL, NULL, '47;', NULL, NULL, 'Non', '44', '1', '3', '4', '5', '6', '7', '20', '20', '90', '90', 'Test 17/01/2018.', ' 2', '2018-01-17 15:00:40', '2018-05-23 10:25:47', NULL, NULL, 0, NULL),
(235, 0, 0, 'DPI-W-Int', 0, 0, NULL, 15, 0, 'A-MaeDémojkjk', NULL, 'Test 17/01/2018 avec valeurs réalistes sauf hauteurs entre brides.', 'Double paroi isolé', '0', NULL, NULL, '47;', NULL, NULL, 'Non', '44', '1', '3', '4', '5', '6', '7', '20', '20', '90', '90', 'Test 17/01/2018.', ' 2', '2018-01-17 15:21:56', '2018-01-26 14:03:36', NULL, NULL, 0, NULL),
(236, 0, 0, 'SPI-Simple Paroi Inox', 0, 0, NULL, 15, 0, 'A-MarqueDémo', NULL, 'Test du 17/01/2018 avec des valeurs réalistes.', 'Conduit de raccordement (simple paroi)', '0', NULL, NULL, '48;', NULL, NULL, NULL, '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Test du 17/01/2018.', NULL, '2018-01-17 15:26:56', '2018-01-26 09:50:38', NULL, NULL, 0, NULL),
(237, 0, 0, 'Flex-Inox', 0, 0, NULL, 15, 0, 'A-MarqueDémo', NULL, 'Test du 17/01/2018 avec des valeurs réalistes.', 'Tubage flexible', '0', NULL, NULL, '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-01-17 15:32:11', '2018-04-17 07:35:48', NULL, NULL, 0, NULL),
(238, 0, 0, 'SPI-Simple Paroi Email', 0, 0, NULL, 15, 0, 'A-MarqueDémo', NULL, 'Test du 17/01/2018 avec des valeurs réalistes sauf en dist Sécu où j\'ai mis \"M-mesuré\" avec 400 mm sinon je ne pouvais pas enregistrer.', 'Conduit de raccordement (simple paroi)', '0', NULL, NULL, '48;', NULL, NULL, 'Non', '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Test du 17/01/2018.', NULL, '2018-01-17 15:41:07', '2018-05-23 10:26:30', NULL, NULL, 0, NULL),
(239, 0, 0, 'CC Inox', 0, 0, NULL, 15, 0, 'A-MarqueDémo', NULL, 'Test du 17/01/2018 avec valeurs réalistes sauf hauteurs entre brides.', 'Concentrique (non isolé)', '0', NULL, NULL, '49;', NULL, NULL, 'Non', '44', '1', '3', '4', '5', '6', '7', '20', '20', '90', '90', '', '2', '2018-01-17 15:55:35', '2018-01-26 09:57:02', NULL, NULL, 0, NULL),
(240, 0, 0, 'SPI-Simple Paroi Inox-copie', 0, 0, NULL, 15, 0, 'A-MarqueDémo', NULL, 'Test du 17/01/2018 avec des valeurs réalistes.', 'Conduit de raccordement (simple paroi)', '0', NULL, NULL, '48;', NULL, NULL, NULL, '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Test du 17/01/2018.', NULL, '2018-01-20 20:51:52', '2018-05-23 10:24:17', NULL, NULL, 0, NULL),
(241, 0, 0, 'Flex-Inox-copie', 0, 0, NULL, 15, 0, 'A-MarqueDémo', NULL, 'Test du 17/01/2018 avec des valeurs réalistes.', 'Tubage flexible', '0', NULL, NULL, '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-01-20 20:52:05', '2018-01-26 09:46:31', NULL, NULL, 0, NULL),
(242, 0, 0, 'SPI-Simple Paroi Email-copie', 0, 0, NULL, 15, 0, 'A-MarqueDémo', NULL, 'Test du 17/01/2018 avec des valeurs réalistes sauf en dist Sécu où j\'ai mis \"M-mesuré\" avec 400 mm sinon je ne pouvais pas enregistrer.', 'Conduit de raccordement (simple paroi)', '0', NULL, NULL, '48;', NULL, NULL, 'Non', '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Test du 17/01/2018.', NULL, '2018-01-26 09:55:01', '2018-05-23 10:23:34', NULL, NULL, 0, NULL),
(243, 0, 0, 'SPI-Simple Paroi Email-copie-copie', 0, 0, NULL, 15, 0, 'A-MarqueDémo', NULL, 'Test du 17/01/2018 avec des valeurs réalistes sauf en dist Sécu où j\'ai mis \"M-mesuré\" avec 400 mm sinon je ne pouvais pas enregistrer.', 'Conduit de raccordement (simple paroi)', '0', NULL, NULL, '48;', NULL, NULL, 'Non', '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Test du 17/01/2018.', NULL, '2018-01-26 09:58:11', '2018-01-26 09:59:59', NULL, NULL, 0, NULL),
(244, 0, 0, 'SPI-Simple Paroi Email-copie-copie-copie', 0, 0, NULL, 15, 0, 'A-MarqueDémo', NULL, 'Test du 17/01/2018 avec des valeurs réalistes sauf en dist Sécu où j\'ai mis \"M-mesuré\" avec 400 mm sinon je ne pouvais pas enregistrer.', 'Conduit de raccordement (simple paroi)', '0', NULL, NULL, '48;', NULL, NULL, 'Non', '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Test du 17/01/2018.', NULL, '2018-01-26 09:59:59', '2018-04-19 13:25:56', NULL, NULL, 0, NULL),
(245, 0, 0, 'triple paroi = essai mic', 1, 1, NULL, 15, 0, 'A-MarqueDémo', NULL, 'Test du 17/01/2018 avec des valeurs réalistes sauf en dist Sécu où j\'ai mis \"M-mesuré\" avec 400 mm sinon je ne pouvais pas enregistrer.', 'Triple paroi (concentrique isolé)', '0', NULL, NULL, '48;', NULL, NULL, 'Non', '43', '10', '11', '10', '10', '10', '10', '10', '10', NULL, NULL, 'Test du 26/01/2018.', '10', '2018-01-26 10:15:41', '2018-07-09 10:18:31', NULL, NULL, 0, NULL),
(247, 0, 0, 'POLYLISSE inox 316L', 1, 1, NULL, 11, 306, 'MODINOX', NULL, 'Tubage flexible double peau L50010 - L50011', 'Tubage flexible', '0', '2270-CPR-019', '127-2FLEPOLI-RPC', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-02-24 10:26:38', '2021-07-12 21:14:14', NULL, NULL, 0, NULL),
(248, 0, 0, 'Tubage rigide oblong', 1, 1, NULL, 0, 339, 'A-MarqueDémo', NULL, NULL, 'Tubage rigide (simple paroi)', '0', NULL, NULL, '47;', NULL, NULL, NULL, '44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-03-15 09:43:22', '2018-05-23 16:21:35', NULL, NULL, 0, NULL),
(249, 0, 0, 'DP isolé Pellet', 1, 1, NULL, 14, 324, 'ISOTIP-JONCOUX', NULL, NULL, 'Double paroi isolé', '0', '0432_CPR_00095-215', 'DOP043200095-A-DP', '47;', NULL, NULL, 'Oui', '44', '10', '2.5', '2.5', '1.5', '1.8', '3', '20', '20', '370', '370', 'Les tés, coudes et éléments ajustables ne doivent supporter aucune charge', '10', '2018-03-15 11:39:55', '2021-02-22 15:53:55', NULL, NULL, 0, NULL),
(250, 0, 0, 'DW25 INT. 316L / EXT. 304', 1, 1, NULL, 56, 398, 'TUBEST', NULL, NULL, 'Double paroi isolé', '0', '0476-CPR-3729', 'Dopcpr01', '47;', NULL, NULL, 'Oui', '44', '11', '', '4', '', '2', '3', '20', '20', '1200', '400', 'Les valeurs communiquées sont valables pour un diamètre maxi de 250 mm intérieur, pour un diamètre supérieur veuillez contacter TUBEST.', '3', '2018-04-30 13:13:26', '2019-08-16 16:51:13', NULL, NULL, 0, NULL),
(251, 0, 0, 'DP-FLAMME INT. 304 / EXT. 304', 1, 1, NULL, 56, 398, 'TUBEST', NULL, NULL, 'Double paroi isolé', '0', '0476-CPR-3729', 'Dopcpr01', '47;', NULL, NULL, 'Oui', '44', '11', '', '4', '', '2', '3', '20', '20', '1200', '400', 'Les valeurs communiquées sont valables pour un diamètre maxi de 250 mm intérieur, pour un diamètre supérieur veuillez contacter TUBEST.', '3', '2018-04-30 15:21:00', '2019-02-14 13:34:43', NULL, NULL, 0, NULL),
(252, 0, 0, 'PRIMA PELLET', 1, 1, NULL, 56, 398, 'TUBEST', NULL, NULL, 'Conduit de raccordement (simple paroi)', '0', '0476-CPR-3730', 'Dopcpr02', '48;', NULL, NULL, 'Non', '45', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-06-11 15:04:51', '2018-06-13 10:15:39', NULL, NULL, 0, NULL),
(253, 0, 0, 'PRIMA PELLET ACIER', 1, 1, NULL, 56, 398, 'TUBEST', NULL, NULL, 'Conduit de raccordement (simple paroi)', '0', '0476-CPR-3730', 'Dopcpr02', '48;', NULL, NULL, NULL, '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'nous ne pouvons pas utiliser ce produit pour tubage ou conduit mais il n\'y a pas dans menu déroulent la possibilité de choisir : \'facultative pour Cdr et conduit interdit pour conduit et tubage\', je ne sais donc pas quoi indiquer.\nPhB : il suffit de chois', NULL, '2018-06-13 09:20:41', '2018-06-13 12:56:09', NULL, NULL, 0, NULL),
(254, 0, 0, 'PELLET EMAIL', 1, 1, NULL, 56, 398, 'TUBEST', NULL, NULL, 'Conduit de raccordement (simple paroi)', '0', '0476-CPR-3730', 'Dopcpr02', '48;', NULL, NULL, 'Non', '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'nous ne pouvons pas utiliser ce produit pour tubage ou conduit mais il n\'y a pas dans menu déroulent la possibilité de choisir : \'facultative pour Cdr et conduit interdit pour conduit et tubage\', je ne sais donc pas quoi indiquer.\n\nAutre question, pourquo', NULL, '2018-06-13 09:29:04', '2018-06-13 12:56:44', NULL, NULL, 0, NULL),
(255, 0, 0, 'SW PRIMA', 1, 1, NULL, 56, 398, 'TUBEST', NULL, NULL, 'Conduit de raccordement (simple paroi)', '0', '0476-CPR-3730', 'Dopcpr02', '48;', NULL, NULL, 'Non', '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Autre question, pourquoi demander pour du raccordement SP si nous avons des coquilles pour passages planchers... ?\n\nIl est demandé si nous avons un DTA sur coquille mais pas sur le produit en lui meme...\n\nMerci', NULL, '2018-06-13 09:33:54', '2018-09-12 10:38:38', NULL, NULL, 0, NULL),
(257, 0, 0, 'SW PRIMA', 1, 1, NULL, 56, 398, 'TUBEST', NULL, NULL, 'Tubage rigide (simple paroi)', '0', '0476-CPR-3730', 'Dopcpr02', '48;', NULL, NULL, 'Non', '44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-06-13 09:54:24', '2018-06-13 10:42:14', NULL, NULL, 0, NULL),
(258, 0, 0, 'TP INOX', 1, 1, NULL, 56, 398, 'TUBEST', NULL, NULL, 'Tubage rigide (simple paroi)', '0', '0476-CPR-3730', 'Dopcpr02', '48;', NULL, NULL, 'Non', '44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-06-13 09:59:47', '2019-06-13 16:05:33', NULL, NULL, 0, NULL),
(260, 0, 0, 'MONO FLAMME EMAIL', 1, 1, NULL, 56, 398, 'TUBEST', NULL, NULL, 'Conduit de raccordement (simple paroi)', '0', '0476-CPR-5413', 'Dopcpr09', '48;', NULL, NULL, 'Non', '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-06-13 10:11:27', '2018-06-13 10:52:11', NULL, NULL, 0, NULL),
(262, 0, 0, 'TUBEX 0,12', 1, 1, NULL, 56, 398, 'TUBEST', NULL, NULL, 'Tubage flexible', '0', '0476-CPR-3730', 'Dopcpr03', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-06-13 12:09:03', '2018-06-13 12:22:39', NULL, NULL, 0, NULL),
(263, 0, 0, 'EXTRA TUBEX 0,12', 1, 1, NULL, 56, 398, 'TUBEST', NULL, NULL, 'Tubage flexible', '0', '0476-CPR-3730', 'Dopcpr03', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-06-13 12:13:47', '2018-06-13 13:20:55', NULL, NULL, 0, NULL),
(266, 0, 0, 'TUBEX 0,10', 1, 1, NULL, 56, 398, 'TUBEST', NULL, NULL, 'Tubage flexible', '0', '0476-CPR-3730', 'Dopcpr03', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'la fiche TUBEX 0.10 remplace la fiche TUBEX\nPhB : OK c\'est fait.', NULL, '2018-06-13 12:22:46', '2019-08-16 16:52:34', NULL, NULL, 0, NULL),
(267, 0, 0, 'TP INOX', 1, 1, NULL, 56, 398, 'TUBEST', NULL, NULL, 'Conduit de raccordement (simple paroi)', '0', '0476-CPR-3730', 'Dopcpr02', '48;', NULL, NULL, 'Non', '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'JE VIENS D\'AJOUTER CHARBON, CETTE FICHE REMPLACE L\'AUTRE FICHE TP INOX en raccordement\nPhB : OK autre fiche supprimée.\n\n\nMerci', NULL, '2018-06-13 12:25:51', '2019-06-13 15:51:47', NULL, NULL, 0, NULL),
(268, 0, 0, 'MONO FLAMME ACIER', 1, 1, NULL, 56, 398, 'TUBEST', NULL, NULL, 'Conduit de raccordement (simple paroi)', '0', '0476-CPR-3730', 'Dopcpr02', '48;', NULL, NULL, 'Non', '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-06-13 12:44:18', '2019-06-13 15:51:19', NULL, NULL, 0, NULL),
(269, 0, 0, 'COAX PELLET', 1, 1, NULL, 56, 398, 'TUBEST', NULL, NULL, 'Concentrique (non isolé)', '0', '0476-CPR-7609', 'Dopcpr08', '49;', NULL, NULL, 'Oui', '45', '18', '', '4', '', '2', '3', '20', '20', '500', '250', 'Les valeurs communiquées sont valables pour un diamètre maxi de 250 mm intérieur, pour un diamètre supérieur veuillez contacter TUBEST.', '3', '2018-06-13 13:23:38', '2019-06-14 08:59:27', NULL, NULL, 0, NULL),
(271, 0, 0, 'FERRO-LUX', 1, 1, NULL, 26, 350, 'JEREMIAS raccordement', NULL, 'conduit de raccordement simple paroi pour Bois Bûche - acier peint 2mm noir\nSaisi par F. SAEZ le 17/09/2018, et validé par PhB le même jour.', 'Conduit de raccordement (simple paroi)', '0', '0036CPR9174017', NULL, '48;', NULL, NULL, 'Non', '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-09-17 08:47:21', '2018-09-17 09:28:12', NULL, NULL, 0, NULL),
(272, 0, 0, 'EW-ECO 1.0 316L', 0, 0, NULL, 26, 350, 'JEREMIAS simple paroi inox', NULL, 'conduit simple paroi inox 316L avec joint silicone monté d\'usine.\nMis en ligne le 17/09/2018 puis retiré le jour même à la demande de Frédéric car remplacé par le tubage rigide EW-FU 06 Ti qui est sans joint et mieux adapté au bois.', 'Tubage rigide (simple paroi)', '0', '0036CPD9174029', NULL, '47;48;', NULL, NULL, 'Non', '45', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-09-17 08:58:18', '2020-05-23 03:47:23', NULL, NULL, 0, NULL),
(273, 0, 0, 'EW-PELLET 316L noir', 1, 1, NULL, 26, 350, 'JEREMIAS Pellet', NULL, 'conduit simple paroi inox 316L peint haute température noir.\nValidé par PhB le 18/09/2017.', 'Conduit de raccordement (simple paroi)', '0', '0036CPR9174072', NULL, '48;', NULL, NULL, 'Non', '45', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-09-17 15:19:05', '2018-09-18 17:09:24', NULL, NULL, 0, NULL),
(274, 0, 0, 'EW-FU 06 Ti', 1, 1, NULL, 26, 350, 'JEREMIAS SIMPLE PAROI tubage & raccordement', NULL, 'Sans joint.', 'Tubage rigide (simple paroi)', '0', '0036CPR9174006', NULL, '47;48;', NULL, NULL, 'Non', '46', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-09-17 15:27:43', '2019-03-18 15:01:08', NULL, NULL, 0, NULL),
(275, 0, 0, 'APOLLO PELLET SP NOIR', 1, 1, NULL, 14, 324, 'ISOTIP-JONCOUX', NULL, 'Version SANS joint Viton. Il existe une autre fiche avec joint Viton 3 lèvres de couleur noire classé T250.', 'Conduit de raccordement (simple paroi)', '0', '0071-CPR-0036', 'DOP00710036-PELLET', '48;', NULL, NULL, 'Non', '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Dans le cas d\'un tubage rigide, il faudra utiliser le tubage rigide APOLLO INOX, avec bride de sécurité. ', NULL, '2018-09-28 11:57:59', '2019-01-16 11:37:33', NULL, NULL, 0, NULL),
(277, 0, 0, 'APOLLO PELLET SP INOX', 1, 1, NULL, 14, 324, 'ISOTIP-JONCOUX', NULL, 'Version SANS joint Viton. Il existe une autre fiche avec joint Viton 3 lèvres de couleur noire classé T250.', 'Conduit de raccordement (simple paroi)', '0', '0071-CPR-0036', 'DOP00710036-PELLET', '48;', NULL, NULL, 'Non', '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Dans le cas d\'un tubage rigide, il faudra utiliser le tubage rigide APOLLO INOX, avec bride de sécurité. ', NULL, '2018-09-28 12:23:29', '2019-09-18 20:54:54', NULL, NULL, 0, NULL),
(278, 0, 0, 'APOLLO INOX', 1, 1, NULL, 14, 324, 'ISOTIP-JONCOUX', NULL, 'Pour une utilisation tubage rigide dans un conduit de fumée pour une application granulés de bois. Tubage à utiliser avec des brides de sécurité. ', 'Tubage rigide (simple paroi)', '0', '0071-CPR-0036', 'DOP00710036-A-INOX', '48;', NULL, NULL, 'Non', '44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Dans le cas d\'un tubage rigide, il faudra utiliser des brides de sécurités. ', NULL, '2018-09-28 12:24:54', '2018-10-12 19:59:03', NULL, NULL, 0, NULL),
(279, 0, 0, 'FLEXLISSE 316-HD', 1, 1, NULL, 14, 324, 'ISOTIP-JONCOUX', NULL, NULL, 'Tubage flexible', '0', '0071-CPR-0037', 'DOP2270024-FLEXLISSE', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RAYON MAXI DE COURBURE : \nØ80 à 200mm R = 1,5 x Ø\nØ 225 à 300mm R = 2 x Ø\nØ > 300 mm R = 3 x Ø', NULL, '2018-09-28 12:37:41', '2018-10-12 19:57:47', NULL, NULL, 0, NULL),
(281, 0, 0, 'STARFLEX+ 2010 ', 1, 1, NULL, 27, 352, 'Cheminées POUJOULAT ', NULL, 'Conduit circulaire double peau 2x0.10. Il est adapté pour le tubage des conduits de cheminées avec dévoiements : bois, gaz, fioul. ', 'Tubage flexible', '0', '0071-CPD-0047', '178031718FR', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-10-05 11:29:58', '2021-02-27 14:56:26', NULL, NULL, 0, NULL),
(282, 0, 0, 'STARFLEX+ 2012', 1, 1, NULL, 27, 352, 'Cheminées POUJOULAT ', NULL, 'Conduit circulaire double peau 2x0.12. Il est adapté pour le tubage des conduits de cheminées avec dévoiements : bois, gaz, fioul. ', 'Tubage flexible', '0', '0071-CPD-0047', '179031718FR', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-10-05 12:05:34', '2021-02-27 14:56:17', NULL, NULL, 0, NULL),
(283, 0, 0, 'Liss-ISO DP', 1, 1, NULL, 27, 352, 'Cheminées POUJOULAT', NULL, 'Fiche modifiée par PhB le 17/08/2019 car inversion entre Ru déclaré (0,45) et lambda demandé (0,073) pour une épaisseur de conduit de 33 mm au lieu de 25 mm (c\'est l\'épaisseur du conduit qu\'il faut déclarer et non l\'épaisseur de l\'isolant), et rayon mini ', 'Tubage flexible pré-isolé', '0', '0071-CPD-0053', '122031718FR', '47;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-10-05 13:04:22', '2019-08-17 07:55:55', NULL, NULL, 0, NULL),
(284, 0, 0, 'TUBAGINOX RIGIDE', 1, 1, NULL, 27, 352, 'Cheminées POUJOULAT', NULL, 'Le conduit TUBAGINOX RIGIDE permet d’améliorer le rendement de votre appareil de chauffage en apportant un dimensionnement adéquat, un tirage amélioré et une étanchéité parfaite.', 'Tubage rigide (simple paroi)', '0', '0071-CPR-0025', '075011718FR', '48;', NULL, NULL, 'Non', '44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'colliers de sécurité fournis', NULL, '2018-10-05 14:12:22', '2018-10-08 15:06:33', NULL, NULL, 0, NULL),
(285, 0, 0, 'KITINOX', 1, 1, NULL, 27, 352, 'Cheminées POUJOULAT', NULL, 'Soudés en continu, les conduits sont prévus pour résister aux très hautes températures dégagées\npar les foyers-inserts et apportent une sécurité optimale pour les utilisateurs.\n\n', 'Conduit de raccordement (simple paroi)', '0', '0071–CPD–0025', ' 080011718FR', '48;', NULL, NULL, 'Non', '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-10-05 14:35:42', '2020-06-01 13:45:24', NULL, NULL, 0, NULL),
(286, 0, 0, 'LISS-ISO DP', 1, 1, NULL, 27, 352, 'Cheminées POUJOULAT', NULL, 'Caractéristiques de chaque diamètre mises en accord avec le DTA 14-2006_V1 le 22/04/2019 (notamment lambda et épaisseur de la laine minérale).\nFiche modifiée par PhB le 17/08/2019 car, pour le moteur de calcul, il faut la vraie épaisseur du conduit, soit ', 'Double paroi isolé', '0', '0071-CPR-0053', '122031718FR', '47;', NULL, NULL, 'Non', '44', '10', '10', '3', '3', '1,45', '1.45', '20', '20', NULL, NULL, '', '10', '2018-10-08 07:15:17', '2021-02-27 15:02:31', NULL, NULL, 0, NULL),
(287, 0, 0, 'TUBOVALE', 1, 1, NULL, 27, 352, 'Cheminées POUJOULAT', NULL, 'TUBER UN CONDUIT DE CHEMINÉE DROIT ET RECTANGULAIRE: Le conduit TUBOVALE permet de conserver une section d’évacuation de fumée maximale, tout en bénéficiant des qualités du tubage rigide en Inox. Il est particulièrement adapté pour des besoins de foyer de', 'Tubage rigide (simple paroi)', '0', '0071-CPD-0042', '084011718FR', '48;', NULL, NULL, NULL, '44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-10-29 12:40:05', '2019-06-22 15:41:48', NULL, NULL, 0, NULL),
(288, 0, 0, 'Simple paroi acier peint', 1, 1, NULL, 14, 324, 'ISOTIP-JONCOUX', NULL, 'Conduit en acier aluminié épaisseur 1.8 mm', 'Conduit de raccordement (simple paroi)', '0', '0476-CPR-2977', 'DOP004APR', '48;', NULL, NULL, NULL, '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-11-26 11:37:09', '2020-11-08 18:01:42', NULL, NULL, 0, NULL),
(289, 0, 0, 'APOLLO PELLET SP INOX AVEC JOINT VITON', 1, 1, NULL, 14, 324, 'ISOTIP-JONCOUX', NULL, 'Version AVEC joint 3 lèvres Viton de couleur noire classé T250.', 'Conduit de raccordement (simple paroi)', '0', '0071-CPR-0036', 'DOP00710036-PELLET', '48;', NULL, NULL, 'Non', '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Dans le cas d\'un tubage rigide, il faudra utiliser le tubage rigide APOLLO INOX, avec bride de sécurité. ', NULL, '2019-01-16 10:48:41', '2019-01-16 11:32:33', NULL, NULL, 0, NULL),
(290, 0, 0, 'APOLLO PELLET SP NOIR AVEC JOINT VITON', 1, 1, NULL, 14, 324, 'ISOTIP-JONCOUX', NULL, 'Version AVEC joint 3 lèvres Viton de couleur noire classé T250.', 'Conduit de raccordement (simple paroi)', '0', '0071-CPR-0036', 'DOP00710036-PELLET', '48;', NULL, NULL, 'Non', '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Dans le cas d\'un tubage rigide, il faudra utiliser le tubage rigide APOLLO INOX, avec bride de sécurité. ', NULL, '2019-01-16 10:51:02', '2020-11-08 17:49:10', NULL, NULL, 0, NULL),
(291, 0, 0, 'APOLLO PELLET AVEC JOINT VITON', 1, 1, NULL, 14, 324, 'ISOTIP-JONCOUX', NULL, 'Version AVEC joint 3 lèvres Viton de couleur verte classé T250. ', 'Concentrique (non isolé)', '0', '0071-CPR-0035; 0071-CPR-23062', 'DOP00710035-A-PELLET', '47;49;', NULL, NULL, 'Oui', '45', '10', '2.5', '2.5', '1.5', '1.8', '3', '20', '20', '370', '370', 'Version avec joint 3 lèvres Viton de couleur verte classé T250. ', '10', '2019-01-16 10:52:21', '2019-01-16 11:29:14', NULL, NULL, 0, NULL),
(292, 0, 0, 'Sodinox acier 2 mm', 1, 1, NULL, 75, 425, 'Sodico', NULL, NULL, 'Conduit de raccordement (simple paroi)', '0', NULL, NULL, '48;', NULL, NULL, NULL, '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-01-21 12:59:44', '2019-01-28 09:10:44', NULL, NULL, 0, NULL),
(293, 0, 0, 'Sodinox émail 1,2 mm D130 à 200', 1, 1, NULL, 75, 425, 'Sodico', NULL, 'Fiche crée par Florent à l\'origine en 01/2019 avec seulement le diamètre 150 mm.\nComplétée par PhB sur indications de Florent en 11/2020 avec les diamètres 130, 180 et 200.', 'Conduit de raccordement (simple paroi)', '0', NULL, NULL, '48;', NULL, NULL, NULL, '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-01-21 13:14:35', '2021-06-23 13:56:45', NULL, NULL, 0, NULL),
(294, 0, 0, 'DUOTEN INOX 316/304', 1, 1, NULL, 76, 427, 'TEN', NULL, NULL, 'Double paroi isolé', '0', '2270-CPR-042 Rev.03', 'TEN05', '47;', NULL, NULL, 'Oui', '44', '10', '3', '2', '1', '1.5', '2.5', '20', '20', '286', '286', '', '3', '2019-02-25 08:04:10', '2021-01-23 19:06:24', NULL, NULL, 0, NULL),
(295, 0, 0, 'DUOTEN INOX 304/304', 1, 1, NULL, 76, 427, 'TEN', NULL, NULL, 'Double paroi isolé', '0', '2270-CPR-042 Rev.03', 'TEN05', '47;', NULL, NULL, 'Oui', '44', '10', '3', '2', '1', '1.5', '2.5', '20', '20', '286', '286', '', '3', '2019-02-25 09:04:36', '2019-02-25 09:46:24', NULL, NULL, 0, NULL),
(296, 0, 0, 'DUOTEN INOX 304/GALVA', 1, 1, NULL, 76, 427, 'TEN', NULL, NULL, 'Double paroi isolé', '0', '2270-CPR-042 Rev.03', 'TEN05', '47;', NULL, NULL, 'Oui', '44', '10', '3', '2', '1', '1.5', '2.5', '20', '20', '286', '286', '', '3', '2019-02-25 09:13:06', '2019-02-25 09:47:09', NULL, NULL, 0, NULL),
(297, 0, 0, 'DUOTEN INOX 316/304 GRANULE', 1, 1, NULL, 76, 427, 'TEN', NULL, NULL, 'Double paroi isolé', '0', '2270-CPR-042 Rev.03', 'TEN05', '47;', NULL, NULL, 'Oui', '44', '10', '3', '2', '1', '1.5', '2.5', '20', '20', '286', '286', '', '3', '2019-02-25 09:22:35', '2019-02-25 09:55:44', NULL, NULL, 0, NULL),
(298, 0, 0, 'TUYAU EMAIL', 1, 1, NULL, 76, 427, 'TEN', NULL, NULL, 'Conduit de raccordement (simple paroi)', '0', '2270-CPR-048 Rev.01', 'TEN09', '48;', NULL, NULL, NULL, '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-02-25 09:58:38', '2019-02-25 11:03:24', NULL, NULL, 0, NULL),
(299, 0, 0, 'TEN LISS', 1, 1, NULL, 76, 427, 'TEN', NULL, NULL, 'Tubage flexible', '0', '2270-CPR-040 Rev.03', 'TEN01', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-02-25 10:40:58', '2021-05-04 09:12:14', NULL, NULL, 0, NULL),
(300, 0, 0, 'BIOTEN', 1, 1, NULL, 76, 427, 'TEN', NULL, NULL, 'Concentrique (non isolé)', '0', '2270-CPR-041 Rev.03 (EN 14989-2);2270-CPR-053 Rev.03 (EN 1856-1)', 'TEN04', '47;49;', NULL, NULL, 'Oui', '43', '5', '3', '2', '1', '', '', '20', '20', '286', '286', '', '3', '2019-02-25 13:33:06', '2019-02-26 14:17:58', NULL, NULL, 0, NULL),
(301, 0, 0, 'CONDUIT EMAIL POUR POELES A GRANULES DE BOIS', 1, 1, NULL, 76, 427, 'TEN', NULL, NULL, 'Conduit de raccordement (simple paroi)', '0', '2270-CPR-047 Rev.01', 'TEN08', '48;', NULL, NULL, NULL, '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-02-25 14:05:19', '2019-02-26 14:19:50', NULL, NULL, 0, NULL),
(302, 0, 0, 'TUBAGE TEN PRE-ISOLE', 1, 1, NULL, 76, 427, 'TEN', NULL, NULL, 'Tubage flexible pré-isolé', '0', 'QB 19/01-2163', 'TEN14', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-02-25 14:28:12', '2019-04-13 09:21:02', NULL, NULL, 0, NULL),
(303, 0, 0, 'TUYAU INOX 304', 1, 1, NULL, 76, 427, 'TEN', NULL, NULL, 'Conduit de raccordement (simple paroi)', '0', '2270-CPR-049 Rev.01', 'TEN10', '48;', NULL, NULL, NULL, '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-02-26 14:18:18', '2019-02-26 15:02:52', NULL, NULL, 0, NULL),
(304, 0, 0, 'TUYAU INOX 304', 1, 1, NULL, 76, 427, 'TEN', NULL, NULL, 'Tubage rigide (simple paroi)', '0', '2270-CPR-049 Rev.01', 'TEN10', '48;', NULL, NULL, NULL, '44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-02-26 14:35:41', '2019-02-26 15:04:12', NULL, NULL, 0, NULL),
(305, 0, 0, 'SUPER TEN LISS', 1, 1, NULL, 76, 427, 'TEN', NULL, NULL, 'Tubage flexible', '0', '2270-CPR-040 Rev.03', 'TEN02', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-02-26 14:51:54', '2020-09-18 06:06:06', NULL, NULL, 0, NULL),
(306, 0, 0, 'SUPER TEN LISS HP', 1, 1, NULL, 76, 427, 'TEN', NULL, NULL, 'Tubage flexible', '0', '2270-CPR-040 Rev.03', 'TEN03', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-02-26 14:59:09', '2020-09-18 06:07:39', NULL, NULL, 0, NULL),
(307, 0, 0, 'TUYAU OVALE INOX 316', 1, 1, NULL, 76, 427, 'TEN', NULL, NULL, 'Tubage rigide (simple paroi)', '0', '2270-CPR-046 Rev.01', 'TEN07', '48;', NULL, NULL, NULL, '44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-02-26 15:09:06', '2019-02-26 16:12:26', NULL, NULL, 0, NULL),
(308, 0, 0, 'SDW50 INT. 316L / EXT. 304', 1, 1, NULL, 56, 398, 'TUBEST', NULL, NULL, 'Double paroi isolé', '0', '0476-CPR-3729', 'Dopcpr06', '47;', NULL, NULL, 'Non', '44', '8', '', '4', '', '2', '3', '20', '20', NULL, NULL, 'Les valeurs communiquées sont valables pour un diamètre maxi de 250 mm intérieur, pour un diamètre supérieur veuillez contacter TUBEST.', '3', '2019-05-28 08:49:30', '2019-06-13 15:50:47', NULL, NULL, 0, NULL),
(309, 0, 0, 'ARP DW25 INT. 316L / EXT. 304', 1, 1, NULL, 10, 433, 'ARPEGY', NULL, NULL, 'Double paroi isolé', '0', '0476-CPR-3729', 'Dopcpr01', '47;', NULL, NULL, 'Oui', '44', '11', '', '4', '', '2', '3', '20', '20', '1200', '400', 'Les valeurs communiquées sont valables pour un diamètre maxi de 250 mm intérieur, pour un diamètre supérieur veuillez contacter TUBEST.', '3', '2018-04-30 13:13:26', '2019-06-14 09:02:16', NULL, NULL, 0, NULL),
(310, 0, 0, 'ARP DP-FLAMME INT. 304 / EXT. 304', 1, 1, NULL, 10, 433, 'ARPEGY', NULL, NULL, 'Double paroi isolé', '0', '0476-CPR-3729', 'Dopcpr01', '47;', NULL, NULL, 'Oui', '44', '11', '', '4', '', '2', '3', '20', '20', '1200', '400', 'Les valeurs communiquées sont valables pour un diamètre maxi de 250 mm intérieur, pour un diamètre supérieur veuillez contacter TUBEST.', '3', '2018-04-30 15:21:00', '2019-06-13 16:11:50', NULL, NULL, 0, NULL),
(311, 0, 0, 'ARP TP INOX', 1, 1, NULL, 10, 324, 'ARPEGY', NULL, NULL, 'Tubage rigide (simple paroi)', '0', '0476-CPR-3730', 'Dopcpr02', '48;', NULL, NULL, 'Non', '44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-06-13 09:59:47', '2019-06-13 15:29:07', NULL, NULL, 0, NULL);
INSERT INTO `duct` (`id`, `current_step`, `third_party_of_user_created_by`, `label`, `is_completed`, `status`, `created_by`, `ref_manufacturer_ext_id`, `ref_brand_ext_id`, `brand_name`, `m_date_app`, `info`, `type`, `forme`, `certificat`, `dop`, `norme_controle`, `mail`, `coquille_isolante`, `dta`, `mise_oeuvre_a`, `mise_oeuvre_b`, `mise_oeuvre_c`, `mise_oeuvre_d`, `mise_oeuvre_e`, `mise_oeuvre_f`, `mise_oeuvre_g`, `mise_oeuvre_h`, `mise_oeuvre_i`, `mise_oeuvre_j`, `mise_oeuvre_k`, `mise_oeuvre_n`, `mise_oeuvre_o`, `created_at`, `updated_at`, `other_norme_controle`, `other_coquille_isolante`, `is_only_for_entreprise`, `online_at`) VALUES
(312, 0, 0, 'ARP TUBEX 0,12', 1, 1, NULL, 10, 433, 'ARPEGY', NULL, NULL, 'Tubage flexible', '0', '0476-CPR-3730', 'Dopcpr03', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-06-13 12:09:03', '2019-06-13 15:29:09', NULL, NULL, 0, NULL),
(313, 0, 0, 'ARP EXTRA TUBEX 0,12', 1, 1, NULL, 10, 433, 'ARPEGY', NULL, NULL, 'Tubage flexible', '0', '0476-CPR-3730', 'Dopcpr03', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2018-06-13 12:13:47', '2019-06-13 15:29:11', NULL, NULL, 0, NULL),
(314, 0, 0, 'ARP TUBEX 0,10', 1, 1, NULL, 10, 433, 'ARPEGY', NULL, NULL, 'Tubage flexible', '0', '0476-CPR-3730', 'Dopcpr03', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'la fiche TUBEX 0.10 remplace la fiche TUBEX\nPhB : OK c\'est fait.', NULL, '2018-06-13 12:22:46', '2019-06-13 15:29:13', NULL, NULL, 0, NULL),
(315, 0, 0, 'ARP TP INOX', 1, 1, NULL, 10, 433, 'ARPEGY', NULL, NULL, 'Conduit de raccordement (simple paroi)', '0', '0476-CPR-3730', 'Dopcpr02', '48;', NULL, NULL, 'Non', '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'JE VIENS D\'AJOUTER CHARBON, CETTE FICHE REMPLACE L\'AUTRE FICHE TP INOX en raccordement\nPhB : OK autre fiche supprimée.\n\n\nMerci', NULL, '2018-06-13 12:25:51', '2021-09-15 07:52:31', NULL, NULL, 0, NULL),
(316, 0, 0, 'ARP COAX PELLET', 1, 1, NULL, 10, 433, 'ARPEGY', NULL, NULL, 'Concentrique (non isolé)', '0', '0476-CPR-7609', 'Dopcpr08', '49;', NULL, NULL, NULL, '45', '18', '', '4', '', '2', '3', '20', '20', '500', '250', 'Les valeurs communiquées sont valables pour un diamètre maxi de 250 mm intérieur, pour un diamètre supérieur veuillez contacter TUBEST.', '3', '2018-06-13 13:23:38', '2019-06-14 08:59:23', NULL, NULL, 0, NULL),
(317, 0, 0, 'DIXINOX OBLONG', 1, 1, NULL, 19, 343, 'DIXNEUF', NULL, 'Fiche dupliquée par PhB le 21/06/2019 à partir de la fiche Poujoulat.', 'Tubage rigide (simple paroi)', '0', '0071-CPD-0042', '102012713FR', '48;', NULL, NULL, NULL, '44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-06-21 12:55:16', '2020-02-13 11:46:40', NULL, NULL, 0, NULL),
(318, 0, 0, 'DIXFLEX', 1, 1, NULL, 19, 343, 'DIXNEUF', NULL, 'Fiche dupliquée par PhB le 21/06/2019 à partir de la fiche Poujoulat du Starflex 2010 en ajoutant D110.', 'Tubage flexible', '0', '0071-CPD-0047', '056032713FR', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-06-21 12:57:43', '2019-06-24 14:53:13', NULL, NULL, 0, NULL),
(319, 0, 0, 'DIXINOX PGI', 1, 1, NULL, 19, 343, 'DIXNEUF', NULL, 'Fiche dupliquée par PhB le 21/06/2019 à partir de la fiche Poujoulat.', 'Concentrique (non isolé)', '0', '0071', 'DOP 015012713FR', '49;DTA CSTB 14/13-1943', NULL, NULL, 'Oui', '44', '10', '10', '2,5', '2,5', '1,2', '1,5', '180', '180', '180', '180', '', '10', '2019-06-21 13:00:04', '2019-06-24 14:53:11', NULL, NULL, 0, NULL),
(320, 0, 0, 'LISS-ISO DP', 1, 1, NULL, 19, 343, 'DIXNEUF', NULL, 'Fiche dupliquée par PhB le 21/06/2019 à partir de la fiche Poujoulat.', 'Double paroi isolé', '0', '0071-CPR-0053', '122031718FR', '47;', NULL, NULL, 'Non', '44', '10', '10', '3', '3', '1,45', '1.45', '20', '20', NULL, NULL, '', '10', '2019-06-21 13:02:27', '2019-06-24 14:53:08', NULL, NULL, 0, NULL),
(322, 0, 0, 'DIXINOX TI', 1, 1, NULL, 19, 343, 'DIXNEUF', NULL, 'Fiche dupliquée par PhB le 21/06/2019 à partir de la fiche Poujoulat.', 'Double paroi isolé', '0', '0071-CPR-0011', 'DOP 001012713FR', '47;', NULL, NULL, 'Oui', '44', '16', '0', '4', '3', '2', '3', '20', '20', '90', '90', '', '10', '2019-06-21 13:05:45', '2019-06-24 14:54:47', NULL, NULL, 0, NULL),
(323, 0, 0, 'DIXINOX ZI', 1, 1, NULL, 19, 343, 'DIXNEUF', NULL, 'Fiche dupliquée par PhB le 21/06/2019 à partir de la fiche Poujoulat.', 'Double paroi isolé', '0', '0071-CPR-0011', 'DOP 002012713FR', '47;', NULL, NULL, 'Oui', '44', '16', '0', '4', '3', '2', '3', '20', '20', '90', '90', '', '10', '2019-06-21 13:10:25', '2019-06-24 14:54:26', NULL, NULL, 0, NULL),
(325, 0, 0, 'EFFICIENCE-Galva', 1, 1, NULL, 19, 343, 'DIXNEUF', NULL, 'Fiche dupliquée par PhB le 21/06/2019 à partir de la fiche Poujoulat.', 'Triple paroi (concentrique isolé)', '0', '0071-CPR–24988', 'DOP 01401317FR', '49;', NULL, NULL, 'Oui', '44', '10', '10', '2.5', '2.5', '1.5', '1.5', '90', '90', '90', '90', '', '10', '2019-06-21 15:31:39', '2019-06-24 14:53:04', NULL, NULL, 0, NULL),
(326, 0, 0, 'EFFICIENCE', 1, 1, NULL, 19, 343, 'DIXNEUF', NULL, 'Fiche dupliquée par PhB le 21/06/2019 à partir de la fiche Poujoulat.', 'Triple paroi (concentrique isolé)', '0', '0071-CPR–24988', 'DOP 01401317FR', '49;', NULL, NULL, 'Oui', '44', '10', '10', '2.5', '2.5', '1.5', '1.5', '90', '90', '90', '90', '', '10', '2019-06-21 15:33:14', '2019-06-24 14:53:00', NULL, NULL, 0, NULL),
(327, 0, 0, 'WESTOVALE', 1, 1, NULL, 27, 351, 'WESTAFRANCE', NULL, 'Fiche dupliquée par PhB le 24/06/2019 selon le tableau des équivalences de JM Bironneau.', 'Tubage rigide (simple paroi)', '0', '0071-CPD-0042', '084011718FR', '48;', NULL, NULL, NULL, '44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-06-24 06:15:48', '2019-06-24 06:32:38', NULL, NULL, 0, NULL),
(328, 0, 0, 'LISFLEX DP', 1, 1, NULL, 27, 351, 'WESTAFRANCE', NULL, 'Fiche dupliquée par PhB le 24/06/2019 selon le tableau des équivalences de JM Bironneau.\nFiche modifiée par PhB le 17/08/2019 car, pour le moteur de calcul, il faut la vraie épaisseur du conduit, soit 33 mm, et non l\'épaisseur de 25 mm d\'isolant, et il fa', 'Double paroi isolé', '0', '0071-CPR-0053', '122031718FR', '47;', NULL, NULL, 'Non', '44', '10', '10', '3', '3', '1,45', '1.45', '20', '20', NULL, NULL, '', '10', '2019-06-24 06:18:14', '2019-08-17 08:01:22', NULL, NULL, 0, NULL),
(329, 0, 0, 'WESTINOX', 1, 1, NULL, 27, 351, 'WESTAFRANCE', NULL, 'Soudés en continu, les conduits sont prévus pour résister aux très hautes températures dégagées\npar les foyers-inserts et apportent une sécurité optimale pour les utilisateurs.\n\n', 'Conduit de raccordement (simple paroi)', '0', '0071–CPD–0025', ' 080011718FR', '48;', NULL, NULL, 'Non', '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-06-24 06:19:30', '2020-06-01 13:54:27', NULL, NULL, 0, NULL),
(330, 0, 0, 'RIGINOX RIGIDE', 1, 1, NULL, 27, 351, 'WESTAFRANCE', NULL, 'Fiche dupliquée par PhB le 24/06/2019 selon le tableau des équivalences de JM Bironneau.', 'Tubage rigide (simple paroi)', '0', '0071-CPR-0025', '075011718FR', '48;', NULL, NULL, 'Non', '44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'colliers de sécurité fournis', NULL, '2019-06-24 06:20:40', '2020-06-22 09:43:50', NULL, NULL, 0, NULL),
(331, 0, 0, 'Lisflex DP', 1, 1, NULL, 27, 351, 'WESTAFRANCE', NULL, 'Fiche dupliquée par PhB le 24/06/2019 selon le tableau des équivalences de JM Bironneau.\nFiche modifiée par PhB le 17/08/2019 car inversion entre Ru déclaré (0,45) et lambda demandé (0,073) pour une épaisseur de conduit de 33 mm au lieu de 25 mm (c\'est l\'', 'Tubage flexible pré-isolé', '0', '0071-CPD-0053', '122031718FR', '47;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-06-24 06:21:51', '2019-08-17 08:16:38', NULL, NULL, 0, NULL),
(332, 0, 0, 'Ventinox PGI', 1, 1, NULL, 27, 351, 'WESTAFRANCE', NULL, 'Fiche dupliquée par PhB le 24/06/2019 selon le tableau des équivalences de JM Bironneau.\nAjout du 130/200 le 1/06/2020 par PhB pour les chaudières.', 'Concentrique (non isolé)', '0', '0071', 'DOP 015012713FR', '49;DTA CSTB 14/13-1943', NULL, NULL, 'Oui', '44', '10', '10', '2,5', '2,5', '1,2', '1,5', '180', '180', '180', '180', '', '10', '2019-06-24 06:22:54', '2020-06-01 14:16:49', NULL, NULL, 0, NULL),
(333, 0, 0, 'FUMISTERIE ÉMAILLÉE', 1, 1, NULL, 27, 351, 'WESTAFRANCE', NULL, 'Fiche dupliquée par PhB le 24/06/2019 selon le tableau des équivalences de JM Bironneau.', 'Conduit de raccordement (simple paroi)', '0', '0407', 'DOP 12401917FR', '48;', NULL, NULL, 'Non', '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-06-24 06:23:57', '2019-12-02 18:51:53', NULL, NULL, 0, NULL),
(334, 0, 0, 'FUMISTERIE ACIER 2mm', 1, 1, NULL, 27, 351, 'WESTAFRANCE', NULL, 'Fiche dupliquée par PhB le 24/06/2019 selon le tableau des équivalences de JM Bironneau.', 'Conduit de raccordement (simple paroi)', '0', '0407', 'DOP 125012713FR', '48;', NULL, NULL, 'Non', '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-06-24 06:24:50', '2019-06-24 06:36:58', NULL, NULL, 0, NULL),
(335, 0, 0, 'FUMISTERIE ÉMAILLÉE pour poêle à granulés', 1, 1, NULL, 27, 351, 'WESTAFRANCE', NULL, 'Fiche dupliquée par PhB le 24/06/2019 selon le tableau des équivalences de JM Bironneau.', 'Conduit de raccordement (simple paroi)', '0', '0407', 'DOP 12401917FR', '48;', NULL, NULL, 'Non', '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-06-24 06:25:37', '2019-12-02 18:53:07', NULL, NULL, 0, NULL),
(336, 0, 0, 'CALORALUZINC', 1, 1, NULL, 27, 351, 'WESTAFRANCE', NULL, 'Fiche dupliquée par PhB le 24/06/2019 selon le tableau des équivalences de JM Bironneau.', 'Double paroi isolé', '0', '0071-CPR-0011', 'DOP 002012713FR', '47;', NULL, NULL, 'Oui', '44', '16', '0', '4', '3', '2', '3', '20', '20', '90', '90', '', '10', '2019-06-24 06:26:28', '2019-06-24 06:38:04', NULL, NULL, 0, NULL),
(337, 0, 0, 'CALORINOX', 1, 1, NULL, 27, 351, 'WESTAFRANCE', NULL, 'Fiche dupliquée par PhB le 24/06/2019 selon le tableau des équivalences de JM Bironneau.', 'Double paroi isolé', '0', '0071-CPR-0011', 'DOP 001012713FR', '47;', NULL, NULL, 'Oui', '44', '16', '0', '4', '3', '2', '3', '20', '20', '90', '90', '', '10', '2019-06-24 06:28:11', '2020-06-23 14:53:11', NULL, NULL, 0, NULL),
(338, 0, 0, 'ULTRAFLEX+ 2010', 1, 1, NULL, 27, 351, 'WESTAFRANCE', NULL, 'Fiche dupliquée par PhB le 24/06/2019 selon le tableau des équivalences de JM Bironneau.', 'Tubage flexible', '0', '0071-CPD-0047', '178031718FR', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-06-24 06:29:04', '2019-06-24 06:39:09', NULL, NULL, 0, NULL),
(339, 0, 0, 'ULTRAFLEX+ 2012', 1, 1, NULL, 27, 351, 'WESTAFRANCE', NULL, 'Fiche dupliquée par PhB le 24/06/2019 selon le tableau des équivalences de JM Bironneau.', 'Tubage flexible', '0', '0071-CPD-0047', '179031718FR', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-06-24 06:30:02', '2019-06-24 06:39:41', NULL, NULL, 0, NULL),
(340, 0, 0, 'DIXINOX', 1, 1, NULL, 19, 343, 'DIXNEUF', NULL, 'Tuyaux inox soudés en continu (= \"SOI\" de Poujoulat).\n\n', 'Conduit de raccordement (simple paroi)', '0', '0071–CPD–0042', 'DOP 100012713FR', '48;', NULL, NULL, 'Non', '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-06-25 13:28:31', '2020-06-01 13:35:54', NULL, NULL, 0, NULL),
(343, 0, 0, 'Emaillés Pellets 0.7', 1, 1, NULL, 11, 306, 'MODINOX', NULL, 'Tuyaux émaillés en épaisseur 0.7 mm pour le raccordement des poêles à granulés\nFinition noire MAT / jonctions discrètes / gorge et joint en partie mâle / joint viton monté d\'origine', 'Conduit de raccordement (simple paroi)', '0', '0476-CPR-7509', NULL, '48;', NULL, NULL, 'Non', '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-07-05 12:43:38', '2021-07-12 21:14:22', NULL, NULL, 0, NULL),
(344, 0, 0, 'POLYLISSE XT 10', 1, 1, NULL, 11, 306, 'MODINOX', NULL, NULL, 'Tubage flexible', '0', '2270-CPR-019-REV.05', '150-2FLEPOLIXT10-RPC', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-11-15 12:24:24', '2021-07-12 21:14:28', NULL, NULL, 0, NULL),
(345, 0, 0, 'POLYLISSE XT 11', 1, 1, NULL, 11, 306, 'MODINOX', NULL, NULL, 'Tubage flexible', '0', '2270-CPR-019-REV.05', '151-2FLEPOLIXT11-RPC', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-11-15 13:01:18', '2021-07-12 21:14:38', NULL, NULL, 0, NULL),
(346, 0, 0, 'POLYLISSE XT 12', 1, 1, NULL, 11, 306, 'MODINOX', NULL, NULL, 'Tubage flexible', '0', '2270-CPR-019-REV.05', '152-2FLEPOLIXT12-RPC', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-11-15 13:05:10', '2021-07-12 21:14:50', NULL, NULL, 0, NULL),
(347, 0, 0, 'POLYLISSE XT 904 10', 1, 1, NULL, 11, 306, 'MODINOX', NULL, 'Nota PhB : Gilbert Ruffenach m\'a confirmé par email du 6/01/2020 que ce tubage est proposé uniquement dans les diamètres 230, 250 et 280.', 'Tubage flexible', '0', '2270-CPR-019-REV.05', '153-2FLEPOLIXT10-RPC', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2019-11-15 13:11:18', '2021-07-12 21:14:57', NULL, NULL, 0, NULL),
(348, 0, 0, 'ORION - Finition galva', 1, 1, NULL, 14, 324, 'ISOTIP-JONCOUX', NULL, NULL, 'Double paroi isolé', '0', '0071-CPR-0004', 'DOP00710004-ORION', '47;', NULL, NULL, 'Oui', '44', '10', '2.5', '2.5', '1.5', '2.2', '3', '20', '20', '370', '370', 'Les tés, coudes et éléments ajustables ne doivent supporter aucune charge', '10', '2020-01-31 07:56:28', '2021-07-17 10:25:05', NULL, NULL, 0, NULL),
(350, 0, 0, 'ORION - Finition inox', 1, 1, NULL, 14, 324, 'ISOTIP-JONCOUX', NULL, NULL, 'Double paroi isolé', '0', '0071-CPR-0004', 'DOP00710004-ORION', '47;', NULL, NULL, 'Oui', '44', '10', '2.5', '2.5', '1.5', '2.2', '3', '20', '20', '370', '370', 'Les tés, coudes et éléments ajustables ne doivent supporter aucune charge', '10', '2020-01-31 08:27:31', '2020-03-13 14:15:25', NULL, NULL, 0, NULL),
(352, 0, 0, 'DW PELLETS sans joint', 1, 1, NULL, 39, 371, 'DINAK', NULL, 'Conduit double paroi isolé avec 30 mm de laine de roche', 'Double paroi isolé', '0', '0036 CPR 90220 001 Rev. 09', 'DOP-DW PELLETS-041', '47;', NULL, NULL, 'Non', '44', '30', '4', '4', '3', '2', '3', '', '', '', '', 'Exclusivité DINAK : colliers muraux faisant office de colliers d\'union. Permet de répartir également la charge sur toute la verticale et de ne plus avoir de chaise murale en pieds de conduit', '4', '2020-05-18 13:39:49', '2020-05-28 15:12:06', NULL, NULL, 0, NULL),
(353, 0, 0, 'DW PELLETS avec joints', 1, 1, NULL, 39, 371, 'DINAK', NULL, 'Conduit double paroi isolé avec joint d\'étanchéité et 30 mm de laine de roche', 'Double paroi isolé', '0', '0036 CPR 90220 001 Rev. 09', 'DOP-DW PELLETS-041', '47;', NULL, NULL, 'Non', '44', '30', '4', '4', '3', '2', '3', '', '', '', '', 'Exclusivité DINAK : colliers muraux faisant office de colliers d\'union. Permet de répartir également la charge sur toute la verticale et de ne plus avoir de chaise murale en pieds de conduit', '4', '2020-05-25 16:41:22', '2020-08-29 16:31:30', NULL, NULL, 0, NULL),
(354, 0, 0, 'Tuyaux émaillés (pour poêle à bûches)', 1, 1, NULL, 19, 343, 'Dixneuf', NULL, 'Le catalogue technique \"référence\" de DIXNEUF précise que ce conduit est \"sans joint silicone\".', 'Conduit de raccordement (simple paroi)', '0', '1004 - CPD - 004 / 2007', NULL, '48;EN 15287-1 2008-11', NULL, NULL, NULL, '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2020-05-28 13:47:13', '2020-05-29 12:20:15', NULL, NULL, 0, NULL),
(355, 0, 0, 'Tuyaux acier 2 mm', 1, 1, NULL, 19, 343, 'Dixneuf', NULL, 'Sans joint', 'Conduit de raccordement (simple paroi)', '0', '1004 - CPD - 0004 / 2007', NULL, '48;EN 15287-1 2008-11', NULL, NULL, NULL, '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2020-05-28 14:03:18', '2021-05-12 11:37:05', NULL, NULL, 0, NULL),
(356, 0, 0, 'Tuyaux émaillés (pour poêle à granulés)', 1, 1, NULL, 19, 343, 'Dixneuf', NULL, 'Le catalogue technique \"référence\" de DIXNEUF précise que ce conduit est \"avec joint silicone\".', 'Conduit de raccordement (simple paroi)', '0', '1004 - CPD - 0004 / 2007', NULL, '48;EN 15287-1 2008-11', NULL, NULL, NULL, '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2020-05-28 14:14:04', '2020-05-29 12:23:40', NULL, NULL, 0, NULL),
(357, 0, 0, 'FUMISTERIE INOX SOI', 1, 1, NULL, 27, 352, 'Cheminées POUJOULAT', NULL, 'Soudés en continu, les conduits de FUMISTERIE INOX SOI sont utilisés pour le raccordement des chaudières gaz, fioul et bois hors condensation et haut rendement.\n\n', 'Conduit de raccordement (simple paroi)', '0', '0071-CPR-0042 Rev. 14.', '098011818FR', '48;', NULL, NULL, 'Non', '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2020-06-02 06:46:05', '2020-06-19 13:58:51', NULL, NULL, 0, NULL),
(358, 0, 0, 'Soudé INOX ', 1, 1, NULL, 27, 351, 'Westafrance', NULL, 'Soudés en continu, les conduits Soudé INOX sont utilisés pour le raccordement des chaudières gaz, fioul et bois hors condensation et haut rendement.\n\n', 'Conduit de raccordement (simple paroi)', '0', '0071-CPR-0042 Rev. 14.', '099011818FR', '48;', NULL, NULL, 'Non', '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2020-06-02 07:12:30', '2020-06-02 07:40:15', NULL, NULL, 0, NULL),
(359, 0, 0, 'CONDENSOR CD', 1, 1, NULL, 27, 352, 'Cheminées POUJOULAT', NULL, 'Fiche dupliquée par JM Bironneau le 2/06/2020, et validée par PhB le 22/06/2020.\nLe conduit CONDENSOR CD permet d’améliorer le rendement de votre appareil de chauffage en apportant un dimensionnement adéquat, un tirage amélioré et une étanchéité parfaite.', 'Tubage rigide (simple paroi)', '0', '0071-CPR-11484 Rev. 9; 0071-CPR-11485 Rev. 6; 0071-CPR-0014 Rev. 18; 0071-CPR-0025 Rev. 12', ' 06601719FR', '48;', NULL, NULL, 'Non', '44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'colliers de sécurité fournis', NULL, '2020-06-02 08:33:17', '2020-06-22 09:48:10', NULL, NULL, 0, NULL),
(362, 0, 0, 'CONDENSOR CD', 1, 1, NULL, 27, 352, 'Cheminées POUJOULAT', NULL, 'Fiche dupliquée par JM Bironneau le 2/06/2020, et validée par PhB le 22/06/2020 après ajout des coudes 5, 15, 30, 42 et 87°.', 'Conduit de raccordement (simple paroi)', '0', '0071-CPR-11484 Rev. 9; 0071-CPR-11485 Rev. 6; 0071-CPR-0014 Rev. 18; 0071-CPR-0025 Rev. 12', ' 06601719FR', '48;', NULL, NULL, 'Non', '45', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'colliers de sécurité fournis', NULL, '2020-06-02 08:55:52', '2020-06-23 14:52:49', NULL, NULL, 0, NULL),
(363, 0, 0, 'RIGINOX RIGIDE ', 1, 1, NULL, 27, 351, 'WESTAFRANCE', NULL, 'Fiche dupliquée par JM Bironneau le 2/06/2020, et validée par PhB le 22/06/2020 après ajout des coudes 5, 15, 30, 42 et 87°.', 'Conduit de raccordement (simple paroi)', '0', '0071-CPR-0025', '075011718FR', '48;', NULL, NULL, 'Non', '45', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'colliers de sécurité fournis', NULL, '2020-06-02 08:57:43', '2020-06-22 09:41:57', NULL, NULL, 0, NULL),
(365, 0, 0, 'DW Bois', 1, 1, NULL, 39, 371, 'DINAK', NULL, 'Conduit double paroi isolé avec joint d\'étanchéité et 30 mm de laine de roche', 'Double paroi isolé', '0', '0036 CPR 90220 001 Rev. 09', 'DOP-DW-001', '47;', NULL, NULL, 'Non', '44', '19', '4', '4', '3', '2', '3', '', '', '', '', 'Exclusivité DINAK : colliers muraux faisant office de colliers d\'union. Permet de répartir également la charge sur toute la verticale et de ne plus avoir de chaise murale en pieds de conduit', '4', '2020-08-20 07:39:08', '2020-08-20 13:39:21', NULL, NULL, 0, NULL),
(366, 0, 0, 'DW Bois avec joints', 1, 1, NULL, 39, 371, 'DINAK', NULL, 'Conduit double paroi isolé avec joint d\'étanchéité et 30 mm de laine de roche', 'Double paroi isolé', '0', '0036 CPR 90220 001 Rev. 09', 'DOP-DW-001', '47;', NULL, NULL, 'Non', '44', '19', '4', '4', '3', '2', '3', '', '', '', '', 'Exclusivité DINAK : colliers muraux faisant office de colliers d\'union. Permet de répartir également la charge sur toute la verticale et de ne plus avoir de chaise murale en pieds de conduit', '4', '2020-08-20 09:17:44', '2020-08-20 11:47:07', NULL, NULL, 0, NULL),
(367, 0, 0, 'DW Bois (GALVA)', 1, 1, NULL, 39, 371, 'DINAK', NULL, 'Conduit double paroi isolé d\'étanchéité et 30 mm de laine de roche', 'Double paroi isolé', '0', '0036 CPR 90220 001 Rev. 09', 'DOP-DW-001', '47;', NULL, NULL, 'Non', '44', '19', '4', '4', '3', '2', '3', '', '', '', '', 'Exclusivité DINAK : colliers muraux faisant office de colliers d\'union. Permet de répartir également la charge sur toute la verticale et de ne plus avoir de chaise murale en pieds de conduit', '4', '2020-08-20 09:19:40', '2020-08-20 10:27:35', NULL, NULL, 0, NULL),
(368, 0, 0, 'DW Bois (GALVA) avec joints', 1, 1, NULL, 39, 371, 'DINAK', NULL, 'Conduit double paroi isolé avec joints d\'étanchéité et 30 mm de laine de roche', 'Double paroi isolé', '0', '0036 CPR 90220 001 Rev. 09', 'DOP-DW-001', '47;', NULL, NULL, 'Non', '44', '19', '4', '4', '3', '2', '3', '', '', '', '', 'Exclusivité DINAK : colliers muraux faisant office de colliers d\'union. Permet de répartir également la charge sur toute la verticale et de ne plus avoir de chaise murale en pieds de conduit', '4', '2020-08-20 09:39:19', '2020-08-20 13:13:23', NULL, NULL, 0, NULL),
(369, 0, 0, 'DEKO Pellets Classic', 1, 1, NULL, 39, 371, 'DINAK', NULL, 'Conduit simple paroi émaillé noir', 'Conduit de raccordement (simple paroi)', '0', '0036 CPR 90220 044 Rev 01', 'DOP-DEKO-PELLETS-044', '48;', NULL, NULL, 'Non', '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2020-08-20 09:43:01', '2020-08-29 17:13:40', NULL, NULL, 0, NULL),
(370, 0, 0, 'DEKO Pellets Classic avec joints', 1, 1, NULL, 39, 371, 'DINAK', NULL, 'Conduit simple paroi émaillé noir avec joints', 'Conduit de raccordement (simple paroi)', '0', '0036 CPR 90220 044 Rev 01', 'DOP-DEKO-PELLETS-044', '48;', NULL, NULL, 'Non', '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2020-08-20 09:46:12', '2020-08-20 13:38:34', NULL, NULL, 0, NULL),
(371, 0, 0, 'DEKO Pellets Style avec joints', 1, 1, NULL, 39, 371, 'DINAK', NULL, 'Conduit simple paroi émaillé noir avec joints', 'Conduit de raccordement (simple paroi)', '0', '0036 CPR 90220 044 Rev 01', 'DOP-DEKO-PELLETS-044', '48;', NULL, NULL, 'Non', '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2020-08-20 09:47:14', '2020-08-20 13:37:48', NULL, NULL, 0, NULL),
(372, 0, 0, 'DEKO Pellets Style', 1, 1, NULL, 39, 371, 'DINAK', NULL, 'Conduit simple paroi émaillé noir', 'Conduit de raccordement (simple paroi)', '0', '0036 CPR 90220 044 Rev 01', 'DOP-DEKO-PELLETS-044', '48;', NULL, NULL, 'Non', '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2020-08-20 09:49:55', '2020-08-20 13:37:07', NULL, NULL, 0, NULL),
(373, 0, 0, 'SW Pellets avec joints', 1, 1, NULL, 39, 371, 'DINAK', NULL, 'Conduit simple paroi avec joint d\'étanchéité intérieur', 'Conduit de raccordement (simple paroi)', '0', '0036 CPR 90220 004 Rev 05', 'DOP-SW-004', '48;', NULL, NULL, 'Non', '44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2020-08-28 06:53:16', '2020-08-29 16:20:05', NULL, NULL, 0, NULL),
(374, 0, 0, 'SW Pellets avec joints', 1, 1, NULL, 39, 371, 'DINAK', NULL, 'Conduit simple paroi avec joint d\'étanchéité intérieur', 'Tubage rigide (simple paroi)', '0', '0036 CPR 90220 004 Rev 05', 'DOP-SW-004', '48;', NULL, NULL, 'Non', '44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2020-08-28 07:04:46', '2020-08-29 16:20:16', NULL, NULL, 0, NULL),
(375, 0, 0, 'SW Pellets sans joint', 1, 1, NULL, 39, 371, 'DINAK', NULL, 'Conduit simple paroi', 'Conduit de raccordement (simple paroi)', '0', '0036 CPD 90220 038 Rev 01', 'DOP-SW-038', '48;', NULL, NULL, 'Non', '45', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2020-08-28 07:08:49', '2020-08-29 16:20:29', NULL, NULL, 0, NULL),
(376, 0, 0, 'SW Pellets sans joint', 1, 1, NULL, 39, 371, 'DINAK', NULL, 'Conduit simple paroi', 'Tubage rigide (simple paroi)', '0', '0036 CPD 90220 020 Rev 02', 'DOP-SW-020', '48;', NULL, NULL, 'Non', '44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2020-08-28 07:27:22', '2020-08-29 17:16:39', NULL, NULL, 0, NULL),
(377, 0, 0, 'Diflux Pellets sans joint', 1, 1, NULL, 39, 371, 'DINAK', NULL, 'Conduit concentrique inox pour poêles et chaudières granulés', 'Concentrique (non isolé)', '0', '0036 CPR 90220 025 Rev. 01', 'DOP DIFLUX PELLETS 025', '47;49;', NULL, NULL, 'Oui', '44', '3', '3', '3', '2.5', '2', '', '', '', '', '', '', '3', '2020-08-28 07:32:28', '2020-08-29 17:08:42', NULL, NULL, 0, NULL),
(378, 0, 0, 'Diflux Pellets Black sans joint', 1, 1, NULL, 39, 371, 'DINAK', NULL, 'Conduit concentrique inox laqué noir pour poêles et chaudières granulés', 'Concentrique (non isolé)', '0', '0036 CPR 90220 025 Rev. 01', 'DOP DIFLUX PELLETS 025', '47;49;', NULL, NULL, 'Oui', '44', '3', '3', '3', '2.5', '2', '', '', '', '', '', '', '3', '2020-08-28 07:52:48', '2020-08-29 17:09:00', NULL, NULL, 0, NULL),
(379, 0, 0, 'Diflux Pellets Black avec Joints', 1, 1, NULL, 39, 371, 'DINAK', NULL, 'Conduit concentrique inox laqué noir avec joints d\'étanchéité pour poêles et chaudières granulés', 'Concentrique (non isolé)', '0', '0036 CPR 90220 025 Rev. 01', 'DOP DIFLUX PELLETS 025', '47;49;', NULL, NULL, 'Oui', '44', '3', '3', '3', '2.5', '2', '', '', '', '', '', '', '3', '2020-08-28 07:53:47', '2020-08-29 17:08:18', NULL, NULL, 0, NULL),
(380, 0, 0, 'Diflux Pellets avec joints', 1, 1, NULL, 39, 371, 'DINAK', NULL, 'Conduit concentrique inox avec joints d\'étanchéité pour poêles et chaudières granulés', 'Concentrique (non isolé)', '0', '0036 CPR 90220 025 Rev. 01', 'DOP DIFLUX PELLETS 025', '47;49;', NULL, NULL, 'Oui', '44', '3', '3', '3', '2.5', '2', '', '', '', '', '', '', '3', '2020-08-28 07:55:17', '2020-08-29 17:11:59', NULL, NULL, 0, NULL),
(381, 0, 0, 'DEKO Bois', 1, 1, NULL, 39, 371, 'DINAK', NULL, 'Conduit à simple paroi émaillé noir mat extérieur des emboîtements esthétiques', 'Conduit de raccordement (simple paroi)', '0', '0036 CPR 90220 045 Rev. 01', 'DOP DEKO LENA 045', '48;', NULL, NULL, 'Non', '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2020-08-28 08:00:59', '2020-08-29 17:15:20', NULL, NULL, 0, NULL),
(382, 0, 0, 'SW Bois', 1, 1, NULL, 39, 371, 'DINAK', NULL, 'Conduit de simple paroi pour poêle à bois', 'Conduit de raccordement (simple paroi)', '0', '0036 CPD 90220 038', 'DOP SW 038', '48;', NULL, NULL, 'Non', '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Petit piquots surs la partie mâle', NULL, '2020-08-28 08:04:51', '2020-08-29 17:21:54', NULL, NULL, 0, NULL),
(383, 0, 0, 'SW Bois', 1, 1, NULL, 39, 371, 'DINAK', NULL, 'Conduit de simple paroi pour poêle à bois', 'Tubage rigide (simple paroi)', '0', '0036 CPD 90220 038', 'DOP SW 038', '48;', NULL, NULL, 'Non', '44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Petit piquots surs la partie mâle', NULL, '2020-08-28 08:09:30', '2020-08-29 17:20:02', NULL, NULL, 0, NULL),
(384, 0, 0, 'Dinaflex', 1, 1, NULL, 39, 371, 'DINAK', NULL, 'Conduit flexible pour tubage.\nNota PhB le 27/06/2021 : j\'ai validé cette fiche (T600, G),en modifiant l\'épaisseur du tubage qui est normalement 0,1 mm (mais sans connaitre l\'angle maxi de dévoiement, ni le rayon mini de courbure).', 'Tubage flexible', '0', '0476 CPR 6286', 'DOP DFINOX', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2020-08-28 08:18:24', '2021-06-27 16:00:48', NULL, NULL, 0, NULL),
(385, 0, 0, 'Dinaflex', 0, 0, NULL, 39, 371, 'DINAK', NULL, 'Conduit flexible pour tubage.\nNota PhB le 27/06/2021 : je n\'ai pas validé cette fiche pour 2 raisons :\n1) Pourquoi T200 et P1 ? (alors qu\'il existe de Dinaflex en T600 N1) \n2) Epaisseur paroi sera à modifier (0,1 mm au lieu 86 mm !).', 'Tubage flexible', '0', '0476 CPR 6286', 'DOP DFINOX', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2020-08-28 08:21:37', '2021-06-27 16:02:58', NULL, NULL, 0, NULL),
(386, 0, 0, 'Dinaflex insolé', 0, 0, NULL, 39, 0, 'DINAK', NULL, 'Conduti flexible isolé pour tubage', 'Tubage flexible pré-isolé', '0', '0476 CPR 6286', 'DOP DFISOLINOX', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2020-08-28 08:22:11', '2020-08-29 19:31:38', NULL, NULL, 0, NULL),
(387, 0, 0, 'Dinaflex isolé', 0, 0, NULL, 39, 371, 'DINAK', NULL, 'Conduit flexible isolé pour tubage.\nNota PhB le 29/08/2020 : si je valide cette fiche, il faudra modifier le lambda qui est incohérent (0,34).', 'Tubage flexible pré-isolé', '0', '0476 CPR 6286', 'DOP DFISOLINOX', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2020-08-28 08:25:52', '2020-08-29 19:31:28', NULL, NULL, 0, NULL),
(388, 0, 0, 'Dinaflex insolé-copie', 0, 0, NULL, 39, 0, 'DINAK', NULL, 'Conduti flexible isolé pour tubage', 'Tubage flexible pré-isolé', '0', '0476 CPR 6286', 'DOP DFISOLINOX', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2020-10-02 07:10:07', '2020-10-02 07:12:45', NULL, NULL, 0, NULL),
(389, 0, 0, 'Dinaflex isolé-copie', 0, 0, NULL, 39, 371, 'DINAK', NULL, 'Conduit flexible isolé pour tubage.\nNota PhB le 29/08/2020 : si je valide cette fiche, il faudra modifier le lambda qui est incohérent (0,34).', 'Tubage flexible pré-isolé', '0', '0476 CPR 6286', 'DOP DFISOLINOX', '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2020-10-02 07:12:25', '2020-10-02 07:12:25', NULL, NULL, 0, NULL),
(390, 0, 0, 'DW-FLEX', 0, 0, NULL, 26, 350, 'JEREMIAS', NULL, 'Non validé par PhB le 26/10/2020 car ép paroi int et Lambda incohérents.', 'Tubage flexible pré-isolé', '0', '0476-CPR-5169', NULL, '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2020-10-26 13:16:57', '2020-10-26 21:12:29', NULL, NULL, 0, NULL),
(391, 0, 0, 'LINE-FLEX', 1, 1, NULL, 26, 350, 'JEREMIAS', NULL, 'Validé par PhB le 26/10/2020.', 'Tubage flexible', '0', '0476-CPR-5169', NULL, '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2020-10-26 13:31:48', '2020-10-26 20:52:50', NULL, NULL, 0, NULL),
(392, 0, 0, 'DW-FLEX-copie', 0, 0, NULL, 26, 0, 'JEREMIAS', NULL, 'Non validé par PhB le 26/10/2020 car ép paroi int et Lambda incohérents.', 'Tubage flexible pré-isolé', '0', '0476-CPR-5169', NULL, '48;', NULL, NULL, NULL, '-', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'En remplacement de la fiche n°390', NULL, '2020-10-27 07:13:08', '2020-10-27 08:32:09', NULL, NULL, 0, NULL),
(393, 0, 0, 'Sodinox émail 0,6 mm D80&100', 1, 1, NULL, 75, 425, 'Sodico', NULL, 'Fiche crée par PhB sur indications de Florent en 11/2020 (copie de la fiche sur émail ép 1,2).', 'Conduit de raccordement (simple paroi)', '0', NULL, NULL, '48;', NULL, NULL, NULL, '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2020-11-06 18:45:46', '2020-11-06 18:49:41', NULL, NULL, 0, NULL),
(394, 0, 0, 'MC MONO', 1, 1, NULL, 47, 383, 'MC di Costa Moreno', NULL, 'Fiche renseignée par Chiara le 15/10/2020, validée par PhB le 23/01/2021.\nEPAISSEUR 0.5 mm \nDIAMETRES : 80 - 100 - 120 - 130 - 140 - 150 - 160 - 180 - 200 - 220 - 250 - 300 - 350 – 400 – 450 – 500 – 550 – 600 – 650\nProduction sur demande : \n- production e', 'Conduit de raccordement (simple paroi)', '0', '0407-CPR-422 (IG–094-2011)', '05MONO-CPR422', '48;', NULL, NULL, 'Non', '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2021-01-23 20:59:27', '2021-01-23 21:05:55', NULL, NULL, 0, NULL),
(399, 0, 0, 'MC MONO ép. 0.8 mm', 0, 0, NULL, 47, 0, 'MC di Costa Moreno', NULL, 'Fiche renseignée par Chiara le 15/10/2020, validée par PhB le 23/01/2021.\nDIAMETRES : 80 - 100 - 120 - 130 - 140 - 150 - 160 - 180 - 200 - 220 - 250 - 300 - 350 – 400 – 450 – 500 – 550 – 600 – 650\nProduction sur demande en épaisseur 0.8 mm\n• MATERIAU : in', 'Conduit de raccordement (simple paroi)', '0', '0407-CPR-422 (IG–094-2011)', '05MONO-CPR422', '48;', NULL, NULL, 'Non', '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2021-02-17 05:30:37', '2021-02-18 20:56:50', NULL, NULL, 0, NULL),
(400, 0, 0, 'MC MONO ép.1 mm', 0, 0, NULL, 47, 0, 'MC di Costa Moreno', NULL, 'Fiche renseignée par Chiara le 15/10/2020, validée par PhB le 23/01/2021.\nDIAMETRES : 80 - 100 - 120 - 130 - 140 - 150 - 160 - 180 - 200 - 220 - 250 - 300 - 350 – 400 – 450 – 500 – 550 – 600 – 650\nProduction sur demande en épaisseur 1 mm\n• MATERIAU : inox', 'Conduit de raccordement (simple paroi)', '0', '0407-CPR-422 (IG–094-2011)', '05MONO-CPR422', '48;', NULL, NULL, 'Non', '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2021-02-18 20:56:51', '2021-02-18 20:58:01', NULL, NULL, 0, NULL),
(401, 0, 0, 'MC BOIS', 0, 0, NULL, 47, 0, 'MC di Costa Moreno', NULL, 'TUYAUX ET ACCESSOIRES POUR POELES ET CHEMINEES A BOIS\nEPAISSEUR 20/10 RESISTANT A LA CORROSION\n• ligne acier REVETU D’ALUMINIUM DX53 + DS épaisseur 20/10\n• Diamètres produits 120-130-140-150-160-180-200-250\n• Entrée mâle-femelle avec étranglement 50 mm\n• ', 'Conduit de raccordement (simple paroi)', '0', '0476-CPR-7921', '20AL-CPR7921', '48;', NULL, NULL, 'Non', '43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2021-02-18 21:05:31', '2021-02-18 21:12:11', NULL, NULL, 0, NULL),
(402, 0, 0, 'EFFICIENCE-Galva pour granulés (W)', 1, 1, NULL, 27, 352, 'Cheminées Poujoulat', NULL, 'conduit concentrique étanche triple paroi isolé.\nFiche dupliquée par PhB le 27/02/2021 après m\'être rappelé que le DTA spécifie W/granulés et D/bûches (initialement le responsable Poujoulat avait enregistré à la fois pour  bûches et granulés, et saisi \"D\"', 'Triple paroi (concentrique isolé)', '0', '0071-CPR–24988', 'DOP 01401317FR', '49;', NULL, NULL, 'Oui', '44', '10', '10', '2.5', '2.5', '1.5', '1.5', '90', '90', '90', '90', '', '10', '2021-02-27 18:00:48', '2021-02-27 18:24:24', NULL, NULL, 0, NULL),
(403, 0, 0, 'EFFICIENCE pour granulés (W)', 1, 1, NULL, 27, 352, 'Cheminées Poujoulat', NULL, 'conduit concentrique étanche triple paroi isolé.\nFiche dupliquée par PhB le 27/02/2021 après m\'être rappelé que le DTA spécifie W/granulés et D/bûches (initialement le responsable Poujoulat avait enregistré à la fois pour bûches et granulés, et saisi \"D\")', 'Triple paroi (concentrique isolé)', '0', '0071-CPR–24988', 'DOP 01401317FR', '49;', NULL, NULL, 'Oui', '44', '10', '10', '2.5', '2.5', '1.5', '1.5', '90', '90', '90', '90', '', '10', '2021-02-27 18:11:50', '2021-09-09 15:51:09', NULL, NULL, 0, NULL),
(405, 0, 0, 'Série acier laqué 2 mm', 0, 0, NULL, 10, 0, 'ARPEGY', NULL, NULL, 'Conduit de raccordement (simple paroi)', '0', NULL, '001DOP2013-07', '48;', NULL, NULL, NULL, '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2021-09-14 07:07:05', '2021-09-15 08:40:59', NULL, NULL, 0, NULL),
(406, 0, 0, 'Série pellet émaillé 0.6', 0, 0, NULL, 10, 0, 'ARPEGY', NULL, 'Avec joint Viton, sans bourrelet', 'Conduit de raccordement (simple paroi)', '0', NULL, '06EMDOP18-PEL', '48;', NULL, NULL, NULL, '69', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2021-09-15 08:42:19', '2021-09-15 08:44:18', NULL, NULL, 0, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `file`
--

CREATE TABLE `file` (
  `id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `updated_at` datetime DEFAULT NULL COMMENT '(DC2Type:datetime)',
  `company_id` int DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `publication_date` datetime DEFAULT NULL COMMENT '(DC2Type:datetime)',
  `section` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_visible` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `final_customer`
--

CREATE TABLE `final_customer` (
  `id` int NOT NULL,
  `address_id` int DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `source` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL COMMENT '(DC2Type:datetime)',
  `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `civility` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `agency_id` int DEFAULT NULL,
  `firstname` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `fos_group`
--

CREATE TABLE `fos_group` (
  `id` int NOT NULL,
  `name` varchar(180) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `roles` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `fos_group`
--

INSERT INTO `fos_group` (`id`, `name`, `roles`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'a:365:{i:0;s:21:\"ROLE_API_LANGUAGE_GET\";i:1;s:22:\"ROLE_API_LANGUAGE_LIST\";i:2;s:22:\"ROLE_API_LANGUAGE_POST\";i:3;s:21:\"ROLE_API_LANGUAGE_PUT\";i:4;s:24:\"ROLE_API_LANGUAGE_DELETE\";i:5;s:16:\"ROLE_API_TAG_GET\";i:6;s:17:\"ROLE_API_TAG_LIST\";i:7;s:17:\"ROLE_API_TAG_POST\";i:8;s:16:\"ROLE_API_TAG_PUT\";i:9;s:19:\"ROLE_API_TAG_DELETE\";i:10;s:18:\"ROLE_API_GROUP_GET\";i:11;s:19:\"ROLE_API_GROUP_LIST\";i:12;s:19:\"ROLE_API_GROUP_POST\";i:13;s:18:\"ROLE_API_GROUP_PUT\";i:14;s:21:\"ROLE_API_GROUP_DELETE\";i:15;s:20:\"ROLE_API_COUNTRY_GET\";i:16;s:21:\"ROLE_API_COUNTRY_LIST\";i:17;s:21:\"ROLE_API_COUNTRY_POST\";i:18;s:20:\"ROLE_API_COUNTRY_PUT\";i:19;s:23:\"ROLE_API_COUNTRY_DELETE\";i:20;s:26:\"ROLE_API_SIMCARDFORMAT_GET\";i:21;s:27:\"ROLE_API_SIMCARDFORMAT_LIST\";i:22;s:27:\"ROLE_API_SIMCARDFORMAT_POST\";i:23;s:26:\"ROLE_API_SIMCARDFORMAT_PUT\";i:24;s:29:\"ROLE_API_SIMCARDFORMAT_DELETE\";i:25;s:21:\"ROLE_API_OPERATOR_GET\";i:26;s:22:\"ROLE_API_OPERATOR_LIST\";i:27;s:22:\"ROLE_API_OPERATOR_POST\";i:28;s:21:\"ROLE_API_OPERATOR_PUT\";i:29;s:24:\"ROLE_API_OPERATOR_DELETE\";i:30;s:21:\"ROLE_API_CURRENCY_GET\";i:31;s:22:\"ROLE_API_CURRENCY_LIST\";i:32;s:22:\"ROLE_API_CURRENCY_POST\";i:33;s:21:\"ROLE_API_CURRENCY_PUT\";i:34;s:24:\"ROLE_API_CURRENCY_DELETE\";i:35;s:22:\"ROLE_API_AFFILIATE_GET\";i:36;s:23:\"ROLE_API_AFFILIATE_LIST\";i:37;s:23:\"ROLE_API_AFFILIATE_POST\";i:38;s:22:\"ROLE_API_AFFILIATE_PUT\";i:39;s:25:\"ROLE_API_AFFILIATE_DELETE\";i:40;s:17:\"ROLE_API_USER_GET\";i:41;s:18:\"ROLE_API_USER_LIST\";i:42;s:18:\"ROLE_API_USER_POST\";i:43;s:17:\"ROLE_API_USER_PUT\";i:44;s:20:\"ROLE_API_USER_DELETE\";i:45;s:19:\"ROLE_API_REGION_GET\";i:46;s:20:\"ROLE_API_REGION_LIST\";i:47;s:20:\"ROLE_API_REGION_POST\";i:48;s:19:\"ROLE_API_REGION_PUT\";i:49;s:22:\"ROLE_API_REGION_DELETE\";i:50;s:18:\"ROLE_API_ROLES_GET\";i:51;s:27:\"ROLE_API_BOXAFFECTATION_GET\";i:52;s:28:\"ROLE_API_BOXAFFECTATION_LIST\";i:53;s:28:\"ROLE_API_BOXAFFECTATION_POST\";i:54;s:27:\"ROLE_API_BOXAFFECTATION_PUT\";i:55;s:30:\"ROLE_API_BOXAFFECTATION_DELETE\";i:56;s:21:\"ROLE_API_BOXMODEL_GET\";i:57;s:22:\"ROLE_API_BOXMODEL_LIST\";i:58;s:22:\"ROLE_API_BOXMODEL_POST\";i:59;s:21:\"ROLE_API_BOXMODEL_PUT\";i:60;s:24:\"ROLE_API_BOXMODEL_DELETE\";i:61;s:19:\"ROLE_API_DEVICE_GET\";i:62;s:20:\"ROLE_API_DEVICE_LIST\";i:63;s:20:\"ROLE_API_DEVICE_POST\";i:64;s:19:\"ROLE_API_DEVICE_PUT\";i:65;s:22:\"ROLE_API_DEVICE_DELETE\";i:66;s:16:\"ROLE_API_SIM_GET\";i:67;s:17:\"ROLE_API_SIM_LIST\";i:68;s:16:\"ROLE_API_SIM_PUT\";i:69;s:19:\"ROLE_API_SIM_DELETE\";i:70;s:23:\"ROLE_API_SIMVERSION_GET\";i:71;s:24:\"ROLE_API_SIMVERSION_LIST\";i:72;s:24:\"ROLE_API_SIMVERSION_POST\";i:73;s:23:\"ROLE_API_SIMVERSION_PUT\";i:74;s:26:\"ROLE_API_SIMVERSION_DELETE\";i:75;s:27:\"ROLE_API_PAYEMENTMETHOD_GET\";i:76;s:28:\"ROLE_API_PAYEMENTMETHOD_LIST\";i:77;s:28:\"ROLE_API_PAYEMENTMETHOD_POST\";i:78;s:27:\"ROLE_API_PAYEMENTMETHOD_PUT\";i:79;s:30:\"ROLE_API_PAYEMENTMETHOD_DELETE\";i:80;s:21:\"ROLE_API_CUSTOMER_GET\";i:81;s:22:\"ROLE_API_CUSTOMER_LIST\";i:82;s:22:\"ROLE_API_CUSTOMER_POST\";i:83;s:21:\"ROLE_API_CUSTOMER_PUT\";i:84;s:24:\"ROLE_API_CUSTOMER_DELETE\";i:85;s:19:\"ROLE_API_AGENCY_GET\";i:86;s:20:\"ROLE_API_AGENCY_LIST\";i:87;s:20:\"ROLE_API_AGENCY_POST\";i:88;s:19:\"ROLE_API_AGENCY_PUT\";i:89;s:22:\"ROLE_API_AGENCY_DELETE\";i:90;s:20:\"ROLE_API_ADDRESS_GET\";i:91;s:21:\"ROLE_API_ADDRESS_LIST\";i:92;s:21:\"ROLE_API_ADDRESS_POST\";i:93;s:20:\"ROLE_API_ADDRESS_PUT\";i:94;s:23:\"ROLE_API_ADDRESS_DELETE\";i:95;s:26:\"ROLE_API_MUTUALIZATION_GET\";i:96;s:27:\"ROLE_API_MUTUALIZATION_LIST\";i:97;s:27:\"ROLE_API_MUTUALIZATION_POST\";i:98;s:26:\"ROLE_API_MUTUALIZATION_PUT\";i:99;s:29:\"ROLE_API_MUTUALIZATION_DELETE\";i:100;s:22:\"ROLE_API_ORDERLINE_GET\";i:101;s:23:\"ROLE_API_ORDERLINE_LIST\";i:102;s:23:\"ROLE_API_ORDERLINE_POST\";i:103;s:22:\"ROLE_API_ORDERLINE_PUT\";i:104;s:25:\"ROLE_API_ORDERLINE_DELETE\";i:105;s:21:\"ROLE_API_SHIPMENT_GET\";i:106;s:22:\"ROLE_API_SHIPMENT_LIST\";i:107;s:22:\"ROLE_API_SHIPMENT_POST\";i:108;s:21:\"ROLE_API_SHIPMENT_PUT\";i:109;s:24:\"ROLE_API_SHIPMENT_DELETE\";i:110;s:18:\"ROLE_API_ORDER_GET\";i:111;s:19:\"ROLE_API_ORDER_LIST\";i:112;s:19:\"ROLE_API_ORDER_POST\";i:113;s:18:\"ROLE_API_ORDER_PUT\";i:114;s:21:\"ROLE_API_ORDER_DELETE\";i:115;s:34:\"ROLE_API_DEFAULTCARDORDERPRICE_GET\";i:116;s:35:\"ROLE_API_DEFAULTCARDORDERPRICE_LIST\";i:117;s:35:\"ROLE_API_DEFAULTCARDORDERPRICE_POST\";i:118;s:34:\"ROLE_API_DEFAULTCARDORDERPRICE_PUT\";i:119;s:37:\"ROLE_API_DEFAULTCARDORDERPRICE_DELETE\";i:120;s:36:\"ROLE_API_SIMORDERLINEAFFECTATION_GET\";i:121;s:37:\"ROLE_API_SIMORDERLINEAFFECTATION_LIST\";i:122;s:27:\"ROLE_API_CARDORDERPRICE_GET\";i:123;s:28:\"ROLE_API_CARDORDERPRICE_LIST\";i:124;s:28:\"ROLE_API_CARDORDERPRICE_POST\";i:125;s:27:\"ROLE_API_CARDORDERPRICE_PUT\";i:126;s:30:\"ROLE_API_CARDORDERPRICE_DELETE\";i:127;s:20:\"ROLE_API_CARRIER_GET\";i:128;s:21:\"ROLE_API_CARRIER_LIST\";i:129;s:21:\"ROLE_API_CARRIER_POST\";i:130;s:20:\"ROLE_API_CARRIER_PUT\";i:131;s:23:\"ROLE_API_CARRIER_DELETE\";i:132;s:23:\"ROLE_API_SIMRETURN_POST\";i:133;s:47:\"ROLE_API_SIMORDERLINEAFFECTATIONBULKDELETE_POST\";i:134;s:20:\"ROLE_API_INVOICE_GET\";i:135;s:21:\"ROLE_API_INVOICE_LIST\";i:136;s:24:\"ROLE_API_BILLINGPOST_GET\";i:137;s:25:\"ROLE_API_BILLINGPOST_LIST\";i:138;s:25:\"ROLE_API_BILLINGPOST_POST\";i:139;s:24:\"ROLE_API_BILLINGPOST_PUT\";i:140;s:27:\"ROLE_API_BILLINGPOST_DELETE\";i:141;s:16:\"ROLE_API_VAT_GET\";i:142;s:17:\"ROLE_API_VAT_LIST\";i:143;s:17:\"ROLE_API_VAT_POST\";i:144;s:16:\"ROLE_API_VAT_PUT\";i:145;s:19:\"ROLE_API_VAT_DELETE\";i:146;s:23:\"ROLE_API_REGULATION_GET\";i:147;s:24:\"ROLE_API_REGULATION_LIST\";i:148;s:24:\"ROLE_API_REGULATION_POST\";i:149;s:23:\"ROLE_API_REGULATION_PUT\";i:150;s:26:\"ROLE_API_REGULATION_DELETE\";i:151;s:29:\"ROLE_API_INVOICESDOWNLOAD_GET\";i:152;s:17:\"ROLE_API_NOTE_GET\";i:153;s:18:\"ROLE_API_NOTE_LIST\";i:154;s:18:\"ROLE_API_NOTE_POST\";i:155;s:17:\"ROLE_API_NOTE_PUT\";i:156;s:20:\"ROLE_API_NOTE_DELETE\";i:157;s:17:\"ROLE_API_LOGS_GET\";i:158;s:18:\"ROLE_API_LOGS_POST\";i:159;s:17:\"ROLE_API_LOGS_PUT\";i:160;s:20:\"ROLE_API_LOGS_DELETE\";i:161;s:29:\"ROLE_API_OPERATORSIMSTATS_GET\";i:162;s:28:\"ROLE_API_ORDERLINESSTATS_GET\";i:163;s:28:\"ROLE_API_CHANGEPASSWORD_POST\";i:164;s:22:\"ROLE_API_SMSZONING_GET\";i:165;s:23:\"ROLE_API_SMSZONING_LIST\";i:166;s:23:\"ROLE_API_SMSZONING_POST\";i:167;s:22:\"ROLE_API_SMSZONING_PUT\";i:168;s:25:\"ROLE_API_SMSZONING_DELETE\";i:169;s:18:\"ROLE_API_USAGE_GET\";i:170;s:19:\"ROLE_API_USAGE_LIST\";i:171;s:19:\"ROLE_API_USAGE_POST\";i:172;s:18:\"ROLE_API_USAGE_PUT\";i:173;s:21:\"ROLE_API_USAGE_DELETE\";i:174;s:22:\"ROLE_API_OFFERTYPE_GET\";i:175;s:23:\"ROLE_API_OFFERTYPE_LIST\";i:176;s:23:\"ROLE_API_OFFERTYPE_POST\";i:177;s:22:\"ROLE_API_OFFERTYPE_PUT\";i:178;s:25:\"ROLE_API_OFFERTYPE_DELETE\";i:179;s:29:\"ROLE_API_PROVIDERBUSINESS_GET\";i:180;s:30:\"ROLE_API_PROVIDERBUSINESS_LIST\";i:181;s:30:\"ROLE_API_PROVIDERBUSINESS_POST\";i:182;s:29:\"ROLE_API_PROVIDERBUSINESS_PUT\";i:183;s:32:\"ROLE_API_PROVIDERBUSINESS_DELETE\";i:184;s:19:\"ROLE_API_OPTION_GET\";i:185;s:20:\"ROLE_API_OPTION_LIST\";i:186;s:20:\"ROLE_API_OPTION_POST\";i:187;s:19:\"ROLE_API_OPTION_PUT\";i:188;s:22:\"ROLE_API_OPTION_DELETE\";i:189;s:23:\"ROLE_API_OPTIONTYPE_GET\";i:190;s:24:\"ROLE_API_OPTIONTYPE_LIST\";i:191;s:24:\"ROLE_API_OPTIONTYPE_POST\";i:192;s:23:\"ROLE_API_OPTIONTYPE_PUT\";i:193;s:26:\"ROLE_API_OPTIONTYPE_DELETE\";i:194;s:18:\"ROLE_API_OFFER_GET\";i:195;s:19:\"ROLE_API_OFFER_LIST\";i:196;s:19:\"ROLE_API_OFFER_POST\";i:197;s:18:\"ROLE_API_OFFER_PUT\";i:198;s:21:\"ROLE_API_OFFER_DELETE\";i:199;s:20:\"ROLE_API_USETYPE_GET\";i:200;s:21:\"ROLE_API_USETYPE_LIST\";i:201;s:21:\"ROLE_API_USETYPE_POST\";i:202;s:20:\"ROLE_API_USETYPE_PUT\";i:203;s:23:\"ROLE_API_USETYPE_DELETE\";i:204;s:20:\"ROLE_API_PRICING_GET\";i:205;s:21:\"ROLE_API_PRICING_LIST\";i:206;s:21:\"ROLE_API_PRICING_POST\";i:207;s:20:\"ROLE_API_PRICING_PUT\";i:208;s:23:\"ROLE_API_PRICING_DELETE\";i:209;s:29:\"ROLE_API_ATTRIBUTEPROFILE_GET\";i:210;s:30:\"ROLE_API_ATTRIBUTEPROFILE_LIST\";i:211;s:30:\"ROLE_API_ATTRIBUTEPROFILE_POST\";i:212;s:29:\"ROLE_API_ATTRIBUTEPROFILE_PUT\";i:213;s:32:\"ROLE_API_ATTRIBUTEPROFILE_DELETE\";i:214;s:34:\"ROLE_API_OFFERATTRIBUTEPROFILE_GET\";i:215;s:35:\"ROLE_API_OFFERATTRIBUTEPROFILE_LIST\";i:216;s:35:\"ROLE_API_OFFERATTRIBUTEPROFILE_POST\";i:217;s:34:\"ROLE_API_OFFERATTRIBUTEPROFILE_PUT\";i:218;s:37:\"ROLE_API_OFFERATTRIBUTEPROFILE_DELETE\";i:219;s:23:\"ROLE_API_SIMREQUEST_GET\";i:220;s:24:\"ROLE_API_SIMREQUEST_LIST\";i:221;s:23:\"ROLE_API_SIMREQUEST_PUT\";i:222;s:27:\"ROLE_API_SIMREQUESTITEM_GET\";i:223;s:28:\"ROLE_API_SIMREQUESTITEM_LIST\";i:224;s:28:\"ROLE_API_SIMREQUESTITEM_POST\";i:225;s:27:\"ROLE_API_SIMREQUESTITEM_PUT\";i:226;s:30:\"ROLE_API_SIMREQUESTITEM_DELETE\";i:227;s:28:\"ROLE_API_SIMAFFECTATION_POST\";i:228;s:24:\"ROLE_API_SIMPAIRING_POST\";i:229;s:24:\"ROLE_API_SIMDELIVERY_GET\";i:230;s:25:\"ROLE_API_SIMDELIVERY_LIST\";i:231;s:25:\"ROLE_API_SIMDELIVERY_POST\";i:232;s:24:\"ROLE_API_SIMDELIVERY_PUT\";i:233;s:27:\"ROLE_API_SIMDELIVERY_DELETE\";i:234;s:38:\"ROLE_API_BOXAFFECTATIONBULKDELETE_POST\";i:235;s:27:\"ROLE_API_SIMBULKDELETE_POST\";i:236;s:26:\"ROLE_API_SUBSCRIPTION_LIST\";i:237;s:27:\"ROLE_API_RELEASECONTENT_GET\";i:238;s:28:\"ROLE_API_RELEASECONTENT_LIST\";i:239;s:28:\"ROLE_API_RELEASECONTENT_POST\";i:240;s:27:\"ROLE_API_RELEASECONTENT_PUT\";i:241;s:30:\"ROLE_API_RELEASECONTENT_DELETE\";i:242;s:20:\"ROLE_API_RELEASE_GET\";i:243;s:21:\"ROLE_API_RELEASE_LIST\";i:244;s:21:\"ROLE_API_RELEASE_POST\";i:245;s:20:\"ROLE_API_RELEASE_PUT\";i:246;s:23:\"ROLE_API_RELEASE_DELETE\";i:247;s:33:\"ROLE_API_PAIRINGCONFIGURATION_GET\";i:248;s:34:\"ROLE_API_PAIRINGCONFIGURATION_LIST\";i:249;s:34:\"ROLE_API_PAIRINGCONFIGURATION_POST\";i:250;s:33:\"ROLE_API_PAIRINGCONFIGURATION_PUT\";i:251;s:36:\"ROLE_API_PAIRINGCONFIGURATION_DELETE\";i:252;s:25:\"ROLE_API_NOTIFICATION_GET\";i:253;s:26:\"ROLE_API_NOTIFICATION_LIST\";i:254;s:26:\"ROLE_API_NOTIFICATION_POST\";i:255;s:25:\"ROLE_API_NOTIFICATION_PUT\";i:256;s:28:\"ROLE_API_NOTIFICATION_DELETE\";i:257;s:35:\"ROLE_API_THREADCONFIGURATIONSMS_GET\";i:258;s:36:\"ROLE_API_THREADCONFIGURATIONSMS_LIST\";i:259;s:34:\"ROLE_API_SIMSTRANSFERCREATION_POST\";i:260;s:36:\"ROLE_API_DEVICESMSCONFIGURATIONS_GET\";i:261;s:27:\"ROLE_API_DEVICESENDSMS_POST\";i:262;s:35:\"ROLE_API_SIMCARDACTIONCREATION_POST\";i:263;s:24:\"ROLE_API_SIMTRANSFER_GET\";i:264;s:25:\"ROLE_API_SIMTRANSFER_LIST\";i:265;s:27:\"ROLE_API_SIMTRANSFER_DELETE\";i:266;s:33:\"ROLE_API_SMSCONFIGURATIONTYPE_GET\";i:267;s:34:\"ROLE_API_SMSCONFIGURATIONTYPE_LIST\";i:268;s:34:\"ROLE_API_SMSCONFIGURATIONTYPE_POST\";i:269;s:33:\"ROLE_API_SMSCONFIGURATIONTYPE_PUT\";i:270;s:36:\"ROLE_API_SMSCONFIGURATIONTYPE_DELETE\";i:271;s:32:\"ROLE_API_NOTIFICATION_DETAIL_GET\";i:272;s:33:\"ROLE_API_NOTIFICATION_DETAIL_LIST\";i:273;s:33:\"ROLE_API_NOTIFICATION_DETAIL_POST\";i:274;s:32:\"ROLE_API_NOTIFICATION_DETAIL_PUT\";i:275;s:35:\"ROLE_API_NOTIFICATION_DETAIL_DELETE\";i:276;s:22:\"ROLE_ALLOWED_TO_SWITCH\";i:277;s:28:\"ROLE_API_COUNT_BY_ENTITY_GET\";i:278;s:37:\"ROLE_API_THREAD_SMS_CONFIGURATION_GET\";i:279;s:38:\"ROLE_API_THREAD_SMS_CONFIGURATION_LIST\";i:280;s:21:\"ROLE_API_END_USER_GET\";i:281;s:22:\"ROLE_API_END_USER_LIST\";i:282;s:22:\"ROLE_API_END_USER_POST\";i:283;s:21:\"ROLE_API_END_USER_PUT\";i:284;s:24:\"ROLE_API_END_USER_DELETE\";i:285;s:30:\"ROLE_API_SMS_CONFIGURATION_GET\";i:286;s:31:\"ROLE_API_SMS_CONFIGURATION_LIST\";i:287;s:34:\"ROLE_API_SIMS_PUSH_API_CLIENT_POST\";i:288;s:41:\"ROLE_API_DEVICES_LOCATION_API_CLIENT_POST\";i:289;s:43:\"ROLE_API_DEVICES_DIAGNOSTIC_API_CLIENT_POST\";i:290;s:16:\"ROLE_API_APN_GET\";i:291;s:17:\"ROLE_API_APN_LIST\";i:292;s:17:\"ROLE_API_APN_POST\";i:293;s:16:\"ROLE_API_APN_PUT\";i:294;s:19:\"ROLE_API_APN_DELETE\";i:295;s:18:\"ROLE_API_ALERT_GET\";i:296;s:19:\"ROLE_API_ALERT_LIST\";i:297;s:19:\"ROLE_API_ALERT_POST\";i:298;s:18:\"ROLE_API_ALERT_PUT\";i:299;s:21:\"ROLE_API_ALERT_DELETE\";i:300;s:39:\"ROLE_ALLOWED_TO_CONNECT_ON_FRONT_OFFICE\";i:301;s:46:\"ROLE_API_CAN_UPDATE_COMPLETED_SIM_REQUEST_ITEM\";i:302;s:19:\"ROLE_API_ACCOUNTING\";i:303;s:39:\"ROLE_API_CAN_UPDATE_CONNECTIVITY_STATUS\";i:304;s:30:\"ROLE_API_REPORTING_FLEET_STATE\";i:305;s:33:\"ROLE_API_REPORTING_FLEET_MOVEMENT\";i:306;s:34:\"ROLE_API_REPORTING_CONSUMPTION_DAY\";i:307;s:36:\"ROLE_API_REPORTING_CONSUMPTION_MONTH\";i:308;s:35:\"ROLE_API_REPORTING_CONSUMPTION_EVOL\";i:309;s:30:\"ROLE_API_REPORTING_FLEET_SLEEP\";i:310;s:29:\"ROLE_API_REPORTING_BILL_MONTH\";i:311;s:28:\"ROLE_API_REPORTING_BILL_CUST\";i:312;s:32:\"ROLE_API_REPORTING_BILL_OPERATOR\";i:313;s:39:\"ROLE_API_REPORTING_BILL_OVERCONSUMPTION\";i:314;s:27:\"ROLE_API_REPORTING_BILL_DAY\";i:315;s:31:\"ROLE_API_REPORTING_BILL_PACKPCA\";i:316;s:17:\"ROLE_API_ENDPOINT\";i:317;s:24:\"ROLE_API_CUSTOM_ROLE_GET\";i:318;s:25:\"ROLE_API_CUSTOM_ROLE_LIST\";i:319;s:25:\"ROLE_API_CUSTOM_ROLE_POST\";i:320;s:24:\"ROLE_API_CUSTOM_ROLE_PUT\";i:321;s:27:\"ROLE_API_CUSTOM_ROLE_DELETE\";i:322;s:33:\"ROLE_API_CREDIT_NOTE_DOWNLOAD_GET\";i:323;s:28:\"ROLE_API_PRIVATE_NETWORK_GET\";i:324;s:29:\"ROLE_API_PRIVATE_NETWORK_LIST\";i:325;s:29:\"ROLE_API_PRIVATE_NETWORK_POST\";i:326;s:28:\"ROLE_API_PRIVATE_NETWORK_PUT\";i:327;s:31:\"ROLE_API_PRIVATE_NETWORK_DELETE\";i:328;s:26:\"ROLE_API_INVOICE_LINE_LIST\";i:329;s:23:\"ROLE_API_USER_GROUP_GET\";i:330;s:24:\"ROLE_API_USER_GROUP_LIST\";i:331;s:24:\"ROLE_API_USER_GROUP_POST\";i:332;s:23:\"ROLE_API_USER_GROUP_PUT\";i:333;s:26:\"ROLE_API_USER_GROUP_DELETE\";i:334;s:21:\"ROLE_API_SERVICE_LIST\";i:335;s:24:\"ROLE_API_CREDIT_NOTE_GET\";i:336;s:25:\"ROLE_API_CREDIT_NOTE_LIST\";i:337;s:15:\"ROLE_API_IP_GET\";i:338;s:16:\"ROLE_API_IP_LIST\";i:339;s:16:\"ROLE_API_IP_POST\";i:340;s:15:\"ROLE_API_IP_PUT\";i:341;s:34:\"ROLE_API_IP_MANUAL_ALLOCATION_POST\";i:342;s:40:\"ROLE_API_IP_FORCE_MANUAL_ALLOCATION_POST\";i:343;s:36:\"ROLE_API_IP_MANUAL_UNALLOCATION_POST\";i:344;s:23:\"ROLE_API_SIM_IMPORT_GET\";i:345;s:24:\"ROLE_API_SIM_IMPORT_LIST\";i:346;s:24:\"ROLE_API_SIM_IMPORT_POST\";i:347;s:17:\"ROLE_API_VLSM_GET\";i:348;s:18:\"ROLE_API_VLSM_LIST\";i:349;s:18:\"ROLE_API_VLSM_POST\";i:350;s:20:\"ROLE_API_VLSM_DELETE\";i:351;s:20:\"ROLE_API_VLSM_ASSIGN\";i:352;s:34:\"ROLE_API_SIM_PACK_SUBSCRIPTION_GET\";i:353;s:35:\"ROLE_API_SIM_PACK_SUBSCRIPTION_LIST\";i:354;s:26:\"ROLE_API_DEVICE_UPDATE_GET\";i:355;s:27:\"ROLE_API_DEVICE_UPDATE_LIST\";i:356;s:33:\"ROLE_API_REPORTING_FLEET_ANALYSIS\";i:357;s:27:\"ROLE_API_DEVICE_UPDATE_POST\";i:358;s:30:\"ROLE_API_OPERATOR_PROFILE_LIST\";i:359;s:30:\"ROLE_API_OPERATOR_PROFILE_POST\";i:360;s:29:\"ROLE_API_OPERATOR_PROFILE_GET\";i:361;s:29:\"ROLE_API_OPERATOR_PROFILE_PUT\";i:362;s:34:\"ROLE_API_SIM_PACK_SUBSCRIPTION_PUT\";i:363;s:20:\"ROLE_API_ZONING_LIST\";i:364;s:19:\"ROLE_API_ZONING_GET\";}', '2021-03-01 16:51:13', '2021-03-01 16:51:13'),
(2, 'Service IT', 'a:364:{i:0;s:21:\"ROLE_API_LANGUAGE_GET\";i:1;s:22:\"ROLE_API_LANGUAGE_LIST\";i:2;s:22:\"ROLE_API_LANGUAGE_POST\";i:3;s:21:\"ROLE_API_LANGUAGE_PUT\";i:4;s:24:\"ROLE_API_LANGUAGE_DELETE\";i:5;s:16:\"ROLE_API_TAG_GET\";i:6;s:17:\"ROLE_API_TAG_LIST\";i:7;s:17:\"ROLE_API_TAG_POST\";i:8;s:16:\"ROLE_API_TAG_PUT\";i:9;s:19:\"ROLE_API_TAG_DELETE\";i:10;s:18:\"ROLE_API_GROUP_GET\";i:11;s:19:\"ROLE_API_GROUP_LIST\";i:12;s:19:\"ROLE_API_GROUP_POST\";i:13;s:18:\"ROLE_API_GROUP_PUT\";i:14;s:21:\"ROLE_API_GROUP_DELETE\";i:15;s:20:\"ROLE_API_COUNTRY_GET\";i:16;s:21:\"ROLE_API_COUNTRY_LIST\";i:17;s:21:\"ROLE_API_COUNTRY_POST\";i:18;s:20:\"ROLE_API_COUNTRY_PUT\";i:19;s:23:\"ROLE_API_COUNTRY_DELETE\";i:20;s:26:\"ROLE_API_SIMCARDFORMAT_GET\";i:21;s:27:\"ROLE_API_SIMCARDFORMAT_LIST\";i:22;s:27:\"ROLE_API_SIMCARDFORMAT_POST\";i:23;s:26:\"ROLE_API_SIMCARDFORMAT_PUT\";i:24;s:29:\"ROLE_API_SIMCARDFORMAT_DELETE\";i:25;s:21:\"ROLE_API_OPERATOR_GET\";i:26;s:22:\"ROLE_API_OPERATOR_LIST\";i:27;s:22:\"ROLE_API_OPERATOR_POST\";i:28;s:21:\"ROLE_API_OPERATOR_PUT\";i:29;s:24:\"ROLE_API_OPERATOR_DELETE\";i:30;s:21:\"ROLE_API_CURRENCY_GET\";i:31;s:22:\"ROLE_API_CURRENCY_LIST\";i:32;s:22:\"ROLE_API_CURRENCY_POST\";i:33;s:21:\"ROLE_API_CURRENCY_PUT\";i:34;s:24:\"ROLE_API_CURRENCY_DELETE\";i:35;s:22:\"ROLE_API_AFFILIATE_GET\";i:36;s:23:\"ROLE_API_AFFILIATE_LIST\";i:37;s:23:\"ROLE_API_AFFILIATE_POST\";i:38;s:22:\"ROLE_API_AFFILIATE_PUT\";i:39;s:25:\"ROLE_API_AFFILIATE_DELETE\";i:40;s:17:\"ROLE_API_USER_GET\";i:41;s:18:\"ROLE_API_USER_LIST\";i:42;s:18:\"ROLE_API_USER_POST\";i:43;s:17:\"ROLE_API_USER_PUT\";i:44;s:20:\"ROLE_API_USER_DELETE\";i:45;s:19:\"ROLE_API_REGION_GET\";i:46;s:20:\"ROLE_API_REGION_LIST\";i:47;s:20:\"ROLE_API_REGION_POST\";i:48;s:19:\"ROLE_API_REGION_PUT\";i:49;s:22:\"ROLE_API_REGION_DELETE\";i:50;s:18:\"ROLE_API_ROLES_GET\";i:51;s:27:\"ROLE_API_BOXAFFECTATION_GET\";i:52;s:28:\"ROLE_API_BOXAFFECTATION_LIST\";i:53;s:28:\"ROLE_API_BOXAFFECTATION_POST\";i:54;s:27:\"ROLE_API_BOXAFFECTATION_PUT\";i:55;s:30:\"ROLE_API_BOXAFFECTATION_DELETE\";i:56;s:21:\"ROLE_API_BOXMODEL_GET\";i:57;s:22:\"ROLE_API_BOXMODEL_LIST\";i:58;s:22:\"ROLE_API_BOXMODEL_POST\";i:59;s:21:\"ROLE_API_BOXMODEL_PUT\";i:60;s:24:\"ROLE_API_BOXMODEL_DELETE\";i:61;s:19:\"ROLE_API_DEVICE_GET\";i:62;s:20:\"ROLE_API_DEVICE_LIST\";i:63;s:20:\"ROLE_API_DEVICE_POST\";i:64;s:19:\"ROLE_API_DEVICE_PUT\";i:65;s:22:\"ROLE_API_DEVICE_DELETE\";i:66;s:16:\"ROLE_API_SIM_GET\";i:67;s:17:\"ROLE_API_SIM_LIST\";i:68;s:16:\"ROLE_API_SIM_PUT\";i:69;s:19:\"ROLE_API_SIM_DELETE\";i:70;s:23:\"ROLE_API_SIMVERSION_GET\";i:71;s:24:\"ROLE_API_SIMVERSION_LIST\";i:72;s:24:\"ROLE_API_SIMVERSION_POST\";i:73;s:23:\"ROLE_API_SIMVERSION_PUT\";i:74;s:26:\"ROLE_API_SIMVERSION_DELETE\";i:75;s:27:\"ROLE_API_PAYEMENTMETHOD_GET\";i:76;s:28:\"ROLE_API_PAYEMENTMETHOD_LIST\";i:77;s:28:\"ROLE_API_PAYEMENTMETHOD_POST\";i:78;s:27:\"ROLE_API_PAYEMENTMETHOD_PUT\";i:79;s:30:\"ROLE_API_PAYEMENTMETHOD_DELETE\";i:80;s:21:\"ROLE_API_CUSTOMER_GET\";i:81;s:22:\"ROLE_API_CUSTOMER_LIST\";i:82;s:22:\"ROLE_API_CUSTOMER_POST\";i:83;s:21:\"ROLE_API_CUSTOMER_PUT\";i:84;s:24:\"ROLE_API_CUSTOMER_DELETE\";i:85;s:19:\"ROLE_API_AGENCY_GET\";i:86;s:20:\"ROLE_API_AGENCY_LIST\";i:87;s:20:\"ROLE_API_AGENCY_POST\";i:88;s:19:\"ROLE_API_AGENCY_PUT\";i:89;s:22:\"ROLE_API_AGENCY_DELETE\";i:90;s:20:\"ROLE_API_ADDRESS_GET\";i:91;s:21:\"ROLE_API_ADDRESS_LIST\";i:92;s:21:\"ROLE_API_ADDRESS_POST\";i:93;s:20:\"ROLE_API_ADDRESS_PUT\";i:94;s:23:\"ROLE_API_ADDRESS_DELETE\";i:95;s:26:\"ROLE_API_MUTUALIZATION_GET\";i:96;s:27:\"ROLE_API_MUTUALIZATION_LIST\";i:97;s:27:\"ROLE_API_MUTUALIZATION_POST\";i:98;s:26:\"ROLE_API_MUTUALIZATION_PUT\";i:99;s:29:\"ROLE_API_MUTUALIZATION_DELETE\";i:100;s:22:\"ROLE_API_ORDERLINE_GET\";i:101;s:23:\"ROLE_API_ORDERLINE_LIST\";i:102;s:23:\"ROLE_API_ORDERLINE_POST\";i:103;s:22:\"ROLE_API_ORDERLINE_PUT\";i:104;s:25:\"ROLE_API_ORDERLINE_DELETE\";i:105;s:21:\"ROLE_API_SHIPMENT_GET\";i:106;s:22:\"ROLE_API_SHIPMENT_LIST\";i:107;s:22:\"ROLE_API_SHIPMENT_POST\";i:108;s:21:\"ROLE_API_SHIPMENT_PUT\";i:109;s:24:\"ROLE_API_SHIPMENT_DELETE\";i:110;s:18:\"ROLE_API_ORDER_GET\";i:111;s:19:\"ROLE_API_ORDER_LIST\";i:112;s:19:\"ROLE_API_ORDER_POST\";i:113;s:18:\"ROLE_API_ORDER_PUT\";i:114;s:21:\"ROLE_API_ORDER_DELETE\";i:115;s:34:\"ROLE_API_DEFAULTCARDORDERPRICE_GET\";i:116;s:35:\"ROLE_API_DEFAULTCARDORDERPRICE_LIST\";i:117;s:35:\"ROLE_API_DEFAULTCARDORDERPRICE_POST\";i:118;s:34:\"ROLE_API_DEFAULTCARDORDERPRICE_PUT\";i:119;s:37:\"ROLE_API_DEFAULTCARDORDERPRICE_DELETE\";i:120;s:36:\"ROLE_API_SIMORDERLINEAFFECTATION_GET\";i:121;s:37:\"ROLE_API_SIMORDERLINEAFFECTATION_LIST\";i:122;s:27:\"ROLE_API_CARDORDERPRICE_GET\";i:123;s:28:\"ROLE_API_CARDORDERPRICE_LIST\";i:124;s:28:\"ROLE_API_CARDORDERPRICE_POST\";i:125;s:27:\"ROLE_API_CARDORDERPRICE_PUT\";i:126;s:30:\"ROLE_API_CARDORDERPRICE_DELETE\";i:127;s:20:\"ROLE_API_CARRIER_GET\";i:128;s:21:\"ROLE_API_CARRIER_LIST\";i:129;s:21:\"ROLE_API_CARRIER_POST\";i:130;s:20:\"ROLE_API_CARRIER_PUT\";i:131;s:23:\"ROLE_API_CARRIER_DELETE\";i:132;s:23:\"ROLE_API_SIMRETURN_POST\";i:133;s:47:\"ROLE_API_SIMORDERLINEAFFECTATIONBULKDELETE_POST\";i:134;s:20:\"ROLE_API_INVOICE_GET\";i:135;s:21:\"ROLE_API_INVOICE_LIST\";i:136;s:24:\"ROLE_API_BILLINGPOST_GET\";i:137;s:25:\"ROLE_API_BILLINGPOST_LIST\";i:138;s:25:\"ROLE_API_BILLINGPOST_POST\";i:139;s:24:\"ROLE_API_BILLINGPOST_PUT\";i:140;s:27:\"ROLE_API_BILLINGPOST_DELETE\";i:141;s:16:\"ROLE_API_VAT_GET\";i:142;s:17:\"ROLE_API_VAT_LIST\";i:143;s:17:\"ROLE_API_VAT_POST\";i:144;s:16:\"ROLE_API_VAT_PUT\";i:145;s:19:\"ROLE_API_VAT_DELETE\";i:146;s:23:\"ROLE_API_REGULATION_GET\";i:147;s:24:\"ROLE_API_REGULATION_LIST\";i:148;s:24:\"ROLE_API_REGULATION_POST\";i:149;s:23:\"ROLE_API_REGULATION_PUT\";i:150;s:26:\"ROLE_API_REGULATION_DELETE\";i:151;s:29:\"ROLE_API_INVOICESDOWNLOAD_GET\";i:152;s:17:\"ROLE_API_NOTE_GET\";i:153;s:18:\"ROLE_API_NOTE_LIST\";i:154;s:18:\"ROLE_API_NOTE_POST\";i:155;s:17:\"ROLE_API_NOTE_PUT\";i:156;s:20:\"ROLE_API_NOTE_DELETE\";i:157;s:17:\"ROLE_API_LOGS_GET\";i:158;s:18:\"ROLE_API_LOGS_POST\";i:159;s:17:\"ROLE_API_LOGS_PUT\";i:160;s:20:\"ROLE_API_LOGS_DELETE\";i:161;s:29:\"ROLE_API_OPERATORSIMSTATS_GET\";i:162;s:28:\"ROLE_API_ORDERLINESSTATS_GET\";i:163;s:28:\"ROLE_API_CHANGEPASSWORD_POST\";i:164;s:22:\"ROLE_API_SMSZONING_GET\";i:165;s:23:\"ROLE_API_SMSZONING_LIST\";i:166;s:23:\"ROLE_API_SMSZONING_POST\";i:167;s:22:\"ROLE_API_SMSZONING_PUT\";i:168;s:25:\"ROLE_API_SMSZONING_DELETE\";i:169;s:18:\"ROLE_API_USAGE_GET\";i:170;s:19:\"ROLE_API_USAGE_LIST\";i:171;s:19:\"ROLE_API_USAGE_POST\";i:172;s:18:\"ROLE_API_USAGE_PUT\";i:173;s:21:\"ROLE_API_USAGE_DELETE\";i:174;s:22:\"ROLE_API_OFFERTYPE_GET\";i:175;s:23:\"ROLE_API_OFFERTYPE_LIST\";i:176;s:23:\"ROLE_API_OFFERTYPE_POST\";i:177;s:22:\"ROLE_API_OFFERTYPE_PUT\";i:178;s:25:\"ROLE_API_OFFERTYPE_DELETE\";i:179;s:29:\"ROLE_API_PROVIDERBUSINESS_GET\";i:180;s:30:\"ROLE_API_PROVIDERBUSINESS_LIST\";i:181;s:30:\"ROLE_API_PROVIDERBUSINESS_POST\";i:182;s:29:\"ROLE_API_PROVIDERBUSINESS_PUT\";i:183;s:32:\"ROLE_API_PROVIDERBUSINESS_DELETE\";i:184;s:19:\"ROLE_API_OPTION_GET\";i:185;s:20:\"ROLE_API_OPTION_LIST\";i:186;s:20:\"ROLE_API_OPTION_POST\";i:187;s:19:\"ROLE_API_OPTION_PUT\";i:188;s:22:\"ROLE_API_OPTION_DELETE\";i:189;s:23:\"ROLE_API_OPTIONTYPE_GET\";i:190;s:24:\"ROLE_API_OPTIONTYPE_LIST\";i:191;s:24:\"ROLE_API_OPTIONTYPE_POST\";i:192;s:23:\"ROLE_API_OPTIONTYPE_PUT\";i:193;s:26:\"ROLE_API_OPTIONTYPE_DELETE\";i:194;s:18:\"ROLE_API_OFFER_GET\";i:195;s:19:\"ROLE_API_OFFER_LIST\";i:196;s:19:\"ROLE_API_OFFER_POST\";i:197;s:18:\"ROLE_API_OFFER_PUT\";i:198;s:21:\"ROLE_API_OFFER_DELETE\";i:199;s:20:\"ROLE_API_USETYPE_GET\";i:200;s:21:\"ROLE_API_USETYPE_LIST\";i:201;s:21:\"ROLE_API_USETYPE_POST\";i:202;s:20:\"ROLE_API_USETYPE_PUT\";i:203;s:23:\"ROLE_API_USETYPE_DELETE\";i:204;s:20:\"ROLE_API_PRICING_GET\";i:205;s:21:\"ROLE_API_PRICING_LIST\";i:206;s:21:\"ROLE_API_PRICING_POST\";i:207;s:20:\"ROLE_API_PRICING_PUT\";i:208;s:23:\"ROLE_API_PRICING_DELETE\";i:209;s:29:\"ROLE_API_ATTRIBUTEPROFILE_GET\";i:210;s:30:\"ROLE_API_ATTRIBUTEPROFILE_LIST\";i:211;s:30:\"ROLE_API_ATTRIBUTEPROFILE_POST\";i:212;s:29:\"ROLE_API_ATTRIBUTEPROFILE_PUT\";i:213;s:32:\"ROLE_API_ATTRIBUTEPROFILE_DELETE\";i:214;s:34:\"ROLE_API_OFFERATTRIBUTEPROFILE_GET\";i:215;s:35:\"ROLE_API_OFFERATTRIBUTEPROFILE_LIST\";i:216;s:35:\"ROLE_API_OFFERATTRIBUTEPROFILE_POST\";i:217;s:34:\"ROLE_API_OFFERATTRIBUTEPROFILE_PUT\";i:218;s:37:\"ROLE_API_OFFERATTRIBUTEPROFILE_DELETE\";i:219;s:23:\"ROLE_API_SIMREQUEST_GET\";i:220;s:24:\"ROLE_API_SIMREQUEST_LIST\";i:221;s:23:\"ROLE_API_SIMREQUEST_PUT\";i:222;s:27:\"ROLE_API_SIMREQUESTITEM_GET\";i:223;s:28:\"ROLE_API_SIMREQUESTITEM_LIST\";i:224;s:28:\"ROLE_API_SIMREQUESTITEM_POST\";i:225;s:27:\"ROLE_API_SIMREQUESTITEM_PUT\";i:226;s:30:\"ROLE_API_SIMREQUESTITEM_DELETE\";i:227;s:28:\"ROLE_API_SIMAFFECTATION_POST\";i:228;s:24:\"ROLE_API_SIMPAIRING_POST\";i:229;s:24:\"ROLE_API_SIMDELIVERY_GET\";i:230;s:25:\"ROLE_API_SIMDELIVERY_LIST\";i:231;s:25:\"ROLE_API_SIMDELIVERY_POST\";i:232;s:24:\"ROLE_API_SIMDELIVERY_PUT\";i:233;s:27:\"ROLE_API_SIMDELIVERY_DELETE\";i:234;s:38:\"ROLE_API_BOXAFFECTATIONBULKDELETE_POST\";i:235;s:27:\"ROLE_API_SIMBULKDELETE_POST\";i:236;s:26:\"ROLE_API_SUBSCRIPTION_LIST\";i:237;s:27:\"ROLE_API_RELEASECONTENT_GET\";i:238;s:28:\"ROLE_API_RELEASECONTENT_LIST\";i:239;s:28:\"ROLE_API_RELEASECONTENT_POST\";i:240;s:27:\"ROLE_API_RELEASECONTENT_PUT\";i:241;s:30:\"ROLE_API_RELEASECONTENT_DELETE\";i:242;s:20:\"ROLE_API_RELEASE_GET\";i:243;s:21:\"ROLE_API_RELEASE_LIST\";i:244;s:21:\"ROLE_API_RELEASE_POST\";i:245;s:20:\"ROLE_API_RELEASE_PUT\";i:246;s:23:\"ROLE_API_RELEASE_DELETE\";i:247;s:33:\"ROLE_API_PAIRINGCONFIGURATION_GET\";i:248;s:34:\"ROLE_API_PAIRINGCONFIGURATION_LIST\";i:249;s:34:\"ROLE_API_PAIRINGCONFIGURATION_POST\";i:250;s:33:\"ROLE_API_PAIRINGCONFIGURATION_PUT\";i:251;s:36:\"ROLE_API_PAIRINGCONFIGURATION_DELETE\";i:252;s:25:\"ROLE_API_NOTIFICATION_GET\";i:253;s:26:\"ROLE_API_NOTIFICATION_LIST\";i:254;s:26:\"ROLE_API_NOTIFICATION_POST\";i:255;s:25:\"ROLE_API_NOTIFICATION_PUT\";i:256;s:28:\"ROLE_API_NOTIFICATION_DELETE\";i:257;s:35:\"ROLE_API_THREADCONFIGURATIONSMS_GET\";i:258;s:36:\"ROLE_API_THREADCONFIGURATIONSMS_LIST\";i:259;s:34:\"ROLE_API_SIMSTRANSFERCREATION_POST\";i:260;s:36:\"ROLE_API_DEVICESMSCONFIGURATIONS_GET\";i:261;s:27:\"ROLE_API_DEVICESENDSMS_POST\";i:262;s:35:\"ROLE_API_SIMCARDACTIONCREATION_POST\";i:263;s:24:\"ROLE_API_SIMTRANSFER_GET\";i:264;s:25:\"ROLE_API_SIMTRANSFER_LIST\";i:265;s:27:\"ROLE_API_SIMTRANSFER_DELETE\";i:266;s:33:\"ROLE_API_SMSCONFIGURATIONTYPE_GET\";i:267;s:34:\"ROLE_API_SMSCONFIGURATIONTYPE_LIST\";i:268;s:34:\"ROLE_API_SMSCONFIGURATIONTYPE_POST\";i:269;s:33:\"ROLE_API_SMSCONFIGURATIONTYPE_PUT\";i:270;s:36:\"ROLE_API_SMSCONFIGURATIONTYPE_DELETE\";i:271;s:32:\"ROLE_API_NOTIFICATION_DETAIL_GET\";i:272;s:33:\"ROLE_API_NOTIFICATION_DETAIL_LIST\";i:273;s:33:\"ROLE_API_NOTIFICATION_DETAIL_POST\";i:274;s:32:\"ROLE_API_NOTIFICATION_DETAIL_PUT\";i:275;s:35:\"ROLE_API_NOTIFICATION_DETAIL_DELETE\";i:276;s:22:\"ROLE_ALLOWED_TO_SWITCH\";i:277;s:28:\"ROLE_API_COUNT_BY_ENTITY_GET\";i:278;s:37:\"ROLE_API_THREAD_SMS_CONFIGURATION_GET\";i:279;s:38:\"ROLE_API_THREAD_SMS_CONFIGURATION_LIST\";i:280;s:21:\"ROLE_API_END_USER_GET\";i:281;s:22:\"ROLE_API_END_USER_LIST\";i:282;s:22:\"ROLE_API_END_USER_POST\";i:283;s:21:\"ROLE_API_END_USER_PUT\";i:284;s:24:\"ROLE_API_END_USER_DELETE\";i:285;s:30:\"ROLE_API_SMS_CONFIGURATION_GET\";i:286;s:31:\"ROLE_API_SMS_CONFIGURATION_LIST\";i:287;s:34:\"ROLE_API_SIMS_PUSH_API_CLIENT_POST\";i:288;s:41:\"ROLE_API_DEVICES_LOCATION_API_CLIENT_POST\";i:289;s:43:\"ROLE_API_DEVICES_DIAGNOSTIC_API_CLIENT_POST\";i:290;s:16:\"ROLE_API_APN_GET\";i:291;s:17:\"ROLE_API_APN_LIST\";i:292;s:17:\"ROLE_API_APN_POST\";i:293;s:16:\"ROLE_API_APN_PUT\";i:294;s:19:\"ROLE_API_APN_DELETE\";i:295;s:18:\"ROLE_API_ALERT_GET\";i:296;s:19:\"ROLE_API_ALERT_LIST\";i:297;s:19:\"ROLE_API_ALERT_POST\";i:298;s:18:\"ROLE_API_ALERT_PUT\";i:299;s:21:\"ROLE_API_ALERT_DELETE\";i:300;s:39:\"ROLE_ALLOWED_TO_CONNECT_ON_FRONT_OFFICE\";i:301;s:46:\"ROLE_API_CAN_UPDATE_COMPLETED_SIM_REQUEST_ITEM\";i:302;s:19:\"ROLE_API_ACCOUNTING\";i:303;s:30:\"ROLE_API_REPORTING_FLEET_STATE\";i:304;s:33:\"ROLE_API_REPORTING_FLEET_MOVEMENT\";i:305;s:34:\"ROLE_API_REPORTING_CONSUMPTION_DAY\";i:306;s:36:\"ROLE_API_REPORTING_CONSUMPTION_MONTH\";i:307;s:35:\"ROLE_API_REPORTING_CONSUMPTION_EVOL\";i:308;s:30:\"ROLE_API_REPORTING_FLEET_SLEEP\";i:309;s:29:\"ROLE_API_REPORTING_BILL_MONTH\";i:310;s:28:\"ROLE_API_REPORTING_BILL_CUST\";i:311;s:32:\"ROLE_API_REPORTING_BILL_OPERATOR\";i:312;s:39:\"ROLE_API_REPORTING_BILL_OVERCONSUMPTION\";i:313;s:27:\"ROLE_API_REPORTING_BILL_DAY\";i:314;s:31:\"ROLE_API_REPORTING_BILL_PACKPCA\";i:315;s:17:\"ROLE_API_ENDPOINT\";i:316;s:24:\"ROLE_API_CUSTOM_ROLE_GET\";i:317;s:25:\"ROLE_API_CUSTOM_ROLE_LIST\";i:318;s:25:\"ROLE_API_CUSTOM_ROLE_POST\";i:319;s:24:\"ROLE_API_CUSTOM_ROLE_PUT\";i:320;s:27:\"ROLE_API_CUSTOM_ROLE_DELETE\";i:321;s:33:\"ROLE_API_CREDIT_NOTE_DOWNLOAD_GET\";i:322;s:28:\"ROLE_API_PRIVATE_NETWORK_GET\";i:323;s:29:\"ROLE_API_PRIVATE_NETWORK_LIST\";i:324;s:29:\"ROLE_API_PRIVATE_NETWORK_POST\";i:325;s:28:\"ROLE_API_PRIVATE_NETWORK_PUT\";i:326;s:31:\"ROLE_API_PRIVATE_NETWORK_DELETE\";i:327;s:26:\"ROLE_API_INVOICE_LINE_LIST\";i:328;s:23:\"ROLE_API_USER_GROUP_GET\";i:329;s:24:\"ROLE_API_USER_GROUP_LIST\";i:330;s:24:\"ROLE_API_USER_GROUP_POST\";i:331;s:23:\"ROLE_API_USER_GROUP_PUT\";i:332;s:26:\"ROLE_API_USER_GROUP_DELETE\";i:333;s:21:\"ROLE_API_SERVICE_LIST\";i:334;s:24:\"ROLE_API_CREDIT_NOTE_GET\";i:335;s:25:\"ROLE_API_CREDIT_NOTE_LIST\";i:336;s:15:\"ROLE_API_IP_GET\";i:337;s:16:\"ROLE_API_IP_LIST\";i:338;s:16:\"ROLE_API_IP_POST\";i:339;s:15:\"ROLE_API_IP_PUT\";i:340;s:34:\"ROLE_API_IP_MANUAL_ALLOCATION_POST\";i:341;s:40:\"ROLE_API_IP_FORCE_MANUAL_ALLOCATION_POST\";i:342;s:36:\"ROLE_API_IP_MANUAL_UNALLOCATION_POST\";i:343;s:23:\"ROLE_API_SIM_IMPORT_GET\";i:344;s:24:\"ROLE_API_SIM_IMPORT_LIST\";i:345;s:24:\"ROLE_API_SIM_IMPORT_POST\";i:346;s:17:\"ROLE_API_VLSM_GET\";i:347;s:18:\"ROLE_API_VLSM_LIST\";i:348;s:18:\"ROLE_API_VLSM_POST\";i:349;s:20:\"ROLE_API_VLSM_DELETE\";i:350;s:20:\"ROLE_API_VLSM_ASSIGN\";i:351;s:34:\"ROLE_API_SIM_PACK_SUBSCRIPTION_GET\";i:352;s:35:\"ROLE_API_SIM_PACK_SUBSCRIPTION_LIST\";i:353;s:26:\"ROLE_API_DEVICE_UPDATE_GET\";i:354;s:27:\"ROLE_API_DEVICE_UPDATE_LIST\";i:355;s:33:\"ROLE_API_REPORTING_FLEET_ANALYSIS\";i:356;s:27:\"ROLE_API_DEVICE_UPDATE_POST\";i:357;s:30:\"ROLE_API_OPERATOR_PROFILE_LIST\";i:358;s:30:\"ROLE_API_OPERATOR_PROFILE_POST\";i:359;s:29:\"ROLE_API_OPERATOR_PROFILE_GET\";i:360;s:29:\"ROLE_API_OPERATOR_PROFILE_PUT\";i:361;s:34:\"ROLE_API_SIM_PACK_SUBSCRIPTION_PUT\";i:362;s:20:\"ROLE_API_ZONING_LIST\";i:363;s:19:\"ROLE_API_ZONING_GET\";}', '2021-03-01 16:51:13', '2021-03-01 16:51:13');

-- --------------------------------------------------------

--
-- Structure de la table `log`
--

CREATE TABLE `log` (
  `id` int NOT NULL,
  `action` varchar(8) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `logged_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `object_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `object_class` varchar(191) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `version` int NOT NULL,
  `data` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci COMMENT '(DC2Type:array)',
  `username` varchar(191) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL COMMENT '(DC2Type:datetime)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `log_connection`
--

CREATE TABLE `log_connection` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `success` tinyint(1) NOT NULL,
  `error_message` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `log_connection`
--

INSERT INTO `log_connection` (`id`, `user_id`, `created_at`, `success`, `error_message`) VALUES
(1, 23, '2021-10-06 13:51:53', 1, NULL),
(2, 2, '2021-10-06 14:01:58', 1, NULL),
(3, 2, '2021-10-06 14:02:07', 1, NULL),
(4, 2, '2021-10-06 14:04:31', 1, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `note`
--

CREATE TABLE `note` (
  `id` int NOT NULL,
  `project_id` int DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `user_id` int NOT NULL,
  `from_reminder_creation` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `project`
--

CREATE TABLE `project` (
  `id` int NOT NULL,
  `final_customer_id` int DEFAULT NULL,
  `default_address_id` int DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_customer_address` tinyint(1) DEFAULT NULL,
  `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `user_id` int DEFAULT NULL,
  `device_id` int DEFAULT NULL,
  `brand_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `device_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `project_document`
--

CREATE TABLE `project_document` (
  `id` int NOT NULL,
  `filepath` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `project_id` int DEFAULT NULL,
  `is_completed` tinyint(1) DEFAULT NULL,
  `nb_generated` int DEFAULT NULL,
  `last_generated_at` datetime DEFAULT NULL COMMENT '(DC2Type:datetime)',
  `project_document_type_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `project_document_type`
--

CREATE TABLE `project_document_type` (
  `id` int NOT NULL,
  `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `slug` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `project_files`
--

CREATE TABLE `project_files` (
  `id` int NOT NULL,
  `project_id` int DEFAULT NULL,
  `filepath` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `project_history`
--

CREATE TABLE `project_history` (
  `id` int NOT NULL,
  `project_id` int NOT NULL,
  `user_id` int NOT NULL,
  `operation_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `operation_description` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `project_picture`
--

CREATE TABLE `project_picture` (
  `id` int NOT NULL,
  `project_id` int DEFAULT NULL,
  `filepath` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `qualification`
--

CREATE TABLE `qualification` (
  `id` int NOT NULL,
  `company_id` int NOT NULL,
  `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `deleted_at` datetime DEFAULT NULL COMMENT '(DC2Type:datetime)',
  `quali_bois_air` tinyint(1) DEFAULT NULL,
  `quali_bois_eau` tinyint(1) DEFAULT NULL,
  `other` tinyint(1) DEFAULT NULL,
  `qualification_number_air` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `qualification_number_eau` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `qualification_number_other` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `first_date_qualification_air` datetime DEFAULT NULL COMMENT '(DC2Type:datetime)',
  `first_date_qualification_eau` datetime DEFAULT NULL COMMENT '(DC2Type:datetime)',
  `first_date_qualification_other` datetime DEFAULT NULL COMMENT '(DC2Type:datetime)',
  `quali_bois_rge_poele` tinyint(1) DEFAULT NULL,
  `quali_bois_rge_chaudiere` tinyint(1) DEFAULT NULL,
  `qualification_number_rge_poele` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `qualification_number_rge_chaudiere` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `first_date_qualification_rge_poele` datetime DEFAULT NULL COMMENT '(DC2Type:datetime)',
  `first_date_qualification_rge_chaudiere` datetime DEFAULT NULL COMMENT '(DC2Type:datetime)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `qualification`
--

INSERT INTO `qualification` (`id`, `company_id`, `created_at`, `updated_at`, `deleted_at`, `quali_bois_air`, `quali_bois_eau`, `other`, `qualification_number_air`, `qualification_number_eau`, `qualification_number_other`, `first_date_qualification_air`, `first_date_qualification_eau`, `first_date_qualification_other`, `quali_bois_rge_poele`, `quali_bois_rge_chaudiere`, `qualification_number_rge_poele`, `qualification_number_rge_chaudiere`, `first_date_qualification_rge_poele`, `first_date_qualification_rge_chaudiere`) VALUES
(1, 1, '2021-10-06 13:25:00', '2021-10-06 13:25:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `reminder`
--

CREATE TABLE `reminder` (
  `id` int NOT NULL,
  `project_id` int DEFAULT NULL,
  `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `reminded_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `is_triggered` tinyint(1) DEFAULT NULL,
  `note_id` int DEFAULT NULL,
  `user_id` int NOT NULL,
  `reminder_object_mail_id` int DEFAULT NULL,
  `is_close_on_dashboard` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `reminder_object_mail`
--

CREATE TABLE `reminder_object_mail` (
  `id` int NOT NULL,
  `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `service`
--

CREATE TABLE `service` (
  `id` int NOT NULL,
  `project_id` int DEFAULT NULL,
  `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `user_id` int DEFAULT NULL,
  `service_list_id` int DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `service_list`
--

CREATE TABLE `service_list` (
  `id` int NOT NULL,
  `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `slug` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `user_group`
--

CREATE TABLE `user_group` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `group_id` int NOT NULL,
  `deleted_at` datetime DEFAULT NULL COMMENT '(DC2Type:datetime)',
  `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime)',
  `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `address`
--
ALTER TABLE `address`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `agency`
--
ALTER TABLE `agency`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_70C0C6E6F5B7AF75` (`address_id`),
  ADD KEY `IDX_70C0C6E6979B1AD6` (`company_id`);

--
-- Index pour la table `application_user`
--
ALTER TABLE `application_user`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_7A7FBEC1A0D96FBF` (`email_canonical`),
  ADD UNIQUE KEY `UNIQ_7A7FBEC1C05FB297` (`confirmation_token`),
  ADD KEY `IDX_7A7FBEC1CDEADB2A` (`agency_id`),
  ADD KEY `IDX_7A7FBEC1727ACA70` (`parent_id`);

--
-- Index pour la table `company`
--
ALTER TABLE `company`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_4FBF094FF5B7AF75` (`address_id`),
  ADD KEY `IDX_4FBF094F1D4F29AC` (`company_state_id`);

--
-- Index pour la table `company_state`
--
ALTER TABLE `company_state`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `devices`
--
ALTER TABLE `devices`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_11074E9A78E40D21` (`device_granule_informations_id`),
  ADD UNIQUE KEY `UNIQ_11074E9AEE411DCC` (`device_buche_informations_id`),
  ADD KEY `IDX_11074E9A4FFA550E` (`device_type_id`);

--
-- Index pour la table `device_buche`
--
ALTER TABLE `device_buche`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `device_granule`
--
ALTER TABLE `device_granule`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `device_type`
--
ALTER TABLE `device_type`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `dgaccessory`
--
ALTER TABLE `dgaccessory`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_FF097AED1AB50D8E` (`duct_id`);

--
-- Index pour la table `dgdesignation`
--
ALTER TABLE `dgdesignation`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_7F34A32C1AB50D8E` (`duct_id`);

--
-- Index pour la table `dginterior_details`
--
ALTER TABLE `dginterior_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_D7A46641AB50D8E` (`duct_id`);

--
-- Index pour la table `duct`
--
ALTER TABLE `duct`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `file`
--
ALTER TABLE `file`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_8C9F3610979B1AD6` (`company_id`);

--
-- Index pour la table `final_customer`
--
ALTER TABLE `final_customer`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_FED0A039F5B7AF75` (`address_id`),
  ADD KEY `IDX_FED0A039CDEADB2A` (`agency_id`);

--
-- Index pour la table `fos_group`
--
ALTER TABLE `fos_group`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_4B019DDB5E237E06` (`name`);

--
-- Index pour la table `log`
--
ALTER TABLE `log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `object_class_idx` (`object_class`),
  ADD KEY `object_id_idx` (`object_id`);

--
-- Index pour la table `log_connection`
--
ALTER TABLE `log_connection`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_23E1DFDDA76ED395` (`user_id`);

--
-- Index pour la table `note`
--
ALTER TABLE `note`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_CFBDFA14166D1F9C` (`project_id`),
  ADD KEY `IDX_CFBDFA14A76ED395` (`user_id`);

--
-- Index pour la table `project`
--
ALTER TABLE `project`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_2FB3D0EEBD94FB16` (`default_address_id`),
  ADD KEY `IDX_2FB3D0EE652F75EC` (`final_customer_id`),
  ADD KEY `IDX_2FB3D0EEA76ED395` (`user_id`),
  ADD KEY `IDX_2FB3D0EE94A4C7D4` (`device_id`);

--
-- Index pour la table `project_document`
--
ALTER TABLE `project_document`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_E52701AD166D1F9C` (`project_id`),
  ADD KEY `IDX_E52701ADDCA6E926` (`project_document_type_id`);

--
-- Index pour la table `project_document_type`
--
ALTER TABLE `project_document_type`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `project_files`
--
ALTER TABLE `project_files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_156049C7166D1F9C` (`project_id`);

--
-- Index pour la table `project_history`
--
ALTER TABLE `project_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_B1A47C2E166D1F9C` (`project_id`),
  ADD KEY `IDX_B1A47C2EA76ED395` (`user_id`);

--
-- Index pour la table `project_picture`
--
ALTER TABLE `project_picture`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_80C543EC166D1F9C` (`project_id`);

--
-- Index pour la table `qualification`
--
ALTER TABLE `qualification`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_B712F0CE979B1AD6` (`company_id`);

--
-- Index pour la table `reminder`
--
ALTER TABLE `reminder`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_40374F4026ED0855` (`note_id`),
  ADD KEY `IDX_40374F40166D1F9C` (`project_id`),
  ADD KEY `IDX_40374F40A76ED395` (`user_id`),
  ADD KEY `IDX_40374F4083FFD6D3` (`reminder_object_mail_id`);

--
-- Index pour la table `reminder_object_mail`
--
ALTER TABLE `reminder_object_mail`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `service`
--
ALTER TABLE `service`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_E19D9AD2166D1F9C` (`project_id`),
  ADD KEY `IDX_E19D9AD2A76ED395` (`user_id`),
  ADD KEY `IDX_E19D9AD2F22A4417` (`service_list_id`);

--
-- Index pour la table `service_list`
--
ALTER TABLE `service_list`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `user_group`
--
ALTER TABLE `user_group`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_8F02BF9DA76ED395` (`user_id`),
  ADD KEY `IDX_8F02BF9DFE54D947` (`group_id`);

--
-- AUTO_INCREMENT pour les tables déchargées
--

--
-- AUTO_INCREMENT pour la table `address`
--
ALTER TABLE `address`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `agency`
--
ALTER TABLE `agency`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `application_user`
--
ALTER TABLE `application_user`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT pour la table `company`
--
ALTER TABLE `company`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `company_state`
--
ALTER TABLE `company_state`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT pour la table `devices`
--
ALTER TABLE `devices`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2402;

--
-- AUTO_INCREMENT pour la table `device_buche`
--
ALTER TABLE `device_buche`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2390;

--
-- AUTO_INCREMENT pour la table `device_granule`
--
ALTER TABLE `device_granule`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2390;

--
-- AUTO_INCREMENT pour la table `device_type`
--
ALTER TABLE `device_type`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT pour la table `dgaccessory`
--
ALTER TABLE `dgaccessory`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1035;

--
-- AUTO_INCREMENT pour la table `dgdesignation`
--
ALTER TABLE `dgdesignation`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=468;

--
-- AUTO_INCREMENT pour la table `dginterior_details`
--
ALTER TABLE `dginterior_details`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1529;

--
-- AUTO_INCREMENT pour la table `duct`
--
ALTER TABLE `duct`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=454;

--
-- AUTO_INCREMENT pour la table `file`
--
ALTER TABLE `file`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `final_customer`
--
ALTER TABLE `final_customer`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `fos_group`
--
ALTER TABLE `fos_group`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=214;

--
-- AUTO_INCREMENT pour la table `log`
--
ALTER TABLE `log`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `log_connection`
--
ALTER TABLE `log_connection`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT pour la table `note`
--
ALTER TABLE `note`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `project`
--
ALTER TABLE `project`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `project_document`
--
ALTER TABLE `project_document`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `project_document_type`
--
ALTER TABLE `project_document_type`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `project_files`
--
ALTER TABLE `project_files`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `project_history`
--
ALTER TABLE `project_history`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `project_picture`
--
ALTER TABLE `project_picture`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `qualification`
--
ALTER TABLE `qualification`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `reminder`
--
ALTER TABLE `reminder`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `reminder_object_mail`
--
ALTER TABLE `reminder_object_mail`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `service`
--
ALTER TABLE `service`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `service_list`
--
ALTER TABLE `service_list`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `user_group`
--
ALTER TABLE `user_group`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- Contraintes pour les tables déchargées
--

--
-- Contraintes pour la table `agency`
--
ALTER TABLE `agency`
  ADD CONSTRAINT `FK_70C0C6E6979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`),
  ADD CONSTRAINT `FK_70C0C6E6F5B7AF75` FOREIGN KEY (`address_id`) REFERENCES `address` (`id`);

--
-- Contraintes pour la table `application_user`
--
ALTER TABLE `application_user`
  ADD CONSTRAINT `FK_7A7FBEC1727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `application_user` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_7A7FBEC1CDEADB2A` FOREIGN KEY (`agency_id`) REFERENCES `agency` (`id`);

--
-- Contraintes pour la table `company`
--
ALTER TABLE `company`
  ADD CONSTRAINT `FK_4FBF094F1D4F29AC` FOREIGN KEY (`company_state_id`) REFERENCES `company_state` (`id`),
  ADD CONSTRAINT `FK_4FBF094FF5B7AF75` FOREIGN KEY (`address_id`) REFERENCES `address` (`id`);

--
-- Contraintes pour la table `devices`
--
ALTER TABLE `devices`
  ADD CONSTRAINT `FK_11074E9A4FFA550E` FOREIGN KEY (`device_type_id`) REFERENCES `device_type` (`id`),
  ADD CONSTRAINT `FK_11074E9A78E40D21` FOREIGN KEY (`device_granule_informations_id`) REFERENCES `device_granule` (`id`),
  ADD CONSTRAINT `FK_11074E9AEE411DCC` FOREIGN KEY (`device_buche_informations_id`) REFERENCES `device_buche` (`id`);

--
-- Contraintes pour la table `dgaccessory`
--
ALTER TABLE `dgaccessory`
  ADD CONSTRAINT `FK_FF097AED1AB50D8E` FOREIGN KEY (`duct_id`) REFERENCES `duct` (`id`);

--
-- Contraintes pour la table `dgdesignation`
--
ALTER TABLE `dgdesignation`
  ADD CONSTRAINT `FK_7F34A32C1AB50D8E` FOREIGN KEY (`duct_id`) REFERENCES `duct` (`id`);

--
-- Contraintes pour la table `dginterior_details`
--
ALTER TABLE `dginterior_details`
  ADD CONSTRAINT `FK_D7A46641AB50D8E` FOREIGN KEY (`duct_id`) REFERENCES `duct` (`id`);

--
-- Contraintes pour la table `file`
--
ALTER TABLE `file`
  ADD CONSTRAINT `FK_8C9F3610979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`);

--
-- Contraintes pour la table `final_customer`
--
ALTER TABLE `final_customer`
  ADD CONSTRAINT `FK_FED0A039CDEADB2A` FOREIGN KEY (`agency_id`) REFERENCES `agency` (`id`),
  ADD CONSTRAINT `FK_FED0A039F5B7AF75` FOREIGN KEY (`address_id`) REFERENCES `address` (`id`);

--
-- Contraintes pour la table `log_connection`
--
ALTER TABLE `log_connection`
  ADD CONSTRAINT `FK_23E1DFDDA76ED395` FOREIGN KEY (`user_id`) REFERENCES `application_user` (`id`);

--
-- Contraintes pour la table `note`
--
ALTER TABLE `note`
  ADD CONSTRAINT `FK_CFBDFA14166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
  ADD CONSTRAINT `FK_CFBDFA14A76ED395` FOREIGN KEY (`user_id`) REFERENCES `application_user` (`id`);

--
-- Contraintes pour la table `project`
--
ALTER TABLE `project`
  ADD CONSTRAINT `FK_2FB3D0EE652F75EC` FOREIGN KEY (`final_customer_id`) REFERENCES `final_customer` (`id`),
  ADD CONSTRAINT `FK_2FB3D0EE94A4C7D4` FOREIGN KEY (`device_id`) REFERENCES `devices` (`id`),
  ADD CONSTRAINT `FK_2FB3D0EEA76ED395` FOREIGN KEY (`user_id`) REFERENCES `application_user` (`id`),
  ADD CONSTRAINT `FK_2FB3D0EEBD94FB16` FOREIGN KEY (`default_address_id`) REFERENCES `address` (`id`);

--
-- Contraintes pour la table `project_document`
--
ALTER TABLE `project_document`
  ADD CONSTRAINT `FK_E52701AD166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
  ADD CONSTRAINT `FK_E52701ADDCA6E926` FOREIGN KEY (`project_document_type_id`) REFERENCES `project_document_type` (`id`);

--
-- Contraintes pour la table `project_files`
--
ALTER TABLE `project_files`
  ADD CONSTRAINT `FK_156049C7166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`);

--
-- Contraintes pour la table `project_history`
--
ALTER TABLE `project_history`
  ADD CONSTRAINT `FK_B1A47C2E166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
  ADD CONSTRAINT `FK_B1A47C2EA76ED395` FOREIGN KEY (`user_id`) REFERENCES `application_user` (`id`);

--
-- Contraintes pour la table `project_picture`
--
ALTER TABLE `project_picture`
  ADD CONSTRAINT `FK_80C543EC166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`);

--
-- Contraintes pour la table `qualification`
--
ALTER TABLE `qualification`
  ADD CONSTRAINT `FK_B712F0CE979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`);

--
-- Contraintes pour la table `reminder`
--
ALTER TABLE `reminder`
  ADD CONSTRAINT `FK_40374F40166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
  ADD CONSTRAINT `FK_40374F4026ED0855` FOREIGN KEY (`note_id`) REFERENCES `note` (`id`),
  ADD CONSTRAINT `FK_40374F4083FFD6D3` FOREIGN KEY (`reminder_object_mail_id`) REFERENCES `reminder_object_mail` (`id`),
  ADD CONSTRAINT `FK_40374F40A76ED395` FOREIGN KEY (`user_id`) REFERENCES `application_user` (`id`);

--
-- Contraintes pour la table `service`
--
ALTER TABLE `service`
  ADD CONSTRAINT `FK_E19D9AD2166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
  ADD CONSTRAINT `FK_E19D9AD2A76ED395` FOREIGN KEY (`user_id`) REFERENCES `application_user` (`id`),
  ADD CONSTRAINT `FK_E19D9AD2F22A4417` FOREIGN KEY (`service_list_id`) REFERENCES `service_list` (`id`);

--
-- Contraintes pour la table `user_group`
--
ALTER TABLE `user_group`
  ADD CONSTRAINT `FK_8F02BF9DA76ED395` FOREIGN KEY (`user_id`) REFERENCES `application_user` (`id`),
  ADD CONSTRAINT `FK_8F02BF9DFE54D947` FOREIGN KEY (`group_id`) REFERENCES `fos_group` (`id`);

