# # Extension Football Prediction League - Football Backup Script # Dump of # Season 2019 # League 4 (DFB Pokal) # DATE : 02-06-2019 18:45:19 GMT # REPLACE 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 (2019, 4, 'DFB Pokal', 'DFB', 2, 4, 0, '0', '0', '10;8', '0', 1, 10, 3, 0, 1, 1, 0, 0, 1900, 1, 12.00); REPLACE INTO phpbb_footb_matchdays (season, league, matchday, status, delivery_date, delivery_date_2, delivery_date_3, matchday_name, matches) VALUES (2019, 4, 1, 3, '2018-08-17 12:00:00', '', '', '1. Runde', '32'),(2019, 4, 2, 3, '2018-10-30 12:00:00', '', '', '2. Runde', '16'),(2019, 4, 3, 3, '2019-02-05 12:00:00', '', '', 'Achtelfinale', '8'),(2019, 4, 4, 3, '2019-05-25 12:00:00', '', '', 'Viertelfinale - Finale', '7'); REPLACE INTO phpbb_footb_teams (season, league, team_id, team_name, team_name_short, team_symbol, group_id, matchday) VALUES (2019, 4, 1, 'Bayern München', 'Bayern', '', '', 4),(2019, 4, 2, 'Bor. Mönchengladbach', 'Gladbach', '', '', 2),(2019, 4, 3, 'Hamburger SV', 'Hamburg', '', '', 4),(2019, 4, 4, '1. FC Nürnberg', 'Nürnberg', '', '', 3),(2019, 4, 5, 'VfL Bochum', 'Bochum', '', '', 1),(2019, 4, 6, '1. FSV Mainz 05', 'Mainz', '', '', 2),(2019, 4, 8, 'VfB Stuttgart', 'Stuttgart', '', '', 1),(2019, 4, 9, 'FC Schalke 04', 'Schalke', '', '', 4),(2019, 4, 10, 'Energie Cottbus', 'Cottbus', '', '', 1),(2019, 4, 11, 'VfL Wolfsburg', 'Wolfsburg', '', '', 3),(2019, 4, 12, 'Borussia Dortmund', 'Dortmund', '', '', 3),(2019, 4, 13, 'Eintracht Frankfurt', 'Frankfurt', '', '', 1),(2019, 4, 14, 'Bayer Leverkusen', 'Leverkusen', '', '', 3),(2019, 4, 15, 'Hannover 96', 'Hannover', '', '', 2),(2019, 4, 16, 'Hertha BSC', 'Berlin', '', '', 3),(2019, 4, 17, 'Werder Bremen', 'Bremen', '', '', 4),(2019, 4, 18, 'Arminia Bielefeld', 'Bielefeld', '', '', 2),(2019, 4, 19, '1. FC Kaiserslautern', 'Lautern', '', '', 1),(2019, 4, 20, 'TSV 1860 München', 'München', '', '', 1),(2019, 4, 21, 'Hansa Rostock', 'Rostock', '', '', 2),(2019, 4, 23, 'FC Augsburg', 'Augsburg', '', '', 4),(2019, 4, 24, '1. FC Köln', 'Köln', '', '', 2),(2019, 4, 25, 'Eintracht Braunschweig', 'Braunschw.', '', '', 1),(2019, 4, 26, 'Karlsruher SC', 'Karlsruhe', '', '', 1),(2019, 4, 27, 'SpVgg Greuther Fürth', 'Fürth', '', '', 1),(2019, 4, 28, 'SC Freiburg', 'Freiburg', '', '', 2),(2019, 4, 30, 'Erzgebirge Aue', 'Aue', '', '', 1),(2019, 4, 31, 'MSV Duisburg', 'Duisburg', '', '', 3),(2019, 4, 33, 'SC Paderborn 07', 'Paderborn', '', '', 4),(2019, 4, 36, 'Carl Zeiss Jena', 'Jena', '', '', 1),(2019, 4, 38, 'Dynamo Dresden', 'Dresden', '', '', 1),(2019, 4, 41, 'Rot-Weiß Oberhausen', 'Oberhausen', '', '', 1),(2019, 4, 43, 'Jahn Regensburg', 'Regensburg', '', '', 1),(2019, 4, 47, '1899 Hoffenheim', 'Hoffenheim', '', '', 2),(2019, 4, 48, 'SV Wehen Wiesbaden', 'Wehen', '', '', 2),(2019, 4, 49, 'FC St. Pauli', 'St. Pauli', '', '', 1),(2019, 4, 53, 'SV Sandhausen', 'Sandhausen', '', '', 2),(2019, 4, 59, '1. FC Magdeburg', 'Magdeburg', '', '', 1),(2019, 4, 63, 'Holstein Kiel', 'Kiel', '', '', 3),(2019, 4, 66, '1. FC Union Berlin', 'Un. Berlin', '', '', 2),(2019, 4, 68, 'Wormatia Worms', 'Worms', '', '', 1),(2019, 4, 70, 'SV Darmstadt 98', 'Darmstadt', '', '', 2),(2019, 4, 72, 'FC Ingolstadt 04', 'Ingolstadt', '', '', 1),(2019, 4, 85, '1. FC Heidenheim 1846', 'Heidenheim', '', '', 4),(2019, 4, 89, 'Fortuna Düsseldorf', 'Düsseldorf', '', '', 3),(2019, 4, 96, 'SV 07 Elversberg', 'Elversberg', '', '', 1),(2019, 4, 116, 'SSV Ulm 1846', 'Ulm', '', '', 2),(2019, 4, 123, 'RB Leipzig', 'RB Leipzig', '', '', 4),(2019, 4, 128, 'BFC Dynamo', 'BFC Dynamo', '', '', 1),(2019, 4, 156, 'Viktoria Köln', 'Vikt. Köln', '', '', 1),(2019, 4, 163, 'TuS Erndtebrück', 'Erndtebr.', '', '', 1),(2019, 4, 170, 'SV Drochtersen/Assel', 'Dr. Assel', '', '', 1),(2019, 4, 175, '1. FC Schweinfurt 05', 'Schweinf.', '', '', 1),(2019, 4, 179, '1. FC Lok Stendal', 'Stendal', '', '', 1),(2019, 4, 180, 'SC Weiche Flensburg 08', 'Flensburg', '', '', 2),(2019, 4, 181, '1. CfR Pforzheim', 'Pforzheim', '', '', 1),(2019, 4, 182, 'SV Linx', 'Linx', '', '', 1),(2019, 4, 183, 'SSV Jeddeloh', 'Jeddeloh', '', '', 1),(2019, 4, 184, 'Rot-Weiß Koblenz', 'RW Koblenz', '', '', 1),(2019, 4, 185, 'BSC Hastedt', 'Hastedt', '', '', 1),(2019, 4, 186, 'TuS Dassendorf', 'Dassendorf', '', '', 1),(2019, 4, 187, 'BSG Chemie Leipzig', 'Ch Leipzig', '', '', 2),(2019, 4, 188, 'TSV Steinbach', 'Steinbach', '', '', 1),(2019, 4, 189, 'SV Rödinghausen', ' Rödingh.', '', '', 2); REPLACE 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 (2019, 4, 1, 182, 4, '1', '2', 1, 3, '2018-08-18 15:30:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 2, 48, 49, '1', '1', 1, 3, '2018-08-17 20:45:00', '', 'D', 'D', 1, '3', '2', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 3, 189, 38, '2', '2', 1, 3, '2018-08-18 15:30:00', '', 'D', 'D', 1, '3', '2', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 4, 59, 70, '0', '1', 1, 3, '2018-08-17 20:45:00', '', 'D', 'D', 1, '', '', '0|0|0', 0.00, 0.00, 0.00, 0.00),(2019, 4, 5, 179, 18, '0', '5', 1, 3, '2018-08-19 15:30:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 6, 163, 3, '3', '5', 1, 3, '2018-08-18 18:30:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 7, 188, 23, '1', '2', 1, 3, '2018-08-19 15:30:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 8, 184, 89, '0', '5', 1, 3, '2018-08-19 15:30:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 9, 27, 12, '1', '1', 1, 3, '2018-08-20 20:45:00', '', 'D', 'D', 1, '1', '2', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 10, 20, 63, '1', '3', 1, 3, '2018-08-19 18:30:00', '', 'D', 'D', 1, '', '', '90|10|0', 0.00, 0.00, 0.00, 0.00),(2019, 4, 11, 41, 53, '0', '6', 1, 3, '2018-08-18 18:30:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 12, 30, 6, '1', '3', 1, 3, '2018-08-18 18:30:00', '', 'D', 'D', 1, '', '', '15|45|40', 0.00, 0.00, 0.00, 0.00),(2019, 4, 13, 180, 5, '1', '0', 1, 3, '2018-08-19 15:30:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 14, 187, 43, '2', '1', 1, 3, '2018-08-19 15:30:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 15, 96, 11, '0', '1', 1, 3, '2018-08-18 15:30:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 16, 186, 31, '0', '1', 1, 3, '2018-08-18 15:30:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 17, 175, 9, '0', '2', 1, 3, '2018-08-17 20:45:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 18, 128, 24, '1', '9', 1, 3, '2018-08-19 15:30:00', '', 'D', 'D', 1, '', '', '0|0|0', 0.00, 0.00, 0.00, 0.00),(2019, 4, 19, 68, 17, '1', '6', 1, 3, '2018-08-18 15:30:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 20, 170, 1, '0', '1', 1, 3, '2018-08-18 15:30:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 21, 183, 85, '2', '5', 1, 3, '2018-08-19 15:30:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 22, 19, 47, '1', '6', 1, 3, '2018-08-18 15:30:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 23, 156, 123, '1', '3', 1, 3, '2018-08-19 15:30:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 24, 36, 66, '2', '4', 1, 3, '2018-08-19 18:30:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 25, 33, 72, '2', '1', 1, 3, '2018-08-20 18:30:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 26, 185, 2, '1', '11', 1, 3, '2018-08-19 18:30:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 27, 10, 28, '2', '2', 1, 3, '2018-08-20 18:30:00', '', 'D', 'D', 1, '5', '7', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 28, 26, 15, '0', '6', 1, 3, '2018-08-19 15:30:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 29, 25, 16, '1', '2', 1, 3, '2018-08-20 18:30:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 30, 21, 8, '2', '0', 1, 3, '2018-08-18 20:45:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 31, 181, 14, '0', '1', 1, 3, '2018-08-18 15:30:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 32, 116, 13, '2', '1', 1, 3, '2018-08-18 15:30:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 33, 21, 4, '1', '1', 2, 3, '2018-10-31 18:30:00', '', 'D', 'D', 1, '3', '5', '36|20|44', 0.00, 0.00, 0.00, 0.00),(2019, 4, 34, 180, 17, '1', '5', 2, 3, '2018-10-31 18:30:00', '', 'D', 'D', 1, '', '', '37|20|43', 0.00, 0.00, 0.00, 0.00),(2019, 4, 35, 187, 33, '0', '3', 2, 3, '2018-10-30 18:30:00', '', 'D', 'D', 1, '', '', '53|20|27', 0.00, 0.00, 0.00, 0.00),(2019, 4, 36, 116, 89, '1', '5', 2, 3, '2018-10-30 18:30:00', '', 'D', 'D', 1, '', '', '37|20|43', 0.00, 0.00, 0.00, 0.00),(2019, 4, 37, 48, 3, '0', '3', 2, 3, '2018-10-30 20:45:00', '', 'D', 'D', 1, '', '', '17|23|60', 0.00, 0.00, 0.00, 0.00),(2019, 4, 38, 189, 1, '1', '2', 2, 3, '2018-10-30 20:45:00', '', 'D', 'D', 1, '', '', '17|33|50', 0.00, 0.00, 0.00, 0.00),(2019, 4, 39, 63, 28, '2', '1', 2, 3, '2018-10-31 20:45:00', '', 'D', 'D', 1, '', '', '32|33|35', 0.00, 0.00, 0.00, 0.00),(2019, 4, 40, 18, 31, '0', '3', 2, 3, '2018-10-31 20:45:00', '', 'D', 'D', 1, '', '', '26|20|54', 0.00, 0.00, 0.00, 0.00),(2019, 4, 41, 85, 53, '3', '0', 2, 3, '2018-10-30 20:45:00', '', 'D', 'D', 1, '', '', '23|35|42', 0.00, 0.00, 0.00, 0.00),(2019, 4, 42, 123, 47, '2', '0', 2, 3, '2018-10-31 20:45:00', '', 'D', 'D', 1, '', '', '28|15|57', 0.00, 0.00, 0.00, 0.00),(2019, 4, 43, 24, 9, '1', '1', 2, 3, '2018-10-31 18:30:00', '', 'D', 'D', 1, '6', '7', '26|18|56', 0.00, 0.00, 0.00, 0.00),(2019, 4, 44, 15, 11, '0', '2', 2, 3, '2018-10-30 18:30:00', '', 'D', 'D', 1, '', '', '26|15|59', 0.00, 0.00, 0.00, 0.00),(2019, 4, 45, 70, 16, '0', '2', 2, 3, '2018-10-30 18:45:00', '', 'D', 'D', 1, '', '', '29|0|71', 0.00, 0.00, 0.00, 0.00),(2019, 4, 46, 2, 14, '0', '5', 2, 3, '2018-10-31 20:45:00', '', 'D', 'D', 1, '', '', '23|26|51', 0.00, 0.00, 0.00, 0.00),(2019, 4, 47, 23, 6, '2', '2', 2, 3, '2018-10-30 20:45:00', '', 'D', 'D', 1, '3', '2', '26|17|57', 0.00, 0.00, 0.00, 0.00),(2019, 4, 48, 12, 66, '2', '2', 2, 3, '2018-10-31 18:30:00', '', 'D', 'D', 1, '3', '2', '10|48|42', 0.00, 0.00, 0.00, 0.00),(2019, 4, 49, 3, 4, '1', '0', 3, 3, '2019-02-05 18:30:00', '', 'D', 'D', 1, '', '', '34|21|45', 0.00, 0.00, 0.00, 0.00),(2019, 4, 50, 85, 14, '2', '1', 3, 3, '2019-02-05 18:30:00', '', 'D', 'D', 1, '', '', '37|20|43', 0.00, 0.00, 0.00, 0.00),(2019, 4, 51, 31, 33, '1', '3', 3, 3, '2019-02-05 20:45:00', '', 'D', 'D', 1, '', '', '33|10|57', 0.00, 0.00, 0.00, 0.00),(2019, 4, 52, 12, 17, '1', '1', 3, 3, '2019-02-05 20:45:00', '', 'D', 'D', 1, '5', '7', '26|17|57', 0.00, 0.00, 0.00, 0.00),(2019, 4, 53, 63, 23, '0', '1', 3, 3, '2019-02-06 18:30:00', '', 'D', 'D', 1, '', '', '33|33|34', 0.00, 0.00, 0.00, 0.00),(2019, 4, 54, 123, 11, '1', '0', 3, 3, '2019-02-06 18:30:00', '', 'D', 'D', 1, '', '', '43|8|49', 0.00, 0.00, 0.00, 0.00),(2019, 4, 55, 9, 89, '4', '1', 3, 3, '2019-02-06 20:45:00', '', 'D', 'D', 1, '', '', '25|25|50', 0.00, 0.00, 0.00, 0.00),(2019, 4, 56, 16, 1, '2', '2', 3, 3, '2019-02-06 20:45:00', '', 'D', 'D', 1, '2', '3', '24|15|61', 0.00, 0.00, 0.00, 0.00),(2019, 4, 57, 9, 17, '0', '2', 4, 3, '2019-04-03 20:45:00', '', 'D', 'D', 1, '', '', '39|21|40', 0.00, 0.00, 0.00, 0.00),(2019, 4, 58, 1, 85, '5', '4', 4, 3, '2019-04-03 18:30:00', '', 'D', 'D', 1, '', '', '18|29|53', 0.00, 0.00, 0.00, 0.00),(2019, 4, 59, 33, 3, '0', '2', 4, 3, '2019-04-02 18:30:00', '', 'D', 'D', 1, '', '', '45|0|55', 0.00, 0.00, 0.00, 0.00),(2019, 4, 60, 23, 123, '1', '1', 4, 3, '2019-04-02 20:45:00', '', 'D', 'D', 1, '1', '2', '27|25|48', 0.00, 0.00, 0.00, 0.00),(2019, 4, 61, 17, 1, '2', '3', 4, 3, '2019-04-24 20:45:00', '', 'D', 'D', 1, '', '', '', 0.00, 0.00, 0.00, 0.00),(2019, 4, 62, 3, 123, '1', '3', 4, 3, '2019-04-23 20:45:00', '', 'D', 'D', 1, '', '', '37|18|45', 0.00, 0.00, 0.00, 0.00),(2019, 4, 63, 123, 1, '0', '3', 4, 3, '2019-05-25 20:00:00', '', 'W 61', 'W 62', 1, '', '', '', 0.00, 0.00, 0.00, 0.00);