· 6 years ago · Aug 12, 2019, 11:08 AM
1-- phpMyAdmin SQL Dump
2-- version 4.4.15.9
3-- https://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Gegenereerd op: 12 aug 2019 om 11:02
7-- Serverversie: 5.6.37
8-- PHP-versie: 5.6.31
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 utf8mb4 */;
18
19--
20-- Database: `f1_championship`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Tabelstructuur voor tabel `drivers`
27--
28
29CREATE TABLE IF NOT EXISTS `drivers` (
30 `Naam` varchar(30) NOT NULL,
31 `Team` varchar(30) NOT NULL,
32 `Racenummer` int(2) NOT NULL
33) ENGINE=InnoDB DEFAULT CHARSET=latin1;
34
35--
36-- Gegevens worden geëxporteerd voor tabel `drivers`
37--
38
39INSERT INTO `drivers` (`Naam`, `Team`, `Racenummer`) VALUES
40('Arris', 'Red Bull Racing', 19),
41('Battle On', 'Mercedes AMG Petronas', 75),
42('Bikk3l', 'Alfa Romeo Racing', 34),
43('Demigod', 'Haas F1 Team', 2),
44('Dennis', 'Mercedes AMG Petronas', 13),
45('DonkeyKonkey', 'Mclaren', 12),
46('Heroism', 'Red Bull Racing', 0),
47('Jaimie', 'Reserve Driver', 74),
48('Jordiz64', 'Renault F1 Team', 69),
49('JurdeV', 'Renault F1 Team', 76),
50('Kyreria', 'Williams Racing', 71),
51('MOAB02', 'Alfa Romeo Racing', 53),
52('Pinguin', 'Haas F1 Team', 16),
53('Qumielo', 'Scuderia Ferrari', 25),
54('Rene9977', 'Racing Point F1 Team', 76),
55('Ridion', 'Scuderia Ferrari', 14),
56('Schapen', 'Red Bull Toro Rosso Honda', 22),
57('TheDutchTorpedo', 'Red Bull Toro Rosso Honda', 70),
58('TimToBeat', 'Mclaren', 98),
59('Trivago', 'Racing Point F1 Team', 24),
60('Y_ram(NL)', 'Williams Racing', 83);
61
62-- --------------------------------------------------------
63
64--
65-- Tabelstructuur voor tabel `kalender`
66--
67
68CREATE TABLE IF NOT EXISTS `kalender` (
69 `Race` varchar(30) NOT NULL,
70 `Datum` date NOT NULL,
71 `Tijd` time NOT NULL
72) ENGINE=InnoDB DEFAULT CHARSET=latin1;
73
74--
75-- Gegevens worden geëxporteerd voor tabel `kalender`
76--
77
78INSERT INTO `kalender` (`Race`, `Datum`, `Tijd`) VALUES
79(' Australian Grand Prix', '2019-09-01', '20:30:00'),
80('Bahrain Grand Prix', '2019-09-08', '20:30:00'),
81('Chinese Grand Prix', '2019-09-15', '20:30:00'),
82('Azerbaijan Grand Prix', '2019-09-22', '20:30:00'),
83('Spanish Grand Prix', '2019-09-29', '20:30:00'),
84('Monaco Grand Prix', '2019-10-06', '20:30:00'),
85('Canadian Grand Prix', '2019-10-13', '20:30:00'),
86('French Grand Prix', '2019-10-20', '20:30:00'),
87('Austrian Grand Prix', '2019-10-27', '20:30:00'),
88('British Grand Prix', '2019-11-03', '20:30:00'),
89('German Grand Prix', '2019-11-10', '20:30:00'),
90('Hungarian Grand Prix', '2019-11-17', '20:30:00'),
91('Belgian Grand Prix', '2019-11-24', '20:30:00'),
92('Italian Grand Prix', '2019-12-01', '20:30:00'),
93('Singapore Grand Prix', '2019-12-08', '20:30:00'),
94('Russian Grand Prix', '2019-12-15', '20:30:00'),
95('Japanese Grand Prix', '2019-12-22', '20:30:00'),
96('Mexican Grand Prix', '2019-12-29', '20:30:00'),
97('United States Grand Prix', '2020-01-05', '20:30:00'),
98('Brazilian Grand Prix', '2020-01-12', '20:30:00'),
99('Abu Dhabi Grand Prix', '2020-01-19', '20:30:00');
100
101-- --------------------------------------------------------
102
103--
104-- Tabelstructuur voor tabel `race_results`
105--
106
107CREATE TABLE IF NOT EXISTS `race_results` (
108 `race_id` int(2) NOT NULL,
109 `driver` varchar(30) NOT NULL,
110 `snelste_ronde` varchar(10) NOT NULL,
111 `tijd` varchar(12) NOT NULL,
112 `plek` int(2) NOT NULL,
113 `punten` int(2) NOT NULL
114) ENGINE=InnoDB DEFAULT CHARSET=latin1;
115
116--
117-- Gegevens worden geëxporteerd voor tabel `race_results`
118--
119
120INSERT INTO `race_results` (`race_id`, `driver`, `snelste_ronde`, `tijd`, `plek`, `punten`) VALUES
121(1, 'Ridion', '00:01:13', '00:41:00', 2, 18),
122(1, 'Qumielo', '00:01:13', '00:41:00', 3, 15),
123(1, 'TimToBeat', '00:01:13', '00:41:00', 9, 2),
124(1, 'DonkeyKonkey', '00:01:13', '00:41:00', 10, 1),
125(1, 'Demigod', '00:01:13', '00:41:00', 1, 25),
126(1, 'Pinguin', '00:01:13', '00:41:00', 4, 12),
127(1, 'JordiZ64', '00:01:13', '00:41:00', 5, 10),
128(1, 'JurdeV', '00:01:13', '00:41:00', 6, 8),
129(1, 'Trivago', '00:01:13', '00:41:00', 7, 6),
130(1, 'Dennis', '00:01:13', '00:41:00', 8, 4),
131(1, 'MOAB02', '00:01:13', '00:41:00', 11, 0),
132(1, 'Bikk3l', '00:01:13', '00:41:00', 12, 0),
133(1, 'Battle On', '00:01:13', '00:41:00', 13, 0),
134(1, 'Rene9977', '00:01:13', '00:41:00', 14, 0),
135(1, 'Arris', '00:01:13', '00:41:00', 15, 0),
136(1, 'Heroism', '00:01:13', '00:41:00', 16, 0),
137(1, 'Schapen', '00:01:13', '00:41:00', 17, 0),
138(1, 'TheDutchTorpedo', '00:01:13', '00:41:00', 18, 0),
139(1, 'Kyreria', '00:01:13', '00:41:00', 19, 0),
140(1, 'Y_ram(NL)', '00:01:13', '00:41:00', 20, 0),
141(2, 'Ridion', '00:01:13', '00:41:00', 1, 25),
142(2, 'Qumielo', '00:01:13', '00:41:00', 3, 15),
143(2, 'TimToBeat', '00:01:13', '00:41:00', 9, 2),
144(2, 'DonkeyKonkey', '00:01:13', '00:41:00', 10, 1),
145(2, 'Demigod', '00:01:13', '00:41:00', 2, 18),
146(2, 'Pinguin', '00:01:13', '00:41:00', 4, 12),
147(2, 'JordiZ64', '00:01:13', '00:41:00', 19, 0),
148(2, 'JurdeV', '00:01:13', '00:41:00', 6, 8),
149(2, 'Trivago', '00:01:13', '00:41:00', 7, 6),
150(2, 'Dennis', '00:01:13', '00:41:00', 8, 4),
151(2, 'MOAB02', '00:01:13', '00:41:00', 11, 0),
152(2, 'Bikk3l', '00:01:13', '00:41:00', 13, 0),
153(2, 'Battle On', '00:01:13', '00:41:00', 12, 0),
154(2, 'Rene9977', '00:01:13', '00:41:00', 14, 0),
155(2, 'Arris', '00:01:13', '00:41:00', 15, 0),
156(2, 'Heroism', '00:01:13', '00:41:00', 16, 0),
157(2, 'Schapen', '00:01:13', '00:41:00', 17, 0),
158(2, 'TheDutchTorpedo', '00:01:13', '00:41:00', 18, 0),
159(2, 'Kyreria', '00:01:13', '00:41:00', 5, 10),
160(2, 'Y_ram(NL)', '00:01:13', '00:41:00', 20, 0),
161(3, 'Demigod', '00:01:13', '00:41:00', 1, 25),
162(3, 'Ridion', '00:01:12', '00:41:00', 2, 18);
163
164--
165-- Indexen voor geëxporteerde tabellen
166--
167
168--
169-- Indexen voor tabel `drivers`
170--
171ALTER TABLE `drivers`
172 ADD PRIMARY KEY (`Naam`);
173
174/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
175/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
176/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;