Hello, Today i'm selling the database (full sql dump not scrap) of the Fédération Française de Motocyclisme.
Offer a price in PM.
Only MM
Sample :
The table "Adresses " contain 467658 rows.
INSERT INTO `Adresses` VALUES (34098,32951,0,'2024-02-12 09:06:37','PR','37','RUE','DES PRINCES DE WAGRAM','','','',NULL,NULL,NULL,94520,'','MANDRES LES ROSES','94047',NULL,'FR','[email protected]',NULL,'','','0769502845',NULL,NULL,NULL,NULL,NULL,000,000),(34099,32952,0,'2023-12-19 08:08:56','PR','490','CHE','DE LECOURT','','','',NULL,NULL,NULL,40180,'','SORT-EN-CHALOSSE','40(34416,33540,0,'2003-02-20 17:10:51','PR','19','RUE','PRINCIPALE',NULL,NULL,'',NULL,NULL,NULL,57980,NULL,'DIEBLING','00000',NULL,'FR',NULL,NULL,'0387024615','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34417,33542,0,'2022-03-27 09:15:05','PR','','AAA','2A RUE DE LA COLONNE','','','',NULL,NULL,NULL,57960,'','MEISENTHAL','57456',NULL,'FR','[email protected]',NULL,'0387969565','','0680408418',NULL,NULL,NULL,NULL,NULL,000,000),(34418,33543,0,'2003-02-20 17:10:51','PR','7','RUE','DE LA CHARMILLE',NULL,NULL,'',NULL,NULL,NULL,67610,NULL,'LA WANTZENAU','00000',NULL,'FR',NULL,NULL,'0388966765','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34419,33544,0,'2003-02-20 17:10:51','PR','6','RUE','DU VIVIER',NULL,NULL,'',NULL,NULL,NULL,42160,NULL,'ANDREZIEUX BOUTHEON','00000',NULL,'FR',NULL,NULL,'0477367900','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34420,33545,0,'2003-02-20 17:10:51','PR',NULL,'SANS','LA BOURGEE FROIDE',NULL,NULL,'',NULL,NULL,NULL,42330,NULL,'CUZIEU','00000',NULL,'FR',NULL,NULL,'0477548887','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34421,33546,0,'2003-02-20 17:10:51','PR','41','RUE','DES TOURNELLES',NULL,NULL,'',NULL,NULL,NULL,75003,NULL,'PARIS','00000',NULL,'FR',NULL,NULL,'0142746246','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34422,33547,0,'2003-02-20 17:10:51','PR','75','BOU','SOULT',NULL,NULL,'',NULL,NULL,NULL,75015,NULL,'PARIS','00000',NULL,'FR',NULL,NULL,'0143454609','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34423,33548,0,'2003-02-20 17:10:51','PR','237','RUE','CLAUDEUS SAVOYE',NULL,NULL,'',NULL,NULL,NULL,69400,NULL,'VILLEFRANCHE SUR SAONE','00000',NULL,'FR',NULL,NULL,'0474681829','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34424,33549,0,'2004-03-23 13:14:59','PR','41','RUE','BRESSIGNY',NULL,NULL,'',NULL,NULL,NULL,49100,NULL,'ANGERS','00000',NULL,'FR','[email protected]',NULL,'0241733709','','0660695821',NULL,NULL,NULL,NULL,'TM',000,000),(34425,33550,0,'2003-02-20 17:10:51','PR',NULL,'HAM','LES VIGNES',NULL,NULL,'B.18',NULL,NULL,NULL,05200,NULL,'EMBRUN','00000',NULL,'FR',NULL,NULL,'0615204123','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34426,33551,0,'2003-02-20 17:10:51','PR',NULL,'SANS','LACOST',NULL,NULL,'',NULL,NULL,NULL,63520,NULL,'DOMAIZE','00000',NULL,'FR',NULL,NULL,'0473707177','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34427,33552,0,'2003-02-20 17:10:51','PR','44','ROU','DES SANGUINIERES',NULL,NULL,'',NULL,NULL,NULL,79230,NULL,'FORS','00000',NULL,'FR',NULL,NULL,'0549326391','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34428,33553,0,'2008-02-19 11:47:05','PR',NULL,'SANS','SAUVIAT',NULL,NULL,'',NULL,NULL,NULL,19510,NULL,'MEILHARDS','00000',NULL,'FR',NULL,NULL,'','','0613371278',NULL,NULL,NULL,NULL,'TM',000,000),(34429,33554,0,'2003-02-20 17:10:51','PR',NULL,'SANS','LA BUSSIERE ST SULPICE',NULL,NULL,'',NULL,NULL,NULL,23000,NULL,'GUERET','00000',NULL,'FR',NULL,NULL,'0555510404','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34430,33555,0,'2003-02-20 17:10:51','PR','154','RUE','DELEUZE',NULL,NULL,'',NULL,NULL,NULL,04200,NULL,'SISTERON','00000',NULL,'FR',NULL,NULL,'0492611407','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34431,33556,0,'2003-02-20 17:10:51','PR',NULL,'SANS','RESIDENCE D ENTRAIS 226',NULL,NULL,'',NULL,NULL,NULL,05000,NULL,'GAP','00000',NULL,'FR',NULL,NULL,'0492521095','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34432,33557,0,'2003-02-20 17:10:51','PR',NULL,'AVE','JEAN DES FIGUES',NULL,NULL,'LES ROMARINS',NULL,NULL,NULL,04200,NULL,'SISTERON','00000',NULL,'FR',NULL,NULL,'0492611347','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34433,33558,0,'2003-02-20 17:10:51','PR','72','CHE','DU PLAN DE LEYDET',NULL,NULL,'',NULL,NULL,NULL,04200,NULL,'SISTERON','00000',NULL,'FR',NULL,NULL,'0492613528','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34434,33559,0,'2015-01-29 19:36:41','PR','','AAA','LOT LA GAGERIE','','','',NULL,NULL,NULL,04400,'','LES THUILES','04220',NULL,'FR','[email protected]',NULL,'0492819090','','0616139004',NULL,'',NULL,'',NULL,000,000),(34435,33560,0,'2010-03-04 18:50:45','PR','72','SANS','BD CHARLES KADDOUZ',NULL,NULL,'',NULL,NULL,NULL,13012,NULL,'MARSEILLE 12','00000',NULL,'FR','[email protected]',NULL,'','','0603104338',NULL,NULL,NULL,NULL,'TM',000,000),(34436,33561,0,'2003-02-20 17:10:51','PR','13','RUE','MODIGLIANI D',NULL,NULL,'',NULL,NULL,NULL,06800,NULL,'CAGNES SUR MER','00000',NULL,'FR',NULL,NULL,'0493983208','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34437,33573,0,'2003-02-20 17:10:51','PR','4','RUE','ABEL DURAND',NULL,NULL,'',NULL,NULL,NULL,44360,NULL,'ST ETIENNE DE MONT LUC','00000',NULL,'FR',NULL,NULL,'0240869563','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34438,33577,0,'2023-04-23 18:13:11','PR','','AAA','VERMONT','','','131 IMPASSE DU PUITS',NULL,NULL,NULL,69910,'','VILLIE-MORGON','69267',NULL,'FR','[email protected]',NULL,'0474691667','','0664228156',NULL,NULL,NULL,NULL,NULL,000,000),308',NULL,'FR','[email protected]',NULL,'','','0643628688',NULL,NULL,NULL,NULL,NULL,000,000)
Personnes (462912) :
(82089,'2001-03-26 12:18:00','2003-02-20 17:07:05','P','Mme','DAGNAUD','LAURENCE','F','1973-01-18',NULL,'FR','250',0,0,NULL,NULL,'N','','A',NULL,NULL,NULL,NULL,NULL,'N',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'N',NULL),(82090,'2001-03-26 12:18:00','2024-01-06 06:59:07','P','M','DESIRE','YANNIS','M','1977-02-11','SAINT DENIS','FR','638',0,0,'DESIRE',NULL,'N','','A',NULL,NULL,NULL,NULL,'','O','2024-01-06 06:59:07',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','O',NULL,'100','SAINT DENIS','97411','N',NULL),(82091,'2001-03-26 12:24:00','2003-02-20 17:07:05','P','M','SERY','JULIEN','M','1981-10-28',NULL,'FR','250',0,0,'SERY',NULL,'N','','A',NULL,NULL,NULL,NULL,NULL,'N',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'N',NULL),(82092,'2001-03-26 12:24:00','2024-01-25 09:23:01','P','Mme','FOURNIER','CORINNE','F','1971-05-30','..','FR','250',0,0,'FOURNIER',
The table "Personnes" contain 462912 rows.
(82089,'2001-03-26 12:18:00','2003-02-20 17:07:05','P','Mme','DAGNAUD','LAURENCE','F','1973-01-18',NULL,'FR','250',0,0,NULL,NULL,'N','','A',NULL,NULL,NULL,NULL,NULL,'N',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'N',NULL),(82090,'2001-03-26 12:18:00','2024-01-06 06:59:07','P','M','DESIRE','YANNIS','M','1977-02-11','SAINT DENIS','FR','638',0,0,'DESIRE',NULL,'N','','A',NULL,NULL,NULL,NULL,'','O','2024-01-06 06:59:07',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','O',NULL,'100','SAINT DENIS','97411','N',NULL),(82091,'2001-03-26 12:24:00','2003-02-20 17:07:05','P','M','SERY','JULIEN','M','1981-10-28',NULL,'FR','250',0,0,'SERY',NULL,'N','','A',NULL,NULL,NULL,NULL,NULL,'N',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'N',NULL),(82092,'2001-03-26 12:24:00','2024-01-25 09:23:01','P','Mme','FOURNIER','CORINNE','F','1971-05-30','..','FR','250',0,0,'FOURNIER',
The table "CompteLicencie" contain 106422 rows.
INSERT INTO `CompteLicencie` VALUES ('065274',65274,'cBaX2rZaV5Mz9Ce/0gBtQvOjuPia3sE86hfmhRcGlUPPDaKHz6ebpWw1BnOdb6mLrARjwa+IW9Es+ijT4BK4fw8Edrthk0ikclEDil9J6xJNJX1mPuRXDU+89khQqeMs','9345954f9cd7b0df61341fbed3f5467f9213bb626b6d6cc6d640df4f5f8df004d67ce398afbfe45ae4c2d628545d78597d778f94968e97957450e41591535ed6',NULL,'$1$iKFgew8n$NX4YtN6fq8LLFviYbHsOU1','2021-01-10 19:50:44','0000-00-00 00:00:00'),('065301',65301,'98m+r2Ph+OMYow/KMmhGy2lgdZKM2+Y61uMvLnV1OeTe3Yg+5Km6BuUgvmCl6k8ov4ijvpxGwwTRBzR5/lmt37wZS2Oin99i9il+Oq8m/LzrQzvBJjOYWZhRRgQAVwn0','e4d6805f1eaefcab23a11778fbb408d533f86732ac3f8d79de8ba938e9f667021a8d5dea8b465605a6a5e63eb36923445932cece1b8aec70179e7b250426c95d','','$1$iYpz5JWq$LEfLPFVoIB5ErUjLZlF2Q/','2017-04-12 13:54:34','2017-04-12 13:54:34'),
('065340',65340,'6sUDf4zTVEXr3W+5FvWXWyt6xYNILgUJ2SRkAuFih0ybaer/D59W8PciVDAIi6yfk9AefS7HnnvnZKccBGXb4PdCQGH+PLT4IdvpjB9mKPYR86+/idk+7LClOuSbOdTu','f61d549f631cb612a8a4607ea2ed93187c865c8a23fb08871f6285eda0cadbfb7c77dc6d5260f59cb327ef7b00ae18f9d9c7a8dccddfe4b5871d7a64b615a767',NULL,'$1$3BK6beC.$BFg3xYQRiEFEkO042z2Av0','2023-01-09 16:17:58','2024-01-31 10:16:47'),('065341',65341,'EjcVSZC0FH9uKSumWlfCqCk8JObJAxt+km8jdtSkGg+XS5m7HjEvs/fzjvXpm8aMcJ4vvrLoFzlsUNy76SAEYN7NelT2Z11U0LVOPdKbs6f0mJ6966qqgCUnvP1eFBfL','436138c46c2be5a693e88816b3b5e9ee1336283dc56361204dc8d9d6026694d6da103f6cf01712fcbbee8995b0d41d968d919e060018aaa01793bbcc64a62bd8',NULL,'$1$S/zFvYAb$dMg24e74uVPO3RHJHZ0tv.','2023-06-05 19:17:55','2023-06-05 19:17:55'),
The table "PanierCmdElectroniques_retourbqe" contain 250501 rows.
INSERT INTO `PanierCmdElectroniques_retourbqe` VALUES (227549,'2024-11-30 21:59:04',1020368,'00',1,'{\"vads_tid\": \"001\", \"signature\": \"1e1c1b457cd84b08db62b86a33d110d8241916fe\", \"vads_hash\": \"7b4888d222dfab1696cc3fd6747ee0117102d825a8ea180795a16afe6b592922\", \"vads_amount\": \"2300\", \"vads_result\": \"00\", \"vads_cust_id\": \"487093\", \"vads_pays_ip\": \"FR\", \"vads_site_id\": \"53442100\", \"vads_version\": \"V2\", \"vads_ctx_mode\": \"PRODUCTION\", \"vads_currency\": \"978\", \"vads_language\": \"fr\", \"vads_order_id\": \"pass-487093-24063341020368\", \"vads_trans_id\": \"232518\", \"vads_auth_mode\": \"FULL\", \"vads_bank_code\": \"10096\", \"vads_cust_name\": \"TOM ROCHET CAPELLAN\", \"vads_bank_label\": \"Lyonnaise de banque L.B.\", \"vads_card_brand\": \"CB\", \"vads_cust_email\": \"[email protected]\", \"vads_trans_date\": \"20241130205557\", \"vads_trans_uuid\": \"d11ad46c0fd34d0b9ce0c6feb75612f1\", \"vads_action_mode\": \"INTERACTIVE\", \"vads_auth_number\": \"851458\", \"vads_auth_result\": \"00\", \"vads_card_nature\": \"CONSUMER\", \"vads_card_number\": \"497946XXXXXX9692\", \"vads_cust_status\": \"PRIVATE\", \"vads_expiry_year\": \"2025\", \"vads_page_action\": \"PAYMENT\", \"vads_payment_src\": \"EC\", \"vads_threeds_eci\": \"05\", \"vads_threeds_xid\": \"\", \"vads_bank_product\": \"P\", \"vads_card_country\": \"FR\", \"vads_expiry_month\": \"10\", \"vads_extra_result\": \"00\", \"vads_risk_control\": \"SUSPECT_IP_COUNTRY=OK\", \"vads_threeds_cavv\": \"A**************************=\", \"vads_trans_status\": \"AUTHORISED\", \"vads_capture_delay\": \"0\", \"vads_contract_used\": \"7295183\", \"vads_url_check_src\": \"PAY\", \"vads_cust_last_name\": \"ROCHET CAPELLAN\", \"vads_operation_type\": \"DEBIT\", \"vads_payment_config\": \"SINGLE\", \"vads_threeds_status\": \"Y\", \"vads_cust_first_name\": \"TOM\", \"vads_cust_legal_name\": \"\", \"vads_occurrence_type\": \"UNITAIRE\", \"vads_sequence_number\": \"1\", \"vads_validation_mode\": \"0\", \"vads_warranty_result\": \"YES\", \"vads_acquirer_network\": \"CB\", \"vads_brand_management\": \"{\\\"userChoice\\\":false,\\\"brandList\\\":\\\"CB|VISA\\\",\\\"brand\\\":\\\"CB\\\"}\", \"vads_effective_amount\": \"2300\", \"vads_threeds_enrolled\": \"Y\", \"vads_presentation_date\": \"20241130205613\", \"vads_threeds_auth_type\": \"CHALLENGE\", \"vads_effective_currency\": \"978\", \"vads_threeds_error_code\": \"\", \"vads_threeds_sign_valid\": \"\", \"vads_payment_certificate\": \"b65a7723a52a0bebc0179af8e4fc841f18edb967\", \"vads_threeds_exit_status\": \"10\", \"vads_archival_reference_id\": \"L33523251801\", \"vads_card_product_category\": \"DEBIT\", \"vads_threeds_cavvAlgorithm\": \"\", \"vads_cardholder_card_number\": \"497946XXXXXX9692\", \"vads_effective_creation_date\": \"20241130205613\", \"vads_threeds_user_interaction\": \"\", \"vads_cardholder_card_expiry_year\": \"2025\", \"vads_cardholder_card_expiry_month\": \"10\", \"vads_initial_issuer_transaction_identifier\": \"1I5674BFFB7B43C2\"}','{\"Email\": \"[email protected]\", \"Extra\": null, \"Status\": null, \"Context\": null, \"Montant\": \"2300\", \"OrderId\": \"pass-487093-24063341020368\", \"LastName\": null, \"FirstName\": null, \"LegalName\": null, \"UrlCancel\": null, \"UrlSucces\": null, \"PersonneId\": null, \"ReferenceId\": null, \"MessageErreur\": null, \"TransactionId\": \"232518\", \"UrlRetourTransparent\": null}','Bqe\\Paiement\\Licence1MFInter','/actions/current/paiementApiEPaiment1MFInter_cb.php'),(227550,'2024-11-30 22:00:42',1020373,'00',1,'{\"vads_tid\": \"001\", \"signature\": \"ca3769808ecf71a6ce18ef2ed4f44c7b3b094340\", \"vads_hash\": \"bac52f79aef94eedffaf11a029805471f6b338db91a5828f6fe70c8cec606fbc\", \"vads_amount\": \"4500\", \"vads_result\": \"00\", \"vads_cust_id\": \"470680\", \"vads_pays_ip\": \"FR\", \"vads_site_id\": \"53442100\", \"vads_version\": \"V2\", \"vads_ctx_mode\": \"PRODUCTION\", \"vads_currency\": \"978\", \"vads_language\": \"fr\", \"vads_order_id\": \"pass-470680-24063341020373\", \"vads_trans_id\": \"232524\", \"vads_auth_mode\": \"FULL\", \"vads_bank_code\": \"18706\", \"vads_cust_name\": \"DYLAN DUVIVIER\", \"vads_bank_label\": \"Caisse régionale de crédit agricole mutuel Brie Picardie\", \"vads_card_brand\": \"CB\", \"vads_cust_email\": \"[email protected]\", \"vads_trans_date\": \"20241130205907\", \"vads_trans_uuid\": \"0215d1f2394a4119a0a89093c9b488b1\", \"vads_action_mode\": \"INTERACTIVE\", \"vads_auth_number\": \"551541\", \"vads_auth_result\": \"00\", \"vads_card_nature\": \"CONSUMER\", \"vads_card_number\": \"513771XXXXXX4968\", \"vads_cust_status\": \"PRIVATE\",
Offer a price in PM.
Only MM
Sample :
The table "Adresses " contain 467658 rows.
INSERT INTO `Adresses` VALUES (34098,32951,0,'2024-02-12 09:06:37','PR','37','RUE','DES PRINCES DE WAGRAM','','','',NULL,NULL,NULL,94520,'','MANDRES LES ROSES','94047',NULL,'FR','[email protected]',NULL,'','','0769502845',NULL,NULL,NULL,NULL,NULL,000,000),(34099,32952,0,'2023-12-19 08:08:56','PR','490','CHE','DE LECOURT','','','',NULL,NULL,NULL,40180,'','SORT-EN-CHALOSSE','40(34416,33540,0,'2003-02-20 17:10:51','PR','19','RUE','PRINCIPALE',NULL,NULL,'',NULL,NULL,NULL,57980,NULL,'DIEBLING','00000',NULL,'FR',NULL,NULL,'0387024615','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34417,33542,0,'2022-03-27 09:15:05','PR','','AAA','2A RUE DE LA COLONNE','','','',NULL,NULL,NULL,57960,'','MEISENTHAL','57456',NULL,'FR','[email protected]',NULL,'0387969565','','0680408418',NULL,NULL,NULL,NULL,NULL,000,000),(34418,33543,0,'2003-02-20 17:10:51','PR','7','RUE','DE LA CHARMILLE',NULL,NULL,'',NULL,NULL,NULL,67610,NULL,'LA WANTZENAU','00000',NULL,'FR',NULL,NULL,'0388966765','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34419,33544,0,'2003-02-20 17:10:51','PR','6','RUE','DU VIVIER',NULL,NULL,'',NULL,NULL,NULL,42160,NULL,'ANDREZIEUX BOUTHEON','00000',NULL,'FR',NULL,NULL,'0477367900','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34420,33545,0,'2003-02-20 17:10:51','PR',NULL,'SANS','LA BOURGEE FROIDE',NULL,NULL,'',NULL,NULL,NULL,42330,NULL,'CUZIEU','00000',NULL,'FR',NULL,NULL,'0477548887','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34421,33546,0,'2003-02-20 17:10:51','PR','41','RUE','DES TOURNELLES',NULL,NULL,'',NULL,NULL,NULL,75003,NULL,'PARIS','00000',NULL,'FR',NULL,NULL,'0142746246','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34422,33547,0,'2003-02-20 17:10:51','PR','75','BOU','SOULT',NULL,NULL,'',NULL,NULL,NULL,75015,NULL,'PARIS','00000',NULL,'FR',NULL,NULL,'0143454609','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34423,33548,0,'2003-02-20 17:10:51','PR','237','RUE','CLAUDEUS SAVOYE',NULL,NULL,'',NULL,NULL,NULL,69400,NULL,'VILLEFRANCHE SUR SAONE','00000',NULL,'FR',NULL,NULL,'0474681829','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34424,33549,0,'2004-03-23 13:14:59','PR','41','RUE','BRESSIGNY',NULL,NULL,'',NULL,NULL,NULL,49100,NULL,'ANGERS','00000',NULL,'FR','[email protected]',NULL,'0241733709','','0660695821',NULL,NULL,NULL,NULL,'TM',000,000),(34425,33550,0,'2003-02-20 17:10:51','PR',NULL,'HAM','LES VIGNES',NULL,NULL,'B.18',NULL,NULL,NULL,05200,NULL,'EMBRUN','00000',NULL,'FR',NULL,NULL,'0615204123','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34426,33551,0,'2003-02-20 17:10:51','PR',NULL,'SANS','LACOST',NULL,NULL,'',NULL,NULL,NULL,63520,NULL,'DOMAIZE','00000',NULL,'FR',NULL,NULL,'0473707177','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34427,33552,0,'2003-02-20 17:10:51','PR','44','ROU','DES SANGUINIERES',NULL,NULL,'',NULL,NULL,NULL,79230,NULL,'FORS','00000',NULL,'FR',NULL,NULL,'0549326391','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34428,33553,0,'2008-02-19 11:47:05','PR',NULL,'SANS','SAUVIAT',NULL,NULL,'',NULL,NULL,NULL,19510,NULL,'MEILHARDS','00000',NULL,'FR',NULL,NULL,'','','0613371278',NULL,NULL,NULL,NULL,'TM',000,000),(34429,33554,0,'2003-02-20 17:10:51','PR',NULL,'SANS','LA BUSSIERE ST SULPICE',NULL,NULL,'',NULL,NULL,NULL,23000,NULL,'GUERET','00000',NULL,'FR',NULL,NULL,'0555510404','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34430,33555,0,'2003-02-20 17:10:51','PR','154','RUE','DELEUZE',NULL,NULL,'',NULL,NULL,NULL,04200,NULL,'SISTERON','00000',NULL,'FR',NULL,NULL,'0492611407','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34431,33556,0,'2003-02-20 17:10:51','PR',NULL,'SANS','RESIDENCE D ENTRAIS 226',NULL,NULL,'',NULL,NULL,NULL,05000,NULL,'GAP','00000',NULL,'FR',NULL,NULL,'0492521095','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34432,33557,0,'2003-02-20 17:10:51','PR',NULL,'AVE','JEAN DES FIGUES',NULL,NULL,'LES ROMARINS',NULL,NULL,NULL,04200,NULL,'SISTERON','00000',NULL,'FR',NULL,NULL,'0492611347','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34433,33558,0,'2003-02-20 17:10:51','PR','72','CHE','DU PLAN DE LEYDET',NULL,NULL,'',NULL,NULL,NULL,04200,NULL,'SISTERON','00000',NULL,'FR',NULL,NULL,'0492613528','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34434,33559,0,'2015-01-29 19:36:41','PR','','AAA','LOT LA GAGERIE','','','',NULL,NULL,NULL,04400,'','LES THUILES','04220',NULL,'FR','[email protected]',NULL,'0492819090','','0616139004',NULL,'',NULL,'',NULL,000,000),(34435,33560,0,'2010-03-04 18:50:45','PR','72','SANS','BD CHARLES KADDOUZ',NULL,NULL,'',NULL,NULL,NULL,13012,NULL,'MARSEILLE 12','00000',NULL,'FR','[email protected]',NULL,'','','0603104338',NULL,NULL,NULL,NULL,'TM',000,000),(34436,33561,0,'2003-02-20 17:10:51','PR','13','RUE','MODIGLIANI D',NULL,NULL,'',NULL,NULL,NULL,06800,NULL,'CAGNES SUR MER','00000',NULL,'FR',NULL,NULL,'0493983208','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34437,33573,0,'2003-02-20 17:10:51','PR','4','RUE','ABEL DURAND',NULL,NULL,'',NULL,NULL,NULL,44360,NULL,'ST ETIENNE DE MONT LUC','00000',NULL,'FR',NULL,NULL,'0240869563','',NULL,NULL,NULL,NULL,NULL,'TM',000,000),(34438,33577,0,'2023-04-23 18:13:11','PR','','AAA','VERMONT','','','131 IMPASSE DU PUITS',NULL,NULL,NULL,69910,'','VILLIE-MORGON','69267',NULL,'FR','[email protected]',NULL,'0474691667','','0664228156',NULL,NULL,NULL,NULL,NULL,000,000),308',NULL,'FR','[email protected]',NULL,'','','0643628688',NULL,NULL,NULL,NULL,NULL,000,000)
Personnes (462912) :
(82089,'2001-03-26 12:18:00','2003-02-20 17:07:05','P','Mme','DAGNAUD','LAURENCE','F','1973-01-18',NULL,'FR','250',0,0,NULL,NULL,'N','','A',NULL,NULL,NULL,NULL,NULL,'N',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'N',NULL),(82090,'2001-03-26 12:18:00','2024-01-06 06:59:07','P','M','DESIRE','YANNIS','M','1977-02-11','SAINT DENIS','FR','638',0,0,'DESIRE',NULL,'N','','A',NULL,NULL,NULL,NULL,'','O','2024-01-06 06:59:07',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','O',NULL,'100','SAINT DENIS','97411','N',NULL),(82091,'2001-03-26 12:24:00','2003-02-20 17:07:05','P','M','SERY','JULIEN','M','1981-10-28',NULL,'FR','250',0,0,'SERY',NULL,'N','','A',NULL,NULL,NULL,NULL,NULL,'N',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'N',NULL),(82092,'2001-03-26 12:24:00','2024-01-25 09:23:01','P','Mme','FOURNIER','CORINNE','F','1971-05-30','..','FR','250',0,0,'FOURNIER',
The table "Personnes" contain 462912 rows.
(82089,'2001-03-26 12:18:00','2003-02-20 17:07:05','P','Mme','DAGNAUD','LAURENCE','F','1973-01-18',NULL,'FR','250',0,0,NULL,NULL,'N','','A',NULL,NULL,NULL,NULL,NULL,'N',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'N',NULL),(82090,'2001-03-26 12:18:00','2024-01-06 06:59:07','P','M','DESIRE','YANNIS','M','1977-02-11','SAINT DENIS','FR','638',0,0,'DESIRE',NULL,'N','','A',NULL,NULL,NULL,NULL,'','O','2024-01-06 06:59:07',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','O',NULL,'100','SAINT DENIS','97411','N',NULL),(82091,'2001-03-26 12:24:00','2003-02-20 17:07:05','P','M','SERY','JULIEN','M','1981-10-28',NULL,'FR','250',0,0,'SERY',NULL,'N','','A',NULL,NULL,NULL,NULL,NULL,'N',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'N',NULL),(82092,'2001-03-26 12:24:00','2024-01-25 09:23:01','P','Mme','FOURNIER','CORINNE','F','1971-05-30','..','FR','250',0,0,'FOURNIER',
The table "CompteLicencie" contain 106422 rows.
INSERT INTO `CompteLicencie` VALUES ('065274',65274,'cBaX2rZaV5Mz9Ce/0gBtQvOjuPia3sE86hfmhRcGlUPPDaKHz6ebpWw1BnOdb6mLrARjwa+IW9Es+ijT4BK4fw8Edrthk0ikclEDil9J6xJNJX1mPuRXDU+89khQqeMs','9345954f9cd7b0df61341fbed3f5467f9213bb626b6d6cc6d640df4f5f8df004d67ce398afbfe45ae4c2d628545d78597d778f94968e97957450e41591535ed6',NULL,'$1$iKFgew8n$NX4YtN6fq8LLFviYbHsOU1','2021-01-10 19:50:44','0000-00-00 00:00:00'),('065301',65301,'98m+r2Ph+OMYow/KMmhGy2lgdZKM2+Y61uMvLnV1OeTe3Yg+5Km6BuUgvmCl6k8ov4ijvpxGwwTRBzR5/lmt37wZS2Oin99i9il+Oq8m/LzrQzvBJjOYWZhRRgQAVwn0','e4d6805f1eaefcab23a11778fbb408d533f86732ac3f8d79de8ba938e9f667021a8d5dea8b465605a6a5e63eb36923445932cece1b8aec70179e7b250426c95d','','$1$iYpz5JWq$LEfLPFVoIB5ErUjLZlF2Q/','2017-04-12 13:54:34','2017-04-12 13:54:34'),
('065340',65340,'6sUDf4zTVEXr3W+5FvWXWyt6xYNILgUJ2SRkAuFih0ybaer/D59W8PciVDAIi6yfk9AefS7HnnvnZKccBGXb4PdCQGH+PLT4IdvpjB9mKPYR86+/idk+7LClOuSbOdTu','f61d549f631cb612a8a4607ea2ed93187c865c8a23fb08871f6285eda0cadbfb7c77dc6d5260f59cb327ef7b00ae18f9d9c7a8dccddfe4b5871d7a64b615a767',NULL,'$1$3BK6beC.$BFg3xYQRiEFEkO042z2Av0','2023-01-09 16:17:58','2024-01-31 10:16:47'),('065341',65341,'EjcVSZC0FH9uKSumWlfCqCk8JObJAxt+km8jdtSkGg+XS5m7HjEvs/fzjvXpm8aMcJ4vvrLoFzlsUNy76SAEYN7NelT2Z11U0LVOPdKbs6f0mJ6966qqgCUnvP1eFBfL','436138c46c2be5a693e88816b3b5e9ee1336283dc56361204dc8d9d6026694d6da103f6cf01712fcbbee8995b0d41d968d919e060018aaa01793bbcc64a62bd8',NULL,'$1$S/zFvYAb$dMg24e74uVPO3RHJHZ0tv.','2023-06-05 19:17:55','2023-06-05 19:17:55'),
The table "PanierCmdElectroniques_retourbqe" contain 250501 rows.
INSERT INTO `PanierCmdElectroniques_retourbqe` VALUES (227549,'2024-11-30 21:59:04',1020368,'00',1,'{\"vads_tid\": \"001\", \"signature\": \"1e1c1b457cd84b08db62b86a33d110d8241916fe\", \"vads_hash\": \"7b4888d222dfab1696cc3fd6747ee0117102d825a8ea180795a16afe6b592922\", \"vads_amount\": \"2300\", \"vads_result\": \"00\", \"vads_cust_id\": \"487093\", \"vads_pays_ip\": \"FR\", \"vads_site_id\": \"53442100\", \"vads_version\": \"V2\", \"vads_ctx_mode\": \"PRODUCTION\", \"vads_currency\": \"978\", \"vads_language\": \"fr\", \"vads_order_id\": \"pass-487093-24063341020368\", \"vads_trans_id\": \"232518\", \"vads_auth_mode\": \"FULL\", \"vads_bank_code\": \"10096\", \"vads_cust_name\": \"TOM ROCHET CAPELLAN\", \"vads_bank_label\": \"Lyonnaise de banque L.B.\", \"vads_card_brand\": \"CB\", \"vads_cust_email\": \"[email protected]\", \"vads_trans_date\": \"20241130205557\", \"vads_trans_uuid\": \"d11ad46c0fd34d0b9ce0c6feb75612f1\", \"vads_action_mode\": \"INTERACTIVE\", \"vads_auth_number\": \"851458\", \"vads_auth_result\": \"00\", \"vads_card_nature\": \"CONSUMER\", \"vads_card_number\": \"497946XXXXXX9692\", \"vads_cust_status\": \"PRIVATE\", \"vads_expiry_year\": \"2025\", \"vads_page_action\": \"PAYMENT\", \"vads_payment_src\": \"EC\", \"vads_threeds_eci\": \"05\", \"vads_threeds_xid\": \"\", \"vads_bank_product\": \"P\", \"vads_card_country\": \"FR\", \"vads_expiry_month\": \"10\", \"vads_extra_result\": \"00\", \"vads_risk_control\": \"SUSPECT_IP_COUNTRY=OK\", \"vads_threeds_cavv\": \"A**************************=\", \"vads_trans_status\": \"AUTHORISED\", \"vads_capture_delay\": \"0\", \"vads_contract_used\": \"7295183\", \"vads_url_check_src\": \"PAY\", \"vads_cust_last_name\": \"ROCHET CAPELLAN\", \"vads_operation_type\": \"DEBIT\", \"vads_payment_config\": \"SINGLE\", \"vads_threeds_status\": \"Y\", \"vads_cust_first_name\": \"TOM\", \"vads_cust_legal_name\": \"\", \"vads_occurrence_type\": \"UNITAIRE\", \"vads_sequence_number\": \"1\", \"vads_validation_mode\": \"0\", \"vads_warranty_result\": \"YES\", \"vads_acquirer_network\": \"CB\", \"vads_brand_management\": \"{\\\"userChoice\\\":false,\\\"brandList\\\":\\\"CB|VISA\\\",\\\"brand\\\":\\\"CB\\\"}\", \"vads_effective_amount\": \"2300\", \"vads_threeds_enrolled\": \"Y\", \"vads_presentation_date\": \"20241130205613\", \"vads_threeds_auth_type\": \"CHALLENGE\", \"vads_effective_currency\": \"978\", \"vads_threeds_error_code\": \"\", \"vads_threeds_sign_valid\": \"\", \"vads_payment_certificate\": \"b65a7723a52a0bebc0179af8e4fc841f18edb967\", \"vads_threeds_exit_status\": \"10\", \"vads_archival_reference_id\": \"L33523251801\", \"vads_card_product_category\": \"DEBIT\", \"vads_threeds_cavvAlgorithm\": \"\", \"vads_cardholder_card_number\": \"497946XXXXXX9692\", \"vads_effective_creation_date\": \"20241130205613\", \"vads_threeds_user_interaction\": \"\", \"vads_cardholder_card_expiry_year\": \"2025\", \"vads_cardholder_card_expiry_month\": \"10\", \"vads_initial_issuer_transaction_identifier\": \"1I5674BFFB7B43C2\"}','{\"Email\": \"[email protected]\", \"Extra\": null, \"Status\": null, \"Context\": null, \"Montant\": \"2300\", \"OrderId\": \"pass-487093-24063341020368\", \"LastName\": null, \"FirstName\": null, \"LegalName\": null, \"UrlCancel\": null, \"UrlSucces\": null, \"PersonneId\": null, \"ReferenceId\": null, \"MessageErreur\": null, \"TransactionId\": \"232518\", \"UrlRetourTransparent\": null}','Bqe\\Paiement\\Licence1MFInter','/actions/current/paiementApiEPaiment1MFInter_cb.php'),(227550,'2024-11-30 22:00:42',1020373,'00',1,'{\"vads_tid\": \"001\", \"signature\": \"ca3769808ecf71a6ce18ef2ed4f44c7b3b094340\", \"vads_hash\": \"bac52f79aef94eedffaf11a029805471f6b338db91a5828f6fe70c8cec606fbc\", \"vads_amount\": \"4500\", \"vads_result\": \"00\", \"vads_cust_id\": \"470680\", \"vads_pays_ip\": \"FR\", \"vads_site_id\": \"53442100\", \"vads_version\": \"V2\", \"vads_ctx_mode\": \"PRODUCTION\", \"vads_currency\": \"978\", \"vads_language\": \"fr\", \"vads_order_id\": \"pass-470680-24063341020373\", \"vads_trans_id\": \"232524\", \"vads_auth_mode\": \"FULL\", \"vads_bank_code\": \"18706\", \"vads_cust_name\": \"DYLAN DUVIVIER\", \"vads_bank_label\": \"Caisse régionale de crédit agricole mutuel Brie Picardie\", \"vads_card_brand\": \"CB\", \"vads_cust_email\": \"[email protected]\", \"vads_trans_date\": \"20241130205907\", \"vads_trans_uuid\": \"0215d1f2394a4119a0a89093c9b488b1\", \"vads_action_mode\": \"INTERACTIVE\", \"vads_auth_number\": \"551541\", \"vads_auth_result\": \"00\", \"vads_card_nature\": \"CONSUMER\", \"vads_card_number\": \"513771XXXXXX4968\", \"vads_cust_status\": \"PRIVATE\",
