CREATE TABLE `namedays` (
  `day` varchar(5) collate utf8_czech_ci NOT NULL,
  `name` varchar(40) collate utf8_czech_ci NOT NULL,
  PRIMARY KEY  (`name`,`day`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

INSERT INTO `namedays` (`day`, `name`) VALUES
('24.12', 'Adam'),
('02.09', 'Adéla'),
('17.06', 'Adolf'),
('26.06', 'Adriana'),
('14.10', 'Agáta'),
('14.08', 'Alan'),
('21.11', 'Albert'),
('16.12', 'Albína'),
('13.08', 'Alena'),
('13.04', 'Aleš'),
('27.02', 'Alexandr'),
('21.04', 'Alexandra'),
('03.05', 'Alexej'),
('15.01', 'Alice'),
('21.06', 'Alois'),
('19.11', 'Alžběta'),
('10.07', 'Amálie'),
('07.12', 'Ambrož'),
('15.04', 'Anastázie'),
('11.03', 'Anděla'),
('26.09', 'Andrea'),
('11.10', 'Andrej'),
('17.05', 'Aneta'),
('02.03', 'Anežka'),
('26.07', 'Anna'),
('12.06', 'Antonie'),
('13.06', 'Antonín'),
('09.02', 'Apolena'),
('30.03', 'Arnošt'),
('26.11', 'Artur'),
('28.08', 'Augustýn'),
('04.12', 'Barbora'),
('24.08', 'Bartoloměj'),
('25.10', 'Beáta'),
('01.03', 'Bedřich'),
('21.01', 'Běla'),
('12.11', 'Benedikt'),
('07.12', 'Benjamín'),
('20.08', 'Bernard'),
('23.09', 'Berta'),
('30.04', 'Blahoslav'),
('02.12', 'Blanka'),
('03.02', 'Blažej'),
('10.05', 'Blažena'),
('09.11', 'Bohdan'),
('11.01', 'Bohdana'),
('03.10', 'Bohumil'),
('28.12', 'Bohumila'),
('08.11', 'Bohumír'),
('22.08', 'Bohuslav'),
('07.07', 'Bohuslava'),
('06.09', 'Boleslav'),
('14.05', 'Bonifác'),
('05.09', 'Boris'),
('12.07', 'Bořek'),
('30.07', 'Bořivoj'),
('11.02', 'Božena'),
('21.10', 'Brigita'),
('03.09', 'Bronislav'),
('11.06', 'Bruno'),
('10.01', 'Břetislav'),
('22.11', 'Cecílie'),
('09.05', 'Ctibor'),
('16.01', 'Ctirad'),
('05.07', 'Cyril'),
('19.07', 'Čeněk'),
('08.01', 'Čestmír'),
('20.12', 'Dagmar'),
('04.06', 'Dalibor'),
('05.01', 'Dalimil'),
('11.12', 'Dana'),
('17.12', 'Daniel'),
('09.09', 'Daniela'),
('22.09', 'Darina'),
('10.04', 'Darja'),
('30.12', 'David'),
('11.09', 'Denisa'),
('04.01', 'Diana'),
('27.03', 'Dita'),
('05.02', 'Dobromila'),
('05.06', 'Dobroslav'),
('04.08', 'Dominik'),
('26.02', 'Dorota'),
('19.01', 'Doubravka'),
('18.07', 'Drahomíra'),
('17.01', 'Drahoslav'),
('09.07', 'Drahoslava'),
('09.04', 'Dušan'),
('13.01', 'Edita'),
('18.03', 'Eduard'),
('16.03', 'Elena'),
('05.10', 'Eliška'),
('08.04', 'Ema'),
('26.03', 'Emanuel'),
('22.05', 'Emil'),
('24.11', 'Emílie'),
('26.10', 'Erik'),
('02.04', 'Erika'),
('19.12', 'Ester'),
('24.12', 'Eva'),
('29.08', 'Evelína'),
('10.11', 'Evžen'),
('22.04', 'Evžénie'),
('01.11', 'Felix'),
('30.05', 'Ferdinand'),
('26.05', 'Filip'),
('04.10', 'František'),
('09.03', 'Františka'),
('24.03', 'Gabriel'),
('08.03', 'Gabriela'),
('10.06', 'Gita'),
('18.02', 'Gizela'),
('02.08', 'Gustav'),
('15.08', 'Hana'),
('06.10', 'Hanuš'),
('16.10', 'Havel'),
('17.10', 'Hedvika'),
('18.08', 'Helena'),
('16.03', 'Herbert'),
('07.04', 'Hermína'),
('07.04', 'Heřman'),
('29.02', 'Horymír'),
('03.11', 'Hubert'),
('01.04', 'Hugo'),
('01.02', 'Hynek'),
('15.03', 'Ida'),
('31.07', 'Ignác'),
('01.10', 'Igor'),
('20.07', 'Ilja'),
('20.01', 'Ilona'),
('27.01', 'Ingrid'),
('16.04', 'Irena'),
('10.09', 'Irma'),
('01.12', 'Iva'),
('25.06', 'Ivan'),
('04.04', 'Ivana'),
('07.06', 'Iveta'),
('19.05', 'Ivo'),
('23.03', 'Ivona'),
('11.04', 'Izabela'),
('16.08', 'Jáchym'),
('25.07', 'Jakub'),
('24.06', 'Jan'),
('24.05', 'Jana'),
('02.06', 'Jarmil'),
('04.02', 'Jarmila'),
('24.09', 'Jaromír'),
('27.04', 'Jaroslav'),
('01.07', 'Jaroslava'),
('30.09', 'Jeroným'),
('15.07', 'Jindřich'),
('04.09', 'Jindřiška'),
('24.04', 'Jiří'),
('15.02', 'Jiřina'),
('05.12', 'Jitka'),
('21.08', 'Johana'),
('15.09', 'Jolana'),
('27.09', 'Jonáš'),
('19.03', 'Josef'),
('29.12', 'Judita'),
('10.12', 'Julie'),
('12.04', 'Julius'),
('07.10', 'Justýna'),
('03.03', 'Kamil'),
('31.05', 'Kamila'),
('04.11', 'Karel'),
('02.01', 'Karina'),
('14.07', 'Karolína'),
('25.11', 'Kateřina'),
('05.03', 'Kazimír'),
('12.08', 'Klára'),
('05.05', 'Klaudie'),
('23.11', 'Klement'),
('05.08', 'Kristián'),
('24.07', 'Kristýna'),
('18.09', 'Kryštof'),
('20.06', 'Květa'),
('04.05', 'Květoslav'),
('08.12', 'Květoslava'),
('31.03', 'Kvido'),
('07.08', 'Lada'),
('27.06', 'Ladislav'),
('01.06', 'Laura'),
('21.02', 'Lenka'),
('22.03', 'Leona'),
('15.11', 'Leopold'),
('19.06', 'Leoš'),
('06.11', 'Liběna'),
('23.07', 'Libor'),
('10.07', 'Libuše'),
('25.02', 'Liliana'),
('01.09', 'Linda'),
('16.02', 'Ljuba'),
('28.06', 'Lubomír'),
('13.09', 'Lubor'),
('16.07', 'Luboš'),
('13.12', 'Lucie'),
('26.08', 'Luděk'),
('16.09', 'Ludmila'),
('19.08', 'Ludvík'),
('18.10', 'Lukáš'),
('28.02', 'Lumír'),
('14.12', 'Lýdie'),
('22.07', 'Magdaléna'),
('17.11', 'Mahulena'),
('12.10', 'Marcel'),
('20.04', 'Marcela'),
('25.04', 'Marek'),
('25.03', 'Marián'),
('08.09', 'Mariana'),
('12.09', 'Marie'),
('31.01', 'Marika'),
('10.10', 'Marina'),
('13.07', 'Markéta'),
('29.07', 'Marta'),
('11.11', 'Martin'),
('17.07', 'Martina'),
('24.02', 'Matěj'),
('21.09', 'Matouš'),
('14.03', 'Matylda'),
('29.05', 'Maxim'),
('29.05', 'Maxmilián'),
('08.06', 'Medard'),
('05.07', 'Metoděj'),
('19.10', 'Michaela'),
('29.09', 'Michal'),
('06.12', 'Mikuláš'),
('08.02', 'Milada'),
('18.06', 'Milan'),
('24.01', 'Milena'),
('18.12', 'Miloslav'),
('17.02', 'Miloslava'),
('25.01', 'Miloš'),
('03.08', 'Miluše'),
('05.11', 'Miriam'),
('06.03', 'Miroslav'),
('05.04', 'Miroslava'),
('10.02', 'Mojmír'),
('21.05', 'Monika'),
('17.09', 'Naděžda'),
('21.12', 'Natálie'),
('18.05', 'Nataša'),
('02.02', 'Nela'),
('20.11', 'Nikola'),
('24.10', 'Nina'),
('08.07', 'Nora'),
('06.06', 'Norbert'),
('20.02', 'Oldřich'),
('06.08', 'Oldřiška'),
('20.09', 'Oleg'),
('11.07', 'Olga'),
('02.10', 'Oliver'),
('02.10', 'Olívie'),
('30.11', 'Ondřej'),
('01.08', 'Oskar'),
('27.08', 'Otakar'),
('16.11', 'Otmar'),
('26.04', 'Oto'),
('28.01', 'Otýlie'),
('12.05', 'Pankrác'),
('02.07', 'Patricie'),
('19.02', 'Patrik'),
('29.06', 'Pavel'),
('22.06', 'Pavla'),
('31.08', 'Pavlína'),
('22.02', 'Petr'),
('29.06', 'Petr'),
('17.08', 'Petra'),
('12.01', 'Pravoslav'),
('04.07', 'Prokop'),
('16.05', 'Přemysl'),
('15.12', 'Radan'),
('15.12', 'Radana'),
('21.03', 'Radek'),
('25.08', 'Radim'),
('14.09', 'Radka'),
('03.01', 'Radmila'),
('03.07', 'Radomír'),
('06.05', 'Radoslav'),
('14.01', 'Radovan'),
('07.09', 'Regína'),
('13.10', 'Renáta'),
('28.11', 'René'),
('03.04', 'Richard'),
('29.04', 'Robert'),
('30.01', 'Robin'),
('14.06', 'Roland'),
('09.08', 'Roman'),
('18.11', 'Romana'),
('19.04', 'Rostislav'),
('17.04', 'Rudolf'),
('14.03', 'Rút'),
('13.03', 'Růžena'),
('12.03', 'Řehoř'),
('22.10', 'Sabina'),
('01.09', 'Samuel'),
('23.08', 'Sandra'),
('09.10', 'Sára'),
('07.11', 'Saskie'),
('14.11', 'Sáva'),
('13.05', 'Servác'),
('31.12', 'Silvestr'),
('29.10', 'Silvie'),
('12.12', 'Simona'),
('12.02', 'Slavěna'),
('07.06', 'Slavoj'),
('22.01', 'Slavomír'),
('08.08', 'Soběslav'),
('28.03', 'Soňa'),
('07.05', 'Stanislav'),
('09.06', 'Stanislava'),
('04.03', 'Stela'),
('11.05', 'Svatava'),
('23.02', 'Svatopluk'),
('03.12', 'Svatoslav'),
('20.03', 'Světlana'),
('30.06', 'Šárka'),
('27.10', 'Šarlota'),
('22.12', 'Šimon'),
('09.10', 'Štefan'),
('26.12', 'Štěpán'),
('31.10', 'Štěpánka'),
('30.10', 'Tadeáš'),
('03.06', 'Tamara'),
('29.03', 'Taťána'),
('23.10', 'Teodor'),
('15.10', 'Tereza'),
('13.11', 'Tibor'),
('07.03', 'Tomáš'),
('28.09', 'Václav'),
('27.05', 'Valdemar'),
('14.02', 'Valentýn'),
('18.04', 'Valérie'),
('06.02', 'Vanda'),
('10.08', 'Vavřinec'),
('13.02', 'Věnceslav'),
('20.10', 'Vendelín'),
('06.04', 'Vendula'),
('08.10', 'Věra'),
('07.02', 'Veronika'),
('27.07', 'Věroslav'),
('28.07', 'Viktor'),
('10.03', 'Viktorie'),
('28.05', 'Vilém'),
('07.01', 'Vilma'),
('14.04', 'Vincenc'),
('25.05', 'Viola'),
('15.06', 'Vít'),
('21.07', 'Vítězslav'),
('09.01', 'Vladan'),
('30.08', 'Vladěna'),
('23.05', 'Vladimír'),
('18.01', 'Vladislav'),
('23.12', 'Vlasta'),
('17.03', 'Vlastimil'),
('28.04', 'Vlastislav'),
('23.04', 'Vojtěch'),
('09.12', 'Vratislav'),
('27.11', 'Xenie'),
('16.06', 'Zbyněk'),
('20.05', 'Zbyšek'),
('23.01', 'Zdeněk'),
('23.06', 'Zdeňka'),
('29.01', 'Zdislava'),
('02.05', 'Zikmund'),
('29.11', 'Zina'),
('19.09', 'Zita'),
('25.09', 'Zlata'),
('27.10', 'Zoe'),
('26.01', 'Zora'),
('11.08', 'Zuzana'),
('27.12', 'Žaneta'),
('15.05', 'Žofie');