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

START TRANSACTION;



--
-- Database: `disease`
--

-- --------------------------------------------------------

--
-- Table structure for table `bloods`
--

CREATE TABLE IF NOT EXISTS `bloods` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `bloods`
--

INSERT INTO `bloods` (`id`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'O-', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(2, 'O+', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(3, 'A+', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(4, 'A-', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(5, 'B+', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(6, 'B-', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(7, 'AB+', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(8, 'AB-', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54');

-- --------------------------------------------------------

--
-- Table structure for table `diseases`
--

CREATE TABLE IF NOT EXISTS `diseases` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `diseases`
--

INSERT INTO `diseases` (`id`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'السكري', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(2, 'ارتفاع ضغط الدم', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(3, 'الربو', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(4, 'التهاب المفاصل', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(5, 'الإنفلونزا', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(6, 'الزهايمر', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(7, 'السكتة الدماغية', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(8, 'السرطان', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(9, 'الاكتئاب', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54');

-- --------------------------------------------------------

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `genders`
--

CREATE TABLE IF NOT EXISTS `genders` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `genders`
--

INSERT INTO `genders` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, '{\"ar\":\"ذكر\"}', '2025-04-26 15:53:53', '2025-04-26 15:53:53'),
(2, '{\"ar\":\"أنثى\"}', '2025-04-26 15:53:53', '2025-04-26 15:53:53');

-- --------------------------------------------------------

--
-- Table structure for table `locations`
--

CREATE TABLE IF NOT EXISTS `locations` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `locations`
--

INSERT INTO `locations` (`id`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'النيل الابيض', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(2, 'نهر النيل', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(3, 'النيل الازرق', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(4, 'الشمالية', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(5, 'الجزيرة', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(6, 'البحر الاحمر', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(7, 'كردفان', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54');

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2022_04_07_221617_create_bloods_table', 1),
(6, '2022_04_08_132603_create_nationalities_table', 1),
(7, '2022_05_06_073205_create_genders_table', 1),
(8, '2023_07_30_181534_create_permission_tables', 1),
(9, '2025_04_22_132101_create_patients_table', 1),
(10, '2025_04_22_132223_create_diseases_table', 1),
(11, '2025_04_22_132312_create_symptoms_table', 1),
(12, '2025_04_22_132412_create_records_table', 1),
(13, '2025_04_22_132511_create_locations_table', 1),
(14, '2025_12_05_181424_create_foreign_keys', 1);

-- --------------------------------------------------------

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE IF NOT EXISTS `model_has_permissions` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE IF NOT EXISTS `model_has_roles` (
  `role_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\User', 1);

-- --------------------------------------------------------

--
-- Table structure for table `nationalities`
--

CREATE TABLE IF NOT EXISTS `nationalities` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=219 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `nationalities`
--

INSERT INTO `nationalities` (`id`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, '{\"en\":\"Sudanese\",\"ar\":\"سوداني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(2, '{\"en\":\"South Sudanese\",\"ar\":\"سوادني جنوبي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(3, '{\"en\":\"Saudi Arabian\",\"ar\":\"سعودي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(4, '{\"en\":\"Qatari\",\"ar\":\"قطري\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(5, '{\"en\":\"Omani\",\"ar\":\"عماني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(6, '{\"en\":\"Moroccan\",\"ar\":\"مغربي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(7, '{\"en\":\"Syrian\",\"ar\":\"سوري\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(8, '{\"en\":\"Tunisian\",\"ar\":\"تونسي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(9, '{\"en\":\"Turkish\",\"ar\":\"تركي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(10, '{\"en\":\"Turkmen\",\"ar\":\"تركمانستاني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(11, '{\"en\":\"Yemeni\",\"ar\":\"يمني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(12, '{\"en\":\"Albanian\",\"ar\":\"ألباني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(13, '{\"en\":\"Aland Islander\",\"ar\":\"آلاندي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(14, '{\"en\":\"Algerian\",\"ar\":\"جزائري\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(15, '{\"en\":\"Bahraini\",\"ar\":\"بحريني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(16, '{\"en\":\"Botswanan\",\"ar\":\"بوتسواني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(17, '{\"en\":\"Bouvetian\",\"ar\":\"بوفيهي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(18, '{\"en\":\"Brazilian\",\"ar\":\"برازيلي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(19, '{\"en\":\"British Indian Ocean Territory\",\"ar\":\"إقليم المحيط الهندي البريطاني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(20, '{\"en\":\"Bruneian\",\"ar\":\"بروني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(21, '{\"en\":\"Bulgarian\",\"ar\":\"بلغاري\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(22, '{\"en\":\"Burkinabe\",\"ar\":\"بوركيني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(23, '{\"en\":\"Burundian\",\"ar\":\"بورونيدي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(24, '{\"en\":\"Cambodian\",\"ar\":\"كمبودي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(25, '{\"en\":\"Cameroonian\",\"ar\":\"كاميروني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(26, '{\"en\":\"Canadian\",\"ar\":\"كندي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(27, '{\"en\":\"Cape Verdean\",\"ar\":\"الرأس الأخضر\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(28, '{\"en\":\"Caymanian\",\"ar\":\"كايماني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(29, '{\"en\":\"Central African\",\"ar\":\"أفريقي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(30, '{\"en\":\"Chadian\",\"ar\":\"تشادي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(31, '{\"en\":\"Chilean\",\"ar\":\"شيلي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(32, '{\"en\":\"Chinese\",\"ar\":\"صيني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(33, '{\"en\":\"Christmas Islander\",\"ar\":\"جزيرة عيد الميلاد\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(34, '{\"en\":\"Cocos Islander\",\"ar\":\"جزر كوكوس\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(35, '{\"en\":\"Colombian\",\"ar\":\"كولومبي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(36, '{\"en\":\"Comorian\",\"ar\":\"جزر القمر\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(37, '{\"en\":\"Congolese\",\"ar\":\"كونغي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(38, '{\"en\":\"Cook Islander\",\"ar\":\"جزر كوك\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(39, '{\"en\":\"Costa Rican\",\"ar\":\"كوستاريكي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(40, '{\"en\":\"Croatian\",\"ar\":\"كوراتي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(41, '{\"en\":\"Cuban\",\"ar\":\"كوبي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(42, '{\"en\":\"Cypriot\",\"ar\":\"قبرصي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(43, '{\"en\":\"Curacian\",\"ar\":\"كوراساوي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(44, '{\"en\":\"Czech\",\"ar\":\"تشيكي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(45, '{\"en\":\"Danish\",\"ar\":\"دنماركي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(46, '{\"en\":\"Djiboutian\",\"ar\":\"جيبوتي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(47, '{\"en\":\"Dominican\",\"ar\":\"دومينيكي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(48, '{\"en\":\"Dominican\",\"ar\":\"دومينيكي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(49, '{\"en\":\"Ecuadorian\",\"ar\":\"إكوادوري\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(50, '{\"en\":\"Egyptian\",\"ar\":\"مصري\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(51, '{\"en\":\"Salvadoran\",\"ar\":\"سلفادوري\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(52, '{\"en\":\"Equatorial Guinean\",\"ar\":\"غيني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(53, '{\"en\":\"Eritrean\",\"ar\":\"إريتيري\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(54, '{\"en\":\"Estonian\",\"ar\":\"استوني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(55, '{\"en\":\"Falkland Islander\",\"ar\":\"فوكلاندي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(56, '{\"en\":\"Faroese\",\"ar\":\"جزر فارو\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(57, '{\"en\":\"Fijian\",\"ar\":\"فيجي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(58, '{\"en\":\"Finnish\",\"ar\":\"فنلندي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(59, '{\"en\":\"French\",\"ar\":\"فرنسي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(60, '{\"en\":\"French Guianese\",\"ar\":\"غويانا الفرنسية\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(61, '{\"en\":\"French Polynesian\",\"ar\":\"بولينيزيي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(62, '{\"en\":\"French\",\"ar\":\"أراض فرنسية جنوبية وأنتارتيكية\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(63, '{\"en\":\"Gabonese\",\"ar\":\"غابوني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(64, '{\"en\":\"Gambian\",\"ar\":\"غامبي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(65, '{\"en\":\"Georgian\",\"ar\":\"جيورجي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(66, '{\"en\":\"German\",\"ar\":\"ألماني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(67, '{\"en\":\"Ghanaian\",\"ar\":\"غاني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(68, '{\"en\":\"Gibraltar\",\"ar\":\"جبل طارق\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(69, '{\"en\":\"Guernsian\",\"ar\":\"غيرنزي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(70, '{\"en\":\"Greek\",\"ar\":\"يوناني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(71, '{\"en\":\"Greenlandic\",\"ar\":\"جرينلاندي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(72, '{\"en\":\"Grenadian\",\"ar\":\"غرينادي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(73, '{\"en\":\"Guadeloupe\",\"ar\":\"جزر جوادلوب\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(74, '{\"en\":\"Guamanian\",\"ar\":\"جوامي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(75, '{\"en\":\"Guatemalan\",\"ar\":\"غواتيمالي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(76, '{\"en\":\"Guinean\",\"ar\":\"غيني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(77, '{\"en\":\"Guinea-Bissauan\",\"ar\":\"غيني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(78, '{\"en\":\"Guyanese\",\"ar\":\"غياني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(79, '{\"en\":\"Haitian\",\"ar\":\"هايتي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(80, '{\"en\":\"Heard and Mc Donald Islanders\",\"ar\":\"جزيرة هيرد وجزر ماكدونالد\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(81, '{\"en\":\"Honduran\",\"ar\":\"هندوراسي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(82, '{\"en\":\"Hongkongese\",\"ar\":\"هونغ كونغي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(83, '{\"en\":\"Hungarian\",\"ar\":\"مجري\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(84, '{\"en\":\"Icelandic\",\"ar\":\"آيسلندي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(85, '{\"en\":\"Indian\",\"ar\":\"هندي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(86, '{\"en\":\"Manx\",\"ar\":\"ماني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(87, '{\"en\":\"Indonesian\",\"ar\":\"أندونيسيي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(88, '{\"en\":\"Iranian\",\"ar\":\"إيراني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(89, '{\"en\":\"Iraqi\",\"ar\":\"عراقي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(90, '{\"en\":\"Irish\",\"ar\":\"إيرلندي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(91, '{\"en\":\"Italian\",\"ar\":\"إيطالي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(92, '{\"en\":\"Ivory Coastian\",\"ar\":\"ساحل العاج\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(93, '{\"en\":\"Jersian\",\"ar\":\"جيرزي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(94, '{\"en\":\"Jamaican\",\"ar\":\"جمايكي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(95, '{\"en\":\"Japanese\",\"ar\":\"ياباني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(96, '{\"en\":\"Jordanian\",\"ar\":\"أردني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(97, '{\"en\":\"Kazakh\",\"ar\":\"كازاخستاني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(98, '{\"en\":\"Kenyan\",\"ar\":\"كيني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(99, '{\"en\":\"I-Kiribati\",\"ar\":\"كيريباتي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(100, '{\"en\":\"North Korean\",\"ar\":\"كوري\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(101, '{\"en\":\"South Korean\",\"ar\":\"كوري\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(102, '{\"en\":\"Kosovar\",\"ar\":\"كوسيفي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(103, '{\"en\":\"Kuwaiti\",\"ar\":\"كويتي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(104, '{\"en\":\"Kyrgyzstani\",\"ar\":\"قيرغيزستاني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(105, '{\"en\":\"Laotian\",\"ar\":\"لاوسي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(106, '{\"en\":\"Latvian\",\"ar\":\"لاتيفي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(107, '{\"en\":\"Lebanese\",\"ar\":\"لبناني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(108, '{\"en\":\"Basotho\",\"ar\":\"ليوسيتي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(109, '{\"en\":\"Liberian\",\"ar\":\"ليبيري\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(110, '{\"en\":\"Libyan\",\"ar\":\"ليبي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(111, '{\"en\":\"Liechtenstein\",\"ar\":\"ليختنشتيني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(112, '{\"en\":\"Lithuanian\",\"ar\":\"لتوانيي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(113, '{\"en\":\"Luxembourger\",\"ar\":\"لوكسمبورغي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(114, '{\"en\":\"Sri Lankian\",\"ar\":\"سريلانكي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(115, '{\"en\":\"Macanese\",\"ar\":\"ماكاوي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(116, '{\"en\":\"Macedonian\",\"ar\":\"مقدوني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(117, '{\"en\":\"Malagasy\",\"ar\":\"مدغشقري\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(118, '{\"en\":\"Malawian\",\"ar\":\"مالاوي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(119, '{\"en\":\"Malaysian\",\"ar\":\"ماليزي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(120, '{\"en\":\"Maldivian\",\"ar\":\"مالديفي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(121, '{\"en\":\"Malian\",\"ar\":\"مالي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(122, '{\"en\":\"Maltese\",\"ar\":\"مالطي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(123, '{\"en\":\"Marshallese\",\"ar\":\"مارشالي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(124, '{\"en\":\"Martiniquais\",\"ar\":\"مارتينيكي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(125, '{\"en\":\"Mauritanian\",\"ar\":\"موريتانيي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(126, '{\"en\":\"Mauritian\",\"ar\":\"موريشيوسي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(127, '{\"en\":\"Mahoran\",\"ar\":\"مايوتي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(128, '{\"en\":\"Mexican\",\"ar\":\"مكسيكي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(129, '{\"en\":\"Micronesian\",\"ar\":\"مايكرونيزيي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(130, '{\"en\":\"Moldovan\",\"ar\":\"مولديفي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(131, '{\"en\":\"Monacan\",\"ar\":\"مونيكي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(132, '{\"en\":\"Mongolian\",\"ar\":\"منغولي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(133, '{\"en\":\"Montenegrin\",\"ar\":\"الجبل الأسود\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(134, '{\"en\":\"Montserratian\",\"ar\":\"مونتسيراتي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(135, '{\"en\":\"Mozambican\",\"ar\":\"موزمبيقي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(136, '{\"en\":\"Myanmarian\",\"ar\":\"ميانماري\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(137, '{\"en\":\"Namibian\",\"ar\":\"ناميبي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(138, '{\"en\":\"Nauruan\",\"ar\":\"نوري\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(139, '{\"en\":\"Nepalese\",\"ar\":\"نيبالي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(140, '{\"en\":\"Dutch\",\"ar\":\"هولندي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(141, '{\"en\":\"Dutch Antilier\",\"ar\":\"هولندي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(142, '{\"en\":\"New Caledonian\",\"ar\":\"كاليدوني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(143, '{\"en\":\"New Zealander\",\"ar\":\"نيوزيلندي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(144, '{\"en\":\"Nicaraguan\",\"ar\":\"نيكاراجوي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(145, '{\"en\":\"Nigerien\",\"ar\":\"نيجيري\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(146, '{\"en\":\"Nigerian\",\"ar\":\"نيجيري\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(147, '{\"en\":\"Niuean\",\"ar\":\"ني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(148, '{\"en\":\"Norfolk Islander\",\"ar\":\"نورفوليكي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(149, '{\"en\":\"Northern Marianan\",\"ar\":\"ماريني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(150, '{\"en\":\"Norwegian\",\"ar\":\"نرويجي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(151, '{\"en\":\"Pakistani\",\"ar\":\"باكستاني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(152, '{\"en\":\"Palauan\",\"ar\":\"بالاوي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(153, '{\"en\":\"Palestinian\",\"ar\":\"فلسطيني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(154, '{\"en\":\"Panamanian\",\"ar\":\"بنمي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(155, '{\"en\":\"Papua New Guinean\",\"ar\":\"بابوي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(156, '{\"en\":\"Paraguayan\",\"ar\":\"بارغاوي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(157, '{\"en\":\"Peruvian\",\"ar\":\"بيري\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(158, '{\"en\":\"Filipino\",\"ar\":\"فلبيني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(159, '{\"en\":\"Pitcairn Islander\",\"ar\":\"بيتكيرني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(160, '{\"en\":\"Polish\",\"ar\":\"بوليني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(161, '{\"en\":\"Portuguese\",\"ar\":\"برتغالي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(162, '{\"en\":\"Puerto Rican\",\"ar\":\"بورتي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(163, '{\"en\":\"Reunionese\",\"ar\":\"ريونيوني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(164, '{\"en\":\"Romanian\",\"ar\":\"روماني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(165, '{\"en\":\"Russian\",\"ar\":\"روسي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(166, '{\"en\":\"Rwandan\",\"ar\":\"رواندا\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(167, '{\"ar\":\"Kittitian/Nevisian\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(168, '{\"en\":\"St. Martian(French)\",\"ar\":\"ساينت مارتني فرنسي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(169, '{\"en\":\"St. Martian(Dutch)\",\"ar\":\"ساينت مارتني هولندي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(170, '{\"en\":\"St. Pierre and Miquelon\",\"ar\":\"سان بيير وميكلوني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(171, '{\"en\":\"Saint Vincent and the Grenadines\",\"ar\":\"سانت فنسنت وجزر غرينادين\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(172, '{\"en\":\"Samoan\",\"ar\":\"ساموي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(173, '{\"en\":\"Sammarinese\",\"ar\":\"ماريني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(174, '{\"en\":\"Sao Tomean\",\"ar\":\"ساو تومي وبرينسيبي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(175, '{\"en\":\"Senegalese\",\"ar\":\"سنغالي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(176, '{\"en\":\"Serbian\",\"ar\":\"صربي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(177, '{\"en\":\"Seychellois\",\"ar\":\"سيشيلي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(178, '{\"en\":\"Sierra Leonean\",\"ar\":\"سيراليوني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(179, '{\"en\":\"Singaporean\",\"ar\":\"سنغافوري\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(180, '{\"en\":\"Slovak\",\"ar\":\"سولفاكي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(181, '{\"en\":\"Slovenian\",\"ar\":\"سولفيني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(182, '{\"en\":\"Solomon Island\",\"ar\":\"جزر سليمان\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(183, '{\"en\":\"Somali\",\"ar\":\"صومالي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(184, '{\"en\":\"South African\",\"ar\":\"أفريقي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(185, '{\"en\":\"South Georgia and the South Sandwich\",\"ar\":\"لمنطقة القطبية الجنوبية\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(186, '{\"en\":\"Surinamese\",\"ar\":\"سورينامي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(187, '{\"en\":\"Svalbardian/Jan Mayenian\",\"ar\":\"سفالبارد ويان ماين\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(188, '{\"en\":\"Swazi\",\"ar\":\"سوازيلندي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(189, '{\"en\":\"Swedish\",\"ar\":\"سويدي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(190, '{\"en\":\"Swiss\",\"ar\":\"سويسري\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(191, '{\"en\":\"Taiwanese\",\"ar\":\"تايواني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(192, '{\"en\":\"Tajikistani\",\"ar\":\"طاجيكستاني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(193, '{\"en\":\"Tanzanian\",\"ar\":\"تنزانيي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(194, '{\"en\":\"Thai\",\"ar\":\"تايلندي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(195, '{\"en\":\"Timor-Lestian\",\"ar\":\"تيموري\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(196, '{\"en\":\"Togolese\",\"ar\":\"توغي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(197, '{\"en\":\"Tokelaian\",\"ar\":\"توكيلاوي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(198, '{\"en\":\"Tongan\",\"ar\":\"تونغي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(199, '{\"en\":\"Trinidadian/Tobagonian\",\"ar\":\"ترينيداد وتوباغو\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(200, '{\"en\":\"Turks and Caicos Islands\",\"ar\":\"جزر توركس وكايكوس\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(201, '{\"en\":\"Tuvaluan\",\"ar\":\"توفالي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(202, '{\"en\":\"Ugandan\",\"ar\":\"أوغندي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(203, '{\"en\":\"Ukrainian\",\"ar\":\"أوكراني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(204, '{\"en\":\"Emirati\",\"ar\":\"إماراتي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(205, '{\"en\":\"British\",\"ar\":\"بريطاني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(206, '{\"en\":\"American\",\"ar\":\"أمريكي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(207, '{\"en\":\"US Minor Outlying Islander\",\"ar\":\"أمريكي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(208, '{\"en\":\"Uruguayan\",\"ar\":\"أورغواي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(209, '{\"en\":\"Uzbek\",\"ar\":\"أوزباكستاني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(210, '{\"en\":\"Vanuatuan\",\"ar\":\"فانواتي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(211, '{\"en\":\"Venezuelan\",\"ar\":\"فنزويلي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(212, '{\"en\":\"Vietnamese\",\"ar\":\"فيتنامي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(213, '{\"en\":\"American Virgin Islander\",\"ar\":\"أمريكي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(214, '{\"en\":\"Vatican\",\"ar\":\"فاتيكاني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(215, '{\"en\":\"Wallisian/Futunan\",\"ar\":\"فوتوني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(216, '{\"en\":\"Sahrawian\",\"ar\":\"صحراوي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(217, '{\"en\":\"Zambian\",\"ar\":\"زامبياني\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(218, '{\"en\":\"Zimbabwean\",\"ar\":\"زمبابوي\"}', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54');

-- --------------------------------------------------------

--
-- Table structure for table `permissions`
--

CREATE TABLE IF NOT EXISTS `permissions` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'التقارير', 'web', '2025-04-26 15:53:53', '2025-04-26 15:53:53'),
(2, 'الطباعة', 'web', '2025-04-26 15:53:53', '2025-04-26 15:53:53'),
(3, 'تصدير', 'web', '2025-04-26 15:53:53', '2025-04-26 15:53:53'),
(4, 'الصلاحيات', 'web', '2025-04-26 15:53:53', '2025-04-26 15:53:53'),
(5, 'عرض صلاحية', 'web', '2025-04-26 15:53:53', '2025-04-26 15:53:53'),
(6, 'اضافة صلاحية', 'web', '2025-04-26 15:53:53', '2025-04-26 15:53:53'),
(7, 'تعديل صلاحية', 'web', '2025-04-26 15:53:53', '2025-04-26 15:53:53'),
(8, 'حذف صلاحية', 'web', '2025-04-26 15:53:53', '2025-04-26 15:53:53'),
(9, 'المستخدمين', 'web', '2025-04-26 15:53:53', '2025-04-26 15:53:53'),
(10, 'عرض مستخدم', 'web', '2025-04-26 15:53:53', '2025-04-26 15:53:53'),
(11, 'اضافة مستخدم', 'web', '2025-04-26 15:53:53', '2025-04-26 15:53:53'),
(12, 'تعديل مستخدم', 'web', '2025-04-26 15:53:53', '2025-04-26 15:53:53'),
(13, 'حذف مستخدم', 'web', '2025-04-26 15:53:53', '2025-04-26 15:53:53'),
(14, 'المواقع', 'web', '2025-04-26 15:53:53', '2025-04-26 15:53:53'),
(15, 'عرض موقع', 'web', '2025-04-26 15:53:53', '2025-04-26 15:53:53'),
(16, 'اضافة موقع', 'web', '2025-04-26 15:53:53', '2025-04-26 15:53:53'),
(17, 'تعديل موقع', 'web', '2025-04-26 15:53:53', '2025-04-26 15:53:53'),
(18, 'حذف موقع', 'web', '2025-04-26 15:53:53', '2025-04-26 15:53:53'),
(19, 'السجلات', 'web', '2025-04-26 15:53:53', '2025-04-26 15:53:53'),
(20, 'عرض سجل', 'web', '2025-04-26 15:53:53', '2025-04-26 15:53:53'),
(21, 'اضافة سجل', 'web', '2025-04-26 15:53:53', '2025-04-26 15:53:53'),
(22, 'تعديل سجل', 'web', '2025-04-26 15:53:53', '2025-04-26 15:53:53'),
(23, 'حذف سجل', 'web', '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(24, 'الاعراض', 'web', '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(25, 'عرض عرض', 'web', '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(26, 'اضافة عرض', 'web', '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(27, 'تعديل عرض', 'web', '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(28, 'حذف عرض', 'web', '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(29, 'الوبئيات', 'web', '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(30, 'عرض وباء', 'web', '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(31, 'اضافة وباء', 'web', '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(32, 'تعديل وباء', 'web', '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(33, 'حذف وباء', 'web', '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(34, 'المرضى', 'web', '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(35, 'عرض مريض', 'web', '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(36, 'اضافة مريض', 'web', '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(37, 'تعديل مريض', 'web', '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(38, 'حذف مريض', 'web', '2025-04-26 15:53:54', '2025-04-26 15:53:54');

-- --------------------------------------------------------

--
-- Table structure for table `records`
--

CREATE TABLE IF NOT EXISTS `records` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `diagnosis_date` date NOT NULL,
  `recovery_date` date DEFAULT NULL,
  `desc` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `stauts` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `patient_id` bigint UNSIGNED NOT NULL,
  `location_id` bigint UNSIGNED NOT NULL,
  `disease_id` bigint UNSIGNED NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `records_patient_id_foreign` (`patient_id`),
  KEY `records_location_id_foreign` (`location_id`),
  KEY `records_disease_id_foreign` (`disease_id`)
) ENGINE=InnoDB AUTO_INCREMENT=164 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `records`
--

INSERT INTO `records` (`id`, `diagnosis_date`, `recovery_date`, `desc`, `stauts`, `patient_id`, `location_id`, `disease_id`, `deleted_at`, `created_at`, `updated_at`) VALUES
(114, '2007-06-04', NULL, 'Odit sit tempora cum enim.', '1', 43, 7, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(115, '2018-02-17', NULL, 'Adipisci laboriosam ipsa ducimus et natus non.', '1', 72, 1, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(116, '2013-05-23', NULL, 'Est et maiores ullam officia et nostrum.', '4', 62, 1, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(117, '2009-12-10', NULL, 'Assumenda laboriosam unde quod est omnis ut veniam consequatur.', '1', 51, 7, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(118, '1991-02-26', NULL, 'Ut consequatur blanditiis facere omnis iure.', '4', 12, 7, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(119, '1999-01-23', NULL, 'Ratione perspiciatis quasi dolor voluptatum accusamus molestias.', '4', 75, 1, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(120, '1982-08-31', NULL, 'Nisi perferendis delectus ipsam cum.', '4', 83, 7, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(121, '1978-01-30', NULL, 'Molestiae vel quam sed est cumque et.', '4', 25, 1, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(122, '2001-05-07', NULL, 'Eum qui quia nihil non molestiae qui.', '4', 8, 1, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(123, '1984-12-18', NULL, 'Quia voluptatem voluptas nulla labore.', '1', 42, 7, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(124, '2018-02-01', NULL, 'Consequatur error a earum cum natus totam aut ut.', '1', 46, 1, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(125, '2014-08-02', NULL, 'Minima magni id eos est cupiditate.', '4', 97, 7, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(126, '2022-04-26', NULL, 'Similique perferendis iusto dolores ut.', '1', 58, 7, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(127, '1973-08-10', NULL, 'Sint molestiae labore et veniam sapiente reprehenderit.', '1', 64, 7, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(128, '2012-04-25', NULL, 'Aut autem aliquid velit quia commodi.', '4', 84, 7, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(129, '2009-02-09', NULL, 'Non ut sint tempore provident asperiores rerum sit explicabo.', '4', 11, 1, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(130, '2019-10-31', NULL, 'Perferendis et quaerat illo dicta.', '4', 81, 1, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(131, '2010-12-03', NULL, 'Quibusdam sequi ut praesentium temporibus ad sapiente molestiae.', '4', 48, 7, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(132, '2000-05-28', NULL, 'Accusantium distinctio quidem sunt quo vitae quis temporibus.', '1', 74, 7, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(133, '1991-10-17', NULL, 'Ipsa esse iste est dolores in vitae nobis.', '1', 63, 1, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(134, '1996-03-18', NULL, 'Vero magnam omnis molestiae iusto harum et illo.', '1', 82, 1, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(135, '2022-04-30', NULL, 'Aut nostrum accusantium atque error asperiores facere.', '4', 20, 7, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(136, '1982-09-03', NULL, 'Ad quasi eaque omnis exercitationem qui dolores sint.', '1', 32, 7, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(137, '1980-11-07', NULL, 'Nihil vero amet esse soluta rerum ipsum est.', '4', 6, 7, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(138, '2016-08-31', NULL, 'Qui ut corrupti fugiat rem dolor.', '4', 4, 7, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(139, '1978-02-10', NULL, 'Et provident est est voluptatem eius facilis.', '4', 33, 7, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(140, '1995-09-21', NULL, 'Omnis vel dolores quia.', '4', 3, 1, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(141, '2006-02-08', NULL, 'Deserunt placeat error dolorem reprehenderit dolorem itaque quos vero.', '4', 88, 1, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(142, '1972-04-04', NULL, 'Cumque est voluptatem consequatur quibusdam eveniet deleniti accusamus.', '1', 26, 7, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(143, '2022-04-02', NULL, 'Rerum non pariatur ea est accusantium quasi.', '1', 86, 7, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(144, '1976-02-19', NULL, 'Aut culpa repellendus sed amet non soluta.', '4', 7, 7, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(145, '1994-07-12', NULL, 'Aut veniam voluptas qui modi.', '1', 99, 1, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(146, '1988-04-14', NULL, 'Rerum qui corrupti laudantium ex.', '1', 22, 7, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(147, '2004-09-25', NULL, 'Qui esse quos explicabo quod itaque quia.', '1', 45, 1, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(148, '1995-07-09', NULL, 'Asperiores velit facere soluta alias velit aspernatur numquam.', '1', 91, 7, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(149, '1971-07-12', NULL, 'Aut iure quo tenetur rerum maxime consequuntur temporibus aperiam.', '4', 80, 1, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(150, '1995-12-12', NULL, 'Asperiores pariatur pariatur quod nam.', '1', 92, 7, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(151, '2013-04-29', NULL, 'Reiciendis libero velit praesentium aut cum laborum.', '1', 90, 7, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(152, '1990-08-24', NULL, 'Consequatur nisi omnis alias ipsam et dolores ut.', '4', 77, 1, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(153, '2008-01-29', NULL, 'Possimus eaque voluptate accusantium architecto necessitatibus veritatis.', '1', 87, 1, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(154, '1992-11-01', NULL, 'Mollitia sit architecto tenetur quae pariatur atque fuga.', '1', 1, 1, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(155, '2005-12-14', NULL, 'Unde facere suscipit quidem rerum amet omnis.', '4', 23, 1, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(156, '1994-01-16', NULL, 'Qui aut eaque nihil architecto et.', '1', 10, 7, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(157, '1981-07-29', NULL, 'Saepe iure nihil est ut debitis.', '1', 31, 1, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(158, '2019-12-17', NULL, 'Doloribus sit animi ipsa nobis qui.', '1', 35, 7, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(159, '2005-08-24', NULL, 'Est numquam sed neque delectus ut et.', '4', 40, 7, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(160, '2009-04-01', NULL, 'Natus nam sint rerum mollitia modi expedita.', '4', 44, 7, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(161, '2023-12-27', NULL, 'Quis praesentium sint amet.', '1', 85, 7, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(162, '1989-12-10', NULL, 'Quidem enim praesentium ut minus odio.', '1', 61, 7, 1, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31'),
(163, '2003-05-10', NULL, 'Fugit id recusandae quisquam exercitationem ad officiis et qui.', '4', 2, 7, 9, NULL, '2025-04-26 16:43:31', '2025-04-26 16:43:31');

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE IF NOT EXISTS `roles` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'owner', 'web', '2025-04-26 15:53:54', '2025-04-26 15:53:54');

-- --------------------------------------------------------

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE IF NOT EXISTS `role_has_permissions` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(15, 1),
(16, 1),
(17, 1),
(18, 1),
(19, 1),
(20, 1),
(21, 1),
(22, 1),
(23, 1),
(24, 1),
(25, 1),
(26, 1),
(27, 1),
(28, 1),
(29, 1),
(30, 1),
(31, 1),
(32, 1),
(33, 1),
(34, 1),
(35, 1),
(36, 1),
(37, 1),
(38, 1);

-- --------------------------------------------------------

--
-- Table structure for table `symptoms`
--

CREATE TABLE IF NOT EXISTS `symptoms` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `disease_id` bigint UNSIGNED NOT NULL,
  `desc` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `symptoms_disease_id_foreign` (`disease_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `symptoms`
--

INSERT INTO `symptoms` (`id`, `disease_id`, `desc`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, 'كثرة التبول: خاصة في الليل', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(2, 2, 'صداع: خاصة في مؤخرة الرأس', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(3, 3, 'ضيق في التنفس: الشعور بصعوبة في أخذ نفس عميق أو الشعور بالاختناق ', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(4, 4, 'ألم المفاصل: قد يكون الألم مستمرًا أو متقطعًا، وقد يزداد مع الحركة أو الضغط على المفصل.', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54'),
(5, 5, 'حمى مفاجئة: غالبًا ما تكون درجة الحرارة مرتفعة (38 درجة مئوية أو أعلى)', NULL, '2025-04-26 15:53:54', '2025-04-26 15:53:54');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `records`
--
ALTER TABLE `records`
  ADD CONSTRAINT `records_disease_id_foreign` FOREIGN KEY (`disease_id`) REFERENCES `diseases` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `records_location_id_foreign` FOREIGN KEY (`location_id`) REFERENCES `locations` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `records_patient_id_foreign` FOREIGN KEY (`patient_id`) REFERENCES `patients` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `symptoms`
--
ALTER TABLE `symptoms`
  ADD CONSTRAINT `symptoms_disease_id_foreign` FOREIGN KEY (`disease_id`) REFERENCES `diseases` (`id`) ON DELETE CASCADE;
COMMIT;

