-- MySQL dump 10.13  Distrib 8.0.38, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: gbscan1
-- ------------------------------------------------------
-- Server version	8.0.39

/*!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 */;
/*!50503 SET NAMES utf8 */;
/*!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 `stock_changes`
--

DROP TABLE IF EXISTS `stock_changes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `stock_changes` (
  `change_id` int NOT NULL AUTO_INCREMENT,
  `product_code` varchar(50) NOT NULL,
  `store_id` int NOT NULL,
  `change_type` enum('sale','replenishment','initial_stock') NOT NULL,
  `quantity` int NOT NULL,
  `change_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`change_id`),
  KEY `idx_stock_changes_product_code` (`product_code`),
  KEY `idx_stock_changes_store_id` (`store_id`),
  KEY `idx_stock_changes_change_date` (`change_date`),
  CONSTRAINT `stock_changes_ibfk_1` FOREIGN KEY (`product_code`) REFERENCES `products` (`product_code`) ON DELETE CASCADE,
  CONSTRAINT `stock_changes_ibfk_2` FOREIGN KEY (`store_id`) REFERENCES `stores` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=416 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `stock_changes`
--

LOCK TABLES `stock_changes` WRITE;
/*!40000 ALTER TABLE `stock_changes` DISABLE KEYS */;
INSERT INTO `stock_changes` VALUES (1,'26538337',1,'replenishment',953,'2024-11-15 10:39:54'),(2,'26538337',2,'replenishment',7257,'2024-11-15 10:39:54'),(3,'26538337',3,'replenishment',234,'2024-11-15 10:39:54'),(4,'26538337',4,'replenishment',4320,'2024-11-15 10:39:54'),(5,'88128842',1,'replenishment',2864,'2024-11-15 10:53:07'),(6,'88128842',2,'replenishment',4349,'2024-11-15 10:53:07'),(7,'88283949',1,'replenishment',19250,'2024-11-15 10:53:24'),(8,'88283949',2,'replenishment',39000,'2024-11-15 10:53:24'),(9,'88283949',4,'replenishment',21750,'2024-11-15 10:53:24'),(10,'88055372',1,'replenishment',9236,'2024-11-15 10:53:42'),(11,'88055372',2,'replenishment',20255,'2024-11-15 10:53:42'),(12,'88055372',3,'replenishment',100,'2024-11-15 10:53:42'),(13,'88055376',1,'replenishment',11507,'2024-11-15 10:54:01'),(14,'88055376',2,'replenishment',1400,'2024-11-15 10:54:01'),(15,'88055376',3,'replenishment',10,'2024-11-15 10:54:01'),(16,'95014421',1,'replenishment',3108,'2024-11-15 10:54:19'),(17,'95014421',2,'replenishment',17883,'2024-11-15 10:54:19'),(18,'95014421',3,'replenishment',177,'2024-11-15 10:54:19'),(19,'95014421',4,'replenishment',141,'2024-11-15 10:54:19'),(20,'25940472',1,'replenishment',1080,'2024-11-15 10:54:52'),(21,'25940472',2,'replenishment',1850,'2024-11-15 10:54:52'),(22,'25940472',3,'replenishment',25,'2024-11-15 10:54:52'),(23,'22125305',1,'replenishment',234,'2024-11-15 10:55:10'),(24,'22125305',2,'replenishment',967,'2024-11-15 10:55:10'),(25,'22125305',3,'replenishment',30,'2024-11-15 10:55:10'),(26,'22125305',4,'replenishment',13,'2024-11-15 10:55:10'),(27,'88055386',1,'replenishment',7,'2024-11-15 10:55:28'),(28,'88055386',2,'replenishment',672,'2024-11-15 10:55:28'),(29,'88055389',1,'replenishment',5900,'2024-11-15 10:55:45'),(30,'88055389',2,'replenishment',4951,'2024-11-15 10:55:45'),(31,'88055389',3,'replenishment',132,'2024-11-15 10:55:45'),(32,'88055389',4,'replenishment',198,'2024-11-15 10:55:45'),(33,'88055368',2,'replenishment',404,'2024-11-15 10:56:09'),(34,'88055368',3,'replenishment',100,'2024-11-15 10:56:09'),(35,'88055368',4,'replenishment',165,'2024-11-15 10:56:09'),(36,'26388387',1,'replenishment',33,'2024-11-15 10:56:26'),(37,'26388387',2,'replenishment',1175,'2024-11-15 10:56:26'),(38,'26388387',4,'replenishment',55,'2024-11-15 10:56:26'),(39,'95033572',1,'replenishment',159,'2024-11-15 10:56:43'),(40,'95033572',4,'replenishment',7,'2024-11-15 10:56:43'),(41,'22118579',1,'replenishment',229,'2024-11-15 10:57:24'),(42,'22118579',2,'replenishment',238,'2024-11-15 10:57:24'),(43,'22118581',1,'replenishment',956,'2024-11-15 10:57:41'),(44,'22118581',2,'replenishment',217,'2024-11-15 10:57:41'),(45,'22118581',4,'replenishment',212,'2024-11-15 10:57:41'),(46,'22128364',1,'replenishment',228,'2024-11-15 10:57:59'),(47,'99519978',1,'replenishment',120,'2024-11-15 10:58:16'),(48,'99519978',2,'replenishment',100,'2024-11-15 10:58:16'),(49,'22014926',1,'replenishment',62,'2024-11-15 10:58:33'),(50,'22014926',2,'replenishment',70,'2024-11-15 10:58:33'),(51,'99879759',1,'replenishment',169,'2024-11-15 10:58:50'),(52,'99879759',2,'replenishment',1537,'2024-11-15 10:58:50'),(53,'25649703',1,'replenishment',103,'2024-11-15 10:59:49'),(54,'25649703',2,'replenishment',3,'2024-11-15 10:59:49'),(55,'25649703',3,'replenishment',2,'2024-11-15 10:59:49'),(56,'25649703',4,'replenishment',25,'2024-11-15 10:59:49'),(57,'25649653',1,'replenishment',25,'2024-11-15 11:00:09'),(58,'25649653',2,'replenishment',2,'2024-11-15 11:00:09'),(59,'25649653',4,'replenishment',8,'2024-11-15 11:00:09'),(60,'94072020',1,'replenishment',58,'2024-11-15 11:00:56'),(61,'94072020',2,'replenishment',47,'2024-11-15 11:00:56'),(62,'94072020',3,'replenishment',3,'2024-11-15 11:00:56'),(63,'94072020',4,'replenishment',3,'2024-11-15 11:00:56'),(64,'25649714',1,'replenishment',75,'2024-11-15 11:01:34'),(65,'25649714',2,'replenishment',4,'2024-11-15 11:01:34'),(66,'25649714',4,'replenishment',11,'2024-11-15 11:01:34'),(67,'22072178',4,'replenishment',8,'2024-11-15 11:02:08'),(68,'88172314',1,'replenishment',58,'2024-11-15 11:02:49'),(69,'88172314',2,'replenishment',180,'2024-11-15 11:02:49'),(70,'88134953',1,'replenishment',18500,'2024-11-15 11:03:10'),(71,'88134953',2,'replenishment',20500,'2024-11-15 11:03:10'),(72,'88134953',4,'replenishment',4000,'2024-11-15 11:03:10'),(73,'91029085',1,'replenishment',245,'2024-11-15 11:03:29'),(74,'91029085',4,'replenishment',21,'2024-11-15 11:03:29'),(75,'22063084',1,'replenishment',4170,'2024-11-15 11:03:48'),(76,'92043186',1,'replenishment',2000,'2024-11-15 11:04:06'),(77,'90064819',1,'replenishment',4500,'2024-11-15 11:04:23'),(78,'88283950',2,'replenishment',51000,'2024-11-15 11:04:44'),(79,'88283950',3,'replenishment',4750,'2024-11-15 11:04:44'),(80,'88283950',4,'replenishment',32750,'2024-11-15 11:04:44'),(81,'88283945',2,'replenishment',36250,'2024-11-15 11:05:01'),(82,'88283945',4,'replenishment',20500,'2024-11-15 11:05:01'),(83,'90084052',1,'replenishment',1000,'2024-11-15 11:05:18'),(84,'88283948',2,'replenishment',4500,'2024-11-15 11:05:41'),(85,'88283948',3,'replenishment',750,'2024-11-15 11:05:41'),(86,'88283948',4,'replenishment',8750,'2024-11-15 11:05:41'),(87,'88283943',2,'replenishment',3500,'2024-11-15 11:06:41'),(88,'88283943',3,'replenishment',500,'2024-11-15 11:06:41'),(89,'88283943',4,'replenishment',2000,'2024-11-15 11:06:41'),(90,'90044773',1,'replenishment',5000,'2024-11-15 11:07:16'),(91,'90001512',1,'replenishment',38700,'2024-11-15 11:07:52'),(92,'90001512',2,'replenishment',3200,'2024-11-15 11:07:52'),(93,'90001512',3,'replenishment',400,'2024-11-15 11:07:52'),(94,'90001512',4,'replenishment',12700,'2024-11-15 11:07:52'),(95,'26407369',1,'replenishment',300,'2024-11-15 11:08:09'),(96,'26407369',4,'replenishment',200,'2024-11-15 11:08:09'),(97,'25359848',1,'replenishment',49,'2024-11-15 11:08:27'),(98,'25359848',2,'replenishment',85,'2024-11-15 11:08:27'),(99,'25359848',3,'replenishment',6,'2024-11-15 11:08:27'),(100,'25359848',4,'replenishment',15,'2024-11-15 11:08:27'),(101,'97146245',1,'replenishment',23,'2024-11-15 11:08:44'),(102,'97146245',2,'replenishment',18,'2024-11-15 11:08:44'),(103,'25203041',1,'replenishment',19000,'2024-11-15 11:09:22'),(104,'25203041',2,'replenishment',29000,'2024-11-15 11:09:22'),(105,'25203041',4,'replenishment',2000,'2024-11-15 11:09:22'),(106,'88215683',1,'replenishment',7310,'2024-11-15 11:09:39'),(107,'88285283',1,'replenishment',32,'2024-11-15 11:10:05'),(108,'88285283',2,'replenishment',520,'2024-11-15 11:10:05'),(109,'88285283',3,'replenishment',212,'2024-11-15 11:10:05'),(110,'88285283',4,'replenishment',43,'2024-11-15 11:10:05'),(111,'94009183',1,'replenishment',223,'2024-11-15 11:10:39'),(112,'94009183',2,'replenishment',31,'2024-11-15 11:10:39'),(113,'94009183',3,'replenishment',173,'2024-11-15 11:10:39'),(114,'94009183',4,'replenishment',18,'2024-11-15 11:10:39'),(115,'91020478',1,'replenishment',179,'2024-11-15 11:11:00'),(116,'88215635',1,'replenishment',183,'2024-11-15 11:11:52'),(117,'88215635',2,'replenishment',2445,'2024-11-15 11:11:52'),(118,'88215635',3,'replenishment',362,'2024-11-15 11:11:52'),(119,'88215635',4,'replenishment',1302,'2024-11-15 11:11:52'),(120,'88215671',1,'replenishment',88,'2024-11-15 11:12:31'),(121,'88215671',2,'replenishment',273,'2024-11-15 11:12:31'),(122,'88215671',3,'replenishment',105,'2024-11-15 11:12:31'),(123,'88215671',4,'replenishment',870,'2024-11-15 11:12:31'),(124,'88285291',1,'replenishment',7,'2024-11-15 11:12:49'),(125,'88285291',3,'replenishment',160,'2024-11-15 11:12:49'),(126,'88285291',4,'replenishment',402,'2024-11-15 11:12:49'),(127,'94009178',1,'replenishment',319,'2024-11-15 11:13:08'),(128,'94009178',2,'replenishment',752,'2024-11-15 11:13:08'),(129,'94009178',3,'replenishment',400,'2024-11-15 11:13:08'),(130,'94009178',4,'replenishment',752,'2024-11-15 11:13:08'),(131,'88215680',1,'replenishment',2420,'2024-11-15 11:13:30'),(132,'92041271',1,'replenishment',204,'2024-11-15 11:13:50'),(133,'92041271',2,'replenishment',513,'2024-11-15 11:13:50'),(134,'92041271',3,'replenishment',70,'2024-11-15 11:13:50'),(135,'92041271',4,'replenishment',584,'2024-11-15 11:13:50'),(136,'88285278',1,'replenishment',297,'2024-11-15 11:14:50'),(137,'88285278',2,'replenishment',205,'2024-11-15 11:14:50'),(138,'88285278',3,'replenishment',76,'2024-11-15 11:14:50'),(139,'88285278',4,'replenishment',341,'2024-11-15 11:14:50'),(140,'88254233',2,'replenishment',123,'2024-11-15 11:15:09'),(141,'88254233',3,'replenishment',123,'2024-11-15 11:15:09'),(142,'88215669',1,'replenishment',206,'2024-11-15 11:15:27'),(143,'88215669',2,'replenishment',533,'2024-11-15 11:15:27'),(144,'88215669',3,'replenishment',151,'2024-11-15 11:15:27'),(145,'88215669',4,'replenishment',1134,'2024-11-15 11:15:27'),(146,'88215679',1,'replenishment',9900,'2024-11-15 11:15:45'),(147,'88285281',1,'replenishment',14,'2024-11-15 11:16:05'),(148,'88285281',2,'replenishment',41,'2024-11-15 11:16:05'),(149,'88285281',3,'replenishment',348,'2024-11-15 11:16:05'),(150,'88285281',4,'replenishment',251,'2024-11-15 11:16:05'),(151,'91020476',1,'replenishment',460,'2024-11-15 11:16:30'),(152,'91020476',2,'replenishment',367,'2024-11-15 11:16:30'),(153,'91020476',3,'replenishment',200,'2024-11-15 11:16:30'),(154,'91020476',4,'replenishment',168,'2024-11-15 11:16:30'),(155,'25918152',1,'replenishment',1200,'2024-11-15 11:17:04'),(156,'25918152',2,'replenishment',500,'2024-11-15 11:17:04'),(157,'25918152',4,'replenishment',3900,'2024-11-15 11:17:04'),(158,'96048514',1,'replenishment',8645,'2024-11-15 11:18:32'),(159,'96048514',2,'replenishment',22044,'2024-11-15 11:18:32'),(160,'96048514',3,'replenishment',1641,'2024-11-15 11:18:32'),(161,'96048514',4,'replenishment',4377,'2024-11-15 11:18:32'),(162,'97205619',1,'replenishment',1725,'2024-11-15 11:18:51'),(163,'97205619',2,'replenishment',7578,'2024-11-15 11:18:51'),(164,'97205619',3,'replenishment',110,'2024-11-15 11:18:51'),(165,'97205619',4,'replenishment',679,'2024-11-15 11:18:51'),(166,'88055396',1,'replenishment',1324,'2024-11-15 11:19:09'),(167,'88055396',2,'replenishment',1950,'2024-11-15 11:19:09'),(168,'25245128',1,'replenishment',2500,'2024-11-15 11:19:26'),(169,'25245128',2,'replenishment',3500,'2024-11-15 11:19:26'),(170,'25245128',3,'replenishment',1200,'2024-11-15 11:19:26'),(171,'25245128',4,'replenishment',6200,'2024-11-15 11:19:26'),(172,'94048146',1,'replenishment',196,'2024-11-15 11:19:47'),(173,'94048146',2,'replenishment',382,'2024-11-15 11:19:47'),(174,'94048146',4,'replenishment',46,'2024-11-15 11:19:47'),(175,'94048147',1,'replenishment',500,'2024-11-15 11:20:10'),(176,'94048147',2,'replenishment',1563,'2024-11-15 11:20:10'),(177,'94048147',4,'replenishment',445,'2024-11-15 11:20:10'),(178,'25163066',1,'replenishment',8954,'2024-11-15 11:20:28'),(179,'25163066',2,'replenishment',980,'2024-11-15 11:20:28'),(180,'25163066',3,'replenishment',85,'2024-11-15 11:20:28'),(181,'25163066',4,'replenishment',2204,'2024-11-15 11:20:28'),(182,'88128885',1,'replenishment',20255,'2024-11-15 11:20:46'),(183,'88128885',2,'replenishment',25047,'2024-11-15 11:20:46'),(184,'88128885',3,'replenishment',13,'2024-11-15 11:20:46'),(185,'88128885',4,'replenishment',19288,'2024-11-15 11:20:46'),(186,'25172177',1,'replenishment',927,'2024-11-15 11:21:07'),(187,'25172177',2,'replenishment',404,'2024-11-15 11:21:07'),(188,'25172177',3,'replenishment',7,'2024-11-15 11:21:07'),(189,'25172177',4,'replenishment',174,'2024-11-15 11:21:07'),(190,'25080958',1,'replenishment',3831,'2024-11-15 11:21:28'),(191,'25080958',2,'replenishment',6709,'2024-11-15 11:21:28'),(192,'25080958',3,'replenishment',125,'2024-11-15 11:21:28'),(193,'25080958',4,'replenishment',2827,'2024-11-15 11:21:28'),(194,'25080907',1,'replenishment',716,'2024-11-15 11:21:54'),(195,'25080907',2,'replenishment',1370,'2024-11-15 11:21:54'),(196,'25080907',3,'replenishment',58,'2024-11-15 11:21:54'),(197,'25080912',1,'replenishment',111,'2024-11-15 11:22:11'),(198,'25080912',2,'replenishment',127,'2024-11-15 11:22:11'),(199,'25080912',3,'replenishment',4,'2024-11-15 11:22:11'),(200,'88128867',1,'replenishment',438,'2024-11-15 11:22:29'),(201,'88128867',2,'replenishment',1906,'2024-11-15 11:22:29'),(202,'88128867',4,'replenishment',321,'2024-11-15 11:22:29'),(203,'88128870',1,'replenishment',600,'2024-11-15 11:22:47'),(204,'88128870',2,'replenishment',997,'2024-11-15 11:22:47'),(205,'88128870',4,'replenishment',217,'2024-11-15 11:22:47'),(206,'26433922',2,'replenishment',155,'2024-11-15 11:23:05'),(207,'25718291',1,'replenishment',71,'2024-11-15 11:23:23'),(208,'25718291',2,'replenishment',188,'2024-11-15 11:23:23'),(209,'25718291',3,'replenishment',33,'2024-11-15 11:23:23'),(210,'25718291',4,'replenishment',417,'2024-11-15 11:23:23'),(211,'25089269',3,'replenishment',24,'2024-11-15 11:23:41'),(212,'88156340',1,'replenishment',170,'2024-11-15 11:24:02'),(213,'88156340',2,'replenishment',158,'2024-11-15 11:24:02'),(214,'88156340',3,'replenishment',5,'2024-11-15 11:24:02'),(215,'88156340',4,'replenishment',7,'2024-11-15 11:24:02'),(216,'25201222',2,'replenishment',72,'2024-11-15 11:24:28'),(217,'25201222',3,'replenishment',68,'2024-11-15 11:24:28'),(218,'88128832',1,'replenishment',330,'2024-11-15 11:25:04'),(219,'88128832',2,'replenishment',758,'2024-11-15 11:25:04'),(220,'88128832',4,'replenishment',172,'2024-11-15 11:25:04'),(221,'88158132',1,'replenishment',25,'2024-11-15 11:25:22'),(222,'25171378',1,'replenishment',18758,'2024-11-15 11:26:02'),(223,'25171378',2,'replenishment',16075,'2024-11-15 11:26:03'),(224,'25171378',3,'replenishment',405,'2024-11-15 11:26:03'),(225,'25171378',4,'replenishment',198,'2024-11-15 11:26:03'),(226,'25241857',1,'replenishment',279,'2024-11-15 11:26:23'),(227,'25241857',4,'replenishment',14,'2024-11-15 11:26:23'),(228,'25718308',1,'replenishment',288,'2024-11-15 11:26:43'),(229,'25718308',4,'replenishment',328,'2024-11-15 11:26:43'),(230,'26698548',1,'replenishment',176,'2024-11-15 11:27:04'),(231,'26698548',2,'replenishment',509,'2024-11-15 11:27:04'),(232,'26698548',4,'replenishment',1291,'2024-11-15 11:27:04'),(233,'26698524',1,'replenishment',36,'2024-11-15 11:27:27'),(234,'26698524',2,'replenishment',1898,'2024-11-15 11:27:27'),(235,'26698524',4,'replenishment',843,'2024-11-15 11:27:27'),(236,'96042616',1,'replenishment',2395,'2024-11-15 11:27:52'),(237,'96042616',2,'replenishment',2450,'2024-11-15 11:27:52'),(238,'96042616',3,'replenishment',40,'2024-11-15 11:27:52'),(239,'96042616',4,'replenishment',2032,'2024-11-15 11:27:52'),(240,'25080786',1,'replenishment',425,'2024-11-15 11:28:17'),(241,'25080786',2,'replenishment',581,'2024-11-15 11:28:17'),(242,'25080792',1,'replenishment',401,'2024-11-15 11:28:35'),(243,'25080792',2,'replenishment',342,'2024-11-15 11:28:35'),(244,'25080792',3,'replenishment',1,'2024-11-15 11:28:35'),(245,'88156449',1,'replenishment',328,'2024-11-15 11:28:53'),(246,'88156449',2,'replenishment',727,'2024-11-15 11:28:53'),(247,'88156449',3,'replenishment',5,'2024-11-15 11:28:53'),(248,'88156449',4,'replenishment',242,'2024-11-15 11:28:53'),(249,'96081044',1,'replenishment',332,'2024-11-15 11:29:17'),(250,'94035117',1,'replenishment',25,'2024-11-15 11:29:53'),(251,'95028867',1,'replenishment',1334,'2024-11-15 11:30:14'),(252,'95028867',4,'replenishment',13,'2024-11-15 11:30:14'),(253,'25235429',1,'replenishment',197,'2024-11-15 11:30:34'),(254,'25235429',2,'replenishment',86,'2024-11-15 11:30:34'),(255,'25235429',3,'replenishment',27,'2024-11-15 11:30:34'),(256,'25235429',4,'replenishment',4,'2024-11-15 11:30:34'),(257,'88283891',1,'replenishment',1575,'2024-11-15 11:30:53'),(258,'88283891',2,'replenishment',7245,'2024-11-15 11:30:53'),(259,'88283891',3,'replenishment',6930,'2024-11-15 11:30:53'),(260,'88283891',4,'replenishment',26460,'2024-11-15 11:30:53'),(261,'22048519',1,'replenishment',38,'2024-11-15 11:31:10'),(262,'25112792',1,'replenishment',6,'2024-11-15 11:31:34'),(263,'25112792',2,'replenishment',59,'2024-11-15 11:31:34'),(264,'25112792',3,'replenishment',25,'2024-11-15 11:31:34'),(265,'25651668',1,'replenishment',524,'2024-11-15 11:31:52'),(266,'25651668',2,'replenishment',530,'2024-11-15 11:31:52'),(267,'25651668',3,'replenishment',21,'2024-11-15 11:31:52'),(268,'25651670',1,'replenishment',205,'2024-11-15 11:32:28'),(269,'25651670',2,'replenishment',233,'2024-11-15 11:32:28'),(270,'88313877',1,'replenishment',316,'2024-11-15 11:33:30'),(271,'88313877',2,'replenishment',213,'2024-11-15 11:33:30'),(272,'88313877',3,'replenishment',14,'2024-11-15 11:33:30'),(273,'88313877',4,'replenishment',109,'2024-11-15 11:33:30'),(274,'88313876',1,'replenishment',496,'2024-11-15 11:33:48'),(275,'88313876',2,'replenishment',655,'2024-11-15 11:33:48'),(276,'88313876',3,'replenishment',45,'2024-11-15 11:33:48'),(277,'88313871',1,'replenishment',114,'2024-11-15 11:34:32'),(278,'88313871',2,'replenishment',109,'2024-11-15 11:34:32'),(279,'88313871',3,'replenishment',9,'2024-11-15 11:34:32'),(280,'88313871',4,'replenishment',1040,'2024-11-15 11:34:32'),(281,'89003741',1,'replenishment',50,'2024-11-15 11:34:49'),(282,'89003741',2,'replenishment',68,'2024-11-15 11:34:49'),(283,'89003741',4,'replenishment',239,'2024-11-15 11:34:49'),(284,'89003742',3,'replenishment',11,'2024-11-15 11:35:08'),(285,'89003743',1,'replenishment',109,'2024-11-15 11:35:50'),(286,'89003743',2,'replenishment',90,'2024-11-15 11:35:50'),(287,'89003743',4,'replenishment',41,'2024-11-15 11:35:50'),(288,'88313868',1,'replenishment',470,'2024-11-15 11:36:25'),(289,'88313868',2,'replenishment',162,'2024-11-15 11:36:25'),(290,'88313867',1,'replenishment',62,'2024-11-15 11:36:42'),(291,'88313867',2,'replenishment',68,'2024-11-15 11:36:42'),(292,'88313867',3,'replenishment',11,'2024-11-15 11:36:42'),(293,'88313867',4,'replenishment',24,'2024-11-15 11:36:42'),(294,'88243268',1,'replenishment',110,'2024-11-15 11:36:59'),(295,'88243268',2,'replenishment',1425,'2024-11-15 11:36:59'),(296,'88243268',3,'replenishment',1,'2024-11-15 11:36:59'),(297,'88054327',1,'replenishment',852,'2024-11-15 11:37:17'),(298,'88054327',2,'replenishment',7100,'2024-11-15 11:37:17'),(299,'88054327',3,'replenishment',100,'2024-11-15 11:37:17'),(300,'88054327',4,'replenishment',7700,'2024-11-15 11:37:17'),(301,'88073661',1,'replenishment',1952,'2024-11-15 11:37:46'),(302,'88073661',2,'replenishment',6808,'2024-11-15 11:37:46'),(303,'88073661',4,'replenishment',1655,'2024-11-15 11:37:46'),(304,'22004725',1,'replenishment',900,'2024-11-15 11:38:04'),(305,'22004725',2,'replenishment',387,'2024-11-15 11:38:04'),(306,'22004725',3,'replenishment',17,'2024-11-15 11:38:04'),(307,'22004725',4,'replenishment',282,'2024-11-15 11:38:04'),(308,'88284544',1,'replenishment',14000,'2024-11-15 11:38:42'),(309,'88284544',2,'replenishment',83500,'2024-11-15 11:38:42'),(310,'88284544',3,'replenishment',15000,'2024-11-15 11:38:42'),(311,'88284544',4,'replenishment',27000,'2024-11-15 11:38:42'),(312,'88284528',1,'replenishment',5000,'2024-11-15 11:39:08'),(313,'88284528',2,'replenishment',64000,'2024-11-15 11:39:08'),(314,'88284528',3,'replenishment',8000,'2024-11-15 11:39:08'),(315,'88284528',4,'replenishment',17500,'2024-11-15 11:39:08'),(316,'88284538',1,'replenishment',17000,'2024-11-15 11:39:26'),(317,'88284538',2,'replenishment',203500,'2024-11-15 11:39:26'),(318,'88284538',3,'replenishment',21000,'2024-11-15 11:39:26'),(319,'88284538',4,'replenishment',29000,'2024-11-15 11:39:26'),(320,'88158576',1,'replenishment',158,'2024-11-15 11:39:43'),(321,'25245070',1,'replenishment',12000,'2024-11-15 11:40:06'),(322,'25245070',2,'replenishment',6400,'2024-11-15 11:40:06'),(323,'25245070',4,'replenishment',4700,'2024-11-15 11:40:06'),(324,'25085291',1,'replenishment',10600,'2024-11-15 11:40:24'),(325,'25085291',2,'replenishment',12200,'2024-11-15 11:40:24'),(326,'25085291',3,'replenishment',1300,'2024-11-15 11:40:24'),(327,'25085291',4,'replenishment',5300,'2024-11-15 11:40:24'),(328,'88073716',1,'replenishment',872,'2024-11-15 11:40:51'),(329,'88073716',2,'replenishment',380,'2024-11-15 11:40:51'),(330,'88073716',3,'replenishment',23,'2024-11-15 11:40:51'),(331,'88073716',4,'replenishment',556,'2024-11-15 11:40:51'),(332,'88073717',1,'replenishment',613,'2024-11-15 11:41:09'),(333,'88073717',2,'replenishment',2469,'2024-11-15 11:41:09'),(334,'88073717',3,'replenishment',179,'2024-11-15 11:41:09'),(335,'88073717',4,'replenishment',1491,'2024-11-15 11:41:09'),(336,'88073718',1,'replenishment',189,'2024-11-15 11:41:31'),(337,'88073718',2,'replenishment',99,'2024-11-15 11:41:31'),(338,'88073718',3,'replenishment',95,'2024-11-15 11:41:31'),(339,'88073718',4,'replenishment',277,'2024-11-15 11:41:31'),(340,'88073726',1,'replenishment',453,'2024-11-15 11:41:56'),(341,'88073726',2,'replenishment',1759,'2024-11-15 11:41:56'),(342,'88073726',4,'replenishment',561,'2024-11-15 11:41:56'),(343,'88073727',1,'replenishment',1679,'2024-11-15 11:42:14'),(344,'88073727',2,'replenishment',2505,'2024-11-15 11:42:14'),(345,'88073727',3,'replenishment',825,'2024-11-15 11:42:14'),(346,'88073727',4,'replenishment',4499,'2024-11-15 11:42:14'),(347,'88073728',1,'replenishment',880,'2024-11-15 11:42:41'),(348,'88073728',2,'replenishment',3318,'2024-11-15 11:42:41'),(349,'88073728',3,'replenishment',125,'2024-11-15 11:42:41'),(350,'88073728',4,'replenishment',1973,'2024-11-15 11:42:41'),(351,'26538337',2,'sale',150,'2024-11-15 12:23:50'),(352,'88055368',4,'sale',100,'2024-11-15 12:27:58'),(353,'94009183',2,'replenishment',2,'2024-11-15 12:44:00'),(354,'25718291',3,'sale',9,'2024-11-15 12:57:05'),(355,'25171378',1,'sale',888,'2024-11-15 12:59:08'),(356,'88313876',2,'sale',8,'2024-11-15 13:05:18'),(357,'89003742',2,'replenishment',150,'2024-11-15 13:07:18'),(358,'88243268',2,'replenishment',30,'2024-11-15 13:09:14'),(359,'22004725',1,'replenishment',550,'2024-11-15 13:10:13'),(360,'88284544',2,'sale',1000,'2024-11-15 13:10:31'),(361,'88284528',2,'sale',1000,'2024-11-15 13:10:54'),(362,'88284538',2,'sale',500,'2024-11-15 13:11:11'),(363,'88073717',2,'sale',20,'2024-11-15 13:12:51'),(364,'88073718',2,'sale',10,'2024-11-15 13:13:10'),(365,'88073727',2,'sale',120,'2024-11-15 13:13:46'),(366,'88073728',2,'sale',80,'2024-11-15 13:14:06'),(367,'26538337',2,'sale',375,'2024-11-15 13:34:59'),(368,'88128842',4,'replenishment',75,'2024-11-15 13:35:20'),(369,'91029085',1,'replenishment',130,'2024-11-15 13:44:47'),(370,'88215671',2,'sale',16,'2024-11-15 13:53:00'),(371,'25080907',4,'replenishment',144,'2024-11-15 14:03:47'),(372,'25080912',4,'replenishment',3,'2024-11-15 14:04:05'),(373,'26433922',4,'replenishment',5,'2024-11-15 14:05:31'),(374,'26698548',2,'sale',342,'2024-11-15 14:08:44'),(375,'26698524',2,'sale',204,'2024-11-15 14:09:01'),(376,'25080786',4,'replenishment',11,'2024-11-15 14:09:52'),(377,'25080792',4,'replenishment',18,'2024-11-15 14:10:26'),(378,'88054327',2,'replenishment',100,'2024-11-15 14:18:02'),(379,'88073717',1,'replenishment',475,'2024-11-15 14:21:15'),(380,'88073717',2,'sale',50,'2024-11-15 14:21:15'),(381,'88073718',1,'replenishment',150,'2024-11-15 14:21:36'),(382,'88073718',2,'sale',50,'2024-11-15 14:21:36'),(383,'25940472',1,'replenishment',600,'2024-11-15 14:57:51'),(384,'25940472',2,'replenishment',50,'2024-11-15 14:57:51'),(385,'22125305',1,'replenishment',300,'2024-11-15 14:58:08'),(386,'88055389',1,'replenishment',900,'2024-11-15 14:59:02'),(387,'88055389',2,'sale',1250,'2024-11-15 14:59:02'),(388,'88055368',1,'replenishment',350,'2024-11-15 14:59:20'),(389,'26388387',1,'replenishment',675,'2024-11-15 14:59:38'),(390,'88285283',4,'replenishment',450,'2024-11-15 15:13:22'),(391,'94009183',4,'replenishment',150,'2024-11-15 15:13:48'),(392,'96048514',2,'sale',2000,'2024-11-15 15:20:27'),(393,'97205619',2,'sale',2000,'2024-11-15 15:20:45'),(394,'88128832',2,'sale',30,'2024-11-15 15:27:50'),(395,'95028867',4,'replenishment',22,'2024-11-15 15:32:09'),(396,'25651670',2,'replenishment',2,'2024-11-15 15:34:29'),(397,'88313870',4,'replenishment',34,'2024-11-15 15:36:58'),(398,'88313868',4,'replenishment',311,'2024-11-15 15:37:51'),(399,'88243268',3,'replenishment',2,'2024-11-15 15:38:30'),(400,'88073661',1,'sale',8,'2024-11-15 15:39:06'),(401,'88073661',2,'sale',800,'2024-11-15 15:39:06'),(402,'88284544',2,'sale',500,'2024-11-15 15:40:00'),(403,'88284538',2,'sale',500,'2024-11-15 15:40:55'),(404,'88284538',4,'sale',1500,'2024-11-15 15:40:55'),(405,'26538337',2,'replenishment',305,'2024-11-15 16:12:14'),(406,'88055386',1,'sale',3,'2024-11-15 16:15:17'),(407,'22118581',1,'replenishment',8,'2024-11-15 16:18:36'),(408,'90001512',4,'sale',100,'2024-11-15 16:28:12'),(409,'94009183',1,'replenishment',73,'2024-11-15 16:31:02'),(410,'88215635',4,'sale',8,'2024-11-15 16:32:11'),(411,'88215671',4,'sale',6,'2024-11-15 16:33:05'),(412,'88215669',1,'sale',25,'2024-11-15 16:35:51'),(413,'88215669',2,'sale',10,'2024-11-15 16:35:51'),(414,'88215669',4,'sale',16,'2024-11-15 16:35:51'),(415,'88285281',2,'sale',25,'2024-11-15 16:36:29');
/*!40000 ALTER TABLE `stock_changes` 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 2024-11-15 16:50:08
