-- Adminer 4.3.0 MySQL dump

SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

CREATE TABLE `customer` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nameFirst` varchar(210) COLLATE utf8_czech_ci NOT NULL,
  `nameLast` varchar(200) COLLATE utf8_czech_ci NOT NULL,
  `note` text COLLATE utf8_czech_ci NOT NULL,
  `code` varchar(45) COLLATE utf8_czech_ci NOT NULL,
  `contactPhone` varchar(100) COLLATE utf8_czech_ci NOT NULL,
  `contactAddress` text COLLATE utf8_czech_ci NOT NULL,
  `deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `deleted` (`deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

INSERT INTO `customer` (`id`, `nameFirst`, `nameLast`, `note`, `code`, `contactPhone`, `contactAddress`, `deleted`) VALUES
(1,	'Ritterová',	'Martina',	'',	'',	'',	'',	0),
(2,	'Lukáš',	'Macháč',	'bla',	'',	'+420458745874',	'dsfdf 15, fff 25477',	0),
(3,	'Stanislav',	'Mozgva',	'',	'',	'',	'',	0),
(4,	'Aneta',	'Pavlůsková',	'',	'',	'',	'',	0),
(5,	'Petra',	'Lorencová',	'',	'',	'',	'',	0),
(6,	'Jakub',	'Novák Nedašov',	'',	'',	'',	'',	0),
(7,	'Adam',	'Pecha',	'',	'',	'',	'',	0),
(8,	'Marie',	'Nováková',	'',	'',	'',	'',	1),
(9,	'Žaneta',	'Tomečková',	'',	'',	'',	'',	0),
(10,	'Jana',	'Fojtíková',	'',	'',	'',	'',	0),
(11,	'Lenka',	'Jenyšová',	'',	'',	'',	'',	0),
(12,	'Renata',	'Hudečková',	'',	'',	'',	'',	0),
(13,	'Lukáš',	'Chovančík',	'',	'',	'',	'',	0),
(14,	'Jiří',	'Polomík',	'',	'',	'',	'',	0),
(15,	'Jakub',	'Knotek',	'',	'',	'',	'',	0),
(16,	'Jana',	'Matochová',	'',	'',	'',	'',	0),
(17,	'Sabina',	'Častulíková',	'',	'',	'',	'',	0),
(18,	'Petr',	'Kaňok',	'',	'',	'',	'',	0),
(19,	'Václav',	'Konečný',	'',	'',	'',	'',	0),
(20,	'Jan',	'Žero',	'',	'',	'',	'',	1),
(21,	'Jaroslav',	'Janiš',	'',	'',	'',	'',	0),
(22,	'Marek',	'Mana',	'',	'',	'',	'',	0),
(23,	'Josef',	'Baláž',	'',	'',	'',	'',	0),
(24,	'Dagmar',	'Holbová',	'',	'',	'',	'',	0),
(25,	'Jakub',	'Novák',	'',	'',	'605 549 606',	'',	0),
(26,	'Jana',	'Beňovičová',	'',	'',	'',	'',	0),
(27,	'S',	'Hošík',	'',	'',	'',	'',	0),
(28,	'Poláček',	'Dominik',	'',	'',	'',	'',	0),
(29,	'Lukšo',	'Roman',	'',	'',	'',	'',	0),
(30,	'Ondra',	'Polách',	'',	'',	'',	'',	0),
(31,	'Daniel',	'Hořák',	'',	'',	'',	'',	0),
(32,	'František',	'Kupčík',	'',	'',	'',	'',	0),
(33,	'Zdena',	'Urbanová',	'',	'',	'',	'',	0),
(34,	'Dominik',	'Hudeček',	'',	'',	'',	'',	0),
(35,	'Dana',	'Bodláková',	'',	'',	'',	'',	0),
(36,	'Robert',	'Lysák',	'',	'',	'',	'',	0),
(37,	'Michal',	'Hořák',	'',	'',	'',	'',	0),
(38,	'Kamil',	'Novák',	'',	'',	'',	'',	0),
(39,	'Vlado',	'Piešťak',	'',	'',	'',	'',	0),
(40,	'Lenka',	'Svárovská',	'',	'',	'',	'',	1),
(41,	'm.',	'Loucká',	'',	'',	'',	'',	1),
(42,	'Alena',	'Loucká',	'',	'',	'',	'',	0),
(43,	'Ivana',	'Trčková',	'',	'',	'',	'',	0),
(44,	'Petr',	'Krůžela',	'',	'',	'',	'',	0),
(45,	'Martin',	'Hořák',	'',	'',	'',	'',	0),
(46,	'Radomír',	'Matocha',	'',	'',	'',	'',	1),
(47,	'Radek',	'Červenka',	'',	'',	'',	'',	0),
(48,	'Marie',	'Nováková',	'',	'',	'',	'',	0),
(49,	'Tomáš',	'Hrabina',	'',	'',	'',	'',	0),
(50,	'Kristýna',	'Fojtíková',	'',	'',	'',	'',	0),
(51,	'Martin',	'Řehák',	'',	'',	'',	'',	0),
(52,	'Petr',	'Holba',	'',	'',	'',	'',	0),
(53,	'Petr',	'Macek',	'',	'',	'',	'',	0),
(54,	'Martin',	'urban',	'',	'',	'',	'',	0),
(55,	'm',	'křenek',	'',	'',	'',	'',	1),
(56,	'Tomáš',	'Křenek',	'',	'',	'',	'',	0),
(57,	'Marie',	'Bubelova',	'',	'',	'',	'',	0),
(58,	'Marie',	'Svobodova',	'',	'',	'',	'',	0),
(59,	'Romana',	'Bartošáková',	'',	'',	'',	'',	0),
(60,	'Laďa',	'Mana',	'',	'',	'',	'',	0),
(61,	'Libor',	'Staník',	'',	'',	'',	'',	0),
(62,	'Kristýna',	'Divošová',	'',	'',	'',	'',	0),
(63,	'Barbora',	'Zikmundová',	'',	'',	'',	'',	0),
(64,	'Šárka',	'Fojtíková',	'',	'',	'',	'',	0),
(65,	'Aneta',	'Rašková',	'',	'',	'',	'',	0),
(66,	'Lea',	'Vaňková',	'',	'',	'',	'',	0),
(67,	'Adam',	'Zelinka',	'',	'',	'',	'',	0),
(68,	'Petra',	'Kostková',	'',	'',	'',	'',	0),
(69,	'Hana',	'Olejníková',	'',	'',	'',	'',	0),
(70,	'Jakub',	'Kolman',	'',	'',	'',	'',	0),
(71,	'Vlado',	'Pistorčák',	'',	'',	'',	'',	0),
(72,	'Libor',	'Liška',	'',	'',	'',	'',	0),
(73,	'Lucie',	'Vaňková',	'',	'',	'',	'',	0),
(74,	'Luboš',	'Polách',	'',	'',	'',	'',	0),
(75,	'Mira',	'Bačo',	'',	'',	'',	'',	0),
(76,	'Vlastimil',	'Vítek',	'',	'',	'',	'',	0),
(77,	'Zdenek',	'Šenkeřík',	'',	'',	'',	'',	0),
(78,	'Alice',	'Chuchmová',	'',	'',	'',	'',	0),
(79,	'Martin',	'Fojtík',	'',	'',	'',	'',	0),
(80,	'Věra',	'Novosádová',	'',	'',	'',	'',	0),
(81,	'Dušan',	'Polách',	'',	'',	'',	'',	0),
(82,	'Daniel',	'Polách',	'',	'',	'',	'',	0),
(83,	'Adam',	'Barbořík',	'',	'',	'',	'',	0),
(84,	'Zdena',	'Vaškůjová',	'',	'',	'',	'',	0),
(85,	'Eliška',	'Mitášová',	'',	'',	'',	'',	0),
(86,	'Dominik',	'Kubiš',	'',	'',	'',	'',	1),
(87,	'Dominik',	'Kubiš',	'',	'',	'',	'',	1),
(88,	'Dominik',	'Kubiš',	'',	'',	'',	'',	1),
(89,	'Dominik',	'Kubiš',	'',	'',	'',	'',	0),
(90,	'Libuše',	'Křeková',	'',	'',	'',	'',	0),
(91,	'Alice',	'Lukšo',	'',	'',	'',	'',	0),
(92,	'Pavel',	'Holba',	'',	'',	'',	'',	1),
(93,	'Jitka',	'Prášilová',	'',	'',	'',	'',	0),
(94,	'Radomír',	'Matocha',	'',	'',	'',	'',	0),
(95,	'Kryštof',	'Holec',	'',	'',	'',	'',	0),
(96,	'Jan',	'Hodas',	'',	'',	'',	'',	0),
(97,	'Aneta',	'Pomajdíková',	'',	'',	'',	'',	0),
(98,	'Monika',	'Hošková',	'',	'',	'',	'',	0),
(99,	'Sabina',	'Vilímková',	'',	'',	'',	'',	0),
(100,	'Radek',	'Kubík',	'',	'',	'',	'',	0),
(101,	'Lenka',	'Svarovská',	'',	'',	'',	'',	0),
(102,	'Jaroslav',	'Gajdošík',	'',	'',	'',	'',	0),
(103,	'Gábina',	'Poláchová',	'',	'',	'',	'',	0),
(104,	'Dominika',	'Lysáková',	'',	'',	'',	'',	0),
(105,	'Kateřina',	'Pinďáková',	'',	'',	'',	'',	0),
(106,	'Jan',	'Horvath',	'',	'',	'',	'',	0),
(107,	'Barbora',	'Zpěváková',	'',	'',	'',	'',	0),
(108,	'Denis',	'Hudeček',	'',	'',	'',	'',	1),
(109,	'Denis',	'Hudeček',	'',	'',	'',	'',	1),
(110,	'Denis',	'Hudeček',	'',	'',	'',	'',	0),
(111,	'Stanislava',	'Křeková',	'',	'',	'',	'',	0),
(112,	'Dominik',	'Kozubík',	'',	'',	'',	'',	0),
(113,	'Martina',	'Zvoníčková',	'',	'',	'',	'',	0),
(114,	'Radim',	'Sucháček',	'',	'',	'',	'',	0),
(115,	'Kristyna',	'Kaňokova',	'',	'',	'',	'',	0),
(116,	'Lucie',	'Račákova',	'',	'',	'',	'',	0),
(117,	'Silvie',	'Vilímková',	'',	'',	'',	'',	0),
(118,	'Jitka',	'Hořáková',	'',	'',	'',	'',	0),
(119,	'Jakub',	'Vaňek',	'',	'',	'',	'',	1),
(120,	'Jakub',	'Vaňek',	'',	'',	'',	'',	1),
(121,	'Jakub',	'Vaněk',	'',	'',	'',	'',	0),
(122,	'Adélka',	'Štěpančíková',	'',	'',	'',	'',	0),
(123,	'Richard',	'Rohoška',	'',	'',	'',	'',	0),
(124,	'Ladislav',	'Pacík',	'',	'',	'',	'',	1),
(125,	'Ladislav',	'Pacík',	'',	'',	'',	'',	0),
(126,	'Veronika',	'Vaňková',	'',	'',	'',	'',	0),
(127,	'Martina',	'Fagulcová',	'',	'',	'',	'',	0),
(128,	'Michal',	'Cuc',	'',	'',	'',	'',	0),
(129,	'Petr',	'Janiš',	'',	'',	'',	'',	0),
(130,	'David',	'Janáček',	'',	'',	'',	'',	0),
(131,	'Martin',	'Pecl',	'',	'',	'',	'',	0),
(132,	'Martina',	'Drobilíková',	'',	'',	'',	'',	1),
(133,	'Martina',	'Drobilíková',	'',	'',	'',	'',	0),
(134,	'Adéla',	'Bártlová',	'',	'',	'',	'',	1),
(135,	'Adéla',	'Bártlová',	'',	'',	'',	'',	1),
(136,	'Adéla',	'Bártlová',	'',	'',	'',	'',	0),
(137,	'Kristýna',	'Babulíková',	'',	'',	'',	'',	0),
(138,	'Monika',	'Vaňková',	'',	'',	'',	'',	0),
(139,	'Pavel',	'Vilímek',	'',	'',	'',	'',	0),
(140,	'Zdena',	'Křenková',	'',	'',	'',	'',	0),
(141,	'Adam',	'Dočkal',	'',	'',	'',	'',	0),
(142,	'Sylva',	'Matyášová',	'',	'',	'',	'',	0),
(143,	'Aleš',	'Zelinka',	'',	'',	'',	'',	0),
(144,	'Klára',	'Zvoníčková',	'',	'',	'',	'',	0),
(145,	'Petr',	'Zaoral',	'',	'',	'',	'',	0),
(146,	'Markéta',	'Dvoršťáková',	'',	'',	'',	'',	0),
(147,	'Marek',	'Ročák',	'',	'',	'',	'',	0),
(148,	'David',	'Šenkeřík',	'',	'',	'',	'',	0),
(149,	'Tereza',	'Hudečková',	'',	'',	'',	'',	0),
(150,	'Vladimír',	'Zaoral',	'',	'',	'',	'',	0),
(151,	'Patrik',	'Macháč',	'',	'',	'',	'',	0),
(152,	'René',	'Macháč',	'',	'',	'',	'',	0),
(153,	'Hana',	'Janáčová',	'',	'',	'',	'',	0),
(154,	'Iveta',	'Fojtíková',	'',	'',	'',	'',	0),
(155,	'Radek',	'Janáč',	'',	'',	'',	'',	0),
(156,	'Karel',	'Vavro',	'',	'',	'',	'',	0),
(157,	'Jana',	'Wolofzczuková',	'',	'',	'',	'',	0),
(158,	'Filip',	'Michalík',	'',	'',	'',	'',	0),
(159,	'Matěj',	'Kubín',	'',	'',	'',	'',	0),
(160,	'Dita',	'Raková',	'',	'',	'',	'',	0),
(161,	'Karolína',	'Raková',	'',	'',	'',	'',	0),
(162,	'Radek',	'Macháč',	'',	'',	'',	'',	0),
(163,	'Antonín',	'Polách',	'',	'',	'',	'',	0),
(164,	'Michaela',	'Brumovská',	'',	'',	'',	'',	0),
(165,	'Jakub',	'Juřica',	'',	'',	'',	'',	0),
(166,	'Andrea',	'Pacíková',	'',	'',	'',	'',	0),
(167,	'Anna',	'Fojtíková',	'',	'',	'',	'',	0),
(168,	'Honza',	'Šimoník',	'',	'',	'',	'',	0),
(169,	'Kristýna',	'Wolofzczuková',	'',	'',	'',	'',	0),
(170,	'Marek',	'Líňa',	'',	'',	'',	'',	0),
(171,	'Erik',	'Škvařil',	'',	'',	'',	'',	0),
(172,	'Erik',	'Škvařil',	'',	'',	'',	'',	0),
(173,	'Jaroslava',	'Vítková',	'',	'',	'',	'',	0),
(174,	'Petr',	'Nevrlka',	'',	'',	'',	'',	0),
(175,	'Tomáš',	'Škvařil',	'',	'',	'',	'',	0),
(176,	'Lucie',	'Švachová',	'',	'',	'',	'',	0),
(177,	'Milan',	'Caletka',	'',	'',	'',	'',	0),
(178,	'Lenka',	'Daníková',	'',	'',	'',	'',	0),
(179,	'Petr',	'Matúšú',	'',	'',	'',	'',	0),
(180,	'Jaroslava',	'Juřenčák',	'',	'',	'',	'',	0),
(181,	'David',	'Bodlák',	'',	'',	'',	'',	0),
(182,	'Lucie',	'Fojtíková',	'',	'',	'',	'',	0),
(183,	'Adam',	'Brumovský',	'',	'',	'',	'',	0),
(184,	'Pan',	'Bohunický',	'',	'',	'',	'',	0),
(185,	'Jaroslav',	'Holba',	'',	'',	'',	'',	0),
(186,	'Aleš',	'Skočovský',	'',	'',	'',	'',	0),
(187,	'Lucie',	'Švachová',	'',	'',	'',	'',	0),
(188,	'Simona',	'Rašková',	'',	'',	'',	'',	0),
(189,	'Jakub',	'Havrland',	'',	'',	'',	'',	0),
(190,	'Martin',	'Bartozel',	'',	'',	'',	'',	0),
(191,	'Monika',	'Kruželová',	'',	'',	'',	'',	0),
(192,	'Radek',	'Vaněk',	'',	'',	'',	'',	0),
(193,	'Štěpán',	'Janáč',	'',	'',	'',	'',	0),
(194,	'Patrik',	'Gabriš',	'',	'',	'',	'',	0),
(195,	'Svatopluk',	'Vávro',	'',	'',	'',	'',	0),
(196,	'Peter',	'Janšto',	'',	'',	'',	'',	0),
(197,	'Zdeno',	'Šimko',	'',	'',	'',	'',	0),
(198,	'Michal',	'Červenka',	'',	'',	'',	'',	0),
(199,	'Radim',	'Vaněk',	'',	'',	'',	'',	0),
(200,	'David',	'Hung',	'',	'',	'',	'',	0),
(201,	'Kateřina',	'Drobilíková',	'',	'',	'',	'',	0),
(202,	'Radek',	'Bartošák',	'',	'',	'',	'',	0),
(203,	'Silvie',	'Matyášová',	'',	'',	'',	'',	0),
(204,	'Daniel',	'Švach',	'',	'',	'',	'',	0),
(205,	'Karolína',	'Vašků',	'',	'',	'',	'',	0),
(206,	'Josef',	'Fagulec',	'',	'',	'',	'',	0),
(207,	'Alice',	'Jandová',	'',	'',	'',	'',	0),
(208,	'Jana',	'Hnilova',	'',	'',	'',	'',	0),
(209,	'Kateřina',	'Hnilova',	'',	'',	'',	'',	0),
(210,	'Hana',	'Smilková',	'',	'',	'',	'',	0),
(211,	'Kristýna',	'Ovesná',	'',	'',	'',	'',	0),
(212,	'Jitka',	'Janáčová',	'',	'',	'',	'',	0),
(213,	'Natálie',	'Hudečková',	'',	'',	'',	'',	0),
(214,	'Josef',	'Tománek',	'',	'',	'',	'',	0),
(215,	'Jan',	'Kostka',	'',	'',	'',	'',	0),
(216,	'Josef',	'Mitáš',	'',	'',	'',	'',	0),
(217,	'Marek',	'Cícha',	'',	'',	'',	'',	0),
(218,	'Ivana',	'Poláchová',	'',	'',	'',	'',	0),
(219,	'Markéta',	'Ambrožová',	'',	'',	'',	'',	0),
(220,	'Stanislav',	'Vítek',	'',	'',	'',	'',	0),
(221,	'Rostislav',	'Behanec',	'',	'',	'',	'',	0),
(222,	'Věra',	'Petrů',	'',	'',	'',	'',	0),
(223,	'Věra',	'Petrů',	'',	'',	'',	'',	0),
(224,	'Tomáš',	'Marek',	'',	'',	'',	'',	0),
(225,	'David',	'Vaňek',	'',	'',	'',	'',	0),
(226,	'Luboš',	'Staník',	'',	'',	'',	'',	0),
(227,	'Šárka',	'Vaňková',	'',	'',	'',	'',	0),
(228,	'Hana',	'Poláchová',	'',	'',	'',	'',	0),
(229,	'Tomáš',	'Pavlůsek',	'',	'',	'',	'',	0),
(230,	'Mária',	'Fabičovicová',	'',	'',	'',	'',	0),
(231,	'Nikola',	'Kostková',	'',	'',	'',	'',	0),
(232,	'Lucie',	'Šustrová',	'',	'',	'',	'',	0),
(233,	'Filip',	'Strnad',	'',	'',	'',	'',	0),
(234,	'Michal',	'Kalač',	'',	'',	'',	'',	0),
(235,	'Nikola',	'Pospíšilová',	'',	'',	'',	'',	0),
(236,	'Nikola',	'Pospíšilová',	'',	'',	'',	'',	0),
(237,	'Adriana',	'Balážová',	'',	'',	'',	'',	0),
(238,	'Radmil',	'Smolíková',	'',	'',	'',	'',	0),
(239,	'Radmil',	'Smolíková',	'',	'',	'',	'',	0),
(240,	'Romana',	'Lysáčková',	'',	'',	'',	'',	0),
(241,	'Tomáš',	'Tulpa',	'',	'',	'',	'',	0),
(242,	'Tomáš',	'Tulpa',	'',	'',	'',	'',	0),
(243,	'Libor',	'Hlavica',	'',	'',	'',	'',	0),
(244,	'Magda',	'Fojtiková',	'',	'',	'',	'',	0),
(245,	'Martina',	'Šenkeříková',	'',	'',	'',	'',	0),
(246,	'Jana',	'Vaňková',	'',	'',	'',	'',	0),
(247,	'Lucie',	'Neťuková',	'',	'',	'',	'',	0),
(248,	'Daniel',	'Šerá',	'',	'',	'',	'',	0),
(249,	'Alena',	'Urbanová',	'',	'',	'',	'',	0),
(250,	'Libor',	'Vykydal',	'',	'',	'',	'',	0),
(251,	'Radek',	'Ivaniš',	'',	'',	'',	'',	0),
(252,	'Aleš',	'Bachánek',	'',	'',	'',	'',	0),
(253,	'Adéla',	'Dorňáková',	'',	'',	'',	'',	0),
(254,	'Alena',	'Smolíková',	'',	'',	'',	'',	0),
(255,	'Edita',	'Vilímková',	'',	'',	'',	'',	0),
(256,	'René',	'Hrnčiřík',	'',	'',	'',	'',	0),
(257,	'Lojza',	'Valčík',	'',	'',	'',	'',	0),
(258,	'Adam',	'Lysák',	'',	'',	'',	'',	0),
(259,	'Tereza',	'Vilímková',	'',	'',	'',	'',	0),
(260,	'Petra',	'Jurčová',	'',	'',	'',	'',	0),
(261,	'Bohdana',	'Kolínková',	'',	'',	'',	'',	0),
(262,	'Bohdana',	'Kolínková',	'',	'',	'',	'',	0),
(263,	'Karolína',	'Trčková',	'',	'',	'',	'',	0),
(264,	'andrea',	'Miklasová',	'',	'',	'',	'',	0),
(265,	'Ludmila',	'Chuchmová',	'',	'',	'',	'',	0),
(266,	'Jakub',	'Šenkeřík',	'',	'',	'',	'',	0),
(267,	'Veronika',	'Tomečková',	'',	'',	'',	'',	0),
(268,	'Adam',	'Macháč',	'',	'',	'',	'',	0),
(269,	'Lukáš',	'Machů',	'',	'',	'',	'',	0),
(270,	'Lukáš',	'Machů',	'',	'',	'',	'',	0),
(271,	'Daniela',	'Burdová',	'',	'',	'',	'',	0),
(272,	'Helena',	'Machů',	'',	'',	'',	'',	0),
(273,	'Veronika',	'Šimoníková',	'',	'',	'',	'',	0),
(274,	'Pavel',	'Dorňák',	'',	'',	'',	'',	0),
(275,	'Renata',	'Šmihalová',	'',	'',	'',	'',	0),
(276,	'Richard',	'Soja',	'',	'',	'',	'',	0),
(277,	'Tomáš',	'Urban',	'',	'',	'',	'',	0),
(278,	'Alice',	'Špačková',	'',	'',	'',	'',	0),
(279,	'Pavla',	'Hořáková',	'',	'',	'',	'',	0),
(280,	'Stanislava',	'Křenková',	'',	'',	'',	'',	0),
(281,	'Lukáš',	'Gregušiak',	'',	'',	'',	'',	0),
(282,	'Ante',	'Imeri',	'',	'',	'',	'',	0),
(283,	'Katarina',	'Gogolová',	'',	'',	'',	'',	0),
(284,	'Kateřina',	'Carasová',	'',	'',	'',	'',	0),
(285,	'Jana',	'Váňová',	'',	'',	'',	'',	0),
(286,	'Zdislava',	'Manová',	'',	'',	'',	'',	0),
(287,	'Miroslav',	'Holub',	'',	'',	'',	'',	0),
(288,	'Ondřej',	'Machala',	'',	'',	'',	'',	0),
(289,	'Josef',	'Šánek',	'',	'',	'',	'',	0),
(290,	'Radek',	'Kindl',	'',	'',	'',	'',	0),
(291,	'Večeřová',	'Majka',	'',	'',	'',	'',	0),
(292,	'Klára',	'Vančuříková',	'',	'',	'',	'',	0),
(293,	'Adriana',	'hudečková',	'',	'',	'',	'',	0),
(294,	'Jakub',	'Číž',	'',	'',	'',	'',	0),
(295,	'Antonín',	'Číž',	'',	'',	'',	'',	0),
(296,	'Jarmila',	'Kozubíková',	'',	'',	'',	'',	0),
(297,	'Lucie',	'Žáčková',	'',	'',	'',	'',	0),
(298,	'Adam',	'Caras',	'',	'',	'',	'',	0),
(299,	'Jana',	'Běhunčíková',	'',	'',	'',	'',	0),
(300,	'Jaroslava',	'Figarová',	'',	'',	'',	'',	0),
(301,	'Anna',	'Vašáková',	'',	'',	'',	'',	0),
(302,	'Ivana',	'Švachová',	'',	'',	'',	'',	0),
(303,	'Martin',	'Juřica',	'',	'',	'',	'',	0),
(304,	'Darina',	'Habancová',	'',	'',	'',	'',	0),
(305,	'Dana',	'Kozubíková',	'',	'',	'',	'',	0),
(306,	'Radana',	'Váňová',	'',	'',	'',	'',	0),
(307,	'Veronika',	'Vaňková',	'',	'',	'',	'',	0),
(308,	'Adéla',	'Prášilová',	'',	'',	'',	'',	0),
(309,	'Libor',	'Krahula',	'',	'',	'',	'',	0),
(310,	'Hana',	'Juračková',	'',	'',	'',	'',	0),
(311,	'Tereza',	'Kalíková',	'',	'',	'',	'',	0),
(312,	'Tomáš',	'Šánek',	'',	'',	'',	'',	0),
(313,	'Tomáš',	'Šánek',	'',	'',	'',	'',	0),
(314,	'Jaroslav',	'Bařinka',	'',	'',	'',	'',	0),
(315,	'Šárka',	'Janáčková',	'',	'',	'',	'',	0),
(316,	'Kristýna',	'Růžičková',	'',	'',	'',	'',	0),
(317,	'Adélka',	'Janáčková',	'',	'',	'',	'',	0),
(318,	'Michaela',	'Vaňková',	'',	'',	'',	'',	0),
(319,	'Jaroslav',	'Bařinka',	'',	'',	'',	'',	0),
(320,	'Iveta',	'Lysáková',	'',	'',	'',	'',	0),
(321,	'Karolína',	'Růžičková',	'',	'',	'',	'',	0),
(322,	'Romana',	'Mačková',	'',	'',	'',	'',	0),
(323,	'Kristýna',	'Škrabalová',	'',	'',	'',	'',	0),
(324,	'Dominik',	'Ovesný',	'',	'',	'',	'',	0),
(325,	'Filip',	'Polách',	'',	'',	'',	'',	0),
(326,	'Daniel',	'Caras',	'',	'',	'',	'',	0),
(327,	'Šárka',	'Holbová',	'',	'',	'',	'',	0),
(328,	'Daniel',	'Hrnčiřík',	'',	'',	'',	'',	0),
(329,	'Pavel',	'Hanák',	'',	'',	'',	'',	0),
(330,	'Tereza',	'Malachová',	'',	'',	'',	'',	0),
(331,	'Adéla',	'Juřenčáková',	'',	'',	'',	'',	0),
(332,	'Radka',	'Juřenčáková',	'',	'',	'',	'',	0),
(333,	'Petra',	'Malachová',	'',	'',	'',	'',	0),
(334,	'Dominik',	'Ovesný',	'',	'',	'',	'',	0),
(335,	'Petr',	'Burda',	'',	'',	'',	'',	0),
(336,	'Petra',	'Fagulcová',	'',	'',	'',	'',	0),
(337,	'Anna',	'Hnaníčková',	'',	'',	'',	'',	0),
(338,	'Tomáš',	'Řehák',	'',	'',	'',	'',	0),
(339,	'Daniel',	'Novák',	'',	'',	'',	'',	0),
(340,	'Adam',	'Hrnčiřík',	'',	'',	'',	'',	0),
(341,	'Veronika',	'Šťastná',	'',	'',	'',	'',	0),
(342,	'Adam',	'Běhunčík',	'',	'',	'',	'',	0),
(343,	'Miroslav',	'David',	'',	'',	'',	'',	0),
(344,	'Blanka',	'Lysáčková',	'',	'',	'',	'',	0),
(345,	'Zuzana',	'Macků',	'',	'',	'',	'',	0),
(346,	'Jiří',	'Zaremba',	'',	'',	'',	'',	0),
(347,	'Lenka',	'Kaňoková',	'',	'',	'',	'',	0),
(348,	'Daniela',	'Janáčková',	'',	'',	'',	'',	0),
(349,	'Kateřina',	'Tulpová',	'',	'',	'',	'',	0),
(350,	'Václav',	'Lysák',	'',	'',	'',	'',	0),
(351,	'Ondřej',	'Lysák',	'',	'',	'',	'',	0),
(352,	'Markéta',	'Vaňková',	'',	'',	'',	'',	0),
(353,	'Kristýna',	'Bičejová',	'',	'',	'',	'',	0),
(354,	'Simona',	'Sábová',	'',	'',	'',	'',	0),
(355,	'Zdenek',	'Pinďák',	'',	'',	'',	'',	0),
(356,	'Pavel',	'Naňák',	'',	'',	'',	'',	0),
(357,	'Daniel',	'Haspala',	'',	'',	'',	'',	0),
(358,	'Natálie',	'Matůšú',	'',	'',	'',	'',	0),
(359,	'Barbora',	'Nováková',	'',	'',	'',	'',	0),
(360,	'Ondra',	'Cícha',	'',	'',	'',	'',	0),
(361,	'Tomáš',	'Řehák',	'',	'',	'',	'',	0),
(362,	'Alena',	'Fojtíková',	'',	'',	'',	'',	0),
(363,	'Martina',	'Sáblíková',	'',	'',	'',	'',	0),
(364,	'Pavel',	'Jakeš',	'',	'',	'',	'',	0),
(365,	'Ivana',	'Šimková',	'',	'',	'',	'',	0),
(366,	'Michal',	'Krčmář',	'',	'',	'',	'',	0),
(367,	'Jiří',	'Slovák',	'',	'',	'',	'',	0),
(368,	'Jana',	'Charvátová',	'',	'',	'',	'',	0),
(369,	'Michala',	'Vrzalíková',	'',	'',	'',	'',	0),
(370,	'Hana',	'Mičová',	'',	'',	'',	'',	0),
(371,	'Daniel',	'Mana',	'',	'',	'',	'',	0),
(372,	'Alena',	'Tulpová',	'',	'',	'',	'',	0),
(373,	'Lenka',	'Sívková',	'',	'',	'',	'',	0),
(374,	'Petr',	'Janáč',	'',	'',	'',	'',	0),
(375,	'Martina',	'Pavlíková',	'',	'',	'',	'',	0),
(376,	'Blahoslava',	'Miklíčková',	'',	'',	'',	'',	0),
(377,	'Blahoslava',	'Miklíčková',	'',	'',	'',	'',	0),
(378,	'Iveta',	'Šenkeříková',	'',	'',	'',	'',	1),
(379,	'Iveta',	'Šenkeříková',	'',	'',	'',	'',	1),
(380,	'Iveta',	'Šenkeříková',	'',	'',	'',	'',	1),
(381,	'Iveta',	'Šenkeříková',	'',	'',	'',	'',	1),
(382,	'Iveta',	'Šenkeříková',	'',	'',	'',	'',	1),
(383,	'Iveta',	'Šenkeříková',	'',	'',	'',	'',	1),
(384,	'Iveta',	'Šenkeříková',	'',	'',	'',	'',	0),
(385,	'Ivana',	'Tkadlecová',	'',	'',	'',	'',	0),
(386,	'Vladimíra',	'Kubišová',	'',	'',	'',	'',	0),
(387,	'Diana',	'Divišová',	'',	'',	'',	'',	0),
(388,	'Iveta',	'Divišová',	'',	'',	'',	'',	0),
(389,	'Dana',	'Miličková',	'',	'',	'',	'',	0),
(390,	'Dominik',	'Bačo',	'',	'',	'',	'',	0),
(391,	'Vlasta',	'Blanařová',	'',	'',	'',	'',	0),
(392,	'Monika',	'Strnková',	'',	'',	'',	'',	0),
(393,	'Jarek',	'Fojtík',	'',	'',	'',	'',	0),
(394,	'Anna',	'Hůdková',	'',	'',	'',	'',	0),
(395,	'Bohdana',	'Macháčová',	'',	'',	'',	'',	0),
(396,	'Dagmar',	'Vašáková',	'',	'',	'',	'',	0),
(397,	'Michaela',	'Zichová',	'',	'',	'',	'',	0),
(398,	'Martina',	'Bartošáková',	'',	'',	'',	'',	0),
(399,	'Lucie',	'Trnavská',	'',	'',	'',	'',	0),
(400,	'Petr',	'Vlček',	'',	'',	'',	'',	0),
(401,	'Radek',	'Kralík',	'',	'',	'',	'',	0),
(402,	'Adéla',	'Rajznareova',	'',	'',	'',	'',	0),
(403,	'David',	'Martinka',	'',	'',	'',	'',	0),
(404,	'Vašek',	'Šerý',	'',	'',	'',	'',	0),
(405,	'Michal',	'Horňák',	'',	'',	'',	'',	0),
(406,	'Zuzana',	'Barboříková',	'',	'',	'',	'',	0),
(407,	'František',	'Bližňák',	'',	'',	'',	'',	0),
(408,	'Jiří',	'Řehák',	'',	'',	'',	'',	0),
(409,	'Alte',	'Imeri',	'',	'',	'',	'',	0),
(410,	'Emilie',	'Mládková',	'',	'',	'',	'',	0),
(411,	'Petra',	'Žálková',	'',	'',	'',	'',	0),
(412,	'Hynek',	'Liška',	'',	'',	'',	'',	0),
(413,	'Patrik',	'Gábor',	'',	'',	'',	'',	0),
(414,	'Simona',	'Bartozelová',	'',	'',	'',	'',	0),
(415,	'Robin',	'Bačo',	'',	'',	'',	'',	0),
(416,	'Michal',	'Novák',	'',	'',	'',	'',	0),
(417,	'Jiří',	'Řehák',	'',	'',	'',	'',	0),
(418,	'Veronika',	'Cíchová',	'',	'',	'',	'',	0),
(419,	'Břetislav',	'Pánek',	'',	'',	'',	'',	0),
(420,	'Miroslav',	'Juřenčák',	'',	'',	'',	'',	0),
(421,	'Věrka',	'Hnaníčková',	'',	'',	'',	'',	0),
(422,	'Martin',	'Slovák',	'',	'',	'',	'',	0),
(423,	'Zuzana',	'Holznerová',	'',	'',	'',	'',	0),
(424,	'Karolína',	'Surá',	'',	'',	'',	'',	0),
(425,	'Lenka',	'Plevová',	'',	'',	'',	'',	0),
(426,	'Jaroslava',	'Březáčková',	'',	'',	'',	'',	0),
(427,	'Radka',	'Sívková',	'',	'',	'',	'',	0),
(428,	'Ivana',	'Juřicová',	'',	'',	'',	'',	0),
(429,	'Simona',	'Kašková',	'',	'',	'',	'',	0),
(430,	'Stano',	'Piestorčák',	'',	'',	'',	'',	0),
(431,	'Milan',	'Pažitka',	'',	'',	'',	'',	0),
(432,	'Veronika',	'Kašková',	'',	'',	'',	'',	0),
(433,	'Lea',	'Švachová',	'',	'',	'',	'',	0),
(434,	'Petr',	'Juřenčák',	'',	'',	'',	'',	0),
(435,	'Filip',	'Hrnčiřík',	'',	'',	'',	'',	0),
(436,	'Lenka',	'Kostková',	'',	'',	'',	'',	0),
(437,	'Kateřina',	'Matějíčková',	'',	'',	'',	'',	0),
(438,	'Tomáš',	'Fagulec',	'',	'',	'',	'',	0),
(439,	'Nikola',	'Zemková',	'',	'',	'',	'',	0),
(440,	'Petr',	'Pavlusek',	'',	'',	'',	'',	0),
(441,	'Petr',	'Krčmář',	'',	'',	'',	'',	0),
(442,	'Lenka',	'Juřenčáková',	'',	'',	'',	'',	0),
(443,	'Tomáš',	'Chovanec',	'',	'',	'',	'',	0),
(444,	'Petra',	'Juračková',	'',	'',	'',	'',	0),
(445,	'Jana',	'Březáčková',	'',	'',	'',	'',	0),
(446,	'Pavla',	'Gajdošíková',	'',	'',	'',	'',	0),
(447,	'Taťána',	'Martišková',	'',	'',	'',	'',	0),
(448,	'Radek',	'Macků',	'',	'',	'',	'',	0),
(449,	'Radovan',	'Vítek',	'',	'',	'',	'',	0),
(450,	'Nikola',	'Zemková',	'',	'',	'',	'',	0),
(451,	'Zdena',	'Polomíková',	'',	'',	'',	'',	0),
(452,	'Marie',	'Výletová',	'',	'',	'',	'',	0),
(453,	'Jaroslav',	'Karapčuk',	'',	'',	'',	'',	0),
(454,	'Petra',	'Pavlusková',	'',	'',	'',	'',	0),
(455,	'Stanislav',	'Fojtík',	'',	'',	'',	'',	0),
(456,	'Světlana',	'Polomíková',	'',	'',	'',	'',	0),
(457,	'Tadeáš',	'Častulík',	'',	'',	'',	'',	0),
(458,	'Bronislav',	'Vilímek',	'',	'',	'',	'',	0),
(459,	'Lukáš',	'Lysák',	'',	'',	'',	'',	0),
(460,	'Tomáš',	'Lysák',	'',	'',	'',	'',	0),
(461,	'Jakub',	'Častulík',	'',	'',	'',	'',	0),
(462,	'Ondřej',	'Zahel',	'',	'',	'',	'',	0),
(463,	'Ginter',	'Lukáš',	'',	'',	'',	'',	0),
(464,	'Josef',	'Hořák',	'',	'',	'',	'',	0),
(465,	'Lenka',	'Lewis',	'',	'',	'',	'',	0),
(466,	'David',	'Holcner',	'',	'',	'',	'',	0),
(467,	'Jarmila',	'Výletová',	'',	'',	'',	'',	0),
(468,	'Michal',	'Divoš',	'',	'',	'',	'',	0),
(469,	'Tomáš',	'Kolínek',	'',	'',	'',	'',	0),
(470,	'Pavel',	'Zimek',	'',	'',	'',	'',	0),
(471,	'Josef',	'Šimoník',	'',	'',	'',	'',	0),
(472,	'Klára',	'Zůbková',	'',	'',	'',	'',	0),
(473,	'Lea',	'Bartošková',	'',	'',	'',	'',	0),
(474,	'Kateřina',	'Dorňáková',	'',	'',	'',	'',	0),
(475,	'Michaell',	'Hošíková',	'',	'',	'',	'',	0),
(476,	'Jakub',	'Fojtík',	'',	'',	'',	'',	0),
(477,	'Kevin',	'Šerý',	'',	'',	'',	'',	0),
(478,	'Martin',	'Mléčka',	'',	'',	'',	'',	0),
(479,	'Vendula',	'Dittrichová',	'',	'',	'',	'',	0),
(480,	'andrea',	'Kolínková',	'',	'',	'',	'',	0),
(481,	'Jarmila',	'Tkadlecová',	'',	'',	'',	'',	0),
(482,	'Monika',	'Kolínková',	'',	'',	'',	'',	0),
(483,	'Jakub',	'Kolínek',	'',	'',	'',	'',	0),
(484,	'Martin',	'Raja',	'',	'',	'',	'',	0),
(485,	'Magdaléna',	'Fojtíková',	'',	'',	'',	'',	0),
(486,	'Karolína',	'Fojtíková',	'',	'',	'',	'',	0),
(487,	'Pavel',	'Hrnčiřík',	'',	'',	'',	'',	0),
(488,	'Ivana',	'Holíková',	'',	'',	'',	'',	0),
(489,	'Natálie',	'Nováková',	'',	'',	'',	'',	0),
(490,	'Petra',	'Nováková',	'',	'',	'',	'',	0),
(491,	'Táňa',	'Šenkeříková',	'',	'',	'',	'',	0),
(492,	'Tomáš',	'Holba',	'',	'',	'',	'',	0),
(493,	'Beata',	'Hamšíková',	'',	'',	'',	'',	0),
(494,	'Michal',	'Čech',	'',	'',	'',	'',	0),
(495,	'Staňka',	'Fojtíková',	'',	'',	'',	'',	0),
(496,	'Dan',	'Hrnčiřík',	'',	'',	'',	'',	0),
(497,	'Ludmila',	'Zimková',	'',	'',	'',	'',	0),
(498,	'Marek',	'Novák',	'',	'',	'',	'',	0),
(499,	'Lukáš',	'Bodlák',	'',	'',	'',	'',	0),
(500,	'Lenka',	'Fusková',	'',	'',	'',	'',	0),
(501,	'Petr',	'Mlček',	'',	'',	'',	'',	0),
(502,	'vlastimil',	'Číž',	'',	'',	'',	'',	0),
(503,	'Eva',	'Hnrčiříková',	'',	'',	'',	'',	0),
(504,	'Alex',	'Avramov',	'',	'',	'',	'',	0),
(505,	'Martin',	'Kostka',	'',	'',	'',	'',	0),
(506,	'Polách',	'Jaroslav',	'',	'',	'',	'',	0),
(507,	'Lenka',	'Fůsková',	'',	'',	'',	'',	0),
(508,	'Marie',	'Trochtová',	'',	'',	'',	'',	0),
(509,	'Jiří',	'Polomík',	'',	'',	'',	'',	0),
(510,	'Adela',	'Kovaříková',	'',	'',	'',	'',	0),
(511,	'David',	'Navrátil',	'',	'',	'',	'',	0),
(512,	'Anna',	'Bělašková',	'',	'',	'',	'',	0),
(513,	'Magda',	'Nečesaná',	'',	'',	'',	'',	0),
(514,	'Pavel',	'Vilímek',	'',	'',	'',	'',	0),
(515,	'Vlaďka',	'Haspalová',	'',	'',	'',	'',	0),
(516,	'Michaela',	'Fojtíková',	'',	'',	'',	'',	0),
(517,	'Lucie',	'Macků',	'',	'',	'',	'',	0),
(518,	'Kristýna',	'Divošová',	'',	'',	'',	'',	0),
(519,	'Bronislava',	'Divošová',	'',	'',	'',	'',	0),
(520,	'Iveta',	'Divošová',	'',	'',	'',	'',	0),
(521,	'Filip',	'Řehák',	'',	'',	'',	'',	0),
(522,	'Štěpán',	'Vaněk',	'',	'',	'',	'',	0),
(523,	'Jiří',	'Procházka',	'',	'',	'',	'',	0),
(524,	'Ivana',	'Fojtíková',	'',	'',	'',	'',	0),
(525,	'Karel',	'Obadal',	'',	'',	'',	'',	0),
(526,	'vlastimil',	'Cícha',	'',	'',	'',	'',	0),
(527,	'Zdena',	'Naňáková',	'',	'',	'',	'',	0),
(528,	'Vendula',	'Šmotková',	'',	'',	'',	'',	0),
(529,	'Zuzana',	'Habancová',	'',	'',	'',	'',	0),
(530,	'Jarmila',	'Šuláková',	'',	'',	'',	'',	0),
(531,	'Lucie',	'Bůbelová',	'',	'',	'',	'',	0),
(532,	'Lenka',	'švachová',	'',	'',	'',	'',	0),
(533,	'Adam',	'Šánek',	'',	'',	'',	'',	0),
(534,	'Přemysl',	'Staník',	'',	'',	'',	'',	0),
(535,	'Veronika',	'švachová',	'',	'',	'',	'',	0),
(536,	'Ilona',	'Remešová',	'',	'',	'',	'',	0),
(537,	'Jaroslav',	'Fitěrka',	'',	'',	'',	'',	0),
(538,	'Lenka',	'Fojtů',	'',	'',	'',	'',	0),
(539,	'Martina',	'Miličková',	'',	'',	'',	'',	0),
(540,	'Veronika',	'Řeháková',	'',	'',	'',	'',	0),
(541,	'Josef',	'Cícha',	'',	'',	'',	'',	0),
(542,	'Marie',	'Častulová',	'',	'',	'',	'',	0),
(543,	'Jarmila',	'Vítková',	'',	'',	'',	'',	0),
(544,	'Monika',	'Chromiaková',	'',	'',	'',	'',	0),
(545,	'Martin',	'Chromiak',	'',	'',	'',	'',	0),
(546,	'Dominik',	'Krovina',	'',	'',	'',	'',	0),
(547,	'Lada',	'Šomanová',	'',	'',	'',	'',	0),
(548,	'Kateřina',	'Psotová',	'',	'',	'',	'',	0),
(549,	'Karel',	'Lysák',	'',	'',	'',	'',	0),
(550,	'Lucie',	'Lišková',	'',	'',	'',	'',	0),
(551,	'Lukáš',	'Ptáček',	'',	'',	'',	'',	0),
(552,	'Aleš',	'Ovesný',	'',	'',	'',	'',	0),
(553,	'Vojtěch',	'Chuchma',	'',	'',	'',	'',	0),
(554,	'Drahoslav',	'Piterka',	'',	'',	'',	'',	0),
(555,	'Bohdana',	'Bělašková',	'',	'',	'',	'',	0),
(556,	'Ladislava',	'Kořenková',	'',	'',	'',	'',	0),
(557,	'Nikola',	'Mňačková',	'',	'',	'',	'',	0),
(558,	'Veronika',	'Danielová',	'',	'',	'',	'',	0),
(559,	'Pavla',	'Hořáková',	'',	'',	'',	'',	0),
(560,	'Lenka',	'Matušincová',	'',	'',	'',	'',	0),
(561,	'Petr',	'Bařinka',	'',	'',	'',	'',	0),
(562,	'Veronika',	'Bělašková',	'',	'',	'',	'',	0),
(563,	'Iveta',	'Bělašková',	'',	'',	'',	'',	0),
(564,	'Michal',	'Juráň',	'',	'',	'',	'',	0),
(565,	'Petr',	'Hořák',	'',	'',	'',	'',	0),
(566,	'Štěpán',	'Melcner',	'',	'',	'',	'',	0),
(567,	'Jakub',	'Svoboda',	'',	'',	'',	'',	0),
(568,	'Stanislava',	'švachová',	'',	'',	'',	'',	0),
(569,	'Sabina',	'Košelíková',	'',	'',	'',	'',	0),
(570,	'Zdenek',	'Vilímek',	'',	'',	'',	'',	0),
(571,	'Eva',	'Fojtíková',	'',	'',	'',	'',	0),
(572,	'Radim',	'Bublák',	'',	'',	'',	'',	0),
(573,	'Jana',	'Běhunčíková',	'',	'',	'',	'',	0),
(574,	'Václav',	'Chovanec',	'',	'',	'',	'',	0),
(575,	'Aneta',	'Vítková',	'',	'',	'',	'',	0),
(576,	'Vít',	'Matocha',	'',	'',	'',	'',	0),
(577,	'Simona',	'Goňová',	'',	'',	'',	'',	0),
(578,	'Ondřej',	'Bačo',	'',	'',	'',	'',	0),
(579,	'Ondra',	'Bačo',	'',	'',	'',	'',	0),
(580,	'Monika',	'Marková',	'',	'',	'',	'',	0),
(581,	'Zbyněk',	'Žabčík',	'',	'',	'',	'',	0),
(582,	'Robert',	'Neuwirt',	'',	'',	'',	'',	0),
(583,	'Jan',	'Machala',	'',	'',	'',	'',	0),
(584,	'Tomáš',	'Vrána',	'',	'',	'',	'',	0),
(585,	'Jitka',	'Strnková',	'',	'',	'',	'',	0),
(586,	'Karla',	'Tománková',	'',	'',	'',	'',	0),
(587,	'Marcela',	'Ročáková',	'',	'',	'',	'',	0),
(588,	'Pavla',	'Kolínková',	'',	'',	'',	'',	0),
(589,	'Romana',	'Kostková',	'',	'',	'',	'',	0),
(590,	'Michal',	'Kopčan',	'',	'',	'',	'',	0),
(591,	'Tomáš',	'Tkadlec',	'',	'',	'',	'',	0),
(592,	'Michaela',	'Pacíková',	'',	'',	'',	'',	0),
(593,	'Aleš',	'Smolík',	'',	'',	'',	'',	0),
(594,	'Tomáš',	'Hladníček',	'',	'',	'',	'',	0),
(595,	'Antonín',	'Pašma',	'',	'',	'',	'',	0),
(596,	'Richard',	'Výlet',	'',	'',	'',	'',	0),
(597,	'Pavla',	'Hudečková',	'',	'',	'',	'',	0),
(598,	'Robert',	'Výlet',	'',	'',	'',	'',	0),
(599,	'Krahulec',	'Karel',	'',	'',	'',	'',	0),
(600,	'Alena',	'Matochová',	'',	'',	'',	'',	0),
(601,	'Kristýna',	'Bartošáková',	'',	'',	'',	'',	0),
(602,	'Martina',	'Pinďáková',	'',	'',	'',	'',	0),
(603,	'Marie',	'Pinďáková',	'',	'',	'',	'',	0),
(604,	'Katarina',	'Gogorová',	'',	'',	'',	'',	0),
(605,	'Milan',	'Kolář',	'',	'',	'',	'',	0),
(606,	'Michal',	'Wovra',	'',	'',	'',	'',	0),
(607,	'Dominika',	'Komrsková',	'',	'',	'',	'',	0),
(608,	'Vladimíra',	'Jordan',	'',	'',	'',	'',	0),
(609,	'Vladimíra',	'Jordan ml.',	'',	'',	'',	'',	0),
(610,	'Robin',	'Žák',	'',	'',	'',	'',	0),
(611,	'Rostislav',	'Břuska',	'',	'',	'',	'',	0),
(612,	'Irena',	'Pavlůsková',	'',	'',	'',	'',	0),
(613,	'Filip',	'Machů',	'',	'',	'',	'',	0),
(614,	'Lenka',	'Jurčová',	'',	'',	'',	'',	0),
(615,	'Adela',	'Vaňková',	'',	'',	'',	'',	0),
(616,	'Hana',	'Běhunčíková',	'',	'',	'',	'',	0),
(617,	'Adrian',	'Michalov',	'',	'',	'',	'',	0),
(618,	'Pavla',	'Častulová',	'',	'',	'',	'',	0),
(619,	'Braňo',	'Lass',	'',	'',	'',	'',	0),
(620,	'Mario',	'Marcan',	'',	'',	'',	'',	0),
(621,	'Zdeněk',	'Mikel',	'',	'',	'',	'',	0),
(622,	'David',	'Šerý',	'',	'',	'',	'',	0),
(623,	'Monika',	'Bělašková',	'',	'',	'',	'',	0),
(624,	'Marcela',	'Řepková',	'',	'',	'',	'',	0),
(625,	'Aleš',	'Zvonek',	'',	'',	'',	'',	0),
(626,	'Svatopluk',	'Měrka',	'',	'',	'',	'',	0),
(627,	'Jakub',	'Malaník',	'',	'',	'',	'',	0),
(628,	'Dominik',	'Novák',	'',	'',	'',	'',	0),
(629,	'Petr',	'Novák',	'',	'',	'',	'',	0),
(630,	'Sobotnik',	'Stojan',	'',	'',	'',	'',	0),
(631,	'Daniel',	'Vachůtka',	'',	'',	'',	'',	0),
(632,	'Monika',	'Lesovská',	'',	'',	'',	'',	0),
(633,	'Jindřich',	'Kostka',	'',	'',	'',	'',	0),
(634,	'Marek',	'Růžička',	'',	'',	'',	'',	0),
(635,	'Patrik',	'Jančovič',	'',	'',	'',	'',	0),
(636,	'Zuzana',	'Bačová',	'',	'',	'',	'',	0),
(637,	'Simona',	'Dostálová',	'',	'',	'',	'',	0),
(638,	'Jiří',	'Šuráň',	'',	'',	'',	'',	0),
(639,	'Tomáš',	'Chmela',	'',	'',	'',	'',	0),
(640,	'Sabina',	'Dohnalová',	'',	'',	'',	'',	0),
(641,	'Vojtěch',	'Štepančík',	'',	'',	'',	'',	0),
(642,	'Viktor',	'Šebák',	'',	'',	'',	'',	0),
(643,	'Tomáš',	'Dekleva',	'',	'',	'',	'',	0),
(644,	'Rostislav',	'Číž',	'',	'',	'',	'',	0),
(645,	'Gabriela',	'Fojtíková',	'',	'',	'',	'',	0),
(646,	'Dzian',	'Matúš',	'',	'',	'',	'',	0),
(647,	'Braňo',	'Medzihorský',	'',	'',	'',	'',	0),
(648,	'Pavlína',	'Skřeková',	'',	'',	'',	'',	0),
(649,	'Josef',	'Strnka',	'',	'',	'',	'',	0),
(650,	'Pavlína',	'Valoušková',	'',	'',	'',	'',	0),
(651,	'Adéla',	'Blanařová',	'',	'',	'',	'',	0),
(652,	'Josef',	'Macháč',	'',	'',	'',	'',	0),
(653,	'Dan',	'Fojtík',	'',	'',	'',	'',	0),
(654,	'Jitka',	'Morávková',	'',	'',	'',	'',	0),
(655,	'David',	'Kroupa',	'',	'',	'',	'',	0),
(656,	'Filip',	'Valčík',	'',	'',	'',	'',	0),
(657,	'Kateřina',	'Struhařová',	'',	'',	'',	'',	0),
(658,	'Kristýna',	'Nováková',	'',	'',	'',	'',	0),
(659,	'Jarmila',	'Tománková',	'',	'',	'',	'',	0),
(660,	'Daniela',	'Macků',	'',	'',	'',	'',	0),
(661,	'Marie',	'Divošová',	'',	'',	'',	'',	0),
(662,	'Filip',	'Fojtík',	'',	'',	'',	'',	0),
(663,	'Dominika',	'Fojtíková',	'',	'',	'',	'',	0),
(664,	'Petr',	'Blanař',	'',	'',	'',	'',	0),
(665,	'Lukáš',	'Novák',	'',	'',	'',	'',	0),
(666,	'Dana',	'Tichá',	'',	'',	'',	'',	0),
(667,	'Kristýna',	'Kubíková',	'',	'',	'',	'',	0),
(668,	'Michaela',	'Vilímková',	'',	'',	'',	'',	0),
(669,	'Kamila',	'Hladníčková',	'',	'',	'',	'',	0),
(670,	'Šárka',	'Lysáčková',	'',	'',	'',	'',	0),
(671,	'Viktor',	'Šimoník',	'',	'',	'',	'',	0),
(672,	'Anna',	'Káňová',	'',	'',	'',	'',	0),
(673,	'Stanislava',	'Lysáková',	'',	'',	'',	'',	0),
(674,	'Anna',	'Ťašká',	'',	'',	'',	'',	0),
(675,	'Dana',	'Kozubíková',	'Hůrka',	'',	'',	'',	0),
(676,	'Martina',	'Kozubíková',	'',	'',	'',	'',	0),
(677,	'Miroslava',	'Krůželová',	'',	'',	'',	'',	0),
(678,	'Adela',	'Poláchová',	'',	'',	'',	'',	0),
(679,	'Klára',	'Baksová',	'',	'',	'',	'',	0),
(680,	'Stanislav',	'Polách',	'',	'',	'',	'',	0),
(681,	'Marie',	'Lišková',	'',	'',	'',	'',	0),
(682,	'Bronislava',	'Pětníková',	'',	'',	'',	'',	0),
(683,	'Radek',	'Juráň',	'',	'',	'',	'',	0),
(684,	'Aneta',	'Vránová',	'',	'',	'',	'',	0),
(685,	'Aleš',	'Lysáček',	'',	'',	'',	'',	0),
(686,	'Jan',	'Slovák',	'',	'',	'',	'',	0),
(687,	'Pavel',	'Důbrava',	'',	'',	'',	'',	0),
(688,	'Karel',	'Solař',	'',	'',	'',	'',	0),
(689,	'Marek',	'Šenkeřík',	'',	'',	'',	'',	0),
(690,	'Josef',	'Ptáček',	'',	'',	'',	'',	0),
(691,	'Martin',	'Šabršula',	'',	'',	'',	'',	0),
(692,	'David',	'Nevrlka',	'',	'',	'',	'',	0),
(693,	'Lenka',	'Filáková',	'',	'',	'',	'',	0),
(694,	'Lucie',	'Mikesková',	'',	'',	'',	'',	0),
(695,	'Jarmila',	'Nováková',	'',	'',	'',	'',	0),
(696,	'Jan',	'Mlčuch',	'',	'',	'',	'',	0),
(697,	'Marek',	'Macháč',	'',	'',	'',	'',	0),
(698,	'David',	'Bečák',	'',	'',	'',	'',	0),
(699,	'David',	'Fojtík',	'',	'',	'',	'',	0),
(700,	'Marie',	'Kindlová',	'',	'',	'',	'',	0),
(701,	'Marie',	'Deklevová',	'',	'',	'',	'',	0),
(702,	'Tereza',	'Olejníková',	'',	'',	'',	'',	0),
(703,	'Veronika',	'Matějíčková',	'',	'',	'',	'',	0),
(704,	'Jiří',	'Macháč',	'',	'',	'',	'',	0),
(705,	'Ondra',	'Studénka',	'',	'',	'',	'',	0),
(706,	'Radek',	'Mikšík',	'',	'',	'',	'',	0),
(707,	'Pavel',	'Lysáček',	'',	'',	'',	'',	0),
(708,	'Jiří',	'Daberger',	'',	'',	'',	'',	0),
(709,	'Tomáš',	'Ritter',	'',	'',	'',	'',	0),
(710,	'Veronika',	'Šenkeříková',	'',	'',	'',	'',	0),
(711,	'Lucie',	'Kalabisová',	'',	'',	'',	'',	0),
(712,	'Libor',	'Barbořík',	'',	'',	'',	'',	0),
(713,	'Božena',	'Fojtíková',	'',	'',	'',	'',	0),
(714,	'Michaela',	'Janáčová',	'',	'',	'',	'',	0),
(715,	'Kristian',	'Skuček',	'',	'',	'',	'',	0),
(716,	'Gábina',	'Kovaříková',	'',	'',	'',	'',	0),
(717,	'Kamila',	'Hořáková',	'',	'',	'',	'',	0),
(718,	'iva',	'Hořáková',	'',	'',	'',	'',	0),
(719,	'Ondra',	'Hošík',	'',	'',	'',	'',	0),
(720,	'Zuzana',	'Marcaníková',	'',	'',	'',	'',	0),
(721,	'Petra',	'Kuželová',	'',	'',	'',	'',	0),
(722,	'Šimon',	'Jílek',	'',	'',	'',	'',	0),
(723,	'Romana',	'Bartošová',	'',	'',	'',	'',	0),
(724,	'Klára',	'Vlčková',	'',	'',	'',	'',	0),
(725,	'Lenka',	'Juřicová',	'',	'',	'',	'',	0),
(726,	'Lenka',	'Tichá',	'',	'',	'',	'',	0),
(727,	'Zuzana',	'Váchová',	'',	'',	'',	'',	0),
(728,	'Kamila',	'Fialová',	'',	'',	'',	'',	0),
(729,	'František',	'Surý',	'',	'',	'',	'',	0),
(730,	'Petra',	'Strnadová',	'',	'',	'',	'',	0),
(731,	'Tereza',	'Zvonková',	'',	'',	'',	'',	0),
(732,	'Tamara',	'Šimšálková',	'',	'',	'',	'',	0),
(733,	'Jessica',	'Gabrišová',	'',	'',	'',	'',	0),
(734,	'Petra',	'Daňhelová',	'',	'',	'',	'',	0),
(735,	'Libor',	'Strnka',	'',	'',	'',	'',	0),
(736,	'Adéla',	'Trčková',	'',	'',	'',	'',	0),
(737,	'Radim',	'Šenkeřík',	'',	'',	'',	'',	0),
(738,	'Jitka',	'Struhařová',	'',	'',	'',	'',	0),
(739,	'Jana',	'Struhařová',	'',	'',	'',	'',	0),
(740,	'Stanislav',	'Kostka',	'',	'',	'',	'',	0),
(741,	'Nikola',	'Hanzelyová',	'',	'',	'',	'',	0),
(742,	'Marek',	'Fojtík',	'',	'',	'',	'',	0),
(743,	'Pavel',	'Fojtík',	'',	'',	'',	'',	0),
(744,	'Libor',	'Holba',	'',	'',	'',	'',	0),
(745,	'Zuzka',	'Bačicová',	'',	'',	'',	'',	0),
(746,	'Filip',	'Jančařík',	'',	'',	'',	'',	0),
(747,	'Dominik',	'Vyoral',	'',	'',	'',	'',	0),
(748,	'Miroslav',	'Hanzlík',	'',	'',	'',	'',	0),
(749,	'Eliška',	'Strejčková',	'',	'',	'',	'',	0),
(750,	'Jakub',	'Hošík',	'',	'',	'',	'',	0),
(751,	'Barbora',	'Ďulíková',	'',	'',	'',	'',	0),
(752,	'Michaela',	'Naňáková',	'',	'',	'',	'',	0),
(753,	'Zuzana',	'Bečicová',	'',	'',	'',	'',	0),
(754,	'Monika',	'Bučková',	'',	'',	'',	'',	0),
(755,	'Anna',	'Bařinková',	'',	'',	'',	'',	0),
(756,	'Lenka',	'Naňáková',	'',	'',	'',	'',	0),
(757,	'Jan',	'Matůš',	'',	'',	'',	'',	0),
(758,	'Filip',	'Cícha',	'',	'',	'',	'',	0),
(759,	'Andrea',	'Bařinková',	'',	'',	'',	'',	0),
(760,	'Eda',	'Koler',	'',	'',	'',	'',	0),
(761,	'Šárka',	'Krahulová',	'',	'',	'',	'',	0),
(762,	'Miroslav',	'Obadal',	'',	'',	'',	'',	0),
(763,	'Simona',	'Košelková',	'',	'',	'',	'',	0),
(764,	'Jakub',	'Struhař',	'',	'',	'',	'',	0),
(765,	'Miroslav',	'Bartoška',	'',	'',	'',	'',	0),
(766,	'Daniel',	'Lukáň',	'',	'',	'',	'',	0),
(767,	'Veronika',	'Báhnová',	'',	'',	'',	'',	0),
(768,	'Michaela',	'Manová',	'',	'',	'',	'',	0),
(769,	'Roman',	'Hrbáček',	'',	'',	'',	'',	0),
(770,	'Patrik',	'Písařovic',	'',	'',	'',	'',	0),
(771,	'Jan',	'Chlupáček',	'',	'',	'',	'',	0),
(772,	'Eva',	'Bartošáková',	'',	'',	'',	'',	0),
(773,	'Eva',	'Marková',	'',	'',	'',	'',	0),
(774,	'Klára',	'Šimšálková',	'',	'',	'',	'',	0),
(775,	'David',	'Heidrich',	'',	'',	'',	'',	0),
(776,	'Kryštof',	'Kudela',	'',	'',	'',	'',	0),
(777,	'Petr',	'Vaculík',	'',	'',	'',	'',	0),
(778,	'Juraj',	'Miklátek',	'',	'',	'',	'',	0),
(779,	'Michal',	'Rejzík',	'',	'',	'',	'',	0),
(780,	'Andrej',	'Štefánek',	'',	'',	'',	'',	0),
(781,	'Mirek',	'Kostka',	'',	'',	'',	'',	0),
(782,	'Luděk',	'Martinka',	'',	'',	'',	'',	0),
(783,	'Robin',	'Králík',	'',	'',	'',	'',	0),
(784,	'Hana',	'Jurkova',	'',	'',	'',	'',	0),
(785,	'Pavla',	'Nana',	'',	'',	'',	'',	0),
(786,	'Pavla',	'Nana',	'',	'',	'',	'',	0),
(787,	'Pavla',	'Naňáková',	'',	'',	'',	'',	0),
(788,	'Radovan',	'Barbořík',	'',	'',	'',	'',	0),
(789,	'Richard',	'Morávek',	'',	'',	'',	'',	0),
(790,	'František',	'Vaculík',	'',	'',	'',	'',	0),
(791,	'Nikol',	'Bečáková',	'',	'',	'',	'',	0),
(792,	'Dominika',	'Dolšova',	'',	'',	'',	'',	0),
(793,	'Honza',	'Machala',	'',	'',	'',	'',	0),
(794,	'Pavel',	'Macek',	'',	'',	'',	'',	0),
(795,	'Michal',	'Pecl',	'',	'',	'',	'',	0),
(796,	'Adam',	'Polách',	'',	'',	'',	'',	0),
(797,	'Denisa',	'Hnaníčková',	'',	'',	'',	'',	0),
(798,	'jana',	'šimonikova',	'',	'',	'',	'',	0),
(799,	'jan',	'Šimonik',	'',	'',	'',	'',	0),
(800,	'Gábina',	'Hořáková',	'',	'',	'',	'',	0),
(801,	'Jakub',	'Molnár',	'',	'',	'',	'',	0),
(802,	'Tomáš',	'Kostka',	'',	'',	'',	'',	0),
(803,	'Tereza',	'Ďulíková',	'',	'',	'',	'',	0),
(804,	'Tomaš',	'Lysaček',	'',	'',	'',	'',	0),
(805,	'Pavel',	'Machách',	'',	'',	'',	'',	0),
(806,	'Petr',	'Šuráň',	'',	'',	'',	'',	0),
(807,	'Andrea',	'Filova',	'',	'',	'',	'',	0),
(808,	'Jiří',	'Hladníček',	'',	'',	'',	'',	0),
(809,	'libor',	'Kubiš',	'',	'',	'',	'',	0),
(810,	'Matej',	'Kubiš',	'',	'',	'',	'',	0),
(811,	'Hana',	'Tažka',	'',	'',	'',	'',	0),
(812,	'Radek',	'Tarabus',	'',	'',	'',	'',	0),
(813,	'Mirek',	'Zaremba',	'',	'',	'',	'',	0),
(814,	'Petr',	'Smilek',	'',	'',	'',	'',	0),
(815,	'Michal',	'Častula',	'',	'',	'',	'',	0),
(816,	'Kristína',	'Beranová',	'',	'',	'',	'',	0),
(817,	'Gabriel',	'Kaško',	'',	'',	'',	'',	0),
(818,	'Monika',	'Davidová',	'',	'',	'',	'',	0),
(819,	'Michal',	'Ekart',	'',	'',	'',	'',	0),
(820,	'Martin',	'Miča',	'',	'',	'',	'',	0),
(821,	'Nikola',	'Stojanovič',	'',	'',	'',	'',	0),
(822,	'Denisa',	'Nováková',	'',	'',	'',	'',	0),
(823,	'Jakub',	'Orsák',	'',	'',	'',	'',	0),
(824,	'Kamil',	'Zůbek',	'',	'',	'',	'',	0),
(825,	'Lenka',	'Krejčířová',	'',	'',	'',	'',	0),
(826,	'Gábina',	'Michková',	'',	'',	'',	'',	0),
(827,	'Tomáš',	'Foltýn',	'',	'',	'',	'',	0),
(828,	'Jitka',	'Miklasová',	'',	'',	'',	'',	0),
(829,	'Michaela',	'Tribusová',	'',	'',	'',	'',	0),
(830,	'Kateřina',	'Haspalová',	'',	'',	'',	'',	0),
(831,	'Lukáš',	'Valášek',	'',	'',	'',	'',	0),
(832,	'David',	'Fojtík',	'',	'',	'',	'',	0),
(833,	'Gabriela',	'Bifkova',	'',	'',	'',	'',	0),
(834,	'Mackova',	'Andrea',	'',	'',	'',	'',	0),
(835,	'Anton',	'Floriš',	'',	'',	'',	'',	0),
(836,	'Jiři',	'Valek',	'',	'',	'',	'',	0),
(837,	'Roman',	'Krahula',	'',	'',	'',	'',	0),
(838,	'Romana',	'Zollerová',	'',	'',	'',	'',	0),
(839,	'Patrik',	'Pagáč',	'',	'',	'',	'',	0),
(840,	'Martina',	'Lišková',	'',	'',	'',	'',	0),
(841,	'Václav',	'Janáč',	'',	'',	'',	'',	0),
(842,	'Daniela',	'Ticha',	'',	'',	'',	'',	0),
(843,	'Klara',	'Juřečkova',	'',	'',	'',	'',	0),
(844,	'Martin',	'Kořenek',	'',	'',	'',	'',	0),
(845,	'Pavel',	'Chovanec',	'',	'',	'',	'',	0),
(846,	'Ivana',	'Bařynkova',	'',	'',	'',	'',	0),
(847,	'Tomáš',	'Bublák',	'',	'',	'',	'',	0),
(848,	'Miroslava',	'Bařinková',	'',	'',	'',	'',	0),
(849,	'Patricia',	'Bařynkova',	'',	'',	'',	'',	0),
(850,	'Kristína',	'Šantová',	'',	'',	'',	'',	0),
(851,	'Adéla',	'Kalíková',	'',	'',	'',	'',	0),
(852,	'Jiří',	'Husička',	'',	'',	'',	'',	0),
(853,	'Peto',	'Janač',	'',	'',	'',	'',	0),
(854,	'Pavel',	'Macháč',	'',	'',	'',	'',	0),
(855,	'Karykova',	'ADELA',	'',	'123456780',	'',	'',	0),
(856,	'Lukáš',	'Martinka',	'',	'',	'',	'',	0),
(857,	'Martina',	'Řeháková',	'',	'',	'',	'',	0),
(858,	'Veronika',	'Holbová',	'',	'',	'',	'',	0),
(859,	'Vašek',	'Janač',	'',	'',	'',	'',	0),
(860,	'Gabriela',	'šanková',	'',	'',	'',	'',	0),
(861,	'Katarina',	'Lysačková',	'',	'',	'',	'',	0),
(862,	'Andrea',	'škrobalova',	'',	'',	'',	'',	0),
(863,	'Vorzalykova',	'Michaela',	'',	'',	'',	'',	0),
(864,	'Miroslav',	'Vaněk',	'',	'',	'',	'',	0),
(865,	'Alois',	'Myšák',	'',	'',	'',	'',	0),
(866,	'Jana',	'Švachová',	'',	'',	'',	'',	0),
(867,	'Lucie',	'Molnárová',	'',	'',	'',	'',	0),
(868,	'Lucie',	'Konečná',	'',	'',	'',	'',	0),
(869,	'Ondřej',	'Orsak',	'',	'',	'',	'',	0),
(870,	'Barbora',	'Švachova',	'',	'',	'',	'',	0),
(871,	'Vlastimil',	'Martinák',	'',	'',	'',	'',	0),
(872,	'Vlasta',	'Šenkeříková',	'',	'',	'',	'',	0),
(873,	'Michal',	'Dulik',	'',	'',	'',	'',	0),
(874,	'Magda',	'Stunten',	'',	'',	'',	'',	0),
(875,	'Miša',	'Miklasova',	'',	'',	'',	'',	0),
(876,	'Radek',	'Hnylo',	'',	'',	'',	'',	0),
(877,	'Jakub',	'Molnar',	'',	'',	'',	'',	0),
(878,	'Markéta',	'Dorňáková',	'',	'',	'',	'',	0),
(879,	'Filip',	'Hovorák',	'',	'',	'',	'',	0),
(880,	'Václav',	'Hlavička',	'',	'',	'',	'',	0),
(881,	'Kryštof',	'Ambrůz',	'',	'',	'',	'',	0),
(882,	'Mariana',	'Brychtová',	'',	'',	'',	'',	0),
(883,	'Hnanyčkova',	'Karolina',	'',	'',	'',	'',	0),
(884,	'Eva',	'Pindakova',	'',	'',	'',	'',	0),
(885,	'Jana',	'Macková',	'',	'',	'',	'',	0),
(886,	'Michaela',	'Miklasová',	'',	'',	'',	'',	0),
(887,	'Ondřej',	'Vaculyk',	'',	'',	'',	'',	0),
(888,	'Marketa',	'Krahulyková',	'',	'',	'',	'',	0),
(889,	'Ondra',	'Vaněk',	'',	'',	'',	'',	0),
(890,	'jakub',	'svoboda',	'',	'',	'',	'',	0),
(891,	'dalibor',	'bečak',	'',	'',	'',	'',	0),
(892,	'dalibor',	'bečak',	'',	'',	'',	'',	0),
(893,	'Romana',	'Frkalová',	'',	'',	'',	'',	0),
(894,	'david',	'novak',	'',	'',	'',	'',	0),
(895,	'Dan',	'Polach',	'',	'',	'',	'',	0),
(896,	'Radek',	'Divoš',	'',	'',	'',	'',	0),
(897,	'Vlaďka',	'Petrů',	'',	'',	'',	'',	0),
(898,	'Patrik',	'Žilkay',	'',	'',	'',	'',	0),
(899,	'Jakub',	'Naňák',	'',	'',	'',	'',	0),
(900,	'Jiří',	'Kakerger',	'',	'',	'',	'',	0),
(901,	'Tomáš',	'Kvasnička',	'',	'',	'',	'',	0),
(902,	'Eva',	'Ludníková',	'',	'',	'',	'',	0),
(903,	'Petra',	'Mišáková',	'',	'',	'',	'',	0),
(904,	'Ludmila',	'Divošová',	'',	'',	'',	'',	0),
(905,	'Alena',	'Naňáková',	'',	'',	'',	'',	0),
(906,	'Veronika',	'Kolmanová',	'',	'',	'',	'',	0),
(907,	'Monika',	'Šánková',	'',	'',	'',	'',	0),
(908,	'Marcela',	'Kolínková',	'',	'',	'',	'',	0),
(909,	'Jaroslav',	'Bůbela',	'',	'',	'',	'',	0),
(910,	'David',	'Fojtík st.',	'',	'',	'',	'',	0),
(911,	'Marek',	'Šuchma',	'',	'',	'',	'',	0),
(912,	'Csilla',	'Nagyová',	'',	'',	'',	'',	0),
(913,	'Tereza',	'Kachlíková',	'',	'',	'',	'',	0),
(914,	'Kateřina',	'Slaběňáková',	'',	'',	'',	'',	0),
(915,	'Filip',	'Naňák',	'',	'',	'',	'',	0),
(916,	'Leona',	'Fojtíková',	'',	'',	'',	'',	0),
(917,	'Pavla',	'Jeřábková',	'',	'',	'',	'',	0),
(918,	'Ferda',	'Mravenec',	'',	'123456789',	'',	'',	0),
(919,	'Ferda',	'Mravenec',	'',	'',	'',	'',	0),
(920,	'Ferda',	'Mravenec',	'hmyzák',	'14578541',	'+420157448',	'Mraveniště',	0);

CREATE TABLE `directpaid` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `utCreated` int(10) unsigned NOT NULL,
  `utClosed` int(11) DEFAULT NULL,
  `customerId` int(10) unsigned DEFAULT NULL,
  `note` varchar(200) COLLATE utf8_czech_ci DEFAULT NULL,
  `userId` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_directPaid_customer1_idx` (`customerId`),
  KEY `fk_directPaid_user1_idx` (`userId`),
  CONSTRAINT `fk_directPaid_customer1` FOREIGN KEY (`customerId`) REFERENCES `customer` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_directPaid_user1` FOREIGN KEY (`userId`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;


CREATE TABLE `package` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) COLLATE utf8_czech_ci NOT NULL,
  `validDuration` int(11) DEFAULT NULL,
  `credit` decimal(10,0) DEFAULT NULL,
  `deleted` tinyint(1) unsigned NOT NULL,
  `creditChargeable` tinyint(1) unsigned NOT NULL,
  `creditNegative` tinyint(1) unsigned NOT NULL,
  `notifyBefore` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

INSERT INTO `package` (`id`, `name`, `validDuration`, `credit`, `deleted`, `creditChargeable`, `creditNegative`, `notifyBefore`) VALUES
(1,	'PILOXING',	NULL,	0,	0,	0,	0,	NULL),
(2,	'TAEBO',	NULL,	0,	0,	0,	0,	NULL),
(3,	'FITNESS',	NULL,	0,	0,	0,	0,	NULL),
(4,	'PILOXING',	NULL,	0,	1,	0,	0,	NULL),
(5,	'Měsíční vstup',	34187400,	0,	0,	0,	0,	NULL),
(6,	'Kredit',	NULL,	0,	0,	1,	0,	NULL),
(7,	'Vstup na měsíc',	2629800,	0,	0,	0,	0,	259200),
(8,	'Rum 10×',	NULL,	0,	0,	0,	0,	NULL);

CREATE TABLE `packageProduct` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `packageId` int(10) unsigned NOT NULL,
  `productId` int(10) unsigned NOT NULL,
  `amount` double DEFAULT NULL,
  `fromCredit` tinyint(1) NOT NULL,
  `priceCredit` decimal(10,0) DEFAULT NULL,
  `priceDirect` decimal(10,0) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_packageProduct_package1_idx` (`packageId`),
  KEY `fk_packageProduct_product1_idx` (`productId`),
  CONSTRAINT `fk_packageProduct_package1` FOREIGN KEY (`packageId`) REFERENCES `package` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_packageProduct_product1` FOREIGN KEY (`productId`) REFERENCES `product` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

INSERT INTO `packageProduct` (`id`, `packageId`, `productId`, `amount`, `fromCredit`, `priceCredit`, `priceDirect`) VALUES
(1,	1,	2,	10,	0,	NULL,	NULL),
(2,	1,	4,	NULL,	0,	NULL,	NULL),
(3,	1,	6,	NULL,	0,	NULL,	NULL),
(4,	2,	2,	10,	0,	NULL,	NULL),
(5,	2,	4,	NULL,	0,	NULL,	NULL),
(6,	2,	6,	NULL,	0,	NULL,	NULL),
(7,	3,	2,	11,	0,	NULL,	NULL),
(8,	3,	4,	NULL,	0,	NULL,	NULL),
(9,	3,	6,	NULL,	0,	NULL,	NULL),
(10,	4,	2,	10,	0,	NULL,	NULL),
(11,	4,	4,	NULL,	0,	NULL,	NULL),
(12,	4,	6,	NULL,	0,	NULL,	NULL),
(13,	5,	2,	NULL,	0,	NULL,	0),
(14,	5,	38,	10,	0,	NULL,	NULL),
(15,	5,	39,	NULL,	1,	NULL,	NULL),
(16,	5,	40,	NULL,	1,	300,	NULL),
(17,	5,	41,	NULL,	0,	NULL,	NULL),
(18,	5,	42,	NULL,	0,	NULL,	NULL),
(19,	5,	43,	NULL,	0,	NULL,	NULL),
(20,	5,	44,	NULL,	0,	NULL,	NULL),
(21,	5,	47,	NULL,	0,	NULL,	NULL),
(22,	5,	48,	NULL,	0,	NULL,	NULL),
(23,	5,	49,	NULL,	0,	NULL,	NULL),
(24,	5,	50,	NULL,	0,	NULL,	NULL),
(25,	5,	51,	NULL,	0,	NULL,	NULL),
(26,	5,	52,	NULL,	0,	NULL,	NULL),
(27,	5,	53,	NULL,	0,	NULL,	NULL),
(28,	5,	54,	NULL,	0,	NULL,	NULL),
(29,	5,	55,	NULL,	0,	NULL,	NULL),
(30,	5,	56,	NULL,	0,	NULL,	NULL),
(31,	5,	37,	NULL,	0,	NULL,	NULL),
(32,	5,	36,	NULL,	0,	NULL,	NULL),
(33,	5,	4,	NULL,	0,	NULL,	NULL),
(34,	5,	6,	NULL,	0,	NULL,	NULL),
(35,	5,	15,	NULL,	0,	NULL,	NULL),
(36,	5,	17,	NULL,	0,	NULL,	NULL),
(37,	5,	18,	NULL,	0,	NULL,	NULL),
(38,	5,	19,	NULL,	0,	NULL,	NULL),
(39,	5,	20,	NULL,	0,	NULL,	NULL),
(40,	5,	21,	NULL,	0,	NULL,	NULL),
(41,	5,	22,	NULL,	0,	NULL,	NULL),
(42,	5,	23,	NULL,	0,	NULL,	NULL),
(43,	5,	24,	NULL,	0,	NULL,	NULL),
(44,	5,	25,	NULL,	0,	NULL,	NULL),
(45,	5,	26,	NULL,	0,	NULL,	NULL),
(46,	5,	29,	NULL,	0,	NULL,	NULL),
(47,	5,	31,	NULL,	0,	NULL,	NULL),
(48,	5,	33,	NULL,	0,	NULL,	NULL),
(49,	5,	34,	NULL,	0,	NULL,	NULL),
(50,	5,	58,	NULL,	0,	NULL,	NULL),
(51,	6,	2,	NULL,	1,	123,	NULL),
(52,	6,	38,	NULL,	1,	45,	NULL),
(53,	6,	39,	NULL,	1,	56,	NULL),
(54,	6,	40,	NULL,	1,	NULL,	NULL),
(55,	6,	41,	NULL,	1,	NULL,	NULL),
(56,	6,	42,	NULL,	1,	NULL,	NULL),
(57,	6,	43,	NULL,	1,	NULL,	NULL),
(58,	6,	44,	NULL,	1,	NULL,	NULL),
(59,	6,	47,	NULL,	1,	NULL,	NULL),
(60,	6,	48,	NULL,	1,	NULL,	NULL),
(61,	6,	49,	NULL,	1,	NULL,	NULL),
(62,	6,	50,	NULL,	1,	NULL,	NULL),
(63,	6,	51,	NULL,	1,	NULL,	NULL),
(64,	6,	52,	NULL,	1,	NULL,	NULL),
(65,	6,	53,	NULL,	1,	NULL,	NULL),
(66,	6,	54,	NULL,	1,	NULL,	NULL),
(67,	6,	55,	NULL,	1,	NULL,	NULL),
(68,	6,	56,	NULL,	1,	NULL,	NULL),
(69,	6,	37,	NULL,	1,	NULL,	NULL),
(70,	6,	36,	NULL,	1,	NULL,	NULL),
(71,	6,	4,	NULL,	1,	NULL,	NULL),
(72,	6,	6,	NULL,	1,	NULL,	NULL),
(73,	6,	15,	NULL,	1,	NULL,	NULL),
(74,	6,	17,	NULL,	1,	NULL,	NULL),
(75,	6,	18,	NULL,	1,	NULL,	NULL),
(76,	6,	19,	NULL,	1,	NULL,	NULL),
(77,	6,	20,	NULL,	1,	NULL,	NULL),
(78,	6,	21,	NULL,	1,	NULL,	NULL),
(79,	6,	22,	NULL,	1,	NULL,	NULL),
(80,	6,	23,	NULL,	1,	NULL,	NULL),
(81,	6,	24,	NULL,	1,	NULL,	NULL),
(82,	6,	25,	NULL,	1,	NULL,	NULL),
(83,	6,	26,	NULL,	1,	NULL,	NULL),
(84,	6,	29,	NULL,	1,	NULL,	NULL),
(85,	6,	31,	NULL,	1,	NULL,	NULL),
(86,	6,	33,	NULL,	1,	NULL,	NULL),
(87,	6,	34,	NULL,	1,	NULL,	NULL),
(88,	6,	58,	NULL,	1,	NULL,	NULL),
(90,	1,	38,	1,	0,	NULL,	NULL),
(91,	1,	39,	NULL,	0,	NULL,	NULL),
(92,	1,	40,	NULL,	0,	NULL,	NULL),
(93,	1,	41,	NULL,	0,	NULL,	NULL),
(94,	1,	42,	NULL,	0,	NULL,	NULL),
(95,	1,	43,	NULL,	0,	NULL,	NULL),
(96,	1,	44,	2,	0,	NULL,	NULL),
(97,	1,	47,	NULL,	1,	NULL,	NULL),
(98,	1,	48,	NULL,	1,	5,	NULL),
(99,	1,	49,	NULL,	0,	NULL,	44),
(100,	1,	50,	NULL,	0,	NULL,	55),
(101,	1,	51,	NULL,	0,	NULL,	66),
(102,	1,	52,	NULL,	0,	NULL,	77),
(103,	1,	53,	NULL,	0,	NULL,	NULL),
(104,	1,	54,	NULL,	0,	NULL,	NULL),
(105,	1,	55,	NULL,	0,	NULL,	NULL),
(106,	1,	56,	NULL,	0,	NULL,	NULL),
(107,	1,	37,	NULL,	0,	NULL,	NULL),
(108,	1,	36,	NULL,	0,	NULL,	NULL),
(109,	1,	17,	NULL,	0,	NULL,	NULL),
(110,	1,	18,	NULL,	0,	NULL,	NULL),
(111,	1,	19,	NULL,	0,	NULL,	NULL),
(112,	1,	20,	NULL,	0,	NULL,	NULL),
(113,	1,	21,	NULL,	0,	NULL,	NULL),
(114,	1,	22,	NULL,	0,	NULL,	NULL),
(115,	1,	23,	NULL,	0,	NULL,	NULL),
(116,	1,	34,	NULL,	0,	NULL,	NULL),
(117,	1,	33,	NULL,	0,	NULL,	NULL),
(118,	1,	31,	NULL,	0,	NULL,	NULL),
(119,	1,	29,	NULL,	0,	NULL,	NULL),
(120,	1,	26,	NULL,	0,	NULL,	NULL),
(121,	1,	25,	NULL,	0,	NULL,	NULL),
(122,	1,	24,	NULL,	0,	NULL,	NULL),
(123,	1,	58,	NULL,	0,	NULL,	NULL),
(124,	1,	15,	NULL,	0,	NULL,	NULL),
(125,	7,	2,	NULL,	0,	NULL,	0),
(126,	7,	38,	NULL,	0,	NULL,	NULL),
(127,	7,	39,	NULL,	0,	NULL,	NULL),
(128,	7,	40,	NULL,	0,	NULL,	NULL),
(129,	7,	41,	NULL,	0,	NULL,	NULL),
(130,	7,	42,	NULL,	0,	NULL,	NULL),
(131,	7,	43,	NULL,	0,	NULL,	NULL),
(132,	7,	44,	NULL,	0,	NULL,	NULL),
(133,	7,	47,	NULL,	0,	NULL,	NULL),
(134,	7,	48,	NULL,	0,	NULL,	NULL),
(135,	7,	49,	NULL,	0,	NULL,	NULL),
(136,	7,	50,	NULL,	0,	NULL,	NULL),
(137,	7,	51,	NULL,	0,	NULL,	NULL),
(138,	7,	52,	NULL,	0,	NULL,	NULL),
(139,	7,	53,	NULL,	0,	NULL,	NULL),
(140,	7,	54,	NULL,	0,	NULL,	NULL),
(141,	7,	55,	NULL,	0,	NULL,	NULL),
(142,	7,	56,	NULL,	0,	NULL,	NULL),
(143,	7,	37,	NULL,	0,	NULL,	NULL),
(144,	7,	36,	NULL,	0,	NULL,	NULL),
(145,	7,	4,	NULL,	0,	NULL,	NULL),
(146,	7,	6,	NULL,	0,	NULL,	NULL),
(147,	7,	17,	NULL,	0,	NULL,	NULL),
(148,	7,	18,	NULL,	0,	NULL,	NULL),
(149,	7,	19,	NULL,	0,	NULL,	NULL),
(150,	7,	20,	NULL,	0,	NULL,	NULL),
(151,	7,	21,	NULL,	0,	NULL,	NULL),
(152,	7,	22,	NULL,	0,	NULL,	NULL),
(153,	7,	23,	NULL,	0,	NULL,	NULL),
(154,	7,	34,	NULL,	0,	NULL,	NULL),
(155,	7,	33,	NULL,	0,	NULL,	NULL),
(156,	7,	31,	NULL,	0,	NULL,	NULL),
(157,	7,	29,	NULL,	0,	NULL,	NULL),
(158,	7,	26,	NULL,	0,	NULL,	NULL),
(159,	7,	25,	NULL,	0,	NULL,	NULL),
(160,	7,	24,	NULL,	0,	NULL,	NULL),
(161,	7,	58,	NULL,	0,	NULL,	NULL),
(162,	7,	15,	NULL,	0,	NULL,	NULL),
(163,	7,	66,	NULL,	0,	NULL,	NULL),
(164,	7,	65,	NULL,	0,	NULL,	NULL),
(165,	7,	64,	NULL,	0,	NULL,	NULL),
(166,	7,	63,	NULL,	0,	NULL,	NULL),
(167,	6,	66,	NULL,	0,	5,	NULL),
(168,	6,	65,	NULL,	0,	NULL,	NULL),
(169,	6,	64,	NULL,	0,	NULL,	NULL),
(170,	6,	63,	NULL,	0,	NULL,	NULL),
(171,	8,	66,	10,	0,	NULL,	NULL),
(172,	8,	49,	NULL,	0,	NULL,	NULL),
(173,	8,	48,	NULL,	0,	NULL,	NULL),
(174,	8,	47,	NULL,	0,	NULL,	NULL),
(175,	8,	44,	NULL,	0,	NULL,	NULL),
(176,	8,	43,	NULL,	0,	NULL,	NULL),
(177,	8,	42,	NULL,	0,	NULL,	NULL),
(178,	8,	41,	NULL,	0,	NULL,	NULL),
(179,	8,	40,	NULL,	0,	NULL,	NULL),
(180,	8,	50,	NULL,	0,	NULL,	NULL),
(181,	8,	51,	NULL,	0,	NULL,	NULL),
(182,	8,	52,	NULL,	0,	NULL,	NULL),
(183,	8,	65,	NULL,	0,	NULL,	NULL),
(184,	8,	64,	NULL,	0,	NULL,	NULL),
(185,	8,	63,	NULL,	0,	NULL,	NULL),
(186,	8,	58,	NULL,	0,	NULL,	NULL),
(187,	8,	56,	NULL,	0,	NULL,	NULL),
(188,	8,	55,	NULL,	0,	NULL,	NULL),
(189,	8,	54,	NULL,	0,	NULL,	NULL),
(190,	8,	53,	NULL,	0,	NULL,	NULL),
(191,	8,	39,	NULL,	0,	NULL,	NULL),
(192,	8,	38,	NULL,	0,	NULL,	NULL),
(193,	8,	22,	NULL,	0,	NULL,	NULL),
(194,	8,	21,	NULL,	0,	NULL,	NULL),
(195,	8,	20,	NULL,	0,	NULL,	NULL),
(196,	8,	19,	NULL,	0,	NULL,	NULL),
(197,	8,	18,	NULL,	0,	NULL,	NULL),
(198,	8,	17,	NULL,	0,	NULL,	NULL),
(199,	8,	6,	NULL,	0,	NULL,	NULL),
(200,	8,	4,	NULL,	0,	NULL,	NULL),
(201,	8,	23,	NULL,	0,	NULL,	NULL),
(202,	8,	24,	NULL,	0,	NULL,	NULL),
(203,	8,	37,	NULL,	0,	NULL,	NULL),
(204,	8,	36,	NULL,	0,	NULL,	NULL),
(205,	8,	34,	NULL,	0,	NULL,	NULL),
(206,	8,	33,	NULL,	0,	NULL,	NULL),
(207,	8,	31,	NULL,	0,	NULL,	NULL),
(208,	8,	29,	NULL,	0,	NULL,	NULL),
(209,	8,	26,	NULL,	0,	NULL,	NULL),
(210,	8,	25,	NULL,	0,	NULL,	NULL),
(211,	8,	2,	NULL,	0,	NULL,	NULL),
(212,	8,	15,	NULL,	0,	NULL,	NULL);

CREATE TABLE `prepaid` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `utCreated` int(10) unsigned NOT NULL,
  `utValidFrom` int(10) unsigned DEFAULT NULL,
  `utValidTo` int(10) unsigned DEFAULT NULL,
  `creditLeftRegular` decimal(10,0) NOT NULL,
  `creditLeftBonus` decimal(10,0) NOT NULL DEFAULT '0',
  `customerId` int(10) unsigned NOT NULL,
  `packageId` int(10) unsigned NOT NULL,
  `userId` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_prepaid_customer_idx` (`customerId`),
  KEY `fk_prepaid_package1_idx` (`packageId`),
  KEY `fk_prepaid_user1_idx` (`userId`),
  CONSTRAINT `fk_prepaid_customer` FOREIGN KEY (`customerId`) REFERENCES `customer` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_prepaid_package1` FOREIGN KEY (`packageId`) REFERENCES `package` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_prepaid_user1` FOREIGN KEY (`userId`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;


CREATE TABLE `prepaidChange` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `prepaidId` int(10) unsigned NOT NULL,
  `utChange` int(10) unsigned NOT NULL,
  `userId` int(10) unsigned NOT NULL,
  `change` text COLLATE utf8_czech_ci NOT NULL,
  `note` text COLLATE utf8_czech_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `userId` (`userId`),
  KEY `prepaidId` (`prepaidId`),
  CONSTRAINT `prepaidChange_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `user` (`id`),
  CONSTRAINT `prepaidChange_ibfk_2` FOREIGN KEY (`prepaidId`) REFERENCES `prepaid` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;


CREATE TABLE `prepaidPackageProduct` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `prepaidId` int(10) unsigned NOT NULL,
  `packageProductId` int(10) unsigned NOT NULL,
  `amountLeft` double NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_prepaidPackageProduct_prepaid1_idx` (`prepaidId`),
  KEY `fk_prepaidPackageProduct_packageProduct1_idx` (`packageProductId`),
  KEY `ppp` (`prepaidId`,`packageProductId`),
  CONSTRAINT `fk_prepaidPackageProduct_packageProduct1` FOREIGN KEY (`packageProductId`) REFERENCES `packageProduct` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_prepaidPackageProduct_prepaid1` FOREIGN KEY (`prepaidId`) REFERENCES `prepaid` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;


CREATE TABLE `product` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) COLLATE utf8_czech_ci NOT NULL,
  `description` text COLLATE utf8_czech_ci NOT NULL,
  `price` decimal(10,0) NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `customerOnly` tinyint(1) NOT NULL,
  `packageId` int(10) unsigned DEFAULT NULL,
  `productId` int(10) unsigned DEFAULT NULL,
  `isCategory` tinyint(1) NOT NULL DEFAULT '0',
  `position` int(10) unsigned NOT NULL,
  `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `code` varchar(50) COLLATE utf8_czech_ci NOT NULL,
  `askPrice` tinyint(1) unsigned NOT NULL,
  `askCount` tinyint(1) unsigned NOT NULL,
  `askCustomName` tinyint(1) unsigned NOT NULL,
  `stockable` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `type` tinyint(2) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fk_product_package1_idx` (`packageId`),
  KEY `fk_product_product1_idx` (`productId`),
  CONSTRAINT `fk_product_package1` FOREIGN KEY (`packageId`) REFERENCES `package` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_product_product1` FOREIGN KEY (`productId`) REFERENCES `product` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

INSERT INTO `product` (`id`, `name`, `description`, `price`, `enabled`, `customerOnly`, `packageId`, `productId`, `isCategory`, `position`, `deleted`, `code`, `askPrice`, `askCount`, `askCustomName`, `stockable`, `type`) VALUES
(1,	'PILOXING',	'',	0,	1,	0,	NULL,	NULL,	1,	2,	0,	'',	0,	0,	0,	0,	1),
(2,	'Jednorázový vstup',	'',	60,	1,	0,	NULL,	1,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(3,	'TAEBO',	'',	0,	1,	0,	NULL,	NULL,	1,	3,	0,	'',	0,	0,	0,	0,	1),
(4,	'Jednorázový vstup',	'',	60,	1,	0,	NULL,	3,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(5,	'FITNESS',	'',	0,	1,	0,	NULL,	NULL,	1,	1,	0,	'',	0,	0,	0,	0,	1),
(6,	'Jednorázový vstup',	'',	50,	1,	0,	NULL,	5,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(7,	'PILOXING',	'',	500,	1,	0,	1,	NULL,	0,	4,	1,	'',	0,	0,	0,	0,	0),
(8,	'TAEBO',	'',	500,	1,	0,	2,	NULL,	0,	5,	1,	'',	0,	0,	0,	0,	0),
(9,	'FITNESS',	'',	500,	1,	0,	3,	NULL,	0,	6,	1,	'',	0,	0,	0,	0,	0),
(10,	'PERMANENTKY',	'',	0,	1,	0,	NULL,	NULL,	1,	6,	0,	'',	0,	0,	0,	0,	1),
(11,	'PILOXING',	'',	500,	1,	0,	1,	10,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(12,	'TAEBO',	'',	500,	1,	0,	2,	10,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(13,	'Fitness',	'',	500,	1,	0,	3,	10,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(14,	'PITÍ',	'',	0,	1,	0,	NULL,	NULL,	1,	4,	0,	'',	0,	0,	0,	0,	1),
(15,	'Káfé',	'',	11,	1,	0,	NULL,	14,	0,	3,	0,	'',	0,	0,	0,	0,	0),
(16,	'SUPLEMENTY',	'',	0,	1,	0,	NULL,	NULL,	1,	5,	0,	'',	0,	0,	0,	0,	1),
(17,	'Iontový nápoj',	'',	10,	1,	0,	NULL,	16,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(18,	'L - Carnitine',	'',	10,	1,	0,	NULL,	16,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(19,	'Čaj',	'',	10,	1,	0,	NULL,	14,	0,	0,	0,	'',	0,	0,	0,	1,	0),
(20,	'Horká čokoláda',	'',	10,	1,	0,	NULL,	14,	0,	0,	0,	'',	0,	0,	0,	1,	0),
(21,	'Scitec Protein',	'',	25,	1,	0,	NULL,	16,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(22,	'BEEF GAINER',	'',	25,	1,	0,	NULL,	16,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(23,	'PROTEIN Extrifit',	'',	15,	1,	0,	NULL,	16,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(24,	'Gainer Mass Up',	'',	10,	1,	0,	NULL,	16,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(25,	'BCAA',	'',	15,	1,	0,	NULL,	16,	0,	0,	0,	'',	0,	1,	0,	0,	0),
(26,	'Tyčinka Nutrend Excelent',	'',	40,	1,	0,	NULL,	16,	0,	0,	0,	'',	0,	0,	0,	1,	0),
(27,	'FITNESS',	'',	500,	1,	0,	3,	NULL,	0,	0,	1,	'',	0,	0,	0,	0,	0),
(28,	'PILOXING',	'',	500,	1,	0,	1,	NULL,	0,	0,	1,	'',	0,	0,	0,	0,	0),
(29,	'E.NOX',	'',	25,	1,	0,	NULL,	16,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(30,	'HOKEJOVÁ AKADEMIE',	'',	0,	1,	0,	NULL,	NULL,	1,	7,	0,	'',	0,	0,	0,	0,	1),
(31,	'Suchý led',	'',	200,	1,	0,	NULL,	30,	0,	0,	0,	'',	0,	0,	0,	1,	0),
(32,	'Kruhový trénink',	'',	0,	1,	0,	NULL,	5,	1,	0,	1,	'',	0,	0,	0,	0,	1),
(33,	'Kruhový trénink',	'',	60,	1,	0,	NULL,	5,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(34,	'Měsíční pernamentka',	'',	500,	1,	0,	NULL,	5,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(35,	'VÝŽIVOVÉ PORADENSTVÍ',	'',	0,	1,	0,	NULL,	NULL,	1,	8,	0,	'',	0,	0,	0,	0,	1),
(36,	'Měření a konzultace',	'',	200,	1,	0,	NULL,	35,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(37,	'Měření a konzultace pro návštěvníky FITNESS',	'',	100,	1,	0,	NULL,	35,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(38,	'Úprava jídelníčku + návrh nového',	'',	100,	1,	0,	NULL,	35,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(39,	'Vstup pro HA',	'',	0,	1,	0,	NULL,	5,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(40,	'Pernamentka',	'',	0,	1,	0,	NULL,	5,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(41,	'Nitrox PUMP',	'',	20,	1,	0,	NULL,	16,	0,	0,	0,	'',	0,	0,	0,	1,	0),
(42,	'BCAA CAPS',	'',	4,	1,	0,	NULL,	16,	0,	0,	0,	'',	0,	0,	0,	1,	0),
(43,	'Protein MATRIX',	'',	25,	1,	0,	NULL,	16,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(44,	'NAPALM',	'',	20,	1,	0,	NULL,	16,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(45,	'Pernamentka akce',	'',	450,	1,	0,	3,	10,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(46,	'OSTATNÍ',	'',	0,	1,	0,	NULL,	NULL,	1,	5,	0,	'',	0,	0,	0,	0,	1),
(47,	'Kšiltovka Hokejová Akademie',	'',	150,	1,	0,	NULL,	46,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(48,	'Práce s trénérem',	'',	50,	1,	0,	NULL,	5,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(49,	'Suchý led',	'',	100,	1,	0,	NULL,	30,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(50,	'C4 EXTREME',	'',	20,	1,	0,	NULL,	16,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(51,	'IONT NUTREND',	'',	12,	1,	0,	NULL,	16,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(52,	'CFM PROM - IN',	'',	25,	1,	0,	NULL,	16,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(53,	'Carnitin EXTRIFIT',	'',	12,	1,	0,	NULL,	16,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(54,	'Dárkový poukaz',	'',	250,	1,	0,	NULL,	5,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(55,	'Dárkový poukaz',	'',	500,	1,	0,	NULL,	5,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(56,	'BCAA MAX',	'',	15,	1,	0,	NULL,	16,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(57,	'FA WHEY PROTEIN',	'',	25,	1,	0,	NULL,	NULL,	0,	0,	1,	'',	0,	0,	0,	0,	0),
(58,	'FA WHEY PROTEIN',	'',	25,	1,	0,	NULL,	16,	0,	0,	0,	'',	0,	0,	0,	1,	0),
(59,	'Kredit',	'',	0,	1,	0,	6,	NULL,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(60,	'dobití kreditu',	'',	0,	0,	0,	NULL,	NULL,	0,	0,	0,	'creditChange',	0,	0,	0,	0,	0),
(61,	'Pivo',	'a rum',	23,	1,	0,	NULL,	16,	0,	11,	1,	'',	0,	1,	0,	0,	0),
(62,	'Vstup na měsíc',	'',	20,	1,	0,	7,	NULL,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(63,	'Obchod bla bla',	'Pivíčko rumík a tak dále',	0,	1,	0,	NULL,	NULL,	0,	0,	0,	'',	0,	0,	0,	0,	2),
(64,	'Chlast',	'',	0,	1,	0,	NULL,	63,	0,	0,	0,	'',	0,	0,	0,	0,	1),
(65,	'Pivo',	'',	20,	1,	0,	NULL,	64,	0,	0,	0,	'',	0,	0,	0,	1,	0),
(66,	'Rum',	'',	30,	1,	0,	NULL,	64,	0,	0,	0,	'',	0,	0,	0,	1,	0),
(67,	'fdgdfgh',	'',	0,	1,	0,	NULL,	NULL,	0,	0,	0,	'',	0,	0,	0,	0,	1),
(68,	'sdfgsdfg',	'',	0,	1,	0,	NULL,	NULL,	0,	0,	0,	'',	0,	0,	0,	0,	2),
(69,	'sdfgsdfg',	'',	5,	1,	0,	NULL,	NULL,	0,	0,	0,	'',	0,	0,	0,	0,	0),
(70,	'Rum 10×',	'',	100,	1,	0,	8,	NULL,	0,	0,	0,	'',	0,	0,	0,	0,	0);

CREATE TABLE `productSell` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `productId` int(10) unsigned NOT NULL,
  `prepaidId` int(10) unsigned DEFAULT NULL,
  `packageProductId` int(10) unsigned DEFAULT NULL,
  `directpaidId` int(10) unsigned DEFAULT NULL,
  `priceDirectpaid` decimal(10,0) DEFAULT NULL,
  `priceCreditRegular` decimal(10,0) DEFAULT NULL,
  `priceCreditBonus` decimal(10,0) DEFAULT NULL,
  `productAmount` decimal(10,0) DEFAULT NULL,
  `utSell` int(10) unsigned NOT NULL,
  `createUserId` int(10) unsigned NOT NULL,
  `cancelUserId` int(10) unsigned DEFAULT NULL,
  `cancelUt` int(10) unsigned DEFAULT NULL,
  `cancelNote` text COLLATE utf8_czech_ci,
  `customName` text COLLATE utf8_czech_ci,
  `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `bonusCredit` decimal(12,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_productSell_product1_idx` (`productId`),
  KEY `fk_productSell_prepaid1_idx` (`prepaidId`),
  KEY `fk_productSell_packageProduct1_idx` (`packageProductId`),
  KEY `fk_productSell_directPaid1_idx` (`directpaidId`),
  KEY `createUserId` (`createUserId`),
  KEY `cancelUserId` (`cancelUserId`),
  CONSTRAINT `fk_productSell_prepaid1` FOREIGN KEY (`prepaidId`) REFERENCES `prepaid` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `productSell_ibfk_1` FOREIGN KEY (`packageProductId`) REFERENCES `packageProduct` (`id`),
  CONSTRAINT `productSell_ibfk_2` FOREIGN KEY (`productId`) REFERENCES `product` (`id`),
  CONSTRAINT `productSell_ibfk_3` FOREIGN KEY (`directpaidId`) REFERENCES `directpaid` (`id`),
  CONSTRAINT `productSell_ibfk_4` FOREIGN KEY (`createUserId`) REFERENCES `user` (`id`),
  CONSTRAINT `productSell_ibfk_5` FOREIGN KEY (`cancelUserId`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;


CREATE TABLE `productSellNote` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `productSellId` int(10) unsigned NOT NULL,
  `note` text COLLATE utf8_czech_ci NOT NULL,
  `utAdd` int(10) unsigned NOT NULL,
  `userId` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `productSellId` (`productSellId`),
  KEY `userId` (`userId`),
  KEY `utAdd` (`utAdd`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;


CREATE TABLE `role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
  `pages` text COLLATE utf8_czech_ci NOT NULL,
  `perms` text COLLATE utf8_czech_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

INSERT INTO `role` (`id`, `name`, `pages`, `perms`) VALUES
(1,	'Administrátor',	'Admin:*;Cashbox:*;Stock:*',	''),
(2,	'Obsluha',	'Cashbox:*;Admin:customer',	'');

CREATE TABLE `stockChange` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `currentAmount` decimal(10,0) NOT NULL,
  `changeAmount` decimal(10,0) NOT NULL,
  `productId` int(10) unsigned NOT NULL,
  `productSellId` int(10) unsigned DEFAULT NULL,
  `stockFillId` int(11) DEFAULT NULL,
  `utChange` int(10) unsigned NOT NULL,
  `isActual` tinyint(1) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `productSellId` (`productSellId`),
  KEY `productId` (`productId`),
  KEY `stockFillId` (`stockFillId`),
  CONSTRAINT `stockChange_ibfk_1` FOREIGN KEY (`productSellId`) REFERENCES `productSell` (`id`),
  CONSTRAINT `stockChange_ibfk_2` FOREIGN KEY (`productId`) REFERENCES `product` (`id`),
  CONSTRAINT `stockChange_ibfk_3` FOREIGN KEY (`stockFillId`) REFERENCES `stockFill` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `stockFill` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `utFill` int(10) unsigned NOT NULL,
  `note` text NOT NULL,
  `userId` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `userId` (`userId`),
  CONSTRAINT `stockFill_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
