-- 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 `password_resets`
--

CREATE TABLE IF NOT EXISTS `password_resets` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `patients`
--

CREATE TABLE IF NOT EXISTS `patients` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `age` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ssn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nationalitie_id` bigint UNSIGNED NOT NULL,
  `blood_id` bigint UNSIGNED NOT NULL,
  `gender_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 `patients_nationalitie_id_foreign` (`nationalitie_id`),
  KEY `patients_blood_id_foreign` (`blood_id`),
  KEY `patients_gender_id_foreign` (`gender_id`)
) ENGINE=InnoDB AUTO_INCREMENT=191 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `patients`
--

INSERT INTO `patients` (`id`, `name`, `age`, `phone`, `address`, `ssn`, `nationalitie_id`, `blood_id`, `gender_id`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Lottie Cronin', '38', '1-219-487-1748', '441 Rex Coves\nPort Letitia, MN 36806-3362', '15640532', 1, 1, 2, NULL, '2025-04-26 15:53:59', '2025-04-26 15:53:59'),
(2, 'Ava Botsford', '41', '+1.925.469.6534', '8048 Everette Isle\nPort Agustin, ID 77587', '60938095', 1, 1, 2, NULL, '2025-04-26 15:53:59', '2025-04-26 15:53:59'),
(3, 'Yesenia Torp', '62', '585.525.1041', '13088 Ferry Mount\nLake Georgianna, NM 78778', '71608414', 1, 8, 2, NULL, '2025-04-26 15:53:59', '2025-04-26 15:53:59'),
(4, 'Darrick Fay', '41', '+1.352.473.0481', '165 Kling Light\nBrendaburgh, NY 31390-4932', '70539188', 1, 1, 1, NULL, '2025-04-26 15:53:59', '2025-04-26 15:53:59'),
(5, 'Tiana Medhurst Sr.', '40', '256-472-0212', '3864 Easton Fork Apt. 916\nPort Aron, LA 06562', '60116339', 9, 1, 1, NULL, '2025-04-26 15:53:59', '2025-04-26 15:53:59'),
(6, 'Stewart Hill II', '33', '+19408347172', '59377 Alfreda Highway Suite 971\nNew Fae, WY 08177', '81065518', 1, 8, 1, NULL, '2025-04-26 15:53:59', '2025-04-26 15:53:59'),
(7, 'Ima Buckridge', '41', '954.383.6248', '6830 Julien Field\nTylerberg, AL 31132', '87542441', 9, 8, 2, NULL, '2025-04-26 15:53:59', '2025-04-26 15:53:59'),
(8, 'Kyla Crona', '28', '1-541-520-6165', '4777 Waters Locks\nRatkeberg, OK 16193-6870', '10913132', 9, 8, 2, NULL, '2025-04-26 15:53:59', '2025-04-26 15:53:59'),
(9, 'Ms. Burnice Davis DVM', '56', '917.931.3058', '59084 Welch Isle Suite 260\nBoganmouth, NM 49302', '83026863', 1, 1, 2, NULL, '2025-04-26 15:53:59', '2025-04-26 15:53:59'),
(10, 'Johnpaul Hettinger', '18', '1-515-722-3903', '8339 Conn Walk Suite 141\nEast Lane, DC 71413-3890', '28182858', 1, 8, 1, NULL, '2025-04-26 15:53:59', '2025-04-26 15:53:59'),
(11, 'Claude Howell DDS', '52', '+1 (972) 575-5512', '55702 Gladys Shoal Apt. 411\nDeonteview, DE 10107-4266', '52303923', 1, 8, 2, NULL, '2025-04-26 16:36:12', '2025-04-26 16:36:12'),
(12, 'Marcella Jerde', '35', '+1.641.385.1042', '56544 Nienow Tunnel Suite 260\nNorth Marieport, LA 69906', '71016954', 9, 8, 2, NULL, '2025-04-26 16:36:12', '2025-04-26 16:36:12'),
(13, 'Cielo Prohaska', '55', '+1.580.558.5930', '2917 Weissnat Ferry Apt. 530\nRandalchester, MD 57296-7919', '85500417', 1, 8, 1, NULL, '2025-04-26 16:36:12', '2025-04-26 16:36:12'),
(14, 'Dr. Nikita Heller Sr.', '31', '+1-410-491-5931', '94509 Nathanial Square Apt. 031\nStrosinberg, OR 16905', '92948207', 9, 8, 2, NULL, '2025-04-26 16:36:12', '2025-04-26 16:36:12'),
(15, 'Madalyn Kihn', '47', '+13396528065', '603 Murazik Falls Apt. 982\nNew Bernitaberg, MO 39949', '89939981', 1, 8, 1, NULL, '2025-04-26 16:36:12', '2025-04-26 16:36:12'),
(16, 'Kaya Mraz', '19', '925.520.6206', '8409 Trantow Cove\nPort Rosalia, NE 39650-5562', '59472139', 9, 1, 2, NULL, '2025-04-26 16:36:12', '2025-04-26 16:36:12'),
(17, 'Dr. Deon Smitham', '19', '+1 (279) 301-4376', '235 Ocie Oval\nKlingbury, RI 23568', '20664497', 1, 8, 2, NULL, '2025-04-26 16:36:12', '2025-04-26 16:36:12'),
(18, 'Mathias Wilderman', '27', '+1.774.314.4358', '3126 Kassulke Freeway\nChesleyside, IL 15153-2762', '69432790', 9, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(19, 'Jocelyn Gerlach', '64', '(940) 550-3976', '22629 Dach Rapids\nEast Aniyaport, CA 65294-6499', '72706452', 9, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(20, 'Dr. Madalyn Jacobson II', '33', '530.655.4295', '5997 Will Port Apt. 339\nBalistreriburgh, AL 01781-4790', '29251531', 9, 1, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(21, 'Jabari Sawayn', '35', '+15412187338', '45458 Stroman Pass Suite 499\nWest Dora, SD 39108', '77202682', 9, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(22, 'Ms. Macie Kiehn III', '38', '1-541-632-7320', '26936 Dell Drives\nBernhardberg, CA 41330', '75543156', 9, 1, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(23, 'Amelie Rolfson', '40', '(929) 353-9644', '748 Langworth Inlet\nCatharinehaven, ID 54291-1134', '14499801', 9, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(24, 'Dayana Graham', '26', '774-227-4259', '32592 Schaefer Stravenue Suite 925\nPort Barney, KS 73617', '13800280', 9, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(25, 'Eduardo Beier III', '29', '+1.862.716.0650', '421 Prosacco Canyon Apt. 330\nOthaport, FL 00068-9195', '43009850', 9, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(26, 'Kyle Becker', '63', '(734) 210-8329', '65321 Maud Ridge\nLake Abbigailmouth, NC 35176', '10018156', 1, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(27, 'Karley Brown MD', '42', '1-562-739-8470', '886 Letitia Harbor Apt. 028\nKarltown, NH 97235-3186', '60933025', 1, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(28, 'Rachel Legros', '47', '+1-657-701-6044', '631 Swift Green Apt. 155\nNorth Delphine, AZ 52081', '92415764', 9, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(29, 'Brian Schuppe DDS', '62', '+1-458-298-3789', '9939 Sanford Port\nPort Damiantown, CT 92782', '43501913', 1, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(30, 'Prof. Eliseo Schneider I', '22', '+1-469-773-3403', '545 Glover Valley Apt. 201\nEdwardoshire, NY 13074-4387', '95932505', 1, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(31, 'Prof. Oral Jones Jr.', '52', '+1.832.797.9977', '40910 Jayda Canyon Suite 836\nWymanmouth, MO 29876-7353', '89209872', 1, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(32, 'Mr. Freddie Buckridge V', '32', '913.271.3008', '57955 Trantow Lakes\nFerryburgh, ME 23221-8303', '55748201', 9, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(33, 'Prof. Celestine Ledner I', '37', '+1-602-928-1375', '742 Bruen Wells\nPort Norene, IA 28088-0545', '90898932', 9, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(34, 'Priscilla Cormier', '47', '+14436547394', '966 Rachelle Courts\nSouth Edwardport, NE 86020-2237', '41314784', 1, 1, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(35, 'Yoshiko Dietrich II', '61', '+1-203-495-0032', '6689 Theodore Tunnel Apt. 327\nAlextown, CA 00892-3491', '42718619', 9, 1, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(36, 'Haskell Zulauf', '34', '+1 (802) 723-4406', '601 Jamie Place Apt. 358\nPort Betsyton, OH 61115', '71677982', 9, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(37, 'Bailee Rodriguez', '30', '+1-947-476-1692', '79042 Padberg Pine Suite 990\nLake Sarina, WV 56673', '10777548', 9, 1, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(38, 'Moshe Frami', '40', '347-561-6488', '188 Cindy Overpass Apt. 859\nNew Bernadinemouth, RI 60211', '72548960', 9, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(39, 'Dr. Valentine Doyle', '52', '925-610-0396', '77716 Mills Trafficway Apt. 081\nJosiahmouth, WY 43422', '67479837', 9, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(40, 'Dr. Colby Frami Sr.', '22', '+1 (501) 914-4961', '71795 Erin Drive Apt. 009\nLake Claudia, MN 77943', '31658179', 1, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(41, 'Benedict Willms', '60', '+1 (678) 827-9345', '6549 Rolfson Plaza Apt. 383\nKemmerburgh, AL 92681-1622', '25254389', 9, 1, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(42, 'Lottie Rogahn', '63', '(240) 952-6740', '7883 Joanie Mountains\nJennieland, AK 84385', '70185285', 1, 1, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(43, 'Angus Kshlerin', '19', '(463) 799-1714', '131 Rath Pass\nLake Moisesview, NH 10253', '85343118', 9, 1, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(44, 'Alena Abernathy', '29', '+1-442-393-2128', '377 Americo Neck\nJazmynchester, MT 62324-2536', '62929208', 9, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(45, 'Lucy Grimes', '28', '415.472.6729', '67613 Kshlerin Port\nHandton, KY 45578-4130', '13660290', 9, 1, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(46, 'Evans Stracke Jr.', '64', '701-414-9338', '706 Stoltenberg Drives\nSchneiderbury, GA 08865-1412', '48480745', 9, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(47, 'Nestor Bosco', '48', '1-951-243-0121', '66864 Murray Prairie\nLednerland, NM 86183', '22338895', 1, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(48, 'Dr. America Kuhic', '42', '+1.725.915.7471', '412 Cecil Valleys\nLake Abigaleshire, WY 24485', '90270266', 1, 1, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(49, 'Kellen Leuschke', '57', '1-484-428-9323', '60089 Heaney Walk Apt. 641\nAlexandrashire, MO 64789-1853', '44102621', 9, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(50, 'Fleta Stamm', '43', '1-662-617-7678', '9020 Deckow Island\nNew Isidro, ME 26042', '29582315', 1, 1, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(51, 'Hester Brown', '20', '1-920-966-0881', '5839 Miller Extension\nMarvinhaven, DC 33854', '19453851', 9, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(52, 'Cary Goyette', '48', '+1 (657) 268-9626', '20860 Terence Mission Apt. 353\nEast Daisha, FL 71931', '41022563', 9, 1, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(53, 'Mr. Jo Keebler', '32', '(636) 318-4775', '7336 Laron Inlet Suite 763\nParisianborough, HI 36185-0593', '45599356', 1, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(54, 'Mrs. Delia Heathcote', '64', '404-963-9953', '20651 Kristofer Port\nRamonamouth, WI 98457', '98811644', 9, 1, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(55, 'Gavin Little', '43', '+1-936-594-1782', '3606 Imelda Trail\nRosemarieside, WV 91932', '20009210', 1, 1, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(56, 'Mona Yundt', '21', '1-586-462-1778', '92201 Kaden Valley\nEast Sallie, VT 85057', '60837233', 1, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(57, 'Madelyn Macejkovic', '43', '769-619-2126', '69060 Glover Court\nCarrollburgh, VA 68705-8533', '31030812', 9, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(58, 'Frankie Hudson IV', '35', '+1.541.672.1117', '368 Kassulke Grove Suite 268\nDustyhaven, UT 74184-7658', '52468989', 1, 1, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(59, 'Adela Prosacco', '60', '1-931-649-1804', '837 Holly Hollow Apt. 391\nLake Jordan, NJ 72639-9135', '35527787', 1, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(60, 'Braulio Torphy', '59', '1-240-514-4377', '634 Heloise Islands Apt. 056\nArifurt, ND 32850-2134', '61899252', 9, 1, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(61, 'Elwin Hansen', '60', '870-820-9358', '795 King Courts\nMelissamouth, OK 52156-5795', '63604378', 9, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(62, 'Audie Carter', '54', '+1 (936) 641-8787', '7864 Kari Plains\nDenesiktown, IA 37200-4975', '31017344', 9, 1, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(63, 'Clotilde Tromp', '43', '+1-270-222-5856', '958 Joey Dam Suite 786\nNew Cheyenne, NV 39132-2412', '99680794', 9, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(64, 'Peyton Reichert DDS', '37', '304-605-0339', '52852 Waino Trafficway Apt. 537\nImmanuelmouth, MS 41096', '86433409', 1, 1, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(65, 'Kristian Dickens', '40', '772.268.6292', '35950 Miller Squares\nNorth Aimee, MA 28019', '10131987', 1, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(66, 'Hugh Moore', '39', '+15643173768', '99106 Branson Trail\nImatown, NM 52472', '47446972', 9, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(67, 'Jalon Simonis', '29', '1-701-975-3929', '701 Rice Courts Suite 766\nThielport, ID 25473-5607', '68807989', 9, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(68, 'Raina Simonis', '59', '1-971-703-2971', '13212 Mireya Fork Apt. 247\nLake Anthonyfurt, CT 84471-5246', '99201182', 9, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(69, 'Easton Botsford', '32', '626-371-1255', '575 Keeling Course\nSouth Domenickmouth, NJ 73520', '53485584', 9, 1, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(70, 'Wilfredo Thiel', '47', '+1 (332) 706-4429', '661 Hettinger Lock\nPort Ryan, WI 46099', '35729711', 9, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(71, 'Prof. Thea Aufderhar', '22', '+14019631209', '56322 Pamela Dale Apt. 161\nJaskolskimouth, MA 30584', '14722084', 1, 1, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(72, 'Mr. Trevion Hyatt', '64', '+1 (765) 574-4786', '28578 Batz Stravenue Suite 618\nDibbertmouth, UT 68216-8007', '75557904', 1, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(73, 'Milton Bruen', '24', '(458) 422-1949', '661 Weissnat Throughway Suite 448\nEast Delmer, NM 33499', '15091991', 9, 1, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(74, 'Waylon Breitenberg III', '59', '+1-732-619-2719', '3520 King Via\nSouth Hayley, OH 13230-8632', '43349761', 9, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(75, 'Toney Gerhold', '29', '501.805.6830', '445 Lane Groves Apt. 131\nNew Lisafurt, NM 29121', '31039179', 1, 1, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(76, 'Ms. Burnice Mitchell', '18', '1-830-548-7828', '749 Abdiel Tunnel\nEphraimbury, WI 98935-0835', '64550635', 9, 1, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(77, 'Lilla Mayer', '24', '848.954.4407', '688 Alexis Meadows\nRyannmouth, NM 12668', '77371037', 1, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(78, 'Mrs. Elouise Collier', '25', '+1-424-939-9598', '943 Will Walk\nNicholausberg, MD 98552', '38552617', 9, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(79, 'Magdalen Rolfson', '38', '1-364-295-3189', '9289 Abshire Street\nNew Leofurt, NE 04473-2662', '78224058', 9, 1, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(80, 'Dr. Lambert Lindgren II', '18', '(567) 686-0444', '32657 Dimitri Oval Suite 200\nEffertzmouth, AR 50680-2580', '29304644', 9, 1, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(81, 'Jarrod Konopelski', '63', '(938) 241-2825', '812 Armani Knoll Suite 790\nEast Elvismouth, NM 43870-9392', '41253727', 9, 1, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(82, 'Dr. Ewald Skiles V', '50', '+1-689-591-7181', '5109 Alejandra Island\nLake Nikki, WY 88142', '47676391', 9, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(83, 'Prof. Manley Altenwerth', '51', '+18577933760', '708 Denesik Summit Apt. 175\nAugustamouth, SD 61185-5884', '21684137', 9, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(84, 'Armand Hettinger', '19', '+1-203-788-0335', '2238 Robel Court Suite 271\nCliftonberg, MI 68685-7227', '76407623', 1, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(85, 'Prof. Lavern Gibson', '53', '1-781-749-1253', '625 Emard Rest\nLake Emilefurt, IN 40508', '19751577', 9, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(86, 'Mr. Marcel Littel', '22', '(351) 468-0611', '222 Doyle Harbors Apt. 563\nElmerport, MT 50158', '30146368', 1, 1, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(87, 'Queenie Koss', '31', '1-743-896-5562', '60172 Bernhard Well Apt. 711\nHansenton, VA 93933-2559', '19417153', 9, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(88, 'Miss Lou Smith IV', '28', '301.668.6390', '888 Lehner Garden Apt. 410\nMarcellefurt, NJ 57012', '86154271', 9, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(89, 'Tiana Bergstrom', '25', '762.212.9926', '497 Barrows Brook Suite 268\nPort Heloise, MN 39880', '85091743', 9, 1, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(90, 'Elaina Dickens', '55', '+1 (608) 914-8201', '6097 Roberts Pass Apt. 037\nNilsbury, NM 47006', '41398808', 9, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(91, 'Katrina Thompson DDS', '33', '+12152649952', '56415 Heidi Forest\nLake Romanchester, MI 06233-3721', '15301958', 9, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(92, 'Gordon Hammes I', '25', '817.315.4059', '113 Kessler Divide Suite 944\nRyleighton, WA 19097-7276', '99355936', 1, 1, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(93, 'Joel Okuneva', '44', '+1-681-577-7689', '942 Morar Ville Apt. 023\nAndersonview, NE 45150', '21056178', 1, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(94, 'Rory Balistreri', '42', '+1.463.971.4164', '58109 Nikolas Freeway Apt. 851\nBransonstad, ND 57162', '51279857', 9, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(95, 'Gina Stroman', '22', '1-541-388-8922', '5557 Gavin Valley\nPort Cierrabury, LA 62647-7306', '80214538', 9, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(96, 'Jarret Cremin', '49', '1-714-359-6394', '442 Celestine Shore\nMarlinville, ME 34311', '61081025', 1, 1, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(97, 'Mr. Ignacio Zulauf', '54', '646.614.3391', '31758 Kassulke Track Suite 953\nKuvalisview, CA 15909', '57831615', 1, 1, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(98, 'Kariane Spinka', '56', '(281) 818-1301', '35893 Gerhold Mount\nHesselberg, MD 73365-6837', '52905486', 9, 1, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(99, 'Bernadette Schowalter', '27', '1-351-334-5999', '21316 Crooks Tunnel Suite 777\nLake Troychester, OR 15175', '61191800', 1, 8, 1, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(100, 'Wilfredo Reilly', '28', '1-386-807-2324', '32011 Mac Skyway Apt. 245\nLake Charlene, KS 98199', '20174564', 9, 8, 2, NULL, '2025-04-26 16:36:13', '2025-04-26 16:36:13'),
(101, 'Ricky Upton', '35', '1-405-287-2806', '197 Alvera Drive Suite 788\nNorth Urban, WI 30953', '19378804', 1, 1, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(102, 'Mabel Cole IV', '53', '+1 (540) 214-0862', '242 Randi Stravenue Suite 813\nGreenmouth, WV 17248', '73225312', 9, 8, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(103, 'Dorcas Keeling', '57', '+1-323-853-0922', '59098 Bradtke Throughway Suite 577\nEvertshire, ID 12770', '59194066', 9, 1, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(104, 'Monty Schmitt', '28', '+1 (612) 848-8020', '5610 Bernhard Mall Apt. 318\nSouth Gene, NC 75397', '49283391', 1, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(105, 'Erna Feil', '54', '+1-240-383-6120', '5988 Mercedes Burg\nLupeside, KS 04467-8666', '64511482', 9, 8, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(106, 'Lola Altenwerth', '59', '1-330-637-1784', '5351 Shanny Forges Suite 060\nSouth Blaiseland, UT 39053', '51797692', 9, 1, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(107, 'Dr. Berenice Bergstrom DDS', '58', '(213) 967-9098', '329 Ondricka Circles Suite 061\nLake Dahlia, NJ 21440', '12897193', 1, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(108, 'Della Hegmann', '43', '518.636.3806', '946 King Square\nAnthonystad, KY 82570-5145', '32561653', 9, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(109, 'Daphne Considine', '31', '(302) 388-1016', '672 Fahey Meadow Suite 936\nBoscoview, OK 16986', '71108876', 1, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(110, 'Domenica Johns', '34', '(865) 648-5805', '236 McGlynn Mountain\nPort Jaquan, MT 92693', '86719901', 1, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(111, 'Ms. Mckayla Satterfield', '37', '+16619805192', '99470 Dock Port\nGutkowskiport, MI 42897', '53221710', 1, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(112, 'Dr. Kole Ruecker', '43', '+19805207663', '4331 Collins Road\nPort Camilla, VT 08386', '28006337', 9, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(113, 'Mr. Ransom Nikolaus III', '29', '(442) 977-2781', '642 Pollich Viaduct Suite 119\nEast Maximillianberg, AR 60767-6104', '80728554', 9, 1, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(114, 'Rachelle Rath', '60', '1-971-237-4394', '6098 Juliet Forges\nNorth Raoulport, ME 28322', '85877871', 1, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(115, 'Mr. Keyon Lakin', '44', '913-251-9451', '702 Holly Shore Apt. 716\nWest Aurelie, CT 10824', '88676574', 1, 8, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(116, 'Bethany Grady', '46', '1-725-698-4826', '9364 Henriette Groves\nJerroldbury, ND 37431-9793', '99801422', 1, 8, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(117, 'Miss Roselyn Johns V', '29', '+1 (650) 227-6047', '54544 Johnston Dam Apt. 792\nFayberg, NV 15958-2538', '15266805', 1, 1, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(118, 'Ms. Rosie Waelchi V', '20', '+1-574-990-9347', '196 Kessler Path Apt. 768\nJosianeside, LA 26086', '54828114', 1, 1, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(119, 'Mr. Issac DuBuque', '26', '(878) 869-8857', '328 Volkman Gardens Suite 918\nLake Lee, DC 99254', '56720253', 1, 8, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(120, 'Raphael Huel', '43', '1-682-990-3992', '51482 Albin Plains Apt. 589\nMarisolview, CO 96783-0166', '50536522', 9, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(121, 'Timothy Davis', '48', '+1-667-607-4369', '875 Funk Circles Apt. 523\nNew Nichole, VA 59809', '43095837', 1, 8, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(122, 'Dillon Beer', '22', '854-204-1568', '9746 Lueilwitz Haven\nEast Heavenstad, MA 89730', '25535419', 9, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(123, 'Lindsey Denesik', '64', '301-797-1630', '333 Botsford Village Apt. 128\nBrekkeview, IN 27372-4040', '28140107', 9, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(124, 'Dr. Aubree Kerluke', '57', '1-302-977-2031', '489 Prohaska Extension\nColleenmouth, WV 92845-6691', '17639751', 1, 8, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(125, 'Wilburn Williamson', '31', '559-432-5419', '520 Ziemann Knoll\nSouth Rhiannafort, IN 52594', '21443496', 9, 1, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(126, 'Kendra Auer', '24', '+13512093932', '404 Madeline Tunnel Suite 117\nKingborough, GA 33566', '96694803', 1, 8, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(127, 'Elyssa Bechtelar', '50', '928-873-9979', '1314 Hessel Orchard\nNew Kaileehaven, NY 44308', '44512443', 9, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(128, 'Dr. Kristian Frami', '65', '(779) 630-4377', '676 Ryan Spur Apt. 957\nEast Nicoport, MT 16405-3004', '24537903', 1, 8, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(129, 'Winona Mante PhD', '18', '1-424-243-8228', '58345 Ritchie Track\nPagacton, HI 59855-2245', '12517208', 9, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(130, 'Justina Schroeder', '38', '743.813.4135', '62251 Christ Lock\nHenriville, NH 73307', '28316389', 9, 1, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(131, 'Miss Meggie Hickle', '51', '1-267-444-1155', '9843 Greenholt Track\nWest Corrine, NV 89388-5544', '37539210', 9, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(132, 'Amaya Goodwin', '44', '+15407589579', '18934 Jack Run\nGoldenhaven, MD 93169-6681', '81687552', 1, 8, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(133, 'Dr. Gay Ziemann', '52', '+12483412311', '66219 Franz Vista\nSouth Duncanbury, CT 97463-7520', '20558118', 9, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(134, 'Mr. Orrin Steuber DDS', '49', '602.989.6502', '1822 Cassin Bridge Apt. 542\nRutherfordbury, MI 35598', '66694649', 1, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(135, 'Miss Gia Breitenberg Jr.', '36', '940.535.6452', '46794 Audreanne Coves Apt. 887\nWest Isabella, WI 15855', '90809055', 1, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(136, 'Hassie Beer', '21', '(206) 509-7077', '41434 Clementine Mountains\nVolkmanton, MT 51127-0047', '29005529', 9, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(137, 'Prof. Bud McDermott PhD', '37', '(562) 710-8817', '469 Koepp Views\nTerrenceborough, MI 65779-1801', '15996906', 9, 8, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(138, 'Mr. Denis Rempel III', '65', '+1-980-452-2087', '88608 Walsh Loop Suite 230\nNew Bradly, AL 69481', '17866444', 9, 1, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(139, 'Dr. Danny Brakus I', '23', '606-985-9164', '12798 Bradly Path\nWest Myrtle, AK 41577', '42903442', 1, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(140, 'Nicklaus Breitenberg', '51', '516.947.7059', '76739 Kattie Mission Apt. 266\nEast Bud, MA 70836', '91698161', 1, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(141, 'Hailee Goldner', '36', '+1.316.671.3302', '328 Gladyce Crossroad\nSouth Santinaside, RI 51051-8277', '62239381', 1, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(142, 'Nadia Paucek', '50', '573-298-2899', '8284 Thelma Lodge\nWest Talon, DC 30407', '23881149', 9, 1, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(143, 'Prof. Kasandra Deckow', '22', '+1-209-440-7439', '405 Jonas Forks Apt. 100\nAbernathyside, MD 43042-7191', '77756556', 9, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(144, 'Amya Bartoletti III', '54', '323-744-0123', '58278 Runte Inlet\nEast Haileeville, AK 38232-0781', '41109529', 1, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(145, 'Louvenia Renner', '61', '(539) 500-7690', '3617 O\'Conner Green Apt. 402\nSouth Norris, VT 44954-5109', '92339634', 1, 1, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(146, 'Bertha Windler', '37', '+1 (248) 362-6634', '94187 Maida Forges Suite 736\nDickiberg, NH 88626-9065', '36710070', 9, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(147, 'Margot Gleichner', '56', '+1-419-901-9478', '586 Lisette Street\nPort Maxie, PA 96672', '86050329', 9, 8, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(148, 'Rhoda Bergnaum', '52', '+15405579826', '37450 Beahan Light\nBoyleville, IA 33585', '45486966', 1, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(149, 'Mr. Selmer Cartwright V', '37', '308.382.0380', '31131 Turcotte Shores\nEast Savionview, NC 14232-4149', '62041117', 1, 8, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(150, 'Matilda Kihn', '31', '445.798.1998', '851 Ben Ford Apt. 203\nJustenmouth, WA 56268-0618', '35036240', 9, 1, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(151, 'Prof. Burley Kris PhD', '36', '254-684-9061', '9448 Edmund Station Suite 199\nWest Camryn, WI 46880', '68911272', 9, 8, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(152, 'Elva Larkin', '33', '+1-682-957-4071', '266 Hailey Village Apt. 560\nWest Naomie, DC 32304-5702', '84010528', 9, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(153, 'Willow Nitzsche', '55', '+1.520.432.0568', '67671 Howell Point Apt. 923\nArlieport, NM 69139-2065', '82708888', 1, 8, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(154, 'Miss Kylee Hudson', '34', '(925) 205-4736', '3668 Williamson Springs\nLake Hipolito, SC 18606-6383', '73888744', 1, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(155, 'Alejandra Nienow', '20', '435-802-1955', '3314 Steve Viaduct\nMaramouth, VA 90349-2217', '98314890', 1, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(156, 'Mr. Rene Tromp I', '54', '(458) 712-6291', '963 Aryanna Forks Apt. 574\nFedericoside, DE 47849-5050', '35045067', 1, 8, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(157, 'Aric Tillman', '42', '559.897.4375', '9407 Gibson Lakes Suite 621\nTreutelshire, MT 31218-3843', '21376054', 1, 8, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(158, 'Nikolas Friesen I', '56', '(608) 560-5239', '77019 Kunde Trail\nTrevorburgh, AR 00211-7301', '36499495', 1, 8, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(159, 'Monica Abernathy', '50', '458.509.3469', '890 Kreiger Extensions\nKailynfort, RI 43629', '47200283', 1, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(160, 'Reta Thompson', '20', '956.480.6459', '96098 Scarlett Lodge\nLueland, WV 41169-2712', '73287390', 9, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(161, 'Rossie Toy', '21', '+1-321-750-1410', '820 Weimann Key\nHowellhaven, OK 67704-8388', '16799060', 9, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(162, 'Prof. Rick Prohaska MD', '19', '+1 (820) 353-8773', '5806 Hagenes Island\nSouth Janiehaven, LA 02761-5008', '76481227', 9, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(163, 'Desiree Medhurst', '31', '+1-240-364-2291', '2595 Domingo Drive Apt. 859\nFramibury, KY 62885-8516', '98243175', 1, 1, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(164, 'Miss Mittie Lesch', '64', '1-775-607-0060', '701 Leffler Lock Suite 662\nSouth Bryanashire, CT 20077', '24742514', 1, 8, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(165, 'Candice White', '19', '847.461.4229', '1699 Gertrude Fall Apt. 296\nFramiberg, CA 13594-0907', '98336300', 9, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(166, 'Miss Kaya Cronin DVM', '49', '+1 (580) 449-5165', '35837 Schmidt Summit\nSouth Jewellborough, SC 19103-4093', '83042415', 9, 1, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(167, 'Edmund Cormier', '30', '845-648-6930', '5619 Crist Ports\nHobartstad, NH 57241-9782', '91526832', 1, 1, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(168, 'Bette Gaylord DDS', '47', '+1 (385) 664-9564', '49673 Jacobson Islands\nWest Genesis, ND 85091', '65002131', 1, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(169, 'Halle Aufderhar II', '50', '207.935.3870', '494 Kuhlman Avenue Suite 765\nKesslerport, IA 82715', '53051314', 9, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(170, 'Grover Connelly', '58', '+1-585-859-1470', '60402 Hayes Stravenue Apt. 291\nGunnarville, NH 74145-4956', '61465003', 9, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(171, 'Schuyler Boehm', '54', '(435) 913-0196', '969 Jenkins Island Apt. 791\nNorth Jordontown, TX 35557', '10224963', 9, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(172, 'Miss Joy Lindgren DVM', '64', '272-462-7239', '7467 Harris Road\nNew Christiantown, OK 48485-9690', '32893159', 9, 1, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(173, 'Fannie Rosenbaum III', '42', '+19495047003', '67338 Taylor Station\nNew Garnetttown, VT 25084-1965', '30468405', 1, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(174, 'Mitchel Roob', '58', '(562) 438-1739', '3121 Kertzmann Isle\nFeilbury, MT 28619-6241', '85732258', 9, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(175, 'Erwin McCullough', '26', '502-816-7424', '1802 Hane Pass\nLehnerberg, PA 44965-9770', '38120005', 9, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(176, 'Dr. Marques Koss Jr.', '59', '1-260-330-9093', '890 Kaley Knolls Apt. 646\nPort Deonte, SD 20726-1639', '70069149', 9, 1, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(177, 'Dr. Garfield Gibson', '26', '+1-239-246-4948', '40358 Cary Ports Apt. 706\nNorth Goldaside, PA 95455-7549', '11529564', 9, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(178, 'Diego Abbott', '55', '(775) 958-2164', '260 Rubye Extension Suite 485\nLynchville, DC 06807-4628', '68053843', 1, 8, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(179, 'Miss Hannah Waelchi', '64', '830-372-6158', '77766 Jovanny Islands\nWest Elyseland, OH 40062-0569', '65419398', 1, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(180, 'Amie Howell', '61', '+1.272.377.0393', '52299 Schamberger Dam Apt. 437\nAlvahfurt, GA 39178', '91552328', 1, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(181, 'Eladio Kreiger', '58', '+1-640-645-2724', '913 Walter Wells Suite 409\nSchowalterville, MD 20974', '90787764', 9, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(182, 'Mollie Stehr', '56', '240-840-5631', '5531 Barton Forges Suite 679\nLake Marvin, SC 82310', '70699731', 1, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(183, 'Manuel Homenick Sr.', '42', '+1-906-795-0897', '1219 Alf Harbors\nBogisichfort, WI 76436-0554', '86080743', 1, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(184, 'Dr. Marjory Mertz', '45', '937.447.8310', '4514 Dietrich Underpass Apt. 452\nBeahanfort, NJ 33050', '97178962', 1, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(185, 'Evans Breitenberg PhD', '35', '(205) 471-3488', '3071 Robel Path Apt. 827\nEast Quintonview, WY 70002', '96109931', 1, 1, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(186, 'Vernice Borer', '18', '+1 (508) 584-1691', '490 Stark Lights Apt. 219\nAnkundinghaven, DE 17538-2934', '37619396', 1, 8, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(187, 'Hilario Lueilwitz V', '41', '(423) 338-7806', '29004 Vida Oval Apt. 353\nDavonteville, TX 70731-6892', '16669295', 1, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(188, 'Chelsea Powlowski', '34', '361.945.6376', '121 Jerde Trail Apt. 726\nNew Otho, GA 06875', '12110823', 9, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(189, 'Reyes Weimann', '55', '(325) 438-8970', '324 Orn Turnpike Suite 954\nEast Krystel, OR 92793-8377', '45494465', 9, 1, 1, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38'),
(190, 'Dr. Rashawn Hahn', '21', '+1 (660) 533-6403', '713 Stephany Stravenue\nNew Vestamouth, TN 73696-5456', '32109136', 1, 8, 2, NULL, '2025-04-26 16:38:38', '2025-04-26 16:38:38');

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

--
-- 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 `personal_access_tokens`
--

CREATE TABLE IF NOT EXISTS `personal_access_tokens` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

--
-- 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');

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `roles_name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'stu',
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `roles_name`, `user_type`, `email`, `email_verified_at`, `password`, `phone`, `remember_token`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Mustafa Adel', '', 'admin', 'mostafa@gmail.com', '2023-08-05 14:57:38', '$2y$10$loSfFoGZ6aF6IYkfFW/7DOZwOF2bXXowAxsMJzULcjuGhnHJkmKuO', '0911405218', NULL, 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 `patients`
--
ALTER TABLE `patients`
  ADD CONSTRAINT `patients_blood_id_foreign` FOREIGN KEY (`blood_id`) REFERENCES `bloods` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `patients_gender_id_foreign` FOREIGN KEY (`gender_id`) REFERENCES `genders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `patients_nationalitie_id_foreign` FOREIGN KEY (`nationalitie_id`) REFERENCES `nationalities` (`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;

