-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             12.6.0.6765
-- --------------------------------------------------------


-- Dumping structure for table nader_db.articles
CREATE TABLE IF NOT EXISTS `articles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint(20) unsigned DEFAULT NULL,
  `services_ids` text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `lat` double DEFAULT NULL,
  `lng` double DEFAULT NULL,
  `facilities` bigint(20) DEFAULT NULL,
  `visit_counts` bigint(20) DEFAULT NULL,
  `open_date` date DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `articles_category_id_article_id_index` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.articles: ~0 rows (approximately)

-- Dumping structure for table nader_db.article_descriptions
CREATE TABLE IF NOT EXISTS `article_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `address` longtext DEFAULT NULL,
  `slug` varchar(100) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `keywords` varchar(400) DEFAULT NULL,
  `article_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `article_descriptions_language_id_index` (`language_id`),
  KEY `article_descriptions_article_id_language_id_index` (`article_id`,`language_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.article_descriptions: ~0 rows (approximately)

-- Dumping structure for table nader_db.article_photos
CREATE TABLE IF NOT EXISTS `article_photos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(250) DEFAULT NULL,
  `article_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `article_photos_article_id_index` (`article_id`) USING BTREE,
  CONSTRAINT `article_photos_article_id_foreign` FOREIGN KEY (`article_id`) REFERENCES `articles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1565 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table nader_db.article_photos: ~0 rows (approximately)

-- Dumping structure for table nader_db.banners
CREATE TABLE IF NOT EXISTS `banners` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(191) DEFAULT NULL,
  `video` varchar(191) DEFAULT NULL,
  `page_url` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `banners_page_url_index` (`page_url`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.banners: ~1 rows (approximately)
INSERT INTO `banners` (`id`, `image`, `video`, `page_url`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'storage/photos/shares/header-1.svg', NULL, 'http://localhost/tabweeb/public/ar', '2024-07-30 09:07:28', '2024-07-30 09:07:28', NULL);

-- Dumping structure for table nader_db.banner_descriptions
CREATE TABLE IF NOT EXISTS `banner_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `btn_name` text DEFAULT NULL,
  `banner_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `banner_descriptions_banner_id_index` (`banner_id`),
  KEY `banner_descriptions_language_id_index` (`language_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.banner_descriptions: ~2 rows (approximately)
INSERT INTO `banner_descriptions` (`id`, `title`, `description`, `btn_name`, `banner_id`, `language_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(5, 'شركة تبويب لتقنية المعلومات', '<div class="p my-4 ">تبويب مؤسسة سعودية متخصصة في مجال تصميم البرمجيات الخاصة وحلول الفوترة الإلكترونية ونظم المال والأعمال وتصميم مواقع الويب وتطبيقات الهواتف الذكية.2</div>', 'اتصل بنا', 1, 1, NULL, NULL, NULL),
	(6, 'Tabweeb for information Technology', '<p>Taboo is a Saudi institution specialized in designing special software, electronic billing solutions, financial and business systems, designing websites, and smart phone applications2.</p>', 'Contact us', 1, 2, NULL, NULL, NULL);

-- Dumping structure for table nader_db.bookings
CREATE TABLE IF NOT EXISTS `bookings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `phone` varchar(15) NOT NULL,
  `email` varchar(50) NOT NULL,
  `agency` varchar(50) NOT NULL,
  `iata_no` varchar(50) DEFAULT NULL,
  `country_id` bigint(20) unsigned NOT NULL,
  `hotel_data` text NOT NULL,
  `booking_data` text NOT NULL,
  `services` text DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table nader_db.bookings: 57 rows
INSERT INTO `bookings` (`id`, `name`, `phone`, `email`, `agency`, `iata_no`, `country_id`, `hotel_data`, `booking_data`, `services`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'Ammar', '0501231234', 'ammarsayed83@gmail.com', 'Test', '503135443541311818181', 1, '{"cities":["mecca","madina"],"check_in":["2022-11-05","2022-11-13"],"check_out":["2022-11-08","2022-11-15"]}', '{"participants_no":"100","rooms_type":{"single":"4","double":"4","triple":"6","quadruple":"10","quintuple":"6"}}', '{"3":[9,8,7],"2":[6,5,4],"1":[3,2,1]}', NULL, '2022-10-20 15:46:59', '2022-11-20 14:49:46', '2022-11-20 14:49:46'),
	(2, 'Ammar2', '0501233456', 'ammarsayed888@gmail.com', 'Test', '111', 2, '{"cities":["mecca","madina"],"check_in":["2022-11-05","2022-11-13"],"check_out":["2022-11-08","2022-11-15"]}', '{"participants_no":"100","rooms_type":{"single":"0","double":"0","triple":"0","quadruple":"0","quintuple":"20"}}', '{"3":[9,8,7],"2":[6,5,4],"1":[3,2,1]}', 'Test tEst', '2022-10-20 15:52:44', '2022-11-20 14:49:46', '2022-11-20 14:49:46'),
	(3, 'sayed', '0502354488', 'ammarh32@gmail.com', 'test test', '51611518', 1, '{"cities":["mecca","madina"],"check_in":["2022-11-05","2022-11-13"],"check_out":["2022-11-08","2022-11-15"]}', '{"participants_no":"105","rooms_type":{"single":"0","double":"0","triple":"0","quadruple":"5","quintuple":"17"}}', '{"3":[9,8,7],"2":[6,5,4],"1":[3,2,1]}', NULL, '2022-10-20 15:56:36', '2022-11-20 14:49:46', '2022-11-20 14:49:46'),
	(4, 'تيست', '0502454488', 'mkladnmg@fda.com', 'asdfij', '531351351', 15, '{"cities":["mecca","madina"],"check_in":["2022-11-05","2022-11-13"],"check_out":["2022-11-08","2022-11-15"]}', '{"participants_no":"20","rooms_type":{"single":"4","double":"0","triple":"1","quadruple":"2","quintuple":"1"}}', '{"3":[9,8,7],"2":[6,5,4],"1":[3,2,1]}', 'تيست تيست تيست تيست تيست تيست تيست تيست', '2022-10-20 16:08:06', '2022-11-20 14:49:46', '2022-11-20 14:49:46'),
	(5, 'admin', '05959552752', 'asad@nesma.com', 'rawahel', '05959552752', 1, '{"cities":["mecca","madina"],"check_in":["2022-11-05","2022-11-13"],"check_out":["2022-11-08","2022-11-15"]}', '{"participants_no":"40","rooms_type":{"single":"0","double":"0","triple":"0","quadruple":"10","quintuple":"0"}}', '{"3":[9,8,7],"2":[6,5,4],"1":[3,2,1]}', 'test', '2022-10-24 09:03:12', '2022-11-20 14:49:46', '2022-11-20 14:49:46'),
	(6, 'admin1', '05959552752', 'asad@nesma.com', 'rawahel2', '05959552752', 1, '{"cities":["mecca","madina"],"check_in":["2022-11-05","2022-11-13"],"check_out":["2022-11-08","2022-11-15"]}', '{"participants_no":"34","rooms_type":{"single":"6","double":"3","triple":"1","quadruple":"1","quintuple":"3"}}', '{"3":[9,8,7],"2":[6,5,4],"1":[3,2,1]}', 'test-2', '2022-10-24 09:05:03', '2022-11-20 14:49:46', '2022-11-20 14:49:46'),
	(7, 'محمد سلام', '0533333333', 'mosallam@gmail.com', 'وكالة اليوم هوست', '1234', 2, '{"cities":["mecca","madina"],"check_in":["2022-11-05","2022-11-13"],"check_out":["2022-11-08","2022-11-15"]}', '{"participants_no":"30","rooms_type":{"single":"2","double":"2","triple":"2","quadruple":"2","quintuple":"2"}}', '{"3":[9,8,7],"2":[6,5,4],"1":[3,2,1]}', NULL, '2022-10-31 18:06:05', '2022-10-31 18:07:15', '2022-10-31 18:07:15'),
	(8, 'محمد سلام', '0533333333', 'mosallam@gmail.com', 'وكالة اليوم هوست', '1234', 2, '{"cities":["mecca","madina"],"check_in":["2022-11-05","2022-11-13"],"check_out":["2022-11-08","2022-11-15"]}', '{"participants_no":"30","rooms_type":{"single":"2","double":"2","triple":"2","quadruple":"2","quintuple":"2"}}', '{"3":[9,8,7],"2":[6,5,4],"1":[3,2,1]}', NULL, '2022-10-31 18:08:46', '2022-11-20 14:49:46', '2022-11-20 14:49:46'),
	(9, 'Abdullah Thabet', '0543605073', 'abdullahr999@gmail.com', 'test', NULL, 1, '{"cities":["mecca","madina"],"check_in":["2022-11-05","2022-11-13"],"check_out":["2022-11-08","2022-11-15"]}', '{"participants_no":"2","rooms_type":{"single":"2","double":"0","triple":"0","quadruple":"0","quintuple":"0"}}', '{"3":[9,8,7],"2":[6,5,4],"1":[3,2,1]}', NULL, '2022-11-01 08:46:02', '2022-11-20 14:49:46', '2022-11-20 14:49:46'),
	(10, 'محمد سلام', '0533333333', 'mosallam@gmail.com', 'وكالة اليوم هوست', '345435', 2, '{"cities":["mecca","madina"],"check_in":["2022-11-01","2022-11-06"],"check_out":["2022-11-03","2022-11-08"]}', '{"participants_no":"2","rooms_type":{"single":"0","double":"1","triple":"0","quadruple":"0","quintuple":"0"}}', '{"3":[9,8,7],"2":[6,5,4],"1":[3,2,1]}', NULL, '2022-11-01 17:49:32', '2022-11-20 14:49:46', '2022-11-20 14:49:46'),
	(11, 'محمد سلام', '0533333333', 'mosallam@gmail.com', 'وكالة اليوم هوست', '234324', 2, '{"cities":["mecca","madina"],"check_in":["2022-11-01","2022-11-06"],"check_out":["2022-11-03","2022-11-08"]}', '{"participants_no":"2","rooms_type":{"single":"2","double":"0","triple":"0","quadruple":"0","quintuple":"0"}}', '{"3":[9,8,7],"2":[6,5,4],"1":[3,2,1]}', 'التفاصيل', '2022-11-01 17:51:51', '2022-11-20 14:49:46', '2022-11-20 14:49:46'),
	(12, 'Abdullah Thabet', '0543605073', 'abdullahr999@gmail.com', 'eeew', NULL, 1, '{"cities":["mecca","madina"],"check_in":["2022-11-01","2022-11-16"],"check_out":["2022-11-16","2022-11-25"]}', '{"participants_no":"200","rooms_type":{"single":"4","double":"5","triple":"5","quadruple":"4","quintuple":"31"}}', '{"3":[9,8,7],"2":[6,5,4],"1":[3,2,1]}', 'test test test test test test test', '2022-11-02 09:12:38', '2022-11-20 14:49:46', '2022-11-20 14:49:46'),
	(13, 'Abdullah Thabet', '0543605073', 'abdullahr999@gmail.com', 'منتنمتمنمتن', NULL, 1, '{"cities":["mecca"],"check_in":["2022-11-02"],"check_out":["2022-11-08"]}', '{"participants_no":"1","rooms_type":{"single":"1","double":"0","triple":"0","quadruple":"0","quintuple":"0"}}', '{"3":[9,8,7],"2":[6,5,4],"1":[3,2,1]}', 'خحنننكم', '2022-11-02 10:07:40', '2022-11-20 14:49:46', '2022-11-20 14:49:46'),
	(14, 'ssssssss', '0512345678', 'admin@admin.com', 'ssssssss', '6555', 2, '{"cities":["madina","madina"],"check_in":["2022-11-02","2022-11-01"],"check_out":["2022-11-10","2022-11-20"]}', '{"participants_no":"10","rooms_type":{"single":"2","double":"4","triple":"0","quadruple":"0","quintuple":"0"}}', '{"3":[9,8,7],"2":[6,5,4],"1":[3,2,1]}', NULL, '2022-11-02 12:10:45', '2022-11-02 12:11:04', '2022-11-02 12:11:04'),
	(15, 'محمد سلام', '0533333333', 'mosallam@gmail.com', 'وكالة اليوم هوست', '234324', 2, '{"cities":["1"],"check_in":["2022-11-02"],"check_out":["2022-11-04"]}', '{"participants_no":"30","rooms_type":{"single":"2","double":"2","triple":"2","quadruple":"2","quintuple":"2"}}', '{"3":[9,8,7],"2":[6,5,4],"1":[3,2,1]}', 'لا توجد ملاحظات', '2022-11-02 23:56:29', '2022-11-20 14:49:46', '2022-11-20 14:49:46'),
	(16, 'محمد سلام', '0533333333', 'mosallam@gmail.com', 'وكالة اليوم هوست', '345435', 2, '{"cities":["1"],"check_in":["2022-11-02"],"check_out":["2022-11-05"]}', '{"participants_no":"30","rooms_type":{"single":"2","double":"2","triple":"2","quadruple":"2","quintuple":"2"}}', '{"3":[9],"2":[6]}', 'ليس هناك ملاحظات', '2022-11-03 00:24:24', '2022-11-20 14:49:46', '2022-11-20 14:49:46'),
	(17, 'Abdullah Thabet', '0543605073', 'abdullahr999@gmail.com', 'sddfsdfsdf', NULL, 1, '{"cities":["1"],"check_in":["2022-11-03"],"check_out":["2022-11-17"]}', '{"participants_no":"200","rooms_type":{"single":"1","double":"7","triple":"41","quadruple":"8","quintuple":"6"}}', '{"3":[13,12]}', 'Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test Test', '2022-11-03 08:17:27', '2022-11-20 14:49:46', '2022-11-20 14:49:46'),
	(18, 'Abdullah Thabet', '0543605073', 'abdullahr999@gmail.com', 'ghfhfghfghfgh', NULL, 1, '{"cities":["1","6","7"],"check_in":["2022-11-03","2022-11-16","2022-11-23"],"check_out":["2022-11-11","2022-11-21","2022-11-30"]}', '{"participants_no":"100","rooms_type":{"single":"5","double":"15","triple":"10","quadruple":"5","quintuple":"3"}}', '{"3":[13,11]}', 'TESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTEST', '2022-11-03 08:34:42', '2022-11-20 14:49:46', '2022-11-20 14:49:46'),
	(19, 'Abdullah Thabet', '0543605073', 'abdullahr999@gmail.com', 'gfgdggfgf', NULL, 1, '{"cities":["1"],"check_in":["2022-11-04"],"check_out":["2022-11-24"]}', '{"participants_no":"10","rooms_type":{"single":"0","double":"0","triple":"0","quadruple":"0","quintuple":"2"}}', '{"3":[12,11]}', 'TESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTESTTEST', '2022-11-03 08:36:05', '2022-11-20 14:49:46', '2022-11-20 14:49:46'),
	(20, 'Abdullah Thabet333', '0543605073', 'abdullahr999@gmail.com', 'dfvdfgdf', NULL, 1, '{"cities":["1"],"check_in":["2022-11-04"],"check_out":["2022-11-23"]}', '{"participants_no":"10","rooms_type":{"single":"0","double":"0","triple":"0","quadruple":"0","quintuple":"2"}}', '{"3":[12]}', 'test', '2022-11-03 08:40:50', '2022-11-20 14:49:46', '2022-11-20 14:49:46'),
	(21, 'محمد سلام', '0533333333', 'mosallam@gmail.com', 'وكالة اليوم هوست', '123213', 2, '{"cities":["1"],"check_in":["2022-11-03"],"check_out":["2022-11-07"]}', '{"participants_no":"30","rooms_type":{"single":"2","double":"2","triple":"2","quadruple":"2","quintuple":"2"}}', '{"3":[13,12,11]}', 'لا توجد ملاحظات', '2022-11-03 11:22:17', '2022-11-20 14:49:46', '2022-11-20 14:49:46'),
	(22, 'Abdullah Thabet', '0543605073', 'abdullahr999@gmail.com', 'ببلييبللبي', NULL, 1, '{"cities":["1"],"check_in":["2022-11-03"],"check_out":["2022-11-17"]}', '{"participants_no":"10","rooms_type":{"single":"0","double":"0","triple":"0","quadruple":"0","quintuple":"2"}}', '{"3":[12,11]}', NULL, '2022-11-03 12:15:37', '2022-11-20 14:49:46', '2022-11-20 14:49:46'),
	(23, 'Abdullah Thabet', '0543605073', 'abdullahr999@gmail.com', 'fdgfdg', NULL, 1, '{"cities":["1"],"check_in":["2022-11-06"],"check_out":["2022-11-24"]}', '{"participants_no":"10","rooms_type":{"single":"0","double":"0","triple":"0","quadruple":"0","quintuple":"2"}}', '{"3":[13,12]}', NULL, '2022-11-06 08:21:50', '2022-11-20 14:49:46', '2022-11-20 14:49:46'),
	(24, 'hassen', '0543404841', 'admin@admin.com', 'jhghgfgfdghf', '3423453245', 1, '{"cities":["1"],"check_in":["2022-11-16"],"check_out":["2022-11-30"]}', '{"participants_no":"50","rooms_type":{"single":"5","double":"0","triple":"2","quadruple":"6","quintuple":"3"}}', '{"3":[13,12,11]}', NULL, '2022-11-13 10:00:08', '2022-11-20 14:49:46', '2022-11-20 14:49:46'),
	(25, 'Abdullah Thabet', '0543605073', 'abdullahr999@gmail.com', 'dfsdf', '445555', 1, '{"cities":["1"],"check_in":["2022-11-13"],"check_out":["2022-11-23"]}', '{"participants_no":"10","rooms_type":{"single":"0","double":"0","triple":"0","quadruple":"0","quintuple":"2"}}', '{"3":[12]}', 'fgfdgfdg', '2022-11-13 15:23:38', '2022-11-20 14:49:46', '2022-11-20 14:49:46'),
	(26, 'حسن -تجربة 2', '05959552752', 'hasan@mawaddah.com.sa', 'وكالة تجربة', '05959552752', 1, '{"cities":["1"],"check_in":["2022-11-20"],"check_out":["2022-11-22"]}', '{"participants_no":"34","rooms_type":{"single":"5","double":"4","triple":"7","quadruple":"0","quintuple":"0"}}', '{"3":[13]}', NULL, '2022-11-20 14:24:37', '2022-11-20 14:24:37', NULL),
	(27, 'حسن -تجربة 2', '05959552752', 'hasan@mawaddah.com.sa', 'وكالة تجربة', '05959552752', 1, '{"cities":["1"],"check_in":["2022-11-20"],"check_out":["2022-11-22"]}', '{"participants_no":"2","rooms_type":{"single":"2","double":"0","triple":"0","quadruple":"0","quintuple":"0"}}', '{"3":[12,11]}', 'بالصحة والهنا', '2022-11-20 14:32:44', '2022-11-20 14:32:44', NULL),
	(28, 'wasim', '7483242209', 'wasimm48@gmail.com', 'Noo', NULL, 3, '{"cities":["1"],"check_in":["2022-12-14"],"check_out":["2022-12-19"]}', '{"participants_no":"2","rooms_type":{"single":"0","double":"1","triple":"0","quadruple":"0","quintuple":"0"}}', '{"3":[13]}', 'We will be reaching by 5 PM on Dec 14, 2 adults + 1 (5 year kid), need stay for 5 days.', '2022-11-23 21:55:40', '2022-11-23 21:55:40', NULL),
	(29, 'Siraj Ahmad Alokozay', '0093700700123', 'info@alokozaytravel.com', 'Alokozay Tourist & Travel Agency', NULL, 1, '{"cities":["1"],"check_in":["2023-01-28"],"check_out":["2023-02-10"]}', '{"participants_no":"9","rooms_type":{"single":"0","double":"1","triple":"1","quadruple":"1","quintuple":"0"}}', '[]', NULL, '2022-12-26 16:48:01', '2022-12-26 16:48:01', NULL),
	(30, 'سماح', '0547439771', 'Drsamah3@gmail.com', 'شخصى', NULL, 197, '{"cities":["1"],"check_in":["2023-03-24"],"check_out":["2023-03-25"]}', '{"participants_no":"5","rooms_type":{"single":"0","double":"1","triple":"1","quadruple":"0","quintuple":"0"}}', '[]', NULL, '2023-01-04 17:24:24', '2023-01-04 17:24:24', NULL),
	(31, 'sameh abdellah', '971567853231', 'sameh.abdellah@dwtravel.ae', 'DW TRVAVEL', '18039902', 237, '{"cities":["1"],"check_in":["2023-02-03"],"check_out":["2023-02-05"]}', '{"participants_no":"3","rooms_type":{"single":"0","double":"0","triple":"1","quadruple":"0","quintuple":"0"}}', '{"3":[11]}', '2 ADULT 1 CHILD (', '2023-01-27 21:02:42', '2023-01-27 21:02:42', NULL),
	(32, 'basheer', '00971504686514', 'mr.shaikhbasheer@gmail.com', 'personal', NULL, 237, '{"cities":["1"],"check_in":["2023-04-17"],"check_out":["2023-04-22"]}', '{"participants_no":"3","rooms_type":{"single":"0","double":"0","triple":"1","quadruple":"0","quintuple":"0"}}', '{"3":[11]}', NULL, '2023-02-06 20:46:54', '2023-02-06 20:46:54', NULL),
	(33, 'norizan', '601156260767', 'norizanmohd68@gmail.com', 'AQ Travel', NULL, 136, '{"cities":["1"],"check_in":["2023-08-05"],"check_out":["2023-08-11"]}', '{"participants_no":"50","rooms_type":{"single":"0","double":"0","triple":"0","quadruple":"10","quintuple":"2"}}', '{"3":[13,12,11]}', NULL, '2023-02-09 18:35:33', '2023-02-09 18:35:33', NULL),
	(34, 'Muhammad Kamran', '08062452681', 'mkamran205@gmail.com', 'Nil', NULL, 112, '{"cities":["1"],"check_in":["2023-04-06"],"check_out":["2023-04-13"]}', '{"participants_no":"3","rooms_type":{"single":"0","double":"0","triple":"1","quadruple":"0","quintuple":"0"}}', '{"3":[11]}', 'We are two people with 1 year old baby. A room for 2 people or 3 people will be sufficient. Please inform about per night rates. Thank you.', '2023-02-11 17:04:51', '2023-02-11 17:04:51', NULL),
	(35, 'Saadiq', '0832988158', 'saadiqj@gmail.com', 'Private', NULL, 209, '{"cities":["1"],"check_in":["2023-12-19"],"check_out":["2023-12-28"]}', '{"participants_no":"4","rooms_type":{"single":"0","double":"2","triple":"0","quadruple":"0","quintuple":"0"}}', '{"3":[11]}', NULL, '2023-02-12 22:42:20', '2023-02-12 22:42:20', NULL),
	(36, 'sharique ammar', '7999184454', 'shariqueammar.rehmani@gmail.com', 'Rehmaniya Tours & Travels', '14378766', 103, '{"cities":["1"],"check_in":["2023-07-03"],"check_out":["2023-07-23"]}', '{"participants_no":"50","rooms_type":{"single":"0","double":"2","triple":"2","quadruple":"10","quintuple":"0"}}', '{"3":[13,12,11]}', NULL, '2023-02-18 08:34:29', '2023-02-18 08:34:29', NULL),
	(37, 'Mona', '0781798386', 'thejukar@hotmail.com', 'Nasa', NULL, 214, '{"cities":["1"],"check_in":["2023-07-24"],"check_out":["2023-08-11"]}', '{"participants_no":"6","rooms_type":{"single":"0","double":"3","triple":"0","quadruple":"0","quintuple":"0"}}', '{"3":[12]}', NULL, '2023-02-28 15:20:44', '2023-02-28 15:20:44', NULL),
	(38, 'testsssss', '0565748697', 'ssss@ddd.dddd', 'qqqqq', '123321', 1, '{"cities":["1"],"check_in":["2023-03-01"],"check_out":["2023-03-15"]}', '{"participants_no":"10","rooms_type":{"single":"0","double":"0","triple":"0","quadruple":"0","quintuple":"0"}}', '{"3":[13]}', 'xzzxz', '2023-03-13 17:42:34', '2023-03-13 17:42:34', NULL),
	(39, 'ِاحمد محمود', '00201002724013', 'ahmed.sebak90@gmail.com', 'personal', NULL, 66, '{"cities":["1"],"check_in":["2023-04-17"],"check_out":["2023-04-21"]}', '{"participants_no":"2","rooms_type":{"single":"0","double":"1","triple":"0","quadruple":"0","quintuple":"0"}}', '{"3":[13,11]}', NULL, '2023-03-15 13:22:17', '2023-03-15 13:22:17', NULL),
	(40, 'Alsayed Alrawy', '0096566623157', 'elrawy10@gmail.com', 'نفسي', NULL, 121, '{"cities":["1"],"check_in":["2023-03-26"],"check_out":["2023-03-29"]}', '{"participants_no":"4","rooms_type":{"single":"0","double":"0","triple":"0","quadruple":"1","quintuple":"0"}}', '[]', NULL, '2023-03-21 12:08:47', '2023-03-21 12:08:47', NULL),
	(41, 'M.Ikram', '0507827023', 'ikramniaz@gmail.com', 'personal', NULL, 237, '{"cities":["1"],"check_in":["2023-03-27"],"check_out":["2023-03-29"]}', '{"participants_no":"2","rooms_type":{"single":"0","double":"0","triple":"0","quadruple":"0","quintuple":"0"}}', '{"3":[11]}', 'only seri', '2023-03-23 02:04:16', '2023-03-23 02:04:16', NULL),
	(42, 'علي', '0561094577', 'mohamd.habib054@gmail.com', 'الهدية', NULL, 152, '{"cities":["1"],"check_in":["2023-03-27"],"check_out":["2023-03-31"]}', '{"participants_no":"1","rooms_type":{"single":"1","double":"0","triple":"0","quadruple":"0","quintuple":"0"}}', '[]', NULL, '2023-03-26 11:36:57', '2023-03-26 11:36:57', NULL),
	(43, 'محمد بن سعيد الشهيمي', '0096895388505', 'mohd.alshohimy@gmail.com', 'معتمر', '1509', 169, '{"cities":["1"],"check_in":["2023-04-13"],"check_out":["2023-04-16"]}', '{"participants_no":"2","rooms_type":{"single":"0","double":"1","triple":"0","quadruple":"0","quintuple":"0"}}', '[]', NULL, '2023-03-26 19:49:03', '2023-03-26 19:49:03', NULL),
	(44, 'Mohammed Said Alshohimy', '0096895388505', 'mohd.alshohimy@gmail.com', 'Oman', '00968', 169, '{"cities":["1"],"check_in":["2023-04-13"],"check_out":["2023-04-16"]}', '{"participants_no":"2","rooms_type":{"single":"0","double":"1","triple":"0","quadruple":"0","quintuple":"0"}}', '[]', NULL, '2023-03-26 19:52:33', '2023-03-26 19:52:33', NULL),
	(45, 'Souad el mellali el karchi', '212654669256', 'anita.panorama1@gmail.com', 'Nasma', NULL, 152, '{"cities":["1"],"check_in":["2023-03-29"],"check_out":["2023-04-03"]}', '{"participants_no":"2","rooms_type":{"single":"0","double":"1","triple":"0","quadruple":"0","quintuple":"0"}}', '[]', NULL, '2023-03-27 06:32:18', '2023-03-27 06:32:18', NULL),
	(46, 'Souad el mellali el karchi', '212654669256', 'anita.panorama1@gmail.com', 'Nasma', NULL, 76, '{"cities":["1"],"check_in":["2023-03-29"],"check_out":["2023-04-03"]}', '{"participants_no":"2","rooms_type":{"single":"0","double":"1","triple":"0","quadruple":"0","quintuple":"0"}}', '[]', NULL, '2023-03-27 06:40:22', '2023-03-27 06:40:22', NULL),
	(47, 'Mohamed', '00212661362854', 'medarouy1999@gmail.com', 'Moi même', NULL, 152, '{"cities":["1"],"check_in":["2023-05-08"],"check_out":["2023-05-23"]}', '{"participants_no":"1","rooms_type":{"single":"1","double":"0","triple":"0","quadruple":"0","quintuple":"0"}}', '[]', NULL, '2023-04-08 18:20:21', '2023-04-08 18:20:21', NULL),
	(48, 'Mohamed', '00212661362854', 'medarouy1999@gmail.com', 'Moi même', NULL, 152, '{"cities":["1"],"check_in":["2023-05-08"],"check_out":["2023-05-23"]}', '{"participants_no":"1","rooms_type":{"single":"1","double":"0","triple":"0","quadruple":"0","quintuple":"0"}}', '[]', NULL, '2023-04-08 18:22:37', '2023-04-08 18:22:37', NULL),
	(49, 'Mostafa Shazly Salem', '00201006622916', 'mosshazly@gmail.com', 'مصر', NULL, 66, '{"cities":["1"],"check_in":["2023-05-24"],"check_out":["2023-05-27"]}', '{"participants_no":"1","rooms_type":{"single":"1","double":"0","triple":"0","quadruple":"0","quintuple":"0"}}', '[]', NULL, '2023-04-23 09:56:09', '2023-04-23 09:56:09', NULL),
	(50, 'admin', '05959552752', 'hasan@mawaddah.com.sa', 'وكالة تجربة', '05959552752', 197, '{"cities":["1"],"check_in":["2023-05-02"],"check_out":["2023-05-02"]}', '{"participants_no":"12","rooms_type":{"single":"1","double":"0","triple":"1","quadruple":"2","quintuple":"0"}}', '{"3":[13]}', NULL, '2023-05-01 14:59:22', '2023-05-01 14:59:22', NULL),
	(51, 'GET A GUOTE', '0588874511', 'asad@nesma.com', 'وكالة تجربة', '05959552752', 94, '{"cities":["1"],"check_in":["2023-05-12"],"check_out":["2023-05-12"]}', '{"participants_no":"40","rooms_type":{"single":"5","double":"5","triple":"4","quadruple":"2","quintuple":"1"}}', '{"3":[13,12,11]}', 'لمين وصلت الرسالة ؟', '2023-05-03 10:46:06', '2023-05-03 10:46:06', NULL),
	(52, 'get a goute', '0567897811', 'asad@nesma.com', 'وكالة تجربة fdfdfd', '05959552752', 1, '{"cities":["1"],"check_in":["2023-05-05"],"check_out":["2023-05-19"]}', '{"participants_no":"10","rooms_type":{"single":"1","double":"2","triple":"0","quadruple":"0","quintuple":"1"}}', '{"3":[13,12,11]}', 'بعد تعديل الايميل', '2023-05-03 10:59:27', '2023-05-03 10:59:27', NULL),
	(53, 'Namma Hotel', '0567897811', 'asad@nesma.com', 'وكالة تجربة hhhhhhhhhhhhhhh', '05959552752', 2, '{"cities":["1"],"check_in":["2023-05-11"],"check_out":["2023-05-12"]}', '{"participants_no":"10","rooms_type":{"single":"0","double":"0","triple":"0","quadruple":"0","quintuple":"2"}}', '{"3":[13,12,11]}', NULL, '2023-05-03 12:19:18', '2023-05-03 12:19:18', NULL),
	(54, 'Namma Hotel', '05959552752', 'asad@nesma.com', 'وكالة تجربة hhhhhhhhhhhhhhh', '05959552752', 2, '{"cities":["1"],"check_in":["2023-05-12"],"check_out":["2023-05-18"]}', '{"participants_no":"12","rooms_type":{"single":"0","double":"1","triple":"0","quadruple":"0","quintuple":"2"}}', '[]', NULL, '2023-05-03 12:23:42', '2023-05-03 12:23:42', NULL),
	(55, 'Fatima', '966599444279', 'fatimah@nesma.com', 'Nesma', NULL, 2, '{"cities":["1"],"check_in":["2023-05-08"],"check_out":["2023-05-08"]}', '{"participants_no":"1","rooms_type":{"single":"1","double":"0","triple":"0","quadruple":"0","quintuple":"0"}}', '{"3":[13,12]}', NULL, '2023-05-07 08:34:00', '2023-05-07 08:34:00', NULL),
	(57, 'Abdullah Thabet', '0543605073', 'abdullahr999@gmail.com', 'gfgdggfgf', '445555', 197, '{"cities":["1"],"check_in":["2023-05-01"],"check_out":["2023-05-23"]}', '{"participants_no":"10","rooms_type":{"single":"2","double":"1","triple":"2","quadruple":"0","quintuple":"0"}}', '{"3":[13]}', 'dfdgf', '2023-05-07 12:35:29', '2023-05-07 12:35:29', NULL),
	(58, 'admin1', '0567897811', 'asad@nesma.com', 'وكالة تجربة hh', '05959552752', 2, '{"cities":["1"],"check_in":["2023-05-10"],"check_out":["2023-05-19"]}', '{"participants_no":"40","rooms_type":{"single":"2","double":"2","triple":"2","quadruple":"2","quintuple":"4"}}', '{"3":[13,12,11]}', NULL, '2023-05-07 14:55:06', '2023-05-07 14:55:06', NULL);

-- Dumping structure for table nader_db.booking_details
CREATE TABLE IF NOT EXISTS `booking_details` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table nader_db.booking_details: ~1 rows (approximately)
INSERT INTO `booking_details` (`id`) VALUES
	(1);

-- Dumping structure for table nader_db.booking_detail_descriptions
CREATE TABLE IF NOT EXISTS `booking_detail_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title_1` varchar(100) NOT NULL,
  `title_2` varchar(100) NOT NULL,
  `title_3` varchar(100) NOT NULL,
  `title_4` varchar(100) NOT NULL,
  `title_5` varchar(100) NOT NULL,
  `booking_detail_id` bigint(20) unsigned NOT NULL,
  `language_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `booking_detail_descriptions_booking_detail_id_language_id_index` (`booking_detail_id`,`language_id`),
  CONSTRAINT `booking_detail_descriptions_booking_detail_id_foreign` FOREIGN KEY (`booking_detail_id`) REFERENCES `booking_details` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table nader_db.booking_detail_descriptions: ~2 rows (approximately)
INSERT INTO `booking_detail_descriptions` (`id`, `title_1`, `title_2`, `title_3`, `title_4`, `title_5`, `booking_detail_id`, `language_id`) VALUES
	(13, 'سعة الغرفة (1) شخص', 'سعة الغرفة (2) شخص', 'سعة الغرفة (3) أفراد', 'سعة الغرفة (4) أشخاص', 'سعة الغرفة (5) أشخاص', 1, 1),
	(14, 'The capacity of the room (1) person', 'The capacity of the room (2) persons', 'The capacity of the room (3) persons', 'The capacity of the room (4) persons', 'The capacity of the room (5) persons', 1, 2);

-- Dumping structure for table nader_db.careers
CREATE TABLE IF NOT EXISTS `careers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(250) DEFAULT NULL,
  `image` varchar(500) DEFAULT NULL,
  `image2` varchar(500) DEFAULT NULL,
  `no_followers` varchar(50) DEFAULT NULL,
  `no_posts` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.careers: ~3 rows (approximately)
INSERT INTO `careers` (`id`, `type`, `image`, `image2`, `no_followers`, `no_posts`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(9, 'الرئيسي-->الرئيسي-2', 'storage/photos/shares/3.jpg', 'storage/photos/shares/avata13.png', 'عدد المتابعين', 'عدد المنشورات', '2024-11-16 17:30:44', '2024-11-16 17:30:44', NULL),
	(10, 'فرعي ثاني-->فرعي ثاني-1', 'storage/photos/shares/370632485_122126490164002835_7814470262877211187_n.jpg', 'storage/photos/shares/ceo-1.jpg', '22', '33', '2024-11-16 17:32:06', '2024-11-16 17:32:06', NULL),
	(11, 'فرعي أول-->فرعي اول -2', 'storage/photos/shares/3.jpg', 'storage/photos/shares/avata13.png', '15', '16', '2024-11-16 17:33:16', '2024-11-16 17:33:16', NULL);

-- Dumping structure for table nader_db.career_descriptions
CREATE TABLE IF NOT EXISTS `career_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `career_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.career_descriptions: ~6 rows (approximately)
INSERT INTO `career_descriptions` (`id`, `title`, `description`, `career_id`, `language_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(19, 'اسم المجتمع التفاعلي (Arabic)', '<p><label>وصف المجتمع التفاعلي (Arabic)</label></p>\r\n<div id="mceu_16" class="mce-tinymce mce-container mce-panel" tabindex="-1" role="application">\r\n<div id="mceu_16-body" class="mce-container-body mce-stack-layout">\r\n<div id="mceu_17" class="mce-top-part mce-container mce-stack-layout-item mce-first">\r\n<div id="mceu_17-body" class="mce-container-body">\r\n<div id="mceu_18" class="mce-container mce-menubar mce-toolbar mce-first" role="menubar">&nbsp;</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>', 9, 1, NULL, NULL, NULL),
	(20, 'اسم المجتمع التفاعلي (English)', '<p><label>وصف المجتمع التفاعلي (English)</label></p>\r\n<div id="mceu_55" class="mce-tinymce mce-container mce-panel" tabindex="-1" role="application">\r\n<div id="mceu_55-body" class="mce-container-body mce-stack-layout">\r\n<div id="mceu_56" class="mce-top-part mce-container mce-stack-layout-item mce-first">\r\n<div id="mceu_56-body" class="mce-container-body">\r\n<div id="mceu_57" class="mce-container mce-menubar mce-toolbar mce-first" role="menubar">&nbsp;</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>', 9, 2, NULL, NULL, NULL),
	(21, '111', '<p>33556</p>', 10, 1, NULL, NULL, NULL),
	(22, '222', '<p>3335</p>', 10, 2, NULL, NULL, NULL),
	(23, '222', '<p>3355</p>', 11, 1, NULL, NULL, NULL),
	(24, '333', '<p>6688</p>', 11, 2, NULL, NULL, NULL);

-- Dumping structure for table nader_db.career_photos
CREATE TABLE IF NOT EXISTS `career_photos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(250) DEFAULT NULL,
  `career_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `career_photos_career_id_foreign` (`career_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.career_photos: ~11 rows (approximately)
INSERT INTO `career_photos` (`id`, `image`, `career_id`, `created_at`, `updated_at`) VALUES
	(45, 'storage/photos/shares/800px-Sunflower_from_Silesia2.jpg', 12, NULL, NULL),
	(46, 'storage/photos/shares/3.jpg', 12, NULL, NULL),
	(47, 'storage/photos/shares/4.jpg', 12, NULL, NULL),
	(48, 'storage/photos/shares/27503686_150287739101270_9041139970018360027_o.jpg', 13, NULL, NULL),
	(49, 'storage/photos/shares/370632485_122126490164002835_7814470262877211187_n.jpg', 13, NULL, NULL),
	(51, 'storage/photos/shares/3.jpg', 14, NULL, NULL),
	(52, 'storage/photos/shares/800px-Sunflower_from_Silesia2.jpg', 14, NULL, NULL),
	(53, 'storage/photos/shares/6.jpg', 14, NULL, NULL),
	(58, 'storage/photos/shares/3.jpg', 6, NULL, NULL),
	(59, 'storage/photos/shares/4.jpg', 6, NULL, NULL),
	(60, 'storage/photos/shares/800px-Sunflower_from_Silesia2.jpg', 6, NULL, NULL);

-- Dumping structure for table nader_db.categories
CREATE TABLE IF NOT EXISTS `categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `categories_id_index` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.categories: ~5 rows (approximately)
INSERT INTO `categories` (`id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(7, '2024-11-08 10:25:36', '2024-11-08 10:25:36', NULL),
	(8, '2024-11-08 10:26:04', '2024-11-08 10:26:04', NULL),
	(9, '2024-11-08 19:34:30', '2024-11-08 19:34:30', NULL),
	(10, '2024-11-08 19:36:36', '2024-11-08 19:36:36', NULL),
	(11, '2024-11-14 00:32:29', '2024-11-14 00:32:29', NULL);

-- Dumping structure for table nader_db.category_descriptions
CREATE TABLE IF NOT EXISTS `category_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `type` bigint(20) DEFAULT NULL,
  `category_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `category_descriptions_category_id_foreign` (`category_id`),
  KEY `category_descriptions_language_id_foreign` (`language_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.category_descriptions: ~8 rows (approximately)
INSERT INTO `category_descriptions` (`id`, `name`, `type`, `category_id`, `language_id`, `created_at`, `updated_at`) VALUES
	(11, 'رئيسي1', NULL, 7, 1, NULL, NULL),
	(12, 'main1', NULL, 7, 2, NULL, NULL),
	(13, 'رئيسي2', NULL, 8, 1, NULL, NULL),
	(14, 'main2', NULL, 8, 2, NULL, NULL),
	(15, 'فرعي اول1', NULL, 9, 1, NULL, NULL),
	(16, 'sub_main1', NULL, 9, 2, NULL, NULL),
	(17, 'فرعي اول2', NULL, 10, 1, NULL, NULL),
	(18, 'sub_main2', NULL, 10, 2, NULL, NULL);

-- Dumping structure for table nader_db.cities
CREATE TABLE IF NOT EXISTS `cities` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `sort` bigint(20) DEFAULT NULL,
  `country_id` bigint(20) unsigned NOT NULL,
  `region_id` bigint(20) unsigned DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cities_country_id_foreign` (`country_id`),
  KEY `cities_region_id_foreign` (`region_id`),
  KEY `cities_sort_index` (`sort`),
  CONSTRAINT `cities_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE,
  CONSTRAINT `cities_region_id_foreign` FOREIGN KEY (`region_id`) REFERENCES `regions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=23713 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table nader_db.cities: ~5 rows (approximately)
INSERT INTO `cities` (`id`, `sort`, `country_id`, `region_id`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(23708, NULL, 267, 32, 'active', NULL, '2024-11-16 12:45:57', '2024-11-16 12:45:57'),
	(23709, NULL, 267, 32, 'active', NULL, '2024-11-16 12:50:09', '2024-11-16 12:50:09'),
	(23710, NULL, 267, 33, 'active', NULL, '2024-11-16 13:23:15', '2024-11-16 13:23:15'),
	(23711, NULL, 267, 34, 'active', NULL, '2024-11-16 13:25:08', '2024-11-16 13:25:08'),
	(23712, NULL, 268, 35, 'active', NULL, '2024-11-16 13:29:32', '2024-11-16 13:29:32');

-- Dumping structure for table nader_db.city_descriptions
CREATE TABLE IF NOT EXISTS `city_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) DEFAULT NULL,
  `city_id` bigint(20) unsigned NOT NULL,
  `language_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `city_descriptions_city_id_foreign` (`city_id`),
  KEY `city_descriptions_language_id_index` (`language_id`),
  CONSTRAINT `city_descriptions_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9200 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table nader_db.city_descriptions: ~10 rows (approximately)
INSERT INTO `city_descriptions` (`id`, `title`, `city_id`, `language_id`) VALUES
	(9190, 'فرعي ثاني-1', 23708, 1),
	(9191, 'submain2-1', 23708, 2),
	(9192, 'فرعي ثاني-2', 23709, 1),
	(9193, 'submain2-3', 23709, 2),
	(9194, 'فرع تاني -3', 23710, 1),
	(9195, 'submain2-3', 23710, 2),
	(9196, 'فرع تاني -4', 23711, 1),
	(9197, 'submain2-4', 23711, 2),
	(9198, 'فرع ثاني -23', 23712, 1),
	(9199, 'submain2-23', 23712, 2);

-- Dumping structure for table nader_db.clients
CREATE TABLE IF NOT EXISTS `clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(250) NOT NULL DEFAULT '0',
  `link_url` varchar(500) DEFAULT NULL,
  `inner_image` varchar(500) DEFAULT NULL,
  `pdf_file` varchar(500) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.clients: ~3 rows (approximately)
INSERT INTO `clients` (`id`, `type`, `link_url`, `inner_image`, `pdf_file`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(23, 'الرئيسي-->الرئيسي 1', 'الرابط', 'storage/photos/shares/3.jpg', 'storage/pdf_uploads/1731772161-tanzol.pdf', '2024-11-16 16:49:21', '2024-11-16 16:49:21', NULL),
	(24, 'فرعي أول-->فرعي اول -1', '999', 'storage/photos/shares/3.jpg', 'storage/pdf_uploads/1731772265-tanzol.pdf', '2024-11-16 16:51:05', '2024-11-16 16:51:05', NULL),
	(25, 'فرعي ثاني-->فرع ثاني -23', '1112', 'storage/photos/shares/370632485_122126490164002835_7814470262877211187_n.jpg', 'storage/pdf_uploads/1731772358-temp@pulitalia.pdf', '2024-11-16 16:52:38', '2024-11-16 16:52:38', NULL);

-- Dumping structure for table nader_db.client_descriptions
CREATE TABLE IF NOT EXISTS `client_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `Disease_Desc` varchar(500) DEFAULT NULL,
  `link_name` varchar(500) DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  `client_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `client_descriptions_language_id_foreign` (`language_id`),
  KEY `client_descriptions_client_id_foreign` (`client_id`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.client_descriptions: ~6 rows (approximately)
INSERT INTO `client_descriptions` (`id`, `title`, `description`, `Disease_Desc`, `link_name`, `language_id`, `client_id`, `created_at`, `updated_at`) VALUES
	(65, 'اسم المرض (Arabic)', '<p>111</p>', 'الوصف التعريفي للمرض (Arabic)', 'اسم الرابط (Arabic)', 1, 23, NULL, NULL),
	(66, 'اسم المرض (English)', '<p>222</p>', 'الوصف التعريفي للمرض (English)', 'اسم الرابط (English)', 2, 23, NULL, NULL),
	(67, '111', '<p>555</p>', '333', '777', 1, 24, NULL, NULL),
	(68, '222', '<p>666</p>', '444', '888', 2, 24, NULL, NULL),
	(69, '222', '<p>777</p>', '555', '999', 1, 25, NULL, NULL),
	(70, '111', '<p>888</p>', '666', '1010', 2, 25, NULL, NULL);

-- Dumping structure for table nader_db.countries
CREATE TABLE IF NOT EXISTS `countries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `sort` bigint(20) DEFAULT NULL,
  `country_code` varchar(50) DEFAULT NULL,
  `iso2` varchar(50) DEFAULT NULL,
  `continent` varchar(50) DEFAULT NULL,
  `capital` varchar(100) DEFAULT NULL,
  `time_zone` varchar(100) DEFAULT NULL,
  `currency` varchar(100) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `countries_sort_index` (`sort`),
  KEY `countries_iso2_index` (`iso2`)
) ENGINE=InnoDB AUTO_INCREMENT=270 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table nader_db.countries: ~3 rows (approximately)
INSERT INTO `countries` (`id`, `sort`, `country_code`, `iso2`, `continent`, `capital`, `time_zone`, `currency`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(267, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'active', NULL, '2024-11-16 12:44:38', '2024-11-16 12:44:38'),
	(268, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'active', NULL, '2024-11-16 13:26:03', '2024-11-16 13:26:03'),
	(269, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'active', NULL, '2024-11-16 19:55:45', '2024-11-16 19:55:45');

-- Dumping structure for table nader_db.countries2
CREATE TABLE IF NOT EXISTS `countries2` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(5) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `countries_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=254 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table nader_db.countries2: ~253 rows (approximately)
INSERT INTO `countries2` (`id`, `code`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, NULL, '2022-12-07 09:39:26', '2023-06-07 08:23:48', '2023-06-07 08:23:48'),
	(2, NULL, '2022-12-07 09:39:26', '2022-12-07 09:39:26', NULL),
	(3, NULL, '2022-12-07 09:39:27', '2022-12-07 09:39:27', NULL),
	(4, NULL, '2022-12-07 09:39:27', '2022-12-07 09:39:27', NULL),
	(5, NULL, '2022-12-07 09:39:27', '2022-12-07 09:39:27', NULL),
	(6, NULL, '2022-12-07 09:39:27', '2022-12-07 09:39:27', NULL),
	(7, NULL, '2022-12-07 09:39:28', '2022-12-07 09:39:28', NULL),
	(8, NULL, '2022-12-07 09:39:28', '2022-12-07 09:39:28', NULL),
	(9, NULL, '2022-12-07 09:39:28', '2022-12-07 09:39:28', NULL),
	(10, NULL, '2022-12-07 09:39:28', '2022-12-07 09:39:28', NULL),
	(11, NULL, '2022-12-07 09:39:28', '2022-12-07 09:39:28', NULL),
	(12, NULL, '2022-12-07 09:39:28', '2022-12-07 09:39:28', NULL),
	(13, NULL, '2022-12-07 09:39:28', '2022-12-07 09:39:28', NULL),
	(14, NULL, '2022-12-07 09:39:28', '2022-12-07 09:39:28', NULL),
	(15, NULL, '2022-12-07 09:39:29', '2022-12-07 09:39:29', NULL),
	(16, NULL, '2022-12-07 09:39:29', '2022-12-07 09:39:29', NULL),
	(17, NULL, '2022-12-07 09:39:29', '2022-12-07 09:39:29', NULL),
	(18, NULL, '2022-12-07 09:39:29', '2022-12-07 09:39:29', NULL),
	(19, NULL, '2022-12-07 09:39:30', '2022-12-07 09:39:30', NULL),
	(20, NULL, '2022-12-07 09:39:30', '2022-12-07 09:39:30', NULL),
	(21, NULL, '2022-12-07 09:39:30', '2022-12-07 09:39:30', NULL),
	(22, NULL, '2022-12-07 09:39:30', '2022-12-07 09:39:30', NULL),
	(23, NULL, '2022-12-07 09:39:30', '2022-12-07 09:39:30', NULL),
	(24, NULL, '2022-12-07 09:39:30', '2022-12-07 09:39:30', NULL),
	(25, NULL, '2022-12-07 09:39:31', '2022-12-07 09:39:31', NULL),
	(26, NULL, '2022-12-07 09:39:31', '2022-12-07 09:39:31', NULL),
	(27, NULL, '2022-12-07 09:39:31', '2022-12-07 09:39:31', NULL),
	(28, NULL, '2022-12-07 09:39:31', '2022-12-07 09:39:31', NULL),
	(29, NULL, '2022-12-07 09:39:32', '2022-12-07 09:39:32', NULL),
	(30, NULL, '2022-12-07 09:39:32', '2022-12-07 09:39:32', NULL),
	(31, NULL, '2022-12-07 09:39:32', '2022-12-07 09:39:32', NULL),
	(32, NULL, '2022-12-07 09:39:32', '2022-12-07 09:39:32', NULL),
	(33, NULL, '2022-12-07 09:39:33', '2022-12-07 09:39:33', NULL),
	(34, NULL, '2022-12-07 09:39:33', '2022-12-07 09:39:33', NULL),
	(35, NULL, '2022-12-07 09:39:33', '2022-12-07 09:39:33', NULL),
	(36, NULL, '2022-12-07 09:39:33', '2022-12-07 09:39:33', NULL),
	(37, NULL, '2022-12-07 09:39:33', '2022-12-07 09:39:33', NULL),
	(38, NULL, '2022-12-07 09:39:33', '2022-12-07 09:39:33', NULL),
	(39, NULL, '2022-12-07 09:39:34', '2022-12-07 09:39:34', NULL),
	(40, NULL, '2022-12-07 09:39:34', '2022-12-07 09:39:34', NULL),
	(41, NULL, '2022-12-07 09:39:34', '2022-12-07 09:39:34', NULL),
	(42, NULL, '2022-12-07 09:39:34', '2022-12-07 09:39:34', NULL),
	(43, NULL, '2022-12-07 09:39:34', '2022-12-07 09:39:34', NULL),
	(44, NULL, '2022-12-07 09:39:35', '2022-12-07 09:39:35', NULL),
	(45, NULL, '2022-12-07 09:39:35', '2022-12-07 09:39:35', NULL),
	(46, NULL, '2022-12-07 09:39:35', '2022-12-07 09:39:35', NULL),
	(47, NULL, '2022-12-07 09:39:35', '2022-12-07 09:39:35', NULL),
	(48, NULL, '2022-12-07 09:39:36', '2022-12-07 09:39:36', NULL),
	(49, NULL, '2022-12-07 09:39:36', '2022-12-07 09:39:36', NULL),
	(50, NULL, '2022-12-07 09:39:36', '2022-12-07 09:39:36', NULL),
	(51, NULL, '2022-12-07 09:39:36', '2022-12-07 09:39:36', NULL),
	(52, NULL, '2022-12-07 09:39:36', '2022-12-07 09:39:36', NULL),
	(53, NULL, '2022-12-07 09:39:36', '2022-12-07 09:39:36', NULL),
	(54, NULL, '2022-12-07 09:39:37', '2022-12-07 09:39:37', NULL),
	(55, NULL, '2022-12-07 09:39:37', '2022-12-07 09:39:37', NULL),
	(56, NULL, '2022-12-07 09:39:37', '2022-12-07 09:39:37', NULL),
	(57, NULL, '2022-12-07 09:39:37', '2022-12-07 09:39:37', NULL),
	(58, NULL, '2022-12-07 09:39:38', '2022-12-07 09:39:38', NULL),
	(59, NULL, '2022-12-07 09:39:38', '2022-12-07 09:39:38', NULL),
	(60, NULL, '2022-12-07 09:39:38', '2022-12-07 09:39:38', NULL),
	(61, NULL, '2022-12-07 09:39:38', '2022-12-07 09:39:38', NULL),
	(62, NULL, '2022-12-07 09:39:38', '2022-12-07 09:39:38', NULL),
	(63, NULL, '2022-12-07 09:39:39', '2022-12-07 09:39:39', NULL),
	(64, NULL, '2022-12-07 09:39:39', '2022-12-07 09:39:39', NULL),
	(65, NULL, '2022-12-07 09:39:39', '2022-12-07 09:39:39', NULL),
	(66, NULL, '2022-12-07 09:39:39', '2022-12-07 09:39:39', NULL),
	(67, NULL, '2022-12-07 09:39:39', '2022-12-07 09:39:39', NULL),
	(68, NULL, '2022-12-07 09:39:39', '2022-12-07 09:39:39', NULL),
	(69, NULL, '2022-12-07 09:39:39', '2022-12-07 09:39:39', NULL),
	(70, NULL, '2022-12-07 09:39:39', '2022-12-07 09:39:39', NULL),
	(71, NULL, '2022-12-07 09:39:39', '2022-12-07 09:39:39', NULL),
	(72, NULL, '2022-12-07 09:39:39', '2022-12-07 09:39:39', NULL),
	(73, NULL, '2022-12-07 09:39:40', '2022-12-07 09:39:40', NULL),
	(74, NULL, '2022-12-07 09:39:40', '2022-12-07 09:39:40', NULL),
	(75, NULL, '2022-12-07 09:39:40', '2022-12-07 09:39:40', NULL),
	(76, NULL, '2022-12-07 09:39:40', '2022-12-07 09:39:40', NULL),
	(77, NULL, '2022-12-07 09:39:40', '2022-12-07 09:39:40', NULL),
	(78, NULL, '2022-12-07 09:39:40', '2022-12-07 09:39:40', NULL),
	(79, NULL, '2022-12-07 09:39:40', '2022-12-07 09:39:40', NULL),
	(80, NULL, '2022-12-07 09:39:41', '2022-12-07 09:39:41', NULL),
	(81, NULL, '2022-12-07 09:39:41', '2022-12-07 09:39:41', NULL),
	(82, NULL, '2022-12-07 09:39:41', '2022-12-07 09:39:41', NULL),
	(83, NULL, '2022-12-07 09:39:41', '2022-12-07 09:39:41', NULL),
	(84, NULL, '2022-12-07 09:39:42', '2022-12-07 09:39:42', NULL),
	(85, NULL, '2022-12-07 09:39:42', '2022-12-07 09:39:42', NULL),
	(86, NULL, '2022-12-07 09:39:42', '2022-12-07 09:39:42', NULL),
	(87, NULL, '2022-12-07 09:39:42', '2022-12-07 09:39:42', NULL),
	(88, NULL, '2022-12-07 09:39:43', '2022-12-07 09:39:43', NULL),
	(89, NULL, '2022-12-07 09:39:43', '2022-12-07 09:39:43', NULL),
	(90, NULL, '2022-12-07 09:39:43', '2022-12-07 09:39:43', NULL),
	(91, NULL, '2022-12-07 09:39:43', '2022-12-07 09:39:43', NULL),
	(92, NULL, '2022-12-07 09:39:43', '2022-12-07 09:39:43', NULL),
	(93, NULL, '2022-12-07 09:39:43', '2022-12-07 09:39:43', NULL),
	(94, NULL, '2022-12-07 09:39:43', '2022-12-07 09:39:43', NULL),
	(95, NULL, '2022-12-07 09:39:44', '2022-12-07 09:39:44', NULL),
	(96, NULL, '2022-12-07 09:39:44', '2022-12-07 09:39:44', NULL),
	(97, NULL, '2022-12-07 09:39:45', '2022-12-07 09:39:45', NULL),
	(98, NULL, '2022-12-07 09:39:45', '2022-12-07 09:39:45', NULL),
	(99, NULL, '2022-12-07 09:39:46', '2022-12-07 09:39:46', NULL),
	(100, NULL, '2022-12-07 09:39:46', '2022-12-07 09:39:46', NULL),
	(101, NULL, '2022-12-07 09:39:46', '2022-12-07 09:39:46', NULL),
	(102, NULL, '2022-12-07 09:39:47', '2022-12-07 09:39:47', NULL),
	(103, NULL, '2022-12-07 09:39:47', '2022-12-07 09:39:47', NULL),
	(104, NULL, '2022-12-07 09:39:48', '2022-12-07 09:39:48', NULL),
	(105, NULL, '2022-12-07 09:39:48', '2022-12-07 09:39:48', NULL),
	(106, NULL, '2022-12-07 09:39:48', '2022-12-07 09:39:48', NULL),
	(107, NULL, '2022-12-07 09:39:49', '2022-12-07 09:39:49', NULL),
	(108, NULL, '2022-12-07 09:39:49', '2022-12-07 09:39:49', NULL),
	(109, NULL, '2022-12-07 09:39:50', '2022-12-07 09:39:50', NULL),
	(110, NULL, '2022-12-07 09:39:50', '2022-12-07 09:39:50', NULL),
	(111, NULL, '2022-12-07 09:39:50', '2022-12-07 09:39:50', NULL),
	(112, NULL, '2022-12-07 09:39:50', '2022-12-07 09:39:50', NULL),
	(113, NULL, '2022-12-07 09:39:51', '2022-12-07 09:39:51', NULL),
	(114, NULL, '2022-12-07 09:39:51', '2022-12-07 09:39:51', NULL),
	(115, NULL, '2022-12-07 09:39:51', '2022-12-07 09:39:51', NULL),
	(116, NULL, '2022-12-07 09:39:51', '2022-12-07 09:39:51', NULL),
	(117, NULL, '2022-12-07 09:39:52', '2022-12-07 09:39:52', NULL),
	(118, NULL, '2022-12-07 09:39:52', '2022-12-07 09:39:52', NULL),
	(119, NULL, '2022-12-07 09:39:52', '2022-12-07 09:39:52', NULL),
	(120, NULL, '2022-12-07 09:39:52', '2022-12-07 09:39:52', NULL),
	(121, NULL, '2022-12-07 09:39:53', '2022-12-07 09:39:53', NULL),
	(122, NULL, '2022-12-07 09:39:53', '2022-12-07 09:39:53', NULL),
	(123, NULL, '2022-12-07 09:39:53', '2022-12-07 09:39:53', NULL),
	(124, NULL, '2022-12-07 09:39:53', '2022-12-07 09:39:53', NULL),
	(125, NULL, '2022-12-07 09:39:54', '2022-12-07 09:39:54', NULL),
	(126, NULL, '2022-12-07 09:39:54', '2022-12-07 09:39:54', NULL),
	(127, NULL, '2022-12-07 09:39:54', '2022-12-07 09:39:54', NULL),
	(128, NULL, '2022-12-07 09:39:54', '2022-12-07 09:39:54', NULL),
	(129, NULL, '2022-12-07 09:39:54', '2022-12-07 09:39:54', NULL),
	(130, NULL, '2022-12-07 09:39:54', '2022-12-07 09:39:54', NULL),
	(131, NULL, '2022-12-07 09:39:54', '2022-12-07 09:39:54', NULL),
	(132, NULL, '2022-12-07 09:39:55', '2022-12-07 09:39:55', NULL),
	(133, NULL, '2022-12-07 09:39:55', '2022-12-07 09:39:55', NULL),
	(134, NULL, '2022-12-07 09:39:55', '2022-12-07 09:39:55', NULL),
	(135, NULL, '2022-12-07 09:39:55', '2022-12-07 09:39:55', NULL),
	(136, NULL, '2022-12-07 09:39:55', '2022-12-07 09:39:55', NULL),
	(137, NULL, '2022-12-07 09:39:56', '2022-12-07 09:39:56', NULL),
	(138, NULL, '2022-12-07 09:39:56', '2022-12-07 09:39:56', NULL),
	(139, NULL, '2022-12-07 09:39:56', '2022-12-07 09:39:56', NULL),
	(140, NULL, '2022-12-07 09:39:57', '2022-12-07 09:39:57', NULL),
	(141, NULL, '2022-12-07 09:39:57', '2022-12-07 09:39:57', NULL),
	(142, NULL, '2022-12-07 09:39:57', '2022-12-07 09:39:57', NULL),
	(143, NULL, '2022-12-07 09:39:58', '2022-12-07 09:39:58', NULL),
	(144, NULL, '2022-12-07 09:39:58', '2022-12-07 09:39:58', NULL),
	(145, NULL, '2022-12-07 09:39:58', '2022-12-07 09:39:58', NULL),
	(146, NULL, '2022-12-07 09:39:58', '2022-12-07 09:39:58', NULL),
	(147, NULL, '2022-12-07 09:39:58', '2022-12-07 09:39:58', NULL),
	(148, NULL, '2022-12-07 09:39:59', '2022-12-07 09:39:59', NULL),
	(149, NULL, '2022-12-07 09:39:59', '2022-12-07 09:39:59', NULL),
	(150, NULL, '2022-12-07 09:39:59', '2022-12-07 09:39:59', NULL),
	(151, NULL, '2022-12-07 09:39:59', '2022-12-07 09:39:59', NULL),
	(152, NULL, '2022-12-07 09:40:00', '2022-12-07 09:40:00', NULL),
	(153, NULL, '2022-12-07 09:40:00', '2022-12-07 09:40:00', NULL),
	(154, NULL, '2022-12-07 09:40:00', '2022-12-07 09:40:00', NULL),
	(155, NULL, '2022-12-07 09:40:00', '2022-12-07 09:40:00', NULL),
	(156, NULL, '2022-12-07 09:40:01', '2022-12-07 09:40:01', NULL),
	(157, NULL, '2022-12-07 09:40:01', '2022-12-07 09:40:01', NULL),
	(158, NULL, '2022-12-07 09:40:01', '2022-12-07 09:40:01', NULL),
	(159, NULL, '2022-12-07 09:40:02', '2022-12-07 09:40:02', NULL),
	(160, NULL, '2022-12-07 09:40:02', '2022-12-07 09:40:02', NULL),
	(161, NULL, '2022-12-07 09:40:02', '2022-12-07 09:40:02', NULL),
	(162, NULL, '2022-12-07 09:40:02', '2022-12-07 09:40:02', NULL),
	(163, NULL, '2022-12-07 09:40:03', '2022-12-07 09:40:03', NULL),
	(164, NULL, '2022-12-07 09:40:03', '2022-12-07 09:40:03', NULL),
	(165, NULL, '2022-12-07 09:40:03', '2022-12-07 09:40:03', NULL),
	(166, NULL, '2022-12-07 09:40:03', '2022-12-07 09:40:03', NULL),
	(167, NULL, '2022-12-07 09:40:03', '2022-12-07 09:40:03', NULL),
	(168, NULL, '2022-12-07 09:40:04', '2022-12-07 09:40:04', NULL),
	(169, NULL, '2022-12-07 09:40:04', '2022-12-07 09:40:04', NULL),
	(170, NULL, '2022-12-07 09:40:04', '2022-12-07 09:40:04', NULL),
	(171, NULL, '2022-12-07 09:40:05', '2022-12-07 09:40:05', NULL),
	(172, NULL, '2022-12-07 09:40:05', '2022-12-07 09:40:05', NULL),
	(173, NULL, '2022-12-07 09:40:05', '2022-12-07 09:40:05', NULL),
	(174, NULL, '2022-12-07 09:40:05', '2022-12-07 09:40:05', NULL),
	(175, NULL, '2022-12-07 09:40:06', '2022-12-07 09:40:06', NULL),
	(176, NULL, '2022-12-07 09:40:06', '2022-12-07 09:40:06', NULL),
	(177, NULL, '2022-12-07 09:40:06', '2022-12-07 09:40:06', NULL),
	(178, NULL, '2022-12-07 09:40:07', '2022-12-07 09:40:07', NULL),
	(179, NULL, '2022-12-07 09:40:07', '2022-12-07 09:40:07', NULL),
	(180, NULL, '2022-12-07 09:40:07', '2022-12-07 09:40:07', NULL),
	(181, NULL, '2022-12-07 09:40:07', '2022-12-07 09:40:07', NULL),
	(182, NULL, '2022-12-07 09:40:08', '2022-12-07 09:40:08', NULL),
	(183, NULL, '2022-12-07 09:40:08', '2022-12-07 09:40:08', NULL),
	(184, NULL, '2022-12-07 09:40:08', '2022-12-07 09:40:08', NULL),
	(185, NULL, '2022-12-07 09:40:09', '2022-12-07 09:40:09', NULL),
	(186, NULL, '2022-12-07 09:40:09', '2022-12-07 09:40:09', NULL),
	(187, NULL, '2022-12-07 09:40:09', '2022-12-07 09:40:09', NULL),
	(188, NULL, '2022-12-07 09:40:09', '2022-12-07 09:40:09', NULL),
	(189, NULL, '2022-12-07 09:40:09', '2022-12-07 09:40:09', NULL),
	(190, NULL, '2022-12-07 09:40:09', '2022-12-07 09:40:09', NULL),
	(191, NULL, '2022-12-07 09:40:09', '2022-12-07 09:40:09', NULL),
	(192, NULL, '2022-12-07 09:40:09', '2022-12-07 09:40:09', NULL),
	(193, NULL, '2022-12-07 09:40:09', '2022-12-07 09:40:09', NULL),
	(194, NULL, '2022-12-07 09:40:10', '2022-12-07 09:40:10', NULL),
	(195, NULL, '2022-12-07 09:40:10', '2022-12-07 09:40:10', NULL),
	(196, NULL, '2022-12-07 09:40:10', '2022-12-07 09:40:10', NULL),
	(197, NULL, '2022-12-07 09:40:10', '2022-12-07 09:40:10', NULL),
	(198, NULL, '2022-12-07 09:40:10', '2022-12-07 09:40:10', NULL),
	(199, NULL, '2022-12-07 09:40:10', '2022-12-07 09:40:10', NULL),
	(200, NULL, '2022-12-07 09:40:11', '2022-12-07 09:40:11', NULL),
	(201, NULL, '2022-12-07 09:40:11', '2022-12-07 09:40:11', NULL),
	(202, NULL, '2022-12-07 09:40:11', '2022-12-07 09:40:11', NULL),
	(203, NULL, '2022-12-07 09:40:11', '2022-12-07 09:40:11', NULL),
	(204, NULL, '2022-12-07 09:40:11', '2022-12-07 09:40:11', NULL),
	(205, NULL, '2022-12-07 09:40:11', '2022-12-07 09:40:11', NULL),
	(206, NULL, '2022-12-07 09:40:11', '2022-12-07 09:40:11', NULL),
	(207, NULL, '2022-12-07 09:40:11', '2022-12-07 09:40:11', NULL),
	(208, NULL, '2022-12-07 09:40:12', '2022-12-07 09:40:12', NULL),
	(209, NULL, '2022-12-07 09:40:12', '2022-12-07 09:40:12', NULL),
	(210, NULL, '2022-12-07 09:40:12', '2022-12-07 09:40:12', NULL),
	(211, NULL, '2022-12-07 09:40:12', '2022-12-07 09:40:12', NULL),
	(212, NULL, '2022-12-07 09:40:12', '2022-12-07 09:40:12', NULL),
	(213, NULL, '2022-12-07 09:40:13', '2022-12-07 09:40:13', NULL),
	(214, NULL, '2022-12-07 09:40:13', '2022-12-07 09:40:13', NULL),
	(215, NULL, '2022-12-07 09:40:13', '2022-12-07 09:40:13', NULL),
	(216, NULL, '2022-12-07 09:40:13', '2022-12-07 09:40:13', NULL),
	(217, NULL, '2022-12-07 09:40:13', '2022-12-07 09:40:13', NULL),
	(218, NULL, '2022-12-07 09:40:13', '2022-12-07 09:40:13', NULL),
	(219, NULL, '2022-12-07 09:40:13', '2022-12-07 09:40:13', NULL),
	(220, NULL, '2022-12-07 09:40:14', '2022-12-07 09:40:14', NULL),
	(221, NULL, '2022-12-07 09:40:14', '2022-12-07 09:40:14', NULL),
	(222, NULL, '2022-12-07 09:40:14', '2022-12-07 09:40:14', NULL),
	(223, NULL, '2022-12-07 09:40:14', '2022-12-07 09:40:14', NULL),
	(224, NULL, '2022-12-07 09:40:14', '2022-12-07 09:40:14', NULL),
	(225, NULL, '2022-12-07 09:40:14', '2022-12-07 09:40:14', NULL),
	(226, NULL, '2022-12-07 09:40:14', '2022-12-07 09:40:14', NULL),
	(227, NULL, '2022-12-07 09:40:14', '2022-12-07 09:40:14', NULL),
	(228, NULL, '2022-12-07 09:40:15', '2022-12-07 09:40:15', NULL),
	(229, NULL, '2022-12-07 09:40:15', '2022-12-07 09:40:15', NULL),
	(230, NULL, '2022-12-07 09:40:15', '2022-12-07 09:40:15', NULL),
	(231, NULL, '2022-12-07 09:40:16', '2022-12-07 09:40:16', NULL),
	(232, NULL, '2022-12-07 09:40:16', '2022-12-07 09:40:16', NULL),
	(233, NULL, '2022-12-07 09:40:16', '2022-12-07 09:40:16', NULL),
	(234, NULL, '2022-12-07 09:40:17', '2022-12-07 09:40:17', NULL),
	(235, NULL, '2022-12-07 09:40:17', '2022-12-07 09:40:17', NULL),
	(236, NULL, '2022-12-07 09:40:17', '2022-12-07 09:40:17', NULL),
	(237, NULL, '2022-12-07 09:40:17', '2022-12-07 09:40:17', NULL),
	(238, NULL, '2022-12-07 09:40:17', '2022-12-07 09:40:17', NULL),
	(239, NULL, '2022-12-07 09:40:17', '2022-12-07 09:40:17', NULL),
	(240, NULL, '2022-12-07 09:40:17', '2022-12-07 09:40:17', NULL),
	(241, NULL, '2022-12-07 09:40:17', '2022-12-07 09:40:17', NULL),
	(242, NULL, '2022-12-07 09:40:18', '2022-12-07 09:40:18', NULL),
	(243, NULL, '2022-12-07 09:40:18', '2022-12-07 09:40:18', NULL),
	(244, NULL, '2022-12-07 09:40:18', '2022-12-07 09:40:18', NULL),
	(245, NULL, '2022-12-07 09:40:18', '2022-12-07 09:40:18', NULL),
	(246, NULL, '2022-12-07 09:40:19', '2022-12-07 09:40:19', NULL),
	(247, NULL, '2022-12-07 09:40:19', '2022-12-07 09:40:19', NULL),
	(248, NULL, '2022-12-07 09:40:19', '2022-12-07 09:40:19', NULL),
	(249, NULL, '2022-12-07 09:40:19', '2022-12-07 09:40:19', NULL),
	(250, NULL, '2022-12-07 09:40:19', '2022-12-07 09:40:19', NULL),
	(251, NULL, '2022-12-07 09:40:19', '2022-12-07 09:40:19', NULL),
	(252, NULL, '2022-12-07 09:40:19', '2022-12-07 09:40:19', NULL),
	(253, NULL, '2023-06-07 08:24:02', '2023-06-07 08:24:02', NULL);

-- Dumping structure for table nader_db.country_descriptions
CREATE TABLE IF NOT EXISTS `country_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) DEFAULT NULL,
  `country_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `country_descriptions_country_id_foreign` (`country_id`),
  KEY `country_descriptions_language_id_index` (`language_id`)
) ENGINE=InnoDB AUTO_INCREMENT=541 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table nader_db.country_descriptions: ~6 rows (approximately)
INSERT INTO `country_descriptions` (`id`, `title`, `country_id`, `language_id`) VALUES
	(535, 'الرئيسي 1', 267, 1),
	(536, 'main1', 267, 2),
	(537, 'الرئيسي-2', 268, 1),
	(538, 'main-2', 268, 2),
	(539, 'الرئيسي 3', 269, 1),
	(540, 'main3', 269, 2);

-- Dumping structure for table nader_db.country_descriptions2
CREATE TABLE IF NOT EXISTS `country_descriptions2` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `country_id` bigint(20) unsigned NOT NULL,
  `language_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `country_descriptions_country_id_language_id_index` (`country_id`,`language_id`),
  CONSTRAINT `country_descriptions_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries2` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=507 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table nader_db.country_descriptions2: ~506 rows (approximately)
INSERT INTO `country_descriptions2` (`id`, `name`, `country_id`, `language_id`) VALUES
	(1, 'أفغانستان', 1, 1),
	(2, 'Afghanistan', 1, 2),
	(3, 'جزر آلاند', 2, 1),
	(4, 'Aland Islands', 2, 2),
	(5, 'ألبانيا', 3, 1),
	(6, 'Albania', 3, 2),
	(7, 'الجزائر', 4, 1),
	(8, 'Algeria', 4, 2),
	(9, 'ساموا الأمريكية', 5, 1),
	(10, 'American Samoa', 5, 2),
	(11, 'أندورا', 6, 1),
	(12, 'Andorra', 6, 2),
	(13, 'أنغولا', 7, 1),
	(14, 'Angola', 7, 2),
	(15, 'أنغيلا', 8, 1),
	(16, 'Anguilla', 8, 2),
	(17, 'أنتاركتيكا', 9, 1),
	(18, 'Antarctica', 9, 2),
	(19, 'أنتيغوا وبربودا', 10, 1),
	(20, 'Antigua and Barbuda', 10, 2),
	(21, 'الأرجنتين', 11, 1),
	(22, 'Argentina', 11, 2),
	(23, 'أرمينيا', 12, 1),
	(24, 'Armenia', 12, 2),
	(25, 'أروبا', 13, 1),
	(26, 'Aruba', 13, 2),
	(27, 'أستراليا', 14, 1),
	(28, 'Australia', 14, 2),
	(29, 'النمسا', 15, 1),
	(30, 'Austria', 15, 2),
	(31, 'أذربيجان', 16, 1),
	(32, 'Azerbaijan', 16, 2),
	(33, 'جزر البهاما', 17, 1),
	(34, 'Bahamas', 17, 2),
	(35, 'البحرين', 18, 1),
	(36, 'Bahrain', 18, 2),
	(37, 'بنغلاديش', 19, 1),
	(38, 'Bangladesh', 19, 2),
	(39, 'بربادوس', 20, 1),
	(40, 'Barbados', 20, 2),
	(41, 'بيلاروسيا', 21, 1),
	(42, 'Belarus', 21, 2),
	(43, 'بلجيكا', 22, 1),
	(44, 'Belgium', 22, 2),
	(45, 'بليز', 23, 1),
	(46, 'Belize', 23, 2),
	(47, 'بنين', 24, 1),
	(48, 'Benin', 24, 2),
	(49, 'برمودا', 25, 1),
	(50, 'Bermuda', 25, 2),
	(51, 'بوتان', 26, 1),
	(52, 'Bhutan', 26, 2),
	(53, 'بوليفيا', 27, 1),
	(54, 'Bolivia', 27, 2),
	(55, 'بونير وسانت يوستاتيوس وسابا', 28, 1),
	(56, 'Bonaire, Sint Eustatius and Saba', 28, 2),
	(57, 'البوسنة والهرسك', 29, 1),
	(58, 'Bosnia and Herzegovina', 29, 2),
	(59, 'بوتسوانا', 30, 1),
	(60, 'Botswana', 30, 2),
	(61, 'جزيرة بوفيت', 31, 1),
	(62, 'Bouvet Island', 31, 2),
	(63, 'البرازيل', 32, 1),
	(64, 'Brazil', 32, 2),
	(65, 'إقليم المحيط البريطاني الهندي', 33, 1),
	(66, 'British Indian Ocean Territory', 33, 2),
	(67, 'بروناي دار السلام', 34, 1),
	(68, 'Brunei Darussalam', 34, 2),
	(69, 'بلغاريا', 35, 1),
	(70, 'Bulgaria', 35, 2),
	(71, 'بوركينا فاسو', 36, 1),
	(72, 'Burkina Faso', 36, 2),
	(73, 'بوروندي', 37, 1),
	(74, 'Burundi', 37, 2),
	(75, 'كمبوديا', 38, 1),
	(76, 'Cambodia', 38, 2),
	(77, 'الكاميرون', 39, 1),
	(78, 'Cameroon', 39, 2),
	(79, 'كندا', 40, 1),
	(80, 'Canada', 40, 2),
	(81, 'الرأس الأخضر', 41, 1),
	(82, 'Cape Verde', 41, 2),
	(83, 'جزر كايمان', 42, 1),
	(84, 'Cayman Islands', 42, 2),
	(85, 'جمهورية افريقيا الوسطى', 43, 1),
	(86, 'Central African Republic', 43, 2),
	(87, 'تشاد', 44, 1),
	(88, 'Chad', 44, 2),
	(89, 'تشيلي', 45, 1),
	(90, 'Chile', 45, 2),
	(91, 'الصين', 46, 1),
	(92, 'China', 46, 2),
	(93, 'جزيرة الكريسماس', 47, 1),
	(94, 'Christmas Island', 47, 2),
	(95, 'جزر كوكوس (كيلينغ)', 48, 1),
	(96, 'Cocos (Keeling) Islands', 48, 2),
	(97, 'كولومبيا', 49, 1),
	(98, 'Colombia', 49, 2),
	(99, 'جزر القمر', 50, 1),
	(100, 'Comoros', 50, 2),
	(101, 'الكونغو', 51, 1),
	(102, 'Congo', 51, 2),
	(103, 'الكونغو ، جمهورية الكونغو الديمقراطية', 52, 1),
	(104, 'Congo, Democratic Republic of the Congo', 52, 2),
	(105, 'جزر كوك', 53, 1),
	(106, 'Cook Islands', 53, 2),
	(107, 'كوستا ريكا', 54, 1),
	(108, 'Costa Rica', 54, 2),
	(109, 'ساحل العاج', 55, 1),
	(110, 'Cote D\'Ivoire', 55, 2),
	(111, 'كرواتيا', 56, 1),
	(112, 'Croatia', 56, 2),
	(113, 'كوبا', 57, 1),
	(114, 'Cuba', 57, 2),
	(115, 'كوراكاو', 58, 1),
	(116, 'Curacao', 58, 2),
	(117, 'قبرص', 59, 1),
	(118, 'Cyprus', 59, 2),
	(119, 'الجمهورية التشيكية', 60, 1),
	(120, 'Czech Republic', 60, 2),
	(121, 'الدنمارك', 61, 1),
	(122, 'Denmark', 61, 2),
	(123, 'جيبوتي', 62, 1),
	(124, 'Djibouti', 62, 2),
	(125, 'دومينيكا', 63, 1),
	(126, 'Dominica', 63, 2),
	(127, 'جمهورية الدومنيكان', 64, 1),
	(128, 'Dominican Republic', 64, 2),
	(129, 'الاكوادور', 65, 1),
	(130, 'Ecuador', 65, 2),
	(131, 'مصر', 66, 1),
	(132, 'Egypt', 66, 2),
	(133, 'السلفادور', 67, 1),
	(134, 'El Salvador', 67, 2),
	(135, 'غينيا الإستوائية', 68, 1),
	(136, 'Equatorial Guinea', 68, 2),
	(137, 'إريتريا', 69, 1),
	(138, 'Eritrea', 69, 2),
	(139, 'إستونيا', 70, 1),
	(140, 'Estonia', 70, 2),
	(141, 'أثيوبيا', 71, 1),
	(142, 'Ethiopia', 71, 2),
	(143, 'جزر فوكلاند (مالفيناس)', 72, 1),
	(144, 'Falkland Islands (Malvinas)', 72, 2),
	(145, 'جزر فاروس', 73, 1),
	(146, 'Faroe Islands', 73, 2),
	(147, 'فيجي', 74, 1),
	(148, 'Fiji', 74, 2),
	(149, 'فنلندا', 75, 1),
	(150, 'Finland', 75, 2),
	(151, 'فرنسا', 76, 1),
	(152, 'France', 76, 2),
	(153, 'غيانا الفرنسية', 77, 1),
	(154, 'French Guiana', 77, 2),
	(155, 'بولينيزيا الفرنسية', 78, 1),
	(156, 'French Polynesia', 78, 2),
	(157, 'المناطق الجنوبية لفرنسا', 79, 1),
	(158, 'French Southern Territories', 79, 2),
	(159, 'الجابون', 80, 1),
	(160, 'Gabon', 80, 2),
	(161, 'غامبيا', 81, 1),
	(162, 'Gambia', 81, 2),
	(163, 'جورجيا', 82, 1),
	(164, 'Georgia', 82, 2),
	(165, 'ألمانيا', 83, 1),
	(166, 'Germany', 83, 2),
	(167, 'غانا', 84, 1),
	(168, 'Ghana', 84, 2),
	(169, 'جبل طارق', 85, 1),
	(170, 'Gibraltar', 85, 2),
	(171, 'اليونان', 86, 1),
	(172, 'Greece', 86, 2),
	(173, 'الأرض الخضراء', 87, 1),
	(174, 'Greenland', 87, 2),
	(175, 'غرينادا', 88, 1),
	(176, 'Grenada', 88, 2),
	(177, 'جوادلوب', 89, 1),
	(178, 'Guadeloupe', 89, 2),
	(179, 'غوام', 90, 1),
	(180, 'Guam', 90, 2),
	(181, 'غواتيمالا', 91, 1),
	(182, 'Guatemala', 91, 2),
	(183, 'غيرنسي', 92, 1),
	(184, 'Guernsey', 92, 2),
	(185, 'غينيا', 93, 1),
	(186, 'Guinea', 93, 2),
	(187, 'غينيا بيساو', 94, 1),
	(188, 'Guinea-Bissau', 94, 2),
	(189, 'غيانا', 95, 1),
	(190, 'Guyana', 95, 2),
	(191, 'هايتي', 96, 1),
	(192, 'Haiti', 96, 2),
	(193, 'قلب الجزيرة وجزر ماكدونالز', 97, 1),
	(194, 'Heard Island and McDonald Islands', 97, 2),
	(195, 'الكرسي الرسولي (دولة الفاتيكان)', 98, 1),
	(196, 'Holy See (Vatican City State)', 98, 2),
	(197, 'هندوراس', 99, 1),
	(198, 'Honduras', 99, 2),
	(199, 'هونج كونج', 100, 1),
	(200, 'Hong Kong', 100, 2),
	(201, 'هنغاريا', 101, 1),
	(202, 'Hungary', 101, 2),
	(203, 'أيسلندا', 102, 1),
	(204, 'Iceland', 102, 2),
	(205, 'الهند', 103, 1),
	(206, 'India', 103, 2),
	(207, 'إندونيسيا', 104, 1),
	(208, 'Indonesia', 104, 2),
	(209, 'جمهورية إيران الإسلامية', 105, 1),
	(210, 'Iran, Islamic Republic of', 105, 2),
	(211, 'العراق', 106, 1),
	(212, 'Iraq', 106, 2),
	(213, 'أيرلندا', 107, 1),
	(214, 'Ireland', 107, 2),
	(215, 'جزيرة آيل أوف مان', 108, 1),
	(216, 'Isle of Man', 108, 2),
	(217, 'إسرائيل', 109, 1),
	(218, 'Israel', 109, 2),
	(219, 'إيطاليا', 110, 1),
	(220, 'Italy', 110, 2),
	(221, 'جامايكا', 111, 1),
	(222, 'Jamaica', 111, 2),
	(223, 'اليابان', 112, 1),
	(224, 'Japan', 112, 2),
	(225, 'جيرسي', 113, 1),
	(226, 'Jersey', 113, 2),
	(227, 'الأردن', 114, 1),
	(228, 'Jordan', 114, 2),
	(229, 'كازاخستان', 115, 1),
	(230, 'Kazakhstan', 115, 2),
	(231, 'كينيا', 116, 1),
	(232, 'Kenya', 116, 2),
	(233, 'كيريباتي', 117, 1),
	(234, 'Kiribati', 117, 2),
	(235, 'كوريا، الجمهورية الشعبية الديمقراطية', 118, 1),
	(236, 'Korea, Democratic People\'s Republic of', 118, 2),
	(237, 'جمهورية كوريا', 119, 1),
	(238, 'Korea, Republic of', 119, 2),
	(239, 'كوسوفو', 120, 1),
	(240, 'Kosovo', 120, 2),
	(241, 'الكويت', 121, 1),
	(242, 'Kuwait', 121, 2),
	(243, 'قيرغيزستان', 122, 1),
	(244, 'Kyrgyzstan', 122, 2),
	(245, 'جمهورية لاو الديمقراطية الشعبية', 123, 1),
	(246, 'Lao People\'s Democratic Republic', 123, 2),
	(247, 'لاتفيا', 124, 1),
	(248, 'Latvia', 124, 2),
	(249, 'لبنان', 125, 1),
	(250, 'Lebanon', 125, 2),
	(251, 'ليسوتو', 126, 1),
	(252, 'Lesotho', 126, 2),
	(253, 'ليبيريا', 127, 1),
	(254, 'Liberia', 127, 2),
	(255, 'الجماهيرية العربية الليبية', 128, 1),
	(256, 'Libyan Arab Jamahiriya', 128, 2),
	(257, 'ليختنشتاين', 129, 1),
	(258, 'Liechtenstein', 129, 2),
	(259, 'ليتوانيا', 130, 1),
	(260, 'Lithuania', 130, 2),
	(261, 'لوكسمبورغ', 131, 1),
	(262, 'Luxembourg', 131, 2),
	(263, 'ماكاو', 132, 1),
	(264, 'Macao', 132, 2),
	(265, 'مقدونيا ، جمهورية يوغوسلافيا السابقة', 133, 1),
	(266, 'Macedonia, the Former Yugoslav Republic of', 133, 2),
	(267, 'مدغشقر', 134, 1),
	(268, 'Madagascar', 134, 2),
	(269, 'ملاوي', 135, 1),
	(270, 'Malawi', 135, 2),
	(271, 'ماليزيا', 136, 1),
	(272, 'Malaysia', 136, 2),
	(273, 'جزر المالديف', 137, 1),
	(274, 'Maldives', 137, 2),
	(275, 'مالي', 138, 1),
	(276, 'Mali', 138, 2),
	(277, 'مالطا', 139, 1),
	(278, 'Malta', 139, 2),
	(279, 'جزر مارشال', 140, 1),
	(280, 'Marshall Islands', 140, 2),
	(281, 'مارتينيك', 141, 1),
	(282, 'Martinique', 141, 2),
	(283, 'موريتانيا', 142, 1),
	(284, 'Mauritania', 142, 2),
	(285, 'موريشيوس', 143, 1),
	(286, 'Mauritius', 143, 2),
	(287, 'مايوت', 144, 1),
	(288, 'Mayotte', 144, 2),
	(289, 'المكسيك', 145, 1),
	(290, 'Mexico', 145, 2),
	(291, 'ولايات ميكرونيزيا الموحدة', 146, 1),
	(292, 'Micronesia, Federated States of', 146, 2),
	(293, 'جمهورية مولدوفا', 147, 1),
	(294, 'Moldova, Republic of', 147, 2),
	(295, 'موناكو', 148, 1),
	(296, 'Monaco', 148, 2),
	(297, 'منغوليا', 149, 1),
	(298, 'Mongolia', 149, 2),
	(299, 'الجبل الأسود', 150, 1),
	(300, 'Montenegro', 150, 2),
	(301, 'مونتسيرات', 151, 1),
	(302, 'Montserrat', 151, 2),
	(303, 'المغرب', 152, 1),
	(304, 'Morocco', 152, 2),
	(305, 'موزمبيق', 153, 1),
	(306, 'Mozambique', 153, 2),
	(307, 'ميانمار', 154, 1),
	(308, 'Myanmar', 154, 2),
	(309, 'ناميبيا', 155, 1),
	(310, 'Namibia', 155, 2),
	(311, 'ناورو', 156, 1),
	(312, 'Nauru', 156, 2),
	(313, 'نيبال', 157, 1),
	(314, 'Nepal', 157, 2),
	(315, 'هولندا', 158, 1),
	(316, 'Netherlands', 158, 2),
	(317, 'جزر الأنتيل الهولندية', 159, 1),
	(318, 'Netherlands Antilles', 159, 2),
	(319, 'كاليدونيا الجديدة', 160, 1),
	(320, 'New Caledonia', 160, 2),
	(321, 'نيوزيلاندا', 161, 1),
	(322, 'New Zealand', 161, 2),
	(323, 'نيكاراغوا', 162, 1),
	(324, 'Nicaragua', 162, 2),
	(325, 'النيجر', 163, 1),
	(326, 'Niger', 163, 2),
	(327, 'نيجيريا', 164, 1),
	(328, 'Nigeria', 164, 2),
	(329, 'نيوي', 165, 1),
	(330, 'Niue', 165, 2),
	(331, 'جزيرة نورفولك', 166, 1),
	(332, 'Norfolk Island', 166, 2),
	(333, 'جزر مريانا الشمالية', 167, 1),
	(334, 'Northern Mariana Islands', 167, 2),
	(335, 'النرويج', 168, 1),
	(336, 'Norway', 168, 2),
	(337, 'سلطنة عمان', 169, 1),
	(338, 'Oman', 169, 2),
	(339, 'باكستان', 170, 1),
	(340, 'Pakistan', 170, 2),
	(341, 'بالاو', 171, 1),
	(342, 'Palau', 171, 2),
	(343, 'الأراضي الفلسطينية المحتلة', 172, 1),
	(344, 'Palestinian Territory, Occupied', 172, 2),
	(345, 'بنما', 173, 1),
	(346, 'Panama', 173, 2),
	(347, 'بابوا غينيا الجديدة', 174, 1),
	(348, 'Papua New Guinea', 174, 2),
	(349, 'باراغواي', 175, 1),
	(350, 'Paraguay', 175, 2),
	(351, 'بيرو', 176, 1),
	(352, 'Peru', 176, 2),
	(353, 'فيلبيني', 177, 1),
	(354, 'Philippines', 177, 2),
	(355, 'بيتكيرن', 178, 1),
	(356, 'Pitcairn', 178, 2),
	(357, 'بولندا', 179, 1),
	(358, 'Poland', 179, 2),
	(359, 'البرتغال', 180, 1),
	(360, 'Portugal', 180, 2),
	(361, 'بورتوريكو', 181, 1),
	(362, 'Puerto Rico', 181, 2),
	(363, 'دولة قطر', 182, 1),
	(364, 'Qatar', 182, 2),
	(365, 'جمع شمل', 183, 1),
	(366, 'Reunion', 183, 2),
	(367, 'رومانيا', 184, 1),
	(368, 'Romania', 184, 2),
	(369, 'الاتحاد الروسي', 185, 1),
	(370, 'Russian Federation', 185, 2),
	(371, 'رواندا', 186, 1),
	(372, 'Rwanda', 186, 2),
	(373, 'سانت بارتيليمي', 187, 1),
	(374, 'Saint Barthelemy', 187, 2),
	(375, 'سانت هيلانة', 188, 1),
	(376, 'Saint Helena', 188, 2),
	(377, 'سانت كيتس ونيفيس', 189, 1),
	(378, 'Saint Kitts and Nevis', 189, 2),
	(379, 'القديسة لوسيا', 190, 1),
	(380, 'Saint Lucia', 190, 2),
	(381, 'القديس مارتن', 191, 1),
	(382, 'Saint Martin', 191, 2),
	(383, 'سانت بيير وميكلون', 192, 1),
	(384, 'Saint Pierre and Miquelon', 192, 2),
	(385, 'سانت فنسنت وجزر غرينادين', 193, 1),
	(386, 'Saint Vincent and the Grenadines', 193, 2),
	(387, 'ساموا', 194, 1),
	(388, 'Samoa', 194, 2),
	(389, 'سان مارينو', 195, 1),
	(390, 'San Marino', 195, 2),
	(391, 'ساو تومي وبرينسيبي', 196, 1),
	(392, 'Sao Tome and Principe', 196, 2),
	(393, 'المملكة العربية السعودية', 197, 1),
	(394, 'Saudi Arabia', 197, 2),
	(395, 'السنغال', 198, 1),
	(396, 'Senegal', 198, 2),
	(397, 'صربيا', 199, 1),
	(398, 'Serbia', 199, 2),
	(399, 'صربيا والجبل الأسود', 200, 1),
	(400, 'Serbia and Montenegro', 200, 2),
	(401, 'سيشيل', 201, 1),
	(402, 'Seychelles', 201, 2),
	(403, 'سيرا ليون', 202, 1),
	(404, 'Sierra Leone', 202, 2),
	(405, 'سنغافورة', 203, 1),
	(406, 'Singapore', 203, 2),
	(407, 'سينت مارتن', 204, 1),
	(408, 'St Martin', 204, 2),
	(409, 'سلوفاكيا', 205, 1),
	(410, 'Slovakia', 205, 2),
	(411, 'سلوفينيا', 206, 1),
	(412, 'Slovenia', 206, 2),
	(413, 'جزر سليمان', 207, 1),
	(414, 'Solomon Islands', 207, 2),
	(415, 'الصومال', 208, 1),
	(416, 'Somalia', 208, 2),
	(417, 'جنوب أفريقيا', 209, 1),
	(418, 'South Africa', 209, 2),
	(419, 'جورجيا الجنوبية وجزر ساندويتش الجنوبية', 210, 1),
	(420, 'South Georgia and the South Sandwich Islands', 210, 2),
	(421, 'جنوب السودان', 211, 1),
	(422, 'South Sudan', 211, 2),
	(423, 'إسبانيا', 212, 1),
	(424, 'Spain', 212, 2),
	(425, 'سيريلانكا', 213, 1),
	(426, 'Sri Lanka', 213, 2),
	(427, 'السودان', 214, 1),
	(428, 'Sudan', 214, 2),
	(429, 'سورينام', 215, 1),
	(430, 'Suriname', 215, 2),
	(431, 'سفالبارد وجان ماين', 216, 1),
	(432, 'Svalbard and Jan Mayen', 216, 2),
	(433, 'سوازيلاند', 217, 1),
	(434, 'Swaziland', 217, 2),
	(435, 'السويد', 218, 1),
	(436, 'Sweden', 218, 2),
	(437, 'سويسرا', 219, 1),
	(438, 'Switzerland', 219, 2),
	(439, 'الجمهورية العربية السورية', 220, 1),
	(440, 'Syrian Arab Republic', 220, 2),
	(441, 'مقاطعة تايوان الصينية', 221, 1),
	(442, 'Taiwan, Province of China', 221, 2),
	(443, 'طاجيكستان', 222, 1),
	(444, 'Tajikistan', 222, 2),
	(445, 'جمهورية تنزانيا المتحدة', 223, 1),
	(446, 'Tanzania, United Republic of', 223, 2),
	(447, 'تايلاند', 224, 1),
	(448, 'Thailand', 224, 2),
	(449, 'تيمور ليشتي', 225, 1),
	(450, 'Timor-Leste', 225, 2),
	(451, 'توجو', 226, 1),
	(452, 'Togo', 226, 2),
	(453, 'توكيلاو', 227, 1),
	(454, 'Tokelau', 227, 2),
	(455, 'تونغا', 228, 1),
	(456, 'Tonga', 228, 2),
	(457, 'ترينداد وتوباغو', 229, 1),
	(458, 'Trinidad and Tobago', 229, 2),
	(459, 'تونس', 230, 1),
	(460, 'Tunisia', 230, 2),
	(461, 'ديك رومى', 231, 1),
	(462, 'Turkey', 231, 2),
	(463, 'تركمانستان', 232, 1),
	(464, 'Turkmenistan', 232, 2),
	(465, 'جزر تركس وكايكوس', 233, 1),
	(466, 'Turks and Caicos Islands', 233, 2),
	(467, 'توفالو', 234, 1),
	(468, 'Tuvalu', 234, 2),
	(469, 'أوغندا', 235, 1),
	(470, 'Uganda', 235, 2),
	(471, 'أوكرانيا', 236, 1),
	(472, 'Ukraine', 236, 2),
	(473, 'الإمارات العربية المتحدة', 237, 1),
	(474, 'United Arab Emirates', 237, 2),
	(475, 'المملكة المتحدة', 238, 1),
	(476, 'United Kingdom', 238, 2),
	(477, 'الولايات المتحدة', 239, 1),
	(478, 'United States', 239, 2),
	(479, 'جزر الولايات المتحدة البعيدة الصغرى', 240, 1),
	(480, 'United States Minor Outlying Islands', 240, 2),
	(481, 'أوروغواي', 241, 1),
	(482, 'Uruguay', 241, 2),
	(483, 'أوزبكستان', 242, 1),
	(484, 'Uzbekistan', 242, 2),
	(485, 'فانواتو', 243, 1),
	(486, 'Vanuatu', 243, 2),
	(487, 'فنزويلا', 244, 1),
	(488, 'Venezuela', 244, 2),
	(489, 'فييت نام', 245, 1),
	(490, 'Viet Nam', 245, 2),
	(491, 'جزر العذراء البريطانية', 246, 1),
	(492, 'Virgin Islands, British', 246, 2),
	(493, 'جزر فيرجن ، الولايات المتحدة', 247, 1),
	(494, 'Virgin Islands, U.s.', 247, 2),
	(495, 'واليس وفوتونا', 248, 1),
	(496, 'Wallis and Futuna', 248, 2),
	(497, 'الصحراء الغربية', 249, 1),
	(498, 'Western Sahara', 249, 2),
	(499, 'اليمن', 250, 1),
	(500, 'Yemen', 250, 2),
	(501, 'زامبيا', 251, 1),
	(502, 'Zambia', 251, 2),
	(503, 'زيمبابوي', 252, 1),
	(504, 'Zimbabwe', 252, 2),
	(505, 'أفغانستان', 253, 1),
	(506, 'Afghanistan', 253, 2);

-- Dumping structure for table nader_db.dropdown1_options
CREATE TABLE IF NOT EXISTS `dropdown1_options` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf16 COLLATE=utf16_general_ci;

-- Dumping data for table nader_db.dropdown1_options: ~2 rows (approximately)
INSERT INTO `dropdown1_options` (`id`, `name`) VALUES
	(1, 'Option 1'),
	(2, 'Option 2');

-- Dumping structure for table nader_db.dropdown2_options
CREATE TABLE IF NOT EXISTS `dropdown2_options` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `dropdown1_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dropdown1_id` (`dropdown1_id`),
  CONSTRAINT `dropdown2_options_ibfk_1` FOREIGN KEY (`dropdown1_id`) REFERENCES `dropdown1_options` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf16 COLLATE=utf16_general_ci;

-- Dumping data for table nader_db.dropdown2_options: ~3 rows (approximately)
INSERT INTO `dropdown2_options` (`id`, `name`, `dropdown1_id`) VALUES
	(1, 'Option 1.1', 1),
	(2, 'Option 1.2', 1),
	(3, 'Option 2.1', 2);

-- Dumping structure for table nader_db.failed_jobs
CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext 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;

-- Dumping data for table nader_db.failed_jobs: ~0 rows (approximately)

-- Dumping structure for table nader_db.features
CREATE TABLE IF NOT EXISTS `features` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(150) DEFAULT NULL,
  `date_from` date DEFAULT NULL,
  `date_to` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table nader_db.features: ~6 rows (approximately)
INSERT INTO `features` (`id`, `image`, `date_from`, `date_to`, `created_at`, `type`, `updated_at`, `deleted_at`) VALUES
	(72, 'storage/photos/shares/12345.jpg', '2024-11-10', '2024-11-20', '2024-11-15 00:29:58', '1', '2024-11-15 00:46:16', NULL),
	(73, 'storage/photos/shares/3.jpg', '2024-11-11', '2024-11-16', '2024-11-15 12:18:52', '1', '2024-11-15 15:57:07', NULL),
	(74, 'storage/photos/shares/3.jpg', NULL, '2024-11-14', '2024-11-15 16:01:10', '2', '2024-11-15 17:12:11', NULL),
	(75, 'storage/photos/shares/370632485_122126490164002835_7814470262877211187_n.jpg', '2024-11-12', '2024-11-19', '2024-11-15 16:05:55', '2', '2024-11-15 16:50:10', NULL),
	(76, 'storage/photos/shares/4.jpg', '2024-11-03', '2024-11-17', '2024-11-15 16:17:25', '2', '2024-11-15 16:17:25', NULL),
	(77, 'storage/photos/shares/370632485_122126490164002835_7814470262877211187_n.jpg', '2024-11-01', '2024-11-26', '2024-11-15 16:39:58', '1', '2024-11-15 16:40:49', NULL);

-- Dumping structure for table nader_db.feature_descriptions
CREATE TABLE IF NOT EXISTS `feature_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `address` varchar(200) DEFAULT NULL,
  `title` varchar(200) DEFAULT NULL,
  `content` varchar(200) DEFAULT NULL,
  `description` varchar(2000) DEFAULT NULL,
  `feature_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `choose_descriptions_choose_id_foreign` (`feature_id`) USING BTREE,
  KEY `choose_descriptions_language_id_foreign` (`language_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=205 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table nader_db.feature_descriptions: ~12 rows (approximately)
INSERT INTO `feature_descriptions` (`id`, `address`, `title`, `content`, `description`, `feature_id`, `language_id`) VALUES
	(181, '0', '666', '520', NULL, 72, 1),
	(182, '0', '777', '410', NULL, 72, 2),
	(185, '0', 'ساره', 'المحتوي (Arabic)2', NULL, 73, 1),
	(186, '0', 'sara', 'المحتوي (English)2', NULL, 73, 2),
	(195, '111', '333', '555', NULL, 76, 1),
	(196, '2222', '444', '666', NULL, 76, 2),
	(199, '555', 'ساره', '777', NULL, 77, 1),
	(200, '666', 'sara', '888', NULL, 77, 2),
	(201, '0', 'احمد', '5556', NULL, 75, 1),
	(202, '0', 'ahmed', '6665', NULL, 75, 2),
	(203, '0', 'باشا', '111', NULL, 74, 1),
	(204, '0', 'basha', '222', NULL, 74, 2);

-- Dumping structure for table nader_db.languages
CREATE TABLE IF NOT EXISTS `languages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `local` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'whether the language is active in the website or not, 1-> is active',
  `admin_status` tinyint(4) NOT NULL DEFAULT 1 COMMENT 'whether the language is active in the dashboard or not, 1-> is active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `languages_local_unique` (`local`),
  KEY `languages_status_index` (`status`),
  KEY `languages_admin_status_index` (`admin_status`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.languages: ~2 rows (approximately)
INSERT INTO `languages` (`id`, `local`, `name`, `status`, `admin_status`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(1, 'ar', 'Arabic', 1, 1, NULL, NULL, NULL),
	(2, 'en', 'English', 1, 1, NULL, NULL, NULL);

-- Dumping structure for table nader_db.mail_lists
CREATE TABLE IF NOT EXISTS `mail_lists` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `send_to` varchar(191) DEFAULT NULL,
  `subject` varchar(191) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `categories` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mail_lists_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.mail_lists: ~0 rows (approximately)

-- Dumping structure for table nader_db.migrations
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.migrations: ~40 rows (approximately)
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(1, '2014_10_12_100000_create_password_reset_tokens_table', 1),
	(2, '2019_08_19_000000_create_failed_jobs_table', 1),
	(3, '2019_12_14_000001_create_personal_access_tokens_table', 1),
	(4, '2024_07_02_130330_create_users_table', 1),
	(5, '2024_07_02_132852_create_modules_table', 1),
	(6, '2024_07_02_132945_create_user_modules_table', 1),
	(7, '2024_07_02_144431_create_settings_table', 1),
	(8, '2024_07_02_150704_create_languages_table', 1),
	(9, '2024_07_02_165131_create_categories_table', 1),
	(10, '2024_07_02_165304_create_articles_table', 1),
	(11, '2024_07_02_170030_create_article_descriptions_table', 1),
	(12, '2024_07_02_170334_create_website_visitors_table', 1),
	(13, '2024_07_03_231744_create_careers_table', 1),
	(14, '2024_07_03_231903_create_career_descriptions_table', 1),
	(15, '2024_07_03_235803_create_visitor_jobs_table', 1),
	(16, '2024_07_10_212553_create_category_descriptions_table', 1),
	(17, '2024_07_10_213318_create_pages_table', 1),
	(18, '2024_07_10_214901_create_partners_table', 1),
	(19, '2024_07_10_220642_create_services_table', 1),
	(20, '2024_07_10_220821_create_service_descriptions_table', 1),
	(21, '2024_07_10_221157_create_photo_categories_table', 1),
	(22, '2024_07_10_221319_create_photo_category_descriptions_table', 1),
	(23, '2024_07_11_145037_create_partner_descriptions_table', 1),
	(24, '2024_07_11_145646_create_newsletters_table', 1),
	(25, '2024_07_12_111219_create_clients_table', 1),
	(26, '2024_07_12_111440_create_client_descriptions_table', 1),
	(27, '2024_07_12_144054_create_website_disabled_table', 1),
	(28, '2024_07_13_100901_create_partner_photos_table', 1),
	(29, '2024_07_14_091333_add_title_to_visitor_jobs', 1),
	(30, '2024_07_14_152345_create_photos_table', 1),
	(31, '2024_07_14_153005_create_photo_descriptions_table', 1),
	(32, '2024_07_15_161932_create_visitor_messages_table', 1),
	(33, '2024_07_15_162302_create_visitor_emails_table', 1),
	(34, '2024_07_15_165727_create_mail_lists_table', 1),
	(35, '2024_07_17_005642_add_youtube_url_to_photo_table', 1),
	(36, '2024_07_17_150917_create_page_descriptions_table', 1),
	(37, '2024_07_17_151442_create_banners_table', 1),
	(38, '2024_07_17_152152_create_banner_descriptions_table', 1),
	(39, '2024_07_18_093954_create_numbers_table', 1),
	(40, '2024_07_18_094250_create_number_descriptions_table', 1);

-- Dumping structure for table nader_db.modules
CREATE TABLE IF NOT EXISTS `modules` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `path` varchar(50) NOT NULL,
  `meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `sort` bigint(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



-- Dumping structure for table nader_db.news
CREATE TABLE IF NOT EXISTS `news` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint(20) unsigned DEFAULT NULL,
  `image` varchar(250) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `news_category_id_foreign` (`category_id`),
  CONSTRAINT `news_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table nader_db.news: ~4 rows (approximately)
INSERT INTO `news` (`id`, `category_id`, `image`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(41, NULL, NULL, '2024-11-14 20:27:22', '2024-11-14 20:27:22', NULL),
	(42, NULL, NULL, '2024-11-14 21:52:11', '2024-11-14 21:52:11', NULL),
	(43, NULL, NULL, '2024-11-14 21:53:31', '2024-11-14 21:53:31', NULL),
	(44, NULL, NULL, '2024-11-14 22:47:07', '2024-11-14 22:55:01', NULL);

-- Dumping structure for table nader_db.newsletters
CREATE TABLE IF NOT EXISTS `newsletters` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_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=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.newsletters: ~15 rows (approximately)
INSERT INTO `newsletters` (`id`, `email`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(1, 'store@store.com', NULL, '2024-04-22 17:26:18', '2024-04-22 17:26:18'),
	(2, 'khalidbehis@gmail.com', NULL, '2024-04-23 10:46:14', '2024-04-23 10:46:14'),
	(3, 'mostafa@gmail.com', NULL, '2024-04-23 13:21:25', '2024-04-23 13:21:25'),
	(4, 'consult@admin.com', NULL, '2024-04-23 13:21:29', '2024-04-23 13:21:29'),
	(5, 'behiskhalid@gmail.com', NULL, '2024-04-23 13:21:35', '2024-04-23 13:28:40'),
	(6, '1234@gmail.com', '2024-04-24 12:44:15', '2024-04-24 12:35:36', '2024-04-24 12:44:15'),
	(12, 'yomna@yahoo.com', NULL, '2024-07-26 18:13:54', '2024-07-26 18:13:54'),
	(13, 'ahmed@gghh.com', NULL, '2024-07-28 05:08:41', '2024-07-28 05:08:41'),
	(14, 'yomn2a@yahoo.com', NULL, '2024-07-28 05:16:10', '2024-07-28 05:16:10'),
	(15, 'aboro2a83@gmail.com', NULL, '2024-07-28 05:26:31', '2024-07-28 05:26:31'),
	(16, 'yomna3@yahoo.com', NULL, '2024-07-28 05:27:36', '2024-07-28 05:27:36'),
	(17, 'abo888ro2a83@gmail.com', NULL, '2024-07-28 05:31:23', '2024-07-28 05:31:23'),
	(18, 'mah_zanaty@yahoo.com', NULL, '2024-07-28 05:32:15', '2024-07-28 05:32:15'),
	(19, 'test@testt.com', NULL, '2024-07-28 15:33:16', '2024-07-28 15:33:16'),
	(20, 'mah@yahoo.com', NULL, '2024-07-28 15:35:33', '2024-07-28 15:35:33');

-- Dumping structure for table nader_db.news_descriptions
CREATE TABLE IF NOT EXISTS `news_descriptions` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `news_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `news_descriptions_language_id_foreign` (`language_id`),
  KEY `news_descriptions_news_id_foreign` (`news_id`),
  CONSTRAINT `news_descriptions_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `news_descriptions_news_id_foreign` FOREIGN KEY (`news_id`) REFERENCES `news` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=153 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table nader_db.news_descriptions: ~8 rows (approximately)
INSERT INTO `news_descriptions` (`id`, `title`, `description`, `news_id`, `language_id`) VALUES
	(141, 'ساره', 'تست', 41, 1),
	(142, 'sara', 'test', 41, 2),
	(143, 'محمود', 'تست2', 42, 1),
	(144, 'mahmoud', 'test2', 42, 2),
	(145, 'احمد', 'تست3', 43, 1),
	(146, 'ahmed', 'test3', 43, 2),
	(151, 'مالك', '<p>تست 5</p>', 44, 1),
	(152, 'malek', '<p>test5</p>', 44, 2);

-- Dumping structure for table nader_db.numbers
CREATE TABLE IF NOT EXISTS `numbers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `counter` bigint(20) DEFAULT NULL,
  `image` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.numbers: ~3 rows (approximately)
INSERT INTO `numbers` (`id`, `counter`, `image`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 15, 'storage/photos/shares/statics-2.svg', '2024-07-18 04:53:12', '2024-07-25 14:04:42', NULL),
	(2, 500, 'storage/photos/shares/statics-1.svg', '2024-07-21 05:28:38', '2024-07-25 14:04:03', NULL),
	(3, 20, 'storage/photos/shares/statics-3.svg', '2024-07-25 10:08:12', '2024-07-29 17:45:51', NULL);

-- Dumping structure for table nader_db.number_descriptions
CREATE TABLE IF NOT EXISTS `number_descriptions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(150) DEFAULT NULL,
  `number_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `number_descriptions_number_id_index` (`number_id`),
  KEY `number_descriptions_language_id_index` (`language_id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table nader_db.number_descriptions: ~6 rows (approximately)
INSERT INTO `number_descriptions` (`id`, `title`, `number_id`, `language_id`) VALUES
	(13, 'عميل', 2, 1),
	(14, 'client', 2, 2),
	(25, 'موقع', 1, 1),
	(26, 'location', 1, 2),
	(27, 'تطبيق جوال', 3, 1),
	(28, 'mobileApp', 3, 2);

-- Dumping structure for table nader_db.pages
CREATE TABLE IF NOT EXISTS `pages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(200) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `image_2` varchar(150) DEFAULT NULL,
  `image_3` varchar(150) DEFAULT NULL,
  `image_4` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.pages: ~7 rows (approximately)
INSERT INTO `pages` (`id`, `image`, `status`, `deleted_at`, `created_at`, `updated_at`, `image_2`, `image_3`, `image_4`) VALUES
	(2, 'storage/photos/shares/12345.jpg', 1, NULL, '2024-04-14 08:02:46', '2024-11-08 09:23:49', NULL, NULL, NULL),
	(3, 'storage/photos/shares/1.jpg', 1, '2024-11-08 08:08:49', '2024-04-14 08:03:22', '2024-10-12 07:06:06', 'storage/photos/shares/1111.jpg', 'storage/photos/shares/22222.jpg', NULL),
	(5, NULL, 1, NULL, '2024-04-14 08:04:15', '2024-04-14 08:04:15', NULL, NULL, NULL),
	(6, NULL, 1, NULL, '2024-04-14 08:04:54', '2024-04-14 08:04:54', NULL, NULL, NULL),
	(7, NULL, 1, NULL, '2024-04-14 08:05:13', '2024-04-14 08:05:13', NULL, NULL, NULL),
	(9, 'storage/photos/shares/800px-Sunflower_from_Silesia2.jpg', 1, '2024-11-08 08:08:08', '2024-04-14 08:05:49', '2024-10-12 07:15:46', NULL, NULL, NULL),
	(10, 'storage/photos/shares/6.jpg', 1, '2024-07-29 17:29:02', '2024-04-14 08:05:49', '2024-05-22 06:16:12', 'storage/photos/shares/test.PNG', 'storage/photos/shares/test2.PNG', NULL);

-- Dumping structure for table nader_db.page_descriptions
CREATE TABLE IF NOT EXISTS `page_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(500) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `slug` varchar(100) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `keywords` varchar(400) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `page_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  `vision` longtext DEFAULT NULL,
  `vision_title` longtext DEFAULT NULL,
  `message` longtext DEFAULT NULL,
  `message_title` longtext DEFAULT NULL,
  `value` longtext DEFAULT NULL,
  `goal` text DEFAULT NULL,
  `goal_title` text DEFAULT NULL,
  `brief` longtext DEFAULT NULL,
  `no1` text DEFAULT NULL,
  `no2` text DEFAULT NULL,
  `no3` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `page_descriptions_page_id_foreign` (`page_id`),
  KEY `page_descriptions_language_id_foreign` (`language_id`)
) ENGINE=InnoDB AUTO_INCREMENT=559 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.page_descriptions: ~12 rows (approximately)
INSERT INTO `page_descriptions` (`id`, `title`, `name`, `slug`, `meta_description`, `keywords`, `description`, `page_id`, `language_id`, `vision`, `vision_title`, `message`, `message_title`, `value`, `goal`, `goal_title`, `brief`, `no1`, `no2`, `no3`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(357, 'ارقامنا', '', 'ارقامنا', 'ارقامنا', 'ارقامنا', '', 10, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(358, 'our Numbers', '', 'our Numbers', 'our Numbers', 'our Numbers', '', 10, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(535, 'رئيس مجلس الاداره', 'محمود230555', NULL, NULL, NULL, '<p>33332555</p>', 9, 1, '', '', '', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL),
	(536, 'ceo', 'Mahmoud23555', NULL, NULL, NULL, '<p>44423555</p>', 9, 2, '', '', '', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL),
	(539, 'بطاقات الرؤية والرسالة والاهداف والقيم33', NULL, NULL, NULL, NULL, '', 3, 1, '<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p" style="text-align: center;">\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p">\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p">\r\n<p style="text-align: right;">أكبر من حصولك على تصميم موقع أو انشاء متجر</p>\r\n<p style="text-align: right;">الكتروني لا يعرفه أحد !!. نحن نعمل على إدارة العلامة</p>\r\n<p style="text-align: right;">التجارية لشركتك باحترافية. من تصميم الهوية، أكبر من حصولك</p>\r\n<p style="text-align: right;">العلامة التجارية لشركتك باحترافية. من تصميم الهوية،</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<div class="col-lg-4" style="text-align: right;">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="d-flex align-items-center mb-4">\r\n<div class="icon_box">&nbsp;</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<h5 style="text-align: right;">&nbsp;</h5>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="d-flex align-items-center mb-4">\r\n<h5 class="icon_box" style="text-align: right;">&nbsp;</h5>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>', 'الرؤية2', '<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p" style="text-align: right;">\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p">\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p" style="text-align: center;">\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p">\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p">\r\n<p style="text-align: right;">أكبر من حصولك على تصميم موقع أو انشاء متجر</p>\r\n<p style="text-align: right;">الكتروني لا يعرفه أحد !!. نحن نعمل على إدارة العلامة</p>\r\n<p style="text-align: right;">التجارية لشركتك باحترافية. من تصميم الهوية، أكبر من حصولك</p>\r\n<p style="text-align: right;">العلامة التجارية لشركتك باحترافية. من تصميم الهوية،</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<div class="col-lg-4" style="text-align: right;">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="d-flex align-items-center mb-4">\r\n<div class="icon_box">&nbsp;</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<h5 style="text-align: right;">&nbsp;</h5>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="d-flex align-items-center mb-4">\r\n<h5 class="icon_box" style="text-align: right;">&nbsp;</h5>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="d-flex align-items-center mb-4">\r\n<div class="icon_box">&nbsp;</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="d-flex align-items-center mb-4">\r\n<div class="icon_box" style="text-align: right;">&nbsp;</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>', 'الرسالة2', '', '<section class="about_cards section">\r\n<div class="container">\r\n<div class="row">\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p" style="text-align: right;">\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p">\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p" style="text-align: center;">\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p">\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="p">\r\n<p style="text-align: right;">أكبر من حصولك على تصميم موقع أو انشاء متجر</p>\r\n<p style="text-align: right;">الكتروني لا يعرفه أحد !!. نحن نعمل على إدارة العلامة</p>\r\n<p style="text-align: right;">التجارية لشركتك باحترافية. من تصميم الهوية، أكبر من حصولك</p>\r\n<p style="text-align: right;">العلامة التجارية لشركتك باحترافية. من تصميم الهوية،</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<div class="col-lg-4" style="text-align: right;">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="d-flex align-items-center mb-4">\r\n<div class="icon_box">&nbsp;</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<h5 style="text-align: right;">&nbsp;</h5>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<div class="col-lg-4">\r\n<div class="about_card">\r\n<div class="content">\r\n<div class="d-flex align-items-center mb-4">\r\n<h5 class="icon_box" style="text-align: right;">&nbsp;</h5>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</section>', 'عنوان الهدف 2', '', NULL, NULL, NULL, NULL, NULL, NULL),
	(540, 'Vision Cards, Message, Goals and Values', NULL, NULL, NULL, NULL, '', 3, 2, '<p>It is more than getting a website design or creating an online store that no one knows about!! We work on managing your company\'s brand professionally. From identity design, it is more than getting your company\'s brand professionally. From identity design,</p>', 'Vission2', '<p>It is more than getting a website design or creating an online store that no one knows about!! We work on managing your company\'s brand professionally. From identity design, it is more than getting your company\'s brand professionally. From identity design,</p>', 'Mission2', '', '<p>It is more than getting a website design or creating an online store that no one knows about!! We work on managing your company\'s brand professionally. From identity design, it is more than getting your company\'s brand professionally. From identity design,</p>', 'goal_title 2', '', NULL, NULL, NULL, NULL, NULL, NULL),
	(551, '<p>الشروط والاحكام5555</p>', NULL, NULL, NULL, NULL, '<p style="text-align: right;">55هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع الفقرات في الصفحة التي يقرأها. ولذلك يتم استخدام طريقة لوريم إيبسوم لأنها تعطي توزيعاَ طبيعياَ -إلى حد ما- للأحرف عوضاً عن استخدام "هنا يوجد محتوى نصي، هنا يوجد محتوى نصي" فتجعلها تبدو (أي الأحرف) وكأنها نص مقروء. العديد من برامح النشر المكتبي وبرامح تحرير صفحات الويب تستخدم لوريم إيبسوم بشكل إفتراضي كنموذج عن النص، وإذا قمت بإدخال "lorem ipsum" في أي محرك بحث ستظهر العديد من المواقع الحديثة العهد في نتائج البحث. على مدى السنين ظهرت نسخ جديدة ومختلفة من نص لوريم إيبسوم، أحياناً عن طريق الصدفة، وأحياناً عن عمد كإدخال بعض العبارات الفكاهية إليها.</p>\r\n<p style="text-align: right;">هنالك العديد من الأنواع المتوفرة لنصوص لوريم إيبسوم، ولكن الغالبية تم تعديلها بشكل ما بعض النوادر أو الكلمات العشوائية إلى النص. إن</p>\r\n<p style="text-align: right;">&nbsp;كنت تريد أن تستخدم نص لوريم إيبسوم ما، عليك أن تتحقق أولاً أن ليس هناك أي كلمات أو عبارات محرجة أو غير لائقة مخبأة في هذا النص. بينما تعمل</p>\r\n<p style="text-align: right;">جميع مولّدات نصوص لوريم إيبسوم على الإنترنت على إعادة تكرار مقاطع من نص لوريم إيبسوم نفسه عدة مرات بما تتطلبه الحاجة، يقوم مولّدنا هذا</p>\r\n<p style="text-align: right;">&nbsp;باستخدام كلمات من قاموس يحوي على أكثر من 200 كلمة لا تينية، مضاف إليها مجموعة من الجمل النموذجية، لتكوين نص لوريم إيبسوم ذو شكل</p>\r\n<p style="text-align: right;">&nbsp;منطقي قريب إلى النص الحقيقي. وبالتالي يكون النص الناتح خالي من التكرار، أو أي كلمات أو عبارات غير لائقة أو ما شابه. وهذا ما يجعله أول مولّد نص</p>\r\n<p style="text-align: right;">&nbsp;لوريم إيبسوم حقيقي على الإنترنت .اكبر من حصولك على تصميم موقع أو انشاء متجر الكتروني لا يعرفه أحد !!.&nbsp; نحن نعمل على إدارة العلامة التجارية</p>\r\n<p style="text-align: right;">&nbsp;لشركتك باحترافية. من تصميم الهوية،تبويب مؤسسة سعودية متخصصة في مجال تصميم البرمجيات الخاصة وحلول الفوترة الإلكترونية ونظم المال</p>\r\n<p style="text-align: right;">والأعمال وتصميم مواقع الويب وتطبيقات الهواتف الذكية.</p>', 5, 1, '', '', '', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL),
	(552, '<p>Terms And Conditions55</p>', NULL, NULL, NULL, NULL, '<p>55It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many new web sites in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like). There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, injected humour, or randomised words which don\'t look even slightly believable. If</p>\r\n<p>you want to use a Lorem Ipsum text, you need to first check that there aren\'t any embarrassing or inappropriate words or phrases hidden in the middle of text. While</p>\r\n<p>all the Lorem Ipsum generators on the Internet re-create chunks of the same Lorem Ipsum text as necessary, this one</p>\r\n<p>uses words from a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum text that looks</p>\r\n<p>logically close to the real text. The resulting text is therefore free of repetition, inappropriate words or phrases, etc. This makes it the first real</p>\r\n<p>Lorem Ipsum generator on the Internet. Greater than getting a website design or creating an online store that no one knows!! We work on managing the brand</p>\r\n<p>of your company professionally. From identity design, Tabweb is a Saudi company specialized in designing special software, electronic billing solutions, financial systems, business, and designing websites and smart phone applications.</p>', 5, 2, '', '', '', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL),
	(555, 'من نحن2222', NULL, NULL, NULL, NULL, '<p>55555</p>', 2, 1, '', '', '', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL),
	(556, 'About Us222', NULL, NULL, NULL, NULL, '<p>66666</p>', 2, 2, '', '', '', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL),
	(557, '<p>سياسة الخصوصية777</p>', NULL, NULL, NULL, NULL, '<p style="text-align: right;">772هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع الفقرات في الصفحة التي يقرأها. ولذلك يتم استخدام طريقة لوريم إيبسوم لأنها تعطي توزيعاَ طبيعياَ -إلى حد ما- للأحرف عوضاً عن استخدام "هنا يوجد محتوى نصي، هنا يوجد محتوى نصي" فتجعلها تبدو (أي الأحرف) وكأنها نص مقروء. العديد من برامح النشر المكتبي وبرامح تحرير صفحات الويب تستخدم لوريم إيبسوم بشكل إفتراضي كنموذج عن النص، وإذا قمت بإدخال "lorem ipsum" في أي محرك بحث ستظهر العديد من المواقع الحديثة العهد في نتائج البحث. على مدى السنين ظهرت نسخ جديدة ومختلفة من نص لوريم إيبسوم، أحياناً عن طريق الصدفة، وأحياناً عن عمد كإدخال بعض العبارات الفكاهية إليها.</p>\r\n<p style="text-align: right;">هنالك العديد من الأنواع المتوفرة لنصوص لوريم إيبسوم، ولكن الغالبية تم تعديلها بشكل ما بعض النوادر أو الكلمات العشوائية إلى النص. إن</p>\r\n<p style="text-align: right;">&nbsp;كنت تريد أن تستخدم نص لوريم إيبسوم ما، عليك أن تتحقق أولاً أن ليس هناك أي كلمات أو عبارات محرجة أو غير لائقة مخبأة في هذا النص. بينما تعمل</p>\r\n<p style="text-align: right;">جميع مولّدات نصوص لوريم إيبسوم على الإنترنت على إعادة تكرار مقاطع من نص لوريم إيبسوم نفسه عدة مرات بما تتطلبه الحاجة، يقوم مولّدنا هذا</p>\r\n<p style="text-align: right;">&nbsp;باستخدام كلمات من قاموس يحوي على أكثر من 200 كلمة لا تينية، مضاف إليها مجموعة من الجمل النموذجية، لتكوين نص لوريم إيبسوم ذو شكل</p>\r\n<p style="text-align: right;">&nbsp;منطقي قريب إلى النص الحقيقي. وبالتالي يكون النص الناتح خالي من التكرار، أو أي كلمات أو عبارات غير لائقة أو ما شابه. وهذا ما يجعله أول مولّد نص</p>\r\n<p style="text-align: right;">&nbsp;لوريم إيبسوم حقيقي على الإنترنت .اكبر من حصولك على تصميم موقع أو انشاء متجر الكتروني لا يعرفه أحد !!.&nbsp; نحن نعمل على إدارة العلامة التجارية</p>\r\n<p style="text-align: right;">&nbsp;لشركتك باحترافية. من تصميم الهوية،تبويب مؤسسة سعودية متخصصة في مجال تصميم البرمجيات الخاصة وحلول الفوترة الإلكترونية ونظم المال</p>\r\n<p style="text-align: right;">والأعمال وتصميم مواقع الويب وتطبيقات الهواتف الذكية.</p>', 7, 1, '', '', '', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL),
	(558, '<p>Privacy Policy77</p>', NULL, NULL, NULL, NULL, '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem 77Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many new web sites in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like). There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, injected humour, or randomised words which don\'t look even slightly believable. If</p>\r\n<p>you want to use a Lorem Ipsum text, you need to first check that there aren\'t any embarrassing or inappropriate words or phrases hidden in the middle of text. While</p>\r\n<p>all the Lorem Ipsum generators on the Internet re-create chunks of the same Lorem Ipsum text as necessary, this one</p>\r\n<p>uses words from a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum text that looks</p>\r\n<p>logically close to the real text. The resulting text is therefore free of repetition, inappropriate words or phrases, etc. This makes it the first real</p>\r\n<p>Lorem Ipsum generator on the Internet. Greater than getting a website design or creating an online store that no one knows!! We work on managing the brand</p>\r\n<p>of your company professionally. From identity design, Tabweb is a Saudi company specialized in designing special software, electronic billing solutions, financial systems, business, and designing websites and smart phone applications.</p>', 7, 2, '', '', '', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL);

-- Dumping structure for table nader_db.partners
CREATE TABLE IF NOT EXISTS `partners` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.partners: ~14 rows (approximately)
INSERT INTO `partners` (`id`, `image`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, NULL, '2024-07-26 04:21:53', '2024-07-26 04:21:53', NULL),
	(2, NULL, '2024-07-26 04:23:12', '2024-07-26 04:23:12', NULL),
	(3, NULL, '2024-07-26 04:23:57', '2024-07-26 04:23:57', NULL),
	(4, NULL, '2024-07-26 04:24:31', '2024-07-26 04:24:31', NULL),
	(5, NULL, '2024-07-26 05:10:41', '2024-07-28 06:52:49', NULL),
	(6, NULL, '2024-07-26 05:15:58', '2024-07-28 06:46:33', NULL),
	(9, NULL, '2024-10-11 06:02:47', '2024-10-11 06:02:47', NULL),
	(10, 'storage/photos/shares/3.jpg', '2024-10-11 06:06:06', '2024-10-11 06:07:03', NULL),
	(11, 'storage/photos/shares/12345.jpg', '2024-10-11 06:14:20', '2024-10-11 06:14:20', NULL),
	(12, 'storage/photos/shares/12345.jpg', '2024-10-11 06:14:59', '2024-10-11 06:14:59', NULL),
	(13, 'storage/photos/shares/3.jpg', '2024-10-11 06:15:38', '2024-10-11 06:33:10', NULL),
	(14, 'storage/photos/shares/3.jpg', '2024-10-11 06:33:59', '2024-10-11 06:34:14', NULL),
	(15, 'storage/photos/shares/12345.jpg', '2024-10-13 11:06:51', '2024-10-13 11:06:51', NULL),
	(16, 'storage/photos/shares/800px-Sunflower_from_Silesia2.jpg', '2024-10-21 08:51:34', '2024-10-21 08:53:17', NULL);

-- Dumping structure for table nader_db.partner_descriptions
CREATE TABLE IF NOT EXISTS `partner_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(150) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `partner_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `partner_descriptions_partner_id_foreign` (`partner_id`),
  KEY `partner_descriptions_language_id_foreign` (`language_id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.partner_descriptions: ~12 rows (approximately)
INSERT INTO `partner_descriptions` (`id`, `title`, `description`, `partner_id`, `language_id`, `created_at`, `updated_at`) VALUES
	(1, 'مؤسسة ينابع الحلول لتقنية المعلومات', NULL, 1, 1, NULL, NULL),
	(2, 'امازون', NULL, 2, 1, NULL, NULL),
	(3, 'جوجل كلود', NULL, 3, 1, NULL, NULL),
	(4, 'ليزر', NULL, 4, 1, NULL, NULL),
	(5, 'مؤسسة ينابع الحلول لتقنية المعلومات 2', NULL, 5, 1, NULL, NULL),
	(6, 'امازون', NULL, 6, 1, NULL, NULL),
	(11, 'مالك', NULL, 9, 1, NULL, NULL),
	(13, '111222', NULL, 10, 1, NULL, NULL),
	(17, '556655', NULL, 13, 1, NULL, NULL),
	(19, '99977', NULL, 14, 1, NULL, NULL),
	(20, 'عنوان', NULL, 15, 1, NULL, NULL),
	(22, '555666', NULL, 16, 1, NULL, NULL);

-- Dumping structure for table nader_db.partner_photos
CREATE TABLE IF NOT EXISTS `partner_photos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(250) DEFAULT NULL,
  `partner_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `partner_photos_partner_id_foreign` (`partner_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.partner_photos: ~6 rows (approximately)
INSERT INTO `partner_photos` (`id`, `image`, `partner_id`, `created_at`, `updated_at`) VALUES
	(1, 'storage/photos/shares/partner-1.svg', 1, NULL, NULL),
	(2, 'storage/photos/shares/partner-2.svg', 2, NULL, NULL),
	(3, 'storage/photos/shares/partner-3.svg', 3, NULL, NULL),
	(4, 'storage/photos/shares/partner-4.svg', 4, NULL, NULL),
	(5, 'storage/photos/shares/partner-1.svg', 5, NULL, NULL),
	(6, 'storage/photos/shares/partner-2.svg', 6, NULL, NULL);

-- Dumping structure for table nader_db.password_reset_tokens
CREATE TABLE IF NOT EXISTS `password_reset_tokens` (
  `email` varchar(191) NOT NULL,
  `token` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.password_reset_tokens: ~0 rows (approximately)

-- Dumping structure for table nader_db.personal_access_tokens
CREATE TABLE IF NOT EXISTS `personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(191) NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_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;

-- Dumping data for table nader_db.personal_access_tokens: ~0 rows (approximately)

-- Dumping structure for table nader_db.photos
CREATE TABLE IF NOT EXISTS `photos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `youtube_url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `photo_category_id` bigint(20) unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `photos_photo_category_id_index` (`photo_category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.photos: ~1 rows (approximately)
INSERT INTO `photos` (`id`, `image`, `youtube_url`, `photo_category_id`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(36, 'storage/photos/shares/12345.jpg', '5555', NULL, NULL, '2024-10-11 17:36:40', '2024-10-11 17:36:40');

-- Dumping structure for table nader_db.photo_categories
CREATE TABLE IF NOT EXISTS `photo_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `show_in` tinyint(4) DEFAULT 0,
  `image` varchar(200) DEFAULT NULL,
  `youtube_url` varchar(200) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.photo_categories: ~8 rows (approximately)
INSERT INTO `photo_categories` (`id`, `show_in`, `image`, `youtube_url`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(51, 2, 'storage/photos/shares/12345.jpg', '6080', '2024-10-11 18:22:43', '2024-10-11 18:22:43', NULL),
	(53, 1, 'storage/photos/shares/Screenshot_2023-09-29_102217.png', NULL, '2024-10-11 19:41:03', '2024-10-16 09:09:08', '2024-10-16 09:09:08'),
	(54, 2, NULL, NULL, '2024-10-16 09:08:34', '2024-10-16 09:09:02', '2024-10-16 09:09:02'),
	(55, 1, NULL, NULL, '2024-10-16 09:11:00', '2024-10-16 09:11:09', '2024-10-16 09:11:09'),
	(56, 1, NULL, NULL, '2024-10-16 09:13:38', '2024-10-16 09:13:42', '2024-10-16 09:13:42'),
	(57, 1, 'storage/photos/shares/12345.jpg', NULL, '2024-10-16 11:56:08', '2024-10-16 11:56:08', NULL),
	(58, 2, 'storage/photos/shares/370632485_122126490164002835_7814470262877211187_n.jpg', 'https://www.youtube.com/watch?v=mkggXE5e2yk', '2024-10-16 11:58:13', '2024-10-16 11:58:13', NULL),
	(59, 1, 'storage/photos/shares/370632485_122126490164002835_7814470262877211187_n.jpg', NULL, '2024-10-16 12:10:06', '2024-10-16 12:10:06', NULL);

-- Dumping structure for table nader_db.photo_category_descriptions
CREATE TABLE IF NOT EXISTS `photo_category_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `slug` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `photo_category_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `photo_category_descriptions_language_id_foreign` (`language_id`),
  KEY `photo_category_descriptions_photo_category_id_language_id_index` (`photo_category_id`,`language_id`)
) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.photo_category_descriptions: ~16 rows (approximately)
INSERT INTO `photo_category_descriptions` (`id`, `name`, `slug`, `title`, `photo_category_id`, `language_id`, `created_at`, `updated_at`) VALUES
	(97, 'محمود', NULL, 'السيارات', 51, 1, NULL, NULL),
	(98, 'الزناتي', NULL, 'Automotive', 51, 2, NULL, NULL),
	(109, NULL, NULL, 'تست', 53, 1, NULL, NULL),
	(110, NULL, NULL, 'test', 53, 2, NULL, NULL),
	(111, NULL, NULL, NULL, 54, 1, NULL, NULL),
	(112, NULL, NULL, NULL, 54, 2, NULL, NULL),
	(113, NULL, NULL, NULL, 55, 1, NULL, NULL),
	(114, NULL, NULL, NULL, 55, 2, NULL, NULL),
	(115, NULL, NULL, NULL, 56, 1, NULL, NULL),
	(116, NULL, NULL, NULL, 56, 2, NULL, NULL),
	(117, NULL, NULL, 'مالك', 57, 1, NULL, NULL),
	(118, NULL, NULL, 'malek', 57, 2, NULL, NULL),
	(119, '111', NULL, 'تست', 58, 1, NULL, NULL),
	(120, '222', NULL, 'test', 58, 2, NULL, NULL),
	(121, NULL, NULL, 'امازون', 59, 1, NULL, NULL),
	(122, NULL, NULL, 'amazon', 59, 2, NULL, NULL);

-- Dumping structure for table nader_db.photo_descriptions
CREATE TABLE IF NOT EXISTS `photo_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `photo_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `photo_descriptions_language_id_index` (`language_id`),
  KEY `photo_descriptions_photo_id_language_id_index` (`photo_id`,`language_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.photo_descriptions: ~0 rows (approximately)

-- Dumping structure for table nader_db.regions
CREATE TABLE IF NOT EXISTS `regions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `sort` bigint(20) DEFAULT NULL,
  `country_id` bigint(20) unsigned NOT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `regions_country_id_foreign` (`country_id`),
  KEY `regions_sort_index` (`sort`),
  CONSTRAINT `regions_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table nader_db.regions: ~4 rows (approximately)
INSERT INTO `regions` (`id`, `sort`, `country_id`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(32, NULL, 267, 'active', NULL, '2024-11-16 12:45:15', '2024-11-16 12:45:15'),
	(33, NULL, 267, 'active', NULL, '2024-11-16 12:47:51', '2024-11-16 12:47:51'),
	(34, NULL, 267, 'active', NULL, '2024-11-16 12:48:31', '2024-11-16 12:48:31'),
	(35, NULL, 268, 'active', NULL, '2024-11-16 13:27:28', '2024-11-16 13:27:28');

-- Dumping structure for table nader_db.region_descriptions
CREATE TABLE IF NOT EXISTS `region_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) DEFAULT NULL,
  `region_id` bigint(20) unsigned NOT NULL,
  `language_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `region_descriptions_region_id_foreign` (`region_id`),
  KEY `region_descriptions_language_id_index` (`language_id`),
  CONSTRAINT `region_descriptions_region_id_foreign` FOREIGN KEY (`region_id`) REFERENCES `regions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table nader_db.region_descriptions: ~8 rows (approximately)
INSERT INTO `region_descriptions` (`id`, `title`, `region_id`, `language_id`) VALUES
	(70, 'فرعي اول -1', 32, 1),
	(71, 'submain1-1', 32, 2),
	(72, 'فرعي اول -2', 33, 1),
	(73, 'submain1-2', 33, 2),
	(74, 'فرعي اول -3', 34, 1),
	(75, 'submain1-3', 34, 2),
	(76, 'فرعي اول-21', 35, 1),
	(77, 'submain2-21', 35, 2);

-- Dumping structure for table nader_db.services
CREATE TABLE IF NOT EXISTS `services` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `serviceType` varchar(200) DEFAULT NULL,
  `mainService` varchar(200) DEFAULT NULL,
  `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.services: ~13 rows (approximately)
INSERT INTO `services` (`id`, `image`, `serviceType`, `mainService`, `icon`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 'storage/photos/shares/services-1.svg', NULL, NULL, 'storage/photos/shares/services-1.svg', '2024-07-26 05:38:05', '2024-07-26 05:38:05', NULL),
	(2, 'storage/photos/shares/service_det.jpg', NULL, NULL, 'storage/photos/shares/services-2.svg', '2024-07-26 05:43:42', '2024-07-30 18:57:13', NULL),
	(3, 'storage/photos/shares/services-3.svg', NULL, NULL, 'storage/photos/shares/services-3.svg', '2024-07-26 05:45:26', '2024-07-26 05:45:26', NULL),
	(4, 'storage/photos/shares/services-1.svg', NULL, NULL, 'storage/photos/shares/services-1.svg', '2024-07-26 05:47:13', '2024-07-29 19:25:51', '2024-07-29 19:25:51'),
	(5, 'storage/photos/shares/services-2.svg', NULL, NULL, 'storage/photos/shares/services-2.svg', '2024-07-26 05:48:11', '2024-07-29 19:25:43', '2024-07-29 19:25:43'),
	(6, 'storage/photos/shares/1111.jpg', 'main', 'service1', NULL, '2024-10-11 07:53:47', '2024-10-11 07:53:47', NULL),
	(7, 'storage/photos/shares/12345.jpg', 'main', 'service1', NULL, '2024-10-11 07:55:42', '2024-10-11 07:55:42', NULL),
	(8, 'storage/photos/shares/12345.jpg', 'sub', 'service2', NULL, '2024-10-11 07:57:58', '2024-10-11 07:57:58', NULL),
	(9, 'storage/photos/shares/1.jpg', 'sub', 'service2', NULL, '2024-10-17 05:44:52', '2024-10-17 05:44:52', NULL),
	(10, 'storage/photos/shares/12345.jpg', 'main', 'service1', NULL, '2024-10-17 05:46:53', '2024-10-17 05:46:53', NULL),
	(11, 'storage/photos/shares/1111.jpg', 'sub', 'service3', NULL, '2024-10-17 05:49:59', '2024-10-17 05:49:59', NULL),
	(12, 'storage/photos/shares/12345.jpg', NULL, NULL, NULL, '2024-10-21 09:33:27', '2024-10-21 09:33:27', NULL),
	(13, 'storage/photos/shares/12345.jpg', NULL, NULL, NULL, '2024-10-21 09:38:12', '2024-10-21 09:38:12', NULL);

-- Dumping structure for table nader_db.service_descriptions
CREATE TABLE IF NOT EXISTS `service_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `description` longtext CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `description_2` text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `service_id` bigint(20) unsigned NOT NULL,
  `language_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `service_descriptions_language_id_foreign` (`language_id`),
  KEY `service_descriptions_service_id_foreign` (`service_id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.service_descriptions: ~26 rows (approximately)
INSERT INTO `service_descriptions` (`id`, `name`, `description`, `description_2`, `service_id`, `language_id`, `created_at`, `updated_at`) VALUES
	(9, 'تصميم المواقع', '<p>تصميم المواقع</p>', NULL, 4, 1, NULL, NULL),
	(10, 'web design', '<p>web design</p>', NULL, 4, 2, NULL, NULL),
	(11, 'تطوير التطبيقات', '<p>تطوير التطبيقات</p>', NULL, 5, 1, NULL, NULL),
	(12, 'Application Development', '<p>Application Development</p>', NULL, 5, 2, NULL, NULL),
	(13, 'تصميم المواقع', '<p>في عالم رقمي متسارع، أصبح وجود موقع إلكتروني احترافي ضرورة لكل الأعمال. في تبويب، نقدم خدمات تصميم مواقع متكاملة تساهم في تعزيز وجودك الرقمي وجذب العملاء بطريقة فعّالة ومبتكرة.</p>\r\n<p>خدماتنا في تصميم المواقع<br />تصميم مخصص<br />نحن ندرك أن كل عمل له احتياجاته الفريدة، ولذلك نقدم تصميمات مخصصة تلبي احتياجاتك الخاصة وتعكس هوية علامتك التجارية. سواء كنت تحتاج إلى موقع بسيط لعرض خدماتك أو موقع تجارة إلكترونية متكامل، نحن هنا لنحقق رؤيتك.</p>\r\n<p>تجربة مستخدم ممتازة<br />نسعى لتقديم تجربة مستخدم سلسة وممتعة من خلال تصميم مواقع بواجهة مستخدم بسيطة وسهلة الاستخدام. نحن نركز على تحسين التجربة العامة للزوار لضمان تحقيق أهدافك من الموقع.</p>\r\n<p>متجاوبة مع جميع الأجهزة<br />تصميم المواقع لدينا يتميز بالتجاوب الكامل مع جميع الأجهزة، سواء كانت أجهزة كمبيوتر، هواتف ذكية، أو أجهزة لوحية. نحن نضمن أن يظهر موقعك بشكل رائع ويعمل بشكل مثالي على جميع الشاشات.</p>\r\n<p>تحسين محركات البحث (SEO)<br />نعمل على تحسين مواقعنا لمحركات البحث لضمان ظهورها في نتائج البحث الأولى، مما يساهم في زيادة عدد الزوار وتعزيز وجودك الرقمي. نحن نتبع أحدث تقنيات السيو لضمان تحقيق أفضل النتائج.</p>\r\n<p>أمان وحماية<br />نضع أمان موقعك على رأس أولوياتنا. نستخدم أحدث تقنيات الأمان والحماية لضمان سلامة بياناتك وبيانات عملائك، ولحماية موقعك من أي تهديدات أمنية محتملة.</p>\r\n<p>مراحل تصميم المواقع<br />التخطيط والاستشارة: نبدأ بفهم احتياجاتك وأهدافك، ونجري استشارة مفصلة لتحديد متطلبات المشروع.<br />التصميم الأولي: نقدم تصميمات أولية تتناسب مع رؤيتك وهوية علامتك التجارية.<br />التطوير: بعد الموافقة على التصميم، نبدأ بتطوير الموقع باستخدام أحدث التقنيات لضمان الأداء الأمثل.<br />الاختبار والتقييم: نقوم بإجراء اختبارات شاملة لضمان خلو الموقع من الأخطاء وعمله بشكل ممتاز.<br />الإطلاق والمتابعة: بعد الانتهاء من جميع الاختبارات، نقوم بإطلاق الموقع ونقدم دعم فني مستمر لضمان استمرارية عمل الموقع بشكل مثالي.</p>', NULL, 1, 1, NULL, NULL),
	(14, 'web design', '<p>In an accelerated digital world, having a professional website has become a necessity for all businesses. At Tabweeb, we offer integrated website design services that contribute to enhancing your digital presence and attracting customers in an effective and innovative manner.</p>\r\n<p>Our web design services<br />Custom Design<br />We recognize that every business has its unique needs, so we offer customized designs that meet your specific needs and reflect your brand identity. Whether you need a simple website to display your services or an integrated e-commerce website, we are here to achieve your vision.</p>\r\n<p>Excellent user experience<br />We strive to provide a seamless and fun user experience by designing websites with a simple and easy-to-use user interface. We focus on improving the general experience of visitors to ensure that your goals are achieved from the site.</p>\r\n<p>Responsive to all devices<br />Our website design features full responsiveness to all devices, whether it be computers, smartphones, or tablets. We ensure that your site appears great and works perfectly on all screens.</p>\r\n<p>Search Engine Optimization (SEO)<br />We improve our search engine sites to ensure they appear in the first search results, contributing to increasing the number of visitors and enhancing your digital presence. We follow the latest SEO technology to ensure the best results.</p>\r\n<p>Safety and Protection<br />We place the security of your site at the top of our priorities. We use the latest security and protection technologies to ensure the integrity of your data and customers\' data, and to protect your site from any potential security threats.</p>\r\n<p>Web Design Stages<br />Planning and consulting: We begin by understanding your needs and objectives, and conduct a detailed consultation to determine the requirements of the project.<br />Initial design: We offer initial designs that suit your vision and brand identity.<br />Development: After design approval, we begin to develop the site using the latest technology to ensure optimal performance.<br />Testing and Evaluation: We conduct comprehensive testing to ensure that the site is free of errors and works excellent.<br />Launch and follow-up: After all the tests are completed, we launch the site and provide ongoing technical support to ensure the continuity of the site\'s work perfectly.</p>', NULL, 1, 2, NULL, NULL),
	(17, 'برامج الحسابات', '<p>برامج الحسابات</p>\r\n<p>في تبويب ، نقدم حلولاً متكاملة لإدارة حساباتك بكل سهولة وفعالية. برامج الحسابات لدينا مصممة خصيصاً لتلبية احتياجات الشركات الصغيرة والمتوسطة والكبيرة، مما يساعدك على إدارة عملياتك المالية بكفاءة وشفافية.</p>\r\n<p>ميزات برامج الحسابات لدينا<br />إدارة الفواتير والمبيعات<br />إنشاء الفواتير بسهولة: صمم وأرسل الفواتير إلى عملائك بسرعة وسهولة.<br />متابعة المبيعات: تتبع جميع عمليات البيع بدقة واحصل على تقارير مفصلة لتحليل الأداء.<br />إدارة المصاريف والمشتريات<br />تتبع المصاريف: سجل جميع مصاريفك اليومية والشهرية واحصل على نظرة شاملة لمصاريفك.<br />إدارة المشتريات: تابع مشترياتك واحصل على تقارير مفصلة حول الموردين والمنتجات.<br />إدارة الحسابات المدينة والدائنة<br />الحسابات المدينة: تتبع المدفوعات المستحقة من العملاء وأرسل تذكيرات للدفع.<br />الحسابات الدائنة: إدارة المدفوعات للموردين وتتبع المبالغ المستحقة عليهم.<br />التقارير المالية<br />تقارير مالية مفصلة: احصل على تقارير مالية شاملة تساعدك على اتخاذ قرارات مستنيرة.<br />تحليل الأداء المالي: تابع الأداء المالي لشركتك وقارن بين الفترات الزمنية المختلفة.<br />التكامل مع الأنظمة الأخرى<br />تكامل سلس: تكامل برامج الحسابات لدينا مع الأنظمة الأخرى التي تستخدمها في شركتك مثل أنظمة إدارة الموارد البشرية والمخزون.<br />واجهة برمجة التطبيقات (API): استخدم واجهة برمجة التطبيقات لتكامل برامج الحسابات مع الأنظمة المخصصة لشركتك.<br />الأمان والحماية<br />تشفير البيانات: نستخدم تقنيات التشفير الحديثة لضمان حماية بياناتك المالية.<br />النسخ الاحتياطي: حلول النسخ الاحتياطي التلقائي لضمان استعادة البيانات في حالة حدوث أي مشكلة.<br />حلول متكاملة للشركات<br />نحن نقدم برامج حسابات مخصصة لاحتياجات مختلف القطاعات، بما في ذلك:</p>\r\n<p>الشركات الصغيرة والمتوسطة: حلول مرنة وبأسعار معقولة لمساعدتك على إدارة حساباتك بفعالية.<br />الشركات الكبيرة: حلول متقدمة تلبي احتياجات الشركات الكبيرة والمعقدة مع تقارير وتحليلات مالية متطورة.</p>', NULL, 3, 1, NULL, NULL),
	(18, 'Account Program', '<p>In Tabweeb, we offer integrated solutions to manage your accounts with ease and effectiveness. Our account programs are tailored to the needs of small, medium and large businesses, helping you manage your financial operations efficiently and transparently.</p>\r\n<p>Features of our account software<br />Invoice and Sales Management<br />Create invoices easily: Design and send invoices to your customers quickly and easily.<br />Follow-up sales: Track all sales accurately and get detailed performance analysis reports.<br />Expenditure and Procurement Management<br />Track expenses: Record all your daily and monthly expenses and get a comprehensive view of your expenses.<br />Procurement Management: Follow your purchases and get detailed reports about suppliers and products.<br />Management of Debit and Credit Accounts<br />Debit accounts: Track outstanding payments from customers and send payment reminders.<br />Accounts payable: management of payments to suppliers and tracking of amounts owed.<br />Financial reports<br />Detailed financial reports: Get comprehensive financial reports that help you make informed decisions.<br />Financial Performance Analysis: Follow your company\'s financial performance and compare different time periods.<br />Integration with other systems<br />Seamless Integration: Integrate our account software with other systems you use in your company such as HRM and inventory systems.<br />API: Use the API to integrate account software with your company\'s custom systems.<br />Safety and Protection<br />Data encryption: We use modern encryption techniques to ensure the protection of your financial data.<br />Backup: Automatic backup solutions to ensure data recovery in case of any problem.<br />Integrated Corporate Solutions<br />We offer custom account programs for the needs of different sectors, including:</p>\r\n<p>SMEs: Flexible and affordable solutions to help you manage your accounts effectively.<br />Large companies: Advanced solutions that meet the needs of large and complex companies with sophisticated financial reports and analysis.</p>', NULL, 3, 2, NULL, NULL),
	(19, 'تطوير التطبيقات', '<p>تطوير التطبيقات</p>\r\n<p>في تبويب، نقدم خدمات تطوير تطبيقات الجوال المتكاملة التي تساعدك على الوصول إلى عملائك بسهولة وفعالية. نحن نفهم أهمية التطبيقات في عالم اليوم الرقمي، ونعمل بجد لتقديم حلول مبتكرة وذات جودة عالية تلبي احتياجات عملك.</p>\r\n<p>خدماتنا في تطوير التطبيقات<br />تطوير تطبيقات مخصصة<br />نحن نؤمن بأن كل عمل له احتياجاته الخاصة، لذلك نقدم حلولاً مخصصة لتطوير تطبيقات الجوال تتناسب مع متطلباتك الفردية وتساهم في تحقيق أهدافك. سواء كنت تحتاج إلى تطبيق للأندرويد أو iOS، فريقنا المتخصص جاهز لتقديم أفضل الحلول.</p>\r\n<p>تجربة مستخدم ممتازة<br />تصميم تجربة مستخدم سلسة وجذابة هو جزء أساسي من خدماتنا. نحرص على أن تكون تطبيقاتنا سهلة الاستخدام وتوفر تجربة مستخدم ممتازة لضمان رضا المستخدمين وزيادة تفاعلهم مع التطبيق.</p>\r\n<p>تطبيقات متجاوبة وعالية الأداء<br />نحن نضمن أن تطبيقاتنا تعمل بشكل ممتاز على جميع الأجهزة والشاشات، سواء كانت هواتف ذكية أو أجهزة لوحية. تطبيقاتنا مصممة لتكون سريعة الاستجابة وذات أداء عالي لتلبية توقعات المستخدمين.</p>\r\n<p>تكامل مع الأنظمة الأخرى<br />نقدم حلولاً متكاملة تتيح لتطبيقات الجوال التكامل مع الأنظمة الأخرى التي تستخدمها في عملك، مثل أنظمة إدارة الموارد البشرية، برامج الحسابات، وأنظمة إدارة العلاقات مع العملاء (CRM).</p>\r\n<p>الأمان والحماية<br />نضع أمان تطبيقاتك على رأس أولوياتنا. نستخدم أحدث تقنيات الأمان والحماية لضمان سلامة بياناتك وبيانات مستخدمي التطبيق، وحمايتها من أي تهديدات أمنية محتملة.</p>\r\n<p>مراحل تطوير التطبيقات<br />التحليل والتخطيط: نبدأ بفهم احتياجاتك وأهدافك من التطبيق، ونجري تحليل متعمق لتحديد متطلبات المشروع.<br />التصميم الأولي: نقدم تصميمات أولية لشاشات التطبيق للحصول على موافقتك وضمان توافق التصميم مع رؤيتك.<br />التطوير: بعد الموافقة على التصميم، نبدأ بتطوير التطبيق باستخدام أحدث التقنيات لضمان الأداء الأمثل.<br />الاختبار والتقييم: نقوم بإجراء اختبارات شاملة للتأكد من خلو التطبيق من الأخطاء وعمله بشكل ممتاز.<br />الإطلاق والمتابعة: بعد الانتهاء من جميع الاختبارات، نقوم بإطلاق التطبيق ونقدم دعم فني مستمر لضمان استمرارية عمله بشكل مثالي.</p>', NULL, 2, 1, NULL, NULL),
	(20, 'Application Development', '<p>In Tabweeb, we offer integrated mobile app development services that help you reach your customers easily and effectively. We understand the importance of applications in today\'s digital world, and we work hard to deliver innovative and high-quality solutions that meet your business needs.</p>\r\n<p>Our Services in App Development<br />Development of customized applications<br />We believe that every business has its own needs, so we offer customized solutions to develop mobile apps that fit your individual requirements and contribute to the achievement of your goals. Whether you need an app for Android or iOS, our dedicated team is ready to offer the best solutions.</p>\r\n<p>Excellent user experience<br />Designing a seamless and attractive user experience is an essential part of our services. We ensure that our apps are user friendly and provide an excellent user experience to ensure users\' satisfaction and increase their interaction with the app.</p>\r\n<p>Responsive and high performance applications<br />We ensure that our apps work excellent on all devices and screens, whether they be smartphones or tablets. Our apps are designed to be responsive and high performance to meet users\' expectations.</p>\r\n<p>Integration with other systems<br />We offer integrated solutions that allow mobile applications to integrate with other systems you use in your business, such as human resources management systems, account software, and customer relationship management systems (CRM).</p>\r\n<p>Safety and Protection<br />We place the security of your apps at the top of our priorities. We use state-of-the-art security and protection technologies to ensure the integrity of your data and users\' data, and protect them from any potential security threats.</p>\r\n<p>Phases of application development<br />Analysis and Planning: We begin by understanding your needs and objectives from the app, and conduct in-depth analysis to determine the requirements of the project.<br />Initial design: We offer initial designs for app screens to get your approval and ensure the design is compatible with your vision.<br />Development: After design approval, we begin to develop the application using the latest technology to ensure optimal performance.<br />Testing &amp; Evaluation: We perform comprehensive testing to make sure the application is error-free and works excellent.<br />Launch and follow-up: After all the tests are completed, we launch the app and provide continuous technical support to ensure the continuity of its work perfectly.</p>', NULL, 2, 2, NULL, NULL),
	(21, '111', '<p>333</p>', NULL, 6, 1, NULL, NULL),
	(22, '222', '<p>444</p>', NULL, 6, 2, NULL, NULL),
	(23, '222', '<p>444</p>', NULL, 7, 1, NULL, NULL),
	(24, '333', '<p>555</p>', NULL, 7, 2, NULL, NULL),
	(25, '444', '<p>666</p>', NULL, 8, 1, NULL, NULL),
	(26, '555', '<p>777</p>', NULL, 8, 2, NULL, NULL),
	(27, 'مالك', '<p><label>وصف الخدمة (Arabic)</label></p>\r\n<div id="mceu_16" class="mce-tinymce mce-container mce-panel" tabindex="-1" role="application">\r\n<div id="mceu_16-body" class="mce-container-body mce-stack-layout">\r\n<div id="mceu_17" class="mce-top-part mce-container mce-stack-layout-item mce-first">\r\n<div id="mceu_17-body" class="mce-container-body">\r\n<div id="mceu_18" class="mce-container mce-menubar mce-toolbar mce-first" role="menubar">&nbsp;</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>', NULL, 9, 1, NULL, NULL),
	(28, 'malek', '<p><label>وصف الخدمة (English)</label></p>\r\n<div id="mceu_55" class="mce-tinymce mce-container mce-panel" tabindex="-1" role="application">\r\n<div id="mceu_55-body" class="mce-container-body mce-stack-layout">\r\n<div id="mceu_56" class="mce-top-part mce-container mce-stack-layout-item mce-first">\r\n<div id="mceu_56-body" class="mce-container-body">\r\n<div id="mceu_57" class="mce-container mce-menubar mce-toolbar mce-first" role="menubar">&nbsp;</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>', NULL, 9, 2, NULL, NULL),
	(29, 'تصميم المواقع', '<p>1111</p>', NULL, 10, 1, NULL, NULL),
	(30, 'web design', '<p>222</p>', NULL, 10, 2, NULL, NULL),
	(31, '999', '<p>555</p>', NULL, 11, 1, NULL, NULL),
	(32, '666', '<p>444</p>', NULL, 11, 2, NULL, NULL),
	(33, 'مالك', '<p>111</p>', NULL, 12, 1, NULL, NULL),
	(34, 'malek', '<p>222</p>', NULL, 12, 2, NULL, NULL),
	(35, '111', '<p>333</p>', NULL, 13, 1, NULL, NULL),
	(36, '222', '<p>444</p>', NULL, 13, 2, NULL, NULL);

-- Dumping structure for table nader_db.service_photos
CREATE TABLE IF NOT EXISTS `service_photos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(250) DEFAULT NULL,
  `service_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `service_photos_service_id_foreign` (`service_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.service_photos: ~0 rows (approximately)

-- Dumping structure for table nader_db.sessions
CREATE TABLE IF NOT EXISTS `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext DEFAULT NULL,
  `last_activity` int(10) unsigned DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_ip_address_index` (`ip_address`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.sessions: ~0 rows (approximately)

-- Dumping structure for table nader_db.settings
CREATE TABLE IF NOT EXISTS `settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `value` text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `settings_key_index` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.settings: ~32 rows (approximately)
INSERT INTO `settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
	(110, 'website_name_ar', 'نادر لاامراض', '2024-07-26 15:08:37', '2024-11-17 02:57:32'),
	(111, 'keywords_ar', 'aJT0EXGFy6TBjhr3', '2024-07-26 15:08:37', '2024-11-17 02:57:33'),
	(112, 'meta_description_ar', '97tIeBVPO1RgkGZR', '2024-07-26 15:08:37', '2024-11-17 02:57:33'),
	(113, 'site_email', 'info@neomsoft-sa.com', '2024-07-26 15:08:37', '2024-11-17 02:57:33'),
	(114, 'site_address_ar', 'الطائف, المملكة العربية السعودية', '2024-07-26 15:08:37', '2024-11-17 02:57:33'),
	(115, 'site_phone', '+966126671538', '2024-07-26 15:08:37', '2024-11-17 02:57:33'),
	(116, 'mail_driver', 'smtp', '2024-07-26 15:08:37', '2024-11-17 02:57:33'),
	(117, 'mail_host', 'smtp.mailtrap.io', '2024-07-26 15:08:37', '2024-11-17 02:57:33'),
	(118, 'mail_port', '2525', '2024-07-26 15:08:37', '2024-11-17 02:57:33'),
	(119, 'mail_username', '759b99df94f0be', '2024-07-26 15:08:37', '2024-11-17 02:57:33'),
	(120, 'mail_password', 'e4c5c123acd614', '2024-07-26 15:08:37', '2024-11-17 02:57:33'),
	(121, 'mail_encryption', 'tls', '2024-07-26 15:08:37', '2024-11-17 02:57:33'),
	(122, 'mail_from_address', 'info@cms.com', '2024-07-26 15:08:37', '2024-11-17 02:57:33'),
	(123, 'mail_from_name', 'CMS', '2024-07-26 15:08:37', '2024-11-17 02:57:33'),
	(124, 'website_logo', 'storage/photos/shares/3.jpg', '2024-07-26 15:08:37', '2024-11-08 08:59:16'),
	(125, 'website_disable', '0', '2024-07-26 15:08:37', '2024-11-17 02:57:33'),
	(126, 'dashboard_disable', '0', '2024-07-26 15:08:37', '2024-11-17 02:57:33'),
	(127, 'website_name_en', 'Nader', '2024-07-26 15:08:37', '2024-11-17 02:57:33'),
	(128, 'keywords_en', 'test', '2024-07-26 15:08:37', '2024-11-17 02:57:33'),
	(129, 'meta_description_en', 'test', '2024-07-26 15:08:37', '2024-11-17 02:57:33'),
	(130, 'site_address_en', 'Taif, Saudi Arabia', '2024-07-26 15:08:37', '2024-11-17 02:57:33'),
	(131, 'facebook', 'https://www.facebookcom', '2024-07-26 15:08:37', '2024-11-17 02:57:33'),
	(132, 'twitter', 'https://twitter.com', '2024-07-26 15:08:37', '2024-11-17 02:57:33'),
	(133, 'instagram', 'https://www.instagram.com', '2024-07-26 15:08:37', '2024-11-17 02:57:33'),
	(134, 'whats', 'https://whatsapp2.com', '2024-07-26 15:08:37', '2024-10-21 07:02:34'),
	(135, 'snapchat', 'https://www.snapcha2t.com', '2024-07-26 15:08:37', '2024-11-17 02:57:33'),
	(136, 'map', 'https://maps.google.com/maps?width=100%25&amp;height=600&amp;hl=en&amp;q=saudi+(My%20Business%20Name)&amp;t=&amp;z=4&amp;ie=UTF8&amp;iwloc=B&amp;output=embed"', '2024-07-26 15:08:37', '2024-11-06 08:32:33'),
	(137, 'linkedin', 'https://www.linkedin.com', '2024-10-10 19:53:59', '2024-11-17 02:57:33'),
	(138, 'tiktok', 'https://www.tiktok.com', NULL, '2024-11-17 02:57:33'),
	(139, 'youtube', 'https://www.youtube.com', '2024-11-07 15:51:49', '2024-11-17 02:57:33'),
	(140, 'iosxx', NULL, '2024-11-12 19:25:47', '2024-11-12 19:25:48'),
	(141, 'androidxx', NULL, '2024-11-12 19:26:10', '2024-11-12 19:26:11');

-- Dumping structure for table nader_db.sliders
CREATE TABLE IF NOT EXISTS `sliders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` text DEFAULT NULL,
  `link` text DEFAULT NULL,
  `cost` double DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table nader_db.sliders: ~1 rows (approximately)
INSERT INTO `sliders` (`id`, `image`, `link`, `cost`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(33, NULL, '777007', NULL, NULL, '2024-10-11 07:31:53', '2024-10-11 07:32:21');

-- Dumping structure for table nader_db.slider_descriptions
CREATE TABLE IF NOT EXISTS `slider_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(400) DEFAULT NULL,
  `description` varchar(400) DEFAULT NULL,
  `start_now` varchar(400) DEFAULT NULL,
  `slider_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `slider_descriptions_language_id_foreign` (`language_id`) USING BTREE,
  KEY `slider_descriptions_slider_id_language_id_index` (`slider_id`,`language_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=176 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table nader_db.slider_descriptions: ~2 rows (approximately)
INSERT INTO `slider_descriptions` (`id`, `name`, `description`, `start_now`, `slider_id`, `language_id`) VALUES
	(174, '11001', '33003', '55005', 33, 1),
	(175, '22002', '44004', '660006', 33, 2);

-- Dumping structure for table nader_db.states_xxx
CREATE TABLE IF NOT EXISTS `states_xxx` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 1,
  `country_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `country_id` (`country_id`),
  CONSTRAINT `states_xxx_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `countries_xxx` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf16 COLLATE=utf16_general_ci;

-- Dumping data for table nader_db.states_xxx: ~12 rows (approximately)
INSERT INTO `states_xxx` (`id`, `name`, `language_id`, `country_id`, `created_at`, `updated_at`) VALUES
	(57, 'فرعي اول', 1, 30, '2024-11-12 09:17:58', '2024-11-12 09:17:58'),
	(58, 'sub main', 2, 31, '2024-11-12 09:17:58', '2024-11-12 09:17:58'),
	(59, 'فرعي ثالث', 1, 32, '2024-11-12 09:20:40', '2024-11-12 09:20:40'),
	(60, 'sub main3', 2, 33, '2024-11-12 09:20:40', '2024-11-12 09:20:40'),
	(61, 'فرعي1', 1, 34, '2024-11-12 11:39:26', '2024-11-12 11:39:26'),
	(62, 'main1', 2, 35, '2024-11-12 11:39:26', '2024-11-12 11:39:26'),
	(63, 'فرعس5', 1, 38, '2024-11-12 17:33:59', '2024-11-12 17:33:59'),
	(64, 'submain5', 2, 39, '2024-11-12 17:33:59', '2024-11-12 17:33:59'),
	(69, 'فرعي 41', 1, 42, '2024-11-12 21:20:58', '2024-11-12 21:20:58'),
	(70, 'submain41', 2, 43, '2024-11-12 21:20:58', '2024-11-12 21:20:58'),
	(71, 'فرعي 5', 1, 44, '2024-11-12 22:48:32', '2024-11-12 22:48:32'),
	(72, 'submain5', 2, 45, '2024-11-12 22:48:32', '2024-11-12 22:48:32');

-- Dumping structure for table nader_db.teams
CREATE TABLE IF NOT EXISTS `teams` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table nader_db.teams: ~2 rows (approximately)
INSERT INTO `teams` (`id`, `image`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(8, 'storage/photos/shares/12345.jpg', '2024-10-10 23:57:10', '2024-10-10 23:57:10', NULL),
	(9, 'storage/photos/shares/12345.jpg', '2024-10-10 23:58:20', '2024-10-10 23:58:20', NULL);

-- Dumping structure for table nader_db.team_descriptions
CREATE TABLE IF NOT EXISTS `team_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(250) DEFAULT NULL,
  `job` varchar(250) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `team_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `team_descriptions_team_id_foreign` (`team_id`) USING BTREE,
  KEY `team_descriptions_language_id_foreign` (`language_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table nader_db.team_descriptions: ~2 rows (approximately)
INSERT INTO `team_descriptions` (`id`, `name`, `job`, `description`, `team_id`, `language_id`) VALUES
	(25, 'مالك', 'مبرمج', NULL, 9, 1),
	(26, 'malek', 'programmer', NULL, 9, 2);

-- Dumping structure for table nader_db.user_modules
CREATE TABLE IF NOT EXISTS `user_modules` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `module_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_modules_module_id_foreign` (`module_id`),
  KEY `user_modules_user_id_module_id_index` (`user_id`,`module_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.user_modules: ~6 rows (approximately)
INSERT INTO `user_modules` (`id`, `user_id`, `module_id`, `created_at`, `updated_at`) VALUES
	(15, 4, 29, NULL, NULL),
	(16, 4, 30, NULL, NULL),
	(17, 4, 31, NULL, NULL),
	(18, 5, 29, NULL, NULL),
	(19, 5, 30, NULL, NULL),
	(20, 5, 31, NULL, NULL);

-- Dumping structure for table nader_db.videos
CREATE TABLE IF NOT EXISTS `videos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `video` varchar(300) DEFAULT NULL,
  `image` varchar(200) DEFAULT NULL,
  `type` enum('1','2') DEFAULT NULL COMMENT '1-> Youtube video file, 2-> localfile',
  `video_category_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `videos_video_category_id_foreign` (`video_category_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table nader_db.videos: ~3 rows (approximately)
INSERT INTO `videos` (`id`, `video`, `image`, `type`, `video_category_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(19, NULL, NULL, '1', NULL, '2024-07-18 06:24:34', '2024-07-18 06:24:53', NULL),
	(20, 'wwww.ddd', NULL, '1', NULL, '2024-07-18 07:22:06', '2024-07-18 07:26:06', NULL),
	(21, 'يالابينا', NULL, '1', NULL, '2024-07-18 07:28:19', '2024-07-18 07:28:19', NULL);

-- Dumping structure for table nader_db.video_categories
CREATE TABLE IF NOT EXISTS `video_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(200) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table nader_db.video_categories: ~0 rows (approximately)

-- Dumping structure for table nader_db.video_category_descriptions
CREATE TABLE IF NOT EXISTS `video_category_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `keywords` varchar(400) NOT NULL,
  `meta_description` text NOT NULL,
  `video_category_id` bigint(20) unsigned DEFAULT NULL,
  `language_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `video_category_descriptions_language_id_foreign` (`language_id`) USING BTREE,
  KEY `video_category_descriptions_video_category_id_language_id_index` (`video_category_id`,`language_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table nader_db.video_category_descriptions: ~0 rows (approximately)

-- Dumping structure for table nader_db.video_descriptions
CREATE TABLE IF NOT EXISTS `video_descriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `video_id` bigint(20) unsigned NOT NULL,
  `language_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `video_descriptions_language_id_foreign` (`language_id`) USING BTREE,
  KEY `video_descriptions_video_id_language_id_index` (`video_id`,`language_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=233 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Dumping data for table nader_db.video_descriptions: ~6 rows (approximately)
INSERT INTO `video_descriptions` (`id`, `title`, `video_id`, `language_id`) VALUES
	(225, 'ساره2', 19, 1),
	(226, 'sara2', 19, 2),
	(229, 'تست', 20, 1),
	(230, 'test', 20, 2),
	(231, 'مدحت', 21, 1),
	(232, 'medht', 21, 2);

-- Dumping structure for table nader_db.visitor_emails
CREATE TABLE IF NOT EXISTS `visitor_emails` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(191) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `posts_id_index` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.visitor_emails: ~0 rows (approximately)

-- Dumping structure for table nader_db.visitor_jobs
CREATE TABLE IF NOT EXISTS `visitor_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `postname` varchar(255) DEFAULT NULL,
  `community` varchar(255) DEFAULT NULL,
  `username` varchar(190) DEFAULT NULL,
  `email` varchar(190) DEFAULT NULL,
  `comments` varchar(15) DEFAULT NULL,
  `pinpost` varchar(200) DEFAULT NULL,
  `image` varchar(200) DEFAULT NULL,
  `comment_text` longtext DEFAULT NULL,
  `comment_date` date DEFAULT NULL,
  `comment_time` time DEFAULT NULL,
  `likes` varchar(50) DEFAULT NULL,
  `reports` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.visitor_jobs: ~3 rows (approximately)
INSERT INTO `visitor_jobs` (`id`, `postname`, `community`, `username`, `email`, `comments`, `pinpost`, `image`, `comment_text`, `comment_date`, `comment_time`, `likes`, `reports`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(120, 'منشور2', '222', '333', '4444', '555', '1', NULL, NULL, NULL, NULL, NULL, NULL, '2024-11-15 19:58:01', '2024-11-15 21:02:07', NULL),
	(121, '222', '333', '444', '555', '666', '2', NULL, NULL, NULL, NULL, NULL, NULL, '2024-11-15 20:07:46', '2024-11-15 20:07:46', NULL),
	(122, 'منشور 2', 'تويتر2', 'محمود2', 'mah2@admin.com', '15', '1', 'storage/photos/shares/12345.jpg', '888', '2024-11-16', '22:15:00', '77', '666', '2024-11-14 20:19:35', '2024-11-15 22:22:49', NULL);

-- Dumping structure for table nader_db.visitor_messages
CREATE TABLE IF NOT EXISTS `visitor_messages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `type` varchar(500) DEFAULT NULL,
  `title` varchar(500) DEFAULT NULL,
  `subject` varchar(191) DEFAULT NULL,
  `message` longtext DEFAULT NULL,
  `read` tinyint(1) NOT NULL DEFAULT 0,
  `reply` tinyint(1) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `visitor_messages_id_index` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.visitor_messages: ~9 rows (approximately)
INSERT INTO `visitor_messages` (`id`, `name`, `email`, `phone`, `type`, `title`, `subject`, `message`, `read`, `reply`, `deleted_at`, `created_at`, `updated_at`) VALUES
	(2, 'mahmoud', 'admin@admin.com', '0100', NULL, NULL, 'تست', 'تستت 123', 0, 0, NULL, '2024-07-28 07:51:47', '2024-07-28 19:50:46'),
	(3, 'mahmoud', 'mah@yahoo.com', '01011800592', NULL, NULL, 'تست', NULL, 0, 0, NULL, '2024-07-28 19:20:06', '2024-07-28 19:50:46'),
	(4, 'mahmoud', 'mah@yahoo.com', '01011800592', NULL, NULL, 'تست', 'basha2', 0, 0, NULL, '2024-07-28 19:25:50', '2024-07-28 19:50:46'),
	(5, 'احمد', 'mah@yahoo.com', '01011800592', NULL, NULL, 'تست', NULL, 0, 0, NULL, '2024-07-28 19:28:09', '2024-07-28 19:50:46'),
	(6, 'احمد', 'mah@yahoo.com', '01011800592', NULL, NULL, 'تست', NULL, 0, 0, NULL, '2024-07-28 19:29:01', '2024-07-28 19:50:46'),
	(7, 'Mahmoud Elzanaty Ahmed Ali AMISH', 'mah_zanaty@yahoo.com', '01011800592', NULL, NULL, 'sg', NULL, 0, 0, NULL, '2024-07-28 19:48:36', '2024-07-28 19:50:46'),
	(8, 'Mahmoud Elzanaty Ahmed Ali AMISH', 'mah_zanaty@yahoo.com', '01011800592', NULL, NULL, 'تست2', 'dszfg', 0, 0, NULL, '2024-07-30 21:18:21', '2024-07-30 21:18:21'),
	(9, 'mahmoud', 'FBA_ITALY@LIBERO.IT', '12345678912', NULL, '555', '666', '55555', 0, 0, NULL, '2024-10-12 19:23:04', '2024-10-12 19:23:04'),
	(10, 'احمد', 'ahmed1@admin.com', NULL, 'الرئيسي', 'عنوان رسالة الترجمة', 'موضوع ملف الترجمة', '<p style="text-align: right;"><label>3الرد على الرسالة</label></p>\r\n<div id="mceu_16" class="mce-tinymce mce-container mce-panel" tabindex="-1" role="application">\r\n<div id="mceu_16-body" class="mce-container-body mce-stack-layout">\r\n<div id="mceu_17" class="mce-top-part mce-container mce-stack-layout-item mce-first">\r\n<div id="mceu_17-body" class="mce-container-body">\r\n<div id="mceu_18" class="mce-container mce-menubar mce-toolbar mce-first" role="menubar">&nbsp;</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>', 0, 0, NULL, '2024-11-13 12:35:18', '2024-11-13 19:12:33');

-- Dumping structure for table nader_db.website_disabled
CREATE TABLE IF NOT EXISTS `website_disabled` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `link` text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.website_disabled: ~0 rows (approximately)

-- Dumping structure for table nader_db.website_visitors
CREATE TABLE IF NOT EXISTS `website_visitors` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ip` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `website_visitors_id_index` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table nader_db.website_visitors: ~62 rows (approximately)
INSERT INTO `website_visitors` (`id`, `ip`, `created_at`, `updated_at`) VALUES
	(1, '::1', '2024-07-18 04:52:56', '2024-07-18 04:52:56'),
	(2, '::1', '2024-07-20 08:36:47', '2024-07-20 08:36:47'),
	(3, '::1', '2024-07-20 09:20:10', '2024-07-20 09:20:10'),
	(4, '::1', '2024-07-21 05:27:45', '2024-07-21 05:27:45'),
	(5, '::1', '2024-07-22 14:56:28', '2024-07-22 14:56:28'),
	(6, '::1', '2024-07-24 04:26:58', '2024-07-24 04:26:58'),
	(7, '::1', '2024-07-24 15:46:22', '2024-07-24 15:46:22'),
	(8, '::1', '2024-07-24 16:50:41', '2024-07-24 16:50:41'),
	(9, '::1', '2024-07-24 16:55:47', '2024-07-24 16:55:47'),
	(10, '::1', '2024-07-24 18:00:36', '2024-07-24 18:00:36'),
	(11, '::1', '2024-07-25 02:22:48', '2024-07-25 02:22:48'),
	(12, '::1', '2024-07-25 02:34:34', '2024-07-25 02:34:34'),
	(13, '::1', '2024-07-25 06:21:20', '2024-07-25 06:21:20'),
	(14, '::1', '2024-07-25 06:44:52', '2024-07-25 06:44:52'),
	(15, '::1', '2024-07-25 06:47:46', '2024-07-25 06:47:46'),
	(16, '::1', '2024-07-25 07:26:13', '2024-07-25 07:26:13'),
	(17, '::1', '2024-07-25 08:08:51', '2024-07-25 08:08:51'),
	(18, '::1', '2024-07-25 12:15:42', '2024-07-25 12:15:42'),
	(19, '::1', '2024-07-25 13:10:55', '2024-07-25 13:10:55'),
	(20, '::1', '2024-07-25 14:04:33', '2024-07-25 14:04:33'),
	(21, '::1', '2024-07-26 02:37:24', '2024-07-26 02:37:24'),
	(22, '::1', '2024-07-26 03:40:53', '2024-07-26 03:40:53'),
	(23, '::1', '2024-07-26 03:51:54', '2024-07-26 03:51:54'),
	(24, '::1', '2024-07-26 03:53:51', '2024-07-26 03:53:51'),
	(25, '::1', '2024-07-26 05:33:16', '2024-07-26 05:33:16'),
	(26, '::1', '2024-07-26 12:11:20', '2024-07-26 12:11:20'),
	(27, '::1', '2024-07-26 15:17:16', '2024-07-26 15:17:16'),
	(28, '::1', '2024-07-26 17:16:27', '2024-07-26 17:16:27'),
	(29, '::1', '2024-07-26 18:00:11', '2024-07-26 18:00:11'),
	(30, '::1', '2024-07-27 02:08:25', '2024-07-27 02:08:25'),
	(31, '::1', '2024-07-27 02:09:39', '2024-07-27 02:09:39'),
	(32, '::1', '2024-07-27 11:46:58', '2024-07-27 11:46:58'),
	(33, '::1', '2024-07-27 16:26:59', '2024-07-27 16:26:59'),
	(34, '::1', '2024-07-27 16:27:41', '2024-07-27 16:27:41'),
	(35, '::1', '2024-07-27 18:09:29', '2024-07-27 18:09:29'),
	(36, '::1', '2024-07-27 19:55:26', '2024-07-27 19:55:26'),
	(37, '::1', '2024-07-28 03:26:23', '2024-07-28 03:26:23'),
	(38, '::1', '2024-07-28 03:26:23', '2024-07-28 03:26:23'),
	(39, '::1', '2024-07-28 04:16:00', '2024-07-28 04:16:00'),
	(40, '::1', '2024-07-28 07:00:03', '2024-07-28 07:00:03'),
	(41, '::1', '2024-07-28 14:33:55', '2024-07-28 14:33:55'),
	(42, '::1', '2024-07-28 14:38:47', '2024-07-28 14:38:47'),
	(43, '::1', '2024-07-28 14:45:26', '2024-07-28 14:45:26'),
	(44, '::1', '2024-07-28 16:56:05', '2024-07-28 16:56:05'),
	(45, '::1', '2024-07-28 18:00:17', '2024-07-28 18:00:17'),
	(46, '::1', '2024-07-28 19:45:04', '2024-07-28 19:45:04'),
	(47, '::1', '2024-07-28 19:46:12', '2024-07-28 19:46:12'),
	(48, '::1', '2024-07-29 06:22:22', '2024-07-29 06:22:22'),
	(49, '::1', '2024-07-29 15:29:01', '2024-07-29 15:29:01'),
	(50, '::1', '2024-07-29 17:20:04', '2024-07-29 17:20:04'),
	(51, '::1', '2024-07-29 18:21:05', '2024-07-29 18:21:05'),
	(52, '::1', '2024-07-30 04:27:38', '2024-07-30 04:27:38'),
	(53, '::1', '2024-07-30 09:33:18', '2024-07-30 09:33:18'),
	(54, '::1', '2024-07-30 09:33:32', '2024-07-30 09:33:32'),
	(55, '::1', '2025-07-30 15:20:26', '2025-07-30 15:20:26'),
	(56, '::1', '2025-07-30 17:10:16', '2025-07-30 17:10:16'),
	(57, '::1', '2025-07-30 18:00:27', '2025-07-30 18:00:27'),
	(58, '::1', '2025-07-30 18:55:27', '2025-07-30 18:55:27'),
	(59, '::1', '2025-07-30 20:57:11', '2025-07-30 20:57:11'),
	(60, '::1', '2024-10-16 14:09:02', '2024-10-16 14:09:03'),
	(61, '::1', '2024-10-16 14:09:16', '2024-10-16 14:09:16'),
	(62, '::1', '2024-10-16 18:55:20', '2024-10-16 18:55:21');

