TPccFGSD

1DROP DATABASE IF EXISTS `mag2010-4290`;
2CREATE DATABASE `mag2010-4290`;
3USE `mag2010-4290`;
4
5CREATE TABLE `cars` (
6`id` int(6) NOT NULL auto_increment,
7`marka` varchar(20) NOT NULL default '',
8PRIMARY KEY (`id`)
9) TYPE=MyISAM;
10
11INSERT INTO `cars` (`id`, `marka`) VALUES
12(1, 'Hyundai Getz'),
13(2, 'Hyundai Matrix'),
14(3, 'Shkoda Octavia'),
15(4, 'Kia Magentis'),
16(5, 'Suzuki Grand Vitara'),
17(6, 'Hyundai NF Sonata'),
18(7, 'Hyundai Grandeur'),
19(8, 'Hyundai Verna'),
20(9, 'Kia Spectra');
21
22CREATE TABLE `year` (
23`id` int(6) NOT NULL auto_increment,
24`year` varchar(20) NOT NULL default '',
25UNIQUE KEY `id` (`id`)
26) TYPE=MyISAM; 
27
28INSERT INTO `year` (`id`, `year`) VALUES
29(1, '2005'),
30(2, '2006'),
31(3, '2007'),
32(4, '2008'),
33(5, '2009');
34
35CREATE TABLE `ryn` (
36`cars_id` int(6) NOT NULL,
37`year_id` int(6) NOT NULL,
38`ryn` varchar(20) default NULL
39) TYPE=MyISAM;
40
41INSERT INTO `ryn` (`cars_id`, `year_id`, `ryn`) VALUES
42(1, 2, '72500'),
43(2, 1, '71195'),
44(3, 2, '85000'),
45(4, 5, '12000'),
46(5, 2, '52500'),
47(6, 4, '4165'),
48(7, 4, '31165'),
49(8, 4, '13400'),
50(9, 3, '75000');