Data for Euro 2020 for the Wordpress World Cup Predictor plugin (https://wordpress.org/plugins/world-cup-predictor/)

euro-2020-inserts.sql

INSERT INTO `wp_wcup_venue` (`venue_id`, `venue_name`, `venue_url`, `stadium`, `tz_offset`, `wwhen`) VALUES
(1, 'Rome', 'https://www.uefa.com/uefaeuro-2020/event-guide/rome/', 'Stadio Olimpico', +1, '2021-05-14 00:00:00'),
(2, 'Baku', 'https://www.uefa.com/uefaeuro-2020/event-guide/baku/', 'Olympic Stadium', +4, '2021-05-14 00:00:00'),
(3, 'Copenhagen', 'https://www.uefa.com/uefaeuro-2020/event-guide/copenhagen/', 'Parken Stadium', +1, '2021-05-14 00:00:00'),
(4, 'St Petersburg', 'https://www.uefa.com/uefaeuro-2020/event-guide/saint-petersburg/', 'Krestovsky Stadium', +3, '2021-05-14 00:00:00'),
(5, 'London', 'https://www.uefa.com/uefaeuro-2020/event-guide/london/', 'Wembley Stadium', +0, '2021-05-14 00:00:00'),
(6, 'Bucharest', 'https://www.uefa.com/uefaeuro-2020/event-guide/bucharest/', 'Arena Națională', +2, '2021-05-14 00:00:00'),
(7, 'Amsterdam', 'https://www.uefa.com/uefaeuro-2020/event-guide/amsterdam/', 'Johan Cruyff Arena', +1, '2021-05-14 00:00:00'),
(8, 'Glasgow', 'https://www.uefa.com/uefaeuro-2020/event-guide/glasgow/', 'Hampden Park', +0, '2021-05-14 00:00:00'),
(9, 'Seville', 'https://www.uefa.com/uefaeuro-2020/event-guide/seville/', 'Estadio La Cartuja', +1, '2021-05-14 00:00:00'),
(10, 'Budapest', 'https://www.uefa.com/uefaeuro-2020/event-guide/budapest/', 'Puskás Aréna', +1, '2021-05-14 00:00:00'),
(11, 'Munich', 'https://www.uefa.com/uefaeuro-2020/event-guide/munich/', 'Allianz Arena', +1, '2021-05-14 00:00:00');


INSERT INTO `wp_wcup_team` (`team_id`, `name`, `country`, `team_url`, `group_order`, `wwhen`) VALUES
(1, 'Austria', 'at', 'https://www.uefa.com/uefaeuro-2020/teams/8--austria/', 0, '2021-05-14 00:00:00'),
(2, 'Belgium', 'be', 'https://www.uefa.com/uefaeuro-2020/teams/13--belgium/', 0, '2021-05-14 00:00:00'),
(3, 'Croatia', 'hr', 'https://www.uefa.com/uefaeuro-2020/teams/56370--croatia/', 0, '2021-05-14 00:00:00'),
(4, 'Czech Republic', 'cz', 'https://www.uefa.com/uefaeuro-2020/teams/58837--czech-republic/', 0, '2021-05-14 00:00:00'),
(5, 'Denmark', 'dk', 'https://www.uefa.com/uefaeuro-2020/teams/35--denmark/', 0, '2021-05-14 00:00:00'),
(6, 'England', 'en', 'https://www.uefa.com/uefaeuro-2020/teams/39--england/', 0, '2021-05-14 00:00:00'),
(7, 'Finland', 'fi', 'https://www.uefa.com/uefaeuro-2020/teams/42--finland/', 0, '2021-05-14 00:00:00'),
(8, 'France', 'fr', 'https://www.uefa.com/uefaeuro-2020/teams/43--france/', 0, '2021-05-14 00:00:00'),
(9, 'Germany', 'de', 'https://www.uefa.com/uefaeuro-2020/teams/47--germany/', 0, '2021-05-14 00:00:00'),
(10, 'Hungary', 'hu', 'https://www.uefa.com/uefaeuro-2020/teams/57--hungary/', 0, '2021-05-14 00:00:00'),
(11, 'Italy', 'it', 'https://www.uefa.com/uefaeuro-2020/teams/66--italy/', 0, '2021-05-14 00:00:00'),
(12, 'Netherlands', 'nl', 'https://www.uefa.com/uefaeuro-2020/teams/95--netherlands/', 0, '2021-05-14 00:00:00'),
(13, 'North Macedonia', 'mk', 'https://www.uefa.com/uefaeuro-2020/teams/59205--north-macedonia/', 0, '2021-05-14 00:00:00'),
(14, 'Poland', 'pl', 'https://www.uefa.com/uefaeuro-2020/teams/109--poland/', 0, '2021-05-14 00:00:00'),
(15, 'Portugal', 'pt', 'https://www.uefa.com/uefaeuro-2020/teams/110--portugal/', 0, '2021-05-14 00:00:00'),
(16, 'Russia', 'ru', 'https://www.uefa.com/uefaeuro-2020/teams/57451--russia/', 0, '2021-05-14 00:00:00'),
(17, 'Scotland', 'sco', 'https://www.uefa.com/uefaeuro-2020/teams/117--scotland/', 0, '2021-05-14 00:00:00'),
(18, 'Slovakia', 'sk', 'https://www.uefa.com/uefaeuro-2020/teams/58836--slovakia/', 0, '2021-05-14 00:00:00'),
(19, 'Spain', 'es', 'https://www.uefa.com/uefaeuro-2020/teams/122--spain/', 0, '2021-05-14 00:00:00'),
(20, 'Sweden', 'se', 'https://www.uefa.com/uefaeuro-2020/teams/127--sweden/', 0, '2021-05-14 00:00:00'),
(21, 'Switzerland', 'ch', 'https://www.uefa.com/uefaeuro-2020/teams/128--switzerland/', 0, '2021-05-14 00:00:00'),
(22, 'Turkey', 'tr', 'https://www.uefa.com/uefaeuro-2020/teams/135--turkey/', 0, '2021-05-14 00:00:00'),
(23, 'Ukraine', 'ua', 'https://www.uefa.com/uefaeuro-2020/teams/57166--ukraine/', 0, '2021-05-14 00:00:00'),
(24, 'Wales', 'cym', 'https://www.uefa.com/uefaeuro-2020/teams/144--wales/', 0, '2021-05-14 00:00:00'),
(25, 'Winner Group A', 'xxx', '', 0, '2021-05-14 00:00:00'),
(26, 'Winner Group B', 'xxx', '', 0, '2021-05-14 00:00:00'),
(27, 'Winner Group C', 'xxx', '', 0, '2021-05-14 00:00:00'),
(28, 'Winner Group D', 'xxx', '', 0, '2021-05-14 00:00:00'),
(29, 'Winner Group E', 'xxx', '', 0, '2021-05-14 00:00:00'),
(30, 'Winner Group F', 'xxx', '', 0, '2021-05-14 00:00:00'),
(31, 'Runner-Up Group A', 'xxx', '', 0, '2021-05-14 00:00:00'),
(32, 'Runner-Up Group B', 'xxx', '', 0, '2021-05-14 00:00:00'),
(33, 'Runner-Up Group C', 'xxx', '', 0, '2021-05-14 00:00:00'),
(34, 'Runner-Up Group D', 'xxx', '', 0, '2021-05-14 00:00:00'),
(35, 'Runner-Up Group E', 'xxx', '', 0, '2021-05-14 00:00:00'),
(36, 'Runner-Up Group F', 'xxx', '', 0, '2021-05-14 00:00:00'),
(37, '3rd Group A/B/C', 'xxx', '', 0, '2021-05-14 00:00:00'),
(38, '3rd Group A/B/C/D', 'xxx', '', 0, '2021-05-14 00:00:00'),
(39, '3rd Group A/D/E/F', 'xxx', '', 0, '2021-05-14 00:00:00'),
(40, '3rd Group D/E/F', 'xxx', '', 0, '2021-05-14 00:00:00'),
(41, 'Winner Match 37', 'xxx', '', 0, '2021-05-14 00:00:00'),
(42, 'Winner Match 38', 'xxx', '', 0, '2021-05-14 00:00:00'),
(43, 'Winner Match 39', 'xxx', '', 0, '2021-05-14 00:00:00'),
(44, 'Winner Match 40', 'xxx', '', 0, '2021-05-14 00:00:00'),
(45, 'Winner Match 41', 'xxx', '', 0, '2021-05-14 00:00:00'),
(46, 'Winner Match 42', 'xxx', '', 0, '2021-05-14 00:00:00'),
(47, 'Winner Match 43', 'xxx', '', 0, '2021-05-14 00:00:00'),
(48, 'Winner Match 44', 'xxx', '', 0, '2021-05-14 00:00:00'),
(49, 'Winner Match 45', 'xxx', '', 0, '2021-05-14 00:00:00'),
(50, 'Winner Match 46', 'xxx', '', 0, '2021-05-14 00:00:00'),
(51, 'Winner Match 47', 'xxx', '', 0, '2021-05-14 00:00:00'),
(52, 'Winner Match 48', 'xxx', '', 0, '2021-05-14 00:00:00'),
(53, 'Winner Match 49', 'xxx', '', 0, '2021-05-14 00:00:00'),
(54, 'Winner Match 50', 'xxx', '', 0, '2021-05-14 00:00:00');

INSERT INTO `wp_wcup_stage` (`stage_id`, `stage_name`, `is_group`, `sort_order`, `wwhen`) VALUES
(1, 'Group A', 1, 1, '2021-05-14 00:00:00'),
(2, 'Group B', 1, 2, '2021-05-14 00:00:00'),
(3, 'Group C', 1, 3, '2021-05-14 00:00:00'),
(4, 'Group D', 1, 4, '2021-05-14 00:00:00'),
(5, 'Group E', 1, 5, '2021-05-14 00:00:00'),
(6, 'Group F', 1, 6, '2021-05-14 00:00:00'),
(7, 'Last 16', 0, 0, '2021-05-14 00:00:00'),
(8, 'Quarter Final', 0, 0, '2021-05-14 00:00:00'),
(9, 'Semi Final', 0, 0, '2021-05-14 00:00:00'),
(10, 'Final', 0, 0, '2021-05-14 00:00:00');


INSERT INTO `wp_wcup_match` (`match_id`, `match_no`, `kickoff`, `home_team_id`, `away_team_id`, `home_goals`, `away_goals`, `home_penalties`, `away_penalties`, `venue_id`, `is_result`, `extra_time`, `stage_id`, `scored`, `wwhen`) VALUES
(1, 1, '2021-06-11 19:00:00', 22, 11, 0, 0, 0, 0, 1, 0, 0, 1, 0, '2021-05-14 00:00:00'),
(2, 2, '2021-06-12 13:00:00', 24, 21, 0, 0, 0, 0, 2, 0, 0, 1, 0, '2021-05-14 00:00:00'),
(3, 3, '2021-06-12 16:00:00', 5, 7, 0, 0, 0, 0, 3, 0, 0, 2, 0, '2021-05-14 00:00:00'),
(4, 4, '2021-06-12 19:00:00', 2, 16, 0, 0, 0, 0, 4, 0, 0, 2, 0, '2021-05-14 00:00:00'),
(5, 5, '2021-06-13 19:00:00', 12, 23, 0, 0, 0, 0, 7, 0, 0, 3, 0, '2021-05-14 00:00:00'),
(6, 6, '2021-06-13 16:00:00', 1, 13, 0, 0, 0, 0, 6, 0, 0, 3, 0, '2021-05-14 00:00:00'),
(7, 7, '2021-06-13 13:00:00', 6, 3, 0, 0, 0, 0, 5, 0, 0, 4, 0, '2021-05-14 00:00:00'),
(8, 8, '2021-06-14 13:00:00', 17, 4, 0, 0, 0, 0, 8, 0, 0, 4, 0, '2021-05-14 00:00:00'),
(9, 9, '2021-06-14 19:00:00', 19, 20, 0, 0, 0, 0, 9, 0, 0, 5, 0, '2021-05-14 00:00:00'),
(10, 10, '2021-06-14 16:00:00', 14, 18, 0, 0, 0, 0, 4, 0, 0, 5, 0, '2021-05-14 00:00:00'),
(11, 11, '2021-06-15 16:00:00', 10, 15, 0, 0, 0, 0, 10, 0, 0, 6, 0, '2021-05-14 00:00:00'),
(12, 12, '2021-06-15 19:00:00', 8, 9, 0, 0, 0, 0, 11, 0, 0, 6, 0, '2021-05-14 00:00:00'),
(13, 13, '2021-06-16 16:00:00', 22, 24, 0, 0, 0, 0, 2, 0, 0, 1, 0, '2021-05-14 00:00:00'),
(14, 14, '2021-06-16 19:00:00', 11, 21, 0, 0, 0, 0, 1, 0, 0, 1, 0, '2021-05-14 00:00:00'),
(15, 15, '2021-06-16 13:00:00', 7, 16, 0, 0, 0, 0, 4, 0, 0, 2, 0, '2021-05-14 00:00:00'),
(16, 16, '2021-06-17 16:00:00', 5, 2, 0, 0, 0, 0, 3, 0, 0, 2, 0, '2021-05-14 00:00:00'),
(17, 17, '2021-06-17 19:00:00', 12, 1, 0, 0, 0, 0, 7, 0, 0, 3, 0, '2021-05-14 00:00:00'),
(18, 18, '2021-06-17 13:00:00', 23, 13, 0, 0, 0, 0, 6, 0, 0, 3, 0, '2021-05-14 00:00:00'),
(19, 19, '2021-06-18 16:00:00', 3, 4, 0, 0, 0, 0, 8, 0, 0, 4, 0, '2021-05-14 00:00:00'),
(20, 20, '2021-06-18 19:00:00', 6, 17, 0, 0, 0, 0, 5, 0, 0, 4, 0, '2021-05-14 00:00:00'),
(21, 21, '2021-06-18 13:00:00', 20, 18, 0, 0, 0, 0, 4, 0, 0, 5, 0, '2021-05-14 00:00:00'),
(22, 22, '2021-06-19 19:00:00', 19, 14, 0, 0, 0, 0, 9, 0, 0, 5, 0, '2021-05-14 00:00:00'),
(23, 23, '2021-06-19 13:00:00', 10, 8, 0, 0, 0, 0, 10, 0, 0, 6, 0, '2021-05-14 00:00:00'),
(24, 24, '2021-06-19 16:00:00', 15, 9, 0, 0, 0, 0, 11, 0, 0, 6, 0, '2021-05-14 00:00:00'),
(25, 25, '2021-06-20 16:00:00', 21, 22, 0, 0, 0, 0, 2, 0, 0, 1, 0, '2021-05-14 00:00:00'),
(26, 26, '2021-06-20 16:00:00', 11, 24, 0, 0, 0, 0, 1, 0, 0, 1, 0, '2021-05-14 00:00:00'),
(27, 27, '2021-06-21 19:00:00', 16, 5, 0, 0, 0, 0, 3, 0, 0, 2, 0, '2021-05-14 00:00:00'),
(28, 28, '2021-06-21 19:00:00', 7, 2, 0, 0, 0, 0, 4, 0, 0, 2, 0, '2021-05-14 00:00:00'),
(29, 29, '2021-06-21 16:00:00', 13, 12, 0, 0, 0, 0, 7, 0, 0, 3, 0, '2021-05-14 00:00:00'),
(30, 30, '2021-06-21 16:00:00', 23, 1, 0, 0, 0, 0, 6, 0, 0, 3, 0, '2021-05-14 00:00:00'),
(31, 31, '2021-06-22 19:00:00', 3, 17, 0, 0, 0, 0, 8, 0, 0, 4, 0, '2021-05-14 00:00:00'),
(32, 32, '2021-06-22 19:00:00', 4, 6, 0, 0, 0, 0, 5, 0, 0, 4, 0, '2021-05-14 00:00:00'),
(33, 33, '2021-06-23 16:00:00', 18, 19, 0, 0, 0, 0, 9, 0, 0, 5, 0, '2021-05-14 00:00:00'),
(34, 34, '2021-06-23 16:00:00', 20, 14, 0, 0, 0, 0, 4, 0, 0, 5, 0, '2021-05-14 00:00:00'),
(35, 35, '2021-06-23 19:00:00', 15, 8, 0, 0, 0, 0, 10, 0, 0, 6, 0, '2021-05-14 00:00:00'),
(36, 36, '2021-06-23 19:00:00', 9, 10, 0, 0, 0, 0, 11, 0, 0, 6, 0, '2021-05-14 00:00:00'),
(37, 37, '2021-06-26 19:00:00', 25, 33, 0, 0, 0, 0, 5, 0, 0, 7, 0, '2021-05-14 00:00:00'),
(38, 38, '2021-06-26 16:00:00', 31, 32, 0, 0, 0, 0, 7, 0, 0, 7, 0, '2021-05-14 00:00:00'),
(39, 39, '2021-06-27 19:00:00', 26, 39, 0, 0, 0, 0, 9, 0, 0, 7, 0, '2021-05-14 00:00:00'),
(40, 40, '2021-06-27 16:00:00', 27, 40, 0, 0, 0, 0, 10, 0, 0, 7, 0, '2021-05-14 00:00:00'),
(41, 41, '2021-06-28 19:00:00', 30, 37, 0, 0, 0, 0, 6, 0, 0, 7, 0, '2021-05-14 00:00:00'),
(42, 42, '2021-06-28 16:00:00', 34, 35, 0, 0, 0, 0, 3, 0, 0, 7, 0, '2021-05-14 00:00:00'),
(43, 43, '2021-06-29 19:00:00', 29, 38, 0, 0, 0, 0, 8, 0, 0, 7, 0, '2021-05-14 00:00:00'),
(44, 44, '2021-06-29 16:00:00', 28, 36, 0, 0, 0, 0, 5, 0, 0, 7, 0, '2021-05-14 00:00:00'),
(45, 45, '2021-07-02 16:00:00', 45, 46, 0, 0, 0, 0, 4, 0, 0, 8, 0, '2021-05-14 00:00:00'),
(46, 46, '2021-07-02 19:00:00', 43, 41, 0, 0, 0, 0, 11, 0, 0, 8, 0, '2021-05-14 00:00:00'),
(47, 47, '2021-07-03 16:00:00', 44, 42, 0, 0, 0, 0, 2, 0, 0, 8, 0, '2021-05-14 00:00:00'),
(48, 48, '2021-07-03 19:00:00', 47, 48, 0, 0, 0, 0, 1, 0, 0, 8, 0, '2021-05-14 00:00:00'),
(49, 49, '2021-07-06 19:00:00', 50, 49, 0, 0, 0, 0, 5, 0, 0, 9, 0, '2021-05-14 00:00:00'),
(50, 50, '2021-07-07 19:00:00', 52, 51, 0, 0, 0, 0, 5, 0, 0, 9, 0, '2021-05-14 00:00:00'),
(51, 51, '2021-07-11 19:00:00', 53, 54, 0, 0, 0, 0, 5, 0, 0, 10, 0, '2021-05-14 00:00:00');