Hello, Today i'm selling the database (full sql dump not scrap) of the Féderation Française de Boxe.
Offer a price in PM.
Only MM
Sample :
The table "__importLicencies" contain 529000 rows.
INSERT INTO `__importLicencies` VALUES ('P0001532','2022/2023','M.',NULL,'ARNAUD','RUFFINE','11/10/2004','france','paris','75012','3 - ALLEE DES GOYAVIERS\nLOT PULCHERY','97229','97','LES TROISILETS','FRANCE',NULL,NULL,NULL,NULL,'06.96.18.05.38',NULL,'[email protected]',NULL,NULL,'FRA','Non',NULL,NULL,NULL,NULL,NULL,NULL,'15/01/2023','01/02/2023
('A0052878','2022/2023','M.',NULL,'ETHAN','BADIN','20/10/2010','FRANCE','BOURGOIN-JALLIEU','38300','145 CHEMIN DU MARAIS','38510','38','COURTENAY','FRANCE',NULL,NULL,NULL,NULL,'06.65.50.24.85',NULL,'[email protected]',NULL,NULL,'FRANCE','Non',NULL,NULL,NULL,NULL,NULL,NULL,'18/10/2022',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL),('K0046999','2022/2023','M.',NULL,'MOUAD','EL MHAMSSI','02/06/2017','FRANCE','TOULOUSE','31100','4 RUE DU ROUSSILLON','31100','31','TOULOUSE','FRANCE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRANCE','Non',NULL,NULL,NULL,NULL,NULL,NULL,'25/10/2022',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL),('K0047000','2022/2023','M.',NULL,'LOUAY','ESSAMHI','28/03/2016','FRANCE','TOULOUSE','31100','3 RUE DU BEARN','31100','31','TOULOUSE','FRANCE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRANCE','Non',NULL,NULL,NULL,NULL,NULL,NULL,'18/12/2022',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL),('I0022369','2022/2023','M.',NULL,'CORENTIN','DUWEL','10/02/1990','FRANCE','BOULOGNE SUR MER','62200','11 RUE DES MOULINS','50630','50','LE VAST','FRANCE',NULL,NULL,NULL,NULL,'06.78.13.20.45',NULL,NULL,NULL,NULL,'FRA','Non',NULL,NULL,NULL,NULL,NULL,NULL,'26/01/2023','23/01/2023',NULL,NULL,NULL,NULL,NULL,'27/12/2022','06/12/2022',NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL),('H0077451','2022/2023','M.',NULL,'SHARONE','ALEKIC','04/10/2009','FRANCE','BONDY','93','16 RUE DES ARDENNES PAVICON','93190','93','LIVRY GARGAN','FRANCE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRA','Non',NULL,NULL,NULL,NULL,NULL,NULL,'07/02/2023',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL),('J0051391','2022/2023','M.',NULL,'BILALL','LAYACHI','15/11/2008','FRANCE','POITIERS','86000','16 PLACE PHILLIPE LE HARDY','86340','86','NOUAILLE MAUPERTUIS','FRANCE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRANCE','Non',NULL,NULL,NULL,NULL,NULL,NULL,'07/10/2022',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL),('H0077452','2022/2023','M.',NULL,'XAVIER','DUPONT','05/10/1987','FRANCE','NOGENT SUR MARNE','94130','146 AVENUE DE VERDUN','92130','92','ISSY LÈS MOULINEAUX','FRANCE',NULL,NULL,NULL,NULL,'06.13.15.35.05',NULL,'[email protected]',NULL,NULL,'FRANCE','Non',NULL,NULL,NULL,NULL,NULL,NULL,'02/02/2023',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL),('A0052882','2022/2023','M.',NULL,'ROMAIN','CLERC','06/04/2005','FRANCE','CHAMBÉRY','73','15 CHEMIN DE VIBORGNE','73100','73','AIX LES BAINS','FRANCE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRANCE','Non',NULL,NULL,NULL,NULL,NULL,NULL,'06/02/2023',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL),('H0077453','2022/2023','M.',NULL,'GUILLAUME','ROUHAUD','10/02/2004','FRANCE','PARIS 14E ARRONDISSEMENT','75014','41 RUE CARVES','92120','92','MONTROUGE','FRANCE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRANCE','Non',NULL,NULL,NULL,NULL,NULL,NULL,'04/02/2023',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL),('A0052884','2022/2023','M.',NULL,'KAIS','HARFI','16/04/2014','FRANCE','VIENNE','38200','23 RUE TONY GARNIER','38200','38','VIENNE','FRANCE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRANCE','Non',NULL,NULL,NULL,NULL,NULL,NULL,'03/12/2022',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL),('B0020159','2022/2023','M.',NULL,'JORIS','CESARIO','18/12/2004','FRANCE','LONS-LE-SAUNIER','39000','4 ROUTE DE LA GRÈVE','71580','71','FLACEY EN BRESSE','FRANCE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRANCE','Non',NULL,NULL,NULL,NULL,NULL,NULL,'26/09/2022',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL),('F0042121','2022/2023','MME','THEET','VERONIQUE','BORCA','22/04/1957','FRANCE','NEUILLY-SUR-SEINE','92000','17 RUE MARCEL FAY','08090','8','TOURNES','FRANCE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRANCE','Non',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL)
The table "adresses" contain 603978 rows.
INSERT INTO `adresses` VALUES (15611,'2023-09-02 23:15:09','2023-09-02 23:15:09',13259,NULL,'PR',NULL,NULL,'SQUARE VAILLANT - 4 RUE ED',NULL,NULL,NULL,'94000',NULL,'ALFORTVILLE','94002','11','94','FR',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15612,'2023-09-02 23:15:09','2023-09-02 23:15:09',13260,NULL,'PR',NULL,NULL,'24 RUE SIMONE SIGNORET',NULL,NULL,NULL,'86530',NULL,'NAINTRE','86174','75','86','FR',NULL,NULL,NULL,NULL,NULL,'0785693730',NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL)
(15665,'2023-09-02 23:15:09','2023-09-02 23:15:09',13313,NULL,'PR',NULL,NULL,'LA GARE',NULL,NULL,NULL,'71800',NULL,'SAINT JULIEN DE CIVRY',NULL,NULL,NULL,'FR',NULL,NULL,'0385706437',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15666,'2023-09-02 23:15:09','2023-09-02 23:15:09',13314,NULL,'PR',NULL,NULL,'192 AVENUE DE DUN',NULL,NULL,NULL,'18000',NULL,'BOURGES','18033','24','18','FR',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15667,'2023-09-02 23:15:09','2023-09-02 23:15:09',13315,NULL,'PR',NULL,NULL,'31 AVENUEDEBERNARDI',NULL,NULL,NULL,'52000',NULL,'CHAUMONT','18060','24','18','FR',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15668,'2023-09-02 23:15:09','2023-09-02 23:15:09',13316,NULL,'PR',NULL,NULL,'3 RUE SAINT EXUPERY',NULL,NULL,NULL,'69600',NULL,'OULLINS','69149','84','69','FR',NULL,NULL,'0660940353',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15669,'2023-09-02 23:15:09','2023-09-02 23:15:09',13317,NULL,'PR',NULL,NULL,'64 ALLEE FANNY DEERPE',NULL,NULL,NULL,'93100',NULL,'MONTREUIL','28267','24','28','FR',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15670,'2023-09-02 23:15:09','2023-09-02 23:15:09',13318,NULL,'PR',NULL,NULL,'14 CHEMIN DU COTEAU',NULL,NULL,NULL,'24470',NULL,'SAINT PARDOUX LA RIVIÈRE',NULL,NULL,NULL,'FR','[email protected]',NULL,NULL,NULL,NULL,'0646441760',NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15671,'2023-09-02 23:15:09','2023-09-02 23:15:09',13319,NULL,'PR',NULL,NULL,'2 BIS RUE CHEVRIER',NULL,NULL,NULL,'41100',NULL,'VENDOME','41269','24','41','FR',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15672,'2023-09-02 23:15:09','2023-09-02 23:15:09',13320,NULL,'PR',NULL,NULL,'13 RUE CLAUDE DEBUSSY',NULL,NULL,NULL,'28500',NULL,'VERNOUILLET','28404','24','28','FR',NULL,NULL,NULL,NULL,NULL,'0621222152',NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15673,'2023-09-02 23:15:09','2023-09-02 23:15:09',13321,NULL,'PR',NULL,NULL,'46 RUE ANDRE LETHUILLIER',NULL,NULL,NULL,'27000',NULL,'EVREUX','27229','28','27','FR',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15674,'2023-09-02 23:15:09','2023-09-02 23:15:09',13322,NULL,'PR',NULL,NULL,'18 LES CHENES DE JONAS\n696 ROUTE DE JONAS',NULL,NULL,NULL,'83500',NULL,'LA SEYNE SUR MER',NULL,NULL,NULL,'FR',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15675,'2023-09-02 23:15:09','2023-09-02 23:15:09',13323,NULL,'PR',NULL,NULL,'LOT LES CHENES DE JANAS VILLA 18\n696 ROUTE DE JANAS',NULL,NULL,NULL,'83500',NULL,'LA SEYNE SUR MER',NULL,NULL,NULL,'FR',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15676,'2023-09-02 23:15:09','2023-09-02 23:15:09',13324,NULL,'PR',NULL,NULL,'14 RUE NATIONALE',NULL,NULL,NULL,'56420',NULL,'GUEHENNO','56071','53','56','FR',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15677,'2023-09-02 23:15:09','2023-09-02 23:15:09',13325,NULL,'PR',NULL,NULL,'58 RUE JOSEPH LE SCIELLOUR',NULL,NULL,NULL,'49800',NULL,'TRÉLAZE','49353','52','49','FR','[email protected]',NULL,NULL,NULL,NULL,'0677013489',NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15678,'2023-09-02 23:15:09','2023-09-02 23:15:09',13326,NULL,'PR',NULL,NULL,'67 RUE PAUL DOUMER',NULL,NULL,NULL,'78540',NULL,'VERNOUILLET','28404','24','28','FR',NULL,NULL,NULL,NULL,NULL,'0661270776',NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15679,'2023-09-02 23:15:09','2023-09-02 23:15:09',13327,NULL,'PR',NULL,NULL,'126 RUE DU GNRAL DE GAULLE',NULL,NULL,NULL
The table "commandes_lignes" contain 444013 rows.
INSERT INTO `commandes_lignes` VALUES (100081,'2023-10-21 13:32:13','2024-05-10 05:09:31',25362,'PRC','Assurance RC BEAL (Boxe Educative Assaut Loisir) 2024 - M DEVLIEGER Johan',5,NULL,1.76,'ELicence\\Core\\Models\\Licence',980351,254461,0,NULL,'PRC','{\"mouvement_code\":\"PRC\",\"licence_id\":980351,\"personne_id\":164805,\"compta_id\":228,\"structure_id\":228,\"libelle\":\"Assurance RC BEAL (Boxe Educative Assaut Loisir) 2024 - M DEVLIEGER Johan\",\"devise\":\"EUR\",\"saison\":2024,\"debit\":1.76}',NULL)
(100084,'2023-10-21 13:32:25','2023-10-21 13:32:25',25363,'LIC','Prise de licence BEAL (Boxe Educative Assaut Loisir) 2024 - M EZZINE Aymen',4,NULL,22.75,'ELicence\\Core\\Models\\Licence',980352,100291,0,NULL,'LIC','{\"mouvement_code\":\"LIC\",\"licence_id\":980352,\"personne_id\":546196,\"compta_id\":372,\"structure_id\":372,\"libelle\":\"Prise de licence BEAL (Boxe Educative Assaut Loisir) 2024 - M EZZINE Aymen\",\"devise\":\"EUR\",\"saison\":2024,\"debit\":22.75}',NULL),(100085,'2023-10-21 13:32:25','2023-10-21 13:32:25',25363,'PRC','Assurance RC BEAL (Boxe Educative Assaut Loisir) 2024 - M EZZINE Aymen',4,NULL,1.76,'ELicence\\Core\\Models\\Licence',980352,100292,0,NULL,'PRC','{\"mouvement_code\":\"PRC\",\"licence_id\":980352,\"personne_id\":546196,\"compta_id\":372,\"structure_id\":372,\"libelle\":\"Assurance RC BEAL (Boxe Educative Assaut Loisir) 2024 - M EZZINE Aymen\",\"devise\":\"EUR\",\"saison\":2024,\"debit\":1.76}',NULL),(100086,'2023-10-21 13:32:25','2023-10-21 13:32:25',25363,'PIA','Assurance IA BEAL (Boxe Educative Assaut Loisir)
The table "commandes_paiements_logs" contain 3120 rows.
INSERT INTO `commandes_paiements_logs` VALUES (1442,'2024-01-29 10:44:36','2024-01-29 10:44:36','20240129104329','00','44126','003126','[52431, 52435, 52442, 52450]','144','194.50.38.6','Lyra-Network Agent','POST','3390f82fc00c4ea7b7fb6cb8ce45ca51','{\"vads_tid\": \"001\", \"signature\": \"76074f11e7f49f09f12a9cab36764231d90e3f09\", \"vads_hash\": \"6f8e34c9466421010a2dd00a2acf5fe03eb4820b2f60359cc20f9bffcc56abb2\", \"vads_amount\": \"14400\", \"vads_result\": \"00\", \"vads_cust_id\": \"01104\", \"vads_pays_ip\": \"FR\", \"vads_site_id\": \"37077950\", \"vads_version\": \"V2\", \"vads_ctx_mode\": \"PRODUCTION\", \"vads_currency\": \"978\", \"vads_language\": \"fr\", \"vads_order_id\": \"44126\", \"vads_trans_id\": \"003126\", \"vads_auth_mode\": \"FULL\", \"vads_bank_code\": \"15589\", \"vads_cust_name\": \"Bernard SANROMA\", \"vads_bank_label\": \"Crédit Mutuel Arkéa\", \"vads_card_brand\": \"E-CARTEBLEUE\", \"vads_cust_email\": \"[email protected]\", \"vads_trans_date\": \"20240129104329\", \"vads_trans_uuid\": \"3390f82fc00c4ea7b7fb6cb8ce45ca51\", \"vads_action_mode\": \"INTERACTIVE\", \"vads_auth_number\": \"597967\", \"vads_auth_result\": \"00\", \"vads_card_nature\": \"BUSINESS\", \"vads_card_number\": \"513489XXXXXX1222\", \"vads_cust_status\": \"COMPANY\", \"vads_expiry_year\": \"2024\", \"vads_page_action\": \"PAYMENT\", \"vads_payment_src\": \"EC\", \"vads_threeds_eci\": \"02\", \"vads_threeds_xid\": null, \"vads_bank_product\": \"MCB\", \"vads_card_country\": \"FR\", \"vads_expiry_month\": \"2\", \"vads_extra_result\": null, \"vads_threeds_cavv\": \"A**************************=\", \"vads_trans_status\": \"AUTHORISED\", \"vads_capture_delay\": \"0\", \"vads_contract_used\": \"3011345\", \"vads_url_check_src\": \"PAY\", \"vads_cust_last_name\": \"SANROMA\", \"vads_operation_type\": \"DEBIT\", \"vads_payment_config\": \"SINGLE\", \"vads_threeds_status\": \"Y\", \"vads_cust_first_name\": \"Bernard\", \"vads_cust_legal_name\": \"SPORT ATHLETIQUE MERIGNACAIS\", \"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\\\":\\\"E-CARTEBLEUE|MASTERCARD\\\",\\\"brand\\\":\\\"E-CARTEBLEUE\\\"}\", \"vads_effective_amount\": \"14400\", \"vads_threeds_enrolled\": \"Y\", \"vads_presentation_date\": \"20240129104329\", \"vads_threeds_auth_type\": \"CHALLENGE\", \"vads_effective_currency\": \"978\", \"vads_threeds_error_code\": null, \"vads_threeds_sign_valid\": null, \"vads_payment_certificate\": \"99e25dfd5f67ab03269126e403380253cbc21d65\", \"vads_threeds_exit_status\": \"10\", \"vads_archival_reference_id\": \"L02900312601\", \"vads_card_product_category\": \"DEBIT\", \"vads_threeds_cavvAlgorithm\": null, \"vads_effective_creation_date\": \"20240129104329\", \"vads_threeds_user_interaction\": null, \"vads_initial_issuer_transaction_identifier\": \"1RCB402975756278\"}')
The table "personnes" contain 620264 rows.
INSERT INTO `personnes` VALUES (75777,'2023-09-02 23:15:09','2023-09-02 23:15:09','075777','G0016888','A','M','BORDJI','Yacin','M','2003-12-24',NULL,NULL,NULL,NULL,'FR',NULL,'FR',0,NULL,1,'2023-09-03 01:15:09',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,1,1,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL)
(75781,'2023-09-02 23:15:09','2023-09-02 23:15:09','075781','F0031847','A','M','BORDJY','Alexis','M','1997-02-27',NULL,NULL,NULL,NULL,'FR',NULL,'FR',0,NULL,1,'2023-09-03 01:15:09',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,1,1,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(75782,'2023-09-02 23:15:09','2023-09-02 23:15:09','075782','A0018427','A','M','BORDNER','Sofiane','M','1996-07-07',NULL,NULL,NULL,NULL,'FR',NULL,'FR',0,NULL,1,'2023-09-03 01:15:09',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,1,1,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(75783,'2023-09-02 23:15:09','2023-09-02 23:15:09','075783','H0034774','A','M','BORDO','Adam','M','1998-10-12',NULL,NULL,NULL,NULL,'FR',NULL,'FR',0,NULL,1,'2023-09-03 01:15:09',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,1,1,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(75784,'2023-09-02 23:15:09','2023-09-02 23:15:09','075784','G0014823','A','M','BORDO','Zahcen','M','1997-02-27',NULL,NULL,NULL,NULL,'FR',NULL,'FR',0,NULL,1,'2023-09-03 01:15:09',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,1,1,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(75785,'2023-09-02 23:15:09','2023-09-02 23:15:09','075785','K0037451','A','Mme','BORDOLL','Ines','F','2004-09-11',NULL,NULL,NULL,NULL,'FR',NULL,'FR',0,NULL,1,'2023-09-03 01:15:09',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,1,1,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(75786,'2023-09-02 23:15:09','2023-09-02 23:15:09','075786','J0032638','A','M','BORDON','Clement','M','2006-02-01',NULL,NULL,NULL,NULL,'FR',NULL,'FR',0,NULL,1,'2023-09-03 01:15:09',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,1,1,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(75787,'2023-09-02 23:15:09','2023-09-02 23:15:09','075787','C0009012','A','M','BORDON','Justin','M','1998-09-12',NULL,NULL,NULL,NULL,'FR',NULL,'FR',0,NULL,1,'2023-09-03 01:15:09',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,1,1,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(75788,'2023-09-02 23:15:09','2023-09-02 23:15:09','075788','H0040205','A','M','BORDON','Paul','M','2000-11-15',NULL,NULL,NULL,NULL,'FR',NULL,'FR',0,NULL,1,'2023-09-03 01:15:09',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,1,1,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(75789,'2023-09-02 23:15:09','2023-09-02 23:15:09','
The table "personnes_representants_legaux" contain 112053 rows.
INSERT INTO `personnes_representants_legaux` VALUES (15452,9081,NULL,NULL,NULL,NULL,NULL,'SEC'),(15453,538324,'Moebs','Sophie','0633310022','[email protected]',NULL,'PRI'),(15454,538324,NULL,NULL,NULL,NULL,NULL,'SEC'),(15455,538325,'MUNOZ','LAETITIA','0624030364','[email protected]',NULL,'PRI'),(15456,538325,NULL,NULL,NULL,NULL,NULL,'SEC'),(15457,141446,'D\'HOOGE','Cédric','0672032046','[email protected]',NULL,'PRI'),(15458,141446,NULL,NULL,NULL,NULL,NULL,'SEC'),(15459,410162,'PELLAN','Karine','0615755125','[email protected]',NULL,'PRI'),(15460,410162,NULL,NULL,NULL,NULL,NULL,'SEC'),(15461,9082,'Airapov','Artem','0760901468','[email protected]',NULL,'PRI'),(15462,9082,NULL,NULL,NULL,NULL,NULL,'SEC'),(15463,538330,'HASSINE','WAFA','0749508280','[email protected]',NULL,'PRI'),(15464,538330,NULL,NULL,NULL,NULL,NULL,'SEC'),(15465,538331,'Arbareri','Joël','0633576141','[email protected]',NULL,'PRI'),(15466,538331,NULL,NULL,NULL,NULL,NULL,'SEC'),(15467,538332,'ROUBIN','Céline','0660951461','[email protected]',NULL,'PRI'),(15468,538332,NULL,NULL,NULL,NULL,NULL,'SEC'),(15469,538334,'HOUSSEINE','AICHA','0772186961','[email protected]',NULL,'PRI'),
(15534,538355,NULL,NULL,NULL,NULL,NULL,'SEC'),(15535,538356,'Sabourdy','Valérie','0783607354','[email protected]',NULL,'PRI'),(15536,538356,NULL,NULL,NULL,NULL,NULL,'SEC'),(15537,320594,'RADE','MAGALI','06/81/40/10/78','[email protected]',NULL,'PRI'),(15538,320594,NULL,NULL,NULL,NULL,NULL,'SEC'),(15539,538359,'FERRE','SEGOLENE','06/01/29/63/70','[email protected]',NULL,'PRI'),(15540,538359,NULL,NULL,NULL,NULL,NULL,'SEC'),(15541,538360,'PELICO','Fanny','0690420230','[email protected]',NULL,'PRI'),(15542,538360,NULL,NULL,NULL,NULL,NULL,'SEC'),(15543,538361,'BAGOLE','Mélanie','0635363242','[email protected]',NULL,'PRI'),(15544,538361,NULL,NULL,NULL,NULL,NULL,'SEC'),(15545,538362,'BEUZEVILLE','Vincent','0609044293','[email protected]',NULL,'PRI'),(15546,538362,NULL,NULL,NULL,NULL,NULL,'SEC'),(15547,538363,'PONAMA','Gwénaëlle','0782038681','[email protected]',NULL,'PRI'),(15548,538363,NULL,NULL,NULL,NULL,NULL,'SEC'),(15549,538364,'FETTIH','Yaniss','0663115545','[email protected]',NULL,'PRI'),(15550,538364,NULL,NULL,NULL,NULL,NULL,'SEC'),(15551,538365,'GONZALEZ','Ludovic','0661587232','[email protected]',NULL,'PRI'),(15552,538365,NULL,NULL,NULL,NULL,NULL,'SEC'),(15553,248925,'TASTES','VALERIE','0763712928','[email protected]',NULL,'PRI'),(15554,248925,NULL,NULL,NULL,NULL,NULL,'SEC'),(15555,538366,'KALAYCI','Béatrice','0687545445','[email protected]',NULL,'PRI'),(15556,538366,NULL,NULL,NULL,NULL,NULL,'SEC'),(15557,538367,'LILAUD','Axel','0632584518','[email protected]',NULL,'PRI'),(15558,538367,NULL,NULL,NULL,NULL,NULL,'SEC'),(15559,408330,'PAULY','Jonathan','0623337837','[email protected]',NULL,'PRI'),(15560,408330,NULL,NULL,NULL,NULL,NULL,'SEC'),(15561,538368,'MIRANDA','Vanessa','0638200355','[email protected]',NULL,'PRI'),(15562,538368,NULL,NULL,NULL,NULL,NULL,'SEC'),(15563,538370,'ROBERT','AUDREY','0692029278','[email protected]',NULL,'PRI'),(15564,538370,NULL,NULL,NULL,NULL,NULL,'SEC'),(15565,538372,'ENGRAND','NICOLAS','06 75 99 78 08','[email protected]',NULL,'PRI'),(15566,538372,NULL,NULL,NULL,NULL,NULL,'SEC'),(15567,538375,'KEYKLICEK','Alexandrie','0634193414','[email protected]',NULL,'PRI'),(15568,538375,'Alloui','Samir','0606654690',NULL,NULL,'SEC'),(15569,538376,'BACCELLI','Maxime','0660847313','[email protected]',NULL,'PRI'),(15570,538376,'BACCELI','Catherine',NULL,NULL,NULL,'SEC'),(15571,538377,'Vidal','Marie','0677364427','[email protected]',NULL,'PRI'),(15572,538377,NULL,NULL,NULL,NULL,NULL,'SEC'),(15573,538378,'AHAMADA','Jacques','06 26 39 18 71','[email protected]',NULL,'PRI'),(15574,538378,NULL,NULL,NULL,NULL,NULL,'SEC')
The table "users" contain 40737 rows.
INSERT INTO `users` VALUES (14818,'2023-10-16 16:15:34','2023-10-16 16:15:55','258371','$2y$10$8KOoZDOuQ2duR/Cy4ihpUO8WegFCsAfOhKGcHMimcXoaN5MEX9tWG',258371,1,0,NULL),(14819,'2023-10-16 16:16:40','2023-10-16 16:17:10','543742','$2y$10$L8BZMj0k3XxRSm.hQlV.yuPakCmJiqthxmjztNwjHohB.AMj9rpyq',543742,1,0,NULL),(14820,'2023-10-16 16:23:12','2023-10-30 20:21:46','378691','$2y$10$1Xbu9A6dpjmzqmYIsEJ3luYYj6RRxx8qUYVkaGCK.POJLJ.oxIE6i',378691,1,0,NULL)
(14844,'2023-10-16 17:37:06','2024-02-14 18:34:11','262076','$2y$10$FLF/jla.y3.K7My/vzTc7.8CdAdKU5PWic43BueaIwbU4lZpsjRZm',262076,1,0,NULL),(14845,'2023-10-16 17:37:38','2023-10-16 17:37:51','529437','$2y$10$umgtmqdujp1VnBBMZF0CGOW/E40nincCe2CQpnbgI09P0/WHhTfs.',529437,1,0,NULL),(14846,'2023-10-16 17:38:44','2023-10-16 17:39:03','543229','$2y$10$RuZb6CR.O9IbxHXViW4jVugCo8WDvtv5XiX49s52cnkkGPUQ5XB92',543229,1,0,NULL),(14847,'2023-10-16 17:39:07','2023-10-16 17:42:06','543887','$2y$10$EIjvs1lYwh41RJYDu0V/pObT.euaAFaFednGedgxQUqbru5cmUW4m',543887,1,0,NULL),(14848,'2023-10-16 17:48:37','2023-10-16 17:49:22','440234','$2y$10$30uDQYUi1XlP1pw8sEao/.GxmkPWqZ7w9Dvq8jh60ZeYmDMUFO0wW',440234,1,0,NULL),(14849,'2023-10-16 17:49:02','2023-10-16 17:49:20','543731','$2y$10$EZHtyj15s5rwVLyJWf3j3eXzld0Z9vfqZRhCLG1qmyYY0WMBRpI22',543731,1,0,NULL),(14850,'2023-10-16 17:52:34','2023-10-16 17:53:16','542973','$2y$10$ODTmcK2WDYhYSTjQxWdJuemgZ/fwzeRK11TuFscXvGXymdgGcfQLi',542973,1,0,NULL),(14851,'2023-10-16 18:00:26','2023-10-16 18:00:40','532404','$2y$10$9Y1oyMzQrVgesWfFuq8W8Oaknsi8sHx4o51VEy9LbWHV4ag/9cn4a',532404,1,0,NULL),(14852,'2023-10-16 18:01:45','2023-10-16 18:02:10','540081','$2y$10$SQyusQS91svXyfmlGJ4TpuoXZ9TNEFclEi7jYhqKLmMp0KvxdbIpK',540081,1,0,NULL),(14853,'2023-10-16 18:01:57','2023-10-23 15:49:50','088766','$2y$10$H8AI3qx8zENg0pApNHKVquJipCnLF/1Zp9q2vGgUImZZj2Qa0JM9m',88766,1,0,NULL),(14854,'2023-10-16 18:02:29','2023-10-16 18:02:40','540473','$2y$10$03St7CGV5MA1eWE4NxNsiecDq0Uo1q3/hfmSFWTd5dh1RENrN.tza',540473,1,0,NULL),(14855,'2023-10-16 18:06:20','2023-10-16 18:06:30','542228','$2y$10$wvSbMY0spjj1B2gIgCV9huBErDaCkYJIyDcfV52liU.E1L4sykGQe',542228,1,0,NULL),(14856,'2023-10-16 18:07:02','2023-10-16 18:07:11','543899','$2y$10$DQwGyzZwPiyz3c0QW2IvC.X.abQHw2ZtKrxfeJl.Od4yYRDBNZwRy',543899,1,0,NULL),(14857,'2023-10-16 18:09:53','2023-10-16 18:10:30','217147','$2y$10$hDCuKBslURgHNVlZaXc1kuoAt8mgRjvgfxaDSunDGhPZAZq2Y5NK.',217147,1,0,NULL),(14858,'2023-10-16 18:12:50','2023-10-16 18:13:08','355088','$2y$10$R0/StY6MeeKIagwlxSRI4uOe0rRT6XXvCVQ.wtRZxMVx6xRjVs58C',355088,1,0,NULL),(14859,'2023-10-16 18:14:16','2023-10-30 07:57:03','543264','$2y$10$zemySkzhH/zcHsB1ctGQuuA3ie/hIrfYtGTw1Hi6lD95kzECzE7Sy',543264,1,0,NULL),(14860,'2023-10-16 18:16:02','2023-10-16 18:16:10','542730','$2y$10$B9Om4CM0Ftp.VsRP1CwmYeMN.yx.4/OgbMZD.ELINUps49KgIm54i',542730,1,0,NULL),(14861,'2023-10-16 18:16:42','2023-10-16 18:16:50','435164','$2y$10$wapCfMYN70LXnERBueft9usc.L/zxd0GdiNHji0GI0YA/vstlDBDG',435164,1,0,NULL),(14862,'2023-10-16 18:17:38','2023-10-16 18:18:08','543903','$2y$10$VCP2i73766O7aqRmcn8pPevzpI25zcvdXb2Bm1CTXVt1GV7WR3VuW',543903,1,0,NULL)
Offer a price in PM.
Only MM
Sample :
The table "__importLicencies" contain 529000 rows.
INSERT INTO `__importLicencies` VALUES ('P0001532','2022/2023','M.',NULL,'ARNAUD','RUFFINE','11/10/2004','france','paris','75012','3 - ALLEE DES GOYAVIERS\nLOT PULCHERY','97229','97','LES TROISILETS','FRANCE',NULL,NULL,NULL,NULL,'06.96.18.05.38',NULL,'[email protected]',NULL,NULL,'FRA','Non',NULL,NULL,NULL,NULL,NULL,NULL,'15/01/2023','01/02/2023
('A0052878','2022/2023','M.',NULL,'ETHAN','BADIN','20/10/2010','FRANCE','BOURGOIN-JALLIEU','38300','145 CHEMIN DU MARAIS','38510','38','COURTENAY','FRANCE',NULL,NULL,NULL,NULL,'06.65.50.24.85',NULL,'[email protected]',NULL,NULL,'FRANCE','Non',NULL,NULL,NULL,NULL,NULL,NULL,'18/10/2022',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL),('K0046999','2022/2023','M.',NULL,'MOUAD','EL MHAMSSI','02/06/2017','FRANCE','TOULOUSE','31100','4 RUE DU ROUSSILLON','31100','31','TOULOUSE','FRANCE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRANCE','Non',NULL,NULL,NULL,NULL,NULL,NULL,'25/10/2022',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL),('K0047000','2022/2023','M.',NULL,'LOUAY','ESSAMHI','28/03/2016','FRANCE','TOULOUSE','31100','3 RUE DU BEARN','31100','31','TOULOUSE','FRANCE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRANCE','Non',NULL,NULL,NULL,NULL,NULL,NULL,'18/12/2022',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL),('I0022369','2022/2023','M.',NULL,'CORENTIN','DUWEL','10/02/1990','FRANCE','BOULOGNE SUR MER','62200','11 RUE DES MOULINS','50630','50','LE VAST','FRANCE',NULL,NULL,NULL,NULL,'06.78.13.20.45',NULL,NULL,NULL,NULL,'FRA','Non',NULL,NULL,NULL,NULL,NULL,NULL,'26/01/2023','23/01/2023',NULL,NULL,NULL,NULL,NULL,'27/12/2022','06/12/2022',NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL),('H0077451','2022/2023','M.',NULL,'SHARONE','ALEKIC','04/10/2009','FRANCE','BONDY','93','16 RUE DES ARDENNES PAVICON','93190','93','LIVRY GARGAN','FRANCE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRA','Non',NULL,NULL,NULL,NULL,NULL,NULL,'07/02/2023',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL),('J0051391','2022/2023','M.',NULL,'BILALL','LAYACHI','15/11/2008','FRANCE','POITIERS','86000','16 PLACE PHILLIPE LE HARDY','86340','86','NOUAILLE MAUPERTUIS','FRANCE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRANCE','Non',NULL,NULL,NULL,NULL,NULL,NULL,'07/10/2022',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL),('H0077452','2022/2023','M.',NULL,'XAVIER','DUPONT','05/10/1987','FRANCE','NOGENT SUR MARNE','94130','146 AVENUE DE VERDUN','92130','92','ISSY LÈS MOULINEAUX','FRANCE',NULL,NULL,NULL,NULL,'06.13.15.35.05',NULL,'[email protected]',NULL,NULL,'FRANCE','Non',NULL,NULL,NULL,NULL,NULL,NULL,'02/02/2023',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL),('A0052882','2022/2023','M.',NULL,'ROMAIN','CLERC','06/04/2005','FRANCE','CHAMBÉRY','73','15 CHEMIN DE VIBORGNE','73100','73','AIX LES BAINS','FRANCE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRANCE','Non',NULL,NULL,NULL,NULL,NULL,NULL,'06/02/2023',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL),('H0077453','2022/2023','M.',NULL,'GUILLAUME','ROUHAUD','10/02/2004','FRANCE','PARIS 14E ARRONDISSEMENT','75014','41 RUE CARVES','92120','92','MONTROUGE','FRANCE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRANCE','Non',NULL,NULL,NULL,NULL,NULL,NULL,'04/02/2023',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL),('A0052884','2022/2023','M.',NULL,'KAIS','HARFI','16/04/2014','FRANCE','VIENNE','38200','23 RUE TONY GARNIER','38200','38','VIENNE','FRANCE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRANCE','Non',NULL,NULL,NULL,NULL,NULL,NULL,'03/12/2022',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL),('B0020159','2022/2023','M.',NULL,'JORIS','CESARIO','18/12/2004','FRANCE','LONS-LE-SAUNIER','39000','4 ROUTE DE LA GRÈVE','71580','71','FLACEY EN BRESSE','FRANCE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRANCE','Non',NULL,NULL,NULL,NULL,NULL,NULL,'26/09/2022',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL),('F0042121','2022/2023','MME','THEET','VERONIQUE','BORCA','22/04/1957','FRANCE','NEUILLY-SUR-SEINE','92000','17 RUE MARCEL FAY','08090','8','TOURNES','FRANCE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRANCE','Non',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Non','Non','Non',NULL)
The table "adresses" contain 603978 rows.
INSERT INTO `adresses` VALUES (15611,'2023-09-02 23:15:09','2023-09-02 23:15:09',13259,NULL,'PR',NULL,NULL,'SQUARE VAILLANT - 4 RUE ED',NULL,NULL,NULL,'94000',NULL,'ALFORTVILLE','94002','11','94','FR',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15612,'2023-09-02 23:15:09','2023-09-02 23:15:09',13260,NULL,'PR',NULL,NULL,'24 RUE SIMONE SIGNORET',NULL,NULL,NULL,'86530',NULL,'NAINTRE','86174','75','86','FR',NULL,NULL,NULL,NULL,NULL,'0785693730',NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL)
(15665,'2023-09-02 23:15:09','2023-09-02 23:15:09',13313,NULL,'PR',NULL,NULL,'LA GARE',NULL,NULL,NULL,'71800',NULL,'SAINT JULIEN DE CIVRY',NULL,NULL,NULL,'FR',NULL,NULL,'0385706437',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15666,'2023-09-02 23:15:09','2023-09-02 23:15:09',13314,NULL,'PR',NULL,NULL,'192 AVENUE DE DUN',NULL,NULL,NULL,'18000',NULL,'BOURGES','18033','24','18','FR',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15667,'2023-09-02 23:15:09','2023-09-02 23:15:09',13315,NULL,'PR',NULL,NULL,'31 AVENUEDEBERNARDI',NULL,NULL,NULL,'52000',NULL,'CHAUMONT','18060','24','18','FR',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15668,'2023-09-02 23:15:09','2023-09-02 23:15:09',13316,NULL,'PR',NULL,NULL,'3 RUE SAINT EXUPERY',NULL,NULL,NULL,'69600',NULL,'OULLINS','69149','84','69','FR',NULL,NULL,'0660940353',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15669,'2023-09-02 23:15:09','2023-09-02 23:15:09',13317,NULL,'PR',NULL,NULL,'64 ALLEE FANNY DEERPE',NULL,NULL,NULL,'93100',NULL,'MONTREUIL','28267','24','28','FR',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15670,'2023-09-02 23:15:09','2023-09-02 23:15:09',13318,NULL,'PR',NULL,NULL,'14 CHEMIN DU COTEAU',NULL,NULL,NULL,'24470',NULL,'SAINT PARDOUX LA RIVIÈRE',NULL,NULL,NULL,'FR','[email protected]',NULL,NULL,NULL,NULL,'0646441760',NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15671,'2023-09-02 23:15:09','2023-09-02 23:15:09',13319,NULL,'PR',NULL,NULL,'2 BIS RUE CHEVRIER',NULL,NULL,NULL,'41100',NULL,'VENDOME','41269','24','41','FR',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15672,'2023-09-02 23:15:09','2023-09-02 23:15:09',13320,NULL,'PR',NULL,NULL,'13 RUE CLAUDE DEBUSSY',NULL,NULL,NULL,'28500',NULL,'VERNOUILLET','28404','24','28','FR',NULL,NULL,NULL,NULL,NULL,'0621222152',NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15673,'2023-09-02 23:15:09','2023-09-02 23:15:09',13321,NULL,'PR',NULL,NULL,'46 RUE ANDRE LETHUILLIER',NULL,NULL,NULL,'27000',NULL,'EVREUX','27229','28','27','FR',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15674,'2023-09-02 23:15:09','2023-09-02 23:15:09',13322,NULL,'PR',NULL,NULL,'18 LES CHENES DE JONAS\n696 ROUTE DE JONAS',NULL,NULL,NULL,'83500',NULL,'LA SEYNE SUR MER',NULL,NULL,NULL,'FR',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15675,'2023-09-02 23:15:09','2023-09-02 23:15:09',13323,NULL,'PR',NULL,NULL,'LOT LES CHENES DE JANAS VILLA 18\n696 ROUTE DE JANAS',NULL,NULL,NULL,'83500',NULL,'LA SEYNE SUR MER',NULL,NULL,NULL,'FR',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15676,'2023-09-02 23:15:09','2023-09-02 23:15:09',13324,NULL,'PR',NULL,NULL,'14 RUE NATIONALE',NULL,NULL,NULL,'56420',NULL,'GUEHENNO','56071','53','56','FR',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15677,'2023-09-02 23:15:09','2023-09-02 23:15:09',13325,NULL,'PR',NULL,NULL,'58 RUE JOSEPH LE SCIELLOUR',NULL,NULL,NULL,'49800',NULL,'TRÉLAZE','49353','52','49','FR','[email protected]',NULL,NULL,NULL,NULL,'0677013489',NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15678,'2023-09-02 23:15:09','2023-09-02 23:15:09',13326,NULL,'PR',NULL,NULL,'67 RUE PAUL DOUMER',NULL,NULL,NULL,'78540',NULL,'VERNOUILLET','28404','24','28','FR',NULL,NULL,NULL,NULL,NULL,'0661270776',NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,'null',NULL),(15679,'2023-09-02 23:15:09','2023-09-02 23:15:09',13327,NULL,'PR',NULL,NULL,'126 RUE DU GNRAL DE GAULLE',NULL,NULL,NULL
The table "commandes_lignes" contain 444013 rows.
INSERT INTO `commandes_lignes` VALUES (100081,'2023-10-21 13:32:13','2024-05-10 05:09:31',25362,'PRC','Assurance RC BEAL (Boxe Educative Assaut Loisir) 2024 - M DEVLIEGER Johan',5,NULL,1.76,'ELicence\\Core\\Models\\Licence',980351,254461,0,NULL,'PRC','{\"mouvement_code\":\"PRC\",\"licence_id\":980351,\"personne_id\":164805,\"compta_id\":228,\"structure_id\":228,\"libelle\":\"Assurance RC BEAL (Boxe Educative Assaut Loisir) 2024 - M DEVLIEGER Johan\",\"devise\":\"EUR\",\"saison\":2024,\"debit\":1.76}',NULL)
(100084,'2023-10-21 13:32:25','2023-10-21 13:32:25',25363,'LIC','Prise de licence BEAL (Boxe Educative Assaut Loisir) 2024 - M EZZINE Aymen',4,NULL,22.75,'ELicence\\Core\\Models\\Licence',980352,100291,0,NULL,'LIC','{\"mouvement_code\":\"LIC\",\"licence_id\":980352,\"personne_id\":546196,\"compta_id\":372,\"structure_id\":372,\"libelle\":\"Prise de licence BEAL (Boxe Educative Assaut Loisir) 2024 - M EZZINE Aymen\",\"devise\":\"EUR\",\"saison\":2024,\"debit\":22.75}',NULL),(100085,'2023-10-21 13:32:25','2023-10-21 13:32:25',25363,'PRC','Assurance RC BEAL (Boxe Educative Assaut Loisir) 2024 - M EZZINE Aymen',4,NULL,1.76,'ELicence\\Core\\Models\\Licence',980352,100292,0,NULL,'PRC','{\"mouvement_code\":\"PRC\",\"licence_id\":980352,\"personne_id\":546196,\"compta_id\":372,\"structure_id\":372,\"libelle\":\"Assurance RC BEAL (Boxe Educative Assaut Loisir) 2024 - M EZZINE Aymen\",\"devise\":\"EUR\",\"saison\":2024,\"debit\":1.76}',NULL),(100086,'2023-10-21 13:32:25','2023-10-21 13:32:25',25363,'PIA','Assurance IA BEAL (Boxe Educative Assaut Loisir)
The table "commandes_paiements_logs" contain 3120 rows.
INSERT INTO `commandes_paiements_logs` VALUES (1442,'2024-01-29 10:44:36','2024-01-29 10:44:36','20240129104329','00','44126','003126','[52431, 52435, 52442, 52450]','144','194.50.38.6','Lyra-Network Agent','POST','3390f82fc00c4ea7b7fb6cb8ce45ca51','{\"vads_tid\": \"001\", \"signature\": \"76074f11e7f49f09f12a9cab36764231d90e3f09\", \"vads_hash\": \"6f8e34c9466421010a2dd00a2acf5fe03eb4820b2f60359cc20f9bffcc56abb2\", \"vads_amount\": \"14400\", \"vads_result\": \"00\", \"vads_cust_id\": \"01104\", \"vads_pays_ip\": \"FR\", \"vads_site_id\": \"37077950\", \"vads_version\": \"V2\", \"vads_ctx_mode\": \"PRODUCTION\", \"vads_currency\": \"978\", \"vads_language\": \"fr\", \"vads_order_id\": \"44126\", \"vads_trans_id\": \"003126\", \"vads_auth_mode\": \"FULL\", \"vads_bank_code\": \"15589\", \"vads_cust_name\": \"Bernard SANROMA\", \"vads_bank_label\": \"Crédit Mutuel Arkéa\", \"vads_card_brand\": \"E-CARTEBLEUE\", \"vads_cust_email\": \"[email protected]\", \"vads_trans_date\": \"20240129104329\", \"vads_trans_uuid\": \"3390f82fc00c4ea7b7fb6cb8ce45ca51\", \"vads_action_mode\": \"INTERACTIVE\", \"vads_auth_number\": \"597967\", \"vads_auth_result\": \"00\", \"vads_card_nature\": \"BUSINESS\", \"vads_card_number\": \"513489XXXXXX1222\", \"vads_cust_status\": \"COMPANY\", \"vads_expiry_year\": \"2024\", \"vads_page_action\": \"PAYMENT\", \"vads_payment_src\": \"EC\", \"vads_threeds_eci\": \"02\", \"vads_threeds_xid\": null, \"vads_bank_product\": \"MCB\", \"vads_card_country\": \"FR\", \"vads_expiry_month\": \"2\", \"vads_extra_result\": null, \"vads_threeds_cavv\": \"A**************************=\", \"vads_trans_status\": \"AUTHORISED\", \"vads_capture_delay\": \"0\", \"vads_contract_used\": \"3011345\", \"vads_url_check_src\": \"PAY\", \"vads_cust_last_name\": \"SANROMA\", \"vads_operation_type\": \"DEBIT\", \"vads_payment_config\": \"SINGLE\", \"vads_threeds_status\": \"Y\", \"vads_cust_first_name\": \"Bernard\", \"vads_cust_legal_name\": \"SPORT ATHLETIQUE MERIGNACAIS\", \"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\\\":\\\"E-CARTEBLEUE|MASTERCARD\\\",\\\"brand\\\":\\\"E-CARTEBLEUE\\\"}\", \"vads_effective_amount\": \"14400\", \"vads_threeds_enrolled\": \"Y\", \"vads_presentation_date\": \"20240129104329\", \"vads_threeds_auth_type\": \"CHALLENGE\", \"vads_effective_currency\": \"978\", \"vads_threeds_error_code\": null, \"vads_threeds_sign_valid\": null, \"vads_payment_certificate\": \"99e25dfd5f67ab03269126e403380253cbc21d65\", \"vads_threeds_exit_status\": \"10\", \"vads_archival_reference_id\": \"L02900312601\", \"vads_card_product_category\": \"DEBIT\", \"vads_threeds_cavvAlgorithm\": null, \"vads_effective_creation_date\": \"20240129104329\", \"vads_threeds_user_interaction\": null, \"vads_initial_issuer_transaction_identifier\": \"1RCB402975756278\"}')
The table "personnes" contain 620264 rows.
INSERT INTO `personnes` VALUES (75777,'2023-09-02 23:15:09','2023-09-02 23:15:09','075777','G0016888','A','M','BORDJI','Yacin','M','2003-12-24',NULL,NULL,NULL,NULL,'FR',NULL,'FR',0,NULL,1,'2023-09-03 01:15:09',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,1,1,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL)
(75781,'2023-09-02 23:15:09','2023-09-02 23:15:09','075781','F0031847','A','M','BORDJY','Alexis','M','1997-02-27',NULL,NULL,NULL,NULL,'FR',NULL,'FR',0,NULL,1,'2023-09-03 01:15:09',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,1,1,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(75782,'2023-09-02 23:15:09','2023-09-02 23:15:09','075782','A0018427','A','M','BORDNER','Sofiane','M','1996-07-07',NULL,NULL,NULL,NULL,'FR',NULL,'FR',0,NULL,1,'2023-09-03 01:15:09',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,1,1,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(75783,'2023-09-02 23:15:09','2023-09-02 23:15:09','075783','H0034774','A','M','BORDO','Adam','M','1998-10-12',NULL,NULL,NULL,NULL,'FR',NULL,'FR',0,NULL,1,'2023-09-03 01:15:09',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,1,1,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(75784,'2023-09-02 23:15:09','2023-09-02 23:15:09','075784','G0014823','A','M','BORDO','Zahcen','M','1997-02-27',NULL,NULL,NULL,NULL,'FR',NULL,'FR',0,NULL,1,'2023-09-03 01:15:09',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,1,1,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(75785,'2023-09-02 23:15:09','2023-09-02 23:15:09','075785','K0037451','A','Mme','BORDOLL','Ines','F','2004-09-11',NULL,NULL,NULL,NULL,'FR',NULL,'FR',0,NULL,1,'2023-09-03 01:15:09',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,1,1,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(75786,'2023-09-02 23:15:09','2023-09-02 23:15:09','075786','J0032638','A','M','BORDON','Clement','M','2006-02-01',NULL,NULL,NULL,NULL,'FR',NULL,'FR',0,NULL,1,'2023-09-03 01:15:09',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,1,1,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(75787,'2023-09-02 23:15:09','2023-09-02 23:15:09','075787','C0009012','A','M','BORDON','Justin','M','1998-09-12',NULL,NULL,NULL,NULL,'FR',NULL,'FR',0,NULL,1,'2023-09-03 01:15:09',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,1,1,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(75788,'2023-09-02 23:15:09','2023-09-02 23:15:09','075788','H0040205','A','M','BORDON','Paul','M','2000-11-15',NULL,NULL,NULL,NULL,'FR',NULL,'FR',0,NULL,1,'2023-09-03 01:15:09',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,1,1,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL),(75789,'2023-09-02 23:15:09','2023-09-02 23:15:09','
The table "personnes_representants_legaux" contain 112053 rows.
INSERT INTO `personnes_representants_legaux` VALUES (15452,9081,NULL,NULL,NULL,NULL,NULL,'SEC'),(15453,538324,'Moebs','Sophie','0633310022','[email protected]',NULL,'PRI'),(15454,538324,NULL,NULL,NULL,NULL,NULL,'SEC'),(15455,538325,'MUNOZ','LAETITIA','0624030364','[email protected]',NULL,'PRI'),(15456,538325,NULL,NULL,NULL,NULL,NULL,'SEC'),(15457,141446,'D\'HOOGE','Cédric','0672032046','[email protected]',NULL,'PRI'),(15458,141446,NULL,NULL,NULL,NULL,NULL,'SEC'),(15459,410162,'PELLAN','Karine','0615755125','[email protected]',NULL,'PRI'),(15460,410162,NULL,NULL,NULL,NULL,NULL,'SEC'),(15461,9082,'Airapov','Artem','0760901468','[email protected]',NULL,'PRI'),(15462,9082,NULL,NULL,NULL,NULL,NULL,'SEC'),(15463,538330,'HASSINE','WAFA','0749508280','[email protected]',NULL,'PRI'),(15464,538330,NULL,NULL,NULL,NULL,NULL,'SEC'),(15465,538331,'Arbareri','Joël','0633576141','[email protected]',NULL,'PRI'),(15466,538331,NULL,NULL,NULL,NULL,NULL,'SEC'),(15467,538332,'ROUBIN','Céline','0660951461','[email protected]',NULL,'PRI'),(15468,538332,NULL,NULL,NULL,NULL,NULL,'SEC'),(15469,538334,'HOUSSEINE','AICHA','0772186961','[email protected]',NULL,'PRI'),
(15534,538355,NULL,NULL,NULL,NULL,NULL,'SEC'),(15535,538356,'Sabourdy','Valérie','0783607354','[email protected]',NULL,'PRI'),(15536,538356,NULL,NULL,NULL,NULL,NULL,'SEC'),(15537,320594,'RADE','MAGALI','06/81/40/10/78','[email protected]',NULL,'PRI'),(15538,320594,NULL,NULL,NULL,NULL,NULL,'SEC'),(15539,538359,'FERRE','SEGOLENE','06/01/29/63/70','[email protected]',NULL,'PRI'),(15540,538359,NULL,NULL,NULL,NULL,NULL,'SEC'),(15541,538360,'PELICO','Fanny','0690420230','[email protected]',NULL,'PRI'),(15542,538360,NULL,NULL,NULL,NULL,NULL,'SEC'),(15543,538361,'BAGOLE','Mélanie','0635363242','[email protected]',NULL,'PRI'),(15544,538361,NULL,NULL,NULL,NULL,NULL,'SEC'),(15545,538362,'BEUZEVILLE','Vincent','0609044293','[email protected]',NULL,'PRI'),(15546,538362,NULL,NULL,NULL,NULL,NULL,'SEC'),(15547,538363,'PONAMA','Gwénaëlle','0782038681','[email protected]',NULL,'PRI'),(15548,538363,NULL,NULL,NULL,NULL,NULL,'SEC'),(15549,538364,'FETTIH','Yaniss','0663115545','[email protected]',NULL,'PRI'),(15550,538364,NULL,NULL,NULL,NULL,NULL,'SEC'),(15551,538365,'GONZALEZ','Ludovic','0661587232','[email protected]',NULL,'PRI'),(15552,538365,NULL,NULL,NULL,NULL,NULL,'SEC'),(15553,248925,'TASTES','VALERIE','0763712928','[email protected]',NULL,'PRI'),(15554,248925,NULL,NULL,NULL,NULL,NULL,'SEC'),(15555,538366,'KALAYCI','Béatrice','0687545445','[email protected]',NULL,'PRI'),(15556,538366,NULL,NULL,NULL,NULL,NULL,'SEC'),(15557,538367,'LILAUD','Axel','0632584518','[email protected]',NULL,'PRI'),(15558,538367,NULL,NULL,NULL,NULL,NULL,'SEC'),(15559,408330,'PAULY','Jonathan','0623337837','[email protected]',NULL,'PRI'),(15560,408330,NULL,NULL,NULL,NULL,NULL,'SEC'),(15561,538368,'MIRANDA','Vanessa','0638200355','[email protected]',NULL,'PRI'),(15562,538368,NULL,NULL,NULL,NULL,NULL,'SEC'),(15563,538370,'ROBERT','AUDREY','0692029278','[email protected]',NULL,'PRI'),(15564,538370,NULL,NULL,NULL,NULL,NULL,'SEC'),(15565,538372,'ENGRAND','NICOLAS','06 75 99 78 08','[email protected]',NULL,'PRI'),(15566,538372,NULL,NULL,NULL,NULL,NULL,'SEC'),(15567,538375,'KEYKLICEK','Alexandrie','0634193414','[email protected]',NULL,'PRI'),(15568,538375,'Alloui','Samir','0606654690',NULL,NULL,'SEC'),(15569,538376,'BACCELLI','Maxime','0660847313','[email protected]',NULL,'PRI'),(15570,538376,'BACCELI','Catherine',NULL,NULL,NULL,'SEC'),(15571,538377,'Vidal','Marie','0677364427','[email protected]',NULL,'PRI'),(15572,538377,NULL,NULL,NULL,NULL,NULL,'SEC'),(15573,538378,'AHAMADA','Jacques','06 26 39 18 71','[email protected]',NULL,'PRI'),(15574,538378,NULL,NULL,NULL,NULL,NULL,'SEC')
The table "users" contain 40737 rows.
INSERT INTO `users` VALUES (14818,'2023-10-16 16:15:34','2023-10-16 16:15:55','258371','$2y$10$8KOoZDOuQ2duR/Cy4ihpUO8WegFCsAfOhKGcHMimcXoaN5MEX9tWG',258371,1,0,NULL),(14819,'2023-10-16 16:16:40','2023-10-16 16:17:10','543742','$2y$10$L8BZMj0k3XxRSm.hQlV.yuPakCmJiqthxmjztNwjHohB.AMj9rpyq',543742,1,0,NULL),(14820,'2023-10-16 16:23:12','2023-10-30 20:21:46','378691','$2y$10$1Xbu9A6dpjmzqmYIsEJ3luYYj6RRxx8qUYVkaGCK.POJLJ.oxIE6i',378691,1,0,NULL)
(14844,'2023-10-16 17:37:06','2024-02-14 18:34:11','262076','$2y$10$FLF/jla.y3.K7My/vzTc7.8CdAdKU5PWic43BueaIwbU4lZpsjRZm',262076,1,0,NULL),(14845,'2023-10-16 17:37:38','2023-10-16 17:37:51','529437','$2y$10$umgtmqdujp1VnBBMZF0CGOW/E40nincCe2CQpnbgI09P0/WHhTfs.',529437,1,0,NULL),(14846,'2023-10-16 17:38:44','2023-10-16 17:39:03','543229','$2y$10$RuZb6CR.O9IbxHXViW4jVugCo8WDvtv5XiX49s52cnkkGPUQ5XB92',543229,1,0,NULL),(14847,'2023-10-16 17:39:07','2023-10-16 17:42:06','543887','$2y$10$EIjvs1lYwh41RJYDu0V/pObT.euaAFaFednGedgxQUqbru5cmUW4m',543887,1,0,NULL),(14848,'2023-10-16 17:48:37','2023-10-16 17:49:22','440234','$2y$10$30uDQYUi1XlP1pw8sEao/.GxmkPWqZ7w9Dvq8jh60ZeYmDMUFO0wW',440234,1,0,NULL),(14849,'2023-10-16 17:49:02','2023-10-16 17:49:20','543731','$2y$10$EZHtyj15s5rwVLyJWf3j3eXzld0Z9vfqZRhCLG1qmyYY0WMBRpI22',543731,1,0,NULL),(14850,'2023-10-16 17:52:34','2023-10-16 17:53:16','542973','$2y$10$ODTmcK2WDYhYSTjQxWdJuemgZ/fwzeRK11TuFscXvGXymdgGcfQLi',542973,1,0,NULL),(14851,'2023-10-16 18:00:26','2023-10-16 18:00:40','532404','$2y$10$9Y1oyMzQrVgesWfFuq8W8Oaknsi8sHx4o51VEy9LbWHV4ag/9cn4a',532404,1,0,NULL),(14852,'2023-10-16 18:01:45','2023-10-16 18:02:10','540081','$2y$10$SQyusQS91svXyfmlGJ4TpuoXZ9TNEFclEi7jYhqKLmMp0KvxdbIpK',540081,1,0,NULL),(14853,'2023-10-16 18:01:57','2023-10-23 15:49:50','088766','$2y$10$H8AI3qx8zENg0pApNHKVquJipCnLF/1Zp9q2vGgUImZZj2Qa0JM9m',88766,1,0,NULL),(14854,'2023-10-16 18:02:29','2023-10-16 18:02:40','540473','$2y$10$03St7CGV5MA1eWE4NxNsiecDq0Uo1q3/hfmSFWTd5dh1RENrN.tza',540473,1,0,NULL),(14855,'2023-10-16 18:06:20','2023-10-16 18:06:30','542228','$2y$10$wvSbMY0spjj1B2gIgCV9huBErDaCkYJIyDcfV52liU.E1L4sykGQe',542228,1,0,NULL),(14856,'2023-10-16 18:07:02','2023-10-16 18:07:11','543899','$2y$10$DQwGyzZwPiyz3c0QW2IvC.X.abQHw2ZtKrxfeJl.Od4yYRDBNZwRy',543899,1,0,NULL),(14857,'2023-10-16 18:09:53','2023-10-16 18:10:30','217147','$2y$10$hDCuKBslURgHNVlZaXc1kuoAt8mgRjvgfxaDSunDGhPZAZq2Y5NK.',217147,1,0,NULL),(14858,'2023-10-16 18:12:50','2023-10-16 18:13:08','355088','$2y$10$R0/StY6MeeKIagwlxSRI4uOe0rRT6XXvCVQ.wtRZxMVx6xRjVs58C',355088,1,0,NULL),(14859,'2023-10-16 18:14:16','2023-10-30 07:57:03','543264','$2y$10$zemySkzhH/zcHsB1ctGQuuA3ie/hIrfYtGTw1Hi6lD95kzECzE7Sy',543264,1,0,NULL),(14860,'2023-10-16 18:16:02','2023-10-16 18:16:10','542730','$2y$10$B9Om4CM0Ftp.VsRP1CwmYeMN.yx.4/OgbMZD.ELINUps49KgIm54i',542730,1,0,NULL),(14861,'2023-10-16 18:16:42','2023-10-16 18:16:50','435164','$2y$10$wapCfMYN70LXnERBueft9usc.L/zxd0GdiNHji0GI0YA/vstlDBDG',435164,1,0,NULL),(14862,'2023-10-16 18:17:38','2023-10-16 18:18:08','543903','$2y$10$VCP2i73766O7aqRmcn8pPevzpI25zcvdXb2Bm1CTXVt1GV7WR3VuW',543903,1,0,NULL)
