/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.6.23-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: lean_shop_net
-- ------------------------------------------------------
-- Server version	10.6.23-MariaDB-0ubuntu0.22.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `leanps_address`
--

DROP TABLE IF EXISTS `leanps_address`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `leanps_address` (
  `id_address` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_country` int(10) unsigned NOT NULL,
  `id_state` int(10) unsigned DEFAULT NULL,
  `id_customer` int(10) unsigned NOT NULL DEFAULT 0,
  `id_manufacturer` int(10) unsigned NOT NULL DEFAULT 0,
  `id_supplier` int(10) unsigned NOT NULL DEFAULT 0,
  `id_warehouse` int(10) unsigned NOT NULL DEFAULT 0,
  `alias` varchar(32) NOT NULL,
  `company` varchar(255) DEFAULT NULL,
  `lastname` varchar(255) NOT NULL,
  `firstname` varchar(255) NOT NULL,
  `address1` varchar(128) NOT NULL,
  `address2` varchar(128) DEFAULT NULL,
  `postcode` varchar(12) DEFAULT NULL,
  `city` varchar(64) NOT NULL,
  `other` text DEFAULT NULL,
  `phone` varchar(32) DEFAULT NULL,
  `phone_mobile` varchar(32) DEFAULT NULL,
  `vat_number` varchar(32) DEFAULT NULL,
  `dni` varchar(16) DEFAULT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  `active` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `deleted` tinyint(1) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id_address`),
  KEY `address_customer` (`id_customer`),
  KEY `id_country` (`id_country`),
  KEY `id_state` (`id_state`),
  KEY `id_manufacturer` (`id_manufacturer`),
  KEY `id_supplier` (`id_supplier`),
  KEY `id_warehouse` (`id_warehouse`)
) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leanps_address`
--

LOCK TABLES `leanps_address` WRITE;
/*!40000 ALTER TABLE `leanps_address` DISABLE KEYS */;
INSERT INTO `leanps_address` VALUES (1,21,5,0,1,0,0,'manufacturer','','COOK','Tim','1 Infinite Loop','','95014','Cupertino','','(800) 275-2273','','','','2012-07-27 12:24:16','2017-07-10 19:05:24',1,1),(2,8,0,1,0,0,0,'Mon adresse','My Company','DOE','John','16, Main street','2nd floor','75000','Paris ',NULL,'0102030405',NULL,NULL,NULL,'2012-07-27 12:24:16','2012-07-27 12:24:16',1,0),(3,8,0,2,0,0,0,'Mon adresse','','LANGLOIS','André','23 Rue Baptiste Renard','','27350','Brestot','','0232563400','','','','2012-07-27 14:45:56','2017-08-24 17:56:16',1,1),(4,8,0,4,0,0,0,'Mon adresse',NULL,'L','A','3 la LOge',NULL,'27350','zae',NULL,NULL,'0609141202',NULL,NULL,'2013-07-13 19:24:11','2013-07-13 19:24:11',1,0),(6,8,0,6,0,0,0,'Lindt','Lindt & Sprüngli','Delrieu','Mathieu','2 Avenue Mal de Lattre de Tassigny',NULL,'64400','Oloron Sainte Marie',NULL,NULL,'0674001620',NULL,NULL,'2013-07-25 16:26:26','2013-07-25 16:26:26',1,0),(8,8,0,7,0,0,0,'Mon adresse',NULL,'Recchia','Bruno','9 route de Châtres',NULL,'41700','Oisly',NULL,NULL,'0674457198',NULL,NULL,'2013-07-31 15:31:56','2013-07-31 15:31:56',1,0),(9,8,0,9,0,0,0,'My address','Rousset 2000 FR, STMicroelectron','EL-KHOURY','Jerome','Z.l. de Rousset, Av Victoire',NULL,'13106','Rousset Dedex',NULL,NULL,'+33675702140',NULL,NULL,'2013-08-01 09:45:07','2013-08-06 12:35:17',1,1),(11,8,0,11,0,0,0,'My address','STMicroelectronic SAS ','EL-Khoury','Jerome ','Rousset 2000 FR','Z.i. de Rousset, Av Victoire','13106','Rousset Cedex','ATTENTION TO : Jerome EL-Khoury',NULL,'+33675702140',NULL,NULL,'2013-08-02 02:53:09','2013-08-06 03:29:43',1,1),(12,8,0,11,0,0,0,'My address','STMicroelectronic SAS ','EL-Khoury','Jerome ','Rousset 2000 FR','Z.i. de Rousset, Av Victoire','13106','Rousset Cedex','ATTENTION TO : Jerome EL-Khoury in FRANCE',NULL,'+33675702140',NULL,NULL,'2013-08-06 03:29:43','2013-08-06 10:01:34',1,0),(13,8,0,12,0,0,0,'Mon adresse','STMicroelectronic SAS (Rousset 2','EL-Khoury','Jerome ','Z.l. de Rousset, Av Victoire',NULL,'13106','Rousset Cedex',NULL,NULL,'+33675702140',NULL,NULL,'2013-08-07 08:52:52','2013-08-07 08:52:52',1,0),(15,8,0,14,0,0,0,'Mon adresse','STMICROELECTRONICS','ardesi','olivier','190 av celestin coq',NULL,'13106','ROUSSET',NULL,NULL,'00 33 6 80 32 71 94',NULL,NULL,'2013-08-27 06:25:47','2013-08-27 06:25:47',1,0),(16,8,0,15,0,0,0,'Mon adresse','stmicroelectronics','ardesi','olivier','STMicroelectronics','190 avenue Celestin Coq','13106','ROUSSET',NULL,NULL,'0680327194',NULL,NULL,'2013-08-29 06:49:20','2013-08-29 06:49:20',1,0),(17,8,0,17,0,0,0,'Mon adresse','Jamespot','Garnier','Alain','66 rue Marceau',NULL,'93100','MONTREUIL',NULL,'0148581801',NULL,NULL,NULL,'2013-11-13 18:31:28','2013-11-13 18:31:28',1,0),(18,8,0,18,0,0,0,'Mon adresse','FAABFABRICAUTO','MARECHAL','Patrick','400 chemin de la Craz',NULL,'01440','VIRIAT',NULL,NULL,'07 88 35 32 67',NULL,NULL,'2013-11-14 16:01:32','2013-11-14 16:01:32',1,0),(19,10,182,19,0,0,0,'My address','MCU srl','menconi','claudio','casati 14',NULL,'20900','monza',NULL,NULL,'+39335296651','02869910964',NULL,'2014-01-07 10:40:14','2014-01-14 19:55:39',1,0),(20,8,0,21,0,0,0,'Mon adresse','FFB','Conti','Isabelle','2 rue des Combottes',NULL,'25130','Villers-le-Lac',NULL,NULL,'+33 381 680 950',NULL,NULL,'2014-04-15 16:10:16','2014-05-12 14:34:04',1,0),(21,68,0,22,0,0,0,'My address',NULL,'novoa','cristian','san jose 855, san bernardo',NULL,'807-1158','santiago',NULL,NULL,'+56954240546',NULL,NULL,'2014-05-05 20:07:05','2014-05-05 20:07:05',1,0),(22,8,0,24,0,0,0,'Mon adresse','Hamelin Group','Andrieu','Jean-Luc','9, Rue Guyon de Guercheville','','14200','HEROUVILLE SAINT CLAIR','','','0678099622','','','2014-11-28 10:39:47','2014-11-28 10:39:47',1,0),(23,8,0,24,0,0,0,'Mon adresse de facturation','Hamelin SAS','Andrieu','Jean-Luc','9, Rue Guyon de Guercheville','','14200','HEROUVILLE SAINT CLAIR','','0678099622','0678099622','','','2014-11-28 10:39:57','2014-11-28 10:43:41',1,0),(24,8,0,25,0,0,0,'Mon adresse','CEDIAL','VANDAELE','laurent','CEDIAL','6 rue bonnefond','69700','GIVORS','','','0625554134','FR7640438639300023','','2015-04-30 08:57:16','2015-04-30 09:00:49',1,0),(25,8,0,26,0,0,0,'Bureau','CEDIAL','VANDAELE','Laurent','6 rue Bonnefond','','69700','GIVORS','','0478079806','0625554134','','','2015-05-26 16:20:17','2015-05-26 16:23:33',1,0),(26,8,0,27,0,0,0,'Mon adresse','renforC','Martin','Sébastien','204 avenue de Comar','','67100','Strasbourg','','0636531518','0636531518','FR04801970260','','2015-07-22 20:24:18','2015-07-22 21:31:27',1,0),(27,8,0,29,0,0,0,'My address','FM Logistic','SCHITTER','Delphine','ZAC Paris Oise, BP16','','60126','Longueil sainte marie','','0033 6 83 64 69 53','0033 6 83 64 69 53','','','2015-10-16 06:00:19','2015-10-16 06:04:34',1,0),(28,8,0,30,0,0,0,'Mon adresse','Faurecia','Savidan','Armelle','2 rue Hennape','','92735','Nanterre Cedex','Faurecia University','','0635343141','','','2016-01-21 15:37:44','2016-10-31 10:30:17',1,0),(29,8,0,31,0,0,0,'Mon adresse','LINDT & SPRUNGLI SAS','BOURDAA','Bernadette','2 avenue de Lattre de Tassigny','BP 49','64400','OLORON STE MARIE','','05 59 88 88 88','','','','2016-02-16 11:57:36','2016-02-16 11:57:36',1,0),(30,8,0,32,0,0,0,'Mon adresse','STERIS','PERNOT','Pascal','116 Avenue de Magudas','','33185','LE HAILLAN','','','0634463864','','','2016-04-18 16:44:17','2016-04-18 16:44:17',1,0),(31,8,0,33,0,0,0,'Mon adresse','Steris','Pernot','Pascal','116 Avenue Magudas','','33185','Le Haillan','','','0634463864','','','2016-05-09 09:58:24','2016-05-09 09:58:24',1,0),(32,8,0,33,0,0,0,'Paypal_Address','','Pernot','Pascal','STERIS','116 Avenue Magudas','33185','Le Haillan','','0634463864','','','','2016-05-09 10:06:01','2016-05-09 10:06:01',1,0),(33,8,0,7,0,0,0,'Paypal_Address','','Recchia','Bruno','le clos de chatres','','41700','oisly','','','','','','2016-07-01 10:54:48','2016-07-01 10:54:48',1,0),(34,8,0,34,0,0,0,'Mon adresse','Sct Benteler','GAISNE','Denis','Parc Industiel d\'Incarville','','27000','LOUVIERS','','0332093209','','','','2016-10-03 16:47:36','2016-10-03 16:47:36',1,0),(35,8,0,34,0,0,0,'Mon adresse  Usine','Sct Benteler','GAISNE','Denis','Parc Industiel d\'Incarville','','27406','LOUVIERS','','0332093209','','','','2016-10-03 16:48:49','2016-10-03 16:48:49',1,0),(36,8,0,34,0,0,0,'Paypal_Address','','GAISNE','Denis','Parc Industiel d\'Incarville','','27000','LOUVIERS','','0332093209','','','','2016-10-03 16:52:58','2016-10-03 16:52:58',1,0),(37,8,0,35,0,0,0,'Mon adresse','La Toque Angevine','Duchesne','Simon','3 rue Robert Schuman - ZI d\'Etriché','','49500','Segré','','','0787363608','','','2016-11-14 11:07:53','2016-11-14 11:12:59',1,0),(38,8,0,36,0,0,0,'Mon adresse','Hutchinson','lesage','Bruno','2 Rue Balzac','','75008','Paris','','','0645744997','','','2016-11-23 15:39:08','2016-11-23 15:41:46',1,0),(39,1,0,37,0,0,0,'Mon adresse','Dr. Mauerer Ing.Conseil','Mauerer','Anton','Hohenzollerndamm 84','','14000','Berlin','','+49308266065','491723261837','DE136029962','','2017-04-20 13:30:27','2017-04-20 14:29:35',1,0),(40,8,0,38,0,0,0,'Mon adresse','AKIRO FORMATIONS','CONSTANT','François','2 le grand Beauvais','','35410','NOUVOITOU','','','0638906542','','','2017-05-18 22:23:28','2017-05-18 22:23:28',1,0),(41,19,0,39,0,0,0,'My address','Autoneum Management AG','Facal','Maria','Schlosstalstrasse 43','','8406','Winterthur','','','0041 79 137 67 54','','','2017-05-23 10:41:41','2017-05-23 10:43:38',1,0),(42,8,0,40,0,0,0,'Mon adresse','','LANGLOIS','Daniel','23 rue Baptiste Renard','','27350','Brestot','','','0232563400','','','2017-05-31 09:55:18','2017-05-31 09:55:40',1,0),(43,19,0,41,0,0,0,'My address','Autoneum Management AG','Facal','Maria','Schlosstalstrasse 43','','8406','Winterthur','','',' + 41 79 137 67 54 ','','','2017-06-01 10:04:01','2017-06-01 10:04:01',1,0),(44,8,0,42,0,0,0,'My address','Autoneum France SASU','Roques','Sebastien','Digue de la Cartonnerie','','82202','Moissac','','','+33664225883','','','2017-06-06 14:55:47','2017-06-06 15:03:29',1,0),(45,19,0,42,0,0,0,'My Invoice address','Autoneum Management AG','Garcia Facal','Maria','Schlosstalstrasse 43','','8406','Winterthur','','','00 41 79 137 67 54','','','2017-06-06 15:02:52','2017-06-06 15:02:52',1,0),(46,19,0,42,0,0,0,'My Invoice address','Autoneum Management AG','Garcia Facal','Maria','Schlosstalstrasse 43','','8406','Winterthur','','','00 41 79 137 67 54','','','2017-06-06 15:03:29','2017-06-06 15:03:29',1,0),(47,8,0,43,0,0,0,'Mon adresse','','Langlois','Dan','23 rue Baptiste Renard','','27350','BRESTOT','','','0232563400','','','2017-06-07 14:48:09','2019-08-16 10:35:37',1,1),(48,8,0,43,0,0,0,'Fourcade','','Langlois','Dan','7 rue Fourcade','','75015','Paris','','0232563400','0609141202','','','2017-06-07 14:49:50','2019-08-16 10:35:37',1,1),(49,8,0,44,0,0,0,'My address','Arconic','Lamotte','Alexis','Huck France SAS,Clos d\'Asseville - BP 30007','','95450','Us','','0787186059','0787186059','','','2017-06-26 10:27:52','2017-06-26 10:27:52',1,0),(50,8,0,45,0,0,0,'Mon adresse','','azzz','az','é\"\"\"\'\"\"','','27350','BRESTOT','','','0232563400','','','2017-06-27 19:21:15','2019-08-16 10:33:34',1,1),(51,8,0,46,0,0,0,'Mon adresse','','bis','test','test','','20501','test','','','0112205445','','','2017-07-04 16:25:47','2019-08-16 10:33:34',1,1),(53,8,0,48,0,0,0,'Mon adresse','','bis','test','test','','20501','paris','','','0112205445','','','2017-07-04 16:52:56','2019-08-16 10:35:37',1,1),(54,8,0,49,0,0,0,'Mon adresse','','bi','test','test','','20501','paris','','','0112205445','','','2017-07-04 22:30:35','2019-08-16 10:33:34',1,1),(55,8,0,50,0,0,0,'Mon adresse','','bis','test','test','','20501','test','','','0112205445','','','2017-07-04 23:23:15','2019-08-16 10:33:34',1,1),(56,8,0,51,0,0,0,'Mon adresse','','bi','test','test','','20501','test','','','0112205445','','','2017-07-04 23:31:01','2019-08-16 10:33:34',1,1),(57,8,0,52,0,0,0,'Mon adresse','','bis','test','test','','20501','test','','','0112205445','','','2017-07-04 23:36:54','2019-08-16 10:33:34',1,1),(58,8,0,53,0,0,0,'Mon adresse','','bis','test','test','','20501','test','','','0112205445','','','2017-07-06 18:17:13','2019-08-16 10:33:34',1,1),(59,8,0,54,0,0,0,'Mon adresse','','Info','Ifi','23 Rue Baptiste Renard','','27350','Brestot','','','0609141202','','','2017-07-07 09:17:59','2019-08-16 10:33:34',1,1),(62,8,0,57,0,0,0,'Mon adresse','','bis','test','test','','20501','test','','','0112205445','','','2017-07-10 12:00:26','2017-07-10 12:00:26',1,0),(63,8,0,58,0,0,0,'Mon adresse','','Michel','Daniel','23 Rue Baptiste Renard','','27350','Brestot','','609141202','0609141202','','','2017-07-12 08:30:15','2019-08-16 10:35:38',1,1),(64,8,0,59,0,0,0,'Commande','LINDT & SPRUNGLI','LACROIX','Sandrine','Avenue de Lattre de Tassigny','','64400','OLORON SAINTE MARIE','','0559888888','0559888888','','','2017-07-31 17:31:01','2017-07-31 17:32:16',1,0),(65,8,0,60,0,0,0,'Mon adresse','Arkema','FAIVRE','Yann','CEntre Technique, Informatique et Administratif - Chemin de la Lône','','69492','Pierre Bénite','','','0613371777 ','','','2017-08-24 11:31:55','2017-08-24 11:31:55',1,0),(66,8,0,61,0,0,0,'Mon adresse','','Test','Firas','75000 Paris, France','','75000','Paris','','00 00 00 00 00','','','','2017-08-24 16:19:22','2018-11-17 15:45:20',1,1),(67,8,0,2,0,0,0,'Mon adresse','','LANGLOIS','André','23 Rue Baptiste Renard','','27350','Brestot','','0232563400','0609141202','','','2017-08-24 17:56:16','2017-08-24 17:56:46',1,0),(68,8,0,62,0,0,0,'Mon adresse','','Langlois','Daniel','23 rue Baptiste Renard','','27350','BRESTOT','','','0232563400','','','2017-08-25 16:04:57','2019-08-16 10:34:50',1,1),(69,8,0,63,0,0,0,'Mon adresse','SKF FRANCE','ROBERT','isabelle','204  BLVD  CHARLES DE GAULLE ','','37540','ST CYR SUR LOIRE  ','','','0685682229','','','2017-11-29 09:02:41','2017-11-29 09:02:41',1,0),(70,8,0,64,0,0,0,'Mon adresse','SNECI','MUTTER','Mathieu','16 rue Rivay','','92300','LEVALLOIS-PERRET','','','0686173897','FR 40 712 063 106 ','','2017-12-08 13:53:05','2017-12-08 13:53:05',1,0),(71,8,0,65,0,0,0,'Paypal_Address','','Langlois','André','23 rue Baptiste Renard','','27350','Brestot','','','','','','2017-12-08 15:58:41','2019-08-16 10:35:38',1,1),(72,8,0,66,0,0,0,'Mon adresse','','leblanc','pierre guillaume','20 rue de la patte d\'oie ','','93460','gournay sur marne','','+33679238267','','','','2018-02-25 10:56:22','2018-02-25 10:56:22',1,0),(73,8,0,67,0,0,0,'Mon adresse','','LANGLOIS','André','23 rue Baptiste Renard','','27350','Brestot','','','0232563400','','','2018-11-17 11:30:22','2019-08-16 10:35:38',1,1),(74,13,0,68,0,0,0,'My address','BAC bv','Hetem','Martin','Stelling 21','','4873HH','Etten-Leur','','','+31625002411','NL809264043B01','','2019-03-14 12:06:10','2019-03-14 12:06:10',1,0),(75,8,0,69,0,0,0,'Mon adresse','BBC and  Partners','BAMOGO','ABDOULAYE','16 Rue Louis Pergaud','','94700','Maisons Alfort','','','0651611789','','','2019-03-29 09:07:32','2019-03-29 09:07:32',1,0),(76,8,0,70,0,0,0,'Mon adresse','LABORATOIRE GILBERT','generaux ','moyens','928 AVENUE  DU GENERAL  DE  GAULLE','','14200','HEROUVILLE ST CLAIR','','0231471459','','FR36306062944','','2019-04-18 14:43:25','2019-07-11 10:42:06',1,1),(77,8,0,70,0,0,0,'Mon adresse','LABORATOIRE GILBERT','GENERAUX ','MOYENS ','928 AVENUE  DU GENERAL DE  GAULLE ','','14200','HEROUVILLE ST CLAIR','','0231471459','','FR36306062944','','2019-07-11 10:42:06','2024-06-07 15:06:55',1,1),(78,8,0,74,0,0,0,'Mon adresse','AL Consulting','Michel','Daniel','23 rue Baptiste Renard','','27350','Brestot','','','','FR27381445907','','2019-08-15 14:11:19','2019-08-16 10:34:00',1,1),(79,8,0,75,0,0,0,'Mon adresse','','Michel','Daniel','23 rue Baptiste Renard','','27350','Brestot','','','','','','2019-08-15 14:59:06','2019-08-16 10:34:00',1,1),(81,8,0,65,0,0,0,'Mon adresse','','Antoine','Héron','23 rue Baptiste Renard','','27350','Brestot','','','','','','2019-08-17 10:30:04','2019-08-17 10:30:04',1,0),(82,8,0,65,0,0,0,'Paypal_Address 1','','anglois','André ','23 rue Baptiste Renard','','27350','Brestot','','','','','','2019-08-17 10:45:55','2019-08-17 10:45:55',1,0),(83,8,0,65,0,0,0,'Mon adresse','','Antoine','Héron','23 rue Baptiste Renard','','27350','Brestot','','','','','','2019-08-17 10:46:42','2019-08-17 10:46:42',1,0),(84,8,0,78,0,0,0,'Mon adresse','','Jules','JUles','23 rue Baptiste Renard','','27350','Brestot','','','','','','2019-08-18 10:29:03','2019-08-18 10:29:03',1,0),(85,8,0,79,0,0,0,'Mon adresse','','SHAKERI','Mathieu','114 rue simone de beauvoir','','69330','meyzieu','','','','','','2019-10-15 16:21:00','2019-10-15 16:21:00',1,0),(86,8,0,80,0,0,0,'Mon adresse','Eramet','PAMBO','florent','5 rue Paul COULON ','','63530','SAYAT ','','','','','','2019-10-16 22:06:19','2019-10-16 22:06:19',1,0),(87,8,0,82,0,0,0,'Mon adresse','AL CONSULTING','LANGLOIS','ANDRE','23 Rue Baptiste Renard','','27350','Brestot','','0609141202','','','','2019-10-18 19:27:00','2019-10-18 19:27:00',1,0),(88,8,0,84,0,0,0,'My Address','','Turbin','Andrei','Akademica Korolyova 3-231','','75001','Moscow','','','','','','2019-10-23 00:09:05','2019-10-23 00:09:05',1,0),(89,8,0,85,0,0,0,'Mon adresse','ARAYMOND FLUID CONNECTION France SAS ','CHITEBOUN','Flore','123 Rue Hilaire Chardonnet','','38000','Grenoble','','+33 457 04 3822','','','','2019-10-25 10:57:30','2019-10-25 11:07:25',1,0),(90,8,0,85,0,0,0,'Mon adresse','RAYGROUP','HADOUI','Myriam','129 COURS BERRIAT','','38000','GRENOBLE','','','','','','2019-10-25 11:08:25','2019-10-25 11:08:25',1,0),(91,8,0,87,0,0,0,'Mon adresse','','LANGLOIS','ANdré','Graz','','08900','Graz','','','','','','2019-10-25 11:45:13','2019-10-26 12:40:11',1,0),(92,8,0,88,0,0,0,'Mon adresse','ITOS','Test','Test','75000 Paris, France','','75000','Paris','','0155146254','','','','2019-10-25 17:44:00','2019-10-25 18:21:17',1,0),(93,8,0,89,0,0,0,'Mon adresse','aaaaaaaaaaaaa','bou','firas','5 rue itos marseille France','','13001','marseille','','0213265450','','','','2019-10-28 11:54:42','2019-10-28 11:54:42',1,0),(94,8,0,90,0,0,0,'Mon adresse','','LANGLOIS','ANdré','23 rue Baptiste Renard','','27350','Brestot','','','','','','2019-11-06 17:46:05','2019-11-06 17:46:05',1,0),(95,8,0,91,0,0,0,'Mon adresse','','Michel','ANdré','aaaa','','42000','Roanne','','','','','','2019-11-08 19:09:39','2019-11-08 19:09:39',1,0),(96,8,0,92,0,0,0,'Mon adresse','SYRACONSEIL','IBANEZ','RENE','3 LOT LES NOISETIERS','','71600','VITRY EN CHAROLLAIS','','0760428450','','FR01794927574','','2020-02-22 05:38:29','2020-02-22 05:38:29',1,0),(97,8,0,93,0,0,0,'Mon adresse','deser','andre','pierre','3 LOT LES NOISETIERS','','71600','VITRY EN CHAROLLAIS','','0760428450','','FR01794927598','','2020-02-22 15:47:22','2020-02-22 15:47:22',1,0),(98,8,0,94,0,0,0,'Mon adresse','','Gautry','Philippe','48 rue alexis quennet','','78955','Carrières-sous-Poissy ','','','','','','2020-05-12 07:18:38','2020-05-12 07:18:38',1,0),(99,8,0,96,0,0,0,'Mon adresse','DEINOVE','berenger','aurelie','1682 rue de la valsiere','batiment cap sigma','34790','Grabels','','','','FR44492272521','','2020-10-12 10:35:12','2020-10-12 10:35:12',1,0),(100,8,0,97,0,0,0,'Mon adresse','SAFRAN ELECTRONICS DEFENSE','BERTHELOT','Sylvaine','RUE COLBERT - CS90604 12','','35306','FOUGERES','','0786943769','','','','2020-10-19 10:17:52','2020-10-19 10:17:52',1,0),(101,8,0,99,0,0,0,'Mon adresse','Delpharm L\'aigle','Noizet','Simon ','7 Rue Fernand Michaux','BP99','61300','L\'aigle','','','','FR28878027580','','2021-04-13 18:26:27','2021-04-15 12:16:55',1,0),(102,8,0,100,0,0,0,'Mon adresse','Delpharm L\'aigle','Noizet','Simon','7 Rue Fernand Michaux','BP90','61300','L\'Aigle','','','','FR28878027580','','2021-04-15 12:19:10','2021-04-15 12:20:51',1,0),(103,8,0,102,0,0,0,'Mon adresse','Becton Dickinson','BRAY','Mikael','11 Rue Aristide-Bergès','','38801','Le Pont-de-Claix cedex','','','','','','2021-10-19 16:54:33','2021-10-19 16:54:33',1,0),(104,8,0,103,0,0,0,'My Address','ENOMAX','BERTHELEM','JULIEN','1 RUE CHARLES DE GAULLE - ZI LA MARINIERE','','91070','BONDOUFLE','','','','FR77499328409','','2022-04-06 09:56:07','2022-04-06 09:56:07',1,0),(105,8,0,104,0,0,0,'Paypal_Address 1','','Chesnier','Sabine','1 rue Charles de Gaulle','','91070','Bondoufle','','','','','','2022-07-26 14:09:56','2022-07-26 14:09:56',1,0),(108,6,0,105,0,0,0,'My Address','','Cavat','Pierre','Camino Lavandeira, 11','','36390','Vigo','','','','','-','2022-10-07 11:58:49','2022-10-07 11:58:49',1,0),(109,6,0,105,0,0,0,'My Address','Faurecia Automotive España SA','Cavat','Pierre','Calle Marie Curie, 19','','28521','Rivas - Vaciamadrid','','+34647682921','','A28041143','-','2022-10-07 12:00:36','2022-10-07 12:00:36',1,0),(110,8,0,106,0,0,0,'Mon adresse','','Got','Maika','Seglaregatan 35','','41457','Göteborg','','','','','','2022-10-27 15:28:09','2022-10-27 15:28:09',1,0),(111,8,0,108,0,0,0,'Mon adresse','NEMERA LE TREPORT','Prunier','Mickael','17 RTE D EU ','','76470','LE TREPORT','','0630482370','','','','2023-04-11 14:19:18','2023-04-11 14:19:18',1,0),(112,8,0,113,0,0,0,'Mon adresse','VEKA SAS','MELE','CHRISTIAN','27 AVENUE DES GENEVRIERS - ZI DE VONGY','','74200','THONON LES BAINS','','0450818800','','FR78332251115','','2023-12-18 15:31:55','2023-12-18 15:31:55',1,0),(113,8,0,114,0,0,0,'Mon adresse','VEKA SAS','MELE','CHRISTIAN','27 AVENUE DES GENEVRIERS ','ZONE INDUSTRIELLE DE VONGY','74200','THONON LES BAINS','','0450818800','','FR78332251115','','2023-12-18 16:40:04','2023-12-18 16:40:04',1,0),(114,26,0,115,0,0,0,'My Address','','Treacy','Raymond','436, Moness Burt, Speenoge P.O. Lifford','Co. Donegal, Ireland.','F93 Y2V4','Burt','','00353873921760','','','','2023-12-21 01:21:44','2023-12-21 01:21:44',1,0),(115,26,0,115,0,0,0,'Paypal_Address 1','','Treacy','Raymond','436, Moness Burt, Speenoge P.O, Lifford, Co Donegal','','F93Y2V4','Burt','','','','','','2023-12-21 01:25:51','2023-12-21 01:25:51',1,0),(116,3,0,120,0,0,0,'My Address','','De la Torre','Bernardo','Achterbremt 35','','9320','Nieuwerkerken','','+32479472480','','','','2024-01-07 21:15:12','2024-01-07 21:15:12',1,0),(117,3,0,121,0,0,0,'Paypal_Address 1','','De la Torre','Bernardo','Achterbremt 35','','9320','Nieuwerkerken','','','','','','2024-01-08 20:35:26','2024-01-08 20:35:26',1,0),(118,8,0,123,0,0,0,'Mon adresse','Desjardin','leroux','thibaud','2 rue du thillay','','95500','Gonesse','','0640640037','','','','2024-01-19 08:15:49','2024-01-19 08:15:49',1,0),(119,143,0,136,0,0,0,'My Address','Nyomda-Technika Kft.','Szeginé Hordós','Renáta','Puskás Tivadar utca 4.','','9027','Győr','','06306809760','','10541034','','2024-04-28 22:33:56','2024-04-28 22:33:56',1,0),(120,8,0,70,0,0,0,'Mon adresse','LABORATOIRE GILBERT','GENERAUX ','MOYENS ','1 avenue de dubna','','14200','HEROUVILLE ST CLAIR','','0231471515','','','','2024-06-07 15:06:55','2024-06-07 15:06:55',1,0),(121,8,0,143,0,0,0,'Mon adresse','AL CONSULTING','LANGLOIS','ANDRE','23 Rue Baptiste Renard','','27350','Brestot','','0609141202','','','','2024-06-07 15:18:58','2024-06-07 15:18:58',1,0);
/*!40000 ALTER TABLE `leanps_address` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-06-30 21:07:27
