Database Leaked - Ehcg.fr Sql © Chucky

Chucky · May 13, 2023

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),

View hidden content is available for registered users!
DOWNLOAD LINK:

View hidden content is available for registered users!

cqmygysd · May 22, 2023

Thank you for the share!

Week · May 22, 2023

thanks for sharing

llkks · May 26, 2023

Nice catch ! Thanks !

allentom · Jun 10, 2023

Thank you for the share!

justaguess · Aug 13, 2023

Link dead or bayfiles down

ademmlebgdu92 · Aug 19, 2024

link doesnt work update it....

Chucky · Aug 19, 2024

UPDATED LINKS TO DOWNLOAD THIS DATABASE.
SEE THE NEW URLS IN THE FIRST POST OF THIS TOPIC.

Database Leaked - Ehcg.fr Sql © Chucky

Chucky

cqmygysd

Week

llkks

allentom

justaguess

ademmlebgdu92

Chucky

Users who are viewing this thread

Similar threads