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

START TRANSACTION;



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

--
-- Table structure for table `audit_logs`
--

CREATE TABLE `audit_logs` (
  `id` int(11) NOT NULL,
  `user_email` varchar(255) DEFAULT NULL,
  `device` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `ipAddress` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `datenow` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `audit_logs`
--

INSERT INTO `audit_logs` (`id`, `user_email`, `device`, `ipAddress`, `datenow`) VALUES
(1, 'ofofonobs@gmail.com', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36', '138.199.7.184', '2023-09-12 22:47:22'),
(2, 'ofofonobs@gmail.com', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36', '138.199.7.184', '2023-09-12 23:04:51'),
(3, 'ofofonobs@gmail.com', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36', '138.199.7.184', '2023-09-12 23:06:15'),
(4, 'drmaverick247@gmail.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_7_8 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.6 Mobile/15E148 Safari/604.1', '102.90.43.210', '2023-09-13 09:03:43'),
(5, 'drmaverick247@gmail.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_7_8 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.6 Mobile/15E148 Safari/604.1', '102.90.42.18', '2023-09-13 13:46:47'),
(6, 'drmaverick247@gmail.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_7_8 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.6 Mobile/15E148 Safari/604.1', '102.90.42.18', '2023-09-13 13:46:49'),
(7, 'drmaverick247@gmail.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_7_8 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.6 Mobile/15E148 Safari/604.1', '102.90.43.182', '2023-09-13 17:20:39'),
(8, 'ofofonobs@gmail.com', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/117.0', '143.244.44.183', '2023-09-16 09:24:40'),
(9, 'ofofonobs@gmail.com', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/117.0', '143.244.44.183', '2023-09-16 09:56:48'),
(10, 'ofofonobs@gmail.com', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/117.0', '143.244.44.183', '2023-09-16 17:34:30'),
(11, 'pfranis@gmail.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_7_8 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.6 Mobile/15E148 Safari/604.1', '102.90.42.223', '2023-09-16 19:28:47'),
(12, 'pfranis@gmail.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_7_8 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.6 Mobile/15E148 Safari/604.1', '102.90.42.223', '2023-09-16 19:28:48'),
(13, 'mantiger146@gmail.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/116.0.5845.177 Mobile/15E148 Safari/604.1', '197.210.226.245', '2023-09-16 19:59:50'),
(14, 'mantiger146@gmail.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/116.0.5845.177 Mobile/15E148 Safari/604.1', '197.210.226.245', '2023-09-16 20:03:18'),
(15, 'mantiger146@gmail.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/116.0.5845.177 Mobile/15E148 Safari/604.1', '197.210.54.156', '2023-09-16 23:05:53'),
(16, 'mantiger146@gmail.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/116.0.5845.177 Mobile/15E148 Safari/604.1', '197.210.54.156', '2023-09-16 23:05:54'),
(17, 'ofofonobs@gmail.com', 'Mozilla/5.0 (Linux; Android 11; Redmi Note 9 Pro) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Mobile Safari/537.36', '105.113.63.76', '2023-09-16 23:22:10'),
(18, 'mantiger146@gmail.com', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.31', '197.210.79.100', '2023-09-19 12:49:46'),
(19, 'mantiger146@gmail.com', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.31', '197.210.84.23', '2023-09-19 13:07:24'),
(20, 'mantiger146@gmail.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/116.0.5845.177 Mobile/15E148 Safari/604.1', '197.210.85.201', '2023-09-19 13:25:43'),
(21, 'mantiger146@gmail.com', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.31', '197.210.85.201', '2023-09-19 14:03:05'),
(22, 'arnolerato47@gmail.com', 'Mozilla/5.0 (Linux; U; Android 11; M2010J19SG Build/RKQ1.201004.002; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/94.0.4606.85 Mobile Safari/537.36 OPR/70.0.2254.66376', '102.23.96.14', '2023-09-19 14:11:06'),
(23, 'arnolerato47@gmail.com', 'Mozilla/5.0 (Linux; U; Android 11; M2010J19SG Build/RKQ1.201004.002; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/94.0.4606.85 Mobile Safari/537.36 OPR/70.0.2254.66376', '102.23.96.19', '2023-09-19 14:43:01'),
(24, 'mantiger146@gmail.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/116.0.5845.177 Mobile/15E148 Safari/604.1', '197.210.84.241', '2023-09-19 14:55:11'),
(25, 'mantiger146@gmail.com', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.31', '197.210.84.23', '2023-09-19 15:16:19'),
(26, 'mantiger146@gmail.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/116.0.5845.177 Mobile/15E148 Safari/604.1', '197.210.79.80', '2023-09-19 15:44:38'),
(27, 'arnolerato47@gmail.com', 'Mozilla/5.0 (Linux; U; Android 11; M2010J19SG Build/RKQ1.201004.002; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/94.0.4606.85 Mobile Safari/537.36 OPR/70.0.2254.66376', '102.23.96.19', '2023-09-19 22:19:49'),
(28, 'arnolerato47@gmail.com', 'Mozilla/5.0 (Linux; U; Android 11; M2010J19SG Build/RKQ1.201004.002; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/94.0.4606.85 Mobile Safari/537.36 OPR/70.0.2254.66376', '102.23.96.19', '2023-09-19 22:19:50'),
(29, 'arnolerato47@gmail.com', 'Mozilla/5.0 (Linux; U; Android 11; M2010J19SG Build/RKQ1.201004.002; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/94.0.4606.85 Mobile Safari/537.36 OPR/70.0.2254.66376', '102.23.96.19', '2023-09-19 22:20:01'),
(30, 'arnolerato47@gmail.com', 'Mozilla/5.0 (Linux; U; Android 11; M2010J19SG Build/RKQ1.201004.002; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/94.0.4606.85 Mobile Safari/537.36 OPR/70.0.2254.66376', '102.23.96.19', '2023-09-19 22:20:02'),
(31, 'arnolerato47@gmail.com', 'Mozilla/5.0 (Linux; U; Android 11; M2010J19SG Build/RKQ1.201004.002; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/94.0.4606.85 Mobile Safari/537.36 OPR/70.0.2254.66376', '102.23.96.19', '2023-09-19 22:20:03'),
(32, 'arnolerato47@gmail.com', 'Mozilla/5.0 (Linux; U; Android 11; M2010J19SG Build/RKQ1.201004.002; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/94.0.4606.85 Mobile Safari/537.36 OPR/70.0.2254.66376', '102.23.96.19', '2023-09-19 22:23:38'),
(33, 'mantiger146@gmail.com', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.31', '197.210.55.37', '2023-09-20 03:00:03'),
(34, 'mantiger146@gmail.com', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36 Edg/117.0.2045.31', '197.210.55.37', '2023-09-20 03:00:04'),
(35, 'Nairamateweb@gmail.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/133.0.6943.120 Mobile/15E148 Safari/604.1', '105.113.33.140', '2025-03-06 01:04:08'),
(36, 'Nairamateweb@gmail.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/133.0.6943.120 Mobile/15E148 Safari/604.1', '105.113.33.140', '2025-03-06 01:08:15'),
(37, 'Nairamateweb@gmail.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/133.0.6943.120 Mobile/15E148 Safari/604.1', '105.113.33.140', '2025-03-06 01:08:57'),
(38, 'lmmentertainments@gmail.com', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Mobile Safari/537.36', '31.94.8.25', '2025-03-06 09:17:36'),
(39, 'lmmentertainments@gmail.com', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Mobile Safari/537.36', '31.94.8.24', '2025-03-06 09:43:42'),
(40, 'lmmentertainments@gmail.com', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Mobile Safari/537.36', '31.94.8.24', '2025-03-06 09:44:16'),
(41, 'Nairamateweb@gmail.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/133.0.6943.120 Mobile/15E148 Safari/604.1', '102.90.102.246', '2025-03-07 09:08:29'),
(42, 'Nairamateweb@gmail.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/133.0.6943.120 Mobile/15E148 Safari/604.1', '102.90.102.246', '2025-03-07 09:09:15'),
(43, 'Nairamateweb@gmail.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/133.0.6943.120 Mobile/15E148 Safari/604.1', '102.90.102.246', '2025-03-07 09:34:42'),
(44, 'Nairamateweb@gmail.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/133.0.6943.120 Mobile/15E148 Safari/604.1', '102.90.102.246', '2025-03-07 09:35:14'),
(45, 'Nairamateweb@gmail.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/133.0.6943.120 Mobile/15E148 Safari/604.1', '102.90.102.246', '2025-03-07 10:20:34'),
(46, 'Nairamateweb@gmail.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/133.0.6943.120 Mobile/15E148 Safari/604.1', '102.90.102.246', '2025-03-07 10:20:53'),
(47, 'lmmentertainments@gmail.com', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Mobile Safari/537.36', '31.94.70.163', '2025-03-07 11:00:27'),
(48, 'lmmentertainments@gmail.com', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Mobile Safari/537.36', '31.94.70.163', '2025-03-07 11:01:17'),
(49, 'lmmentertainments@gmail.com', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Mobile Safari/537.36', '31.94.70.162', '2025-03-07 17:22:05'),
(50, 'lmmentertainments@gmail.com', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Mobile Safari/537.36', '31.94.70.162', '2025-03-07 17:23:25'),
(51, 'lmmentertainments@gmail.com', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Mobile Safari/537.36', '31.94.70.163', '2025-03-07 20:39:41'),
(52, 'lmmentertainments@gmail.com', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Mobile Safari/537.36', '31.94.70.163', '2025-03-07 20:40:37'),
(53, 'dlpev317@yahoo.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.3 Mobile/15E148 Safari/604.1', '104.28.78.100', '2025-03-08 11:31:37'),
(54, 'dlpev317@yahoo.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/130.0.6723.37 Mobile/15E148 Safari/604.1', '31.94.70.93', '2025-03-08 11:38:43'),
(55, 'lmmentertainments@gmail.com', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Mobile Safari/537.36', '31.94.70.93', '2025-03-08 11:42:10'),
(56, 'lmmentertainments@gmail.com', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Mobile Safari/537.36', '31.94.70.93', '2025-03-08 11:43:07'),
(57, 'thapluginc@yahoo.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/130.0.6723.37 Mobile/15E148 Safari/604.1', '31.94.70.93', '2025-03-08 12:07:08'),
(58, 'dlpev317@yahoo.com', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.3 Mobile/15E148 Safari/604.1', '104.28.32.99', '2025-03-08 12:18:49');

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

--
-- Table structure for table `crypto_currency`
--

CREATE TABLE `crypto_currency` (
  `id` int(11) NOT NULL,
  `crypto_name` varchar(200) NOT NULL,
  `short_name` varchar(255) DEFAULT NULL,
  `wallet_address` text NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `crypto_currency`
--

INSERT INTO `crypto_currency` (`id`, `crypto_name`, `short_name`, `wallet_address`, `created_at`) VALUES
(1, 'Bitcoin', 'BTC', '1581Hs3A3eQsKA8kDiFvKHRRjCjGomtXcd', '2022-11-06 21:58:35'),
(5, 'Etheruem', 'ETH', '0x658db2B83E3FcB734C7d21FBe9d48F6d69153997', '2022-11-06 21:58:35'),
(6, 'ETH', NULL, '0x658db2B83E3FcB734C7d21FBe9d48F6d69153997', '2023-09-19 06:52:13');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `url_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT 'Company Name',
  `url_tel` varchar(15) DEFAULT NULL COMMENT 'Company Number',
  `url_email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT 'Company Email',
  `url_address` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT 'Company Address',
  `padiwise_sms` int(11) NOT NULL DEFAULT 0 COMMENT '1=Activate, 0=Disactivate',
  `image` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT 'Company Logo',
  `currency` varchar(255) DEFAULT '$',
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `url_name`, `url_tel`, `url_email`, `url_address`, `padiwise_sms`, `image`, `currency`, `created_at`) VALUES
(1, 'Binance', '', 'info@clientdashboardbin.com', '', 0, 'logo.png', '$', '2023-03-28 14:51:33');

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

--
-- Table structure for table `ticket`
--

CREATE TABLE `ticket` (
  `ticket_id` int(11) NOT NULL,
  `acct_email` varchar(255) DEFAULT NULL,
  `ticket_message` text NOT NULL,
  `ticket_status` varchar(255) NOT NULL DEFAULT 'open' COMMENT 'open, closed, processing',
  `createdAt` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `ticket`
--

INSERT INTO `ticket` (`ticket_id`, `acct_email`, `ticket_message`, `ticket_status`, `createdAt`) VALUES
(1, 'ofofonobs@gmail.com', 'jhg ughhj', 'closed', '2023-09-16 09:10:22'),
(2, NULL, 'PLO bn  n lfhhj open ', 'processing', '2023-09-19 08:01:55'),
(3, NULL, 'PLO bn  n lfhhj open ', 'open', '2023-09-19 08:03:33');

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `trans_id` int(11) NOT NULL,
  `acct_email` varchar(255) NOT NULL,
  `crypto_id` int(11) DEFAULT NULL,
  `wallet_address` varchar(255) DEFAULT NULL,
  `amount` double NOT NULL,
  `trans_type` text DEFAULT NULL,
  `transaction_type` text DEFAULT NULL,
  `refrence_id` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `trans_status` text DEFAULT NULL COMMENT 'completed, pending, processing, failed.',
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`trans_id`, `acct_email`, `crypto_id`, `wallet_address`, `amount`, `trans_type`, `transaction_type`, `refrence_id`, `image`, `trans_status`, `created_at`) VALUES
(1, 'ofofonobs@gmail.com', 5, NULL, 900, 'Crypto Deposit', 'credit', 'jhgfghjdkjbhd', NULL, 'pending', '2023-09-16 02:09:05'),
(2, 'ofofonobs@gmail.com', 1, 'bc1qz90y4ydmcwzy3fl55rammn5x2cuncxl0d998ld', 21, 'Crypto Withdrawal', 'credit', '65054da237f90', '1694846370cred-logo.png', 'completed', '2023-09-16 02:39:30'),
(3, 'ofofonobs@gmail.com', 5, 'ihgfdfghjkjhgghjkjhvgfghjkjh', 272, 'Crypto Withdrawal', 'debit', '65055a9f75156', NULL, 'completed', '2023-09-16 03:34:55'),
(4, 'ofofonobs@gmail.com', NULL, NULL, 850, 'Crypto Deposit', 'credit', '65055ebe31c9a', NULL, 'failed', '2023-09-07 03:33:00'),
(5, 'ofofonobs@gmail.com', 1, NULL, 800, 'Crypto Deposit', 'credit', '65055ffa9470f', NULL, 'processing', '2023-03-16 03:03:00'),
(6, 'ofofonobs@gmail.com', 1, NULL, 990, 'Crypto Withdrawal', 'debit', '6505604cf184b', NULL, 'completed', '2023-09-08 03:33:00'),
(7, 'ofofonobs@gmail.com', 5, NULL, 76, 'Crypto Withdrawal', 'debit', '6505606c38959', NULL, 'completed', '2023-09-15 08:08:00'),
(8, 'mantiger146@gmail.com', 1, 'bc1qm44r2jsfajhnxr2ugm5zg3pymwe5lm43l2zm47', 1000, 'Crypto Deposit', 'credit', '6505d33fc6e46', '1694880575Screenshot 2022-06-28 at 03.58.03.png', 'completed', '2023-09-16 12:09:35'),
(9, 'arnolerato47@gmail.com', 5, '0x9C286Ff1edCfB6200a7640B8913af0Ea5E067c4E', 2000, 'Crypto Deposit', 'credit', '6509750175dc3', '1695118593IMG-20230919-WA0005.jpg', 'processing', '2023-09-19 06:16:33'),
(10, 'arnolerato47@gmail.com', 5, '0x9C286Ff1edCfB6200a7640B8913af0Ea5E067c4E', 2000, 'Crypto Deposit', 'credit', '6509751c36843', '1695118620IMG-20230919-WA0005.jpg', 'processing', '2023-09-19 06:17:00'),
(11, 'arnolerato47@gmail.com', 5, '0x9C286Ff1edCfB6200a7640B8913af0Ea5E067c4E', 2000, 'Crypto Deposit', 'credit', '6509751dd9eea', '1695118621IMG-20230919-WA0005.jpg', 'processing', '2023-09-19 06:17:01'),
(12, 'arnolerato47@gmail.com', 5, '0x9C286Ff1edCfB6200a7640B8913af0Ea5E067c4E', 2000, 'Crypto Deposit', 'credit', '6509751e6689d', '1695118622IMG-20230919-WA0005.jpg', 'processing', '2023-09-19 06:17:02'),
(13, 'arnolerato47@gmail.com', 5, '0x9C286Ff1edCfB6200a7640B8913af0Ea5E067c4E', 2000, 'Crypto Deposit', 'credit', '6509751e97e8d', '1695118622IMG-20230919-WA0005.jpg', 'processing', '2023-09-19 06:17:02'),
(14, 'arnolerato47@gmail.com', 5, '0x9C286Ff1edCfB6200a7640B8913af0Ea5E067c4E', 2000, 'Crypto Deposit', 'credit', '6509751e9d923', '1695118622IMG-20230919-WA0005.jpg', 'processing', '2023-09-19 06:17:02'),
(15, 'arnolerato47@gmail.com', 5, '0x9C286Ff1edCfB6200a7640B8913af0Ea5E067c4E', 2000, 'Crypto Deposit', 'credit', '650975239052d', '1695118627IMG-20230919-WA0005.jpg', 'completed', '2023-09-19 06:17:07'),
(16, 'arnolerato47@gmail.com', 5, '0x9C286Ff1edCfB6200a7640B8913af0Ea5E067c4E', 2000, 'Crypto Deposit', 'credit', '65097523ac764', '1695118627IMG-20230919-WA0005.jpg', 'completed', '2023-09-19 06:17:07'),
(17, 'arnolerato47@gmail.com', 6, '0x6ce649128d850d5b530ec602d7a94a5a18fc046c', 1000000, 'Crypto Deposit', 'credit', '65097e8a9271d', '1695121034IMG-20230919-WA0003.jpg', 'completed', '2023-09-19 06:57:14'),
(18, 'mantiger146@gmail.com', 1, '0x6ce649128d850d5b530ec602d7a94a5a18fc046c', 500, 'Crypto Withdrawal', 'debit', '6509892a98bab', NULL, 'completed', '2023-09-19 07:42:34'),
(19, 'mantiger146@gmail.com', 1, '0x6ce649128d850d5b530ec602d7a94a5a18fc046c', 500, 'Crypto Withdrawal', 'debit', '6509892acce41', NULL, 'completed', '2023-09-19 07:42:34'),
(20, 'mantiger146@gmail.com', 5, '0x9C286Ff1edCfB6200a7640B8913af0Ea5E067c4E', 7000000, 'Crypto Deposit', 'credit', '6509896510e1e', '1695123813-2147483648_-210007.jpg', 'failed', '2023-09-19 07:43:33'),
(21, 'mantiger146@gmail.com', 5, '0x9C286Ff1edCfB6200a7640B8913af0Ea5E067c4E', 1000, 'Crypto Deposit', 'credit', '65098b2599ff8', '1695124261IMG_7528.jpeg', 'completed', '2023-09-19 07:51:01'),
(22, 'mantiger146@gmail.com', 6, NULL, 1000, 'Crypto Deposit', 'credit', '65098d5150b71', NULL, 'completed', '2023-09-19 13:00:00'),
(23, 'Nairamateweb@gmail.com', 1, NULL, 2000, 'Crypto Deposit', 'credit', '67cade2a44bbc', NULL, 'completed', '2025-03-07 12:53:00'),
(24, 'Nairamateweb@gmail.com', 1, NULL, 2000, 'Crypto Deposit', 'credit', '67cb18961454a', NULL, 'failed', '2025-03-07 17:02:00'),
(25, 'lmmentertainments@gmail.com', 1, NULL, 500, 'Crypto Deposit', 'credit', '67cb3b0d4e78d', NULL, 'completed', '2025-03-07 18:29:00'),
(26, 'lmmentertainments@gmail.com', 1, '16uZ8uLMrFX2bgE3nc2JtqaejewFnkDfiU', 100, 'Crypto Withdrawal', 'debit', '67cb3b37bff5c', NULL, 'failed', '2025-03-07 19:30:15'),
(27, 'dlpev317@yahoo.com', 1, NULL, 1928066, 'Crypto Deposit', 'credit', '67cc2e8098ae1', NULL, 'completed', '2024-09-05 11:47:00');

--
-- Indexes for table `audit_logs`
--
ALTER TABLE `audit_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crypto_currency`
--
ALTER TABLE `crypto_currency`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ticket`
--
ALTER TABLE `ticket`
  ADD PRIMARY KEY (`ticket_id`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`trans_id`);

--
-- AUTO_INCREMENT for table `audit_logs`
--
ALTER TABLE `audit_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=59;

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

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `trans_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;
COMMIT;

