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

START TRANSACTION;



--
-- Database: `ispwebapp`
--

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

--
-- Table structure for table `about_us`
--

CREATE TABLE `about_us` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `aboutUs` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `our_values` mediumtext 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;

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

--
-- Table structure for table `apply_job`
--

CREATE TABLE `apply_job` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `cv` varchar(255) DEFAULT NULL,
  `apply_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `banners`
--

CREATE TABLE `banners` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `banner_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int(11) DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `banners`
--

INSERT INTO `banners` (`id`, `banner_image`, `order`, `title`, `details`, `created_at`, `updated_at`, `deleted_at`) VALUES
(29, '20211016080353-a.jpg', 1, 'Linkup Communication', '<p style=\"margin: 0px 0px 6px; font-family: Helvetica, Arial, sans-serif; color: #1c1e21; font-size: 14px; background-color: #ffffff;\">আপনাদের সুপরিচিত&nbsp;<strong>Link Up Communication</strong>&nbsp;এখন আরও সুন্দর সুন্দর প্যাকেজ নিয়ে আপনাদের কাছে হাজির।তাই আর বিলম্ব না করে এখনি বেছে নিন মনোনীত প্যাকেজটি এবং উপভোগ করুন দুরন্ত গতির ইন্টারনেট সেবা।</p>\r\n<p style=\"margin: 6px 0px; font-family: Helvetica, Arial, sans-serif; color: #1c1e21; font-size: 14px; background-color: #ffffff;\"><span class=\"text_exposed_show\" style=\"display: inline; font-family: inherit;\">ধন্যবাদ ।</span></p>', '2021-10-16 12:03:53', '2021-10-16 12:03:53', NULL),
(30, '20211018055934-Benner 2.jpg', 2, '100mbps', '<p>আমাদের সম্পূর্ণ নেটওয়ার্ক ফাইবার অপটিক্যাল দ্বারা পরিচালিত, আমরা দক্ষকর্মীর সহযোগীতায় সবসময় আপনাদের সেবা দানে অবিরাম চেষ্টা করে যাচ্ছি।&nbsp;</p>', '2021-10-18 09:59:34', '2021-10-18 09:59:34', NULL),
(31, '20211018062105-Benner 3.jpg', 3, 'Benner 3', '<p>Enjoy Our Movies Servers</p>', '2021-10-18 10:21:05', '2021-10-18 10:21:05', NULL),
(32, '20211019120605-Benner 4.jpg', 4, 'Bkash Payment', '<p>Bkash Payment&nbsp;</p>', '2021-10-19 16:06:05', '2021-10-19 16:06:05', NULL);

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

--
-- Table structure for table `batches`
--

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

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

--
-- Table structure for table `billings`
--

CREATE TABLE `billings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `billing_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_icon` varchar(255) DEFAULT NULL,
  `order` int(11) DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `billings`
--

INSERT INTO `billings` (`id`, `billing_image`, `billing_icon`, `order`, `title`, `details`, `created_at`, `updated_at`, `deleted_at`) VALUES
(7, '20210211082557-9.png', '20210211082557-9.png', 2, 'Bkash Pay', '<p><span style=\"color: #1c1e21; font-family: Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;\">যখন ভাববে দূরত্ব LinkUP</span><span style=\"color: #1c1e21; font-family: Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;\"> Communication আছে আপনার সাথে</span><span style=\"color: #1c1e21; font-family: Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;\">&nbsp;সংযুক্ত ।</span><br style=\"color: #1c1e21; font-family: Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;\" /><span style=\"color: #1c1e21; font-family: Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;\">দূরত্বকে ভুলে গিয়ে LinkUP Communication এর সাথে সংযুক্ত থেকে আপনার দৈনন্দিন কাজ সেরে নিন। যেমন: ক্লাস করা / অফিস করা / চ্যাটিং করা ইত্যাদি এখন থেকে চলবে বাধাহীন নেটওয়ার্ক LinkUP Communication এর সাথে। আমরা দিচ্ছি Optical Fiber Connection যা আপনাকে দিবে নির-বিচ্ছিন্ন দ্রুত গতির ইন্টারনেট কানেকশন এবং সাথে থাকছে আমাদের Strong Support Team</span></p>', '2021-02-10 23:23:02', '2021-10-13 11:06:22', NULL),
(9, '20210211095034-icons-07.png', '20210211095034-icons-07.png', 2, 'Online Banking', '<p>Online Banking</p>', '2021-02-11 14:50:34', '2021-02-11 14:50:34', NULL),
(10, '20210211095110-icons-04.png', '20210211095110-icons-04.png', 3, 'Office Payment', '<p>Office Payment</p>', '2021-02-11 14:51:10', '2021-02-11 14:51:10', NULL),
(11, '20210211095141-icons-05.png', '20210211095141-icons-05.png', 4, 'Billing guideline', '<p>Billing guideline</p>', '2021-02-11 14:51:41', '2021-02-11 14:51:41', NULL),
(12, '20211015171549-link_up_logo.png', '20211015171549-link_up_logo.png', 3, 'bb', NULL, '2021-10-15 21:15:49', '2021-10-15 21:15:49', NULL);

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

--
-- Table structure for table `categories`
--

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

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

--
-- Table structure for table `category_contents`
--

CREATE TABLE `category_contents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_image` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_text` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `complains`
--

CREATE TABLE `complains` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(11) DEFAULT NULL,
  `complain_text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `solve_text` longtext DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0 COMMENT '0 -> pending, 1 -> solved',
  `complain_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `solve_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `submitted_date` timestamp NULL DEFAULT NULL,
  `solved_date` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `complains`
--

INSERT INTO `complains` (`id`, `user_id`, `complain_text`, `solve_text`, `status`, `complain_image`, `solve_image`, `submitted_date`, `solved_date`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'This is a complain', NULL, 0, '1608986061.png', NULL, '2020-12-26 17:34:21', NULL, '2020-12-26 17:34:21', '2021-02-08 16:44:54', '2021-02-08 16:44:54'),
(2, 2, 'This is a complain', 'solved', 1, '1608986180.png', '20201227093747-duck.png', '2020-12-26 17:36:20', '2020-12-27 14:37:47', '2020-12-26 17:36:20', '2021-02-08 16:44:52', '2021-02-08 16:44:52'),
(3, 1, 'This is another complain', NULL, 0, '1608986226.png', NULL, '2020-12-26 17:37:06', NULL, '2020-12-26 17:37:06', '2021-02-08 16:44:56', '2021-02-08 16:44:56'),
(4, 2, 'User 2 complain', NULL, 0, '1608986241.png', NULL, '2020-12-26 17:37:21', NULL, '2020-12-26 17:37:21', '2021-02-08 16:44:58', '2021-02-08 16:44:58'),
(5, 2, 'no complain', NULL, 1, '1608989073.png', NULL, '2020-12-26 18:24:33', NULL, '2020-12-26 18:24:33', '2021-02-08 16:44:45', '2021-02-08 16:44:45'),
(6, 2, 'solved complain', NULL, 1, '1608989083.png', NULL, '2020-12-26 18:24:43', NULL, '2020-12-26 18:24:43', '2021-02-08 16:44:47', '2021-02-08 16:44:47'),
(7, 1, 'dddd', NULL, 0, '1612627148.jpeg', NULL, '2021-02-06 20:59:09', NULL, '2021-02-06 20:59:09', '2021-02-08 16:44:21', '2021-02-08 16:44:21'),
(8, 1, 'duck', NULL, 0, '1612627333.png', NULL, '2021-02-06 21:02:13', NULL, '2021-02-06 21:02:13', '2021-02-08 16:44:40', '2021-02-08 16:44:40'),
(9, 1, 'duck', NULL, 0, '1612627556.png', NULL, '2021-02-06 21:05:56', NULL, '2021-02-06 21:05:56', '2021-02-08 16:44:37', '2021-02-08 16:44:37'),
(26, 4667, 'deauuhhhhjj', NULL, 0, '1613039281.png', NULL, '2021-02-11 15:28:03', NULL, '2021-02-11 15:28:03', '2021-10-15 21:56:46', '2021-10-15 21:56:46'),
(27, 9, 'complain text test', NULL, 0, 'NULL', NULL, '2021-09-29 12:35:39', NULL, '2021-09-29 12:35:40', '2021-10-15 21:56:36', '2021-10-15 21:56:36'),
(28, 1763602525, 'test text', NULL, 0, 'NULL', NULL, NULL, NULL, NULL, '2021-10-15 21:57:00', '2021-10-15 21:57:00'),
(29, 8801515637446, 'complain text test another', NULL, 1, 'NULL', NULL, '2021-09-29 12:37:41', NULL, '2021-09-29 12:37:41', '2021-10-15 21:56:41', '2021-10-15 21:56:41');

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

--
-- Table structure for table `connection_details`
--

CREATE TABLE `connection_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `details` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `connection_details`
--

INSERT INTO `connection_details` (`id`, `details`, `created_at`, `updated_at`, `deleted_at`) VALUES
(5, '<p>add please</p>\r\n<p>&nbsp;</p>', '2021-01-30 22:14:24', '2021-10-11 08:02:45', NULL);

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

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

CREATE TABLE `contact_us` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fb_page` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fb_group` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `contact_us` (`id`, `title`, `address`, `phone_number`, `email`, `location`, `fb_page`, `fb_group`, `created_at`, `updated_at`) VALUES
(1, 'This is another test', 'House No: 1770 || House Name: D.H. Khan Mansion || Road: Hazi Osim Uddin Road', '01521431920', 'ashikrafat.lne@gmail.com', 'https://www.google.com/maps/place/Nilkhet+Mor/@23.7341072,90.3865211,16.3z/data=!4m5!3m4!1s0x3755b8c5eee6d2e9:0xb039e2ad7310547b!8m2!3d23.7321019!4d90.3850512', 'adfsaf', 'adfasf', '2020-12-25 03:02:13', '2021-02-10 13:21:23');

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

--
-- Table structure for table `courses`
--

CREATE TABLE `courses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `course_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `course_description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `class_start_end_date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `class_schedule1` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `class_schedule2` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `venue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price_offer` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_sit` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pre_knowledge` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `class_start_date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_classes` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_date_apply` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `course_details` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `image1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `course_category_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `course_categories`
--

CREATE TABLE `course_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_course` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `course_category_photo` varchar(255) 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;

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

--
-- Table structure for table `discover_missions`
--

CREATE TABLE `discover_missions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descriptions` mediumtext 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;

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

--
-- Table structure for table `employment_histories`
--

CREATE TABLE `employment_histories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `instructor__apply_id` bigint(20) UNSIGNED NOT NULL,
  `company_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `employment_period` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `responsibilities` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `entertainments`
--

CREATE TABLE `entertainments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `entertainment_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int(11) DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `click_url` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `ecategory_id` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `entertainments`
--

INSERT INTO `entertainments` (`id`, `entertainment_image`, `order`, `title`, `click_url`, `ecategory_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
(14, '20211018062458-100 x 100.jpg', 1, 'ftp-1', 'http://khulnaplex.net/', 1, '2021-10-15 21:09:44', '2021-10-18 11:18:05', '2021-10-18 11:18:05'),
(15, '20211018062626-100 x 100.jpg', 2, 'ftp-2', 'https://crazyctg.com/', 1, '2021-10-18 10:26:26', '2021-10-18 10:41:53', '2021-10-18 10:41:53'),
(16, '20211018062701-100 x 100.jpg', 3, 'ftp-3', 'http://ctgmovies.com/', 1, '2021-10-18 10:27:01', '2021-10-18 11:18:10', '2021-10-18 11:18:10'),
(17, '20211018062918-100 x 100.jpg', 4, 'TV-1', 'http://bdixtv.live/', 1, '2021-10-18 10:29:18', '2021-10-18 11:18:14', '2021-10-18 11:18:14'),
(18, '20211018063023-100 x 100.jpg', 5, 'TV-JAGO', 'https://m.jagobd.com/play?v=vwgm0ukuviunsn', 1, '2021-10-18 10:30:23', '2021-10-18 11:18:01', '2021-10-18 11:18:01'),
(19, '20211018063144-100 x 100.jpg', 6, 'FTP-5', 'https://nbd-media.tk/', 1, '2021-10-18 10:31:44', '2021-10-18 11:17:55', '2021-10-18 11:17:55'),
(20, '20211018063514-100 x 100.jpg', 7, 'tv-4', 'https://nbd-media.tk/', 1, '2021-10-18 10:35:14', '2021-10-18 11:17:50', '2021-10-18 11:17:50'),
(21, '20211026174118-ftp (4).png', 1, 'KPN-ftp', 'http://khulnaplex.net/', 1, '2021-10-18 11:21:08', '2021-10-26 21:41:18', NULL),
(22, '20211026173549-ftp (1).png', 2, 'NBD-FTP2', 'https://nbd-media.tk/', 1, '2021-10-18 11:22:33', '2021-10-26 21:35:49', NULL),
(23, '20211026173718-ftp (2).png', 3, 'CTGM-FTP3', 'http://ctgmovies.com/', 1, '2021-10-18 11:25:27', '2021-10-26 21:37:18', NULL),
(24, '20211026173823-ftp (3).png', 4, 'PBN-FTP4', 'http://plexbd.net/', 1, '2021-10-18 11:26:53', '2021-10-26 21:38:23', NULL),
(25, '20211026174043-unnamed.png', 5, 'Bioscope-TV', 'https://www.bioscopelive.com', 1, '2021-10-18 11:58:11', '2021-10-26 21:40:43', NULL),
(26, '20211026174629-18652502.png', 6, 'Bongobd Live TV', 'https://bongobd.com/', 1, '2021-10-21 15:35:52', '2021-10-26 21:47:33', NULL),
(27, '20211026193841-unnamed (1).png', 7, 'Toffee Tv', 'https://toffeelive.com', 1, '2021-10-26 23:38:41', '2021-10-26 23:38:41', NULL),
(28, '20211206175051-1.jpg', 40, 'test ent', 'http://khulnaplex.net/', 3, '2021-12-06 11:50:51', '2021-12-06 12:00:47', '2021-12-06 12:00:47');

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

--
-- Table structure for table `entertainment_category`
--

CREATE TABLE `entertainment_category` (
  `ecat_id` int(11) NOT NULL,
  `entertainment_category_name` varchar(255) DEFAULT NULL,
  `ecat_image` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `deleted_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `entertainment_category`
--

INSERT INTO `entertainment_category` (`ecat_id`, `entertainment_category_name`, `ecat_image`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Live tv', 'tv.jpg', '2021-12-06 17:22:50', '2021-12-06 17:22:50', '2021-12-06 17:22:50'),
(2, 'Movie', 'mv.jpg', '2021-12-06 17:22:50', '2021-12-06 17:22:50', '2021-12-06 17:22:50'),
(3, 'News', 'nwes.jpg', '2021-12-06 17:23:08', '2021-12-06 17:23:08', '2021-12-06 17:23:08'),
(4, 'Portal', 'pt.jpg', '2021-12-06 17:23:23', '2021-12-06 17:23:23', '2021-12-06 17:23:23'),
(5, 'Others', 'others.jpg', '2021-12-06 17:23:40', '2021-12-06 17:23:40', '2021-12-06 17:23:40');

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

--
-- Table structure for table `exclusive_packages`
--

CREATE TABLE `exclusive_packages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `exclusive_package_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exclusive_package_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exclusive_package_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `exclusive_packages`
--

INSERT INTO `exclusive_packages` (`id`, `exclusive_package_name`, `exclusive_package_image`, `exclusive_package_description`, `order`, `created_at`, `updated_at`) VALUES
(1, 'Gamer', '20210102081743-rsz_games-banner.jpg', 'Forget the Suffering of buffering and elevate your gaming experience with XploreNet Gamer Package', 1, '2021-01-02 13:17:43', '2021-01-02 13:17:43');

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

--
-- Table structure for table `f_a_q_s`
--

CREATE TABLE `f_a_q_s` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descriptions` mediumtext 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;

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

--
-- Table structure for table `galleries`
--

CREATE TABLE `galleries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `photo1` varchar(255) 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;

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

--
-- Table structure for table `hotlines`
--

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

--
-- Dumping data for table `hotlines`
--

INSERT INTO `hotlines` (`id`, `name`, `designation`, `number`, `created_at`, `updated_at`) VALUES
(2, 'Support', 'Call Center', '01907103271', '2020-12-25 20:11:27', '2021-10-13 10:35:55');

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

--
-- Table structure for table `infos`
--

CREATE TABLE `infos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `info_image` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `info_icon` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int(11) DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `infos`
--

INSERT INTO `infos` (`id`, `info_image`, `info_icon`, `order`, `title`, `details`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, '20210124035137-human.png', '20210124035137-down-arrow.png', 1, 'info icon testing', '<p>info icon all testing yo</p>', '2021-01-24 08:49:44', '2021-02-08 20:43:41', '2021-02-08 20:43:41'),
(2, '20210208135403-WhatsApp Image 2020-11-30 at 10.51.35 PM(6) - Copy.jpeg', '20210208135403-WhatsApp Image 2020-12-16 at 11.04.29 AM.jpeg', 5, 'Router', '<p><span style=\"color: #202124; font-family: arial, sans-serif; font-size: 16px; background-color: #ffffff;\">Whether websites are failing to load, everything network-related seems slow, connections are dropping, or your wireless is flaking out, you may just want to try rebooting your&nbsp;</span><strong style=\"color: #202124; font-family: arial, sans-serif; font-size: 16px; background-color: #ffffff;\">router</strong><span style=\"color: #202124; font-family: arial, sans-serif; font-size: 16px; background-color: #ffffff;\">. ... The reboot process is simple on most routers &mdash; unplug your&nbsp;</span><strong style=\"color: #202124; font-family: arial, sans-serif; font-size: 16px; background-color: #ffffff;\">router\'s</strong><span style=\"color: #202124; font-family: arial, sans-serif; font-size: 16px; background-color: #ffffff;\">&nbsp;power cable, wait a few seconds, and then plug it back in</span></p>', '2021-02-08 18:54:03', '2021-02-10 21:53:54', '2021-02-10 21:53:54'),
(3, '20210208140201-106477191_1243171452519758_3238550893316483425_o.jpg', '20210208140201-unnamed.png', 3, 'Bkash Pay', '<div class=\"kvgmc6g5 cxmmr5t8 oygrvhab hcukyx3x c1et5uql ii04i59q\" style=\"overflow-wrap: break-word; margin: 0px; white-space: pre-wrap; font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; color: #050505; font-size: 15px; background-color: #ffffff;\">\r\n<div dir=\"auto\" style=\"font-family: inherit;\">এক্সপ্লোর নেটের সকল গ্রাহকদের জানাই শুভেচ্ছা, এক্সপ্লোর নেটের সকল অনলাইন পেমেন্ট মেথডে বিল প্রদানের ক্ষেত্রে অবশ্যই রেফারেন্স দিতে হবে আপনার ইউজার আইডি।</div>\r\n<div dir=\"auto\" style=\"font-family: inherit;\"><span style=\"font-family: inherit;\"><a class=\"oajrlxb2 g5ia77u1 qu0x051f esr5mh6w e9989ue4 r7d6kgcz rq0escxv nhd2j8a9 nc684nl6 p7hjln8o kvgmc6g5 cxmmr5t8 oygrvhab hcukyx3x jb3vyjys rz4wbd8a qt6c0cv9 a8nywdso i1ao9s8h esuyzwwr f1sip0of lzcic4wl q66pz984 gpro0wi8 b1v8xokw\" style=\"cursor: pointer; text-decoration-line: none; outline: none; list-style: none; padding: 0px; margin: 0px; touch-action: manipulation; background-color: transparent; text-align: inherit; display: inline; -webkit-tap-highlight-color: transparent; box-sizing: border-box; font-family: inherit; border: 0px initial initial;\" tabindex=\"0\" role=\"link\" href=\"https://www.facebook.com/hashtag/user?__eep__=6&amp;__cft__[0]=AZWZ8DkgIKnRb0zhbfUC4e2fT4UmL25yyMOaYgLoqWY5YJN5u5ENFUmvHXMhBh2twgf2-MiQE0CbhwX3QUnoEhxv655uOIX_v7RHxrYFQGyT8ehPDE6-pYpZTXcMyD2B8j677WtdjA1MyDxLUVCejRWWEoZwlM_gPa_ZuwVtvsnzBeo8x3xeRE8SN4pN-0H3tGo&amp;__tn__=*NK-R\">#User</a></span> Id না দিলে আপনার বিলটি কাউন্ট হবে না। যদি ভুল হয় তা হলে অবশ্যই হট লাইনে কল করে জানিয়ে দিতে হবে।</div>\r\n</div>\r\n<div class=\"o9v6fnle cxmmr5t8 oygrvhab hcukyx3x c1et5uql ii04i59q\" style=\"overflow-wrap: break-word; margin: 0.5em 0px 0px; white-space: pre-wrap; font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; color: #050505; font-size: 15px; background-color: #ffffff;\">\r\n<div dir=\"auto\" style=\"font-family: inherit;\">এক্সপ্লোর নেট বিডি</div>\r\n</div>', '2021-02-08 19:02:01', '2021-02-08 19:02:51', '2021-02-08 19:02:51'),
(4, '20210208140608-106477191_1243171452519758_3238550893316483425_o.jpg', '20210208140608-unnamed.png', 5, 'Bkash Pay', '<div dir=\"auto\" style=\"font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; color: #050505; font-size: 15px; white-space: pre-wrap; background-color: #ffffff;\">এক্সপ্লোর নেটে</div>\r\n<div dir=\"auto\" style=\"font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; color: #050505; font-size: 15px; white-space: pre-wrap; background-color: #ffffff;\">বিল পেমেন্ট হবে ডিজিটাল মেথডে</div>\r\n<div dir=\"auto\" style=\"font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; color: #050505; font-size: 15px; white-space: pre-wrap; background-color: #ffffff;\">ঘরে বসেই!</div>', '2021-02-08 19:06:08', '2021-02-10 21:53:57', '2021-02-10 21:53:57'),
(5, '20210208154659-107379777_1243171485853088_4018911220505329641_o.jpg', '20210208154659-87.jpg', 1, 'Bkash Pay', '<p><span style=\"color: #050505; font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; font-size: 15px; white-space: pre-wrap; background-color: #ffffff;\">এখন বিল পেমেন্ট করুন ঘরে বশেই এবং আনন্দে উপভোগ করুন আমাদের হাই স্পিড ইন্টারনেট সেবা</span></p>', '2021-02-08 20:46:59', '2021-02-10 21:53:49', '2021-02-10 21:53:49'),
(6, '20210210170025-20210209171132-human.png', '20210210170025-20210209171132-human.png', 1, 'ghh', '<p>8</p>\r\n<p>&nbsp;</p>', '2021-02-10 22:00:25', '2021-02-10 23:11:50', '2021-02-10 23:11:50'),
(7, '20210210181349-Cambium-router-setup-2.1.jpg', '20210210181349-Screenshot_12.png', 2, 'Router Setup', '<header class=\"entry-header\" style=\"box-sizing: border-box; font-family: \'Open Sans\', Arial, Helvetica, sans-serif; font-size: 16px; background-color: #ffffff;\">\r\n<h1 class=\"entry-title\" style=\"box-sizing: border-box; margin: 0px 0px 0.75em; line-height: 1.5em; overflow-wrap: break-word;\">D-Link Router Setup</h1>\r\n</header>\r\n<div class=\"entry-content\" style=\"box-sizing: border-box; font-family: \'Open Sans\', Arial, Helvetica, sans-serif; font-size: 16px; background-color: #ffffff;\">\r\n<p style=\"box-sizing: border-box; margin: 0px 0px 1.5em; padding: 0px; font-size: 1em; line-height: 1.5em;\">D-Link Router can be configured in just a few minutes and once you have configured the router and set it up, your Wi-Fi connection will set up and you will be able to connect to the internet through your D-Link Router.</p>\r\n<p style=\"box-sizing: border-box; margin: 0px 0px 1.5em; padding: 0px; font-size: 1em; line-height: 1.5em;\">Before proceeding, make sure the ethernet cable is attached to modem or an active data jack to the ethernet port in back of your router.</p>\r\n<p style=\"box-sizing: border-box; margin: 0px 0px 1.5em; padding: 0px; font-size: 1em; line-height: 1.5em;\"><em style=\"box-sizing: border-box;\"><strong style=\"box-sizing: border-box;\">Follow these steps to set up your D-Link Router &ndash;</strong></em></p>\r\n<ol style=\"box-sizing: border-box; margin: 0px 0px 1.5em; padding: 0px; font-size: 1em; line-height: 1.5em; list-style-position: inside;\">\r\n<li style=\"box-sizing: border-box;\">Power on your D-Link Router.</li>\r\n<li style=\"box-sizing: border-box;\">Connect your PC to the router using an Ethernet Cable or WiFi.</li>\r\n<li style=\"box-sizing: border-box;\">Once your PC is connected, open a web browser and go to&nbsp;<strong style=\"box-sizing: border-box;\"><em style=\"box-sizing: border-box;\"><a style=\"box-sizing: border-box; background-color: transparent; text-decoration-line: none; color: #004d99;\" href=\"https://19216801.one/\" target=\"_blank\" rel=\"noopener noreferrer\" data-wpel-link=\"internal\">http://192.168.0.1</a></em></strong>&nbsp;or&nbsp;<em style=\"box-sizing: border-box;\"><strong style=\"box-sizing: border-box;\"><a style=\"box-sizing: border-box; background-color: transparent; text-decoration-line: none; color: #004d99;\" href=\"https://19216801.one/192-168-1-1/\" target=\"_blank\" rel=\"noopener noreferrer\" data-wpel-link=\"internal\">http://192.168.1.1</a></strong></em>&nbsp;(The default gateway address may vary from model to model, here is&nbsp;<a style=\"box-sizing: border-box; background-color: transparent; text-decoration-line: none; color: #004d99;\" href=\"https://19216801.one/router-ip-addresses/\" data-wpel-link=\"internal\"><strong style=\"box-sizing: border-box;\">list of default router IP address</strong></a>).</li>\r\n</ol>\r\n</div>', '2021-02-10 23:13:49', '2021-02-11 13:26:24', '2021-02-11 13:26:24'),
(8, '20210211082413-8.png', '20210211082136-8.png', 1, 'Home Internet', '<p>1122</p>', '2021-02-11 13:21:36', '2021-02-11 13:24:13', NULL),
(9, '20210211082241-8.png', '20210211082241-8.png', 1, 'Home Internet', '<p>s</p>', '2021-02-11 13:22:41', '2021-02-11 13:26:40', '2021-02-11 13:26:40'),
(10, '20210211094844-icons-02.png', '20210211094844-icons-02.png', 2, 'Corporate Internet', '<p>Corporate Internet</p>', '2021-02-11 14:48:44', '2021-02-11 14:48:44', NULL),
(11, '20210211094911-icons-03.png', '20210211094911-icons-03.png', 3, 'Offers', '<p>Offers</p>', '2021-02-11 14:49:11', '2021-02-11 14:49:11', NULL),
(12, '20210211094927-icons-06.png', '20210211094927-icons-06.png', 4, 'Coverage', '<p>Coverage</p>', '2021-02-11 14:49:27', '2021-02-11 14:49:27', NULL),
(13, '20211015171406-Screenshot_13.png', '20211015171406-Screenshot_13.png', 3, 'bb', NULL, '2021-10-15 21:14:06', '2021-10-15 21:59:05', '2021-10-15 21:59:05'),
(14, '20211015171433-flappy.png', '20211015171433-link_up_brand_logo.png', 4, 'cc', '<p>adfd</p>', '2021-10-15 21:14:33', '2021-10-15 22:00:18', '2021-10-15 22:00:18');

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

--
-- Table structure for table `instructor__applies`
--

CREATE TABLE `instructor__applies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `instructor_photo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gender` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_birth` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `education_level` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `result` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `passing_year` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2020_09_26_154720_create_instructor__applies_table', 1),
(4, '2020_10_03_050008_create_testimonials_table', 1),
(5, '2020_10_04_105308_create_news_table', 1),
(6, '2020_10_06_061202_create_course_categories_table', 1),
(7, '2020_10_08_061201_create_courses_table', 1),
(8, '2020_10_11_043131_create_admission_tables_table', 1),
(9, '2020_10_12_055456_create_f_a_q_s_table', 1),
(10, '2020_10_14_050733_create_discover_missions_table', 1),
(11, '2020_10_14_091050_create_galleries_table', 1),
(12, '2020_10_17_045926_create_about_us_table', 1),
(14, '2020_11_10_061803_create_employment_histories_table', 1),
(16, '2020_11_12_042823_create_batches_table', 1),
(17, '2020_11_21_130001_create_categories_table', 1),
(18, '2020_11_21_132131_create_category_contents_table', 1),
(19, '2020_11_25_061153_create_packages_table', 2),
(20, '2020_11_11_052935_create_banners_table', 3),
(21, '2020_12_25_065944_entertainment', 4),
(22, '2020_12_25_070027_info', 5),
(24, '2020_11_09_154734_create_contact_us_table', 6),
(26, '2020_12_25_091613_connection_details', 7),
(27, '2020_12_25_095344_notice', 8),
(28, '2020_12_25_100612_hotline', 9);

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

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

CREATE TABLE `news` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descriptions` mediumtext 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;

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

--
-- Table structure for table `notices`
--

CREATE TABLE `notices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `notice_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'NULL',
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notices`
--

INSERT INTO `notices` (`id`, `notice_image`, `title`, `details`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, '20201225100422-human.png', 'This is notice', '<p>adasdfasdfasdfasdfasfasdf</p>', '2020-12-25 04:03:47', '2020-12-25 04:05:43', '2020-12-25 04:05:43'),
(2, '20210113171919-3Tiers-500x383.jpg', 'This is a notice', '<div id=\"lipsum\" style=\"margin: 0px; padding: 0px; text-align: justify; color: #000000; font-family: \'Open Sans\', Arial, sans-serif; font-size: 14px; font-weight: 400; text-transform: none; background-color: #ffffff;\">\r\n<p style=\"margin: 0px 0px 15px; padding: 0px 0px 0px 80px; text-align: left;\"><span style=\"font-family: \'arial black\', sans-serif; color: #e03e2d;\"><em>Lorem ipsum dolor sit amet, consectetur adipiscing elit. In massa justo, lobortis quis pellentesque quis, ultricies vel sapien. Nullam diam purus, consequat eu tempor nec, varius ut mauris. Nam at tempor dui. Etiam justo orci, hendrerit ac fermentum id, cursus a erat. Fusce sollicitudin nunc nisl, sed pulvinar sapien pellentesque et. Fusce est urna, maximus ut laoreet ac, vestibulum</em></span> <code>varius nisi.</code> <span style=\"background-color: #f1c40f;\">Proin commodo scelerisque mauris, in rutrum arcu tincidunt eu.</span> Vivamus placerat elementum enim vel ornare. Sed sit amet elementum sapien, sed dapibus risus.</p>\r\n<p style=\"margin: 0px 0px 15px; padding: 0px 0px 0px 80px; text-align: left;\">&nbsp;</p>\r\n<blockquote>\r\n<p style=\"margin: 0px 0px 15px; padding: 0px 0px 0px 80px; text-align: left;\"><span style=\"font-family: Open Sans, Arial, sans-serif;\"><span style=\"font-size: 14px;\">https://www.google.com.bd/maps/@23.7509527,90.3654215,15z</span></span></p>\r\n</blockquote>\r\n<p style=\"margin: 0px 0px 15px; padding: 0px;\">Maecenas finibus pharetra metus, vel aliquam nibh semper at. Donec scelerisque, sem in porttitor maximus, lectus ligula congue tortor, et tincidunt sapien quam quis magna. Suspendisse sed consectetur est. Curabitur non justo ex. Nulla consectetur non augue ac condimentum. Sed at arcu et sem placerat congue. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Ut non accumsan diam. Cras dolor ipsum, consectetur vel ante eu, tincidunt porta nibh. Etiam egestas finibus augue, sodales consequat urna fringilla et. Donec suscipit, turpis eu ullamcorper gravida, magna erat pharetra neque, sed vestibulum leo sem at sem. Donec eu hendrerit quam. Cras suscipit turpis orci, ac sodales urna viverra vitae. Praesent in faucibus urna, in eleifend felis.</p>\r\n<p style=\"margin: 0px 0px 15px; padding: 0px;\">Praesent consequat, sem eu sagittis laoreet, metus lacus eleifend nibh, ac cursus felis metus quis leo. Praesent bibendum enim non dui placerat viverra sed viverra velit. Nam in tortor velit. Pellentesque magna elit, pharetra sit amet vehicula sit amet, tincidunt quis ex. Phasellus maximus nisi eget velit condimentum, non pretium augue viverra. Etiam vel quam facilisis, feugiat dui eget, elementum nisi. Integer sit amet nunc ac dolor luctus tincidunt. Nam sollicitudin lobortis est a molestie. Vestibulum condimentum at lacus vel fermentum. Donec suscipit tortor vitae bibendum euismod. Aliquam sit amet nunc neque. Vestibulum egestas ex sem, vitae tempus lacus lacinia nec. Duis auctor, nulla vel pharetra pharetra, mauris ante dictum nisl, ut volutpat risus risus in ipsum. Phasellus id feugiat orci.</p>\r\n<p style=\"margin: 0px 0px 15px; padding: 0px;\">Nunc at convallis dolor, non convallis nulla. Quisque tellus leo, sodales id mi in, ultrices blandit metus. Maecenas et malesuada neque, non interdum massa. Nunc fermentum vulputate posuere. Proin magna tortor, laoreet quis consequat sed, scelerisque sed dolor. Quisque lobortis eleifend luctus. Nunc dignissim turpis eros, non malesuada ligula commodo et. Duis nec mollis enim. Sed consequat, purus sed bibendum porta, magna dolor ultricies felis, sit amet porta nibh dui eget quam. Vivamus maximus justo turpis, sed dignissim mauris ullamcorper vel. Nam pretium sodales lectus, sed sagittis neque hendrerit vitae.</p>\r\n<p style=\"margin: 0px 0px 15px; padding: 0px;\">Nunc viverra elit ac est volutpat, et viverra diam condimentum. Nunc luctus, tellus luctus facilisis ultrices, justo nunc laoreet leo, ultricies dapibus tellus neque sit amet ante. In lobortis tempus rutrum. Nullam sit amet vulputate nibh. Pellentesque quis felis metus. Nunc congue, mauris eget porttitor volutpat, nisl augue laoreet tellus, et viverra turpis orci nec purus. Sed malesuada vel turpis eget gravida. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Curabitur aliquet sem non lectus vehicula, ut fringilla est elementum. Aenean accumsan tellus ut mi fermentum mollis. Proin ac dictum erat.</p>\r\n</div>\r\n<div id=\"generated\" style=\"margin: 0px; padding: 0px; color: #000000; font-family: \'Open Sans\', Arial, sans-serif; font-size: 14px; text-transform: none; background-color: #ffffff;\">Generated 5 paragraphs, 509 words, 3410 bytes of&nbsp;<a style=\"margin: 0px; padding: 0px; color: #000000;\" title=\"Lorem Ipsum\" href=\"https://www.lipsum.com/\">Lorem Ipsum</a></div>', '2020-12-25 20:22:25', '2021-02-10 21:46:15', '2021-02-10 21:46:15'),
(3, '20210210180506-Screenshot_11.png', 'Xplore Internet', '<p>add new</p>', '2021-02-10 23:05:06', '2021-10-16 17:54:46', '2021-10-16 17:54:46'),
(4, '20210211095745-icons-02.png', 'Thunder alert', '<p>Thunder alert</p>', '2021-02-11 14:57:45', '2021-02-11 14:57:45', NULL),
(5, '20210926172543-B&W desine.jpg', 'test title', '<p>details notice.</p>', '2021-09-26 11:25:43', '2021-09-26 11:25:43', NULL),
(6, '20210929174952-O.JPG', 'test new', '<p>test details new</p>', '2021-09-29 11:49:52', '2021-09-29 11:49:52', NULL),
(7, NULL, 'test without image', '<p>test details without image</p>', '2021-09-29 11:58:35', '2021-09-29 12:04:34', '2021-09-29 12:04:34'),
(8, '\"\"', 'test without image double string', '<p>details without image double string</p>', '2021-09-29 11:59:41', '2021-09-29 12:04:29', '2021-09-29 12:04:29'),
(9, 'NULL', 'new title NULL', '<p>details NULL</p>', '2021-09-29 12:01:12', '2021-09-29 12:01:12', NULL),
(10, '20211015171944-link_up_logo.png', 'dd', '<p>ddd</p>', '2021-10-15 21:19:44', '2021-10-15 21:19:44', NULL);

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

--
-- Table structure for table `offers`
--

CREATE TABLE `offers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `offer_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `offers`
--

INSERT INTO `offers` (`id`, `offer_image`, `order`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, '20210102090432-1.jpg', 3, '2021-01-02 14:04:32', '2021-01-02 14:04:32', NULL),
(2, '20210102090439-2.jpg', 1, '2021-01-02 14:04:39', '2021-07-07 11:07:33', NULL),
(4, '20210102090500-4.jpg', 2, '2021-01-02 14:05:00', '2021-01-02 14:05:00', NULL),
(5, '20210102090508-5.jpg', 4, '2021-01-02 14:05:08', '2021-01-02 14:05:08', NULL);

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

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

CREATE TABLE `packages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `package_price` int(11) NOT NULL,
  `package_speed` int(11) NOT NULL,
  `order` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `packages` (`id`, `package_name`, `package_price`, `package_speed`, `order`, `created_at`, `updated_at`) VALUES
(2, 'SILVER', 700, 20, 2, '2021-01-02 12:59:38', '2021-01-02 12:59:38'),
(3, 'RUBY', 800, 30, 3, '2021-01-02 12:59:59', '2021-01-02 12:59:59'),
(4, 'GOLD', 1000, 40, 4, '2021-01-02 13:00:18', '2021-01-02 13:00:18'),
(5, 'DIAMOND', 1600, 50, 5, '2021-01-02 13:00:46', '2021-02-08 18:07:02'),
(6, 'PLATINUM', 1500, 60, 6, '2021-01-02 13:01:14', '2021-01-02 13:01:14');

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

--
-- Table structure for table `popups`
--

CREATE TABLE `popups` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `popup_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `popups`
--

INSERT INTO `popups` (`id`, `popup_image`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, '20210102075226-ad-1.jpg', '2021-01-02 12:52:26', '2021-01-02 12:52:26', NULL);

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

--
-- Table structure for table `requests`
--

CREATE TABLE `requests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `request_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `request_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `request_package` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `request_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `request_message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `requests`
--

INSERT INTO `requests` (`id`, `request_name`, `request_number`, `request_package`, `request_location`, `request_message`, `created_at`, `updated_at`) VALUES
(1, 'test', '123', 'Biddut', 'dhaka', 'i need this', '2021-01-02 15:37:15', '2021-01-02 15:37:15'),
(2, NULL, NULL, NULL, NULL, NULL, '2021-02-07 22:19:44', '2021-02-07 22:19:44'),
(3, 'Ashik', '01521431920', NULL, 'dhanmondi', 'this testing', '2021-02-07 22:30:31', '2021-02-07 22:30:31'),
(4, 'Ashik', '01521431920', NULL, 'Rayerbag', 'jhjghj', '2021-02-09 21:36:08', '2021-02-09 21:36:08'),
(5, 'Test', '017', NULL, 'Dhaka', 'Ss', '2021-02-09 21:38:08', '2021-02-09 21:38:08'),
(6, 'Aa', 'Sd', NULL, 'Ff', NULL, '2021-02-09 21:38:29', '2021-02-09 21:38:29');

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

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

CREATE TABLE `sliders` (
  `id` int(11) NOT NULL,
  `slider_text1` varchar(255) DEFAULT NULL,
  `slider_text2` varchar(255) DEFAULT NULL,
  `slider_button` varchar(255) DEFAULT NULL,
  `slider_button_link` varchar(255) DEFAULT NULL,
  `slider_image` varchar(255) DEFAULT NULL,
  `slider_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `sliders` (`id`, `slider_text1`, `slider_text2`, `slider_button`, `slider_button_link`, `slider_image`, `slider_order`, `created_at`, `updated_at`) VALUES
(1, NULL, NULL, NULL, NULL, '20210804174117-xplore-net-banner-01.png', 0, '2021-08-04 11:41:17', '2021-08-04 11:41:17'),
(2, NULL, NULL, NULL, NULL, '20210804174125-xplore-net-banner-02.png', 1, '2021-08-04 11:41:25', '2021-08-04 11:41:25'),
(3, NULL, NULL, NULL, NULL, '20210804174133-xplore-net-banner-03.png', 2, '2021-08-04 11:41:33', '2021-08-04 11:41:33');

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

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

CREATE TABLE `testimonials` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `descriptions` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `students_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `students_photo` varchar(255) 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;

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `batches`
--
ALTER TABLE `batches`
  ADD PRIMARY KEY (`id`),
  ADD KEY `batches_course_id_foreign` (`course_id`);

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

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

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

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

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

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

--
-- Indexes for table `courses`
--
ALTER TABLE `courses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `courses_course_category_id_foreign` (`course_category_id`);

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

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

--
-- Indexes for table `employment_histories`
--
ALTER TABLE `employment_histories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employment_histories_instructor__apply_id_foreign` (`instructor__apply_id`);

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

--
-- Indexes for table `entertainment_category`
--
ALTER TABLE `entertainment_category`
  ADD PRIMARY KEY (`ecat_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

--
-- AUTO_INCREMENT for table `entertainment_category`
--
ALTER TABLE `entertainment_category`
  MODIFY `ecat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

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

--
-- AUTO_INCREMENT for table `notices`
--
ALTER TABLE `notices`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
COMMIT;

