-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `client_id` bigint unsigned NOT NULL,
  `scopes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_auth_codes_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_auth_codes`
--


--
-- Table structure for table `oauth_clients`
--

CREATE TABLE `oauth_clients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redirect` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_clients_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_clients`
--

INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `provider`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES (1,NULL,'Laravel Personal Access Client','M5hKJeOymQ5ybOqGLb1ZHeZwAvggkkcZi4jSuwrX',NULL,'http://localhost',1,0,0,'2022-06-22 10:12:48','2022-06-22 10:12:48'),(2,NULL,'Laravel Password Grant Client','oiElx9TLRlbGMJYB07DzGeD7GcN1SQMxbg24HbDa','users','http://localhost',0,1,0,'2022-06-22 10:12:48','2022-06-22 10:12:48');

--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES (1,1,'2022-06-22 10:12:48','2022-06-22 10:12:48');

--
-- Table structure for table `oauth_refresh_tokens`
--

CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_token_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_refresh_tokens`
--


--
-- Table structure for table `page_translations`
--

CREATE TABLE `page_translations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `page_id` int unsigned NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `page_translations_page_id_locale_unique` (`page_id`,`locale`),
  KEY `page_translations_locale_index` (`locale`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `page_translations`
--

INSERT INTO `page_translations` (`id`, `page_id`, `title`, `locale`, `content`, `created_at`, `updated_at`) VALUES (1,1,'صفحة تجيريبية','ar','<p>وصف تجريبي</p>',NULL,NULL),(2,1,'Test Page','en','<p>Test Discription</p>',NULL,NULL),(3,2,'من نحن','ar','<p><strong>discountpro: عالم الخصومات بين يديك</strong></p>\r\n\r\n<p>هل تبحث عن تجارب تناول طعام فاخرة أو إقامة مريحة في فندق دون أن تكسر ميزانيتك؟ تطبيق &quot;discountpro&quot; هو الحل الأمثل لك!</p>\r\n\r\n<p><strong>ما هو تطبيق discountpro؟</strong></p>\r\n\r\n<p>discountpro هو تطبيق مبتكر يوفر لك خصومات حصرية على مجموعة واسعة من المطاعم والكافيهات والفنادق المميزة. باشتراك سنوي واحد، يمكنك الاستمتاع بتوفير كبير على وجباتك، وقضاء أمسيات رومانسية في أجواء فاخرة، والاستفادة من عروض الإقامة الخاصة.</p>\r\n\r\n<p><strong>ما الذي يميز discountpro؟</strong></p>\r\n\r\n<ul>\r\n	<li><strong>خصومات حصرية:</strong> احصل على خصومات تصل إلى [نسبة الخصم] على قائمة الطعام والمشروبات في مجموعة متنوعة من المطاعم والكافيهات.</li>\r\n	<li><strong>عروض فنادق مميزة:</strong> استمتع بإقامات فاخرة بأسعار مخفضة، مع إمكانية الحصول على خدمات إضافية مثل وجبات الإفطار المجانية أو الوصول المبكر إلى الغرفة.</li>\r\n	<li><strong>تحديثات مستمرة:</strong> يتم تحديث التطبيق بانتظام بعروض جديدة وخصومات حصرية، مما يضمن لك دائماً وجود خيارات متنوعة لاختيار ما يناسبك.</li>\r\n	<li><strong>واجهة سهلة الاستخدام:</strong> يتميز التطبيق بواجهة بسيطة وسهلة الاستخدام، مما يتيح لك البحث عن العروض والخصومات بسهولة وسرعة.</li>\r\n	<li><strong>مرونة في الاستخدام:</strong> يمكنك استخدام التطبيق في أي وقت ومن أي مكان، سواء كنت تخطط لخروج مع الأصدقاء أو تبحث عن مكان للإقامة خلال عطلة نهاية الأسبوع.</li>\r\n</ul>\r\n\r\n<p><strong>كيف يعمل discountpro؟</strong></p>\r\n\r\n<ol>\r\n	<li><strong>التسجيل والاشتراك:</strong> قم بتنزيل التطبيق وتسجيل حسابك. اختر الاشتراك السنوي المناسب لك واستمتع بكافة المزايا.</li>\r\n	<li><strong>البحث عن العروض:</strong> استخدم خيارات البحث المتقدمة للعثور على المطاعم والكافيهات والفنادق التي تناسب ذوقك وميزانيتك.</li>\r\n	<li><strong>الحجز والاستمتاع:</strong> بمجرد اختيار العرض الذي يناسبك، يمكنك حجز طاولتك أو غرفتك مباشرة من خلال التطبيق والاستمتاع بتجربة فريدة.</li>\r\n</ol>\r\n\r\n<p><strong>لماذا تختار discountpro؟</strong></p>\r\n\r\n<ul>\r\n	<li><strong>توفير المال:</strong> احفظ ميزانيتك واستمتع بتجارب تناول الطعام والإقامة الفاخرة.</li>\r\n	<li><strong>الوصول إلى أفضل الأماكن:</strong> اكتشف أماكن جديدة ومميزة في مدينتك.</li>\r\n	<li><strong>مرونة في الاختيار:</strong> اختر من بين مجموعة واسعة من العروض والخصومات.</li>\r\n	<li><strong>سهولة الاستخدام:</strong> استمتع بتجربة استخدام سلسة وممتعة.</li>\r\n</ul>\r\n\r\n<p><strong>استمتع بتجربة تناول الطعام والإقامة الفاخرة مع discountpro!</strong></p>\r\n\r\n<p><strong>[أضف هنا أي ميزات إضافية للتطبيق، مثل تقييم المطاعم، أو إمكانية مشاركة العروض مع الأصدقاء، أو أي ميزة أخرى تجعله مميزًا]</strong></p>\r\n\r\n<p><strong>ملاحظة:</strong> يمكنك تخصيص هذا الوصف أكثر من خلال إضافة معلومات محددة حول:</p>\r\n\r\n<ul>\r\n	<li><strong>نسبة الخصومات المتاحة</strong></li>\r\n	<li><strong>عدد المطاعم والكافيهات والفنادق الشريكة</strong></li>\r\n	<li><strong>المواقع الجغرافية التي يغطيها التطبيق</strong></li>\r\n	<li><strong>أي ميزات إضافية يقدمها التطبيق</strong></li>\r\n</ul>\r\n\r\n<p><strong>لتحميل التطبيق، قم بزيارة [رابط تحميل التطبيق]</strong></p>\r\n\r\n<p><strong>لا تفوت فرصة الاستمتاع بتجارب لا تُنسى بأسعار مخفضة!</strong></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<div id=\"gtx-trans\" style=\"left:779px; position:absolute; top:38.5px\">\r\n<div class=\"gtx-trans-icon\">&nbsp;</div>\r\n</div>',NULL,NULL),(4,2,'About Us','en','<p><strong>discountpro: عالم الخصومات بين يديك</strong></p>\r\n\r\n<p>هل تبحث عن تجارب تناول طعام فاخرة أو إقامة مريحة في فندق دون أن تكسر ميزانيتك؟ تطبيق &quot;discountpro&quot; هو الحل الأمثل لك!</p>\r\n\r\n<p><strong>ما هو تطبيق discountpro؟</strong></p>\r\n\r\n<p>discountpro هو تطبيق مبتكر يوفر لك خصومات حصرية على مجموعة واسعة من المطاعم والكافيهات والفنادق المميزة. باشتراك سنوي واحد، يمكنك الاستمتاع بتوفير كبير على وجباتك، وقضاء أمسيات رومانسية في أجواء فاخرة، والاستفادة من عروض الإقامة الخاصة.</p>\r\n\r\n<p><strong>ما الذي يميز discountpro؟</strong></p>\r\n\r\n<ul>\r\n	<li><strong>خصومات حصرية:</strong> احصل على خصومات تصل إلى [نسبة الخصم] على قائمة الطعام والمشروبات في مجموعة متنوعة من المطاعم والكافيهات.</li>\r\n	<li><strong>عروض فنادق مميزة:</strong> استمتع بإقامات فاخرة بأسعار مخفضة، مع إمكانية الحصول على خدمات إضافية مثل وجبات الإفطار المجانية أو الوصول المبكر إلى الغرفة.</li>\r\n	<li><strong>تحديثات مستمرة:</strong> يتم تحديث التطبيق بانتظام بعروض جديدة وخصومات حصرية، مما يضمن لك دائماً وجود خيارات متنوعة لاختيار ما يناسبك.</li>\r\n	<li><strong>واجهة سهلة الاستخدام:</strong> يتميز التطبيق بواجهة بسيطة وسهلة الاستخدام، مما يتيح لك البحث عن العروض والخصومات بسهولة وسرعة.</li>\r\n	<li><strong>مرونة في الاستخدام:</strong> يمكنك استخدام التطبيق في أي وقت ومن أي مكان، سواء كنت تخطط لخروج مع الأصدقاء أو تبحث عن مكان للإقامة خلال عطلة نهاية الأسبوع.</li>\r\n</ul>\r\n\r\n<p><strong>كيف يعمل discountpro؟</strong></p>\r\n\r\n<ol>\r\n	<li><strong>التسجيل والاشتراك:</strong> قم بتنزيل التطبيق وتسجيل حسابك. اختر الاشتراك السنوي المناسب لك واستمتع بكافة المزايا.</li>\r\n	<li><strong>البحث عن العروض:</strong> استخدم خيارات البحث المتقدمة للعثور على المطاعم والكافيهات والفنادق التي تناسب ذوقك وميزانيتك.</li>\r\n	<li><strong>الحجز والاستمتاع:</strong> بمجرد اختيار العرض الذي يناسبك، يمكنك حجز طاولتك أو غرفتك مباشرة من خلال التطبيق والاستمتاع بتجربة فريدة.</li>\r\n</ol>\r\n\r\n<p><strong>لماذا تختار discountpro؟</strong></p>\r\n\r\n<ul>\r\n	<li><strong>توفير المال:</strong> احفظ ميزانيتك واستمتع بتجارب تناول الطعام والإقامة الفاخرة.</li>\r\n	<li><strong>الوصول إلى أفضل الأماكن:</strong> اكتشف أماكن جديدة ومميزة في مدينتك.</li>\r\n	<li><strong>مرونة في الاختيار:</strong> اختر من بين مجموعة واسعة من العروض والخصومات.</li>\r\n	<li><strong>سهولة الاستخدام:</strong> استمتع بتجربة استخدام سلسة وممتعة.</li>\r\n</ul>\r\n\r\n<p><strong>استمتع بتجربة تناول الطعام والإقامة الفاخرة مع discountpro!</strong></p>\r\n\r\n<p><strong>[أضف هنا أي ميزات إضافية للتطبيق، مثل تقييم المطاعم، أو إمكانية مشاركة العروض مع الأصدقاء، أو أي ميزة أخرى تجعله مميزًا]</strong></p>\r\n\r\n<p><strong>ملاحظة:</strong> يمكنك تخصيص هذا الوصف أكثر من خلال إضافة معلومات محددة حول:</p>\r\n\r\n<ul>\r\n	<li><strong>نسبة الخصومات المتاحة</strong></li>\r\n	<li><strong>عدد المطاعم والكافيهات والفنادق الشريكة</strong></li>\r\n	<li><strong>المواقع الجغرافية التي يغطيها التطبيق</strong></li>\r\n	<li><strong>أي ميزات إضافية يقدمها التطبيق</strong></li>\r\n</ul>\r\n\r\n<p><strong>لتحميل التطبيق، قم بزيارة [رابط تحميل التطبيق]</strong></p>\r\n\r\n<p><strong>لا تفوت فرصة الاستمتاع بتجارب لا تُنسى بأسعار مخفضة!</strong></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<div id=\"gtx-trans\" style=\"left:923px; position:absolute; top:38.5px\">\r\n<div class=\"gtx-trans-icon\">&nbsp;</div>\r\n</div>',NULL,NULL),(5,3,'شروط الاشتراك','ar','<p><strong>discountpro: عالم الخصومات بين يديك</strong></p>\r\n\r\n<p>هل تبحث عن تجارب تناول طعام فاخرة أو إقامة مريحة في فندق دون أن تكسر ميزانيتك؟ تطبيق &quot;discountpro&quot; هو الحل الأمثل لك!</p>\r\n\r\n<p><strong>ما هو تطبيق discountpro؟</strong></p>\r\n\r\n<p>discountpro هو تطبيق مبتكر يوفر لك خصومات حصرية على مجموعة واسعة من المطاعم والكافيهات والفنادق المميزة. باشتراك سنوي واحد، يمكنك الاستمتاع بتوفير كبير على وجباتك، وقضاء أمسيات رومانسية في أجواء فاخرة، والاستفادة من عروض الإقامة الخاصة.</p>\r\n\r\n<p><strong>ما الذي يميز discountpro؟</strong></p>\r\n\r\n<ul>\r\n	<li><strong>خصومات حصرية:</strong> احصل على خصومات تصل إلى [نسبة الخصم] على قائمة الطعام والمشروبات في مجموعة متنوعة من المطاعم والكافيهات.</li>\r\n	<li><strong>عروض فنادق مميزة:</strong> استمتع بإقامات فاخرة بأسعار مخفضة، مع إمكانية الحصول على خدمات إضافية مثل وجبات الإفطار المجانية أو الوصول المبكر إلى الغرفة.</li>\r\n	<li><strong>تحديثات مستمرة:</strong> يتم تحديث التطبيق بانتظام بعروض جديدة وخصومات حصرية، مما يضمن لك دائماً وجود خيارات متنوعة لاختيار ما يناسبك.</li>\r\n	<li><strong>واجهة سهلة الاستخدام:</strong> يتميز التطبيق بواجهة بسيطة وسهلة الاستخدام، مما يتيح لك البحث عن العروض والخصومات بسهولة وسرعة.</li>\r\n	<li><strong>مرونة في الاستخدام:</strong> يمكنك استخدام التطبيق في أي وقت ومن أي مكان، سواء كنت تخطط لخروج مع الأصدقاء أو تبحث عن مكان للإقامة خلال عطلة نهاية الأسبوع.</li>\r\n</ul>\r\n\r\n<p><strong>كيف يعمل discountpro؟</strong></p>\r\n\r\n<ol>\r\n	<li><strong>التسجيل والاشتراك:</strong> قم بتنزيل التطبيق وتسجيل حسابك. اختر الاشتراك السنوي المناسب لك واستمتع بكافة المزايا.</li>\r\n	<li><strong>البحث عن العروض:</strong> استخدم خيارات البحث المتقدمة للعثور على المطاعم والكافيهات والفنادق التي تناسب ذوقك وميزانيتك.</li>\r\n	<li><strong>الحجز والاستمتاع:</strong> بمجرد اختيار العرض الذي يناسبك، يمكنك حجز طاولتك أو غرفتك مباشرة من خلال التطبيق والاستمتاع بتجربة فريدة.</li>\r\n</ol>\r\n\r\n<p><strong>لماذا تختار discountpro؟</strong></p>\r\n\r\n<ul>\r\n	<li><strong>توفير المال:</strong> احفظ ميزانيتك واستمتع بتجارب تناول الطعام والإقامة الفاخرة.</li>\r\n	<li><strong>الوصول إلى أفضل الأماكن:</strong> اكتشف أماكن جديدة ومميزة في مدينتك.</li>\r\n	<li><strong>مرونة في الاختيار:</strong> اختر من بين مجموعة واسعة من العروض والخصومات.</li>\r\n	<li><strong>سهولة الاستخدام:</strong> استمتع بتجربة استخدام سلسة وممتعة.</li>\r\n</ul>\r\n\r\n<p><strong>استمتع بتجربة تناول الطعام والإقامة الفاخرة مع discountpro!</strong></p>\r\n\r\n<p><strong>[أضف هنا أي ميزات إضافية للتطبيق، مثل تقييم المطاعم، أو إمكانية مشاركة العروض مع الأصدقاء، أو أي ميزة أخرى تجعله مميزًا]</strong></p>\r\n\r\n<p><strong>ملاحظة:</strong> يمكنك تخصيص هذا الوصف أكثر من خلال إضافة معلومات محددة حول:</p>\r\n\r\n<ul>\r\n	<li><strong>نسبة الخصومات المتاحة</strong></li>\r\n	<li><strong>عدد المطاعم والكافيهات والفنادق الشريكة</strong></li>\r\n	<li><strong>المواقع الجغرافية التي يغطيها التطبيق</strong></li>\r\n	<li><strong>أي ميزات إضافية يقدمها التطبيق</strong></li>\r\n</ul>\r\n\r\n<p><strong>لتحميل التطبيق، قم بزيارة [رابط تحميل التطبيق]</strong></p>\r\n\r\n<p><strong>لا تفوت فرصة الاستمتاع بتجارب لا تُنسى بأسعار مخفضة!</strong></p>\r\n\r\n<p>&nbsp;</p>',NULL,NULL),(6,3,'Subscription terms','en','<p><strong>discountpro: عالم الخصومات بين يديك</strong></p>\r\n\r\n<p>هل تبحث عن تجارب تناول طعام فاخرة أو إقامة مريحة في فندق دون أن تكسر ميزانيتك؟ تطبيق &quot;discountpro&quot; هو الحل الأمثل لك!</p>\r\n\r\n<p><strong>ما هو تطبيق discountpro؟</strong></p>\r\n\r\n<p>discountpro هو تطبيق مبتكر يوفر لك خصومات حصرية على مجموعة واسعة من المطاعم والكافيهات والفنادق المميزة. باشتراك سنوي واحد، يمكنك الاستمتاع بتوفير كبير على وجباتك، وقضاء أمسيات رومانسية في أجواء فاخرة، والاستفادة من عروض الإقامة الخاصة.</p>\r\n\r\n<p><strong>ما الذي يميز discountpro؟</strong></p>\r\n\r\n<ul>\r\n	<li><strong>خصومات حصرية:</strong> احصل على خصومات تصل إلى [نسبة الخصم] على قائمة الطعام والمشروبات في مجموعة متنوعة من المطاعم والكافيهات.</li>\r\n	<li><strong>عروض فنادق مميزة:</strong> استمتع بإقامات فاخرة بأسعار مخفضة، مع إمكانية الحصول على خدمات إضافية مثل وجبات الإفطار المجانية أو الوصول المبكر إلى الغرفة.</li>\r\n	<li><strong>تحديثات مستمرة:</strong> يتم تحديث التطبيق بانتظام بعروض جديدة وخصومات حصرية، مما يضمن لك دائماً وجود خيارات متنوعة لاختيار ما يناسبك.</li>\r\n	<li><strong>واجهة سهلة الاستخدام:</strong> يتميز التطبيق بواجهة بسيطة وسهلة الاستخدام، مما يتيح لك البحث عن العروض والخصومات بسهولة وسرعة.</li>\r\n	<li><strong>مرونة في الاستخدام:</strong> يمكنك استخدام التطبيق في أي وقت ومن أي مكان، سواء كنت تخطط لخروج مع الأصدقاء أو تبحث عن مكان للإقامة خلال عطلة نهاية الأسبوع.</li>\r\n</ul>\r\n\r\n<p><strong>كيف يعمل discountpro؟</strong></p>\r\n\r\n<ol>\r\n	<li><strong>التسجيل والاشتراك:</strong> قم بتنزيل التطبيق وتسجيل حسابك. اختر الاشتراك السنوي المناسب لك واستمتع بكافة المزايا.</li>\r\n	<li><strong>البحث عن العروض:</strong> استخدم خيارات البحث المتقدمة للعثور على المطاعم والكافيهات والفنادق التي تناسب ذوقك وميزانيتك.</li>\r\n	<li><strong>الحجز والاستمتاع:</strong> بمجرد اختيار العرض الذي يناسبك، يمكنك حجز طاولتك أو غرفتك مباشرة من خلال التطبيق والاستمتاع بتجربة فريدة.</li>\r\n</ol>\r\n\r\n<p><strong>لماذا تختار discountpro؟</strong></p>\r\n\r\n<ul>\r\n	<li><strong>توفير المال:</strong> احفظ ميزانيتك واستمتع بتجارب تناول الطعام والإقامة الفاخرة.</li>\r\n	<li><strong>الوصول إلى أفضل الأماكن:</strong> اكتشف أماكن جديدة ومميزة في مدينتك.</li>\r\n	<li><strong>مرونة في الاختيار:</strong> اختر من بين مجموعة واسعة من العروض والخصومات.</li>\r\n	<li><strong>سهولة الاستخدام:</strong> استمتع بتجربة استخدام سلسة وممتعة.</li>\r\n</ul>\r\n\r\n<p><strong>استمتع بتجربة تناول الطعام والإقامة الفاخرة مع discountpro!</strong></p>\r\n\r\n<p><strong>[أضف هنا أي ميزات إضافية للتطبيق، مثل تقييم المطاعم، أو إمكانية مشاركة العروض مع الأصدقاء، أو أي ميزة أخرى تجعله مميزًا]</strong></p>\r\n\r\n<p><strong>ملاحظة:</strong> يمكنك تخصيص هذا الوصف أكثر من خلال إضافة معلومات محددة حول:</p>\r\n\r\n<ul>\r\n	<li><strong>نسبة الخصومات المتاحة</strong></li>\r\n	<li><strong>عدد المطاعم والكافيهات والفنادق الشريكة</strong></li>\r\n	<li><strong>المواقع الجغرافية التي يغطيها التطبيق</strong></li>\r\n	<li><strong>أي ميزات إضافية يقدمها التطبيق</strong></li>\r\n</ul>\r\n\r\n<p><strong>لتحميل التطبيق، قم بزيارة [رابط تحميل التطبيق]</strong></p>\r\n\r\n<p><strong>لا تفوت فرصة الاستمتاع بتجارب لا تُنسى بأسعار مخفضة!</strong></p>\r\n\r\n<p>&nbsp;</p>',NULL,NULL),(7,4,'مؤسسة الإلتزام للمقاولات','ar','<p>مؤسسة الالتزام للمقاولات العامة، المؤسسة الرائدة في مجال الإنشاءات ومواد البناء والعقارات عالية الجودة والبناء، بخبرة أكثر من ١٥ سنة في صناعة البناء ضمن منطقة الخليج العربي ومن ١٠ سنة في مجال التطوير العقاري.</p>',NULL,NULL),(8,4,'مؤسسة الإلتزام للمقاولات','en','<p>مؤسسة الالتزام للمقاولات العامة، المؤسسة الرائدة في مجال الإنشاءات ومواد البناء والعقارات عالية الجودة والبناء، بخبرة أكثر من ١٥ سنة في صناعة البناء ضمن منطقة الخليج العربي ومن ١٠ سنة في مجال التطوير العقاري.</p>',NULL,NULL);

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `created_at`, `updated_at`, `image`, `type`) VALUES (2,'2024-12-05 00:08:37','2024-12-05 00:08:37',NULL,1),(3,'2024-12-05 00:09:07','2024-12-05 00:09:07',NULL,1),(4,'2025-01-22 23:50:08','2025-01-22 23:50:08','2025-01-22-590784a1c5f7520b0680d06f9f85f73f.png',2);

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_resets`
--


--
-- Table structure for table `payment_method_translations`
--

CREATE TABLE `payment_method_translations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `payment_method_id` int unsigned NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `payment_method_translations_payment_method_id_locale_unique` (`payment_method_id`,`locale`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_method_translations`
--

INSERT INTO `payment_method_translations` (`id`, `payment_method_id`, `title`, `locale`, `created_at`, `updated_at`) VALUES (1,1,'الدفع عند الاستلام','ar',NULL,NULL),(2,1,'الدفع عند الاستلام','en',NULL,NULL),(3,2,'كي نت','ar',NULL,NULL),(4,2,'كي نت','en',NULL,NULL),(5,3,'كارت الهدية','ar',NULL,NULL),(6,3,'كارت الهدية','en',NULL,NULL);

--
-- Table structure for table `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` (`id`, `image`, `type`, `status`, `created_at`, `updated_at`) VALUES (1,'2022-07-05-cash.png',0,1,'2022-06-22 10:19:52','2022-07-05 11:53:51'),(2,'2022-07-05-knet.png',1,1,'2022-06-22 10:20:09','2022-07-05 11:53:09'),(3,'2023-05-22-1681787942gift1.png',2,0,'2023-05-23 04:50:44','2023-06-18 23:03:23');

--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `permission_role_role_id_foreign` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` (`permission_id`, `role_id`) VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1),(16,1),(17,1),(18,1),(19,1),(20,1),(21,1),(22,1),(23,1),(24,1),(25,1),(26,1),(27,1),(28,1),(29,1),(30,1),(31,1),(32,1),(33,1),(34,1),(35,1),(36,1),(37,1),(38,1),(39,1),(40,1),(41,1),(42,1),(43,1),(44,1),(45,1),(46,1),(47,1),(48,1),(49,1),(50,1),(51,1),(52,1),(53,1),(54,1),(55,1),(56,1),(57,1),(58,1),(59,1),(60,1),(61,1),(62,1),(63,1),(64,1),(2,10),(25,10),(26,10),(27,10),(28,10),(61,10),(62,10),(63,10);

--
-- Table structure for table `permission_user`
--

CREATE TABLE `permission_user` (
  `permission_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `user_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`user_id`,`permission_id`,`user_type`),
  KEY `permission_user_permission_id_foreign` (`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permission_user`
--


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

CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `permissions` (`id`, `name`, `display_name`, `description`, `created_at`, `updated_at`) VALUES (1,'create_users','Create Users','Create Users','2022-06-21 09:32:18','2022-06-21 09:32:18'),(2,'read_users','Read Users','Read Users','2022-06-21 09:32:18','2022-06-21 09:32:18'),(3,'update_users','Update Users','Update Users','2022-06-21 09:32:18','2022-06-21 09:32:18'),(4,'delete_users','Delete Users','Delete Users','2022-06-21 09:32:18','2022-06-21 09:32:18'),(5,'create_roles','Create Roles','Create Roles','2022-06-21 09:32:18','2022-06-21 09:32:18'),(6,'read_roles','Read Roles','Read Roles','2022-06-21 09:32:18','2022-06-21 09:32:18'),(7,'update_roles','Update Roles','Update Roles','2022-06-21 09:32:18','2022-06-21 09:32:18'),(8,'delete_roles','Delete Roles','Delete Roles','2022-06-21 09:32:18','2022-06-21 09:32:18'),(9,'create_notifications','Create Notifications','Create Notifications','2022-06-21 09:32:18','2022-06-21 09:32:18'),(10,'read_notifications','Read Notifications','Read Notifications','2022-06-21 09:32:18','2022-06-21 09:32:18'),(11,'update_notifications','Update Notifications','Update Notifications','2022-06-21 09:32:18','2022-06-21 09:32:18'),(12,'delete_notifications','Delete Notifications','Delete Notifications','2022-06-21 09:32:18','2022-06-21 09:32:18'),(13,'create_sliders','Create Sliders','Create Sliders','2022-06-21 09:32:18','2022-06-21 09:32:18'),(14,'read_sliders','Read Sliders','Read Sliders','2022-06-21 09:32:18','2022-06-21 09:32:18'),(15,'update_sliders','Update Sliders','Update Sliders','2022-06-21 09:32:18','2022-06-21 09:32:18'),(16,'delete_sliders','Delete Sliders','Delete Sliders','2022-06-21 09:32:18','2022-06-21 09:32:18'),(17,'create_settings','Create Settings','Create Settings','2022-06-21 09:32:18','2022-06-21 09:32:18'),(18,'read_settings','Read Settings','Read Settings','2022-06-21 09:32:18','2022-06-21 09:32:18'),(19,'update_settings','Update Settings','Update Settings','2022-06-21 09:32:18','2022-06-21 09:32:18'),(20,'delete_settings','Delete Settings','Delete Settings','2022-06-21 09:32:18','2022-06-21 09:32:18'),(21,'create_categories','Create Categories','Create Categories','2022-06-21 09:32:18','2022-06-21 09:32:18'),(22,'read_categories','Read Categories','Read Categories','2022-06-21 09:32:18','2022-06-21 09:32:18'),(23,'update_categories','Update Categories','Update Categories','2022-06-21 09:32:18','2022-06-21 09:32:18'),(24,'delete_categories','Delete Categories','Delete Categories','2022-06-21 09:32:18','2022-06-21 09:32:18'),(25,'create_offers','Create offers','Create offers','2022-06-21 09:32:18','2022-06-21 09:32:18'),(26,'read_offers','Read offers','Read offers','2022-06-21 09:32:18','2022-06-21 09:32:18'),(27,'update_offers','Update offers','Update offers','2022-06-21 09:32:18','2022-06-21 09:32:18'),(28,'delete_offers','Delete offers','Delete offers','2022-06-21 09:32:18','2022-06-21 09:32:18'),(29,'create_paymentMethods','Create PaymentMethods','Create PaymentMethods','2022-06-21 09:32:18','2022-06-21 09:32:18'),(30,'read_paymentMethods','Read PaymentMethods','Read PaymentMethods','2022-06-21 09:32:18','2022-06-21 09:32:18'),(31,'update_paymentMethods','Update PaymentMethods','Update PaymentMethods','2022-06-21 09:32:18','2022-06-21 09:32:18'),(32,'delete_paymentMethods','Delete PaymentMethods','Delete PaymentMethods','2022-06-21 09:32:18','2022-06-21 09:32:18'),(33,'create_shippingType','Create ShippingType','Create ShippingType','2022-06-21 09:32:18','2022-06-21 09:32:18'),(34,'read_shippingType','Read ShippingType','Read ShippingType','2022-06-21 09:32:18','2022-06-21 09:32:18'),(35,'update_shippingType','Update ShippingType','Update ShippingType','2022-06-21 09:32:18','2022-06-21 09:32:18'),(36,'delete_shippingType','Delete ShippingType','Delete ShippingType','2022-06-21 09:32:18','2022-06-21 09:32:18'),(37,'create_orders','Create Orders','Create Orders','2022-06-21 09:32:18','2022-06-21 09:32:18'),(38,'read_orders','Read Orders','Read Orders','2022-06-21 09:32:18','2022-06-21 09:32:18'),(39,'update_orders','Update Orders','Update Orders','2022-06-21 09:32:18','2022-06-21 09:32:18'),(40,'delete_orders','Delete Orders','Delete Orders','2022-06-21 09:32:18','2022-06-21 09:32:18'),(41,'create_reports','Create Reports','Create Reports','2022-06-21 09:32:18','2022-06-21 09:32:18'),(42,'read_reports','Read Reports','Read Reports','2022-06-21 09:32:18','2022-06-21 09:32:18'),(43,'update_reports','Update Reports','Update Reports','2022-06-21 09:32:18','2022-06-21 09:32:18'),(44,'delete_reports','Delete Reports','Delete Reports','2022-06-21 09:32:18','2022-06-21 09:32:18'),(45,'create_governments','Create Governments','Create Governments','2022-06-21 09:32:18','2022-06-21 09:32:18'),(46,'read_governments','Read Governments','Read Governments','2022-06-21 09:32:18','2022-06-21 09:32:18'),(47,'update_governments','Update Governments','Update Governments','2022-06-21 09:32:18','2022-06-21 09:32:18'),(48,'delete_governments','Delete Governments','Delete Governments','2022-06-21 09:32:18','2022-06-21 09:32:18'),(49,'create_regions','Create Regions','Create Regions','2022-06-21 09:32:18','2022-06-21 09:32:18'),(50,'read_regions','Read Regions','Read Regions','2022-06-21 09:32:18','2022-06-21 09:32:18'),(51,'update_regions','Update Regions','Update Regions','2022-06-21 09:32:18','2022-06-21 09:32:18'),(52,'delete_regions','Delete Regions','Delete Regions','2022-06-21 09:32:18','2022-06-21 09:32:18'),(53,'create_discount','Create Discount','Create Discount','2022-06-21 09:32:18','2022-06-21 09:32:18'),(54,'read_discount','Read Discount','Read Discount','2022-06-21 09:32:18','2022-06-21 09:32:18'),(55,'update_discount','Update Discount','Update Discount','2022-06-21 09:32:18','2022-06-21 09:32:18'),(56,'delete_discount','Delete Discount','Delete Discount','2022-06-21 09:32:18','2022-06-21 09:32:18'),(57,'create_times','Create Times','Create Times','2022-06-21 09:32:18','2022-06-21 09:32:18'),(58,'read_times','Read Times','Read Times','2022-06-21 09:32:18','2022-06-21 09:32:18'),(59,'update_times','Update Times','Update Times','2022-06-21 09:32:18','2022-06-21 09:32:18'),(60,'delete_times','Delete Times','Delete Times','2022-06-21 09:32:18','2022-06-21 09:32:18'),(61,'create_tagers','Create Tagers','Create Tagers','2022-06-21 09:32:18','2022-06-21 09:32:18'),(62,'read_tagers','Read Tagers','Read Tagers','2022-06-21 09:32:18','2022-06-21 09:32:18'),(63,'update_tagers','Update Tagers','Update Tagers','2022-06-21 09:32:18','2022-06-21 09:32:18'),(64,'delete_tagers','Delete Tagers','Delete Tagers','2022-06-21 09:32:18','2022-06-21 09:32:18');

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `personal_access_tokens`
--


--
-- Table structure for table `product_categories`
--

CREATE TABLE `product_categories` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int unsigned DEFAULT NULL,
  `category_id` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_categories_product_id_foreign` (`product_id`),
  KEY `product_categories_category_id_foreign` (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_categories`
--

INSERT INTO `product_categories` (`id`, `product_id`, `category_id`, `created_at`, `updated_at`) VALUES (1,6,15,NULL,NULL),(2,7,15,NULL,NULL),(3,8,16,NULL,NULL),(4,9,16,NULL,NULL),(5,10,17,NULL,NULL),(6,11,1,NULL,NULL),(7,12,15,NULL,NULL),(8,13,15,NULL,NULL),(9,14,15,NULL,NULL),(10,15,15,NULL,NULL),(11,16,15,NULL,NULL),(12,17,15,NULL,NULL),(13,18,15,NULL,NULL),(14,19,15,NULL,NULL),(15,22,18,NULL,NULL),(16,23,18,NULL,NULL),(17,24,18,NULL,NULL),(18,25,18,NULL,NULL),(19,26,15,NULL,NULL),(20,27,17,NULL,NULL),(21,28,15,NULL,NULL),(22,29,15,NULL,NULL),(23,30,16,NULL,NULL),(24,31,15,NULL,NULL),(25,32,15,NULL,NULL),(26,33,15,NULL,NULL),(27,34,15,NULL,NULL),(28,35,15,NULL,NULL),(29,36,15,NULL,NULL),(30,37,15,NULL,NULL),(31,38,15,NULL,NULL),(32,39,15,NULL,NULL),(33,40,15,NULL,NULL),(34,41,15,NULL,NULL),(35,42,15,NULL,NULL),(36,43,15,NULL,NULL),(37,44,15,NULL,NULL),(38,45,15,NULL,NULL),(39,46,17,NULL,NULL),(40,47,15,NULL,NULL),(41,48,15,NULL,NULL),(42,49,15,NULL,NULL),(43,50,15,NULL,NULL),(44,51,15,NULL,NULL),(45,52,15,NULL,NULL),(46,53,15,NULL,NULL),(47,54,15,NULL,NULL),(48,55,15,NULL,NULL),(49,56,15,NULL,NULL),(50,57,15,NULL,NULL),(51,58,15,NULL,NULL),(52,59,15,NULL,NULL),(53,60,15,NULL,NULL),(54,61,15,NULL,NULL),(55,62,25,NULL,NULL),(56,63,15,NULL,NULL),(57,64,17,NULL,NULL),(58,65,15,NULL,NULL);

--
-- Table structure for table `product_content_sections`
--

CREATE TABLE `product_content_sections` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int unsigned DEFAULT NULL,
  `content_section_id` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_content_sections_product_id_foreign` (`product_id`),
  KEY `product_content_sections_content_section_id_foreign` (`content_section_id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_content_sections`
--

INSERT INTO `product_content_sections` (`id`, `product_id`, `content_section_id`, `created_at`, `updated_at`) VALUES (2,90,36,'2024-11-11 23:39:03','2024-11-11 23:39:03'),(40,103,38,'2024-12-07 11:46:16','2024-12-07 11:46:16'),(41,104,38,'2024-12-07 11:46:16','2024-12-07 11:46:16'),(42,110,38,'2024-12-07 11:46:16','2024-12-07 11:46:16'),(43,111,38,'2024-12-07 11:46:16','2024-12-07 11:46:16'),(44,112,38,'2024-12-07 11:46:16','2024-12-07 11:46:16'),(45,114,38,'2024-12-07 11:46:16','2024-12-07 11:46:16'),(46,115,38,'2024-12-07 11:46:16','2024-12-07 11:46:16'),(47,110,37,'2024-12-08 13:44:49','2024-12-08 13:44:49'),(48,111,37,'2024-12-08 13:44:49','2024-12-08 13:44:49'),(49,119,37,'2024-12-08 13:44:49','2024-12-08 13:44:49'),(50,120,37,'2024-12-08 13:44:49','2024-12-08 13:44:49'),(51,114,35,'2024-12-08 13:45:52','2024-12-08 13:45:52'),(52,115,35,'2024-12-08 13:45:52','2024-12-08 13:45:52'),(53,114,35,'2024-12-08 13:45:52','2024-12-08 13:45:52'),(54,115,35,'2024-12-08 13:45:52','2024-12-08 13:45:52'),(55,121,35,'2024-12-08 13:45:52','2024-12-08 13:45:52');

--
-- Table structure for table `product_orders`
--

CREATE TABLE `product_orders` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int unsigned NOT NULL,
  `product_id` int unsigned NOT NULL,
  `user_id` int DEFAULT NULL,
  `quantity` int NOT NULL DEFAULT '1',
  `option` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` decimal(8,2) NOT NULL,
  `shipping_cost` decimal(8,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `offer_id` int DEFAULT NULL,
  `messageCart` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `TypeSended` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `methodSended` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gift` int DEFAULT '0',
  `freeDelivery` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `product_orders_order_id_foreign` (`order_id`),
  KEY `product_orders_product_id_foreign` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_orders`
--


--
-- Table structure for table `product_otherdatas`
--

CREATE TABLE `product_otherdatas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int unsigned DEFAULT NULL,
  `input_key_ar` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `input_value_ar` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `input_key_en` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `input_value_en` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_otherdatas_product_id_foreign` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_otherdatas`
--


--
-- Table structure for table `product_sizes`
--

CREATE TABLE `product_sizes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int unsigned NOT NULL,
  `size_id` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_sizes_product_id_foreign` (`product_id`),
  KEY `product_sizes_size_id_foreign` (`size_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_sizes`
--

INSERT INTO `product_sizes` (`id`, `product_id`, `size_id`, `created_at`, `updated_at`) VALUES (1,1,0,NULL,NULL),(3,2,2,NULL,NULL),(4,3,2,NULL,NULL),(5,4,4,NULL,NULL),(6,5,5,NULL,NULL),(7,6,5,NULL,NULL);

--
-- Table structure for table `product_translations`
--

CREATE TABLE `product_translations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `shortDiscrption` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `meta_keywords` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `address_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `product_translations_product_id_locale_unique` (`product_id`,`locale`),
  KEY `product_translations_locale_index` (`locale`),
  CONSTRAINT `product_translations_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=908 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_translations`
--

INSERT INTO `product_translations` (`id`, `product_id`, `name`, `content`, `shortDiscrption`, `locale`, `created_at`, `updated_at`, `meta_keywords`, `meta_description`, `address_text`) VALUES (1,1,'أحصل على 20% خصم على طلبك','<p>عرض خاص بالمطاعم أحصل على 20% على طلبك من مطاعمنا</p>',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(3,2,'test product2','<h3>Balloon Bunch Pastel (25pcs)</h3>',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(787,3,'test product2','<p>test product2</p>',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(788,3,'test product2','<p>test product2</p>',NULL,'en',NULL,NULL,NULL,NULL,NULL),(789,1,'Get 20% off your order','<p>Special offer for restaurants Get 20% on your order from our restaurants</p>',NULL,'en',NULL,NULL,NULL,NULL,NULL),(790,6,'اعلان جديد','<p>اعلان جديد</p>',NULL,'ar',NULL,NULL,NULL,NULL,'عنوان جديدي'),(791,6,'اعلان جديد','<p>اعلان جديد</p>',NULL,'en',NULL,NULL,NULL,NULL,'عنوان جديدي'),(792,7,'اعلان 2','<p>هذا النص هو مثال لنص يمكن أن يستبدل في نفس المساحة، لقد تم توليد هذا النص من مولد النص العربى، حيث يمكنك أن تولد مثل هذا النص أو العديد من النصوص الأخرى إضافة إلى زيادة عدد الحروف التى يولدها التطبيق.</p>',NULL,'ar',NULL,NULL,NULL,NULL,'اعلان 2'),(793,7,'اعلان 2','<p>هذا النص هو مثال لنص يمكن أن يستبدل في نفس المساحة، لقد تم توليد هذا النص من مولد النص العربى، حيث يمكنك أن تولد مثل هذا النص أو العديد من النصوص الأخرى إضافة إلى زيادة عدد الحروف التى يولدها التطبيق.</p>',NULL,'en',NULL,NULL,NULL,NULL,'اعلان 2'),(794,8,'اعلان 3','<p>هذا النص هو مثال لنص يمكن أن يستبدل في نفس المساحة، لقد تم توليد هذا النص من مولد النص العربى، حيث يمكنك أن تولد مثل هذا النص أو العديد من النصوص الأخرى إضافة إلى زيادة عدد الحروف التى يولدها التطبيق.</p>',NULL,'ar',NULL,NULL,NULL,NULL,'اعلان 3'),(795,8,'اعلان 3','<p>هذا النص هو مثال لنص يمكن أن يستبدل في نفس المساحة، لقد تم توليد هذا النص من مولد النص العربى، حيث يمكنك أن تولد مثل هذا النص أو العديد من النصوص الأخرى إضافة إلى زيادة عدد الحروف التى يولدها التطبيق.</p>',NULL,'en',NULL,NULL,NULL,NULL,'اعلان 3'),(796,9,'اعلان 4','<p>هذا النص هو مثال لنص يمكن أن يستبدل في نفس المساحة، لقد تم توليد هذا النص من مولد النص العربى، حيث يمكنك أن تولد مثل هذا النص أو العديد من النصوص الأخرى إضافة إلى زيادة عدد الحروف التى يولدها التطبيق.</p>',NULL,'ar',NULL,NULL,NULL,NULL,'اعلان 4'),(797,9,'اعلان 4','<p>هذا النص هو مثال لنص يمكن أن يستبدل في نفس المساحة، لقد تم توليد هذا النص من مولد النص العربى، حيث يمكنك أن تولد مثل هذا النص أو العديد من النصوص الأخرى إضافة إلى زيادة عدد الحروف التى يولدها التطبيق.</p>',NULL,'en',NULL,NULL,NULL,NULL,'اعلان 4'),(798,10,'اعلان 5','<p>هذا النص هو مثال لنص يمكن أن يستبدل في نفس المساحة، لقد تم توليد هذا النص من مولد النص العربى، حيث يمكنك أن تولد مثل هذا النص أو العديد من النصوص الأخرى إضافة إلى زيادة عدد الحروف التى يولدها التطبيق.</p>',NULL,'ar',NULL,NULL,NULL,NULL,'اعلان 5'),(799,10,'اعلان 5','<p>هذا النص هو مثال لنص يمكن أن يستبدل في نفس المساحة، لقد تم توليد هذا النص من مولد النص العربى، حيث يمكنك أن تولد مثل هذا النص أو العديد من النصوص الأخرى إضافة إلى زيادة عدد الحروف التى يولدها التطبيق.</p>',NULL,'en',NULL,NULL,NULL,NULL,'اعلان 5'),(800,11,'asdasd','asdasd',NULL,'ar',NULL,NULL,NULL,NULL,'asdasd'),(801,11,'asdasd','asdasdasd',NULL,'en',NULL,NULL,NULL,NULL,'asdasdasd'),(802,12,'asdasd','asdasd',NULL,'ar',NULL,NULL,NULL,NULL,'asdasd'),(803,12,'asdasd','asdasdasd',NULL,'en',NULL,NULL,NULL,NULL,'asdasdasd'),(804,13,'asdasd','asdasd',NULL,'ar',NULL,NULL,NULL,NULL,'asdasd'),(805,13,'asdasd','asdasdasd',NULL,'en',NULL,NULL,NULL,NULL,'asdasdasd'),(806,14,'asdasd','asdasd',NULL,'ar',NULL,NULL,NULL,NULL,'asdasd'),(807,14,'asdasd','asdasdasd',NULL,'en',NULL,NULL,NULL,NULL,'asdasdasd'),(808,15,'اعلان جديد','asdasd',NULL,'ar',NULL,NULL,NULL,NULL,'asdasd'),(809,15,'asdasd','asdasdasd',NULL,'en',NULL,NULL,NULL,NULL,'asdasdasd'),(810,16,'asdasd','asdasd',NULL,'ar',NULL,NULL,NULL,NULL,'asdasd'),(811,16,'asdasd','asdasdasd',NULL,'en',NULL,NULL,NULL,NULL,'asdasdasd'),(812,17,'asdasd','asdasd',NULL,'ar',NULL,NULL,NULL,NULL,'asdasd'),(813,17,'asdasd','asdasdasd',NULL,'en',NULL,NULL,NULL,NULL,'asdasdasd'),(814,18,'text1','asdasd',NULL,'ar',NULL,NULL,NULL,NULL,'asdasd'),(815,18,'asdasd','asdasdasd',NULL,'en',NULL,NULL,NULL,NULL,'asdasdasd'),(816,19,'text1','asdasd',NULL,'ar',NULL,NULL,NULL,NULL,'asdasd'),(817,19,'asdasd','asdasdasd',NULL,'en',NULL,NULL,NULL,NULL,'asdasdasd'),(818,20,'qq','qq',NULL,'ar',NULL,NULL,NULL,NULL,'qq'),(819,21,'qq','qq',NULL,'ar',NULL,NULL,NULL,NULL,'qq'),(820,22,'e','e',NULL,'ar',NULL,NULL,NULL,NULL,'e'),(821,22,'e','e',NULL,'en',NULL,NULL,NULL,NULL,'e'),(822,23,'e','e',NULL,'ar',NULL,NULL,NULL,NULL,'e'),(823,23,'e','e',NULL,'en',NULL,NULL,NULL,NULL,'e'),(824,24,'e','e',NULL,'ar',NULL,NULL,NULL,NULL,'e'),(825,24,'e','e',NULL,'en',NULL,NULL,NULL,NULL,'e'),(826,25,'e','e',NULL,'ar',NULL,NULL,NULL,NULL,'e'),(827,25,'e','e',NULL,'en',NULL,NULL,NULL,NULL,'e'),(828,26,'شقة للبيع','اعلان ٢',NULL,'ar',NULL,NULL,NULL,NULL,'اسالمية'),(829,26,'Apartment for sale','Announcement 2',NULL,'en',NULL,NULL,NULL,NULL,'Asklia'),(830,27,'شقة','٣٤',NULL,'ar',NULL,NULL,NULL,NULL,'تتتت'),(831,27,'apartment','٣٤',NULL,'en',NULL,NULL,NULL,NULL,'Tat'),(832,28,'text1','asdasd',NULL,'ar',NULL,NULL,NULL,NULL,'asdasd'),(833,28,'asdasd','asdasdasd',NULL,'en',NULL,NULL,NULL,NULL,'asdasdasd'),(834,29,'text1','asdasd',NULL,'ar',NULL,NULL,NULL,NULL,'asdasd'),(835,29,'asdasd','asdasdasd',NULL,'en',NULL,NULL,NULL,NULL,'asdasdasd'),(836,30,'tferwt','dfsgsdf',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(837,30,'TFferwt','dfsgsdf',NULL,'en',NULL,NULL,NULL,NULL,NULL),(838,31,'fdsgd','fdsgsdf',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(839,31,'fdsgd','fdsgsdf',NULL,'en',NULL,NULL,NULL,NULL,NULL),(840,32,'dfgsfd','sdfgsfd',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(841,32,'dfgsfd','sdfgsfd',NULL,'en',NULL,NULL,NULL,NULL,NULL),(842,33,'dfgsfd','sdfgsfd',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(843,33,'dfgsfd','sdfgsfd',NULL,'en',NULL,NULL,NULL,NULL,NULL),(844,34,'sdfdsaf','fdsgsdg',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(845,34,'SDFDSAF','fdsgsdg',NULL,'en',NULL,NULL,NULL,NULL,NULL),(846,35,'sdfdsaf','fdsgsdg',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(847,35,'SDFDSAF','fdsgsdg',NULL,'en',NULL,NULL,NULL,NULL,NULL),(848,36,'jkhh','lkj',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(849,36,'JHKH','LKJ',NULL,'en',NULL,NULL,NULL,NULL,NULL),(850,37,'jkhh','lkj',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(851,37,'JHKH','LKJ',NULL,'en',NULL,NULL,NULL,NULL,NULL),(852,38,'jkhh','lkj',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(853,38,'JHKH','LKJ',NULL,'en',NULL,NULL,NULL,NULL,NULL),(854,39,'jkhh','lkj',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(855,39,'JHKH','LKJ',NULL,'en',NULL,NULL,NULL,NULL,NULL),(856,40,'jkhh','lkj',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(857,40,'JHKH','LKJ',NULL,'en',NULL,NULL,NULL,NULL,NULL),(858,41,'jkhh','lkj',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(859,41,'JHKH','LKJ',NULL,'en',NULL,NULL,NULL,NULL,NULL),(860,42,'jkhh','lkj',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(861,42,'JHKH','LKJ',NULL,'en',NULL,NULL,NULL,NULL,NULL),(862,43,'jkhh','lkj',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(863,43,'JHKH','LKJ',NULL,'en',NULL,NULL,NULL,NULL,NULL),(864,44,'jkhh','lkj',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(865,44,'JHKH','LKJ',NULL,'en',NULL,NULL,NULL,NULL,NULL),(866,45,'jkhh','lkj',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(867,45,'JHKH','LKJ',NULL,'en',NULL,NULL,NULL,NULL,NULL),(868,46,'anwer test app','safdfdsaf',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(869,46,'anwer test app','safdfdsaf',NULL,'en',NULL,NULL,NULL,NULL,NULL),(870,47,'dddddddddd','uuuuuu',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(871,47,'dddddddddd','Uuuuuuu',NULL,'en',NULL,NULL,NULL,NULL,NULL),(872,48,'dddddddddd','uuuuuu',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(873,48,'dddddddddd','Uuuuuuu',NULL,'en',NULL,NULL,NULL,NULL,NULL),(874,49,'eqwrqwer','qwerewq',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(875,49,'eqwrqwer','qwerewq',NULL,'en',NULL,NULL,NULL,NULL,NULL),(876,50,'eqwrqwer','qwerewq',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(877,50,'eqwrqwer','qwerewq',NULL,'en',NULL,NULL,NULL,NULL,NULL),(878,51,'eqwrqwer','qwerewq',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(879,51,'eqwrqwer','qwerewq',NULL,'en',NULL,NULL,NULL,NULL,NULL),(880,52,'eqwrqwer','qwerewq',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(881,52,'eqwrqwer','qwerewq',NULL,'en',NULL,NULL,NULL,NULL,NULL),(882,53,'eqwrqwer','qwerewq',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(883,53,'eqwrqwer','qwerewq',NULL,'en',NULL,NULL,NULL,NULL,NULL),(884,54,'eqwrqwer','qwerewq',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(885,54,'eqwrqwer','qwerewq',NULL,'en',NULL,NULL,NULL,NULL,NULL),(886,55,'eqwrqwer','qwerewq',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(887,55,'eqwrqwer','qwerewq',NULL,'en',NULL,NULL,NULL,NULL,NULL),(888,56,'eqwrqwer','qwerewq',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(889,56,'eqwrqwer','qwerewq',NULL,'en',NULL,NULL,NULL,NULL,NULL),(890,57,'test test test','weqrqwer',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(891,57,'test test test','weqrqwer',NULL,'en',NULL,NULL,NULL,NULL,NULL),(892,58,'ewrewqr','ewrewq',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(893,58,'eurrewqr','ewrewq',NULL,'en',NULL,NULL,NULL,NULL,NULL),(894,59,'asd asd asd','sadfsdafs',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(895,59,'asd asd asd','sadfsdafs',NULL,'en',NULL,NULL,NULL,NULL,NULL),(896,60,'asd','<p>srwer</p>',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(897,60,'asd','<p>SRWer</p>',NULL,'en',NULL,NULL,NULL,NULL,NULL),(898,61,'تازرز داا','راتتت',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(899,61,'Tazars Da','Rett',NULL,'en',NULL,NULL,NULL,NULL,NULL),(900,62,'فندق 1','<p>فندق 1</p>',NULL,'ar',NULL,NULL,NULL,NULL,'فندق 1'),(901,62,'فندق 1',NULL,NULL,'en',NULL,NULL,NULL,NULL,'فندق 1'),(902,63,'إعلان جديد','تتنزدددد',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(903,63,'New ad.','Disad',NULL,'en',NULL,NULL,NULL,NULL,NULL),(904,64,'تزززتتز','فلا',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(905,64,'Tzhazitz','No',NULL,'en',NULL,NULL,NULL,NULL,NULL),(906,65,'yrtwy','tryrtey',NULL,'ar',NULL,NULL,NULL,NULL,NULL),(907,65,'yrtwy','tryrtey',NULL,'en',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int unsigned DEFAULT NULL,
  `option` enum('true','false') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('pending','reject','active') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `reason` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `Codevalue` decimal(8,3) DEFAULT NULL,
  `order` int DEFAULT NULL,
  `lat` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `long` varchar(111) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(111) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `whatapp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discrimination` int DEFAULT NULL,
  `aqar_id` int DEFAULT NULL,
  `region_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `products_user_id_foreign` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `image`, `user_id`, `option`, `code`, `status`, `reason`, `deleted_at`, `created_at`, `updated_at`, `Codevalue`, `order`, `lat`, `long`, `address`, `phone`, `whatapp`, `price`, `discrimination`, `aqar_id`, `region_id`) VALUES (1,'2024-11-27-offer 20%.jpg',103,NULL,'102030405060','active',NULL,'2025-01-23 00:05:25','2024-11-10 23:09:25','2025-01-23 00:05:25',20.000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,NULL,NULL,NULL,NULL,'pending',NULL,'2024-11-16 17:00:10','2024-11-16 16:57:46','2024-11-16 17:00:10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,NULL,94,NULL,'333','active',NULL,'2025-01-23 00:05:21','2024-11-19 21:44:50','2025-01-23 00:05:21',33.000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,NULL,NULL,NULL,NULL,'pending',NULL,'2024-11-25 23:28:47','2024-11-24 14:00:43','2024-11-25 23:28:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,NULL,NULL,NULL,NULL,'pending',NULL,'2024-11-25 23:31:35','2024-11-25 23:29:34','2024-11-25 23:31:35',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'2025-01-28-cbed569cf91e48dc8dd7aec8ae0d3610.png',1,NULL,NULL,'active',NULL,NULL,'2025-01-23 00:05:28','2025-02-09 18:48:25',NULL,NULL,'29.33800089','48.01700617333986','82Q8+8PH، شارع 85، حولي، الكويت‎','444444','55555','33',1,19,20),(7,'2025-01-29-an-10.avif',1,NULL,NULL,'active',NULL,NULL,'2025-01-29 16:36:55','2025-02-09 18:47:25',NULL,NULL,'29.34757771','47.992630257812515','26-30 شارع محمد صالح الحميضي، الكويت‎','111111111','111111','10',1,NULL,NULL),(8,'2025-01-29-an-7.avif',1,NULL,NULL,'active',NULL,NULL,'2025-01-29 16:39:37','2025-02-09 18:47:48',NULL,NULL,'29.38911932','47.9955468498291','9XQW+C86، شارع 10، مدينة الكويت، الكويت‎','22222','1222','11',1,NULL,NULL),(9,'2025-01-29-an-11.avif',1,NULL,NULL,'active',NULL,NULL,'2025-01-29 16:40:41','2025-02-09 18:48:05',NULL,NULL,'29.38264374','47.998330478295905','قطعة 2،، مدينة الكويت، الكويت‎','23','3454325','23',1,NULL,NULL),(10,'2025-01-29-an-12.avif',1,NULL,NULL,'active',NULL,NULL,'2025-01-29 16:43:57','2025-02-09 18:48:14',NULL,NULL,'29.35281466','47.992630257812515','9X3V+659، الكويت‎','4356453634','4564536','14',1,NULL,NULL),(11,NULL,128,NULL,NULL,'pending',NULL,'2025-02-04 22:48:49','2025-02-04 22:46:37','2025-02-04 22:48:49',NULL,NULL,'123123','12312321',NULL,'23432432',NULL,'333',1,2,1),(12,NULL,128,NULL,NULL,'pending',NULL,'2025-02-04 22:48:53','2025-02-04 22:47:40','2025-02-04 22:48:53',NULL,NULL,'123123','12312321',NULL,'23432432',NULL,'333',1,19,19),(13,'2025-02-04-1736874329.jpg',128,NULL,NULL,'pending',NULL,'2025-02-04 22:48:59','2025-02-04 22:48:09','2025-02-04 22:48:59',NULL,NULL,'123123','12312321',NULL,'23432432',NULL,'333',1,19,19),(14,'2025-02-04-1736874329.jpg',128,NULL,NULL,'active',NULL,'2025-02-06 14:12:53','2025-02-04 22:48:38','2025-02-06 14:12:53',NULL,NULL,'123123','12312321',NULL,'23432432',NULL,'333',1,19,19),(15,'2025-02-04-1736874329.jpg',128,NULL,NULL,'pending',NULL,'2025-02-04 23:31:39','2025-02-04 23:26:28','2025-02-04 23:31:39',NULL,NULL,'123123','12312321',NULL,'23432432',NULL,'333',1,19,19),(16,NULL,128,NULL,NULL,'pending',NULL,'2025-02-06 14:13:07','2025-02-06 13:45:37','2025-02-06 14:13:07',NULL,NULL,'123123','12312321',NULL,'23432432',NULL,'333',1,19,19),(17,NULL,128,NULL,NULL,'pending',NULL,'2025-02-06 14:13:21','2025-02-06 14:11:49','2025-02-06 14:13:21',NULL,NULL,'123123','12312321',NULL,'23432432',NULL,'333',1,19,19),(18,NULL,128,NULL,NULL,'pending',NULL,'2025-02-08 00:20:52','2025-02-06 14:13:40','2025-02-08 00:20:52',NULL,NULL,'123123','12312321',NULL,'23432432',NULL,'333',1,19,19),(19,NULL,128,NULL,NULL,'pending',NULL,'2025-02-08 00:20:30','2025-02-06 17:09:03','2025-02-08 00:20:30',NULL,NULL,'123123','12312321',NULL,'23432432',NULL,'333',1,19,19),(20,NULL,128,NULL,NULL,'pending',NULL,'2025-02-08 00:20:26','2025-02-08 00:15:30','2025-02-08 00:20:26',NULL,NULL,'0.0','0.0',NULL,'qq',NULL,'qq',0,19,19),(21,NULL,128,NULL,NULL,'pending',NULL,'2025-02-08 00:20:23','2025-02-08 00:16:03','2025-02-08 00:20:23',NULL,NULL,'0.0','0.0',NULL,'qq',NULL,'qq',0,19,19),(22,NULL,128,NULL,NULL,'pending',NULL,'2025-02-08 00:20:20','2025-02-08 00:17:21','2025-02-08 00:20:20',NULL,NULL,'0.0','0.0',NULL,'e',NULL,'e',0,19,23),(23,NULL,128,NULL,NULL,'pending',NULL,'2025-02-08 00:21:01','2025-02-08 00:17:36','2025-02-08 00:21:01',NULL,NULL,'0.0','0.0',NULL,'e',NULL,'e',0,19,23),(24,NULL,128,NULL,NULL,'pending',NULL,'2025-02-08 00:20:41','2025-02-08 00:18:51','2025-02-08 00:20:41',NULL,NULL,'0.0','0.0',NULL,'e',NULL,'e',0,19,23),(25,NULL,128,NULL,NULL,'pending',NULL,'2025-02-08 00:20:38','2025-02-08 00:18:58','2025-02-08 00:20:38',NULL,NULL,'0.0','0.0',NULL,'e',NULL,'e',0,19,23),(26,NULL,128,NULL,NULL,'pending',NULL,'2025-02-09 00:04:17','2025-02-08 00:39:37','2025-02-09 00:04:17',NULL,NULL,'0.0','0.0',NULL,'٤٥٦٦٦٧٧٧',NULL,'٢٢',0,19,19),(27,'2025-02-08-images.jpg',128,NULL,NULL,'pending',NULL,'2025-02-09 00:04:14','2025-02-08 01:10:09','2025-02-09 00:04:14',NULL,NULL,'0.0','0.0',NULL,'٦٦٦٦٦٦٦',NULL,'١٢',0,19,21),(28,NULL,128,NULL,NULL,'pending',NULL,'2025-02-09 00:34:35','2025-02-09 00:09:25','2025-02-09 00:34:35',NULL,NULL,'123123','12312321',NULL,'23432432',NULL,'333',1,19,19),(29,'2025-02-09-download.jpg',128,NULL,NULL,'pending',NULL,'2025-02-09 00:45:45','2025-02-09 00:10:33','2025-02-09 00:45:45',NULL,NULL,'123123','12312321',NULL,'23432432',NULL,'333',1,19,19),(30,NULL,128,NULL,NULL,'pending',NULL,'2025-02-09 00:35:10','2025-02-09 00:26:34','2025-02-09 00:35:10',NULL,NULL,'0.0','0.0',NULL,'42352435',NULL,'234',0,19,19),(31,'2025-02-09-download (2).jpg',128,NULL,NULL,'pending',NULL,'2025-02-09 00:34:46','2025-02-09 00:28:05','2025-02-09 00:34:46',NULL,NULL,'0.0','0.0',NULL,'3245423',NULL,'444',0,19,19),(32,'2025-02-09-download (2).jpg',128,NULL,NULL,'pending',NULL,'2025-02-09 00:34:41','2025-02-09 00:34:09','2025-02-09 00:34:41',NULL,NULL,'0.0','0.0',NULL,'4353425',NULL,'3425324',0,19,23),(33,'2025-02-09-download (2).jpg',128,NULL,NULL,'pending',NULL,'2025-02-09 00:35:06','2025-02-09 00:34:17','2025-02-09 00:35:06',NULL,NULL,'0.0','0.0',NULL,'4353425',NULL,'3425324',0,19,23),(34,'2025-02-09-download.jpg',128,NULL,NULL,'pending',NULL,'2025-02-09 00:45:28','2025-02-09 00:36:48','2025-02-09 00:45:28',NULL,NULL,'0.0','0.0',NULL,'2435234',NULL,'34532',0,19,19),(35,'2025-02-09-download.jpg',128,NULL,NULL,'pending',NULL,'2025-02-09 00:45:36','2025-02-09 00:36:56','2025-02-09 00:45:36',NULL,NULL,'0.0','0.0',NULL,'2435234',NULL,'34532',0,19,19),(36,'2025-02-09-download (2).jpg',128,NULL,NULL,'pending',NULL,'2025-02-09 00:45:33','2025-02-09 00:39:08','2025-02-09 00:45:33',NULL,NULL,'0.0','0.0',NULL,'786876768',NULL,'66',0,19,19),(37,'2025-02-09-download (2).jpg',128,NULL,NULL,'pending',NULL,'2025-02-09 00:45:49','2025-02-09 00:39:28','2025-02-09 00:45:49',NULL,NULL,'0.0','0.0',NULL,'786876768',NULL,'66',0,19,19),(38,'2025-02-09-download (2).jpg',128,NULL,NULL,'active',NULL,NULL,'2025-02-09 00:39:46','2025-02-09 18:45:39',NULL,NULL,'0.0','0.0',NULL,'786876768',NULL,'66',0,19,19),(39,'2025-02-09-download (2).jpg',128,NULL,NULL,'pending',NULL,'2025-02-09 00:45:52','2025-02-09 00:40:04','2025-02-09 00:45:52',NULL,NULL,'0.0','0.0',NULL,'786876768',NULL,'66',0,19,19),(40,'2025-02-09-download (2).jpg',128,NULL,NULL,'active',NULL,NULL,'2025-02-09 00:40:35','2025-02-09 18:45:37',NULL,NULL,'0.0','0.0',NULL,'786876768',NULL,'66',0,19,19),(41,'2025-02-09-download (2).jpg',128,NULL,NULL,'active',NULL,NULL,'2025-02-09 00:41:18','2025-02-09 18:45:34',NULL,NULL,'0.0','0.0',NULL,'786876768',NULL,'66',0,19,19),(42,'2025-02-09-download (2).jpg',128,NULL,NULL,'pending',NULL,NULL,'2025-02-09 00:43:18','2025-02-09 00:43:18',NULL,NULL,'0.0','0.0',NULL,'786876768',NULL,'66',0,19,19),(43,'2025-02-09-download (2).jpg',128,NULL,NULL,'pending',NULL,NULL,'2025-02-09 00:43:39','2025-02-09 00:43:39',NULL,NULL,'0.0','0.0',NULL,'786876768',NULL,'66',0,19,19),(44,'2025-02-09-download (2).jpg',128,NULL,NULL,'pending',NULL,NULL,'2025-02-09 00:43:50','2025-02-09 00:43:50',NULL,NULL,'0.0','0.0',NULL,'786876768',NULL,'66',0,19,19),(45,'2025-02-09-download (2).jpg',128,NULL,NULL,'pending',NULL,NULL,'2025-02-09 00:44:29','2025-02-09 00:44:29',NULL,NULL,'0.0','0.0',NULL,'786876768',NULL,'66',0,19,19),(46,'2025-02-09-download.jpg',128,NULL,NULL,'pending',NULL,NULL,'2025-02-09 00:48:39','2025-02-09 00:48:39',NULL,NULL,'0.0','0.0',NULL,'24562435243',NULL,'23452345',0,19,19),(47,'2025-02-09-images.jpg',128,NULL,NULL,'active',NULL,NULL,'2025-02-09 00:51:05','2025-02-09 10:03:28',NULL,NULL,'0.0','0.0',NULL,'78876876867',NULL,'76',0,19,20),(48,'2025-02-09-images.jpg',128,NULL,NULL,'pending',NULL,NULL,'2025-02-09 00:51:16','2025-02-09 00:51:16',NULL,NULL,'0.0','0.0',NULL,'78876876867',NULL,'76',0,19,20),(49,'2025-02-09-images.jpg',128,NULL,NULL,'pending',NULL,NULL,'2025-02-09 00:55:49','2025-02-09 00:55:49',NULL,NULL,'0.0','0.0',NULL,'3245324',NULL,'43532',0,19,27),(50,'2025-02-09-images.jpg',128,NULL,NULL,'pending',NULL,NULL,'2025-02-09 00:56:10','2025-02-09 00:56:10',NULL,NULL,'0.0','0.0',NULL,'3245324',NULL,'43532',0,19,27),(51,'2025-02-09-images.jpg',128,NULL,NULL,'pending',NULL,NULL,'2025-02-09 00:56:43','2025-02-09 00:56:43',NULL,NULL,'0.0','0.0',NULL,'3245324',NULL,'43532',0,19,27),(52,'2025-02-09-images.jpg',128,NULL,NULL,'pending',NULL,NULL,'2025-02-09 00:58:19','2025-02-09 00:58:19',NULL,NULL,'0.0','0.0',NULL,'3245324',NULL,'43532',0,19,27),(53,'2025-02-09-images.jpg',128,NULL,NULL,'pending',NULL,NULL,'2025-02-09 01:00:25','2025-02-09 01:00:25',NULL,NULL,'0.0','0.0',NULL,'3245324',NULL,'43532',0,19,27),(54,'2025-02-09-images.jpg',128,NULL,NULL,'pending',NULL,NULL,'2025-02-09 01:00:49','2025-02-09 01:00:49',NULL,NULL,'0.0','0.0',NULL,'3245324',NULL,'43532',0,19,27),(55,'2025-02-09-images.jpg',128,NULL,NULL,'pending',NULL,NULL,'2025-02-09 01:01:21','2025-02-09 01:01:21',NULL,NULL,'0.0','0.0',NULL,'3245324',NULL,'43532',0,19,27),(56,'2025-02-09-images.jpg',128,NULL,NULL,'pending',NULL,NULL,'2025-02-09 01:01:58','2025-02-09 01:01:58',NULL,NULL,'0.0','0.0',NULL,'3245324',NULL,'43532',0,19,27),(57,'2025-02-09-images.jpg',128,NULL,NULL,'active',NULL,NULL,'2025-02-09 01:04:26','2025-02-09 10:03:36',NULL,NULL,'0.0','0.0',NULL,'43252345',NULL,'sadfdsafa',0,19,19),(58,'2025-02-09-download.jpg',128,NULL,NULL,'pending',NULL,NULL,'2025-02-09 01:06:44','2025-02-09 01:06:44',NULL,NULL,'0.0','0.0',NULL,'3452345',NULL,'222',0,19,24),(59,'2025-02-09-images.jpg',128,NULL,NULL,'pending',NULL,NULL,'2025-02-09 01:10:22','2025-02-09 01:10:22',NULL,NULL,'0.0','0.0',NULL,'4353245',NULL,'sdfdsaf',0,19,21),(60,'2025-02-09-IMG_E9565-scaled.jpg',1,NULL,NULL,'active',NULL,NULL,'2025-02-09 09:57:16','2025-02-09 18:48:40',NULL,NULL,'29.38219500','47.976014499292','9XJG+VCM، مدينة الكويت، الكويت‎','34252345',NULL,'23',0,19,19),(61,'2025-02-09-image_picker_977A2D58-FC3A-41F3-B1A0-50776B654876-6042-000000976C70A9AF.jpg',128,NULL,NULL,'pending',NULL,'2025-02-09 18:45:16','2025-02-09 15:57:48','2025-02-09 18:45:16',NULL,NULL,'0.0','0.0',NULL,'76544567767',NULL,'22',0,19,92),(62,'2025-02-09-images.jpg',1,NULL,NULL,'active',NULL,NULL,'2025-02-09 19:00:51','2025-02-09 19:03:07',NULL,NULL,'29.36463420','47.99022699853517','Soor Street Shaheed Park Second Phase Sharq، مدينة الكويت، الكويت‎','4354325432','34534253232','12',1,20,19),(63,'2025-06-15-image_picker_7D7963F9-095F-47C5-949D-6F2E483DB658-789-00000011BF2D09AA.jpg',128,NULL,NULL,'active',NULL,NULL,'2025-06-15 11:35:58','2025-06-15 11:38:55',NULL,NULL,'0.0','0.0',NULL,'56565566665',NULL,'56645',0,19,19),(64,'2025-06-15-image_picker_FDD1DB35-B7D7-417E-B29C-2FCCE832DA16-1595-000000320B9C3F1C.jpg',128,NULL,NULL,'pending',NULL,NULL,'2025-06-15 13:13:27','2025-06-15 13:13:27',NULL,NULL,'0.0','0.0',NULL,'ادا',NULL,'تارت',0,19,19),(65,'2025-06-15-image_picker_A519D8AE-7905-41AE-9485-FCFDA387263B-48613-0000162666987A64.jpg',128,NULL,NULL,'pending',NULL,NULL,'2025-06-15 17:03:56','2025-06-15 17:03:56',NULL,NULL,'0.0','0.0',NULL,'rteyrteyrerety',NULL,'retyrteyr',0,19,19);

--
-- Table structure for table `public_notifcations`
--

CREATE TABLE `public_notifcations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `public_notifcations_user_id_foreign` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `public_notifcations`
--

INSERT INTO `public_notifcations` (`id`, `user_id`, `title`, `message`, `data`, `created_at`, `updated_at`) VALUES (1,1,'asd','asdasd','{\"image\":\"https:\\/\\/offerapp.topapp-kw.com\\/storage\\/images\\/notifications\\/\\/tmp\\/phpdT71Pg\"}','2024-11-24 00:15:37','2024-11-24 00:15:37');

--
-- Table structure for table `refund_products`
--

CREATE TABLE `refund_products` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `product_order_id` int unsigned DEFAULT NULL,
  `product_id` int unsigned DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `restore` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `refund_products_user_id_foreign` (`user_id`),
  KEY `refund_products_product_id_foreign` (`product_id`),
  KEY `refund_products_product_order_id_foreign` (`product_order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `refund_products`
--

INSERT INTO `refund_products` (`id`, `user_id`, `product_order_id`, `product_id`, `type`, `notes`, `created_at`, `updated_at`, `restore`) VALUES (1,173,285,206,'توالف',NULL,'2022-08-25 19:15:46','2022-08-25 19:15:46',0);

--
-- Table structure for table `region_translations`
--

CREATE TABLE `region_translations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `region_id` int unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `arrival` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `region_translations_region_id_locale_unique` (`region_id`,`locale`),
  KEY `region_translations_locale_index` (`locale`)
) ENGINE=InnoDB AUTO_INCREMENT=1693 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `region_translations`
--

INSERT INTO `region_translations` (`id`, `region_id`, `name`, `locale`, `created_at`, `updated_at`, `arrival`) VALUES (37,19,'مدينة الكويت','ar',NULL,NULL,'بعد ٢٤ ساعة'),(38,19,'Kuwait City','en',NULL,NULL,'After 24 Hours'),(39,20,'دسمان','ar',NULL,NULL,'بعد ٢٤ ساعة'),(40,20,'Dasman','en',NULL,NULL,'After 24 Hours'),(41,21,'شرق','ar',NULL,NULL,'بعد ٢٤ ساعة'),(42,21,'Sharq','en',NULL,NULL,'After 24 Hours'),(43,22,'الصوابر','ar',NULL,NULL,'بعد ٢٤ ساعة'),(44,22,'Sawber','en',NULL,NULL,'After 24 Hours'),(45,23,'المرقاب','ar',NULL,NULL,'بعد ٢٤ ساعة'),(46,23,'Mirqab','en',NULL,NULL,'After 24 Hours'),(47,24,'القبلة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(48,24,'Qibla','en',NULL,NULL,'After 24 Hours'),(49,25,'الصالحية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(50,25,'Salhiya','en',NULL,NULL,'After 24 Hours'),(51,26,'الوطية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(52,26,'Watiya','en',NULL,NULL,'After 24 Hours'),(53,27,'بنيد القار','ar',NULL,NULL,'بعد ٢٤ ساعة'),(54,27,'Bneid Al Gar','en',NULL,NULL,'After 24 Hours'),(55,28,'كيفان','ar',NULL,NULL,'بعد ٢٤ ساعة'),(56,28,'Kefan','en',NULL,NULL,'After 24 Hours'),(57,29,'الدوحة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(58,29,'Doha','en',NULL,NULL,'After 24 Hours'),(59,30,'الدسمة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(60,30,'Dasma','en',NULL,NULL,'After 24 Hours'),(61,31,'الدعية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(62,31,'Daiya','en',NULL,NULL,'After 24 Hours'),(63,32,'المنصورية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(64,32,'Mansoriya','en',NULL,NULL,'After 24 Hours'),(65,33,'ضاحية عبد الله السالم','ar',NULL,NULL,'بعد ٢٤ ساعة'),(66,33,'Abdulallah Al-Salem','en',NULL,NULL,'After 24 Hours'),(67,34,'النزهة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(68,34,'Nuzha','en',NULL,NULL,'After 24 Hours'),(69,35,'الفيحاء','ar',NULL,NULL,'بعد ٢٤ ساعة'),(70,35,'Faiha','en',NULL,NULL,'After 24 Hours'),(71,36,'الشامية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(72,36,'Shamiya','en',NULL,NULL,'After 24 Hours'),(73,37,'الروضة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(74,37,'Rawda','en',NULL,NULL,'After 24 Hours'),(75,38,'العديلية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(76,38,'Adileya','en',NULL,NULL,'After 24 Hours'),(77,39,'الخالدية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(78,39,'Khaldiya','en',NULL,NULL,'After 24 Hours'),(79,40,'القادسية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(80,40,'Qadsiya','en',NULL,NULL,'After 24 Hours'),(81,41,'قرطبة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(82,41,'Qurtoba','en',NULL,NULL,'After 24 Hours'),(83,42,'السرة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(84,42,'Surra','en',NULL,NULL,'After 24 Hours'),(85,43,'اليرموك','ar',NULL,NULL,'بعد ٢٤ ساعة'),(86,43,'Yarmouk','en',NULL,NULL,'After 24 Hours'),(87,44,'الشويخ','ar',NULL,NULL,'بعد ٢٤ ساعة'),(88,44,'Shuwaikh','en',NULL,NULL,'After 24 Hours'),(89,45,'الري','ar',NULL,NULL,'بعد ٢٤ ساعة'),(90,45,'Alrai','en',NULL,NULL,'After 24 Hours'),(91,46,'غرناطة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(92,46,'Granatha','en',NULL,NULL,'After 24 Hours'),(93,47,'الصليبيخات','ar',NULL,NULL,'بعد ٢٤ ساعة'),(94,47,'Sulaibikhat','en',NULL,NULL,'After 24 Hours'),(95,48,'النهضة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(96,48,'Nahda','en',NULL,NULL,'After 24 Hours'),(97,49,'مدينة جابر الأحمد','ar',NULL,NULL,'بعد ٢٤ ساعة'),(98,49,'Jaber Al Ahmed','en',NULL,NULL,'After 24 Hours'),(99,50,'القيروان','ar',NULL,NULL,'بعد ٢٤ ساعة'),(100,50,'Qairawan','en',NULL,NULL,'After 24 Hours'),(101,51,'شمال غرب الصليبيخات','ar',NULL,NULL,'بعد ٢٤ ساعة'),(102,51,'East Sulibkhat','en',NULL,NULL,'After 24 Hours'),(103,52,'الفنطاس','ar',NULL,NULL,'بعد ٢٤ ساعة'),(104,52,'Fintas','en',NULL,NULL,'After 24 Hours'),(105,53,'العقيلة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(106,53,'Eqaila','en',NULL,NULL,'After 24 Hours'),(107,54,'الظهر','ar',NULL,NULL,'بعد ٢٤ ساعة'),(108,54,'Zuhor','en',NULL,NULL,'After 24 Hours'),(109,55,'المقوع','ar',NULL,NULL,'بعد ٢٤ ساعة'),(110,55,'Moqwa','en',NULL,NULL,'After 24 Hours'),(111,56,'المهبولة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(112,56,'Mahboula','en',NULL,NULL,'After 24 Hours'),(113,57,'الرقة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(114,57,'Riqqa','en',NULL,NULL,'After 24 Hours'),(115,58,'هدية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(116,58,'Hadiya','en',NULL,NULL,'After 24 Hours'),(117,59,'أبو حليفة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(118,59,'Abu Halifa','en',NULL,NULL,'After 24 Hours'),(119,60,'الصباحية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(120,60,'Sabahiya','en',NULL,NULL,'After 24 Hours'),(121,61,'المنقف','ar',NULL,NULL,'بعد ٢٤ ساعة'),(122,61,'Manqaf','en',NULL,NULL,'After 24 Hours'),(123,62,'الفحيحيل','ar',NULL,NULL,'بعد ٢٤ ساعة'),(124,62,'Fahaheel','en',NULL,NULL,'After 24 Hours'),(125,63,'الأحمدي','ar',NULL,NULL,'بعد ٢٤ ساعة'),(126,63,'Ahmadi','en',NULL,NULL,'After 24 Hours'),(127,64,'الوفرة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(128,64,'Wafra','en',NULL,NULL,'After 24 Hours'),(129,65,'الزور','ar',NULL,NULL,'بعد ٢٤ ساعة'),(130,65,'Zoor','en',NULL,NULL,'After 24 Hours'),(131,66,'الخيران','ar',NULL,NULL,'بعد ٢٤ ساعة'),(132,66,'Al Khiran','en',NULL,NULL,'After 24 Hours'),(133,67,'ميناء عبد الله','ar',NULL,NULL,'بعد ٢٤ ساعة'),(134,67,'Menaa Abdulallah','en',NULL,NULL,'After 24 Hours'),(135,68,'الوفرة الزراعية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(136,68,'Al Wafra Ziraeya','en',NULL,NULL,'After 24 Hours'),(137,69,'بنيدر','ar',NULL,NULL,'بعد ٢٤ ساعة'),(138,69,'Binder','en',NULL,NULL,'After 24 Hours'),(139,70,'الجليعة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(140,70,'Gelaya','en',NULL,NULL,'After 24 Hours'),(141,71,'الضباعية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(142,71,'Dabiya','en',NULL,NULL,'After 24 Hours'),(143,72,'ضاحية جابر العلي','ar',NULL,NULL,'بعد ٢٤ ساعة'),(144,72,'Jaber Al Ali','en',NULL,NULL,'بعد ٢٤ ساعة'),(145,73,'ضاحية فهد الأحمد','ar',NULL,NULL,'بعد ٢٤ ساعة'),(146,73,'Fahad Al Ahmad','en',NULL,NULL,'After 24 Hours'),(147,74,'الشعيبة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(148,74,'Sheeyba','en',NULL,NULL,'After 24 Hours'),(149,75,'واره','ar',NULL,NULL,'بعد ٢٤ ساعة'),(150,75,'Waaraa','en',NULL,NULL,'After 24 Hours'),(151,76,'مدينة صباح الأحمد','ar',NULL,NULL,'بعد ٢٤ ساعة'),(152,76,'Sabah Al Ahmad','en',NULL,NULL,'After 24 Hours'),(153,77,'النويصيب','ar',NULL,NULL,'بعد ٢٤ ساعة'),(154,77,'Nouyseb','en',NULL,NULL,'After 24 Hours'),(155,78,'مدينة الخيران','ar',NULL,NULL,'بعد ٢٤ ساعة'),(156,78,'Al Khairan City','en',NULL,NULL,'After 24 Hours'),(157,79,'ضاحية علي صباح السالم أم الهيمان سابقاً','ar',NULL,NULL,'بعد ٢٤ ساعة'),(158,79,'Ali Sabah Al Salem','en',NULL,NULL,'After 24 Hours'),(159,80,'مدينة صباح الأحمد البحرية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(160,80,'Sabah Al Ahmad Bahria','en',NULL,NULL,'After 24 Hours'),(161,81,'أبرق خيطان','ar',NULL,NULL,'بعد ٢٤ ساعة'),(162,81,'Abraq Khaitan','en',NULL,NULL,'After 24 Hours'),(163,82,'الأندلس','ar',NULL,NULL,'بعد ٢٤ ساعة'),(164,82,'Andalous','en',NULL,NULL,'After 24 Hours'),(165,83,'اشبيلية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(166,83,'Ishbiliya','en',NULL,NULL,'After 24 Hours'),(167,84,'جليب الشيوخ','ar',NULL,NULL,'بعد ٢٤ ساعة'),(168,84,'Jeleeb Al Shuyoukh','en',NULL,NULL,'After 24 Hours'),(169,85,'خيطان','ar',NULL,NULL,'بعد ٢٤ ساعة'),(170,85,'Khaitan','en',NULL,NULL,'After 24 Hours'),(171,86,'خيطان الجديدة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(172,86,'New Khaitan','en',NULL,NULL,'After 24 Hours'),(173,87,'العمرية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(174,87,'Omariya','en',NULL,NULL,'After 24 Hours'),(175,88,'العارضية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(176,88,'Ardiya','en',NULL,NULL,'After 24 Hours'),(177,89,'العارضية الصناعية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(178,89,'Ardiya Industrial','en',NULL,NULL,'After 24 Hours'),(179,90,'العباسية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(180,90,'Abasiya','en',NULL,NULL,'After 24 Hours'),(181,91,'الفردوس','ar',NULL,NULL,'بعد ٢٤ ساعة'),(182,91,'Firdous','en',NULL,NULL,'After 24 Hours'),(183,92,'الفروانية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(184,92,'Farwaniya','en',NULL,NULL,'After 24 Hours'),(185,93,'الحساوي','ar',NULL,NULL,'بعد ٢٤ ساعة'),(186,93,'Hasawi','en',NULL,NULL,'After 24 Hours'),(187,94,'الشدادية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(188,94,'Shadadya','en',NULL,NULL,'After 24 Hours'),(189,95,'الرابية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(190,95,'Rabiya','en',NULL,NULL,'After 24 Hours'),(191,96,'الرحاب','ar',NULL,NULL,'بعد ٢٤ ساعة'),(192,96,'Rehab','en',NULL,NULL,'After 24 Hours'),(193,97,'الرقعي','ar',NULL,NULL,'بعد ٢٤ ساعة'),(194,97,'Al Riggae','en',NULL,NULL,'After 24 Hours'),(195,98,'الري الصناعية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(196,98,'Al Rai Industrial','en',NULL,NULL,'After 24 Hours'),(197,99,'ضاحية صباح الناصر','ar',NULL,NULL,'بعد ٢٤ ساعة'),(198,99,'Sabah Al Nasser','en',NULL,NULL,'After 24 Hours'),(199,100,'ضاحية عبد الله المبارك','ar',NULL,NULL,'بعد ٢٤ ساعة'),(200,100,'Abdullah Mubarak','en',NULL,NULL,'After 24 Hours'),(201,101,'الضجيج','ar',NULL,NULL,'بعد ٢٤ ساعة'),(202,101,'Al Dajeej','en',NULL,NULL,'After 24 Hours'),(203,102,'الصليبية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(204,102,'Al Sulaibiya','en',NULL,NULL,'After 24 Hours'),(205,103,'أمغرة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(206,103,'Amgra','en',NULL,NULL,'After 24 Hours'),(207,104,'النعيم','ar',NULL,NULL,'بعد ٢٤ ساعة'),(208,104,'Naeem','en',NULL,NULL,'After 24 Hours'),(209,105,'القصر','ar',NULL,NULL,'بعد ٢٤ ساعة'),(210,105,'Qasr','en',NULL,NULL,'After 24 Hours'),(211,106,'الواحة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(212,106,'Waha','en',NULL,NULL,'After 24 Hours'),(213,107,'تيماء','ar',NULL,NULL,'بعد ٢٤ ساعة'),(214,107,'Taima','en',NULL,NULL,'After 24 Hours'),(215,108,'النسيم','ar',NULL,NULL,'بعد ٢٤ ساعة'),(216,108,'Nassem','en',NULL,NULL,'After 24 Hours'),(217,109,'العيون','ar',NULL,NULL,'بعد ٢٤ ساعة'),(218,109,'Oyoun','en',NULL,NULL,'After 24 Hours'),(219,110,'القيصرية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(220,110,'Qaysariyya','en',NULL,NULL,'After 24 Hours'),(221,111,'العبدلي','ar',NULL,NULL,'بعد ٢٤ ساعة'),(222,111,'Abdali','en',NULL,NULL,'After 24 Hours'),(223,112,'الجهراء القديمة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(224,112,'Old Jahra','en',NULL,NULL,'After 24 Hours'),(225,113,'الجهراء الجديدة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(226,113,'New jahra','en',NULL,NULL,'After 24 Hours'),(227,114,'كاظمة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(228,114,'Kazma','en',NULL,NULL,'After 24 Hours'),(229,115,'مدينة سعد العبد الله','ar',NULL,NULL,'بعد ٢٤ ساعة'),(230,115,'Saad - Al-abdullah','en',NULL,NULL,'After 24 Hours'),(231,116,'السالمي','ar',NULL,NULL,'بعد ٢٤ ساعة'),(232,116,'Alsalmi','en',NULL,NULL,'After 24 Hours'),(233,117,'المطلاع','ar',NULL,NULL,'بعد ٢٤ ساعة'),(234,117,'Al Muţlā','en',NULL,NULL,'After 24 Hours'),(235,118,'مدينة الحرير','ar',NULL,NULL,'بعد ٢٤ ساعة'),(236,118,'Harir city','en',NULL,NULL,'After 24 Hours'),(237,119,'كبد','ar',NULL,NULL,'بعد ٢٤ ساعة'),(238,119,'Kabad','en',NULL,NULL,'After 24 Hours'),(239,120,'الروضتين','ar',NULL,NULL,'بعد ٢٤ ساعة'),(240,120,'Al Rawdatain','en',NULL,NULL,'After 24 Hours'),(241,121,'الصبية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(242,121,'Subiya','en',NULL,NULL,'After 24 Hours'),(243,122,'حولي','ar',NULL,NULL,'بعد ٢٤ ساعة'),(244,122,'Hawalli','en',NULL,NULL,'After 24 Hours'),(245,123,'الشعب','ar',NULL,NULL,'بعد ٢٤ ساعة'),(246,123,'Shaab','en',NULL,NULL,'After 24 Hours'),(247,124,'السالمية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(248,124,'Salmiya','en',NULL,NULL,'After 24 Hours'),(249,125,'الرميثية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(250,125,'Rumaithiya','en',NULL,NULL,'After 24 Hours'),(251,126,'الجابرية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(252,126,'Jabriya','en',NULL,NULL,'After 24 Hours'),(253,127,'مشرف','ar',NULL,NULL,'بعد ٢٤ ساعة'),(254,127,'Meshrif','en',NULL,NULL,'After 24 Hours'),(255,128,'بيان','ar',NULL,NULL,'بعد ٢٤ ساعة'),(256,128,'Bayan','en',NULL,NULL,'After 24 Hours'),(257,129,'آلبدع','ar',NULL,NULL,'بعد ٢٤ ساعة'),(258,129,'Al Bidaa','en',NULL,NULL,'After 24 Hours'),(259,130,'النقرة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(260,130,'Noqra','en',NULL,NULL,'After 24 Hours'),(261,131,'ميدان حولي','ar',NULL,NULL,'بعد ٢٤ ساعة'),(262,131,'Maidan Hawally','en',NULL,NULL,'After 24 Hours'),(263,132,'ضاحية مبارك العبد الله الجابر','ar',NULL,NULL,'بعد ٢٤ ساعة'),(264,132,'Mubarak Al Abdullah','en',NULL,NULL,'After 24 Hours'),(265,133,'سلوى','ar',NULL,NULL,'بعد ٢٤ ساعة'),(266,133,'Salwa','en',NULL,NULL,'After 24 Hours'),(267,134,'جنوب السرة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(268,134,'Jnoub Surra','en',NULL,NULL,'After 24 Hours'),(269,135,'الزهراء','ar',NULL,NULL,'بعد ٢٤ ساعة'),(270,135,'Al Zahra','en',NULL,NULL,'After 24 Hours'),(271,136,'الصديق','ar',NULL,NULL,'بعد ٢٤ ساعة'),(272,136,'Al Siddeeq','en',NULL,NULL,'After 24 Hours'),(273,137,'حطين','ar',NULL,NULL,'بعد ٢٤ ساعة'),(274,137,'Hateen','en',NULL,NULL,'After 24 Hours'),(275,138,'السلام','ar',NULL,NULL,'بعد ٢٤ ساعة'),(276,138,'Al Salam','en',NULL,NULL,'After 24 Hours'),(277,139,'الشهداء','ar',NULL,NULL,'بعد ٢٤ ساعة'),(278,139,'Shuhada','en',NULL,NULL,'After 24 Hours'),(279,140,'العدان','ar',NULL,NULL,'بعد ٢٤ ساعة'),(280,140,'Adan','en',NULL,NULL,'After 24 Hours'),(281,141,'القصور','ar',NULL,NULL,'بعد ٢٤ ساعة'),(282,141,'Qusor','en',NULL,NULL,'After 24 Hours'),(283,142,'القرين','ar',NULL,NULL,'بعد ٢٤ ساعة'),(284,142,'Al Qurain','en',NULL,NULL,'After 24 Hours'),(285,143,'ضاحية صباح السالم','ar',NULL,NULL,'بعد ٢٤ ساعة'),(286,143,'Sabah Al Salem','en',NULL,NULL,'After 24 Hours'),(287,144,'المسيلة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(288,144,'Messila','en',NULL,NULL,'After 24 Hours'),(289,145,'المسايل','ar',NULL,NULL,'بعد ٢٤ ساعة'),(290,145,'Masayel','en',NULL,NULL,'After 24 Hours'),(291,146,'أبو فطيرة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(292,146,'Abu Fteira','en',NULL,NULL,'After 24 Hours'),(293,147,'أبو الحصانية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(294,147,'Abu Al Hasaniya','en',NULL,NULL,'After 24 Hours'),(295,148,'صبحان','ar',NULL,NULL,'بعد ٢٤ ساعة'),(296,148,'Sabhan','en',NULL,NULL,'After 24 Hours'),(297,149,'الفنيطيس','ar',NULL,NULL,'بعد ٢٤ ساعة'),(298,149,'Fintas','en',NULL,NULL,'After 24 Hours'),(301,151,'ضاحيه مبارك الكبير','ar',NULL,NULL,'ضاحيه مبارك الكبير'),(302,151,'Mubarak Al Kabeer','en',NULL,NULL,'ضاحيه مبارك الكبير'),(303,152,'ابو ظبي','ar',NULL,NULL,NULL),(304,152,'Abu Dhabi','en',NULL,NULL,NULL),(305,153,'العارضية','ar',NULL,NULL,NULL),(306,153,'Al Ardiyah','en',NULL,NULL,NULL),(307,154,'الذربانية','ar',NULL,NULL,NULL),(308,154,'Al Dharbaniyah','en',NULL,NULL,NULL),(309,155,'الذيد','ar',NULL,NULL,NULL),(310,155,'Al Dhaid','en',NULL,NULL,NULL),(311,156,'الدوس','ar',NULL,NULL,NULL),(312,156,'Al Duss','en',NULL,NULL,NULL),(313,157,'الختم','ar',NULL,NULL,NULL),(314,157,'Al Khatem','en',NULL,NULL,NULL),(315,158,'المفرق','ar',NULL,NULL,NULL),(316,158,'Al Mafraq','en',NULL,NULL,NULL),(317,159,'المقطع','ar',NULL,NULL,NULL),(318,159,'Al Maqta','en',NULL,NULL,NULL),(319,160,'المرفأ','ar',NULL,NULL,NULL),(320,160,'Al Marfa','en',NULL,NULL,NULL),(321,161,'البطين','ar',NULL,NULL,NULL),(322,161,'Buteen','en',NULL,NULL,NULL),(323,162,'حبشان','ar',NULL,NULL,NULL),(324,162,'Habshan','en',NULL,NULL,NULL),(325,163,'خنور','ar',NULL,NULL,NULL),(326,163,'Khannur','en',NULL,NULL,NULL),(327,164,'المفرق','ar',NULL,NULL,NULL),(328,164,'Mafraq','en',NULL,NULL,NULL),(329,165,'مصفح','ar',NULL,NULL,NULL),(330,165,'Mussafah','en',NULL,NULL,NULL),(331,166,'عجمان','ar',NULL,NULL,NULL),(332,166,'Ajman City','en',NULL,NULL,NULL),(333,167,'الزهرا','ar',NULL,NULL,NULL),(334,167,'Al Zahra','en',NULL,NULL,NULL),(335,168,'بستان','ar',NULL,NULL,NULL),(336,168,'Al Bustan','en',NULL,NULL,NULL),(337,169,'جرف','ar',NULL,NULL,NULL),(338,169,'Al Jurf','en',NULL,NULL,NULL),(339,170,'مسفط','ar',NULL,NULL,NULL),(340,170,'Masfut','en',NULL,NULL,NULL),(341,171,'رشيدية','ar',NULL,NULL,NULL),(342,171,'Rashidiya','en',NULL,NULL,NULL),(343,172,'العين','ar',NULL,NULL,NULL),(344,172,'Al Ain City','en',NULL,NULL,NULL),(345,173,'الحير','ar',NULL,NULL,NULL),(346,173,'Al Hayr','en',NULL,NULL,NULL),(347,174,'ريما','ar',NULL,NULL,NULL),(348,174,'Rima','en',NULL,NULL,NULL),(349,175,'ابو هيل','ar',NULL,NULL,NULL),(350,175,'Abu Hail','en',NULL,NULL,NULL),(351,176,'الروية','ar',NULL,NULL,NULL),(352,176,'Al Ruwayyah','en',NULL,NULL,NULL),(353,177,'بردبي','ar',NULL,NULL,NULL),(354,177,'Bur Dubai','en',NULL,NULL,NULL),(355,178,'مدينة دبي للإنترنت','ar',NULL,NULL,NULL),(356,178,'Dubai Internet City','en',NULL,NULL,NULL),(357,179,'غنتوت','ar',NULL,NULL,NULL),(358,179,'Ghantoot','en',NULL,NULL,NULL),(359,180,'السلع','ar',NULL,NULL,NULL),(360,180,'Sila','en',NULL,NULL,NULL),(361,181,'Sweihan','ar',NULL,NULL,NULL),(362,181,'Sweihan','en',NULL,NULL,NULL),(363,182,'Umm Al Nar','ar',NULL,NULL,NULL),(364,182,'Umm Al Nar','en',NULL,NULL,NULL),(365,183,'حتا','ar',NULL,NULL,NULL),(366,183,'Hatta','en',NULL,NULL,NULL),(367,184,'هور العنز','ar',NULL,NULL,NULL),(368,184,'Horl Al Anz','en',NULL,NULL,NULL),(369,185,'الجميرة','ar',NULL,NULL,NULL),(370,185,'Jumeirah','en',NULL,NULL,NULL),(371,186,'الكرامة','ar',NULL,NULL,NULL),(372,186,'Karama','en',NULL,NULL,NULL),(373,187,'ميناء سفوح','ar',NULL,NULL,NULL),(374,187,'Mina Sufooh','en',NULL,NULL,NULL),(375,188,'مردف','ar',NULL,NULL,NULL),(376,188,'Mirdif','en',NULL,NULL,NULL),(377,189,'القصيص','ar',NULL,NULL,NULL),(378,189,'Al Qusais','en',NULL,NULL,NULL),(379,190,'ريم','ar',NULL,NULL,NULL),(380,190,'Reem Community','en',NULL,NULL,NULL),(381,191,'السطوة','ar',NULL,NULL,NULL),(382,191,'Satwa','en',NULL,NULL,NULL),(383,192,'Al Shindagha','ar',NULL,NULL,NULL),(384,192,'Al Shindagha','en',NULL,NULL,NULL),(385,193,'مشرف','ar',NULL,NULL,NULL),(386,193,'Mushrif','en',NULL,NULL,NULL),(387,194,'Rashidiyah','ar',NULL,NULL,NULL),(388,194,'Rashidiyah','en',NULL,NULL,NULL),(389,195,'ورسان','ar',NULL,NULL,NULL),(390,195,'Warsan','en',NULL,NULL,NULL),(391,196,'عبادلة','ar',NULL,NULL,NULL),(392,196,'Abadilah','en',NULL,NULL,NULL),(393,197,'العكامية','ar',NULL,NULL,NULL),(394,197,'Akamiyah','en',NULL,NULL,NULL),(395,198,'الحيل','ar',NULL,NULL,NULL),(396,198,'Al Hayl','en',NULL,NULL,NULL),(397,199,'دبا','ar',NULL,NULL,NULL),(398,199,'Diba','en',NULL,NULL,NULL),(399,200,'دبا البيعة','ar',NULL,NULL,NULL),(400,200,'Dibba Al Baya','en',NULL,NULL,NULL),(401,201,'دبا الحصن','ar',NULL,NULL,NULL),(402,201,'Dibba Al-Hisn','en',NULL,NULL,NULL),(403,202,'الفجيرة','ar',NULL,NULL,NULL),(404,202,'Fujairah','en',NULL,NULL,NULL),(405,203,'الفورفار','ar',NULL,NULL,NULL),(406,203,'Al Ghurfah','en',NULL,NULL,NULL),(407,204,'الغورفة','ar',NULL,NULL,NULL),(408,204,'Farfar','en',NULL,NULL,NULL),(409,205,'دبا حسان','ar',NULL,NULL,NULL),(410,205,'Hassan Dibba','en',NULL,NULL,NULL),(411,206,'كلباء','ar',NULL,NULL,NULL),(412,206,'Kalba','en',NULL,NULL,NULL),(413,207,'خور فكان','ar',NULL,NULL,NULL),(414,207,'Khawr Fakkan','en',NULL,NULL,NULL),(415,208,'خور كلباء','ar',NULL,NULL,NULL),(416,208,'Khawr Kalba','en',NULL,NULL,NULL),(417,209,'قدفع','ar',NULL,NULL,NULL),(418,209,'Kidfa','en',NULL,NULL,NULL),(419,210,'مسافي','ar',NULL,NULL,NULL),(420,210,'Masafi','en',NULL,NULL,NULL),(421,211,'Qidfa','ar',NULL,NULL,NULL),(422,211,'Qidfa','en',NULL,NULL,NULL),(423,212,'Rughaylat','ar',NULL,NULL,NULL),(424,212,'Rughaylat','en',NULL,NULL,NULL),(425,213,'سكمكم','ar',NULL,NULL,NULL),(426,213,'Saqamqam','en',NULL,NULL,NULL),(427,214,'سيجي','ar',NULL,NULL,NULL),(428,214,'Siji','en',NULL,NULL,NULL),(429,215,'ديرة','ar',NULL,NULL,NULL),(430,215,'Deira','en',NULL,NULL,NULL),(431,216,'طريف كلباء','ar',NULL,NULL,NULL),(432,216,'Tarif Kalba','en',NULL,NULL,NULL),(433,217,'دبي','ar',NULL,NULL,NULL),(434,217,'Dubai','en',NULL,NULL,NULL),(435,218,'Al Fulayyah','ar',NULL,NULL,NULL),(436,218,'Al Fulayyah','en',NULL,NULL,NULL),(437,219,'الحمرانية','ar',NULL,NULL,NULL),(438,219,'Al Hamraniyah','en',NULL,NULL,NULL),(439,220,'الجزيرة','ar',NULL,NULL,NULL),(440,220,'Al Jazirah','en',NULL,NULL,NULL),(441,221,'الجزيرة الحمراء','ar',NULL,NULL,NULL),(442,221,'Al Jazirah Al Hamra','en',NULL,NULL,NULL),(443,222,'المنامة','ar',NULL,NULL,NULL),(444,222,'Manama','en',NULL,NULL,NULL),(445,223,'الرمس','ar',NULL,NULL,NULL),(446,223,'Al Rams','en',NULL,NULL,NULL),(447,224,'الشعم','ar',NULL,NULL,NULL),(448,224,'Al Sham','en',NULL,NULL,NULL),(449,225,'عوانات','ar',NULL,NULL,NULL),(450,225,'Awanat','en',NULL,NULL,NULL),(451,226,'الخران','ar',NULL,NULL,NULL),(452,226,'Al Kharran','en',NULL,NULL,NULL),(453,227,'خت','ar',NULL,NULL,NULL),(454,227,'Khatt','en',NULL,NULL,NULL),(455,228,'خور خوير','ar',NULL,NULL,NULL),(456,228,'Khuwayr','en',NULL,NULL,NULL),(457,229,'النخيل','ar',NULL,NULL,NULL),(458,229,'Nakheel','en',NULL,NULL,NULL),(459,230,'راس الخيمة','ar',NULL,NULL,NULL),(460,230,'Ras Al Khaimah','en',NULL,NULL,NULL),(461,231,'شعم','ar',NULL,NULL,NULL),(462,231,'Sham','en',NULL,NULL,NULL),(463,232,'أبو شغارة','ar',NULL,NULL,NULL),(464,232,'Abu Shagara','en',NULL,NULL,NULL),(465,233,'العزرة','ar',NULL,NULL,NULL),(466,233,'Al Azra','en',NULL,NULL,NULL),(467,234,'Al Fahiya','ar',NULL,NULL,NULL),(468,234,'Al Fahiya','en',NULL,NULL,NULL),(469,235,'الفلج','ar',NULL,NULL,NULL),(470,235,'Al Falaj','en',NULL,NULL,NULL),(471,236,'الحمريه','ar',NULL,NULL,NULL),(472,236,'Al Hamriyah','en',NULL,NULL,NULL),(473,237,'الخان','ar',NULL,NULL,NULL),(474,237,'Al Khan','en',NULL,NULL,NULL),(475,238,'الكشافة','ar',NULL,NULL,NULL),(476,238,'Al Khasfah','en',NULL,NULL,NULL),(477,239,'المناخ','ar',NULL,NULL,NULL),(478,239,'Al Manakh','en',NULL,NULL,NULL),(479,240,'القاسمية','ar',NULL,NULL,NULL),(480,240,'Al Qasimia','en',NULL,NULL,NULL),(481,241,'التعاون','ar',NULL,NULL,NULL),(482,241,'Al Taawun','en',NULL,NULL,NULL),(483,242,'الواسط','ar',NULL,NULL,NULL),(484,242,'Al Wasit','en',NULL,NULL,NULL),(485,243,'البدية','ar',NULL,NULL,NULL),(486,243,'Badiyah','en',NULL,NULL,NULL),(487,244,'بوطينة','ar',NULL,NULL,NULL),(488,244,'Buteena','en',NULL,NULL,NULL),(489,245,'الذيد','ar',NULL,NULL,NULL),(490,245,'Dhaid','en',NULL,NULL,NULL),(491,246,'الغافية','ar',NULL,NULL,NULL),(492,246,'Al Ghafia','en',NULL,NULL,NULL),(493,247,'الغبيبة','ar',NULL,NULL,NULL),(494,247,'Ghubaiba','en',NULL,NULL,NULL),(495,248,'الجزات','ar',NULL,NULL,NULL),(496,248,'Jazzat','en',NULL,NULL,NULL),(497,249,'Kharayan','ar',NULL,NULL,NULL),(498,249,'Kharayan','en',NULL,NULL,NULL),(499,250,'ضاحية اللية','ar',NULL,NULL,NULL),(500,250,'Layyah','en',NULL,NULL,NULL),(501,251,'ميسلون','ar',NULL,NULL,NULL),(502,251,'Maisaloon','en',NULL,NULL,NULL),(503,252,'المجرة','ar',NULL,NULL,NULL),(504,252,'Al Majarah','en',NULL,NULL,NULL),(505,253,'المنصورة','ar',NULL,NULL,NULL),(506,253,'Mansoora','en',NULL,NULL,NULL),(507,254,'موافجة','ar',NULL,NULL,NULL),(508,254,'Muwafjah','en',NULL,NULL,NULL),(509,255,'النبأ','ar',NULL,NULL,NULL),(510,255,'Al Nabbah','en',NULL,NULL,NULL),(511,256,'النخيلات','ar',NULL,NULL,NULL),(512,256,'Al Nakheelat','en',NULL,NULL,NULL),(513,257,'الناصرية','ar',NULL,NULL,NULL),(514,257,'Nasariya','en',NULL,NULL,NULL),(515,258,'الرماقية','ar',NULL,NULL,NULL),(516,258,'Al Ramaqiya','en',NULL,NULL,NULL),(517,259,'الرملة','ar',NULL,NULL,NULL),(518,259,'Ramlah','en',NULL,NULL,NULL),(519,260,'الرمثاء','ar',NULL,NULL,NULL),(520,260,'Al Ramtha','en',NULL,NULL,NULL),(521,261,'Rolla','ar',NULL,NULL,NULL),(522,261,'Rolla','en',NULL,NULL,NULL),(523,262,'Saabah','ar',NULL,NULL,NULL),(524,262,'Saabah','en',NULL,NULL,NULL),(525,263,'Saif','ar',NULL,NULL,NULL),(526,263,'Saif','en',NULL,NULL,NULL),(527,264,'سمنان','ar',NULL,NULL,NULL),(528,264,'Samnan','en',NULL,NULL,NULL),(529,265,'الشهباء','ar',NULL,NULL,NULL),(530,265,'Shahba','en',NULL,NULL,NULL),(531,266,'الشارقة','ar',NULL,NULL,NULL),(532,266,'Sharjah','en',NULL,NULL,NULL),(533,267,'Umm Kanoor','ar',NULL,NULL,NULL),(534,267,'Umm Kanoor','en',NULL,NULL,NULL),(535,268,'واسط','ar',NULL,NULL,NULL),(536,268,'Wasit','en',NULL,NULL,NULL),(537,269,'اليرموك','ar',NULL,NULL,NULL),(538,269,'Al Yarmook','en',NULL,NULL,NULL),(539,270,'فلج المعلا','ar',NULL,NULL,NULL),(540,270,'Falaj Al Mulla','en',NULL,NULL,NULL),(541,271,'ام القيوين','ar',NULL,NULL,NULL),(542,271,'Umm Al Quwain','en',NULL,NULL,NULL),(543,272,'اللذيذ','ar',NULL,NULL,NULL),(544,272,'Dhaid','en',NULL,NULL,NULL),(545,273,'شرقان','ar',NULL,NULL,NULL),(546,273,'Sherqan','en',NULL,NULL,NULL),(547,274,'الفيحاء','ar',NULL,NULL,NULL),(548,274,'Al Fahiya','en',NULL,NULL,NULL),(549,275,'دسمان','ar',NULL,NULL,NULL),(550,275,'Dasman','en',NULL,NULL,NULL),(551,276,'المندق','ar',NULL,NULL,NULL),(552,276,'Al Mandaq','en',NULL,NULL,NULL),(553,277,'بلجرشي','ar',NULL,NULL,NULL),(554,277,'Baljurashi','en',NULL,NULL,NULL),(555,278,'قلوة','ar',NULL,NULL,NULL),(556,278,'Qalwa','en',NULL,NULL,NULL),(557,279,'القرى','ar',NULL,NULL,NULL),(558,279,'Qura','en',NULL,NULL,NULL),(559,280,'دومة الجندل','ar',NULL,NULL,NULL),(560,280,'Dumat Al Jandal','en',NULL,NULL,NULL),(561,281,'الجوف','ar',NULL,NULL,NULL),(562,281,'Jouf','en',NULL,NULL,NULL),(563,282,'القريات','ar',NULL,NULL,NULL),(564,282,'Quurayyat','en',NULL,NULL,NULL),(565,283,'سكاكا','ar',NULL,NULL,NULL),(566,283,'Sakakah','en',NULL,NULL,NULL),(567,284,'الحناكية','ar',NULL,NULL,NULL),(568,284,'Al Hinakiyah','en',NULL,NULL,NULL),(569,285,'بدر','ar',NULL,NULL,NULL),(570,285,'Badr','en',NULL,NULL,NULL),(571,286,'خيبر','ar',NULL,NULL,NULL),(572,286,'Khaybar','en',NULL,NULL,NULL),(573,287,'المدينة المنورة','ar',NULL,NULL,NULL),(574,287,'Madinah','en',NULL,NULL,NULL),(575,288,'المهد','ar',NULL,NULL,NULL),(576,288,'Mahd Al Thahab','en',NULL,NULL,NULL),(577,289,'العلا','ar',NULL,NULL,NULL),(578,289,'Oula','en',NULL,NULL,NULL),(579,290,'ينبع البحر','ar',NULL,NULL,NULL),(580,290,'Yanbu Al Bahr','en',NULL,NULL,NULL),(581,291,'ابها','ar',NULL,NULL,NULL),(582,291,'Abha','en',NULL,NULL,NULL),(583,292,'احد رفيده','ar',NULL,NULL,NULL),(584,292,'Ahad Rafidah','en',NULL,NULL,NULL),(585,293,'بللسمر','ar',NULL,NULL,NULL),(586,293,'Billasmar','en',NULL,NULL,NULL),(587,294,'بللا حمر','ar',NULL,NULL,NULL),(588,294,'Billahmar','en',NULL,NULL,NULL),(589,295,'بيشة','ar',NULL,NULL,NULL),(590,295,'Bisha','en',NULL,NULL,NULL),(591,296,'خميس مشيط','ar',NULL,NULL,NULL),(592,296,'Khamis Mushayt','en',NULL,NULL,NULL),(593,297,'المجارده','ar',NULL,NULL,NULL),(594,297,'Al Majardah','en',NULL,NULL,NULL),(595,298,'محائل','ar',NULL,NULL,NULL),(596,298,'Muhayil','en',NULL,NULL,NULL),(597,299,'رجال المع','ar',NULL,NULL,NULL),(598,299,'Rijal Alma','en',NULL,NULL,NULL),(599,300,'سراة عبيدة','ar',NULL,NULL,NULL),(600,300,'Sarat Abidah','en',NULL,NULL,NULL),(601,301,'Sarat Abidah','ar',NULL,NULL,NULL),(602,301,'Sarat Abidah','en',NULL,NULL,NULL),(603,302,'تثليث','ar',NULL,NULL,NULL),(604,302,'Tathlith','en',NULL,NULL,NULL),(605,303,'عين الدار','ar',NULL,NULL,NULL),(606,303,'Ain Dar','en',NULL,NULL,NULL),(607,304,'الاحساء','ar',NULL,NULL,NULL),(608,304,'Al Hasa','en',NULL,NULL,NULL),(609,305,'الجش','ar',NULL,NULL,NULL),(610,305,'Al Jsh','en',NULL,NULL,NULL),(611,306,'عنك','ar',NULL,NULL,NULL),(612,306,'Anak','en',NULL,NULL,NULL),(613,307,'العوامية','ar',NULL,NULL,NULL),(614,307,'Awamiah','en',NULL,NULL,NULL),(615,308,'بقيق','ar',NULL,NULL,NULL),(616,308,'Baqiq','en',NULL,NULL,NULL),(617,309,'البطحة','ar',NULL,NULL,NULL),(618,309,'Batha','en',NULL,NULL,NULL),(619,310,'الظهران','ar',NULL,NULL,NULL),(620,310,'Dhahran','en',NULL,NULL,NULL),(621,311,'حرض','ar',NULL,NULL,NULL),(622,311,'Harad','en',NULL,NULL,NULL),(623,312,'الحوية','ar',NULL,NULL,NULL),(624,312,'Hawiyah','en',NULL,NULL,NULL),(625,313,'الهفوف','ar',NULL,NULL,NULL),(626,313,'Hofuf','en',NULL,NULL,NULL),(627,314,'Al Jafar','ar',NULL,NULL,NULL),(628,314,'Al Jafarr','en',NULL,NULL,NULL),(629,315,'الجبيل','ar',NULL,NULL,NULL),(630,315,'Jubail','en',NULL,NULL,NULL),(631,316,'الخوضرية','ar',NULL,NULL,NULL),(632,316,'Al Khodaria','en',NULL,NULL,NULL),(633,317,'المبرز','ar',NULL,NULL,NULL),(634,317,'Mubaraz','en',NULL,NULL,NULL),(635,318,'مليجة','ar',NULL,NULL,NULL),(636,318,'Mulaija','en',NULL,NULL,NULL),(637,319,'النابية','ar',NULL,NULL,NULL),(638,319,'An Nabiyah','en',NULL,NULL,NULL),(639,320,'نويريه','ar',NULL,NULL,NULL),(640,320,'Noweirieh','en',NULL,NULL,NULL),(641,321,'Ojam','ar',NULL,NULL,NULL),(642,321,'Ojam','en',NULL,NULL,NULL),(643,322,'العثمانية','ar',NULL,NULL,NULL),(644,322,'Uthmaniyah','en',NULL,NULL,NULL),(645,323,'القارة','ar',NULL,NULL,NULL),(646,323,'Qarah','en',NULL,NULL,NULL),(647,324,'قارة العليا','ar',NULL,NULL,NULL),(648,324,'Qaryat Al Ulya','en',NULL,NULL,NULL),(649,325,'الرحيمة','ar',NULL,NULL,NULL),(650,325,'Rahima','en',NULL,NULL,NULL),(651,326,'راس الخير','ar',NULL,NULL,NULL),(652,326,'Ras Al Khair','en',NULL,NULL,NULL),(653,327,'الصفنية','ar',NULL,NULL,NULL),(654,327,'Safaniya','en',NULL,NULL,NULL),(655,328,'صفوى','ar',NULL,NULL,NULL),(656,328,'Safwa','en',NULL,NULL,NULL),(657,329,'سلوى','ar',NULL,NULL,NULL),(658,329,'Salwa','en',NULL,NULL,NULL),(659,330,'سرار','ar',NULL,NULL,NULL),(660,330,'Al Sarar','en',NULL,NULL,NULL),(661,331,'الساتروب','ar',NULL,NULL,NULL),(662,331,'Satorp','en',NULL,NULL,NULL),(663,332,'سيهات','ar',NULL,NULL,NULL),(664,332,'Saihat','en',NULL,NULL,NULL),(665,333,'تناجيب','ar',NULL,NULL,NULL),(666,333,'Tanajib','en',NULL,NULL,NULL),(667,334,'Tarut','ar',NULL,NULL,NULL),(668,334,'Tarut','en',NULL,NULL,NULL),(669,335,'الثقبة','ar',NULL,NULL,NULL),(670,335,'Thuqbah','en',NULL,NULL,NULL),(671,336,'العضيلية','ar',NULL,NULL,NULL),(672,336,'Udhailiyah','en',NULL,NULL,NULL),(673,337,'العيون','ar',NULL,NULL,NULL),(674,337,'Uyun','en',NULL,NULL,NULL),(675,338,'الأحساء','ar',NULL,NULL,NULL),(676,338,'Al Ahsa','en',NULL,NULL,NULL),(677,339,'الدمام','ar',NULL,NULL,NULL),(678,339,'Dammam','en',NULL,NULL,NULL),(679,340,'حفر الباطن','ar',NULL,NULL,NULL),(680,340,'Hafar Al Batin','en',NULL,NULL,NULL),(681,341,'الخفجي','ar',NULL,NULL,NULL),(682,341,'Khafji','en',NULL,NULL,NULL),(683,342,'الخبر','ar',NULL,NULL,NULL),(684,342,'Khobar','en',NULL,NULL,NULL),(685,343,'النعيرية','ar',NULL,NULL,NULL),(686,343,'Nariyah','en',NULL,NULL,NULL),(687,344,'قرية العيا','ar',NULL,NULL,NULL),(688,344,'Qaryat Al Ulya','en',NULL,NULL,NULL),(689,345,'القطيف','ar',NULL,NULL,NULL),(690,345,'Qatif','en',NULL,NULL,NULL),(691,346,'راس تنورة','ar',NULL,NULL,NULL),(692,346,'Ras Tanura','en',NULL,NULL,NULL),(693,347,'السليمى','ar',NULL,NULL,NULL),(694,347,'Al Sulaimi','en',NULL,NULL,NULL),(695,348,'الشملي','ar',NULL,NULL,NULL),(696,348,'Ash Shamli','en',NULL,NULL,NULL),(697,349,'الشنان','ar',NULL,NULL,NULL),(698,349,'Ash Shinan','en',NULL,NULL,NULL),(699,350,'بقعاء','ar',NULL,NULL,NULL),(700,350,'Baqaa','en',NULL,NULL,NULL),(701,351,'موقق','ar',NULL,NULL,NULL),(702,351,'Mawqaq','en',NULL,NULL,NULL),(703,352,'سومريه','ar',NULL,NULL,NULL),(704,352,'Sumairaa','en',NULL,NULL,NULL),(705,353,'المنهل','ar',NULL,NULL,NULL),(706,353,'Abha Manhal','en',NULL,NULL,NULL),(707,354,'ابو عريش','ar',NULL,NULL,NULL),(708,354,'Abu Areish','en',NULL,NULL,NULL),(709,355,'الدائر','ar',NULL,NULL,NULL),(710,355,'Addayer','en',NULL,NULL,NULL),(711,356,'أضم','ar',NULL,NULL,NULL),(712,356,'Adham','en',NULL,NULL,NULL),(713,357,'أحد المسارحة','ar',NULL,NULL,NULL),(714,357,'Ahad Masarha','en',NULL,NULL,NULL),(715,358,'العيص','ar',NULL,NULL,NULL),(716,358,'Al Ais','en',NULL,NULL,NULL),(717,359,'البدع','ar',NULL,NULL,NULL),(718,359,'Al Bada','en',NULL,NULL,NULL),(719,360,'البشائر','ar',NULL,NULL,NULL),(720,360,'Al Bashayer','en',NULL,NULL,NULL),(721,361,'العيدابي','ar',NULL,NULL,NULL),(722,361,'Al Edabi','en',NULL,NULL,NULL),(723,362,'المدى','ar',NULL,NULL,NULL),(724,362,'Al Mada','en',NULL,NULL,NULL),(725,363,'المويه','ar',NULL,NULL,NULL),(726,363,'Al Moya','en',NULL,NULL,NULL),(727,364,'الهدا','ar',NULL,NULL,NULL),(728,364,'Al Hada','en',NULL,NULL,NULL),(729,365,'عمق','ar',NULL,NULL,NULL),(730,365,'Amaq','en',NULL,NULL,NULL),(731,366,'العقيق','ar',NULL,NULL,NULL),(732,366,'Aqiq','en',NULL,NULL,NULL),(733,367,'العرضة','ar',NULL,NULL,NULL),(734,367,'Ardah','en',NULL,NULL,NULL),(735,368,'عسفان','ar',NULL,NULL,NULL),(736,368,'Asfan','en',NULL,NULL,NULL),(737,369,'الشقيق','ar',NULL,NULL,NULL),(738,369,'Ash Shuqaiq','en',NULL,NULL,NULL),(739,370,'بدر','ar',NULL,NULL,NULL),(740,370,'Bader','en',NULL,NULL,NULL),(741,371,'بدرالجنوب','ar',NULL,NULL,NULL),(742,371,'Badr Al Janoub','en',NULL,NULL,NULL),(743,372,'الباحه','ar',NULL,NULL,NULL),(744,372,'Baha','en',NULL,NULL,NULL),(745,373,'بحره','ar',NULL,NULL,NULL),(746,373,'Bahara','en',NULL,NULL,NULL),(747,374,'Bahrat Al Moujoud','ar',NULL,NULL,NULL),(748,374,'Bahrat Al Moujoud','en',NULL,NULL,NULL),(749,375,'بلحمر','ar',NULL,NULL,NULL),(750,375,'Balahmar','en',NULL,NULL,NULL),(751,376,'بللسمر','ar',NULL,NULL,NULL),(752,376,'Balasmar','en',NULL,NULL,NULL),(753,377,'بلقرن','ar',NULL,NULL,NULL),(754,377,'Balqarn','en',NULL,NULL,NULL),(755,378,'بارق','ar',NULL,NULL,NULL),(756,378,'Bareq','en',NULL,NULL,NULL),(757,379,'بلجرشي','ar',NULL,NULL,NULL),(758,379,'Biljurashi','en',NULL,NULL,NULL),(759,380,'البرك','ar',NULL,NULL,NULL),(760,380,'Birk','en',NULL,NULL,NULL),(761,381,'بيش','ar',NULL,NULL,NULL),(762,381,'Bish','en',NULL,NULL,NULL),(763,382,'ضمد','ar',NULL,NULL,NULL),(764,382,'Damad','en',NULL,NULL,NULL),(765,383,'الدرب','ar',NULL,NULL,NULL),(766,383,'Darb','en',NULL,NULL,NULL),(767,384,'ذهبان','ar',NULL,NULL,NULL),(768,384,'Dhahban','en',NULL,NULL,NULL),(769,385,'ظهران الجنوب','ar',NULL,NULL,NULL),(770,385,'Dhahran Al Janoob','en',NULL,NULL,NULL),(771,386,'ضباء','ar',NULL,NULL,NULL),(772,386,'Duba','en',NULL,NULL,NULL),(773,387,'فرسان','ar',NULL,NULL,NULL),(774,387,'Farasan','en',NULL,NULL,NULL),(775,388,'Gilwa','ar',NULL,NULL,NULL),(776,388,'Gilwa','en',NULL,NULL,NULL),(777,389,'جازان','ar',NULL,NULL,NULL),(778,389,'Gizan','en',NULL,NULL,NULL),(779,390,'الحجرة','ar',NULL,NULL,NULL),(780,390,'Hajrah','en',NULL,NULL,NULL),(781,391,'حالة عمار','ar',NULL,NULL,NULL),(782,391,'Halat Ammar','en',NULL,NULL,NULL),(783,392,'حلي','ar',NULL,NULL,NULL),(784,392,'Hali','en',NULL,NULL,NULL),(785,393,'حائل','ar',NULL,NULL,NULL),(786,393,'Haqil','en',NULL,NULL,NULL),(787,394,'حرجة','ar',NULL,NULL,NULL),(788,394,'Harajah','en',NULL,NULL,NULL),(789,395,'Hawaya / Taif','ar',NULL,NULL,NULL),(790,395,'Hawea / Taif','en',NULL,NULL,NULL),(791,396,'الحناكية','ar',NULL,NULL,NULL),(792,396,'Al Hinakiyah','en',NULL,NULL,NULL),(793,397,'حبونا','ar',NULL,NULL,NULL),(794,397,'Hubuna','en',NULL,NULL,NULL),(795,398,'Ja Araneh','ar',NULL,NULL,NULL),(796,398,'Ja Araneh','en',NULL,NULL,NULL),(797,399,'جدة','ar',NULL,NULL,NULL),(798,399,'Jeddah','en',NULL,NULL,NULL),(799,400,'الجموم','ar',NULL,NULL,NULL),(800,400,'Jumum','en',NULL,NULL,NULL),(801,401,'كرز','ar',NULL,NULL,NULL),(802,401,'Karaa','en',NULL,NULL,NULL),(803,402,'الكربوس','ar',NULL,NULL,NULL),(804,402,'Karboos','en',NULL,NULL,NULL),(805,403,'خيبر','ar',NULL,NULL,NULL),(806,403,'Khaibar','en',NULL,NULL,NULL),(807,404,'خميس مشيط','ar',NULL,NULL,NULL),(808,404,'Khamis Mushait','en',NULL,NULL,NULL),(809,405,'الخرمة','ar',NULL,NULL,NULL),(810,405,'Khurma','en',NULL,NULL,NULL),(811,406,'ليث','ar',NULL,NULL,NULL),(812,406,'Laith','en',NULL,NULL,NULL),(813,407,'مهد الذهب','ar',NULL,NULL,NULL),(814,407,'Mahd Al Dahab','en',NULL,NULL,NULL),(815,408,'المهد','ar',NULL,NULL,NULL),(816,408,'Mahd','en',NULL,NULL,NULL),(817,409,'مكة','ar',NULL,NULL,NULL),(818,409,'Makkah','en',NULL,NULL,NULL),(819,410,'المندق','ar',NULL,NULL,NULL),(820,410,'Mandak','en',NULL,NULL,NULL),(821,411,'مستورة','ar',NULL,NULL,NULL),(822,411,'Masturah','en',NULL,NULL,NULL),(823,412,'المخواة','ar',NULL,NULL,NULL),(824,412,'Al Mikhwah','en',NULL,NULL,NULL),(825,413,'محايل عسير','ar',NULL,NULL,NULL),(826,413,'Muhayil, Aseer','en',NULL,NULL,NULL),(827,414,'Muthaleif','ar',NULL,NULL,NULL),(828,414,'Muthaleif','en',NULL,NULL,NULL),(829,415,'نجران','ar',NULL,NULL,NULL),(830,415,'Najran','en',NULL,NULL,NULL),(831,416,'النماص','ar',NULL,NULL,NULL),(832,416,'Namas','en',NULL,NULL,NULL),(833,417,'نيمره','ar',NULL,NULL,NULL),(834,417,'Nimra','en',NULL,NULL,NULL),(835,418,'Nwariah','ar',NULL,NULL,NULL),(836,418,'Nwariah','en',NULL,NULL,NULL),(837,419,'العلا','ar',NULL,NULL,NULL),(838,419,'Oula','en',NULL,NULL,NULL),(839,420,'القحمة','ar',NULL,NULL,NULL),(840,420,'Qahmah','en',NULL,NULL,NULL),(841,421,'القوز','ar',NULL,NULL,NULL),(842,421,'Qouz','en',NULL,NULL,NULL),(843,422,'القنفذة','ar',NULL,NULL,NULL),(844,422,'Qunfudah','en',NULL,NULL,NULL),(845,423,'رابغ','ar',NULL,NULL,NULL),(846,423,'Rabigh','en',NULL,NULL,NULL),(847,424,'رنية','ar',NULL,NULL,NULL),(848,424,'Rania','en',NULL,NULL,NULL),(849,425,'Ras Baridi','ar',NULL,NULL,NULL),(850,425,'Ras Baridi','en',NULL,NULL,NULL),(851,426,'رجال ألمع','ar',NULL,NULL,NULL),(852,426,'Rijal Almaa','en',NULL,NULL,NULL),(853,427,'سبت العلاية','ar',NULL,NULL,NULL),(854,427,'Sabt Al Alaya','en',NULL,NULL,NULL),(855,428,'صبياء','ar',NULL,NULL,NULL),(856,428,'Sabya','en',NULL,NULL,NULL),(857,429,'Sadal Malik','ar',NULL,NULL,NULL),(858,429,'Sadal Malik','en',NULL,NULL,NULL),(859,430,'صمخ','ar',NULL,NULL,NULL),(860,430,'Samakh','en',NULL,NULL,NULL),(861,431,'صامطه','ar',NULL,NULL,NULL),(862,431,'Samtah','en',NULL,NULL,NULL),(863,432,'سراة عبيدة','ar',NULL,NULL,NULL),(864,432,'Sarat Obeida','en',NULL,NULL,NULL),(865,433,'شرورة','ar',NULL,NULL,NULL),(866,433,'Sharurah','en',NULL,NULL,NULL),(867,434,'الشعيبة','ar',NULL,NULL,NULL),(868,434,'Shoaiba','en',NULL,NULL,NULL),(869,435,'Shraie\'e','ar',NULL,NULL,NULL),(870,435,'Shraie\'e','en',NULL,NULL,NULL),(871,436,'الشميسي','ar',NULL,NULL,NULL),(872,436,'Shumaisi','en',NULL,NULL,NULL),(873,437,'Subheka','ar',NULL,NULL,NULL),(874,437,'Subheka','en',NULL,NULL,NULL),(875,438,'Tablah','ar',NULL,NULL,NULL),(876,438,'Tablah','en',NULL,NULL,NULL),(877,439,'تبوك','ar',NULL,NULL,NULL),(878,439,'Tabuk','en',NULL,NULL,NULL),(879,440,'طيبة','ar',NULL,NULL,NULL),(880,440,'Taiba','en',NULL,NULL,NULL),(881,441,'الطائف','ar',NULL,NULL,NULL),(882,441,'Taif','en',NULL,NULL,NULL),(883,442,'Taif','ar',NULL,NULL,NULL),(884,442,'Taif','en',NULL,NULL,NULL),(885,443,'تنده','ar',NULL,NULL,NULL),(886,443,'Tanda','en',NULL,NULL,NULL),(887,444,'التنومه','ar',NULL,NULL,NULL),(888,444,'Tanuma','en',NULL,NULL,NULL),(889,445,'Tatleeth','ar',NULL,NULL,NULL),(890,445,'Tatleeth','en',NULL,NULL,NULL),(891,446,'تيماء','ar',NULL,NULL,NULL),(892,446,'Tayma','en',NULL,NULL,NULL),(893,447,'Thabya','ar',NULL,NULL,NULL),(894,447,'Thabya','en',NULL,NULL,NULL),(895,448,'ثول','ar',NULL,NULL,NULL),(896,448,'Thuwal','en',NULL,NULL,NULL),(897,449,'Turaif','ar',NULL,NULL,NULL),(898,449,'Turaib','en',NULL,NULL,NULL),(899,450,'تربة','ar',NULL,NULL,NULL),(900,450,'Turba','en',NULL,NULL,NULL),(901,451,'Umluj','ar',NULL,NULL,NULL),(902,451,'Umluj','en',NULL,NULL,NULL),(903,452,'Wadeien','ar',NULL,NULL,NULL),(904,452,'Wadeien','en',NULL,NULL,NULL),(905,453,'الغزالة','ar',NULL,NULL,NULL),(906,453,'Ghazalah','en',NULL,NULL,NULL),(907,454,'موقق','ar',NULL,NULL,NULL),(908,454,'Mawqaq','en',NULL,NULL,NULL),(909,455,'حائل','ar',NULL,NULL,NULL),(910,455,'Hail','en',NULL,NULL,NULL),(911,456,'وادي ابن هشبل','ar',NULL,NULL,NULL),(912,456,'Wadi Bin Hasbal','en',NULL,NULL,NULL),(913,457,'وادي الفراعة','ar',NULL,NULL,NULL),(914,457,'Wadi Al Farah','en',NULL,NULL,NULL),(915,458,'وادي فاطمة','ar',NULL,NULL,NULL),(916,458,'Wadi Fatimah','en',NULL,NULL,NULL),(917,459,'الوجه','ar',NULL,NULL,NULL),(918,459,'Wajeh','en',NULL,NULL,NULL),(919,460,'ينبع','ar',NULL,NULL,NULL),(920,460,'Yanbu','en',NULL,NULL,NULL),(921,461,'ينبع البحر','ar',NULL,NULL,NULL),(922,461,'Yanbu Al Baher','en',NULL,NULL,NULL),(923,462,'النخيل','ar',NULL,NULL,NULL),(924,462,'Yanbu Nakheel','en',NULL,NULL,NULL),(925,463,'Yuthma','ar',NULL,NULL,NULL),(926,463,'Yuthma','en',NULL,NULL,NULL),(927,464,'khasawyah','ar',NULL,NULL,NULL),(928,464,'khasawyah','en',NULL,NULL,NULL),(929,465,'خليص','ar',NULL,NULL,NULL),(930,465,'khulais','en',NULL,NULL,NULL),(931,466,'احد رفيده','ar',NULL,NULL,NULL),(932,466,'Ahad Rufaidah','en',NULL,NULL,NULL),(933,467,'ابو عريش','ar',NULL,NULL,NULL),(934,467,'Abu Arish','en',NULL,NULL,NULL),(935,468,'احد المسارحه','ar',NULL,NULL,NULL),(936,468,'Ahad Al Masarihah','en',NULL,NULL,NULL),(937,469,'العارضه','ar',NULL,NULL,NULL),(938,469,'Al\'Aridah','en',NULL,NULL,NULL),(939,470,'العيدابي','ar',NULL,NULL,NULL),(940,470,'Al Edabi','en',NULL,NULL,NULL),(941,471,'الداير','ar',NULL,NULL,NULL),(942,471,'Al Dair','en',NULL,NULL,NULL),(943,472,'الحرث','ar',NULL,NULL,NULL),(944,472,'Al Harth','en',NULL,NULL,NULL),(945,473,'الريث','ar',NULL,NULL,NULL),(946,473,'Al Raith','en',NULL,NULL,NULL),(947,474,'بيش','ar',NULL,NULL,NULL),(948,474,'Baish','en',NULL,NULL,NULL),(949,475,'جازان','ar',NULL,NULL,NULL),(950,475,'Jizan','en',NULL,NULL,NULL),(951,476,'الكامل','ar',NULL,NULL,NULL),(952,476,'Al Kamil','en',NULL,NULL,NULL),(953,477,'الليث','ar',NULL,NULL,NULL),(954,477,'Al Lith','en',NULL,NULL,NULL),(955,478,'القنفذة','ar',NULL,NULL,NULL),(956,478,'Al Qunfudhah','en',NULL,NULL,NULL),(957,479,'خليص','ar',NULL,NULL,NULL),(958,479,'Khulays','en',NULL,NULL,NULL),(959,480,'مكة المكرمة','ar',NULL,NULL,NULL),(960,480,'Mecca','en',NULL,NULL,NULL),(961,481,'رنية','ar',NULL,NULL,NULL),(962,481,'Ranyah','en',NULL,NULL,NULL),(963,482,'الطائف','ar',NULL,NULL,NULL),(964,482,'Taif','en',NULL,NULL,NULL),(965,483,'تربة','ar',NULL,NULL,NULL),(966,483,'Turubah','en',NULL,NULL,NULL),(967,484,'الخرخير','ar',NULL,NULL,NULL),(968,484,'Al Khirkhir','en',NULL,NULL,NULL),(969,485,'بدر الجنوب','ar',NULL,NULL,NULL),(970,485,'Badr Al Janub','en',NULL,NULL,NULL),(971,486,'شرورة','ar',NULL,NULL,NULL),(972,486,'Sharurah','en',NULL,NULL,NULL),(973,487,'ثار','ar',NULL,NULL,NULL),(974,487,'Thar','en',NULL,NULL,NULL),(975,488,'يدمه','ar',NULL,NULL,NULL),(976,488,'Yadamah','en',NULL,NULL,NULL),(977,489,'عرعر','ar',NULL,NULL,NULL),(978,489,'Arar','en',NULL,NULL,NULL),(979,490,'رفحاء','ar',NULL,NULL,NULL),(980,490,'Rafha','en',NULL,NULL,NULL),(981,491,'طريف','ar',NULL,NULL,NULL),(982,491,'Turayf','en',NULL,NULL,NULL),(983,492,'البكيرية','ar',NULL,NULL,NULL),(984,492,'Al Bukayriyah','en',NULL,NULL,NULL),(985,493,'المذنب','ar',NULL,NULL,NULL),(986,493,'Al Mithnab','en',NULL,NULL,NULL),(987,494,'الأسياح','ar',NULL,NULL,NULL),(988,494,'Al Asyah','en',NULL,NULL,NULL),(989,495,'النبهانية','ar',NULL,NULL,NULL),(990,495,'An Nabhaniyah','en',NULL,NULL,NULL),(991,496,'الشماسية','ar',NULL,NULL,NULL),(992,496,'Al Shmasia','en',NULL,NULL,NULL),(993,497,'الرس','ar',NULL,NULL,NULL),(994,497,'Ar Rass','en',NULL,NULL,NULL),(995,498,'البدائع','ar',NULL,NULL,NULL),(996,498,'Badaya','en',NULL,NULL,NULL),(997,499,'بريدة','ar',NULL,NULL,NULL),(998,499,'Buraydah','en',NULL,NULL,NULL),(999,500,'رياض الخبراء','ar',NULL,NULL,NULL),(1000,500,'Riyadh Al Khabra','en',NULL,NULL,NULL),(1001,501,'عنيزة','ar',NULL,NULL,NULL),(1002,501,'Unaizah','en',NULL,NULL,NULL),(1003,502,'عين الجواء','ar',NULL,NULL,NULL),(1004,502,'Uyun Al Jawa','en',NULL,NULL,NULL),(1005,503,'ابا الورود','ar',NULL,NULL,NULL),(1006,503,'Aba Al Worood','en',NULL,NULL,NULL),(1007,504,'ابو عجرم','ar',NULL,NULL,NULL),(1008,504,'Abu Ajram','en',NULL,NULL,NULL),(1009,505,'الداهنة','ar',NULL,NULL,NULL),(1010,505,'Ad Dahinah','en',NULL,NULL,NULL),(1011,506,'الضبيعة','ar',NULL,NULL,NULL),(1012,506,'Ad Dubaiyah','en',NULL,NULL,NULL),(1013,507,'عفيف','ar',NULL,NULL,NULL),(1014,507,'Afif','en',NULL,NULL,NULL),(1015,508,'الأجفر','ar',NULL,NULL,NULL),(1016,508,'Al Ajfar','en',NULL,NULL,NULL),(1017,509,'العمارة','ar',NULL,NULL,NULL),(1018,509,'Al Ammarah','en',NULL,NULL,NULL),(1019,510,'الأسياح','ar',NULL,NULL,NULL),(1020,510,'Al Asyah','en',NULL,NULL,NULL),(1021,511,'البتراء','ar',NULL,NULL,NULL),(1022,511,'Al Batra','en',NULL,NULL,NULL),(1023,512,'البجادية','ar',NULL,NULL,NULL),(1024,512,'Al Bijadyah','en',NULL,NULL,NULL),(1025,513,'Al Dalemya','ar',NULL,NULL,NULL),(1026,513,'Al Dalemya','en',NULL,NULL,NULL),(1027,514,'الحائط','ar',NULL,NULL,NULL),(1028,514,'Al Hait','en',NULL,NULL,NULL),(1029,515,'الهياثم','ar',NULL,NULL,NULL),(1030,515,'Al Hayathem','en',NULL,NULL,NULL),(1031,516,'الحفيرة','ar',NULL,NULL,NULL),(1032,516,'Al Hufayyirah','en',NULL,NULL,NULL),(1033,517,'الحليفة السفلى','ar',NULL,NULL,NULL),(1034,517,'Al Hulayfah As Sufla','en',NULL,NULL,NULL),(1035,518,'الخشيبي','ar',NULL,NULL,NULL),(1036,518,'Al Khushaybi','en',NULL,NULL,NULL),(1037,519,'الخطة','ar',NULL,NULL,NULL),(1038,519,'Al Khitah','en',NULL,NULL,NULL),(1039,520,'Al Laqayit','ar',NULL,NULL,NULL),(1040,520,'Al Laqayit','en',NULL,NULL,NULL),(1041,521,'القرين','ar',NULL,NULL,NULL),(1042,521,'Al Qarin','en',NULL,NULL,NULL),(1043,522,'العويقيلة','ar',NULL,NULL,NULL),(1044,522,'Al Uwayqilah','en',NULL,NULL,NULL),(1045,523,'الوسيطاء','ar',NULL,NULL,NULL),(1046,523,'Al Wasayta','en',NULL,NULL,NULL),(1047,524,'الغاط','ar',NULL,NULL,NULL),(1048,524,'Al Ghat','en',NULL,NULL,NULL),(1049,525,'النبهانية','ar',NULL,NULL,NULL),(1050,525,'Al Nabhaniyah','en',NULL,NULL,NULL),(1051,526,'الرس','ar',NULL,NULL,NULL),(1052,526,'Al Rass','en',NULL,NULL,NULL),(1053,527,'النبك أبو قصر','ar',NULL,NULL,NULL),(1054,527,'An Nabk Abu Qasr','en',NULL,NULL,NULL),(1055,528,'النقرة','ar',NULL,NULL,NULL),(1056,528,'An Nuqrah','en',NULL,NULL,NULL),(1057,529,'الرديفة','ar',NULL,NULL,NULL),(1058,529,'Ar Radifah','en',NULL,NULL,NULL),(1059,530,'الرفيعة','ar',NULL,NULL,NULL),(1060,530,'Ar Rafia','en',NULL,NULL,NULL),(1061,531,'الرشاوية','ar',NULL,NULL,NULL),(1062,531,'Ar Rishawiyah','en',NULL,NULL,NULL),(1063,532,'عرعر','ar',NULL,NULL,NULL),(1064,532,'Arar','en',NULL,NULL,NULL),(1065,533,'عرجاء','ar',NULL,NULL,NULL),(1066,533,'Arja','en',NULL,NULL,NULL),(1067,534,'الأرطاوية','ar',NULL,NULL,NULL),(1068,534,'Al Artawiyah','en',NULL,NULL,NULL),(1069,535,'السلمانية','ar',NULL,NULL,NULL),(1070,535,'As Sulaimaniyah','en',NULL,NULL,NULL),(1071,536,'الصلبية','ar',NULL,NULL,NULL),(1072,536,'As Sulubiayh','en',NULL,NULL,NULL),(1073,537,'الشرائع','ar',NULL,NULL,NULL),(1074,537,'Ash Sheraa','en',NULL,NULL,NULL),(1075,538,'الشملي','ar',NULL,NULL,NULL),(1076,538,'Ash Shamli','en',NULL,NULL,NULL),(1077,539,'الشماسية','ar',NULL,NULL,NULL),(1078,539,'Ash Shimasiyah','en',NULL,NULL,NULL),(1079,540,'الطوير','ar',NULL,NULL,NULL),(1080,540,'At Tuwayr','en',NULL,NULL,NULL),(1081,541,'الذيبية','ar',NULL,NULL,NULL),(1082,541,'At Thybiyah','en',NULL,NULL,NULL),(1083,542,'عين ابن فهيد','ar',NULL,NULL,NULL),(1084,542,'Ayn Fuhayd','en',NULL,NULL,NULL),(1085,543,'بقعاء الشرقية','ar',NULL,NULL,NULL),(1086,543,'Baqa Ash Sharqiyah','en',NULL,NULL,NULL),(1087,544,'بقعاء','ar',NULL,NULL,NULL),(1088,544,'Baqa','en',NULL,NULL,NULL),(1089,545,'البكيرية','ar',NULL,NULL,NULL),(1090,545,'Bukeiriah','en',NULL,NULL,NULL),(1091,546,'بريده','ar',NULL,NULL,NULL),(1092,546,'Buraidah','en',NULL,NULL,NULL),(1093,547,'Diriyah','ar',NULL,NULL,NULL),(1094,547,'Dariyah','en',NULL,NULL,NULL),(1095,548,'الدوادمي','ar',NULL,NULL,NULL),(1096,548,'Dawadmi','en',NULL,NULL,NULL),(1097,549,'ديراب','ar',NULL,NULL,NULL),(1098,549,'Deraab','en',NULL,NULL,NULL),(1099,550,'الدرعية','ar',NULL,NULL,NULL),(1100,550,'Derelyeh','en',NULL,NULL,NULL),(1101,551,'ضرماء','ar',NULL,NULL,NULL),(1102,551,'Dhruma','en',NULL,NULL,NULL),(1103,552,'دومة الجندل','ar',NULL,NULL,NULL),(1104,552,'Dumat Al Jandal','en',NULL,NULL,NULL),(1105,553,'دخنة','ar',NULL,NULL,NULL),(1106,553,'Duhknah','en',NULL,NULL,NULL),(1107,554,'ضليع رشيد','ar',NULL,NULL,NULL),(1108,554,'Dulay Rashid','en',NULL,NULL,NULL),(1109,555,'الغزالة','ar',NULL,NULL,NULL),(1110,555,'Ghazalah','en',NULL,NULL,NULL),(1111,556,'غطي','ar',NULL,NULL,NULL),(1112,556,'Ghtai','en',NULL,NULL,NULL),(1113,557,'الحديثة','ar',NULL,NULL,NULL),(1114,557,'Hadeethah','en',NULL,NULL,NULL),(1115,558,'حفر الباطن','ar',NULL,NULL,NULL),(1116,558,'Hafer Al Batin','en',NULL,NULL,NULL),(1117,559,'حائل','ar',NULL,NULL,NULL),(1118,559,'Hail','en',NULL,NULL,NULL),(1119,560,'الحريق','ar',NULL,NULL,NULL),(1120,560,'Hareeq','en',NULL,NULL,NULL),(1121,561,'حوطة بني تميم','ar',NULL,NULL,NULL),(1122,561,'Hawtat Bani Tamim','en',NULL,NULL,NULL),(1123,562,'حزم الجلاميد','ar',NULL,NULL,NULL),(1124,562,'Hazem Aljalamid','en',NULL,NULL,NULL),(1125,563,'هديب','ar',NULL,NULL,NULL),(1126,563,'Hedeb','en',NULL,NULL,NULL),(1127,564,'حريملاء','ar',NULL,NULL,NULL),(1128,564,'Horaimal','en',NULL,NULL,NULL),(1129,565,'حوطة تميم','ar',NULL,NULL,NULL),(1130,565,'Hotat Bani Tamim','en',NULL,NULL,NULL),(1131,566,'حوطة سدير','ar',NULL,NULL,NULL),(1132,566,'Hotat Sudair','en',NULL,NULL,NULL),(1133,567,'Huraymila','ar',NULL,NULL,NULL),(1134,567,'Huraymala','en',NULL,NULL,NULL),(1135,568,'جلاجل','ar',NULL,NULL,NULL),(1136,568,'Jalajel','en',NULL,NULL,NULL),(1137,569,'الجوف','ar',NULL,NULL,NULL),(1138,569,'Jouf','en',NULL,NULL,NULL),(1139,570,'كحلة','ar',NULL,NULL,NULL),(1140,570,'Kahla','en',NULL,NULL,NULL),(1141,571,'Kara','ar',NULL,NULL,NULL),(1142,571,'Kara','en',NULL,NULL,NULL),(1143,572,'الخماسين','ar',NULL,NULL,NULL),(1144,572,'Khamaseen','en',NULL,NULL,NULL),(1145,573,'الخرج','ar',NULL,NULL,NULL),(1146,573,'Kharj','en',NULL,NULL,NULL),(1147,574,'مدينة الملك خالد العسكرية','ar',NULL,NULL,NULL),(1148,574,'King Khalid Military City','en',NULL,NULL,NULL),(1149,575,'ليلى','ar',NULL,NULL,NULL),(1150,575,'Layla','en',NULL,NULL,NULL),(1151,576,'المجمعة','ar',NULL,NULL,NULL),(1152,576,'Majma','en',NULL,NULL,NULL),(1153,577,'موقق','ar',NULL,NULL,NULL),(1154,577,'Mawqaq','en',NULL,NULL,NULL),(1155,578,'Midinhab','ar',NULL,NULL,NULL),(1156,578,'Midinhab','en',NULL,NULL,NULL),(1157,579,'موقق','ar',NULL,NULL,NULL),(1158,579,'Moqaq','en',NULL,NULL,NULL),(1159,580,'مرات','ar',NULL,NULL,NULL),(1160,580,'Mrat','en',NULL,NULL,NULL),(1161,581,'مبايض','ar',NULL,NULL,NULL),(1162,581,'Mubayid','en',NULL,NULL,NULL),(1163,582,'مليح','ar',NULL,NULL,NULL),(1164,582,'Mulayh','en',NULL,NULL,NULL),(1165,583,'منيفة القاعد','ar',NULL,NULL,NULL),(1166,583,'Munifat al Qa\'id','en',NULL,NULL,NULL),(1167,584,'المزاحمية','ar',NULL,NULL,NULL),(1168,584,'Al-Muzahmiya','en',NULL,NULL,NULL),(1169,585,'Muzneb','ar',NULL,NULL,NULL),(1170,585,'Muzneb','en',NULL,NULL,NULL),(1171,586,'نيساب','ar',NULL,NULL,NULL),(1172,586,'Nisab','en',NULL,NULL,NULL),(1173,587,'عنيزة','ar',NULL,NULL,NULL),(1174,587,'Onaiza','en',NULL,NULL,NULL),(1175,588,'العيينة','ar',NULL,NULL,NULL),(1176,588,'Al Uyaynah','en',NULL,NULL,NULL),(1177,589,'عيون الجوا','ar',NULL,NULL,NULL),(1178,589,'Uyun Al Jawa','en',NULL,NULL,NULL),(1179,590,'القصب','ar',NULL,NULL,NULL),(1180,590,'Qasab','en',NULL,NULL,NULL),(1181,591,'القصيم','ar',NULL,NULL,NULL),(1182,591,'Qassim','en',NULL,NULL,NULL),(1183,592,'القيصومة','ar',NULL,NULL,NULL),(1184,592,'Qaisumah','en',NULL,NULL,NULL),(1185,593,'قبه','ar',NULL,NULL,NULL),(1186,593,'Qbah','en',NULL,NULL,NULL),(1187,594,'قفار','ar',NULL,NULL,NULL),(1188,594,'Qufar','en',NULL,NULL,NULL),(1189,595,'القريات','ar',NULL,NULL,NULL),(1190,595,'Qurayyat','en',NULL,NULL,NULL),(1191,596,'قصيباء','ar',NULL,NULL,NULL),(1192,596,'Qusaiba','en',NULL,NULL,NULL),(1193,597,'القويعية','ar',NULL,NULL,NULL),(1194,597,'Quwei\'leh','en',NULL,NULL,NULL),(1195,598,'روضة هباس','ar',NULL,NULL,NULL),(1196,598,'Rawdat Habbas','en',NULL,NULL,NULL),(1197,599,'رماح','ar',NULL,NULL,NULL),(1198,599,'Remah','en',NULL,NULL,NULL),(1199,600,'رماح','ar',NULL,NULL,NULL),(1200,600,'Rimah','en',NULL,NULL,NULL),(1201,601,'الرياض','ar',NULL,NULL,NULL),(1202,601,'Riyadh','en',NULL,NULL,NULL),(1203,602,'رياض الخبراء','ar',NULL,NULL,NULL),(1204,602,'Riyadh Al Khabra','en',NULL,NULL,NULL),(1205,603,'روضة سدير','ar',NULL,NULL,NULL),(1206,603,'Raudat Sudair','en',NULL,NULL,NULL),(1207,604,'رفايع الجمش','ar',NULL,NULL,NULL),(1208,604,'Rvaya Aljamsh','en',NULL,NULL,NULL),(1209,605,'Ar Ruwaydah','ar',NULL,NULL,NULL),(1210,605,'Ar Ruwaydah','en',NULL,NULL,NULL),(1211,606,'سدير','ar',NULL,NULL,NULL),(1212,606,'Sadeer','en',NULL,NULL,NULL),(1213,607,'الصحنة','ar',NULL,NULL,NULL),(1214,607,'Sahna','en',NULL,NULL,NULL),(1215,608,'ساجر','ar',NULL,NULL,NULL),(1216,608,'Sajir','en',NULL,NULL,NULL),(1217,609,'صلبوخ','ar',NULL,NULL,NULL),(1218,609,'Salbukh','en',NULL,NULL,NULL),(1219,610,'شقراء','ar',NULL,NULL,NULL),(1220,610,'Shagra','en',NULL,NULL,NULL),(1221,611,'شقراء','ar',NULL,NULL,NULL),(1222,611,'Shaqra','en',NULL,NULL,NULL),(1223,612,'شقراء','ar',NULL,NULL,NULL),(1224,612,'Shaqra\'a','en',NULL,NULL,NULL),(1225,613,'شري','ar',NULL,NULL,NULL),(1226,613,'Shari','en',NULL,NULL,NULL),(1227,614,'الشفا','ar',NULL,NULL,NULL),(1228,614,'Shefa\'a','en',NULL,NULL,NULL),(1229,615,'الشنانة','ar',NULL,NULL,NULL),(1230,615,'Shinanh','en',NULL,NULL,NULL),(1231,616,'سميراء','ar',NULL,NULL,NULL),(1232,616,'Simira','en',NULL,NULL,NULL),(1233,617,'السليل','ar',NULL,NULL,NULL),(1234,617,'As Sulayyil','en',NULL,NULL,NULL),(1235,618,'صوير','ar',NULL,NULL,NULL),(1236,618,'Suwayr','en',NULL,NULL,NULL),(1237,619,'طبرجل','ar',NULL,NULL,NULL),(1238,619,'Tabarjal','en',NULL,NULL,NULL),(1239,620,'التنومه','ar',NULL,NULL,NULL),(1240,620,'Tanumah','en',NULL,NULL,NULL),(1241,621,'ثادق','ar',NULL,NULL,NULL),(1242,621,'Thadek','en',NULL,NULL,NULL),(1243,622,'ثادق','ar',NULL,NULL,NULL),(1244,622,'Thadig','en',NULL,NULL,NULL),(1245,623,'ثرمداء','ar',NULL,NULL,NULL),(1246,623,'Tharmada\'a','en',NULL,NULL,NULL),(1247,624,'الذيبية','ar',NULL,NULL,NULL),(1248,624,'Thebea','en',NULL,NULL,NULL),(1249,625,'تمير','ar',NULL,NULL,NULL),(1250,625,'Thumair','en',NULL,NULL,NULL),(1251,626,'طريف','ar',NULL,NULL,NULL),(1252,626,'Turaif','en',NULL,NULL,NULL),(1253,627,'ام الجماجم','ar',NULL,NULL,NULL),(1254,627,'Umm Al Jamajim','en',NULL,NULL,NULL),(1255,628,'عقلة الصقور','ar',NULL,NULL,NULL),(1256,628,'Uqlat Al Suqur','en',NULL,NULL,NULL),(1257,629,'أشيقر','ar',NULL,NULL,NULL),(1258,629,'Ushaiqer','en',NULL,NULL,NULL),(1259,630,'وادي الدواسر','ar',NULL,NULL,NULL),(1260,630,'Wadi Al Dawasir','en',NULL,NULL,NULL),(1261,631,'الزلفي','ar',NULL,NULL,NULL),(1262,631,'Zulfi','en',NULL,NULL,NULL),(1263,632,'الزلفي','ar',NULL,NULL,NULL),(1264,632,'Zulf City','en',NULL,NULL,NULL),(1265,633,'الوجه','ar',NULL,NULL,NULL),(1266,633,'Al Wajh','en',NULL,NULL,NULL),(1267,634,'حقل','ar',NULL,NULL,NULL),(1268,634,'Haql','en',NULL,NULL,NULL),(1269,635,'أملج','ar',NULL,NULL,NULL),(1270,635,'Umm Lajj','en',NULL,NULL,NULL),(1271,636,'الحريق','ar',NULL,NULL,NULL),(1272,636,'Al hareeq','en',NULL,NULL,NULL),(1273,637,'المزاحمية','ar',NULL,NULL,NULL),(1274,637,'Al muzahmiyyah','en',NULL,NULL,NULL),(1275,638,'ضرما','ar',NULL,NULL,NULL),(1276,638,'Dhurma','en',NULL,NULL,NULL),(1277,639,'العدلية','ar',NULL,NULL,NULL),(1278,639,'Adliya','en',NULL,NULL,NULL),(1279,640,'الغريفة','ar',NULL,NULL,NULL),(1280,640,'Ghurafya','en',NULL,NULL,NULL),(1281,641,'جد حفص','ar',NULL,NULL,NULL),(1282,641,'Jidhafs','en',NULL,NULL,NULL),(1283,642,'الجفير','ar',NULL,NULL,NULL),(1284,642,'Juffair','en',NULL,NULL,NULL),(1285,643,'كرباباد','ar',NULL,NULL,NULL),(1286,643,'Karbabad','en',NULL,NULL,NULL),(1287,644,'المنامة','ar',NULL,NULL,NULL),(1288,644,'Manama','en',NULL,NULL,NULL),(1289,645,'ميناء سلمان','ar',NULL,NULL,NULL),(1290,645,'Mina Salman','en',NULL,NULL,NULL),(1291,646,'المصلى','ar',NULL,NULL,NULL),(1292,646,'Musalla','en',NULL,NULL,NULL),(1293,647,'كفول','ar',NULL,NULL,NULL),(1294,647,'Qofool','en',NULL,NULL,NULL),(1295,648,'القضيبية','ar',NULL,NULL,NULL),(1296,648,'Qudaibiya','en',NULL,NULL,NULL),(1297,649,'راس رمان','ar',NULL,NULL,NULL),(1298,649,'Ras Ruman','en',NULL,NULL,NULL),(1299,650,'السلمانية','ar',NULL,NULL,NULL),(1300,650,'Salmaniya','en',NULL,NULL,NULL),(1301,651,'السيف','ar',NULL,NULL,NULL),(1302,651,'Seef','en',NULL,NULL,NULL),(1303,652,'ام الحصم','ar',NULL,NULL,NULL),(1304,652,'Um Al Hassam','en',NULL,NULL,NULL),(1305,653,'امواج','ar',NULL,NULL,NULL),(1306,653,'Amwaj','en',NULL,NULL,NULL),(1307,654,'امواج','ar',NULL,NULL,NULL),(1308,654,'Amwaj','en',NULL,NULL,NULL),(1309,655,'عراد','ar',NULL,NULL,NULL),(1310,655,'Arad','en',NULL,NULL,NULL),(1311,656,'البسيتين','ar',NULL,NULL,NULL),(1312,656,'Busaiteen','en',NULL,NULL,NULL),(1313,657,'الدير','ar',NULL,NULL,NULL),(1314,657,'Dair','en',NULL,NULL,NULL),(1315,658,'الحد','ar',NULL,NULL,NULL),(1316,658,'Hidd','en',NULL,NULL,NULL),(1317,659,'المحرق','ar',NULL,NULL,NULL),(1318,659,'Muharraq','en',NULL,NULL,NULL),(1319,660,'قلالي','ar',NULL,NULL,NULL),(1320,660,'Qalali','en',NULL,NULL,NULL),(1321,661,'سماهيج','ar',NULL,NULL,NULL),(1322,661,'Samaheej','en',NULL,NULL,NULL),(1323,662,'جريرة تالا','ar',NULL,NULL,NULL),(1324,662,'Tala Island','en',NULL,NULL,NULL),(1325,663,'ابو بهام','ar',NULL,NULL,NULL),(1326,663,'Abu Baham','en',NULL,NULL,NULL),(1327,664,'ابو صيبع','ar',NULL,NULL,NULL),(1328,664,'Abu Saiba','en',NULL,NULL,NULL),(1329,665,'بني جمرة','ar',NULL,NULL,NULL),(1330,665,'Bani Jamra','en',NULL,NULL,NULL),(1331,666,'معبد باربار','ar',NULL,NULL,NULL),(1332,666,'Barbar','en',NULL,NULL,NULL),(1333,667,'بو قوة','ar',NULL,NULL,NULL),(1334,667,'Bu Quwah','en',NULL,NULL,NULL),(1335,668,'بوري','ar',NULL,NULL,NULL),(1336,668,'Buri','en',NULL,NULL,NULL),(1337,669,'دار كليب','ar',NULL,NULL,NULL),(1338,669,'Dar Kulaib','en',NULL,NULL,NULL),(1339,670,'معبد الدراز','ar',NULL,NULL,NULL),(1340,670,'Diraz','en',NULL,NULL,NULL),(1341,671,'دمستان','ar',NULL,NULL,NULL),(1342,671,'Damistan','en',NULL,NULL,NULL),(1343,672,'الحجر','ar',NULL,NULL,NULL),(1344,672,'Hajar','en',NULL,NULL,NULL),(1345,673,'مدينة حمد','ar',NULL,NULL,NULL),(1346,673,'Hamad Town','en',NULL,NULL,NULL),(1347,674,'الهملة','ar',NULL,NULL,NULL),(1348,674,'Hamala','en',NULL,NULL,NULL),(1349,675,'حلة عبد الصالح','ar',NULL,NULL,NULL),(1350,675,'Hillat Abdul Saleh','en',NULL,NULL,NULL),(1351,676,'جونسان','ar',NULL,NULL,NULL),(1352,676,'Jannusan','en',NULL,NULL,NULL),(1353,677,'بيت الجسرة','ar',NULL,NULL,NULL),(1354,677,'Jasra','en',NULL,NULL,NULL),(1355,678,'جبلة حبشي','ar',NULL,NULL,NULL),(1356,678,'Jablat Habshi','en',NULL,NULL,NULL),(1357,679,'جد الحاج','ar',NULL,NULL,NULL),(1358,679,'Jid Al Haj','en',NULL,NULL,NULL),(1359,680,'جد الحاج','ar',NULL,NULL,NULL),(1360,680,'Jid Al Haj','en',NULL,NULL,NULL),(1361,681,'كرانة','ar',NULL,NULL,NULL),(1362,681,'Karranah','en',NULL,NULL,NULL),(1363,682,'كرزكان','ar',NULL,NULL,NULL),(1364,682,'Karzakan','en',NULL,NULL,NULL),(1365,683,'مسجد الخميس','ar',NULL,NULL,NULL),(1366,683,'Khamis','en',NULL,NULL,NULL),(1367,684,'المالكية','ar',NULL,NULL,NULL),(1368,684,'Malikiya','en',NULL,NULL,NULL),(1369,685,'المرخ','ar',NULL,NULL,NULL),(1370,685,'Markh','en',NULL,NULL,NULL),(1371,686,'المقشع','ar',NULL,NULL,NULL),(1372,686,'Meqsha','en',NULL,NULL,NULL),(1373,687,'مقابة','ar',NULL,NULL,NULL),(1374,687,'Muqaba','en',NULL,NULL,NULL),(1375,688,'شمال سهلة','ar',NULL,NULL,NULL),(1376,688,'North Sehla','en',NULL,NULL,NULL),(1377,689,'القدم','ar',NULL,NULL,NULL),(1378,689,'Qadam','en',NULL,NULL,NULL),(1379,690,'قلا','ar',NULL,NULL,NULL),(1380,690,'Qella','en',NULL,NULL,NULL),(1381,691,'القرية','ar',NULL,NULL,NULL),(1382,691,'Qurayya','en',NULL,NULL,NULL),(1383,692,'مستوطنة سار','ar',NULL,NULL,NULL),(1384,692,'Saar','en',NULL,NULL,NULL),(1385,693,'سداد','ar',NULL,NULL,NULL),(1386,693,'Sadad','en',NULL,NULL,NULL),(1387,694,'الصخير','ar',NULL,NULL,NULL),(1388,694,'Shahrakan','en',NULL,NULL,NULL),(1389,695,'الشاخورة','ar',NULL,NULL,NULL),(1390,695,'Shakhurah','en',NULL,NULL,NULL),(1391,696,'جنوب سهلة','ar',NULL,NULL,NULL),(1392,696,'South Sehla','en',NULL,NULL,NULL),(1393,697,'طشان','ar',NULL,NULL,NULL),(1394,697,'Tashan','en',NULL,NULL,NULL),(1395,698,'ام الصبان','ar',NULL,NULL,NULL),(1396,698,'Umm Al Sabban','en',NULL,NULL,NULL),(1397,699,'الزلاق','ar',NULL,NULL,NULL),(1398,699,'Zallaq','en',NULL,NULL,NULL),(1399,700,'عالي','ar',NULL,NULL,NULL),(1400,700,'A\'ali','en',NULL,NULL,NULL),(1401,701,'الرفاع الشرقي','ar',NULL,NULL,NULL),(1402,701,'East Riffa','en',NULL,NULL,NULL),(1403,702,'مدينة عيسى','ar',NULL,NULL,NULL),(1404,702,'Isa Town','en',NULL,NULL,NULL),(1405,703,'Jordab','ar',NULL,NULL,NULL),(1406,703,'Jordab','en',NULL,NULL,NULL),(1407,704,'نسفة','ar',NULL,NULL,NULL),(1408,704,'Nasfah','en',NULL,NULL,NULL),(1409,705,'سلماباد','ar',NULL,NULL,NULL),(1410,705,'Salmabad','en',NULL,NULL,NULL),(1411,706,'سند','ar',NULL,NULL,NULL),(1412,706,'Sanad','en',NULL,NULL,NULL),(1413,707,'سترة','ar',NULL,NULL,NULL),(1414,707,'Sitra','en',NULL,NULL,NULL),(1415,708,'توبلي','ar',NULL,NULL,NULL),(1416,708,'Tubli','en',NULL,NULL,NULL),(1417,709,'الرفاع الغربي','ar',NULL,NULL,NULL),(1418,709,'West Riffa','en',NULL,NULL,NULL),(1419,710,'مدينة زايد','ar',NULL,NULL,NULL),(1420,710,'Zayed Town','en',NULL,NULL,NULL),(1421,711,'العذبة','ar',NULL,NULL,NULL),(1422,711,'Al Adhbah','en',NULL,NULL,NULL),(1423,712,'منطقة الظعاين','ar',NULL,NULL,NULL),(1424,712,'Al Daayen','en',NULL,NULL,NULL),(1425,713,'الهتمي','ar',NULL,NULL,NULL),(1426,713,'Al Hitmi','en',NULL,NULL,NULL),(1427,714,'الجسرة','ar',NULL,NULL,NULL),(1428,714,'Al Jasrah','en',NULL,NULL,NULL),(1429,715,'الجميلية','ar',NULL,NULL,NULL),(1430,715,'Al Jumaliyah','en',NULL,NULL,NULL),(1431,716,'مدينة الكعبان','ar',NULL,NULL,NULL),(1432,716,'Al Qa`Abiyah','en',NULL,NULL,NULL),(1433,717,'خليفات','ar',NULL,NULL,NULL),(1434,717,'Al Khalifat','en',NULL,NULL,NULL),(1435,718,'الخور','ar',NULL,NULL,NULL),(1436,718,'Al Khawr','en',NULL,NULL,NULL),(1437,719,'منطقة الخور','ar',NULL,NULL,NULL),(1438,719,'Al Khor','en',NULL,NULL,NULL),(1439,720,'الخوير','ar',NULL,NULL,NULL),(1440,720,'Al Khuwair','en',NULL,NULL,NULL),(1441,721,'المفجر','ar',NULL,NULL,NULL),(1442,721,'Al Mafjar','en',NULL,NULL,NULL),(1443,722,'الكعبية','ar',NULL,NULL,NULL),(1444,722,'Al Qaabiya','en',NULL,NULL,NULL),(1445,723,'الريان','ar',NULL,NULL,NULL),(1446,723,'Al Rayyan','en',NULL,NULL,NULL),(1447,724,'السيلية','ar',NULL,NULL,NULL),(1448,724,'Al Sailiya','en',NULL,NULL,NULL),(1449,725,'الشمال','ar',NULL,NULL,NULL),(1450,725,'Al Shamal','en',NULL,NULL,NULL),(1451,726,'منطقة الوكرة','ar',NULL,NULL,NULL),(1452,726,'Al Wakrah','en',NULL,NULL,NULL),(1453,727,'منطقة الدوحة','ar',NULL,NULL,NULL),(1454,727,'Doha','en',NULL,NULL,NULL),(1455,728,'منطقة الدخنان','ar',NULL,NULL,NULL),(1456,728,'Dukhan','en',NULL,NULL,NULL),(1457,729,'الغرافة','ar',NULL,NULL,NULL),(1458,729,'Gharafa','en',NULL,NULL,NULL),(1459,730,'راس لفان','ar',NULL,NULL,NULL),(1460,730,'Ras Laffan','en',NULL,NULL,NULL),(1461,731,'منطقة الشيحانية','ar',NULL,NULL,NULL),(1462,731,'Ash Shahaniyah','en',NULL,NULL,NULL),(1463,732,'ام باب','ar',NULL,NULL,NULL),(1464,732,'Umm Bab','en',NULL,NULL,NULL),(1465,733,'منطقة ام سعيد','ar',NULL,NULL,NULL),(1466,733,'Umm Said','en',NULL,NULL,NULL),(1467,734,'ام صلال علي','ar',NULL,NULL,NULL),(1468,734,'Umm Salal Ali','en',NULL,NULL,NULL),(1469,735,'منطقة ام صلال','ar',NULL,NULL,NULL),(1470,735,'Umm Salal Muhammed','en',NULL,NULL,NULL),(1471,736,'عبري','ar',NULL,NULL,NULL),(1472,736,'Ibri','en',NULL,NULL,NULL),(1473,737,'بركاء','ar',NULL,NULL,NULL),(1474,737,'Barka','en',NULL,NULL,NULL),(1475,738,'الخابورة','ar',NULL,NULL,NULL),(1476,738,'Al Khaburah','en',NULL,NULL,NULL),(1477,739,'لوى','ar',NULL,NULL,NULL),(1478,739,'Liwa','en',NULL,NULL,NULL),(1479,740,'نخل','ar',NULL,NULL,NULL),(1480,740,'Nakhl','en',NULL,NULL,NULL),(1481,741,'الرستاق','ar',NULL,NULL,NULL),(1482,741,'Rustaq','en',NULL,NULL,NULL),(1483,742,'صحم','ar',NULL,NULL,NULL),(1484,742,'Saham','en',NULL,NULL,NULL),(1485,743,'Shinas','ar',NULL,NULL,NULL),(1486,743,'Shinas','en',NULL,NULL,NULL),(1487,744,'صحار','ar',NULL,NULL,NULL),(1488,744,'Sohar','en',NULL,NULL,NULL),(1489,745,'السويق','ar',NULL,NULL,NULL),(1490,745,'Suwayq','en',NULL,NULL,NULL),(1491,746,'وادي المعاول','ar',NULL,NULL,NULL),(1492,746,'Wadi Al Maawil','en',NULL,NULL,NULL),(1493,747,'البريمي','ar',NULL,NULL,NULL),(1494,747,'Buraimi','en',NULL,NULL,NULL),(1495,748,'محضة','ar',NULL,NULL,NULL),(1496,748,'Mahdah','en',NULL,NULL,NULL),(1497,749,'الدقم','ar',NULL,NULL,NULL),(1498,749,'Duqm','en',NULL,NULL,NULL),(1499,750,'هيما','ar',NULL,NULL,NULL),(1500,750,'Haima','en',NULL,NULL,NULL),(1501,751,'محوت','ar',NULL,NULL,NULL),(1502,751,'Mahout','en',NULL,NULL,NULL),(1503,752,'جعلان بني بو علي','ar',NULL,NULL,NULL),(1504,752,'Jaalan Bani Bu Ali','en',NULL,NULL,NULL),(1505,753,'جعلان بني بو حسن','ar',NULL,NULL,NULL),(1506,753,'Jaalan Bani Buhassan','en',NULL,NULL,NULL),(1507,754,'مصيرة','ar',NULL,NULL,NULL),(1508,754,'Masirah','en',NULL,NULL,NULL),(1509,755,'وادي بن خالد','ar',NULL,NULL,NULL),(1510,755,'Wadi Bani Khalid','en',NULL,NULL,NULL),(1511,756,'ضلكوت','ar',NULL,NULL,NULL),(1512,756,'Dhalkut','en',NULL,NULL,NULL),(1513,757,'مرباط','ar',NULL,NULL,NULL),(1514,757,'Mirbat','en',NULL,NULL,NULL),(1515,758,'سدح','ar',NULL,NULL,NULL),(1516,758,'Sadah','en',NULL,NULL,NULL),(1517,759,'صلالة','ar',NULL,NULL,NULL),(1518,759,'Salalah','en',NULL,NULL,NULL),(1519,760,'طاقة','ar',NULL,NULL,NULL),(1520,760,'Taqah','en',NULL,NULL,NULL),(1521,761,'بخا','ar',NULL,NULL,NULL),(1522,761,'Bukha','en',NULL,NULL,NULL),(1523,762,'خصب','ar',NULL,NULL,NULL),(1524,762,'Khasab','en',NULL,NULL,NULL),(1525,763,'مدحا','ar',NULL,NULL,NULL),(1526,763,'Madha','en',NULL,NULL,NULL),(1527,764,'ادم','ar',NULL,NULL,NULL),(1528,764,'Adam','en',NULL,NULL,NULL),(1529,765,'العقير','ar',NULL,NULL,NULL),(1530,765,'Al Aqir','en',NULL,NULL,NULL),(1531,766,'الأشخرة','ar',NULL,NULL,NULL),(1532,766,'Ash Ashkarah','en',NULL,NULL,NULL),(1533,767,'العوابي - بركة','ar',NULL,NULL,NULL),(1534,767,'Al Awabi','en',NULL,NULL,NULL),(1535,768,'العوابي - مسقط','ar',NULL,NULL,NULL),(1536,768,'Al Awabi Muscat','en',NULL,NULL,NULL),(1537,769,'بديه','ar',NULL,NULL,NULL),(1538,769,'Al Bidayah','en',NULL,NULL,NULL),(1539,770,'الغزير','ar',NULL,NULL,NULL),(1540,770,'Al Ghazir','en',NULL,NULL,NULL),(1541,771,'الحمرا','ar',NULL,NULL,NULL),(1542,771,'Al Hamra','en',NULL,NULL,NULL),(1543,772,'الجديدة','ar',NULL,NULL,NULL),(1544,772,'Al Jadidah','en',NULL,NULL,NULL),(1545,773,'الخوض','ar',NULL,NULL,NULL),(1546,773,'Al Khoudh','en',NULL,NULL,NULL),(1547,774,'الخوير','ar',NULL,NULL,NULL),(1548,774,'Al Khuwair','en',NULL,NULL,NULL),(1549,775,'المزيونه','ar',NULL,NULL,NULL),(1550,775,'Al Mazyunah','en',NULL,NULL,NULL),(1551,776,'السعادة','ar',NULL,NULL,NULL),(1552,776,'Al Saada','en',NULL,NULL,NULL),(1553,777,'الأنصب','ar',NULL,NULL,NULL),(1554,777,'Al Ansab','en',NULL,NULL,NULL),(1555,778,'الحيل','ar',NULL,NULL,NULL),(1556,778,'Al Hail','en',NULL,NULL,NULL),(1557,779,'الجفنين','ar',NULL,NULL,NULL),(1558,779,'Al Jafnayn','en',NULL,NULL,NULL),(1559,780,'المعبيلة','ar',NULL,NULL,NULL),(1560,780,'Al Maabilah','en',NULL,NULL,NULL),(1561,781,'الوجاجة','ar',NULL,NULL,NULL),(1562,781,'Al Wajajah','en',NULL,NULL,NULL),(1563,782,'العامرات','ar',NULL,NULL,NULL),(1564,782,'Al Amarat','en',NULL,NULL,NULL),(1565,783,'السليف','ar',NULL,NULL,NULL),(1566,783,'As Sulaif','en',NULL,NULL,NULL),(1567,784,'عوقد','ar',NULL,NULL,NULL),(1568,784,'Awqad','en',NULL,NULL,NULL),(1569,785,'العذبية','ar',NULL,NULL,NULL),(1570,785,'Azaiba','en',NULL,NULL,NULL),(1571,786,'بهلاء','ar',NULL,NULL,NULL),(1572,786,'Bahla','en',NULL,NULL,NULL),(1573,787,'بديد','ar',NULL,NULL,NULL),(1574,787,'Bidbid','en',NULL,NULL,NULL),(1575,788,'Bidiyah','ar',NULL,NULL,NULL),(1576,788,'Bidiyah','en',NULL,NULL,NULL),(1577,789,'بوشر','ar',NULL,NULL,NULL),(1578,789,'Bowsher','en',NULL,NULL,NULL),(1579,790,'الدهاريز','ar',NULL,NULL,NULL),(1580,790,'Dahariz','en',NULL,NULL,NULL),(1581,791,'دراسيت','ar',NULL,NULL,NULL),(1582,791,'Darsait','en',NULL,NULL,NULL),(1583,792,'ضنك','ar',NULL,NULL,NULL),(1584,792,'Dhank','en',NULL,NULL,NULL),(1585,793,'دبا','ar',NULL,NULL,NULL),(1586,793,'Diba','en',NULL,NULL,NULL),(1587,794,'دما والطائيين','ar',NULL,NULL,NULL),(1588,794,'Dima Wattayeen','en',NULL,NULL,NULL),(1589,795,'فهود','ar',NULL,NULL,NULL),(1590,795,'Fahud','en',NULL,NULL,NULL),(1591,796,'فلج القبائل','ar',NULL,NULL,NULL),(1592,796,'Falaj Al Qaba\'il','en',NULL,NULL,NULL),(1593,797,'فنجا','ar',NULL,NULL,NULL),(1594,797,'Fanja','en',NULL,NULL,NULL),(1595,798,'Firq','ar',NULL,NULL,NULL),(1596,798,'Firq','en',NULL,NULL,NULL),(1597,799,'غلا','ar',NULL,NULL,NULL),(1598,799,'Ghala','en',NULL,NULL,NULL),(1599,800,'الغبرة','ar',NULL,NULL,NULL),(1600,800,'Ghubrah','en',NULL,NULL,NULL),(1601,801,'حلبان','ar',NULL,NULL,NULL),(1602,801,'Halban','en',NULL,NULL,NULL),(1603,802,'الحمرية','ar',NULL,NULL,NULL),(1604,802,'Hamriyah','en',NULL,NULL,NULL),(1605,803,'ازكي','ar',NULL,NULL,NULL),(1606,803,'Izki','en',NULL,NULL,NULL),(1607,804,'الجبل الأخضر','ar',NULL,NULL,NULL),(1608,804,'Jabal Akhdar','en',NULL,NULL,NULL),(1609,805,'جيبرو','ar',NULL,NULL,NULL),(1610,805,'Jibroo','en',NULL,NULL,NULL),(1611,806,'خضرا','ar',NULL,NULL,NULL),(1612,806,'Khadra','en',NULL,NULL,NULL),(1613,807,'خطمة ملاحة','ar',NULL,NULL,NULL),(1614,807,'Khatmat Malahah','en',NULL,NULL,NULL),(1615,808,'لزغ','ar',NULL,NULL,NULL),(1616,808,'Lizugh','en',NULL,NULL,NULL),(1617,809,'مدينة السلطان قابوس','ar',NULL,NULL,NULL),(1618,809,'Madinat As Sultan Qaboos','en',NULL,NULL,NULL),(1619,810,'مجيس','ar',NULL,NULL,NULL),(1620,810,'Majis','en',NULL,NULL,NULL),(1621,811,'منح','ar',NULL,NULL,NULL),(1622,811,'Manah','en',NULL,NULL,NULL),(1623,812,'مرمول','ar',NULL,NULL,NULL),(1624,812,'Marmul','en',NULL,NULL,NULL),(1625,813,'الموالح','ar',NULL,NULL,NULL),(1626,813,'Mawaleh','en',NULL,NULL,NULL),(1627,814,'مسفاه','ar',NULL,NULL,NULL),(1628,814,'Misfah','en',NULL,NULL,NULL),(1629,815,'الملدة','ar',NULL,NULL,NULL),(1630,815,'Muladdah','en',NULL,NULL,NULL),(1631,816,'مسقط','ar',NULL,NULL,NULL),(1632,816,'Muscat','en',NULL,NULL,NULL),(1633,817,'مطرح','ar',NULL,NULL,NULL),(1634,817,'Muttrah','en',NULL,NULL,NULL),(1635,818,'نزوى','ar',NULL,NULL,NULL),(1636,818,'Nizwa','en',NULL,NULL,NULL),(1637,819,'قنتب','ar',NULL,NULL,NULL),(1638,819,'Qantab','en',NULL,NULL,NULL),(1639,820,'Qantana','ar',NULL,NULL,NULL),(1640,820,'Qantana','en',NULL,NULL,NULL),(1641,821,'قريات','ar',NULL,NULL,NULL),(1642,821,'Qurayat','en',NULL,NULL,NULL),(1643,822,'القرم','ar',NULL,NULL,NULL),(1644,822,'Qurum','en',NULL,NULL,NULL),(1645,823,'البديع','ar',NULL,NULL,NULL),(1646,823,'Budaiya','en',NULL,NULL,NULL),(1647,824,'راس الحد','ar',NULL,NULL,NULL),(1648,824,'Ras Al Hadd','en',NULL,NULL,NULL),(1649,825,'ريسوت','ar',NULL,NULL,NULL),(1650,825,'Rasyut','en',NULL,NULL,NULL),(1651,826,'الرميس','ar',NULL,NULL,NULL),(1652,826,'Rumais','en',NULL,NULL,NULL),(1653,827,'الرسيل','ar',NULL,NULL,NULL),(1654,827,'Rusayl','en',NULL,NULL,NULL),(1655,828,'الرسيل','ar',NULL,NULL,NULL),(1656,828,'Rusayl','en',NULL,NULL,NULL),(1657,829,'روي','ar',NULL,NULL,NULL),(1658,829,'Ruwi','en',NULL,NULL,NULL),(1659,830,'صحلنوت','ar',NULL,NULL,NULL),(1660,830,'Sahalnoot','en',NULL,NULL,NULL),(1661,831,'سمد الشان','ar',NULL,NULL,NULL),(1662,831,'Samad Al Shan','en',NULL,NULL,NULL),(1663,832,'سمائل','ar',NULL,NULL,NULL),(1664,832,'Samayil','en',NULL,NULL,NULL),(1665,833,'السيب','ar',NULL,NULL,NULL),(1666,833,'Seeb','en',NULL,NULL,NULL),(1667,834,'سداب','ar',NULL,NULL,NULL),(1668,834,'Sidab','en',NULL,NULL,NULL),(1669,835,'سناو','ar',NULL,NULL,NULL),(1670,835,'Sinaw','en',NULL,NULL,NULL),(1671,836,'السنينة','ar',NULL,NULL,NULL),(1672,836,'As Sunainah','en',NULL,NULL,NULL),(1673,837,'ثمريت','ar',NULL,NULL,NULL),(1674,837,'Thumrait','en',NULL,NULL,NULL),(1675,838,'الثرمد','ar',NULL,NULL,NULL),(1676,838,'Tharmad','en',NULL,NULL,NULL),(1677,839,'طيوي','ar',NULL,NULL,NULL),(1678,839,'Tiwi','en',NULL,NULL,NULL),(1679,840,'وادي عداي','ar',NULL,NULL,NULL),(1680,840,'Wadi Aday','en',NULL,NULL,NULL),(1681,841,'وادي الجيزي','ar',NULL,NULL,NULL),(1682,841,'Wadi Al Jizi','en',NULL,NULL,NULL),(1683,842,'وادي حبي','ar',NULL,NULL,NULL),(1684,842,'Wadi Hibi','en',NULL,NULL,NULL),(1685,843,'وادي كبير','ar',NULL,NULL,NULL),(1686,843,'Wadi Kabir','en',NULL,NULL,NULL),(1687,844,'الوطيه','ar',NULL,NULL,NULL),(1688,844,'Wattayah','en',NULL,NULL,NULL),(1689,845,'ودام الساحل','ar',NULL,NULL,NULL),(1690,845,'Wudam Al Sahil','en',NULL,NULL,NULL),(1691,846,'يتي','ar',NULL,NULL,NULL),(1692,846,'Yiti','en',NULL,NULL,NULL);

--
-- Table structure for table `regions`
--

CREATE TABLE `regions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `address_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address_latitude` double NOT NULL,
  `address_longitude` double NOT NULL,
  `governments_id` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `regions_governments_id_foreign` (`governments_id`)
) ENGINE=InnoDB AUTO_INCREMENT=847 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `regions`
--

INSERT INTO `regions` (`id`, `status`, `address_address`, `address_latitude`, `address_longitude`, `governments_id`, `created_at`, `updated_at`) VALUES (19,1,'مدينة الكويت',0,0,8,'2022-08-25 10:34:31','2022-08-25 10:34:31'),(20,1,'دسمان',0,0,8,'2022-08-25 10:36:00','2022-08-25 10:36:00'),(21,1,'شرق',0,0,8,'2022-08-25 10:36:31','2022-08-25 10:36:31'),(22,1,'الصوابر',0,0,8,'2022-08-25 10:41:53','2022-08-25 10:41:53'),(23,1,'المرقاب',0,0,8,'2022-08-25 10:42:29','2022-08-25 10:42:29'),(24,1,'القبلة',0,0,8,'2022-08-25 10:42:56','2022-08-25 10:42:56'),(25,1,'الصالحية',0,0,8,'2022-08-25 10:43:27','2022-08-25 10:43:27'),(26,1,'الوطية',0,0,8,'2022-08-25 10:43:58','2022-08-25 10:43:58'),(27,1,'بنيد القار',0,0,8,'2022-08-25 10:44:54','2022-08-25 10:44:54'),(28,1,'كيفان',0,0,8,'2022-08-25 10:45:21','2022-08-25 10:45:21'),(29,1,'الدوحة',0,0,8,'2022-08-25 10:46:27','2022-08-25 10:46:27'),(30,1,'الدسمة',0,0,8,'2022-08-25 10:46:52','2022-08-25 10:46:52'),(31,1,'الدعية',0,0,8,'2022-08-25 10:48:10','2022-08-25 10:48:10'),(32,1,'المنصورية',0,0,8,'2022-08-25 10:48:40','2022-08-25 10:48:40'),(33,1,'ضاحية عبد الله السالم',0,0,8,'2022-08-25 10:49:23','2022-08-25 10:49:23'),(34,1,'النزهة',0,0,8,'2022-08-25 10:49:56','2022-08-25 10:49:56'),(35,1,'الفيحاء',0,0,8,'2022-08-25 10:50:29','2022-08-25 10:50:29'),(36,1,'الشامية',0,0,8,'2022-08-25 10:51:07','2022-08-25 10:51:07'),(37,1,'الروضة',0,0,8,'2022-08-25 10:51:48','2022-08-25 10:51:48'),(38,1,'العديلية',0,0,8,'2022-08-25 10:52:21','2022-08-25 10:52:21'),(39,1,'الخالدية',0,0,8,'2022-08-25 10:53:18','2022-08-25 10:53:18'),(40,1,'القادسية',0,0,8,'2022-08-25 10:53:43','2022-08-25 10:53:43'),(41,1,'قرطبة',0,0,8,'2022-08-25 10:54:11','2022-08-25 10:54:11'),(42,1,'السرة',0,0,8,'2022-08-25 10:54:40','2022-08-25 10:54:40'),(43,1,'اليرموك',0,0,8,'2022-08-25 10:55:09','2022-08-25 10:55:09'),(44,1,'الشويخ',0,0,8,'2022-08-25 10:55:54','2022-08-25 10:55:54'),(45,1,'الري',0,0,8,'2022-08-25 10:56:14','2022-08-25 10:56:14'),(46,1,'غرناطة، Kuwait',29.312521,47.8785532,8,'2022-08-25 10:57:53','2022-08-25 10:57:53'),(47,1,'الصليبيخات',29.312521,47.8785532,8,'2022-08-25 10:59:18','2022-08-25 10:59:18'),(48,1,'النهضة',29.312521,47.8785532,8,'2022-08-25 10:59:50','2022-08-25 10:59:50'),(49,1,'مدينة جابر الأحمد',29.312521,47.8785532,8,'2022-08-25 11:00:29','2022-08-25 11:00:29'),(50,1,'القيروان',29.312521,47.8785532,8,'2022-08-25 11:01:01','2022-08-25 11:01:01'),(51,1,'شمال غرب الصليبيخات',29.312521,47.8785532,8,'2022-08-25 11:02:03','2022-08-25 11:02:03'),(52,1,'الفنطاس',29.312521,47.8785532,9,'2022-08-25 11:02:23','2022-08-25 11:02:23'),(53,1,'العقيلة',29.312521,47.8785532,9,'2022-08-25 11:02:49','2022-08-25 11:02:49'),(54,1,'الظهر',29.312521,47.8785532,9,'2022-08-25 11:03:15','2022-08-25 11:03:15'),(55,1,'المقوع',29.312521,47.8785532,9,'2022-08-25 11:03:52','2022-08-25 11:03:52'),(56,1,'المهبولة',29.312521,47.8785532,9,'2022-08-25 11:08:24','2022-08-25 11:08:24'),(57,1,'الرقة',29.312521,47.8785532,9,'2022-08-25 11:08:46','2022-08-25 11:08:46'),(58,1,'هدية',29.312521,47.8785532,9,'2022-08-25 11:09:06','2022-08-25 11:09:06'),(59,1,'أبو حليفة',29.312521,47.8785532,9,'2022-08-25 11:09:46','2022-08-25 11:09:46'),(60,1,'الصباحية',29.312521,47.8785532,9,'2022-08-25 11:10:14','2022-08-25 11:10:14'),(61,1,'المنقف',29.312521,47.8785532,9,'2022-08-25 11:10:44','2022-08-25 11:10:44'),(62,1,'الفحيحيل',29.312521,47.8785532,9,'2022-08-25 11:11:17','2022-08-25 11:11:17'),(63,1,'الأحمدي',29.312521,47.8785532,9,'2022-08-25 11:11:52','2022-08-25 11:11:52'),(64,1,'الوفرة',29.312521,47.8785532,9,'2022-08-25 11:12:12','2022-08-25 11:12:12'),(65,1,'الزور',29.312521,47.8785532,9,'2022-08-25 11:12:36','2022-08-25 11:12:36'),(66,1,'الخيران',29.312521,47.8785532,9,'2022-08-25 11:13:08','2022-08-25 11:13:08'),(67,1,'ميناء عبد الله',29.312521,47.8785532,9,'2022-08-25 11:13:55','2022-08-25 11:13:55'),(68,1,'الوفرة الزراعية',29.312521,47.8785532,9,'2022-08-25 11:14:28','2022-08-25 11:14:28'),(69,1,'بنيدر',29.312521,47.8785532,9,'2022-08-25 11:14:58','2022-08-25 11:14:58'),(70,1,'الجليعة',29.312521,47.8785532,9,'2022-08-25 11:15:37','2022-08-25 11:15:37'),(71,1,'الضباعية',29.312521,47.8785532,9,'2022-08-25 11:16:05','2022-08-25 11:16:05'),(72,1,'ضاحية جابر العلي',29.312521,47.8785532,9,'2022-08-25 11:16:38','2022-08-25 11:16:38'),(73,1,'ضاحية فهد الأحمد',29.312521,47.8785532,9,'2022-08-25 11:17:13','2022-08-25 11:17:13'),(74,1,'الشعيبة',29.312521,47.8785532,9,'2022-08-25 11:17:41','2022-08-25 11:17:41'),(75,1,'واره',29.312521,47.8785532,9,'2022-08-25 11:18:02','2022-08-25 11:18:02'),(76,1,'مدينة صباح الأحمد',29.312521,47.8785532,9,'2022-08-25 11:18:43','2022-08-25 11:18:43'),(77,1,'النويصيب',29.312521,47.8785532,9,'2022-08-25 11:19:20','2022-08-25 11:19:20'),(78,1,'مدينة الخيران',29.312521,47.8785532,9,'2022-08-25 11:19:53','2022-08-25 11:19:53'),(79,1,'ضاحية علي صباح السالم أم الهيمان سابقاً',29.312521,47.8785532,9,'2022-08-25 11:20:38','2022-08-25 11:20:38'),(80,1,'مدينة صباح الأحمد البحرية',29.312521,47.8785532,9,'2022-08-25 11:21:22','2022-08-25 11:21:22'),(81,1,'Abraq Khaitan Secondary School for Girls, Naser Abdullah Aljabri Street, Kuwait',29.3005413,47.9720904,10,'2022-08-25 11:22:08','2023-04-18 10:13:45'),(82,1,'الأندلس',29.312521,47.8785532,10,'2022-08-25 11:22:29','2022-08-25 11:22:29'),(83,1,'اشبيلية',29.312521,47.8785532,10,'2022-08-25 11:23:08','2022-08-25 11:23:08'),(84,1,'جليب الشيوخ',29.312521,47.8785532,10,'2022-08-25 11:23:43','2022-08-25 11:23:43'),(85,1,'خيطان',29.312521,47.8785532,10,'2022-08-25 11:24:06','2022-08-25 11:24:06'),(86,1,'خيطان الجديدة',29.312521,47.8785532,10,'2022-08-25 11:24:30','2022-08-25 11:24:30'),(87,1,'العمرية',29.312521,47.8785532,10,'2022-08-25 11:24:58','2022-08-25 11:24:58'),(88,1,'العارضية',29.312521,47.8785532,10,'2022-08-25 11:25:22','2022-08-25 11:25:22'),(89,1,'العارضية الصناعية',29.312521,47.8785532,10,'2022-08-25 11:26:01','2022-08-25 11:26:01'),(90,1,'العباسية',29.312521,47.8785532,10,'2022-08-25 11:26:30','2022-08-25 11:26:30'),(91,1,'الفردوس',29.312521,47.8785532,10,'2022-08-25 11:27:01','2022-08-25 11:27:01'),(92,1,'الفروانية',29.312521,47.8785532,10,'2022-08-25 11:27:27','2022-08-25 11:27:27'),(93,1,'الحساوي',29.312521,47.8785532,10,'2022-08-25 11:27:52','2022-08-25 11:27:52'),(94,1,'الشدادية',0,0,10,'2022-08-25 11:31:28','2022-08-25 11:31:28'),(95,1,'الرابية',0,0,10,'2022-08-25 11:31:56','2022-08-25 11:31:56'),(96,1,'الرحاب',0,0,10,'2022-08-25 11:32:37','2022-08-25 11:32:37'),(97,1,'الرقعي',0,0,10,'2022-08-25 11:34:15','2022-08-25 11:34:15'),(98,1,'Al rai, Shuwaikh Industrial, Kuwait',29.3083977,47.9404184,10,'2022-08-25 11:34:49','2023-04-18 10:39:49'),(99,1,'ضاحية صباح الناصر',0,0,10,'2022-08-25 11:35:48','2022-08-25 11:35:48'),(100,1,'ضاحية عبد الله المبارك',0,0,10,'2022-08-25 11:36:25','2022-08-25 11:36:25'),(101,1,'Al-Dajeej, Kuwait',29.2620388,47.9630143,10,'2022-08-25 11:37:32','2023-04-18 10:45:51'),(102,1,'الصليبية',0,0,11,'2022-08-25 11:38:04','2022-08-25 11:38:04'),(103,1,'أمغرة',0,0,11,'2022-08-25 11:38:29','2022-08-25 11:38:29'),(104,1,'Naeem',0,0,11,'2022-08-25 11:39:03','2022-08-25 11:39:03'),(105,1,'القصر',0,0,11,'2022-08-25 11:42:07','2022-08-25 11:42:07'),(106,1,'الواحة',0,0,11,'2022-08-25 11:42:30','2022-08-25 11:42:30'),(107,1,'تيماء',0,0,11,'2022-08-25 11:42:50','2022-08-25 11:42:50'),(108,1,'النسيم',0,0,11,'2022-08-25 11:43:13','2022-08-25 11:43:13'),(109,1,'العيون',0,0,11,'2022-08-25 11:43:44','2022-08-25 11:43:44'),(110,1,'القيصرية',0,0,11,'2022-08-25 11:44:37','2022-08-25 11:44:37'),(111,1,'العبدلي',0,0,11,'2022-08-25 11:45:06','2022-08-25 11:45:06'),(112,1,'الجهراء القديمة',0,0,11,'2022-08-25 11:46:42','2022-08-25 11:46:42'),(113,1,'New jahra',0,0,11,'2022-08-25 11:47:31','2022-08-25 11:47:31'),(114,1,'كاظمة',0,0,11,'2022-08-25 11:47:48','2022-08-25 11:47:48'),(115,1,'مدينة سعد العبد الله',0,0,11,'2022-08-25 11:48:22','2022-08-25 11:48:22'),(116,1,'السالمي',0,0,11,'2022-08-25 11:48:52','2022-08-25 11:48:52'),(117,1,'المطلاع',0,0,11,'2022-08-25 11:49:24','2022-08-25 11:49:24'),(118,1,'مدينة الحرير',0,0,11,'2022-08-25 11:50:13','2022-08-25 11:50:13'),(119,1,'كبد',0,0,11,'2022-08-25 11:50:44','2022-08-25 11:50:44'),(120,1,'الروضتين',0,0,11,'2022-08-25 11:51:21','2022-08-25 11:51:21'),(121,1,'الصبية',0,0,11,'2022-08-25 11:51:47','2022-08-25 11:51:47'),(122,1,'حولي',0,0,12,'2022-08-25 11:52:26','2022-08-25 11:52:26'),(123,1,'الشعب',0,0,12,'2022-08-25 11:52:47','2022-08-25 11:52:47'),(124,1,'السالمية',0,0,12,'2022-08-25 11:53:07','2022-08-25 11:53:07'),(125,1,'الرميثية',0,0,12,'2022-08-25 11:53:52','2022-08-25 11:53:52'),(126,1,'الجابرية',0,0,12,'2022-08-25 11:54:15','2022-08-25 11:54:15'),(127,1,'مشرف',0,0,12,'2022-08-25 11:54:39','2022-08-25 11:54:39'),(128,1,'بيان',0,0,12,'2022-08-25 11:54:57','2022-08-25 11:54:57'),(129,1,'آلبدع',0,0,12,'2022-08-25 11:55:23','2022-08-25 11:55:23'),(130,1,'النقرة',0,0,12,'2022-08-25 11:55:53','2022-08-25 11:55:53'),(131,1,'ميدان حولي',0,0,12,'2022-08-25 11:56:15','2022-08-25 11:56:15'),(132,1,'ضاحية مبارك العبد الله الجابر',0,0,12,'2022-08-25 11:57:05','2022-08-25 11:57:05'),(133,1,'سلوى',0,0,12,'2022-08-25 11:57:23','2022-08-25 11:57:23'),(134,1,'جنوب السرة',0,0,12,'2022-08-25 11:57:54','2022-08-25 11:57:54'),(135,1,'الزهراء',0,0,12,'2022-08-25 11:58:27','2022-08-25 11:58:27'),(136,1,'الصديق',0,0,12,'2022-08-25 11:59:17','2022-08-25 11:59:17'),(137,1,'حطين',0,0,12,'2022-08-25 11:59:57','2022-08-25 11:59:57'),(138,1,'السلام',0,0,12,'2022-08-25 12:01:35','2022-08-25 12:01:35'),(139,1,'الشهداء',0,0,12,'2022-08-25 12:02:07','2022-08-25 12:02:07'),(140,1,'العدان',0,0,13,'2022-08-25 12:02:29','2022-08-25 12:02:29'),(141,1,'القصور',0,0,13,'2022-08-25 12:02:59','2022-08-25 12:02:59'),(142,1,'القرين',0,0,13,'2022-08-25 12:03:31','2022-08-25 12:03:31'),(143,1,'ضاحية صباح السالم',0,0,13,'2022-08-25 12:04:02','2022-08-25 12:04:02'),(144,1,'المسيلة',0,0,13,'2022-08-25 12:04:27','2022-08-25 12:04:27'),(145,1,'المسايل',0,0,13,'2022-08-25 12:04:54','2022-08-25 12:04:54'),(146,1,'أبو فطيرة',0,0,13,'2022-08-25 12:05:20','2022-08-25 12:05:20'),(147,1,'أبو الحصانية',0,0,13,'2022-08-25 12:05:57','2022-08-25 12:05:57'),(148,1,'صبحان',0,0,13,'2022-08-25 12:06:25','2022-08-25 12:06:25'),(149,1,'الفنيطيس',0,0,13,'2022-08-25 12:06:55','2022-08-25 12:06:55'),(151,1,'مبارك الكبير، الكويت‎',29.1886698,48.0806909,13,'2022-08-28 01:58:47','2022-08-28 01:58:47');

--
-- Table structure for table `related_products`
--

CREATE TABLE `related_products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int unsigned DEFAULT NULL,
  `related_id` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `option_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `related_products_product_id_foreign` (`product_id`),
  KEY `related_products_related_id_foreign` (`related_id`)
) ENGINE=InnoDB AUTO_INCREMENT=297 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `related_products`
--

INSERT INTO `related_products` (`id`, `product_id`, `related_id`, `created_at`, `updated_at`, `option_id`) VALUES (19,10,9,'2023-04-22 23:50:02','2023-04-22 23:50:02',8),(20,10,10,'2023-04-22 23:50:02','2023-04-22 23:50:02',15),(25,9,9,'2023-04-28 02:25:02','2023-04-28 02:25:02',8),(26,9,10,'2023-04-28 02:25:02','2023-04-28 02:25:02',15),(42,12,9,'2023-05-01 15:57:33','2023-05-01 15:57:33',8),(78,47,47,'2023-06-17 22:17:16','2023-06-17 22:17:16',31),(79,47,47,'2023-06-17 22:17:16','2023-06-17 22:17:16',31),(80,47,47,'2023-06-17 22:17:16','2023-06-17 22:17:16',31),(266,280,16,'2023-07-19 16:58:20','2023-07-19 16:58:20',32),(267,280,48,'2023-07-19 16:58:20','2023-07-19 16:58:20',263),(268,280,52,'2023-07-19 16:58:20','2023-07-19 16:58:20',486),(272,281,48,'2023-07-19 18:02:50','2023-07-19 18:02:50',262),(273,281,52,'2023-07-19 18:02:50','2023-07-19 18:02:50',485),(288,48,54,'2023-08-16 18:17:26','2023-08-16 18:17:26',270),(289,48,20,'2023-08-16 18:17:26','2023-08-16 18:17:26',37),(292,270,16,'2023-08-27 04:49:00','2023-08-27 04:49:00',32),(293,270,48,'2023-08-27 04:49:00','2023-08-27 04:49:00',262),(294,85,48,'2023-08-30 00:11:02','2023-08-30 00:11:02',261),(295,85,20,'2023-08-30 00:11:02','2023-08-30 00:11:02',36),(296,20,48,'2023-08-30 00:12:42','2023-08-30 00:12:42',261);

--
-- Table structure for table `role_user`
--

CREATE TABLE `role_user` (
  `role_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `user_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`,`user_type`),
  KEY `role_user_role_id_foreign` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_user`
--

INSERT INTO `role_user` (`role_id`, `user_id`, `user_type`) VALUES (1,1,'App\\Models\\User'),(2,91,'App\\Models\\User'),(2,92,'App\\Models\\User'),(2,127,'App\\Models\\User'),(2,128,'App\\Models\\User'),(2,129,'App\\Models\\User'),(2,130,'App\\Models\\User'),(2,131,'App\\Models\\User'),(2,132,'App\\Models\\User'),(2,133,'App\\Models\\User'),(2,135,'App\\Models\\User'),(2,139,'App\\Models\\User'),(2,140,'App\\Models\\User'),(2,141,'App\\Models\\User'),(2,142,'App\\Models\\User'),(10,88,'App\\Models\\User'),(10,120,'App\\Models\\User'),(10,121,'App\\Models\\User');

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

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` (`id`, `name`, `display_name`, `description`, `created_at`, `updated_at`) VALUES (1,'super_admin','Super Admin','Super Admin','2022-06-21 09:32:18','2022-06-21 09:32:18'),(2,'clients','Clients','Clients','2022-06-21 09:32:18','2022-06-21 09:32:18'),(3,'admin','Admin','Admin','2022-06-21 09:32:18','2022-06-21 09:32:18'),(10,'Tager',NULL,NULL,'2024-10-29 22:14:32','2024-10-29 22:25:10');

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `payload` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('2qpCxPKjulTHyAfbaYigW06Gie0HC4Obda8XXl2M',NULL,'66.102.8.9','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiT1ZNNnFIUkhaNFRmQVJaZ1poWU5wMlg4d2lMZnFlU05vQVh2M2NvRyI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHBzOi8vbmF0aW9uYWwtZy5jb20vYXIiO31zOjY6ImxvY2FsZSI7czoyOiJhciI7fQ==',1691885931),('e6Hh4zldmgyqACrr24SN1zZJUndCDnN5EZjZ9cBe',NULL,'85.208.96.210','Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiQkhCbFBFeHJRTEVqMmcyZW9pbzhycGYzUElFNVBkcXNRa3dPVmZxRiI7czo2OiJsb2NhbGUiO3M6MjoiYXIiO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjE3NjoiaHR0cHM6Ly9uYXRpb25hbC1nLmNvbS9hci9wcm9kdWN0cy8zNC8lRDglQUQlRDklODElRDglQTclRDglQjYtJUQ5JTg0JUQ4JUE3JUQ4JUI1JUQ5JTgyLSVEOSU4MSVEOSU4NCVEOSU4OCVEOSU4MSVEOCVCMyVEOCVBNyVEOSU4Ni0tLSVEOCVBNyVEOSU4MyVEOCVCMy0lRDklODQlRDglQTclRDglQjElRDglQUMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1691885390),('FsyLsJ5pMM5r42RYXxXxxBeECdhOeFQnwC6qNdgm',NULL,'136.243.111.17','SiteCheckerBotCrawler/1.0 (+http://sitechecker.pro)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiYVh1UUlwcGVUSWhuSDRvUVd5Z3pyTUxCdHlYdlJYaU1tR1BuZnV5VSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vbmF0aW9uYWwtZy5jb20iO319',1691886114),('gxcRNI9AyL0ugEtr29b8qp1D8Rx6Bidtn892P82k',NULL,'31.13.127.1','facebookexternalhit/1.1 (+http://www.facebook.com/externalhit_uatext.php)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiQUE3OHU0RjJ4M1FOdTdpdmZmTzUzNHVJVDl6T0hrOTRRdUVIeXYwRiI7czo2OiJsb2NhbGUiO3M6MjoiYXIiO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjQ3OiJodHRwczovL25hdGlvbmFsLWcuY29tL2FyL3BhZ2Uv2KfZhNiu2LXZiNi12YrZhyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1691884579),('mvQCWei3vYaADLWHWdlLS1YdghZzbSM2UcmMoWue',69,'156.199.232.186','Mozilla/5.0 (iPhone; CPU iPhone OS 16_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.5.1 Mobile/15E148 Safari/604.1','YTo1OntzOjY6Il90b2tlbiI7czo0MDoiME1mN3NISEVOOE5PMXVsSHJrcFlsNHJTaVdwMzExbzRlU3g0YTNmayI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vbmF0aW9uYWwtZy5jb20vYXIvZ2V0L3Byb2ZpbGUiO31zOjY6ImxvY2FsZSI7czoyOiJhciI7czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6Njk7fQ==',1691885403),('nyRc6qVp1SO4Vq5PRlj70gwxdLIWqpeSp4LJP8vZ',NULL,'156.199.232.186','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36','YTo1OntzOjY6Il90b2tlbiI7czo0MDoiM1ZYdUNDbVV6UUFnUTlYODZpUHRtRzhHN1dKaVBjamdvOUNZRVBuVCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vbmF0aW9uYWwtZy5jb20vYXIvYXV0aC9nb29nbGUiO31zOjY6ImxvY2FsZSI7czoyOiJhciI7czo1OiJzdGF0ZSI7czo0MDoiUTZpNFptdkhOV0JTcWRPc3ZLUEFiZHVwZVE3bVA5Ulhua09LdFMzZCI7fQ==',1691886176),('OMoBuJYFnzJ2tjGDJ8aOXYj55UOufx36M5DBQtlP',69,'156.199.232.186','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36 OPR/99.0.0.0','YTo1OntzOjY6Il90b2tlbiI7czo0MDoiYkNCcnppZktkcUZlZDZ1ZWNlM0ozV2J5enpkOFBtTjFkWGdHM1plciI7czo2OiJsb2NhbGUiO3M6MjoiYXIiO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjI1OiJodHRwczovL25hdGlvbmFsLWcuY29tL2FyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6Njk7fQ==',1691885428),('QTHx8pkJGe5pSsrPU8w24lrxMoeNrFeDSr8vcJgu',NULL,'136.243.111.17','SiteCheckerBotCrawler/1.0 (+http://sitechecker.pro)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZHY3bkpEa3dWMFFiNlN1ZDBGc3p2N2w1UGZ3SFhKOXNiTjZoaVRqYiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vbmF0aW9uYWwtZy5jb20iO319',1691885640),('r79wy2fYTXcjjy0h8zohmo3NiCIl0ioiKP5mPvo8',NULL,'136.243.111.17','SiteCheckerBotCrawler/1.0 (+http://sitechecker.pro)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZ3NrcXc3dlRNSXZRWm9PU1ROQzRsM3cwU2x3ZFdaU0MxNUN1dWNpMCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vbmF0aW9uYWwtZy5jb20iO319',1691884256),('SMUreEcaECKYmXqnMLMYLZbdFiEdf112harnd3S9',NULL,'136.243.111.17','SiteCheckerBotCrawler/1.0 (+http://sitechecker.pro)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWUVqV1dDbU5WdjVPU0Z5UDE3bFRIV0ZYZnlqZnF0eUF2VlZudEZFTiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vbmF0aW9uYWwtZy5jb20iO319',1691885177),('XkySzlC5SuZxLlpUdS18n39mFFByjXgZFh8kX3RG',69,'156.199.232.186','Mozilla/5.0 (iPhone; CPU iPhone OS 16_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.5.2 Mobile/15E148 Safari/604.1','YTo1OntzOjY6Il90b2tlbiI7czo0MDoidFh0SnQ4d2EzSnVsOFhxWjVLRzNjcHhYSWQ2Q1FiWEs1dUtTaW9xaSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHBzOi8vbmF0aW9uYWwtZy5jb20vYXIiO31zOjY6ImxvY2FsZSI7czoyOiJhciI7czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6Njk7fQ==',1691885314),('yuJFqhm3StbXAmAkSggBZLPO0TUd9bS2NEWZGYeq',NULL,'136.243.111.17','SiteCheckerBotCrawler/1.0 (+http://sitechecker.pro)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiQm5aTm8zR1ozdlRKNHJ3eHpsQkNrQWZkOVVhbzJxekluRjJWTkoxWSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vbmF0aW9uYWwtZy5jb20iO319',1691884716);

--
-- Table structure for table `short_terms`
--

CREATE TABLE `short_terms` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `Ticket` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `AccountNo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `Action` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `FirstSymbol` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `PriceCurrent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `PriceOpen` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `PriceSL` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `PriceTP` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `Profit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `SecondSymbol` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `Symbol` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `Volume` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT 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 `short_terms`
--


--
-- Table structure for table `slider_translations`
--

CREATE TABLE `slider_translations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slider_id` int unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slider_translations_slider_id_locale_unique` (`slider_id`,`locale`),
  KEY `slider_translations_locale_index` (`locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `slider_translations`
--


--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_number` int DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `link` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` (`id`, `image`, `type`, `id_number`, `status`, `created_at`, `updated_at`, `link`) VALUES (7,'777803-337838a900d2589572311fb13f0af5d1.png','ads',NULL,'1','2024-12-05 15:42:11','2025-01-22 23:29:23',NULL),(11,'494323-an-11.avif',NULL,NULL,'1','2025-01-29 16:28:55','2025-01-29 16:28:55',NULL),(12,'989716-an-12.avif',NULL,NULL,'1','2025-01-29 16:29:07','2025-01-29 16:29:07',NULL),(13,'149315-an-13.avif',NULL,NULL,'1','2025-01-29 16:29:17','2025-01-29 16:29:17',NULL),(14,'626103-an-14.avif',NULL,NULL,'1','2025-01-29 16:29:28','2025-01-29 16:29:28',NULL);

--
-- Table structure for table `tagers`
--

CREATE TABLE `tagers` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `instagram_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `banners` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tagers_user_id_foreign` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tagers`
--

INSERT INTO `tagers` (`id`, `user_id`, `instagram_link`, `banners`, `created_at`, `updated_at`) VALUES (1,88,'https://offerapp.topapp-kw.com/ar/cpanel/admin/tagers/create','[\"2024-10-29-footer-logo.png\"]','2024-10-29 22:25:20','2024-10-29 22:25:20'),(15,120,NULL,'[\"2024-12-08-a11.jpg\",\"2024-12-08-a12.jpg\",\"2024-12-08-a13.jpg\",\"2024-12-08-a14.jpg\"]','2024-12-07 22:59:29','2024-12-08 12:36:49'),(16,121,NULL,'[\"2024-12-08-a1.jpg\",\"2024-12-08-a2.jpg\",\"2024-12-08-a3.jpg\",\"2024-12-08-a4.jpg\",\"2024-12-08-a5.jpg\",\"2024-12-08-a6.jpg\"]','2024-12-07 23:02:24','2024-12-08 12:41:20');

--
-- Table structure for table `topic_subscripts`
--

CREATE TABLE `topic_subscripts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `topics_id` int unsigned DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `symobleName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `topic_subscripts_topics_id_foreign` (`topics_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `topic_subscripts`
--


--
-- Table structure for table `topics`
--

CREATE TABLE `topics` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `token` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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 `topics`
--


--
-- Table structure for table `user_addresses`
--

CREATE TABLE `user_addresses` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `governments_id` int unsigned DEFAULT NULL,
  `region_id` int unsigned NOT NULL,
  `block` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Street_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Apartment_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `floor_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `flat_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `secondPhone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `checked` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lat` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `long` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gada` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mac_address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_addresses_user_id_foreign` (`user_id`),
  KEY `user_addresses_governments_id_foreign` (`governments_id`),
  KEY `user_addresses_region_id_foreign` (`region_id`)
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_addresses`
--

INSERT INTO `user_addresses` (`id`, `user_id`, `governments_id`, `region_id`, `block`, `Street_number`, `Apartment_number`, `floor_number`, `house_number`, `flat_number`, `type`, `user_name`, `phone`, `secondPhone`, `email`, `created_at`, `updated_at`, `checked`, `lat`, `long`, `gada`, `note`, `address`, `mac_address`) VALUES (7,0,9,58,'asd','ads','asd',NULL,NULL,NULL,'home',NULL,NULL,NULL,NULL,'2023-02-22 00:25:31','2023-02-22 00:25:31','true',NULL,NULL,NULL,'asdsad',NULL,'ISdstWUMXQ7dofE3uGCrlP6Y35BbX5pjVP0gz8IS'),(8,0,8,23,'Yy','Uu','Uu',NULL,NULL,NULL,'home',NULL,NULL,NULL,NULL,'2023-02-22 01:44:28','2023-02-22 01:44:28','true','29.30650394154814','47.72740619698798',NULL,NULL,NULL,'Kb07T5EeyzGsl8JmPmV4rWUcUisIFqC9Ygc1g4Hn'),(9,0,8,33,'Tt','Cf','Fd',NULL,NULL,NULL,'home',NULL,NULL,NULL,NULL,'2023-02-28 05:01:34','2023-02-28 05:01:34','true',NULL,NULL,'Cdd','Ff',NULL,'Er1Fi99tiCsamkBB2IDeGAs0cBEOvUu72kbOoMRK'),(10,1,10,19,'323','23434','234','3','234','4','home',NULL,'30550228','51007138',NULL,'2023-05-06 14:37:49','2023-08-13 16:50:37','false','29.3620534700822','47.98345710298158','324','23423',NULL,NULL),(11,0,NULL,19,'323','23','232',NULL,NULL,NULL,'home',NULL,NULL,NULL,NULL,'2023-05-06 19:07:08','2023-05-06 20:22:04','false',NULL,NULL,'232','2323',NULL,'cRhBCMuvMpZA9kJt5j6EOJyCgNVouFP5qWkNCkXt'),(12,0,12,124,'sdfsdf','sdfsdfsdf','sdfsdf','sdf','sdf',NULL,'hotel',NULL,'55022830','51007138',NULL,'2023-05-06 19:46:56','2023-05-06 20:22:04','false','29.362539699927922','47.98432613870241','sdf','sdfsdf',NULL,'cRhBCMuvMpZA9kJt5j6EOJyCgNVouFP5qWkNCkXt'),(13,0,10,83,'323','r23r','23r23r','2r3','23r',NULL,'hotel',NULL,'51007138','55022830',NULL,'2023-05-06 19:48:07','2023-05-06 20:22:04','true','29.362539699927922','47.98432613870241','23r2r','r2323r32',NULL,'cRhBCMuvMpZA9kJt5j6EOJyCgNVouFP5qWkNCkXt'),(14,0,11,115,'9','944','41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-05-06 21:08:06','2023-05-06 21:08:24','false','29.36804031793844','47.98057380182752','98',NULL,NULL,'GfkVnYbiUpc29jWrcrp1suIG0EQ7tdR5NXIfu2NT'),(15,0,11,115,'9','944','41',NULL,NULL,NULL,NULL,NULL,'55665287','66556655',NULL,'2023-05-06 21:08:24','2023-05-06 21:08:35','true','29.36804031793844','47.98057380182752','98',NULL,NULL,'GfkVnYbiUpc29jWrcrp1suIG0EQ7tdR5NXIfu2NT'),(16,0,9,54,'wq','21312','12312','123','123',NULL,'hotel',NULL,'32423424',NULL,NULL,'2023-05-08 10:22:28','2023-05-08 10:22:43','true','29.36249294715902','47.98326398393251','123','123','9X6M+X8 مدينة الكويت، الكويت‎','mskHSei66Pxpx727gs2lY2NQCKNxXjlK9wOxr5Zx'),(17,0,10,96,'9','944','41',NULL,NULL,NULL,NULL,NULL,'55665287',NULL,NULL,'2023-05-08 21:34:54','2023-05-08 21:34:54','true',NULL,NULL,NULL,NULL,NULL,'Jf58GeOrD19kEEaplKfXVCxNBLGqxjEqCuL3z3dZ'),(18,0,11,102,'9','994','41',NULL,NULL,NULL,NULL,NULL,'55667788',NULL,NULL,'2023-05-08 21:45:35','2023-05-08 21:48:01','true',NULL,NULL,NULL,NULL,NULL,'2cjzvEyUB59Uf3KxyobLVrNMyHYkRmdAHpOo4X9j'),(19,0,8,19,'9','944','41','1','2',NULL,'home',NULL,NULL,NULL,NULL,'2023-05-08 23:18:23','2023-05-08 23:18:34','true',NULL,NULL,NULL,NULL,NULL,'xZZTBJUxKZZlcxGbzVxv6rCOIHePsONIFkJO8ALo'),(20,25,9,53,'324','sdsa','234','234','234234',NULL,'hotel',NULL,'55022830',NULL,NULL,'2023-05-09 19:58:53','2023-05-09 21:01:40','false','29.362371389859437','47.98395062944032','324','234',NULL,NULL),(21,25,9,53,'we32','34324324','242344','234324','24234',NULL,'hotel',NULL,'5423424',NULL,NULL,'2023-05-09 21:01:40','2023-05-09 21:02:22','true','29.362455544928448','47.9834249164734','34234234','24234234242234','9X6M+X9 مدينة الكويت، الكويت‎',NULL),(22,27,8,24,'sdf','sdfs','sdfsd','f','sdf',NULL,'home',NULL,'55022830',NULL,NULL,'2023-05-13 17:30:33','2023-05-13 17:30:33','true',NULL,NULL,'dfs','sdf',NULL,NULL),(23,28,9,53,'asd','asd','asd','asd','adsas',NULL,'home',NULL,'51007138',NULL,NULL,'2023-05-14 22:45:50','2023-05-14 22:45:58','true','29.36263320540135','47.98345710298158','asd','asdasd','9X7M+39 Kuwait City, Kuwait',NULL),(24,0,8,20,'2','2',NULL,NULL,NULL,NULL,'hotel',NULL,NULL,NULL,NULL,'2023-05-17 11:55:52','2023-05-17 11:55:52','true',NULL,NULL,'32',NULL,NULL,'TH8LMM4j7yOBxISknxshC3ixFWCsxv3uwBNRAHHx'),(25,0,8,20,'9','966','66',NULL,NULL,NULL,NULL,NULL,'555666',NULL,NULL,'2023-05-23 06:21:32','2023-05-23 06:23:22','true',NULL,NULL,'999',NULL,NULL,'A9GVboeUTZ6CKPHhRNooBoz6Bm8e3S1AnHcV4q1u'),(26,44,8,23,'9','55','41',NULL,NULL,NULL,'home',NULL,'55665287',NULL,NULL,'2023-05-23 06:35:03','2023-05-23 06:35:03','true','29.36804104108808','47.980590394639194','31',NULL,NULL,NULL),(27,0,9,52,'sdf','sdfsdf','sdf','sdf','sdf',NULL,'home',NULL,'55022830',NULL,NULL,'2023-05-23 20:44:02','2023-05-23 20:44:02','true','29.362689308644185','47.982856288162246','sdfsd','sdfsdf',NULL,'nyE1qAQPOhJfvoc15n0g7sOSKcirTDZ5WSxL7U2d'),(28,0,9,52,'w','32','23','324','32423',NULL,'home',NULL,'55022830','51007138',NULL,'2023-05-24 03:53:33','2023-05-27 23:34:27','true','29.36201606769021','47.982148184982314','23','234',NULL,'50ogGG9merSQVmbWAJtlI3pPMK9jM4H1jQidaZaL'),(29,39,10,82,'ads','qwe','qwe','qwe','qwe',NULL,'home',NULL,'510017138',NULL,NULL,'2023-05-24 06:42:51','2023-05-24 06:42:51','true',NULL,NULL,'qwe','qewqe',NULL,NULL),(30,45,11,115,'2','2','19','2','2',NULL,'building',NULL,'50890840',NULL,NULL,'2023-05-25 07:56:54','2023-05-30 06:05:26','true','29.33425035394212','47.70686770936586',NULL,'أمام البيت محول','26 شارع 6، الجهراء،، Al Jahra, Kuwait',NULL),(31,0,9,76,'00','99','41','1',NULL,NULL,'hotel',NULL,NULL,NULL,NULL,'2023-05-28 03:44:20','2023-05-28 14:48:37','true',NULL,NULL,'9',NULL,NULL,'xXTEDdNLrQ6O76LJpVE93JiEBTGi1sp6ILO2zfxA'),(32,11,9,54,'qwd','qwd','qdw','qdw','qdw',NULL,'hotel',NULL,'55022830',NULL,NULL,'2023-05-28 20:44:36','2023-05-28 20:44:36','true','29.36219372892978','47.98348928948976','qwd','qwd',NULL,NULL),(33,0,8,19,'999','٩٩99','٩٩','٩','٩٩',NULL,'home',NULL,'55665287',NULL,NULL,'2023-05-29 23:14:16','2023-06-11 03:17:42','true',NULL,NULL,'٩','٩٩',NULL,'rZ2pYwBe6ZeN5owwYtV5GhPvf32JJDwUTzkCupWZ'),(34,1,10,19,'8','8','18','1','1',NULL,'home',NULL,'87654765','55665287',NULL,'2023-05-29 23:37:56','2023-08-22 18:37:49','true',NULL,NULL,NULL,NULL,NULL,NULL),(35,47,8,33,'klj','k','kl','lk',NULL,NULL,NULL,NULL,'55665287',NULL,NULL,'2023-06-01 02:28:59','2023-06-01 02:29:24','true',NULL,NULL,'kj',NULL,NULL,NULL),(36,0,8,24,'9','944','41',NULL,NULL,NULL,NULL,NULL,'55665287',NULL,NULL,'2023-06-01 03:02:08','2023-06-01 03:02:42','true',NULL,NULL,'9',NULL,NULL,'U9v907ZSCgbh52zcWSyo9XFY3ZbW1IuW76A6s5wJ'),(37,0,9,55,'fdddddd','Gharbiyah Elmahala-Elkubra','sddddddddddddd','dddsdddddddddd','dfffffffffq',NULL,'home',NULL,'+201092485755',NULL,NULL,'2023-06-02 05:44:15','2023-06-02 05:44:15','true','30.015488','31.2147968','ddddddddddddddddddd','sdddddddddddddddddd',NULL,'waUuD3JwBAkiCRkVcl55rezC1DrK3s8oIVcQPSAp'),(38,0,8,20,'323','324','234','234','342',NULL,'hotel',NULL,'55022830',NULL,NULL,'2023-06-04 16:32:42','2023-06-04 16:32:42','true',NULL,NULL,'234','23',NULL,'Fkg9TCovNYrYHVUvsYVeh7z88bzsHv43fPk64tqp'),(39,0,8,23,'9','933','90','O',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-06-05 02:55:36','2023-06-05 02:55:36','true',NULL,NULL,'10',NULL,NULL,'mTSWuheqqMmffwaW3H6USaxW7RQhHtRbLCf4ZaYL'),(40,0,8,25,'9','O',NULL,NULL,NULL,NULL,'building',NULL,NULL,NULL,NULL,'2023-06-05 04:55:41','2023-06-05 04:55:41','true',NULL,NULL,'O',NULL,NULL,'TZdQB3DUCSo5Py4u2IdIEcnxP27eVrDbSGujbVra'),(41,0,10,81,'sad','asdasd','asdasd','asdasd','asdas',NULL,'home',NULL,'55022830',NULL,NULL,'2023-06-06 18:43:07','2023-06-06 18:43:07','true',NULL,NULL,'asdasd','asd',NULL,'nMoYjvX0tqXWgTgxVudPGfAxUmnhiD6dRpDe3Ftm'),(42,0,10,83,'٢','٢','٢','2','2',NULL,'home',NULL,'50890395',NULL,NULL,'2023-06-08 20:42:59','2023-06-08 20:42:59','true',NULL,NULL,'٢',NULL,NULL,'2urHCmjtgJq28qJZzK0ljTJtUwuAdrhfXRku51TU'),(43,0,8,23,'9','99','99',NULL,NULL,NULL,'work',NULL,'55665566',NULL,NULL,'2023-06-10 23:57:40','2023-06-10 23:57:40','true',NULL,NULL,'9',NULL,NULL,'pJISH3ByAhygT1wlqXz3JuQgGIosuBQ7x5KtmhWd'),(44,0,8,25,'9','99','99',NULL,NULL,NULL,'work',NULL,'5566555555',NULL,NULL,'2023-06-11 00:01:07','2023-06-11 00:01:07','true',NULL,NULL,'99',NULL,NULL,'9Dy63x7gKiyyJ6kdhh1IYtijaa18V2ziqw3WjyTf'),(45,49,11,115,'3','3',NULL,NULL,NULL,NULL,NULL,NULL,'56505135',NULL,NULL,'2023-06-11 03:05:15','2023-09-05 20:04:53','false',NULL,NULL,'3',NULL,NULL,NULL),(46,0,11,117,'2','2',NULL,NULL,NULL,NULL,NULL,NULL,'55555555',NULL,NULL,'2023-06-11 03:13:44','2023-06-11 03:13:44','true',NULL,NULL,'2',NULL,NULL,'h9GbyCJcFTk6eG3oCLJ0NSkp2pjQ5JwpfVp4ZuQk'),(47,0,11,105,'٩','٩','٩٠',NULL,NULL,NULL,'work',NULL,'55665287',NULL,NULL,'2023-06-11 03:15:26','2023-06-11 03:15:26','true',NULL,NULL,'٠٩٩',NULL,NULL,'YSDSuCgrwsm48MzsAKxgnVujjjDoux6r3Dk0ABFT'),(48,0,8,23,'99','9',NULL,NULL,NULL,NULL,NULL,NULL,'5566527666',NULL,NULL,'2023-06-11 03:22:33','2023-06-11 03:22:33','true',NULL,NULL,'9',NULL,NULL,'OH2ss7ArdPtZAsFO6rslL6lYi8wwckFtIAHeSSB4'),(49,0,10,87,'1','1',NULL,NULL,NULL,NULL,NULL,NULL,'56505135','1223345678908765',NULL,'2023-06-11 03:23:52','2023-09-05 19:09:06','true',NULL,NULL,'1',NULL,NULL,'4kEfLuZcHA7JdAiuJ4dMqfDNVKEls4ts1RbdAmrN'),(50,0,8,20,'99','9',NULL,NULL,NULL,NULL,NULL,NULL,'55665287',NULL,NULL,'2023-06-13 07:55:25','2023-06-13 07:55:25','true',NULL,NULL,'9','9',NULL,'dMnZ21GZXzZUjTGVz81c5IAKtPkB8CRZ89byZDTg'),(51,0,8,23,'9','99','61','77','41',NULL,'home',NULL,NULL,NULL,NULL,'2023-06-15 00:28:16','2023-06-15 00:28:23','false',NULL,NULL,'99',NULL,NULL,'hRPIxdA2Opr8lvaMMHT1lukRklGTsOPHIERqTNH1'),(52,0,8,23,'9','99','61','77','41',NULL,'home',NULL,'55665287',NULL,NULL,'2023-06-15 00:28:23','2023-06-15 00:28:23','true',NULL,NULL,'99',NULL,NULL,'hRPIxdA2Opr8lvaMMHT1lukRklGTsOPHIERqTNH1'),(53,0,9,64,'1','1',NULL,NULL,NULL,NULL,NULL,NULL,'12345678',NULL,NULL,'2023-06-15 00:39:51','2023-06-15 00:39:51','true',NULL,NULL,'11','1cdsc',NULL,'aDstTbCmUJKxZZ7bVquXCC73CoxPwWAdRUAe3ZRJ'),(54,0,10,89,'Gg','Hn','Nb','Jn','Bb',NULL,'home',NULL,'55022830',NULL,NULL,'2023-06-15 05:06:20','2023-06-15 05:06:20','true',NULL,NULL,'Jnn','Bb',NULL,'hmPkThg5lubi61OvMmIZSVKwB0bOyE6ePvi5wPow'),(55,0,8,23,'9',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'55665287',NULL,NULL,'2023-06-17 22:08:52','2023-06-17 22:08:52','true',NULL,NULL,'9',NULL,NULL,'k472flQ8nXKz71G5i4rkkHGVEXKsOMjbSMq0KdxF'),(56,0,8,19,'3','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-06-19 02:48:00','2023-06-19 02:48:00','true',NULL,NULL,'1','1',NULL,'ihZUooCHZazl0aFZF66GqRbJLjUF1JrTdKbRukjE'),(57,0,8,20,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-06-19 02:52:41','2023-06-19 02:52:41','true','30.045081679273274','31.491077653388',NULL,NULL,NULL,'nEjqWqHXeFJm9HHyCBx5WxDEQMl4UefdZIQdIMMB'),(58,0,11,115,'2','212','19','2','2',NULL,'home',NULL,NULL,NULL,NULL,'2023-06-19 03:08:15','2023-06-19 03:08:15','true',NULL,NULL,'-','الاتصال قبل الوصول',NULL,'1Bg8pNQY06Hk3oy6CGJaEJNCSw2lzNIfAaCUHY0g'),(59,0,11,105,'1','1','1',NULL,NULL,NULL,'work',NULL,'11111111',NULL,NULL,'2023-06-19 23:24:47','2023-06-19 23:24:47','true',NULL,NULL,'1',NULL,NULL,'QqNoyplgCVuDYN3PhXBUPXgReEqKiPinhsZe0jsS'),(60,0,10,19,'23','232','سيبسيب','يسبسيب','سيبسيب',NULL,'hospital',NULL,'51007138',NULL,NULL,'2023-06-20 07:08:04','2023-06-22 03:56:46','false',NULL,NULL,'يبسبس','سيبسيبسي',NULL,'lbwB8SNKBvjCU9TDSp8qSC01ka593QTahYjbykRn'),(61,0,9,53,'1','1',NULL,NULL,NULL,NULL,NULL,NULL,'11111111',NULL,NULL,'2023-06-20 22:56:51','2023-06-20 22:56:51','true',NULL,NULL,'1','1',NULL,'FlUQxBFMWXZ5iIcmiuJeamhRvaHP4W1CNmUwU6KF'),(62,0,8,22,'9','9',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-06-21 00:32:44','2023-06-21 00:32:45','true',NULL,NULL,'9','O',NULL,'6t0PfDGPACzJ6LI3hHjCGom5gXKdKKyjkdUifsO0'),(63,0,10,84,'23','e32','2323','232','wqdq',NULL,'home',NULL,'51007138',NULL,NULL,'2023-06-21 01:48:57','2023-06-21 01:48:57','true',NULL,NULL,'232','qwdqwdqwd',NULL,'lbwB8SNKBvjCU9TDSp8qSC01ka593QTahYjbykRn'),(64,1,8,23,'3','3','3',NULL,NULL,NULL,'work',NULL,NULL,NULL,NULL,'2023-06-21 02:15:23','2023-08-13 16:50:37','false',NULL,NULL,NULL,NULL,NULL,NULL),(65,0,8,19,'9','9',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-06-21 02:27:08','2023-06-21 02:28:25','false',NULL,NULL,NULL,NULL,NULL,'PkTPNYWP6CrSajD5K9oGCwnU8Hfu43pZouTD7t3x'),(66,0,8,19,'9','9','41',NULL,NULL,NULL,'work',NULL,NULL,NULL,NULL,'2023-06-21 02:28:13','2023-06-21 02:28:25','false',NULL,NULL,NULL,NULL,NULL,'PkTPNYWP6CrSajD5K9oGCwnU8Hfu43pZouTD7t3x'),(67,0,8,19,'9','9','41',NULL,NULL,NULL,'work',NULL,'55665287',NULL,NULL,'2023-06-21 02:28:25','2023-06-21 02:28:25','true',NULL,NULL,NULL,NULL,NULL,'PkTPNYWP6CrSajD5K9oGCwnU8Hfu43pZouTD7t3x'),(68,0,9,72,'1','4',NULL,NULL,NULL,NULL,NULL,NULL,'96633521',NULL,NULL,'2023-06-21 05:22:50','2023-06-21 05:22:50','true',NULL,NULL,'-','رقم المنزل 39',NULL,'jVZf0JLR2KHvNUDVx2u8jAtVnwasyiPEVrecAeyM'),(69,0,8,19,'1','1','1','1','1',NULL,'home',NULL,'1111111',NULL,NULL,'2023-06-21 06:58:24','2023-06-21 06:58:24','true',NULL,NULL,'1',NULL,NULL,'ql7Uz9QsddMQJak3OwvZV2zP32QWWkC5EBMr6yQJ'),(70,0,8,21,'9','99','43','41','55',NULL,'hospital',NULL,'55665287',NULL,NULL,'2023-06-21 18:32:47','2023-06-21 18:36:41','true',NULL,NULL,'9',NULL,NULL,'ZE13I7VflkgIkkLCX0UmYX6Dz3L0HLoP7tJ0eBJV'),(71,0,8,21,'9','944','56','5','9',NULL,'hospital',NULL,'55665287',NULL,NULL,'2023-06-21 18:47:06','2023-06-21 18:47:06','true','29.30640173783406','47.7270929396093','944',NULL,NULL,'DFSi750jRuqSwgxULGxlc9mWQKqvyCCqZ6BtbpWq'),(72,57,8,20,'9','0','0','٩','9',NULL,'home',NULL,'55665287',NULL,NULL,'2023-06-22 03:16:43','2023-08-22 18:46:04','true',NULL,NULL,'0','0',NULL,NULL),(73,0,NULL,19,'9','9','41','1','31',NULL,'hospital',NULL,'55665287',NULL,NULL,'2023-06-22 07:06:23','2023-06-22 07:06:23','true',NULL,NULL,NULL,NULL,NULL,'ZuMsrZwIN4LgPTwmBuGEs6POJVumN2iCqcL77pBQ'),(74,0,NULL,34,'9','p','p','p','p',NULL,'hospital',NULL,'55665287',NULL,NULL,'2023-06-22 21:47:17','2023-06-22 21:47:17','true',NULL,NULL,'p','p',NULL,'pKSFnHIvIfJlpujekPvrWpRlGBSzejBHlVYkzFp3'),(75,0,NULL,28,'9','9','41','6','6-',NULL,'home',NULL,'55665288',NULL,NULL,'2023-06-26 19:50:38','2023-06-26 19:50:38','true',NULL,NULL,'7',NULL,NULL,'rP2RxCSE5LnVJI8DvjRrW3Y1ofl33aht2q8bQERE'),(76,0,NULL,19,'55','jksbca','kjdbskc','kjbdsd','kjbsc',NULL,'home',NULL,'23476262',NULL,NULL,'2023-07-26 01:06:43','2023-07-26 01:06:43','true',NULL,NULL,'kjbxkc',NULL,NULL,'LEumMVX1DNXJv4BHAV2GI4OtTsfCZtUgaVaWJz2z'),(77,0,NULL,20,'9','9','9','9','99',NULL,'home',NULL,'55665287',NULL,NULL,'2023-07-30 00:28:23','2023-07-30 00:28:23','true',NULL,NULL,'99','98',NULL,'96UAPJJFKxlJuwtzRvY9SlfnzHK07XXeTYXPHSph'),(78,0,NULL,21,'zzxxz','zxzzx','dsc',NULL,NULL,NULL,'work',NULL,'51887656','51007138',NULL,'2023-08-06 04:44:59','2023-08-16 10:32:22','true',NULL,NULL,'cs','dscdw',NULL,'rndah49JnJI1yNi4nv1Bjtpf8QN8kn9Akp3KO9B9'),(79,0,NULL,25,'4','gg','9','9','g',NULL,'home',NULL,'55665287',NULL,NULL,'2023-08-10 23:12:39','2023-08-10 23:12:39','true',NULL,NULL,'9','9',NULL,'ICyxziS94h4RGCubJDd1fvUSkWOgOkSdUAg737SI'),(80,80,NULL,21,'9','9','9','9','9',NULL,'home',NULL,'55665287',NULL,NULL,'2023-08-14 00:10:26','2023-08-14 00:10:26','true',NULL,NULL,'9','9',NULL,NULL),(81,57,NULL,20,'66','6','6','6','6',NULL,'hospital',NULL,'55665287',NULL,NULL,'2023-08-15 01:24:37','2023-08-22 18:41:50','false',NULL,NULL,'6','6',NULL,NULL),(82,0,NULL,19,'9','99','U','U','I',NULL,'home',NULL,'55665287',NULL,NULL,'2023-08-15 02:30:31','2023-08-15 02:30:31','true',NULL,NULL,'7',NULL,NULL,'ZkjLET9tQvoZAfpLWV3zF4ywvMO75inGejSDOMFi'),(83,0,NULL,19,'2','212','19','2','2',NULL,'home',NULL,'50890840',NULL,NULL,'2023-08-15 08:39:31','2023-08-15 08:41:48','true',NULL,NULL,'-','لا يطرق الجرس',NULL,'lFqGvpJ3oXqr6pXS65xyidVb73CcTd5eR9DXPgex'),(84,0,NULL,19,'4','4','4',NULL,NULL,NULL,'home',NULL,'45544444',NULL,NULL,'2023-08-15 16:45:12','2023-08-15 16:45:12','true',NULL,NULL,NULL,NULL,NULL,'h2pfBfdaavKwF7FRi0YgiO5Ys9MwpWE9pLew0p0Y'),(85,0,NULL,21,'9','٩','٩','٩٩٩٩','٩',NULL,'home',NULL,'55665287',NULL,NULL,'2023-08-17 18:25:27','2023-08-17 18:25:27','true',NULL,NULL,'٩','٩',NULL,'4oLvEbJ2I4sAhXwFf4SyzIJ2TBCHChfiO3fg7qyw'),(86,0,NULL,21,'dg','fdg','dfg','fdg','fdgf',NULL,'home',NULL,'55022830',NULL,NULL,'2023-08-18 09:15:21','2023-08-18 09:15:21','true',NULL,NULL,'dfg',NULL,NULL,'EpsDGku9PKqZvcT9dKWvhc4vJdwgPGZjXtVrlIAy'),(87,0,NULL,23,'9','9','51',NULL,NULL,NULL,'home',NULL,'55665287',NULL,NULL,'2023-08-20 13:19:21','2023-08-20 13:19:21','true',NULL,NULL,'9',NULL,NULL,'RLSliGcmgAc9PCsSkZWpdbYSkFB6aPFjzcjfG2Oh'),(88,0,NULL,22,'Jsj','Hbb','Bbb','Bbb','Bbb',NULL,'home',NULL,'51007138',NULL,NULL,'2023-08-22 00:08:50','2023-08-22 00:08:50','true',NULL,NULL,'Bb','Nnbnsn',NULL,'gvXyvkwIcyHMGICZjI8nUrhpTYW1I5G3MmCbqzBg'),(89,0,NULL,19,'9','9','9','9','9',NULL,'home',NULL,'55665287',NULL,NULL,'2023-08-22 17:02:40','2023-08-22 17:02:40','true',NULL,NULL,'9','9',NULL,'xBLxByHh7yZJqrrJxPcM0TJhs3FLYhaMbqiwVTM9'),(90,0,NULL,19,'4','545','454','54','54',NULL,'home',NULL,'10617562',NULL,NULL,'2023-08-22 18:00:19','2023-08-22 18:00:19','true',NULL,NULL,'45',NULL,NULL,'tpr3gkE8lpLrykdqetaxHeMl00DI746Q12ND1R3d'),(91,0,NULL,21,'9','9','9','9','9',NULL,'home',NULL,'55665287',NULL,NULL,'2023-08-22 18:45:05','2023-08-22 18:45:05','true',NULL,NULL,'9','9',NULL,'jJR2NdqEy9A02Qwu27cb5l8SfjCyfjoRG9FOmF15'),(92,82,NULL,112,'4','4','48','1','9',NULL,'home',NULL,'99450815','99450815',NULL,'2023-08-23 19:01:26','2023-08-23 21:52:25','true',NULL,NULL,NULL,NULL,NULL,NULL),(93,79,NULL,19,'4','4','4','g','g',NULL,'hospital',NULL,'56505136','01096475777',NULL,'2023-08-23 20:38:45','2023-08-23 22:32:08','false',NULL,NULL,NULL,NULL,NULL,NULL),(94,83,NULL,25,'3','3','3',NULL,NULL,NULL,'home',NULL,'50329745',NULL,NULL,'2023-08-23 22:09:05','2023-08-23 22:09:05','true',NULL,NULL,NULL,NULL,NULL,NULL),(95,79,NULL,24,'3','3','hospital',NULL,NULL,NULL,'hospital',NULL,'56505135','56505135',NULL,'2023-08-23 22:29:34','2023-08-28 23:19:43','true',NULL,NULL,NULL,NULL,NULL,NULL),(96,0,NULL,23,'5','5','5',NULL,NULL,NULL,'home',NULL,'56505135',NULL,NULL,'2023-08-24 20:30:29','2023-08-24 20:30:33','false',NULL,NULL,NULL,NULL,NULL,'8RxsL4XqefImdMpZbZRYGQGoUSwlzRTVbWtsOo4C'),(97,0,NULL,23,'5','5','5',NULL,NULL,NULL,'home',NULL,'56505135',NULL,NULL,'2023-08-24 20:30:31','2023-08-24 20:30:33','false',NULL,NULL,NULL,NULL,NULL,'8RxsL4XqefImdMpZbZRYGQGoUSwlzRTVbWtsOo4C'),(98,0,NULL,23,'5','5','5',NULL,NULL,NULL,'home',NULL,'56505135',NULL,NULL,'2023-08-24 20:30:33','2023-08-24 20:30:33','true',NULL,NULL,NULL,NULL,NULL,'8RxsL4XqefImdMpZbZRYGQGoUSwlzRTVbWtsOo4C'),(99,0,NULL,23,'4','44','4',NULL,NULL,NULL,'home',NULL,'56505135',NULL,NULL,'2023-08-29 23:04:28','2023-08-29 23:04:28','true',NULL,NULL,NULL,NULL,NULL,'p7IZNl79j0adOhki3iJqI5tJ85b5RMBmOvbQxtzh'),(100,84,NULL,20,'fdddddd','المنصورة','sddddddddddddd','dddddddddddd','ddddddddddddd',NULL,'home',NULL,'01024517',NULL,NULL,'2023-09-02 22:44:43','2023-09-02 22:44:43','true',NULL,NULL,'fgggggggggdf','asasas',NULL,NULL),(101,85,NULL,41,'2','2','27',NULL,NULL,NULL,'home',NULL,'51222726',NULL,NULL,'2023-09-03 18:06:02','2023-09-03 18:06:02','true',NULL,NULL,NULL,NULL,NULL,NULL),(102,0,NULL,22,'Hh','Jk','Knn','Knn','Jnj',NULL,'home',NULL,'51007138',NULL,NULL,'2023-09-04 02:17:43','2023-09-04 02:17:43','true',NULL,NULL,'Kk','Nbb',NULL,'AbT47tt4nw4cTOicbAvowVWSIgtldphfllpoMnXN'),(103,0,NULL,20,'1','1','1',NULL,NULL,NULL,'home',NULL,'56505135',NULL,NULL,'2023-09-04 03:09:22','2023-09-04 03:09:22','true',NULL,NULL,NULL,NULL,NULL,'RcwOcjunvOJyZc9vbXl94mX1ognbSOo2AeUTYx8t'),(104,0,NULL,19,'9','944','41','41','41',NULL,'home',NULL,'55665287',NULL,NULL,'2023-09-04 03:09:45','2023-09-04 03:09:45','true',NULL,NULL,NULL,NULL,NULL,'rxTUNx7bZomNKyWxNYDqJ6lHSssCX937znRYv9VL'),(105,0,NULL,19,'4','4','4',NULL,NULL,NULL,'home',NULL,'50329745',NULL,NULL,'2023-09-04 21:21:10','2023-09-04 21:21:10','true',NULL,NULL,NULL,NULL,NULL,'4l7GwloNXtAIxuD3DQzCz9Eqc7ECYKXnzuNh54k0'),(106,0,NULL,27,'wqd','qwd','qdw','qwd','qwd',NULL,'home',NULL,'55022830',NULL,NULL,'2023-09-05 08:15:08','2023-09-05 08:15:08','true',NULL,NULL,'qdw','qwd',NULL,'848ZDoHKELC4yB4DYRYtfeejkOM4oai0mdp1EDQe'),(107,0,NULL,19,'9','9','9','9','9',NULL,'home',NULL,'55665287',NULL,NULL,'2023-09-05 18:50:08','2023-09-05 18:50:08','true',NULL,NULL,'9','9',NULL,'mGUkKwAlqcOzV6jP3LHHc1yoDk73hGfl4UUwSUFc'),(108,49,NULL,20,'5','5','5','5','5',NULL,'home',NULL,'56505135',NULL,NULL,'2023-09-05 19:37:35','2023-09-05 20:04:53','true',NULL,NULL,'5','5',NULL,NULL),(109,49,NULL,19,'5','4','2',NULL,NULL,NULL,'home',NULL,'56505135',NULL,NULL,'2023-09-05 19:38:35','2023-09-05 20:04:53','false',NULL,NULL,NULL,NULL,NULL,NULL),(110,49,NULL,19,'5','4','2',NULL,NULL,NULL,'home',NULL,'56505135',NULL,NULL,'2023-09-05 19:38:38','2023-09-05 20:04:53','false',NULL,NULL,NULL,NULL,NULL,NULL),(111,0,NULL,19,'adasd','asdasd','asdasd','asd','sdaasd',NULL,'home',NULL,'51007138',NULL,NULL,'2023-09-07 03:54:13','2023-09-07 03:54:13','true',NULL,NULL,'asd','asdasd',NULL,'eVsgGvHnsOVvpCPS3xI1UeEQO7dLqeSeTNa9i8ff');

--
-- Table structure for table `user_categories`
--

CREATE TABLE `user_categories` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `category_id` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_categories_user_id_foreign` (`user_id`),
  KEY `user_categories_category_id_foreign` (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_categories`
--

INSERT INTO `user_categories` (`id`, `user_id`, `category_id`, `created_at`, `updated_at`) VALUES (6,90,1,NULL,NULL),(7,94,2,NULL,NULL),(8,94,3,NULL,NULL),(9,103,1,NULL,NULL),(14,116,6,NULL,NULL),(15,104,1,NULL,NULL),(16,110,2,NULL,NULL),(17,111,2,NULL,NULL),(18,112,8,NULL,NULL),(19,113,8,NULL,NULL),(20,114,6,NULL,NULL),(21,115,6,NULL,NULL),(22,119,2,NULL,NULL),(23,120,2,NULL,NULL),(24,121,6,NULL,NULL),(25,122,11,NULL,NULL),(26,123,11,NULL,NULL);

--
-- Table structure for table `user_orders`
--

CREATE TABLE `user_orders` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `order_id` int unsigned DEFAULT NULL,
  `status` enum('wait','refused','accepted','shipped','complete') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_orders_user_id_foreign` (`user_id`),
  KEY `user_orders_order_id_foreign` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_orders`
--


--
-- Table structure for table `user_otherdatas`
--

CREATE TABLE `user_otherdatas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `input_key_ar` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `input_value_ar` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `input_key_en` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `input_value_en` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_otherdatas_product_id_foreign` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_otherdatas`
--

INSERT INTO `user_otherdatas` (`id`, `user_id`, `input_key_ar`, `input_value_ar`, `input_key_en`, `input_value_en`, `image`, `created_at`, `updated_at`) VALUES (1,89,'asdads',NULL,'asdasd',NULL,'2024-10-30-Screen Shot 2024-10-29 at 9.35.51 PM.png','2024-10-30 23:33:17','2024-10-30 23:33:17'),(2,89,'asdasd',NULL,'asdasd',NULL,'2024-10-30-Screen Shot 2024-10-29 at 9.35.51 PM.png','2024-10-30 23:33:17','2024-10-30 23:33:17'),(5,90,'asdads',NULL,'asdasd',NULL,'2024-10-30-Screen Shot 2024-10-29 at 9.35.51 PM (2).png','2024-10-30 23:56:32','2024-10-30 23:56:32'),(6,90,'asdasd',NULL,'asdasd',NULL,'2024-10-30-Screen Shot 2024-10-29 at 9.35.51 PM (2).png','2024-10-30 23:56:32','2024-10-30 23:56:32');

--
-- Table structure for table `user_products`
--

CREATE TABLE `user_products` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `product_id` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_products_user_id_foreign` (`user_id`),
  KEY `user_products_product_id_foreign` (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=158 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_products`
--

INSERT INTO `user_products` (`id`, `user_id`, `product_id`, `created_at`, `updated_at`) VALUES (91,45,48,NULL,NULL),(92,45,45,NULL,NULL),(94,11,15,NULL,NULL),(97,39,15,NULL,NULL),(101,1,15,NULL,NULL),(103,47,15,NULL,NULL),(104,47,16,NULL,NULL),(116,49,62,NULL,NULL),(117,49,285,NULL,NULL),(118,49,281,NULL,NULL),(119,49,82,NULL,NULL),(120,49,195,NULL,NULL),(121,49,150,NULL,NULL),(122,49,157,NULL,NULL),(131,82,62,NULL,NULL),(134,1,48,NULL,NULL),(142,79,62,NULL,NULL),(143,79,285,NULL,NULL),(144,79,48,NULL,NULL),(145,79,150,NULL,NULL),(146,79,157,NULL,NULL),(147,1,62,NULL,NULL),(148,82,20,NULL,NULL),(149,82,85,NULL,NULL),(150,85,62,NULL,NULL),(151,11,48,NULL,NULL),(152,49,321,NULL,NULL),(155,11,28,NULL,NULL),(156,11,76,NULL,NULL),(157,1,285,NULL,NULL);

--
-- Table structure for table `user_subscribes`
--

CREATE TABLE `user_subscribes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `start` date DEFAULT NULL,
  `end` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `price` decimal(8,3) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `user_subscribes`
--

INSERT INTO `user_subscribes` (`id`, `user_id`, `start`, `end`, `created_at`, `updated_at`, `price`) VALUES (5,93,'2024-11-13','2025-11-13','2024-11-13 23:20:47','2024-11-13 23:20:47',10.000),(6,99,'2024-11-25','2025-11-25','2024-11-25 15:49:00','2024-11-25 15:49:00',10.000),(7,100,'2024-11-25','2025-11-25','2024-11-25 16:31:38','2024-11-25 16:31:38',10.000),(8,102,'2024-11-25','2025-11-25','2024-11-25 18:14:38','2024-11-25 18:14:38',10.000),(9,101,'2024-11-25','2025-11-25','2024-11-25 23:46:55','2024-11-25 23:46:55',10.000),(10,106,'2024-12-05','2025-12-05','2024-12-05 12:36:46','2024-12-05 12:36:46',10.000),(11,107,'2024-12-05','2025-12-05','2024-12-05 13:23:09','2024-12-05 13:23:09',10.000),(12,108,'2024-12-05','2025-12-05','2024-12-05 13:33:31','2024-12-05 13:33:31',10.000),(13,109,'2024-12-05','2025-12-05','2024-12-05 13:40:41','2024-12-05 13:40:41',10.000),(14,124,'2024-12-14','2025-12-14','2024-12-14 00:58:01','2024-12-14 00:58:01',10.000);

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

CREATE TABLE `users` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content_ar` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `content_en` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `Working_hours_ar` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `Working_hours_en` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `address_ar` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `address_en` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '0',
  `unique_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `civil_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `activation_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `long` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_token` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `second_phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(111) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `count_offer` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=143 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `name`, `name_en`, `content_ar`, `content_en`, `Working_hours_ar`, `Working_hours_en`, `address_ar`, `address_en`, `email`, `phone`, `email_verified_at`, `password`, `status`, `unique_id`, `civil_id`, `activation_code`, `remember_token`, `created_at`, `updated_at`, `address`, `lat`, `long`, `image`, `device_token`, `second_phone`, `logo`, `count_offer`) VALUES (1,'admin',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'admin@admin.com','+965',NULL,'$2y$10$ubmzCnhrbqxfQC445TqTm.XsR3qW0dDEDyGJvnyI2SqboLhQTZ1kC',1,NULL,NULL,'89508',NULL,'2022-06-21 09:32:18','2024-11-11 23:54:11',NULL,NULL,NULL,NULL,NULL,'[]',NULL,NULL),(120,'كافية العرايس','كافية العرايس','<p>أقوى تعاون بالكويت بدقيقة بعد نجاح ٨ سنين من اول تعاون بين اثنين من اكبر الشركات الكويتية على منتج باع فوق الاثنين مليون حبة - اليوم صار فيه تعاون يديد</p>\r\n\r\n<p>أقوى تعاون بالكويت بدقيقة بعد نجاح ٨ سنين من اول تعاون بين اثنين من اكبر الشركات الكويتية على منتج باع فوق الاثنين مليون حبة - اليوم صار فيه تعاون يديد</p>','<p>أقوى تعاون بالكويت بدقيقة بعد نجاح ٨ سنين من اول تعاون بين اثنين من اكبر الشركات الكويتية على منتج باع فوق الاثنين مليون حبة - اليوم صار فيه تعاون يديد</p>\r\n\r\n<p>أقوى تعاون بالكويت بدقيقة بعد نجاح ٨ سنين من اول تعاون بين اثنين من اكبر الشركات الكويتية على منتج باع فوق الاثنين مليون حبة - اليوم صار فيه تعاون يديد</p>','34','24','كافية العرايس','كافية العرايس','asd2@asd.com','+9654523523',NULL,'$2y$10$2GpM2yVCC1fluvnbRFbB4.a/386Gs1YJMMeAu9kAR4BG83zuTYUQe',1,NULL,NULL,'742118',NULL,'2024-12-07 22:59:29','2024-12-08 13:41:03','82V5+H6Q مستوصف حولي، حولي، الكويت‎','29.34388706967736','48.00754619194338','2024-12-07-pexels-photo-2775827.jpg',NULL,'32452345','2024-12-08-logo_636800516461703732.jpg',3),(121,'فندق السعادة','Happiness Hotel','<p>أدخل تواريخك للاطلاع على أحدث الأسعار والعروض&nbsp;<em>لفنادق</em>&nbsp;الكويت &middot;&nbsp;<em>فندق</em>&nbsp;شاطئ الكوت &middot;&nbsp;<em>فندق</em>&nbsp;فورسيزونز الكويت في برج الشايع &middot; إيبيس السالمية الكويت &middot; أجنحة سراي برايم</p>','<p>أدخل تواريخك للاطلاع على أحدث الأسعار والعروض&nbsp;<em>لفنادق</em>&nbsp;الكويت &middot;&nbsp;<em>فندق</em>&nbsp;شاطئ الكوت &middot;&nbsp;<em>فندق</em>&nbsp;فورسيزونز الكويت في برج الشايع &middot; إيبيس السالمية الكويت &middot; أجنحة سراي برايم</p>','34','34','Happiness Hotel','Happiness Hotel','admin2@admin.com','+96543565346',NULL,'$2y$10$t7rgGnl37qc/40gx89vYUOcKwpKJ71NLFe7QBr70N/bzWoMfq.8Z.',1,NULL,NULL,'17400',NULL,'2024-12-07 23:02:24','2024-12-08 13:12:11','8XW6+V56، الكويت‎','29.34712882510865','47.96070124169923','2024-12-08-a4.jpg',NULL,'43563456','2024-12-08-Chowking_Logo_636544579008571553.jpg',3),(127,'samerasas',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'samerabdelmonem96@gmail.com','+96551007138',NULL,'$2y$10$jEy/WE4uLtFTPFegnlwfCOY8ZiPnYj22ymv6rTGVb0.6RP/.Cul3O',0,NULL,NULL,'16492',NULL,'2025-01-22 00:28:33','2025-01-22 00:28:33',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(128,'samerasas',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'samera3bdelmonem96@gmail.com','51007138',NULL,'$2y$10$fmfealczUtUp4RWGfVE4kuYnKeqY7YtkvX2WTuKEcLcKjbxKN.aBW',1,NULL,NULL,'12630',NULL,'2025-01-22 00:37:31','2025-01-22 00:38:50',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(129,'ddddddd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ghhgghhh@gmaim.com','88888888',NULL,'$2y$10$nQh.69LKwDtHogGJsSbjnO0GPt9TqGTyA9STGV1PfWx7NRlgjXIP2',0,NULL,NULL,'34838',NULL,'2025-02-09 15:32:10','2025-02-09 15:32:10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(130,'ddddddd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ghhgghhhd@gmaim.com','88888555',NULL,'$2y$10$nNWshIDFJ1VUGAGIkVlNreMvbH/GDlue6jrpnOfWrI1KguhX0fot.',0,NULL,NULL,'33963',NULL,'2025-02-09 15:32:36','2025-02-09 15:32:36',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(131,'aaaass',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'uuuuuu@gmail.com','66666666',NULL,'$2y$10$6jbr1tahsK.h2Wsa0MpeOO/C/a/V4NlyC5A5P90Dc7OU40MIXL7.C',0,NULL,NULL,'12748',NULL,'2025-02-09 15:44:09','2025-02-09 15:44:09',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(132,'dddddg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'hgggvu@gknki.com','36663666',NULL,'$2y$10$ZT7/UjqumHr3e7W/O.4Y4egH7Fhu7cb6STckL67SJusOkkjvpXQFu',1,NULL,NULL,'56033',NULL,'2025-02-09 15:48:52','2025-02-09 15:49:08',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(133,'hvhjjbb',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'hyghhh@gmai.com','58244555',NULL,'$2y$10$BmkdEABJ78af2wyRp77WgOjVNCb99yykePMmHP13rFFYeZC4yl4jG',1,NULL,NULL,'23619',NULL,'2025-02-09 15:50:45','2025-02-09 15:51:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(135,'hgggggghgv',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'gtfguyghh@gmail.com','82885554',NULL,'$2y$10$Oe2xp3WSojvY0w2.kkUgLOg8IXvhF0NncYUN7gVEoW.0b2.zxT5DO',1,NULL,NULL,'94403',NULL,'2025-02-09 15:56:24','2025-02-09 15:56:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(139,'asdfadsf',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'asdfsda@gmail.com','42364536',NULL,'$2y$10$mktGgaZD4VMy8n0TAbHDlOz7bh6P/o/PQwVhhjLWDeLyUJz2/q/zG',1,NULL,NULL,'15578',NULL,'2025-02-09 17:31:33','2025-02-09 17:31:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(140,'testapp',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'testapp@gmail.com','00000000',NULL,'$2y$10$34WMXgCu61DmMCk8mBqNgOszlbyFbXc6cOLGw9rzbqFoUia0AovXe',1,NULL,NULL,'37639',NULL,'2025-04-15 12:03:34','2025-04-15 12:03:44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(141,'test',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'asd@asd.com','55555555',NULL,'$2y$10$H49Kp6SHd93ijnY9kC/SAuBAYirTxRGk3HB6An/Z/YRRe6oZs9R.y',1,NULL,NULL,'24581',NULL,'2025-06-15 11:32:40','2025-06-15 11:33:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(142,'tête-à-tête',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fdgfhgfgh@gmail.com','11111111',NULL,'$2y$10$IGyhWGjZZDliggTR9b3OD.1rYYtaSwer65OL.zoCXv8ClSZzS/rja',1,NULL,NULL,'43329',NULL,'2025-06-15 17:01:13','2025-06-15 17:01:24',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Dumping events for database 'topappkw_aqar'
--

--
-- Dumping routines for database 'topappkw_aqar'
--


