-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Oct 16, 2019 at 01:34 PM
-- Server version: 5.7.26
-- PHP Version: 7.3.5

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `abouHagar_en`
--

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

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

DROP TABLE IF EXISTS `about`;
CREATE TABLE IF NOT EXISTS `about` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `about_id` int(10) NOT NULL,
  `mission` text COLLATE utf8mb4_unicode_ci,
  `vision` text COLLATE utf8mb4_unicode_ci,
  `value` text COLLATE utf8mb4_unicode_ci,
  `approach` text COLLATE utf8mb4_unicode_ci,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `about_ar_id` (`about_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `about` (`id`, `about_id`, `mission`, `vision`, `value`, `approach`, `description`, `created_at`, `updated_at`) VALUES
(1, 1, '<p><big>To provide evidence based services, best competitive prices in the private medical sector comapred to the quality provided.</big></p>', '<p><small><big>To be the best medical center in Egypt &amp; Middle East and to be the medical tourism destination for our clinets from all over the world.</big></small></p>', '<p><big>A.Prof of Surgery, consultant of obesity &amp; laparoscopic surgery, Ain Shams Univerity, Egypt.Locum Consultant of Surgery, HSE Ireland.</big></p>', NULL, '<p><big>Specialized clinics founded by Prof Mohamed Abou-zeid in 2010. Started by one clinic Elite Care -Obesity Center and after gaining popularity and successful outcomes and due to increasing trust of our clients we decided to provide quality evidence base services in the following fields: weight loss surgery, key hole surgery, reshaping and cosmotic surgery, breast surgery, vascular surgery, dental clinic. All clinics run&nbsp;</big></p>', '2019-08-19 22:00:00', '2019-10-15 10:20:25');

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

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

DROP TABLE IF EXISTS `album`;
CREATE TABLE IF NOT EXISTS `album` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `album_id` int(10) UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `album_id_ar` (`album_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `album` (`id`, `album_id`, `title`, `created_at`, `updated_at`) VALUES
(13, 19, 'perfect health', '2019-10-13 08:13:11', '2019-10-13 08:13:11'),
(14, 20, 'success-stories', '2019-10-13 12:11:29', '2019-10-13 12:11:29'),
(15, 21, 'medical-tourism', '2019-10-13 13:33:47', '2019-10-13 13:33:47');

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

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

DROP TABLE IF EXISTS `blog`;
CREATE TABLE IF NOT EXISTS `blog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `blog_id` int(10) NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sub_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `body` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `blog_id_ar` (`blog_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `blog` (`id`, `blog_id`, `title`, `sub_title`, `body`, `created_at`, `updated_at`) VALUES
(2, 2, 'Effect of Sleeve Gastrectomy on Esophageal Reflux', NULL, '<p>Effect of Sleeve Gastrectomy on Esophageal Reflux</p>', '2019-08-21 11:43:21', '2019-09-25 07:12:05'),
(3, 3, 'Effect of Laparoscopic Sleeve Gastrectomy on Clinical Hypothyroidism', NULL, '<p>Effect of Laparoscopic Sleeve Gastrectomy on Clinical Hypothyroidism</p>', '2019-08-30 05:47:09', '2019-09-25 07:09:33'),
(4, 4, 'Safety and Efficacy of Laparoscopic sleeve Gastrectomy on Class 1 obesity', NULL, '<p>Safety and Efficacy of Laparoscopic sleeve Gastrectomy on Class 1 obesity</p>', '2019-08-30 05:53:48', '2019-09-25 07:19:57'),
(10, 14, 'Obesity Surgery', NULL, '<p>Obesity Surgery</p>', '2019-10-03 10:48:22', '2019-10-03 10:48:22'),
(11, 15, 'pefe@mailinator.net', NULL, '<p>edw ewfef eferdfvr erfgverdfer erfgvrfgverd</p>', '2019-10-14 10:08:15', '2019-10-14 10:08:15'),
(12, 16, 'codamogis@mailinator.com', NULL, '<p>fgbvfgbv fhbtg n hgn hg nbf hb th jnyjny</p>', '2019-10-14 10:19:32', '2019-10-14 10:19:32'),
(13, 17, 'wazuji@mailinator.com', NULL, '<p>drfhgbf fhnghj tgjghjhngg thjyhg</p>', '2019-10-14 10:25:31', '2019-10-14 10:25:31');

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

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

DROP TABLE IF EXISTS `branch`;
CREATE TABLE IF NOT EXISTS `branch` (
  `branch_id` int(11) DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  KEY `fk_branch_branchEn` (`branch_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `branch` (`branch_id`, `name`, `address`) VALUES
(1, '6TH OF OCTOBERBR', '391 neighborhood 2 – first district – 6 October – Giza – Egypt.'),
(2, 'HELIOPOLIS BRANCH', '25 Asmaa Fahmy Street, Off El Nozha Street.El Mashrabeya Bldg. Floor 8,Nasr City, Cairo Egypt'),
(3, 'fsfsdff', 'fe fd dfdf df dfdf d d dv v d ed f rd v v'),
(5, 'viguw@mailinator.net', 'fyxi@mailinator.com');

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

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

DROP TABLE IF EXISTS `client`;
CREATE TABLE IF NOT EXISTS `client` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `client_id` int(10) NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `client_ar_id` (`client_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

DROP TABLE IF EXISTS `feature`;
CREATE TABLE IF NOT EXISTS `feature` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `feature_id` int(10) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `feature_ar_parent` (`feature_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `feature` (`id`, `feature_id`, `title`, `slug`, `description`, `created_at`, `updated_at`) VALUES
(7, 1, 'teeth whitening', 'teeth whiteningm', 'Quaerat qui corrupti', '2019-10-13 09:49:34', '2019-10-13 10:08:55'),
(8, 2, 'cleaning of teeth', 'cleaning of teeth', 'cleaning of teeth cleaning of teeth cleaning of teeth', '2019-10-13 09:50:36', '2019-10-13 10:10:31');

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

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

DROP TABLE IF EXISTS `offer`;
CREATE TABLE IF NOT EXISTS `offer` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `offer_id` int(10) UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `offer_ar_id` (`offer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

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

INSERT INTO `offer` (`id`, `offer_id`, `title`, `body`, `created_at`, `updated_at`) VALUES
(2, 2, 'offers all over the year', 'follow up our offers all over the year', '2019-09-04 19:57:49', '2019-09-04 20:01:14');

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

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

DROP TABLE IF EXISTS `service`;
CREATE TABLE IF NOT EXISTS `service` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `service_id` int(10) NOT NULL,
  `slug` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `second_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `second_description` text COLLATE utf8mb4_unicode_ci,
  `third_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `third_description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `service_ar_id` (`service_id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `service` (`id`, `service_id`, `slug`, `title`, `description`, `second_title`, `second_description`, `third_title`, `third_description`, `created_at`, `updated_at`) VALUES
(8, 11, 'Available services', 'Obesity Clinic - Weight Loss', '<p>sfsd efgdgrf hgfhfhfgh</p>\r\n\r\n<p>.rgrtytyh thtr tr h rgr</p>\r\n\r\n<p>gt</p>\r\n\r\n<p>g rththjyjy</p>', NULL, NULL, NULL, NULL, '2019-08-19 08:41:55', '2019-10-16 10:02:28'),
(9, 12, 'Available Services', 'Obesity Clinic - Reshaping', '<p>fmkr&#39; vffmkf lf fklnfjf&#39;u spp9 rgfj gi]&#39;dkldz</p>\r\n\r\n<p>&nbsp;</p>', NULL, NULL, NULL, NULL, '2019-08-19 12:10:55', '2019-10-16 10:03:31'),
(13, 16, 'Available Services', 'Cosmotic & Laser Clinic', '<p>abm , las vegas las vegas</p>', NULL, NULL, NULL, NULL, '2019-08-21 05:28:42', '2019-10-16 10:04:53'),
(14, 17, 'Available Services', 'Surgery', '<p>dfvff gr grepjgird pejfldksvlkfd mfdv,fd lfdm.d, fd</p>\r\n\r\n<p>&nbsp;</p>', NULL, NULL, NULL, NULL, '2019-08-21 09:37:13', '2019-10-16 10:19:48'),
(18, 21, 'Gastric Bypass', 'Laparoscopic Gastric Bypass', '<p><big><strong>Laparoscopic RY Gastric Bypass</strong></big></p>\r\n\r\n<p><big><strong>Laparoscopic Minigastric Bypass</strong></big></p>\r\n\r\n<p><big><strong>Laparoscopic Single Anastomosis Sleeve Ileal&nbsp;Bypass (SASI)</strong></big></p>\r\n\r\n<p><big><strong>Laparoscopic&nbsp; Single Anastomosis Duodeno-&nbsp;Ileal&nbsp;Bypass (SADI)</strong></big></p>', NULL, NULL, NULL, NULL, '2019-08-30 01:43:13', '2019-10-07 13:29:40'),
(22, 25, 'Laparoscopic Sleeve Gastrectomy', 'Laparoscopic Sleeve Gastrectomy', '<p>Laparoscopic Sleeve Gastrectomy</p>', NULL, NULL, NULL, NULL, '2019-08-30 05:10:08', '2019-10-02 03:47:30'),
(23, 26, 'Intragastric Ballon', 'Intragastric Ballon', '<p>Intragastric Ballon</p>', NULL, NULL, NULL, NULL, '2019-08-30 05:11:29', '2019-10-02 02:54:43'),
(24, 27, 'Laparoscopic Redo Surgery', 'Laparoscopic Redo Surgery', '<p>Laparoscopic Redo Surgery</p>', NULL, NULL, NULL, NULL, '2019-08-30 05:13:26', '2019-10-02 03:39:55');

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

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

DROP TABLE IF EXISTS `setting`;
CREATE TABLE IF NOT EXISTS `setting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `setting_id` int(10) NOT NULL,
  `website_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `website_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `setting_ar_id` (`setting_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `setting` (`id`, `setting_id`, `website_name`, `website_description`, `created_at`, `updated_at`) VALUES
(1, 1, 'Perfect Health Dr.Mohamed Abou-zeid', 'Elite Care are specialized clinics in Obesity, Cosmotic & Laser, Surgery& Endoscopy, and Dental surgery, delivered by qualified consultants under supervision of Dr Ahmed Elnabil - professor of surgery, Ain Shams University.', '2019-08-07 22:00:00', '2019-10-15 10:30:32');

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

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

DROP TABLE IF EXISTS `slider`;
CREATE TABLE IF NOT EXISTS `slider` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `slide_id` int(10) NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sub_title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `button` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `slide_id_ar` (`slide_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `slider` (`id`, `slide_id`, `title`, `sub_title`, `description`, `button`, `created_at`, `updated_at`) VALUES
(10, 14, 'Dr Mohamed Abou-zeid', NULL, 'Expert with more than 3000 cases', 'Know more', '2019-08-30 01:59:41', '2019-10-15 14:36:39'),
(11, 15, 'More than one specialized clinic', NULL, 'High quality evidence based service with best price', 'know more', '2019-08-30 02:04:09', '2019-10-07 14:14:48'),
(12, 16, 'Medical Tourism', NULL, 'Medical Tourism', 'Read More', '2019-08-30 02:11:40', '2019-10-04 01:20:50');

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

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

DROP TABLE IF EXISTS `team`;
CREATE TABLE IF NOT EXISTS `team` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `member_id` int(10) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `job_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `member_ar_id` (`member_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

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

INSERT INTO `team` (`id`, `member_id`, `name`, `job_title`, `description`, `created_at`, `updated_at`) VALUES
(6, 11, 'Dr bgbfbfc', 'Obesity  & Cosmetic Surgery', 'Obesity  & Cosmetic Surgery', '2019-09-16 05:26:34', '2019-10-16 10:31:46'),
(7, 14, 'Dr Mohamed Abou-zeid', 'Prof of General Surgery & Consultant of Obesity and laparoscopic Surgery', 'Prof of General Surgery & Consultant of Obesity and laparoscopic Surgery', '2019-09-19 10:21:17', '2019-10-15 10:11:38');

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

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

DROP TABLE IF EXISTS `testimonial`;
CREATE TABLE IF NOT EXISTS `testimonial` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `testimonial_id` int(10) NOT NULL,
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `text` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `testimonial_id_ar` (`testimonial_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `testimonial` (`id`, `testimonial_id`, `username`, `text`, `created_at`, `updated_at`) VALUES
(1, 2, 'karmin  Ali-Egypt', 'I lost 100 kg after Gastric bypass, my life changed completely, all my obesity related troubles have resolved, I am enjoying my life for 7 years now after surgery without any troubles, indeed grateful for prof Mohamed Abou-zeid.', '2019-08-21 07:52:49', '2019-10-15 09:58:18'),
(3, 4, 'Mohamed - Saudi Arabia', 'I have been refused to be operated by many medical center in KSA, due to my high BMI was 68, my weight was 185, I did sleeve gastrectomy by Dr Mohamed Abou-zeid, now my weight 75kg, I highly recommend this center.', '2019-09-01 04:31:55', '2019-10-15 10:06:06'),
(4, 5, 'Mrs Rania - Egypt', 'I underwent earlier open VBG and I lost only 30 kg from 160 down to 130, I was disappointed, till I met Dr Mohamed Abou-zeid and I had key hole surgery minigastric bypass to overcome my failed VBG, now my weight around 75-80.', '2019-09-01 04:45:15', '2019-10-15 10:07:22');

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

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

DROP TABLE IF EXISTS `working_days`;
CREATE TABLE IF NOT EXISTS `working_days` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `working_days_id` int(10) UNSIGNED NOT NULL,
  `sat` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sun` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mon` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tus` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wed` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thu` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fri` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `working_days_ar` (`working_days_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

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

INSERT INTO `working_days` (`id`, `working_days_id`, `sat`, `sun`, `mon`, `tus`, `wed`, `thu`, `fri`, `created_at`, `updated_at`) VALUES
(1, 1, '1 pm  - 10 PM', '1 pm  - 10 PM', '1 pm  - 10 PM', '1 pm  - 10 PM', '1 pm  - 10 PM', 'closed', 'closed', '2019-09-01 22:00:00', '2019-09-05 13:20:52');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `about`
--
ALTER TABLE `about`
  ADD CONSTRAINT `about_ar_id` FOREIGN KEY (`about_id`) REFERENCES `abouHagar`.`about` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

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

--
-- Constraints for table `blog`
--
ALTER TABLE `blog`
  ADD CONSTRAINT `blog_id_ar` FOREIGN KEY (`blog_id`) REFERENCES `abouHagar`.`blog` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `branch`
--
ALTER TABLE `branch`
  ADD CONSTRAINT `fk_branch_branchEn` FOREIGN KEY (`branch_id`) REFERENCES `abouHagar`.`branch` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `client`
--
ALTER TABLE `client`
  ADD CONSTRAINT `client_ar_id` FOREIGN KEY (`client_id`) REFERENCES `abouHagar`.`client` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `feature`
--
ALTER TABLE `feature`
  ADD CONSTRAINT `feature_ar_parent` FOREIGN KEY (`feature_id`) REFERENCES `abouHagar`.`feature` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `offer`
--
ALTER TABLE `offer`
  ADD CONSTRAINT `offer_ar_id` FOREIGN KEY (`offer_id`) REFERENCES `abouHagar`.`offer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `service`
--
ALTER TABLE `service`
  ADD CONSTRAINT `service_ar_id` FOREIGN KEY (`service_id`) REFERENCES `abouHagar`.`service` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `setting`
--
ALTER TABLE `setting`
  ADD CONSTRAINT `setting_ar_id` FOREIGN KEY (`setting_id`) REFERENCES `abouHagar`.`setting` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `slider`
--
ALTER TABLE `slider`
  ADD CONSTRAINT `slide_id_ar` FOREIGN KEY (`slide_id`) REFERENCES `abouHagar`.`slider` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `team`
--
ALTER TABLE `team`
  ADD CONSTRAINT `member_ar_id` FOREIGN KEY (`member_id`) REFERENCES `abouHagar`.`team` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `testimonial`
--
ALTER TABLE `testimonial`
  ADD CONSTRAINT `testimonial_id_ar` FOREIGN KEY (`testimonial_id`) REFERENCES `abouHagar`.`testimonial` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `working_days`
--
ALTER TABLE `working_days`
  ADD CONSTRAINT `working_days_ar` FOREIGN KEY (`working_days_id`) REFERENCES `abouHagar`.`working_days` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
