-- Adminer 4.2.0 MySQL dump

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

DROP TABLE IF EXISTS `pole`;
CREATE TABLE `pole` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jmeno` varchar(80) COLLATE utf8_czech_ci DEFAULT NULL,
  `starth` tinyint(2) unsigned zerofill DEFAULT NULL,
  `startm` tinyint(2) unsigned zerofill DEFAULT NULL,
  `endh` tinyint(2) unsigned zerofill DEFAULT NULL,
  `endm` tinyint(2) unsigned zerofill DEFAULT NULL,
  `prichod` varchar(5) COLLATE utf8_czech_ci NOT NULL DEFAULT '00:00',
  `odchod` varchar(5) COLLATE utf8_czech_ci DEFAULT '00:00',
  `odprhodin` varchar(5) COLLATE utf8_czech_ci DEFAULT NULL,
  `hodinnavic` varchar(5) COLLATE utf8_czech_ci DEFAULT NULL,
  `prichodprescas` varchar(80) COLLATE utf8_czech_ci DEFAULT '00:00',
  `odchodprescas` varchar(80) COLLATE utf8_czech_ci DEFAULT '00:00',
  `prescas` varchar(80) COLLATE utf8_czech_ci DEFAULT '00',
  `dovolena` varchar(3) COLLATE utf8_czech_ci DEFAULT NULL,
  `nemoc` varchar(3) COLLATE utf8_czech_ci DEFAULT NULL,
  `nahrady` varchar(3) COLLATE utf8_czech_ci DEFAULT NULL,
  `den` varchar(7) COLLATE utf8_czech_ci DEFAULT NULL,
  `day` tinyint(2) unsigned zerofill NOT NULL,
  `tyden` tinyint(2) unsigned zerofill NOT NULL,
  `month` tinyint(2) unsigned zerofill NOT NULL,
  `mesic` varchar(10) COLLATE utf8_czech_ci NOT NULL,
  `rok` varchar(4) COLLATE utf8_czech_ci NOT NULL,
  `datum` date NOT NULL,
  `odkaz` varchar(125) COLLATE utf8_czech_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

INSERT INTO `pole` (`id`, `jmeno`, `starth`, `startm`, `endh`, `endm`, `prichod`, `odchod`, `odprhodin`, `hodinnavic`, `prichodprescas`, `odchodprescas`, `prescas`, `dovolena`, `nemoc`, `nahrady`, `den`, `day`, `tyden`, `month`, `mesic`, `rok`, `datum`, `odkaz`) VALUES
(1,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:54',	'15:01',	'08:00',	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Čtvrtek',	23,	17,	04,	'Duben',	'2015',	'2015-04-23',	NULL),
(2,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:55',	'15:03',	'08.00',	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Pátek',	24,	17,	04,	'Duben',	'2015',	'2015-04-24',	NULL),
(3,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:51',	'15:04',	'08:00',	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Pondělí',	27,	18,	04,	'Duben',	'2015',	'2015-04-27',	NULL),
(4,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:54',	'15:02',	'08:00',	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Úterý',	28,	18,	04,	'Duben',	'2015',	'2015-04-28',	NULL),
(5,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:58',	'15:05',	'08:00',	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Středa',	29,	18,	04,	'Duben',	'2015',	'2015-04-29',	NULL),
(6,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:52',	'15:03',	'08:00',	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Čtvrtek',	30,	18,	04,	'Duben',	'2015',	'2015-04-30',	NULL),
(7,	NULL,	NULL,	NULL,	NULL,	NULL,	'00:00',	'00:00',	'',	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Pátek',	01,	18,	05,	'Květen',	'2015',	'2015-05-01',	NULL),
(8,	NULL,	NULL,	NULL,	NULL,	NULL,	'00:00',	'00:00',	'',	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Sobota',	02,	18,	05,	'Květen',	'2015',	'2015-05-02',	NULL),
(9,	NULL,	NULL,	NULL,	NULL,	NULL,	'00:00',	'00:00',	NULL,	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Neděle',	03,	18,	05,	'Květen',	'2015',	'2015-05-03',	NULL),
(10,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:54',	'15:02',	'08:00',	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Pondělí',	04,	19,	05,	'Květen',	'2015',	'2015-05-04',	NULL),
(11,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:58',	'15:05',	'08:00',	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Úterý',	05,	19,	05,	'Květen',	'2015',	'2015-05-05',	NULL),
(12,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:52',	'15:03',	'08:00',	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Středa',	06,	19,	05,	'Květen',	'2015',	'2015-05-06',	NULL),
(13,	'',	07,	00,	15,	00,	'06:53',	'15:02',	'08:00',	NULL,	'00:00#16:23#19:34#20:36',	'00:00#16:56#20:22#21:23',	'00#30#30#30',	NULL,	NULL,	NULL,	'Čtvrtek',	07,	19,	05,	'Květen',	'2015',	'2015-05-07',	NULL),
(14,	'',	07,	00,	15,	00,	'00:00',	'00:00',	'',	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Pátek',	08,	19,	05,	'Květen',	'2015',	'2015-05-08',	NULL),
(15,	NULL,	NULL,	NULL,	NULL,	NULL,	'00:00',	'00:00',	NULL,	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Sobota',	09,	19,	05,	'Květen',	'2015',	'2015-05-09',	NULL),
(16,	NULL,	NULL,	NULL,	NULL,	NULL,	'00:00',	'00:00',	NULL,	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Neděle',	10,	19,	05,	'Květen',	'2015',	'2015-05-10',	NULL),
(17,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:57',	'15:04',	'08:00',	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Pondělí',	11,	20,	05,	'Květen',	'2015',	'2015-05-11',	NULL),
(18,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:45',	'15:02',	'08:00',	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Úterý',	12,	20,	05,	'Květen',	'2015',	'2015-05-12',	NULL),
(19,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:53',	'15:04',	'08:00',	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Středa',	13,	20,	05,	'Květen',	'2015',	'2015-05-13',	NULL),
(20,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:54',	'15:04',	'08:00',	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Čtvrtek',	14,	20,	05,	'Květen',	'2015',	'2015-05-15',	NULL),
(21,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:53',	'15:02',	'08:00',	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Pátek',	15,	20,	05,	'Květen',	'2015',	'2015-05-15',	NULL),
(22,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:57',	'15:02',	'08:00',	'',	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Pondělí',	18,	21,	05,	'Květen',	'2015',	'2015-05-18',	NULL),
(23,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:55',	'15:05',	'08:00',	'',	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Úterý',	19,	21,	05,	'Květen',	'2015',	'2015-05-19',	NULL),
(24,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:54',	'15:03',	'08:00',	'0:0',	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Středa',	20,	21,	05,	'Květen',	'2015',	'2015-05-20',	NULL),
(25,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:49',	'15:02',	'08:00',	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Čtvrtek',	21,	21,	05,	'Květen',	'2015',	'2015-05-21',	NULL),
(26,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:47',	'15:07',	'08:00',	'0:0',	'00:00#15:57#17:18',	'00:00#17:17#18:47',	'00#90#90',	NULL,	NULL,	NULL,	'Pátek',	22,	21,	05,	'Květen',	'2015',	'2015-05-22',	NULL),
(27,	NULL,	NULL,	NULL,	NULL,	NULL,	'00:00',	'00:00',	NULL,	NULL,	'00:00#22:28',	'00:00#23:36',	'00#60',	NULL,	NULL,	NULL,	'Neděle',	24,	21,	05,	'Květen',	'2015',	'2015-05-24',	NULL),
(28,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:58',	'15:02',	'08:00',	'0:0',	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Pondělí',	25,	22,	05,	'Květen',	'2015',	'2015-05-25',	NULL),
(29,	NULL,	NULL,	NULL,	NULL,	NULL,	'00:00',	'00:00',	NULL,	NULL,	'00:00',	'00:00',	'00',	'ano',	NULL,	NULL,	'Úterý',	26,	22,	05,	'Květen',	'2015',	'2015-05-26',	NULL),
(30,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:52',	'15:03',	'08:00',	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Středa',	27,	22,	05,	'Květen',	'2015',	'2015-05-27',	NULL),
(31,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:53',	'15:10',	'08:00',	'',	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Čtvrtek',	28,	22,	05,	'Květen',	'2015',	'2015-05-28',	NULL),
(32,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:54',	'15:05',	'08:00',	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Pátek',	29,	22,	05,	'Květen',	'2015',	'2015-05-29',	NULL),
(33,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:54',	'15:01',	'08:00',	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Pondělí',	01,	23,	06,	'Červen',	'2015',	'2015-06-01',	NULL),
(34,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:48',	'15:01',	'08:00',	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Úterý',	02,	23,	06,	'Červen',	'2015',	'2015-06-02',	NULL),
(35,	NULL,	NULL,	NULL,	NULL,	NULL,	'06:54',	'00:00',	NULL,	NULL,	'00:00',	'00:00',	'00',	NULL,	NULL,	NULL,	'Středa',	03,	23,	06,	'Červen',	'2015',	'2015-06-03',	NULL);

-- 2015-06-03 09:07:03
