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

START TRANSACTION;



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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` int(10) UNSIGNED NOT NULL,
  `order` int(11) DEFAULT NULL,
  `name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`name`)),
  `title` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`title`)),
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`description`)),
  `meta_title` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`meta_title`)),
  `meta_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`meta_description`)),
  `slug` text NOT NULL,
  `status` enum('Not Active','Active') NOT NULL DEFAULT 'Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `careers`
--

CREATE TABLE `careers` (
  `id` int(10) UNSIGNED NOT NULL,
  `order` int(11) DEFAULT NULL,
  `name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`name`)),
  `title` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`title`)),
  `desc` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`desc`)),
  `details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`details`)),
  `meta_title` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`meta_title`)),
  `meta_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`meta_description`)),
  `slug` text NOT NULL,
  `status` enum('Not Active','Active') NOT NULL DEFAULT 'Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `careers`
--

INSERT INTO `careers` (`id`, `order`, `name`, `title`, `desc`, `details`, `meta_title`, `meta_description`, `slug`, `status`, `created_at`, `updated_at`) VALUES
(13, 3, '{\"en\":\"Landscape Engineer\",\"ar\":\"Landscape Engineer\"}', '{\"en\":\"Landscape Engineer (Construction)\",\"ar\":\"Landscape Engineer (Construction)\"}', '{\"en\":\"<p>SiteWork Contracting &amp; Landscaping is looking for an experienced Landscape Engineer (Construction) with 5 to 8 years of experience to join our team.</p><p><br></p>\",\"ar\":\"<p>SiteWork Contracting &amp; Landscaping is looking for an experienced Landscape Engineer (Construction) with 5 to 8 years of experience to join our team.</p><p><br></p>\"}', '{\"en\":\"<p>Responsibilities:</p><p>Supervise the execution of landscaping and planting works.</p><p>Ensure soil and plant quality meet project requirements.</p><p>Coordinate between site teams and suppliers for smooth workflow.</p><p>Prepare technical reports and monitor project progress.</p><p>Requirements:</p><p>5 to 8 years of experience in landscaping and plantation projects.</p><p>Strong knowledge of plant species and environmental requirements.</p><p>Ability to read plans and coordinate with on-site teams.</p>\",\"ar\":\"<p>Responsibilities:</p><p>Supervise the execution of landscaping and planting works.</p><p>Ensure soil and plant quality meet project requirements.</p><p>Coordinate between site teams and suppliers for smooth workflow.</p><p>Prepare technical reports and monitor project progress.</p><p>Requirements:</p><p>5 to 8 years of experience in landscaping and plantation projects.</p><p>Strong knowledge of plant species and environmental requirements.</p><p>Ability to read plans and coordinate with on-site teams.</p>\"}', '{\"en\":\"Landscape Engineer\",\"ar\":\"Landscape Engineer\"}', '{\"en\":\"<p>Dolor.</p>\",\"ar\":\"<p>Iure .</p>\"}', 'Nihil', 'Active', '2025-03-07 18:20:53', '2025-03-07 18:25:46');

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `order` int(11) DEFAULT NULL,
  `title` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`title`)),
  `desc` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `status` enum('Active','Not Active') NOT NULL DEFAULT 'Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `order`, `title`, `desc`, `status`, `created_at`, `updated_at`) VALUES
(2, 1, '{\"en\":\"Sitework History\",\"ar\":\"تاريخ سايت وورك\"}', '{\"en\":\"Sitework Contracting and Landscape was established by senior\\nengineers in the fields of landscape and modern irrigation. We\\ntransfer more than 30 years of experience of achievements And\\nparticipation in major national and private projects.\",\"ar\":\"شركة سايت وورك للمقاولات وأعمال اللاندسكيب تم تأسيسها من قبل كبار مهندسين في مجال تنسيق الحدائق والري الحديث. نحن\\nنقل أكثر من 30 عاما من الخبرة من الإنجازات و المشاركة في المشاريع الوطنية والخاصة الكبرى.\"}', 'Active', '2025-01-28 05:45:44', '2025-01-30 07:20:33'),
(3, 2, '{\"en\":\"Our Vision\",\"ar\":\"رؤيتنا\"}', '{\"en\":\"To be the premier landscape company renowned for creating bespoke, breathtaking outdoor environments that enhance the quality of life and\\nadd lasting value to every project, whether national or private.\",\"ar\":\"<p>نهدف لنكون الشركة الرائدة في مجال تنسيق الحدائق، المشهورة بخلق بيئات خارجية مخصصة تخطف الأنفاس وتعزز جودة الحياة وتضيف قيمة </p><p>دائمة لكل مشروع، سواء كان مشروعا سكنيا عاما </p><p>أو خاصا.</p>\"}', 'Active', '2025-01-28 06:07:28', '2025-02-19 10:11:51'),
(4, 3, '{\"en\":\"Our Mission\",\"ar\":\"هدفنا\"}', '{\"en\":\"<p>Our mission is to deliver exceptional landscape solutions through talented teams, custom designs, and expert irrigation systems. We\'re committed to quality, credibility, and fast service, ensuring each project reflects our dedication to excellence and customer satisfaction.</p>\",\"ar\":\"<p>مهمتنا هي تقديم حلول تنسيقية استثنائية من خلال فِِفِِرق موهوبة، وتصاميم مخصصة، وأنظمة ري متخصصة. نحن ملتزمون بالجودة والمصداقية والخدمة السريعة، لضمان أن </p><p>يعكس كل مشروع تفانينا في التميز ورضا العملاء.</p>\"}', 'Active', '2025-01-28 06:09:47', '2025-02-19 10:12:33'),
(5, 4, '{\"en\":\"Our Values\",\"ar\":\"قيمنا\"}', '{\"en\":\"<h2><br></h2><h2><sup class=\\\"ql-size-huge\\\">Credibility</sup></h2><h2><sup class=\\\"ql-size-huge\\\">Quality</sup></h2><h2><sup class=\\\"ql-size-huge\\\">Commitment </sup></h2>\",\"ar\":\"<ol><li data-list=\\\"bullet\\\"><span class=\\\"ql-ui\\\" contenteditable=\\\"false\\\"></span>المداقيه </li><li data-list=\\\"bullet\\\"><span class=\\\"ql-ui\\\" contenteditable=\\\"false\\\"></span>الجوده</li><li data-list=\\\"bullet\\\"><span class=\\\"ql-ui\\\" contenteditable=\\\"false\\\"></span>الالتزام</li></ol>\"}', 'Active', '2025-01-28 06:32:10', '2025-02-21 12:18:50'),
(6, 5, '{\"en\":\"home_about\",\"ar\":\"home_about\"}', '{\"en\":\"SiteWork for Contracting and Landscaping was established for\\ndesigning and installing irrigation networks, central control\\nsystems, supply and cultivate ornamental plants for commercial\\nand residential projects, designing and construction of sport\\ncourts (specially football courts and polo courts), also\\nconstruction and maintenance for fountains and swimming\\npools .\",\"ar\":\"تم تأسيس شركة سايت وورك للمقاولات وتنسيق الحدائق\\nتصميم وتركيب شبكات الري والتحكم المركزي\\nنظم وتوريد وزراعة نباتات الزينة لأغراض تجارية\\nوالمشاريع السكنية وتصميم وبناء الرياضة\\nالملاعب (خاصة ملاعب كرة القدم وملاعب البولو).\\nبناء وصيانة النوافير والسباحة\\nحمامات سباحة .\"}', 'Not Active', '2025-01-30 05:56:23', '2025-01-30 05:56:23');

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

--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `id` int(10) UNSIGNED NOT NULL,
  `status` enum('Not Active','Active') NOT NULL DEFAULT 'Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` (`id`, `status`, `created_at`, `updated_at`) VALUES
(10, 'Active', '2025-02-22 13:13:30', '2025-02-22 15:22:10'),
(11, 'Active', '2025-02-22 13:20:14', '2025-03-07 16:56:27'),
(12, 'Not Active', '2025-02-22 13:24:28', '2025-03-07 16:49:19'),
(17, 'Active', '2025-03-07 16:49:15', '2025-03-07 16:49:15'),
(24, 'Active', '2025-03-13 17:18:33', '2025-03-13 17:18:33'),
(26, 'Active', '2025-03-13 17:30:13', '2025-03-13 17:30:13'),
(27, 'Active', '2025-03-13 17:37:15', '2025-03-13 17:37:15'),
(28, 'Active', '2025-03-13 18:14:41', '2025-03-13 18:14:41');

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

--
-- Table structure for table `counters`
--

CREATE TABLE `counters` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `counters`
--

INSERT INTO `counters` (`id`, `name`, `count`, `icon`, `created_at`, `updated_at`) VALUES
(3, 'Aquila Chambers', 58, 'fa fa-certificate', '2024-11-30 16:38:37', '2024-12-08 02:27:58'),
(4, 'Xandra Fletcher', 72, 'fa fa-users-cog', '2024-12-08 02:22:51', '2024-12-08 02:28:27'),
(5, 'Helen Bauer', 36, 'fa fa-users', '2024-12-08 02:22:57', '2024-12-08 02:29:04'),
(6, 'Phelan Henry', 7, 'fa fa-check', '2024-12-08 02:29:23', '2024-12-08 02:29:23');

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `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()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) DEFAULT NULL,
  `collection_name` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `mime_type` varchar(255) DEFAULT NULL,
  `disk` varchar(255) NOT NULL,
  `conversions_disk` varchar(255) DEFAULT NULL,
  `size` bigint(20) UNSIGNED NOT NULL,
  `manipulations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`manipulations`)),
  `custom_properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`custom_properties`)),
  `generated_conversions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`generated_conversions`)),
  `responsive_images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`responsive_images`)),
  `order_column` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media`
--

INSERT INTO `media` (`id`, `model_type`, `model_id`, `uuid`, `collection_name`, `name`, `file_name`, `mime_type`, `disk`, `conversions_disk`, `size`, `manipulations`, `custom_properties`, `generated_conversions`, `responsive_images`, `order_column`, `created_at`, `updated_at`) VALUES
(10, 'App\\Models\\Page', 12, 'e622c7bb-5500-450c-8330-974ad74dcc33', 'banner', 'SiteWork Logo Monochrome', 'SiteWork-Logo-Monochrome.png', 'image/png', 'media', 'media', 2063659, '[]', '[]', '[]', '[]', 1, '2025-01-27 12:04:33', '2025-01-27 12:04:33'),
(11, 'App\\Models\\Page', 13, '1d34dfbe-ec11-4993-b553-2122928103dd', 'banner', 'SiteWork Logo Monochrome', 'SiteWork-Logo-Monochrome.png', 'image/png', 'media', 'media', 2063659, '[]', '[]', '[]', '[]', 1, '2025-01-27 12:09:43', '2025-01-27 12:09:43'),
(13, 'App\\Models\\Page', 15, '1a9256ea-c508-4217-b10d-d25e3b7009d0', 'banner', 'SiteWork Logo Monochrome', 'SiteWork-Logo-Monochrome.png', 'image/png', 'media', 'media', 2063659, '[]', '[]', '[]', '[]', 1, '2025-01-27 12:13:01', '2025-01-27 12:13:01'),
(14, 'App\\Models\\Page', 16, '181919c6-e4fd-4ebd-b413-3006ec57f0a2', 'banner', 'SiteWork Logo Monochrome', 'SiteWork-Logo-Monochrome.png', 'image/png', 'media', 'media', 2063659, '[]', '[]', '[]', '[]', 1, '2025-01-27 12:13:45', '2025-01-27 12:13:45'),
(15, 'App\\Models\\Page', 17, '3ba020ed-5a16-436c-9190-b8fe19c432dc', 'banner', 'SiteWork Logo Monochrome', 'SiteWork-Logo-Monochrome.png', 'image/png', 'media', 'media', 2063659, '[]', '[]', '[]', '[]', 1, '2025-01-27 12:15:52', '2025-01-27 12:15:52'),
(130, 'App\\Models\\Setting', 1, '7e4df7e2-f17f-4a2b-ac7e-c15cfde134ea', 'logo_light', 'Mail logo', 'Mail-logo.png', 'image/png', 'media', 'media', 6951, '[]', '[]', '[]', '[]', 33, '2025-02-17 12:01:06', '2025-02-17 12:01:06'),
(131, 'App\\Models\\Setting', 1, 'a85a7bc9-b127-46bb-a6f9-7158299f8081', 'logo_dark', 'HD LOGO White version', 'HD-LOGO-White-version.png', 'image/png', 'media', 'media', 60894, '[]', '[]', '[]', '[]', 34, '2025-02-17 12:01:06', '2025-02-17 12:01:06'),
(136, 'App\\Models\\Client', 10, '414fed43-8138-436f-9ab6-83c56de2813b', 'client', 'TATWEER-MISR', 'TATWEER-MISR.png', 'image/png', 'media', 'media', 79021, '[]', '[]', '[]', '[]', 1, '2025-02-22 13:13:30', '2025-02-22 13:13:30'),
(137, 'App\\Models\\Client', 11, '81f9dc30-4bbb-4f85-8e4e-a9b7aeb52cc5', 'client', 'f095f9b3-90e3-4fb8-b897-a546afa7ceb6', 'f095f9b3-90e3-4fb8-b897-a546afa7ceb6.png', 'image/png', 'media', 'media', 41541, '[]', '[]', '[]', '[]', 1, '2025-02-22 13:20:14', '2025-02-22 13:20:14'),
(138, 'App\\Models\\Client', 12, 'ac4074a5-f3c5-488a-b01c-6edd6f128033', 'client', 'images (1)', 'images-(1).png', 'image/png', 'media', 'media', 3980, '[]', '[]', '[]', '[]', 1, '2025-02-22 13:24:28', '2025-02-22 13:24:28'),
(139, 'App\\Models\\Service', 15, 'f641e854-db4c-4f84-9194-bf4287c47152', 'service', '1725651124512', '1725651124512.jpg', 'image/jpeg', 'media', 'media', 357221, '[]', '[]', '[]', '[]', 1, '2025-02-22 15:12:57', '2025-02-22 15:12:57'),
(141, 'App\\Models\\Project', 10, '8ce4e59a-07ed-40d6-b814-ca75d587d0ad', 'banner0', 'WhatsApp Image 2024-07-07 at 4.34.08 PM', 'WhatsApp-Image-2024-07-07-at-4.34.08-PM.jpg', 'image/jpeg', 'media', 'media', 848702, '[]', '[]', '[]', '[]', 1, '2025-02-22 15:17:05', '2025-02-22 15:17:05'),
(142, 'App\\Models\\Member', 26, 'a516a897-540c-4797-951c-483b7df5c48f', 'members', 'WhatsApp Image 2025-02-23 at 11.18.46_960abdbe', 'WhatsApp-Image-2025-02-23-at-11.18.46_960abdbe.jpg', 'image/jpeg', 'media', 'media', 83575, '[]', '[]', '[]', '[]', 1, '2025-02-24 18:44:38', '2025-02-24 18:44:38'),
(143, 'App\\Models\\Member', 27, 'fc928e17-46c8-473e-baba-303c7ba15551', 'members', 'WhatsApp Image 2025-02-23 at 13.10.23_c5078355', 'WhatsApp-Image-2025-02-23-at-13.10.23_c5078355.jpg', 'image/jpeg', 'media', 'media', 375467, '[]', '[]', '[]', '[]', 1, '2025-02-24 18:46:13', '2025-02-24 18:46:13'),
(144, 'App\\Models\\Member', 28, '54df113f-b264-43d5-ab7c-8f8b7ae17ff8', 'members', 'WhatsApp Image 2025-02-23 at 12.23.29_f415fbdc', 'WhatsApp-Image-2025-02-23-at-12.23.29_f415fbdc.jpg', 'image/jpeg', 'media', 'media', 35963, '[]', '[]', '[]', '[]', 1, '2025-02-24 18:47:22', '2025-02-24 18:47:22'),
(152, 'App\\Models\\Page', 14, '4c09fcb3-fd04-4909-af96-a1e12af313a1', 'banner', 'WhatsApp Image 2025-02-21 at 4.29.35 PM', 'WhatsApp-Image-2025-02-21-at-4.29.35-PM.jpeg', 'image/jpeg', 'media', 'media', 444890, '[]', '[]', '[]', '[]', 1, '2025-02-25 12:00:04', '2025-02-25 12:00:04'),
(153, 'App\\Models\\Page', 14, '395d0100-3b36-4e5b-87b1-6df88d8f33ef', 'banner', 'WhatsApp Image 2025-02-21 at 4.29.27 PM', 'WhatsApp-Image-2025-02-21-at-4.29.27-PM.jpeg', 'image/jpeg', 'media', 'media', 707700, '[]', '[]', '[]', '[]', 2, '2025-02-25 12:00:04', '2025-02-25 12:00:04'),
(154, 'App\\Models\\Service', 17, '08c01dbf-e31b-426a-9805-30a121c4bd19', 'service', 'WhatsApp Image 2024-08-26 at 5.26.51 PM (1)', 'WhatsApp-Image-2024-08-26-at-5.26.51-PM-(1).jpg', 'image/jpeg', 'media', 'media', 454453, '[]', '[]', '[]', '[]', 1, '2025-02-25 12:00:16', '2025-02-25 12:00:16'),
(155, 'App\\Models\\Project', 11, 'de2df847-1da7-49aa-9961-1456449fd50f', 'banner0', 'WhatsApp Image 2025-02-21 at 4.29.35 PM', 'WhatsApp-Image-2025-02-21-at-4.29.35-PM.jpeg', 'image/jpeg', 'media', 'media', 444890, '[]', '[]', '[]', '[]', 1, '2025-02-26 04:54:43', '2025-02-26 04:54:43'),
(156, 'App\\Models\\Project', 11, '13924c9f-3066-4493-92d4-ea192330c839', 'banner1', 'WhatsApp Image 2025-02-21 at 4.29.27 PM', 'WhatsApp-Image-2025-02-21-at-4.29.27-PM.jpeg', 'image/jpeg', 'media', 'media', 707700, '[]', '[]', '[]', '[]', 2, '2025-02-26 04:54:43', '2025-02-26 04:54:43'),
(158, 'App\\Models\\Project', 13, '81ceb4e0-3c8c-4280-90a5-2ab8447e7e10', 'banner0', '1725651116459', '1725651116459.jpg', 'image/jpeg', 'media', 'media', 233499, '[]', '[]', '[]', '[]', 1, '2025-02-26 10:14:34', '2025-02-26 10:14:34'),
(162, 'App\\Models\\Setting', 1, '56457456-fb3f-4e8f-a2cc-cdedef581697', 'about', '1725651124512', '1725651124512.jpg', 'image/jpeg', 'media', 'media', 357221, '[]', '[]', '[]', '[]', 35, '2025-02-26 11:55:17', '2025-02-26 11:55:17'),
(163, 'App\\Models\\Setting', 1, '31c65fa4-ff46-4ad2-861c-6fdff804ff5b', 'about', 'Picture3', 'Picture3.jpg', 'image/jpeg', 'media', 'media', 308475, '[]', '[]', '[]', '[]', 36, '2025-02-26 11:55:17', '2025-02-26 11:55:17'),
(164, 'App\\Models\\Setting', 1, '6ade359d-9ef3-4700-be6c-df5785c651d1', 'about', 'WhatsApp Image 2024-08-26 at 5.26.51 PM (1)', 'WhatsApp-Image-2024-08-26-at-5.26.51-PM-(1).jpg', 'image/jpeg', 'media', 'media', 454453, '[]', '[]', '[]', '[]', 37, '2025-02-26 11:55:17', '2025-02-26 11:55:17'),
(168, 'App\\Models\\Client', 17, 'fa639b2e-4df2-4cb7-bc89-7c126ab137a9', 'client', 'Hilton-logo-1A3DCEC9A6-seeklogo.com', 'Hilton-logo-1A3DCEC9A6-seeklogo.com.png', 'image/png', 'media', 'media', 5752, '[]', '[]', '[]', '[]', 1, '2025-03-07 16:49:15', '2025-03-07 16:49:15'),
(176, 'App\\Models\\Page', 18, 'aff9374c-90ac-4886-acd4-7e6bf061e9c5', 'banner', 'WhatsApp Image 2025-02-21 at 4.29.35 PM', 'WhatsApp-Image-2025-02-21-at-4.29.35-PM.jpeg', 'image/jpeg', 'media', 'media', 444890, '[]', '[]', '[]', '[]', 1, '2025-03-07 17:53:45', '2025-03-07 17:53:45'),
(177, 'App\\Models\\Page', 18, 'a870b52a-d86d-417a-9f4f-95dfcadc94af', 'banner', 'WhatsApp Image 2025-02-21 at 4.29.27 PM', 'WhatsApp-Image-2025-02-21-at-4.29.27-PM.jpeg', 'image/jpeg', 'media', 'media', 707700, '[]', '[]', '[]', '[]', 2, '2025-03-07 17:53:45', '2025-03-07 17:53:45'),
(178, 'App\\Models\\Career', 13, '49a0cddc-e1b5-46b5-a497-0a35a86c6ce8', 'career', 'WhatsApp Image 2025-02-21 at 4.29.27 PM', 'WhatsApp-Image-2025-02-21-at-4.29.27-PM.jpeg', 'image/jpeg', 'media', 'media', 707700, '[]', '[]', '[]', '[]', 1, '2025-03-07 18:20:53', '2025-03-07 18:20:53'),
(180, 'App\\Models\\Client', 24, 'f96e3092-4d82-4190-9772-9582d26ebd90', 'client', 'ora-reim(2).86f8f37', 'ora-reim(2).86f8f37.png', 'image/png', 'media', 'media', 54331, '[]', '[]', '[]', '[]', 1, '2025-03-13 17:18:33', '2025-03-13 17:18:33'),
(183, 'App\\Models\\Client', 26, '544ebe33-bc17-4bb5-b99e-a21e47b87918', 'client', 'تصميم بدون عنوان (3)', 'تصميم-بدون-عنوان-(3).png', 'image/png', 'media', 'media', 24623, '[]', '[]', '[]', '[]', 1, '2025-03-13 17:30:13', '2025-03-13 17:30:13'),
(184, 'App\\Models\\Client', 27, '1ae37b32-7f3e-4713-b089-c98de7ebf43e', 'client', '7cebf6f6-4d70-48db-8934-078aa85cf96c', '7cebf6f6-4d70-48db-8934-078aa85cf96c.png', 'image/png', 'media', 'media', 57771, '[]', '[]', '[]', '[]', 1, '2025-03-13 17:37:15', '2025-03-13 17:37:15'),
(187, 'App\\Models\\Service', 18, '3020760a-c847-4730-8b99-711c7295c76d', 'service', 'IMG-20240502-WA0176', 'IMG-20240502-WA0176.jpg', 'image/jpeg', 'media', 'media', 274705, '[]', '[]', '[]', '[]', 1, '2025-03-13 17:47:49', '2025-03-13 17:47:49'),
(188, 'App\\Models\\Service', 16, 'ec67e0d7-628a-4e46-90ea-977f662ed75e', 'service', '4b842457-770f-42af-9822-5e5b186749d2 (1)', '4b842457-770f-42af-9822-5e5b186749d2-(1).jpg', 'image/jpeg', 'media', 'media', 141414, '[]', '[]', '[]', '[]', 1, '2025-03-13 17:49:31', '2025-03-13 17:49:31'),
(189, 'App\\Models\\Project', 15, '257d46b1-3b70-4373-ad60-cde3321d08e9', 'banner0', '3c5d89be-b80e-4334-b30e-b3ba1ba35ccf', '3c5d89be-b80e-4334-b30e-b3ba1ba35ccf.jpg', 'image/jpeg', 'media', 'media', 585851, '[]', '[]', '[]', '[]', 1, '2025-03-13 17:50:49', '2025-03-13 17:50:49'),
(190, 'App\\Models\\Client', 28, 'a0391ada-4f2d-41cb-9f10-8cbd36c72b38', 'client', 'logo', 'logo.png', 'image/png', 'media', 'media', 18535, '[]', '[]', '[]', '[]', 1, '2025-03-13 18:14:41', '2025-03-13 18:14:41'),
(193, 'App\\Models\\Project', 15, '1865778e-608d-43c3-964f-47f65e6e789b', 'banner-0', 'IMG-20240502-WA0176 (1)', 'IMG-20240502-WA0176-(1).jpg', 'image/jpeg', 'media', 'media', 274705, '[]', '[]', '[]', '[]', 4, '2025-03-13 21:10:14', '2025-03-13 21:10:14'),
(194, 'App\\Models\\Project', 15, '8f50ada6-9492-4c04-8d47-ead93ec08cd5', 'banner-1', 'IMG-20240502-WA0176', 'IMG-20240502-WA0176.jpg', 'image/jpeg', 'media', 'media', 274705, '[]', '[]', '[]', '[]', 5, '2025-03-13 21:10:14', '2025-03-13 21:10:14'),
(195, 'App\\Models\\Project', 15, 'cecf903f-c551-4916-945c-f5070463890b', 'banner-2', '20240909_115507-EDIT', '20240909_115507-EDIT.jpg', 'image/jpeg', 'media', 'media', 3866484, '[]', '[]', '[]', '[]', 6, '2025-03-13 21:10:14', '2025-03-13 21:10:14'),
(196, 'App\\Models\\Project', 15, '1c3af675-0679-41d3-ba43-c62088d11b1a', 'banner-3', '20240909_115319', '20240909_115319.jpg', 'image/jpeg', 'media', 'media', 6991817, '[]', '[]', '[]', '[]', 7, '2025-03-13 21:10:14', '2025-03-13 21:10:14'),
(197, 'App\\Models\\Project', 15, 'bc430a31-58b7-4d08-8170-822638e33d31', 'banner-4', '20240909_115233', '20240909_115233.jpg', 'image/jpeg', 'media', 'media', 3120303, '[]', '[]', '[]', '[]', 8, '2025-03-13 21:10:14', '2025-03-13 21:10:14'),
(198, 'App\\Models\\Project', 15, 'ebb9f78b-db2d-4441-a9ad-e3ed59d67322', 'banner-5', '20240909_115104', '20240909_115104.jpg', 'image/jpeg', 'media', 'media', 3399060, '[]', '[]', '[]', '[]', 9, '2025-03-13 21:10:14', '2025-03-13 21:10:14'),
(199, 'App\\Models\\Project', 15, '39798e8c-c48c-4baa-8fb7-f5de9a04baac', 'banner-6', '20240909_114954-EDIT', '20240909_114954-EDIT.jpg', 'image/jpeg', 'media', 'media', 2971745, '[]', '[]', '[]', '[]', 10, '2025-03-13 21:10:14', '2025-03-13 21:10:14'),
(200, 'App\\Models\\Project', 15, '27755e50-fe84-4ab4-84c5-a3e00b44ae11', 'banner-7', '20240909_113751-EDIT', '20240909_113751-EDIT.jpg', 'image/jpeg', 'media', 'media', 2366538, '[]', '[]', '[]', '[]', 11, '2025-03-13 21:10:14', '2025-03-13 21:10:14'),
(201, 'App\\Models\\Project', 15, '508e2290-90b3-4ae6-af58-aeccc6725ecc', 'banner-8', '20240909_113554-EFFECTS', '20240909_113554-EFFECTS.jpg', 'image/jpeg', 'media', 'media', 3692920, '[]', '[]', '[]', '[]', 12, '2025-03-13 21:10:14', '2025-03-13 21:10:14'),
(202, 'App\\Models\\Service', 19, '698b445c-d5ca-439e-b233-87982b339dcb', 'service', 'IMG-20241203-WA0041', 'IMG-20241203-WA0041.jpg', 'image/jpeg', 'media', 'media', 373417, '[]', '[]', '[]', '[]', 1, '2025-03-14 12:58:02', '2025-03-14 12:58:02'),
(204, 'App\\Models\\Service', 14, 'a1455d5e-ac0e-4aa6-9d33-83f15d789cfb', 'service', '2_Photo - 14', '2_Photo---14.jpg', 'image/jpeg', 'media', 'media', 671699, '[]', '[]', '[]', '[]', 1, '2025-03-14 13:02:53', '2025-03-14 13:02:53'),
(213, 'App\\Models\\Project', 13, '382cfa38-91ca-4191-a46c-498dd7dbda07', 'banner-7', '20240909_113751-EDIT', '20240909_113751-EDIT.jpg', 'image/jpeg', 'media', 'media', 2366538, '[]', '[]', '[]', '[]', 9, '2025-03-14 13:31:33', '2025-03-14 13:31:33'),
(214, 'App\\Models\\Project', 13, '85c4d586-c3a5-44f9-a611-22a3c1898445', 'banner-8', '20240909_113554-EFFECTS', '20240909_113554-EFFECTS.jpg', 'image/jpeg', 'media', 'media', 3692920, '[]', '[]', '[]', '[]', 10, '2025-03-14 13:31:33', '2025-03-14 13:31:33'),
(221, 'App\\Models\\Project', 10, 'f18f90bc-1d62-4864-bd0a-56f163763a1c', 'banner-0', 'WhatsApp Image 2024-07-07 at 4.31.00 PM', 'WhatsApp-Image-2024-07-07-at-4.31.00-PM.jpg', 'image/jpeg', 'media', 'media', 587656, '[]', '[]', '[]', '[]', 8, '2025-03-14 13:57:31', '2025-03-14 13:57:31'),
(222, 'App\\Models\\Project', 10, 'd763bed5-844e-49d0-823b-cf249d4023a9', 'banner-1', 'WhatsApp Image 2024-07-07 at 4.34.08 PM', 'WhatsApp-Image-2024-07-07-at-4.34.08-PM.jpg', 'image/jpeg', 'media', 'media', 848702, '[]', '[]', '[]', '[]', 9, '2025-03-14 13:57:31', '2025-03-14 13:57:31'),
(223, 'App\\Models\\Project', 10, '2a1bbcc4-a360-4f9b-a0a9-27b75ba7427c', 'banner-2', 'WhatsApp Image 2024-07-07 at 4.34.09 PM (1)', 'WhatsApp-Image-2024-07-07-at-4.34.09-PM-(1).jpg', 'image/jpeg', 'media', 'media', 692713, '[]', '[]', '[]', '[]', 10, '2025-03-14 13:57:31', '2025-03-14 13:57:31'),
(224, 'App\\Models\\Project', 10, 'd6717295-6bbe-4678-afaa-62d3e7bae09c', 'banner-3', 'WhatsApp Image 2024-07-07 at 4.34.09 PM (2)', 'WhatsApp-Image-2024-07-07-at-4.34.09-PM-(2).jpg', 'image/jpeg', 'media', 'media', 722293, '[]', '[]', '[]', '[]', 11, '2025-03-14 13:57:31', '2025-03-14 13:57:31'),
(225, 'App\\Models\\Project', 10, 'a78e024a-ea2b-4a7e-9eaf-0ca4ce0ff234', 'banner-4', 'WhatsApp Image 2024-07-07 at 4.34.09 PM', 'WhatsApp-Image-2024-07-07-at-4.34.09-PM.jpg', 'image/jpeg', 'media', 'media', 692713, '[]', '[]', '[]', '[]', 12, '2025-03-14 13:57:31', '2025-03-14 13:57:31'),
(226, 'App\\Models\\Project', 10, '6ef3e8b3-0f55-40a9-a52d-e71382c92318', 'banner-5', 'WhatsApp Image 2024-08-26 at 5.26.41 PM (1)', 'WhatsApp-Image-2024-08-26-at-5.26.41-PM-(1).jpg', 'image/jpeg', 'media', 'media', 358430, '[]', '[]', '[]', '[]', 13, '2025-03-14 13:57:31', '2025-03-14 13:57:31'),
(231, 'App\\Models\\Project', 13, 'b13ed09b-cb38-476b-b5ca-d1c293cd5b9a', 'banner-0', '1725651116459', '1725651116459.jpg', 'image/jpeg', 'media', 'media', 233499, '[]', '[]', '[]', '[]', 15, '2025-03-14 16:03:47', '2025-03-14 16:03:47'),
(232, 'App\\Models\\Project', 13, '3625fe78-2c63-4d17-b9b1-2df15acf1693', 'banner-1', '1725651124512', '1725651124512.jpg', 'image/jpeg', 'media', 'media', 357221, '[]', '[]', '[]', '[]', 16, '2025-03-14 16:03:47', '2025-03-14 16:03:47'),
(233, 'App\\Models\\Project', 13, '16b22504-a502-4faa-825b-389c686549e4', 'banner-2', 'a3b9a979-7618-4298-8434-58bd84f756cc', 'a3b9a979-7618-4298-8434-58bd84f756cc.jpg', 'image/jpeg', 'media', 'media', 341732, '[]', '[]', '[]', '[]', 17, '2025-03-14 16:03:47', '2025-03-14 16:03:47'),
(234, 'App\\Models\\Project', 13, '769c54bd-29d0-461e-acf7-c06e54cb8114', 'banner-3', 'WhatsApp Image 2024-08-29 at 11.51.43 AM', 'WhatsApp-Image-2024-08-29-at-11.51.43-AM.jpg', 'image/jpeg', 'media', 'media', 1097973, '[]', '[]', '[]', '[]', 18, '2025-03-14 16:03:47', '2025-03-14 16:03:47'),
(235, 'App\\Models\\Project', 13, '3b14ae50-c425-41f3-8427-94d73e61d089', 'banner-4', 'WhatsApp Image 2024-09-26 at 12.07.56 PM (1)', 'WhatsApp-Image-2024-09-26-at-12.07.56-PM-(1).jpg', 'image/jpeg', 'media', 'media', 169502, '[]', '[]', '[]', '[]', 19, '2025-03-14 16:03:47', '2025-03-14 16:03:47'),
(236, 'App\\Models\\Project', 13, 'c8f38694-47e1-441f-ab27-13c00e256ffb', 'banner-5', 'WhatsApp Image 2024-09-26 at 12.07.56 PM (2)', 'WhatsApp-Image-2024-09-26-at-12.07.56-PM-(2).jpg', 'image/jpeg', 'media', 'media', 191199, '[]', '[]', '[]', '[]', 20, '2025-03-14 16:03:47', '2025-03-14 16:03:47'),
(237, 'App\\Models\\Project', 13, '22e89ff0-7574-4dc9-a226-e9a46cdc406d', 'banner-6', 'WhatsApp Image 2024-09-26 at 12.07.56 PM (3)', 'WhatsApp-Image-2024-09-26-at-12.07.56-PM-(3).jpg', 'image/jpeg', 'media', 'media', 196557, '[]', '[]', '[]', '[]', 21, '2025-03-14 16:03:47', '2025-03-14 16:03:47'),
(238, 'App\\Models\\Service', 20, '164d5b3c-851c-4ee5-9983-8d93bbf7748f', 'service', 'WhatsApp Image 2022-03-12 at 1.47.01 PM (3)', 'WhatsApp-Image-2022-03-12-at-1.47.01-PM-(3).jpg', 'image/jpeg', 'media', 'media', 102146, '[]', '[]', '[]', '[]', 1, '2025-03-14 16:09:16', '2025-03-14 16:09:16'),
(239, 'App\\Models\\Project', 16, '85488b1b-638d-4042-bd9f-55dced4b30b6', 'banner0', 'WhatsApp Image 2022-03-12 at 1.47.00 PM (1)', 'WhatsApp-Image-2022-03-12-at-1.47.00-PM-(1).jpg', 'image/jpeg', 'media', 'media', 121817, '[]', '[]', '[]', '[]', 1, '2025-03-14 16:44:00', '2025-03-14 16:44:00'),
(240, 'App\\Models\\Project', 16, '92a0aee2-d603-417c-b181-7d337843e77c', 'banner-0', '4b842457-770f-42af-9822-5e5b186749d2', '4b842457-770f-42af-9822-5e5b186749d2.jpg', 'image/jpeg', 'media', 'media', 141414, '[]', '[]', '[]', '[]', 2, '2025-03-14 16:48:29', '2025-03-14 16:48:29'),
(241, 'App\\Models\\Project', 16, 'd03569b4-111c-49cf-bb00-720c87cec509', 'banner-1', '5d43ac32-5aba-4f91-80c5-22f7c72d724f', '5d43ac32-5aba-4f91-80c5-22f7c72d724f.jpg', 'image/jpeg', 'media', 'media', 148181, '[]', '[]', '[]', '[]', 3, '2025-03-14 16:48:29', '2025-03-14 16:48:29'),
(242, 'App\\Models\\Project', 16, '292f7c3e-e69a-473d-9845-eb7df9abd370', 'banner-2', 'WhatsApp Image 2022-03-12 at 1.46.59 PM (1)', 'WhatsApp-Image-2022-03-12-at-1.46.59-PM-(1).jpg', 'image/jpeg', 'media', 'media', 98445, '[]', '[]', '[]', '[]', 4, '2025-03-14 16:48:29', '2025-03-14 16:48:29'),
(243, 'App\\Models\\Project', 16, '196741e2-8710-4098-88fd-907c37ba291f', 'banner-3', 'WhatsApp Image 2022-03-12 at 1.47.01 PM (3)', 'WhatsApp-Image-2022-03-12-at-1.47.01-PM-(3).jpg', 'image/jpeg', 'media', 'media', 102146, '[]', '[]', '[]', '[]', 5, '2025-03-14 16:48:29', '2025-03-14 16:48:29'),
(244, 'App\\Models\\Project', 16, '0806fbf0-4ea7-47f0-9d1c-d534d9b8eb70', 'banner-4', 'WhatsApp Image 2022-03-12 at 1.47.02 PM', 'WhatsApp-Image-2022-03-12-at-1.47.02-PM.jpg', 'image/jpeg', 'media', 'media', 89541, '[]', '[]', '[]', '[]', 6, '2025-03-14 16:48:29', '2025-03-14 16:48:29'),
(245, 'App\\Models\\Project', 17, '80358913-dd26-4f09-8cca-dfbb1c2ba58a', 'banner0', 'IMG-20220801-WA0001', 'IMG-20220801-WA0001.jpg', 'image/jpeg', 'media', 'media', 105609, '[]', '[]', '[]', '[]', 1, '2025-03-14 17:18:11', '2025-03-14 17:18:11');

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

--
-- Table structure for table `members`
--

CREATE TABLE `members` (
  `id` int(10) UNSIGNED NOT NULL,
  `order` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `facebook` varchar(255) DEFAULT NULL,
  `twitter` varchar(255) DEFAULT NULL,
  `linkedin` varchar(255) DEFAULT NULL,
  `instagram` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `members`
--

INSERT INTO `members` (`id`, `order`, `name`, `position`, `image`, `facebook`, `twitter`, `linkedin`, `instagram`, `created_at`, `updated_at`) VALUES
(26, 2, 'ENG. Mohamed Adel', 'Managing director', NULL, NULL, NULL, NULL, NULL, '2025-02-24 18:44:38', '2025-02-27 11:35:31'),
(27, 2, 'Eng. Mohamed Abd elwahab', ' Executive Manager', NULL, NULL, NULL, NULL, NULL, '2025-02-24 18:46:13', '2025-02-27 11:35:31'),
(28, 0, 'Eng. Shams eldin Fadly', ' Vice president', NULL, NULL, NULL, NULL, NULL, '2025-02-24 18:47:22', '2025-02-27 11:35:31');

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

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `message` longtext DEFAULT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` (`id`, `name`, `email`, `subject`, `message`, `status`, `created_at`, `updated_at`) VALUES
(11, 'In ma', 'rutolenys@mailinator.com', 'Labor', 'Sunt', '1', '2025-02-21 12:36:17', '2025-02-21 12:36:27'),
(12, 'Joseph C', 'pat@aneesho.com', 'Design Work', 'Do you need help with graphic design - brochures, banners, flyers, advertisements, social media posts, logos etc? \n\nWe charge a low fixed monthly fee.  Let me know if you\'re interested and would like to see our portfolio.', '0', '2025-02-27 05:03:52', '2025-02-27 05:03:52');

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2024_11_18_032026_create_admins_table', 2),
(6, '2024_11_19_094633_create_settings_table', 3),
(7, '2024_11_21_082954_create_skills_table', 4),
(8, '2024_11_30_145019_create_subscribes_table', 5),
(9, '2024_11_30_145020_create_subscribes_table', 6),
(10, '2024_11_30_145021_create_subscribes_table', 7),
(11, '2024_11_30_165023_create_counters_table', 8),
(12, '2024_11_30_165042_create_services_table', 8),
(13, '2024_11_30_200420_create_messages_table', 9),
(14, '2024_12_02_042544_create_categories_table', 10),
(15, '2024_12_04_021525_create_projects_table', 11),
(16, '2024_12_07_182821_create_members_table', 12),
(17, '2024_12_07_183135_create_testmonials_table', 13),
(18, '2025_01_16_132738_create_pages_table', 14),
(19, '2025_01_16_132739_create_pages_table', 15),
(20, '2025_01_27_121731_create_media_table', 16),
(21, '2025_01_27_211556_add_description_to_settings', 17),
(22, '2025_01_27_211560_add_description_to_settings', 18),
(23, '2025_01_28_072830_create_categories_table', 19),
(24, '2025_01_29_074108_add_status_to_services', 20),
(25, '2025_01_29_114856_add_map_to_settings', 21),
(26, '2025_02_11_000001_create_projects_table', 22),
(27, '2025_02_12_085647_create_projects_services_table', 23),
(28, '2025_02_13_131509_create_blogs_table', 24),
(29, '2025_02_14_124828_create_clients_table', 25),
(30, '2025_02_14_235311_create_careers_table', 26),
(31, '2025_02_15_013203_create_jobs_table', 27),
(32, '2025_02_15_013205_create_jobs_table', 28),
(33, '2025_02_26_200423_add_date_to_projects_table', 29),
(34, '2025_02_26_114710_add_order_to_blogs', 30),
(35, '2025_02_26_114727_add_order_to_careers', 30),
(36, '2025_02_26_114746_add_order_to_categories', 30),
(37, '2025_02_26_114751_add_order_to_clients', 30),
(38, '2025_02_26_114810_add_order_to_members', 30),
(39, '2025_02_26_114832_add_order_to_pages', 30),
(40, '2025_02_26_114835_add_order_to_projects', 30),
(41, '2025_02_26_114846_add_order_to_services', 30),
(42, '2025_02_27_080407_add_location_to_projects', 31);

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

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

CREATE TABLE `pages` (
  `id` int(10) UNSIGNED NOT NULL,
  `order` int(11) DEFAULT NULL,
  `name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`name`)),
  `title` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`title`)),
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`description`)),
  `meta_title` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`meta_title`)),
  `meta_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`meta_description`)),
  `slug` text NOT NULL,
  `status` enum('Active','Not Active') NOT NULL DEFAULT 'Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `pages` (`id`, `order`, `name`, `title`, `description`, `meta_title`, `meta_description`, `slug`, `status`, `created_at`, `updated_at`) VALUES
(12, 1, '{\"en\":\"Home\",\"ar\":\"الرئيسية\"}', '{\"en\":\"Home\",\"ar\":\"الرئيسية\"}', '{\"en\":\"SiteWork for Contracting and Landscaping was established for designing and installing irrigation networks, central control systems, supply and cultivate ornamental plants for commercial and residential projects, designing and construction of sport courts (specially football courts and polo courts), also construction and maintenance for fountains and swimming pools\",\"ar\":\"تم تأسيس شركة SiteWork للمقاولات وتنسيق الحدائق\\nتصميم وتركيب شبكات الري والتحكم المركزي\\nنظم وتوريد وزراعة نباتات الزينة لأغراض تجارية\\nوالمشاريع السكنية وتصميم وبناء الرياضة\\nالملاعب (خاصة ملاعب كرة القدم وملاعب البولو).\\nبناء وصيانة النوافير والسباحة\\nحمامات سباحة .\"}', '{\"en\":\"Home\",\"ar\":\"الرئيسية\"}', '{\"en\":\"SiteWork for Contracting and Landscaping was established for designing and installing irrigation networks, central control systems, supply and cultivate ornamental plants for commercial and residential projects, designing and construction of sport courts (specially football courts and polo courts), also construction and maintenance for fountains and swimming pools\",\"ar\":\"تم تأسيس شركة SiteWork للمقاولات وتنسيق الحدائق\\nتصميم وتركيب شبكات الري والتحكم المركزي\\nنظم وتوريد وزراعة نباتات الزينة لأغراض تجارية\\nوالمشاريع السكنية وتصميم وبناء الرياضة\\nالملاعب (خاصة ملاعب كرة القدم وملاعب البولو).\\nبناء وصيانة النوافير والسباحة\\nحمامات سباحة .\"}', 'home', 'Active', '2025-01-27 12:04:33', '2025-02-22 16:31:57'),
(13, 2, '{\"en\":\"About us\",\"ar\":\"معلومات عنا\"}', '{\"en\":\"About us\",\"ar\":\"عنا\"}', '{\"en\":\"<p>SiteWork for Contracting and Landscaping was established for designing and installing irrigation networks, central control systems, supply and cultivate ornamental plants for commercial </p><p>and residential projects, designing and construction of sport courts </p><p>(specially football courts and polo courts), also construction and </p><p>maintenance for fountains and swimming pools .</p>\",\"ar\":\"<p>شركة سايت وورك للمقاولات وأعمال اللاند سكيب تم تأسيسها لتصميم وتركيب شبكات الري وأنظمة التحكم المركزي، وتوريد وزراعة نباتات الزينة للمشاريع التجارية والسكنية، وتصميم وبناء الملاعب الرياضية )خاصة ملاعب كرة القدم والبولو(، وأيًًضًًا إنشاء </p><p>وصيانة النوافير وحمامات السباحة.</p>\"}', '{\"en\":\"About us\",\"ar\":\"عنا\"}', '{\"en\":\"<p>SiteWork for Contracting and Landscaping was established for designing and installing irrigation networks, central control systems, supply and cultivate ornamental plants for commercial </p><p>and residential projects, designing and construction of sport courts </p><p>(specially football courts and polo courts), also construction and </p><p>maintenance for fountains and swimming pools .</p>\",\"ar\":\"<p>شركة سايت وورك للمقاولات وأعمال اللاند سكيب تم تأسيسها لتصميم وتركيب شبكات الري وأنظمة التحكم المركزي، وتوريد وزراعة نباتات الزينة للمشاريع التجارية والسكنية، وتصميم وبناء الملاعب الرياضية )خاصة ملاعب كرة القدم والبولو(، وأيًًضًًا إنشاء </p><p>وصيانة النوافير وحمامات السباحة.</p>\"}', 'about', 'Active', '2025-01-27 12:09:43', '2025-02-19 10:09:33'),
(14, 3, '{\"en\":\"Services\",\"ar\":\"خدمات\"}', '{\"en\":\"Services\",\"ar\":\"خدمات\"}', '{\"ar\":\"\"}', '{\"en\":\"Services\",\"ar\":\"خدمات\"}', '{\"ar\":\"\"}', 'services', 'Active', '2025-01-27 12:10:55', '2025-03-06 19:54:25'),
(15, 4, '{\"en\":\"Projects\",\"ar\":\"المشاريع\"}', '{\"en\":\"Projects\",\"ar\":\"المشاريع\"}', '{\"ar\":\"\"}', '{\"en\":\"Projects\",\"ar\":\"المشاريع\"}', '{\"ar\":\"\"}', 'projects', 'Active', '2025-01-27 12:13:01', '2025-03-06 19:54:23'),
(16, 5, '{\"en\":\"Career\",\"ar\":\"Career\"}', '{\"en\":\"Career\",\"ar\":\"Career\"}', '{\"ar\":null}', '{\"en\":\"Career\",\"ar\":\"Career\"}', '{\"ar\":null}', 'career', 'Active', '2025-01-27 12:13:45', '2025-03-06 19:54:22'),
(17, 6, '{\"en\":\"Contact Us\",\"ar\":\"Contact Us\"}', '{\"en\":\"Contact Us\",\"ar\":\"Contact Us\"}', '{\"ar\":null}', '{\"en\":\"Contact Us\",\"ar\":\"Contact Us\"}', '{\"ar\":null}', 'contact-us', 'Active', '2025-01-27 12:15:52', '2025-03-06 19:54:22'),
(18, 7, '{\"en\":\"Blogs\",\"ar\":\"مدونات\"}', '{\"en\":\"Blogs\",\"ar\":\"مدونات\"}', '{\"ar\":\"\"}', '{\"en\":\"Blogs\",\"ar\":\"مدونات\"}', '{\"ar\":\"\"}', 'blogs', 'Not Active', '2025-01-27 12:16:32', '2025-03-13 18:16:13');

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

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` int(10) UNSIGNED NOT NULL,
  `order` int(11) DEFAULT NULL,
  `name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`name`)),
  `title` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`title`)),
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`description`)),
  `meta_title` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`meta_title`)),
  `meta_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`meta_description`)),
  `slug` text NOT NULL,
  `status` enum('Not Active','Active') NOT NULL DEFAULT 'Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `date` date DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` (`id`, `order`, `name`, `title`, `description`, `meta_title`, `meta_description`, `slug`, `status`, `created_at`, `updated_at`, `date`, `location`) VALUES
(10, 1, '{\"en\":\"Bloomfields\",\"ar\":\"بلوم فيلدز\"}', '{\"en\":\"Bloomfields \",\"ar\":\"بلوم فيلدز\"}', '{\"en\":\"<p>Project Location: Mostakbal City, New Cairo Developer: Tatweer Misr Project Duration: June 2023 – Present Scope of Work:Comprehensive landscaping, including irrigation and plantation.</p>\",\"ar\":\"<p><strong>الموقع: </strong>مستقبل سيتي – القاهرة الجديدة</p><p><strong>الشركة المطورة: </strong>تطوير مصر </p><p><strong>تاريخ المشروع:</strong> يونيه 2023: الآن </p><p><strong>طبيعة الأعمال: </strong>كافة أعمال اللاند سكيب بما تضمه من ري وزراعة. </p>\"}', '{\"en\":\"Bloomfields \",\"ar\":\"بلوم فيلدز\"}', '{\"en\":\"<p>Bloom fields</p>\",\"ar\":\"<p>Bloom fields</p>\"}', 'Bloomfields ', 'Active', '2025-02-22 15:17:05', '2025-03-14 15:40:40', NULL, 'Mostakbal city'),
(11, 2, '{\"en\":\"Al masa Hotel -   New administrative capital  \",\"ar\":\"فندق الماسة العاصمة الإدارية\"}', '{\"en\":\"Al masa Hotel -   New administrative capital  \",\"ar\":\"فندق الماسة العاصمة الإدارية\"}', '{\"en\":\"<h3><strong>Project Name:</strong> Al Masa Capital Hotel</h3><p><strong>Developer:</strong> Hilton</p><p> <strong>Project Date:</strong> May 2019</p><p> <strong>Scope of Work:</strong> Supply and installation of irrigation networks, as well as supply and planting of greenery.</p>\",\"ar\":\"<p><strong>اسم المشروع: </strong>فندق الماسة كابيتال</p><p><strong>الشركة المطورة: </strong>هيلتون</p><p><strong>تاريخ المشروع: </strong>مايو 2019</p><p><strong>طبيعة الأعمال:</strong> أعمال توريد وتركيب شبكات الري، وأعمال توريد وزراعة النباتات</p>\"}', '{\"en\":\"Al masa Hotel -   New administrative capital  \",\"ar\":\"فندق الماسة العاصمة الإدارية\"}', '{\"en\":\"<p>Al masa hotel</p>\",\"ar\":\"<p>Al masa hotel</p>\"}', 'Al masa Hotel - Hilton', 'Active', '2025-02-26 04:54:43', '2025-03-14 15:41:53', '2017-05-24', ' New administrative capital  '),
(13, 4, '{\"en\":\"D- Bay\",\"ar\":\"داي باي\"}', '{\"en\":\"D- Bay\",\"ar\":\"داي باي\"}', '{\"en\":\"<p><strong>Project Location:</strong> North Coast, Ras El Hekma</p><p> <strong>Developer:</strong> Tatweer Misr</p><p> <strong>Project Duration:</strong> June 2023 – Present</p><p> <strong>Scope of Work:</strong> Comprehensive landscaping, including irrigation and plantation.</p>\",\"ar\":\"<p class=\\\"ql-align-right\\\"><strong>الموقع:</strong> الساحل الشمالي رأس الحكمة </p><p class=\\\"ql-align-right\\\"><strong>الشركة المطورة:</strong> تطوير مصر </p><p class=\\\"ql-align-right\\\"><strong>تاريخ المشروع:</strong> يونيه 2023: الآن </p><p class=\\\"ql-align-right\\\"><strong>طبيعة الأعمال: </strong>كافة أعمال اللاند سكيب بما تضمه من ري وزراعة. </p>\"}', '{\"en\":\"D- Bay\",\"ar\":\"داي باي\"}', '{\"en\":\"<p>D - Bay </p>\",\"ar\":\"<p>داي باي</p>\"}', 'D- Bay', 'Active', '2025-02-26 10:14:33', '2025-03-14 15:46:07', NULL, 'North coast - Ras Elhekma'),
(15, 3, '{\"en\":\"Azad\",\"ar\":\"آزاد\"}', '{\"en\":\"Azad compound\",\"ar\":\"كمبوند آزاد\"}', '{\"en\":\"<p><strong>Project Location:</strong> Fifth Settlement, New Cairo</p><p> <strong>Developer:</strong> Tameer</p><p> <strong>Project Duration:</strong> May 2023 – December 2024</p><p> <strong>Scope of Work:</strong> Landscaping maintenance, including irrigation and plantation</p>\",\"ar\":\"<p>الموقع: التجمع الخامس - القاهرة الجديدة الشركة المطورة: تعمير تاريخ المشروع: مايو 2023: ديسمبر 2024 طبيعة الأعمال: صيانة أعمال اللاند سكيب بما تضمه من ري وزراعة.</p><p><br></p><h6><br></h6><p><br></p>\"}', '{\"en\":\"Azad\",\"ar\":\"Azad\"}', '{\"en\":\"<p>Azad</p>\",\"ar\":\"<p>Azad</p>\"}', 'Azad', 'Active', '2025-03-13 17:50:49', '2025-03-13 17:51:58', NULL, 'New Cairo'),
(16, 7, '{\"en\":\"Hilton Secon Nile Towers\",\"ar\":\"سيكون نايل تاورز\"}', '{\"en\":\"Hilton Secon Nile Towers\",\"ar\":\"سيكون نايل تاورز\"}', '{\"en\":\"<p><strong>Location:</strong> Maadi</p><p> <strong>Developer:</strong> Egyptian Industries &amp; Construction Company</p><p> <strong>Project Date:</strong> January 2020 – Ongoing</p><p> <strong>Scope of Work:</strong> Irrigation network works for <strong>Green Walls</strong>.</p>\",\"ar\":\"<p class=\\\"ql-align-right\\\"><strong>الموقع:</strong> المعادي</p><p class=\\\"ql-align-right\\\"> <strong>الشركة المطورة:</strong> الشركة المصرية للصناعات والتشييد</p><p class=\\\"ql-align-right\\\"> <strong>تاريخ المشروع:</strong> يناير 2020 – جاري التنفيذ</p><p class=\\\"ql-align-right\\\"> <strong>طبيعة الأعمال:</strong> أعمال شبكة الري <strong>للجدران الخضراء (Green Walls)</strong>.</p>\"}', '{\"en\":\"Hilton Secon Nile Towers\",\"ar\":\"سيكون نايل تاورز\"}', '{\"ar\":\"\"}', 'Hilton Secon Nile Towers', 'Active', '2025-03-14 16:44:00', '2025-03-14 17:28:53', NULL, 'Maddi'),
(17, 7, '{\"en\":\"City of Arts and Culture\",\"ar\":\"مدينة الفنون والثقافة \"}', '{\"en\":\"City of Arts and Culture\",\"ar\":\"مدينة الفنون والثقافة - الأوبرا\"}', '{\"ar\":\"<p><br></p>\"}', '{\"en\":\"City of Arts and Culture\",\"ar\":\"مدينة الفنون والثقافة - الأوبرا\"}', '{\"ar\":\"\"}', 'City of Arts and Culture', 'Active', '2025-03-14 17:18:11', '2025-03-14 17:28:21', NULL, 'New administrative capital ');

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

--
-- Table structure for table `projects_services`
--

CREATE TABLE `projects_services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `project_id` bigint(20) UNSIGNED NOT NULL,
  `service_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `projects_services`
--

INSERT INTO `projects_services` (`id`, `project_id`, `service_id`, `created_at`, `updated_at`) VALUES
(1, 8, 8, NULL, NULL),
(2, 8, 9, NULL, NULL),
(3, 8, 10, NULL, NULL),
(4, 9, 8, NULL, NULL),
(5, 9, 12, NULL, NULL),
(6, 9, 10, NULL, NULL),
(7, 7, 9, NULL, NULL),
(8, 7, 10, NULL, NULL),
(9, 7, 11, NULL, NULL),
(10, 10, 14, NULL, NULL),
(11, 10, 15, NULL, NULL),
(12, 12, 15, NULL, NULL),
(13, 12, 16, NULL, NULL),
(14, 13, 16, NULL, NULL),
(15, 13, 15, NULL, NULL),
(16, 13, 17, NULL, NULL),
(17, 11, 16, NULL, NULL),
(18, 11, 17, NULL, NULL),
(19, 14, 14, NULL, NULL),
(20, 15, 18, NULL, NULL),
(21, 16, 16, NULL, NULL),
(22, 16, 20, NULL, NULL),
(23, 17, 17, NULL, NULL);

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` int(10) UNSIGNED NOT NULL,
  `order` int(11) DEFAULT NULL,
  `title` longtext NOT NULL,
  `description` longtext DEFAULT NULL,
  `status` enum('Not Active','Active') NOT NULL DEFAULT 'Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `order`, `title`, `description`, `status`, `created_at`, `updated_at`) VALUES
(14, 2, '{\"en\":\"Design of landscape works\",\"ar\":\"تصميم أعمال اللاند سكيب \"}', '{\"en\":\"<p>Our team handles all landscaping work, including both hardscape and softscape, covering all irrigation and planting services.</p>\",\"ar\":\"<p>يقوم فريقنا بكافة الأعمال المتعلقة باللاندسكيب سواء هارد سكيب أو سوفت سكيب، بما يتضمن كافة أعمال الري والزراعة.</p>\"}', 'Active', '2025-02-21 12:30:08', '2025-03-14 12:52:35'),
(15, 3, '{\"en\":\"Landscape commercial & residential installation irrigation\",\"ar\":\"تنفيذ أعمال اللاند سكيب للمشروعات التجارية والسكنية \"}', '{\"en\":\"<p><strong>Site Work</strong> provides comprehensive landscape execution services for commercial and residential projects, including green space design, irrigation system installation, and plant cultivation to create sustainable and visually appealing environments.</p>\",\"ar\":\"<p>تقدم <strong>سايت وورك</strong> خدمات متكاملة لتنفيذ أعمال اللاندسكيب للمشروعات التجارية والسكنية، بما يشمل تصميم وتنسيق المساحات الخضراء، تركيب أنظمة الري، وزراعة النباتات لضمان بيئة طبيعية مستدامة وجذابة.</p>\"}', 'Active', '2025-02-22 15:12:57', '2025-03-14 13:04:00'),
(16, 4, '{\"en\":\"Irrigation Network Design for Projects\",\"ar\":\"تصميم شبكات الري للمشروعات\"}', '{\"en\":\"<p>At <strong>Site Work</strong>, we specialize in designing irrigation networks for projects, ensuring optimal water distribution and sustainable green spaces using the latest technologies.</p>\",\"ar\":\"<p>نقدم في <strong>سايت وورك</strong> خدمات تصميم شبكات الري للمشروعات، مع مراعاة تحقيق أعلى كفاءة في توزيع المياه وضمان استدامة المسطحات الخضراء بأحدث التقنيات.</p>\"}', 'Active', '2025-02-25 11:48:05', '2025-03-14 13:05:07'),
(17, 5, '{\"en\":\"Ornamental Plant Landscaping\",\"ar\":\"تنسيق نباتات الزينة \"}', '{\"en\":\"<p>At <strong>Site Work</strong>, we specialize in ornamental plant arrangement, enhancing outdoor spaces with beauty and vibrancy. Our services include plant selection, layout design, and professional planting to ensure both aesthetics and sustainability.</p>\",\"ar\":\"<p>نقدم في <strong>سايت وورك</strong> خدمات متخصصة في تنسيق نباتات الزينة، مما يضفي لمسة جمالية وحيوية على المساحات الخارجية. تشمل خدماتنا اختيار النباتات المناسبة، تصميم التوزيع، وزراعتها بأسلوب يجمع بين الجمال والاستدامة.</p>\"}', 'Active', '2025-02-25 12:00:16', '2025-03-14 13:01:25'),
(18, 6, '{\"en\":\"Green Spaces and Irrigation Network Maintenance\",\"ar\":\"كافة أعمال صيانة المسطحات الخضراء وشبكات الري\"}', '{\"en\":\"<p><strong>Site Work</strong> offers comprehensive maintenance for green spaces and irrigation systems, ensuring healthy and sustainable landscapes. Our services include lawn mowing, tree pruning, irrigation system upkeep,</p>\",\"ar\":\"<p>توفر <strong>سايت وورك</strong> خدمات صيانة متكاملة للمسطحات الخضراء وشبكات الري، مما يضمن مظهرًا صحيًا ومستدامًا للمساحات الخارجية. تشمل خدماتنا جز العشب، تقليم الأشجار، صيانة أنظمة الري، وتحسين جودة التربة، باستخدام أحدث التقنيات لضمان كفاءة الموارد وجمال المناظر الطبيعية.</p>\"}', 'Active', '2025-03-13 17:43:20', '2025-03-13 17:44:26'),
(19, 5, '{\"en\":\"Irrigation water management for project\",\"ar\":\"إدارة مياه الري للمشروعات\"}', '{\"en\":\"<p><strong>Site Work</strong> provides comprehensive irrigation water management solutions, ensuring optimal water usage for projects. Our services include planning, monitoring, and maintaining irrigation systems for greater efficiency and sustainability.</p>\",\"ar\":\"<p>توفر <strong>سايت وورك</strong> حلولًا متكاملة لإدارة مياه الري، مما يضمن الاستخدام الأمثل للموارد المائية في المشروعات. تشمل خدماتنا التخطيط، المراقبة، والصيانة لأنظمة الري لتحقيق كفاءة واستدامة أعلى.</p>\"}', 'Active', '2025-03-14 12:58:02', '2025-03-14 12:58:02'),
(20, 6, '{\"en\":\"Hardscape Works & Mechanical Systems for Fountains and Swimming Pools\",\"ar\":\"أعمال الهارد سكيب والأعمال الميكانيكية للنوافير وحمامات السباحة\"}', '{\"en\":\"<p><strong>Site Work</strong> provides comprehensive hardscape services, including the installation of walkways, patios, and decorative stonework. We also specialize in mechanical systems for fountains and swimming pools, ensuring efficient operation and durability. Additionally, we offer <strong>pergola installation</strong>, creating shaded outdoor spaces that blend functionality with aesthetic appeal.</p><p><br></p>\",\"ar\":\"<p><span style=\\\"background-color: rgb(255, 255, 255); color: rgb(105, 122, 141);\\\">توفر سايت وورك خدمات متكاملة في أعمال الهاردسكيب، بما في ذلك تنفيذ الممرات، الأفنية، والأحجار الزخرفية. كما نختص في الأعمال الميكانيكية للنوافير وحمامات السباحة لضمان كفاءة التشغيل والمتانة. بالإضافة إلى ذلك، نقدم خدمة تركيب البرجولات لتوفير مساحات مظللة تجمع بين الجمال والوظيفة العملية.</span></p>\"}', 'Active', '2025-03-14 16:09:16', '2025-03-14 16:16:28');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `map` longtext DEFAULT NULL,
  `description_en` longtext DEFAULT NULL,
  `description_ar` longtext DEFAULT NULL,
  `facebook` varchar(255) DEFAULT NULL,
  `twitter` varchar(255) DEFAULT NULL,
  `linkedin` varchar(255) DEFAULT NULL,
  `instagram` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `name`, `address`, `phone`, `email`, `map`, `description_en`, `description_ar`, `facebook`, `twitter`, `linkedin`, `instagram`, `created_at`, `updated_at`) VALUES
(1, 'sitework', '102 El-Thawra St, Almazah, Heliopolis, Cairo Governorate 4461204', '+2 01005055276', 'info@sitework-egy.com', '{\"len\":\"30.082297528513646\",\"lat\":\"31.34467480920883\"}', 'Sunday to Thursday: 9 AM - 6 PM\nSaturday: 10 AM - 4 PM\nFriday: Closed', 'Sunday to Thursday: 9 AM - 6 PM\nSaturday: 10 AM - 4 PM\nFriday: Closed', 'https://www.facebook.com/SiteWorkOfficial2019', 'twitter', 'https://www.linkedin.com/company/30744132/admin/?lipi=urn%3Ali%3Apage%3Ad_flagship3_feed%3BO01Eohd8T2G36qy1%2BXIwMw%3D%3D', 'https://www.instagram.com/sitework.landscape?utm_source=ig_web_button_share_sheet&igsh=ZDNlZDc0MzIxNw==', '2024-11-19 08:13:28', '2025-03-13 18:08:10');

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

--
-- Table structure for table `subscribes`
--

CREATE TABLE `subscribes` (
  `id` int(10) UNSIGNED NOT NULL,
  `email` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscribes`
--

INSERT INTO `subscribes` (`id`, `email`, `created_at`, `updated_at`) VALUES
(5, 'mmedkhaater@mail.com', NULL, NULL),
(6, 'mmedkhaater@google.com', NULL, NULL),
(8, 'paxu@mailinator.com', '2024-12-07 18:52:24', '2024-12-07 18:52:24'),
(9, 'rugico@mailinator.com', '2024-12-07 19:08:06', '2024-12-07 19:08:06');

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

--
-- Table structure for table `testmonials`
--

CREATE TABLE `testmonials` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testmonials`
--

INSERT INTO `testmonials` (`id`, `name`, `description`, `position`, `image`, `created_at`, `updated_at`) VALUES
(1, 'khater', 'Omnis', 'Id in', 'storage/images/1733600024.jpeg', '2024-12-07 17:33:44', '2024-12-07 17:34:50'),
(2, 'Freya Santos', 'Sit ', 'Nesci', 'storage/images/1733600036.jpeg', '2024-12-07 17:33:56', '2024-12-07 17:33:56'),
(3, 'Inez Horne', 'In pl', 'Dolor', 'storage/images/1733600053.jpeg', '2024-12-07 17:34:13', '2024-12-07 17:34:13');

--
-- Indexes for table `blogs`
--
ALTER TABLE `blogs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `careers`
--
ALTER TABLE `careers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `clients`
--
ALTER TABLE `clients`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `counters`
--
ALTER TABLE `counters`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `media_uuid_unique` (`uuid`),
  ADD KEY `media_model_type_model_id_index` (`model_type`,`model_id`),
  ADD KEY `media_order_column_index` (`order_column`);

--
-- Indexes for table `members`
--
ALTER TABLE `members`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `projects`
--
ALTER TABLE `projects`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `projects_services`
--
ALTER TABLE `projects_services`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `subscribes`
--
ALTER TABLE `subscribes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `subscribes_email_unique` (`email`);

--
-- Indexes for table `testmonials`
--
ALTER TABLE `testmonials`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `careers`
--
ALTER TABLE `careers`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `clients`
--
ALTER TABLE `clients`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `counters`
--
ALTER TABLE `counters`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `media`
--
ALTER TABLE `media`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=246;

--
-- AUTO_INCREMENT for table `members`
--
ALTER TABLE `members`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `projects`
--
ALTER TABLE `projects`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `projects_services`
--
ALTER TABLE `projects_services`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `subscribes`
--
ALTER TABLE `subscribes`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `testmonials`
--
ALTER TABLE `testmonials`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
COMMIT;

