-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jun 29, 2026 at 06:17 PM -- Server version: 11.4.12-MariaDB-cll-lve-log -- PHP Version: 8.4.21 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: `sfoseeax_vt` -- Cleaned/updated transactions_history_entries data for June 30 package -- -- -------------------------------------------------------- -- -- Table structure for table `broad_casts` -- CREATE TABLE `broad_casts` ( `id` int(11) NOT NULL, `title` text DEFAULT NULL, `description` text DEFAULT NULL, `time` time DEFAULT NULL, `contentType` text DEFAULT NULL, `marqueeText` text DEFAULT NULL, `image` text DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `broad_casts` -- INSERT INTO `broad_casts` (`id`, `title`, `description`, `time`, `contentType`, `marqueeText`, `image`, `user_id`, `created_at`, `updated_at`) VALUES (1, 'Migistrate Court', 'Every effort IS being made to provide a satisfactory streaming service of the magistrates Court judgment and hearing. However, these services may be subject to technical\r\nIssues or delays, In which case we Will attempt to resolve them as soon as possible. We Will provide regular updates on any Issues.\r\n\r\nThis footage IS made available for the sole purpose of the fair and accurate reporting of the judicial proceedings of the Magistrate Court Although you are welcome to View\r\nthese proceedings, the re-use, capture, re-editing or redistribution of this footage In any form is not permitted. You should be aware that any such use could attract liability\r\nfor breach of copyright or defamation and In some circumstances could constitute contempt of court', '23:53:00', 'video', 'Davies Steven, Bradbury Suzanne Louise, Teasdale, Russell Vine, Theydon Secretaries Limited & Theydon Nominees Limited) (POWER TRADE LIMITED 01 /05/2025 13:00pm (BST) City of London Magistrates Court room 3', 'https://www.youtube.com/watch?v=5dNm6EYL1b0', 5, '2025-01-06 12:19:09', '2025-05-01 19:14:21'), (2, 'Migistrate Court', 'Every effort is being made to provide a satisfactory streaming service of the magistrates Court judgment and hearing. However, these services may be subject to technical Issues or delays, In which case we will attempt to resolve them as soon as possible. We Will provide regular updates on any Issues. This footage is made available for the sole purpose of the fair and accurate reporting of the judicial proceedings of the Magistrate Court Although you are welcome to view these proceedings, the re-use, capture, re-editing or redistribution of this footage in any form is not permitted. You should be aware that any such use could attract liability for breach of copyright or defamation and in some circumstances could constitute contempt of court.', '14:47:00', 'video', 'Not Available', 'https://www.youtube.com/watch?v=IShDpXap_z0', 4, '2025-01-14 13:48:32', '2025-01-14 13:48:32'), (3, 'Migistrate Court', '111Every effort IS being made to provide a satisfactory streaming service of the magistrates Court judgment and hearing. However, these services may be subject to technical\r\nIssues or delays, In which case we Will attempt to resolve them as soon as possible. We Will provide regular updates on any Issues.\r\n\r\nThis footage IS made available for the sole purpose of the fair and accurate reporting of the judicial proceedings of the Magistrate Court Although you are welcome to View\r\nthese proceedings, the re-use, capture, re-editing or redistribution of this footage In any form is not permitted. You should be aware that any such use could attract liability\r\nfor breach of copyright or defamation and In some circumstances could constitute contempt of court', '14:49:00', 'video', 'Claimant [RANTA PATTI –ANNE] vs Defendant [Davies Steven , Bradbury Suzanne Louise , Teasdale, Russell Vine, Theydon Secretaries Limited & Theydon Nominees] Hearing pending.', 'https://www.youtube.com/watch?v=IShDpXap_z0', 3, '2025-01-14 13:50:12', '2025-01-14 17:39:19'), (4, 'Migistrate Court', 'Every effort IS being made to provide a satisfactory streaming service of the magistrates Court judgment and hearing. However, these services may be subject to technical\r\nIssues or delays, In which case we Will attempt to resolve them as soon as possible. We Will provide regular updates on any Issues.\r\n\r\nThis footage IS made available for the sole purpose of the fair and accurate reporting of the judicial proceedings of the Magistrate Court Although you are welcome to View\r\nthese proceedings, the re-use, capture, re-editing or redistribution of this footage In any form is not permitted. You should be aware that any such use could attract liability\r\nfor breach of copyright or defamation and In some circumstances could constitute contempt of court', '08:52:00', 'video', 'Claimant [RANTA PATTI –ANNE] vs Defendant [Davies Steven , Bradbury Suzanne Louise , Teasdale, Russell Vine, Theydon Secretaries Limited & Theydon Nominees] Hearing pending.', 'https://www.youtube.com/watch?v=IShDpXap_z0', NULL, '2025-01-14 13:52:57', '2025-01-14 13:52:57'), (5, '324324', 'rewrwerw', '14:59:00', 'image', 'rwrwr', 'broadcast_images/1736845122_2025-01-07_022044.png', NULL, '2025-01-14 13:58:42', '2025-01-14 13:58:42'), (6, 'erwwr', 'rwrwr', '15:00:00', 'image', 'rwrw', 'broadcast_images/1736845243_2025-01-07_022044.png', NULL, '2025-01-14 14:00:43', '2025-01-14 14:00:43'), (7, 'kutta', 'kutta', '03:04:00', 'video', 'kutta', 'https://youtu.be/IShDpXap_z0?si=tKv4mgt50O7tZNjC', 4, '2025-01-14 14:05:02', '2025-01-14 14:05:02'); -- -------------------------------------------------------- -- -- Table structure for table `case_activity_tables` -- CREATE TABLE `case_activity_tables` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` int(10) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `case_activity_tables` -- INSERT INTO `case_activity_tables` (`id`, `user_id`, `created_at`, `updated_at`) VALUES (1, 2, '2023-12-14 21:53:48', '2023-12-14 21:53:48'), (2, 2, '2023-12-14 21:53:48', '2023-12-14 21:53:48'), (9, 4, '2024-06-22 14:29:23', '2024-06-22 14:29:23'), (8, 4, '2024-02-20 17:04:09', '2024-02-20 17:04:09'), (10, 4, '2024-06-22 14:33:22', '2024-06-22 14:33:22'), (11, 4, '2024-06-22 15:15:53', '2024-06-22 15:15:53'), (12, 4, '2024-06-22 15:44:35', '2024-06-22 15:44:35'), (13, 4, '2024-06-22 16:33:56', '2024-06-22 16:33:56'), (14, 4, '2024-06-22 16:40:24', '2024-06-22 16:40:24'), (15, 2, '2024-06-22 18:14:57', '2024-06-22 18:14:57'), (16, 4, '2024-06-22 18:24:29', '2024-06-22 18:24:29'), (17, 2, '2024-06-23 23:49:11', '2024-06-23 23:49:11'), (18, 4, '2024-06-23 23:55:12', '2024-06-23 23:55:12'), (19, 4, '2024-06-25 06:31:23', '2024-06-25 06:31:23'), (20, 4, '2024-06-25 06:33:15', '2024-06-25 06:33:15'), (21, 4, '2024-06-25 06:38:02', '2024-06-25 06:38:02'), (22, 4, '2024-06-25 06:43:06', '2024-06-25 06:43:06'), (23, 2, '2024-06-25 06:47:26', '2024-06-25 06:47:26'), (24, 2, '2024-06-25 06:50:19', '2024-06-25 06:50:19'), (25, 2, '2024-06-25 06:54:08', '2024-06-25 06:54:08'), (26, 2, '2024-06-25 06:56:53', '2024-06-25 06:56:53'), (27, 2, '2024-06-25 06:58:38', '2024-06-25 06:58:38'), (28, 2, '2024-06-25 07:01:38', '2024-06-25 07:01:38'), (29, 2, '2024-06-25 07:01:52', '2024-06-25 07:01:52'), (30, 2, '2024-06-25 07:02:41', '2024-06-25 07:02:41'), (31, 2, '2024-06-25 07:03:16', '2024-06-25 07:03:16'), (32, 2, '2024-06-25 07:03:45', '2024-06-25 07:03:45'), (33, 2, '2024-06-25 07:06:59', '2024-06-25 07:06:59'), (34, 2, '2024-06-25 07:07:37', '2024-06-25 07:07:37'), (35, 2, '2024-06-25 07:08:32', '2024-06-25 07:08:32'), (36, 2, '2024-06-25 07:10:35', '2024-06-25 07:10:35'), (37, 2, '2024-06-25 07:11:59', '2024-06-25 07:11:59'), (38, 2, '2024-06-25 07:13:48', '2024-06-25 07:13:48'), (39, 4, '2024-06-25 07:47:55', '2024-06-25 07:47:55'), (40, 4, '2024-06-25 08:05:05', '2024-06-25 08:05:05'), (41, 4, '2024-06-25 08:08:32', '2024-06-25 08:08:32'), (42, 4, '2024-06-25 08:10:49', '2024-06-25 08:10:49'), (43, 4, '2024-06-25 08:13:38', '2024-06-25 08:13:38'), (44, 5, '2025-01-04 02:49:26', '2025-01-04 02:49:26'), (45, 2, '2025-01-17 00:04:17', '2025-01-17 00:04:17'), (46, 2, '2025-01-17 00:10:57', '2025-01-17 00:10:57'), (47, 2, '2025-01-17 00:11:20', '2025-01-17 00:11:20'), (48, 2, '2025-01-17 00:11:20', '2025-01-17 00:11:20'), (49, 2, '2025-01-18 02:20:47', '2025-01-18 02:20:47'), (50, 2, '2025-01-18 02:27:53', '2025-01-18 02:27:53'), (51, 2, '2025-02-22 22:50:22', '2025-02-22 22:50:22'), (52, 2, '2025-02-22 22:51:12', '2025-02-22 22:51:12'), (53, 2, '2025-02-22 22:51:13', '2025-02-22 22:51:13'), (54, 2, '2025-02-22 22:51:13', '2025-02-22 22:51:13'), (55, 2, '2025-02-22 22:59:39', '2025-02-22 22:59:39'), (56, 6, '2025-06-17 22:51:19', '2025-06-17 22:51:19'), (57, 6, '2025-06-27 22:33:00', '2025-06-27 22:33:00'), (58, 6, '2025-06-27 22:34:37', '2025-06-27 22:34:37'), (59, 6, '2025-06-27 22:41:59', '2025-06-27 22:41:59'); -- -------------------------------------------------------- -- -- Table structure for table `case_activity_table_data` -- CREATE TABLE `case_activity_table_data` ( `id` bigint(20) UNSIGNED NOT NULL, `case_activity_table_id` bigint(20) UNSIGNED NOT NULL, `notification_event` varchar(255) DEFAULT NULL, `notification_event_color` varchar(255) DEFAULT NULL, `agency` varchar(255) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `investigative_case_number` varchar(255) DEFAULT NULL, `defendants` varchar(255) DEFAULT NULL, `event_date` datetime DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `custom` text DEFAULT NULL, `account` text DEFAULT NULL, `transaction_status` text DEFAULT NULL, `transaction_id` text DEFAULT NULL, `transaction_amount` text DEFAULT NULL, `transaction_status_color` text DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `case_activity_table_data` -- INSERT INTO `case_activity_table_data` (`id`, `case_activity_table_id`, `notification_event`, `notification_event_color`, `agency`, `description`, `investigative_case_number`, `defendants`, `event_date`, `created_at`, `updated_at`, `custom`, `account`, `transaction_status`, `transaction_id`, `transaction_amount`, `transaction_status_color`) VALUES (37, 37, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-25 07:11:59', '2025-04-23 15:09:58', '{\"Notification Event\":\"Disbursement\",\"Account\":\"GD BGLAZING PRODUCTS\",\"Transaction Status\":\"Declined\",\"Transaction Status Color\":\"Red\",\"Event Date\":\"23\\/04\\/2025 11:00am\",\"Agency\":\"HM Revenue & Customs\",\"Transaction Id\":\"HMRC2141011\",\"Transaction Amount\":\"(\\u00a3) 80,837.5812\",\"Description\":\"Your transaction has declined account error. Contact the disbursement unit for more information.\"}', NULL, NULL, NULL, NULL, NULL), (43, 43, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-25 08:13:38', '2026-04-01 15:40:59', '{\"Notification Event\":\"Disbursement\",\"Agency\":\"FSCS (Financial Services Compensation Scheme)\",\"Description\":\"Congratulation on the successful completion of your signoff process .Nevertheless it is essential to complete your transaction clearance fee , kindly visit your invoice section for further information . On the completion of your fees, your transaction will be completed.\",\"Event Date\":\"01\\/04 \\/2026 11: 30am\",\"Transaction Status\":\"PENDING\",\"Account\":\"STANLEY YEW SAN INVESTMENTS LTD 0683659\",\"Transaction Id\":\"HMRC 8632075\",\"Transaction Amount\":\"\\u00a3108,799\",\"Transaction Status Color\":\"orange\"}', NULL, NULL, NULL, NULL, NULL), (44, 44, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-04 02:49:26', '2025-05-29 09:10:09', '{\"Notification Event\":\"Interview\",\"Transaction Status Color\":\"green\",\"Agency\":\"HM Court & Tribunal Services\",\"Investigative Case Number\":\"Sealed\",\"Defendant(s)\":\"Davies Steven, Bradbury Suzanne Louise, Teasdale, Russell Vine, Theydon Secretaries Limited & Theydon Nominees Limited) (POWER TRADE LIMITED\",\"Date\":\"09\\/06\\/2025 9:00am (BST)\",\"Venue\":\"City of London Magistrates Court room 2\",\"Description\":\"Hearing\"}', NULL, NULL, NULL, NULL, NULL), (59, 59, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-06-27 22:41:59', '2026-05-28 18:13:03', '{\"Notification Event\":\"Disbursement\",\"Transaction Status Color\":\"orange\",\"Agency\":\"His Majesty\'s Revenue and Customs\",\"Account\":\"SOTIRIS PETROU (G D BGLAZING PRODUCTS LTD) 70015709\",\"Transaction ID\":\"HMRC3145818\",\"Transaction Amount\":\"(\\u00a3) 63,812.591\",\"Transaction Status\":\"PENDING\",\"Description\":\"We are currently reviewing your transaction on the completion of the review process. Your transfer code would be issued to the primary recipient\' email to complete the transaction.\",\"Event Date\":\"27\\/05\\/2026 7:00 am\"}', NULL, NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `investigate_case_data` -- CREATE TABLE `investigate_case_data` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` int(10) UNSIGNED NOT NULL, `investigative_case_number` varchar(255) DEFAULT NULL, `investigative_case_status` varchar(255) DEFAULT NULL, `contact_person` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `investigate_case_data` -- INSERT INTO `investigate_case_data` (`id`, `user_id`, `investigative_case_number`, `investigative_case_status`, `contact_person`, `created_at`, `updated_at`) VALUES (1, 2, 'Sealed', 'Concluded', 'Timothy Sanders', '2023-12-15 04:28:19', '2023-12-27 17:16:11'), (2, 4, 'PENDING', 'ACTIVE', 'TIMOTHY W .SANDERS', '2023-12-15 09:38:09', '2023-12-20 00:16:09'), (3, 5, 'Sealed', 'ACTIVE', 'Timothy Sanders', '2025-01-04 02:46:33', '2025-01-04 02:46:33'), (4, 6, 'Sealed', 'Active', 'Aron Loeb', '2025-06-17 22:49:32', '2025-06-17 22:49:32'); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2014_10_12_100000_create_password_resets_table', 1), (2, '2016_06_01_000001_create_oauth_auth_codes_table', 1), (3, '2016_06_01_000002_create_oauth_access_tokens_table', 1), (4, '2016_06_01_000003_create_oauth_refresh_tokens_table', 1), (5, '2016_06_01_000004_create_oauth_clients_table', 1), (6, '2016_06_01_000005_create_oauth_personal_access_clients_table', 1), (7, '2019_09_10_000000_create_permissions_table', 1), (8, '2019_09_10_000001_create_roles_table', 1), (9, '2019_09_10_000002_create_users_table', 1), (10, '2019_09_10_000003_create_permission_role_pivot_table', 1), (11, '2019_09_10_000004_create_role_user_pivot_table', 1), (12, '2019_09_10_181218_add_username_to_users_table', 1), (13, '2023_07_23_163735_add_extra_fields_to_users_table', 2), (14, '2023_08_02_053235_create_my_additional_contacts_table', 3); -- -------------------------------------------------------- -- -- Table structure for table `my_additional_contacts` -- CREATE TABLE `my_additional_contacts` ( `id` bigint(20) UNSIGNED NOT NULL, `additional_contact` varchar(255) NOT NULL, `contact_name` varchar(255) DEFAULT NULL, `additional_contact_type` varchar(255) NOT NULL, `investigative_case_number` varchar(255) NOT NULL, `receive_notifications` varchar(255) DEFAULT NULL, `uid` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `my_additional_contacts` -- INSERT INTO `my_additional_contacts` (`id`, `additional_contact`, `contact_name`, `additional_contact_type`, `investigative_case_number`, `receive_notifications`, `uid`, `created_at`, `updated_at`) VALUES (2, 'yes', 'Timothy Sanders', 'Attorney', 'yes', 'on', '2', '2023-09-06 00:11:41', '2023-09-06 00:11:41'); -- -------------------------------------------------------- -- -- Table structure for table `oauth_access_tokens` -- CREATE TABLE `oauth_access_tokens` ( `id` varchar(100) NOT NULL, `user_id` bigint(20) DEFAULT NULL, `client_id` int(10) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `scopes` text DEFAULT NULL, `revoked` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `expires_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `oauth_auth_codes` -- CREATE TABLE `oauth_auth_codes` ( `id` varchar(100) NOT NULL, `user_id` bigint(20) NOT NULL, `client_id` int(10) UNSIGNED NOT NULL, `scopes` text DEFAULT NULL, `revoked` tinyint(1) NOT NULL, `expires_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `oauth_clients` -- CREATE TABLE `oauth_clients` ( `id` int(10) UNSIGNED NOT NULL, `user_id` bigint(20) DEFAULT NULL, `name` varchar(255) NOT NULL, `secret` varchar(100) NOT NULL, `redirect` text NOT NULL, `personal_access_client` tinyint(1) NOT NULL, `password_client` tinyint(1) NOT NULL, `revoked` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `oauth_personal_access_clients` -- CREATE TABLE `oauth_personal_access_clients` ( `id` int(10) UNSIGNED NOT NULL, `client_id` int(10) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `oauth_refresh_tokens` -- CREATE TABLE `oauth_refresh_tokens` ( `id` varchar(100) NOT NULL, `access_token_id` varchar(100) NOT NULL, `revoked` tinyint(1) NOT NULL, `expires_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `password_resets` -- INSERT INTO `password_resets` (`email`, `token`, `created_at`) VALUES ('exdotech@gmail.com', '$2y$10$R6rpeonSuq4aTg9f1yPA5eeSheY.2JIoKy0JVlUxtHXEnFTh1fp7y', '2024-06-02 00:54:04'); -- -------------------------------------------------------- -- -- Table structure for table `permissions` -- CREATE TABLE `permissions` ( `id` int(10) UNSIGNED NOT NULL, `title` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `permissions` -- INSERT INTO `permissions` (`id`, `title`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'user_management_access', '2019-09-10 12:07:28', '2019-09-10 12:07:28', NULL), (2, 'permission_create', '2019-09-10 12:07:28', '2019-09-10 12:07:28', NULL), (3, 'permission_edit', '2019-09-10 12:07:28', '2019-09-10 12:07:28', NULL), (4, 'permission_show', '2019-09-10 12:07:28', '2019-09-10 12:07:28', NULL), (5, 'permission_delete', '2019-09-10 12:07:28', '2019-09-10 12:07:28', NULL), (6, 'permission_access', '2019-09-10 12:07:28', '2019-09-10 12:07:28', NULL), (7, 'role_create', '2019-09-10 12:07:28', '2019-09-10 12:07:28', NULL), (8, 'role_edit', '2019-09-10 12:07:28', '2019-09-10 12:07:28', NULL), (9, 'role_show', '2019-09-10 12:07:28', '2019-09-10 12:07:28', NULL), (10, 'role_delete', '2019-09-10 12:07:28', '2019-09-10 12:07:28', NULL), (11, 'role_access', '2019-09-10 12:07:28', '2019-09-10 12:07:28', NULL), (12, 'user_create', '2019-09-10 12:07:28', '2019-09-10 12:07:28', NULL), (13, 'user_edit', '2019-09-10 12:07:28', '2019-09-10 12:07:28', NULL), (14, 'user_show', '2019-09-10 12:07:28', '2019-09-10 12:07:28', NULL), (15, 'user_delete', '2019-09-10 12:07:28', '2019-09-10 12:07:28', NULL), (16, 'user_access', '2019-09-10 12:07:28', '2019-09-10 12:07:28', NULL), (17, 'show_menu', '2019-09-10 12:07:28', '2019-09-10 12:07:28', NULL); -- -------------------------------------------------------- -- -- Table structure for table `permission_role` -- CREATE TABLE `permission_role` ( `role_id` int(10) UNSIGNED NOT NULL, `permission_id` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `permission_role` -- INSERT INTO `permission_role` (`role_id`, `permission_id`) VALUES (1, 1), (1, 2), (1, 3), (1, 4), (1, 5), (1, 6), (1, 7), (1, 8), (1, 9), (1, 10), (1, 11), (1, 12), (1, 13), (1, 14), (1, 15), (1, 16), (3, 17); -- -------------------------------------------------------- -- -- Table structure for table `roles` -- CREATE TABLE `roles` ( `id` int(10) UNSIGNED NOT NULL, `title` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `roles` -- INSERT INTO `roles` (`id`, `title`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'Admin', '2019-09-10 11:56:03', '2019-09-10 11:56:03', NULL), (2, 'User', '2019-09-10 11:56:03', '2019-09-10 11:56:03', NULL), (3, 'Menu Settings', '2023-12-19 08:09:10', '2023-12-19 08:09:10', NULL); -- -------------------------------------------------------- -- -- Table structure for table `role_user` -- CREATE TABLE `role_user` ( `user_id` int(10) UNSIGNED NOT NULL, `role_id` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `role_user` -- INSERT INTO `role_user` (`user_id`, `role_id`) VALUES (1, 1), (3, 2), (5, 2), (6, 2), (2, 2), (4, 2), (5, 3); -- -------------------------------------------------------- -- -- Table structure for table `transactions_history_entries` -- CREATE TABLE `transactions_history_entries` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `date` date DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `amount` varchar(191) DEFAULT NULL, `status` varchar(100) DEFAULT NULL, `transaction_id` varchar(191) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `ref_id` varchar(191) DEFAULT NULL, `recipient` text DEFAULT NULL, `attorney_name` varchar(191) DEFAULT NULL, `location` text DEFAULT NULL, `total_amount` varchar(191) DEFAULT NULL, `refund_amount` varchar(191) DEFAULT NULL, `pending_transfers` tinyint(1) NOT NULL DEFAULT 0, `amount_words` text DEFAULT NULL, `button_text` varchar(191) DEFAULT NULL, `secure_note` text DEFAULT NULL, `processing_message` text DEFAULT NULL, `otp_code` varchar(10) DEFAULT NULL, `otp_expires_at` datetime DEFAULT NULL, `otp_verified` tinyint(1) NOT NULL DEFAULT 0, `otp_verified_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `transactions_history_entries` -- INSERT INTO `transactions_history_entries` (`id`, `user_id`, `date`, `description`, `amount`, `status`, `transaction_id`, `created_at`, `updated_at`, `deleted_at`, `ref_id`, `recipient`, `attorney_name`, `location`, `total_amount`, `refund_amount`, `pending_transfers`, `amount_words`, `button_text`, `secure_note`, `processing_message`, `otp_code`, `otp_expires_at`, `otp_verified`, `otp_verified_at`) VALUES (1, 6, NULL, NULL, '63.00', 'Complete Transaction', NULL, '2026-05-11 04:04:57', '2026-05-11 08:11:26', '2026-05-11 08:11:26', '#456789356', 'SOTIRIS PETROU (G D BGLAZING PRODUCTS LTD) 70015709', 'Aron loeb', '15, Afroditis, 2364, Agios Dometios, Nicosia, Cyprus', '£63,812.591', '£9571.8812', 0, 'Sixty-three thousand, eight hundred twelve pounds and fifty-nine pence only', NULL, 'YOUR TRANSACTION IS CURRENTLY PROCESSING YOU WOULD BE NOTIFIED ON THE COMPLETION OF YOUR TRANSACTION', NULL, NULL, NULL, 0, NULL), (2, 6, NULL, NULL, '0.00', 'Complete Transaction', NULL, '2026-05-11 04:11:10', '2026-05-15 17:54:16', '2026-05-15 17:54:16', '#456789356', 'SOTIRIS PETROU (G D BGLAZING PRODUCTS LTD) 70015709', 'Aron loeb', '15, Afroditis, 2364, Agios Dometios, Nicosia, Cyprus', '£63,812.591', '£9571.8812', 0, 'Sixty-three thousand, eight hundred twelve pounds and fifty-nine pence only', NULL, 'YOUR TRANSACTION IS CURRENTLY PROCESSING YOU WOULD BE NOTIFIED ON THE COMPLETION OF YOUR TRANSACTION', NULL, NULL, NULL, 0, NULL), (3, 6, NULL, NULL, '£63,812.591', NULL, NULL, '2026-05-15 17:53:18', '2026-05-15 17:54:20', '2026-05-15 17:54:20', '#456789356', 'SOTIRIS PETROU (G D BGLAZING PRODUCTS LTD) 70015709', 'Aron loeb', '15, Afroditis, 2364, Agios Dometios, Nicosia, Cyprus', '£63,812.591', '£95731.8812', 1, 'Sixty-three thousand, eight hundred twelve pounds and fifty-nine pence only', 'Complete Transaction', 'Securely encrypted transaction. Reference: WHIT FIELD ST LONDON W1T 4HD', 'YOUR TRANSACTION IS CURRENTLY PROCESSING YOU WOULD BE NOTIFIED ON THE COMPLETION OF YOUR TRANSACTION', NULL, NULL, 0, NULL), (4, 6, NULL, NULL, '£63,812.591', NULL, NULL, '2026-05-15 17:53:58', '2026-05-20 20:35:41', '2026-05-20 20:35:41', '#456789356', 'SOTIRIS PETROU (G D BGLAZING PRODUCTS LTD) 70015709', 'Aron loeb', '15, Afroditis, 2364, Agios Dometios, Nicosia, Cyprus', '£63,812.591', '£9954.7506', 1, 'Sixty-three thousand, eight hundred twelve pounds and fifty-nine pence only', 'Complete Transaction', 'Securely encrypted transaction. Reference: WHIT FIELD ST LONDON W1T 4HD', 'YOUR TRANSACTION IS CURRENTLY PROCESSING YOU WOULD BE NOTIFIED ON THE COMPLETION OF YOUR TRANSACTION', NULL, NULL, 0, NULL), (5, 6, NULL, NULL, '£63,812.591', NULL, NULL, '2026-05-20 20:35:35', '2026-05-28 18:19:10', '2026-05-28 18:19:10', '#456789356', 'SOTIRIS PETROU (G D BGLAZING PRODUCTS LTD) 70015709', 'Aron loeb', '15, Afroditis, 2364, Agios Dometios, Nicosia, Cyprus', '£63,812.591', '£10,656.6506', 1, 'Sixty-three thousand, eight hundred twelve pounds and fifty-nine pence only', 'Complete Transaction', 'Securely encrypted transaction. Reference: WHIT FIELD ST LONDON W1T 4HD', 'YOUR TRANSACTION IS CURRENTLY PROCESSING YOU WOULD BE NOTIFIED ON THE COMPLETION OF YOUR TRANSACTION', NULL, NULL, 0, NULL), (6, 6, NULL, NULL, '£63,812.591', NULL, NULL, '2026-05-28 18:18:58', '2026-05-28 18:20:25', '2026-05-28 18:20:25', '#456789356', 'SOTIRIS PETROU (G D BGLAZING PRODUCTS LTD) 70015709', 'Aron loeb', '15, Afroditis, 2364, Agios Dometios, Nicosia, Cyprus', '£63,812.591', '£9571.8812', 1, 'Sixty-three thousand, eight hundred twelve pounds and fifty-nine pence only', 'Complete Transaction', 'Securely encrypted transaction. Reference: WHIT FIELD ST LONDON W1T 4HD', 'YOUR TRANSACTION IS CURRENTLY PROCESSING YOU WOULD BE NOTIFIED ON THE COMPLETION OF YOUR TRANSACTION', NULL, NULL, 0, NULL), (7, 6, NULL, NULL, '£63,812.591', NULL, NULL, '2026-05-28 18:20:11', '2026-05-28 18:20:16', '2026-05-28 18:20:16', '#456789356', 'SOTIRIS PETROU (G D BGLAZING PRODUCTS LTD) 70015709', 'Aron loeb', '15, Afroditis, 2364, Agios Dometios, Nicosia, Cyprus', '£63,812.591', '17,685.4056', 1, 'Sixty-three thousand, eight hundred twelve pounds and fifty-nine pence only', 'Complete Transaction', 'Securely encrypted transaction. Reference: WHIT FIELD ST LONDON W1T 4HD', 'YOUR TRANSACTION IS CURRENTLY PROCESSING YOU WOULD BE NOTIFIED ON THE COMPLETION OF YOUR TRANSACTION', NULL, NULL, 0, NULL), (8, 6, NULL, NULL, '£63,812.591', NULL, NULL, '2026-05-28 18:20:31', '2026-06-19 11:35:28', NULL, '#456789356', 'SOTIRIS PETROU (G D BGLAZING PRODUCTS LTD) 70015709', 'Aron loeb', '15, Afroditis, 2364, Agios Dometios, Nicosia, Cyprus', '£63,812.591', '17,685.4056', 1, 'Sixty-three thousand, eight hundred twelve pounds and fifty-nine pence only', 'Transaction Completed', 'Securely encrypted transaction. Reference: WHIT FIELD ST LONDON W1T 4HD', 'YOUR TRANSACTION IS CURRENTLY PROCESSING YOU WOULD BE NOTIFIED ON THE COMPLETION OF YOUR TRANSACTION', '389553', '2026-06-19 07:45:28', 0, NULL), (9, 5, NULL, NULL, '£0000', NULL, NULL, '2026-06-27 01:42:10', '2026-06-27 01:42:10', NULL, '#456789356', 'SOTIRIS PETROU (G D BGLAZING PRODUCTS LTD) 70015709', 'Aron loeb', 'Location ( 3-SEATON PLACE DR STONEY CREEK, ON ,L8E 3E3)', '£63,812.591', '£2233', 1, 'Sixty-three thousand, eight hundred twelve pounds and fifty-nine pence only', 'PENDING', 'Securely encrypted transaction. Reference: WHIT FIELD ST LONDON W1T 4HD', 'YOUR TRANSACTION IS CURRENTLY PROCESSING YOU WOULD BE NOTIFIED ON THE COMPLETION OF YOUR TRANSACTION', NULL, NULL, 0, NULL), (10, 5, NULL, NULL, '£0000', NULL, NULL, '2026-06-27 01:44:02', '2026-06-27 01:44:14', '2026-06-27 01:44:14', '#456789356', 'SOTIRIS PETROU (G D BGLAZING PRODUCTS LTD) 70015709', 'Aron loeb', '3-SEATON PLACE DR STONEY CREEK, ON ,L8E 3E3', '£63,812.591', '£2233', 1, 'Sixty-three thousand, eight hundred twelve pounds and fifty-nine pence only', 'PENDING', 'Securely encrypted transaction. Reference: WHIT FIELD ST LONDON W1T 4HD', 'YOUR TRANSACTION IS CURRENTLY PROCESSING YOU WOULD BE NOTIFIED ON THE COMPLETION OF YOUR TRANSACTION', NULL, NULL, 0, NULL), (11, 5, NULL, NULL, '£63,44', NULL, NULL, '2026-06-28 03:08:26', '2026-06-28 03:08:34', '2026-06-28 03:08:34', '#456789356', 'SOTIRIS PETROU (G D BGLAZING PRODUCTS LTD) 70015709', 'Aron loeb', '15, Afroditis, 2364, Agios Dometios, Nicosia, Cyprus', '£63,812.591', '£9571.8812', 1, 'Sixty-three thousand, eight hundred twelve pounds and fifty-nine pence only', 'Complete Transaction', 'Securely encrypted transaction. Reference: WHIT FIELD ST LONDON W1T 4HD', 'YOUR TRANSACTION IS CURRENTLY PROCESSING YOU WOULD BE NOTIFIED ON THE COMPLETION OF YOUR TRANSACTION', NULL, NULL, 0, NULL); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `email_verified_at` datetime DEFAULT NULL, `password` varchar(255) NOT NULL, `remember_token` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `username` varchar(255) DEFAULT NULL, `contact_type` varchar(255) DEFAULT NULL, `contact_name` varchar(255) DEFAULT NULL, `residential_address` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `cell_phone` varchar(255) DEFAULT NULL, `country` varchar(255) DEFAULT NULL, `victim_name` varchar(255) DEFAULT NULL, `work_address` varchar(255) DEFAULT NULL, `work_phone` varchar(255) DEFAULT NULL, `work_cell_phone` varchar(255) DEFAULT NULL, `work_fax` varchar(255) DEFAULT NULL, `work_pager` varchar(255) DEFAULT NULL, `home_address` varchar(255) DEFAULT NULL, `home_phone` varchar(255) DEFAULT NULL, `home_cell_phone` varchar(255) DEFAULT NULL, `home_fax` varchar(255) DEFAULT NULL, `home_pager` varchar(255) DEFAULT NULL, `menu` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`menu`)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `deleted_at`, `username`, `contact_type`, `contact_name`, `residential_address`, `phone`, `cell_phone`, `country`, `victim_name`, `work_address`, `work_phone`, `work_cell_phone`, `work_fax`, `work_pager`, `home_address`, `home_phone`, `home_cell_phone`, `home_fax`, `home_pager`, `menu`) VALUES (1, 'Admin', 'rizvi.bhit@gmail.com', NULL, '$2y$10$rreo7aI2uor4g0h27GGyHeA9QOgZPO27eczPfBY3/yAZrCNrtAG6u', NULL, '2019-09-10 12:07:28', '2023-12-18 07:36:17', NULL, 'admin', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[\n {\n \"title\": \"Site Navigation\",\n \"sub_menus\": [\n {\n \"title\": \"Summary Information\",\n \"link\": \"/admin/summary\",\n \"new_tab\": false,\n \"show\": true\n },\n {\n \"title\": \"Case Activity Details\",\n \"link\": \"/admin/case-activity\",\n \"new_tab\": false,\n \"show\": true\n },\n {\n \"title\": \"Broadcast\",\n \"link\": \"/admin/broadcast\",\n \"new_tab\": false,\n \"show\": true\n },\n {\n \"title\": \"Claim Status\",\n \"link\": \"/images/claim Status (R0480- 61806-25825) (3).pdf\",\n \"new_tab\": true,\n \"show\": true\n },\n {\n \"title\": \"City Magistrate Court\",\n \"link\": \"/images/Claim Acceptance RANTA PATTI.pdf\",\n \"new_tab\": true,\n \"show\": true\n },\n {\n \"title\": \"News\",\n \"link\": \"https://thismoney.news/investment_scam_fraud_ring.html\",\n \"new_tab\": true,\n \"show\": true\n },\n {\n \"title\": \"2nd News\",\n \"link\": \"https://www.courtnews.uk\",\n \"new_tab\": true,\n \"show\": false\n },\n {\n \"title\": \"Add Broadcast\",\n \"link\": \"/admin/add-broadcast\",\n \"new_tab\": false,\n \"show\": true\n }\n ]\n },\n {\n \"title\": \"Related Links\",\n \"sub_menus\": [\n {\n \"title\": \"Victims Code\",\n \"link\": \"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/936239/victims-code-2020.pdf\",\n \"new_tab\": true,\n \"show\": true\n },\n {\n \"title\": \"Majestys Prison Service\",\n \"link\": \"https://www.gov.uk/government/organisations/hm-prison-service/about\",\n \"new_tab\": true,\n \"show\": true\n },\n {\n \"title\": \"National Crime Agency\",\n \"link\": \"https://www.nationalcrimeagency.gov.uk\",\n \"new_tab\": true,\n \"show\": true\n },\n {\n \"title\": \"Royal Mail\",\n \"link\": \"https://www.royalmail.com\",\n \"new_tab\": true,\n \"show\": true\n },\n {\n \"title\": \"Victim Rights\",\n \"link\": \"https://www.gov.uk/government/publications/the-code-of-practice-for-victims-of-crime/code-of-practice-for-victims-of-crime-in-england-and-wales-victims-code\",\n \"new_tab\": true,\n \"show\": true\n },\n {\n \"title\": \"Privacy Policy\",\n \"link\": \"https://www.gov.uk/help/privacy-notice\",\n \"new_tab\": true,\n \"show\": true\n }\n ]\n },\n {\n \"title\": \"My Account\",\n \"sub_menus\": [\n {\n \"title\": \"My Information\",\n \"link\": \"/admin\",\n \"new_tab\": false,\n \"show\": true\n },\n {\n \"title\": \"Help\",\n \"link\": \"https://www.victimsupport.org.uk/help-and-support/how-we-can-help\",\n \"new_tab\": true,\n \"show\": true\n },\n {\n \"title\": \"Invoice\",\n \"link\": \"/images/Invoice_16102023.pdf\",\n \"new_tab\": true,\n \"show\": true\n }\n ]\n }\n]\n'), (2, 'suellen186', 'exdotech@gmail.com', NULL, '$2y$10$uB7nVgir0TtzXUeXFnf6qeOcdxpVHQEtbee4hZphXjDE4N8uhG0W6', NULL, '2023-07-21 04:22:02', '2025-08-04 16:39:58', NULL, 'suellen186', 'ATTORNEY', 'TIMOTHY W .SANDERS', 'WHIT FIELD ST LONDON WIT 4HD', '+44 20 7097 1278', NULL, NULL, 'GARZA SUELLEN', '725 BELMONT DR, NEW BRAUNFELS TX 78130-2317', '12103267060', '12103267060', NULL, NULL, '725 BELMONT DR, NEW BRAUNFELS TX 78130-2317', '12103267060', '12103267060', NULL, NULL, '[{\"title\":\"Site Navigation\",\"sub_menus\":[{\"title\":\"Summary Information\",\"link\":\"\\/admin\\/summary\",\"new_tab\":false,\"show\":true},{\"title\":\"Case Activity Details\",\"link\":\"\\/admin\\/case-activity\",\"new_tab\":false,\"show\":true},{\"title\":\"Broadcast\",\"link\":\"\\/admin\\/broadcast\",\"new_tab\":false,\"show\":true},{\"title\":\"Claim Status\",\"link\":\"\\/images\\/CLAIM STATUS (942172).pdf\",\"new_tab\":true,\"show\":true},{\"title\":\"City Magistrate Court\",\"link\":\"\\/images\\/Claim Acceptance RANTA PATTI.pdf\",\"new_tab\":true,\"show\":true},{\"title\":\"News\",\"link\":\"https:\\/\\/thismoney.news\\/investment_scam_fraud_ring.html\",\"new_tab\":true,\"show\":true},{\"title\":\"2nd News\",\"link\":\"https:\\/\\/www.courtnews.uk\",\"new_tab\":true,\"show\":false},{\"title\":\"Add Broadcast\",\"link\":\"\\/admin\\/add-broadcast\",\"new_tab\":false,\"show\":true}]},{\"title\":\"Related Links\",\"sub_menus\":[{\"title\":\"Victims Code\",\"link\":\"https:\\/\\/assets.publishing.service.gov.uk\\/government\\/uploads\\/system\\/uploads\\/attachment_data\\/file\\/936239\\/victims-code-2020.pdf\",\"new_tab\":true,\"show\":true},{\"title\":\"Majestys Prison Service\",\"link\":\"https:\\/\\/www.gov.uk\\/government\\/organisations\\/hm-prison-service\\/about\",\"new_tab\":true,\"show\":true},{\"title\":\"National Crime Agency\",\"link\":\"https:\\/\\/www.nationalcrimeagency.gov.uk\",\"new_tab\":true,\"show\":true},{\"title\":\"Royal Mail\",\"link\":\"https:\\/\\/www.royalmail.com\",\"new_tab\":true,\"show\":true},{\"title\":\"Victim Rights\",\"link\":\"https:\\/\\/www.gov.uk\\/government\\/publications\\/the-code-of-practice-for-victims-of-crime\\/code-of-practice-for-victims-of-crime-in-england-and-wales-victims-code\",\"new_tab\":true,\"show\":true},{\"title\":\"Privacy Policy\",\"link\":\"https:\\/\\/www.gov.uk\\/help\\/privacy-notice\",\"new_tab\":true,\"show\":true}]},{\"title\":\"My Account\",\"sub_menus\":[{\"title\":\"My Information\",\"link\":\"\\/admin\",\"new_tab\":false,\"show\":true},{\"title\":\"Help\",\"link\":\"https:\\/\\/www.victimsupport.org.uk\\/help-and-support\\/how-we-can-help\",\"new_tab\":true,\"show\":true},{\"title\":\"Invoice\",\"link\":\"\\/images\\/Invoice_16102023.pdf\",\"new_tab\":true,\"show\":true},{\"title\":\"Transaction Activities\",\"link\":\"\\/admin\\/transaction_activities\",\"new_tab\":false,\"show\":true}]}]'), (3, 'rizvi', 'rizviahmed.badhon@gmail.com', NULL, '$2y$10$k8xvPqRXl4r4nCbL5vIVhOzM4NVtW5PlVnNDsDfjt8aBVcO8Ymli2', NULL, '2023-10-12 05:25:08', '2025-01-14 13:59:59', NULL, 'rizvi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[\n {\n \"title\": \"Site Navigation\",\n \"sub_menus\": [\n {\n \"title\": \"Summary Information\",\n \"link\": \"/admin/summary\",\n \"new_tab\": false,\n \"show\": true\n },\n {\n \"title\": \"Case Activity Details\",\n \"link\": \"/admin/case-activity\",\n \"new_tab\": false,\n \"show\": true\n },\n {\n \"title\": \"Broadcast\",\n \"link\": \"/admin/broadcast\",\n \"new_tab\": false,\n \"show\": true\n },\n {\n \"title\": \"Claim Status\",\n \"link\": \"/images/claim Status (R0480- 61806-25825) (3).pdf\",\n \"new_tab\": true,\n \"show\": true\n },\n {\n \"title\": \"City Magistrate Court\",\n \"link\": \"/images/Claim Acceptance RANTA PATTI.pdf\",\n \"new_tab\": true,\n \"show\": true\n },\n {\n \"title\": \"News\",\n \"link\": \"https://thismoney.news/investment_scam_fraud_ring.html\",\n \"new_tab\": true,\n \"show\": true\n },\n {\n \"title\": \"2nd News\",\n \"link\": \"https://www.courtnews.uk\",\n \"new_tab\": true,\n \"show\": false\n },\n {\n \"title\": \"Add Broadcast\",\n \"link\": \"/admin/add-broadcast\",\n \"new_tab\": false,\n \"show\": true\n }\n ]\n },\n {\n \"title\": \"Related Links\",\n \"sub_menus\": [\n {\n \"title\": \"Victims Code\",\n \"link\": \"https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/936239/victims-code-2020.pdf\",\n \"new_tab\": true,\n \"show\": true\n },\n {\n \"title\": \"Majestys Prison Service\",\n \"link\": \"https://www.gov.uk/government/organisations/hm-prison-service/about\",\n \"new_tab\": true,\n \"show\": true\n },\n {\n \"title\": \"National Crime Agency\",\n \"link\": \"https://www.nationalcrimeagency.gov.uk\",\n \"new_tab\": true,\n \"show\": true\n },\n {\n \"title\": \"Royal Mail\",\n \"link\": \"https://www.royalmail.com\",\n \"new_tab\": true,\n \"show\": true\n },\n {\n \"title\": \"Victim Rights\",\n \"link\": \"https://www.gov.uk/government/publications/the-code-of-practice-for-victims-of-crime/code-of-practice-for-victims-of-crime-in-england-and-wales-victims-code\",\n \"new_tab\": true,\n \"show\": true\n },\n {\n \"title\": \"Privacy Policy\",\n \"link\": \"https://www.gov.uk/help/privacy-notice\",\n \"new_tab\": true,\n \"show\": true\n }\n ]\n },\n {\n \"title\": \"My Account\",\n \"sub_menus\": [\n {\n \"title\": \"My Information\",\n \"link\": \"/admin\",\n \"new_tab\": false,\n \"show\": true\n },\n {\n \"title\": \"Help\",\n \"link\": \"https://www.victimsupport.org.uk/help-and-support/how-we-can-help\",\n \"new_tab\": true,\n \"show\": true\n },\n {\n \"title\": \"Invoice\",\n \"link\": \"/images/Invoice_16102023.pdf\",\n \"new_tab\": true,\n \"show\": true\n }\n ]\n }\n]\n'), (4, 'TAN STANLEY YEW SAN', 'tanstanley@gmail.com', NULL, '$2y$10$5gW8C9dAxS7nkRyng4xh5enBLWdGqw.3Q0qbdmzDHnwrcOvpaszKS', NULL, '2023-12-12 16:44:58', '2026-04-23 15:27:33', NULL, 'tanstanley', 'ATTORNEY', 'TIMOTHY W .SANDERS', 'WHIT FIELD ST LONDON WIT4HD', '+44 20 7097 1278', NULL, NULL, 'TAN STANLEY YEW SAN', NULL, NULL, NULL, NULL, NULL, '17 WEDGE ST SMITHTON 7330', NULL, '61403318789', NULL, NULL, '[{\"title\":\"Site Navigation\",\"sub_menus\":[{\"title\":\"Summary Information\",\"link\":\"\\/admin\\/summary\",\"new_tab\":false,\"show\":true},{\"title\":\"Case Activity Details\",\"link\":\"\\/admin\\/case-activity\",\"new_tab\":false,\"show\":true},{\"title\":\"Broadcast\",\"link\":\"\\/admin\\/broadcast\",\"new_tab\":false,\"show\":true},{\"title\":\"Claim Status\",\"link\":\"\\/images\\/CLAIM STATUS 0765423451 -2 (1)-1.pdf\",\"new_tab\":true,\"show\":true},{\"title\":\"City Magistrate Court\",\"link\":\"\\/images\\/SUMMONS (London magistrate court) (1).pdf\",\"new_tab\":true,\"show\":true},{\"title\":\"News\",\"link\":\"https:\\/\\/thismoney.news\\/investment_scam_fraud_ring.html\",\"new_tab\":true,\"show\":true},{\"title\":\"2nd News\",\"link\":\"https:\\/\\/www.courtnews.uk\",\"new_tab\":true,\"show\":false},{\"title\":\"Judgement\",\"link\":\"\\/images\\/CMC_LON_2024_SEALED_TAN_STANLEY_YEW_SAN_v_STATICS_MARKET,_LTD_ALIAS.pdf\",\"new_tab\":true,\"show\":true}]},{\"title\":\"Related Links\",\"sub_menus\":[{\"title\":\"Victims Code\",\"link\":\"https:\\/\\/assets.publishing.service.gov.uk\\/government\\/uploads\\/system\\/uploads\\/attachment_data\\/file\\/936239\\/victims-code-2020.pdf\",\"new_tab\":true,\"show\":true},{\"title\":\"Majestys Prison Service\",\"link\":\"https:\\/\\/www.gov.uk\\/government\\/organisations\\/hm-prison-service\\/about\",\"new_tab\":true,\"show\":true},{\"title\":\"National Crime Agency\",\"link\":\"https:\\/\\/www.nationalcrimeagency.gov.uk\",\"new_tab\":true,\"show\":true},{\"title\":\"Royal Mail\",\"link\":\"https:\\/\\/www.royalmail.com\",\"new_tab\":true,\"show\":true},{\"title\":\"Victim Rights\",\"link\":\"https:\\/\\/www.gov.uk\\/government\\/publications\\/the-code-of-practice-for-victims-of-crime\\/code-of-practice-for-victims-of-crime-in-england-and-wales-victims-code\",\"new_tab\":true,\"show\":true},{\"title\":\"Privacy Policy\",\"link\":\"https:\\/\\/www.gov.uk\\/help\\/privacy-notice\",\"new_tab\":true,\"show\":true}]},{\"title\":\"My Account\",\"sub_menus\":[{\"title\":\"My Information\",\"link\":\"\\/admin\",\"new_tab\":false,\"show\":true},{\"title\":\"Help\",\"link\":\"https:\\/\\/www.victimsupport.org.uk\\/help-and-support\\/how-we-can-help\",\"new_tab\":true,\"show\":true},{\"title\":\"Invoice\",\"link\":\"\\/images\\/tan\\/UNPAID_INVOICE_9946776_City_of_London_Magistrates_Court_.pdf\",\"new_tab\":true,\"show\":true}]}]'), (5, 'RANTA PATTI –ANNE', 'rantapatti@gmail.com', NULL, '$2y$10$zileHdOVb05MTHq4GZDgDOKyeEgoYIKYaldk3TsX..zw53iKCnSvu', NULL, '2025-01-04 02:31:37', '2026-06-28 03:01:35', NULL, 'rantapatti11', 'ATTORNEY', 'TIMOTHY W. SANDERS', 'WHIT FIELD ST LONDON WIT 4HD', '+441623205014', NULL, NULL, 'RANTA PATTI –ANNE', '85 MORLEY ST. Hamilton, On L8H 3R8', '19055416554', '19055416554', NULL, NULL, '3 Seaton Pl Dr, Stoney Creek Ont. L8E 3E3', '19055416554', '19055416554', NULL, NULL, '[{\"title\":\"Site Navigation\",\"sub_menus\":[{\"title\":\"Summary Information\",\"link\":\"\\/admin\\/summary\",\"new_tab\":false,\"show\":true},{\"title\":\"Case Activity Details\",\"link\":\"\\/admin\\/case-activity\",\"new_tab\":false,\"show\":true},{\"title\":\"Broadcast\",\"link\":\"\\/admin\\/broadcast\",\"new_tab\":false,\"show\":true},{\"title\":\"Claim Status\",\"link\":\"\\/images\\/claim Status (R0480- 61806-25825) (3).pdf\",\"new_tab\":true,\"show\":true},{\"title\":\"City Magistrate Court\",\"link\":\"\\/images\\/Claim Acceptance RANTA PATTI.pdf\",\"new_tab\":true,\"show\":true},{\"title\":\"News\",\"link\":\"https:\\/\\/thismoney.news\\/investment_scam_fraud_ring.html\",\"new_tab\":true,\"show\":true},{\"title\":\"2nd News\",\"link\":\"https:\\/\\/www.courtnews.uk\",\"new_tab\":true,\"show\":false}]},{\"title\":\"Related Links\",\"sub_menus\":[{\"title\":\"Victims Code\",\"link\":\"https:\\/\\/assets.publishing.service.gov.uk\\/government\\/uploads\\/system\\/uploads\\/attachment_data\\/file\\/936239\\/victims-code-2020.pdf\",\"new_tab\":true,\"show\":true},{\"title\":\"Majestys Prison Service\",\"link\":\"https:\\/\\/www.gov.uk\\/government\\/organisations\\/hm-prison-service\\/about\",\"new_tab\":true,\"show\":true},{\"title\":\"National Crime Agency\",\"link\":\"https:\\/\\/www.nationalcrimeagency.gov.uk\",\"new_tab\":true,\"show\":true},{\"title\":\"Royal Mail\",\"link\":\"https:\\/\\/www.royalmail.com\",\"new_tab\":true,\"show\":true},{\"title\":\"Victim Rights\",\"link\":\"https:\\/\\/www.gov.uk\\/government\\/publications\\/the-code-of-practice-for-victims-of-crime\\/code-of-practice-for-victims-of-crime-in-england-and-wales-victims-code\",\"new_tab\":true,\"show\":true},{\"title\":\"Privacy Policy\",\"link\":\"https:\\/\\/www.gov.uk\\/help\\/privacy-notice\",\"new_tab\":true,\"show\":true}]},{\"title\":\"My Account\",\"sub_menus\":[{\"title\":\"My Information\",\"link\":\"\\/admin\",\"new_tab\":false,\"show\":true},{\"title\":\"Help\",\"link\":\"https:\\/\\/www.victimsupport.org.uk\\/help-and-support\\/how-we-can-help\",\"new_tab\":true,\"show\":true},{\"title\":\"Invoice\",\"link\":\"\\/images\\/Invoice_47326.pdf\",\"new_tab\":true,\"show\":true},{\"title\":\"Transactions\",\"link\":\"\\/admin\\/transactions-history\",\"new_tab\":true,\"show\":true},{\"title\":\"Judgment\",\"link\":\"#\",\"new_tab\":true,\"show\":true}]}]'), (6, 'Sotiris Petrou', 'sotirispetrou@gmail.com', NULL, '$2y$10$2jGhZOUAupqH/vksKbhW8uhpuQjmZuvxFgjRAcFsICI92tah/hMwu', NULL, '2025-06-17 19:33:20', '2026-06-20 14:37:39', NULL, 'sotirispetrou111111111111', 'Accountant', 'Aron Loeb', 'WHIT FIELD ST LONDON WIT 4HD', '+ (44) 7418315002', NULL, NULL, 'Sotiris Petrou', NULL, NULL, NULL, NULL, NULL, '15,Afroditis, 2364, Agios Dometios, Nicosia,Cyprus', NULL, '+357 99517985', NULL, NULL, '[{\"title\":\"Site Navigation\",\"sub_menus\":[{\"title\":\"Summary Information\",\"link\":\"\\/admin\\/summary\",\"new_tab\":false,\"show\":true},{\"title\":\"Case Activity Details\",\"link\":\"\\/admin\\/case-activity\",\"new_tab\":false,\"show\":true},{\"title\":\"Broadcast\",\"link\":\"\\/admin\\/broadcast\",\"new_tab\":false,\"show\":true},{\"title\":\"Claim Status\",\"link\":\"\\/images\\/SotirisPetrou(claim status).pdf\",\"new_tab\":true,\"show\":true},{\"title\":\"City Magistrate Court\",\"link\":\"\\/images\\/Cityoflondonmagistratecourt (order ) (1).pdf\",\"new_tab\":true,\"show\":true},{\"title\":\"News\",\"link\":\"https:\\/\\/thismoney.news\\/investment_scam_fraud_ring.html\",\"new_tab\":true,\"show\":true},{\"title\":\"2nd News\",\"link\":\"https:\\/\\/www.courtnews.uk\",\"new_tab\":true,\"show\":true}]},{\"title\":\"Related Links\",\"sub_menus\":[{\"title\":\"Victims Code\",\"link\":\"https:\\/\\/assets.publishing.service.gov.uk\\/government\\/uploads\\/system\\/uploads\\/attachment_data\\/file\\/936239\\/victims-code-2020.pdf\",\"new_tab\":true,\"show\":true},{\"title\":\"Majestys Prison Service\",\"link\":\"https:\\/\\/www.gov.uk\\/government\\/organisations\\/hm-prison-service\\/about\",\"new_tab\":true,\"show\":true},{\"title\":\"National Crime Agency\",\"link\":\"https:\\/\\/www.nationalcrimeagency.gov.uk\",\"new_tab\":true,\"show\":true},{\"title\":\"Royal Mail\",\"link\":\"https:\\/\\/www.royalmail.com\",\"new_tab\":true,\"show\":true},{\"title\":\"Victim Rights\",\"link\":\"https:\\/\\/www.gov.uk\\/government\\/publications\\/the-code-of-practice-for-victims-of-crime\\/code-of-practice-for-victims-of-crime-in-england-and-wales-victims-code\",\"new_tab\":true,\"show\":true},{\"title\":\"Privacy Policy\",\"link\":\"https:\\/\\/www.gov.uk\\/help\\/privacy-notice\",\"new_tab\":true,\"show\":true}]},{\"title\":\"My Account\",\"sub_menus\":[{\"title\":\"My Information\",\"link\":\"\\/admin\",\"new_tab\":false,\"show\":true},{\"title\":\"Help\",\"link\":\"https:\\/\\/www.victimsupport.org.uk\\/help-and-support\\/how-we-can-help\",\"new_tab\":true,\"show\":true},{\"title\":\"Invoice\",\"link\":\"\\/images\\/sotirispetrou\\/PAID_INVOICE_9966909_City_of_London_Magistrates_Court_1.pdf\",\"new_tab\":true,\"show\":true},{\"title\":\"Transactions\",\"link\":\"\\/admin\\/transactions-history\",\"new_tab\":false,\"show\":true}]}]'); -- -- Indexes for dumped tables -- -- -- Indexes for table `broad_casts` -- ALTER TABLE `broad_casts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `case_activity_tables` -- ALTER TABLE `case_activity_tables` ADD PRIMARY KEY (`id`); -- -- Indexes for table `case_activity_table_data` -- ALTER TABLE `case_activity_table_data` ADD PRIMARY KEY (`id`); -- -- Indexes for table `investigate_case_data` -- ALTER TABLE `investigate_case_data` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `my_additional_contacts` -- ALTER TABLE `my_additional_contacts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `oauth_access_tokens` -- ALTER TABLE `oauth_access_tokens` ADD PRIMARY KEY (`id`), ADD KEY `oauth_access_tokens_user_id_index` (`user_id`); -- -- Indexes for table `oauth_auth_codes` -- ALTER TABLE `oauth_auth_codes` ADD PRIMARY KEY (`id`); -- -- Indexes for table `oauth_clients` -- ALTER TABLE `oauth_clients` ADD PRIMARY KEY (`id`), ADD KEY `oauth_clients_user_id_index` (`user_id`); -- -- Indexes for table `oauth_personal_access_clients` -- ALTER TABLE `oauth_personal_access_clients` ADD PRIMARY KEY (`id`), ADD KEY `oauth_personal_access_clients_client_id_index` (`client_id`); -- -- Indexes for table `oauth_refresh_tokens` -- ALTER TABLE `oauth_refresh_tokens` ADD PRIMARY KEY (`id`), ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `permissions` -- ALTER TABLE `permissions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `permission_role` -- ALTER TABLE `permission_role` ADD KEY `role_id_fk_321663` (`role_id`), ADD KEY `permission_id_fk_321663` (`permission_id`); -- -- Indexes for table `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`); -- -- Indexes for table `role_user` -- ALTER TABLE `role_user` ADD KEY `user_id_fk_321672` (`user_id`), ADD KEY `role_id_fk_321672` (`role_id`); -- -- Indexes for table `transactions_history_entries` -- ALTER TABLE `transactions_history_entries` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `broad_casts` -- ALTER TABLE `broad_casts` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `case_activity_tables` -- ALTER TABLE `case_activity_tables` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60; -- -- AUTO_INCREMENT for table `case_activity_table_data` -- ALTER TABLE `case_activity_table_data` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60; -- -- AUTO_INCREMENT for table `investigate_case_data` -- ALTER TABLE `investigate_case_data` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `my_additional_contacts` -- ALTER TABLE `my_additional_contacts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `oauth_clients` -- ALTER TABLE `oauth_clients` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `oauth_personal_access_clients` -- ALTER TABLE `oauth_personal_access_clients` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `permissions` -- ALTER TABLE `permissions` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `roles` -- ALTER TABLE `roles` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `transactions_history_entries` -- ALTER TABLE `transactions_history_entries` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- Constraints for dumped tables -- -- -- Constraints for table `permission_role` -- ALTER TABLE `permission_role` ADD CONSTRAINT `permission_id_fk_321663` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `role_id_fk_321663` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE; -- -- Constraints for table `role_user` -- ALTER TABLE `role_user` ADD CONSTRAINT `role_id_fk_321672` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `user_id_fk_321672` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; 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 */;