-- phpMyAdmin SQL Dump
-- version 5.2.1-1.el7.remi
-- https://www.phpmyadmin.net/
--
-- Počítač: localhost
-- Vytvořeno: Pon 15. led 2024, 12:25
-- Verze serveru: 5.5.68-MariaDB
-- Verze PHP: 8.0.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Databáze: `shonth22`
--

-- --------------------------------------------------------

--
-- Struktura tabulky `matchups`
--

CREATE TABLE `matchups` (
  `ID` int(11) NOT NULL,
  `match_date` date NOT NULL,
  `match_time` time NOT NULL,
  `league` varchar(100) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
  `home` varchar(100) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
  `away` varchar(100) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Vypisuji data pro tabulku `matchups`
--

INSERT INTO `matchups` (`ID`, `match_date`, `match_time`, `league`, `home`, `away`) VALUES
(1, '2024-01-15', '20:45:00', 'Serie A', 'Atalanta BC', 'Frosinone Calcio'),
(2, '2024-01-16', '20:45:00', 'Serie A', 'Juventus FC', 'US Sassuolo Calcio'),
(3, '2024-01-13', '13:30:00', 'Premier League', 'Chelsea FC', 'Fulham FC'),
(4, '2024-01-13', '18:30:00', 'Premier League', 'Newcastle United FC', 'Manchester City FC'),
(5, '2024-01-13', '17:00:00', 'Ligue 1', 'AS Monaco FC', 'Stade de Reims'),
(6, '2024-01-13', '21:00:00', 'Ligue 1', 'Stade Rennais FC 1901', 'OGC Nice'),
(7, '2024-01-13', '15:30:00', 'Bundesliga', 'RB Leipzig', 'Eintracht Frankfurt'),
(8, '2024-01-13', '15:30:00', 'Bundesliga', 'SC Freiburg', '1. FC Union Berlin'),
(9, '2024-01-13', '15:30:00', 'Bundesliga', '1. FSV Mainz 05', 'VfL Wolfsburg'),
(10, '2024-01-13', '15:30:00', 'Bundesliga', '1. FC KÃ¶ln', '1. FC Heidenheim 1846'),
(11, '2024-01-13', '15:30:00', 'Bundesliga', 'FC Augsburg', 'Bayer 04 Leverkusen'),
(12, '2024-01-13', '18:30:00', 'Bundesliga', 'SV Darmstadt 98', 'Borussia Dortmund'),
(13, '2024-01-13', '14:00:00', 'Primera Division', 'UD Las Palmas', 'Villarreal CF'),
(14, '2024-01-13', '16:15:00', 'Primera Division', 'RCD Mallorca', 'RC Celta de Vigo'),
(15, '2024-01-13', '18:30:00', 'Primera Division', 'Athletic Club', 'Real Sociedad de FÃºtbol'),
(16, '2024-01-13', '21:00:00', 'Primera Division', 'Real Betis BalompiÃ©', 'Granada CF'),
(17, '2024-01-13', '15:00:00', 'Serie A', 'Genoa CFC', 'Torino FC'),
(18, '2024-01-13', '15:00:00', 'Serie A', 'SSC Napoli', 'US Salernitana 1919'),
(19, '2024-01-13', '18:00:00', 'Serie A', 'Hellas Verona FC', 'Empoli FC'),
(20, '2024-01-13', '20:45:00', 'Serie A', 'AC Monza', 'FC Internazionale Milano'),
(21, '2024-01-14', '15:00:00', 'Premier League', 'Everton FC', 'Aston Villa FC'),
(22, '2024-01-14', '17:30:00', 'Premier League', 'Manchester United FC', 'Tottenham Hotspur FC'),
(23, '2024-01-14', '13:00:00', 'Ligue 1', 'Lille OSC', 'FC Lorient'),
(24, '2024-01-14', '15:00:00', 'Ligue 1', 'FC Metz', 'Toulouse FC'),
(25, '2024-01-14', '15:00:00', 'Ligue 1', 'FC Nantes', 'Clermont Foot 63'),
(26, '2024-01-14', '15:00:00', 'Ligue 1', 'Stade Brestois 29', 'Montpellier HSC'),
(27, '2024-01-14', '17:05:00', 'Ligue 1', 'Le Havre AC', 'Olympique Lyonnais'),
(28, '2024-01-14', '20:45:00', 'Ligue 1', 'Racing Club de Lens', 'Paris Saint-Germain FC'),
(29, '2024-01-14', '15:30:00', 'Bundesliga', 'VfL Bochum 1848', 'SV Werder Bremen'),
(30, '2024-01-14', '17:30:00', 'Bundesliga', 'Borussia MÃ¶nchengladbach', 'VfB Stuttgart'),
(31, '2024-01-14', '14:00:00', 'Primera Division', 'UD AlmerÃ­a', 'Girona FC'),
(32, '2024-01-14', '16:15:00', 'Primera Division', 'CÃ¡diz CF', 'Valencia CF'),
(33, '2024-01-14', '12:30:00', 'Serie A', 'SS Lazio', 'US Lecce'),
(34, '2024-01-14', '15:00:00', 'Serie A', 'Cagliari Calcio', 'Bologna FC 1909'),
(35, '2024-01-14', '18:00:00', 'Serie A', 'ACF Fiorentina', 'Udinese Calcio'),
(36, '2024-01-14', '20:45:00', 'Serie A', 'AC Milan', 'AS Roma'),
(37, '2024-01-19', '20:30:00', 'Bundesliga', '1. FSV Mainz 05', '1. FC Union Berlin'),
(38, '2024-01-19', '21:00:00', 'Primera Division', 'Deportivo AlavÃ©s', 'CÃ¡diz CF'),
(39, '2024-01-20', '13:30:00', 'Premier League', 'Arsenal FC', 'Crystal Palace FC'),
(40, '2024-01-20', '18:30:00', 'Premier League', 'Brentford FC', 'Nottingham Forest FC'),
(41, '2024-01-20', '15:30:00', 'Bundesliga', '1. FC KÃ¶ln', 'Borussia Dortmund'),
(42, '2024-01-20', '15:30:00', 'Bundesliga', 'SV Darmstadt 98', 'Eintracht Frankfurt'),
(43, '2024-01-20', '15:30:00', 'Bundesliga', '1. FC Heidenheim 1846', 'VfL Wolfsburg'),
(44, '2024-01-20', '15:30:00', 'Bundesliga', 'SC Freiburg', 'TSG 1899 Hoffenheim'),
(45, '2024-01-20', '15:30:00', 'Bundesliga', 'VfL Bochum 1848', 'VfB Stuttgart'),
(46, '2024-01-20', '18:30:00', 'Bundesliga', 'RB Leipzig', 'Bayer 04 Leverkusen'),
(47, '2024-01-20', '14:00:00', 'Primera Division', 'Rayo Vallecano de Madrid', 'UD Las Palmas'),
(48, '2024-01-20', '16:15:00', 'Primera Division', 'Granada CF', 'Club AtlÃ©tico de Madrid'),
(49, '2024-01-20', '18:30:00', 'Primera Division', 'Valencia CF', 'Athletic Club'),
(50, '2024-01-20', '21:00:00', 'Primera Division', 'RC Celta de Vigo', 'Real Sociedad de FÃºtbol'),
(51, '2024-01-20', '18:00:00', 'Serie A', 'AS Roma', 'Hellas Verona FC'),
(52, '2024-01-20', '20:45:00', 'Serie A', 'Udinese Calcio', 'AC Milan');

--
-- Indexy pro exportované tabulky
--

--
-- Indexy pro tabulku `matchups`
--
ALTER TABLE `matchups`
  ADD PRIMARY KEY (`ID`);

--
-- AUTO_INCREMENT pro tabulky
--

--
-- AUTO_INCREMENT pro tabulku `matchups`
--
ALTER TABLE `matchups`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
