-- https://www.phpmyadmin.net/
--

START TRANSACTION;



-- --------------------------------------------------------

--
-- 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 `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_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 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_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 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_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 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;

