-- phpMyAdmin SQL Dump
-- version 4.9.4
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jun 27, 2020 at 11:38 AM
-- Server version: 5.7.30-log
-- PHP Version: 7.3.6

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


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

--
-- Database: `heavenpi_heaven`
--

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

--
-- Table structure for table `submenu`
--

CREATE TABLE `submenu` (
  `productid` int(255) DEFAULT NULL,
  `productname` varchar(255) DEFAULT NULL,
  `short_product_name` varchar(255) DEFAULT NULL,
  `size` varchar(150) DEFAULT NULL,
  `price` double DEFAULT NULL,
  `cgst` double DEFAULT NULL,
  `sgst` double DEFAULT NULL,
  `tax` double DEFAULT NULL,
  `gstprice` double DEFAULT NULL,
  `category_id` int(255) DEFAULT NULL,
  `category` varchar(255) DEFAULT NULL,
  `srno` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `submenu`
--

INSERT INTO `submenu` (`productid`, `productname`, `short_product_name`, `size`, `price`, `cgst`, `sgst`, `tax`, `gstprice`, `category_id`, `category`, `srno`) VALUES
(1, 'Plain Cheese Pizza', 'Pln Cheese P', 'Small', 75, 1.786, 1.786, 3.571, 71.429, 1, 'Pizza', 1),
(2, 'Plain Cheese Pizza', 'Pln Cheese P', 'Medium', 120, 2.857, 2.857, 5.714, 114.286, 1, 'Pizza', 2),
(3, 'Plain Cheese Pizza', 'Pln Cheese P', 'Large', 180, 4.286, 4.286, 8.571, 171.429, 1, 'Pizza', 3),
(4, 'Veg Cheese Pizza', 'Cheese P', 'Small', 75, 1.786, 1.786, 3.571, 71.429, 1, 'Pizza', 4),
(5, 'Veg Cheese Pizza', 'Cheese P', 'Medium', 120, 2.857, 2.857, 5.714, 114.286, 1, 'Pizza', 5),
(6, 'Veg Cheese Pizza', 'Cheese P', 'Large', 180, 4.286, 4.286, 8.571, 171.429, 1, 'Pizza', 6),
(7, 'Veg Jain Cheese Pizza', 'Jain Cheese P', 'Small', 75, 1.786, 1.786, 3.571, 71.429, 1, 'Pizza', 7),
(8, 'Veg Jain Cheese Pizza', 'Jain Cheese P', 'Medium', 120, 2.857, 2.857, 5.714, 114.286, 1, 'Pizza', 8),
(9, 'Veg Jain Cheese Pizza', 'Jain Cheese P', 'Large', 180, 4.286, 4.286, 8.571, 171.429, 1, 'Pizza', 9),
(10, 'Chocolate Cheese Pizza', 'Chocolate Cheese P', 'Small', 75, 1.786, 1.786, 3.571, 71.429, 1, 'Pizza', 10),
(11, 'Chocolate Cheese Pizza', 'Chocolate Cheese P', 'Medium', 120, 2.857, 2.857, 5.714, 114.286, 1, 'Pizza', 11),
(12, 'Chocolate Cheese Pizza', 'Chocolate Cheese P', 'Large', 150, 3.572, 3.572, 7.143, 142.857, 1, 'Pizza', 12),
(13, 'Veg Corn Cheese Pizza', 'Corn Cheese P', 'Small', 90, 2.143, 2.143, 4.286, 85.714, 1, 'Pizza', 13),
(14, 'Veg Corn Cheese Pizza', 'Corn Cheese P', 'Medium', 130, 3.095, 3.095, 6.19, 123.81, 1, 'Pizza', 14),
(15, 'Veg Corn Cheese Pizza', 'Corn Cheese P', 'Large', 190, 4.524, 4.524, 9.048, 180.952, 1, 'Pizza', 15),
(16, 'Veg Baby Corn Cheese Pizza', 'Baby Corn Cheese P', 'Small', 90, 2.143, 2.143, 4.286, 85.714, 1, 'Pizza', 16),
(17, 'Veg Baby Corn Cheese Pizza', 'Baby Corn Cheese P', 'Medium', 145, 3.453, 3.453, 6.905, 138.095, 1, 'Pizza', 17),
(18, 'Veg Baby Corn Cheese Pizza', 'Baby Corn Cheese P', 'Large', 190, 4.524, 4.524, 9.048, 180.952, 1, 'Pizza', 18),
(19, 'Veg Mushroom Cheese Pizza', 'Mshroom Cheese P', 'Small', 100, 2.381, 2.381, 4.762, 95.238, 1, 'Pizza', 19),
(20, 'Veg Mushroom Cheese Pizza', 'Mshroom Cheese P', 'Medium', 150, 3.572, 3.572, 7.143, 142.857, 1, 'Pizza', 20),
(21, 'Veg Mushroom Cheese Pizza', 'Mshroom Cheese P', 'Large', 190, 4.524, 4.524, 9.048, 180.952, 1, 'Pizza', 21),
(22, 'Veg Paneer Cheese Pizza', 'Paneer Cheese P', 'Small', 105, 2.5, 2.5, 5, 100, 1, 'Pizza', 22),
(23, 'Veg Paneer Cheese Pizza', 'Paneer Cheese P', 'Medium', 155, 3.691, 3.691, 7.381, 147.619, 1, 'Pizza', 23),
(24, 'Veg Paneer Cheese Pizza', 'Paneer Cheese P', 'Large', 190, 4.524, 4.524, 9.048, 180.952, 1, 'Pizza', 24),
(25, 'Corn Delight Cheese Pizza', 'Corn Delight Cheese P', 'Small', 100, 2.381, 2.381, 4.762, 95.238, 1, 'Pizza', 25),
(26, 'Corn Delight Cheese Pizza', 'Corn Delight Cheese P', 'Medium', 150, 3.572, 3.572, 7.143, 142.857, 1, 'Pizza', 26),
(27, 'Corn Delight Cheese Pizza', 'Corn Delight Cheese P', 'Large', 190, 4.524, 4.524, 9.048, 180.952, 1, 'Pizza', 27),
(28, 'Veg Mix Loaded Pizza', 'Mix Loaded P', 'Small', 120, 2.857, 2.857, 5.714, 114.286, 1, 'Pizza', 28),
(29, 'Veg Mix Loaded Pizza', 'Mix Loaded P', 'Medium', 170, 4.048, 4.048, 8.095, 161.905, 1, 'Pizza', 29),
(30, 'Veg Mix Loaded Pizza', 'Mix Loaded P', 'Large', 210, 5, 5, 10, 200, 1, 'Pizza', 30),
(31, 'Veg Cheese Burst Pizza', 'Cheese Burst P', 'Small', 125, 2.976, 2.976, 5.952, 119.048, 1, 'Pizza', 31),
(32, 'Veg Cheese Burst Pizza', 'Cheese Burst P', 'Medium', 175, 4.167, 4.167, 8.333, 166.667, 1, 'Pizza', 32),
(33, 'Veg Cheese Burst Pizza', 'Cheese Burst P', 'Large', 215, 5.119, 5.119, 10.238, 204.762, 1, 'Pizza', 33),
(34, 'Veg Italian Cheese Pizza', 'Italian Cheese P', 'Small', 145, 3.453, 3.453, 6.905, 138.095, 1, 'Pizza', 34),
(35, 'Veg Italian Cheese Pizza', 'Italian Cheese P', 'Medium', 210, 5, 5, 10, 200, 1, 'Pizza', 35),
(36, 'Veg Italian Cheese Pizza', 'Italian Cheese P', 'Large', 255, 6.072, 6.072, 12.143, 242.857, 1, 'Pizza', 36),
(37, 'Veg Aloo Tikki Burger', 'Aloo Tikki B', 'Regular', 35, 0.834, 0.834, 1.667, 33.333, 2, 'Burger', 37),
(38, 'Veg Aloo Tikki Cheese Burger', ' Aloo Tikki Cheese B', 'Regular', 45, 1.072, 1.072, 2.143, 42.857, 2, 'Burger', 38),
(39, 'Veg Burger', 'Veg B', 'Regular', 55, 1.31, 1.31, 2.619, 52.381, 2, 'Burger', 39),
(40, 'Veg Cheese Burger', 'Cheese B', 'Regular', 65, 1.548, 1.548, 3.095, 61.905, 2, 'Burger', 40),
(41, 'Herb Chilli Burger', 'Herb Chilli B', 'Regular', 60, 1.429, 1.429, 2.857, 57.143, 2, 'Burger', 41),
(42, 'Herb Chilli Cheese Burger', 'Herb Chilli Cheese B', 'Regular', 70, 1.667, 1.667, 3.333, 66.667, 2, 'Burger', 42),
(43, 'Corn Spinach Burger', 'Corn Spinach Burger', 'Regular', 60, 1.429, 1.429, 2.857, 57.143, 2, 'Burger', 43),
(44, 'Corn Spinach Cheese Burger', 'Corn Spinach Cheese Burger', 'Regular', 70, 1.667, 1.667, 3.333, 66.667, 2, 'Burger', 44),
(45, 'Paneer Burger', 'Paneer B', 'Regular', 100, 2.381, 2.381, 4.762, 95.238, 2, 'Burger', 45),
(46, 'Paneer Cheese Burger', 'Paneer Cheese B', 'Regular', 110, 2.62, 2.62, 5.24, 104.76, 2, 'Burger', 46),
(47, 'French Fries', '', 'Regular', 45, 1.072, 1.072, 2.143, 42.857, 3, 'Fries', 47),
(48, 'Cheese French Fries', '', 'Regular', 65, 1.548, 1.548, 3.095, 61.905, 3, 'Fries', 48),
(49, 'Peri Peri Fries', '', 'Regular', 55, 1.31, 1.31, 2.619, 52.381, 3, 'Fries', 49),
(50, 'Peri Peri Cheese Fries', '', 'Regular', 75, 1.786, 1.786, 3.571, 71.429, 3, 'Fries', 50),
(51, 'Masala Fries', 'Masala F', 'Regular', 55, 1.31, 1.31, 2.619, 52.381, 3, 'Fries', 51),
(52, 'Masala Cheese Fries', 'Masala Cheese F', 'Regular', 75, 1.786, 1.786, 3.571, 71.429, 3, 'Fries', 52),
(53, 'Cheese Corn Nuggets (6 Pcs)', 'Cheese Corn N(6P)', 'Regular', 75, 1.786, 1.786, 3.571, 71.429, 4, 'Nuggets', 53),
(54, 'Cheese Fingers (6 Pcs)', 'Cheese F(6P)', 'Regular', 80, 1.905, 1.905, 3.81, 76.19, 4, 'Nuggets', 54),
(55, 'Chilli Garlic Bites (12 Pcs)', 'Chilli Garlic B(12P)', 'Regular', 65, 1.548, 1.548, 3.095, 61.905, 4, 'Nuggets', 55),
(56, 'Veg Tandoori Nuggets (6 Pcs)', 'Tandoori N(6P)', 'Regular', 65, 1.548, 1.548, 3.095, 61.905, 4, 'Nuggets', 56),
(57, 'Hot Coffee', 'Hot Coffee', 'Regular', 25, 0.595, 0.595, 1.19, 23.81, 5, 'Coffee', 57),
(58, 'Hot Chocolate', 'Hot Chocolate', 'Regular', 35, 0.834, 0.834, 1.667, 33.333, 5, 'Coffee', 58),
(59, 'Hot Bornvita', 'Hot Bornvita', 'Regular', 35, 0.834, 0.834, 1.667, 33.333, 5, 'Coffee', 59),
(60, 'Cold Coffee', 'Cold Coffee', 'Regular', 35, 0.834, 0.834, 1.667, 33.333, 5, 'Coffee', 60),
(61, 'Cold Chocolate Coffee', 'Chocolate Cold C', 'Regular', 40, 0.953, 0.953, 1.905, 38.095, 5, 'Coffee', 61),
(62, 'Cold Coffee with Ice-Cream', 'Cold C(ice-cream)', 'Regular', 60, 1.429, 1.429, 2.857, 57.143, 5, 'Coffee', 62),
(63, 'Cold Choco Coffee(Ice-Cream)', 'Cold Chocolate C(ice-cream)', 'Regular', 70, 1.667, 1.667, 3.333, 66.667, 5, 'Coffee', 63),
(64, 'KAD-B s', 'KAD-B s', 'Regular', 70, 1.667, 1.667, 3.333, 66.667, 5, 'Coffee', 64),
(65, 'Thik Cold Coffee', '	 Thik Cold C', 'Regular', 45, 1.072, 1.072, 2.143, 42.857, 5, 'Coffee', 65),
(66, 'Thik Chocolate Cold Coffee', 'Thik Chocolate Cold C', 'Regular', 49, 1.167, 1.167, 2.333, 46.667, 5, 'Coffee', 66),
(67, 'Chocolate Shake', '	 Chocolate Shake', 'Regular', 65, 1.548, 1.548, 3.095, 61.905, 6, 'Shakes', 67),
(68, 'Pineapple Shake', 'Pineapple Shake', 'Regular', 65, 1.548, 1.548, 3.095, 61.905, 6, 'Shakes', 68),
(69, 'Strawberry Shake', 'Strawberry Shake', 'Regular', 65, 1.548, 1.548, 3.095, 61.905, 6, 'Shakes', 69),
(70, 'Mango Shake', 'Mango Shake', 'Regular', 70, 1.667, 1.667, 3.333, 66.667, 6, 'Shakes', 70),
(71, 'Sitafal Shake', 'Sitafal Shake', 'Regular', 80, 1.905, 1.905, 3.81, 76.19, 6, 'Shakes', 71),
(72, 'Extra Cheese', 'Extra Cheese', 'Small', 40, 0.953, 0.953, 1.905, 38.095, 1, 'Pizza', 72),
(73, 'Extra Cheese', 'Extra Cheese', 'Medium', 70, 1.667, 1.667, 3.333, 66.667, 1, 'Pizza', 73),
(74, 'Extra Cheese', 'Extra Cheese', 'Large', 90, 2.143, 2.143, 4.286, 85.714, 1, 'Pizza', 74),
(75, 'Extra Cheese Slice', 'Extra Cheese Slice', 'Regular', 16, 0.381, 0.381, 0.762, 15.238, 2, 'Burger', 75),
(76, 'With Ice-Cream Extra', 'With Ice-Cream Extra', 'Regular', 30, 0.715, 0.715, 1.429, 28.571, 6, 'Shakes', 76),
(78, 'Mini Water Bottle', 'Mini Water Bottle', 'Regular', 10, 0.238, 0.238, 0.476, 9.524, 6, 'Shakes', 77),
(79, 'Water Bottle', 'Water Bottle', 'Regular', 20, 0.476, 0.476, 0.952, 19.048, 6, 'Shakes', 78),
(80, 'Corn Cheese Pizza (S) + Peri Peri Fries + Cold Chocolate Coffee', 'Corn Cheese Pizza (S) + Peri Peri Fries + Cold Coffee', 'Regular', 149, 3.548, 3.548, 7.095, 141.906, 7, 'Combo', 80),
(81, 'Corn Spinach Cheese Burger + Cold Chocolate Coffee', 'Corn Spinach Cheese Burger + Cold Chololate Coffee', 'Regular', 99, 2.355, 2.355, 4.71, 94.29, 7, 'Combo', 81),
(82, 'Thums Up', 'Thums Up', 'Regular', 30, 0.715, 0.715, 1.429, 28.571, 8, 'Cold Drinks', 82),
(83, 'Sprite', 'Sprite', 'Regular', 30, 0.715, 0.715, 1.429, 28.571, 8, 'Cold Drinks', 83),
(84, 'Fanta', 'Fanta', 'Regular', 30, 0.715, 0.715, 1.429, 28.571, 8, 'Cold Drinks', 84),
(85, 'Corn Cheese Pizza (S) + Peri Peri Cheese Fries + Cold Chocolate Coffee', 'Corn Cheese Pizza (S) + Peri Peri Cheese Fries + Cold Chocolate Coffee', 'Regular', 169, 4.024, 4.024, 8.048, 160.952, 10, 'Combo', 85);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `submenu`
--
ALTER TABLE `submenu`
  ADD PRIMARY KEY (`srno`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `submenu`
--
ALTER TABLE `submenu`
  MODIFY `srno` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=86;
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 */;
