uFL5VpPV

1--  
2 -- Table structure for table `brand`  
3 --  
4 CREATE TABLE IF NOT EXISTS `brand` (  
5  `brand_id` int(11) NOT NULL AUTO_INCREMENT,  
6  `brand_name` varchar(250) NOT NULL,  
7  PRIMARY KEY (`brand_id`)  
8 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;  
9 --  
10 -- Dumping data for table `brand`  
11 --  
12 INSERT INTO `brand` (`brand_id`, `brand_name`) VALUES  
13 (1, 'Samsung'),  
14 (2, 'Sony'),  
15 (3, 'Motorola'),  
16 (4, 'Xiaomi');  
17 -- --------------------------------------------------------  
18 --  
19 -- Table structure for table `product`  
20 --  
21 CREATE TABLE IF NOT EXISTS `product` (  
22  `product_id` int(11) NOT NULL AUTO_INCREMENT,  
23  `product_name` varchar(250) NOT NULL,  
24  `brand_id` int(11) NOT NULL,  
25  PRIMARY KEY (`product_id`)  
26 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;  
27 --  
28 -- Dumping data for table `product`  
29 --  
30 INSERT INTO `product` (`product_id`, `product_name`, `brand_id`) VALUES  
31 (1, 'Samsung Galaxy A9', 1),  
32 (2, 'Samsung Galaxy S7', 1),  
33 (3, 'Samsung Galaxy S6 edge', 1),  
34 (4, 'Xperia Z5 Premium', 2),  
35 (5, 'Xperia M5 Dual', 2),  
36 (6, 'Xperia C5 uplta', 2),  
37 (7, 'Moto G Turbo', 3),  
38 (8, 'Moto X Force', 3),  
39 (9, 'Redmi 3 Pro', 4),  
40 (10, 'Mi 5', 4);