-- phpMyAdmin SQL Dump
-- version 4.9.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Feb 17, 2024 at 06:05 AM
-- Server version: 10.4.8-MariaDB
-- PHP Version: 7.1.32

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


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

--
-- Database: `highmarks`
--

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

--
-- Table structure for table `about_qa`
--

CREATE TABLE `about_qa` (
  `id` int(11) NOT NULL,
  `feature_1` text DEFAULT NULL,
  `answer_1` text DEFAULT NULL,
  `feature_2` text DEFAULT NULL,
  `answer_2` text DEFAULT NULL,
  `feature_3` text DEFAULT NULL,
  `answer_3` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `about_qa`
--

INSERT INTO `about_qa` (`id`, `feature_1`, `answer_1`, `feature_2`, `answer_2`, `feature_3`, `answer_3`) VALUES
(1, 'test 1', NULL, 'test 2', NULL, 'test 3', NULL);

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

--
-- Table structure for table `about_section_3`
--

CREATE TABLE `about_section_3` (
  `id` int(11) NOT NULL,
  `intro` text DEFAULT NULL,
  `intro_image` varchar(255) DEFAULT NULL,
  `status` enum('0','1') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `about_section_3`
--

INSERT INTO `about_section_3` (`id`, `intro`, `intro_image`, `status`) VALUES
(1, '<b>DCM CLASSES</b> is one of the best <b>Commerce & Management Coaching Classes</b> located in Jaipur, Rajasthan (India)<br> R.S.Shekhawat Sir having 15 year exp. of teaching Commerce & Management subjects. We committed & Dedicated to quality education. Best results have been given consistently over the years in <b>B.com, BBA, M.Com & MBA</b>', 'intro.jpg', NULL);

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

--
-- Table structure for table `about_section_4`
--

CREATE TABLE `about_section_4` (
  `id` int(11) NOT NULL,
  `intro` text DEFAULT NULL,
  `intro_image` varchar(255) DEFAULT NULL,
  `status` enum('0','1') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `about_section_4`
--

INSERT INTO `about_section_4` (`id`, `intro`, `intro_image`, `status`) VALUES
(1, '<b>DCM CLASSES</b> is one of the best <b>Commerce & Management Coaching Classes</b> located in Jaipur, Rajasthan (India)<br> R.S.Shekhawat Sir having 15 year exp. of teaching Commerce & Management subjects. We committed & Dedicated to quality education. Best results have been given consistently over the years in <b>B.com, BBA, M.Com & MBA</b>', 'intro.jpg', NULL);

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

--
-- Table structure for table `features`
--

CREATE TABLE `features` (
  `id` int(11) NOT NULL,
  `feature_1` text DEFAULT NULL,
  `feature_2` text DEFAULT NULL,
  `feature_3` text DEFAULT NULL,
  `feature_4` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `features`
--

INSERT INTO `features` (`id`, `feature_1`, `feature_2`, `feature_3`, `feature_4`) VALUES
(1, 'test 1', 'test 2', 'test 3', 'test 4');

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

--
-- Table structure for table `features_2`
--

CREATE TABLE `features_2` (
  `id` int(11) NOT NULL,
  `feature_1` text DEFAULT NULL,
  `feature_2` text DEFAULT NULL,
  `feature_3` text DEFAULT NULL,
  `feature_4` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `features_2`
--

INSERT INTO `features_2` (`id`, `feature_1`, `feature_2`, `feature_3`, `feature_4`) VALUES
(1, 'test 1', 'test 2', 'test 3', 'test 4');

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

--
-- Table structure for table `offline_courses`
--

CREATE TABLE `offline_courses` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `section1_title` text DEFAULT NULL,
  `section1_content` text DEFAULT NULL,
  `section2_title` text DEFAULT NULL,
  `section2_content` text DEFAULT NULL,
  `status` enum('0','1') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `offline_courses`
--

INSERT INTO `offline_courses` (`id`, `title`, `image`, `description`, `section1_title`, `section1_content`, `section2_title`, `section2_content`, `status`) VALUES
(19, 'B.Com', '20200921_162143.jpg', '<li>Corporate Accounting</li> <li>Business Statistics</li> <li>Income Tax</li> <li>Cost Accounting</li> <li>Financial Management</li><li>Management Accounting</li><li>Advance Accounting</li><li>Business Budgeting</li>', NULL, NULL, NULL, NULL, NULL),
(21, 'BBA', '20200921_162251.jpg', '<li>Financial Accounting</li><li>Economics</li><li>Business Law</li><li>Business Management</li><li>Business Finance</li><li>Quantitative Techniques</li><li>Cost & Management Accounting</li>  ', NULL, NULL, NULL, NULL, NULL);

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

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

CREATE TABLE `slider` (
  `id` int(11) NOT NULL,
  `slider1_image` varchar(255) DEFAULT NULL,
  `slider1_text` varchar(255) DEFAULT NULL,
  `slider2_image` varchar(255) DEFAULT NULL,
  `slider2_text` varchar(255) DEFAULT NULL,
  `slider3_image` varchar(255) DEFAULT NULL,
  `slider3_text` varchar(255) DEFAULT NULL,
  `status` enum('0','1') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `slider` (`id`, `slider1_image`, `slider1_text`, `slider2_image`, `slider2_text`, `slider3_image`, `slider3_text`, `status`) VALUES
(1, 'slider1.jpg', '', 'slider2.jpg', '', 'slider3.jpeg', '', NULL);

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

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

CREATE TABLE `testimonials` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `rating` int(10) DEFAULT NULL,
  `status` enum('0','1') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `testimonials` (`id`, `name`, `image`, `comment`, `rating`, `status`) VALUES
(1, 'Pragati Singh', 'IMG_4535a.jpg', 'Best Coaching for B.Com', 5, '1'),
(15, 'Chandra Shekhar', 'IMG_4704.JPG', 'Best institute for BBA', NULL, NULL);

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

--
-- Indexes for table `slider`
--
ALTER TABLE `slider`
  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_qa`
--
ALTER TABLE `about_qa`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

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

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

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

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

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

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

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