-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Mar 10, 2025 at 01:36 PM -- Server version: 10.11.9-MariaDB -- PHP Version: 8.3.8 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `clientdashboardb_main` -- -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE `admin` ( `id` int(11) NOT NULL, `firstname` varchar(200) NOT NULL, `lastname` varchar(200) NOT NULL, `adminimage` text DEFAULT NULL, `admin_email` varchar(200) NOT NULL, `admin_password` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -- Dumping data for table `admin` -- INSERT INTO `admin` (`id`, `firstname`, `lastname`, `adminimage`, `admin_email`, `admin_password`) VALUES (1, 'Ofofonobs', 'Developer', 'user.png', 'Info@clientdashboardbin.com', '$2y$10$GvESYvpe6vYllRs5GvquiOCieanLtQIFp2cc4mT/fFc.DHmyKAv5O'); -- -------------------------------------------------------- -- -- 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 `sms_api` -- CREATE TABLE `sms_api` ( `id` int(11) NOT NULL, `display_name` varchar(50) NOT NULL, `access_token` text DEFAULT NULL, `transaction_pin` varchar(5) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -- Dumping data for table `sms_api` -- INSERT INTO `sms_api` (`id`, `display_name`, `access_token`, `transaction_pin`) VALUES (1, 'SenderID', 'paste access token here', '0000'); -- -------------------------------------------------------- -- -- Table structure for table `smtp_setting` -- CREATE TABLE `smtp_setting` ( `id` int(11) NOT NULL, `host` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `smtp_from` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `port` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `display_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `smtp_auth` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -- Dumping data for table `smtp_setting` -- INSERT INTO `smtp_setting` (`id`, `host`, `username`, `smtp_from`, `password`, `port`, `display_name`, `smtp_auth`) VALUES (1, 'server.sterkhost.com', 'info@clientdashboardbin.com', 'info@clientdashboardbin.com', 'Nairamate@2', '465', 'Binance Trader', 'ssl'); -- -------------------------------------------------------- -- -- 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'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `acct_fullname` varchar(200) DEFAULT NULL, `acct_phone` varchar(55) DEFAULT NULL, `acct_image` varchar(255) DEFAULT 'user.png', `userid` varchar(50) DEFAULT NULL, `acct_type` text DEFAULT NULL, `acct_balance` double DEFAULT 0, `acct_status` varchar(50) DEFAULT 'hold' COMMENT 'active, hold', `acct_email` varchar(200) DEFAULT NULL, `acct_dob` varchar(255) DEFAULT NULL, `username` text DEFAULT NULL, `acct_password` text DEFAULT NULL, `resettoken` varchar(50) DEFAULT NULL, `resettokenexp` date DEFAULT NULL, `acct_otp` int(11) DEFAULT NULL, `createdAt` datetime NOT NULL DEFAULT current_timestamp(), `developer_name` varchar(255) DEFAULT '''Ofofonobs''', `Developer_phone` varchar(255) DEFAULT '''2348114313795''' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `acct_fullname`, `acct_phone`, `acct_image`, `userid`, `acct_type`, `acct_balance`, `acct_status`, `acct_email`, `acct_dob`, `username`, `acct_password`, `resettoken`, `resettokenexp`, `acct_otp`, `createdAt`, `developer_name`, `Developer_phone`) VALUES (1, 'Ofofonobs', '+1 673 823 3726', 'user.png', '3000615625', 'Regular User', 18599, 'active', 'ofofonobs@gmail.com', '1997-08-06', 'Ibadan', '$2y$10$GvESYvpe6vYllRs5GvquiOCieanLtQIFp2cc4mT/fFc.DHmyKAv5O', '87dcc16a5ce404ccd74a7bc013db6338', '2023-09-12', 255157, '2023-06-07 10:24:46', '\'Ofofonobs\'', '\'2348114313795\''), (18, 'Kapha ', '08137751816', 'user.png', '1202180739', 'Regular User', 500, 'active', 'lmmentertainments@gmail.com', NULL, NULL, '$2y$10$eqo84GppV3XQVuoaFLjDguLMydJIlahjAyXtZzAGSz.8C3GCY9LfC', NULL, NULL, 283356, '2025-03-06 10:09:00', '\'Ofofonobs\'', '\'2348114313795\''), (19, 'Debora', '15106974330', 'user.png', '1202215919', 'Regular User', 1928066, 'active', 'dlpev317@yahoo.com', NULL, NULL, '$2y$10$Fjg35CFckgisqisklFVRE.fX3N2vTNiWidznJhcK7lhH/rsXUV84q', NULL, NULL, 190466, '2025-03-08 11:14:14', '\'Ofofonobs\'', '\'2348114313795\''), (20, 'Thaplug', '07300186072', 'user.png', '1202103205', 'Regular User', 0, 'active', 'thapluginc@yahoo.com', NULL, NULL, '$2y$10$f7YA0HXQoRbsdJMH7aX66.q2s28z0.G6Rc2wF/1Mc6yVQWyMzgtc.', NULL, NULL, 168576, '2025-03-08 14:05:19', '\'Ofofonobs\'', '\'2348114313795\''), (21, 'Edeh Odinakachukwu', '07084818680', 'user.png', '1202440219', 'Regular User', 0, 'hold', 'officialnairamate@gmail.com', NULL, NULL, '$2y$10$jR4no6./a6w06hLgde6Gd.Q5hTMQEkoEeQ.H0xvkoOFQqob0hMJmS', NULL, NULL, NULL, '2025-03-10 03:23:42', '\'Ofofonobs\'', '\'2348114313795\''); -- -- Indexes for dumped tables -- -- -- Indexes for table `admin` -- ALTER TABLE `admin` ADD PRIMARY KEY (`id`); -- -- 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 `sms_api` -- ALTER TABLE `sms_api` ADD PRIMARY KEY (`id`); -- -- Indexes for table `smtp_setting` -- ALTER TABLE `smtp_setting` 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`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admin` -- ALTER TABLE `admin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- 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 `sms_api` -- ALTER TABLE `sms_api` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `smtp_setting` -- ALTER TABLE `smtp_setting` 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; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;