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

START TRANSACTION;



--
-- 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&amp;ccedil; &amp;ouml;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&amp;amp;', '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&amp;aacute;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&amp;aacute;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&amp;aacute;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&amp;aacute;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&amp;ccedil;', 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&amp;oacute;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&amp;oacute;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&amp;amp;amp;', '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&amp;amp;ccedil;', 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;

