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

DROP TABLE IF EXISTS `leanps_order_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `leanps_order_history` (
  `id_order_history` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_employee` int(10) unsigned NOT NULL,
  `id_order` int(10) unsigned NOT NULL,
  `id_order_state` int(10) unsigned NOT NULL,
  `date_add` datetime NOT NULL,
  PRIMARY KEY (`id_order_history`),
  KEY `order_history_order` (`id_order`),
  KEY `id_employee` (`id_employee`),
  KEY `id_order_state` (`id_order_state`)
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leanps_order_history`
--

LOCK TABLES `leanps_order_history` WRITE;
/*!40000 ALTER TABLE `leanps_order_history` DISABLE KEYS */;
INSERT INTO `leanps_order_history` VALUES (1,0,1,1,'2019-07-30 17:17:56'),(2,0,2,1,'2019-07-30 17:17:56'),(3,0,3,1,'2019-07-30 17:17:56'),(4,0,4,1,'2019-07-30 17:17:56'),(5,0,5,10,'2019-07-30 17:17:56'),(6,1,1,6,'2019-07-30 17:17:56'),(7,1,3,8,'2019-07-30 17:17:56'),(8,0,5,2,'2013-07-25 16:37:28'),(9,0,6,2,'2013-07-31 15:32:14'),(10,0,7,2,'2013-07-31 19:54:31'),(11,0,8,2,'2013-07-31 20:10:40'),(12,0,9,2,'2013-07-31 20:51:00'),(13,0,10,2,'2013-08-01 18:58:26'),(14,0,11,8,'2013-08-02 02:53:35'),(15,0,12,8,'2013-08-02 02:59:43'),(16,0,13,8,'2013-08-27 03:10:40'),(17,0,14,8,'2013-08-27 03:18:34'),(18,0,15,8,'2013-08-29 06:49:45'),(19,0,16,2,'2013-08-29 06:54:27'),(20,0,17,1,'2013-11-13 18:34:49'),(21,1,17,2,'2013-11-18 16:07:45'),(22,0,18,2,'2014-01-15 10:01:48'),(23,0,19,2,'2014-09-04 14:38:31'),(24,0,20,2,'2014-11-28 10:48:44'),(25,0,20,9,'2014-11-28 10:48:55'),(26,0,21,2,'2015-04-30 09:02:14'),(27,0,21,9,'2015-04-30 09:02:29'),(28,0,22,2,'2015-05-26 16:28:39'),(29,0,22,9,'2015-05-26 16:28:55'),(30,1,22,3,'2015-06-17 12:25:29'),(31,0,23,2,'2015-07-22 21:32:41'),(32,0,24,2,'2015-10-16 06:05:12'),(33,0,25,2,'2016-01-21 15:47:02'),(34,0,26,2,'2016-02-16 12:00:13'),(35,0,27,2,'2016-03-07 17:46:59'),(36,0,28,2,'2016-03-09 11:11:44'),(37,0,29,2,'2016-04-29 14:41:46'),(38,5,29,6,'2016-04-29 14:44:51'),(39,0,30,2,'2016-05-09 10:06:24'),(40,0,31,2,'2016-07-01 10:55:02'),(41,0,32,2,'2016-10-03 16:53:27'),(42,0,33,2,'2016-10-07 12:48:03'),(43,0,34,2,'2016-10-31 10:30:32'),(44,0,35,2,'2016-11-14 11:13:48'),(45,0,36,2,'2016-11-23 15:42:05'),(46,0,37,10,'2017-04-20 16:12:03'),(47,0,38,2,'2017-05-18 22:28:12'),(48,0,39,10,'2017-07-07 18:58:17'),(49,0,40,1,'2017-07-10 12:16:16'),(50,0,41,1,'2017-07-12 08:31:11'),(51,0,42,10,'2017-07-31 17:33:50'),(52,0,43,1,'2017-08-24 16:20:01'),(53,0,44,1,'2017-08-30 20:01:55'),(54,0,45,2,'2017-09-01 10:05:22'),(55,0,46,2,'2017-09-07 11:42:24'),(56,0,47,2,'2017-11-29 09:48:57'),(57,0,48,2,'2017-12-08 13:56:02'),(58,0,49,2,'2018-02-25 10:57:50'),(59,0,50,2,'2018-11-17 11:48:42'),(60,0,51,2,'2018-11-17 15:20:20'),(61,0,52,10,'2019-03-14 12:07:24'),(62,0,53,10,'2019-04-18 14:46:13'),(63,0,54,2,'2019-07-11 10:52:48'),(64,0,55,10,'2019-08-15 15:02:16'),(65,0,56,2,'2019-08-17 10:47:06'),(66,15,56,5,'2019-08-17 10:55:12'),(67,0,57,2,'2019-08-18 10:29:18'),(68,0,58,2,'2019-10-15 16:21:18'),(69,0,59,2,'2019-10-16 22:06:53'),(70,0,60,2,'2019-10-23 00:09:41'),(71,15,53,2,'2019-12-03 10:16:08'),(72,0,61,2,'2020-02-22 05:42:22'),(73,0,62,2,'2020-05-12 07:19:07'),(74,0,63,10,'2020-10-12 10:36:26'),(75,0,64,2,'2020-10-20 15:52:23'),(76,15,52,2,'2021-01-22 10:50:02'),(77,0,65,10,'2021-04-15 12:17:24'),(78,0,66,10,'2021-04-15 12:21:05'),(79,15,66,2,'2021-04-24 19:35:08'),(80,0,67,2,'2022-04-06 09:58:05'),(81,0,68,2,'2022-07-26 14:10:29'),(82,0,69,2,'2023-04-11 14:20:29'),(83,0,70,10,'2023-12-18 16:49:17'),(84,0,71,10,'2024-06-07 15:07:29');
/*!40000 ALTER TABLE `leanps_order_history` 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:47
