Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
FIFA Worldcup 2014 Brazil mySQL and JSON dumps, includes data for all participating teams, venues and matches

FIFA Worldcup 2014 Brazil mySQL and JSON dumps, includes data for all participating teams, venues and matches.

Note that match contains a parameter stage:

0 => Group games

8 => Round of 16

4 => Quarter-Finals

2 => Semi-Finals

1 => Losers-Final and Final

team1_id and team2_id refer to team_bracket when stage > 0

{
"data":
[
{
"id": 1,
"name": "A"
},
{
"id": 2,
"name": "B"
},
{
"id": 3,
"name": "C"
},
{
"id": 4,
"name": "D"
},
{
"id": 5,
"name": "E"
},
{
"id": 6,
"name": "F"
},
{
"id": 7,
"name": "G"
},
{
"id": 8,
"name": "H"
}
]
}
{
"data":
[
{
"id": 1,
"stage": 0,
"venue_id": 12,
"team1_id": 1,
"team2_id": 2,
"kickoff": "2014-06-12 17:00:00"
},
{
"id": 2,
"stage": 0,
"venue_id": 7,
"team1_id": 3,
"team2_id": 4,
"kickoff": "2014-06-13 13:00:00"
},
{
"id": 3,
"stage": 0,
"venue_id": 11,
"team1_id": 5,
"team2_id": 6,
"kickoff": "2014-06-13 16:00:00"
},
{
"id": 4,
"stage": 0,
"venue_id": 3,
"team1_id": 7,
"team2_id": 8,
"kickoff": "2014-06-13 18:00:00"
},
{
"id": 5,
"stage": 0,
"venue_id": 1,
"team1_id": 9,
"team2_id": 10,
"kickoff": "2014-06-14 13:00:00"
},
{
"id": 6,
"stage": 0,
"venue_id": 9,
"team1_id": 11,
"team2_id": 12,
"kickoff": "2014-06-14 22:00:00"
},
{
"id": 7,
"stage": 0,
"venue_id": 5,
"team1_id": 13,
"team2_id": 14,
"kickoff": "2014-06-14 16:00:00"
},
{
"id": 8,
"stage": 0,
"venue_id": 6,
"team1_id": 15,
"team2_id": 16,
"kickoff": "2014-06-14 18:00:00"
},
{
"id": 9,
"stage": 0,
"venue_id": 2,
"team1_id": 17,
"team2_id": 18,
"kickoff": "2014-06-15 13:00:00"
},
{
"id": 10,
"stage": 0,
"venue_id": 8,
"team1_id": 19,
"team2_id": 20,
"kickoff": "2014-06-15 16:00:00"
},
{
"id": 11,
"stage": 0,
"venue_id": 10,
"team1_id": 21,
"team2_id": 22,
"kickoff": "2014-06-15 19:00:00"
},
{
"id": 12,
"stage": 0,
"venue_id": 4,
"team1_id": 23,
"team2_id": 24,
"kickoff": "2014-06-16 16:00:00"
},
{
"id": 13,
"stage": 0,
"venue_id": 11,
"team1_id": 25,
"team2_id": 26,
"kickoff": "2014-06-16 13:00:00"
},
{
"id": 14,
"stage": 0,
"venue_id": 7,
"team1_id": 27,
"team2_id": 28,
"kickoff": "2014-06-16 19:00:00"
},
{
"id": 15,
"stage": 0,
"venue_id": 1,
"team1_id": 29,
"team2_id": 30,
"kickoff": "2014-06-17 13:00:00"
},
{
"id": 16,
"stage": 0,
"venue_id": 3,
"team1_id": 31,
"team2_id": 32,
"kickoff": "2014-06-17 18:00:00"
},
{
"id": 17,
"stage": 0,
"venue_id": 5,
"team1_id": 1,
"team2_id": 3,
"kickoff": "2014-06-17 16:00:00"
},
{
"id": 18,
"stage": 0,
"venue_id": 6,
"team1_id": 4,
"team2_id": 2,
"kickoff": "2014-06-18 18:00:00"
},
{
"id": 19,
"stage": 0,
"venue_id": 10,
"team1_id": 5,
"team2_id": 7,
"kickoff": "2014-06-18 16:00:00"
},
{
"id": 20,
"stage": 0,
"venue_id": 8,
"team1_id": 8,
"team2_id": 6,
"kickoff": "2014-06-18 13:00:00"
},
{
"id": 21,
"stage": 0,
"venue_id": 2,
"team1_id": 9,
"team2_id": 11,
"kickoff": "2014-06-19 13:00:00"
},
{
"id": 22,
"stage": 0,
"venue_id": 7,
"team1_id": 12,
"team2_id": 10,
"kickoff": "2014-06-19 19:00:00"
},
{
"id": 23,
"stage": 0,
"venue_id": 12,
"team1_id": 13,
"team2_id": 15,
"kickoff": "2014-06-19 16:00:00"
},
{
"id": 24,
"stage": 0,
"venue_id": 9,
"team1_id": 16,
"team2_id": 14,
"kickoff": "2014-06-20 13:00:00"
},
{
"id": 25,
"stage": 0,
"venue_id": 11,
"team1_id": 17,
"team2_id": 19,
"kickoff": "2014-06-20 16:00:00"
},
{
"id": 26,
"stage": 0,
"venue_id": 4,
"team1_id": 20,
"team2_id": 18,
"kickoff": "2014-06-20 19:00:00"
},
{
"id": 27,
"stage": 0,
"venue_id": 1,
"team1_id": 21,
"team2_id": 23,
"kickoff": "2014-06-21 13:00:00"
},
{
"id": 28,
"stage": 0,
"venue_id": 3,
"team1_id": 24,
"team2_id": 22,
"kickoff": "2014-06-21 18:00:00"
},
{
"id": 29,
"stage": 0,
"venue_id": 5,
"team1_id": 25,
"team2_id": 27,
"kickoff": "2014-06-21 16:00:00"
},
{
"id": 30,
"stage": 0,
"venue_id": 6,
"team1_id": 28,
"team2_id": 26,
"kickoff": "2014-06-22 18:00:00"
},
{
"id": 31,
"stage": 0,
"venue_id": 10,
"team1_id": 29,
"team2_id": 31,
"kickoff": "2014-06-22 13:00:00"
},
{
"id": 32,
"stage": 0,
"venue_id": 8,
"team1_id": 32,
"team2_id": 30,
"kickoff": "2014-06-22 16:00:00"
},
{
"id": 33,
"stage": 0,
"venue_id": 2,
"team1_id": 4,
"team2_id": 1,
"kickoff": "2014-06-23 17:00:00"
},
{
"id": 34,
"stage": 0,
"venue_id": 9,
"team1_id": 2,
"team2_id": 3,
"kickoff": "2014-06-23 17:00:00"
},
{
"id": 35,
"stage": 0,
"venue_id": 4,
"team1_id": 8,
"team2_id": 5,
"kickoff": "2014-06-23 13:00:00"
},
{
"id": 36,
"stage": 0,
"venue_id": 12,
"team1_id": 6,
"team2_id": 7,
"kickoff": "2014-06-23 13:00:00"
},
{
"id": 37,
"stage": 0,
"venue_id": 3,
"team1_id": 12,
"team2_id": 9,
"kickoff": "2014-06-24 16:00:00"
},
{
"id": 38,
"stage": 0,
"venue_id": 5,
"team1_id": 10,
"team2_id": 11,
"kickoff": "2014-06-24 16:00:00"
},
{
"id": 39,
"stage": 0,
"venue_id": 7,
"team1_id": 16,
"team2_id": 13,
"kickoff": "2014-06-24 13:00:00"
},
{
"id": 40,
"stage": 0,
"venue_id": 1,
"team1_id": 14,
"team2_id": 15,
"kickoff": "2014-06-24 13:00:00"
},
{
"id": 41,
"stage": 0,
"venue_id": 6,
"team1_id": 20,
"team2_id": 17,
"kickoff": "2014-06-25 16:00:00"
},
{
"id": 42,
"stage": 0,
"venue_id": 10,
"team1_id": 18,
"team2_id": 19,
"kickoff": "2014-06-25 17:00:00"
},
{
"id": 43,
"stage": 0,
"venue_id": 8,
"team1_id": 24,
"team2_id": 21,
"kickoff": "2014-06-25 13:00:00"
},
{
"id": 44,
"stage": 0,
"venue_id": 11,
"team1_id": 22,
"team2_id": 23,
"kickoff": "2014-06-25 13:00:00"
},
{
"id": 45,
"stage": 0,
"venue_id": 9,
"team1_id": 28,
"team2_id": 25,
"kickoff": "2014-06-26 13:00:00"
},
{
"id": 46,
"stage": 0,
"venue_id": 2,
"team1_id": 26,
"team2_id": 27,
"kickoff": "2014-06-26 13:00:00"
},
{
"id": 47,
"stage": 0,
"venue_id": 12,
"team1_id": 32,
"team2_id": 29,
"kickoff": "2014-06-26 17:00:00"
},
{
"id": 48,
"stage": 0,
"venue_id": 4,
"team1_id": 30,
"team2_id": 31,
"kickoff": "2014-06-26 17:00:00"
},
{
"id": 49,
"stage": 8,
"venue_id": 1,
"team1_id": 1,
"team2_id": 10,
"kickoff": "2014-06-28 13:00:00"
},
{
"id": 50,
"stage": 8,
"venue_id": 10,
"team1_id": 3,
"team2_id": 12,
"kickoff": "2014-06-28 17:00:00"
},
{
"id": 51,
"stage": 8,
"venue_id": 5,
"team1_id": 2,
"team2_id": 9,
"kickoff": "2014-06-29 13:00:00"
},
{
"id": 52,
"stage": 8,
"venue_id": 9,
"team1_id": 4,
"team2_id": 11,
"kickoff": "2014-06-29 17:00:00"
},
{
"id": 53,
"stage": 8,
"venue_id": 2,
"team1_id": 5,
"team2_id": 14,
"kickoff": "2014-06-30 13:00:00"
},
{
"id": 54,
"stage": 8,
"venue_id": 8,
"team1_id": 7,
"team2_id": 16,
"kickoff": "2014-06-30 17:00:00"
},
{
"id": 55,
"stage": 8,
"venue_id": 12,
"team1_id": 6,
"team2_id": 13,
"kickoff": "2014-07-01 13:00:00"
},
{
"id": 56,
"stage": 8,
"venue_id": 11,
"team1_id": 8,
"team2_id": 15,
"kickoff": "2014-07-01 17:00:00"
},
{
"id": 57,
"stage": 4,
"venue_id": 5,
"team1_id": 17,
"team2_id": 18,
"kickoff": "2014-07-04 17:00:00"
},
{
"id": 58,
"stage": 4,
"venue_id": 10,
"team1_id": 21,
"team2_id": 22,
"kickoff": "2014-07-04 13:00:00"
},
{
"id": 59,
"stage": 4,
"venue_id": 11,
"team1_id": 19,
"team2_id": 20,
"kickoff": "2014-07-05 17:00:00"
},
{
"id": 60,
"stage": 4,
"venue_id": 2,
"team1_id": 23,
"team2_id": 24,
"kickoff": "2014-07-05 13:00:00"
},
{
"id": 61,
"stage": 2,
"venue_id": 1,
"team1_id": 25,
"team2_id": 26,
"kickoff": "2014-07-08 17:00:00"
},
{
"id": 62,
"stage": 2,
"venue_id": 12,
"team1_id": 27,
"team2_id": 28,
"kickoff": "2014-07-09 17:00:00"
},
{
"id": 63,
"stage": 1,
"venue_id": 2,
"team1_id": 29,
"team2_id": 30,
"kickoff": "2014-07-12 17:00:00"
},
{
"id": 64,
"stage": 1,
"venue_id": 10,
"team1_id": 31,
"team2_id": 32,
"kickoff": "2014-07-13 17:00:00"
}
]
}
{
"data":
[
{
"id": 1,
"group_id": 1,
"code": "BRA",
"name": "Brazil"
},
{
"id": 2,
"group_id": 1,
"code": "HRV",
"name": "Croatia"
},
{
"id": 3,
"group_id": 1,
"code": "MEX",
"name": "Mexico"
},
{
"id": 4,
"group_id": 1,
"code": "CMR",
"name": "Cameroon"
},
{
"id": 5,
"group_id": 2,
"code": "ESP",
"name": "Spain"
},
{
"id": 6,
"group_id": 2,
"code": "NLD",
"name": "Netherlands"
},
{
"id": 7,
"group_id": 2,
"code": "CHL",
"name": "Chile"
},
{
"id": 8,
"group_id": 2,
"code": "AUS",
"name": "Australia"
},
{
"id": 9,
"group_id": 3,
"code": "COL",
"name": "Colombia"
},
{
"id": 10,
"group_id": 3,
"code": "GRC",
"name": "Greece"
},
{
"id": 11,
"group_id": 3,
"code": "CIV",
"name": "Ivory Coast"
},
{
"id": 12,
"group_id": 3,
"code": "JPN",
"name": "Japan"
},
{
"id": 13,
"group_id": 4,
"code": "URY",
"name": "Uruguay"
},
{
"id": 14,
"group_id": 4,
"code": "CRC",
"name": "Costa Rica"
},
{
"id": 15,
"group_id": 4,
"code": "ENG",
"name": "England"
},
{
"id": 16,
"group_id": 4,
"code": "ITA",
"name": "Italy"
},
{
"id": 17,
"group_id": 5,
"code": "CHE",
"name": "Switzerland"
},
{
"id": 18,
"group_id": 5,
"code": "ECU",
"name": "Ecuador"
},
{
"id": 19,
"group_id": 5,
"code": "FRA",
"name": "France"
},
{
"id": 20,
"group_id": 5,
"code": "HND",
"name": "Honduras"
},
{
"id": 21,
"group_id": 6,
"code": "ARG",
"name": "Argentina"
},
{
"id": 22,
"group_id": 6,
"code": "BIH",
"name": "Bosnia and Herzegovina"
},
{
"id": 23,
"group_id": 6,
"code": "IRN",
"name": "Iran"
},
{
"id": 24,
"group_id": 6,
"code": "NGA",
"name": "Nigeria"
},
{
"id": 25,
"group_id": 7,
"code": "DEU",
"name": "Germany"
},
{
"id": 26,
"group_id": 7,
"code": "PRT",
"name": "Portugal"
},
{
"id": 27,
"group_id": 7,
"code": "GHA",
"name": "Ghana"
},
{
"id": 28,
"group_id": 7,
"code": "USA",
"name": "USA"
},
{
"id": 29,
"group_id": 8,
"code": "BEL",
"name": "Belgium"
},
{
"id": 30,
"group_id": 8,
"code": "DZA",
"name": "Algeria"
},
{
"id": 31,
"group_id": 8,
"code": "RUS",
"name": "Russia"
},
{
"id": 32,
"group_id": 8,
"code": "KOR",
"name": "Korea"
}
]
}
{
"data":
[
{
"id": 1,
"label": "1A",
"team_id": 0
},
{
"id": 2,
"label": "1B",
"team_id": 0
},
{
"id": 3,
"label": "1C",
"team_id": 0
},
{
"id": 4,
"label": "1D",
"team_id": 0
},
{
"id": 5,
"label": "1E",
"team_id": 0
},
{
"id": 6,
"label": "1F",
"team_id": 0
},
{
"id": 7,
"label": "1G",
"team_id": 0
},
{
"id": 8,
"label": "1H",
"team_id": 0
},
{
"id": 9,
"label": "2A",
"team_id": 0
},
{
"id": 10,
"label": "2B",
"team_id": 0
},
{
"id": 11,
"label": "2C",
"team_id": 0
},
{
"id": 12,
"label": "2D",
"team_id": 0
},
{
"id": 13,
"label": "2E",
"team_id": 0
},
{
"id": 14,
"label": "2F",
"team_id": 0
},
{
"id": 15,
"label": "2G",
"team_id": 0
},
{
"id": 16,
"label": "2H",
"team_id": 0
},
{
"id": 17,
"label": "W49",
"team_id": 0
},
{
"id": 18,
"label": "W50",
"team_id": 0
},
{
"id": 19,
"label": "W51",
"team_id": 0
},
{
"id": 20,
"label": "W52",
"team_id": 0
},
{
"id": 21,
"label": "W53",
"team_id": 0
},
{
"id": 22,
"label": "W54",
"team_id": 0
},
{
"id": 23,
"label": "W55",
"team_id": 0
},
{
"id": 24,
"label": "W56",
"team_id": 0
},
{
"id": 25,
"label": "W57",
"team_id": 0
},
{
"id": 26,
"label": "W58",
"team_id": 0
},
{
"id": 27,
"label": "W59",
"team_id": 0
},
{
"id": 28,
"label": "W60",
"team_id": 0
},
{
"id": 29,
"label": "L61",
"team_id": 0
},
{
"id": 30,
"label": "L62",
"team_id": 0
},
{
"id": 31,
"label": "W61",
"team_id": 0
},
{
"id": 32,
"label": "W62",
"team_id": 0
}
]
}
{
"data":
[
{
"id": 1,
"name": "Estadio Mineirao",
"city": "Belo Horizonte"
},
{
"id": 2,
"name": "Estadio Nacional",
"city": "Brasilia"
},
{
"id": 3,
"name": "Arena Pantanal",
"city": "Cuiaba"
},
{
"id": 4,
"name": "Arena da Baixada",
"city": "Curitiba"
},
{
"id": 5,
"name": "Estadio Castelao",
"city": "Fortaleza"
},
{
"id": 6,
"name": "Arena Amazonia",
"city": "Manaus"
},
{
"id": 7,
"name": "Estadio das Dunas",
"city": "Natal"
},
{
"id": 8,
"name": "Estadio Beira-Rio",
"city": "Porto Alegre"
},
{
"id": 9,
"name": "Arena Pernambuco",
"city": "Recife"
},
{
"id": 10,
"name": "Estadio do Maracana",
"city": "Rio De Janeiro"
},
{
"id": 11,
"name": "Arena Fonte Nova",
"city": "Salvador"
},
{
"id": 12,
"name": "Arena de Sao Paulo",
"city": "Sao Paulo"
}
]
}
# Dump of table teams_bracket
# ------------------------------------------------------------
DROP TABLE IF EXISTS `teams_bracket`;
CREATE TABLE `teams_bracket` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`label` varchar(3) NOT NULL DEFAULT '',
`team_id` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `teams_bracket` WRITE;
/*!40000 ALTER TABLE `teams_bracket` DISABLE KEYS */;
INSERT INTO `teams_bracket` (`id`, `label`, `team_id`)
VALUES
(1,'1A',0),
(2,'1B',0),
(3,'1C',0),
(4,'1D',0),
(5,'1E',0),
(6,'1F',0),
(7,'1G',0),
(8,'1H',0),
(9,'2A',0),
(10,'2B',0),
(11,'2C',0),
(12,'2D',0),
(13,'2E',0),
(14,'2F',0),
(15,'2G',0),
(16,'2H',0),
(17,'W49',0),
(18,'W50',0),
(19,'W51',0),
(20,'W52',0),
(21,'W53',0),
(22,'W54',0),
(23,'W55',0),
(24,'W56',0),
(25,'W57',0),
(26,'W58',0),
(27,'W59',0),
(28,'W60',0),
(29,'L61',0),
(30,'L62',0),
(31,'W61',0),
(32,'W62',0);
/*!40000 ALTER TABLE `teams_bracket` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table group
# ------------------------------------------------------------
DROP TABLE IF EXISTS `group`;
CREATE TABLE `group` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(1) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `group` WRITE;
/*!40000 ALTER TABLE `group` DISABLE KEYS */;
INSERT INTO `group` (`id`, `name`)
VALUES
(1,'A'),
(2,'B'),
(3,'C'),
(4,'D'),
(5,'E'),
(6,'F'),
(7,'G'),
(8,'H');
/*!40000 ALTER TABLE `group` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table match
# ------------------------------------------------------------
DROP TABLE IF EXISTS `match`;
CREATE TABLE `match` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`stage` tinyint(1) unsigned NOT NULL,
`venue_id` int(11) unsigned NOT NULL,
`team1_id` int(11) unsigned NOT NULL,
`team2_id` int(11) unsigned NOT NULL,
`kickoff` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `match` WRITE;
/*!40000 ALTER TABLE `match` DISABLE KEYS */;
INSERT INTO `match` (`id`, `stage`, `venue_id`, `team1_id`, `team2_id`, `kickoff`)
VALUES
(1,0,12,1,2,'2014-06-12 17:00:00'),
(2,0,7,3,4,'2014-06-13 13:00:00'),
(3,0,11,5,6,'2014-06-13 16:00:00'),
(4,0,3,7,8,'2014-06-13 18:00:00'),
(5,0,1,9,10,'2014-06-14 13:00:00'),
(6,0,9,11,12,'2014-06-14 22:00:00'),
(7,0,5,13,14,'2014-06-14 16:00:00'),
(8,0,6,15,16,'2014-06-14 18:00:00'),
(9,0,2,17,18,'2014-06-15 13:00:00'),
(10,0,8,19,20,'2014-06-15 16:00:00'),
(11,0,10,21,22,'2014-06-15 19:00:00'),
(12,0,4,23,24,'2014-06-16 16:00:00'),
(13,0,11,25,26,'2014-06-16 13:00:00'),
(14,0,7,27,28,'2014-06-16 19:00:00'),
(15,0,1,29,30,'2014-06-17 13:00:00'),
(16,0,3,31,32,'2014-06-17 18:00:00'),
(17,0,5,1,3,'2014-06-17 16:00:00'),
(18,0,6,4,2,'2014-06-18 18:00:00'),
(19,0,10,5,7,'2014-06-18 16:00:00'),
(20,0,8,8,6,'2014-06-18 13:00:00'),
(21,0,2,9,11,'2014-06-19 13:00:00'),
(22,0,7,12,10,'2014-06-19 19:00:00'),
(23,0,12,13,15,'2014-06-19 16:00:00'),
(24,0,9,16,14,'2014-06-20 13:00:00'),
(25,0,11,17,19,'2014-06-20 16:00:00'),
(26,0,4,20,18,'2014-06-20 19:00:00'),
(27,0,1,21,23,'2014-06-21 13:00:00'),
(28,0,3,24,22,'2014-06-21 18:00:00'),
(29,0,5,25,27,'2014-06-21 16:00:00'),
(30,0,6,28,26,'2014-06-22 18:00:00'),
(31,0,10,29,31,'2014-06-22 13:00:00'),
(32,0,8,32,30,'2014-06-22 16:00:00'),
(33,0,2,4,1,'2014-06-23 17:00:00'),
(34,0,9,2,3,'2014-06-23 17:00:00'),
(35,0,4,8,5,'2014-06-23 13:00:00'),
(36,0,12,6,7,'2014-06-23 13:00:00'),
(37,0,3,12,9,'2014-06-24 16:00:00'),
(38,0,5,10,11,'2014-06-24 16:00:00'),
(39,0,7,16,13,'2014-06-24 13:00:00'),
(40,0,1,14,15,'2014-06-24 13:00:00'),
(41,0,6,20,17,'2014-06-25 16:00:00'),
(42,0,10,18,19,'2014-06-25 17:00:00'),
(43,0,8,24,21,'2014-06-25 13:00:00'),
(44,0,11,22,23,'2014-06-25 13:00:00'),
(45,0,9,28,25,'2014-06-26 13:00:00'),
(46,0,2,26,27,'2014-06-26 13:00:00'),
(47,0,12,32,29,'2014-06-26 17:00:00'),
(48,0,4,30,31,'2014-06-26 17:00:00'),
(49,8,1,1,10,'2014-06-28 13:00:00'),
(50,8,10,3,12,'2014-06-28 17:00:00'),
(51,8,5,2,9,'2014-06-29 13:00:00'),
(52,8,9,4,11,'2014-06-29 17:00:00'),
(53,8,2,5,14,'2014-06-30 13:00:00'),
(54,8,8,7,16,'2014-06-30 17:00:00'),
(55,8,12,6,13,'2014-07-01 13:00:00'),
(56,8,11,8,15,'2014-07-01 17:00:00'),
(57,4,5,17,18,'2014-07-04 17:00:00'),
(58,4,10,21,22,'2014-07-04 13:00:00'),
(59,4,11,19,20,'2014-07-05 17:00:00'),
(60,4,2,23,24,'2014-07-05 13:00:00'),
(61,2,1,25,26,'2014-07-08 17:00:00'),
(62,2,12,27,28,'2014-07-09 17:00:00'),
(63,1,2,29,30,'2014-07-12 17:00:00'),
(64,1,10,31,32,'2014-07-13 17:00:00');
/*!40000 ALTER TABLE `match` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table team
# ------------------------------------------------------------
DROP TABLE IF EXISTS `team`;
CREATE TABLE `team` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`group_id` int(11) unsigned NOT NULL,
`code` varchar(3) NOT NULL DEFAULT '',
`name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `team` WRITE;
/*!40000 ALTER TABLE `team` DISABLE KEYS */;
INSERT INTO `team` (`id`, `group_id`, `code`, `name`)
VALUES
(1,1,'BRA','Brazil'),
(2,1,'HRV','Croatia'),
(3,1,'MEX','Mexico'),
(4,1,'CMR','Cameroon'),
(5,2,'ESP','Spain'),
(6,2,'NLD','Netherlands'),
(7,2,'CHL','Chile'),
(8,2,'AUS','Australia'),
(9,3,'COL','Colombia'),
(10,3,'GRC','Greece'),
(11,3,'CIV','Ivory Coast'),
(12,3,'JPN','Japan'),
(13,4,'URY','Uruguay'),
(14,4,'CRC','Costa Rica'),
(15,4,'ENG','England'),
(16,4,'ITA','Italy'),
(17,5,'CHE','Switzerland'),
(18,5,'ECU','Ecuador'),
(19,5,'FRA','France'),
(20,5,'HND','Honduras'),
(21,6,'ARG','Argentina'),
(22,6,'BIH','Bosnia and Herzegovina'),
(23,6,'IRN','Iran'),
(24,6,'NGA','Nigeria'),
(25,7,'DEU','Germany'),
(26,7,'PRT','Portugal'),
(27,7,'GHA','Ghana'),
(28,7,'USA','USA'),
(29,8,'BEL','Belgium'),
(30,8,'DZA','Algeria'),
(31,8,'RUS','Russia'),
(32,8,'KOR','Korea');
/*!40000 ALTER TABLE `team` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table venue
# ------------------------------------------------------------
DROP TABLE IF EXISTS `venue`;
CREATE TABLE `venue` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`city` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `venue` WRITE;
/*!40000 ALTER TABLE `venue` DISABLE KEYS */;
INSERT INTO `venue` (`id`, `name`, `city`)
VALUES
(1,'Estadio Mineirao','Belo Horizonte'),
(2,'Estadio Nacional','Brasilia'),
(3,'Arena Pantanal','Cuiaba'),
(4,'Arena da Baixada','Curitiba'),
(5,'Estadio Castelao','Fortaleza'),
(6,'Arena Amazonia','Manaus'),
(7,'Estadio das Dunas','Natal'),
(8,'Estadio Beira-Rio','Porto Alegre'),
(9,'Arena Pernambuco','Recife'),
(10,'Estadio do Maracana','Rio De Janeiro'),
(11,'Arena Fonte Nova','Salvador'),
(12,'Arena de Sao Paulo','Sao Paulo');
/*!40000 ALTER TABLE `venue` ENABLE KEYS */;
UNLOCK TABLES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.