-- MariaDB dump 10.19 Distrib 10.4.32-MariaDB, for Win64 (AMD64) -- -- Host: localhost Database: opetagency_raksha -- ------------------------------------------------------ -- Server version 10.4.32-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `activity_log` -- DROP TABLE IF EXISTS `activity_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `activity_log` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `log_name` varchar(255) DEFAULT NULL, `description` text NOT NULL, `subject_type` varchar(255) DEFAULT NULL, `subject_id` bigint(20) unsigned DEFAULT NULL, `event` varchar(255) DEFAULT NULL, `causer_type` varchar(255) DEFAULT NULL, `causer_id` bigint(20) unsigned DEFAULT NULL, `properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`properties`)), `batch_uuid` char(36) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `activity_log_log_name_index` (`log_name`), KEY `activity_log_subject_type_subject_id_index` (`subject_type`,`subject_id`), KEY `activity_log_causer_type_causer_id_index` (`causer_type`,`causer_id`) ) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `activity_log` -- LOCK TABLES `activity_log` WRITE; /*!40000 ALTER TABLE `activity_log` DISABLE KEYS */; INSERT INTO `activity_log` VALUES (1,'auth','User logged in.',NULL,NULL,'login','App\\Models\\User',1,'[]',NULL,'2026-09-09 17:48:34','2026-09-09 17:48:34'),(2,'auth','User logged in.',NULL,NULL,'login','App\\Models\\User',1,'[]',NULL,'2026-09-09 17:53:38','2026-09-09 17:53:38'),(3,'auth','User logged in.',NULL,NULL,'login','App\\Models\\User',1,'[]',NULL,'2026-09-09 17:54:03','2026-09-09 17:54:03'),(4,'auth','User logged in.',NULL,NULL,'login','App\\Models\\User',1,'[]',NULL,'2026-09-09 17:54:51','2026-09-09 17:54:51'),(5,'auth','User logged in.',NULL,NULL,'login','App\\Models\\User',1,'[]',NULL,'2026-09-09 18:03:23','2026-09-09 18:03:23'),(6,'auth','User logged in.',NULL,NULL,'login','App\\Models\\User',1,'[]',NULL,'2026-09-09 18:03:47','2026-09-09 18:03:47'),(7,'auth','User logged in.',NULL,NULL,'login','App\\Models\\User',1,'[]',NULL,'2026-09-09 18:23:30','2026-09-09 18:23:30'),(8,'auth','User logged in.',NULL,NULL,'login','App\\Models\\User',1,'[]',NULL,'2026-09-09 18:26:50','2026-09-09 18:26:50'),(9,'auth','User logged in.',NULL,NULL,'login','App\\Models\\User',1,'[]',NULL,'2026-09-09 18:33:16','2026-09-09 18:33:16'),(10,'auth','User logged in.',NULL,NULL,'login','App\\Models\\User',1,'[]',NULL,'2026-09-09 18:42:43','2026-09-09 18:42:43'),(11,'auth','User logged in.',NULL,NULL,'login','App\\Models\\User',1,'[]',NULL,'2026-09-09 18:50:37','2026-09-09 18:50:37'),(12,'auth','User logged in.',NULL,NULL,'login','App\\Models\\User',1,'[]',NULL,'2026-09-09 18:50:39','2026-09-09 18:50:39'),(13,'menu-items','deleted','App\\Models\\MenuItem',17,'deleted','App\\Models\\User',1,'{\"old\":{\"category_id\":4,\"name_en\":\"Cola Drinks\",\"name_ar\":\"\\u0645\\u0634\\u0631\\u0648\\u0628\\u0627\\u062a \\u0643\\u0648\\u0644\\u0627\",\"description_en\":\"Assorted cola soft drinks\",\"description_ar\":\"\\u0645\\u0634\\u0631\\u0648\\u0628\\u0627\\u062a \\u063a\\u0627\\u0632\\u064a\\u0629 \\u0643\\u0648\\u0644\\u0627\",\"price\":\"0.00\",\"image\":null,\"is_featured\":false,\"is_available\":true,\"tags\":null,\"ingredients_en\":null,\"ingredients_ar\":null,\"calories\":null,\"best_seller\":false,\"sort_order\":1}}',NULL,'2026-09-09 18:53:48','2026-09-09 18:53:48'),(14,'testimonials','created','App\\Models\\Testimonial',1,'created','App\\Models\\User',1,'{\"attributes\":{\"name\":\"test\",\"job_title_en\":\"test\",\"job_title_ar\":\"test\",\"rating\":5,\"review_en\":\"test\",\"review_ar\":\"test\",\"photo_url\":null,\"is_published\":false,\"sort_order\":0}}',NULL,'2026-09-09 18:54:44','2026-09-09 18:54:44'),(15,'testimonials','updated','App\\Models\\Testimonial',1,'updated','App\\Models\\User',1,'{\"attributes\":{\"is_published\":true},\"old\":{\"is_published\":false}}',NULL,'2026-09-09 18:54:51','2026-09-09 18:54:51'),(16,'auth','User logged in.',NULL,NULL,'login','App\\Models\\User',1,'[]',NULL,'2026-09-09 19:07:36','2026-09-09 19:07:36'),(17,'auth','User logged in.',NULL,NULL,'login','App\\Models\\User',1,'[]',NULL,'2026-09-09 19:14:25','2026-09-09 19:14:25'),(18,'auth','User logged in.',NULL,NULL,'login','App\\Models\\User',1,'[]',NULL,'2026-09-09 20:38:13','2026-09-09 20:38:13'),(19,'media','created','App\\Models\\Media',1,'created','App\\Models\\User',1,'{\"attributes\":{\"original_name\":\"test-upload.png\",\"folder_id\":null,\"alt_text\":null}}',NULL,'2026-09-09 20:40:15','2026-09-09 20:40:15'),(20,'gallery','created','App\\Models\\Gallery',1,'created','App\\Models\\User',1,'{\"attributes\":{\"title\":\"Test Interior\",\"category\":\"interior\",\"image_path\":\"http:\\/\\/localhost\\/storage\\/gallery\\/NonO1cCqFYTd9R3gJwFZPssE6OFDxAbH6S6fjzHh.png\",\"sort_order\":0}}',NULL,'2026-09-09 20:40:32','2026-09-09 20:40:32'),(21,'gallery','deleted','App\\Models\\Gallery',1,'deleted','App\\Models\\User',1,'{\"old\":{\"title\":\"Test Interior\",\"category\":\"interior\",\"image_path\":\"http:\\/\\/localhost\\/storage\\/gallery\\/NonO1cCqFYTd9R3gJwFZPssE6OFDxAbH6S6fjzHh.png\",\"sort_order\":0}}',NULL,'2026-09-09 20:40:46','2026-09-09 20:40:46'),(22,'media','deleted','App\\Models\\Media',1,'deleted','App\\Models\\User',1,'{\"old\":{\"original_name\":\"test-upload.png\",\"folder_id\":null,\"alt_text\":null}}',NULL,'2026-09-09 20:40:48','2026-09-09 20:40:48'),(23,'media','created','App\\Models\\Media',2,'created','App\\Models\\User',1,'{\"attributes\":{\"original_name\":\"catgery main img.webp\",\"folder_id\":null,\"alt_text\":null}}',NULL,'2026-09-09 20:42:25','2026-09-09 20:42:25'),(24,'menu-items','updated','App\\Models\\MenuItem',1,'updated','App\\Models\\User',1,'{\"attributes\":{\"image\":\"http:\\/\\/localhost\\/storage\\/media\\/2026\\/09\\/aa2e0ede-471b-48f8-8583-7815a6d62319.webp\"},\"old\":{\"image\":null}}',NULL,'2026-09-09 20:42:26','2026-09-09 20:42:26'),(25,'auth','User logged in.',NULL,NULL,'login','App\\Models\\User',1,'[]',NULL,'2026-09-09 20:46:39','2026-09-09 20:46:39'),(26,'homepage-cms','created','App\\Models\\ContentBlock',1,'created','App\\Models\\User',1,'{\"attributes\":{\"section_key\":\"hero_slide\",\"sort_order\":1,\"is_active\":true,\"data\":{\"heading_en\":\"Authentic Eastern Flavors\",\"cta_link\":\"\\/reservations\",\"eyebrow_ar\":\"\\u062c\\u0645\\u0631\\u0629\",\"subtitle_en\":\"Fresh sandwiches and grills made to order in New Cairo and Shorouk \\u2014 bold flavors, warm hospitality.\",\"image_url\":\"\\/images\\/hero.jpg\",\"eyebrow_en\":\"JAMRA\",\"subtitle_ar\":\"\\u0633\\u0627\\u0646\\u062f\\u0648\\u062a\\u0634\\u0627\\u062a \\u0648\\u0645\\u0634\\u0648\\u064a\\u0627\\u062a \\u0637\\u0627\\u0632\\u062c\\u0629 \\u062a\\u064f\\u062d\\u0636\\u064e\\u0651\\u0631 \\u0639\\u0646\\u062f \\u0627\\u0644\\u0637\\u0644\\u0628 \\u0641\\u064a \\u0627\\u0644\\u0642\\u0627\\u0647\\u0631\\u0629 \\u0627\\u0644\\u062c\\u062f\\u064a\\u062f\\u0629 \\u0648\\u0627\\u0644\\u0634\\u0631\\u0648\\u0642 \\u2014 \\u0646\\u0643\\u0647\\u0627\\u062a \\u0642\\u0648\\u064a\\u0629 \\u0648\\u0636\\u064a\\u0627\\u0641\\u0629 \\u062f\\u0627\\u0641\\u0626\\u0629.\",\"cta_label_en\":\"Book a Table\",\"cta_label_ar\":\"\\u0627\\u062d\\u062c\\u0632 \\u0637\\u0627\\u0648\\u0644\\u062a\\u0643\",\"heading_ar\":\"\\u0646\\u0643\\u0647\\u0627\\u062a \\u0634\\u0631\\u0642\\u064a\\u0629 \\u0623\\u0635\\u064a\\u0644\\u0629\"}}}',NULL,'2026-09-09 20:48:20','2026-09-09 20:48:20'),(27,'homepage-cms','created','App\\Models\\ContentBlock',2,'created','App\\Models\\User',1,'{\"attributes\":{\"section_key\":\"hero_slide\",\"sort_order\":2,\"is_active\":true,\"data\":{\"heading_en\":\"Grills & Sandwiches Made to Order\",\"cta_link\":\"\\/menu\",\"eyebrow_ar\":\"\\u0637\\u0627\\u0632\\u062c \\u0648\\u062c\\u0631\\u064a\\u0621\",\"subtitle_en\":\"From shawarma to mixed grills, every plate is crafted with bold, authentic flavors.\",\"image_url\":\"\\/images\\/gallery-1.jpg\",\"eyebrow_en\":\"Fresh & Bold\",\"subtitle_ar\":\"\\u0645\\u0646 \\u0627\\u0644\\u0634\\u0627\\u0648\\u0631\\u0645\\u0627 \\u0625\\u0644\\u0649 \\u0627\\u0644\\u0645\\u0634\\u0648\\u064a\\u0627\\u062a \\u0627\\u0644\\u0645\\u0634\\u0643\\u0644\\u0629\\u060c \\u0643\\u0644 \\u0637\\u0628\\u0642 \\u064a\\u064f\\u062d\\u0636\\u064e\\u0651\\u0631 \\u0628\\u0646\\u0643\\u0647\\u0627\\u062a \\u0623\\u0635\\u064a\\u0644\\u0629 \\u0642\\u0648\\u064a\\u0629.\",\"cta_label_en\":\"View Menu\",\"cta_label_ar\":\"\\u0639\\u0631\\u0636 \\u0627\\u0644\\u0642\\u0627\\u0626\\u0645\\u0629\",\"heading_ar\":\"\\u0645\\u0634\\u0648\\u064a\\u0627\\u062a \\u0648\\u0633\\u0627\\u0646\\u062f\\u0648\\u062a\\u0634\\u0627\\u062a \\u062a\\u064f\\u062d\\u0636\\u064e\\u0651\\u0631 \\u0639\\u0646\\u062f \\u0627\\u0644\\u0637\\u0644\\u0628\"}}}',NULL,'2026-09-09 20:48:23','2026-09-09 20:48:23'),(28,'homepage-cms','created','App\\Models\\ContentBlock',3,'created','App\\Models\\User',1,'{\"attributes\":{\"section_key\":\"hero_slide\",\"sort_order\":3,\"is_active\":true,\"data\":{\"heading_en\":\"A Space to Belong\",\"cta_link\":\"\\/gallery\",\"eyebrow_ar\":\"\\u0636\\u064a\\u0627\\u0641\\u0629 \\u062f\\u0627\\u0641\\u0626\\u0629\",\"subtitle_en\":\"Step inside a space designed for long conversations and great food.\",\"image_url\":\"\\/images\\/gallery-2.jpg\",\"eyebrow_en\":\"Warm Hospitality\",\"subtitle_ar\":\"\\u0627\\u062f\\u062e\\u0644 \\u0625\\u0644\\u0649 \\u0645\\u0633\\u0627\\u062d\\u0629 \\u0635\\u064f\\u0645\\u0645\\u062a \\u0644\\u0644\\u0623\\u062d\\u0627\\u062f\\u064a\\u062b \\u0627\\u0644\\u0637\\u0648\\u064a\\u0644\\u0629 \\u0648\\u0627\\u0644\\u0637\\u0639\\u0627\\u0645 \\u0627\\u0644\\u0631\\u0627\\u0626\\u0639.\",\"cta_label_en\":\"Explore Gallery\",\"cta_label_ar\":\"\\u0627\\u0633\\u062a\\u0643\\u0634\\u0641 \\u0627\\u0644\\u0645\\u0639\\u0631\\u0636\",\"heading_ar\":\"\\u0645\\u0633\\u0627\\u062d\\u0629 \\u062a\\u0646\\u062a\\u0645\\u064a \\u0625\\u0644\\u064a\\u0647\\u0627\"}}}',NULL,'2026-09-09 20:48:26','2026-09-09 20:48:26'),(29,'homepage-cms','created','App\\Models\\ContentBlock',4,'created','App\\Models\\User',1,'{\"attributes\":{\"section_key\":\"about\",\"sort_order\":0,\"is_active\":true,\"data\":{\"eyebrow_en\":\"Our Story\",\"heading_ar\":\"\\u062d\\u0631\\u0641\\u064a\\u0629 \\u0631\\u0627\\u0633\\u062e\\u0629\\u060c \\u062a\\u064f\\u0642\\u062f\\u064e\\u0651\\u0645 \\u0628\\u0631\\u0648\\u062d\",\"body_ar\":\"\\u062c\\u0645\\u0631\\u0629 \\u0645\\u0637\\u0639\\u0645 \\u064a\\u062d\\u062a\\u0641\\u0644 \\u0628\\u0627\\u0644\\u0645\\u0637\\u0628\\u062e \\u0627\\u0644\\u0634\\u0631\\u0642\\u064a \\u0627\\u0644\\u0623\\u0635\\u064a\\u0644 \\u2014 \\u0645\\u0646 \\u0627\\u0644\\u0634\\u0627\\u0648\\u0631\\u0645\\u0627 \\u0648\\u0627\\u0644\\u0645\\u0634\\u0648\\u064a\\u0627\\u062a \\u0627\\u0644\\u062a\\u0642\\u0644\\u064a\\u062f\\u064a\\u0629 \\u0625\\u0644\\u0649 \\u0627\\u0644\\u0623\\u062c\\u0648\\u0627\\u0621 \\u0627\\u0644\\u062f\\u0627\\u0641\\u0626\\u0629 \\u0648\\u0627\\u0644\\u062a\\u0631\\u062d\\u064a\\u0628\\u064a\\u0629. \\u0643\\u0644 \\u0632\\u064a\\u0627\\u0631\\u0629 \\u0647\\u064a \\u0631\\u062d\\u0644\\u0629 \\u0641\\u064a \\u0639\\u0627\\u0644\\u0645 \\u0627\\u0644\\u0646\\u0643\\u0647\\u0627\\u062a \\u0648\\u0627\\u0644\\u0636\\u064a\\u0627\\u0641\\u0629.\",\"eyebrow_ar\":\"\\u0642\\u0635\\u062a\\u0646\\u0627\",\"stats\":[{\"value\":\"12+\",\"label\":{\"ar\":\"\\u0633\\u0646\\u0629 \\u0645\\u0646 \\u0627\\u0644\\u062d\\u0631\\u0641\\u064a\\u0629\",\"en\":\"Years of Craft\"},\"id\":\"years\"},{\"value\":\"40+\",\"label\":{\"ar\":\"\\u0637\\u0628\\u0642\\u064b\\u0627 \\u0645\\u0645\\u064a\\u0632\\u064b\\u0627\",\"en\":\"Signature Dishes\"},\"id\":\"dishes\"},{\"value\":\"4.9\",\"label\":{\"ar\":\"\\u062a\\u0642\\u064a\\u064a\\u0645 \\u0627\\u0644\\u0636\\u064a\\u0648\\u0641\",\"en\":\"Guest Rating\"},\"id\":\"rating\"}],\"body_en\":\"JAMRA is a restaurant that celebrates authentic Eastern cuisine \\u2014 from traditional shawarma and grills to a warm, welcoming atmosphere. Every visit is a journey of taste and hospitality.\",\"heading_en\":\"Rooted in Craft, Served with Soul\",\"image\":\"\\/images\\/gallery-2.jpg\"}}}',NULL,'2026-09-09 20:48:28','2026-09-09 20:48:28'),(30,'homepage-cms','created','App\\Models\\ContentBlock',5,'created','App\\Models\\User',1,'{\"attributes\":{\"section_key\":\"why_choose_us_heading\",\"sort_order\":0,\"is_active\":true,\"data\":{\"eyebrow_ar\":\"\\u0644\\u0645\\u0627\\u0630\\u0627 \\u062c\\u0645\\u0631\\u0629\",\"heading_en\":\"Why Guests Choose Us\",\"subtitle_ar\":\"\\u0627\\u0644\\u062a\\u0641\\u0627\\u0635\\u064a\\u0644 \\u0627\\u0644\\u062a\\u064a \\u062a\\u062d\\u0648\\u0651\\u0644 \\u0627\\u0644\\u0632\\u064a\\u0627\\u0631\\u0629 \\u0627\\u0644\\u0628\\u0633\\u064a\\u0637\\u0629 \\u0625\\u0644\\u0649 \\u0639\\u0627\\u062f\\u0629 \\u064a\\u0648\\u0645\\u064a\\u0629.\",\"eyebrow_en\":\"Why JAMRA\",\"heading_ar\":\"\\u0644\\u0645\\u0627\\u0630\\u0627 \\u064a\\u062e\\u062a\\u0627\\u0631\\u0646\\u0627 \\u0636\\u064a\\u0648\\u0641\\u0646\\u0627\",\"subtitle_en\":\"The details that turn a simple visit into a ritual.\"}}}',NULL,'2026-09-09 20:48:31','2026-09-09 20:48:31'),(31,'homepage-cms','created','App\\Models\\ContentBlock',6,'created','App\\Models\\User',1,'{\"attributes\":{\"section_key\":\"why_choose_us_item\",\"sort_order\":1,\"is_active\":true,\"data\":{\"title_en\":\"Authentic Recipes\",\"description_ar\":\"\\u0648\\u0635\\u0641\\u0627\\u062a \\u0634\\u0631\\u0642\\u064a\\u0629 \\u062a\\u0642\\u0644\\u064a\\u062f\\u064a\\u0629 \\u062a\\u0648\\u0627\\u0631\\u062b\\u0646\\u0627\\u0647\\u0627 \\u0628\\u0639\\u0646\\u0627\\u064a\\u0629.\",\"title_ar\":\"\\u0648\\u0635\\u0641\\u0627\\u062a \\u0623\\u0635\\u064a\\u0644\\u0629\",\"description_en\":\"Traditional Eastern recipes passed down with care.\",\"icon\":\"flame\"}}}',NULL,'2026-09-09 20:48:34','2026-09-09 20:48:34'),(32,'homepage-cms','created','App\\Models\\ContentBlock',7,'created','App\\Models\\User',1,'{\"attributes\":{\"section_key\":\"why_choose_us_item\",\"sort_order\":2,\"is_active\":true,\"data\":{\"title_en\":\"Fresh Ingredients\",\"description_ar\":\"\\u062a\\u064f\\u062e\\u062a\\u0627\\u0631 \\u064a\\u0648\\u0645\\u064a\\u064b\\u0627 \\u0645\\u0646 \\u0645\\u0648\\u0631\\u062f\\u064a\\u0646 \\u0645\\u062d\\u0644\\u064a\\u064a\\u0646 \\u0645\\u0648\\u062b\\u0648\\u0642\\u064a\\u0646.\",\"title_ar\":\"\\u0645\\u0643\\u0648\\u0646\\u0627\\u062a \\u0637\\u0627\\u0632\\u062c\\u0629\",\"description_en\":\"Sourced daily from trusted local suppliers.\",\"icon\":\"leaf\"}}}',NULL,'2026-09-09 20:48:36','2026-09-09 20:48:36'),(33,'homepage-cms','created','App\\Models\\ContentBlock',8,'created','App\\Models\\User',1,'{\"attributes\":{\"section_key\":\"why_choose_us_item\",\"sort_order\":3,\"is_active\":true,\"data\":{\"title_en\":\"Warm Hospitality\",\"description_ar\":\"\\u0643\\u0644 \\u0636\\u064a\\u0641 \\u064a\\u064f\\u0633\\u062a\\u0642\\u0628\\u0644 \\u0648\\u0643\\u0623\\u0646\\u0647 \\u0645\\u0646 \\u0627\\u0644\\u0639\\u0627\\u0626\\u0644\\u0629.\",\"title_ar\":\"\\u0636\\u064a\\u0627\\u0641\\u0629 \\u062f\\u0627\\u0641\\u0626\\u0629\",\"description_en\":\"Every guest is welcomed like family.\",\"icon\":\"heart\"}}}',NULL,'2026-09-09 20:48:39','2026-09-09 20:48:39'),(34,'homepage-cms','created','App\\Models\\ContentBlock',9,'created','App\\Models\\User',1,'{\"attributes\":{\"section_key\":\"why_choose_us_item\",\"sort_order\":4,\"is_active\":true,\"data\":{\"title_en\":\"Fast & Fresh\",\"description_ar\":\"\\u064a\\u064f\\u062d\\u0636\\u064e\\u0651\\u0631 \\u0639\\u0646\\u062f \\u0627\\u0644\\u0637\\u0644\\u0628 \\u0648\\u064a\\u064f\\u0642\\u062f\\u064e\\u0651\\u0645 \\u0633\\u0627\\u062e\\u0646\\u064b\\u0627 \\u0641\\u064a \\u0643\\u0644 \\u0645\\u0631\\u0629.\",\"title_ar\":\"\\u0633\\u0631\\u064a\\u0639 \\u0648\\u0637\\u0627\\u0632\\u062c\",\"description_en\":\"Made to order, served hot, every time.\",\"icon\":\"clock\"}}}',NULL,'2026-09-09 20:48:41','2026-09-09 20:48:41'),(35,'homepage-cms','created','App\\Models\\ContentBlock',10,'created','App\\Models\\User',1,'{\"attributes\":{\"section_key\":\"featured_menu\",\"sort_order\":0,\"is_active\":true,\"data\":{\"heading_ar\":\"\\u0645\\u0646 \\u0645\\u0637\\u0628\\u062e\\u0646\\u0627 \\u0625\\u0644\\u0649 \\u0645\\u0627\\u0626\\u062f\\u062a\\u0643\",\"heading_en\":\"From Our Kitchen to Your Table\",\"eyebrow_ar\":\"\\u0645\\u062e\\u062a\\u0627\\u0631\\u0627\\u062a \\u062e\\u0627\\u0635\\u0629\",\"eyebrow_en\":\"Handpicked\"}}}',NULL,'2026-09-09 20:48:44','2026-09-09 20:48:44'),(36,'homepage-cms','created','App\\Models\\ContentBlock',11,'created','App\\Models\\User',1,'{\"attributes\":{\"section_key\":\"gallery_preview\",\"sort_order\":0,\"is_active\":true,\"data\":{\"heading_ar\":\"\\u0644\\u0645\\u062d\\u0629 \\u0645\\u0646 \\u0627\\u0644\\u062a\\u062c\\u0631\\u0628\\u0629\",\"heading_en\":\"A Glimpse of the Experience\",\"eyebrow_ar\":\"\\u062f\\u0627\\u062e\\u0644 \\u062c\\u0645\\u0631\\u0629\",\"eyebrow_en\":\"Inside JAMRA\"}}}',NULL,'2026-09-09 20:48:47','2026-09-09 20:48:47'),(37,'homepage-cms','created','App\\Models\\ContentBlock',12,'created','App\\Models\\User',1,'{\"attributes\":{\"section_key\":\"video_section\",\"sort_order\":0,\"is_active\":true,\"data\":{\"eyebrow_ar\":\"\\u062a\\u062c\\u0631\\u0628\\u0629 \\u062c\\u0645\\u0631\\u0629\",\"heading_en\":\"A Taste of the Atmosphere\",\"video_url\":\"\\/videos\\/atmosphere.mp4\",\"eyebrow_en\":\"The JAMRA Experience\",\"heading_ar\":\"\\u0644\\u0645\\u062d\\u0629 \\u0645\\u0646 \\u0627\\u0644\\u0623\\u062c\\u0648\\u0627\\u0621\",\"poster_image_url\":\"\\/images\\/gallery-1.jpg\"}}}',NULL,'2026-09-09 20:48:50','2026-09-09 20:48:50'),(38,'homepage-cms','created','App\\Models\\ContentBlock',13,'created','App\\Models\\User',1,'{\"attributes\":{\"section_key\":\"testimonials_section\",\"sort_order\":0,\"is_active\":true,\"data\":{\"heading_ar\":\"\\u0645\\u0627\\u0630\\u0627 \\u064a\\u0642\\u0648\\u0644 \\u0627\\u0644\\u0646\\u0627\\u0633\",\"heading_en\":\"What People Are Saying\",\"eyebrow_ar\":\"\\u0622\\u0631\\u0627\\u0621 \\u0627\\u0644\\u0636\\u064a\\u0648\\u0641\",\"eyebrow_en\":\"Testimonials\"}}}',NULL,'2026-09-09 20:48:52','2026-09-09 20:48:52'),(39,'homepage-cms','created','App\\Models\\ContentBlock',14,'created','App\\Models\\User',1,'{\"attributes\":{\"section_key\":\"reservation_cta\",\"sort_order\":0,\"is_active\":true,\"data\":{\"cta_label_en\":\"Reserve a Table\",\"heading_en\":\"Your Table Is Waiting\",\"subtitle_ar\":\"\\u0627\\u062d\\u062c\\u0632 \\u0641\\u064a \\u0623\\u0642\\u0644 \\u0645\\u0646 \\u062f\\u0642\\u064a\\u0642\\u0629 \\u0648\\u062f\\u0639\\u0646\\u0627 \\u0646\\u0647\\u062a\\u0645 \\u0628\\u0627\\u0644\\u0628\\u0627\\u0642\\u064a.\",\"cta_label_ar\":\"\\u0627\\u062d\\u062c\\u0632 \\u0637\\u0627\\u0648\\u0644\\u062a\\u0643\",\"heading_ar\":\"\\u0637\\u0627\\u0648\\u0644\\u062a\\u0643 \\u0641\\u064a \\u0627\\u0646\\u062a\\u0638\\u0627\\u0631\\u0643\",\"subtitle_en\":\"Reserve in less than a minute and let us take care of the rest.\"}}}',NULL,'2026-09-09 20:48:55','2026-09-09 20:48:55'),(40,'homepage-cms','created','App\\Models\\ContentBlock',15,'created','App\\Models\\User',1,'{\"attributes\":{\"section_key\":\"footer\",\"sort_order\":0,\"is_active\":true,\"data\":{\"tagline_ar\":\"\\u0646\\u0643\\u0647\\u0627\\u062a \\u0634\\u0631\\u0642\\u064a\\u0629 \\u0623\\u0635\\u064a\\u0644\\u0629\\u060c \\u0635\\u064f\\u0646\\u0639\\u062a \\u0628\\u062f\\u0641\\u0621 \\u0648\\u0634\\u063a\\u0641.\",\"tagline_en\":\"Authentic Eastern flavors, crafted with warmth.\"}}}',NULL,'2026-09-09 20:48:57','2026-09-09 20:48:57'),(41,'homepage-cms','created','App\\Models\\ContentBlock',16,'created','App\\Models\\User',1,'{\"attributes\":{\"section_key\":\"events_heading\",\"sort_order\":0,\"is_active\":true,\"data\":{\"eyebrow_ar\":\"\\u0627\\u062d\\u062a\\u0641\\u0644 \\u0645\\u0639\\u0646\\u0627\",\"heading_en\":\"Moments Made for Sharing\",\"subtitle_ar\":\"\\u0645\\u0646 \\u0623\\u0639\\u064a\\u0627\\u062f \\u0627\\u0644\\u0645\\u064a\\u0644\\u0627\\u062f \\u0625\\u0644\\u0649 \\u0644\\u064a\\u0627\\u0644\\u064a \\u0627\\u0644\\u0645\\u0628\\u0627\\u0631\\u064a\\u0627\\u062a\\u060c \\u0646\\u062c\\u0647\\u0632 \\u0627\\u0644\\u0645\\u0643\\u0627\\u0646 \\u0644\\u062a\\u062c\\u0645\\u0639\\u0627\\u062a\\u0643.\",\"eyebrow_en\":\"Celebrate With Us\",\"heading_ar\":\"\\u0644\\u062d\\u0638\\u0627\\u062a \\u0635\\u064f\\u0646\\u0639\\u062a \\u0644\\u062a\\u064f\\u0634\\u0627\\u0631\\u0643\",\"subtitle_en\":\"From birthdays to match nights, we set the scene for your gatherings.\"}}}',NULL,'2026-09-09 20:49:00','2026-09-09 20:49:00'),(42,'homepage-cms','created','App\\Models\\ContentBlock',17,'created','App\\Models\\User',1,'{\"attributes\":{\"section_key\":\"event_item\",\"sort_order\":1,\"is_active\":true,\"data\":{\"title_en\":\"Birthday Celebrations\",\"description_ar\":\"\\u062a\\u062c\\u0647\\u064a\\u0632\\u0627\\u062a \\u0645\\u062e\\u0635\\u0635\\u0629 \\u0648\\u0631\\u0643\\u0646 \\u0645\\u062b\\u0627\\u0644\\u064a \\u0644\\u0644\\u0627\\u062d\\u062a\\u0641\\u0627\\u0644 \\u0628\\u064a\\u0648\\u0645\\u0643 \\u0627\\u0644\\u0645\\u0645\\u064a\\u0632.\",\"description_en\":\"Custom setups and a cake-worthy corner for your special day.\",\"title_ar\":\"\\u0623\\u0639\\u064a\\u0627\\u062f \\u0627\\u0644\\u0645\\u064a\\u0644\\u0627\\u062f\",\"image_url\":\"\\/images\\/gallery-3.jpg\"}}}',NULL,'2026-09-09 20:49:03','2026-09-09 20:49:03'),(43,'homepage-cms','created','App\\Models\\ContentBlock',18,'created','App\\Models\\User',1,'{\"attributes\":{\"section_key\":\"event_item\",\"sort_order\":2,\"is_active\":true,\"data\":{\"title_en\":\"Live Match Nights\",\"description_ar\":\"\\u0634\\u0627\\u0634\\u0627\\u062a \\u0643\\u0628\\u064a\\u0631\\u0629 \\u0648\\u0645\\u0642\\u0628\\u0644\\u0627\\u062a \\u0623\\u0643\\u0628\\u0631 \\u2014 \\u0634\\u0627\\u0647\\u062f \\u0643\\u0644 \\u0645\\u0628\\u0627\\u0631\\u0627\\u0629 \\u0645\\u0639 \\u0623\\u0635\\u062f\\u0642\\u0627\\u0626\\u0643.\",\"description_en\":\"Big screens, bigger snacks \\u2014 catch every match with friends.\",\"title_ar\":\"\\u0644\\u064a\\u0627\\u0644\\u064a \\u0627\\u0644\\u0645\\u0628\\u0627\\u0631\\u064a\\u0627\\u062a\",\"image_url\":\"\\/images\\/gallery-4.jpg\"}}}',NULL,'2026-09-09 20:49:05','2026-09-09 20:49:05'),(44,'homepage-cms','created','App\\Models\\ContentBlock',19,'created','App\\Models\\User',1,'{\"attributes\":{\"section_key\":\"event_item\",\"sort_order\":3,\"is_active\":true,\"data\":{\"title_en\":\"Live Music Evenings\",\"description_ar\":\"\\u0639\\u0632\\u0641 \\u062d\\u064a \\u0648\\u0625\\u0636\\u0627\\u0621\\u0629 \\u0647\\u0627\\u062f\\u0626\\u0629 \\u0644\\u0633\\u0647\\u0631\\u0629 \\u0644\\u0627 \\u062a\\u064f\\u0646\\u0633\\u0649.\",\"description_en\":\"Acoustic sets and soft lighting for an unforgettable evening.\",\"title_ar\":\"\\u0623\\u0645\\u0633\\u064a\\u0627\\u062a \\u0645\\u0648\\u0633\\u064a\\u0642\\u064a\\u0629\",\"image_url\":\"\\/images\\/gallery-5.jpg\"}}}',NULL,'2026-09-09 20:49:08','2026-09-09 20:49:08'),(45,'homepage-cms','created','App\\Models\\ContentBlock',20,'created','App\\Models\\User',1,'{\"attributes\":{\"section_key\":\"event_item\",\"sort_order\":4,\"is_active\":true,\"data\":{\"title_en\":\"Private Dinners & Events\",\"description_ar\":\"\\u0627\\u062d\\u062c\\u0632 \\u0627\\u0644\\u0645\\u0643\\u0627\\u0646 \\u0644\\u0644\\u0630\\u0643\\u0631\\u0649 \\u0627\\u0644\\u0633\\u0646\\u0648\\u064a\\u0629 \\u0623\\u0648 \\u0627\\u0644\\u062a\\u062c\\u0645\\u0639\\u0627\\u062a \\u0623\\u0648 \\u0623\\u0645\\u0633\\u064a\\u0627\\u062a \\u0627\\u0644\\u0634\\u0631\\u0643\\u0627\\u062a.\",\"description_en\":\"Book the space for anniversaries, gatherings, or company nights.\",\"title_ar\":\"\\u0639\\u0634\\u0627\\u0621\\u0627\\u062a \\u0648\\u0645\\u0646\\u0627\\u0633\\u0628\\u0627\\u062a \\u062e\\u0627\\u0635\\u0629\",\"image_url\":\"\\/images\\/gallery-6.jpg\"}}}',NULL,'2026-09-09 20:49:11','2026-09-09 20:49:11'),(46,'homepage-cms','created','App\\Models\\ContentBlock',21,'created','App\\Models\\User',1,'{\"attributes\":{\"section_key\":\"seo_home\",\"sort_order\":0,\"is_active\":true,\"data\":{\"robots\":\"index, follow\",\"seo_description_ar\":\"\\u064a\\u0642\\u062f\\u0645 \\u0645\\u0637\\u0639\\u0645 \\u062c\\u0645\\u0631\\u0629 \\u0623\\u0641\\u0636\\u0644 \\u0627\\u0644\\u0633\\u0627\\u0646\\u062f\\u0648\\u062a\\u0634\\u0627\\u062a \\u0648\\u0627\\u0644\\u0645\\u0634\\u0648\\u064a\\u0627\\u062a \\u0627\\u0644\\u0634\\u0631\\u0642\\u064a\\u0629 \\u0641\\u064a \\u0627\\u0644\\u0642\\u0627\\u0647\\u0631\\u0629 \\u0627\\u0644\\u062c\\u062f\\u064a\\u062f\\u0629 \\u0648\\u0627\\u0644\\u0634\\u0631\\u0648\\u0642 \\u2014 \\u0637\\u0627\\u0632\\u062c\\u0629 \\u0648\\u0633\\u0631\\u064a\\u0639\\u0629 \\u0648\\u0645\\u0644\\u064a\\u0626\\u0629 \\u0628\\u0627\\u0644\\u0646\\u0643\\u0647\\u0629.\",\"canonical_url\":null,\"seo_keywords_en\":\"JAMRA, restaurant, Eastern food, sandwiches, grills, shawarma, New Cairo, Shorouk\",\"seo_description_en\":\"JAMRA serves the best Eastern sandwiches and grills in New Cairo and Shorouk \\u2014 fresh, fast, and full of flavor.\",\"seo_keywords_ar\":\"\\u062c\\u0645\\u0631\\u0629, \\u0645\\u0637\\u0639\\u0645, \\u0637\\u0639\\u0627\\u0645 \\u0634\\u0631\\u0642\\u064a, \\u0633\\u0627\\u0646\\u062f\\u0648\\u062a\\u0634\\u0627\\u062a, \\u0645\\u0634\\u0648\\u064a\\u0627\\u062a, \\u0634\\u0627\\u0648\\u0631\\u0645\\u0627, \\u0627\\u0644\\u0642\\u0627\\u0647\\u0631\\u0629 \\u0627\\u0644\\u062c\\u062f\\u064a\\u062f\\u0629, \\u0627\\u0644\\u0634\\u0631\\u0648\\u0642\",\"seo_title_en\":\"JAMRA Restaurant | Authentic Eastern Sandwiches & Grills\",\"seo_title_ar\":\"\\u0645\\u0637\\u0639\\u0645 \\u062c\\u0645\\u0631\\u0629 | \\u0633\\u0627\\u0646\\u062f\\u0648\\u062a\\u0634\\u0627\\u062a \\u0648\\u0645\\u0634\\u0648\\u064a\\u0627\\u062a \\u0634\\u0631\\u0642\\u064a\\u0629 \\u0623\\u0635\\u064a\\u0644\\u0629\",\"og_image_url\":\"\\/images\\/hero.jpg\"}}}',NULL,'2026-09-09 20:49:14','2026-09-09 20:49:14'),(47,'gallery','created','App\\Models\\Gallery',2,'created','App\\Models\\User',1,'{\"attributes\":{\"title\":\"Our Space\",\"category\":\"interior\",\"image_path\":\"http:\\/\\/localhost\\/storage\\/gallery\\/5q0RMkfzDxHNqJ0wN0TSPkRXRYCF5YKAuvxlWpEi.jpg\",\"sort_order\":1}}',NULL,'2026-09-09 20:50:42','2026-09-09 20:50:42'),(48,'gallery','created','App\\Models\\Gallery',3,'created','App\\Models\\User',1,'{\"attributes\":{\"title\":\"Cozy Corner\",\"category\":\"interior\",\"image_path\":\"http:\\/\\/localhost\\/storage\\/gallery\\/HE09rQY17o0kzlCGHyZ2ARB3f1nBUSilVPRb5jG9.jpg\",\"sort_order\":2}}',NULL,'2026-09-09 20:50:44','2026-09-09 20:50:44'),(49,'gallery','created','App\\Models\\Gallery',4,'created','App\\Models\\User',1,'{\"attributes\":{\"title\":\"Signature Dish\",\"category\":\"food\",\"image_path\":\"http:\\/\\/localhost\\/storage\\/gallery\\/A03XpX3MZ4mmWBaiLLoZB6B0WU4SDbY5xIMkFiAv.jpg\",\"sort_order\":3}}',NULL,'2026-09-09 20:50:47','2026-09-09 20:50:47'),(50,'gallery','created','App\\Models\\Gallery',5,'created','App\\Models\\User',1,'{\"attributes\":{\"title\":\"Fresh Grills\",\"category\":\"food\",\"image_path\":\"http:\\/\\/localhost\\/storage\\/gallery\\/Plz2xW9lUi8wrBIVrf7M2OwdGaTyCejMADvFa5bd.jpg\",\"sort_order\":4}}',NULL,'2026-09-09 20:50:50','2026-09-09 20:50:50'),(51,'gallery','created','App\\Models\\Gallery',6,'created','App\\Models\\User',1,'{\"attributes\":{\"title\":\"Match Night\",\"category\":\"events\",\"image_path\":\"http:\\/\\/localhost\\/storage\\/gallery\\/zpf5JdTUPILG4dFbsakWH6IwU3ikWYKx3jZRgFik.jpg\",\"sort_order\":5}}',NULL,'2026-09-09 20:50:53','2026-09-09 20:50:53'),(52,'gallery','created','App\\Models\\Gallery',7,'created','App\\Models\\User',1,'{\"attributes\":{\"title\":\"The Ambiance\",\"category\":\"interior\",\"image_path\":\"http:\\/\\/localhost\\/storage\\/gallery\\/4xSncN4b6mNh9She0zoeGb7DH0Ukc9C6TpEO6pPY.jpg\",\"sort_order\":6}}',NULL,'2026-09-09 20:50:55','2026-09-09 20:50:55'),(53,'gallery','created','App\\Models\\Gallery',8,'created','App\\Models\\User',1,'{\"attributes\":{\"title\":\"Shawarma Platter\",\"category\":\"food\",\"image_path\":\"http:\\/\\/localhost\\/storage\\/gallery\\/aIvqOWP2KAI5qJDiwPab7x2zG6jhoMwRvLOlYEAF.jpg\",\"sort_order\":7}}',NULL,'2026-09-09 20:50:58','2026-09-09 20:50:58'),(54,'gallery','created','App\\Models\\Gallery',9,'created','App\\Models\\User',1,'{\"attributes\":{\"title\":\"Celebrations\",\"category\":\"events\",\"image_path\":\"http:\\/\\/localhost\\/storage\\/gallery\\/ODsZbbe6qtFyfuX1t0rToMzatKvmrWMJymOpUjM0.jpg\",\"sort_order\":8}}',NULL,'2026-09-09 20:51:01','2026-09-09 20:51:01'),(55,'gallery','updated','App\\Models\\Gallery',2,'updated',NULL,NULL,'{\"attributes\":{\"image_path\":\"http:\\/\\/localhost:8000\\/storage\\/gallery\\/5q0RMkfzDxHNqJ0wN0TSPkRXRYCF5YKAuvxlWpEi.jpg\"},\"old\":{\"image_path\":\"http:\\/\\/localhost\\/storage\\/gallery\\/5q0RMkfzDxHNqJ0wN0TSPkRXRYCF5YKAuvxlWpEi.jpg\"}}',NULL,'2026-09-09 21:07:00','2026-09-09 21:07:00'),(56,'gallery','updated','App\\Models\\Gallery',3,'updated',NULL,NULL,'{\"attributes\":{\"image_path\":\"http:\\/\\/localhost:8000\\/storage\\/gallery\\/HE09rQY17o0kzlCGHyZ2ARB3f1nBUSilVPRb5jG9.jpg\"},\"old\":{\"image_path\":\"http:\\/\\/localhost\\/storage\\/gallery\\/HE09rQY17o0kzlCGHyZ2ARB3f1nBUSilVPRb5jG9.jpg\"}}',NULL,'2026-09-09 21:07:00','2026-09-09 21:07:00'),(57,'gallery','updated','App\\Models\\Gallery',4,'updated',NULL,NULL,'{\"attributes\":{\"image_path\":\"http:\\/\\/localhost:8000\\/storage\\/gallery\\/A03XpX3MZ4mmWBaiLLoZB6B0WU4SDbY5xIMkFiAv.jpg\"},\"old\":{\"image_path\":\"http:\\/\\/localhost\\/storage\\/gallery\\/A03XpX3MZ4mmWBaiLLoZB6B0WU4SDbY5xIMkFiAv.jpg\"}}',NULL,'2026-09-09 21:07:00','2026-09-09 21:07:00'),(58,'gallery','updated','App\\Models\\Gallery',5,'updated',NULL,NULL,'{\"attributes\":{\"image_path\":\"http:\\/\\/localhost:8000\\/storage\\/gallery\\/Plz2xW9lUi8wrBIVrf7M2OwdGaTyCejMADvFa5bd.jpg\"},\"old\":{\"image_path\":\"http:\\/\\/localhost\\/storage\\/gallery\\/Plz2xW9lUi8wrBIVrf7M2OwdGaTyCejMADvFa5bd.jpg\"}}',NULL,'2026-09-09 21:07:00','2026-09-09 21:07:00'),(59,'gallery','updated','App\\Models\\Gallery',6,'updated',NULL,NULL,'{\"attributes\":{\"image_path\":\"http:\\/\\/localhost:8000\\/storage\\/gallery\\/zpf5JdTUPILG4dFbsakWH6IwU3ikWYKx3jZRgFik.jpg\"},\"old\":{\"image_path\":\"http:\\/\\/localhost\\/storage\\/gallery\\/zpf5JdTUPILG4dFbsakWH6IwU3ikWYKx3jZRgFik.jpg\"}}',NULL,'2026-09-09 21:07:00','2026-09-09 21:07:00'),(60,'gallery','updated','App\\Models\\Gallery',7,'updated',NULL,NULL,'{\"attributes\":{\"image_path\":\"http:\\/\\/localhost:8000\\/storage\\/gallery\\/4xSncN4b6mNh9She0zoeGb7DH0Ukc9C6TpEO6pPY.jpg\"},\"old\":{\"image_path\":\"http:\\/\\/localhost\\/storage\\/gallery\\/4xSncN4b6mNh9She0zoeGb7DH0Ukc9C6TpEO6pPY.jpg\"}}',NULL,'2026-09-09 21:07:00','2026-09-09 21:07:00'),(61,'gallery','updated','App\\Models\\Gallery',8,'updated',NULL,NULL,'{\"attributes\":{\"image_path\":\"http:\\/\\/localhost:8000\\/storage\\/gallery\\/aIvqOWP2KAI5qJDiwPab7x2zG6jhoMwRvLOlYEAF.jpg\"},\"old\":{\"image_path\":\"http:\\/\\/localhost\\/storage\\/gallery\\/aIvqOWP2KAI5qJDiwPab7x2zG6jhoMwRvLOlYEAF.jpg\"}}',NULL,'2026-09-09 21:07:00','2026-09-09 21:07:00'),(62,'gallery','updated','App\\Models\\Gallery',9,'updated',NULL,NULL,'{\"attributes\":{\"image_path\":\"http:\\/\\/localhost:8000\\/storage\\/gallery\\/ODsZbbe6qtFyfuX1t0rToMzatKvmrWMJymOpUjM0.jpg\"},\"old\":{\"image_path\":\"http:\\/\\/localhost\\/storage\\/gallery\\/ODsZbbe6qtFyfuX1t0rToMzatKvmrWMJymOpUjM0.jpg\"}}',NULL,'2026-09-09 21:07:00','2026-09-09 21:07:00'),(63,'media','updated','App\\Models\\Media',2,'updated',NULL,NULL,'{\"attributes\":[],\"old\":[]}',NULL,'2026-09-09 21:07:00','2026-09-09 21:07:00'),(64,'menu-items','updated','App\\Models\\MenuItem',1,'updated',NULL,NULL,'{\"attributes\":{\"image\":\"http:\\/\\/localhost:8000\\/storage\\/media\\/2026\\/09\\/aa2e0ede-471b-48f8-8583-7815a6d62319.webp\"},\"old\":{\"image\":\"http:\\/\\/localhost\\/storage\\/media\\/2026\\/09\\/aa2e0ede-471b-48f8-8583-7815a6d62319.webp\"}}',NULL,'2026-09-09 21:07:55','2026-09-09 21:07:55'),(65,'gallery','created','App\\Models\\Gallery',10,'created','App\\Models\\User',1,'{\"attributes\":{\"title\":null,\"category\":\"food\",\"image_path\":\"http:\\/\\/localhost:8000\\/storage\\/gallery\\/GpijbyTW7bFu4n2HDwJEmaXr69FCP5MEbtoRTnMj.png\",\"sort_order\":0}}',NULL,'2026-09-09 21:11:44','2026-09-09 21:11:44'),(66,'gallery','deleted','App\\Models\\Gallery',10,'deleted','App\\Models\\User',1,'{\"old\":{\"title\":null,\"category\":\"food\",\"image_path\":\"http:\\/\\/localhost:8000\\/storage\\/gallery\\/GpijbyTW7bFu4n2HDwJEmaXr69FCP5MEbtoRTnMj.png\",\"sort_order\":0}}',NULL,'2026-09-09 21:11:47','2026-09-09 21:11:47'),(67,'media','created','App\\Models\\Media',3,'created','App\\Models\\User',1,'{\"attributes\":{\"original_name\":\"home Banner.webp\",\"folder_id\":null,\"alt_text\":null}}',NULL,'2026-09-09 21:41:52','2026-09-09 21:41:52'),(68,'menu-items','updated','App\\Models\\MenuItem',6,'updated','App\\Models\\User',1,'{\"attributes\":{\"image\":\"http:\\/\\/localhost:8000\\/storage\\/media\\/2026\\/09\\/95da4aeb-29be-469c-aaef-eff14ef783d6.webp\"},\"old\":{\"image\":null}}',NULL,'2026-09-09 21:41:53','2026-09-09 21:41:53'),(69,'homepage-cms','deleted','App\\Models\\ContentBlock',1,'deleted','App\\Models\\User',1,'{\"old\":{\"section_key\":\"hero_slide\",\"sort_order\":1,\"is_active\":true,\"data\":{\"heading_en\":\"Authentic Eastern Flavors\",\"cta_link\":\"\\/reservations\",\"eyebrow_ar\":\"\\u062c\\u0645\\u0631\\u0629\",\"subtitle_en\":\"Fresh sandwiches and grills made to order in New Cairo and Shorouk \\u2014 bold flavors, warm hospitality.\",\"image_url\":\"\\/images\\/hero.jpg\",\"eyebrow_en\":\"JAMRA\",\"subtitle_ar\":\"\\u0633\\u0627\\u0646\\u062f\\u0648\\u062a\\u0634\\u0627\\u062a \\u0648\\u0645\\u0634\\u0648\\u064a\\u0627\\u062a \\u0637\\u0627\\u0632\\u062c\\u0629 \\u062a\\u064f\\u062d\\u0636\\u064e\\u0651\\u0631 \\u0639\\u0646\\u062f \\u0627\\u0644\\u0637\\u0644\\u0628 \\u0641\\u064a \\u0627\\u0644\\u0642\\u0627\\u0647\\u0631\\u0629 \\u0627\\u0644\\u062c\\u062f\\u064a\\u062f\\u0629 \\u0648\\u0627\\u0644\\u0634\\u0631\\u0648\\u0642 \\u2014 \\u0646\\u0643\\u0647\\u0627\\u062a \\u0642\\u0648\\u064a\\u0629 \\u0648\\u0636\\u064a\\u0627\\u0641\\u0629 \\u062f\\u0627\\u0641\\u0626\\u0629.\",\"cta_label_en\":\"Book a Table\",\"cta_label_ar\":\"\\u0627\\u062d\\u062c\\u0632 \\u0637\\u0627\\u0648\\u0644\\u062a\\u0643\",\"heading_ar\":\"\\u0646\\u0643\\u0647\\u0627\\u062a \\u0634\\u0631\\u0642\\u064a\\u0629 \\u0623\\u0635\\u064a\\u0644\\u0629\"}}}',NULL,'2026-09-09 22:04:04','2026-09-09 22:04:04'),(70,'homepage-cms','deleted','App\\Models\\ContentBlock',2,'deleted','App\\Models\\User',1,'{\"old\":{\"section_key\":\"hero_slide\",\"sort_order\":2,\"is_active\":true,\"data\":{\"heading_en\":\"Grills & Sandwiches Made to Order\",\"cta_link\":\"\\/menu\",\"eyebrow_ar\":\"\\u0637\\u0627\\u0632\\u062c \\u0648\\u062c\\u0631\\u064a\\u0621\",\"subtitle_en\":\"From shawarma to mixed grills, every plate is crafted with bold, authentic flavors.\",\"image_url\":\"\\/images\\/gallery-1.jpg\",\"eyebrow_en\":\"Fresh & Bold\",\"subtitle_ar\":\"\\u0645\\u0646 \\u0627\\u0644\\u0634\\u0627\\u0648\\u0631\\u0645\\u0627 \\u0625\\u0644\\u0649 \\u0627\\u0644\\u0645\\u0634\\u0648\\u064a\\u0627\\u062a \\u0627\\u0644\\u0645\\u0634\\u0643\\u0644\\u0629\\u060c \\u0643\\u0644 \\u0637\\u0628\\u0642 \\u064a\\u064f\\u062d\\u0636\\u064e\\u0651\\u0631 \\u0628\\u0646\\u0643\\u0647\\u0627\\u062a \\u0623\\u0635\\u064a\\u0644\\u0629 \\u0642\\u0648\\u064a\\u0629.\",\"cta_label_en\":\"View Menu\",\"cta_label_ar\":\"\\u0639\\u0631\\u0636 \\u0627\\u0644\\u0642\\u0627\\u0626\\u0645\\u0629\",\"heading_ar\":\"\\u0645\\u0634\\u0648\\u064a\\u0627\\u062a \\u0648\\u0633\\u0627\\u0646\\u062f\\u0648\\u062a\\u0634\\u0627\\u062a \\u062a\\u064f\\u062d\\u0636\\u064e\\u0651\\u0631 \\u0639\\u0646\\u062f \\u0627\\u0644\\u0637\\u0644\\u0628\"}}}',NULL,'2026-09-09 22:04:07','2026-09-09 22:04:07'),(71,'homepage-cms','deleted','App\\Models\\ContentBlock',3,'deleted','App\\Models\\User',1,'{\"old\":{\"section_key\":\"hero_slide\",\"sort_order\":3,\"is_active\":true,\"data\":{\"heading_en\":\"A Space to Belong\",\"cta_link\":\"\\/gallery\",\"eyebrow_ar\":\"\\u0636\\u064a\\u0627\\u0641\\u0629 \\u062f\\u0627\\u0641\\u0626\\u0629\",\"subtitle_en\":\"Step inside a space designed for long conversations and great food.\",\"image_url\":\"\\/images\\/gallery-2.jpg\",\"eyebrow_en\":\"Warm Hospitality\",\"subtitle_ar\":\"\\u0627\\u062f\\u062e\\u0644 \\u0625\\u0644\\u0649 \\u0645\\u0633\\u0627\\u062d\\u0629 \\u0635\\u064f\\u0645\\u0645\\u062a \\u0644\\u0644\\u0623\\u062d\\u0627\\u062f\\u064a\\u062b \\u0627\\u0644\\u0637\\u0648\\u064a\\u0644\\u0629 \\u0648\\u0627\\u0644\\u0637\\u0639\\u0627\\u0645 \\u0627\\u0644\\u0631\\u0627\\u0626\\u0639.\",\"cta_label_en\":\"Explore Gallery\",\"cta_label_ar\":\"\\u0627\\u0633\\u062a\\u0643\\u0634\\u0641 \\u0627\\u0644\\u0645\\u0639\\u0631\\u0636\",\"heading_ar\":\"\\u0645\\u0633\\u0627\\u062d\\u0629 \\u062a\\u0646\\u062a\\u0645\\u064a \\u0625\\u0644\\u064a\\u0647\\u0627\"}}}',NULL,'2026-09-09 22:04:10','2026-09-09 22:04:10'),(72,'homepage-cms','deleted','App\\Models\\ContentBlock',5,'deleted','App\\Models\\User',1,'{\"old\":{\"section_key\":\"why_choose_us_heading\",\"sort_order\":0,\"is_active\":true,\"data\":{\"eyebrow_ar\":\"\\u0644\\u0645\\u0627\\u0630\\u0627 \\u062c\\u0645\\u0631\\u0629\",\"heading_en\":\"Why Guests Choose Us\",\"subtitle_ar\":\"\\u0627\\u0644\\u062a\\u0641\\u0627\\u0635\\u064a\\u0644 \\u0627\\u0644\\u062a\\u064a \\u062a\\u062d\\u0648\\u0651\\u0644 \\u0627\\u0644\\u0632\\u064a\\u0627\\u0631\\u0629 \\u0627\\u0644\\u0628\\u0633\\u064a\\u0637\\u0629 \\u0625\\u0644\\u0649 \\u0639\\u0627\\u062f\\u0629 \\u064a\\u0648\\u0645\\u064a\\u0629.\",\"eyebrow_en\":\"Why JAMRA\",\"heading_ar\":\"\\u0644\\u0645\\u0627\\u0630\\u0627 \\u064a\\u062e\\u062a\\u0627\\u0631\\u0646\\u0627 \\u0636\\u064a\\u0648\\u0641\\u0646\\u0627\",\"subtitle_en\":\"The details that turn a simple visit into a ritual.\"}}}',NULL,'2026-09-09 22:04:13','2026-09-09 22:04:13'),(73,'homepage-cms','deleted','App\\Models\\ContentBlock',6,'deleted','App\\Models\\User',1,'{\"old\":{\"section_key\":\"why_choose_us_item\",\"sort_order\":1,\"is_active\":true,\"data\":{\"title_en\":\"Authentic Recipes\",\"description_ar\":\"\\u0648\\u0635\\u0641\\u0627\\u062a \\u0634\\u0631\\u0642\\u064a\\u0629 \\u062a\\u0642\\u0644\\u064a\\u062f\\u064a\\u0629 \\u062a\\u0648\\u0627\\u0631\\u062b\\u0646\\u0627\\u0647\\u0627 \\u0628\\u0639\\u0646\\u0627\\u064a\\u0629.\",\"title_ar\":\"\\u0648\\u0635\\u0641\\u0627\\u062a \\u0623\\u0635\\u064a\\u0644\\u0629\",\"description_en\":\"Traditional Eastern recipes passed down with care.\",\"icon\":\"flame\"}}}',NULL,'2026-09-09 22:04:15','2026-09-09 22:04:15'),(74,'homepage-cms','deleted','App\\Models\\ContentBlock',7,'deleted','App\\Models\\User',1,'{\"old\":{\"section_key\":\"why_choose_us_item\",\"sort_order\":2,\"is_active\":true,\"data\":{\"title_en\":\"Fresh Ingredients\",\"description_ar\":\"\\u062a\\u064f\\u062e\\u062a\\u0627\\u0631 \\u064a\\u0648\\u0645\\u064a\\u064b\\u0627 \\u0645\\u0646 \\u0645\\u0648\\u0631\\u062f\\u064a\\u0646 \\u0645\\u062d\\u0644\\u064a\\u064a\\u0646 \\u0645\\u0648\\u062b\\u0648\\u0642\\u064a\\u0646.\",\"title_ar\":\"\\u0645\\u0643\\u0648\\u0646\\u0627\\u062a \\u0637\\u0627\\u0632\\u062c\\u0629\",\"description_en\":\"Sourced daily from trusted local suppliers.\",\"icon\":\"leaf\"}}}',NULL,'2026-09-09 22:04:18','2026-09-09 22:04:18'),(75,'homepage-cms','deleted','App\\Models\\ContentBlock',8,'deleted','App\\Models\\User',1,'{\"old\":{\"section_key\":\"why_choose_us_item\",\"sort_order\":3,\"is_active\":true,\"data\":{\"title_en\":\"Warm Hospitality\",\"description_ar\":\"\\u0643\\u0644 \\u0636\\u064a\\u0641 \\u064a\\u064f\\u0633\\u062a\\u0642\\u0628\\u0644 \\u0648\\u0643\\u0623\\u0646\\u0647 \\u0645\\u0646 \\u0627\\u0644\\u0639\\u0627\\u0626\\u0644\\u0629.\",\"title_ar\":\"\\u0636\\u064a\\u0627\\u0641\\u0629 \\u062f\\u0627\\u0641\\u0626\\u0629\",\"description_en\":\"Every guest is welcomed like family.\",\"icon\":\"heart\"}}}',NULL,'2026-09-09 22:04:20','2026-09-09 22:04:20'),(76,'homepage-cms','deleted','App\\Models\\ContentBlock',9,'deleted','App\\Models\\User',1,'{\"old\":{\"section_key\":\"why_choose_us_item\",\"sort_order\":4,\"is_active\":true,\"data\":{\"title_en\":\"Fast & Fresh\",\"description_ar\":\"\\u064a\\u064f\\u062d\\u0636\\u064e\\u0651\\u0631 \\u0639\\u0646\\u062f \\u0627\\u0644\\u0637\\u0644\\u0628 \\u0648\\u064a\\u064f\\u0642\\u062f\\u064e\\u0651\\u0645 \\u0633\\u0627\\u062e\\u0646\\u064b\\u0627 \\u0641\\u064a \\u0643\\u0644 \\u0645\\u0631\\u0629.\",\"title_ar\":\"\\u0633\\u0631\\u064a\\u0639 \\u0648\\u0637\\u0627\\u0632\\u062c\",\"description_en\":\"Made to order, served hot, every time.\",\"icon\":\"clock\"}}}',NULL,'2026-09-09 22:04:23','2026-09-09 22:04:23'),(77,'homepage-cms','deleted','App\\Models\\ContentBlock',10,'deleted','App\\Models\\User',1,'{\"old\":{\"section_key\":\"featured_menu\",\"sort_order\":0,\"is_active\":true,\"data\":{\"heading_ar\":\"\\u0645\\u0646 \\u0645\\u0637\\u0628\\u062e\\u0646\\u0627 \\u0625\\u0644\\u0649 \\u0645\\u0627\\u0626\\u062f\\u062a\\u0643\",\"heading_en\":\"From Our Kitchen to Your Table\",\"eyebrow_ar\":\"\\u0645\\u062e\\u062a\\u0627\\u0631\\u0627\\u062a \\u062e\\u0627\\u0635\\u0629\",\"eyebrow_en\":\"Handpicked\"}}}',NULL,'2026-09-09 22:04:26','2026-09-09 22:04:26'),(78,'homepage-cms','deleted','App\\Models\\ContentBlock',11,'deleted','App\\Models\\User',1,'{\"old\":{\"section_key\":\"gallery_preview\",\"sort_order\":0,\"is_active\":true,\"data\":{\"heading_ar\":\"\\u0644\\u0645\\u062d\\u0629 \\u0645\\u0646 \\u0627\\u0644\\u062a\\u062c\\u0631\\u0628\\u0629\",\"heading_en\":\"A Glimpse of the Experience\",\"eyebrow_ar\":\"\\u062f\\u0627\\u062e\\u0644 \\u062c\\u0645\\u0631\\u0629\",\"eyebrow_en\":\"Inside JAMRA\"}}}',NULL,'2026-09-09 22:04:28','2026-09-09 22:04:28'),(79,'homepage-cms','deleted','App\\Models\\ContentBlock',12,'deleted','App\\Models\\User',1,'{\"old\":{\"section_key\":\"video_section\",\"sort_order\":0,\"is_active\":true,\"data\":{\"eyebrow_ar\":\"\\u062a\\u062c\\u0631\\u0628\\u0629 \\u062c\\u0645\\u0631\\u0629\",\"heading_en\":\"A Taste of the Atmosphere\",\"video_url\":\"\\/videos\\/atmosphere.mp4\",\"eyebrow_en\":\"The JAMRA Experience\",\"heading_ar\":\"\\u0644\\u0645\\u062d\\u0629 \\u0645\\u0646 \\u0627\\u0644\\u0623\\u062c\\u0648\\u0627\\u0621\",\"poster_image_url\":\"\\/images\\/gallery-1.jpg\"}}}',NULL,'2026-09-09 22:04:31','2026-09-09 22:04:31'),(80,'homepage-cms','deleted','App\\Models\\ContentBlock',13,'deleted','App\\Models\\User',1,'{\"old\":{\"section_key\":\"testimonials_section\",\"sort_order\":0,\"is_active\":true,\"data\":{\"heading_ar\":\"\\u0645\\u0627\\u0630\\u0627 \\u064a\\u0642\\u0648\\u0644 \\u0627\\u0644\\u0646\\u0627\\u0633\",\"heading_en\":\"What People Are Saying\",\"eyebrow_ar\":\"\\u0622\\u0631\\u0627\\u0621 \\u0627\\u0644\\u0636\\u064a\\u0648\\u0641\",\"eyebrow_en\":\"Testimonials\"}}}',NULL,'2026-09-09 22:04:33','2026-09-09 22:04:33'),(81,'homepage-cms','deleted','App\\Models\\ContentBlock',14,'deleted','App\\Models\\User',1,'{\"old\":{\"section_key\":\"reservation_cta\",\"sort_order\":0,\"is_active\":true,\"data\":{\"cta_label_en\":\"Reserve a Table\",\"heading_en\":\"Your Table Is Waiting\",\"subtitle_ar\":\"\\u0627\\u062d\\u062c\\u0632 \\u0641\\u064a \\u0623\\u0642\\u0644 \\u0645\\u0646 \\u062f\\u0642\\u064a\\u0642\\u0629 \\u0648\\u062f\\u0639\\u0646\\u0627 \\u0646\\u0647\\u062a\\u0645 \\u0628\\u0627\\u0644\\u0628\\u0627\\u0642\\u064a.\",\"cta_label_ar\":\"\\u0627\\u062d\\u062c\\u0632 \\u0637\\u0627\\u0648\\u0644\\u062a\\u0643\",\"heading_ar\":\"\\u0637\\u0627\\u0648\\u0644\\u062a\\u0643 \\u0641\\u064a \\u0627\\u0646\\u062a\\u0638\\u0627\\u0631\\u0643\",\"subtitle_en\":\"Reserve in less than a minute and let us take care of the rest.\"}}}',NULL,'2026-09-09 22:04:36','2026-09-09 22:04:36'),(82,'homepage-cms','deleted','App\\Models\\ContentBlock',15,'deleted','App\\Models\\User',1,'{\"old\":{\"section_key\":\"footer\",\"sort_order\":0,\"is_active\":true,\"data\":{\"tagline_ar\":\"\\u0646\\u0643\\u0647\\u0627\\u062a \\u0634\\u0631\\u0642\\u064a\\u0629 \\u0623\\u0635\\u064a\\u0644\\u0629\\u060c \\u0635\\u064f\\u0646\\u0639\\u062a \\u0628\\u062f\\u0641\\u0621 \\u0648\\u0634\\u063a\\u0641.\",\"tagline_en\":\"Authentic Eastern flavors, crafted with warmth.\"}}}',NULL,'2026-09-09 22:04:39','2026-09-09 22:04:39'),(83,'homepage-cms','deleted','App\\Models\\ContentBlock',16,'deleted','App\\Models\\User',1,'{\"old\":{\"section_key\":\"events_heading\",\"sort_order\":0,\"is_active\":true,\"data\":{\"eyebrow_ar\":\"\\u0627\\u062d\\u062a\\u0641\\u0644 \\u0645\\u0639\\u0646\\u0627\",\"heading_en\":\"Moments Made for Sharing\",\"subtitle_ar\":\"\\u0645\\u0646 \\u0623\\u0639\\u064a\\u0627\\u062f \\u0627\\u0644\\u0645\\u064a\\u0644\\u0627\\u062f \\u0625\\u0644\\u0649 \\u0644\\u064a\\u0627\\u0644\\u064a \\u0627\\u0644\\u0645\\u0628\\u0627\\u0631\\u064a\\u0627\\u062a\\u060c \\u0646\\u062c\\u0647\\u0632 \\u0627\\u0644\\u0645\\u0643\\u0627\\u0646 \\u0644\\u062a\\u062c\\u0645\\u0639\\u0627\\u062a\\u0643.\",\"eyebrow_en\":\"Celebrate With Us\",\"heading_ar\":\"\\u0644\\u062d\\u0638\\u0627\\u062a \\u0635\\u064f\\u0646\\u0639\\u062a \\u0644\\u062a\\u064f\\u0634\\u0627\\u0631\\u0643\",\"subtitle_en\":\"From birthdays to match nights, we set the scene for your gatherings.\"}}}',NULL,'2026-09-09 22:04:42','2026-09-09 22:04:42'),(84,'homepage-cms','deleted','App\\Models\\ContentBlock',17,'deleted','App\\Models\\User',1,'{\"old\":{\"section_key\":\"event_item\",\"sort_order\":1,\"is_active\":true,\"data\":{\"title_en\":\"Birthday Celebrations\",\"description_ar\":\"\\u062a\\u062c\\u0647\\u064a\\u0632\\u0627\\u062a \\u0645\\u062e\\u0635\\u0635\\u0629 \\u0648\\u0631\\u0643\\u0646 \\u0645\\u062b\\u0627\\u0644\\u064a \\u0644\\u0644\\u0627\\u062d\\u062a\\u0641\\u0627\\u0644 \\u0628\\u064a\\u0648\\u0645\\u0643 \\u0627\\u0644\\u0645\\u0645\\u064a\\u0632.\",\"description_en\":\"Custom setups and a cake-worthy corner for your special day.\",\"title_ar\":\"\\u0623\\u0639\\u064a\\u0627\\u062f \\u0627\\u0644\\u0645\\u064a\\u0644\\u0627\\u062f\",\"image_url\":\"\\/images\\/gallery-3.jpg\"}}}',NULL,'2026-09-09 22:04:44','2026-09-09 22:04:44'),(85,'homepage-cms','deleted','App\\Models\\ContentBlock',18,'deleted','App\\Models\\User',1,'{\"old\":{\"section_key\":\"event_item\",\"sort_order\":2,\"is_active\":true,\"data\":{\"title_en\":\"Live Match Nights\",\"description_ar\":\"\\u0634\\u0627\\u0634\\u0627\\u062a \\u0643\\u0628\\u064a\\u0631\\u0629 \\u0648\\u0645\\u0642\\u0628\\u0644\\u0627\\u062a \\u0623\\u0643\\u0628\\u0631 \\u2014 \\u0634\\u0627\\u0647\\u062f \\u0643\\u0644 \\u0645\\u0628\\u0627\\u0631\\u0627\\u0629 \\u0645\\u0639 \\u0623\\u0635\\u062f\\u0642\\u0627\\u0626\\u0643.\",\"description_en\":\"Big screens, bigger snacks \\u2014 catch every match with friends.\",\"title_ar\":\"\\u0644\\u064a\\u0627\\u0644\\u064a \\u0627\\u0644\\u0645\\u0628\\u0627\\u0631\\u064a\\u0627\\u062a\",\"image_url\":\"\\/images\\/gallery-4.jpg\"}}}',NULL,'2026-09-09 22:04:47','2026-09-09 22:04:47'),(86,'homepage-cms','deleted','App\\Models\\ContentBlock',19,'deleted','App\\Models\\User',1,'{\"old\":{\"section_key\":\"event_item\",\"sort_order\":3,\"is_active\":true,\"data\":{\"title_en\":\"Live Music Evenings\",\"description_ar\":\"\\u0639\\u0632\\u0641 \\u062d\\u064a \\u0648\\u0625\\u0636\\u0627\\u0621\\u0629 \\u0647\\u0627\\u062f\\u0626\\u0629 \\u0644\\u0633\\u0647\\u0631\\u0629 \\u0644\\u0627 \\u062a\\u064f\\u0646\\u0633\\u0649.\",\"description_en\":\"Acoustic sets and soft lighting for an unforgettable evening.\",\"title_ar\":\"\\u0623\\u0645\\u0633\\u064a\\u0627\\u062a \\u0645\\u0648\\u0633\\u064a\\u0642\\u064a\\u0629\",\"image_url\":\"\\/images\\/gallery-5.jpg\"}}}',NULL,'2026-09-09 22:04:49','2026-09-09 22:04:49'),(87,'homepage-cms','deleted','App\\Models\\ContentBlock',20,'deleted','App\\Models\\User',1,'{\"old\":{\"section_key\":\"event_item\",\"sort_order\":4,\"is_active\":true,\"data\":{\"title_en\":\"Private Dinners & Events\",\"description_ar\":\"\\u0627\\u062d\\u062c\\u0632 \\u0627\\u0644\\u0645\\u0643\\u0627\\u0646 \\u0644\\u0644\\u0630\\u0643\\u0631\\u0649 \\u0627\\u0644\\u0633\\u0646\\u0648\\u064a\\u0629 \\u0623\\u0648 \\u0627\\u0644\\u062a\\u062c\\u0645\\u0639\\u0627\\u062a \\u0623\\u0648 \\u0623\\u0645\\u0633\\u064a\\u0627\\u062a \\u0627\\u0644\\u0634\\u0631\\u0643\\u0627\\u062a.\",\"description_en\":\"Book the space for anniversaries, gatherings, or company nights.\",\"title_ar\":\"\\u0639\\u0634\\u0627\\u0621\\u0627\\u062a \\u0648\\u0645\\u0646\\u0627\\u0633\\u0628\\u0627\\u062a \\u062e\\u0627\\u0635\\u0629\",\"image_url\":\"\\/images\\/gallery-6.jpg\"}}}',NULL,'2026-09-09 22:04:52','2026-09-09 22:04:52'),(88,'homepage-cms','deleted','App\\Models\\ContentBlock',21,'deleted','App\\Models\\User',1,'{\"old\":{\"section_key\":\"seo_home\",\"sort_order\":0,\"is_active\":true,\"data\":{\"robots\":\"index, follow\",\"seo_description_ar\":\"\\u064a\\u0642\\u062f\\u0645 \\u0645\\u0637\\u0639\\u0645 \\u062c\\u0645\\u0631\\u0629 \\u0623\\u0641\\u0636\\u0644 \\u0627\\u0644\\u0633\\u0627\\u0646\\u062f\\u0648\\u062a\\u0634\\u0627\\u062a \\u0648\\u0627\\u0644\\u0645\\u0634\\u0648\\u064a\\u0627\\u062a \\u0627\\u0644\\u0634\\u0631\\u0642\\u064a\\u0629 \\u0641\\u064a \\u0627\\u0644\\u0642\\u0627\\u0647\\u0631\\u0629 \\u0627\\u0644\\u062c\\u062f\\u064a\\u062f\\u0629 \\u0648\\u0627\\u0644\\u0634\\u0631\\u0648\\u0642 \\u2014 \\u0637\\u0627\\u0632\\u062c\\u0629 \\u0648\\u0633\\u0631\\u064a\\u0639\\u0629 \\u0648\\u0645\\u0644\\u064a\\u0626\\u0629 \\u0628\\u0627\\u0644\\u0646\\u0643\\u0647\\u0629.\",\"canonical_url\":null,\"seo_keywords_en\":\"JAMRA, restaurant, Eastern food, sandwiches, grills, shawarma, New Cairo, Shorouk\",\"seo_description_en\":\"JAMRA serves the best Eastern sandwiches and grills in New Cairo and Shorouk \\u2014 fresh, fast, and full of flavor.\",\"seo_keywords_ar\":\"\\u062c\\u0645\\u0631\\u0629, \\u0645\\u0637\\u0639\\u0645, \\u0637\\u0639\\u0627\\u0645 \\u0634\\u0631\\u0642\\u064a, \\u0633\\u0627\\u0646\\u062f\\u0648\\u062a\\u0634\\u0627\\u062a, \\u0645\\u0634\\u0648\\u064a\\u0627\\u062a, \\u0634\\u0627\\u0648\\u0631\\u0645\\u0627, \\u0627\\u0644\\u0642\\u0627\\u0647\\u0631\\u0629 \\u0627\\u0644\\u062c\\u062f\\u064a\\u062f\\u0629, \\u0627\\u0644\\u0634\\u0631\\u0648\\u0642\",\"seo_title_en\":\"JAMRA Restaurant | Authentic Eastern Sandwiches & Grills\",\"seo_title_ar\":\"\\u0645\\u0637\\u0639\\u0645 \\u062c\\u0645\\u0631\\u0629 | \\u0633\\u0627\\u0646\\u062f\\u0648\\u062a\\u0634\\u0627\\u062a \\u0648\\u0645\\u0634\\u0648\\u064a\\u0627\\u062a \\u0634\\u0631\\u0642\\u064a\\u0629 \\u0623\\u0635\\u064a\\u0644\\u0629\",\"og_image_url\":\"\\/images\\/hero.jpg\"}}}',NULL,'2026-09-09 22:04:55','2026-09-09 22:04:55'),(89,'homepage-cms','created','App\\Models\\ContentBlock',22,'created','App\\Models\\User',1,'{\"attributes\":{\"section_key\":\"hero\",\"sort_order\":0,\"is_active\":true,\"data\":{\"subtitle_en\":\"The best Eastern sandwiches and grills in New Cairo and Shorouk \\u2014 fresh ingredients, bold flavors, and warm hospitality.\",\"badge_ar\":\"\\u0645\\u0641\\u062a\\u0648\\u062d \\u0627\\u0644\\u0622\\u0646\",\"poster_image_url\":\"\\/images\\/hero.jpg\",\"badge_en\":\"Open Now\",\"title_en\":\"JAMRA\",\"subtitle_ar\":\"\\u0623\\u0641\\u0636\\u0644 \\u0633\\u0627\\u0646\\u062f\\u0648\\u062a\\u0634\\u0627\\u062a \\u0648\\u0645\\u0634\\u0648\\u064a\\u0627\\u062a \\u0634\\u0631\\u0642\\u064a\\u0629 \\u0641\\u064a \\u0627\\u0644\\u0642\\u0627\\u0647\\u0631\\u0629 \\u0627\\u0644\\u062c\\u062f\\u064a\\u062f\\u0629 \\u0648\\u0627\\u0644\\u0634\\u0631\\u0648\\u0642 \\u2014 \\u0645\\u0643\\u0648\\u0646\\u0627\\u062a \\u0637\\u0627\\u0632\\u062c\\u0629 \\u0648\\u0646\\u0643\\u0647\\u0627\\u062a \\u0642\\u0648\\u064a\\u0629 \\u0648\\u0636\\u064a\\u0627\\u0641\\u0629 \\u062f\\u0627\\u0641\\u0626\\u0629.\",\"title_ar\":\"\\u062c\\u0645\\u0631\\u0629\",\"video_url\":\"https:\\/\\/cdn.coverr.co\\/videos\\/coverr-chef-cooking-in-a-restaurant-3327\\/1080p.mp4\"}}}',NULL,'2026-09-09 22:19:32','2026-09-09 22:19:32'),(90,'reservations','created','App\\Models\\Reservation',1,'created',NULL,NULL,'{\"attributes\":{\"user_id\":null,\"full_name\":\"Test User\",\"phone\":\"+20 100 000 0000\",\"email\":null,\"guests_count\":2,\"date\":\"2026-09-15T00:00:00.000000Z\",\"time\":\"14:00:00\",\"notes\":\"window seat\",\"status\":\"pending\"}}',NULL,'2026-09-09 22:46:59','2026-09-09 22:46:59'),(91,'reservations','created','App\\Models\\Reservation',2,'created',NULL,NULL,'{\"attributes\":{\"user_id\":null,\"full_name\":\"FastBot\",\"phone\":\"123\",\"email\":null,\"guests_count\":2,\"date\":\"2026-09-15T00:00:00.000000Z\",\"time\":\"14:00:00\",\"notes\":null,\"status\":\"pending\"}}',NULL,'2026-09-09 22:47:04','2026-09-09 22:47:04'),(92,'reservations','created','App\\Models\\Reservation',3,'created',NULL,NULL,'{\"attributes\":{\"user_id\":null,\"full_name\":\"TwelveHour\",\"phone\":\"+20 100 000 0001\",\"email\":\"x@y.com\",\"guests_count\":3,\"date\":\"2026-09-16T00:00:00.000000Z\",\"time\":\"14:00:00\",\"notes\":null,\"status\":\"pending\"}}',NULL,'2026-09-09 22:47:08','2026-09-09 22:47:08'),(93,'reservations','created','App\\Models\\Reservation',4,'created',NULL,NULL,'{\"attributes\":{\"user_id\":null,\"full_name\":\"FastBot2\",\"phone\":\"123\",\"email\":null,\"guests_count\":2,\"date\":\"2026-09-20T00:00:00.000000Z\",\"time\":\"14:00:00\",\"notes\":null,\"status\":\"pending\"}}',NULL,'2026-09-09 22:50:06','2026-09-09 22:50:06'),(94,'reservations','created','App\\Models\\Reservation',5,'created',NULL,NULL,'{\"attributes\":{\"user_id\":null,\"full_name\":\"SlowUser\",\"phone\":\"+20 100 000 0002\",\"email\":null,\"guests_count\":4,\"date\":\"2026-09-21T00:00:00.000000Z\",\"time\":\"19:30:00\",\"notes\":null,\"status\":\"pending\"}}',NULL,'2026-09-09 22:50:09','2026-09-09 22:50:09'),(95,'reservations','created','App\\Models\\Reservation',6,'created',NULL,NULL,'{\"attributes\":{\"user_id\":null,\"full_name\":\"DebugBot\",\"phone\":\"1\",\"email\":null,\"guests_count\":2,\"date\":\"2026-09-20T00:00:00.000000Z\",\"time\":\"14:00:00\",\"notes\":null,\"status\":\"pending\"}}',NULL,'2026-09-09 22:51:57','2026-09-09 22:51:57'),(96,'reservations','created','App\\Models\\Reservation',7,'created',NULL,NULL,'{\"attributes\":{\"user_id\":null,\"full_name\":\"SlowUser2\",\"phone\":\"+20 100 000 0003\",\"email\":null,\"guests_count\":4,\"date\":\"2026-09-21T00:00:00.000000Z\",\"time\":\"19:30:00\",\"notes\":null,\"status\":\"pending\"}}',NULL,'2026-09-09 22:52:58','2026-09-09 22:52:58'),(97,'reservations','deleted','App\\Models\\Reservation',1,'deleted','App\\Models\\User',1,'{\"old\":{\"user_id\":null,\"full_name\":\"Test User\",\"phone\":\"+20 100 000 0000\",\"email\":null,\"guests_count\":2,\"date\":\"2026-09-15T00:00:00.000000Z\",\"time\":\"14:00:00\",\"notes\":\"window seat\",\"status\":\"pending\"}}',NULL,'2026-09-09 22:53:23','2026-09-09 22:53:23'),(98,'reservations','deleted','App\\Models\\Reservation',2,'deleted','App\\Models\\User',1,'{\"old\":{\"user_id\":null,\"full_name\":\"FastBot\",\"phone\":\"123\",\"email\":null,\"guests_count\":2,\"date\":\"2026-09-15T00:00:00.000000Z\",\"time\":\"14:00:00\",\"notes\":null,\"status\":\"pending\"}}',NULL,'2026-09-09 22:53:26','2026-09-09 22:53:26'),(99,'reservations','deleted','App\\Models\\Reservation',3,'deleted','App\\Models\\User',1,'{\"old\":{\"user_id\":null,\"full_name\":\"TwelveHour\",\"phone\":\"+20 100 000 0001\",\"email\":\"x@y.com\",\"guests_count\":3,\"date\":\"2026-09-16T00:00:00.000000Z\",\"time\":\"14:00:00\",\"notes\":null,\"status\":\"pending\"}}',NULL,'2026-09-09 22:53:28','2026-09-09 22:53:28'),(100,'reservations','deleted','App\\Models\\Reservation',4,'deleted','App\\Models\\User',1,'{\"old\":{\"user_id\":null,\"full_name\":\"FastBot2\",\"phone\":\"123\",\"email\":null,\"guests_count\":2,\"date\":\"2026-09-20T00:00:00.000000Z\",\"time\":\"14:00:00\",\"notes\":null,\"status\":\"pending\"}}',NULL,'2026-09-09 22:53:31','2026-09-09 22:53:31'),(101,'reservations','deleted','App\\Models\\Reservation',5,'deleted','App\\Models\\User',1,'{\"old\":{\"user_id\":null,\"full_name\":\"SlowUser\",\"phone\":\"+20 100 000 0002\",\"email\":null,\"guests_count\":4,\"date\":\"2026-09-21T00:00:00.000000Z\",\"time\":\"19:30:00\",\"notes\":null,\"status\":\"pending\"}}',NULL,'2026-09-09 22:53:34','2026-09-09 22:53:34'),(102,'reservations','deleted','App\\Models\\Reservation',6,'deleted','App\\Models\\User',1,'{\"old\":{\"user_id\":null,\"full_name\":\"DebugBot\",\"phone\":\"1\",\"email\":null,\"guests_count\":2,\"date\":\"2026-09-20T00:00:00.000000Z\",\"time\":\"14:00:00\",\"notes\":null,\"status\":\"pending\"}}',NULL,'2026-09-09 22:53:36','2026-09-09 22:53:36'),(103,'reservations','deleted','App\\Models\\Reservation',7,'deleted','App\\Models\\User',1,'{\"old\":{\"user_id\":null,\"full_name\":\"SlowUser2\",\"phone\":\"+20 100 000 0003\",\"email\":null,\"guests_count\":4,\"date\":\"2026-09-21T00:00:00.000000Z\",\"time\":\"19:30:00\",\"notes\":null,\"status\":\"pending\"}}',NULL,'2026-09-09 22:53:39','2026-09-09 22:53:39'),(104,'reservations','created','App\\Models\\Reservation',8,'created',NULL,NULL,'{\"attributes\":{\"user_id\":null,\"full_name\":\"Ahmed Hassan\",\"phone\":\"+20 100 555 1234\",\"email\":\"ahmed@example.com\",\"guests_count\":5,\"date\":\"2026-09-18T00:00:00.000000Z\",\"time\":\"20:30:00\",\"notes\":\"Birthday celebration, window table please\",\"status\":\"pending\"}}',NULL,'2026-09-09 22:56:10','2026-09-09 22:56:10'),(105,'reservations','deleted','App\\Models\\Reservation',8,'deleted','App\\Models\\User',1,'{\"old\":{\"user_id\":null,\"full_name\":\"Ahmed Hassan\",\"phone\":\"+20 100 555 1234\",\"email\":\"ahmed@example.com\",\"guests_count\":5,\"date\":\"2026-09-18T00:00:00.000000Z\",\"time\":\"20:30:00\",\"notes\":\"Birthday celebration, window table please\",\"status\":\"pending\"}}',NULL,'2026-09-09 22:56:16','2026-09-09 22:56:16'),(106,'reservations','created','App\\Models\\Reservation',9,'created',NULL,NULL,'{\"attributes\":{\"user_id\":null,\"full_name\":\"RateTest1\",\"phone\":\"1\",\"email\":null,\"guests_count\":2,\"date\":\"2026-09-20T00:00:00.000000Z\",\"time\":\"14:00:00\",\"notes\":null,\"status\":\"pending\"}}',NULL,'2026-09-09 22:56:41','2026-09-09 22:56:41'),(107,'reservations','created','App\\Models\\Reservation',10,'created',NULL,NULL,'{\"attributes\":{\"user_id\":null,\"full_name\":\"RateTest2\",\"phone\":\"1\",\"email\":null,\"guests_count\":2,\"date\":\"2026-09-20T00:00:00.000000Z\",\"time\":\"14:00:00\",\"notes\":null,\"status\":\"pending\"}}',NULL,'2026-09-09 22:56:44','2026-09-09 22:56:44'),(108,'reservations','created','App\\Models\\Reservation',11,'created',NULL,NULL,'{\"attributes\":{\"user_id\":null,\"full_name\":\"RateTest3\",\"phone\":\"1\",\"email\":null,\"guests_count\":2,\"date\":\"2026-09-20T00:00:00.000000Z\",\"time\":\"14:00:00\",\"notes\":null,\"status\":\"pending\"}}',NULL,'2026-09-09 22:56:46','2026-09-09 22:56:46'),(109,'reservations','created','App\\Models\\Reservation',12,'created',NULL,NULL,'{\"attributes\":{\"user_id\":null,\"full_name\":\"RateTest4\",\"phone\":\"1\",\"email\":null,\"guests_count\":2,\"date\":\"2026-09-20T00:00:00.000000Z\",\"time\":\"14:00:00\",\"notes\":null,\"status\":\"pending\"}}',NULL,'2026-09-09 22:56:49','2026-09-09 22:56:49'),(110,'reservations','created','App\\Models\\Reservation',13,'created',NULL,NULL,'{\"attributes\":{\"user_id\":null,\"full_name\":\"RateTest5\",\"phone\":\"1\",\"email\":null,\"guests_count\":2,\"date\":\"2026-09-20T00:00:00.000000Z\",\"time\":\"14:00:00\",\"notes\":null,\"status\":\"pending\"}}',NULL,'2026-09-09 22:56:52','2026-09-09 22:56:52'),(111,'reservations','deleted','App\\Models\\Reservation',9,'deleted','App\\Models\\User',1,'{\"old\":{\"user_id\":null,\"full_name\":\"RateTest1\",\"phone\":\"1\",\"email\":null,\"guests_count\":2,\"date\":\"2026-09-20T00:00:00.000000Z\",\"time\":\"14:00:00\",\"notes\":null,\"status\":\"pending\"}}',NULL,'2026-09-09 22:57:06','2026-09-09 22:57:06'),(112,'reservations','deleted','App\\Models\\Reservation',10,'deleted','App\\Models\\User',1,'{\"old\":{\"user_id\":null,\"full_name\":\"RateTest2\",\"phone\":\"1\",\"email\":null,\"guests_count\":2,\"date\":\"2026-09-20T00:00:00.000000Z\",\"time\":\"14:00:00\",\"notes\":null,\"status\":\"pending\"}}',NULL,'2026-09-09 22:57:08','2026-09-09 22:57:08'),(113,'reservations','deleted','App\\Models\\Reservation',11,'deleted','App\\Models\\User',1,'{\"old\":{\"user_id\":null,\"full_name\":\"RateTest3\",\"phone\":\"1\",\"email\":null,\"guests_count\":2,\"date\":\"2026-09-20T00:00:00.000000Z\",\"time\":\"14:00:00\",\"notes\":null,\"status\":\"pending\"}}',NULL,'2026-09-09 22:57:11','2026-09-09 22:57:11'),(114,'reservations','deleted','App\\Models\\Reservation',12,'deleted','App\\Models\\User',1,'{\"old\":{\"user_id\":null,\"full_name\":\"RateTest4\",\"phone\":\"1\",\"email\":null,\"guests_count\":2,\"date\":\"2026-09-20T00:00:00.000000Z\",\"time\":\"14:00:00\",\"notes\":null,\"status\":\"pending\"}}',NULL,'2026-09-09 22:57:14','2026-09-09 22:57:14'),(115,'reservations','deleted','App\\Models\\Reservation',13,'deleted','App\\Models\\User',1,'{\"old\":{\"user_id\":null,\"full_name\":\"RateTest5\",\"phone\":\"1\",\"email\":null,\"guests_count\":2,\"date\":\"2026-09-20T00:00:00.000000Z\",\"time\":\"14:00:00\",\"notes\":null,\"status\":\"pending\"}}',NULL,'2026-09-09 22:57:17','2026-09-09 22:57:17'); /*!40000 ALTER TABLE `activity_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache` -- DROP TABLE IF EXISTS `cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cache` -- LOCK TABLES `cache` WRITE; /*!40000 ALTER TABLE `cache` DISABLE KEYS */; /*!40000 ALTER TABLE `cache` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache_locks` -- DROP TABLE IF EXISTS `cache_locks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int(11) NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cache_locks` -- LOCK TABLES `cache_locks` WRITE; /*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */; /*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `categories` -- DROP TABLE IF EXISTS `categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `categories` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name_en` varchar(255) NOT NULL, `name_ar` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `image` varchar(255) DEFAULT NULL, `sort_order` int(10) unsigned NOT NULL DEFAULT 0, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `categories_slug_unique` (`slug`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `categories` -- LOCK TABLES `categories` WRITE; /*!40000 ALTER TABLE `categories` DISABLE KEYS */; INSERT INTO `categories` VALUES (1,'Sandwiches','ساندوتشات','sandwiches',NULL,1,1,'2026-09-09 21:00:26','2026-09-09 21:00:26'),(2,'Platters & Meals','وجبات','platters-meals',NULL,2,1,'2026-09-09 21:00:26','2026-09-09 21:00:26'),(3,'Sides','إضافات','sides',NULL,3,1,'2026-09-09 21:00:26','2026-09-09 21:00:26'),(4,'Beverages','مشروبات','beverages',NULL,4,1,'2026-09-09 21:00:26','2026-09-09 21:00:26'); /*!40000 ALTER TABLE `categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contact_messages` -- DROP TABLE IF EXISTS `contact_messages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contact_messages` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `subject` varchar(255) DEFAULT NULL, `message` text NOT NULL, `is_read` tinyint(1) NOT NULL DEFAULT 0, `replied_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contact_messages` -- LOCK TABLES `contact_messages` WRITE; /*!40000 ALTER TABLE `contact_messages` DISABLE KEYS */; /*!40000 ALTER TABLE `contact_messages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `content_blocks` -- DROP TABLE IF EXISTS `content_blocks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `content_blocks` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `section_key` varchar(255) NOT NULL, `sort_order` int(10) unsigned NOT NULL DEFAULT 0, `is_active` tinyint(1) NOT NULL DEFAULT 1, `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`data`)), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `content_blocks_section_key_index` (`section_key`) ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `content_blocks` -- LOCK TABLES `content_blocks` WRITE; /*!40000 ALTER TABLE `content_blocks` DISABLE KEYS */; INSERT INTO `content_blocks` VALUES (4,'about',0,1,'{\"eyebrow_en\":\"Our Story\",\"heading_ar\":\"\\u062d\\u0631\\u0641\\u064a\\u0629 \\u0631\\u0627\\u0633\\u062e\\u0629\\u060c \\u062a\\u064f\\u0642\\u062f\\u064e\\u0651\\u0645 \\u0628\\u0631\\u0648\\u062d\",\"body_ar\":\"\\u062c\\u0645\\u0631\\u0629 \\u0645\\u0637\\u0639\\u0645 \\u064a\\u062d\\u062a\\u0641\\u0644 \\u0628\\u0627\\u0644\\u0645\\u0637\\u0628\\u062e \\u0627\\u0644\\u0634\\u0631\\u0642\\u064a \\u0627\\u0644\\u0623\\u0635\\u064a\\u0644 \\u2014 \\u0645\\u0646 \\u0627\\u0644\\u0634\\u0627\\u0648\\u0631\\u0645\\u0627 \\u0648\\u0627\\u0644\\u0645\\u0634\\u0648\\u064a\\u0627\\u062a \\u0627\\u0644\\u062a\\u0642\\u0644\\u064a\\u062f\\u064a\\u0629 \\u0625\\u0644\\u0649 \\u0627\\u0644\\u0623\\u062c\\u0648\\u0627\\u0621 \\u0627\\u0644\\u062f\\u0627\\u0641\\u0626\\u0629 \\u0648\\u0627\\u0644\\u062a\\u0631\\u062d\\u064a\\u0628\\u064a\\u0629. \\u0643\\u0644 \\u0632\\u064a\\u0627\\u0631\\u0629 \\u0647\\u064a \\u0631\\u062d\\u0644\\u0629 \\u0641\\u064a \\u0639\\u0627\\u0644\\u0645 \\u0627\\u0644\\u0646\\u0643\\u0647\\u0627\\u062a \\u0648\\u0627\\u0644\\u0636\\u064a\\u0627\\u0641\\u0629.\",\"eyebrow_ar\":\"\\u0642\\u0635\\u062a\\u0646\\u0627\",\"stats\":[{\"value\":\"12+\",\"label\":{\"ar\":\"\\u0633\\u0646\\u0629 \\u0645\\u0646 \\u0627\\u0644\\u062d\\u0631\\u0641\\u064a\\u0629\",\"en\":\"Years of Craft\"},\"id\":\"years\"},{\"value\":\"40+\",\"label\":{\"ar\":\"\\u0637\\u0628\\u0642\\u064b\\u0627 \\u0645\\u0645\\u064a\\u0632\\u064b\\u0627\",\"en\":\"Signature Dishes\"},\"id\":\"dishes\"},{\"value\":\"4.9\",\"label\":{\"ar\":\"\\u062a\\u0642\\u064a\\u064a\\u0645 \\u0627\\u0644\\u0636\\u064a\\u0648\\u0641\",\"en\":\"Guest Rating\"},\"id\":\"rating\"}],\"body_en\":\"JAMRA is a restaurant that celebrates authentic Eastern cuisine \\u2014 from traditional shawarma and grills to a warm, welcoming atmosphere. Every visit is a journey of taste and hospitality.\",\"heading_en\":\"Rooted in Craft, Served with Soul\",\"image\":\"\\/images\\/gallery-2.jpg\"}','2026-09-09 20:48:28','2026-09-09 20:48:28'),(22,'hero',0,1,'{\"subtitle_en\":\"The best Eastern sandwiches and grills in New Cairo and Shorouk \\u2014 fresh ingredients, bold flavors, and warm hospitality.\",\"badge_ar\":\"\\u0645\\u0641\\u062a\\u0648\\u062d \\u0627\\u0644\\u0622\\u0646\",\"poster_image_url\":\"\\/images\\/hero.jpg\",\"badge_en\":\"Open Now\",\"title_en\":\"JAMRA\",\"subtitle_ar\":\"\\u0623\\u0641\\u0636\\u0644 \\u0633\\u0627\\u0646\\u062f\\u0648\\u062a\\u0634\\u0627\\u062a \\u0648\\u0645\\u0634\\u0648\\u064a\\u0627\\u062a \\u0634\\u0631\\u0642\\u064a\\u0629 \\u0641\\u064a \\u0627\\u0644\\u0642\\u0627\\u0647\\u0631\\u0629 \\u0627\\u0644\\u062c\\u062f\\u064a\\u062f\\u0629 \\u0648\\u0627\\u0644\\u0634\\u0631\\u0648\\u0642 \\u2014 \\u0645\\u0643\\u0648\\u0646\\u0627\\u062a \\u0637\\u0627\\u0632\\u062c\\u0629 \\u0648\\u0646\\u0643\\u0647\\u0627\\u062a \\u0642\\u0648\\u064a\\u0629 \\u0648\\u0636\\u064a\\u0627\\u0641\\u0629 \\u062f\\u0627\\u0641\\u0626\\u0629.\",\"title_ar\":\"\\u062c\\u0645\\u0631\\u0629\",\"video_url\":\"https:\\/\\/cdn.coverr.co\\/videos\\/coverr-chef-cooking-in-a-restaurant-3327\\/1080p.mp4\"}','2026-09-09 22:19:32','2026-09-09 22:19:32'); /*!40000 ALTER TABLE `content_blocks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `failed_jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(255) NOT NULL, `connection` text NOT NULL, `queue` text NOT NULL, `payload` longtext NOT NULL, `exception` longtext NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `galleries` -- DROP TABLE IF EXISTS `galleries`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `galleries` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `category` enum('interior','food','events','exterior') NOT NULL, `image_path` varchar(255) NOT NULL, `sort_order` int(10) unsigned NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `galleries` -- LOCK TABLES `galleries` WRITE; /*!40000 ALTER TABLE `galleries` DISABLE KEYS */; INSERT INTO `galleries` VALUES (2,'Our Space','interior','http://localhost:8000/storage/gallery/5q0RMkfzDxHNqJ0wN0TSPkRXRYCF5YKAuvxlWpEi.jpg',1,'2026-09-09 20:50:42','2026-09-09 21:07:00'),(3,'Cozy Corner','interior','http://localhost:8000/storage/gallery/HE09rQY17o0kzlCGHyZ2ARB3f1nBUSilVPRb5jG9.jpg',2,'2026-09-09 20:50:44','2026-09-09 21:07:00'),(4,'Signature Dish','food','http://localhost:8000/storage/gallery/A03XpX3MZ4mmWBaiLLoZB6B0WU4SDbY5xIMkFiAv.jpg',3,'2026-09-09 20:50:47','2026-09-09 21:07:00'),(5,'Fresh Grills','food','http://localhost:8000/storage/gallery/Plz2xW9lUi8wrBIVrf7M2OwdGaTyCejMADvFa5bd.jpg',4,'2026-09-09 20:50:50','2026-09-09 21:07:00'),(6,'Match Night','events','http://localhost:8000/storage/gallery/zpf5JdTUPILG4dFbsakWH6IwU3ikWYKx3jZRgFik.jpg',5,'2026-09-09 20:50:53','2026-09-09 21:07:00'),(7,'The Ambiance','interior','http://localhost:8000/storage/gallery/4xSncN4b6mNh9She0zoeGb7DH0Ukc9C6TpEO6pPY.jpg',6,'2026-09-09 20:50:55','2026-09-09 21:07:00'),(8,'Shawarma Platter','food','http://localhost:8000/storage/gallery/aIvqOWP2KAI5qJDiwPab7x2zG6jhoMwRvLOlYEAF.jpg',7,'2026-09-09 20:50:58','2026-09-09 21:07:00'),(9,'Celebrations','events','http://localhost:8000/storage/gallery/ODsZbbe6qtFyfuX1t0rToMzatKvmrWMJymOpUjM0.jpg',8,'2026-09-09 20:51:01','2026-09-09 21:07:00'); /*!40000 ALTER TABLE `galleries` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `job_batches` -- DROP TABLE IF EXISTS `job_batches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `job_batches` ( `id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `total_jobs` int(11) NOT NULL, `pending_jobs` int(11) NOT NULL, `failed_jobs` int(11) NOT NULL, `failed_job_ids` longtext NOT NULL, `options` mediumtext DEFAULT NULL, `cancelled_at` int(11) DEFAULT NULL, `created_at` int(11) NOT NULL, `finished_at` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `job_batches` -- LOCK TABLES `job_batches` WRITE; /*!40000 ALTER TABLE `job_batches` DISABLE KEYS */; /*!40000 ALTER TABLE `job_batches` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jobs` -- DROP TABLE IF EXISTS `jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `attempts` tinyint(3) unsigned NOT NULL, `reserved_at` int(10) unsigned DEFAULT NULL, `available_at` int(10) unsigned NOT NULL, `created_at` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `jobs_queue_index` (`queue`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jobs` -- LOCK TABLES `jobs` WRITE; /*!40000 ALTER TABLE `jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `media` -- DROP TABLE IF EXISTS `media`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `media` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `folder_id` bigint(20) unsigned DEFAULT NULL, `disk` varchar(255) NOT NULL DEFAULT 'public', `path` varchar(255) NOT NULL, `url` varchar(255) NOT NULL, `file_name` varchar(255) NOT NULL, `original_name` varchar(255) NOT NULL, `mime_type` varchar(255) DEFAULT NULL, `size` int(10) unsigned NOT NULL DEFAULT 0, `alt_text` varchar(255) DEFAULT NULL, `uploaded_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `media_folder_id_foreign` (`folder_id`), KEY `media_uploaded_by_foreign` (`uploaded_by`), CONSTRAINT `media_folder_id_foreign` FOREIGN KEY (`folder_id`) REFERENCES `media_folders` (`id`) ON DELETE SET NULL, CONSTRAINT `media_uploaded_by_foreign` FOREIGN KEY (`uploaded_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `media` -- LOCK TABLES `media` WRITE; /*!40000 ALTER TABLE `media` DISABLE KEYS */; INSERT INTO `media` VALUES (2,NULL,'public','media/2026/09/aa2e0ede-471b-48f8-8583-7815a6d62319.webp','http://localhost:8000/storage/media/2026/09/aa2e0ede-471b-48f8-8583-7815a6d62319.webp','aa2e0ede-471b-48f8-8583-7815a6d62319.webp','catgery main img.webp','image/webp',88448,NULL,1,'2026-09-09 20:42:25','2026-09-09 21:07:00'),(3,NULL,'public','media/2026/09/95da4aeb-29be-469c-aaef-eff14ef783d6.webp','http://localhost:8000/storage/media/2026/09/95da4aeb-29be-469c-aaef-eff14ef783d6.webp','95da4aeb-29be-469c-aaef-eff14ef783d6.webp','home Banner.webp','image/webp',97290,NULL,1,'2026-09-09 21:41:52','2026-09-09 21:41:52'); /*!40000 ALTER TABLE `media` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `media_folders` -- DROP TABLE IF EXISTS `media_folders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `media_folders` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `parent_id` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `media_folders_parent_id_foreign` (`parent_id`), CONSTRAINT `media_folders_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `media_folders` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `media_folders` -- LOCK TABLES `media_folders` WRITE; /*!40000 ALTER TABLE `media_folders` DISABLE KEYS */; /*!40000 ALTER TABLE `media_folders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `menu_images` -- DROP TABLE IF EXISTS `menu_images`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `menu_images` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `menu_item_id` bigint(20) unsigned NOT NULL, `image_path` varchar(255) NOT NULL, `sort_order` int(10) unsigned NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `menu_images_menu_item_id_foreign` (`menu_item_id`), CONSTRAINT `menu_images_menu_item_id_foreign` FOREIGN KEY (`menu_item_id`) REFERENCES `menu_items` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `menu_images` -- LOCK TABLES `menu_images` WRITE; /*!40000 ALTER TABLE `menu_images` DISABLE KEYS */; /*!40000 ALTER TABLE `menu_images` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `menu_items` -- DROP TABLE IF EXISTS `menu_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `menu_items` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `category_id` bigint(20) unsigned NOT NULL, `name_en` varchar(255) NOT NULL, `name_ar` varchar(255) NOT NULL, `description_en` text NOT NULL, `description_ar` text NOT NULL, `ingredients_en` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`ingredients_en`)), `ingredients_ar` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`ingredients_ar`)), `price` decimal(8,2) NOT NULL, `calories` int(10) unsigned DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `is_featured` tinyint(1) NOT NULL DEFAULT 0, `best_seller` tinyint(1) NOT NULL DEFAULT 0, `sort_order` int(10) unsigned NOT NULL DEFAULT 0, `is_available` tinyint(1) NOT NULL DEFAULT 1, `tags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`tags`)), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `menu_items_category_id_foreign` (`category_id`), CONSTRAINT `menu_items_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `menu_items` -- LOCK TABLES `menu_items` WRITE; /*!40000 ALTER TABLE `menu_items` DISABLE KEYS */; INSERT INTO `menu_items` VALUES (1,1,'Shish Tawook','شيش طاوول','Grilled chicken shish tawook sandwich','ساندوتش شيش طاوول مشوي',NULL,NULL,0.00,NULL,'http://localhost:8000/storage/media/2026/09/aa2e0ede-471b-48f8-8583-7815a6d62319.webp',0,0,1,1,NULL,'2026-09-09 21:00:26','2026-09-09 21:07:55'),(2,1,'Alexandria Liver','كبدة اسكندرانية','Alexandria-style liver sandwich','ساندوتش كبدة اسكندرانية',NULL,NULL,0.00,NULL,NULL,0,0,2,1,NULL,'2026-09-09 21:00:26','2026-09-09 21:00:26'),(3,1,'Sausage','سجق','Grilled sausage sandwich','ساندوتش سجق مشوي',NULL,NULL,0.00,NULL,NULL,0,0,3,1,NULL,'2026-09-09 21:00:26','2026-09-09 21:00:26'),(4,1,'Kofta','كفته','Grilled kofta sandwich','ساندوتش كفته مشوي',NULL,NULL,0.00,NULL,NULL,0,0,4,1,NULL,'2026-09-09 21:00:26','2026-09-09 21:00:26'),(5,1,'Hawawshi','حواوش','Traditional hawawshi sandwich with spiced meat','ساندوتش حواوش باللحمة المشكلة',NULL,NULL,0.00,NULL,NULL,0,1,5,1,NULL,'2026-09-09 21:00:26','2026-09-09 21:00:26'),(6,2,'Meal','وجبة','Regular meal platter','وجبة عادية',NULL,NULL,0.00,NULL,'http://localhost:8000/storage/media/2026/09/95da4aeb-29be-469c-aaef-eff14ef783d6.webp',0,0,1,1,NULL,'2026-09-09 21:00:26','2026-09-09 21:41:53'),(7,2,'Mixed Platter','وجبة مشكل','Mixed grill platter with assorted meats','وجبة مشكل باللحوم المشوية',NULL,NULL,0.00,NULL,NULL,1,1,2,1,NULL,'2026-09-09 21:00:26','2026-09-09 21:00:26'),(8,2,'Sausage Platter','وجبة سجق','Sausage platter with sides','وجبة سجق مع الإضافات',NULL,NULL,0.00,NULL,NULL,0,0,3,1,NULL,'2026-09-09 21:00:26','2026-09-09 21:00:26'),(9,2,'Grilled Chicken','فراخ مشوية','Grilled chicken platter','وجبة فراخ مشوية',NULL,NULL,0.00,NULL,NULL,1,0,4,1,NULL,'2026-09-09 21:00:26','2026-09-09 21:00:26'),(10,2,'Extra Cheese','جبنة إضافية','Extra cheese topping for any meal','جبنة إضافية لأي وجبة',NULL,NULL,0.00,NULL,NULL,0,0,5,1,NULL,'2026-09-09 21:00:26','2026-09-09 21:00:26'),(11,3,'Rice','أرز','Steamed rice side','أرز مسلوق',NULL,NULL,0.00,NULL,NULL,0,0,1,1,NULL,'2026-09-09 21:00:26','2026-09-09 21:00:26'),(12,3,'Potatoes','بطاطس','French fries','بطاطس محمرة',NULL,NULL,0.00,NULL,NULL,0,1,2,1,NULL,'2026-09-09 21:00:26','2026-09-09 21:00:26'),(13,3,'Tahini','طحينة','Tahini sauce','صلصة الطحينة',NULL,NULL,0.00,NULL,NULL,0,0,3,1,NULL,'2026-09-09 21:00:26','2026-09-09 21:00:26'),(14,3,'Baba Ghanoush','بابا غنوج','Smoky eggplant dip','بابا غنوج',NULL,NULL,0.00,NULL,NULL,0,0,4,1,NULL,'2026-09-09 21:00:26','2026-09-09 21:00:26'),(15,3,'Country Salad','سلطة بلدي','Traditional Egyptian country salad','سلطة بلدي تقليدية',NULL,NULL,0.00,NULL,NULL,0,0,5,1,NULL,'2026-09-09 21:00:26','2026-09-09 21:00:26'),(16,3,'Pickles','مخلل','Assorted pickled vegetables','مخلل مشكل',NULL,NULL,0.00,NULL,NULL,0,0,6,1,NULL,'2026-09-09 21:00:26','2026-09-09 21:00:26'),(18,4,'Halal Whiskey','ويسكي حلال','Non-alcoholic halal whiskey drink','مشروب ويسكي حلال بدون كحول',NULL,NULL,0.00,NULL,NULL,1,0,2,1,NULL,'2026-09-09 21:00:26','2026-09-09 21:00:26'); /*!40000 ALTER TABLE `menu_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `migrations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` VALUES (1,'2026_09_10_000000_make_reservations_email_nullable',1); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `model_has_permissions` -- DROP TABLE IF EXISTS `model_has_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `model_has_permissions` ( `permission_id` bigint(20) unsigned NOT NULL, `model_type` varchar(255) NOT NULL, `model_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`permission_id`,`model_id`,`model_type`), KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`), CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `model_has_permissions` -- LOCK TABLES `model_has_permissions` WRITE; /*!40000 ALTER TABLE `model_has_permissions` DISABLE KEYS */; /*!40000 ALTER TABLE `model_has_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `model_has_roles` -- DROP TABLE IF EXISTS `model_has_roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `model_has_roles` ( `role_id` bigint(20) unsigned NOT NULL, `model_type` varchar(255) NOT NULL, `model_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`role_id`,`model_id`,`model_type`), KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`), CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `model_has_roles` -- LOCK TABLES `model_has_roles` WRITE; /*!40000 ALTER TABLE `model_has_roles` DISABLE KEYS */; INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\User',1); /*!40000 ALTER TABLE `model_has_roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `notifications` -- DROP TABLE IF EXISTS `notifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `notifications` ( `id` char(36) NOT NULL, `type` varchar(255) NOT NULL, `notifiable_type` varchar(255) NOT NULL, `notifiable_id` bigint(20) unsigned NOT NULL, `data` text NOT NULL, `read_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `notifications` -- LOCK TABLES `notifications` WRITE; /*!40000 ALTER TABLE `notifications` DISABLE KEYS */; INSERT INTO `notifications` VALUES ('00e24eaf-1ffd-42da-a20a-77072cd89738','App\\Notifications\\NewReservationNotification','App\\Models\\User',1,'{\"type\":\"reservation\",\"title\":\"New reservation request\",\"message\":\"SlowUser requested a table for 4 on 2026-09-21.\",\"link\":\"\\/admin\\/reservations\",\"subject_id\":5}',NULL,'2026-09-09 22:50:09','2026-09-09 22:50:09'),('1f576c99-8984-4e62-8b88-31119405d1f9','App\\Notifications\\NewReservationNotification','App\\Models\\User',1,'{\"type\":\"reservation\",\"title\":\"New reservation request\",\"message\":\"RateTest4 requested a table for 2 on 2026-09-20.\",\"link\":\"\\/admin\\/reservations\",\"subject_id\":12}',NULL,'2026-09-09 22:56:49','2026-09-09 22:56:49'),('4acca3b0-aa2f-4094-b100-e7c636850221','App\\Notifications\\NewReservationNotification','App\\Models\\User',1,'{\"type\":\"reservation\",\"title\":\"New reservation request\",\"message\":\"FastBot requested a table for 2 on 2026-09-15.\",\"link\":\"\\/admin\\/reservations\",\"subject_id\":2}',NULL,'2026-09-09 22:47:04','2026-09-09 22:47:04'),('719d3e64-2321-4ec8-91ec-4286a247b94b','App\\Notifications\\NewReservationNotification','App\\Models\\User',1,'{\"type\":\"reservation\",\"title\":\"New reservation request\",\"message\":\"RateTest1 requested a table for 2 on 2026-09-20.\",\"link\":\"\\/admin\\/reservations\",\"subject_id\":9}',NULL,'2026-09-09 22:56:41','2026-09-09 22:56:41'),('8a96fd90-c330-4bb5-badb-3d01eaabcf6a','App\\Notifications\\NewReservationNotification','App\\Models\\User',1,'{\"type\":\"reservation\",\"title\":\"New reservation request\",\"message\":\"RateTest3 requested a table for 2 on 2026-09-20.\",\"link\":\"\\/admin\\/reservations\",\"subject_id\":11}',NULL,'2026-09-09 22:56:46','2026-09-09 22:56:46'),('915ffbe0-6be5-4d71-80ee-2540c582ec72','App\\Notifications\\NewReservationNotification','App\\Models\\User',1,'{\"type\":\"reservation\",\"title\":\"New reservation request\",\"message\":\"Test User requested a table for 2 on 2026-09-15.\",\"link\":\"\\/admin\\/reservations\",\"subject_id\":1}',NULL,'2026-09-09 22:46:59','2026-09-09 22:46:59'),('a19f0db7-d74f-4985-bfef-f712361bf238','App\\Notifications\\NewReservationNotification','App\\Models\\User',1,'{\"type\":\"reservation\",\"title\":\"New reservation request\",\"message\":\"DebugBot requested a table for 2 on 2026-09-20.\",\"link\":\"\\/admin\\/reservations\",\"subject_id\":6}',NULL,'2026-09-09 22:51:57','2026-09-09 22:51:57'),('b6d0a103-bbb4-4741-a6a6-318fd30e81e3','App\\Notifications\\NewReservationNotification','App\\Models\\User',1,'{\"type\":\"reservation\",\"title\":\"New reservation request\",\"message\":\"TwelveHour requested a table for 3 on 2026-09-16.\",\"link\":\"\\/admin\\/reservations\",\"subject_id\":3}',NULL,'2026-09-09 22:47:08','2026-09-09 22:47:08'),('cc8dc40c-78b6-4beb-b450-bb006d2985d5','App\\Notifications\\NewReservationNotification','App\\Models\\User',1,'{\"type\":\"reservation\",\"title\":\"New reservation request\",\"message\":\"SlowUser2 requested a table for 4 on 2026-09-21.\",\"link\":\"\\/admin\\/reservations\",\"subject_id\":7}',NULL,'2026-09-09 22:52:58','2026-09-09 22:52:58'),('d336f7f5-8913-482d-8ca4-7003cfa1b522','App\\Notifications\\NewReservationNotification','App\\Models\\User',1,'{\"type\":\"reservation\",\"title\":\"New reservation request\",\"message\":\"RateTest5 requested a table for 2 on 2026-09-20.\",\"link\":\"\\/admin\\/reservations\",\"subject_id\":13}',NULL,'2026-09-09 22:56:52','2026-09-09 22:56:52'),('d72ece93-c5db-432c-b2d2-2e800d56fc49','App\\Notifications\\NewReservationNotification','App\\Models\\User',1,'{\"type\":\"reservation\",\"title\":\"New reservation request\",\"message\":\"FastBot2 requested a table for 2 on 2026-09-20.\",\"link\":\"\\/admin\\/reservations\",\"subject_id\":4}',NULL,'2026-09-09 22:50:06','2026-09-09 22:50:06'),('eb176ce7-acca-4244-b7d2-dd9c80546cef','App\\Notifications\\NewReservationNotification','App\\Models\\User',1,'{\"type\":\"reservation\",\"title\":\"New reservation request\",\"message\":\"Ahmed Hassan requested a table for 5 on 2026-09-18.\",\"link\":\"\\/admin\\/reservations\",\"subject_id\":8}',NULL,'2026-09-09 22:56:10','2026-09-09 22:56:10'),('f30cef9a-40cb-4e51-87fa-38867a9c09d2','App\\Notifications\\NewReservationNotification','App\\Models\\User',1,'{\"type\":\"reservation\",\"title\":\"New reservation request\",\"message\":\"RateTest2 requested a table for 2 on 2026-09-20.\",\"link\":\"\\/admin\\/reservations\",\"subject_id\":10}',NULL,'2026-09-09 22:56:44','2026-09-09 22:56:44'); /*!40000 ALTER TABLE `notifications` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `offers` -- DROP TABLE IF EXISTS `offers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `offers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title_en` varchar(255) NOT NULL, `title_ar` varchar(255) NOT NULL, `description_en` text NOT NULL, `description_ar` text NOT NULL, `image` varchar(255) DEFAULT NULL, `discount_label` varchar(255) DEFAULT NULL, `starts_at` date DEFAULT NULL, `ends_at` date DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `offers` -- LOCK TABLES `offers` WRITE; /*!40000 ALTER TABLE `offers` DISABLE KEYS */; /*!40000 ALTER TABLE `offers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_reset_tokens` -- DROP TABLE IF EXISTS `password_reset_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_reset_tokens` -- LOCK TABLES `password_reset_tokens` WRITE; /*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `permissions` -- DROP TABLE IF EXISTS `permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `permissions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `guard_name` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`) ) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `permissions` -- LOCK TABLES `permissions` WRITE; /*!40000 ALTER TABLE `permissions` DISABLE KEYS */; INSERT INTO `permissions` VALUES (64,'dashboard.view','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(65,'menu-categories.view','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(66,'menu-categories.create','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(67,'menu-categories.edit','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(68,'menu-categories.delete','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(69,'menu-items.view','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(70,'menu-items.create','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(71,'menu-items.edit','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(72,'menu-items.delete','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(73,'reservations.view','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(74,'reservations.edit','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(75,'reservations.approve','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(76,'reservations.delete','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(77,'reviews.view','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(78,'reviews.approve','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(79,'reviews.delete','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(80,'gallery.view','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(81,'gallery.create','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(82,'gallery.edit','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(83,'gallery.delete','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(84,'offers.view','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(85,'offers.create','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(86,'offers.edit','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(87,'offers.delete','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(88,'contact-messages.view','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(89,'contact-messages.reply','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(90,'contact-messages.delete','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(91,'users.view','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(92,'users.create','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(93,'users.edit','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(94,'users.delete','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(95,'settings.view','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(96,'settings.edit','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(97,'media.view','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(98,'media.upload','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(99,'media.edit','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(100,'media.delete','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(101,'testimonials.view','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(102,'testimonials.create','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(103,'testimonials.edit','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(104,'testimonials.delete','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(105,'homepage-cms.view','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(106,'homepage-cms.edit','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(107,'logs.view','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(108,'roles.view','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(109,'roles.create','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(110,'roles.edit','web','2026-09-09 21:22:26','2026-09-09 21:22:26'),(111,'roles.delete','web','2026-09-09 21:22:26','2026-09-09 21:22:26'); /*!40000 ALTER TABLE `permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `personal_access_tokens` -- DROP TABLE IF EXISTS `personal_access_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `personal_access_tokens` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tokenable_type` varchar(255) NOT NULL, `tokenable_id` bigint(20) unsigned NOT NULL, `name` text NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `personal_access_tokens_token_unique` (`token`), KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`), KEY `personal_access_tokens_expires_at_index` (`expires_at`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `personal_access_tokens` -- LOCK TABLES `personal_access_tokens` WRITE; /*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */; INSERT INTO `personal_access_tokens` VALUES (1,'App\\Models\\User',1,'raksha-frontend','b065b2e00c37a783810bb71b17ce325fc6c7dd2010bbe04c906c538a132e1093','[\"*\"]',NULL,NULL,'2026-09-09 17:48:34','2026-09-09 17:48:34'),(2,'App\\Models\\User',1,'raksha-frontend','2052adee1a0faa9f67924e62453dcf50087dac62acd279684d0e76168b97d7b5','[\"*\"]',NULL,NULL,'2026-09-09 17:53:38','2026-09-09 17:53:38'),(3,'App\\Models\\User',1,'raksha-frontend','0cb2d87decfb98e73281520131c618558f9cc899c94ce400d293eddf96d4a9f4','[\"*\"]',NULL,NULL,'2026-09-09 17:54:03','2026-09-09 17:54:03'),(4,'App\\Models\\User',1,'raksha-frontend','280cef4d3d865a27c3f5e7a4803ee942aeb1d76979ee95efffe071832e1f9b92','[\"*\"]','2026-09-09 18:43:49',NULL,'2026-09-09 17:54:51','2026-09-09 18:43:49'),(5,'App\\Models\\User',1,'raksha-frontend','797b5bf6cb55705904cb4dd81d07f70bd6682f1c8da5035b2eb8a3eeb23d8809','[\"*\"]','2026-09-09 18:03:28',NULL,'2026-09-09 18:03:23','2026-09-09 18:03:28'),(6,'App\\Models\\User',1,'raksha-frontend','61739fbb0edcb60ed434f4edcbe165b6ce012ab703762d51d01b92299edaa7be','[\"*\"]','2026-09-09 18:05:21',NULL,'2026-09-09 18:03:47','2026-09-09 18:05:21'),(7,'App\\Models\\User',1,'raksha-frontend','cbe8ae131b77a245cb09f956983bfa98840a190c5555a75c103ce4d581828361','[\"*\"]','2026-09-09 18:23:45',NULL,'2026-09-09 18:23:30','2026-09-09 18:23:45'),(8,'App\\Models\\User',1,'raksha-frontend','97928a2791bf7c38e9d84a5c296100de0afe05e7c8fbd11900600824713f298a','[\"*\"]','2026-09-09 18:27:36',NULL,'2026-09-09 18:26:50','2026-09-09 18:27:36'),(9,'App\\Models\\User',1,'raksha-frontend','be1a916d9ba1f3dd7c00a6a7283ed75b562b926c5f1bd8a6879aa54d114fd1a3','[\"*\"]','2026-09-09 18:34:01',NULL,'2026-09-09 18:33:16','2026-09-09 18:34:01'),(10,'App\\Models\\User',1,'raksha-frontend','fb99bc266307f8a177a375ac3a9bd51f79d60a43245878d6fa6b1ee25852dd6c','[\"*\"]','2026-09-09 18:43:23',NULL,'2026-09-09 18:42:43','2026-09-09 18:43:23'),(11,'App\\Models\\User',1,'raksha-frontend','804f7aa6be21c3060e732f34f00e53d6f3b0e0f9b9b1bb5d14c54a4e90e2682d','[\"*\"]',NULL,NULL,'2026-09-09 18:50:37','2026-09-09 18:50:37'),(12,'App\\Models\\User',1,'raksha-frontend','41ac7f5c4feece751783d978fcc01582f97ee66e38ec9d6757faf267927cc01c','[\"*\"]','2026-09-09 22:57:45',NULL,'2026-09-09 18:50:39','2026-09-09 22:57:45'),(13,'App\\Models\\User',1,'raksha-frontend','97d287ca77db65e928978e3ac5b7627245fd9a11473958b382c78452e52ee3a3','[\"*\"]','2026-09-09 19:07:41',NULL,'2026-09-09 19:07:36','2026-09-09 19:07:41'),(14,'App\\Models\\User',1,'raksha-frontend','01ada03a32b31dd44f98c21e98cc717dc8f5a38bd6d868037bc06ad5918da9f8','[\"*\"]',NULL,NULL,'2026-09-09 19:14:25','2026-09-09 19:14:25'),(15,'App\\Models\\User',1,'raksha-frontend','b3f5fdf5b86a6990cab341d0eb39daa626c459729d55781b375c6cdf2b71f331','[\"*\"]','2026-09-09 20:40:47',NULL,'2026-09-09 20:38:13','2026-09-09 20:40:47'),(16,'App\\Models\\User',1,'raksha-frontend','9b674b0ad269065d384eab13e3087a3a5659de53b4df3357f8e734be5fbf0bef','[\"*\"]','2026-09-09 22:57:20',NULL,'2026-09-09 20:46:39','2026-09-09 22:57:20'); /*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `reservations` -- DROP TABLE IF EXISTS `reservations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `reservations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned DEFAULT NULL, `full_name` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `email` varchar(255) DEFAULT NULL, `guests_count` int(10) unsigned NOT NULL, `date` date NOT NULL, `time` time NOT NULL, `notes` text DEFAULT NULL, `status` enum('pending','confirmed','cancelled') NOT NULL DEFAULT 'pending', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `reservations_user_id_foreign` (`user_id`), CONSTRAINT `reservations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `reservations` -- LOCK TABLES `reservations` WRITE; /*!40000 ALTER TABLE `reservations` DISABLE KEYS */; /*!40000 ALTER TABLE `reservations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `reviews` -- DROP TABLE IF EXISTS `reviews`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `reviews` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned DEFAULT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) DEFAULT NULL, `rating` tinyint(3) unsigned NOT NULL, `comment` text NOT NULL, `status` enum('pending','approved') NOT NULL DEFAULT 'pending', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `reviews_user_id_foreign` (`user_id`), CONSTRAINT `reviews_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `reviews` -- LOCK TABLES `reviews` WRITE; /*!40000 ALTER TABLE `reviews` DISABLE KEYS */; /*!40000 ALTER TABLE `reviews` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `role_has_permissions` -- DROP TABLE IF EXISTS `role_has_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `role_has_permissions` ( `permission_id` bigint(20) unsigned NOT NULL, `role_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`permission_id`,`role_id`), KEY `role_has_permissions_role_id_foreign` (`role_id`), CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE, CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `role_has_permissions` -- LOCK TABLES `role_has_permissions` WRITE; /*!40000 ALTER TABLE `role_has_permissions` DISABLE KEYS */; INSERT INTO `role_has_permissions` VALUES (64,1),(65,1),(66,1),(67,1),(68,1),(69,1),(70,1),(71,1),(72,1),(73,1),(74,1),(75,1),(76,1),(77,1),(78,1),(79,1),(80,1),(81,1),(82,1),(83,1),(84,1),(85,1),(86,1),(87,1),(88,1),(89,1),(90,1),(91,1),(92,1),(93,1),(94,1),(95,1),(96,1),(97,1),(98,1),(99,1),(100,1),(101,1),(102,1),(103,1),(104,1),(105,1),(106,1),(107,1),(108,1),(109,1),(110,1),(111,1); /*!40000 ALTER TABLE `role_has_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `roles` -- DROP TABLE IF EXISTS `roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `roles` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `guard_name` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `roles` -- LOCK TABLES `roles` WRITE; /*!40000 ALTER TABLE `roles` DISABLE KEYS */; INSERT INTO `roles` VALUES (1,'admin','web','2026-09-09 20:18:39','2026-09-09 20:18:39'),(2,'customer','web','2026-09-09 20:18:39','2026-09-09 20:18:39'); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sessions` -- DROP TABLE IF EXISTS `sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sessions` ( `id` varchar(255) NOT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `payload` longtext NOT NULL, `last_activity` int(11) 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sessions` -- LOCK TABLES `sessions` WRITE; /*!40000 ALTER TABLE `sessions` DISABLE KEYS */; INSERT INTO `sessions` VALUES ('NQcku2cTmqYKx8w2SfYOVrQ2laKO3OlFPap9I4bN',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Microsoft Windows 10.0.19045; en-US) PowerShell/7.6.6','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVUY1RWQ3TWNLbklHOHR0S1VGcjRoQlRnSHFJNjZaZGRSYUJ6NklTUSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMCI7czo1OiJyb3V0ZSI7Tjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1788997132),('TdlK9m7sANWXhjzA1bnf2i4ZCT943LzuYEBNk6qK',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Microsoft Windows 10.0.19045; en-US) PowerShell/7.6.6','YTozOntzOjY6Il90b2tlbiI7czo0MDoicVFlMHdGd2dScG10cXdmQkJBM3FCVTEzMXNzZkVnUmptVVhwV09kaCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMCI7czo1OiJyb3V0ZSI7Tjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1788997114); /*!40000 ALTER TABLE `sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `settings` -- DROP TABLE IF EXISTS `settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `settings` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `key` varchar(255) NOT NULL, `value` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `settings_key_unique` (`key`) ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings` -- LOCK TABLES `settings` WRITE; /*!40000 ALTER TABLE `settings` DISABLE KEYS */; INSERT INTO `settings` VALUES (1,'site_name','JAMRA Restaurant','2026-09-09 20:18:40','2026-09-09 20:18:40'),(2,'site_name_ar','مطعم جمرة','2026-09-09 20:18:40','2026-09-09 20:18:40'),(3,'site_tagline','Authentic Flavors, Modern Experience','2026-09-09 20:18:40','2026-09-09 20:18:40'),(4,'site_tagline_ar','نكهات أصيلة، تجربة عصرية','2026-09-09 20:18:40','2026-09-09 20:18:40'),(5,'contact_email','info@jamra.com','2026-09-09 20:18:40','2026-09-09 20:18:40'),(6,'contact_phone','\"+20 100 000 0000\"','2026-09-09 20:18:40','2026-09-09 22:15:06'),(7,'contact_phone_secondary','\"+20 100 000 0001\"','2026-09-09 20:18:40','2026-09-09 22:15:06'),(8,'address_en','\"New Cairo & Shorouk, Egypt\"','2026-09-09 20:18:40','2026-09-09 22:15:06'),(9,'address_ar','\"\\u0627\\u0644\\u0642\\u0627\\u0647\\u0631\\u0629 \\u0627\\u0644\\u062c\\u062f\\u064a\\u062f\\u0629 \\u0648\\u0627\\u0644\\u0634\\u0631\\u0648\\u0642\\u060c \\u0645\\u0635\\u0631\"','2026-09-09 20:18:40','2026-09-09 22:15:06'),(10,'whatsapp_number','\"+20 100 000 0000\"','2026-09-09 20:18:40','2026-09-09 22:15:06'),(11,'opening_hours_en','Sun-Thu: 12PM-11PM, Fri-Sat: 1PM-12AM','2026-09-09 20:18:40','2026-09-09 20:18:40'),(12,'opening_hours_ar','الأحد-الخميس: 12م-11م، الجمعة-السبت: 1م-12ص','2026-09-09 20:18:40','2026-09-09 20:18:40'),(13,'latitude','30.03','2026-09-09 20:18:40','2026-09-09 22:15:06'),(14,'longitude','31.47','2026-09-09 20:18:40','2026-09-09 22:15:06'),(15,'seo_title','null','2026-09-09 22:33:53','2026-09-09 22:35:19'),(16,'seo_description','null','2026-09-09 22:33:53','2026-09-09 22:35:19'),(17,'google_site_verification','null','2026-09-09 22:33:53','2026-09-09 22:35:19'),(18,'google_analytics_id','null','2026-09-09 22:33:53','2026-09-09 22:35:19'),(19,'meta_keywords','null','2026-09-09 22:33:53','2026-09-09 22:35:19'),(20,'canonical_url','null','2026-09-09 22:33:53','2026-09-09 22:35:19'),(21,'robots','null','2026-09-09 22:33:53','2026-09-09 22:35:19'),(22,'og_image_url','null','2026-09-09 22:33:54','2026-09-09 22:35:19'); /*!40000 ALTER TABLE `settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `testimonials` -- DROP TABLE IF EXISTS `testimonials`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `testimonials` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `job_title_en` varchar(255) DEFAULT NULL, `job_title_ar` varchar(255) DEFAULT NULL, `rating` tinyint(3) unsigned NOT NULL DEFAULT 5, `review_en` text NOT NULL, `review_ar` text NOT NULL, `photo_url` varchar(255) DEFAULT NULL, `is_published` tinyint(1) NOT NULL DEFAULT 0, `sort_order` int(10) unsigned NOT NULL DEFAULT 0, `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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `testimonials` -- LOCK TABLES `testimonials` WRITE; /*!40000 ALTER TABLE `testimonials` DISABLE KEYS */; INSERT INTO `testimonials` VALUES (1,'test','test','test',5,'test','test',NULL,1,0,'2026-09-09 18:54:44','2026-09-09 18:54:51'); /*!40000 ALTER TABLE `testimonials` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`), KEY `idx_users_phone` (`phone`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'Admin','admin@jamra.com','+966500000000',1,NULL,'$2y$12$02NwV3YoDS9TYOian7.6jujwiNQ4cCQkCXjudDEyyi3s9EvdkRe6W',NULL,'2026-09-09 20:18:39','2026-09-09 20:18:39'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-09-10 16:19:09