-- phpMyAdmin SQL Dump
-- version 4.9.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Apr 24, 2022 at 01:31 PM
-- Server version: 10.4.10-MariaDB
-- PHP Version: 7.4.0

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: `mmit_db`
--

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

--
-- Table structure for table `tbl_acal`
--

DROP TABLE IF EXISTS `tbl_acal`;
CREATE TABLE IF NOT EXISTS `tbl_acal` (
  `acal_id` int(11) NOT NULL AUTO_INCREMENT,
  `acal_file` varchar(255) NOT NULL,
  `added_on` datetime NOT NULL,
  `session` varchar(100) NOT NULL,
  PRIMARY KEY (`acal_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_acal`
--

INSERT INTO `tbl_acal` (`acal_id`, `acal_file`, `added_on`, `session`) VALUES
(2, 'pdf/20220423053406ACADEMIC CALENDAR Even Sem 2021-22.pdf', '2022-04-23 05:34:06', 'Academic Calender Even Sem 2021-22');

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

--
-- Table structure for table `tbl_accreditation`
--

DROP TABLE IF EXISTS `tbl_accreditation`;
CREATE TABLE IF NOT EXISTS `tbl_accreditation` (
  `ac_id` int(11) NOT NULL AUTO_INCREMENT,
  `file` varchar(200) NOT NULL,
  `session` varchar(30) NOT NULL,
  `type` varchar(20) NOT NULL,
  `date` varchar(30) NOT NULL,
  `added_on` varchar(30) NOT NULL,
  PRIMARY KEY (`ac_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_admin`
--

DROP TABLE IF EXISTS `tbl_admin`;
CREATE TABLE IF NOT EXISTS `tbl_admin` (
  `adm_id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(30) NOT NULL,
  `password` varchar(30) NOT NULL,
  PRIMARY KEY (`adm_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_admin`
--

INSERT INTO `tbl_admin` (`adm_id`, `email`, `password`) VALUES
(1, 'admin@gmail.com', 'admin@123'),
(2, 'rohit@gmail.com', 'rohit@poly');

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

--
-- Table structure for table `tbl_aicte`
--

DROP TABLE IF EXISTS `tbl_aicte`;
CREATE TABLE IF NOT EXISTS `tbl_aicte` (
  `doc_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `file` varchar(60) DEFAULT NULL,
  `date` varchar(12) DEFAULT NULL,
  PRIMARY KEY (`doc_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_aicte`
--

INSERT INTO `tbl_aicte` (`doc_id`, `title`, `file`, `date`) VALUES
(1, '2021-22 EOA Report', 'aicte-290mmit.pdf', '2022-04-19'),
(3, '2017-18 LOA mmit shamli	', 'aicte-352pdf2.pdf', '2022-04-19'),
(4, '2018-19 EOA Report 1', 'aicte-016pdf3.pdf', '2022-04-19'),
(5, '2018-19 EOA Report 2 – Corrigendum', 'aicte-348pdf4.pdf', '2022-04-19'),
(6, '2018-19 GO Paper and Pulp Technology', 'aicte-643pdf5.pdf', '2022-04-19'),
(7, '2018-19 GO Seat Intake, Page No. 09', 'aicte-202pdf6.PDF', '2022-04-19'),
(8, '2019-20 EOA Report. 06', 'aicte-444pdf7.pdf', '2022-04-19'),
(9, '2020-21 EOA Report', 'aicte-456pdf8.PDF', '2022-04-19'),
(10, '2019-20 GO Seat Intake, Page No', 'aicte-344pdf9.pdf', '2022-04-19'),
(11, '2020-21 GO Seat Intake', 'aicte-626pdf10.pdf', '2022-04-19'),
(12, '2021-22 EOA Report', 'aicte-769pdf11.PDF', '2022-04-19');

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

--
-- Table structure for table `tbl_alumni`
--

DROP TABLE IF EXISTS `tbl_alumni`;
CREATE TABLE IF NOT EXISTS `tbl_alumni` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `name` varchar(60) DEFAULT NULL,
  `enrollment` varchar(30) DEFAULT NULL,
  `fname` varchar(60) DEFAULT NULL,
  `branch` varchar(60) DEFAULT NULL,
  `year` varchar(30) DEFAULT NULL,
  `mob` bigint(10) DEFAULT NULL,
  `email` varchar(30) DEFAULT NULL,
  `marks` int(30) DEFAULT NULL,
  `company` varchar(60) DEFAULT NULL,
  `designation` varchar(60) DEFAULT NULL,
  `feedback` varchar(200) DEFAULT NULL,
  `about` varchar(200) DEFAULT NULL,
  `pic` varchar(60) DEFAULT NULL,
  `cv` varchar(90) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `status` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_alumni`
--

INSERT INTO `tbl_alumni` (`id`, `name`, `enrollment`, `fname`, `branch`, `year`, `mob`, `email`, `marks`, `company`, `designation`, `feedback`, `about`, `pic`, `cv`, `date`, `status`) VALUES
(1, 'shiva goyal', '543', 'shivam goyal', 'ME', '2022', 9087654321, 'shiva@gmail.com', 40, 'SPI', 'Software Engineer', 'great campus', 'I am shiva', 'alumni290409sp1.jpg', 'alumni_cv471561mmit.pdf', '2022-04-19', 'Y');

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

--
-- Table structure for table `tbl_contact`
--

DROP TABLE IF EXISTS `tbl_contact`;
CREATE TABLE IF NOT EXISTS `tbl_contact` (
  `con_id` int(11) NOT NULL AUTO_INCREMENT,
  `fname` varchar(100) NOT NULL,
  `lname` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `mobile` varchar(10) NOT NULL,
  `message` varchar(200) NOT NULL,
  `date` varchar(30) NOT NULL,
  PRIMARY KEY (`con_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_contact`
--

INSERT INTO `tbl_contact` (`con_id`, `fname`, `lname`, `email`, `mobile`, `message`, `date`) VALUES
(1, 'shiva', 'goyal', 'shiva@gmail.com', '2321545242', 'msg', '2022-04-19 18:07:41');

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

--
-- Table structure for table `tbl_department`
--

DROP TABLE IF EXISTS `tbl_department`;
CREATE TABLE IF NOT EXISTS `tbl_department` (
  `dept_id` int(11) NOT NULL AUTO_INCREMENT,
  `dept_name` varchar(50) NOT NULL,
  `date` varchar(10) NOT NULL,
  PRIMARY KEY (`dept_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_department`
--

INSERT INTO `tbl_department` (`dept_id`, `dept_name`, `date`) VALUES
(1, 'Mechanical Engineering (Production)', '2022-03-22'),
(2, 'Food Technology', '2022-03-22'),
(3, 'Paper & Pulp Technology', '2022-03-22'),
(5, 'N/A', '2022-03-22');

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

--
-- Table structure for table `tbl_gallery`
--

DROP TABLE IF EXISTS `tbl_gallery`;
CREATE TABLE IF NOT EXISTS `tbl_gallery` (
  `gal_id` int(11) NOT NULL AUTO_INCREMENT,
  `text1` varchar(100) NOT NULL,
  `text2` varchar(100) NOT NULL,
  `pic` varchar(100) NOT NULL,
  `type` varchar(60) NOT NULL,
  `date` varchar(10) NOT NULL,
  PRIMARY KEY (`gal_id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_gallery`
--

INSERT INTO `tbl_gallery` (`gal_id`, `text1`, `text2`, `pic`, `type`, `date`) VALUES
(1, 'gal 1', 'gal 1', 'gallery1160img1.jpg', 'gallery', '2022-04-19'),
(2, 'gal 2', 'gal 2', 'gallery9260img2.jpg', 'gallery', '2022-04-19'),
(3, 'gal 3', 'gal 3', 'industrial2720img3.jpg', 'industrial', '2022-04-19'),
(4, 'gal 4', 'gal 4', 'sports6060img4.jpg', 'sports', '2022-04-19'),
(5, 'gal 5', 'gal 5', 'sports6372img6.jpg', 'sports', '2022-04-19'),
(6, 'gal 6', 'gal 6', 'sports4976img7.jpg', 'sports', '2022-04-19'),
(7, 'gal 7', 'gal 7', 'sports764img9.jpg', 'sports', '2022-04-19'),
(8, 'gal 8', 'gal 8', 'seminar3350img5.jpg', 'seminar', '2022-04-19'),
(9, 'gal 9 ', 'gal 9', 'seminar5186img8.jpg', 'seminar', '2022-04-19'),
(10, 'gal 10', 'gal 10', 'survey4995img10.jpg', 'survey', '2022-04-19'),
(11, 'gal 11 ', 'gal 11', 'annual1749img11.jpg', 'annual', '2022-04-19'),
(12, 'gal 1', 'gal 1', 'industrial529img3.jpg', 'industrial', '2022-04-19');

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

--
-- Table structure for table `tbl_grievance`
--

DROP TABLE IF EXISTS `tbl_grievance`;
CREATE TABLE IF NOT EXISTS `tbl_grievance` (
  `g_id` int(11) NOT NULL AUTO_INCREMENT,
  `stu_name` varchar(60) NOT NULL,
  `enroll_no` varchar(60) NOT NULL,
  `mobile` varchar(10) NOT NULL,
  `email` varchar(60) NOT NULL,
  `subject` varchar(60) NOT NULL,
  `msg` varchar(200) NOT NULL,
  `status` varchar(60) NOT NULL,
  `date` varchar(30) NOT NULL,
  PRIMARY KEY (`g_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_grievance`
--

INSERT INTO `tbl_grievance` (`g_id`, `stu_name`, `enroll_no`, `mobile`, `email`, `subject`, `msg`, `status`, `date`) VALUES
(1, 'shiva ', '4454', '4524522452', 'shiva@gmail.com', 'subject ', 'message', 'N', '2022-04-19');

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

--
-- Table structure for table `tbl_mou`
--

DROP TABLE IF EXISTS `tbl_mou`;
CREATE TABLE IF NOT EXISTS `tbl_mou` (
  `doc_id` int(11) NOT NULL AUTO_INCREMENT,
  `company` varchar(200) NOT NULL,
  `title` varchar(200) DEFAULT NULL,
  `file` varchar(60) DEFAULT NULL,
  `date` varchar(12) DEFAULT NULL,
  PRIMARY KEY (`doc_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_mou`
--

INSERT INTO `tbl_mou` (`doc_id`, `company`, `title`, `file`, `date`) VALUES
(2, 'Softpro India Computer Technology (p) Ltd.', 'MOU between Softpro India Computer Technology (p) Ltd. and Department of Technical Education Govt. of India	', 'mou-630MOU DTE & SPI_compressed.pdf', '2022-04-24'),
(3, 'Engineers Kudos Infra Projects (p) Ltd. Ghaziabad', 'MOU between Mahamaya Polytechnic of Information Technology, Shamli and Engineers Kudos Infra Projects (p) Ltd. Ghaziabad', 'mou-766MOU EKIPL - MMIT_compressed.pdf', '2022-04-24'),
(4, 'Medha Learning Foundation, Lucknow', 'MOU between Mahamaya Polytechnic of Information Technology, Shamli and Medha Learning Foundation, Lucknow', 'mou-843MOU MEDHA MMIT.pdf', '2022-04-24'),
(5, 'Prapti Enterprises, Shamli', 'MOU between Mahamaya Polytechnic of Information Technology, Shamli and Prapti Enterprises, Shamli', 'mou-445MOU Prapti enterprises_compressed.pdf', '2022-04-24'),
(6, 'Prime Servies, Nashik', 'MOU between Mahamaya Polytechnic of Information Technology and Prime Servies, Nashik', 'mou-407MOU Prime Service.pdf', '2022-04-24'),
(7, 'Softpro India Computer Technology (p) Ltd.', 'MOU between Softpro India Computer Technology (p) Ltd. and Department of Technical Education Govt. of India', 'mou-837MOU SoftPro India_compressed.pdf', '2022-04-24');

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

--
-- Table structure for table `tbl_notice`
--

DROP TABLE IF EXISTS `tbl_notice`;
CREATE TABLE IF NOT EXISTS `tbl_notice` (
  `file_id` int(11) NOT NULL AUTO_INCREMENT,
  `notice` varchar(200) NOT NULL,
  `file_name` varchar(200) NOT NULL,
  `date` varchar(20) NOT NULL,
  PRIMARY KEY (`file_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_notice`
--

INSERT INTO `tbl_notice` (`file_id`, `notice`, `file_name`, `date`) VALUES
(4, 'JEECUP Information Bulletin-2022', '23-04-2022-32-JEECUP Information Bulletin-2022.pdf', '2022-04-23 11:07:11'),
(3, 'AICTE Anti-Ragging Notification', '23-04-2022-50-AICTE Anti-Ragging Notification.pdf', '2022-04-23 11:05:35');

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

--
-- Table structure for table `tbl_placement`
--

DROP TABLE IF EXISTS `tbl_placement`;
CREATE TABLE IF NOT EXISTS `tbl_placement` (
  `place_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `file` varchar(200) NOT NULL,
  `date` varchar(40) NOT NULL,
  PRIMARY KEY (`place_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_placement`
--

INSERT INTO `tbl_placement` (`place_id`, `title`, `file`, `date`) VALUES
(1, 'Placement 2020-2021', 'placement-139Placement Info, 2020-21.pdf', '2022-04-24'),
(2, 'Placement 2021-2022', 'placement-034Placement Info, 2021-22.pdf', '2022-04-24');

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

--
-- Table structure for table `tbl_rag`
--

DROP TABLE IF EXISTS `tbl_rag`;
CREATE TABLE IF NOT EXISTS `tbl_rag` (
  `rag_id` int(11) NOT NULL AUTO_INCREMENT,
  `stu_name` varchar(60) NOT NULL,
  `enroll_no` varchar(60) NOT NULL,
  `gen` varchar(10) NOT NULL,
  `parent_name` varchar(60) NOT NULL,
  `stu_email` varchar(60) NOT NULL,
  `stu_mob` varchar(10) NOT NULL,
  `parent_mob` varchar(10) NOT NULL,
  `course` varchar(60) NOT NULL,
  `year` varchar(60) NOT NULL,
  `address` varchar(200) NOT NULL,
  `complaint` varchar(500) NOT NULL,
  `status` varchar(20) NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`rag_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_rag`
--

INSERT INTO `tbl_rag` (`rag_id`, `stu_name`, `enroll_no`, `gen`, `parent_name`, `stu_email`, `stu_mob`, `parent_mob`, `course`, `year`, `address`, `complaint`, `status`, `date`) VALUES
(2, 'shiva goyal', '1243', 'male', 'shivam goyal', 'shiva@gmail.com', '1234567890', '1234567890', 'Mechenical Engineering', '2', 'LKO', 'Ragging', 'N', '2022-04-19');

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

--
-- Table structure for table `tbl_result`
--

DROP TABLE IF EXISTS `tbl_result`;
CREATE TABLE IF NOT EXISTS `tbl_result` (
  `res_id` int(11) NOT NULL AUTO_INCREMENT,
  `link` varchar(200) NOT NULL,
  `date` varchar(30) NOT NULL,
  PRIMARY KEY (`res_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_result`
--

INSERT INTO `tbl_result` (`res_id`, `link`, `date`) VALUES
(1, 'http://softproindia.in/', '2022-04-19 13:39:11'),
(2, 'http://result.bteupexam.in/even/main/', '2022-04-23 11:13:35');

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

--
-- Table structure for table `tbl_rti`
--

DROP TABLE IF EXISTS `tbl_rti`;
CREATE TABLE IF NOT EXISTS `tbl_rti` (
  `doc_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(60) DEFAULT NULL,
  `file` varchar(60) DEFAULT NULL,
  `date` varchar(12) DEFAULT NULL,
  PRIMARY KEY (`doc_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_rti`
--

INSERT INTO `tbl_rti` (`doc_id`, `title`, `file`, `date`) VALUES
(1, 'rti 1', 'rti-576rti1.pdf', '2022-04-19'),
(2, 'rti 2', 'rti-653rti2.pdf', '2022-04-19'),
(3, 'rti 3', 'rti-024rti3.pdf', '2022-04-19'),
(4, 'rti 4', 'rti-552rti4.pdf', '2022-04-19');

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

--
-- Table structure for table `tbl_slider`
--

DROP TABLE IF EXISTS `tbl_slider`;
CREATE TABLE IF NOT EXISTS `tbl_slider` (
  `slider_id` int(11) NOT NULL AUTO_INCREMENT,
  `text1` varchar(100) CHARACTER SET utf8 NOT NULL,
  `text2` varchar(100) CHARACTER SET utf8 NOT NULL,
  `pic` varchar(100) NOT NULL,
  `date` varchar(10) NOT NULL,
  PRIMARY KEY (`slider_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_slider`
--

INSERT INTO `tbl_slider` (`slider_id`, `text1`, `text2`, `pic`, `date`) VALUES
(5, 'महामाया पॉलिटेक्निक ऑफ इन्फोर्मेशन टेक्नोलोजी, शामली', 'We had such a great time in Education', 'IMG_20181016_124043.jpg', '2022-04-24'),
(2, 'महामाया पॉलिटेक्निक ऑफ इन्फोर्मेशन टेक्नोलोजी, शामली', 'We had such a great time in Education', 'IMG_20181016_124653.jpg', '2022-04-19'),
(3, 'महामाया पॉलिटेक्निक ऑफ इन्फोर्मेशन टेक्नोलोजी, शामली', 'We had such a great time in Education', 'IMG_20190212_162219.jpg', '2022-04-19'),
(4, 'महामाया पॉलिटेक्निक ऑफ इन्फोर्मेशन टेक्नोलोजी, शामली', 'We had such a great time in Education', 'IMG-20180707-WA0000.jpg', '2022-04-19');

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

--
-- Table structure for table `tbl_teacher`
--

DROP TABLE IF EXISTS `tbl_teacher`;
CREATE TABLE IF NOT EXISTS `tbl_teacher` (
  `tech_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `dob` varchar(10) NOT NULL,
  `fname` varchar(100) NOT NULL,
  `gender` varchar(6) NOT NULL,
  `mobile` varchar(10) NOT NULL,
  `email` varchar(80) NOT NULL,
  `dept_id` int(11) NOT NULL,
  `designation` varchar(50) NOT NULL,
  `qualification` varchar(200) NOT NULL,
  `address` varchar(200) NOT NULL,
  `pic` varchar(100) NOT NULL,
  `dor` varchar(20) NOT NULL,
  PRIMARY KEY (`tech_id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_teacher`
--

INSERT INTO `tbl_teacher` (`tech_id`, `name`, `dob`, `fname`, `gender`, `mobile`, `email`, `dept_id`, `designation`, `qualification`, `address`, `pic`, `dor`) VALUES
(1, ' Mr. NAVEEN KUMAR', '2022-04-19', 'N/A', 'Male', '0000000000', 'xxxx@gmail.com', 5, 'HOD ELECTRONICS ENGG', 'M.Tech.', 'N/A', 'principal.png', '2022-04-19 12:46:49'),
(2, 'MR. LOKESH KUMAR', '2022-04-19', 'N/A', 'Male', '0000000000', 'xxxx@gmail.com', 5, 'LECTURER : CHEMISTRY', 'N/A', 'N/A', 'fac2.png', '2022-04-19 12:49:14'),
(3, '   MR. KAPIL KUMAR SINGH', '2022-04-19', 'N/A', 'Male', '0000000000', 'xxxx@gmail.com', 5, 'LECTURER : MECHANICAL ENGG.', 'N/A', 'N/A', 'fac3.png', '2022-04-19 12:50:28'),
(4, ' MR. JASHVEER SINGH', '2022-04-19', 'N/A', 'Male', '0000000000', 'xxxx@gmail.com', 5, 'LECTURER : MECHANICAL ENGG.', 'N/A', 'N/A', 'fac4.png', '2022-04-19 12:50:28'),
(5, '  Mr. M NASIM ANSARI', '2022-04-19', 'N/A', 'Male', '0000000000', 'xxxx@gmail.com', 5, 'LECTURER : MECHANICAL ENGG.', 'N/A', 'N/A', 'manish.png', '2022-04-19 12:53:47'),
(6, '  Mr. SUBHASH CHAND', '2022-04-19', 'N/A', 'Male', '0000000000', 'xxxx@gmail.com', 5, 'N/A', 'INSTRUCTOR : Workshop', 'N/A', 'fac6.png', '2022-04-19 12:56:23'),
(7, 'Mr. LALIT KUMAR', '2022-04-23', 'N/A', 'Male', '0000000000', 'lalittyagi2321@gmail.com', 5, 'Workshop Instructor', 'B.Tech (Mechanical Engg.)', 'N/A', 'lalit_kumar.png', '2022-04-23 09:58:23'),
(8, 'Mr. PAVAN KUMAR', '2022-04-23', 'N/A', 'Male', '0000000000', 'kumar.pavan101989@gmail.com', 5, 'Guest Faculty', 'B.Tech (Mechanical Engg.)', 'N/A', 'pavan.png', '2022-04-23 09:59:56'),
(9, 'Km. SHALU', '2022-04-23', 'N/A', 'Female', '0000000000', 'xxxx@gmail.com', 5, 'Guest Faculty', 'M.Sc (Mathematics)', 'N/A', 'shalu.png', '2022-04-23 10:01:40'),
(10, 'Ms. SWAPNIL SHARMA', '2022-04-23', 'N/A', 'Female', '0000000000', 'xxxx@gmail.com', 5, 'Guest Faculty', 'B.Tech (Chemical Engg.)', 'N/A', 'swapline.png', '2022-04-23 10:02:54'),
(11, 'Mr. Gourav Kumar', '2022-04-23', 'N/A', 'Male', '0000000000', 'Gouravkr10ipec@gmail.com', 5, 'Guest Faculty', 'B.Tech (Mechanical Engg.)', 'N/A', 'gaurav.png', '2022-04-23 11:02:46');

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

--
-- Table structure for table `tbl_video`
--

DROP TABLE IF EXISTS `tbl_video`;
CREATE TABLE IF NOT EXISTS `tbl_video` (
  `v_id` int(30) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `branch` varchar(60) NOT NULL,
  `year` varchar(60) NOT NULL,
  `subject` varchar(200) NOT NULL,
  `date` varchar(30) NOT NULL,
  `url` varchar(200) NOT NULL,
  PRIMARY KEY (`v_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_video`
--

INSERT INTO `tbl_video` (`v_id`, `title`, `branch`, `year`, `subject`, `date`, `url`) VALUES
(1, 'demo topic ', '1', '1st', 'demo subject', '2022-04-19 12:33:54', 'https://youtu.be/qlXZlOw7C4c');

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

--
-- Table structure for table `time_table`
--

DROP TABLE IF EXISTS `time_table`;
CREATE TABLE IF NOT EXISTS `time_table` (
  `t_id` int(11) NOT NULL AUTO_INCREMENT,
  `time_table_file` varchar(255) NOT NULL,
  `type` varchar(50) NOT NULL,
  `date` varchar(30) NOT NULL,
  `added_on` datetime NOT NULL,
  `session` varchar(100) NOT NULL,
  PRIMARY KEY (`t_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `time_table`
--

INSERT INTO `time_table` (`t_id`, `time_table_file`, `type`, `date`, `added_on`, `session`) VALUES
(3, 'pdf/20220423053949NH RH Holiday Shamli 2022-converted.pdf', 'holiday', '2022-04-23', '2022-04-23 05:39:49', 'NH RH Holiday Shamli 2022');
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 */;