-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jun 13, 2024 at 10:13 PM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.2.12 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: `lfm` -- -- -------------------------------------------------------- -- -- Table structure for table `activity_logs` -- CREATE TABLE `activity_logs` ( `id` bigint(20) 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 `authorities` -- CREATE TABLE `authorities` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT 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 `authorities` -- INSERT INTO `authorities` (`id`, `name`, `nameAr`, `created_at`, `updated_at`) VALUES (1, 'Option 1', 'الخيار الأول', '2024-06-10 10:29:32', '2024-06-10 10:29:32'), (2, 'Option 2', 'الخيار الثاني', '2024-06-10 10:29:32', '2024-06-10 10:29:32'); -- -------------------------------------------------------- -- -- Table structure for table `banks` -- CREATE TABLE `banks` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT 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 `banks` -- INSERT INTO `banks` (`id`, `name`, `nameAr`, `created_at`, `updated_at`) VALUES (1, 'FAB', 'القوات المسلحة البوروندية', '2024-06-11 11:32:51', '2024-06-11 11:32:51'); -- -------------------------------------------------------- -- -- Table structure for table `case_stages` -- CREATE TABLE `case_stages` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT NULL, `caseTypeId` bigint(20) UNSIGNED DEFAULT 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 `case_stages` -- INSERT INTO `case_stages` (`id`, `name`, `nameAr`, `caseTypeId`, `created_at`, `updated_at`) VALUES (1, 'Option 1', 'الخيار الأول', 1, '2024-06-10 10:29:29', '2024-06-10 10:29:29'), (2, 'Option 2', 'الخيار الثاني', 2, '2024-06-10 10:29:29', '2024-06-10 10:29:29'); -- -------------------------------------------------------- -- -- Table structure for table `case_types` -- CREATE TABLE `case_types` ( `id` bigint(20) UNSIGNED NOT NULL, `section` varchar(255) DEFAULT NULL, `sectionAr` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT 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 `case_types` -- INSERT INTO `case_types` (`id`, `section`, `sectionAr`, `name`, `nameAr`, `created_at`, `updated_at`) VALUES (1, 'Judicial', 'قضائية', 'Option 1', 'الخيار الأول', '2024-06-10 10:29:29', '2024-06-10 10:29:29'), (2, 'Procedural', 'إجرائية', 'Option 2', 'الخيار الثاني', '2024-06-10 10:29:29', '2024-06-10 10:29:29'); -- -------------------------------------------------------- -- -- Table structure for table `cities` -- CREATE TABLE `cities` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(100) DEFAULT NULL, `nameAr` varchar(100) DEFAULT 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 `clients` -- CREATE TABLE `clients` ( `id` bigint(20) UNSIGNED NOT NULL, `serial` varchar(100) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT NULL, `fileType` varchar(100) DEFAULT 'Civil File', `phone` varchar(100) DEFAULT NULL, `landline` varchar(100) DEFAULT NULL, `fax` varchar(100) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `accessEmail` varchar(255) DEFAULT NULL, `alternativeEmail` varchar(255) DEFAULT NULL, `secondAlternativeEmail` varchar(255) DEFAULT NULL, `thirdAlternativeEmail` varchar(255) DEFAULT NULL, `fourthAlternativeEmail` varchar(255) DEFAULT NULL, `fifthAlternativeEmail` varchar(255) DEFAULT NULL, `password` text DEFAULT NULL, `imageFile` text DEFAULT NULL, `clientTypeId` bigint(20) UNSIGNED DEFAULT NULL, `identity` varchar(255) DEFAULT NULL, `nationalityId` bigint(20) UNSIGNED DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `addressAr` varchar(255) DEFAULT NULL, `branchCityId` bigint(20) UNSIGNED DEFAULT NULL, `note` text DEFAULT NULL, `noteAr` text DEFAULT NULL, `isActive` tinyint(1) DEFAULT 1, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `clients` -- INSERT INTO `clients` (`id`, `serial`, `name`, `nameAr`, `fileType`, `phone`, `landline`, `fax`, `email`, `accessEmail`, `alternativeEmail`, `secondAlternativeEmail`, `thirdAlternativeEmail`, `fourthAlternativeEmail`, `fifthAlternativeEmail`, `password`, `imageFile`, `clientTypeId`, `identity`, `nationalityId`, `address`, `addressAr`, `branchCityId`, `note`, `noteAr`, `isActive`, `creationDate`, `creatorId`, `created_at`, `updated_at`) VALUES (1, 'C-0001', 'Mashreq Bank', 'بنك المشرق', 'Civil File', '0444444444', '0444444444', '0444444444', 'info@mashreq.ae', 'admin@lfm.ae', 'info@mashreq.ae', 'info@mashreq.ae', 'info@mashreq.ae', 'info@mashreq.ae', 'info@mashreq.ae', '$2y$12$hgfdLLD./D6FtWd4loCyreyRiX.Pv3cD/iR0SxIt1Rhtb.3EsFwDq', 'CLN-04.06AM219623974441.png', 4, '123456', 153, NULL, NULL, NULL, NULL, NULL, 1, '2024-06-11', 1, '2024-06-11 11:06:24', '2024-06-11 11:06:24'); -- -------------------------------------------------------- -- -- Table structure for table `client_attachments` -- CREATE TABLE `client_attachments` ( `id` bigint(20) UNSIGNED NOT NULL, `issueDate` varchar(100) DEFAULT NULL, `expiryDate` varchar(100) DEFAULT NULL, `documentFile` text DEFAULT NULL, `documentFileSize` varchar(100) DEFAULT NULL, `note` text DEFAULT NULL, `noteAr` text DEFAULT NULL, `identityTypeId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `client_contracts` -- CREATE TABLE `client_contracts` ( `id` bigint(20) UNSIGNED NOT NULL, `issueDate` varchar(100) DEFAULT NULL, `expiryDate` varchar(100) DEFAULT NULL, `documentFile` text DEFAULT NULL, `documentFileSize` varchar(100) DEFAULT NULL, `note` text DEFAULT NULL, `noteAr` text DEFAULT NULL, `contractTypeId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `client_contracts` -- INSERT INTO `client_contracts` (`id`, `issueDate`, `expiryDate`, `documentFile`, `documentFileSize`, `note`, `noteAr`, `contractTypeId`, `clientId`, `creationDate`, `creatorId`, `created_at`, `updated_at`) VALUES (1, '2023-11-11', '2024-11-10', 'CON-04.11AM888846867066.pdf', '4.9 MB', NULL, NULL, 1, 1, '2024-06-11', 1, '2024-06-11 11:11:41', '2024-06-11 11:11:41'); -- -------------------------------------------------------- -- -- Table structure for table `client_titles` -- CREATE TABLE `client_titles` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) DEFAULT NULL, `titleAr` varchar(255) DEFAULT 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 `client_titles` -- INSERT INTO `client_titles` (`id`, `title`, `titleAr`, `created_at`, `updated_at`) VALUES (1, 'Option 1', 'الخيار الأول', '2024-06-10 10:29:29', '2024-06-10 10:29:29'), (2, 'Option 2', 'الخيار الثاني', '2024-06-10 10:29:29', '2024-06-10 10:29:29'); -- -------------------------------------------------------- -- -- Table structure for table `client_types` -- CREATE TABLE `client_types` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT 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 `client_types` -- INSERT INTO `client_types` (`id`, `name`, `nameAr`, `created_at`, `updated_at`) VALUES (1, 'Company', 'شركات', '2024-06-10 10:29:31', '2024-06-11 11:04:58'), (2, 'Individual', 'افراد', '2024-06-10 10:29:31', '2024-06-11 11:04:58'), (3, 'Institutions', 'مؤسسات', '2024-06-11 11:05:14', '2024-06-11 11:05:14'), (4, 'Banks', 'بنوك', '2024-06-11 11:05:25', '2024-06-11 11:05:25'); -- -------------------------------------------------------- -- -- Table structure for table `contract_types` -- CREATE TABLE `contract_types` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT 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 `contract_types` -- INSERT INTO `contract_types` (`id`, `name`, `nameAr`, `created_at`, `updated_at`) VALUES (1, 'Legal Attorney', 'توكيل قانوني', '2024-06-10 10:29:29', '2024-06-10 10:29:29'), (2, 'Delegation', 'تفويض', '2024-06-10 10:29:29', '2024-06-10 10:29:29'), (3, 'Bilateral Agreements', 'اتفاقيات ثنائية', '2024-06-10 10:29:29', '2024-06-10 10:29:29'), (4, 'Main Contract', 'القعد الأساسي', '2024-06-10 10:29:29', '2024-06-10 10:29:29'); -- -------------------------------------------------------- -- -- Table structure for table `courts` -- CREATE TABLE `courts` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT 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 `courts` -- INSERT INTO `courts` (`id`, `name`, `nameAr`, `created_at`, `updated_at`) VALUES (1, 'Dubai Court', 'محكمة دبي', '2024-06-10 10:29:29', '2024-06-10 10:29:29'), (2, 'Abu Dhabi Court', 'محكمة أبوظبي', '2024-06-10 10:29:29', '2024-06-10 10:29:29'), (3, 'DUBAI - COURT', 'دبي - المحكمة', '2024-06-11 11:32:50', '2024-06-11 11:32:50'), (4, 'AUH - COURT', 'آه - المحكمة', '2024-06-11 11:32:52', '2024-06-11 11:32:52'); -- -------------------------------------------------------- -- -- Table structure for table `departments` -- CREATE TABLE `departments` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT 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 `departments` -- INSERT INTO `departments` (`id`, `name`, `nameAr`, `created_at`, `updated_at`) VALUES (1, 'Option 1', 'الخيار الأول', '2024-06-10 10:29:29', '2024-06-10 10:29:29'), (2, 'Option 2', 'الخيار الثاني', '2024-06-10 10:29:29', '2024-06-10 10:29:29'); -- -------------------------------------------------------- -- -- Table structure for table `document_types` -- CREATE TABLE `document_types` ( `id` bigint(20) UNSIGNED NOT NULL, `isFor` varchar(100) DEFAULT 'General', `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT 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 `document_types` -- INSERT INTO `document_types` (`id`, `isFor`, `name`, `nameAr`, `created_at`, `updated_at`) VALUES (1, 'General', 'Type 1', 'المذكرات', '2024-06-10 10:29:32', '2024-06-11 20:00:36'), (2, 'Execution', 'Type 2', 'النوع الثاني', '2024-06-10 10:29:32', '2024-06-10 10:29:32'); -- -------------------------------------------------------- -- -- Table structure for table `execution_files` -- CREATE TABLE `execution_files` ( `id` bigint(20) UNSIGNED NOT NULL, `serial` varchar(100) DEFAULT NULL, `executionNumber` varchar(255) DEFAULT NULL, `executionDate` varchar(100) DEFAULT NULL, `status` varchar(100) DEFAULT 'Pending', `information` text DEFAULT NULL, `informationAr` text DEFAULT NULL, `executionTypeId` bigint(20) UNSIGNED DEFAULT NULL, `defendantId` bigint(20) UNSIGNED DEFAULT NULL, `accountNumber` text DEFAULT NULL, `cardNumber` text DEFAULT NULL, `loanNumber` text DEFAULT NULL, `circularNumber` text DEFAULT NULL, `chequeNumber` varchar(255) DEFAULT NULL, `chequeAmount` double DEFAULT NULL, `chequeActualAmount` double DEFAULT NULL, `bankId` bigint(20) UNSIGNED DEFAULT NULL, `courtId` bigint(20) UNSIGNED DEFAULT NULL, `productId` bigint(20) UNSIGNED DEFAULT NULL, `isConceded` varchar(255) DEFAULT NULL, `concedingDate` varchar(100) DEFAULT NULL, `caseId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `execution_files` -- INSERT INTO `execution_files` (`id`, `serial`, `executionNumber`, `executionDate`, `status`, `information`, `informationAr`, `executionTypeId`, `defendantId`, `accountNumber`, `cardNumber`, `loanNumber`, `circularNumber`, `chequeNumber`, `chequeAmount`, `chequeActualAmount`, `bankId`, `courtId`, `productId`, `isConceded`, `concedingDate`, `caseId`, `clientId`, `creationDate`, `creatorId`, `created_at`, `updated_at`) VALUES (1, 'MA-0001', '0001', '2024-06-11', 'Active', 'Nothing', 'لا توجد', NULL, 1, '123123', '123123', 'C01', NULL, '123123', 50000, 50000, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2024-06-11', 1, '2024-06-11 11:33:45', '2024-06-11 11:33:45'); -- -------------------------------------------------------- -- -- Table structure for table `execution_file_attachments` -- CREATE TABLE `execution_file_attachments` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT NULL, `documentNumber` varchar(100) DEFAULT NULL, `documentDate` varchar(100) DEFAULT NULL, `documentTypeId` bigint(20) UNSIGNED DEFAULT NULL, `documentFile` text DEFAULT NULL, `documentFileSize` text DEFAULT NULL, `information` text DEFAULT NULL, `informationAr` text DEFAULT NULL, `executionFileId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `execution_file_operations` -- CREATE TABLE `execution_file_operations` ( `id` bigint(20) UNSIGNED NOT NULL, `operationDate` varchar(100) DEFAULT NULL, `status` varchar(100) DEFAULT 'Pending', `information` text DEFAULT NULL, `informationAr` text DEFAULT NULL, `note` text DEFAULT NULL, `noteAr` text DEFAULT NULL, `operationFees` double(15,2) DEFAULT NULL, `operationAmount` double(15,2) DEFAULT NULL, `documentFile` text DEFAULT NULL, `secondDocumentFile` text DEFAULT NULL, `thirdDocumentFile` text DEFAULT NULL, `fourthDocumentFile` text DEFAULT NULL, `executionOperationTypeId` bigint(20) UNSIGNED DEFAULT NULL, `executionOperationAuthorityId` bigint(20) UNSIGNED DEFAULT NULL, `executionFileId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `execution_file_operations` -- INSERT INTO `execution_file_operations` (`id`, `operationDate`, `status`, `information`, `informationAr`, `note`, `noteAr`, `operationFees`, `operationAmount`, `documentFile`, `secondDocumentFile`, `thirdDocumentFile`, `fourthDocumentFile`, `executionOperationTypeId`, `executionOperationAuthorityId`, `executionFileId`, `clientId`, `creationDate`, `creatorId`, `created_at`, `updated_at`) VALUES (1, NULL, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, NULL, '2024-06-11', 1, '2024-06-11 11:33:45', '2024-06-11 11:33:45'), (2, NULL, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, 1, NULL, '2024-06-11', 1, '2024-06-11 11:33:45', '2024-06-11 11:33:45'); -- -------------------------------------------------------- -- -- Table structure for table `execution_file_operation_invoices` -- CREATE TABLE `execution_file_operation_invoices` ( `id` bigint(20) UNSIGNED NOT NULL, `title` text DEFAULT NULL, `titleAr` text DEFAULT NULL, `invoiceDate` varchar(100) DEFAULT NULL, `invoiceAmount` double(15,2) DEFAULT NULL, `documentFile` text DEFAULT NULL, `note` text DEFAULT NULL, `noteAr` text DEFAULT NULL, `executionFileId` bigint(20) UNSIGNED DEFAULT NULL, `executionFileOperationId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `execution_file_tasks` -- CREATE TABLE `execution_file_tasks` ( `id` bigint(20) UNSIGNED NOT NULL, `taskNumber` varchar(100) DEFAULT NULL, `status` varchar(100) DEFAULT 'Pending', `assignDate` varchar(100) DEFAULT NULL, `executionDate` varchar(100) DEFAULT NULL, `dueDate` varchar(100) DEFAULT NULL, `completionDate` varchar(100) DEFAULT NULL, `information` text DEFAULT NULL, `informationAr` text DEFAULT NULL, `taskHandlerId` bigint(20) UNSIGNED DEFAULT NULL, `taskFollowerId` bigint(20) UNSIGNED DEFAULT NULL, `executionFileId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `execution_operation_authorities` -- CREATE TABLE `execution_operation_authorities` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT 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 `execution_operation_authorities` -- INSERT INTO `execution_operation_authorities` (`id`, `name`, `nameAr`, `created_at`, `updated_at`) VALUES (1, 'Type 1', 'النوع الأول', '2024-06-10 10:29:32', '2024-06-10 10:29:32'), (2, 'Type 2', 'النوع الثاني', '2024-06-10 10:29:32', '2024-06-10 10:29:32'); -- -------------------------------------------------------- -- -- Table structure for table `execution_operation_types` -- CREATE TABLE `execution_operation_types` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT 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 `execution_operation_types` -- INSERT INTO `execution_operation_types` (`id`, `name`, `nameAr`, `created_at`, `updated_at`) VALUES (1, 'Stocks', 'الاسهم', '2024-06-11 10:45:53', '2024-06-11 10:45:53'), (2, 'Real Estate', 'العقارات', '2024-06-11 10:45:53', '2024-06-11 10:45:53'), (3, 'Vehicles', 'المركبات', '2024-06-11 10:45:53', '2024-06-11 10:45:53'), (4, 'Findings', 'الموجودات', '2024-06-11 10:45:53', '2024-06-11 10:45:53'), (5, 'Accounts', 'الحسابات', '2024-06-11 10:45:53', '2024-06-11 10:45:53'), (6, 'Licenses', 'الرخص', '2024-06-11 10:45:53', '2024-06-11 10:45:53'), (7, 'Arrest warrant', 'الضبط والاحضار', '2024-06-11 10:45:53', '2024-06-11 10:45:53'), (8, 'Travel Ban', 'منع السفر', '2024-06-11 10:45:53', '2024-06-11 10:45:53'); -- -------------------------------------------------------- -- -- Table structure for table `execution_services` -- CREATE TABLE `execution_services` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT 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 `execution_types` -- CREATE TABLE `execution_types` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT 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 `execution_types` -- INSERT INTO `execution_types` (`id`, `name`, `nameAr`, `created_at`, `updated_at`) VALUES (1, 'Type 1', 'النوع الأول', '2024-06-10 10:29:32', '2024-06-10 10:29:32'), (2, 'Type 2', 'النوع الثاني', '2024-06-10 10:29:32', '2024-06-10 10:29:32'); -- -------------------------------------------------------- -- -- Table structure for table `expert_offices` -- CREATE TABLE `expert_offices` ( `id` bigint(20) UNSIGNED NOT NULL, `serial` varchar(100) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT NULL, `phone` varchar(100) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `password` text DEFAULT NULL, `contactPerson` varchar(255) DEFAULT NULL, `contactPersonAr` varchar(255) DEFAULT NULL, `contactPersonPhone` varchar(100) DEFAULT NULL, `address` text DEFAULT NULL, `addressAr` text DEFAULT 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 `expert_offices` -- INSERT INTO `expert_offices` (`id`, `serial`, `name`, `nameAr`, `phone`, `email`, `password`, `contactPerson`, `contactPersonAr`, `contactPersonPhone`, `address`, `addressAr`, `created_at`, `updated_at`) VALUES (1, NULL, 'Truth Tech', 'تروث التقنية', '0555022838', 'admin@lfm.ae', '$2y$12$lVYB16.eEh4YtmeLa7uRRe0XlkkIdZ0KC15pkBTtwjt85UMsD64jC', NULL, NULL, NULL, 'churchill tower', 'برج تشرشل', '2024-06-11 11:07:10', '2024-06-11 11:07:10'); -- -------------------------------------------------------- -- -- Table structure for table `files` -- CREATE TABLE `files` ( `id` bigint(20) UNSIGNED NOT NULL, `serial` varchar(100) DEFAULT NULL, `fileNumber` varchar(100) DEFAULT NULL, `information` text DEFAULT NULL, `informationAr` text DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `files` -- INSERT INTO `files` (`id`, `serial`, `fileNumber`, `information`, `informationAr`, `clientId`, `creationDate`, `creatorId`, `created_at`, `updated_at`) VALUES (1, 'MA-0001', '0001', NULL, NULL, 1, '2024-06-11', 1, '2024-06-11 11:14:40', '2024-06-11 11:14:40'), (2, 'MA-0002', '0002', NULL, NULL, 1, '2024-06-13', 1, '2024-06-13 07:40:48', '2024-06-13 07:40:48'); -- -------------------------------------------------------- -- -- Table structure for table `file_associated_cases` -- CREATE TABLE `file_associated_cases` ( `id` bigint(20) UNSIGNED NOT NULL, `serial` varchar(100) DEFAULT NULL, `caseNumber` varchar(100) DEFAULT NULL, `requestNumber` varchar(100) DEFAULT NULL, `requestDate` varchar(100) DEFAULT NULL, `information` text DEFAULT NULL, `informationAr` text DEFAULT NULL, `caseTypeId` bigint(20) UNSIGNED DEFAULT NULL, `caseStageId` bigint(20) UNSIGNED DEFAULT NULL, `clientTitleId` bigint(20) UNSIGNED DEFAULT NULL, `courtFees` double(15,2) DEFAULT NULL, `discountAmount` double(15,2) DEFAULT NULL, `courtId` bigint(20) UNSIGNED DEFAULT NULL, `departmentId` bigint(20) UNSIGNED DEFAULT NULL, `isOpen` tinyint(1) DEFAULT 1, `isMainCase` tinyint(1) DEFAULT 0, `fileId` bigint(20) UNSIGNED DEFAULT NULL, `caseId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `branchCityId` bigint(20) UNSIGNED DEFAULT NULL, `administrativeId` bigint(20) UNSIGNED DEFAULT NULL, `secAdministrativeId` bigint(20) UNSIGNED DEFAULT NULL, `thirdAdministrativeId` bigint(20) UNSIGNED DEFAULT NULL, `advisorId` bigint(20) UNSIGNED DEFAULT NULL, `secAdvisorId` bigint(20) UNSIGNED DEFAULT NULL, `thirdAdvisorId` bigint(20) UNSIGNED DEFAULT NULL, `pleadingLawyerId` bigint(20) UNSIGNED DEFAULT NULL, `secPleadingLawyerId` bigint(20) UNSIGNED DEFAULT NULL, `thirdPleadingLawyerId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `file_cases` -- CREATE TABLE `file_cases` ( `id` bigint(20) UNSIGNED NOT NULL, `serial` varchar(100) DEFAULT NULL, `caseNumber` varchar(100) DEFAULT NULL, `registerDate` varchar(100) DEFAULT NULL, `caseFees` double(15,2) DEFAULT 0.00, `claimAmount` double(15,2) DEFAULT 0.00, `information` text DEFAULT NULL, `informationAr` text DEFAULT NULL, `caseTypeId` bigint(20) UNSIGNED DEFAULT NULL, `caseStageId` bigint(20) UNSIGNED DEFAULT NULL, `clientTitleId` bigint(20) UNSIGNED DEFAULT NULL, `courtFees` double(15,2) DEFAULT NULL, `discountAmount` double(15,2) DEFAULT NULL, `courtId` bigint(20) UNSIGNED DEFAULT NULL, `departmentId` bigint(20) UNSIGNED DEFAULT NULL, `isOpen` tinyint(1) DEFAULT 1, `isMainCase` tinyint(1) DEFAULT 0, `fileId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `administrativeId` bigint(20) UNSIGNED DEFAULT NULL, `secAdministrativeId` bigint(20) UNSIGNED DEFAULT NULL, `thirdAdministrativeId` bigint(20) UNSIGNED DEFAULT NULL, `advisorId` bigint(20) UNSIGNED DEFAULT NULL, `secAdvisorId` bigint(20) UNSIGNED DEFAULT NULL, `thirdAdvisorId` bigint(20) UNSIGNED DEFAULT NULL, `pleadingLawyerId` bigint(20) UNSIGNED DEFAULT NULL, `secPleadingLawyerId` bigint(20) UNSIGNED DEFAULT NULL, `thirdPleadingLawyerId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `file_cases` -- INSERT INTO `file_cases` (`id`, `serial`, `caseNumber`, `registerDate`, `caseFees`, `claimAmount`, `information`, `informationAr`, `caseTypeId`, `caseStageId`, `clientTitleId`, `courtFees`, `discountAmount`, `courtId`, `departmentId`, `isOpen`, `isMainCase`, `fileId`, `clientId`, `administrativeId`, `secAdministrativeId`, `thirdAdministrativeId`, `advisorId`, `secAdvisorId`, `thirdAdvisorId`, `pleadingLawyerId`, `secPleadingLawyerId`, `thirdPleadingLawyerId`, `creationDate`, `creatorId`, `created_at`, `updated_at`) VALUES (1, 'C-0', '0', '2024-06-11', 10500.00, 10000000.00, 'A defaulted loan', 'قرض تعثر سداده', 1, 1, 1, 5000.00, NULL, 1, 1, 1, 1, 1, 1, 1, 1, NULL, 1, NULL, NULL, 1, NULL, NULL, '2024-06-11', 1, '2024-06-11 11:14:40', '2024-06-11 11:14:40'), (2, 'C-559019', '559019', '2024-06-12', 12455.00, 590188.00, '-----------', '-----------', 2, 2, 1, 12311.00, NULL, 1, 1, 1, 1, 2, 1, 1, NULL, NULL, 1, NULL, NULL, 2, NULL, NULL, '2024-06-13', 1, '2024-06-13 07:40:48', '2024-06-13 07:40:48'); -- -------------------------------------------------------- -- -- Table structure for table `file_case_attachments` -- CREATE TABLE `file_case_attachments` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT NULL, `documentDate` varchar(100) DEFAULT NULL, `documentNumber` varchar(100) DEFAULT NULL, `documentTypeId` bigint(20) UNSIGNED DEFAULT NULL, `documentFile` text DEFAULT NULL, `documentFileSize` text DEFAULT NULL, `information` text DEFAULT NULL, `informationAr` text DEFAULT NULL, `fileId` bigint(20) UNSIGNED DEFAULT NULL, `caseId` bigint(20) UNSIGNED DEFAULT NULL, `caseExecutionId` bigint(20) UNSIGNED DEFAULT NULL, `associatedCaseId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `file_case_attachments` -- INSERT INTO `file_case_attachments` (`id`, `name`, `nameAr`, `documentDate`, `documentNumber`, `documentTypeId`, `documentFile`, `documentFileSize`, `information`, `informationAr`, `fileId`, `caseId`, `caseExecutionId`, `associatedCaseId`, `clientId`, `creationDate`, `creatorId`, `created_at`, `updated_at`) VALUES (1, 'Screenshots of conversations', 'لقطات من المحادثات', '2024-06-11', 'D-0001', 1, 'DOC-04.23AM28788400283.jpg', '123.3 KB', NULL, NULL, 1, 1, NULL, NULL, 1, '2024-06-11', 1, '2024-06-11 11:23:53', '2024-06-11 11:23:53'); -- -------------------------------------------------------- -- -- Table structure for table `file_case_claims` -- CREATE TABLE `file_case_claims` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT NULL, `note` text DEFAULT NULL, `noteAr` text DEFAULT NULL, `fileId` bigint(20) UNSIGNED DEFAULT NULL, `caseId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `file_case_claims` -- INSERT INTO `file_case_claims` (`id`, `name`, `nameAr`, `note`, `noteAr`, `fileId`, `caseId`, `creationDate`, `creatorId`, `created_at`, `updated_at`) VALUES (1, 'S', 'استرداد ارض زراعية', 'S', 'استرداد ارض زراعية', 1, 1, '2024-06-11', 1, '2024-06-11 11:16:47', '2024-06-11 11:16:47'); -- -------------------------------------------------------- -- -- Table structure for table `file_case_configurations` -- CREATE TABLE `file_case_configurations` ( `id` bigint(20) UNSIGNED NOT NULL, `requirementDate` varchar(100) DEFAULT NULL, `requirementCompletionDate` varchar(100) DEFAULT NULL, `status` varchar(100) DEFAULT 'Pending', `requirementTypeId` bigint(20) UNSIGNED DEFAULT NULL, `information` varchar(255) DEFAULT NULL, `informationAr` varchar(255) DEFAULT NULL, `handlerId` bigint(20) UNSIGNED DEFAULT NULL, `documentFile` text DEFAULT NULL, `documentFileSize` varchar(100) DEFAULT NULL, `fileId` bigint(20) UNSIGNED DEFAULT NULL, `caseId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `file_case_executions` -- CREATE TABLE `file_case_executions` ( `id` bigint(20) UNSIGNED NOT NULL, `executionNumber` varchar(100) DEFAULT NULL, `executionDate` varchar(100) DEFAULT NULL, `information` text DEFAULT NULL, `informationAr` text DEFAULT NULL, `executionTypeId` bigint(20) UNSIGNED DEFAULT NULL, `claimAmount` double(15,2) DEFAULT NULL, `executionAmount` double(15,2) DEFAULT NULL, `executionFees` double(15,2) DEFAULT NULL, `fileId` bigint(20) UNSIGNED DEFAULT NULL, `caseId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `file_case_executions` -- INSERT INTO `file_case_executions` (`id`, `executionNumber`, `executionDate`, `information`, `informationAr`, `executionTypeId`, `claimAmount`, `executionAmount`, `executionFees`, `fileId`, `caseId`, `clientId`, `creationDate`, `creatorId`, `created_at`, `updated_at`) VALUES (1, '1212', '2024-06-12', 'Instant execution', 'تنفيذ فوري', 1, 10000000.00, 9400000.00, 14500.00, 1, 1, 1, '2024-06-11', 1, '2024-06-11 11:26:47', '2024-06-11 11:26:47'); -- -------------------------------------------------------- -- -- Table structure for table `file_case_execution_operations` -- CREATE TABLE `file_case_execution_operations` ( `id` bigint(20) UNSIGNED NOT NULL, `operationDate` varchar(100) DEFAULT NULL, `status` varchar(100) DEFAULT 'Pending', `information` text DEFAULT NULL, `informationAr` text DEFAULT NULL, `note` text DEFAULT NULL, `noteAr` text DEFAULT NULL, `operationFees` double(15,2) DEFAULT NULL, `operationAmount` double(15,2) DEFAULT NULL, `documentFile` text DEFAULT NULL, `secondDocumentFile` text DEFAULT NULL, `thirdDocumentFile` text DEFAULT NULL, `fourthDocumentFile` text DEFAULT NULL, `executionOperationTypeId` bigint(20) UNSIGNED DEFAULT NULL, `executionOperationAuthorityId` bigint(20) UNSIGNED DEFAULT NULL, `caseExecutionId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `file_case_execution_operations` -- INSERT INTO `file_case_execution_operations` (`id`, `operationDate`, `status`, `information`, `informationAr`, `note`, `noteAr`, `operationFees`, `operationAmount`, `documentFile`, `secondDocumentFile`, `thirdDocumentFile`, `fourthDocumentFile`, `executionOperationTypeId`, `executionOperationAuthorityId`, `caseExecutionId`, `clientId`, `creationDate`, `creatorId`, `created_at`, `updated_at`) VALUES (1, NULL, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, NULL, '2024-06-11', 1, '2024-06-11 11:26:47', '2024-06-11 11:26:47'), (2, NULL, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, 1, NULL, '2024-06-11', 1, '2024-06-11 11:26:47', '2024-06-11 11:26:47'); -- -------------------------------------------------------- -- -- Table structure for table `file_case_execution_operation_invoices` -- CREATE TABLE `file_case_execution_operation_invoices` ( `id` bigint(20) UNSIGNED NOT NULL, `title` text DEFAULT NULL, `titleAr` text DEFAULT NULL, `invoiceDate` varchar(100) DEFAULT NULL, `invoiceAmount` double(15,2) DEFAULT NULL, `note` text DEFAULT NULL, `noteAr` text DEFAULT NULL, `documentFile` text DEFAULT NULL, `caseExecutionOperationId` bigint(20) UNSIGNED DEFAULT NULL, `caseExecutionId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `file_case_hearings` -- CREATE TABLE `file_case_hearings` ( `id` bigint(20) UNSIGNED NOT NULL, `hearingDate` varchar(100) DEFAULT NULL, `upcomingHearingDate` varchar(100) DEFAULT NULL, `hearingTypeId` bigint(20) UNSIGNED DEFAULT NULL, `courtHall` varchar(255) DEFAULT NULL, `courtAttendance` varchar(100) DEFAULT NULL, `courtDecision` text DEFAULT NULL, `courtDecisionAr` text DEFAULT NULL, `courtDecisionDate` text DEFAULT NULL, `courtId` bigint(20) UNSIGNED DEFAULT NULL, `note` text DEFAULT NULL, `noteAr` text DEFAULT NULL, `officeFees` double DEFAULT NULL, `expertOfficeId` bigint(20) UNSIGNED DEFAULT NULL, `administrativeId` bigint(20) UNSIGNED DEFAULT NULL, `advisorId` bigint(20) UNSIGNED DEFAULT NULL, `pleadingLawyerId` bigint(20) UNSIGNED DEFAULT NULL, `fileId` bigint(20) UNSIGNED DEFAULT NULL, `caseId` bigint(20) UNSIGNED DEFAULT NULL, `associatedCaseId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `file_case_hearings` -- INSERT INTO `file_case_hearings` (`id`, `hearingDate`, `upcomingHearingDate`, `hearingTypeId`, `courtHall`, `courtAttendance`, `courtDecision`, `courtDecisionAr`, `courtDecisionDate`, `courtId`, `note`, `noteAr`, `officeFees`, `expertOfficeId`, `administrativeId`, `advisorId`, `pleadingLawyerId`, `fileId`, `caseId`, `associatedCaseId`, `clientId`, `creationDate`, `creatorId`, `created_at`, `updated_at`) VALUES (1, '2024-06-10', '2024-06-13', 1, '1', 'in Person', 'Postponed to the next session for comment', 'تؤجل للجلسة القادمة للتعقيب', '2024-06-10', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, 1, NULL, 1, '2024-06-11', 1, '2024-06-11 11:21:13', '2024-06-11 11:21:13'), (3, '2024-06-11', NULL, 3, '3', 'Online', 'A ruling was issued for immediate compensation and the defendant was obligated to pay all expenses', 'تم اصدار الحكم بالتعويض الفوري و الزام المدعى عليه بجميع المصروفات', '2024-06-11', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, 1, NULL, 1, '2024-06-11', 1, '2024-06-11 11:25:57', '2024-06-11 11:25:57'), (4, '2024-06-12', '2024-06-13', 5, 'محكمة 1', 'Online', NULL, NULL, '2024-06-12', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, 1, NULL, 1, '2024-06-13', 1, '2024-06-13 05:06:49', '2024-06-13 05:06:49'), (5, NULL, '2024-06-12', 5, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 1, 2, 2, 2, NULL, 1, '2024-06-13', 1, '2024-06-13 07:40:48', '2024-06-13 07:40:48'); -- -------------------------------------------------------- -- -- Table structure for table `file_case_hearing_phases` -- CREATE TABLE `file_case_hearing_phases` ( `id` bigint(20) UNSIGNED NOT NULL, `status` varchar(100) DEFAULT NULL, `submissionDate` varchar(100) DEFAULT NULL, `meetingDateTime` varchar(100) DEFAULT NULL, `hearingPhaseId` bigint(20) UNSIGNED DEFAULT NULL, `caseHearingId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `file_case_hearing_phases` -- INSERT INTO `file_case_hearing_phases` (`id`, `status`, `submissionDate`, `meetingDateTime`, `hearingPhaseId`, `caseHearingId`, `creationDate`, `creatorId`, `created_at`, `updated_at`) VALUES (1, 'Pending', NULL, '2024-06-13T12:00', 1, 4, '2024-06-13', 1, '2024-06-13 05:06:49', '2024-06-13 05:07:07'), (2, 'Pending', NULL, NULL, 2, 4, '2024-06-13', 1, '2024-06-13 05:06:49', '2024-06-13 05:06:49'), (3, 'Pending', NULL, NULL, 3, 4, '2024-06-13', 1, '2024-06-13 05:06:49', '2024-06-13 05:06:49'), (4, 'Pending', NULL, NULL, 1, 5, '2024-06-13', 1, '2024-06-13 07:40:48', '2024-06-13 07:40:48'), (5, 'Pending', NULL, NULL, 2, 5, '2024-06-13', 1, '2024-06-13 07:40:48', '2024-06-13 07:40:48'), (6, 'Pending', NULL, NULL, 3, 5, '2024-06-13', 1, '2024-06-13 07:40:48', '2024-06-13 07:40:48'); -- -------------------------------------------------------- -- -- Table structure for table `file_case_hearing_phase_requirements` -- CREATE TABLE `file_case_hearing_phase_requirements` ( `id` bigint(20) UNSIGNED NOT NULL, `name` text DEFAULT NULL, `nameAr` text DEFAULT NULL, `information` text DEFAULT NULL, `informationAr` text DEFAULT NULL, `documentFile` text DEFAULT NULL, `secondDocumentFile` text DEFAULT NULL, `thirdDocumentFile` text DEFAULT NULL, `caseHearingPhaseId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `file_case_hearing_phase_requirements` -- INSERT INTO `file_case_hearing_phase_requirements` (`id`, `name`, `nameAr`, `information`, `informationAr`, `documentFile`, `secondDocumentFile`, `thirdDocumentFile`, `caseHearingPhaseId`, `creationDate`, `creatorId`, `created_at`, `updated_at`) VALUES (5, 'requirement 1', 'requirement 1', NULL, NULL, NULL, 'REQ-08.44AM764844087778.png', NULL, 1, '2024-06-13', 1, '2024-06-13 05:44:22', '2024-06-13 05:44:22'); -- -------------------------------------------------------- -- -- Table structure for table `file_case_memoirs` -- CREATE TABLE `file_case_memoirs` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) DEFAULT NULL, `titleAr` varchar(255) DEFAULT NULL, `memoirDate` varchar(100) DEFAULT NULL, `status` varchar(100) DEFAULT 'Pending', `documentFile` text DEFAULT NULL, `documentFileSize` varchar(100) DEFAULT NULL, `memoirTypeId` bigint(20) UNSIGNED DEFAULT NULL, `note` text DEFAULT NULL, `noteAr` text DEFAULT NULL, `executionDate` varchar(100) DEFAULT NULL, `completionDate` varchar(100) DEFAULT NULL, `completionDays` int(11) DEFAULT NULL, `advisorId` bigint(20) UNSIGNED DEFAULT NULL, `fileId` bigint(20) UNSIGNED DEFAULT NULL, `caseId` bigint(20) UNSIGNED DEFAULT NULL, `associatedCaseId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `file_case_memoirs` -- INSERT INTO `file_case_memoirs` (`id`, `title`, `titleAr`, `memoirDate`, `status`, `documentFile`, `documentFileSize`, `memoirTypeId`, `note`, `noteAr`, `executionDate`, `completionDate`, `completionDays`, `advisorId`, `fileId`, `caseId`, `associatedCaseId`, `clientId`, `creationDate`, `creatorId`, `created_at`, `updated_at`) VALUES (1, 'Primitive note', 'مذكرة بدائية', '2024-06-11', 'Completed', 'MEM-04.19AM431373492579.pdf', '4.9 MB', 1, NULL, NULL, '2024-06-14', '2024-06-11', -3, 1, 1, 1, NULL, 1, '2024-06-11', 1, '2024-06-11 11:17:42', '2024-06-11 11:19:22'), (2, '----------------', '----------------', '2024-06-13', 'Pending', NULL, NULL, 1, NULL, NULL, '2024-06-13', NULL, NULL, 1, 1, 1, NULL, 1, '2024-06-13', 1, '2024-06-13 07:19:43', '2024-06-13 07:19:43'), (3, '1231', '1231', '2024-06-13', 'Completed', 'MEM-11.04AM467765479077.png', '62.4 KB', 2, NULL, NULL, '2024-06-13', '2024-06-13', 0, 1, 1, 1, NULL, 1, '2024-06-13', 1, '2024-06-13 07:22:09', '2024-06-13 08:04:33'), (4, '---', '---', '2024-06-13', 'Completed', 'MEM-11.07AM160936725625.png', '62.4 KB', 1, NULL, NULL, '2024-06-05', '2024-06-13', 8, 1, 1, 1, NULL, 1, '2024-06-13', 1, '2024-06-13 07:24:14', '2024-06-13 08:07:17'), (5, '1231', '1231', '2024-06-13', 'Pending', NULL, NULL, 1, NULL, NULL, '2024-06-13', NULL, NULL, 1, 1, 1, NULL, 1, '2024-06-13', 1, '2024-06-13 07:24:54', '2024-06-13 07:24:54'), (6, '1111', '1111', '2024-06-13', 'Completed', 'MEM-11.09AM980942663275.png', '62.4 KB', 1, NULL, NULL, '2024-06-12', '2024-06-13', 1, 2, 1, 1, NULL, 1, '2024-06-13', 1, '2024-06-13 07:27:05', '2024-06-13 08:18:15'), (7, '12', '12', '2024-06-13', 'Pending', NULL, NULL, 1, NULL, NULL, '2024-06-13', NULL, NULL, 1, 1, 1, NULL, 1, '2024-06-13', 1, '2024-06-13 07:27:29', '2024-06-13 07:27:29'), (8, '-------------', '-------------', '2024-06-13', 'Completed', 'MEM-11.19AM744831066065.png', '62.4 KB', 1, NULL, NULL, '2024-06-14', '2024-06-13', -1, 2, 2, 2, NULL, 1, '2024-06-13', 1, '2024-06-13 07:43:49', '2024-06-13 08:19:51'); -- -------------------------------------------------------- -- -- Table structure for table `file_case_opponents` -- CREATE TABLE `file_case_opponents` ( `id` bigint(20) UNSIGNED NOT NULL, `note` text DEFAULT NULL, `noteAr` text DEFAULT NULL, `fileId` bigint(20) UNSIGNED DEFAULT NULL, `caseId` bigint(20) UNSIGNED DEFAULT NULL, `opponentId` bigint(20) UNSIGNED DEFAULT NULL, `opponentTitleId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `file_case_opponents` -- INSERT INTO `file_case_opponents` (`id`, `note`, `noteAr`, `fileId`, `caseId`, `opponentId`, `opponentTitleId`, `creationDate`, `creatorId`, `created_at`, `updated_at`) VALUES (1, NULL, NULL, 1, 1, 1, 1, '2024-06-11', 1, '2024-06-11 11:30:50', '2024-06-11 11:30:50'); -- -------------------------------------------------------- -- -- Table structure for table `file_case_reports` -- CREATE TABLE `file_case_reports` ( `id` bigint(20) UNSIGNED NOT NULL, `reportNumber` varchar(100) DEFAULT NULL, `reportDate` varchar(100) DEFAULT NULL, `reportFees` double(15,2) DEFAULT NULL, `status` varchar(100) DEFAULT 'Pending', `reportTypeId` bigint(20) UNSIGNED DEFAULT NULL, `information` text DEFAULT NULL, `informationAr` text DEFAULT NULL, `documentFile` text DEFAULT NULL, `documentFileSize` varchar(100) DEFAULT NULL, `authorityId` bigint(20) UNSIGNED DEFAULT NULL, `departmentId` bigint(20) UNSIGNED DEFAULT NULL, `administrativeId` bigint(20) UNSIGNED DEFAULT NULL, `advisorId` bigint(20) UNSIGNED DEFAULT NULL, `pleadingLawyerId` bigint(20) UNSIGNED DEFAULT NULL, `fileId` bigint(20) UNSIGNED DEFAULT NULL, `caseId` bigint(20) UNSIGNED DEFAULT NULL, `associatedCaseId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `file_case_reports` -- INSERT INTO `file_case_reports` (`id`, `reportNumber`, `reportDate`, `reportFees`, `status`, `reportTypeId`, `information`, `informationAr`, `documentFile`, `documentFileSize`, `authorityId`, `departmentId`, `administrativeId`, `advisorId`, `pleadingLawyerId`, `fileId`, `caseId`, `associatedCaseId`, `clientId`, `creationDate`, `creatorId`, `created_at`, `updated_at`) VALUES (1, 'R-0001', '2024-06-11', 3130.00, 'Pending', 1, 'Report for immediate dealing with the customer', 'بلاغ للتعامل الفوري مع العميل', 'REP-04.24AM789864906276.jpg', '123.3 KB', 1, 1, 1, 1, NULL, 1, 1, NULL, 1, '2024-06-11', 1, '2024-06-11 11:24:39', '2024-06-11 11:24:39'); -- -------------------------------------------------------- -- -- Table structure for table `file_case_requirements` -- CREATE TABLE `file_case_requirements` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT NULL, `requirementDate` varchar(100) DEFAULT NULL, `status` varchar(100) DEFAULT 'Pending', `documentFile` text DEFAULT NULL, `information` text DEFAULT NULL, `informationAr` text DEFAULT NULL, `executorId` bigint(20) UNSIGNED DEFAULT NULL, `fileId` bigint(20) UNSIGNED DEFAULT NULL, `caseId` bigint(20) UNSIGNED DEFAULT NULL, `associatedCaseId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `file_case_tasks` -- CREATE TABLE `file_case_tasks` ( `id` bigint(20) UNSIGNED NOT NULL, `taskNumber` varchar(100) DEFAULT NULL, `status` varchar(100) DEFAULT 'Pending', `assignDate` varchar(100) DEFAULT NULL, `executionDate` varchar(100) DEFAULT NULL, `dueDate` varchar(100) DEFAULT NULL, `completionDate` varchar(100) DEFAULT NULL, `information` text DEFAULT NULL, `informationAr` text DEFAULT NULL, `taskHandlerId` bigint(20) UNSIGNED DEFAULT NULL, `taskFollowerId` bigint(20) UNSIGNED DEFAULT NULL, `fileId` bigint(20) UNSIGNED DEFAULT NULL, `caseId` bigint(20) UNSIGNED DEFAULT NULL, `caseExecutionId` bigint(20) UNSIGNED DEFAULT NULL, `associatedCaseId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `file_case_tasks` -- INSERT INTO `file_case_tasks` (`id`, `taskNumber`, `status`, `assignDate`, `executionDate`, `dueDate`, `completionDate`, `information`, `informationAr`, `taskHandlerId`, `taskFollowerId`, `fileId`, `caseId`, `caseExecutionId`, `associatedCaseId`, `clientId`, `creationDate`, `creatorId`, `created_at`, `updated_at`) VALUES (1, 'T-0001', 'Pending', '2024-06-11', '2024-06-11', '2024-06-11', NULL, 'Follow up regarding the next meeting with the client', 'المتابعة بخصوص الاجتماع القادم مع العميل', 1, 1, 1, 1, NULL, NULL, 1, '2024-06-11', 1, '2024-06-11 11:23:04', '2024-06-11 11:23:04'); -- -------------------------------------------------------- -- -- Table structure for table `file_case_tickets` -- CREATE TABLE `file_case_tickets` ( `id` bigint(20) UNSIGNED NOT NULL, `ticketDate` varchar(100) DEFAULT NULL, `ticketStatus` varchar(100) DEFAULT 'Pending', `ticketTypeId` bigint(20) UNSIGNED DEFAULT NULL, `advisorId` bigint(20) UNSIGNED DEFAULT NULL, `fileId` bigint(20) UNSIGNED DEFAULT NULL, `caseId` bigint(20) UNSIGNED DEFAULT NULL, `associatedCaseId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `file_case_verdicts` -- CREATE TABLE `file_case_verdicts` ( `id` bigint(20) UNSIGNED NOT NULL, `verdictDate` varchar(100) DEFAULT NULL, `verdictTypeId` bigint(20) UNSIGNED DEFAULT NULL, `courtHall` varchar(255) DEFAULT NULL, `courtDecision` text DEFAULT NULL, `courtDecisionAr` text DEFAULT NULL, `courtDecisionDate` text DEFAULT NULL, `courtId` bigint(20) UNSIGNED DEFAULT NULL, `advisorId` bigint(20) UNSIGNED DEFAULT NULL, `pleadingLawyerId` bigint(20) UNSIGNED DEFAULT NULL, `fileId` bigint(20) UNSIGNED DEFAULT NULL, `caseId` bigint(20) UNSIGNED DEFAULT NULL, `caseHearingId` bigint(20) UNSIGNED DEFAULT NULL, `associatedCaseId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `file_case_verdicts` -- INSERT INTO `file_case_verdicts` (`id`, `verdictDate`, `verdictTypeId`, `courtHall`, `courtDecision`, `courtDecisionAr`, `courtDecisionDate`, `courtId`, `advisorId`, `pleadingLawyerId`, `fileId`, `caseId`, `caseHearingId`, `associatedCaseId`, `clientId`, `creationDate`, `creatorId`, `created_at`, `updated_at`) VALUES (1, '2024-06-11', 3, '3', 'A ruling was issued for immediate compensation and the defendant was obligated to pay all expenses', 'تم اصدار الحكم بالتعويض الفوري و الزام المدعى عليه بجميع المصروفات', '2024-06-11', NULL, 1, 1, 1, 1, 3, NULL, 1, '2024-06-11', 1, '2024-06-11 11:25:57', '2024-06-11 11:25:57'); -- -------------------------------------------------------- -- -- Table structure for table `general_settings` -- CREATE TABLE `general_settings` ( `id` bigint(20) UNSIGNED NOT NULL, `fileSerial` bigint(20) DEFAULT 1, `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 `hearing_phases` -- CREATE TABLE `hearing_phases` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT 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 `hearing_phases` -- INSERT INTO `hearing_phases` (`id`, `name`, `nameAr`, `created_at`, `updated_at`) VALUES (1, 'Recruitment of Expert', 'انتداب الخبير', '2024-06-12 18:08:58', '2024-06-12 18:08:58'), (2, 'Expert Meeting', 'اجتماع الخبرة', '2024-06-12 18:08:58', '2024-06-12 18:08:58'), (3, 'Feedback', 'التعقيب', '2024-06-12 18:08:58', '2024-06-12 18:08:58'); -- -------------------------------------------------------- -- -- Table structure for table `hearing_types` -- CREATE TABLE `hearing_types` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT NULL, `type` varchar(100) DEFAULT 'Hearing', `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 `hearing_types` -- INSERT INTO `hearing_types` (`id`, `name`, `nameAr`, `type`, `created_at`, `updated_at`) VALUES (1, 'Type 1', 'النوع الأول', 'Hearing', '2024-06-10 10:29:32', '2024-06-10 10:29:32'), (2, 'Type 2', 'النوع الثاني', 'Hearing', '2024-06-10 10:29:32', '2024-06-10 10:29:32'), (3, 'Type 1', 'النوع الأول', 'Verdict', '2024-06-10 10:29:32', '2024-06-10 10:29:32'), (4, 'Type 2', 'النوع الثاني', 'Verdict', '2024-06-10 10:29:32', '2024-06-10 10:29:32'), (5, 'The first type', 'النوع الاول', 'Expert', '2024-06-10 20:36:11', '2024-06-10 20:36:11'); -- -------------------------------------------------------- -- -- Table structure for table `identity_types` -- CREATE TABLE `identity_types` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT 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 `identity_types` -- INSERT INTO `identity_types` (`id`, `name`, `nameAr`, `created_at`, `updated_at`) VALUES (1, 'Type 1', 'النوع الأول', '2024-06-10 10:29:32', '2024-06-10 10:29:32'), (2, 'Type 2', 'النوع الثاني', '2024-06-10 10:29:32', '2024-06-10 10:29:32'); -- -------------------------------------------------------- -- -- Table structure for table `job_titles` -- CREATE TABLE `job_titles` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT 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 `job_titles` -- INSERT INTO `job_titles` (`id`, `name`, `nameAr`, `created_at`, `updated_at`) VALUES (1, 'Manager', 'مدير', '2024-06-13 04:20:12', '2024-06-13 04:20:12'), (2, 'Employee', 'موظف', '2024-06-13 04:20:20', '2024-06-13 04:20:20'); -- -------------------------------------------------------- -- -- Table structure for table `meetings` -- CREATE TABLE `meetings` ( `id` bigint(20) UNSIGNED NOT NULL, `topic` text DEFAULT NULL, `topicAr` text DEFAULT NULL, `status` varchar(100) DEFAULT NULL, `meetingPlace` varchar(255) DEFAULT NULL, `meetingPlaceAr` varchar(255) DEFAULT NULL, `meetingDate` varchar(100) DEFAULT NULL, `meetingFrom` varchar(100) DEFAULT NULL, `meetingUntil` varchar(100) DEFAULT NULL, `upcomingMeetingPlace` varchar(255) DEFAULT NULL, `upcomingMeetingPlaceAr` varchar(255) DEFAULT NULL, `upcomingMeetingDate` varchar(100) DEFAULT NULL, `upcomingMeetingFrom` varchar(100) DEFAULT NULL, `upcomingMeetingUntil` varchar(100) DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `fileId` bigint(20) UNSIGNED DEFAULT NULL, `fileCaseId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `meetings` -- INSERT INTO `meetings` (`id`, `topic`, `topicAr`, `status`, `meetingPlace`, `meetingPlaceAr`, `meetingDate`, `meetingFrom`, `meetingUntil`, `upcomingMeetingPlace`, `upcomingMeetingPlaceAr`, `upcomingMeetingDate`, `upcomingMeetingFrom`, `upcomingMeetingUntil`, `clientId`, `fileId`, `fileCaseId`, `creationDate`, `creatorId`, `created_at`, `updated_at`) VALUES (1, 'To discuss the dimensions of the issue', 'لمناقشة ابعاد القضية', 'Pending', NULL, NULL, '2024-06-12', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 1, '2024-06-11', 1, '2024-06-11 11:27:12', '2024-06-11 11:27:12'), (2, 'Discussing DOER - LFM', 'مناقشة DOER - LFM', 'Pending', 'TRUTH Company', 'شركة الحقيقة', '2024-06-13', '13:00', '15:00', 'Main Branch', 'الفرع الرئيسي', '2024-06-13', '13:00', '15:00', 1, 1, 1, '2024-06-13', 1, '2024-06-13 04:18:31', '2024-06-13 04:22:02'), (3, '123', '123', 'Completed', '5656', '5656', '2024-06-11', '22:42', '22:41', 'hello', 'مرحبًا', '2024-06-12', '23:12', '23:14', 1, 2, 2, '2024-06-13', 1, '2024-06-13 16:39:55', '2024-06-13 17:11:01'); -- -------------------------------------------------------- -- -- Table structure for table `meeting_agendas` -- CREATE TABLE `meeting_agendas` ( `id` bigint(20) UNSIGNED NOT NULL, `information` text DEFAULT NULL, `informationAr` text DEFAULT NULL, `presenter` varchar(255) DEFAULT NULL, `presenterAr` varchar(255) DEFAULT NULL, `meetingId` bigint(20) UNSIGNED DEFAULT 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 `meeting_agendas` -- INSERT INTO `meeting_agendas` (`id`, `information`, `informationAr`, `presenter`, `presenterAr`, `meetingId`, `created_at`, `updated_at`) VALUES (1, 'DOER - Pending Functions', 'DOER - الوظائف المعلقة', 'Aymen Najm', 'أيمن نجم', 2, '2024-06-13 04:18:59', '2024-06-13 04:18:59'), (2, 'DOER - Enhancements & Sugguestions', 'DOER - التحسينات والاقتراحات', 'Aymen Najm', 'أيمن نجم', 2, '2024-06-13 04:19:35', '2024-06-13 04:19:35'), (4, 'LFM - enhancements', 'LFM - التحسينات', 'Aymen Najm', 'أيمن نجم', 2, '2024-06-13 04:47:19', '2024-06-13 04:47:19'); -- -------------------------------------------------------- -- -- Table structure for table `meeting_discussions` -- CREATE TABLE `meeting_discussions` ( `id` bigint(20) UNSIGNED NOT NULL, `point` text DEFAULT NULL, `pointAr` text DEFAULT NULL, `note` text DEFAULT NULL, `noteAr` text DEFAULT NULL, `meetingId` bigint(20) UNSIGNED DEFAULT 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 `meeting_discussions` -- INSERT INTO `meeting_discussions` (`id`, `point`, `pointAr`, `note`, `noteAr`, `meetingId`, `created_at`, `updated_at`) VALUES (1, 'Email and Password recovery in Logins', 'استعادة البريد الإلكتروني وكلمة المرور في عمليات تسجيل الدخول', 'Should be in Drivers / Customers as well', 'يجب أن يكون في السائقين / العملاء أيضًا', 2, '2024-06-13 04:23:06', '2024-06-13 04:23:06'), (2, 'Login side-pictures shoud be a slider for better experience', 'يجب أن تكون الصور الجانبية لتسجيل الدخول عبارة عن شريط تمرير للحصول على تجربة أفضل', NULL, NULL, 2, '2024-06-13 04:23:52', '2024-06-13 04:23:52'), (3, 'Limit the upload size to 500Kb only', 'الحد من حجم التحميل إلى 500 كيلو بايت فقط', NULL, NULL, 2, '2024-06-13 04:24:13', '2024-06-13 04:24:13'), (4, 'Restructure customer subscription form in Doer - Admin portal', 'إعادة هيكلة نموذج اشتراك العميل في Doer - بوابة المسؤول', NULL, NULL, 2, '2024-06-13 04:25:12', '2024-06-13 04:25:12'), (5, 'Remove the Label builder and build a sticker for each client with certain specifics', 'قم بإزالة أداة إنشاء الملصقات وإنشاء ملصق لكل عميل بمواصفات معينة', 'Reason behind this is that each client sticker is different and no standard is available', 'السبب وراء ذلك هو أن كل ملصق عميل مختلف ولا يتوفر أي معيار', 2, '2024-06-13 04:26:45', '2024-06-13 04:26:45'), (6, 'Ingredients should not be modifiable only residing on the database and can be managed by our manager system which update the list and push the updates to the client\'s databases', 'لا ينبغي أن تكون المكونات قابلة للتعديل، فهي موجودة فقط في قاعدة البيانات ويمكن إدارتها بواسطة نظام المدير لدينا الذي يقوم بتحديث القائمة ويدفع التحديثات إلى قواعد بيانات العميل', 'This also includes the conversion factor for each ingredient', 'يتضمن هذا أيضًا عامل التحويل لكل مكون', 2, '2024-06-13 04:28:39', '2024-06-13 04:28:39'), (7, 'Doer system permissions should be manageable from our manager system side and \n push to they database', 'يجب أن تكون أذونات نظام الفاعل قابلة للإدارة من جانب نظام المدير لدينا و \n ادفع إلى قاعدة البيانات الخاصة بهم', 'This the same process for the ingredient lists', 'هذه نفس العملية لقوائم المكونات', 2, '2024-06-13 04:31:34', '2024-06-13 04:31:34'), (8, 'Every client should have a full-designed website with its unique form, and enough time for test and development once its done then no further development', 'يجب أن يكون لدى كل عميل موقع ويب كامل التصميم بشكله الفريد، ووقتًا كافيًا للاختبار والتطوير بمجرد الانتهاء منه، ثم لا مزيد من التطوير', NULL, NULL, 2, '2024-06-13 04:33:09', '2024-06-13 04:33:09'), (9, 'I recommend that system should be in our server for faster serving time and maintaining the error free env\nalso allowing them to backup their database manually and the website should only work with Api, but the customer login / driver login should be in a subdomain in our server', 'أوصي بأن يكون النظام موجودًا في خادمنا من أجل توفير وقت خدمة أسرع والحفاظ على بيئة خالية من الأخطاء\nالسماح لهم أيضًا بالنسخ الاحتياطي لقاعدة بياناتهم يدويًا ويجب أن يعمل موقع الويب فقط مع واجهة برمجة التطبيقات (Api)، ولكن يجب أن يكون تسجيل دخول العميل / تسجيل دخول السائق في نطاق فرعي في خادمنا', NULL, NULL, 2, '2024-06-13 04:36:35', '2024-06-13 04:36:35'), (10, 'ChatGPT should be added as a chat-popup and as a full page for the client to search recipes and ingredients related information', 'يجب إضافة ChatGPT كنافذة دردشة منبثقة وكصفحة كاملة للعميل للبحث عن الوصفات والمعلومات المتعلقة بالمكونات', NULL, NULL, 2, '2024-06-13 04:37:40', '2024-06-13 04:37:40'), (11, 'In each page should be a popup displaying information about the page and what the client can do or view in this page', 'يجب أن يكون في كل صفحة نافذة منبثقة تعرض معلومات حول الصفحة وما يمكن للعميل القيام به أو مشاهدته في هذه الصفحة', NULL, NULL, 2, '2024-06-13 04:38:43', '2024-06-13 04:38:43'), (12, 'The recipe and the item tabs should have \"our recommended recipes\" and they can view the ingredients in it then clone it to their system\n\nthese recipes and items should be added in our manager-system', 'يجب أن تحتوي علامات تبويب الوصفة والعناصر على \"وصفاتنا الموصى بها\" ويمكنهم عرض المكونات الموجودة فيها ثم استنساخها في نظامهم\n\nيجب إضافة هذه الوصفات والعناصر إلى نظام المدير لدينا', NULL, NULL, 2, '2024-06-13 04:40:03', '2024-06-13 04:40:03'), (13, 'Adding Ticket for the client fill if there\'s an issue or to report something on the system', 'إضافة تذكرة للعميل لملئها في حالة وجود مشكلة أو الإبلاغ عن شيء ما على النظام', NULL, NULL, 2, '2024-06-13 04:41:02', '2024-06-13 04:41:02'), (14, 'Email Builder should be added and switch buttons to activate / deactivate sending messages in certain phases', 'يجب إضافة أداة إنشاء البريد الإلكتروني وتبديل الأزرار لتنشيط/إلغاء تنشيط إرسال الرسائل في مراحل معينة', NULL, NULL, 2, '2024-06-13 04:42:05', '2024-06-13 04:42:05'), (15, 'changing address / renew subscription for customer\'s application', 'تغيير العنوان / تجديد الاشتراك لتطبيق العميل', NULL, NULL, 2, '2024-06-13 04:42:35', '2024-06-13 04:42:35'), (16, 'driver\'s app - map location', 'تطبيق السائق - خريطة الموقع', NULL, NULL, 2, '2024-06-13 04:43:19', '2024-06-13 04:43:19'), (18, 'Pending functions and pages in LFM - Report Page - Manage Cases page- Tasks page - settings for profile in settings tab-', 'الوظائف والصفحات المعلقة في LFM - صفحة التقرير - صفحة إدارة الحالات - صفحة المهام - إعدادات الملف الشخصي في علامة تبويب الإعدادات-', NULL, NULL, 2, '2024-06-13 04:54:03', '2024-06-13 04:54:03'), (19, 'Revising the select issue in different modals - also the refresh problems in deleting certain items like hearings for example', 'مراجعة مشكلة التحديد في أشكال مختلفة - وكذلك مشكلات التحديث في حذف عناصر معينة مثل جلسات الاستماع على سبيل المثال', NULL, NULL, 2, '2024-06-13 04:55:28', '2024-06-13 04:55:28'), (20, 'Update - Remove - Insert Permissions is not active for departments', 'تحديث - إزالة - إدراج الأذونات غير نشطة للأقسام', NULL, NULL, 2, '2024-06-13 04:58:41', '2024-06-13 04:58:41'), (21, 'change the upload method of images or pdf files and limit the type of files to give certain image to represent', 'قم بتغيير طريقة تحميل الصور أو ملفات pdf وحدد نوع الملفات لإعطاء صورة معينة لتمثيلها', NULL, NULL, 2, '2024-06-13 06:19:37', '2024-06-13 06:19:37'), (22, 'Change some of the card view to table view for better experience', 'قم بتغيير بعض طرق عرض البطاقة إلى عرض الجدول للحصول على تجربة أفضل', NULL, NULL, 2, '2024-06-13 06:51:37', '2024-06-13 06:51:37'), (23, 'replying on discussion number.2 is to create a permission for the super-admin to control the login-picture and remove it from customer and driver', 'الرد على المناقشة رقم 2 هو إنشاء إذن للمشرف المتميز للتحكم في صورة تسجيل الدخول وإزالتها من العميل والسائق', NULL, NULL, 2, '2024-06-13 10:34:58', '2024-06-13 10:34:58'), (24, 'replying to point number.3 use a compress js package to compress the upload image', 'الرد على النقطة رقم 3 استخدم حزمة js المضغوطة لضغط صورة التحميل', NULL, NULL, 2, '2024-06-13 10:35:51', '2024-06-13 10:35:51'), (25, 'replying to point no.4 - restructuring the customer-subscription form and making it customizable by controller example designing labels', 'الرد على النقطة رقم 4 - إعادة هيكلة نموذج اشتراك العميل وجعله قابلاً للتخصيص من خلال نموذج وحدة التحكم لتصميم الملصقات', NULL, NULL, 2, '2024-06-13 10:52:05', '2024-06-13 10:52:05'), (26, 'replying to point no.10 - chatGPT integeration can be create the meal depending on the ingredients on the reply .. this point will be after finishing phase 1', 'الرد على النقطة رقم 10 - يمكن لتكامل chatGPT إنشاء الوجبة اعتمادًا على المكونات الموجودة في الرد .. ستكون هذه النقطة بعد الانتهاء من المرحلة الأولى', NULL, NULL, 2, '2024-06-13 11:03:35', '2024-06-13 11:03:35'), (27, 'replying to point no.12 - we can make the item available for clients added from our side', 'الرد على النقطة رقم 12 - يمكننا إتاحة السلعة للعملاء المضافين من جانبنا', NULL, NULL, 2, '2024-06-13 11:08:06', '2024-06-13 11:08:06'), (28, 'replying to point no.15 - customer can change the address once a day or either contact the support', 'الرد على النقطة رقم 15 - يمكن للعميل تغيير العنوان مرة واحدة يوميا أو الاتصال بالدعم', NULL, NULL, 2, '2024-06-13 11:14:57', '2024-06-13 11:14:57'); -- -------------------------------------------------------- -- -- Table structure for table `meeting_participants` -- CREATE TABLE `meeting_participants` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(100) DEFAULT NULL, `nameAr` varchar(100) DEFAULT NULL, `hadAttended` tinyint(1) DEFAULT NULL, `authority` varchar(100) DEFAULT NULL, `jobTitleId` bigint(20) UNSIGNED DEFAULT NULL, `meetingId` bigint(20) UNSIGNED DEFAULT 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 `meeting_participants` -- INSERT INTO `meeting_participants` (`id`, `name`, `nameAr`, `hadAttended`, `authority`, `jobTitleId`, `meetingId`, `created_at`, `updated_at`) VALUES (1, 'Idris Abdel Rahman', 'ادريس عبدالرحمن', NULL, 'Client', 1, 2, '2024-06-13 04:20:59', '2024-06-13 04:20:59'), (2, 'Aymen Najm', 'أيمن نجم', NULL, 'Client', 2, 2, '2024-06-13 04:21:22', '2024-06-13 04:21:22'); -- -------------------------------------------------------- -- -- Table structure for table `memoir_types` -- CREATE TABLE `memoir_types` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT 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 `memoir_types` -- INSERT INTO `memoir_types` (`id`, `name`, `nameAr`, `created_at`, `updated_at`) VALUES (1, 'Type 1', 'النوع الأول', '2024-06-10 10:29:32', '2024-06-10 10:29:32'), (2, 'Type 2', 'النوع الثاني', '2024-06-10 10:29:32', '2024-06-10 10:29: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_11_000002_create_permissions_table', 1), (2, '2014_10_11_000004_create_roles_table', 1), (3, '2014_10_11_000008_create_role_permissions_table', 1), (4, '2014_10_12_000000_create_users_table', 1), (5, '2014_10_12_000002_create_activity_logs_table', 1), (6, '2019_12_14_000001_create_personal_access_tokens_table', 1), (7, '2024_01_15_051001_create_cities_table', 1), (8, '2024_01_15_051002_create_general_settings_table', 1), (9, '2024_01_15_051002_create_nationalities_table', 1), (10, '2024_01_15_051003_create_job_titles_table', 1), (11, '2024_01_15_051003_create_products_table', 1), (12, '2024_01_15_051004_create_banks_table', 1), (13, '2024_01_15_051004_create_profiles_table', 1), (14, '2024_01_15_051005_create_courts_table', 1), (15, '2024_01_15_051006_create_authorities_table', 1), (16, '2024_01_15_051006_create_departments_table', 1), (17, '2024_01_15_051007_create_requirement_types_table', 1), (18, '2024_01_15_051008_create_identity_types_table', 1), (19, '2024_01_15_051009_create_contract_types_table', 1), (20, '2024_01_15_051009_create_document_types_table', 1), (21, '2024_01_15_051010_create_case_types_table', 1), (22, '2024_01_15_051011_create_case_stages_table', 1), (23, '2024_01_15_051014_create_ticket_types_table', 1), (24, '2024_01_15_051015_create_memoir_types_table', 1), (25, '2024_01_15_051018_create_hearing_types_table', 1), (26, '2024_01_15_051018_create_report_types_table', 1), (27, '2024_01_15_051019_create_execution_operation_authorities_table', 1), (28, '2024_01_15_051019_create_execution_operation_types_table', 1), (29, '2024_01_15_051019_create_execution_types_table', 1), (30, '2024_01_15_051020_create_execution_services_table', 1), (31, '2024_01_15_051021_create_client_titles_table', 1), (32, '2024_01_15_051021_create_client_types_table', 1), (33, '2024_01_15_061004_create_clients_table', 1), (34, '2024_01_15_061006_create_client_attachments_table', 1), (35, '2024_01_15_061009_create_client_contracts_table', 1), (36, '2024_01_15_061341_create_opponents_table', 1), (37, '2024_01_15_061344_create_expert_offices_table', 1), (38, '2024_01_15_061457_create_files_table', 1), (39, '2024_01_15_061651_create_file_cases_table', 1), (40, '2024_01_15_061653_create_file_case_claims_table', 1), (41, '2024_01_15_061655_create_file_case_opponents_table', 1), (42, '2024_01_15_062010_create_file_associated_cases_table', 1), (43, '2024_01_15_062016_create_file_case_executions_table', 1), (44, '2024_01_15_062020_create_file_case_execution_operations_table', 1), (45, '2024_01_15_062022_create_file_case_execution_operation_invoices_table', 1), (46, '2024_01_15_062025_create_file_case_hearings_table', 1), (47, '2024_01_15_074926_create_file_case_tickets_table', 1), (48, '2024_01_15_075211_create_file_case_attachments_table', 1), (49, '2024_01_15_075213_create_file_case_requirements_table', 1), (50, '2024_01_15_075357_create_file_case_tasks_table', 1), (51, '2024_01_22_064630_create_file_case_memoirs_table', 1), (52, '2024_01_29_101844_create_file_case_verdicts_table', 1), (53, '2024_01_30_121121_create_file_case_reports_table', 1), (54, '2024_02_05_121822_create_file_case_configurations_table', 1), (55, '2024_05_29_064911_create_execution_files_table', 1), (56, '2024_05_29_064915_create_execution_file_operations_table', 1), (57, '2024_05_29_065302_create_execution_file_operation_invoices_table', 1), (58, '2024_05_30_122424_create_execution_file_tasks_table', 1), (59, '2024_05_30_125213_create_execution_file_attachments_table', 1), (60, '2024_06_01_092400_create_report_files_table', 1), (61, '2024_06_01_092427_create_report_file_operations_table', 1), (62, '2024_06_01_092432_create_report_file_operation_invoices_table', 1), (63, '2024_06_01_092526_create_report_file_tasks_table', 1), (64, '2024_06_01_092535_create_report_file_attachments_table', 1), (65, '2024_06_10_102445_create_meetings_table', 1), (66, '2024_06_10_102849_create_meeting_participants_table', 1), (67, '2024_06_10_102910_create_meeting_agendas_table', 1); -- -------------------------------------------------------- -- -- Table structure for table `nationalities` -- CREATE TABLE `nationalities` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(100) DEFAULT NULL, `nameAr` varchar(100) DEFAULT 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 `nationalities` -- INSERT INTO `nationalities` (`id`, `name`, `nameAr`, `created_at`, `updated_at`) VALUES (1, 'Afghan', 'الأفغاني', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (2, 'Albanian', 'الألبانية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (3, 'Algerian', 'جزائري', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (4, 'American', 'أمريكي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (5, 'Andorran', 'أندورا', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (6, 'Angolan', 'أنغولا', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (7, 'Antiguans', 'أنتيجوان', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (8, 'Argentinean', 'أرجنتيني', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (9, 'Armenian', 'أرمنية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (10, 'Australian', 'الأسترالي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (11, 'Austrian', 'النمساوي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (12, 'Azerbaijani', 'الأذربيجانية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (13, 'Bahamian', 'البهامية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (14, 'Bahraini', 'بحريني', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (15, 'Bangladeshi', 'بنغلاديش', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (16, 'Barbadian', 'بربادوسي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (17, 'Barbudans', 'البربوديون', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (18, 'Batswana', 'باتسوانا', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (19, 'Belarusian', 'البيلاروسية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (20, 'Belgian', 'بلجيكي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (21, 'Belizean', 'البليزية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (22, 'Beninese', 'بنيني', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (23, 'Bhutanese', 'بوتاني', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (24, 'Bolivian', 'البوليفي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (25, 'Bosnian', 'البوسني', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (26, 'Brazilian', 'البرازيلي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (27, 'British', 'بريطاني', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (28, 'Bruneian', 'بروني', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (29, 'Bulgarian', 'البلغارية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (30, 'Burkinabe', 'بوركينا فاسو', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (31, 'Burmese', 'البورمية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (32, 'Burundian', 'بوروندي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (33, 'Cambodian', 'الكمبودية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (34, 'Cameroonian', 'الكاميروني', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (35, 'Canadian', 'كندي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (36, 'Cape Verdean', 'الرأس الأخضر', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (37, 'Central African', 'أفريقيا الوسطى', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (38, 'Chadian', 'التشادية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (39, 'Chilean', 'التشيلية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (40, 'Chinese', 'صينى', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (41, 'Colombian', 'الكولومبي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (42, 'Comoran', 'جزر القمر', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (43, 'Congolese', 'الكونغولي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (44, 'Costa Rican', 'كوستاريكا', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (45, 'Croatian', 'الكرواتية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (46, 'Cuban', 'الكوبي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (47, 'Cypriot', 'القبرصي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (48, 'Czech', 'التشيكية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (49, 'Danish', 'دانماركي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (50, 'Djibouti', 'جيبوتي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (51, 'Dominican', 'الدومينيكي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (52, 'Dutch', 'هولندي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (53, 'East Timorese', 'تيمور الشرقية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (54, 'Ecuadorean', 'الإكوادوري', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (55, 'Egyptian', 'مصري', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (56, 'Emirian', 'أميري', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (57, 'Equatorial Guinean', 'غينيا الاستوائية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (58, 'Eritrean', 'الإريترية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (59, 'Estonian', 'الإستونية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (60, 'Ethiopian', 'الإثيوبية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (61, 'Fijian', 'الفيجي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (62, 'Filipino', 'الفلبينية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (63, 'Finnish', 'الفنلندية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (64, 'French', 'فرنسي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (65, 'Gabonese', 'الجابوني', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (66, 'Gambian', 'غامبيا', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (67, 'Georgian', 'الجورجية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (68, 'German', 'ألمانية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (69, 'Ghanaian', 'الغانية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (70, 'Greek', 'اليونانية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (71, 'Grenadian', 'غريناديان', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (72, 'Guatemalan', 'غواتيمالا', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (73, 'Guinea-Bissauan', 'غينيا بيساو', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (74, 'Guinean', 'غينيا', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (75, 'Guyanese', 'جويانا', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (76, 'Haitian', 'هايتي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (77, 'Herzegovinian', 'الهرسك', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (78, 'Honduran', 'هندوراس', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (79, 'Hungarian', 'المجرية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (80, 'I-Kiribati', 'كيريباتي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (81, 'Icelander', 'أيسلندا', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (82, 'Indian', 'الهندي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (83, 'Indonesian', 'الإندونيسية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (84, 'Iranian', 'إيراني', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (85, 'Iraqi', 'عراقي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (86, 'Irish', 'الأيرلندية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (87, 'Israeli', 'إسرائيلي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (88, 'Italian', 'الإيطالية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (89, 'Ivorian', 'الإيفواري', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (90, 'Jamaican', 'الجامايكي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (91, 'Japanese', 'اليابانية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (92, 'Jordanian', 'أردني', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (93, 'Kazakhstani', 'الكازاخستانية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (94, 'Kenyan', 'الكينية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (95, 'Kittian and Nevisian', 'كيتيان ونيفيسيان', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (96, 'Kuwaiti', 'كويتي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (97, 'Kyrgyz', 'قيرغيزستان', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (98, 'Laotian', 'لاوسية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (99, 'Latvian', 'لاتفيا', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (100, 'Lebanese', 'لبناني', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (101, 'Liberian', 'الليبرية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (102, 'Libyan', 'الليبية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (103, 'Liechtensteiner', 'ليختنشتاينر', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (104, 'Lithuanian', 'الليتوانية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (105, 'Luxembourger', 'لوكسمبورغ', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (106, 'Macedonian', 'المقدونية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (107, 'Malagasy', 'مدغشقر', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (108, 'Malawian', 'ملاوي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (109, 'Malaysian', 'الماليزية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (110, 'Maldivan', 'المالديفية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (111, 'Malian', ' مالي ', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (112, 'Maltese', 'المالطية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (113, 'Marshallese', 'المارشالية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (114, 'Mauritanian', 'موريتاني', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (115, 'Mauritian', 'موريتانيا', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (116, 'Mexican', 'المكسيكي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (117, 'Micronesian', 'ميكرونيزيا', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (118, 'Moldovan', 'المولدوفية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (119, 'Monacan', 'موناكان', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (120, 'Mongolian', 'المنغولية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (121, 'Moroccan', 'المغربي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (122, 'Mosotho', 'موسوتو', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (123, 'Motswana', 'موتسوانا', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (124, 'Mozambican', 'موزمبيقى', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (125, 'Namibian', 'الناميبي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (126, 'Nauruan', 'ناوروان', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (127, 'Nepalese', 'النيبالية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (128, 'New Zealander', 'نيوزيلندي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (129, 'Nicaraguan', 'نيكاراغوا', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (130, 'Nigerian', 'النيجيري', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (131, 'Nigerien', 'النيجيري', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (132, 'North Korean', 'كوري شمالي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (133, 'Northern Irish', 'شمالية إيرلندية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (134, 'Norwegian', 'النرويجية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (135, 'Omani', 'العماني', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (136, 'Pakistani', 'الباكستانية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (137, 'Palauan', 'بالاوي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (138, 'Panamanian', 'بنمي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (139, 'Papua New Guinean', 'بابوا غينيا الجديدة', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (140, 'Paraguayan', 'باراجواي', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (141, 'Peruvian', 'بيرو', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (142, 'Polish', 'تلميع', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (143, 'Portuguese', 'البرتغالية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (144, 'Qatari', 'قطري', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (145, 'Romanian', 'روماني', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (146, 'Russian', 'الروسية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (147, 'Rwandan', 'الرواندية', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (148, 'Saint Lucian', 'سانت لوسيان', '2024-06-10 10:29:30', '2024-06-10 10:29:30'), (149, 'Salvadoran', 'السلفادوري', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (150, 'Samoan', 'ساموا', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (151, 'San Marinese', 'سان مارينيز', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (152, 'Sao Tomean', 'ساو توميان', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (153, 'Saudi', 'سعودي', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (154, 'Scottish', 'اسكتلندي', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (155, 'Senegalese', 'سنغالي', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (156, 'Serbian', 'الصربية', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (157, 'Seychellois', 'سيشيل', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (158, 'Sierra Leonean', 'سيراليوني', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (159, 'Singaporean', 'سنغافوري', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (160, 'Slovakian', 'السلوفاكية', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (161, 'Slovenian', 'السلوفينية', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (162, 'Solomon Islander', 'جزر سليمان', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (163, 'Somali', 'الصومالي', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (164, 'South African', 'جنوب افريقيا', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (165, 'South Korean', 'كوريا الجنوبية', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (166, 'Spanish', 'الأسبانية', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (167, 'Sri Lankan', 'سري لانكا', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (168, 'Sudanese', 'السوداني', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (169, 'Surinamer', 'سورينمر', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (170, 'Swazi', 'سوازيلاند', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (171, 'Swedish', 'السويدي', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (172, 'Swiss', 'السويسري', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (173, 'Syrian', 'السورية', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (174, 'Taiwanese', 'تايوانية', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (175, 'Tajik', 'الطاجيكية', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (176, 'Tanzanian', 'التنزانية', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (177, 'Thai', 'التايلاندية', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (178, 'Togolese', 'التوغولي', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (179, 'Tongan', 'تونجا', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (180, 'Trinidadian or Tobagonian', 'ترينيداد أو توباجوني', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (181, 'Tunisian', 'تونسي', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (182, 'Turkish', 'اللغة التركية', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (183, 'Tuvaluan', 'التوفالوية', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (184, 'Ugandan', 'الأوغندية', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (185, 'Ukrainian', 'الأوكرانية', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (186, 'Uruguayan', 'الأوروغواي', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (187, 'Uzbekistani', 'أوزبكستاني', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (188, 'Venezuelan', 'الفنزويلية', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (189, 'Vietnamese', 'الفيتنامية', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (190, 'Welsh', 'تهرب من دفع الرهان', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (191, 'Yemenite', 'اليمني', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (192, 'Zambian', 'زامبيا', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (193, 'Zimbabwean', 'زيمبابوي', '2024-06-10 10:29:31', '2024-06-10 10:29:31'); -- -------------------------------------------------------- -- -- Table structure for table `opponents` -- CREATE TABLE `opponents` ( `id` bigint(20) UNSIGNED NOT NULL, `serial` varchar(100) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT NULL, `fileType` varchar(100) DEFAULT 'Civil File', `email` varchar(255) DEFAULT NULL, `phone` varchar(100) DEFAULT NULL, `landline` varchar(100) DEFAULT NULL, `fax` varchar(100) DEFAULT NULL, `imageFile` text DEFAULT NULL, `identity` varchar(255) DEFAULT NULL, `accountNumber` varchar(255) DEFAULT NULL, `nationalityId` bigint(20) UNSIGNED DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `addressAr` varchar(255) DEFAULT NULL, `information` text DEFAULT NULL, `informationAr` text DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `opponents` -- INSERT INTO `opponents` (`id`, `serial`, `name`, `nameAr`, `fileType`, `email`, `phone`, `landline`, `fax`, `imageFile`, `identity`, `accountNumber`, `nationalityId`, `address`, `addressAr`, `information`, `informationAr`, `creationDate`, `creatorId`, `created_at`, `updated_at`) VALUES (1, 'O-0001', 'Al Tamayez Holding Company', 'شركة التمييز القابضة', 'Civil File', 'info@altamyez.com', '0666666666', '0666666666', '0666666666', 'OPP-04.09AM145113416770.png', '123456', '1234', 4, NULL, NULL, NULL, NULL, '2024-06-11', 1, '2024-06-11 11:09:06', '2024-06-11 11:09:06'), (2, 'O-0002', 'MR SATYAWAN SINGH', 'السيد ساتياوان سينغ', 'Report File', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-11', 1, '2024-06-11 11:32:50', '2024-06-11 11:32:50'), (3, 'O-0003', 'MR KHENETTE CASTILLO', 'السيد خينيت كاستيلو', 'Report File', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-11', 1, '2024-06-11 11:32:52', '2024-06-11 11:32:52'), (4, 'O-0004', 'MARK NOEL LIM DE GUZMAN', 'مارك نويل ليم دي جوزمان', 'Report File', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-11', 1, '2024-06-11 11:32:53', '2024-06-11 11:32:53'), (5, 'O-0005', 'MR WARWICK STEPHEN STICHBURY', 'السيد وارويك ستيفن ستيتشبيري', 'Report File', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-11', 1, '2024-06-11 11:32:53', '2024-06-11 11:32:53'), (6, 'O-0006', 'MS AILYN NADAL', 'السيدة إيلين نادال', 'Report File', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-11', 1, '2024-06-11 11:32:54', '2024-06-11 11:32:54'), (7, 'O-0007', 'MR SHADHEES DHANAPAL', 'السيد شاديس دانبال', 'Report File', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-11', 1, '2024-06-11 11:32:55', '2024-06-11 11:32:55'), (8, 'O-0008', 'ASRAF ALI ABDUL MUTHALIEF', 'أشرف علي عبد المخلف', 'Report File', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-11', 1, '2024-06-11 11:32:55', '2024-06-11 11:32:55'), (9, 'O-0009', 'MR ALY RASHAD SOLIMAN', 'السيد علي رشاد سليمان', 'Report File', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-11', 1, '2024-06-11 11:32:56', '2024-06-11 11:32:56'), (10, 'O-0010', 'MR JAYARAS JACKSON', 'السيد جاياراس جاكسون', 'Report File', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-11', 1, '2024-06-11 11:32:57', '2024-06-11 11:32:57'); -- -------------------------------------------------------- -- -- Table structure for table `permissions` -- CREATE TABLE `permissions` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT NULL, `isFor` varchar(100) DEFAULT 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 `permissions` -- INSERT INTO `permissions` (`id`, `name`, `nameAr`, `isFor`, `created_at`, `updated_at`) VALUES (1, 'Dashboard', 'الرئيسية', 'Module', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (2, 'Manage Clients', 'إدارة العملاء', 'Module', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (3, 'Manage Cases', 'إدارة القضايا', 'Module', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (4, 'Search', 'البحث', 'Module', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (5, 'Reports', 'التقارير', 'Module', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (6, 'Tasks', 'المهام', 'Module', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (7, 'Management', 'الإدارة', 'Module', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (8, 'Settings', 'الإعدادات', 'Module', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (9, 'Create Actions', 'اجراءات الاضافة', 'Action', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (10, 'Update Actions', 'اجراءات التعديل', 'Action', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (11, 'Remove Actions', 'اجراءات الحذف', 'Action', '2024-06-10 10:29:31', '2024-06-10 10:29:31'); -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `last_used_at` timestamp NULL DEFAULT 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 `personal_access_tokens` -- INSERT INTO `personal_access_tokens` (`id`, `tokenable_type`, `tokenable_id`, `name`, `token`, `abilities`, `expires_at`, `last_used_at`, `created_at`, `updated_at`) VALUES (1, 'App\\Models\\User', 1, 'user', 'b355943a6e75b1932b21cc5296b91d4cb320c90daa8b8bc2efdfb5265dafcb0a', '[\"role:user\"]', NULL, '2024-06-10 20:36:11', '2024-06-10 20:34:50', '2024-06-10 20:36:11'), (2, 'App\\Models\\User', 1, 'user', '2494d87f0adfc21f97788fdcbe8b0681171351429769f3e45a95ff0d0ccdf566', '[\"role:user\"]', NULL, NULL, '2024-06-11 03:21:51', '2024-06-11 03:21:51'), (3, 'App\\Models\\User', 1, 'user', 'a637cbd60326619643c6ec53089c230d0d68157add5ded6e9129c7ef1dc5526a', '[\"role:user\"]', NULL, '2024-06-11 11:40:35', '2024-06-11 11:03:24', '2024-06-11 11:40:35'), (4, 'App\\Models\\User', 2, 'user', '2f35dba055e6cdab2f72d54c28a8306b0661d77ae09168d085519febe3f4df3d', '[\"role:user\"]', NULL, NULL, '2024-06-11 16:16:34', '2024-06-11 16:16:34'), (5, 'App\\Models\\User', 2, 'user', 'e26f78b0af90d8f0f5fa938bfbff47d685d662091b0e96c5ea2600a196bf5b14', '[\"role:user\"]', NULL, NULL, '2024-06-11 19:54:56', '2024-06-11 19:54:56'), (6, 'App\\Models\\User', 1, 'user', '8c3d2897d0e3b74538a37fedb442b735594b154ac1120b9e0c58302072c191ae', '[\"role:user\"]', NULL, '2024-06-11 20:00:36', '2024-06-11 19:55:08', '2024-06-11 20:00:36'), (7, 'App\\Models\\User', 1, 'user', 'decf28ae26059699b1697d643bf6cc9b5e6efbd4e86c343223fe16a22aa8bf27', '[\"role:user\"]', NULL, NULL, '2024-06-11 20:41:20', '2024-06-11 20:41:20'), (8, 'App\\Models\\User', 1, 'user', '26566f719336d4537f329bd43d32adcdad3013a40de084706e94ae8bf38c32e3', '[\"role:user\"]', NULL, NULL, '2024-06-12 13:03:16', '2024-06-12 13:03:16'), (9, 'App\\Models\\User', 1, 'user', 'f41ea082c5a1c9c15ddfce2a650c66ffba26179afd6951d71ac22267e333f8a9', '[\"role:user\"]', NULL, NULL, '2024-06-12 16:46:57', '2024-06-12 16:46:57'), (10, 'App\\Models\\User', 1, 'user', '0cdb6c0dd026904202766c82b6620ffa6331b3b7d3704961887e7b6a8e2aeadf', '[\"role:user\"]', NULL, '2024-06-12 21:13:45', '2024-06-12 20:53:06', '2024-06-12 21:13:45'), (11, 'App\\Models\\User', 1, 'user', '5a8fa543f91f75f91558d05d71c49fd9b974ba914f8f799d87a2f87e8bbc0883', '[\"role:user\"]', NULL, '2024-06-13 04:15:17', '2024-06-13 04:12:51', '2024-06-13 04:15:17'), (12, 'App\\Models\\User', 1, 'user', 'd18d0631e685c3039644b5847a416d4aeefef3da308184bb7781c083d890a875', '[\"role:user\"]', NULL, '2024-06-13 17:11:21', '2024-06-13 04:16:16', '2024-06-13 17:11:21'); -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE `products` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT 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 `products` -- INSERT INTO `products` (`id`, `name`, `nameAr`, `created_at`, `updated_at`) VALUES (1, 'DF CARDS', 'بطاقات الدفاع', '2024-06-11 11:32:51', '2024-06-11 11:32:51'); -- -------------------------------------------------------- -- -- Table structure for table `profiles` -- CREATE TABLE `profiles` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT NULL, `phone` varchar(100) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `imageFile` text DEFAULT NULL, `preloaderImageFile` text DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `addressAr` varchar(255) DEFAULT NULL, `information` text DEFAULT NULL, `informationAr` text DEFAULT NULL, `establishment` text DEFAULT NULL, `establishmentAr` text DEFAULT NULL, `WebsiteURL` text DEFAULT 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 `report_files` -- CREATE TABLE `report_files` ( `id` bigint(20) UNSIGNED NOT NULL, `serial` varchar(100) DEFAULT NULL, `reportNumber` varchar(255) DEFAULT NULL, `reportDate` varchar(100) DEFAULT NULL, `status` varchar(100) DEFAULT 'Pending', `information` text DEFAULT NULL, `informationAr` text DEFAULT NULL, `reportTypeId` bigint(20) UNSIGNED DEFAULT NULL, `defendantId` bigint(20) UNSIGNED DEFAULT NULL, `accountNumber` text DEFAULT NULL, `cardNumber` text DEFAULT NULL, `loanNumber` text DEFAULT NULL, `circularNumber` text DEFAULT NULL, `chequeNumber` varchar(255) DEFAULT NULL, `chequeAmount` double DEFAULT NULL, `chequeActualAmount` double DEFAULT NULL, `bankId` bigint(20) UNSIGNED DEFAULT NULL, `courtId` bigint(20) UNSIGNED DEFAULT NULL, `productId` bigint(20) UNSIGNED DEFAULT NULL, `isConceded` varchar(255) DEFAULT NULL, `concedingDate` varchar(100) DEFAULT NULL, `caseId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `report_files` -- INSERT INTO `report_files` (`id`, `serial`, `reportNumber`, `reportDate`, `status`, `information`, `informationAr`, `reportTypeId`, `defendantId`, `accountNumber`, `cardNumber`, `loanNumber`, `circularNumber`, `chequeNumber`, `chequeAmount`, `chequeActualAmount`, `bankId`, `courtId`, `productId`, `isConceded`, `concedingDate`, `caseId`, `clientId`, `creationDate`, `creatorId`, `created_at`, `updated_at`) VALUES (1, 'MA-0001', '0001', '2024-06-11', 'Active', 'The check is original', 'الشيك اصل', NULL, 2, '0005242041927284886', '1031151754348015', NULL, NULL, '1361959', 30000, 31197.43, 1, 3, 1, NULL, NULL, NULL, 1, '2024-06-11', 1, '2024-06-11 11:32:51', '2024-06-11 11:32:51'), (2, 'MA-0002', '0002', '2024-06-11', 'Active', 'The check is original', 'الشيك اصل', NULL, 3, '0005161004199503224', '1031151756165018', NULL, NULL, '1359224', 30000, 34194.66, 1, 4, 1, NULL, NULL, NULL, 1, '2024-06-11', 1, '2024-06-11 11:32:52', '2024-06-11 11:32:52'), (3, 'MA-0003', '0003', '2024-06-11', 'Active', 'The check is original', 'الشيك اصل', NULL, 4, '0005242044082921292', '1031151882975015', NULL, NULL, '1419249', 30000, 30967.34, 1, 3, 1, NULL, NULL, NULL, 1, '2024-06-11', 1, '2024-06-11 11:32:53', '2024-06-11 11:32:53'), (4, 'MA-0004', '0004', '2024-06-11', 'Active', 'The check is original', 'الشيك اصل', NULL, 5, '0005242041107124381', '1031151927771015', NULL, NULL, '1453679', 30000, 31745.78, 1, 3, 1, NULL, NULL, NULL, 1, '2024-06-11', 1, '2024-06-11 11:32:53', '2024-06-11 11:32:53'), (5, 'MA-0005', '0005', '2024-06-11', 'Active', 'The check is original', 'الشيك اصل', NULL, 6, '0005161004199536430', '1031151792968015', NULL, NULL, '1377153', 31000, 48350.23, 1, 3, 1, NULL, NULL, NULL, 1, '2024-06-11', 1, '2024-06-11 11:32:54', '2024-06-11 11:32:54'), (6, 'MA-0006', '0006', '2024-06-11', 'Active', 'The check is original', 'الشيك اصل', NULL, 7, '0005161004033627007', '1031151133460038', NULL, NULL, '1354736', 35000, 29786.14, 1, 3, 1, NULL, NULL, NULL, 1, '2024-06-11', 1, '2024-06-11 11:32:55', '2024-06-11 11:32:55'), (7, 'MA-0007', '0007', '2024-06-11', 'Active', 'The check is original', 'الشيك اصل', NULL, 8, '0005242042517946090', '1031151173378020', NULL, NULL, '1437423', 35000, 39667.92, 1, 3, 1, NULL, NULL, NULL, 1, '2024-06-11', 1, '2024-06-11 11:32:55', '2024-06-11 11:32:55'), (8, 'MA-0008', '0008', '2024-06-11', 'Active', 'The check is original', 'الشيك اصل', NULL, 9, '0005242040760405673', '1031151795989016', NULL, NULL, '1377065', 36000, 39920.6, 1, 3, 1, NULL, NULL, NULL, 1, '2024-06-11', 1, '2024-06-11 11:32:56', '2024-06-11 11:32:56'), (9, 'MA-0009', '0009', '2024-06-11', 'Active', 'The check is original', 'الشيك اصل', NULL, 10, '0005161784199522197', '1031151760586016', NULL, NULL, '1361765', 40000, 49123.61, 1, 3, 1, NULL, NULL, NULL, 1, '2024-06-11', 1, '2024-06-11 11:32:57', '2024-06-11 11:32:57'); -- -------------------------------------------------------- -- -- Table structure for table `report_file_attachments` -- CREATE TABLE `report_file_attachments` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT NULL, `documentNumber` varchar(100) DEFAULT NULL, `documentDate` varchar(100) DEFAULT NULL, `documentTypeId` bigint(20) UNSIGNED DEFAULT NULL, `documentFile` text DEFAULT NULL, `documentFileSize` text DEFAULT NULL, `information` text DEFAULT NULL, `informationAr` text DEFAULT NULL, `reportFileId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `report_file_operations` -- CREATE TABLE `report_file_operations` ( `id` bigint(20) UNSIGNED NOT NULL, `operationDate` varchar(100) DEFAULT NULL, `status` varchar(100) DEFAULT 'Pending', `information` text DEFAULT NULL, `informationAr` text DEFAULT NULL, `note` text DEFAULT NULL, `noteAr` text DEFAULT NULL, `operationFees` double(15,2) DEFAULT NULL, `operationAmount` double(15,2) DEFAULT NULL, `documentFile` text DEFAULT NULL, `secondDocumentFile` text DEFAULT NULL, `thirdDocumentFile` text DEFAULT NULL, `fourthDocumentFile` text DEFAULT NULL, `reportOperationTypeId` bigint(20) UNSIGNED DEFAULT NULL, `reportOperationAuthorityId` bigint(20) UNSIGNED DEFAULT NULL, `reportFileId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `report_file_operations` -- INSERT INTO `report_file_operations` (`id`, `operationDate`, `status`, `information`, `informationAr`, `note`, `noteAr`, `operationFees`, `operationAmount`, `documentFile`, `secondDocumentFile`, `thirdDocumentFile`, `fourthDocumentFile`, `reportOperationTypeId`, `reportOperationAuthorityId`, `reportFileId`, `clientId`, `creationDate`, `creatorId`, `created_at`, `updated_at`) VALUES (1, NULL, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, NULL, '2024-06-11', 1, '2024-06-11 11:32:51', '2024-06-11 11:32:51'), (2, NULL, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, 1, NULL, '2024-06-11', 1, '2024-06-11 11:32:51', '2024-06-11 11:32:51'), (3, NULL, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 2, NULL, '2024-06-11', 1, '2024-06-11 11:32:52', '2024-06-11 11:32:52'), (4, NULL, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, 2, NULL, '2024-06-11', 1, '2024-06-11 11:32:52', '2024-06-11 11:32:52'), (5, NULL, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 3, NULL, '2024-06-11', 1, '2024-06-11 11:32:53', '2024-06-11 11:32:53'), (6, NULL, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, 3, NULL, '2024-06-11', 1, '2024-06-11 11:32:53', '2024-06-11 11:32:53'), (7, NULL, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 4, NULL, '2024-06-11', 1, '2024-06-11 11:32:53', '2024-06-11 11:32:53'), (8, NULL, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, 4, NULL, '2024-06-11', 1, '2024-06-11 11:32:53', '2024-06-11 11:32:53'), (9, NULL, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 5, NULL, '2024-06-11', 1, '2024-06-11 11:32:54', '2024-06-11 11:32:54'), (10, NULL, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, 5, NULL, '2024-06-11', 1, '2024-06-11 11:32:54', '2024-06-11 11:32:54'), (11, NULL, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 6, NULL, '2024-06-11', 1, '2024-06-11 11:32:55', '2024-06-11 11:32:55'), (12, NULL, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, 6, NULL, '2024-06-11', 1, '2024-06-11 11:32:55', '2024-06-11 11:32:55'), (13, NULL, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 7, NULL, '2024-06-11', 1, '2024-06-11 11:32:55', '2024-06-11 11:32:55'), (14, NULL, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, 7, NULL, '2024-06-11', 1, '2024-06-11 11:32:55', '2024-06-11 11:32:55'), (15, NULL, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 8, NULL, '2024-06-11', 1, '2024-06-11 11:32:56', '2024-06-11 11:32:56'), (16, NULL, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, 8, NULL, '2024-06-11', 1, '2024-06-11 11:32:56', '2024-06-11 11:32:56'), (17, NULL, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 9, NULL, '2024-06-11', 1, '2024-06-11 11:32:57', '2024-06-11 11:32:57'), (18, NULL, 'Pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, 9, NULL, '2024-06-11', 1, '2024-06-11 11:32:57', '2024-06-11 11:32:57'); -- -------------------------------------------------------- -- -- Table structure for table `report_file_operation_invoices` -- CREATE TABLE `report_file_operation_invoices` ( `id` bigint(20) UNSIGNED NOT NULL, `title` text DEFAULT NULL, `titleAr` text DEFAULT NULL, `invoiceDate` varchar(100) DEFAULT NULL, `invoiceAmount` double(15,2) DEFAULT NULL, `documentFile` text DEFAULT NULL, `note` text DEFAULT NULL, `noteAr` text DEFAULT NULL, `reportFileId` bigint(20) UNSIGNED DEFAULT NULL, `reportFileOperationId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `report_file_tasks` -- CREATE TABLE `report_file_tasks` ( `id` bigint(20) UNSIGNED NOT NULL, `taskNumber` varchar(100) DEFAULT NULL, `status` varchar(100) DEFAULT 'Pending', `assignDate` varchar(100) DEFAULT NULL, `executionDate` varchar(100) DEFAULT NULL, `dueDate` varchar(100) DEFAULT NULL, `completionDate` varchar(100) DEFAULT NULL, `information` text DEFAULT NULL, `informationAr` text DEFAULT NULL, `taskHandlerId` bigint(20) UNSIGNED DEFAULT NULL, `taskFollowerId` bigint(20) UNSIGNED DEFAULT NULL, `reportFileId` bigint(20) UNSIGNED DEFAULT NULL, `clientId` bigint(20) UNSIGNED DEFAULT NULL, `creationDate` varchar(100) DEFAULT NULL, `creatorId` bigint(20) UNSIGNED DEFAULT 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 `report_types` -- CREATE TABLE `report_types` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT 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 `report_types` -- INSERT INTO `report_types` (`id`, `name`, `nameAr`, `created_at`, `updated_at`) VALUES (1, 'Standard Report', 'التقرير القياسي', '2024-06-10 10:29:32', '2024-06-10 10:29:32'), (2, 'Detailed Report', 'تقرير مفصل', '2024-06-10 10:29:32', '2024-06-10 10:29:32'); -- -------------------------------------------------------- -- -- Table structure for table `requirement_types` -- CREATE TABLE `requirement_types` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT 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 `roles` -- CREATE TABLE `roles` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT 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 `roles` -- INSERT INTO `roles` (`id`, `name`, `nameAr`, `created_at`, `updated_at`) VALUES (1, 'Administrator', 'الأدمن', '2024-06-10 10:29:31', '2024-06-10 10:29:31'), (2, 'Secretary', 'سكرتير', '2024-06-11 11:37:08', '2024-06-11 11:37:08'); -- -------------------------------------------------------- -- -- Table structure for table `role_permissions` -- CREATE TABLE `role_permissions` ( `id` bigint(20) UNSIGNED NOT NULL, `roleId` bigint(20) UNSIGNED DEFAULT NULL, `permissionId` bigint(20) UNSIGNED DEFAULT NULL, `isAllowed` tinyint(1) DEFAULT 0, `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 `role_permissions` -- INSERT INTO `role_permissions` (`id`, `roleId`, `permissionId`, `isAllowed`, `created_at`, `updated_at`) VALUES (1, 1, 1, 0, '2024-06-10 20:35:25', '2024-06-10 20:35:25'), (2, 1, 2, 0, '2024-06-10 20:35:25', '2024-06-10 20:35:25'), (3, 1, 3, 0, '2024-06-10 20:35:25', '2024-06-10 20:35:25'), (4, 1, 4, 0, '2024-06-10 20:35:25', '2024-06-10 20:35:25'), (5, 1, 5, 0, '2024-06-10 20:35:25', '2024-06-10 20:35:25'), (6, 1, 6, 0, '2024-06-10 20:35:25', '2024-06-10 20:35:25'), (7, 1, 7, 0, '2024-06-10 20:35:25', '2024-06-10 20:35:25'), (8, 1, 8, 0, '2024-06-10 20:35:25', '2024-06-10 20:35:25'), (9, 1, 9, 0, '2024-06-10 20:35:25', '2024-06-10 20:35:25'), (10, 1, 10, 0, '2024-06-10 20:35:25', '2024-06-10 20:35:25'), (11, 1, 11, 0, '2024-06-10 20:35:25', '2024-06-10 20:35:25'), (16, 2, 1, 0, '2024-06-11 11:37:27', '2024-06-11 11:37:27'), (17, 2, 2, 0, '2024-06-11 11:37:27', '2024-06-11 11:37:27'), (18, 2, 4, 0, '2024-06-11 11:37:27', '2024-06-11 11:37:27'), (19, 2, 8, 0, '2024-06-11 11:37:27', '2024-06-11 11:37:27'), (20, 2, 9, 0, '2024-06-11 11:37:27', '2024-06-11 11:37:27'), (21, 2, 10, 0, '2024-06-11 11:37:27', '2024-06-11 11:37:27'); -- -------------------------------------------------------- -- -- Table structure for table `ticket_types` -- CREATE TABLE `ticket_types` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `nameAr` varchar(255) DEFAULT 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 `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(100) DEFAULT NULL, `nameAr` varchar(100) DEFAULT NULL, `phone` varchar(100) DEFAULT NULL, `email` varchar(255) NOT NULL, `password` text DEFAULT NULL, `imageFile` text DEFAULT NULL, `isActive` tinyint(1) DEFAULT 1, `roleId` bigint(20) UNSIGNED DEFAULT NULL, `remember_token` varchar(100) DEFAULT 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 `users` -- INSERT INTO `users` (`id`, `name`, `nameAr`, `phone`, `email`, `password`, `imageFile`, `isActive`, `roleId`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'Administrator', 'الأدمن', '9715590100', 'admin@lfm.ae', '$2y$12$IaW4Ct.SAT7RQvw8PSousOtwnxbQBfyC3Lj3/jZSLuPzxjuuIxjrG', NULL, 1, 1, NULL, '2024-06-10 10:29:32', '2024-06-10 10:29:32'), (2, 'Rawan Ahmed Al-Anzi', 'روان احمد العنزي', '0522222222', 'sec@lfm.ae', '$2y$12$IrT0K.vzns61FKuSloO44.r/BXzS7NqGL5M3A809hVqmY.zDf0/5m', 'USR-04.40AM625219157928.png', 1, 2, NULL, '2024-06-11 11:40:35', '2024-06-11 11:40:35'); -- -- Indexes for dumped tables -- -- -- Indexes for table `activity_logs` -- ALTER TABLE `activity_logs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `authorities` -- ALTER TABLE `authorities` ADD PRIMARY KEY (`id`); -- -- Indexes for table `banks` -- ALTER TABLE `banks` ADD PRIMARY KEY (`id`); -- -- Indexes for table `case_stages` -- ALTER TABLE `case_stages` ADD PRIMARY KEY (`id`), ADD KEY `case_stages_casetypeid_foreign` (`caseTypeId`); -- -- Indexes for table `case_types` -- ALTER TABLE `case_types` ADD PRIMARY KEY (`id`); -- -- Indexes for table `cities` -- ALTER TABLE `cities` ADD PRIMARY KEY (`id`); -- -- Indexes for table `clients` -- ALTER TABLE `clients` ADD PRIMARY KEY (`id`), ADD KEY `clients_clienttypeid_foreign` (`clientTypeId`), ADD KEY `clients_nationalityid_foreign` (`nationalityId`), ADD KEY `clients_branchcityid_foreign` (`branchCityId`), ADD KEY `clients_creatorid_foreign` (`creatorId`); -- -- Indexes for table `client_attachments` -- ALTER TABLE `client_attachments` ADD PRIMARY KEY (`id`), ADD KEY `client_attachments_identitytypeid_foreign` (`identityTypeId`), ADD KEY `client_attachments_clientid_foreign` (`clientId`), ADD KEY `client_attachments_creatorid_foreign` (`creatorId`); -- -- Indexes for table `client_contracts` -- ALTER TABLE `client_contracts` ADD PRIMARY KEY (`id`), ADD KEY `client_contracts_contracttypeid_foreign` (`contractTypeId`), ADD KEY `client_contracts_clientid_foreign` (`clientId`), ADD KEY `client_contracts_creatorid_foreign` (`creatorId`); -- -- Indexes for table `client_titles` -- ALTER TABLE `client_titles` ADD PRIMARY KEY (`id`); -- -- Indexes for table `client_types` -- ALTER TABLE `client_types` ADD PRIMARY KEY (`id`); -- -- Indexes for table `contract_types` -- ALTER TABLE `contract_types` ADD PRIMARY KEY (`id`); -- -- Indexes for table `courts` -- ALTER TABLE `courts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `departments` -- ALTER TABLE `departments` ADD PRIMARY KEY (`id`); -- -- Indexes for table `document_types` -- ALTER TABLE `document_types` ADD PRIMARY KEY (`id`); -- -- Indexes for table `execution_files` -- ALTER TABLE `execution_files` ADD PRIMARY KEY (`id`), ADD KEY `execution_files_executiontypeid_foreign` (`executionTypeId`), ADD KEY `execution_files_defendantid_foreign` (`defendantId`), ADD KEY `execution_files_bankid_foreign` (`bankId`), ADD KEY `execution_files_courtid_foreign` (`courtId`), ADD KEY `execution_files_productid_foreign` (`productId`), ADD KEY `execution_files_caseid_foreign` (`caseId`), ADD KEY `execution_files_clientid_foreign` (`clientId`), ADD KEY `execution_files_creatorid_foreign` (`creatorId`); -- -- Indexes for table `execution_file_attachments` -- ALTER TABLE `execution_file_attachments` ADD PRIMARY KEY (`id`), ADD KEY `execution_file_attachments_documenttypeid_foreign` (`documentTypeId`), ADD KEY `execution_file_attachments_executionfileid_foreign` (`executionFileId`), ADD KEY `execution_file_attachments_clientid_foreign` (`clientId`), ADD KEY `execution_file_attachments_creatorid_foreign` (`creatorId`); -- -- Indexes for table `execution_file_operations` -- ALTER TABLE `execution_file_operations` ADD PRIMARY KEY (`id`), ADD KEY `execution_file_operations_executionoperationtypeid_foreign` (`executionOperationTypeId`), ADD KEY `eoa_id_foreign` (`executionOperationAuthorityId`), ADD KEY `execution_file_operations_executionfileid_foreign` (`executionFileId`), ADD KEY `execution_file_operations_clientid_foreign` (`clientId`), ADD KEY `execution_file_operations_creatorid_foreign` (`creatorId`); -- -- Indexes for table `execution_file_operation_invoices` -- ALTER TABLE `execution_file_operation_invoices` ADD PRIMARY KEY (`id`), ADD KEY `execution_file_operation_invoices_executionfileid_foreign` (`executionFileId`), ADD KEY `efo_id_foreign` (`executionFileOperationId`), ADD KEY `execution_file_operation_invoices_clientid_foreign` (`clientId`), ADD KEY `execution_file_operation_invoices_creatorid_foreign` (`creatorId`); -- -- Indexes for table `execution_file_tasks` -- ALTER TABLE `execution_file_tasks` ADD PRIMARY KEY (`id`), ADD KEY `execution_file_tasks_taskhandlerid_foreign` (`taskHandlerId`), ADD KEY `execution_file_tasks_taskfollowerid_foreign` (`taskFollowerId`), ADD KEY `execution_file_tasks_executionfileid_foreign` (`executionFileId`), ADD KEY `execution_file_tasks_clientid_foreign` (`clientId`), ADD KEY `execution_file_tasks_creatorid_foreign` (`creatorId`); -- -- Indexes for table `execution_operation_authorities` -- ALTER TABLE `execution_operation_authorities` ADD PRIMARY KEY (`id`); -- -- Indexes for table `execution_operation_types` -- ALTER TABLE `execution_operation_types` ADD PRIMARY KEY (`id`); -- -- Indexes for table `execution_services` -- ALTER TABLE `execution_services` ADD PRIMARY KEY (`id`); -- -- Indexes for table `execution_types` -- ALTER TABLE `execution_types` ADD PRIMARY KEY (`id`); -- -- Indexes for table `expert_offices` -- ALTER TABLE `expert_offices` ADD PRIMARY KEY (`id`); -- -- Indexes for table `files` -- ALTER TABLE `files` ADD PRIMARY KEY (`id`), ADD KEY `files_clientid_foreign` (`clientId`), ADD KEY `files_creatorid_foreign` (`creatorId`); -- -- Indexes for table `file_associated_cases` -- ALTER TABLE `file_associated_cases` ADD PRIMARY KEY (`id`), ADD KEY `file_associated_cases_casetypeid_foreign` (`caseTypeId`), ADD KEY `file_associated_cases_casestageid_foreign` (`caseStageId`), ADD KEY `file_associated_cases_clienttitleid_foreign` (`clientTitleId`), ADD KEY `file_associated_cases_courtid_foreign` (`courtId`), ADD KEY `file_associated_cases_departmentid_foreign` (`departmentId`), ADD KEY `file_associated_cases_fileid_foreign` (`fileId`), ADD KEY `file_associated_cases_caseid_foreign` (`caseId`), ADD KEY `file_associated_cases_clientid_foreign` (`clientId`), ADD KEY `file_associated_cases_branchcityid_foreign` (`branchCityId`), ADD KEY `file_associated_cases_administrativeid_foreign` (`administrativeId`), ADD KEY `file_associated_cases_secadministrativeid_foreign` (`secAdministrativeId`), ADD KEY `file_associated_cases_thirdadministrativeid_foreign` (`thirdAdministrativeId`), ADD KEY `file_associated_cases_advisorid_foreign` (`advisorId`), ADD KEY `file_associated_cases_secadvisorid_foreign` (`secAdvisorId`), ADD KEY `file_associated_cases_thirdadvisorid_foreign` (`thirdAdvisorId`), ADD KEY `file_associated_cases_pleadinglawyerid_foreign` (`pleadingLawyerId`), ADD KEY `file_associated_cases_secpleadinglawyerid_foreign` (`secPleadingLawyerId`), ADD KEY `file_associated_cases_thirdpleadinglawyerid_foreign` (`thirdPleadingLawyerId`), ADD KEY `file_associated_cases_creatorid_foreign` (`creatorId`); -- -- Indexes for table `file_cases` -- ALTER TABLE `file_cases` ADD PRIMARY KEY (`id`), ADD KEY `file_cases_casetypeid_foreign` (`caseTypeId`), ADD KEY `file_cases_casestageid_foreign` (`caseStageId`), ADD KEY `file_cases_clienttitleid_foreign` (`clientTitleId`), ADD KEY `file_cases_courtid_foreign` (`courtId`), ADD KEY `file_cases_departmentid_foreign` (`departmentId`), ADD KEY `file_cases_fileid_foreign` (`fileId`), ADD KEY `file_cases_clientid_foreign` (`clientId`), ADD KEY `file_cases_administrativeid_foreign` (`administrativeId`), ADD KEY `file_cases_secadministrativeid_foreign` (`secAdministrativeId`), ADD KEY `file_cases_thirdadministrativeid_foreign` (`thirdAdministrativeId`), ADD KEY `file_cases_advisorid_foreign` (`advisorId`), ADD KEY `file_cases_secadvisorid_foreign` (`secAdvisorId`), ADD KEY `file_cases_thirdadvisorid_foreign` (`thirdAdvisorId`), ADD KEY `file_cases_pleadinglawyerid_foreign` (`pleadingLawyerId`), ADD KEY `file_cases_secpleadinglawyerid_foreign` (`secPleadingLawyerId`), ADD KEY `file_cases_thirdpleadinglawyerid_foreign` (`thirdPleadingLawyerId`), ADD KEY `file_cases_creatorid_foreign` (`creatorId`); -- -- Indexes for table `file_case_attachments` -- ALTER TABLE `file_case_attachments` ADD PRIMARY KEY (`id`), ADD KEY `file_case_attachments_documenttypeid_foreign` (`documentTypeId`), ADD KEY `file_case_attachments_fileid_foreign` (`fileId`), ADD KEY `file_case_attachments_caseid_foreign` (`caseId`), ADD KEY `file_case_attachments_caseexecutionid_foreign` (`caseExecutionId`), ADD KEY `file_case_attachments_associatedcaseid_foreign` (`associatedCaseId`), ADD KEY `file_case_attachments_clientid_foreign` (`clientId`), ADD KEY `file_case_attachments_creatorid_foreign` (`creatorId`); -- -- Indexes for table `file_case_claims` -- ALTER TABLE `file_case_claims` ADD PRIMARY KEY (`id`), ADD KEY `file_case_claims_fileid_foreign` (`fileId`), ADD KEY `file_case_claims_caseid_foreign` (`caseId`), ADD KEY `file_case_claims_creatorid_foreign` (`creatorId`); -- -- Indexes for table `file_case_configurations` -- ALTER TABLE `file_case_configurations` ADD PRIMARY KEY (`id`), ADD KEY `file_case_configurations_requirementtypeid_foreign` (`requirementTypeId`), ADD KEY `file_case_configurations_handlerid_foreign` (`handlerId`), ADD KEY `file_case_configurations_fileid_foreign` (`fileId`), ADD KEY `file_case_configurations_caseid_foreign` (`caseId`), ADD KEY `file_case_configurations_creatorid_foreign` (`creatorId`); -- -- Indexes for table `file_case_executions` -- ALTER TABLE `file_case_executions` ADD PRIMARY KEY (`id`), ADD KEY `file_case_executions_executiontypeid_foreign` (`executionTypeId`), ADD KEY `file_case_executions_fileid_foreign` (`fileId`), ADD KEY `file_case_executions_caseid_foreign` (`caseId`), ADD KEY `file_case_executions_clientid_foreign` (`clientId`), ADD KEY `file_case_executions_creatorid_foreign` (`creatorId`); -- -- Indexes for table `file_case_execution_operations` -- ALTER TABLE `file_case_execution_operations` ADD PRIMARY KEY (`id`), ADD KEY `file_case_execution_operations_executionoperationtypeid_foreign` (`executionOperationTypeId`), ADD KEY `coa_id_foreign` (`executionOperationAuthorityId`), ADD KEY `file_case_execution_operations_caseexecutionid_foreign` (`caseExecutionId`), ADD KEY `file_case_execution_operations_clientid_foreign` (`clientId`), ADD KEY `file_case_execution_operations_creatorid_foreign` (`creatorId`); -- -- Indexes for table `file_case_execution_operation_invoices` -- ALTER TABLE `file_case_execution_operation_invoices` ADD PRIMARY KEY (`id`), ADD KEY `ceo_id_foreign` (`caseExecutionOperationId`), ADD KEY `file_case_execution_operation_invoices_caseexecutionid_foreign` (`caseExecutionId`), ADD KEY `file_case_execution_operation_invoices_clientid_foreign` (`clientId`), ADD KEY `file_case_execution_operation_invoices_creatorid_foreign` (`creatorId`); -- -- Indexes for table `file_case_hearings` -- ALTER TABLE `file_case_hearings` ADD PRIMARY KEY (`id`), ADD KEY `file_case_hearings_hearingtypeid_foreign` (`hearingTypeId`), ADD KEY `file_case_hearings_courtid_foreign` (`courtId`), ADD KEY `file_case_hearings_expertofficeid_foreign` (`expertOfficeId`), ADD KEY `file_case_hearings_administrativeid_foreign` (`administrativeId`), ADD KEY `file_case_hearings_advisorid_foreign` (`advisorId`), ADD KEY `file_case_hearings_pleadinglawyerid_foreign` (`pleadingLawyerId`), ADD KEY `file_case_hearings_fileid_foreign` (`fileId`), ADD KEY `file_case_hearings_caseid_foreign` (`caseId`), ADD KEY `file_case_hearings_associatedcaseid_foreign` (`associatedCaseId`), ADD KEY `file_case_hearings_clientid_foreign` (`clientId`), ADD KEY `file_case_hearings_creatorid_foreign` (`creatorId`); -- -- Indexes for table `file_case_hearing_phases` -- ALTER TABLE `file_case_hearing_phases` ADD PRIMARY KEY (`id`), ADD KEY `file_case_hearing_phases_hearingphaseid_foreign` (`hearingPhaseId`), ADD KEY `file_case_hearing_phases_casehearingid_foreign` (`caseHearingId`), ADD KEY `file_case_hearing_phases_creatorid_foreign` (`creatorId`); -- -- Indexes for table `file_case_hearing_phase_requirements` -- ALTER TABLE `file_case_hearing_phase_requirements` ADD PRIMARY KEY (`id`), ADD KEY `file_case_hearing_phase_requirements_casehearingphaseid_foreign` (`caseHearingPhaseId`), ADD KEY `file_case_hearing_phase_requirements_creatorid_foreign` (`creatorId`); -- -- Indexes for table `file_case_memoirs` -- ALTER TABLE `file_case_memoirs` ADD PRIMARY KEY (`id`), ADD KEY `file_case_memoirs_memoirtypeid_foreign` (`memoirTypeId`), ADD KEY `file_case_memoirs_advisorid_foreign` (`advisorId`), ADD KEY `file_case_memoirs_fileid_foreign` (`fileId`), ADD KEY `file_case_memoirs_caseid_foreign` (`caseId`), ADD KEY `file_case_memoirs_associatedcaseid_foreign` (`associatedCaseId`), ADD KEY `file_case_memoirs_clientid_foreign` (`clientId`), ADD KEY `file_case_memoirs_creatorid_foreign` (`creatorId`); -- -- Indexes for table `file_case_opponents` -- ALTER TABLE `file_case_opponents` ADD PRIMARY KEY (`id`), ADD KEY `file_case_opponents_fileid_foreign` (`fileId`), ADD KEY `file_case_opponents_caseid_foreign` (`caseId`), ADD KEY `file_case_opponents_opponentid_foreign` (`opponentId`), ADD KEY `file_case_opponents_opponenttitleid_foreign` (`opponentTitleId`), ADD KEY `file_case_opponents_creatorid_foreign` (`creatorId`); -- -- Indexes for table `file_case_reports` -- ALTER TABLE `file_case_reports` ADD PRIMARY KEY (`id`), ADD KEY `file_case_reports_reporttypeid_foreign` (`reportTypeId`), ADD KEY `file_case_reports_authorityid_foreign` (`authorityId`), ADD KEY `file_case_reports_departmentid_foreign` (`departmentId`), ADD KEY `file_case_reports_administrativeid_foreign` (`administrativeId`), ADD KEY `file_case_reports_advisorid_foreign` (`advisorId`), ADD KEY `file_case_reports_pleadinglawyerid_foreign` (`pleadingLawyerId`), ADD KEY `file_case_reports_fileid_foreign` (`fileId`), ADD KEY `file_case_reports_caseid_foreign` (`caseId`), ADD KEY `file_case_reports_associatedcaseid_foreign` (`associatedCaseId`), ADD KEY `file_case_reports_clientid_foreign` (`clientId`), ADD KEY `file_case_reports_creatorid_foreign` (`creatorId`); -- -- Indexes for table `file_case_requirements` -- ALTER TABLE `file_case_requirements` ADD PRIMARY KEY (`id`), ADD KEY `file_case_requirements_executorid_foreign` (`executorId`), ADD KEY `file_case_requirements_fileid_foreign` (`fileId`), ADD KEY `file_case_requirements_caseid_foreign` (`caseId`), ADD KEY `file_case_requirements_associatedcaseid_foreign` (`associatedCaseId`), ADD KEY `file_case_requirements_clientid_foreign` (`clientId`), ADD KEY `file_case_requirements_creatorid_foreign` (`creatorId`); -- -- Indexes for table `file_case_tasks` -- ALTER TABLE `file_case_tasks` ADD PRIMARY KEY (`id`), ADD KEY `file_case_tasks_taskhandlerid_foreign` (`taskHandlerId`), ADD KEY `file_case_tasks_taskfollowerid_foreign` (`taskFollowerId`), ADD KEY `file_case_tasks_fileid_foreign` (`fileId`), ADD KEY `file_case_tasks_caseid_foreign` (`caseId`), ADD KEY `file_case_tasks_caseexecutionid_foreign` (`caseExecutionId`), ADD KEY `file_case_tasks_associatedcaseid_foreign` (`associatedCaseId`), ADD KEY `file_case_tasks_clientid_foreign` (`clientId`), ADD KEY `file_case_tasks_creatorid_foreign` (`creatorId`); -- -- Indexes for table `file_case_tickets` -- ALTER TABLE `file_case_tickets` ADD PRIMARY KEY (`id`), ADD KEY `file_case_tickets_tickettypeid_foreign` (`ticketTypeId`), ADD KEY `file_case_tickets_advisorid_foreign` (`advisorId`), ADD KEY `file_case_tickets_fileid_foreign` (`fileId`), ADD KEY `file_case_tickets_caseid_foreign` (`caseId`), ADD KEY `file_case_tickets_associatedcaseid_foreign` (`associatedCaseId`), ADD KEY `file_case_tickets_clientid_foreign` (`clientId`), ADD KEY `file_case_tickets_creatorid_foreign` (`creatorId`); -- -- Indexes for table `file_case_verdicts` -- ALTER TABLE `file_case_verdicts` ADD PRIMARY KEY (`id`), ADD KEY `file_case_verdicts_verdicttypeid_foreign` (`verdictTypeId`), ADD KEY `file_case_verdicts_courtid_foreign` (`courtId`), ADD KEY `file_case_verdicts_advisorid_foreign` (`advisorId`), ADD KEY `file_case_verdicts_pleadinglawyerid_foreign` (`pleadingLawyerId`), ADD KEY `file_case_verdicts_fileid_foreign` (`fileId`), ADD KEY `file_case_verdicts_caseid_foreign` (`caseId`), ADD KEY `file_case_verdicts_casehearingid_foreign` (`caseHearingId`), ADD KEY `file_case_verdicts_associatedcaseid_foreign` (`associatedCaseId`), ADD KEY `file_case_verdicts_clientid_foreign` (`clientId`), ADD KEY `file_case_verdicts_creatorid_foreign` (`creatorId`); -- -- Indexes for table `general_settings` -- ALTER TABLE `general_settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `hearing_phases` -- ALTER TABLE `hearing_phases` ADD PRIMARY KEY (`id`); -- -- Indexes for table `hearing_types` -- ALTER TABLE `hearing_types` ADD PRIMARY KEY (`id`); -- -- Indexes for table `identity_types` -- ALTER TABLE `identity_types` ADD PRIMARY KEY (`id`); -- -- Indexes for table `job_titles` -- ALTER TABLE `job_titles` ADD PRIMARY KEY (`id`); -- -- Indexes for table `meetings` -- ALTER TABLE `meetings` ADD PRIMARY KEY (`id`), ADD KEY `meetings_clientid_foreign` (`clientId`), ADD KEY `meetings_fileid_foreign` (`fileId`), ADD KEY `meetings_filecaseid_foreign` (`fileCaseId`), ADD KEY `meetings_creatorid_foreign` (`creatorId`); -- -- Indexes for table `meeting_agendas` -- ALTER TABLE `meeting_agendas` ADD PRIMARY KEY (`id`), ADD KEY `meeting_agendas_meetingid_foreign` (`meetingId`); -- -- Indexes for table `meeting_discussions` -- ALTER TABLE `meeting_discussions` ADD PRIMARY KEY (`id`), ADD KEY `meeting_discussions_meetingid_foreign` (`meetingId`); -- -- Indexes for table `meeting_participants` -- ALTER TABLE `meeting_participants` ADD PRIMARY KEY (`id`), ADD KEY `meeting_participants_jobtitleid_foreign` (`jobTitleId`), ADD KEY `meeting_participants_meetingid_foreign` (`meetingId`); -- -- Indexes for table `memoir_types` -- ALTER TABLE `memoir_types` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `nationalities` -- ALTER TABLE `nationalities` ADD PRIMARY KEY (`id`); -- -- Indexes for table `opponents` -- ALTER TABLE `opponents` ADD PRIMARY KEY (`id`), ADD KEY `opponents_nationalityid_foreign` (`nationalityId`), ADD KEY `opponents_creatorid_foreign` (`creatorId`); -- -- Indexes for table `permissions` -- ALTER TABLE `permissions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`); -- -- Indexes for table `products` -- ALTER TABLE `products` ADD PRIMARY KEY (`id`); -- -- Indexes for table `profiles` -- ALTER TABLE `profiles` ADD PRIMARY KEY (`id`); -- -- Indexes for table `report_files` -- ALTER TABLE `report_files` ADD PRIMARY KEY (`id`), ADD KEY `report_files_reporttypeid_foreign` (`reportTypeId`), ADD KEY `report_files_defendantid_foreign` (`defendantId`), ADD KEY `report_files_bankid_foreign` (`bankId`), ADD KEY `report_files_courtid_foreign` (`courtId`), ADD KEY `report_files_productid_foreign` (`productId`), ADD KEY `report_files_caseid_foreign` (`caseId`), ADD KEY `report_files_clientid_foreign` (`clientId`), ADD KEY `report_files_creatorid_foreign` (`creatorId`); -- -- Indexes for table `report_file_attachments` -- ALTER TABLE `report_file_attachments` ADD PRIMARY KEY (`id`), ADD KEY `report_file_attachments_documenttypeid_foreign` (`documentTypeId`), ADD KEY `report_file_attachments_reportfileid_foreign` (`reportFileId`), ADD KEY `report_file_attachments_clientid_foreign` (`clientId`), ADD KEY `report_file_attachments_creatorid_foreign` (`creatorId`); -- -- Indexes for table `report_file_operations` -- ALTER TABLE `report_file_operations` ADD PRIMARY KEY (`id`), ADD KEY `report_file_operations_reportoperationtypeid_foreign` (`reportOperationTypeId`), ADD KEY `roa_id_foreign` (`reportOperationAuthorityId`), ADD KEY `report_file_operations_reportfileid_foreign` (`reportFileId`), ADD KEY `report_file_operations_clientid_foreign` (`clientId`), ADD KEY `report_file_operations_creatorid_foreign` (`creatorId`); -- -- Indexes for table `report_file_operation_invoices` -- ALTER TABLE `report_file_operation_invoices` ADD PRIMARY KEY (`id`), ADD KEY `report_file_operation_invoices_reportfileid_foreign` (`reportFileId`), ADD KEY `rfo_id_foreign` (`reportFileOperationId`), ADD KEY `report_file_operation_invoices_clientid_foreign` (`clientId`), ADD KEY `report_file_operation_invoices_creatorid_foreign` (`creatorId`); -- -- Indexes for table `report_file_tasks` -- ALTER TABLE `report_file_tasks` ADD PRIMARY KEY (`id`), ADD KEY `report_file_tasks_taskhandlerid_foreign` (`taskHandlerId`), ADD KEY `report_file_tasks_taskfollowerid_foreign` (`taskFollowerId`), ADD KEY `report_file_tasks_reportfileid_foreign` (`reportFileId`), ADD KEY `report_file_tasks_clientid_foreign` (`clientId`), ADD KEY `report_file_tasks_creatorid_foreign` (`creatorId`); -- -- Indexes for table `report_types` -- ALTER TABLE `report_types` ADD PRIMARY KEY (`id`); -- -- Indexes for table `requirement_types` -- ALTER TABLE `requirement_types` ADD PRIMARY KEY (`id`); -- -- Indexes for table `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`); -- -- Indexes for table `role_permissions` -- ALTER TABLE `role_permissions` ADD PRIMARY KEY (`id`), ADD KEY `role_permissions_roleid_foreign` (`roleId`), ADD KEY `role_permissions_permissionid_foreign` (`permissionId`); -- -- Indexes for table `ticket_types` -- ALTER TABLE `ticket_types` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`), ADD KEY `users_roleid_foreign` (`roleId`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `activity_logs` -- ALTER TABLE `activity_logs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `authorities` -- ALTER TABLE `authorities` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `banks` -- ALTER TABLE `banks` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `case_stages` -- ALTER TABLE `case_stages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `case_types` -- ALTER TABLE `case_types` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `cities` -- ALTER TABLE `cities` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `clients` -- ALTER TABLE `clients` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `client_attachments` -- ALTER TABLE `client_attachments` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `client_contracts` -- ALTER TABLE `client_contracts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `client_titles` -- ALTER TABLE `client_titles` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `client_types` -- ALTER TABLE `client_types` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `contract_types` -- ALTER TABLE `contract_types` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `courts` -- ALTER TABLE `courts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `departments` -- ALTER TABLE `departments` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `document_types` -- ALTER TABLE `document_types` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `execution_files` -- ALTER TABLE `execution_files` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `execution_file_attachments` -- ALTER TABLE `execution_file_attachments` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `execution_file_operations` -- ALTER TABLE `execution_file_operations` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `execution_file_operation_invoices` -- ALTER TABLE `execution_file_operation_invoices` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `execution_file_tasks` -- ALTER TABLE `execution_file_tasks` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `execution_operation_authorities` -- ALTER TABLE `execution_operation_authorities` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `execution_operation_types` -- ALTER TABLE `execution_operation_types` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `execution_services` -- ALTER TABLE `execution_services` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `execution_types` -- ALTER TABLE `execution_types` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `expert_offices` -- ALTER TABLE `expert_offices` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `files` -- ALTER TABLE `files` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `file_associated_cases` -- ALTER TABLE `file_associated_cases` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `file_cases` -- ALTER TABLE `file_cases` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `file_case_attachments` -- ALTER TABLE `file_case_attachments` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `file_case_claims` -- ALTER TABLE `file_case_claims` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `file_case_configurations` -- ALTER TABLE `file_case_configurations` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `file_case_executions` -- ALTER TABLE `file_case_executions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `file_case_execution_operations` -- ALTER TABLE `file_case_execution_operations` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `file_case_execution_operation_invoices` -- ALTER TABLE `file_case_execution_operation_invoices` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `file_case_hearings` -- ALTER TABLE `file_case_hearings` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `file_case_hearing_phases` -- ALTER TABLE `file_case_hearing_phases` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `file_case_hearing_phase_requirements` -- ALTER TABLE `file_case_hearing_phase_requirements` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `file_case_memoirs` -- ALTER TABLE `file_case_memoirs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `file_case_opponents` -- ALTER TABLE `file_case_opponents` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `file_case_reports` -- ALTER TABLE `file_case_reports` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `file_case_requirements` -- ALTER TABLE `file_case_requirements` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `file_case_tasks` -- ALTER TABLE `file_case_tasks` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `file_case_tickets` -- ALTER TABLE `file_case_tickets` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `file_case_verdicts` -- ALTER TABLE `file_case_verdicts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `general_settings` -- ALTER TABLE `general_settings` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `hearing_phases` -- ALTER TABLE `hearing_phases` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `hearing_types` -- ALTER TABLE `hearing_types` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `identity_types` -- ALTER TABLE `identity_types` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `job_titles` -- ALTER TABLE `job_titles` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `meetings` -- ALTER TABLE `meetings` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `meeting_agendas` -- ALTER TABLE `meeting_agendas` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `meeting_discussions` -- ALTER TABLE `meeting_discussions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29; -- -- AUTO_INCREMENT for table `meeting_participants` -- ALTER TABLE `meeting_participants` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `memoir_types` -- ALTER TABLE `memoir_types` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68; -- -- AUTO_INCREMENT for table `nationalities` -- ALTER TABLE `nationalities` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=194; -- -- AUTO_INCREMENT for table `opponents` -- ALTER TABLE `opponents` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `permissions` -- ALTER TABLE `permissions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `products` -- ALTER TABLE `products` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `profiles` -- ALTER TABLE `profiles` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `report_files` -- ALTER TABLE `report_files` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `report_file_attachments` -- ALTER TABLE `report_file_attachments` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `report_file_operations` -- ALTER TABLE `report_file_operations` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19; -- -- AUTO_INCREMENT for table `report_file_operation_invoices` -- ALTER TABLE `report_file_operation_invoices` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `report_file_tasks` -- ALTER TABLE `report_file_tasks` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `report_types` -- ALTER TABLE `report_types` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `requirement_types` -- ALTER TABLE `requirement_types` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `roles` -- ALTER TABLE `roles` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `role_permissions` -- ALTER TABLE `role_permissions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT for table `ticket_types` -- ALTER TABLE `ticket_types` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- Constraints for dumped tables -- -- -- Constraints for table `case_stages` -- ALTER TABLE `case_stages` ADD CONSTRAINT `case_stages_casetypeid_foreign` FOREIGN KEY (`caseTypeId`) REFERENCES `case_types` (`id`) ON DELETE CASCADE; -- -- Constraints for table `clients` -- ALTER TABLE `clients` ADD CONSTRAINT `clients_branchcityid_foreign` FOREIGN KEY (`branchCityId`) REFERENCES `cities` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `clients_clienttypeid_foreign` FOREIGN KEY (`clientTypeId`) REFERENCES `client_types` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `clients_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `clients_nationalityid_foreign` FOREIGN KEY (`nationalityId`) REFERENCES `nationalities` (`id`) ON DELETE SET NULL; -- -- Constraints for table `client_attachments` -- ALTER TABLE `client_attachments` ADD CONSTRAINT `client_attachments_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `client_attachments_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `client_attachments_identitytypeid_foreign` FOREIGN KEY (`identityTypeId`) REFERENCES `identity_types` (`id`) ON DELETE SET NULL; -- -- Constraints for table `client_contracts` -- ALTER TABLE `client_contracts` ADD CONSTRAINT `client_contracts_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `client_contracts_contracttypeid_foreign` FOREIGN KEY (`contractTypeId`) REFERENCES `contract_types` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `client_contracts_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `execution_files` -- ALTER TABLE `execution_files` ADD CONSTRAINT `execution_files_bankid_foreign` FOREIGN KEY (`bankId`) REFERENCES `banks` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `execution_files_caseid_foreign` FOREIGN KEY (`caseId`) REFERENCES `file_cases` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `execution_files_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `execution_files_courtid_foreign` FOREIGN KEY (`courtId`) REFERENCES `courts` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `execution_files_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `execution_files_defendantid_foreign` FOREIGN KEY (`defendantId`) REFERENCES `opponents` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `execution_files_executiontypeid_foreign` FOREIGN KEY (`executionTypeId`) REFERENCES `execution_types` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `execution_files_productid_foreign` FOREIGN KEY (`productId`) REFERENCES `products` (`id`) ON DELETE SET NULL; -- -- Constraints for table `execution_file_attachments` -- ALTER TABLE `execution_file_attachments` ADD CONSTRAINT `execution_file_attachments_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `execution_file_attachments_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `execution_file_attachments_documenttypeid_foreign` FOREIGN KEY (`documentTypeId`) REFERENCES `document_types` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `execution_file_attachments_executionfileid_foreign` FOREIGN KEY (`executionFileId`) REFERENCES `execution_files` (`id`) ON DELETE CASCADE; -- -- Constraints for table `execution_file_operations` -- ALTER TABLE `execution_file_operations` ADD CONSTRAINT `eoa_id_foreign` FOREIGN KEY (`executionOperationAuthorityId`) REFERENCES `execution_operation_authorities` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `execution_file_operations_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `execution_file_operations_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `execution_file_operations_executionfileid_foreign` FOREIGN KEY (`executionFileId`) REFERENCES `execution_files` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `execution_file_operations_executionoperationtypeid_foreign` FOREIGN KEY (`executionOperationTypeId`) REFERENCES `execution_operation_types` (`id`) ON DELETE SET NULL; -- -- Constraints for table `execution_file_operation_invoices` -- ALTER TABLE `execution_file_operation_invoices` ADD CONSTRAINT `efo_id_foreign` FOREIGN KEY (`executionFileOperationId`) REFERENCES `execution_file_operations` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `execution_file_operation_invoices_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `execution_file_operation_invoices_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `execution_file_operation_invoices_executionfileid_foreign` FOREIGN KEY (`executionFileId`) REFERENCES `execution_files` (`id`) ON DELETE CASCADE; -- -- Constraints for table `execution_file_tasks` -- ALTER TABLE `execution_file_tasks` ADD CONSTRAINT `execution_file_tasks_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `execution_file_tasks_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `execution_file_tasks_executionfileid_foreign` FOREIGN KEY (`executionFileId`) REFERENCES `execution_files` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `execution_file_tasks_taskfollowerid_foreign` FOREIGN KEY (`taskFollowerId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `execution_file_tasks_taskhandlerid_foreign` FOREIGN KEY (`taskHandlerId`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `files` -- ALTER TABLE `files` ADD CONSTRAINT `files_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `files_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `file_associated_cases` -- ALTER TABLE `file_associated_cases` ADD CONSTRAINT `file_associated_cases_administrativeid_foreign` FOREIGN KEY (`administrativeId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_associated_cases_advisorid_foreign` FOREIGN KEY (`advisorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_associated_cases_branchcityid_foreign` FOREIGN KEY (`branchCityId`) REFERENCES `cities` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_associated_cases_caseid_foreign` FOREIGN KEY (`caseId`) REFERENCES `file_cases` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_associated_cases_casestageid_foreign` FOREIGN KEY (`caseStageId`) REFERENCES `case_stages` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_associated_cases_casetypeid_foreign` FOREIGN KEY (`caseTypeId`) REFERENCES `case_types` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_associated_cases_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_associated_cases_clienttitleid_foreign` FOREIGN KEY (`clientTitleId`) REFERENCES `client_titles` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_associated_cases_courtid_foreign` FOREIGN KEY (`courtId`) REFERENCES `courts` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_associated_cases_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_associated_cases_departmentid_foreign` FOREIGN KEY (`departmentId`) REFERENCES `departments` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_associated_cases_fileid_foreign` FOREIGN KEY (`fileId`) REFERENCES `files` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_associated_cases_pleadinglawyerid_foreign` FOREIGN KEY (`pleadingLawyerId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_associated_cases_secadministrativeid_foreign` FOREIGN KEY (`secAdministrativeId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_associated_cases_secadvisorid_foreign` FOREIGN KEY (`secAdvisorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_associated_cases_secpleadinglawyerid_foreign` FOREIGN KEY (`secPleadingLawyerId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_associated_cases_thirdadministrativeid_foreign` FOREIGN KEY (`thirdAdministrativeId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_associated_cases_thirdadvisorid_foreign` FOREIGN KEY (`thirdAdvisorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_associated_cases_thirdpleadinglawyerid_foreign` FOREIGN KEY (`thirdPleadingLawyerId`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `file_cases` -- ALTER TABLE `file_cases` ADD CONSTRAINT `file_cases_administrativeid_foreign` FOREIGN KEY (`administrativeId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_cases_advisorid_foreign` FOREIGN KEY (`advisorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_cases_casestageid_foreign` FOREIGN KEY (`caseStageId`) REFERENCES `case_stages` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_cases_casetypeid_foreign` FOREIGN KEY (`caseTypeId`) REFERENCES `case_types` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_cases_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_cases_clienttitleid_foreign` FOREIGN KEY (`clientTitleId`) REFERENCES `client_titles` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_cases_courtid_foreign` FOREIGN KEY (`courtId`) REFERENCES `courts` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_cases_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_cases_departmentid_foreign` FOREIGN KEY (`departmentId`) REFERENCES `departments` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_cases_fileid_foreign` FOREIGN KEY (`fileId`) REFERENCES `files` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_cases_pleadinglawyerid_foreign` FOREIGN KEY (`pleadingLawyerId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_cases_secadministrativeid_foreign` FOREIGN KEY (`secAdministrativeId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_cases_secadvisorid_foreign` FOREIGN KEY (`secAdvisorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_cases_secpleadinglawyerid_foreign` FOREIGN KEY (`secPleadingLawyerId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_cases_thirdadministrativeid_foreign` FOREIGN KEY (`thirdAdministrativeId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_cases_thirdadvisorid_foreign` FOREIGN KEY (`thirdAdvisorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_cases_thirdpleadinglawyerid_foreign` FOREIGN KEY (`thirdPleadingLawyerId`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `file_case_attachments` -- ALTER TABLE `file_case_attachments` ADD CONSTRAINT `file_case_attachments_associatedcaseid_foreign` FOREIGN KEY (`associatedCaseId`) REFERENCES `file_associated_cases` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_attachments_caseexecutionid_foreign` FOREIGN KEY (`caseExecutionId`) REFERENCES `file_case_executions` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_attachments_caseid_foreign` FOREIGN KEY (`caseId`) REFERENCES `file_cases` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_attachments_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_attachments_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_attachments_documenttypeid_foreign` FOREIGN KEY (`documentTypeId`) REFERENCES `document_types` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_attachments_fileid_foreign` FOREIGN KEY (`fileId`) REFERENCES `files` (`id`) ON DELETE CASCADE; -- -- Constraints for table `file_case_claims` -- ALTER TABLE `file_case_claims` ADD CONSTRAINT `file_case_claims_caseid_foreign` FOREIGN KEY (`caseId`) REFERENCES `file_cases` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_claims_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_claims_fileid_foreign` FOREIGN KEY (`fileId`) REFERENCES `files` (`id`) ON DELETE CASCADE; -- -- Constraints for table `file_case_configurations` -- ALTER TABLE `file_case_configurations` ADD CONSTRAINT `file_case_configurations_caseid_foreign` FOREIGN KEY (`caseId`) REFERENCES `file_cases` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_configurations_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_configurations_fileid_foreign` FOREIGN KEY (`fileId`) REFERENCES `files` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_configurations_handlerid_foreign` FOREIGN KEY (`handlerId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_configurations_requirementtypeid_foreign` FOREIGN KEY (`requirementTypeId`) REFERENCES `requirement_types` (`id`) ON DELETE SET NULL; -- -- Constraints for table `file_case_executions` -- ALTER TABLE `file_case_executions` ADD CONSTRAINT `file_case_executions_caseid_foreign` FOREIGN KEY (`caseId`) REFERENCES `file_cases` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_executions_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_executions_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_executions_executiontypeid_foreign` FOREIGN KEY (`executionTypeId`) REFERENCES `execution_types` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_executions_fileid_foreign` FOREIGN KEY (`fileId`) REFERENCES `files` (`id`) ON DELETE CASCADE; -- -- Constraints for table `file_case_execution_operations` -- ALTER TABLE `file_case_execution_operations` ADD CONSTRAINT `coa_id_foreign` FOREIGN KEY (`executionOperationAuthorityId`) REFERENCES `execution_operation_authorities` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_execution_operations_caseexecutionid_foreign` FOREIGN KEY (`caseExecutionId`) REFERENCES `file_case_executions` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_execution_operations_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_execution_operations_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_execution_operations_executionoperationtypeid_foreign` FOREIGN KEY (`executionOperationTypeId`) REFERENCES `execution_operation_types` (`id`) ON DELETE SET NULL; -- -- Constraints for table `file_case_execution_operation_invoices` -- ALTER TABLE `file_case_execution_operation_invoices` ADD CONSTRAINT `ceo_id_foreign` FOREIGN KEY (`caseExecutionOperationId`) REFERENCES `file_case_execution_operations` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_execution_operation_invoices_caseexecutionid_foreign` FOREIGN KEY (`caseExecutionId`) REFERENCES `file_case_executions` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_execution_operation_invoices_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_execution_operation_invoices_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `file_case_hearings` -- ALTER TABLE `file_case_hearings` ADD CONSTRAINT `file_case_hearings_administrativeid_foreign` FOREIGN KEY (`administrativeId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_hearings_advisorid_foreign` FOREIGN KEY (`advisorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_hearings_associatedcaseid_foreign` FOREIGN KEY (`associatedCaseId`) REFERENCES `file_associated_cases` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_hearings_caseid_foreign` FOREIGN KEY (`caseId`) REFERENCES `file_cases` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_hearings_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_hearings_courtid_foreign` FOREIGN KEY (`courtId`) REFERENCES `courts` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_hearings_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_hearings_expertofficeid_foreign` FOREIGN KEY (`expertOfficeId`) REFERENCES `expert_offices` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_hearings_fileid_foreign` FOREIGN KEY (`fileId`) REFERENCES `files` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_hearings_hearingtypeid_foreign` FOREIGN KEY (`hearingTypeId`) REFERENCES `hearing_types` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_hearings_pleadinglawyerid_foreign` FOREIGN KEY (`pleadingLawyerId`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `file_case_hearing_phases` -- ALTER TABLE `file_case_hearing_phases` ADD CONSTRAINT `file_case_hearing_phases_casehearingid_foreign` FOREIGN KEY (`caseHearingId`) REFERENCES `file_case_hearings` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_hearing_phases_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_hearing_phases_hearingphaseid_foreign` FOREIGN KEY (`hearingPhaseId`) REFERENCES `hearing_phases` (`id`) ON DELETE SET NULL; -- -- Constraints for table `file_case_hearing_phase_requirements` -- ALTER TABLE `file_case_hearing_phase_requirements` ADD CONSTRAINT `file_case_hearing_phase_requirements_casehearingphaseid_foreign` FOREIGN KEY (`caseHearingPhaseId`) REFERENCES `file_case_hearing_phases` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_hearing_phase_requirements_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `file_case_memoirs` -- ALTER TABLE `file_case_memoirs` ADD CONSTRAINT `file_case_memoirs_advisorid_foreign` FOREIGN KEY (`advisorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_memoirs_associatedcaseid_foreign` FOREIGN KEY (`associatedCaseId`) REFERENCES `file_associated_cases` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_memoirs_caseid_foreign` FOREIGN KEY (`caseId`) REFERENCES `file_cases` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_memoirs_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_memoirs_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_memoirs_fileid_foreign` FOREIGN KEY (`fileId`) REFERENCES `files` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_memoirs_memoirtypeid_foreign` FOREIGN KEY (`memoirTypeId`) REFERENCES `memoir_types` (`id`) ON DELETE SET NULL; -- -- Constraints for table `file_case_opponents` -- ALTER TABLE `file_case_opponents` ADD CONSTRAINT `file_case_opponents_caseid_foreign` FOREIGN KEY (`caseId`) REFERENCES `file_cases` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_opponents_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_opponents_fileid_foreign` FOREIGN KEY (`fileId`) REFERENCES `files` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_opponents_opponentid_foreign` FOREIGN KEY (`opponentId`) REFERENCES `opponents` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_opponents_opponenttitleid_foreign` FOREIGN KEY (`opponentTitleId`) REFERENCES `client_titles` (`id`) ON DELETE SET NULL; -- -- Constraints for table `file_case_reports` -- ALTER TABLE `file_case_reports` ADD CONSTRAINT `file_case_reports_administrativeid_foreign` FOREIGN KEY (`administrativeId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_reports_advisorid_foreign` FOREIGN KEY (`advisorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_reports_associatedcaseid_foreign` FOREIGN KEY (`associatedCaseId`) REFERENCES `file_associated_cases` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_reports_authorityid_foreign` FOREIGN KEY (`authorityId`) REFERENCES `authorities` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_reports_caseid_foreign` FOREIGN KEY (`caseId`) REFERENCES `file_cases` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_reports_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_reports_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_reports_departmentid_foreign` FOREIGN KEY (`departmentId`) REFERENCES `departments` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_reports_fileid_foreign` FOREIGN KEY (`fileId`) REFERENCES `files` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_reports_pleadinglawyerid_foreign` FOREIGN KEY (`pleadingLawyerId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_reports_reporttypeid_foreign` FOREIGN KEY (`reportTypeId`) REFERENCES `report_types` (`id`) ON DELETE SET NULL; -- -- Constraints for table `file_case_requirements` -- ALTER TABLE `file_case_requirements` ADD CONSTRAINT `file_case_requirements_associatedcaseid_foreign` FOREIGN KEY (`associatedCaseId`) REFERENCES `file_associated_cases` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_requirements_caseid_foreign` FOREIGN KEY (`caseId`) REFERENCES `file_cases` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_requirements_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_requirements_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_requirements_executorid_foreign` FOREIGN KEY (`executorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_requirements_fileid_foreign` FOREIGN KEY (`fileId`) REFERENCES `files` (`id`) ON DELETE CASCADE; -- -- Constraints for table `file_case_tasks` -- ALTER TABLE `file_case_tasks` ADD CONSTRAINT `file_case_tasks_associatedcaseid_foreign` FOREIGN KEY (`associatedCaseId`) REFERENCES `file_associated_cases` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_tasks_caseexecutionid_foreign` FOREIGN KEY (`caseExecutionId`) REFERENCES `file_case_executions` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_tasks_caseid_foreign` FOREIGN KEY (`caseId`) REFERENCES `file_cases` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_tasks_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_tasks_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_tasks_fileid_foreign` FOREIGN KEY (`fileId`) REFERENCES `files` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_tasks_taskfollowerid_foreign` FOREIGN KEY (`taskFollowerId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_tasks_taskhandlerid_foreign` FOREIGN KEY (`taskHandlerId`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `file_case_tickets` -- ALTER TABLE `file_case_tickets` ADD CONSTRAINT `file_case_tickets_advisorid_foreign` FOREIGN KEY (`advisorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_tickets_associatedcaseid_foreign` FOREIGN KEY (`associatedCaseId`) REFERENCES `file_associated_cases` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_tickets_caseid_foreign` FOREIGN KEY (`caseId`) REFERENCES `file_cases` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_tickets_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_tickets_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_tickets_fileid_foreign` FOREIGN KEY (`fileId`) REFERENCES `files` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_tickets_tickettypeid_foreign` FOREIGN KEY (`ticketTypeId`) REFERENCES `ticket_types` (`id`) ON DELETE SET NULL; -- -- Constraints for table `file_case_verdicts` -- ALTER TABLE `file_case_verdicts` ADD CONSTRAINT `file_case_verdicts_advisorid_foreign` FOREIGN KEY (`advisorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_verdicts_associatedcaseid_foreign` FOREIGN KEY (`associatedCaseId`) REFERENCES `file_associated_cases` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_verdicts_casehearingid_foreign` FOREIGN KEY (`caseHearingId`) REFERENCES `file_case_hearings` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_verdicts_caseid_foreign` FOREIGN KEY (`caseId`) REFERENCES `file_cases` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_verdicts_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_verdicts_courtid_foreign` FOREIGN KEY (`courtId`) REFERENCES `courts` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_verdicts_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_verdicts_fileid_foreign` FOREIGN KEY (`fileId`) REFERENCES `files` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `file_case_verdicts_pleadinglawyerid_foreign` FOREIGN KEY (`pleadingLawyerId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `file_case_verdicts_verdicttypeid_foreign` FOREIGN KEY (`verdictTypeId`) REFERENCES `hearing_types` (`id`) ON DELETE SET NULL; -- -- Constraints for table `meetings` -- ALTER TABLE `meetings` ADD CONSTRAINT `meetings_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `meetings_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `meetings_filecaseid_foreign` FOREIGN KEY (`fileCaseId`) REFERENCES `file_cases` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `meetings_fileid_foreign` FOREIGN KEY (`fileId`) REFERENCES `files` (`id`) ON DELETE SET NULL; -- -- Constraints for table `meeting_agendas` -- ALTER TABLE `meeting_agendas` ADD CONSTRAINT `meeting_agendas_meetingid_foreign` FOREIGN KEY (`meetingId`) REFERENCES `meetings` (`id`) ON DELETE CASCADE; -- -- Constraints for table `meeting_discussions` -- ALTER TABLE `meeting_discussions` ADD CONSTRAINT `meeting_discussions_meetingid_foreign` FOREIGN KEY (`meetingId`) REFERENCES `meetings` (`id`) ON DELETE CASCADE; -- -- Constraints for table `meeting_participants` -- ALTER TABLE `meeting_participants` ADD CONSTRAINT `meeting_participants_jobtitleid_foreign` FOREIGN KEY (`jobTitleId`) REFERENCES `job_titles` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `meeting_participants_meetingid_foreign` FOREIGN KEY (`meetingId`) REFERENCES `meetings` (`id`) ON DELETE CASCADE; -- -- Constraints for table `opponents` -- ALTER TABLE `opponents` ADD CONSTRAINT `opponents_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `opponents_nationalityid_foreign` FOREIGN KEY (`nationalityId`) REFERENCES `nationalities` (`id`) ON DELETE SET NULL; -- -- Constraints for table `report_files` -- ALTER TABLE `report_files` ADD CONSTRAINT `report_files_bankid_foreign` FOREIGN KEY (`bankId`) REFERENCES `banks` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `report_files_caseid_foreign` FOREIGN KEY (`caseId`) REFERENCES `file_cases` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `report_files_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `report_files_courtid_foreign` FOREIGN KEY (`courtId`) REFERENCES `courts` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `report_files_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `report_files_defendantid_foreign` FOREIGN KEY (`defendantId`) REFERENCES `opponents` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `report_files_productid_foreign` FOREIGN KEY (`productId`) REFERENCES `products` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `report_files_reporttypeid_foreign` FOREIGN KEY (`reportTypeId`) REFERENCES `report_types` (`id`) ON DELETE SET NULL; -- -- Constraints for table `report_file_attachments` -- ALTER TABLE `report_file_attachments` ADD CONSTRAINT `report_file_attachments_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `report_file_attachments_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `report_file_attachments_documenttypeid_foreign` FOREIGN KEY (`documentTypeId`) REFERENCES `document_types` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `report_file_attachments_reportfileid_foreign` FOREIGN KEY (`reportFileId`) REFERENCES `report_files` (`id`) ON DELETE CASCADE; -- -- Constraints for table `report_file_operations` -- ALTER TABLE `report_file_operations` ADD CONSTRAINT `report_file_operations_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `report_file_operations_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `report_file_operations_reportfileid_foreign` FOREIGN KEY (`reportFileId`) REFERENCES `report_files` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `report_file_operations_reportoperationtypeid_foreign` FOREIGN KEY (`reportOperationTypeId`) REFERENCES `execution_operation_types` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `roa_id_foreign` FOREIGN KEY (`reportOperationAuthorityId`) REFERENCES `execution_operation_authorities` (`id`) ON DELETE SET NULL; -- -- Constraints for table `report_file_operation_invoices` -- ALTER TABLE `report_file_operation_invoices` ADD CONSTRAINT `report_file_operation_invoices_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `report_file_operation_invoices_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `report_file_operation_invoices_reportfileid_foreign` FOREIGN KEY (`reportFileId`) REFERENCES `report_files` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `rfo_id_foreign` FOREIGN KEY (`reportFileOperationId`) REFERENCES `report_file_operations` (`id`) ON DELETE CASCADE; -- -- Constraints for table `report_file_tasks` -- ALTER TABLE `report_file_tasks` ADD CONSTRAINT `report_file_tasks_clientid_foreign` FOREIGN KEY (`clientId`) REFERENCES `clients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `report_file_tasks_creatorid_foreign` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `report_file_tasks_reportfileid_foreign` FOREIGN KEY (`reportFileId`) REFERENCES `report_files` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `report_file_tasks_taskfollowerid_foreign` FOREIGN KEY (`taskFollowerId`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `report_file_tasks_taskhandlerid_foreign` FOREIGN KEY (`taskHandlerId`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `role_permissions` -- ALTER TABLE `role_permissions` ADD CONSTRAINT `role_permissions_permissionid_foreign` FOREIGN KEY (`permissionId`) REFERENCES `permissions` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `role_permissions_roleid_foreign` FOREIGN KEY (`roleId`) REFERENCES `roles` (`id`) ON DELETE CASCADE; -- -- Constraints for table `users` -- ALTER TABLE `users` ADD CONSTRAINT `users_roleid_foreign` FOREIGN KEY (`roleId`) REFERENCES `roles` (`id`) ON DELETE SET NULL; 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 */;