/*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_orders`
--

DROP TABLE IF EXISTS `leanps_orders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `leanps_orders` (
  `id_order` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `reference` varchar(9) DEFAULT NULL,
  `id_shop_group` int(11) unsigned NOT NULL DEFAULT 1,
  `id_shop` int(11) unsigned NOT NULL DEFAULT 1,
  `id_carrier` int(10) unsigned NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  `id_customer` int(10) unsigned NOT NULL,
  `id_cart` int(10) unsigned NOT NULL,
  `id_currency` int(10) unsigned NOT NULL,
  `id_address_delivery` int(10) unsigned NOT NULL,
  `id_address_invoice` int(10) unsigned NOT NULL,
  `current_state` int(10) unsigned NOT NULL,
  `secure_key` varchar(32) NOT NULL DEFAULT '-1',
  `payment` varchar(255) NOT NULL,
  `conversion_rate` decimal(13,6) NOT NULL DEFAULT 1.000000,
  `module` varchar(255) DEFAULT NULL,
  `recyclable` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `gift` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `gift_message` text DEFAULT NULL,
  `mobile_theme` tinyint(1) NOT NULL DEFAULT 0,
  `shipping_number` varchar(64) DEFAULT NULL,
  `total_discounts` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `total_discounts_tax_incl` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `total_discounts_tax_excl` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `total_paid` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `total_paid_tax_incl` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `total_paid_tax_excl` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `total_paid_real` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `total_products` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `total_products_wt` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `total_shipping` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `total_shipping_tax_incl` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `total_shipping_tax_excl` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `carrier_tax_rate` decimal(10,3) NOT NULL DEFAULT 0.000,
  `total_wrapping` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `total_wrapping_tax_incl` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `total_wrapping_tax_excl` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `round_mode` tinyint(1) NOT NULL DEFAULT 2,
  `round_type` tinyint(1) NOT NULL DEFAULT 1,
  `invoice_number` int(10) unsigned NOT NULL DEFAULT 0,
  `delivery_number` int(10) unsigned NOT NULL DEFAULT 0,
  `invoice_date` datetime NOT NULL,
  `delivery_date` datetime NOT NULL,
  `valid` int(1) unsigned NOT NULL DEFAULT 0,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  PRIMARY KEY (`id_order`),
  KEY `reference` (`reference`),
  KEY `id_customer` (`id_customer`),
  KEY `id_cart` (`id_cart`),
  KEY `invoice_number` (`invoice_number`),
  KEY `id_carrier` (`id_carrier`),
  KEY `id_lang` (`id_lang`),
  KEY `id_currency` (`id_currency`),
  KEY `id_address_delivery` (`id_address_delivery`),
  KEY `id_address_invoice` (`id_address_invoice`),
  KEY `id_shop_group` (`id_shop_group`),
  KEY `current_state` (`current_state`),
  KEY `id_shop` (`id_shop`),
  KEY `date_add` (`date_add`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leanps_orders`
--

LOCK TABLES `leanps_orders` WRITE;
/*!40000 ALTER TABLE `leanps_orders` DISABLE KEYS */;
INSERT INTO `leanps_orders` VALUES (5,'TNHBSROQD',1,1,8,2,6,17,1,6,6,2,'97a55db8afb4abecac01b93da3101007','PayPal',1.000000,'paypal',0,0,NULL,0,NULL,0.000000,0.000000,0.000000,394.680000,394.680000,330.000000,394.680000,300.000000,358.800000,35.880000,35.880000,30.000000,19.600,0.000000,0.000000,0.000000,2,1,1,0,'2013-07-25 16:37:28','0000-00-00 00:00:00',1,'2013-07-25 16:37:28','2013-07-25 16:37:28'),(11,'ZEKAPAYQT',1,1,18,1,11,33,1,9,9,8,'07c8cd4fbe693f701b4b0f837083bc68','PayPal',1.000000,'paypal',0,0,NULL,0,NULL,0.000000,0.000000,0.000000,353.940000,353.940000,297.100000,0.000000,290.000000,346.840000,7.100000,7.100000,7.100000,0.000,0.000000,0.000000,0.000000,2,1,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,'2013-08-02 02:53:35','2013-08-02 02:53:35'),(12,'RICDMWNEI',1,1,18,1,11,37,1,11,11,8,'07c8cd4fbe693f701b4b0f837083bc68','PayPal',1.000000,'paypal',0,0,NULL,0,NULL,0.000000,0.000000,0.000000,327.070000,327.070000,274.550000,0.000000,267.990000,320.520000,6.560000,6.560000,6.560000,0.000,0.000000,0.000000,0.000000,2,1,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,'2013-08-02 02:59:43','2013-08-06 10:36:29'),(13,'GVMRSLPSQ',1,1,18,2,12,43,1,13,13,8,'4d39f1b73e0aba63bdf133e37f851934','PayPal',1.000000,'paypal',0,0,NULL,0,NULL,0.000000,0.000000,0.000000,353.940000,353.940000,297.100000,0.000000,290.000000,346.840000,7.100000,7.100000,7.100000,0.000,0.000000,0.000000,0.000000,2,1,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,'2013-08-27 03:10:40','2013-08-27 03:10:40'),(14,'FAXKUZVZF',1,1,18,2,12,47,1,13,13,8,'4d39f1b73e0aba63bdf133e37f851934','PayPal',1.000000,'paypal',0,0,NULL,0,NULL,0.000000,0.000000,0.000000,353.940000,353.940000,297.100000,0.000000,290.000000,346.840000,7.100000,7.100000,7.100000,0.000,0.000000,0.000000,0.000000,2,1,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,'2013-08-27 03:18:34','2013-08-27 03:18:34'),(15,'OYNEEBXXW',1,1,18,2,15,48,1,15,15,8,'4041100630244ca7ce5ad7ea43fb9dcd','PayPal',1.000000,'paypal',0,0,NULL,0,NULL,0.000000,0.000000,0.000000,353.940000,353.940000,297.100000,0.000000,290.000000,346.840000,7.100000,7.100000,7.100000,0.000,0.000000,0.000000,0.000000,2,1,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,'2013-08-29 06:49:45','2013-08-29 06:49:45'),(16,'RYQTQGNHX',1,1,18,2,15,49,1,16,16,2,'4041100630244ca7ce5ad7ea43fb9dcd','PayPal',1.000000,'paypal',0,0,NULL,0,NULL,0.000000,0.000000,0.000000,353.940000,353.940000,297.100000,353.940000,290.000000,346.840000,7.100000,7.100000,7.100000,0.000,0.000000,0.000000,0.000000,2,1,97,0,'2013-08-29 06:54:27','0000-00-00 00:00:00',1,'2013-08-29 06:54:27','2013-08-29 06:54:27'),(17,'FAYVRUTLE',1,1,0,2,17,66,1,17,17,2,'0784999754a264c9e38d9671d6f9a91c','Chèque',1.000000,'cheque',0,0,NULL,0,NULL,0.000000,0.000000,0.000000,75.350000,75.350000,63.000000,75.350000,63.000000,75.350000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,98,0,'2013-11-18 16:07:45','0000-00-00 00:00:00',1,'2013-11-13 18:34:48','2013-11-18 16:07:45'),(18,'TVOGKYSAE',1,1,18,1,19,69,1,19,19,2,'c5b2304e7dd8a9f228d95071fc8bf93a','PayPal',1.000000,'paypal',0,0,NULL,0,NULL,0.000000,0.000000,0.000000,539.250000,539.250000,539.250000,539.250000,530.000000,530.000000,9.250000,9.250000,9.250000,0.000,0.000000,0.000000,0.000000,2,1,99,0,'2014-01-15 10:01:48','0000-00-00 00:00:00',1,'2014-01-15 10:01:47','2014-01-15 10:01:48'),(19,'HQYEUVREV',1,1,0,2,2,97,1,3,3,2,'bf2f30e6403f579d96a53338ad6f8855','Commande gratuite',1.000000,'free_order',0,0,NULL,0,NULL,114.820000,114.820000,96.000000,0.000000,0.000000,0.000000,0.000000,96.000000,114.820000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,100,0,'2014-09-04 14:38:31','0000-00-00 00:00:00',1,'2014-09-04 14:38:31','2014-09-04 14:38:31'),(20,'AMKPMQECO',1,1,18,2,24,108,1,22,23,9,'77dea994643207b690f360703fd56c46','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,355.100000,355.100000,297.100000,355.100000,290.000000,348.000000,7.100000,7.100000,7.100000,0.000,0.000000,0.000000,0.000000,2,1,101,0,'2014-11-28 10:48:35','0000-00-00 00:00:00',0,'2014-11-28 10:44:20','2014-11-28 10:48:55'),(21,'QVIYCQYLS',1,1,0,2,25,140,1,24,24,9,'2b7340b2090dce16b76874dd59a9442c','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,31.080000,31.080000,25.900000,31.080000,25.900000,31.080000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,102,0,'2015-04-30 09:02:08','0000-00-00 00:00:00',0,'2015-04-30 09:01:48','2015-04-30 09:02:29'),(22,'HWEVBQQXE',1,1,18,2,26,153,1,25,25,3,'3813c144b8032360329cb60d028fe109','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,355.100000,355.100000,297.100000,355.100000,290.000000,348.000000,7.100000,7.100000,7.100000,0.000,0.000000,0.000000,0.000000,2,1,103,0,'2015-05-26 16:28:28','0000-00-00 00:00:00',1,'2015-05-26 16:24:05','2015-06-17 12:25:30'),(23,'ARTNVEEEL',1,1,18,2,27,170,1,26,26,2,'3241cc0bc527f5418e41d9aedfdfa354','PayPal',1.000000,'paypal',0,0,'',0,'',104.400000,104.400000,87.000000,250.700000,250.700000,210.100000,250.700000,290.000000,348.000000,7.100000,7.100000,7.100000,0.000,0.000000,0.000000,0.000000,2,1,104,0,'2015-07-22 21:32:39','0000-00-00 00:00:00',1,'2015-07-22 21:31:35','2015-07-22 21:32:41'),(24,'VPBILMKLY',1,1,18,1,29,198,1,27,27,2,'52de63756dc40b74ae9da9b979bb3f7f','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,645.250000,645.250000,539.250000,645.250000,530.000000,636.000000,9.250000,9.250000,9.250000,0.000,0.000000,0.000000,0.000000,2,1,105,0,'2015-10-16 06:05:12','0000-00-00 00:00:00',1,'2015-10-16 06:05:09','2015-10-16 06:05:12'),(25,'ZZELQCSRT',1,1,18,2,30,217,1,28,28,2,'4527f50d9e9f09d18b18609f80a269d3','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,2808.000000,2808.000000,2340.000000,2808.000000,2340.000000,2808.000000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,106,0,'2016-01-21 15:47:02','0000-00-00 00:00:00',1,'2016-01-21 15:47:02','2016-01-21 15:47:02'),(26,'QLITOOSXW',1,1,18,2,31,222,1,29,29,2,'3dfe3cd89a1af93f16a87359504fb6dd','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,376.350000,376.350000,316.350000,376.350000,300.000000,360.000000,16.350000,16.350000,16.350000,0.000,0.000000,0.000000,0.000000,2,1,107,0,'2016-02-16 12:00:13','0000-00-00 00:00:00',1,'2016-02-16 12:00:13','2016-02-16 12:00:13'),(27,'GYHZZHCRP',1,1,18,2,31,225,1,29,29,2,'3dfe3cd89a1af93f16a87359504fb6dd','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,117.250000,117.250000,99.250000,117.250000,90.000000,108.000000,9.250000,9.250000,9.250000,0.000,0.000000,0.000000,0.000000,2,1,108,0,'2016-03-07 17:46:58','0000-00-00 00:00:00',1,'2016-03-07 17:46:58','2016-03-07 17:46:59'),(28,'WANBDMYWS',1,1,18,2,31,227,1,29,29,2,'3dfe3cd89a1af93f16a87359504fb6dd','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,972.000000,972.000000,810.000000,972.000000,810.000000,972.000000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,109,0,'2016-03-09 11:11:43','0000-00-00 00:00:00',1,'2016-03-09 11:11:43','2016-03-09 11:11:44'),(29,'CERFTSHOM',1,1,0,2,7,237,1,8,8,6,'a37570ed9133f4d984c0d2fa211b3eed','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,0.700000,0.700000,0.700000,0.700000,0.700000,0.700000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,97,0,'2016-04-29 14:41:46','0000-00-00 00:00:00',0,'2016-04-29 14:41:46','2016-04-29 14:44:51'),(30,'FGCADGZGE',1,1,18,2,33,242,1,31,32,2,'3175e22eac54c6970a0e43eedf925a80','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,80.200000,80.200000,68.200000,80.200000,60.000000,72.000000,8.200000,8.200000,8.200000,0.000,0.000000,0.000000,0.000000,2,1,110,0,'2016-05-09 10:06:24','0000-00-00 00:00:00',1,'2016-05-09 10:06:24','2016-05-09 10:06:24'),(31,'BCKSAANTF',1,1,0,2,7,256,1,8,33,2,'a37570ed9133f4d984c0d2fa211b3eed','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,0.600000,0.600000,0.500000,0.600000,0.500000,0.600000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,111,0,'2016-07-01 10:55:02','0000-00-00 00:00:00',1,'2016-07-01 10:55:01','2016-07-01 10:55:02'),(32,'FWJFDRIEE',1,1,18,2,34,292,1,34,36,2,'873ea6134cc7b346aafda2b37bfccade','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,80.200000,80.200000,68.200000,80.200000,60.000000,72.000000,8.200000,8.200000,8.200000,0.000,0.000000,0.000000,0.000000,2,1,112,0,'2016-10-03 16:53:26','0000-00-00 00:00:00',1,'2016-10-03 16:53:26','2016-10-03 16:53:27'),(33,'FEOVQOTOF',1,1,9,2,30,294,1,28,28,2,'4527f50d9e9f09d18b18609f80a269d3','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,1104.000000,1104.000000,920.000000,1104.000000,890.000000,1068.000000,36.000000,36.000000,30.000000,20.000,0.000000,0.000000,0.000000,2,1,113,0,'2016-10-07 12:48:03','0000-00-00 00:00:00',1,'2016-10-07 12:48:02','2016-10-07 12:48:03'),(34,'HEIRULKBV',1,1,9,2,30,295,1,28,28,2,'4527f50d9e9f09d18b18609f80a269d3','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,1104.000000,1104.000000,920.000000,1104.000000,890.000000,1068.000000,36.000000,36.000000,30.000000,20.000,0.000000,0.000000,0.000000,2,1,114,0,'2016-10-31 10:30:32','0000-00-00 00:00:00',1,'2016-10-31 10:30:32','2016-10-31 10:30:32'),(35,'SSZGSDVXE',1,1,18,2,35,297,1,37,37,2,'203b104131bf2e426be09afc769e1dac','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,413.900000,413.900000,346.100000,413.900000,339.000000,406.800000,7.100000,7.100000,7.100000,0.000,0.000000,0.000000,0.000000,2,1,115,0,'2016-11-14 11:13:48','0000-00-00 00:00:00',1,'2016-11-14 11:13:48','2016-11-14 11:13:48'),(36,'QCCNQAJFI',1,1,18,2,36,300,1,38,38,2,'d3b4dfc12af160a704fc36ad861c6eae','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,653.700000,653.700000,547.700000,653.700000,530.000000,636.000000,17.700000,17.700000,17.700000,0.000,0.000000,0.000000,0.000000,2,1,116,0,'2016-11-23 15:42:05','0000-00-00 00:00:00',1,'2016-11-23 15:42:04','2016-11-23 15:42:05'),(37,'DNEPIKZGR',1,1,18,2,37,365,1,39,39,10,'885274a2a9d496ddcc54cca5f6094bed','Virement bancaire',1.000000,'bankwire',0,0,'',0,'',0.000000,0.000000,0.000000,68.200000,68.200000,68.200000,0.000000,60.000000,60.000000,8.200000,8.200000,8.200000,0.000,0.000000,0.000000,0.000000,2,1,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,'2017-04-20 16:12:03','2017-04-20 16:12:03'),(38,'ICQJIOEUB',1,1,18,2,38,381,1,40,40,2,'1e580763c701c6edfc3ce55dd8cb189a','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,357.250000,357.250000,299.250000,357.250000,290.000000,348.000000,9.250000,9.250000,9.250000,0.000,0.000000,0.000000,0.000000,2,1,117,0,'2017-05-18 22:28:12','0000-00-00 00:00:00',1,'2017-05-18 22:28:11','2017-05-18 22:28:12'),(39,'EBHMRDWEH',1,1,26,2,54,418,1,59,59,10,'c16bb986e9489a6b7a55835b278394a2','Virement bancaire',1.000000,'bankwire',0,0,'',0,'',0.000000,0.000000,0.000000,51.840000,51.840000,43.200000,0.000000,25.000000,30.000000,21.840000,21.840000,18.200000,20.000,0.000000,0.000000,0.000000,2,1,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,'2017-07-07 18:58:17','2017-07-07 18:58:17'),(40,'GKAMGEPVD',1,1,28,2,57,421,1,62,62,1,'4a5cf35755a35337e3d51094350d3503','Chèque',1.000000,'cheque',0,0,'',0,'',0.000000,0.000000,0.000000,360.000000,360.000000,302.000000,0.000000,290.000000,348.000000,12.000000,12.000000,12.000000,0.000,0.000000,0.000000,0.000000,2,1,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,'2017-07-10 12:16:16','2017-07-10 12:16:16'),(41,'HRRVFQMLM',1,1,28,2,58,427,1,63,63,1,'749cbabd8d74111b7685a7b1802327ed','Chèque',1.000000,'cheque',0,0,'',1,'',0.000000,0.000000,0.000000,38.000000,38.000000,33.000000,0.000000,25.000000,30.000000,8.000000,8.000000,8.000000,0.000,0.000000,0.000000,0.000000,2,1,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,'2017-07-12 08:31:11','2017-07-12 08:31:11'),(42,'GRYUBKIHM',1,1,29,2,59,432,1,64,64,10,'4d5274b00010a31124b52e9aa67bcc87','Virement bancaire',1.000000,'bankwire',0,0,'',0,'',0.000000,0.000000,0.000000,381.840000,381.840000,318.200000,0.000000,300.000000,360.000000,21.840000,21.840000,18.200000,20.000,0.000000,0.000000,0.000000,2,1,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,'2017-07-31 17:33:50','2017-07-31 17:33:50'),(43,'NENAPXOKP',1,1,29,2,61,438,1,66,66,1,'db094b4df68613153cfc469af807d526','Chèque',1.000000,'cheque',0,0,'',0,'',0.000000,0.000000,0.000000,309.840000,309.840000,258.200000,0.000000,240.000000,288.000000,21.840000,21.840000,18.200000,20.000,0.000000,0.000000,0.000000,2,1,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,'2017-08-24 16:20:01','2017-08-24 16:20:01'),(44,'BVKHWCJZL',1,1,33,2,61,439,1,66,66,1,'db094b4df68613153cfc469af807d526','Chèque',1.000000,'cheque',0,0,'',0,'',0.000000,0.000000,0.000000,0.840000,0.840000,0.700000,0.000000,0.700000,0.840000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,'2017-08-30 20:01:55','2017-08-30 20:01:55'),(45,'VKEIYQCAG',1,1,0,2,62,440,1,68,68,2,'367fd062eea6344dd37774316d9adfc0','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,0.840000,0.840000,0.700000,0.840000,0.700000,0.840000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,118,0,'2017-09-01 10:05:22','0000-00-00 00:00:00',1,'2017-09-01 10:05:22','2017-09-01 10:05:22'),(46,'HFVTYCNOV',1,1,0,2,62,443,1,68,68,2,'367fd062eea6344dd37774316d9adfc0','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,0.840000,0.840000,0.700000,0.840000,0.700000,0.840000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,119,0,'2017-09-07 11:42:24','0000-00-00 00:00:00',1,'2017-09-07 11:42:24','2017-09-07 11:42:24'),(47,'PKOBYYNSQ',1,1,29,2,63,455,1,69,69,2,'7f47fde3ef369e1231a2d4424972aee9','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,1089.840000,1089.840000,908.200000,1089.840000,890.000000,1068.000000,21.840000,21.840000,18.200000,20.000,0.000000,0.000000,0.000000,2,1,120,0,'2017-11-29 09:48:57','0000-00-00 00:00:00',1,'2017-11-29 09:48:56','2017-11-29 09:48:57'),(48,'BBASDMAOQ',1,1,33,2,64,458,1,70,70,2,'9227921b99d58a50b0e21a010612c5a8','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,348.840000,348.840000,290.700000,348.840000,290.700000,348.840000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,121,0,'2017-12-08 13:56:02','0000-00-00 00:00:00',1,'2017-12-08 13:56:01','2017-12-08 13:56:02'),(49,'BTTUXUPQW',1,1,33,2,66,467,1,72,72,2,'2b02368d90d4eefddc96118f59064a13','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,25.190000,25.190000,20.990000,25.190000,20.990000,25.190000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,122,0,'2018-02-25 10:57:50','0000-00-00 00:00:00',1,'2018-02-25 10:57:49','2018-02-25 10:57:50'),(50,'ASWYEMCTO',1,1,33,2,67,574,1,73,73,2,'678b11c0a63b393df3d022412cd938f2','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,0.840000,0.840000,0.700000,0.840000,0.700000,0.840000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,123,0,'2018-11-17 11:48:42','0000-00-00 00:00:00',1,'2018-11-17 11:48:42','2018-11-17 11:48:42'),(51,'FPJFZXERW',1,1,0,2,67,575,1,73,73,2,'678b11c0a63b393df3d022412cd938f2','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,0.420000,0.420000,0.350000,0.420000,0.350000,0.420000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,124,0,'2018-11-17 15:20:20','0000-00-00 00:00:00',1,'2018-11-17 15:20:20','2018-11-17 15:20:20'),(52,'JTSYBDMVQ',1,1,28,1,68,594,1,74,74,2,'d69decd879c49b15a6214766db06cafe','Bank wire',1.000000,'bankwire',0,0,'',0,'',0.000000,0.000000,0.000000,348.000000,348.000000,290.000000,348.000000,290.000000,348.000000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,1,0,'2021-01-22 10:50:00','0000-00-00 00:00:00',1,'2019-03-14 12:07:24','2021-01-22 10:50:02'),(53,'SLVQYIYUZ',1,1,29,2,70,603,1,76,76,2,'335e5839cc5b2a6b9ad685e698da4877','Virement bancaire',1.000000,'bankwire',0,0,'',0,'',0.000000,0.000000,0.000000,56.640000,56.640000,47.200000,56.640000,29.000000,34.800000,21.840000,21.840000,18.200000,20.000,0.000000,0.000000,0.000000,2,1,130,0,'2019-12-03 10:16:07','0000-00-00 00:00:00',1,'2019-04-18 14:46:13','2019-12-03 10:16:08'),(54,'YAJDOYFNU',1,1,28,2,70,618,1,77,77,2,'335e5839cc5b2a6b9ad685e698da4877','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,154.200000,154.200000,131.000000,154.200000,116.000000,139.200000,15.000000,15.000000,15.000000,0.000,0.000000,0.000000,0.000000,2,1,1,0,'2019-07-11 10:52:48','0000-00-00 00:00:00',1,'2019-07-11 10:52:47','2019-07-11 10:52:48'),(55,'ZGVMKEYHH',1,1,0,1,75,630,1,79,79,10,'8e7995f03de7389ce2a4d2e7d7533785','Transfert bancaire',1.000000,'ps_wirepayment',0,0,'',0,'',0.000000,0.000000,0.000000,0.590000,0.590000,0.490000,0.000000,0.490000,0.590000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,'2019-08-15 15:02:09','2019-08-15 15:02:16'),(56,'KBZQJTIJS',1,1,0,2,65,637,1,83,83,5,'5ab79da0835c8e1fc53856a857adb5ba','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,1.680000,1.680000,1.400000,1.680000,1.400000,1.680000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,125,1,'2019-08-17 10:47:05','2019-08-17 10:55:12',1,'2019-08-17 10:47:03','2019-08-17 10:55:12'),(57,'JXHQPCAQC',1,1,0,2,78,638,1,84,84,2,'04116872b1197abdcd49ea4211c1cee7','Commande gratuite',1.000000,'free_order',0,0,'',0,'',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,126,0,'2019-08-18 10:29:17','0000-00-00 00:00:00',1,'2019-08-18 10:29:16','2019-08-18 10:29:18'),(58,'AGFYMLHXL',1,1,0,2,79,642,1,85,85,2,'cd0d322f3788e22ff4cf53e4ba1cad63','Commande gratuite',1.000000,'free_order',0,0,'',0,'',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,127,0,'2019-10-15 16:21:18','0000-00-00 00:00:00',1,'2019-10-15 16:21:16','2019-10-15 16:21:19'),(59,'JXMONNXFY',1,1,0,2,80,644,1,86,86,2,'f2904aa1607e1c59f02ae56155c1cadb','Commande gratuite',1.000000,'free_order',0,0,'',0,'',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,128,0,'2019-10-16 22:06:52','0000-00-00 00:00:00',1,'2019-10-16 22:06:51','2019-10-16 22:06:53'),(60,'ROUZMPXUT',1,1,0,1,84,649,1,88,88,2,'92116e3c100476cfa169871a8a9301e7','Free order',1.000000,'free_order',0,0,'',0,'',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,129,0,'2019-10-23 00:09:40','0000-00-00 00:00:00',1,'2019-10-23 00:09:39','2019-10-23 00:09:41'),(61,'DXPEHROEX',1,1,65,2,92,672,1,96,96,2,'945555d7b96a33b2fb02b1dc30c7a94e','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,354.000000,354.000000,295.000000,354.000000,295.000000,354.000000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,1,0,'2020-02-22 05:42:22','0000-00-00 00:00:00',1,'2020-02-22 05:42:20','2020-02-22 05:42:22'),(62,'TIFMKWVQG',1,1,0,2,94,677,1,98,98,2,'6a658829761c360d3857ae0faaeb0e14','Commande gratuite',1.000000,'free_order',0,0,'',0,'',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,2,0,'2020-05-12 07:19:06','0000-00-00 00:00:00',1,'2020-05-12 07:19:04','2020-05-12 07:19:07'),(63,'EKBHRUURO',1,1,69,2,96,687,1,99,99,10,'a6f245fbe86e7c853883556846ae9664','Transfert bancaire',1.000000,'ps_wirepayment',0,0,'',0,'',0.000000,0.000000,0.000000,119.600000,119.600000,101.000000,0.000000,93.000000,111.600000,8.000000,8.000000,8.000000,0.000,0.000000,0.000000,0.000000,2,1,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,'2020-10-12 10:36:25','2020-10-12 10:36:26'),(64,'EBSNLYKFO',1,1,69,2,96,689,1,99,99,2,'a6f245fbe86e7c853883556846ae9664','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,119.600000,119.600000,101.000000,119.600000,93.000000,111.600000,8.000000,8.000000,8.000000,0.000,0.000000,0.000000,0.000000,2,1,3,0,'2020-10-20 15:52:23','0000-00-00 00:00:00',1,'2020-10-20 15:52:21','2020-10-20 15:52:23'),(65,'RIZQDKKBX',1,1,69,2,99,700,1,101,101,10,'c059429f197407166bdb8c1fdc82a1b5','Transfert bancaire',1.000000,'ps_wirepayment',0,0,'',0,'',0.000000,0.000000,0.000000,361.000000,361.000000,303.000000,0.000000,290.000000,348.000000,13.000000,13.000000,13.000000,0.000,0.000000,0.000000,0.000000,2,1,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,'2021-04-15 12:17:18','2021-04-15 12:17:24'),(66,'LMEOYGOLU',1,1,69,2,100,701,1,102,102,2,'5de36aa3a09de7bbe99ba9b984ac5099','Transfert bancaire',1.000000,'ps_wirepayment',0,0,'',0,'',0.000000,0.000000,0.000000,361.000000,361.000000,303.000000,361.000000,290.000000,348.000000,13.000000,13.000000,13.000000,0.000,0.000000,0.000000,0.000000,2,1,2,0,'2021-04-24 19:35:07','0000-00-00 00:00:00',1,'2021-04-15 12:21:05','2021-04-24 19:35:08'),(67,'NUAKBTPTI',1,1,69,1,103,711,1,104,104,2,'39a187ba67c67d94c16a1825a838d6a6','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,361.000000,361.000000,303.000000,361.000000,290.000000,348.000000,13.000000,13.000000,13.000000,0.000,0.000000,0.000000,0.000000,2,1,1,0,'2022-04-06 09:58:05','0000-00-00 00:00:00',1,'2022-04-06 09:58:05','2022-04-06 09:58:05'),(68,'RRLVNGPSR',1,1,69,2,104,716,1,105,105,2,'ec0db1bcc977dde9371b4ed683433269','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,361.000000,361.000000,303.000000,361.000000,290.000000,348.000000,13.000000,13.000000,13.000000,0.000,0.000000,0.000000,0.000000,2,1,2,0,'2022-07-26 14:10:29','0000-00-00 00:00:00',1,'2022-07-26 14:10:27','2022-07-26 14:10:29'),(69,'IDNDLSLOG',1,1,69,2,108,6247,1,111,111,2,'a843deaf8a4dd969582dd529108adbfa','PayPal',1.000000,'paypal',0,0,'',0,'',0.000000,0.000000,0.000000,119.600000,119.600000,101.000000,119.600000,93.000000,111.600000,8.000000,8.000000,8.000000,0.000,0.000000,0.000000,0.000000,2,1,1,0,'2023-04-11 14:20:27','0000-00-00 00:00:00',1,'2023-04-11 14:20:25','2023-04-11 14:20:29'),(70,'CLZEJBCUQ',1,1,69,2,114,6350,1,113,113,10,'1346571b251958465a50d96ef4e4cc79','Transfert bancaire',1.000000,'ps_wirepayment',0,0,'',0,'',0.000000,0.000000,0.000000,119.600000,119.600000,101.000000,0.000000,93.000000,111.600000,8.000000,8.000000,8.000000,0.000,0.000000,0.000000,0.000000,2,1,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,'2023-12-18 16:49:16','2023-12-18 16:49:17'),(71,'RDEPAWXER',1,1,69,2,70,6386,1,120,120,10,'335e5839cc5b2a6b9ad685e698da4877','Transfert bancaire',1.000000,'ps_wirepayment',0,0,'',0,'',0.000000,0.000000,0.000000,513.600000,513.600000,428.000000,0.000000,428.000000,513.600000,0.000000,0.000000,0.000000,0.000,0.000000,0.000000,0.000000,2,1,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,'2024-06-07 15:07:27','2024-06-07 15:07:29');
/*!40000 ALTER TABLE `leanps_orders` 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:31
