-- phpMyAdmin SQL Dump
-- version 5.2.1-1.el7.remi
-- https://www.phpmyadmin.net/
--
-- Počítač: localhost
-- Vytvořeno: Pon 15. led 2024, 12:23
-- 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 `odds`
--

CREATE TABLE `odds` (
  `ID` int(11) NOT NULL,
  `match_date` date NOT NULL,
  `match_time` time NOT NULL,
  `home_team` varchar(100) CHARACTER SET utf8 NOT NULL,
  `away_team` varchar(100) CHARACTER SET utf8 NOT NULL,
  `home_odds` float NOT NULL,
  `draw_odds` float NOT NULL,
  `away_odds` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Vypisuji data pro tabulku `odds`
--

INSERT INTO `odds` (`ID`, `match_date`, `match_time`, `home_team`, `away_team`, `home_odds`, `draw_odds`, `away_odds`) VALUES
(1, '2024-01-15', '20:45:00', 'Atalanta BC', 'Frosinone Calcio', 1.44, 4.75, 7.21),
(2, '2024-01-16', '20:45:00', 'Juventus FC', 'US Sassuolo Calcio', 1.41, 4.77, 8),
(3, '2024-01-13', '13:30:00', 'Chelsea FC', 'Fulham FC', 1.63, 4.34, 5.35),
(4, '2024-01-13', '18:30:00', 'Newcastle United FC', 'Manchester City FC', 5.23, 4.34, 1.64),
(5, '2024-01-13', '17:00:00', 'AS Monaco FC', 'Stade de Reims', 1.79, 4.12, 4.37),
(6, '2024-01-13', '21:00:00', 'Stade Rennais FC 1901', 'OGC Nice', 2.47, 3.11, 3.33),
(7, '2024-01-13', '15:30:00', 'RB Leipzig', 'Eintracht Frankfurt', 1.47, 4.94, 6.7),
(8, '2024-01-13', '15:30:00', 'SC Freiburg', '1. FC Union Berlin', 2.11, 3.59, 3.62),
(9, '2024-01-13', '15:30:00', '1. FSV Mainz 05', 'VfL Wolfsburg', 2.25, 3.5, 3.35),
(10, '2024-01-13', '15:30:00', '1. FC KÃ¶ln', '1. FC Heidenheim 1846', 2.1, 3.73, 3.52),
(11, '2024-01-13', '15:30:00', 'FC Augsburg', 'Bayer 04 Leverkusen', 5.77, 4.79, 1.54),
(12, '2024-01-13', '18:30:00', 'SV Darmstadt 98', 'Borussia Dortmund', 5.62, 4.87, 1.54),
(13, '2024-01-13', '14:00:00', 'UD Las Palmas', 'Villarreal CF', 2.51, 3.33, 2.88),
(14, '2024-01-13', '16:15:00', 'RCD Mallorca', 'RC Celta de Vigo', 2.59, 3.03, 3.21),
(15, '2024-01-13', '18:30:00', 'Athletic Club', 'Real Sociedad de FÃºtbol', 2.06, 3.25, 3.97),
(16, '2024-01-13', '21:00:00', 'Real Betis BalompiÃ©', 'Granada CF', 1.64, 3.96, 5.49),
(17, '2024-01-13', '15:00:00', 'Genoa CFC', 'Torino FC', 3.07, 2.79, 2.76),
(18, '2024-01-13', '15:00:00', 'SSC Napoli', 'US Salernitana 1919', 1.32, 5.4, 9.34),
(19, '2024-01-13', '18:00:00', 'Hellas Verona FC', 'Empoli FC', 2.17, 3.24, 3.64),
(20, '2024-01-13', '20:45:00', 'AC Monza', 'FC Internazionale Milano', 6.76, 4.48, 1.48),
(21, '2024-01-14', '15:00:00', 'Everton FC', 'Aston Villa FC', 2.75, 3.6, 2.47),
(22, '2024-01-14', '17:30:00', 'Manchester United FC', 'Tottenham Hotspur FC', 2.13, 4.11, 3.01),
(23, '2024-01-14', '13:00:00', 'Lille OSC', 'FC Lorient', 1.36, 5.02, 8.92),
(24, '2024-01-14', '15:00:00', 'FC Metz', 'Toulouse FC', 3.1, 3.02, 2.55),
(25, '2024-01-14', '15:00:00', 'FC Nantes', 'Clermont Foot 63', 2, 3.3, 4.16),
(26, '2024-01-14', '15:00:00', 'Stade Brestois 29', 'Montpellier HSC', 1.88, 3.61, 4.29),
(27, '2024-01-14', '17:05:00', 'Le Havre AC', 'Olympique Lyonnais', 3.19, 3.25, 2.35),
(28, '2024-01-14', '20:45:00', 'Racing Club de Lens', 'Paris Saint-Germain FC', 3.73, 3.99, 1.91),
(29, '2024-01-14', '15:30:00', 'VfL Bochum 1848', 'SV Werder Bremen', 2.24, 3.76, 3.01),
(30, '2024-01-14', '17:30:00', 'Borussia MÃ¶nchengladbach', 'VfB Stuttgart', 3.58, 4.11, 1.92),
(31, '2024-01-14', '14:00:00', 'UD AlmerÃ­a', 'Girona FC', 4.69, 4.41, 1.66),
(32, '2024-01-14', '16:15:00', 'CÃ¡diz CF', 'Valencia CF', 3.02, 2.87, 2.74),
(33, '2024-01-14', '12:30:00', 'SS Lazio', 'US Lecce', 1.66, 3.68, 5.78),
(34, '2024-01-14', '15:00:00', 'Cagliari Calcio', 'Bologna FC 1909', 3.23, 2.98, 2.49),
(35, '2024-01-14', '18:00:00', 'ACF Fiorentina', 'Udinese Calcio', 1.66, 3.77, 5.58),
(36, '2024-01-14', '20:45:00', 'AC Milan', 'AS Roma', 2.17, 3.2, 3.68),
(37, '2024-01-19', '20:30:00', '1. FSV Mainz 05', '1. FC Union Berlin', 2.14, 3.2, 3.46),
(38, '2024-01-19', '21:00:00', 'Deportivo AlavÃ©s', 'CÃ¡diz CF', 1.71, 3.33, 5.37),
(39, '2024-01-20', '13:30:00', 'Arsenal FC', 'Crystal Palace FC', 1.31, 5.09, 9.18),
(40, '2024-01-20', '18:30:00', 'Brentford FC', 'Nottingham Forest FC', 1.97, 3.52, 3.66),
(41, '2024-01-20', '15:30:00', 'VfL Bochum 1848', 'VfB Stuttgart', 3.55, 3.83, 1.92),
(42, '2024-01-20', '15:30:00', 'SV Darmstadt 98', 'Eintracht Frankfurt', 3.51, 3.58, 2),
(43, '2024-01-20', '15:30:00', 'SC Freiburg', 'TSG 1899 Hoffenheim', 2.01, 3.73, 3.35),
(44, '2024-01-20', '15:30:00', '1. FC Heidenheim 1846', 'VfL Wolfsburg', 2.66, 3.47, 2.49),
(45, '2024-01-20', '15:30:00', '1. FC KÃ¶ln', 'Borussia Dortmund', 4.04, 4.12, 1.75),
(46, '2024-01-20', '18:30:00', 'RB Leipzig', 'Bayer 04 Leverkusen', 2.31, 3.73, 2.75),
(47, '2024-01-20', '14:00:00', 'Rayo Vallecano de Madrid', 'UD Las Palmas', 1.9, 3.22, 4.4),
(48, '2024-01-20', '18:30:00', 'Valencia CF', 'Athletic Club', 3.32, 3.19, 2.21),
(49, '2024-01-20', '21:00:00', 'RC Celta de Vigo', 'Real Sociedad de FÃºtbol', 3.18, 2.89, 2.45),
(50, '2024-01-20', '18:00:00', 'AS Roma', 'Hellas Verona FC', 1.49, 3.98, 7.01),
(51, '2024-01-20', '20:45:00', 'Udinese Calcio', 'AC Milan', 4.01, 3.64, 1.86),
(52, '2024-01-22', '16:15:00', 'Granada CF', 'Club AtlÃ©tico de Madrid', 4.57, 3.9, 1.7);

--
-- Indexy pro exportované tabulky
--

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

--
-- AUTO_INCREMENT pro tabulky
--

--
-- AUTO_INCREMENT pro tabulku `odds`
--
ALTER TABLE `odds`
  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 */;
