-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Počítač: 127.0.0.1
-- Vytvořeno: Pát 02. čen 2023, 08:19
-- Verze serveru: 10.4.27-MariaDB
-- Verze PHP: 8.0.25

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: `20-c-mrkvicka.d`
--

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

--
-- Struktura tabulky `pocitac`
--

CREATE TABLE `pocitac` (
  `ec` char(4) NOT NULL,
  `procesor` varchar(20) NOT NULL,
  `ram` tinyint(4) NOT NULL,
  `typ_disku` set('HDD','SSD - SATA','SSD - M.2') NOT NULL,
  `kapacita` smallint(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_czech_ci;

--
-- Vypisuji data pro tabulku `pocitac`
--

INSERT INTO `pocitac` (`ec`, `procesor`, `ram`, `typ_disku`, `kapacita`) VALUES
('1000', 'AMD Ryzen 5 2400G', 16, 'SSD - M.2', 1000),
('1001', 'Intel Core I5-9400F', 32, 'SSD - M.2', 500),
('1002', 'Intel Core I9-9900K', 64, 'SSD - M.2', 1000);

--
-- Indexy pro exportované tabulky
--

--
-- Indexy pro tabulku `pocitac`
--
ALTER TABLE `pocitac`
  ADD PRIMARY KEY (`ec`);
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 */;
