Skip to content

Instantly share code, notes, and snippets.

@bacbos

bacbos/_worldcup2014.md

Last active January 2, 2016 00:48
Show Gist options
  • Save bacbos/8225634 to your computer and use it in GitHub Desktop.
Save bacbos/8225634 to your computer and use it in GitHub Desktop.
Download ZIP
FIFA Worldcup 2014 Brazil mySQL and JSON dumps, includes data for all participating teams, venues and matches
Raw
_worldcup2014.md

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

Raw
group.json
{
"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"
}
]
}
Raw
match.json
{
"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"
}
]
}
Raw
team.json
{
"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"
}
]
}
Raw
team_bracket.json
{
"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
}
]
}
Raw
venue.json
{
"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"
}
]
}
Raw
worldcup2014.sql
# 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