· 8 years ago · Apr 18, 2018, 11:56 AM
1-- phpMyAdmin SQL Dump
2-- version 3.4.3.2
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generato il: Gen 30, 2018 alle 11:35
7-- Versione del server: 5.5.15
8-- Versione PHP: 5.3.8
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `formula1`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struttura della tabella `circuito`
27--
28
29CREATE TABLE IF NOT EXISTS `circuito` (
30 `idCircuito` int(11) NOT NULL AUTO_INCREMENT,
31 `denominazione` text NOT NULL,
32 `indirizzo` text,
33 `citta` text NOT NULL,
34 `lunghezza` int(11) DEFAULT NULL,
35 `giri` int(11) DEFAULT NULL,
36 PRIMARY KEY (`idCircuito`)
37) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;
38
39--
40-- Dump dei dati per la tabella `circuito`
41--
42
43INSERT INTO `circuito` (`idCircuito`, `denominazione`, `indirizzo`, `citta`, `lunghezza`, `giri`) VALUES
44(1, 'GP Australia', 'ALBERT PARK', 'Melbourne', 5303, 58),
45(2, 'GP Cina', 'SHANGHAI INTERNATIONAL CIRCUIT', 'Shanghai', 5451, 56),
46(3, 'GP Bahrain', 'BAHRAIN INTERNATIONAL CIRCUIT', 'Sakhir', 5412, 57),
47(4, 'GP Russia', 'SOCHI AUTODROM', 'Sochi', 5848, 52),
48(5, 'GP Spagna', 'CIRCUIT DE CATALUNYA', 'Barcellona', 4655, 66),
49(6, 'GP Monaco', 'CIRCUIT DE MONACO', 'Monaco', 3340, 78),
50(7, 'GP Canada', 'CIRCUIT GILLES VILLENEUVE', 'Montréal', 4361, 70),
51(8, 'GP Azerbaijan', 'BAKU CITY CIRCUIT', 'Baku', 6003, 51),
52(9, 'GP Austria', 'RED BULL RING', 'Spielberg', 4326, 71),
53(10, 'GP Gran Bretagna', 'SILVERSTONE CIRCUIT', 'Towcester', 5891, 52),
54(11, 'GP Ungheria', 'HUNGARORING', 'Mogyoród - Budapest', 4381, 70),
55(12, 'GP Belgio', 'CIRCUIT DE SPA FRANCORCHAMPS', 'Stavelot', 7004, 44),
56(13, 'GP Italia', 'AUTODROMO NAZIONALE DI MONZA', 'Monza', 5793, 53),
57(14, 'GP Singapore', 'SINGAPORE STREET CIRCUIT', 'Marina Bay - Singapore', 5065, 61),
58(15, 'GP Malesia', 'SEPANG INTERNATIONAL CIRCUIT', 'Sepang', 5543, 56),
59(16, 'GP Giappone', 'SUZUKA INTERNATIONAL RACING COURSE', 'Inoucho - Suzuka', 5807, 53),
60(17, 'GP Stati Uniti', 'CIRCUIT OF THE AMERICAS', 'Austin - Texas', 5513, 56),
61(18, 'GP Messico', 'AUTODROMO HERMANOS RODRIGUEZ', 'Granjas México - Città del Mesico', 4421, 71),
62(19, 'GP Brasile', 'AUTODROMO CARLOS PACE', 'Interlagos - San Paolo', 4309, 71),
63(20, 'GP Emirati Arabi Uniti', 'YAS MARINA CIRCUIT', 'AbuDhabi', 5554, 55);
64
65-- --------------------------------------------------------
66
67--
68-- Struttura della tabella `motore`
69--
70
71CREATE TABLE IF NOT EXISTS `motore` (
72 `idMotore` int(11) NOT NULL AUTO_INCREMENT,
73 `nome` text NOT NULL,
74 `modello` text NOT NULL,
75 `cilindrata` int(11) DEFAULT NULL,
76 `cavalli` int(11) DEFAULT NULL,
77 PRIMARY KEY (`idMotore`)
78) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
79
80--
81-- Dump dei dati per la tabella `motore`
82--
83
84INSERT INTO `motore` (`idMotore`, `nome`, `modello`, `cilindrata`, `cavalli`) VALUES
85(1, 'Ferrari', '2017', 1600, 1000),
86(2, 'Mercedes', '2017', 1600, 1000),
87(3, 'Renault', '2017', 1600, 1000),
88(4, 'Honda', '2017', 1600, 1000);
89
90-- --------------------------------------------------------
91
92--
93-- Struttura della tabella `pilota`
94--
95
96CREATE TABLE IF NOT EXISTS `pilota` (
97 `idPilota` int(11) NOT NULL AUTO_INCREMENT,
98 `nome` text NOT NULL,
99 `cognome` text NOT NULL,
100 `numero` int(5) NOT NULL,
101 `idTeam` int(10) unsigned NOT NULL,
102 `nazione` text NOT NULL,
103 PRIMARY KEY (`idPilota`),
104 KEY `idTeam` (`idTeam`)
105) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;
106
107--
108-- Dump dei dati per la tabella `pilota`
109--
110
111INSERT INTO `pilota` (`idPilota`, `nome`, `cognome`, `numero`, `idTeam`, `nazione`) VALUES
112(1, 'Lewis', 'Hamilton', 1, 1, 'ING'),
113(2, 'Valtteri', 'Bottas', 77, 1, 'FIN'),
114(3, 'Sebastian', 'Vettel', 5, 2, 'GER'),
115(4, 'Kimi', 'Raikkonen', 7, 2, 'FIN'),
116(5, 'Daniel', 'Ricciardo', 3, 3, 'AUS'),
117(6, 'Max', 'Verstappen', 33, 3, ''),
118(7, 'Fernando', 'Alonso', 14, 5, 'SPA'),
119(8, 'Stoffel', 'Vandoorne', 2, 5, ''),
120(9, 'Sergio', 'Perez', 11, 4, 'MEX'),
121(10, 'Esteban', 'Ocon', 31, 4, 'FRA'),
122(11, 'Daniil', 'Kvyat', 26, 6, 'RUS'),
123(12, 'Carlos', 'Sainz', 55, 6, 'SPA'),
124(13, 'Felipe', 'Massa', 19, 7, 'BRA'),
125(14, 'Lance', 'Stroll', 18, 7, 'CAN'),
126(15, 'Romain', 'Grosjean', 8, 8, 'FRA'),
127(16, 'Kevin', 'Magnussen', 20, 8, 'DAN'),
128(17, 'Nico', 'Hülkenberg', 27, 9, 'GER'),
129(18, 'Jolyon', 'Palmer', 30, 9, 'ING'),
130(19, 'Marcus', 'Ericsson', 9, 10, 'SVE'),
131(20, 'Pascal', 'Wehrlein', 94, 10, 'GER');
132
133-- --------------------------------------------------------
134
135--
136-- Struttura della tabella `risultato`
137--
138
139CREATE TABLE IF NOT EXISTS `risultato` (
140 `idRisultato` int(11) NOT NULL AUTO_INCREMENT,
141 `posizione` int(11) NOT NULL,
142 `idPilota` int(11) NOT NULL,
143 `idCircuito` int(11) NOT NULL,
144 PRIMARY KEY (`idRisultato`),
145 KEY `idPilota` (`idPilota`),
146 KEY `idCircuito` (`idCircuito`)
147) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=201 ;
148
149--
150-- Dump dei dati per la tabella `risultato`
151--
152
153INSERT INTO `risultato` (`idRisultato`, `posizione`, `idPilota`, `idCircuito`) VALUES
154(1, 1, 3, 1),
155(2, 2, 1, 1),
156(3, 3, 2, 1),
157(4, 4, 4, 1),
158(5, 5, 6, 1),
159(6, 6, 13, 1),
160(7, 7, 9, 1),
161(8, 8, 12, 1),
162(9, 9, 11, 1),
163(10, 10, 10, 1),
164(11, 1, 1, 2),
165(12, 2, 3, 2),
166(13, 3, 6, 2),
167(14, 4, 5, 2),
168(15, 5, 4, 2),
169(16, 6, 2, 2),
170(17, 7, 12, 2),
171(18, 8, 16, 2),
172(19, 9, 9, 2),
173(20, 10, 10, 2),
174(21, 1, 3, 3),
175(22, 2, 1, 3),
176(23, 3, 2, 3),
177(24, 4, 4, 3),
178(25, 5, 5, 3),
179(26, 6, 13, 3),
180(27, 7, 9, 3),
181(28, 8, 15, 3),
182(29, 9, 17, 3),
183(30, 10, 10, 3),
184(31, 1, 2, 4),
185(32, 2, 3, 4),
186(33, 3, 4, 4),
187(34, 4, 1, 4),
188(35, 5, 6, 4),
189(36, 6, 9, 4),
190(37, 7, 10, 4),
191(38, 8, 17, 4),
192(39, 9, 13, 4),
193(40, 10, 12, 4),
194(41, 1, 1, 5),
195(42, 2, 3, 5),
196(43, 3, 5, 5),
197(44, 4, 9, 5),
198(45, 5, 10, 5),
199(46, 6, 17, 5),
200(47, 7, 12, 5),
201(48, 8, 20, 5),
202(49, 9, 11, 5),
203(50, 10, 15, 5),
204(51, 1, 3, 6),
205(52, 2, 4, 6),
206(53, 3, 5, 6),
207(54, 4, 2, 6),
208(55, 5, 6, 6),
209(56, 6, 12, 6),
210(57, 7, 1, 6),
211(58, 8, 15, 6),
212(59, 9, 13, 6),
213(60, 10, 16, 6),
214(61, 1, 1, 7),
215(62, 2, 2, 7),
216(63, 3, 5, 7),
217(64, 4, 3, 7),
218(65, 5, 9, 7),
219(66, 6, 10, 7),
220(67, 7, 4, 7),
221(68, 8, 17, 7),
222(69, 9, 14, 7),
223(70, 10, 15, 7),
224(71, 1, 5, 8),
225(72, 2, 2, 8),
226(73, 3, 14, 8),
227(74, 4, 3, 8),
228(75, 5, 1, 8),
229(76, 6, 10, 8),
230(77, 7, 16, 8),
231(78, 8, 12, 8),
232(79, 9, 7, 8),
233(80, 10, 20, 8),
234(81, 1, 2, 9),
235(82, 2, 3, 9),
236(83, 3, 5, 9),
237(84, 4, 1, 9),
238(85, 5, 4, 9),
239(86, 6, 15, 9),
240(87, 7, 9, 9),
241(88, 8, 10, 9),
242(89, 9, 13, 9),
243(90, 10, 14, 9),
244(91, 1, 1, 10),
245(92, 2, 2, 10),
246(93, 3, 4, 10),
247(94, 4, 6, 10),
248(95, 5, 5, 10),
249(96, 6, 17, 10),
250(97, 7, 3, 10),
251(98, 8, 10, 10),
252(99, 9, 9, 10),
253(100, 10, 13, 10),
254(101, 1, 3, 11),
255(102, 2, 4, 11),
256(103, 3, 2, 11),
257(104, 4, 1, 11),
258(105, 5, 6, 11),
259(106, 6, 7, 11),
260(107, 7, 12, 11),
261(108, 8, 9, 11),
262(109, 9, 10, 11),
263(110, 10, 8, 11),
264(111, 1, 1, 12),
265(112, 2, 3, 12),
266(113, 3, 5, 12),
267(114, 4, 4, 12),
268(115, 5, 2, 12),
269(116, 6, 17, 12),
270(117, 7, 15, 12),
271(118, 8, 13, 12),
272(119, 9, 10, 12),
273(120, 10, 12, 12),
274(121, 1, 1, 13),
275(122, 2, 2, 13),
276(123, 3, 3, 13),
277(124, 4, 5, 13),
278(125, 5, 4, 13),
279(126, 6, 10, 13),
280(127, 7, 14, 13),
281(128, 8, 13, 13),
282(129, 9, 9, 13),
283(130, 10, 6, 13),
284(131, 1, 1, 14),
285(132, 2, 5, 14),
286(133, 3, 2, 14),
287(134, 4, 12, 14),
288(135, 5, 9, 14),
289(136, 6, 18, 14),
290(137, 7, 8, 14),
291(138, 8, 14, 14),
292(139, 9, 15, 14),
293(140, 10, 10, 14),
294(141, 1, 6, 15),
295(142, 2, 1, 15),
296(143, 3, 5, 15),
297(144, 4, 3, 15),
298(145, 5, 2, 15),
299(146, 6, 9, 15),
300(147, 7, 8, 15),
301(148, 8, 14, 15),
302(149, 9, 13, 15),
303(150, 10, 10, 15),
304(151, 1, 1, 16),
305(152, 2, 6, 16),
306(153, 3, 5, 16),
307(154, 4, 2, 16),
308(155, 5, 4, 16),
309(156, 6, 10, 16),
310(157, 7, 9, 16),
311(158, 8, 16, 16),
312(159, 9, 15, 16),
313(160, 10, 13, 16),
314(161, 1, 1, 17),
315(162, 2, 3, 17),
316(163, 3, 4, 17),
317(164, 4, 6, 17),
318(165, 5, 2, 17),
319(166, 6, 10, 17),
320(167, 7, 12, 17),
321(168, 8, 9, 17),
322(169, 9, 13, 17),
323(170, 10, 11, 17),
324(171, 1, 6, 18),
325(172, 2, 2, 18),
326(173, 3, 4, 18),
327(174, 4, 3, 18),
328(175, 5, 10, 18),
329(176, 6, 14, 18),
330(177, 7, 9, 18),
331(178, 8, 16, 18),
332(179, 9, 1, 18),
333(180, 10, 7, 18),
334(181, 1, 3, 19),
335(182, 2, 2, 19),
336(183, 3, 4, 19),
337(184, 4, 1, 19),
338(185, 5, 6, 19),
339(186, 6, 5, 19),
340(187, 7, 13, 19),
341(188, 8, 7, 19),
342(189, 9, 9, 19),
343(190, 10, 17, 19),
344(191, 1, 2, 20),
345(192, 2, 1, 20),
346(193, 3, 3, 20),
347(194, 4, 4, 20),
348(195, 5, 6, 20),
349(196, 6, 17, 20),
350(197, 7, 9, 20),
351(198, 8, 10, 20),
352(199, 9, 7, 20),
353(200, 10, 13, 20);
354
355-- --------------------------------------------------------
356
357--
358-- Struttura della tabella `team`
359--
360
361CREATE TABLE IF NOT EXISTS `team` (
362 `idTeam` int(10) unsigned NOT NULL AUTO_INCREMENT,
363 `nome` text NOT NULL,
364 `idMotore` int(11) NOT NULL,
365 `sitoWeb` text,
366 `citta` text,
367 `nazionePrincipale` text NOT NULL,
368 PRIMARY KEY (`idTeam`),
369 KEY `idMotore` (`idMotore`)
370) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
371
372--
373-- Dump dei dati per la tabella `team`
374--
375
376INSERT INTO `team` (`idTeam`, `nome`, `idMotore`, `sitoWeb`, `citta`, `nazionePrincipale`) VALUES
377(1, 'Mercedes', 2, 'https://www.mercedesamgf1.com', 'Stoccarda', 'GER'),
378(2, 'Ferrari', 1, 'http://formula1.ferrari.com/it/', 'Maranello', 'ITA'),
379(3, 'Red Bull', 3, 'https://redbullracing.redbull.com/', 'Milton Keynes - Regno Unito', 'AUT'),
380(4, 'Force India', 2, 'https://www.forceindiaf1.com/', 'Silverstone - Regno Unito', 'IND'),
381(5, 'Mc Laren', 4, 'https://www.mclaren.com/', 'Woking - Regno Unito', 'ING'),
382(6, 'Toro Rosso', 3, 'https://scuderiatororosso.redbull.com/it_INT', 'Faenza - Italia', 'ITA'),
383(7, 'Williams', 2, 'http://www.williamsf1.com/racing', 'Wantage - Regno Unito', 'ING'),
384(8, 'Haas', 1, 'https://www.haasf1team.com/', 'Kannapolis - Carolina del Nord - Stati Uniti', 'USA'),
385(9, 'Renault', 3, 'https://www.renaultsport.com/?lang=en', 'Enstone - Regno Unito', 'FRA'),
386(10, 'Sauber', 1, 'https://www.sauberf1team.com/', 'Hinwil - Svizzera', 'SVI');
387
388--
389-- Limiti per le tabelle scaricate
390--
391
392--
393-- Limiti per la tabella `pilota`
394--
395ALTER TABLE `pilota`
396 ADD CONSTRAINT `pilota_ibfk_1` FOREIGN KEY (`idTeam`) REFERENCES `team` (`idTeam`);
397
398--
399-- Limiti per la tabella `risultato`
400--
401ALTER TABLE `risultato`
402 ADD CONSTRAINT `risultato_ibfk_1` FOREIGN KEY (`idPilota`) REFERENCES `pilota` (`idPilota`),
403 ADD CONSTRAINT `risultato_ibfk_2` FOREIGN KEY (`idCircuito`) REFERENCES `circuito` (`idCircuito`);
404
405--
406-- Limiti per la tabella `team`
407--
408ALTER TABLE `team`
409 ADD CONSTRAINT `team_ibfk_1` FOREIGN KEY (`idMotore`) REFERENCES `motore` (`idMotore`);
410
411/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
412/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
413/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;