-- Adminer 4.8.1 MySQL 5.7.27-0ubuntu0.16.04.1 dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

SET NAMES utf8mb4;

DROP TABLE IF EXISTS `zamestnanci`;
CREATE TABLE `zamestnanci` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jmeno` varchar(50) COLLATE utf8mb4_czech_ci NOT NULL,
  `prijmeni` varchar(50) COLLATE utf8mb4_czech_ci NOT NULL,
  `narozeni` year(4) DEFAULT NULL,
  `plat` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_czech_ci;

INSERT INTO `zamestnanci` (`id`, `jmeno`, `prijmeni`, `narozeni`, `plat`) VALUES
(1,	'Jana',	'Malá',	'1987',	42000),
(2,	'Josef',	'Nováček',	'1991',	47000),
(3,	'Jitka',	'Dutá',	'1991',	60000),
(4,	'Eva',	'Rajská',	'1990',	45000),
(5,	'Martin',	'Tichý',	'1990',	51000);

-- 2025-03-25 07:07:18
