Sql © Chucky Database Leaked - Ehcg.fr
- Thread starter
- Administrator
- Moderator
- #1
Database Leaked ehcg.fr
INSERT INTO `event` (`id`, `type`, `date_event`, `content`, `detail`, `id_mission`, `id_user`) VALUES
INSERT INTO `user` (`idUser`, `langIdlang`, `firstnameUser`, `lastnameUser`, `emailUser`, `loginUser`, `passwordUser`, `barcodeUser`, `rankUser`, `isActiveUser`, `dateRegisterUser`, `dateLastLoginUser`, `ipUser`, `lastloginUser`, `genderUser`, `token`, `notecolor`, `tokenBat`, `tokenBatDate`, `isFirstVisit`, `representativeCode`, `userDevisCode`, `profileid`, `idCustomer`, `idcontact @fbi_gov User`, `isAutorisedToAddPapers`, `autoPrintLetterDevis`, `isResponsable`, `clientAutorizedRfq`, `idFkSupplier`, `idcontact @fbi_gov Supplier`, `userAvatarPath`) VALUES
INSERT INTO `contact @fbi_gov ` (`idcontact @fbi_gov `, `gendercontact @fbi_gov `, `firstname`, `lastname`, `emailcontact @fbi_gov `, `metiersMyhd`, `linkedin`, `statuscontact @fbi_gov `, `phone`, `mobile`, `fax`, `adress`, `zipcode`, `city`, `country`, `isFirst`, `emailnotification`, `batnotification`, `contact @fbi_gov seq`, `is_contact @fbi_gov _webtoprint`, `is_active`, `customerid`, `fonction`, `typecontact @fbi_gov `, `idFkSupplier`, `islivraison`) VALUES
Format - .SQL
Date - 2023
All Rows - 13kk
Website - ehcg.fr
HTML:
INSERT INTO `event` (`id`, `type`, `date_event`, `content`, `detail`, `id_mission`, `id_user`) VALUES
(724957, 'EDITION MISSION', '2022-09-06 18:18:53', 'Avant Edition', '["T2216460","T2216460",null,{"date":"2022-09-07 07:00:00.000000","timezone_type":3,"timezone":"Europe\\/Paris"},"TRACTO 18TONNES SANS PONT MOTEUR - 7h00 ILLIES HAMEAU DU GRAVELIN 2208016\\r\\nClient: COLAS FRANCE - COLWAV - Chef ROMAIN 0764867022\\r\\nN\\u00b0 Mission: T2216460 INTERLOC (Nicole)","ATT","COLWAV","2208016","DUFDOH","TRACTO 18T","","HOC","","T2216460-2208016-ILLIES","51.50","54.00",true,""]', 75867, 22),
(724958, 'EDITION MISSION', '2022-09-06 18:18:54', 'Après Edition', '["T2216460","T2216460",null,{"date":"2022-09-07 07:00:00.000000","timezone_type":3,"timezone":"Europe\\/Paris"},"TRACTO 18TONNES SANS PONT MOTEUR - 7h00 ILLIES HAMEAU DU GRAVELIN 2208016\\r\\nClient: COLAS FRANCE - COLWAV - Chef ROMAIN 0764867022\\r\\nN\\u00b0 Mission: T2216460 INTERLOC (Nicole)","ATT","COLWAV","2208016","DUFDOH","TRACTO 18T","","HOC","","T2216460-2208016-ILLIES","51.50","54.00",1,""]', 75867, 22),
(724959, 'GESTION TACHE', '2022-09-06 18:18:54', 'Suivi des taches', '{"ID":"73498","Type":null,"Closed":0,"Source":"Mission","IdSource":null,"Statut":null,"Action":"Instruction","Sujet":"Mission avec instruction \\u00e0 v\\u00e9rifier ","Mission":{},"Dispacher":{},"Demande":null,"Debut":{"date":"2022-09-06 18:18:54.000000","timezone_type":3,"timezone":"Europe\\/Paris"},"Creation":null,"Modification":{"date":"2022-09-06 18:18:54.000000","timezone_type":3,"timezone":"Europe\\/Paris"}}', 75867, 22),
(724960, 'LITIGE', '2022-09-06 18:19:29', 'Résolution du litige #7982 : Contestation Tarif Achat', NULL, 73931, 22),
(724961, 'GESTION TACHE', '2022-09-06 18:19:29', 'Suivi des taches', '{"ID":"73676","Type":null,"Closed":1,"Source":"Litige","IdSource":null,"Statut":"Termin\\u00e9","Action":"Litige","Sujet":"R\\u00e9solution du litige #7982 : Contestation Tarif Achat","Mission":{"__initializer__":{},"__cloner__":{},"__isInitialized__":false},"Dispacher":{},"Demande":null,"Debut":{"date":"2022-09-06 18:19:29.000000","timezone_type":3,"timezone":"Europe\\/Paris"},"Creation":null,"Modification":{"date":"2022-09-06 18:19:29.000000","timezone_type":3,"timezone":"Europe\\/Paris"}}', 73931, 22),
(724962, 'VALIDATION BON NS DISPACHER', '2022-09-06 18:19:49', '', NULL, 75486, 2797),
(724963, 'PROCESS ENVOI MAILS: sendMail', '2022-09-06 18:19:50', 'Suivi des envois des mails (lors de la validation mission)', '{"mail_to_array":["Georgy.LELEUX@eiffage.com"],"mail_bcc_array":["ywendzinski@gmail.com","slahchiouach@havetdigital.fr","ywendzinski@havetdigital.fr"],"mail_subject":"Envoi du Bon de travail sign\\u00e9 et valid\\u00e9","template":"template_mail","data_title_mail":"Envoi du Bon de travail sign\\u00e9 et valid\\u00e9","attachement":"C:\\\\PROJETS\\\\interloc\\\\config\\\\autoload\\\\..\\\\..\\\\public\\/ressources\\/MISSIONS\\\\EIFLES\\\\BL-T2216093-05-09-2022-CHANTIER-Lille.pdf","success":true}', 75486, NULL),
(724964, 'ENVOI BON VALIDE', '2022-09-06 18:19:51', 'Envoi du bon validé suite à une validation dispacher du Bon_NS à Eddy DEQUIDT Georgy.LELEUX@eiffage.com', NULL, 75486, NULL),
(724965, 'PROCESS ENVOI MAILS: sendMail', '2022-09-06 18:19:51', 'Suivi des envois des mails (lors de la validation mission)', '{"mail_to_array":["sarl.bennett@hotmail.fr"],"mail_bcc_array":["ywendzinski@gmail.com","slahchiouach@havetdigital.fr","ywendzinski@havetdigital.fr"],"mail_subject":"Envoi du Bon de travail sign\\u00e9 et valid\\u00e9","template":"template_mail","data_title_mail":"Envoi du Bon de travail sign\\u00e9 et valid\\u00e9","attachement":"C:\\\\PROJETS\\\\interloc\\\\config\\\\autoload\\\\..\\\\..\\\\public\\/ressources\\/MISSIONS\\\\EIFLES\\\\BL-T2216093-05-09-2022-CHANTIER-Lille.pdf","success":true}', 75486, NULL),
(724966, 'ENVOI BON VALIDE', '2022-09-06 18:19:51', 'Envoi du bon validé suite à une validation dispacher du Bon_NS à Khaled KHALED sarl.bennett@hotmail.fr', NULL, 75486, NULL),
(724967, 'ETAT PRE FACTURATION', '2022-09-06 18:19:51', 'Passage à l''état Pré-facturation suite à la validation dispacher', NULL, 75486, NULL),
(724968, 'PROCESS PREFACTURATION', '2022-09-06 18:19:51', 'Process préfacturation par le dispacher. Préfacturé par le dispacher et envoyé avec succès', NULL, 75486, NULL),
(724969, 'EDITION MISSION', '2022-09-06 18:24:05', 'Avant Edition', '["T2216464","T2216464",null,{"date":"2022-09-07 07:00:00.000000","timezone_type":3,"timezone":"Europe\\/Paris"},"TRACTO 18TONNES SANS PONT MOTEUR - 7h00 Brebi\\u00e8res ENTREPRISE GAZ EUP - RUE GEORGES LEFEBVRE- ZONE HORIZON 2 C22080138\\r\\nClient: EJL NORD DOUAI - EJLDOU - Chef 0619161907 DIMITRI\\r\\nN\\u00b0 Mission: T2216464 INTERLOC (Nicole)","ATT","EJLDOU","C22080138","CARGRA","TRACTO 18T","","HOC","D0864","T2216464-C22080138-Brebi\\u00e8res","53.00","54.50",true,null]', 75872, 22),
(724970, 'EDITION MISSION', '2022-09-06 18:24:05', 'Après Edition', '["T2216464","T2216464",null,{"date":"2022-09-07 07:00:00.000000","timezone_type":3,"timezone":"Europe\\/Paris"},"TRACTO 18TONNES SANS PONT MOTEUR - 7h00 Brebi\\u00e8res ENTREPRISE GAZ EUP - RUE GEORGES LEFEBVRE- ZONE HORIZON 2 C22080138\\r\\nClient: EJL NORD DOUAI - EJLDOU - Chef 0619161907 DIMITRI\\r\\nN\\u00b0 Mission: T2216464 INTERLOC (Nicole)","ATT","EJLDOU","C22080138","CARGRA","TRACTO 18T","","HOC","D0864","T2216464-C22080138-Brebi\\u00e8res","53.00","54.50",1,""]', 75872, 22),
(724971, 'GESTION TACHE', '2022-09-06 18:24:06', 'Suivi des taches', '{"ID":"73507","Type":null,"Closed":0,"Source":"Mission","IdSource":null,"Statut":null,"Action":"Instruction","Sujet":"Mission avec instruction \\u00e0 v\\u00e9rifier ","Mission":{},"Dispacher":{},"Demande":null,"Debut":{"date":"2022-09-06 18:24:06.000000","timezone_type":3,"timezone":"Europe\\/Paris"},"Creation":null,"Modification":{"date":"2022-09-06 18:24:06.000000","timezone_type":3,"timezone":"Europe\\/Paris"}}', 75872, 22),
INSERT INTO `user` (`idUser`, `langIdlang`, `firstnameUser`, `lastnameUser`, `emailUser`, `loginUser`, `passwordUser`, `barcodeUser`, `rankUser`, `isActiveUser`, `dateRegisterUser`, `dateLastLoginUser`, `ipUser`, `lastloginUser`, `genderUser`, `token`, `notecolor`, `tokenBat`, `tokenBatDate`, `isFirstVisit`, `representativeCode`, `userDevisCode`, `profileid`, `idCustomer`, `idcontact @fbi_gov User`, `isAutorisedToAddPapers`, `autoPrintLetterDevis`, `isResponsable`, `clientAutorizedRfq`, `idFkSupplier`, `idcontact @fbi_gov Supplier`, `userAvatarPath`) VALUES
(5275, 1, 'Amandine', 'CAILLY', 'amandine.cailly@pasdecalais-habitat.fr', 'CP0062', '022c24ff5d54fe5f2b1a3b61b44f09695b111fdd', NULL, '0', 1, '1534498710', NULL, '172.17.15.12', '1534498710', 'MRS', 'token', 'color', '5e69fda38cda2060819766569fd93aa5', '2018-08-17 11:38:30', 0, NULL, NULL, 2, 2538, 10199, 0, 0, 0, 0, NULL, NULL, NULL),
(5276, 1, 'DAVID', 'GONCE', 'deruycklucie@yahoo.fr', 'CP0048', '022c24ff5d54fe5f2b1a3b61b44f09695b111fdd', NULL, '0', 1, '1534498721', NULL, '172.17.15.12', '1534498721', 'MR', 'token', 'color', 'ed383ec94720d62a939bfb6bdd98f50c', '2018-08-17 11:38:41', 0, NULL, NULL, 2, 2540, 10200, 0, 0, 0, 0, NULL, NULL, NULL),
(5277, 1, 'Anabela', 'DE ABREU', 'anabela.de_abreu@saint-gobain.com', 'CP0131', '022c24ff5d54fe5f2b1a3b61b44f09695b111fdd', NULL, '0', 1, '1534498727', NULL, '172.17.15.12', '1534498727', 'MRS', 'token', 'color', '770f8e448d07586afbf77bb59f698587', '2018-08-17 11:38:47', 0, NULL, NULL, 2, 2541, 10201, 0, 0, 0, 0, NULL, NULL, NULL),
(5278, 1, 'VINCENT', 'DEBLOCK', '', 'CP0030', '022c24ff5d54fe5f2b1a3b61b44f09695b111fdd', NULL, '0', 1, '1534498731', NULL, '172.17.15.12', '1534498731', 'MR', 'token', 'color', '82f292a22966b857d968fb578ccbead9', '2018-08-17 11:38:51', 0, NULL, NULL, 2, 2542, 10202, 0, 0, 0, 0, NULL, NULL, NULL),
(5279, 1, 'Aurelie', 'ZEMEL', 'secretariat@patouxtp.com', 'CP0060', '022c24ff5d54fe5f2b1a3b61b44f09695b111fdd', NULL, '0', 1, '1534500487', NULL, '172.17.15.12', '1534500487', 'Mme', 'token', 'color', '10cd8cca7d33d4526cf4c264654762c6', '2018-08-17 12:08:07', 1, NULL, NULL, 2, 2543, 10206, 0, 0, 0, 0, NULL, NULL, NULL),
(5280, 1, 'Carole', 'PATRAO', 'patraotransport@wanadoo.fr', 'CPATRA', 'e937dc0be43cb19a0bf2b232a09d4bbf8ecb7fcf', NULL, '0', 1, '1534498737', '1639557864', '172.17.15.12', '1534498737', 'Mme', '', 'color', '5b658d2a925565f0755e035597f8d22f', '2018-08-17 11:38:57', 1, NULL, NULL, 2, 2544, 10207, 0, 0, 0, 0, NULL, NULL, NULL),
(5281, 1, 'Patrice', 'DELABY', 'patricedelaby@gmail.com', 'CP0028', '022c24ff5d54fe5f2b1a3b61b44f09695b111fdd', NULL, '0', 1, '1534498741', NULL, '172.17.15.12', '1534498741', 'MR', 'token', 'color', '980b2e71a187f092466c13bf42cd6413', '2018-08-17 11:39:01', 0, NULL, NULL, 2, 2545, 10208, 0, 0, 0, 0, NULL, NULL, NULL),
(5282, 1, 'Florence', 'MEULEMAN', 'fmeuleman@nortia.fr', 'CP0100', '022c24ff5d54fe5f2b1a3b61b44f09695b111fdd', NULL, '0', 1, '1534498744', NULL, '172.17.15.12', '1534498744', 'MRS', 'token', 'color', '91e82999cf7e45da1070ebd673690716', '2018-08-17 11:39:04', 0, NULL, NULL, 2, 2546, 10209, 0, 0, 0, 0, NULL, NULL, NULL),
(5283, 1, 'Eric', 'BACHMANN', 'fmeuleman@nortia.fr', 'CS2068', '022c24ff5d54fe5f2b1a3b61b44f09695b111fdd', NULL, '0', 1, '1534498746', NULL, '172.17.15.12', '1534498746', 'MRS', 'token', 'color', '5ca359ab1e9e3b9c478459944a2d9ca5', '2018-08-17 11:39:06', 0, NULL, NULL, 2, 2547, 10210, 0, 0, 0, 0, NULL, NULL, NULL),
(5284, 1, 'Olivier', 'PLANTAZ', 'o.plantaz.lallain@schuller.fr', 'CP0049', '022c24ff5d54fe5f2b1a3b61b44f09695b111fdd', NULL, '0', 1, '1534498750', NULL, '172.17.15.12', '1534498750', 'MR', 'token', 'color', '0b9e57c46de934cee33b0e8d1839bfc2', '2018-08-17 11:39:10', 0, NULL, NULL, 2, 2548, 10211, 0, 0, 0, 0, NULL, NULL, NULL),
(5285, 1, 'Paul', 'CHARLET', 'paul-charlet@wanadoo.fr', 'CP0129', '022c24ff5d54fe5f2b1a3b61b44f09695b111fdd', NULL, '0', 1, '1534498757', NULL, '172.17.15.12', '1534498757', 'M', 'token', 'color', '151de84cca69258b17375e2f44239191', '2018-08-17 11:39:17', 0, NULL, NULL, 2, 2549, 10212, 0, 0, 0, 0, NULL, NULL, NULL),
(5286, 1, 'Alain', 'CORDIER', 'foyerpaulconstans@wanadoo.fr', 'C00331', '022c24ff5d54fe5f2b1a3b61b44f09695b111fdd', NULL, '0', 1, '1534498760', NULL, '172.17.15.12', '1534498760', 'MR', 'token', 'color', '48237d9f2dea8c74c2a72126cf63d933', '2018-08-17 11:39:20', 0, NULL, NULL, 2, 2550, 10213, 0, 0, 0, 0, NULL, NULL, NULL),
(5287, 1, 'Caroline', 'BURELLE', 'contact @fbi_gov @paulmichel-import.com', 'CP0017', '022c24ff5d54fe5f2b1a3b61b44f09695b111fdd', NULL, '0', 1, '1534498767', NULL, '172.17.15.12', '1534498767', 'MRS', 'token', 'color', 'b937176da86d4bb5f0ac63aaecf540ea', '2018-08-17 11:39:27', 0, NULL, NULL, 2, 2551, 10215, 0, 0, 0, 0, NULL, NULL, NULL),
(
INSERT INTO `contact @fbi_gov ` (`idcontact @fbi_gov `, `gendercontact @fbi_gov `, `firstname`, `lastname`, `emailcontact @fbi_gov `, `metiersMyhd`, `linkedin`, `statuscontact @fbi_gov `, `phone`, `mobile`, `fax`, `adress`, `zipcode`, `city`, `country`, `isFirst`, `emailnotification`, `batnotification`, `contact @fbi_gov seq`, `is_contact @fbi_gov _webtoprint`, `is_active`, `customerid`, `fonction`, `typecontact @fbi_gov `, `idFkSupplier`, `islivraison`) VALUES
(24132, 'Mme', 'Valérie', 'GADEBLED', 'gadebled.valery@busi-part.com', '', '', 1, '03 28 22 67 77', '', '', ' ROUTE DES CARAIBES PORT OUEST 5845 ', '59279 ', 'LOON PLAGE ', 'FRANCE', 0, NULL, NULL, NULL, 0, 1, 2403, 'Responsable de service', 'ACHATS', NULL, 0),
(24133, 'Mme', 'Fabienne', 'LEFEBVRE', 'nord-coat@wanadoo.fr', 'Print;Digital;Studio;Dev', '', 1, '03 20 48 68 68', '', '', 'ZAE DE L EPINETTE ', '59850', 'NIEPPE', 'FRANCE', 0, NULL, NULL, NULL, 0, 1, 2432, 'Employé', 'Administratif', NULL, 0),
(24134, 'M', 'Gaelle', 'MANIEZ', 'contact @fbi_gov @jbbernard.fr', '', '', 1, '03 21 50 57 80', '', '', '2, rue de Bihucourt ', '62121 ', 'GOMIECOURT', 'FRANCE', 0, NULL, NULL, NULL, 0, 1, 2764, 'Responsable de service', 'Informatique', NULL, 0),
(24135, 'M', 'William', 'Jue', 'william.jue@euro-channel-logistics.com', 'Print;Studio', '', 1, '02 35 40 00 41', '0688912763', '', 'RUE JEAN REDELE', '76370', 'MARTIN-EGLISE', 'France', 1, NULL, NULL, NULL, 0, 0, 19818, 'Responsable de service', 'Achat', NULL, 0),
(24136, 'Mme', 'Celine ', 'COTTIGNIES ', 'contact @fbi_gov @jbbernard.fr', 'Print;Studio', '', 1, '03.21.50.57.80', '', '', '2 rue de bihucourt\r\n \r\n', '62121', 'Gomiécourt', 'France', 1, NULL, NULL, NULL, 0, 1, 2764, 'Employé', 'Achat', NULL, 0),
(24137, 'M', 'Mohamed Amin', 'EL AMRAOUI', 'mohamedamin.elamraoui@cemex.com', 'Print', '', 1, '+33(01)69934625', '+33 0620893290', '', 'CEMEX Bétons Ile de France \r\n2, rue Paul Doumer -CS45411 ', '91120', 'Palaiseau', 'FRANCE', 0, NULL, NULL, NULL, 0, 1, 526, 'Responsable de service', 'Achat', NULL, 0),
(24138, 'M', 'Alexandre', 'DELMER', 'adelmer@charlet.com', 'Digital', '', 1, '03 20 48 40 00', '', '', 'ZONE DE LA HOUSSOYE RUE CALMETTE ', '59280 ', 'BOIS GRENIER ', 'FRANCE', 0, NULL, NULL, NULL, 0, 1, 7826, 'Responsable de service', 'Informatique', NULL, 0),
(24139, 'M', 'Christophe ', 'JULLIEN', 'christophe.jullien@stalliant.com', 'Print;Digital;Studio;Dev', '', 1, '08 25 87 69 08', '06 08 21 79 14', '', ' 10 rue Rouget de l''Isle ', '92415', 'COURBEVOIE', 'FRANCE', 0, NULL, NULL, NULL, 0, 1, 19117, 'Employé', 'Achat', NULL, 0),
(24140, 'M', 'Julien', 'VILLECROZE', 'julien.villecroze@stelliant.com', '', '', 1, '0825876908', '', '', '10 rue Rouget de l''Isle', '92415', 'COURBEVOIE', 'France', 0, NULL, NULL, NULL, 0, 1, 19117, 'Responsable de service', 'Informatique', NULL, 0),
(24141, 'M', 'jerome ', 'pierret', 'jeromepierret@sfr.fr', 'Print;Studio', '', 1, '03.64.16.04.88 ', '06.22.45.94.88 ', '', ' RUE DU CHATEAU LISLET', '02340', 'LISLET', 'France', 1, NULL, NULL, NULL, 0, 1, 19819, 'Employé', 'Achat', NULL, 0),
(24142, 'M', 'Francois ', 'PIGACHE', 'c2f2p@orange.fr', '', '', 1, '03 21 07 19 79', '', '', '18 rue du Moulin ', '62123 ', 'BERLES AU BOIS ', 'FRANCE', 0, NULL, NULL, NULL, 0, 1, 5882, 'Direction', 'Direction', NULL, 0),
(24143, 'M', 'Service', 'Partenariat', 'hello@alchimii.com', '', '', 1, '01 40 38 04 13', '', '', '256 RUE DU FAUBOURG SAINT MARTIN', '75010', 'PARIS 10', 'France', 1, NULL, NULL, NULL, 0, 1, 19820, 'Responsable de service', 'Achat', NULL, 0),
(24144, 'M', 'Wilfrid', 'TAUPIN', 'wilfrid.taupin@airliquide.com', '', 'https://www.linkedin.com/in/wilfrid-taupin-317a8a112/', 1, '', '06 48 01 43 31', '', '', '', '', '', 0, NULL, NULL, NULL, 0, 1, 3752, 'Employé', 'Achat', NULL, 0),
(24145, 'Mme', 'Tiffany', 'GRAU', 'contact @fbi_gov @transportstouyre.com', '', '', 1, '04 71 49 22 33', '', '', 'LE BOURG\r\n', '15120', 'LABESSERETTE', 'FRANCE', 0, NULL, NULL, NULL, 0, 1, 3474, 'Direction', 'Achat', NULL, 0),
DOWNLOAD LINK:
View hidden content is available for registered users!
Last edited: