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

START TRANSACTION;



--
-- Database: `degreewala_update`
--

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

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

CREATE TABLE `apply_job` (
  `id` int(10) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `job_code` text NOT NULL,
  `name` text NOT NULL,
  `contact` text NOT NULL,
  `email` text NOT NULL,
  `upload_resume` text NOT NULL,
  `message` text NOT NULL,
  `address` text NOT NULL,
  `admin_response` text NOT NULL,
  `remark` text NOT NULL,
  `status_of_timing` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `apply_job`
--

INSERT INTO `apply_job` (`id`, `code`, `date`, `time`, `job_code`, `name`, `contact`, `email`, `upload_resume`, `message`, `address`, `admin_response`, `remark`, `status_of_timing`) VALUES
(1, '2992', '16-08-24', '06:36', '9669', 'Ashna Mansuri', '9874563214', 'sdd662@gmail.com', 'upload/Marksheet_Template-2.jpg', 'Sir, is there any job vacancy in your company', 'Shopping Center, Kota', 'Wait', 'wait I am busy now call you letter', '19:00'),
(3, '8386', '17-08-24', '11:11', '6677', 'Zishan Khan', '2368245633', 'sfse@gmail.com', 'upload/1131w-xkDELtpQH94.webp', 'Sir, is there any job vacancy in your company', 'Gumanpura, Kota', 'Wait', 'call karna please', '11:11'),
(4, '8779', '20-08-24', '11:35', '9461', 'Firdous Noor', '1236547895', '123@gmail.com', 'upload/87915397fcb2d0b04899cd90420f4acc.jpg', 'Sir, is there any job vacancy in your company', 'Nayapura', 'Wait', 'Call us soon', '13:36'),
(5, '2265', '29-08-24', '12:12', '2903', 'harshita', 'malav', 'fdfg@fhfghgf', 'upload/', 'w2ewedwe', 'Kaithoon', '1', '1', '12:24'),
(6, '3632', '29-08-24', '12:14', '2903', 'df', 'dg', 'dg@gg', '', 'gd', 'dg', '', '', ''),
(7, '4380', '29-08-24', '12:17', '2903', 'sd', 'sdsd', 'dsd@gjgj', 'upload/in.jpg', 'dd', 'sdsd@dgfh', '', '', ''),
(8, '2382', '29-08-24', '12:17', '2903', 'harshita', '5464557', 'sdsfsdf@dg', 'upload/', 'fh', 'Kaithoon', '', '', ''),
(9, '3716', '29-08-24', '12:55', '2707', 'harshita', '5464557', 'fdfg@fhfghgf', 'upload/', 'ghgjgj', 'Kaithoon', '', '', ''),
(10, '9332', '03-09-24', '12:15', '3728', '1', '1', '1@2', 'upload/', '1', '1', '', '', ''),
(14, '2222', '03-09-24', '12:58', '7346', 'harshita', 'malav', 'malavpoonam7@gmail.com', 'upload/', 'dgfdgfdg', 'Kaithoon', '', '', '');

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

--
-- Table structure for table `article_schema`
--

CREATE TABLE `article_schema` (
  `id` int(10) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `article_type` text NOT NULL,
  `url` text NOT NULL,
  `headline` text NOT NULL,
  `image_url` text NOT NULL,
  `image_url1` text NOT NULL,
  `short_description` text NOT NULL,
  `author_type` text NOT NULL,
  `author` text NOT NULL,
  `author_url` text NOT NULL,
  `publisher` text NOT NULL,
  `publisher_logo` text NOT NULL,
  `date_publish` text NOT NULL,
  `date_modified` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `article_schema`
--

INSERT INTO `article_schema` (`id`, `code`, `date`, `time`, `article_type`, `url`, `headline`, `image_url`, `image_url1`, `short_description`, `author_type`, `author`, `author_url`, `publisher`, `publisher_logo`, `date_publish`, `date_modified`) VALUES
(1, '3075', '16-08-24', '01:41', 'Make Solution', 'https://www.flipkart.com', 'Website', 'https://makesolution.in', 'https://makesolution', 'Best Web Design Company in Kota, Rajasthan, India', '543543', 'Make Solution', 'Make Solution', 'Make Solution', 'Make Solution', '01:00 AM', '11:49 PM'),
(4, '3738', '20-08-24', '06:17', 'Make Solution', 'https://www.fireboltt.com/', 'Website', 'https://makesolution.in', 'https://makesolution', '100% performance', '543543', 'Make Solution', 'Make Solution', 'Make Solution', 'Make Solution', '20/08/2024', '04/03/2023');

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

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

CREATE TABLE `batches` (
  `id` int(10) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `batch_name` text NOT NULL,
  `batch_time_start` text NOT NULL,
  `batch_time_close` text NOT NULL,
  `batch_start_date` text NOT NULL,
  `batch_images` text NOT NULL,
  `capacity` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `batches`
--

INSERT INTO `batches` (`id`, `code`, `date`, `time`, `batch_name`, `batch_time_start`, `batch_time_close`, `batch_start_date`, `batch_images`, `capacity`) VALUES
(1, '', '', '', 'App Development', '10:00', '12:01', '2024-03-01', 'upload/stock-photo-happy-group-of-college-students-smiling-and-holding-notebooks-106310207.jpg', '20-25'),
(3, '2151', '20-08-24', '02:58', 'Web Development', '13:20', '15:20', '2023-09-17', 'upload/download.jfif', '25-30'),
(11, '7344', '20-08-24', '04:05', 'Digital Marketing', '15:00', '17:00', '2024-01-05', 'upload/113368901-group-of-students-over-university-background.jpg', '20-30');

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

--
-- Table structure for table `blog_category`
--

CREATE TABLE `blog_category` (
  `id` int(10) NOT NULL,
  `code` varchar(10) NOT NULL,
  `date` varchar(13) NOT NULL,
  `time` varchar(12) NOT NULL,
  `category_name` varchar(50) NOT NULL,
  `image` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `blog_category`
--

INSERT INTO `blog_category` (`id`, `code`, `date`, `time`, `category_name`, `image`) VALUES
(2, '2731', '30-08-24', '04:35', 'blog2', 'upload/myntrabags.webp'),
(5, '1294', '04-09-24', '12:16', 'bloggg2', 'upload/');

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

--
-- Table structure for table `blog_description`
--

CREATE TABLE `blog_description` (
  `id` int(11) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `blog_code` text NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `blog_image`
--

CREATE TABLE `blog_image` (
  `id` int(11) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `blog_code` text NOT NULL,
  `image` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `blog_image`
--

INSERT INTO `blog_image` (`id`, `code`, `date`, `time`, `blog_code`, `image`) VALUES
(17, '4790', '02-09-24', '04:04', '2183', 'upload/ArooshiSingh.webp'),
(18, '3886', '02-09-24', '04:07', '2183', 'upload/leaders-1.webp');

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

--
-- Table structure for table `blog_post`
--

CREATE TABLE `blog_post` (
  `id` int(11) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `blog_title` text NOT NULL,
  `category` text NOT NULL,
  `image` text NOT NULL,
  `video` text NOT NULL,
  `blog_post_date` text NOT NULL,
  `remark` text NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `blog_post`
--

INSERT INTO `blog_post` (`id`, `code`, `date`, `time`, `blog_title`, `category`, `image`, `video`, `blog_post_date`, `remark`, `description`) VALUES
(16, '5950', '02-09-24', '03:00', 'blog1', 'blog2', 'upload/ArooshiSingh.webp', 'video', '2024-09-04', 'good', 'Johan’s stomach groaned like some ki'),
(17, '2183', '02-09-24', '03:09', 'blogssss', 'blog2', 'upload/ArooshiSingh.webp', 'video', '2024-09-06', 'asd', 'ne description, many writers will default to w'),
(18, '6453', '03-09-24', '02:22', 'blog3', 'blog2', 'upload/cousre1.webp', 'video', '2024-09-03', 'good', 'qqqqq qqqqqqqqqqqqqqq qqqqq qqqqqqqqqq q jdbcmv nvvvvvvv vvvvvv vvvvvvvvvvvv vvvvvvvv vvjdvbbbbbbbbbb bbbbbbbbbbbbbbb bbbbbbbbb'),
(19, '7938', '03-09-24', '02:25', 'Classmblog', 'blog2', 'upload/batch.webp', 'video', '2024-09-26', 'good', 'sad'),
(20, '9117', '04-09-24', '12:16', 'blog1', 'blog2', 'upload/career-edu-400.webp', '1', '2024-09-06', '13123', '234');

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

--
-- Table structure for table `blog_video`
--

CREATE TABLE `blog_video` (
  `id` int(11) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `blog_code` text NOT NULL,
  `video` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `book_visit`
--

CREATE TABLE `book_visit` (
  `id` int(10) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `course_name` text NOT NULL,
  `time_1` text NOT NULL,
  `date_1` text NOT NULL,
  `status` text NOT NULL,
  `remark` text NOT NULL,
  `contact` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `book_visit`
--

INSERT INTO `book_visit` (`id`, `code`, `date`, `time`, `course_name`, `time_1`, `date_1`, `status`, `remark`, `contact`) VALUES
(3, '[value-2]', '[value-3]', '[value-4]', 'Web Development', '[value-6]', '[value-7]', 'Active', 'call karna please', '6376740228'),
(4, '[value-2]', '[value-3]', '[value-4]', 'Graphic Design', '[value-6]', '[value-7]', 'Deactive', 'Call us soon', '1236547895'),
(5, '6', '22-08-24', '03:38', 'dgg', '20:37', '2024-08-23', '', '', 'gfhgfh'),
(6, '414', '22-08-24', '03:40', 'asd', '20:44', '2024-08-30', '', '', 'sw2s'),
(7, '9588', '22-08-24', '03:41', 'ghgh', '20:41', '2024-08-22', '', '', 'hjhj'),
(8, '8384', '22-08-24', '04:05', '', '', '', '', '', ''),
(9, '5063', '22-08-24', '04:05', '', '', '', '', '', ''),
(10, '2799', '22-08-24', '04:05', '', '', '', '', '', ''),
(11, '9360', '22-08-24', '04:05', '', '', '', '', '', ''),
(12, '3900', '22-08-24', '04:05', '', '', '', '', '', ''),
(13, '2063', '22-08-24', '04:06', '', '', '', '', '', ''),
(14, '7429', '22-08-24', '04:06', '', '', '', '', '', '');

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

--
-- Table structure for table `call_back`
--

CREATE TABLE `call_back` (
  `id` int(10) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `full_name` text NOT NULL,
  `mobile` text NOT NULL,
  `email` text NOT NULL,
  `select_course` text NOT NULL,
  `your_city` text NOT NULL,
  `status` text NOT NULL,
  `remark` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `call_back`
--

INSERT INTO `call_back` (`id`, `code`, `date`, `time`, `full_name`, `mobile`, `email`, `select_course`, `your_city`, `status`, `remark`) VALUES
(1, '[value-2]', '[value-3]', '[value-4]', 'Ashifa Rizvi', '1236547895', 'xyz@gmail.com', 'Digital marketing', 'Kota', 'Active', 'Call us soon'),
(3, '[value-2]', '[value-3]', '[value-4]', '[value-5]', '[value-6]', '[value-7]', '[value-8]', '[value-9]', 'Active', 'wait I am busy now call you letter'),
(4, '9870', '22-08-24', '03:53', 'fgfg', 'f', 'dgdfg@kkb', 'd', 'g', '', '');

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

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

CREATE TABLE `contact_us` (
  `id` int(11) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `name` text NOT NULL,
  `contact_no` text NOT NULL,
  `email` text NOT NULL,
  `message` text NOT NULL,
  `remark` text NOT NULL,
  `status` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `contact_us` (`id`, `code`, `date`, `time`, `name`, `contact_no`, `email`, `message`, `remark`, `status`) VALUES
(1, '6102', '03-09-24', '12:57', '1', '1', '1@2', '1', 'fcfh', 'ghjhj'),
(3, '3448', '03-09-24', '01:13', '2', '2', '2', '2', '2', '2'),
(5, '4720', '03-09-24', '02:31', 'harshita', 'malav', '1@2', '11', '', ''),
(6, '6651', '04-09-24', '12:11', 'harshita', 'malav', 'fdfg@fhfghgf', 'w2ewedwe', '', ''),
(7, '7970', '11-09-24', '04:26', 'Firdous Noor', '9874563214', '123@gmail.com', 'GIVE-AND-TAKE', '', ''),
(8, '7966', '11-09-24', '04:28', 'Firdous Noor', '9874563214', 'xyz@gmail.com', 'Sir, is there any job vacancy in your company', '', ''),
(9, '6265', '11-09-24', '04:29', '1', '11', '123@gmail.com', '1', '', ''),
(10, '3615', '12-09-24', '04:32', '', '', '', '', '', ''),
(11, '5862', '12-09-24', '06:18', 'Reshma Hakimi', '457896321', 'sdd662@gmail.com', 'Are you their', '', ''),
(12, '3247', '13-09-24', '12:28', '', '', '', '', '', ''),
(13, '4866', '13-09-24', '12:30', '', '89357927492', '', '', '', '');

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

--
-- Table structure for table `course_teacher`
--

CREATE TABLE `course_teacher` (
  `id` int(10) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `name` text NOT NULL,
  `short_description` text NOT NULL,
  `experience` text NOT NULL,
  `medium` text NOT NULL,
  `lecture_mode` text NOT NULL,
  `image_profile` text NOT NULL,
  `dob` text NOT NULL,
  `gender` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `course_teacher`
--

INSERT INTO `course_teacher` (`id`, `code`, `date`, `time`, `name`, `short_description`, `experience`, `medium`, `lecture_mode`, `image_profile`, `dob`, `gender`) VALUES
(1, '4680', '20-08-24', '01:14', 'Prerna Soni', '100% performance', '2 years', 'English', 'GIVE-AND-TAKE', 'upload/girl.webp', '1999-11-25', 'Female'),
(2, '3599', '20-08-24', '01:21', 'Ashna Mansuri', 'Terms & Conditions', '1-2 Years', 'English', 'REPORT-AND-DISCUSS', 'upload/hum.webp', '1996-06-01', 'Female'),
(4, '4510', '20-08-24', '01:23', 'Zishan Khan', ' I am trying my best', '8-9 Months', 'Hindi', 'TALK-AND-CHALK', 'upload/dum.webp', '2003-10-10', 'Male');

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

--
-- Table structure for table `data_description`
--

CREATE TABLE `data_description` (
  `id` int(10) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `heading` text NOT NULL,
  `description1` text NOT NULL,
  `description2` text NOT NULL,
  `description3` text NOT NULL,
  `link` text NOT NULL,
  `data_code` text NOT NULL,
  `example_code` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `data_description`
--

INSERT INTO `data_description` (`id`, `code`, `date`, `time`, `heading`, `description1`, `description2`, `description3`, `link`, `data_code`, `example_code`) VALUES
(2, '1860', '23-08-24', '05:29', 'Web Development', 'Make Solution', 'Make Solution', 'Make Solution', 'https/Make Solution', '4725', '7672'),
(3, '8536', '24-08-24', '07:03', 'fedfsdf', 'fdfsdf', 'fdsfsdfsd', 'fdsfds', 'fdsfds', '9537', '9638'),
(5, '8948', '28-08-24', '06:08', 'Graphic Designing', 'Make Solution', 'Make Solution', 'Make Solution', 'https/Make Solution', '6324', 'waewfe778fe'),
(6, '5868', '29-08-24', '06:42', 'Web Development', 'Best Web Design & Software Development & Mobile App Development Company in Kota, Rajasthan, India', 'MakeSolution is a best website design and development company in Kota, which gives you a creative web design and development service in Kota, Rajasthan and pan India.', 'MakeSolution, a leading creative Website Design, Software Development and Website Development Company in Kota, Rajasthan, India. We also offers Mobile App Development and Digital marketing services all across PAN India.', 'http://www.makesolution.in/', '4484', 'waewfe778fe'),
(7, '8183', '30-08-24', '12:27', 'Graphic Designing', 'Best Web Design & Software Development & Mobile App Development Company in Kota, Rajasthan, India', 'MakeSolution is a best website design and development company in Kota, which gives you a creative web design and development service in Kota, Rajasthan and pan India.', 'MakeSolution, a leading creative Website Design, Software Development and Website Development Company in Kota, Rajasthan, India. We also offers Mobile App Development and Digital marketing services all across PAN India.', 'http://www.makesolution.in/', '8379', 'waewfe778fe'),
(8, '7636', '31-08-24', '12:27', 'App Development', 'Mobile application development is the process of creating software applications that run on a mobile device', 'Mobile application development is the process of creating software applications that run on a mobile device', 'They work in popular operating system environments like iOS and Android and often take into account UI and UX principles when creating applications.', 'http://www.makesolution.in/', '7327', 'Design'),
(9, '1480', '31-08-24', '04:03', 'Web Development', ' Web development refers to the creating, building, and maintaining of websites.', 'Web development encompasses a broad range of tasks from coding, to technical design, to performance of a website or application running on the internet', 'Web development is the work involved in developing a website for the Internet (World Wide Web) or an intranet (a private network).', 'http://www.makesolution.in/', '9607', 'HTML'),
(10, '9827', '31-08-24', '04:09', 'Digital Marketing', 'Digital marketing, also called online marketing', 'Digital marketing is the use of websites, apps, mobile devices, social media, search engines, and other digital means to promote and sell products and services.', 'This includes not only email, social media, and web-based advertising, but also text and multimedia messages as a marketing channel.', 'http://www.makesolution.in/', '9076', '‎Social Media Marketing (SMM)'),
(11, '2882', '31-08-24', '04:13', 'Programming Language', 'A programming language is a system of notation for writing computer programs ;', 'It is a tool programmers use to communicate with and control the behavior of a machine, more often a computer.', 'A programming language is a set of instructions written by a programmer to deliver instructions to the computer to perform and accomplish a task.', 'http://www.makesolution.in/', '6730', 'Basic C Program'),
(12, '9284', '31-08-24', '04:18', 'Word Press', 'WordPress is an open-source content management system (CMS). ', 'WordPress is the most easy to use website and blog creation tool and content management system (or CMS) available', 'All of our courses are created for use with WordPress.com managed hosting.', 'http://www.makesolution.in/', '4857', 'Plugins');

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

--
-- Table structure for table `feedback`
--

CREATE TABLE `feedback` (
  `id` int(10) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `name` text NOT NULL,
  `feedback` text NOT NULL,
  `status` text NOT NULL,
  `remark` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `feedback`
--

INSERT INTO `feedback` (`id`, `code`, `date`, `time`, `name`, `feedback`, `status`, `remark`) VALUES
(1, '1848', '16-08-24', '03:27', 'shariq ansari', 'Website', 'Deactive', 'Call us soon'),
(6, '3752', '22-08-24', '04:14', 'ghg', 'hggh', 'active', ''),
(7, '5179', '23-08-24', '12:04', 'harshita', 'ddsds', 'active', 'asdsf');

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

--
-- Table structure for table `how_to_schema`
--

CREATE TABLE `how_to_schema` (
  `id` int(10) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `name` text NOT NULL,
  `description` text NOT NULL,
  `video_time` text NOT NULL,
  `costs` text NOT NULL,
  `image_url` text NOT NULL,
  `supply` text NOT NULL,
  `tool` text NOT NULL,
  `instructure_step` text NOT NULL,
  `image_url_step` text NOT NULL,
  `name_step` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `how_to_schema`
--

INSERT INTO `how_to_schema` (`id`, `code`, `date`, `time`, `name`, `description`, `video_time`, `costs`, `image_url`, `supply`, `tool`, `instructure_step`, `image_url_step`, `name_step`) VALUES
(1, '2843', '16-08-24', '11:06', 'Yuvika verma', '1', '1', '1', '1', '1', '1', '1', '1', '1');

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

--
-- Table structure for table `images`
--

CREATE TABLE `images` (
  `id` int(10) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `image_category` text NOT NULL,
  `image` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `images`
--

INSERT INTO `images` (`id`, `code`, `date`, `time`, `image_category`, `image`) VALUES
(1, '[value-2]', '[value-3]', '[value-4]', 'Samsung', 'upload/1609736490.jpg'),
(3, '6166', '12-08-24', '02:20', 'Samsung', 'upload/1662817728493.jfif');

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

--
-- Table structure for table `job_benefits`
--

CREATE TABLE `job_benefits` (
  `id` int(10) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `job_code` text NOT NULL,
  `benefit` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `job_benefits`
--

INSERT INTO `job_benefits` (`id`, `code`, `date`, `time`, `job_code`, `benefit`) VALUES
(10, '6502', '29-08-24', '12:36', '2903', 'benefit of '),
(11, '7902', '29-08-24', '12:37', '2903', 'benefit of '),
(12, '1481', '29-08-24', '12:37', '2903', 'benefit of '),
(13, '8472', '29-08-24', '12:37', '2903', 'benefit of '),
(20, '9631', '29-08-24', '01:18', '1802', 'benefit of '),
(23, '9115', '30-08-24', '03:08', '7131', 'benefit of '),
(24, '3592', '30-08-24', '03:08', '7131', 'benefit of  employment');

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

--
-- Table structure for table `job_category`
--

CREATE TABLE `job_category` (
  `id` int(10) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `category_name` text NOT NULL,
  `image` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `job_category`
--

INSERT INTO `job_category` (`id`, `code`, `date`, `time`, `category_name`, `image`) VALUES
(1, '6906', '17-08-24', '11:31', 'Web Development', 'upload/ygfutyj.png'),
(3, '3119', '17-08-24', '11:39', 'Video Editing', 'upload/laptop.webp'),
(4, '9114', '17-08-24', '01:01', 'Graphic Designing', 'upload/dum.webp');

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

--
-- Table structure for table `job_posting_schema`
--

CREATE TABLE `job_posting_schema` (
  `id` int(10) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `job_title` text NOT NULL,
  `search_query` text NOT NULL,
  `job_description` text NOT NULL,
  `company` text NOT NULL,
  `company_url` text NOT NULL,
  `company_logo` text NOT NULL,
  `industry` text NOT NULL,
  `employment_type` text NOT NULL,
  `work_time` text NOT NULL,
  `date_post` text NOT NULL,
  `expire_date` text NOT NULL,
  `country` text NOT NULL,
  `state` text NOT NULL,
  `street` text NOT NULL,
  `city` text NOT NULL,
  `zipcode` text NOT NULL,
  `min_salary` text NOT NULL,
  `max_salary` text NOT NULL,
  `carruncy` text NOT NULL,
  `salary_type` text NOT NULL,
  `responsibility` text NOT NULL,
  `skills` text NOT NULL,
  `qualification` text NOT NULL,
  `education_requirement` text NOT NULL,
  `experience_requirement` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `job_posting_schema`
--

INSERT INTO `job_posting_schema` (`id`, `code`, `date`, `time`, `job_title`, `search_query`, `job_description`, `company`, `company_url`, `company_logo`, `industry`, `employment_type`, `work_time`, `date_post`, `expire_date`, `country`, `state`, `street`, `city`, `zipcode`, `min_salary`, `max_salary`, `carruncy`, `salary_type`, `responsibility`, `skills`, `qualification`, `education_requirement`, `experience_requirement`) VALUES
(2, '8138', '16-08-24', '12:45', 'Web Developer', 'Developement', 'Make Solution', 'Make Solution', 'httpxc ', 'dsfvtrbf', 'bsrtttgbsb', 'bttrhb', 'drtj5jytj', 'redt6jyjkk', 'drtttit8k6', 'India', 'Rajasthan', 'Gumanpura', 'Kota', '147856', '10,000', '12,000', 'Rupees', 'Cash', 'rtjytydrn', 'Reading', 'B.A.', 'Graduation', 'Fresher');

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

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` int(10) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `category_name` text NOT NULL,
  `icon` text NOT NULL,
  `languages_name` text NOT NULL,
  `video_url` text NOT NULL,
  `video_thum_nail` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` (`id`, `code`, `date`, `time`, `category_name`, `icon`, `languages_name`, `video_url`, `video_thum_nail`) VALUES
(5, '6783', '22-08-24', '05:45', 'Web Development', 'upload/1703139714332.jfif', 'React', '', 'upload/'),
(6, '5270', '24-08-24', '07:01', 'Web Development', 'upload/HTML.webp', 'HTML', '', 'upload/'),
(8, '8816', '28-08-24', '11:04', 'App Development', 'upload/web-programming-languages-1.jpg', 'PHP', '', 'upload/'),
(9, '3521', '28-08-24', '11:19', 'Digital Marketing', 'upload/10-Types-of-Digital-Marketing-You-Should-Know-1536x864.jpg', 'SEO', '', 'upload/'),
(10, '9104', '28-08-24', '03:41', 'Programming Language', 'upload/coding-languages-2024.webp', 'Java Script', '', 'upload/'),
(11, '7704', '28-08-24', '03:43', 'Programming Language', 'upload/Top-5-Programming-1024x576.jpg', 'PHP', '', 'upload/'),
(12, '8672', '28-08-24', '03:45', 'Programming Language', 'upload/programming-language-web-development-set-program-code-software-programmer-designer-specialist-developer-engaged-180219764.webp', 'Python', '', 'upload/'),
(13, '5436', '28-08-24', '03:49', 'Graphic Designing', 'upload/Graphic-_Design.jpg', 'Coral Draw', '', 'upload/'),
(14, '8898', '28-08-24', '03:58', 'Graphic Designing', 'upload/design-concept-illustration-idea-style-creativity-projects_613284-3229.avif', 'Photoshop', '', 'upload/'),
(15, '8787', '31-08-24', '11:56', 'Word Press Training', 'upload/wordpress.jpg', 'PHP', '', 'upload/'),
(16, '5942', '13-09-24', '04:00', 'Web Development', 'upload/degreewala-it-training-institute-kota-website-developemt-learn-html.webp', 'HTML', '', 'upload/'),
(17, '7086', '13-09-24', '04:00', 'Web Development', 'upload/degreewala-it-training-institute-kota-website-developemt-learn-CSS.webp', 'CSS', '', 'upload/');

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

--
-- Table structure for table `main_category`
--

CREATE TABLE `main_category` (
  `id` int(10) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `category_name` text NOT NULL,
  `icon` text NOT NULL,
  `video_url` text NOT NULL,
  `video_thum_nail` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `main_category`
--

INSERT INTO `main_category` (`id`, `code`, `date`, `time`, `category_name`, `icon`, `video_url`, `video_thum_nail`) VALUES
(7, '2150', '27-08-24', '01:39', 'Word Press Training', 'upload/degreewala-pro-developer.svg', 'n8Y5RNX0OcU', 'upload/'),
(8, '2211', '27-08-24', '01:40', 'App Development', 'upload/degreewala-app-development.svg', '', 'upload/'),
(9, '5217', '27-08-24', '06:00', 'Web Development', 'upload/degreewala-web-developer.svg', '', 'upload/'),
(11, '1472', '27-08-24', '06:12', 'Digital Marketing', 'upload/digital-marketing1.svg', '', 'upload/'),
(12, '3224', '28-08-24', '03:30', 'Graphic Designing', 'upload/favicon-icon.jfif', '', 'upload/'),
(13, '7691', '28-08-24', '03:33', 'Programming Language', 'upload/degreewala-languages.svg', '', 'upload/');

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

--
-- Table structure for table `meta_tag`
--

CREATE TABLE `meta_tag` (
  `id` int(10) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `course_code` text NOT NULL,
  `description` text NOT NULL,
  `keywords` text NOT NULL,
  `og_site_name` text NOT NULL,
  `og_title` text NOT NULL,
  `og_url` text NOT NULL,
  `og_description` text NOT NULL,
  `og_image` text NOT NULL,
  `og_type` text NOT NULL,
  `article_author` text NOT NULL,
  `article_publisher` text NOT NULL,
  `instagram_card` text NOT NULL,
  `instagram_site` text NOT NULL,
  `instagram_creator` text NOT NULL,
  `instagram_image` text NOT NULL,
  `instagram_title` text NOT NULL,
  `instagram_description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `meta_tag`
--

INSERT INTO `meta_tag` (`id`, `code`, `date`, `time`, `course_code`, `description`, `keywords`, `og_site_name`, `og_title`, `og_url`, `og_description`, `og_image`, `og_type`, `article_author`, `article_publisher`, `instagram_card`, `instagram_site`, `instagram_creator`, `instagram_image`, `instagram_title`, `instagram_description`) VALUES
(8, '7091', '12-08-24', '03:16', '6783', 'MakeSolution is a best website design in Kota, Rajasthan and pan India.', 'web design company, creative website design company in india, mobile app development service, best software development company', 'Make Solution', 'Best Web Design & Software Development Company in Kota, Rajasthan, India', 'http://www.makeinfotech.com/', 'MakeSolution is a best website design in Kota, Rajasthan and pan India.', 'https://makesolution.in/img/mslogo3.png', 'website', 'Make Solution', 'Make Solution', 'summary', '@makesolutionn', '@makesolutionn', 'https://makesolution.in/img/mslogo3.png', 'Best Web Design & Software Development & Mobile App Development Company in Kota, Rajasthan, India', 'MakeSolution is a best website design and development company in Kota, which gives you a creative web design and development service in Kota, Rajasthan and pan India.'),
(9, '7359', '12-08-24', '05:04', '5979', 'fspfpjp[', 'ioopjpoi', 'jopjp[o', 'jpoiijkp[', 'ojpojpo', 'jpojpo', 'joppjp[o', 'jopj[o', 'j[ojo0[', 'jpioj', 'jlkijn', 'pijpijp', 'jp', 'jpo', 'j', 'poj'),
(10, '2036', '12-08-24', '05:07', '9521', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '11', '1', '1'),
(11, '3420', '12-08-24', '07:07', '[value-2]', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1'),
(12, '5211', '30-08-24', '02:27', '5217', 'MakeSolution, a leading creative Website Design, Software Development and Website Development Company in Kota, Rajasthan, India. We also offers Mobile App Development and Digital marketing services all across PAN India.', 'web design company, creative website design company, web designing company in Kota, web development services company, best web development company in india, mobile app development service, best software development company', 'Make Solution', 'Best Web Design & Software Development & Mobile App Development Company in Kota, Rajasthan, India', 'http://www.makeinfotech.com/', 'MakeSolution is a best website design and development company in Kota, which gives you a creative web design and development service in Kota, Rajasthan and pan India.', 'https://makesolution.in/img/mslogo3.png', 'website', 'Make Solution', 'Make Solution', 'summary', '@makesolutionn', '@makesolutionn', 'https://makesolution.in/img/mslogo3.png', 'Best Web Design & Software Development & Mobile App Development Company in Kota, Rajasthan, India', 'MakeSolution is a best website design and development company in Kota, which gives you a creative web design and development service in Kota, Rajasthan and pan India.'),
(13, '7553', '30-08-24', '02:44', '2150', 'rdhh6d', 'ioopjpoi', 'dgtr ', 'jpoiijkp[', 'ojpojpo', 'tydjgyj', 'joppjp[o', 'jopj[o', 'fyhr54g', 'ey54te4', 'tykjtyk', 'tydfkyt', 'rftjurt', 'rtirt', 'rikrtyko', 'ryuedgter'),
(14, '5096', '30-08-24', '02:57', '8379', 'MakeSolution, a leading creative Website Design, Software Development and Website Development Company in Kota, Rajasthan, India. We also offers Mobile App Development and Digital marketing services all across PAN India.', 'web design company, creative website design company, web designing company in Kota, web development services company, best web development company in india, mobile app development service, best software development company', 'Make Solution', 'Best Web Design & Software Development & Mobile App Development Company in Kota, Rajasthan, India', 'http://www.makeinfotech.com/', 'MakeSolution is a best website design and development company in Kota, which gives you a creative web design and development service in Kota, Rajasthan and pan India.', 'https://makesolution.in/img/mslogo3.png', 'website', 'Make Solution', 'Make Solution', 'summary', '@makesolutionn', '@makesolutionn', 'https://makesolution.in/img/mslogo3.png', 'Best Web Design & Software Development & Mobile App Development Company in Kota, Rajasthan, India', 'MakeSolution is a best website design and development company in Kota, which gives you a creative web design and development service in Kota, Rajasthan and pan India.'),
(15, '4621', '30-08-24', '02:58', '2211', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1'),
(16, '1358', '30-08-24', '02:59', '1472', 'MakeSolution, a leading creative Website Design, Software Development and Website Development Company in Kota, Rajasthan, India. We also offers Mobile App Development and Digital marketing services all across PAN India.', 'web design company, creative website design company, web designing company in Kota, web development services company, best web development company in india, mobile app development service, best software development company', 'Make Solution', 'Best Web Design & Software Development & Mobile App Development Company in Kota, Rajasthan, India', 'http://www.makeinfotech.com/', 'MakeSolution is a best website design and development company in Kota, which gives you a creative web design and development service in Kota, Rajasthan and pan India.', 'https://makesolution.in/img/mslogo3.png', 'website', 'Make Solution', 'Make Solution', 'summary', '@makesolutionn', '@makesolutionn', 'https://makesolution.in/img/mslogo3.png', 'Best Web Design & Software Development & Mobile App Development Company in Kota, Rajasthan, India', 'MakeSolution is a best website design and development company in Kota, which gives you a creative web design and development service in Kota, Rajasthan and pan India.'),
(17, '4385', '30-08-24', '03:00', '3224', 'MakeSolution, a leading creative Website Design, Software Development and Website Development Company in Kota, Rajasthan, India. We also offers Mobile App Development and Digital marketing services all across PAN India.', 'web design company, creative website design company, web designing company in Kota, web development services company, best web development company in india, mobile app development service, best software development company', 'Make Solution', 'Best Web Design & Software Development & Mobile App Development Company in Kota, Rajasthan, India', 'http://www.makeinfotech.com/', 'MakeSolution is a best website design and development company in Kota, which gives you a creative web design and development service in Kota, Rajasthan and pan India.', 'https://makesolution.in/img/mslogo3.png', 'website', 'Make Solution', 'Make Solution', 'summary', '@makesolutionn', '@makesolutionn', 'https://makesolution.in/img/mslogo3.png', 'Best Web Design & Software Development & Mobile App Development Company in Kota, Rajasthan, India', 'MakeSolution is a best website design and development company in Kota, which gives you a creative web design and development service in Kota, Rajasthan and pan India.'),
(18, '2966', '30-08-24', '03:00', '7691', 'MakeSolution, a leading creative Website Design, Software Development and Website Development Company in Kota, Rajasthan, India. We also offers Mobile App Development and Digital marketing services all across PAN India.', 'web design company, creative website design company, web designing company in Kota, web development services company, best web development company in india, mobile app development service, best software development company', 'Make Solution', 'Best Web Design & Software Development & Mobile App Development Company in Kota, Rajasthan, India', 'http://www.makeinfotech.com/', 'MakeSolution is a best website design and development company in Kota, which gives you a creative web design and development service in Kota, Rajasthan and pan India.', 'https://makesolution.in/img/mslogo3.png', 'website', 'Make Solution', 'Make Solution', 'summary', '@makesolutionn', '@makesolutionn', 'https://makesolution.in/img/mslogo3.png', 'Best Web Design & Software Development & Mobile App Development Company in Kota, Rajasthan, India', 'MakeSolution is a best website design and development company in Kota, which gives you a creative web design and development service in Kota, Rajasthan and pan India.'),
(19, '5241', '30-08-24', '03:01', '5270', 'MakeSolution, a leading creative Website Design, Software Development and Website Development Company in Kota, Rajasthan, India. We also offers Mobile App Development and Digital marketing services all across PAN India.', 'web design company, creative website design company, web designing company in Kota, web development services company, best web development company in india, mobile app development service, best software development company', 'Make Solution', 'Best Web Design & Software Development & Mobile App Development Company in Kota, Rajasthan, India', 'http://www.makeinfotech.com/', 'MakeSolution is a best website design and development company in Kota, which gives you a creative web design and development service in Kota, Rajasthan and pan India.', 'https://makesolution.in/img/mslogo3.png', 'website', 'Make Solution', 'Make Solution', 'summary', '@makesolutionn', '@makesolutionn', 'https://makesolution.in/img/mslogo3.png', 'Best Web Design & Software Development & Mobile App Development Company in Kota, Rajasthan, India', 'MakeSolution is a best website design and development company in Kota, which gives you a creative web design and development service in Kota, Rajasthan and pan India.'),
(20, '9957', '30-08-24', '03:02', '8816', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1'),
(21, '8224', '30-08-24', '03:02', '3521', 'MakeSolution, a leading creative Website Design, Software Development and Website Development Company in Kota, Rajasthan, India. We also offers Mobile App Development and Digital marketing services all across PAN India.', 'web design company, creative website design company, web designing company in Kota, web development services company, best web development company in india, mobile app development service, best software development company', 'Make Solution', 'Best Web Design & Software Development & Mobile App Development Company in Kota, Rajasthan, India', 'http://www.makeinfotech.com/', 'MakeSolution is a best website design and development company in Kota, which gives you a creative web design and development service in Kota, Rajasthan and pan India.', 'https://makesolution.in/img/mslogo3.png', 'website', 'Make Solution', 'Make Solution', 'summary', '@makesolutionn', '@makesolutionn', 'https://makesolution.in/img/mslogo3.png', 'Best Web Design & Software Development & Mobile App Development Company in Kota, Rajasthan, India', 'MakeSolution is a best website design and development company in Kota, which gives you a creative web design and development service in Kota, Rajasthan and pan India.'),
(22, '3537', '30-08-24', '03:03', '9104', 'MakeSolution, a leading creative Website Design, Software Development and Website Development Company in Kota, Rajasthan, India. We also offers Mobile App Development and Digital marketing services all across PAN India.', 'web design company, creative website design company, web designing company in Kota, web development services company, best web development company in india, mobile app development service, best software development company', 'Make Solution', 'Best Web Design & Software Development & Mobile App Development Company in Kota, Rajasthan, India', 'http://www.makeinfotech.com/', 'MakeSolution is a best website design and development company in Kota, which gives you a creative web design and development service in Kota, Rajasthan and pan India.', 'https://makesolution.in/img/mslogo3.png', 'website', 'Make Solution', 'Make Solution', 'summary', '@makesolutionn', '@makesolutionn', 'https://makesolution.in/img/mslogo3.png', 'Best Web Design & Software Development & Mobile App Development Company in Kota, Rajasthan, India', 'MakeSolution is a best website design and development company in Kota, which gives you a creative web design and development service in Kota, Rajasthan and pan India.'),
(23, '9387', '30-08-24', '03:04', '9537', 'MakeSolution, a leading creative Website Design, Software Development and Website Development Company in Kota, Rajasthan, India. We also offers Mobile App Development and Digital marketing services all across PAN India.', 'web design company, creative website design company, web designing company in Kota, web development services company, best web development company in india, mobile app development service, best software development company', 'Make Solution', 'Best Web Design & Software Development & Mobile App Development Company in Kota, Rajasthan, India', 'http://www.makeinfotech.com/', 'MakeSolution is a best website design and development company in Kota, which gives you a creative web design and development service in Kota, Rajasthan and pan India.', 'https://makesolution.in/img/mslogo3.png', 'website', 'Make Solution', 'Make Solution', 'summary', '@makesolutionn', '@makesolutionn', 'https://makesolution.in/img/mslogo3.png', 'Best Web Design & Software Development & Mobile App Development Company in Kota, Rajasthan, India', 'MakeSolution is a best website design and development company in Kota, which gives you a creative web design and development service in Kota, Rajasthan and pan India.'),
(24, '9850', '30-08-24', '03:06', '4725', 'abcdef', 'abcdef', 'abcdef', 'abcdef', 'abcdef', 'abcdef', 'abcdef', 'abcdef', 'abcdef', 'abcdef', 'abcdef', 'abcdef', 'abcdef', 'abcdef', 'abcdef', 'abcdef');

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

--
-- Table structure for table `person_schema`
--

CREATE TABLE `person_schema` (
  `id` int(10) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `name` text NOT NULL,
  `url` text NOT NULL,
  `picture_url` text NOT NULL,
  `job_title` text NOT NULL,
  `company` text NOT NULL,
  `facebook` text NOT NULL,
  `twitter` text NOT NULL,
  `instagram` text NOT NULL,
  `linkedin` text NOT NULL,
  `pinterest` text NOT NULL,
  `other` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `person_schema`
--

INSERT INTO `person_schema` (`id`, `code`, `date`, `time`, `name`, `url`, `picture_url`, `job_title`, `company`, `facebook`, `twitter`, `instagram`, `linkedin`, `pinterest`, `other`) VALUES
(2, '1713', '14-08-24', '06:50', 'Sharmin Sheikh', 'Make Solution', 'Make Solution', 'Developer', 'Make Solution', 'Make Solution', 'Make Solution', 'Make Solution', 'Make Solution', 'Make Solution', 'Make Solution'),
(3, '3834', '20-08-24', '04:52', 'Zishan Khan', 'https://www.microsoft.com/en-in/', 'Make Solution', 'Web Developer', 'Make Solution', 'Make Solution', 'Make Solution', 'Make Solution', 'Make Solution', 'Make Solution', 'Make Solution'),
(6, '4680', '20-08-24', '05:20', 'shariq ansari', 'https://www.flipkart.com/', 'Make Solution', 'Web Developer', 'Make Solution', 'Make Solution', 'Make Solution', 'Make Solution', 'Make Solution', 'Make Solution', 'Make Solution');

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

--
-- Table structure for table `question`
--

CREATE TABLE `question` (
  `id` int(10) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `product_code` text NOT NULL,
  `question` text NOT NULL,
  `answer` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `question`
--

INSERT INTO `question` (`id`, `code`, `date`, `time`, `product_code`, `question`, `answer`) VALUES
(3, '', '12-08-24', '02:02', '2150', 'can I call you?', 'I call you letter'),
(4, '1339', '12-08-24', '02:15', '6783', 'What is the purpose of this pen?', 'This pen is designed to provide web developers with boilerplate code for a FAQ Accordion.'),
(6, '1855', '29-08-24', '05:09', '2150', 'Can I use this accordion in my project?', 'Absolutely! Feel free to use this accordion in your projects. You can modify and adapt it as needed to fit your requirements.'),
(7, '6940', '29-08-24', '05:09', '2211', 'Can I use this accordion in my project?', 'Absolutely! Feel free to use this accordion in your projects. You can modify and adapt it as needed to fit your requirements.'),
(8, '8079', '29-08-24', '05:09', '2211', 'How can I customize the accordion?', 'You can customize the accordion by modifying the CSS styles and changing the HTML structure as per your needs. You can also add JavaScript to enhance its functionality.'),
(9, '1915', '29-08-24', '05:14', '5217', 'Is this accordion responsive?', 'Yes, this accordion is designed to be responsive and will adjust its layout based on the screen size to ensure a good user experience on both desktop and mobile devices.'),
(10, '1684', '29-08-24', '05:32', '5217', 'can i ask you a question?', 'Yes, absolutely.'),
(11, '7533', '29-08-24', '05:33', '1472', 'What is an accordion?', 'An accordion is a vertically stacked list of headers that users can click on to reveal more information about a business. With an accordion, when someone visits your web page, they will see a list of headers.'),
(12, '9589', '29-08-24', '05:33', '3224', 'How can I customize the accordion?', 'You can customize the accordion by modifying the CSS styles and changing the HTML structure as per your needs. You can also add JavaScript to enhance its functionality.'),
(13, '8738', '29-08-24', '05:34', '7691', 'Can I use this accordion in my project?', 'Absolutely! Feel free to use this accordion in your projects. You can modify and adapt it as needed to fit your requirements.'),
(14, '5782', '29-08-24', '06:07', '8816', 'Can I use this accordion in my project?', 'Absolutely! Feel free to use this accordion in your projects. You can modify and adapt it as needed to fit your requirements.'),
(15, '2401', '29-08-24', '06:19', '5270', 'Is this accordion responsive?', 'Yes, this accordion is designed to be responsive and will adjust its layout based on the screen size to ensure a good user experience on both desktop and mobile devices.'),
(16, '7878', '29-08-24', '06:20', '3521', 'How can I customize the accordion?', 'You can customize the accordion by modifying the CSS styles and changing the HTML structure as per your needs. You can also add JavaScript to enhance its functionality.'),
(17, '2728', '29-08-24', '06:20', '7704', 'What is an accordion?', 'An accordion is a vertically stacked list of headers that users can click on to reveal more information about a business. With an accordion, when someone visits your web page, they will see a list of headers.'),
(18, '1528', '29-08-24', '06:21', '8379', 'What is the purpose of this pen?', 'An accordion is a vertically stacked list of headers that users can click on to reveal more information about a business. With an accordion, when someone visits your web page, they will see a list of headers.'),
(19, '4441', '29-08-24', '06:21', '4725', 'Is this accordion responsive?', 'Yes, this accordion is designed to be responsive and will adjust its layout based on the screen size to ensure a good user experience on both desktop and mobile devices.'),
(20, '1669', '29-08-24', '06:22', '9537', 'Can I use this accordion in my project?', 'Absolutely! Feel free to use this accordion in your projects. You can modify and adapt it as needed to fit your requirements.'),
(21, '1520', '29-08-24', '06:22', '4484', 'How can I customize the accordion?', 'You can customize the accordion by modifying the CSS styles and changing the HTML structure as per your needs. You can also add JavaScript to enhance its functionality.'),
(22, '6600', '29-08-24', '06:23', '6324', 'What is the purpose of this pen?', 'This pen is designed to provide web developers with boilerplate code for a FAQ Accordion.'),
(23, '2993', '31-08-24', '12:54', '7327', 'What is an accordion?', 'An accordion is a vertically stacked list of headers that users can click on to reveal more information about a business. With an accordion, when someone visits your web page, they will see a list of headers.'),
(24, '6498', '03-09-24', '11:25', '9607', 'Can I use this accordion in my project?', 'Absolutely! Feel free to use this accordion in your projects. You can modify and adapt it as needed to fit your requirements.'),
(25, '6022', '03-09-24', '11:25', '9076', 'Is this accordion responsive?', 'Yes, this accordion is designed to be responsive and will adjust its layout based on the screen size to ensure a good user experience on both desktop and mobile devices.'),
(26, '9452', '03-09-24', '11:26', '6730', 'How can I customize the accordion?', 'You can customize the accordion by modifying the CSS styles and changing the HTML structure as per your needs. You can also add JavaScript to enhance its functionality.'),
(27, '7450', '03-09-24', '11:26', '4857', 'What is an accordion?', 'An accordion is a vertically stacked list of headers that users can click on to reveal more information about a business. With an accordion, when someone visits your web page, they will see a list of headers.');

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

--
-- Table structure for table `search_tag`
--

CREATE TABLE `search_tag` (
  `id` int(10) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `search_code` text NOT NULL,
  `search_tag` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `search_tag`
--

INSERT INTO `search_tag` (`id`, `code`, `date`, `time`, `search_code`, `search_tag`) VALUES
(1, '2727', '22-08-24', '06:17', '8379', 'GRAPHIC DESIGNING'),
(3, '2277', '23-08-24', '04:38', '8816', 'Programming Language'),
(4, '4763', '30-08-24', '03:52', '2150', 'HTML'),
(5, '2087', '30-08-24', '03:57', '2150', 'CSS'),
(6, '1830', '30-08-24', '05:50', '2211', 'APP DEVELOPMENT'),
(7, '4430', '30-08-24', '06:29', '8379', 'COREL DRAW'),
(8, '6268', '30-08-24', '06:40', '2211', 'JAVA SCRIPT'),
(9, '1585', '30-08-24', '06:41', '5217', 'WEB DEVELOPMENT'),
(10, '3295', '30-08-24', '06:41', '5217', 'JQUERY'),
(11, '6242', '30-08-24', '06:42', '1472', 'GOOGLE ADS'),
(12, '7505', '30-08-24', '06:43', '1472', 'YOUTUBE ADS'),
(13, '6279', '30-08-24', '06:43', '3224', 'ADOBE XD'),
(14, '3185', '30-08-24', '06:45', '3224', 'PHOTOSHOP'),
(15, '2185', '30-08-24', '06:46', '7691', 'C++'),
(16, '7159', '30-08-24', '06:46', '7691', 'ASP.NET'),
(17, '5057', '30-08-24', '06:46', '7691', 'PYTHON'),
(18, '2838', '30-08-24', '06:47', '7691', 'JAVA SCRIPT'),
(19, '6895', '30-08-24', '06:47', '7691', 'PHP'),
(20, '7287', '30-08-24', '06:47', '7691', 'JAVA'),
(21, '6071', '30-08-24', '06:55', '2150', 'PHP'),
(22, '8425', '30-08-24', '06:56', '2150', 'JAVA SCRIPT'),
(23, '4440', '30-08-24', '06:56', '2150', 'PLUGIN DEVELOPMENT'),
(24, '6373', '30-08-24', '06:58', '2211', 'UI DESIGN(XML)'),
(25, '1576', '30-08-24', '06:58', '2211', 'ANDROID'),
(26, '7561', '30-08-24', '06:58', '2211', 'DBMS'),
(27, '2094', '30-08-24', '06:58', '2211', 'REACT NATIVE'),
(28, '9869', '30-08-24', '06:59', '5217', 'BOOTSTRAP'),
(29, '4337', '30-08-24', '06:59', '5217', 'CODEIGNITER'),
(30, '6283', '30-08-24', '07:00', '5217', 'LARAVEL'),
(31, '6782', '30-08-24', '07:00', '5217', 'MY SQL'),
(32, '9407', '30-08-24', '07:01', '1472', 'MOBILE MARKETING'),
(33, '2274', '30-08-24', '07:01', '1472', 'BULK SMS MARKETING'),
(34, '8461', '30-08-24', '07:01', '1472', 'GROWTH HACKING'),
(35, '3473', '30-08-24', '07:02', '1472', 'MARKETING STRATEGY'),
(36, '6462', '30-08-24', '07:02', '3224', 'ADOBE ILLUSTRATOR'),
(37, '3213', '30-08-24', '07:03', '3224', 'COREL DRAW'),
(38, '4627', '31-08-24', '11:06', '6783', 'HTML'),
(39, '8243', '31-08-24', '11:06', '6783', 'CSS'),
(40, '1725', '31-08-24', '11:07', '6783', 'JQUERY'),
(41, '8228', '31-08-24', '11:07', '6783', 'JAVA SCRIPT'),
(42, '9419', '31-08-24', '11:07', '6783', 'BOOTSTRAP'),
(43, '7893', '31-08-24', '11:07', '6783', 'PHP'),
(44, '8060', '31-08-24', '11:08', '5270', 'CODEIGNITER'),
(45, '6543', '31-08-24', '11:08', '5270', 'LARAVEL'),
(46, '4036', '31-08-24', '11:08', '5270', 'AJAX'),
(47, '4710', '31-08-24', '11:08', '5270', 'PYTHON'),
(48, '3347', '31-08-24', '11:08', '5270', 'JAVA'),
(49, '8020', '31-08-24', '11:08', '5270', 'MY SQL'),
(50, '7831', '31-08-24', '11:09', '8816', 'JAVA'),
(51, '5091', '31-08-24', '11:09', '8816', 'UI DESIGN (XML)'),
(52, '7683', '31-08-24', '11:09', '8816', 'PHP'),
(53, '9234', '31-08-24', '11:09', '8816', 'ANDROID'),
(54, '1466', '31-08-24', '11:09', '8816', 'DBMS'),
(55, '6581', '31-08-24', '11:10', '3521', 'SEO'),
(56, '8585', '31-08-24', '11:10', '3521', 'SMM'),
(57, '1423', '31-08-24', '11:10', '3521', 'SMO'),
(58, '6591', '31-08-24', '11:10', '3521', 'GOOGLE ADS'),
(59, '2681', '31-08-24', '11:10', '3521', 'YOUTUBE ADS'),
(60, '2684', '31-08-24', '11:10', '3521', 'EMAIL MARKETING'),
(61, '2389', '31-08-24', '11:11', '9104', 'C, C++, C#'),
(62, '1165', '31-08-24', '11:11', '9104', 'ASP.NET'),
(63, '4948', '31-08-24', '11:11', '9104', 'JAVA'),
(64, '8023', '31-08-24', '11:11', '9104', 'JAVA SCRIPT'),
(65, '2494', '31-08-24', '11:11', '9104', 'PHP'),
(66, '4110', '31-08-24', '11:12', '9104', 'PYTHON'),
(67, '3564', '31-08-24', '11:12', '7704', 'C++'),
(68, '7291', '31-08-24', '11:12', '7704', 'ASP.NET'),
(69, '5174', '31-08-24', '11:12', '7704', 'JAVA'),
(70, '8507', '31-08-24', '11:12', '7704', 'JAVA SCRIPT'),
(71, '4488', '31-08-24', '11:12', '7704', 'PHP'),
(72, '1172', '31-08-24', '11:12', '7704', 'PYTHON'),
(73, '9844', '31-08-24', '11:13', '8672', 'C, C++, C#'),
(74, '7002', '31-08-24', '11:13', '8672', 'ASP.NET'),
(75, '5420', '31-08-24', '11:13', '8672', 'JAVA'),
(76, '8777', '31-08-24', '11:13', '8672', 'JAVA SCRIPT'),
(77, '2266', '31-08-24', '11:13', '8672', 'PHP'),
(78, '2818', '31-08-24', '11:13', '8672', 'PYTHON'),
(79, '8931', '31-08-24', '11:14', '5436', 'PHOTOSHOP'),
(80, '3955', '31-08-24', '11:14', '5436', 'ADOBE XD'),
(81, '1791', '31-08-24', '11:14', '5436', 'ADOBE ILLUSTRATOR'),
(82, '9213', '31-08-24', '11:14', '5436', 'COREL DRAW'),
(83, '8665', '31-08-24', '11:14', '8898', 'PHOTOSHOP'),
(84, '4396', '31-08-24', '11:14', '8898', 'ADOBE XD'),
(85, '1836', '31-08-24', '11:15', '8898', 'ADOBE ILLUSTRATOR'),
(86, '6095', '31-08-24', '11:15', '8898', 'COREL DRAW'),
(87, '1989', '31-08-24', '11:28', '8379', 'PHOTOSHOP'),
(88, '4223', '31-08-24', '11:28', '8379', 'ADOBE XD'),
(89, '8283', '31-08-24', '11:28', '8379', 'ADOBE ILLUSTRATOR'),
(90, '1149', '31-08-24', '11:29', '4725', 'HTML'),
(91, '9558', '31-08-24', '11:29', '4725', 'CSS'),
(92, '7611', '31-08-24', '11:30', '4725', 'JQUERY'),
(93, '2060', '31-08-24', '11:30', '4725', 'JAVA SCRIPT'),
(94, '3867', '31-08-24', '11:30', '4725', 'BOOTSTRAP'),
(95, '8594', '31-08-24', '11:30', '4725', 'PHP'),
(96, '6761', '31-08-24', '11:30', '9537', 'CODEIGNITER'),
(97, '6267', '31-08-24', '11:30', '9537', 'LARAVEL'),
(98, '9390', '31-08-24', '11:30', '9537', 'AJAX'),
(99, '9322', '31-08-24', '11:30', '9537', 'PYTHON'),
(100, '4368', '31-08-24', '11:30', '9537', 'JAVA'),
(101, '5232', '31-08-24', '11:31', '9537', 'MY SQL'),
(102, '2814', '31-08-24', '11:31', '4484', 'HTML'),
(103, '4648', '31-08-24', '11:31', '4484', 'JQUERY'),
(104, '4528', '31-08-24', '11:31', '4484', 'JAVA SCRIPT'),
(105, '8848', '31-08-24', '11:31', '4484', 'PHP'),
(106, '9839', '31-08-24', '11:32', '4484', 'LARAVEL'),
(107, '4957', '31-08-24', '11:32', '4484', 'AJAX'),
(108, '8196', '31-08-24', '11:32', '6324', 'PHOTOSHOP'),
(109, '8131', '31-08-24', '11:32', '6324', 'ADOBE XD'),
(110, '6232', '31-08-24', '11:32', '6324', 'ADOBE ILLUSTRATOR'),
(111, '9964', '31-08-24', '11:32', '6324', 'COREL DRAW'),
(112, '7103', '31-08-24', '12:57', '7327', 'JAVA'),
(113, '1936', '31-08-24', '12:57', '7327', 'UI DESIGN(XML)'),
(114, '9223', '31-08-24', '12:57', '7327', 'PHP'),
(115, '3638', '31-08-24', '01:39', '7327', 'ANDROID'),
(116, '5239', '31-08-24', '01:40', '7327', 'REACT NATIVE'),
(117, '2548', '31-08-24', '01:40', '7327', 'DBMS'),
(118, '6600', '31-08-24', '01:42', '9607', 'EXCEL'),
(119, '6870', '31-08-24', '01:42', '9607', 'XML'),
(120, '6504', '31-08-24', '01:42', '9607', 'NODE JS'),
(121, '4201', '31-08-24', '01:43', '9607', 'TYPE SCRIPT'),
(122, '4433', '31-08-24', '01:43', '9607', 'ASP.NET'),
(123, '1722', '31-08-24', '01:44', '9607', 'APP ML'),
(124, '8553', '31-08-24', '01:59', '6324', 'INDESIGN'),
(125, '9299', '31-08-24', '02:00', '6324', 'AFTER EFFECTS'),
(126, '1647', '31-08-24', '02:01', '5436', 'AFTER EFFECTS'),
(127, '2881', '31-08-24', '02:01', '5436', 'INDESIGN'),
(128, '9128', '31-08-24', '02:01', '8898', 'INDESIGN'),
(129, '6054', '31-08-24', '02:01', '8898', 'AFTER EFFECTS'),
(130, '9510', '31-08-24', '02:02', '3224', 'INDESIGN'),
(131, '2869', '31-08-24', '02:02', '3224', 'AFTER EFFECTS'),
(132, '7267', '31-08-24', '02:34', '8787', 'HTML'),
(133, '2115', '31-08-24', '02:35', '8787', 'CSS'),
(134, '9306', '31-08-24', '02:35', '8787', 'PHP'),
(135, '4412', '31-08-24', '02:35', '8787', 'JAVA SCRIPT'),
(136, '9361', '31-08-24', '02:39', '8787', 'PLUGIN DEVELOPMENT'),
(137, '5477', '31-08-24', '02:39', '8787', 'BACKEND DEVELOPMENT'),
(138, '7791', '31-08-24', '02:41', '2150', 'BACKEND DEVELOPMENT'),
(139, '9068', '31-08-24', '03:54', '9076', 'EMAIL MARKETING'),
(140, '1760', '31-08-24', '03:55', '9076', 'KEYWORD RESEARCH'),
(141, '5282', '31-08-24', '03:55', '9076', 'BULK SMS MARKETING'),
(142, '9457', '31-08-24', '03:55', '9076', 'MOBILE MARKETING'),
(143, '7207', '31-08-24', '03:55', '9076', 'WEBSITE ANALYTICS'),
(144, '5189', '31-08-24', '03:56', '9076', 'GROWTH HACKING'),
(145, '6813', '31-08-24', '03:56', '6730', 'C, C++, C#'),
(146, '8034', '31-08-24', '03:56', '6730', 'ASP.NET'),
(147, '7363', '31-08-24', '03:56', '6730', 'JAVA'),
(148, '7177', '31-08-24', '03:56', '6730', 'JAVA SCRIPT'),
(149, '4465', '31-08-24', '03:56', '6730', 'PHP'),
(150, '8885', '31-08-24', '03:56', '6730', 'PYTHON'),
(151, '8184', '31-08-24', '03:59', '4857', 'HTML'),
(152, '6851', '31-08-24', '03:59', '4857', 'CSS'),
(153, '5658', '31-08-24', '03:59', '4857', 'JAVA SCRIPT'),
(154, '4769', '31-08-24', '03:59', '4857', 'PHP'),
(155, '8064', '31-08-24', '03:59', '4857', 'PLUGIN DEVELOPMENT'),
(156, '9767', '31-08-24', '03:59', '4857', 'BACKEND DEVELOPMENT');

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

--
-- Table structure for table `table_of_content`
--

CREATE TABLE `table_of_content` (
  `id` int(10) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `category` text NOT NULL,
  `language` text NOT NULL,
  `point_to_learn` text NOT NULL,
  `image` text NOT NULL,
  `video_url` text NOT NULL,
  `video_thum_nail` text NOT NULL,
  `video_status` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `table_of_content`
--

INSERT INTO `table_of_content` (`id`, `code`, `date`, `time`, `category`, `language`, `point_to_learn`, `image`, `video_url`, `video_thum_nail`, `video_status`) VALUES
(4, '8379', '10-08-24', '04:58', 'Graphic Designing', 'English', 'Corel Draw', 'upload/png-clipart-coreldraw-computer-software-graphics-suite-others-miscellaneous-cdr.png', 'n8Y5RNX0OcU', 'upload/Motion-Graphics-vs-Animation-1.jpg', 'Active'),
(9, '4725', '22-08-24', '05:46', 'Web Development', 'React', 'cookies', 'upload/png-transparent-react-javascript-library-redux-user-interface-tesseract-logo-symmetry-nodejs.png', '', 'upload/', 'Deactive'),
(10, '9537', '24-08-24', '07:02', 'web development', 'HTML', 'Paragraph tag', 'upload/code-flat.png', '', 'upload/website-design-preview-107805.jpg', ''),
(11, '4484', '28-08-24', '02:56', 'web development', 'React', 'React HTML', 'upload/11470321.png', '', 'upload/1711707907php9olnui.jpeg', 'Active'),
(12, '6324', '28-08-24', '04:04', 'Graphic Designing', 'Photoshop', 'Photoshop', 'upload/aa7ieit2u.webp', '', 'upload/Graphic-banner.png', 'Active'),
(13, '9607', '31-08-24', '12:14', 'Web Development', 'React', 'React JSX', 'upload/png-transparent-react-javascript-library-redux-user-interface-tesseract-logo-symmetry-nodejs.png', '', 'upload/hdxxdt.jfif', 'Deactive'),
(14, '7327', '31-08-24', '12:21', 'App Development', 'PHP', 'DBMS', 'upload/app.svg', '', 'upload/2caf3e7f-1704-42e2-908f-3d089da3e3ac_The+Ultimate+Guide+to+Android+App+Development.avif', 'Active'),
(15, '9076', '31-08-24', '01:51', 'Digital Marketing', 'SEO', 'Google Ads', 'upload/juhtyhf.png', 'f9dk_sUpKuc', 'upload/1662817728493.jfif', 'Active'),
(16, '6730', '31-08-24', '02:30', 'Programming Language', 'Java Script', 'C++', 'upload/png-transparent-c-logo-the-c-programming-language-computer-icons-computer-programming-source-code-programming-miscellaneous-template-blue-thumbnail.png', '', 'upload/best-programming-languages-1128x635.jpg', 'Active'),
(17, '4857', '31-08-24', '02:48', 'Word Press Training', 'PHP', 'Backend Development', 'upload/png-transparent-wordpress-logo-wordpress-logo-website-blog-icon-wordpress-logo-free-blue-emblem-image-file-formats.png', 'K2rrHISctrI', 'upload/revolution-slider-website-banner-carousel-web-slider-carousel-design-c427.png', 'Active'),
(18, '6897', '14-09-24', '11:06', 'App Development', 'PHP', 'Demo upload', 'upload/theme37.png', '', 'upload/', '');

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

--
-- Table structure for table `test_imonial`
--

CREATE TABLE `test_imonial` (
  `id` int(10) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `image` text NOT NULL,
  `name` text NOT NULL,
  `feedback` text NOT NULL,
  `rating` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `test_imonial`
--

INSERT INTO `test_imonial` (`id`, `code`, `date`, `time`, `image`, `name`, `feedback`, `rating`) VALUES
(2, '7888', '16-08-24', '03:09', 'upload/i1.webp', 'Firdous Noor', 'Website', '5'),
(3, '4611', '16-08-24', '04:24', 'upload/ww.webp', 'Zishan Khan', 'Website', '3');

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

--
-- Table structure for table `upload_job`
--

CREATE TABLE `upload_job` (
  `id` int(3) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `title` text NOT NULL,
  `category_name` varchar(25) NOT NULL,
  `image` text NOT NULL,
  `search_tag` text NOT NULL,
  `job_description` text NOT NULL,
  `industry` text NOT NULL,
  `employment_type` text NOT NULL,
  `work_hours` text NOT NULL,
  `state` text NOT NULL,
  `city` text NOT NULL,
  `pincode` text NOT NULL,
  `landmark` text NOT NULL,
  `salary` text NOT NULL,
  `no_of_candidate` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `upload_job`
--

INSERT INTO `upload_job` (`id`, `code`, `date`, `time`, `title`, `category_name`, `image`, `search_tag`, `job_description`, `industry`, `employment_type`, `work_hours`, `state`, `city`, `pincode`, `landmark`, `salary`, `no_of_candidate`) VALUES
(35, '2707', '17-08-24', '01:02', 'Web Development', 'Web Development', 'upload/dum.webp', 'Web Development', 'Make Solution', 'Make Solution', 'Experienced', '6-8 Hours', 'Rajasthan', 'Kota', '324007', 'Kunhadi', '10,000', '15'),
(37, '2903', '17-08-24', '03:10', 'Graphic Designing', 'Graphic Designing', 'upload/hum.webp', 'Graphic Designing', 'Make Solution', 'Make Solution', ' Full-time Employment', '8-10 Hours', 'Rajasthan', 'Kota', '321005', 'Vigyan Nager', '15,000', '1'),
(39, '3728', '17-08-24', '06:15', 'Digital Marketing', 'Graphic Designing', 'upload/micro365.webp', 'Digital marketing', 'Make Solution', 'Make Solution', ' Independent contracting', '10-12 Hours', 'Rajasthan', 'Kota', '321005', 'Shrinath Puram', '18,000', '9'),
(40, '1951', '20-08-24', '11:00', 'App Development', 'Web Development', 'upload/worklap.webp', 'App Development', 'Make Solution', 'Make Solution', 'Seasonal', '8-10 Hours', 'Rajasthan', 'Kota', '4789654', 'Kunhadi', '12,000', '9'),
(45, '9744', '30-08-24', '03:55', '1', 'Web Development', 'upload/', '1', '1', '1', 'Part-time Employment', '1', '1', '1', '1', '1', '1', '1'),
(46, '7346', '30-08-24', '03:55', 'designing', 'Web Development', 'upload/', '4577', '44', '57', 'Part-time Employment', '', '', '', '', '', '', '');

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

--
-- Table structure for table `user_contact_enquiry`
--

CREATE TABLE `user_contact_enquiry` (
  `id` int(11) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `mobile_no` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_contact_enquiry`
--

INSERT INTO `user_contact_enquiry` (`id`, `code`, `date`, `time`, `mobile_no`) VALUES
(1, '9717', '13-09-24', '12:53', '467846'),
(2, '5993', '13-09-24', '12:59', '98697945'),
(3, '9329', '13-09-24', '01:33', '467846'),
(4, '4572', '13-09-24', '01:33', '1234567892'),
(5, '5349', '13-09-24', '01:33', '467846'),
(6, '8799', '13-09-24', '01:33', '1236547896'),
(7, '3381', '13-09-24', '01:35', '1236547896'),
(8, '8659', '13-09-24', '01:36', '467846'),
(9, '6579', '13-09-24', '01:36', '98697945'),
(10, '5917', '13-09-24', '03:55', '7479292');

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

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

CREATE TABLE `video` (
  `id` int(11) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `category` text NOT NULL,
  `video_url` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `video` (`id`, `code`, `date`, `time`, `category`, `video_url`) VALUES
(1, '[value-2]', '[value-3]', '[value-4]', 'Vivo', 'n8Y5RNX0OcU'),
(3, '4715', '12-08-24', '02:25', 'Web Development', 'K2rrHISctrI'),
(4, '5330', '13-09-24', '06:48', 'Web Development', 'f9dk_sUpKuc'),
(5, '4563', '13-09-24', '06:49', 'Digital marketing', 'n8Y5RNX0OcU');

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

--
-- Table structure for table `video_schema`
--

CREATE TABLE `video_schema` (
  `id` int(10) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `name` text NOT NULL,
  `video_description` text NOT NULL,
  `upload_date` text NOT NULL,
  `minutes` text NOT NULL,
  `seconds` text NOT NULL,
  `thumnail_url` text NOT NULL,
  `contact_url` text NOT NULL,
  `action_url` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `video_schema`
--

INSERT INTO `video_schema` (`id`, `code`, `date`, `time`, `name`, `video_description`, `upload_date`, `minutes`, `seconds`, `thumnail_url`, `contact_url`, `action_url`) VALUES
(1, '3161', '16-08-24', '02:22', 'Zishan Khan', 'eergesehg', 'ghreshhtrh', 'ersht', 'tht5r6j', 'dh56jj', '1234567895', 'k76r8o79l'),
(5, '7176', '20-08-24', '05:44', 'Khushi Sharma', 'a well-optimized description can boost your video’s ', '20/08/2024', '02:00 min', '00:39 sec', 'https://www.flipkart.com/', '1234567895', 'https://www.flipkart.com/');

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

--
-- Table structure for table `working_time`
--

CREATE TABLE `working_time` (
  `id` int(10) NOT NULL,
  `code` text NOT NULL,
  `date` text NOT NULL,
  `time` text NOT NULL,
  `working_type` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `working_time`
--

INSERT INTO `working_time` (`id`, `code`, `date`, `time`, `working_type`) VALUES
(1, '8497', '17-08-24', '01:47', 'Part-time Employment'),
(2, '6748', '17-08-24', '01:47', ' Full-time Employment'),
(3, '3589', '17-08-24', '01:47', 'Temporary Employment'),
(4, '1978', '17-08-24', '01:48', 'Contract Employment'),
(5, '4120', '17-08-24', '01:48', 'Casual Employment'),
(6, '9871', '17-08-24', '01:48', 'Seasonal'),
(7, '1717', '17-08-24', '01:48', ' Apprenticeship'),
(8, '8639', '17-08-24', '01:48', ' Internship'),
(9, '5202', '17-08-24', '01:49', ' Independent contracting'),
(11, '9339', '17-08-24', '01:54', 'Commission-based Employment');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `apply_job`
--
ALTER TABLE `apply_job`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `article_schema`
--
ALTER TABLE `article_schema`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `batches`
--
ALTER TABLE `batches`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `blog_category`
--
ALTER TABLE `blog_category`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `blog_description`
--
ALTER TABLE `blog_description`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `blog_image`
--
ALTER TABLE `blog_image`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `blog_post`
--
ALTER TABLE `blog_post`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `blog_video`
--
ALTER TABLE `blog_video`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `book_visit`
--
ALTER TABLE `book_visit`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `call_back`
--
ALTER TABLE `call_back`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `contact_us`
--
ALTER TABLE `contact_us`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `course_teacher`
--
ALTER TABLE `course_teacher`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `data_description`
--
ALTER TABLE `data_description`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `feedback`
--
ALTER TABLE `feedback`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `how_to_schema`
--
ALTER TABLE `how_to_schema`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `images`
--
ALTER TABLE `images`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `job_benefits`
--
ALTER TABLE `job_benefits`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `job_category`
--
ALTER TABLE `job_category`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `job_posting_schema`
--
ALTER TABLE `job_posting_schema`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `languages`
--
ALTER TABLE `languages`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `main_category`
--
ALTER TABLE `main_category`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `meta_tag`
--
ALTER TABLE `meta_tag`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `person_schema`
--
ALTER TABLE `person_schema`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `question`
--
ALTER TABLE `question`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `search_tag`
--
ALTER TABLE `search_tag`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=157;

--
-- AUTO_INCREMENT for table `table_of_content`
--
ALTER TABLE `table_of_content`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `test_imonial`
--
ALTER TABLE `test_imonial`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `upload_job`
--
ALTER TABLE `upload_job`
  MODIFY `id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT for table `user_contact_enquiry`
--
ALTER TABLE `user_contact_enquiry`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

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

--
-- AUTO_INCREMENT for table `video_schema`
--
ALTER TABLE `video_schema`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `working_time`
--
ALTER TABLE `working_time`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
COMMIT;

