-- MySQL dump 10.13 Distrib 8.0.30, for Win64 (x86_64) -- -- Host: localhost Database: joglo_koi_rms -- ------------------------------------------------------ -- Server version 8.0.30 /*!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 */; -- -- Current Database: `joglo_koi_rms` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `joglo_koi_rms` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */ /*!80016 DEFAULT ENCRYPTION='N' */; USE `joglo_koi_rms`; -- -- Table structure for table `attendance` -- DROP TABLE IF EXISTS `attendance`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `attendance` ( `id` int NOT NULL AUTO_INCREMENT, `employee_id` int NOT NULL, `attendance_date` date NOT NULL, `clock_in` time DEFAULT NULL, `clock_out` time DEFAULT NULL, `status` enum('present','late','absent','leave','holiday') COLLATE utf8mb4_unicode_ci DEFAULT 'present', `overtime_hours` decimal(4,2) DEFAULT '0.00', `notes` text COLLATE utf8mb4_unicode_ci, `device_info` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `unique_attendance` (`employee_id`,`attendance_date`), CONSTRAINT `attendance_ibfk_1` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `attendance` -- LOCK TABLES `attendance` WRITE; /*!40000 ALTER TABLE `attendance` DISABLE KEYS */; /*!40000 ALTER TABLE `attendance` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `audit_logs` -- DROP TABLE IF EXISTS `audit_logs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `audit_logs` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int DEFAULT NULL, `action` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `module` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `record_id` int DEFAULT NULL, `old_data` json DEFAULT NULL, `new_data` json DEFAULT NULL, `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_agent` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), CONSTRAINT `audit_logs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=148 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `audit_logs` -- LOCK TABLES `audit_logs` WRITE; /*!40000 ALTER TABLE `audit_logs` DISABLE KEYS */; INSERT INTO `audit_logs` VALUES (1,2,'LOGIN','auth',2,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-25 17:14:53'),(2,2,'LOGOUT','auth',2,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-25 17:15:56'),(3,1,'LOGIN','auth',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-25 17:16:02'),(4,1,'LOGOUT','auth',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-25 17:20:30'),(5,3,'LOGIN','auth',3,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-25 17:20:47'),(6,3,'LOGOUT','auth',3,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-25 17:21:09'),(7,1,'LOGIN','auth',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-25 17:28:50'),(8,1,'LOGIN','auth',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 00:54:17'),(9,1,'LOGIN','auth',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 01:24:31'),(10,1,'LOGIN','auth',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 02:13:45'),(11,1,'CALCULATE_PAYROLL','payroll',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 02:14:16'),(12,1,'LOGOUT','auth',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 02:55:57'),(13,2,'LOGIN','auth',2,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 02:56:10'),(14,2,'LOGOUT','auth',2,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 02:59:03'),(15,3,'LOGIN','auth',3,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 02:59:11'),(16,3,'CREATE_SUPPLIER','suppliers',16,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:02:04'),(17,3,'LOGOUT','auth',3,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:03:27'),(18,4,'LOGIN','auth',4,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:03:36'),(19,4,'LOGOUT','auth',4,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:36:43'),(20,2,'LOGIN','auth',2,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:36:50'),(21,2,'LOGOUT','auth',2,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:39:53'),(22,1,'LOGIN','auth',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:40:03'),(23,1,'APPROVE_PAYROLL','payroll',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:41:09'),(24,1,'PAY_PAYROLL','payroll',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:41:45'),(25,1,'CREATE_ORDER','orders',1,NULL,'{\"total\": 124200, \"order_number\": \"KOI-20260826-0001\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:45:02'),(26,1,'PAYMENT','payments',1,NULL,'{\"amount\": 124200, \"method\": \"cash\", \"order_number\": \"KOI-20260826-0001\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:45:24'),(27,1,'CREATE_ORDER','orders',2,NULL,'{\"total\": 124200, \"order_number\": \"KOI-20260826-0002\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:47:04'),(28,1,'PAYMENT','payments',2,NULL,'{\"amount\": 124200, \"method\": \"qris\", \"order_number\": \"KOI-20260826-0002\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:47:07'),(29,1,'CREATE_ORDER','orders',3,NULL,'{\"total\": 124200, \"order_number\": \"KOI-20260826-0003\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:50:59'),(30,1,'PAYMENT','payments',3,NULL,'{\"amount\": 124200, \"method\": \"cash\", \"order_number\": \"KOI-20260826-0003\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:51:03'),(31,1,'CREATE_ORDER','orders',4,NULL,'{\"total\": 124200, \"order_number\": \"KOI-20260826-0004\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:51:08'),(32,1,'CREATE_ORDER','orders',5,NULL,'{\"total\": 124200, \"order_number\": \"KOI-20260826-0005\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:51:16'),(33,1,'PAYMENT','payments',5,NULL,'{\"amount\": 124200, \"method\": \"bank_transfer\", \"order_number\": \"KOI-20260826-0005\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:51:21'),(34,1,'CREATE_ORDER','orders',6,NULL,'{\"total\": 124200, \"order_number\": \"KOI-20260826-0006\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:51:35'),(35,1,'PAYMENT','payments',6,NULL,'{\"amount\": 124200, \"method\": \"qris\", \"order_number\": \"KOI-20260826-0006\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:51:38'),(36,1,'CREATE_ORDER','orders',7,NULL,'{\"total\": 124200, \"order_number\": \"KOI-20260826-0007\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:51:43'),(37,1,'PAYMENT','payments',7,NULL,'{\"amount\": 124200, \"method\": \"cash\", \"order_number\": \"KOI-20260826-0007\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:51:47'),(38,1,'CREATE_ORDER','orders',8,NULL,'{\"total\": 103500, \"order_number\": \"KOI-20260826-0008\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:52:16'),(39,1,'CREATE_ORDER','orders',9,NULL,'{\"total\": 207000, \"order_number\": \"KOI-20260826-0009\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:52:27'),(40,1,'PAYMENT','payments',9,NULL,'{\"amount\": 207000, \"method\": \"cash\", \"order_number\": \"KOI-20260826-0009\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:52:32'),(41,1,'CREATE_ORDER','orders',10,NULL,'{\"total\": 207000, \"order_number\": \"KOI-20260826-0010\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:53:05'),(42,1,'PAYMENT','payments',10,NULL,'{\"amount\": 207000, \"method\": \"bank_transfer\", \"order_number\": \"KOI-20260826-0010\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:53:08'),(43,1,'CREATE_ORDER','orders',11,NULL,'{\"total\": 207000, \"order_number\": \"KOI-20260826-0011\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:53:13'),(44,1,'PAYMENT','payments',11,NULL,'{\"amount\": 207000, \"method\": \"ewallet\", \"order_number\": \"KOI-20260826-0011\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:53:17'),(45,1,'CREATE_ORDER','orders',12,NULL,'{\"total\": 207000, \"order_number\": \"KOI-20260826-0012\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:53:21'),(46,1,'PAYMENT','payments',12,NULL,'{\"amount\": 207000, \"method\": \"qris\", \"order_number\": \"KOI-20260826-0012\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:53:24'),(47,1,'CREATE_ORDER','orders',13,NULL,'{\"total\": 270250, \"order_number\": \"KOI-20260826-0013\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:59:46'),(48,1,'PAYMENT','payments',13,NULL,'{\"amount\": 270250, \"method\": \"cash\", \"order_number\": \"KOI-20260826-0013\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 03:59:57'),(49,1,'CANCEL_ORDER','orders',8,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 04:21:42'),(50,1,'CREATE_ORDER','orders',14,NULL,'{\"total\": 103500, \"order_number\": \"KOI-20260826-0014\"}','::1','Mozilla/5.0 (iPad; CPU OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.5 Mobile/15E148 Safari/604.1','2026-08-26 04:27:46'),(51,1,'PAYMENT','payments',14,NULL,'{\"amount\": 103500, \"method\": \"cash\", \"order_number\": \"KOI-20260826-0014\"}','::1','Mozilla/5.0 (iPad; CPU OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.5 Mobile/15E148 Safari/604.1','2026-08-26 04:27:50'),(52,1,'CREATE_ORDER','orders',15,NULL,'{\"total\": 149500, \"order_number\": \"KOI-20260826-0015\"}','::1','Mozilla/5.0 (iPad; CPU OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.5 Mobile/15E148 Safari/604.1','2026-08-26 04:28:56'),(53,1,'PAYMENT','payments',15,NULL,'{\"amount\": 200000, \"method\": \"cash\", \"order_number\": \"KOI-20260826-0015\"}','::1','Mozilla/5.0 (iPad; CPU OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.5 Mobile/15E148 Safari/604.1','2026-08-26 04:29:08'),(54,1,'KITCHEN_STATUS_UPDATE','kitchen',10,NULL,'{\"status\": \"preparing\"}','::1','Mozilla/5.0 (iPad; CPU OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.5 Mobile/15E148 Safari/604.1','2026-08-26 04:30:00'),(55,1,'KITCHEN_STATUS_UPDATE','kitchen',10,NULL,'{\"status\": \"ready\"}','::1','Mozilla/5.0 (iPad; CPU OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.5 Mobile/15E148 Safari/604.1','2026-08-26 04:30:02'),(56,1,'KITCHEN_STATUS_UPDATE','kitchen',10,NULL,'{\"status\": \"served\"}','::1','Mozilla/5.0 (iPad; CPU OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.5 Mobile/15E148 Safari/604.1','2026-08-26 04:30:05'),(57,1,'KITCHEN_STATUS_UPDATE','kitchen',11,NULL,'{\"status\": \"preparing\"}','::1','Mozilla/5.0 (iPad; CPU OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.5 Mobile/15E148 Safari/604.1','2026-08-26 04:30:09'),(58,1,'KITCHEN_STATUS_UPDATE','kitchen',11,NULL,'{\"status\": \"ready\"}','::1','Mozilla/5.0 (iPad; CPU OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.5 Mobile/15E148 Safari/604.1','2026-08-26 04:30:09'),(59,1,'KITCHEN_STATUS_UPDATE','kitchen',11,NULL,'{\"status\": \"served\"}','::1','Mozilla/5.0 (iPad; CPU OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.5 Mobile/15E148 Safari/604.1','2026-08-26 04:30:09'),(60,1,'KITCHEN_STATUS_UPDATE','kitchen',12,NULL,'{\"status\": \"preparing\"}','::1','Mozilla/5.0 (iPad; CPU OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.5 Mobile/15E148 Safari/604.1','2026-08-26 04:30:11'),(61,1,'KITCHEN_STATUS_UPDATE','kitchen',12,NULL,'{\"status\": \"ready\"}','::1','Mozilla/5.0 (iPad; CPU OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.5 Mobile/15E148 Safari/604.1','2026-08-26 04:30:12'),(62,1,'KITCHEN_STATUS_UPDATE','kitchen',12,NULL,'{\"status\": \"served\"}','::1','Mozilla/5.0 (iPad; CPU OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.5 Mobile/15E148 Safari/604.1','2026-08-26 04:30:13'),(63,1,'LOGIN','auth',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 11:10:18'),(64,1,'LOGOUT','auth',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 11:10:31'),(65,2,'LOGIN','auth',2,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 11:10:47'),(66,2,'LOGOUT','auth',2,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 11:12:17'),(67,3,'LOGIN','auth',3,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 11:12:26'),(68,3,'LOGOUT','auth',3,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 11:12:38'),(69,4,'LOGIN','auth',4,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 11:12:43'),(70,4,'LOGOUT','auth',4,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 11:13:54'),(71,1,'LOGIN','auth',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 11:14:17'),(72,2,'LOGIN','auth',2,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 16:42:04'),(73,2,'LOGOUT','auth',2,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 16:44:42'),(74,1,'LOGIN','auth',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 16:44:50'),(75,1,'CREATE_TABLE','tables',24,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 16:45:33'),(76,1,'CREATE_RESERVATION','reservations',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 16:46:57'),(77,1,'CREATE_ORDER','orders',16,NULL,'{\"total\": 170200, \"order_number\": \"KOI-20260826-0016\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 16:56:35'),(78,1,'PAYMENT','payments',16,NULL,'{\"amount\": 200000, \"method\": \"cash\", \"order_number\": \"KOI-20260826-0016\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 16:56:47'),(79,1,'CREATE_MENU','menus',56,NULL,'{\"sku\": \"B-011\", \"name\": \"Bubur\", \"price\": \"5000\", \"_token\": \"2de76aaceba1dd8e37442b73e138552b44160a4beccf09ca7561e3abf9cd52d3\", \"cost_price\": \"3000\", \"sort_order\": \"1\", \"category_id\": \"8\", \"description\": \"Bubur\", \"is_available\": \"1\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:15:42'),(80,1,'CREATE_ORDER','orders',17,NULL,'{\"total\": 55200, \"order_number\": \"KOI-20260827-0001\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:16:23'),(81,1,'KITCHEN_STATUS_UPDATE','kitchen',44,NULL,'{\"status\": \"preparing\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:19:16'),(82,1,'KITCHEN_STATUS_UPDATE','kitchen',45,NULL,'{\"status\": \"preparing\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:19:17'),(83,1,'KITCHEN_STATUS_UPDATE','kitchen',46,NULL,'{\"status\": \"preparing\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:19:19'),(84,1,'KITCHEN_STATUS_UPDATE','kitchen',44,NULL,'{\"status\": \"ready\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:19:21'),(85,1,'KITCHEN_STATUS_UPDATE','kitchen',45,NULL,'{\"status\": \"ready\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:19:23'),(86,1,'KITCHEN_STATUS_UPDATE','kitchen',46,NULL,'{\"status\": \"ready\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:19:24'),(87,1,'KITCHEN_STATUS_UPDATE','kitchen',44,NULL,'{\"status\": \"served\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:19:27'),(88,1,'KITCHEN_STATUS_UPDATE','kitchen',45,NULL,'{\"status\": \"served\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:19:28'),(89,1,'KITCHEN_STATUS_UPDATE','kitchen',46,NULL,'{\"status\": \"served\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:19:29'),(90,1,'CREATE_ORDER','orders',18,NULL,'{\"total\": 55200, \"order_number\": \"KOI-20260827-0002\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:26:06'),(91,1,'PAYMENT','payments',18,NULL,'{\"amount\": 100000, \"method\": \"cash\", \"order_number\": \"KOI-20260827-0002\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:26:13'),(92,1,'KITCHEN_STATUS_UPDATE','kitchen',47,NULL,'{\"status\": \"preparing\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:26:31'),(93,1,'KITCHEN_STATUS_UPDATE','kitchen',48,NULL,'{\"status\": \"preparing\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:26:32'),(94,1,'KITCHEN_STATUS_UPDATE','kitchen',49,NULL,'{\"status\": \"preparing\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:26:33'),(95,1,'KITCHEN_STATUS_UPDATE','kitchen',47,NULL,'{\"status\": \"ready\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:26:35'),(96,1,'KITCHEN_STATUS_UPDATE','kitchen',48,NULL,'{\"status\": \"ready\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:26:37'),(97,1,'KITCHEN_STATUS_UPDATE','kitchen',49,NULL,'{\"status\": \"ready\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:26:38'),(98,1,'KITCHEN_STATUS_UPDATE','kitchen',47,NULL,'{\"status\": \"served\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:26:42'),(99,1,'KITCHEN_STATUS_UPDATE','kitchen',48,NULL,'{\"status\": \"served\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:26:43'),(100,1,'KITCHEN_STATUS_UPDATE','kitchen',49,NULL,'{\"status\": \"served\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:26:44'),(101,1,'CREATE_ORDER','orders',19,NULL,'{\"total\": 155250, \"order_number\": \"KOI-20260827-0003\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:41:36'),(102,1,'CREATE_ORDER','orders',20,NULL,'{\"total\": 120750, \"order_number\": \"KOI-20260827-0004\"}','::1','Mozilla/5.0 (Linux; Android 15; Pixel 9) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Mobile Safari/537.36','2026-08-26 17:54:59'),(103,1,'PAYMENT','payments',20,NULL,'{\"amount\": 150000, \"method\": \"cash\", \"order_number\": \"KOI-20260827-0004\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:58:58'),(104,1,'PAYMENT','payments',19,NULL,'{\"amount\": 155250, \"method\": \"qris\", \"order_number\": \"KOI-20260827-0003\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-26 17:59:36'),(105,2,'LOGIN','auth',2,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-28 03:44:51'),(106,2,'CREATE_ORDER','orders',21,NULL,'{\"total\": 276000, \"order_number\": \"KOI-20260828-0001\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-28 03:45:45'),(107,2,'LOGOUT','auth',2,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-28 03:45:52'),(108,4,'LOGIN','auth',4,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-28 03:46:01'),(109,4,'LOGOUT','auth',4,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-28 03:46:09'),(110,3,'LOGIN','auth',3,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-28 03:46:17'),(111,3,'LOGOUT','auth',3,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-28 03:46:22'),(112,1,'LOGIN','auth',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-28 03:46:27'),(113,1,'CREATE_ORDER','orders',22,NULL,'{\"total\": 155250, \"order_number\": \"KOI-20260828-0002\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-28 03:47:21'),(114,1,'CREATE_ORDER','orders',23,NULL,'{\"total\": 212750, \"order_number\": \"KOI-20260828-0003\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-28 04:09:22'),(115,1,'CREATE_ORDER','orders',24,NULL,'{\"total\": 17250, \"order_number\": \"KOI-20260828-0004\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-28 04:20:53'),(116,1,'LOGIN','auth',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-28 06:38:33'),(117,1,'PAYMENT','payments',24,NULL,'{\"amount\": 20000, \"method\": \"cash\", \"order_number\": \"KOI-20260828-0004\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-28 06:42:16'),(118,1,'LOGIN','auth',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-28 15:36:06'),(119,1,'PAYMENT','payments',23,NULL,'{\"amount\": 212750, \"method\": \"cash\", \"order_number\": \"KOI-20260828-0003\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-28 15:49:20'),(120,1,'PAYMENT','payments',22,NULL,'{\"amount\": 155250, \"method\": \"cash\", \"order_number\": \"KOI-20260828-0002\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-28 15:49:31'),(121,1,'PAYMENT','payments',21,NULL,'{\"amount\": 276000, \"method\": \"cash\", \"order_number\": \"KOI-20260828-0001\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-28 15:49:36'),(122,1,'LOGOUT','auth',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-28 16:01:31'),(123,3,'LOGIN','auth',3,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-28 16:01:37'),(124,2,'LOGIN','auth',2,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-29 11:32:59'),(125,2,'CREATE_ORDER','orders',25,NULL,'{\"total\": 99750, \"discount\": 9500, \"order_number\": \"KOI-20260829-0001\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-29 11:34:49'),(126,2,'LOGOUT','auth',2,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-29 11:35:11'),(127,1,'LOGIN','auth',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-29 11:35:17'),(128,1,'UPDATE_RESERVATION_STATUS','reservations',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-29 11:35:44'),(129,1,'CREATE_ORDER','orders',26,NULL,'{\"total\": 40250, \"discount\": 0, \"order_number\": \"KOI-20260829-0002\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-29 11:36:24'),(130,1,'UPDATE_RESERVATION_STATUS','reservations',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-29 11:36:47'),(131,1,'PAYMENT','payments',26,NULL,'{\"amount\": 40250, \"method\": \"cash\", \"order_number\": \"KOI-20260829-0002\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-29 11:37:37'),(132,1,'PAYMENT','payments',25,NULL,'{\"amount\": 99750, \"method\": \"qris\", \"order_number\": \"KOI-20260829-0001\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-29 11:37:59'),(133,1,'CREATE_ORDER','orders',27,NULL,'{\"total\": 74750, \"discount\": 0, \"order_number\": \"KOI-20260829-0003\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-29 12:05:48'),(134,1,'LOGIN','auth',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36','2026-09-05 08:39:18'),(135,1,'CREATE_ORDER','orders',29,NULL,'{\"total\": 74750, \"discount\": 0, \"order_number\": \"KOI-20260905-0001\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36','2026-09-05 08:40:14'),(136,1,'PAYMENT','payments',29,NULL,'{\"amount\": 74750, \"method\": \"qris\", \"order_number\": \"KOI-20260905-0001\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36','2026-09-05 08:41:34'),(137,1,'CREATE_ORDER','orders',33,NULL,'{\"total\": 103500, \"is_merge\": false, \"order_number\": \"KOI-20260905-0002\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36','2026-09-05 09:14:35'),(138,1,'CUSTOMER_ORDER','orders',33,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36','2026-09-05 09:16:11'),(139,1,'PAYMENT','payments',33,NULL,'{\"amount\": 200000, \"method\": \"cash\", \"order_number\": \"KOI-20260905-0002\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36','2026-09-05 09:17:40'),(140,1,'LOGIN','auth',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36','2026-09-05 12:09:11'),(141,1,'CUSTOMER_ORDER','orders',34,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36','2026-09-05 12:18:45'),(142,1,'PAYMENT','payments',34,NULL,'{\"amount\": 233450, \"method\": \"cash\", \"order_number\": \"TBL-20260905-0003\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36','2026-09-05 12:25:35'),(143,1,'LOGOUT','auth',1,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36','2026-09-05 12:40:13'),(144,2,'LOGIN','auth',2,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36','2026-09-05 12:40:23'),(145,2,'CREATE_ORDER','orders',35,NULL,'{\"total\": 126500, \"is_merge\": false, \"order_number\": \"KOI-20260905-0004\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36','2026-09-05 12:41:30'),(146,2,'PAYMENT','payments',35,NULL,'{\"amount\": 150000, \"method\": \"cash\", \"order_number\": \"KOI-20260905-0004\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36','2026-09-05 12:42:22'),(147,2,'LOGOUT','auth',2,NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36','2026-09-05 12:54:54'); /*!40000 ALTER TABLE `audit_logs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cash_sessions` -- DROP TABLE IF EXISTS `cash_sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cash_sessions` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL, `opened_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `closed_at` timestamp NULL DEFAULT NULL, `opening_cash` decimal(14,2) DEFAULT '0.00', `closing_cash` decimal(14,2) DEFAULT NULL, `expected_cash` decimal(14,2) DEFAULT NULL, `variance` decimal(14,2) DEFAULT NULL, `status` enum('open','closed') COLLATE utf8mb4_unicode_ci DEFAULT 'open', `notes` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), CONSTRAINT `cash_sessions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cash_sessions` -- LOCK TABLES `cash_sessions` WRITE; /*!40000 ALTER TABLE `cash_sessions` DISABLE KEYS */; /*!40000 ALTER TABLE `cash_sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customers` -- DROP TABLE IF EXISTS `customers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `customers` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `notes` text COLLATE utf8mb4_unicode_ci, `total_orders` int DEFAULT '0', `total_spending` decimal(14,2) DEFAULT '0.00', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customers` -- LOCK TABLES `customers` WRITE; /*!40000 ALTER TABLE `customers` DISABLE KEYS */; INSERT INTO `customers` VALUES (1,'Keluarga Wibowo','0812-9999-1111',NULL,'Pelanggan rutin, suka duduk area kolam koi',0,0.00,'2026-08-25 16:55:22','2026-08-25 16:55:22',NULL),(2,'Rombongan Anak SMAN 1 Klaten','0813-8888-2222',NULL,'Biasa datang Sabtu sore',0,0.00,'2026-08-25 16:55:22','2026-08-25 16:55:22',NULL),(3,'Pak Joko','0814-7777-3333',NULL,'Suka ikan bakar',0,0.00,'2026-08-25 16:55:22','2026-08-25 16:55:22',NULL),(4,'Bu Rina','0815-6666-4444',NULL,'Hobi memesan dessert',0,0.00,'2026-08-25 16:55:22','2026-08-25 16:55:22',NULL),(5,'Kantor Dinas Pendidikan','0816-5555-5555',NULL,'Order untuk acara kantor',0,0.00,'2026-08-25 16:55:22','2026-08-25 16:55:22',NULL),(6,'Keluarga Wibowo','0812-9999-1111',NULL,'Pelanggan rutin, suka duduk area kolam koi',0,0.00,'2026-08-25 16:59:26','2026-08-25 16:59:26',NULL),(7,'Rombongan Anak SMAN 1 Klaten','0813-8888-2222',NULL,'Biasa datang Sabtu sore',0,0.00,'2026-08-25 16:59:26','2026-08-25 16:59:26',NULL),(8,'Pak Joko','0814-7777-3333',NULL,'Suka ikan bakar',0,0.00,'2026-08-25 16:59:26','2026-08-25 16:59:26',NULL),(9,'Bu Rina','0815-6666-4444',NULL,'Hobi memesan dessert',0,0.00,'2026-08-25 16:59:26','2026-08-25 16:59:26',NULL),(10,'Kantor Dinas Pendidikan','0816-5555-5555',NULL,'Order untuk acara kantor',0,0.00,'2026-08-25 16:59:26','2026-08-25 16:59:26',NULL),(11,'Keluarga Wibowo','0812-9999-1111',NULL,'Pelanggan rutin, suka duduk area kolam koi',0,0.00,'2026-08-25 17:11:55','2026-08-25 17:11:55',NULL),(12,'Rombongan Anak SMAN 1 Klaten','0813-8888-2222',NULL,'Biasa datang Sabtu sore',0,0.00,'2026-08-25 17:11:55','2026-08-25 17:11:55',NULL),(13,'Pak Joko','0814-7777-3333',NULL,'Suka ikan bakar',0,0.00,'2026-08-25 17:11:55','2026-08-25 17:11:55',NULL),(14,'Bu Rina','0815-6666-4444',NULL,'Hobi memesan dessert',0,0.00,'2026-08-25 17:11:55','2026-08-25 17:11:55',NULL),(15,'Kantor Dinas Pendidikan','0816-5555-5555',NULL,'Order untuk acara kantor',0,0.00,'2026-08-25 17:11:55','2026-08-25 17:11:55',NULL),(16,'ahsan',NULL,NULL,NULL,16,2472200.00,'2026-08-26 03:45:02','2026-09-05 12:42:22',NULL),(17,'ex',NULL,NULL,NULL,1,103500.00,'2026-08-26 04:27:46','2026-08-26 04:27:50',NULL),(18,'mimi',NULL,NULL,NULL,1,149500.00,'2026-08-26 04:28:56','2026-08-26 04:29:08',NULL),(19,'xixixi','08899071726',NULL,NULL,0,0.00,'2026-08-26 16:46:56','2026-08-26 16:46:56',NULL),(20,'lulu',NULL,NULL,NULL,1,170200.00,'2026-08-26 16:56:35','2026-08-26 16:56:47',NULL),(21,'Edy',NULL,NULL,NULL,1,212750.00,'2026-08-26 17:16:23','2026-08-28 15:49:20',NULL),(22,'inu',NULL,NULL,NULL,1,55200.00,'2026-08-26 17:26:06','2026-08-26 17:26:13',NULL),(23,'ga',NULL,NULL,NULL,1,155250.00,'2026-08-26 17:41:36','2026-08-26 17:59:36',NULL),(24,'li',NULL,NULL,NULL,1,120750.00,'2026-08-26 17:54:59','2026-08-26 17:58:58',NULL),(25,'aku',NULL,NULL,NULL,1,155250.00,'2026-08-28 03:47:21','2026-08-28 15:49:31',NULL),(26,'iki',NULL,NULL,NULL,1,40250.00,'2026-08-29 11:36:24','2026-08-29 11:37:37',NULL); /*!40000 ALTER TABLE `customers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `employees` -- DROP TABLE IF EXISTS `employees`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `employees` ( `id` int NOT NULL AUTO_INCREMENT, `employee_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` text COLLATE utf8mb4_unicode_ci, `position` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `join_date` date NOT NULL, `status` enum('active','inactive','resigned') COLLATE utf8mb4_unicode_ci DEFAULT 'active', `basic_salary` decimal(14,2) DEFAULT '0.00', `salary_type` enum('monthly','weekly','daily') COLLATE utf8mb4_unicode_ci DEFAULT 'monthly', `bank_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bank_account` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bank_account_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `notes` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `employee_code` (`employee_code`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `employees` -- LOCK TABLES `employees` WRITE; /*!40000 ALTER TABLE `employees` DISABLE KEYS */; INSERT INTO `employees` VALUES (1,'EMP-001','Andi Pratama',NULL,'0812-1111-2222',NULL,'Kasir','2025-01-15','active',3500000.00,'monthly',NULL,NULL,NULL,NULL,'2026-08-25 16:55:22','2026-08-25 16:55:22',NULL),(2,'EMP-002','Siti Rahayu',NULL,'0813-2222-3333',NULL,'Koki','2025-01-15','active',4000000.00,'monthly',NULL,NULL,NULL,NULL,'2026-08-25 16:55:22','2026-08-25 16:55:22',NULL),(3,'EMP-003','Budi Santoso',NULL,'0814-3333-4444',NULL,'Waiter','2025-02-01','active',3000000.00,'monthly',NULL,NULL,NULL,NULL,'2026-08-25 16:55:22','2026-08-25 16:55:22',NULL),(4,'EMP-004','Dewi Lestari',NULL,'0815-4444-5555',NULL,'Koki','2025-03-01','active',3800000.00,'monthly',NULL,NULL,NULL,NULL,'2026-08-25 16:55:22','2026-08-25 16:55:22',NULL),(5,'EMP-005','Eko Prasetyo',NULL,'0816-5555-6666',NULL,'Admin Gudang','2025-01-15','active',3500000.00,'monthly',NULL,NULL,NULL,NULL,'2026-08-25 16:55:22','2026-08-25 16:55:22',NULL); /*!40000 ALTER TABLE `employees` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `expense_categories` -- DROP TABLE IF EXISTS `expense_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `expense_categories` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `is_active` tinyint(1) DEFAULT '1', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `expense_categories` -- LOCK TABLES `expense_categories` WRITE; /*!40000 ALTER TABLE `expense_categories` DISABLE KEYS */; INSERT INTO `expense_categories` VALUES (1,'Listrik','Biaya listrik bulanan',1,'2026-08-25 16:55:22'),(2,'Air','Biaya air bersih',1,'2026-08-25 16:55:22'),(3,'Gas','Gas memasak',1,'2026-08-25 16:55:22'),(4,'Internet','Biaya internet',1,'2026-08-25 16:55:22'),(5,'Maintenance','Perbaikan peralatan',1,'2026-08-25 16:55:22'),(6,'Transportasi','Biaya transportasi',1,'2026-08-25 16:55:22'),(7,'Kebersihan','Alat kebersihan',1,'2026-08-25 16:55:22'),(8,'Marketing','Biaya promosi',1,'2026-08-25 16:55:22'),(9,'Perlengkapan','Perlengkapan restoran',1,'2026-08-25 16:55:22'),(10,'Lainnya','Pengeluaran lainnya',1,'2026-08-25 16:55:22'),(11,'Listrik','Biaya listrik bulanan',1,'2026-08-25 16:59:26'),(12,'Air','Biaya air bersih',1,'2026-08-25 16:59:26'),(13,'Gas','Gas memasak',1,'2026-08-25 16:59:26'),(14,'Internet','Biaya internet',1,'2026-08-25 16:59:26'),(15,'Maintenance','Perbaikan peralatan',1,'2026-08-25 16:59:26'),(16,'Transportasi','Biaya transportasi',1,'2026-08-25 16:59:26'),(17,'Kebersihan','Alat kebersihan',1,'2026-08-25 16:59:26'),(18,'Marketing','Biaya promosi',1,'2026-08-25 16:59:26'),(19,'Perlengkapan','Perlengkapan restoran',1,'2026-08-25 16:59:26'),(20,'Lainnya','Pengeluaran lainnya',1,'2026-08-25 16:59:26'),(21,'Listrik','Biaya listrik bulanan',1,'2026-08-25 17:11:55'),(22,'Air','Biaya air bersih',1,'2026-08-25 17:11:55'),(23,'Gas','Gas memasak',1,'2026-08-25 17:11:55'),(24,'Internet','Biaya internet',1,'2026-08-25 17:11:55'),(25,'Maintenance','Perbaikan peralatan',1,'2026-08-25 17:11:55'),(26,'Transportasi','Biaya transportasi',1,'2026-08-25 17:11:55'),(27,'Kebersihan','Alat kebersihan',1,'2026-08-25 17:11:55'),(28,'Marketing','Biaya promosi',1,'2026-08-25 17:11:55'),(29,'Perlengkapan','Perlengkapan restoran',1,'2026-08-25 17:11:55'),(30,'Lainnya','Pengeluaran lainnya',1,'2026-08-25 17:11:55'); /*!40000 ALTER TABLE `expense_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `expenses` -- DROP TABLE IF EXISTS `expenses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `expenses` ( `id` int NOT NULL AUTO_INCREMENT, `expense_number` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `category_id` int NOT NULL, `amount` decimal(14,2) NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `expense_date` date NOT NULL, `receipt_photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `payment_method` enum('cash','bank_transfer','qris') COLLATE utf8mb4_unicode_ci DEFAULT 'cash', `status` enum('pending','approved','rejected') COLLATE utf8mb4_unicode_ci DEFAULT 'pending', `user_id` int NOT NULL, `approved_by` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `expense_number` (`expense_number`), KEY `category_id` (`category_id`), KEY `user_id` (`user_id`), KEY `approved_by` (`approved_by`), CONSTRAINT `expenses_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `expense_categories` (`id`), CONSTRAINT `expenses_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`), CONSTRAINT `expenses_ibfk_3` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `expenses` -- LOCK TABLES `expenses` WRITE; /*!40000 ALTER TABLE `expenses` DISABLE KEYS */; /*!40000 ALTER TABLE `expenses` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `goods_receipts` -- DROP TABLE IF EXISTS `goods_receipts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `goods_receipts` ( `id` int NOT NULL AUTO_INCREMENT, `receipt_number` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `po_id` int NOT NULL, `received_date` date NOT NULL, `notes` text COLLATE utf8mb4_unicode_ci, `received_by` int NOT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `receipt_number` (`receipt_number`), KEY `po_id` (`po_id`), KEY `received_by` (`received_by`), CONSTRAINT `goods_receipts_ibfk_1` FOREIGN KEY (`po_id`) REFERENCES `purchase_orders` (`id`), CONSTRAINT `goods_receipts_ibfk_2` FOREIGN KEY (`received_by`) REFERENCES `users` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `goods_receipts` -- LOCK TABLES `goods_receipts` WRITE; /*!40000 ALTER TABLE `goods_receipts` DISABLE KEYS */; /*!40000 ALTER TABLE `goods_receipts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ingredient_categories` -- DROP TABLE IF EXISTS `ingredient_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ingredient_categories` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ingredient_categories` -- LOCK TABLES `ingredient_categories` WRITE; /*!40000 ALTER TABLE `ingredient_categories` DISABLE KEYS */; INSERT INTO `ingredient_categories` VALUES (1,'Ikan & Seafood','Bahan laut','2026-08-25 16:55:21',NULL),(2,'Daging','Daging sapi, ayam, dll','2026-08-25 16:55:21',NULL),(3,'Sayuran','Sayuran segar','2026-08-25 16:55:21',NULL),(4,'Bumbu & Rempah','Bumbu masak','2026-08-25 16:55:21',NULL),(5,'Minyak & Saus','Minyak goreng dan saus','2026-08-25 16:55:21',NULL),(6,'Tepung & Tepung','Tepung terigu, maizena','2026-08-25 16:55:21',NULL),(7,'Minuman','Bahan minuman','2026-08-25 16:55:21',NULL),(8,'Susu & Dairy','Susu, keju, mentega','2026-08-25 16:55:21',NULL),(9,'Roti & Pastry','Bahan roti','2026-08-25 16:55:21',NULL),(10,'Lainnya','Bahan lainnya','2026-08-25 16:55:21',NULL),(11,'Ikan & Seafood','Bahan laut','2026-08-25 16:59:26',NULL),(12,'Daging','Daging sapi, ayam, dll','2026-08-25 16:59:26',NULL),(13,'Sayuran','Sayuran segar','2026-08-25 16:59:26',NULL),(14,'Bumbu & Rempah','Bumbu masak','2026-08-25 16:59:26',NULL),(15,'Minyak & Saus','Minyak goreng dan saus','2026-08-25 16:59:26',NULL),(16,'Tepung & Tepung','Tepung terigu, maizena','2026-08-25 16:59:26',NULL),(17,'Minuman','Bahan minuman','2026-08-25 16:59:26',NULL),(18,'Susu & Dairy','Susu, keju, mentega','2026-08-25 16:59:26',NULL),(19,'Roti & Pastry','Bahan roti','2026-08-25 16:59:26',NULL),(20,'Lainnya','Bahan lainnya','2026-08-25 16:59:26',NULL),(21,'Ikan & Seafood','Bahan laut','2026-08-25 17:11:55',NULL),(22,'Daging','Daging sapi, ayam, dll','2026-08-25 17:11:55',NULL),(23,'Sayuran','Sayuran segar','2026-08-25 17:11:55',NULL),(24,'Bumbu & Rempah','Bumbu masak','2026-08-25 17:11:55',NULL),(25,'Minyak & Saus','Minyak goreng dan saus','2026-08-25 17:11:55',NULL),(26,'Tepung & Tepung','Tepung terigu, maizena','2026-08-25 17:11:55',NULL),(27,'Minuman','Bahan minuman','2026-08-25 17:11:55',NULL),(28,'Susu & Dairy','Susu, keju, mentega','2026-08-25 17:11:55',NULL),(29,'Roti & Pastry','Bahan roti','2026-08-25 17:11:55',NULL),(30,'Lainnya','Bahan lainnya','2026-08-25 17:11:55',NULL); /*!40000 ALTER TABLE `ingredient_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ingredients` -- DROP TABLE IF EXISTS `ingredients`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ingredients` ( `id` int NOT NULL AUTO_INCREMENT, `code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `category_id` int DEFAULT NULL, `unit_id` int NOT NULL, `supplier_id` int DEFAULT NULL, `purchase_price` decimal(12,2) DEFAULT '0.00', `minimum_stock` decimal(10,2) DEFAULT '0.00', `maximum_stock` decimal(10,2) DEFAULT '0.00', `current_stock` decimal(10,2) DEFAULT '0.00', `warehouse_location` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `expiry_date` date DEFAULT NULL, `is_active` tinyint(1) DEFAULT '1', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `code` (`code`), KEY `category_id` (`category_id`), KEY `unit_id` (`unit_id`), CONSTRAINT `ingredients_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `ingredient_categories` (`id`), CONSTRAINT `ingredients_ibfk_2` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ingredients` -- LOCK TABLES `ingredients` WRITE; /*!40000 ALTER TABLE `ingredients` DISABLE KEYS */; INSERT INTO `ingredients` VALUES (1,'ING-001','Ikan Mas',1,1,NULL,35000.00,5.00,50.00,11.50,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-26 17:59:36',NULL),(2,'ING-002','Ikan Mackerel',1,1,NULL,45000.00,3.00,30.00,15.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(3,'ING-003','Udang',1,1,NULL,80000.00,2.00,20.00,10.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(4,'ING-004','Cumi',1,1,NULL,70000.00,2.00,15.00,8.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(5,'ING-005','Ayam Utuh',2,1,NULL,32000.00,5.00,40.00,20.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(6,'ING-006','Daging Sapi',2,1,NULL,120000.00,3.00,20.00,10.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(7,'ING-007','Iga Sapi',2,1,NULL,150000.00,2.00,15.00,8.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(8,'ING-008','Telur',2,5,NULL,25000.00,30.00,200.00,90.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-09-05 12:25:35',NULL),(9,'ING-009','Nasi',10,1,NULL,12000.00,10.00,100.00,47.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-09-05 12:25:35',NULL),(10,'ING-010','Mie',10,7,NULL,8000.00,10.00,100.00,40.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(11,'ING-011','Bawang Merah',3,1,NULL,25000.00,2.00,20.00,8.95,NULL,NULL,1,'2026-08-25 16:55:21','2026-09-05 12:25:35',NULL),(12,'ING-012','Bawang Putih',3,1,NULL,30000.00,2.00,20.00,9.39,NULL,NULL,1,'2026-08-25 16:55:21','2026-09-05 12:25:35',NULL),(13,'ING-013','Cabai Merah',3,1,NULL,40000.00,1.00,15.00,7.56,NULL,NULL,1,'2026-08-25 16:55:21','2026-09-05 12:25:35',NULL),(14,'ING-014','Tomat',3,1,NULL,15000.00,2.00,20.00,10.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(15,'ING-015','Selada',3,5,NULL,5000.00,10.00,50.00,25.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(16,'ING-016','Kentang',3,1,NULL,12000.00,5.00,30.00,15.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(17,'ING-017','Minyak Goreng',5,3,NULL,18000.00,5.00,30.00,14.55,NULL,NULL,1,'2026-08-25 16:55:21','2026-09-05 12:25:35',NULL),(18,'ING-018','Kecap Manis',5,8,NULL,15000.00,5.00,20.00,9.73,NULL,NULL,1,'2026-08-25 16:55:21','2026-09-05 12:25:35',NULL),(19,'ING-019','Saus Tiram',5,8,NULL,12000.00,3.00,15.00,8.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(20,'ING-020','Garam',4,1,NULL,5000.00,2.00,10.00,5.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(21,'ING-021','Gula',4,1,NULL,12000.00,3.00,15.00,8.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(22,'ING-022','Merica',4,2,NULL,50000.00,0.50,3.00,1.50,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(23,'ING-023','Tepung Terigu',6,1,NULL,10000.00,5.00,30.00,15.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(24,'ING-024','Tepung Maizena',6,1,NULL,15000.00,2.00,15.00,8.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(25,'ING-025','Teh',7,7,NULL,25000.00,5.00,20.00,10.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(26,'ING-026','Gula Pasir',4,1,NULL,14000.00,5.00,30.00,15.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(27,'ING-027','Susu Segar',8,8,NULL,18000.00,5.00,20.00,10.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(28,'ING-028','Mentega',8,1,NULL,28000.00,2.00,10.00,5.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(29,'ING-029','Keju',8,1,NULL,60000.00,1.00,5.00,3.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(30,'ING-030','Roti Tawar',9,6,NULL,15000.00,3.00,15.00,8.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(31,'ING-031','Alpukat',3,5,NULL,8000.00,5.00,30.00,15.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(32,'ING-032','Mangga',3,5,NULL,10000.00,5.00,30.00,15.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(33,'ING-033','Jeruk',3,5,NULL,6000.00,10.00,50.00,30.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(34,'ING-034','Kopi Bubuk',7,7,NULL,80000.00,1.00,5.00,3.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(35,'ING-035','Susu Kental Manis',8,8,NULL,12000.00,5.00,20.00,10.00,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL); /*!40000 ALTER TABLE `ingredients` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `inventory_movements` -- DROP TABLE IF EXISTS `inventory_movements`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `inventory_movements` ( `id` int NOT NULL AUTO_INCREMENT, `ingredient_id` int NOT NULL, `warehouse_id` int DEFAULT '1', `type` enum('purchase','usage','waste','adjustment','opname','transfer_in','transfer_out') COLLATE utf8mb4_unicode_ci NOT NULL, `reference_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reference_id` int DEFAULT NULL, `quantity_in` decimal(10,2) DEFAULT '0.00', `quantity_out` decimal(10,2) DEFAULT '0.00', `balance_after` decimal(10,2) NOT NULL, `unit_cost` decimal(12,2) DEFAULT '0.00', `notes` text COLLATE utf8mb4_unicode_ci, `user_id` int NOT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `ingredient_id` (`ingredient_id`), KEY `warehouse_id` (`warehouse_id`), KEY `user_id` (`user_id`), CONSTRAINT `inventory_movements_ibfk_1` FOREIGN KEY (`ingredient_id`) REFERENCES `ingredients` (`id`), CONSTRAINT `inventory_movements_ibfk_2` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`), CONSTRAINT `inventory_movements_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=406 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `inventory_movements` -- LOCK TABLES `inventory_movements` WRITE; /*!40000 ALTER TABLE `inventory_movements` DISABLE KEYS */; INSERT INTO `inventory_movements` VALUES (1,1,1,'usage','order',1,0.00,0.50,19.50,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:45:24'),(2,11,1,'usage','order',1,0.00,0.05,9.95,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:45:24'),(3,12,1,'usage','order',1,0.00,0.03,9.97,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:45:24'),(4,13,1,'usage','order',1,0.00,0.02,7.98,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:45:24'),(5,17,1,'usage','order',1,0.00,0.02,14.98,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:45:24'),(6,18,1,'usage','order',1,0.00,0.01,9.99,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:45:24'),(7,1,1,'usage','order',1,0.00,0.50,19.50,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:45:24'),(8,11,1,'usage','order',1,0.00,0.05,9.95,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:45:24'),(9,12,1,'usage','order',1,0.00,0.03,9.97,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:45:24'),(10,13,1,'usage','order',1,0.00,0.02,7.98,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:45:24'),(11,17,1,'usage','order',1,0.00,0.02,14.98,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:45:24'),(12,18,1,'usage','order',1,0.00,0.01,9.99,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:45:24'),(13,1,1,'usage','order',1,0.00,0.50,19.50,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:45:24'),(14,11,1,'usage','order',1,0.00,0.05,9.95,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:45:24'),(15,12,1,'usage','order',1,0.00,0.03,9.97,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:45:24'),(16,13,1,'usage','order',1,0.00,0.02,7.98,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:45:24'),(17,17,1,'usage','order',1,0.00,0.02,14.98,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:45:24'),(18,18,1,'usage','order',1,0.00,0.01,9.99,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:45:24'),(19,9,1,'usage','order',1,0.00,0.30,49.70,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:45:24'),(20,8,1,'usage','order',1,0.00,1.00,99.00,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:45:24'),(21,11,1,'usage','order',1,0.00,0.02,9.93,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:45:24'),(22,12,1,'usage','order',1,0.00,0.01,9.96,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:45:24'),(23,13,1,'usage','order',1,0.00,0.01,7.97,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:45:24'),(24,17,1,'usage','order',1,0.00,0.02,14.97,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:45:24'),(25,18,1,'usage','order',1,0.00,0.01,9.98,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:45:24'),(26,9,1,'usage','order',1,0.00,0.30,49.70,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:45:24'),(27,8,1,'usage','order',1,0.00,1.00,99.00,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:45:24'),(28,11,1,'usage','order',1,0.00,0.02,9.93,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:45:24'),(29,12,1,'usage','order',1,0.00,0.01,9.96,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:45:24'),(30,13,1,'usage','order',1,0.00,0.01,7.97,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:45:24'),(31,17,1,'usage','order',1,0.00,0.02,14.97,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:45:24'),(32,18,1,'usage','order',1,0.00,0.01,9.98,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:45:24'),(33,9,1,'usage','order',1,0.00,0.30,49.70,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:45:24'),(34,8,1,'usage','order',1,0.00,1.00,99.00,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:45:24'),(35,11,1,'usage','order',1,0.00,0.02,9.93,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:45:24'),(36,12,1,'usage','order',1,0.00,0.01,9.96,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:45:24'),(37,13,1,'usage','order',1,0.00,0.01,7.97,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:45:24'),(38,17,1,'usage','order',1,0.00,0.02,14.97,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:45:24'),(39,18,1,'usage','order',1,0.00,0.01,9.98,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:45:24'),(40,1,1,'usage','order',2,0.00,0.50,19.00,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:47:07'),(41,11,1,'usage','order',2,0.00,0.05,9.88,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:47:07'),(42,12,1,'usage','order',2,0.00,0.03,9.93,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:47:07'),(43,13,1,'usage','order',2,0.00,0.02,7.95,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:47:07'),(44,17,1,'usage','order',2,0.00,0.02,14.95,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:47:07'),(45,18,1,'usage','order',2,0.00,0.01,9.97,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:47:07'),(46,1,1,'usage','order',2,0.00,0.50,19.00,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:47:07'),(47,11,1,'usage','order',2,0.00,0.05,9.88,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:47:07'),(48,12,1,'usage','order',2,0.00,0.03,9.93,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:47:07'),(49,13,1,'usage','order',2,0.00,0.02,7.95,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:47:07'),(50,17,1,'usage','order',2,0.00,0.02,14.95,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:47:07'),(51,18,1,'usage','order',2,0.00,0.01,9.97,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:47:07'),(52,1,1,'usage','order',2,0.00,0.50,19.00,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:47:07'),(53,11,1,'usage','order',2,0.00,0.05,9.88,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:47:07'),(54,12,1,'usage','order',2,0.00,0.03,9.93,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:47:07'),(55,13,1,'usage','order',2,0.00,0.02,7.95,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:47:07'),(56,17,1,'usage','order',2,0.00,0.02,14.95,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:47:07'),(57,18,1,'usage','order',2,0.00,0.01,9.97,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:47:07'),(58,9,1,'usage','order',2,0.00,0.30,49.40,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:47:07'),(59,8,1,'usage','order',2,0.00,1.00,98.00,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:47:07'),(60,11,1,'usage','order',2,0.00,0.02,9.86,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:47:07'),(61,12,1,'usage','order',2,0.00,0.01,9.92,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:47:07'),(62,13,1,'usage','order',2,0.00,0.01,7.94,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:47:07'),(63,17,1,'usage','order',2,0.00,0.02,14.94,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:47:07'),(64,18,1,'usage','order',2,0.00,0.01,9.96,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:47:07'),(65,9,1,'usage','order',2,0.00,0.30,49.40,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:47:07'),(66,8,1,'usage','order',2,0.00,1.00,98.00,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:47:07'),(67,11,1,'usage','order',2,0.00,0.02,9.86,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:47:07'),(68,12,1,'usage','order',2,0.00,0.01,9.92,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:47:07'),(69,13,1,'usage','order',2,0.00,0.01,7.94,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:47:07'),(70,17,1,'usage','order',2,0.00,0.02,14.94,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:47:07'),(71,18,1,'usage','order',2,0.00,0.01,9.96,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:47:07'),(72,9,1,'usage','order',2,0.00,0.30,49.40,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:47:07'),(73,8,1,'usage','order',2,0.00,1.00,98.00,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:47:07'),(74,11,1,'usage','order',2,0.00,0.02,9.86,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:47:07'),(75,12,1,'usage','order',2,0.00,0.01,9.92,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:47:07'),(76,13,1,'usage','order',2,0.00,0.01,7.94,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:47:07'),(77,17,1,'usage','order',2,0.00,0.02,14.94,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:47:07'),(78,18,1,'usage','order',2,0.00,0.01,9.96,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:47:07'),(79,1,1,'usage','order',3,0.00,0.50,18.50,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:03'),(80,11,1,'usage','order',3,0.00,0.05,9.81,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:03'),(81,12,1,'usage','order',3,0.00,0.03,9.89,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:03'),(82,13,1,'usage','order',3,0.00,0.02,7.92,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:03'),(83,17,1,'usage','order',3,0.00,0.02,14.92,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:03'),(84,18,1,'usage','order',3,0.00,0.01,9.95,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:03'),(85,1,1,'usage','order',3,0.00,0.50,18.50,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:03'),(86,11,1,'usage','order',3,0.00,0.05,9.81,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:03'),(87,12,1,'usage','order',3,0.00,0.03,9.89,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:03'),(88,13,1,'usage','order',3,0.00,0.02,7.92,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:03'),(89,17,1,'usage','order',3,0.00,0.02,14.92,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:03'),(90,18,1,'usage','order',3,0.00,0.01,9.95,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:03'),(91,1,1,'usage','order',3,0.00,0.50,18.50,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:03'),(92,11,1,'usage','order',3,0.00,0.05,9.81,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:03'),(93,12,1,'usage','order',3,0.00,0.03,9.89,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:03'),(94,13,1,'usage','order',3,0.00,0.02,7.92,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:03'),(95,17,1,'usage','order',3,0.00,0.02,14.92,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:03'),(96,18,1,'usage','order',3,0.00,0.01,9.95,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:03'),(97,9,1,'usage','order',3,0.00,0.30,49.10,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:03'),(98,8,1,'usage','order',3,0.00,1.00,97.00,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:03'),(99,11,1,'usage','order',3,0.00,0.02,9.79,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:03'),(100,12,1,'usage','order',3,0.00,0.01,9.88,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:03'),(101,13,1,'usage','order',3,0.00,0.01,7.91,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:03'),(102,17,1,'usage','order',3,0.00,0.02,14.91,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:03'),(103,18,1,'usage','order',3,0.00,0.01,9.94,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:03'),(104,9,1,'usage','order',3,0.00,0.30,49.10,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:03'),(105,8,1,'usage','order',3,0.00,1.00,97.00,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:03'),(106,11,1,'usage','order',3,0.00,0.02,9.79,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:03'),(107,12,1,'usage','order',3,0.00,0.01,9.88,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:03'),(108,13,1,'usage','order',3,0.00,0.01,7.91,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:03'),(109,17,1,'usage','order',3,0.00,0.02,14.91,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:03'),(110,18,1,'usage','order',3,0.00,0.01,9.94,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:03'),(111,9,1,'usage','order',3,0.00,0.30,49.10,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:03'),(112,8,1,'usage','order',3,0.00,1.00,97.00,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:03'),(113,11,1,'usage','order',3,0.00,0.02,9.79,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:03'),(114,12,1,'usage','order',3,0.00,0.01,9.88,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:03'),(115,13,1,'usage','order',3,0.00,0.01,7.91,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:03'),(116,17,1,'usage','order',3,0.00,0.02,14.91,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:03'),(117,18,1,'usage','order',3,0.00,0.01,9.94,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:03'),(118,1,1,'usage','order',5,0.00,0.50,18.00,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:21'),(119,11,1,'usage','order',5,0.00,0.05,9.74,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:21'),(120,12,1,'usage','order',5,0.00,0.03,9.85,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:21'),(121,13,1,'usage','order',5,0.00,0.02,7.89,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:21'),(122,17,1,'usage','order',5,0.00,0.02,14.89,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:21'),(123,18,1,'usage','order',5,0.00,0.01,9.93,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:21'),(124,1,1,'usage','order',5,0.00,0.50,18.00,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:21'),(125,11,1,'usage','order',5,0.00,0.05,9.74,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:21'),(126,12,1,'usage','order',5,0.00,0.03,9.85,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:21'),(127,13,1,'usage','order',5,0.00,0.02,7.89,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:21'),(128,17,1,'usage','order',5,0.00,0.02,14.89,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:21'),(129,18,1,'usage','order',5,0.00,0.01,9.93,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:21'),(130,1,1,'usage','order',5,0.00,0.50,18.00,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:21'),(131,11,1,'usage','order',5,0.00,0.05,9.74,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:21'),(132,12,1,'usage','order',5,0.00,0.03,9.85,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:21'),(133,13,1,'usage','order',5,0.00,0.02,7.89,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:21'),(134,17,1,'usage','order',5,0.00,0.02,14.89,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:21'),(135,18,1,'usage','order',5,0.00,0.01,9.93,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:21'),(136,9,1,'usage','order',5,0.00,0.30,48.80,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:21'),(137,8,1,'usage','order',5,0.00,1.00,96.00,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:21'),(138,11,1,'usage','order',5,0.00,0.02,9.72,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:21'),(139,12,1,'usage','order',5,0.00,0.01,9.84,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:21'),(140,13,1,'usage','order',5,0.00,0.01,7.88,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:21'),(141,17,1,'usage','order',5,0.00,0.02,14.88,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:21'),(142,18,1,'usage','order',5,0.00,0.01,9.92,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:21'),(143,9,1,'usage','order',5,0.00,0.30,48.80,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:21'),(144,8,1,'usage','order',5,0.00,1.00,96.00,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:21'),(145,11,1,'usage','order',5,0.00,0.02,9.72,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:21'),(146,12,1,'usage','order',5,0.00,0.01,9.84,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:21'),(147,13,1,'usage','order',5,0.00,0.01,7.88,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:21'),(148,17,1,'usage','order',5,0.00,0.02,14.88,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:21'),(149,18,1,'usage','order',5,0.00,0.01,9.92,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:21'),(150,9,1,'usage','order',5,0.00,0.30,48.80,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:21'),(151,8,1,'usage','order',5,0.00,1.00,96.00,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:21'),(152,11,1,'usage','order',5,0.00,0.02,9.72,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:21'),(153,12,1,'usage','order',5,0.00,0.01,9.84,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:21'),(154,13,1,'usage','order',5,0.00,0.01,7.88,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:21'),(155,17,1,'usage','order',5,0.00,0.02,14.88,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:21'),(156,18,1,'usage','order',5,0.00,0.01,9.92,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:21'),(157,1,1,'usage','order',6,0.00,0.50,17.50,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:38'),(158,11,1,'usage','order',6,0.00,0.05,9.67,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:38'),(159,12,1,'usage','order',6,0.00,0.03,9.81,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:38'),(160,13,1,'usage','order',6,0.00,0.02,7.86,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:38'),(161,17,1,'usage','order',6,0.00,0.02,14.86,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:38'),(162,18,1,'usage','order',6,0.00,0.01,9.91,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:38'),(163,1,1,'usage','order',6,0.00,0.50,17.50,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:38'),(164,11,1,'usage','order',6,0.00,0.05,9.67,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:38'),(165,12,1,'usage','order',6,0.00,0.03,9.81,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:38'),(166,13,1,'usage','order',6,0.00,0.02,7.86,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:38'),(167,17,1,'usage','order',6,0.00,0.02,14.86,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:38'),(168,18,1,'usage','order',6,0.00,0.01,9.91,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:38'),(169,1,1,'usage','order',6,0.00,0.50,17.50,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:38'),(170,11,1,'usage','order',6,0.00,0.05,9.67,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:38'),(171,12,1,'usage','order',6,0.00,0.03,9.81,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:38'),(172,13,1,'usage','order',6,0.00,0.02,7.86,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:38'),(173,17,1,'usage','order',6,0.00,0.02,14.86,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:38'),(174,18,1,'usage','order',6,0.00,0.01,9.91,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:38'),(175,9,1,'usage','order',6,0.00,0.30,48.50,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:38'),(176,8,1,'usage','order',6,0.00,1.00,95.00,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:38'),(177,11,1,'usage','order',6,0.00,0.02,9.65,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:38'),(178,12,1,'usage','order',6,0.00,0.01,9.80,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:38'),(179,13,1,'usage','order',6,0.00,0.01,7.85,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:38'),(180,17,1,'usage','order',6,0.00,0.02,14.85,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:38'),(181,18,1,'usage','order',6,0.00,0.01,9.90,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:38'),(182,9,1,'usage','order',6,0.00,0.30,48.50,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:38'),(183,8,1,'usage','order',6,0.00,1.00,95.00,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:38'),(184,11,1,'usage','order',6,0.00,0.02,9.65,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:38'),(185,12,1,'usage','order',6,0.00,0.01,9.80,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:38'),(186,13,1,'usage','order',6,0.00,0.01,7.85,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:38'),(187,17,1,'usage','order',6,0.00,0.02,14.85,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:38'),(188,18,1,'usage','order',6,0.00,0.01,9.90,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:38'),(189,9,1,'usage','order',6,0.00,0.30,48.50,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:38'),(190,8,1,'usage','order',6,0.00,1.00,95.00,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:38'),(191,11,1,'usage','order',6,0.00,0.02,9.65,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:38'),(192,12,1,'usage','order',6,0.00,0.01,9.80,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:38'),(193,13,1,'usage','order',6,0.00,0.01,7.85,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:38'),(194,17,1,'usage','order',6,0.00,0.02,14.85,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:38'),(195,18,1,'usage','order',6,0.00,0.01,9.90,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:38'),(196,1,1,'usage','order',7,0.00,0.50,17.00,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:46'),(197,11,1,'usage','order',7,0.00,0.05,9.60,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:46'),(198,12,1,'usage','order',7,0.00,0.03,9.77,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:46'),(199,13,1,'usage','order',7,0.00,0.02,7.83,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:46'),(200,17,1,'usage','order',7,0.00,0.02,14.83,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:46'),(201,18,1,'usage','order',7,0.00,0.01,9.89,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:46'),(202,1,1,'usage','order',7,0.00,0.50,17.00,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:46'),(203,11,1,'usage','order',7,0.00,0.05,9.60,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:46'),(204,12,1,'usage','order',7,0.00,0.03,9.77,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:46'),(205,13,1,'usage','order',7,0.00,0.02,7.83,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:46'),(206,17,1,'usage','order',7,0.00,0.02,14.83,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:46'),(207,18,1,'usage','order',7,0.00,0.01,9.89,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:46'),(208,1,1,'usage','order',7,0.00,0.50,17.00,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:46'),(209,11,1,'usage','order',7,0.00,0.05,9.60,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:46'),(210,12,1,'usage','order',7,0.00,0.03,9.77,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:46'),(211,13,1,'usage','order',7,0.00,0.02,7.83,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:46'),(212,17,1,'usage','order',7,0.00,0.02,14.83,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:46'),(213,18,1,'usage','order',7,0.00,0.01,9.89,0.00,'Penggunaan untuk Ikan Bakar x1',1,'2026-08-26 03:51:46'),(214,9,1,'usage','order',7,0.00,0.30,48.20,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:46'),(215,8,1,'usage','order',7,0.00,1.00,94.00,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:46'),(216,11,1,'usage','order',7,0.00,0.02,9.58,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:46'),(217,12,1,'usage','order',7,0.00,0.01,9.76,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:46'),(218,13,1,'usage','order',7,0.00,0.01,7.82,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:46'),(219,17,1,'usage','order',7,0.00,0.02,14.82,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:46'),(220,18,1,'usage','order',7,0.00,0.01,9.88,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:46'),(221,9,1,'usage','order',7,0.00,0.30,48.20,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:46'),(222,8,1,'usage','order',7,0.00,1.00,94.00,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:46'),(223,11,1,'usage','order',7,0.00,0.02,9.58,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:46'),(224,12,1,'usage','order',7,0.00,0.01,9.76,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:47'),(225,13,1,'usage','order',7,0.00,0.01,7.82,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:47'),(226,17,1,'usage','order',7,0.00,0.02,14.82,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:47'),(227,18,1,'usage','order',7,0.00,0.01,9.88,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:47'),(228,9,1,'usage','order',7,0.00,0.30,48.20,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:47'),(229,8,1,'usage','order',7,0.00,1.00,94.00,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:47'),(230,11,1,'usage','order',7,0.00,0.02,9.58,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:47'),(231,12,1,'usage','order',7,0.00,0.01,9.76,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:47'),(232,13,1,'usage','order',7,0.00,0.01,7.82,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:47'),(233,17,1,'usage','order',7,0.00,0.02,14.82,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:47'),(234,18,1,'usage','order',7,0.00,0.01,9.88,0.00,'Penggunaan untuk Nasi Goreng Spesial x1',1,'2026-08-26 03:51:47'),(235,1,1,'usage','order',9,0.00,1.00,16.00,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:52:32'),(236,11,1,'usage','order',9,0.00,0.10,9.48,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:52:32'),(237,12,1,'usage','order',9,0.00,0.06,9.70,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:52:32'),(238,13,1,'usage','order',9,0.00,0.04,7.78,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:52:32'),(239,17,1,'usage','order',9,0.00,0.04,14.78,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:52:32'),(240,18,1,'usage','order',9,0.00,0.02,9.86,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:52:32'),(241,1,1,'usage','order',9,0.00,1.00,16.00,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:52:32'),(242,11,1,'usage','order',9,0.00,0.10,9.48,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:52:32'),(243,12,1,'usage','order',9,0.00,0.06,9.70,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:52:32'),(244,13,1,'usage','order',9,0.00,0.04,7.78,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:52:32'),(245,17,1,'usage','order',9,0.00,0.04,14.78,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:52:32'),(246,18,1,'usage','order',9,0.00,0.02,9.86,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:52:32'),(247,1,1,'usage','order',9,0.00,1.00,16.00,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:52:32'),(248,11,1,'usage','order',9,0.00,0.10,9.48,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:52:32'),(249,12,1,'usage','order',9,0.00,0.06,9.70,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:52:32'),(250,13,1,'usage','order',9,0.00,0.04,7.78,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:52:32'),(251,17,1,'usage','order',9,0.00,0.04,14.78,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:52:32'),(252,18,1,'usage','order',9,0.00,0.02,9.86,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:52:32'),(253,1,1,'usage','order',10,0.00,1.00,15.00,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:08'),(254,11,1,'usage','order',10,0.00,0.10,9.38,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:08'),(255,12,1,'usage','order',10,0.00,0.06,9.64,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:08'),(256,13,1,'usage','order',10,0.00,0.04,7.74,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:08'),(257,17,1,'usage','order',10,0.00,0.04,14.74,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:08'),(258,18,1,'usage','order',10,0.00,0.02,9.84,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:08'),(259,1,1,'usage','order',10,0.00,1.00,15.00,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:08'),(260,11,1,'usage','order',10,0.00,0.10,9.38,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:08'),(261,12,1,'usage','order',10,0.00,0.06,9.64,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:08'),(262,13,1,'usage','order',10,0.00,0.04,7.74,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:08'),(263,17,1,'usage','order',10,0.00,0.04,14.74,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:08'),(264,18,1,'usage','order',10,0.00,0.02,9.84,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:08'),(265,1,1,'usage','order',10,0.00,1.00,15.00,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:08'),(266,11,1,'usage','order',10,0.00,0.10,9.38,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:08'),(267,12,1,'usage','order',10,0.00,0.06,9.64,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:08'),(268,13,1,'usage','order',10,0.00,0.04,7.74,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:08'),(269,17,1,'usage','order',10,0.00,0.04,14.74,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:08'),(270,18,1,'usage','order',10,0.00,0.02,9.84,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:08'),(271,1,1,'usage','order',11,0.00,1.00,14.00,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:17'),(272,11,1,'usage','order',11,0.00,0.10,9.28,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:17'),(273,12,1,'usage','order',11,0.00,0.06,9.58,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:17'),(274,13,1,'usage','order',11,0.00,0.04,7.70,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:17'),(275,17,1,'usage','order',11,0.00,0.04,14.70,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:17'),(276,18,1,'usage','order',11,0.00,0.02,9.82,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:17'),(277,1,1,'usage','order',11,0.00,1.00,14.00,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:17'),(278,11,1,'usage','order',11,0.00,0.10,9.28,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:17'),(279,12,1,'usage','order',11,0.00,0.06,9.58,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:17'),(280,13,1,'usage','order',11,0.00,0.04,7.70,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:17'),(281,17,1,'usage','order',11,0.00,0.04,14.70,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:17'),(282,18,1,'usage','order',11,0.00,0.02,9.82,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:17'),(283,1,1,'usage','order',11,0.00,1.00,14.00,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:17'),(284,11,1,'usage','order',11,0.00,0.10,9.28,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:17'),(285,12,1,'usage','order',11,0.00,0.06,9.58,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:17'),(286,13,1,'usage','order',11,0.00,0.04,7.70,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:17'),(287,17,1,'usage','order',11,0.00,0.04,14.70,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:17'),(288,18,1,'usage','order',11,0.00,0.02,9.82,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:17'),(289,1,1,'usage','order',12,0.00,1.00,13.00,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:24'),(290,11,1,'usage','order',12,0.00,0.10,9.18,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:24'),(291,12,1,'usage','order',12,0.00,0.06,9.52,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:24'),(292,13,1,'usage','order',12,0.00,0.04,7.66,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:24'),(293,17,1,'usage','order',12,0.00,0.04,14.66,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:24'),(294,18,1,'usage','order',12,0.00,0.02,9.80,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:24'),(295,1,1,'usage','order',12,0.00,1.00,13.00,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:24'),(296,11,1,'usage','order',12,0.00,0.10,9.18,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:24'),(297,12,1,'usage','order',12,0.00,0.06,9.52,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:24'),(298,13,1,'usage','order',12,0.00,0.04,7.66,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:24'),(299,17,1,'usage','order',12,0.00,0.04,14.66,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:24'),(300,18,1,'usage','order',12,0.00,0.02,9.80,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:24'),(301,1,1,'usage','order',12,0.00,1.00,13.00,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:24'),(302,11,1,'usage','order',12,0.00,0.10,9.18,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:24'),(303,12,1,'usage','order',12,0.00,0.06,9.52,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:24'),(304,13,1,'usage','order',12,0.00,0.04,7.66,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:24'),(305,17,1,'usage','order',12,0.00,0.04,14.66,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:24'),(306,18,1,'usage','order',12,0.00,0.02,9.80,0.00,'Penggunaan untuk Ikan Bakar x2',1,'2026-08-26 03:53:24'),(307,1,1,'usage','order',13,0.00,1.00,12.00,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 03:59:57'),(308,11,1,'usage','order',13,0.00,0.10,9.08,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 03:59:57'),(309,12,1,'usage','order',13,0.00,0.06,9.46,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 03:59:57'),(310,13,1,'usage','order',13,0.00,0.04,7.62,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 03:59:57'),(311,17,1,'usage','order',13,0.00,0.04,14.62,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 03:59:57'),(312,18,1,'usage','order',13,0.00,0.02,9.78,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 03:59:57'),(313,1,1,'usage','order',13,0.00,1.00,12.00,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 03:59:57'),(314,11,1,'usage','order',13,0.00,0.10,9.08,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 03:59:57'),(315,12,1,'usage','order',13,0.00,0.06,9.46,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 03:59:57'),(316,13,1,'usage','order',13,0.00,0.04,7.62,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 03:59:57'),(317,17,1,'usage','order',13,0.00,0.04,14.62,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 03:59:57'),(318,18,1,'usage','order',13,0.00,0.02,9.78,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 03:59:57'),(319,1,1,'usage','order',13,0.00,1.00,12.00,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 03:59:57'),(320,11,1,'usage','order',13,0.00,0.10,9.08,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 03:59:57'),(321,12,1,'usage','order',13,0.00,0.06,9.46,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 03:59:57'),(322,13,1,'usage','order',13,0.00,0.04,7.62,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 03:59:57'),(323,17,1,'usage','order',13,0.00,0.04,14.62,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 03:59:57'),(324,18,1,'usage','order',13,0.00,0.02,9.78,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 03:59:57'),(325,9,1,'usage','order',15,0.00,0.30,47.90,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-26 04:29:08'),(326,8,1,'usage','order',15,0.00,1.00,93.00,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-26 04:29:08'),(327,11,1,'usage','order',15,0.00,0.02,9.06,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-26 04:29:08'),(328,12,1,'usage','order',15,0.00,0.01,9.45,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-26 04:29:08'),(329,13,1,'usage','order',15,0.00,0.01,7.61,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-26 04:29:08'),(330,17,1,'usage','order',15,0.00,0.02,14.61,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-26 04:29:08'),(331,18,1,'usage','order',15,0.00,0.01,9.77,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-26 04:29:08'),(332,9,1,'usage','order',15,0.00,0.30,47.90,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-26 04:29:08'),(333,8,1,'usage','order',15,0.00,1.00,93.00,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-26 04:29:08'),(334,11,1,'usage','order',15,0.00,0.02,9.06,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-26 04:29:08'),(335,12,1,'usage','order',15,0.00,0.01,9.45,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-26 04:29:08'),(336,13,1,'usage','order',15,0.00,0.01,7.61,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-26 04:29:08'),(337,17,1,'usage','order',15,0.00,0.02,14.61,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-26 04:29:08'),(338,18,1,'usage','order',15,0.00,0.01,9.77,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-26 04:29:08'),(339,9,1,'usage','order',15,0.00,0.30,47.90,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-26 04:29:08'),(340,8,1,'usage','order',15,0.00,1.00,93.00,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-26 04:29:08'),(341,11,1,'usage','order',15,0.00,0.02,9.06,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-26 04:29:08'),(342,12,1,'usage','order',15,0.00,0.01,9.45,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-26 04:29:08'),(343,13,1,'usage','order',15,0.00,0.01,7.61,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-26 04:29:08'),(344,17,1,'usage','order',15,0.00,0.02,14.61,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-26 04:29:08'),(345,18,1,'usage','order',15,0.00,0.01,9.77,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-26 04:29:08'),(346,1,1,'usage','order',19,0.00,0.50,11.50,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 17:59:36'),(347,11,1,'usage','order',19,0.00,0.05,9.01,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 17:59:36'),(348,12,1,'usage','order',19,0.00,0.03,9.42,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 17:59:36'),(349,13,1,'usage','order',19,0.00,0.02,7.59,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 17:59:36'),(350,17,1,'usage','order',19,0.00,0.02,14.59,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 17:59:36'),(351,18,1,'usage','order',19,0.00,0.01,9.76,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 17:59:36'),(352,1,1,'usage','order',19,0.00,0.50,11.50,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 17:59:36'),(353,11,1,'usage','order',19,0.00,0.05,9.01,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 17:59:36'),(354,12,1,'usage','order',19,0.00,0.03,9.42,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 17:59:36'),(355,13,1,'usage','order',19,0.00,0.02,7.59,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 17:59:36'),(356,17,1,'usage','order',19,0.00,0.02,14.59,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 17:59:36'),(357,18,1,'usage','order',19,0.00,0.01,9.76,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 17:59:36'),(358,1,1,'usage','order',19,0.00,0.50,11.50,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 17:59:36'),(359,11,1,'usage','order',19,0.00,0.05,9.01,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 17:59:36'),(360,12,1,'usage','order',19,0.00,0.03,9.42,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 17:59:36'),(361,13,1,'usage','order',19,0.00,0.02,7.59,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 17:59:36'),(362,17,1,'usage','order',19,0.00,0.02,14.59,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 17:59:36'),(363,18,1,'usage','order',19,0.00,0.01,9.76,0.00,'Penggunaan untuk Ikan Bakar',1,'2026-08-26 17:59:36'),(364,9,1,'usage','order',22,0.00,0.60,47.30,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-28 15:49:31'),(365,8,1,'usage','order',22,0.00,2.00,91.00,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-28 15:49:31'),(366,11,1,'usage','order',22,0.00,0.04,8.97,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-28 15:49:31'),(367,12,1,'usage','order',22,0.00,0.02,9.40,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-28 15:49:31'),(368,13,1,'usage','order',22,0.00,0.02,7.57,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-28 15:49:31'),(369,17,1,'usage','order',22,0.00,0.03,14.56,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-28 15:49:31'),(370,18,1,'usage','order',22,0.00,0.02,9.74,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-28 15:49:31'),(371,9,1,'usage','order',22,0.00,0.60,47.30,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-28 15:49:31'),(372,8,1,'usage','order',22,0.00,2.00,91.00,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-28 15:49:31'),(373,11,1,'usage','order',22,0.00,0.04,8.97,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-28 15:49:31'),(374,12,1,'usage','order',22,0.00,0.02,9.40,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-28 15:49:31'),(375,13,1,'usage','order',22,0.00,0.02,7.57,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-28 15:49:31'),(376,17,1,'usage','order',22,0.00,0.03,14.56,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-28 15:49:31'),(377,18,1,'usage','order',22,0.00,0.02,9.74,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-28 15:49:31'),(378,9,1,'usage','order',22,0.00,0.60,47.30,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-28 15:49:31'),(379,8,1,'usage','order',22,0.00,2.00,91.00,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-28 15:49:31'),(380,11,1,'usage','order',22,0.00,0.04,8.97,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-28 15:49:31'),(381,12,1,'usage','order',22,0.00,0.02,9.40,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-28 15:49:31'),(382,13,1,'usage','order',22,0.00,0.02,7.57,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-28 15:49:31'),(383,17,1,'usage','order',22,0.00,0.03,14.56,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-28 15:49:31'),(384,18,1,'usage','order',22,0.00,0.02,9.74,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-08-28 15:49:31'),(385,9,1,'usage','order',34,0.00,0.30,47.00,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-09-05 12:25:35'),(386,8,1,'usage','order',34,0.00,1.00,90.00,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-09-05 12:25:35'),(387,11,1,'usage','order',34,0.00,0.02,8.95,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-09-05 12:25:35'),(388,12,1,'usage','order',34,0.00,0.01,9.39,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-09-05 12:25:35'),(389,13,1,'usage','order',34,0.00,0.01,7.56,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-09-05 12:25:35'),(390,17,1,'usage','order',34,0.00,0.02,14.55,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-09-05 12:25:35'),(391,18,1,'usage','order',34,0.00,0.01,9.73,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-09-05 12:25:35'),(392,9,1,'usage','order',34,0.00,0.30,47.00,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-09-05 12:25:35'),(393,8,1,'usage','order',34,0.00,1.00,90.00,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-09-05 12:25:35'),(394,11,1,'usage','order',34,0.00,0.02,8.95,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-09-05 12:25:35'),(395,12,1,'usage','order',34,0.00,0.01,9.39,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-09-05 12:25:35'),(396,13,1,'usage','order',34,0.00,0.01,7.56,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-09-05 12:25:35'),(397,17,1,'usage','order',34,0.00,0.02,14.55,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-09-05 12:25:35'),(398,18,1,'usage','order',34,0.00,0.01,9.73,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-09-05 12:25:35'),(399,9,1,'usage','order',34,0.00,0.30,47.00,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-09-05 12:25:35'),(400,8,1,'usage','order',34,0.00,1.00,90.00,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-09-05 12:25:35'),(401,11,1,'usage','order',34,0.00,0.02,8.95,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-09-05 12:25:35'),(402,12,1,'usage','order',34,0.00,0.01,9.39,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-09-05 12:25:35'),(403,13,1,'usage','order',34,0.00,0.01,7.56,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-09-05 12:25:35'),(404,17,1,'usage','order',34,0.00,0.02,14.55,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-09-05 12:25:35'),(405,18,1,'usage','order',34,0.00,0.01,9.73,0.00,'Penggunaan untuk Nasi Goreng Spesial',1,'2026-09-05 12:25:35'); /*!40000 ALTER TABLE `inventory_movements` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `menu_categories` -- DROP TABLE IF EXISTS `menu_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `menu_categories` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `icon` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sort_order` int DEFAULT '0', `is_active` tinyint(1) DEFAULT '1', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `menu_categories` -- LOCK TABLES `menu_categories` WRITE; /*!40000 ALTER TABLE `menu_categories` DISABLE KEYS */; INSERT INTO `menu_categories` VALUES (1,'Main Course','Menu utama','utensils',1,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(2,'Seafood','Hidangan laut','fish',2,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(3,'Chicken','Hidangan ayam','drumstick-bite',3,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(4,'Rice','Nasi dan mie','bowl',4,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(5,'Soup','Sup dan bakso','soup',5,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(6,'Beverage','Minuman','coffee',6,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(7,'Juice','Jus segar','glass-water',7,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(8,'Dessert','Pencuci mulut','ice-cream',8,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(9,'Pastry','Roti dan kue','croissant',9,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(10,'Snack','Cemilan','cookie',10,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(11,'Main Course','Menu utama','utensils',1,1,'2026-08-25 16:59:26','2026-08-25 16:59:26',NULL),(12,'Seafood','Hidangan laut','fish',2,1,'2026-08-25 16:59:26','2026-08-25 16:59:26',NULL),(13,'Chicken','Hidangan ayam','drumstick-bite',3,1,'2026-08-25 16:59:26','2026-08-25 16:59:26',NULL),(14,'Rice','Nasi dan mie','bowl',4,1,'2026-08-25 16:59:26','2026-08-25 16:59:26',NULL),(15,'Soup','Sup dan bakso','soup',5,1,'2026-08-25 16:59:26','2026-08-25 16:59:26',NULL),(16,'Beverage','Minuman','coffee',6,1,'2026-08-25 16:59:26','2026-08-25 16:59:26',NULL),(17,'Juice','Jus segar','glass-water',7,1,'2026-08-25 16:59:26','2026-08-25 16:59:26',NULL),(18,'Dessert','Pencuci mulut','ice-cream',8,1,'2026-08-25 16:59:26','2026-08-25 16:59:26',NULL),(19,'Pastry','Roti dan kue','croissant',9,1,'2026-08-25 16:59:26','2026-08-25 16:59:26',NULL),(20,'Snack','Cemilan','cookie',10,1,'2026-08-25 16:59:26','2026-08-25 16:59:26',NULL),(21,'Main Course','Menu utama','utensils',1,1,'2026-08-25 17:11:55','2026-08-25 17:11:55',NULL),(22,'Seafood','Hidangan laut','fish',2,1,'2026-08-25 17:11:55','2026-08-25 17:11:55',NULL),(23,'Chicken','Hidangan ayam','drumstick-bite',3,1,'2026-08-25 17:11:55','2026-08-25 17:11:55',NULL),(24,'Rice','Nasi dan mie','bowl',4,1,'2026-08-25 17:11:55','2026-08-25 17:11:55',NULL),(25,'Soup','Sup dan bakso','soup',5,1,'2026-08-25 17:11:55','2026-08-25 17:11:55',NULL),(26,'Beverage','Minuman','coffee',6,1,'2026-08-25 17:11:55','2026-08-25 17:11:55',NULL),(27,'Juice','Jus segar','glass-water',7,1,'2026-08-25 17:11:55','2026-08-25 17:11:55',NULL),(28,'Dessert','Pencuci mulut','ice-cream',8,1,'2026-08-25 17:11:55','2026-08-25 17:11:55',NULL),(29,'Pastry','Roti dan kue','croissant',9,1,'2026-08-25 17:11:55','2026-08-25 17:11:55',NULL),(30,'Snack','Cemilan','cookie',10,1,'2026-08-25 17:11:55','2026-08-25 17:11:55',NULL); /*!40000 ALTER TABLE `menu_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `menu_modifier_options` -- DROP TABLE IF EXISTS `menu_modifier_options`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `menu_modifier_options` ( `id` int NOT NULL AUTO_INCREMENT, `modifier_id` int NOT NULL, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `price_adjustment` decimal(12,2) DEFAULT '0.00', `is_default` tinyint(1) DEFAULT '0', `sort_order` int DEFAULT '0', PRIMARY KEY (`id`), KEY `modifier_id` (`modifier_id`), CONSTRAINT `menu_modifier_options_ibfk_1` FOREIGN KEY (`modifier_id`) REFERENCES `menu_modifiers` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `menu_modifier_options` -- LOCK TABLES `menu_modifier_options` WRITE; /*!40000 ALTER TABLE `menu_modifier_options` DISABLE KEYS */; /*!40000 ALTER TABLE `menu_modifier_options` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `menu_modifiers` -- DROP TABLE IF EXISTS `menu_modifiers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `menu_modifiers` ( `id` int NOT NULL AUTO_INCREMENT, `menu_id` int NOT NULL, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `type` enum('single','multiple') COLLATE utf8mb4_unicode_ci DEFAULT 'single', `is_required` tinyint(1) DEFAULT '0', `sort_order` int DEFAULT '0', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `menu_id` (`menu_id`), CONSTRAINT `menu_modifiers_ibfk_1` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `menu_modifiers` -- LOCK TABLES `menu_modifiers` WRITE; /*!40000 ALTER TABLE `menu_modifiers` DISABLE KEYS */; /*!40000 ALTER TABLE `menu_modifiers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `menus` -- DROP TABLE IF EXISTS `menus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `menus` ( `id` int NOT NULL AUTO_INCREMENT, `category_id` int NOT NULL, `sku` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `price` decimal(12,2) NOT NULL DEFAULT '0.00', `cost_price` decimal(12,2) DEFAULT '0.00', `photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_available` tinyint(1) DEFAULT '1', `is_active` tinyint(1) DEFAULT '1', `sort_order` int DEFAULT '0', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `sku` (`sku`), KEY `category_id` (`category_id`), CONSTRAINT `menus_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `menu_categories` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `menus` -- LOCK TABLES `menus` WRITE; /*!40000 ALTER TABLE `menus` DISABLE KEYS */; INSERT INTO `menus` VALUES (1,1,'MC-001','Grilled Fish Platter','Ikan bakar special dengan nasi dan sayuran',55000.00,28000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(2,1,'MC-002','Short Ribs','Iga pendek panggang dengan saus BBQ',65000.00,35000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(3,1,'MC-003','Chicken Steak','Steak ayam dengan mushroom sauce',45000.00,22000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(4,2,'SF-001','Ikan Bakar','Ikan bakar bumbu khas Joglo Koi',45000.00,24000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(5,2,'SF-002','Mackerel','Ikan mackerel goreng dengan sambal',40000.00,20000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(6,2,'SF-003','Udang Goreng Tepung','Udang crispy dengan mayo',42000.00,22000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(7,3,'CH-001','Ayam Bakar Madu','Ayam bakar madu dengan nasi',38000.00,18000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(8,3,'CH-002','Chicken Katsu','Chicken katsu dengan salad',35000.00,16000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(9,4,'RS-001','Nasi Goreng Spesial','Nasi goreng dengan telur dan ayam',28000.00,12000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(10,4,'RS-002','Nasi Goreng Seafood','Nasi goreng dengan udang dan cumi',35000.00,18000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(11,4,'RS-003','Mie Goreng Jawa','Mie goreng khas Jawa',25000.00,10000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(12,5,'SP-001','Tom Yum','Tom yum seafood pedas',35000.00,15000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(13,5,'SP-002','Chicken Soup','Sup ayam hangat',25000.00,10000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(14,5,'SP-003','Soto Ayam','Soto ayam bening',22000.00,9000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(15,6,'BV-001','Es Teh Manis','Teh manis dingin',8000.00,2000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(16,6,'BV-002','Es Jeruk','Jeruk segar',12000.00,4000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(17,6,'BV-003','Kopi Hitam','Kopi hitam tubruk',10000.00,3000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(18,6,'BV-004','Kopi Susu','Kopi susu kekinian',18000.00,6000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(19,7,'JC-001','Juice Alpukat','Jus alpukat segar',15000.00,6000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(20,7,'JC-002','Juice Mangga','Jus mangga segar',15000.00,5000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(21,7,'JC-003','Juice Jeruk','Jus jeruk segar',12000.00,4000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(22,8,'DS-001','Pudding Coklat','Puding coklat lembut',18000.00,7000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(23,8,'DS-002','Es Krim Vanilla','Es krim vanilla 2 scoop',20000.00,8000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(24,9,'PA-001','Croissant','Croissant butter fresh',15000.00,6000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(25,9,'PA-002','Roti Coklat','Roti isi coklat',10000.00,4000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(26,10,'SN-001','Kentang Goreng','French fries crispy',18000.00,7000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(27,10,'SN-002','Onion Rings','Bawang bombay goreng tepung',20000.00,8000.00,NULL,1,1,0,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(56,8,'B-011','Bubur','Bubur',5000.00,3000.00,'uploads/menu/upload_6a8f1f3ea002e_1787764542.jpeg',1,1,1,'2026-08-26 17:15:42','2026-08-26 17:15:42',NULL); /*!40000 ALTER TABLE `menus` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `notifications` -- DROP TABLE IF EXISTS `notifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `notifications` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int DEFAULT NULL, `title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `message` text COLLATE utf8mb4_unicode_ci NOT NULL, `type` enum('info','warning','danger','success') COLLATE utf8mb4_unicode_ci DEFAULT 'info', `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_read` tinyint(1) DEFAULT '0', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), CONSTRAINT `notifications_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `notifications` -- LOCK TABLES `notifications` WRITE; /*!40000 ALTER TABLE `notifications` DISABLE KEYS */; /*!40000 ALTER TABLE `notifications` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `order_items` -- DROP TABLE IF EXISTS `order_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `order_items` ( `id` int NOT NULL AUTO_INCREMENT, `order_id` int NOT NULL, `menu_id` int NOT NULL, `menu_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `menu_price` decimal(12,2) NOT NULL, `quantity` int NOT NULL DEFAULT '1', `modifier_text` text COLLATE utf8mb4_unicode_ci, `modifier_price` decimal(12,2) DEFAULT '0.00', `subtotal` decimal(14,2) NOT NULL, `notes` text COLLATE utf8mb4_unicode_ci, `status` enum('pending','preparing','ready','served','cancelled') COLLATE utf8mb4_unicode_ci DEFAULT 'pending', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `order_id` (`order_id`), KEY `menu_id` (`menu_id`), CONSTRAINT `order_items_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE, CONSTRAINT `order_items_ibfk_2` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `order_items` -- LOCK TABLES `order_items` WRITE; /*!40000 ALTER TABLE `order_items` DISABLE KEYS */; INSERT INTO `order_items` VALUES (1,1,4,'Ikan Bakar',45000.00,1,NULL,0.00,45000.00,'','pending','2026-08-26 03:45:02'),(2,1,8,'Chicken Katsu',35000.00,1,NULL,0.00,35000.00,'','pending','2026-08-26 03:45:02'),(3,1,9,'Nasi Goreng Spesial',28000.00,1,NULL,0.00,28000.00,'','pending','2026-08-26 03:45:02'),(4,2,4,'Ikan Bakar',45000.00,1,NULL,0.00,45000.00,'','pending','2026-08-26 03:47:04'),(5,2,8,'Chicken Katsu',35000.00,1,NULL,0.00,35000.00,'','pending','2026-08-26 03:47:04'),(6,2,9,'Nasi Goreng Spesial',28000.00,1,NULL,0.00,28000.00,'','pending','2026-08-26 03:47:04'),(7,3,4,'Ikan Bakar',45000.00,1,NULL,0.00,45000.00,'','pending','2026-08-26 03:50:59'),(8,3,8,'Chicken Katsu',35000.00,1,NULL,0.00,35000.00,'','pending','2026-08-26 03:50:59'),(9,3,9,'Nasi Goreng Spesial',28000.00,1,NULL,0.00,28000.00,'','pending','2026-08-26 03:50:59'),(10,4,4,'Ikan Bakar',45000.00,1,NULL,0.00,45000.00,'','served','2026-08-26 03:51:08'),(11,4,8,'Chicken Katsu',35000.00,1,NULL,0.00,35000.00,'','served','2026-08-26 03:51:08'),(12,4,9,'Nasi Goreng Spesial',28000.00,1,NULL,0.00,28000.00,'','served','2026-08-26 03:51:08'),(13,5,4,'Ikan Bakar',45000.00,1,NULL,0.00,45000.00,'','pending','2026-08-26 03:51:16'),(14,5,8,'Chicken Katsu',35000.00,1,NULL,0.00,35000.00,'','pending','2026-08-26 03:51:16'),(15,5,9,'Nasi Goreng Spesial',28000.00,1,NULL,0.00,28000.00,'','pending','2026-08-26 03:51:16'),(16,6,4,'Ikan Bakar',45000.00,1,NULL,0.00,45000.00,'','pending','2026-08-26 03:51:35'),(17,6,8,'Chicken Katsu',35000.00,1,NULL,0.00,35000.00,'','pending','2026-08-26 03:51:35'),(18,6,9,'Nasi Goreng Spesial',28000.00,1,NULL,0.00,28000.00,'','pending','2026-08-26 03:51:35'),(19,7,4,'Ikan Bakar',45000.00,1,NULL,0.00,45000.00,'','pending','2026-08-26 03:51:43'),(20,7,8,'Chicken Katsu',35000.00,1,NULL,0.00,35000.00,'','pending','2026-08-26 03:51:43'),(21,7,9,'Nasi Goreng Spesial',28000.00,1,NULL,0.00,28000.00,'','pending','2026-08-26 03:51:43'),(22,8,4,'Ikan Bakar',45000.00,1,NULL,0.00,45000.00,'','pending','2026-08-26 03:52:16'),(23,8,3,'Chicken Steak',45000.00,1,NULL,0.00,45000.00,'','pending','2026-08-26 03:52:16'),(24,9,4,'Ikan Bakar',45000.00,2,NULL,0.00,90000.00,'','pending','2026-08-26 03:52:27'),(25,9,3,'Chicken Steak',45000.00,2,NULL,0.00,90000.00,'','pending','2026-08-26 03:52:27'),(26,10,4,'Ikan Bakar',45000.00,2,NULL,0.00,90000.00,'','pending','2026-08-26 03:53:05'),(27,10,3,'Chicken Steak',45000.00,2,NULL,0.00,90000.00,'','pending','2026-08-26 03:53:05'),(28,11,4,'Ikan Bakar',45000.00,2,NULL,0.00,90000.00,'','pending','2026-08-26 03:53:13'),(29,11,3,'Chicken Steak',45000.00,2,NULL,0.00,90000.00,'','pending','2026-08-26 03:53:13'),(30,12,4,'Ikan Bakar',45000.00,2,NULL,0.00,90000.00,'','pending','2026-08-26 03:53:21'),(31,12,3,'Chicken Steak',45000.00,2,NULL,0.00,90000.00,'','pending','2026-08-26 03:53:21'),(32,13,4,'Ikan Bakar',45000.00,2,NULL,0.00,90000.00,'','pending','2026-08-26 03:59:46'),(33,13,3,'Chicken Steak',45000.00,2,NULL,0.00,90000.00,'','pending','2026-08-26 03:59:46'),(34,13,1,'Grilled Fish Platter',55000.00,1,NULL,0.00,55000.00,'','pending','2026-08-26 03:59:46'),(35,14,3,'Chicken Steak',45000.00,2,NULL,0.00,90000.00,'','pending','2026-08-26 04:27:46'),(36,15,6,'Udang Goreng Tepung',42000.00,1,NULL,0.00,42000.00,'','pending','2026-08-26 04:28:56'),(37,15,9,'Nasi Goreng Spesial',28000.00,1,NULL,0.00,28000.00,'','pending','2026-08-26 04:28:56'),(38,15,10,'Nasi Goreng Seafood',35000.00,1,NULL,0.00,35000.00,'','pending','2026-08-26 04:28:56'),(39,15,11,'Mie Goreng Jawa',25000.00,1,NULL,0.00,25000.00,'','pending','2026-08-26 04:28:56'),(40,16,1,'Grilled Fish Platter',55000.00,1,NULL,0.00,55000.00,'','pending','2026-08-26 16:56:35'),(41,16,2,'Short Ribs',65000.00,1,NULL,0.00,65000.00,'','pending','2026-08-26 16:56:35'),(42,16,17,'Kopi Hitam',10000.00,1,NULL,0.00,10000.00,'','pending','2026-08-26 16:56:35'),(43,16,18,'Kopi Susu',18000.00,1,NULL,0.00,18000.00,'','pending','2026-08-26 16:56:35'),(44,17,56,'Bubur',5000.00,2,NULL,0.00,10000.00,'','served','2026-08-26 17:16:23'),(45,17,23,'Es Krim Vanilla',20000.00,1,NULL,0.00,20000.00,'','served','2026-08-26 17:16:23'),(46,17,22,'Pudding Coklat',18000.00,1,NULL,0.00,18000.00,'','served','2026-08-26 17:16:23'),(47,18,56,'Bubur',5000.00,2,NULL,0.00,10000.00,'','served','2026-08-26 17:26:06'),(48,18,23,'Es Krim Vanilla',20000.00,1,NULL,0.00,20000.00,'','served','2026-08-26 17:26:06'),(49,18,22,'Pudding Coklat',18000.00,1,NULL,0.00,18000.00,'','served','2026-08-26 17:26:06'),(50,19,3,'Chicken Steak',45000.00,1,NULL,0.00,45000.00,'','served','2026-08-26 17:41:36'),(51,19,4,'Ikan Bakar',45000.00,1,NULL,0.00,45000.00,'','served','2026-08-26 17:41:36'),(52,19,5,'Mackerel',40000.00,1,NULL,0.00,40000.00,'','served','2026-08-26 17:41:36'),(53,19,56,'Bubur',5000.00,1,NULL,0.00,5000.00,'','served','2026-08-26 17:41:36'),(54,20,8,'Chicken Katsu',35000.00,3,NULL,0.00,105000.00,'','served','2026-08-26 17:54:59'),(55,21,2,'Short Ribs',65000.00,1,NULL,0.00,65000.00,'','served','2026-08-28 03:45:45'),(56,21,1,'Grilled Fish Platter',55000.00,1,NULL,0.00,55000.00,'','served','2026-08-28 03:45:45'),(57,21,8,'Chicken Katsu',35000.00,2,NULL,0.00,70000.00,'','served','2026-08-28 03:45:45'),(58,21,23,'Es Krim Vanilla',20000.00,1,NULL,0.00,20000.00,'','served','2026-08-28 03:45:45'),(59,21,22,'Pudding Coklat',18000.00,1,NULL,0.00,18000.00,'','served','2026-08-28 03:45:45'),(60,21,21,'Juice Jeruk',12000.00,1,NULL,0.00,12000.00,'','served','2026-08-28 03:45:45'),(61,22,9,'Nasi Goreng Spesial',28000.00,2,NULL,0.00,56000.00,'','served','2026-08-28 03:47:21'),(62,22,10,'Nasi Goreng Seafood',35000.00,1,NULL,0.00,35000.00,'','served','2026-08-28 03:47:21'),(63,22,27,'Onion Rings',20000.00,1,NULL,0.00,20000.00,'','served','2026-08-28 03:47:21'),(64,22,21,'Juice Jeruk',12000.00,1,NULL,0.00,12000.00,'','served','2026-08-28 03:47:21'),(65,22,16,'Es Jeruk',12000.00,1,NULL,0.00,12000.00,'','served','2026-08-28 03:47:21'),(66,23,1,'Grilled Fish Platter',55000.00,1,NULL,0.00,55000.00,'','served','2026-08-28 04:09:22'),(67,23,2,'Short Ribs',65000.00,2,NULL,0.00,130000.00,'','served','2026-08-28 04:09:22'),(68,24,19,'Juice Alpukat',15000.00,1,NULL,0.00,15000.00,'','served','2026-08-28 04:20:53'),(69,25,17,'Kopi Hitam',10000.00,9,NULL,0.00,90000.00,'','served','2026-08-29 11:34:49'),(70,25,56,'Bubur',5000.00,1,NULL,0.00,5000.00,'','served','2026-08-29 11:34:49'),(71,26,8,'Chicken Katsu',35000.00,1,NULL,0.00,35000.00,'','served','2026-08-29 11:36:24'),(72,27,3,'Chicken Steak',45000.00,1,NULL,0.00,45000.00,'','pending','2026-08-29 12:05:48'),(73,27,23,'Es Krim Vanilla',20000.00,1,NULL,0.00,20000.00,'','pending','2026-08-29 12:05:48'),(74,29,2,'Short Ribs',65000.00,1,NULL,0.00,65000.00,'','served','2026-09-05 08:40:14'),(75,33,1,'Grilled Fish Platter',55000.00,1,NULL,0.00,55000.00,'','served','2026-09-05 09:14:35'),(76,33,10,'Nasi Goreng Seafood',35000.00,1,NULL,0.00,35000.00,'','served','2026-09-05 09:14:35'),(77,33,1,'Grilled Fish Platter',55000.00,1,NULL,0.00,55000.00,NULL,'served','2026-09-05 09:16:11'),(78,33,11,'Mie Goreng Jawa',25000.00,1,NULL,0.00,25000.00,NULL,'served','2026-09-05 09:16:11'),(79,34,1,'Grilled Fish Platter',55000.00,2,NULL,0.00,110000.00,NULL,'served','2026-09-05 12:18:45'),(80,34,2,'Short Ribs',65000.00,1,NULL,0.00,65000.00,NULL,'served','2026-09-05 12:18:45'),(81,34,9,'Nasi Goreng Spesial',28000.00,1,NULL,0.00,28000.00,NULL,'served','2026-09-05 12:18:45'),(82,35,2,'Short Ribs',65000.00,1,NULL,0.00,65000.00,'','served','2026-09-05 12:41:30'),(83,35,3,'Chicken Steak',45000.00,1,NULL,0.00,45000.00,'','served','2026-09-05 12:41:30'); /*!40000 ALTER TABLE `order_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orders` -- DROP TABLE IF EXISTS `orders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `orders` ( `id` int NOT NULL AUTO_INCREMENT, `order_number` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `customer_id` int DEFAULT NULL, `customer_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `table_id` int DEFAULT NULL, `user_id` int DEFAULT NULL, `order_type` enum('dine_in','takeaway','delivery') COLLATE utf8mb4_unicode_ci DEFAULT 'dine_in', `status` enum('draft','pending','preparing','ready','served','completed','cancelled') COLLATE utf8mb4_unicode_ci DEFAULT 'draft', `subtotal` decimal(14,2) DEFAULT '0.00', `discount_amount` decimal(14,2) DEFAULT '0.00', `discount_type` enum('fixed','percentage') COLLATE utf8mb4_unicode_ci DEFAULT NULL, `discount_value` decimal(12,2) DEFAULT '0.00', `tax_amount` decimal(14,2) DEFAULT '0.00', `service_charge` decimal(14,2) DEFAULT '0.00', `total` decimal(14,2) DEFAULT '0.00', `notes` text COLLATE utf8mb4_unicode_ci, `is_synced` tinyint(1) DEFAULT '1', `synced_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `order_number` (`order_number`), KEY `customer_id` (`customer_id`), KEY `table_id` (`table_id`), KEY `user_id` (`user_id`), CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`), CONSTRAINT `orders_ibfk_2` FOREIGN KEY (`table_id`) REFERENCES `restaurant_tables` (`id`), CONSTRAINT `orders_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=36 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,'KOI-20260826-0001',16,'ahsan',1,1,'dine_in','completed',108000.00,0.00,NULL,0.00,10800.00,5400.00,124200.00,NULL,1,NULL,'2026-08-26 03:45:02','2026-08-26 03:45:24',NULL),(2,'KOI-20260826-0002',16,'ahsan',1,1,'dine_in','completed',108000.00,0.00,NULL,0.00,10800.00,5400.00,124200.00,NULL,1,NULL,'2026-08-26 03:47:04','2026-08-26 03:47:07',NULL),(3,'KOI-20260826-0003',NULL,NULL,NULL,1,'takeaway','completed',108000.00,0.00,NULL,0.00,10800.00,5400.00,124200.00,NULL,1,NULL,'2026-08-26 03:50:59','2026-08-26 03:51:03',NULL),(4,'KOI-20260826-0004',NULL,NULL,NULL,1,'takeaway','ready',108000.00,0.00,NULL,0.00,10800.00,5400.00,124200.00,NULL,1,NULL,'2026-08-26 03:51:08','2026-08-26 04:30:12',NULL),(5,'KOI-20260826-0005',16,'ahsan',1,1,'takeaway','completed',108000.00,0.00,NULL,0.00,10800.00,5400.00,124200.00,NULL,1,NULL,'2026-08-26 03:51:16','2026-08-26 03:51:21',NULL),(6,'KOI-20260826-0006',16,'ahsan',1,1,'takeaway','completed',108000.00,0.00,NULL,0.00,10800.00,5400.00,124200.00,NULL,1,NULL,'2026-08-26 03:51:35','2026-08-26 03:51:38',NULL),(7,'KOI-20260826-0007',16,'ahsan',1,1,'takeaway','completed',108000.00,0.00,NULL,0.00,10800.00,5400.00,124200.00,NULL,1,NULL,'2026-08-26 03:51:43','2026-08-26 03:51:46',NULL),(8,'KOI-20260826-0008',16,'ahsan',1,1,'takeaway','cancelled',90000.00,0.00,NULL,0.00,9000.00,4500.00,103500.00,NULL,1,NULL,'2026-08-26 03:52:16','2026-08-26 04:21:42',NULL),(9,'KOI-20260826-0009',16,'ahsan',2,1,'takeaway','completed',180000.00,0.00,NULL,0.00,18000.00,9000.00,207000.00,NULL,1,NULL,'2026-08-26 03:52:27','2026-08-26 03:52:32',NULL),(10,'KOI-20260826-0010',16,'ahsan',2,1,'takeaway','completed',180000.00,0.00,NULL,0.00,18000.00,9000.00,207000.00,NULL,1,NULL,'2026-08-26 03:53:05','2026-08-26 03:53:08',NULL),(11,'KOI-20260826-0011',16,'ahsan',2,1,'takeaway','completed',180000.00,0.00,NULL,0.00,18000.00,9000.00,207000.00,NULL,1,NULL,'2026-08-26 03:53:13','2026-08-26 03:53:17',NULL),(12,'KOI-20260826-0012',16,'ahsan',2,1,'takeaway','completed',180000.00,0.00,NULL,0.00,18000.00,9000.00,207000.00,NULL,1,NULL,'2026-08-26 03:53:21','2026-08-26 03:53:24',NULL),(13,'KOI-20260826-0013',NULL,NULL,NULL,1,'dine_in','completed',235000.00,0.00,NULL,0.00,23500.00,11750.00,270250.00,NULL,1,NULL,'2026-08-26 03:59:46','2026-08-26 03:59:57',NULL),(14,'KOI-20260826-0014',17,'ex',6,1,'dine_in','completed',90000.00,0.00,NULL,0.00,9000.00,4500.00,103500.00,NULL,1,NULL,'2026-08-26 04:27:46','2026-08-26 04:27:50',NULL),(15,'KOI-20260826-0015',18,'mimi',11,1,'takeaway','completed',130000.00,0.00,NULL,0.00,13000.00,6500.00,149500.00,NULL,1,NULL,'2026-08-26 04:28:56','2026-08-26 04:29:08',NULL),(16,'KOI-20260826-0016',20,'lulu',1,1,'dine_in','completed',148000.00,0.00,NULL,0.00,14800.00,7400.00,170200.00,NULL,1,NULL,'2026-08-26 16:56:35','2026-08-26 16:56:47',NULL),(17,'KOI-20260827-0001',21,'Edy',11,1,'dine_in','completed',48000.00,0.00,NULL,0.00,4800.00,2400.00,55200.00,NULL,1,NULL,'2026-08-26 17:16:23','2026-08-26 17:19:29',NULL),(18,'KOI-20260827-0002',22,'inu',11,1,'dine_in','completed',48000.00,0.00,NULL,0.00,4800.00,2400.00,55200.00,NULL,1,NULL,'2026-08-26 17:26:06','2026-08-26 17:26:44',NULL),(19,'KOI-20260827-0003',23,'ga',2,1,'dine_in','completed',135000.00,0.00,NULL,0.00,13500.00,6750.00,155250.00,NULL,1,NULL,'2026-08-26 17:41:36','2026-08-26 17:59:36',NULL),(20,'KOI-20260827-0004',24,'li',1,1,'dine_in','completed',105000.00,0.00,NULL,0.00,10500.00,5250.00,120750.00,NULL,1,NULL,'2026-08-26 17:54:59','2026-08-26 17:58:58',NULL),(21,'KOI-20260828-0001',16,'ahsan',2,2,'dine_in','completed',240000.00,0.00,NULL,0.00,24000.00,12000.00,276000.00,NULL,1,NULL,'2026-08-28 03:45:45','2026-08-28 15:49:36',NULL),(22,'KOI-20260828-0002',25,'aku',9,1,'dine_in','completed',135000.00,0.00,NULL,0.00,13500.00,6750.00,155250.00,NULL,1,NULL,'2026-08-28 03:47:21','2026-08-28 15:49:31',NULL),(23,'KOI-20260828-0003',21,'edy',1,1,'dine_in','completed',185000.00,0.00,NULL,0.00,18500.00,9250.00,212750.00,NULL,1,NULL,'2026-08-28 04:09:22','2026-08-28 15:49:20',NULL),(24,'KOI-20260828-0004',16,'ahsan',4,1,'dine_in','completed',15000.00,0.00,NULL,0.00,1500.00,750.00,17250.00,NULL,1,NULL,'2026-08-28 04:20:53','2026-08-28 06:42:16',NULL),(25,'KOI-20260829-0001',16,'ahsan',5,2,'dine_in','completed',95000.00,9500.00,'percentage',10.00,9500.00,4750.00,99750.00,NULL,1,NULL,'2026-08-29 11:34:49','2026-08-29 11:37:59',NULL),(26,'KOI-20260829-0002',26,'iki',1,1,'dine_in','completed',35000.00,0.00,NULL,0.00,3500.00,1750.00,40250.00,NULL,1,NULL,'2026-08-29 11:36:24','2026-08-29 11:37:37',NULL),(27,'KOI-20260829-0003',16,'ahsan',10,1,'dine_in','pending',65000.00,0.00,NULL,0.00,6500.00,3250.00,74750.00,NULL,1,NULL,'2026-08-29 12:05:48','2026-08-29 12:05:48',NULL),(29,'KOI-20260905-0001',16,'ahsan',11,1,'dine_in','completed',65000.00,0.00,NULL,0.00,6500.00,3250.00,74750.00,NULL,1,NULL,'2026-09-05 08:40:14','2026-09-05 08:41:34',NULL),(33,'KOI-20260905-0002',16,'ahsan',11,1,'dine_in','completed',170000.00,0.00,NULL,0.00,17000.00,8500.00,195500.00,NULL,1,NULL,'2026-09-05 09:14:35','2026-09-05 09:17:40',NULL),(34,'TBL-20260905-0003',16,'ahsan',1,NULL,'dine_in','completed',203000.00,0.00,NULL,0.00,20300.00,10150.00,233450.00,NULL,1,NULL,'2026-09-05 12:18:45','2026-09-05 12:25:35',NULL),(35,'KOI-20260905-0004',16,'ahsan',1,2,'dine_in','completed',110000.00,0.00,NULL,0.00,11000.00,5500.00,126500.00,NULL,1,NULL,'2026-09-05 12:41:30','2026-09-05 12:42:22',NULL); /*!40000 ALTER TABLE `orders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payments` -- DROP TABLE IF EXISTS `payments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `payments` ( `id` int NOT NULL AUTO_INCREMENT, `payment_number` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `order_id` int NOT NULL, `amount` decimal(14,2) NOT NULL, `method` enum('cash','qris','bank_transfer','debit','credit','ewallet') COLLATE utf8mb4_unicode_ci NOT NULL, `reference_number` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('pending','paid','partial','refunded','failed') COLLATE utf8mb4_unicode_ci DEFAULT 'pending', `paid_at` timestamp NULL DEFAULT NULL, `created_by` int NOT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `payment_number` (`payment_number`), KEY `order_id` (`order_id`), KEY `created_by` (`created_by`), CONSTRAINT `payments_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`), CONSTRAINT `payments_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `payments` -- LOCK TABLES `payments` WRITE; /*!40000 ALTER TABLE `payments` DISABLE KEYS */; INSERT INTO `payments` VALUES (1,'PMT-20260826-0001',1,124200.00,'cash',NULL,'paid','2026-08-26 03:45:24',1,'2026-08-26 03:45:24'),(2,'PMT-20260826-0002',2,124200.00,'qris',NULL,'paid','2026-08-26 03:47:07',1,'2026-08-26 03:47:07'),(3,'PMT-20260826-0003',3,124200.00,'cash',NULL,'paid','2026-08-26 03:51:03',1,'2026-08-26 03:51:03'),(4,'PMT-20260826-0004',5,124200.00,'bank_transfer',NULL,'paid','2026-08-26 03:51:21',1,'2026-08-26 03:51:21'),(5,'PMT-20260826-0005',6,124200.00,'qris',NULL,'paid','2026-08-26 03:51:38',1,'2026-08-26 03:51:38'),(6,'PMT-20260826-0006',7,124200.00,'cash',NULL,'paid','2026-08-26 03:51:46',1,'2026-08-26 03:51:46'),(7,'PMT-20260826-0007',9,207000.00,'cash',NULL,'paid','2026-08-26 03:52:32',1,'2026-08-26 03:52:32'),(8,'PMT-20260826-0008',10,207000.00,'bank_transfer',NULL,'paid','2026-08-26 03:53:08',1,'2026-08-26 03:53:08'),(9,'PMT-20260826-0009',11,207000.00,'ewallet',NULL,'paid','2026-08-26 03:53:17',1,'2026-08-26 03:53:17'),(10,'PMT-20260826-0010',12,207000.00,'qris',NULL,'paid','2026-08-26 03:53:24',1,'2026-08-26 03:53:24'),(11,'PMT-20260826-0011',13,270250.00,'cash',NULL,'paid','2026-08-26 03:59:57',1,'2026-08-26 03:59:57'),(12,'PMT-20260826-0012',14,103500.00,'cash',NULL,'paid','2026-08-26 04:27:50',1,'2026-08-26 04:27:50'),(13,'PMT-20260826-0013',15,200000.00,'cash',NULL,'paid','2026-08-26 04:29:08',1,'2026-08-26 04:29:08'),(14,'PMT-20260826-0014',16,200000.00,'cash',NULL,'paid','2026-08-26 16:56:47',1,'2026-08-26 16:56:47'),(15,'PMT-20260827-0001',18,100000.00,'cash',NULL,'paid','2026-08-26 17:26:13',1,'2026-08-26 17:26:13'),(16,'PMT-20260827-0002',20,150000.00,'cash',NULL,'paid','2026-08-26 17:58:58',1,'2026-08-26 17:58:58'),(17,'PMT-20260827-0003',19,155250.00,'qris',NULL,'paid','2026-08-26 17:59:36',1,'2026-08-26 17:59:36'),(18,'PMT-20260828-0001',24,20000.00,'cash',NULL,'paid','2026-08-28 06:42:16',1,'2026-08-28 06:42:16'),(19,'PMT-20260828-0002',23,212750.00,'cash',NULL,'paid','2026-08-28 15:49:20',1,'2026-08-28 15:49:20'),(20,'PMT-20260828-0003',22,155250.00,'cash',NULL,'paid','2026-08-28 15:49:31',1,'2026-08-28 15:49:31'),(21,'PMT-20260828-0004',21,276000.00,'cash',NULL,'paid','2026-08-28 15:49:36',1,'2026-08-28 15:49:36'),(22,'PMT-20260829-0001',26,40250.00,'cash',NULL,'paid','2026-08-29 11:37:37',1,'2026-08-29 11:37:37'),(23,'PMT-20260829-0002',25,99750.00,'qris',NULL,'paid','2026-08-29 11:37:59',1,'2026-08-29 11:37:59'),(24,'PMT-20260905-0001',29,74750.00,'qris',NULL,'paid','2026-09-05 08:41:34',1,'2026-09-05 08:41:34'),(25,'PMT-20260905-0002',33,200000.00,'cash',NULL,'paid','2026-09-05 09:17:40',1,'2026-09-05 09:17:40'),(26,'PMT-20260905-0003',34,233450.00,'cash',NULL,'paid','2026-09-05 12:25:35',1,'2026-09-05 12:25:35'),(27,'PMT-20260905-0004',35,150000.00,'cash',NULL,'paid','2026-09-05 12:42:22',2,'2026-09-05 12:42:22'); /*!40000 ALTER TABLE `payments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payroll` -- DROP TABLE IF EXISTS `payroll`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `payroll` ( `id` int NOT NULL AUTO_INCREMENT, `payroll_number` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `period_month` int NOT NULL, `period_year` int NOT NULL, `status` enum('draft','calculated','approved','paid') COLLATE utf8mb4_unicode_ci DEFAULT 'draft', `total_gross` decimal(14,2) DEFAULT '0.00', `total_deduction` decimal(14,2) DEFAULT '0.00', `total_net` decimal(14,2) DEFAULT '0.00', `processed_by` int DEFAULT NULL, `approved_by` int DEFAULT NULL, `paid_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `payroll_number` (`payroll_number`), KEY `processed_by` (`processed_by`), KEY `approved_by` (`approved_by`), CONSTRAINT `payroll_ibfk_1` FOREIGN KEY (`processed_by`) REFERENCES `users` (`id`), CONSTRAINT `payroll_ibfk_2` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `payroll` -- LOCK TABLES `payroll` WRITE; /*!40000 ALTER TABLE `payroll` DISABLE KEYS */; INSERT INTO `payroll` VALUES (1,'PAY-20260826-0001',8,2026,'paid',17800000.00,0.00,17800000.00,1,1,'2026-08-26 03:41:45','2026-08-26 02:14:16'); /*!40000 ALTER TABLE `payroll` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payroll_items` -- DROP TABLE IF EXISTS `payroll_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `payroll_items` ( `id` int NOT NULL AUTO_INCREMENT, `payroll_id` int NOT NULL, `employee_id` int NOT NULL, `basic_salary` decimal(14,2) DEFAULT '0.00', `attendance_allowance` decimal(14,2) DEFAULT '0.00', `overtime_pay` decimal(14,2) DEFAULT '0.00', `bonus` decimal(14,2) DEFAULT '0.00', `commission` decimal(14,2) DEFAULT '0.00', `meal_allowance` decimal(14,2) DEFAULT '0.00', `transport_allowance` decimal(14,2) DEFAULT '0.00', `deduction` decimal(14,2) DEFAULT '0.00', `loan_deduction` decimal(14,2) DEFAULT '0.00', `absence_deduction` decimal(14,2) DEFAULT '0.00', `net_salary` decimal(14,2) DEFAULT '0.00', `status` enum('pending','paid') COLLATE utf8mb4_unicode_ci DEFAULT 'pending', PRIMARY KEY (`id`), KEY `payroll_id` (`payroll_id`), KEY `employee_id` (`employee_id`), CONSTRAINT `payroll_items_ibfk_1` FOREIGN KEY (`payroll_id`) REFERENCES `payroll` (`id`) ON DELETE CASCADE, CONSTRAINT `payroll_items_ibfk_2` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `payroll_items` -- LOCK TABLES `payroll_items` WRITE; /*!40000 ALTER TABLE `payroll_items` DISABLE KEYS */; INSERT INTO `payroll_items` VALUES (1,1,1,3500000.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,3500000.00,'paid'),(2,1,2,4000000.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'paid'),(3,1,3,3000000.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,3000000.00,'paid'),(4,1,4,3800000.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,3800000.00,'paid'),(5,1,5,3500000.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,3500000.00,'paid'); /*!40000 ALTER TABLE `payroll_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `permissions` -- DROP TABLE IF EXISTS `permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `permissions` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `module` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `permissions` -- LOCK TABLES `permissions` WRITE; /*!40000 ALTER TABLE `permissions` DISABLE KEYS */; INSERT INTO `permissions` VALUES (1,'dashboard.view','dashboard',NULL,'2026-08-25 16:55:21'),(2,'orders.view','orders',NULL,'2026-08-25 16:55:21'),(3,'orders.create','orders',NULL,'2026-08-25 16:55:21'),(4,'orders.update','orders',NULL,'2026-08-25 16:55:21'),(5,'orders.cancel','orders',NULL,'2026-08-25 16:55:21'),(6,'orders.refund','orders',NULL,'2026-08-25 16:55:21'),(7,'pos.access','pos',NULL,'2026-08-25 16:55:21'),(8,'pos.process_payment','pos',NULL,'2026-08-25 16:55:21'),(9,'pos.split_bill','pos',NULL,'2026-08-25 16:55:21'),(10,'menus.view','menus',NULL,'2026-08-25 16:55:21'),(11,'menus.create','menus',NULL,'2026-08-25 16:55:21'),(12,'menus.update','menus',NULL,'2026-08-25 16:55:21'),(13,'menus.delete','menus',NULL,'2026-08-25 16:55:21'),(14,'categories.view','categories',NULL,'2026-08-25 16:55:21'),(15,'categories.manage','categories',NULL,'2026-08-25 16:55:21'),(16,'tables.view','tables',NULL,'2026-08-25 16:55:21'),(17,'tables.manage','tables',NULL,'2026-08-25 16:55:21'),(18,'tables.update_status','tables',NULL,'2026-08-25 16:55:21'),(19,'reservations.view','reservations',NULL,'2026-08-25 16:55:21'),(20,'reservations.create','reservations',NULL,'2026-08-25 16:55:21'),(21,'reservations.update','reservations',NULL,'2026-08-25 16:55:21'),(22,'reservations.cancel','reservations',NULL,'2026-08-25 16:55:21'),(23,'kitchen.view','kitchen',NULL,'2026-08-25 16:55:21'),(24,'kitchen.update_status','kitchen',NULL,'2026-08-25 16:55:21'),(25,'inventory.view','inventory',NULL,'2026-08-25 16:55:21'),(26,'inventory.receive','inventory',NULL,'2026-08-25 16:55:21'),(27,'inventory.adjust','inventory',NULL,'2026-08-25 16:55:21'),(28,'inventory.waste','inventory',NULL,'2026-08-25 16:55:21'),(29,'inventory.transfer','inventory',NULL,'2026-08-25 16:55:21'),(30,'inventory.opname','inventory',NULL,'2026-08-25 16:55:21'),(31,'purchases.view','purchases',NULL,'2026-08-25 16:55:21'),(32,'purchases.create','purchases',NULL,'2026-08-25 16:55:21'),(33,'purchases.update','purchases',NULL,'2026-08-25 16:55:21'),(34,'purchases.approve','purchases',NULL,'2026-08-25 16:55:21'),(35,'suppliers.view','suppliers',NULL,'2026-08-25 16:55:21'),(36,'suppliers.manage','suppliers',NULL,'2026-08-25 16:55:21'),(37,'expenses.view','expenses',NULL,'2026-08-25 16:55:21'),(38,'expenses.create','expenses',NULL,'2026-08-25 16:55:21'),(39,'expenses.approve','expenses',NULL,'2026-08-25 16:55:21'),(40,'employees.view','employees',NULL,'2026-08-25 16:55:21'),(41,'employees.manage','employees',NULL,'2026-08-25 16:55:21'),(42,'attendance.view','attendance',NULL,'2026-08-25 16:55:21'),(43,'attendance.manage','attendance',NULL,'2026-08-25 16:55:21'),(44,'payroll.view','payroll',NULL,'2026-08-25 16:55:21'),(45,'payroll.process','payroll',NULL,'2026-08-25 16:55:21'),(46,'payroll.approve','payroll',NULL,'2026-08-25 16:55:21'),(47,'reports.sales','reports',NULL,'2026-08-25 16:55:21'),(48,'reports.expense','reports',NULL,'2026-08-25 16:55:21'),(49,'reports.profit','reports',NULL,'2026-08-25 16:55:21'),(50,'reports.inventory','reports',NULL,'2026-08-25 16:55:21'),(51,'reports.payroll','reports',NULL,'2026-08-25 16:55:21'),(52,'reports.export','reports',NULL,'2026-08-25 16:55:21'),(53,'users.manage','users',NULL,'2026-08-25 16:55:21'),(54,'settings.manage','settings',NULL,'2026-08-25 16:55:21'),(55,'audit.view','audit',NULL,'2026-08-25 16:55:21'); /*!40000 ALTER TABLE `permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `purchase_order_items` -- DROP TABLE IF EXISTS `purchase_order_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `purchase_order_items` ( `id` int NOT NULL AUTO_INCREMENT, `po_id` int NOT NULL, `ingredient_id` int NOT NULL, `quantity` decimal(10,2) NOT NULL, `unit_price` decimal(12,2) NOT NULL, `subtotal` decimal(14,2) NOT NULL, `received_quantity` decimal(10,2) DEFAULT '0.00', PRIMARY KEY (`id`), KEY `po_id` (`po_id`), KEY `ingredient_id` (`ingredient_id`), CONSTRAINT `purchase_order_items_ibfk_1` FOREIGN KEY (`po_id`) REFERENCES `purchase_orders` (`id`) ON DELETE CASCADE, CONSTRAINT `purchase_order_items_ibfk_2` FOREIGN KEY (`ingredient_id`) REFERENCES `ingredients` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `purchase_order_items` -- LOCK TABLES `purchase_order_items` WRITE; /*!40000 ALTER TABLE `purchase_order_items` DISABLE KEYS */; /*!40000 ALTER TABLE `purchase_order_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `purchase_orders` -- DROP TABLE IF EXISTS `purchase_orders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `purchase_orders` ( `id` int NOT NULL AUTO_INCREMENT, `po_number` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `supplier_id` int NOT NULL, `order_date` date NOT NULL, `expected_date` date DEFAULT NULL, `status` enum('draft','ordered','partial','received','completed','cancelled') COLLATE utf8mb4_unicode_ci DEFAULT 'draft', `subtotal` decimal(14,2) DEFAULT '0.00', `tax_amount` decimal(14,2) DEFAULT '0.00', `total` decimal(14,2) DEFAULT '0.00', `notes` text COLLATE utf8mb4_unicode_ci, `created_by` int NOT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `po_number` (`po_number`), KEY `supplier_id` (`supplier_id`), KEY `created_by` (`created_by`), CONSTRAINT `purchase_orders_ibfk_1` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`), CONSTRAINT `purchase_orders_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `purchase_orders` -- LOCK TABLES `purchase_orders` WRITE; /*!40000 ALTER TABLE `purchase_orders` DISABLE KEYS */; /*!40000 ALTER TABLE `purchase_orders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `recipe_items` -- DROP TABLE IF EXISTS `recipe_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `recipe_items` ( `id` int NOT NULL AUTO_INCREMENT, `recipe_id` int NOT NULL, `ingredient_id` int NOT NULL, `quantity` decimal(10,4) NOT NULL, `unit_id` int NOT NULL, `notes` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `recipe_id` (`recipe_id`), KEY `ingredient_id` (`ingredient_id`), KEY `unit_id` (`unit_id`), CONSTRAINT `recipe_items_ibfk_1` FOREIGN KEY (`recipe_id`) REFERENCES `recipes` (`id`) ON DELETE CASCADE, CONSTRAINT `recipe_items_ibfk_2` FOREIGN KEY (`ingredient_id`) REFERENCES `ingredients` (`id`), CONSTRAINT `recipe_items_ibfk_3` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `recipe_items` -- LOCK TABLES `recipe_items` WRITE; /*!40000 ALTER TABLE `recipe_items` DISABLE KEYS */; INSERT INTO `recipe_items` VALUES (1,1,1,0.5000,1,NULL),(2,1,11,0.0500,2,NULL),(3,1,12,0.0300,2,NULL),(4,1,13,0.0200,2,NULL),(5,1,17,0.0200,3,NULL),(6,1,18,0.0100,3,NULL),(7,2,9,0.3000,1,NULL),(8,2,8,1.0000,5,NULL),(9,2,11,0.0200,2,NULL),(10,2,12,0.0100,2,NULL),(11,2,13,0.0100,2,NULL),(12,2,17,0.0150,3,NULL),(13,2,18,0.0100,3,NULL),(14,3,3,0.1000,1,NULL),(15,3,4,0.0500,1,NULL),(16,3,14,0.0500,1,NULL),(17,3,11,0.0200,2,NULL),(18,3,12,0.0100,2,NULL),(19,3,13,0.0100,2,NULL),(20,3,20,0.0050,2,NULL),(21,1,1,0.5000,1,NULL),(22,1,11,0.0500,2,NULL),(23,1,12,0.0300,2,NULL),(24,1,13,0.0200,2,NULL),(25,1,17,0.0200,3,NULL),(26,1,18,0.0100,3,NULL),(27,2,9,0.3000,1,NULL),(28,2,8,1.0000,5,NULL),(29,2,11,0.0200,2,NULL),(30,2,12,0.0100,2,NULL),(31,2,13,0.0100,2,NULL),(32,2,17,0.0150,3,NULL),(33,2,18,0.0100,3,NULL),(34,3,3,0.1000,1,NULL),(35,3,4,0.0500,1,NULL),(36,3,14,0.0500,1,NULL),(37,3,11,0.0200,2,NULL),(38,3,12,0.0100,2,NULL),(39,3,13,0.0100,2,NULL),(40,3,20,0.0050,2,NULL),(41,1,1,0.5000,1,NULL),(42,1,11,0.0500,2,NULL),(43,1,12,0.0300,2,NULL),(44,1,13,0.0200,2,NULL),(45,1,17,0.0200,3,NULL),(46,1,18,0.0100,3,NULL),(47,2,9,0.3000,1,NULL),(48,2,8,1.0000,5,NULL),(49,2,11,0.0200,2,NULL),(50,2,12,0.0100,2,NULL),(51,2,13,0.0100,2,NULL),(52,2,17,0.0150,3,NULL),(53,2,18,0.0100,3,NULL),(54,3,3,0.1000,1,NULL),(55,3,4,0.0500,1,NULL),(56,3,14,0.0500,1,NULL),(57,3,11,0.0200,2,NULL),(58,3,12,0.0100,2,NULL),(59,3,13,0.0100,2,NULL),(60,3,20,0.0050,2,NULL); /*!40000 ALTER TABLE `recipe_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `recipes` -- DROP TABLE IF EXISTS `recipes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `recipes` ( `id` int NOT NULL AUTO_INCREMENT, `menu_id` int NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `estimated_cost` decimal(12,2) DEFAULT '0.00', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `menu_id` (`menu_id`), CONSTRAINT `recipes_ibfk_1` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `recipes` -- LOCK TABLES `recipes` WRITE; /*!40000 ALTER TABLE `recipes` DISABLE KEYS */; INSERT INTO `recipes` VALUES (1,4,'Resep Ikan Bakar Khas Joglo Koi',24000.00,'2026-08-25 16:55:21','2026-08-25 16:55:21'),(2,9,'Resep Nasi Goreng Spesial',12000.00,'2026-08-25 16:55:21','2026-08-25 16:55:21'),(3,12,'Resep Tom Yum Seafood',15000.00,'2026-08-25 16:55:21','2026-08-25 16:55:21'); /*!40000 ALTER TABLE `recipes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `refunds` -- DROP TABLE IF EXISTS `refunds`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `refunds` ( `id` int NOT NULL AUTO_INCREMENT, `refund_number` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `order_id` int NOT NULL, `payment_id` int NOT NULL, `amount` decimal(14,2) NOT NULL, `reason` text COLLATE utf8mb4_unicode_ci NOT NULL, `status` enum('pending','approved','rejected','completed') COLLATE utf8mb4_unicode_ci DEFAULT 'pending', `approved_by` int DEFAULT NULL, `approved_at` timestamp NULL DEFAULT NULL, `created_by` int NOT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `refund_number` (`refund_number`), KEY `order_id` (`order_id`), KEY `payment_id` (`payment_id`), KEY `created_by` (`created_by`), KEY `approved_by` (`approved_by`), CONSTRAINT `refunds_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`), CONSTRAINT `refunds_ibfk_2` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`id`), CONSTRAINT `refunds_ibfk_3` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`), CONSTRAINT `refunds_ibfk_4` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `refunds` -- LOCK TABLES `refunds` WRITE; /*!40000 ALTER TABLE `refunds` DISABLE KEYS */; /*!40000 ALTER TABLE `refunds` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `reservations` -- DROP TABLE IF EXISTS `reservations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `reservations` ( `id` int NOT NULL AUTO_INCREMENT, `reservation_number` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `customer_id` int DEFAULT NULL, `customer_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `customer_phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reservation_date` date NOT NULL, `reservation_time` time NOT NULL, `duration_minutes` int DEFAULT '120', `party_size` int NOT NULL, `table_id` int DEFAULT NULL, `notes` text COLLATE utf8mb4_unicode_ci, `special_requests` text COLLATE utf8mb4_unicode_ci, `status` enum('pending','confirmed','arrived','seated','completed','cancelled','no_show') COLLATE utf8mb4_unicode_ci DEFAULT 'pending', `created_by` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `reservation_number` (`reservation_number`), KEY `customer_id` (`customer_id`), KEY `table_id` (`table_id`), KEY `created_by` (`created_by`), CONSTRAINT `reservations_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`), CONSTRAINT `reservations_ibfk_2` FOREIGN KEY (`table_id`) REFERENCES `restaurant_tables` (`id`), CONSTRAINT `reservations_ibfk_3` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `reservations` -- LOCK TABLES `reservations` WRITE; /*!40000 ALTER TABLE `reservations` DISABLE KEYS */; INSERT INTO `reservations` VALUES (1,'RES-20260826-0001',19,'xixixi','08899071726','2026-08-28','11:00:00',120,2,10,'Romantis','Bucket','completed',1,'2026-08-26 16:46:56','2026-08-29 11:36:47'); /*!40000 ALTER TABLE `reservations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `restaurant_tables` -- DROP TABLE IF EXISTS `restaurant_tables`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `restaurant_tables` ( `id` int NOT NULL AUTO_INCREMENT, `area_id` int NOT NULL, `number` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `capacity` int NOT NULL DEFAULT '4', `status` enum('available','reserved','occupied','cleaning','maintenance') COLLATE utf8mb4_unicode_ci DEFAULT 'available', `is_active` tinyint(1) DEFAULT '1', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `qr_token` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `number` (`number`), UNIQUE KEY `idx_qr_token` (`qr_token`), KEY `area_id` (`area_id`), CONSTRAINT `restaurant_tables_ibfk_1` FOREIGN KEY (`area_id`) REFERENCES `table_areas` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `restaurant_tables` -- LOCK TABLES `restaurant_tables` WRITE; /*!40000 ALTER TABLE `restaurant_tables` DISABLE KEYS */; INSERT INTO `restaurant_tables` VALUES (1,1,'J-01','Joglo Meja 1',4,'available',1,'2026-08-25 16:55:21','2026-09-05 12:42:22','4df85c4b-5bd1af99-7a5888f9'),(2,1,'J-02','Joglo Meja 2',4,'available',1,'2026-08-25 16:55:21','2026-08-28 16:00:01','d84c7988-07bca15c-88095ad0'),(3,1,'J-03','Joglo Meja 3',6,'available',1,'2026-08-25 16:55:21','2026-08-28 16:00:01','30646856-9b977a5b-972321a9'),(4,1,'J-04','Joglo Meja 4',8,'available',1,'2026-08-25 16:55:21','2026-08-28 16:00:01','42161f30-15358ef7-8a65cc95'),(5,2,'K-01','Koi Meja 1',4,'available',1,'2026-08-25 16:55:21','2026-08-29 11:37:59','8ff6c5bf-1c48439c-6219cdbf'),(6,2,'K-02','Koi Meja 2',4,'available',1,'2026-08-25 16:55:21','2026-08-28 16:00:01','df321723-52011e15-a3845316'),(7,2,'K-03','Koi Meja 3',6,'available',1,'2026-08-25 16:55:21','2026-08-28 16:00:01','49f9c226-883bd769-e4dcfe6b'),(8,3,'T-01','Taman Meja 1',4,'available',1,'2026-08-25 16:55:21','2026-08-28 16:00:01','22a97263-5455a546-01a286cf'),(9,3,'T-02','Taman Meja 2',6,'available',1,'2026-08-25 16:55:21','2026-08-28 16:00:01','1dbd51f4-dc408e50-a112c890'),(10,4,'V-01','VIP Ruangan 1',10,'occupied',1,'2026-08-25 16:55:21','2026-08-29 12:05:48','5a8d018f-75fcd4af-0b6604d8'),(11,4,'V-02','VIP Ruangan 2',15,'available',1,'2026-08-25 16:55:21','2026-09-05 09:17:40','14894647-d6f6343d-7cdeddbf'),(24,1,'J-10','Meja Joglo 10',2,'available',1,'2026-08-26 16:45:33','2026-08-28 16:00:01','abf9917c-8354d51e-f999f381'); /*!40000 ALTER TABLE `restaurant_tables` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `role_permissions` -- DROP TABLE IF EXISTS `role_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `role_permissions` ( `role_id` int NOT NULL, `permission_id` int NOT NULL, PRIMARY KEY (`role_id`,`permission_id`), KEY `permission_id` (`permission_id`), CONSTRAINT `role_permissions_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE, CONSTRAINT `role_permissions_ibfk_2` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `role_permissions` -- LOCK TABLES `role_permissions` WRITE; /*!40000 ALTER TABLE `role_permissions` DISABLE KEYS */; INSERT INTO `role_permissions` VALUES (1,1),(2,1),(3,1),(4,1),(1,2),(2,2),(4,2),(1,3),(2,3),(1,4),(1,5),(2,5),(1,6),(4,6),(1,7),(2,7),(1,8),(2,8),(1,9),(2,9),(1,10),(2,10),(1,11),(1,12),(1,13),(1,14),(1,15),(1,16),(2,16),(1,17),(1,18),(2,18),(1,19),(2,19),(4,19),(1,20),(2,20),(1,21),(4,21),(1,22),(1,23),(2,23),(1,24),(1,25),(3,25),(1,26),(3,26),(1,27),(3,27),(1,28),(3,28),(1,29),(3,29),(1,30),(3,30),(1,31),(3,31),(1,32),(3,32),(1,33),(3,33),(1,34),(1,35),(3,35),(1,36),(3,36),(1,37),(4,37),(1,38),(4,38),(1,39),(4,39),(1,40),(4,40),(1,41),(4,41),(1,42),(4,42),(1,43),(4,43),(1,44),(4,44),(1,45),(4,45),(1,46),(4,46),(1,47),(2,47),(4,47),(1,48),(4,48),(1,49),(4,49),(1,50),(3,50),(1,51),(4,51),(1,52),(4,52),(1,53),(1,54),(1,55); /*!40000 ALTER TABLE `role_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `roles` -- DROP TABLE IF EXISTS `roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `roles` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `roles` -- LOCK TABLES `roles` WRITE; /*!40000 ALTER TABLE `roles` DISABLE KEYS */; INSERT INTO `roles` VALUES (1,'Super Admin','Akses penuh ke seluruh sistem','2026-08-25 16:55:20','2026-08-25 16:55:20'),(2,'Kasir','Mengelola POS, order, dan pembayaran','2026-08-25 16:55:20','2026-08-25 16:55:20'),(3,'Admin Gudang','Mengelola stok, pembelian, dan supplier','2026-08-25 16:55:20','2026-08-25 16:55:20'),(4,'Manager','Mengelola karyawan, payroll, dan laporan','2026-08-25 16:55:20','2026-08-25 16:55:20'); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `settings` -- DROP TABLE IF EXISTS `settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `settings` ( `id` int NOT NULL AUTO_INCREMENT, `setting_key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `setting_value` text COLLATE utf8mb4_unicode_ci, `setting_type` enum('text','number','boolean','json','file') COLLATE utf8mb4_unicode_ci DEFAULT 'text', `description` text COLLATE utf8mb4_unicode_ci, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `setting_key` (`setting_key`) ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings` -- LOCK TABLES `settings` WRITE; /*!40000 ALTER TABLE `settings` DISABLE KEYS */; INSERT INTO `settings` VALUES (1,'restaurant_name','Joglo Koi Restaurant','text','Nama restoran','2026-08-25 16:55:22'),(2,'restaurant_address','Lembu, Jimus, Polanharjo, Klaten, Jawa Tengah','text','Alamat restoran','2026-08-25 16:55:22'),(3,'restaurant_phone','0878-1810-9887','text','Nomor telepon','2026-08-25 16:55:22'),(4,'restaurant_instagram','@joglokoirestaurant','text','Instagram','2026-08-25 16:55:22'),(5,'tax_rate','10','number','Persentase pajak (PPN)','2026-08-25 16:55:22'),(6,'service_charge','5','number','Persentase service charge','2026-08-25 16:55:22'),(7,'currency','IDR','text','Mata uang','2026-08-25 16:55:22'),(8,'timezone','Asia/Jakarta','text','Timezone','2026-08-25 16:55:22'),(9,'receipt_footer','Terima kasih telah berkunjung ke Joglo Koi Restaurant!\nSelamat menikmati hidangan Anda.','text','Footer struk','2026-08-25 16:55:22'),(10,'low_stock_threshold','5','number','Batas minimum stok untuk alert','2026-08-25 16:55:22'),(11,'opening_hours_monday','10:00-22:00','text','Jam buka Senin','2026-08-25 16:55:22'),(12,'opening_hours_tuesday','10:00-22:00','text','Jam buka Selasa','2026-08-25 16:55:22'),(13,'opening_hours_wednesday','10:00-22:00','text','Jam buka Rabu','2026-08-25 16:55:22'),(14,'opening_hours_thursday','10:00-22:00','text','Jam buka Kamis','2026-08-25 16:55:22'),(15,'opening_hours_friday','10:00-22:00','text','Jam buka Jumat','2026-08-25 16:55:22'),(16,'opening_hours_saturday','10:00-23:00','text','Jam buka Sabtu','2026-08-25 16:55:22'),(17,'opening_hours_sunday','10:00-22:00','text','Jam buka Minggu','2026-08-25 16:55:22'); /*!40000 ALTER TABLE `settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `stock_opname_items` -- DROP TABLE IF EXISTS `stock_opname_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `stock_opname_items` ( `id` int NOT NULL AUTO_INCREMENT, `opname_id` int NOT NULL, `ingredient_id` int NOT NULL, `system_stock` decimal(10,2) NOT NULL, `actual_stock` decimal(10,2) NOT NULL, `variance` decimal(10,2) GENERATED ALWAYS AS ((`actual_stock` - `system_stock`)) STORED, `reason` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `opname_id` (`opname_id`), KEY `ingredient_id` (`ingredient_id`), CONSTRAINT `stock_opname_items_ibfk_1` FOREIGN KEY (`opname_id`) REFERENCES `stock_opnames` (`id`) ON DELETE CASCADE, CONSTRAINT `stock_opname_items_ibfk_2` FOREIGN KEY (`ingredient_id`) REFERENCES `ingredients` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `stock_opname_items` -- LOCK TABLES `stock_opname_items` WRITE; /*!40000 ALTER TABLE `stock_opname_items` DISABLE KEYS */; /*!40000 ALTER TABLE `stock_opname_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `stock_opnames` -- DROP TABLE IF EXISTS `stock_opnames`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `stock_opnames` ( `id` int NOT NULL AUTO_INCREMENT, `opname_number` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `warehouse_id` int DEFAULT '1', `opname_date` date NOT NULL, `status` enum('draft','completed','approved') COLLATE utf8mb4_unicode_ci DEFAULT 'draft', `notes` text COLLATE utf8mb4_unicode_ci, `created_by` int NOT NULL, `approved_by` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `opname_number` (`opname_number`), KEY `warehouse_id` (`warehouse_id`), KEY `created_by` (`created_by`), KEY `approved_by` (`approved_by`), CONSTRAINT `stock_opnames_ibfk_1` FOREIGN KEY (`warehouse_id`) REFERENCES `warehouses` (`id`), CONSTRAINT `stock_opnames_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`), CONSTRAINT `stock_opnames_ibfk_3` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `stock_opnames` -- LOCK TABLES `stock_opnames` WRITE; /*!40000 ALTER TABLE `stock_opnames` DISABLE KEYS */; /*!40000 ALTER TABLE `stock_opnames` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `suppliers` -- DROP TABLE IF EXISTS `suppliers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `suppliers` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `contact_person` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `whatsapp` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` text COLLATE utf8mb4_unicode_ci, `npwp` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bank_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bank_account` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bank_account_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `notes` text COLLATE utf8mb4_unicode_ci, `is_active` tinyint(1) DEFAULT '1', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `suppliers` -- LOCK TABLES `suppliers` WRITE; /*!40000 ALTER TABLE `suppliers` DISABLE KEYS */; INSERT INTO `suppliers` VALUES (1,'Toko Ikan Segar Pak Budi','Pak Budi','0812-3456-7890','0812-3456-7890',NULL,'Pasar Ikan Klaten',NULL,NULL,NULL,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(2,'Distributor Daging Sapi Mas Joko','Mas Joko','0856-7890-1234','0856-7890-1234',NULL,'Solo',NULL,NULL,NULL,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(3,'Sayur Segar Bu Ani','Bu Ani','0878-9012-3456','0878-9012-3456',NULL,'Pasar Tradisional Polanharjo',NULL,NULL,NULL,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(4,'Minyak & Bumbu Berkah','Pak Harto','0813-4567-8901','0813-4567-8901',NULL,'Grosir Bumbu Klaten',NULL,NULL,NULL,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(5,'Toko Minuman Segar','Mas Dwi','0821-6789-0123','0821-6789-0123',NULL,'Distributor Minuman Klaten',NULL,NULL,NULL,NULL,NULL,1,'2026-08-25 16:55:21','2026-08-25 16:55:21',NULL),(6,'Toko Ikan Segar Pak Budi','Pak Budi','0812-3456-7890','0812-3456-7890',NULL,'Pasar Ikan Klaten',NULL,NULL,NULL,NULL,NULL,1,'2026-08-25 16:59:26','2026-08-25 16:59:26',NULL),(7,'Distributor Daging Sapi Mas Joko','Mas Joko','0856-7890-1234','0856-7890-1234',NULL,'Solo',NULL,NULL,NULL,NULL,NULL,1,'2026-08-25 16:59:26','2026-08-25 16:59:26',NULL),(8,'Sayur Segar Bu Ani','Bu Ani','0878-9012-3456','0878-9012-3456',NULL,'Pasar Tradisional Polanharjo',NULL,NULL,NULL,NULL,NULL,1,'2026-08-25 16:59:26','2026-08-25 16:59:26',NULL),(9,'Minyak & Bumbu Berkah','Pak Harto','0813-4567-8901','0813-4567-8901',NULL,'Grosir Bumbu Klaten',NULL,NULL,NULL,NULL,NULL,1,'2026-08-25 16:59:26','2026-08-25 16:59:26',NULL),(10,'Toko Minuman Segar','Mas Dwi','0821-6789-0123','0821-6789-0123',NULL,'Distributor Minuman Klaten',NULL,NULL,NULL,NULL,NULL,1,'2026-08-25 16:59:26','2026-08-25 16:59:26',NULL),(11,'Toko Ikan Segar Pak Budi','Pak Budi','0812-3456-7890','0812-3456-7890',NULL,'Pasar Ikan Klaten',NULL,NULL,NULL,NULL,NULL,1,'2026-08-25 17:11:55','2026-08-25 17:11:55',NULL),(12,'Distributor Daging Sapi Mas Joko','Mas Joko','0856-7890-1234','0856-7890-1234',NULL,'Solo',NULL,NULL,NULL,NULL,NULL,1,'2026-08-25 17:11:55','2026-08-25 17:11:55',NULL),(13,'Sayur Segar Bu Ani','Bu Ani','0878-9012-3456','0878-9012-3456',NULL,'Pasar Tradisional Polanharjo',NULL,NULL,NULL,NULL,NULL,1,'2026-08-25 17:11:55','2026-08-25 17:11:55',NULL),(14,'Minyak & Bumbu Berkah','Pak Harto','0813-4567-8901','0813-4567-8901',NULL,'Grosir Bumbu Klaten',NULL,NULL,NULL,NULL,NULL,1,'2026-08-25 17:11:55','2026-08-25 17:11:55',NULL),(15,'Toko Minuman Segar','Mas Dwi','0821-6789-0123','0821-6789-0123',NULL,'Distributor Minuman Klaten',NULL,NULL,NULL,NULL,NULL,1,'2026-08-25 17:11:55','2026-08-25 17:11:55',NULL),(16,'ex','ex','0888','08888','ex@gmail.com','ex',NULL,'bri','8977','ex','ex',1,'2026-08-26 03:02:04','2026-08-26 03:02:04',NULL); /*!40000 ALTER TABLE `suppliers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `table_areas` -- DROP TABLE IF EXISTS `table_areas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `table_areas` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `sort_order` int DEFAULT '0', `is_active` tinyint(1) DEFAULT '1', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `table_areas` -- LOCK TABLES `table_areas` WRITE; /*!40000 ALTER TABLE `table_areas` DISABLE KEYS */; INSERT INTO `table_areas` VALUES (1,'Area Joglo','Area utama dengan konsep joglo',1,1,'2026-08-25 16:55:21','2026-08-25 16:55:21'),(2,'Area Kolam Koi','Area dekat kolam ikan koi',2,1,'2026-08-25 16:55:21','2026-08-25 16:55:21'),(3,'Area Taman','Area outdoor taman',3,1,'2026-08-25 16:55:21','2026-08-25 16:55:21'),(4,'Area VIP','Area privat untuk acara khusus',4,1,'2026-08-25 16:55:21','2026-08-25 16:55:21'),(5,'Area Joglo','Area utama dengan konsep joglo',1,0,'2026-08-25 16:59:26','2026-08-26 03:40:27'),(6,'Area Kolam Koi','Area dekat kolam ikan koi',2,0,'2026-08-25 16:59:26','2026-08-26 16:45:39'),(7,'Area Taman','Area outdoor taman',3,1,'2026-08-25 16:59:26','2026-08-25 16:59:26'),(8,'Area VIP','Area privat untuk acara khusus',4,1,'2026-08-25 16:59:26','2026-08-25 16:59:26'),(9,'Area Joglo','Area utama dengan konsep joglo',1,0,'2026-08-25 17:11:55','2026-08-26 04:19:28'),(10,'Area Kolam Koi','Area dekat kolam ikan koi',2,0,'2026-08-25 17:11:55','2026-08-26 04:21:18'),(11,'Area Taman','Area outdoor taman',3,0,'2026-08-25 17:11:55','2026-08-26 16:45:47'),(12,'Area VIP','Area privat untuk acara khusus',4,1,'2026-08-25 17:11:55','2026-08-25 17:11:55'); /*!40000 ALTER TABLE `table_areas` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `table_leads` -- DROP TABLE IF EXISTS `table_leads`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `table_leads` ( `id` int NOT NULL AUTO_INCREMENT, `table_id` int NOT NULL, `order_id` int DEFAULT NULL, `customer_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `whatsapp` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `instagram` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `tiktok` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `facebook` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `notes` text COLLATE utf8mb4_unicode_ci, `is_converted` tinyint(1) DEFAULT '0', `converted_customer_id` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `table_id` (`table_id`), KEY `order_id` (`order_id`), KEY `converted_customer_id` (`converted_customer_id`), CONSTRAINT `table_leads_ibfk_1` FOREIGN KEY (`table_id`) REFERENCES `restaurant_tables` (`id`) ON DELETE CASCADE, CONSTRAINT `table_leads_ibfk_2` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE SET NULL, CONSTRAINT `table_leads_ibfk_3` FOREIGN KEY (`converted_customer_id`) REFERENCES `customers` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `table_leads` -- LOCK TABLES `table_leads` WRITE; /*!40000 ALTER TABLE `table_leads` DISABLE KEYS */; INSERT INTO `table_leads` VALUES (1,3,NULL,'ahsan','088299067272',NULL,'','','','manahhati0@gmail.com','',0,NULL,'2026-09-05 08:45:01'); /*!40000 ALTER TABLE `table_leads` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `table_messages` -- DROP TABLE IF EXISTS `table_messages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `table_messages` ( `id` int NOT NULL AUTO_INCREMENT, `table_id` int NOT NULL, `order_id` int DEFAULT NULL, `sender_type` enum('customer','cashier','system') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'customer', `sender_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `message_type` enum('order','add_item','question','call_staff','payment','complaint','info','lead') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'info', `message` text COLLATE utf8mb4_unicode_ci NOT NULL, `extra_data` json DEFAULT NULL, `is_read` tinyint(1) DEFAULT '0', `read_by` int DEFAULT NULL, `read_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `table_id` (`table_id`), KEY `order_id` (`order_id`), KEY `read_by` (`read_by`), CONSTRAINT `table_messages_ibfk_1` FOREIGN KEY (`table_id`) REFERENCES `restaurant_tables` (`id`) ON DELETE CASCADE, CONSTRAINT `table_messages_ibfk_2` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE SET NULL, CONSTRAINT `table_messages_ibfk_3` FOREIGN KEY (`read_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `table_messages` -- LOCK TABLES `table_messages` WRITE; /*!40000 ALTER TABLE `table_messages` DISABLE KEYS */; INSERT INTO `table_messages` VALUES (1,10,NULL,'customer','Pelanggan Meja V-01','call_staff','Mohon datang ke meja, terima kasih.',NULL,0,NULL,NULL,'2026-08-29 12:06:53'),(2,10,NULL,'cashier','Super Admin','info','iya sebentar kak',NULL,0,NULL,NULL,'2026-08-29 12:07:26'),(3,10,NULL,'customer','Pelanggan Meja V-01','question','Mohon info mengenai pesanan saya.',NULL,0,NULL,NULL,'2026-08-29 12:07:49'),(4,3,NULL,'customer','ahsan','lead','Lead baru dari Meja J-03','{\"name\": \"ahsan\", \"phone\": \"088299067272\"}',1,1,'2026-09-05 09:14:02','2026-09-05 08:45:01'),(5,3,NULL,'customer','Pelanggan Meja J-03','payment','Saya mau bayar, tolong siapkan.',NULL,1,1,'2026-09-05 09:14:02','2026-09-05 08:53:26'),(6,3,NULL,'customer','Pelanggan Meja J-03','question','Mohon info mengenai pesanan saya.',NULL,1,1,'2026-09-05 09:14:02','2026-09-05 08:53:43'),(7,11,33,'customer','ahsan','add_item','Item ditambahkan ke KOI-20260905-0002 dari Meja V-02: +2 item','{\"items\": [\"Grilled Fish Platter\", \"Mie Goreng Jawa\"], \"total\": 195500, \"is_merge\": true, \"order_number\": \"KOI-20260905-0002\"}',1,1,'2026-09-05 09:18:06','2026-09-05 09:16:11'),(8,1,NULL,'customer','Pelanggan Meja J-01','question','Mohon info mengenai pesanan saya.',NULL,1,2,'2026-09-05 12:40:39','2026-09-05 12:17:26'),(9,1,NULL,'cashier','Super Admin','info','sebentar kak, baru dimasak',NULL,1,2,'2026-09-05 12:40:39','2026-09-05 12:18:13'),(10,1,34,'customer','ahsan','order','Pesanan baru dari Meja J-01: 3 item','{\"items\": [\"Grilled Fish Platter\", \"Short Ribs\", \"Nasi Goreng Spesial\"], \"total\": 233450, \"is_merge\": false, \"order_number\": \"TBL-20260905-0003\"}',1,2,'2026-09-05 12:40:39','2026-09-05 12:18:45'); /*!40000 ALTER TABLE `table_messages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `units` -- DROP TABLE IF EXISTS `units`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `units` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `abbreviation` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `units` -- LOCK TABLES `units` WRITE; /*!40000 ALTER TABLE `units` DISABLE KEYS */; INSERT INTO `units` VALUES (1,'Kilogram','Kg'),(2,'Gram','g'),(3,'Liter','L'),(4,'Mililiter','ml'),(5,'Pieces','Pcs'),(6,'Box','Box'),(7,'Pack','Pack'),(8,'Botol','Botol'),(9,'Dus','Dus'),(10,'Ikat','Ikat'),(11,'Kilogram','Kg'),(12,'Gram','g'),(13,'Liter','L'),(14,'Mililiter','ml'),(15,'Pieces','Pcs'),(16,'Box','Box'),(17,'Pack','Pack'),(18,'Botol','Botol'),(19,'Dus','Dus'),(20,'Ikat','Ikat'),(21,'Kilogram','Kg'),(22,'Gram','g'),(23,'Liter','L'),(24,'Mililiter','ml'),(25,'Pieces','Pcs'),(26,'Box','Box'),(27,'Pack','Pack'),(28,'Botol','Botol'),(29,'Dus','Dus'),(30,'Ikat','Ikat'); /*!40000 ALTER TABLE `units` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` int NOT NULL AUTO_INCREMENT, `username` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `password_hash` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `full_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `role_id` int NOT NULL, `is_active` tinyint(1) DEFAULT '1', `last_login_at` timestamp NULL DEFAULT NULL, `login_attempts` int DEFAULT '0', `locked_until` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`), KEY `role_id` (`role_id`), CONSTRAINT `users_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'superadmin','$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi','Super Admin','admin@jogloKoi.com',NULL,NULL,1,1,'2026-09-05 12:09:11',0,NULL,'2026-08-25 16:55:21','2026-09-05 12:09:11',NULL),(2,'kasir','$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi','Kasir Utama','kasir@jogloKoi.com',NULL,NULL,2,1,'2026-09-05 12:40:23',0,NULL,'2026-08-25 16:55:21','2026-09-05 12:40:23',NULL),(3,'gudang','$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi','Admin Gudang','gudang@jogloKoi.com',NULL,NULL,3,1,'2026-08-28 16:01:37',0,NULL,'2026-08-25 16:55:21','2026-08-28 16:01:37',NULL),(4,'manager','$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi','Manager','manager@jogloKoi.com',NULL,NULL,4,1,'2026-08-28 03:46:01',0,NULL,'2026-08-25 16:55:21','2026-08-28 03:46:01',NULL); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `warehouses` -- DROP TABLE IF EXISTS `warehouses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `warehouses` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `is_active` tinyint(1) DEFAULT '1', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `warehouses` -- LOCK TABLES `warehouses` WRITE; /*!40000 ALTER TABLE `warehouses` DISABLE KEYS */; INSERT INTO `warehouses` VALUES (1,'Gudang Utama','Gudang utama penyimpanan bahan',1,'2026-08-25 16:55:21'),(2,'Dapur','Penyimpanan bahan di dapur',1,'2026-08-25 16:55:21'),(3,'Bar','Penyimpanan bahan minuman',1,'2026-08-25 16:55:21'),(4,'Gudang Utama','Gudang utama penyimpanan bahan',1,'2026-08-25 16:59:26'),(5,'Dapur','Penyimpanan bahan di dapur',1,'2026-08-25 16:59:26'),(6,'Bar','Penyimpanan bahan minuman',1,'2026-08-25 16:59:26'),(7,'Gudang Utama','Gudang utama penyimpanan bahan',1,'2026-08-25 17:11:55'),(8,'Dapur','Penyimpanan bahan di dapur',1,'2026-08-25 17:11:55'),(9,'Bar','Penyimpanan bahan minuman',1,'2026-08-25 17:11:55'); /*!40000 ALTER TABLE `warehouses` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `wastes` -- DROP TABLE IF EXISTS `wastes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `wastes` ( `id` int NOT NULL AUTO_INCREMENT, `waste_number` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `ingredient_id` int NOT NULL, `quantity` decimal(10,2) NOT NULL, `reason` enum('expired','damaged','spoiled','wrong_order','spilled','other') COLLATE utf8mb4_unicode_ci NOT NULL, `notes` text COLLATE utf8mb4_unicode_ci, `estimated_loss` decimal(12,2) DEFAULT '0.00', `status` enum('pending','approved') COLLATE utf8mb4_unicode_ci DEFAULT 'pending', `user_id` int NOT NULL, `approved_by` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `waste_number` (`waste_number`), KEY `ingredient_id` (`ingredient_id`), KEY `user_id` (`user_id`), KEY `approved_by` (`approved_by`), CONSTRAINT `wastes_ibfk_1` FOREIGN KEY (`ingredient_id`) REFERENCES `ingredients` (`id`), CONSTRAINT `wastes_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`), CONSTRAINT `wastes_ibfk_3` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wastes` -- LOCK TABLES `wastes` WRITE; /*!40000 ALTER TABLE `wastes` DISABLE KEYS */; /*!40000 ALTER TABLE `wastes` 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-09-08 14:32:18