# # Extension Football Prediction League - Football Backup Script # Dump of # Season 2020 # League 4 (DFB Pokal) # DATE : 24-05-2021 10:31:01 GMT # INSERT INTO phpbb_footb_leagues (season, league, league_name, league_name_short, league_type, matchdays, matches_on_matchday, win_result, win_result_02, win_matchday, win_season, points_mode, points_result, points_tendency, points_diff, points_last, join_by_user, join_in_season, bet_in_time, rules_post_id, bet_ko_type, bet_points) VALUES (2020, 4, 'DFB Pokal', 'DFB', 2, 4, 0, '0', '0', '0', '0', 1, 10, 3, 0, 1, 1, 0, 0, 1900, 1, '12.00'); INSERT INTO phpbb_footb_matchdays (season, league, matchday, status, delivery_date, delivery_date_2, delivery_date_3, matchday_name, matches) VALUES (2020, 4, 1, 3, '2019-08-09 12:00:00', '', '', '1. Runde', '32'),(2020, 4, 2, 3, '2019-10-29 12:00:00', '', '', '2. Runde', '16'),(2020, 4, 3, 3, '2020-02-04 12:00:00', '', '', 'Achtelfinale', '8'),(2020, 4, 4, 3, '2020-07-03 12:00:00', '', '', 'Viertelfinale - Finale', '7'); INSERT INTO phpbb_footb_teams (season, league, team_id, team_name, team_name_short, team_symbol, group_id, matchday) VALUES (2020, 4, 1, 'Bayern München', 'Bayern', '', '', 4),(2020, 4, 2, 'Bor. Mönchengladbach', 'Gladbach', '', '', 1),(2020, 4, 3, 'Hamburger SV', 'Hamburg', '', '', 1),(2020, 4, 4, '1. FC Nürnberg', 'Nürnberg', '', '', 1),(2020, 4, 5, 'VfL Bochum', 'Bochum', '', '', 1),(2020, 4, 6, '1. FSV Mainz 05', 'Mainz', '', '', 1),(2020, 4, 7, 'Alemannia Aachen', 'Aachen', '', '', 1),(2020, 4, 8, 'VfB Stuttgart', 'Stuttgart', '', '', 3),(2020, 4, 9, 'FC Schalke 04', 'Schalke', '', '', 4),(2020, 4, 10, 'Energie Cottbus', 'Cottbus', '', '', 1),(2020, 4, 11, 'VfL Wolfsburg', 'Wolfsburg', '', '', 1),(2020, 4, 12, 'Borussia Dortmund', 'Dortmund', '', '', 3),(2020, 4, 13, 'Eintracht Frankfurt', 'Frankfurt', '', '', 4),(2020, 4, 14, 'Bayer Leverkusen', 'Leverkusen', '', '', 4),(2020, 4, 15, 'Hannover 96', 'Hannover', '', '', 1),(2020, 4, 16, 'Hertha BSC', 'Berlin', '', '', 3),(2020, 4, 17, 'Werder Bremen', 'Bremen', '', '', 4),(2020, 4, 18, 'Arminia Bielefeld', 'Bielefeld', '', '', 1),(2020, 4, 19, '1. FC Kaiserslautern', 'Lautern', '', '', 3),(2020, 4, 21, 'Hansa Rostock', 'Rostock', '', '', 1),(2020, 4, 23, 'FC Augsburg', 'Augsburg', '', '', 1),(2020, 4, 24, '1. FC Köln', 'Köln', '', '', 1),(2020, 4, 26, 'Karlsruher SC', 'Karlsruhe', '', '', 3),(2020, 4, 27, 'SpVgg Greuther Fürth', 'Fürth', '', '', 1),(2020, 4, 28, 'SC Freiburg', 'Freiburg', '', '', 1),(2020, 4, 30, 'Erzgebirge Aue', 'Aue', '', '', 1),(2020, 4, 31, 'MSV Duisburg', 'Duisburg', '', '', 1),(2020, 4, 33, 'SC Paderborn 07', 'Paderborn', '', '', 1),(2020, 4, 38, 'Dynamo Dresden', 'Dresden', '', '', 1),(2020, 4, 40, 'VfB Lübeck', 'Lübeck', '', '', 1),(2020, 4, 42, 'VfL Osnabrück', 'Osnabrück', '', '', 1),(2020, 4, 43, 'Jahn Regensburg', 'Regensburg', '', '', 1),(2020, 4, 44, '1. FC Saarbrücken', 'Saarbrück.', '', '', 4),(2020, 4, 47, '1899 Hoffenheim', 'Hoffenheim', '', '', 3),(2020, 4, 48, 'SV Wehen Wiesbaden', 'Wehen', '', '', 1),(2020, 4, 49, 'FC St. Pauli', 'St. Pauli', '', '', 1),(2020, 4, 52, 'SC Verl', 'Verl', '', '', 3),(2020, 4, 53, 'SV Sandhausen', 'Sandhausen', '', '', 1),(2020, 4, 59, '1. FC Magdeburg', 'Magdeburg', '', '', 1),(2020, 4, 63, 'Holstein Kiel', 'Kiel', '', '', 1),(2020, 4, 66, '1. FC Union Berlin', 'Un. Berlin', '', '', 4),(2020, 4, 69, 'FC Villingen', 'Villingen', '', '', 1),(2020, 4, 70, 'SV Darmstadt 98', 'Darmstadt', '', '', 1),(2020, 4, 72, 'FC Ingolstadt 04', 'Ingolstadt', '', '', 1),(2020, 4, 74, 'FC Oberneuland', 'Oberneul.', '', '', 1),(2020, 4, 78, 'Hallescher FC', 'Halle', '', '', 1),(2020, 4, 79, 'Chemnitzer FC', 'Chemnitz', '', '', 1),(2020, 4, 85, '1. FC Heidenheim 1846', 'Heidenheim', '', '', 1),(2020, 4, 89, 'Fortuna Düsseldorf', 'Düsseldorf', '', '', 4),(2020, 4, 110, 'KFC Uerdingen 05', 'Uerdingen', '', '', 1),(2020, 4, 111, 'Waldhof Mannheim', 'Mannheim', '', '', 1),(2020, 4, 116, 'SSV Ulm 1846', 'Ulm', '', '', 1),(2020, 4, 123, 'RB Leipzig', 'RB Leipzig', '', '', 3),(2020, 4, 151, 'FC Viktoria 1889 Berlin', 'V. Berlin', '', '', 1),(2020, 4, 157, 'Würzburger Kickers', 'Würzburg K', '', '', 1),(2020, 4, 159, 'FSV Salmrohr', 'Salmrohr', '', '', 1),(2020, 4, 170, 'SV Drochtersen/Assel', 'Dr. Assel', '', '', 1),(2020, 4, 171, 'Germania Halberstadt', 'Halberst.', '', '', 1),(2020, 4, 186, 'TuS Dassendorf', 'Dassendorf', '', '', 1),(2020, 4, 189, 'SV Rödinghausen', ' Rödingh.', '', '', 1),(2020, 4, 190, 'VfB Eichstätt', 'Eichstätt', '', '', 1),(2020, 4, 191, 'KSV Baunatal', 'Baunatal', '', '', 1),(2020, 4, 192, 'Atlas Delmenhorst', 'Delmenh.', '', '', 1),(2020, 4, 193, 'Wacker Nordhausen', 'Nordhausen', '', '', 1); INSERT INTO phpbb_footb_matches (season, league, match_no, team_id_home, team_id_guest, goals_home, goals_guest, matchday, status, match_datetime, group_id, formula_home, formula_guest, ko_match, goals_overtime_home, goals_overtime_guest, trend, odd_1, odd_x, odd_2, rating) VALUES (2020, 4, 1, 31, 27, '2', '0', 1, 3, '2019-08-11 18:30:00', '', 'D', 'D', 1, '', '', '39|23|38', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 2, 21, 8, '0', '1', 1, 3, '2019-08-12 18:30:00', '', 'D', 'D', 1, '', '', '32|15|53', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 3, 26, 15, '2', '0', 1, 3, '2019-08-12 18:30:00', '', 'D', 'D', 1, '', '', '24|21|55', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 4, 111, 13, '3', '5', 1, 3, '2019-08-11 15:30:00', '', 'D', 'D', 1, '', '', '0|0|0', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 5, 110, 12, '0', '2', 1, 3, '2019-08-09 20:45:00', '', 'D', 'D', 1, '', '', '0|0|0', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 6, 40, 49, '2', '2', 1, 3, '2019-08-11 15:30:00', '', 'D', 'D', 1, '6', '7', '0|10|90', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 7, 19, 6, '2', '0', 1, 3, '2019-08-10 15:30:00', '', 'D', 'D', 1, '', '', '29|20|51', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 8, 42, 123, '2', '3', 1, 3, '2019-08-11 15:30:00', '', 'D', 'D', 1, '', '', '0|10|90', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 9, 192, 17, '1', '6', 1, 3, '2019-08-10 20:45:00', '', 'D', 'D', 1, '', '', '0|0|0', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 10, 79, 3, '2', '2', 1, 3, '2019-08-11 18:30:00', '', 'D', 'D', 1, '7', '8', '0|0|0', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 11, 193, 30, '1', '4', 1, 3, '2019-08-10 15:30:00', '', 'D', 'D', 1, '', '', '0|0|0', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 12, 10, 1, '1', '3', 1, 3, '2019-08-12 20:45:00', '', 'D', 'D', 1, '', '', '11|0|89', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 13, 116, 85, '0', '2', 1, 3, '2019-08-10 18:30:00', '', 'D', 'D', 1, '', '', '0|0|0', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 14, 52, 23, '2', '1', 1, 3, '2019-08-10 15:30:00', '', 'D', 'D', 1, '', '', '0|0|0', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 15, 44, 43, '3', '2', 1, 3, '2019-08-11 15:30:00', '', 'D', 'D', 1, '', '', '31|38|31', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 16, 7, 14, '1', '4', 1, 3, '2019-08-10 15:30:00', '', 'D', 'D', 1, '', '', '0|0|100', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 17, 159, 63, '0', '6', 1, 3, '2019-08-11 15:30:00', '', 'D', 'D', 1, '', '', '0|0|0', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 18, 48, 24, '2', '2', 1, 3, '2019-08-11 18:30:00', '', 'D', 'D', 1, '4', '5', '50|0|50', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 19, 59, 28, '0', '0', 1, 3, '2019-08-10 15:30:00', '', 'D', 'D', 1, '0', '1', '0|0|0', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 20, 53, 2, '0', '1', 1, 3, '2019-08-09 20:45:00', '', 'D', 'D', 1, '', '', '0|0|0', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 21, 74, 70, '1', '6', 1, 3, '2019-08-11 15:30:00', '', 'D', 'D', 1, '', '', '0|0|0', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 22, 186, 38, '0', '3', 1, 3, '2019-08-10 15:30:00', '', 'D', 'D', 1, '', '', '0|0|0', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 23, 69, 89, '1', '1', 1, 3, '2019-08-10 15:30:00', '', 'D', 'D', 1, '1', '3', '0|0|0', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 24, 191, 5, '2', '3', 1, 3, '2019-08-10 18:30:00', '', 'D', 'D', 1, '', '', '0|0|0', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 25, 78, 11, '3', '3', 1, 3, '2019-08-12 18:30:00', '', 'D', 'D', 1, '3', '5', '0|0|0', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 26, 171, 66, '0', '6', 1, 3, '2019-08-11 15:30:00', '', 'D', 'D', 1, '', '', '0|0|0', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 27, 157, 47, '2', '2', 1, 3, '2019-08-10 18:30:00', '', 'D', 'D', 1, '7', '8', '0|0|0', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 28, 72, 4, '0', '1', 1, 3, '2019-08-09 20:45:00', '', 'D', 'D', 1, '', '', '22|26|52', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 29, 170, 9, '0', '5', 1, 3, '2019-08-10 15:30:00', '', 'D', 'D', 1, '', '', '0|0|0', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 30, 190, 16, '1', '5', 1, 3, '2019-08-11 15:30:00', '', 'D', 'D', 1, '', '', '0|0|0', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 31, 189, 33, '3', '3', 1, 3, '2019-08-11 15:30:00', '', 'D', 'D', 1, '5', '7', '0|0|0', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 32, 151, 18, '0', '1', 1, 3, '2019-08-10 15:30:00', '', 'D', 'D', 1, '', '', '0|0|0', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 33, 31, 47, '0', '2', 2, 3, '2019-10-29 18:30:00', '', 'D', 'D', 1, '', '', '43|33|24', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 34, 17, 85, '4', '1', 2, 3, '2019-10-30 18:30:00', '', 'D', 'D', 1, '', '', '23|10|67', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 35, 28, 66, '1', '3', 2, 3, '2019-10-29 18:30:00', '', 'D', 'D', 1, '', '', '17|18|65', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 36, 5, 1, '1', '2', 2, 3, '2019-10-29 20:00:00', '', 'D', 'D', 1, '', '', '25|9|66', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 37, 14, 33, '1', '0', 2, 3, '2019-10-29 20:45:00', '', 'D', 'D', 1, '', '', '41|26|33', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 38, 18, 9, '2', '3', 2, 3, '2019-10-29 20:45:00', '', 'D', 'D', 1, '', '', '27|11|62', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 39, 3, 8, '1', '1', 2, 3, '2019-10-29 18:30:00', '', 'D', 'D', 1, '1', '2', '18|15|67', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 40, 89, 30, '2', '1', 2, 3, '2019-10-30 20:45:00', '', 'D', 'D', 1, '', '', '23|12|65', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 41, 12, 2, '2', '1', 2, 3, '2019-10-30 20:45:00', '', 'D', 'D', 1, '', '', '33|8|59', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 42, 49, 13, '1', '2', 2, 3, '2019-10-30 20:45:00', '', 'D', 'D', 1, '', '', '15|26|59', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 43, 11, 123, '1', '6', 2, 3, '2019-10-30 18:30:00', '', 'D', 'D', 1, '', '', '14|29|57', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 44, 16, 38, '1', '1', 2, 3, '2019-10-30 20:45:00', '', 'D', 'D', 1, '6', '5', '33|0|67', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 45, 19, 4, '2', '2', 2, 3, '2019-10-30 18:30:00', '', 'D', 'D', 1, '8', '7', '42|5|53', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 46, 70, 26, '0', '1', 2, 3, '2019-10-29 20:45:00', '', 'D', 'D', 1, '', '', '37|26|37', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 47, 52, 63, '1', '1', 2, 3, '2019-10-30 18:30:00', '', 'D', 'D', 1, '9', '8', '37|20|43', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 48, 44, 24, '3', '2', 2, 3, '2019-10-29 18:30:00', '', 'D', 'D', 1, '', '', '54|13|33', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 49, 13, 123, '3', '1', 3, 3, '2020-02-04 18:30:00', '', 'D', 'D', 1, '', '', '23|28|49', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 50, 14, 8, '2', '1', 3, 3, '2020-02-05 18:30:00', '', 'D', 'D', 1, '', '', '47|16|37', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 51, 1, 47, '4', '3', 3, 3, '2020-02-05 20:45:00', '', 'D', 'D', 1, '', '', '36|17|47', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 52, 9, 16, '2', '2', 3, 3, '2020-02-04 20:45:00', '', 'D', 'D', 1, '3', '2', '32|16|52', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 53, 44, 26, '0', '0', 3, 3, '2020-02-05 20:45:00', '', 'D', 'D', 1, '5', '3', '36|14|50', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 54, 17, 12, '3', '2', 3, 3, '2020-02-04 20:45:00', '', 'D', 'D', 1, '', '', '41|8|51', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 55, 19, 89, '2', '5', 3, 3, '2020-02-04 18:30:00', '', 'D', 'D', 1, '', '', '30|36|34', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 56, 52, 66, '0', '1', 3, 3, '2020-02-05 18:30:00', '', 'D', 'D', 1, '', '', '25|33|42', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 57, 14, 66, '3', '1', 4, 3, '2020-03-04 18:30:00', '', 'D', 'D', 1, '', '', '50|0|50', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 58, 9, 1, '0', '1', 4, 3, '2020-03-03 20:45:00', '', 'D', 'D', 1, '', '', '27|15|58', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 59, 13, 17, '2', '0', 4, 3, '2020-03-04 20:45:00', '', 'D', 'D', 1, '', '', '40|14|46', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 60, 44, 89, '1', '1', 4, 3, '2020-03-03 18:30:00', '', 'D', 'D', 1, '8', '7', '30|35|35', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 61, 1, 13, '2', '1', 4, 3, '2020-06-10 20:45:00', '', 'D', 'D', 1, '', '', '46|8|46', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 62, 44, 14, '0', '3', 4, 3, '2020-06-09 20:45:00', '', 'D', 'D', 1, '', '', '28|31|41', '0.00', '0.00', '0.00', '0.00'),(2020, 4, 63, 14, 1, '2', '4', 4, 3, '2020-07-04 20:00:00', '', 'W 61', 'W 62', 1, '', '', '44|11|45', '0.00', '0.00', '0.00', '0.00');