-- https://www.phpmyadmin.net/
--
-- Počítač: localhost
-- Vytvořeno: Pon 15. led 2024, 12:26
-- Verze serveru: 5.5.68-MariaDB
-- Verze PHP: 8.0.30

START TRANSACTION;



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

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

--
-- Struktura tabulky `betusers`
--

CREATE TABLE `betusers` (
  `ID` int(11) NOT NULL,
  `email` varchar(200) COLLATE utf8_czech_ci NOT NULL,
  `username` varchar(100) COLLATE utf8_czech_ci NOT NULL,
  `account_balance` int(20) NOT NULL,
  `password` text COLLATE utf8_czech_ci NOT NULL,
  `phonenumber` varchar(30) COLLATE utf8_czech_ci NOT NULL,
  `gender` varchar(20) COLLATE utf8_czech_ci NOT NULL,
  `dateofbirth` date NOT NULL,
  `time_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Vypisuji data pro tabulku `betusers`
--

INSERT INTO `betusers` (`ID`, `email`, `username`, `account_balance`, `password`, `phonenumber`, `gender`, `dateofbirth`, `time_create`) VALUES
(1, 'thomas.shon6@gmail.com', 'ThominOSS', 972, '99d7e477a41363dd239d9884586b28db373dbc38262203f7ec2e2da3d7912280d0949b62d859b45cd63554c111855f9b3ad4bbf584db48b9605f60376eaa19bc', '+420 656 744 323', 'Muž', '2005-09-03', '2024-01-09 19:14:15'),
(3, '47954055@fsv.cuni.cz', 'Michalka', 1534, '101bb581719456256c6e137c4d480dac771e236eb12938c05a25c896c43d754f9c62b1cebacd07442ccb9ef307c8b37a47245d7c49c965eb57d636bbd6cc927c', '+420 452 689 524', 'Žena', '2004-05-10', '2024-01-12 21:09:36'),
(4, 'ukopnisimalicek@email.cz', 'abysnezakop', 82, '704bce7ab996e23e2da15acc6f837ad17fc1f36a8c851850101f62369245b8c78acec83669a6269fb6c3753945d446ff78ec4ad73e476f6cae51dd58932a67a2', '+420 111 222 333', 'Muž', '1997-04-13', '2024-01-13 17:44:44');

--
-- Indexy pro exportované tabulky
--

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

--
-- AUTO_INCREMENT pro tabulky
--

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

