-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Feb 06, 2025 at 12:48 AM -- Server version: 10.6.21-MariaDB -- PHP Version: 8.3.15 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: `westamarica_west` -- -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE `admin` ( `id` int(11) NOT NULL, `firstname` varchar(200) NOT NULL, `lastname` varchar(200) NOT NULL, `image` 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`, `image`, `admin_email`, `admin_password`) VALUES (1, '', 'Admin', 'qm2eo6qvlot51 copy.jpg', 'support@westamericafinance.com', '$2y$10$Lx9cYeDKeOT8AvYM./CgPeEEMnBKFSP1jD.S12Rdn7Rnj3Xhx8EpG'); -- -------------------------------------------------------- -- -- 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 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_id`, `device`, `ipAddress`, `datenow`) VALUES (1, 107, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36', '51.89.220.49', '2024-06-09 22:47:23'), (2, 108, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_8 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.6 Mobile/15E148 Safari/604.1', '173.239.211.224', '2024-06-09 23:28:39'), (3, 107, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Mobile Safari/537.36', '138.94.168.192', '2024-06-10 10:35:31'), (4, 107, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Mobile Safari/537.36', '138.94.168.192', '2024-06-10 20:34:29'), (5, 107, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Mobile Safari/537.36', '45.71.210.146', '2024-06-11 14:19:22'), (6, 107, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Mobile Safari/537.36', '45.71.210.146', '2024-06-11 14:56:56'), (7, 107, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Mobile Safari/537.36', '45.71.210.146', '2024-06-11 15:00:42'), (8, 107, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Mobile Safari/537.36', '45.71.210.146', '2024-06-11 15:58:37'), (9, 107, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Mobile Safari/537.36', '45.71.210.146', '2024-06-11 21:51:26'), (10, 107, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Mobile Safari/537.36', '45.71.210.146', '2024-06-11 22:22:55'), (11, 107, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Mobile Safari/537.36', '45.71.210.146', '2024-06-12 00:04:17'), (12, 107, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Mobile Safari/537.36', '45.71.210.146', '2024-06-12 10:12:42'), (13, 107, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Mobile Safari/537.36', '45.71.210.146', '2024-06-12 11:52:14'), (14, 108, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_8 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.6 Mobile/15E148 Safari/604.1', '103.163.220.31', '2024-06-12 13:43:32'), (15, 107, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Mobile Safari/537.36', '45.71.210.146', '2024-06-12 14:12:36'), (16, 107, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Mobile Safari/537.36', '45.181.39.10', '2024-06-12 16:28:44'), (17, 107, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Mobile Safari/537.36', '45.181.39.10', '2024-06-12 19:41:58'), (18, 107, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Mobile Safari/537.36', '45.181.39.10', '2024-06-12 21:42:51'), (19, 107, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Mobile Safari/537.36', '45.181.39.10', '2024-06-12 23:23:55'), (20, 107, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Mobile Safari/537.36', '45.181.39.10', '2024-06-13 09:49:32'), (21, 107, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Mobile Safari/537.36', '45.181.39.10', '2024-06-13 16:41:17'), (22, 107, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Mobile Safari/537.36', '45.181.39.10', '2024-06-13 16:43:00'), (23, 107, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Mobile Safari/537.36', '45.181.39.10', '2024-06-13 16:43:45'), (24, 107, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Mobile Safari/537.36', '45.181.39.10', '2024-06-13 16:44:22'), (25, 108, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_8_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.6 Mobile/15E148 Safari/604.1', '103.163.220.241', '2024-07-03 00:37:24'), (26, 108, 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/124.0.6367.88 Mobile/15E148 Safari/604.1', '102.89.23.157', '2024-07-04 18:25:40'), (27, 110, 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/124.0.6367.88 Mobile/15E148 Safari/604.1', '102.89.23.162', '2024-07-04 18:43:14'), (28, 110, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.5 Mobile/15E148 Safari/604.1', '105.113.41.126', '2024-07-04 22:13:39'), (29, 111, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/25.0 Chrome/121.0.0.0 Mobile Safari/537.36', '49.178.94.214', '2024-07-26 00:07:55'), (30, 111, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36', '180.150.112.116', '2024-07-26 00:26:00'), (31, 111, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36', '180.150.112.116', '2024-07-26 01:11:38'), (32, 111, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Mobile Safari/537.36', '49.178.94.214', '2024-07-26 08:20:45'), (33, 111, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Mobile Safari/537.36', '49.178.94.214', '2024-07-26 09:14:19'), (34, 111, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Mobile Safari/537.36', '49.178.94.214', '2024-07-26 12:37:05'), (35, 111, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Mobile Safari/537.36', '49.178.94.214', '2024-07-26 12:37:11'), (36, 111, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36', '110.175.115.86', '2024-07-29 04:34:39'), (37, 112, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.5 Mobile/15E148 Safari/604.1', '188.71.222.87', '2024-08-09 16:26:41'), (38, 112, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.5 Mobile/15E148 Safari/604.1', '188.71.222.87', '2024-08-09 16:26:46'), (39, 112, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.5 Mobile/15E148 Safari/604.1', '188.71.222.87', '2024-08-09 16:26:49'), (40, 112, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.5 Mobile/15E148 Safari/604.1', '188.71.222.87', '2024-08-09 16:28:46'), (41, 113, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36', '102.89.23.217', '2024-08-30 13:13:27'), (42, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.6312.118 Mobile Safari/537.36 XiaoMi/MiuiBrowser/14.17.0-gn', '31.221.171.9', '2024-08-31 17:19:37'), (43, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.6312.118 Mobile Safari/537.36 XiaoMi/MiuiBrowser/14.17.0-gn', '31.221.171.9', '2024-08-31 18:25:44'), (44, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.76.100', '2024-09-02 16:32:07'), (45, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.76.111', '2024-09-02 16:49:56'), (46, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.76.111', '2024-09-02 16:52:32'), (47, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.76.111', '2024-09-02 16:54:22'), (48, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.76.111', '2024-09-02 18:03:34'), (49, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.76.111', '2024-09-02 18:03:38'), (50, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.76.111', '2024-09-02 18:26:21'), (51, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.76.111', '2024-09-02 18:26:22'), (52, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.76.154', '2024-09-04 02:56:38'), (53, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.76.154', '2024-09-04 02:56:51'), (54, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.76.154', '2024-09-04 02:56:54'), (55, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.76.154', '2024-09-04 03:13:01'), (56, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.76.154', '2024-09-04 03:13:47'), (57, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.76.154', '2024-09-04 03:13:49'), (58, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.76.154', '2024-09-04 03:14:52'), (59, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.75.237', '2024-09-04 08:05:55'), (60, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.75.237', '2024-09-04 08:06:09'), (61, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.75.237', '2024-09-04 08:06:11'), (62, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.84.54', '2024-09-04 11:48:21'), (63, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.84.54', '2024-09-04 11:48:23'), (64, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.84.54', '2024-09-04 12:13:07'), (65, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.84.54', '2024-09-04 12:13:10'), (66, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.84.243', '2024-09-04 18:39:08'), (67, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.75.219', '2024-09-05 13:08:31'), (68, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.75.219', '2024-09-05 13:08:35'), (69, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.75.219', '2024-09-05 13:08:42'), (70, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.76.224', '2024-09-06 07:50:59'), (71, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.76.224', '2024-09-06 07:52:07'), (72, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.76.224', '2024-09-06 07:52:08'), (73, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.75.30', '2024-09-06 18:38:24'), (74, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.75.30', '2024-09-06 18:38:27'), (75, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.75.30', '2024-09-06 18:38:30'), (76, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.84.178', '2024-09-12 09:27:48'), (77, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.84.178', '2024-09-12 09:27:50'), (78, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.75.237', '2024-09-20 13:36:56'), (79, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.75.237', '2024-09-20 13:36:57'), (80, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36', '91.58.220.140', '2024-09-20 13:37:26'), (81, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.75.237', '2024-09-20 13:47:14'), (82, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.75.237', '2024-09-20 13:47:15'), (83, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.75.237', '2024-09-20 14:36:04'), (84, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36', '131.161.194.144', '2024-09-24 13:17:34'), (85, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36', '131.161.194.144', '2024-09-24 14:13:11'), (86, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36', '131.161.194.144', '2024-09-24 15:10:08'), (87, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36', '131.161.194.144', '2024-09-24 15:31:49'), (88, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36', '131.161.194.144', '2024-09-24 15:41:33'), (89, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36', '187.90.218.166', '2024-09-24 21:43:26'), (90, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36', '200.173.181.145', '2024-09-25 21:10:34'), (91, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.69.245', '2024-09-27 08:45:47'), (92, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.69.245', '2024-09-27 08:45:52'), (93, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.69.245', '2024-09-27 08:49:26'), (94, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.69.245', '2024-09-27 08:49:30'), (95, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.69.245', '2024-09-27 08:52:09'), (96, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36', '102.89.69.245', '2024-09-27 08:52:11'), (97, 116, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_0_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.0.1 Mobile/15E148 Safari/604.1', '105.112.209.159', '2024-09-28 19:37:59'), (98, 116, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_0_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.0.1 Mobile/15E148 Safari/604.1', '23.26.221.88', '2024-09-28 20:00:12'), (99, 116, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_0_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.0.1 Mobile/15E148 Safari/604.1', '23.26.221.88', '2024-09-28 20:00:17'), (100, 116, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_0_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.0.1 Mobile/15E148 Safari/604.1', '23.26.221.88', '2024-09-28 22:41:59'), (101, 116, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_0_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.0.1 Mobile/15E148 Safari/604.1', '23.26.221.88', '2024-09-28 22:42:02'), (102, 116, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_0_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.0.1 Mobile/15E148 Safari/604.1', '105.112.100.130', '2024-09-29 18:13:45'), (103, 116, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_0_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.0.1 Mobile/15E148 Safari/604.1', '105.112.100.130', '2024-09-29 18:13:45'), (104, 116, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_0_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.0.1 Mobile/15E148 Safari/604.1', '105.112.100.130', '2024-09-29 18:13:56'), (105, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Mobile Safari/537.36', '102.89.68.8', '2024-10-07 18:49:10'), (106, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Mobile Safari/537.36', '102.89.69.21', '2024-10-13 08:39:18'), (107, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Mobile Safari/537.36', '102.89.69.21', '2024-10-13 08:39:27'), (108, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Mobile Safari/537.36', '102.89.69.21', '2024-10-13 08:39:36'), (109, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Mobile Safari/537.36', '102.89.69.21', '2024-10-13 08:44:01'), (110, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Mobile Safari/537.36', '102.89.83.14', '2024-10-15 14:42:52'), (111, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Mobile Safari/537.36', '102.89.83.14', '2024-10-15 14:45:04'), (112, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Mobile Safari/537.36', '102.89.83.14', '2024-10-15 14:45:06'), (113, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Mobile Safari/537.36', '102.89.83.14', '2024-10-15 15:28:27'), (114, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Mobile Safari/537.36', '102.89.83.14', '2024-10-15 15:29:38'), (115, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Mobile Safari/537.36', '102.89.68.172', '2024-10-19 20:50:13'), (116, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Mobile Safari/537.36', '102.89.68.172', '2024-10-19 20:50:15'), (117, 117, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_6_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.6 Mobile/15E148 Safari/604.1', '102.90.65.212', '2024-10-24 11:10:57'), (118, 117, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_6_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.6 Mobile/15E148 Safari/604.1', '102.90.65.212', '2024-10-24 11:20:53'), (119, 117, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Mobile Safari/537.36', '102.90.65.212', '2024-10-24 11:28:20'), (120, 117, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36', '78.190.145.59', '2024-10-25 03:37:41'), (121, 117, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36', '78.190.145.59', '2024-10-25 03:37:50'), (122, 117, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36', '78.190.145.59', '2024-10-25 03:37:59'), (123, 117, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36', '78.190.145.59', '2024-10-25 03:38:15'), (124, 108, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', '102.212.163.102', '2024-10-25 05:07:20'), (125, 108, 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.5.2 Mobile/15E148 Safari/604.1', '102.212.163.102', '2024-10-25 05:17:31'), (126, 118, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.4.1 Mobile/15E148 Safari/604.1', '89.41.26.55', '2024-10-30 13:42:11'), (127, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-10-30 16:55:10'), (128, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-10-30 17:01:40'), (129, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-10-30 17:34:37'), (130, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-10-30 17:45:47'), (131, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-10-30 17:45:49'), (132, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-10-30 17:56:22'), (133, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-10-30 17:56:23'), (134, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-10-30 18:21:12'), (135, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-10-30 18:21:14'), (136, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-10-30 18:21:16'), (137, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-10-30 18:21:18'), (138, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-10-30 18:21:19'), (139, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-10-30 19:50:46'), (140, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-10-30 19:50:47'), (141, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-10-30 19:52:39'), (142, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-10-30 19:53:38'), (143, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-10-30 20:18:31'), (144, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-10-30 20:18:53'), (145, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-10-31 06:10:01'), (146, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-10-31 06:10:02'), (147, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-10-31 06:18:50'), (148, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-10-31 11:13:22'), (149, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/26.0 Chrome/122.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-10-31 11:13:23'), (150, 119, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36', '102.91.5.18', '2024-11-10 22:34:19'), (151, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36', '102.89.83.34', '2024-11-12 14:42:01'), (152, 113, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36', '102.89.83.34', '2024-11-12 14:42:09'), (153, 118, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/27.0 Chrome/125.0.0.0 Mobile Safari/537.36', '212.253.215.45', '2024-11-18 12:08:30'), (154, 117, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36', '78.163.150.137', '2024-11-18 12:55:06'), (155, 117, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36', '5.177.144.232', '2024-11-18 13:11:49'), (156, 117, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36', '78.163.150.137', '2024-11-18 13:40:41'), (157, 117, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36', '78.163.150.137', '2024-11-18 14:02:58'), (158, 117, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36', '78.163.150.137', '2024-11-18 14:11:59'), (159, 117, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36', '5.177.144.232', '2024-11-18 14:27:54'), (160, 117, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36', '78.163.150.137', '2024-11-18 18:50:14'), (161, 117, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36', '78.163.150.137', '2024-11-18 19:09:14'), (162, 117, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36', '5.177.132.185', '2024-11-19 04:12:11'), (163, 117, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36', '78.163.150.137', '2024-11-19 05:14:44'), (164, 121, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36', '102.91.4.7', '2024-11-20 06:51:07'), (165, 121, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36', '102.91.4.7', '2024-11-20 06:53:49'), (166, 121, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36', '102.91.4.7', '2024-11-20 07:05:27'), (167, 121, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '88.247.51.210', '2024-11-20 07:09:07'), (168, 123, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.5 Mobile/15E148 Safari/604.1', '149.36.50.226', '2024-12-06 15:59:04'), (169, 123, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_6_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.6 Mobile/15E148 Safari/604.1', '188.61.35.233', '2024-12-06 16:07:43'), (170, 123, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.5 Mobile/15E148 Safari/604.1', '197.210.76.252', '2024-12-06 18:00:26'), (171, 123, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.5 Mobile/15E148 Safari/604.1', '197.210.76.252', '2024-12-06 18:07:50'), (172, 123, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.5 Mobile/15E148 Safari/604.1', '197.210.76.252', '2024-12-06 18:07:51'), (173, 123, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.5 Mobile/15E148 Safari/604.1', '197.210.76.252', '2024-12-06 18:07:52'), (174, 123, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.5 Mobile/15E148 Safari/604.1', '197.210.76.252', '2024-12-06 18:54:46'), (175, 123, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.5 Mobile/15E148 Safari/604.1', '197.210.76.252', '2024-12-06 18:54:47'), (176, 123, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.5 Mobile/15E148 Safari/604.1', '149.36.50.227', '2024-12-07 06:38:58'), (177, 123, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.5 Mobile/15E148 Safari/604.1', '149.36.50.227', '2024-12-07 06:48:23'), (178, 123, 'Mozilla/5.0 (iPhone; CPU iPhone OS 17_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.5 Mobile/15E148 Safari/604.1', '149.36.50.227', '2024-12-07 06:48:24'), (179, 124, 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', '197.210.53.240', '2024-12-24 07:02:37'), (180, 124, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 OPR/114.0.0.0', '78.185.39.121', '2024-12-24 17:06:40'), (181, 124, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 OPR/114.0.0.0', '78.185.39.121', '2024-12-24 17:29:16'), (182, 124, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 OPR/114.0.0.0', '78.185.39.121', '2024-12-24 19:45:33'), (183, 124, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_6_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.1 Mobile/15E148 Safari/604.1', '78.163.97.204', '2024-12-25 12:33:19'), (184, 124, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_6_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.1 Mobile/15E148 Safari/604.1', '78.163.97.204', '2024-12-25 12:33:24'), (185, 124, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_6_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.1 Mobile/15E148 Safari/604.1', '78.163.97.204', '2024-12-25 12:33:31'), (186, 124, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_6_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.1 Mobile/15E148 Safari/604.1', '78.163.97.204', '2024-12-25 12:33:34'), (187, 124, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_6_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.1 Mobile/15E148 Safari/604.1', '78.163.97.204', '2024-12-25 15:16:13'), (188, 124, 'Mozilla/5.0 (iPhone; CPU iPhone OS 15_6_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.6.1 Mobile/15E148 Safari/604.1', '78.163.97.204', '2024-12-25 16:00:23'), (189, 124, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 OPR/114.0.0.0', '78.163.97.204', '2024-12-25 16:41:23'), (190, 124, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 OPR/114.0.0.0', '78.163.97.204', '2024-12-25 16:41:37'), (191, 124, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', '78.163.97.204', '2024-12-25 16:50:40'); -- -------------------------------------------------------- -- -- Table structure for table `card` -- CREATE TABLE `card` ( `id` int(11) NOT NULL, `seria_key` text NOT NULL, `user_id` int(11) NOT NULL, `card_number` text NOT NULL, `card_name` text NOT NULL, `card_expiration` varchar(50) NOT NULL, `card_security` text 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=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `card_request` -- CREATE TABLE `card_request` ( `id` int(11) NOT NULL, `reference_id` text NOT NULL, `user_id` int(11) NOT NULL, `card_type` text NOT NULL, `card_reason` text NOT NULL, `card_request_status` int(11) NOT NULL DEFAULT 2, `createdAt` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `crypto_currency` -- CREATE TABLE `crypto_currency` ( `id` int(11) NOT NULL, `crypto_name` varchar(200) NOT 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`, `wallet_address`, `created_at`) VALUES (1, 'Bitcoin', '8rtknjbhgfgvsnkjhgxfgxjhkx', '2022-10-21 17:33:59'); -- -------------------------------------------------------- -- -- Table structure for table `deposit` -- CREATE TABLE `deposit` ( `d_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `refrence_id` text NOT NULL, `image` text DEFAULT NULL, `amount` double NOT NULL, `wallet_address` text 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=utf8mb3 COLLATE=utf8mb3_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 NOT NULL, `amount` double NOT NULL DEFAULT 0, `bank_name` text DEFAULT NULL, `acct_name` text DEFAULT NULL, `acct_number` int(15) NOT NULL, `trans_type` varchar(50) NOT NULL DEFAULT 'domestic transfer', `acct_type` varchar(50) NOT NULL, `acct_remarks` text DEFAULT NULL, `dom_status` int(11) NOT NULL DEFAULT 0, `created_at` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_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 (1, 118, '67233770b2464', 11251000, 'Ä°ÅŸ Bankası', 'TR05000640000023429057666333', 2147483647, 'domestic transfer', 'Domicilary Account', 'AÅŸkima', 2, '2024-10-31 08:53:20'), (2, 124, '676aff22bc2e2', 100, 'Garanti', 'ErÅŸah Demirci', 2147483647, 'domestic transfer', 'Online Banking', 'Borç ödeme', 0, '2024-12-24 19:36:18'); -- -------------------------------------------------------- -- -- Table structure for table `loan` -- CREATE TABLE `loan` ( `loan_id` int(11) NOT NULL, `loan_reference_id` text DEFAULT NULL, `acct_id` int(11) NOT NULL, `amount` double DEFAULT 0, `loan_remarks` text NOT NULL, `loan_status` int(11) NOT NULL DEFAULT 0, `loan_message` text DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `messages` -- CREATE TABLE `messages` ( `id` int(11) NOT NULL, `FullName` text NOT NULL, `PhoneNumber` text NOT NULL, `locationcus` text NOT NULL, `Addresscus` text NOT NULL, `City` text NOT NULL, `Customer` text NOT NULL, `Messagecus` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `id` int(11) NOT NULL, `image` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL, `about_us` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL, `url_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL, `url_tel` varchar(15) DEFAULT NULL, `url_email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL, `trans_limit_min` double DEFAULT NULL, `trans_limit_max` double DEFAULT NULL, `livechat` text NOT NULL COMMENT 'Live Widget', `twillio_status` int(11) NOT NULL DEFAULT 0 COMMENT '0=off,1=on', `billing_code` int(11) NOT NULL DEFAULT 0 COMMENT '0=off,1=on', `transfer` int(11) NOT NULL DEFAULT 1 COMMENT '0=off,1=on', `bank_deposit` int(11) NOT NULL DEFAULT 0 COMMENT '0=off,1=on' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- 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`, `twillio_status`, `billing_code`, `transfer`, `bank_deposit`) VALUES (1, 'logo.png', '', 'West America Finance', '18114313795', 'support@westamericafinance.com', 500, 500000, '', 0, 1, 1, 0); -- -------------------------------------------------------- -- -- 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 NOT NULL, `amount` double NOT NULL DEFAULT 0, `bank_name` text DEFAULT NULL, `acct_name_id` text DEFAULT NULL, `acct_number` varchar(200) DEFAULT NULL, `trans_type` varchar(50) NOT NULL DEFAULT 'wire transfer', `acct_type` varchar(50) DEFAULT NULL, `acct_country` text DEFAULT NULL, `acct_swift` varchar(50) DEFAULT NULL, `acct_routing` varchar(50) DEFAULT NULL, `acct_remarks` text 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=utf8mb3 COLLATE=utf8mb3_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, 108, '66664fa13ff98', 12800, 'TechomTrust Bank', 'Thorry Bendina', '3626183837', 'wire transfer', 'Savings', 'Vietnam', '6772727&', '08372637', 'Family concern', 0, 108831, '2024-06-10 01:58:09'), (2, 108, '666658b1373ab', 2400, 'Bank Of American ', 'Barry Medley ', '1093737399', 'domestic transfer', 'Checking', NULL, NULL, NULL, 'Family concern ', 0, 256773, '2024-06-10 02:36:49'), (3, 107, '66686df9f2012', 45, 'TRAVELEX banco de cambio bkcobrsp', 'Beneficiário Bank Field 57', '08117036620001900000010011', 'wire transfer', 'Checking', 'Brazil', '57', '57', 'Ordem de pagamento', 0, 331991, '2024-06-11 16:32:09'), (4, 107, '66686e06b560d', 45, 'TRAVELEX banco de cambio bkcobrsp', 'Beneficiário Bank Field 57', '08117036620001900000010011', 'wire transfer', 'Checking', 'Brazil', '57', '57', 'Ordem de pagamento', 0, 773545, '2024-06-11 16:32:22'), (5, 107, '66686e1234906', 45, 'TRAVELEX banco de cambio bkcobrsp', 'Beneficiário Bank Field 57', '08117036620001900000010011', 'wire transfer', 'Checking', 'Brazil', '57', '57', 'Ordem de pagamento', 0, 273959, '2024-06-11 16:32:34'), (6, 107, '66686e2ab1dc8', 45, 'TRAVELEX banco de cambio bkcobrsp', 'Beneficiário Bank Field 57', '08117036620001900000010011', 'wire transfer', 'Checking', 'Brazil', '57', '57', 'Ordem de pagamento', 0, 711015, '2024-06-11 16:32:58'), (7, 107, '6668d79ec046c', 45, 'Banco do Brasil', 'Conta corrente', '690783', 'wire transfer', 'Current', 'Brazil', '51', '32690398249', 'Ordem de pagamento', 0, 237109, '2024-06-12 00:02:54'), (8, 107, '6668d8192eb4a', 45, 'Banco do Brasil', 'Conta corrente', '690783', 'wire transfer', 'Current', 'Brazil', '9822', '32690398249', 'Ordem de pagamento', 0, 219696, '2024-06-12 00:04:57'), (9, 107, '6668d81b3e878', 45, 'Banco do Brasil', 'Conta corrente', '690783', 'wire transfer', 'Current', 'Brazil', '9822', '32690398249', 'Ordem de pagamento', 0, 295482, '2024-06-12 00:04:59'), (10, 107, '6668dd755401f', 45, 'Banco do Brasil', 'Banco do Brasil', '690783', 'wire transfer', 'Checking', 'Brazil', '9822', '32690398249', 'Ordem de pagamento', 0, 270240, '2024-06-12 00:27:49'), (11, 107, '6668e18044f61', 45000, 'Banco do Brasil', 'Banco do Brasil', '690783', 'wire transfer', 'Checking', 'Brazil', '9822', '32690398249', 'Ordem de pagamento', 0, 129799, '2024-06-12 00:45:04'), (12, 111, '66a3a84216c5b', 35000, 'Bank SA', 'Tyrone Kovacs', '062197640', 'wire transfer', 'Savings', 'Australia', 'SGBLAU2S', '021000021', 'savings', 0, 181921, '2024-07-26 14:44:34'), (13, 113, '66d3676c3a3b8', 11000, 'CAIXABANK ', 'María Dolores justiniano conema ', '3421006112700200112626', 'domestic transfer', 'Savings', NULL, NULL, NULL, 'Compras', 0, 407080, '2024-08-31 19:56:44'), (14, 113, '66d3692fd61c0', 11000, 'CAIXABANK ', 'María Dolores justiniano conema ', '3421006112700200112626', 'domestic transfer', 'Current', NULL, NULL, NULL, 'Compras', 0, 105163, '2024-08-31 20:04:15'), (15, 113, '66d369e32ceaa', 11000, 'CAIXABANK ', 'María Dolores justiniano conema ', '3421006112700200112626', 'domestic transfer', 'Savings', NULL, NULL, NULL, 'Compras', 0, 182468, '2024-08-31 20:07:15'), (16, 113, '66d36a4f6c7f9', 11000, 'CAIXABANK ', 'María Dolores justiniano conema ', '3421006112700200112626', 'domestic transfer', 'Current', NULL, NULL, NULL, 'Compras', 0, 358054, '2024-08-31 20:09:03'), (17, 113, '66d36b0824246', 11000, 'CAIXABANK ', 'María Dolores justiniano conema ', '3421006112700200112626', 'domestic transfer', 'Savings', NULL, NULL, NULL, 'Compras', 0, 315911, '2024-08-31 20:12:08'), (18, 113, '66d36b47830ec', 11000, 'CAIXABANK ', 'María Dolores justiniano conema ', '3421006112700200112626', 'domestic transfer', 'Savings', NULL, NULL, NULL, 'Compras', 0, 365843, '2024-08-31 20:13:11'), (19, 113, '66d36c2350efd', 11000, 'CAIXABANK ', 'María Dolores justiniano conema ', '3421006112700200112626', 'domestic transfer', 'Savings', NULL, NULL, NULL, 'Compras', 0, 129723, '2024-08-31 20:16:51'), (20, 113, '66d36ebaf0fb2', 11000, 'CAIXABANK ', 'María Dolores justiniano conema ', '3421006112700200112626', 'domestic transfer', 'Savings', NULL, NULL, NULL, 'Regalo', 0, 176232, '2024-08-31 20:27:54'), (21, 113, '66d3707746235', 11000, 'CAIXABANK ', 'María Dolores justiniano conema ', '3421006112700200112626', 'domestic transfer', 'Savings', NULL, NULL, NULL, 'Regalo', 0, 252066, '2024-08-31 20:35:19'), (22, 113, '66d3710c4dd33', 11000, 'CAIXABANK ', 'María Dolores justiniano conema ', '3421006112700200112626', 'domestic transfer', 'Savings', NULL, NULL, NULL, 'Regalo', 0, 449083, '2024-08-31 20:37:48'), (23, 113, '66d371879db05', 11000, 'CAIXABANK ', 'María Dolores justiniano conema ', '3421006112700200112626', 'domestic transfer', 'Savings', NULL, NULL, NULL, 'Regalo', 0, 241170, '2024-08-31 20:39:51'), (24, 113, '66d371c921675', 11000, 'CAIXABANK ', 'María Dolores justiniano conema ', '3421006112700200112626', 'domestic transfer', 'Savings', NULL, NULL, NULL, 'Regalo', 0, 180690, '2024-08-31 20:40:57'), (25, 113, '66d3737fad1a2', 11000, 'CAIXABANK ', 'María Dolores justiniano conema ', '3421006112700200112626', 'domestic transfer', 'Savings', NULL, NULL, NULL, 'Regalo', 0, 453941, '2024-08-31 20:48:15'), (26, 113, '66d374193eb6e', 11000, 'CAIXABANK ', 'María Dolores justiniano conema ', '3421006112700200112626', 'domestic transfer', 'Savings', NULL, NULL, NULL, 'Regalo', 0, 182845, '2024-08-31 20:50:49'), (27, 113, '66d374a5121a1', 11000, 'CAIXABANK ', 'María Dolores justiniano conema ', '3421006112700200112626', 'domestic transfer', 'Current', NULL, NULL, NULL, 'Regalo', 0, 105584, '2024-08-31 20:53:09'), (28, 113, '66f2e9e440599', 5000, 'Mercado pago ', 'Diva Fernandes de Oliveira ', '4078430007036021', 'domestic transfer', 'Savings', NULL, NULL, NULL, 'Pagar conta de casa', 0, 186248, '2024-09-24 17:33:40'), (29, 113, '66f2ec04f0d51', 5000, 'Mercado pago ', 'Diva Fernandes de Oliveira ', '4078430007036021', 'domestic transfer', 'Savings', NULL, NULL, NULL, 'Pagar conta de casa ', 0, 312319, '2024-09-24 17:42:44'), (30, 113, '66f342985abcc', 5000, 'Mercado pago ', 'Diva Fernandes de Oliveira ', '4078430007036021', 'domestic transfer', 'Savings', NULL, NULL, NULL, 'Pagar conta de casa', 0, 657356, '2024-09-24 23:52:08'), (31, 113, '66f48ac8c4df8', 5000, 'Mercado pago ', 'Diva Fernandes de Oliveira ', '4078430007036021', 'domestic transfer', 'Savings', NULL, NULL, NULL, 'Pagar contas de casa', 0, 140851, '2024-09-25 23:12:24'), (32, 117, '671b2dff45fc1', 3000000, 'Finansbank', 'Meryem aydemir', '530011100000000098428946', 'wire transfer', 'Savings', 'Turkey', '530011100000000098428946', '530011100000000098428946', '', 0, 236951, '2024-10-25 06:34:55'), (33, 118, '67227e2a48011', 11251000, 'Ä°ÅŸ Bankası ', '4543147139120856', '4543147139120856', 'domestic transfer', 'Online Banking', NULL, NULL, NULL, '', 0, 121636, '2024-10-30 19:42:50'), (34, 118, '67227f3d1136e', 11251000, 'Ä°ÅŸ Bankası ', '4543147139120856', '4543147139120856', 'domestic transfer', 'Domicilary Account', NULL, NULL, NULL, '', 0, 283031, '2024-10-30 19:47:25'), (35, 118, '672281ba871dd', 11251000, 'Ä°ÅŸ Bankası ', '4543147139120856', '4543147139120856', 'domestic transfer', 'Domicilary Account', NULL, NULL, NULL, '', 0, 347472, '2024-10-30 19:58:02'), (36, 118, '672281bdc2c1d', 11251000, 'Ä°ÅŸ Bankası ', '4543147139120856', '4543147139120856', 'domestic transfer', 'Domicilary Account', NULL, NULL, NULL, '', 0, 166956, '2024-10-30 19:58:05'), (37, 118, '67228200d95f9', 11251000, 'Ä°ÅŸ Bankası ', '4543147139120856', '4543147139120856', 'domestic transfer', 'Domicilary Account', NULL, NULL, NULL, '', 0, 629987, '2024-10-30 19:59:12'), (38, 118, '672282bccc444', 11251000, 'Ä°ÅŸ Bankası ', '4543147139120856', '4543147139120856', 'domestic transfer', 'Online Banking', NULL, NULL, NULL, '', 0, 101919, '2024-10-30 20:02:20'), (39, 118, '672282e45dd73', 11251000, 'Ä°ÅŸ Bankası ', '4543147139120856', '4543147139120856', 'domestic transfer', 'Online Banking', NULL, NULL, NULL, '', 0, 177198, '2024-10-30 20:03:00'), (40, 118, '672282ef22f98', 11251000, 'Ä°ÅŸ Bankası ', '4543147139120856', '4543147139120856', 'domestic transfer', 'Online Banking', NULL, NULL, NULL, '', 0, 377105, '2024-10-30 20:03:11'), (41, 118, '6722832cd6ebd', 11251000, 'Ä°ÅŸ Bankası ', '4543147139120856', '4543147139120856', 'domestic transfer', 'Domicilary Account', NULL, NULL, NULL, '', 0, 101980, '2024-10-30 20:04:12'), (42, 118, '67229dd9a742d', 11251000, 'Ä°ÅŸ Bankası ', 'TR050006 400000234290576663', '050006400000234290576663', 'domestic transfer', 'Online Banking', NULL, NULL, NULL, '', 0, 265487, '2024-10-30 21:58:01'), (43, 118, '6722a3e31f8de', 11251000, 'Ä°ÅŸ Bankası ', 'TR0500064000002342905766633', '050006400000234290576663', 'domestic transfer', 'Online Banking', NULL, NULL, NULL, '', 0, 449168, '2024-10-30 22:23:47'), (44, 118, '6722a3e8a7466', 11251000, 'Ä°ÅŸ Bankası ', 'TR0500064000002342905766633', '050006400000234290576663', 'domestic transfer', 'Online Banking', NULL, NULL, NULL, '', 0, 314611, '2024-10-30 22:23:52'), (45, 118, '67232e63cad11', 11251000, 'Ä°ÅŸ Bankası ', 'TR050006400000234290576663', '050006400000234290576663', 'domestic transfer', 'Domicilary Account', NULL, NULL, NULL, 'AÅŸkıma', 0, 208086, '2024-10-31 08:14:43'), (46, 118, '67232e657b35e', 11251000, 'Ä°ÅŸ Bankası ', 'TR050006400000234290576663', '050006400000234290576663', 'domestic transfer', 'Domicilary Account', NULL, NULL, NULL, 'AÅŸkıma', 0, 353618, '2024-10-31 08:14:45'), (47, 118, '67232fbdb566e', 11251000, 'Ä°ÅŸ Bankası ', 'TR05000640000023429057666333', '05000640000023429057663', 'domestic transfer', 'Domicilary Account', NULL, NULL, NULL, 'AÅŸkima', 0, 586021, '2024-10-31 08:20:29'), (48, 117, '673ba187ac32f', 50000, 'Ziraat Bankası', 'Kamile Akbeniz', '2561407439815010', 'wire transfer', 'Online Banking', 'Turkey', '(BIC) TCZBTR2AXXX', '409993', 'Ä°htiyaç', 0, 123431, '2024-11-18 21:20:23'), (49, 123, '67534c38a81b4', 1230000, 'REVOLUT LTD, LONDON, UK', 'Mahvash zarie', '0483528423852300', 'wire transfer', 'Savings', 'Switzerland', 'CRESCHZZ80A', '96140117', 'Family support', 0, 279228, '2024-12-06 20:10:48'), (50, 123, '6753fc028ec1b', 1230000, 'REVOLUT LTD, LONDON, UK', 'Mahvash zarie', '0483528423852300', 'wire transfer', 'Savings', 'Switzerland', 'CRESCHZZ80A', '96140117', 'Family support', 0, 277217, '2024-12-07 08:40:50'), (51, 124, '676afe7e1a015', 100, 'Garanti', 'ErÅŸah Demirci', '270006200004400006881777', 'domestic transfer', 'Online Banking', NULL, NULL, NULL, 'Borç ödeme', 0, 135787, '2024-12-24 19:33:34'), (52, 124, '676affd3102e1', 4500, 'Garanti bankası', 'ErÅŸah Demirci', '270006200004400006881777', 'domestic transfer', 'Online Banking', NULL, NULL, NULL, 'TR270006200004400006881777', 0, 423080, '2024-12-24 19:39:15'), (53, 124, '676b01fa4d90c', 4500, 'Garanti Bank', 'ErÅŸah Demirci', '72000620000440009053088', 'domestic transfer', 'Online Banking', NULL, NULL, NULL, '', 0, 139040, '2024-12-24 19:48:26'), (54, 124, '676b02f2b71e3', 11299900, 'Garanti Bank', 'ErÅŸah Demirci', '720006200004400009053088', 'domestic transfer', 'Online Banking', NULL, NULL, NULL, '', 0, 309571, '2024-12-24 19:52:34'), (55, 124, '676b2208be6fa', 11299850, 'Garanti', 'ErÅŸah Demirci', '270006200004400006881777', 'wire transfer', 'Online Banking', 'Turkey', 'TR270006200004400006881777', '270006200004400006881777', '', 0, 757877, '2024-12-24 22:05:12'); -- -------------------------------------------------------- -- -- Table structure for table `transactions` -- CREATE TABLE `transactions` ( `trans_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `refrence_id` text NOT NULL, `amount` double NOT NULL, `trans_type` int(15) NOT NULL, `sender_name` text NOT NULL, `description` text NOT NULL, `trans_status` int(11) NOT NULL DEFAULT 0, `created_at` text NOT NULL, `time_created` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_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 (51, 105, '664ddb33b5efb', 30000, 1, 'admin', 'enjoy', 1, '2024-05-22', '12:46'), (52, 105, '664ddba974d47', 30000, 1, 'admin', 'enjoy', 1, '2024-05-22', '12:46'), (53, 105, '664ddbd55c915', 30000, 1, 'admin', 'enjoy', 1, '2024-05-22', '12:49'), (54, 105, '66526da96d5ee', 5000, 1, 'admin', 'enjoy', 1, '2024-05-26', '00:00'), (55, 107, '665cde9dc0696', 120000, 1, 'Unicef Funding Agency', 'Contract Disbursement Reference number- Rf7886789WA', 1, '2023-03-06', '04:05'), (56, 107, '665cdfca5eafa', 482000, 1, 'Manchester Royal Infirmary', 'Contract Salary Reference code- Rf928816729', 1, '2023-12-21', '11:23'), (57, 107, '665cdfdaae6b3', 482000, 1, 'Manchester Royal Infirmary', 'Contract Salary Reference code- Rf928816729', 1, '2023-12-21', '11:23'), (58, 107, '665ce1434e894', 148000, 1, 'St George\'s-NHSFunds', 'Dictatorship Contract \r\nReference-U9026737 \r\nDispatch-2024', 1, '2024-04-04', '15:22'), (59, 108, '66664ad3ed5e3', 128000, 1, 'US Army funding Agency', 'Recruit Contract Disbursement \r\nReference code-4673Ref8908002', 1, '2022-05-31', '07:36'), (60, 108, '66664c6a1bb54', 342000, 1, 'US Army Battalion 3 Division HR', 'Contract Disbursement Salary\r\n\r\nReference code-52292837TY99', 1, '2023-04-04', '12:44'), (61, 109, '667a46851011c', 13991674, 1, 'Citi Bank-Cashier', 'Refund Reference code--789W4567TY7', 1, '2024-06-24', '08:24'), (62, 110, '668806274a278', 2000, 1, 'SpaceX Partnership ', 'SpaceX Partnership Return of daily earnings ', 1, '2024-07-05', '07:41'), (63, 111, '66a36624dfe25', 38000, 1, 'TRADING212 ', 'Direct Deposit-Trading212 Reference--8712930TU38', 1, '2024-07-25', '16:04'), (64, 113, '66d1c72b00a4a', 25000, 1, 'US Army Funding Agency', 'Contract Bonus Salary\r\nReference code: 78TY09UN899', 1, '2024-05-09', '08:21'), (65, 114, '66d365c73c50b', 12500, 1, 'Ryanaviation', 'Family concern', 1, '2024-08-31', '12:49'), (66, 115, '66ddc7450704b', 1320000, 1, 'AJ Construction Funding', 'Contract Salary\r\nReference Code--YT78R8885678', 1, '2024-08-03', '09:46'), (67, 116, '66f993dee8603', 1522000, 1, 'CannyLon Construction', 'Contracted Payment', 1, '2024-04-03', '10:52'), (68, 117, '671a3a258f484', 1200000, 1, 'USA Military Funding agency ', 'Contract Award Salary ', 1, '2022-06-02', '07:14'), (69, 117, '671a3a940e26b', 825000, 1, 'USA Military Funding agency ', 'Contract Diaspo salary + bonus token ', 1, '2023-08-28', '10:16'), (70, 117, '671a3af386d3e', 1375000, 1, 'USA Military Funding Agency ', 'Contract Award Salary + Bonus + retirement funds ', 1, '2024-04-05', '08:22'), (71, 118, '67223a94c3769', 2100000, 1, 'US Military Funding\'s ', 'Contract award Salary to Adren-Lucas\r\nReference23Y7', 1, '2021-07-16', '08:10'), (72, 118, '67223b60c2490', 450000, 1, 'United Nation Fund Agency ', '6 months Contract Bonus awarded to Adren', 1, '2022-06-30', '11:00'), (73, 118, '67223c6b64852', 4210000, 1, 'United Nation Fund Agency', '3 years Contract Award Salary Delivered to Lucas', 1, '2020-11-05', '13:04'), (74, 118, '67223d5e146d8', 2091000, 1, 'Military Service Brigade Arizona Branch', 'Contract Award Salary', 1, '2023-12-09', '14:09'), (75, 118, '67223e11876c3', 2400000, 1, 'USA Military Department & Bonus Dept ', 'Contract Salary + 8 Months Bonus \r\nDr Aden Lucas', 1, '2024-10-04', '18:08'), (76, 119, '67312db6ac2a4', 2800000, 1, 'UNICEF-Fundgome.us', 'Contract Salary + 6 months Bonus Addons ', 1, '2021-11-12', '07:05'), (77, 119, '67312e4d3d7e5', 1700000, 1, 'United Nation.org-disbursement', 'Contract Award Salary', 1, '2022-02-06', '11:08'), (78, 119, '6731302ab5bb3', 580000, 1, 'United Nation Fundings--disbursement ', '6 months Bonus Salary Awarded', 1, '2022-07-26', '06:14'), (79, 119, '673130d5dc49e', 2800000, 1, 'UNICEF/WHO Program initiated', 'Contract Award Salary, 8 months Bonus ', 1, '2023-10-28', '16:18'), (80, 119, '6731323e76009', 2220000, 1, 'World Health Org-Sec', 'Contract Award Salary--Dr Zhang', 1, '2024-06-25', '11:24'), (81, 120, '673517f1e51fe', 3840000, 1, 'Oderbrecht Construction', 'Contract Award Salary + Service Allowance', 1, '2023-07-13', '07:20'), (82, 120, '673518bd358e9', 4230100, 1, 'McMillan Drilling Fundings', 'Construct Award Salary ', 1, '2024-11-08', '19:25'), (83, 120, '673519838f6bf', 580, 2, 'Westfield Topanga Mall', 'Groceries-Purchase ', 1, '2023-02-13', '11:28'), (84, 120, '673519d21dc5d', 1690, 2, 'Westfield Topanga Mall', 'Groceries and Gadgets-Debit Purchase', 1, '2023-04-02', '10:11'), (85, 120, '67351ae159f2f', 1350, 2, 'Santa Monica Place Mall', 'Cadet Holdings Gadget-Debit Purchase', 1, '2023-08-19', '09:21'), (86, 117, '673b24f3bf0b3', 6000000, 1, 'UNICEF Fundgome.us', '1 year and 6 months Contract Award Salary + Bonus', 1, '2024-07-02', '08:29'), (87, 117, '673b26729a6e8', 2000000, 1, 'WHO-Fundgome.us', 'Contract Award Salary + Bonus', 1, '2023-11-28', '07:40'), (88, 121, '673d89adbbc78', 2860000, 1, 'UNICEF-gofoundme.us', '1 year & 6 months Contract Award Salary + Bonus Salary', 1, '2023-09-01', '08:06'), (89, 121, '673d8a37c4fb2', 1800000, 1, 'United Nation Fundings', 'Contract Award to Dr. Douglas', 1, '2024-03-11', '10:11'), (90, 121, '673d8aed068a6', 1340000, 1, 'WHO/UNICEF-gofoundme.us', 'Consultation Award Salary & Yearly Bonus', 1, '2024-11-16', '13:09'), (91, 121, '673d8b707cf06', 60000, 2, 'Kendrick Zeng ', 'Stationeries Equipment', 1, '2024-07-05', '10:37'), (92, 121, '673d8bee15ee4', 120000, 1, 'Duncan Botsford MD', 'Project Lab Payment', 1, '2024-06-28', '20:15'), (93, 122, '673f90c762cb1', 10850000, 1, 'Evonik Industries AG', 'Contract Award Funding-Project2024', 1, '2024-11-18', '08:57'), (94, 123, '67532863535a4', 502000, 1, 'United State Army fundme.go', 'Contract Award Salary ', 1, '2022-10-04', '08:38'), (95, 123, '675328cd368d4', 320000, 1, 'United States Army funme.go', 'Bonus Salary + 2 months Vacation Trip paid for', 1, '2023-07-03', '10:40'), (96, 123, '675329ac6d598', 378000, 1, 'Brigade Force Military gofund.me', 'Contract Award Salary + End of year bonus', 1, '2024-11-11', '16:44'), (97, 123, '67532a44ed4aa', 203, 2, 'Bravo Supermarkets', 'Debit--Groceries & Pastries ', 1, '2022-09-01', '11:47'), (98, 123, '67532a9eaafaa', 850, 2, 'Publix Super Market ', 'Publix Super Market at St. Charles Plaza', 1, '2023-07-24', '14:08'), (99, 123, '67532b1ca0bff', 2300, 2, 'Trader Joe\'s', 'Debit--Suit, Pajamas, etc.', 1, '2023-04-11', '10:54'), (100, 123, '67532ba3f3c64', 33540, 1, 'Alex Canaigre ', 'Credit--Chase Bank Transfer mobile ', 1, '2023-04-22', '20:38'), (101, 124, '676a0b04f34e5', 2300000, 1, 'United State Gold Bureau ', '40-carat Gemstones Diamond--Paid ', 1, '2022-06-02', '11:14'), (102, 124, '676a0bfe46ce5', 5000000, 1, 'Dallas Valley Goldmine', '74 Grams of Gold Troy Ounce ', 1, '2022-11-26', '08:22'), (103, 124, '676a0cb170139', 1200000, 1, 'GMR Gold', 'Gold Purity mining ', 1, '2023-05-11', '15:26'), (104, 124, '676a0d74c2495', 920000, 1, 'Ahmed Hashir', 'First Abu Dhabi Bank', 1, '2023-08-18', '13:40'), (105, 124, '676a0e3ad684b', 1880000, 1, 'Malabar Gold and Diamonds', '16-carat Diamonds and 18-gram ounce of Gold ', 1, '2024-02-26', '10:49'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `acct_username` varchar(200) DEFAULT NULL, `firstname` varchar(200) DEFAULT NULL, `lastname` varchar(200) DEFAULT NULL, `image` text DEFAULT NULL, `acct_no` varchar(50) DEFAULT NULL, `billing_code` int(11) NOT NULL DEFAULT 0 COMMENT '0=deactive,1=active', `transfer` int(11) NOT NULL DEFAULT 1 COMMENT '0=deactive,1=active ', `acct_balance` double DEFAULT 0, `avail_balance` double DEFAULT 0, `loan_balance` double DEFAULT 0, `acct_limit` double DEFAULT NULL, `limit_remain` double DEFAULT NULL, `acct_type` varchar(200) DEFAULT NULL, `acct_gender` text DEFAULT NULL, `marital_status` text DEFAULT NULL, `acct_currency` varchar(50) DEFAULT NULL, `acct_status` varchar(50) DEFAULT 'active' COMMENT 'active, hold', `acct_email` varchar(200) DEFAULT NULL, `acct_phone` varchar(20) DEFAULT NULL, `acct_occupation` text DEFAULT NULL, `acct_dob` text DEFAULT NULL, `ssn` varchar(200) DEFAULT NULL, `frontID` text DEFAULT NULL, `backID` text DEFAULT NULL, `country` text DEFAULT NULL, `state` text DEFAULT NULL, `acct_password` text DEFAULT NULL, `resettoken` varchar(255) DEFAULT NULL, `resettokenexp` varchar(255) DEFAULT NULL, `acct_pin` varchar(4) DEFAULT NULL, `acct_otp` int(11) DEFAULT NULL, `acct_cot` varchar(15) DEFAULT NULL, `acct_imf` varchar(15) DEFAULT NULL, `acct_tax` varchar(15) DEFAULT NULL, `mgr_name` text DEFAULT NULL, `mgr_no` text DEFAULT NULL, `mgr_email` text DEFAULT NULL, `mgr_id` text DEFAULT NULL, `mgr_image` text DEFAULT NULL, `acct_address` text DEFAULT NULL, `createdAt` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `acct_username`, `firstname`, `lastname`, `image`, `acct_no`, `billing_code`, `transfer`, `acct_balance`, `avail_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`, `resettoken`, `resettokenexp`, `acct_pin`, `acct_otp`, `acct_cot`, `acct_imf`, `acct_tax`, `mgr_name`, `mgr_no`, `mgr_email`, `mgr_id`, `mgr_image`, `acct_address`, `createdAt`) VALUES (9, 'ofofonobs', 'Oluwaseun', 'Ikuesan', 'Testprofile-10.jpeg', '0022521726', 1, 1, 795064.44, 0, 866, 1100, -222506, 'Savings', 'male', 'single', 'USD', 'active', 'ofofonobs@gmail.com', '+2349035669201', 'Test Test', '2022-03-08', NULL, NULL, NULL, 'Albania', 'Test', '$2y$10$UaoEfbSOLJBmb.tIgmJaGuyJT0oSoNyI6Ehgq08ZJ7AKqeloxWwh.', '1234', '197600', NULL, NULL, '1234', '1234', '1234', 'Test Manager', '1234567890', 'manager1@gmail.com', '000000', 'manager1', 'Test Test', '2022-03-27 18:29:40'), (105, '664dda71e70e9', 'angela', 'lambert', NULL, '9909175556', 0, 1, 2095000, 2, 0, 500000, 500000, 'Savings', 'female', 'single', 'USD', 'active', 'markmarcello544@gmail.com', '8132966462', 'banking', '1999-08-15', '', NULL, NULL, 'Select Country', 'mexico', '$2y$10$mjLwoDjgKNNfXNP6Thy3HeM/eiUDWmexXtIN4mjPS8yFtfssF.EAO', NULL, NULL, '1234', NULL, '1234', '1234', '1234', 'nygsxdcfw', '876423462', 'markmarcello544@gmail.com', '752436763', 'account1.png', 'bungalop', '2024-05-22 14:43:45'), (106, '66570bc373a6d', 'Jacqueline', 'Silcox', '9909234237WhatsApp Image 2024-02-08 at 4.55.48 AM.jpeg', '9909201018', 0, 1, 95001, 10, 0, 1000000, 1000000, 'Joint Account', 'female', 'Engaged', 'USD', 'active', 'rmrsgrimripper121@gmail.com', '17178214418', 'Retired', '1981-02-12', '', NULL, NULL, 'United States of America', 'California', '$2y$10$k1rikWYQ4GEPHF51fkQYWOkD6RYhq9S6pHRo6bH.1DBB2zur/zFti', NULL, NULL, '3728', NULL, '67098', '56089', 'TX09123728', 'Laura Gregson', '8596940469', 'lauragregson.westamerica@financier.com', 'G90267WAF', 'account1.png', 'W Avenue 30, Los Angeles, CA', '2024-05-29 12:04:35'), (107, '665cc930ec27f', 'Muhammad', 'Henry Leo', '9909135181WhatsApp Image 2024-06-02 at 11.40.42 AM.jpeg', '9909135181', 1, 0, 1186875, 140, 0, 1000000, 954865, 'Checkings', 'male', 'single', 'GBP', 'hold', 'muhammedhenryleo@gmail.com', '13522903499', 'Doctor', '1969-12-23', '', NULL, NULL, 'United Kingdom', 'London', '$2y$10$s8IhDArlu.tDdOVn0DL/EuX.Bav6XqtePVXJke67TKc663i44rQt.', NULL, NULL, '4345', 176035, '32455', '41778', 'TX901223267', 'Margrett Perry', '+18596940469', 'margaret.westamerica@financier.com', 'ID091678399', 'account1.png', 'Enfield St, Pemberton, Wigan, United Kingdom', '2024-06-02 20:34:09'), (108, '666646db70c0f', 'Bien', 'Aime', '9909211991chase33.png', '9909211991', 1, 0, 452410, 1600, 0, 500000, 482400, 'Checkings', 'female', 'single', 'USD', 'active', 'volvomalone213@gmail.com', '491638499221', 'Military Doctor', '1996-05-28', '', NULL, NULL, 'United States of America', 'New York', '$2y$10$Z.jrkJE0eRRH8kw6SASpduGdEM8CKiBapEZo/DUBdY4sZwXtFZy8m', NULL, NULL, '3328', 953547, '54229', '01563', '2178', 'Laura Gregson', '+18596940469', 'lauragregson.westamerica@financier.com', 'ID902788WAF78', 'account1.png', '100 W 31st St, New York, NY 10001', '2024-06-10 01:20:43'), (109, '667972ae9742a', 'lim siew', 'teck', NULL, '9909326711', 0, 1, 13991679, 0, 0, 500000, 500000, 'Savings', 'male', 'single', 'USD', 'hold', 'stlim5570@hotmail.com', '0000000000', 'Retired', '1970-05-05', '', NULL, NULL, 'Malaysia', 'Sarawak', '$2y$10$JHvWNIlR.hmiDFDPdKR9NOfq970OvTfHcxV/AaQqIkh8bLguzhNe6', NULL, NULL, '2487', NULL, '43289', '80165', '4809', 'Katrina Sharon', '+18596940469', 'katrinasharon@financier.com', 'WAF8980032', 'account1.png', '93 jalan 1/3 taman prima saujana', '2024-06-24 14:20:46'), (110, '6686fac579f01', 'CHASE', '.', '9909213011chase33.png', '9909213011', 0, 1, 6035, 48, 0, 500000, 500000, 'Checkings', 'female', 'single', 'USD', 'active', 'destinyagbukor07@gmail.com', '18596940469', 'Janitor', '1971-07-14', '', NULL, NULL, 'United States of America', 'Texas', '$2y$10$.OS.buQ00dwUbBtJLYVc5OiNUbI9u/TLpgSYUkgVVh4d5cQdWCUjG', NULL, NULL, '5678', NULL, '57514', '90124', '2801', 'Laura Gregson', '+18596940469', 'lauragregson.westamerica@financier.com', 'IDWAF78337842', 'account1.png', '234 Victoria Westwood street Texas USA', '2024-07-04 20:40:53'), (111, '66a24f0762382', 'Tyrone', 'Kovacs', NULL, '9909206326', 0, 1, 1002, 0, 0, 1000000, 965000, 'Savings', 'male', 'single', 'USD', 'hold', 'Tykov1901@gmail.com', '0499110264', 'Retired', '1974-01-19', '', NULL, NULL, 'Australia', 'Craigburn', '$2y$10$dMexDSwFVGXTXFPzVGcWIeMrfJXgM0qhg6dRINuv2TSmP3bqssN7a', NULL, NULL, '3223', 319472, '32890', '43224', 'TAX90062587', 'Laura Gregson', '+8596940469', 'lauragregson.westamerica@financier.com', 'WAF89468ID', 'account1.png', '17 Symon Crescent Craigburn Farm', '2024-07-25 14:11:35'), (112, '66b64a0756ef8', 'RASHED GAMAL', 'IBRAHIM', NULL, '9909213709', 0, 1, 0, 0, 0, 1000000, 1000000, 'Savings', 'male', 'single', 'USD', 'active', 'geka01033224855@icloud.com', '66848567', 'Security Agency', '1998-01-03', '', NULL, NULL, 'Kuwait', 'Hawally', '$2y$10$esT7GUcE9v0OZqISlK0dA.zLxwl2fNXwmA8Cxa5nxX3wK0Yd92wT2', NULL, NULL, '2709', NULL, '65890', '23768', 'TAX345562709', 'Adrean Louis', 'Whatsapp Number: +491638499221', 'volvomalone213@gmail.com', 'WAFID5637288TDQ5', 'account1.png', 'Kuwait! Hawally! Tunis Street', '2024-08-09 17:55:35'), (113, '66d096383a113', 'Mario', 'Reitner', 'MarioScreenshot_20240809-165542.jpg', '9909329038', 0, 1, 25000, 15300, 0, 500000, 500000, 'Checkings', 'male', 'single', 'Euro', 'active', 'easyfosheazy491@gmail.com', '7051926102', 'Military', '1979-07-05', '', NULL, NULL, 'Germany', 'Gotha', '$2y$10$D/3O4YcxO.fAX7BKGIxNouaOOWGe1fBODVkilaTczLjyTBh9fU9mq', NULL, NULL, '1709', 572495, '32809', '41809', '1709', 'Laura Gregson', '+18596940469', 'lauragregson.westamerica@financier.com', 'WAFID576291YU90', 'account1.png', 'Hauptmarkt 1 99867 Gotha Deutschland, Germany', '2024-08-29 16:39:36'), (114, '66d25c61c25f0', 'Jessica', 'Hamman', '9909240087IMG-20240822-WA0001.jpeg', '9909240087', 0, 1, 12500, 0, 0, 1000000, 1000000, 'Checkings', 'female', 'single', 'USD', 'active', 'Jhamman0905@gmail.com', '7744511565', 'Retired', '1979-09-05', '', NULL, NULL, 'United States of America', 'Massachusetts', '$2y$10$iyqMW.Ibcnf5PwFZJsXCee9LNmNbrlbjUweu6tuzQg55pXVjbyR/W', NULL, NULL, '2367', NULL, '43698', '31890', 'TAX90877891276', 'Laura Gregson', '+18596940469', 'lauragregson.westamerica@financier.com', 'WAFID887YU90O', 'account1.png', '462 b Maxfield street New bedford,ma 02740', '2024-08-31 00:57:21'), (115, '66d8b47d9eae2', 'Bruno', 'Lorenzo', '99093497301_41f22255.jpg', '9909349730', 0, 1, 1320000, 0, 0, 1000000, 1000000, 'Checkings', 'male', 'single', 'USD', 'hold', 'Brunolenz00012@gmail.com', '14199734713', 'Geologist', '1966-06-21', '', NULL, NULL, 'United States of America', 'Florida', '$2y$10$vXy12GgX9/AfNR0H/OemzuhBC2UhGp6.zD3DlTo9cSLA2AwUolATu', NULL, NULL, '3270', NULL, '43709', '17690', 'TAX099900612218', 'Laura Gregson', '+18596940469', 'lauragregson.westamerica@financier.com', 'WAFID5678TY007C', 'account1.png', '3417 Gulf Breeze Pkwy, Gulf Breeze, Florida', '2024-09-04 20:26:53'), (116, '66f84e7a89723', 'Robert', 'Andrich', NULL, '9909385958', 0, 1, 1522000, 1340, 0, 500000, 500000, 'Checkings', 'male', 'single', 'USD', 'hold', 'companymail8585@gmail.com', '4693284112', 'Engineer', '1965-08-17', '', NULL, NULL, 'United States of America', 'California', '$2y$10$7nx6muzigznoYgyd3PLfZe43S49aBP6mcVs2m5dYmdLDEjLorj0JO', NULL, NULL, '2163', NULL, '35720', '32887', '2163', 'Laura GregSon', '+18596940469', 'lauragregson.westamerica@financier.com', 'WAFID89028330', 'account1.png', '11301 Wilshire Blvd, California USA', '2024-09-28 19:44:10'), (117, '671a3496bcd2b', 'George', 'Lucas', '9909408459WhatsApp Image 2024-10-24 at 04.08.59_1345ec22.jpg', '9909408459', 1, 0, 8350700, 0, 0, 4000000, 950000, 'Current', 'male', 'single', 'Euro', 'active', 'georgelucas0023@gmail.com', '12252207852', 'Doctor', '1974-05-09', '', NULL, NULL, 'Poland', 'Karków', '$2y$10$JstS9t7QON2CEulWOPnONuP834ydJJb1tdy6g82J9xpqhH5n0z3nG', NULL, NULL, '3370', 212788, '32879', '21577', '198876', 'Laura Gregson', '+18596940469', 'lauragregson.westamerica@financier.com', 'WAF90TY67879', 'account1.png', 'Monte Cassino 6 Karków Poland', '2024-10-24 12:50:46'), (118, '6721697f79012', 'Aden', 'Lucas', '99091015354a8d4404.jpg', '9909101535', 1, 0, 0, 205, 0, 1000000, -10251000, 'Checkings', 'male', 'single', 'USD', 'active', 'dradenlucas@gmail.com', '12132543449', 'Doctor', '1974-05-09', '', NULL, NULL, 'United States of America', 'Ohio', '$2y$10$h1eEeh00YljMAzmXsrU47.ffEnb5VTL4U2oQA7hR3AnGedc33BnHG', NULL, NULL, '2109', 581981, '43234', '32287', 'TAX21096555', 'Laura Gregson', '+18596940469', 'lauragregson.westamerica@financier.com', 'WAFID789YU0KL', 'account1.png', '408 W St Clair Ave, Cleveland Ohio, United States', '2024-10-30 00:02:23'), (119, '6731286a83f99', 'Zhang', 'Chen', '9909500561_761b55d4.jpg', '9909500561', 0, 1, 10100000, 240, 0, 1000000, 1000000, 'Checkings', 'male', 'single', 'USD', 'active', 'zhangchen4596150@gmail.com', '84585227810', 'Doctor', '1964-02-04', '', NULL, NULL, 'United States of America', 'California', '$2y$10$r4TciUoNWw7FTs2pZ05IjuAbcN3kLkMFF4gtPY1ZzvmTdsdDJVp0K', NULL, NULL, '3264', NULL, '41432', '65437', '7509', 'Laura Gregson', '+18596940469', 'lauragregson.westamerica@financier.com', 'WAFID5772890284', 'account1.png', '4930 Angie Drive, Los Angeles, CA 90017 USA', '2024-11-10 22:40:58'), (120, '67337e6dc9471', 'Patrick', 'Lorenzo', '9909139001.14_93ccf6e2.jpg', '9909139001', 0, 1, 8066480, 234, 0, 500000, 500000, 'Checkings', 'male', 'single', 'USD', 'active', 'Patricklorenzo767@gmail.com', '1510698042', 'Engineer', '1966-06-21', '', NULL, NULL, 'United States of America', 'Florida', '$2y$10$Wop1DRtgl5bD9KAat5X/iuzZaR.K3U4B2OXsSoi7kXsI8LFB/bUlK', NULL, NULL, '3257', NULL, '54267', '63098', '5890', 'Laura Gregson', '+18596940469', 'lauragregson.westamerica@financier.com', 'WAFID678494957390', 'account1.png', '210 S Elgin St Jacksonville, Florida, 65260 USA', '2024-11-12 17:12:29'), (121, '673d88af955bd', 'Douglas', 'Henry', '9909955385.34.44_5cf3c8a5.jpg', '9909955385', 0, 1, 6060000, 220, 0, 1000000, 1000000, 'Checkings', 'male', 'single', 'USD', 'active', 'henrydouglas2428@gmail.com', '12252207852', 'Surgeon', '1974-04-11', '', NULL, NULL, 'United States of America', 'New York', '$2y$10$rA79uuCq7i6Tv6wSOfWsgeXr5abKLXZaa6oamErZmxNm1z3.8DAwO', NULL, NULL, '3454', NULL, '43455', '32234', 'TAX9900433454', 'Laura Gregson', '+18596940469', 'lauragregson.westamerica@financier.com', 'WAFID689YU90889GH', 'account1.png', '93 Ridgedale Cir, Rochester New York 14616 USA', '2024-11-20 07:58:55'), (122, '673ea04373746', 'Kendall', 'Wallance', '99093242038.38.47_8caf20d9.jpg', '9909324203', 0, 1, 10850000, 312, 0, 500000, 500000, 'Checkings', 'male', 'single', 'USD', 'active', 'kendallwallance@gmail.com', '19942194048', 'Engineer', '1996-07-18', '', NULL, NULL, 'United States of America', 'Minnesota', '$2y$10$jUnKs4z8VUhwb9.76SDazeT.c/E2ZfHfBbnVGLrLpKlxeFqjWimYu', NULL, NULL, '3233', NULL, '543445', '66544', '4278', 'Laura Gregson', '+18596940469', 'kendallwallance@gmail.com', 'WAFID789YU778', 'account1.png', 'St.Paul Minneapolis, Minnesota United States', '2024-11-21 03:51:47'), (123, '675319f6c67b9', 'Mike', 'Montana', '990912578106.21.48_bba103a1.jpg', '9909125781', 0, 1, 187, 23, 0, 500000, -730000, 'Checkings', 'male', 'single', 'USD', 'active', 'montanamike922@gmail.com', '12409371955', 'Military', '1984-02-21', '', NULL, NULL, 'United States of America', 'Florida', '$2y$10$cgqdpamaWx.N23ZNXZagq.QTCuIcJAzptDQO5tWiDPz5s6LqtUMY2', NULL, NULL, '2709', 112247, '43345', '15885', '2709', 'Laura Gregson', '+18596940469', 'lauragregson.westamerica@financier.com', 'WAFIDTY783748P', 'account1.png', '3779 McDonald Avenue, Orlando Florida United States', '2024-12-06 16:36:23'), (124, '676972f19c8b2', 'Kaan', 'Farah Simon', '99098150731.43_6c4d4441.jpg', '9909815073', 0, 1, 50, 23, 0, 1000000, -10299950, 'Checkings', 'male', 'single', 'USD', 'active', 'kaanfarahsimon@gmail.com', '16165970042', 'Business Mogul', '1974-04-14', '', NULL, NULL, 'United States of America', 'Texas', '$2y$10$3HBVtiHKGu8D9fq.KSIXFePAf4xxNpJd.6vZcP8ZegV.7mMm6lFTa', NULL, NULL, '3465', 248371, '43235', '79086', '3429', 'Laura Gregson', '+18596940469', 'lauragregson.westamerica@financier.com', 'California', 'account1.png', '11800 Magnolia Pkwy ste 210, Manvel, TX 77578, United States', '2024-12-23 15:25:53'); -- -------------------------------------------------------- -- -- Table structure for table `v_bank` -- CREATE TABLE `v_bank` ( `id` int(11) NOT NULL, `bank_name` text NOT NULL, `routine_no` text NOT NULL, `acct_no` text NOT NULL, `swift_code` text NOT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -------------------------------------------------------- -- -- 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 NOT NULL, `amount` double NOT NULL DEFAULT 0, `bank_name` text DEFAULT NULL, `acct_name` text DEFAULT NULL, `acct_number` varchar(200) NOT NULL, `trans_type` varchar(50) NOT NULL DEFAULT 'wire transfer', `acct_type` varchar(50) NOT NULL, `acct_country` text DEFAULT NULL, `acct_swift` varchar(50) DEFAULT NULL, `acct_routing` varchar(50) NOT NULL, `acct_remarks` text DEFAULT NULL, `wire_status` int(11) NOT NULL DEFAULT 0, `createdAt` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_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`, `createdAt`) VALUES (1, 108, '66664fe45c6e0', 12800, 'TechomTrust Bank', 'Thorry Bendina', '3626183837', 'wire transfer', 'Savings', 'Vietnam', '6772727&', '08372637', 'Family concern', 0, '2024-06-10 01:59:16'), (2, 108, '66665938b1803', 2400, 'Bank Of American', 'Barry Medley', '1093737399', 'wire transfer', 'Checking', '', '', '', 'Family concern', 0, '2024-06-10 02:39:04'), (3, 108, '66665938b17c4', 2400, 'Bank Of American', 'Barry Medley', '1093737399', 'wire transfer', 'Checking', '', '', '', 'Family concern', 2, '2024-06-10 02:39:04'), (4, 107, '6668daaa6ae93', 45, 'Banco do Brasil', 'Conta corrente', '690783', 'wire transfer', 'Current', 'Brazil', '9822', '32690398249', 'Ordem de pagamento', 0, '2024-06-12 00:15:54'), (5, 107, '6668daab12cb3', 45, 'Banco do Brasil', 'Conta corrente', '690783', 'wire transfer', 'Current', 'Brazil', '9822', '32690398249', 'Ordem de pagamento', 0, '2024-06-12 00:15:55'), (6, 107, '6668daabcf3cd', 45, 'Banco do Brasil', 'Conta corrente', '690783', 'wire transfer', 'Current', 'Brazil', '9822', '32690398249', 'Ordem de pagamento', 0, '2024-06-12 00:15:55'), (7, 107, '6668daabcf3e4', 45, 'Banco do Brasil', 'Conta corrente', '690783', 'wire transfer', 'Current', 'Brazil', '9822', '32690398249', 'Ordem de pagamento', 0, '2024-06-12 00:15:55'), (8, 107, '6668dea51f6ed', 45, 'Banco do Brasil', 'Banco do Brasil', '690783', 'wire transfer', 'Checking', 'Brazil', '9822', '32690398249', 'Ordem de pagamento', 0, '2024-06-12 00:32:53'), (9, 107, '6668dea51f6c1', 45, 'Banco do Brasil', 'Banco do Brasil', '690783', 'wire transfer', 'Checking', 'Brazil', '9822', '32690398249', 'Ordem de pagamento', 0, '2024-06-12 00:32:53'), (10, 107, '6668dea51f652', 45, 'Banco do Brasil', 'Banco do Brasil', '690783', 'wire transfer', 'Checking', 'Brazil', '9822', '32690398249', 'Ordem de pagamento', 0, '2024-06-12 00:32:53'), (11, 107, '6668dea56d79a', 45, 'Banco do Brasil', 'Banco do Brasil', '690783', 'wire transfer', 'Checking', 'Brazil', '9822', '32690398249', 'Ordem de pagamento', 0, '2024-06-12 00:32:53'), (12, 107, '6668dea521e18', 45, 'Banco do Brasil', 'Banco do Brasil', '690783', 'wire transfer', 'Checking', 'Brazil', '9822', '32690398249', 'Ordem de pagamento', 0, '2024-06-12 00:32:53'), (13, 107, '6668e2185c4c2', 45000, 'Banco do Brasil', 'Banco do Brasil', '690783', 'wire transfer', 'Checking', 'Brazil', '9822', '32690398249', 'Ordem de pagamento', 2, '2024-06-12 00:47:36'), (14, 111, '66a3a85d7fdd2', 35000, 'Bank SA', 'Tyrone Kovacs', '062197640', 'wire transfer', 'Savings', 'Australia', 'SGBLAU2S', '021000021', 'savings', 2, '2024-07-26 14:45:01'), (16, 117, '673baac7f0a0a', 50000, 'Ziraat Bankası', 'Kamile Akbeniz', '2561407439815010', 'wire transfer', 'Online Banking', 'Turkey', '(BIC) TCZBTR2AXXX', '409993', 'Ä°htiyaç', 2, '2024-11-18 21:59:51'), (17, 123, '6753fc1726a37', 1230000, 'REVOLUT LTD, LONDON, UK', 'Mahvash zarie', '0483528423852300', 'wire transfer', 'Savings', 'Switzerland', 'CRESCHZZ80A', '96140117', 'Family support', 2, '2024-12-07 08:41:11'), (18, 123, '6753fc173a46a', 1230000, 'REVOLUT LTD, LONDON, UK', 'Mahvash zarie', '0483528423852300', 'wire transfer', 'Savings', 'Switzerland', 'CRESCHZZ80A', '96140117', 'Family support', 2, '2024-12-07 08:41:11'), (19, 124, '676b22412b1e4', 11299850, 'Garanti', 'ErÅŸah Demirci', '270006200004400006881777', 'wire transfer', 'Online Banking', 'Turkey', 'TR270006200004400006881777', '270006200004400006881777', '', 2, '2024-12-24 22:06:09'); -- -------------------------------------------------------- -- -- 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, `trans_type` int(11) NOT NULL, `wallet_address` text NOT NULL, `bankname` text NOT NULL, `account_number` text NOT NULL, `routineno` text NOT NULL, `acctname` text NOT NULL, `status` int(11) NOT NULL DEFAULT 0, `createdAt` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `withdrawal` -- INSERT INTO `withdrawal` (`id`, `reference_id`, `user_id`, `amount`, `withdraw_method`, `trans_type`, `wallet_address`, `bankname`, `account_number`, `routineno`, `acctname`, `status`, `createdAt`) VALUES (1, '66a3a99a7c118', 111, 2000, '1', 2, '1BzqnBQ8uQ8LZUUHXq68HuDH7vQytfgaiw', '', '', '', '', 2, '2024-07-26 13:50:18'); -- -- 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 `messages` -- ALTER TABLE `messages` ADD PRIMARY KEY (`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 `v_bank` -- ALTER TABLE `v_bank` 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=192; -- -- AUTO_INCREMENT for table `card` -- ALTER TABLE `card` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `card_request` -- ALTER TABLE `card_request` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `crypto_currency` -- ALTER TABLE `crypto_currency` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=56; -- -- AUTO_INCREMENT for table `deposit` -- ALTER TABLE `deposit` MODIFY `d_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `domestic_transfer` -- ALTER TABLE `domestic_transfer` MODIFY `dom_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `loan` -- ALTER TABLE `loan` MODIFY `loan_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `messages` -- ALTER TABLE `messages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- 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=56; -- -- AUTO_INCREMENT for table `transactions` -- ALTER TABLE `transactions` MODIFY `trans_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=106; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=125; -- -- AUTO_INCREMENT for table `v_bank` -- ALTER TABLE `v_bank` 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=20; -- -- AUTO_INCREMENT for table `withdrawal` -- ALTER TABLE `withdrawal` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; 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 */;