Posts: 617
Threads: 596
Joined: Jan 2023
Reputation:
3
balance: 5 R
Please login or register to view this content
Posts: 19
Threads: 0
Joined: Oct 2023
Reputation:
0
balance: 0 R
(07-21-2023, 10:35 AM)letmein Wrote: Website - agenceemploijeunes.ci
Agence emploi jeunes en Cote d'Ivoire
Format - .SQL
Size sql file - 3.2GB
Date - 2023
All Rows - 2.3kk
unique users/emails - 296k
  INSERT INTO `digit_demandeur_demandeuremploi` (`id`, `matriculeaej`, `prenoms`, `datenaissance`, `lieunaissance`, `lieuhabitation`, `telephone`, `numerocni`, `nombreexperience`, `etablissementfrequente`, `expertise`, `datedebutchomage`, `nocnps`, `dateinscription`, `sexe_id`, `paysdemandeur_id`, `handicapdemandeur`, `statudemandeur_id`, `motifinscription_id`, `typepieceidentite_id`, `niveauetude_id`, `diplome_id`, `specialite_id`, `divisionregionaleaej_id`, `paysresidence_id`, `paysnationalite_id`, `typeenseignement_id`, `typesituationhandicap_id`, `villeresidence_id`, `uniteexperience_id`, `categoriedemandeur_id`, `agencecnps_id`, `created_at`, `updated_at`, `deleted_at`, `paysdiplome_id`, `secteuractivite_id`, `situationmatrimoniale_id`, `conseilleremploi_id`, `typeetablissement_id`, `competence_id`, `nom`, `soussecteuractivite_id`, `conseillerprojet_id`, `nomdupere`, `nomdelamere`, `lieunaissance_id`, `lieuhabitation_id`, `typenationalite_id`, `precision_handicap`, `migration_key`, `actif`, `last_user`, `first_user`, `cvdemandeur`, `offresms`, `offreemail`, `email`, `precisionhandicap`, `statutdemandeur_id`, `ancienphoto`) VALUES
  INSERT INTO `users` (`id`, `name`, `email`, `password`, `activation_code`, `persist_code`, `reset_password_code`, `permissions`, `is_activated`, `activated_at`, `last_login`, `created_at`, `updated_at`, `username`, `surname`, `deleted_at`, `last_seen`, `is_guest`, `is_superuser`, `typeutilisateur_id`, `demandeuremploi_id`, `cabinetplacement_id`, `entreprise_id`, `login`, `cellulaire`, `migration_key`, `actif`, `estancien`, `ancienavatar`) VALUES
sample:
Code: (29688, 'Metch', 'pmetch@gmail.com', '501f06eec9cfd3b82848142d3b4520c6', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'pmetch@gmail.com', 'Pierre Marie Aubierge Agnime', NULL, NULL, 0, 0, 1, 29688, NULL, NULL, 'pmetch@gmail.com', '42125524', '29688', 1, 1, NULL),
(29690, 'guepie', 'olivier.guepie23@gmail.com', 'c778974af2c81bcd7c55ee573649ca69', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'olivier.guepie23@gmail.com', 'ulrich lionnel', NULL, NULL, 0, 0, 1, 29690, NULL, NULL, 'olivier.guepie23@gmail.com', '01773538', '29690', 1, 1, NULL),
(29692, 'gohou', 'gohoulibicyrille@gmail.com', '68b1a203b163b3ba63fcbf39fdcd6f51', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'gohoulibicyrille@gmail.com', 'libi cyrille', NULL, NULL, 0, 0, 1, 29692, NULL, NULL, 'gohoulibicyrille@gmail.com', '78006578', '29692', 1, 1, NULL),
(29693, 'kouassi', 'angyamenan@gmail.com', '310dabdf240d23eabf43e814a502f901', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'angyamenan@gmail.com', 'amenan angeline', NULL, NULL, 0, 0, 1, 29693, NULL, NULL, 'angyamenan@gmail.com', '57999717', '29693', 1, 1, NULL),
(29694, 'SAMBLE', 'eliegohibi@gmail.com', '9ed2262f101c7050ff0ba9763dc501a1', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'eliegohibi@gmail.com', 'DOUO ADELINE ', NULL, NULL, 0, 0, 1, 29694, NULL, NULL, 'eliegohibi@gmail.com', '46290924', '29694', 1, 1, NULL),
(29695, 'FOFANA', 'ismaelfofana206@outlook.fr', '2fcb1e2c5c7a490522e3ffe613b0d649', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'ismaelfofana206@outlook.fr', 'SOUMAILA', NULL, NULL, 0, 0, 1, 29695, NULL, NULL, 'ismaelfofana206@outlook.fr', '45020810', '29695', 1, 1, NULL),
(29697, 'KOUADIO', 'kouadioregis1@gmail.com', 'bc77a5adbbd23aae095168968bb9de59', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'kouadioregis1@gmail.com', 'AYA MARIE REGIS', NULL, NULL, 0, 0, 1, 29697, NULL, NULL, 'kouadioregis1@gmail.com', '08987627', '29697', 1, 1, NULL),
(29698, 'woi', 'woinelson@gmail.com', '0f6c67dcc8476e05ea1c6e9d827e51c3', NULL, NULL, '05H0eKb1FUTzlthnudfy5LOx6wlAnYSiPfTcWc8ewI', NULL, 1, NULL, NULL, NULL, '2018-04-05 12:44:04', 'woinelson@gmail.com', 'dosso nelson martial', NULL, NULL, 0, 0, 1, 29698, NULL, NULL, 'woinelson@gmail.com', '65838883', '29698', 1, 1, NULL),
(29700, 'ADINGRA', 'kiraha520@yahoo.fr', '28afd73a4eeffea6bfb5f410e1235c1e', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'kiraha520@yahoo.fr', 'Affia Kiraha Annick', NULL, NULL, 0, 0, 1, 29700, NULL, NULL, 'kiraha520@yahoo.fr', '47692219', '29700', 1, 1, NULL),
(29701, 'ADJA', 'adjaessosergeomer@gmail.com', '729faddafc590edf2eba69dc2436a982', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'adjaessosergeomer@gmail.com', 'ESSO SERGE OMER', NULL, NULL, 0, 0, 1, 29701, NULL, NULL, 'adjaessosergeomer@gmail.com', '40421431', '29701', 1, 1, NULL),
(29703, 'koffi', 'koffiolivier44@gmail.com', '$2y$10$57rXtQjX0QNEhO5YO2YVMeo0u9ORXfcUIlvmt/74wiruxJy/Ct1m2', NULL, '$2y$10$eMnwW3tc.J9vwphgypKKX.xmOgPc/8mu26O.cP4ZT1q9J8aPwepy6', NULL, NULL, 1, NULL, '2019-07-02 07:06:02', NULL, '2019-07-02 07:06:02', 'koffiolivier44@gmail.com', 'jean olivier', NULL, '2019-07-10 11:01:32', 0, 0, 1, 29703, NULL, NULL, 'koffiolivier44@gmail.com', '40708085', '29703', 1, 1, NULL),
(29704, 'TANGOH', 'tnhippo@gmail.com', '3683d841e7e1ada836935cdfdd92045a', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'tnhippo@gmail.com', 'NGUESSAN HIPPOLYTE', NULL, NULL, 0, 0, 1, 29704, NULL, NULL, 'tnhippo@gmail.com', '08336803', '29704', 1, 1, NULL),
(29705, 'Bini', 'alixbini@gmail.com', 'bcec769f0f5fbb3801fbb0e4ae925d23', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'alixbini@gmail.com', 'Abenan Alix', NULL, NULL, 0, 0, 1, 29705, NULL, NULL, 'alixbini@gmail.com', '49013576', '29705', 1, 1, NULL),
(29706, 'Soro', 'sorosanga@outlook.com', '10a1301d56887e0d9236b108be27697b', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'sorosanga@outlook.com', 'sanga', NULL, NULL, 0, 0, 1, 29706, NULL, NULL, 'sorosanga@outlook.com', '05560032', '29706', 1, 1, NULL),
(29707, 'ASSOUMA', 'assoumagnanagomarcdavid@yahoo.fr', 'f3b00d95dda006942fac5fa130ff2262', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'assoumagnanagomarcdavid@yahoo.fr', 'gnanago marc david', NULL, NULL, 0, 0, 1, 29707, NULL, NULL, 'assoumagnanagomarcdavid@yahoo.fr', '49059151', '29707', 1, 1, NULL),
(29708, 'BAH', 'ousmane.bah10@gmail.com', 'f2eee28d740a14d731bdbbac80c4cf46', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'ousmane.bah10@gmail.com', 'Ousmane', NULL, NULL, 0, 0, 1, 29708, NULL, NULL, 'ousmane.bah10@gmail.com', '47313022', '29708', 1, 1, NULL),
(29709, 'DEKA', 'Lumondek@gmail.com', '40d474ca38c4efc7dbf44f1b89e56956', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'Lumondek@gmail.com', 'MODUI LUCIEN', NULL, NULL, 0, 0, 1, 29709, NULL, NULL, 'Lumondek@gmail.com', '48122075', '29709', 1, 1, NULL),
(29710, 'YAPO', 'poyab2@yahoo.fr', '46b727dd0d3e6e86fb7f8a31ce8b322b', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'poyab2@yahoo.fr', 'BERENGER AURELIEN', NULL, NULL, 0, 0, 1, 29710, NULL, NULL, 'poyab2@yahoo.fr', '47285862', '29710', 1, 1, NULL),
(184424, '170949631821', 'MORY', '1983-01-01', NULL, NULL, '07263750', 'C0096047503', NULL, 'EPP', '', NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 1, 1, 49, NULL, 9, 141, 141, 2, 2, NULL, 3, NULL, NULL, '2017-12-12 00:00:00', NULL, NULL, 141, NULL, 3, 46, NULL, NULL, 'BAKAYOKO', 1, 0, NULL, NULL, NULL, NULL, 1, NULL, '184424', 1, NULL, NULL, 'cv_132965217_81baff291e9e3468f3c5dc926f45c6de.jpg', 1, 1, 'bakayokomory1983@gmail.com', '', 0, 'profil_288321507_81baff291e9e3468f3c5dc926f45c6de.jpg'),
(184425, '170116802682', 'ANIWA MARIE JEANNE', '1993-01-01', NULL, NULL, '79976287', 'C0107669982', 1, 'ALT-ISTEA ACADEMIE YOPOUGON', 'ASSISTANTE EN RESSOURCES HUMAINES ET COMMUNICATION', NULL, NULL, NULL, 2, 141, NULL, 1, 1, 1, 16, 12, NULL, 1, 141, 141, 4, 2, 4, 2, 7, NULL, '2017-12-12 00:00:00', '2019-03-06 17:49:24', NULL, 141, 20, 3, 808, NULL, NULL, 'ALIKO', 1876, 0, 'KOUADIO ALIKO FELIX', 'ETTIEN ADJO', 166, 4, 1, NULL, '184425', 1, 184425, NULL, NULL, 1, 1, 'jeanne.aliko01@gmail.com', NULL, 0, 'profil_1596278704_0a7056be5ad7f87f60327ca2a7a4582f.jpg'),
(184426, '170962670591', 'BABA', '1987-12-10', NULL, NULL, '04391097', 'C0045970548', 6, 'UNIVERSITE ALASSANE OUATTARA', 'Stagiaire', NULL, NULL, NULL, 1, 141, NULL, 1, 1, 1, 19, 15, NULL, 16, 141, 141, 2, 2, 938, 1, 8, NULL, '2017-12-12 00:00:00', '2018-12-17 22:47:36', NULL, 141, 1, 3, 46, NULL, NULL, 'SORO', 4, 0, 'FEU SORO LADJI', 'FEUE SORO GNONNOUGONAN AWA', 732, 539, 1, NULL, '184426', 1, 184426, NULL, NULL, 1, 1, 'babasoro07@gmail.com', NULL, 0, NULL),
(184427, '170176200631', 'YAO CELESTIN', '1992-01-04', NULL, NULL, '86581693', '0000657000577', NULL, 'EST LOKO', '', NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 2, 16, 12, NULL, 1, 141, 141, 4, 2, NULL, 1, NULL, NULL, '2017-12-12 00:00:00', NULL, NULL, 141, NULL, 3, 808, NULL, NULL, 'SARAKA', 221, 0, NULL, NULL, NULL, NULL, 1, NULL, '184427', 1, NULL, NULL, '', 1, 1, 'sarakayaocelestin@gmail.com', '', 0, 'profil_2099539780_e9ab2f2fb5a8aa49491e09dee957e855.jpg'),
(184428, '171383081642', 'GUEYE NADEGE', '1986-03-20', NULL, NULL, '08169843', 'C 0035361451', 0, 'CEFIAT ABIDJAN', 'GESTION DU PERSONNELPAIEMENT DU PERSONNEL', NULL, NULL, NULL, 2, 141, NULL, 1, 1, 1, 16, 12, NULL, 13, 141, 141, 3, 2, 416, 1, 6, NULL, '2017-12-12 00:00:00', '2018-09-19 11:55:44', NULL, 141, 46, 3, 8084, NULL, NULL, 'KEI', 44, 0, 'KEI GUEYE RAYMOND', 'BOU OUGENE MATHURINE', 578, 416, 1, NULL, '184428', 1, 184428, NULL, 'cv_1300666386_f04f3f851da0168f71f7cf52097130ca.docx', 1, 1, 'nadegekei2017@gmail.com', NULL, 0, 'profil_168417458_f04f3f851da0168f71f7cf52097130ca.jpg'),
(184429, '170136900011', 'BEDIA DESIRE', '1993-11-11', NULL, NULL, '79927242', 'C 0112 6188 36', NULL, 'ITES 2 PLATEAUX', '', NULL, NULL, NULL, 1, NULL, NULL, NULL, 2, 1, 16, 12, NULL, 1, 141, 141, 3, 2, NULL, 3, NULL, NULL, '2017-12-12 00:00:00', NULL, NULL, 141, NULL, 3, 808, NULL, NULL, 'DETTE', 2039, 0, NULL, NULL, NULL, NULL, 1, NULL, '184429', 1, NULL, NULL, 'cv_696285739_013ccb55c80db0a71ab51cbec52de705.docx', 1, 1, 'bediadesire225@gmail.com', '', 0, 'profil_1433806843_013ccb55c80db0a71ab51cbec52de705.jpg'),
(184430, '170110463741', 'OUMAR', '1990-02-23', NULL, NULL, '44215185', 'C0034669121', NULL, 'UNIVERSITE ADAMA SANOGO ABIDJAN', '', NULL, NULL, NULL, 1, NULL, NULL, NULL, 2, 1, 17, 43, NULL, 1, 141, 141, 1, 2, NULL, 3, NULL, NULL, '2017-12-12 00:00:00', NULL, NULL, 141, NULL, 3, 808, NULL, NULL, 'SOUMAHORO', 182, 0, NULL, NULL, NULL, NULL, 1, NULL, '184430', 1, NULL, NULL, 'cv_454725615_2f4cdfa3cebddfecf79b28d3585e3437.jpg', 1, 1, 'oumarsoumahor2020@gmail.com', '', 0, 'profil_5234675_2f4cdfa3cebddfecf79b28d3585e3437.jpg'),
(184431, '170403227412', 'AFFOUE EVELYNE', '1993-12-20', NULL, NULL, '87227902', 'C0109335919', NULL, NULL, NULL, NULL, NULL, NULL, 2, 141, NULL, 2, 1, 1, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, 1, 5, NULL, '2017-12-12 00:00:00', '2019-05-09 09:22:35', NULL, 141, 1, 3, 118, NULL, NULL, 'KOUAKOU', 2058, 0, 'KOAKOU YAO JOSEPH', 'KOUADIO AMOIN ELISABETH', 253, 938, 1, NULL, '184431', 1, 199, NULL, NULL, 1, 1, 'evelynekouakouaffoue@gmail.com', NULL, 0, 'default.png'),
(184432, '170164343202', 'RAMATA', '1986-12-28', NULL, NULL, '57632275', 'C 0025 2943 30', NULL, 'IFAD ABOBO', '', NULL, NULL, NULL, 2, NULL, NULL, NULL, 1, 1, 14, 16, NULL, 1, 141, 141, 3, 2, NULL, 2, NULL, NULL, '2017-12-12 00:00:00', NULL, NULL, 141, NULL, 3, 808, NULL, NULL, 'DOUMBIA', 113, 0, NULL, NULL, NULL, NULL, 1, NULL, '184432', 1, NULL, NULL, 'cv_2048727480_fde8170fa5e880aa4cba7999794e6dab.jpg', 0, 1, 'mamandetata1986@gmail.com', '', 0, 'profil_1246978949_fde8170fa5e880aa4cba7999794e6dab.jpg'),
(184433, '170263065592', 'Diane Olivia Yao', '1997-04-25', NULL, NULL, '48804593', 'C0114392376', NULL, 'AIST', '', NULL, NULL, NULL, 2, NULL, NULL, NULL, 2, 1, 16, 12, NULL, 2, 141, 141, 3, 2, NULL, 3, NULL, NULL, '2017-12-12 00:00:00', NULL, NULL, 141, NULL, 3, 807, NULL, NULL, 'KROKRO', 239, 0, NULL, NULL, NULL, NULL, 1, NULL, '184433', 1, NULL, NULL, 'cv_1078586999_58c5637a5b42d08784cae0c5892329e1.docx', 1, 1, 'dianeoliviayao@gmail.com', '', 0, 'profil_1584934916_58c5637a5b42d08784cae0c5892329e1.jpg'),
(184434, '170437073042', 'AGYENIM ELLA-GLWADYS', '1979-07-14', NULL, NULL, '58749525', 'C0090649240', NULL, '', '', NULL, NULL, NULL, 2, NULL, NULL, NULL, 4, 1, 9, 4, NULL, 4, 141, 141, 2, 2, NULL, 3, NULL, NULL, '2017-12-12 00:00:00', NULL, NULL, 141, NULL, 2, 41, NULL, NULL, 'BOITINI', 114, 0, NULL, NULL, NULL, NULL, 1, NULL, '184434', 1, NULL, NULL, 'cv_715248353_107d8b703fb8f7eaad62cc7111aca651.docx', 1, 1, 'boitiniella10@gmail.fr', '', 0, 'profil_1241897563_107d8b703fb8f7eaad62cc7111aca651.jpg'),
(184435, '170737341592', 'AMINATA OUATTARA', '1976-12-30', NULL, NULL, '08627137', 'C 0053221719', NULL, '', '', NULL, NULL, NULL, 2, NULL, NULL, NULL, 1, 1, 9, 510, NULL, 7, 141, 141, 2, 2, NULL, 2, NULL, NULL, '2017-12-12 00:00:00', NULL, NULL, 141, NULL, 2, 1, NULL, NULL, 'BOUHO', 129, 0, NULL, NULL, NULL, NULL, 1, NULL, '184435', 1, NULL, NULL, 'cv_744447284_3018797413bc14505b0667bc149bb2ad.docx', 1, 1, 'aminatabouho@yahoo.fr', '', 0, 'profil_1320838369_3018797413bc14505b0667bc149bb2ad.png'),
(184436, '170894884672', 'LOU IRIE FRANCOISE', '1986-03-09', NULL, NULL, '46522222', '51020124020517', NULL, 'CET BOUAKE', '', NULL, NULL, NULL, 2, NULL, NULL, NULL, 1, 2, 14, 10, NULL, 8, 141, 141, 4, 2, NULL, 1, NULL, NULL, '2017-12-12 00:00:00', NULL, NULL, 141, NULL, 1, 6, NULL, NULL, 'YOUAN ZOU', 2053, 0, NULL, NULL, NULL, NULL, 1, NULL, '184436', 1, NULL, NULL, 'cv_1504016962_9139e8540504f6a54554f44f85fa2af4.docx', 1, 1, 'francoisesikabi@gmail.com', '', 0, 'profil_969016234_9139e8540504f6a54554f44f85fa2af4.JPG'),
|