-
Notifications
You must be signed in to change notification settings - Fork 1
/
ashopping.sql
242 lines (200 loc) · 10.2 KB
/
ashopping.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
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Feb 17, 2021 at 05:23 AM
-- Server version: 10.4.14-MariaDB
-- PHP Version: 7.2.33
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: `ashopping`
--
-- --------------------------------------------------------
--
-- Table structure for table `cart_items`
--
CREATE TABLE `cart_items` (
`cart_item_id` int(11) NOT NULL,
`order_id` int(11) NOT NULL,
`pid` int(11) NOT NULL,
`quantity` int(11) NOT NULL,
`purchase_price` int(11) NOT NULL,
`product_name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `cart_items`
--
INSERT INTO `cart_items` (`cart_item_id`, `order_id`, `pid`, `quantity`, `purchase_price`, `product_name`) VALUES
(1, 1, 1, 10, 30, 'Plain Creamy Cake'),
(2, 1, 10, 5, 100, 'Capsicum Pizza'),
(3, 1, 60, 1, 600, 'Mens Watch');
-- --------------------------------------------------------
--
-- Table structure for table `category`
--
CREATE TABLE `category` (
`cid` int(6) NOT NULL,
`cname` varchar(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`parent_id` int(6) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Dumping data for table `category`
--
INSERT INTO `category` (`cid`, `cname`, `parent_id`) VALUES
(1, 'Cakes and Pastries', 0),
(2, 'Pizzas', 0),
(3, 'Other Foods', 0),
(4, 'Selected GIFTS', 0),
(5, 'Egg', 1),
(6, 'Egg Free', 1),
(7, 'Veg', 2),
(8, 'Nonveg', 2),
(10, 'Clothes', 4),
(11, 'Accessories', 4),
(16, 'Shirts', 10),
(15, 'Jeans', 10);
-- --------------------------------------------------------
--
-- Table structure for table `customers`
--
CREATE TABLE `customers` (
`cust_id` int(11) NOT NULL,
`fullname` varchar(50) NOT NULL,
`email` varchar(50) NOT NULL,
`password` varchar(30) NOT NULL,
`phone` varchar(30) NOT NULL,
`address` varchar(200) NOT NULL,
`timestamp` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `customers`
--
INSERT INTO `customers` (`cust_id`, `fullname`, `email`, `password`, `phone`, `address`, `timestamp`) VALUES
(1, 'Nikhil Narayan', 'ipeg.solutions@gmail.com', 'password', '08620007775', 'D-1105, Koyla Vihar, VIP Road,\r\nNear Haldiram,', '1613535752');
-- --------------------------------------------------------
--
-- Table structure for table `orders`
--
CREATE TABLE `orders` (
`order_id` int(11) NOT NULL,
`cust_id` int(11) NOT NULL,
`shipping_fullname` varchar(50) NOT NULL,
`shipping_phone` varchar(30) NOT NULL,
`shipping_address` varchar(200) NOT NULL,
`payment_info` varchar(200) NOT NULL,
`timestamp` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `orders`
--
INSERT INTO `orders` (`order_id`, `cust_id`, `shipping_fullname`, `shipping_phone`, `shipping_address`, `payment_info`, `timestamp`) VALUES
(1, 1, 'Nikhil Narayan', '08620007775', 'D-1105, Koyla Vihar, VIP Road,\r\nNear Haldiram,', 'cod', '1613535752');
-- --------------------------------------------------------
--
-- Table structure for table `products`
--
CREATE TABLE `products` (
`id` int(11) NOT NULL,
`name` varchar(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`details` text COLLATE latin1_general_ci NOT NULL,
`image` varchar(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
`price` int(4) NOT NULL DEFAULT 0,
`cid` int(6) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Dumping data for table `products`
--
INSERT INTO `products` (`id`, `name`, `details`, `image`, `price`, `cid`) VALUES
(1, 'Plain Creamy Cake', 'This is a very good product of Monginis and also very healthy and testy.', 'products/1.jpg', 30, 5),
(2, 'Pineapple cakes', 'This is a very good product of Monginis and also very healthy and testy.', 'products/2.jpg', 45, 5),
(3, 'Strawberry cakes', 'This is a very good product of Monginis and also very healthy and testy.', 'products/3.jpg', 30, 5),
(4, 'Heart-Shaped Cake', 'This is a very good product of Monginis and also very healthy and testy.', 'products/4.jpg', 300, 5),
(5, 'Fruit cakes', 'This is a very good product of Monginis and also very healthy and testy.', 'products/5.jpg', 50, 5),
(8, 'Chocolate(egg free)', 'This is a very good product of Monginis and also very healthy and testy.', 'products/8.jpg', 42, 6),
(9, 'Vanilla(egg free)', 'This is a very good product of Monginis and also very healthy and testy.', 'products/9.jpg', 30, 6),
(10, 'Capsicum Pizza', 'Pizzas are of good quality.', 'products/10.jpg', 100, 7),
(11, 'Onion Pizza', 'Pizzas are of good quality.', 'products/11.jpg', 110, 7),
(12, 'Chicken Pizza', 'Pizzas are of good quality.', 'products/12.jpg', 120, 8),
(13, 'Fish Pizza', 'Pizzas are of good quality.', 'products/13.jpg', 115, 8),
(14, 'Egg Patties', 'Patties are soft and fresh.', 'products/14.jpg', 30, 3),
(15, 'Aloo Patties', 'Patties are soft and fresh.', 'products/15.jpg', 25, 3),
(17, 'Vanilla Ice Creams', 'Fresh and Yummy.', 'products/17.jpg', 25, 3),
(49, 'Popcorn', 'Crispy & Salty', 'products/6.jpg', 15, 3),
(19, 'Aloo Fries', 'Served Hot.', 'products/20.jpg', 190, 3),
(63, 'Red Flared Skirt', 'Increase your glam quotient by wearing this red coloured skirt from the house of Faballey. Made of knit, this skirt is comfortable to wear and skin friendly as well.', 'products/red_skirt.jpg', 630, 10),
(54, 'Black Geometric Print Dress ', 'If you believe in a classy and modish dressing style, then this black coloured dress from Alia Bhatt\'s exclusive collection for Jabong is meant for you. Fashioned from rayon, this dress will ensure a comfortable fit. Team this dress with high heels and a neckpiece for a stunning look.', 'products/black_dress.jpg', 540, 10),
(55, 'Pink Polyurethane (Pu) Handbag', 'Cute and trendy, this pink coloured handbag by Next will tempt you to buy it instantly. It is compact yet can store your important things with ease. Made from polyurethane (pu), it will convince you of its good quality in no time. Fetch a catchy look by just carrying this bag with a simple top and a pair of jeans.', 'products/pink_bag.jpg', 550, 11),
(56, 'Black Tee Shirt', ' Look like an absolute stunner as you make your way to the party wearing this navy blue T-shirt from MANGO. Made from viscose spandex, this T-shirt features a round neck and will be comfortable all day long. This T-shirt can be teamed up with a pair of sequined shorts and stilettos to complete your stylish look.', 'products/black_tee.jpg', 560, 10),
(57, 'Saree', 'Classy, sensuous and versatile are the perfect words to describe this brown coloured saree from Vishal. The chiffon fabric makes this 6.0 m saree easy to drape and carry all day long. Club it with golden danglers and heels to highlight your personality on any occasion.', 'products/saree.jpg', 570, 10),
(58, 'Watch', 'If you have it, flaunt it! If this is your mantra then hit the streets in style wearing this black coloured analog watch for women from the house of Custom. The casing adds more appeal to this timepiece that can be worn on a rainy day, all thanks to its water resistance upto 10 atm.', 'products/watch.jpg', 2222, 11),
(59, 'Blue Tee (Mens)', 'Fall in love with the soft texture of the fabric wearing this regular-fit T-shirt by United Colors of Benetton. Your skin will love the feel of this T-shirt as it is fashioned using the material that is famous for comfort – cotton. Live the moment wearing this T-shirt with casual trousers and flip-flops as you hit the street with best buds.', 'products/blue_tee.jpg', 590, 10),
(60, 'Mens Watch', 'Keep up with time wearing this black coloured analog watch from the house of Fossil. The stainless steel dial and leather strap make this watch for men quite high on quality. Designed with a difference, this watch will be a fantastic addition to your accessory collection.', 'products/mens_watch.jpg', 600, 11),
(61, 'Scarf', 'Charmingly gorgeous is what you’d be once you team up this multicoloured scarf with a sexy top and a pair of denims. While its modal adds to its appeal by making it soft to the touch, its attractive print accentuates its visual appeal. Furthermore, you can also wrap it in varied styles with different outfits and sport a new look every day.', 'products/scarf.jpg', 199, 10),
(62, 'Perfume', 'A refreshing fragrance that uplifts your mood and takes you to a blissful territory is here from Nike. The new gen women can now bask in the subtlety of the scent.\r\n\r\nLong Lasting Protection\r\n\r\nStart your day on a jovial note and stay fresh all day with Up or Down Eau de Toilette that gives you a long lasting protection.', 'products/perfume.jpg', 620, 11);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `cart_items`
--
ALTER TABLE `cart_items`
ADD PRIMARY KEY (`cart_item_id`);
--
-- Indexes for table `category`
--
ALTER TABLE `category`
ADD PRIMARY KEY (`cid`);
--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
ADD PRIMARY KEY (`cust_id`);
--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
ADD PRIMARY KEY (`order_id`);
--
-- Indexes for table `products`
--
ALTER TABLE `products`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `cart_items`
--
ALTER TABLE `cart_items`
MODIFY `cart_item_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
MODIFY `cid` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
MODIFY `cust_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
MODIFY `order_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=103;
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 */;