-
Notifications
You must be signed in to change notification settings - Fork 0
/
products.sql
86 lines (74 loc) · 7.54 KB
/
products.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
-- phpMyAdmin SQL Dump
-- version 4.6.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 10, 2018 at 10:11 AM
-- Server version: 5.7.14
-- PHP Version: 5.6.25
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `food`
--
-- --------------------------------------------------------
--
-- Table structure for table `products`
--
CREATE TABLE `products` (
`pid` int(10) NOT NULL,
`name` varchar(200) NOT NULL,
`image` varchar(50) NOT NULL,
`description` varchar(1000) NOT NULL,
`price` int(10) NOT NULL,
`category` varchar(100) NOT NULL,
`status` varchar(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `products`
--
INSERT INTO `products` (`pid`, `name`, `image`, `description`, `price`, `category`, `status`) VALUES
(1, 'Idli Sambhar', 'IdliSambhar.jpg', 'Idli are a type of savoury rice cake, popular as breakfast foods throughout India and neighbouring countries.he cakes are made by steaming a batter consisting of fermented black lentils (de-husked) and rice.', 80, 'Breakfast', 'Enable'),
(2, 'Idli Chilli fry', 'Idlifry.jpg', 'Idli fry-a quick snack made with idlis. In this recipe of idli fry sauted idlis with cumin, sesame and mustard which give them amazing taste and aroma.', 130, 'Breakfast', 'Enable'),
(3, 'Masala Dosa', 'masaladosa.jpg', 'The masala dosa is made by stuffing a dosa with a lightly cooked filling of potatoes, fried onions and spices. The dosa is wrapped around an onion and potato curry or masala.', 90, 'Breakfast', 'Enable'),
(4, 'Special Spring Dosa', 'springdosa.jpg', 'A tasty stuffing of crunchy veggies, boiled noodles and peppy sauces is the highlight of this delicious butter-cooked Spring dosa', 110, 'Breakfast', 'Enable'),
(5, 'Veg Grill Sandwich', 'veggrillsand.jpg', 'Veg Grill Sandwich with chutney and sauce', 95, 'Breakfast', 'Enable'),
(6, 'Veg Grilled Cheese Sandwich', 'cheesesand.jpg', 'Veg Grilled Cheese Sandwich recipe is also very healthy as it is loaded with vegetables and paneer.This is a sweet and spicy sandwich with filling of cabbage, carrot, onion, paneer/indian cottage cheese, mayonnaise and mozzarella cheese. ', 100, 'Breakfast', 'Enable'),
(7, 'Masala Uttapam', 'uttapam.jpg', 'Uttapam is traditionally made with toppings such as tomatoes, onion, chillies, capsicum and coriander', 80, 'Breakfast', 'Enable'),
(8, 'Aloo Paratha', 'alooparatha.jpg', ' Aloo parathas consist of unleavened dough stuffed with a mixture of mashed potato and spices, which is rolled out and cooked on a hot tawa with butter or ghee', 60, 'Breakfast', 'Enable'),
(9, 'Tomato Soup', 'tomatosoup.jpg', 'smooth in texture,include chunks (or small pieces) of tomato, cream and vegetable stock. Popular toppings for tomato soup include sour cream or croutons.', 80, 'Soups', 'Enable'),
(10, 'Vegetable Manchow Soup', 'VegetableManchowSoup.jpg', 'Vegetable Manchow Soup is a spicy, hot and sour Indo-Chinese soup loaded with crunchy vegetables flavored with soy sauce and vinegar and thickened with a cornstarch mixture. The highlight of this delightful soup is the garnish of fried noodles! ', 90, 'Soups', 'Enable'),
(11, 'Vegetable Noodles Soup', 'VegetableNoodlesSoup.jpg', 'Vegetable Noodle Soup is full of healthy veggies, protein packed with gluten free noodles.', 85, 'Soups', 'Enable'),
(12, 'Chicken Noodle Soup', 'chickennoodlesoup.jpg', 'Brimming with chopped vegetables, cubed chicken, and egg noodles, and seasoned with fresh parsley, pepper, bay leaf and chopped garlic.', 90, 'Soups', 'Enable'),
(13, 'Veg Spring Roll', 'vegspringroll.jpg', 'Spring rolls are a large variety of filled, rolled appetizers,spring rolls are savoury rolls with cabbage and other vegetable fillings inside a thinly wrapped cylindrical pastry.', 175, 'Starter', 'Enable'),
(14, 'Paneer Tikka', 'PANEERTIKKA.jpg', 'It is made by marinating paneer in special type of marinade made from thick curd, tandoori masala powder and many other spices', 250, 'Starter', 'Enable'),
(15, 'Cheese Corn Balls', 'cheesecornballs.jpg', 'Cheese Corn Balls crecipe is a crunchy yet soft-centered deep-fried dish with soft corn kernels and creamy melted cheese.', 250, 'Starter', 'Enable'),
(16, 'Chicken Sholey Kabab', 'chickentikka.jpg', 'Chicken Sholay Kebab is made with spicy and flavorful chicken kebab topped by fluffy egg omelet. This dish is little spicy and it is served best on sizzling plate', 375, 'Starter', 'Enable'),
(17, 'Chiken Crispy', 'chickencrispy.jpg', 'The chicken is fried in such a way that the skin is extremely crunchy, but the white meat is relatively soft and served with sauce.', 350, 'Starter', 'Enable'),
(18, 'Chicken Reshmi Kabab', 'ChickenReshmiKabab.jpg', 'Chicken Reshmi Kabab is made with Pieces of Boneless Chicken Breast, marinated in juicy mixture of Curd, Cream, Cashew nuts and Spices and then Grilled in Oven. It is one of the most popular Indian Kabab dish.', 350, 'Starter', 'Enable'),
(19, 'Prawns Koliwada', 'koliwadaprawn.jpg', 'Prawn Koliwada is a spicy, deep fried prawns ', 210, 'Starter', 'Enable'),
(20, 'Fish fingers', 'FishFingersTartarSauce.jpg', 'Fish fingers or fish sticks are a processed food made using a whitefish, such as cod, haddock or pollock, which has been battered or breaded served with tarter sauce. ', 500, 'Starter', 'Enable'),
(21, 'Veg Hakka Nooddles', 'hakkanoddles.jpg', 'vegetable hakka noodles an indo chinese preparation with hakka noodles and mix vegetables', 180, 'Main Course', 'Enable'),
(22, 'Paneer Veg Biryani', 'VegBiryaniPaneer.jpg', 'Vegetable and Paneer Biryani A classic Indian one pot meal that is full of flavors and aromas from whole spices, garam masala and the long grain basmati rice.', 180, 'Main Course', 'Enable'),
(23, 'Chiken Tikka Biryani', 'chikentikkabiryani.jpg', 'Chicken Tikka Biryani Recipe is the famous delicacy of Indian Cuisine. Here Boneless Chicken Tikka is cooked in Gravy and then mixed with Basmati Rice.', 300, 'Main Course', 'Enable'),
(24, 'Rasmalai', 'Rasmalai.jpg', 'Ras malai consists of sugary white cream, or yellow-coloured (flattened) balls of chhana soaked in malai (clotted cream) flavoured with cardamom', 250, 'Desserts', 'Enable'),
(25, 'Rose Falooda', 'rosefaluda.jpg', 'Falooda is a cold dessert popular in the Indian subcontinent. Traditionally it is made from mixing rose syrup, vermicelli, sweet basil (sabza/takmaria) seeds, and pieces of jelly with milk, often topped off with a scoop of ice cream. ', 150, 'Desserts', 'Enable'),
(26, 'Cheese Pizza', 'pizza.jpg', 'Extra cheese pizza with a thick and puffy pizza crust.', 250, 'Main Course', 'Enable'),
(27, 'Skillet Chocolate Chip Cookie', 'SkilletChocolateChipCookie.JPG', 'Chocolate Chip Skillet Cookie the Pizzokie is a warm, ooey, gooey browned butter chocolate chip cookie topped with vanilla bean ice cream.', 250, 'Specials', 'Enable'),
(28, 'Chocolate gateau', 'choco.jpg', 'Chocolate gateau is a cake flavored with melted chocolate, cocoa powder.', 250, 'Desserts', 'Enable'),
(29, 'Malai Kulfi', 'malaikulfi.jpg', 'Traditional Malai Kulfi stands out with an extra rich and intense flavour and creaminess', 200, 'Desserts', 'Enable');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `products`
--
ALTER TABLE `products`
ADD PRIMARY KEY (`pid`);
/*!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 */;