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

START TRANSACTION;



--
-- Database: `el-badeel`
--

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

--
-- Table structure for table `about_page`
--

CREATE TABLE `about_page` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `inp_type` enum('text','image') COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `about_page`
--

INSERT INTO `about_page` (`id`, `inp_type`, `title`, `value`) VALUES
(1, 'image', 'Contact_page_banner', '25237.webp'),
(2, 'text', 'WHO_WE_ARE_en', 'The expertise and diversity of the firm founders have helped to create harmony and strong bonds in its management’s leadership, by adding value due to their knowledge in Saudi Arabia, for the 10 years working in high profile, multi‐million Saudi riyal projects in the kingdom. Their proficiency has also amplified by collaborating with international and great reputable Contractors of the likes of Consultants and Project Management Firms such as Saudi Bin Laden Group, Proger, Dar Al Handasa , Arup , Shaker, etc. elevates the profile of the firm to compete with the other reputable established companies in the field.\r\n Al‐Badeel has been specialized and has distinguished itself in Reinforced Concrete, finishing, Landscaping, Mechanical, Electrical,Plumbing, Civil defence and HVAC works in the Construction Industry Services (CIS) utilizing all the engineering services related to itsproduction, thus becoming distinguished pioneers in this sector in the Saudi market.'),
(3, 'text', 'WHO_WE_ARE_ar', 'The expertise and diversity of the firm founders have helped to create harmony and strong bonds in its management’s leadership, by adding value due to their knowledge in Saudi Arabia, for the 10 years working in high profile, multi‐million Saudi riyal projects in the kingdom. Their proficiency has also amplified by collaborating with international and great reputable Contractors of the likes of Consultants and Project Management Firms such as Saudi Bin Laden Group, Proger, Dar Al Handasa , Arup , Shaker, etc. elevates the profile of the firm to compete with the other reputable established companies in the field. Al‐Badeel has been specialized and has distinguished itself in Reinforced Concrete, finishing, Landscaping, Mechanical, Electrical,Plumbing, Civil defence and HVAC works in the Construction Industry Services (CIS) utilizing all the engineering services related to itsproduction, thus becoming distinguished pioneers in this sector in the Saudi market.'),
(4, 'image', 'Download_Profile', '40749.png'),
(5, 'text', 'VISION_en', 'Ensuring ultimate services. \r\n- Customer satisfaction through exceeding their expectations. \r\n- Expanding horizontally and vertically. \r\n- Continuous and Never‐Ending Development . \r\n- Concentration at the firm Core Business and developing the skills of its employees. \r\n- Successful business that insures what we like to call “TRIPOD SUCCESS”between Client , Company and End Users.'),
(6, 'text', 'VISION_ar', 'Ensuring ultimate services. - Customer satisfaction through exceeding their expectations. - Expanding horizontally and vertically. - Continuous and Never‐Ending Development . - Concentration at the firm Core Business and developing the skills of its employees. - Successful business that insures what we like to call “TRIPOD SUCCESS”between Client , Company and End Users.'),
(7, 'text', 'MISSION_en', 'Al‐Badeel is Full Service Engineering and Contracting Firm, specialized in concrete MEP works execution and serving clients in all areas in the workflow. The firm focuses in providing the highest quality and standards within a minimal time frame, a rarity with contractors in the field, yet we strive to achieve this goal. Our purpose to serve our clients so that their expectations for their projects are met and even exceeded. Our most important service, outpost is happy, 100% satisfied customer.'),
(8, 'text', 'MISSION_ar', 'Al‐Badeel is Full Service Engineering and Contracting Firm, specialized in concrete MEP works execution and serving clients in all areas in the workflow. The firm focuses in providing the highest quality and standards within a minimal time frame, a rarity with contractors in the field, yet we strive to achieve this goal. Our purpose to serve our clients so that their expectations for their projects are met and even exceeded. Our most important service, outpost is happy, 100% satisfied customer.'),
(9, 'text', 'BOARD_OF_DIRECTORS_en', 'Our Top Management Team is a cluster of skilled personnel with over 20 years of experience in the construction industry, in the Gulf market, working with high profile multi‐million projects and of international standard with the involvement of companies of international reputation.'),
(10, 'text', 'BOARD_OF_DIRECTORS_ar', 'Our Top Management Team is a cluster of skilled personnel with over 20 years of experience in the construction industry, in the Gulf market, working with high profile multi‐million projects and of international standard with the involvement of companies of international reputation.'),
(11, 'text', 'TEAMWORK_en', '85% of the firm’s human resource is the work‐force; the foundation stone on which the firm stands that insures the success of the business. Top Management is adamant, in close collaboration with construction team, in closely monitoring the workforce, properly training them to become even more skilled, as well as paying attention to all their aspects. We trust that this process assures the best results, as we believe that the human element is at the core of all our undertakings.'),
(12, 'text', 'TEAMWORK_ar', '85% of the firm’s human resource is the work‐force; the foundation stone on which the firm stands that insures the success of the business. Top Management is adamant, in close collaboration with construction team, in closely monitoring the workforce, properly training them to become even more skilled, as well as paying attention to all their aspects. We trust that this process assures the best results, as we believe that the human element is at the core of all our undertakings.'),
(13, 'image', 'VISION_image', '74085.webp'),
(14, 'image', 'MISSION_image', '28286.webp');

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

--
-- Table structure for table `board_of_directors`
--

CREATE TABLE `board_of_directors` (
  `id` int(11) NOT NULL,
  `name_en` varchar(225) NOT NULL,
  `name_ar` varchar(225) NOT NULL,
  `job_en` varchar(225) NOT NULL,
  `job_ar` varchar(225) NOT NULL,
  `description_en` text NOT NULL,
  `description_ar` text NOT NULL,
  `image` varchar(225) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `position` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `board_of_directors`
--

INSERT INTO `board_of_directors` (`id`, `name_en`, `name_ar`, `job_en`, `job_ar`, `description_en`, `description_ar`, `image`, `status`, `position`, `created_at`, `updated_at`) VALUES
(1, 'Eng. Reda Abd El Kader', 'Eng. Reda Abd El Kader', 'Executive Manager', 'Executive Manager', 'The Saudi market is an open and diverse market, which give us the freedom to innovate and do our best, our work team is always in a race against the time, so our goal has been to provide the highest quality and standards within a minimal time frame”', 'The Saudi market is an open and diverse market, which give us the freedom to innovate and do our best, our work team is always in a race against the time, so our goal has been to provide the highest quality and standards within a minimal time frame”', 'BoardOfDirectors_79732.webp', 1, 0, '2023-07-10 16:31:08', '2023-07-10 16:38:24'),
(2, 'Cassidy Patel', 'Armand Grant', 'Amet hic duis ratio', 'Est consequatur pla', 'Pariatur Perferendi', 'Sunt id perspiciati', 'BoardOfDirectors_92442.webp', 1, 0, '2023-07-10 16:32:16', '2023-07-10 16:38:12'),
(3, 'Eng. Reda Abd El Kader', 'Eng. Reda Abd El Kader', 'Executive Manager', 'Executive Manager', 'The Saudi market is an open and diverse market, which give us the freedom to innovate and do our best, our work team is always in a race against the time, so our goal has been to provide the highest quality and standards within a minimal time frame”', 'The Saudi market is an open and diverse market, which give us the freedom to innovate and do our best, our work team is always in a race against the time, so our goal has been to provide the highest quality and standards within a minimal time frame”', 'BoardOfDirectors_79732.webp', 1, 0, '2023-07-10 16:31:08', '2023-07-10 16:38:24');

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

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

CREATE TABLE `careers` (
  `id` int(11) NOT NULL,
  `name` varchar(225) NOT NULL,
  `phone` varchar(225) NOT NULL,
  `email` varchar(225) NOT NULL,
  `city` varchar(225) NOT NULL,
  `country` varchar(225) NOT NULL,
  `category_id` int(11) NOT NULL,
  `cv` varchar(225) NOT NULL,
  `is_contacted` tinyint(4) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `careers` (`id`, `name`, `phone`, `email`, `city`, `country`, `category_id`, `cv`, `is_contacted`, `created_at`, `updated_at`) VALUES
(1, 'Breanna Espinoza', '+1 (292) 425-5329', 'buwu@mailinator.com', 'Pariatur Nostrud re', 'Quia distinctio Qui', 2, 'Careers_25742.webp', 0, '2023-07-09 16:26:37', '2023-07-11 16:15:01');

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

--
-- Table structure for table `categories_of_projects`
--

CREATE TABLE `categories_of_projects` (
  `id` int(11) NOT NULL,
  `name_en` varchar(225) NOT NULL,
  `name_ar` varchar(225) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `position` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `categories_of_projects`
--

INSERT INTO `categories_of_projects` (`id`, `name_en`, `name_ar`, `status`, `position`, `created_at`, `updated_at`) VALUES
(1, 'Urban Planning & Residential', 'التخطيط العمراني والسكني', 1, 1, '2023-03-06 19:08:15', '2023-05-28 15:41:01'),
(2, 'Commercial & Administrative', 'تجاري وإداري', 1, 2, '2023-03-06 19:08:43', '2023-05-28 15:40:50'),
(3, 'Culture & Religious', 'الثقافة والدينية', 1, 3, '2023-03-13 17:55:18', '2023-05-28 15:40:42'),
(4, 'Educational & Healthcare', 'التعليم والرعاية الصحية', 1, 4, '2023-03-13 17:55:26', '2023-05-28 15:40:27');

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

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name_en` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_ar` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_price` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `position` int(11) 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 `cities`
--

INSERT INTO `cities` (`id`, `name_en`, `name_ar`, `shipping_price`, `status`, `position`, `created_at`, `updated_at`) VALUES
(1, 'cairo', 'القاهرة', 0, 1, 0, '2020-03-11 12:00:09', '2020-07-15 11:52:47'),
(426, 'Alexandria', 'الاسكندرية', 0, 0, 0, '2020-03-30 08:26:46', '2020-07-15 11:52:04'),
(427, 'Sharm Shekh', 'شرم الشيخ', 0, 0, 0, '2020-04-03 15:41:04', '2020-07-15 11:52:03'),
(428, 'Giza', 'الجيزة', 0, 1, 0, '2020-04-03 15:42:02', '2020-07-18 10:11:01'),
(429, 'Ismalia', 'الإسماعيلية', 0, 0, 0, '2020-05-11 08:18:13', '2020-07-15 11:52:02'),
(430, 'Aswan', 'أسوان', 0, 0, 0, '2020-05-11 08:18:30', '2020-07-15 11:52:01'),
(431, 'Aswuit', 'اسيوط', 0, 0, 0, '2020-05-11 08:19:08', '2020-07-15 11:52:00'),
(432, 'luxer', 'الأقصر', 0, 0, 0, '2020-05-11 08:24:57', '2020-07-15 11:52:00'),
(433, 'RED SEA', 'البحر الأحمر', 0, 0, 0, '2020-05-11 08:25:13', '2020-07-15 11:52:00'),
(434, 'El behera', 'البحيرة', 0, 0, 0, '2020-05-11 08:25:56', '2020-07-15 11:51:59'),
(435, 'Bani Swaif', 'بني سويف', 0, 0, 0, '2020-05-11 08:27:09', '2020-07-15 11:51:59'),
(436, 'Port Said', 'بورسعيد', 0, 0, 0, '2020-05-11 08:27:27', '2020-07-15 11:51:58'),
(437, 'South of Sinai', 'جنوب سيناء', 0, 0, 0, '2020-05-11 08:28:04', '2020-07-15 11:51:58'),
(438, 'El dakahlia', 'الدقهلية', 0, 0, 0, '2020-05-11 08:29:04', '2020-07-15 11:52:30'),
(439, 'Damietta', 'دمياط', 0, 0, 0, '2020-05-11 08:29:28', '2020-07-15 11:52:29'),
(440, 'Sohag', 'سوهاج', 0, 0, 0, '2020-05-11 08:29:46', '2020-07-15 11:52:28'),
(441, 'Suez', 'السويس', 0, 0, 0, '2020-05-11 08:30:05', '2020-07-15 11:52:27'),
(442, 'El-Sharqia', 'الشرقية', 0, 0, 0, '2020-05-11 08:30:23', '2020-07-15 11:52:25'),
(443, 'North Sinai', 'شمال سيناء', 0, 0, 0, '2020-05-11 08:30:52', '2020-07-15 11:52:24'),
(444, 'El-Gharbia', 'الغربية', 0, 0, 0, '2020-05-11 08:31:33', '2020-07-15 11:52:21'),
(445, 'EL-Fayoum', 'الفيوم', 0, 0, 0, '2020-05-11 08:31:53', '2020-07-15 11:52:18'),
(446, 'EL- Qaliopia', 'القليوبية', 0, 1, 0, '2020-05-11 08:32:42', '2020-07-15 11:54:17'),
(447, 'QNA', 'قنا', 0, 0, 0, '2020-05-11 08:32:56', '2020-07-15 11:52:16'),
(448, 'Kafr El-Sheikh', 'كفر الشيخ', 0, 0, 0, '2020-05-11 08:33:09', '2020-07-15 11:52:15'),
(449, 'Matruh', 'مطروح', 0, 0, 0, '2020-05-11 08:33:46', '2020-07-15 11:52:14'),
(450, 'El- Menoufia', 'المنوفية', 0, 0, 0, '2020-05-11 08:36:52', '2020-07-15 11:52:11'),
(451, 'EL- Menia', 'المنيا', 0, 0, 0, '2020-05-11 08:37:24', '2020-07-15 11:52:10'),
(452, 'El- Wady Geded', 'الوادي الجديد', 0, 1, 0, '2020-05-11 08:37:57', '2022-04-05 13:45:56'),
(453, 'dwdd', 'dwdwd', 0, 1, 0, '2022-05-19 10:09:37', '2022-05-19 10:09:37');

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

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

CREATE TABLE `clients` (
  `id` int(11) NOT NULL,
  `image` varchar(225) NOT NULL,
  `name` varchar(225) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `position` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `clients` (`id`, `image`, `name`, `status`, `position`, `created_at`, `updated_at`) VALUES
(1, 'ProjectsHomeSlider_74649.webp', 'client 1', 1, 1, '2023-03-06 15:00:56', NULL),
(2, 'ProjectsHomeSlider_25131.webp', 'client 2', 1, 14, '2023-03-06 15:01:08', NULL),
(3, 'ProjectsHomeSlider_40350.webp', 'client 3', 1, 15, '2023-03-06 15:01:22', NULL),
(4, 'ProjectsHomeSlider_56448.webp', 'client 4', 1, 16, '2023-03-06 15:01:32', NULL),
(5, 'ProjectsHomeSlider_98303.webp', 'client 5', 1, 17, '2023-03-06 15:01:45', NULL),
(6, 'ProjectsHomeSlider_67615.webp', 'client  6', 1, 18, '2023-03-06 15:01:53', NULL),
(7, 'ProjectsHomeSlider_45530.webp', 'client 7', 1, 19, '2023-03-06 15:02:03', NULL),
(8, 'ProjectsHomeSlider_43789.webp', 'client 8', 1, 20, '2023-03-06 15:02:18', NULL),
(9, 'ProjectsHomeSlider_24707.webp', 'client 9', 1, 21, '2023-03-06 15:02:32', NULL),
(10, 'ProjectsHomeSlider_98600.webp', 'client 9', 1, 22, '2023-03-06 15:03:53', NULL),
(11, 'ProjectsHomeSlider_30062.webp', 'client 10', 1, 13, '2023-03-06 15:04:01', NULL),
(12, 'ProjectsHomeSlider_27453.webp', 'client 11', 1, 12, '2023-03-06 15:04:09', NULL),
(13, 'ProjectsHomeSlider_21795.webp', 'client  12', 1, 11, '2023-03-06 15:04:34', NULL),
(14, 'ProjectsHomeSlider_25992.webp', 'client  13', 1, 2, '2023-03-06 15:04:44', NULL),
(15, 'ProjectsHomeSlider_32036.webp', 'client 14', 1, 3, '2023-03-06 15:04:52', NULL),
(16, 'ProjectsHomeSlider_39878.webp', 'client 16', 1, 4, '2023-03-06 15:05:27', NULL),
(17, 'ProjectsHomeSlider_58541.webp', 'client 17', 1, 5, '2023-03-06 15:05:45', NULL),
(18, 'ProjectsHomeSlider_31432.webp', 'client 18', 1, 6, '2023-03-06 15:09:04', NULL),
(19, 'ProjectsHomeSlider_61093.webp', 'client 19', 1, 7, '2023-03-06 15:09:36', NULL),
(20, 'ProjectsHomeSlider_86914.webp', 'client 19', 1, 8, '2023-03-06 15:09:49', NULL),
(21, 'ProjectsHomeSlider_96196.webp', 'client 21', 1, 9, '2023-03-06 15:10:01', NULL),
(22, 'ProjectsHomeSlider_48999.webp', 'client 22', 1, 10, '2023-03-06 15:10:14', NULL),
(23, 'ProjectsHomeSlider_81299.webp', 'client 23', 1, 23, '2023-03-06 15:10:24', NULL),
(24, 'ProjectsHomeSlider_17918.png', 'ww', 1, NULL, '2023-03-19 17:44:40', '2023-03-19 17:44:40');

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

--
-- Table structure for table `contact_info`
--

CREATE TABLE `contact_info` (
  `id` int(11) NOT NULL,
  `image` varchar(225) NOT NULL,
  `title_en` varchar(225) NOT NULL,
  `title_ar` varchar(225) NOT NULL,
  `description_en` text NOT NULL,
  `description_ar` text NOT NULL,
  `link` varchar(225) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `position` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contact_info`
--

INSERT INTO `contact_info` (`id`, `image`, `title_en`, `title_ar`, `description_en`, `description_ar`, `link`, `status`, `position`, `created_at`, `updated_at`) VALUES
(1, 'ContactInfo_50709.svg', 'France office:', '', '(+33) (6) 77 54 90 91\r\n70 avenue La Bruyere, \r\n38100 Grenoble, Paris, \r\nFrance', '', NULL, 0, 2, '2023-03-06 19:00:31', '2023-07-04 15:25:53'),
(2, 'ContactInfo_73623.svg', 'Egypt Offical', 'Egypt Offical', '0101010101\r\ndsd sds ds d s', '0101010101\r\ndsd sds ds d s', 'https://www.google.com/maps/place/%D8%AF%D8%A7%D8%B1+%D8%A7%D9%84%D9%82%D9%88%D8%A7%D8%AA+%D8%A7%D9%84%D8%AC%D9%88%D9%8A%D8%A9+%D9%86%D8%A7%D8%AF%D9%8A+%D8%A7%D9%84%D9%86%D8%B3%D9%88%D8%B1%E2%80%AD/@30.0903541,31.3677734,18.5', 0, 1, '2023-03-06 19:00:39', '2023-07-04 15:25:52'),
(3, 'ContactInfo_39879.svg', 'Head Office :', 'UK office:', '(+20) 0567933993 - 0567570344 \r\nOffice no 7 - Building no 3534 - Al Amir Muhammad Ibn Abdul Aziz - Alsafa - Jeddah - KSA', '0044 20 7256 4046\r\nLevel 17, dashwood house, 69 old, broad St., London, UK', 's', 1, 3, '2023-03-12 18:30:27', '2023-07-04 15:27:04'),
(4, 'ContactInfo_16698.svg', '(+20)  0111 055 6603', '', '35 Obour Bulidings, \r\nSalah Salem ST., Nasr City, \r\nCairo, Egypt', '', NULL, 0, 4, '2023-03-12 18:31:05', '2023-07-04 15:25:51'),
(5, 'ContactInfo_63556.svg', 'Barcelona:', 'Barcelona:', 'GBM C/ Balmes 120, 5a1a, \r\n08008 Barcelona, Spain', 'GBM C / Balmes 120 ، 5a1a ،\r\n08008 برشلونة ، إسبانيا', NULL, 0, 5, '2023-03-12 18:31:27', '2023-07-04 15:25:51'),
(6, 'ContactInfo_26516.svg', 'Shanghai:', 'Shanghai:', 'HWCD Room 606, No. 5, \r\nLane 28, Danba Rd, \r\nShanghai, China', 'HWCD Room 606، No. 5،\r\nلين 28 ، طريق دانبا ،\r\nشنغهاي، الصين', NULL, 0, 6, '2023-03-12 18:31:51', '2023-07-04 15:25:50');

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

--
-- Table structure for table `contact_us`
--

CREATE TABLE `contact_us` (
  `id` int(11) NOT NULL,
  `name` varchar(225) NOT NULL,
  `phone` varchar(225) NOT NULL,
  `email` varchar(225) NOT NULL,
  `message` text NOT NULL,
  `is_contacted` int(11) NOT NULL DEFAULT 0,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contact_us`
--

INSERT INTO `contact_us` (`id`, `name`, `phone`, `email`, `message`, `is_contacted`, `created_at`, `updated_at`) VALUES
(2, 'Illana Mckenzie', '57', 'nijypunera@mailinator.com', 'Quisquam qui illum', 0, '2023-03-15 18:38:21', '2023-03-26 12:09:02'),
(3, 'Grant Chandler', '41', 'sale@mailinator.com', 'Exercitation tempor', 1, '2023-03-15 18:39:15', '2023-03-16 15:58:07');

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

--
-- Table structure for table `districts`
--

CREATE TABLE `districts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `city_id` bigint(20) UNSIGNED NOT NULL,
  `name_en` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_ar` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_price` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `position` int(11) 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 `districts`
--

INSERT INTO `districts` (`id`, `city_id`, `name_en`, `name_ar`, `shipping_price`, `status`, `position`, `created_at`, `updated_at`) VALUES
(1, 1, 'sharaton', 'شيرتون', 10, 1, NULL, '2020-03-11 12:01:50', '2020-03-11 12:01:50'),
(2, 1, 'el nozha', 'النزهة', 10, 1, NULL, '2020-03-11 12:02:06', '2020-03-30 08:27:01'),
(3, 1, 'Nasr City', 'مدينة نصر', 10, 1, NULL, '2020-03-30 08:27:22', '2020-03-30 08:27:22'),
(6, 1, 'Obour', 'العبور', 10, 1, NULL, '2020-04-05 18:22:17', '2020-04-16 16:43:15'),
(8, 1, 'makram ebid', 'مكرم عبيد', 10, 1, NULL, '2020-04-07 10:43:11', '2020-04-07 10:43:11'),
(9, 1, 'Heliopolis', 'مصر الجديدة ', 10, 1, NULL, '2020-04-16 16:42:40', '2020-04-16 16:42:40'),
(13, 1, 'Al waily', ' الوايلي ', 10, 1, NULL, '2020-04-16 16:45:45', '2020-09-30 10:45:27'),
(15, 1, 'AL abbasia', ' العباسية ', 10, 1, NULL, '2020-04-16 16:48:26', '2020-09-30 10:45:26'),
(16, 1, 'Mataria', 'المطرية', 10, 1, NULL, '2020-04-16 16:48:42', '2020-09-30 10:45:20'),
(17, 1, 'Helwan', 'حلوان', 10, 1, NULL, '2020-04-16 16:50:33', '2020-09-30 10:45:19'),
(18, 1, 'Al Basaten', ' البساتين ', 10, 1, NULL, '2020-04-16 16:50:34', '2020-09-30 10:45:17'),
(20, 1, 'Marg', 'المرج', 10, 1, NULL, '2020-04-16 16:51:00', '2020-11-19 10:27:41'),
(21, 1, 'Ain Shams', ' عين شمس ', 10, 1, NULL, '2020-04-16 16:57:54', '2020-09-30 10:45:13'),
(23, 1, 'Shubra', 'شبرا ', 10, 1, NULL, '2020-04-16 17:00:49', '2020-09-30 10:45:12'),
(25, 1, 'Al Sahel', ' الساحل ', 10, 1, NULL, '2020-04-16 17:02:17', '2020-09-30 10:45:11'),
(27, 1, 'Al Zaiton', ' الزيتون ', 10, 1, NULL, '2020-04-16 17:04:21', '2020-09-30 10:45:10'),
(29, 1, 'Al zawia Al Hamra', ' الزاوية الحمراء ', 10, 1, NULL, '2020-04-16 17:05:24', '2020-09-30 10:45:09'),
(31, 1, 'Al Sharabia', ' الشرابية ', 10, 1, NULL, '2020-04-16 17:06:18', '2020-09-30 10:45:08'),
(32, 1, 'Rod Al Farag', ' روض الفرج ', 10, 1, NULL, '2020-04-16 17:06:41', '2020-09-30 10:45:07'),
(33, 1, 'New Al Monira', ' المنيرة الجديدة', 10, 1, NULL, '2020-04-16 17:07:11', '2020-09-30 10:45:06'),
(34, 1, 'Al Khalifa', 'الخليفة', 10, 1, NULL, '2020-04-16 17:07:34', '2020-09-30 10:45:05'),
(35, 1, 'Al Manile', 'المنيل', 10, 1, NULL, '2020-04-16 17:07:55', '2020-09-30 10:45:05'),
(36, 1, 'AL Rowda', ' جزيرة الروضة ', 10, 1, NULL, '2020-04-16 17:08:15', '2020-09-30 10:45:05'),
(37, 1, 'Dar Al Salam ', ' دار السلام ', 10, 1, NULL, '2020-04-16 17:08:41', '2020-09-30 10:44:52'),
(38, 1, 'Al Maadi', 'المعادي ', 10, 1, NULL, '2020-04-16 17:09:05', '2020-04-16 17:09:05'),
(40, 1, 'Al tebin', ' التبين', 10, 0, NULL, '2020-04-16 17:09:46', '2020-09-11 11:12:07'),
(41, 1, 'Bab AL Shaaria', 'باب الشعرية', 10, 0, NULL, '2020-04-16 17:10:09', '2020-09-11 11:12:06'),
(42, 1, 'AL Mokatm', 'المقطم', 10, 1, NULL, '2020-04-16 17:10:34', '2020-04-16 17:10:34'),
(43, 1, 'Bolaaq', 'بولاق ', 10, 1, NULL, '2020-04-16 17:10:56', '2020-09-30 10:44:49'),
(44, 1, 'Garden City', 'جاردن سيتي', 10, 1, NULL, '2020-04-16 17:11:17', '2020-04-16 17:11:17'),
(45, 1, 'Al Zamalek', 'الزمالك', 10, 1, NULL, '2020-04-16 17:11:43', '2020-04-16 17:12:01'),
(46, 1, 'Qasr Al nile', 'قصر النيل', 10, 1, NULL, '2020-04-16 17:12:29', '2020-09-30 10:44:43'),
(47, 1, 'Al Gamalia', 'الجمالية', 10, 0, NULL, '2020-04-16 17:12:51', '2020-09-11 11:11:57'),
(48, 1, 'AL Moskey', 'الموسكي', 10, 0, NULL, '2020-04-16 17:13:10', '2020-09-11 11:11:57'),
(49, 1, 'Manshet Naser', 'منشأة ناصر', 10, 0, NULL, '2020-04-16 17:13:44', '2020-09-11 11:11:55'),
(51, 1, 'Rod Al Farag', 'روض الفرج', 10, 0, NULL, '2020-04-16 17:14:52', '2020-09-11 11:11:54'),
(52, 1, 'Al darb Al ahmer', 'الدرب الاحمر', 10, 0, NULL, '2020-04-16 17:15:22', '2020-09-11 11:11:53'),
(54, 1, 'the 5th settlement', 'التجمع الخامس', 10, 1, NULL, '2020-04-16 17:16:01', '2020-04-16 17:16:01'),
(55, 1, 'Other', 'أخري', 10, 1, NULL, '2020-04-16 17:19:19', '2020-09-11 11:10:50'),
(56, 426, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:39:05', '2020-09-11 11:10:46'),
(57, 427, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:39:38', '2020-09-11 11:10:44'),
(58, 430, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:39:51', '2020-09-11 11:10:43'),
(59, 431, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:40:06', '2020-09-11 11:10:41'),
(60, 432, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:40:20', '2020-09-11 11:10:40'),
(61, 433, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:40:31', '2020-09-11 11:10:39'),
(62, 434, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:42:15', '2020-09-11 11:10:38'),
(63, 435, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:42:24', '2020-09-11 11:10:35'),
(64, 436, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:42:37', '2020-09-11 11:10:33'),
(65, 437, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:42:50', '2020-09-11 11:10:32'),
(66, 438, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:43:03', '2020-09-11 11:10:31'),
(67, 439, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:43:42', '2020-09-11 11:10:30'),
(68, 440, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:43:52', '2020-09-11 11:10:29'),
(69, 441, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:44:03', '2020-09-11 11:10:28'),
(70, 442, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:44:12', '2020-09-11 11:10:16'),
(71, 443, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:44:30', '2020-09-11 11:10:14'),
(72, 444, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:44:42', '2020-09-11 11:10:13'),
(73, 445, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:46:28', '2020-09-11 11:10:10'),
(74, 446, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:46:39', '2020-11-19 10:29:03'),
(75, 445, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:46:42', '2020-09-11 11:10:02'),
(76, 447, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:46:57', '2020-09-11 11:10:04'),
(77, 448, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:47:11', '2020-09-11 11:10:02'),
(78, 449, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:47:26', '2020-09-11 11:10:02'),
(79, 450, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:47:35', '2020-09-11 11:09:53'),
(80, 451, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:47:47', '2020-09-11 11:09:52'),
(81, 452, 'Other', 'أخري', 10, 0, NULL, '2020-05-11 08:47:58', '2020-09-11 11:09:52'),
(82, 426, 'El Azarita', 'الأزاريطة', 10, 0, NULL, '2020-05-11 08:49:25', '2020-09-11 11:09:45'),
(95, 426, 'Stanly', 'ستانلي', 10, 0, NULL, '2020-05-11 08:55:43', '2020-09-11 11:09:36'),
(99, 428, 'Other', 'أخري', 10, 1, NULL, '2020-06-27 14:29:02', '2020-06-27 14:29:02'),
(100, 446, 'Obour', 'العبور', 10, 1, NULL, '2020-11-19 10:31:11', '2020-11-19 10:31:11');

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

--
-- Table structure for table `home_settings`
--

CREATE TABLE `home_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `inp_type` enum('text','image') COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `home_settings`
--

INSERT INTO `home_settings` (`id`, `inp_type`, `title`, `value`) VALUES
(1, 'image', 'section_1_bg_image_en', 'HomeSetting_25927.webp'),
(2, 'text', 'section_2_description_en', 'For more than 30 years IC Olus is providing excellence and ecrichment to design services and project managment consultancy in the middle East & global marketing'),
(3, 'text', 'about_shorter_description_en', 'Al‐Badeel is an established engineering and contracting firm that had been founded in 2006 by a high‐profile collective of experienced leading figures in the construction industry for more than 10 years in the Kingdom of Saudi Arabia.'),
(4, 'text', 'about_longer_description_en', 'The expertise and diversity of the firm founders have helped to create harmony and strong bonds in its management’s leadership, by adding value due to their knowledge in Saudi Arabia, for the 10 years working in high profile, multi‐million Saudi riyal projects in the kingdom. Their proficiency has also amplified by collaborating with international and great reputable Contractors of the likes of Consultants and Project Management Firms such as Saudi Bin Laden Group, Proger, Dar Al Handasa , Arup , Shaker, etc. elevates the profile of the firm to compete with the other reputable established companies in the field.'),
(5, 'text', 'Vision_en', 'In five years now will grow to better serve more regions by establishing corresponding branches that will provide services that best suits these regions through IES team.'),
(6, 'text', 'Mission_en', 'To Provide the world of construction wit consultancy solutions, and designs that are creative, cost effective and easy to implement to meet the wide range of diversified customer satisfaction.'),
(7, 'text', 'Teamwork_en', 'IES hac a unique service portfolio that puts it at the highest rank amongst engineering consultancy service companies. Not only restricted to urban & landscapem architectural, interior, structural, MEP designs, IES portfolio includes management services as well which can be clearly seen in project management and supervision management and supplay chain management.'),
(8, 'text', 'section_2_title_en', 'Power of History'),
(9, 'image', 'section_1_bg_image_ar', 'HomeSetting_25927.webp'),
(10, 'text', 'section_2_description_ar', 'لأكثر من 30 عامًا ، تقدم IC Olus التميز والإثراء لخدمات التصميم واستشارات إدارة المشاريع في الشرق الأوسط والتسويق العالمي'),
(11, 'text', 'about_shorter_description_ar', 'IES هي شركة تصميم سريعة النمو مع فريق دولي مقره في القاهرة وباريس وشنغهاي ولندن وبرشلونة. تشمل محفظتنا تصميمات سكنية وحضرية راقية.'),
(12, 'text', 'about_longer_description_ar', 'من المفهوم إلى رسومات البناء ، نؤكد على التفاصيل ودمج الثقافات المحلية\r\nفي عملية التصميم لدينا. كشركة تصميم لدينا خبرة في التخطيط الحضري والهندسة المعمارية ،\r\nمشاريع تصميم المناظر الطبيعية والداخلية وتصميم المنتجات. كل مشروع تم تنفيذه في IES له\r\nالتركيز على تطوير البحث من أجل الحصول على سياق ثقافي وبيئي راسخ الجذور.\r\nمسترشدة بتقاليد لغة التصميم الحديثة ، IES في طليعة الابتكار.'),
(13, 'text', 'Vision_ar', 'في غضون خمس سنوات ، ستنمو الآن لخدمة المزيد من المناطق بشكل أفضل من خلال إنشاء الفروع المقابلة التي ستقدم الخدمات التي تناسب هذه المناطق على أفضل وجه من خلال فريق IES.'),
(14, 'text', 'Mission_ar', 'لتوفير عالم البناء مع حلول استشارية وتصميمات مبتكرة وفعالة من حيث التكلفة وسهلة التنفيذ لتلبية مجموعة واسعة من رضا العملاء المتنوع.'),
(15, 'text', 'Teamwork_ar', 'IES لديها مجموعة خدمات فريدة من نوعها تضعها في أعلى مرتبة بين شركات خدمات الاستشارات الهندسية. لا يقتصر الأمر على التصميمات المعمارية للمناطق الحضرية والمناظر الطبيعية والداخلية والهيكلية وتصميمات الهندسة الكهربائية والميكانيكية ، بل تشمل محفظة IES خدمات الإدارة أيضًا والتي يمكن رؤيتها بوضوح في إدارة المشروع وإدارة الإشراف وإدارة سلسلة التوريد.'),
(16, 'text', 'section_2_title_ar', 'قوة التاريخ'),
(17, 'text', 'Finished_Projects', '120'),
(18, 'text', 'Happy_clients', '80'),
(19, 'text', 'industries_served', '20'),
(20, 'text', 'live_Projects', '13');

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

--
-- Table structure for table `home_sliders`
--

CREATE TABLE `home_sliders` (
  `id` int(11) NOT NULL,
  `title_en` varchar(225) NOT NULL,
  `title_ar` varchar(225) DEFAULT NULL,
  `description_en` text DEFAULT NULL,
  `description_ar` text DEFAULT NULL,
  `image` varchar(225) DEFAULT NULL,
  `link` varchar(225) DEFAULT NULL,
  `link_type` enum('normal','product_id','subCategory_id','no_link') DEFAULT NULL,
  `link_redirect_id` int(11) DEFAULT NULL,
  `position` int(11) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `home_sliders`
--

INSERT INTO `home_sliders` (`id`, `title_en`, `title_ar`, `description_en`, `description_ar`, `image`, `link`, `link_type`, `link_redirect_id`, `position`, `status`, `created_at`, `updated_at`) VALUES
(3, 'Light Cleaning', 'تنظيف خفيف', 'd', 'd', 'HomeSlider_89072.webp', NULL, NULL, NULL, 3, 1, '2023-05-30 16:16:27', NULL),
(4, 'Quo ut omnis illum', 'Quas omnis ea harum', 'Qui ut ex explicabo', 'Quaerat qui facere v', 'HomeSlider_96775.webp', NULL, NULL, NULL, 2, 1, '2023-06-25 15:42:39', NULL),
(5, 'Al Badeel For Contracting', 'Al Badeel For Contracting', 'Al‐Badeelnet is full service engineering and general contracting firm, specialized in concrete,architectural and MEP works execution . Serving clients in all areas in the workflow.', 'Al‐Badeelnet is full service engineering and general contracting firm, specialized in concrete,architectural and MEP works execution . Serving clients in all areas in the workflow.', 'HomeSlider_57775.webp', NULL, NULL, NULL, 1, 1, '2023-06-25 15:44:32', NULL);

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

--
-- Table structure for table `job_categories`
--

CREATE TABLE `job_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name_en` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_ar` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `position` int(11) 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 `job_categories`
--

INSERT INTO `job_categories` (`id`, `name_en`, `name_ar`, `status`, `position`, `created_at`, `updated_at`) VALUES
(1, 'It', 'It', 1, NULL, NULL, NULL),
(2, 'Hr', '', 1, NULL, NULL, NULL),
(3, 'project manger', 'project manger', 1, NULL, '2023-07-11 14:50:09', '2023-07-11 14:50:09');

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

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

CREATE TABLE `media` (
  `id` int(11) NOT NULL,
  `name_en` varchar(225) NOT NULL,
  `name_ar` varchar(225) NOT NULL,
  `description_en` varchar(225) NOT NULL,
  `description_ar` varchar(225) NOT NULL,
  `media_type` enum('image','video') NOT NULL,
  `image` varchar(225) DEFAULT NULL,
  `youtube` varchar(225) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `position` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `media` (`id`, `name_en`, `name_ar`, `description_en`, `description_ar`, `media_type`, `image`, `youtube`, `status`, `position`, `created_at`, `updated_at`) VALUES
(1, 'Diaverm Alrass', 'Diaverm Alrass', 'Alrass', 'Alrass', 'image', 'Media_88763.webp', NULL, 1, 1, '2023-07-06 15:23:35', '2023-07-06 15:39:42'),
(2, 'Diaverm Alrass', 'Diaverm Alrass', 'Alrass', 'Alrass', 'video', 'Media_73897.webp', 'triXo_xCqms', 1, 2, '2023-07-06 15:38:19', '2023-07-06 16:27:34'),
(3, 'Diaverm Alrass', 'Diaverm Alrass', 'Alrass', 'Alrass', 'image', 'Media_17348.webp', NULL, 1, 3, '2023-07-06 15:38:36', '2023-07-06 15:39:42'),
(4, 'Diaverm Alrass', 'Diaverm Alrass', 'Alrass', 'Alrass', 'image', 'Media_92326.webp', NULL, 1, 4, '2023-07-06 15:38:46', '2023-07-06 15:39:43'),
(5, 'Diaverm Alrass', 'Diaverm Alrass', 'Alrass', 'Alrass', 'image', 'Media_91061.webp', NULL, 1, 5, '2023-07-06 15:39:00', '2023-07-06 15:39:43'),
(6, 'Diaverm Alrass', 'Diaverm Alrass', 'Alrass', 'Alrass', 'image', 'Media_59013.webp', NULL, 1, 6, '2023-07-06 15:39:12', '2023-07-11 18:30:36'),
(7, 'Diaverm Alrass', 'Diaverm Alrass', 'Alrass', 'Alrass', 'video', 'Media_19353.webp', 'triXo_xCqms', 1, 7, '2023-07-06 15:39:21', '2023-07-06 16:29:34'),
(8, 'Diaverm Alrass', 'Diaverm Alrass', 'Alrass', 'Alrass', 'image', 'Media_68205.webp', NULL, 1, 8, '2023-07-06 15:39:27', '2023-07-06 15:39:43');

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

--
-- Table structure for table `media_gallery`
--

CREATE TABLE `media_gallery` (
  `id` int(11) NOT NULL,
  `media_id` int(11) NOT NULL,
  `image` varchar(225) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `media_gallery`
--

INSERT INTO `media_gallery` (`id`, `media_id`, `image`, `created_at`, `updated_at`) VALUES
(1, 8, 'MediaGallery_59588.png', '2023-07-12 16:53:56', '2023-07-12 16:53:56'),
(2, 8, 'MediaGallery_90020.jpg', '2023-07-12 16:56:41', '2023-07-12 16:56:41'),
(3, 8, 'MediaGallery_91605.png', '2023-07-12 16:56:45', '2023-07-12 16:56:45'),
(4, 6, 'MediaGallery_89197.png', '2023-07-12 16:56:55', '2023-07-12 16:56:55'),
(5, 6, 'MediaGallery_42184.png', '2023-07-12 16:56:59', '2023-07-12 16:56:59'),
(6, 5, 'MediaGallery_78850.png', '2023-07-12 16:57:13', '2023-07-12 16:57:13'),
(7, 5, 'MediaGallery_80547.jpg', '2023-07-12 16:57:19', '2023-07-12 16:57:19'),
(8, 5, 'MediaGallery_62330.png', '2023-07-12 16:57:19', '2023-07-12 16:57:19'),
(9, 5, 'MediaGallery_56344.jpg', '2023-07-12 16:57:19', '2023-07-12 16:57:19'),
(10, 5, 'MediaGallery_31573.png', '2023-07-12 16:57:19', '2023-07-12 16:57:19'),
(11, 1, 'MediaGallery_45856.png', '2023-07-12 18:03:11', '2023-07-12 18:03:11'),
(12, 1, 'MediaGallery_58312.png', '2023-07-12 18:03:11', '2023-07-12 18:03:11'),
(14, 1, 'MediaGallery_22023.png', '2023-07-12 18:03:11', '2023-07-12 18:03:11'),
(15, 1, 'MediaGallery_42359.webp', '2023-07-12 18:03:11', '2023-07-12 18:03:11');

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

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` int(11) NOT NULL,
  `title_en` varchar(225) NOT NULL,
  `title_ar` varchar(225) NOT NULL,
  `publish_data` date NOT NULL,
  `sub_content_en` varchar(225) NOT NULL,
  `sub_content_ar` varchar(225) NOT NULL,
  `content_en` text NOT NULL,
  `content_ar` text NOT NULL,
  `image` varchar(225) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `position` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `title_en`, `title_ar`, `publish_data`, `sub_content_en`, `sub_content_ar`, `content_en`, `content_ar`, `image`, `status`, `position`, `created_at`, `updated_at`) VALUES
(12, 'To Provide the world of construction wit consultancy', 'لتوفير عالم البناء مع الاستشارات', '2023-02-21', 'To Provide the world of construction wit consultancy solutions, and designs that are creative, cost effective and easy to implement to meet the wide range of diversified customer satisfaction.', 'لتوفير عالم البناء مع حلول استشارية وتصميمات مبتكرة وفعالة من حيث التكلفة وسهلة التنفيذ لتلبية مجموعة واسعة من رضا العملاء المتنوع.', '<p><span style=\"color: rgb(0, 0, 0);\">Vivamus vestibulum sem et</span><strong style=\"color: rgb(0, 0, 0);\"> justo convallis</strong><span style=\"color: rgb(0, 0, 0);\"> hendrerit. </span><em style=\"color: rgb(0, 0, 0);\">In sagittis rutrum</em><span style=\"color: rgb(0, 0, 0);\"> metus quis suscipit. Nulla odio ante, tristique eget facilisis eget, semper id leo. Vestibulum ut lectus hendrerit, facilisis nulla ac, tempor ligula. Sed luctus, dolor quis imperdiet suscipit, magna felis imperdiet ligula, ut dignissim tellus eros vitae magna. Nullam in tincidunt nisl. Fusce eget eros lacus. Maecenas sit amet ante sed justo egestas interdum. Vestibulum fermentum sapien vitae lorem suscipit, aliquam lacinia elit egestas. In eu metus ultrices, accumsan neque in, tristique lectus. Phasellus diam est, lacinia eget feugiat sit amet, gravida a velit. Morbi laoreet varius rutrum. Vestibulum facilisis egestas varius. Mauris tristique, arcu vitae consectetur ullamcorper, ex velit elementum sem, id euismod dolor arcu et sapien. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Vestibulum varius, elit in sollicitudin vestibulum, turpis odio sollicitudin urna, tempus semper nunc ipsum in eros.</span></p><p><img src=\"http://127.0.0.1:8000/images/Blogs/content/Blog_image_94272.webp\"></p><p><span style=\"color: rgb(0, 0, 0);\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span></p><p><br></p><h1>Good Design accelerates the adoption</h1><p><span style=\"color: rgb(0, 0, 0);\">Aliquam tortor erat, sollicitudin et blandit at, scelerisque vel magna. Donec tempor quam tortor. Suspendisse potenti. Curabitur felis ante, eleifend a tincidunt at, hendrerit et sem. Nam congue venenatis vestibulum. Nam arcu mauris, efficitur sit amet lectus sed, imperdiet tristique elit. Fusce fermentum in risus eu ornare. Aliquam pulvinar vestibulum mi sit amet suscipit. Nam elementum massa porttitor placerat sodales.</span></p><p><img src=\"http://127.0.0.1:8000/images/Blogs/content/Blog_image_35612.webp\"></p><p><span style=\"color: rgb(0, 0, 0);\">Aliquam condimentum, neque in faucibus tincidunt, neque libero ultricies urna, nec fringilla nisi odio at eros. Aliquam erat volutpat. Phasellus dictum ex in faucibus hendrerit. Suspendisse egestas ac lectus sit amet finibus. Phasellus sit amet augue facilisis, mattis tortor sit amet, semper tellus. Morbi hendrerit tincidunt laoreet. Sed non consectetur neque, at volutpat elit. Aenean non quam libero. Praesent tortor urna, venenatis rutrum interdum et, malesuada in urna. Aenean turpis justo, mollis in nulla vel, cursus consequat lacus.</span></p><p><span style=\"color: rgb(0, 0, 0);\">some links </span></p><p><a href=\"https://www.google.com\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(0, 0, 0);\">link to google</a><span style=\"color: rgb(0, 0, 0);\"> , </span><a href=\"https://bsocial-eg.com\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(0, 0, 0);\">link to bsocial</a></p><p><span style=\"color: rgb(0, 0, 0);\"><span class=\"ql-cursor\">﻿﻿﻿﻿</span>The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero</span></p>', '<p>الدهليز Vivamus sem et justo convallis hendrerit. في القوس rutrum metus quis suscipit. Nulla odio ante ، tristique eget Facilisis eget ، semper id leo. الدهليز الخاص بهندريت ، التسهيلات الخالية من التيار المتردد ، الليجولا الصدغي. Sed luctus، dolor quis imperdiet suscipit، magna felis imperdiet ligula، utensim tellus eros vitae magna. Nullam في tincidunt nisl. فوس إيجيت إيروس لاكوس. Maecenas الجلوس amet قبل justo egestas interdum. الدهليز الخميرة السيرة الذاتية لوريم ساسيبيت ، لاسينيا أليكوام إليت إيجستاس. في eu metus ultrices، accumsan neque in، tristique lectus. Phasellus Diam est، lacinia eget feugiat sit amet، gravida a velit. موربي لوريت فاريوس روتروم. الدهليز facilisis egestas varius. Mauris tristique، arcu vitae consectetur ullamcorper، ex velit elementum sem، id euismod dolor arcu et sapien. Orci varius natoque penatibus et magnis dis parturient montes، nascetur ridiculus mus. الدهليز varius، elit in sollicitudin vestibulum، turpis odio sollicitudin urna، tempus semper nunc ipsum in eros.</p><p><br></p><p><br></p><p><br></p><p>هناك العديد من الأشكال المتاحة لنصوص لوريم إيبسوم ، لكن الغالبية تعرضت للتغيير بشكل ما ، عن طريق إدخال بعض الفكاهة أو الكلمات العشوائية التي لا تبدو قابلة للتصديق إلى حد ما. إذا كنت ستستخدم مقطعًا من لوريم إيبسوم ، فعليك التأكد من عدم وجود أي شيء محرج مخفي في منتصف النص. تميل جميع مولدات Lorem Ipsum على الإنترنت إلى تكرار الأجزاء المحددة مسبقًا حسب الضرورة ، مما يجعلها أول مولد حقيقي على الإنترنت. يستخدم قاموسًا يضم أكثر من 200 كلمة لاتينية ، جنبًا إلى جنب مع حفنة من تراكيب الجملة النموذجية ، لتوليد Lorem Ipsum الذي يبدو معقولًا. لذلك فإن لوريم إيبسوم الذي تم إنشاؤه يكون دائمًا خاليًا من التكرار أو الدعابة المحقونة أو الكلمات غير المميزة وما إلى ذلك.</p><p><br></p><p><br></p><p><br></p><p>التصميم الجيد يسرع التبني</p><p>Aliquam tortor erat، sollicitudin et blandit at، scelerisque vel magna. دونك مؤقت quam عذاب. تعليق قوة. Curabitur felis ante، eleifend a tincidunt at، hendrerit et sem. نام كونيج دهليز فينيناتيس. Nam arcu mauris، efficitur sit amet lectus sed، imperdiet tristique elit. خميرة فيوسيس في ريسوس يو أورناري. الدهليز Aliquam pulvinar mi sit amet suscipit. نام elementum ماسا porttitor placerat sodales.</p><p><br></p><p><br></p><p><br></p><p>Aliquam condimentum ، neque in faucibus tincidunt ، neque libero ultricies urna ، nec fringilla nisi odio at eros. Aliquam إيرات فولوتبات. Phasellus القول المأثور في faucibus hendrerit. تعليق egestas ac lectus الجلوس amet finibus. Phasellus sit amet augue facilisis، mattis tortor sit amet، semper tellus. موربي هندريريت تينكيدونت لوريت. Sed non consectetur neque ، في volutpat elit. Aenean non quam Libero. تقديم عذاب الجرة ، venenatis rutrum interdum وآخرون ، malesuada في الجرة. Aenean Turpis justo ، mollis in nulla vel ، cursus dueat lacus.</p><p><br></p><p>بعض الروابط</p><p><br></p><p>رابط جوجل ، رابط إلى bsocial</p><p><br></p><p>الجزء القياسي من لوريم إيبسوم المستخدم منذ القرن الخامس عشر مستنسخ أدناه للمهتمين. القسمان 1.10.32 و 1.10.33 من \"de Finibus Bonorum et Malorum\" بواسطة Cicero</p>', 'News_41772.webp', 1, 3, '2023-02-19 15:02:20', '2023-05-28 18:42:37'),
(13, 'To Provide the world of construction wit consultancy', '', '1976-12-03', 'To Provide the world of construction wit consultancy solutions, and designs that are creative, cost effective and easy to implement to meet the wide range of diversified customer satisfaction.', '', 'Repudiandae corrupti', '', 'News_56827.webp', 1, 2, '2023-03-22 13:20:14', '2023-03-22 15:02:24'),
(14, 'To Provide the world of construction wit consultancy', 'لتوفير عالم البناء مع الاستشارات', '2023-03-23', 'To Provide the world of construction wit consultancy solutions, and designs that are creative, cost effective and easy to implement to meet the wide range of diversified customer satisfaction.', 'لتوفير عالم البناء مع حلول استشارية وتصميمات مبتكرة وفعالة من حيث التكلفة وسهلة التنفيذ لتلبية مجموعة واسعة من رضا العملاء المتنوع.', '<p>wdwd</p>', '<p>لتوفير عالم البناء مع حلول استشارية وتصميمات مبتكرة وفعالة من حيث التكلفة وسهلة التنفيذ لتلبية مجموعة واسعة من رضا العملاء المتنوع.</p>', 'News_67962.webp', 1, 1, '2023-03-22 14:57:53', '2023-07-11 15:35:28');

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

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

CREATE TABLE `projects` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `in_home` tinyint(4) NOT NULL DEFAULT 0,
  `title_en` varchar(225) NOT NULL,
  `title_ar` varchar(225) NOT NULL,
  `country_en` varchar(225) NOT NULL,
  `country_ar` varchar(225) NOT NULL,
  `client_en` varchar(225) DEFAULT NULL,
  `client_ar` varchar(225) DEFAULT NULL,
  `date_en` varchar(225) NOT NULL,
  `date_ar` varchar(225) NOT NULL,
  `description_en` text NOT NULL,
  `description_ar` varchar(225) NOT NULL,
  `image` varchar(225) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `position` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `projects` (`id`, `category_id`, `in_home`, `title_en`, `title_ar`, `country_en`, `country_ar`, `client_en`, `client_ar`, `date_en`, `date_ar`, `description_en`, `description_ar`, `image`, `status`, `position`, `created_at`, `updated_at`) VALUES
(1, 1, 0, 'Aut dolore voluptate', 'Facilis enim et haru', 'Sed ut vel eligendi', 'Quis qui et sunt at', 'Qui non accusantium', 'Natus nobis aut elig', '04-Apr-1982', '14-Aug-1992', 'Duis dolorem modi co', 'Voluptas corrupti o', 'Project_45518.png', 1, 2, '2023-03-06 19:42:13', '2023-06-26 14:13:29'),
(2, 1, 0, 'Quo quasi deleniti e', 'Ad Nam obcaecati vol', 'Ex labore optio rei', 'Sunt perspiciatis p', 'Laborum Corporis ex', 'Quasi non quas verit', '05-Sep-1997', '21-Oct-2021', 'Qui eu sed fugiat re', 'Aut quo molestias in', 'Project_54567.png', 1, 15, '2023-03-13 16:45:28', '2023-06-26 14:13:04'),
(3, 1, 0, 'Nostrum culpa ut rat', 'Eum est proident do', 'Laborum Veniam vel', 'Reprehenderit unde', 'Et ab nostrum conseq', 'Quia odio ut alias l', '19-Dec-2005', '30-Dec-2007', 'Fuga Accusantium ex', 'Accusantium pariatur', 'Project_88087.png', 1, 14, '2023-03-13 16:46:29', '2023-06-26 14:12:54'),
(4, 1, 0, 'Ullam magna neque no', 'Ea eos error anim v', 'Consequatur fuga V', 'Et dolorem pariatur', 'Eum sit architecto r', 'Quo laudantium id a', '09-Jul-1987', '29-Nov-2002', 'Est rerum cupiditat', 'Temporibus deserunt', 'Project_69062.png', 1, 13, '2023-03-13 17:04:05', '2023-06-26 14:12:46'),
(5, 1, 0, 'Accusantium ullam ve', 'Quis quisquam velit', 'Facere sint minima', 'Amet eum amet pari', 'Dolor amet vel sed', 'Et magnam dolore non', '03-Jun-1978', '20-Jun-1973', 'Nihil incididunt ips', 'Neque explicabo Qui', 'Project_58462.png', 1, 12, '2023-03-13 17:04:21', '2023-06-26 14:12:26'),
(6, 1, 0, 'Aut eius ipsa debit', 'Velit id cupiditate', 'Porro magnam volupta', 'Et animi labore sit', 'Nihil facilis sapien', 'Inventore nemo et et', '19-Nov-1992', '23-Nov-1986', 'Velit totam nisi na', 'Ullam aliqua Volupt', 'Project_17299.png', 1, 11, '2023-03-13 17:04:35', '2023-06-26 14:12:19'),
(7, 1, 0, 'Voluptatem dolore ad', 'Possimus officia es', 'Reprehenderit bland', 'Lorem labore exercit', 'Dignissimos in et en', 'Quo sint velit dolor', '15-May-1997', '27-May-1980', 'Voluptate anim moles', 'Sunt vel aliquip fac', 'Project_71116.png', 1, 10, '2023-03-13 17:04:45', '2023-06-26 14:11:09'),
(8, 1, 0, 'Et tempora et id adi', 'Laboris at harum cul', 'Incididunt ratione a', 'Commodo porro dolore', 'Ut quidem neque eu s', 'Tenetur officiis rep', '07-Mar-2015', '15-Oct-2022', 'Quos incididunt eum', 'Molestias debitis ad', 'Project_74895.png', 1, 9, '2023-03-13 17:04:56', '2023-06-26 14:10:59'),
(9, 1, 1, 'Enim deserunt qui qu', 'Rem incidunt ex sin', 'Error sed anim vero', 'Ipsa voluptatem Al', 'Unde et fugit aliqu', 'Rerum sed sapiente v', '14-Sep-2015', '24-Nov-2010', 'Eos aut distinctio', 'Iusto amet sed nesc', 'Project_12271.png', 1, 8, '2023-03-13 17:05:18', '2023-06-26 17:35:52'),
(10, 1, 1, 'Explicabo Quis ulla', 'Occaecat mollitia ma', 'Dolor exercitation a', 'Non consequuntur ut', 'Occaecat sint totam', 'Vel placeat porro s', '22-Jul-2014', '26-Jun-1998', 'Ut esse laudantium', 'Nulla ea deleniti qu', 'Project_61115.png', 1, 7, '2023-03-13 17:05:31', '2023-06-26 17:35:49'),
(11, 1, 1, 'Dolores sunt quis mo', 'Natus ipsam dolore p', 'Quis cumque itaque a', 'Praesentium nostrum', 'Illum ipsa fugit', 'Molestias ut autem a', '21-Nov-2015', '02-May-2001', 'Alias in obcaecati l', 'Ex animi ullam est', 'Project_20794.png', 1, 6, '2023-03-13 17:05:45', '2023-06-26 17:35:48'),
(12, 1, 1, 'Rerum quis quo quo d', 'Quidem aliquip est o', 'Similique quae fugia', 'Saepe deleniti in pr', 'Optio occaecat nequ', 'Sapiente quaerat vol', '20-Oct-1971', '11-Dec-1996', 'Enim numquam corrupt', 'Voluptate repudianda', 'Project_65454.png', 1, 5, '2023-03-13 17:05:55', '2023-06-26 17:35:47'),
(13, 1, 1, 'Ipsum consequatur d', 'Facere sunt sunt in', 'Et nisi rerum dolore', 'Ut quo fugiat fuga', 'Necessitatibus est n', 'Illum proident nat', '01-Sep-1990', '29-Aug-1998', 'Nam eos non impedit', 'Alias magna suscipit', 'Project_43578.png', 1, 4, '2023-03-13 17:06:03', '2023-06-26 17:34:45'),
(14, 1, 1, 'Dolor sint sed conse', 'Ut dolor quod fuga', 'Quis eiusmod pariatu', 'Saepe ut provident', 'Iste est iste ex se', 'Incididunt accusamus', '06-Mar-2000', '28-Sep-1993', 'Doloribus quaerat nu', 'Harum consequatur e', 'Project_40131.png', 1, 3, '2023-03-13 17:06:13', '2023-06-26 17:34:39'),
(15, 1, 1, 'EL Kobesy Villa', 'EL Kobesy Villa', 'Egypt', 'Egypt', 'Private developer', 'Private developer', '2010', '2010', 'To Provide the world of construction wit consultancy solutions, and designs that are creative, cost effective and easy to implement to meet the wide range of diversified customer satisfaction. To Provide the world of construction wit consultancy solutions, and designs that are creative, cost effective and easy to implement to meet the wide range of diversified customer satisfaction.', 'To Provide the world of construction wit consultancy solutions, and designs that are creative, cost effective and easy to implement to meet the wide range of diversified customer satisfaction. To Provide the world of construc', 'Project_76468.png', 1, 1, '2023-03-13 18:37:41', '2023-06-26 17:35:46');

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

--
-- Table structure for table `projects_home_slider`
--

CREATE TABLE `projects_home_slider` (
  `id` int(11) NOT NULL,
  `image` varchar(225) NOT NULL,
  `name` varchar(225) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `position` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `projects_home_slider`
--

INSERT INTO `projects_home_slider` (`id`, `image`, `name`, `status`, `position`, `created_at`, `updated_at`) VALUES
(1, 'ProjectsHomeSlider_27260.webp', 'img 1', 1, 2, '2023-03-06 14:41:18', NULL),
(2, 'ProjectsHomeSlider_93926.webp', 'img 2', 1, 1, '2023-03-06 14:45:57', NULL),
(3, 'ProjectsHomeSlider_30596.webp', 'img 3', 1, 3, '2023-03-06 14:46:10', NULL);

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

--
-- Table structure for table `project_gallery`
--

CREATE TABLE `project_gallery` (
  `id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `image` varchar(225) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `project_gallery`
--

INSERT INTO `project_gallery` (`id`, `project_id`, `image`, `created_at`, `updated_at`) VALUES
(1, 16, 'project_gallery_75021.png', '2023-04-17 14:02:42', '2023-04-17 14:02:42'),
(2, 16, 'project_gallery_16803.png', '2023-04-17 14:02:42', '2023-04-17 14:02:42'),
(3, 16, 'project_gallery_35705.png', '2023-04-17 14:02:51', '2023-04-17 14:02:51'),
(6, 15, 'project_gallery_21521.png', '2023-04-17 14:40:05', '2023-04-17 14:40:05'),
(7, 15, 'project_gallery_96777.png', '2023-04-17 14:40:05', '2023-04-17 14:40:05'),
(8, 15, 'project_gallery_44762.png', '2023-04-17 14:40:05', '2023-04-17 14:40:05'),
(9, 15, 'project_gallery_67943.png', '2023-04-17 14:40:05', '2023-04-17 14:40:05'),
(10, 15, 'project_gallery_64584.png', '2023-04-17 14:40:05', '2023-04-17 14:40:05'),
(11, 15, 'project_gallery_89206.png', '2023-04-17 14:40:05', '2023-04-17 14:40:05'),
(12, 17, 'project_gallery_48232.png', '2023-05-31 17:51:58', '2023-05-31 17:51:58'),
(13, 17, 'project_gallery_60145.png', '2023-05-31 17:52:13', '2023-05-31 17:52:13'),
(14, 18, 'project_gallery_80840.png', '2023-05-31 17:55:35', '2023-05-31 17:55:35'),
(15, 18, 'project_gallery_91575.png', '2023-05-31 17:55:54', '2023-05-31 17:55:54'),
(16, 19, 'project_gallery_40712.png', '2023-05-31 17:57:14', '2023-05-31 17:57:14');

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

--
-- Table structure for table `seo_keywords`
--

CREATE TABLE `seo_keywords` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `seo_keywords`
--

INSERT INTO `seo_keywords` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(3, 'res', 1, '2023-03-23 08:50:32', '2023-03-23 08:50:41');

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

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

CREATE TABLE `services` (
  `id` int(11) NOT NULL,
  `image` varchar(225) NOT NULL,
  `icon` varchar(225) NOT NULL,
  `name_en` varchar(225) NOT NULL,
  `name_ar` varchar(225) NOT NULL,
  `description_en` text NOT NULL,
  `description_ar` text NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `position` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `services` (`id`, `image`, `icon`, `name_en`, `name_ar`, `description_en`, `description_ar`, `status`, `position`, `created_at`, `updated_at`) VALUES
(1, 'Service_54712.webp', 'ServiceIcon_84784.svg', 'Animation & Maket', 'الرسوم المتحركة وماكيت', 'To Provide the world of construction wit consultancy solutions, and designs that are creative, cost effective and easy to implement to meet the wide range of diversified customer satisfaction.', 'لتوفير عالم البناء مع حلول استشارية وتصميمات مبتكرة وفعالة من حيث التكلفة وسهلة التنفيذ لتلبية مجموعة واسعة من رضا العملاء المتنوع.', 0, 6, '2023-03-12 15:07:17', '2023-05-28 15:21:28'),
(2, 'Service_62365.webp', 'ServiceIcon_91600.svg', 'MEP', 'الهندسة الكهربائية والميكانيكية', 'To Provide the world of construction wit consultancy solutions, and designs that are creative, cost effective and easy to implement to meet the wide range of diversified customer satisfaction.', 'لتوفير عالم البناء مع حلول استشارية وتصميمات مبتكرة وفعالة من حيث التكلفة وسهلة التنفيذ لتلبية مجموعة واسعة من رضا العملاء المتنوع.', 0, 5, '2023-03-12 15:11:05', '2023-05-28 15:21:13'),
(3, 'Service_52988.webp', 'ServiceIcon_34323.svg', 'Structure', 'بناء', 'To Provide the world of construction wit consultancy solutions, and designs that are creative, cost effective and easy to implement to meet the wide range', 'لتوفير عالم البناء مع حلول استشارية وتصميمات مبتكرة وفعالة من حيث التكلفة وسهلة التنفيذ لتلبية النطاق الواسع', 0, 4, '2023-03-12 15:17:57', '2023-05-28 15:20:52'),
(4, 'Service_28269.webp', 'ServiceIcon_24154.webp', 'Maintenance', 'الداخلية', 'To Provide the world of construction wit consultancy solutions, and designs that are creative, cost effective and easy to implement to meet the wide range of diversified customer satisfaction.', 'لتوفير عالم البناء مع حلول استشارية وتصميمات مبتكرة وفعالة من حيث التكلفة وسهلة التنفيذ لتلبية مجموعة واسعة من رضا العملاء المتنوع.', 1, 3, '2023-03-12 15:18:23', '2023-07-04 13:23:58'),
(5, 'Service_47860.webp', 'ServiceIcon_48600.webp', 'Furnishing', 'إدارة', 'To Provide the world of construction wit consultancy solutions, and designs that are creative, cost effective and easy to implement to meet the wide range of diversified customer satisfaction.', 'لتوفير عالم البناء مع حلول استشارية وتصميمات مبتكرة وفعالة من حيث التكلفة وسهلة التنفيذ لتلبية مجموعة واسعة من رضا العملاء المتنوع.', 1, 7, '2023-03-12 15:18:38', '2023-07-04 13:23:48'),
(7, 'Service_66798.webp', 'ServiceIcon_51435.webp', 'Renovation', 'بنيان', 'To Provide the world of construction wit consultancy solutions, and designs that are creative, cost effective and easy to implement to meet the wide range of diversified customer satisfaction.', 'لتوفير عالم البناء مع حلول استشارية وتصميمات مبتكرة وفعالة من حيث التكلفة وسهلة التنفيذ لتلبية مجموعة واسعة من رضا العملاء المتنوع.', 1, 2, '2023-03-21 12:26:25', '2023-07-04 13:23:36'),
(9, 'Service_85363.webp', 'ServiceIcon_52685.webp', 'Healthcare', 'ليد والعمارة الخضراء', 'To Provide the world of construction wit consultancy solutions, and designs that are creative, cost effective and easy to implement to meet the wide range of diversified customer satisfaction.', 'لتوفير عالم البناء مع حلول استشارية وتصميمات مبتكرة وفعالة من حيث التكلفة وسهلة التنفيذ لتلبية مجموعة واسعة من رضا العملاء المتنوع.', 1, 8, '2023-03-21 12:40:40', '2023-07-04 13:23:27'),
(10, 'Service_43892.webp', 'ServiceIcon_76156.webp', 'Construction', 'المشهد الحضري', 'To Provide the world of construction wit consultancy solutions, and designs that are creative, cost effective and easy to implement to meet the wide range of diversified customer satisfaction.', 'لتوفير عالم البناء مع حلول استشارية وتصميمات مبتكرة وفعالة من حيث التكلفة وسهلة التنفيذ لتلبية مجموعة واسعة من رضا العملاء المتنوع.', 1, 1, '2023-03-21 12:42:18', '2023-07-04 13:23:16');

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

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

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `inp_type` enum('text','image') COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `settings` (`id`, `inp_type`, `title`, `value`) VALUES
(1, 'text', 'facebook_link', 'https://www.facebook.com/1'),
(2, 'text', 'linkedin_link', 'https://www.linkedin.com/'),
(3, 'text', 'youtube_link', 'https://www.youtube.com/'),
(4, 'image', 'Services_page_banner_en', '72518.webp'),
(5, 'image', 'Projects_page_banner_en', '82907.webp'),
(6, 'image', 'News_page_banner_en', '76693.webp'),
(7, 'image', 'Services_page_banner_ar', '80535.webp'),
(8, 'image', 'Projects_page_banner_ar', '45636.webp'),
(9, 'image', 'News_page_banner_ar', '76693.webp'),
(10, 'text', 'home_subTitle_PROJECTS_en', 'More than 350 projects'),
(11, 'text', 'home_subTitle_Services_en', 'Meet Ies'),
(12, 'text', 'home_subTitle_CLIENTS_en', '250+ SATISFIED CLIENTS GLOBALLY'),
(13, 'text', 'home_subTitle_CONTACTUS_en', 'Power of expansion'),
(14, 'text', 'home_subTitle_PROJECTS_ar', 'More than 350 projects'),
(15, 'text', 'home_subTitle_Services_ar', 'Meet Ies'),
(16, 'text', 'home_subTitle_CLIENTS_ar', '250+ SATISFIED CLIENTS GLOBALLY'),
(17, 'text', 'home_subTitle_CONTACTUS_ar', 'Power of expansion'),
(18, 'image', 'Contact_page_banner_en', '97322.webp'),
(19, 'image', 'Contact_page_banner_ar', '67366.webp'),
(20, 'image', 'Clients_page_banner_en', '96732.webp'),
(21, 'image', 'Clients_page_banner_ar', '95835.webp'),
(22, 'image', 'media_page_banner_en', '66288.webp'),
(23, 'image', 'media_page_banner_ar', '41676.webp'),
(24, 'image', 'careers_page_banner_en', '23742.webp'),
(25, 'image', 'careers_page_banner_ar', '92957.webp'),
(26, 'image', 'careers_image', '92673.webp');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `about_page`
--
ALTER TABLE `about_page`
  ADD PRIMARY KEY (`id`) USING BTREE;

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

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

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

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

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

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

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

--
-- Indexes for table `districts`
--
ALTER TABLE `districts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `districts_city_id_index` (`city_id`);

--
-- Indexes for table `home_settings`
--
ALTER TABLE `home_settings`
  ADD PRIMARY KEY (`id`) USING BTREE;

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

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

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

--
-- Indexes for table `media_gallery`
--
ALTER TABLE `media_gallery`
  ADD PRIMARY KEY (`id`),
  ADD KEY `media_id` (`media_id`);

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

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

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

--
-- Indexes for table `project_gallery`
--
ALTER TABLE `project_gallery`
  ADD PRIMARY KEY (`id`),
  ADD KEY `project_id` (`project_id`);

--
-- Indexes for table `seo_keywords`
--
ALTER TABLE `seo_keywords`
  ADD PRIMARY KEY (`id`) USING BTREE;

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `board_of_directors`
--
ALTER TABLE `board_of_directors`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `careers`
--
ALTER TABLE `careers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `categories_of_projects`
--
ALTER TABLE `categories_of_projects`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

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

--
-- AUTO_INCREMENT for table `clients`
--
ALTER TABLE `clients`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `contact_info`
--
ALTER TABLE `contact_info`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `contact_us`
--
ALTER TABLE `contact_us`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

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

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

--
-- AUTO_INCREMENT for table `home_sliders`
--
ALTER TABLE `home_sliders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

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

--
-- AUTO_INCREMENT for table `media`
--
ALTER TABLE `media`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `media_gallery`
--
ALTER TABLE `media_gallery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `projects`
--
ALTER TABLE `projects`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `projects_home_slider`
--
ALTER TABLE `projects_home_slider`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `project_gallery`
--
ALTER TABLE `project_gallery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `media_gallery`
--
ALTER TABLE `media_gallery`
  ADD CONSTRAINT `media_gallery_ibfk_1` FOREIGN KEY (`media_id`) REFERENCES `media` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `projects`
--
ALTER TABLE `projects`
  ADD CONSTRAINT `projects_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories_of_projects` (`id`) ON UPDATE CASCADE;
COMMIT;

