-- phpMyAdmin SQL Dump
-- version 5.2.1-1.el7.remi
-- https://www.phpmyadmin.net/
--
-- Počítač: localhost
-- Vytvořeno: Stř 12. čen 2024, 05:46
-- 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 `testovaciDatabaze`
--

CREATE TABLE `testovaciDatabaze` (
  `ID` int(11) NOT NULL,
  `domain` varchar(255) NOT NULL,
  `port` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `datumOvereni` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Vypisuji data pro tabulku `testovaciDatabaze`
--

INSERT INTO `testovaciDatabaze` (`ID`, `domain`, `port`, `username`, `datumOvereni`) VALUES
(4, 'www.sofascore.com', 443, 'ThominOSS ', '2024-05-16 12:13:07'),
(23, 'www.bohemians.cz', 443, 'ThominOSS ', '2024-05-16 12:13:07');

--
-- Indexy pro exportované tabulky
--

--
-- Indexy pro tabulku `testovaciDatabaze`
--
ALTER TABLE `testovaciDatabaze`
  ADD PRIMARY KEY (`ID`),
  ADD UNIQUE KEY `domain` (`domain`,`port`),
  ADD KEY `username` (`username`);

--
-- AUTO_INCREMENT pro tabulky
--

--
-- AUTO_INCREMENT pro tabulku `testovaciDatabaze`
--
ALTER TABLE `testovaciDatabaze`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;
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 */;
