Description:
Adding a dump from a Microsoft Access database.
Dump made by BullZip Access to MySQL
How to repeat:
# Dump File
#
# Database is ported from MS Access
#--------------------------------------------------------
# Program Version 3.0.148
DROP DATABASE IF EXISTS `db`;
CREATE DATABASE IF NOT EXISTS `db`;
USE `db`;
#
# Table structure for table 'BaneData'
#
DROP TABLE IF EXISTS `BaneData`;
CREATE TABLE `BaneData` (
`BData-ID` INTEGER NOT NULL AUTO_INCREMENT,
`BData-Navn` VARCHAR(30),
`BData-Land` VARCHAR(30),
`BData-Landekode` INTEGER DEFAULT 0,
`BData-filenavn` VARCHAR(30),
`BData-Omgange` TINYINT DEFAULT 0,
`BData-Kilometer` FLOAT NULL DEFAULT 0
) ENGINE=innodb DEFAULT CHARSET=utf8;
SET autocommit=1;
#
# Dumping data for table 'BaneData'
#
INSERT INTO `BaneData` () VALUES (1, 'Yas Marina', 'Abu Dhabi', 2, 'abu-dhabi', 55, 0);
INSERT INTO `BaneData` () VALUES (2, 'Buenos Aires', 'Argentina', 3, 'buenos-aires', 72, 0);
INSERT INTO `BaneData` () VALUES (3, 'Melbourne', 'Australien', 5, 'melbourne', 58, 0);
INSERT INTO `BaneData` () VALUES (4, 'Melbourne', 'Australien', 5, 'melbourne', 58, 0);
INSERT INTO `BaneData` () VALUES (5, 'Sakhir', 'Bahrain', 7, 'bahrain', 57, 0);
INSERT INTO `BaneData` () VALUES (6, 'Spa-Francorchamps', 'Belgien', 6, 'spa-francorchamps', 44, 0);
INSERT INTO `BaneData` () VALUES (7, 'São Paolo', 'Brasilien', 8, 'interlagos', 71, 0);
INSERT INTO `BaneData` () VALUES (8, 'São Paolo', 'Brasilien', 8, 'interlagos', 72, 0);
INSERT INTO `BaneData` () VALUES (9, 'Montreal', 'Canada', 9, 'gilles-villeneuve', 70, 0);
INSERT INTO `BaneData` () VALUES (10, 'Montreal', 'Canada', 9, 'gilles-villeneuve', 70, 0);
INSERT INTO `BaneData` () VALUES (11, 'Silverstone', 'England', 33, 'silverstone', 52, 0);
INSERT INTO `BaneData` () VALUES (12, 'Silverstone', 'England', 33, 'silverstone', 60, 0);
INSERT INTO `BaneData` () VALUES (13, 'Valencia', 'Europa', 16, 'valencia', 57, 0);
INSERT INTO `BaneData` () VALUES (14, 'Nürburgring', 'Europa', 16, 'nurburgring', 59, 0);
INSERT INTO `BaneData` () VALUES (15, 'Nürburgring', 'Tyskland', 16, 'nurburgring', 60, 0);
INSERT INTO `BaneData` () VALUES (16, 'Nürburgring', 'Europa', 16, 'nurburgring', 66, 0);
INSERT INTO `BaneData` () VALUES (17, 'Nürburgring', 'Europa', 16, 'nurburgring', 67, 0);
INSERT INTO `BaneData` () VALUES (18, 'Magny-Cours', 'Frankrig', 18, 'magny-cours', 70, 0);
INSERT INTO `BaneData` () VALUES (19, 'Magny-Cours', 'Frankrig', 18, 'magny-cours', 71, 0);
INSERT INTO `BaneData` () VALUES (20, 'Magny-Cours', 'Frankrig', 18, 'magny-cours', 72, 0);
INSERT INTO `BaneData` () VALUES (21, 'Monza', 'Italien', 22, 'monza', 53, 0);
INSERT INTO `BaneData` () VALUES (22, 'Suzuka', 'Japan', 23, 'suzuka', 51, 0);
INSERT INTO `BaneData` () VALUES (23, 'Suzuka', 'Japan', 23, 'suzuka', 53, 0);
INSERT INTO `BaneData` () VALUES (24, 'Fuji', 'Japan', 23, 'fuji', 67, 0);
INSERT INTO `BaneData` () VALUES (25, 'Shanghai', 'Kina', 10, 'shanghai', 56, 0);
INSERT INTO `BaneData` () VALUES (26, 'Sepang', 'Malaysia', 25, 'kuala-lumpur', 56, 0);
INSERT INTO `BaneData` () VALUES (27, 'Monte Carlo', 'Monaco', 24, 'monte-carlo', 78, 0);
INSERT INTO `BaneData` () VALUES (28, 'Monte Carlo', 'Monaco', 24, 'monte-carlo', 78, 0);
INSERT INTO `BaneData` () VALUES (29, 'Imola', 'San Marino', 31, 'imola', 62, 0);
INSERT INTO `BaneData` () VALUES (30, 'Singapore', 'Singapore', 30, 'singapore', 61, 0);
INSERT INTO `BaneData` () VALUES (31, 'Barcelona', 'Spanien', 15, 'catalunya', 66, 0);
INSERT INTO `BaneData` () VALUES (32, 'Barcelona', 'Spanien', 15, 'catalunya', 66, 0);
INSERT INTO `BaneData` () VALUES (33, 'Istanbul', 'Tyrkiet', 32, 'istanbul', 58, 0);
INSERT INTO `BaneData` () VALUES (34, 'Hockenheim', 'Tyskland', 14, 'hockenheim', 45, 0);
INSERT INTO `BaneData` () VALUES (35, 'Hockenheim', 'Tyskland', 14, 'hockenheim', 67, 0);
INSERT INTO `BaneData` () VALUES (36, 'Hockenheim', 'Tyskland', 14, 'hockenheim', 67, 0);
INSERT INTO `BaneData` () VALUES (37, 'Hungaroring', 'Ungarn', 19, 'hungaroring', 70, 0);
INSERT INTO `BaneData` () VALUES (38, 'Hungaroring', 'Ungarn', 19, 'hungaroring', 77, 0);
INSERT INTO `BaneData` () VALUES (39, 'Indianapolis', 'USA', 34, 'indianapolis', 73, 0);
INSERT INTO `BaneData` () VALUES (40, 'Spielberg', 'Østrig', 4, 'a1-ring', 69, 0);
INSERT INTO `BaneData` () VALUES (41, 'Spielberg', 'Østrig', 4, 'a1-ring', 71, 0);
INSERT INTO `BaneData` () VALUES (43, 'Seoul', 'Korea', 4, 'korea', 55, 0);
INSERT INTO `BaneData` () VALUES (45, 'Sakhir', 'Bahrain', 7, 'bahrain', 49, 0);
INSERT INTO `BaneData` () VALUES (46, 'Delhi', 'Indien', 21, 'indien', 60, 0);
# 44 records
