· 6 years ago · Nov 11, 2019, 06:44 AM
1-- phpMyAdmin SQL Dump
2-- version 4.8.5
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1:3306
6-- Generation Time: Nov 11, 2019 at 06:40 AM
7-- Server version: 5.7.26
8-- PHP Version: 7.2.18
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `store`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `category`
29--
30
31DROP TABLE IF EXISTS `category`;
32CREATE TABLE IF NOT EXISTS `category` (
33 `id` int(11) NOT NULL AUTO_INCREMENT,
34 `main` varchar(20) NOT NULL,
35 `sub` varchar(20) NOT NULL,
36 PRIMARY KEY (`id`)
37) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
38
39--
40-- Dumping data for table `category`
41--
42
43INSERT INTO `category` (`id`, `main`, `sub`) VALUES
44(1, 'electronics', 'laptop'),
45(2, 'electronics', 'mobile'),
46(3, 'electronics', 'camera'),
47(4, 'electronics', 'storage'),
48(5, 'electronics', 'watches'),
49(6, 'appliances', 'washing machine'),
50(7, 'appliances', 'refrigerator'),
51(8, 'appliance-- phpMyAdmin SQL Dump
52-- version 4.8.5
53-- https://www.phpmyadmin.net/
54--
55-- Host: 127.0.0.1:3306
56-- Generation Time: Nov 11, 2019 at 06:40 AM
57-- Server version: 5.7.26
58-- PHP Version: 7.2.18
59
60SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
61SET AUTOCOMMIT = 0;
62START TRANSACTION;
63SET time_zone = "+00:00";
64
65
66/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
67/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
68/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
69/*!40101 SET NAMES utf8mb4 */;
70
71--
72-- Database: `store`
73--
74
75-- --------------------------------------------------------
76
77--
78-- Table structure for table `category`
79--
80
81DROP TABLE IF EXISTS `category`;
82CREATE TABLE IF NOT EXISTS `category` (
83 `id` int(11) NOT NULL AUTO_INCREMENT,
84 `main` varchar(20) NOT NULL,
85 `sub` varchar(20) NOT NULL,
86 PRIMARY KEY (`id`)
87) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
88
89--
90-- Dumping data for table `category`
91--
92
93INSERT INTO `category` (`id`, `main`, `sub`) VALUES
94(1, 'electronics', 'laptop'),
95(2, 'electronics', 'mobile'),
96(3, 'electronics', 'camera'),
97(4, 'electronics', 'storage'),
98(5, 'electronics', 'watches'),
99(6, 'appliances', 'washing machine'),
100(7, 'appliances', 'refrigerator'),
101(8, 'appliances', 'air conditioners'),
102(9, 'appliances', 'coolers'),
103(10, 'appliances', 'kitchen'),
104(11, 'books', 'romance'),
105(12, 'books', 'sci-fi & fantasy'),
106(13, 'books', 'textbooks'),
107(14, 'books', 'crime & thriller'),
108(15, 'books', 'children'),
109(16, 'fashion', 'clothing'),
110(17, 'fashion', 'footwear'),
111(18, 'fashion', 'backpacks'),
112(19, 'fashion', 'sunglasses'),
113(20, 'baby', 'diapers'),
114(21, 'baby', 'natural care');
115
116-- --------------------------------------------------------
117
118--
119-- Table structure for table `product`
120--
121
122DROP TABLE IF EXISTS `product`;
123CREATE TABLE IF NOT EXISTS `product` (
124 `id` int(11) NOT NULL AUTO_INCREMENT,
125 `cat_id` int(11) NOT NULL,
126 `name` varchar(100) NOT NULL,
127 `des` varchar(1000) NOT NULL,
128 `price` int(11) NOT NULL,
129 `stock` int(11) NOT NULL,
130 `brand` varchar(100) NOT NULL,
131 `image` varchar(1000) NOT NULL,
132 PRIMARY KEY (`id`),
133 KEY `cat_id` (`cat_id`)
134) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
135
136--
137-- Dumping data for table `product`
138--
139
140INSERT INTO `product` (`id`, `cat_id`, `name`, `des`, `price`, `stock`, `brand`, `image`) VALUES
141(1, 1, 'Acer Aspire 3 Thin A315-54', 'Enjoy Premium touch and feel experience with the lastest Aspire 3 Thin series of Notebooks. The notebook features a 15.6 inch display, 4GB of DDR4 memory and a 256 GB fast SSD for superior performance at all conditions. A dream notebook at an attractive price point has always been Aspire 3\'s biggest USP.', 28990, 2, 'Acer', ''),
142(2, 1, 'Acer Nitro 5 AN515-52', 'Enjoy premium looks without the premium price with the Acer NITRO Gaming notebook (model AN515-52), which features a beautiful exterior. It features a 15.6-inch high-def. display giving you ample space for opening multiple windows and digital entertainment. It\'s powered by Intel i5 8300H Enjoy smooth multitasking and excellent performance with 8GB installed RAM and 1TB HDD + 256GB SSD with NVIDIA GTX 1050Ti (4 GB Dedicated GDDR5).', 32890, 3, 'Acer', ''),
143(3, 1, 'Lenovo Ideapad 330 7th gen Intel Core i3', 'Sometimes it’s best to keep things simple. Stacked with premium Intel processing and discrete graphics options, the Idea Pad 330 is as powerful as it is easy to use. Available in a range of sophisticated colors, it’s safe, durable and ready for today’s tasks - and tomorrow’s. A laptop isn’t just a piece of electronics - it’s also an investment. That’s why we designed the Idea Pad 330 with a special protective finish to guard against wear and tear, as well as rubber detailing on the bottom to maximize ventilation and extend component life. You’ll experience lightning-fast responsiveness and reliable performance. Store thousands of videos, photos and files in your laptop locally. We are committed to providing an uncluttered desktop and a safer PC experience out of the box.', 29900, 3, 'Lenovo', ''),
144(4, 1, 'Lenovo V145-15AST', 'Meet the V145 15 inch laptop, designed to make your everyday business better. Improve productivity and efficiency with its robust AMD processor and graphics, keep your data safe with professional-level encryption, and give your employees the comfort of its ergonomic features—wrapped up in a chassis with a sharp, clean, professional look.The V145’s productivity, security, and reliability are a gift to your IT department. Impressive AMD performance and multiple ports will satisfy your employees, reducing complaints to IT.', 35890, 5, 'Lenovo', '');
145
146--
147-- Constraints for dumped tables
148--
149
150--
151-- Constraints for table `product`
152--
153ALTER TABLE `product`
154 ADD CONSTRAINT `product_ibfk_1` FOREIGN KEY (`cat_id`) REFERENCES `category` (`id`);
155COMMIT;
156
157/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
158/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
159/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
160s', 'air conditioners'),
161(9, 'appliances', 'coolers'),
162(10, 'appliances', 'kitchen'),
163(11, 'books', 'romance'),
164(12, 'books', 'sci-fi & fantasy'),
165(13, 'books', 'textbooks'),
166(14, 'books', 'crime & thriller'),
167(15, 'books', 'children'),
168(16, 'fashion', 'clothing'),
169(17, 'fashion', 'footwear'),
170(18, 'fashion', 'backpacks'),
171(19, 'fashion', 'sunglasses'),
172(20, 'baby', 'diapers'),
173(21, 'baby', 'natural care');
174
175-- --------------------------------------------------------
176
177--
178-- Table structure for table `product`
179--
180
181DROP TABLE IF EXISTS `product`;
182CREATE TABLE IF NOT EXISTS `product` (
183 `id` int(11) NOT NULL AUTO_INCREMENT,
184 `cat_id` int(11) NOT NULL,
185 `name` varchar(100) NOT NULL,
186 `des` varchar(1000) NOT NULL,
187 `price` int(11) NOT NULL,
188 `stock` int(11) NOT NULL,
189 `brand` varchar(100) NOT NULL,
190 `image` varchar(1000) NOT NULL,
191 PRIMARY KEY (`id`),
192 KEY `cat_id` (`cat_id`)
193) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
194
195--
196-- Dumping data for table `product`
197--
198
199INSERT INTO `product` (`id`, `cat_id`, `name`, `des`, `price`, `stock`, `brand`, `image`) VALUES
200(1, 1, 'Acer Aspire 3 Thin A315-54', 'Enjoy Premium touch and feel experience with the lastest Aspire 3 Thin series of Notebooks. The notebook features a 15.6 inch display, 4GB of DDR4 memory and a 256 GB fast SSD for superior performance at all conditions. A dream notebook at an attractive price point has always been Aspire 3\'s biggest USP.', 28990, 2, 'Acer', ''),
201(2, 1, 'Acer Nitro 5 AN515-52', 'Enjoy premium looks without the premium price with the Acer NITRO Gaming notebook (model AN515-52), which features a beautiful exterior. It features a 15.6-inch high-def. display giving you ample space for opening multiple windows and digital entertainment. It\'s powered by Intel i5 8300H Enjoy smooth multitasking and excellent performance with 8GB installed RAM and 1TB HDD + 256GB SSD with NVIDIA GTX 1050Ti (4 GB Dedicated GDDR5).', 32890, 3, 'Acer', ''),
202(3, 1, 'Lenovo Ideapad 330 7th gen Intel Core i3', 'Sometimes it’s best to keep things simple. Stacked with premium Intel processing and discrete graphics options, the Idea Pad 330 is as powerful as it is easy to use. Available in a range of sophisticated colors, it’s safe, durable and ready for today’s tasks - and tomorrow’s. A laptop isn’t just a piece of electronics - it’s also an investment. That’s why we designed the Idea Pad 330 with a special protective finish to guard against wear and tear, as well as rubber detailing on the bottom to maximize ventilation and extend component life. You’ll experience lightning-fast responsiveness and reliable performance. Store thousands of videos, photos and files in your laptop locally. We are committed to providing an uncluttered desktop and a safer PC experience out of the box.', 29900, 3, 'Lenovo', ''),
203(4, 1, 'Lenovo V145-15AST', 'Meet the V145 15 inch laptop, designed to make your everyday business better. Improve productivity and efficiency with its robust AMD processor and graphics, keep your data safe with professional-level encryption, and give your employees the comfort of its ergonomic features—wrapped up in a chassis with a sharp, clean, professional look.The V145’s productivity, security, and reliability are a gift to your IT department. Impressive AMD performance and multiple ports will satisfy your employees, reducing complaints to IT.', 35890, 5, 'Lenovo', '');
204
205--
206-- Constraints for dumped tables
207--
208
209--
210-- Constraints for table `product`
211--
212ALTER TABLE `product`
213 ADD CONSTRAINT `product_ibfk_1` FOREIGN KEY (`cat_id`) REFERENCES `category` (`id`);
214COMMIT;
215
216/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
217/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
218/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;