· 6 years ago · Nov 11, 2019, 06:40 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:35 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 `product`
29--
30
31DROP TABLE IF EXISTS `product`;
32CREATE TABLE IF NOT EXISTS `product` (
33 `id` int(11) NOT NULL AUTO_INCREMENT,
34 `cat_id` int(11) NOT NULL,
35 `name` varchar(100) NOT NULL,
36 `des` varchar(1000) NOT NULL,
37 `price` int(11) NOT NULL,
38 `stock` int(11) NOT NULL,
39 `brand` varchar(100) NOT NULL,
40 `image` varchar(1000) NOT NULL,
41 PRIMARY KEY (`id`),
42 KEY `cat_id` (`cat_id`)
43) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
44
45--
46-- Dumping data for table `product`
47--
48
49INSERT INTO `product` (`id`, `cat_id`, `name`, `des`, `price`, `stock`, `brand`, `image`) VALUES
50(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', ''),
51(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', ''),
52(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', '');
53
54--
55-- Constraints for dumped tables
56--
57
58--
59-- Constraints for table `product`
60--
61ALTER TABLE `product`
62 ADD CONSTRAINT `product_ibfk_1` FOREIGN KEY (`cat_id`) REFERENCES `category` (`id`);
63COMMIT;
64
65/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
66/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
67/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;