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

DROP TABLE IF EXISTS `leanps_order_invoice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `leanps_order_invoice` (
  `id_order_invoice` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_order` int(11) NOT NULL,
  `number` int(11) NOT NULL,
  `delivery_number` int(11) NOT NULL,
  `delivery_date` datetime DEFAULT NULL,
  `total_discount_tax_excl` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `total_discount_tax_incl` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `total_paid_tax_excl` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `total_paid_tax_incl` 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_tax_excl` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `total_shipping_tax_incl` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `shipping_tax_computation_method` int(10) unsigned NOT NULL,
  `total_wrapping_tax_excl` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `total_wrapping_tax_incl` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `shop_address` text DEFAULT NULL,
  `note` text DEFAULT NULL,
  `date_add` datetime NOT NULL,
  PRIMARY KEY (`id_order_invoice`),
  KEY `id_order` (`id_order`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leanps_order_invoice`
--

LOCK TABLES `leanps_order_invoice` WRITE;
/*!40000 ALTER TABLE `leanps_order_invoice` DISABLE KEYS */;
INSERT INTO `leanps_order_invoice` VALUES (1,5,1,0,NULL,0.000000,0.000000,330.000000,394.680000,300.000000,358.800000,30.000000,35.880000,0,0.000000,0.000000,NULL,NULL,'2013-07-25 16:37:28'),(2,6,2,0,NULL,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0.000000,0.000000,NULL,NULL,'2013-07-31 15:32:14'),(3,7,3,0,NULL,96.000000,114.820000,0.000000,0.000000,96.000000,114.820000,0.000000,0.000000,0,0.000000,0.000000,NULL,NULL,'2013-07-31 19:54:31'),(4,8,4,0,NULL,96.000000,114.820000,0.000000,0.000000,96.000000,114.820000,0.000000,0.000000,0,0.000000,0.000000,NULL,NULL,'2013-07-31 20:10:40'),(5,9,5,0,NULL,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0.000000,0.000000,NULL,NULL,'2013-07-31 20:51:00'),(6,3,6,0,NULL,0.000000,0.000000,1.000000,1.200000,1.000000,1.200000,0.000000,0.000000,0,0.000000,0.000000,NULL,NULL,'2013-08-01 18:45:23'),(7,10,7,0,NULL,96.000000,114.820000,0.000000,0.000000,96.000000,114.820000,0.000000,0.000000,0,0.000000,0.000000,NULL,NULL,'2013-08-01 18:58:26'),(8,16,97,0,NULL,0.000000,0.000000,297.100000,353.940000,290.000000,346.840000,7.100000,7.100000,0,0.000000,0.000000,NULL,NULL,'2013-08-29 06:54:27'),(9,17,98,0,NULL,0.000000,0.000000,63.000000,75.350000,63.000000,75.350000,0.000000,0.000000,0,0.000000,0.000000,NULL,NULL,'2013-11-18 16:07:45'),(10,18,99,0,NULL,0.000000,0.000000,539.250000,539.250000,530.000000,530.000000,9.250000,9.250000,1,0.000000,0.000000,NULL,NULL,'2014-01-15 10:01:48'),(11,19,100,0,NULL,96.000000,114.820000,0.000000,0.000000,96.000000,114.820000,0.000000,0.000000,0,0.000000,0.000000,NULL,NULL,'2014-09-04 14:38:31'),(12,20,101,0,NULL,0.000000,0.000000,297.100000,355.100000,290.000000,348.000000,7.100000,7.100000,0,0.000000,0.000000,NULL,'','2014-11-28 10:48:35'),(13,21,102,0,NULL,0.000000,0.000000,25.900000,31.080000,25.900000,31.080000,0.000000,0.000000,0,0.000000,0.000000,NULL,'','2015-04-30 09:02:08'),(14,22,103,0,NULL,0.000000,0.000000,297.100000,355.100000,290.000000,348.000000,7.100000,7.100000,0,0.000000,0.000000,NULL,'','2015-05-26 16:28:28'),(15,23,104,0,NULL,87.000000,104.400000,210.100000,250.700000,290.000000,348.000000,7.100000,7.100000,0,0.000000,0.000000,NULL,'','2015-07-22 21:32:39'),(16,24,105,0,NULL,0.000000,0.000000,539.250000,645.250000,530.000000,636.000000,9.250000,9.250000,0,0.000000,0.000000,NULL,'','2015-10-16 06:05:12'),(17,25,106,0,NULL,0.000000,0.000000,2340.000000,2808.000000,2340.000000,2808.000000,0.000000,0.000000,0,0.000000,0.000000,NULL,'','2016-01-21 15:47:02'),(18,26,107,0,NULL,0.000000,0.000000,316.350000,376.350000,300.000000,360.000000,16.350000,16.350000,0,0.000000,0.000000,NULL,'','2016-02-16 12:00:13'),(19,27,108,0,NULL,0.000000,0.000000,99.250000,117.250000,90.000000,108.000000,9.250000,9.250000,0,0.000000,0.000000,NULL,'','2016-03-07 17:46:58'),(20,28,109,0,NULL,0.000000,0.000000,810.000000,972.000000,810.000000,972.000000,0.000000,0.000000,0,0.000000,0.000000,NULL,'','2016-03-09 11:11:43'),(21,29,97,0,NULL,0.000000,0.000000,0.700000,0.700000,0.700000,0.700000,0.000000,0.000000,0,0.000000,0.000000,NULL,'','2016-04-29 14:41:46'),(22,30,110,0,NULL,0.000000,0.000000,68.200000,80.200000,60.000000,72.000000,8.200000,8.200000,0,0.000000,0.000000,NULL,'','2016-05-09 10:06:24'),(23,31,111,0,NULL,0.000000,0.000000,0.500000,0.600000,0.500000,0.600000,0.000000,0.000000,0,0.000000,0.000000,NULL,'','2016-07-01 10:55:02'),(24,32,112,0,NULL,0.000000,0.000000,68.200000,80.200000,60.000000,72.000000,8.200000,8.200000,0,0.000000,0.000000,NULL,'','2016-10-03 16:53:26'),(25,33,113,0,NULL,0.000000,0.000000,920.000000,1104.000000,890.000000,1068.000000,30.000000,36.000000,0,0.000000,0.000000,NULL,'','2016-10-07 12:48:03'),(26,34,114,0,NULL,0.000000,0.000000,920.000000,1104.000000,890.000000,1068.000000,30.000000,36.000000,0,0.000000,0.000000,NULL,'','2016-10-31 10:30:32'),(27,35,115,0,NULL,0.000000,0.000000,346.100000,413.900000,339.000000,406.800000,7.100000,7.100000,0,0.000000,0.000000,NULL,'','2016-11-14 11:13:48'),(28,36,116,0,NULL,0.000000,0.000000,547.700000,653.700000,530.000000,636.000000,17.700000,17.700000,0,0.000000,0.000000,NULL,'','2016-11-23 15:42:05'),(29,38,117,0,NULL,0.000000,0.000000,299.250000,357.250000,290.000000,348.000000,9.250000,9.250000,0,0.000000,0.000000,NULL,'','2017-05-18 22:28:12'),(30,45,118,0,NULL,0.000000,0.000000,0.700000,0.840000,0.700000,0.840000,0.000000,0.000000,0,0.000000,0.000000,NULL,'','2017-09-01 10:05:22'),(31,46,119,0,NULL,0.000000,0.000000,0.700000,0.840000,0.700000,0.840000,0.000000,0.000000,0,0.000000,0.000000,NULL,'','2017-09-07 11:42:24'),(32,47,120,0,NULL,0.000000,0.000000,908.200000,1089.840000,890.000000,1068.000000,18.200000,21.840000,0,0.000000,0.000000,NULL,'','2017-11-29 09:48:57'),(33,48,121,0,NULL,0.000000,0.000000,290.700000,348.840000,290.700000,348.840000,0.000000,0.000000,0,0.000000,0.000000,NULL,'','2017-12-08 13:56:02'),(34,49,122,0,NULL,0.000000,0.000000,20.990000,25.190000,20.990000,25.190000,0.000000,0.000000,0,0.000000,0.000000,NULL,'','2018-02-25 10:57:50'),(35,50,123,0,NULL,0.000000,0.000000,0.700000,0.840000,0.700000,0.840000,0.000000,0.000000,0,0.000000,0.000000,NULL,'','2018-11-17 11:48:42'),(36,51,124,0,NULL,0.000000,0.000000,0.350000,0.420000,0.350000,0.420000,0.000000,0.000000,0,0.000000,0.000000,NULL,'','2018-11-17 15:20:20'),(37,54,1,0,NULL,0.000000,0.000000,131.000000,154.200000,116.000000,139.200000,15.000000,15.000000,0,0.000000,0.000000,NULL,'','2019-07-11 10:52:48'),(38,56,125,1,'2019-08-17 10:55:12',0.000000,0.000000,1.400000,1.680000,1.400000,1.680000,0.000000,0.000000,0,0.000000,0.000000,'lean-shop.net<br />Lean Shop, 23 rue Baptiste Renard<br />27350 BRESTOT<br />+33232563400','','2019-08-17 10:47:05'),(39,57,126,0,'0000-00-00 00:00:00',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0.000000,0.000000,'lean-shop.net<br />Lean Shop, 23 rue Baptiste Renard<br />27350 BRESTOT<br />+33232563400','','2019-08-18 10:29:17'),(40,58,127,0,'0000-00-00 00:00:00',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0.000000,0.000000,'lean-shop.net<br />Lean Shop, 23 rue Baptiste Renard<br />27350 BRESTOT<br />France<br />+33232563400','','2019-10-15 16:21:18'),(41,59,128,0,'0000-00-00 00:00:00',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0.000000,0.000000,'lean-shop.net<br />Lean Shop, 23 rue Baptiste Renard<br />27350 BRESTOT<br />France<br />+33232563400','','2019-10-16 22:06:52'),(42,60,129,0,'0000-00-00 00:00:00',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0.000000,0.000000,'lean-shop.net<br />Lean Shop, 23 rue Baptiste Renard<br />27350 BRESTOT<br />France<br />+33232563400','','2019-10-23 00:09:40'),(43,53,130,0,'0000-00-00 00:00:00',0.000000,0.000000,47.200000,56.640000,29.000000,34.800000,18.200000,21.840000,0,0.000000,0.000000,'lean-shop.net<br />Lean Shop, 23 rue Baptiste Renard<br />27350 BRESTOT<br />France<br />+33232563400','','2019-12-03 10:16:07'),(44,61,1,0,'0000-00-00 00:00:00',0.000000,0.000000,295.000000,354.000000,295.000000,354.000000,0.000000,0.000000,0,0.000000,0.000000,'lean-shop.net<br />Lean Shop, 23 rue Baptiste Renard<br />27350 BRESTOT<br />France<br />+33232563400','','2020-02-22 05:42:22'),(45,62,2,0,'0000-00-00 00:00:00',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0.000000,0.000000,'lean-shop.net<br />Lean Shop, 23 rue Baptiste Renard<br />27350 BRESTOT<br />France<br />+33232563400','','2020-05-12 07:19:06'),(46,64,3,0,'0000-00-00 00:00:00',0.000000,0.000000,101.000000,119.600000,93.000000,111.600000,8.000000,8.000000,0,0.000000,0.000000,'lean-shop.net<br />Lean Shop, 23 rue Baptiste Renard<br />27350 BRESTOT<br />France<br />+33232563400','','2020-10-20 15:52:23'),(47,52,1,0,'0000-00-00 00:00:00',0.000000,0.000000,290.000000,348.000000,290.000000,348.000000,0.000000,0.000000,0,0.000000,0.000000,'lean-shop.net<br />Lean Shop, 23 rue Baptiste Renard<br />27350 BRESTOT<br />France<br />+33232563400','','2021-01-22 10:50:00'),(48,66,2,0,'0000-00-00 00:00:00',0.000000,0.000000,303.000000,361.000000,290.000000,348.000000,13.000000,13.000000,0,0.000000,0.000000,'lean-shop.net<br />Lean Shop, 23 rue Baptiste Renard<br />27350 BRESTOT<br />France<br />+33232563400','','2021-04-24 19:35:07'),(49,67,1,0,'0000-00-00 00:00:00',0.000000,0.000000,303.000000,361.000000,290.000000,348.000000,13.000000,13.000000,0,0.000000,0.000000,'lean-shop.net<br />Lean Shop, 23 rue Baptiste Renard<br />27350 BRESTOT<br />France<br />+33232563400','','2022-04-06 09:58:05'),(50,68,2,0,'0000-00-00 00:00:00',0.000000,0.000000,303.000000,361.000000,290.000000,348.000000,13.000000,13.000000,0,0.000000,0.000000,'lean-shop.net<br />Lean Shop, 23 rue Baptiste Renard<br />27350 BRESTOT<br />France<br />+33232563400','','2022-07-26 14:10:29'),(51,69,1,0,'0000-00-00 00:00:00',0.000000,0.000000,101.000000,119.600000,93.000000,111.600000,8.000000,8.000000,0,0.000000,0.000000,'lean-shop.net<br />Lean Shop, 23 rue Baptiste Renard<br />27350 BRESTOT<br />France<br />+33232563400','','2023-04-11 14:20:27');
/*!40000 ALTER TABLE `leanps_order_invoice` 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:32
