-- phpMyAdmin SQL Dump
-- version 5.2.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Tempo de geração: 26/02/2026 às 18:08
-- Versão do servidor: 8.4.8
-- Versão do PHP: 8.4.16

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 */;

--
-- Banco de dados: `virtual_football`
--

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

--
-- Estrutura para tabela `matches`
--

CREATE TABLE `matches` (
  `id_jogo` int NOT NULL,
  `time_casa` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `time_fora` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `placar_casa` int DEFAULT NULL,
  `placar_fora` int DEFAULT NULL,
  `data_jogo` datetime DEFAULT (now())
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Despejando dados para a tabela `matches`
--

INSERT INTO `matches` (`id_jogo`, `time_casa`, `time_fora`, `placar_casa`, `placar_fora`, `data_jogo`) VALUES
(30248362, 'ARS', 'FUL', 1, 3, '2026-02-26 11:00:00'),
(30248363, 'LIV', 'MNC', 0, 1, '2026-02-26 11:02:00'),
(30248364, 'NEW', 'CHE', 1, 1, '2026-02-26 11:04:00'),
(30248447, 'CRY', 'NOT', 1, 1, '2026-02-26 11:06:00'),
(30248448, 'LEE', 'BUR', 3, 1, '2026-02-26 11:08:00'),
(30248449, 'ARS', 'BHA', 0, 1, '2026-02-26 11:10:00'),
(30248450, 'AST', 'SUN', 2, 0, '2026-02-26 11:12:00'),
(30248451, 'MNC', 'CHE', 1, 1, '2026-02-26 11:14:00'),
(30248452, 'NEW', 'NOT', 0, 1, '2026-02-26 11:16:00'),
(30248534, 'CRY', 'LEE', 0, 0, '2026-02-26 11:20:00'),
(30248535, 'EVE', 'BRE', 1, 3, '2026-02-26 11:18:00'),
(30248536, 'BHA', 'FUL', 0, 1, '2026-02-26 11:22:00'),
(30248537, 'MNC', 'BOU', 1, 0, '2026-02-26 11:24:00'),
(30248538, 'AST', 'CRY', 3, 2, '2026-02-26 11:28:00'),
(30248539, 'NEW', 'WHU', 3, 2, '2026-02-26 11:26:00'),
(30248619, 'BRE', 'BUR', 2, 0, '2026-02-26 11:32:00'),
(30248620, 'MNC', 'BHA', 2, 1, '2026-02-26 11:34:00'),
(30248621, 'EVE', 'CHE', 0, 1, '2026-02-26 11:30:00'),
(30248622, 'AST', 'NEW', 1, 1, '2026-02-26 11:38:00'),
(30248623, 'LIV', 'CRY', 3, 0, '2026-02-26 11:36:00'),
(30250991, 'WOL', 'MNU', 2, 1, '2026-02-26 11:40:00'),
(30250992, 'FUL', 'TOT', 3, 1, '2026-02-26 11:42:00'),
(30250993, 'CRY', 'EVE', 2, 0, '2026-02-26 11:44:00'),
(30250994, 'NOT', 'MNC', 1, 3, '2026-02-26 11:46:00'),
(30250995, 'LEE', 'BOU', 1, 4, '2026-02-26 11:48:00'),
(30250996, 'WOL', 'SUN', 2, 1, '2026-02-26 11:50:00'),
(30251082, 'BHA', 'BRE', 0, 1, '2026-02-26 11:52:00'),
(30251083, 'ARS', 'NEW', 5, 0, '2026-02-26 11:54:00'),
(30251084, 'MNC', 'WHU', 3, 1, '2026-02-26 11:56:00'),
(30251085, 'BUR', 'WOL', 0, 1, '2026-02-26 11:58:00'),
(30251086, 'BHA', 'CHE', 1, 0, '2026-02-26 12:00:00'),
(30251087, 'BRE', 'LIV', 0, 1, '2026-02-26 12:02:00'),
(30251169, 'MNU', 'ARS', 2, 2, '2026-02-26 12:04:00'),
(30251170, 'NOT', 'BOU', 0, 3, '2026-02-26 12:06:00'),
(30251171, 'SUN', 'BUR', 1, 0, '2026-02-26 12:08:00'),
(30251527, 'TOT', 'LEE', 0, 0, '2026-02-26 12:58:00'),
(30251609, 'MNU', 'MNC', 1, 1, '2026-02-26 13:00:00'),
(30251613, 'ARS', 'SUN', 2, 1, '2026-02-26 13:02:00'),
(30251782, 'TOT', 'WHU', 2, 2, '2026-02-26 13:32:00'),
(30251783, 'CRY', 'LIV', 1, 4, '2026-02-26 13:30:00'),
(30254149, 'WOL', 'BOU', 1, 3, '2026-02-26 13:34:00'),
(30254150, 'BRE', 'FUL', 0, 0, '2026-02-26 13:36:00'),
(30254151, 'SUN', 'LIV', 0, 3, '2026-02-26 13:38:00'),
(30254152, 'AST', 'CRY', 0, 0, '2026-02-26 13:40:00'),
(30254153, 'BHA', 'MNC', 2, 2, '2026-02-26 13:42:00'),
(30254154, 'ARS', 'EVE', 0, 0, '2026-02-26 13:44:00'),
(30254237, 'WOL', 'LEE', 2, 1, '2026-02-26 13:46:00'),
(30254238, 'LIV', 'BUR', 4, 1, '2026-02-26 13:48:00'),
(30254239, 'BRE', 'NOT', 2, 1, '2026-02-26 13:50:00'),
(30254240, 'ARS', 'CRY', 4, 1, '2026-02-26 13:52:00'),
(30254241, 'MNU', 'BHA', 2, 2, '2026-02-26 13:54:00'),
(30254321, 'NEW', 'TOT', 4, 0, '2026-02-26 13:56:00'),
(30254322, 'LEE', 'EVE', 2, 1, '2026-02-26 13:58:00'),
(30254323, 'BUR', 'WHU', 0, 3, '2026-02-26 14:00:00'),
(30254324, 'MNC', 'AST', 1, 0, '2026-02-26 14:02:00'),
(30254325, 'MNU', 'BHA', 2, 1, '2026-02-26 14:04:00'),
(30254326, 'TOT', 'EVE', 3, 0, '2026-02-26 14:06:00'),
(30254404, 'LEE', 'CRY', 0, 3, '2026-02-26 14:08:00'),
(30254405, 'SUN', 'NEW', 0, 2, '2026-02-26 14:10:00'),
(30254406, 'AST', 'MNC', 1, 2, '2026-02-26 14:12:00'),
(30254407, 'WHU', 'ARS', 0, 2, '2026-02-26 14:14:00'),
(30254408, 'CRY', 'MNU', 0, 0, '2026-02-26 14:16:00'),
(30254491, 'FUL', 'BHA', 0, 2, '2026-02-26 14:18:00'),
(30254492, 'MNC', 'BOU', 0, 5, '2026-02-26 14:20:00'),
(30254493, 'LEE', 'NEW', 1, 2, '2026-02-26 14:22:00'),
(30254494, 'CHE', 'WOL', 0, 0, '2026-02-26 14:24:00'),
(30254495, 'AST', 'BHA', 2, 1, '2026-02-26 14:26:00'),
(30254496, 'BUR', 'WHU', 2, 0, '2026-02-26 14:28:00'),
(30254577, 'MNU', 'NEW', 0, 3, '2026-02-26 14:30:00'),
(30254578, 'BRE', 'CHE', 2, 0, '2026-02-26 14:32:00'),
(30254579, 'LIV', 'BHA', 3, 1, '2026-02-26 14:34:00'),
(30254580, 'FUL', 'BUR', 1, 1, '2026-02-26 14:36:00'),
(30254581, 'SUN', 'NEW', 3, 3, '2026-02-26 14:38:00'),
(30254662, 'CHE', 'MNC', 2, 2, '2026-02-26 14:40:00'),
(30254663, 'ARS', 'BRE', 0, 1, '2026-02-26 14:42:00'),
(30254664, 'BOU', 'WHU', 0, 0, '2026-02-26 14:44:00'),
(30254665, 'BHA', 'NOT', 0, 0, '2026-02-26 14:46:00'),
(30254666, 'LEE', 'SUN', 1, 3, '2026-02-26 14:48:00'),
(30254667, 'NEW', 'ARS', 0, 1, '2026-02-26 14:50:00'),
(30254744, 'EVE', 'MNU', 0, 0, '2026-02-26 14:52:00'),
(30254745, 'AST', 'FUL', 2, 0, '2026-02-26 14:54:00'),
(30254747, 'NEW', 'WOL', 0, 0, '2026-02-26 14:58:00'),
(30254748, 'EVE', 'TOT', 0, 1, '2026-02-26 15:00:00'),
(30254831, 'LIV', 'CRY', 0, 0, '2026-02-26 15:02:00'),
(30254832, 'AST', 'BRE', 0, 1, '2026-02-26 15:04:00'),
(30254833, 'MNC', 'SUN', 0, 1, '2026-02-26 15:06:00');

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

--
-- Estrutura para tabela `model_metrics`
--

CREATE TABLE `model_metrics` (
  `id` int NOT NULL,
  `timestamp` datetime DEFAULT (now()),
  `accuracy_score` int DEFAULT NULL,
  `total_predictions` int DEFAULT NULL,
  `model_version` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Despejando dados para a tabela `model_metrics`
--

INSERT INTO `model_metrics` (`id`, `timestamp`, `accuracy_score`, `total_predictions`, `model_version`) VALUES
(1, '2026-02-26 11:29:11', 62, 14, 'xgb_v202602261129'),
(2, '2026-02-26 11:29:37', 60, 15, 'xgb_v202602261129'),
(3, '2026-02-26 11:31:56', 63, 16, 'xgb_v202602261131'),
(4, '2026-02-26 11:33:53', 63, 17, 'xgb_v202602261133'),
(5, '2026-02-26 11:35:53', 63, 18, 'xgb_v202602261135'),
(6, '2026-02-26 11:37:54', 64, 19, 'xgb_v202602261137'),
(7, '2026-02-26 11:39:57', 68, 20, 'xgb_v202602261139'),
(8, '2026-02-26 11:41:54', 70, 21, 'xgb_v202602261141'),
(9, '2026-02-26 11:43:53', 58, 22, 'xgb_v202602261143'),
(10, '2026-02-26 11:45:53', 60, 23, 'xgb_v202602261145'),
(11, '2026-02-26 11:47:53', 62, 24, 'xgb_v202602261147'),
(12, '2026-02-26 11:49:58', 55, 25, 'xgb_v202602261149'),
(13, '2026-02-26 11:51:53', 56, 26, 'xgb_v202602261151'),
(14, '2026-02-26 11:53:53', 61, 27, 'xgb_v202602261153'),
(15, '2026-02-26 11:55:55', 67, 28, 'xgb_v202602261155'),
(16, '2026-02-26 11:57:53', 51, 29, 'xgb_v202602261157'),
(17, '2026-02-26 11:59:53', 59, 30, 'xgb_v202602261159'),
(18, '2026-02-26 12:01:53', 58, 31, 'xgb_v202602261201'),
(19, '2026-02-26 12:03:53', 64, 32, 'xgb_v202602261203'),
(20, '2026-02-26 12:05:53', 71, 33, 'xgb_v202602261205'),
(21, '2026-02-26 12:07:53', 58, 34, 'xgb_v202602261207'),
(22, '2026-02-26 12:09:53', 62, 35, 'xgb_v202602261209'),
(23, '2026-02-26 13:02:13', 60, 36, 'xgb_v202602261302'),
(24, '2026-02-26 13:02:15', 65, 37, 'xgb_v202602261302'),
(25, '2026-02-26 13:03:53', 56, 38, 'xgb_v202602261303'),
(26, '2026-02-26 13:33:54', 53, 39, 'xgb_v202602261333'),
(27, '2026-02-26 13:33:56', 62, 40, 'xgb_v202602261333'),
(28, '2026-02-26 13:35:53', 62, 41, 'xgb_v202602261335'),
(29, '2026-02-26 13:37:53', 70, 42, 'xgb_v202602261337'),
(30, '2026-02-26 13:39:53', 62, 43, 'xgb_v202602261339'),
(31, '2026-02-26 13:41:53', 63, 44, 'xgb_v202602261341'),
(32, '2026-02-26 13:43:53', 57, 45, 'xgb_v202602261343'),
(33, '2026-02-26 13:45:53', 68, 46, 'xgb_v202602261345'),
(34, '2026-02-26 13:47:53', 60, 47, 'xgb_v202602261347'),
(35, '2026-02-26 13:49:53', 60, 48, 'xgb_v202602261349'),
(36, '2026-02-26 13:51:53', 60, 48, 'xgb_v202602261351'),
(37, '2026-02-26 13:51:54', 61, 49, 'xgb_v202602261351'),
(38, '2026-02-26 13:53:38', 69, 50, 'xgb_v202602261353'),
(39, '2026-02-26 13:55:31', 65, 51, 'xgb_v202602261355'),
(40, '2026-02-26 13:57:41', 67, 52, 'xgb_v202602261357'),
(41, '2026-02-26 13:59:31', 66, 53, 'xgb_v202602261359'),
(42, '2026-02-26 14:01:37', 70, 54, 'xgb_v202602261401'),
(43, '2026-02-26 14:03:53', 60, 55, 'xgb_v202602261403'),
(44, '2026-02-26 14:05:37', 66, 56, 'xgb_v202602261405'),
(45, '2026-02-26 14:07:53', 57, 57, 'xgb_v202602261407'),
(46, '2026-02-26 14:11:18', 75, 58, 'xgb_v202602261411'),
(47, '2026-02-26 14:11:36', 56, 59, 'xgb_v202602261411'),
(48, '2026-02-26 14:13:44', 61, 60, 'xgb_v202602261413'),
(49, '2026-02-26 14:15:53', 66, 61, 'xgb_v202602261415'),
(50, '2026-02-26 14:17:41', 60, 62, 'xgb_v202602261417'),
(51, '2026-02-26 14:19:34', 59, 63, 'xgb_v202602261419'),
(52, '2026-02-26 14:21:34', 64, 64, 'xgb_v202602261421'),
(53, '2026-02-26 14:23:50', 54, 65, 'xgb_v202602261423'),
(54, '2026-02-26 14:25:53', 45, 66, 'xgb_v202602261425'),
(55, '2026-02-26 14:27:53', 66, 67, 'xgb_v202602261427'),
(56, '2026-02-26 14:29:53', 60, 68, 'xgb_v202602261429'),
(57, '2026-02-26 14:31:53', 60, 69, 'xgb_v202602261431'),
(58, '2026-02-26 14:33:53', 57, 70, 'xgb_v202602261433'),
(59, '2026-02-26 14:36:53', 60, 71, 'xgb_v202602261436'),
(60, '2026-02-26 14:37:53', 58, 72, 'xgb_v202602261437'),
(61, '2026-02-26 14:39:53', 54, 73, 'xgb_v202602261439'),
(62, '2026-02-26 14:41:50', 55, 74, 'xgb_v202602261441'),
(63, '2026-02-26 14:43:34', 52, 75, 'xgb_v202602261443'),
(64, '2026-02-26 14:45:34', 54, 76, 'xgb_v202602261445'),
(65, '2026-02-26 14:47:53', 57, 77, 'xgb_v202602261447'),
(66, '2026-02-26 14:49:53', 61, 78, 'xgb_v202602261449'),
(67, '2026-02-26 14:51:39', 59, 79, 'xgb_v202602261451'),
(68, '2026-02-26 14:53:03', 59, 79, 'xgb_v202602261453'),
(69, '2026-02-26 14:55:52', 56, 80, 'xgb_v202602261455'),
(70, '2026-02-26 14:55:53', 54, 81, 'xgb_v202602261455'),
(71, '2026-02-26 15:02:52', 54, 82, 'xgb_v202602261502'),
(72, '2026-02-26 15:02:53', 54, 83, 'xgb_v202602261502'),
(73, '2026-02-26 15:03:53', 57, 84, 'xgb_v202602261503'),
(74, '2026-02-26 15:05:53', 59, 85, 'xgb_v202602261505'),
(75, '2026-02-26 15:07:53', 64, 86, 'xgb_v202602261507');

--
-- Índices para tabelas despejadas
--

--
-- Índices de tabela `matches`
--
ALTER TABLE `matches`
  ADD PRIMARY KEY (`id_jogo`),
  ADD KEY `ix_matches_data_jogo` (`data_jogo`),
  ADD KEY `ix_matches_time_casa` (`time_casa`),
  ADD KEY `ix_matches_id_jogo` (`id_jogo`),
  ADD KEY `ix_matches_time_fora` (`time_fora`),
  ADD KEY `idx_time_casa_data` (`time_casa`,`data_jogo`),
  ADD KEY `idx_time_fora_data` (`time_fora`,`data_jogo`);

--
-- Índices de tabela `model_metrics`
--
ALTER TABLE `model_metrics`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ix_model_metrics_id` (`id`);

--
-- AUTO_INCREMENT para tabelas despejadas
--

--
-- AUTO_INCREMENT de tabela `matches`
--
ALTER TABLE `matches`
  MODIFY `id_jogo` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30254834;

--
-- AUTO_INCREMENT de tabela `model_metrics`
--
ALTER TABLE `model_metrics`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;
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 */;
