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

START TRANSACTION;



--
-- Database: `raintak`
--

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

--
-- Table structure for table `abouts`
--

CREATE TABLE `abouts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `name_ar` varchar(255) NOT NULL,
  `title_ar` varchar(255) DEFAULT NULL,
  `description_ar` text DEFAULT NULL,
  `saudi_egypt` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `cover` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `abouts`
--

INSERT INTO `abouts` (`id`, `name`, `title`, `description`, `name_ar`, `title_ar`, `description_ar`, `saudi_egypt`, `status`, `cover`, `created_at`, `updated_at`) VALUES
(1, 'nldnl', 'sdlkndslk', 'sdnldnsv', 'sdvjbdsjl', 'sdvnldvsdjsb', 'skdvnlk', 1, 1, 'nldnl.png', '2024-12-23 10:45:08', '2024-12-23 09:04:41');

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

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

CREATE TABLE `blogs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `name_ar` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `title_ar` varchar(255) DEFAULT NULL,
  `video` varchar(255) DEFAULT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `description_ar` text DEFAULT NULL,
  `featured` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `saudi_egypt` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blogs`
--

INSERT INTO `blogs` (`id`, `name`, `name_ar`, `title`, `title_ar`, `video`, `slug`, `description`, `description_ar`, `featured`, `status`, `saudi_egypt`, `created_at`, `updated_at`) VALUES
(2, 'ouuooguo', 'jkbkjbkj', ';injpojjop', 'hbkbkh', 'https://www.youtube.com/watch?v=jwWpTAXu-Sg', 'ouuooguo', 'iihoihiooi', 'lnihiioihlkl', 1, 1, 1, '2024-12-22 23:24:40', '2024-12-22 23:24:40');

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `address` varchar(255) NOT NULL,
  `url_facebook` varchar(255) DEFAULT NULL,
  `url_x` varchar(255) DEFAULT NULL,
  `url_linkedin` varchar(255) DEFAULT NULL,
  `url_instagram` varchar(255) DEFAULT NULL,
  `url_youtube` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `saudi_egypt` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` (`id`, `email`, `phone`, `address`, `url_facebook`, `url_x`, `url_linkedin`, `url_instagram`, `url_youtube`, `status`, `saudi_egypt`, `created_at`, `updated_at`) VALUES
(1, 'uohohoo', '04165155', 'lihoihioh', NULL, NULL, NULL, NULL, NULL, 0, 0, '2024-12-23 01:27:46', '2024-12-22 23:55:55'),
(2, 'ouhiohi', '056165116', 'ihnoihio', NULL, NULL, NULL, NULL, NULL, 1, 1, '2024-12-23 01:27:46', '2024-12-23 01:27:46');

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

--
-- Table structure for table `developers`
--

CREATE TABLE `developers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `job_title` varchar(255) NOT NULL,
  `cover` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `url_facebook` varchar(255) DEFAULT NULL,
  `url_x` varchar(255) DEFAULT NULL,
  `saudi_egypt` tinyint(1) NOT NULL DEFAULT 0,
  `url_linkedin` varchar(255) DEFAULT NULL,
  `url_pinterest` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `developers`
--

INSERT INTO `developers` (`id`, `name`, `job_title`, `cover`, `status`, `url_facebook`, `url_x`, `saudi_egypt`, `url_linkedin`, `url_pinterest`, `created_at`, `updated_at`) VALUES
(1, 'sss-003 gray', 'DKSNKJBSD', 'sss-003-gray.png', 1, 'https://www.facebook.com/', 'https://x.com/', 1, 'https://www.linkedin.com/', 'omorkvp', '2024-12-23 09:48:34', '2024-12-23 13:40:08');

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `name_ar` varchar(255) NOT NULL,
  `description_ar` text DEFAULT NULL,
  `saudi_egypt` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` (`id`, `name`, `description`, `name_ar`, `description_ar`, `saudi_egypt`, `status`, `created_at`, `updated_at`) VALUES
(1, 'nlljb', 'jb.vvhgfcf', 'jvhj.vvvvvvj', 'kb.jhjvtuftyk', 1, 1, '2024-12-23 09:18:44', '2024-12-23 09:24:59');

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

--
-- Table structure for table `faq_abouts`
--

CREATE TABLE `faq_abouts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `name_ar` varchar(255) NOT NULL,
  `ratio` varchar(255) NOT NULL,
  `about_id` bigint(20) UNSIGNED NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faq_abouts`
--

INSERT INTO `faq_abouts` (`id`, `name`, `name_ar`, `ratio`, `about_id`, `status`, `created_at`, `updated_at`) VALUES
(1, ';knmklnl', 'knlllb', '55', 1, 1, '2024-12-24 09:42:04', '2024-12-24 09:47:42');

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

--
-- Table structure for table `mains`
--

CREATE TABLE `mains` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `name_ar` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `title_ar` varchar(255) NOT NULL,
  `cover` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `description_ar` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `saudi_egypt` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mains`
--

INSERT INTO `mains` (`id`, `name`, `name_ar`, `title`, `title_ar`, `cover`, `description`, `description_ar`, `status`, `saudi_egypt`, `created_at`, `updated_at`) VALUES
(1, 'شهاب محمد', 'نصائح غذائية لحياة صحية أفضل', 'nkjjbkkj', 'nlknljnjk', 'shhab-mhmd.png', 'knllbkj', 'bkbbkjbjk', 1, 1, '2024-12-22 21:23:25', '2024-12-22 21:40:26'),
(2, 'JKBKJBK', 'LNKLL', 'JNBJKBK', 'JNK', 'jkbkjbk.png', 'JLBKJBK', 'LJBJ KJB', 1, 0, '2024-12-26 21:37:01', '2024-12-26 21:37:01');

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

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

CREATE TABLE `media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_type` varchar(255) NOT NULL,
  `file_size` varchar(255) NOT NULL,
  `file_status` varchar(255) NOT NULL,
  `file_sort` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `mediable_id` bigint(20) UNSIGNED NOT NULL,
  `mediable_type` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `media` (`id`, `file_name`, `file_type`, `file_size`, `file_status`, `file_sort`, `mediable_id`, `mediable_type`, `created_at`, `updated_at`) VALUES
(1, 'isdnvjkknjs_1734914391_1.jpeg', 'image/jpeg', '43940', '1', 1, 3, 'App\\Models\\Projects', '2024-12-22 22:39:51', '2024-12-22 22:39:51'),
(2, 'isdnvjkknjs_1734914391_2.jpeg', 'image/jpeg', '43940', '1', 2, 3, 'App\\Models\\Projects', '2024-12-22 22:39:51', '2024-12-22 22:39:51'),
(5, 'ouuooguo_1734917080_1.png', 'image/png', '574', '1', 1, 2, 'App\\Models\\Blogs', '2024-12-22 23:24:40', '2024-12-22 23:24:40');

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

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

CREATE TABLE `messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `messages` (`id`, `name`, `email`, `phone`, `message`, `created_at`, `updated_at`) VALUES
(1, 'dmvklnsdl', 'dkslnklds', '0320020202', 'ojpjrggojpbepjrpb', '2024-12-23 10:38:46', '2024-12-23 10:38:46'),
(2, 'sdjlknkjdsn', 'shehab9113@gmail.com', '0102135233', 'dnv.jbuvaud;b.j kj ke lekn;lnsvlknldknlndvidiewovurv', '2024-12-26 15:12:28', '2024-12-26 15:12:28'),
(3, 'sdjlknkjdsn', 'shehab9113@gmail.com', '0102135233', 'dnv.jbuvaud;b.j kj ke lekn;lnsvlknldknlndvidiewovurv', '2024-12-26 21:23:43', '2024-12-26 21:23:43'),
(4, 'sdjlknkjdsn', 'shehab9113@gmail.com', '0102135233', 'dnv.jbuvaud;b.j kj ke lekn;lnsvlknldknlndvidiewovurv', '2024-12-26 21:24:27', '2024-12-26 21:24:27');

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2024_12_21_083500_create_admins_table', 1),
(6, '2024_12_21_083506_create_mains_table', 1),
(7, '2024_12_21_083640_create_sections_table', 1),
(8, '2024_12_21_083840_create_blogs_table', 1),
(9, '2024_12_21_084026_create_abouts_table', 1),
(10, '2024_12_21_084103_create_faq_abouts_table', 1),
(11, '2024_12_21_084151_create_developers_table', 1),
(12, '2024_12_21_084315_create_messages_table', 1),
(13, '2024_12_21_084334_create_projects_table', 1),
(14, '2024_12_21_084350_create_media_table', 1),
(15, '2024_12_21_084604_create_revies_table', 1),
(16, '2024_12_21_084646_create_contacts_table', 1),
(17, '2024_12_21_084755_create_faqs_table', 1),
(18, '2024_12_21_105256_create_packages_table', 1),
(19, '2024_12_21_105308_create_packagedetails_table', 1),
(20, '2024_12_26_075709_create_visitors_table', 2),
(21, '2024_12_26_231049_create_notifications_table', 3);

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` char(36) NOT NULL,
  `type` varchar(255) NOT NULL,
  `notifiable_type` varchar(255) NOT NULL,
  `notifiable_id` bigint(20) UNSIGNED NOT NULL,
  `data` text NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `type`, `notifiable_type`, `notifiable_id`, `data`, `read_at`, `created_at`, `updated_at`) VALUES
('92a15fe8-ad78-4d16-917f-bdda0faf8f9a', 'App\\Notifications\\DashboardNotification', 'App\\Models\\Admins', 1, '{\"message\":\"\\u0644\\u062f\\u064a\\u0643 \\u0625\\u0634\\u0639\\u0627\\u0631 \\u062c\\u062f\\u064a\\u062f \\u062a\\u0642\\u064a\\u0645\\u0627\\u062a  \\u0627\\u0644\\u0637\\u0628\\u064a\\u0628\",\"url\":\"http:\\/\\/127.0.0.1:8000\\/admin\\/support\\/4\"}', '2024-12-26 21:24:47', '2024-12-26 21:24:29', '2024-12-26 21:24:47');

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

--
-- Table structure for table `packagedetails`
--

CREATE TABLE `packagedetails` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `name_ar` varchar(255) NOT NULL,
  `package_id` bigint(20) UNSIGNED NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `packagedetails`
--

INSERT INTO `packagedetails` (`id`, `name`, `name_ar`, `package_id`, `status`, `created_at`, `updated_at`) VALUES
(2, 'jbkkbb', 'نلاتنلاتن', 1, 1, '2024-12-24 05:55:00', '2024-12-24 05:55:00'),
(3, 'مىم', 'jkbk', 2, 1, '2024-12-24 05:58:49', '2024-12-24 05:58:49'),
(6, 'mlkn', ';m;knkln', 2, 1, '2024-12-26 21:04:08', '2024-12-26 21:04:08');

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

--
-- Table structure for table `packages`
--

CREATE TABLE `packages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `name_ar` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `title_ar` varchar(255) DEFAULT NULL,
  `saudi_egypt` tinyint(1) NOT NULL DEFAULT 0,
  `price_month` decimal(8,2) NOT NULL,
  `price_yearly` decimal(8,2) NOT NULL,
  `price_month_before` decimal(8,2) DEFAULT NULL,
  `price_yearly_before` decimal(8,2) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `packages`
--

INSERT INTO `packages` (`id`, `name`, `name_ar`, `title`, `title_ar`, `saudi_egypt`, `price_month`, `price_yearly`, `price_month_before`, `price_yearly_before`, `status`, `created_at`, `updated_at`) VALUES
(1, 'v,jh,vhj,', 'علازناررلت', 'cgmcg', 'روالا', 1, 70.00, 200.00, 100.00, 250.00, 1, '2024-12-23 16:12:57', '2024-12-23 16:12:57'),
(2, 'شهاب محمد', 'الطب العام', NULL, NULL, 1, 30.00, 50.00, NULL, 30.00, 0, '2024-12-24 05:32:31', '2024-12-24 05:43:36');

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

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

CREATE TABLE `projects` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `name_ar` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `title_ar` varchar(255) DEFAULT NULL,
  `price` decimal(8,2) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `featured` tinyint(1) NOT NULL DEFAULT 0,
  `description` text DEFAULT NULL,
  `description_ar` text DEFAULT NULL,
  `saudi_egypt` tinyint(1) NOT NULL DEFAULT 0,
  `url` varchar(255) DEFAULT NULL,
  `price_abefore` decimal(8,2) DEFAULT NULL,
  `section_id` bigint(20) UNSIGNED NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `projects` (`id`, `name`, `name_ar`, `title`, `title_ar`, `price`, `slug`, `featured`, `description`, `description_ar`, `saudi_egypt`, `url`, `price_abefore`, `section_id`, `status`, `created_at`, `updated_at`) VALUES
(3, 'isdnvjkknjs', 'الطب العام', 'dsknkd', 'نصائح لنظام غذائي متوازن', 20.00, 'isdnvjkknjs', 1, 'sdknlknibnopvrnven', 'vkremlkngfrenierion', 1, 'http://certifiedhacker.com', 80.00, 2, 1, '2024-12-22 22:39:51', '2024-12-22 23:00:07');

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

--
-- Table structure for table `revies`
--

CREATE TABLE `revies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `message` text NOT NULL,
  `message_ar` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `first_name` varchar(255) NOT NULL,
  `rating` tinyint(3) UNSIGNED DEFAULT 1,
  `job_title` varchar(255) DEFAULT NULL,
  `cover` varchar(255) DEFAULT NULL,
  `saudi_egypt` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `revies`
--

INSERT INTO `revies` (`id`, `message`, `message_ar`, `status`, `first_name`, `rating`, `job_title`, `cover`, `saudi_egypt`, `created_at`, `updated_at`) VALUES
(2, 'lknjlbkjb.j', 'jvjvjv', 1, 'shehabhjc', 2, 'DKSNKJBSD', 'shehabhjc.png', 1, '2024-12-24 13:57:13', '2024-12-24 13:57:13');

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

--
-- Table structure for table `sections`
--

CREATE TABLE `sections` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `name_ar` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `title_ar` varchar(255) DEFAULT NULL,
  `cover` varchar(255) DEFAULT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `description_ar` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `saudi_egypt` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sections`
--

INSERT INTO `sections` (`id`, `name`, `name_ar`, `title`, `title_ar`, `cover`, `slug`, `description`, `description_ar`, `status`, `saudi_egypt`, `created_at`, `updated_at`) VALUES
(2, 'ks;fmlk', 'الطب العام', 'jbkjbjkb', 'inikihoiho', 'ksfmlk.png', 'ks-fmlk', 'ksnflkngvlkd', 'lkandflknfdl', 1, 1, '2024-12-22 21:54:07', '2024-12-22 21:54:07');

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

--
-- Table structure for table `visitors`
--

CREATE TABLE `visitors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ip_address` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `blogs`
--
ALTER TABLE `blogs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `blogs_slug_unique` (`slug`);

--
-- Indexes for table `contacts`
--
ALTER TABLE `contacts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `contacts_address_unique` (`address`);

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

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

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

--
-- Indexes for table `faq_abouts`
--
ALTER TABLE `faq_abouts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `faq_abouts_about_id_foreign` (`about_id`);

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

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

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

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

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`);

--
-- Indexes for table `packagedetails`
--
ALTER TABLE `packagedetails`
  ADD PRIMARY KEY (`id`),
  ADD KEY `packagedetails_package_id_foreign` (`package_id`);

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

--
-- Indexes for table `projects`
--
ALTER TABLE `projects`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `projects_slug_unique` (`slug`),
  ADD KEY `projects_section_id_foreign` (`section_id`);

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

--
-- Indexes for table `sections`
--
ALTER TABLE `sections`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `sections_slug_unique` (`slug`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `faq_abouts`
--
ALTER TABLE `faq_abouts`
  ADD CONSTRAINT `faq_abouts_about_id_foreign` FOREIGN KEY (`about_id`) REFERENCES `abouts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `packagedetails`
--
ALTER TABLE `packagedetails`
  ADD CONSTRAINT `packagedetails_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `projects`
--
ALTER TABLE `projects`
  ADD CONSTRAINT `projects_section_id_foreign` FOREIGN KEY (`section_id`) REFERENCES `sections` (`id`) ON DELETE CASCADE;
COMMIT;

