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

START TRANSACTION;



--
-- Database: `abouHagar`
--

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

--
-- Table structure for table `about`
--

CREATE TABLE IF NOT EXISTS `about` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `image_id` int(10) UNSIGNED DEFAULT NULL,
  `mission_image_id` int(10) UNSIGNED DEFAULT NULL,
  `vision_image_id` int(10) UNSIGNED DEFAULT NULL,
  `values_image_id` int(10) UNSIGNED DEFAULT NULL,
  `approach_image_id` int(10) UNSIGNED DEFAULT NULL,
  `video_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `about_image_id` (`image_id`),
  KEY `mission_image_id` (`mission_image_id`),
  KEY `vision_image_id` (`vision_image_id`),
  KEY `values_image_id` (`values_image_id`),
  KEY `approach_image_id` (`approach_image_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `about`
--

INSERT INTO `about` (`id`, `image_id`, `mission_image_id`, `vision_image_id`, `values_image_id`, `approach_image_id`, `video_url`, `created_at`, `updated_at`) VALUES
(1, 530, 390, 391, 557, 239, 'https://www.youtube.com/embed/_Y6Ttq2l6zM', '2019-08-19 22:00:00', '2019-10-15 09:21:55');

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

--
-- Table structure for table `album`
--

CREATE TABLE IF NOT EXISTS `album` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `type` varchar(191) DEFAULT NULL,
  `image_id` int(10) UNSIGNED DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `album_created_by_user` (`created_by`),
  KEY `album_image_id` (`image_id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `album`
--

INSERT INTO `album` (`id`, `type`, `image_id`, `created_by`, `created_at`, `updated_at`) VALUES
(19, '1', 531, 3, '2019-10-13 08:13:11', '2019-10-13 08:13:11'),
(20, '1', 540, 3, '2019-10-13 12:11:28', '2019-10-13 12:11:28'),
(21, '1', 547, 3, '2019-10-13 13:33:47', '2019-10-13 13:33:47');

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

--
-- Table structure for table `appointment`
--

CREATE TABLE IF NOT EXISTS `appointment` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `birth_date` date DEFAULT NULL,
  `service_id` int(10) NOT NULL,
  `gender` int(10) NOT NULL,
  `file_id` int(10) UNSIGNED DEFAULT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `appointment_service_id` (`service_id`),
  KEY `appointment_file_id` (`file_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `blog`
--

CREATE TABLE IF NOT EXISTS `blog` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `is_information` tinyint(1) DEFAULT NULL,
  `image_id` int(10) UNSIGNED DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `open_graph_id` int(10) DEFAULT NULL,
  `page_id` int(10) DEFAULT NULL,
  `created_by` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `image_id` (`image_id`),
  KEY `blog_created_by` (`created_by`),
  KEY `blog_page_id` (`page_id`),
  KEY `blog_open_graph_id` (`open_graph_id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blog`
--

INSERT INTO `blog` (`id`, `is_information`, `image_id`, `url`, `open_graph_id`, `page_id`, `created_by`, `created_at`, `updated_at`) VALUES
(2, NULL, 440, 'effect-of-sleeve-gastrectomy-on-esophageal-reflux', 118, 117, 3, '2019-08-21 11:43:21', '2019-09-25 07:12:05'),
(3, NULL, 441, 'effect-of-laparoscopic-sleeve-gastrectomy-on-clinical-hypothyroidism', 119, 118, 3, '2019-08-30 05:47:09', '2019-09-25 07:09:32'),
(4, NULL, 442, 'safety-and-efficacy-of-laparoscopic-sleeve-gastrectomy-on-class-1-obesity', 121, 120, 3, '2019-08-30 05:53:48', '2019-09-25 07:19:57'),
(14, 1, 521, 'Obesity Surgery', 129, 129, 3, '2019-10-03 10:48:22', '2019-10-03 10:48:22'),
(15, 1, 553, 'xuxubil@mailinator.com', 132, 132, 3, '2019-10-14 10:08:15', '2019-10-14 10:08:15'),
(16, NULL, 554, 'naqib@mailinator.com', 133, 133, 3, '2019-10-14 10:19:32', '2019-10-14 10:19:32'),
(17, 1, 555, 'pyfiqedy@mailinator.net', 134, 134, 3, '2019-10-14 10:25:31', '2019-10-14 10:25:31');

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

--
-- Table structure for table `branch`
--

CREATE TABLE IF NOT EXISTS `branch` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_alt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` text COLLATE utf8mb4_unicode_ci,
  `created_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `branch`
--

INSERT INTO `branch` (`id`, `phone`, `phone_alt`, `location`, `created_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, '01111111111', NULL, 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3451.9881371883316!2d31.327343815116194!3d30.094526081864093!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x1458158b1e7c5a65%3A0x6444fef7b88e7a8c!2z2LnZitin2K_ZhyDYp9ivINmF2K3ZhdivINmF2K3ZhdmI2K8g2KfYqNmI2LLZitivINmE2KzYsdin2K3Yp9iqINin2YTYs9mF2YbZhyDZiCDYqtmD2YXZitmFINin2YTZhdi52K_YqSAtIFBlcmZlY3QgSGVhbHRoIENsaW5pY3M!5e0!3m2!1sen!2seg!4v1568106265915!5m2!1sen!2seg', 3, '2019-09-24 10:45:20', '2019-10-14 09:13:31', NULL),
(2, '01244668810', NULL, 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3451.9881371883316!2d31.327343815116194!3d30.094526081864093!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x1458158b1e7c5a65%3A0x6444fef7b88e7a8c!2z2LnZitin2K_ZhyDYp9ivINmF2K3ZhdivINmF2K3ZhdmI2K8g2KfYqNmI2LLZitivINmE2KzYsdin2K3Yp9iqINin2YTYs9mF2YbZhyDZiCDYqtmD2YXZitmFINin2YTZhdi52K_YqSAtIFBlcmZlY3QgSGVhbHRoIENsaW5pY3M!5e0!3m2!1sen!2seg!4v1568106265915!5m2!1sen!2seg', 3, '2019-09-24 22:29:33', '2019-10-14 09:13:22', NULL),
(3, '01234567891', NULL, 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3451.9881371883316!2d31.327343815116194!3d30.094526081864093!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x1458158b1e7c5a65%3A0x6444fef7b88e7a8c!2z2LnZitin2K_ZhyDYp9ivINmF2K3ZhdivINmF2K3ZhdmI2K8g2KfYqNmI2LLZitivINmE2KzYsdin2K3Yp9iqINin2YTYs9mF2YbZhyDZiCDYqtmD2YXZitmFINin2YTZhdi52K_YqSAtIFBlcmZlY3QgSGVhbHRoIENsaW5pY3M!5e0!3m2!1sen!2seg!4v1568106265915!5m2!1sen!2seg', 3, '2019-09-24 22:33:30', '2019-10-14 09:13:48', NULL),
(5, '01111111111', NULL, 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3451.9881371883316!2d31.327343815116194!3d30.094526081864093!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x1458158b1e7c5a65%3A0x6444fef7b88e7a8c!2z2LnZitin2K_ZhyDYp9ivINmF2K3ZhdivINmF2K3ZhdmI2K8g2KfYqNmI2LLZitivINmE2KzYsdin2K3Yp9iqINin2YTYs9mF2YbZhyDZiCDYqtmD2YXZitmFINin2YTZhdi52K_YqSAtIFBlcmZlY3QgSGVhbHRoIENsaW5pY3M!5e0!3m2!1sen!2seg!4v1568106265915!5m2!1sen!2seg', 3, '2019-10-14 08:15:20', '2019-10-14 09:22:17', '2019-10-14 11:22:17');

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

--
-- Table structure for table `client`
--

CREATE TABLE IF NOT EXISTS `client` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `image_id` int(10) UNSIGNED DEFAULT NULL,
  `created_by` int(10) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `client_image_id` (`image_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `contact`
--

CREATE TABLE IF NOT EXISTS `contact` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_alt` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_id` int(10) UNSIGNED DEFAULT NULL,
  `address_en` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address_ar` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `location` text,
  `facebook` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `twitter` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instagram` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `youtube` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `linkedin` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pintrest` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `behance` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `whatsapp` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `google_plus` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `contact_file_id` (`file_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`id`, `email`, `phone`, `phone_alt`, `file_id`, `address_en`, `address_ar`, `location`, `facebook`, `twitter`, `instagram`, `youtube`, `linkedin`, `pintrest`, `behance`, `whatsapp`, `google_plus`, `updated_at`, `created_at`) VALUES
(1, 'info@mohamedAbouzeid.com', '+2 010 124 61 121', '+2 011 011 028 27', NULL, '28 Rabaa Eladawya Buildings, Elnozha Street,  Nasr City, Cairo, Egypt', '28 عمارات رابعة العدوية الاستثماري، تقاطع شارع النزهة مع طريق النصر, مدينة نصر، محافظة القاهرة‬ - مصر', 'https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d55244.85071154436!2d31.338405!3d30.071176!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xb058b6624f890905!2sDr.+Ahmed+ElNabil+-+Bariatric+%26+Laparoscopic+Surgeon!5e0!3m2!1sen!2sus!4v1566310485162!5m2!1sen!2sus', 'https://www.facebook.com/drahmedelnabil', 'https://twitter.com/drahmedelnabil', 'https://www.instagram.com/drahmedelnabil', 'https://www.youtube.com/channel/UCZaztM96-ZdrF9raT6OFb7A', NULL, NULL, NULL, '+2 010 124 61 121', NULL, '2019-10-15 10:31:23', NULL);

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

--
-- Table structure for table `feature`
--

CREATE TABLE IF NOT EXISTS `feature` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `image_id` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `feature_image_id` (`image_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `feature`
--

INSERT INTO `feature` (`id`, `image_id`, `created_at`, `updated_at`) VALUES
(1, 537, '2019-10-13 09:49:34', '2019-10-13 10:03:42'),
(2, 538, '2019-10-13 09:50:36', '2019-10-13 10:03:56');

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

--
-- Table structure for table `file`
--

CREATE TABLE IF NOT EXISTS `file` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `file`
--

INSERT INTO `file` (`id`, `name`, `path`, `created_at`, `updated_at`) VALUES
(1, '1566403726banner2.jpg', 'dashboardImages/contactFiles/1566403726banner2.jpg', '2019-08-21 14:08:46', '2019-08-21 14:08:46'),
(2, '1566403864banner2.jpg', 'dashboardImages/contactFiles/1566403864banner2.jpg', '2019-08-21 14:11:04', '2019-08-21 14:11:04'),
(3, '1566403974banner2.jpg', 'dashboardImages/contactFiles/1566403974banner2.jpg', '2019-08-21 14:12:54', '2019-08-21 14:12:54'),
(4, '1566731719156673120217-650x350.jpg', 'dashboardImages/appointments/1566731719156673120217-650x350.jpg', '2019-08-25 15:15:19', '2019-08-25 15:15:19'),
(5, '1567094714bmi.png', 'dashboardImages/contactFiles/1567094714bmi.png', '2019-08-29 20:05:14', '2019-08-29 20:05:14'),
(6, '156713026812391891_903523759725030_7696815635537288591_n.jpg', 'dashboardImages/contactFiles/156713026812391891_903523759725030_7696815635537288591_n.jpg', '2019-08-30 05:57:48', '2019-08-30 05:57:48'),
(7, '156713054212391891_903523759725030_7696815635537288591_n.jpg', 'dashboardImages/appointments/156713054212391891_903523759725030_7696815635537288591_n.jpg', '2019-08-30 06:02:22', '2019-08-30 06:02:22'),
(8, '1567130743942541_908562145887858_1615123856846563610_n.jpg', 'dashboardImages/appointments/1567130743942541_908562145887858_1615123856846563610_n.jpg', '2019-08-30 06:05:43', '2019-08-30 06:05:43'),
(9, '156713088413669800_1027696733974398_4636621315345423580_n.jpg', 'dashboardImages/appointments/156713088413669800_1027696733974398_4636621315345423580_n.jpg', '2019-08-30 06:08:04', '2019-08-30 06:08:04'),
(10, '1567341985ear-3.jpg', 'dashboardImages/appointments/1567341985ear-3.jpg', '2019-09-01 16:46:25', '2019-09-01 16:46:25'),
(11, '1567342097ear-3.jpg', 'dashboardImages/appointments/1567342097ear-3.jpg', '2019-09-01 16:48:17', '2019-09-01 16:48:17');

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

--
-- Table structure for table `form`
--

CREATE TABLE IF NOT EXISTS `form` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `formId` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `page_id` int(11) DEFAULT NULL,
  `tracking_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `header_code` text COLLATE utf8mb4_unicode_ci,
  `body_code` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `form_page_id` (`page_id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `form`
--

INSERT INTO `form` (`id`, `name`, `formId`, `page_id`, `tracking_id`, `header_code`, `body_code`, `created_at`, `updated_at`) VALUES
(27, 'hogyv@mailinator.com', NULL, NULL, NULL, NULL, NULL, '2019-09-24 10:16:00', '2019-09-24 10:16:00'),
(31, 'Obesity Clinic - Weight Loss', NULL, NULL, NULL, NULL, NULL, '2019-09-24 11:17:05', '2019-09-24 11:17:05'),
(32, 'Obesity Clinic - Reshaping', NULL, NULL, NULL, NULL, NULL, '2019-09-24 11:23:29', '2019-09-24 11:23:29'),
(33, 'Cosmotic & Laser Clinic', NULL, NULL, NULL, NULL, NULL, '2019-09-24 11:26:28', '2019-09-24 11:26:28'),
(34, 'Key Hole Surgery', NULL, NULL, NULL, NULL, NULL, '2019-09-24 11:29:17', '2019-09-24 11:29:17'),
(35, 'Breast Surgery', NULL, NULL, NULL, NULL, NULL, '2019-09-24 11:29:32', '2019-09-24 11:29:32'),
(36, 'Varicose Vein Surgery', NULL, NULL, NULL, NULL, NULL, '2019-09-24 11:29:41', '2019-09-24 11:29:41'),
(37, 'Laparoscopic Gastric Bypass', NULL, NULL, NULL, NULL, NULL, '2019-09-24 11:30:04', '2019-09-24 11:30:04'),
(38, 'Laparoscopic Sleeve Gastrectomy', NULL, NULL, NULL, NULL, NULL, '2019-09-24 11:31:53', '2019-09-24 11:31:53'),
(39, 'Intragastric Ballon', NULL, NULL, NULL, NULL, NULL, '2019-09-24 11:32:04', '2019-09-24 11:32:04'),
(40, 'Laparoscopic Redo Surgery', NULL, NULL, NULL, NULL, NULL, '2019-09-24 11:32:23', '2019-09-24 11:32:23'),
(41, 'byvahofux@mailinator.com', NULL, NULL, NULL, NULL, NULL, '2019-09-24 11:38:05', '2019-09-24 11:38:05');

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

--
-- Table structure for table `gallery`
--

CREATE TABLE IF NOT EXISTS `gallery` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `image_id` int(10) UNSIGNED DEFAULT NULL,
  `video_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `gallery_image_id` (`image_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `image`
--

CREATE TABLE IF NOT EXISTS `image` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `alt` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `album_id` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `image_album_id` (`album_id`)
) ENGINE=InnoDB AUTO_INCREMENT=585 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `image`
--

INSERT INTO `image` (`id`, `name`, `path`, `alt`, `album_id`, `created_at`, `updated_at`) VALUES
(239, '156621131517-650x350.jpg', 'dashboardImages/service/156621131517-650x350.jpg', NULL, NULL, '2019-08-19 08:41:55', '2019-08-19 08:41:55'),
(266, '1566379811about.png', 'dashboardImages/team/1566379811about.png', NULL, NULL, '2019-08-21 07:30:11', '2019-08-21 07:30:11'),
(270, '1566387433lat-blog-3.jpg', 'dashboardImages/service/1566387433lat-blog-3.jpg', NULL, NULL, '2019-08-21 09:37:13', '2019-08-21 09:37:13'),
(272, '1566394952mision.png', 'dashboardImages/blog/1566394952mision.png', 'bilymelazu@mailinator.com', NULL, '2019-08-21 11:42:32', '2019-08-21 11:42:32'),
(273, '1566395000mision.png', 'dashboardImages/blog/1566395000mision.png', 'bilymelazu@mailinator.com', NULL, '2019-08-21 11:43:20', '2019-08-21 11:43:20'),
(274, '156672720217-650x350.jpg', 'dashboardImages/slider/156672720217-650x350.jpg', 'nihehyxi@mailinator.com', NULL, '2019-08-25 14:00:02', '2019-08-25 14:00:02'),
(277, '1567088023service-1.jpg', 'dashboardImages/slider/1567088023service-1.jpg', NULL, NULL, '2019-08-29 18:13:43', '2019-08-29 18:13:43'),
(283, '1567088493Logo 1.png', 'dashboardImages/slider/1567088493Logo 1.png', 'Elite Care Clinics by Prof Ahmed Elnabil', NULL, '2019-08-29 18:21:33', '2019-08-30 01:33:41'),
(284, '1567088729Logo-1.png', 'dashboardImages/setting/1567088729Logo-1.png', NULL, NULL, '2019-08-29 18:25:29', '2019-08-29 18:25:29'),
(286, '156709056013697175_1026316654112406_2722328623378624082_n.png', 'dashboardImages/testimonial/156709056013697175_1026316654112406_2722328623378624082_n.png', NULL, NULL, '2019-08-29 18:56:00', '2019-08-29 18:56:00'),
(287, '156709062413697175_1026316654112406_2722328623378624082_n.png', 'dashboardImages/testimonial/156709062413697175_1026316654112406_2722328623378624082_n.png', NULL, NULL, '2019-08-29 18:57:04', '2019-08-29 18:57:04'),
(288, '156709086113697175_1026316654112406_2722328623378624082_n.png', 'dashboardImages/album/156709086113697175_1026316654112406_2722328623378624082_n.png', NULL, NULL, '2019-08-29 19:01:01', '2019-08-29 19:01:01'),
(298, '156709133612366422_903523823058357_8397166799479880486_n.jpg', 'dashboardImages/album/156709133612366422_903523823058357_8397166799479880486_n.jpg', NULL, NULL, '2019-08-29 19:08:56', '2019-08-29 19:08:56'),
(305, '1567091998about-3.jpg', 'dashboardImages/album/1567091998about-3.jpg', NULL, NULL, '2019-08-29 19:19:58', '2019-08-29 19:19:58'),
(307, '1567092528service-details.jpg', 'dashboardImages/slider/1567092528service-details.jpg', NULL, NULL, '2019-08-29 19:28:48', '2019-08-29 19:28:48'),
(308, '1567092767service-1.jpg', 'dashboardImages/slider/1567092767service-1.jpg', NULL, NULL, '2019-08-29 19:32:47', '2019-08-29 19:32:47'),
(309, '1567092850slide-2.jpg', 'dashboardImages/slider/1567092850slide-2.jpg', NULL, NULL, '2019-08-29 19:34:10', '2019-08-29 19:34:10'),
(311, '1567093197slide-3.jpg', 'dashboardImages/service/1567093197slide-3.jpg', NULL, NULL, '2019-08-29 19:39:57', '2019-08-29 19:39:57'),
(312, '1567093871slide-1.jpg', 'dashboardImages/about/1567093871slide-1.jpg', NULL, NULL, '2019-08-29 19:51:15', '2019-08-29 19:51:15'),
(313, '1567093875slide-2.jpg', 'dashboardImages/about/1567093875slide-2.jpg', NULL, NULL, '2019-08-29 19:51:15', '2019-08-29 19:51:15'),
(314, '1567093875slide-3.jpg', 'dashboardImages/about/1567093875slide-3.jpg', NULL, NULL, '2019-08-29 19:51:17', '2019-08-29 19:51:17'),
(315, '1567093877slide-1.jpg', 'dashboardImages/about/1567093877slide-1.jpg', NULL, NULL, '2019-08-29 19:51:21', '2019-08-29 19:51:21'),
(316, '1567094513slide-3.jpg', 'dashboardImages/blog/1567094513slide-3.jpg', 'bilymelazu@mailinator.com', NULL, '2019-08-29 20:01:53', '2019-08-29 20:01:53'),
(317, '1567106240F9.jpg', 'dashboardImages/slider/1567106240F9.jpg', NULL, NULL, '2019-08-29 23:17:20', '2019-08-29 23:17:20'),
(318, '1567106412F8.jpg', 'dashboardImages/slider/1567106412F8.jpg', 'jk', NULL, '2019-08-29 23:20:12', '2019-09-24 11:29:08'),
(319, '1567106975F10.jpg', 'dashboardImages/slider/1567106975F10.jpg', NULL, NULL, '2019-08-29 23:29:35', '2019-08-29 23:29:35'),
(320, '1567107840F11.jpg', 'dashboardImages/slider/1567107840F11.jpg', NULL, NULL, '2019-08-29 23:44:00', '2019-08-29 23:44:00'),
(321, '1567108066F11.jpg', 'dashboardImages/slider/1567108066F11.jpg', NULL, NULL, '2019-08-29 23:47:46', '2019-08-29 23:47:46'),
(323, '1567114849تحويل-مسار-المعدة.jpg', 'dashboardImages/slider/1567114849تحويل-مسار-المعدة.jpg', NULL, NULL, '2019-08-30 01:40:49', '2019-08-30 01:40:49'),
(324, '1567114993تحويل-مسار-المعدة.jpg', 'dashboardImages/service/1567114993تحويل-مسار-المعدة.jpg', NULL, NULL, '2019-08-30 01:43:13', '2019-08-30 01:43:13'),
(325, '1567115163F7.jpg', 'dashboardImages/service/1567115163F7.jpg', NULL, NULL, '2019-08-30 01:46:03', '2019-08-30 01:46:03'),
(326, '1567115660F7.jpg', 'dashboardImages/service/1567115660F7.jpg', NULL, NULL, '2019-08-30 01:54:20', '2019-08-30 01:54:20'),
(327, '1567115981تعافى-المريض-بعد-بالون-المعدة (1).jpg', 'dashboardImages/slider/1567115981تعافى-المريض-بعد-بالون-المعدة (1).jpg', 'We help support you by different ways', NULL, '2019-08-30 01:59:41', '2019-08-30 01:59:41'),
(328, '1567116249pyramids-egypt-2134-750x315.jpg', 'dashboardImages/slider/1567116249pyramids-egypt-2134-750x315.jpg', 'We are the best provider in Medical Tourism', NULL, '2019-08-30 02:04:09', '2019-08-30 02:04:09'),
(329, '156711669720190613_205610.jpg', 'dashboardImages/slider/156711669720190613_205610.jpg', 'Dr Ahmed Elnabil, Prof of General Surgery & Consultant of Obesity and laparoscopic Surgery', NULL, '2019-08-30 02:11:40', '2019-08-30 02:11:40'),
(330, '156711721420190616_101736.jpg', 'dashboardImages/about/156711721420190616_101736.jpg', NULL, NULL, '2019-08-30 02:20:14', '2019-08-30 02:20:14'),
(331, '156711746820190616_101736.jpg', 'dashboardImages/about/156711746820190616_101736.jpg', NULL, NULL, '2019-08-30 02:24:28', '2019-08-30 02:24:28'),
(332, '156711792720190616_101736.jpg', 'dashboardImages/team/156711792720190616_101736.jpg', NULL, NULL, '2019-08-30 02:32:07', '2019-08-30 02:32:07'),
(335, '156711877913.jpg', 'dashboardImages/album/156711877913.jpg', NULL, NULL, '2019-08-30 02:46:19', '2019-08-30 02:46:19'),
(348, '156712454512.jpg', 'dashboardImages/album/156712454512.jpg', NULL, NULL, '2019-08-30 04:22:25', '2019-08-30 04:22:25'),
(367, '1567126337FEBSMIS.jpg', 'dashboardImages/album/1567126337FEBSMIS.jpg', NULL, NULL, '2019-08-30 04:52:19', '2019-08-30 04:52:19'),
(374, '1567127408عملية-تكميم-المعدة.jpg', 'dashboardImages/service/1567127408عملية-تكميم-المعدة.jpg', NULL, NULL, '2019-08-30 05:10:08', '2019-08-30 05:10:08'),
(375, '1567127489بالون-المعدة-بالمنظار.jpg', 'dashboardImages/service/1567127489بالون-المعدة-بالمنظار.jpg', NULL, NULL, '2019-08-30 05:11:29', '2019-08-30 05:11:29'),
(376, '1567127606تحويل-مسار-المعدة.jpg', 'dashboardImages/service/1567127606تحويل-مسار-المعدة.jpg', NULL, NULL, '2019-08-30 05:13:26', '2019-08-30 05:13:26'),
(377, '1567127779pp12.jpg', 'dashboardImages/service/1567127779pp12.jpg', NULL, NULL, '2019-08-30 05:16:19', '2019-08-30 05:16:19'),
(378, '1567127934pp-2.jpg', 'dashboardImages/service/1567127934pp-2.jpg', NULL, NULL, '2019-08-30 05:18:54', '2019-08-30 05:18:54'),
(379, '1567128055pp.jpg', 'dashboardImages/service/1567128055pp.jpg', NULL, NULL, '2019-08-30 05:20:55', '2019-08-30 05:20:55'),
(386, '1567129625pp-2.jpg', 'dashboardImages/blog/1567129625pp-2.jpg', 'Effect of Laparoscopic Sleeve Gastrectomy on Clinical Hypothyroidism', NULL, '2019-08-30 05:47:09', '2019-08-30 05:47:09'),
(387, '1567129753F6.jpg', 'dashboardImages/blog/1567129753F6.jpg', 'Effect of Sleeve Gastrectomy on Esophageal Reflux', NULL, '2019-08-30 05:49:13', '2019-08-30 05:49:13'),
(388, '1567130028pp12.jpg', 'dashboardImages/blog/1567130028pp12.jpg', 'Safety and Efficacy of Laparoscopic sleeve Gastrectomy on Class 1 obesity', NULL, '2019-08-30 05:53:48', '2019-08-30 05:53:48'),
(389, '1567131192pp12.jpg', 'dashboardImages/about/1567131192pp12.jpg', NULL, NULL, '2019-08-30 06:13:12', '2019-08-30 06:13:12'),
(390, '1567131192pp-2.jpg', 'dashboardImages/about/1567131192pp-2.jpg', NULL, NULL, '2019-08-30 06:13:12', '2019-08-30 06:13:12'),
(391, '1567131192942541_908562145887858_1615123856846563610_n.jpg', 'dashboardImages/about/1567131192942541_908562145887858_1615123856846563610_n.jpg', NULL, NULL, '2019-08-30 06:13:12', '2019-08-30 06:13:12'),
(392, '1567131192Image-40-225x300.jpg', 'dashboardImages/about/1567131192Image-40-225x300.jpg', NULL, NULL, '2019-08-30 06:13:12', '2019-08-30 06:13:12'),
(393, '156729668614045666_1052991971444874_5240131624976723813_n.png', 'dashboardImages/testimonial/156729668614045666_1052991971444874_5240131624976723813_n.png', NULL, NULL, '2019-09-01 04:11:26', '2019-09-01 04:11:26'),
(394, '156729791512.jpg', 'dashboardImages/testimonial/156729791512.jpg', NULL, NULL, '2019-09-01 04:31:55', '2019-09-01 04:31:55'),
(395, '156729871514089318_1056453494432055_2388640315964947902_n.png', 'dashboardImages/testimonial/156729871514089318_1056453494432055_2388640315964947902_n.png', NULL, NULL, '2019-09-01 04:45:15', '2019-09-01 04:45:15'),
(396, '1567299308pp12.jpg', 'dashboardImages/testimonial/1567299308pp12.jpg', NULL, NULL, '2019-09-01 04:55:08', '2019-09-01 04:55:08'),
(397, '1567299494pp-2.jpg', 'dashboardImages/testimonial/1567299494pp-2.jpg', NULL, NULL, '2019-09-01 04:58:17', '2019-09-01 04:58:17'),
(398, '156730043714141767_1052992191444852_584314722569051661_n.jpg', 'dashboardImages/testimonial/156730043714141767_1052992191444852_584314722569051661_n.jpg', NULL, NULL, '2019-09-01 05:13:57', '2019-09-01 05:13:57'),
(403, '1567612669F4.jpg', 'dashboardImages/offer/1567612669F4.jpg', 'افضل جهة للسياحة العلاجية', NULL, '2019-09-04 19:57:49', '2019-09-04 19:57:49'),
(404, '1568325865images.jpeg', 'dashboardImages/service/1568325865images.jpeg', NULL, NULL, '2019-09-13 02:04:25', '2019-09-13 02:04:25'),
(405, '1568325895images.jpeg', 'dashboardImages/service/1568325895images.jpeg', NULL, NULL, '2019-09-13 02:04:55', '2019-09-13 02:04:55'),
(406, '1568325921images.jpeg', 'dashboardImages/service/1568325921images.jpeg', NULL, NULL, '2019-09-13 02:05:21', '2019-09-13 02:05:21'),
(407, '1568325964Clinic.vodafone 20190409_234220.jpg', 'dashboardImages/service/1568325964Clinic.vodafone 20190409_234220.jpg', NULL, NULL, '2019-09-13 02:06:04', '2019-09-13 02:06:04'),
(408, '1568325995images.jpeg', 'dashboardImages/service/1568325995images.jpeg', NULL, NULL, '2019-09-13 02:06:35', '2019-09-13 02:06:35'),
(409, '156858630420190613_205610.jpg', 'dashboardImages/slider/156858630420190613_205610.jpg', 'Dr Ahmed Elnabil, Prof of General Surgery & Consultant of Obesity and laparoscopic Surgery', NULL, '2019-09-16 02:25:04', '2019-09-16 02:25:04'),
(410, '1568586847تعافى-المريض-بعد-بالون-المعدة (1).jpg', 'dashboardImages/slider/1568586847تعافى-المريض-بعد-بالون-المعدة (1).jpg', 'We help support you by different ways', NULL, '2019-09-16 02:34:07', '2019-09-16 02:34:07'),
(412, '1568587268pyramids-egypt-2134-750x315.jpg', 'dashboardImages/slider/1568587268pyramids-egypt-2134-750x315.jpg', 'We are the best provider in Medical Tourism', NULL, '2019-09-16 02:41:08', '2019-09-16 02:41:08'),
(418, '156859223214045666_1052991971444874_5240131624976723813_n.png', 'dashboardImages/testimonial/156859223214045666_1052991971444874_5240131624976723813_n.png', NULL, NULL, '2019-09-16 04:03:52', '2019-09-16 04:03:52'),
(419, '156859225212.jpg', 'dashboardImages/testimonial/156859225212.jpg', NULL, NULL, '2019-09-16 04:04:12', '2019-09-16 04:04:12'),
(420, '156859227614089318_1056453494432055_2388640315964947902_n.png', 'dashboardImages/testimonial/156859227614089318_1056453494432055_2388640315964947902_n.png', NULL, NULL, '2019-09-16 04:04:36', '2019-09-16 04:04:36'),
(421, '1568592337pp12.jpg', 'dashboardImages/testimonial/1568592337pp12.jpg', NULL, NULL, '2019-09-16 04:05:37', '2019-09-16 04:05:37'),
(422, '1568592361pp.jpg', 'dashboardImages/testimonial/1568592361pp.jpg', NULL, NULL, '2019-09-16 04:06:01', '2019-09-16 04:06:01'),
(423, '156859237917191058_1254546867956049_7094099639614282127_n.png', 'dashboardImages/testimonial/156859237917191058_1254546867956049_7094099639614282127_n.png', NULL, NULL, '2019-09-16 04:06:19', '2019-09-16 04:06:19'),
(425, '1568595465mini.jpg', 'dashboardImages/slider/1568595465mini.jpg', NULL, NULL, '2019-09-16 04:57:45', '2019-09-16 04:57:45'),
(426, '1568595599rygp.jpg', 'dashboardImages/slider/1568595599rygp.jpg', 'عمليات تحويل المسار', NULL, '2019-09-16 04:59:59', '2019-10-02 03:33:41'),
(427, '1568595631sleeve.jpg', 'dashboardImages/slider/1568595631sleeve.jpg', 'تكميم المعدة', NULL, '2019-09-16 05:00:31', '2019-10-02 03:23:39'),
(428, '1568595675BALLON.jpg', 'dashboardImages/slider/1568595675BALLON.jpg', 'بالون المعدة', NULL, '2019-09-16 05:01:15', '2019-10-02 02:51:54'),
(432, '1568596182vbg.jpg', 'dashboardImages/slider/1568596182vbg.jpg', 'عمليات تحويل المسار', NULL, '2019-09-16 05:09:42', '2019-10-02 03:39:55'),
(434, '1568597175bader.jpg', 'dashboardImages/team/1568597175bader.jpg', NULL, NULL, '2019-09-16 05:26:15', '2019-09-16 05:26:15'),
(435, '1568597194bader.jpg', 'dashboardImages/team/1568597194bader.jpg', NULL, NULL, '2019-09-16 05:26:34', '2019-09-16 05:26:34'),
(436, '1568874052Image-40-225x300.jpg', 'dashboardImages/team/1568874052Image-40-225x300.jpg', NULL, NULL, '2019-09-19 10:20:52', '2019-09-19 10:20:52'),
(437, '1568874065Image-40-225x300.jpg', 'dashboardImages/team/1568874065Image-40-225x300.jpg', NULL, NULL, '2019-09-19 10:21:05', '2019-09-19 10:21:05'),
(438, '1568874077Image-40-225x300.jpg', 'dashboardImages/team/1568874077Image-40-225x300.jpg', NULL, NULL, '2019-09-19 10:21:17', '2019-09-19 10:21:17'),
(439, '156887437620190616_101736.jpg', 'dashboardImages/team/156887437620190616_101736.jpg', NULL, NULL, '2019-09-19 10:26:16', '2019-09-19 10:26:16'),
(440, '1568875237F6.jpg', 'dashboardImages/blog/1568875237F6.jpg', 'Effect of Sleeve Gastrectomy on Esophageal Reflux', NULL, '2019-09-19 10:40:37', '2019-09-19 10:40:37'),
(441, '1568875268pp.jpg', 'dashboardImages/blog/1568875268pp.jpg', 'Effect of Laparoscopic Sleeve Gastrectomy on Clinical Hypothyroidism', NULL, '2019-09-19 10:41:08', '2019-09-19 10:41:08'),
(442, '1568875295pp.jpg', 'dashboardImages/blog/1568875295pp.jpg', 'Safety and Efficacy of Laparoscopic sleeve Gastrectomy on Class 1 obesity', NULL, '2019-09-19 10:41:35', '2019-09-19 10:41:35'),
(443, '1568875725dr ahmed.jpeg', 'dashboardImages/about/1568875725dr ahmed.jpeg', NULL, NULL, '2019-09-19 10:48:45', '2019-09-19 10:48:45'),
(444, '156893004920190616_101736.jpg', 'dashboardImages/team/156893004920190616_101736.jpg', NULL, NULL, '2019-09-20 01:54:09', '2019-09-20 01:54:09'),
(478, '1569283633F7.jpg', 'dashboardImages/slider/1569283633F7.jpg', NULL, NULL, '2019-09-24 04:07:13', '2019-09-24 04:07:13'),
(479, '1569283954Logo الجراحة.png', 'dashboardImages/slider/1569283954Logo الجراحة.png', NULL, NULL, '2019-09-24 04:12:34', '2019-09-24 04:12:34'),
(480, '1569289231Logo السمنه.png', 'dashboardImages/album/1569289231Logo السمنه.png', NULL, NULL, '2019-09-24 05:40:31', '2019-09-24 05:40:31'),
(482, '156931666213.jpg', 'dashboardImages/slider/156931666213.jpg', 'fff', NULL, '2019-09-24 13:17:42', '2019-09-24 11:28:45'),
(483, '156931679613707550_1027713070639431_4362316680534968186_n.jpg', 'dashboardImages/slider/156931679613707550_1027713070639431_4362316680534968186_n.jpg', 'ss', NULL, '2019-09-24 13:19:56', '2019-09-24 11:23:01'),
(498, '1569401033picture.png', 'dashboardImages/blog/1569401033picture.png', 'qepixecy@mailinator.net', NULL, '2019-09-25 06:43:53', '2019-09-25 06:43:53'),
(501, '15694213541568325964Clinic.vodafone 20190409_234220.jpg', 'dashboardImages/service/15694213541568325964Clinic.vodafone 20190409_234220.jpg', 'sd', NULL, '2019-09-25 18:22:34', '2019-09-25 18:22:34'),
(502, '15694213911567115981تعافى-المريض-بعد-بالون-المعدة (1).jpg', 'dashboardImages/slider/15694213911567115981تعافى-المريض-بعد-بالون-المعدة (1).jpg', 'We help support you by different ways', NULL, '2019-09-25 18:23:11', '2019-09-25 18:23:11'),
(503, '15694264861568586847تعافى-المريض-بعد-بالون-المعدة (1).jpg', 'dashboardImages/slider/15694264861568586847تعافى-المريض-بعد-بالون-المعدة (1).jpg', 'We help support you by different ways', NULL, '2019-09-25 19:48:06', '2019-09-25 19:48:06'),
(505, '1569825450pp-2.jpg', 'dashboardImages/about/1569825450pp-2.jpg', NULL, NULL, '2019-09-30 10:37:30', '2019-09-30 10:37:30'),
(506, '156982554120190616_101736.jpg', 'dashboardImages/about/156982554120190616_101736.jpg', NULL, NULL, '2019-09-30 10:39:01', '2019-09-30 10:39:01'),
(508, '1569829844Logo التجميل.png', 'dashboardImages/team/1569829844Logo التجميل.png', NULL, NULL, '2019-09-30 11:50:44', '2019-09-30 11:50:44'),
(510, '1570007732156982554120190616_101736.jpg', 'dashboardImages/about/1570007732156982554120190616_101736.jpg', NULL, NULL, '2019-10-02 13:15:32', '2019-10-02 13:15:32'),
(511, '1570007774156859021720190616_152438.jpg', 'dashboardImages/about/1570007774156859021720190616_152438.jpg', NULL, NULL, '2019-10-02 13:16:14', '2019-10-02 13:16:14'),
(512, '1570049674Image (39).jpg', 'dashboardImages/about/1570049674Image (39).jpg', NULL, NULL, '2019-10-03 00:54:34', '2019-10-03 00:54:34'),
(515, '157008506314183720_1057049221039149_7906515005574846915_n.png', 'dashboardImages/blog/157008506314183720_1057049221039149_7906515005574846915_n.png', 'ما هي جراحات السمنة؟', NULL, '2019-10-03 10:44:23', '2019-10-03 10:44:23'),
(516, '157008508214183720_1057049221039149_7906515005574846915_n.png', 'dashboardImages/blog/157008508214183720_1057049221039149_7906515005574846915_n.png', 'ما هي جراحات السمنة؟', NULL, '2019-10-03 10:44:42', '2019-10-03 10:44:42'),
(517, '157008511714183720_1057049221039149_7906515005574846915_n.png', 'dashboardImages/blog/157008511714183720_1057049221039149_7906515005574846915_n.png', 'ما هي جراحات السمنة؟', NULL, '2019-10-03 10:45:17', '2019-10-03 10:45:17'),
(518, '157008516214183720_1057049221039149_7906515005574846915_n.png', 'dashboardImages/blog/157008516214183720_1057049221039149_7906515005574846915_n.png', 'ما هي جراحات السمنة؟', NULL, '2019-10-03 10:46:02', '2019-10-03 10:46:02'),
(521, '157008530214183720_1057049221039149_7906515005574846915_n.png', 'dashboardImages/blog/157008530214183720_1057049221039149_7906515005574846915_n.png', 'Obesity surgery', NULL, '2019-10-03 10:48:22', '2019-10-03 10:48:22'),
(523, '1570089108F7.jpg', 'dashboardImages/service/1570089108F7.jpg', 'key hole surgery', NULL, '2019-10-03 11:51:48', '2019-10-03 11:51:48'),
(524, '1570089133F7.jpg', 'dashboardImages/service/1570089133F7.jpg', 'key hole surgery', NULL, '2019-10-03 11:52:13', '2019-10-03 11:52:13'),
(525, '1570089151F7.jpg', 'dashboardImages/service/1570089151F7.jpg', 'key hole surgery', NULL, '2019-10-03 11:52:31', '2019-10-03 11:52:31'),
(526, '1570094018slide-1.jpg', 'dashboardImages/slider/1570094018slide-1.jpg', 'Dr Ahmed Elnabil', NULL, '2019-10-03 13:13:38', '2019-10-04 01:21:10'),
(527, '1570094029slide-2.jpg', 'dashboardImages/slider/1570094029slide-2.jpg', 'our service', NULL, '2019-10-03 13:13:49', '2019-10-04 01:23:40'),
(528, '1570094041slide-3.jpg', 'dashboardImages/slider/1570094041slide-3.jpg', 'Medical Tourism', NULL, '2019-10-03 13:14:01', '2019-10-04 01:20:50'),
(529, '1570443287slide-4.jpg', 'dashboardImages/slider/1570443287slide-4.jpg', 'our service', NULL, '2019-10-07 14:14:48', '2019-10-07 14:14:48'),
(530, '1570959750about1.png', 'dashboardImages/about/1570959750about1.png', NULL, NULL, '2019-10-13 07:42:30', '2019-10-13 07:42:30'),
(531, '15709615911.JPG', 'dashboardImages/album/15709615911.JPG', NULL, NULL, '2019-10-13 08:13:11', '2019-10-13 08:13:11'),
(532, '15709616172.jpg', 'dashboardImages/album/15709616172.jpg', NULL, 19, '2019-10-13 08:13:37', '2019-10-13 08:13:37'),
(533, '15709616173.jpg', 'dashboardImages/album/15709616173.jpg', NULL, 19, '2019-10-13 08:13:37', '2019-10-13 08:13:37'),
(534, '15709616391.JPG', 'dashboardImages/album/15709616391.JPG', NULL, 19, '2019-10-13 08:13:59', '2019-10-13 08:13:59'),
(535, '15709673742 (1).jpg', 'dashboardImages/feature/15709673742 (1).jpg', NULL, NULL, '2019-10-13 09:49:34', '2019-10-13 09:49:34'),
(536, '1570967436prosthodontics.jpg', 'dashboardImages/feature/1570967436prosthodontics.jpg', NULL, NULL, '2019-10-13 09:50:36', '2019-10-13 09:50:36'),
(537, '1570968535prosthodontics.jpg', 'dashboardImages/feature/1570968535prosthodontics.jpg', NULL, NULL, '2019-10-13 10:03:42', '2019-10-13 10:08:55'),
(538, '1570968630heart-hands.jpg', 'dashboardImages/feature/1570968630heart-hands.jpg', NULL, NULL, '2019-10-13 10:03:56', '2019-10-13 10:10:30'),
(539, '1570973881dr.2.png', 'dashboardImages/team/1570973881dr.2.png', NULL, NULL, '2019-10-13 11:38:01', '2019-10-13 11:38:01'),
(540, '1570975888gallery-1.jpg', 'dashboardImages/album/1570975888gallery-1.jpg', NULL, NULL, '2019-10-13 12:11:28', '2019-10-13 12:11:28'),
(541, '1570975905gallery-1.jpg', 'dashboardImages/album/1570975905gallery-1.jpg', NULL, 20, '2019-10-13 12:11:45', '2019-10-13 12:11:45'),
(542, '1570975905gallery-2.jpg', 'dashboardImages/album/1570975905gallery-2.jpg', NULL, 20, '2019-10-13 12:11:45', '2019-10-13 12:11:45'),
(543, '1570975905gallery-3.jpg', 'dashboardImages/album/1570975905gallery-3.jpg', NULL, 20, '2019-10-13 12:11:45', '2019-10-13 12:11:45'),
(544, '1570975905gallery-4.jpg', 'dashboardImages/album/1570975905gallery-4.jpg', NULL, 20, '2019-10-13 12:11:45', '2019-10-13 12:11:45'),
(545, '1570975905gallery-5.jpg', 'dashboardImages/album/1570975905gallery-5.jpg', NULL, 20, '2019-10-13 12:11:45', '2019-10-13 12:11:45'),
(546, '1570975905gallery-6.jpg', 'dashboardImages/album/1570975905gallery-6.jpg', NULL, 20, '2019-10-13 12:11:45', '2019-10-13 12:11:45'),
(547, '1570980827gallery-5.jpg', 'dashboardImages/album/1570980827gallery-5.jpg', NULL, 21, '2019-10-13 13:33:47', '2019-10-13 13:33:47'),
(548, '1570980854gallery-1.jpg', 'dashboardImages/album/1570980854gallery-1.jpg', NULL, 21, '2019-10-13 13:34:14', '2019-10-13 13:34:14'),
(549, '1570980854gallery-2.jpg', 'dashboardImages/album/1570980854gallery-2.jpg', NULL, 21, '2019-10-13 13:34:14', '2019-10-13 13:34:14'),
(550, '1570980854gallery-3.jpg', 'dashboardImages/album/1570980854gallery-3.jpg', NULL, 21, '2019-10-13 13:34:14', '2019-10-13 13:34:14'),
(552, '1570980854gallery-5.jpg', 'dashboardImages/album/1570980854gallery-5.jpg', NULL, 21, '2019-10-13 13:34:14', '2019-10-13 13:34:14'),
(553, '1571054895376432women.jpg', 'dashboardImages/blog/1571054895376432women.jpg', 'gibab@mailinator.net', NULL, '2019-10-14 10:08:15', '2019-10-14 10:08:15'),
(554, '157105557111068126_3.jpg', 'dashboardImages/blog/157105557111068126_3.jpg', 'zafisov@mailinator.net', NULL, '2019-10-14 10:19:31', '2019-10-14 10:19:31'),
(555, '1571055931index34.jpg', 'dashboardImages/blog/1571055931index34.jpg', 'pimivac@mailinator.net', NULL, '2019-10-14 10:25:31', '2019-10-14 10:25:31'),
(556, '1571068322logo.png', 'dashboardImages/setting/1571068322logo.png', NULL, NULL, '2019-10-14 13:52:02', '2019-10-14 13:52:02'),
(557, '1571070014dr-about.JPG', 'dashboardImages/about/1571070014dr-about.JPG', NULL, NULL, '2019-10-14 14:20:15', '2019-10-14 14:20:15'),
(558, '1571140658karmen.jpg', 'dashboardImages/testimonial/1571140658karmen.jpg', NULL, NULL, '2019-10-15 09:57:38', '2019-10-15 09:57:38'),
(559, '1571141498dr-about.JPG', 'dashboardImages/team/1571141498dr-about.JPG', NULL, NULL, '2019-10-15 10:11:38', '2019-10-15 10:11:38'),
(560, '1571150294dr-about.JPG', 'dashboardImages/slider/1571150294dr-about.JPG', 'Dr Mohamed Abou-zeid', NULL, '2019-10-15 12:38:14', '2019-10-15 12:38:14'),
(561, '1571219676dr-about.JPG', 'dashboardImages/openGraph/1571219676dr-about.JPG', NULL, NULL, '2019-10-16 07:54:36', '2019-10-16 07:54:36'),
(562, '1571219739about1.png', 'dashboardImages/openGraph/1571219739about1.png', NULL, NULL, '2019-10-16 07:55:39', '2019-10-16 07:55:39'),
(563, '1571222288smile.jpg', 'dashboardImages/openGraph/1571222288smile.jpg', NULL, NULL, '2019-10-16 08:38:08', '2019-10-16 08:38:08'),
(564, '1571222409dr-about.JPG', 'dashboardImages/openGraph/1571222409dr-about.JPG', NULL, NULL, '2019-10-16 08:40:09', '2019-10-16 08:40:09'),
(565, '1571222443about1.png', 'dashboardImages/openGraph/1571222443about1.png', NULL, NULL, '2019-10-16 08:40:43', '2019-10-16 08:40:43'),
(566, '1571222492contact_home_bg.jpg', 'dashboardImages/openGraph/1571222492contact_home_bg.jpg', NULL, NULL, '2019-10-16 08:41:32', '2019-10-16 08:41:32'),
(567, '1571222536blog-2.png', 'dashboardImages/openGraph/1571222536blog-2.png', NULL, NULL, '2019-10-16 08:42:16', '2019-10-16 08:42:16'),
(568, '1571222595gallery-2.jpg', 'dashboardImages/openGraph/1571222595gallery-2.jpg', NULL, NULL, '2019-10-16 08:43:15', '2019-10-16 08:43:15'),
(569, '1571222614gallery-2.jpg', 'dashboardImages/openGraph/1571222614gallery-2.jpg', NULL, NULL, '2019-10-16 08:43:34', '2019-10-16 08:43:34'),
(570, '1571222657ev.jpg', 'dashboardImages/openGraph/1571222657ev.jpg', NULL, NULL, '2019-10-16 08:44:17', '2019-10-16 08:44:17'),
(571, '15712226852 (1).jpg', 'dashboardImages/openGraph/15712226852 (1).jpg', NULL, NULL, '2019-10-16 08:44:45', '2019-10-16 08:44:45'),
(572, '1571222724karmen.jpg', 'dashboardImages/openGraph/1571222724karmen.jpg', NULL, NULL, '2019-10-16 08:45:24', '2019-10-16 08:45:24'),
(573, '1571222751karmen.jpg', 'dashboardImages/openGraph/1571222751karmen.jpg', NULL, NULL, '2019-10-16 08:45:51', '2019-10-16 08:45:51'),
(574, '1571222788tam_bg.jpg', 'dashboardImages/openGraph/1571222788tam_bg.jpg', NULL, NULL, '2019-10-16 08:46:28', '2019-10-16 08:46:28'),
(575, '15712228091.JPG', 'dashboardImages/openGraph/15712228091.JPG', NULL, NULL, '2019-10-16 08:46:49', '2019-10-16 08:46:49'),
(576, '1571222838member.jpg', 'dashboardImages/openGraph/1571222838member.jpg', NULL, NULL, '2019-10-16 08:47:18', '2019-10-16 08:47:18'),
(577, '1571222859about1.png', 'dashboardImages/openGraph/1571222859about1.png', NULL, NULL, '2019-10-16 08:47:39', '2019-10-16 08:47:39'),
(578, '1571222885dr-about.JPG', 'dashboardImages/openGraph/1571222885dr-about.JPG', NULL, NULL, '2019-10-16 08:48:05', '2019-10-16 08:48:05'),
(579, '1571227348whiteSmile.png', 'dashboardImages/service/1571227348whiteSmile.png', 'ss', NULL, '2019-10-16 10:02:28', '2019-10-16 10:02:28'),
(580, '1571227411white-3.jpg', 'dashboardImages/service/1571227411white-3.jpg', 'fff', NULL, '2019-10-16 10:03:31', '2019-10-16 10:03:31'),
(581, '1571227493white-2.jpg', 'dashboardImages/service/1571227493white-2.jpg', 'jk', NULL, '2019-10-16 10:04:53', '2019-10-16 10:04:53'),
(582, '1571227654white-4.jpg', 'dashboardImages/service/1571227654white-4.jpg', 'key hole surgery', NULL, '2019-10-16 10:07:34', '2019-10-16 10:07:34'),
(583, '1571228388people-2597995_640.jpg', 'dashboardImages/service/1571228388people-2597995_640.jpg', 'key hole surgery', NULL, '2019-10-16 10:19:48', '2019-10-16 10:19:48'),
(584, '1571229106member.jpg', 'dashboardImages/team/1571229106member.jpg', NULL, NULL, '2019-10-16 10:31:46', '2019-10-16 10:31:46');

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

--
-- Table structure for table `message`
--

CREATE TABLE IF NOT EXISTS `message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `phone` varchar(191) NOT NULL,
  `title` varchar(191) DEFAULT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_id` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `message_file_id` (`file_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `offer`
--

CREATE TABLE IF NOT EXISTS `offer` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `image_id` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `offer_image_id` (`image_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `offer`
--

INSERT INTO `offer` (`id`, `image_id`, `created_at`, `updated_at`) VALUES
(2, 403, '2019-09-04 19:57:49', '2019-09-04 19:57:49');

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

--
-- Table structure for table `open_graph`
--

CREATE TABLE IF NOT EXISTS `open_graph` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `og_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `og_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `og_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `og_image` int(10) UNSIGNED DEFAULT NULL,
  `image_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `og_description` text COLLATE utf8mb4_unicode_ci,
  `og_site_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `og_image_id` (`og_image`)
) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `open_graph`
--

INSERT INTO `open_graph` (`id`, `og_title`, `og_type`, `og_url`, `og_image`, `image_url`, `og_description`, `og_site_name`, `created_at`, `updated_at`) VALUES
(6, 'services', NULL, 'services', 563, NULL, NULL, NULL, '2019-08-05 22:00:00', '2019-10-16 08:38:45'),
(28, 'Home', 'video.movie', '/', 564, NULL, 'عيادات متخصصة في مجالات علاج السمنة و السكر - التجميل و الليزر- الجراحة و المناظير - الاسنان و التقويم تحت اشراف نخبة من الاستشاريين بادارة  دكتور احمد النبيل - استاذ الجراحة بطب عين شمس', 'عيادات دكتور محمد أبو زيد', '2019-08-06 22:00:00', '2019-10-16 08:40:09'),
(29, 'About', NULL, 'about', 565, NULL, NULL, NULL, '2019-08-06 22:00:00', '2019-10-16 08:40:43'),
(30, 'Contact', NULL, 'contact', 566, 'https://www.allawyfestival.com/website/img/show/circus.jpeg', NULL, NULL, '2019-08-06 22:00:00', '2019-10-16 08:41:32'),
(31, 'Blog', NULL, 'blog', 567, NULL, NULL, NULL, '2019-08-07 22:00:00', '2019-10-16 08:42:16'),
(59, 'clients', NULL, 'clients', NULL, 'https://www.drahmedelnabil.com/dashboardImages/setting/1567088729Logo-1.png', NULL, NULL, '2019-09-04 22:00:00', '2019-09-04 22:00:00'),
(60, 'album', NULL, 'album', 569, NULL, NULL, NULL, '2019-09-07 22:00:00', '2019-10-16 08:43:34'),
(61, 'reserve', NULL, 'reserve', 570, NULL, NULL, NULL, '2019-09-07 22:00:00', '2019-10-16 08:44:17'),
(68, 'careers', NULL, 'careers', 571, NULL, NULL, NULL, '2019-09-16 22:00:00', '2019-10-16 08:44:45'),
(69, 'branches', NULL, 'branches', 572, NULL, NULL, NULL, '2019-09-16 22:00:00', '2019-10-16 08:45:25'),
(70, 'gallery', NULL, 'gallery', 568, NULL, NULL, NULL, '2019-09-16 22:00:00', '2019-10-16 08:43:15'),
(71, 'testimonial', NULL, 'testimonial', 573, NULL, NULL, NULL, '2019-09-16 22:00:00', '2019-10-16 08:45:51'),
(77, 'Why Us', NULL, 'why-us', 574, NULL, NULL, NULL, '2019-09-17 22:00:00', '2019-10-16 08:46:28'),
(78, 'Policy', NULL, 'policy', 575, NULL, NULL, NULL, '2019-09-17 22:00:00', '2019-10-16 08:46:49'),
(95, 'team', NULL, 'team', 576, NULL, NULL, NULL, '2019-09-21 22:00:00', '2019-10-16 08:47:18'),
(96, 'bio', NULL, 'bio', 577, NULL, NULL, NULL, '2019-09-23 22:00:00', '2019-10-16 08:47:39'),
(105, 'Obesity Clinic - Weight Loss', NULL, 'obesity-clinic-weight-loss', 483, NULL, '<p>&nbsp;</p>\r\n\r\n<p><big><strong><a href=\"https://www.drahmedelnabil.com/service-details/10\">Laparoscopic Sleeve Gastrectomy</a></strong></big></p>\r\n\r\n<p><big><strong><a href=\"https://www.drahmedelnabil.com/service-details/21\">Laparoscopic Minigastric Bypass</a></strong></big></p>\r\n\r\n<p><big><strong>Laparoscopic RYGP</strong></big></p>\r\n\r\n<p><big><strong>Intragastric Ballon</strong></big></p>\r\n\r\n<p><big><strong>Laparoscopic Redo Surgery</strong></big></p>\r\n\r\n<p><big><strong>Laparoscopic Gastric Plication</strong></big></p>\r\n\r\n<p><big><strong>Laparoscopic Gastric Band</strong></big></p>', NULL, '2019-09-24 11:17:04', '2019-09-24 11:35:06'),
(106, 'Obesity Clinic - Reshaping', NULL, 'obesity-clinic-reshaping', 482, NULL, '<p>&nbsp;</p>\r\n\r\n<p><big><strong>4 D VASER&nbsp;</strong></big></p>\r\n\r\n<p><big><strong>Tummy tuck</strong></big></p>\r\n\r\n<p><big><strong>Total body lift</strong></big></p>\r\n\r\n<p><big><strong>Reduction &amp; Augmentation Mammoplasty</strong></big></p>\r\n\r\n<p><big><strong>Gynecomastia treatment</strong></big></p>\r\n\r\n<p>&nbsp;</p>', NULL, '2019-09-24 11:23:29', '2019-09-24 11:23:29'),
(107, 'Cosmotic & Laser Clinic', NULL, 'cosmotic-laser-clinic', 318, NULL, '<p>&nbsp;</p>\r\n\r\n<p><big><strong>Rhinoplasty</strong></big></p>\r\n\r\n<p><big><strong>Face Lift</strong></big></p>\r\n\r\n<p><big><strong>Filler &amp; Botox Injection</strong></big></p>', NULL, '2019-09-24 11:26:28', '2019-10-16 10:04:53'),
(108, 'Key Hole Surgery', NULL, 'surgery', 478, NULL, '<p><big><span dir=\"rtl\"><strong>Laparoscopic repair of GERD &amp; Hiatus Hernia</strong></span></big></p>\r\n\r\n<p><big><span dir=\"rtl\"><strong>Laparoscopic repair of Achalazia</strong></span></big></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>', NULL, '2019-09-24 11:29:17', '2019-10-16 10:07:35'),
(111, 'Laparoscopic Gastric Bypass', NULL, 'laparoscopic-gastric-bypass', 426, 'https://www.drahmedelnabil.com/dashboardImages/slider/1568595599rygp.jpg', 'هي مجموعة من العمليات التي يتم فيها تصغير  حجم المعدة و توصيلها بالامعاء مما يؤدي الى  اختصارو تغيير  مسار مرور الاكل من المعدة الى الامعاء و من هنا جاءت مسمى تحويل المسارو سوف نقوم بشرح العمليات المختلفة', NULL, '2019-09-24 11:30:04', '2019-10-07 14:10:35'),
(112, 'Laparoscopic Sleeve Gastrectomy', NULL, 'laparoscopic-sleeve-gastrectomy', 427, NULL, '<p>Laparoscopic Sleeve Gastrectomy</p>', NULL, '2019-09-24 11:31:53', '2019-09-24 11:31:53'),
(113, 'Intragastric Ballon', NULL, 'intragastric-ballon', 428, NULL, '<p>Intragastric Ballon</p>', NULL, '2019-09-24 11:32:04', '2019-09-24 11:32:04'),
(114, 'Laparoscopic Redo Surgery', NULL, 'laparoscopic-redo-surgery', 432, NULL, '<p>Laparoscopic Redo Surgery</p>', NULL, '2019-09-24 11:32:23', '2019-09-24 11:32:23'),
(116, 'mizapymoqo@mailinator.com', NULL, 'mizapymoqo-at-mailinatorcom', 498, NULL, '<p>Voluptate nostrud co.</p>', NULL, '2019-09-25 06:43:53', '2019-09-25 06:43:53'),
(118, 'Effect of Sleeve Gastrectomy on Esophageal Reflux', NULL, 'effect-of-sleeve-gastrectomy-on-esophageal-reflux', 440, NULL, 'Effect of Sleeve Gastrectomy on Esophageal Reflux', NULL, '2019-09-25 07:08:14', '2019-09-25 08:40:48'),
(119, 'Effect of Laparoscopic Sleeve Gastrectomy on Clinical Hypothyroidism', NULL, 'effect-of-laparoscopic-sleeve-gastrectomy-on-clinical-hypothyroidism', 441, NULL, '<p>Effect of Laparoscopic Sleeve Gastrectomy on Clinical Hypothyroidism</p>', NULL, '2019-09-25 07:09:32', '2019-09-25 07:09:32'),
(121, 'Safety and Efficacy of Laparoscopic sleeve Gastrectomy on Class 1 obesity', NULL, 'safety-and-efficacy-of-laparoscopic-sleeve-gastrectomy-on-class-1-obesity', 442, NULL, '<p>Safety and Efficacy of Laparoscopic sleeve Gastrectomy on Class 1 obesity</p>', NULL, '2019-09-25 07:19:57', '2019-09-25 07:19:57'),
(122, 'Offers', NULL, 'offers', 315, NULL, NULL, NULL, '2019-09-24 22:00:00', '2019-09-24 22:00:00'),
(123, 'Obesity Surgery', NULL, 'obesity-surgery', 515, NULL, '<p>Obesity Surgery</p>', NULL, '2019-10-03 10:44:23', '2019-10-03 10:44:23'),
(124, 'Obesity Surgery', NULL, 'obesity-surgery', 516, NULL, '<p>Obesity Surgery</p>', NULL, '2019-10-03 10:44:42', '2019-10-03 10:44:42'),
(125, 'Obesity Surgery', NULL, 'Obesity Surgery', 517, NULL, '<p>Obesity Surgery</p>', NULL, '2019-10-03 10:45:17', '2019-10-03 10:45:17'),
(126, 'Obesity Surgery', NULL, 'Obesity Surgery', 518, NULL, '<p>Obesity Surgery</p>', NULL, '2019-10-03 10:46:02', '2019-10-03 10:46:02'),
(129, 'Obesity Surgery', NULL, 'Obesity Surgery', 521, NULL, '<p>Obesity Surgery</p>', NULL, '2019-10-03 10:48:22', '2019-10-03 10:48:22'),
(130, 'success story', NULL, 'success-story', 578, NULL, 'success story page', NULL, '2019-10-12 22:00:00', '2019-10-16 08:48:05'),
(131, 'medical tourism', NULL, 'medical-tourism', 561, NULL, 'medical tourism medical tourism medical tourism', NULL, '2019-10-13 03:18:10', '2019-10-16 07:54:36'),
(132, 'pefe@mailinator.net', NULL, 'xuxubil@mailinator.com', 553, NULL, '<p>edw ewfef eferdfvr erfgverdfer erfgvrfgverd</p>', NULL, '2019-10-14 10:08:15', '2019-10-14 10:08:15'),
(133, 'codamogis@mailinator.com', NULL, 'naqib@mailinator.com', 554, NULL, '<p>fgbvfgbv fhbtg n hgn hg nbf hb th jnyjny</p>', NULL, '2019-10-14 10:19:32', '2019-10-14 10:19:32'),
(134, 'wazuji@mailinator.com', NULL, 'pyfiqedy@mailinator.net', 555, NULL, '<p>drfhgbf fhnghj tgjghjhngg thjyhg</p>', NULL, '2019-10-14 10:25:31', '2019-10-14 10:25:31');

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

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

CREATE TABLE IF NOT EXISTS `pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `is_main_page` int(11) DEFAULT NULL,
  `url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `key_words` text COLLATE utf8mb4_unicode_ci,
  `open_graph_id` int(10) DEFAULT NULL,
  `header_code` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `page_open_graph_id` (`open_graph_id`)
) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `pages` (`id`, `is_main_page`, `url`, `name`, `description`, `key_words`, `open_graph_id`, `header_code`, `created_at`, `updated_at`) VALUES
(9, 1, 'services', 'services', NULL, NULL, 6, NULL, '2019-08-05 22:00:00', '2019-08-05 22:00:00'),
(31, 1, '/', 'Home', 'تاسست عيادة دكتور احمد النبيل عام ٢٠١٠ بعد العودة من رحلة التدريب في انجلترا و ايطاليا في مجال جراحات السمنة و المناظير وكان الهدف تقديم خدمة طبية متكاملة تضاهي المعايير الاوروبية  و الامريكية على ارض مصرية حيث ان دكتور احمد النبيل حاصل على زمالات البورد الاوروبي و كلية الجراحين الامريكية و الكلية الملكية للجراحين بانجلترا و تم اختيار اسم ايليت كير بعناية ليكون اسم و شعار في نفس الوقت معبراعن رقي و جودة مستوى الخدمة و الرعاية المقدمة', 'ahmednabil, clinic, elite, dental, egypt', 28, '<script src=\"home ahmed nabil\"></script>', '2019-08-06 22:00:00', '2019-09-25 08:15:09'),
(32, 1, 'about', 'about', NULL, NULL, 29, '<script src=\"\"></script>', '2019-08-06 22:00:00', '2019-09-25 08:03:06'),
(33, 1, 'contact', 'contact', NULL, NULL, 30, NULL, '2019-08-06 22:00:00', '2019-08-06 22:00:00'),
(34, 1, 'blog', 'blog', NULL, NULL, 31, NULL, '2019-08-06 22:00:00', '2019-08-06 22:00:00'),
(62, 1, 'clients', 'clients', NULL, NULL, 70, NULL, '2019-09-04 22:00:00', '2019-09-04 22:00:00'),
(63, 1, 'album', 'album', NULL, NULL, 60, NULL, '2019-09-07 22:00:00', '2019-09-08 05:51:13'),
(64, 1, 'reserve', 'reserve', NULL, NULL, 61, NULL, '2019-09-08 22:00:00', '2019-09-08 22:00:00'),
(65, 1, 'service', 'service', NULL, NULL, 6, NULL, '2019-09-08 22:00:00', '2019-09-08 22:00:00'),
(71, 1, 'careers', 'careers', NULL, NULL, 68, NULL, '2019-09-16 22:00:00', '2019-09-16 22:00:00'),
(72, 1, 'branches', 'branches', NULL, NULL, 69, NULL, '2019-09-16 22:00:00', '2019-09-16 22:00:00'),
(73, 1, 'gallery', 'gallery', NULL, NULL, 70, NULL, '2019-09-16 22:00:00', '2019-09-16 22:00:00'),
(74, 1, 'testimonial', 'testimonial', NULL, NULL, 71, NULL, '2019-09-16 22:00:00', '2019-09-16 22:00:00'),
(80, 1, 'why-us', 'Why Us ? ', NULL, NULL, 77, NULL, '2019-09-17 22:00:00', '2019-09-18 12:17:48'),
(81, 1, 'policy', 'Policy', NULL, NULL, 78, NULL, '2019-09-17 22:00:00', '2019-09-17 22:00:00'),
(98, 1, 'team', 'فريق العمل', NULL, NULL, 95, NULL, '2019-09-21 22:00:00', '2019-09-25 08:10:08'),
(104, NULL, 'obesity-clinic-weight-loss', 'تكميم المعدة', NULL, NULL, 105, NULL, '2019-09-24 11:17:05', '2019-09-25 08:11:01'),
(105, NULL, 'obesity-clinic-reshaping', 'Obesity Clinic - Reshaping', NULL, NULL, 106, NULL, '2019-09-24 11:23:29', '2019-09-24 11:23:29'),
(106, NULL, 'cosmotic-laser-clinic', 'Cosmotic & Laser Clinic', NULL, NULL, 107, NULL, '2019-09-24 11:26:28', '2019-10-16 10:04:53'),
(107, NULL, 'surgery', 'Key Hole Surgery', NULL, NULL, 108, NULL, '2019-09-24 11:29:17', '2019-10-16 10:07:35'),
(110, NULL, 'laparoscopic-gastric-bypass', 'Laparoscopic Gastric Bypass', NULL, NULL, 111, NULL, '2019-09-24 11:30:04', '2019-09-24 11:30:04'),
(111, NULL, 'laparoscopic-sleeve-gastrectomy', 'Laparoscopic Sleeve Gastrectomy', NULL, NULL, 112, NULL, '2019-09-24 11:31:53', '2019-09-24 11:31:53'),
(112, NULL, 'intragastric-ballon', 'Intragastric Ballon', NULL, NULL, 113, NULL, '2019-09-24 11:32:04', '2019-09-24 11:32:04'),
(113, NULL, 'laparoscopic-redo-surgery', 'Laparoscopic Redo Surgery', NULL, NULL, 114, NULL, '2019-09-24 11:32:23', '2019-09-24 11:32:23'),
(115, NULL, 'mizapymoqo-at-mailinatorcom', 'mizapymoqo@mailinator.com', NULL, NULL, 116, NULL, '2019-09-25 06:43:53', '2019-09-25 06:43:53'),
(117, NULL, 'effect-of-sleeve-gastrectomy-on-esophageal-reflux', 'Effect of Sleeve Gastrectomy on Esophageal Reflux', 'Effect of Sleeve Gastrectomy on Esophageal Reflux', NULL, 118, NULL, '2019-09-25 07:08:14', '2019-09-25 08:39:30'),
(118, NULL, 'effect-of-laparoscopic-sleeve-gastrectomy-on-clinical-hypothyroidism', 'Effect of Laparoscopic Sleeve Gastrectomy on Clinical Hypothyroidism', '<p>Effect of Laparoscopic Sleeve Gastrectomy on Clinical Hypothyroidism</p>', NULL, 119, NULL, '2019-09-25 07:09:32', '2019-09-25 07:09:32'),
(120, NULL, 'safety-and-efficacy-of-laparoscopic-sleeve-gastrectomy-on-class-1-obesity', 'Safety and Efficacy of Laparoscopic sleeve Gastrectomy on Class 1 obesity', '<p>Safety and Efficacy of Laparoscopic sleeve Gastrectomy on Class 1 obesity</p>', NULL, 121, NULL, '2019-09-25 07:19:57', '2019-09-25 07:19:57'),
(121, 1, 'bio', 'Bio', NULL, NULL, 96, NULL, '2019-09-24 22:00:00', '2019-09-24 22:00:00'),
(122, 1, 'offers', 'Offers', NULL, NULL, 122, NULL, '2019-09-24 22:00:00', '2019-09-24 22:00:00'),
(123, NULL, 'obesity-surgery', 'Obesity Surgery', '<p>Obesity Surgery</p>', NULL, 123, NULL, '2019-10-03 10:44:23', '2019-10-03 10:44:23'),
(124, NULL, 'obesity-surgery', 'Obesity Surgery', '<p>Obesity Surgery</p>', NULL, 124, NULL, '2019-10-03 10:44:42', '2019-10-03 10:44:42'),
(125, NULL, 'Obesity Surgery', 'Obesity Surgery', '<p>Obesity Surgery</p>', NULL, 125, NULL, '2019-10-03 10:45:17', '2019-10-03 10:45:17'),
(126, NULL, 'Obesity Surgery', 'Obesity Surgery', '<p>Obesity Surgery</p>', NULL, 126, NULL, '2019-10-03 10:46:02', '2019-10-03 10:46:02'),
(129, NULL, 'Obesity Surgery', 'Obesity Surgery', '<p>Obesity Surgery</p>', NULL, 129, NULL, '2019-10-03 10:48:22', '2019-10-03 10:48:22'),
(130, 1, 'success-story', 'success story', NULL, NULL, 130, NULL, '2019-10-12 22:00:00', '2019-10-12 22:00:00'),
(131, 1, 'medical-tourism', '	\r\nmedical tourism', '	\r\nmedical tourism 	\r\nmedical tourism', NULL, 131, NULL, '2019-10-13 03:18:10', '2019-10-13 03:18:10'),
(132, NULL, 'xuxubil@mailinator.com', 'pefe@mailinator.net', '<p>edw ewfef eferdfvr erfgverdfer erfgvrfgverd</p>', NULL, 132, NULL, '2019-10-14 10:08:15', '2019-10-14 10:08:15'),
(133, NULL, 'naqib@mailinator.com', 'codamogis@mailinator.com', '<p>fgbvfgbv fhbtg n hgn hg nbf hb th jnyjny</p>', NULL, 133, NULL, '2019-10-14 10:19:32', '2019-10-14 10:19:32'),
(134, NULL, 'pyfiqedy@mailinator.net', 'wazuji@mailinator.com', '<p>drfhgbf fhnghj tgjghjhngg thjyhg</p>', NULL, 134, NULL, '2019-10-14 10:25:31', '2019-10-14 10:25:31');

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

--
-- Table structure for table `same_as`
--

CREATE TABLE IF NOT EXISTS `same_as` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rel` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_prop` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'sameAs',
  `created_by` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `same_as_created_by` (`created_by`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `same_as`
--

INSERT INTO `same_as` (`id`, `name`, `url`, `rel`, `item_prop`, `created_by`, `created_at`, `updated_at`) VALUES
(4, 'youtube', 'https://www.youtube.com', NULL, 'sameAs', 2, '2019-08-08 04:31:01', '2019-08-14 05:46:46'),
(5, 'FB', 'https://www.facebook.com', NULL, 'sameAs', 2, '2019-08-08 05:11:54', '2019-08-14 05:47:15'),
(6, 'twitter', 'https://www.twitter.com', NULL, 'sameAs', 2, '2019-08-08 05:12:10', '2019-08-14 05:47:47');

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

--
-- Table structure for table `service`
--

CREATE TABLE IF NOT EXISTS `service` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `image_id` int(10) UNSIGNED DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` int(10) UNSIGNED DEFAULT NULL,
  `video_id` int(10) DEFAULT NULL,
  `parent_service_id` int(10) DEFAULT NULL,
  `open_graph_id` int(10) DEFAULT NULL,
  `page_id` int(10) DEFAULT NULL,
  `form_id` int(10) DEFAULT NULL,
  `created_by` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `service_created_by` (`created_by`),
  KEY `service_icon` (`icon`),
  KEY `service_image_id` (`image_id`),
  KEY `parent_service_id` (`parent_service_id`),
  KEY `service_video_id` (`video_id`),
  KEY `service_page_id` (`page_id`),
  KEY `service_open_graph_id` (`open_graph_id`),
  KEY `service_form` (`form_id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `service`
--

INSERT INTO `service` (`id`, `image_id`, `url`, `icon`, `video_id`, `parent_service_id`, `open_graph_id`, `page_id`, `form_id`, `created_by`, `created_at`, `updated_at`) VALUES
(11, 579, 'obesity-clinic-weight-loss', NULL, 20, NULL, 105, 104, 31, 3, '2019-08-19 08:41:55', '2019-10-16 10:02:28'),
(12, 580, 'obesity-clinic-reshaping', NULL, 17, NULL, 106, 105, 32, 3, '2019-08-19 12:10:55', '2019-10-16 10:03:31'),
(16, 581, 'cosmotic-laser-clinic', NULL, NULL, NULL, 107, 106, 33, 3, '2019-08-21 05:28:42', '2019-10-16 10:04:53'),
(17, 583, 'surgery', NULL, NULL, NULL, 108, 107, 34, 3, '2019-08-21 09:37:13', '2019-10-16 10:19:48'),
(21, 426, 'laparoscopic-gastric-bypass', NULL, NULL, 11, 111, 110, 37, 3, '2019-08-30 01:43:13', '2019-10-07 13:25:54'),
(25, 427, 'laparoscopic-sleeve-gastrectomy', NULL, 18, 11, 112, 111, 38, 3, '2019-08-30 05:10:08', '2019-09-24 11:31:53'),
(26, 428, 'intragastric-ballon', NULL, 28, 11, 113, 112, 39, 3, '2019-08-30 05:11:29', '2019-09-24 11:32:04'),
(27, 432, 'laparoscopic-redo-surgery', NULL, NULL, 11, 114, 113, 40, 3, '2019-08-30 05:13:26', '2019-09-24 11:32:23');

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

--
-- Table structure for table `setting`
--

CREATE TABLE IF NOT EXISTS `setting` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `logo` int(10) UNSIGNED NOT NULL,
  `status` int(10) NOT NULL DEFAULT '1',
  `default_lang` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `webiste_logo_image_id` (`logo`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`id`, `logo`, `status`, `default_lang`, `created_at`, `updated_at`) VALUES
(1, 556, 1, 'ar', '2019-08-07 22:00:00', '2019-10-14 13:52:02');

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

--
-- Table structure for table `slider`
--

CREATE TABLE IF NOT EXISTS `slider` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `image_id` int(10) UNSIGNED DEFAULT NULL,
  `video_id` int(10) DEFAULT NULL,
  `url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `slide_created_by` (`created_by`),
  KEY `slide_image_id` (`image_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`id`, `image_id`, `video_id`, `url`, `created_by`, `created_at`, `updated_at`) VALUES
(14, 560, NULL, NULL, 3, '2019-08-30 01:59:41', '2019-10-15 12:38:14'),
(15, 529, NULL, NULL, 3, '2019-08-30 02:04:09', '2019-10-07 14:14:48'),
(16, 528, NULL, 'https://www.drahmedelnabil.com/bio', 3, '2019-08-30 02:11:40', '2019-10-03 13:14:01');

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

--
-- Table structure for table `team`
--

CREATE TABLE IF NOT EXISTS `team` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `image_id` int(10) UNSIGNED DEFAULT NULL,
  `service_id` int(10) DEFAULT NULL,
  `is_ceo` int(10) DEFAULT NULL,
  `created_by` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `team_created_by` (`created_by`),
  KEY `team_image_id` (`image_id`),
  KEY `service_id` (`service_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `team`
--

INSERT INTO `team` (`id`, `image_id`, `service_id`, `is_ceo`, `created_by`, `created_at`, `updated_at`) VALUES
(11, 584, 16, NULL, 3, '2019-09-16 05:26:34', '2019-10-16 10:31:46'),
(14, 559, 11, 1, 3, '2019-09-19 10:21:17', '2019-10-15 10:11:38');

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

--
-- Table structure for table `testimonial`
--

CREATE TABLE IF NOT EXISTS `testimonial` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `image_id` int(10) UNSIGNED DEFAULT NULL,
  `created_by` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `testimonial_created_by` (`created_by`),
  KEY `tetsti_image_id` (`image_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonial`
--

INSERT INTO `testimonial` (`id`, `image_id`, `created_by`, `created_at`, `updated_at`) VALUES
(2, 558, 3, '2019-08-21 07:52:48', '2019-10-15 09:57:38'),
(4, 419, 3, '2019-09-01 04:31:55', '2019-09-16 04:04:12'),
(5, 420, 3, '2019-09-01 04:45:15', '2019-09-16 04:04:36');

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

--
-- Table structure for table `video`
--

CREATE TABLE IF NOT EXISTS `video` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `album_id` int(10) UNSIGNED DEFAULT NULL,
  `created_by` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `video_album_id` (`album_id`),
  KEY `video_created_by` (`created_by`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `video`
--

INSERT INTO `video` (`id`, `url`, `album_id`, `created_by`, `created_at`, `updated_at`) VALUES
(17, 'https://www.youtube.com/embed/BQY98zo8kU0', NULL, NULL, '2019-09-02 11:19:21', '2019-09-24 13:17:42'),
(18, 'https://www.youtube.com/embed/y-2-h8my3v0', NULL, NULL, '2019-09-04 19:42:32', '2019-09-04 19:42:32'),
(20, 'https://www.youtube.com/embed/8UXhnTJlIYo', NULL, NULL, '2019-09-05 13:38:16', '2019-09-05 13:38:16'),
(28, 'https://www.youtube.com/embed/dwyVLx4Q3eI', NULL, NULL, '2019-09-24 06:02:32', '2019-09-24 06:02:32'),
(29, 'https://www.youtube.com/embed/kfhuGZl8Hi0', NULL, NULL, '2019-09-24 06:21:51', '2019-09-24 06:21:51'),
(44, 'https://www.wam.org.au', NULL, NULL, '2019-09-24 10:24:30', '2019-09-24 10:24:30'),
(45, 'https://www.wam.org.au', NULL, NULL, '2019-09-24 10:25:35', '2019-09-24 10:25:35'),
(46, 'https://www.wam.org.au', NULL, NULL, '2019-09-24 10:26:15', '2019-09-24 10:26:15');

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

--
-- Table structure for table `working_days`
--

CREATE TABLE IF NOT EXISTS `working_days` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `working_days`
--

INSERT INTO `working_days` (`id`, `created_at`, `updated_at`) VALUES
(1, '2019-09-01 22:00:00', '2019-09-01 22:00:00');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `about`
--
ALTER TABLE `about`
  ADD CONSTRAINT `about_image_id` FOREIGN KEY (`image_id`) REFERENCES `image` (`id`),
  ADD CONSTRAINT `approach_image_id` FOREIGN KEY (`approach_image_id`) REFERENCES `image` (`id`),
  ADD CONSTRAINT `mission_image_id` FOREIGN KEY (`mission_image_id`) REFERENCES `image` (`id`),
  ADD CONSTRAINT `values_image_id` FOREIGN KEY (`values_image_id`) REFERENCES `image` (`id`),
  ADD CONSTRAINT `vision_image_id` FOREIGN KEY (`vision_image_id`) REFERENCES `image` (`id`);

--
-- Constraints for table `album`
--
ALTER TABLE `album`
  ADD CONSTRAINT `album_created_by_user` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `album_image_id` FOREIGN KEY (`image_id`) REFERENCES `image` (`id`);

--
-- Constraints for table `appointment`
--
ALTER TABLE `appointment`
  ADD CONSTRAINT `appointment_file_id` FOREIGN KEY (`file_id`) REFERENCES `file` (`id`),
  ADD CONSTRAINT `appointment_service_id` FOREIGN KEY (`service_id`) REFERENCES `service` (`id`);

--
-- Constraints for table `blog`
--
ALTER TABLE `blog`
  ADD CONSTRAINT `blog_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `blog_image_id` FOREIGN KEY (`image_id`) REFERENCES `image` (`id`),
  ADD CONSTRAINT `blog_open_graph_id` FOREIGN KEY (`open_graph_id`) REFERENCES `open_graph` (`id`),
  ADD CONSTRAINT `blog_page_id` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`);

--
-- Constraints for table `client`
--
ALTER TABLE `client`
  ADD CONSTRAINT `client_image_id` FOREIGN KEY (`image_id`) REFERENCES `image` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `contact`
--
ALTER TABLE `contact`
  ADD CONSTRAINT `contact_file_id` FOREIGN KEY (`file_id`) REFERENCES `file` (`id`);

--
-- Constraints for table `feature`
--
ALTER TABLE `feature`
  ADD CONSTRAINT `feature_image_id` FOREIGN KEY (`image_id`) REFERENCES `image` (`id`);

--
-- Constraints for table `form`
--
ALTER TABLE `form`
  ADD CONSTRAINT `form_page_id` FOREIGN KEY (`page_id`) REFERENCES `form` (`id`);

--
-- Constraints for table `gallery`
--
ALTER TABLE `gallery`
  ADD CONSTRAINT `gallery_image_id` FOREIGN KEY (`image_id`) REFERENCES `image` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `image`
--
ALTER TABLE `image`
  ADD CONSTRAINT `image_album_id` FOREIGN KEY (`album_id`) REFERENCES `album` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `message`
--
ALTER TABLE `message`
  ADD CONSTRAINT `message_file_id` FOREIGN KEY (`file_id`) REFERENCES `file` (`id`);

--
-- Constraints for table `offer`
--
ALTER TABLE `offer`
  ADD CONSTRAINT `offer_image_id` FOREIGN KEY (`image_id`) REFERENCES `image` (`id`);

--
-- Constraints for table `open_graph`
--
ALTER TABLE `open_graph`
  ADD CONSTRAINT `open_graph_image_id` FOREIGN KEY (`og_image`) REFERENCES `image` (`id`);

--
-- Constraints for table `pages`
--
ALTER TABLE `pages`
  ADD CONSTRAINT `page_open_graph_id` FOREIGN KEY (`open_graph_id`) REFERENCES `open_graph` (`id`);

--
-- Constraints for table `same_as`
--
ALTER TABLE `same_as`
  ADD CONSTRAINT `same_as_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `service`
--
ALTER TABLE `service`
  ADD CONSTRAINT `parent_service_id` FOREIGN KEY (`parent_service_id`) REFERENCES `service` (`id`),
  ADD CONSTRAINT `service_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `service_form` FOREIGN KEY (`form_id`) REFERENCES `form` (`id`),
  ADD CONSTRAINT `service_icon` FOREIGN KEY (`icon`) REFERENCES `image` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `service_image_id` FOREIGN KEY (`image_id`) REFERENCES `image` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `service_open_graph_id` FOREIGN KEY (`open_graph_id`) REFERENCES `open_graph` (`id`),
  ADD CONSTRAINT `service_page_id` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`),
  ADD CONSTRAINT `service_video_id` FOREIGN KEY (`video_id`) REFERENCES `video` (`id`);

--
-- Constraints for table `setting`
--
ALTER TABLE `setting`
  ADD CONSTRAINT `logo_image_id` FOREIGN KEY (`logo`) REFERENCES `image` (`id`);

--
-- Constraints for table `slider`
--
ALTER TABLE `slider`
  ADD CONSTRAINT `slider_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `slider_image_id` FOREIGN KEY (`image_id`) REFERENCES `image` (`id`);

--
-- Constraints for table `team`
--
ALTER TABLE `team`
  ADD CONSTRAINT `service_id` FOREIGN KEY (`service_id`) REFERENCES `service` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `team_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `team_image_id` FOREIGN KEY (`image_id`) REFERENCES `image` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `testimonial`
--
ALTER TABLE `testimonial`
  ADD CONSTRAINT `testimonial_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `tetsti_image_id` FOREIGN KEY (`image_id`) REFERENCES `image` (`id`);

--
-- Constraints for table `video`
--
ALTER TABLE `video`
  ADD CONSTRAINT `video_album_id` FOREIGN KEY (`album_id`) REFERENCES `album` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `video_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

