-- phpMyAdmin SQL Dump -- version 4.9.7 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Sep 06, 2022 at 12:44 PM -- Server version: 10.3.35-MariaDB-log-cll-lve -- PHP Version: 7.4.30 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: `homewydm_archdb` -- -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE `admin` ( `id` int(11) NOT NULL, `firstname` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `lastname` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `image` text COLLATE utf8_unicode_ci DEFAULT NULL, `admin_email` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `admin_password` varchar(200) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `admin` -- INSERT INTO `admin` (`id`, `firstname`, `lastname`, `image`, `admin_email`, `admin_password`) VALUES (1, '', 'Admin', 'jamesavatar.png', 'admin@mail.com', 'NmTd92xIhFa4.'); -- -------------------------------------------------------- -- -- Table structure for table `audit_logs` -- CREATE TABLE `audit_logs` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `device` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `ipAddress` varchar(200) CHARACTER SET utf8 COLLATE utf8_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_id`, `device`, `ipAddress`, `datenow`) VALUES (1, 1, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.5060.134 Safari/537.36 OPR/89.0.4447.83', '5.157.22.2', '2022-08-26 15:26:04'), (2, 2, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36', '102.89.32.27', '2022-08-26 16:22:23'), (3, 3, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.5060.134 Safari/537.36 OPR/89.0.4447.83', '82.165.110.171', '2022-08-26 16:30:45'), (4, 3, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.5060.134 Safari/537.36 OPR/89.0.4447.83', '82.165.110.171', '2022-08-26 16:31:34'), (5, 3, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.5060.134 Safari/537.36 OPR/89.0.4447.83', '82.165.110.171', '2022-08-26 16:33:02'), (6, 3, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.5060.134 Safari/537.36 OPR/89.0.4447.83', '82.165.110.171', '2022-08-26 16:34:27'), (7, 3, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.5060.134 Safari/537.36 OPR/89.0.4447.83', '82.165.110.171', '2022-08-26 16:35:22'), (8, 3, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.5060.134 Safari/537.36 OPR/89.0.4447.83', '82.165.110.171', '2022-08-26 16:37:32'), (9, 3, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:104.0) Gecko/20100101 Firefox/104.0', '82.165.110.171', '2022-08-26 16:39:11'), (10, 3, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:104.0) Gecko/20100101 Firefox/104.0', '82.165.110.171', '2022-08-26 16:40:24'), (11, 3, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:104.0) Gecko/20100101 Firefox/104.0', '82.165.110.171', '2022-08-26 16:41:31'), (12, 3, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:104.0) Gecko/20100101 Firefox/104.0', '82.165.110.171', '2022-08-26 16:42:51'), (13, 3, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:104.0) Gecko/20100101 Firefox/104.0', '105.112.123.64', '2022-08-26 16:52:05'), (14, 3, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:104.0) Gecko/20100101 Firefox/104.0', '82.165.110.171', '2022-08-26 17:57:55'), (15, 3, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:104.0) Gecko/20100101 Firefox/104.0', '82.165.110.171', '2022-08-26 17:58:52'), (16, 3, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:104.0) Gecko/20100101 Firefox/104.0', '82.165.110.171', '2022-08-26 17:59:41'), (17, 3, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:104.0) Gecko/20100101 Firefox/104.0', '82.165.110.171', '2022-08-26 18:00:50'), (18, 3, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:104.0) Gecko/20100101 Firefox/104.0', '105.112.123.64', '2022-08-26 18:03:28'), (19, 3, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:104.0) Gecko/20100101 Firefox/104.0', '105.112.217.52', '2022-08-26 19:33:45'), (20, 3, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:104.0) Gecko/20100101 Firefox/104.0', '105.112.209.59', '2022-08-27 04:37:58'), (21, 2, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36', '197.210.71.142', '2022-08-27 07:18:30'), (22, 5, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.5112.102 Safari/537.36 OPR/90.0.4480.54', '5.104.107.121', '2022-08-30 16:17:55'), (23, 5, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.5112.102 Safari/537.36 OPR/90.0.4480.54', '5.104.107.121', '2022-08-31 03:38:13'), (24, 6, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:103.0) Gecko/20100101 Firefox/103.0', '5.104.107.121', '2022-08-31 13:52:06'), (25, 8, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:103.0) Gecko/20100101 Firefox/103.0', '5.104.107.121', '2022-09-03 16:30:17'), (26, 8, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:104.0) Gecko/20100101 Firefox/104.0', '5.104.107.121', '2022-09-04 00:23:15'), (27, 8, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36 Edg/105.0.1343.25', '5.104.107.121', '2022-09-04 00:54:22'), (28, 8, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36 Edg/105.0.1343.25', '5.104.107.121', '2022-09-05 22:43:21'), (29, 9, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36', '94.46.220.97', '2022-09-06 12:12:26'), (30, 5, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:104.0) Gecko/20100101 Firefox/104.0', '105.112.121.224', '2022-09-06 13:03:25'), (31, 5, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.5112.102 Safari/537.36 OPR/90.0.4480.54', '105.112.121.224', '2022-09-06 13:57:14'), (32, 9, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36', '78.110.173.152', '2022-09-06 13:58:22'), (33, 9, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36', '78.110.173.152', '2022-09-06 14:53:27'), (34, 9, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36', '78.110.173.152', '2022-09-06 16:10:10'); -- -------------------------------------------------------- -- -- Table structure for table `card` -- CREATE TABLE `card` ( `id` int(11) NOT NULL, `seria_key` text COLLATE utf8_unicode_ci NOT NULL, `user_id` int(11) NOT NULL, `card_number` text COLLATE utf8_unicode_ci NOT NULL, `card_name` text COLLATE utf8_unicode_ci NOT NULL, `card_expiration` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `card_security` text COLLATE utf8_unicode_ci NOT NULL, `card_limit` double NOT NULL DEFAULT 5000, `card_limit_remain` double NOT NULL DEFAULT 5000, `card_status` int(11) NOT NULL DEFAULT 2 COMMENT '1=Active,2=Process,3=hold, 4=PAUSE', `createdAt` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `card` -- INSERT INTO `card` (`id`, `seria_key`, `user_id`, `card_number`, `card_name`, `card_expiration`, `card_security`, `card_limit`, `card_limit_remain`, `card_status`, `createdAt`) VALUES (1, 'CARD6308fc244e565', 2, '5295 4946 3216 5715', 'Nicholas C. Parker', '07/26', '897', 5000, 5000, 2, '2022-08-26 22:30:20'), (2, 'CARD63173988b6064', 9, '3094 475723 3602', 'aidlov biola', '07/26', '897', 5000, 5000, 2, '2022-09-06 08:14:00'); -- -------------------------------------------------------- -- -- Table structure for table `card_request` -- CREATE TABLE `card_request` ( `id` int(11) NOT NULL, `reference_id` text COLLATE utf8_unicode_ci NOT NULL, `user_id` int(11) NOT NULL, `card_type` text COLLATE utf8_unicode_ci NOT NULL, `card_reason` text COLLATE utf8_unicode_ci NOT NULL, `card_request_status` int(11) NOT NULL DEFAULT 2, `createdAt` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `crypto_currency` -- CREATE TABLE `crypto_currency` ( `id` int(11) NOT NULL, `crypto_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `wallet_address` text COLLATE utf8_unicode_ci NOT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `crypto_currency` -- INSERT INTO `crypto_currency` (`id`, `crypto_name`, `wallet_address`, `created_at`) VALUES (1, 'Bitcoin', '1E977gLAfCWSE1CXbgEtgGADA7UqmktSAc', '2021-10-08 11:05:42'), (43, 'Dogecoin', '1E977gLAfCWSE1CXbgEtgGADA7UqmktSAc', '2021-11-01 15:39:41'), (46, 'Paxful Wallet', '1E977gLAfCWSE1CXbgEtgGADA7UqmktSAc', '2021-11-03 10:59:51'), (47, 'Paypal', 'support@xyz.com', '2021-11-11 13:26:42'); -- -------------------------------------------------------- -- -- Table structure for table `deposit` -- CREATE TABLE `deposit` ( `d_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `refrence_id` text COLLATE utf8_unicode_ci NOT NULL, `image` text COLLATE utf8_unicode_ci DEFAULT NULL, `amount` double NOT NULL, `wallet_address` text COLLATE utf8_unicode_ci NOT NULL, `crypto_id` int(11) NOT NULL, `crypto_status` int(15) NOT NULL DEFAULT 0, `created_at` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `domestic_transfer` -- CREATE TABLE `domestic_transfer` ( `dom_id` int(11) NOT NULL, `acct_id` int(11) DEFAULT NULL, `refrence_id` text COLLATE utf8_unicode_ci NOT NULL, `amount` double NOT NULL DEFAULT 0, `bank_name` text COLLATE utf8_unicode_ci DEFAULT NULL, `acct_name` text COLLATE utf8_unicode_ci DEFAULT NULL, `acct_number` int(15) NOT NULL, `trans_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'domestic transfer', `acct_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `acct_remarks` text COLLATE utf8_unicode_ci DEFAULT NULL, `dom_status` int(11) NOT NULL DEFAULT 0, `created_at` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `domestic_transfer` -- INSERT INTO `domestic_transfer` (`dom_id`, `acct_id`, `refrence_id`, `amount`, `bank_name`, `acct_name`, `acct_number`, `trans_type`, `acct_type`, `acct_remarks`, `dom_status`, `created_at`) VALUES (11, 5, '630ef519d9049', 120, 'reag', 'fedd', 22222222, 'domestic transfer', 'Domicilary Account', 'ee', 0, '2022-08-31 07:43:53'), (12, 5, '6317461846860', 2000, 'safari', 'dddd', 1234567890, 'domestic transfer', 'Non Resident', 'tg', 0, '2022-09-06 09:07:36'); -- -------------------------------------------------------- -- -- Table structure for table `loan` -- CREATE TABLE `loan` ( `loan_id` int(11) NOT NULL, `loan_reference_id` text COLLATE utf8_unicode_ci DEFAULT NULL, `acct_id` int(11) NOT NULL, `amount` double DEFAULT 0, `loan_remarks` text COLLATE utf8_unicode_ci NOT NULL, `loan_status` int(11) NOT NULL DEFAULT 0, `loan_message` text COLLATE utf8_unicode_ci DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `loan` -- INSERT INTO `loan` (`loan_id`, `loan_reference_id`, `acct_id`, `amount`, `loan_remarks`, `loan_status`, `loan_message`, `created_at`) VALUES (16, '6308f53d71a36', 2, 10000, 'Please \\i need loan', 1, 'Accepted', '2022-08-26 22:00:53'), (17, '6317399e79925', 9, 2000, 'Please \\i need a loan', 0, NULL, '2022-09-06 08:14:22'), (18, '631773b75dad9', 9, 500000, 'Loan requested', 1, 'Loan granted', '2022-09-06 12:22:15'); -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `id` int(11) NOT NULL, `image` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `about_us` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `url_name` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `url_tel` varchar(15) DEFAULT NULL, `url_email` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `trans_limit_min` double DEFAULT NULL, `trans_limit_max` double DEFAULT NULL, `livechat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Live Widget' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `settings` -- INSERT INTO `settings` (`id`, `image`, `about_us`, `url_name`, `url_tel`, `url_email`, `trans_limit_min`, `trans_limit_max`, `livechat`) VALUES (1, 'favicon.png', 'Arch BB International', 'Arch BB', '12677377389', 'info@yomiyomi.xyz', 50, 500000, 'livechat'); -- -------------------------------------------------------- -- -- Table structure for table `temp_trans` -- CREATE TABLE `temp_trans` ( `wire_id` int(11) NOT NULL, `acct_id` int(11) DEFAULT NULL, `trans_id` text COLLATE utf8_unicode_ci NOT NULL, `amount` double NOT NULL DEFAULT 0, `bank_name` text COLLATE utf8_unicode_ci DEFAULT NULL, `acct_name_id` text COLLATE utf8_unicode_ci DEFAULT NULL, `acct_number` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL, `trans_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'wire transfer', `acct_type` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `acct_country` text COLLATE utf8_unicode_ci DEFAULT NULL, `acct_swift` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `acct_routing` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `acct_remarks` text COLLATE utf8_unicode_ci DEFAULT NULL, `wire_status` int(11) NOT NULL DEFAULT 0, `trans_otp` int(11) DEFAULT NULL, `createdAt` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `temp_trans` -- INSERT INTO `temp_trans` (`wire_id`, `acct_id`, `trans_id`, `amount`, `bank_name`, `acct_name_id`, `acct_number`, `trans_type`, `acct_type`, `acct_country`, `acct_swift`, `acct_routing`, `acct_remarks`, `wire_status`, `trans_otp`, `createdAt`) VALUES (1, 2, '6308f5ad72539', 200, 'Barcklays', 'Desmond', '34567234', 'domestic transfer', 'Fixed Deposit', NULL, NULL, NULL, 'Send Money', 0, 174503, '2022-08-26 22:02:45'), (2, 2, '6308f61c44404', 500, 'Barcklays', 'Desmond', '7890435673', 'wire transfer', 'Current', 'American Samoa', '563456', '434566', 'Please send good back', 0, 161446, '2022-08-26 22:04:36'), (3, 2, '6308f80842e76', 1000, 'Barcklays', 'Desmond', '9856743212', 'wire transfer', 'Fixed Deposit', 'American Samoa', '6567', '656777', 'Please transfer', 0, 337079, '2022-08-26 22:12:48'), (4, 3, '63090bf39382c', 100, 'safari', 'john jons', '324532452354', 'domestic transfer', 'Current', NULL, NULL, NULL, 'fees', 0, 121223, '2022-08-26 23:37:47'), (5, 3, '63090bfddb2ee', 100, 'safari', 'john jons', '324532452354', 'domestic transfer', 'Current', NULL, NULL, NULL, 'fees', 0, 272526, '2022-08-26 23:37:57'), (6, 3, '63090c124603e', 300, 'safari', 'john jons', '0016226015', 'domestic transfer', 'Savings', NULL, NULL, NULL, 'fess', 0, 713527, '2022-08-26 23:38:18'), (7, 3, '63090c4b351dd', 1000, 'safari', 'john jons', '1234567890', 'domestic transfer', 'Domicilary Account', NULL, NULL, NULL, 'fess', 0, 293726, '2022-08-26 23:39:15'), (8, 3, '63090c9925c58', 2000, 'safari', 'john jons', '1234567890', 'wire transfer', 'Joint Account', 'Afganistan', '451551345', '135413453145', 'fess', 0, 209670, '2022-08-26 23:40:33'), (9, 3, '630911c2371c6', 300, 'safari', 'john jons', '1234567890', 'wire transfer', 'Domicilary Account', 'Anguilla', '451551345', '32643246245', 'fes', 0, 109710, '2022-08-27 00:02:34'), (10, 3, '630916c17c1bb', 300, 'safari', 'john jons', '1234567890', 'wire transfer', 'Savings', 'Angola', '451551345', '23545234', 'fess', 0, 758646, '2022-08-27 00:23:53'), (11, 3, '630921070df05', 2000, 'safari', 'john jons', '1234567890', 'wire transfer', 'Checking', 'Afganistan', '451551345', '2353245345', 'fess', 0, 265337, '2022-08-27 01:07:43'), (12, 3, '630926f9789bc', 300, 'safari', 'john jons', '0016226015', 'domestic transfer', 'Online Banking', NULL, NULL, NULL, 'fess', 0, 172283, '2022-08-27 01:33:05'), (13, 2, '6309c6329a42c', 1000, 'Barcklays', 'Desmond', '7659876432', 'wire transfer', 'Checking', 'Albania', '7654', '87876', 'approved', 0, 998263, '2022-08-27 12:52:26'), (14, 2, '6309c72e1c5be', 650, 'Barcklays', 'Adislove', '9076543213', 'wire transfer', 'Current', 'Andorra', '4543', '878589', 'approved', 0, 447269, '2022-08-27 12:56:38'), (15, 2, '6309c827385fe', 550, 'Barcklays', 'Desmond', '6784356798', 'wire transfer', 'Online Banking', 'Antigua & Barbuda', '6765', '4565', '9909234058', 0, 153831, '2022-08-27 13:00:47'), (16, 5, '630e54be95a70', 120, 'reag', 'fedd', '2351345413', 'domestic transfer', 'Joint Account', NULL, NULL, NULL, 'd', 0, 189237, '2022-08-30 20:19:42'), (17, 5, '630e54dce7de5', 120, 'reag', 'fedd', '2222222', 'wire transfer', 'Current', 'Afganistan', '5654654', '32534536', 'fdgfg', 0, 249463, '2022-08-30 20:20:12'), (18, 5, '630ef50aa5567', 120, 'reag', 'fedd', '22222222', 'domestic transfer', 'Domicilary Account', NULL, NULL, NULL, 'ee', 0, 105977, '2022-08-31 07:43:38'), (19, 9, '63173a0f902df', 10000, 'UK Clays', 'Ben Uhu', '7678903456', 'wire transfer', 'Current', 'Algeria', '45678', '3244556', 'aCCOUNT FUNDED FOR WAR', 0, 432835, '2022-09-06 08:16:15'), (20, 9, '63173c2d93ffb', 10000, 'UK Clays', 'Ben Uhu', '6784534234', 'wire transfer', 'Savings', 'American Samoa', '45678', '56455666', 'Transfer', 0, 253874, '2022-09-06 08:25:17'), (21, 5, '63174585092ec', 2000, 'safari', 'john jons', '1234567890', 'domestic transfer', 'Online Banking', NULL, NULL, NULL, 'trgh', 0, 218554, '2022-09-06 09:05:09'), (22, 5, '631745ba70ee7', 2000, 'safari', 'john jons', '1234567890', 'domestic transfer', 'Online Banking', NULL, NULL, NULL, 'ff', 0, 123372, '2022-09-06 09:06:02'), (23, 5, '631746036b288', 2000, 'safari', 'dddd', '1234567890', 'domestic transfer', 'Non Resident', NULL, NULL, NULL, 'tg', 0, 139916, '2022-09-06 09:07:15'), (24, 5, '631748a81cd03', 2000, 'safari', 'john jons', '1234567890', 'wire transfer', 'Fixed Deposit', 'Select Country', '451551345', '4567878678', 'gfsdfg', 0, 321538, '2022-09-06 09:18:32'), (25, 9, '631752bb6f5e6', 1000, 'USA DEV', 'Joe', '9087654324', 'wire transfer', 'Savings', 'Andorra', '987654', '908756', 'SENDING', 0, 226847, '2022-09-06 10:01:31'), (26, 9, '6317727738b85', 1000, 'Mega Bank', 'Ben Ugie', '9876589087', 'domestic transfer', 'Checking', NULL, NULL, NULL, 'Money sent', 0, 107434, '2022-09-06 12:16:55'), (27, 9, '631772f3173b3', 1000, 'Mega Bank', 'Ben Ugie', '45345678', 'wire transfer', 'Savings', 'Albania', '54676', '454455', 'Transfer', 0, 317634, '2022-09-06 12:18:59'); -- -------------------------------------------------------- -- -- Table structure for table `transactions` -- CREATE TABLE `transactions` ( `trans_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `refrence_id` text COLLATE utf8_unicode_ci NOT NULL, `amount` double NOT NULL, `trans_type` int(15) NOT NULL, `sender_name` text COLLATE utf8_unicode_ci NOT NULL, `description` text COLLATE utf8_unicode_ci NOT NULL, `trans_status` int(11) NOT NULL DEFAULT 0, `created_at` text COLLATE utf8_unicode_ci NOT NULL, `time_created` text COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `transactions` -- INSERT INTO `transactions` (`trans_id`, `user_id`, `refrence_id`, `amount`, `trans_type`, `sender_name`, `description`, `trans_status`, `created_at`, `time_created`) VALUES (1, 2, '6308f3c80dee6', 20000, 1, 'Parkers Company', 'Paid For The Contract', 0, '2020-12-12', '01:22'), (9, 9, '63175fa00931d', 30000, 1, 'Benjamin', 'Transfered', 1, '2022-12-02', '00:00'), (10, 9, '6317714d7a26f', 30000, 2, 'Paid', 'paid', 1, '2022-12-12', '00:11'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `acct_username` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `firstname` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL, `lastname` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL, `image` text COLLATE utf8_unicode_ci DEFAULT NULL, `acct_no` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `billing_code` int(11) NOT NULL DEFAULT 0 COMMENT '0=deactive,1=active', `acct_balance` double DEFAULT 0, `loan_balance` double DEFAULT 0, `acct_limit` double DEFAULT NULL, `limit_remain` double DEFAULT NULL, `acct_type` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL, `acct_gender` text COLLATE utf8_unicode_ci DEFAULT NULL, `marital_status` text COLLATE utf8_unicode_ci DEFAULT NULL, `acct_currency` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `acct_status` varchar(50) COLLATE utf8_unicode_ci DEFAULT 'active' COMMENT 'active, hold', `acct_email` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL, `acct_phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `acct_occupation` text COLLATE utf8_unicode_ci DEFAULT NULL, `acct_dob` text COLLATE utf8_unicode_ci DEFAULT NULL, `ssn` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL, `frontID` text COLLATE utf8_unicode_ci DEFAULT NULL, `backID` text COLLATE utf8_unicode_ci DEFAULT NULL, `country` text COLLATE utf8_unicode_ci DEFAULT NULL, `state` text COLLATE utf8_unicode_ci DEFAULT NULL, `acct_password` text COLLATE utf8_unicode_ci DEFAULT NULL, `acct_pin` varchar(4) COLLATE utf8_unicode_ci DEFAULT NULL, `acct_otp` int(11) DEFAULT NULL, `acct_cot` varchar(15) COLLATE utf8_unicode_ci NOT NULL, `acct_imf` varchar(15) COLLATE utf8_unicode_ci NOT NULL, `acct_tax` varchar(15) COLLATE utf8_unicode_ci NOT NULL, `mgr_name` text COLLATE utf8_unicode_ci NOT NULL, `mgr_no` text COLLATE utf8_unicode_ci NOT NULL, `mgr_email` text COLLATE utf8_unicode_ci NOT NULL, `mgr_id` text COLLATE utf8_unicode_ci NOT NULL, `mgr_image` text COLLATE utf8_unicode_ci DEFAULT NULL, `acct_address` text COLLATE utf8_unicode_ci DEFAULT NULL, `createdAt` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `acct_username`, `firstname`, `lastname`, `image`, `acct_no`, `billing_code`, `acct_balance`, `loan_balance`, `acct_limit`, `limit_remain`, `acct_type`, `acct_gender`, `marital_status`, `acct_currency`, `acct_status`, `acct_email`, `acct_phone`, `acct_occupation`, `acct_dob`, `ssn`, `frontID`, `backID`, `country`, `state`, `acct_password`, `acct_pin`, `acct_otp`, `acct_cot`, `acct_imf`, `acct_tax`, `mgr_name`, `mgr_no`, `mgr_email`, `mgr_id`, `mgr_image`, `acct_address`, `createdAt`) VALUES (5, 'bryte', 'bryte', 'david', '1661883382favicon.png', '123456789', 0, 19999997760, 0, NULL, -2240, 'Savings', 'male', NULL, 'USD', 'active', 'brytedree@gmail.com', '24387906453', 'miner', '2022-08-09', '12345678', '1661883382favicon.png', '1661883382favicon.png', 'Bangladesh', 'New york', '$2y$10$R01tHtUBSJ3z4UhMUcg9n.D0cxT3iANXz2RIURHkjzJMi6ePhSVeG', '1234', 179475, '', '', '', '', '', '', '', NULL, 'queens 34 California New york 3245324', '2022-08-30 20:16:22'), (7, 'Attwillant', 'leo', 'yhi', '1661960865IMG_2794.webp', '9909898212', 0, 0, 0, NULL, NULL, 'Savings', 'male', NULL, 'USD', 'hold', 'att.willlant@gmail.com', '9297387280', 'Driver ', '1985-04-06', '1234567', '16619608656c60fc1e7ace8ec80f659ff649167649.jpg', '16619608650db5c76c79fd85aeb1c8d4c2b66796d8.jpg', 'United States of America', 'New York', '$2y$10$XeWU7FJEiKs0RrMaix78eO19CTpSgCpK5bDrls5kpfF.iu2ufaD46', '1234', NULL, '', '', '', '', '', '', '', NULL, 'Rss 13 unit 4 87391 Buffalo New York 14209', '2022-08-31 17:47:45'), (9, 'adislove', 'aidlov', 'biola', '1662466112woo.jpg', '9909153589', 1, 29000, 500000, 0, -2000, 'Savings', 'female', 'single', 'USD', 'active', 'gseun129@gmail.com', '67363663633', 'Business ', '1986-02-12', '11111111', '1662466112woo.jpg', '1662466112large_banxxe.png', 'United Kingdom', 'UK', '$2y$10$VxAVZMz95XpbuhW/eviQuufw0Wt.l1LfvQeCDbzdXfCCOoX1PjWpe', '1111', 257993, '1111', '1111', '1111', '', '', '', '', NULL, 'Tech Guru Avenu 3455 UK UK 546788', '2022-09-06 08:08:32'); -- -------------------------------------------------------- -- -- Table structure for table `virtual` -- CREATE TABLE `virtual` ( `id` int(11) NOT NULL, `bank_name` text COLLATE utf8_unicode_ci NOT NULL, `routine_no` text COLLATE utf8_unicode_ci NOT NULL, `acct_no` text COLLATE utf8_unicode_ci NOT NULL, `swift_code` text COLLATE utf8_unicode_ci NOT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `virtual` -- INSERT INTO `virtual` (`id`, `bank_name`, `routine_no`, `acct_no`, `swift_code`, `created_at`) VALUES (1, 'Arch BB', '637363636', '7642292324', 'SFDHHS86X', '2021-10-08 11:05:42'); -- -------------------------------------------------------- -- -- Table structure for table `wire_transfer` -- CREATE TABLE `wire_transfer` ( `wire_id` int(11) NOT NULL, `acct_id` int(11) NOT NULL, `refrence_id` text COLLATE utf8_unicode_ci NOT NULL, `amount` double NOT NULL DEFAULT 0, `bank_name` text COLLATE utf8_unicode_ci DEFAULT NULL, `acct_name` text COLLATE utf8_unicode_ci DEFAULT NULL, `acct_number` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `trans_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'wire transfer', `acct_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `acct_country` text COLLATE utf8_unicode_ci DEFAULT NULL, `acct_swift` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `acct_routing` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `acct_remarks` text COLLATE utf8_unicode_ci DEFAULT NULL, `wire_status` int(11) NOT NULL DEFAULT 0, `created_at` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `wire_transfer` -- INSERT INTO `wire_transfer` (`wire_id`, `acct_id`, `refrence_id`, `amount`, `bank_name`, `acct_name`, `acct_number`, `trans_type`, `acct_type`, `acct_country`, `acct_swift`, `acct_routing`, `acct_remarks`, `wire_status`, `created_at`) VALUES (4, 5, '630e54f927a6e', 120, 'reag', 'fedd', '2222222', 'wire transfer', 'Current', 'Afganistan', '5654654', '32534536', 'fdgfg', 1, '2022-08-30 20:20:41'), (6, 9, '6317731bf0147', 1000, 'Mega Bank', 'Ben Ugie', '45345678', 'wire transfer', 'Savings', 'Albania', '54676', '454455', 'Transfer', 1, '2022-09-06 12:19:39'); -- -------------------------------------------------------- -- -- Table structure for table `withdrawal` -- CREATE TABLE `withdrawal` ( `id` int(11) NOT NULL, `reference_id` varchar(200) NOT NULL, `user_id` int(11) NOT NULL, `amount` float NOT NULL, `withdraw_method` varchar(200) NOT NULL, `wallet_address` text NOT NULL, `status` int(11) NOT NULL DEFAULT 0, `createdAt` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- 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 `card` -- ALTER TABLE `card` ADD PRIMARY KEY (`id`); -- -- Indexes for table `card_request` -- ALTER TABLE `card_request` ADD PRIMARY KEY (`id`); -- -- Indexes for table `crypto_currency` -- ALTER TABLE `crypto_currency` ADD PRIMARY KEY (`id`); -- -- Indexes for table `deposit` -- ALTER TABLE `deposit` ADD PRIMARY KEY (`d_id`); -- -- Indexes for table `domestic_transfer` -- ALTER TABLE `domestic_transfer` ADD PRIMARY KEY (`dom_id`); -- -- Indexes for table `loan` -- ALTER TABLE `loan` ADD PRIMARY KEY (`loan_id`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `temp_trans` -- ALTER TABLE `temp_trans` ADD PRIMARY KEY (`wire_id`); -- -- Indexes for table `transactions` -- ALTER TABLE `transactions` ADD PRIMARY KEY (`trans_id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `virtual` -- ALTER TABLE `virtual` ADD PRIMARY KEY (`id`); -- -- Indexes for table `wire_transfer` -- ALTER TABLE `wire_transfer` ADD PRIMARY KEY (`wire_id`); -- -- Indexes for table `withdrawal` -- ALTER TABLE `withdrawal` 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=3; -- -- AUTO_INCREMENT for table `audit_logs` -- ALTER TABLE `audit_logs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35; -- -- AUTO_INCREMENT for table `card` -- ALTER TABLE `card` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `card_request` -- ALTER TABLE `card_request` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `crypto_currency` -- ALTER TABLE `crypto_currency` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48; -- -- AUTO_INCREMENT for table `deposit` -- ALTER TABLE `deposit` MODIFY `d_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `domestic_transfer` -- ALTER TABLE `domestic_transfer` MODIFY `dom_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `loan` -- ALTER TABLE `loan` MODIFY `loan_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19; -- -- AUTO_INCREMENT for table `settings` -- ALTER TABLE `settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `temp_trans` -- ALTER TABLE `temp_trans` MODIFY `wire_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28; -- -- AUTO_INCREMENT for table `transactions` -- ALTER TABLE `transactions` MODIFY `trans_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `virtual` -- ALTER TABLE `virtual` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48; -- -- AUTO_INCREMENT for table `wire_transfer` -- ALTER TABLE `wire_transfer` MODIFY `wire_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; 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 */;