text: -- phpMyAdmin SQL Dump
  -- version 5.0.2
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1:3306
  -- Generation Time: May 03, 2021 at 07:14 PM
  -- Server version: 8.0.21
  -- PHP Version: 7.3.21
  
  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: `online_car_rental`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `admin`
  --
  
  DROP TABLE IF EXISTS `admin`;
  CREATE TABLE IF NOT EXISTS `admin` (
    `id` int NOT NULL AUTO_INCREMENT,
    `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,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `admin`
  --
  
  INSERT INTO `admin` (`id`, `UserName`, `Password`, `updationDate`) VALUES
  (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', '2017-07-05 11:02:08');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tblbooking`
  --
  
  DROP TABLE IF EXISTS `tblbooking`;
  CREATE TABLE IF NOT EXISTS `tblbooking` (
    `id` int NOT NULL AUTO_INCREMENT,
    `userEmail` varchar(100) DEFAULT NULL,
    `VehicleId` int DEFAULT NULL,
    `FromDate` varchar(20) DEFAULT NULL,
    `ToDate` varchar(20) DEFAULT NULL,
    `message` varchar(255) DEFAULT NULL,
    `Status` int DEFAULT NULL,
    `PostingDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tblbooking`
  --
  
  INSERT INTO `tblbooking` (`id`, `userEmail`, `VehicleId`, `FromDate`, `ToDate`, `message`, `Status`, `PostingDate`) VALUES
  (7, 'kr2@gmail.com', 9, '05-05-2021', '08-05-2021', 'Address:\r\nopp to forum Srujana Mall,\r\nKukatpally.', 1, '2021-05-03 19:09:24');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tblbrands`
  --
  
  DROP TABLE IF EXISTS `tblbrands`;
  CREATE TABLE IF NOT EXISTS `tblbrands` (
    `id` int NOT NULL AUTO_INCREMENT,
    `BrandName` varchar(120) NOT NULL,
    `CreationDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `UpdationDate` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tblbrands`
  --
  
  INSERT INTO `tblbrands` (`id`, `BrandName`, `CreationDate`, `UpdationDate`) VALUES
  (11, 'Tesla', '2021-05-03 16:39:06', NULL),
  (12, 'Volkswagen', '2021-05-03 16:39:26', NULL),
  (13, 'Tata', '2021-05-03 16:39:31', NULL),
  (14, 'BMW', '2021-05-03 16:39:37', NULL),
  (15, 'Morris Garages', '2021-05-03 16:40:01', NULL),
  (16, 'Porsche', '2021-05-03 16:40:34', NULL),
  (17, 'Mahindra Electric', '2021-05-03 16:41:23', NULL),
  (18, 'Hyundai', '2021-05-03 16:41:32', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tblcontactusinfo`
  --
  
  DROP TABLE IF EXISTS `tblcontactusinfo`;
  CREATE TABLE IF NOT EXISTS `tblcontactusinfo` (
    `id` int NOT NULL AUTO_INCREMENT,
    `Address` tinytext,
    `EmailId` varchar(255) DEFAULT NULL,
    `ContactNo` char(11) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tblcontactusinfo`
  --
  
  INSERT INTO `tblcontactusinfo` (`id`, `Address`, `EmailId`, `ContactNo`) VALUES
  (1, 'Chipp Inc,\r\nGuntur,\r\nAndhra Pradesh.																						', 'contact@chipp.com', '9876543210');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tblcontactusquery`
  --
  
  DROP TABLE IF EXISTS `tblcontactusquery`;
  CREATE TABLE IF NOT EXISTS `tblcontactusquery` (
    `id` int NOT NULL AUTO_INCREMENT,
    `name` varchar(100) DEFAULT NULL,
    `EmailId` varchar(120) DEFAULT NULL,
    `ContactNumber` char(11) DEFAULT NULL,
    `Message` longtext,
    `PostingDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `status` int DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tblpages`
  --
  
  DROP TABLE IF EXISTS `tblpages`;
  CREATE TABLE IF NOT EXISTS `tblpages` (
    `id` int NOT NULL AUTO_INCREMENT,
    `PageName` varchar(255) DEFAULT NULL,
    `type` varchar(255) NOT NULL DEFAULT '',
    `detail` longtext NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tblpages`
  --
  
  INSERT INTO `tblpages` (`id`, `PageName`, `type`, `detail`) VALUES
  (1, 'Terms and Conditions', 'terms', '<P align=justify><FONT size=2><STRONG><FONT color=#990000>(1) ACCEPTANCE OF TERMS</FONT><BR><BR></STRONG>Welcome to Yahoo! India. 1Yahoo Web Services India Private Limited Yahoo\", \"we\" or \"us\" as the case may be) provides the Service (defined below) to you, subject to the following Terms of Service (\"TOS\"), which may be updated by us from time to time without notice to you. You can review the most current version of the TOS at any time at: <A href=\"http://in.docs.yahoo.com/info/terms/\">http://in.docs.yahoo.com/info/terms/</A>. In addition, when using particular Yahoo services or third party services, you and Yahoo shall be subject to any posted guidelines or rules applicable to such services which may be posted from time to time. All such guidelines or rules, which maybe subject to change, are hereby incorporated by reference into the TOS. In most cases the guides and rules are specific to a particular part of the Service and will assist you in applying the TOS to that part, but to the extent of any inconsistency between the TOS and any guide or rule, the TOS will prevail. We may also offer other services from time to time that are governed by different Terms of Services, in which case the TOS do not apply to such other services if and to the extent expressly excluded by such different Terms of Services. Yahoo also may offer other services from time to time that are governed by different Terms of Services. These TOS do not apply to such other services that are governed by different Terms of Service. </FONT></P>\r\n<P align=justify><FONT size=2>Welcome to Yahoo! India. Yahoo Web Services India Private Limited Yahoo\", \"we\" or \"us\" as the case may be) provides the Service (defined below) to you, subject to the following Terms of Service (\"TOS\"), which may be updated by us from time to time without notice to you. You can review the most current version of the TOS at any time at: </FONT><A href=\"http://in.docs.yahoo.com/info/terms/\"><FONT size=2>http://in.docs.yahoo.com/info/terms/</FONT></A><FONT size=2>. In addition, when using particular Yahoo services or third party services, you and Yahoo shall be subject to any posted guidelines or rules applicable to such services which may be posted from time to time. All such guidelines or rules, which maybe subject to change, are hereby incorporated by reference into the TOS. In most cases the guides and rules are specific to a particular part of the Service and will assist you in applying the TOS to that part, but to the extent of any inconsistency between the TOS and any guide or rule, the TOS will prevail. We may also offer other services from time to time that are governed by different Terms of Services, in which case the TOS do not apply to such other services if and to the extent expressly excluded by such different Terms of Services. Yahoo also may offer other services from time to time that are governed by different Terms of Services. These TOS do not apply to such other services that are governed by different Terms of Service. </FONT></P>\r\n<P align=justify><FONT size=2>Welcome to Yahoo! India. Yahoo Web Services India Private Limited Yahoo\", \"we\" or \"us\" as the case may be) provides the Service (defined below) to you, subject to the following Terms of Service (\"TOS\"), which may be updated by us from time to time without notice to you. You can review the most current version of the TOS at any time at: </FONT><A href=\"http://in.docs.yahoo.com/info/terms/\"><FONT size=2>http://in.docs.yahoo.com/info/terms/</FONT></A><FONT size=2>. In addition, when using particular Yahoo services or third party services, you and Yahoo shall be subject to any posted guidelines or rules applicable to such services which may be posted from time to time. All such guidelines or rules, which maybe subject to change, are hereby incorporated by reference into the TOS. In most cases the guides and rules are specific to a particular part of the Service and will assist you in applying the TOS to that part, but to the extent of any inconsistency between the TOS and any guide or rule, the TOS will prevail. We may also offer other services from time to time that are governed by different Terms of Services, in which case the TOS do not apply to such other services if and to the extent expressly excluded by such different Terms of Services. Yahoo also may offer other services from time to time that are governed by different Terms of Services. These TOS do not apply to such other services that are governed by different Terms of Service. </FONT></P>'),
  (2, 'Privacy Policy', 'privacy', '<span style=\"color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; text-align: justify;\">At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Temporibus autem quibusdam et aut officiis debitis aut rerum necessitatibus saepe eveniet ut et voluptates repudiandae sint et molestiae non recusandae. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat</span>'),
  (3, 'About Us ', 'aboutus', '<span id=\"docs-internal-guid-04ac42c1-7fff-1f1e-ed19-1bbff8d6ebfe\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:0pt;\"><span style=\"font-size: 15pt; font-family: Lato, sans-serif; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\">Since our humble beginnings over two years ago, we have come a very long way in our journey. What started out as a simple cab service between two busy places in our native town has now turned into a very passionate mission. Since our initial growth towards car rental services, we decided to shift our mode of operations to an \'all green\' position, and so, we decided that we would only list electric vehicles for rent. Slowly, and together, we can contribute to a cleaner, greener, and a beautiful future.</span></p><div><span style=\"font-size: 15pt; font-family: Lato, sans-serif; color: rgb(0, 0, 0); background-color: transparent; font-weight: 700; font-variant-numeric: normal; font-variant-east-asian: normal; vertical-align: baseline; white-space: pre-wrap;\"><br></span></div></span>'),
  (11, 'FAQs', 'faqs', '<div style=\"text-align: justify;\"><span style=\"font-size: 1em; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif;\">Coming Soon</span></div>');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tblsubscribers`
  --
  
  DROP TABLE IF EXISTS `tblsubscribers`;
  CREATE TABLE IF NOT EXISTS `tblsubscribers` (
    `id` int NOT NULL AUTO_INCREMENT,
    `SubscriberEmail` varchar(120) DEFAULT NULL,
    `PostingDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbltestimonial`
  --
  
  DROP TABLE IF EXISTS `tbltestimonial`;
  CREATE TABLE IF NOT EXISTS `tbltestimonial` (
    `id` int NOT NULL AUTO_INCREMENT,
    `UserEmail` varchar(100) NOT NULL,
    `Testimonial` mediumtext NOT NULL,
    `PostingDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `status` int DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tbltestimonial`
  --
  
  INSERT INTO `tbltestimonial` (`id`, `UserEmail`, `Testimonial`, `PostingDate`, `status`) VALUES
  (5, 'apk@gmail.com', 'I am always spreading the good word about the fabulous service and simple price structure with no hidden costs that you offer and will continue to do so. Can’t wait to see you all again real soon and as soon as I can fly I will be booking cars for the group traveling.', '2021-05-03 17:46:44', 1),
  (9, 'incendero@gmail.com', 'We have booked with you numerous times and always recommend you to friends and family. We like your up-front all-inclusive, no surprise rates. Keep up the good work and see you again!', '2021-05-03 17:55:43', 1),
  (10, 'kr2@gmail.com', 'Excellent and prompt  customer service. A truly professional car rental company. Cars are in up-to-date condition. In case of emergency, the response from the team is quick, The availability of customer support service is 24x7. All payment, contract terms and transactions are transparent.', '2021-05-03 18:28:43', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tblusers`
  --
  
  DROP TABLE IF EXISTS `tblusers`;
  CREATE TABLE IF NOT EXISTS `tblusers` (
    `id` int NOT NULL AUTO_INCREMENT,
    `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 CURRENT_TIMESTAMP,
    `UpdationDate` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tblusers`
  --
  
  INSERT INTO `tblusers` (`id`, `FullName`, `EmailId`, `Password`, `ContactNo`, `dob`, `Address`, `City`, `Country`, `RegDate`, `UpdationDate`) VALUES
  (7, 'Incendero', 'incendero@gmail.com', 'c92a10ba6b39031c85fff38ac7625382', '9461626464', NULL, NULL, NULL, NULL, '2021-03-20 09:07:42', NULL),
  (8, 'Chipp', 'chipp@google.com', '8785a1f13d955c7f5f8bba68706c26c5', '9876543210', NULL, NULL, NULL, NULL, '2021-04-26 16:57:58', NULL),
  (9, 'Prabhu Avula', 'apk@gmail.com', '5f4dcc3b5aa765d61d8327deb882cf99', '9876543210', NULL, NULL, NULL, NULL, '2021-05-03 17:37:59', NULL),
  (12, 'Ruthvik Reddy', 'kr2@gmail.com', '6ab3d0526bb1d023ab7c4fee4fb684df', '9876543210', '', '', '', '', '2021-05-03 18:23:33', '2021-05-03 18:24:35');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tblvehicles`
  --
  
  DROP TABLE IF EXISTS `tblvehicles`;
  CREATE TABLE IF NOT EXISTS `tblvehicles` (
    `id` int NOT NULL AUTO_INCREMENT,
    `VehiclesTitle` varchar(150) DEFAULT NULL,
    `VehiclesBrand` int DEFAULT NULL,
    `VehiclesOverview` longtext,
    `PricePerDay` int DEFAULT NULL,
    `FuelType` varchar(100) DEFAULT NULL,
    `ModelYear` int DEFAULT NULL,
    `SeatingCapacity` int 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 DEFAULT NULL,
    `PowerDoorLocks` int DEFAULT NULL,
    `AntiLockBrakingSystem` int DEFAULT NULL,
    `BrakeAssist` int DEFAULT NULL,
    `PowerSteering` int DEFAULT NULL,
    `DriverAirbag` int DEFAULT NULL,
    `PassengerAirbag` int DEFAULT NULL,
    `PowerWindows` int DEFAULT NULL,
    `CDPlayer` int DEFAULT NULL,
    `CentralLocking` int DEFAULT NULL,
    `CrashSensor` int DEFAULT NULL,
    `LeatherSeats` int DEFAULT NULL,
    `RegDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `UpdationDate` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tblvehicles`
  --
  
  INSERT INTO `tblvehicles` (`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
  (9, 'Tesla Model S', 11, 'The 2020 Tesla Model S is one of the highest-rated vehicles in the luxury hybrid and electric car class because of its lightning-quick acceleration and long driving range.', 500, 'Electric', 2020, 5, '1.jpg', '2.jpg', '5.jpg', '3.jpg', '4.jpg', 1, 1, 1, 1, 1, 1, 1, 1, NULL, 1, 1, 1, '2021-05-03 16:57:10', '2021-05-03 17:15:31'),
  (10, 'Tesla Model 3', 11, 'The Tesla Model 3’s rapid acceleration and dynamic handling help it rank near the top of the luxury hybrid and electric car class.', 400, 'Electric', 2021, 5, '6.jpg', '7.jpg', '8.jpg', '9.jpg', '10.jpg', 1, 1, 1, 1, 1, 1, 1, 1, NULL, 1, 1, 1, '2021-05-03 17:01:19', '2021-05-03 17:15:39'),
  (11, 'Porsche Taycan', 16, 'The all-electric 2021 Porsche Taycan has blistering acceleration, lively handling, and a first-rate interior, but some overly complicated cabin controls prevent it from reaching the zenith of the luxury hybrid and electric car class.', 1000, 'Electric', 2021, 4, '11.jpg', '12.jpg', '13.jpg', '14.jpg', '15.jpg', 1, 1, 1, 1, 1, 1, 1, 1, NULL, 1, 1, 1, '2021-05-03 17:05:20', '2021-05-03 17:15:50'),
  (12, 'Tesla Model X', 11, 'The Tesla Model X ranks near the top of the luxury hybrid and electric SUV class thanks to its swift acceleration, buttoned-down handling, superb all-electric driving range, spacious cabin, and advanced features.', 350, 'Electric', 2020, 5, '16.jpg', '17.jpg', '18.jpg', '19.jpg', '20.jpg', 1, 1, 1, 1, 1, 1, 1, 1, NULL, 1, 1, 1, '2021-05-03 17:09:46', '2021-05-03 17:15:55'),
  (13, 'Tesla Model Y', 11, 'The all-electric 2021 Tesla Model Y has a long driving range and engaging performance, but some interior build quality issues hold it back among its competitors. The Model Y is unranked because it hasn’t been evaluated for predicted reliability.', 450, 'Electric', 2021, 5, '21.jpg', '24.jpg', '25.jpg', '22.jpg', '23.jpg', 1, 1, 1, 1, 1, 1, 1, 1, NULL, 1, 1, 1, '2021-05-03 17:13:42', '2021-05-03 17:16:02'),
  (14, 'Hyundai Kona EV', 18, 'Among hybrid and electric SUVs, the Hyundai Kona Electric offers great driving range and swift acceleration, but it also has confining rear seats and a small cargo hold. This EV does not have an overall score or ranking because it has not been fully crash tested or scored for reliability.', 100, 'Electric', 2021, 5, '26.jpg', '27.jpg', '28.jpg', '29.jpg', '30.jpg', 1, 1, 1, 1, 1, 1, 1, 1, NULL, 1, 1, 1, '2021-05-03 17:25:36', NULL);
  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 */;
  