Da

✏️ Editing: kwannamo_rice.sql

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.26-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: kwannamo_rice
-- ------------------------------------------------------
-- Server version	10.5.26-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `kwannamo_rice`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `kwannamo_rice` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci */;

USE `kwannamo_rice`;

--
-- Table structure for table `customer`
--

DROP TABLE IF EXISTS `customer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customer` (
  `customerId` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `phone` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(50) NOT NULL DEFAULT '',
  `firstName` varchar(50) NOT NULL,
  `lastName` varchar(50) NOT NULL,
  `lineId` varchar(50) DEFAULT NULL,
  `password` varchar(250) NOT NULL,
  `notes` varchar(250) NOT NULL,
  `createdDate` datetime NOT NULL DEFAULT current_timestamp(),
  `updatedDate` datetime DEFAULT NULL ON UPDATE current_timestamp(),
  `statusId` tinyint(4) NOT NULL DEFAULT 1,
  PRIMARY KEY (`customerId`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!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,'0919999','view@gmail.com','tom','tomtom','@totom','$2y$10$qJdayYSBQ5jeL6bpSXGgxuMYa/u9wXYOa9WLd9RL34Lxs0ijVjpQm','tomtom Local office rice organic original','2025-04-29 10:51:39',NULL,1),(2,'0910099','riew@gmail.com','riew','tomtom','@riew','$2y$10$4PSeu39Xnelf7aljvmTT0uEKfn1h8cJrrzWP0v3Mn1wmehXD1fy.m','riew Local office rice organic original','2025-04-29 10:52:04','2025-04-29 11:00:00',1);
/*!40000 ALTER TABLE `customer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detail`
--

DROP TABLE IF EXISTS `detail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detail` (
  `autId` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `transactId` int(10) unsigned NOT NULL,
  `productId` varchar(50) NOT NULL,
  `productName` varchar(50) NOT NULL,
  `unitName` varchar(50) NOT NULL,
  `notes` varchar(250) DEFAULT NULL,
  `ppu` decimal(20,2) unsigned NOT NULL DEFAULT 0.00,
  `amt` int(10) unsigned NOT NULL DEFAULT 0,
  `total` decimal(20,2) unsigned NOT NULL DEFAULT 0.00,
  PRIMARY KEY (`autId`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detail`
--

LOCK TABLES `detail` WRITE;
/*!40000 ALTER TABLE `detail` DISABLE KEYS */;
INSERT INTO `detail` VALUES (1,1,'10001','ข้าวหอมมะลิออการ์นิค','1KG per pack','Kwannamom Brand original',45.50,1,45.50),(2,1,'10003','ข้าวหอมมะลิแดงออการ์นิค','1KG per pack','Kwannamom Brand original',50.00,1,50.00),(3,2,'10001','ข้าวหอมมะลิออการ์นิค','1KG per pack','Kwannamom Brand original',45.50,1,45.50),(4,2,'10001','ข้าวหอมมะลิออการ์นิค','1KG per pack','Kwannamom Brand original',45.50,1,45.50),(5,3,'10001','ข้าวหอมมะลิออการ์นิค','1KG per pack','Kwannamom Brand original',45.50,1,45.50),(6,4,'10001','ข้าวหอมมะลิออการ์นิค','1KG per pack','Kwannamom Brand original',45.50,1,45.50),(7,5,'10001','ข้าวหอมมะลิออการ์นิค','1KG per pack','Kwannamom Brand original',45.50,1,45.50),(8,6,'10001','ข้าวหอมมะลิออการ์นิค','1KG per pack','Kwannamom Brand original',45.50,1,45.50),(9,6,'10001','ข้าวหอมมะลิออการ์นิค','1KG per pack','Kwannamom Brand original',45.50,1,45.50),(10,7,'10001','ข้าวหอมมะลิออการ์นิค','1KG per pack','Kwannamom Brand original',45.50,1,45.50),(11,7,'10001','ข้าวหอมมะลิออการ์นิค','1KG per pack','Kwannamom Brand original',45.50,1,45.50),(12,7,'10001','ข้าวหอมมะลิออการ์นิค','1KG per pack','Kwannamom Brand original',45.50,1,45.50),(13,7,'10001','ข้าวหอมมะลิออการ์นิค','1KG per pack','Kwannamom Brand original',45.50,1,45.50),(14,8,'10002','ข้าวกล้องอการ์นิค','1KG per pack','Kwannamom Brand original',50.00,1,50.00);
/*!40000 ALTER TABLE `detail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `head`
--

DROP TABLE IF EXISTS `head`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `head` (
  `transactId` int(11) NOT NULL AUTO_INCREMENT,
  `isOnline` tinyint(4) NOT NULL DEFAULT 0,
  `staffId` varchar(5) NOT NULL,
  `numRow` int(10) unsigned NOT NULL DEFAULT 0,
  `sumItem` int(10) unsigned NOT NULL DEFAULT 0,
  `totals` decimal(20,2) unsigned NOT NULL DEFAULT 0.00,
  `discount` decimal(20,2) unsigned NOT NULL DEFAULT 0.00,
  `grandTotals` decimal(20,2) unsigned NOT NULL DEFAULT 0.00,
  `statusId` tinyint(4) NOT NULL DEFAULT 1,
  `customerId` int(10) unsigned NOT NULL DEFAULT 0,
  `isTransfer` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `notes` varchar(250) DEFAULT NULL,
  `transactDate` datetime NOT NULL DEFAULT current_timestamp(),
  `notesConfirm` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`transactId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `head`
--

LOCK TABLES `head` WRITE;
/*!40000 ALTER TABLE `head` DISABLE KEYS */;
INSERT INTO `head` VALUES (1,1,'1001',2,2,95.50,0.00,95.50,6,2,0,'39 Moo 4 Nammom Khowang Yasothorn 35160','2025-05-05 17:19:11',NULL),(2,1,'1001',2,2,91.00,0.00,91.00,-2,2,1,'xx xxx ccxcc cxvvxvx xcxc','2025-05-05 18:10:24',NULL),(3,1,'1001',1,1,45.50,0.00,45.50,0,2,0,'ss sds  dsddd sdsddsd f','2025-05-05 18:24:51',NULL),(4,1,'1001',1,1,45.50,0.00,45.50,5,2,1,'40 Moo 4 Siriputtana Namom Khowang Yasothorn 35160','2025-05-05 18:29:29',NULL),(5,1,'1001',1,1,45.50,0.00,45.50,3,2,0,'xxx xxxxx xxxxxxxxxx','2025-05-05 20:23:59',NULL),(6,1,'1001',2,2,91.00,0.00,91.00,-1,2,1,'61 Moo 1 Nonsila Nonsila Nonsila Khonkaeng 4110','2025-05-07 10:38:41',NULL),(7,1,'1001',4,4,182.00,0.00,182.00,3,2,1,'82 Moo 10 Yasothorn 35160','2025-05-07 13:56:45',NULL),(8,1,'1001',1,1,50.00,0.00,50.00,1,2,0,'39 Moo 4 Khowang Yasothorn','2025-05-08 08:59:27',NULL);
/*!40000 ALTER TABLE `head` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `office`
--

DROP TABLE IF EXISTS `office`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `office` (
  `officeId` varchar(5) NOT NULL,
  `officeName` varchar(100) NOT NULL,
  `address` varchar(250) NOT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `notes` varchar(250) DEFAULT NULL,
  `statusId` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `createdDate` datetime NOT NULL DEFAULT current_timestamp(),
  `updatedDate` datetime DEFAULT NULL ON UPDATE current_timestamp(),
  PRIMARY KEY (`officeId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `office`
--

LOCK TABLES `office` WRITE;
/*!40000 ALTER TABLE `office` DISABLE KEYS */;
INSERT INTO `office` VALUES ('1001','subin@gmail.com','82 Moo 10 Siriputtana Namom Khowang Yasothorn 35160','080175669','Local office rice organic original',1,'2025-04-29 10:44:31',NULL),('1002','Brach 2','82 Moo 4 Siriputtana Namom Khowang Yasothorn 35160','080175669','Local office rice organic original',1,'2025-04-29 10:45:18',NULL);
/*!40000 ALTER TABLE `office` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `orders`
--

DROP TABLE IF EXISTS `orders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orders` (
  `transactId` int(11) NOT NULL,
  `isOnline` tinyint(4) NOT NULL DEFAULT 0,
  `staffId` varchar(5) NOT NULL,
  `numRow` int(10) unsigned NOT NULL DEFAULT 0,
  `sumItem` int(10) unsigned NOT NULL DEFAULT 0,
  `totals` decimal(20,2) unsigned NOT NULL DEFAULT 0.00,
  `discount` decimal(20,2) unsigned NOT NULL DEFAULT 0.00,
  `grandTotals` decimal(20,2) unsigned NOT NULL DEFAULT 0.00,
  `statusId` tinyint(4) NOT NULL DEFAULT 1,
  `customerId` int(10) unsigned NOT NULL DEFAULT 0,
  `isTransfer` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `notes` varchar(250) DEFAULT NULL,
  `transactDate` datetime NOT NULL DEFAULT current_timestamp(),
  `notesConfirm` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`transactId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `orders`
--

LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
INSERT INTO `orders` VALUES (1,1,'1001',2,2,95.50,0.00,95.50,6,2,0,'39 Moo 4 Nammom Khowang Yasothorn 35160','2025-05-05 17:19:11',NULL),(2,1,'1001',2,2,91.00,0.00,91.00,-2,2,1,'xx xxx ccxcc cxvvxvx xcxc','2025-05-05 18:10:24',NULL),(3,1,'1001',1,1,45.50,0.00,45.50,0,2,0,'ss sds  dsddd sdsddsd f','2025-05-05 18:24:51',NULL),(4,1,'1001',1,1,45.50,0.00,45.50,5,2,1,'40 Moo 4 Siriputtana Namom Khowang Yasothorn 35160','2025-05-05 18:29:29',NULL),(5,1,'1001',1,1,45.50,0.00,45.50,3,2,0,'xxx xxxxx xxxxxxxxxx','2025-05-05 20:23:59','xxxx xcxcxc xcxcxcx c'),(6,1,'1001',2,2,91.00,0.00,91.00,-1,2,1,'61 Moo 1 Nonsila Nonsila Nonsila Khonkaeng 4110','2025-05-07 10:38:41',NULL),(7,1,'1001',4,4,182.00,0.00,182.00,3,2,1,'82 Moo 10 Yasothorn 35160','2025-05-07 13:56:45','xxxxxxxxxxxx dsdsdsdsdsdsds'),(8,1,'1001',1,1,50.00,0.00,50.00,1,2,0,'39 Moo 4 Khowang Yasothorn','2025-05-08 08:59:27',NULL);
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product`
--

DROP TABLE IF EXISTS `product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product` (
  `productId` varchar(5) NOT NULL,
  `name` varchar(50) NOT NULL,
  `unitName` varchar(50) NOT NULL,
  `ppu` decimal(20,2) NOT NULL DEFAULT 0.00,
  `descript` varchar(250) DEFAULT NULL,
  `statusId` tinyint(4) NOT NULL DEFAULT 1,
  `createdDate` datetime NOT NULL DEFAULT current_timestamp(),
  `updatedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`productId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product`
--

LOCK TABLES `product` WRITE;
/*!40000 ALTER TABLE `product` DISABLE KEYS */;
INSERT INTO `product` VALUES ('10001','ข้าวหอมมะลิออการ์นิค','1KG per pack',45.50,'Kwannamom Brand original',1,'2025-04-28 17:52:54',NULL),('10002','ข้าวกล้องอการ์นิค','1KG per pack',50.00,'Kwannamom Brand original',1,'2025-04-28 17:54:16',NULL),('10003','ข้าวหอมมะลิแดงออการ์นิค','1KG per pack',50.00,'Kwannamom Brand original',1,'2025-04-28 17:54:49',NULL);
/*!40000 ALTER TABLE `product` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `staff`
--

DROP TABLE IF EXISTS `staff`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `staff` (
  `staffId` varchar(5) NOT NULL,
  `email` varchar(50) NOT NULL,
  `password` varchar(250) NOT NULL,
  `firstName` varchar(50) NOT NULL,
  `lastName` varchar(50) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `levelId` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `statusId` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `createdDate` datetime NOT NULL DEFAULT current_timestamp(),
  `updatedDate` datetime DEFAULT NULL ON UPDATE current_timestamp(),
  `officeId` varchar(5) DEFAULT '00000',
  PRIMARY KEY (`staffId`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `staff`
--

LOCK TABLES `staff` WRITE;
/*!40000 ALTER TABLE `staff` DISABLE KEYS */;
INSERT INTO `staff` VALUES ('10001','jasubin@hotmail.com','$2y$10$bo0BVG7D64WCxGCvdfTcUORsFPJx7um5KUZH.M3ysdIkhTzmQIGg.','subin','jantasing','0801745594',1,1,'2025-04-28 14:57:20','2025-06-28 15:01:42','1001'),('10002','jasubin@gmail.com','$2y$10$WUR881DGrYRZ7KJP8ZS5L.p0gCAv4t.vTcUB5BipdIh9GjJvm.Jn.','rom','jantasing','0801',1,1,'2025-04-28 14:58:25','2025-06-28 15:00:10','1001'),('10003','subin@gmail.com','$2y$10$G8QW.p5SWi4v20T1V8kVsuv6uMrhXSTg.fHlCjyTLxFPyJbhuDheW','ram','jantasing','0801',1,1,'2025-04-28 14:59:36','2025-06-28 15:00:20','1002');
/*!40000 ALTER TABLE `staff` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `statushead`
--

DROP TABLE IF EXISTS `statushead`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `statushead` (
  `statusId` tinyint(4) NOT NULL,
  `descript` varchar(50) NOT NULL DEFAULT 'Order',
  PRIMARY KEY (`statusId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `statushead`
--

LOCK TABLES `statushead` WRITE;
/*!40000 ALTER TABLE `statushead` DISABLE KEYS */;
INSERT INTO `statushead` VALUES (-2,'Cancel Deliver'),(-1,'Cancel Admin'),(0,'Cancel Customer'),(1,'Ordering'),(2,'Confirm Transfer'),(3,'Confirmed'),(4,'Package'),(5,'Delivery'),(6,'Finished');
/*!40000 ALTER TABLE `statushead` 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 2025-10-22 16:52:42

📁 Sid Gifari File Manager