-
Notifications
You must be signed in to change notification settings - Fork 3
/
cars.sql
36 lines (34 loc) · 2.57 KB
/
cars.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
--
-- File generated with SQLiteStudio v3.0.6 on Fri Jul 17 19:56:54 2015
--
-- Text encoding used: UTF-8
--
PRAGMA foreign_keys = off;
BEGIN TRANSACTION;
-- Table: cars
CREATE TABLE cars (id INTEGER PRIMARY KEY UNIQUE, name text, maxrpm real, startrpm real);
INSERT INTO cars (id, name, maxrpm, startrpm) VALUES (1, 'Mini Cooper S', 733.038, 104.72);
INSERT INTO cars (id, name, maxrpm, startrpm) VALUES (2, 'Lancia Fulvia HF', 783.304, 98.4366);
INSERT INTO cars (id, name, maxrpm, startrpm) VALUES (3, 'Opel Kadett GT/E 16v', 869.174, 125.664);
INSERT INTO cars (id, name, maxrpm, startrpm) VALUES (4, 'Fiat 131 Abarth', 884.882, 150.796);
INSERT INTO cars (id, name, maxrpm, startrpm) VALUES (5, 'Ford Escort Mk II', 942.478, 104.72);
INSERT INTO cars (id, name, maxrpm, startrpm) VALUES (6, 'Lancia Stratos', 837.758, 188.496);
INSERT INTO cars (id, name, maxrpm, startrpm) VALUES (7, 'BMW E30 Evo Rally', 942.478, 125.664);
INSERT INTO cars (id, name, maxrpm, startrpm) VALUES (8, 'Ford Sierra Cosworth RS500', 785.398, 125.664);
INSERT INTO cars (id, name, maxrpm, startrpm) VALUES (9, 'MG Metro 6R4', 1099.56, 157.08);
INSERT INTO cars (id, name, maxrpm, startrpm) VALUES (10, 'Audi Sport Quattro Rallye', 733.038, 115.192);
INSERT INTO cars (id, name, maxrpm, startrpm) VALUES (11, 'Ford RS200 / Lancia 037 Evo 2', 890.118, 125.664);
INSERT INTO cars (id, name, maxrpm, startrpm) VALUES (12, 'Peugeot 2015 T16 Evo 2 ', 837.758, 209.439);
INSERT INTO cars (id, name, maxrpm, startrpm) VALUES (13, 'Lancia Delta S4', 890.118, 104.72);
INSERT INTO cars (id, name, maxrpm, startrpm) VALUES (14, 'Delta HF Integrale / Ford Escort RS Cosworth', 785.398, 104.72);
INSERT INTO cars (id, name, maxrpm, startrpm) VALUES (15, 'Subaru Impreza 1995', 785.398, 125.664);
INSERT INTO cars (id, name, maxrpm, startrpm) VALUES (17, 'Seat Ibiza Kitcar', 942.478, 136.136);
INSERT INTO cars (id, name, maxrpm, startrpm) VALUES (18, 'Peugeot 306 Maxi', 1151.92, 146.607);
INSERT INTO cars (id, name, maxrpm, startrpm) VALUES (19, 'Mini Countryman Rally Edition', 785.398, 157.08);
INSERT INTO cars (id, name, maxrpm, startrpm) VALUES (20, 'Ford Fiesta 2010', 785.398, 146.607);
INSERT INTO cars (id, name, maxrpm, startrpm) VALUES (21, 'Opel Manta 400', 837.758, 146.607);
INSERT INTO cars (id, name, maxrpm, startrpm) VALUES (1000, 'Peugeot 205 T16 Pikes Peak', 837.758, 209.439);
INSERT INTO cars (id, name, maxrpm, startrpm) VALUES (1001, 'Peugeot 405 T16 Pikes Peak', 837.758, 157.08);
INSERT INTO cars (id, name, maxrpm, startrpm) VALUES (1002, 'Audi Sport Quattro S1 PP', 863.938, 141.372);
COMMIT TRANSACTION;
PRAGMA foreign_keys = on;