-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 10 Agu 2023 pada 13.59
-- Versi server: 10.6.14-MariaDB-cll-lve
-- Versi PHP: 8.1.16

START TRANSACTION;



--
-- Database: `seonwazi_pay4d`
--

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

--
-- Struktur dari tabel `accordions`
--

CREATE TABLE `accordions` (
  `id` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `alt_text` varchar(100) NOT NULL,
  `description` text DEFAULT NULL,
  `statuspromosi` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Struktur dari tabel `admin_activity`
--

CREATE TABLE `admin_activity` (
  `id` int(11) NOT NULL,
  `admin_username` varchar(50) NOT NULL,
  `activity_type` enum('Edit_Saldo','Hapus_Pengguna') NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `activity_time` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Struktur dari tabel `admin_activity_log`
--

CREATE TABLE `admin_activity_log` (
  `id` int(11) NOT NULL,
  `admin_username` varchar(255) NOT NULL,
  `activity_type` varchar(50) NOT NULL,
  `login_time` text DEFAULT NULL,
  `logout_time` text DEFAULT NULL,
  `device` varchar(255) DEFAULT NULL,
  `ip_address` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `admin_activity_log`
--

INSERT INTO `admin_activity_log` (`id`, `admin_username`, `activity_type`, `login_time`, `logout_time`, `device`, `ip_address`) VALUES
(228, 'dekils', 'login', '30 Jul 2023 18:51:41', NULL, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', '125.164.16.181'),
(229, 'endoo023', 'logout', NULL, '30 Jul 2023 18:52:00', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', '125.164.20.83'),
(230, 'dekils', 'login', '30 Jul 2023 18:52:10', NULL, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', '125.164.20.83'),
(231, 'dekils', 'login', '30 Jul 2023 18:56:32', NULL, 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Safari/537.36', '103.105.25.0'),
(232, 'dekils', 'login', '30 Jul 2023 19:02:47', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '103.105.25.0'),
(233, 'dekils', 'login', '30 Jul 2023 19:04:21', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Mobile Safari/537.36', '180.242.68.104'),
(234, 'dekils', 'login', '30 Jul 2023 19:04:57', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Mobile Safari/537.36', '180.242.68.104'),
(235, 'dekils', 'login', '30 Jul 2023 19:05:27', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Mobile Safari/537.36', '180.242.68.104'),
(236, 'dekils', 'login', '30 Jul 2023 19:05:42', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.40'),
(237, 'dekils', 'login', '30 Jul 2023 19:08:10', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.40'),
(238, 'dekils', 'login', '30 Jul 2023 19:09:04', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Mobile Safari/537.36', '180.242.68.104'),
(239, 'dekils', 'login', '30 Jul 2023 19:09:18', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.40'),
(240, 'dekils', 'login', '30 Jul 2023 19:09:35', NULL, 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Safari/537.36', '114.142.175.40'),
(241, 'dekils', 'logout', NULL, '30 Jul 2023 19:35:23', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Safari/537.36', '114.142.175.40'),
(242, 'Dekils', 'login', '30 Jul 2023 20:08:41', NULL, 'Mozilla/5.0 (Linux; Android 11; Infinix X6812B) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/97.0.4692.98 Mobile Safari/537.36', '182.0.169.104'),
(243, 'Dekils', 'login', '30 Jul 2023 20:22:20', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36', '180.252.255.187'),
(244, 'Dekils', 'login', '30 Jul 2023 20:26:03', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36', '180.252.255.187'),
(245, 'Dekils', 'login', '30 Jul 2023 20:26:33', NULL, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36', '103.18.232.97'),
(246, 'Dekils', 'login', '30 Jul 2023 20:29:39', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36', '180.252.255.187'),
(247, 'Dekils', 'login', '30 Jul 2023 20:32:40', NULL, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36', '103.18.232.97'),
(248, 'Dekils', 'login', '30 Jul 2023 20:55:52', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Mobile Safari/537.36', '103.18.232.97'),
(249, 'Yoyokganteng', 'logout', NULL, '30 Jul 2023 20:59:44', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Mobile Safari/537.36', '103.18.232.97'),
(250, 'Dekils', 'login', '30 Jul 2023 20:59:46', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Mobile Safari/537.36', '103.18.232.97'),
(251, 'Dekils', 'login', '30 Jul 2023 20:59:47', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Mobile Safari/537.36', '103.18.232.97'),
(252, 'Dekils', 'login', '30 Jul 2023 20:59:50', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Mobile Safari/537.36', '103.18.232.97'),
(253, 'Dekils', 'login', '30 Jul 2023 21:13:09', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36', '180.252.255.187'),
(254, 'Dekils', 'login', '30 Jul 2023 21:13:25', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Mobile Safari/537.36', '103.18.232.97'),
(255, 'Dekils', 'login', '30 Jul 2023 21:13:26', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Mobile Safari/537.36', '103.18.232.97'),
(256, 'Dekils', 'login', '30 Jul 2023 21:13:47', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36', '180.252.255.187'),
(257, 'Dekils', 'login', '30 Jul 2023 21:14:07', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Mobile Safari/537.36', '103.18.232.97'),
(258, 'Dekils', 'login', '30 Jul 2023 21:14:07', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Mobile Safari/537.36', '103.18.232.97'),
(259, 'Dekils', 'login', '30 Jul 2023 21:14:27', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36', '180.252.255.187'),
(260, 'Dekils', 'login', '30 Jul 2023 21:29:02', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36', '139.0.68.9'),
(261, 'Dekils', 'login', '30 Jul 2023 21:29:05', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36', '139.0.68.9'),
(262, 'Dekils', 'login', '30 Jul 2023 21:29:06', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36', '139.0.68.9'),
(263, 'Dekils', 'login', '30 Jul 2023 21:52:10', NULL, 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_1_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.1 Mobile/15E148 Safari/604.1', '180.254.73.68'),
(264, 'Prat1337x', 'logout', NULL, '30 Jul 2023 21:52:18', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36', '180.252.255.187'),
(265, 'Dekils', 'login', '30 Jul 2023 21:52:26', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36', '180.252.255.187'),
(266, 'Dekils', 'login', '30 Jul 2023 21:52:49', NULL, 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_1_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.1 Mobile/15E148 Safari/604.1', '180.254.73.68'),
(267, 'Dekils', 'login', '30 Jul 2023 21:53:23', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36', '180.252.255.187'),
(268, 'Dekils', 'login', '30 Jul 2023 21:55:49', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36', '180.252.255.187'),
(269, 'Sambo303', 'logout', NULL, '30 Jul 2023 22:13:19', 'Mozilla/5.0 (Linux; Android 12; vivo 1920; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/87.0.4280.141 Mobile Safari/537.36 VivoBrowser/10.5.0.0', '116.206.28.22'),
(270, 'Sambo303', 'logout', NULL, '30 Jul 2023 22:13:31', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36', '116.206.28.22'),
(271, 'Dekils', 'login', '30 Jul 2023 22:14:08', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36', '116.206.28.22'),
(272, 'Prat1337x', 'logout', NULL, '30 Jul 2023 22:19:40', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36', '180.252.255.187'),
(273, 'Dekils', 'login', '30 Jul 2023 22:19:47', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36', '180.252.255.187'),
(274, 'Dekils', 'login', '30 Jul 2023 22:28:52', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36', '180.252.255.187'),
(275, 'Dekils', 'login', '30 Jul 2023 22:55:38', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36', '180.252.255.187'),
(276, 'Dekils', 'login', '30 Jul 2023 23:02:42', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36', '180.252.255.187'),
(277, 'dekils', 'login', '31 Jul 2023 06:45:06', NULL, 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Safari/537.36', '114.142.175.58'),
(278, 'dekils', 'login', '31 Jul 2023 10:11:54', NULL, 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Safari/537.36', '114.142.175.58'),
(279, 'Dekils', 'login', '31 Jul 2023 13:19:21', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36', '180.252.255.187'),
(280, 'dekils', 'login', '31 Jul 2023 17:20:58', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.35'),
(281, 'dekils', 'login', '31 Jul 2023 17:21:09', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.35'),
(282, 'dekils', 'login', '31 Jul 2023 17:21:20', NULL, 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Safari/537.36', '114.142.175.35'),
(283, 'dekils', 'login', '31 Jul 2023 17:21:31', NULL, 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Safari/537.36', '114.142.175.35'),
(284, 'dekils', 'login', '31 Jul 2023 17:21:41', NULL, 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Safari/537.36', '114.142.175.35'),
(285, 'dekils', 'login', '31 Jul 2023 17:22:16', NULL, 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Safari/537.36', '114.142.175.35'),
(286, 'dekils', 'login', '31 Jul 2023 17:22:33', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.35'),
(287, 'dekils', 'login', '31 Jul 2023 17:23:45', NULL, 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Safari/537.36', '114.142.175.35'),
(288, 'dekils', 'login', '31 Jul 2023 17:24:02', NULL, 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Safari/537.36', '114.142.175.35'),
(289, 'dekils', 'login', '31 Jul 2023 17:24:12', NULL, 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Safari/537.36', '114.142.175.35'),
(290, 'dekils', 'login', '31 Jul 2023 17:25:29', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.35'),
(291, 'dekils', 'login', '31 Jul 2023 17:26:38', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.35'),
(292, 'dekils', 'login', '31 Jul 2023 17:26:46', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.35'),
(293, 'dekils', 'login', '31 Jul 2023 17:27:37', NULL, 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Safari/537.36', '114.142.175.35'),
(294, 'dekils', 'login', '31 Jul 2023 17:27:52', NULL, 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Safari/537.36', '114.142.175.35'),
(295, 'dekils', 'login', '31 Jul 2023 17:28:01', NULL, 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Safari/537.36', '114.142.175.35'),
(296, 'dekils', 'login', '31 Jul 2023 17:28:47', NULL, 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Safari/537.36', '114.142.175.35'),
(297, 'dekils', 'login', '31 Jul 2023 17:29:52', NULL, 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Safari/537.36', '114.142.175.35'),
(298, 'dekils', 'login', '31 Jul 2023 17:29:53', NULL, 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Safari/537.36', '114.142.175.35'),
(299, 'dekils', 'login', '31 Jul 2023 17:36:03', NULL, 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Safari/537.36', '114.142.175.35'),
(300, 'dekils', 'login', '31 Jul 2023 18:28:09', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.35'),
(301, 'Dekils', 'login', '31 Jul 2023 19:18:41', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36', '180.214.232.5'),
(302, 'Dekils', 'login', '31 Jul 2023 20:02:13', NULL, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36', '81.198.216.121'),
(303, 'dekils', 'login', '31 Jul 2023 22:31:34', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Mobile Safari/537.36', '114.79.3.218'),
(304, 'dekils', 'login', '31 Jul 2023 22:31:36', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Mobile Safari/537.36', '114.79.3.218'),
(305, 'dekils', 'login', '31 Jul 2023 22:31:38', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Mobile Safari/537.36', '114.79.3.218'),
(306, 'dekils', 'login', '01 Aug 2023 07:15:06', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.49'),
(307, 'dekils', 'login', '01 Aug 2023 09:57:08', NULL, 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Safari/537.36', '140.213.122.145'),
(308, 'dekils', 'login', '01 Aug 2023 11:56:56', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '140.213.122.24'),
(309, 'dekils', 'login', '01 Aug 2023 14:14:53', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '140.213.122.24'),
(310, 'Dekils', 'login', '01 Aug 2023 14:57:40', NULL, 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.3 Mobile/15E148 Safari/604.1', '182.2.140.104'),
(311, 'Dekils', 'login', '01 Aug 2023 14:57:43', NULL, 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.3 Mobile/15E148 Safari/604.1', '182.2.140.104'),
(312, 'dekils', 'login', '01 Aug 2023 17:33:10', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '140.213.122.24'),
(313, 'dekils', 'login', '02 Aug 2023 05:49:03', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '103.105.25.25'),
(314, 'ulanncantik99', 'logout', NULL, '02 Aug 2023 06:07:43', 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '103.105.25.25'),
(315, 'dekils', 'login', '02 Aug 2023 06:07:51', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '103.105.25.25'),
(316, 'dekils', 'login', '02 Aug 2023 06:26:11', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '103.105.25.25'),
(317, 'dekils', 'login', '02 Aug 2023 07:12:09', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.63'),
(318, 'dekils', 'login', '03 Aug 2023 02:37:37', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Mobile Safari/537.36', '125.164.22.97'),
(319, 'dekils', 'login', '03 Aug 2023 06:59:21', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.48'),
(320, 'dekils', 'login', '03 Aug 2023 08:31:12', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.39'),
(321, 'dekils', 'login', '03 Aug 2023 08:32:43', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.39'),
(322, 'dekils', 'login', '03 Aug 2023 10:37:50', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.52'),
(323, 'dekils', 'login', '03 Aug 2023 11:22:35', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.52'),
(324, 'dekils', 'login', '03 Aug 2023 12:15:16', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.52'),
(325, 'dekils', 'login', '03 Aug 2023 15:46:18', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.41'),
(326, 'dekils', 'login', '03 Aug 2023 15:57:19', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.41'),
(327, 'dekils', 'login', '03 Aug 2023 18:17:35', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.60'),
(328, 'dekils', 'login', '03 Aug 2023 20:10:50', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.61'),
(329, 'dekils', 'login', '03 Aug 2023 21:19:32', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.61'),
(330, 'dekils', 'login', '03 Aug 2023 23:34:29', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '104.28.217.187'),
(331, 'dekils', 'login', '04 Aug 2023 08:19:32', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.46'),
(332, 'dekils', 'login', '04 Aug 2023 09:07:06', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.52'),
(333, 'dekils', 'login', '04 Aug 2023 10:31:08', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.52'),
(334, 'dekils', 'login', '04 Aug 2023 11:23:12', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '103.105.25.15'),
(335, 'dekils', 'login', '04 Aug 2023 16:12:35', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.34'),
(336, 'dekils', 'login', '04 Aug 2023 16:12:54', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.34'),
(337, 'dekils', 'login', '04 Aug 2023 16:14:52', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.34'),
(338, 'dekils', 'login', '05 Aug 2023 09:37:25', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '103.105.25.13'),
(339, 'Endoo123', 'logout', NULL, '06 Aug 2023 03:30:55', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Mobile Safari/537.36', '116.206.15.15'),
(340, 'dekils', 'login', '06 Aug 2023 03:31:06', NULL, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Mobile Safari/537.36', '116.206.15.15'),
(341, 'dekils', 'login', '06 Aug 2023 09:22:05', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.53'),
(342, 'dekils', 'login', '06 Aug 2023 22:20:16', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.34'),
(343, 'dekils', 'login', '07 Aug 2023 07:53:49', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '140.213.122.209'),
(344, 'dekils', 'login', '07 Aug 2023 08:44:28', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '103.105.25.10'),
(345, 'dekils', 'login', '07 Aug 2023 19:57:14', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.43'),
(346, 'dekils', 'login', '08 Aug 2023 20:19:53', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '103.105.25.16'),
(347, 'dekils', 'login', '09 Aug 2023 11:17:01', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.56'),
(348, 'dekils', 'login', '09 Aug 2023 11:27:46', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.56'),
(349, 'dekils', 'login', '09 Aug 2023 16:54:26', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '103.105.25.4'),
(350, 'dekils', 'login', '09 Aug 2023 16:54:37', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '103.105.25.4'),
(351, 'dekils', 'login', '09 Aug 2023 16:55:38', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '103.105.25.4'),
(352, 'dekils', 'login', '09 Aug 2023 16:55:47', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '103.105.25.4'),
(353, 'dekils', 'login', '09 Aug 2023 16:55:58', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '103.105.25.4'),
(354, 'dekils', 'login', '09 Aug 2023 17:10:23', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '103.105.25.4'),
(355, 'dekils', 'login', '09 Aug 2023 19:21:04', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '103.105.25.29'),
(356, 'dekils', 'login', '09 Aug 2023 21:29:00', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.33'),
(357, 'perjaka88', 'logout', NULL, '09 Aug 2023 21:59:38', 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.33'),
(358, 'dekils', 'login', '09 Aug 2023 21:59:41', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.33'),
(359, 'perjaka88', 'logout', NULL, '09 Aug 2023 22:04:43', 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.33'),
(360, 'dekils', 'login', '09 Aug 2023 22:04:46', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.33'),
(361, 'perjaka88', 'logout', NULL, '09 Aug 2023 22:05:37', 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.33'),
(362, 'dekils', 'login', '09 Aug 2023 22:05:40', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.33'),
(363, 'perjaka88', 'logout', NULL, '09 Aug 2023 22:06:40', 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.33'),
(364, 'dekils', 'login', '09 Aug 2023 22:06:43', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.33'),
(365, 'perjaka88', 'logout', NULL, '09 Aug 2023 22:15:12', 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.45'),
(366, 'dekils', 'login', '09 Aug 2023 22:15:15', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.45'),
(367, 'dekils', 'login', '09 Aug 2023 23:13:19', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.45'),
(368, 'dekils', 'login', '09 Aug 2023 23:53:58', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.45'),
(369, 'dekils', 'login', '10 Aug 2023 11:14:23', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.36'),
(370, 'manobrako', 'logout', NULL, '10 Aug 2023 11:51:33', 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.36'),
(371, 'dekils', 'login', '10 Aug 2023 11:51:36', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.36'),
(372, 'manobrako', 'logout', NULL, '10 Aug 2023 11:52:45', 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.36'),
(373, 'dekils', 'login', '10 Aug 2023 11:52:47', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.36'),
(374, 'manobrako', 'logout', NULL, '10 Aug 2023 12:14:26', 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.42'),
(375, 'dekils', 'login', '10 Aug 2023 12:14:29', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.42'),
(376, 'manobrako', 'logout', NULL, '10 Aug 2023 12:16:17', 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.42'),
(377, 'dekils', 'login', '10 Aug 2023 12:16:20', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.42'),
(378, 'dekils', 'login', '10 Aug 2023 12:51:09', NULL, 'Mozilla/5.0 (Linux; Android 11; M2007J20CG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.85 Mobile Safari/537.36', '114.142.175.42');

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

--
-- Struktur dari tabel `balance_change_log`
--

CREATE TABLE `balance_change_log` (
  `id` int(11) NOT NULL,
  `username_pengguna` varchar(55) NOT NULL,
  `admin_username` varchar(255) NOT NULL,
  `old_balance` decimal(10,2) NOT NULL,
  `new_balance` decimal(10,2) NOT NULL,
  `change_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `balance_change_log`
--

INSERT INTO `balance_change_log` (`id`, `username_pengguna`, `admin_username`, `old_balance`, `new_balance`, `change_date`) VALUES
(102, 'Sambo303', 'dekils', 0.00, 100.00, '2023-07-30 15:20:14'),
(103, 'Wageg11', 'dekils', 100000.00, 100000.00, '2023-07-30 15:56:21'),
(104, 'Anndee', 'dekils', 100000.00, 100000.00, '2023-07-30 15:59:47'),
(105, 'Borju88', 'dekils', 50000.00, 100000.00, '2023-07-31 03:15:21'),
(106, 'Kopi168Jp5Jta', 'dekils', 0.00, 100000.00, '2023-07-31 10:37:12'),
(107, 'Adelia11', 'dekils', 150000.00, 300000.00, '2023-07-31 10:52:37'),
(108, 'Kuyabalap', 'dekils', 50000.00, 100000.00, '2023-07-31 11:30:10'),
(109, 'jadijp123', 'dekils', 0.00, 200000.00, '2023-08-01 04:58:10'),
(110, 'ulanncantik99', 'dekils', 0.00, 2680000.00, '2023-08-01 23:08:52'),
(111, 'Recehanah66', 'dekils', 0.00, 100000.00, '2023-08-03 03:38:14'),
(112, 'Yola09', 'dekils', 100000.00, 0.00, '2023-08-03 05:17:44'),
(113, 'Degel88', 'dekils', 0.00, 100000.00, '2023-08-03 08:57:51'),
(114, 'Yola09', 'dekils', 50000.00, 100000.00, '2023-08-03 11:21:56'),
(115, 'alberth', 'dekils', 98000.00, 196000.00, '2023-08-03 14:44:26'),
(116, 'detik14', 'dekils', 0.00, 200000.00, '2023-08-03 16:34:54'),
(117, 'gasjp99', 'dekils', 50000.00, 100000.00, '2023-08-04 03:44:12'),
(118, 'Jpkampang', 'dekils', 50000.00, 100000.00, '2023-08-04 09:15:22'),
(119, 'Milkyway168', 'dekils', 50000.00, 100000.00, '2023-08-05 02:38:04'),
(120, 'Endoo123', 'dekils', 10000.00, 100000.00, '2023-08-05 20:32:04'),
(121, 'Bangjun', 'dekils', 0.00, 100000.00, '2023-08-08 13:21:06'),
(122, 'perjaka88', 'dekils', 100000.00, 200000.00, '2023-08-09 14:29:35'),
(123, 'perjaka88', 'dekils', 200000.00, 2368000.00, '2023-08-09 15:00:25'),
(124, 'perjaka88', 'dekils', 0.00, 2368000.00, '2023-08-09 15:06:02'),
(125, 'Kadal11', 'dekils', 2368000.00, 0.00, '2023-08-09 15:19:58'),
(126, 'Agusrahayu', 'dekils', 0.00, 100000.00, '2023-08-09 16:16:26'),
(127, 'Bandit662', 'dekils', 50000.00, 100000.00, '2023-08-09 16:54:33'),
(128, 'manobrako', 'dekils', 300000.00, 1830000.00, '2023-08-10 05:15:21'),
(129, 'papahgila88', 'dekils', 58000.00, 116000.00, '2023-08-10 05:52:18'),
(130, 'Nadila', 'dekils', 50000.00, 100000.00, '2023-08-10 06:09:46');

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

--
-- Struktur dari tabel `bank_options`
--

CREATE TABLE `bank_options` (
  `id` int(11) NOT NULL,
  `value` varchar(50) NOT NULL,
  `att` varchar(50) DEFAULT NULL,
  `rek` varchar(50) DEFAULT NULL,
  `label` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `bank_options`
--

INSERT INTO `bank_options` (`id`, `value`, `att`, `rek`, `label`) VALUES
(48, 'REKENING', '0', 'KLIK DISINI', ''),
(50, 'BCA', '00', 'HUBUNGI LIVECHAT', ''),
(51, 'BRI', '514901013767533', 'NURLAILA', ''),
(52, 'GOPAY', '085810407418', 'ANISA BAHRUDIN', ''),
(53, 'LINKAJA', '085950702500', 'ADI RIYANTO', ''),
(54, 'OVO', '085811168256', 'FERDIANSYAH', ''),
(56, 'NEOBANK', '5859458199740821', 'RENALDI RAHIM', ''),
(57, 'DANA', '083871065675', 'SULFIKAR', '');

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

--
-- Struktur dari tabel `banners`
--

CREATE TABLE `banners` (
  `id` int(11) NOT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `alt_text` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `banners`
--

INSERT INTO `banners` (`id`, `image_path`, `alt_text`) VALUES
(72, '../banner/20230809_175907.jpg', 'BONUS NEWMEMBER 100% TO X7');

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

--
-- Struktur dari tabel `bannersdesktop`
--

CREATE TABLE `bannersdesktop` (
  `id` int(11) NOT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `alt_text` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `bannersdesktop`
--

INSERT INTO `bannersdesktop` (`id`, `image_path`, `alt_text`) VALUES
(28, '../bannerdesktop/Safeimagekit-resized-img.jpg', 'OWNER');

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

--
-- Struktur dari tabel `configuration`
--

CREATE TABLE `configuration` (
  `id` int(11) NOT NULL,
  `key_name` varchar(255) NOT NULL,
  `value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Struktur dari tabel `deleted_users`
--

CREATE TABLE `deleted_users` (
  `id` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `level` varchar(50) NOT NULL,
  `deleted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `admin_username` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Struktur dari tabel `deposits`
--

CREATE TABLE `deposits` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `submit_date` varchar(55) DEFAULT NULL,
  `username` varchar(50) DEFAULT NULL,
  `bank_name` varchar(10) DEFAULT NULL,
  `acc_no` varchar(55) DEFAULT NULL,
  `fullname` varchar(55) DEFAULT NULL,
  `destination` text DEFAULT NULL,
  `status` enum('Pending','Approved','Rejected') DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `activity_type` varchar(255) NOT NULL DEFAULT 'Deposit',
  `activity_details` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `deposits`
--

INSERT INTO `deposits` (`id`, `user_id`, `amount`, `submit_date`, `username`, `bank_name`, `acc_no`, `fullname`, `destination`, `status`, `created_at`, `updated_at`, `activity_type`, `activity_details`) VALUES
(343, 35, 10000.00, '2023-07-30', 'dekils', 'BCA', '1234567890', 'LOLI', 'ovo', 'Approved', '2023-07-30 14:05:16', '2023-07-30 14:05:16', 'Deposit', NULL),
(344, 35, 1000000.00, '2023-07-30', 'dekils', 'BCA', '1234567890', 'LOLI', 'ovo', 'Rejected', '2023-07-30 14:07:49', '2023-07-30 14:07:49', 'Deposit', NULL),
(345, 35, 1000000.00, '2023-07-30', 'dekils', 'BCA', '1234567890', 'LOLI', 'ovo', 'Approved', '2023-07-30 14:09:10', '2023-07-30 14:09:10', 'Deposit', NULL),
(346, 165, 100000.00, '2023-07-30', 'Sayangmamah', 'DANA', '087871259269', 'Suryanah', 'BCA', 'Approved', '2023-07-30 15:28:34', '2023-07-30 15:28:34', 'Deposit', NULL),
(347, 168, 100000.00, '2023-07-30', 'Wageg11', 'DANA', '085893696502', 'MOCHAMMAD SADHAT ARDANI', 'BCA', 'Approved', '2023-07-30 15:54:58', '2023-07-30 15:54:58', 'Deposit', NULL),
(348, 167, 100000.00, '2023-07-30', 'Anndee', 'BCA', '7610964065', 'Andhi Rimantiasto', 'BCA', 'Approved', '2023-07-30 15:59:06', '2023-07-30 15:59:06', 'Deposit', NULL),
(349, 35, 100000.00, '2023-07-31', 'dekils', 'BCA', '1234567890', 'LOLI', 'NEOBANK', 'Approved', '2023-07-30 23:52:24', '2023-07-30 23:52:24', 'Deposit', NULL),
(350, 170, 50000.00, '2023-07-31', 'Borju88', 'DANA', '087898046836', 'Ai Nuraeni', 'DANA', 'Approved', '2023-07-31 03:13:31', '2023-07-31 03:13:31', 'Deposit', NULL),
(351, 162, 50000.00, '2023-07-31', 'Prat1337x', 'BCA', '2950063098', 'Abdul hadi', 'NEOBANK', 'Approved', '2023-07-31 06:18:48', '2023-07-31 06:18:48', 'Deposit', NULL),
(352, 172, 50000.00, '2023-07-31', 'Kopi168Jp5Jta', 'DANA', '081528448286', 'Djamila', 'DANA', 'Rejected', '2023-07-31 10:20:30', '2023-07-31 10:20:30', 'Deposit', NULL),
(353, 169, 150000.00, '2023-07-31', 'Adelia11', 'DANA', '081395914850', 'Ramlan', 'NEOBANK', 'Approved', '2023-07-31 10:47:31', '2023-07-31 10:47:31', 'Deposit', NULL),
(354, 173, 50000.00, '2023-07-31', 'Kuyabalap', 'DANA', '085314918928', 'Jaja sudrajat', 'DANA', 'Approved', '2023-07-31 11:24:33', '2023-07-31 11:24:33', 'Deposit', NULL),
(355, 175, 100000.00, '2023-08-01', 'jadijp123', 'DANA', '085609230010', 'SUSANTI', 'DANA', 'Rejected', '2023-08-01 04:53:34', '2023-08-01 04:53:34', 'Deposit', NULL),
(356, 179, 50000.00, '2023-08-01', 'Fakip77', 'DANA', '082182352844', 'Mahliadi', 'DANA', 'Rejected', '2023-08-01 10:32:03', '2023-08-01 10:32:03', 'Deposit', NULL),
(357, 181, 500000.00, '2023-08-01', 'Markas38', 'DANA', '0858363737838', 'Rizki Maulana ', 'DANA', 'Rejected', '2023-08-01 14:57:09', '2023-08-01 14:57:09', 'Deposit', NULL),
(358, 182, 2834000.00, '2023-08-02', 'ulanncantik99', 'DANA', '0822628363823', 'WULANDARI ', 'DANA', 'Approved', '2023-08-01 23:25:55', '2023-08-01 23:25:55', 'Deposit', NULL),
(359, 188, 50000.00, '2023-08-03', 'Recehanah66', 'DANA', '085754432536', 'Rian Gumilar jaya', 'DANA', 'Rejected', '2023-08-03 03:33:34', '2023-08-03 03:33:34', 'Deposit', NULL),
(360, 190, 50000.00, '2023-08-03', 'Degel88', 'DANA', '085600439896', 'Hendra rahwanto', 'DANA', 'Rejected', '2023-08-03 07:57:34', '2023-08-03 07:57:34', 'Deposit', NULL),
(361, 189, 50000.00, '2023-08-03', 'Yola09', 'DANA', '085871179241', 'Yolanda rahman', 'DANA', 'Approved', '2023-08-03 11:18:07', '2023-08-03 11:18:07', 'Deposit', NULL),
(362, 195, 50000.00, '2023-08-03', 'Sempak4d', 'BCA', '7820414025', 'Maman saputra', 'BCA', 'Rejected', '2023-08-03 11:55:45', '2023-08-03 11:55:45', 'Deposit', NULL),
(363, 198, 25000.00, '2023-08-03', 'Fahmijp', 'DANA', '085714994431', 'Ari wibowo', 'DANA', 'Rejected', '2023-08-03 13:03:27', '2023-08-03 13:03:27', 'Deposit', NULL),
(364, 198, 25000.00, '2023-08-03', 'Fahmijp', 'DANA', '085714994431', 'Ari wibowo', 'DANA', 'Rejected', '2023-08-03 13:12:54', '2023-08-03 13:12:54', 'Deposit', NULL),
(365, 198, 50000.00, '2023-08-03', 'Fahmijp', 'DANA', '085714994431', 'Ari wibowo', 'DANA', 'Approved', '2023-08-03 13:15:08', '2023-08-03 13:15:08', 'Deposit', NULL),
(366, 202, 98000.00, '2023-08-03', 'alberth', 'BRI', '361901024038534', 'juniati rosalina hun', 'BRI', 'Approved', '2023-08-03 14:38:06', '2023-08-03 14:38:06', 'Deposit', NULL),
(367, 204, 100000.00, '2023-08-03', 'detik14', 'DANA', '082144844432', 'iwanto', 'DANA', 'Rejected', '2023-08-03 16:31:49', '2023-08-03 16:31:49', 'Deposit', NULL),
(368, 206, 50000.00, '2023-08-04', 'gasjp99', 'DANA', '085841121259', 'suprianto', 'DANA', 'Approved', '2023-08-04 03:39:38', '2023-08-04 03:39:38', 'Deposit', NULL),
(369, 211, 50000.00, '2023-08-04', 'Jpkampang', 'DANA', '0895420975680', 'Andri kurniawan', 'DANA', 'Approved', '2023-08-04 09:11:23', '2023-08-04 09:11:23', 'Deposit', NULL),
(370, 215, 50000.00, '2023-08-05', 'Milkyway168', 'BCA', '8135410612', 'Hendrizal', 'BCA', 'Approved', '2023-08-05 02:36:50', '2023-08-05 02:36:50', 'Deposit', NULL),
(371, 159, 10000.00, '2023-08-06', 'Endoo123', 'Permata', '08988891332', 'Kepilu', 'DANA', 'Approved', '2023-08-05 20:30:46', '2023-08-05 20:30:46', 'Deposit', NULL),
(372, 220, 50000.00, '2023-08-06', 'Uwong168', 'BCA', '5850329801', 'Zainal muttaqin', 'DANA', 'Approved', '2023-08-06 15:12:03', '2023-08-06 15:12:03', 'Deposit', NULL),
(373, 220, 50000.00, '2023-08-06', 'Uwong168', 'BCA', '5850329801', 'Zainal muttaqin', 'NEOBANK', 'Rejected', '2023-08-06 15:24:20', '2023-08-06 15:24:20', 'Deposit', NULL),
(374, 221, 50000.00, '2023-08-07', 'Ruly78', 'DANA', '085782587455', 'Ruly Amarulloh', 'DANA', 'Approved', '2023-08-06 21:00:48', '2023-08-06 21:00:48', 'Deposit', NULL),
(375, 221, 50000.00, '2023-08-07', 'Ruly78', 'DANA', '085782587455', 'Ruly Amarulloh', 'DANA', 'Rejected', '2023-08-07 03:10:16', '2023-08-07 03:10:16', 'Deposit', NULL),
(376, 224, 50000.00, '2023-08-08', 'Bangjun', 'DANA', '081273660466', 'Junani', 'DANA', 'Rejected', '2023-08-08 13:18:01', '2023-08-08 13:18:01', 'Deposit', NULL),
(377, 228, 40000.00, '2023-08-09', 'Jakatbatara', 'DANA', '085255500570', 'Sumardi', 'DANA', 'Rejected', '2023-08-09 12:11:23', '2023-08-09 12:11:23', 'Deposit', NULL),
(378, 228, 50000.00, '2023-08-09', 'Jakatbatara', 'DANA', '085255500570', 'Sumardi', 'DANA', 'Approved', '2023-08-09 12:47:57', '2023-08-09 12:47:57', 'Deposit', NULL),
(379, 229, 100000.00, '2023-08-09', 'perjaka88', 'DANA', '082363839292', 'ANIS SORAYA', 'DANA', 'Approved', '2023-08-09 14:28:47', '2023-08-09 14:28:47', 'Deposit', NULL),
(380, 235, 20000.00, '2023-08-09', 'Agusrahayu', 'DANA', '081255439817', 'Suriani', 'DANA', 'Rejected', '2023-08-09 16:08:02', '2023-08-09 16:08:02', 'Deposit', NULL),
(381, 235, 50000.00, '2023-08-09', 'Agusrahayu', 'DANA', '081255439817', 'Suriani', 'DANA', 'Rejected', '2023-08-09 16:22:01', '2023-08-09 16:22:01', 'Deposit', NULL),
(382, 237, 50000.00, '2023-08-09', 'Bandit662', 'DANA', '081317047500', 'Nurdian nurdin', 'DANA', 'Approved', '2023-08-09 16:44:59', '2023-08-09 16:44:59', 'Deposit', NULL),
(383, 240, 750000.00, '2023-08-10', 'Manuel90', 'GOPAY', '081617823364', 'Riyan ', 'GOPAY', 'Rejected', '2023-08-09 17:19:50', '2023-08-09 17:19:50', 'Deposit', NULL),
(384, 240, 750000.00, '2023-08-10', 'Manuel90', 'GOPAY', '081617823364', 'Riyan ', 'REKENING', 'Rejected', '2023-08-09 17:21:43', '2023-08-09 17:21:43', 'Deposit', NULL),
(385, 241, 100000.00, '2023-08-10', 'Lasita99', 'BCA', '8907030258', 'Liza arsita', 'BCA', 'Rejected', '2023-08-09 19:00:57', '2023-08-09 19:00:57', 'Deposit', NULL),
(386, 243, 150000.00, '2023-08-10', 'manobrako', 'DANA', '082362829491', 'RISMAN ABIGAIL', 'DANA', 'Approved', '2023-08-10 04:51:28', '2023-08-10 04:51:28', 'Deposit', NULL),
(387, 243, 150000.00, '2023-08-10', 'manobrako', 'DANA', '082362829491', 'RISMAN ABIGAIL', 'REKENING', 'Approved', '2023-08-10 04:52:39', '2023-08-10 04:52:39', 'Deposit', NULL),
(388, 244, 58000.00, '2023-08-10', 'papahgila88', 'LinkAja', '085641825018', 'hanifatul afifah', 'LINKAJA', 'Approved', '2023-08-10 05:50:52', '2023-08-10 05:50:52', 'Deposit', NULL),
(389, 245, 50000.00, '2023-08-10', 'Nadila', 'DANA', '085346365100', 'Nadila', 'REKENING', 'Approved', '2023-08-10 06:08:36', '2023-08-10 06:08:36', 'Deposit', NULL);

--
-- Trigger `deposits`
--
DELIMITER $$
    END IF;
END
$$
DELIMITER ;

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

--
-- Struktur dari tabel `deposits_history`
--

CREATE TABLE `deposits_history` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `destination` varchar(255) NOT NULL,
  `amount` int(11) NOT NULL,
  `status` enum('Pending','Approved') NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Struktur dari tabel `deposit_approved`
--

CREATE TABLE `deposit_approved` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `destination` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Struktur dari tabel `deposit_progress`
--

CREATE TABLE `deposit_progress` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `destination` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Struktur dari tabel `failed_logins`
--

CREATE TABLE `failed_logins` (
  `id` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `count` int(11) NOT NULL DEFAULT 0,
  `last_failed_login_time` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Struktur dari tabel `login_history`
--

CREATE TABLE `login_history` (
  `id` int(12) NOT NULL,
  `user_id` int(12) NOT NULL,
  `username` varchar(50) NOT NULL,
  `last_login_ip` varchar(45) NOT NULL,
  `login_time` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Struktur dari tabel `maintenance_settings`
--

CREATE TABLE `maintenance_settings` (
  `id` int(11) NOT NULL,
  `maintenance_mode` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Struktur dari tabel `saldo_edit_history`
--

CREATE TABLE `saldo_edit_history` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `old_balance` decimal(10,2) NOT NULL,
  `new_balance` decimal(10,2) NOT NULL,
  `edited_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `edited_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Struktur dari tabel `transactions`
--

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `username` int(11) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `transaction_type` enum('deposit','withdraw') NOT NULL,
  `transaction_time` datetime NOT NULL,
  `status` enum('approved','pending','rejected') NOT NULL DEFAULT 'pending'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Struktur dari tabel `user_activity`
--

CREATE TABLE `user_activity` (
  `id` int(11) NOT NULL,
  `admin_username` varchar(50) NOT NULL,
  `activity_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `activity_type` varchar(50) NOT NULL,
  `activity_details` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Struktur dari tabel `user_balance`
--

CREATE TABLE `user_balance` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `balance` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Struktur dari tabel `withdraws`
--

CREATE TABLE `withdraws` (
  `id` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` varchar(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `admin_action` enum('Rejected','Approved') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `withdraws`
--

INSERT INTO `withdraws` (`id`, `username`, `amount`, `status`, `created_at`, `updated_at`, `admin_action`) VALUES
(143, 'dekils', 10000.00, 'Approved', '2023-07-30 14:10:39', '2023-07-30 14:11:16', NULL),
(144, 'Borju88', 100000.00, 'Rejected', '2023-07-31 03:25:19', '2023-07-31 03:27:35', NULL),
(145, 'Kuyabalap', 100000.00, 'Rejected', '2023-07-31 12:50:01', '2023-07-31 12:51:04', NULL),
(146, 'Adelia11', 300000.00, 'Rejected', '2023-07-31 12:50:21', '2023-07-31 12:53:12', NULL),
(147, 'Kuyabalap', 50000.00, 'Rejected', '2023-07-31 12:53:26', '2023-07-31 12:54:28', NULL),
(148, 'Adelia11', 50000.00, 'Rejected', '2023-07-31 12:54:55', '2023-07-31 12:55:58', NULL),
(149, 'Kuyabalap', 350000.00, 'Rejected', '2023-07-31 12:55:40', '2023-07-31 12:56:56', NULL),
(150, 'Adelia11', 50000.00, 'Rejected', '2023-07-31 12:56:54', '2023-07-31 12:57:55', NULL),
(151, 'Adelia11', 400000.00, 'Rejected', '2023-07-31 12:58:58', '2023-07-31 13:00:34', NULL),
(152, 'Adelia11', 400000.00, 'Rejected', '2023-07-31 13:59:56', '2023-07-31 14:06:56', NULL),
(153, 'Adelia11', 150000.00, 'Rejected', '2023-07-31 14:07:43', '2023-07-31 14:08:50', NULL),
(154, 'Adelia11', 400000.00, 'Rejected', '2023-07-31 15:20:29', '2023-07-31 15:22:30', NULL),
(155, 'Adelia11', 200000.00, 'Rejected', '2023-07-31 15:22:51', '2023-07-31 15:23:55', NULL),
(156, 'Adelia11', 150000.00, 'Rejected', '2023-07-31 15:24:40', '2023-07-31 15:37:46', NULL),
(157, 'ulanncantik99', 2680000.00, 'Approved', '2023-08-01 23:10:50', '2023-08-01 23:11:31', NULL),
(158, 'Recehanah66', 100000.00, 'Rejected', '2023-08-03 03:52:23', '2023-08-03 04:08:55', NULL),
(159, 'Degel88', 100000.00, 'Rejected', '2023-08-03 09:05:55', '2023-08-03 09:07:07', NULL),
(160, 'Fahmijp', 50000.00, 'Rejected', '2023-08-03 13:30:31', '2023-08-03 13:31:33', NULL),
(161, 'Fahmijp', 50000.00, 'Rejected', '2023-08-03 13:49:03', '2023-08-03 13:50:12', NULL),
(162, 'alberth', 68000.00, 'Rejected', '2023-08-03 14:55:47', '2023-08-03 14:58:47', NULL),
(163, 'Fahmijp', 118000.00, 'Rejected', '2023-08-03 15:00:19', '2023-08-03 15:01:29', NULL),
(164, 'Fahmijp', 100000.00, 'Rejected', '2023-08-03 15:19:34', '2023-08-03 15:20:49', NULL),
(165, 'detik14', 200000.00, 'Rejected', '2023-08-03 16:44:43', '2023-08-03 16:48:00', NULL),
(166, 'detik14', 100000.00, 'Rejected', '2023-08-03 17:06:49', '2023-08-03 17:22:32', NULL),
(167, 'Fahmijp', 100000.00, 'Rejected', '2023-08-04 00:15:30', '2023-08-04 00:16:32', NULL),
(168, 'Jpkampang', 100000.00, 'Rejected', '2023-08-04 09:21:30', '2023-08-04 09:22:41', NULL),
(169, 'Fahmijp', 100000.00, 'Rejected', '2023-08-04 14:24:29', '2023-08-04 14:25:56', NULL),
(170, 'Milkyway168', 10000.00, 'Rejected', '2023-08-05 02:47:39', '2023-08-05 02:48:52', NULL),
(171, 'Milkyway168', 100000.00, 'Rejected', '2023-08-05 02:49:14', '2023-08-05 02:50:23', NULL),
(172, 'Uwong168', 50000.00, 'Rejected', '2023-08-06 15:33:08', '2023-08-06 15:34:42', NULL),
(173, 'Uwong168', 50000.00, 'Rejected', '2023-08-06 15:36:34', '2023-08-06 15:37:48', NULL),
(174, 'Uwong168', 50000.00, 'Rejected', '2023-08-06 15:38:42', '2023-08-06 15:39:51', NULL),
(175, 'Bangjun', 100000.00, 'Rejected', '2023-08-08 13:28:26', '2023-08-08 13:29:29', NULL),
(176, 'Jakatbatara', 50000.00, 'Rejected', '2023-08-09 12:57:54', '2023-08-09 12:59:24', NULL),
(177, 'perjaka88', 2368000.00, 'Rejected', '2023-08-09 15:01:28', '2023-08-09 15:03:15', NULL),
(178, 'perjaka88', 2368000.00, 'Approved', '2023-08-09 15:06:34', '2023-08-09 15:07:01', NULL),
(179, 'Bandit662', 50000.00, 'Rejected', '2023-08-09 16:58:26', '2023-08-09 17:00:59', NULL),
(180, 'manobrako', 1830000.00, 'Approved', '2023-08-10 05:16:02', '2023-08-10 05:16:39', NULL);

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `accordions`
--
ALTER TABLE `accordions`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `admin_activity`
--
ALTER TABLE `admin_activity`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `admin_activity_log`
--
ALTER TABLE `admin_activity_log`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `balance_change_log`
--
ALTER TABLE `balance_change_log`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `bank_options`
--
ALTER TABLE `bank_options`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `banners`
--
ALTER TABLE `banners`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `bannersdesktop`
--
ALTER TABLE `bannersdesktop`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `configuration`
--
ALTER TABLE `configuration`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `deleted_users`
--
ALTER TABLE `deleted_users`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `deposits`
--
ALTER TABLE `deposits`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indeks untuk tabel `deposits_history`
--
ALTER TABLE `deposits_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indeks untuk tabel `deposit_approved`
--
ALTER TABLE `deposit_approved`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `deposit_progress`
--
ALTER TABLE `deposit_progress`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `failed_logins`
--
ALTER TABLE `failed_logins`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `login_history`
--
ALTER TABLE `login_history`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `maintenance_settings`
--
ALTER TABLE `maintenance_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `saldo_edit_history`
--
ALTER TABLE `saldo_edit_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `edited_by` (`edited_by`);

--
-- Indeks untuk tabel `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`username`);

--
-- Indeks untuk tabel `user_activity`
--
ALTER TABLE `user_activity`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `user_balance`
--
ALTER TABLE `user_balance`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indeks untuk tabel `withdraws`
--
ALTER TABLE `withdraws`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `accordions`
--
ALTER TABLE `accordions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- AUTO_INCREMENT untuk tabel `admin_activity`
--
ALTER TABLE `admin_activity`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT untuk tabel `admin_activity_log`
--
ALTER TABLE `admin_activity_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=379;

--
-- AUTO_INCREMENT untuk tabel `balance_change_log`
--
ALTER TABLE `balance_change_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=131;

--
-- AUTO_INCREMENT untuk tabel `bank_options`
--
ALTER TABLE `bank_options`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58;

--
-- AUTO_INCREMENT untuk tabel `banners`
--
ALTER TABLE `banners`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;

--
-- AUTO_INCREMENT untuk tabel `bannersdesktop`
--
ALTER TABLE `bannersdesktop`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT untuk tabel `configuration`
--
ALTER TABLE `configuration`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `deleted_users`
--
ALTER TABLE `deleted_users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT untuk tabel `deposits`
--
ALTER TABLE `deposits`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=390;

--
-- AUTO_INCREMENT untuk tabel `deposits_history`
--
ALTER TABLE `deposits_history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT untuk tabel `deposit_approved`
--
ALTER TABLE `deposit_approved`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `deposit_progress`
--
ALTER TABLE `deposit_progress`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT untuk tabel `failed_logins`
--
ALTER TABLE `failed_logins`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT untuk tabel `login_history`
--
ALTER TABLE `login_history`
  MODIFY `id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=172;

--
-- AUTO_INCREMENT untuk tabel `maintenance_settings`
--
ALTER TABLE `maintenance_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `saldo_edit_history`
--
ALTER TABLE `saldo_edit_history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT untuk tabel `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT untuk tabel `user_activity`
--
ALTER TABLE `user_activity`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;

--
-- AUTO_INCREMENT untuk tabel `user_balance`
--
ALTER TABLE `user_balance`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `withdraws`
--
ALTER TABLE `withdraws`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=181;

--
-- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables)
--

--
-- Ketidakleluasaan untuk tabel `deposits_history`
--
ALTER TABLE `deposits_history`
  ADD CONSTRAINT `deposits_history_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Ketidakleluasaan untuk tabel `transactions`
--
ALTER TABLE `transactions`
  ADD CONSTRAINT `transactions_ibfk_1` FOREIGN KEY (`username`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Ketidakleluasaan untuk tabel `user_balance`
--
ALTER TABLE `user_balance`
  ADD CONSTRAINT `user_balance_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
COMMIT;

