-- MySQL dump 10.13  Distrib 8.4.7, for Linux (x86_64)
--
-- Host: localhost    Database: primagroup
-- ------------------------------------------------------
-- Server version	8.4.7

/*!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 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 `customer`
--

DROP TABLE IF EXISTS `customer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `customer` (
  `id` int NOT NULL AUTO_INCREMENT,
  `bizname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `shopname` varchar(50) DEFAULT NULL,
  `billaddress` varchar(255) NOT NULL,
  `deliveraddr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `contact` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `abn` varchar(15) DEFAULT NULL,
  `filename` varchar(15) NOT NULL,
  `discount` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Customer Details';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customer`
--

LOCK TABLES `customer` WRITE;
/*!40000 ALTER TABLE `customer` DISABLE KEYS */;
INSERT INTO `customer` VALUES (1,'Seahorse Brother Pty Ltd','Seahorse Brother','2 Loch St, Campsie NSW 2194',NULL,'(02) 9787 9122','Frendy - 0413 199 602','31 101 481 921','seahorse',0),(2,'White Lotus Asian Food Market',NULL,'379 Anzac Pde, Kingsford NSW 2032',NULL,'(02) 9662 7736','Ko Athiam Lau - 0433 145 002','44 870 043 087','whitelotus',0),(3,'H2O Mart Pty Ltd','H2O Indo Store','309 Castlereagh St, Sydney NSW 2000','303 Castlereagh St, Haymarket NSW 2000','(02) 9281 0276','Hendry Lie - 0422 402 388','62 606 242 924','h2ocity',2),(4,'Beta Indo Grocery Pty Ltd','Beta Indo Grocery','208-210 Coward St, Mascot NSW 2020',NULL,'0482 377 050','Andy','74 687 838 884','beta',0),(5,'Deborah & Nehemiah Pty Ltd','Panda Asia Market','84 Railway Pde, Kogarah NSW 2217',NULL,'0413 682 216','Ko Salim','49 635 859 371','panda',0),(6,'Deustar Pty Ltd','Alpha Mart','92 Cahors Rd, Padstow NSW 2211',NULL,'0421 775 555','Ci Catherine','45 612 169 687','alphamart',0),(7,'Laladan Pty Ltd','Lala Indo Market','Shop 5/60-62 Oxford Rd, Ingleburn NSW 2565',NULL,'0452 473 066','Ci Lala','75 678 119 607','lalaindo',0),(8,'INDOmarket Punchbowl',NULL,'250 The Boulevarde, Punchbowl NSW 2196',NULL,'(02) 8958 7885','Pak Fauzi',NULL,'indomarket',0),(9,'Helen Mascot Supermarket Pty Ltd','Helen Mascot Supermarket','988 Botany Rd, Mascot NSW 2020',NULL,'(02) 8383 1205','Ci Helen','64 619 930 399','helenmascot',2),(10,'Chua, Lizel Austria','Pinoy Grocer','8 Butler Rd, Hurstville NSW 2220',NULL,'0481 235 898','Lizel','30 433 006 061','pinoygrocer',0),(11,'Eulogia (NSW) Pty Ltd','Panda Asia Market (City)','382 Sussex St, Sydney NSW 2000',NULL,'0433 136 227','Teresa Wong - teresa.salim@hotmail.com','46 678 748 000','pandacity',0),(12,'Cash',NULL,'Sydney, NSW 2000',NULL,NULL,NULL,NULL,'cash',0),(13,'Omega Mart Grocery Pty Ltd','Omega Mart Grocery (OMG)','69 Liverpool St, Sydney NSW 2000',NULL,'0450 831 300','Siskalia','54 672 071 162','omega',0),(14,'L\'Artisan Focaccia Pty Ltd','Calista','370 Pitt St, Sydney NSW 2000',NULL,'+62 813 4551 1717','Ci Erni',NULL,'calista',0),(15,'Indo Cafe & Restaurant',NULL,'11/2/8 Knox St, Belmore NSW 2192',NULL,'0470 588 460','Bu Rohani - 0470 588 460',NULL,'indocafe',0),(16,'Ala Indo Pty Ltd','A\'la Indo Resto','Shop 1/220 King St, Mascot NSW 2020',NULL,'0434 106 571','Ci Ling-Ling - 0434 106 571','35 622 106 647','alaindo',0);
/*!40000 ALTER TABLE `customer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `priced`
--

DROP TABLE IF EXISTS `priced`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `priced` (
  `productid` int NOT NULL,
  `price` decimal(7,2) NOT NULL,
  `margin` decimal(5,2) NOT NULL,
  `reason` varchar(10) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  KEY `time` (`time`),
  KEY `productid` (`productid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Current Pricelist';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `priced`
--

LOCK TABLES `priced` WRITE;
/*!40000 ALTER TABLE `priced` DISABLE KEYS */;
INSERT INTO `priced` VALUES (1,0.90,50.00,'initial','2025-08-18 06:21:48'),(2,2.65,14.72,'initial','2025-08-18 06:21:48'),(3,8.00,35.59,'initial','2025-08-18 06:21:48'),(4,2.70,37.06,'initial','2025-08-18 06:21:48'),(5,2.00,38.89,'initial','2025-08-18 06:21:48'),(6,2.00,36.05,'initial','2025-08-18 06:21:48'),(7,2.00,29.03,'initial','2025-08-18 06:21:48'),(8,7.00,28.91,'initial','2025-08-18 06:21:48'),(9,0.90,40.63,'initial','2025-08-18 06:21:48'),(10,0.90,40.63,'initial','2025-08-18 06:21:48'),(11,0.90,40.63,'initial','2025-08-18 06:21:48'),(12,4.20,16.67,'initial','2025-08-18 06:21:48'),(13,2.40,10.60,'initial','2025-08-18 06:21:48'),(14,2.10,16.67,'initial','2025-08-18 06:21:48'),(15,1.10,50.68,'initial','2025-08-18 06:21:48'),(16,1.10,50.68,'initial','2025-08-18 06:21:48'),(17,1.10,50.68,'initial','2025-08-18 06:21:48'),(18,1.95,9.55,'initial','2025-08-18 06:21:48'),(19,1.95,9.55,'initial','2025-08-18 06:21:48'),(20,4.70,44.17,'initial','2025-08-18 06:21:48'),(21,1.40,50.54,'initial','2025-08-18 06:21:48'),(22,1.40,50.54,'initial','2025-08-18 06:21:48'),(23,1.40,50.54,'initial','2025-08-18 06:21:48'),(24,0.35,84.21,'initial','2025-08-18 06:21:48'),(25,0.35,84.21,'initial','2025-08-18 06:21:48'),(26,0.35,84.21,'initial','2025-08-18 06:21:48'),(27,0.35,84.21,'initial','2025-08-18 06:21:48'),(28,0.35,84.21,'initial','2025-08-18 06:21:48'),(29,0.35,84.21,'initial','2025-08-18 06:21:48'),(30,0.35,84.21,'initial','2025-08-18 06:21:48'),(31,3.50,45.23,'initial','2025-08-18 06:21:48'),(32,1.65,33.06,'initial','2025-08-18 06:21:48'),(33,1.55,40.91,'initial','2025-08-18 06:21:48'),(34,1.55,26.02,'initial','2025-08-18 06:21:48'),(35,2.15,15.59,'initial','2025-08-18 06:21:48'),(36,1.20,81.82,'initial','2025-08-18 06:21:48'),(37,0.85,23.19,'initial','2025-08-18 06:21:48'),(38,0.85,23.19,'initial','2025-08-18 06:21:48'),(39,0.85,23.19,'initial','2025-08-18 06:21:48'),(40,0.85,23.19,'initial','2025-08-18 06:21:48'),(41,0.85,23.19,'initial','2025-08-18 06:21:48'),(42,1.80,24.14,'initial','2025-08-18 06:21:48'),(43,1.15,35.29,'initial','2025-08-18 06:21:48'),(44,1.15,41.98,'initial','2025-08-18 06:21:48'),(45,1.10,26.44,'initial','2025-08-18 06:21:48'),(46,1.10,26.44,'initial','2025-08-18 06:21:48'),(47,1.10,26.44,'initial','2025-08-18 06:21:48'),(48,1.10,26.44,'initial','2025-08-18 06:21:48'),(49,3.90,17.12,'initial','2025-08-18 06:21:48'),(50,3.90,17.12,'initial','2025-08-18 06:21:48'),(51,0.85,26.87,'initial','2025-08-18 06:21:48'),(52,0.85,26.87,'initial','2025-08-18 06:21:48'),(53,0.85,26.87,'initial','2025-08-18 06:21:48'),(54,0.85,26.87,'initial','2025-08-18 06:21:48'),(55,0.85,26.87,'initial','2025-08-18 06:21:48'),(56,0.85,26.87,'initial','2025-08-18 06:21:48'),(57,3.90,2.36,'initial','2025-08-18 06:21:48'),(58,2.35,29.83,'initial','2025-08-18 06:21:48'),(59,3.50,54.19,'initial','2025-08-18 06:21:48'),(60,1.25,34.41,'initial','2025-08-18 06:21:48'),(61,1.50,57.89,'initial','2025-08-18 06:21:48'),(62,3.30,20.44,'initial','2025-08-18 06:21:48'),(63,1.15,13.86,'initial','2025-08-18 06:21:48'),(64,1.15,13.86,'initial','2025-08-18 06:21:48'),(65,1.15,13.86,'initial','2025-08-18 06:21:48'),(66,1.15,13.86,'initial','2025-08-18 06:21:48'),(67,1.15,13.86,'initial','2025-08-18 06:21:48'),(68,2.85,28.38,'initial','2025-08-18 06:21:48'),(69,1.55,37.17,'initial','2025-08-18 06:21:48'),(70,1.55,37.17,'initial','2025-08-18 06:21:48'),(71,1.55,37.17,'initial','2025-08-18 06:21:48'),(72,1.60,34.45,'initial','2025-08-18 06:21:48'),(73,1.50,35.14,'initial','2025-08-18 06:21:48'),(74,1.50,35.14,'initial','2025-08-18 06:21:48'),(75,1.20,100.00,'initial','2025-08-18 06:21:48'),(76,1.20,100.00,'initial','2025-08-18 06:21:48'),(77,1.20,100.00,'initial','2025-08-18 06:21:48'),(78,8.50,151.48,'initial','2025-08-18 06:21:48'),(79,1.20,69.01,'initial','2025-08-18 06:21:48'),(80,1.30,22.64,'initial','2025-08-18 06:21:48'),(81,1.30,54.76,'initial','2025-08-18 06:21:48'),(82,1.20,-7.69,'initial','2025-08-18 06:21:48'),(83,12.10,37.81,'initial','2025-08-18 06:21:48'),(84,2.20,41.03,'initial','2025-08-18 06:21:48'),(85,4.00,68.07,'initial','2025-08-18 06:21:48'),(86,1.20,50.00,'initial','2025-08-18 06:21:48'),(87,3.90,43.38,'initial','2025-08-18 06:21:48'),(88,4.30,39.61,'initial','2025-08-18 06:21:48'),(89,4.30,39.61,'initial','2025-08-18 06:21:48'),(90,3.90,53.54,'initial','2025-08-18 06:21:48'),(91,3.90,53.54,'initial','2025-08-18 06:21:48'),(92,3.40,51.79,'initial','2025-08-18 06:21:48'),(93,3.60,52.54,'initial','2025-08-18 06:21:48'),(94,4.30,39.61,'initial','2025-08-18 06:21:48'),(95,4.30,39.61,'initial','2025-08-18 06:21:48'),(96,1.05,12.90,'initial','2025-08-18 06:21:48'),(97,1.05,9.38,'initial','2025-08-18 06:21:48'),(98,1.05,9.38,'initial','2025-08-18 06:21:48'),(99,4.50,42.86,'initial','2025-08-18 06:21:48'),(100,4.50,42.86,'initial','2025-08-18 06:21:48'),(101,1.10,52.78,'initial','2025-08-18 06:21:48'),(102,1.20,50.00,'initial','2025-08-18 06:21:48'),(103,1.10,44.74,'initial','2025-08-18 06:21:48'),(104,1.35,31.07,'initial','2025-08-18 06:21:48'),(105,2.95,29.96,'initial','2025-08-18 06:21:48'),(106,1.50,72.41,'initial','2025-08-18 06:21:48'),(107,2.55,18.60,'initial','2025-08-18 06:21:48'),(108,2.55,18.60,'initial','2025-08-18 06:21:48'),(109,1.50,27.12,'initial','2025-08-18 06:21:48'),(110,1.50,16.28,'initial','2025-08-18 06:21:48'),(111,2.60,39.78,'initial','2025-08-18 06:21:48'),(112,0.95,37.68,'initial','2025-08-18 06:21:48'),(113,0.95,37.68,'initial','2025-08-18 06:21:48'),(114,0.95,37.68,'initial','2025-08-18 06:21:48'),(115,0.95,37.68,'initial','2025-08-18 06:21:48'),(116,0.95,37.68,'initial','2025-08-18 06:21:48'),(117,4.50,1.12,'initial','2025-08-18 06:21:48'),(118,4.50,1.12,'initial','2025-08-18 06:21:48'),(119,4.50,1.12,'initial','2025-08-18 06:21:48'),(120,4.50,1.12,'initial','2025-08-18 06:21:48'),(121,4.50,1.12,'initial','2025-08-18 06:21:48'),(122,0.50,51.52,'initial','2025-08-18 06:21:48'),(123,0.50,51.52,'initial','2025-08-18 06:21:48'),(124,0.50,51.52,'initial','2025-08-18 06:21:48'),(125,0.60,20.00,'initial','2025-08-18 06:21:48'),(126,0.60,20.00,'initial','2025-08-18 06:21:48'),(127,0.60,20.00,'initial','2025-08-18 06:21:48'),(128,0.60,20.00,'initial','2025-08-18 06:21:48'),(129,1.15,19.79,'initial','2025-08-18 06:21:48'),(130,1.15,19.79,'initial','2025-08-18 06:21:48'),(131,0.95,37.68,'initial','2025-08-18 06:21:48'),(112,0.80,15.94,'comp','2025-08-31 03:40:15'),(113,0.80,15.94,'comp','2025-08-31 03:40:15'),(114,0.80,15.94,'comp','2025-08-31 03:40:15'),(115,0.80,15.94,'comp','2025-08-31 03:40:15'),(116,0.80,15.94,'comp','2025-08-31 03:40:15'),(111,2.40,29.03,'comp','2025-08-31 03:45:49'),(125,0.55,10.00,'comp','2025-08-31 03:52:44'),(126,0.55,10.00,'comp','2025-08-31 03:52:44'),(127,0.55,10.00,'comp','2025-08-31 03:52:44'),(128,0.55,10.00,'comp','2025-08-31 03:52:44'),(45,1.00,14.95,'comp','2025-08-31 03:55:23'),(46,1.00,14.95,'comp','2025-08-31 03:55:23'),(47,1.00,14.95,'comp','2025-08-31 03:55:23'),(48,1.00,14.95,'comp','2025-08-31 03:55:23'),(36,1.10,66.67,'comp','2025-08-31 04:08:26'),(125,6.60,10.00,'wrongqty','2025-09-01 05:09:30'),(126,6.60,10.00,'wrongqty','2025-09-01 05:09:30'),(127,6.60,10.00,'wrongqty','2025-09-01 05:09:30'),(128,6.60,10.00,'wrongqty','2025-09-01 05:09:30'),(43,1.00,17.64,'lowsales','2025-09-10 06:42:50'),(44,1.00,23.46,'lowsales','2025-09-10 06:42:50'),(3,7.50,27.12,'lowsales','2025-09-10 06:46:42'),(4,2.50,26.91,'lowsales','2025-09-10 06:48:22'),(122,0.40,21.22,'lowsales','2025-09-10 06:50:54'),(123,0.40,21.22,'lowsales','2025-09-10 06:50:54'),(124,0.40,21.22,'lowsales','2025-09-10 06:50:54'),(104,1.25,21.36,'lowsales','2025-09-10 06:53:32'),(1,0.85,41.67,'lowsales','2025-10-20 10:02:39'),(4,2.30,16.76,'lowsales','2025-10-20 10:02:39'),(11,0.85,32.82,'lowsales','2025-10-20 10:02:39'),(16,1.00,36.98,'lowsales','2025-10-20 10:02:39'),(20,4.00,22.70,'lowsales','2025-10-20 10:02:39'),(24,0.30,57.89,'lowsales','2025-10-20 10:02:39'),(25,0.30,57.89,'lowsales','2025-10-20 10:02:39'),(26,0.30,57.89,'lowsales','2025-10-20 10:02:39'),(27,0.30,57.89,'lowsales','2025-10-20 10:02:39'),(28,0.30,57.89,'lowsales','2025-10-20 10:02:39'),(29,0.30,57.89,'lowsales','2025-10-20 10:02:39'),(30,0.30,57.89,'lowsales','2025-10-20 10:02:39'),(32,1.55,25.00,'lowsales','2025-10-20 10:02:39'),(33,1.45,31.82,'lowsales','2025-10-20 10:02:39'),(43,0.90,5.88,'lowsales','2025-10-20 10:02:39'),(44,0.90,11.11,'lowsales','2025-10-20 10:02:39'),(122,0.35,6.07,'lowsales','2025-10-20 10:02:39'),(123,0.35,6.07,'lowsales','2025-10-20 10:02:39'),(124,0.35,6.07,'lowsales','2025-10-20 10:02:39'),(129,1.10,14.58,'lowsales','2025-10-20 10:02:39'),(3,1.80,22.04,'repack','2025-11-15 03:12:21'),(5,2.00,20.71,'ship','2025-12-06 10:30:29'),(6,2.00,16.27,'ship','2025-12-06 10:30:29'),(7,2.00,11.79,'ship','2025-12-06 10:30:29'),(12,4.20,17.36,'ship','2025-12-06 10:30:29'),(14,2.10,15.93,'ship','2025-12-06 10:30:29'),(18,1.95,5.08,'ship','2025-12-06 10:30:29'),(19,1.95,5.08,'ship','2025-12-06 10:30:29'),(21,1.40,60.03,'ship','2025-12-06 10:30:29'),(22,1.50,33.14,'ship','2025-12-06 10:30:29'),(23,1.40,60.03,'ship','2025-12-06 10:30:29'),(36,1.10,56.83,'ship','2025-12-06 10:30:29'),(59,3.50,30.77,'ship','2025-12-06 10:30:29'),(60,1.25,45.30,'ship','2025-12-06 10:30:29'),(69,1.55,23.09,'ship','2025-12-06 10:30:29'),(70,1.55,23.09,'ship','2025-12-06 10:30:29'),(81,1.30,44.05,'ship','2025-12-06 10:30:29'),(83,11.00,22.40,'ship','2025-12-06 10:30:29'),(85,4.00,48.41,'ship','2025-12-06 10:30:29'),(87,4.20,40.38,'ship','2025-12-06 10:30:29'),(88,4.60,34.92,'ship','2025-12-06 10:30:29'),(89,4.60,34.92,'ship','2025-12-06 10:30:29'),(90,4.00,43.70,'ship','2025-12-06 10:30:29'),(91,4.00,43.70,'ship','2025-12-06 10:30:29'),(93,3.70,43.72,'ship','2025-12-06 10:30:29'),(94,4.60,34.92,'ship','2025-12-06 10:30:29'),(95,4.60,34.92,'ship','2025-12-06 10:30:29'),(96,1.05,13.28,'ship','2025-12-06 10:30:29'),(97,1.05,9.79,'ship','2025-12-06 10:30:29'),(98,1.05,9.79,'ship','2025-12-06 10:30:29'),(106,1.50,77.95,'ship','2025-12-06 10:30:29'),(130,1.15,25.80,'ship','2025-12-06 10:30:29'),(131,0.95,31.61,'ship','2025-12-06 10:30:29'),(132,7.70,32.43,'initial','2025-12-06 10:47:21'),(133,7.70,32.43,'initial','2025-12-06 10:47:21'),(134,7.70,32.43,'initial','2025-12-06 10:47:21'),(135,7.70,32.43,'initial','2025-12-06 10:47:21'),(136,0.85,25.74,'initial','2025-12-06 10:47:21'),(137,1.00,39.71,'initial','2025-12-06 10:47:21'),(138,0.75,38.75,'initial','2025-12-06 10:47:21'),(139,2.85,26.77,'initial','2025-12-06 10:47:21'),(140,0.50,82.26,'initial','2025-12-06 10:47:21'),(141,0.50,63.42,'initial','2025-12-06 10:47:21'),(142,0.50,82.26,'initial','2025-12-06 10:47:21'),(143,0.50,63.42,'initial','2025-12-06 10:47:21'),(144,1.00,62.11,'initial','2025-12-06 10:47:21'),(145,1.00,98.13,'initial','2025-12-06 10:47:21'),(146,7.20,185.71,'initial','2025-12-06 10:47:21'),(147,7.20,185.71,'initial','2025-12-06 10:47:21'),(148,3.60,185.71,'initial','2025-12-06 10:47:21'),(149,5.00,32.28,'initial','2025-12-06 10:47:21'),(150,3.00,25.52,'initial','2025-12-06 10:47:21'),(151,3.00,25.52,'initial','2025-12-06 10:47:21'),(152,3.00,25.52,'initial','2025-12-06 10:47:21'),(153,7.20,26.98,'initial','2025-12-06 10:47:21'),(154,0.30,185.89,'initial','2025-12-06 10:47:21'),(155,4.00,29.15,'initial','2025-12-06 10:47:21'),(156,4.00,29.15,'initial','2025-12-06 10:47:21'),(157,4.00,29.15,'initial','2025-12-06 10:47:21'),(158,1.40,51.79,'initial','2025-12-06 10:47:21'),(159,1.40,51.79,'initial','2025-12-06 10:47:21'),(160,3.00,46.02,'initial','2025-12-06 10:47:21'),(161,1.50,44.70,'initial','2025-12-06 10:47:21'),(162,1.50,44.70,'initial','2025-12-06 10:47:21'),(163,1.50,44.70,'initial','2025-12-06 10:47:21'),(164,1.10,40.48,'initial','2025-12-06 10:47:21'),(165,1.10,40.48,'initial','2025-12-06 10:47:21'),(166,1.10,40.48,'initial','2025-12-06 10:47:21'),(167,4.75,21.48,'initial','2025-12-06 10:47:21'),(168,4.75,21.48,'initial','2025-12-06 10:47:21'),(169,3.80,75.65,'initial','2025-12-06 10:47:21'),(170,3.80,75.65,'initial','2025-12-06 10:47:21'),(171,3.80,75.65,'initial','2025-12-06 10:47:21'),(172,3.80,75.65,'initial','2025-12-06 10:47:21'),(173,4.80,67.61,'initial','2025-12-06 10:47:21'),(174,4.80,67.61,'initial','2025-12-06 10:47:21'),(175,1.70,24.17,'initial','2025-12-06 10:47:21'),(176,1.70,23.50,'initial','2025-12-06 10:47:21'),(177,1.70,23.50,'initial','2025-12-06 10:47:21'),(178,4.00,55.27,'initial','2025-12-06 10:47:21'),(179,4.00,47.61,'initial','2025-12-06 10:47:21'),(180,3.85,56.30,'initial','2025-12-06 10:47:21'),(181,3.85,56.30,'initial','2025-12-06 10:47:21'),(182,1.20,109.27,'initial','2025-12-06 10:47:21'),(183,1.40,17.36,'initial','2025-12-06 10:47:21'),(184,1.30,44.05,'initial','2025-12-06 10:47:21'),(185,1.45,18.91,'initial','2025-12-06 10:47:21'),(186,3.00,76.03,'initial','2025-12-06 10:47:21'),(187,3.00,13.82,'initial','2025-12-06 10:47:21'),(188,3.00,76.03,'initial','2025-12-06 10:47:21'),(189,2.40,39.07,'initial','2025-12-06 10:47:21'),(190,2.40,39.07,'initial','2025-12-06 10:47:21'),(191,2.40,39.07,'initial','2025-12-06 10:47:21'),(192,2.40,39.07,'initial','2025-12-06 10:47:21'),(193,2.40,39.07,'initial','2025-12-06 10:47:21'),(194,1.10,38.56,'initial','2025-12-06 10:47:21'),(195,2.85,19.31,'initial','2025-12-06 10:47:21'),(196,1.60,20.46,'initial','2025-12-06 10:47:21'),(197,1.10,15.82,'initial','2025-12-06 10:47:21'),(198,0.30,169.27,'initial','2025-12-06 10:47:21'),(199,1.40,17.47,'initial','2025-12-06 10:47:21'),(200,1.45,61.56,'initial','2025-12-06 10:47:21'),(201,1.45,52.39,'initial','2025-12-06 10:47:21'),(202,1.45,57.56,'initial','2025-12-06 10:47:21'),(203,1.80,37.46,'initial','2025-12-06 10:47:21'),(204,1.80,37.46,'initial','2025-12-06 10:47:21'),(205,1.80,37.46,'initial','2025-12-06 10:47:21'),(206,1.80,37.46,'initial','2025-12-06 10:47:21'),(207,1.80,37.46,'initial','2025-12-06 10:47:21'),(208,1.80,37.46,'initial','2025-12-06 10:47:21'),(209,1.80,37.46,'initial','2025-12-06 10:47:21'),(210,1.80,37.46,'initial','2025-12-06 10:47:21'),(211,1.20,31.66,'initial','2025-12-06 10:47:21'),(212,1.20,31.66,'initial','2025-12-06 10:47:21'),(213,1.20,31.66,'initial','2025-12-06 10:47:21'),(214,0.65,22.60,'initial','2025-12-06 10:47:21'),(215,0.65,22.60,'initial','2025-12-06 10:47:21'),(216,0.65,22.60,'initial','2025-12-06 10:47:21'),(217,5.30,35.70,'initial','2025-12-06 10:47:21'),(218,0.95,31.61,'initial','2025-12-06 10:47:21'),(219,4.00,42.66,'initial','2025-12-06 10:47:21'),(220,2.50,63.46,'initial','2025-12-06 10:47:21'),(221,2.30,106.24,'initial','2025-12-06 10:47:21'),(222,1.50,34.51,'initial','2025-12-06 10:47:21'),(223,1.65,47.96,'initial','2025-12-06 10:47:21'),(224,4.00,60.95,'initial','2025-12-06 10:47:21'),(225,1.50,34.51,'initial','2025-12-06 10:47:21'),(226,1.50,34.51,'initial','2025-12-06 10:47:21'),(227,5.80,34.84,'initial','2025-12-06 10:47:21'),(228,7.80,36.00,'initial','2025-12-06 10:47:21'),(229,4.50,47.12,'initial','2025-12-06 10:47:21'),(230,4.50,41.23,'initial','2025-12-06 10:47:21'),(231,4.20,40.38,'initial','2025-12-06 10:47:21'),(232,2.60,62.42,'initial','2025-12-06 10:47:21'),(233,3.90,43.66,'initial','2025-12-06 10:47:21'),(234,4.80,40.79,'initial','2025-12-06 10:47:21'),(235,2.60,62.42,'initial','2025-12-06 10:47:21'),(236,4.80,40.79,'initial','2025-12-06 10:47:21'),(237,3.20,48.30,'initial','2025-12-06 10:47:21'),(238,3.20,48.30,'initial','2025-12-06 10:47:21'),(239,2.30,87.13,'initial','2025-12-06 10:47:21'),(240,3.30,47.60,'initial','2025-12-06 10:47:21'),(241,3.40,42.38,'initial','2025-12-06 10:47:21'),(242,2.30,83.98,'initial','2025-12-06 10:47:21'),(243,3.80,43.01,'initial','2025-12-06 10:47:21'),(244,2.40,72.44,'initial','2025-12-06 10:47:21'),(245,3.20,46.97,'initial','2025-12-06 10:47:21'),(246,10.00,107.57,'initial','2025-12-06 10:47:21'),(247,11.00,78.69,'initial','2025-12-06 10:47:21'),(248,12.50,79.63,'initial','2025-12-06 10:47:21'),(249,13.50,73.93,'initial','2025-12-06 10:47:21'),(250,15.00,75.14,'initial','2025-12-06 10:47:21'),(251,18.50,92.00,'initial','2025-12-06 10:47:21'),(178,4.25,64.97,'review','2026-01-07 07:17:57'),(179,4.25,56.84,'review','2026-01-07 07:17:57'),(217,5.15,31.86,'review','2026-01-07 09:31:00'),(224,3.60,44.85,'review','2026-01-07 10:12:38'),(227,5.50,27.87,'review','2026-01-07 10:19:06'),(228,7.50,30.77,'review','2026-01-07 10:22:51'),(4,2.20,11.68,'review','2026-01-15 07:26:16'),(24,0.25,31.57,'review','2026-01-15 07:51:32'),(25,0.25,31.57,'review','2026-01-15 07:51:32'),(26,0.25,31.57,'review','2026-01-15 07:51:32'),(27,0.25,31.57,'review','2026-01-15 07:51:32'),(28,0.25,31.57,'review','2026-01-15 07:51:32'),(29,0.25,31.57,'review','2026-01-15 07:51:32'),(30,0.25,31.57,'review','2026-01-15 07:51:32'),(43,0.85,0.00,'review','2026-01-15 08:12:45'),(44,0.85,4.94,'review','2026-01-15 08:12:45'),(64,1.10,8.91,'review','2026-01-15 10:42:28'),(81,1.10,21.89,'review','2026-01-15 10:42:28'),(138,0.70,29.50,'review','2026-01-15 10:42:28'),(199,1.35,13.27,'review','2026-01-15 10:42:28'),(138,0.60,11.00,'comp','2026-02-23 08:36:20'),(26,0.00,-100.00,'expiry','2026-03-08 06:54:36'),(30,0.20,5.26,'expiry','2026-03-08 06:54:37'),(25,0.20,5.26,'expiry','2026-03-08 06:54:37'),(81,0.90,0.00,'expiry','2026-03-08 06:54:37'),(24,0.20,5.26,'expiry','2026-03-08 06:54:37'),(4,2.00,1.52,'expiry','2026-03-08 06:54:37'),(64,1.00,-0.99,'expiry','2026-03-08 06:54:37'),(138,0.50,-7.41,'expiry','2026-03-08 06:54:37'),(140,0.40,48.15,'expiry','2026-03-08 06:54:37'),(143,0.40,29.03,'expiry','2026-03-08 06:54:37'),(21,1.20,37.93,'expiry','2026-03-08 06:54:37'),(184,1.10,22.22,'expiry','2026-03-08 06:54:37'),(141,0.40,29.03,'expiry','2026-03-08 06:54:37'),(238,2.80,29.63,'expiry','2026-03-08 06:54:37'),(236,4.20,23.17,'expiry','2026-03-08 06:54:37'),(132,7.00,20.48,'expiry','2026-03-08 06:54:37'),(234,4.20,23.17,'expiry','2026-03-08 06:54:37'),(142,0.40,48.15,'expiry','2026-03-08 06:54:37'),(87,3.90,30.43,'expiry','2026-03-08 06:54:37'),(69,1.45,15.08,'expiry','2026-03-08 06:54:37'),(237,3.00,38.89,'expiry','2026-03-08 06:54:37'),(94,4.20,23.17,'expiry','2026-03-08 06:54:37'),(23,1.20,37.93,'expiry','2026-03-08 06:54:37'),(175,1.50,9.49,'expiry','2026-03-08 06:54:37'),(36,0.95,35.71,'expiry','2026-03-08 06:54:37'),(135,7.00,20.48,'expiry','2026-03-08 06:54:37'),(219,3.50,25.00,'expiry','2026-03-08 06:54:37'),(131,0.90,25.00,'expiry','2026-03-08 06:54:37'),(3,1.70,15.65,'expiry','2026-03-08 06:54:37'),(252,1.60,50.94,'initial','2026-03-31 08:15:21'),(253,3.30,40.43,'initial','2026-03-31 08:15:21'),(254,3.60,60.00,'initial','2026-03-31 08:15:21'),(140,0.35,27.01,'expiry','2026-04-03 13:45:56'),(143,0.35,12.90,'expiry','2026-04-03 13:45:56'),(3,1.50,2.04,'expiry','2026-04-03 13:58:39'),(178,3.90,51.38,'expiry','2026-04-03 13:58:39'),(179,3.90,43.92,'expiry','2026-04-03 13:58:39'),(145,0.80,58.50,'expiry','2026-04-04 03:36:45'),(200,1.10,22.52,'expiry','2026-04-05 08:26:31'),(201,1.10,15.61,'expiry','2026-04-05 08:26:31'),(202,1.10,19.53,'expiry','2026-04-05 08:26:31'),(220,2.30,50.38,'expiry','2026-04-05 10:06:44'),(221,2.20,97.27,'expiry','2026-04-05 10:06:44'),(222,1.40,25.54,'expiry','2026-04-05 10:06:44'),(223,1.50,34.51,'expiry','2026-04-05 10:06:44'),(224,3.40,36.80,'expiry','2026-04-05 10:06:44'),(225,1.45,30.02,'expiry','2026-04-05 10:06:44'),(230,4.20,31.81,'expiry','2026-04-05 10:06:44'),(255,0.50,150.00,'initial','2026-04-06 11:47:22'),(1,0.80,31.96,'ship','2026-04-06 15:48:52'),(27,0.30,48.59,'ship','2026-04-06 15:48:52'),(29,0.30,48.59,'ship','2026-04-06 15:48:52'),(25,0.30,48.59,'ship','2026-04-06 15:48:52'),(28,0.30,48.59,'ship','2026-04-06 15:48:52'),(329,4.80,45.69,'initial','2026-04-06 15:48:52'),(331,4.80,45.69,'initial','2026-04-06 15:48:52'),(330,4.80,45.69,'initial','2026-04-06 15:48:52'),(69,1.55,26.71,'ship','2026-04-06 15:48:52'),(85,3.85,47.05,'ship','2026-04-06 15:48:52'),(101,3.75,45.69,'ship','2026-04-06 15:48:52'),(111,2.60,36.61,'ship','2026-04-06 15:48:52'),(129,1.15,29.50,'ship','2026-04-06 15:48:52'),(87,4.20,57.78,'ship','2026-04-06 15:48:52'),(234,4.80,58.24,'ship','2026-04-06 15:48:52'),(256,3.25,29.63,'ship','2026-04-06 16:03:13'),(257,5.20,43.86,'ship','2026-04-06 16:03:13'),(258,5.20,43.86,'ship','2026-04-06 16:03:13'),(259,5.20,43.86,'ship','2026-04-06 16:03:13'),(260,5.20,43.86,'ship','2026-04-06 16:03:13'),(261,5.20,43.86,'ship','2026-04-06 16:03:13'),(262,5.20,43.86,'ship','2026-04-06 16:03:13'),(263,5.20,43.86,'ship','2026-04-06 16:03:13'),(264,2.20,53.70,'ship','2026-04-06 16:03:13'),(265,2.20,53.70,'ship','2026-04-06 16:03:13'),(266,2.20,53.70,'ship','2026-04-06 16:03:13'),(267,2.20,53.70,'ship','2026-04-06 16:03:13'),(268,3.00,74.74,'ship','2026-04-06 16:03:13'),(269,3.00,47.15,'ship','2026-04-06 16:03:13'),(270,3.00,47.15,'ship','2026-04-06 16:03:13'),(271,3.00,47.15,'ship','2026-04-06 16:03:13'),(272,3.00,47.15,'ship','2026-04-06 16:03:13'),(273,3.00,47.15,'ship','2026-04-06 16:03:13'),(274,3.00,47.15,'ship','2026-04-06 16:03:13'),(275,5.50,86.38,'ship','2026-04-06 16:03:13'),(276,5.00,158.13,'ship','2026-04-06 16:03:13'),(277,6.90,43.53,'ship','2026-04-06 16:03:13'),(278,6.50,35.21,'ship','2026-04-06 16:03:13'),(279,1.20,46.30,'ship','2026-04-06 16:03:13'),(280,1.20,46.30,'ship','2026-04-06 16:03:13'),(281,1.20,46.30,'ship','2026-04-06 16:03:13'),(282,3.60,49.57,'ship','2026-04-06 16:03:13'),(283,4.80,72.54,'ship','2026-04-06 16:03:13'),(284,4.80,72.54,'ship','2026-04-06 16:03:13'),(285,4.80,72.54,'ship','2026-04-06 16:03:13'),(286,2.50,65.20,'ship','2026-04-06 16:03:13'),(287,2.50,65.20,'ship','2026-04-06 16:03:13'),(288,1.20,115.42,'ship','2026-04-06 16:03:13'),(289,1.20,115.42,'ship','2026-04-06 16:03:13'),(290,1.20,35.97,'ship','2026-04-06 16:03:13'),(291,8.50,38.99,'ship','2026-04-06 16:03:13'),(292,2.00,45.62,'ship','2026-04-06 16:03:13'),(293,2.40,43.16,'ship','2026-04-06 16:03:13'),(294,1.90,40.53,'ship','2026-04-06 16:03:13'),(295,1.90,40.53,'ship','2026-04-06 16:03:13'),(296,3.50,43.82,'ship','2026-04-06 16:03:13'),(297,3.50,43.82,'ship','2026-04-06 16:03:13'),(298,1.25,45.69,'ship','2026-04-06 16:03:13'),(299,8.00,114.71,'ship','2026-04-06 16:03:13'),(300,8.00,114.71,'ship','2026-04-06 16:03:13'),(301,8.00,114.71,'ship','2026-04-06 16:03:13'),(302,8.00,114.71,'ship','2026-04-06 16:03:13'),(303,3.00,23.41,'ship','2026-04-06 16:03:13'),(304,1.10,80.70,'ship','2026-04-06 16:03:13'),(305,1.10,80.70,'ship','2026-04-06 16:03:13'),(306,1.10,80.70,'ship','2026-04-06 16:03:13'),(307,1.10,80.70,'ship','2026-04-06 16:03:13'),(308,1.10,80.70,'ship','2026-04-06 16:03:13'),(309,4.00,58.47,'ship','2026-04-06 16:03:13'),(310,4.00,47.93,'ship','2026-04-06 16:03:13'),(311,2.80,98.83,'ship','2026-04-06 16:03:13'),(312,2.80,98.83,'ship','2026-04-06 16:03:13'),(313,2.80,98.83,'ship','2026-04-06 16:03:13'),(314,2.80,98.83,'ship','2026-04-06 16:03:13'),(315,2.80,98.83,'ship','2026-04-06 16:03:13'),(316,15.00,104.31,'ship','2026-04-06 16:03:13'),(317,2.20,46.63,'ship','2026-04-06 16:03:13'),(318,5.30,12.62,'ship','2026-04-06 16:03:13'),(319,3.30,35.02,'ship','2026-04-06 16:03:13'),(320,6.00,50.83,'ship','2026-04-06 16:03:13'),(321,6.00,50.83,'ship','2026-04-06 16:03:13'),(322,6.00,50.83,'ship','2026-04-06 16:03:13'),(323,6.00,50.83,'ship','2026-04-06 16:03:13'),(324,2.85,30.49,'ship','2026-04-06 16:03:13'),(325,1.50,25.58,'ship','2026-04-06 16:03:13'),(326,2.00,130.77,'ship','2026-04-06 16:03:13'),(327,1.85,70.77,'ship','2026-04-06 16:03:13'),(133,7.00,20.48,'expiry','2026-04-08 15:40:21'),(134,7.00,20.48,'expiry','2026-04-08 15:40:21'),(275,5.00,69.44,'revise','2026-04-08 15:45:29'),(140,0.30,8.87,'expiry','2026-04-17 06:31:42'),(143,0.30,-3.23,'expiry','2026-04-17 06:31:42'),(21,1.00,14.94,'expiry','2026-04-17 06:40:25'),(23,1.00,14.94,'expiry','2026-04-17 06:40:25'),(234,4.60,51.65,'expiry','2026-04-17 06:45:08'),(236,4.00,17.30,'expiry','2026-04-17 06:48:13'),(237,2.80,29.63,'expiry','2026-04-17 06:51:42'),(238,2.60,20.37,'expiry','2026-04-17 06:55:18'),(175,1.40,2.19,'expiry','2026-04-17 06:57:40'),(87,4.00,50.27,'expiry','2026-04-17 07:04:56'),(194,1.00,25.96,'expiry','2026-04-17 07:09:59'),(132,6.50,11.87,'expiry','2026-04-26 04:58:21'),(133,6.50,11.87,'expiry','2026-04-26 04:58:21'),(134,6.50,11.87,'expiry','2026-04-26 04:58:21'),(135,6.50,11.87,'expiry','2026-04-26 04:58:21');
/*!40000 ALTER TABLE `priced` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `prices`
--

DROP TABLE IF EXISTS `prices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `prices` (
  `productid` int NOT NULL,
  `price` decimal(7,2) NOT NULL,
  `margin` decimal(5,2) NOT NULL,
  UNIQUE KEY `productid` (`productid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Current Pricelist';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `prices`
--

LOCK TABLES `prices` WRITE;
/*!40000 ALTER TABLE `prices` DISABLE KEYS */;
INSERT INTO `prices` VALUES (1,0.80,31.96),(2,2.65,14.72),(3,1.50,2.04),(4,2.00,1.52),(5,2.00,20.71),(6,2.00,16.27),(7,2.00,11.79),(8,7.00,28.91),(9,0.90,40.63),(10,0.90,40.63),(11,0.85,32.82),(12,4.20,17.36),(13,2.40,10.60),(14,2.10,15.93),(15,1.10,50.68),(16,1.00,36.98),(17,1.10,50.68),(18,1.95,5.08),(19,1.95,5.08),(20,4.00,22.70),(21,1.00,14.94),(22,1.50,33.14),(23,1.00,14.94),(24,4.00,5.26),(25,6.00,48.59),(26,0.00,-100.00),(27,6.00,48.59),(28,6.00,48.59),(29,6.00,48.59),(30,4.00,5.26),(31,3.50,45.23),(32,1.55,25.00),(33,1.45,31.82),(34,1.55,26.02),(35,2.15,15.59),(36,0.95,35.71),(37,0.85,23.19),(38,0.85,23.19),(39,0.85,23.19),(40,0.85,23.19),(41,0.85,23.19),(42,1.80,24.14),(43,0.85,0.00),(44,0.85,4.94),(45,1.00,14.95),(46,1.00,14.95),(47,1.00,14.95),(48,1.00,14.95),(49,3.90,17.12),(50,3.90,17.12),(51,0.85,26.87),(52,0.85,26.87),(53,0.85,26.87),(54,0.85,26.87),(55,0.85,26.87),(56,0.85,26.87),(57,3.90,2.36),(58,2.35,29.83),(59,3.50,30.77),(60,1.25,45.30),(61,1.50,57.89),(62,3.30,20.44),(63,1.15,13.86),(64,1.00,-0.99),(65,1.15,13.86),(66,1.15,13.86),(67,1.15,13.86),(68,2.85,28.38),(69,1.55,26.71),(70,1.55,23.09),(71,1.55,37.17),(72,1.60,34.45),(73,1.50,35.14),(74,1.50,35.14),(75,1.20,100.00),(76,1.20,100.00),(77,1.20,100.00),(78,8.50,151.48),(79,1.20,69.01),(80,1.30,22.64),(81,0.90,0.00),(82,1.20,-7.69),(83,11.00,22.49),(84,2.20,41.03),(85,3.85,47.05),(86,1.20,50.00),(87,4.00,50.27),(88,4.60,34.92),(89,4.60,34.92),(90,4.00,43.70),(91,4.00,43.70),(92,3.40,51.79),(93,3.70,43.72),(94,4.20,23.17),(95,4.60,34.92),(96,1.05,13.28),(97,1.05,9.79),(98,1.05,9.79),(99,4.50,42.86),(100,4.50,42.86),(101,3.75,45.69),(102,1.20,50.00),(103,1.10,44.74),(104,1.25,21.36),(105,2.95,29.96),(106,1.50,77.95),(107,2.55,18.60),(108,2.55,18.60),(109,1.50,27.12),(110,1.50,16.28),(111,2.60,36.61),(112,0.85,15.94),(113,0.85,15.94),(114,0.85,15.94),(115,0.85,15.94),(116,0.85,15.94),(117,4.50,1.12),(118,4.50,1.12),(119,4.50,1.12),(120,4.50,1.12),(121,4.50,1.12),(122,0.35,6.07),(123,0.35,6.07),(124,0.35,6.07),(125,6.60,10.00),(126,6.60,10.00),(127,6.60,10.00),(128,6.60,10.00),(129,1.15,29.50),(130,1.15,25.80),(131,0.90,25.00),(132,6.50,11.87),(133,6.50,11.87),(134,6.50,11.87),(135,6.50,11.87),(136,0.85,25.74),(137,1.00,39.71),(138,0.50,-7.41),(139,2.85,26.77),(140,0.30,8.87),(141,0.40,29.03),(142,0.40,48.15),(143,0.30,-3.23),(144,1.00,62.11),(145,0.80,58.50),(146,7.20,185.71),(147,7.20,185.71),(148,3.60,185.71),(149,5.00,32.28),(150,3.00,25.52),(151,3.00,25.52),(152,3.00,25.52),(153,21.60,26.98),(154,0.30,185.89),(155,4.00,29.15),(156,4.00,29.15),(157,4.00,29.15),(158,1.40,51.79),(159,1.40,51.79),(160,3.00,46.02),(161,1.50,44.70),(162,1.50,44.70),(163,1.50,44.70),(164,1.10,40.48),(165,1.10,40.48),(166,1.10,40.48),(167,4.75,21.48),(168,4.75,21.48),(169,3.80,75.65),(170,3.80,75.65),(171,3.80,75.65),(172,3.80,75.65),(173,4.80,67.61),(174,4.80,67.61),(175,1.40,2.19),(176,1.70,23.50),(177,1.70,23.50),(178,3.90,51.38),(179,3.90,43.92),(180,3.85,56.30),(181,3.85,56.30),(182,1.20,109.27),(183,1.40,17.36),(184,1.10,22.22),(185,1.35,10.71),(186,3.00,76.03),(187,3.00,13.82),(188,3.00,76.03),(189,2.40,39.07),(190,2.40,39.07),(191,2.40,39.07),(192,2.40,39.07),(193,2.40,39.07),(194,1.00,25.96),(195,2.85,19.31),(196,1.60,20.46),(197,1.10,15.82),(198,0.30,169.27),(199,1.35,13.27),(200,1.10,22.52),(201,1.10,15.61),(202,1.10,19.53),(203,1.80,37.46),(204,1.80,37.46),(205,1.80,37.46),(206,1.80,37.46),(207,1.80,37.46),(208,1.80,37.46),(209,1.80,37.46),(210,1.80,37.46),(211,1.20,31.66),(212,1.20,31.66),(213,1.20,31.66),(214,0.65,22.60),(215,0.65,22.60),(216,0.65,22.60),(217,5.15,31.86),(218,0.95,31.61),(219,3.50,25.00),(220,2.30,50.38),(221,2.20,97.27),(222,1.40,25.54),(223,1.50,34.51),(224,3.40,36.80),(225,1.45,30.02),(226,1.50,34.51),(227,5.50,27.87),(228,7.50,30.77),(229,4.50,47.12),(230,4.20,31.81),(231,4.20,40.38),(232,2.60,62.42),(233,3.90,43.66),(234,4.60,51.65),(235,2.60,62.42),(236,4.00,17.30),(237,2.80,29.63),(238,2.60,20.37),(239,2.30,87.13),(240,3.30,47.60),(241,3.40,42.38),(242,2.30,83.98),(243,3.80,43.01),(244,2.40,72.44),(245,3.20,46.97),(246,10.00,107.57),(247,11.00,78.69),(248,12.50,79.63),(249,13.50,73.93),(250,15.00,75.14),(251,18.50,92.00),(252,1.60,50.94),(253,3.30,40.43),(254,3.60,60.00),(255,0.50,150.00),(256,3.25,29.63),(257,5.20,43.86),(258,5.20,43.86),(259,5.20,43.86),(260,5.20,43.86),(261,5.20,43.86),(262,5.20,43.86),(263,5.20,43.86),(264,2.20,53.70),(265,2.20,53.70),(266,2.20,53.70),(267,2.20,53.70),(268,3.00,74.74),(269,3.00,47.15),(270,3.00,47.15),(271,3.00,47.15),(272,3.00,47.15),(273,3.00,47.15),(274,3.00,47.15),(275,5.00,69.44),(276,5.00,158.13),(277,6.90,43.53),(278,6.50,35.21),(279,1.20,46.30),(280,1.20,46.30),(281,1.20,46.30),(282,3.60,49.57),(283,4.80,72.54),(284,4.80,72.54),(285,4.80,72.54),(286,2.50,65.20),(287,2.50,65.20),(288,1.20,115.42),(289,1.20,115.42),(290,1.20,35.97),(291,8.50,38.99),(292,2.00,45.62),(293,2.40,43.16),(294,1.90,40.53),(295,1.90,40.53),(296,3.50,43.82),(297,3.50,43.82),(298,1.25,45.69),(299,8.00,114.71),(300,8.00,114.71),(301,8.00,114.71),(302,8.00,114.71),(303,3.00,23.41),(304,1.10,80.70),(305,1.10,80.70),(306,1.10,80.70),(307,1.10,80.70),(308,1.10,80.70),(309,4.00,58.47),(310,4.00,47.93),(311,2.80,98.83),(312,2.80,98.83),(313,2.80,98.83),(314,2.80,98.83),(315,2.80,98.83),(316,15.00,104.31),(317,2.20,46.63),(318,5.30,12.62),(319,3.30,35.02),(320,6.00,50.83),(321,6.00,50.83),(322,6.00,50.83),(323,6.00,50.83),(324,2.85,30.49),(325,1.50,25.58),(326,2.00,130.77),(327,1.85,70.77),(328,4.20,57.78),(329,4.80,45.69),(330,4.80,45.69),(331,4.80,45.69);
/*!40000 ALTER TABLE `prices` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `products`
--

DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `products` (
  `id` int NOT NULL AUTO_INCREMENT,
  `brand` varchar(50) NOT NULL,
  `variant` varchar(100) NOT NULL,
  `packlist` varchar(15) NOT NULL,
  `sellqty` smallint NOT NULL,
  `gst` tinyint(1) NOT NULL,
  `supplier` smallint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=332 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Product Details table';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `products`
--

LOCK TABLES `products` WRITE;
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
INSERT INTO `products` VALUES (1,'A&W minuman','250ml','24X250ML',24,1,1),(2,'ABC','Kecap manis pedas','24X275ML',24,0,1),(3,'Adem sari bubuk','96*6*7gr/box','96X6X7GR',6,0,1),(4,'Atoom bulan','Bumbu masak sachet kaldu ayam','50X20X7GR',1,0,1),(5,'Bogasari Tepung 1kg','Kunci biru','12X1KG',12,0,1),(6,'Bogasari Tepung 1kg','Segitiga Biru','12X1KG',12,0,1),(7,'Bogasari Tepung 1kg','Cakra kembar','12X1KG',12,0,1),(8,'Cangkir Mas jahe merah','330gr (topless)','10X330GR',10,0,1),(9,'Cap Panda','Cincau','24X310ML',24,1,1),(10,'Cap Panda','Liang teh','24X310ML',24,1,1),(11,'Cap Panda','Cincau selasih','24X310ML',24,1,1),(12,'Cho cho wafer roll (toples)','500gr','6X500GR',6,1,1),(13,'Choki-Choki','20*9gr','9X20X9GR',9,1,1),(14,'Dixi cuka','650ml','12X650ML',12,0,1),(15,'Gery Malkist saluut','Sweet cheese 100gr','30X100GR',30,1,1),(16,'Gery Malkist saluut','Coklat 110gr','30X110GR',30,1,1),(17,'Gery Malkist saluut','Matcha 100gr','30X100GR',30,1,1),(18,'Ginding','Batagor','20X100GR',20,0,1),(19,'Ginding','Cuanki','20X100GR',20,0,1),(20,'Helda','Harum Manis 150gr','28X150GR',28,1,1),(21,'Ichitan','Thaimilk Coffee','24X300ML',24,1,1),(22,'Ichitan','Dark Chocolate','24X300ML',24,1,1),(23,'Ichitan','Milk Coffee Caramel','24X300ML',24,1,1),(24,'Indofood racik','Sayur asem','10X20SX20GR',20,0,1),(25,'Indofood racik','Lodeh','10X20SX20GR',20,0,1),(26,'Indofood racik','Tumis','10X20SX20GR',20,0,1),(27,'Indofood racik','Ikan goreng','10X20SX20GR',20,0,1),(28,'Indofood racik','Tempe goreng','10X20SX20GR',20,0,1),(29,'Indofood racik','Ayam goreng','10X20SX20GR',20,0,1),(30,'Indofood racik','Nasi goreng','10X20SX20GR',20,0,1),(31,'Kartika sari (pouch)','Bagelan cheese','12X78GR',12,1,1),(32,'Khong Guan Biscuit','Saltcheese ComboCiz 175gr','20X175GR',20,1,1),(33,'Khong Guan Biscuit','Saltcheese Cracker Biscuit 200gr','30X200GR',30,1,1),(34,'Khong Guan Biscuit','Saltcheese Combo 175gr','20X175GR',20,1,1),(35,'Khong Guan Biscuit','Assorted Biscuit (bag) 300gr','30X300GR',30,1,1),(36,'Kiranti minuman botol','Datang Bulan original 150ml','24X150ML',24,1,1),(37,'Kobe bumbu 210gr','Pisang goreng','24X210GR',24,0,1),(38,'Kobe bumbu 210gr','Tempe','24X210GR',24,0,1),(39,'Kobe bumbu 210gr','Bakwan','24X210GR',24,0,1),(40,'Kobe bumbu 210gr','Serbaguna special','24X210GR',24,0,1),(41,'Kobe bumbu 210gr','Super krispi kentucky','24X210GR',24,0,1),(42,'Koepoe Koepoe bubuk','Biji pala','72X37GR',72,0,1),(43,'Koepoe Koepoe bubuk','SP','72X30GR',72,0,1),(44,'Koepoe Koepoe bubuk','TBM','72X35GR',72,0,1),(45,'Koepoe Koepoe perasa (60ml)','Pandan','72X60ML',72,0,1),(46,'Koepoe Koepoe perasa (60ml)','Coklat','72X60ML',72,0,1),(47,'Koepoe Koepoe perasa (60ml)','Kopi moka','72X60ML',72,0,1),(48,'Koepoe Koepoe perasa (60ml)','Moka','72X60ML',72,0,1),(49,'Kokita (botol kaca)','Kecap manis pedas','12X225GR',12,0,1),(50,'Kokita (botol kaca)','Kecap manis pedas sedang','12X225GR',12,0,1),(51,'Larutan Penyegar Cap Badak','Leci 320ml','24X320ML',24,1,1),(52,'Larutan Penyegar Cap Badak','Jambu 320ml','24X320ML',24,1,1),(53,'Larutan Penyegar Cap Badak','Anggur 320ml','24X320ML',24,1,1),(54,'Larutan Penyegar Cap Badak','Strawberry 320ml','24X320ML',24,1,1),(55,'Larutan Penyegar Cap Badak','Jeruk 320ml','24X320ML',24,1,1),(56,'Larutan Penyegar Cap Badak','Melon 320ml','24X320ML',24,1,1),(57,'Liauw Liong Pit tapioca Flour Tjap Orang Tani','1kg','10X1KG',10,0,1),(58,'Liauw Liong Pit tapioca Flour Tjap Orang Tani','500gr','20X500GR',20,0,1),(59,'Maizenaku Tepung Jagung','1kg','18X1KG',18,0,1),(60,'Maizenaku Tepung Jagung','300gr','40X300GR',40,0,1),(61,'Mariza Daun kering','Daun Salam 25gr','20X25GR',20,0,1),(62,'MBK bedak putih','13.6gr','50X12X13.6GR',50,1,1),(63,'Momogi','Jagung bakar','12X10X12GR',12,1,1),(64,'Momogi','Cheese','12X10X12GR',12,1,1),(65,'Momogi','Coklat','12X10X12GR',12,1,1),(66,'Momogi','Seaweed','12X10X12GR',12,1,1),(67,'Momogi','Balado','12X10X12GR',12,1,1),(68,'Monde Butter Cookies','150gr','20X150GR',20,1,1),(69,'Monde genji pie','Original','24X70GR',24,1,1),(70,'Monde genji pie','Strawberry','24X70GR',24,1,1),(71,'Monde genji pie','Lemon','24X85GR',24,1,1),(72,'Monde genji pie','Coklat sand','24X110GR',24,1,1),(73,'Nabati Siip','Coklat','12X20PCSX5GR',12,1,1),(74,'Nabati Siip','Cheese','12X20PCSX5GR',12,1,1),(75,'Nabati Wafer 110gr','Cheese 100gr','24X110GR',24,1,1),(76,'Nabati Wafer 110gr','Coklat  100gr','24X110GR',24,1,1),(77,'Nabati Wafer 110gr','Pink 100gr','24X110GR',24,1,1),(78,'Nissin','Wafer Kaleng','6X330GR',6,1,1),(79,'Nissin','Longer Stick','24X90GR',24,1,1),(80,'Nissin','Wafer Coklat 110g','24X110GR',24,1,1),(81,'Nissin','Wafer Vanilla 100g','30X100GR',30,1,1),(82,'Nissin','Lemonia Lemon Cookies 130gr','24X130GR',24,1,1),(83,'NR','Hair Tonic 200ml','12X200ML',12,1,1),(84,'Oishi','Tater Thins - Spicy','12X100GR',12,1,1),(85,'Pocari sweat','2L','6X2LTR',6,1,1),(86,'Pocari sweat','500ml','24X500ML',24,1,1),(87,'Prima Snack','Kemplang Ikan Panggang 120gr','27x120GR',27,1,1),(88,'Prima Snack','Stik Ikan 200gr','15X200GR',15,1,1),(89,'Prima Snack','Kerupuk Mangkok Ikan Goreng 200gr','15X200GR',15,1,1),(90,'Prima Snack','Kerupuk Cumi Goreng 250gr','13X250GR',13,1,1),(91,'Prima Snack','Kerupuk Udang Goreng 250gr','13X250GR',13,1,1),(92,'Prima Snack','Oven Udang 160gr','18X160GR',18,1,1),(93,'Prima Snack','Kemplang Ikan Goreng 250gr','12X250GR',12,1,1),(94,'Prima Snack','Kemplang Tinta Cumi 150gr','14X150GR',14,1,1),(95,'Prima Snack','Krupuk Kecil Ikan 200gr','13X200GR',13,1,1),(96,'Probaso Adonan Komplit bakso 250gr','Original','40X250GR',40,0,1),(97,'Probaso Adonan Komplit bakso 250gr','Khas Solo','40X250GR',40,0,1),(98,'Probaso Adonan Komplit bakso 250gr','Rasa Iga','40X250GR',40,0,1),(99,'Rinso Anti noda + molto bubuk 770g','classic','12X770GR',12,1,1),(100,'Rinso Anti noda + molto bubuk 770g','rose','12X770GR',12,1,1),(101,'Roma','Arden Fresh Pack - Chocolate','8X3X72GR',8,1,1),(102,'Roma','Kis Mint Permen (semua rasa)','24X125GR',24,1,1),(103,'Roma','Keju manis','30X90GR',30,1,1),(104,'Roma','biscuit Kelapa 300gr','28X300GR',28,1,1),(105,'Royco','Kaldu jamur 170gr','24X170GR',24,0,1),(106,'Sabun Colek B29','350GR','12X350GR',12,1,1),(107,'Saori saus botol','Teriyaki 275ml','12X275ML',12,0,1),(108,'Saori saus botol','Tiram 270ml','12X270ML',12,0,1),(109,'Saori saus botol','Lada hitam 133ml','24X133ML',24,0,1),(110,'Saori saus botol','Bulgogi 133ml','24X133ML',24,0,1),(111,'Sasa','Tepung ayam goreng renyah 900gr','12X850GR',12,0,1),(112,'Sasa (bumbu) 210g','Kentucky','24X210GR',24,0,1),(113,'Sasa (bumbu) 210g','Serbaguna original','24X210GR',24,0,1),(114,'Sasa (bumbu) 210g','Pisang goreng','24X210GR',24,0,1),(115,'Sasa (bumbu) 210g','Bakwan','24X210GR',24,0,1),(116,'Sasa (bumbu) 210g','Serbaguna hot spicy','24X210GR',24,0,1),(117,'Selera Indo (bumbu)','Lada Hitam','24x150GR',24,0,1),(118,'Selera Indo (bumbu)','Rendang Ayam','24x200GR',24,0,1),(119,'Selera Indo (bumbu)','Emi Medan','24x200GR',24,0,1),(120,'Selera Indo (bumbu)','Gulai Ikan','24x200GR',24,0,1),(121,'Selera Indo (bumbu)','Soto Mie / Mie Sop','24x200GR',24,0,1),(122,'Super Bubur (plastic) 45gr','Soto','40X45GR',40,0,1),(123,'Super Bubur (plastic) 45gr','Kari','40X45GR',40,0,1),(124,'Super Bubur (plastic) 45gr','Ayam','40X45GR',40,0,1),(125,'Swallow Tepung Agar2 7gr','Putih','24X12X7GR',24,0,1),(126,'Swallow Tepung Agar2 7gr','Coklat','24X12X7GR',24,0,1),(127,'Swallow Tepung Agar2 7gr','Merah','24X12X7GR',24,0,1),(128,'Swallow Tepung Agar2 7gr','Hijau','24X12X7GR',24,0,1),(129,'Taro net Snack 65g','Bbq potato','30X65GR',30,1,1),(130,'Taro net Snack 65g','Seaweed','30X65GR',30,1,1),(131,'You C 1000 Drink','Orange','30X140ML',30,1,1),(132,'ABC','Apel Juice','4X6X250ML',4,1,2),(133,'ABC','Lychee Juice','4X6X250ML',4,1,2),(134,'ABC','Mango Juice','4X6X250ML',4,1,2),(135,'ABC','Soursop Juice','4X6X250ML',4,1,2),(136,'Atoom','Dried Noodle','20X200G',20,0,2),(137,'Atoom','Dried Noodle Special','20X200G',20,0,2),(138,'3 Ayam','Dried Noodle','20X200G',20,0,2),(139,'Better','Vanilla Box','12X10X27G',12,1,2),(140,'Bihunku','Vermicelli - Chicken Onion Flavour','40X55G',40,0,2),(141,'Bihunku','Vermicelli - Laksa Curry Flavour','40X55G',40,0,2),(142,'Bihunku','Vermicelli - Soto Special Flavour','40X55G',40,0,2),(143,'Bihunku','Vermicelli - Goreng Spesial Flavour','40X55G',40,0,2),(144,'Mi Burung Dara','Mie Kering Lebar','20X197G',20,0,2),(145,'Mi Burung Dara','Mie Keriting MKS Bali','20X190G',20,0,2),(146,'Desaku','Kunyit','18X24SX5G',24,0,2),(147,'Desaku','Ketumbar','8X24SX12.5G',24,0,2),(148,'Desaku','Marinasi','36X12SX12.5G',12,0,2),(149,'Desaku','Balado','12X10SX25G',10,0,2),(150,'Desaku','Sambal Goreng','12X10SX12.5G',10,0,2),(151,'Desaku','Opor','12X10SX25G',10,0,2),(152,'Desaku','Kari','12X10SX25G',10,0,2),(153,'Desaku','Bawang Putih','6X72SX6G',24,0,2),(154,'Ladaku','Pepper Powder','576X2.5G',576,0,2),(155,'Goodday','Freeze Mocafrio','12X10X30G',12,0,2),(156,'Goodday','Freeze Hazelnut','12X10X30G',12,0,2),(157,'Goodday','Freeze Cookies n Cream','12X10X30G',12,0,2),(158,'Ichitan','Korean Banana Milk','24X300ML',24,1,2),(159,'Ichitan','Korean Strawberry Milk','24X300ML',24,1,2),(160,'Kobe','Nasi Kuning','12X10X15GR',12,0,2),(161,'Kopi Kenangan','Black Aren','24X220ML',24,1,2),(162,'Kopi Kenangan','Mantancino','24X220ML',24,1,2),(163,'Kopi Kenangan','Avocuddle','24X220ML',24,1,2),(164,'Kopi Kenangan','Indonesiano Ori Black Coffee','24X220ML',24,1,2),(165,'Kopi Kenangan','Caffee Latte Coffee Milk','24X220ML',24,1,2),(166,'Kopi Kenangan','Japanese Matcha Espresso','24X220ML',24,1,2),(167,'Ny Lily','Sambal Bawang - merah putih 24','24X300G',24,0,2),(168,'Ny Lily','Sambal Bawang - merah putih 12','12X300G',12,0,2),(169,'Lifebuoy','Body Wash pouch - Total 10 - Merah','24X240ML',24,1,2),(170,'Lifebuoy','Body Wash pouch - Cool Fresh - Biru','24X240ML',24,1,2),(171,'Lifebuoy','Body Wash pouch - Lemon Fresh - Kuning','24X240ML',24,1,2),(172,'Lifebuoy','Body Wash pouch - Mild Care - Putih','24X240ML',24,1,2),(173,'Lux','Body Wash - Zaitun & Madu','24X400ML',24,1,2),(174,'Lux','Body Wash - Soft Rose','24X400ML',24,1,2),(175,'Marie Regal','Choco Marie','24X96G',24,1,2),(176,'Marie Regal','Duo Chocolate','8X12X20G',8,1,2),(177,'Marie Regal','Vanilla','8X12X20G',8,1,2),(178,'Matahari Peanut','Original','40X250G',40,1,2),(179,'Matahari Peanut','Garlic','40X250G',40,1,2),(180,'Molto','Softener Japanese Peach','12X650ML',12,1,2),(181,'Molto','Softener Ultra Pure','12X550ML',12,1,2),(182,'Molto','Trika Blue','24X300ML',24,1,2),(183,'Nissin','Coconut Biscuit','24X200G',24,1,2),(184,'Nissin','Wafer Strawberry 100g','30X100G',30,1,2),(185,'Nissin','Biscuit Crispy Crackers','30X250G',30,1,2),(186,'Pepsodent','Toothpaste - Gigi Berlubang','48X190G',48,1,2),(187,'Pepsodent','Toothpaste - Herbal','48X190G',48,1,2),(188,'Pepsodent','Toothpaste - Fresh Cool Mint','48X190G',48,1,2),(189,'Purbasari','Body Scrub - Bengkoang','24X200G',24,1,2),(190,'Purbasari','Body Scrub - Zaitun','24X200G',24,1,2),(191,'Purbasari','Body Scrub - Green Tea','24X200G',24,1,2),(192,'Purbasari','Body Scrub - Susu Bengkoang','24X200G',24,1,2),(193,'Purbasari','Body Scrub - Brightening+VIT E','24X200G',24,1,2),(194,'Roma','Malkist Crackers','30X105G',30,1,2),(195,'Roma','Superstar Wafer Triple Chocolate','8X20X12.5G',8,1,2),(196,'Rose Brand','Glutinous Flour','20X500G',20,0,2),(197,'Rose Brand','Rice Flour','20X500G',20,0,2),(198,'Rinso','Molto Perfume Essence','96X40G',96,1,2),(199,'Selamat','Sandwich Biscuit - Chocolate','24X102G',24,1,2),(200,'Sido Muncul','Kunyit Asam','40X125G',40,0,2),(201,'Sido Muncul','Kunyit Asam Sirih','40X125G',40,0,2),(202,'Sido Muncul','Pelangsing Perut','40X5X14G',40,0,2),(203,'Stella','All in One - Balinese Jasmine','18X42G',18,1,2),(204,'Stella','All in One - Bougenville','18X42G',18,1,2),(205,'Stella','All in One - Apple Red','18X42G',18,1,2),(206,'Stella','All in One - Café Latte','18X42G',18,1,2),(207,'Stella','All in One - Lavender','18X42G',18,1,2),(208,'Stella','All in One - Lemon','18X42G',18,1,2),(209,'Stella','All in One - Orange','18X42G',18,1,2),(210,'Stella','All in One - Floral Sensation','18X42G',18,1,2),(211,'Stella','Fogo Cupboard - Floral','72X30G',72,1,2),(212,'Stella','Fogo Cupboard - Fresh ','72X30G',72,1,2),(213,'Stella','Fogo Cupboard - Princess','72X12G',72,1,2),(214,'Super Bihun','Original','30X51G',30,0,2),(215,'Super Bihun','Goreng','30X65G',30,0,2),(216,'Super Bihun','Meatball','30X65G',30,0,2),(217,'Tari Bali','Peanut','60X300G',60,1,2),(218,'You C 1000 Drink','Lemon','30X140ML',30,1,2),(219,'Raprima','Ragi Tempe (Yeast)','50X500G',50,0,2),(220,'Khas Indo','UNCOOKED Udang Super','25X250G',25,0,2),(221,'Khas Indo','UNCOOKED Udangsari','30X250G',30,0,2),(222,'Khas Indo','UNCOOKED Garlic Tersanjung','30X250G',30,0,2),(223,'Khas Indo','UNCOOKED Mawar','25X250G',25,0,2),(224,'Khas Indo','Dried Salted Teri Madura / Teri Jengki','20X150G',20,0,2),(225,'Khas Indo','UNCOOKED Mawar Colour','25X250G',25,0,2),(226,'Khas Indo','UNCOOKED Garlic Crackers Colour Big Chips','30X250G',30,0,2),(227,'Khas Indo','Dried Salted Teri Medan','20X150G',20,0,2),(228,'Khas Indo','Dried Salted Jambal Roti','20X150G',20,0,2),(229,'Khas Indo','Bawang Goreng BREBES Premium','35X100G',35,0,2),(230,'Khas Indo','Dried Cutcherry - Kencur Iris 100gr x','50X100G',50,0,2),(231,'Khas Indo','Stick Udang','23X180G',23,1,2),(232,'Khas Indo','Kerupuk Kulit Ikan Goreng','14X180G',14,1,2),(233,'Khas Indo','Kerupuk Oven Ikan','22X130G',22,1,2),(234,'Khas Indo','Getas Ikan Bulat','30X200G',30,1,2),(235,'Khas Indo','Kerupuk Bambu Ikan Goreng','20X180G',20,1,2),(236,'Khas Indo','Getas Ikan Panjang','30X200G',30,1,2),(237,'Khas Indo','Kerupuk Goreng Besar','25X8PCS',25,1,2),(238,'Khas Indo','Kerupuk Ring Ikan','40X90G',40,1,2),(239,'Cap Rusa','Kecap Asin Bangka','20X300ML',20,0,2),(240,'Cap Rusa','Kecap Asin Bangka','12X650ML',12,0,2),(241,'Cap SS','Kecap Asin Bangka','15X620ML',15,0,2),(242,'Cap SS','Kecap Asin Bangka','24X300ML',24,0,2),(243,'Cap Siong (Gajah)','Kecap Asin Bangka','12X620ML',12,0,2),(244,'Cap Siong (Gajah)','Kecap Asin Bangka','24X300ML',24,0,2),(245,'Cap Siong Kuning (Gajah)','Kecap Asin Bangka Istimewa','24X300ML',24,0,2),(246,'Cobek','18','5x18cm',1,1,2),(247,'Cobek','20','5x20cm',1,1,2),(248,'Cobek','22','5x22cm',1,1,2),(249,'Cobek','24','5x24cm',1,1,2),(250,'Cobek','26','5x26cm',1,1,2),(251,'Cobek','28','5x28cm',1,1,2),(252,'Terasi AB1 (Asli Bangka)','100g','10X100g',1,0,0),(253,'Qthen Kopi Bubuk (Bangka)','100% Robusta 100g','1X100g',1,0,0),(254,'Khas Indo','Abon Ikan (Bangka) 100g','1X1',1,1,0),(255,'Sikok','Ebi Bubuk','24X4.5G',1,0,0),(256,'ABC','Special Grade Cocopandan','12X485ml',12,0,2),(257,'Biore','Men Facial Foam - Bright Energy','24X100g',24,1,2),(258,'Biore','Men Facial Foam - Acne Bacterior','24X100g',24,1,2),(259,'Biore','Men Facial Foam - Deep Pore Clean','24X100g',24,1,2),(260,'Biore','Men Facial Foam - Cool Oil Clear','24X100g',24,1,2),(261,'Biore','Men Facial Foam - Acne Bright Care','24X100g',24,1,2),(262,'Biore','Men Facial Foam - Oil Balance','24X100g',24,1,2),(263,'Biore','Men Cool Oil Clear - Oil Balance','12X100g',12,1,2),(264,'Freshcare','Smash Inhaler and Roll-on - Strong','12X12sX10ml',144,1,2),(265,'Freshcare','Smash Inhaler and Roll-on - Matcha','12X12sX10ml',144,1,2),(266,'Freshcare','Smash Inhaler and Roll-on - Fruity','12X12sX10ml',144,1,2),(267,'Freshcare','Smash Inhaler and Roll-on - Combine','18X10ml',18,1,2),(268,'Gatsby','Fiber Clay','96X30g',96,1,2),(269,'Gatsby','Water Gloss Soft','48X150g',48,1,2),(270,'Gatsby','Water Gloss Hard','48X150g',48,1,2),(271,'Gatsby','Water Gloss Super Hard','48X150g',48,1,2),(272,'Gatsby','Water Gloss Hyper Solid','48X150g',48,1,2),(273,'Gatsby','Water Gloss Ultimate Hold','48X150g',48,1,2),(274,'Gatsby','Water Gloss Combined','20s',20,1,2),(275,'Kertas Nasi Cap Gajah','Pink 28x38cm','25X250s',25,1,2),(276,'Kertas Nasi Cap Gajah','Bunga','40X250s',40,1,2),(277,'Himalayan','Salty Candy','12X12X15g',12,1,2),(278,'Himalayan','Salt Ginger Lemon Candy','12X12X15g',12,1,2),(279,'Kis Candy','Zak Barley','24X125g',24,1,2),(280,'Kis Candy','Zak Cherry','24X125g',24,1,2),(281,'Kis Candy','Zak Grape','24X125g',24,1,2),(282,'Kobe','Ayam Kalasan','12X12sX35g',144,0,2),(283,'Lux','Body Wash - Lavender Chamo','24X400ml',24,1,2),(284,'Lux','Body Wash - Magical Orchid','24X400ml',24,1,2),(285,'Lux','Body Wash - Sakura Bloom','24X400ml',24,1,2),(286,'Mamasuka Gim','Jagung Bakar','40X2X4.5g',40,1,2),(287,'Mamasuka Gim','Soto Ayam Lamongan','40X2X4.5g',40,1,2),(288,'Molto','Trika Pure','24X300ml',24,1,2),(289,'Molto','Trika Japanese Peach','24X300ml',24,1,2),(290,'Nabati','White 110g','24X110g',24,1,2),(291,'Nissin','Wafer Chocolate','6X570g',6,1,2),(292,'Pocari Sweat','900ml','15X900ml',15,1,2),(293,'Purbasari','Body Scrub - Sakura Glow','24X200g',24,1,2),(294,'Resik V','Pembersih Kewanitaan Sirih - Mawar','36X90ml',36,1,2),(295,'Resik V','Pembersih Kewanitaan Sirih - Sirih Wangi','36X90ml',36,1,2),(296,'Resik V','Ramuan Madura Whitening','36X90ml',36,1,2),(297,'Resik V','Coklat Khasiat Manjakani','36X90ml',36,1,2),(298,'Roma','Arden Fresh Pack - Strawberry','24X72GR',24,1,2),(299,'Rinso','Classic Fresh Powder','6X1.44Kg',6,1,2),(300,'Rinso','Perfume Essence Powder','6X1.44Kg',6,1,2),(301,'Rinso','Rose Fresh Powder','6X1.44Kg',6,1,2),(302,'Rinso','Pure Fresh Powder','6X1.44Kg',6,1,2),(303,'Sasa','Tepung Kentucky Fortified','12X850g',12,0,2),(304,'Sosro','Fruit Tea Blackcurrant','24X500ml',24,1,2),(305,'Sosro','Fruit Tea Freeze','24X500ml',24,1,2),(306,'Sosro','Fruit Tea X-treme','24X500ml',24,1,2),(307,'Sosro','Fruit Tea Apple','24X500ml',24,1,2),(308,'Sosro','Fruit Tea Strawberry','24X500ml',24,1,2),(309,'Shinzui','Face Wash Acne Calm','48X80g',48,1,2),(310,'Shinzui','Face Wash Brightening','48X80g',48,1,2),(311,'Sunlight','Anti Bau pouch','12X600ml',12,1,2),(312,'Sunlight','Extra Lembut pouch','12X600ml',12,1,2),(313,'Sunlight','Korean Strawberry pouch','12X600ml',12,1,2),(314,'Sunlight','Power Higienis pouch','12X600ml',12,1,2),(315,'Sunlight','Biocare Nature pouch','12X600ml',12,1,2),(316,'Dunlopillo Bantal Guling','Guling 82 x 22cm - Super Soft','1X1',1,1,2),(317,'Oishi','Tater Thins - Truffle','12X100g',12,1,2),(318,'Zwitsal','Hair Lotion - Aloe Vera Kemiri Saledri','18X200ml',18,1,2),(319,'Zwitsal','Hair & Body Bath - Aloe Vera','24X200ml',24,1,2),(320,'Zwitsal','H&B Aloe Vera pouch','12X400ml',12,1,2),(321,'Zwitsal','H&B Antibacterial pouch','12X400ml',12,1,2),(322,'Zwitsal','H&B Milky Honey pouch','12X400ml',12,1,2),(323,'Zwitsal','Bath Telon pouch','12X400ml',12,1,2),(324,'Better','Caramel','12X10sX27g',12,1,2),(325,'Bihun Cap Dua Muzair','Medan 300g','20X300g',20,0,2),(326,'Khas Indo','Kerupuk Bawang (Siap Saji)','10X200g',10,1,2),(327,'Khas Indo','Kerupuk Padang Gado2 Mentah','20X250g',20,1,2),(328,'Khas Indo','Kemplang Ikan Panggang 120gr','27x120GR',27,1,1),(329,'Lifebuoy','Body Wash bottle - Total 10 - Merah','24X250G',24,1,2),(330,'Lifebuoy','Body Wash bottle - Lemon Fresh - Kuning','24X250G',24,1,2),(331,'Lifebuoy','Body Wash bottle - Mild Care - Putih','24X250G',24,1,2);
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `productscat`
--

DROP TABLE IF EXISTS `productscat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `productscat` (
  `productid` int NOT NULL,
  `category` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`productid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='complimenting products table';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `productscat`
--

LOCK TABLES `productscat` WRITE;
/*!40000 ALTER TABLE `productscat` DISABLE KEYS */;
INSERT INTO `productscat` VALUES (1,'drink'),(2,'cooking'),(3,'drink'),(4,'cooking'),(5,'cooking'),(6,'cooking'),(7,'cooking'),(8,'drink'),(9,'drink'),(10,'drink'),(11,'drink'),(12,'snack'),(13,'snack'),(14,'cooking'),(15,'snack'),(16,'snack'),(17,'snack'),(18,'food'),(19,'food'),(20,'snack'),(21,'drink'),(22,'drink'),(23,'drink'),(24,'cooking'),(25,'cooking'),(26,'cooking'),(27,'cooking'),(28,'cooking'),(29,'cooking'),(30,'cooking'),(31,'snack'),(32,'snack'),(33,'snack'),(34,'snack'),(35,'snack'),(36,'drink'),(37,'cooking'),(38,'cooking'),(39,'cooking'),(40,'cooking'),(41,'cooking'),(42,'cooking'),(43,'cooking'),(44,'cooking'),(45,'cooking'),(46,'cooking'),(47,'cooking'),(48,'cooking'),(49,'cooking'),(50,'cooking'),(51,'drink'),(52,'drink'),(53,'drink'),(54,'drink'),(55,'drink'),(56,'drink'),(57,'cooking'),(58,'cooking'),(59,'cooking'),(60,'cooking'),(61,'cooking'),(62,'personalcare'),(63,'snack'),(64,'snack'),(65,'snack'),(66,'snack'),(67,'snack'),(68,'snack'),(69,'snack'),(70,'snack'),(71,'snack'),(72,'snack'),(73,'snack'),(74,'snack'),(75,'snack'),(76,'snack'),(77,'snack'),(78,'snack'),(79,'snack'),(80,'snack'),(81,'snack'),(82,'snack'),(83,'personalcare'),(84,'snack'),(85,'drink'),(86,'drink'),(87,'snack'),(88,'snack'),(89,'snack'),(90,'snack'),(91,'snack'),(92,'snack'),(93,'snack'),(94,'snack'),(95,'snack'),(96,'cooking'),(97,'cooking'),(98,'cooking'),(99,'washing'),(100,'washing'),(101,'snack'),(102,'snack'),(103,'snack'),(104,'snack'),(105,'cooking'),(106,'washing'),(107,'cooking'),(108,'cooking'),(109,'cooking'),(110,'cooking'),(111,'cooking'),(112,'cooking'),(113,'cooking'),(114,'cooking'),(115,'cooking'),(116,'cooking'),(117,'cooking'),(118,'cooking'),(119,'cooking'),(120,'cooking'),(121,'cooking'),(122,'food'),(123,'food'),(124,'food'),(125,'cooking'),(126,'cooking'),(127,'cooking'),(128,'cooking'),(129,'snack'),(130,'snack'),(131,'drink'),(132,'drink'),(133,'drink'),(134,'drink'),(135,'drink'),(136,'food'),(137,'food'),(138,'food'),(139,'snack'),(140,'food'),(141,'food'),(142,'food'),(143,'food'),(144,'food'),(145,'food'),(146,'cooking'),(147,'cooking'),(148,'cooking'),(149,'cooking'),(150,'cooking'),(151,'cooking'),(152,'cooking'),(153,'cooking'),(154,'cooking'),(155,'drink'),(156,'drink'),(157,'drink'),(158,'drink'),(159,'drink'),(160,'cooking'),(161,'drink'),(162,'drink'),(163,'drink'),(164,'drink'),(165,'drink'),(166,'drink'),(167,'cooking'),(168,'cooking'),(169,'personalcare'),(170,'personalcare'),(171,'personalcare'),(172,'personalcare'),(173,'personalcare'),(174,'personalcare'),(175,'snack'),(176,'snack'),(177,'snack'),(178,'snack'),(179,'snack'),(180,'washing'),(181,'washing'),(182,'washing'),(183,'snack'),(184,'snack'),(185,'snack'),(186,'personalcare'),(187,'personalcare'),(188,'personalcare'),(189,'personalcare'),(190,'personalcare'),(191,'personalcare'),(192,'personalcare'),(193,'personalcare'),(194,'snack'),(195,'snack'),(196,'cooking'),(197,'cooking'),(198,'washing'),(199,'snack'),(200,'drink'),(201,'drink'),(202,'drink'),(203,'airfreshener'),(204,'airfreshener'),(205,'airfreshener'),(206,'airfreshener'),(207,'airfreshener'),(208,'airfreshener'),(209,'airfreshener'),(210,'airfreshener'),(211,'airfreshener'),(212,'airfreshener'),(213,'airfreshener'),(214,'food'),(215,'food'),(216,'food'),(217,'snack'),(218,'drink'),(219,'cooking'),(220,'cooking'),(221,'cooking'),(222,'cooking'),(223,'cooking'),(224,'cooking'),(225,'cooking'),(226,'cooking'),(227,'cooking'),(228,'cooking'),(229,'cooking'),(230,'cooking'),(231,'snack'),(232,'snack'),(233,'snack'),(234,'snack'),(235,'snack'),(236,'snack'),(237,'snack'),(238,'snack'),(239,'cooking'),(240,'cooking'),(241,'cooking'),(242,'cooking'),(243,'cooking'),(244,'cooking'),(245,'cooking'),(246,'misc'),(247,'misc'),(248,'misc'),(249,'misc'),(250,'misc'),(251,'misc'),(252,'cooking'),(253,'drink'),(254,'cooking'),(255,'cooking'),(256,'drink'),(257,'personalcare'),(258,'personalcare'),(259,'personalcare'),(260,'personalcare'),(261,'personalcare'),(262,'personalcare'),(263,'personalcare'),(264,'personalcare'),(265,'personalcare'),(266,'personalcare'),(267,'personalcare'),(268,'personalcare'),(269,'personalcare'),(270,'personalcare'),(271,'personalcare'),(272,'personalcare'),(273,'personalcare'),(274,'personalcare'),(275,'misc'),(276,'misc'),(277,'snack'),(278,'snack'),(279,'snack'),(280,'snack'),(281,'snack'),(282,'cooking'),(283,'personalcare'),(284,'personalcare'),(285,'personalcare'),(286,'snack'),(287,'snack'),(288,'washing'),(289,'washing'),(290,'snack'),(291,'snack'),(292,'drink'),(293,'personalcare'),(294,'personalcare'),(295,'personalcare'),(296,'personalcare'),(297,'personalcare'),(298,'snack'),(299,'washing'),(300,'washing'),(301,'washing'),(302,'washing'),(303,'cooking'),(304,'drink'),(305,'drink'),(306,'drink'),(307,'drink'),(308,'drink'),(309,'personalcare'),(310,'personalcare'),(311,'personalcare'),(312,'personalcare'),(313,'personalcare'),(314,'personalcare'),(315,'personalcare'),(316,'nonfood'),(317,'snack'),(318,'personalcare'),(319,'personalcare'),(320,'personalcare'),(321,'personalcare'),(322,'personalcare'),(323,'personalcare'),(324,'snack'),(325,'cooking'),(326,'snack'),(327,'snack'),(328,'snack'),(329,'personalcare'),(330,'personalcare'),(331,'personalcare');
/*!40000 ALTER TABLE `productscat` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `returnitems`
--

DROP TABLE IF EXISTS `returnitems`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `returnitems` (
  `returnid` int NOT NULL,
  `productid` int NOT NULL,
  `price` decimal(10,0) NOT NULL,
  `gst` decimal(10,0) NOT NULL,
  KEY `returnproductid` (`returnid`,`productid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Items on Sales / Invoice';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `returnitems`
--

LOCK TABLES `returnitems` WRITE;
/*!40000 ALTER TABLE `returnitems` DISABLE KEYS */;
/*!40000 ALTER TABLE `returnitems` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `returns`
--

DROP TABLE IF EXISTS `returns`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `returns` (
  `id` int NOT NULL AUTO_INCREMENT,
  `salesid` int NOT NULL,
  `custid` int NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `total` float NOT NULL,
  `totalgst` decimal(10,0) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `salesid` (`salesid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Sales / Invoice Details';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `returns`
--

LOCK TABLES `returns` WRITE;
/*!40000 ALTER TABLE `returns` DISABLE KEYS */;
/*!40000 ALTER TABLE `returns` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sales`
--

DROP TABLE IF EXISTS `sales`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sales` (
  `id` int NOT NULL AUTO_INCREMENT,
  `custid` int NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `total` float NOT NULL,
  `totalgst` decimal(10,0) NOT NULL,
  `checked` tinyint(1) NOT NULL DEFAULT '0',
  `packed` tinyint(1) NOT NULL DEFAULT '0',
  `received` tinyint(1) NOT NULL DEFAULT '0',
  `deliverydate` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Sales / Invoice Details';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sales`
--

LOCK TABLES `sales` WRITE;
/*!40000 ALTER TABLE `sales` DISABLE KEYS */;
/*!40000 ALTER TABLE `sales` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `salesitems`
--

DROP TABLE IF EXISTS `salesitems`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `salesitems` (
  `salesid` int NOT NULL,
  `productid` int NOT NULL,
  `price` decimal(10,0) NOT NULL,
  `gst` decimal(10,0) NOT NULL,
  KEY `salesproductid` (`salesid`,`productid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Items on Sales / Invoice';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `salesitems`
--

LOCK TABLES `salesitems` WRITE;
/*!40000 ALTER TABLE `salesitems` DISABLE KEYS */;
/*!40000 ALTER TABLE `salesitems` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `warehouse`
--

DROP TABLE IF EXISTS `warehouse`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `warehouse` (
  `productid` int NOT NULL,
  `qty` int NOT NULL,
  `expiry` date DEFAULT NULL,
  KEY `productid` (`productid`) USING BTREE,
  KEY `expiry` (`expiry`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Current Warehouse stock';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `warehouse`
--

LOCK TABLES `warehouse` WRITE;
/*!40000 ALTER TABLE `warehouse` DISABLE KEYS */;
INSERT INTO `warehouse` VALUES (1,0,'2026-04-29'),(2,0,'2026-04-27'),(3,65,'2026-09-13'),(4,47,'2026-04-25'),(5,0,'2026-11-10'),(6,0,'2026-10-23'),(7,0,'2026-11-15'),(8,0,'2027-02-25'),(9,0,'2027-06-30'),(10,0,'2028-04-30'),(11,0,'2026-03-31'),(12,0,'2026-04-25'),(13,0,'2026-03-31'),(14,0,'2029-12-31'),(15,0,'2026-07-31'),(16,0,'2026-03-31'),(17,0,'2026-04-30'),(18,0,'2026-05-10'),(19,0,'2026-05-10'),(20,0,'2026-05-14'),(21,0,'2026-02-16'),(22,0,'2026-01-22'),(23,0,'2026-01-22'),(24,0,'2026-05-07'),(25,0,'2026-04-16'),(26,0,'2026-03-03'),(27,0,'2026-04-25'),(28,0,'2026-04-10'),(29,0,'2026-04-25'),(30,0,'2026-04-08'),(31,0,'2026-05-19'),(32,0,'2026-02-19'),(33,0,'2026-03-24'),(34,0,'2026-03-22'),(35,0,'2026-04-25'),(36,0,'2026-05-01'),(37,120,'2027-04-14'),(38,0,'2027-04-19'),(39,0,'2027-04-13'),(40,0,'2027-04-25'),(41,0,'2027-04-15'),(42,0,'2027-01-15'),(43,276,'2027-03-26'),(44,276,'2027-03-25'),(45,0,'2028-04-10'),(46,0,'2028-04-09'),(47,72,'2028-02-18'),(48,0,'2028-01-23'),(49,0,'2026-12-01'),(50,0,'2026-12-05'),(51,0,'2027-04-15'),(52,288,'2027-04-24'),(53,0,'2027-03-11'),(54,0,'2027-02-21'),(55,0,'2027-03-18'),(56,0,'2027-02-19'),(57,0,'2026-08-31'),(58,0,'2026-08-31'),(59,0,'2027-04-01'),(60,0,'2027-04-01'),(61,0,'2027-05-15'),(62,14,'2032-04-30'),(63,0,'2026-04-07'),(64,0,'2026-04-14'),(65,0,'2026-03-25'),(66,0,'2026-05-02'),(67,0,'2026-03-22'),(68,0,'2026-05-08'),(69,0,'2026-04-16'),(70,0,'2026-04-22'),(71,0,'2026-04-25'),(72,0,'2026-04-28'),(73,0,'2026-01-27'),(74,0,'2026-02-11'),(75,0,'2026-01-29'),(76,0,'2026-01-23'),(77,0,'2025-12-26'),(78,0,'2026-02-13'),(79,0,'2026-04-30'),(80,0,'2026-04-25'),(81,120,'2026-07-05'),(82,0,'2026-03-21'),(83,0,'2028-11-15'),(84,0,'2026-02-27'),(85,0,'2026-04-14'),(86,0,'2026-04-15'),(87,0,'2026-03-05'),(88,0,'2026-03-05'),(89,0,'2026-03-05'),(90,0,'2026-03-05'),(91,0,'2026-03-05'),(92,0,'2026-03-05'),(93,0,'2026-03-05'),(94,0,'2026-03-05'),(95,0,'2026-03-05'),(96,0,'2026-09-10'),(97,0,'2026-09-14'),(98,0,'2026-09-21'),(99,0,NULL),(100,0,NULL),(101,0,'2026-02-28'),(102,0,'2026-03-31'),(103,0,'2026-05-31'),(104,0,'2026-02-22'),(105,0,'2026-02-22'),(106,0,'2028-01-03'),(107,0,'2026-02-11'),(108,0,'2026-04-24'),(109,0,'2026-04-17'),(110,0,'2026-03-18'),(111,0,'2026-09-20'),(112,0,'2026-09-10'),(113,0,'2026-09-01'),(114,0,'2026-09-13'),(115,0,'2026-09-04'),(116,0,'2026-10-08'),(117,0,'2027-05-03'),(118,0,'2027-05-10'),(119,0,'2027-05-16'),(120,0,'2027-05-16'),(121,12,'2027-05-16'),(122,0,'2026-01-31'),(123,0,'2026-01-31'),(124,0,'2026-01-31'),(125,78,'2027-10-30'),(126,33,'2027-06-13'),(127,30,'2027-10-30'),(128,34,'2027-10-03'),(129,0,'2026-02-19'),(130,0,'2026-04-08'),(131,0,'2026-03-13'),(132,64,'2026-08-02'),(133,48,'2026-10-15'),(134,60,'2026-11-04'),(135,24,'2026-08-23'),(136,0,NULL),(137,0,'2027-09-15'),(138,0,'2026-05-22'),(139,0,'2026-09-30'),(140,160,'2026-06-30'),(141,0,'2026-07-29'),(142,0,'2026-07-24'),(143,120,'2026-07-04'),(144,0,'2026-09-30'),(145,0,'2026-09-30'),(146,0,'2028-05-30'),(147,0,'2028-03-30'),(148,0,'2028-03-30'),(149,0,'2028-07-14'),(150,0,'2028-06-03'),(151,9,'2028-07-02'),(152,0,'2028-06-21'),(153,0,'2028-05-30'),(154,0,'2025-06-30'),(155,24,'2027-03-19'),(156,12,'2027-03-18'),(157,0,'2027-03-18'),(158,0,'2026-08-19'),(159,0,'2026-09-05'),(160,23,'2027-02-04'),(161,0,'2026-08-16'),(162,0,'2026-08-15'),(163,0,'2026-08-16'),(164,0,'2026-08-11'),(165,0,'2026-08-12'),(166,0,'2026-08-14'),(167,24,'2026-11-30'),(168,0,'2026-11-30'),(169,84,'2027-09-05'),(170,30,'2028-01-25'),(171,96,'2027-09-18'),(172,36,'2027-09-17'),(173,0,'2027-02-15'),(174,0,'2027-12-24'),(175,24,'2026-08-21'),(176,0,'2026-12-03'),(177,0,'2026-10-30'),(178,16,'2026-09-19'),(179,160,'2026-09-19'),(180,0,NULL),(181,48,NULL),(182,0,NULL),(183,0,'2026-08-25'),(184,60,'2026-08-01'),(185,30,'2026-09-13'),(186,96,'2028-08-06'),(187,112,'2028-06-13'),(188,88,'2028-07-02'),(189,0,'2028-09-30'),(190,0,'2028-09-30'),(191,0,'2028-09-30'),(192,0,'2028-09-30'),(193,0,'2028-09-30'),(194,90,'2026-09-30'),(195,0,'2026-06-30'),(196,0,'2027-05-06'),(197,0,'2027-08-02'),(198,0,NULL),(199,96,'2027-02-28'),(200,287,'2027-01-30'),(201,280,'2027-02-28'),(202,279,'2027-07-30'),(203,225,'2027-07-30'),(204,253,'2027-07-30'),(205,261,'2027-07-30'),(206,295,'2027-07-30'),(207,261,'2027-07-30'),(208,209,'2027-07-30'),(209,197,'2027-07-30'),(210,271,'2027-07-30'),(211,218,'2027-07-30'),(212,194,'2027-07-30'),(213,278,'2027-07-30'),(214,0,'2026-09-12'),(215,0,'2026-09-20'),(216,0,'2026-09-08'),(217,0,'2026-10-31'),(218,0,'2026-07-17'),(219,0,'2026-08-21'),(220,137,'2027-09-25'),(221,14,'2027-09-25'),(222,209,'2027-09-25'),(223,124,'2027-09-25'),(224,160,'2027-09-25'),(225,175,'2027-09-25'),(226,0,'2027-09-25'),(227,0,'2027-09-25'),(228,0,'2027-09-25'),(229,0,'2027-09-25'),(230,70,'2027-09-25'),(231,0,'2026-08-01'),(232,0,'2026-08-01'),(233,0,'2026-08-01'),(234,25,'2026-08-01'),(235,0,'2026-08-01'),(236,0,'2026-08-01'),(237,8,'2026-08-01'),(238,8,'2026-08-01'),(239,100,'2027-03-30'),(240,0,'2027-03-30'),(241,60,'2028-12-02'),(242,120,'2028-12-02'),(243,0,'2028-12-02'),(244,24,'2028-12-02'),(245,24,'2030-12-02'),(246,0,NULL),(247,0,NULL),(248,0,NULL),(249,0,NULL),(250,0,NULL),(251,0,NULL),(7,0,'2027-04-01'),(5,0,'2027-03-01'),(6,0,'2027-03-20'),(106,0,NULL),(12,0,'2026-09-08'),(14,0,'2030-08-30'),(19,0,NULL),(18,0,NULL),(22,0,'2026-07-18'),(21,46,'2026-06-21'),(23,69,'2026-08-13'),(36,0,'2026-08-21'),(59,0,'2027-08-01'),(60,240,'2027-06-01'),(69,0,'2026-08-07'),(70,0,'2026-09-02'),(81,0,'2026-04-05'),(83,0,'2029-04-30'),(85,0,'2026-08-25'),(96,0,'2027-02-28'),(98,0,'2027-03-05'),(97,118,'2027-01-11'),(130,0,'2026-10-07'),(131,0,'2026-09-09'),(87,27,'2026-08-01'),(88,0,'2026-08-01'),(89,0,'2026-08-01'),(90,0,'2026-08-01'),(91,0,'2026-08-01'),(93,0,'2026-08-01'),(94,0,'2026-08-01'),(95,0,'2026-08-01'),(252,0,'2027-09-05'),(253,12,'2027-03-02'),(254,0,'2027-01-01'),(255,168,'2028-05-20'),(256,588,'2028-09-06'),(257,66,'2028-12-08'),(258,66,'2028-03-08'),(259,66,'2028-10-30'),(260,120,'2028-12-06'),(261,72,'2028-10-30'),(262,66,'2028-12-06'),(263,0,NULL),(264,114,'2029-01-31'),(265,144,'2029-01-31'),(266,156,'2028-12-31'),(267,0,NULL),(268,0,'2028-04-28'),(269,0,'2030-02-13'),(270,0,'2030-01-16'),(271,0,'2030-02-10'),(272,0,'2030-09-24'),(273,0,'2029-04-27'),(274,0,NULL),(275,220,NULL),(276,160,NULL),(277,106,'2027-12-19'),(278,0,'2027-11-16'),(279,24,'2027-01-31'),(280,0,'2027-01-31'),(281,24,'2027-01-31'),(282,1437,'2028-04-07'),(283,24,'2028-04-23'),(284,24,'2028-06-17'),(285,24,'2028-04-03'),(286,100,'2026-12-02'),(287,100,'2026-10-29'),(288,0,NULL),(289,0,NULL),(290,96,'2026-12-06'),(291,42,'2027-04-02'),(292,0,'2026-12-06'),(293,96,'2029-01-31'),(294,36,'2028-10-31'),(295,0,'2028-10-31'),(296,0,'2028-10-31'),(297,0,'2028-10-31'),(298,48,'2026-12-31'),(299,72,NULL),(300,60,NULL),(301,66,NULL),(302,66,NULL),(303,156,'2027-07-06'),(304,216,'2027-01-14'),(305,360,'2027-01-13'),(306,360,'2027-01-15'),(307,264,'2027-01-15'),(308,384,'2027-01-15'),(309,0,'2028-10-31'),(310,48,'2028-12-31'),(311,72,NULL),(312,108,NULL),(313,0,NULL),(314,60,NULL),(315,120,NULL),(316,75,NULL),(317,36,'2026-12-04'),(318,0,'2028-06-23'),(319,72,'2028-06-18'),(320,36,'2028-02-18'),(321,36,'2028-05-07'),(322,36,'2028-05-10'),(323,18,'2028-04-27'),(324,0,'2027-02-28'),(325,340,'2029-12-31'),(326,214,'2027-02-05'),(327,40,'2027-02-05'),(1,328,'2027-01-12'),(139,0,'2027-01-31'),(5,72,'2027-07-23'),(6,348,'2027-07-25'),(7,396,'2027-07-03'),(14,120,'2028-11-30'),(146,146,'2028-11-01'),(147,37,'2028-09-02'),(148,43,'2028-09-02'),(153,0,'2028-10-10'),(154,5760,'2028-11-02'),(22,648,'2026-11-16'),(158,192,'2026-12-13'),(27,0,'2027-01-11'),(29,0,'2027-01-15'),(25,12,'2027-01-14'),(28,25,'2026-12-29'),(162,0,'2026-11-09'),(163,0,'2026-11-11'),(165,0,'2026-11-07'),(166,96,'2026-11-08'),(329,120,'2028-01-17'),(331,120,'2027-12-16'),(330,48,'2028-04-06'),(173,48,'2028-04-21'),(174,120,'2028-07-02'),(69,48,'2026-11-12'),(70,0,'2026-12-02'),(72,48,'2026-10-20'),(75,120,'2026-12-08'),(76,48,'2026-12-07'),(77,144,'2026-12-10'),(79,168,'2027-01-10'),(186,240,'2028-11-01'),(85,0,'2026-12-13'),(86,0,'2026-11-14'),(189,168,'2029-01-31'),(190,120,'2028-12-31'),(191,96,'2028-12-31'),(192,72,'2029-01-31'),(193,96,'2028-12-31'),(101,0,'2026-12-31'),(197,0,'2027-12-19'),(105,0,'2026-09-24'),(115,0,'2027-07-19'),(112,192,'2027-06-29'),(111,96,'2027-06-27'),(214,60,'2027-02-04'),(215,420,'2027-02-06'),(216,360,'2027-02-05'),(130,0,'2026-12-12'),(129,0,'2027-01-06'),(84,12,'2026-12-01'),(59,144,'2027-12-01'),(176,80,'2027-04-26'),(226,75,'2027-02-05'),(87,54,'2026-12-10'),(95,0,'2026-12-10'),(89,18,'2026-12-10'),(90,26,'2026-12-10'),(91,26,'2026-12-10'),(232,5,'2026-12-10'),(234,90,'2026-12-10'),(328,49,'2026-12-10');
/*!40000 ALTER TABLE `warehouse` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `warehoused`
--

DROP TABLE IF EXISTS `warehoused`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `warehoused` (
  `productid` int NOT NULL,
  `qty` smallint NOT NULL,
  `expiry` date DEFAULT NULL,
  `reason` varchar(10) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  KEY `time` (`time`),
  KEY `productid` (`productid`) USING BTREE,
  KEY `expiry` (`expiry`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Current Warehouse stock';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `warehoused`
--

LOCK TABLES `warehoused` WRITE;
/*!40000 ALTER TABLE `warehoused` DISABLE KEYS */;
INSERT INTO `warehoused` VALUES (1,15,'2026-04-29','stock','2025-08-18 06:40:06'),(2,0,'2026-04-27','stock','2025-08-18 06:40:06'),(3,96,'2026-09-13','stock','2025-08-18 06:40:06'),(4,87,'2026-04-25','stock','2025-08-18 06:40:06'),(5,15,'2026-11-10','stock','2025-08-18 06:40:06'),(6,17,'2026-10-23','stock','2025-08-18 06:40:06'),(7,25,'2026-11-15','stock','2025-08-18 06:40:06'),(8,100,'2027-02-25','stock','2025-08-18 06:40:06'),(9,10,'2027-06-30','stock','2025-08-18 06:40:06'),(10,10,'2028-04-30','stock','2025-08-18 06:40:06'),(11,10,'2026-03-31','stock','2025-08-18 06:40:06'),(12,0,'2026-04-25','stock','2025-08-18 06:40:06'),(13,8,'2026-03-31','stock','2025-08-18 06:40:06'),(14,3,'2029-12-31','stock','2025-08-18 06:40:06'),(15,2,'2026-07-31','stock','2025-08-18 06:40:06'),(16,4,'2026-03-31','stock','2025-08-18 06:40:06'),(17,3,'2026-04-30','stock','2025-08-18 06:40:06'),(18,18,'2026-05-10','stock','2025-08-18 06:40:06'),(19,14,'2026-05-10','stock','2025-08-18 06:40:06'),(20,10,'2026-05-14','stock','2025-08-18 06:40:06'),(21,2,'2026-02-16','stock','2025-08-18 06:40:06'),(22,1,'2026-01-22','stock','2025-08-18 06:40:06'),(23,2,'2026-01-22','stock','2025-08-18 06:40:06'),(24,800,'2026-05-07','stock','2025-08-18 06:40:06'),(25,360,'2026-04-16','stock','2025-08-18 06:40:06'),(26,310,'2026-03-03','stock','2025-08-18 06:40:06'),(27,200,'2026-04-25','stock','2025-08-18 06:40:06'),(28,600,'2026-04-10','stock','2025-08-18 06:40:06'),(29,700,'2026-04-25','stock','2025-08-18 06:40:06'),(30,800,'2026-04-08','stock','2025-08-18 06:40:06'),(31,2,'2026-05-19','stock','2025-08-18 06:40:06'),(32,9,'2026-02-19','stock','2025-08-18 06:40:06'),(33,8,'2026-03-24','stock','2025-08-18 06:40:06'),(34,9,'2026-03-22','stock','2025-08-18 06:40:06'),(35,5,'2026-04-25','stock','2025-08-18 06:40:06'),(36,10,'2026-05-01','stock','2025-08-18 06:40:06'),(37,15,'2027-04-14','stock','2025-08-18 06:40:06'),(38,20,'2027-04-19','stock','2025-08-18 06:40:06'),(39,20,'2027-04-13','stock','2025-08-18 06:40:06'),(40,15,'2027-04-25','stock','2025-08-18 06:40:06'),(41,15,'2027-04-15','stock','2025-08-18 06:40:06'),(42,144,'2027-01-15','stock','2025-08-18 06:40:06'),(43,288,'2027-03-26','stock','2025-08-18 06:40:06'),(44,360,'2027-03-25','stock','2025-08-18 06:40:06'),(45,132,'2028-04-10','stock','2025-08-18 06:40:06'),(46,132,'2028-04-09','stock','2025-08-18 06:40:06'),(47,144,'2028-02-18','stock','2025-08-18 06:40:06'),(48,132,'2028-01-23','stock','2025-08-18 06:40:06'),(49,5,'2026-12-01','stock','2025-08-18 06:40:06'),(50,4,'2026-12-05','stock','2025-08-18 06:40:06'),(51,92,'2027-04-15','stock','2025-08-18 06:40:06'),(52,67,'2027-04-24','stock','2025-08-18 06:40:06'),(53,36,'2027-03-11','stock','2025-08-18 06:40:06'),(54,29,'2027-02-21','stock','2025-08-18 06:40:06'),(55,18,'2027-03-18','stock','2025-08-18 06:40:06'),(56,18,'2027-02-19','stock','2025-08-18 06:40:06'),(57,23,'2026-08-31','stock','2025-08-18 06:40:06'),(58,10,'2026-08-31','stock','2025-08-18 06:40:06'),(59,2,'2027-04-01','stock','2025-08-18 06:40:06'),(60,4,'2027-04-01','stock','2025-08-18 06:40:06'),(61,0,'2027-05-15','stock','2025-08-18 06:40:06'),(62,90,'2032-04-30','stock','2025-08-18 06:40:06'),(63,28,'2026-04-07','stock','2025-08-18 06:40:06'),(64,19,'2026-04-14','stock','2025-08-18 06:40:06'),(65,9,'2026-03-25','stock','2025-08-18 06:40:06'),(66,7,'2026-05-02','stock','2025-08-18 06:40:06'),(67,0,'2026-03-22','stock','2025-08-18 06:40:06'),(68,5,'2026-05-08','stock','2025-08-18 06:40:06'),(69,1,'2026-04-16','stock','2025-08-18 06:40:06'),(70,4,'2026-04-22','stock','2025-08-18 06:40:06'),(71,2,'2026-04-25','stock','2025-08-18 06:40:06'),(72,2,'2026-04-28','stock','2025-08-18 06:40:06'),(73,3,'2026-01-27','stock','2025-08-18 06:40:06'),(74,3,'2026-02-11','stock','2025-08-18 06:40:06'),(75,5,'2026-01-29','stock','2025-08-18 06:40:06'),(76,5,'2026-01-23','stock','2025-08-18 06:40:06'),(77,3,'2025-12-26','stock','2025-08-18 06:40:06'),(78,4,'2026-02-13','stock','2025-08-18 06:40:06'),(79,5,'2026-04-30','stock','2025-08-18 06:40:06'),(80,5,'2026-04-25','stock','2025-08-18 06:40:06'),(81,4,'2026-04-24','stock','2025-08-18 06:40:06'),(82,2,'2026-03-21','stock','2025-08-18 06:40:06'),(83,0,'2028-11-15','stock','2025-08-18 06:40:06'),(84,2,'2026-02-27','stock','2025-08-18 06:40:06'),(85,13,'2026-04-14','stock','2025-08-18 06:40:06'),(86,18,'2026-04-15','stock','2025-08-18 06:40:06'),(87,3,'2026-03-05','stock','2025-08-18 06:40:06'),(88,3,'2026-03-05','stock','2025-08-18 06:40:06'),(89,3,'2026-03-05','stock','2025-08-18 06:40:06'),(90,3,'2026-03-05','stock','2025-08-18 06:40:06'),(91,3,'2026-03-05','stock','2025-08-18 06:40:06'),(92,3,'2026-03-05','stock','2025-08-18 06:40:06'),(93,3,'2026-03-05','stock','2025-08-18 06:40:06'),(94,2,'2026-03-05','stock','2025-08-18 06:40:06'),(95,3,'2026-03-05','stock','2025-08-18 06:40:06'),(96,0,'2026-09-10','stock','2025-08-18 06:40:06'),(97,2,'2026-09-14','stock','2025-08-18 06:40:06'),(98,3,'2026-09-21','stock','2025-08-18 06:40:06'),(99,3,NULL,'stock','2025-08-18 06:40:06'),(100,3,NULL,'stock','2025-08-18 06:40:06'),(101,4,'2026-02-28','stock','2025-08-18 06:40:06'),(102,0,'2026-03-31','stock','2025-08-18 06:40:06'),(103,4,'2026-05-31','stock','2025-08-18 06:40:06'),(104,4,'2026-02-22','stock','2025-08-18 06:40:06'),(105,4,'2026-02-22','stock','2025-08-18 06:40:06'),(106,0,'2028-01-03','stock','2025-08-18 06:40:06'),(107,5,'2026-02-11','stock','2025-08-18 06:40:06'),(108,6,'2026-04-24','stock','2025-08-18 06:40:06'),(109,1,'2026-04-17','stock','2025-08-18 06:40:06'),(110,0,'2026-03-18','stock','2025-08-18 06:40:06'),(111,5,'2026-09-20','stock','2025-08-18 06:40:06'),(112,12,'2026-09-10','stock','2025-08-18 06:40:06'),(113,15,'2026-09-01','stock','2025-08-18 06:40:06'),(114,12,'2026-09-13','stock','2025-08-18 06:40:06'),(115,17,'2026-09-04','stock','2025-08-18 06:40:06'),(116,14,'2026-01-08','stock','2025-08-18 06:40:06'),(117,1,'2027-05-03','stock','2025-08-18 06:40:06'),(118,1,'2027-05-10','stock','2025-08-18 06:40:06'),(119,1,'2027-05-16','stock','2025-08-18 06:40:06'),(120,1,'2027-05-16','stock','2025-08-18 06:40:06'),(121,1,'2027-05-16','stock','2025-08-18 06:40:06'),(122,18,'2026-01-31','stock','2025-08-18 06:40:06'),(123,18,'2026-01-31','stock','2025-08-18 06:40:06'),(124,30,'2026-01-31','stock','2025-08-18 06:40:06'),(125,120,'2027-10-30','stock','2025-08-18 06:40:06'),(126,48,'2027-06-13','stock','2025-08-18 06:40:06'),(127,48,'2027-10-30','stock','2025-08-18 06:40:06'),(128,48,'2027-10-03','stock','2025-08-18 06:40:06'),(129,17,'2026-02-19','stock','2025-08-18 06:40:06'),(130,18,'2026-04-08','stock','2025-08-18 06:40:06'),(131,19,'2026-03-13','stock','2025-08-18 06:40:06'),(132,80,'2026-08-02','stock','2025-12-05 09:02:28'),(133,80,'2026-10-15','stock','2025-12-05 09:02:28'),(134,116,'2026-11-04','stock','2025-12-05 09:02:28'),(135,80,'2026-08-23','stock','2025-12-05 09:02:28'),(136,60,NULL,'stock','2025-12-05 09:02:28'),(137,400,'2027-09-15','stock','2025-12-05 09:02:28'),(138,600,'2026-05-22','stock','2025-12-05 09:02:28'),(139,120,'2026-09-30','stock','2025-12-05 09:02:28'),(140,600,'2026-06-30','stock','2025-12-05 09:02:28'),(141,600,'2026-07-29','stock','2025-12-05 09:02:28'),(142,600,'2026-07-24','stock','2025-12-05 09:02:28'),(143,600,'2026-07-04','stock','2025-12-05 09:02:28'),(7,120,'2027-04-01','stock','2025-12-05 09:02:28'),(5,120,'2027-03-01','stock','2025-12-05 09:02:28'),(6,180,'2027-03-20','stock','2025-12-05 09:02:28'),(144,600,'2026-09-30','stock','2025-12-05 09:02:28'),(145,600,'2026-09-30','stock','2025-12-05 09:02:28'),(106,84,NULL,'stock','2025-12-05 09:02:28'),(12,120,'2026-09-08','stock','2025-12-05 09:02:28'),(14,60,'2030-08-30','stock','2025-12-05 09:02:28'),(146,36,'2028-05-30','stock','2025-12-05 09:02:28'),(147,36,'2028-03-30','stock','2025-12-05 09:02:28'),(148,72,'2028-03-30','stock','2025-12-05 09:02:28'),(149,24,'2028-07-14','stock','2025-12-05 09:02:28'),(150,24,'2028-06-03','stock','2025-12-05 09:02:28'),(151,24,'2028-07-02','stock','2025-12-05 09:02:28'),(152,24,'2028-06-21','stock','2025-12-05 09:02:28'),(153,16,'2028-05-30','stock','2025-12-05 09:02:28'),(154,1152,'2025-06-30','stock','2025-12-05 09:02:28'),(19,200,NULL,'stock','2025-12-05 09:02:28'),(18,200,NULL,'stock','2025-12-05 09:02:28'),(155,60,'2027-03-19','stock','2025-12-05 09:02:28'),(156,60,'2027-03-18','stock','2025-12-05 09:02:28'),(157,60,'2027-03-18','stock','2025-12-05 09:02:28'),(22,288,'2026-07-18','stock','2025-12-05 09:02:28'),(21,360,'2026-06-21','stock','2025-12-05 09:02:28'),(158,120,'2026-08-19','stock','2025-12-05 09:02:28'),(159,120,'2026-09-05','stock','2025-12-05 09:02:28'),(23,360,'2026-08-13','stock','2025-12-05 09:02:28'),(36,240,'2026-08-21','stock','2025-12-05 09:02:28'),(160,120,'2027-02-04','stock','2025-12-05 09:02:28'),(161,360,'2026-08-16','stock','2025-12-05 09:02:28'),(162,360,'2026-08-15','stock','2025-12-05 09:02:28'),(163,240,'2026-08-16','stock','2025-12-05 09:02:28'),(164,384,'2026-08-11','stock','2025-12-05 09:02:28'),(165,264,'2026-08-12','stock','2025-12-05 09:02:28'),(166,264,'2026-08-14','stock','2025-12-05 09:02:28'),(167,288,'2026-11-30','stock','2025-12-05 09:02:28'),(168,12,'2026-11-30','stock','2025-12-05 09:02:28'),(169,168,'2027-09-05','stock','2025-12-05 09:02:28'),(170,120,'2028-01-25','stock','2025-12-05 09:02:28'),(171,168,'2027-09-18','stock','2025-12-05 09:02:28'),(172,144,'2027-09-17','stock','2025-12-05 09:02:28'),(173,120,'2027-02-15','stock','2025-12-05 09:02:28'),(174,120,'2027-12-24','stock','2025-12-05 09:02:28'),(175,120,'2026-08-21','stock','2025-12-05 09:02:28'),(176,40,'2026-12-03','stock','2025-12-05 09:02:28'),(177,40,'2026-10-30','stock','2025-12-05 09:02:28'),(59,198,'2027-08-01','stock','2025-12-05 09:02:28'),(60,440,'2027-06-01','stock','2025-12-05 09:02:28'),(178,400,'2026-09-19','stock','2025-12-05 09:02:28'),(179,400,'2026-09-19','stock','2025-12-05 09:02:28'),(69,240,'2026-08-07','stock','2025-12-05 09:02:28'),(70,120,'2026-09-02','stock','2025-12-05 09:02:28'),(180,120,NULL,'stock','2025-12-05 09:02:28'),(181,120,NULL,'stock','2025-12-05 09:02:28'),(182,240,NULL,'stock','2025-12-05 09:02:28'),(183,120,'2026-08-25','stock','2025-12-05 09:02:28'),(184,180,'2026-08-01','stock','2025-12-05 09:02:28'),(81,150,'2026-07-05','stock','2025-12-05 09:02:28'),(185,150,'2026-09-13','stock','2025-12-05 09:02:28'),(83,180,'2029-04-30','stock','2025-12-05 09:02:28'),(186,240,'2028-08-06','stock','2025-12-05 09:02:28'),(187,240,'2028-06-13','stock','2025-12-05 09:02:28'),(188,240,'2028-07-02','stock','2025-12-05 09:02:28'),(85,90,'2026-08-25','stock','2025-12-05 09:02:28'),(96,1200,'2027-02-28','stock','2025-12-05 09:02:28'),(98,200,'2027-03-05','stock','2025-12-05 09:02:28'),(97,400,'2027-01-11','stock','2025-12-05 09:02:28'),(189,96,'2028-09-30','stock','2025-12-05 09:02:28'),(190,96,'2028-09-30','stock','2025-12-05 09:02:28'),(191,96,'2028-09-30','stock','2025-12-05 09:02:28'),(192,96,'2028-09-30','stock','2025-12-05 09:02:28'),(193,96,'2028-09-30','stock','2025-12-05 09:02:28'),(194,150,'2026-09-30','stock','2025-12-05 09:02:28'),(195,80,'2026-06-30','stock','2025-12-05 09:02:28'),(196,300,'2027-05-06','stock','2025-12-05 09:02:28'),(197,400,'2027-08-02','stock','2025-12-05 09:02:28'),(198,96,NULL,'stock','2025-12-05 09:02:28'),(199,240,'2027-02-28','stock','2025-12-05 09:02:28'),(200,400,'2027-01-30','stock','2025-12-05 09:02:28'),(201,400,'2027-02-28','stock','2025-12-05 09:02:28'),(202,400,'2027-07-30','stock','2025-12-05 09:02:28'),(203,360,'2027-07-30','stock','2025-12-05 09:02:28'),(204,360,'2027-07-30','stock','2025-12-05 09:02:28'),(205,360,'2027-07-30','stock','2025-12-05 09:02:28'),(206,360,'2027-07-30','stock','2025-12-05 09:02:28'),(207,360,'2027-07-30','stock','2025-12-05 09:02:28'),(208,360,'2027-07-30','stock','2025-12-05 09:02:28'),(209,360,'2027-07-30','stock','2025-12-05 09:02:28'),(210,360,'2027-07-30','stock','2025-12-05 09:02:28'),(211,360,'2027-07-30','stock','2025-12-05 09:02:28'),(212,360,'2027-07-30','stock','2025-12-05 09:02:28'),(213,360,'2027-07-30','stock','2025-12-05 09:02:28'),(214,600,'2026-09-12','stock','2025-12-05 09:02:28'),(215,300,'2026-09-20','stock','2025-12-05 09:02:28'),(216,300,'2026-09-08','stock','2025-12-05 09:02:28'),(217,900,'2026-10-31','stock','2025-12-05 09:02:28'),(130,600,'2026-10-07','stock','2025-12-05 09:02:28'),(218,300,'2026-07-17','stock','2025-12-05 09:02:28'),(131,1890,'2026-09-09','stock','2025-12-05 09:02:28'),(219,50,'2026-08-21','stock','2025-12-05 09:02:28'),(220,125,'2027-09-25','stock','2025-12-05 09:02:28'),(221,90,'2027-09-25','stock','2025-12-05 09:02:28'),(222,300,'2027-09-25','stock','2025-12-05 09:02:28'),(223,200,'2027-09-25','stock','2025-12-05 09:02:28'),(224,200,'2027-09-25','stock','2025-12-05 09:02:28'),(225,200,'2027-09-25','stock','2025-12-05 09:02:28'),(226,240,'2027-09-25','stock','2025-12-05 09:02:28'),(227,300,'2027-09-25','stock','2025-12-05 09:02:28'),(228,200,'2027-09-25','stock','2025-12-05 09:02:28'),(229,105,'2027-09-25','stock','2025-12-05 09:02:28'),(230,100,'2027-09-25','stock','2025-12-05 09:02:28'),(231,69,'2026-08-01','stock','2025-12-05 09:02:28'),(232,85,'2026-08-01','stock','2025-12-05 09:02:28'),(233,110,'2026-08-01','stock','2025-12-05 09:02:28'),(234,160,'2026-08-01','stock','2025-12-05 09:02:28'),(235,100,'2026-08-01','stock','2025-12-05 09:02:28'),(236,160,'2026-08-01','stock','2025-12-05 09:02:28'),(237,125,'2026-08-01','stock','2025-12-05 09:02:28'),(238,200,'2026-08-01','stock','2025-12-05 09:02:28'),(87,125,'2026-08-01','stock','2025-12-05 09:02:28'),(88,75,'2026-08-01','stock','2025-12-05 09:02:28'),(89,45,'2026-08-01','stock','2025-12-05 09:02:28'),(90,39,'2026-08-01','stock','2025-12-05 09:02:28'),(91,39,'2026-08-01','stock','2025-12-05 09:02:28'),(93,120,'2026-08-01','stock','2025-12-05 09:02:28'),(94,42,'2026-08-01','stock','2025-12-05 09:02:28'),(95,65,'2026-08-01','stock','2025-12-05 09:02:28'),(239,100,'2027-03-30','stock','2025-12-05 09:02:28'),(240,60,'2027-03-30','stock','2025-12-05 09:02:28'),(241,75,'2028-12-02','stock','2025-12-05 09:02:28'),(242,120,'2028-12-02','stock','2025-12-05 09:02:28'),(243,24,'2028-12-02','stock','2025-12-05 09:02:28'),(244,48,'2028-12-02','stock','2025-12-05 09:02:28'),(245,48,'2030-12-02','stock','2025-12-05 09:02:28'),(246,5,NULL,'stock','2025-12-05 09:02:28'),(247,5,NULL,'stock','2025-12-05 09:02:28'),(248,5,NULL,'stock','2025-12-05 09:02:28'),(249,5,NULL,'stock','2025-12-05 09:02:28'),(250,5,NULL,'stock','2025-12-05 09:02:28'),(251,5,NULL,'stock','2025-12-05 09:02:28'),(252,50,'2027-09-05','stock','2026-03-31 08:20:16'),(253,25,'2027-03-02','stock','2026-03-31 08:20:16'),(254,20,'2027-01-01','stock','2026-03-31 08:20:16'),(255,960,'2028-05-20','stock','2026-04-06 11:52:11'),(256,600,'2028-09-06','stock','2026-04-06 14:31:47'),(257,120,'2028-12-08','stock','2026-04-06 14:31:47'),(258,120,'2028-03-08','stock','2026-04-06 14:31:47'),(259,120,'2028-10-30','stock','2026-04-06 14:31:47'),(260,168,'2028-12-06','stock','2026-04-06 14:31:47'),(261,120,'2028-10-30','stock','2026-04-06 14:31:47'),(262,120,'2028-12-06','stock','2026-04-06 14:31:47'),(263,12,NULL,'stock','2026-04-06 14:31:47'),(264,144,'2029-01-31','stock','2026-04-06 14:31:47'),(265,144,'2029-01-31','stock','2026-04-06 14:31:47'),(266,144,'2028-12-31','stock','2026-04-06 14:31:47'),(267,18,NULL,'stock','2026-04-06 14:31:47'),(268,96,'2028-04-28','stock','2026-04-06 14:31:47'),(269,52,'2030-02-13','stock','2026-04-06 14:31:47'),(270,52,'2030-01-16','stock','2026-04-06 14:31:47'),(271,52,'2030-02-10','stock','2026-04-06 14:31:47'),(272,52,'2030-09-24','stock','2026-04-06 14:31:47'),(273,52,'2029-04-27','stock','2026-04-06 14:31:47'),(274,0,NULL,'stock','2026-04-06 14:31:47'),(275,250,NULL,'stock','2026-04-06 14:31:47'),(276,160,NULL,'stock','2026-04-06 14:31:47'),(277,120,'2027-12-19','stock','2026-04-06 14:31:47'),(278,24,'2027-11-16','stock','2026-04-06 14:31:47'),(279,120,'2027-01-31','stock','2026-04-06 14:31:47'),(280,120,'2027-01-31','stock','2026-04-06 14:31:47'),(281,120,'2027-01-31','stock','2026-04-06 14:31:47'),(282,1440,'2028-04-07','stock','2026-04-06 14:31:47'),(283,48,'2028-04-23','stock','2026-04-06 14:31:47'),(284,48,'2028-06-17','stock','2026-04-06 14:31:47'),(285,48,'2028-04-03','stock','2026-04-06 14:31:47'),(286,120,'2026-12-02','stock','2026-04-06 14:31:47'),(287,120,'2026-10-29','stock','2026-04-06 14:31:47'),(288,96,NULL,'stock','2026-04-06 14:31:47'),(289,72,NULL,'stock','2026-04-06 14:31:47'),(290,240,'2026-12-06','stock','2026-04-06 14:31:47'),(291,60,'2027-04-02','stock','2026-04-06 14:31:47'),(292,300,'2026-12-06','stock','2026-04-06 14:31:47'),(293,120,'2029-01-31','stock','2026-04-06 14:31:47'),(294,72,'2028-10-31','stock','2026-04-06 14:31:47'),(295,36,'2028-10-31','stock','2026-04-06 14:31:47'),(296,36,'2028-10-31','stock','2026-04-06 14:31:47'),(297,36,'2028-10-31','stock','2026-04-06 14:31:47'),(298,72,'2026-12-31','stock','2026-04-06 14:31:47'),(299,90,NULL,'stock','2026-04-06 14:31:47'),(300,90,NULL,'stock','2026-04-06 14:31:47'),(301,90,NULL,'stock','2026-04-06 14:31:47'),(302,90,NULL,'stock','2026-04-06 14:31:47'),(303,180,'2027-07-06','stock','2026-04-06 14:31:47'),(304,480,'2027-01-14','stock','2026-04-06 14:31:47'),(305,480,'2027-01-13','stock','2026-04-06 14:31:47'),(306,480,'2027-01-15','stock','2026-04-06 14:31:47'),(307,480,'2027-01-15','stock','2026-04-06 14:31:47'),(308,480,'2027-01-15','stock','2026-04-06 14:31:47'),(309,48,'2028-10-31','stock','2026-04-06 14:31:47'),(310,96,'2028-12-31','stock','2026-04-06 14:31:47'),(311,84,NULL,'stock','2026-04-06 14:31:47'),(312,120,NULL,'stock','2026-04-06 14:31:47'),(313,36,NULL,'stock','2026-04-06 14:31:47'),(314,96,NULL,'stock','2026-04-06 14:31:47'),(315,120,NULL,'stock','2026-04-06 14:31:47'),(316,100,NULL,'stock','2026-04-06 14:31:47'),(317,120,'2026-12-04','stock','2026-04-06 14:31:47'),(318,90,'2028-06-23','stock','2026-04-06 14:31:47'),(319,120,'2028-06-18','stock','2026-04-06 14:31:47'),(320,60,'2028-02-18','stock','2026-04-06 14:31:47'),(321,60,'2028-05-07','stock','2026-04-06 14:31:47'),(322,60,'2028-05-10','stock','2026-04-06 14:31:47'),(323,60,'2028-04-27','stock','2026-04-06 14:31:47'),(324,60,'2027-02-28','stock','2026-04-06 14:31:47'),(325,400,'2029-12-31','stock','2026-04-06 14:31:47'),(326,250,'2027-02-05','stock','2026-04-06 14:31:47'),(327,80,'2027-02-05','stock','2026-04-06 14:31:47'),(1,720,'2027-01-12','stock','2026-04-06 14:59:39'),(139,120,'2027-01-31','stock','2026-04-06 14:59:39'),(5,240,'2027-07-23','stock','2026-04-06 14:59:39'),(6,600,'2027-07-25','stock','2026-04-06 14:59:39'),(7,600,'2027-07-03','stock','2026-04-06 14:59:39'),(14,120,'2028-11-30','stock','2026-04-06 14:59:39'),(146,180,'2028-11-01','stock','2026-04-06 14:59:39'),(147,80,'2028-09-02','stock','2026-04-06 14:59:39'),(148,180,'2028-09-02','stock','2026-04-06 14:59:39'),(153,80,'2028-10-10','stock','2026-04-06 14:59:39'),(154,5760,'2028-11-02','stock','2026-04-06 14:59:39'),(22,720,'2026-11-16','stock','2026-04-06 14:59:39'),(158,240,'2026-12-13','stock','2026-04-06 14:59:39'),(27,400,'2027-01-11','stock','2026-04-06 14:59:39'),(29,1000,'2027-01-15','stock','2026-04-06 14:59:39'),(25,400,'2027-01-14','stock','2026-04-06 14:59:39'),(28,600,'2026-12-29','stock','2026-04-06 14:59:39'),(162,240,'2026-11-09','stock','2026-04-06 14:59:39'),(163,360,'2026-11-11','stock','2026-04-06 14:59:39'),(165,360,'2026-11-07','stock','2026-04-06 14:59:39'),(166,360,'2026-11-08','stock','2026-04-06 14:59:39'),(329,120,'2028-01-17','stock','2026-04-06 14:59:39'),(331,120,'2027-12-16','stock','2026-04-06 14:59:39'),(330,48,'2028-04-06','stock','2026-04-06 14:59:39'),(173,48,'2028-04-21','stock','2026-04-06 14:59:39'),(174,120,'2028-07-02','stock','2026-04-06 14:59:39'),(69,96,'2026-11-12','stock','2026-04-06 14:59:39'),(70,48,'2026-12-02','stock','2026-04-06 14:59:39'),(72,120,'2026-10-20','stock','2026-04-06 14:59:39'),(180,60,NULL,'stock','2026-04-06 14:59:39'),(181,108,NULL,'stock','2026-04-06 14:59:39'),(182,216,NULL,'stock','2026-04-06 14:59:39'),(75,960,'2026-12-08','stock','2026-04-06 14:59:39'),(76,360,'2026-12-07','stock','2026-04-06 14:59:39'),(77,360,'2026-12-10','stock','2026-04-06 14:59:39'),(79,240,'2027-01-10','stock','2026-04-06 14:59:39'),(186,240,'2028-11-01','stock','2026-04-06 14:59:39'),(85,150,'2026-12-13','stock','2026-04-06 14:59:39'),(86,480,'2026-11-14','stock','2026-04-06 14:59:39'),(189,240,'2029-01-31','stock','2026-04-06 14:59:39'),(190,120,'2028-12-31','stock','2026-04-06 14:59:39'),(191,120,'2028-12-31','stock','2026-04-06 14:59:39'),(192,120,'2029-01-31','stock','2026-04-06 14:59:39'),(193,120,'2028-12-31','stock','2026-04-06 14:59:39'),(101,24,'2026-12-31','stock','2026-04-06 14:59:39'),(197,200,'2027-12-19','stock','2026-04-06 14:59:39'),(105,48,'2026-09-24','stock','2026-04-06 14:59:39'),(115,360,'2027-07-19','stock','2026-04-06 14:59:39'),(112,240,'2027-06-29','stock','2026-04-06 14:59:39'),(111,120,'2027-06-27','stock','2026-04-06 14:59:39'),(214,600,'2027-02-04','stock','2026-04-06 14:59:39'),(215,600,'2027-02-06','stock','2026-04-06 14:59:39'),(216,600,'2027-02-05','stock','2026-04-06 14:59:39'),(130,90,'2026-12-12','stock','2026-04-06 14:59:39'),(129,300,'2027-01-06','stock','2026-04-06 14:59:39'),(84,108,'2026-12-01','stock','2026-04-06 14:59:39'),(59,180,'2027-12-01','stock','2026-04-06 14:59:39'),(176,80,'2027-04-26','stock','2026-04-06 14:59:39'),(226,75,'2027-02-05','stock','2026-04-06 14:59:39'),(87,54,'2026-12-10','stock','2026-04-06 14:59:39'),(95,13,'2026-12-10','stock','2026-04-06 14:59:39'),(89,36,'2026-12-10','stock','2026-04-06 14:59:39'),(90,39,'2026-12-10','stock','2026-04-06 14:59:39'),(91,39,'2026-12-10','stock','2026-04-06 14:59:39'),(232,70,'2026-12-10','stock','2026-04-06 14:59:39'),(234,99,'2026-12-10','stock','2026-04-06 14:59:39'),(328,162,'2026-12-10','stock','2026-04-06 14:59:39');
/*!40000 ALTER TABLE `warehoused` 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-04-27 13:46:19
