-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jan 02, 2026 at 05:30 PM -- Server version: 10.4.24-MariaDB -- PHP Version: 8.2.4 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `s0augs53` -- -- -------------------------------------------------------- -- -- Table structure for table `auth_identities` -- CREATE TABLE `auth_identities` ( `id` int(10) UNSIGNED NOT NULL, `user_id` int(10) UNSIGNED NOT NULL, `type` varchar(255) NOT NULL, `name` varchar(255) DEFAULT NULL, `secret` varchar(255) NOT NULL, `secret2` varchar(255) DEFAULT NULL, `expires` datetime DEFAULT NULL, `extra` text DEFAULT NULL, `force_reset` tinyint(1) NOT NULL DEFAULT 0, `last_used_at` datetime DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `auth_identities` -- INSERT INTO `auth_identities` (`id`, `user_id`, `type`, `name`, `secret`, `secret2`, `expires`, `extra`, `force_reset`, `last_used_at`, `created_at`, `updated_at`) VALUES (18, 29, 'email_password', NULL, 'customer', '$2y$12$kys5OH6jv06lu7e6YC.H2eR.PSDgjxyLbAZz/OO4R3DBBVCOYIgdu', NULL, NULL, 0, '2026-01-02 22:22:32', '2025-09-15 12:27:39', '2026-01-02 22:22:32'), (20, 31, 'email_password', NULL, 'admin', '$2y$12$v1axm.q5BD4a7cus92yRa.PDh7TP3jYLSOC87RLzUpXWfNhK0RABu', NULL, NULL, 0, '2026-01-02 07:47:43', '2025-09-15 14:43:18', '2026-01-02 07:47:43'), (21, 32, 'email_password', NULL, 'kepala_toko', '$2y$12$na2tqlmqfGGY4pe00IckmuEhJSGa6moRwRqsb/F6JdlPAwbIudEAW', NULL, NULL, 0, '2025-11-07 14:52:36', '2025-09-15 14:44:18', '2025-11-07 14:52:36'), (22, 33, 'email_password', NULL, 'kasir', '$2y$12$U08UTQipA/N7lsFRDFMhBOHKgFn.aR2KkS0j13N./b0O22PPs6G2S', NULL, NULL, 0, '2026-01-02 22:23:40', '2025-09-15 14:44:51', '2026-01-02 22:23:40'), (23, 34, 'email_password', NULL, 'customer2', '$2y$10$vjQ2gi4Fb9PtQlRiG34VN.e3bWixcyGz4egL9AlUQpSF26RM9K3RW', NULL, NULL, 0, NULL, '2025-09-15 15:39:42', '2025-09-15 15:39:42'), (34, 45, 'email_password', NULL, 'test', '$2y$12$mU4QqtPunwTci9QMaDNNIekBeI3f3L7MAOS.VKzGOKg8FBDm2.Su2', NULL, NULL, 0, '2025-10-05 16:12:41', '2025-10-05 16:10:17', '2025-10-05 16:12:41'), (36, 47, 'email_password', NULL, 'rangga', '$2y$12$Ivx94f8oBye9Kd3l2SncqOpnUQZ6Bz1Eib1EDVuyFXklvZqVbomBa', NULL, NULL, 0, '2025-12-10 17:53:27', '2025-12-10 17:44:35', '2025-12-10 17:53:27'), (37, 48, 'email_password', NULL, 'test1239512', '$2y$10$ip6ceTK8JWxnJmgZYaY6yu0Ab0TH7jQZdENwRW9ku56sMn1sokwCO', NULL, NULL, 0, NULL, '2025-12-18 03:16:41', '2025-12-18 03:16:41'); -- -------------------------------------------------------- -- -- Table structure for table `auth_logins` -- CREATE TABLE `auth_logins` ( `id` int(10) UNSIGNED NOT NULL, `ip_address` varchar(255) NOT NULL, `user_agent` varchar(255) DEFAULT NULL, `id_type` varchar(255) NOT NULL, `identifier` varchar(255) NOT NULL, `user_id` int(10) UNSIGNED DEFAULT NULL, `date` datetime NOT NULL, `success` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `auth_logins` -- INSERT INTO `auth_logins` (`id`, `ip_address`, `user_agent`, `id_type`, `identifier`, `user_id`, `date`, `success`) VALUES (31, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0', 'username', 'customer', 29, '2025-09-15 12:31:24', 1), (32, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0', 'username', 'admin', 31, '2025-09-15 15:10:17', 1), (33, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0', 'username', 'admin', 31, '2025-09-15 15:18:27', 1), (34, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0', 'username', 'customer', 29, '2025-09-15 17:27:18', 1), (35, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0', 'username', 'customer', 29, '2025-09-15 17:28:23', 1), (36, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0', 'username', 'admin', 31, '2025-09-16 04:49:54', 1), (37, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0', 'username', 'admin', 31, '2025-09-16 08:05:24', 1), (38, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0', 'username', 'kasir', 33, '2025-09-16 16:20:37', 1), (39, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0', 'username', 'kepala_toko', 32, '2025-09-16 16:24:15', 1), (40, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0', 'username', 'kasir', 33, '2025-09-16 16:29:02', 1), (41, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0', 'username', 'admin', 31, '2025-09-16 16:29:20', 1), (42, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0', 'username', 'customer', 29, '2025-09-16 16:30:35', 1), (43, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0', 'username', 'rangga', NULL, '2025-09-16 16:35:18', 0), (44, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0', 'username', 'rangga', NULL, '2025-09-16 16:35:32', 0), (45, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0', 'username', 'admin', 31, '2025-09-16 16:36:09', 1), (46, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0', 'username', 'rangga', 38, '2025-09-16 16:37:05', 1), (47, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0', 'username', 'admin', 31, '2025-09-16 16:37:34', 1), (48, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0', 'username', 'admin', 31, '2025-09-17 06:09:40', 1), (49, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'username', 'admin', 31, '2025-10-04 08:00:18', 1), (50, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'username', 'test', NULL, '2025-10-04 08:11:02', 0), (51, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'username', 'admin', 31, '2025-10-04 08:11:28', 1), (52, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'username', 'test', 42, '2025-10-04 08:12:22', 1), (53, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'username', 'admin', 31, '2025-10-04 08:15:51', 1), (54, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'username', 'admin', 31, '2025-10-04 15:48:42', 1), (55, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'username', 'admin', 31, '2025-10-05 00:28:26', 1), (56, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'username', 'admin', 31, '2025-10-05 13:51:11', 1), (57, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'username', 'test', 45, '2025-10-05 16:10:27', 1), (58, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'username', 'customer', 29, '2025-10-05 16:12:11', 1), (59, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'username', 'test', 45, '2025-10-05 16:12:41', 1), (60, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'username', 'kasir', 33, '2025-10-05 16:12:53', 1), (61, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'username', 'kepalatoko', NULL, '2025-10-05 16:13:30', 0), (62, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'username', 'kepala_toko', NULL, '2025-10-05 16:13:45', 0), (63, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'username', 'kepala_toko', NULL, '2025-10-05 16:13:53', 0), (64, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'username', 'kepalatoko', NULL, '2025-10-05 16:14:36', 0), (65, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'username', 'kepala_toko', 32, '2025-10-05 16:15:07', 1), (66, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'username', 'admin', 31, '2025-10-10 02:07:53', 1), (67, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'username', 'kasir', 33, '2025-10-10 02:09:31', 1), (68, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'username', 'kepala_toko', NULL, '2025-10-10 02:09:54', 0), (69, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'username', 'kepala_toko', 32, '2025-10-10 02:10:09', 1), (70, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:143.0) Gecko/20100101 Firefox/143.0', 'username', 'customer', 29, '2025-10-10 02:10:25', 1), (71, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:144.0) Gecko/20100101 Firefox/144.0', 'username', 'pemilik_toko', NULL, '2025-11-07 12:18:34', 0), (72, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:144.0) Gecko/20100101 Firefox/144.0', 'username', 'pemilik_toko', NULL, '2025-11-07 12:19:08', 0), (73, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:144.0) Gecko/20100101 Firefox/144.0', 'username', 'kepala_toko', 32, '2025-11-07 12:19:45', 1), (74, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:144.0) Gecko/20100101 Firefox/144.0', 'username', 'admin', 31, '2025-11-07 12:27:05', 1), (75, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:144.0) Gecko/20100101 Firefox/144.0', 'username', 'customer', 29, '2025-11-07 14:50:44', 1), (76, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:144.0) Gecko/20100101 Firefox/144.0', 'username', 'kasir', 33, '2025-11-07 14:51:10', 1), (77, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:144.0) Gecko/20100101 Firefox/144.0', 'username', 'pemilik_toko', NULL, '2025-11-07 14:51:36', 0), (78, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:144.0) Gecko/20100101 Firefox/144.0', 'username', 'pemilik_toko', NULL, '2025-11-07 14:51:59', 0), (79, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:144.0) Gecko/20100101 Firefox/144.0', 'username', 'kepala_toko', 32, '2025-11-07 14:52:36', 1), (80, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:144.0) Gecko/20100101 Firefox/144.0', 'username', 'kasir', 33, '2025-11-07 14:53:04', 1), (81, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:144.0) Gecko/20100101 Firefox/144.0', 'username', 'customer', 29, '2025-11-07 15:03:24', 1), (82, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:144.0) Gecko/20100101 Firefox/144.0', 'username', 'kasir', 33, '2025-11-07 15:40:05', 1), (83, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:144.0) Gecko/20100101 Firefox/144.0', 'username', 'admin', NULL, '2025-11-07 16:49:59', 0), (84, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:144.0) Gecko/20100101 Firefox/144.0', 'username', 'admin', 31, '2025-11-07 16:56:29', 1), (85, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:144.0) Gecko/20100101 Firefox/144.0', 'username', 'customer', 29, '2025-11-08 04:12:22', 1), (86, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:144.0) Gecko/20100101 Firefox/144.0', 'username', 'customer', 29, '2025-11-08 10:19:45', 1), (87, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:144.0) Gecko/20100101 Firefox/144.0', 'username', 'admin', 31, '2025-11-08 11:34:53', 1), (88, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2025-11-16 02:39:32', 1), (89, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2025-11-16 08:54:11', 1), (90, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2025-12-03 05:04:56', 1), (91, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'admin', 31, '2025-12-04 15:41:37', 1), (92, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'admin', 31, '2025-12-07 05:30:38', 1), (93, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', NULL, '2025-12-07 07:28:13', 0), (94, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2025-12-07 07:28:30', 1), (95, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'kasir', 33, '2025-12-07 07:32:07', 1), (96, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2025-12-07 16:43:12', 1), (97, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2025-12-09 09:58:35', 1), (98, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2025-12-09 13:07:04', 1), (99, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2025-12-09 14:43:25', 1), (100, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2025-12-10 03:06:25', 1), (101, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2025-12-10 07:24:45', 1), (102, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'kasir', 33, '2025-12-10 15:58:16', 1), (103, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'admin', 31, '2025-12-10 15:58:32', 1), (104, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'kasir', 33, '2025-12-10 16:00:25', 1), (105, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'admin', 31, '2025-12-10 16:15:25', 1), (106, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'kasir ', 33, '2025-12-10 16:24:34', 1), (107, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2025-12-10 17:16:09', 1), (108, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2025-12-10 17:17:07', 1), (109, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'kasir', 33, '2025-12-10 17:17:22', 1), (110, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'rangga', 47, '2025-12-10 17:53:27', 1), (111, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'admin', 31, '2025-12-10 17:53:42', 1), (112, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'admin', 31, '2025-12-14 03:46:44', 1), (113, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'admin', 31, '2025-12-14 04:13:57', 1), (114, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'kasir', 33, '2025-12-14 04:14:28', 1), (115, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2025-12-14 04:14:58', 1), (116, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'admin', 31, '2025-12-14 04:19:07', 1), (117, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'kasir', 33, '2025-12-14 04:19:29', 1), (118, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2025-12-14 04:31:35', 1), (119, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', NULL, '2025-12-14 07:52:56', 0), (120, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2025-12-14 07:53:08', 1), (121, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2025-12-17 14:06:59', 1), (122, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2025-12-18 02:29:46', 1), (123, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'admin', 31, '2025-12-18 03:07:09', 1), (124, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'kasir', 33, '2025-12-18 03:08:37', 1), (125, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'admin', 31, '2025-12-18 03:16:59', 1), (126, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2025-12-18 03:17:58', 1), (127, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'kasir', 33, '2025-12-18 04:19:16', 1), (128, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2025-12-18 05:30:41', 1), (129, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2025-12-18 13:57:12', 1), (130, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2025-12-18 15:17:21', 1), (131, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2025-12-19 01:58:16', 1), (132, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'kasir', 33, '2025-12-19 02:38:12', 1), (133, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'admin', 31, '2025-12-19 02:38:34', 1), (134, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'kasir', NULL, '2025-12-19 02:39:27', 0), (135, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'kasir', 33, '2025-12-19 02:39:39', 1), (136, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'kasir', NULL, '2025-12-30 14:40:07', 0), (137, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'kasir', 33, '2025-12-30 14:40:27', 1), (138, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2025-12-30 14:42:54', 1), (139, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2026-01-01 04:40:03', 1), (140, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'kasir', 33, '2026-01-01 20:41:28', 1), (141, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'kasir', 33, '2026-01-01 23:45:07', 1), (142, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2026-01-02 05:20:42', 1), (143, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'kasir', 33, '2026-01-02 05:21:05', 1), (144, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'admin', 31, '2026-01-02 07:47:43', 1), (145, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2026-01-02 07:59:29', 1), (146, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'kasir', 33, '2026-01-02 18:38:48', 1), (147, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2026-01-02 18:39:56', 1), (148, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'customer', 29, '2026-01-02 22:22:33', 1), (149, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:145.0) Gecko/20100101 Firefox/145.0', 'username', 'kasir', 33, '2026-01-02 22:23:40', 1); -- -------------------------------------------------------- -- -- Table structure for table `auth_remember_tokens` -- CREATE TABLE `auth_remember_tokens` ( `id` int(10) UNSIGNED NOT NULL, `selector` varchar(255) NOT NULL, `hashedValidator` varchar(255) NOT NULL, `user_id` int(10) UNSIGNED NOT NULL, `expires` datetime NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` bigint(20) UNSIGNED NOT NULL, `version` varchar(255) NOT NULL, `class` varchar(255) NOT NULL, `group` varchar(255) NOT NULL, `namespace` varchar(255) NOT NULL, `time` int(11) NOT NULL, `batch` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `version`, `class`, `group`, `namespace`, `time`, `batch`) VALUES (1, '2020-12-28-223112', 'CodeIgniter\\Shield\\Database\\Migrations\\CreateAuthTables', 'default', 'CodeIgniter\\Shield', 1756367988, 1), (2, '2021-07-04-041948', 'CodeIgniter\\Settings\\Database\\Migrations\\CreateSettingsTable', 'default', 'CodeIgniter\\Settings', 1756367988, 1), (3, '2021-11-14-143905', 'CodeIgniter\\Settings\\Database\\Migrations\\AddContextColumn', 'default', 'CodeIgniter\\Settings', 1756367988, 1), (4, '2025-09-15-061917', 'App\\Database\\Migrations\\CreateAllTables', 'default', 'App', 1757935441, 2), (5, '2025-12-03-000002', 'App\\Database\\Migrations\\AddRevisionFieldsV2', 'default', 'App', 1764735945, 3), (6, '2025-12-04-000001', 'App\\Database\\Migrations\\ConvertDatesToDatetime', 'default', 'App', 1764865702, 4), (7, '2025-12-04-000002', 'App\\Database\\Migrations\\ConvertOrderDatesToDatetime', 'default', 'App', 1764867222, 5), (8, '2025-12-10-061022', 'App\\Database\\Migrations\\CreateRevisiPermintaanTable', 'default', 'App', 1765347524, 6), (9, '2025-12-10-120000', 'App\\Database\\Migrations\\AddOrderStatusFields', 'default', 'App', 1765386066, 7), (10, '2025-12-11-000000', 'App\\Database\\Migrations\\UpdateStatusPesananEnum', 'default', 'App', 1765386565, 8), (11, '2025-12-17-000000', 'App\\Database\\Migrations\\UpdateDetailKainForMultipleFabrics', 'default', 'App', 1765981920, 9), (12, '2025-12-17-145800', 'App\\Database\\Migrations\\AddMissingRevisionColumns', 'default', 'App', 1765983566, 10); -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `id` int(11) NOT NULL, `class` varchar(255) NOT NULL, `key` varchar(255) NOT NULL, `value` text DEFAULT NULL, `type` varchar(31) NOT NULL DEFAULT 'string', `context` varchar(255) DEFAULT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `tabel_customer` -- CREATE TABLE `tabel_customer` ( `id_customer` int(11) UNSIGNED NOT NULL, `nama` varchar(100) NOT NULL, `alamat` text DEFAULT NULL, `username` varchar(255) DEFAULT NULL, `telepon` varchar(25) NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tabel_customer` -- INSERT INTO `tabel_customer` (`id_customer`, `nama`, `alamat`, `username`, `telepon`, `created_at`, `updated_at`) VALUES (2, 'Customer', 'alamat 85', 'Customer', '085123456789', '2025-09-15 12:27:39', '2025-09-15 17:28:06'), (13, 'test 123', 'test', 'test', '08596789456', '2025-10-05 16:10:17', '2025-10-05 16:10:35'), (21, 'Rangga', NULL, 'rangga', '0856935558', '2025-12-10 17:44:35', '2025-12-10 17:44:35'), (22, 'test123', NULL, 'test1239512', '0859654789512', '2025-12-18 03:16:41', '2025-12-18 03:16:41'); -- -------------------------------------------------------- -- -- Table structure for table `tabel_detail_kain` -- CREATE TABLE `tabel_detail_kain` ( `kode_detail_kain` int(10) UNSIGNED NOT NULL, `id_detail_order` int(10) UNSIGNED NOT NULL, `kode_jenis_kain` varchar(20) DEFAULT NULL, `meter_pemakaian` int(11) NOT NULL, `harga_per_meter` double NOT NULL, `subtotal_detail_kain` double NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `additional_fabrics` text DEFAULT NULL COMMENT 'JSON array of additional fabrics: [{"kode_jenis_kain":"KK001","meter_pemakaian":"1.5","harga_per_meter":"50000"}]' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `tabel_detail_permintaan` -- CREATE TABLE `tabel_detail_permintaan` ( `id_detail_order` int(10) UNSIGNED NOT NULL, `no_order_custom` varchar(255) NOT NULL, `kode_model` int(10) UNSIGNED DEFAULT NULL, `jumlah_pcs` int(11) NOT NULL, `ukuran_gamis` varchar(255) NOT NULL, `lingkar_dada` int(11) DEFAULT NULL COMMENT 'dalam cm', `lingkar_pinggang` int(11) DEFAULT NULL COMMENT 'dalam cm', `lingkar_panggul` int(11) DEFAULT NULL COMMENT 'dalam cm', `lebar_bahu` int(11) DEFAULT NULL COMMENT 'dalam cm', `panjang_lengan` int(11) DEFAULT NULL COMMENT 'dalam cm', `panjang_gamis` int(11) DEFAULT NULL COMMENT 'dalam cm', `catatan_detail` text DEFAULT NULL, `gambar_referensi` varchar(255) DEFAULT NULL, `bawa_kain_sendiri` tinyint(1) DEFAULT 0, `upload_model_sendiri` tinyint(1) DEFAULT 0, `ongkos_jahit_custom` int(11) DEFAULT 0, `ongkos_pengerjaan` double NOT NULL, `subtotal_detail_order` double NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `tabel_history_revisi_order` -- CREATE TABLE `tabel_history_revisi_order` ( `id_history_revisi_order` int(10) UNSIGNED NOT NULL, `id_detail_order` int(10) UNSIGNED NOT NULL, `tanggal_permintaan_revisi` date NOT NULL, `keterangan_permintaan_revisi` text NOT NULL, `tipe_revisi` varchar(50) DEFAULT 'lainnya' COMMENT 'Tipe perubahan: ukuran, warna, material, desain, detail_change, lainnya', `status` int(11) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `biaya_revisi` decimal(10,2) DEFAULT 0.00 COMMENT 'Biaya tambahan untuk revisi', `tgl_diterima_pegawai` datetime DEFAULT NULL COMMENT 'Tanggal revisi diterima oleh pegawai' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `tabel_jenis_kain` -- CREATE TABLE `tabel_jenis_kain` ( `kode_jenis_kain` int(10) UNSIGNED NOT NULL, `nama_jenis_kain` varchar(100) NOT NULL, `warna` varchar(100) NOT NULL, `harga_per_meter` double NOT NULL DEFAULT 0, `foto_jenis_kain` varchar(250) NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tabel_jenis_kain` -- INSERT INTO `tabel_jenis_kain` (`kode_jenis_kain`, `nama_jenis_kain`, `warna`, `harga_per_meter`, `foto_jenis_kain`, `created_at`, `updated_at`) VALUES (1, 'Jenis Kain 1', 'Hitam', 55000, 'assets/jenis_kain/281417257.jpg', '2025-09-15 16:59:53', '2025-10-04 10:12:48'), (2, 'Jenis Kain 2', 'Biru', 50000, 'assets/jenis_kain/281417257.jpg', '2025-09-15 16:59:53', '2025-10-04 10:12:48'); -- -------------------------------------------------------- -- -- Table structure for table `tabel_laporan` -- CREATE TABLE `tabel_laporan` ( `id_laporan` int(10) UNSIGNED NOT NULL, `periode` varchar(100) NOT NULL, `periode_awal` datetime DEFAULT NULL, `total_transaksi` int(11) NOT NULL DEFAULT 0, `total_pendapatan` int(11) NOT NULL DEFAULT 0, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `periode_akhir` datetime DEFAULT NULL, `tipe_laporan` enum('penjualan','pendapatan','pelanggan','revisi','pembayaran') DEFAULT 'penjualan', `status_laporan` enum('draft','finalized') DEFAULT 'draft' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `tabel_model` -- CREATE TABLE `tabel_model` ( `kode_model` int(10) UNSIGNED NOT NULL, `foto_model` varchar(100) NOT NULL, `nama_model` varchar(250) NOT NULL, `ongkos_pengerjaan` double NOT NULL DEFAULT 0, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tabel_model` -- INSERT INTO `tabel_model` (`kode_model`, `foto_model`, `nama_model`, `ongkos_pengerjaan`, `created_at`, `updated_at`) VALUES (5, 'assets/model/219988754.jpg', 'Model 1', 25000, '2025-10-04 10:25:36', '2025-10-04 10:25:36'); -- -------------------------------------------------------- -- -- Table structure for table `tabel_pegawai` -- CREATE TABLE `tabel_pegawai` ( `id_pegawai` int(11) UNSIGNED NOT NULL, `nama` varchar(100) NOT NULL, `username` varchar(250) NOT NULL, `password` varchar(250) NOT NULL, `role` varchar(100) NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tabel_pegawai` -- INSERT INTO `tabel_pegawai` (`id_pegawai`, `nama`, `username`, `password`, `role`, `created_at`, `updated_at`) VALUES (2, 'Admin', 'admin', '$2y$10$Y/7V8GutbiRKJL4V4MS0G.4jevHypLp.eHzDaXeAd3hnX.PV.tFV.', 'admin', '2025-09-15 14:43:18', '2025-10-04 08:09:39'), (3, 'Kepala Toko', 'kepala_toko', '$2y$10$Smbb0eUSBK5W8zd/sJEsp.vNKYlOkfA8yvId58q5I8LTYDIrLyvKS', 'pemilik_toko', '2025-09-15 14:44:18', '2025-09-15 16:04:52'), (4, 'Kasir', 'kasir', '$2y$10$uycsx.9OGSRSSpAYQfv3l.hF1B1/iWi/bMEvRdGQei76W2wf/5f0u', 'kasir', '2025-09-15 14:44:51', '2025-09-15 14:44:51'); -- -------------------------------------------------------- -- -- Table structure for table `tabel_permintaan_custom` -- CREATE TABLE `tabel_permintaan_custom` ( `kode_permintaan_custom` int(10) UNSIGNED NOT NULL, `no_order_custom` varchar(255) NOT NULL, `tanggal_order` datetime DEFAULT NULL, `tanggal_pengambilan` date DEFAULT NULL, `tanggal_pengambilan_konfirmasi` date DEFAULT NULL, `id_customer` int(11) UNSIGNED NOT NULL, `created_by_role` varchar(20) DEFAULT 'customer', `total_order` int(10) UNSIGNED DEFAULT NULL, `dp_pembayaran` double UNSIGNED DEFAULT NULL, `sisa_pembayaran` double DEFAULT NULL, `nominal_pelunasan` double DEFAULT NULL, `tanggal_pelunasan` datetime DEFAULT NULL, `status_pengiriman` int(11) DEFAULT NULL, `status_pelunasan` int(11) NOT NULL DEFAULT 0, `alamat_pengiriman` varchar(255) DEFAULT NULL, `alamat_locked` tinyint(1) DEFAULT 0 COMMENT 'Status alamat terkunci (0=unlock, 1=locked)', `alamat_locked_at` datetime DEFAULT NULL COMMENT 'Timestamp kapan alamat dikunci', `alamat_change_request` text DEFAULT NULL COMMENT 'Alamat baru yang diminta customer', `alamat_change_request_at` datetime DEFAULT NULL COMMENT 'Timestamp request perubahan alamat', `alamat_change_approved` tinyint(1) DEFAULT NULL COMMENT 'Status approval (NULL=pending, 0=rejected, 1=approved)', `alamat_change_approved_at` datetime DEFAULT NULL COMMENT 'Timestamp approval/rejection', `alamat_change_approved_by` int(11) UNSIGNED DEFAULT NULL COMMENT 'User ID yang approve/reject', `alamat_change_note` text DEFAULT NULL COMMENT 'Catatan approval/rejection', `status` int(11) DEFAULT NULL, `bukti_pembayaran` varchar(255) DEFAULT NULL, `bukti_pembayaran_dp` varchar(255) DEFAULT NULL, `metode_pembayaran` enum('transfer','tunai','qris') DEFAULT 'transfer', `catatan_pelanggan` text DEFAULT NULL, `catatan_toko` text DEFAULT NULL, `estimasi_selesai` datetime DEFAULT NULL, `status_admin_konfirmasi` int(1) DEFAULT 0 COMMENT '0=pending, 1=approved, 2=rejected', `tgl_admin_konfirmasi` datetime DEFAULT NULL, `status_pesanan` varchar(50) DEFAULT 'menunggu_konfirmasi', `payment_completed_at` datetime DEFAULT NULL, `meter_completed_at` datetime DEFAULT NULL, `estimasi_pengerjaan` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `tabel_revisi` -- CREATE TABLE `tabel_revisi` ( `id_revisi` int(11) UNSIGNED NOT NULL, `no_order_custom` varchar(100) NOT NULL, `user_id` int(11) UNSIGNED NOT NULL, `user_name` varchar(100) NOT NULL, `perubahan_data` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tabel_revisi` -- INSERT INTO `tabel_revisi` (`id_revisi`, `no_order_custom`, `user_id`, `user_name`, `perubahan_data`, `created_at`, `updated_at`) VALUES (0, 'INV/20260102/000003', 29, 'Customer', '{\"old_nominal\":\"25000\",\"new_nominal\":25000,\"difference\":0,\"total_items\":1,\"items_details\":[{\"item_number\":1,\"kode_model\":\"5\",\"nama_model\":\"Model 1\",\"kode_jenis_kain\":\"1\",\"nama_jenis_kain\":\"Jenis Kain 1\",\"warna\":\"Hitam\",\"ukuran\":\"M\",\"jumlah_pcs\":\"1\",\"meter_pemakaian\":\"0\",\"harga_model\":\"25000\",\"harga_kain\":\"55000\",\"subtotal_model\":25000,\"subtotal_kain\":0,\"total_item\":25000,\"lingkar_dada\":\"0\",\"lingkar_pinggang\":\"0\",\"lingkar_panggul\":\"0\",\"lebar_bahu\":\"0\",\"panjang_lengan\":\"0\",\"panjang_gamis\":\"0\",\"is_new\":false,\"changes\":[]}],\"timestamp\":\"2026-01-02 10:56:20\"}', '2026-01-02 10:56:20', '2026-01-02 10:56:20'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(10) UNSIGNED NOT NULL, `user_id` int(11) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `username` varchar(255) DEFAULT NULL, `role` enum('admin','pemilik_toko','kasir','customer') DEFAULT 'customer', `last_active` datetime DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `deleted_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `user_id`, `name`, `image`, `username`, `role`, `last_active`, `created_at`, `updated_at`, `deleted_at`) VALUES (29, 2, 'Customer', 'assets/img/avatar4.png', 'customer', 'customer', '2026-01-02 23:16:53', '2025-09-15 12:27:39', '2025-09-15 17:28:06', NULL), (31, 2, 'Admin', 'assets/img/avatar3.png', 'admin', 'admin', '2026-01-02 07:59:04', '2025-09-15 14:43:18', '2025-10-04 08:09:39', NULL), (32, 3, 'Kepala Toko', 'assets/img/avatar.png', 'kepala_toko', 'pemilik_toko', '2025-11-07 14:52:44', '2025-09-15 14:44:18', '2025-09-15 16:04:52', NULL), (33, 4, 'Kasir', 'assets/img/avatar5.png', 'kasir', 'kasir', '2026-01-02 23:18:00', '2025-09-15 14:44:51', '2025-09-15 14:44:51', NULL), (34, 3, 'Customer 454', 'assets/img/avatar4.png', 'customer2', NULL, NULL, '2025-09-15 15:39:42', '2025-09-15 16:01:10', NULL), (45, 13, 'test 123', 'assets/img/avatar4.png', 'test', 'customer', '2025-10-05 16:12:42', '2025-10-05 16:10:17', '2025-10-05 16:10:35', NULL), (47, 21, 'Rangga', 'assets/img/avatar4.png', 'rangga', 'customer', '2025-12-10 17:54:08', '2025-12-10 17:44:35', '2025-12-10 17:44:35', NULL), (48, 22, 'test123', 'assets/img/avatar4.png', 'test1239512', 'customer', NULL, '2025-12-18 03:16:41', '2025-12-18 03:16:41', NULL); -- -- Indexes for dumped tables -- -- -- Indexes for table `auth_identities` -- ALTER TABLE `auth_identities` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `type_secret` (`type`,`secret`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `auth_logins` -- ALTER TABLE `auth_logins` ADD PRIMARY KEY (`id`), ADD KEY `id_type_identifier` (`id_type`,`identifier`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tabel_customer` -- ALTER TABLE `tabel_customer` ADD PRIMARY KEY (`id_customer`); -- -- Indexes for table `tabel_detail_kain` -- ALTER TABLE `tabel_detail_kain` ADD PRIMARY KEY (`kode_detail_kain`) USING BTREE, ADD KEY `id_detail_order` (`id_detail_order`,`kode_jenis_kain`), ADD KEY `tabel_detail_kain_ibfk_2` (`kode_jenis_kain`); -- -- Indexes for table `tabel_detail_permintaan` -- ALTER TABLE `tabel_detail_permintaan` ADD PRIMARY KEY (`id_detail_order`) USING BTREE, ADD KEY `kode_model` (`kode_model`), ADD KEY `no_order_custom` (`no_order_custom`); -- -- Indexes for table `tabel_history_revisi_order` -- ALTER TABLE `tabel_history_revisi_order` ADD PRIMARY KEY (`id_history_revisi_order`) USING BTREE, ADD KEY `id_detail_order` (`id_detail_order`); -- -- Indexes for table `tabel_jenis_kain` -- ALTER TABLE `tabel_jenis_kain` ADD PRIMARY KEY (`kode_jenis_kain`) USING BTREE; -- -- Indexes for table `tabel_laporan` -- ALTER TABLE `tabel_laporan` ADD PRIMARY KEY (`id_laporan`); -- -- Indexes for table `tabel_model` -- ALTER TABLE `tabel_model` ADD PRIMARY KEY (`kode_model`) USING BTREE; -- -- Indexes for table `tabel_pegawai` -- ALTER TABLE `tabel_pegawai` ADD PRIMARY KEY (`id_pegawai`), ADD UNIQUE KEY `username` (`username`); -- -- Indexes for table `tabel_permintaan_custom` -- ALTER TABLE `tabel_permintaan_custom` ADD PRIMARY KEY (`no_order_custom`), ADD UNIQUE KEY `kode_permintaan_custom` (`kode_permintaan_custom`), ADD KEY `id_customer` (`id_customer`), ADD KEY `idx_alamat_locked` (`alamat_locked`), ADD KEY `idx_alamat_change_approved` (`alamat_change_approved`), ADD KEY `idx_status_pesanan` (`status_pesanan`), ADD KEY `idx_created_by_role` (`created_by_role`); -- -- Indexes for table `tabel_revisi` -- ALTER TABLE `tabel_revisi` ADD PRIMARY KEY (`id_revisi`), ADD KEY `no_order_custom` (`no_order_custom`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `FK_UNIQUE_USER` (`username`) USING BTREE; -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `auth_identities` -- ALTER TABLE `auth_identities` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38; -- -- AUTO_INCREMENT for table `auth_logins` -- ALTER TABLE `auth_logins` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=150; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `tabel_customer` -- ALTER TABLE `tabel_customer` MODIFY `id_customer` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23; -- -- AUTO_INCREMENT for table `tabel_detail_kain` -- ALTER TABLE `tabel_detail_kain` MODIFY `kode_detail_kain` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=102; -- -- AUTO_INCREMENT for table `tabel_detail_permintaan` -- ALTER TABLE `tabel_detail_permintaan` MODIFY `id_detail_order` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=116; -- -- AUTO_INCREMENT for table `tabel_history_revisi_order` -- ALTER TABLE `tabel_history_revisi_order` MODIFY `id_history_revisi_order` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `tabel_jenis_kain` -- ALTER TABLE `tabel_jenis_kain` MODIFY `kode_jenis_kain` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `tabel_laporan` -- ALTER TABLE `tabel_laporan` MODIFY `id_laporan` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tabel_model` -- ALTER TABLE `tabel_model` MODIFY `kode_model` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `tabel_pegawai` -- ALTER TABLE `tabel_pegawai` MODIFY `id_pegawai` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `tabel_permintaan_custom` -- ALTER TABLE `tabel_permintaan_custom` MODIFY `kode_permintaan_custom` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55; -- -- AUTO_INCREMENT for table `tabel_revisi` -- ALTER TABLE `tabel_revisi` MODIFY `id_revisi` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49; -- -- Constraints for dumped tables -- -- -- Constraints for table `auth_identities` -- ALTER TABLE `auth_identities` ADD CONSTRAINT `auth_identities_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `tabel_detail_kain` -- ALTER TABLE `tabel_detail_kain` ADD CONSTRAINT `tabel_detail_kain_ibfk_1` FOREIGN KEY (`id_detail_order`) REFERENCES `tabel_detail_permintaan` (`id_detail_order`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `tabel_detail_permintaan` -- ALTER TABLE `tabel_detail_permintaan` ADD CONSTRAINT `tabel_detail_permintaan_ibfk_1` FOREIGN KEY (`kode_model`) REFERENCES `tabel_model` (`kode_model`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `tabel_detail_permintaan_ibfk_2` FOREIGN KEY (`no_order_custom`) REFERENCES `tabel_permintaan_custom` (`no_order_custom`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `tabel_history_revisi_order` -- ALTER TABLE `tabel_history_revisi_order` ADD CONSTRAINT `tabel_history_revisi_order_ibfk_1` FOREIGN KEY (`id_detail_order`) REFERENCES `tabel_detail_permintaan` (`id_detail_order`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `tabel_permintaan_custom` -- ALTER TABLE `tabel_permintaan_custom` ADD CONSTRAINT `tabel_permintaan_custom_ibfk_1` FOREIGN KEY (`id_customer`) REFERENCES `tabel_customer` (`id_customer`) ON DELETE CASCADE ON UPDATE CASCADE; COMMIT; /*!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 */;