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

DROP TABLE IF EXISTS `leanps_order_carrier`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `leanps_order_carrier` (
  `id_order_carrier` int(11) NOT NULL AUTO_INCREMENT,
  `id_order` int(11) unsigned NOT NULL,
  `id_carrier` int(11) unsigned NOT NULL,
  `id_order_invoice` int(11) unsigned DEFAULT NULL,
  `weight` decimal(20,6) DEFAULT NULL,
  `shipping_cost_tax_excl` decimal(20,6) DEFAULT NULL,
  `shipping_cost_tax_incl` decimal(20,6) DEFAULT NULL,
  `tracking_number` varchar(64) DEFAULT NULL,
  `date_add` datetime NOT NULL,
  PRIMARY KEY (`id_order_carrier`),
  KEY `id_order` (`id_order`),
  KEY `id_carrier` (`id_carrier`),
  KEY `id_order_invoice` (`id_order_invoice`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leanps_order_carrier`
--

LOCK TABLES `leanps_order_carrier` WRITE;
/*!40000 ALTER TABLE `leanps_order_carrier` DISABLE KEYS */;
INSERT INTO `leanps_order_carrier` VALUES (1,1,2,NULL,0.000000,0.000000,0.000000,NULL,'2012-07-27 12:24:16'),(2,2,2,NULL,0.500000,7.000000,8.370000,NULL,'2012-07-27 14:46:28'),(3,4,8,0,1.000000,30.000000,35.880000,NULL,'2013-07-25 12:28:32'),(4,5,8,1,10.000000,30.000000,35.880000,NULL,'2013-07-25 16:37:28'),(5,11,18,0,0.900000,7.100000,7.100000,NULL,'2013-08-02 02:53:35'),(6,12,18,0,0.900000,6.560000,6.560000,NULL,'2013-08-02 02:59:43'),(7,13,18,0,0.900000,7.100000,7.100000,NULL,'2013-08-27 03:10:40'),(8,14,18,0,0.900000,7.100000,7.100000,NULL,'2013-08-27 03:18:34'),(9,15,18,0,0.900000,7.100000,7.100000,NULL,'2013-08-29 06:49:45'),(10,16,18,8,0.900000,7.100000,7.100000,NULL,'2013-08-29 06:54:27'),(11,18,18,10,2.500000,9.250000,9.250000,NULL,'2014-01-15 10:01:48'),(12,20,18,12,0.900000,7.100000,7.100000,'','2014-11-28 10:48:31'),(13,22,18,14,0.900000,7.100000,7.100000,'','2015-05-26 16:28:22'),(14,23,18,15,0.900000,7.100000,7.100000,'','2015-07-22 21:32:32'),(15,24,18,16,2.500000,9.250000,9.250000,'','2015-10-16 06:05:12'),(16,25,18,17,13.000000,0.000000,0.000000,'','2016-01-21 15:47:02'),(17,26,18,18,9.000000,16.350000,16.350000,'','2016-02-16 12:00:13'),(18,27,18,19,2.700000,9.250000,9.250000,'','2016-03-07 17:46:58'),(19,28,18,20,24.300000,0.000000,0.000000,'','2016-03-09 11:11:43'),(20,30,18,22,1.800000,8.200000,8.200000,'','2016-05-09 10:06:24'),(21,32,18,24,1.800000,8.200000,8.200000,'','2016-10-03 16:53:26'),(22,33,9,25,8.500000,30.000000,36.000000,'','2016-10-07 12:48:02'),(23,34,9,26,8.500000,30.000000,36.000000,'','2016-10-31 10:30:32'),(24,35,18,27,0.900000,7.100000,7.100000,'','2016-11-14 11:13:48'),(25,36,18,28,1.950000,17.700000,17.700000,'','2016-11-23 15:42:05'),(26,37,18,0,1.800000,8.200000,8.200000,'','2017-04-20 16:12:03'),(27,38,18,29,2.500000,9.250000,9.250000,'','2017-05-18 22:28:11'),(28,39,26,0,0.400000,18.200000,21.840000,'','2017-07-07 18:58:17'),(29,40,28,0,2.500000,12.000000,12.000000,'','2017-07-10 12:16:16'),(30,41,28,0,0.400000,8.000000,8.000000,'','2017-07-12 08:31:11'),(31,42,29,0,9.000000,18.200000,21.840000,'','2017-07-31 17:33:50'),(32,43,29,0,0.000000,18.200000,21.840000,'','2017-08-24 16:20:01'),(33,44,33,0,0.000000,0.000000,0.000000,'','2017-08-30 20:01:55'),(34,47,29,32,8.500000,18.200000,21.840000,'','2017-11-29 09:48:57'),(35,48,33,33,0.900000,0.000000,0.000000,'','2017-12-08 13:56:02'),(36,49,33,34,0.000000,0.000000,0.000000,'','2018-02-25 10:57:50'),(37,50,33,35,0.000000,0.000000,0.000000,'','2018-11-17 11:48:42'),(38,52,28,47,0.900000,0.000000,0.000000,'','2019-03-14 12:07:24'),(39,53,29,43,0.900000,18.200000,21.840000,'','2019-04-18 14:46:13'),(40,54,28,37,3.600000,15.000000,15.000000,'','2019-07-11 10:52:48'),(41,61,65,44,2.500000,0.000000,0.000000,'','2020-02-22 05:42:20'),(42,63,69,0,0.900000,8.000000,8.000000,'','2020-10-12 10:36:25'),(43,64,69,46,0.900000,8.000000,8.000000,'','2020-10-20 15:52:22'),(44,65,69,0,1.200000,13.000000,13.000000,'','2021-04-15 12:17:21'),(45,66,69,48,1.200000,13.000000,13.000000,'','2021-04-15 12:21:05'),(46,67,69,49,1.200000,13.000000,13.000000,'','2022-04-06 09:58:05'),(47,68,69,50,1.200000,13.000000,13.000000,'','2022-07-26 14:10:27'),(48,69,69,51,0.900000,8.000000,8.000000,'','2023-04-11 14:20:26'),(49,70,69,0,0.900000,8.000000,8.000000,'','2023-12-18 16:49:17'),(50,71,69,0,1.200000,0.000000,0.000000,'','2024-06-07 15:07:27');
/*!40000 ALTER TABLE `leanps_order_carrier` 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
