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

START TRANSACTION;



--
-- Database: `sunnahtravelv2`
--

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

--
-- Table structure for table `airlines`
--

CREATE TABLE `airlines` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `flight_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `airlines`
--

INSERT INTO `airlines` (`id`, `name`, `flight_number`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 'SAUDIA', 'SV825 CGKMED', '2023-01-14 03:05:32', '2023-01-14 03:05:32', 1, 1),
(2, 'SAUDIA', 'SV826 JEDCGK', '2023-01-14 03:05:32', '2023-01-14 03:05:32', 1, 1);

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

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

CREATE TABLE `cities` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` (`id`, `name`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 'MADINAH', '2023-01-14 03:07:09', '2023-01-14 03:07:09', 1, 1),
(2, 'MEKKAH', '2023-01-14 03:07:09', '2023-01-14 03:07:09', 1, 1),
(3, 'JEDDAH', '2023-01-14 03:07:09', '2023-01-14 03:07:09', 1, 1),
(4, 'THAIF', '2023-01-14 03:07:09', '2023-01-14 03:07:09', 1, 1),
(5, 'JORDANIA', '2023-01-14 03:07:09', '2023-01-14 03:07:09', 1, 1),
(6, 'ISRAEL', '2023-01-14 03:07:09', '2023-01-14 03:07:09', 1, 1),
(7, 'TURKEY', '2023-01-14 03:07:09', '2023-01-14 03:07:09', 1, 1),
(8, 'DUBAI', '2023-01-14 03:07:09', '2023-01-14 03:07:09', 1, 1),
(9, 'MESIR', '2023-01-14 03:07:09', '2023-01-14 03:07:09', 1, 1);

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

--
-- Table structure for table `configs`
--

CREATE TABLE `configs` (
  `id` bigint UNSIGNED NOT NULL,
  `config_category` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `config_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `config_value` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `config_desc` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `configs`
--

INSERT INTO `configs` (`id`, `config_category`, `config_name`, `config_value`, `config_desc`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(3, 'framework', 'language_set', 'en', 'Language Set', NULL, NULL, NULL, NULL),
(4, 'framework', 'max_pass_length', '4', 'Maximal Password Length', NULL, NULL, NULL, NULL),
(5, 'framework', 'service_mail', 'travelsunnah@gmail.com', 'Service Mail', NULL, NULL, NULL, NULL),
(6, 'web', 'sitename', 'sunnah.travel', 'Website Name', NULL, NULL, NULL, NULL),
(19, 'framework', 'max_upload_size_int', '20000000', 'Maximal Upload File Size', NULL, NULL, NULL, NULL),
(20, 'framework', 'max_upload_size_str', '20 MB', 'Maximal Upload File Size (String)', NULL, NULL, NULL, NULL),
(49, 'web', 'meta_keyword', '', 'SEO Meta Keyword', NULL, NULL, NULL, NULL),
(50, 'web', 'meta_desc', '', 'SEO Meta Description', NULL, NULL, NULL, NULL),
(51, 'web', 'meta_title', 'Sunnah Travel', 'SEO Meta Title', NULL, NULL, NULL, NULL),
(52, 'web', 'google_analytics', NULL, 'Kode Google Analytics', NULL, '2022-10-25 18:00:36', NULL, NULL),
(57, 'profile', 'contact_phone', '0818-792-929', 'Contact Phone', NULL, '2022-10-25 18:59:42', NULL, NULL),
(58, 'profile', 'contact_mail', 'travelsunnah@gmail.com\r\ninfo@sunnah.travel', 'Contact Email', NULL, NULL, NULL, NULL),
(59, 'profile', 'contact_facebook', '#', 'Facebook', NULL, NULL, NULL, NULL),
(60, 'profile', 'contact_twitter', '#', 'Twitter', NULL, '2022-10-25 19:15:27', NULL, NULL),
(63, 'profile', 'company_name', 'Sunnah Travel', 'Company Name', NULL, '2022-10-25 19:03:45', NULL, NULL),
(64, 'profile', 'company_address', 'Madison Square SHC.2 No. 22, Kota Wisata, Cibubur - Bogor', 'Company Address Office', NULL, '2022-09-05 06:03:16', NULL, NULL),
(72, 'images', 'products_width', '1348', 'Product Pic Width', NULL, NULL, NULL, NULL),
(73, 'images', 'products_height', '206', 'Product Pic Height', NULL, NULL, NULL, NULL),
(74, 'images', 'thumb_height', '100', 'Product Thumb Height', NULL, NULL, NULL, NULL),
(75, 'images', 'thumb_width', '150', 'Product Thumb Width', NULL, NULL, NULL, NULL),
(76, 'images', 'big_height', '600', 'Product Pic Big Height', NULL, NULL, NULL, NULL),
(77, 'images', 'big_width', '800', 'Product Pic Big Width', NULL, NULL, NULL, NULL),
(78, 'images', 'small_height', '73', 'Small Height', NULL, NULL, NULL, NULL),
(79, 'images', 'small_width', '102', 'Small Width', NULL, NULL, NULL, NULL),
(86, 'images', 'medium_width', '400', 'Medium Width', NULL, NULL, NULL, NULL),
(87, 'images', 'medium_height', '300', 'Medium Height', NULL, NULL, NULL, NULL),
(102, 'images', 'clients_width', '50', 'Client Logo Width', NULL, NULL, NULL, NULL),
(103, 'images', 'clients_height', '50', 'Client Logo Height', NULL, NULL, NULL, NULL),
(107, 'images', 'gallery_photos_width', '960', 'Gallery Photo Width', NULL, NULL, NULL, NULL),
(108, 'images', 'gallery_photos_height', '720', 'Gallery Photo Height', NULL, NULL, NULL, NULL),
(109, 'images', 'partnership_logo_width', '200', 'Partnership Logo Width', NULL, NULL, NULL, NULL),
(110, 'images', 'partnership_logo_height', '80', 'Partnership Logo Height', NULL, NULL, NULL, NULL),
(116, 'images', 'page_picture_width', '1366', 'Page Photo Width', NULL, NULL, NULL, NULL),
(117, 'images', 'page_picture_height', '768', 'Page Photo Height', NULL, NULL, NULL, NULL),
(120, 'framework', 'siteurl', 'sunnah.travel', 'Website URL', NULL, NULL, NULL, NULL),
(121, 'images', 'icon_width', '100', 'Icon Width', NULL, NULL, NULL, NULL),
(122, 'images', 'icon_height', '100', 'Icon Height', NULL, NULL, NULL, NULL),
(123, 'images', 'watermark_width', '250', 'Watermark Width', NULL, NULL, NULL, NULL),
(124, 'images', 'watermark_height', '80', 'Watermark Height', NULL, NULL, NULL, NULL),
(127, 'images', 'blog_width', '450', 'Blog Picture Width', NULL, NULL, NULL, NULL),
(128, 'images', 'blog_height', '300', 'Blog Picture Height', NULL, NULL, NULL, NULL),
(132, 'web', 'footer_content', 'Lorem ipsum dolor sit amet consectetur. Urna dolor urna venenatis sed lectus integer habitasse sollicitudin vitae. Vitae lobortis lectus vestibulum elementum non consectetur praesent nulla sit.', 'Footer Content', NULL, '2022-12-01 13:46:40', NULL, NULL),
(134, 'profile', 'contact_instagram', '#', 'Instagram', NULL, NULL, NULL, NULL),
(135, 'profile', 'contact_linkedin', '#', 'Linkedin', NULL, NULL, NULL, NULL),
(136, 'profile', 'contact_youtube', '#', 'Youtube Channel', NULL, '2022-10-25 19:15:32', NULL, NULL),
(137, 'web', 'maintenance_mode', 'No', 'Maintenance Mode', NULL, '2022-10-25 18:51:22', NULL, NULL),
(138, 'web', 'live_chat_code', '', 'Kode Live Chat Whatsapp', NULL, NULL, NULL, NULL),
(140, 'web', 'gmap_embed_url', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3965.329703930773!2d106.95903841535265!3d-6.351343163906356!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x2e6993778965f7f9%3A0xcd409b4f17f4edd5!2sSunnah%20Tour%20%26%20Travel%20(Haji%20%26%20Umroh%20Sesuai%20Sunnah)!5e0!3m2!1sen!2sid!4v1673885796393!5m2!1sen!2sid', 'Google Maps Embed URL', NULL, '2022-10-25 10:29:09', NULL, NULL),
(143, 'images', 'portfolio_width', '253', 'Portfolio Pic Width', NULL, NULL, NULL, NULL),
(144, 'images', 'portfolio_height', '162', 'Portfolio Pic Height', NULL, NULL, NULL, NULL),
(149, 'images', 'avatar_width', '140', 'Team Avatar Width', NULL, NULL, NULL, NULL),
(150, 'images', 'avatar_height', '200', 'Team Avatar Height', NULL, NULL, NULL, NULL),
(151, 'images', 'gallery_photo_height', '397', 'Gallery Photo Height', NULL, NULL, NULL, NULL),
(152, 'images', 'gallery_photo_width', '600', 'Gallery Photo Width', NULL, NULL, NULL, NULL),
(153, 'images', 'gallery_small_height', '131', 'Gallery Photo Height', NULL, NULL, NULL, NULL),
(154, 'images', 'gallery_small_width', '198', 'Gallery Photo Width', NULL, NULL, NULL, NULL),
(155, 'images', 'testimonial_height', '86', 'Testimonial Photo Height', NULL, NULL, NULL, NULL),
(156, 'images', 'testimonial_width', '86', 'Testimonial Photo Width', NULL, NULL, NULL, NULL),
(163, 'images', 'partnership_width', '210', 'Partnership Logo Width', NULL, NULL, NULL, NULL),
(164, 'images', 'partnership_height', '110', 'Partnership Logo Height', NULL, NULL, NULL, NULL),
(166, 'images', 'profile_height', '200', 'Profile Photo Height', NULL, NULL, NULL, NULL),
(167, 'images', 'profile_width', '200', 'Profile Photo Width', NULL, NULL, NULL, NULL),
(168, 'images', 'landing_height', '768', 'Landing Picture Height', NULL, NULL, NULL, NULL),
(169, 'images', 'landing_width', '1366', 'Landing Picture Width', NULL, NULL, NULL, NULL),
(173, 'images', 'services_height', '50', 'Service Icon Height', NULL, NULL, NULL, NULL),
(174, 'images', 'services_width', '50', 'Service Icon Width', NULL, NULL, NULL, NULL),
(175, 'framework', 'company_logo', 'logo.webp', 'Company Logo', NULL, NULL, NULL, NULL),
(176, 'framework', 'company_favicon', 'favicon.ico', 'Company Favicon', NULL, NULL, NULL, NULL),
(177, 'images', 'logo_height', '50', 'Logo Height', NULL, NULL, NULL, NULL),
(178, 'images', 'logo_width', '50', 'Logo Width', NULL, NULL, NULL, NULL),
(179, 'profile', 'contact_whatsapp', '0818-792-727', 'Contact Whatsapp', NULL, '2022-10-25 18:59:42', NULL, NULL),
(180, 'profile', 'contact_mail_top', 'travelsunnah@gmail.com', 'Contact Email Top Bar', NULL, NULL, NULL, NULL);

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

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

CREATE TABLE `contacts` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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 `contacts`
--

INSERT INTO `contacts` (`id`, `name`, `email`, `phone`, `company_name`, `message`, `created_at`, `updated_at`) VALUES
(1, 'Wisnu Hafid', 'webhadecreative@gmail.com', '08976660502', 'WebHade Creative', 'testing kontak', '2023-01-16 17:02:42', '2023-01-16 17:02:42'),
(2, 'Wisnu Hafid', 'webhadecreative@gmail.com', '08976660502', 'WebHade Creative', 'test kontak form', '2023-01-23 01:54:17', '2023-01-23 01:54:17');

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

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

CREATE TABLE `districts` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `province_id` bigint UNSIGNED DEFAULT NULL,
  `local_city_id` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `districts`
--

INSERT INTO `districts` (`id`, `name`, `province_id`, `local_city_id`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 'Rancasari', 9, 1, '2023-01-07 08:24:51', '2023-01-07 08:24:51', 1, 1),
(3, 'Lembang', 9, 3, '2023-01-30 08:55:21', '2023-01-30 09:05:22', 1, 1),
(6, 'Sekejati', 9, 1, '2023-01-30 10:20:57', '2023-01-30 10:20:57', 1, 1),
(7, 'Batununggal', 9, 1, '2023-01-30 10:21:11', '2023-01-30 10:21:11', 1, 1);

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

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

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

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

--
-- Table structure for table `hotels`
--

CREATE TABLE `hotels` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rating` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `cover_media` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hotels`
--

INSERT INTO `hotels` (`id`, `name`, `rating`, `cover_media`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 'Movenpick', '5', 'hotel1.jpg', '2023-01-14 03:09:31', '2023-01-14 03:09:31', 1, 1),
(2, 'Shafwa Royal Orchied', '4', 'hotel2.jpg', '2023-01-14 03:09:31', '2023-01-14 03:09:31', 1, 1),
(3, 'Hotel Name', '3', 'hotel1.jpg', '2023-01-14 05:03:35', '2023-01-14 05:03:35', 1, 1),
(4, 'panghegar', '3', 'hotel1675078787682004153.jpeg', '2023-01-30 11:36:39', '2023-01-30 11:39:47', 1, 1);

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

--
-- Table structure for table `local_cities`
--

CREATE TABLE `local_cities` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `province_id` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `local_cities`
--

INSERT INTO `local_cities` (`id`, `name`, `province_id`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 'Kota Bandung', 9, '2023-01-30 08:20:51', '2023-01-30 08:21:00', 1, 1),
(3, 'Kab. Bandung Barat', 9, '2023-01-30 08:55:04', '2023-01-30 08:55:04', 1, 1);

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

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

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int 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_resets_table', 2),
(3, '2019_08_19_000000_create_failed_jobs_table', 3),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 4),
(5, '2022_08_18_102855_create_configs_table', 5),
(6, '2022_08_15_140414_add_blameable_in_users', 6),
(7, '2022_09_08_131403_create_contacts_table', 7),
(8, '2022_09_08_151809_create_news_table', 8),
(9, '2022_10_14_123856_add_api_token_in_users', 9),
(10, '2022_10_21_173105_create_news_tags_table', 10),
(11, '2023_01_06_151451_create_pages_table', 11),
(12, '2023_01_14_103408_create_sliders_table', 12),
(13, '2023_01_16_092447_create_airlines_table', 13),
(14, '2023_01_16_092507_create_cities_table', 14),
(15, '2023_01_16_092519_create_hotels_table', 15),
(16, '2023_01_16_092534_create_tour_leaders_table', 16),
(21, '2023_01_16_092642_create_services_table', 17),
(25, '2023_01_16_092713_create_packages_table', 18),
(26, '2023_01_16_093544_create_package_hotels_table', 19),
(27, '2023_01_16_093735_create_package_services_table', 20),
(28, '2023_01_16_214124_create_testimonials_table', 21),
(29, '2023_01_17_012404_create_photo_galleries_table', 22),
(31, '2023_01_17_012519_create_video_galleries_table', 23),
(32, '2023_01_22_132707_create_provinces_table', 24),
(33, '2023_01_22_132837_create_local_cities_table', 25),
(34, '2023_01_22_132857_create_districts_table', 26),
(35, '2023_01_22_132908_create_sub_districts_table', 27),
(38, '2023_01_22_133519_create_package_register_umrahs_table', 28),
(39, '2023_01_22_133702_create_package_register_hajjs_table', 29);

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

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

CREATE TABLE `news` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `published_at` date NOT NULL,
  `status` enum('draft','publish') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `cover_media` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_keyword` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `hitsview` int DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `news` (`id`, `title`, `slug`, `content`, `published_at`, `status`, `cover_media`, `meta_title`, `meta_keyword`, `meta_description`, `hitsview`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 'Ihram Haji dan Umroh Bagian 2', 'ihram-haji-dan-umroh-bagian-2', '{\"ops\":[{\"insert\":\"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Cursus mattis molestie a iaculis at erat pellentesque adipiscing commodo. Aliquam eleifend mi in nulla posuere sollicitudin aliquam. Suspendisse sed nisi lacus sed. Volutpat diam ut venenatis tellus in metus vulputate. Volutpat odio facilisis mauris sit amet massa vitae tortor condimentum. Nisl purus in mollis nunc. Eget dolor morbi non arcu risus. Leo urna molestie at elementum eu facilisis. Risus feugiat in ante metus dictum at tempor commodo. Viverra accumsan in nisl nisi scelerisque eu ultrices. Quis lectus nulla at volutpat diam ut venenatis tellus. Sed sed risus pretium quam.\\nSagittis vitae et leo duis ut diam. Suspendisse interdum consectetur libero id faucibus. Nulla porttitor massa id neque aliquam. Viverra aliquet eget sit amet tellus. Nulla facilisi cras fermentum odio eu feugiat pretium nibh. Nisi scelerisque eu ultrices vitae auctor eu. Ullamcorper a lacus vestibulum sed arcu. Tortor at auctor urna nunc id cursus metus. Neque egestas congue quisque egestas diam in arcu. Nec tincidunt praesent semper feugiat nibh sed. Platea dictumst quisque sagittis purus. Viverra nibh cras pulvinar mattis nunc sed blandit libero volutpat. In massa tempor nec feugiat nisl pretium fusce id.\\nEt egestas quis ipsum suspendisse ultrices gravida dictum. Posuere lorem ipsum dolor sit amet consectetur adipiscing elit duis. Nulla facilisi nullam vehicula ipsum a arcu. Egestas quis ipsum suspendisse ultrices gravida dictum fusce. Mauris sit amet massa vitae. Felis eget velit aliquet sagittis id consectetur purus. Purus sit amet luctus venenatis lectus magna. Rhoncus mattis rhoncus urna neque. Interdum velit euismod in pellentesque massa placerat. Sagittis nisl rhoncus mattis rhoncus urna neque. Ut diam quam nulla porttitor massa id. Molestie a iaculis at erat pellentesque adipiscing. Ac turpis egestas integer eget aliquet nibh praesent.\\nFringilla urna porttitor rhoncus dolor purus non enim praesent elementum. Nunc consequat interdum varius sit amet mattis vulputate enim nulla. Mi tempus imperdiet nulla malesuada pellentesque elit. Blandit turpis cursus in hac. Sed tempus urna et pharetra pharetra. Vitae justo eget magna fermentum iaculis eu non. Ac tortor dignissim convallis aenean et tortor. Velit sed ullamcorper morbi tincidunt. Aliquet eget sit amet tellus cras adipiscing enim eu. Consequat id porta nibh venenatis cras. Malesuada fames ac turpis egestas sed tempus urna et. Montes nascetur ridiculus mus mauris. Placerat orci nulla pellentesque dignissim enim sit amet venenatis urna. Aenean sed adipiscing diam donec adipiscing tristique risus nec. Nisl vel pretium lectus quam id leo in vitae turpis. Tincidunt ornare massa eget egestas.\\n\"}]}', '2023-01-13', 'publish', 'news16736647051193488404.png', 'Ihram Haji dan Umroh Bagian 2', 'Ihram Haji dan Umroh Bagian 2', 'Ihram Haji dan Umroh Bagian 2', 1, '2023-01-14 02:51:30', '2023-01-16 09:15:28', 1, 1),
(2, 'Ihram Haji dan Umroh Bagian 1', 'ihram-haji-dan-umroh-bagian-1', '{\"ops\":[{\"insert\":\"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Cursus mattis molestie a iaculis at erat pellentesque adipiscing commodo. Aliquam eleifend mi in nulla posuere sollicitudin aliquam. Suspendisse sed nisi lacus sed. Volutpat diam ut venenatis tellus in metus vulputate. Volutpat odio facilisis mauris sit amet massa vitae tortor condimentum. Nisl purus in mollis nunc. Eget dolor morbi non arcu risus. Leo urna molestie at elementum eu facilisis. Risus feugiat in ante metus dictum at tempor commodo. Viverra accumsan in nisl nisi scelerisque eu ultrices. Quis lectus nulla at volutpat diam ut venenatis tellus. Sed sed risus pretium quam.\\nSagittis vitae et leo duis ut diam. Suspendisse interdum consectetur libero id faucibus. Nulla porttitor massa id neque aliquam. Viverra aliquet eget sit amet tellus. Nulla facilisi cras fermentum odio eu feugiat pretium nibh. Nisi scelerisque eu ultrices vitae auctor eu. Ullamcorper a lacus vestibulum sed arcu. Tortor at auctor urna nunc id cursus metus. Neque egestas congue quisque egestas diam in arcu. Nec tincidunt praesent semper feugiat nibh sed. Platea dictumst quisque sagittis purus. Viverra nibh cras pulvinar mattis nunc sed blandit libero volutpat. In massa tempor nec feugiat nisl pretium fusce id.\\nEt egestas quis ipsum suspendisse ultrices gravida dictum. Posuere lorem ipsum dolor sit amet consectetur adipiscing elit duis. Nulla facilisi nullam vehicula ipsum a arcu. Egestas quis ipsum suspendisse ultrices gravida dictum fusce. Mauris sit amet massa vitae. Felis eget velit aliquet sagittis id consectetur purus. Purus sit amet luctus venenatis lectus magna. Rhoncus mattis rhoncus urna neque. Interdum velit euismod in pellentesque massa placerat. Sagittis nisl rhoncus mattis rhoncus urna neque. Ut diam quam nulla porttitor massa id. Molestie a iaculis at erat pellentesque adipiscing. Ac turpis egestas integer eget aliquet nibh praesent.\\nFringilla urna porttitor rhoncus dolor purus non enim praesent elementum. Nunc consequat interdum varius sit amet mattis vulputate enim nulla. Mi tempus imperdiet nulla malesuada pellentesque elit. Blandit turpis cursus in hac. Sed tempus urna et pharetra pharetra. Vitae justo eget magna fermentum iaculis eu non. Ac tortor dignissim convallis aenean et tortor. Velit sed ullamcorper morbi tincidunt. Aliquet eget sit amet tellus cras adipiscing enim eu. Consequat id porta nibh venenatis cras. Malesuada fames ac turpis egestas sed tempus urna et. Montes nascetur ridiculus mus mauris. Placerat orci nulla pellentesque dignissim enim sit amet venenatis urna. Aenean sed adipiscing diam donec adipiscing tristique risus nec. Nisl vel pretium lectus quam id leo in vitae turpis. Tincidunt ornare massa eget egestas.\\n\"}]}', '2023-01-14', 'publish', 'news1673664850631113452.png', 'Ihram Haji dan Umroh Bagian 1', 'Ihram Haji dan Umroh Bagian 1', 'Ihram Haji dan Umroh Bagian 1', 14, '2023-01-14 02:54:10', '2023-01-16 09:14:59', 1, 1),
(3, 'Ihram Haji dan Umroh Bagian 2', 'ihram-haji-dan-umroh-bagian-2', '{\"ops\":[{\"insert\":\"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Cursus mattis molestie a iaculis at erat pellentesque adipiscing commodo. Aliquam eleifend mi in nulla posuere sollicitudin aliquam. Suspendisse sed nisi lacus sed. Volutpat diam ut venenatis tellus in metus vulputate. Volutpat odio facilisis mauris sit amet massa vitae tortor condimentum. Nisl purus in mollis nunc. Eget dolor morbi non arcu risus. Leo urna molestie at elementum eu facilisis. Risus feugiat in ante metus dictum at tempor commodo. Viverra accumsan in nisl nisi scelerisque eu ultrices. Quis lectus nulla at volutpat diam ut venenatis tellus. Sed sed risus pretium quam.\\nSagittis vitae et leo duis ut diam. Suspendisse interdum consectetur libero id faucibus. Nulla porttitor massa id neque aliquam. Viverra aliquet eget sit amet tellus. Nulla facilisi cras fermentum odio eu feugiat pretium nibh. Nisi scelerisque eu ultrices vitae auctor eu. Ullamcorper a lacus vestibulum sed arcu. Tortor at auctor urna nunc id cursus metus. Neque egestas congue quisque egestas diam in arcu. Nec tincidunt praesent semper feugiat nibh sed. Platea dictumst quisque sagittis purus. Viverra nibh cras pulvinar mattis nunc sed blandit libero volutpat. In massa tempor nec feugiat nisl pretium fusce id.\\nEt egestas quis ipsum suspendisse ultrices gravida dictum. Posuere lorem ipsum dolor sit amet consectetur adipiscing elit duis. Nulla facilisi nullam vehicula ipsum a arcu. Egestas quis ipsum suspendisse ultrices gravida dictum fusce. Mauris sit amet massa vitae. Felis eget velit aliquet sagittis id consectetur purus. Purus sit amet luctus venenatis lectus magna. Rhoncus mattis rhoncus urna neque. Interdum velit euismod in pellentesque massa placerat. Sagittis nisl rhoncus mattis rhoncus urna neque. Ut diam quam nulla porttitor massa id. Molestie a iaculis at erat pellentesque adipiscing. Ac turpis egestas integer eget aliquet nibh praesent.\\nFringilla urna porttitor rhoncus dolor purus non enim praesent elementum. Nunc consequat interdum varius sit amet mattis vulputate enim nulla. Mi tempus imperdiet nulla malesuada pellentesque elit. Blandit turpis cursus in hac. Sed tempus urna et pharetra pharetra. Vitae justo eget magna fermentum iaculis eu non. Ac tortor dignissim convallis aenean et tortor. Velit sed ullamcorper morbi tincidunt. Aliquet eget sit amet tellus cras adipiscing enim eu. Consequat id porta nibh venenatis cras. Malesuada fames ac turpis egestas sed tempus urna et. Montes nascetur ridiculus mus mauris. Placerat orci nulla pellentesque dignissim enim sit amet venenatis urna. Aenean sed adipiscing diam donec adipiscing tristique risus nec. Nisl vel pretium lectus quam id leo in vitae turpis. Tincidunt ornare massa eget egestas.\\n\"}]}', '2023-01-13', 'publish', 'news16736647051193488404.png', 'Ihram Haji dan Umroh Bagian 2', 'Ihram Haji dan Umroh Bagian 2', 'Ihram Haji dan Umroh Bagian 2', 1, '2023-01-14 02:51:30', '2023-01-16 09:15:28', 1, 1),
(4, 'Ihram Haji dan Umroh Bagian 1', 'ihram-haji-dan-umroh-bagian-1', '{\"ops\":[{\"insert\":\"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Cursus mattis molestie a iaculis at erat pellentesque adipiscing commodo. Aliquam eleifend mi in nulla posuere sollicitudin aliquam. Suspendisse sed nisi lacus sed. Volutpat diam ut venenatis tellus in metus vulputate. Volutpat odio facilisis mauris sit amet massa vitae tortor condimentum. Nisl purus in mollis nunc. Eget dolor morbi non arcu risus. Leo urna molestie at elementum eu facilisis. Risus feugiat in ante metus dictum at tempor commodo. Viverra accumsan in nisl nisi scelerisque eu ultrices. Quis lectus nulla at volutpat diam ut venenatis tellus. Sed sed risus pretium quam.\\nSagittis vitae et leo duis ut diam. Suspendisse interdum consectetur libero id faucibus. Nulla porttitor massa id neque aliquam. Viverra aliquet eget sit amet tellus. Nulla facilisi cras fermentum odio eu feugiat pretium nibh. Nisi scelerisque eu ultrices vitae auctor eu. Ullamcorper a lacus vestibulum sed arcu. Tortor at auctor urna nunc id cursus metus. Neque egestas congue quisque egestas diam in arcu. Nec tincidunt praesent semper feugiat nibh sed. Platea dictumst quisque sagittis purus. Viverra nibh cras pulvinar mattis nunc sed blandit libero volutpat. In massa tempor nec feugiat nisl pretium fusce id.\\nEt egestas quis ipsum suspendisse ultrices gravida dictum. Posuere lorem ipsum dolor sit amet consectetur adipiscing elit duis. Nulla facilisi nullam vehicula ipsum a arcu. Egestas quis ipsum suspendisse ultrices gravida dictum fusce. Mauris sit amet massa vitae. Felis eget velit aliquet sagittis id consectetur purus. Purus sit amet luctus venenatis lectus magna. Rhoncus mattis rhoncus urna neque. Interdum velit euismod in pellentesque massa placerat. Sagittis nisl rhoncus mattis rhoncus urna neque. Ut diam quam nulla porttitor massa id. Molestie a iaculis at erat pellentesque adipiscing. Ac turpis egestas integer eget aliquet nibh praesent.\\nFringilla urna porttitor rhoncus dolor purus non enim praesent elementum. Nunc consequat interdum varius sit amet mattis vulputate enim nulla. Mi tempus imperdiet nulla malesuada pellentesque elit. Blandit turpis cursus in hac. Sed tempus urna et pharetra pharetra. Vitae justo eget magna fermentum iaculis eu non. Ac tortor dignissim convallis aenean et tortor. Velit sed ullamcorper morbi tincidunt. Aliquet eget sit amet tellus cras adipiscing enim eu. Consequat id porta nibh venenatis cras. Malesuada fames ac turpis egestas sed tempus urna et. Montes nascetur ridiculus mus mauris. Placerat orci nulla pellentesque dignissim enim sit amet venenatis urna. Aenean sed adipiscing diam donec adipiscing tristique risus nec. Nisl vel pretium lectus quam id leo in vitae turpis. Tincidunt ornare massa eget egestas.\\n\"}]}', '2023-01-14', 'publish', 'news1673664850631113452.png', 'Ihram Haji dan Umroh Bagian 1', 'Ihram Haji dan Umroh Bagian 1', 'Ihram Haji dan Umroh Bagian 1', 26, '2023-01-14 02:54:10', '2023-01-20 01:16:07', 1, 1),
(5, 'Ihram Haji dan Umroh Bagian 2', 'ihram-haji-dan-umroh-bagian-2', '{\"ops\":[{\"insert\":\"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Cursus mattis molestie a iaculis at erat pellentesque adipiscing commodo. Aliquam eleifend mi in nulla posuere sollicitudin aliquam. Suspendisse sed nisi lacus sed. Volutpat diam ut venenatis tellus in metus vulputate. Volutpat odio facilisis mauris sit amet massa vitae tortor condimentum. Nisl purus in mollis nunc. Eget dolor morbi non arcu risus. Leo urna molestie at elementum eu facilisis. Risus feugiat in ante metus dictum at tempor commodo. Viverra accumsan in nisl nisi scelerisque eu ultrices. Quis lectus nulla at volutpat diam ut venenatis tellus. Sed sed risus pretium quam.\\nSagittis vitae et leo duis ut diam. Suspendisse interdum consectetur libero id faucibus. Nulla porttitor massa id neque aliquam. Viverra aliquet eget sit amet tellus. Nulla facilisi cras fermentum odio eu feugiat pretium nibh. Nisi scelerisque eu ultrices vitae auctor eu. Ullamcorper a lacus vestibulum sed arcu. Tortor at auctor urna nunc id cursus metus. Neque egestas congue quisque egestas diam in arcu. Nec tincidunt praesent semper feugiat nibh sed. Platea dictumst quisque sagittis purus. Viverra nibh cras pulvinar mattis nunc sed blandit libero volutpat. In massa tempor nec feugiat nisl pretium fusce id.\\nEt egestas quis ipsum suspendisse ultrices gravida dictum. Posuere lorem ipsum dolor sit amet consectetur adipiscing elit duis. Nulla facilisi nullam vehicula ipsum a arcu. Egestas quis ipsum suspendisse ultrices gravida dictum fusce. Mauris sit amet massa vitae. Felis eget velit aliquet sagittis id consectetur purus. Purus sit amet luctus venenatis lectus magna. Rhoncus mattis rhoncus urna neque. Interdum velit euismod in pellentesque massa placerat. Sagittis nisl rhoncus mattis rhoncus urna neque. Ut diam quam nulla porttitor massa id. Molestie a iaculis at erat pellentesque adipiscing. Ac turpis egestas integer eget aliquet nibh praesent.\\nFringilla urna porttitor rhoncus dolor purus non enim praesent elementum. Nunc consequat interdum varius sit amet mattis vulputate enim nulla. Mi tempus imperdiet nulla malesuada pellentesque elit. Blandit turpis cursus in hac. Sed tempus urna et pharetra pharetra. Vitae justo eget magna fermentum iaculis eu non. Ac tortor dignissim convallis aenean et tortor. Velit sed ullamcorper morbi tincidunt. Aliquet eget sit amet tellus cras adipiscing enim eu. Consequat id porta nibh venenatis cras. Malesuada fames ac turpis egestas sed tempus urna et. Montes nascetur ridiculus mus mauris. Placerat orci nulla pellentesque dignissim enim sit amet venenatis urna. Aenean sed adipiscing diam donec adipiscing tristique risus nec. Nisl vel pretium lectus quam id leo in vitae turpis. Tincidunt ornare massa eget egestas.\\n\"}]}', '2023-01-13', 'publish', 'news16736647051193488404.png', 'Ihram Haji dan Umroh Bagian 2', 'Ihram Haji dan Umroh Bagian 2', 'Ihram Haji dan Umroh Bagian 2', 1, '2023-01-14 02:51:30', '2023-01-16 09:15:28', 1, 1),
(6, 'Ihram Haji dan Umroh Bagian 1', 'ihram-haji-dan-umroh-bagian-1', '{\"ops\":[{\"insert\":\"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Cursus mattis molestie a iaculis at erat pellentesque adipiscing commodo. Aliquam eleifend mi in nulla posuere sollicitudin aliquam. Suspendisse sed nisi lacus sed. Volutpat diam ut venenatis tellus in metus vulputate. Volutpat odio facilisis mauris sit amet massa vitae tortor condimentum. Nisl purus in mollis nunc. Eget dolor morbi non arcu risus. Leo urna molestie at elementum eu facilisis. Risus feugiat in ante metus dictum at tempor commodo. Viverra accumsan in nisl nisi scelerisque eu ultrices. Quis lectus nulla at volutpat diam ut venenatis tellus. Sed sed risus pretium quam.\\nSagittis vitae et leo duis ut diam. Suspendisse interdum consectetur libero id faucibus. Nulla porttitor massa id neque aliquam. Viverra aliquet eget sit amet tellus. Nulla facilisi cras fermentum odio eu feugiat pretium nibh. Nisi scelerisque eu ultrices vitae auctor eu. Ullamcorper a lacus vestibulum sed arcu. Tortor at auctor urna nunc id cursus metus. Neque egestas congue quisque egestas diam in arcu. Nec tincidunt praesent semper feugiat nibh sed. Platea dictumst quisque sagittis purus. Viverra nibh cras pulvinar mattis nunc sed blandit libero volutpat. In massa tempor nec feugiat nisl pretium fusce id.\\nEt egestas quis ipsum suspendisse ultrices gravida dictum. Posuere lorem ipsum dolor sit amet consectetur adipiscing elit duis. Nulla facilisi nullam vehicula ipsum a arcu. Egestas quis ipsum suspendisse ultrices gravida dictum fusce. Mauris sit amet massa vitae. Felis eget velit aliquet sagittis id consectetur purus. Purus sit amet luctus venenatis lectus magna. Rhoncus mattis rhoncus urna neque. Interdum velit euismod in pellentesque massa placerat. Sagittis nisl rhoncus mattis rhoncus urna neque. Ut diam quam nulla porttitor massa id. Molestie a iaculis at erat pellentesque adipiscing. Ac turpis egestas integer eget aliquet nibh praesent.\\nFringilla urna porttitor rhoncus dolor purus non enim praesent elementum. Nunc consequat interdum varius sit amet mattis vulputate enim nulla. Mi tempus imperdiet nulla malesuada pellentesque elit. Blandit turpis cursus in hac. Sed tempus urna et pharetra pharetra. Vitae justo eget magna fermentum iaculis eu non. Ac tortor dignissim convallis aenean et tortor. Velit sed ullamcorper morbi tincidunt. Aliquet eget sit amet tellus cras adipiscing enim eu. Consequat id porta nibh venenatis cras. Malesuada fames ac turpis egestas sed tempus urna et. Montes nascetur ridiculus mus mauris. Placerat orci nulla pellentesque dignissim enim sit amet venenatis urna. Aenean sed adipiscing diam donec adipiscing tristique risus nec. Nisl vel pretium lectus quam id leo in vitae turpis. Tincidunt ornare massa eget egestas.\\n\"}]}', '2023-01-14', 'publish', 'news1673664850631113452.png', 'Ihram Haji dan Umroh Bagian 1', 'Ihram Haji dan Umroh Bagian 1', 'Ihram Haji dan Umroh Bagian 1', 14, '2023-01-14 02:54:10', '2023-01-16 09:14:59', 1, 1),
(7, 'Ihram Haji dan Umroh Bagian 2', 'ihram-haji-dan-umroh-bagian-2', '{\"ops\":[{\"insert\":\"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Cursus mattis molestie a iaculis at erat pellentesque adipiscing commodo. Aliquam eleifend mi in nulla posuere sollicitudin aliquam. Suspendisse sed nisi lacus sed. Volutpat diam ut venenatis tellus in metus vulputate. Volutpat odio facilisis mauris sit amet massa vitae tortor condimentum. Nisl purus in mollis nunc. Eget dolor morbi non arcu risus. Leo urna molestie at elementum eu facilisis. Risus feugiat in ante metus dictum at tempor commodo. Viverra accumsan in nisl nisi scelerisque eu ultrices. Quis lectus nulla at volutpat diam ut venenatis tellus. Sed sed risus pretium quam.\\nSagittis vitae et leo duis ut diam. Suspendisse interdum consectetur libero id faucibus. Nulla porttitor massa id neque aliquam. Viverra aliquet eget sit amet tellus. Nulla facilisi cras fermentum odio eu feugiat pretium nibh. Nisi scelerisque eu ultrices vitae auctor eu. Ullamcorper a lacus vestibulum sed arcu. Tortor at auctor urna nunc id cursus metus. Neque egestas congue quisque egestas diam in arcu. Nec tincidunt praesent semper feugiat nibh sed. Platea dictumst quisque sagittis purus. Viverra nibh cras pulvinar mattis nunc sed blandit libero volutpat. In massa tempor nec feugiat nisl pretium fusce id.\\nEt egestas quis ipsum suspendisse ultrices gravida dictum. Posuere lorem ipsum dolor sit amet consectetur adipiscing elit duis. Nulla facilisi nullam vehicula ipsum a arcu. Egestas quis ipsum suspendisse ultrices gravida dictum fusce. Mauris sit amet massa vitae. Felis eget velit aliquet sagittis id consectetur purus. Purus sit amet luctus venenatis lectus magna. Rhoncus mattis rhoncus urna neque. Interdum velit euismod in pellentesque massa placerat. Sagittis nisl rhoncus mattis rhoncus urna neque. Ut diam quam nulla porttitor massa id. Molestie a iaculis at erat pellentesque adipiscing. Ac turpis egestas integer eget aliquet nibh praesent.\\nFringilla urna porttitor rhoncus dolor purus non enim praesent elementum. Nunc consequat interdum varius sit amet mattis vulputate enim nulla. Mi tempus imperdiet nulla malesuada pellentesque elit. Blandit turpis cursus in hac. Sed tempus urna et pharetra pharetra. Vitae justo eget magna fermentum iaculis eu non. Ac tortor dignissim convallis aenean et tortor. Velit sed ullamcorper morbi tincidunt. Aliquet eget sit amet tellus cras adipiscing enim eu. Consequat id porta nibh venenatis cras. Malesuada fames ac turpis egestas sed tempus urna et. Montes nascetur ridiculus mus mauris. Placerat orci nulla pellentesque dignissim enim sit amet venenatis urna. Aenean sed adipiscing diam donec adipiscing tristique risus nec. Nisl vel pretium lectus quam id leo in vitae turpis. Tincidunt ornare massa eget egestas.\\n\"}]}', '2023-01-13', 'publish', 'news16736647051193488404.png', 'Ihram Haji dan Umroh Bagian 2', 'Ihram Haji dan Umroh Bagian 2', 'Ihram Haji dan Umroh Bagian 2', 1, '2023-01-14 02:51:30', '2023-01-16 09:15:28', 1, 1),
(8, 'Ihram Haji dan Umroh Bagian 1', 'ihram-haji-dan-umroh-bagian-1', '{\"ops\":[{\"insert\":\"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Cursus mattis molestie a iaculis at erat pellentesque adipiscing commodo. Aliquam eleifend mi in nulla posuere sollicitudin aliquam. Suspendisse sed nisi lacus sed. Volutpat diam ut venenatis tellus in metus vulputate. Volutpat odio facilisis mauris sit amet massa vitae tortor condimentum. Nisl purus in mollis nunc. Eget dolor morbi non arcu risus. Leo urna molestie at elementum eu facilisis. Risus feugiat in ante metus dictum at tempor commodo. Viverra accumsan in nisl nisi scelerisque eu ultrices. Quis lectus nulla at volutpat diam ut venenatis tellus. Sed sed risus pretium quam.\\nSagittis vitae et leo duis ut diam. Suspendisse interdum consectetur libero id faucibus. Nulla porttitor massa id neque aliquam. Viverra aliquet eget sit amet tellus. Nulla facilisi cras fermentum odio eu feugiat pretium nibh. Nisi scelerisque eu ultrices vitae auctor eu. Ullamcorper a lacus vestibulum sed arcu. Tortor at auctor urna nunc id cursus metus. Neque egestas congue quisque egestas diam in arcu. Nec tincidunt praesent semper feugiat nibh sed. Platea dictumst quisque sagittis purus. Viverra nibh cras pulvinar mattis nunc sed blandit libero volutpat. In massa tempor nec feugiat nisl pretium fusce id.\\nEt egestas quis ipsum suspendisse ultrices gravida dictum. Posuere lorem ipsum dolor sit amet consectetur adipiscing elit duis. Nulla facilisi nullam vehicula ipsum a arcu. Egestas quis ipsum suspendisse ultrices gravida dictum fusce. Mauris sit amet massa vitae. Felis eget velit aliquet sagittis id consectetur purus. Purus sit amet luctus venenatis lectus magna. Rhoncus mattis rhoncus urna neque. Interdum velit euismod in pellentesque massa placerat. Sagittis nisl rhoncus mattis rhoncus urna neque. Ut diam quam nulla porttitor massa id. Molestie a iaculis at erat pellentesque adipiscing. Ac turpis egestas integer eget aliquet nibh praesent.\\nFringilla urna porttitor rhoncus dolor purus non enim praesent elementum. Nunc consequat interdum varius sit amet mattis vulputate enim nulla. Mi tempus imperdiet nulla malesuada pellentesque elit. Blandit turpis cursus in hac. Sed tempus urna et pharetra pharetra. Vitae justo eget magna fermentum iaculis eu non. Ac tortor dignissim convallis aenean et tortor. Velit sed ullamcorper morbi tincidunt. Aliquet eget sit amet tellus cras adipiscing enim eu. Consequat id porta nibh venenatis cras. Malesuada fames ac turpis egestas sed tempus urna et. Montes nascetur ridiculus mus mauris. Placerat orci nulla pellentesque dignissim enim sit amet venenatis urna. Aenean sed adipiscing diam donec adipiscing tristique risus nec. Nisl vel pretium lectus quam id leo in vitae turpis. Tincidunt ornare massa eget egestas.\\n\"}]}', '2023-01-14', 'publish', 'news1673664850631113452.png', 'Ihram Haji dan Umroh Bagian 1', 'Ihram Haji dan Umroh Bagian 1', 'Ihram Haji dan Umroh Bagian 1', 15, '2023-01-14 02:54:10', '2023-01-26 03:21:54', 1, 1),
(9, 'Ihram Haji dan Umroh Bagian 2', 'ihram-haji-dan-umroh-bagian-2', '{\"ops\":[{\"insert\":\"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Cursus mattis molestie a iaculis at erat pellentesque adipiscing commodo. Aliquam eleifend mi in nulla posuere sollicitudin aliquam. Suspendisse sed nisi lacus sed. Volutpat diam ut venenatis tellus in metus vulputate. Volutpat odio facilisis mauris sit amet massa vitae tortor condimentum. Nisl purus in mollis nunc. Eget dolor morbi non arcu risus. Leo urna molestie at elementum eu facilisis. Risus feugiat in ante metus dictum at tempor commodo. Viverra accumsan in nisl nisi scelerisque eu ultrices. Quis lectus nulla at volutpat diam ut venenatis tellus. Sed sed risus pretium quam.\\nSagittis vitae et leo duis ut diam. Suspendisse interdum consectetur libero id faucibus. Nulla porttitor massa id neque aliquam. Viverra aliquet eget sit amet tellus. Nulla facilisi cras fermentum odio eu feugiat pretium nibh. Nisi scelerisque eu ultrices vitae auctor eu. Ullamcorper a lacus vestibulum sed arcu. Tortor at auctor urna nunc id cursus metus. Neque egestas congue quisque egestas diam in arcu. Nec tincidunt praesent semper feugiat nibh sed. Platea dictumst quisque sagittis purus. Viverra nibh cras pulvinar mattis nunc sed blandit libero volutpat. In massa tempor nec feugiat nisl pretium fusce id.\\nEt egestas quis ipsum suspendisse ultrices gravida dictum. Posuere lorem ipsum dolor sit amet consectetur adipiscing elit duis. Nulla facilisi nullam vehicula ipsum a arcu. Egestas quis ipsum suspendisse ultrices gravida dictum fusce. Mauris sit amet massa vitae. Felis eget velit aliquet sagittis id consectetur purus. Purus sit amet luctus venenatis lectus magna. Rhoncus mattis rhoncus urna neque. Interdum velit euismod in pellentesque massa placerat. Sagittis nisl rhoncus mattis rhoncus urna neque. Ut diam quam nulla porttitor massa id. Molestie a iaculis at erat pellentesque adipiscing. Ac turpis egestas integer eget aliquet nibh praesent.\\nFringilla urna porttitor rhoncus dolor purus non enim praesent elementum. Nunc consequat interdum varius sit amet mattis vulputate enim nulla. Mi tempus imperdiet nulla malesuada pellentesque elit. Blandit turpis cursus in hac. Sed tempus urna et pharetra pharetra. Vitae justo eget magna fermentum iaculis eu non. Ac tortor dignissim convallis aenean et tortor. Velit sed ullamcorper morbi tincidunt. Aliquet eget sit amet tellus cras adipiscing enim eu. Consequat id porta nibh venenatis cras. Malesuada fames ac turpis egestas sed tempus urna et. Montes nascetur ridiculus mus mauris. Placerat orci nulla pellentesque dignissim enim sit amet venenatis urna. Aenean sed adipiscing diam donec adipiscing tristique risus nec. Nisl vel pretium lectus quam id leo in vitae turpis. Tincidunt ornare massa eget egestas.\\n\"}]}', '2023-01-13', 'publish', 'news16736647051193488404.png', 'Ihram Haji dan Umroh Bagian 2', 'Ihram Haji dan Umroh Bagian 2', 'Ihram Haji dan Umroh Bagian 2', 1, '2023-01-14 02:51:30', '2023-01-16 09:15:28', 1, 1),
(10, 'Ihram Haji dan Umroh Bagian 1', 'ihram-haji-dan-umroh-bagian-1', '{\"ops\":[{\"insert\":\"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Cursus mattis molestie a iaculis at erat pellentesque adipiscing commodo. Aliquam eleifend mi in nulla posuere sollicitudin aliquam. Suspendisse sed nisi lacus sed. Volutpat diam ut venenatis tellus in metus vulputate. Volutpat odio facilisis mauris sit amet massa vitae tortor condimentum. Nisl purus in mollis nunc. Eget dolor morbi non arcu risus. Leo urna molestie at elementum eu facilisis. Risus feugiat in ante metus dictum at tempor commodo. Viverra accumsan in nisl nisi scelerisque eu ultrices. Quis lectus nulla at volutpat diam ut venenatis tellus. Sed sed risus pretium quam.\\nSagittis vitae et leo duis ut diam. Suspendisse interdum consectetur libero id faucibus. Nulla porttitor massa id neque aliquam. Viverra aliquet eget sit amet tellus. Nulla facilisi cras fermentum odio eu feugiat pretium nibh. Nisi scelerisque eu ultrices vitae auctor eu. Ullamcorper a lacus vestibulum sed arcu. Tortor at auctor urna nunc id cursus metus. Neque egestas congue quisque egestas diam in arcu. Nec tincidunt praesent semper feugiat nibh sed. Platea dictumst quisque sagittis purus. Viverra nibh cras pulvinar mattis nunc sed blandit libero volutpat. In massa tempor nec feugiat nisl pretium fusce id.\\nEt egestas quis ipsum suspendisse ultrices gravida dictum. Posuere lorem ipsum dolor sit amet consectetur adipiscing elit duis. Nulla facilisi nullam vehicula ipsum a arcu. Egestas quis ipsum suspendisse ultrices gravida dictum fusce. Mauris sit amet massa vitae. Felis eget velit aliquet sagittis id consectetur purus. Purus sit amet luctus venenatis lectus magna. Rhoncus mattis rhoncus urna neque. Interdum velit euismod in pellentesque massa placerat. Sagittis nisl rhoncus mattis rhoncus urna neque. Ut diam quam nulla porttitor massa id. Molestie a iaculis at erat pellentesque adipiscing. Ac turpis egestas integer eget aliquet nibh praesent.\\nFringilla urna porttitor rhoncus dolor purus non enim praesent elementum. Nunc consequat interdum varius sit amet mattis vulputate enim nulla. Mi tempus imperdiet nulla malesuada pellentesque elit. Blandit turpis cursus in hac. Sed tempus urna et pharetra pharetra. Vitae justo eget magna fermentum iaculis eu non. Ac tortor dignissim convallis aenean et tortor. Velit sed ullamcorper morbi tincidunt. Aliquet eget sit amet tellus cras adipiscing enim eu. Consequat id porta nibh venenatis cras. Malesuada fames ac turpis egestas sed tempus urna et. Montes nascetur ridiculus mus mauris. Placerat orci nulla pellentesque dignissim enim sit amet venenatis urna. Aenean sed adipiscing diam donec adipiscing tristique risus nec. Nisl vel pretium lectus quam id leo in vitae turpis. Tincidunt ornare massa eget egestas.\\n\"}]}', '2023-01-14', 'publish', 'news1673664850631113452.png', 'Ihram Haji dan Umroh Bagian 1', 'Ihram Haji dan Umroh Bagian 1', 'Ihram Haji dan Umroh Bagian 1', 15, '2023-01-14 02:54:10', '2023-01-16 09:20:28', 1, 1),
(11, 'Ihram Haji dan Umroh Bagian 2', 'ihram-haji-dan-umroh-bagian-2', '{\"ops\":[{\"insert\":\"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Cursus mattis molestie a iaculis at erat pellentesque adipiscing commodo. Aliquam eleifend mi in nulla posuere sollicitudin aliquam. Suspendisse sed nisi lacus sed. Volutpat diam ut venenatis tellus in metus vulputate. Volutpat odio facilisis mauris sit amet massa vitae tortor condimentum. Nisl purus in mollis nunc. Eget dolor morbi non arcu risus. Leo urna molestie at elementum eu facilisis. Risus feugiat in ante metus dictum at tempor commodo. Viverra accumsan in nisl nisi scelerisque eu ultrices. Quis lectus nulla at volutpat diam ut venenatis tellus. Sed sed risus pretium quam.\\nSagittis vitae et leo duis ut diam. Suspendisse interdum consectetur libero id faucibus. Nulla porttitor massa id neque aliquam. Viverra aliquet eget sit amet tellus. Nulla facilisi cras fermentum odio eu feugiat pretium nibh. Nisi scelerisque eu ultrices vitae auctor eu. Ullamcorper a lacus vestibulum sed arcu. Tortor at auctor urna nunc id cursus metus. Neque egestas congue quisque egestas diam in arcu. Nec tincidunt praesent semper feugiat nibh sed. Platea dictumst quisque sagittis purus. Viverra nibh cras pulvinar mattis nunc sed blandit libero volutpat. In massa tempor nec feugiat nisl pretium fusce id.\\nEt egestas quis ipsum suspendisse ultrices gravida dictum. Posuere lorem ipsum dolor sit amet consectetur adipiscing elit duis. Nulla facilisi nullam vehicula ipsum a arcu. Egestas quis ipsum suspendisse ultrices gravida dictum fusce. Mauris sit amet massa vitae. Felis eget velit aliquet sagittis id consectetur purus. Purus sit amet luctus venenatis lectus magna. Rhoncus mattis rhoncus urna neque. Interdum velit euismod in pellentesque massa placerat. Sagittis nisl rhoncus mattis rhoncus urna neque. Ut diam quam nulla porttitor massa id. Molestie a iaculis at erat pellentesque adipiscing. Ac turpis egestas integer eget aliquet nibh praesent.\\nFringilla urna porttitor rhoncus dolor purus non enim praesent elementum. Nunc consequat interdum varius sit amet mattis vulputate enim nulla. Mi tempus imperdiet nulla malesuada pellentesque elit. Blandit turpis cursus in hac. Sed tempus urna et pharetra pharetra. Vitae justo eget magna fermentum iaculis eu non. Ac tortor dignissim convallis aenean et tortor. Velit sed ullamcorper morbi tincidunt. Aliquet eget sit amet tellus cras adipiscing enim eu. Consequat id porta nibh venenatis cras. Malesuada fames ac turpis egestas sed tempus urna et. Montes nascetur ridiculus mus mauris. Placerat orci nulla pellentesque dignissim enim sit amet venenatis urna. Aenean sed adipiscing diam donec adipiscing tristique risus nec. Nisl vel pretium lectus quam id leo in vitae turpis. Tincidunt ornare massa eget egestas.\\n\"}]}', '2023-01-13', 'publish', 'news16736647051193488404.png', 'Ihram Haji dan Umroh Bagian 2', 'Ihram Haji dan Umroh Bagian 2', 'Ihram Haji dan Umroh Bagian 2', 1, '2023-01-14 02:51:30', '2023-01-16 09:15:28', 1, 1),
(12, 'Ihram Haji dan Umroh Bagian 1', 'ihram-haji-dan-umroh-bagian-1', '{\"ops\":[{\"insert\":\"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Cursus mattis molestie a iaculis at erat pellentesque adipiscing commodo. Aliquam eleifend mi in nulla posuere sollicitudin aliquam. Suspendisse sed nisi lacus sed. Volutpat diam ut venenatis tellus in metus vulputate. Volutpat odio facilisis mauris sit amet massa vitae tortor condimentum. Nisl purus in mollis nunc. Eget dolor morbi non arcu risus. Leo urna molestie at elementum eu facilisis. Risus feugiat in ante metus dictum at tempor commodo. Viverra accumsan in nisl nisi scelerisque eu ultrices. Quis lectus nulla at volutpat diam ut venenatis tellus. Sed sed risus pretium quam.\\nSagittis vitae et leo duis ut diam. Suspendisse interdum consectetur libero id faucibus. Nulla porttitor massa id neque aliquam. Viverra aliquet eget sit amet tellus. Nulla facilisi cras fermentum odio eu feugiat pretium nibh. Nisi scelerisque eu ultrices vitae auctor eu. Ullamcorper a lacus vestibulum sed arcu. Tortor at auctor urna nunc id cursus metus. Neque egestas congue quisque egestas diam in arcu. Nec tincidunt praesent semper feugiat nibh sed. Platea dictumst quisque sagittis purus. Viverra nibh cras pulvinar mattis nunc sed blandit libero volutpat. In massa tempor nec feugiat nisl pretium fusce id.\\nEt egestas quis ipsum suspendisse ultrices gravida dictum. Posuere lorem ipsum dolor sit amet consectetur adipiscing elit duis. Nulla facilisi nullam vehicula ipsum a arcu. Egestas quis ipsum suspendisse ultrices gravida dictum fusce. Mauris sit amet massa vitae. Felis eget velit aliquet sagittis id consectetur purus. Purus sit amet luctus venenatis lectus magna. Rhoncus mattis rhoncus urna neque. Interdum velit euismod in pellentesque massa placerat. Sagittis nisl rhoncus mattis rhoncus urna neque. Ut diam quam nulla porttitor massa id. Molestie a iaculis at erat pellentesque adipiscing. Ac turpis egestas integer eget aliquet nibh praesent.\\nFringilla urna porttitor rhoncus dolor purus non enim praesent elementum. Nunc consequat interdum varius sit amet mattis vulputate enim nulla. Mi tempus imperdiet nulla malesuada pellentesque elit. Blandit turpis cursus in hac. Sed tempus urna et pharetra pharetra. Vitae justo eget magna fermentum iaculis eu non. Ac tortor dignissim convallis aenean et tortor. Velit sed ullamcorper morbi tincidunt. Aliquet eget sit amet tellus cras adipiscing enim eu. Consequat id porta nibh venenatis cras. Malesuada fames ac turpis egestas sed tempus urna et. Montes nascetur ridiculus mus mauris. Placerat orci nulla pellentesque dignissim enim sit amet venenatis urna. Aenean sed adipiscing diam donec adipiscing tristique risus nec. Nisl vel pretium lectus quam id leo in vitae turpis. Tincidunt ornare massa eget egestas.\\n\"}]}', '2023-01-14', 'publish', 'news1673664850631113452.png', 'Ihram Haji dan Umroh Bagian 1', 'Ihram Haji dan Umroh Bagian 1', 'Ihram Haji dan Umroh Bagian 1', 15, '2023-01-14 02:54:10', '2023-01-30 10:25:53', 1, 1),
(13, 'Ihram Haji dan Umroh Bagian 2', 'ihram-haji-dan-umroh-bagian-2', '{\"ops\":[{\"insert\":\"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Cursus mattis molestie a iaculis at erat pellentesque adipiscing commodo. Aliquam eleifend mi in nulla posuere sollicitudin aliquam. Suspendisse sed nisi lacus sed. Volutpat diam ut venenatis tellus in metus vulputate. Volutpat odio facilisis mauris sit amet massa vitae tortor condimentum. Nisl purus in mollis nunc. Eget dolor morbi non arcu risus. Leo urna molestie at elementum eu facilisis. Risus feugiat in ante metus dictum at tempor commodo. Viverra accumsan in nisl nisi scelerisque eu ultrices. Quis lectus nulla at volutpat diam ut venenatis tellus. Sed sed risus pretium quam.\\nSagittis vitae et leo duis ut diam. Suspendisse interdum consectetur libero id faucibus. Nulla porttitor massa id neque aliquam. Viverra aliquet eget sit amet tellus. Nulla facilisi cras fermentum odio eu feugiat pretium nibh. Nisi scelerisque eu ultrices vitae auctor eu. Ullamcorper a lacus vestibulum sed arcu. Tortor at auctor urna nunc id cursus metus. Neque egestas congue quisque egestas diam in arcu. Nec tincidunt praesent semper feugiat nibh sed. Platea dictumst quisque sagittis purus. Viverra nibh cras pulvinar mattis nunc sed blandit libero volutpat. In massa tempor nec feugiat nisl pretium fusce id.\\nEt egestas quis ipsum suspendisse ultrices gravida dictum. Posuere lorem ipsum dolor sit amet consectetur adipiscing elit duis. Nulla facilisi nullam vehicula ipsum a arcu. Egestas quis ipsum suspendisse ultrices gravida dictum fusce. Mauris sit amet massa vitae. Felis eget velit aliquet sagittis id consectetur purus. Purus sit amet luctus venenatis lectus magna. Rhoncus mattis rhoncus urna neque. Interdum velit euismod in pellentesque massa placerat. Sagittis nisl rhoncus mattis rhoncus urna neque. Ut diam quam nulla porttitor massa id. Molestie a iaculis at erat pellentesque adipiscing. Ac turpis egestas integer eget aliquet nibh praesent.\\nFringilla urna porttitor rhoncus dolor purus non enim praesent elementum. Nunc consequat interdum varius sit amet mattis vulputate enim nulla. Mi tempus imperdiet nulla malesuada pellentesque elit. Blandit turpis cursus in hac. Sed tempus urna et pharetra pharetra. Vitae justo eget magna fermentum iaculis eu non. Ac tortor dignissim convallis aenean et tortor. Velit sed ullamcorper morbi tincidunt. Aliquet eget sit amet tellus cras adipiscing enim eu. Consequat id porta nibh venenatis cras. Malesuada fames ac turpis egestas sed tempus urna et. Montes nascetur ridiculus mus mauris. Placerat orci nulla pellentesque dignissim enim sit amet venenatis urna. Aenean sed adipiscing diam donec adipiscing tristique risus nec. Nisl vel pretium lectus quam id leo in vitae turpis. Tincidunt ornare massa eget egestas.\\n\"}]}', '2023-01-13', 'publish', 'news16736647051193488404.png', 'Ihram Haji dan Umroh Bagian 2', 'Ihram Haji dan Umroh Bagian 2', 'Ihram Haji dan Umroh Bagian 2', 1, '2023-01-14 02:51:30', '2023-01-16 09:15:28', 1, 1),
(14, 'Ihram Haji dan Umroh Bagian 1', 'ihram-haji-dan-umroh-bagian-1', '{\"ops\":[{\"insert\":\"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Cursus mattis molestie a iaculis at erat pellentesque adipiscing commodo. Aliquam eleifend mi in nulla posuere sollicitudin aliquam. Suspendisse sed nisi lacus sed. Volutpat diam ut venenatis tellus in metus vulputate. Volutpat odio facilisis mauris sit amet massa vitae tortor condimentum. Nisl purus in mollis nunc. Eget dolor morbi non arcu risus. Leo urna molestie at elementum eu facilisis. Risus feugiat in ante metus dictum at tempor commodo. Viverra accumsan in nisl nisi scelerisque eu ultrices. Quis lectus nulla at volutpat diam ut venenatis tellus. Sed sed risus pretium quam.\\nSagittis vitae et leo duis ut diam. Suspendisse interdum consectetur libero id faucibus. Nulla porttitor massa id neque aliquam. Viverra aliquet eget sit amet tellus. Nulla facilisi cras fermentum odio eu feugiat pretium nibh. Nisi scelerisque eu ultrices vitae auctor eu. Ullamcorper a lacus vestibulum sed arcu. Tortor at auctor urna nunc id cursus metus. Neque egestas congue quisque egestas diam in arcu. Nec tincidunt praesent semper feugiat nibh sed. Platea dictumst quisque sagittis purus. Viverra nibh cras pulvinar mattis nunc sed blandit libero volutpat. In massa tempor nec feugiat nisl pretium fusce id.\\nEt egestas quis ipsum suspendisse ultrices gravida dictum. Posuere lorem ipsum dolor sit amet consectetur adipiscing elit duis. Nulla facilisi nullam vehicula ipsum a arcu. Egestas quis ipsum suspendisse ultrices gravida dictum fusce. Mauris sit amet massa vitae. Felis eget velit aliquet sagittis id consectetur purus. Purus sit amet luctus venenatis lectus magna. Rhoncus mattis rhoncus urna neque. Interdum velit euismod in pellentesque massa placerat. Sagittis nisl rhoncus mattis rhoncus urna neque. Ut diam quam nulla porttitor massa id. Molestie a iaculis at erat pellentesque adipiscing. Ac turpis egestas integer eget aliquet nibh praesent.\\nFringilla urna porttitor rhoncus dolor purus non enim praesent elementum. Nunc consequat interdum varius sit amet mattis vulputate enim nulla. Mi tempus imperdiet nulla malesuada pellentesque elit. Blandit turpis cursus in hac. Sed tempus urna et pharetra pharetra. Vitae justo eget magna fermentum iaculis eu non. Ac tortor dignissim convallis aenean et tortor. Velit sed ullamcorper morbi tincidunt. Aliquet eget sit amet tellus cras adipiscing enim eu. Consequat id porta nibh venenatis cras. Malesuada fames ac turpis egestas sed tempus urna et. Montes nascetur ridiculus mus mauris. Placerat orci nulla pellentesque dignissim enim sit amet venenatis urna. Aenean sed adipiscing diam donec adipiscing tristique risus nec. Nisl vel pretium lectus quam id leo in vitae turpis. Tincidunt ornare massa eget egestas.\\n\"}]}', '2023-01-14', 'publish', 'news1673664850631113452.png', 'Ihram Haji dan Umroh Bagian 1', 'Ihram Haji dan Umroh Bagian 1', 'Ihram Haji dan Umroh Bagian 1', 14, '2023-01-14 02:54:10', '2023-01-16 09:14:59', 1, 1),
(15, 'Ihram Haji dan Umroh Bagian 2', 'ihram-haji-dan-umroh-bagian-2', '{\"ops\":[{\"insert\":\"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Cursus mattis molestie a iaculis at erat pellentesque adipiscing commodo. Aliquam eleifend mi in nulla posuere sollicitudin aliquam. Suspendisse sed nisi lacus sed. Volutpat diam ut venenatis tellus in metus vulputate. Volutpat odio facilisis mauris sit amet massa vitae tortor condimentum. Nisl purus in mollis nunc. Eget dolor morbi non arcu risus. Leo urna molestie at elementum eu facilisis. Risus feugiat in ante metus dictum at tempor commodo. Viverra accumsan in nisl nisi scelerisque eu ultrices. Quis lectus nulla at volutpat diam ut venenatis tellus. Sed sed risus pretium quam.\\nSagittis vitae et leo duis ut diam. Suspendisse interdum consectetur libero id faucibus. Nulla porttitor massa id neque aliquam. Viverra aliquet eget sit amet tellus. Nulla facilisi cras fermentum odio eu feugiat pretium nibh. Nisi scelerisque eu ultrices vitae auctor eu. Ullamcorper a lacus vestibulum sed arcu. Tortor at auctor urna nunc id cursus metus. Neque egestas congue quisque egestas diam in arcu. Nec tincidunt praesent semper feugiat nibh sed. Platea dictumst quisque sagittis purus. Viverra nibh cras pulvinar mattis nunc sed blandit libero volutpat. In massa tempor nec feugiat nisl pretium fusce id.\\nEt egestas quis ipsum suspendisse ultrices gravida dictum. Posuere lorem ipsum dolor sit amet consectetur adipiscing elit duis. Nulla facilisi nullam vehicula ipsum a arcu. Egestas quis ipsum suspendisse ultrices gravida dictum fusce. Mauris sit amet massa vitae. Felis eget velit aliquet sagittis id consectetur purus. Purus sit amet luctus venenatis lectus magna. Rhoncus mattis rhoncus urna neque. Interdum velit euismod in pellentesque massa placerat. Sagittis nisl rhoncus mattis rhoncus urna neque. Ut diam quam nulla porttitor massa id. Molestie a iaculis at erat pellentesque adipiscing. Ac turpis egestas integer eget aliquet nibh praesent.\\nFringilla urna porttitor rhoncus dolor purus non enim praesent elementum. Nunc consequat interdum varius sit amet mattis vulputate enim nulla. Mi tempus imperdiet nulla malesuada pellentesque elit. Blandit turpis cursus in hac. Sed tempus urna et pharetra pharetra. Vitae justo eget magna fermentum iaculis eu non. Ac tortor dignissim convallis aenean et tortor. Velit sed ullamcorper morbi tincidunt. Aliquet eget sit amet tellus cras adipiscing enim eu. Consequat id porta nibh venenatis cras. Malesuada fames ac turpis egestas sed tempus urna et. Montes nascetur ridiculus mus mauris. Placerat orci nulla pellentesque dignissim enim sit amet venenatis urna. Aenean sed adipiscing diam donec adipiscing tristique risus nec. Nisl vel pretium lectus quam id leo in vitae turpis. Tincidunt ornare massa eget egestas.\\n\"}]}', '2023-01-13', 'publish', 'news16736647051193488404.png', 'Ihram Haji dan Umroh Bagian 2', 'Ihram Haji dan Umroh Bagian 2', 'Ihram Haji dan Umroh Bagian 2', 1, '2023-01-14 02:51:30', '2023-01-16 09:15:28', 1, 1);
INSERT INTO `news` (`id`, `title`, `slug`, `content`, `published_at`, `status`, `cover_media`, `meta_title`, `meta_keyword`, `meta_description`, `hitsview`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(16, 'Ihram Haji dan Umroh Bagian 1', 'ihram-haji-dan-umroh-bagian-1', '{\"ops\":[{\"insert\":\"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Cursus mattis molestie a iaculis at erat pellentesque adipiscing commodo. Aliquam eleifend mi in nulla posuere sollicitudin aliquam. Suspendisse sed nisi lacus sed. Volutpat diam ut venenatis tellus in metus vulputate. Volutpat odio facilisis mauris sit amet massa vitae tortor condimentum. Nisl purus in mollis nunc. Eget dolor morbi non arcu risus. Leo urna molestie at elementum eu facilisis. Risus feugiat in ante metus dictum at tempor commodo. Viverra accumsan in nisl nisi scelerisque eu ultrices. Quis lectus nulla at volutpat diam ut venenatis tellus. Sed sed risus pretium quam.\\nSagittis vitae et leo duis ut diam. Suspendisse interdum consectetur libero id faucibus. Nulla porttitor massa id neque aliquam. Viverra aliquet eget sit amet tellus. Nulla facilisi cras fermentum odio eu feugiat pretium nibh. Nisi scelerisque eu ultrices vitae auctor eu. Ullamcorper a lacus vestibulum sed arcu. Tortor at auctor urna nunc id cursus metus. Neque egestas congue quisque egestas diam in arcu. Nec tincidunt praesent semper feugiat nibh sed. Platea dictumst quisque sagittis purus. Viverra nibh cras pulvinar mattis nunc sed blandit libero volutpat. In massa tempor nec feugiat nisl pretium fusce id.\\nEt egestas quis ipsum suspendisse ultrices gravida dictum. Posuere lorem ipsum dolor sit amet consectetur adipiscing elit duis. Nulla facilisi nullam vehicula ipsum a arcu. Egestas quis ipsum suspendisse ultrices gravida dictum fusce. Mauris sit amet massa vitae. Felis eget velit aliquet sagittis id consectetur purus. Purus sit amet luctus venenatis lectus magna. Rhoncus mattis rhoncus urna neque. Interdum velit euismod in pellentesque massa placerat. Sagittis nisl rhoncus mattis rhoncus urna neque. Ut diam quam nulla porttitor massa id. Molestie a iaculis at erat pellentesque adipiscing. Ac turpis egestas integer eget aliquet nibh praesent.\\nFringilla urna porttitor rhoncus dolor purus non enim praesent elementum. Nunc consequat interdum varius sit amet mattis vulputate enim nulla. Mi tempus imperdiet nulla malesuada pellentesque elit. Blandit turpis cursus in hac. Sed tempus urna et pharetra pharetra. Vitae justo eget magna fermentum iaculis eu non. Ac tortor dignissim convallis aenean et tortor. Velit sed ullamcorper morbi tincidunt. Aliquet eget sit amet tellus cras adipiscing enim eu. Consequat id porta nibh venenatis cras. Malesuada fames ac turpis egestas sed tempus urna et. Montes nascetur ridiculus mus mauris. Placerat orci nulla pellentesque dignissim enim sit amet venenatis urna. Aenean sed adipiscing diam donec adipiscing tristique risus nec. Nisl vel pretium lectus quam id leo in vitae turpis. Tincidunt ornare massa eget egestas.\\n\"}]}', '2023-01-14', 'publish', 'news1673664850631113452.png', 'Ihram Haji dan Umroh Bagian 1', 'Ihram Haji dan Umroh Bagian 1', 'Ihram Haji dan Umroh Bagian 1', 14, '2023-01-14 02:54:10', '2023-01-16 09:14:59', 1, 1);

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

--
-- Table structure for table `news_tags`
--

CREATE TABLE `news_tags` (
  `id` bigint UNSIGNED NOT NULL,
  `news_id` bigint UNSIGNED DEFAULT NULL,
  `tags_id` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `news_tags`
--

INSERT INTO `news_tags` (`id`, `news_id`, `tags_id`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(20, 2, 2, '2023-01-16 09:09:40', '2023-01-16 09:09:40', 1, 1),
(21, 2, 3, '2023-01-16 09:09:40', '2023-01-16 09:09:40', 1, 1),
(22, 2, 4, '2023-01-16 09:09:40', '2023-01-16 09:09:40', 1, 1),
(23, 2, 5, '2023-01-16 09:09:40', '2023-01-16 09:09:40', 1, 1),
(24, 1, 2, '2023-01-16 09:09:47', '2023-01-16 09:09:47', 1, 1),
(25, 1, 3, '2023-01-16 09:09:47', '2023-01-16 09:09:47', 1, 1),
(26, 1, 4, '2023-01-16 09:09:47', '2023-01-16 09:09:47', 1, 1),
(27, 1, 5, '2023-01-16 09:09:47', '2023-01-16 09:09:47', 1, 1);

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

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

CREATE TABLE `packages` (
  `id` bigint UNSIGNED NOT NULL,
  `type` enum('umrah','haji') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cover_media` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_at` date NOT NULL,
  `end_at` date NOT NULL,
  `airline_departure` bigint UNSIGNED DEFAULT NULL,
  `airline_arrival` bigint UNSIGNED DEFAULT NULL,
  `tour_leader_id` bigint UNSIGNED DEFAULT NULL,
  `price_quad` int DEFAULT NULL,
  `price_triple` int DEFAULT NULL,
  `price_double` int DEFAULT NULL,
  `status` enum('draft','publish') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `packages` (`id`, `type`, `name`, `slug`, `cover_media`, `start_at`, `end_at`, `airline_departure`, `airline_arrival`, `tour_leader_id`, `price_quad`, `price_triple`, `price_double`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 'umrah', 'Umrah Awal Tahun', 'umrah-awal-tahun', 'package1.png', '2023-01-10', '2023-01-18', 1, 2, 1, 2000, 2100, 2200, 'publish', '2023-01-01 03:24:50', '2023-01-01 03:24:50', 1, 1),
(2, 'umrah', 'Umrah Awal Tahun 2', 'umrah-awal-tahun-2', 'package2.png', '2023-01-19', '2023-01-27', 1, 2, 1, 2000, 2100, 2200, 'publish', '2023-01-01 03:24:50', '2023-01-01 03:24:50', 1, 1),
(3, 'haji', 'Haji Plus', 'haji-plus', 'package1.png', '2023-01-10', '2023-01-18', 1, 2, 1, 2000, 2100, 2200, 'publish', '2023-01-01 03:24:50', '2023-01-01 03:24:50', 1, 1);

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

--
-- Table structure for table `package_hotels`
--

CREATE TABLE `package_hotels` (
  `id` bigint UNSIGNED NOT NULL,
  `package_id` bigint UNSIGNED DEFAULT NULL,
  `city_id` bigint UNSIGNED DEFAULT NULL,
  `hotel_id` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `package_hotels`
--

INSERT INTO `package_hotels` (`id`, `package_id`, `city_id`, `hotel_id`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 1, 1, 1, '2023-01-01 03:28:46', '2023-01-01 03:28:46', 1, 1),
(2, 1, 2, 2, '2023-01-01 03:28:46', '2023-01-01 03:28:46', 1, 1),
(3, 2, 1, 1, '2023-01-01 03:28:46', '2023-01-01 03:28:46', 1, 1),
(4, 2, 2, 2, '2023-01-01 03:28:46', '2023-01-01 03:28:46', 1, 1),
(5, 1, 3, 3, '2023-01-14 05:03:56', '2023-01-14 05:03:56', 1, 1),
(7, 1, 4, 3, '2023-01-14 05:03:56', '2023-01-14 05:03:56', 1, 1),
(8, 1, 5, 3, '2023-01-14 05:03:56', '2023-01-14 05:03:56', 1, 1),
(9, 1, 6, 3, '2023-01-14 05:03:56', '2023-01-14 05:03:56', 1, 1),
(10, 1, 7, 3, '2023-01-14 05:03:56', '2023-01-14 05:03:56', 1, 1),
(11, 1, 8, 3, '2023-01-14 05:03:56', '2023-01-14 05:03:56', 1, 1),
(12, 1, 9, 3, '2023-01-14 05:03:56', '2023-01-14 05:03:56', 1, 1),
(13, 2, 3, 3, '2023-01-14 05:03:56', '2023-01-14 05:03:56', 1, 1),
(14, 2, 4, 3, '2023-01-14 05:03:56', '2023-01-14 05:03:56', 1, 1),
(15, 2, 5, 3, '2023-01-14 05:03:56', '2023-01-14 05:03:56', 1, 1),
(16, 2, 6, 3, '2023-01-14 05:03:56', '2023-01-14 05:03:56', 1, 1),
(17, 2, 7, 3, '2023-01-14 05:03:56', '2023-01-14 05:03:56', 1, 1),
(18, 2, 8, 3, '2023-01-14 05:03:56', '2023-01-14 05:03:56', 1, 1),
(19, 2, 9, 3, '2023-01-14 05:03:56', '2023-01-14 05:03:56', 1, 1);

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

--
-- Table structure for table `package_register_hajjs`
--

CREATE TABLE `package_register_hajjs` (
  `id` bigint UNSIGNED NOT NULL,
  `package_id` bigint UNSIGNED NOT NULL,
  `no_ktp` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `father_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `birthplace` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `birthdate` date NOT NULL,
  `gender` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `citizenship` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `province_id` bigint UNSIGNED DEFAULT NULL,
  `local_city_id` bigint UNSIGNED DEFAULT NULL,
  `district_id` bigint UNSIGNED DEFAULT NULL,
  `sub_district_id` bigint UNSIGNED DEFAULT NULL,
  `post_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `education` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `occupation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `going_hajj` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mahram_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mahram_relation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `blood_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `whatsapp` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hair` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `face` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eyebrow` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nose` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `height` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `weight` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `package_register_hajjs`
--

INSERT INTO `package_register_hajjs` (`id`, `package_id`, `no_ktp`, `name`, `father_name`, `birthplace`, `birthdate`, `gender`, `citizenship`, `address`, `province_id`, `local_city_id`, `district_id`, `sub_district_id`, `post_code`, `education`, `occupation`, `going_hajj`, `mahram_name`, `mahram_relation`, `blood_type`, `whatsapp`, `email`, `hair`, `face`, `eyebrow`, `nose`, `height`, `weight`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 3, '3217012107870001', 'Wisnu Hafid', 'Sutisna', 'Bandung', '1987-07-21', 'male', 'wni', 'JL. Taman Merkuri Timur VI No.15\r\nRT.03 RW.04\r\nKEL.MANJAHLEGA', 9, 1, 1, 1, '40295', 's1', '6', '2', 'wisnu', '1', 'A', '08976660502', 'webhadecreative@gmail.com', '1', '1', '2', '1', '180', '60', '2023-01-31 11:18:59', '2023-01-31 11:18:59', NULL, NULL);

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

--
-- Table structure for table `package_register_umrahs`
--

CREATE TABLE `package_register_umrahs` (
  `id` bigint UNSIGNED NOT NULL,
  `package_id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `father_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `identity_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `identity_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `passport_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `passport_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `passport_date` date NOT NULL,
  `passport_city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `birthplace` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `birthdate` date NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `province_id` bigint UNSIGNED DEFAULT NULL,
  `local_city_id` bigint UNSIGNED DEFAULT NULL,
  `district_id` bigint UNSIGNED DEFAULT NULL,
  `sub_district_id` bigint UNSIGNED DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `whatsapp` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `citizenship` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `marital_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `education` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `occupation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `package_register_umrahs`
--

INSERT INTO `package_register_umrahs` (`id`, `package_id`, `title`, `name`, `father_name`, `identity_type`, `identity_number`, `passport_name`, `passport_number`, `passport_date`, `passport_city`, `birthplace`, `birthdate`, `address`, `province_id`, `local_city_id`, `district_id`, `sub_district_id`, `phone`, `whatsapp`, `citizenship`, `marital_status`, `education`, `occupation`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 1, 'mr', 'Wisnu Hafid', 'Sutisna', 'ktp', '3217012107870001', 'Wisnu Hafid', '1234567890', '2023-01-01', 'Bandung', 'Bandung', '1987-07-21', 'JL. Taman Merkuri Timur VI No.15\r\nRT.03 RW.04\r\nKEL.MANJAHLEGA', 9, 1, 1, 1, '08976660502', '081321425825', 'wni', '1', 's1', '6', '2023-01-31 11:16:16', '2023-01-31 11:16:16', NULL, NULL);

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

--
-- Table structure for table `package_services`
--

CREATE TABLE `package_services` (
  `id` bigint UNSIGNED NOT NULL,
  `package_id` bigint UNSIGNED DEFAULT NULL,
  `type` enum('include','exclude') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `service_id` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `package_services`
--

INSERT INTO `package_services` (`id`, `package_id`, `type`, `service_id`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 1, 'include', 1, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(2, 1, 'include', 2, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(3, 1, 'include', 3, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(4, 1, 'include', 4, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(5, 1, 'include', 5, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(6, 1, 'include', 6, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(7, 1, 'include', 7, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(8, 1, 'include', 8, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(9, 1, 'include', 9, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(10, 1, 'include', 10, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(11, 2, 'include', 1, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(12, 2, 'include', 2, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(13, 2, 'include', 3, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(14, 2, 'include', 4, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(15, 2, 'include', 5, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(16, 2, 'include', 6, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(17, 2, 'include', 7, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(18, 2, 'include', 8, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(19, 2, 'include', 9, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(20, 2, 'include', 10, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(21, 1, 'exclude', 11, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(22, 1, 'exclude', 12, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(23, 1, 'exclude', 13, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(24, 1, 'exclude', 14, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(25, 1, 'exclude', 15, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(26, 1, 'exclude', 16, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(27, 1, 'exclude', 17, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(28, 2, 'exclude', 11, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(29, 2, 'exclude', 12, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(30, 2, 'exclude', 13, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(31, 2, 'exclude', 14, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(32, 2, 'exclude', 15, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(33, 2, 'exclude', 16, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1),
(34, 2, 'exclude', 17, '2023-01-16 03:38:06', '2023-01-16 03:38:06', 1, 1);

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

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

CREATE TABLE `pages` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('draft','publish') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_keyword` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `photo_galleries`
--

CREATE TABLE `photo_galleries` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cover_media` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('draft','publish') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `photo_galleries`
--

INSERT INTO `photo_galleries` (`id`, `name`, `cover_media`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 'photo 1', 'photo1.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1),
(2, 'photo 2', 'photo2.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1),
(3, 'photo 3', 'photo3.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1),
(4, 'photo 1', 'photo2.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1),
(5, 'photo 2', 'photo1.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1),
(6, 'photo 3', 'photo3.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1),
(7, 'photo 1', 'photo3.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1),
(8, 'photo 2', 'photo2.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1),
(9, 'photo 3', 'photo1.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1),
(10, 'photo 1', 'photo1.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1),
(11, 'photo 2', 'photo2.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1),
(12, 'photo 3', 'photo3.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1),
(13, 'photo 1', 'photo1.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1),
(14, 'photo 2', 'photo2.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1),
(15, 'photo 3', 'photo3.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1),
(16, 'photo 1', 'photo1.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1),
(17, 'photo 2', 'photo2.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1),
(18, 'photo 3', 'photo3.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1),
(19, 'photo 1', 'photo1.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1),
(20, 'photo 2', 'photo2.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1),
(21, 'photo 3', 'photo3.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1),
(22, 'photo 1', 'photo1.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1),
(23, 'photo 2', 'photo2.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1),
(24, 'photo 3', 'photo3.png', 'publish', '2023-01-06 19:22:32', '2023-01-06 19:22:32', 1, 1);

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

--
-- Table structure for table `provinces`
--

CREATE TABLE `provinces` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `provinces`
--

INSERT INTO `provinces` (`id`, `name`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 'Bali', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(2, 'Bangka Belitung', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(3, 'Banten', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(4, 'Bengkulu', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(5, 'DI Yogyakarta', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(6, 'DKI Jakarta', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(7, 'Gorontalo', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(8, 'Jambi', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(9, 'Jawa Barat', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(10, 'Jawa Tengah', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(11, 'Jawa Timur', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(12, 'Kalimantan Barat', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(13, 'Kalimantan Selatan', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(14, 'Kalimantan Tengah', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(15, 'Kalimantan Timur', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(16, 'Kalimantan Utara', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(17, 'Kepulauan Riau', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(18, 'Lampung', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(19, 'Maluku', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(20, 'Maluku Utara', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(21, 'Nanggroe Aceh Darussalam (NAD)', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(22, 'Nusa Tenggara Barat (NTB)', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(23, 'Nusa Tenggara Timur (NTT)', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(24, 'Papua', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(25, 'Papua Barat', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(26, 'Riau', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(27, 'Sulawesi Barat', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(28, 'Sulawesi Selatan', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(29, 'Sulawesi Tengah', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(30, 'Sulawesi Tenggara', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(31, 'Sulawesi Utara', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(32, 'Sumatera Barat', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(33, 'Sumatera Selatan', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(34, 'Sumatera Utara', '2023-01-07 09:06:12', '2023-01-07 09:06:12', 1, 1),
(35, 'Papua Tengah', '2023-01-07 09:07:44', '2023-01-07 09:07:44', 1, 1),
(36, 'Papua Pegunungan', '2023-01-07 09:07:44', '2023-01-07 09:07:44', 1, 1),
(37, 'Papua Selatan', '2023-01-07 09:07:44', '2023-01-07 09:07:44', 1, 1),
(38, 'Papua Barat Daya', '2023-01-07 09:07:44', '2023-01-07 09:07:44', 1, 1);

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

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

CREATE TABLE `services` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `services` (`id`, `name`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 'Tiket Pesawat Ekonomi PP', '2023-01-16 03:22:47', '2023-01-16 03:22:47', 1, 1),
(2, 'Visa', '2023-01-16 03:22:47', '2023-01-16 03:22:47', 1, 1),
(3, 'Hotel sesuai pilihan paket', '2023-01-16 03:22:47', '2023-01-16 03:22:47', 1, 1),
(4, 'Makan 3x sehari', '2023-01-16 03:22:47', '2023-01-16 03:22:47', 1, 1),
(5, 'Handling', '2023-01-16 03:22:47', '2023-01-16 03:22:47', 1, 1),
(6, 'Bus AC', '2023-01-16 03:22:47', '2023-01-16 03:22:47', 1, 1),
(7, 'Muthawwif', '2023-01-16 03:22:47', '2023-01-16 03:22:47', 1, 1),
(8, 'Pembimbing (Tour Leader)', '2023-01-16 03:22:47', '2023-01-16 03:22:47', 1, 1),
(9, 'City Tour Mekkah & Madinah', '2023-01-16 03:22:47', '2023-01-16 03:22:47', 1, 1),
(10, 'Manasik Umroh', '2023-01-16 03:22:47', '2023-01-16 03:22:47', 1, 1),
(11, 'Kelebihan Bagasi', '2023-01-16 03:22:47', '2023-01-16 03:22:47', 1, 1),
(12, 'Extra Bill untuk Laundry, Telepon, dll', '2023-01-16 03:22:47', '2023-01-16 03:22:47', 1, 1),
(13, 'Tour tambahan diluar Program', '2023-01-16 03:22:47', '2023-01-16 03:22:47', 1, 1),
(14, 'Biaya Pembuatan Passport dan Suntik Meningitis', '2023-01-16 03:22:47', '2023-01-16 03:22:47', 1, 1),
(15, 'Layanan khusus kursi roda dan jasa pendorong', '2023-01-16 03:22:47', '2023-01-16 03:22:47', 1, 1),
(16, 'Transportasi lokal PP (transprotasi, akomodasi dari luar Jakarta)', '2023-01-16 03:22:47', '2023-01-16 03:22:47', 1, 1),
(17, 'Pengurusan Passport', '2023-01-16 03:22:47', '2023-01-16 03:22:47', 1, 1);

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

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `cover_media` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `button_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` int DEFAULT NULL,
  `status` enum('draft','publish') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` (`id`, `name`, `cover_media`, `title`, `subtitle`, `description`, `button_text`, `button_link`, `position`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 'slide 1', 'slide1.png', 'Umrah Akhir Tahun', 'Desember 2022', 'Booking dari sekarang yuk!', 'info lengkap', '#', 1, 'publish', '2023-01-14 06:32:49', '2023-01-26 03:29:25', 1, 1),
(2, 'slide 2', 'slide2.png', 'Umrah Akhir Tahun', 'Desember 2022', 'Booking dari sekarang yuk!', 'info lengkap', '#', 2, 'publish', '2023-01-14 06:32:49', '2023-01-14 06:32:49', 1, 1),
(3, 'slide 3', 'slide3.png', 'Umrah Akhir Tahun', 'Desember 2022', 'Booking dari sekarang yuk!', 'info lengkap', '#', 3, 'publish', '2023-01-14 06:32:49', '2023-01-14 06:32:49', 1, 1);

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

--
-- Table structure for table `sub_districts`
--

CREATE TABLE `sub_districts` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `province_id` bigint UNSIGNED DEFAULT NULL,
  `local_city_id` bigint UNSIGNED DEFAULT NULL,
  `district_id` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sub_districts`
--

INSERT INTO `sub_districts` (`id`, `name`, `province_id`, `local_city_id`, `district_id`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 'Manjahlega', 9, 1, 1, '2023-01-07 08:25:20', '2023-01-07 08:25:20', 1, 1),
(3, 'Kayuambon', 9, 3, 3, '2023-01-30 10:16:40', '2023-01-30 10:16:40', 1, 1);

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

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tags`
--

INSERT INTO `tags` (`id`, `name`, `slug`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(2, 'ihram', 'ihram', '2023-01-14 02:53:16', '2023-01-14 02:53:16', 1, 1),
(3, 'haji', 'haji', '2023-01-14 02:53:16', '2023-01-14 02:53:16', 1, 1),
(4, 'umrah', 'umrah', '2023-01-14 02:53:16', '2023-01-14 02:53:16', 1, 1),
(5, 'umroh', 'umroh', '2023-01-14 02:53:16', '2023-01-14 02:53:16', 1, 1);

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

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rating` int NOT NULL,
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('draft','publish') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`id`, `name`, `message`, `rating`, `avatar`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 'Wisnu Hafid', 'Lorem ipsum dolor sit amet consectetur. Consequat adipiscing dignissim venenatis arcu sagittis faucibus viverra. Lectus lacus pellentesque nibh bibendum.', 4, NULL, 'publish', '2023-01-07 14:44:42', '2023-01-07 14:44:42', 1, 1),
(2, 'Wisnu Hafid', 'Lorem ipsum dolor sit amet consectetur. Consequat adipiscing dignissim venenatis arcu sagittis faucibus viverra. Lectus lacus pellentesque nibh bibendum.', 5, 'avatar.png', 'publish', '2023-01-07 14:44:42', '2023-01-07 14:44:42', 1, 1),
(3, 'Arganta', 'Lorem ipsum dolor sit amet consectetur. Consequat adipiscing dignissim venenatis arcu sagittis faucibus viverra. Lectus lacus pellentesque nibh bibendum.', 3, NULL, 'publish', '2023-01-07 14:44:42', '2023-01-07 14:44:42', 1, 1),
(4, 'Wisnu Hafid', 'Lorem ipsum dolor sit amet consectetur. Consequat adipiscing dignissim venenatis arcu sagittis faucibus viverra. Lectus lacus pellentesque nibh bibendum.', 4, NULL, 'publish', '2023-01-07 14:44:42', '2023-01-07 14:44:42', 1, 1),
(5, 'Wisnu Hafid', 'Lorem ipsum dolor sit amet consectetur. Consequat adipiscing dignissim venenatis arcu sagittis faucibus viverra. Lectus lacus pellentesque nibh bibendum.', 5, 'avatar.png', 'publish', '2023-01-07 14:44:42', '2023-01-07 14:44:42', 1, 1),
(6, 'Arganta', 'Lorem ipsum dolor sit amet consectetur. Consequat adipiscing dignissim venenatis arcu sagittis faucibus viverra. Lectus lacus pellentesque nibh bibendum.', 3, NULL, 'publish', '2023-01-07 14:44:42', '2023-01-07 14:44:42', 1, 1),
(7, 'Wisnu Hafid', 'Lorem ipsum dolor sit amet consectetur. Consequat adipiscing dignissim venenatis arcu sagittis faucibus viverra. Lectus lacus pellentesque nibh bibendum.', 4, NULL, 'publish', '2023-01-07 14:44:42', '2023-01-07 14:44:42', 1, 1),
(8, 'Wisnu Hafid', 'Lorem ipsum dolor sit amet consectetur. Consequat adipiscing dignissim venenatis arcu sagittis faucibus viverra. Lectus lacus pellentesque nibh bibendum.', 5, 'avatar.png', 'publish', '2023-01-07 14:44:42', '2023-01-07 14:44:42', 1, 1),
(9, 'Arganta', 'Lorem ipsum dolor sit amet consectetur. Consequat adipiscing dignissim venenatis arcu sagittis faucibus viverra. Lectus lacus pellentesque nibh bibendum.', 3, NULL, 'publish', '2023-01-07 14:44:42', '2023-01-07 14:44:42', 1, 1),
(10, 'Wisnu Hafid', 'Lorem ipsum dolor sit amet consectetur. Consequat adipiscing dignissim venenatis arcu sagittis faucibus viverra. Lectus lacus pellentesque nibh bibendum.', 4, NULL, 'publish', '2023-01-07 14:44:42', '2023-01-07 14:44:42', 1, 1),
(11, 'Wisnu Hafid', 'Lorem ipsum dolor sit amet consectetur. Consequat adipiscing dignissim venenatis arcu sagittis faucibus viverra. Lectus lacus pellentesque nibh bibendum.', 5, 'avatar.png', 'publish', '2023-01-07 14:44:42', '2023-01-07 14:44:42', 1, 1),
(12, 'Arganta', 'Lorem ipsum dolor sit amet consectetur. Consequat adipiscing dignissim venenatis arcu sagittis faucibus viverra. Lectus lacus pellentesque nibh bibendum.', 3, NULL, 'publish', '2023-01-07 14:44:42', '2023-01-07 14:44:42', 1, 1);

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

--
-- Table structure for table `tour_leaders`
--

CREATE TABLE `tour_leaders` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `cover_media` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tour_leaders`
--

INSERT INTO `tour_leaders` (`id`, `name`, `cover_media`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 'Ust. DR. Abdullah Roy, MA.', 'tourleader16747200891856644375.png', '2023-01-14 03:23:58', '2023-01-26 08:01:29', 1, 1);

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

--
-- Table structure for table `video_galleries`
--

CREATE TABLE `video_galleries` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cover_media` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('draft','publish') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `video_galleries`
--

INSERT INTO `video_galleries` (`id`, `name`, `url`, `cover_media`, `video_file`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 'test youtube', 'https://www.youtube.com/watch?v=KPzsQAcXRP4', NULL, NULL, 'publish', '2023-01-07 02:37:15', '2023-01-07 02:37:15', 1, 1),
(2, 'test video upload', NULL, 'video.jpg', 'video.mp4', 'publish', '2023-01-07 02:37:45', '2023-01-30 14:35:25', 1, 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `airlines`
--
ALTER TABLE `airlines`
  ADD PRIMARY KEY (`id`),
  ADD KEY `airlines_created_by_foreign` (`created_by`),
  ADD KEY `airlines_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `cities`
--
ALTER TABLE `cities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cities_created_by_foreign` (`created_by`),
  ADD KEY `cities_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `configs`
--
ALTER TABLE `configs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `configs_created_by_foreign` (`created_by`),
  ADD KEY `configs_updated_by_foreign` (`updated_by`);

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

--
-- Indexes for table `districts`
--
ALTER TABLE `districts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `districts_province_id_foreign` (`province_id`),
  ADD KEY `districts_local_city_id_foreign` (`local_city_id`),
  ADD KEY `districts_created_by_foreign` (`created_by`),
  ADD KEY `districts_updated_by_foreign` (`updated_by`);

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

--
-- Indexes for table `hotels`
--
ALTER TABLE `hotels`
  ADD PRIMARY KEY (`id`),
  ADD KEY `hotels_created_by_foreign` (`created_by`),
  ADD KEY `hotels_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `local_cities`
--
ALTER TABLE `local_cities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `local_cities_province_id_foreign` (`province_id`),
  ADD KEY `local_cities_created_by_foreign` (`created_by`),
  ADD KEY `local_cities_updated_by_foreign` (`updated_by`);

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

--
-- Indexes for table `news`
--
ALTER TABLE `news`
  ADD PRIMARY KEY (`id`),
  ADD KEY `news_created_by_foreign` (`created_by`),
  ADD KEY `news_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `news_tags`
--
ALTER TABLE `news_tags`
  ADD PRIMARY KEY (`id`),
  ADD KEY `news_tags_news_id_foreign` (`news_id`),
  ADD KEY `news_tags_tags_id_foreign` (`tags_id`),
  ADD KEY `news_tags_created_by_foreign` (`created_by`),
  ADD KEY `news_tags_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `packages`
--
ALTER TABLE `packages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `packages_airline_departure_foreign` (`airline_departure`),
  ADD KEY `packages_airline_arrival_foreign` (`airline_arrival`),
  ADD KEY `packages_tour_leader_id_foreign` (`tour_leader_id`),
  ADD KEY `packages_created_by_foreign` (`created_by`),
  ADD KEY `packages_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `package_hotels`
--
ALTER TABLE `package_hotels`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_hotels_package_id_foreign` (`package_id`),
  ADD KEY `package_hotels_city_id_foreign` (`city_id`),
  ADD KEY `package_hotels_hotel_id_foreign` (`hotel_id`),
  ADD KEY `package_hotels_created_by_foreign` (`created_by`),
  ADD KEY `package_hotels_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `package_register_hajjs`
--
ALTER TABLE `package_register_hajjs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_register_hajjs_package_id_foreign` (`package_id`),
  ADD KEY `package_register_hajjs_province_id_foreign` (`province_id`),
  ADD KEY `package_register_hajjs_local_city_id_foreign` (`local_city_id`),
  ADD KEY `package_register_hajjs_district_id_foreign` (`district_id`),
  ADD KEY `package_register_hajjs_sub_district_id_foreign` (`sub_district_id`),
  ADD KEY `package_register_hajjs_created_by_foreign` (`created_by`),
  ADD KEY `package_register_hajjs_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `package_register_umrahs`
--
ALTER TABLE `package_register_umrahs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_register_umrahs_package_id_foreign` (`package_id`),
  ADD KEY `package_register_umrahs_province_id_foreign` (`province_id`),
  ADD KEY `package_register_umrahs_local_city_id_foreign` (`local_city_id`),
  ADD KEY `package_register_umrahs_district_id_foreign` (`district_id`),
  ADD KEY `package_register_umrahs_sub_district_id_foreign` (`sub_district_id`),
  ADD KEY `package_register_umrahs_created_by_foreign` (`created_by`),
  ADD KEY `package_register_umrahs_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `package_services`
--
ALTER TABLE `package_services`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_services_package_id_foreign` (`package_id`),
  ADD KEY `package_services_service_id_foreign` (`service_id`),
  ADD KEY `package_services_created_by_foreign` (`created_by`),
  ADD KEY `package_services_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pages_created_by_foreign` (`created_by`),
  ADD KEY `pages_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `photo_galleries`
--
ALTER TABLE `photo_galleries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `photo_galleries_created_by_foreign` (`created_by`),
  ADD KEY `photo_galleries_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `provinces`
--
ALTER TABLE `provinces`
  ADD PRIMARY KEY (`id`),
  ADD KEY `provinces_created_by_foreign` (`created_by`),
  ADD KEY `provinces_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`),
  ADD KEY `services_created_by_foreign` (`created_by`),
  ADD KEY `services_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `sliders`
--
ALTER TABLE `sliders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sliders_created_by_foreign` (`created_by`),
  ADD KEY `sliders_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `sub_districts`
--
ALTER TABLE `sub_districts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sub_districts_province_id_foreign` (`province_id`),
  ADD KEY `sub_districts_local_city_id_foreign` (`local_city_id`),
  ADD KEY `sub_districts_district_id_foreign` (`district_id`),
  ADD KEY `sub_districts_created_by_foreign` (`created_by`),
  ADD KEY `sub_districts_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `tags`
--
ALTER TABLE `tags`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tags_created_by_foreign` (`created_by`),
  ADD KEY `tags_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `testimonials`
--
ALTER TABLE `testimonials`
  ADD PRIMARY KEY (`id`),
  ADD KEY `testimonials_created_by_foreign` (`created_by`),
  ADD KEY `testimonials_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `tour_leaders`
--
ALTER TABLE `tour_leaders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tour_leaders_created_by_foreign` (`created_by`),
  ADD KEY `tour_leaders_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `video_galleries`
--
ALTER TABLE `video_galleries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `video_galleries_created_by_foreign` (`created_by`),
  ADD KEY `video_galleries_updated_by_foreign` (`updated_by`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `airlines`
--
ALTER TABLE `airlines`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `cities`
--
ALTER TABLE `cities`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `configs`
--
ALTER TABLE `configs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=181;

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

--
-- AUTO_INCREMENT for table `districts`
--
ALTER TABLE `districts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

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

--
-- AUTO_INCREMENT for table `hotels`
--
ALTER TABLE `hotels`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `local_cities`
--
ALTER TABLE `local_cities`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `news_tags`
--
ALTER TABLE `news_tags`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `packages`
--
ALTER TABLE `packages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `package_hotels`
--
ALTER TABLE `package_hotels`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `package_register_hajjs`
--
ALTER TABLE `package_register_hajjs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `package_register_umrahs`
--
ALTER TABLE `package_register_umrahs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `package_services`
--
ALTER TABLE `package_services`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `photo_galleries`
--
ALTER TABLE `photo_galleries`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `provinces`
--
ALTER TABLE `provinces`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `sub_districts`
--
ALTER TABLE `sub_districts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tags`
--
ALTER TABLE `tags`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `tour_leaders`
--
ALTER TABLE `tour_leaders`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `video_galleries`
--
ALTER TABLE `video_galleries`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `airlines`
--
ALTER TABLE `airlines`
  ADD CONSTRAINT `airlines_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `airlines_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `cities`
--
ALTER TABLE `cities`
  ADD CONSTRAINT `cities_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `cities_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `configs`
--
ALTER TABLE `configs`
  ADD CONSTRAINT `configs_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `configs_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `districts`
--
ALTER TABLE `districts`
  ADD CONSTRAINT `districts_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `districts_local_city_id_foreign` FOREIGN KEY (`local_city_id`) REFERENCES `local_cities` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `districts_province_id_foreign` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `districts_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `hotels`
--
ALTER TABLE `hotels`
  ADD CONSTRAINT `hotels_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `hotels_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `local_cities`
--
ALTER TABLE `local_cities`
  ADD CONSTRAINT `local_cities_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `local_cities_province_id_foreign` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `local_cities_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `news`
--
ALTER TABLE `news`
  ADD CONSTRAINT `news_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `news_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `news_tags`
--
ALTER TABLE `news_tags`
  ADD CONSTRAINT `news_tags_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `news_tags_news_id_foreign` FOREIGN KEY (`news_id`) REFERENCES `news` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `news_tags_tags_id_foreign` FOREIGN KEY (`tags_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `news_tags_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `packages`
--
ALTER TABLE `packages`
  ADD CONSTRAINT `packages_airline_arrival_foreign` FOREIGN KEY (`airline_arrival`) REFERENCES `airlines` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `packages_airline_departure_foreign` FOREIGN KEY (`airline_departure`) REFERENCES `airlines` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `packages_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `packages_tour_leader_id_foreign` FOREIGN KEY (`tour_leader_id`) REFERENCES `tour_leaders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `packages_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `package_hotels`
--
ALTER TABLE `package_hotels`
  ADD CONSTRAINT `package_hotels_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_hotels_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_hotels_hotel_id_foreign` FOREIGN KEY (`hotel_id`) REFERENCES `hotels` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_hotels_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_hotels_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `package_register_hajjs`
--
ALTER TABLE `package_register_hajjs`
  ADD CONSTRAINT `package_register_hajjs_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_register_hajjs_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_register_hajjs_local_city_id_foreign` FOREIGN KEY (`local_city_id`) REFERENCES `local_cities` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_register_hajjs_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_register_hajjs_province_id_foreign` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_register_hajjs_sub_district_id_foreign` FOREIGN KEY (`sub_district_id`) REFERENCES `sub_districts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_register_hajjs_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `package_register_umrahs`
--
ALTER TABLE `package_register_umrahs`
  ADD CONSTRAINT `package_register_umrahs_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_register_umrahs_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_register_umrahs_local_city_id_foreign` FOREIGN KEY (`local_city_id`) REFERENCES `local_cities` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_register_umrahs_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_register_umrahs_province_id_foreign` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_register_umrahs_sub_district_id_foreign` FOREIGN KEY (`sub_district_id`) REFERENCES `sub_districts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_register_umrahs_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `package_services`
--
ALTER TABLE `package_services`
  ADD CONSTRAINT `package_services_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_services_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_services_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_services_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `pages`
--
ALTER TABLE `pages`
  ADD CONSTRAINT `pages_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `pages_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `photo_galleries`
--
ALTER TABLE `photo_galleries`
  ADD CONSTRAINT `photo_galleries_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `photo_galleries_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `provinces`
--
ALTER TABLE `provinces`
  ADD CONSTRAINT `provinces_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `provinces_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `services`
--
ALTER TABLE `services`
  ADD CONSTRAINT `services_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `services_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sliders`
--
ALTER TABLE `sliders`
  ADD CONSTRAINT `sliders_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `sliders_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sub_districts`
--
ALTER TABLE `sub_districts`
  ADD CONSTRAINT `sub_districts_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `sub_districts_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `sub_districts_local_city_id_foreign` FOREIGN KEY (`local_city_id`) REFERENCES `local_cities` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `sub_districts_province_id_foreign` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `sub_districts_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tags`
--
ALTER TABLE `tags`
  ADD CONSTRAINT `tags_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tags_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `testimonials`
--
ALTER TABLE `testimonials`
  ADD CONSTRAINT `testimonials_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `testimonials_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tour_leaders`
--
ALTER TABLE `tour_leaders`
  ADD CONSTRAINT `tour_leaders_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tour_leaders_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `video_galleries`
--
ALTER TABLE `video_galleries`
  ADD CONSTRAINT `video_galleries_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `video_galleries_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

