| Server IP : 68.178.161.82 / Your IP : 216.73.216.141 Web Server : Microsoft-IIS/10.0 System : Windows NT 82-161-178-68 10.0 build 20348 (Windows Server 2016) AMD64 User : IWAM_plesk(default) ( 0) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Inetpub/vhosts/lpsc.co.in/gomtinagar.lpsc.co.in/sqlfile/ |
Upload File : |
-- phpMyAdmin SQL Dump -- version 5.0.2 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jul 21, 2020 at 09:16 AM -- Server version: 10.4.11-MariaDB -- PHP Version: 7.4.6 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; 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: `lpsgomtinagar` -- -- -------------------------------------------------------- -- -- Table structure for table `about` -- CREATE TABLE `about` ( `id` int(11) NOT NULL, `about` varchar(2000) NOT NULL, `about1` varchar(1000) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `about` -- INSERT INTO `about` (`id`, `about`, `about1`) VALUES (1, 'Lucknow Public Schools & Colleges is one of the premier institutions in the state of Uttar Pradesh. It hails students from all over the world irrespective of their backgrounds, countries, states and educational systems. Talent is nurtured and acuminated here. Formative years are given attention, and a strong foundation is built by vigilant teaching fraternity. It’s a wonderful community where teachers and learners co-exist with the aim of rendering finest citizens to the country. Learners are harnessed with strong English communicative skills, mathematical exactitude, scientific temper, musical, & artistic expressions, aesthetics, open mindedness, competitiveness and holistic development for world class grooming. ', 'Its track record has been fairly unique. Currently, its 12 campuses are teaching 28000 learners from Pre Primary to Degree level. Hundred percent knowledge sharing with hundred percent result is its prime concern.'); -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE `admin` ( `id` int(11) NOT NULL, `UserName` varchar(100) NOT NULL, `Password` varchar(100) NOT NULL, `updationDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `admin` -- INSERT INTO `admin` (`id`, `UserName`, `Password`, `updationDate`) VALUES (1, 'admin', '8aa1ef9afbb2e0799af4c96103a078e1', '2020-05-16 18:02:53'); -- -------------------------------------------------------- -- -- Table structure for table `affiliation` -- CREATE TABLE `affiliation` ( `id` int(200) NOT NULL, `status` varchar(100) NOT NULL, `number` varchar(200) NOT NULL, `board` int(100) NOT NULL, `upto` varchar(300) NOT NULL, `society` varchar(300) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `affiliation` -- INSERT INTO `affiliation` (`id`, `status`, `number`, `board`, `upto`, `society`) VALUES (2, 'Provisional', '2130879', 2007, '2017', 'LUCKNOW PUBLIC EDUCATIONAL SOCIETY A BLOCK RAJAJIPURAM LUCKNOW'); -- -------------------------------------------------------- -- -- Table structure for table `blog` -- CREATE TABLE `blog` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(100) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `cafe` -- CREATE TABLE `cafe` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(11) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `calender` -- CREATE TABLE `calender` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(11) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `cbsedata` -- CREATE TABLE `cbsedata` ( `id` int(11) NOT NULL, `year` int(11) NOT NULL, `totalappeared` int(11) NOT NULL, `ninty` int(11) NOT NULL, `eight` int(11) NOT NULL, `per` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `digitaladmin` -- CREATE TABLE `digitaladmin` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(11) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `dignity` -- CREATE TABLE `dignity` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(100) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `dignity` -- INSERT INTO `dignity` (`id`, `VehiclesTitle`, `VehiclesBrand`, `VehiclesOverview`, `PricePerDay`, `FuelType`, `ModelYear`, `SeatingCapacity`, `Vimage1`, `Vimage2`, `Vimage3`, `Vimage4`, `Vimage5`, `AirConditioner`, `PowerDoorLocks`, `AntiLockBrakingSystem`, `BrakeAssist`, `PowerSteering`, `DriverAirbag`, `PassengerAirbag`, `PowerWindows`, `CDPlayer`, `CentralLocking`, `CrashSensor`, `LeatherSeats`, `RegDate`, `UpdationDate`) VALUES (1, 'dignity', NULL, NULL, 'Divyanshu Singh', 'PREFECT JUNIOR', NULL, NULL, 'Divyanshu Singh Prefect.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:35:51', NULL), (2, 'dignity', NULL, NULL, 'Mauli Singh', 'PREFECT JUNIOR', NULL, NULL, 'Mauli Singh Prefect.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:36:13', NULL), (3, 'dignity', NULL, NULL, 'Nandini Awasthi', 'PREFECT JUNIOR', NULL, NULL, 'Nandini Awawsthi Prefect.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:36:46', NULL), (4, 'dignity', NULL, NULL, 'Rajat Singh', 'PREFECT JUNIOR', NULL, NULL, 'RAJAT SINGH.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:37:06', NULL), (6, 'dignity', NULL, NULL, 'Tanya Chand', 'VICE CAPTAIN JUNIOR', NULL, NULL, 'Tanya Chand Vice Captain.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:38:09', NULL), (7, 'dignity', NULL, NULL, 'Tanishqa Singh', 'CAPTAIN JUNIOR', NULL, NULL, 'Tanishqa Singh Captain.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:41:25', NULL), (9, 'dignity', NULL, NULL, 'Yusuf Meraz', 'PREFECT PRIMARY', NULL, NULL, 'PREFECT YUSUF MERAZ-.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:01:07', NULL), (10, 'dignity', NULL, NULL, 'Ansh Verma', 'PREFECT PRIMARY', NULL, NULL, 'Prefect-Ansh Verma.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:01:30', NULL), (11, 'dignity', NULL, NULL, 'Saumya Mishra', 'PREFECT PRIMARY', NULL, NULL, 'Prefect-Saumya Mishra.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:01:55', NULL), (12, 'dignity', NULL, NULL, 'Vinay Pandey', 'PREFECT PRIMARY', NULL, NULL, 'Prefect-Vinay Pandey.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:02:22', NULL), (13, 'dignity', NULL, NULL, 'Khitiz Singh', 'VICE CAPTAIN PRIMARY', NULL, NULL, 'Vice Captain-Khitiz Singh.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:02:53', NULL), (14, 'dignity', NULL, NULL, 'Kritagya Agrahari', 'CAPTAIN PRIMARY', NULL, NULL, 'Captain-Kritagya Agrahari.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:05:36', NULL), (15, 'dignity', NULL, NULL, 'Akriti Gupta', 'PREFECT SENIOR', NULL, NULL, 'AKRITI GUPTA PREFECT.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:26:20', NULL), (16, 'dignity', NULL, NULL, 'Ayush Tripathi', 'VICE CAPTAIN SENIOR', NULL, NULL, 'AYUSH TRIPATHI V CAPT.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:26:42', NULL), (17, 'dignity', NULL, NULL, 'Harshit Jaiswal', 'PREFECT SENIOR', NULL, NULL, 'HARSHIT JAISWAL PREFECT.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:27:10', NULL), (18, 'dignity', NULL, NULL, 'Sandhya Singh', 'PREFECT SENIOR', NULL, NULL, 'SANDHYA SINGH PREFECT.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:27:27', NULL), (19, 'dignity', NULL, NULL, 'Tibrika Rai', 'CAPTAIN SENIOR', NULL, NULL, 'TIBRIKA RAI CAPT.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:27:46', NULL); -- -------------------------------------------------------- -- -- Table structure for table `eco` -- CREATE TABLE `eco` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(11) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `enquery` -- CREATE TABLE `enquery` ( `id` int(100) NOT NULL, `name` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `phone` int(12) NOT NULL, `message` varchar(500) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `enquery` -- INSERT INTO `enquery` (`id`, `name`, `email`, `phone`, `message`) VALUES (1, 'naman', 'chaudharynaman321@gmail.com', 2147483647, 'fbfb'), (2, 'naman', 'chaudharynaman321@gmail.com', 0, 'rggrtgrtgrtgtrggrrg'); -- -------------------------------------------------------- -- -- Table structure for table `faq` -- CREATE TABLE `faq` ( `id` int(200) NOT NULL, `question` varchar(200) NOT NULL, `answer` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `faq` -- INSERT INTO `faq` (`id`, `question`, `answer`) VALUES (1, 'Would you please give us some general information about your organization?', 'Lucknow Public Schools and Colleges is one of the most prestigious group of educational institutions in the state of U.P. Our branches are functioning in Lucknow , Sitapur, Lakhimpur Kheri and Hardoi '), (2, 'Which pattern of school education is being followed at Lucknow Public Schools and Colleges?', 'The pattern of education being followed at Lucknow Public Schools and Colleges is such that 3 of its branches are affiliated to ICSE which are situated at A Block Rajajipuram, Sahara State Jankipuram '), (3, 'Are hostel facilities available at Lucknow Public Schools and Colleges?', 'In 3 branches of our organization hostel facility is available. Our branches at Gomti Nagar(CBSE Br) Lakhimpur Kheri(ICSE Br) and Madhoganj(U.P Board) (Hardoi) provide, the best facilities with separa'), (4, 'When do admissions start in LPS ?', 'For all the details regarding entire admission procedure in Lucknow Public Schools and Colleges, please contact the desired campus in which admission is sought. Please note that Admission form /Prospe'), (5, 'How can one apply for any teaching or non teaching job at Lucknow Public Schools and Colleges?', 'It is easy. Kindly fill up the Lucknow Public Schools and Colleges application form or one may upload one’s CV too. Subject to the number of vacancies and requirement you may be called for interview. '), (6, 'Is B.Ed. or any other equivalent qualification necessary to apply for a job in Lucknow Public Schools and Colleges ?', 'No. As far as non teaching posts are concerned, required criteria for the post are needed. For teaching posts, B.Ed. or equivalent qualification gets weightage and respective benefits in appointment. '), (7, 'Are there, any campus, franchisee or affiliate of Lucknow Public Schools and Colleges in any other city outside Lucknow ?', 'Lucknow Public Schools and Colleges is running a chain of schools in Lucknow city itself and has three school campuses outside Lucknow. Please note that Lucknow Public Schools and Colleges does not ha'), (8, 'Do you have smart classes in Lucknow Public Schools and Colleges?', 'We would like to inform you that Lucknow Public Schools and Colleges has smart classes in its campuses, with interactive white boards and animated, educational contents.'), (9, 'You have been in the field of quality education with your valuable inputs for more than three decades. As far as education of children (Primary to Senior Secondary levels) is concerned, what do you sa', 'Obviously, parents want their children to get a ‘good’ meaningful and future securing education. Within their resources and understanding of education they look for the best school they can afford. Fo'), (10, 'How do you make students aware of their career?', 'We have a Career Counselling Cell headed by a Chief Counsellor, who keeps on interacting and organizing career counselling sessions with students at all the branches. Students’ doubts are cleared and '), (11, 'What about preparations for Competitive Examinations?', 'Ours is a holistic approach. Subject experts work as mentors. They remove hurdles in their understanding. Apart from class room teachings, subject related strategies are applied to get them harnessed '), (12, 'Does the present system of education need a change ?', 'Yes, It does- there must be some fundamental changes. First, learning targets need to be articulated for each state but no education system presents so, and the society at large must understand well w'); -- -------------------------------------------------------- -- -- Table structure for table `fees` -- CREATE TABLE `fees` ( `id` int(11) NOT NULL, `sr` varchar(50) NOT NULL, `name` varchar(50) NOT NULL, `fathername` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `fees` -- INSERT INTO `fees` (`id`, `sr`, `name`, `fathername`) VALUES (2, '1', 'naman', 'ffbbtr'); -- -------------------------------------------------------- -- -- Table structure for table `gallery1` -- CREATE TABLE `gallery1` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(11) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `gallery1` -- INSERT INTO `gallery1` (`id`, `VehiclesTitle`, `VehiclesBrand`, `VehiclesOverview`, `PricePerDay`, `FuelType`, `ModelYear`, `SeatingCapacity`, `Vimage1`, `Vimage2`, `Vimage3`, `Vimage4`, `Vimage5`, `AirConditioner`, `PowerDoorLocks`, `AntiLockBrakingSystem`, `BrakeAssist`, `PowerSteering`, `DriverAirbag`, `PassengerAirbag`, `PowerWindows`, `CDPlayer`, `CentralLocking`, `CrashSensor`, `LeatherSeats`, `RegDate`, `UpdationDate`) VALUES (1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '_DSC0026.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 05:55:29', NULL), (2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '_DSC0135.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 05:55:46', NULL), (3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '_DSC0217.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 05:56:01', NULL), (4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '_DSC0280.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 05:56:10', NULL), (5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '_DSC0412.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 05:56:21', NULL), (6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '_DSC1572.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 05:56:43', NULL), (7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '_DSC1631.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 05:56:55', NULL), (8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '_DSC1690.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 05:57:07', NULL), (9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '_DSC2288 - Copy.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 05:57:15', NULL), (10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '_DSC2310 - Copy.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 05:57:20', NULL), (11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '_DSC2321.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 05:57:27', NULL), (12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '_DSC2503.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 05:57:33', NULL), (14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '_DSC2683.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 05:58:03', NULL), (15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '21.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 05:58:09', NULL), (16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '20190502_085958(0).jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 05:58:17', NULL), (17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '58444290_443409906412140_7099214828685754368_o.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 05:58:29', NULL), (18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '59691392_446611472758650_9086791432596881408_o.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 05:58:34', NULL), (19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '69624875_514264869326643_8767026599104086016_o - Copy.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 05:58:39', NULL), (20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '70487115_528188204600976_7498803149793132544_o.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 05:58:43', NULL), (21, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '70505806_528188477934282_8484058799135522816_o.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 05:58:47', NULL), (22, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '71001174_540521200034343_3006644344636571648_n.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 05:58:51', NULL), (23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'IMG-20200111-WA0039.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 05:58:56', NULL); -- -------------------------------------------------------- -- -- Table structure for table `hostel` -- CREATE TABLE `hostel` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(11) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `infra` -- CREATE TABLE `infra` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(11) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `infra` -- INSERT INTO `infra` (`id`, `VehiclesTitle`, `VehiclesBrand`, `VehiclesOverview`, `PricePerDay`, `FuelType`, `ModelYear`, `SeatingCapacity`, `Vimage1`, `Vimage2`, `Vimage3`, `Vimage4`, `Vimage5`, `AirConditioner`, `PowerDoorLocks`, `AntiLockBrakingSystem`, `BrakeAssist`, `PowerSteering`, `DriverAirbag`, `PassengerAirbag`, `PowerWindows`, `CDPlayer`, `CentralLocking`, `CrashSensor`, `LeatherSeats`, `RegDate`, `UpdationDate`) VALUES (2, '1', NULL, NULL, NULL, NULL, NULL, NULL, '1 (1).JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:11:27', NULL), (3, '2', NULL, NULL, NULL, NULL, NULL, NULL, '1 (2).JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:11:38', NULL), (4, '3', NULL, NULL, NULL, NULL, NULL, NULL, '1 (3).JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:11:45', NULL), (5, '4', NULL, NULL, NULL, NULL, NULL, NULL, '1 (4).JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:11:52', NULL), (6, '5', NULL, NULL, NULL, NULL, NULL, NULL, '1 (5).JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:11:59', NULL), (7, '6', NULL, NULL, NULL, NULL, NULL, NULL, '1 (6).JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:12:08', NULL), (9, '7', NULL, NULL, NULL, NULL, NULL, NULL, '1 (7).JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:12:42', NULL), (10, '8', NULL, NULL, NULL, NULL, NULL, NULL, '1 (8).JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:12:49', NULL), (11, '9', NULL, NULL, NULL, NULL, NULL, NULL, '1 (9).JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:12:56', NULL), (12, '10', NULL, NULL, NULL, NULL, NULL, NULL, '1 (10).JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:13:03', NULL), (13, '11', NULL, NULL, NULL, NULL, NULL, NULL, '1 (11).JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:13:10', NULL), (14, '12', NULL, NULL, NULL, NULL, NULL, NULL, '1 (12).JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:13:23', NULL), (15, '13', NULL, NULL, NULL, NULL, NULL, NULL, '1 (13).JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:13:31', NULL), (16, '14', NULL, NULL, NULL, NULL, NULL, NULL, '1 (14).JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:13:37', NULL), (17, '15', NULL, NULL, NULL, NULL, NULL, NULL, '1 (15).JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:13:44', NULL), (18, '16', NULL, NULL, NULL, NULL, NULL, NULL, '1 (16).JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:13:51', NULL), (19, '17', NULL, NULL, NULL, NULL, NULL, NULL, '1 (17).jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:13:58', NULL); -- -------------------------------------------------------- -- -- Table structure for table `liberty` -- CREATE TABLE `liberty` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(100) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `liberty` -- INSERT INTO `liberty` (`id`, `VehiclesTitle`, `VehiclesBrand`, `VehiclesOverview`, `PricePerDay`, `FuelType`, `ModelYear`, `SeatingCapacity`, `Vimage1`, `Vimage2`, `Vimage3`, `Vimage4`, `Vimage5`, `AirConditioner`, `PowerDoorLocks`, `AntiLockBrakingSystem`, `BrakeAssist`, `PowerSteering`, `DriverAirbag`, `PassengerAirbag`, `PowerWindows`, `CDPlayer`, `CentralLocking`, `CrashSensor`, `LeatherSeats`, `RegDate`, `UpdationDate`) VALUES (1, 'liberty', NULL, NULL, 'Astha Singh', 'PREFECT JUNIOR', NULL, NULL, 'Astha Singh Prefect.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:42:29', NULL), (2, 'liberty', NULL, NULL, 'Devyani Tripathi', 'VICE CAPTAIN JUNIOR', NULL, NULL, 'Devyani Tripathi Vice Captain.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:43:16', NULL), (3, 'liberty', NULL, NULL, 'KRISHNA SINGH ', 'PREFECT JUNIOR', NULL, NULL, 'Krishna Singh Prefect.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:43:39', NULL), (4, 'liberty', NULL, NULL, 'Pushyamitra Rai', 'PREFECT JUNIOR', NULL, NULL, 'Pushyamitra Rai Prefect.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:44:05', NULL), (5, 'liberty', NULL, NULL, 'Samar Pratap Singh', 'PREFECT JUNIOR', NULL, NULL, 'Samar Pratap Singh Prefect.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:44:29', NULL), (6, 'liberty', NULL, NULL, 'Tisha Dutta', 'CAPTAIN JUNIOR', NULL, NULL, 'Tisha Dutta Captain.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:44:49', NULL), (7, 'liberty', NULL, NULL, 'Ananya Verma ', 'VICE CAPTAIN JUNIOR', NULL, NULL, 'Ananya Verma Prefect.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:46:50', NULL), (8, 'liberty', NULL, NULL, 'Prisha Srivastava', 'CAPTAIN PRIMARY ', NULL, NULL, 'Captain -Prisha Srivastava.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:09:20', NULL), (9, 'liberty', NULL, NULL, 'Anant Verma', 'PREFECT PRIMARY', NULL, NULL, 'Prefect- Anant Verma.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:09:40', NULL), (10, 'liberty', NULL, NULL, 'Anshika Rai', 'PREFECT PRIMARY', NULL, NULL, 'Prefect-Anshika Rai.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:10:01', NULL), (11, 'liberty', NULL, NULL, 'Kartik Mishra', 'PREFECT PRIMARY', NULL, NULL, 'Prefect-Kartik Mishra.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:10:19', NULL), (12, 'liberty', NULL, NULL, 'Shaurya Veer Singh', 'PREFECT PRIMARY', NULL, NULL, 'Prefect-Shaurya Veer Singh.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:10:43', NULL), (13, 'liberty', NULL, NULL, 'Aditi Giri', 'VICE CAPTAIN PRIMARY', NULL, NULL, 'Vice Captain-Aditi Giri.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:11:32', NULL), (14, 'liberty', NULL, NULL, 'Anany Mishra', 'PREFECT SENIOR', NULL, NULL, 'ANANY MISHRA PREFECT.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:19:08', NULL), (15, 'liberty', NULL, NULL, 'Disha Singh', 'PREFECT SENIOR', NULL, NULL, 'DISHA SINGH PREFECT.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:19:31', NULL), (16, 'liberty', NULL, NULL, 'Nivedita Prakash', 'PREFECT SENIOR', NULL, NULL, 'NIVEDITA PRAKASH PREFECT.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:19:50', NULL), (17, NULL, NULL, NULL, 'Rashi Verma', 'VICE CAPTAIN SENIOR', NULL, NULL, 'RASHI VERMA VICE CAPT.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:20:07', NULL), (18, 'liberty', NULL, NULL, 'Rishabh Singh', 'CAPTAIN SENIOR', NULL, NULL, 'RISHABH SINGH CAPT.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:20:32', NULL), (19, 'liberty', NULL, NULL, 'Yashi Pal', 'PREFECT SENIOR', NULL, NULL, 'YASHI PAL PREFECT.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:20:54', NULL); -- -------------------------------------------------------- -- -- Table structure for table `libraryadmin` -- CREATE TABLE `libraryadmin` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(11) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `link` -- CREATE TABLE `link` ( `id` int(100) NOT NULL, `facebook` varchar(200) NOT NULL, `instagram` varchar(200) NOT NULL, `twitter` varchar(200) NOT NULL, `linkedin` varchar(200) NOT NULL, `youtube` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `link` -- INSERT INTO `link` (`id`, `facebook`, `instagram`, `twitter`, `linkedin`, `youtube`) VALUES (1, 'https://www.facebook.com/lucknowpublicschoolsandcolleges/', 'https://www.instagram.com/lps_lpc_official/', 'https://twitter.com/LucknowPublic', '#', 'https://www.youtube.com/channel/UCVIKIPkZidoMwG4dZZw5uCw'); -- -------------------------------------------------------- -- -- Table structure for table `managing` -- CREATE TABLE `managing` ( `id` int(11) NOT NULL, `sr` varchar(50) NOT NULL, `name` varchar(50) NOT NULL, `desigination` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `managing` -- INSERT INTO `managing` (`id`, `sr`, `name`, `desigination`) VALUES (1, '1', 'Kanti Singh', 'Chairman'), (2, '2', 'Shri. Surya Kumar', 'Deputy Chairman'), (3, '3', 'Dr. S. P. Singh', 'General Secretary'), (4, '4', 'Shri. Amitabh Chakraboty', 'Vice Minister'), (5, '5', 'Ms. Neha Singh', 'Treasurer'), (6, '6', 'Mrs. Ruchi Shukla', 'Member'), (7, '7', 'Mrs. Asha Verma', 'Member'), (8, '8', 'Mr. Harshit Singh', 'Member'), (9, '9 ', 'Mr. Prabhod Kumar', 'Member'), (10, '10', 'Ms. Garima Singh', 'Member (General Assembly)'), (11, '11', 'Mr. Triloki Nath', 'Member (General Assembly)'), (12, '12', 'Mr. Sushil Kumar', 'Member (General Assembly)'), (13, '13', 'Mr. Shikhar Pal', 'Member (General Assembly)'), (14, '14', 'Dr. Anirudh Verma', 'Member (General Assembly)'); -- -------------------------------------------------------- -- -- Table structure for table `mentor` -- CREATE TABLE `mentor` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(11) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` date DEFAULT NULL, `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `musicadmin` -- CREATE TABLE `musicadmin` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(11) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `nobel` -- CREATE TABLE `nobel` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(50) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `nobel` -- INSERT INTO `nobel` (`id`, `VehiclesTitle`, `VehiclesBrand`, `VehiclesOverview`, `PricePerDay`, `FuelType`, `ModelYear`, `SeatingCapacity`, `Vimage1`, `Vimage2`, `Vimage3`, `Vimage4`, `Vimage5`, `AirConditioner`, `PowerDoorLocks`, `AntiLockBrakingSystem`, `BrakeAssist`, `PowerSteering`, `DriverAirbag`, `PassengerAirbag`, `PowerWindows`, `CDPlayer`, `CentralLocking`, `CrashSensor`, `LeatherSeats`, `RegDate`, `UpdationDate`) VALUES (1, 'nobel', NULL, NULL, 'Akansha Singh', 'PREFECT JUNIOR', NULL, NULL, 'Astha Singh Prefect.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:46:01', NULL), (2, 'nobel', NULL, NULL, 'Ananya Verma ', 'VICE CAPTAIN JUNIOR', NULL, NULL, 'Ananya Verma Vice Captain.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:47:15', NULL), (3, 'nobel', NULL, NULL, 'Ashi Singh', 'PREFECT JUNIOR', NULL, NULL, 'Ashi Singh Prefect.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:47:31', NULL), (4, 'nobel', NULL, NULL, 'Riya Rawat', 'CAPTAIN JUNIOR', NULL, NULL, 'Riya Rawat Captain.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:47:53', NULL), (5, 'nobel', NULL, NULL, 'Suryansh Jaiswal', 'PREFECT JUNIOR', NULL, NULL, 'SURYANSH JAISWAL PREFECT.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:48:17', NULL), (6, 'nobel', NULL, NULL, 'Shrishti Mishra', 'CAPTAIN PRIMARY', NULL, NULL, 'Captain- Srishti Mishra.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:06:56', NULL), (7, 'nobel', NULL, NULL, 'Ananya Asthana', 'PREFECT PRIMARY', NULL, NULL, 'PREFECT ANANYA ASTHANA.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:07:17', NULL), (8, 'nobel', NULL, NULL, 'Gaurav Gupta', 'PREFECT PRIMARY', NULL, NULL, 'Prefect- Gaurav Gupta.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:07:34', NULL), (9, 'nobel', NULL, NULL, 'Shriya Singh', 'PREFECT PRIMARY', NULL, NULL, 'Prefect-Shriya Singh.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:07:59', NULL), (10, 'nobel', NULL, NULL, 'Yash Verma', 'PREFECT PRIMARY', NULL, NULL, 'Prefect-Yash Verma.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:08:15', NULL), (11, 'nobel', NULL, NULL, 'Divya Verma', 'PREFECT PRIMARY', NULL, NULL, 'Vice Captain- Divya Verma.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:08:32', NULL), (12, 'nobel', NULL, NULL, 'Akriti Srivastava', 'PREFECT SENIOR', NULL, NULL, 'AKRITI SRIVASTAVA PREFECT.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:22:44', NULL), (13, 'nobel', NULL, NULL, 'Anushka Shukla', 'PREFECT SENIOR', NULL, NULL, 'ANUSHKA SHUKLA.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:23:40', NULL), (14, 'nobel', NULL, NULL, 'Apurva Sinha', 'PREFECT SENIOR', NULL, NULL, 'APURVA SINHA.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:23:59', NULL), (15, 'nobel', NULL, NULL, 'Ananya Thakur', 'CAPTAIN SENIOR', NULL, NULL, 'CAPTYAIN ANANYA THAKUR .jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:24:25', NULL), (16, 'nobel', NULL, NULL, 'Satvik Singh', 'VICE CAPTAIN SENIOR', NULL, NULL, 'SATVIK SINGH VICE CAPT.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:24:45', NULL), (17, 'nobel', NULL, NULL, 'Shivam Singh', 'PREFECT SENIOR', NULL, NULL, 'SHIVAM SINGH.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:25:06', NULL), (18, 'nobel', NULL, NULL, 'Ananya Thakur', 'CAPTAIN SENIOR', NULL, NULL, 'CAPTYAIN ANANYA THAKUR .jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:25:49', NULL); -- -------------------------------------------------------- -- -- Table structure for table `office` -- CREATE TABLE `office` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(50) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `office` -- INSERT INTO `office` (`id`, `VehiclesTitle`, `VehiclesBrand`, `VehiclesOverview`, `PricePerDay`, `FuelType`, `ModelYear`, `SeatingCapacity`, `Vimage1`, `Vimage2`, `Vimage3`, `Vimage4`, `Vimage5`, `AirConditioner`, `PowerDoorLocks`, `AntiLockBrakingSystem`, `BrakeAssist`, `PowerSteering`, `DriverAirbag`, `PassengerAirbag`, `PowerWindows`, `CDPlayer`, `CentralLocking`, `CrashSensor`, `LeatherSeats`, `RegDate`, `UpdationDate`) VALUES (1, NULL, NULL, NULL, 'Rudra Pratap Singh ', 'VICE HEAD BOY JUNIOR', NULL, NULL, 'Rudra Pratap Singh Vice Head Boy.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 06:43:32', NULL), (2, 'office', NULL, NULL, 'DEEPAK KUMAR ', 'VICE SPORTS CAPTAIN JUNIOR', NULL, NULL, 'DEEPAK KUMAR VICE SPORTS CAPTAIN.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 06:46:32', NULL), (3, 'office', NULL, NULL, 'Priyal Srivastava ', 'Vice Head Girl JUNIOR', NULL, NULL, 'Priyal Srivastava Vice Head Girl.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 06:47:48', NULL), (4, 'office', NULL, NULL, 'Rudra Pratap Singh Vice Head Boy', 'Vice Head Boy JUNIOR', NULL, NULL, 'Rudra Pratap Singh Vice Head Boy.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 06:48:36', NULL), (5, 'office', NULL, NULL, 'Saurabh Singh ', ' Head Boy JUNIOR', NULL, NULL, 'Saurabh Singh Head Boy.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 06:49:25', NULL), (6, 'office', NULL, NULL, 'Shikha Singh ', 'Head Girl JUNIOR', NULL, NULL, 'Shikha Singh Head Girl.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 06:50:08', NULL), (7, 'office', NULL, NULL, 'Sidra Fatima', 'Head girl PRIMARY', NULL, NULL, 'Headgirl-Sidra Fatima.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 06:55:44', NULL), (8, 'office', NULL, NULL, ' PRINCE KUMAR', 'SPORTS CAPTAIN PRIMARY', NULL, NULL, 'SPORTS CAPTAIN-PRINCE KUMAR.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 06:56:35', NULL), (9, 'office', NULL, NULL, 'Archit Mishra', 'Vice Head boy PRIMARY', NULL, NULL, 'Vice Headboy-Archit Mishra.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 06:57:36', NULL), (10, 'office', NULL, NULL, 'Kashish Katiyar', 'Vice Headgirl PRIMARY', NULL, NULL, 'Vice Headgirl-Kashish Katiyar.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 06:58:26', NULL), (11, 'office', NULL, NULL, ' SHIKHAR SINGH', 'VICE SPORTS CAPTAIN', NULL, NULL, 'VICE SPORTS CAPTAIN SHIKHAR SINGH.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 06:59:04', NULL), (12, 'office', NULL, NULL, 'APOORVA PANDEY ', 'VICE HEAD GIRL', NULL, NULL, 'APOORVA PANDEY VICE HEAD GIRL.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:00:38', NULL), (13, 'office', NULL, NULL, 'ARIN PANDEY ', 'VICE SPORTS CAPTAIN SENIOR', NULL, NULL, 'ARIN PANDEY VICE SPORTS CAPTAIN.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:01:46', NULL), (14, 'office', NULL, NULL, 'DAKSH PRATAP SINGH ', 'HEAD BOY SENIOR', NULL, NULL, 'DAKSH PRATAP SINGH HEAD BOY.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:02:34', NULL), (15, 'office', NULL, NULL, 'MOHD. AHMAD ', 'VICE HEAD BOY SENIOR', NULL, NULL, 'MOHD. AHMAD VICE HEAD BOY.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:03:20', NULL), (16, 'office', NULL, NULL, 'PRAKRITI SINGH ', 'HEAD GIRL SENIOR', NULL, NULL, 'PRAKRITI SINGH HEAD GIRL.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:04:25', NULL), (17, 'office', NULL, NULL, 'VIVEK SINGH ', 'SPORTS CAPTAIN SENIOR', NULL, NULL, 'VIVEK SINGH SPORTS CAPTAIN.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:05:20', NULL), (18, 'office', NULL, NULL, 'Anoop Singh', 'HEAD BOY (PRIMARY)', NULL, NULL, 'Headboy-Anoop Singh.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:51:24', NULL), (19, 'office', NULL, NULL, 'Sidra Fatima', 'HEAD GIRL (PRIMARY)', NULL, NULL, 'Headgirl-Sidra Fatima.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:51:59', NULL), (20, 'office', NULL, NULL, 'Prince Kumar', 'SPORTS CAPTAIN (PRIMARY)', NULL, NULL, 'SPORTS CAPTAIN-PRINCE KUMAR.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:53:07', NULL), (21, 'office', NULL, NULL, 'Archit Mishra', 'VICE HEAD BOY PRIMARY', NULL, NULL, 'Vice Headboy-Archit Mishra.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:54:05', NULL), (22, 'office', NULL, NULL, 'Kashish Katiyar', 'VICE HEAD GIRL PRIMARY', NULL, NULL, 'Vice Headgirl-Kashish Katiyar.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:54:38', NULL), (23, 'office', NULL, NULL, 'Shikhar Singh', 'VICE SPORTS CAPTAIN PRIMARY', NULL, NULL, 'VICE SPORTS CAPTAIN SHIKHAR SINGH.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:55:21', NULL), (24, 'office', NULL, NULL, 'APOORVA PANDEY ', 'VICE HEAD GIRL SENIOR', NULL, NULL, 'APOORVA PANDEY VICE HEAD GIRL.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:14:08', NULL); -- -------------------------------------------------------- -- -- Table structure for table `prospectus` -- CREATE TABLE `prospectus` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(11) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `prospectus` -- INSERT INTO `prospectus` (`id`, `VehiclesTitle`, `VehiclesBrand`, `VehiclesOverview`, `PricePerDay`, `FuelType`, `ModelYear`, `SeatingCapacity`, `Vimage1`, `Vimage2`, `Vimage3`, `Vimage4`, `Vimage5`, `AirConditioner`, `PowerDoorLocks`, `AntiLockBrakingSystem`, `BrakeAssist`, `PowerSteering`, `DriverAirbag`, `PassengerAirbag`, `PowerWindows`, `CDPlayer`, `CentralLocking`, `CrashSensor`, `LeatherSeats`, `RegDate`, `UpdationDate`) VALUES (1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'PROSPECTUS 2020-21.pdf', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-24 17:15:39', NULL); -- -------------------------------------------------------- -- -- Table structure for table `regal` -- CREATE TABLE `regal` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(50) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `regal` -- INSERT INTO `regal` (`id`, `VehiclesTitle`, `VehiclesBrand`, `VehiclesOverview`, `PricePerDay`, `FuelType`, `ModelYear`, `SeatingCapacity`, `Vimage1`, `Vimage2`, `Vimage3`, `Vimage4`, `Vimage5`, `AirConditioner`, `PowerDoorLocks`, `AntiLockBrakingSystem`, `BrakeAssist`, `PowerSteering`, `DriverAirbag`, `PassengerAirbag`, `PowerWindows`, `CDPlayer`, `CentralLocking`, `CrashSensor`, `LeatherSeats`, `RegDate`, `UpdationDate`) VALUES (1, 'regal', NULL, NULL, 'Shailly Verma', 'CaptaiN', NULL, NULL, 'Captain-Shailly Verma.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:09:09', NULL), (2, 'regal', NULL, NULL, 'Shailly Verma', 'CAPTAIN PRIMARY', NULL, NULL, 'Captain-Shailly Verma.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:10:44', NULL), (3, 'regal', NULL, NULL, ' Aradhya Yadav', 'PREFECT PRIMARY', NULL, NULL, 'Prefect- Aradhya Yadav.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:11:24', NULL), (4, 'regal', NULL, NULL, ' Nidhi Verma', 'PREFECT PRIMARY', NULL, NULL, 'Prefect- Nidhi Verma.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:12:08', NULL), (5, 'regal', NULL, NULL, ' Rudresh Singh', 'PREFECT PRIMARY', NULL, NULL, 'Prefect- Rudresh Singh.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:12:44', NULL), (6, 'regal', NULL, NULL, ' Rudresh Singh', 'PREFECT PRIMARY', NULL, NULL, 'Prefect- Rudresh Singh.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:13:43', NULL), (7, 'regal', NULL, NULL, ' Shriya Singh', 'PREFECT PRIMARY', NULL, NULL, 'Prefect- Shriya Singh.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:14:19', NULL), (8, 'regal', NULL, NULL, 'Shagun Rai', 'Vice Captain PRIMARY', NULL, NULL, 'Captain-Kritagya Agrahari.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:15:20', NULL), (9, 'regal', NULL, NULL, 'Abhishek Chauhan ', ' PREFECT JUNIOR', NULL, NULL, 'Abhishek Chauhan Prefect.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:17:26', NULL), (10, 'regal', NULL, NULL, 'Anant Kumar Patel ', ' Prefect JUNIOR', NULL, NULL, 'Anant Kumar Patel Prefect.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:18:10', NULL), (11, 'regal', NULL, NULL, 'Bhavya Singh ', ' Vice Captain JUNIOR', NULL, NULL, 'Bhavya Singh Vice Captain.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:18:45', NULL), (12, NULL, NULL, NULL, 'Jatin Verma ', 'PREFECT JUNIOR', NULL, NULL, 'Jatin Verma Prefect.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:29:00', NULL), (13, 'regal', NULL, NULL, 'Shaily Verma', 'CAPTAIN PRIMARY ', NULL, NULL, 'Captain-Shailly Verma.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:57:48', NULL), (14, 'regal', NULL, NULL, 'Aradhya Yadav', 'PREFECT PRIMARY', NULL, NULL, 'Prefect- Aradhya Yadav.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:58:22', NULL), (15, 'regal', NULL, NULL, 'Nidhi Verma', 'PREFECT PRIMARY', NULL, NULL, 'Prefect- Nidhi Verma.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:58:46', NULL), (16, 'regal', NULL, NULL, 'Rudresh Singh', 'PREFECT PRIMARY', NULL, NULL, 'Prefect- Rudresh Singh.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:59:07', NULL), (17, 'regal', NULL, NULL, 'Shriya Singh', 'PREFECT PRIMARY', NULL, NULL, 'Prefect- Shriya Singh.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:59:23', NULL), (18, 'regal', NULL, NULL, 'Shagun Rai', 'VICE CAPTAIN PRIMARY', NULL, NULL, 'ViceCaptain-Shagun Rai.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 07:59:45', NULL), (19, 'regal', NULL, NULL, 'Devansh Pandey', 'CAPTAIN SENIOR', NULL, NULL, 'DEVANSH PANDEY CAPT.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:15:51', NULL), (20, 'regal', NULL, NULL, 'Manya Agarwal', 'VICE CAPTAIN SENIOR', NULL, NULL, 'MANYA AGARWAL VICE CAPT..jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:16:19', NULL), (21, 'regal', NULL, NULL, 'Nandani SIngh', 'PREFECT SENIOR', NULL, NULL, 'NANDANI SINGH.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:16:50', NULL), (22, 'regal', NULL, NULL, 'Rudra Dwivedi', 'PREFECT SENIOR', NULL, NULL, 'RUDRA DWIVEDI.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:17:16', NULL), (23, 'regal', NULL, NULL, 'Shreya Rauniyal', 'PREFECT SENIOR', NULL, NULL, 'SHREYA RAUNIYAL.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:17:44', NULL), (24, 'regal', NULL, NULL, 'Suchi Pandey', 'PREFECT SENIOR', NULL, NULL, 'SUCHI PANDEY.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-15 08:18:08', NULL); -- -------------------------------------------------------- -- -- Table structure for table `schoolawards` -- CREATE TABLE `schoolawards` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(11) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `schoolawards` -- INSERT INTO `schoolawards` (`id`, `VehiclesTitle`, `VehiclesBrand`, `VehiclesOverview`, `PricePerDay`, `FuelType`, `ModelYear`, `SeatingCapacity`, `Vimage1`, `Vimage2`, `Vimage3`, `Vimage4`, `Vimage5`, `AirConditioner`, `PowerDoorLocks`, `AntiLockBrakingSystem`, `BrakeAssist`, `PowerSteering`, `DriverAirbag`, `PassengerAirbag`, `PowerWindows`, `CDPlayer`, `CentralLocking`, `CrashSensor`, `LeatherSeats`, `RegDate`, `UpdationDate`) VALUES (3, '7th UP state Grappling Championship 2019 was organized by UP State Grappling Association in which we got five gold medals , one silver and one bronze ', NULL, NULL, NULL, NULL, NULL, NULL, '1.jpeg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-24 17:21:14', NULL), (4, 'Team members of Scout & Guide received Governor Award for their outstanding performance in State level camp. The team included Aman Sharma, Kartikeya ', NULL, NULL, NULL, NULL, NULL, NULL, '4jpeg.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-24 17:33:41', NULL), (5, 'In Natkhat Utshav, Jigyasa Singh III-A and Aradhya Tripathi IV-C got 1st position, whereas Divyanshu Singh II-D, Sarthak Pal III-D, Sammriddhi Vishesh', NULL, NULL, NULL, NULL, NULL, NULL, '7 .jpeg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-24 17:34:32', NULL), (6, 'Sachin Yadav represented our country in South ASIAN games in Grappling event in which he stood winner and then he participated in Grappling World Cham', NULL, NULL, NULL, NULL, NULL, NULL, '8.jpeg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-24 17:35:12', NULL), (7, 'The event ‘Colosseum’ organized by Lucknow Public Schools & Colleges', NULL, NULL, NULL, NULL, NULL, NULL, '12.jpeg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-24 17:36:09', NULL), (8, 'In Sahodaya Mini Olympiad Athletics Meet our branch students Sampada got bronze medal in U-17 high jump, Anushak Upadhyay got silver medal in U-17 100', NULL, NULL, NULL, NULL, NULL, NULL, '25.jpeg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-24 17:37:43', NULL), (9, 'Our school organized Inter School Kho Kho Tournament under Hubs Of Learning of CBSE in which our team got first place. ', NULL, NULL, NULL, NULL, NULL, NULL, '22.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-24 17:39:02', NULL), (10, 'III position was bagged by our branch in Girls’ Flag March in the prestigious function of 71st Republic Day Celebration at Vidhan Sabha organized by', NULL, NULL, NULL, NULL, NULL, NULL, '19a.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-24 17:40:23', NULL); -- -------------------------------------------------------- -- -- Table structure for table `scienceadmin` -- CREATE TABLE `scienceadmin` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(11) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `staffadmin` -- CREATE TABLE `staffadmin` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(11) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `staffadmin` -- INSERT INTO `staffadmin` (`id`, `VehiclesTitle`, `VehiclesBrand`, `VehiclesOverview`, `PricePerDay`, `FuelType`, `ModelYear`, `SeatingCapacity`, `Vimage1`, `Vimage2`, `Vimage3`, `Vimage4`, `Vimage5`, `AirConditioner`, `PowerDoorLocks`, `AntiLockBrakingSystem`, `BrakeAssist`, `PowerSteering`, `DriverAirbag`, `PassengerAirbag`, `PowerWindows`, `CDPlayer`, `CentralLocking`, `CrashSensor`, `LeatherSeats`, `RegDate`, `UpdationDate`) VALUES (1, 'AJIT GANGWAR', NULL, '2018-19', NULL, 'BEST TEACHER', NULL, NULL, 'AJIT GANGWAR.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:22:17', NULL), (2, 'AKANSHA MISHRA', NULL, '2018-19', NULL, 'BEST TEACHER', NULL, NULL, 'AKANSHA SRIVASTAVA.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:22:37', NULL), (3, 'AKHILESHWAR PRASAD', NULL, '2018-19', NULL, 'BEST TEACHER', NULL, NULL, 'AKHILESHWAR PRASAD.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:23:03', NULL), (4, 'ANITA VERMA', NULL, '2018-19', NULL, 'BEST TEACHER', NULL, NULL, 'ANITA VERMA.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:23:18', NULL), (5, 'ANKITA KANCHAN', NULL, '2018-19', NULL, 'BEST TEACHER', NULL, NULL, 'ANKITA KANCHAN.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:23:50', NULL), (6, 'ARCHANA MISHRA', NULL, '2018-19', NULL, 'BEST TEACHER', NULL, NULL, 'ARCHANA MISHRA.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:24:11', NULL), (7, 'ARVIND TIWARI', NULL, '2018-19', NULL, 'BEST TEACHER', NULL, NULL, 'ARVIND TIWARI.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:24:29', NULL), (8, 'BARBARA KHAN', NULL, '2018-19', NULL, 'BEST TEACHER', NULL, NULL, 'BARBARA KHAN.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:24:51', NULL), (9, 'BHAVIKA GABA', NULL, '2018-19', NULL, 'BEST TEACHER', NULL, NULL, 'BHAVIKA GABA.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:25:11', NULL), (10, 'GIRIJA SINGH', NULL, '2018-19', NULL, 'BEST TEACHER', NULL, NULL, 'GIRIJA SINGH.JPG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-09 06:25:29', NULL); -- -------------------------------------------------------- -- -- Table structure for table `support` -- CREATE TABLE `support` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(11) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `supportingstaff` -- CREATE TABLE `supportingstaff` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(11) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `tblbooking` -- CREATE TABLE `tblbooking` ( `id` int(11) NOT NULL, `userEmail` varchar(100) DEFAULT NULL, `VehicleId` int(11) DEFAULT NULL, `FromDate` varchar(20) DEFAULT NULL, `ToDate` varchar(20) DEFAULT NULL, `message` varchar(255) DEFAULT NULL, `Status` int(11) DEFAULT NULL, `PostingDate` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `tblbrands` -- CREATE TABLE `tblbrands` ( `id` int(11) NOT NULL, `BrandName` varchar(120) NOT NULL, `CreationDate` timestamp NULL DEFAULT NULL, `UpdationDate` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `tblcontactusinfo` -- CREATE TABLE `tblcontactusinfo` ( `id` int(11) NOT NULL, `Address` tinytext DEFAULT NULL, `EmailId` varchar(255) DEFAULT NULL, `ContactNo` char(50) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tblcontactusinfo` -- INSERT INTO `tblcontactusinfo` (`id`, `Address`, `EmailId`, `ContactNo`) VALUES (1, 'Lucknow Public School Sec. 9, Vrindavan Yojna, Lucknow ', 'principallpsvy@gmail.com', '+91 9235 60 4781, +91 9044 06 9616'); -- -------------------------------------------------------- -- -- Table structure for table `tblcontactusquery` -- CREATE TABLE `tblcontactusquery` ( `id` int(11) NOT NULL, `name` varchar(100) DEFAULT NULL, `EmailId` varchar(120) DEFAULT NULL, `ContactNumber` char(11) DEFAULT NULL, `Message` longtext DEFAULT NULL, `PostingDate` timestamp NOT NULL DEFAULT current_timestamp(), `status` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `tblpages` -- CREATE TABLE `tblpages` ( `id` int(11) NOT NULL, `PageName` varchar(255) DEFAULT NULL, `type` varchar(255) NOT NULL DEFAULT '', `detail` longtext NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `tblsubscribers` -- CREATE TABLE `tblsubscribers` ( `id` int(11) NOT NULL, `SubscriberEmail` varchar(120) DEFAULT NULL, `PostingDate` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `tblusers` -- CREATE TABLE `tblusers` ( `id` int(11) NOT NULL, `FullName` varchar(120) DEFAULT NULL, `EmailId` varchar(100) DEFAULT NULL, `Password` varchar(100) DEFAULT NULL, `ContactNo` char(11) DEFAULT NULL, `dob` varchar(100) DEFAULT NULL, `Address` varchar(255) DEFAULT NULL, `City` varchar(100) DEFAULT NULL, `Country` varchar(100) DEFAULT NULL, `RegDate` timestamp NULL DEFAULT NULL, `UpdationDate` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `tblvehicles` -- CREATE TABLE `tblvehicles` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(11) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `tc` -- CREATE TABLE `tc` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(11) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `testimonial` -- CREATE TABLE `testimonial` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(11) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(900) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `timmer` -- CREATE TABLE `timmer` ( `id` int(20) NOT NULL, `link` varchar(50) NOT NULL, `a` varchar(100) NOT NULL, `b` varchar(100) NOT NULL, `c` varchar(100) NOT NULL, `d` varchar(300) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `timmer` -- INSERT INTO `timmer` (`id`, `link`, `a`, `b`, `c`, `d`) VALUES (1, 'https://www.youtube.com/watch?v=qsAU0rnSeNg', '30000', '600', '2000', '5000'); -- -------------------------------------------------------- -- -- Table structure for table `topperadmin` -- CREATE TABLE `topperadmin` ( `id` int(11) NOT NULL, `VehiclesTitle` varchar(150) DEFAULT NULL, `VehiclesBrand` int(11) DEFAULT NULL, `VehiclesOverview` longtext DEFAULT NULL, `PricePerDay` varchar(11) DEFAULT NULL, `FuelType` varchar(100) DEFAULT NULL, `ModelYear` varchar(500) DEFAULT NULL, `SeatingCapacity` int(11) DEFAULT NULL, `Vimage1` varchar(120) DEFAULT NULL, `Vimage2` varchar(120) DEFAULT NULL, `Vimage3` varchar(120) DEFAULT NULL, `Vimage4` varchar(120) DEFAULT NULL, `Vimage5` varchar(120) DEFAULT NULL, `AirConditioner` int(11) DEFAULT NULL, `PowerDoorLocks` int(11) DEFAULT NULL, `AntiLockBrakingSystem` int(11) DEFAULT NULL, `BrakeAssist` int(11) DEFAULT NULL, `PowerSteering` int(11) DEFAULT NULL, `DriverAirbag` int(11) DEFAULT NULL, `PassengerAirbag` int(11) DEFAULT NULL, `PowerWindows` int(11) DEFAULT NULL, `CDPlayer` int(11) DEFAULT NULL, `CentralLocking` int(11) DEFAULT NULL, `CrashSensor` int(11) DEFAULT NULL, `LeatherSeats` int(11) DEFAULT NULL, `RegDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `about` -- ALTER TABLE `about` ADD PRIMARY KEY (`id`); -- -- Indexes for table `admin` -- ALTER TABLE `admin` ADD PRIMARY KEY (`id`); -- -- Indexes for table `affiliation` -- ALTER TABLE `affiliation` ADD PRIMARY KEY (`id`); -- -- Indexes for table `blog` -- ALTER TABLE `blog` ADD PRIMARY KEY (`id`); -- -- Indexes for table `cafe` -- ALTER TABLE `cafe` ADD PRIMARY KEY (`id`); -- -- Indexes for table `calender` -- ALTER TABLE `calender` ADD PRIMARY KEY (`id`); -- -- Indexes for table `cbsedata` -- ALTER TABLE `cbsedata` ADD PRIMARY KEY (`id`); -- -- Indexes for table `digitaladmin` -- ALTER TABLE `digitaladmin` ADD PRIMARY KEY (`id`); -- -- Indexes for table `dignity` -- ALTER TABLE `dignity` ADD PRIMARY KEY (`id`); -- -- Indexes for table `eco` -- ALTER TABLE `eco` ADD PRIMARY KEY (`id`); -- -- Indexes for table `enquery` -- ALTER TABLE `enquery` ADD PRIMARY KEY (`id`); -- -- Indexes for table `faq` -- ALTER TABLE `faq` ADD PRIMARY KEY (`id`); -- -- Indexes for table `fees` -- ALTER TABLE `fees` ADD PRIMARY KEY (`id`); -- -- Indexes for table `gallery1` -- ALTER TABLE `gallery1` ADD PRIMARY KEY (`id`); -- -- Indexes for table `hostel` -- ALTER TABLE `hostel` ADD PRIMARY KEY (`id`); -- -- Indexes for table `infra` -- ALTER TABLE `infra` ADD PRIMARY KEY (`id`); -- -- Indexes for table `liberty` -- ALTER TABLE `liberty` ADD PRIMARY KEY (`id`); -- -- Indexes for table `libraryadmin` -- ALTER TABLE `libraryadmin` ADD PRIMARY KEY (`id`); -- -- Indexes for table `link` -- ALTER TABLE `link` ADD PRIMARY KEY (`id`); -- -- Indexes for table `managing` -- ALTER TABLE `managing` ADD PRIMARY KEY (`id`); -- -- Indexes for table `mentor` -- ALTER TABLE `mentor` ADD PRIMARY KEY (`id`); -- -- Indexes for table `musicadmin` -- ALTER TABLE `musicadmin` ADD PRIMARY KEY (`id`); -- -- Indexes for table `nobel` -- ALTER TABLE `nobel` ADD PRIMARY KEY (`id`); -- -- Indexes for table `office` -- ALTER TABLE `office` ADD PRIMARY KEY (`id`); -- -- Indexes for table `prospectus` -- ALTER TABLE `prospectus` ADD PRIMARY KEY (`id`); -- -- Indexes for table `regal` -- ALTER TABLE `regal` ADD PRIMARY KEY (`id`); -- -- Indexes for table `schoolawards` -- ALTER TABLE `schoolawards` ADD PRIMARY KEY (`id`); -- -- Indexes for table `scienceadmin` -- ALTER TABLE `scienceadmin` ADD PRIMARY KEY (`id`); -- -- Indexes for table `staffadmin` -- ALTER TABLE `staffadmin` ADD PRIMARY KEY (`id`); -- -- Indexes for table `support` -- ALTER TABLE `support` ADD PRIMARY KEY (`id`); -- -- Indexes for table `supportingstaff` -- ALTER TABLE `supportingstaff` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tblbooking` -- ALTER TABLE `tblbooking` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tblbrands` -- ALTER TABLE `tblbrands` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tblcontactusinfo` -- ALTER TABLE `tblcontactusinfo` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tblcontactusquery` -- ALTER TABLE `tblcontactusquery` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tblpages` -- ALTER TABLE `tblpages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tblsubscribers` -- ALTER TABLE `tblsubscribers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tblusers` -- ALTER TABLE `tblusers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tblvehicles` -- ALTER TABLE `tblvehicles` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tc` -- ALTER TABLE `tc` ADD PRIMARY KEY (`id`); -- -- Indexes for table `testimonial` -- ALTER TABLE `testimonial` ADD PRIMARY KEY (`id`); -- -- Indexes for table `timmer` -- ALTER TABLE `timmer` ADD PRIMARY KEY (`id`); -- -- Indexes for table `topperadmin` -- ALTER TABLE `topperadmin` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admin` -- ALTER TABLE `admin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `affiliation` -- ALTER TABLE `affiliation` MODIFY `id` int(200) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `blog` -- ALTER TABLE `blog` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `cafe` -- ALTER TABLE `cafe` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `calender` -- ALTER TABLE `calender` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `cbsedata` -- ALTER TABLE `cbsedata` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `digitaladmin` -- ALTER TABLE `digitaladmin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `dignity` -- ALTER TABLE `dignity` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `eco` -- ALTER TABLE `eco` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `enquery` -- ALTER TABLE `enquery` MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `faq` -- ALTER TABLE `faq` MODIFY `id` int(200) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `fees` -- ALTER TABLE `fees` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `gallery1` -- ALTER TABLE `gallery1` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24; -- -- AUTO_INCREMENT for table `hostel` -- ALTER TABLE `hostel` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `infra` -- ALTER TABLE `infra` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `liberty` -- ALTER TABLE `liberty` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `libraryadmin` -- ALTER TABLE `libraryadmin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `link` -- ALTER TABLE `link` MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `managing` -- ALTER TABLE `managing` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `mentor` -- ALTER TABLE `mentor` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `musicadmin` -- ALTER TABLE `musicadmin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `nobel` -- ALTER TABLE `nobel` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19; -- -- AUTO_INCREMENT for table `office` -- ALTER TABLE `office` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25; -- -- AUTO_INCREMENT for table `prospectus` -- ALTER TABLE `prospectus` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `regal` -- ALTER TABLE `regal` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25; -- -- AUTO_INCREMENT for table `schoolawards` -- ALTER TABLE `schoolawards` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `scienceadmin` -- ALTER TABLE `scienceadmin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `staffadmin` -- ALTER TABLE `staffadmin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `support` -- ALTER TABLE `support` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `supportingstaff` -- ALTER TABLE `supportingstaff` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tblbooking` -- ALTER TABLE `tblbooking` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tblbrands` -- ALTER TABLE `tblbrands` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tblcontactusinfo` -- ALTER TABLE `tblcontactusinfo` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tblcontactusquery` -- ALTER TABLE `tblcontactusquery` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tblpages` -- ALTER TABLE `tblpages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tblsubscribers` -- ALTER TABLE `tblsubscribers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tblusers` -- ALTER TABLE `tblusers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tblvehicles` -- ALTER TABLE `tblvehicles` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tc` -- ALTER TABLE `tc` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `testimonial` -- ALTER TABLE `testimonial` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `timmer` -- ALTER TABLE `timmer` MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `topperadmin` -- ALTER TABLE `topperadmin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; 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 */;