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

START TRANSACTION;



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

--
-- Table structure for table `admin_branches`
--

CREATE TABLE `admin_branches` (
  `ab_id` int(11) NOT NULL,
  `ab_admin_id` int(11) NOT NULL,
  `ab_branch_id` int(11) NOT NULL,
  `ab_insert_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `ab_insert_admin_id` int(11) NOT NULL,
  `ab_update_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `ab_update_admin_id` int(11) DEFAULT NULL,
  `ab_active` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `admin_branches`
--

INSERT INTO `admin_branches` (`ab_id`, `ab_admin_id`, `ab_branch_id`, `ab_insert_at`, `ab_insert_admin_id`, `ab_update_at`, `ab_update_admin_id`, `ab_active`) VALUES
(1, 1, 1, '2023-02-01 09:33:01', 1, '2023-03-01 02:26:56', 1, 0),
(2, 1, 2, '2023-02-01 09:33:01', 1, '2023-03-01 02:26:56', 1, 0),
(3, 2, 1, '2023-02-01 09:36:13', 1, '2023-02-24 02:38:11', 1, 0),
(4, 2, 1, '2023-02-01 15:26:29', 1, '2023-02-24 02:38:11', 1, 0),
(5, 2, 2, '2023-02-01 15:26:29', 1, '2023-02-24 02:38:11', 1, 0),
(6, 2, 1, '2023-02-01 15:26:35', 1, '2023-02-24 02:38:11', 1, 0),
(7, 3, 2, '2023-02-02 05:54:05', 1, '2023-02-24 02:38:18', 1, 0),
(8, 4, 1, '2023-02-03 07:02:33', 1, '2023-02-08 09:01:05', NULL, 1),
(9, 5, 1, '2023-02-06 06:15:18', 1, '2023-02-10 03:15:50', 5, 0),
(10, 5, 2, '2023-02-06 06:15:18', 1, '2023-02-10 03:15:50', 5, 0),
(11, 5, 1, '2023-02-06 06:15:26', 1, '2023-02-10 03:15:50', 5, 0),
(12, 5, 1, '2023-02-06 06:16:04', 1, '2023-02-10 03:15:50', 5, 0),
(13, 3, 2, '2023-02-07 06:15:01', 1, '2023-02-24 02:38:18', 1, 0),
(14, 3, 4, '2023-02-07 06:36:42', 1, '2023-02-24 02:38:18', 1, 0),
(15, 3, 4, '2023-02-07 07:44:46', 1, '2023-02-24 02:38:18', 1, 0),
(16, 3, 4, '2023-02-07 07:44:55', 1, '2023-02-24 02:38:18', 1, 0),
(17, 1, 1, '2023-02-07 09:53:51', 1, '2023-03-01 02:26:56', 1, 0),
(18, 1, 2, '2023-02-07 09:53:51', 1, '2023-03-01 02:26:56', 1, 0),
(19, 1, 1, '2023-02-08 06:01:57', 3, '2023-03-01 02:26:56', 1, 0),
(20, 1, 2, '2023-02-08 06:01:57', 3, '2023-03-01 02:26:56', 1, 0),
(21, 5, 1, '2023-02-08 06:06:27', 3, '2023-02-10 03:15:50', 5, 0),
(22, 5, 1, '2023-02-08 06:07:02', 3, '2023-02-10 03:15:50', 5, 0),
(23, 3, 4, '2023-02-08 06:51:42', 3, '2023-02-24 02:38:18', 1, 0),
(24, 2, 1, '2023-02-08 07:24:27', 1, '2023-02-24 02:38:11', 1, 0),
(25, 1, 1, '2023-02-08 07:25:06', 1, '2023-03-01 02:26:56', 1, 0),
(26, 1, 2, '2023-02-08 07:25:06', 1, '2023-03-01 02:26:56', 1, 0),
(27, 6, 4, '2023-02-08 07:29:57', 3, NULL, NULL, 1),
(28, 3, 4, '2023-02-09 04:04:21', 5, '2023-02-24 02:38:18', 1, 0),
(29, 3, 4, '2023-02-09 04:07:53', 5, '2023-02-24 02:38:18', 1, 0),
(30, 3, 1, '2023-02-09 05:11:37', 3, '2023-02-24 02:38:18', 1, 0),
(31, 3, 2, '2023-02-09 05:11:37', 3, '2023-02-24 02:38:18', 1, 0),
(32, 3, 4, '2023-02-09 05:11:37', 3, '2023-02-24 02:38:18', 1, 0),
(33, 3, 4, '2023-02-09 05:12:35', 3, '2023-02-24 02:38:18', 1, 0),
(34, 7, 1, '2023-02-09 06:38:17', 3, NULL, NULL, 1),
(35, 7, 2, '2023-02-09 06:38:17', 3, NULL, NULL, 1),
(36, 7, 4, '2023-02-09 06:38:17', 3, NULL, NULL, 1),
(37, 5, 1, '2023-02-10 02:44:46', 5, '2023-02-10 03:15:50', 5, 0),
(38, 5, 2, '2023-02-10 02:44:46', 5, '2023-02-10 03:15:50', 5, 0),
(39, 5, 4, '2023-02-10 02:44:46', 5, '2023-02-10 03:15:50', 5, 0),
(40, 5, 1, '2023-02-10 03:15:50', 5, NULL, NULL, 1),
(41, 5, 2, '2023-02-10 03:15:50', 5, NULL, NULL, 1),
(42, 5, 4, '2023-02-10 03:15:50', 5, NULL, NULL, 1),
(43, 1, 1, '2023-02-10 03:16:29', 5, '2023-03-01 02:26:56', 1, 0),
(44, 1, 2, '2023-02-10 03:16:29', 5, '2023-03-01 02:26:56', 1, 0),
(45, 1, 4, '2023-02-10 03:16:29', 5, '2023-03-01 02:26:56', 1, 0),
(46, 1, 1, '2023-02-10 03:16:40', 5, '2023-03-01 02:26:56', 1, 0),
(47, 1, 2, '2023-02-10 03:16:40', 5, '2023-03-01 02:26:56', 1, 0),
(48, 1, 4, '2023-02-10 03:16:40', 5, '2023-03-01 02:26:56', 1, 0),
(49, 1, 1, '2023-02-10 03:19:12', 1, '2023-03-01 02:26:56', 1, 0),
(50, 1, 2, '2023-02-10 03:19:12', 1, '2023-03-01 02:26:56', 1, 0),
(51, 1, 4, '2023-02-10 03:19:12', 1, '2023-03-01 02:26:56', 1, 0),
(52, 8, 1, '2023-02-20 07:21:44', 3, '2023-02-20 07:39:27', 3, 0),
(53, 8, 2, '2023-02-20 07:21:44', 3, '2023-02-20 07:39:27', 3, 0),
(54, 8, 4, '2023-02-20 07:21:44', 3, '2023-02-20 07:39:27', 3, 0),
(55, 1, 1, '2023-02-20 07:26:03', 3, '2023-03-01 02:26:56', 1, 0),
(56, 1, 2, '2023-02-20 07:26:03', 3, '2023-03-01 02:26:56', 1, 0),
(57, 1, 4, '2023-02-20 07:26:03', 3, '2023-03-01 02:26:56', 1, 0),
(58, 1, 5, '2023-02-20 07:30:07', 1, '2023-03-01 02:26:56', 1, 0),
(59, 1, 5, '2023-02-20 07:30:15', 1, '2023-03-01 02:26:56', 1, 0),
(60, 2, 5, '2023-02-20 07:30:48', 1, '2023-02-24 02:38:11', 1, 0),
(61, 3, 5, '2023-02-20 07:30:53', 1, '2023-02-24 02:38:18', 1, 0),
(62, 8, 5, '2023-02-20 07:39:27', 3, NULL, NULL, 1),
(63, 9, 5, '2023-02-20 07:41:36', 3, NULL, NULL, 1),
(64, 10, 6, '2023-02-20 07:42:16', 3, NULL, NULL, 1),
(65, 11, 6, '2023-02-20 07:43:03', 3, NULL, NULL, 1),
(66, 12, 7, '2023-02-20 07:44:14', 3, NULL, NULL, 1),
(67, 13, 7, '2023-02-20 07:45:34', 3, NULL, NULL, 1),
(68, 14, 8, '2023-02-21 03:20:25', 3, NULL, NULL, 1),
(69, 15, 8, '2023-02-21 03:21:17', 3, NULL, NULL, 1),
(70, 16, 9, '2023-02-21 03:21:59', 3, NULL, NULL, 1),
(71, 17, 9, '2023-02-21 03:22:47', 3, NULL, NULL, 1),
(72, 18, 10, '2023-02-21 03:23:37', 3, NULL, NULL, 1),
(73, 19, 10, '2023-02-21 03:24:23', 3, NULL, NULL, 1),
(74, 20, 11, '2023-02-21 03:25:12', 3, NULL, NULL, 1),
(75, 21, 11, '2023-02-21 03:27:35', 3, NULL, NULL, 1),
(76, 22, 12, '2023-02-21 03:28:22', 3, NULL, NULL, 1),
(77, 23, 12, '2023-02-21 03:29:14', 3, NULL, NULL, 1),
(78, 24, 13, '2023-02-21 03:35:50', 3, NULL, NULL, 1),
(79, 25, 13, '2023-02-21 03:36:40', 3, '2023-02-21 04:07:32', 3, 0),
(80, 26, 14, '2023-02-21 03:40:18', 3, NULL, NULL, 1),
(81, 27, 15, '2023-02-21 03:41:42', 3, NULL, NULL, 1),
(82, 28, 15, '2023-02-21 03:43:16', 3, NULL, NULL, 1),
(83, 29, 16, '2023-02-21 03:44:25', 3, NULL, NULL, 1),
(84, 30, 16, '2023-02-21 03:45:14', 3, NULL, NULL, 1),
(85, 31, 17, '2023-02-21 03:46:26', 3, NULL, NULL, 1),
(86, 32, 17, '2023-02-21 03:47:16', 3, NULL, NULL, 1),
(87, 33, 18, '2023-02-21 03:48:19', 3, NULL, NULL, 1),
(88, 34, 18, '2023-02-21 03:52:32', 3, NULL, NULL, 1),
(89, 35, 19, '2023-02-21 03:53:31', 3, NULL, NULL, 1),
(90, 36, 19, '2023-02-21 03:54:29', 3, NULL, NULL, 1),
(91, 37, 20, '2023-02-21 03:55:53', 3, NULL, NULL, 1),
(92, 38, 20, '2023-02-21 03:57:48', 3, NULL, NULL, 1),
(93, 39, 21, '2023-02-21 03:58:50', 3, NULL, NULL, 1),
(94, 40, 21, '2023-02-21 03:59:45', 3, NULL, NULL, 1),
(95, 41, 22, '2023-02-21 04:00:27', 3, NULL, NULL, 1),
(96, 42, 22, '2023-02-21 04:01:16', 3, NULL, NULL, 1),
(97, 43, 23, '2023-02-21 04:02:29', 3, NULL, NULL, 1),
(98, 44, 23, '2023-02-21 04:03:10', 3, NULL, NULL, 1),
(99, 45, 24, '2023-02-21 04:04:07', 3, NULL, NULL, 1),
(100, 46, 24, '2023-02-21 04:04:57', 3, NULL, NULL, 1),
(101, 47, 25, '2023-02-21 04:06:02', 3, NULL, NULL, 1),
(102, 48, 25, '2023-02-21 04:06:45', 3, NULL, NULL, 1),
(103, 25, 13, '2023-02-21 04:07:32', 3, NULL, NULL, 1),
(104, 25, 14, '2023-02-21 04:07:32', 3, NULL, NULL, 1),
(105, 1, 5, '2023-02-21 04:15:05', 3, '2023-03-01 02:26:56', 1, 0),
(106, 2, 5, '2023-02-21 04:15:29', 1, '2023-02-24 02:38:11', 1, 0),
(107, 1, 5, '2023-02-23 02:20:03', 9, '2023-03-01 02:26:56', 1, 0),
(108, 1, 5, '2023-02-23 03:10:55', 3, '2023-03-01 02:26:56', 1, 0),
(109, 1, 6, '2023-02-23 03:10:55', 3, '2023-03-01 02:26:56', 1, 0),
(110, 1, 7, '2023-02-23 03:10:55', 3, '2023-03-01 02:26:56', 1, 0),
(111, 1, 8, '2023-02-23 03:10:55', 3, '2023-03-01 02:26:56', 1, 0),
(112, 1, 9, '2023-02-23 03:10:55', 3, '2023-03-01 02:26:56', 1, 0),
(113, 1, 10, '2023-02-23 03:10:55', 3, '2023-03-01 02:26:56', 1, 0),
(114, 1, 11, '2023-02-23 03:10:55', 3, '2023-03-01 02:26:56', 1, 0),
(115, 1, 12, '2023-02-23 03:10:55', 3, '2023-03-01 02:26:56', 1, 0),
(116, 1, 13, '2023-02-23 03:10:55', 3, '2023-03-01 02:26:56', 1, 0),
(117, 1, 14, '2023-02-23 03:10:55', 3, '2023-03-01 02:26:56', 1, 0),
(118, 1, 15, '2023-02-23 03:10:55', 3, '2023-03-01 02:26:56', 1, 0),
(119, 1, 17, '2023-02-23 03:10:55', 3, '2023-03-01 02:26:56', 1, 0),
(120, 1, 18, '2023-02-23 03:10:55', 3, '2023-03-01 02:26:56', 1, 0),
(121, 1, 19, '2023-02-23 03:10:55', 3, '2023-03-01 02:26:56', 1, 0),
(122, 1, 20, '2023-02-23 03:10:55', 3, '2023-03-01 02:26:56', 1, 0),
(123, 1, 21, '2023-02-23 03:10:55', 3, '2023-03-01 02:26:56', 1, 0),
(124, 1, 22, '2023-02-23 03:10:55', 3, '2023-03-01 02:26:56', 1, 0),
(125, 1, 23, '2023-02-23 03:10:55', 3, '2023-03-01 02:26:56', 1, 0),
(126, 1, 24, '2023-02-23 03:10:55', 3, '2023-03-01 02:26:56', 1, 0),
(127, 1, 25, '2023-02-23 03:10:55', 3, '2023-03-01 02:26:56', 1, 0),
(128, 3, 5, '2023-02-23 03:11:12', 3, '2023-02-24 02:38:18', 1, 0),
(129, 3, 5, '2023-02-23 05:18:06', 3, '2023-02-24 02:38:18', 1, 0),
(130, 3, 6, '2023-02-23 05:18:06', 3, '2023-02-24 02:38:18', 1, 0),
(131, 3, 7, '2023-02-23 05:18:06', 3, '2023-02-24 02:38:18', 1, 0),
(132, 3, 8, '2023-02-23 05:18:06', 3, '2023-02-24 02:38:18', 1, 0),
(133, 3, 9, '2023-02-23 05:18:06', 3, '2023-02-24 02:38:18', 1, 0),
(134, 3, 10, '2023-02-23 05:18:06', 3, '2023-02-24 02:38:18', 1, 0),
(135, 3, 11, '2023-02-23 05:18:06', 3, '2023-02-24 02:38:18', 1, 0),
(136, 3, 12, '2023-02-23 05:18:06', 3, '2023-02-24 02:38:18', 1, 0),
(137, 3, 13, '2023-02-23 05:18:06', 3, '2023-02-24 02:38:18', 1, 0),
(138, 3, 14, '2023-02-23 05:18:06', 3, '2023-02-24 02:38:18', 1, 0),
(139, 3, 15, '2023-02-23 05:18:06', 3, '2023-02-24 02:38:18', 1, 0),
(140, 3, 16, '2023-02-23 05:18:06', 3, '2023-02-24 02:38:18', 1, 0),
(141, 3, 17, '2023-02-23 05:18:06', 3, '2023-02-24 02:38:18', 1, 0),
(142, 3, 18, '2023-02-23 05:18:06', 3, '2023-02-24 02:38:18', 1, 0),
(143, 3, 19, '2023-02-23 05:18:06', 3, '2023-02-24 02:38:18', 1, 0),
(144, 3, 20, '2023-02-23 05:18:06', 3, '2023-02-24 02:38:18', 1, 0),
(145, 3, 21, '2023-02-23 05:18:06', 3, '2023-02-24 02:38:18', 1, 0),
(146, 3, 22, '2023-02-23 05:18:06', 3, '2023-02-24 02:38:18', 1, 0),
(147, 3, 23, '2023-02-23 05:18:06', 3, '2023-02-24 02:38:18', 1, 0),
(148, 3, 24, '2023-02-23 05:18:06', 3, '2023-02-24 02:38:18', 1, 0),
(149, 3, 25, '2023-02-23 05:18:06', 3, '2023-02-24 02:38:18', 1, 0),
(150, 49, 5, '2023-02-23 07:12:04', 3, '2023-02-23 18:10:30', 1, 0),
(151, 49, 6, '2023-02-23 07:12:04', 3, '2023-02-23 18:10:30', 1, 0),
(152, 49, 7, '2023-02-23 07:12:04', 3, '2023-02-23 18:10:30', 1, 0),
(153, 49, 8, '2023-02-23 07:12:04', 3, '2023-02-23 18:10:30', 1, 0),
(154, 49, 9, '2023-02-23 07:12:04', 3, '2023-02-23 18:10:30', 1, 0),
(155, 49, 10, '2023-02-23 07:12:04', 3, '2023-02-23 18:10:30', 1, 0),
(156, 49, 11, '2023-02-23 07:12:04', 3, '2023-02-23 18:10:30', 1, 0),
(157, 49, 12, '2023-02-23 07:12:04', 3, '2023-02-23 18:10:30', 1, 0),
(158, 49, 13, '2023-02-23 07:12:04', 3, '2023-02-23 18:10:30', 1, 0),
(159, 49, 14, '2023-02-23 07:12:04', 3, '2023-02-23 18:10:30', 1, 0),
(160, 49, 15, '2023-02-23 07:12:04', 3, '2023-02-23 18:10:30', 1, 0),
(161, 49, 16, '2023-02-23 07:12:04', 3, '2023-02-23 18:10:30', 1, 0),
(162, 49, 17, '2023-02-23 07:12:04', 3, '2023-02-23 18:10:30', 1, 0),
(163, 49, 18, '2023-02-23 07:12:04', 3, '2023-02-23 18:10:30', 1, 0),
(164, 49, 19, '2023-02-23 07:12:04', 3, '2023-02-23 18:10:30', 1, 0),
(165, 49, 20, '2023-02-23 07:12:04', 3, '2023-02-23 18:10:30', 1, 0),
(166, 49, 21, '2023-02-23 07:12:04', 3, '2023-02-23 18:10:30', 1, 0),
(167, 49, 22, '2023-02-23 07:12:04', 3, '2023-02-23 18:10:30', 1, 0),
(168, 49, 23, '2023-02-23 07:12:04', 3, '2023-02-23 18:10:30', 1, 0),
(169, 49, 24, '2023-02-23 07:12:04', 3, '2023-02-23 18:10:30', 1, 0),
(170, 49, 25, '2023-02-23 07:12:04', 3, '2023-02-23 18:10:30', 1, 0),
(171, 50, 5, '2023-02-23 07:14:28', 3, '2023-02-23 18:10:53', 1, 0),
(172, 50, 6, '2023-02-23 07:14:28', 3, '2023-02-23 18:10:53', 1, 0),
(173, 50, 7, '2023-02-23 07:14:28', 3, '2023-02-23 18:10:53', 1, 0),
(174, 50, 8, '2023-02-23 07:14:28', 3, '2023-02-23 18:10:53', 1, 0),
(175, 50, 9, '2023-02-23 07:14:28', 3, '2023-02-23 18:10:53', 1, 0),
(176, 50, 10, '2023-02-23 07:14:28', 3, '2023-02-23 18:10:53', 1, 0),
(177, 50, 11, '2023-02-23 07:14:28', 3, '2023-02-23 18:10:53', 1, 0),
(178, 50, 12, '2023-02-23 07:14:28', 3, '2023-02-23 18:10:53', 1, 0),
(179, 50, 13, '2023-02-23 07:14:28', 3, '2023-02-23 18:10:53', 1, 0),
(180, 50, 14, '2023-02-23 07:14:28', 3, '2023-02-23 18:10:53', 1, 0),
(181, 50, 15, '2023-02-23 07:14:28', 3, '2023-02-23 18:10:53', 1, 0),
(182, 50, 16, '2023-02-23 07:14:28', 3, '2023-02-23 18:10:53', 1, 0),
(183, 50, 17, '2023-02-23 07:14:28', 3, '2023-02-23 18:10:53', 1, 0),
(184, 50, 18, '2023-02-23 07:14:28', 3, '2023-02-23 18:10:53', 1, 0),
(185, 50, 19, '2023-02-23 07:14:28', 3, '2023-02-23 18:10:53', 1, 0),
(186, 50, 20, '2023-02-23 07:14:28', 3, '2023-02-23 18:10:53', 1, 0),
(187, 50, 21, '2023-02-23 07:14:28', 3, '2023-02-23 18:10:53', 1, 0),
(188, 50, 22, '2023-02-23 07:14:28', 3, '2023-02-23 18:10:53', 1, 0),
(189, 50, 23, '2023-02-23 07:14:28', 3, '2023-02-23 18:10:53', 1, 0),
(190, 50, 24, '2023-02-23 07:14:28', 3, '2023-02-23 18:10:53', 1, 0),
(191, 50, 25, '2023-02-23 07:14:28', 3, '2023-02-23 18:10:53', 1, 0),
(192, 51, 5, '2023-02-23 07:17:53', 3, '2023-02-23 18:11:08', 1, 0),
(193, 51, 6, '2023-02-23 07:17:53', 3, '2023-02-23 18:11:08', 1, 0),
(194, 51, 7, '2023-02-23 07:17:53', 3, '2023-02-23 18:11:08', 1, 0),
(195, 51, 8, '2023-02-23 07:17:53', 3, '2023-02-23 18:11:08', 1, 0),
(196, 51, 9, '2023-02-23 07:17:53', 3, '2023-02-23 18:11:08', 1, 0),
(197, 51, 10, '2023-02-23 07:17:53', 3, '2023-02-23 18:11:08', 1, 0),
(198, 51, 11, '2023-02-23 07:17:53', 3, '2023-02-23 18:11:08', 1, 0),
(199, 51, 12, '2023-02-23 07:17:53', 3, '2023-02-23 18:11:08', 1, 0),
(200, 51, 13, '2023-02-23 07:17:53', 3, '2023-02-23 18:11:08', 1, 0),
(201, 51, 14, '2023-02-23 07:17:53', 3, '2023-02-23 18:11:08', 1, 0),
(202, 51, 15, '2023-02-23 07:17:53', 3, '2023-02-23 18:11:08', 1, 0),
(203, 51, 16, '2023-02-23 07:17:53', 3, '2023-02-23 18:11:08', 1, 0),
(204, 51, 17, '2023-02-23 07:17:53', 3, '2023-02-23 18:11:08', 1, 0),
(205, 51, 18, '2023-02-23 07:17:53', 3, '2023-02-23 18:11:08', 1, 0),
(206, 51, 19, '2023-02-23 07:17:53', 3, '2023-02-23 18:11:08', 1, 0),
(207, 51, 20, '2023-02-23 07:17:53', 3, '2023-02-23 18:11:08', 1, 0),
(208, 51, 21, '2023-02-23 07:17:53', 3, '2023-02-23 18:11:08', 1, 0),
(209, 51, 22, '2023-02-23 07:17:53', 3, '2023-02-23 18:11:08', 1, 0),
(210, 51, 23, '2023-02-23 07:17:53', 3, '2023-02-23 18:11:08', 1, 0),
(211, 51, 24, '2023-02-23 07:17:53', 3, '2023-02-23 18:11:08', 1, 0),
(212, 51, 25, '2023-02-23 07:17:53', 3, '2023-02-23 18:11:08', 1, 0),
(213, 52, 5, '2023-02-23 07:22:32', 3, NULL, NULL, 1),
(214, 52, 6, '2023-02-23 07:22:32', 3, NULL, NULL, 1),
(215, 52, 7, '2023-02-23 07:22:32', 3, NULL, NULL, 1),
(216, 52, 8, '2023-02-23 07:22:32', 3, NULL, NULL, 1),
(217, 52, 9, '2023-02-23 07:22:32', 3, NULL, NULL, 1),
(218, 52, 10, '2023-02-23 07:22:32', 3, NULL, NULL, 1),
(219, 52, 11, '2023-02-23 07:22:32', 3, NULL, NULL, 1),
(220, 52, 12, '2023-02-23 07:22:32', 3, NULL, NULL, 1),
(221, 52, 13, '2023-02-23 07:22:32', 3, NULL, NULL, 1),
(222, 52, 14, '2023-02-23 07:22:32', 3, NULL, NULL, 1),
(223, 52, 15, '2023-02-23 07:22:32', 3, NULL, NULL, 1),
(224, 52, 16, '2023-02-23 07:22:32', 3, NULL, NULL, 1),
(225, 52, 17, '2023-02-23 07:22:32', 3, NULL, NULL, 1),
(226, 52, 18, '2023-02-23 07:22:32', 3, NULL, NULL, 1),
(227, 52, 19, '2023-02-23 07:22:32', 3, NULL, NULL, 1),
(228, 52, 20, '2023-02-23 07:22:32', 3, NULL, NULL, 1),
(229, 52, 21, '2023-02-23 07:22:32', 3, NULL, NULL, 1),
(230, 52, 22, '2023-02-23 07:22:32', 3, NULL, NULL, 1),
(231, 52, 23, '2023-02-23 07:22:32', 3, NULL, NULL, 1),
(232, 52, 24, '2023-02-23 07:22:32', 3, NULL, NULL, 1),
(233, 52, 25, '2023-02-23 07:22:32', 3, NULL, NULL, 1),
(234, 49, 5, '2023-02-23 18:10:30', 1, NULL, NULL, 1),
(235, 49, 6, '2023-02-23 18:10:30', 1, NULL, NULL, 1),
(236, 49, 7, '2023-02-23 18:10:30', 1, NULL, NULL, 1),
(237, 49, 8, '2023-02-23 18:10:30', 1, NULL, NULL, 1),
(238, 49, 9, '2023-02-23 18:10:30', 1, NULL, NULL, 1),
(239, 49, 10, '2023-02-23 18:10:30', 1, NULL, NULL, 1),
(240, 49, 11, '2023-02-23 18:10:30', 1, NULL, NULL, 1),
(241, 49, 12, '2023-02-23 18:10:30', 1, NULL, NULL, 1),
(242, 49, 13, '2023-02-23 18:10:30', 1, NULL, NULL, 1),
(243, 49, 14, '2023-02-23 18:10:30', 1, NULL, NULL, 1),
(244, 49, 15, '2023-02-23 18:10:30', 1, NULL, NULL, 1),
(245, 49, 16, '2023-02-23 18:10:30', 1, NULL, NULL, 1),
(246, 49, 17, '2023-02-23 18:10:30', 1, NULL, NULL, 1),
(247, 49, 18, '2023-02-23 18:10:30', 1, NULL, NULL, 1),
(248, 49, 19, '2023-02-23 18:10:30', 1, NULL, NULL, 1),
(249, 49, 20, '2023-02-23 18:10:30', 1, NULL, NULL, 1),
(250, 49, 21, '2023-02-23 18:10:30', 1, NULL, NULL, 1),
(251, 49, 22, '2023-02-23 18:10:30', 1, NULL, NULL, 1),
(252, 49, 23, '2023-02-23 18:10:30', 1, NULL, NULL, 1),
(253, 49, 24, '2023-02-23 18:10:30', 1, NULL, NULL, 1),
(254, 49, 25, '2023-02-23 18:10:30', 1, NULL, NULL, 1),
(255, 50, 5, '2023-02-23 18:10:40', 1, '2023-02-23 18:10:53', 1, 0),
(256, 50, 6, '2023-02-23 18:10:40', 1, '2023-02-23 18:10:53', 1, 0),
(257, 50, 7, '2023-02-23 18:10:40', 1, '2023-02-23 18:10:53', 1, 0),
(258, 50, 8, '2023-02-23 18:10:40', 1, '2023-02-23 18:10:53', 1, 0),
(259, 50, 9, '2023-02-23 18:10:40', 1, '2023-02-23 18:10:53', 1, 0),
(260, 50, 10, '2023-02-23 18:10:40', 1, '2023-02-23 18:10:53', 1, 0),
(261, 50, 11, '2023-02-23 18:10:40', 1, '2023-02-23 18:10:53', 1, 0),
(262, 50, 12, '2023-02-23 18:10:40', 1, '2023-02-23 18:10:53', 1, 0),
(263, 50, 13, '2023-02-23 18:10:40', 1, '2023-02-23 18:10:53', 1, 0),
(264, 50, 14, '2023-02-23 18:10:40', 1, '2023-02-23 18:10:53', 1, 0),
(265, 50, 15, '2023-02-23 18:10:40', 1, '2023-02-23 18:10:53', 1, 0),
(266, 50, 16, '2023-02-23 18:10:40', 1, '2023-02-23 18:10:53', 1, 0),
(267, 50, 17, '2023-02-23 18:10:40', 1, '2023-02-23 18:10:53', 1, 0),
(268, 50, 18, '2023-02-23 18:10:40', 1, '2023-02-23 18:10:53', 1, 0),
(269, 50, 19, '2023-02-23 18:10:40', 1, '2023-02-23 18:10:53', 1, 0),
(270, 50, 20, '2023-02-23 18:10:40', 1, '2023-02-23 18:10:53', 1, 0),
(271, 50, 21, '2023-02-23 18:10:40', 1, '2023-02-23 18:10:53', 1, 0),
(272, 50, 22, '2023-02-23 18:10:40', 1, '2023-02-23 18:10:53', 1, 0),
(273, 50, 23, '2023-02-23 18:10:40', 1, '2023-02-23 18:10:53', 1, 0),
(274, 50, 24, '2023-02-23 18:10:40', 1, '2023-02-23 18:10:53', 1, 0),
(275, 50, 25, '2023-02-23 18:10:40', 1, '2023-02-23 18:10:53', 1, 0),
(276, 50, 5, '2023-02-23 18:10:53', 1, NULL, NULL, 1),
(277, 50, 6, '2023-02-23 18:10:53', 1, NULL, NULL, 1),
(278, 50, 7, '2023-02-23 18:10:53', 1, NULL, NULL, 1),
(279, 50, 8, '2023-02-23 18:10:53', 1, NULL, NULL, 1),
(280, 50, 9, '2023-02-23 18:10:53', 1, NULL, NULL, 1),
(281, 50, 10, '2023-02-23 18:10:53', 1, NULL, NULL, 1),
(282, 50, 11, '2023-02-23 18:10:53', 1, NULL, NULL, 1),
(283, 50, 12, '2023-02-23 18:10:53', 1, NULL, NULL, 1),
(284, 50, 13, '2023-02-23 18:10:53', 1, NULL, NULL, 1),
(285, 50, 14, '2023-02-23 18:10:53', 1, NULL, NULL, 1),
(286, 50, 15, '2023-02-23 18:10:53', 1, NULL, NULL, 1),
(287, 50, 16, '2023-02-23 18:10:53', 1, NULL, NULL, 1),
(288, 50, 17, '2023-02-23 18:10:53', 1, NULL, NULL, 1),
(289, 50, 18, '2023-02-23 18:10:53', 1, NULL, NULL, 1),
(290, 50, 19, '2023-02-23 18:10:53', 1, NULL, NULL, 1),
(291, 50, 20, '2023-02-23 18:10:53', 1, NULL, NULL, 1),
(292, 50, 21, '2023-02-23 18:10:53', 1, NULL, NULL, 1),
(293, 50, 22, '2023-02-23 18:10:53', 1, NULL, NULL, 1),
(294, 50, 23, '2023-02-23 18:10:53', 1, NULL, NULL, 1),
(295, 50, 24, '2023-02-23 18:10:53', 1, NULL, NULL, 1),
(296, 50, 25, '2023-02-23 18:10:53', 1, NULL, NULL, 1),
(297, 51, 5, '2023-02-23 18:11:08', 1, NULL, NULL, 1),
(298, 51, 6, '2023-02-23 18:11:08', 1, NULL, NULL, 1),
(299, 51, 7, '2023-02-23 18:11:08', 1, NULL, NULL, 1),
(300, 51, 8, '2023-02-23 18:11:08', 1, NULL, NULL, 1),
(301, 51, 9, '2023-02-23 18:11:08', 1, NULL, NULL, 1),
(302, 51, 10, '2023-02-23 18:11:08', 1, NULL, NULL, 1),
(303, 51, 11, '2023-02-23 18:11:08', 1, NULL, NULL, 1),
(304, 51, 12, '2023-02-23 18:11:08', 1, NULL, NULL, 1),
(305, 51, 13, '2023-02-23 18:11:08', 1, NULL, NULL, 1),
(306, 51, 14, '2023-02-23 18:11:08', 1, NULL, NULL, 1),
(307, 51, 15, '2023-02-23 18:11:08', 1, NULL, NULL, 1),
(308, 51, 16, '2023-02-23 18:11:08', 1, NULL, NULL, 1),
(309, 51, 17, '2023-02-23 18:11:08', 1, NULL, NULL, 1),
(310, 51, 18, '2023-02-23 18:11:08', 1, NULL, NULL, 1),
(311, 51, 19, '2023-02-23 18:11:08', 1, NULL, NULL, 1),
(312, 51, 20, '2023-02-23 18:11:08', 1, NULL, NULL, 1),
(313, 51, 21, '2023-02-23 18:11:08', 1, NULL, NULL, 1),
(314, 51, 22, '2023-02-23 18:11:08', 1, NULL, NULL, 1),
(315, 51, 23, '2023-02-23 18:11:08', 1, NULL, NULL, 1),
(316, 51, 24, '2023-02-23 18:11:08', 1, NULL, NULL, 1),
(317, 51, 25, '2023-02-23 18:11:08', 1, NULL, NULL, 1),
(318, 3, 5, '2023-02-23 18:11:15', 1, '2023-02-24 02:38:18', 1, 0),
(319, 3, 6, '2023-02-23 18:11:15', 1, '2023-02-24 02:38:18', 1, 0),
(320, 3, 7, '2023-02-23 18:11:15', 1, '2023-02-24 02:38:18', 1, 0),
(321, 3, 8, '2023-02-23 18:11:15', 1, '2023-02-24 02:38:18', 1, 0),
(322, 3, 9, '2023-02-23 18:11:15', 1, '2023-02-24 02:38:18', 1, 0),
(323, 3, 10, '2023-02-23 18:11:15', 1, '2023-02-24 02:38:18', 1, 0),
(324, 3, 11, '2023-02-23 18:11:15', 1, '2023-02-24 02:38:18', 1, 0),
(325, 3, 12, '2023-02-23 18:11:15', 1, '2023-02-24 02:38:18', 1, 0),
(326, 3, 13, '2023-02-23 18:11:15', 1, '2023-02-24 02:38:18', 1, 0),
(327, 3, 14, '2023-02-23 18:11:15', 1, '2023-02-24 02:38:18', 1, 0),
(328, 3, 15, '2023-02-23 18:11:15', 1, '2023-02-24 02:38:18', 1, 0),
(329, 3, 16, '2023-02-23 18:11:15', 1, '2023-02-24 02:38:18', 1, 0),
(330, 3, 17, '2023-02-23 18:11:15', 1, '2023-02-24 02:38:18', 1, 0),
(331, 3, 18, '2023-02-23 18:11:15', 1, '2023-02-24 02:38:18', 1, 0),
(332, 3, 19, '2023-02-23 18:11:15', 1, '2023-02-24 02:38:18', 1, 0),
(333, 3, 20, '2023-02-23 18:11:15', 1, '2023-02-24 02:38:18', 1, 0),
(334, 3, 21, '2023-02-23 18:11:15', 1, '2023-02-24 02:38:18', 1, 0),
(335, 3, 22, '2023-02-23 18:11:15', 1, '2023-02-24 02:38:18', 1, 0),
(336, 3, 23, '2023-02-23 18:11:15', 1, '2023-02-24 02:38:18', 1, 0),
(337, 3, 24, '2023-02-23 18:11:15', 1, '2023-02-24 02:38:18', 1, 0),
(338, 3, 25, '2023-02-23 18:11:15', 1, '2023-02-24 02:38:18', 1, 0),
(339, 53, 14, '2023-02-24 02:31:03', 49, NULL, NULL, 1),
(340, 2, 5, '2023-02-24 02:38:11', 1, NULL, NULL, 1),
(341, 2, 6, '2023-02-24 02:38:11', 1, NULL, NULL, 1),
(342, 2, 7, '2023-02-24 02:38:11', 1, NULL, NULL, 1),
(343, 2, 8, '2023-02-24 02:38:11', 1, NULL, NULL, 1),
(344, 2, 9, '2023-02-24 02:38:11', 1, NULL, NULL, 1),
(345, 2, 10, '2023-02-24 02:38:11', 1, NULL, NULL, 1),
(346, 2, 11, '2023-02-24 02:38:11', 1, NULL, NULL, 1),
(347, 2, 12, '2023-02-24 02:38:11', 1, NULL, NULL, 1),
(348, 2, 13, '2023-02-24 02:38:11', 1, NULL, NULL, 1),
(349, 2, 14, '2023-02-24 02:38:11', 1, NULL, NULL, 1),
(350, 2, 15, '2023-02-24 02:38:11', 1, NULL, NULL, 1),
(351, 2, 16, '2023-02-24 02:38:11', 1, NULL, NULL, 1),
(352, 2, 17, '2023-02-24 02:38:11', 1, NULL, NULL, 1),
(353, 2, 18, '2023-02-24 02:38:11', 1, NULL, NULL, 1),
(354, 2, 19, '2023-02-24 02:38:11', 1, NULL, NULL, 1),
(355, 2, 20, '2023-02-24 02:38:11', 1, NULL, NULL, 1),
(356, 2, 21, '2023-02-24 02:38:11', 1, NULL, NULL, 1),
(357, 2, 22, '2023-02-24 02:38:11', 1, NULL, NULL, 1),
(358, 2, 23, '2023-02-24 02:38:11', 1, NULL, NULL, 1),
(359, 2, 24, '2023-02-24 02:38:11', 1, NULL, NULL, 1),
(360, 2, 25, '2023-02-24 02:38:11', 1, NULL, NULL, 1),
(361, 3, 5, '2023-02-24 02:38:18', 1, NULL, NULL, 1),
(362, 3, 6, '2023-02-24 02:38:18', 1, NULL, NULL, 1),
(363, 3, 7, '2023-02-24 02:38:18', 1, NULL, NULL, 1),
(364, 3, 8, '2023-02-24 02:38:18', 1, NULL, NULL, 1),
(365, 3, 9, '2023-02-24 02:38:18', 1, NULL, NULL, 1),
(366, 3, 10, '2023-02-24 02:38:18', 1, NULL, NULL, 1),
(367, 3, 11, '2023-02-24 02:38:18', 1, NULL, NULL, 1),
(368, 3, 12, '2023-02-24 02:38:18', 1, NULL, NULL, 1),
(369, 3, 13, '2023-02-24 02:38:18', 1, NULL, NULL, 1),
(370, 3, 14, '2023-02-24 02:38:18', 1, NULL, NULL, 1),
(371, 3, 15, '2023-02-24 02:38:18', 1, NULL, NULL, 1),
(372, 3, 16, '2023-02-24 02:38:18', 1, NULL, NULL, 1),
(373, 3, 17, '2023-02-24 02:38:18', 1, NULL, NULL, 1),
(374, 3, 18, '2023-02-24 02:38:18', 1, NULL, NULL, 1),
(375, 3, 19, '2023-02-24 02:38:18', 1, NULL, NULL, 1),
(376, 3, 20, '2023-02-24 02:38:18', 1, NULL, NULL, 1),
(377, 3, 21, '2023-02-24 02:38:18', 1, NULL, NULL, 1),
(378, 3, 22, '2023-02-24 02:38:18', 1, NULL, NULL, 1),
(379, 3, 23, '2023-02-24 02:38:18', 1, NULL, NULL, 1),
(380, 3, 24, '2023-02-24 02:38:18', 1, NULL, NULL, 1),
(381, 3, 25, '2023-02-24 02:38:18', 1, NULL, NULL, 1),
(382, 54, 26, '2023-03-01 02:26:50', 1, NULL, NULL, 1),
(383, 1, 5, '2023-03-01 02:26:56', 1, NULL, NULL, 1),
(384, 1, 6, '2023-03-01 02:26:56', 1, NULL, NULL, 1),
(385, 1, 7, '2023-03-01 02:26:56', 1, NULL, NULL, 1),
(386, 1, 8, '2023-03-01 02:26:56', 1, NULL, NULL, 1),
(387, 1, 9, '2023-03-01 02:26:56', 1, NULL, NULL, 1),
(388, 1, 10, '2023-03-01 02:26:56', 1, NULL, NULL, 1),
(389, 1, 11, '2023-03-01 02:26:56', 1, NULL, NULL, 1),
(390, 1, 12, '2023-03-01 02:26:56', 1, NULL, NULL, 1),
(391, 1, 13, '2023-03-01 02:26:56', 1, NULL, NULL, 1),
(392, 1, 14, '2023-03-01 02:26:56', 1, NULL, NULL, 1),
(393, 1, 15, '2023-03-01 02:26:56', 1, NULL, NULL, 1),
(394, 1, 17, '2023-03-01 02:26:56', 1, NULL, NULL, 1),
(395, 1, 18, '2023-03-01 02:26:56', 1, NULL, NULL, 1),
(396, 1, 19, '2023-03-01 02:26:56', 1, NULL, NULL, 1),
(397, 1, 20, '2023-03-01 02:26:56', 1, NULL, NULL, 1),
(398, 1, 21, '2023-03-01 02:26:56', 1, NULL, NULL, 1),
(399, 1, 22, '2023-03-01 02:26:56', 1, NULL, NULL, 1),
(400, 1, 23, '2023-03-01 02:26:56', 1, NULL, NULL, 1),
(401, 1, 24, '2023-03-01 02:26:56', 1, NULL, NULL, 1),
(402, 1, 25, '2023-03-01 02:26:56', 1, NULL, NULL, 1),
(403, 1, 26, '2023-03-01 02:26:56', 1, NULL, NULL, 1),
(404, 55, 26, '2023-03-01 02:34:02', 1, '2023-03-01 02:42:41', 1, 0),
(405, 56, 26, '2023-03-01 02:37:07', 1, '2023-03-02 05:55:43', 1, 0),
(406, 55, 26, '2023-03-01 02:42:41', 1, NULL, NULL, 1),
(407, 57, 26, '2023-03-01 03:01:39', 1, NULL, NULL, 1),
(408, 58, 26, '2023-03-01 03:14:11', 1, NULL, NULL, 1),
(409, 59, 26, '2023-03-01 03:18:47', 1, NULL, NULL, 1),
(410, 60, 26, '2023-03-01 03:31:47', 1, NULL, NULL, 1),
(411, 56, 26, '2023-03-01 05:28:05', 1, '2023-03-02 05:55:43', 1, 0),
(412, 56, 26, '2023-03-02 05:55:43', 1, NULL, NULL, 1),
(413, 61, 26, '2023-03-07 05:08:42', 1, NULL, NULL, 1);

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

--
-- Table structure for table `branches`
--

CREATE TABLE `branches` (
  `branch_id` int(11) NOT NULL,
  `branch_name` varchar(255) NOT NULL,
  `branch_phone` varchar(255) NOT NULL,
  `branch_address` varchar(255) NOT NULL,
  `branch_insert_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `branch_insert_admin_id` int(11) NOT NULL,
  `branch_update_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `branch_update_admin_id` int(11) DEFAULT NULL,
  `branch_delete_at` timestamp NULL DEFAULT NULL,
  `branch_delete_admin_id` int(11) DEFAULT NULL,
  `branch_active` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `branches`
--

INSERT INTO `branches` (`branch_id`, `branch_name`, `branch_phone`, `branch_address`, `branch_insert_at`, `branch_insert_admin_id`, `branch_update_at`, `branch_update_admin_id`, `branch_delete_at`, `branch_delete_admin_id`, `branch_active`) VALUES
(1, 'Klaten', '088232340119', 'Pedan Klaten ', '2023-01-25 08:45:34', 1, '2023-02-20 08:30:42', 1, '2023-02-20 07:30:42', 1, 0),
(2, 'Solo', '08122680110', 'Solo', '2023-01-25 08:48:35', 1, '2023-02-20 08:30:40', 1, '2023-02-20 07:30:40', 1, 0),
(3, 'ssasa', '0181881881', 'Solo 1', '2023-01-25 08:49:20', 1, '2023-01-25 08:52:07', NULL, '2023-01-25 08:52:07', 1, 0),
(4, 'Solo Baru', '081227025763', 'Widuran surakarta', '2023-02-07 07:25:00', 1, '2023-02-20 08:30:38', 1, '2023-02-20 07:30:38', 1, 0),
(5, 'Semar Nusantara Cabang Pedan', '087710180904', 'Jalan Kauman-Pedan, Pedan, Polaharjo, Sobayan, Kec. Pedan, Kabupaten Klaten, Jawa Tengah 57468', '2023-02-20 08:23:24', 3, NULL, NULL, NULL, NULL, 1),
(6, 'Semar Nusantara Cabang Klaten', '085866363669', '7JW3+X4J, Pandanrejo, Kabupaten, Kec. Klaten Tengah, Kabupaten Klaten, Jawa Tengah 57413', '2023-02-20 08:24:03', 3, NULL, NULL, NULL, NULL, 1),
(7, 'Semar Nusantara Cabang Tawangsari', '087738935514', 'Jl. Dalangan-Tawangsari, Dua, Kateguhan, Kec. Tawangsari, Kabupaten Sukoharjo, Jawa Tengah 57561', '2023-02-20 08:24:47', 3, NULL, NULL, NULL, NULL, 1),
(8, 'Semar Nusantara Cabang Sukoharjo', '087827023567', 'Gudangsari, Gayam, Kec. Sukoharjo, Kabupaten Sukoharjo, Jawa Tengah 57512', '2023-02-20 08:25:19', 3, NULL, NULL, NULL, NULL, 1),
(9, 'Semar Nusantara Cabang Solo Radjiman', '085770805098', 'Jl. Dr. Rajiman No.285, Panularan, Kec. Laweyan, Kota Surakarta, Jawa Tengah 57149', '2023-02-20 08:27:28', 3, NULL, NULL, NULL, NULL, 1),
(10, 'Semar Nusantara Cabang The Park', '087726515726', 'The Park Mall Lt. 1 No. 43A-45, Jl. Ir. Soekarno, Solo Baru, Madegondo, Grogol, Dusun II, Madegondo, Kec. Grogol, Kabupaten Sukoharjo, Jawa Tengah 57552', '2023-02-20 08:28:01', 3, NULL, NULL, NULL, NULL, 1),
(11, 'Semar Nusantara Cabang Prambanan', '087897394188', 'Jl. Raya Piyungan - Prambanan Klurak Baru KM 1 No 31C, Klurak Baru, Kec. Prambanan, Kabupaten Bantul, Daerah Istimewa Yogyakarta 55792', '2023-02-20 08:28:32', 3, NULL, NULL, NULL, NULL, 1),
(12, 'Semar Nusantara Cabang Demangan', '087826974030', 'Jl. Laksda Adisucipto No.9, Demangan, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55221', '2023-02-20 08:29:04', 3, NULL, NULL, NULL, NULL, 1),
(13, 'Semar Nusantara Cabang Gondomanan', '087825327941', 'Jl. Brigjen Katamso No.52, Prawirodirjan, Kec. Gondomanan, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55131', '2023-02-20 08:29:35', 3, NULL, NULL, NULL, NULL, 1),
(14, 'Semar Nusantara Cabang Kyaimojo', '081909976660', 'Jl. Kyai Mojo No.95 A, Tegalrejo, Kec. Tegalrejo, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55244', '2023-02-20 08:30:08', 3, NULL, NULL, NULL, NULL, 1),
(15, 'Semar Nusantara Cabang Amplaz', '087782324107', 'Plaza Ambarrukmo Lantai 1 No.8-9A, Jl. Laksda Adisucipto No.9, Ambarukmo, Caturtunggal, Kec. Depok, Kabupaten Sleman, Daerah Istimewa Yogyakarta 55281', '2023-02-20 08:31:07', 3, NULL, NULL, NULL, NULL, 1),
(16, 'Semar Nusantara Cabang Jakal', '087817617503', 'Jalan Kaliurang KM. 5,5 No. 18B, Manggung, Caturtunggal, Kec. Depok, Kabupaten Sleman, Daerah Istimewa Yogyakarta 55281', '2023-02-20 08:32:14', 3, NULL, NULL, NULL, NULL, 1),
(17, 'Semar Nusantara Cabang Bantul', '0895393172442', 'Jl. Jend. Sudirman No.35, Kurahan, Gandekan, Kec. Bantul, Kabupaten Bantul, Daerah Istimewa Yogyakarta 55711', '2023-02-20 08:33:10', 3, NULL, NULL, NULL, NULL, 1),
(18, 'Semar Nusantara Cabang Wonogiri', '087731120274', 'Jl. Jend. Sudirman No.5, Sabggrahan, Giritirto, Kec. Wonogiri, Kabupaten Wonogiri, Jawa Tengah 57612', '2023-02-20 08:33:40', 3, NULL, NULL, NULL, NULL, 1),
(19, 'Semar Nusantara Cabang Karangayu', '089649889060', 'Jl. Jenderal Sudirman No.215, Karangayu, Kec. Semarang Barat, Kota Semarang, Jawa Tengah 50149', '2023-02-20 08:34:26', 3, NULL, NULL, NULL, NULL, 1),
(20, 'Semar Nusantara Cabang Banyumanik', '087700159895', 'Jl. Jati Raya No.10-11, Srondol Wetan, Kec. Banyumanik, Kota Semarang, Jawa Tengah 50263', '2023-02-20 08:35:10', 3, NULL, NULL, NULL, NULL, 1),
(21, 'Semar Nusantara Cabang Kranggan', '085702846473', 'Jl. K.H. Wahid Hasyim No.140-142, Bangunharjo, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50139', '2023-02-20 08:36:36', 3, NULL, NULL, NULL, NULL, 1),
(22, 'Semar Nusantara Cabang Muntilan', '087705577877', 'Jl. Pemuda No.64, Karangwatu, Pucungrejo, Kec. Muntilan, Kabupaten Magelang, Jawa Tengah 56414', '2023-02-20 08:37:13', 3, NULL, NULL, NULL, NULL, 1),
(23, 'Semar Nusantara Cabang Tegal', '082135658397', 'Jl. AR. Hakim No.15, Randugunting, Kec. Tegal Sel., Kota Tegal, Jawa Tengah 52131', '2023-02-20 08:37:44', 3, NULL, NULL, NULL, NULL, 1),
(24, 'Semar Nusantara Cabang Pakuwon Mall', '087833644030', 'Hartono Mall, Jl. Kaliwaru No.17, Kaliwaru, Condongcatur, Kec. Depok, Kabupaten Sleman, Daerah Istimewa Yogyakarta 55281', '2023-02-20 08:38:17', 3, NULL, NULL, NULL, NULL, 1),
(25, 'Semar Nusantara Cabang Malang', '081252458273', 'Jl. Letjend S. Parman No.104-A, Purwantoro, Kec. Blimbing, Kota Malang, Jawa Timur 65122', '2023-02-20 08:38:43', 3, NULL, NULL, NULL, NULL, 1),
(26, 'Order', '08122680110', 'Order', '2023-03-01 03:24:09', 1, NULL, NULL, NULL, NULL, 1);

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

--
-- Table structure for table `cases`
--

CREATE TABLE `cases` (
  `case_id` int(11) NOT NULL,
  `case_type_id` int(11) NOT NULL,
  `case_branch_id` int(11) NOT NULL,
  `case_number` varchar(255) NOT NULL,
  `case_title` varchar(255) NOT NULL,
  `case_date` date NOT NULL,
  `case_due_date` date NOT NULL,
  `case_end_date` datetime DEFAULT NULL,
  `case_status` varchar(25) NOT NULL COMMENT '[new,progress,completed,cancel]',
  `case_insert_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `case_insert_admin_id` int(11) NOT NULL,
  `case_update_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `case_update_admin_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `cases`
--

INSERT INTO `cases` (`case_id`, `case_type_id`, `case_branch_id`, `case_number`, `case_title`, `case_date`, `case_due_date`, `case_end_date`, `case_status`, `case_insert_at`, `case_insert_admin_id`, `case_update_at`, `case_update_admin_id`) VALUES
(1, 2, 1, '1514752739', 'Lorem ipsum dolor sit amet,', '2023-02-02', '2023-02-28', NULL, 'Progress', '2023-02-02 03:43:03', 1, '2023-02-06 06:36:16', 1),
(2, 1, 1, '856439171', 'Penambahan lampu', '2023-02-06', '0000-00-00', NULL, 'New', '2023-02-06 04:10:27', 1, NULL, 0),
(3, 1, 1, '92113410', 'Permintaan Lampu Klaten', '2023-02-06', '0000-00-00', NULL, 'New', '2023-02-06 06:16:28', 5, NULL, 0),
(4, 1, 1, '2112431276', 'Genteng bocor', '2023-02-06', '0000-00-00', NULL, 'New', '2023-02-06 09:26:47', 1, NULL, 0),
(5, 1, 1, '1864885346', 'Herbal', '2023-02-06', '0000-00-00', NULL, 'New', '2023-02-06 09:39:23', 1, NULL, 0),
(6, 1, 2, '1031200998', 'barang rusak', '2023-02-07', '2023-02-10', NULL, 'New', '2023-02-07 06:16:26', 3, NULL, 0),
(7, 3, 2, '118575003', 'Barang tidak sesuai', '2023-02-07', '2023-03-07', NULL, 'New', '2023-02-07 06:33:35', 3, NULL, 0),
(8, 1, 4, '1765830507', 'Ada Barang Yang Cacat', '2023-02-07', '2023-02-16', NULL, 'New', '2023-02-07 06:40:48', 3, NULL, 0),
(9, 1, 1, '2043460548', 'Hallo world', '2023-02-07', '2023-02-18', NULL, 'New', '2023-02-07 07:46:05', 1, NULL, 0),
(10, 1, 4, '2084983445', '严重损坏的货物', '2023-02-07', '2023-02-10', NULL, 'Completed', '2023-02-07 08:05:35', 3, '2023-02-08 06:23:13', 3),
(11, 1, 1, '2956595', '严重损坏的货物', '2023-02-07', '0000-00-00', NULL, 'New', '2023-02-07 09:52:44', 1, NULL, 0),
(12, 1, 1, '1191009264', 'Lampu rusak', '2023-02-07', '2023-02-28', NULL, 'New', '2023-02-07 12:43:23', 1, NULL, 0),
(13, 3, 4, '1762790870', 'Barang Tidak Sesuai', '2023-02-08', '2023-02-26', NULL, 'New', '2023-02-08 07:31:25', 3, NULL, 0),
(14, 1, 4, '1006657871', 'test', '2023-02-09', '0000-00-00', NULL, 'Cancel', '2023-02-09 05:34:28', 3, '2023-02-09 05:41:50', 3),
(15, 2, 4, '1521679062', 'Emas Varian NWG Tidak Ada', '2023-02-10', '2023-02-28', NULL, 'Completed', '2023-02-10 02:52:38', 3, '2023-02-10 03:24:04', 3),
(16, 1, 4, '1813812376', 'Kondisi Barang Ada Yang Rusak ', '2023-02-10', '2023-02-28', NULL, 'New', '2023-02-10 03:18:17', 3, NULL, 0),
(17, 1, 4, '195000711', 'Coba elkana admin ', '2023-02-10', '0000-00-00', NULL, 'Progress', '2023-02-10 03:23:51', 1, '2023-02-10 03:25:10', 1),
(18, 1, 4, '977200316', 'test trouble', '2023-02-10', '2023-02-28', NULL, 'Progress', '2023-02-10 06:18:20', 3, '2023-02-24 03:52:42', 3),
(19, 1, 5, '1831722830', 'Case pemasangan lampu', '2023-02-23', '0000-00-00', NULL, 'Cancel', '2023-02-23 03:11:30', 1, '2023-02-23 03:14:07', 1),
(20, 3, 5, '517652621', 'Penukaran Barang', '2023-02-23', '2023-02-28', NULL, 'Completed', '2023-02-23 03:12:44', 3, '2023-02-23 03:15:34', 3),
(21, 1, 5, '1669908319', 'Perbaikan Etaslase', '2023-02-23', '2023-02-28', NULL, 'New', '2023-02-23 03:19:40', 3, NULL, 0),
(22, 1, 5, '1201714510', 'Perbaikan pintu', '2023-02-23', '0000-00-00', NULL, 'Progress', '2023-02-23 05:27:10', 3, '2023-02-24 03:52:44', 3),
(23, 1, 5, '2065965746', 'Perbaikan Pintu', '2023-02-24', '2023-02-28', NULL, 'Completed', '2023-02-24 02:17:50', 3, '2023-02-24 02:22:14', 3),
(24, 1, 5, '763207198', 'Perbaikan jalan di depan mess', '2023-02-24', '2023-03-01', NULL, 'New', '2023-02-24 02:20:18', 49, NULL, 0),
(25, 1, 6, '1117881519', 'Permintaan perbaikan toilet', '2023-02-24', '0000-00-00', NULL, 'Progress', '2023-02-24 02:24:04', 1, '2023-02-24 03:52:47', 1),
(26, 1, 11, '1931053815', 'perbaikan lampu etalase', '2023-02-24', '2023-02-28', NULL, 'New', '2023-02-24 02:29:31', 20, NULL, 0),
(27, 1, 20, '908838006', 'Perbaikan kamar mandi', '2023-02-24', '2023-03-01', NULL, 'Progress', '2023-02-24 02:36:44', 37, '2023-02-24 03:52:54', 37),
(28, 1, 10, '214250913', 'Perbaikan lampu led etalase', '2023-02-24', '2023-02-28', NULL, 'Progress', '2023-02-24 02:36:46', 19, '2023-02-24 03:52:56', 1),
(29, 1, 7, '2133331949', 'PERBAIKAN LAMPU ETALASE', '2023-02-24', '2023-03-01', NULL, 'Progress', '2023-02-24 02:37:23', 13, '2023-02-24 02:59:35', 13),
(30, 1, 10, '826086776', 'Perbaikan lampu led etalase', '2023-02-24', '2023-02-28', NULL, 'Cancel', '2023-02-24 02:37:32', 19, '2023-02-24 02:39:54', 19),
(31, 1, 25, '787501561', 'cctv mati', '2023-02-24', '2023-02-28', NULL, 'Completed', '2023-02-24 02:38:33', 48, '2023-02-25 11:20:01', 48),
(32, 1, 5, '1403613221', 'perbaikan area parkir ganti plafon + cat', '2023-02-24', '2023-03-10', NULL, 'Progress', '2023-02-24 02:40:06', 8, '2023-02-24 03:53:00', 8),
(33, 2, 9, '1065455059', 'Permintaan Kursi Pembeli (Percobaan)', '2023-02-24', '2023-02-28', NULL, 'Cancel', '2023-02-24 02:40:06', 17, '2023-02-24 02:43:11', 17),
(34, 1, 11, '1264783542', 'perbaikan kaca etalase', '2023-02-24', '2023-03-01', NULL, 'New', '2023-02-24 02:41:46', 20, NULL, 0),
(35, 2, 9, '1311805510', 'Permintaan Kursi Pembeli (Percobaan)', '2023-02-24', '2023-02-28', NULL, 'Progress', '2023-02-24 02:42:19', 17, '2023-03-01 01:13:03', 1),
(36, 1, 14, '838012890', 'Perbaikan kamar mandi', '2023-02-24', '2023-03-10', NULL, 'Cancel', '2023-02-24 02:42:19', 53, '2023-03-03 02:43:00', 53),
(37, 2, 7, '694151017', 'Minta tandon', '2023-02-24', '2023-03-31', NULL, 'Progress', '2023-02-24 02:43:47', 49, '2023-02-24 02:52:44', 1),
(38, 1, 21, '1313268446', 'perbaikan', '2023-02-24', '2023-03-10', NULL, 'Progress', '2023-02-24 02:44:02', 39, '2023-02-24 03:53:05', 39),
(39, 1, 21, '385978048', 'Perbaikan genteng mess bocor', '2023-02-24', '2023-03-02', NULL, 'Progress', '2023-02-24 02:51:28', 39, '2023-02-24 02:54:59', 3),
(40, 1, 11, '1662601561', 'perbaikan sanyo', '2023-02-24', '2023-03-02', NULL, 'New', '2023-02-24 03:02:57', 20, NULL, 0),
(41, 1, 7, '1036863663', 'PERBAIKAN LAMPU SOROT REKLAME', '2023-02-24', '2023-03-01', NULL, 'Progress', '2023-02-24 03:04:51', 13, '2023-02-24 03:06:24', 13),
(42, 2, 7, '899668390', 'PERMINTAAN PERLENGKAPAN', '2023-02-24', '2023-03-01', NULL, 'Progress', '2023-02-24 03:07:36', 13, '2023-02-24 03:08:49', 13),
(43, 1, 18, '1689641495', 'perbaikan plavon bocor', '2023-02-24', '2023-02-28', NULL, 'Cancel', '2023-02-24 05:46:08', 34, '2023-02-28 03:17:36', 34),
(44, 1, 6, '651149844', 'Perbaikan lampu display batangan display Peru logo semar', '2023-02-24', '2023-03-10', NULL, 'New', '2023-02-24 10:34:34', 10, NULL, 0),
(45, 1, 16, '976951590', 'PERBAIKAN TOKO', '2023-02-27', '0000-00-00', NULL, 'New', '2023-02-27 08:44:12', 29, NULL, 0),
(46, 2, 16, '977785003', 'PENGADAAN BARANG ', '2023-02-27', '0000-00-00', NULL, 'New', '2023-02-27 08:46:42', 29, NULL, 0),
(47, 2, 9, '1304197549', 'Laptop (percobaan)', '2023-03-01', '2023-03-03', NULL, 'New', '2023-03-01 01:46:57', 16, NULL, 0),
(48, 2, 26, '1640186520', 'Order Alloy', '2023-03-01', '2023-03-04', NULL, 'Progress', '2023-03-01 02:27:51', 1, '2023-03-01 02:40:33', 1),
(49, 2, 26, '1527834669', 'Permintaan Batu  buru-buru', '2023-03-01', '2023-04-01', NULL, 'Completed', '2023-03-01 02:46:38', 55, '2023-03-01 02:48:33', 55),
(50, 2, 26, '217538495', 'cincin putih - o-0152302221', '2023-03-01', '2023-03-15', NULL, 'Progress', '2023-03-01 03:08:05', 57, '2023-03-01 03:11:35', 57),
(51, 2, 26, '1437090027', 'Permintaan barang', '2023-03-01', '2023-03-31', NULL, 'Progress', '2023-03-01 03:19:27', 58, '2023-03-01 03:22:07', 58),
(52, 2, 26, '1480026153', 'sunglon', '2023-03-01', '2023-04-30', NULL, 'Cancel', '2023-03-01 03:22:47', 59, '2023-03-01 03:39:20', 59),
(53, 2, 26, '1152462446', 'Amplop bubble ', '2023-03-01', '2023-03-11', NULL, 'Cancel', '2023-03-01 03:36:23', 60, '2023-03-01 03:39:19', 60),
(54, 2, 26, '265617604', 'cincin  o-0112302262', '2023-03-01', '2023-04-03', NULL, 'Progress', '2023-03-01 05:39:54', 57, '2023-03-01 06:04:31', 57),
(55, 1, 16, '2042328673', 'PENGGANTIAN LAMPU STRIP ETALASE DAN SALURAN AC', '2023-03-02', '0000-00-00', NULL, 'New', '2023-03-02 07:07:25', 29, NULL, 0),
(56, 2, 26, '354708769', 'permintaan batu', '2023-03-03', '2023-04-10', NULL, 'New', '2023-03-03 03:42:44', 55, NULL, 0),
(57, 1, 8, '819129946', 'Lampu Rusak', '2023-03-03', '2023-03-23', NULL, 'New', '2023-03-03 08:48:04', 15, NULL, 0),
(58, 1, 8, '1185580650', 'Test', '2023-03-03', '2023-03-08', NULL, 'New', '2023-03-03 08:50:10', 15, NULL, 0),
(59, 3, 8, '449117770', 'Barang Tidak Sesuai', '2023-03-03', '2023-03-11', NULL, 'New', '2023-03-03 08:51:22', 15, NULL, 0),
(60, 1, 19, '1825354129', 'perbaikan pintu', '2023-03-07', '2023-03-10', NULL, 'Progress', '2023-03-07 03:22:34', 36, '2023-03-07 03:30:32', 36),
(61, 1, 17, '1164994913', 'Perbaikan Pintu', '2023-03-07', '2023-03-10', NULL, 'New', '2023-03-07 03:34:08', 32, NULL, 0),
(62, 2, 12, '1577017396', 'Lampu mati', '2023-03-07', '2023-03-08', NULL, 'New', '2023-03-07 04:18:00', 22, NULL, 0),
(63, 1, 22, '1643080651', 'Perbaikan lampu  box dinding', '2023-03-08', '2023-03-15', NULL, 'Progress', '2023-03-08 02:18:07', 42, '2023-03-08 02:21:41', 42),
(64, 1, 25, '1267048968', 'Toilet bocor ', '2023-03-10', '2023-03-31', NULL, 'New', '2023-03-10 08:48:34', 48, NULL, 0);

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

--
-- Table structure for table `case_admins`
--

CREATE TABLE `case_admins` (
  `ca_id` int(11) NOT NULL,
  `ca_admin_id` int(11) NOT NULL,
  `ca_case_id` int(11) NOT NULL,
  `ca_send_reminder` int(1) NOT NULL DEFAULT 1,
  `ca_insert_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `ca_insert_admin_id` int(11) NOT NULL,
  `ca_delete_at` timestamp NULL DEFAULT NULL,
  `ca_delete_admin_id` int(11) DEFAULT NULL,
  `ca_active` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `case_admins`
--

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

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

--
-- Table structure for table `case_attachments`
--

CREATE TABLE `case_attachments` (
  `ca_id` int(11) NOT NULL,
  `ca_cc_id` int(11) NOT NULL,
  `ca_type` varchar(5) NOT NULL COMMENT '[file,url]',
  `ca_url` varchar(255) NOT NULL,
  `ca_insert_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `ca_insert_admin_id` int(11) NOT NULL,
  `ca_delete_at` timestamp NULL DEFAULT NULL,
  `ca_delete_admin_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `case_attachments`
--

INSERT INTO `case_attachments` (`ca_id`, `ca_cc_id`, `ca_type`, `ca_url`, `ca_insert_at`, `ca_insert_admin_id`, `ca_delete_at`, `ca_delete_admin_id`) VALUES
(1, 1, 'jpg', 'http://localhost:8084/uploads/attachments/1887281460_Picture1.jpg', '2023-02-02 07:00:55', 1, NULL, NULL),
(2, 1, 'jpg', 'http://localhost:8084/uploads/attachments/1504022604_OIP.jpg', '2023-02-02 07:00:55', 1, NULL, NULL),
(3, 2, 'jpg', 'http://localhost:8084/uploads/attachments/1656838680_OIP2.jpg', '2023-02-02 07:02:15', 1, NULL, NULL),
(4, 3, 'jpg', 'http://localhost:8084/uploads/attachments/1622820547_term-bg-1-34fe4c59.jpg', '2023-02-02 07:03:29', 1, NULL, NULL),
(5, 4, 'png', 'http://localhost:8084/uploads/attachments/1379427826_car23773.png', '2023-02-02 07:04:22', 1, NULL, NULL),
(6, 5, 'jpg', 'https://semar-housekeeping.myaksesori.com/uploads/attachments/1219169913_Screenshot2022-12-28-13-56-27-772com.facebook.katana.jpg', '2023-02-02 11:34:35', 1, NULL, NULL),
(7, 55, 'jpg', 'https://semar-housekeeping.myaksesori.com/uploads/attachments/1941741112_term-bg-1-34fe4c59.jpg', '2023-02-08 07:41:34', 6, NULL, NULL),
(8, 57, 'jpg', 'https://semar-housekeeping.myaksesori.com/uploads/attachments/1071289383_issa11.jpg', '2023-02-09 05:58:23', 3, NULL, NULL),
(9, 75, 'jpg', 'https://semar-housekeeping.myaksesori.com/uploads/attachments/348320913_1677125680734754012784449471677.jpg', '2023-02-23 03:15:01', 1, NULL, NULL),
(10, 78, 'jpg', 'https://semar-housekeeping.myaksesori.com/uploads/attachments/898720862_33229721013968061477936922656486994083041382n11.jpg', '2023-02-23 05:31:31', 3, NULL, NULL),
(11, 81, 'jpg', 'https://semar-housekeeping.myaksesori.com/uploads/attachments/1248124875_33229721013968061477936922656486994083041382n11.jpg', '2023-02-24 02:20:09', 3, NULL, NULL),
(12, 104, 'jpg', 'https://semar-housekeeping.myaksesori.com/uploads/attachments/1415286371_AA.jpg', '2023-02-24 02:45:36', 39, NULL, NULL),
(13, 125, 'jpg', 'https://semar-housekeeping.myaksesori.com/uploads/attachments/1835715522_dcma-workflows.jpg', '2023-03-01 02:40:30', 1, NULL, NULL),
(14, 128, 'jpg', 'https://semar-housekeeping.myaksesori.com/uploads/attachments/702085797_image.jpg', '2023-03-01 03:11:31', 57, NULL, NULL),
(15, 130, 'jpg', 'https://semar-housekeeping.myaksesori.com/uploads/attachments/739572614_1677644412182891396106314701052.jpg', '2023-03-01 03:22:02', 58, NULL, NULL),
(16, 132, 'jpg', 'https://semar-housekeeping.myaksesori.com/uploads/attachments/2074041355_16776448273916273367591051542045.jpg', '2023-03-01 03:27:22', 59, NULL, NULL),
(17, 134, 'jpg', 'https://semar-housekeeping.myaksesori.com/uploads/attachments/2096942429_allitempackaging12.jpg', '2023-03-01 03:38:12', 60, NULL, NULL),
(18, 136, 'jpg', 'https://semar-housekeeping.myaksesori.com/uploads/attachments/1921087011_3suaka.jpg', '2023-03-01 06:04:27', 57, NULL, NULL);

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

--
-- Table structure for table `case_comments`
--

CREATE TABLE `case_comments` (
  `cc_id` int(11) NOT NULL,
  `cc_case_id` int(11) NOT NULL,
  `cc_comment` text NOT NULL,
  `cc_insert_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `cc_insert_admin_id` int(11) NOT NULL,
  `cc_delete_at` timestamp NULL DEFAULT NULL,
  `cc_delete_admin_id` int(11) DEFAULT NULL,
  `cc_active` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `case_comments`
--

INSERT INTO `case_comments` (`cc_id`, `cc_case_id`, `cc_comment`, `cc_insert_at`, `cc_insert_admin_id`, `cc_delete_at`, `cc_delete_admin_id`, `cc_active`) VALUES
(1, 1, '<p>Hallo</p>', '2023-02-02 07:00:55', 1, NULL, NULL, 1),
(2, 1, '<p>Hello World</p>', '2023-02-02 07:02:15', 1, NULL, NULL, 1),
(3, 1, '<p>Testing</p>', '2023-02-02 07:03:29', 1, NULL, NULL, 1),
(4, 1, '<p>Hello World</p>', '2023-02-02 07:04:22', 1, NULL, NULL, 1),
(5, 1, '<p>Heloo</p>', '2023-02-02 11:34:35', 1, NULL, NULL, 1),
(6, 2, '<p>Mau tambah lampu</p>', '2023-02-06 04:10:36', 1, NULL, NULL, 1),
(7, 1, '<p>Haiiiii</p>', '2023-02-06 06:36:39', 1, NULL, NULL, 1),
(8, 4, 'Tes', '2023-02-06 09:26:47', 1, NULL, NULL, 1),
(9, 5, 'Hallo', '2023-02-06 09:39:23', 1, NULL, NULL, 1),
(10, 6, 'Tolong Segera Perbaiki.', '2023-02-07 06:16:26', 3, NULL, NULL, 1),
(11, 7, 'barang yang datang tidak sesuai', '2023-02-07 06:33:35', 3, NULL, NULL, 1),
(12, 8, 'Barang minta ditukar baru', '2023-02-07 06:40:48', 3, NULL, NULL, 1),
(13, 8, '<p>ditukar dengan jenis barang yang sama atau berbeda ?</p><p><br></p>', '2023-02-07 06:45:42', 1, NULL, NULL, 1),
(14, 8, '<p>ditukar dengan jenis barang yang sama atau berbeda ?</p><p><br></p>', '2023-02-07 06:45:46', 1, NULL, NULL, 1),
(15, 8, '<p>ditukar dengan jenis barang yang sama atau berbeda ?</p><p><br></p>', '2023-02-07 06:47:06', 1, NULL, NULL, 1),
(16, 8, '<p>ditukar dengan jenis barang yang sama atau berbeda ?</p><p><br></p>', '2023-02-07 06:49:20', 1, NULL, NULL, 1),
(17, 8, '<p>ditukar dengan jenis barang yang sama atau berbeda ?</p><p><br></p>', '2023-02-07 06:49:52', 1, NULL, NULL, 1),
(18, 8, '<p>Harus segera ditukar barang ini</p>', '2023-02-07 06:50:29', 1, NULL, NULL, 1),
(19, 8, '<p>ditukar dengan jenis barang yang sama atau berbeda ?</p><p><br></p>', '2023-02-07 06:51:54', 1, NULL, NULL, 1),
(20, 8, '<p>Hai 123</p>', '2023-02-07 06:56:05', 1, NULL, NULL, 1),
(21, 7, '<p>Hai123</p>', '2023-02-07 06:56:36', 1, NULL, NULL, 1),
(22, 8, '<p>Hallo</p>', '2023-02-07 07:11:01', 1, NULL, NULL, 1),
(23, 8, '<p>Halllo</p>', '2023-02-07 07:12:24', 1, NULL, NULL, 1),
(24, 8, '<p>Shhshsbd</p>', '2023-02-07 07:22:44', 1, NULL, NULL, 1),
(25, 8, '<p>Aaaaa</p>', '2023-02-07 07:26:43', 1, NULL, NULL, 1),
(26, 8, '<p>Gghhgg</p>', '2023-02-07 07:31:14', 1, NULL, NULL, 1),
(27, 8, '<p>Hallo world</p>', '2023-02-07 07:35:56', 1, NULL, NULL, 1),
(28, 8, '<p>Hallo world</p>', '2023-02-07 07:36:45', 1, NULL, NULL, 1),
(29, 7, '<p>testt</p>', '2023-02-07 07:37:51', 3, NULL, NULL, 1),
(30, 8, '<p>Hallo world</p>', '2023-02-07 07:42:48', 1, NULL, NULL, 1),
(31, 8, '<p>Hallo world</p>', '2023-02-07 07:43:10', 1, NULL, NULL, 1),
(32, 9, 'Hai', '2023-02-07 07:46:05', 1, NULL, NULL, 1),
(33, 10, '请尽快修复我的物品..', '2023-02-07 08:05:35', 3, NULL, NULL, 1),
(34, 10, '<pre class=\"ql-syntax\" spellcheck=\"false\">\r\n\r\n请现在把货物送到这里\r\n\r\n</pre><p><br></p>', '2023-02-07 08:07:23', 1, NULL, NULL, 1),
(35, 10, '<pre class=\"ql-syntax\" spellcheck=\"false\">\r\n\r\n请现在把货物送到这里\r\n\r\n</pre><p><br></p>', '2023-02-07 08:07:35', 1, NULL, NULL, 1),
(36, 10, '<p><br></p><p><span style=\"background-color: rgb(48, 49, 52); color: rgb(232, 234, 237);\">请现在把货物送到这里</span></p>', '2023-02-07 08:07:55', 1, NULL, NULL, 1),
(37, 10, '<p>Hshshz</p>', '2023-02-07 08:08:03', 1, NULL, NULL, 1),
(38, 10, '<p>Hshshz</p>', '2023-02-07 08:09:03', 1, NULL, NULL, 1),
(39, 10, '<p><br></p><p><span style=\"background-color: rgb(48, 49, 52); color: rgb(232, 234, 237);\">请现在把货物送到这里</span></p>', '2023-02-07 08:09:54', 1, NULL, NULL, 1),
(40, 10, '<p>Hallo world</p>', '2023-02-07 08:09:57', 1, NULL, NULL, 1),
(41, 10, '<p>Hallo world</p>', '2023-02-07 08:21:16', 1, NULL, NULL, 1),
(42, 10, '<p>Hallo world</p>', '2023-02-07 08:21:55', 1, NULL, NULL, 1),
(43, 10, '<p>Halooo</p>', '2023-02-07 08:22:50', 1, NULL, NULL, 1),
(44, 10, '<p>Halooo</p>', '2023-02-07 08:24:03', 1, NULL, NULL, 1),
(45, 11, 'Hallo World', '2023-02-07 09:52:44', 1, NULL, NULL, 1),
(46, 11, '<p>严重损坏的货物</p>', '2023-02-07 09:53:09', 1, NULL, NULL, 1),
(47, 11, '<p>严重损坏的货物</p>', '2023-02-07 09:54:03', 1, NULL, NULL, 1),
(48, 12, 'Hallo', '2023-02-07 12:43:24', 1, NULL, NULL, 1),
(49, 12, '<p>Tolong segera</p>', '2023-02-07 12:44:25', 1, NULL, NULL, 1),
(50, 12, '<p>Baru disiapkan alatnya</p>', '2023-02-08 07:26:03', 2, NULL, NULL, 1),
(51, 13, 'Minta ditukar ', '2023-02-08 07:31:25', 3, NULL, NULL, 1),
(52, 13, '<p>Siap Laksankan</p>', '2023-02-08 07:31:48', 6, NULL, NULL, 1),
(53, 13, '<p>Estimasi berapa lama ya ? </p>', '2023-02-08 07:36:11', 3, NULL, NULL, 1),
(54, 13, '<p>1 Hari</p>', '2023-02-08 07:37:20', 6, NULL, NULL, 1),
(55, 13, '<p>Ini Notanya</p>', '2023-02-08 07:41:34', 6, NULL, NULL, 1),
(56, 14, 'test aja', '2023-02-09 05:34:28', 3, NULL, NULL, 1),
(57, 13, '<p>donee</p>', '2023-02-09 05:58:23', 3, NULL, NULL, 1),
(58, 13, '<p>https://www.youtube.com/watch?v=EOn78tJulBY</p>', '2023-02-09 05:59:26', 3, NULL, NULL, 1),
(59, 15, 'Tolong Kirim Emas Varian NWG ', '2023-02-10 02:52:38', 3, NULL, NULL, 1),
(60, 15, '<p>Kapan bisa dikirim ya ? </p>', '2023-02-10 03:15:08', 3, NULL, NULL, 1),
(61, 16, 'Tolong Segera Perbaiki ', '2023-02-10 03:18:17', 3, NULL, NULL, 1),
(62, 15, '<p>Test kirimemail</p>', '2023-02-10 03:20:13', 1, NULL, NULL, 1),
(63, 17, 'Dicoba ya', '2023-02-10 03:23:51', 1, NULL, NULL, 1),
(64, 17, '<p>sssss</p>', '2023-02-10 03:24:48', 1, NULL, NULL, 1),
(65, 17, '<p>masuk</p>', '2023-02-10 03:25:07', 3, NULL, NULL, 1),
(66, 15, '<p>testssss</p>', '2023-02-10 06:13:38', 3, NULL, NULL, 1),
(67, 18, 'Tolong Segera Perbaiki', '2023-02-10 06:18:20', 3, NULL, NULL, 1),
(68, 18, '<p>kapan diperbaiki ya test</p>', '2023-02-11 06:04:38', 3, NULL, NULL, 1),
(69, 19, 'Butuh pasang lampu', '2023-02-23 03:11:30', 1, NULL, NULL, 1),
(70, 20, 'Minta ganti baru', '2023-02-23 03:12:44', 3, NULL, NULL, 1),
(71, 19, '<p>Halo mau pasang lampu</p>', '2023-02-23 03:13:26', 1, NULL, NULL, 1),
(72, 19, '<p>Okeeeeee</p>', '2023-02-23 03:13:59', 3, NULL, NULL, 1),
(73, 20, '<p>El, sudah dipasang ?</p>', '2023-02-23 03:14:28', 1, NULL, NULL, 1),
(74, 20, '<p>doneee</p>', '2023-02-23 03:14:40', 3, NULL, NULL, 1),
(75, 20, '<p>Ini foto speakernya</p>', '2023-02-23 03:15:01', 1, NULL, NULL, 1),
(76, 21, 'Tolong Segera Perbaiki Etalase yang rusak', '2023-02-23 03:19:40', 3, NULL, NULL, 1),
(77, 22, 'perbaikan pintu ', '2023-02-23 05:27:10', 3, NULL, NULL, 1),
(78, 22, '<p>Terlampir evidencennya.. </p>', '2023-02-23 05:31:31', 3, NULL, NULL, 1),
(79, 23, 'Tolong segera diperbaiki', '2023-02-24 02:17:50', 3, NULL, NULL, 1),
(80, 23, '<p>Okay siap, nanti segera dijadwalkan segera perbaikannya.</p>', '2023-02-24 02:19:22', 1, NULL, NULL, 1),
(81, 23, '<p>kapan akan dikerjakan ? </p>', '2023-02-24 02:20:09', 3, NULL, NULL, 1),
(82, 24, 'Mohon segera diperbaiki di cor karena berbahaya menyebabkan kecelakaan', '2023-02-24 02:20:18', 49, NULL, NULL, 1),
(83, 23, '<p>Saya akan cek pengerjaan pada hari minggu</p>', '2023-02-24 02:21:29', 1, NULL, NULL, 1),
(84, 25, 'Toilet rusak, minta tolong segera diperbaiki karena konsumen terganggu', '2023-02-24 02:24:04', 1, NULL, NULL, 1),
(85, 25, '<p>Bisa tolong segera perbaiki ? Bisa di rubah seperti di toilet radjiman.</p><p>Koordinasi dengan Mba Iswanti</p>', '2023-02-24 02:25:20', 1, NULL, NULL, 1),
(86, 26, 'kapan mulai dikerjakan?', '2023-02-24 02:29:31', 20, NULL, NULL, 1),
(87, 27, 'Minta tolong segera diperbaiki', '2023-02-24 02:36:44', 37, NULL, NULL, 1),
(88, 28, 'Minta tolong diperbaiki', '2023-02-24 02:36:46', 19, NULL, NULL, 1),
(89, 29, 'MINTA DIPERCEPAT YA PAK', '2023-02-24 02:37:23', 13, NULL, NULL, 1),
(90, 30, 'Minta tolong diperbaiki', '2023-02-24 02:37:32', 19, NULL, NULL, 1),
(91, 31, 'mau mulai diganti kapan ya ?', '2023-02-24 02:38:33', 48, NULL, NULL, 1),
(92, 28, '<p>Siap, akan segera dijadwalkan kunjungannya</p>', '2023-02-24 02:39:18', 1, NULL, NULL, 1),
(93, 32, 'mohon segera di kerjakan', '2023-02-24 02:40:06', 8, NULL, NULL, 1),
(94, 33, 'Minta tolong segera dikirim', '2023-02-24 02:40:06', 17, NULL, NULL, 1),
(95, 31, '<p>hari ini akan saya kerjakan </p>', '2023-02-24 02:41:00', 3, NULL, NULL, 1),
(96, 34, 'mohon segera dikerjakan ', '2023-02-24 02:41:46', 20, NULL, NULL, 1),
(97, 35, 'Minta tolong segera dikirim', '2023-02-24 02:42:19', 17, NULL, NULL, 1),
(98, 36, 'mohon segera diperbaiki ya..\r\n', '2023-02-24 02:42:19', 53, NULL, NULL, 1),
(99, 27, '<p>Atap kamar mandi bocor</p>', '2023-02-24 02:42:59', 37, NULL, NULL, 1),
(100, 32, '<p>minta segera ya</p>', '2023-02-24 02:43:22', 8, NULL, NULL, 1),
(101, 37, 'Keperluan display', '2023-02-24 02:43:47', 49, NULL, NULL, 1),
(102, 38, 'minta tolong cat ulang toko', '2023-02-24 02:44:02', 39, NULL, NULL, 1),
(103, 36, '<p>pintu kamar mandi jebol..</p><p>koordinasi dengan bu yupita</p>', '2023-02-24 02:44:13', 53, NULL, NULL, 1),
(104, 38, '<p>minta dicat u;lang segera</p>', '2023-02-24 02:45:36', 39, NULL, NULL, 1),
(105, 38, '<p>mau dicat warna apa ya ? </p>', '2023-02-24 02:50:15', 3, NULL, NULL, 1),
(106, 39, 'perbaikan genteng mess toko lantai 3 bocor banyak', '2023-02-24 02:51:28', 39, NULL, NULL, 1),
(107, 38, '<p>warna putih. dikerjakan kapan? oleh siapa??</p>', '2023-02-24 02:52:30', 39, NULL, NULL, 1),
(108, 37, '<p>Okay, </p><p>Akan segera dicek untuk lokasi oleh tukang dari PB Simaju</p><p>Senin jam 14</p>', '2023-02-24 02:52:39', 1, NULL, NULL, 1),
(109, 39, '<p>banyaknya berapa ya ? </p>', '2023-02-24 02:54:52', 3, NULL, NULL, 1),
(110, 29, '<p>LAMPU LED STREP 5 BIJI</p>', '2023-02-24 02:59:28', 13, NULL, NULL, 1),
(111, 39, '<p>1 lembar seng itu ada 10 lubang yg bocor. sedangkan didaerah jemuran lantai 3 ada 6 lembar seng . </p>', '2023-02-24 03:00:01', 39, NULL, NULL, 1),
(112, 40, 'ex : mohon segera diperbaiki ', '2023-02-24 03:02:57', 20, NULL, NULL, 1),
(113, 41, 'LAMPU DEPAN BELAKANG SUDAH MATI SEMUA', '2023-02-24 03:04:51', 13, NULL, NULL, 1),
(114, 41, '<p>PERBAIKAN LAMPU SOROT REKLAME BILLBOX DEPAN BELAKANG MATI TOTALL</p>', '2023-02-24 03:06:16', 13, NULL, NULL, 1),
(115, 42, 'MINTA DITAMBAH LAGI PENGADAAN KALKULATOR', '2023-02-24 03:07:36', 13, NULL, NULL, 1),
(116, 42, '<p>KALKULATOR BANYAK YANG RUSAK TIDAK BISA DIPAKAI</p>', '2023-02-24 03:08:42', 13, NULL, NULL, 1),
(117, 43, 'beberapa plavon toko bocor ,minta di perbaiki ', '2023-02-24 05:46:08', 34, NULL, NULL, 1),
(118, 43, '<p>minta segera perbaikan karena saat hujan turun kondisi plavon bocor dan ruangan basah</p>', '2023-02-24 06:14:21', 34, NULL, NULL, 1),
(119, 44, 'Minta diperbaiki lampu yg mati', '2023-02-24 10:34:34', 10, NULL, NULL, 1),
(120, 45, 'perbaikan keramik pecah dan bernoda,pengecatan tembok area parkir', '2023-02-27 08:44:12', 29, NULL, NULL, 1),
(121, 46, 'MESIN HITUNG UANG YANG MENDUKUNG SENSOR UANG PALSU', '2023-02-27 08:46:42', 29, NULL, NULL, 1),
(122, 35, '<p>Balas percobaan pesan</p>', '2023-03-01 01:12:52', 1, NULL, NULL, 1),
(123, 47, 'Urgent segera ', '2023-03-01 01:46:57', 16, NULL, NULL, 1),
(124, 48, 'Butuh Order :\r\n- Alloy\r\n- Batu', '2023-03-01 02:27:51', 1, NULL, NULL, 1),
(125, 48, '<p>Kirim foto orderan disini</p>', '2023-03-01 02:40:30', 1, NULL, NULL, 1),
(126, 49, 'Permintaan batu :\r\n- batu  hati 3*3 navy 3000\r\n', '2023-03-01 02:46:38', 55, NULL, NULL, 1),
(127, 50, 'rangka cincin cewek baru gia 2ct ,size 12,berat 4gram', '2023-03-01 03:08:05', 57, NULL, NULL, 1),
(128, 50, '<p>Ini foto gambar</p>', '2023-03-01 03:11:31', 57, NULL, NULL, 1),
(129, 51, 'Kitek merah', '2023-03-01 03:19:27', 58, NULL, NULL, 1),
(130, 51, '<p>Barang</p>', '2023-03-01 03:22:02', 58, NULL, NULL, 1),
(131, 52, 'sunglon 30 pcs', '2023-03-01 03:22:47', 59, NULL, NULL, 1),
(132, 52, '<p>Ini contoh barangnya</p>', '2023-03-01 03:27:22', 59, NULL, NULL, 1),
(133, 53, 'Amplop bubble jumlah 20.000 warna  pink dusty ', '2023-03-01 03:36:23', 60, NULL, NULL, 1),
(134, 53, '<p>Ini contoh barangnya</p>', '2023-03-01 03:38:12', 60, NULL, NULL, 1),
(135, 54, 'pesan cincin cowok batu black diamond 0.2ct ada lish 2baris kanan kiri.\r\nyang cewek batu black diamond 0.70ct ring samping full batu black diamond jumlah batu menyesuaikan lebar.\r\n\r\n', '2023-03-01 05:39:54', 57, NULL, NULL, 1),
(136, 54, '<p>contoh gambar</p>', '2023-03-01 06:04:27', 57, NULL, NULL, 1),
(137, 55, 'TOLONG SEGERA DIBUATKAN SALURAN AC DAN GANTI LAMPU STRIP YANG BARU', '2023-03-02 07:07:25', 29, NULL, NULL, 1),
(138, 56, 'permintaan order batu\r\n- batu tetes 2*3 navy (3000)\r\n-batu tetes 2*3 pink    (1000)\r\n- batu malkis 2*4 pink (3000)\r\n- batu malkis 2*4 kuning (3000)\r\n- batu malkis 2.5*5 putih (5000)', '2023-03-03 03:42:44', 55, NULL, NULL, 1),
(139, 57, 'Example', '2023-03-03 08:48:04', 15, NULL, NULL, 1),
(140, 58, 'Ex', '2023-03-03 08:50:10', 15, NULL, NULL, 1),
(141, 59, 'Test', '2023-03-03 08:51:22', 15, NULL, NULL, 1),
(142, 60, 'tolong segera di perbaiki ', '2023-03-07 03:22:34', 36, NULL, NULL, 1),
(143, 60, '<p>kapan akan di kerjakan ? </p>', '2023-03-07 03:30:31', 36, NULL, NULL, 1),
(144, 61, 'Tolong segera diperbaiki', '2023-03-07 03:34:08', 32, NULL, NULL, 1),
(145, 62, 'Ini contoh belajar housekeeping', '2023-03-07 04:18:00', 22, NULL, NULL, 1),
(146, 63, 'Minta segera di ganti lampu box dinding dengan lampu neon karena muntilan masih lampu led', '2023-03-08 02:18:07', 42, NULL, NULL, 1),
(147, 63, '<p>Mas muntilan lampu box dinding masih led minta di ganti lampu neon</p>', '2023-03-08 02:21:41', 42, NULL, NULL, 1),
(148, 64, 'Mbk/ mas malang Toilet nya bocor, ( Yang untuk Customer ), ', '2023-03-10 08:48:34', 48, NULL, NULL, 1);

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

--
-- Table structure for table `case_comment_notifications`
--

CREATE TABLE `case_comment_notifications` (
  `ccn_id` int(11) NOT NULL,
  `ccn_cc_id` int(11) NOT NULL,
  `ccn_admin_id` int(11) NOT NULL,
  `ccn_interval` int(3) NOT NULL,
  `ccn_repeat_interval` int(11) NOT NULL,
  `ccn_last_sent` timestamp NULL DEFAULT NULL,
  `ccn_active` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `case_comment_notifications`
--

INSERT INTO `case_comment_notifications` (`ccn_id`, `ccn_cc_id`, `ccn_admin_id`, `ccn_interval`, `ccn_repeat_interval`, `ccn_last_sent`, `ccn_active`) VALUES
(1, 10, 3, 1, 0, '2023-02-08 03:48:15', 1),
(2, 11, 3, 1, 0, '2023-02-08 03:48:14', 1),
(3, 12, 1, 1, 0, '2023-02-08 03:48:14', 1),
(4, 21, 1, 1, 0, '2023-02-08 22:00:06', 1),
(5, 52, 6, 1, 0, '2023-02-17 22:00:05', 1),
(6, 52, 3, 1, 0, '2023-02-08 22:00:05', 1),
(7, 53, 3, 1, 0, '2023-02-08 22:00:03', 1),
(8, 63, 1, 1, 0, '2023-02-10 22:00:04', 1),
(9, 76, 3, 3, 0, '2023-03-09 22:00:04', 1),
(10, 76, 1, 1, 0, '2023-02-23 22:00:03', 1),
(11, 78, 3, 2, 0, '2023-02-28 22:00:04', 1),
(12, 81, 3, 0, 0, '2023-02-24 02:21:20', 1),
(13, 83, 1, 0, 0, '2023-02-24 02:21:41', 1),
(14, 86, 20, 2, 0, '2023-03-01 22:00:08', 1),
(15, 91, 3, 0, 0, '2023-02-24 22:00:08', 1),
(16, 93, 8, 2, 0, '2023-03-01 22:00:07', 1),
(17, 100, 8, 2, 0, '2023-03-01 22:00:07', 1),
(18, 96, 20, 2, 0, '2023-02-27 22:00:05', 1),
(19, 102, 39, 1, 0, '2023-02-25 22:00:06', 1),
(20, 106, 39, 1, 0, '2023-02-25 22:00:05', 1),
(21, 110, 13, 2, 0, '2023-03-01 22:00:06', 1),
(22, 113, 13, 1, 0, '2023-02-24 22:00:05', 1),
(23, 114, 13, 1, 0, '2023-02-24 22:00:04', 1),
(24, 116, 13, 3, 0, '2023-02-26 22:00:04', 1),
(25, 120, 29, 3, 0, '2023-03-07 22:00:06', 1),
(26, 121, 29, 3, 0, '2023-03-07 22:00:04', 1),
(27, 137, 29, 2, 0, '2023-03-07 22:00:03', 1),
(28, 143, 36, 2, 0, '2023-03-10 22:00:05', 1),
(29, 148, 48, 1, 2, '2023-03-11 01:15:21', 1);

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

--
-- Table structure for table `case_types`
--

CREATE TABLE `case_types` (
  `ct_id` int(11) NOT NULL,
  `ct_code` varchar(255) NOT NULL,
  `ct_name` varchar(255) NOT NULL,
  `ct_order` int(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `case_types`
--

INSERT INTO `case_types` (`ct_id`, `ct_code`, `ct_name`, `ct_order`) VALUES
(1, 'MT', 'Maintenance', 1),
(2, 'RE', 'Pengadaan', 2),
(3, 'OT', 'Lainnya', 3);

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

--
-- Table structure for table `notification_queue`
--

CREATE TABLE `notification_queue` (
  `nq_id` int(11) NOT NULL,
  `nq_type` varchar(25) NOT NULL COMMENT '[whatsapp,email]',
  `nq_admin_id` int(11) NOT NULL,
  `nq_from` varchar(255) NOT NULL,
  `nq_from_name` varchar(255) NOT NULL,
  `nq_to` varchar(255) NOT NULL,
  `nq_to_name` varchar(255) NOT NULL,
  `nq_title` varchar(255) NOT NULL,
  `nq_content` longtext NOT NULL,
  `nq_insert_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `nq_delivered_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `notification_queue`
--

INSERT INTO `notification_queue` (`nq_id`, `nq_type`, `nq_admin_id`, `nq_from`, `nq_from_name`, `nq_to`, `nq_to_name`, `nq_title`, `nq_content`, `nq_insert_at`, `nq_delivered_at`) VALUES
(3, 'email', 0, 'noreply@semar.co.id', 'Semar Housekeeping', 'sammy011088@gmail.com', 'Samuel', 'Reminder - 2023-03-11', 'Reminder - 2023-03-11<br/><br/>1. Toilet bocor <br/>Cabang: Semar Nusantara Cabang Malang<br/>Jatuh Tempo: 2023-03-31<br/>Oleh: Samuel<br/><br/>2. Perbaikan lampu  box dinding<br/>Cabang: Semar Nusantara Cabang Muntilan<br/>Jatuh Tempo: 2023-03-15<br/>Oleh: Samuel<br/><br/>3. Lampu mati<br/>Cabang: Semar Nusantara Cabang Demangan<br/>Jatuh Tempo: 2023-03-08<br/>Oleh: Samuel<br/><br/>4. Perbaikan Pintu<br/>Cabang: Semar Nusantara Cabang Bantul<br/>Jatuh Tempo: 2023-03-10<br/>Oleh: Samuel<br/><br/>5. perbaikan pintu<br/>Cabang: Semar Nusantara Cabang Karangayu<br/>Jatuh Tempo: 2023-03-10<br/>Oleh: Samuel<br/><br/>6. Barang Tidak Sesuai<br/>Cabang: Semar Nusantara Cabang Sukoharjo<br/>Jatuh Tempo: 2023-03-11<br/>Oleh: Samuel<br/><br/>7. Test<br/>Cabang: Semar Nusantara Cabang Sukoharjo<br/>Jatuh Tempo: 2023-03-08<br/>Oleh: Samuel<br/><br/>8. Lampu Rusak<br/>Cabang: Semar Nusantara Cabang Sukoharjo<br/>Jatuh Tempo: 2023-03-23<br/>Oleh: Samuel<br/><br/>9. permintaan batu<br/>Cabang: Order<br/>Jatuh Tempo: 2023-04-10<br/>Oleh: Samuel<br/><br/>10. cincin  o-0112302262<br/>Cabang: Order<br/>Jatuh Tempo: 2023-04-03<br/>Oleh: Samuel<br/><br/>11. Permintaan barang<br/>Cabang: Order<br/>Jatuh Tempo: 2023-03-31<br/>Oleh: Samuel<br/><br/>12. cincin putih - o-0152302221<br/>Cabang: Order<br/>Jatuh Tempo: 2023-03-15<br/>Oleh: Samuel<br/><br/>13. Order Alloy<br/>Cabang: Order<br/>Jatuh Tempo: 2023-03-04<br/>Oleh: Samuel<br/><br/>14. Laptop (percobaan)<br/>Cabang: Semar Nusantara Cabang Solo Radjiman<br/>Jatuh Tempo: 2023-03-03<br/>Oleh: Samuel<br/><br/>15. Perbaikan lampu display batangan display Peru logo semar<br/>Cabang: Semar Nusantara Cabang Klaten<br/>Jatuh Tempo: 2023-03-10<br/>Oleh: Samuel<br/><br/>16. PERMINTAAN PERLENGKAPAN<br/>Cabang: Semar Nusantara Cabang Tawangsari<br/>Jatuh Tempo: 2023-03-01<br/>Oleh: Samuel<br/><br/>17. PERBAIKAN LAMPU SOROT REKLAME<br/>Cabang: Semar Nusantara Cabang Tawangsari<br/>Jatuh Tempo: 2023-03-01<br/>Oleh: Samuel<br/><br/>18. perbaikan sanyo<br/>Cabang: Semar Nusantara Cabang Prambanan<br/>Jatuh Tempo: 2023-03-02<br/>Oleh: Samuel<br/><br/>19. Perbaikan genteng mess bocor<br/>Cabang: Semar Nusantara Cabang Kranggan<br/>Jatuh Tempo: 2023-03-02<br/>Oleh: Samuel<br/><br/>20. perbaikan<br/>Cabang: Semar Nusantara Cabang Kranggan<br/>Jatuh Tempo: 2023-03-10<br/>Oleh: Samuel<br/><br/>21. Minta tandon<br/>Cabang: Semar Nusantara Cabang Tawangsari<br/>Jatuh Tempo: 2023-03-31<br/>Oleh: Samuel<br/><br/>22. Permintaan Kursi Pembeli (Percobaan)<br/>Cabang: Semar Nusantara Cabang Solo Radjiman<br/>Jatuh Tempo: 2023-02-28<br/>Oleh: Samuel<br/><br/>23. perbaikan kaca etalase<br/>Cabang: Semar Nusantara Cabang Prambanan<br/>Jatuh Tempo: 2023-03-01<br/>Oleh: Samuel<br/><br/>24. perbaikan area parkir ganti plafon + cat<br/>Cabang: Semar Nusantara Cabang Pedan<br/>Jatuh Tempo: 2023-03-10<br/>Oleh: Samuel<br/><br/>25. PERBAIKAN LAMPU ETALASE<br/>Cabang: Semar Nusantara Cabang Tawangsari<br/>Jatuh Tempo: 2023-03-01<br/>Oleh: Samuel<br/><br/>26. Perbaikan kamar mandi<br/>Cabang: Semar Nusantara Cabang Banyumanik<br/>Jatuh Tempo: 2023-03-01<br/>Oleh: Samuel<br/><br/>27. perbaikan lampu etalase<br/>Cabang: Semar Nusantara Cabang Prambanan<br/>Jatuh Tempo: 2023-02-28<br/>Oleh: Samuel<br/><br/>28. Permintaan perbaikan toilet<br/>Cabang: Semar Nusantara Cabang Klaten<br/>Jatuh Tempo: 0000-00-00<br/>Oleh: Samuel<br/><br/>29. Perbaikan jalan di depan mess<br/>Cabang: Semar Nusantara Cabang Pedan<br/>Jatuh Tempo: 2023-03-01<br/>Oleh: Samuel<br/><br/>30. Perbaikan pintu<br/>Cabang: Semar Nusantara Cabang Pedan<br/>Jatuh Tempo: 0000-00-00<br/>Oleh: Samuel<br/><br/>31. Perbaikan Etaslase<br/>Cabang: Semar Nusantara Cabang Pedan<br/>Jatuh Tempo: 2023-02-28<br/>Oleh: Samuel<br/><br/>32. test trouble<br/>Cabang: Solo Baru<br/>Jatuh Tempo: 2023-02-28<br/>Oleh: samuel<br/><br/>33. Coba elkana admin <br/>Cabang: Solo Baru<br/>Jatuh Tempo: 0000-00-00<br/>Oleh: Samuel<br/><br/>34. Coba elkana admin <br/>Cabang: Solo Baru<br/>Jatuh Tempo: 0000-00-00<br/>Oleh: samuel<br/><br/>35. Kondisi Barang Ada Yang Rusak <br/>Cabang: Solo Baru<br/>Jatuh Tempo: 2023-02-28<br/>Oleh: samuel<br/><br/>36. Lampu rusak<br/>Cabang: Klaten<br/>Jatuh Tempo: 2023-02-28<br/>Oleh: Samuel<br/><br/>37. 严重损坏的货物<br/>Cabang: Klaten<br/>Jatuh Tempo: 0000-00-00<br/>Oleh: samuel<br/><br/>38. 严重损坏的货物<br/>Cabang: Klaten<br/>Jatuh Tempo: 0000-00-00<br/>Oleh: Samuel<br/><br/>39. Hallo world<br/>Cabang: Klaten<br/>Jatuh Tempo: 2023-02-18<br/>Oleh: samuel<br/><br/>40. Hallo world<br/>Cabang: Klaten<br/>Jatuh Tempo: 2023-02-18<br/>Oleh: Samuel<br/><br/>41. Ada Barang Yang Cacat<br/>Cabang: Solo Baru<br/>Jatuh Tempo: 2023-02-16<br/>Oleh: Samuel<br/><br/>42. Barang tidak sesuai<br/>Cabang: Solo<br/>Jatuh Tempo: 2023-03-07<br/>Oleh: Samuel<br/><br/>43. Herbal<br/>Cabang: Klaten<br/>Jatuh Tempo: 0000-00-00<br/>Oleh: samuel<br/><br/>44. Herbal<br/>Cabang: Klaten<br/>Jatuh Tempo: 0000-00-00<br/>Oleh: Samuel<br/><br/>45. Genteng bocor<br/>Cabang: Klaten<br/>Jatuh Tempo: 0000-00-00<br/>Oleh: samuel<br/><br/>46. Genteng bocor<br/>Cabang: Klaten<br/>Jatuh Tempo: 0000-00-00<br/>Oleh: Samuel<br/><br/>47. Permintaan Lampu Klaten<br/>Cabang: Klaten<br/>Jatuh Tempo: 0000-00-00<br/>Oleh: samuel<br/><br/>48. Penambahan lampu<br/>Cabang: Klaten<br/>Jatuh Tempo: 0000-00-00<br/>Oleh: Samuel<br/><br/>49. Lorem ipsum dolor sit amet,<br/>Cabang: Klaten<br/>Jatuh Tempo: 2023-02-28<br/>Oleh: Samuel', '2023-03-11 15:32:22', '2023-03-11 03:32:38'),
(4, 'whatsapp', 0, '', 'Semar Housekeeping', '08122680110', 'Samuel', 'Reminder - 2023-03-11', 'Reminder - 2023-03-11 \\n \\n1. Toilet bocor  \\nCabang: Semar Nusantara Cabang Malang \\nJatuh Tempo: 2023-03-31 \\nOleh: Samuel \\n \\n2. Perbaikan lampu  box dinding \\nCabang: Semar Nusantara Cabang Muntilan \\nJatuh Tempo: 2023-03-15 \\nOleh: Samuel \\n \\n3. Lampu mati \\nCabang: Semar Nusantara Cabang Demangan \\nJatuh Tempo: 2023-03-08 \\nOleh: Samuel \\n \\n4. Perbaikan Pintu \\nCabang: Semar Nusantara Cabang Bantul \\nJatuh Tempo: 2023-03-10 \\nOleh: Samuel \\n \\n5. perbaikan pintu \\nCabang: Semar Nusantara Cabang Karangayu \\nJatuh Tempo: 2023-03-10 \\nOleh: Samuel \\n \\n6. Barang Tidak Sesuai \\nCabang: Semar Nusantara Cabang Sukoharjo \\nJatuh Tempo: 2023-03-11 \\nOleh: Samuel \\n \\n7. Test \\nCabang: Semar Nusantara Cabang Sukoharjo \\nJatuh Tempo: 2023-03-08 \\nOleh: Samuel \\n \\n8. Lampu Rusak \\nCabang: Semar Nusantara Cabang Sukoharjo \\nJatuh Tempo: 2023-03-23 \\nOleh: Samuel \\n \\n9. permintaan batu \\nCabang: Order \\nJatuh Tempo: 2023-04-10 \\nOleh: Samuel \\n \\n10. cincin  o-0112302262 \\nCabang: Order \\nJatuh Tempo: 2023-04-03 \\nOleh: Samuel \\n \\n11. Permintaan barang \\nCabang: Order \\nJatuh Tempo: 2023-03-31 \\nOleh: Samuel \\n \\n12. cincin putih - o-0152302221 \\nCabang: Order \\nJatuh Tempo: 2023-03-15 \\nOleh: Samuel \\n \\n13. Order Alloy \\nCabang: Order \\nJatuh Tempo: 2023-03-04 \\nOleh: Samuel \\n \\n14. Laptop (percobaan) \\nCabang: Semar Nusantara Cabang Solo Radjiman \\nJatuh Tempo: 2023-03-03 \\nOleh: Samuel \\n \\n15. Perbaikan lampu display batangan display Peru logo semar \\nCabang: Semar Nusantara Cabang Klaten \\nJatuh Tempo: 2023-03-10 \\nOleh: Samuel \\n \\n16. PERMINTAAN PERLENGKAPAN \\nCabang: Semar Nusantara Cabang Tawangsari \\nJatuh Tempo: 2023-03-01 \\nOleh: Samuel \\n \\n17. PERBAIKAN LAMPU SOROT REKLAME \\nCabang: Semar Nusantara Cabang Tawangsari \\nJatuh Tempo: 2023-03-01 \\nOleh: Samuel \\n \\n18. perbaikan sanyo \\nCabang: Semar Nusantara Cabang Prambanan \\nJatuh Tempo: 2023-03-02 \\nOleh: Samuel \\n \\n19. Perbaikan genteng mess bocor \\nCabang: Semar Nusantara Cabang Kranggan \\nJatuh Tempo: 2023-03-02 \\nOleh: Samuel \\n \\n20. perbaikan \\nCabang: Semar Nusantara Cabang Kranggan \\nJatuh Tempo: 2023-03-10 \\nOleh: Samuel \\n \\n21. Minta tandon \\nCabang: Semar Nusantara Cabang Tawangsari \\nJatuh Tempo: 2023-03-31 \\nOleh: Samuel \\n \\n22. Permintaan Kursi Pembeli (Percobaan) \\nCabang: Semar Nusantara Cabang Solo Radjiman \\nJatuh Tempo: 2023-02-28 \\nOleh: Samuel \\n \\n23. perbaikan kaca etalase \\nCabang: Semar Nusantara Cabang Prambanan \\nJatuh Tempo: 2023-03-01 \\nOleh: Samuel \\n \\n24. perbaikan area parkir ganti plafon + cat \\nCabang: Semar Nusantara Cabang Pedan \\nJatuh Tempo: 2023-03-10 \\nOleh: Samuel \\n \\n25. PERBAIKAN LAMPU ETALASE \\nCabang: Semar Nusantara Cabang Tawangsari \\nJatuh Tempo: 2023-03-01 \\nOleh: Samuel \\n \\n26. Perbaikan kamar mandi \\nCabang: Semar Nusantara Cabang Banyumanik \\nJatuh Tempo: 2023-03-01 \\nOleh: Samuel \\n \\n27. perbaikan lampu etalase \\nCabang: Semar Nusantara Cabang Prambanan \\nJatuh Tempo: 2023-02-28 \\nOleh: Samuel \\n \\n28. Permintaan perbaikan toilet \\nCabang: Semar Nusantara Cabang Klaten \\nJatuh Tempo: 0000-00-00 \\nOleh: Samuel \\n \\n29. Perbaikan jalan di depan mess \\nCabang: Semar Nusantara Cabang Pedan \\nJatuh Tempo: 2023-03-01 \\nOleh: Samuel \\n \\n30. Perbaikan pintu \\nCabang: Semar Nusantara Cabang Pedan \\nJatuh Tempo: 0000-00-00 \\nOleh: Samuel \\n \\n31. Perbaikan Etaslase \\nCabang: Semar Nusantara Cabang Pedan \\nJatuh Tempo: 2023-02-28 \\nOleh: Samuel \\n \\n32. test trouble \\nCabang: Solo Baru \\nJatuh Tempo: 2023-02-28 \\nOleh: samuel \\n \\n33. Coba elkana admin  \\nCabang: Solo Baru \\nJatuh Tempo: 0000-00-00 \\nOleh: Samuel \\n \\n34. Coba elkana admin  \\nCabang: Solo Baru \\nJatuh Tempo: 0000-00-00 \\nOleh: samuel \\n \\n35. Kondisi Barang Ada Yang Rusak  \\nCabang: Solo Baru \\nJatuh Tempo: 2023-02-28 \\nOleh: samuel \\n \\n36. Lampu rusak \\nCabang: Klaten \\nJatuh Tempo: 2023-02-28 \\nOleh: Samuel \\n \\n37. 严重损坏的货物 \\nCabang: Klaten \\nJatuh Tempo: 0000-00-00 \\nOleh: samuel \\n \\n38. 严重损坏的货物 \\nCabang: Klaten \\nJatuh Tempo: 0000-00-00 \\nOleh: Samuel \\n \\n39. Hallo world \\nCabang: Klaten \\nJatuh Tempo: 2023-02-18 \\nOleh: samuel \\n \\n40. Hallo world \\nCabang: Klaten \\nJatuh Tempo: 2023-02-18 \\nOleh: Samuel \\n \\n41. Ada Barang Yang Cacat \\nCabang: Solo Baru \\nJatuh Tempo: 2023-02-16 \\nOleh: Samuel \\n \\n42. Barang tidak sesuai \\nCabang: Solo \\nJatuh Tempo: 2023-03-07 \\nOleh: Samuel \\n \\n43. Herbal \\nCabang: Klaten \\nJatuh Tempo: 0000-00-00 \\nOleh: samuel \\n \\n44. Herbal \\nCabang: Klaten \\nJatuh Tempo: 0000-00-00 \\nOleh: Samuel \\n \\n45. Genteng bocor \\nCabang: Klaten \\nJatuh Tempo: 0000-00-00 \\nOleh: samuel \\n \\n46. Genteng bocor \\nCabang: Klaten \\nJatuh Tempo: 0000-00-00 \\nOleh: Samuel \\n \\n47. Permintaan Lampu Klaten \\nCabang: Klaten \\nJatuh Tempo: 0000-00-00 \\nOleh: samuel \\n \\n48. Penambahan lampu \\nCabang: Klaten \\nJatuh Tempo: 0000-00-00 \\nOleh: Samuel \\n \\n49. Lorem ipsum dolor sit amet, \\nCabang: Klaten \\nJatuh Tempo: 2023-02-28 \\nOleh: Samuel', '2023-03-11 15:32:22', '2023-03-11 03:32:39'),
(5, 'email', 0, 'noreply@semar.co.id', 'Semar Housekeeping', 'sammy011088@gmail.com', 'Samuel', 'Reminder - 2023-03-11', 'Reminder - 2023-03-11<br/><br/>1. Toilet bocor <br/>Cabang: Semar Nusantara Cabang Malang<br/>Jatuh Tempo: 2023-03-31<br/>Oleh: Samuel<br/><br/>2. Perbaikan lampu  box dinding<br/>Cabang: Semar Nusantara Cabang Muntilan<br/>Jatuh Tempo: 2023-03-15<br/>Oleh: Samuel<br/><br/>3. Lampu mati<br/>Cabang: Semar Nusantara Cabang Demangan<br/>Jatuh Tempo: 2023-03-08<br/>Oleh: Samuel<br/><br/>4. Perbaikan Pintu<br/>Cabang: Semar Nusantara Cabang Bantul<br/>Jatuh Tempo: 2023-03-10<br/>Oleh: Samuel<br/><br/>5. perbaikan pintu<br/>Cabang: Semar Nusantara Cabang Karangayu<br/>Jatuh Tempo: 2023-03-10<br/>Oleh: Samuel<br/><br/>6. Barang Tidak Sesuai<br/>Cabang: Semar Nusantara Cabang Sukoharjo<br/>Jatuh Tempo: 2023-03-11<br/>Oleh: Samuel<br/><br/>7. Test<br/>Cabang: Semar Nusantara Cabang Sukoharjo<br/>Jatuh Tempo: 2023-03-08<br/>Oleh: Samuel<br/><br/>8. Lampu Rusak<br/>Cabang: Semar Nusantara Cabang Sukoharjo<br/>Jatuh Tempo: 2023-03-23<br/>Oleh: Samuel<br/><br/>9. permintaan batu<br/>Cabang: Order<br/>Jatuh Tempo: 2023-04-10<br/>Oleh: Samuel<br/><br/>10. cincin  o-0112302262<br/>Cabang: Order<br/>Jatuh Tempo: 2023-04-03<br/>Oleh: Samuel<br/><br/>11. Permintaan barang<br/>Cabang: Order<br/>Jatuh Tempo: 2023-03-31<br/>Oleh: Samuel<br/><br/>12. cincin putih - o-0152302221<br/>Cabang: Order<br/>Jatuh Tempo: 2023-03-15<br/>Oleh: Samuel<br/><br/>13. Order Alloy<br/>Cabang: Order<br/>Jatuh Tempo: 2023-03-04<br/>Oleh: Samuel<br/><br/>14. Laptop (percobaan)<br/>Cabang: Semar Nusantara Cabang Solo Radjiman<br/>Jatuh Tempo: 2023-03-03<br/>Oleh: Samuel<br/><br/>15. Perbaikan lampu display batangan display Peru logo semar<br/>Cabang: Semar Nusantara Cabang Klaten<br/>Jatuh Tempo: 2023-03-10<br/>Oleh: Samuel<br/><br/>16. PERMINTAAN PERLENGKAPAN<br/>Cabang: Semar Nusantara Cabang Tawangsari<br/>Jatuh Tempo: 2023-03-01<br/>Oleh: Samuel<br/><br/>17. PERBAIKAN LAMPU SOROT REKLAME<br/>Cabang: Semar Nusantara Cabang Tawangsari<br/>Jatuh Tempo: 2023-03-01<br/>Oleh: Samuel<br/><br/>18. perbaikan sanyo<br/>Cabang: Semar Nusantara Cabang Prambanan<br/>Jatuh Tempo: 2023-03-02<br/>Oleh: Samuel<br/><br/>19. Perbaikan genteng mess bocor<br/>Cabang: Semar Nusantara Cabang Kranggan<br/>Jatuh Tempo: 2023-03-02<br/>Oleh: Samuel<br/><br/>20. perbaikan<br/>Cabang: Semar Nusantara Cabang Kranggan<br/>Jatuh Tempo: 2023-03-10<br/>Oleh: Samuel<br/><br/>21. Minta tandon<br/>Cabang: Semar Nusantara Cabang Tawangsari<br/>Jatuh Tempo: 2023-03-31<br/>Oleh: Samuel<br/><br/>22. Permintaan Kursi Pembeli (Percobaan)<br/>Cabang: Semar Nusantara Cabang Solo Radjiman<br/>Jatuh Tempo: 2023-02-28<br/>Oleh: Samuel<br/><br/>23. perbaikan kaca etalase<br/>Cabang: Semar Nusantara Cabang Prambanan<br/>Jatuh Tempo: 2023-03-01<br/>Oleh: Samuel<br/><br/>24. perbaikan area parkir ganti plafon + cat<br/>Cabang: Semar Nusantara Cabang Pedan<br/>Jatuh Tempo: 2023-03-10<br/>Oleh: Samuel<br/><br/>25. PERBAIKAN LAMPU ETALASE<br/>Cabang: Semar Nusantara Cabang Tawangsari<br/>Jatuh Tempo: 2023-03-01<br/>Oleh: Samuel<br/><br/>26. Perbaikan kamar mandi<br/>Cabang: Semar Nusantara Cabang Banyumanik<br/>Jatuh Tempo: 2023-03-01<br/>Oleh: Samuel<br/><br/>27. perbaikan lampu etalase<br/>Cabang: Semar Nusantara Cabang Prambanan<br/>Jatuh Tempo: 2023-02-28<br/>Oleh: Samuel<br/><br/>28. Permintaan perbaikan toilet<br/>Cabang: Semar Nusantara Cabang Klaten<br/>Jatuh Tempo: <br/>Oleh: Samuel<br/><br/>29. Perbaikan jalan di depan mess<br/>Cabang: Semar Nusantara Cabang Pedan<br/>Jatuh Tempo: 2023-03-01<br/>Oleh: Samuel<br/><br/>30. Perbaikan pintu<br/>Cabang: Semar Nusantara Cabang Pedan<br/>Jatuh Tempo: <br/>Oleh: Samuel<br/><br/>31. Perbaikan Etaslase<br/>Cabang: Semar Nusantara Cabang Pedan<br/>Jatuh Tempo: 2023-02-28<br/>Oleh: Samuel<br/><br/>32. test trouble<br/>Cabang: Solo Baru<br/>Jatuh Tempo: 2023-02-28<br/>Oleh: samuel<br/><br/>33. Coba elkana admin <br/>Cabang: Solo Baru<br/>Jatuh Tempo: <br/>Oleh: Samuel<br/><br/>34. Coba elkana admin <br/>Cabang: Solo Baru<br/>Jatuh Tempo: <br/>Oleh: samuel<br/><br/>35. Kondisi Barang Ada Yang Rusak <br/>Cabang: Solo Baru<br/>Jatuh Tempo: 2023-02-28<br/>Oleh: samuel<br/><br/>36. Lampu rusak<br/>Cabang: Klaten<br/>Jatuh Tempo: 2023-02-28<br/>Oleh: Samuel<br/><br/>37. 严重损坏的货物<br/>Cabang: Klaten<br/>Jatuh Tempo: <br/>Oleh: samuel<br/><br/>38. 严重损坏的货物<br/>Cabang: Klaten<br/>Jatuh Tempo: <br/>Oleh: Samuel<br/><br/>39. Hallo world<br/>Cabang: Klaten<br/>Jatuh Tempo: 2023-02-18<br/>Oleh: samuel<br/><br/>40. Hallo world<br/>Cabang: Klaten<br/>Jatuh Tempo: 2023-02-18<br/>Oleh: Samuel<br/><br/>41. Ada Barang Yang Cacat<br/>Cabang: Solo Baru<br/>Jatuh Tempo: 2023-02-16<br/>Oleh: Samuel<br/><br/>42. Barang tidak sesuai<br/>Cabang: Solo<br/>Jatuh Tempo: 2023-03-07<br/>Oleh: Samuel<br/><br/>43. Herbal<br/>Cabang: Klaten<br/>Jatuh Tempo: <br/>Oleh: samuel<br/><br/>44. Herbal<br/>Cabang: Klaten<br/>Jatuh Tempo: <br/>Oleh: Samuel<br/><br/>45. Genteng bocor<br/>Cabang: Klaten<br/>Jatuh Tempo: <br/>Oleh: samuel<br/><br/>46. Genteng bocor<br/>Cabang: Klaten<br/>Jatuh Tempo: <br/>Oleh: Samuel<br/><br/>47. Permintaan Lampu Klaten<br/>Cabang: Klaten<br/>Jatuh Tempo: <br/>Oleh: samuel<br/><br/>48. Penambahan lampu<br/>Cabang: Klaten<br/>Jatuh Tempo: <br/>Oleh: Samuel<br/><br/>49. Lorem ipsum dolor sit amet,<br/>Cabang: Klaten<br/>Jatuh Tempo: 2023-02-28<br/>Oleh: Samuel', '2023-03-11 15:34:29', '2023-03-11 03:32:39'),
(6, 'whatsapp', 0, '', 'Semar Housekeeping', '08122680110', 'Samuel', 'Reminder - 2023-03-11', 'Reminder - 2023-03-11 \n \n1. Toilet bocor  \nCabang: Semar Nusantara Cabang Malang \nJatuh Tempo: 2023-03-31 \nOleh: Samuel \n \n2. Perbaikan lampu  box dinding \nCabang: Semar Nusantara Cabang Muntilan \nJatuh Tempo: 2023-03-15 \nOleh: Samuel \n \n3. Lampu mati \nCabang: Semar Nusantara Cabang Demangan \nJatuh Tempo: 2023-03-08 \nOleh: Samuel \n \n4. Perbaikan Pintu \nCabang: Semar Nusantara Cabang Bantul \nJatuh Tempo: 2023-03-10 \nOleh: Samuel \n \n5. perbaikan pintu \nCabang: Semar Nusantara Cabang Karangayu \nJatuh Tempo: 2023-03-10 \nOleh: Samuel \n \n6. Barang Tidak Sesuai \nCabang: Semar Nusantara Cabang Sukoharjo \nJatuh Tempo: 2023-03-11 \nOleh: Samuel \n \n7. Test \nCabang: Semar Nusantara Cabang Sukoharjo \nJatuh Tempo: 2023-03-08 \nOleh: Samuel \n \n8. Lampu Rusak \nCabang: Semar Nusantara Cabang Sukoharjo \nJatuh Tempo: 2023-03-23 \nOleh: Samuel \n \n9. permintaan batu \nCabang: Order \nJatuh Tempo: 2023-04-10 \nOleh: Samuel \n \n10. cincin  o-0112302262 \nCabang: Order \nJatuh Tempo: 2023-04-03 \nOleh: Samuel \n \n11. Permintaan barang \nCabang: Order \nJatuh Tempo: 2023-03-31 \nOleh: Samuel \n \n12. cincin putih - o-0152302221 \nCabang: Order \nJatuh Tempo: 2023-03-15 \nOleh: Samuel \n \n13. Order Alloy \nCabang: Order \nJatuh Tempo: 2023-03-04 \nOleh: Samuel \n \n14. Laptop (percobaan) \nCabang: Semar Nusantara Cabang Solo Radjiman \nJatuh Tempo: 2023-03-03 \nOleh: Samuel \n \n15. Perbaikan lampu display batangan display Peru logo semar \nCabang: Semar Nusantara Cabang Klaten \nJatuh Tempo: 2023-03-10 \nOleh: Samuel \n \n16. PERMINTAAN PERLENGKAPAN \nCabang: Semar Nusantara Cabang Tawangsari \nJatuh Tempo: 2023-03-01 \nOleh: Samuel \n \n17. PERBAIKAN LAMPU SOROT REKLAME \nCabang: Semar Nusantara Cabang Tawangsari \nJatuh Tempo: 2023-03-01 \nOleh: Samuel \n \n18. perbaikan sanyo \nCabang: Semar Nusantara Cabang Prambanan \nJatuh Tempo: 2023-03-02 \nOleh: Samuel \n \n19. Perbaikan genteng mess bocor \nCabang: Semar Nusantara Cabang Kranggan \nJatuh Tempo: 2023-03-02 \nOleh: Samuel \n \n20. perbaikan \nCabang: Semar Nusantara Cabang Kranggan \nJatuh Tempo: 2023-03-10 \nOleh: Samuel \n \n21. Minta tandon \nCabang: Semar Nusantara Cabang Tawangsari \nJatuh Tempo: 2023-03-31 \nOleh: Samuel \n \n22. Permintaan Kursi Pembeli (Percobaan) \nCabang: Semar Nusantara Cabang Solo Radjiman \nJatuh Tempo: 2023-02-28 \nOleh: Samuel \n \n23. perbaikan kaca etalase \nCabang: Semar Nusantara Cabang Prambanan \nJatuh Tempo: 2023-03-01 \nOleh: Samuel \n \n24. perbaikan area parkir ganti plafon + cat \nCabang: Semar Nusantara Cabang Pedan \nJatuh Tempo: 2023-03-10 \nOleh: Samuel \n \n25. PERBAIKAN LAMPU ETALASE \nCabang: Semar Nusantara Cabang Tawangsari \nJatuh Tempo: 2023-03-01 \nOleh: Samuel \n \n26. Perbaikan kamar mandi \nCabang: Semar Nusantara Cabang Banyumanik \nJatuh Tempo: 2023-03-01 \nOleh: Samuel \n \n27. perbaikan lampu etalase \nCabang: Semar Nusantara Cabang Prambanan \nJatuh Tempo: 2023-02-28 \nOleh: Samuel \n \n28. Permintaan perbaikan toilet \nCabang: Semar Nusantara Cabang Klaten \nJatuh Tempo:  \nOleh: Samuel \n \n29. Perbaikan jalan di depan mess \nCabang: Semar Nusantara Cabang Pedan \nJatuh Tempo: 2023-03-01 \nOleh: Samuel \n \n30. Perbaikan pintu \nCabang: Semar Nusantara Cabang Pedan \nJatuh Tempo:  \nOleh: Samuel \n \n31. Perbaikan Etaslase \nCabang: Semar Nusantara Cabang Pedan \nJatuh Tempo: 2023-02-28 \nOleh: Samuel \n \n32. test trouble \nCabang: Solo Baru \nJatuh Tempo: 2023-02-28 \nOleh: samuel \n \n33. Coba elkana admin  \nCabang: Solo Baru \nJatuh Tempo:  \nOleh: Samuel \n \n34. Coba elkana admin  \nCabang: Solo Baru \nJatuh Tempo:  \nOleh: samuel \n \n35. Kondisi Barang Ada Yang Rusak  \nCabang: Solo Baru \nJatuh Tempo: 2023-02-28 \nOleh: samuel \n \n36. Lampu rusak \nCabang: Klaten \nJatuh Tempo: 2023-02-28 \nOleh: Samuel \n \n37. 严重损坏的货物 \nCabang: Klaten \nJatuh Tempo:  \nOleh: samuel \n \n38. 严重损坏的货物 \nCabang: Klaten \nJatuh Tempo:  \nOleh: Samuel \n \n39. Hallo world \nCabang: Klaten \nJatuh Tempo: 2023-02-18 \nOleh: samuel \n \n40. Hallo world \nCabang: Klaten \nJatuh Tempo: 2023-02-18 \nOleh: Samuel \n \n41. Ada Barang Yang Cacat \nCabang: Solo Baru \nJatuh Tempo: 2023-02-16 \nOleh: Samuel \n \n42. Barang tidak sesuai \nCabang: Solo \nJatuh Tempo: 2023-03-07 \nOleh: Samuel \n \n43. Herbal \nCabang: Klaten \nJatuh Tempo:  \nOleh: samuel \n \n44. Herbal \nCabang: Klaten \nJatuh Tempo:  \nOleh: Samuel \n \n45. Genteng bocor \nCabang: Klaten \nJatuh Tempo:  \nOleh: samuel \n \n46. Genteng bocor \nCabang: Klaten \nJatuh Tempo:  \nOleh: Samuel \n \n47. Permintaan Lampu Klaten \nCabang: Klaten \nJatuh Tempo:  \nOleh: samuel \n \n48. Penambahan lampu \nCabang: Klaten \nJatuh Tempo:  \nOleh: Samuel \n \n49. Lorem ipsum dolor sit amet, \nCabang: Klaten \nJatuh Tempo: 2023-02-28 \nOleh: Samuel', '2023-03-11 15:34:29', '2023-03-11 03:34:38');

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

--
-- Table structure for table `notification_templates`
--

CREATE TABLE `notification_templates` (
  `nt_id` int(11) NOT NULL,
  `nt_slug` varchar(255) NOT NULL,
  `nt_type` varchar(25) NOT NULL COMMENT '[whatsapp,email]',
  `nt_title` varchar(255) NOT NULL,
  `nt_content` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `notification_templates`
--

INSERT INTO `notification_templates` (`nt_id`, `nt_slug`, `nt_type`, `nt_title`, `nt_content`) VALUES
(1, 'whatsapp-general-notification', 'whatsapp', '{{title}}', '{{content}}'),
(2, 'email-general-notification', 'email', '{{title}}', '{{content}}');

--
-- Indexes for table `admin_branches`
--
ALTER TABLE `admin_branches`
  ADD PRIMARY KEY (`ab_id`);

--
-- Indexes for table `branches`
--
ALTER TABLE `branches`
  ADD PRIMARY KEY (`branch_id`),
  ADD KEY `branch_insert_admin_id` (`branch_insert_admin_id`),
  ADD KEY `branch_update_admin_id` (`branch_update_admin_id`),
  ADD KEY `branch_delete_admin_id` (`branch_delete_admin_id`);

--
-- Indexes for table `cases`
--
ALTER TABLE `cases`
  ADD PRIMARY KEY (`case_id`),
  ADD KEY `case_insert_admin_id` (`case_insert_admin_id`),
  ADD KEY `case_update_admin_id` (`case_update_admin_id`),
  ADD KEY `case_number` (`case_number`),
  ADD KEY `case_date` (`case_date`),
  ADD KEY `case_due_date` (`case_due_date`),
  ADD KEY `case_status` (`case_status`),
  ADD KEY `case_branch_id` (`case_branch_id`),
  ADD KEY `case_type_id` (`case_type_id`);

--
-- Indexes for table `case_admins`
--
ALTER TABLE `case_admins`
  ADD PRIMARY KEY (`ca_id`),
  ADD KEY `ca_admin_id` (`ca_admin_id`),
  ADD KEY `ca_insert_admin_id` (`ca_insert_admin_id`),
  ADD KEY `ca_delete_admin_id` (`ca_delete_admin_id`),
  ADD KEY `ca_case_id` (`ca_case_id`);

--
-- Indexes for table `case_attachments`
--
ALTER TABLE `case_attachments`
  ADD PRIMARY KEY (`ca_id`);

--
-- Indexes for table `case_comments`
--
ALTER TABLE `case_comments`
  ADD PRIMARY KEY (`cc_id`),
  ADD KEY `cc_insert_admin_id` (`cc_insert_admin_id`),
  ADD KEY `cc_case_id` (`cc_case_id`);

--
-- Indexes for table `case_comment_notifications`
--
ALTER TABLE `case_comment_notifications`
  ADD PRIMARY KEY (`ccn_id`),
  ADD KEY `ccn_cc_id` (`ccn_cc_id`),
  ADD KEY `ccn_admin_id` (`ccn_admin_id`);

--
-- Indexes for table `case_types`
--
ALTER TABLE `case_types`
  ADD PRIMARY KEY (`ct_id`);

--
-- Indexes for table `notification_queue`
--
ALTER TABLE `notification_queue`
  ADD PRIMARY KEY (`nq_id`),
  ADD KEY `nq_admin_id` (`nq_admin_id`);

--
-- Indexes for table `notification_templates`
--
ALTER TABLE `notification_templates`
  ADD PRIMARY KEY (`nt_id`);

--
-- AUTO_INCREMENT for table `admin_branches`
--
ALTER TABLE `admin_branches`
  MODIFY `ab_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=414;

--
-- AUTO_INCREMENT for table `branches`
--
ALTER TABLE `branches`
  MODIFY `branch_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `cases`
--
ALTER TABLE `cases`
  MODIFY `case_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;

--
-- AUTO_INCREMENT for table `case_admins`
--
ALTER TABLE `case_admins`
  MODIFY `ca_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=362;

--
-- AUTO_INCREMENT for table `case_attachments`
--
ALTER TABLE `case_attachments`
  MODIFY `ca_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `case_comments`
--
ALTER TABLE `case_comments`
  MODIFY `cc_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=149;

--
-- AUTO_INCREMENT for table `case_comment_notifications`
--
ALTER TABLE `case_comment_notifications`
  MODIFY `ccn_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `case_types`
--
ALTER TABLE `case_types`
  MODIFY `ct_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `notification_queue`
--
ALTER TABLE `notification_queue`
  MODIFY `nq_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `notification_templates`
--
ALTER TABLE `notification_templates`
  MODIFY `nt_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

