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

DROP TABLE IF EXISTS `leanps_order_detail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `leanps_order_detail` (
  `id_order_detail` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_order` int(10) unsigned NOT NULL,
  `id_order_invoice` int(11) DEFAULT NULL,
  `id_warehouse` int(10) unsigned DEFAULT 0,
  `id_shop` int(11) unsigned NOT NULL,
  `product_id` int(10) unsigned NOT NULL,
  `product_attribute_id` int(10) unsigned DEFAULT NULL,
  `id_customization` int(10) unsigned DEFAULT 0,
  `product_name` varchar(255) NOT NULL,
  `product_quantity` int(10) unsigned NOT NULL DEFAULT 0,
  `product_quantity_in_stock` int(10) NOT NULL DEFAULT 0,
  `product_quantity_refunded` int(10) unsigned NOT NULL DEFAULT 0,
  `product_quantity_return` int(10) unsigned NOT NULL DEFAULT 0,
  `product_quantity_reinjected` int(10) unsigned NOT NULL DEFAULT 0,
  `product_price` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `reduction_percent` decimal(10,2) NOT NULL DEFAULT 0.00,
  `reduction_amount` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `reduction_amount_tax_incl` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `reduction_amount_tax_excl` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `group_reduction` decimal(10,2) NOT NULL DEFAULT 0.00,
  `product_quantity_discount` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `product_ean13` varchar(13) DEFAULT NULL,
  `product_isbn` varchar(32) DEFAULT NULL,
  `product_upc` varchar(12) DEFAULT NULL,
  `product_reference` varchar(64) DEFAULT NULL,
  `product_supplier_reference` varchar(64) DEFAULT NULL,
  `product_weight` decimal(20,6) NOT NULL,
  `id_tax_rules_group` int(11) unsigned DEFAULT 0,
  `tax_computation_method` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `tax_name` varchar(16) NOT NULL,
  `tax_rate` decimal(10,3) NOT NULL DEFAULT 0.000,
  `ecotax` decimal(21,6) NOT NULL DEFAULT 0.000000,
  `ecotax_tax_rate` decimal(5,3) NOT NULL DEFAULT 0.000,
  `discount_quantity_applied` tinyint(1) NOT NULL DEFAULT 0,
  `download_hash` varchar(255) DEFAULT NULL,
  `download_nb` int(10) unsigned DEFAULT 0,
  `download_deadline` datetime DEFAULT NULL,
  `total_price_tax_incl` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `total_price_tax_excl` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `unit_price_tax_incl` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `unit_price_tax_excl` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `total_shipping_price_tax_incl` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `total_shipping_price_tax_excl` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `purchase_supplier_price` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `original_product_price` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `original_wholesale_price` decimal(20,6) NOT NULL DEFAULT 0.000000,
  PRIMARY KEY (`id_order_detail`),
  KEY `order_detail_order` (`id_order`),
  KEY `product_id` (`product_id`,`product_attribute_id`),
  KEY `product_attribute_id` (`product_attribute_id`),
  KEY `id_tax_rules_group` (`id_tax_rules_group`),
  KEY `id_order_id_order_detail` (`id_order`,`id_order_detail`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leanps_order_detail`
--

LOCK TABLES `leanps_order_detail` WRITE;
/*!40000 ALTER TABLE `leanps_order_detail` DISABLE KEYS */;
INSERT INTO `leanps_order_detail` VALUES (3,2,0,0,1,1,31,0,'jeu smed - Capacité : 16Go, Couleur : Noir',1,1,0,0,0,431.806020,5.00,0.000000,0.000000,0.000000,0.00,490.620000,NULL,NULL,NULL,NULL,NULL,0.500000,0,0,'TVA FR 19.6%',19.600,0.000000,0.000,0,NULL,0,NULL,490.620000,410.217391,490.620000,410.217391,0.000000,0.000000,0.000000,0.000000,0.000000),(4,3,6,0,1,14,0,0,'SMED : slides de présentation',1,0,0,0,0,1.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,NULL,NULL,NULL,NULL,NULL,0.000000,0,0,'',0.000,0.000000,0.000,0,'5fa6fc5bc89ddebf0f0ee825017d49d145c2117b',0,NULL,1.200000,1.000000,1.200000,1.000000,0.000000,0.000000,0.000000,1.000000,0.000000),(5,4,0,0,1,43,0,0,'5S : Les étiquettes rouges',1,0,0,0,0,30.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,NULL,NULL,NULL,'5s-etiquettes-rouges',NULL,1.000000,0,0,'',0.000,0.000000,0.000,0,NULL,0,NULL,35.880000,30.000000,35.880000,30.000000,0.000000,0.000000,0.000000,30.000000,0.000000),(6,5,1,0,1,43,0,0,'5S : Les étiquettes rouges',10,-1,0,0,0,30.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,NULL,NULL,NULL,'5s-etiquettes-rouges',NULL,1.000000,0,0,'',0.000,0.000000,0.000,0,NULL,0,NULL,358.800000,300.000000,35.880000,30.000000,0.000000,0.000000,0.000000,30.000000,0.000000),(7,6,2,0,1,46,0,0,'5S : jeu pédagogique',1,0,0,0,0,96.000000,100.00,0.000000,0.000000,0.000000,0.00,1.196000,NULL,NULL,NULL,'jeu 5S',NULL,0.000000,0,0,'',0.000,0.000000,0.000,0,'c5cab2fff98ce06b3273c54a0b54fec0725ffe50',2,NULL,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,96.000000,0.000000),(8,7,3,0,1,46,0,0,'5S : jeu pédagogique',1,-1,0,0,0,96.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,NULL,NULL,NULL,'jeu 5S',NULL,0.000000,0,0,'',0.000,0.000000,0.000,0,'eedc06379801c7d57c555a00033c7ba9454fee19',0,NULL,114.820000,96.000000,114.820000,96.000000,0.000000,0.000000,0.000000,96.000000,0.000000),(9,8,4,0,1,46,0,0,'5S : jeu pédagogique',1,-2,0,0,0,96.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,NULL,NULL,NULL,'jeu 5S',NULL,0.000000,0,0,'',0.000,0.000000,0.000,0,'e1b0b8158a0d1b60ca8853042a8546f84f046db1',0,NULL,114.820000,96.000000,114.820000,96.000000,0.000000,0.000000,0.000000,96.000000,0.000000),(11,10,7,0,1,46,0,0,'5S : jeu pédagogique',1,-4,0,0,0,96.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,NULL,NULL,NULL,'jeu 5S',NULL,0.000000,0,0,'',0.000,0.000000,0.000,0,'275bb300d82ce63debb1be92de3df1d1710a38a5',1,NULL,114.820000,96.000000,114.820000,96.000000,0.000000,0.000000,0.000000,96.000000,0.000000),(12,11,0,0,1,15,0,0,'SMED : le jeu pédagogique',1,0,0,0,0,290.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,NULL,NULL,NULL,'jeu-smed',NULL,0.900000,0,0,'',0.000,0.000000,0.000,0,NULL,0,NULL,346.840000,290.000000,346.840000,290.000000,0.000000,0.000000,0.000000,290.000000,0.000000),(13,12,0,0,1,15,0,0,'SMED : le jeu pédagogique',1,0,0,0,0,267.990000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,NULL,NULL,NULL,'jeu-smed',NULL,0.900000,0,0,'',0.000,0.000000,0.000,0,NULL,0,NULL,320.520000,267.990000,320.520000,267.990000,0.000000,0.000000,0.000000,267.990000,0.000000),(14,13,0,0,1,15,0,0,'SMED : le jeu pédagogique (seul)',1,0,0,0,0,290.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,NULL,NULL,NULL,'jeu-smed',NULL,0.900000,0,0,'',0.000,0.000000,0.000,0,NULL,0,NULL,346.840000,290.000000,346.840000,290.000000,0.000000,0.000000,0.000000,290.000000,0.000000),(15,14,0,0,1,15,0,0,'SMED : le jeu pédagogique (seul)',1,0,0,0,0,290.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,NULL,NULL,NULL,'jeu-smed',NULL,0.900000,0,0,'',0.000,0.000000,0.000,0,NULL,0,NULL,346.840000,290.000000,346.840000,290.000000,0.000000,0.000000,0.000000,290.000000,0.000000),(16,15,0,0,1,15,0,0,'SMED : le jeu pédagogique (seul)',1,0,0,0,0,290.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,NULL,NULL,NULL,'jeu-smed',NULL,0.900000,0,0,'',0.000,0.000000,0.000,0,NULL,0,NULL,346.840000,290.000000,346.840000,290.000000,0.000000,0.000000,0.000000,290.000000,0.000000),(17,16,8,0,1,15,0,0,'SMED : le jeu pédagogique (seul)',1,0,0,0,0,290.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,NULL,NULL,NULL,'jeu-smed',NULL,0.900000,0,0,'',0.000,0.000000,0.000,0,NULL,0,NULL,346.840000,290.000000,346.840000,290.000000,0.000000,0.000000,0.000000,290.000000,0.000000),(18,17,9,0,1,59,0,0,'Package Créativité',1,0,0,0,0,90.000000,30.00,0.000000,0.000000,0.000000,0.00,76.546000,NULL,NULL,NULL,NULL,NULL,0.000000,0,0,'',0.000,0.000000,0.000,0,'5031d183b1ae4f79f17f2c6e776216259d50b8c4',1,NULL,75.350000,63.000000,75.350000,63.000000,0.000000,0.000000,90.000000,90.000000,0.000000),(19,18,10,0,1,1,0,0,'Smed Game',1,1,0,0,0,530.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,NULL,NULL,NULL,NULL,NULL,2.500000,0,1,'',0.000,0.000000,0.000,0,NULL,0,NULL,530.000000,530.000000,530.000000,530.000000,0.000000,0.000000,0.000000,530.000000,0.000000),(20,19,11,0,1,46,0,0,'5S : le jeu pédagogique (seul)',1,-5,0,0,0,96.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,NULL,NULL,NULL,'jeu 5S',NULL,0.000000,0,0,'',0.000,0.000000,0.000,0,'ddec4bf5d582fb006b9212098ea937bcb6b58bf3',1,NULL,114.820000,96.000000,114.820000,96.000000,0.000000,0.000000,0.000000,96.000000,0.000000),(21,20,12,0,1,15,0,0,'SMED : le jeu pédagogique (seul)',1,-1,0,0,0,290.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','jeu-smed','',0.900000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,348.000000,290.000000,348.000000,290.000000,0.000000,0.000000,0.000000,290.000000,0.000000),(22,21,13,0,1,46,0,0,'5S : le jeu pédagogique (seul)',1,-6,0,0,0,37.000000,30.00,0.000000,0.000000,0.000000,0.00,32.280000,'',NULL,'','jeu 5S','',0.000000,0,0,'',0.000,0.000000,0.000,0,'5708206b7fcd17847d2942059dc61d47ec756fec',1,NULL,31.080000,25.900000,31.080000,25.900000,0.000000,0.000000,0.000000,37.000000,0.000000),(23,22,14,0,1,15,0,0,'SMED : le jeu pédagogique (seul)',1,-2,0,0,0,290.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','jeu-smed','',0.900000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,348.000000,290.000000,348.000000,290.000000,0.000000,0.000000,0.000000,290.000000,0.000000),(24,23,15,0,1,15,0,0,'SMED : le jeu pédagogique (seul)',1,1,0,0,0,290.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','jeu-smed','',0.900000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,348.000000,290.000000,348.000000,290.000000,0.000000,0.000000,0.000000,290.000000,0.000000),(25,24,16,0,1,1,0,0,'SMED : The Complete Package',1,1,0,0,0,530.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','','',2.500000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,636.000000,530.000000,636.000000,530.000000,0.000000,0.000000,0.000000,530.000000,0.000000),(26,25,17,0,1,51,0,0,'Kanban : le jeu pédagogique',1,0,0,0,0,890.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','','',8.500000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,1068.000000,890.000000,1068.000000,890.000000,0.000000,0.000000,0.000000,890.000000,0.000000),(27,25,17,0,1,15,0,0,'SMED : le jeu pédagogique (seul)',5,5,0,0,0,290.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','jeu-smed','',0.900000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,1740.000000,1450.000000,348.000000,290.000000,0.000000,0.000000,0.000000,290.000000,0.000000),(28,26,18,0,1,43,0,0,'5S : Lot de 100 étiquettes rouges',10,10,0,0,0,30.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','5s-etiquettes-rouges','',0.900000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,360.000000,300.000000,36.000000,30.000000,0.000000,0.000000,0.000000,30.000000,0.000000),(29,27,19,0,1,43,0,0,'5S : Lot de 100 étiquettes rouges',3,3,0,0,0,30.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','5s-etiquettes-rouges','',0.900000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,108.000000,90.000000,36.000000,30.000000,0.000000,0.000000,0.000000,30.000000,0.000000),(30,28,20,0,1,43,0,0,'5S : Lot de 100 étiquettes rouges',27,7,0,0,0,30.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','5s-etiquettes-rouges','',0.900000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,972.000000,810.000000,36.000000,30.000000,0.000000,0.000000,0.000000,30.000000,0.000000),(31,29,21,0,1,60,0,0,'Pour test',1,0,1,0,0,1.000000,30.00,0.000000,0.000000,0.000000,0.00,1.700000,'',NULL,'','0010010012','',0.000000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,0.700000,0.700000,0.700000,0.700000,0.000000,0.000000,0.000000,1.000000,0.000000),(32,30,22,0,1,43,0,0,'5S : Lot de 100 étiquettes rouges',2,-20,0,0,0,30.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','5s-etiquettes-rouges','',0.900000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,72.000000,60.000000,36.000000,30.000000,0.000000,0.000000,0.000000,30.000000,0.000000),(33,31,23,0,1,14,0,0,'SMED : slides de présentation',1,-1,1,0,0,0.500000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','smed-sp','',0.000000,0,0,'',0.000,0.000000,0.000,0,'d33f085b115cba8112dd559ed75d5369adeb1b68',0,NULL,0.600000,0.500000,0.600000,0.500000,0.000000,0.000000,0.000000,0.500000,0.000000),(34,32,24,0,1,43,0,0,'5S : Lot de 100 étiquettes rouges',2,-22,0,0,0,30.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','5s-etiquettes-rouges','',0.900000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,72.000000,60.000000,36.000000,30.000000,0.000000,0.000000,0.000000,30.000000,0.000000),(35,33,25,0,1,51,0,0,'Kanban : le jeu pédagogique',1,-1,0,0,0,890.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','','',8.500000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,1068.000000,890.000000,1068.000000,890.000000,0.000000,0.000000,0.000000,890.000000,0.000000),(36,34,26,0,1,51,0,0,'Kanban : le jeu pédagogique',1,-2,0,0,0,890.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','','',8.500000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,1068.000000,890.000000,1068.000000,890.000000,0.000000,0.000000,0.000000,890.000000,0.000000),(37,35,27,0,1,15,0,0,'SMED : le jeu pédagogique (seul)',1,1,0,0,0,290.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','jeu-smed','',0.900000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,348.000000,290.000000,348.000000,290.000000,0.000000,0.000000,0.000000,290.000000,0.000000),(38,35,27,0,1,46,0,0,'5S : le jeu pédagogique (seul)',1,1,0,0,0,70.000000,30.00,0.000000,0.000000,0.000000,0.00,60.000000,'',NULL,'','jeu 5S','',0.000000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,58.800000,49.000000,58.800000,49.000000,0.000000,0.000000,0.000000,70.000000,0.000000),(39,36,28,0,1,1,0,0,'SMED : le package complet',1,1,0,0,0,530.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','','',1.950000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,636.000000,530.000000,636.000000,530.000000,11.400000,9.500000,0.000000,530.000000,0.000000),(40,37,0,0,1,43,0,0,'5S : Lot de 100 étiquettes rouges',2,-24,0,0,0,30.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','5s-etiquettes-rouges','',0.900000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,60.000000,60.000000,30.000000,30.000000,0.000000,0.000000,0.000000,30.000000,0.000000),(41,38,29,0,1,50,0,0,'Jeu Logistique',1,0,0,0,0,290.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','','',2.500000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,348.000000,290.000000,348.000000,290.000000,0.000000,0.000000,0.000000,290.000000,0.000000),(42,39,0,0,1,44,0,0,' 5S : Lot de 10 cartes',1,0,0,0,0,25.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','cartes-5s','',0.400000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,30.000000,25.000000,30.000000,25.000000,0.000000,0.000000,25.000000,25.000000,0.000000),(43,40,0,0,1,50,0,0,'Jeu Logistique',1,-1,0,0,0,290.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','','',2.500000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,348.000000,290.000000,348.000000,290.000000,0.000000,0.000000,0.000000,290.000000,0.000000),(44,41,0,0,1,44,0,0,' 5S : Lot de 10 cartes',1,-1,0,0,0,25.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','cartes-5s','',0.400000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,30.000000,25.000000,30.000000,25.000000,0.000000,0.000000,25.000000,25.000000,0.000000),(45,42,0,0,1,43,0,0,'5S : Lot de 100 étiquettes rouges',10,-26,0,0,0,30.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','5s-etiquettes-rouges','',0.900000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,360.000000,300.000000,36.000000,30.000000,0.000000,0.000000,0.000000,30.000000,0.000000),(46,43,0,0,1,48,0,0,'5S : le guide pour appliquer',1,0,0,0,0,240.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','','',0.000000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,288.000000,240.000000,288.000000,240.000000,0.000000,0.000000,0.000000,240.000000,0.000000),(47,44,0,0,1,46,0,0,'5S : le jeu pédagogique (seul)',1,1,0,0,0,1.000000,30.00,0.000000,0.000000,0.000000,0.00,2.040000,'',NULL,'','jeu 5S','',0.000000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,0.840000,0.700000,0.840000,0.700000,0.000000,0.000000,0.000000,1.000000,0.000000),(48,45,30,0,1,61,0,0,'5S : le jeu pédagogique (seul)',1,0,0,0,0,1.000000,30.00,0.000000,0.000000,0.000000,0.00,2.040000,'',NULL,'','jeu 5S','',0.000000,0,0,'',0.000,0.000000,0.000,0,'0b7e6a385fe426b60d13256f3e20a43f546b591b',0,NULL,0.840000,0.700000,0.840000,0.700000,0.000000,0.000000,0.000000,1.000000,0.000000),(49,46,31,0,1,61,0,0,'5S : le jeu pédagogique (seul)',1,-1,0,0,0,1.000000,30.00,0.000000,0.000000,0.000000,0.00,2.040000,'',NULL,'','jeu 5S','',0.000000,0,0,'',0.000,0.000000,0.000,0,'59e67aa94b9c9312ebc0e20aff82dd23ebf98cae',0,NULL,0.840000,0.700000,0.840000,0.700000,0.000000,0.000000,0.000000,1.000000,0.000000),(50,47,32,0,1,51,0,0,'Kanban : le jeu pédagogique',1,-3,0,0,0,890.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','','',8.500000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,1068.000000,890.000000,1068.000000,890.000000,0.000000,0.000000,0.000000,890.000000,0.000000),(51,48,33,0,1,15,0,0,'SMED : le jeu pédagogique (seul)',1,1,0,0,0,290.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','jeu-smed','',0.900000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,348.000000,290.000000,348.000000,290.000000,0.000000,0.000000,0.000000,290.000000,0.000000),(52,48,33,0,1,61,0,0,'5S : le jeu pédagogique (seul)',1,-2,0,0,0,1.000000,30.00,0.000000,0.000000,0.000000,0.00,2.040000,'',NULL,'','jeu 5S','',0.000000,0,0,'',0.000,0.000000,0.000,0,'19b4fcadf165695b6bcaa7c5a529fe54790f1a96',0,NULL,0.840000,0.700000,0.840000,0.700000,0.000000,0.000000,0.000000,1.000000,0.000000),(53,49,34,0,1,46,0,0,'5S : le jeu pédagogique (seul)',1,1,0,0,0,29.990000,30.00,0.000000,0.000000,0.000000,0.00,26.390000,'',NULL,'','jeu 5S','',0.000000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,25.190000,20.990000,25.191600,20.993000,0.000000,0.000000,0.000000,29.990000,0.000000),(54,50,35,0,1,46,0,0,'5S : le jeu pédagogique (seul)',1,1,0,0,0,1.000000,30.00,0.000000,0.000000,0.000000,0.00,2.040000,'',NULL,'','jeu 5S','',0.000000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,0.840000,0.700000,0.840000,0.700000,0.000000,0.000000,0.000000,1.000000,0.000000),(55,51,36,0,1,61,0,0,'5S : le jeu pédagogique (seul)',1,-3,0,0,0,0.500000,30.00,0.000000,0.000000,0.000000,0.00,1.620000,'',NULL,'','jeu 5S','',0.000000,0,0,'',0.000,0.000000,0.000,0,'ce2421c8fa3dbc6a70134b157c36551a6def3fcc',1,NULL,0.420000,0.350000,0.420000,0.350000,0.000000,0.000000,0.000000,0.500000,0.000000),(56,52,47,0,1,15,0,0,'SMED : Pedagogical Game',1,1,0,0,0,290.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','jeu-smed','',0.900000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,348.000000,290.000000,348.000000,290.000000,24.000000,20.000000,0.000000,290.000000,0.000000),(57,53,43,0,1,43,0,0,'5S : Lot de 100 étiquettes rouges',1,-36,0,0,0,29.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','5s-etiquettes-rouges','',0.900000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,34.800000,29.000000,34.800000,29.000000,0.000000,0.000000,0.000000,29.000000,0.000000),(58,54,37,0,1,43,0,0,'5S : Lot de 100 étiquettes rouges',4,-37,0,0,0,29.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'',NULL,'','5s-etiquettes-rouges','',0.900000,0,0,'',0.000,0.000000,0.000,0,'',0,NULL,139.200000,116.000000,34.800000,29.000000,0.000000,0.000000,0.000000,29.000000,0.000000),(59,55,0,0,1,61,0,0,'5S: game',1,1,0,0,0,0.700000,30.00,0.000000,0.000000,0.000000,0.00,1.790000,'','','','jeu 5S','',0.000000,1,0,'',0.000,0.000000,0.000,0,'7f29589270adb96814f4e7e6374fbb39ea29ba6b',0,'0000-00-00 00:00:00',0.590000,0.490000,0.588000,0.490000,0.000000,0.000000,0.000000,0.700000,0.000000),(60,56,38,0,1,61,0,0,'5S : le jeu pédagogique (seul)',1,1,0,0,0,2.000000,30.00,0.000000,0.000000,0.000000,0.00,2.880000,'','','','jeu 5S','',0.000000,1,0,'',0.000,0.000000,0.000,0,'6f4d8a6c77fc3a30cd5c36aaaafe7caaf2d859dd',1,'0000-00-00 00:00:00',1.680000,1.400000,1.680000,1.400000,0.000000,0.000000,0.000000,2.000000,0.000000),(61,57,39,0,1,11,0,0,'QRQC : Le management de la résolution de problème',1,-1,0,0,0,0.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'','','','qrqc-application','',0.000000,1,0,'',0.000,0.000000,0.000,0,'c3b54de89e1d0b772b4b37bc941ed0202866802d',1,'0000-00-00 00:00:00',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000),(62,58,40,0,1,11,0,0,'QRQC : Le management de la résolution de problème (Fichier gratuit)',1,-2,0,0,0,0.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'','','','qrqc-application','',0.000000,1,0,'',0.000,0.000000,0.000,0,'f8830b3cdc37a98edd150326c0ae1cc02279083c',1,'0000-00-00 00:00:00',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000),(63,59,41,0,1,11,0,0,'QRQC : Le management de la résolution de problème (Fichier gratuit)',1,-3,0,0,0,0.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'','','','qrqc-application','',0.000000,1,0,'',0.000,0.000000,0.000,0,'02cc767e47c3c73ea83d362bf05f9bcee925b1f4',2,'0000-00-00 00:00:00',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000),(64,60,42,0,1,11,0,0,'QRQC : The problem solving management (free presentation)',1,-4,0,0,0,0.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'','','','qrqc-application','',0.000000,1,0,'',0.000,0.000000,0.000,0,'7f6d28b1c0dd8c4e42f8657ae65b97847d99ac59',2,'0000-00-00 00:00:00',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000),(65,61,44,0,1,50,0,0,'Jeu Logistique',1,1,0,0,0,295.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'','','','','',2.500000,1,0,'',0.000,0.000000,0.000,0,'',0,'0000-00-00 00:00:00',354.000000,295.000000,354.000000,295.000000,0.000000,0.000000,0.000000,295.000000,0.000000),(66,62,45,0,1,11,0,0,'QRQC : Le management de la résolution de problème (Fichier gratuit)',1,-5,0,0,0,0.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'','','','qrqc-application','',0.000000,1,0,'',0.000,0.000000,0.000,0,'3d9f7c0e514fb905a096827a2d94ee9e35bc7dfd',1,'0000-00-00 00:00:00',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000),(67,63,0,0,1,43,0,0,'5S : Lot de 100 étiquettes rouges',1,1,0,0,0,93.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'','','','5s-etiquettes-rouges','',0.900000,1,0,'',0.000,0.000000,0.000,0,'',0,'0000-00-00 00:00:00',111.600000,93.000000,111.600000,93.000000,0.000000,0.000000,40.000000,93.000000,40.000000),(68,64,46,0,1,43,0,0,'5S : Lot de 100 étiquettes rouges',1,1,0,0,0,93.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'','','','5s-etiquettes-rouges','',0.900000,1,0,'',0.000,0.000000,0.000,0,'',0,'0000-00-00 00:00:00',111.600000,93.000000,111.600000,93.000000,0.000000,0.000000,40.000000,93.000000,40.000000),(69,65,0,0,1,15,0,0,'SMED : le jeu pédagogique (seul)',1,0,0,0,0,290.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'','','','jeu-smed','',1.200000,1,0,'',0.000,0.000000,0.000,0,'',0,'0000-00-00 00:00:00',348.000000,290.000000,348.000000,290.000000,6.000000,5.000000,0.000000,290.000000,0.000000),(70,66,48,0,1,15,0,0,'SMED : le jeu pédagogique (seul)',1,-1,0,0,0,290.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'','','','jeu-smed','',1.200000,1,0,'',0.000,0.000000,0.000,0,'',0,'0000-00-00 00:00:00',348.000000,290.000000,348.000000,290.000000,6.000000,5.000000,0.000000,290.000000,0.000000),(71,67,49,0,1,15,0,0,'SMED : Pedagogical Game',1,-2,0,0,0,290.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'','','','jeu-smed','',1.200000,1,0,'',0.000,0.000000,0.000,0,'',0,'0000-00-00 00:00:00',348.000000,290.000000,348.000000,290.000000,6.000000,5.000000,0.000000,290.000000,0.000000),(72,68,50,0,1,15,0,0,'SMED : le jeu pédagogique (seul)',1,-3,0,0,0,290.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'','','','jeu-smed','',1.200000,1,0,'',0.000,0.000000,0.000,0,'',0,'0000-00-00 00:00:00',348.000000,290.000000,348.000000,290.000000,6.000000,5.000000,0.000000,290.000000,0.000000),(73,69,51,0,1,43,0,0,'5S : Lot de 100 étiquettes rouges',1,1,0,0,0,93.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'','','','5s-etiquettes-rouges','',0.900000,1,0,'',0.000,0.000000,0.000,0,'',0,'0000-00-00 00:00:00',111.600000,93.000000,111.600000,93.000000,0.000000,0.000000,40.000000,93.000000,40.000000),(74,70,0,0,1,43,0,0,'5S : Lot de 100 étiquettes rouges',1,1,0,0,0,93.000000,0.00,0.000000,0.000000,0.000000,0.00,0.000000,'','','','5s-etiquettes-rouges','',0.900000,1,0,'',0.000,0.000000,0.000,0,'',0,'0000-00-00 00:00:00',111.600000,93.000000,111.600000,93.000000,0.000000,0.000000,40.000000,93.000000,40.000000),(75,71,0,0,1,1,0,0,'SMED : le package complet',1,1,0,0,0,535.000000,20.00,0.000000,0.000000,0.000000,0.00,514.800000,'','','','','',1.200000,1,0,'',0.000,0.000000,0.000,0,'',0,'0000-00-00 00:00:00',513.600000,428.000000,513.600000,428.000000,0.000000,0.000000,0.000000,535.000000,0.000000);
/*!40000 ALTER TABLE `leanps_order_detail` 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-07-01 21:35:46
