-- phpMyAdmin SQL Dump
-- version 4.9.11
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Sep 20, 2023 at 02:02 AM
-- Server version: 8.0.34-cll-lve
-- PHP Version: 7.4.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `cnbgncst_ABa`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int NOT NULL,
  `firstname` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `lastname` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `adminimage` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `admin_email` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `admin_password` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci 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', 'support@dirtyscripts.shop', '$2y$10$GvESYvpe6vYllRs5GvquiOCieanLtQIFp2cc4mT/fFc.DHmyKAv5O');

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

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

CREATE TABLE `audit_logs` (
  `id` int NOT NULL,
  `user_email` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci 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;

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

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

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

CREATE TABLE `crypto_currency` (
  `id` int NOT NULL,
  `crypto_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `short_name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `wallet_address` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci 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 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 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;

--
-- 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 OTC', '2348114313795', 'support@dirtyscripts.shop', '', 0, 'logo.png', '$', '2023-03-28 14:51:33');

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

--
-- Table structure for table `sms_api`
--

CREATE TABLE `sms_api` (
  `id` int NOT NULL,
  `display_name` varchar(50) NOT NULL,
  `access_token` text,
  `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 NOT NULL,
  `host` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `username` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `smtp_from` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `port` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `display_name` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `smtp_auth` varchar(50) 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, 'mail.sporespad.com', 'support@sporespad.com', 'support@sporespad.com', 'XBn235j2zt68Hjsh', '465', 'Binance OTC', 'ssl');

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

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

CREATE TABLE `ticket` (
  `ticket_id` int 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 NOT NULL,
  `acct_email` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `crypto_id` int DEFAULT NULL,
  `wallet_address` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `amount` double NOT NULL,
  `trans_type` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `transaction_type` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `refrence_id` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `image` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `trans_status` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci 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', 'processing', '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', 'completed', '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');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int NOT NULL,
  `acct_fullname` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_phone` varchar(55) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_image` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT 'user.png',
  `userid` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_type` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `acct_balance` double DEFAULT '0',
  `acct_status` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT 'hold' COMMENT 'active, hold',
  `acct_email` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_dob` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `acct_country` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `acct_password` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `resettoken` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `resettokenexp` date DEFAULT NULL,
  `acct_otp` int DEFAULT NULL,
  `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `developer_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT '''Ofofonobs''',
  `Developer_phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci 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`, `acct_country`, `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\''),
(6, 'Man tiger', NULL, 'user.png', '1202292094', 'Regular User', 7002000, 'active', 'mantiger146@gmail.com', NULL, NULL, '$2y$10$nbVMjtlNYyb/Zn.Jln/cW.Cv62BUt7W7xwvWSbX1PKXMcEZDkN/OS', NULL, NULL, 132048, '2023-09-14 09:02:23', '\'Ofofonobs\'', '\'2348114313795\''),
(12, 'Ave', '1745886494', 'user.png', '1202322232', 'Regular User', 1002000, 'active', 'arnolerato47@gmail.com', NULL, NULL, '$2y$10$NuUY9A6NcwfP8azMZhGV.OFlY3IjoZP5dbnPHRwq37du5UQkP3W96', NULL, NULL, 133539, '2023-09-19 06:08:32', '\'Ofofonobs\'', '\'2348114313795\''),
(13, 'Amelia aiden', '174562358', 'user.png', '1202323598', 'Regular User', 0, 'hold', 'sammeqassem469@gmail.com', NULL, NULL, '$2y$10$qS3fgXmDkn8lm99dtsUhsev7yWIke3c.UZ7tOkGCwyPRMe3HX2pku', NULL, NULL, NULL, '2023-09-19 06:40:30', '\'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 NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `audit_logs`
--
ALTER TABLE `audit_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

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

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

--
-- AUTO_INCREMENT for table `sms_api`
--
ALTER TABLE `sms_api`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `smtp_setting`
--
ALTER TABLE `smtp_setting`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `trans_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
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 */;
