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

--
-- 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', 0, '2023-02-24 04:26:47', 1, 0),
(2, 1, 2, '2023-02-01 09:33:01', 0, '2023-02-24 04:26:47', 1, 0),
(3, 2, 1, '2023-02-01 09:36:13', 0, '2023-02-01 15:26:35', 1, 0),
(4, 2, 1, '2023-02-01 15:26:29', 0, '2023-02-01 15:26:35', 1, 0),
(5, 2, 2, '2023-02-01 15:26:29', 0, '2023-02-01 15:26:35', 1, 0),
(6, 2, 1, '2023-02-01 15:26:35', 0, NULL, NULL, 1),
(7, 3, 2, '2023-02-02 05:54:05', 0, NULL, NULL, 1),
(8, 4, 1, '2023-02-07 03:40:26', 0, '2023-02-07 03:42:35', 1, 0),
(9, 4, 2, '2023-02-07 03:40:26', 0, '2023-02-07 03:42:35', 1, 0),
(10, 4, 1, '2023-02-07 03:42:35', 0, NULL, NULL, 1),
(11, 4, 2, '2023-02-07 03:42:35', 0, NULL, NULL, 1),
(12, 5, 1, '2023-02-07 03:42:57', 0, NULL, NULL, 1),
(13, 5, 2, '2023-02-07 03:42:57', 0, NULL, NULL, 1),
(14, 1, 1, '2023-02-07 03:43:47', 0, '2023-02-24 04:26:47', 1, 0),
(15, 1, 2, '2023-02-07 03:43:47', 0, '2023-02-24 04:26:47', 1, 0),
(16, 1, 1, '2023-02-24 04:26:47', 1, NULL, NULL, 1),
(17, 1, 2, '2023-02-24 04:26:47', 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;

--
-- 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-06 10:11:11', 1, NULL, NULL, 1),
(2, 'Solo', '0181881881', 'Solo', '2023-01-25 08:48:35', 1, NULL, NULL, NULL, NULL, 1),
(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);

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

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

--
-- 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', '2023-03-02', 'Completed', '2023-02-02 03:43:03', 1, '2023-02-24 10:47:45', 1),
(2, 2, 1, '1479226573', 'Lorem ipsum dolor sit amet,', '2023-02-06', '2023-02-13', NULL, 'New', '2023-02-06 03:44:16', 1, NULL, 0),
(3, 1, 1, '263460601', 'Lorem ipsum dolor sit a', '2023-02-06', '0000-00-00', NULL, 'New', '2023-02-06 09:39:09', 1, NULL, 0),
(4, 1, 1, '1141871588', 'Lorem ipsum dolor sit a', '2023-02-06', '0000-00-00', NULL, 'New', '2023-02-06 09:39:32', 1, NULL, 0),
(5, 2, 1, '65908580', 'Hallo World', '2023-02-06', '0000-00-00', NULL, 'New', '2023-02-06 09:57:35', 2, NULL, 0),
(6, 2, 1, '1746825732', 'Hallo World 1', '2023-02-06', '0000-00-00', NULL, 'New', '2023-02-06 09:58:04', 2, NULL, 0),
(7, 2, 1, '189113765', 'Hello World', '2023-02-06', '0000-00-00', NULL, 'New', '2023-02-06 10:00:14', 1, NULL, 0),
(8, 1, 2, '1177083082', 'Herbal', '2023-02-06', '0000-00-00', NULL, 'New', '2023-02-06 10:05:02', 1, '2023-02-24 10:39:45', 1),
(9, 1, 1, '1528755953', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit', '2023-02-06', '2023-02-06', '2023-02-06', 'Completed', '2023-02-06 10:08:50', 1, '2023-02-24 10:35:11', 1),
(10, 2, 1, '788077517', 'Lorem ipsum dolor sit amet,', '2023-02-06', '0000-00-00', '2023-02-06', 'Completed', '2023-02-06 10:09:27', 1, '2023-02-24 10:35:45', 1),
(11, 2, 1, '1003384914', 'Lorem ipsum dolor sit amet,ll', '2023-02-06', '2023-02-06', NULL, 'New', '2023-02-06 10:11:41', 2, '2023-02-06 10:21:29', 2),
(12, 1, 1, '1251260519', 'asas', '2023-02-06', '0000-00-00', NULL, 'New', '2023-02-06 10:16:18', 1, NULL, 0),
(13, 1, 1, '778030009', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit', '2023-02-06', '0000-00-00', '2023-02-06', 'Completed', '2023-02-06 10:16:48', 1, '2023-02-24 10:35:50', 1),
(14, 1, 1, '1647234672', 'Lorem ipsum dolor sit amet, 22', '2023-02-06', '0000-00-00', '2023-02-06', 'Cancel', '2023-02-06 10:17:49', 1, '2023-02-24 10:35:55', 1),
(15, 1, 1, '980199126', 'Lorem ipsum Lorem ipsum Lorem ipsum', '2023-02-06', '0000-00-00', NULL, 'New', '2023-02-06 10:36:29', 2, NULL, 0),
(16, 1, 1, '1709431503', 'Hai', '2023-02-07', '0000-00-00', '2023-02-07', 'Completed', '2023-02-07 03:56:44', 1, '2023-02-24 10:36:01', 1),
(17, 1, 1, '423818804', 'Lorem ipsum dolo', '2023-02-07', '0000-00-00', '2023-02-07', 'Completed', '2023-02-07 04:28:45', 1, '2023-02-24 10:36:06', 1),
(18, 1, 1, '1513920172', 'Lorem ipsum dolor sit amet,', '2023-02-07', '0000-00-00', '2023-02-07', 'Completed', '2023-02-07 04:33:51', 1, '2023-02-24 10:36:10', 1),
(19, 1, 1, '750966917', 'Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet,', '2023-02-07', '0000-00-00', '2023-02-07', 'Completed', '2023-02-07 10:05:16', 1, '2023-02-24 10:36:14', 1),
(20, 1, 1, '1735030435', 'Lorem ipsum dolor sit amet, Lorem ', '2023-02-07', '0000-00-00', '2023-02-07', 'Completed', '2023-02-07 10:09:22', 1, '2023-02-24 10:36:18', 1),
(21, 1, 1, '448913380', 'Lorem ipsum dolor sit amet, consectetur ', '2023-02-07', '0000-00-00', '2023-02-07', 'Cancel', '2023-02-07 10:13:07', 1, '2023-02-24 10:36:23', 1),
(22, 1, 1, '628960156', 'Lorem ipsum dolor sit amet,', '2023-02-08', '0000-00-00', NULL, 'New', '2023-02-08 04:31:49', 2, NULL, 0),
(23, 1, 1, '242662926', 'Lorem ipsum dolor sit amet,', '2023-03-02', '2023-03-02', NULL, 'Completed', '2023-03-02 02:40:59', 1, '2023-03-02 02:43:39', 1),
(24, 1, 1, '1276833139', 'qssdd', '2023-03-06', '2023-03-11', NULL, 'New', '2023-03-06 02:30:05', 1, NULL, 0),
(25, 1, 1, '113457371', 'Haloo', '2023-03-06', '2023-03-07', NULL, 'New', '2023-03-06 02:31:05', 1, NULL, 0),
(26, 1, 1, '1949131261', 'Alif', '2023-03-06', '2023-03-06', NULL, 'Progress', '2023-03-06 03:59:23', 4, '2023-03-06 04:00:30', 4);

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

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

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

INSERT INTO `case_admins` (`ca_id`, `ca_admin_id`, `ca_case_id`, `ca_insert_at`, `ca_insert_admin_id`, `ca_delete_at`, `ca_delete_admin_id`, `ca_active`) VALUES
(1, 1, 1, '2023-02-02 03:43:03', 1, NULL, NULL, 1),
(2, 2, 1, '2023-02-02 03:43:03', 1, '2023-02-03 08:58:48', 1, 0),
(3, 3, 1, '2023-02-02 08:02:10', 1, '2023-02-02 08:23:26', 1, 0),
(4, 3, 1, '2023-02-02 08:14:15', 1, '2023-02-02 08:23:26', 1, 0),
(5, 3, 1, '2023-02-02 08:14:37', 1, '2023-02-02 08:23:26', 1, 0),
(6, 3, 1, '2023-02-02 08:22:18', 1, '2023-02-02 08:23:26', 1, 0),
(7, 3, 1, '2023-02-02 08:23:24', 1, '2023-02-02 08:23:26', 1, 0),
(8, 2, 1, '2023-02-02 13:18:13', 1, '2023-02-03 08:58:48', 1, 0),
(9, 2, 1, '2023-02-03 08:58:50', 1, NULL, NULL, 1),
(10, 3, 1, '2023-02-06 03:40:29', 1, NULL, NULL, 1),
(11, 1, 2, '2023-02-06 03:44:16', 1, NULL, NULL, 1),
(12, 2, 2, '2023-02-06 03:44:16', 1, NULL, NULL, 1),
(13, 1, 4, '2023-02-06 09:39:32', 1, NULL, NULL, 1),
(14, 2, 4, '2023-02-06 09:39:32', 1, NULL, NULL, 1),
(15, 2, 6, '2023-02-06 09:58:04', 2, NULL, NULL, 1),
(16, 1, 7, '2023-02-06 10:00:14', 1, NULL, NULL, 1),
(17, 2, 7, '2023-02-06 10:00:14', 1, NULL, NULL, 1),
(18, 1, 8, '2023-02-06 10:05:02', 1, NULL, NULL, 1),
(19, 1, 9, '2023-02-06 10:08:50', 1, NULL, NULL, 1),
(20, 2, 9, '2023-02-06 10:08:51', 1, NULL, NULL, 1),
(21, 1, 10, '2023-02-06 10:09:27', 1, NULL, NULL, 1),
(22, 2, 10, '2023-02-06 10:09:28', 1, NULL, NULL, 1),
(23, 2, 11, '2023-02-06 10:11:41', 2, NULL, NULL, 1),
(24, 1, 13, '2023-02-06 10:16:48', 1, NULL, NULL, 1),
(25, 2, 13, '2023-02-06 10:16:49', 1, NULL, NULL, 1),
(26, 1, 14, '2023-02-06 10:17:49', 1, NULL, NULL, 1),
(27, 2, 14, '2023-02-06 10:17:50', 1, NULL, NULL, 1),
(28, 2, 15, '2023-02-06 10:36:29', 2, NULL, NULL, 1),
(29, 2, 16, '2023-02-07 03:56:44', 1, NULL, NULL, 1),
(30, 1, 16, '2023-02-07 03:56:45', 1, NULL, NULL, 1),
(31, 2, 17, '2023-02-07 04:28:45', 1, NULL, NULL, 1),
(32, 1, 17, '2023-02-07 04:28:47', 1, NULL, NULL, 1),
(33, 2, 18, '2023-02-07 04:33:51', 1, NULL, NULL, 1),
(34, 1, 18, '2023-02-07 04:33:53', 1, NULL, NULL, 1),
(35, 2, 19, '2023-02-07 10:05:16', 1, NULL, NULL, 1),
(36, 1, 19, '2023-02-07 10:05:17', 1, NULL, NULL, 1),
(37, 2, 20, '2023-02-07 10:09:22', 1, NULL, NULL, 1),
(38, 1, 20, '2023-02-07 10:09:24', 1, NULL, NULL, 1),
(39, 2, 21, '2023-02-07 10:13:07', 1, NULL, NULL, 1),
(40, 1, 21, '2023-02-07 10:13:08', 1, NULL, NULL, 1),
(41, 2, 22, '2023-02-08 04:31:49', 2, '2023-03-02 03:01:44', 1, 0),
(42, 1, 22, '2023-02-08 04:32:35', 2, NULL, NULL, 1),
(43, 3, 22, '2023-02-24 04:19:17', 1, '2023-03-02 03:16:41', 1, 0),
(44, 2, 23, '2023-03-02 02:40:59', 1, NULL, NULL, 1),
(45, 1, 23, '2023-03-02 02:41:01', 1, NULL, NULL, 1),
(46, 3, 22, '2023-03-02 03:16:36', 1, '2023-03-02 03:16:41', 1, 0),
(47, 2, 24, '2023-03-06 02:30:06', 1, NULL, NULL, 1),
(48, 1, 24, '2023-03-06 02:30:06', 1, NULL, NULL, 1),
(49, 2, 25, '2023-03-06 02:31:05', 1, NULL, NULL, 1),
(50, 1, 25, '2023-03-06 02:31:05', 1, NULL, NULL, 1),
(51, 2, 26, '2023-03-06 03:59:23', 4, NULL, NULL, 1),
(52, 4, 26, '2023-03-06 03:59:23', 4, NULL, NULL, 1),
(53, 1, 26, '2023-03-06 03:59:23', 4, 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;

--
-- 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, 7, 'jpg', 'http://localhost:8084/uploads/attachments/794026147_OIP2.jpg', '2023-02-03 09:06:12', 1, NULL, NULL),
(7, 16, 'png', 'http://localhost:8084/uploads/attachments/1674167963_car23773.png', '2023-02-06 03:41:01', 1, NULL, NULL),
(8, 18, 'jpg', 'http://localhost:8084/uploads/attachments/2060337312_audir8.jpg', '2023-02-06 05:28:30', 1, 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;

--
-- 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>Hallo Semuanya</p>', '2023-02-03 09:05:30', 1, NULL, NULL, 1),
(6, 1, '<p>Hallo </p>', '2023-02-03 09:06:00', 1, NULL, NULL, 1),
(7, 1, '<p>Hallo World</p>', '2023-02-03 09:06:12', 1, NULL, NULL, 1),
(8, 1, '<p>Selamat Siang</p>', '2023-02-03 09:07:21', 2, NULL, NULL, 1),
(9, 1, '<p>Hallo </p>', '2023-02-03 09:16:24', 1, NULL, NULL, 1),
(10, 1, '<p>Hello World</p>', '2023-02-03 09:17:06', 2, NULL, NULL, 1),
(11, 1, '<p>HAllo</p>', '2023-02-06 03:31:33', 1, NULL, NULL, 1),
(12, 1, '<p>Lorem ipsum</p>', '2023-02-06 03:32:31', 1, NULL, NULL, 1),
(13, 1, '<p>Lorem ipsum</p>', '2023-02-06 03:34:31', 1, NULL, NULL, 1),
(14, 1, '<p>Lorem ipsum</p>', '2023-02-06 03:35:21', 1, NULL, NULL, 1),
(15, 1, '<p>Lorem ipsum</p>', '2023-02-06 03:40:01', 1, NULL, NULL, 1),
(16, 1, '<p>Haii aaa</p>', '2023-02-06 03:41:01', 1, NULL, NULL, 1),
(17, 2, '<p>Hallo</p>', '2023-02-06 04:07:10', 1, NULL, NULL, 1),
(18, 2, '<p>Hallo</p>', '2023-02-06 05:28:30', 1, NULL, NULL, 1),
(19, 2, '<p>aaaaaaaaaa</p>', '2023-02-06 05:28:58', 1, NULL, NULL, 1),
(20, 2, '<p>Hai123</p>', '2023-02-06 05:31:06', 1, NULL, NULL, 1),
(21, 2, '<p>wwwwwwwwwwww</p>', '2023-02-06 05:31:26', 1, NULL, NULL, 1),
(22, 2, '<p>sdsdsd</p>', '2023-02-06 05:33:10', 1, NULL, NULL, 1),
(23, 4, 'Tes', '2023-02-06 09:39:32', 1, NULL, NULL, 1),
(24, 5, 'Hallo', '2023-02-06 09:57:35', 2, NULL, NULL, 1),
(25, 6, 'Hallo', '2023-02-06 09:58:04', 2, NULL, NULL, 1),
(26, 7, 'Hai', '2023-02-06 10:00:14', 1, NULL, NULL, 1),
(27, 8, 'Tes', '2023-02-06 10:05:02', 1, NULL, NULL, 1),
(28, 9, 'aaa', '2023-02-06 10:08:50', 1, NULL, NULL, 1),
(29, 10, 'tes', '2023-02-06 10:09:27', 1, NULL, NULL, 1),
(30, 11, 'kkk', '2023-02-06 10:11:41', 2, NULL, NULL, 1),
(31, 12, 'aaa', '2023-02-06 10:16:18', 1, NULL, NULL, 1),
(32, 13, 'aaa', '2023-02-06 10:16:48', 1, NULL, NULL, 1),
(33, 14, 'Hai', '2023-02-06 10:17:49', 1, NULL, NULL, 1),
(34, 15, 'Horee', '2023-02-06 10:36:29', 2, NULL, NULL, 1),
(35, 16, 'Tessss', '2023-02-07 03:56:44', 1, NULL, NULL, 1),
(36, 17, 'Hallo', '2023-02-07 04:28:45', 1, NULL, NULL, 1),
(37, 18, 'Tes', '2023-02-07 04:33:51', 1, NULL, NULL, 1),
(38, 18, '<p>Hallo s</p>', '2023-02-07 09:50:57', 1, NULL, NULL, 1),
(39, 18, '<p>Hallo s</p>', '2023-02-07 09:51:58', 1, NULL, NULL, 1),
(40, 19, 'Tes', '2023-02-07 10:05:16', 1, NULL, NULL, 1),
(41, 20, 'Lorem ipsum dolor sit ', '2023-02-07 10:09:22', 1, NULL, NULL, 1),
(42, 21, 'adipisicing elit', '2023-02-07 10:13:07', 1, NULL, NULL, 1),
(43, 21, '<p>Haiii</p>', '2023-02-07 10:19:56', 1, NULL, NULL, 1),
(44, 21, '<p>Haiii</p>', '2023-02-07 10:22:17', 1, NULL, NULL, 1),
(45, 21, '<p>Haiii</p>', '2023-02-07 10:25:20', 1, NULL, NULL, 1),
(46, 21, '<p>Hallo</p>', '2023-02-07 10:27:46', 1, NULL, NULL, 1),
(47, 21, '<p>Testing</p>', '2023-02-07 10:28:14', 1, NULL, NULL, 1),
(48, 21, '<p>asasas</p>', '2023-02-07 17:16:51', 1, NULL, NULL, 1),
(49, 21, '<p>asasa</p>', '2023-02-07 17:19:36', 1, NULL, NULL, 1),
(50, 21, '<p>Hallo World</p>', '2023-02-08 01:42:19', 1, NULL, NULL, 1),
(51, 21, '<p>Hallo World</p>', '2023-02-08 01:49:42', 1, NULL, NULL, 1),
(52, 21, '<p>Tesss</p>', '2023-02-08 01:58:42', 2, NULL, NULL, 1),
(53, 22, 'Hai', '2023-02-08 04:31:49', 2, NULL, NULL, 1),
(54, 22, '<p>Hallo</p>', '2023-02-08 04:32:53', 2, NULL, NULL, 1),
(55, 22, '<p>Tesss</p>', '2023-02-08 04:33:31', 1, NULL, NULL, 1),
(56, 13, '<p>asasa</p>', '2023-02-10 09:19:28', 1, NULL, NULL, 1),
(57, 13, '<p>Hallo World</p>', '2023-02-10 09:20:09', 1, NULL, NULL, 1),
(58, 10, '<p>Hallo World</p>', '2023-02-10 09:48:56', 1, NULL, NULL, 1),
(59, 8, '<p>asasasa</p>', '2023-02-10 10:46:19', 1, NULL, NULL, 1),
(60, 23, 'Tes', '2023-03-02 02:40:59', 1, NULL, NULL, 1),
(61, 23, '<p>Hallo</p>', '2023-03-02 02:41:20', 1, NULL, NULL, 1),
(62, 24, 'ddd', '2023-03-06 02:30:06', 1, NULL, NULL, 1),
(63, 25, 'Hai', '2023-03-06 02:31:05', 1, NULL, NULL, 1),
(64, 26, 'tes', '2023-03-06 03:59:23', 4, NULL, NULL, 1),
(65, 26, '<p>Tes qq</p>', '2023-03-06 04:00:30', 4, 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 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`) VALUES
(1, 22, 1, 12, 2, '2023-02-08 04:12:58'),
(2, 49, 1, 1, 5, '2023-02-08 04:19:15'),
(3, 49, 2, 1, 5, '2023-02-08 04:19:13'),
(4, 55, 1, 1, 9, '2023-02-08 04:35:50'),
(5, 58, 1, 0, 0, '2023-02-10 09:49:10'),
(6, 54, 1, 1, 10, '2023-02-24 04:20:01');

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

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

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

--
-- 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
(1, 'whatsapp', 1, '6285726715114', 'Oluchi Solution', '6285726715114', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<p>Lorem ipsum</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:23'),
(2, 'email', 1, 'semar@gmail.com', 'Oluchi Solution', 'semar@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<p>Lorem ipsum</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:25'),
(3, 'whatsapp', 2, '6285726715114', 'Oluchi Solution', '6285726715114', 'Alif', 'Lorem ipsum dolor sit amet,', '<p>Lorem ipsum</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:25'),
(4, 'email', 2, 'semar@gmail.com', 'Oluchi Solution', 'alif@gmail.com', 'Alif', 'Lorem ipsum dolor sit amet,', '<p>Lorem ipsum</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:26'),
(5, 'whatsapp', 1, '6285726715114', 'Oluchi Solution', '6285726715114', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<p>Haii aaa</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:27'),
(6, 'email', 1, 'semar@gmail.com', 'Oluchi Solution', 'semar@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<p>Haii aaa</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:28'),
(7, 'whatsapp', 2, '6285726715114', 'Oluchi Solution', '6285726715114', 'Alif', 'Lorem ipsum dolor sit amet,', '<p>Haii aaa</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:28'),
(8, 'email', 2, 'semar@gmail.com', 'Oluchi Solution', 'alif@gmail.com', 'Alif', 'Lorem ipsum dolor sit amet,', '<p>Haii aaa</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:29'),
(9, 'whatsapp', 3, '6285726715114', 'Oluchi Solution', '6285726715114', 'elkana', 'Lorem ipsum dolor sit amet,', '<p>Haii aaa</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:30'),
(10, 'email', 3, 'semar@gmail.com', 'Oluchi Solution', 'elkana@gmail.com', 'elkana', 'Lorem ipsum dolor sit amet,', '<p>Haii aaa</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:30'),
(11, 'whatsapp', 1, '6285726715114', 'Oluchi Solution', '6285726715114', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, <br> Tanggal : 2023-02-06 <br> Batas Tanggal : 2023-02-13', '0000-00-00 00:00:00', '2023-03-06 02:24:31'),
(12, 'email', 1, 'semar@gmail.com', 'Oluchi Solution', 'semar@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, <br> Tanggal : 2023-02-06 <br> Batas Tanggal : 2023-02-13', '0000-00-00 00:00:00', '2023-03-06 02:24:32'),
(13, 'whatsapp', 2, '6285726715114', 'Oluchi Solution', '6285726715114', 'Alif', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, <br> Tanggal : 2023-02-06 <br> Batas Tanggal : 2023-02-13', '0000-00-00 00:00:00', '2023-03-06 02:24:32'),
(14, 'email', 2, 'semar@gmail.com', 'Oluchi Solution', 'alif@gmail.com', 'Alif', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, <br> Tanggal : 2023-02-06 <br> Batas Tanggal : 2023-02-13', '0000-00-00 00:00:00', '2023-03-06 02:24:33'),
(15, 'whatsapp', 1, '6285726715114', 'Oluchi Solution', '6285726715114', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<p>Hallo</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:33'),
(16, 'email', 1, 'semar@gmail.com', 'Oluchi Solution', 'semar@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<p>Hallo</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:34'),
(17, 'whatsapp', 2, '6285726715114', 'Oluchi Solution', '6285726715114', 'Alif', 'Lorem ipsum dolor sit amet,', '<p>Hallo</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:35'),
(18, 'email', 2, 'semar@gmail.com', 'Oluchi Solution', 'alif@gmail.com', 'Alif', 'Lorem ipsum dolor sit amet,', '<p>Hallo</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:35'),
(19, 'whatsapp', 1, '6285726715114', 'Oluchi Solution', '6285726715114', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<p>Hallo</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:36'),
(20, 'email', 1, 'semar@gmail.com', 'Oluchi Solution', 'semar@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<p>Hallo</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:37'),
(21, 'whatsapp', 2, '6285726715114', 'Oluchi Solution', '6285726715114', 'Alif', 'Lorem ipsum dolor sit amet,', '<p>Hallo</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:37'),
(22, 'email', 2, 'semar@gmail.com', 'Oluchi Solution', 'alif@gmail.com', 'Alif', 'Lorem ipsum dolor sit amet,', '<p>Hallo</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:38'),
(23, 'whatsapp', 1, '6285726715114', 'Oluchi Solution', '6285726715114', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<p>aaaaaaaaaa</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:38'),
(24, 'email', 1, 'semar@gmail.com', 'Oluchi Solution', 'semar@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<p>aaaaaaaaaa</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:39'),
(25, 'whatsapp', 2, '6285726715114', 'Oluchi Solution', '6285726715114', 'Alif', 'Lorem ipsum dolor sit amet,', '<p>aaaaaaaaaa</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:40'),
(26, 'email', 2, 'semar@gmail.com', 'Oluchi Solution', 'alif@gmail.com', 'Alif', 'Lorem ipsum dolor sit amet,', '<p>aaaaaaaaaa</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:40'),
(27, 'whatsapp', 1, '6285726715114', 'Oluchi Solution', '6285726715114', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<p>Hai123</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:41'),
(28, 'email', 1, 'semar@gmail.com', 'Oluchi Solution', 'semar@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<p>Hai123</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:41'),
(29, 'whatsapp', 2, '6285726715114', 'Oluchi Solution', '6285726715114', 'Alif', 'Lorem ipsum dolor sit amet,', '<p>Hai123</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:42'),
(30, 'email', 2, 'semar@gmail.com', 'Oluchi Solution', 'alif@gmail.com', 'Alif', 'Lorem ipsum dolor sit amet,', '<p>Hai123</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:43'),
(31, 'whatsapp', 1, '6285726715114', 'Oluchi Solution', '6285726715114', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<p>wwwwwwwwwwww</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:43'),
(32, 'email', 1, 'semar@gmail.com', 'Oluchi Solution', 'semar@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<p>wwwwwwwwwwww</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:44'),
(33, 'whatsapp', 2, '6285726715114', 'Oluchi Solution', '6285726715114', 'Alif', 'Lorem ipsum dolor sit amet,', '<p>wwwwwwwwwwww</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:45'),
(34, 'email', 2, 'semar@gmail.com', 'Oluchi Solution', 'alif@gmail.com', 'Alif', 'Lorem ipsum dolor sit amet,', '<p>wwwwwwwwwwww</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:45'),
(35, 'whatsapp', 1, '6285726715114', 'Oluchi Solution', '6285726715114', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<p>sdsdsd</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:46'),
(36, 'email', 1, 'semar@gmail.com', 'Oluchi Solution', 'semar@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<p>sdsdsd</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:47'),
(37, 'whatsapp', 2, '6285726715114', 'Oluchi Solution', '6285726715114', 'Alif', 'Lorem ipsum dolor sit amet,', '<p>sdsdsd</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:47'),
(38, 'email', 2, 'semar@gmail.com', 'Oluchi Solution', 'alif@gmail.com', 'Alif', 'Lorem ipsum dolor sit amet,', '<p>sdsdsd</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:50'),
(39, 'whatsapp', 2, '6285726715114', 'Alif', '6285726715114', 'Alif', 'Hallo World 1', 'Hallo World 1 Cabang : Klaten  \r\n\r\n						 Hallo\r\n						 Oleh Alif', '0000-00-00 00:00:00', '2023-02-06 09:58:04'),
(40, 'email', 2, 'alif@gmail.com', 'Alif', 'alif@gmail.com', 'Alif', 'Hallo World 1', 'Hallo World 1 Cabang : Klaten  \r\n\r\n						 Hallo\r\n						 Oleh Alif', '0000-00-00 00:00:00', '2023-02-06 09:58:04'),
(41, 'whatsapp', 1, '6285726715114', 'Oluchi Solution', '6285726715114', 'Oluchi Solution', 'Hello World', 'Hello World Cabang : Klaten  \r\n\r\n						 Hai\r\n						 Oleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-06 10:00:14'),
(42, 'email', 1, 'semar@gmail.com', 'Oluchi Solution', 'semar@gmail.com', 'Oluchi Solution', 'Hello World', 'Hello World Cabang : Klaten  \r\n\r\n						 Hai\r\n						 Oleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-06 10:00:14'),
(43, 'whatsapp', 2, '6285726715114', 'Oluchi Solution', '6285726715114', 'Alif', 'Hello World', 'Hello World Cabang : Klaten  \n\n						 Hai\n						 Oleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-06 10:00:14'),
(44, 'email', 2, 'semar@gmail.com', 'Oluchi Solution', 'alif@gmail.com', 'Alif', 'Hello World', 'Hello World Cabang : Klaten  \r\n\r\n						 Hai\r\n						 Oleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-06 10:00:14'),
(45, 'whatsapp', 1, '0181881881', 'Oluchi Solution', '0181881881', 'Oluchi Solution', 'Herbal', 'Herbal Cabang : Solo  \r\n\r\n						 Tes\r\n						 Oleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-06 10:05:04'),
(46, 'email', 1, 'semar@gmail.com', 'Oluchi Solution', 'semar@gmail.com', 'Oluchi Solution', 'Herbal', 'Herbal Cabang : Solo  \r\n\r\n						 Tes\r\n						 Oleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-06 10:05:04'),
(47, 'whatsapp', 1, '6285726715114', 'Oluchi Solution', '6285726715114', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit Cabang : Klaten  \r\n\r\n						 aaa\r\n						 Oleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-06 10:08:51'),
(48, 'email', 1, 'semar@gmail.com', 'Oluchi Solution', 'semar@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit Cabang : Klaten  \r\n\r\n						 aaa\r\n						 Oleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-06 10:08:51'),
(49, 'whatsapp', 2, '6285726715114', 'Oluchi Solution', '6285726715114', 'Alif', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit Cabang : Klaten  \r\n\r\n						 aaa\r\n						 Oleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-06 10:08:51'),
(50, 'email', 2, 'semar@gmail.com', 'Oluchi Solution', 'alif@gmail.com', 'Alif', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit Cabang : Klaten  \r\n\r\n						 aaa\r\n						 Oleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-06 10:08:51'),
(51, 'whatsapp', 1, '085726715114', 'Oluchi Solution', '085726715114', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, Cabang : Klaten  \r\n\r\n						 tes\r\n						 Oleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-06 10:09:28'),
(52, 'email', 1, 'semar@gmail.com', 'Oluchi Solution', 'semar@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, Cabang : Klaten  \r\n\r\n						 tes\r\n						 Oleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-06 10:09:28'),
(53, 'whatsapp', 2, '085726715114', 'Oluchi Solution', '085726715114', 'Alif', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, Cabang : Klaten  \n\n						 tes\n						 Oleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-06 10:09:28'),
(54, 'email', 2, 'semar@gmail.com', 'Oluchi Solution', 'alif@gmail.com', 'Alif', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, Cabang : Klaten  \r\n\r\n						 tes\r\n						 Oleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-06 10:09:28'),
(55, 'whatsapp', 2, '088232340119', 'Alif', '088232340119', 'Alif', 'Lorem ipsum dolor sit amet,ll', 'Lorem ipsum dolor sit amet,ll Cabang : Klaten  \r\n\r\n						 kkk\r\n						 Oleh Alif', '0000-00-00 00:00:00', '2023-02-06 10:11:41'),
(56, 'email', 2, 'alif@gmail.com', 'Alif', 'alif@gmail.com', 'Alif', 'Lorem ipsum dolor sit amet,ll', 'Lorem ipsum dolor sit amet,ll Cabang : Klaten  \r\n\r\n						 kkk\r\n						 Oleh Alif', '0000-00-00 00:00:00', '2023-02-06 10:11:41'),
(57, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit Cabang : Klaten  \r\n\r\n						 aaa\r\n						 Oleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-06 10:16:49'),
(58, 'email', 1, 'semar@gmail.com', 'Oluchi Solution', 'semar@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit Cabang : Klaten  \r\n\r\n						 aaa\r\n						 Oleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-06 10:16:49'),
(59, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '088232340119', 'Alif', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit Cabang : Klaten  \r\n\r\n						 aaa\r\n						 Oleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-06 10:16:49'),
(60, 'email', 2, 'semar@gmail.com', 'Oluchi Solution', 'alif@gmail.com', 'Alif', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit Cabang : Klaten  \r\n\r\n						 aaa\r\n						 Oleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-06 10:16:49'),
(61, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, 22', 'Lorem ipsum dolor sit amet, 22 \r\n\r\n						Cabang : Klaten  \r\n\r\nHai\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-06 10:17:50'),
(62, 'email', 1, 'semar@gmail.com', 'Oluchi Solution', 'semar@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, 22', 'Lorem ipsum dolor sit amet, 22 \r\n\r\n						Cabang : Klaten  \r\n\r\nHai\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-06 10:17:50'),
(63, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '088232340119', 'Alif', 'Lorem ipsum dolor sit amet, 22', 'Lorem ipsum dolor sit amet, 22 \r\n\r\n						Cabang : Klaten  \r\n\r\nHai\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-06 10:17:51'),
(64, 'email', 2, 'semar@gmail.com', 'Oluchi Solution', 'alif@gmail.com', 'Alif', 'Lorem ipsum dolor sit amet, 22', 'Lorem ipsum dolor sit amet, 22 \r\n\r\n						Cabang : Klaten  \r\n\r\nHai\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-06 10:17:51'),
(65, 'whatsapp', 2, '088232340119', 'Alif', '088232340119', 'Alif', 'Lorem ipsum Lorem ipsum Lorem ipsum', 'Lorem ipsum Lorem ipsum Lorem ipsum \r\n\r\nCabang : Klaten  \r\n\r\nHoree\r\nOleh Alif', '0000-00-00 00:00:00', '2023-02-06 10:36:30'),
(66, 'email', 2, 'alif@gmail.com', 'Alif', 'alif@gmail.com', 'Alif', 'Lorem ipsum Lorem ipsum Lorem ipsum', 'Lorem ipsum Lorem ipsum Lorem ipsum \r\n\r\nCabang : Klaten  \r\n\r\nHoree\r\nOleh Alif', '0000-00-00 00:00:00', '2023-02-06 10:36:30'),
(67, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Hai', 'Hai \r\n\r\nCabang : Klaten  \r\n\r\nTessss\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-07 03:56:45'),
(68, 'email', 2, 'semar@gmail.com', 'Oluchi Solution', 'alif@gmail.com', 'Alif', 'Hai', 'Hai \r\n\r\nCabang : Klaten  \r\n\r\nTessss\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-07 03:56:45'),
(69, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Hai', 'Hai \r\n\r\nCabang : Klaten  \r\n\r\nTessss\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-07 03:56:46'),
(70, 'email', 1, 'semar@gmail.com', 'Oluchi Solution', 'semar@gmail.com', 'Oluchi Solution', 'Hai', 'Hai \r\n\r\nCabang : Klaten  \r\n\r\nTessss\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-07 03:56:46'),
(71, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Lorem ipsum dolo', 'Lorem ipsum dolo \r\n\r\nCabang : Klaten  \r\n\r\nHallo\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-07 04:28:45'),
(72, 'email', 2, 'semar@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolo', 'Lorem ipsum dolo \r\n\r\nCabang : Klaten  \r\n\r\nHallo\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-07 04:28:47'),
(73, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolo', 'Lorem ipsum dolo \r\n\r\nCabang : Klaten  \r\n\r\nHallo\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-07 04:28:48'),
(74, 'email', 1, 'semar@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolo', 'Lorem ipsum dolo \r\n\r\nCabang : Klaten  \r\n\r\nHallo\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-07 04:28:48'),
(75, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\nCabang : Klaten  \r\n\r\nTes\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-07 04:33:51'),
(76, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\nCabang : Klaten  \r\n\r\nTes\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-07 04:33:53'),
(77, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\nCabang : Klaten  \r\n\r\nTes\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-07 04:33:53'),
(78, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\nCabang : Klaten  \r\n\r\nTes\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-07 04:33:54'),
(79, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<p>Hallo s</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:51'),
(80, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<p>Hallo s</p>', '0000-00-00 00:00:00', '2023-03-06 02:24:52'),
(81, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Lorem ipsum dolor sit amet,', '<p>Hallo s</p>', '0000-00-00 00:00:00', '2023-03-06 02:33:02'),
(82, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet,', '<p>Hallo s</p>', '0000-00-00 00:00:00', '2023-03-06 02:33:03'),
(83, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet, \r\n\r\nCabang : Klaten  \r\n\r\nTes\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-07 10:05:16'),
(84, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet, \r\n\r\nCabang : Klaten  \r\n\r\nTes\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-07 10:05:17'),
(85, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet, \r\n\r\nCabang : Klaten  \r\n\r\nTes\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-07 10:05:18'),
(86, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet, \r\n\r\nCabang : Klaten  \r\n\r\nTes\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-07 10:05:19'),
(87, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Lorem ipsum dolor sit amet, Lorem ', 'Lorem ipsum dolor sit amet, Lorem  \r\n\r\n	Cabang : Klaten  \r\n\r\n	Lorem ipsum dolor sit \r\n	Oleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-07 10:09:23'),
(88, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet, Lorem ', '<h5>Lorem ipsum dolor sit amet, Lorem </h5><br> \r\n\r\n	Cabang : Klaten  \r\n	<br>\r\n	<br>\r\n	<p>Lorem ipsum dolor sit </p>\r\n	<br>\r\n	<p>Oleh Oluchi Solution</p>', '0000-00-00 00:00:00', '2023-02-07 10:09:24'),
(89, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, Lorem ', 'Lorem ipsum dolor sit amet, Lorem  \r\n\r\n	Cabang : Klaten  \r\n\r\n	Lorem ipsum dolor sit \r\n	Oleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-07 10:09:24'),
(90, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, Lorem ', '<h5>Lorem ipsum dolor sit amet, Lorem </h5><br> \r\n\r\n	Cabang : Klaten  \r\n	<br>\r\n	<br>\r\n	<p>Lorem ipsum dolor sit </p>\r\n	<br>\r\n	<p>Oleh Oluchi Solution</p>', '0000-00-00 00:00:00', '2023-02-07 10:09:25'),
(91, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\nCabang : Klaten  \r\n\r\nadipisicing elit\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-07 10:13:07'),
(92, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>adipisicing elit</p>\r\n	<p>Oleh Oluchi Solution</p>', '0000-00-00 00:00:00', '2023-02-07 10:13:08'),
(93, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\nCabang : Klaten  \r\n\r\nadipisicing elit\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-02-07 10:13:09'),
(94, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>adipisicing elit</p>\r\n	<p>Oleh Oluchi Solution</p>', '0000-00-00 00:00:00', '2023-02-07 10:13:09'),
(95, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\nCabang : Klaten  \r\n\r\n<p>Haiii</p>\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-03-06 02:33:04'),
(96, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Haiii</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '0000-00-00 00:00:00', '2023-03-06 02:33:04'),
(97, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\nCabang : Klaten  \r\n\r\n<p>Haiii</p>\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-03-06 02:33:05'),
(98, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Haiii</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '0000-00-00 00:00:00', '2023-03-06 02:33:06'),
(99, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\nCabang : Klaten  \r\n\r\nHallo\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-03-06 02:33:07'),
(100, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Hallo</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '0000-00-00 00:00:00', '2023-03-06 02:33:07'),
(101, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\nCabang : Klaten  \r\n\r\nHallo\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-03-06 02:33:08'),
(102, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Hallo</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '0000-00-00 00:00:00', '2023-03-06 02:33:16'),
(103, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\nCabang : Klaten  \r\n\r\nTesting\r\n\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-03-06 02:33:17'),
(104, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Testing</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '0000-00-00 00:00:00', '2023-03-06 02:33:25'),
(105, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\nCabang : Klaten  \r\n\r\nTesting\r\n\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-03-06 02:33:26'),
(106, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Testing</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '0000-00-00 00:00:00', '2023-03-06 02:33:35'),
(107, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\nCabang : Klaten  \r\n\r\nasasas\r\n\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-03-06 02:33:35'),
(108, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>asasas</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '0000-00-00 00:00:00', '2023-03-06 02:33:44'),
(109, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\nCabang : Klaten  \r\n\r\nasasas\r\n\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-03-06 02:33:45'),
(110, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>asasas</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '0000-00-00 00:00:00', '2023-03-06 02:33:54'),
(111, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\nCabang : Klaten  \r\n\r\nasasa\r\n\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-03-06 02:33:55'),
(112, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>asasa</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '0000-00-00 00:00:00', '2023-03-06 02:34:05'),
(113, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\nCabang : Klaten  \r\n\r\nasasa\r\n\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-03-06 02:34:05'),
(114, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>asasa</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '0000-00-00 00:00:00', '2023-03-06 02:34:15'),
(115, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\nCabang : Klaten  \r\n\r\nHallo World\r\n\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-03-06 02:34:16'),
(116, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Hallo World</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '0000-00-00 00:00:00', '2023-03-06 02:34:26'),
(117, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\nCabang : Klaten  \r\n\r\nHallo World\r\n\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-03-06 02:34:27'),
(118, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Hallo World</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '0000-00-00 00:00:00', '2023-03-06 02:34:37'),
(119, 'whatsapp', 1, '', 'Alif', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\nCabang : Klaten  \r\n\r\nTesss\r\n\r\nOleh Alif', '0000-00-00 00:00:00', '2023-03-06 02:34:38'),
(120, 'email', 1, 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Tesss</p></p>\r\n	<p>Oleh Alif</p>', '0000-00-00 00:00:00', '2023-03-06 02:34:48'),
(121, 'whatsapp', 2, '', 'Alif', '', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\nCabang : Klaten  \r\n\r\nTesss\r\n\r\nOleh Alif', '0000-00-00 00:00:00', '2023-03-06 02:34:49'),
(122, 'email', 2, 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Tesss</p></p>\r\n	<p>Oleh Alif</p>', '0000-00-00 00:00:00', '2023-03-06 02:35:00'),
(123, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\nCabang : Klaten  \r\n\r\nasasa\r\n\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-03-06 02:35:01'),
(124, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\nCabang : Klaten  \r\n<br>\r\n<p><p>asasa</p></p>\r\n<p>Oleh Oluchi Solution</p>', '0000-00-00 00:00:00', '2023-03-06 02:35:12'),
(125, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\nCabang : Klaten  \r\n\r\nasasa\r\n\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-03-06 02:35:13'),
(126, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\nCabang : Klaten  \r\n<br>\r\n<p><p>asasa</p></p>\r\n<p>Oleh Oluchi Solution</p>', '0000-00-00 00:00:00', '2023-03-06 02:35:25'),
(127, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\nCabang : Klaten  \r\n\r\nsdsdsd\r\n\r\nOleh Oluchi Solution', '0000-00-00 00:00:00', '2023-03-06 02:35:26'),
(128, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<h3>Lorem ipsum dolor sit amet,</h3>\r\nCabang : Klaten  \r\n<br>\r\n<p><p>sdsdsd</p></p>\r\n<p>Oleh Oluchi Solution</p>', '0000-00-00 00:00:00', '2023-03-06 02:35:38'),
(129, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\nCabang : Klaten  \r\n\r\nasasa\r\n\r\nOleh Oluchi Solution', '2023-02-08 03:48:00', '2023-03-06 02:35:39'),
(130, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\nCabang : Klaten  \r\n<br>\r\n<p><p>asasa</p></p>\r\n<p>Oleh Oluchi Solution</p>', '2023-02-08 03:48:01', '2023-03-06 02:35:52'),
(131, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\nCabang : Klaten  \r\n\r\nasasa\r\n\r\nOleh Oluchi Solution', '2023-02-08 03:48:02', '2023-03-06 02:35:53'),
(132, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\nCabang : Klaten  \r\n<br>\r\n<p><p>asasa</p></p>\r\n<p>Oleh Oluchi Solution</p>', '2023-02-08 03:48:02', '2023-03-06 02:36:06'),
(133, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\nCabang : Klaten  \r\n\r\nsdsdsd\r\n\r\nOleh Oluchi Solution', '2023-02-08 03:48:02', '2023-03-06 02:37:47'),
(134, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<h3>Lorem ipsum dolor sit amet,</h3>\r\nCabang : Klaten  \r\n<br>\r\n<p><p>sdsdsd</p></p>\r\n<p>Oleh Oluchi Solution</p>', '2023-02-08 03:48:02', '2023-03-06 02:37:48'),
(135, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\n	Cabang : Klaten  \r\n\r\n	asasa\r\n\r\n	Oleh Oluchi Solution', '2023-02-08 04:07:54', '2023-03-06 02:37:48'),
(136, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>asasa</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-02-08 04:07:55', '2023-03-06 02:37:48'),
(137, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\n	Cabang : Klaten  \r\n\r\n	asasa\r\n\r\n	Oleh Oluchi Solution', '2023-02-08 04:07:56', '2023-03-06 02:37:49'),
(138, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>asasa</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-02-08 04:07:56', '2023-03-06 02:37:50'),
(139, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\n	Cabang : Klaten  \r\n\r\n	asasa\r\n\r\n	Oleh Oluchi Solution', '2023-02-08 04:14:09', '2023-03-06 02:37:51'),
(140, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>asasa</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-02-08 04:14:10', '2023-03-06 02:37:51'),
(141, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\n	Cabang : Klaten  \r\n\r\n	asasa\r\n\r\n	Oleh Oluchi Solution', '2023-02-08 04:14:11', '2023-03-06 02:37:52'),
(142, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>asasa</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-02-08 04:14:11', '2023-03-06 02:37:53'),
(143, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\n	Cabang : Klaten  \r\n\r\n	asasa\r\n\r\n	Oleh Oluchi Solution', '2023-02-08 04:19:12', '2023-03-06 02:37:53'),
(144, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>asasa</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-02-08 04:19:13', '2023-03-06 02:37:54'),
(145, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', 'Lorem ipsum dolor sit amet, consectetur  \r\n\r\n	Cabang : Klaten  \r\n\r\n	asasa\r\n\r\n	Oleh Oluchi Solution', '2023-02-08 04:19:14', '2023-03-06 02:37:55'),
(146, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur ', '<h3>Lorem ipsum dolor sit amet, consectetur </h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>asasa</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-02-08 04:19:15', '2023-03-06 02:37:55'),
(147, 'whatsapp', 2, '', 'Alif', '', 'Alif', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\nCabang : Klaten  \r\n\r\nHai\r\nOleh Alif', '2023-02-08 04:31:50', '2023-02-08 04:31:50'),
(148, 'email', 2, 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet,', '<h3>Lorem ipsum dolor sit amet,</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>Hai</p>\r\n	<p>Oleh Alif</p>', '2023-02-08 04:31:51', '2023-02-08 04:31:51'),
(149, 'whatsapp', 1, '', 'Alif', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\nCabang : Klaten  \r\n\r\nHallo\r\n\r\nOleh Alif', '2023-02-08 04:32:54', '2023-02-08 04:32:54'),
(150, 'email', 1, 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<h3>Lorem ipsum dolor sit amet,</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Hallo</p></p>\r\n	<p>Oleh Alif</p>', '2023-02-08 04:32:54', '2023-02-08 04:32:54'),
(151, 'whatsapp', 2, '', 'Alif', '', 'Alif', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\nCabang : Klaten  \r\n\r\nHallo\r\n\r\nOleh Alif', '2023-02-08 04:32:55', '2023-02-08 04:32:55'),
(152, 'email', 2, 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet,', '<h3>Lorem ipsum dolor sit amet,</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Hallo</p></p>\r\n	<p>Oleh Alif</p>', '2023-02-08 04:32:56', '2023-02-08 04:32:56'),
(153, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\nCabang : Klaten  \r\n\r\nTesss\r\n\r\nOleh Oluchi Solution', '2023-02-08 04:33:32', '2023-02-08 04:33:32'),
(154, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<h3>Lorem ipsum dolor sit amet,</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Tesss</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-02-08 04:33:33', '2023-02-08 04:33:33'),
(155, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\nCabang : Klaten  \r\n\r\nTesss\r\n\r\nOleh Oluchi Solution', '2023-02-08 04:33:33', '2023-02-08 04:33:33'),
(156, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet,', '<h3>Lorem ipsum dolor sit amet,</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Tesss</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-02-08 04:33:34', '2023-02-08 04:33:34'),
(157, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\n	Cabang : Klaten  \r\n\r\n	Tesss\r\n\r\n	Oleh Oluchi Solution', '2023-02-08 04:35:49', '2023-02-08 04:35:49'),
(158, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<h3>Lorem ipsum dolor sit amet,</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Tesss</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-02-08 04:35:50', '2023-02-08 04:35:50'),
(159, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit \r\n\r\nCabang : Klaten  \r\n\r\nasasa\r\n\r\nOleh Oluchi Solution', '2023-02-10 09:19:29', '2023-02-10 09:19:29'),
(160, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit', '<h3>Lorem ipsum dolor sit amet, consectetur adipisicing elit</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>asasa</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-02-10 09:19:30', '2023-02-10 09:19:30'),
(161, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit \r\n\r\nCabang : Klaten  \r\n\r\nasasa\r\n\r\nOleh Oluchi Solution', '2023-02-10 09:19:31', '2023-02-10 09:19:31'),
(162, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit', '<h3>Lorem ipsum dolor sit amet, consectetur adipisicing elit</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>asasa</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-02-10 09:19:31', '2023-02-10 09:19:31'),
(163, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit \r\n\r\nCabang : Klaten  \r\n\r\nHallo World\r\n\r\nOleh Oluchi Solution', '2023-02-10 09:20:09', '2023-02-10 09:20:09'),
(164, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit', '<h3>Lorem ipsum dolor sit amet, consectetur adipisicing elit</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Hallo World</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-02-10 09:20:10', '2023-02-10 09:20:10'),
(165, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit \r\n\r\nCabang : Klaten  \r\n\r\nHallo World\r\n\r\nOleh Oluchi Solution', '2023-02-10 09:20:10', '2023-02-10 09:20:10'),
(166, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit', '<h3>Lorem ipsum dolor sit amet, consectetur adipisicing elit</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Hallo World</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-02-10 09:20:11', '2023-02-10 09:20:11'),
(167, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\nCabang : Klaten  \r\n\r\nHallo World\r\n\r\nOleh Oluchi Solution', '2023-02-10 09:48:57', '2023-02-10 09:48:57'),
(168, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet,', '<h3>Lorem ipsum dolor sit amet,</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Hallo World</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-02-10 09:48:58', '2023-02-10 09:48:58'),
(169, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\nCabang : Klaten  \r\n\r\nHallo World\r\n\r\nOleh Oluchi Solution', '2023-02-10 09:48:58', '2023-02-10 09:48:58'),
(170, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<h3>Lorem ipsum dolor sit amet,</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Hallo World</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-02-10 09:48:59', '2023-02-10 09:48:59'),
(171, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Herbal', 'Herbal \r\n\r\nCabang : Solo  \r\n\r\nasasasa\r\n\r\nOleh Oluchi Solution', '2023-02-10 10:46:20', '2023-02-10 10:46:20'),
(172, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Herbal', '<h3>Herbal</h3>\r\n	Cabang : Solo  \r\n	<br>\r\n	<p><p>asasasa</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-02-10 10:46:21', '2023-02-10 10:46:21'),
(173, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\nCabang : Klaten  \r\n\r\nTes\r\nOleh Oluchi Solution', '2023-03-02 02:41:00', '2023-03-02 02:41:00'),
(174, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet,', '<h3>Lorem ipsum dolor sit amet,</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>Tes</p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-02 02:41:01', '2023-03-02 02:41:01'),
(175, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\nCabang : Klaten  \r\n\r\nTes\r\nOleh Oluchi Solution', '2023-03-02 02:41:03', '2023-03-02 02:41:03'),
(176, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<h3>Lorem ipsum dolor sit amet,</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>Tes</p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-02 02:41:03', '2023-03-02 02:41:03'),
(177, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\nCabang : Klaten  \r\n\r\nHallo\r\n\r\nOleh Oluchi Solution', '2023-03-02 02:41:22', '2023-03-02 02:41:22'),
(178, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<h3>Lorem ipsum dolor sit amet,</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Hallo</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-02 02:41:22', '2023-03-02 02:41:22'),
(179, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\nCabang : Klaten  \r\n\r\nHallo\r\n\r\nOleh Oluchi Solution', '2023-03-02 02:41:23', '2023-03-02 02:41:23'),
(180, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet,', '<h3>Lorem ipsum dolor sit amet,</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Hallo</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-02 02:41:24', '2023-03-02 02:41:24'),
(181, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'qssdd', 'qssdd \r\n\r\nCabang : Klaten  \r\n\r\nddd\r\nOleh Oluchi Solution', '2023-03-06 02:30:06', '2023-03-06 02:30:06'),
(182, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'qssdd', '<h3>qssdd</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>ddd</p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-06 02:30:06', '2023-03-06 02:30:06'),
(183, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'qssdd', 'qssdd \r\n\r\nCabang : Klaten  \r\n\r\nddd\r\nOleh Oluchi Solution', '2023-03-06 02:30:06', '2023-03-06 02:30:06'),
(184, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'qssdd', '<h3>qssdd</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>ddd</p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-06 02:30:06', '2023-03-06 02:30:06'),
(185, 'whatsapp', 2, '088232340119', 'Oluchi Solution', '', 'Alif', 'Haloo', 'Haloo \n\nCabang : Klaten  \n\nHai\nOleh Oluchi Solution', '2023-03-06 02:31:05', '2023-03-06 02:37:56'),
(186, 'email', 2, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Haloo', '<h3>Haloo</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>Hai</p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-06 02:31:05', '2023-03-06 02:37:56'),
(187, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Haloo', 'Haloo \n\nCabang : Klaten  \n\nHai\nOleh Oluchi Solution', '2023-03-06 02:31:05', '2023-03-06 02:37:57'),
(188, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Haloo', '<h3>Haloo</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>Hai</p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-06 02:31:05', '2023-03-06 02:37:58'),
(189, 'whatsapp', 2, '0817717818', 'Muh Alif', '', 'Alif', 'Alif', 'Alif \r\n\r\nCabang : Klaten  \r\n\r\ntes\r\nOleh Muh Alif', '2023-03-06 03:59:23', NULL);
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
(190, 'email', 2, 'admin@gmail.com', 'Muh Alif', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Alif', '<h3>Alif</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>tes</p>\r\n	<p>Oleh Muh Alif</p>', '2023-03-06 03:59:23', NULL),
(191, 'whatsapp', 4, '0817717818', 'Muh Alif', '0817717818', 'Muh Alif', 'Alif', 'Alif \r\n\r\nCabang : Klaten  \r\n\r\ntes\r\nOleh Muh Alif', '2023-03-06 03:59:23', NULL),
(192, 'email', 4, 'admin@gmail.com', 'Muh Alif', 'admin@gmail.com', 'Muh Alif', 'Alif', '<h3>Alif</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>tes</p>\r\n	<p>Oleh Muh Alif</p>', '2023-03-06 03:59:23', NULL),
(193, 'whatsapp', 1, '0817717818', 'Muh Alif', '088232340119', 'Oluchi Solution', 'Alif', 'Alif \r\n\r\nCabang : Klaten  \r\n\r\ntes\r\nOleh Muh Alif', '2023-03-06 03:59:23', NULL),
(194, 'email', 1, 'admin@gmail.com', 'Muh Alif', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Alif', '<h3>Alif</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>tes</p>\r\n	<p>Oleh Muh Alif</p>', '2023-03-06 03:59:23', NULL),
(195, 'whatsapp', 1, '0817717818', 'Muh Alif', '088232340119', 'Oluchi Solution', 'Alif', 'Alif \r\n\r\nCabang : Klaten  \r\n\r\nTes qq\r\n\r\nOleh Muh Alif', '2023-03-06 04:00:30', NULL),
(196, 'email', 1, 'admin@gmail.com', 'Muh Alif', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Alif', '<h3>Alif</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Tes qq</p></p>\r\n	<p>Oleh Muh Alif</p>', '2023-03-06 04:00:30', NULL),
(197, 'whatsapp', 4, '0817717818', 'Muh Alif', '0817717818', 'Muh Alif', 'Alif', 'Alif \r\n\r\nCabang : Klaten  \r\n\r\nTes qq\r\n\r\nOleh Muh Alif', '2023-03-06 04:00:30', NULL),
(198, 'email', 4, 'admin@gmail.com', 'Muh Alif', 'admin@gmail.com', 'Muh Alif', 'Alif', '<h3>Alif</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Tes qq</p></p>\r\n	<p>Oleh Muh Alif</p>', '2023-03-06 04:00:30', NULL),
(199, 'whatsapp', 2, '0817717818', 'Muh Alif', '', 'Alif', 'Alif', 'Alif \r\n\r\nCabang : Klaten  \r\n\r\nTes qq\r\n\r\nOleh Muh Alif', '2023-03-06 04:00:30', NULL),
(200, 'email', 2, 'admin@gmail.com', 'Muh Alif', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Alif', '<h3>Alif</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Tes qq</p></p>\r\n	<p>Oleh Muh Alif</p>', '2023-03-06 04:00:30', NULL),
(201, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Alif', 'Alif \r\n\r\n	Cabang : Klaten  \r\n\r\n	Tes qq\r\n\r\n	Oleh Oluchi Solution', '2023-03-06 04:23:51', '2023-03-06 04:23:51'),
(202, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Alif', '<h3>Alif</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Tes qq</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-06 04:23:52', '2023-03-06 04:23:52'),
(203, 'whatsapp', 2, '', 'Alif', '', 'Alif', 'Alif', 'Alif \r\n\r\n	Cabang : Klaten  \r\n\r\n	Tes qq\r\n\r\n	Oleh Alif', '2023-03-06 04:23:52', '2023-03-06 04:23:52'),
(204, 'email', 2, 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Alif', '<h3>Alif</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Tes qq</p></p>\r\n	<p>Oleh Alif</p>', '2023-03-06 04:23:53', '2023-03-06 04:23:53'),
(205, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Haloo', 'Haloo \r\n\r\n	Cabang : Klaten  \r\n\r\n	Hai\r\n\r\n	Oleh Oluchi Solution', '2023-03-06 04:23:54', '2023-03-06 04:23:54'),
(206, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Haloo', '<h3>Haloo</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>Hai</p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-06 04:23:54', '2023-03-06 04:23:54'),
(207, 'whatsapp', 2, '', 'Alif', '', 'Alif', 'Haloo', 'Haloo \r\n\r\n	Cabang : Klaten  \r\n\r\n	Hai\r\n\r\n	Oleh Alif', '2023-03-06 04:23:54', '2023-03-06 04:23:54'),
(208, 'email', 2, 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Haloo', '<h3>Haloo</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>Hai</p>\r\n	<p>Oleh Alif</p>', '2023-03-06 04:23:55', '2023-03-06 04:23:55'),
(209, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'qssdd', 'qssdd \r\n\r\n	Cabang : Klaten  \r\n\r\n	ddd\r\n\r\n	Oleh Oluchi Solution', '2023-03-06 04:23:56', '2023-03-06 04:23:56'),
(210, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'qssdd', '<h3>qssdd</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>ddd</p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-06 04:23:56', '2023-03-06 04:23:56'),
(211, 'whatsapp', 2, '', 'Alif', '', 'Alif', 'qssdd', 'qssdd \r\n\r\n	Cabang : Klaten  \r\n\r\n	ddd\r\n\r\n	Oleh Alif', '2023-03-06 04:23:57', '2023-03-06 04:23:57'),
(212, 'email', 2, 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'qssdd', '<h3>qssdd</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>ddd</p>\r\n	<p>Oleh Alif</p>', '2023-03-06 04:23:57', '2023-03-06 04:23:57'),
(213, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\n	Cabang : Klaten  \r\n\r\n	Tesss\r\n\r\n	Oleh Oluchi Solution', '2023-03-06 04:23:58', '2023-03-06 04:23:58'),
(214, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<h3>Lorem ipsum dolor sit amet,</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Tesss</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-06 04:23:59', '2023-03-06 04:23:59'),
(215, 'whatsapp', 2, '', 'Alif', '', 'Alif', 'Lorem ipsum Lorem ipsum Lorem ipsum', 'Lorem ipsum Lorem ipsum Lorem ipsum \r\n\r\n	Cabang : Klaten  \r\n\r\n	Horee\r\n\r\n	Oleh Alif', '2023-03-06 04:23:59', '2023-03-06 04:23:59'),
(216, 'email', 2, 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum Lorem ipsum Lorem ipsum', '<h3>Lorem ipsum Lorem ipsum Lorem ipsum</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>Horee</p>\r\n	<p>Oleh Alif</p>', '2023-03-06 04:24:00', '2023-03-06 04:24:00'),
(217, 'whatsapp', 2, '', 'Alif', '', 'Alif', 'Lorem ipsum dolor sit amet,ll', 'Lorem ipsum dolor sit amet,ll \r\n\r\n	Cabang : Klaten  \r\n\r\n	kkk\r\n\r\n	Oleh Alif', '2023-03-06 04:24:00', '2023-03-06 04:24:00'),
(218, 'email', 2, 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet,ll', '<h3>Lorem ipsum dolor sit amet,ll</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>kkk</p>\r\n	<p>Oleh Alif</p>', '2023-03-06 04:24:01', '2023-03-06 04:24:01'),
(219, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Herbal', 'Herbal \r\n\r\n	Cabang : Solo  \r\n\r\n	asasasa\r\n\r\n	Oleh Oluchi Solution', '2023-03-06 04:24:02', '2023-03-06 04:24:02'),
(220, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Herbal', '<h3>Herbal</h3>\r\n	Cabang : Solo  \r\n	<br>\r\n	<p><p>asasasa</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-06 04:24:02', '2023-03-06 04:24:02'),
(221, 'whatsapp', 2, '', 'Alif', '', 'Alif', 'Hello World', 'Hello World \r\n\r\n	Cabang : Klaten  \r\n\r\n	Hai\r\n\r\n	Oleh Alif', '2023-03-06 04:24:03', '2023-03-06 04:24:03'),
(222, 'email', 2, 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Hello World', '<h3>Hello World</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>Hai</p>\r\n	<p>Oleh Alif</p>', '2023-03-06 04:24:03', '2023-03-06 04:24:03'),
(223, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Hello World', 'Hello World \r\n\r\n	Cabang : Klaten  \r\n\r\n	Hai\r\n\r\n	Oleh Oluchi Solution', '2023-03-06 04:24:04', '2023-03-06 04:24:04'),
(224, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Hello World', '<h3>Hello World</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>Hai</p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-06 04:24:05', '2023-03-06 04:24:05'),
(225, 'whatsapp', 2, '', 'Alif', '', 'Alif', 'Hallo World 1', 'Hallo World 1 \r\n\r\n	Cabang : Klaten  \r\n\r\n	Hallo\r\n\r\n	Oleh Alif', '2023-03-06 04:24:05', '2023-03-06 04:24:05'),
(226, 'email', 2, 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Hallo World 1', '<h3>Hallo World 1</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>Hallo</p>\r\n	<p>Oleh Alif</p>', '2023-03-06 04:24:06', '2023-03-06 04:24:06'),
(227, 'whatsapp', 2, '', 'Alif', '', 'Alif', 'Lorem ipsum dolor sit a', 'Lorem ipsum dolor sit a \r\n\r\n	Cabang : Klaten  \r\n\r\n	Tes\r\n\r\n	Oleh Alif', '2023-03-06 04:24:06', '2023-03-06 04:24:06'),
(228, 'email', 2, 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit a', '<h3>Lorem ipsum dolor sit a</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>Tes</p>\r\n	<p>Oleh Alif</p>', '2023-03-06 04:24:07', '2023-03-06 04:24:07'),
(229, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit a', 'Lorem ipsum dolor sit a \r\n\r\n	Cabang : Klaten  \r\n\r\n	Tes\r\n\r\n	Oleh Oluchi Solution', '2023-03-06 04:24:07', '2023-03-06 04:24:07'),
(230, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit a', '<h3>Lorem ipsum dolor sit a</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>Tes</p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-06 04:24:08', '2023-03-06 04:24:08'),
(231, 'whatsapp', 2, '', 'Alif', '', 'Alif', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\n	Cabang : Klaten  \r\n\r\n	sdsdsd\r\n\r\n	Oleh Alif', '2023-03-06 04:24:08', '2023-03-06 04:24:08'),
(232, 'email', 2, 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet,', '<h3>Lorem ipsum dolor sit amet,</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>sdsdsd</p></p>\r\n	<p>Oleh Alif</p>', '2023-03-06 04:24:09', '2023-03-06 04:24:09'),
(233, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\n	Cabang : Klaten  \r\n\r\n	sdsdsd\r\n\r\n	Oleh Oluchi Solution', '2023-03-06 04:24:10', '2023-03-06 04:24:10'),
(234, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<h3>Lorem ipsum dolor sit amet,</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>sdsdsd</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-06 04:24:10', '2023-03-06 04:24:10'),
(235, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Alif', 'Alif \r\n\r\n	Cabang : Klaten  \r\n\r\n	Tes qq\r\n\r\n	Oleh Oluchi Solution', '2023-03-06 04:25:09', '2023-03-06 04:25:09'),
(236, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Alif', '<h3>Alif</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Tes qq</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-06 04:25:11', '2023-03-06 04:25:11'),
(237, 'whatsapp', 2, '', 'Alif', '', 'Alif', 'Alif', 'Alif \r\n\r\n	Cabang : Klaten  \r\n\r\n	Tes qq\r\n\r\n	Oleh Alif', '2023-03-06 04:25:11', '2023-03-06 04:25:11'),
(238, 'email', 2, 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Alif', '<h3>Alif</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Tes qq</p></p>\r\n	<p>Oleh Alif</p>', '2023-03-06 04:25:12', '2023-03-06 04:25:12'),
(239, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Haloo', 'Haloo \r\n\r\n	Cabang : Klaten  \r\n\r\n	Hai\r\n\r\n	Oleh Oluchi Solution', '2023-03-06 04:25:13', '2023-03-06 04:25:13'),
(240, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Haloo', '<h3>Haloo</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>Hai</p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-06 04:25:13', '2023-03-06 04:25:13'),
(241, 'whatsapp', 2, '', 'Alif', '', 'Alif', 'Haloo', 'Haloo \r\n\r\n	Cabang : Klaten  \r\n\r\n	Hai\r\n\r\n	Oleh Alif', '2023-03-06 04:25:14', '2023-03-06 04:25:14'),
(242, 'email', 2, 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Haloo', '<h3>Haloo</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>Hai</p>\r\n	<p>Oleh Alif</p>', '2023-03-06 04:25:14', '2023-03-06 04:25:14'),
(243, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'qssdd', 'qssdd \r\n\r\n	Cabang : Klaten  \r\n\r\n	ddd\r\n\r\n	Oleh Oluchi Solution', '2023-03-06 04:25:15', '2023-03-06 04:25:15'),
(244, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'qssdd', '<h3>qssdd</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>ddd</p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-06 04:25:16', '2023-03-06 04:25:16'),
(245, 'whatsapp', 2, '', 'Alif', '', 'Alif', 'qssdd', 'qssdd \r\n\r\n	Cabang : Klaten  \r\n\r\n	ddd\r\n\r\n	Oleh Alif', '2023-03-06 04:25:16', '2023-03-06 04:25:16'),
(246, 'email', 2, 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'qssdd', '<h3>qssdd</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>ddd</p>\r\n	<p>Oleh Alif</p>', '2023-03-06 04:25:17', '2023-03-06 04:25:17'),
(247, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\n	Cabang : Klaten  \r\n\r\n	Tesss\r\n\r\n	Oleh Oluchi Solution', '2023-03-06 04:25:18', '2023-03-06 04:25:18'),
(248, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<h3>Lorem ipsum dolor sit amet,</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>Tesss</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-06 04:25:18', '2023-03-06 04:25:18'),
(249, 'whatsapp', 2, '', 'Alif', '', 'Alif', 'Lorem ipsum Lorem ipsum Lorem ipsum', 'Lorem ipsum Lorem ipsum Lorem ipsum \r\n\r\n	Cabang : Klaten  \r\n\r\n	Horee\r\n\r\n	Oleh Alif', '2023-03-06 04:25:19', '2023-03-06 04:25:19'),
(250, 'email', 2, 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum Lorem ipsum Lorem ipsum', '<h3>Lorem ipsum Lorem ipsum Lorem ipsum</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>Horee</p>\r\n	<p>Oleh Alif</p>', '2023-03-06 04:25:20', '2023-03-06 04:25:20'),
(251, 'whatsapp', 2, '', 'Alif', '', 'Alif', 'Lorem ipsum dolor sit amet,ll', 'Lorem ipsum dolor sit amet,ll \r\n\r\n	Cabang : Klaten  \r\n\r\n	kkk\r\n\r\n	Oleh Alif', '2023-03-06 04:25:20', '2023-03-06 04:25:20'),
(252, 'email', 2, 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet,ll', '<h3>Lorem ipsum dolor sit amet,ll</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>kkk</p>\r\n	<p>Oleh Alif</p>', '2023-03-06 04:25:21', '2023-03-06 04:25:21'),
(253, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Herbal', 'Herbal \r\n\r\n	Cabang : Solo  \r\n\r\n	asasasa\r\n\r\n	Oleh Oluchi Solution', '2023-03-06 04:25:22', '2023-03-06 04:25:22'),
(254, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Herbal', '<h3>Herbal</h3>\r\n	Cabang : Solo  \r\n	<br>\r\n	<p><p>asasasa</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-06 04:25:22', '2023-03-06 04:25:22'),
(255, 'whatsapp', 2, '', 'Alif', '', 'Alif', 'Hello World', 'Hello World \r\n\r\n	Cabang : Klaten  \r\n\r\n	Hai\r\n\r\n	Oleh Alif', '2023-03-06 04:25:23', '2023-03-06 04:25:23'),
(256, 'email', 2, 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Hello World', '<h3>Hello World</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>Hai</p>\r\n	<p>Oleh Alif</p>', '2023-03-06 04:25:24', '2023-03-06 04:25:24'),
(257, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Hello World', 'Hello World \r\n\r\n	Cabang : Klaten  \r\n\r\n	Hai\r\n\r\n	Oleh Oluchi Solution', '2023-03-06 04:25:24', '2023-03-06 04:25:24'),
(258, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Hello World', '<h3>Hello World</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>Hai</p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-06 04:25:25', '2023-03-06 04:25:25'),
(259, 'whatsapp', 2, '', 'Alif', '', 'Alif', 'Hallo World 1', 'Hallo World 1 \r\n\r\n	Cabang : Klaten  \r\n\r\n	Hallo\r\n\r\n	Oleh Alif', '2023-03-06 04:25:25', '2023-03-06 04:25:25'),
(260, 'email', 2, 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Hallo World 1', '<h3>Hallo World 1</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>Hallo</p>\r\n	<p>Oleh Alif</p>', '2023-03-06 04:25:26', '2023-03-06 04:25:26'),
(261, 'whatsapp', 2, '', 'Alif', '', 'Alif', 'Lorem ipsum dolor sit a', 'Lorem ipsum dolor sit a \r\n\r\n	Cabang : Klaten  \r\n\r\n	Tes\r\n\r\n	Oleh Alif', '2023-03-06 04:25:27', '2023-03-06 04:25:27'),
(262, 'email', 2, 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit a', '<h3>Lorem ipsum dolor sit a</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>Tes</p>\r\n	<p>Oleh Alif</p>', '2023-03-06 04:25:27', '2023-03-06 04:25:27'),
(263, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit a', 'Lorem ipsum dolor sit a \r\n\r\n	Cabang : Klaten  \r\n\r\n	Tes\r\n\r\n	Oleh Oluchi Solution', '2023-03-06 04:25:30', '2023-03-06 04:25:30'),
(264, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit a', '<h3>Lorem ipsum dolor sit a</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p>Tes</p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-06 04:25:30', '2023-03-06 04:25:30'),
(265, 'whatsapp', 2, '', 'Alif', '', 'Alif', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\n	Cabang : Klaten  \r\n\r\n	sdsdsd\r\n\r\n	Oleh Alif', '2023-03-06 04:25:31', '2023-03-06 04:25:31'),
(266, 'email', 2, 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'aliffathoni@pelitanusantarakasih.sch.id', 'Alif', 'Lorem ipsum dolor sit amet,', '<h3>Lorem ipsum dolor sit amet,</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>sdsdsd</p></p>\r\n	<p>Oleh Alif</p>', '2023-03-06 04:25:32', '2023-03-06 04:25:32'),
(267, 'whatsapp', 1, '088232340119', 'Oluchi Solution', '088232340119', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', 'Lorem ipsum dolor sit amet, \r\n\r\n	Cabang : Klaten  \r\n\r\n	sdsdsd\r\n\r\n	Oleh Oluchi Solution', '2023-03-06 04:25:32', '2023-03-06 04:25:32'),
(268, 'email', 1, 'fmuhalif12@gmail.com', 'Oluchi Solution', 'fmuhalif12@gmail.com', 'Oluchi Solution', 'Lorem ipsum dolor sit amet,', '<h3>Lorem ipsum dolor sit amet,</h3>\r\n	Cabang : Klaten  \r\n	<br>\r\n	<p><p>sdsdsd</p></p>\r\n	<p>Oleh Oluchi Solution</p>', '2023-03-06 04:25:33', '2023-03-06 04:25:33');

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

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

--
-- 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=18;

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

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

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

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

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

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

--
-- 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=269;

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

