-- phpMyAdmin SQL Dump
-- version 2.10.0.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jun 14, 2007 at 05:42 PM
-- Server version: 5.0.42
-- PHP Version: 5.2.2-pl1-gentoo

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `probatur`
-- 

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

-- 
-- Table structure for table `tAdmins`
-- 

CREATE TABLE `tAdmins` (
  `id` bigint(20) unsigned NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci;

-- 
-- Dumping data for table `tAdmins`
-- 

INSERT INTO `tAdmins` VALUES (1);

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

-- 
-- Table structure for table `tAnswer`
-- 

CREATE TABLE `tAnswer` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `id_answerSet` bigint(20) unsigned NOT NULL,
  `text` text collate utf8_slovak_ci NOT NULL,
  `correct` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci AUTO_INCREMENT=14 ;

-- 
-- Dumping data for table `tAnswer`
-- 

INSERT INTO `tAnswer` VALUES (1, 1, 'ALU', 1);
INSERT INTO `tAnswer` VALUES (2, 1, 'CLU', 1);
INSERT INTO `tAnswer` VALUES (3, 1, 'Registre', 1);
INSERT INTO `tAnswer` VALUES (4, 1, 'CLM', 0);
INSERT INTO `tAnswer` VALUES (5, 2, 'CPU', 1);
INSERT INTO `tAnswer` VALUES (6, 2, 'Zbernice', 1);
INSERT INTO `tAnswer` VALUES (7, 2, 'Pamat', 1);
INSERT INTO `tAnswer` VALUES (8, 2, 'Pouzivatel', 0);
INSERT INTO `tAnswer` VALUES (9, 2, 'Monitor', 0);
INSERT INTO `tAnswer` VALUES (10, 2, 'Klavesnica', 0);
INSERT INTO `tAnswer` VALUES (11, 3, '1 milka', 1);
INSERT INTO `tAnswer` VALUES (12, 3, '10000', 1);
INSERT INTO `tAnswer` VALUES (13, 3, 'dovolenka pri mori', 0);

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

-- 
-- Table structure for table `tAnswerSet`
-- 

CREATE TABLE `tAnswerSet` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `id_question` bigint(20) unsigned NOT NULL,
  `difficulty` float NOT NULL,
  `obsolete` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `tAnswerSet`
-- 

INSERT INTO `tAnswerSet` VALUES (1, 1, 0, 0);
INSERT INTO `tAnswerSet` VALUES (2, 2, 0, 0);
INSERT INTO `tAnswerSet` VALUES (3, 3, 0, 0);

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

-- 
-- Table structure for table `tCourse`
-- 

CREATE TABLE `tCourse` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `id_scale` bigint(20) unsigned NOT NULL,
  `id_demoTest` bigint(20) unsigned NOT NULL,
  `name` varchar(128) collate utf8_slovak_ci NOT NULL,
  `code` varchar(15) collate utf8_slovak_ci NOT NULL,
  `description` text collate utf8_slovak_ci NOT NULL,
  `questionCount` smallint(5) unsigned NOT NULL,
  `duration` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci AUTO_INCREMENT=19 ;

-- 
-- Dumping data for table `tCourse`
-- 

INSERT INTO `tCourse` VALUES (1, 0, 0, 'Matematická analýza (1)', '1-INF-110', 'Stručný historický prehľad. Limita funkcie apostupnosti a základné vety o limitách. Cauchyho-Bolyanovo kritérium aexistencia konvergentných podpostupností. Spojitosť funkcie v bode a namnožine, vlastnosti spojitých funkcií na intervaloch a na kompaktnýchmnožinách. Derivácia funkcie, základné vety o výpočte derivácií, deriváciainverznej a zloženej funkcie. Vety o strednej hodnote diferenciálneho počtu,vyšetrovanie priebehu funkcií. L´Hospitalovo pravidlo. Taylorove polynómy.', 0, 0);
INSERT INTO `tCourse` VALUES (2, 0, 0, 'Algebra (1)', '1-INF-115', 'Základné pojmy potrebné k abstraktnémuvybudovaniu vektorových priestorov (grupy, polia, vektorové priestory).Podpriestory, lineárna závislosť a nezávislosť vektorov, Steinitzova veta, bázavektorového priestoru. Matice. Lineárne zobrazenia. Kompozícia lineárnychzobrazení, inverzné matice. Riešenia homogénnych a nehomogénnych systémovlineárnych rovníc. Determinanty, základné vlastnosti a aplikácie.', 0, 0);
INSERT INTO `tCourse` VALUES (3, 0, 0, 'Úvod do diskrétnych štruktúr', '1-INF-120', 'Výroková logika. Kvantifikované výroky. Matematickédôkazy. Matematická indukcia. Intuitívna teória množín a jej paradoxy.Základné množinové vzťahy a operácie s množinami. Mohutnosti množín.Konečné, nekonečné, spočítateľné a nespočítateľné množiny. Pravidlo súčtua súčinu, Spernerova veta, Dirichletov princíp a jeho zovšeobecnenia.Booleovské funkcie.', 0, 0);
INSERT INTO `tCourse` VALUES (4, 0, 0, 'Programovanie (1)', '1-INF-125', 'Vizuálne prostredie Delphi, práca s grafikou;programové a dátové štruktúry jazyka, podprogramy, programové jednotky,rekurzia; práca s textom, súbory, lexikálna analýza; definovanie objektov,dedičnosť, polymorfizmus; základy programovania pod systémom windows.', 0, 0);
INSERT INTO `tCourse` VALUES (5, 0, 0, 'Princípy počítačov', '1-INF-130', 'Pozičné číselné sústavy, kódovanie informácie vpočítači, aritmetika v pevnej a pohyblivej rádovej čiarke, Booleovské funkcie aoperátory, DNF, minimalizácia DNF, realizácia základných Booleovských funkciíelektrickými obvodmi. Kombinačné obvody. Priestorová a časová zložitosť obvodov.Sekvenčné obvody. Jazyk RTL, riadiace jednotky, návrh digitálnych systémov,násobenie a delenie celých čísel, architektúra a princíp činnosti vonNeumanovského počítača. Aritmeticko-logická jednotka, inštrukcie, formátinštrukcií, spôsoby adresovania, inštrukčný súbor. Pamäť: asociatívna pamäť,virtuálna pamäť (stránkovanie a segmentovanie), cache, zásobníková pamäť.Vstupno-výstupné zariadenia, riadenie vstupu a výstupu. Procesor: riadiaci aaritmetický procesor, registre, spracovanie prerušení, mikroprogramovanie.RISC-CISC, pipelening, paralelné spracovanie údajov. Architektúry vybranýchprocesorov.', 0, 0);
INSERT INTO `tCourse` VALUES (6, 0, 0, 'Matematická analýza (2)', '1-INF-150', 'Primitívna funkcia a neurčitý integrál, základnémetódy výpočtu, integrovanie racionálnych funkcií a trigonometrickésubstitúcie. Určitý Riemannov integrál funkcií jednej premennej, kritériáR-integrovateľnosti, Newtonov-Leibnizov vzorec, niektoré aplikácie. Číselnérady a kritériá ich konvergencie. Prerovnanie relatívne a absolútnekonvergentných radov, Cachyho súčin radov. Rovnomerná konvergenciafunkcionálnych radov a ich derivovanie a integrovanie člen po člene. Mocninovéa Taylorove rady, polomer a interval konvergencie. Niektoré výpočty pomocouradov.', 0, 0);
INSERT INTO `tCourse` VALUES (7, 0, 0, 'Algebra (2)', '1-INF-155', 'Skalárny súčin, ortonormálna báza a ortogonálnaprojekcia na podpriestor. Kvadratické formy a ich kanonické tvary. Pozitívna(semi)definitnosť matice a kvadratickej formy a kritériá na overenie pozitívnejdefinitnosti. Zmena bázy, podobné matice. Podobnosť matice s diagonálnoumaticou. Vlastné čísla a vlastné vektory, charakteristický polynóm. Ortogonálnematice, ortogonálna podobnosť, Schurova veta a veta o hlavných osiach. Základyteórie grúp – podgrupy, cyklické grupy, grupy permutácií, rozklad grupy podľapodgrupy, faktorizácia, základné vety o izomorfizmoch a homomorfizmoch.', 0, 0);
INSERT INTO `tCourse` VALUES (8, 0, 0, 'Úvod do kombinatoriky a teórie grafov', '1-INF-160', 'Kombinatorika: základné typy kombinatorických úloha základné pojmy. Permutácie, variácie, kombinácie. Pascalova formula,binomická a plynomická veta, Newtonova polynomická veta. Kombinatorickéidentity, odhady kombinatorických čísel. Princíp zapojenia - vypojenia.Rekurentné vzťahy, generujúce funkcie, metódy sumácie, konečný kalkulus. Teóriagrafov: Motivačné úlohy. Definície rôznych typov grafov. Základné pojmy.Stromy. Prehľadávanie grafov. Eulerovské ťahy, Hamiltonovské kružnice. Farbeniagrafov. Planárne grafy. Enumerácia stromov. Algoritmy na nájdenie najkratšejcesty, najlacnejšej kostry, najpočetnejšieho párenia.', 0, 0);
INSERT INTO `tCourse` VALUES (9, 0, 0, 'Programovanie (2)', '1-INF-165', 'Dynamické premenné; dynamické dátové typy: zoznam,strom, graf; algoritmy práce s dynamickými dátovými typmi; základné algoritmytriedenia; ďalšie komponenty jazyka pre prácu pod systémom windows.', 0, 0);
INSERT INTO `tCourse` VALUES (10, 0, 0, 'Spoločenské aspekty informatiky', '1-INF-175', 'Nové IKT technológie sa rozvíjajú veľmi rýchlo.Nebadane ale vytrvalo vstupujú do nášho každodenného života. Všímame si akézmeny, čo pozitívne, ale aj aké riziká IKT prinášajú v rôznych oblastiach:vzdelávanie, zdravotníctvo, umenie, obchod a financie, priemysel a ďalšie.Osobitne si všimneme problematiku autorského práva a jeho porušovania apočítačovej kriminality.', 0, 0);
INSERT INTO `tCourse` VALUES (11, 0, 0, 'Úvod do matematickej logiky', '1-INF-210', 'Jazyk, sémantika a syntax  výrokovej logiky. Vetao kompaktnosti. Axiómy a pravidlá odvodenia. Veta o dedukcii.Základné teorémy výrokovej logiky. Postove vety. Bezospornosť a úplnosťvýrokovej logiky. Jazyk, axiómy a pravidlá odvodenia predikátovej logiky.Veta o dedukcii. Základné teorémy predikátovej logiky. Bezospornosť aúplnosť  predikátovej logiky. Axiómy rovnosti a príklady teóriís rovnosťou. Zapisovanie matematických tvrdení pomocou formúl predikátového počtu.', 0, 0);
INSERT INTO `tCourse` VALUES (12, 0, 0, 'Formálne jazyky a automaty (1)', '1-INF-215', 'Gramatiky Chomského hierarchie. Konečné automaty azásobníkové automaty. Základné vlastnosti regulárnych a bezkontextovýchjazykov, regulárne výrazy. Turingove stroje. Nerozhodnuteľné problémy. Úvod doteórie zložitosti.', 0, 0);
INSERT INTO `tCourse` VALUES (13, 0, 0, 'Algoritmy a dátové štruktúry', '1-INF-220', 'Úvod do problematiky. Matematické základy: symbolika,kombinatorické identity. Analýza triedenia: heapsort, quicksort; triedenie vlineárnom čase. Dátové štruktúry: elementárne, hašovacie tabuľky, binárneprehľadávacie stromy, červeno-čierne a vyvážené stromy. Návrhové a analyzačnétechniky: dynamické programovanie , greedy algoritmy.', 0, 0);
INSERT INTO `tCourse` VALUES (14, 0, 0, 'Programovanie (3)', '1-INF-225', 'Preťaženie funkcií a operátorov, šablóny, standardtemplate library (STL), rozhrania (interfaces), vlákna a ich súbežnosť,AWT, Swing, Java a Internet, design patterns, refactoring.', 0, 0);
INSERT INTO `tCourse` VALUES (15, 0, 0, 'Úvod do databázových systémov', '1-INF-230', 'Dátové modely, architektúra DBMS a modelovaniereality; Relačný model, relačné dotazové jazyky, SQL, teória navrhovaniarelačných báz dát (funkčné závislosti, kľúče a normálne formy), logické adeduktívne databázy, datalóg, negácia v databázach; Transakcie aspracovanie transakcií; Dátové štruktúry pre dvojúrovňovú pamäť, kompresiadát;  Navigačné modely (sieťový model).', 0, 0);
INSERT INTO `tCourse` VALUES (16, 0, 0, 'Počítačové siete', '1-INF-260', 'Prednáška sa venuje telekomunikačným sieťam a službám,ich vývoju s dôrazom na integračné trendy v dátovej komunikácii, princípomprepínania a komunikačných protokolov, problematike sieťových architektúr avšeobecným aspektom koncových zariadení. Ďalej sa pojednáva o dátovýchprenosoch, o problematike synchronizácie, štandardoch a doporučeniach ivýkonovej analýze. Prakticky orientované časti charakterizujú rôzne typykabeláže, sieťové komponenty a techniky prepojovania sietí.', 0, 0);
INSERT INTO `tCourse` VALUES (17, 1, 2, 'Operačné systémy', '1-INF-170', 'Systémové programy – význam, typy. Assembler,makroprocesor, linker, loader. Operačný systém – história, štruktúra, základnépojmy. Správa procesov a procesora. Správa operačnej pamäte. Správa súborov.Správa periférií.', 2, 60);
INSERT INTO `tCourse` VALUES (18, 0, 0, 'Tvorba efektívnych algoritmov', '1-INF-310', 'Problém slovníka (2-3 stromy). Union/Find-Set problém.Algoritmy pre hľadanie najkratších ciest a najlacnejšej kostry grafu. Princípytvorby efektívnych algoritmov (vrátane konkrétnych aplikácií). Rozdeľuj apanuj. Dynamické programovanie. "Greedy" algoritmy, vyváženosť avoľba vhodnej dátovej štruktúry. Triedy P a NP, polynomiálna redukovateľnosť,[Cookova veta] a NP-úplné problémy, string matching, pravdepodobnostnéalgoritmy, výpočtová geometria.', 0, 0);

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

-- 
-- Table structure for table `tCourseToDomain`
-- 

CREATE TABLE `tCourseToDomain` (
  `id_course` bigint(20) unsigned NOT NULL,
  `id_domain` bigint(20) unsigned NOT NULL,
  `min` smallint(5) unsigned NOT NULL,
  `max` smallint(5) unsigned NOT NULL,
  `is_NULL` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id_course`,`id_domain`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci;

-- 
-- Dumping data for table `tCourseToDomain`
-- 

INSERT INTO `tCourseToDomain` VALUES (17, 1, 0, 1, 0);
INSERT INTO `tCourseToDomain` VALUES (17, 2, 1, 2, 0);
INSERT INTO `tCourseToDomain` VALUES (17, 3, 0, 1, 0);

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

-- 
-- Table structure for table `tCourseToUser`
-- 

CREATE TABLE `tCourseToUser` (
  `id_course` bigint(20) unsigned NOT NULL,
  `id_user` bigint(20) unsigned NOT NULL,
  PRIMARY KEY  (`id_course`,`id_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci;

-- 
-- Dumping data for table `tCourseToUser`
-- 

INSERT INTO `tCourseToUser` VALUES (1, 230);
INSERT INTO `tCourseToUser` VALUES (1, 253);
INSERT INTO `tCourseToUser` VALUES (1, 427);
INSERT INTO `tCourseToUser` VALUES (2, 229);
INSERT INTO `tCourseToUser` VALUES (2, 249);
INSERT INTO `tCourseToUser` VALUES (2, 250);
INSERT INTO `tCourseToUser` VALUES (2, 252);
INSERT INTO `tCourseToUser` VALUES (2, 257);
INSERT INTO `tCourseToUser` VALUES (2, 265);
INSERT INTO `tCourseToUser` VALUES (2, 426);
INSERT INTO `tCourseToUser` VALUES (3, 231);
INSERT INTO `tCourseToUser` VALUES (3, 245);
INSERT INTO `tCourseToUser` VALUES (3, 249);
INSERT INTO `tCourseToUser` VALUES (3, 259);
INSERT INTO `tCourseToUser` VALUES (3, 267);
INSERT INTO `tCourseToUser` VALUES (3, 428);
INSERT INTO `tCourseToUser` VALUES (4, 232);
INSERT INTO `tCourseToUser` VALUES (4, 244);
INSERT INTO `tCourseToUser` VALUES (4, 250);
INSERT INTO `tCourseToUser` VALUES (4, 251);
INSERT INTO `tCourseToUser` VALUES (4, 256);
INSERT INTO `tCourseToUser` VALUES (4, 262);
INSERT INTO `tCourseToUser` VALUES (4, 429);
INSERT INTO `tCourseToUser` VALUES (5, 233);
INSERT INTO `tCourseToUser` VALUES (5, 246);
INSERT INTO `tCourseToUser` VALUES (5, 254);
INSERT INTO `tCourseToUser` VALUES (5, 258);
INSERT INTO `tCourseToUser` VALUES (5, 260);
INSERT INTO `tCourseToUser` VALUES (5, 267);
INSERT INTO `tCourseToUser` VALUES (5, 271);
INSERT INTO `tCourseToUser` VALUES (5, 430);
INSERT INTO `tCourseToUser` VALUES (6, 230);
INSERT INTO `tCourseToUser` VALUES (6, 244);
INSERT INTO `tCourseToUser` VALUES (6, 254);
INSERT INTO `tCourseToUser` VALUES (6, 263);
INSERT INTO `tCourseToUser` VALUES (6, 268);
INSERT INTO `tCourseToUser` VALUES (6, 271);
INSERT INTO `tCourseToUser` VALUES (6, 427);
INSERT INTO `tCourseToUser` VALUES (7, 229);
INSERT INTO `tCourseToUser` VALUES (7, 247);
INSERT INTO `tCourseToUser` VALUES (7, 256);
INSERT INTO `tCourseToUser` VALUES (7, 265);
INSERT INTO `tCourseToUser` VALUES (7, 266);
INSERT INTO `tCourseToUser` VALUES (7, 426);
INSERT INTO `tCourseToUser` VALUES (8, 234);
INSERT INTO `tCourseToUser` VALUES (8, 258);
INSERT INTO `tCourseToUser` VALUES (8, 261);
INSERT INTO `tCourseToUser` VALUES (8, 270);
INSERT INTO `tCourseToUser` VALUES (8, 271);
INSERT INTO `tCourseToUser` VALUES (8, 272);
INSERT INTO `tCourseToUser` VALUES (8, 431);
INSERT INTO `tCourseToUser` VALUES (9, 232);
INSERT INTO `tCourseToUser` VALUES (9, 244);
INSERT INTO `tCourseToUser` VALUES (9, 247);
INSERT INTO `tCourseToUser` VALUES (9, 251);
INSERT INTO `tCourseToUser` VALUES (9, 263);
INSERT INTO `tCourseToUser` VALUES (9, 266);
INSERT INTO `tCourseToUser` VALUES (9, 270);
INSERT INTO `tCourseToUser` VALUES (9, 272);
INSERT INTO `tCourseToUser` VALUES (9, 429);
INSERT INTO `tCourseToUser` VALUES (10, 235);
INSERT INTO `tCourseToUser` VALUES (10, 243);
INSERT INTO `tCourseToUser` VALUES (10, 250);
INSERT INTO `tCourseToUser` VALUES (10, 251);
INSERT INTO `tCourseToUser` VALUES (10, 256);
INSERT INTO `tCourseToUser` VALUES (10, 259);
INSERT INTO `tCourseToUser` VALUES (10, 272);
INSERT INTO `tCourseToUser` VALUES (10, 432);
INSERT INTO `tCourseToUser` VALUES (11, 231);
INSERT INTO `tCourseToUser` VALUES (11, 242);
INSERT INTO `tCourseToUser` VALUES (11, 245);
INSERT INTO `tCourseToUser` VALUES (11, 428);
INSERT INTO `tCourseToUser` VALUES (12, 236);
INSERT INTO `tCourseToUser` VALUES (12, 248);
INSERT INTO `tCourseToUser` VALUES (12, 260);
INSERT INTO `tCourseToUser` VALUES (12, 272);
INSERT INTO `tCourseToUser` VALUES (12, 433);
INSERT INTO `tCourseToUser` VALUES (13, 237);
INSERT INTO `tCourseToUser` VALUES (13, 242);
INSERT INTO `tCourseToUser` VALUES (13, 245);
INSERT INTO `tCourseToUser` VALUES (13, 248);
INSERT INTO `tCourseToUser` VALUES (13, 263);
INSERT INTO `tCourseToUser` VALUES (13, 264);
INSERT INTO `tCourseToUser` VALUES (13, 434);
INSERT INTO `tCourseToUser` VALUES (14, 238);
INSERT INTO `tCourseToUser` VALUES (14, 243);
INSERT INTO `tCourseToUser` VALUES (14, 245);
INSERT INTO `tCourseToUser` VALUES (14, 250);
INSERT INTO `tCourseToUser` VALUES (14, 256);
INSERT INTO `tCourseToUser` VALUES (14, 261);
INSERT INTO `tCourseToUser` VALUES (14, 264);
INSERT INTO `tCourseToUser` VALUES (14, 265);
INSERT INTO `tCourseToUser` VALUES (14, 435);
INSERT INTO `tCourseToUser` VALUES (14, 576);
INSERT INTO `tCourseToUser` VALUES (14, 577);
INSERT INTO `tCourseToUser` VALUES (14, 578);
INSERT INTO `tCourseToUser` VALUES (14, 579);
INSERT INTO `tCourseToUser` VALUES (14, 580);
INSERT INTO `tCourseToUser` VALUES (14, 581);
INSERT INTO `tCourseToUser` VALUES (14, 582);
INSERT INTO `tCourseToUser` VALUES (15, 239);
INSERT INTO `tCourseToUser` VALUES (15, 245);
INSERT INTO `tCourseToUser` VALUES (15, 251);
INSERT INTO `tCourseToUser` VALUES (15, 254);
INSERT INTO `tCourseToUser` VALUES (15, 256);
INSERT INTO `tCourseToUser` VALUES (15, 267);
INSERT INTO `tCourseToUser` VALUES (15, 436);
INSERT INTO `tCourseToUser` VALUES (16, 240);
INSERT INTO `tCourseToUser` VALUES (16, 243);
INSERT INTO `tCourseToUser` VALUES (16, 253);
INSERT INTO `tCourseToUser` VALUES (16, 259);
INSERT INTO `tCourseToUser` VALUES (16, 261);
INSERT INTO `tCourseToUser` VALUES (16, 437);
INSERT INTO `tCourseToUser` VALUES (17, 238);
INSERT INTO `tCourseToUser` VALUES (17, 247);
INSERT INTO `tCourseToUser` VALUES (17, 250);
INSERT INTO `tCourseToUser` VALUES (17, 435);
INSERT INTO `tCourseToUser` VALUES (17, 504);
INSERT INTO `tCourseToUser` VALUES (17, 564);
INSERT INTO `tCourseToUser` VALUES (17, 565);
INSERT INTO `tCourseToUser` VALUES (17, 566);
INSERT INTO `tCourseToUser` VALUES (17, 567);
INSERT INTO `tCourseToUser` VALUES (17, 568);
INSERT INTO `tCourseToUser` VALUES (17, 569);
INSERT INTO `tCourseToUser` VALUES (17, 570);
INSERT INTO `tCourseToUser` VALUES (17, 571);
INSERT INTO `tCourseToUser` VALUES (17, 572);
INSERT INTO `tCourseToUser` VALUES (17, 573);
INSERT INTO `tCourseToUser` VALUES (17, 574);
INSERT INTO `tCourseToUser` VALUES (17, 575);
INSERT INTO `tCourseToUser` VALUES (17, 593);
INSERT INTO `tCourseToUser` VALUES (17, 624);
INSERT INTO `tCourseToUser` VALUES (18, 241);
INSERT INTO `tCourseToUser` VALUES (18, 248);
INSERT INTO `tCourseToUser` VALUES (18, 250);
INSERT INTO `tCourseToUser` VALUES (18, 257);
INSERT INTO `tCourseToUser` VALUES (18, 268);
INSERT INTO `tCourseToUser` VALUES (18, 438);

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

-- 
-- Table structure for table `tDomain`
-- 

CREATE TABLE `tDomain` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `id_parent` bigint(20) unsigned NOT NULL,
  `id_course` bigint(20) unsigned NOT NULL,
  `subject` varchar(128) collate utf8_slovak_ci NOT NULL,
  `description` text collate utf8_slovak_ci NOT NULL,
  `obsolete` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `tDomain`
-- 

INSERT INTO `tDomain` VALUES (1, 0, 17, '1', '111111', 0);
INSERT INTO `tDomain` VALUES (2, 0, 17, '2', '', 0);
INSERT INTO `tDomain` VALUES (3, 2, 17, '22', '', 0);

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

-- 
-- Table structure for table `tExam`
-- 

CREATE TABLE `tExam` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `id_course` bigint(20) unsigned NOT NULL,
  `date` datetime NOT NULL,
  `state` enum('scheduled','progress','finished') collate utf8_slovak_ci NOT NULL,
  `comment` text collate utf8_slovak_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `tExam`
-- 

INSERT INTO `tExam` VALUES (1, 17, '2007-06-15 10:00:00', 'finished', '');
INSERT INTO `tExam` VALUES (2, 17, '2007-06-17 10:00:00', 'finished', '');
INSERT INTO `tExam` VALUES (3, 14, '2007-06-15 16:00:20', 'scheduled', '');
INSERT INTO `tExam` VALUES (4, 14, '2007-06-15 18:08:40', 'scheduled', '');

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

-- 
-- Table structure for table `tExamToUser`
-- 

CREATE TABLE `tExamToUser` (
  `id_exam` bigint(20) unsigned NOT NULL,
  `id_user` bigint(20) unsigned NOT NULL,
  PRIMARY KEY  (`id_exam`,`id_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci;

-- 
-- Dumping data for table `tExamToUser`
-- 

INSERT INTO `tExamToUser` VALUES (1, 444);
INSERT INTO `tExamToUser` VALUES (1, 447);
INSERT INTO `tExamToUser` VALUES (1, 564);
INSERT INTO `tExamToUser` VALUES (1, 565);
INSERT INTO `tExamToUser` VALUES (1, 593);
INSERT INTO `tExamToUser` VALUES (2, 566);
INSERT INTO `tExamToUser` VALUES (2, 567);
INSERT INTO `tExamToUser` VALUES (2, 568);
INSERT INTO `tExamToUser` VALUES (2, 593);
INSERT INTO `tExamToUser` VALUES (3, 440);
INSERT INTO `tExamToUser` VALUES (3, 442);
INSERT INTO `tExamToUser` VALUES (3, 447);
INSERT INTO `tExamToUser` VALUES (4, 453);
INSERT INTO `tExamToUser` VALUES (4, 458);
INSERT INTO `tExamToUser` VALUES (4, 461);
INSERT INTO `tExamToUser` VALUES (4, 462);

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

-- 
-- Table structure for table `tImportData`
-- 

CREATE TABLE `tImportData` (
  `url` text NOT NULL,
  `id` varchar(32) NOT NULL,
  `idPrefix` varchar(6) NOT NULL,
  `pubKey` varchar(256) NOT NULL,
  `pubMod` varchar(256) NOT NULL,
  `bLoadedBkp` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `tImportData`
-- 

INSERT INTO `tImportData` VALUES ('http://sprite.edi.fmph.uniba.sk/~probatur/libs/dummyServer.php', 'c38ff948c80e52d91946698f79f3dd96', 'wPy3Ja', '3', '29b', 1);

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

-- 
-- Table structure for table `tProctors`
-- 

CREATE TABLE `tProctors` (
  `id` bigint(20) unsigned NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci;

-- 
-- Dumping data for table `tProctors`
-- 


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

-- 
-- Table structure for table `tProctorToTeacher`
-- 

CREATE TABLE `tProctorToTeacher` (
  `id_proctor` bigint(20) unsigned NOT NULL,
  `id_teacher` bigint(20) unsigned NOT NULL,
  PRIMARY KEY  (`id_proctor`,`id_teacher`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `tProctorToTeacher`
-- 

INSERT INTO `tProctorToTeacher` VALUES (426, 435);
INSERT INTO `tProctorToTeacher` VALUES (427, 435);

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

-- 
-- Table structure for table `tQuestion`
-- 

CREATE TABLE `tQuestion` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `id_domain` bigint(20) unsigned NOT NULL,
  `question` text collate utf8_slovak_ci NOT NULL,
  `obsolete` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `id_domain` (`id_domain`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `tQuestion`
-- 

INSERT INTO `tQuestion` VALUES (1, 1, 'Ake su hlavne casti CPU?', 0);
INSERT INTO `tQuestion` VALUES (2, 2, 'Ake su hlavne casti PC?', 0);
INSERT INTO `tQuestion` VALUES (3, 3, 'Kolko ste prispeli svojmu ucitelovi?', 0);

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

-- 
-- Table structure for table `tScale`
-- 

CREATE TABLE `tScale` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `ptsFull` smallint(5) NOT NULL,
  `ptsEmpty` smallint(5) NOT NULL,
  `ptsPartial` smallint(5) NOT NULL,
  `ptsBad` smallint(5) NOT NULL,
  `A` int(10) NOT NULL,
  `B` int(10) NOT NULL,
  `C` int(10) NOT NULL,
  `D` int(10) NOT NULL,
  `E` int(10) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `tScale`
-- 

INSERT INTO `tScale` VALUES (0, 1, 0, 0, 0, 18, 16, 14, 12, 10);
INSERT INTO `tScale` VALUES (1, 2, -1, -1, -2, 1, -1, 0, 0, 0);

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

-- 
-- Table structure for table `tSession`
-- 

CREATE TABLE `tSession` (
  `sessionId` varchar(100) NOT NULL,
  `lastUpdated` datetime NOT NULL,
  `dataValue` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `tSession`
-- 

INSERT INTO `tSession` VALUES ('406dc27849c6d7549b2bb50a1599b8a4', '2007-06-14 00:23:24', '');
INSERT INTO `tSession` VALUES ('ccfa34c22d03eeab27bf43e7d85232f5', '2007-06-13 15:59:41', '');
INSERT INTO `tSession` VALUES ('dcdd5505ed3a7b4011602c90fbc3a9ef', '2007-06-13 19:16:16', '');

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

-- 
-- Table structure for table `tSpecialization`
-- 

CREATE TABLE `tSpecialization` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `name` text NOT NULL,
  `id_garant` bigint(20) unsigned NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

-- 
-- Dumping data for table `tSpecialization`
-- 

INSERT INTO `tSpecialization` VALUES (1, 'Aplikovaná Informatika', 426);
INSERT INTO `tSpecialization` VALUES (2, 'Biomedicínska fyzika', 427);
INSERT INTO `tSpecialization` VALUES (3, 'Ekonomická a finančná matematika', 428);
INSERT INTO `tSpecialization` VALUES (4, 'Fyzika', 429);
INSERT INTO `tSpecialization` VALUES (5, 'Informatika', 430);
INSERT INTO `tSpecialization` VALUES (6, 'Matematika', 431);

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

-- 
-- Table structure for table `tStudents`
-- 

CREATE TABLE `tStudents` (
  `id` bigint(20) unsigned NOT NULL,
  `id_specialization` bigint(20) unsigned NOT NULL,
  `year` int(10) unsigned NOT NULL,
  `bkp` tinyint(1) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci;

-- 
-- Dumping data for table `tStudents`
-- 

INSERT INTO `tStudents` VALUES (439, 1, 1, 0);
INSERT INTO `tStudents` VALUES (440, 1, 1, 0);
INSERT INTO `tStudents` VALUES (441, 1, 1, 0);
INSERT INTO `tStudents` VALUES (442, 1, 1, 0);
INSERT INTO `tStudents` VALUES (443, 1, 1, 0);
INSERT INTO `tStudents` VALUES (444, 1, 1, 0);
INSERT INTO `tStudents` VALUES (445, 1, 1, 0);
INSERT INTO `tStudents` VALUES (446, 1, 1, 0);
INSERT INTO `tStudents` VALUES (447, 1, 1, 0);
INSERT INTO `tStudents` VALUES (448, 1, 1, 0);
INSERT INTO `tStudents` VALUES (449, 1, 1, 0);
INSERT INTO `tStudents` VALUES (450, 1, 1, 0);
INSERT INTO `tStudents` VALUES (451, 1, 1, 0);
INSERT INTO `tStudents` VALUES (452, 1, 1, 0);
INSERT INTO `tStudents` VALUES (453, 1, 1, 0);
INSERT INTO `tStudents` VALUES (454, 1, 1, 0);
INSERT INTO `tStudents` VALUES (455, 1, 1, 0);
INSERT INTO `tStudents` VALUES (456, 1, 1, 0);
INSERT INTO `tStudents` VALUES (457, 1, 1, 0);
INSERT INTO `tStudents` VALUES (458, 1, 1, 0);
INSERT INTO `tStudents` VALUES (459, 1, 1, 0);
INSERT INTO `tStudents` VALUES (460, 1, 1, 0);
INSERT INTO `tStudents` VALUES (461, 1, 1, 0);
INSERT INTO `tStudents` VALUES (462, 1, 1, 0);
INSERT INTO `tStudents` VALUES (463, 1, 1, 0);
INSERT INTO `tStudents` VALUES (464, 1, 1, 0);
INSERT INTO `tStudents` VALUES (465, 1, 1, 0);
INSERT INTO `tStudents` VALUES (466, 1, 1, 0);
INSERT INTO `tStudents` VALUES (467, 1, 1, 0);
INSERT INTO `tStudents` VALUES (468, 1, 1, 0);
INSERT INTO `tStudents` VALUES (469, 1, 1, 0);
INSERT INTO `tStudents` VALUES (470, 1, 2, 0);
INSERT INTO `tStudents` VALUES (471, 1, 2, 0);
INSERT INTO `tStudents` VALUES (472, 1, 2, 0);
INSERT INTO `tStudents` VALUES (473, 1, 2, 0);
INSERT INTO `tStudents` VALUES (474, 1, 2, 0);
INSERT INTO `tStudents` VALUES (475, 1, 2, 0);
INSERT INTO `tStudents` VALUES (476, 1, 2, 0);
INSERT INTO `tStudents` VALUES (477, 1, 2, 0);
INSERT INTO `tStudents` VALUES (478, 1, 2, 0);
INSERT INTO `tStudents` VALUES (479, 1, 2, 0);
INSERT INTO `tStudents` VALUES (480, 1, 2, 0);
INSERT INTO `tStudents` VALUES (481, 1, 2, 0);
INSERT INTO `tStudents` VALUES (482, 1, 2, 0);
INSERT INTO `tStudents` VALUES (483, 1, 2, 0);
INSERT INTO `tStudents` VALUES (484, 1, 2, 0);
INSERT INTO `tStudents` VALUES (485, 1, 2, 0);
INSERT INTO `tStudents` VALUES (486, 1, 2, 0);
INSERT INTO `tStudents` VALUES (487, 1, 2, 0);
INSERT INTO `tStudents` VALUES (488, 1, 2, 0);
INSERT INTO `tStudents` VALUES (489, 1, 2, 0);
INSERT INTO `tStudents` VALUES (490, 1, 2, 0);
INSERT INTO `tStudents` VALUES (491, 1, 2, 0);
INSERT INTO `tStudents` VALUES (492, 1, 2, 0);
INSERT INTO `tStudents` VALUES (493, 1, 3, 0);
INSERT INTO `tStudents` VALUES (494, 1, 3, 0);
INSERT INTO `tStudents` VALUES (495, 1, 3, 0);
INSERT INTO `tStudents` VALUES (496, 1, 3, 0);
INSERT INTO `tStudents` VALUES (497, 1, 3, 0);
INSERT INTO `tStudents` VALUES (498, 1, 3, 0);
INSERT INTO `tStudents` VALUES (499, 1, 3, 0);
INSERT INTO `tStudents` VALUES (500, 1, 3, 0);
INSERT INTO `tStudents` VALUES (501, 2, 1, 0);
INSERT INTO `tStudents` VALUES (502, 2, 1, 0);
INSERT INTO `tStudents` VALUES (503, 2, 1, 0);
INSERT INTO `tStudents` VALUES (504, 2, 2, 0);
INSERT INTO `tStudents` VALUES (505, 2, 2, 0);
INSERT INTO `tStudents` VALUES (506, 2, 2, 0);
INSERT INTO `tStudents` VALUES (507, 2, 2, 0);
INSERT INTO `tStudents` VALUES (508, 2, 2, 0);
INSERT INTO `tStudents` VALUES (509, 2, 2, 0);
INSERT INTO `tStudents` VALUES (510, 2, 2, 0);
INSERT INTO `tStudents` VALUES (511, 2, 2, 0);
INSERT INTO `tStudents` VALUES (512, 2, 2, 0);
INSERT INTO `tStudents` VALUES (513, 3, 1, 0);
INSERT INTO `tStudents` VALUES (514, 3, 1, 0);
INSERT INTO `tStudents` VALUES (515, 3, 1, 0);
INSERT INTO `tStudents` VALUES (516, 3, 1, 0);
INSERT INTO `tStudents` VALUES (517, 3, 1, 0);
INSERT INTO `tStudents` VALUES (518, 3, 1, 0);
INSERT INTO `tStudents` VALUES (519, 3, 1, 0);
INSERT INTO `tStudents` VALUES (520, 3, 1, 0);
INSERT INTO `tStudents` VALUES (521, 3, 1, 0);
INSERT INTO `tStudents` VALUES (522, 3, 1, 0);
INSERT INTO `tStudents` VALUES (523, 3, 1, 0);
INSERT INTO `tStudents` VALUES (524, 3, 9, 1);
INSERT INTO `tStudents` VALUES (525, 3, 2, 0);
INSERT INTO `tStudents` VALUES (526, 3, 2, 0);
INSERT INTO `tStudents` VALUES (527, 3, 2, 0);
INSERT INTO `tStudents` VALUES (528, 3, 2, 0);
INSERT INTO `tStudents` VALUES (529, 3, 2, 0);
INSERT INTO `tStudents` VALUES (530, 3, 2, 0);
INSERT INTO `tStudents` VALUES (531, 3, 2, 0);
INSERT INTO `tStudents` VALUES (532, 3, 2, 0);
INSERT INTO `tStudents` VALUES (533, 3, 2, 0);
INSERT INTO `tStudents` VALUES (534, 3, 2, 0);
INSERT INTO `tStudents` VALUES (535, 4, 1, 0);
INSERT INTO `tStudents` VALUES (536, 4, 1, 0);
INSERT INTO `tStudents` VALUES (537, 4, 1, 0);
INSERT INTO `tStudents` VALUES (538, 4, 1, 0);
INSERT INTO `tStudents` VALUES (539, 4, 1, 0);
INSERT INTO `tStudents` VALUES (540, 4, 1, 0);
INSERT INTO `tStudents` VALUES (541, 4, 1, 0);
INSERT INTO `tStudents` VALUES (542, 4, 1, 0);
INSERT INTO `tStudents` VALUES (543, 4, 1, 0);
INSERT INTO `tStudents` VALUES (544, 4, 1, 0);
INSERT INTO `tStudents` VALUES (545, 4, 1, 0);
INSERT INTO `tStudents` VALUES (546, 4, 1, 0);
INSERT INTO `tStudents` VALUES (547, 4, 2, 0);
INSERT INTO `tStudents` VALUES (548, 4, 2, 0);
INSERT INTO `tStudents` VALUES (549, 4, 2, 0);
INSERT INTO `tStudents` VALUES (550, 4, 2, 0);
INSERT INTO `tStudents` VALUES (551, 4, 2, 0);
INSERT INTO `tStudents` VALUES (552, 4, 2, 0);
INSERT INTO `tStudents` VALUES (553, 4, 2, 0);
INSERT INTO `tStudents` VALUES (554, 4, 3, 0);
INSERT INTO `tStudents` VALUES (555, 4, 3, 0);
INSERT INTO `tStudents` VALUES (556, 4, 3, 0);
INSERT INTO `tStudents` VALUES (557, 4, 3, 0);
INSERT INTO `tStudents` VALUES (558, 4, 3, 0);
INSERT INTO `tStudents` VALUES (559, 4, 3, 0);
INSERT INTO `tStudents` VALUES (560, 4, 3, 0);
INSERT INTO `tStudents` VALUES (561, 4, 3, 0);
INSERT INTO `tStudents` VALUES (562, 4, 3, 0);
INSERT INTO `tStudents` VALUES (564, 5, 1, 0);
INSERT INTO `tStudents` VALUES (565, 5, 1, 0);
INSERT INTO `tStudents` VALUES (566, 5, 1, 0);
INSERT INTO `tStudents` VALUES (567, 5, 1, 0);
INSERT INTO `tStudents` VALUES (568, 5, 1, 0);
INSERT INTO `tStudents` VALUES (569, 5, 1, 0);
INSERT INTO `tStudents` VALUES (570, 5, 1, 0);
INSERT INTO `tStudents` VALUES (571, 5, 1, 0);
INSERT INTO `tStudents` VALUES (572, 5, 1, 0);
INSERT INTO `tStudents` VALUES (573, 5, 1, 0);
INSERT INTO `tStudents` VALUES (574, 5, 1, 0);
INSERT INTO `tStudents` VALUES (575, 5, 1, 0);
INSERT INTO `tStudents` VALUES (576, 5, 2, 0);
INSERT INTO `tStudents` VALUES (577, 5, 2, 0);
INSERT INTO `tStudents` VALUES (578, 5, 2, 0);
INSERT INTO `tStudents` VALUES (579, 5, 2, 0);
INSERT INTO `tStudents` VALUES (580, 5, 2, 0);
INSERT INTO `tStudents` VALUES (581, 5, 2, 0);
INSERT INTO `tStudents` VALUES (582, 5, 2, 0);
INSERT INTO `tStudents` VALUES (583, 5, 2, 0);
INSERT INTO `tStudents` VALUES (584, 5, 3, 0);
INSERT INTO `tStudents` VALUES (585, 5, 3, 0);
INSERT INTO `tStudents` VALUES (586, 5, 3, 0);
INSERT INTO `tStudents` VALUES (587, 5, 3, 0);
INSERT INTO `tStudents` VALUES (588, 5, 3, 0);
INSERT INTO `tStudents` VALUES (589, 5, 3, 0);
INSERT INTO `tStudents` VALUES (590, 5, 3, 0);
INSERT INTO `tStudents` VALUES (591, 5, 3, 0);
INSERT INTO `tStudents` VALUES (592, 5, 3, 0);
INSERT INTO `tStudents` VALUES (593, 5, 3, 0);
INSERT INTO `tStudents` VALUES (594, 5, 3, 0);
INSERT INTO `tStudents` VALUES (595, 6, 1, 0);
INSERT INTO `tStudents` VALUES (596, 6, 1, 0);
INSERT INTO `tStudents` VALUES (597, 6, 1, 0);
INSERT INTO `tStudents` VALUES (598, 6, 1, 0);
INSERT INTO `tStudents` VALUES (599, 6, 1, 0);
INSERT INTO `tStudents` VALUES (600, 6, 1, 0);
INSERT INTO `tStudents` VALUES (601, 6, 1, 0);
INSERT INTO `tStudents` VALUES (602, 6, 1, 0);
INSERT INTO `tStudents` VALUES (603, 6, 1, 0);
INSERT INTO `tStudents` VALUES (604, 6, 1, 0);
INSERT INTO `tStudents` VALUES (605, 6, 1, 0);
INSERT INTO `tStudents` VALUES (606, 6, 1, 0);
INSERT INTO `tStudents` VALUES (607, 6, 1, 0);
INSERT INTO `tStudents` VALUES (608, 6, 1, 0);
INSERT INTO `tStudents` VALUES (609, 6, 2, 0);
INSERT INTO `tStudents` VALUES (610, 6, 2, 0);
INSERT INTO `tStudents` VALUES (611, 6, 2, 0);
INSERT INTO `tStudents` VALUES (612, 6, 2, 0);
INSERT INTO `tStudents` VALUES (613, 6, 2, 0);
INSERT INTO `tStudents` VALUES (614, 6, 2, 0);
INSERT INTO `tStudents` VALUES (615, 6, 2, 0);
INSERT INTO `tStudents` VALUES (616, 6, 3, 0);
INSERT INTO `tStudents` VALUES (617, 6, 3, 0);
INSERT INTO `tStudents` VALUES (618, 6, 3, 0);
INSERT INTO `tStudents` VALUES (619, 6, 3, 0);
INSERT INTO `tStudents` VALUES (620, 6, 3, 0);
INSERT INTO `tStudents` VALUES (621, 6, 3, 0);
INSERT INTO `tStudents` VALUES (622, 6, 3, 0);
INSERT INTO `tStudents` VALUES (623, 3, 2, 0);
INSERT INTO `tStudents` VALUES (624, 5, 1, 0);

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

-- 
-- Table structure for table `tTeachers`
-- 

CREATE TABLE `tTeachers` (
  `id` bigint(20) unsigned NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci;

-- 
-- Dumping data for table `tTeachers`
-- 

INSERT INTO `tTeachers` VALUES (426);
INSERT INTO `tTeachers` VALUES (427);
INSERT INTO `tTeachers` VALUES (428);
INSERT INTO `tTeachers` VALUES (429);
INSERT INTO `tTeachers` VALUES (430);
INSERT INTO `tTeachers` VALUES (431);
INSERT INTO `tTeachers` VALUES (432);
INSERT INTO `tTeachers` VALUES (433);
INSERT INTO `tTeachers` VALUES (434);
INSERT INTO `tTeachers` VALUES (435);
INSERT INTO `tTeachers` VALUES (436);
INSERT INTO `tTeachers` VALUES (437);
INSERT INTO `tTeachers` VALUES (438);

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

-- 
-- Table structure for table `tTest`
-- 

CREATE TABLE `tTest` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `id_exam` bigint(20) unsigned NOT NULL,
  `id_testTemplate` bigint(20) unsigned NOT NULL,
  `id_user` bigint(20) unsigned NOT NULL,
  `comment` text NOT NULL,
  `totalTime` int(11) NOT NULL,
  `mark` enum('A','B','C','D','E','Fx') default NULL,
  `points` smallint(6) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

-- 
-- Dumping data for table `tTest`
-- 

INSERT INTO `tTest` VALUES (1, 0, 8, 0, '', 0, NULL, NULL);
INSERT INTO `tTest` VALUES (2, 0, 9, 0, '', 0, NULL, NULL);
INSERT INTO `tTest` VALUES (3, 0, 10, 0, '', 0, NULL, NULL);
INSERT INTO `tTest` VALUES (6, 1, 4, 593, 'Blby den...', 1181652228, 'Fx', -18);
INSERT INTO `tTest` VALUES (7, 2, 2, 593, '', 1181729783, 'Fx', -2);

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

-- 
-- Table structure for table `tTestAnswer`
-- 

CREATE TABLE `tTestAnswer` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `id_test` bigint(20) unsigned NOT NULL,
  `comment` text NOT NULL,
  `totalTime` int(11) NOT NULL,
  `index` int(11) unsigned NOT NULL,
  `points` tinyint(4) NOT NULL,
  `answerType` enum('full','partial','missing','bad') NOT NULL,
  `answerMark` enum('unread','answered','undone','unknown','else') NOT NULL default 'unread',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;

-- 
-- Dumping data for table `tTestAnswer`
-- 

INSERT INTO `tTestAnswer` VALUES (1, 1, '', 0, 1, 0, 'full', 'unread');
INSERT INTO `tTestAnswer` VALUES (2, 1, '', 0, 2, 0, 'full', 'unread');
INSERT INTO `tTestAnswer` VALUES (3, 2, '', 0, 1, 0, 'full', 'unread');
INSERT INTO `tTestAnswer` VALUES (4, 2, '', 0, 2, 0, 'full', 'unread');
INSERT INTO `tTestAnswer` VALUES (5, 3, '', 0, 1, 0, 'full', 'unread');
INSERT INTO `tTestAnswer` VALUES (6, 3, '', 0, 2, 0, 'full', 'unread');
INSERT INTO `tTestAnswer` VALUES (13, 7, '', 0, 1, -1, 'missing', 'unread');
INSERT INTO `tTestAnswer` VALUES (12, 6, '2 otazka', 18, 2, -20, 'full', 'unknown');
INSERT INTO `tTestAnswer` VALUES (11, 6, 'poznamka k prvej otazke', 29, 1, 2, 'full', 'answered');
INSERT INTO `tTestAnswer` VALUES (14, 7, '', 0, 2, -1, 'missing', 'unread');

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

-- 
-- Table structure for table `tTestAnswerToAnswer`
-- 

CREATE TABLE `tTestAnswerToAnswer` (
  `id_testAnswer` bigint(20) unsigned NOT NULL,
  `id_answer` bigint(20) unsigned NOT NULL,
  `value` tinyint(1) NOT NULL,
  `index` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`id_testAnswer`,`id_answer`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `tTestAnswerToAnswer`
-- 

INSERT INTO `tTestAnswerToAnswer` VALUES (1, 13, 0, 1);
INSERT INTO `tTestAnswerToAnswer` VALUES (1, 12, 0, 2);
INSERT INTO `tTestAnswerToAnswer` VALUES (1, 11, 0, 3);
INSERT INTO `tTestAnswerToAnswer` VALUES (2, 9, 0, 1);
INSERT INTO `tTestAnswerToAnswer` VALUES (2, 7, 0, 2);
INSERT INTO `tTestAnswerToAnswer` VALUES (2, 10, 0, 3);
INSERT INTO `tTestAnswerToAnswer` VALUES (2, 5, 0, 4);
INSERT INTO `tTestAnswerToAnswer` VALUES (2, 6, 0, 5);
INSERT INTO `tTestAnswerToAnswer` VALUES (2, 8, 0, 6);
INSERT INTO `tTestAnswerToAnswer` VALUES (3, 5, 0, 1);
INSERT INTO `tTestAnswerToAnswer` VALUES (3, 9, 0, 2);
INSERT INTO `tTestAnswerToAnswer` VALUES (3, 7, 0, 3);
INSERT INTO `tTestAnswerToAnswer` VALUES (3, 6, 0, 4);
INSERT INTO `tTestAnswerToAnswer` VALUES (3, 8, 0, 5);
INSERT INTO `tTestAnswerToAnswer` VALUES (3, 10, 0, 6);
INSERT INTO `tTestAnswerToAnswer` VALUES (4, 11, 0, 1);
INSERT INTO `tTestAnswerToAnswer` VALUES (4, 13, 0, 2);
INSERT INTO `tTestAnswerToAnswer` VALUES (4, 12, 0, 3);
INSERT INTO `tTestAnswerToAnswer` VALUES (5, 5, 0, 1);
INSERT INTO `tTestAnswerToAnswer` VALUES (5, 6, 0, 2);
INSERT INTO `tTestAnswerToAnswer` VALUES (5, 10, 0, 3);
INSERT INTO `tTestAnswerToAnswer` VALUES (5, 9, 0, 4);
INSERT INTO `tTestAnswerToAnswer` VALUES (5, 7, 0, 5);
INSERT INTO `tTestAnswerToAnswer` VALUES (5, 8, 0, 6);
INSERT INTO `tTestAnswerToAnswer` VALUES (6, 12, 0, 1);
INSERT INTO `tTestAnswerToAnswer` VALUES (6, 13, 0, 2);
INSERT INTO `tTestAnswerToAnswer` VALUES (6, 11, 0, 3);
INSERT INTO `tTestAnswerToAnswer` VALUES (12, 4, 0, 1);
INSERT INTO `tTestAnswerToAnswer` VALUES (11, 7, 1, 6);
INSERT INTO `tTestAnswerToAnswer` VALUES (11, 10, 0, 5);
INSERT INTO `tTestAnswerToAnswer` VALUES (11, 8, 0, 4);
INSERT INTO `tTestAnswerToAnswer` VALUES (11, 9, 0, 3);
INSERT INTO `tTestAnswerToAnswer` VALUES (11, 6, 1, 2);
INSERT INTO `tTestAnswerToAnswer` VALUES (11, 5, 1, 1);
INSERT INTO `tTestAnswerToAnswer` VALUES (12, 3, 1, 2);
INSERT INTO `tTestAnswerToAnswer` VALUES (12, 1, 1, 3);
INSERT INTO `tTestAnswerToAnswer` VALUES (12, 2, 1, 4);
INSERT INTO `tTestAnswerToAnswer` VALUES (13, 1, 0, 1);
INSERT INTO `tTestAnswerToAnswer` VALUES (13, 2, 0, 2);
INSERT INTO `tTestAnswerToAnswer` VALUES (13, 4, 0, 3);
INSERT INTO `tTestAnswerToAnswer` VALUES (13, 3, 0, 4);
INSERT INTO `tTestAnswerToAnswer` VALUES (14, 11, 0, 1);
INSERT INTO `tTestAnswerToAnswer` VALUES (14, 13, 0, 2);
INSERT INTO `tTestAnswerToAnswer` VALUES (14, 12, 0, 3);

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

-- 
-- Table structure for table `tTestItems`
-- 

CREATE TABLE `tTestItems` (
  `id_testTemplate` bigint(20) unsigned NOT NULL,
  `id_answerSet` bigint(20) unsigned NOT NULL,
  KEY `id_testTemplate` (`id_testTemplate`,`id_answerSet`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `tTestItems`
-- 

INSERT INTO `tTestItems` VALUES (2, 1);
INSERT INTO `tTestItems` VALUES (2, 3);
INSERT INTO `tTestItems` VALUES (3, 2);
INSERT INTO `tTestItems` VALUES (3, 3);
INSERT INTO `tTestItems` VALUES (4, 1);
INSERT INTO `tTestItems` VALUES (4, 2);
INSERT INTO `tTestItems` VALUES (5, 2);
INSERT INTO `tTestItems` VALUES (5, 3);
INSERT INTO `tTestItems` VALUES (6, 2);
INSERT INTO `tTestItems` VALUES (6, 3);
INSERT INTO `tTestItems` VALUES (7, 1);
INSERT INTO `tTestItems` VALUES (7, 3);
INSERT INTO `tTestItems` VALUES (8, 2);
INSERT INTO `tTestItems` VALUES (8, 3);
INSERT INTO `tTestItems` VALUES (9, 2);
INSERT INTO `tTestItems` VALUES (9, 3);
INSERT INTO `tTestItems` VALUES (10, 2);
INSERT INTO `tTestItems` VALUES (10, 3);

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

-- 
-- Table structure for table `tTestTemplate`
-- 

CREATE TABLE `tTestTemplate` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `id_course` bigint(20) unsigned NOT NULL,
  `printed` tinyint(1) NOT NULL,
  `obsolete` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci AUTO_INCREMENT=11 ;

-- 
-- Dumping data for table `tTestTemplate`
-- 

INSERT INTO `tTestTemplate` VALUES (2, 17, 0, 0);
INSERT INTO `tTestTemplate` VALUES (3, 17, 0, 0);
INSERT INTO `tTestTemplate` VALUES (4, 17, 0, 0);
INSERT INTO `tTestTemplate` VALUES (5, 17, 0, 0);
INSERT INTO `tTestTemplate` VALUES (6, 17, 0, 0);
INSERT INTO `tTestTemplate` VALUES (7, 17, 0, 0);
INSERT INTO `tTestTemplate` VALUES (8, 17, 1, 0);
INSERT INTO `tTestTemplate` VALUES (9, 17, 1, 0);
INSERT INTO `tTestTemplate` VALUES (10, 17, 1, 0);

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

-- 
-- Table structure for table `tTimeStamps`
-- 

CREATE TABLE `tTimeStamps` (
  `id_user` bigint(20) NOT NULL,
  `id_test` bigint(20) NOT NULL,
  `timeStamp` bigint(20) NOT NULL,
  PRIMARY KEY  (`id_user`,`id_test`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `tTimeStamps`
-- 

INSERT INTO `tTimeStamps` VALUES (593, 4, 1181651972);
INSERT INTO `tTimeStamps` VALUES (593, 5, 1181652048);
INSERT INTO `tTimeStamps` VALUES (593, 6, 1181652197);
INSERT INTO `tTimeStamps` VALUES (593, 7, 1181728034);

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

-- 
-- Table structure for table `tUser`
-- 

CREATE TABLE `tUser` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `namePrefix` varchar(12) collate utf8_slovak_ci NOT NULL,
  `name` varchar(15) collate utf8_slovak_ci NOT NULL,
  `surname` varchar(25) collate utf8_slovak_ci NOT NULL,
  `nameSuffix` varchar(12) collate utf8_slovak_ci NOT NULL,
  `login` varchar(40) collate utf8_slovak_ci NOT NULL,
  `password` varchar(32) collate utf8_slovak_ci NOT NULL,
  `passPrefix` varchar(6) collate utf8_slovak_ci NOT NULL,
  `ISIC` bigint(20) NOT NULL,
  `bISICValid` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `login` (`login`,`ISIC`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci AUTO_INCREMENT=625 ;

-- 
-- Dumping data for table `tUser`
-- 

INSERT INTO `tUser` VALUES (1, 'RNDr.', 'Tajny', 'Admin', 'CSc.', 'admin', 'ac5aae7a600dcad8aed48174c5350dc3', 'ab4e3x', 1234567890, 1);
INSERT INTO `tUser` VALUES (426, 'RNDr.', 'Jaroslav', 'Guričan', 'CSc.', 'GuricanJaroslav', '7c3ae55f242092dd27d0ea65a4b813cd', 'F5RwVZ', 2000000001, 1);
INSERT INTO `tUser` VALUES (427, 'RNDr.', 'Zbyněk', 'Kubáček', 'CSc.', 'KubacekZbynek', 'd3bd7a3849b418b471c0ee0cd925e47e', 'wla9wp', 2000000002, 1);
INSERT INTO `tUser` VALUES (428, 'doc. RNDr.', 'Eduard', 'Toman', 'CSc.', 'TomanEduard', '20baeed4b5378764bcf141653679050f', 'YSExCY', 2000000003, 1);
INSERT INTO `tUser` VALUES (429, 'RNDr.', 'Andrej', 'Blaho', '', 'BlahoAndrej', 'c431ac51140e726f7c6d26bcf37f0c92', 'foedlx', 2000000004, 1);
INSERT INTO `tUser` VALUES (430, 'doc. RNDr.', 'Daniel', 'Olejár', 'PhD.', 'OlejarDaniel', '644652afd77ff9558e5e7f72b689d0b5', 'DKoNxJ', 2000000005, 1);
INSERT INTO `tUser` VALUES (431, 'prof. RNDr.', 'Martin', 'Škoviera', 'PhD.', 'SkovieraMartin', 'b19855f65091a61d5d5a92872f6288c7', 'Z3DHpp', 2000000006, 1);
INSERT INTO `tUser` VALUES (432, 'RNDr.', 'Michal', 'Winczer', 'PhD.', 'WinczerMichal', '74c7d4ad2bdbd753d199b13b71ff7507', 'xLBxKY', 2000000007, 1);
INSERT INTO `tUser` VALUES (433, 'prof. RNDr.', 'Branislav', 'Rovan', 'PhD.', 'RovanBranislav', '9477c7dbd5ade9afacced87eddd71b60', 'MyGgW9', 2000000008, 1);
INSERT INTO `tUser` VALUES (434, 'doc. RNDr.', 'Juraj', 'Procházka', 'CSc.', 'ProchazkaJuraj', '29ee1a0ab9c6b64cd7660b83cb11c125', '63na6z', 2000000009, 1);
INSERT INTO `tUser` VALUES (435, 'RNDr.', 'Richard', 'Ostertág', '', 'OstertagRichard', '5e274ea4169194f24501f93543760441', 'xz0Lcx', 2000000010, 1);
INSERT INTO `tUser` VALUES (436, 'Dr.', 'Tomáš', 'Plachetka', '', 'PlachetkaTomas', 'c2d6de117f8064a86cd8adc56ef69650', 'l3pOzE', 2000000011, 1);
INSERT INTO `tUser` VALUES (437, 'RNDr.', 'Andrej', 'Bebják', '', 'BebjakAndrej', 'e28fe7e59f92e18bd17b7b0b16a8e5c0', '5WgvkQ', 2000000012, 1);
INSERT INTO `tUser` VALUES (438, 'doc. RNDr.', 'Pavol', 'Ďuriš', 'CSc.', 'DurisPavol', '15128ed283f7b6fb0c6c8d04f0dd8339', 'kWfQ42', 2000000014, 1);
INSERT INTO `tUser` VALUES (439, '', 'Peter', 'Bátora', '', 'BatoraPeter', 'a1ead5c0f23c284e2a3aeb69e8ece93b', 'PZU4ZP', 1000000005, 1);
INSERT INTO `tUser` VALUES (440, '', 'Andrej', 'Bihuň', '', 'BihunAndrej', '69097bee06cc27030c890ccc6c0747d7', 'snerYh', 1000000010, 1);
INSERT INTO `tUser` VALUES (441, '', 'Ján', 'Boldiš', '', 'BoldisJan', '150dcac7b30383c80aea9ac1263d9a9f', 'Pa05Pz', 1000000015, 1);
INSERT INTO `tUser` VALUES (442, '', 'Alexander', 'Bugala', '', 'BugalaAlexander', 'cdf466946dafa358a9009d6fbcac43a0', 'zJlG6w', 1000000020, 1);
INSERT INTO `tUser` VALUES (443, '', 'Ivan', 'Debnár', '', 'DebnarIvan', '096f330221861e7abf4c51e046a5821f', 'mfjsVc', 1000000025, 1);
INSERT INTO `tUser` VALUES (444, '', 'Martin', 'Dunčko', '', 'DunckoMartin', '9c021670e9c30ec2f2fbe4e199d5c29c', 'kB35uR', 1000000030, 1);
INSERT INTO `tUser` VALUES (445, '', 'Mikuláš', 'Florek', '', 'FlorekMikulas', '0f1b4c57c32297aed87b247c2449496c', 'KM5O5T', 1000000035, 1);
INSERT INTO `tUser` VALUES (446, '', 'Martin', 'Galla', '', 'GallaMartin', '8dc08ce2b8cc1bcdb707b12d2bc2e662', 'WJTVEz', 1000000040, 1);
INSERT INTO `tUser` VALUES (447, '', 'Michal', 'Heriban', '', 'HeribanMichal', '16b516af6b42d2f78a6bc92682733083', 'k49wz4', 1000000045, 1);
INSERT INTO `tUser` VALUES (448, '', 'Szabolcs', 'Horváth', '', 'HorvathSzabolcs', '0f2534345982d2bf507da615a738dba6', 'SM025V', 1000000050, 1);
INSERT INTO `tUser` VALUES (449, '', 'Roman', 'Hrušovský', '', 'HrusovskyRoman', 'd1348bdb1399ffbd5d2794159dedc1f6', '5fmW0G', 1000000055, 1);
INSERT INTO `tUser` VALUES (450, '', 'Tomáš', 'Jurík', '', 'JurikTomas', '374975ab8243e90e295ef1dd18ec8603', 'EKjzod', 1000000060, 1);
INSERT INTO `tUser` VALUES (451, '', 'Juraj', 'Kašiar', '', 'KasiarJuraj', 'a66b3168ce4089f582820ed59ebe1245', 'jbM4Wg', 1000000065, 1);
INSERT INTO `tUser` VALUES (452, '', 'Marián', 'Klempai', '', 'KlempaiMarian', 'd5bb2e3b364bd7d28e20b39862b95da0', 's8aqtz', 1000000070, 1);
INSERT INTO `tUser` VALUES (453, '', 'Jozef', 'Kopaničák', '', 'KopanicakJozef', 'c6a2ec10ce03f7c36fa296d28e320113', 'kbck48', 1000000075, 1);
INSERT INTO `tUser` VALUES (454, '', 'Boris', 'Kruľ', '', 'KrulBoris', '807aa22cbc8a4f56e42be68d12b3e223', '6XchKc', 1000000080, 1);
INSERT INTO `tUser` VALUES (455, '', 'Marek', 'Kurta', '', 'KurtaMarek', 'd2a032456c2e07c8ac9b0545d3da3b86', 'OeMXD2', 1000000085, 1);
INSERT INTO `tUser` VALUES (456, '', 'Kristína', 'Lidayová', '', 'LidayovaKristina', 'cf79cbbc6161f52a808f71bbf07467ee', '1M3DFO', 1000000090, 1);
INSERT INTO `tUser` VALUES (457, '', 'Ján', 'Majling', '', 'MajlingJan', '8371ac7ecc5d8ca9ae44e81409249235', 'JXLKe6', 1000000095, 1);
INSERT INTO `tUser` VALUES (458, '', 'Michal', 'Mlatiček', '', 'MlaticekMichal', '1b6a0b6dba329aff622c4ffceb937a28', '0p7czZ', 1000000100, 1);
INSERT INTO `tUser` VALUES (459, '', 'Gabriel', 'Németh', '', 'NemethGabriel', '87b6de6b012a1230578b4546387a87a1', '0uNbCn', 1000000105, 1);
INSERT INTO `tUser` VALUES (460, '', 'Michal', 'Pálka', '', 'PalkaMichal', '1ba31b87662fa44288faf3c0524e4271', 'egrQ4V', 1000000110, 1);
INSERT INTO `tUser` VALUES (461, '', 'Andrea', 'Porvazníková', '', 'PorvaznikovaAndrea', 'dde3deca9db09a23de0e97f080cdcba9', 'IUyAn5', 1000000115, 1);
INSERT INTO `tUser` VALUES (462, '', 'Marián', 'Rojko', '', 'RojkoMarian', '0b5d1f9752fcd46d3ea9c92794f97b21', 'fWSRxW', 1000000120, 1);
INSERT INTO `tUser` VALUES (463, '', 'Martin', 'Sárközi', '', 'SarkziMartin', 'cd19ed1173a571a6e185e686d0e14e5c', 'MwbJzB', 1000000125, 1);
INSERT INTO `tUser` VALUES (464, '', 'Jozef', 'Sudolský', '', 'SudolskyJozef', '3717d8a20603ce78812baebae93af3c6', 'zyVcAn', 1000000130, 1);
INSERT INTO `tUser` VALUES (465, '', 'Martin', 'Šabík', '', 'SabikMartin', '4d458bb3740f5c4bfef68d31da600b11', 'qEtIln', 1000000135, 1);
INSERT INTO `tUser` VALUES (466, '', 'Norbert', 'Špót', '', 'SpotNorbert', 'f92db1463e52c335abeae40403c234e2', 'tT8Sjk', 1000000140, 1);
INSERT INTO `tUser` VALUES (467, '', 'Slavomír', 'Takáč', '', 'TakacSlavomir', 'a506c5038b0d541e0a7217fa9032192a', 'Mp8u7u', 1000000145, 1);
INSERT INTO `tUser` VALUES (468, '', 'Peter', 'Veress', '', 'VeressPeter', '63ac9b09912775945bc3a5348ada584f', 'hJRjig', 1000000150, 1);
INSERT INTO `tUser` VALUES (469, '', 'Peter', 'Vlk', '', 'VlkPeter', '210602f6c376f2d6441a3c97b0a4ccb3', 'KIFwL6', 1000000155, 1);
INSERT INTO `tUser` VALUES (470, '', 'Andrej', 'Bankovich', '', 'BankovichAndrej', '812498aa704187fd15fecad754f28a26', 'J2z4zL', 1000700005, 1);
INSERT INTO `tUser` VALUES (471, '', 'Pavol', 'Bezák', '', 'BezakPavol', '2a7ea08aa26bf6469f5b3ad20268eb3c', 'hTueBE', 1000700010, 1);
INSERT INTO `tUser` VALUES (472, '', 'Peter', 'Dolník', '', 'DolnikPeter', 'a4851bc236325470a05238217f3ce326', 'pdTmyQ', 1000700015, 1);
INSERT INTO `tUser` VALUES (473, '', 'Peter', 'Galčík', '', 'GalcikPeter', 'f2cc219dc3c32d66d54be5f701940b9c', 'HGpoPy', 1000700020, 1);
INSERT INTO `tUser` VALUES (474, '', 'Jozef', 'Girmala', '', 'GirmalaJozef', '399cc348afca8fb3863553a5a4c6a529', 'vp81MI', 1000700025, 1);
INSERT INTO `tUser` VALUES (475, '', 'Juraj', 'Haviar', '', 'HaviarJuraj', '70e9343e2993b673b8e254640ee2594f', 'VlAlfZ', 1000700030, 1);
INSERT INTO `tUser` VALUES (476, '', 'Michal', 'Hrivnák', '', 'HrivnakMichal', '7a5a70faea36acf4c9ce869ab87514e8', 'WmJhra', 1000700035, 1);
INSERT INTO `tUser` VALUES (477, '', 'Pavol', 'Janiš', '', 'JanisPavol', '9509e6f5260f9917e25ca1ad2f42a09f', 'LGevSD', 1000700040, 1);
INSERT INTO `tUser` VALUES (478, '', 'Kristián', 'Kádaši', '', 'KadasiKristian', '51d26eff7dbf5fb34b48f2027a79c607', 'bq0rEO', 1000700045, 1);
INSERT INTO `tUser` VALUES (479, '', 'Adrián', 'Kollárik', '', 'KollarikAdrian', 'd6d6d7713e022b1e4a70885a68294510', 'P15NQG', 1000700050, 1);
INSERT INTO `tUser` VALUES (480, '', 'Ján', 'Kovács', '', 'KovacsJan', '11f84d669773a1b859d5b8f3391b349f', 'lBSMNY', 1000700055, 1);
INSERT INTO `tUser` VALUES (481, '', 'Ján', 'Kreps', '', 'KrepsJan', 'a7491033eae4410763848e16129ea8a4', 'BAbbHs', 1000700060, 1);
INSERT INTO `tUser` VALUES (482, '', 'Július', 'Kunský', '', 'KunskyJulius', '5a577c117e1a92da36026eb5df546911', 'ciZhDI', 1000700065, 1);
INSERT INTO `tUser` VALUES (483, '', 'Barbora', 'Macháčová', '', 'MachacovaBarbora', '94e3e96c68eaf64342f03b3761f9c390', 'KFYKWs', 1000700070, 1);
INSERT INTO `tUser` VALUES (484, '', 'Michal', 'Novomeský', '', 'NovomeskyMichal', '2665b01a873dd15b9137754f1188158d', 'pCikfZ', 1000700075, 1);
INSERT INTO `tUser` VALUES (485, '', 'Michal', 'Partika', '', 'PartikaMichal', 'b06b9bafd11b18df89dc6b8dfcdf38d5', 'Rrrz45', 1000700080, 1);
INSERT INTO `tUser` VALUES (486, '', 'Eliška', 'Pätoprstá', '', 'PatoprstaEliska', '0a974c6f04368aed590b47d6ebb5badd', 'ovuqw3', 1000700085, 1);
INSERT INTO `tUser` VALUES (487, '', 'Ján', 'Prosuch', '', 'ProsuchJan', '727b59c5ac2017af197607255edbeac2', 'IybyGE', 1000700090, 1);
INSERT INTO `tUser` VALUES (488, '', 'Michal', 'Stríženec', '', 'StrizenecMichal', 'ea1f6f29fcbdfe6d53708d9e3619b6b5', '7gaURW', 1000700095, 1);
INSERT INTO `tUser` VALUES (489, '', 'Radoslav', 'Škoviera', '', 'SkovieraRadoslav', '8084201a9e89aed7c75f5d45e20e245c', 'd7omgu', 1000700100, 1);
INSERT INTO `tUser` VALUES (490, '', 'Stanislav', 'Toth', '', 'TothStanislav', '441b37ca82558033736232243aa065a1', 'bXLsnE', 1000700105, 1);
INSERT INTO `tUser` VALUES (491, '', 'Daniel', 'Vančo', '', 'VancoDaniel', '38df6386df539b7f1de8755402f1628c', 'nBZISm', 1000700110, 1);
INSERT INTO `tUser` VALUES (492, '', 'Karol', 'Votava', '', 'VotavaKarol', '0e319cd15365bcf307e83b02e0eceeeb', 'ArLBPh', 1000700115, 1);
INSERT INTO `tUser` VALUES (493, '', 'Martin', 'Čajági', '', 'CajagiMartin', '1d23aa4573399369d0a466c5d4e5c472', '7Lo7v6', 1004900005, 1);
INSERT INTO `tUser` VALUES (494, '', 'Pavol', 'Fabo', '', 'FaboPavol', '1762cd8018a177ecbd11848a5eaf5fe3', 'Ty29L9', 1004900010, 1);
INSERT INTO `tUser` VALUES (495, '', 'Ondrej', 'Hrabovec', '', 'HrabovecOndrej', '614d97faec819ccb6e4583695850f064', 'sMV569', 1004900015, 1);
INSERT INTO `tUser` VALUES (496, '', 'Peter', 'Kuťák', '', 'KutakPeter', '712fbc378fcaa0922773c486cba1ae30', 'yiAoRi', 1004900020, 1);
INSERT INTO `tUser` VALUES (497, '', 'Marian', 'Maričák', '', 'MaricakMarian', '8f37d13a6e0b41761d46a9bdf23c9691', 'BizcJe', 1004900025, 1);
INSERT INTO `tUser` VALUES (498, '', 'Martin', 'Rejda', '', 'RejdaMartin', 'b48ba744227e36abfe78749731eec57a', 'kGQzDb', 1004900030, 1);
INSERT INTO `tUser` VALUES (499, '', 'Jozef', 'Švec', '', 'SvecJozef', 'b4e6af7bc36fbdbd511d7edc66db2f59', 'umAmlb', 1004900035, 1);
INSERT INTO `tUser` VALUES (500, '', 'Tib', 'Zimányi', '', 'ZimanyiTib', '6f0c71efca77e677a37763facb972c23', 'kDO7xJ', 1004900040, 1);
INSERT INTO `tUser` VALUES (501, '', 'Lukáš', 'Gaži', '', 'GaziLukas', '2c9e9457914041d9daf9d99fc05011c2', '5WSvbz', 1000002005, 1);
INSERT INTO `tUser` VALUES (502, '', 'Jakub', 'Kollár', '', 'KollarJakub', '6323290eba5627f645dff929b537e864', 'EDH4Gh', 1000002010, 1);
INSERT INTO `tUser` VALUES (503, '', 'Katarína', 'Sýsová', '', 'SysovaKatarina', 'f24806b533f232ba6e736735f4e0b6a5', '9QOOfh', 1000002015, 1);
INSERT INTO `tUser` VALUES (504, '', 'Karina', '﻿Arendášová', '', 'arendasovaKarina', '35c17b5288cb4e9cde006495e7e6bd9b', 'QAuhNF', 1000800001, 1);
INSERT INTO `tUser` VALUES (505, '', 'Martin', 'Gajdošík', '', 'GajdosikMartin', '3dbc69b441d9d894c1d935871fb9d1f0', 'iX0XTx', 1000800002, 1);
INSERT INTO `tUser` VALUES (506, '', 'Dušan', 'Giertl', '', 'GiertlDusan', '5d91a078076e7087d20a5c29bc10e711', 'wOkeal', 1000800003, 1);
INSERT INTO `tUser` VALUES (507, '', 'Marián', 'Grman', '', 'GrmanMarian', 'ad9901edb58520fd94ec3203de1da9d3', 'EEPcyl', 1000800004, 1);
INSERT INTO `tUser` VALUES (508, '', 'Katarína', 'Holičová', '', 'HolicovaKatarina', '091f7f6545e914073a89fd88cd9f177b', 'kw3Yb9', 1000800005, 1);
INSERT INTO `tUser` VALUES (509, '', 'Radana', 'Kollárová', '', 'KollarovaRadana', 'ed50878fded456ff5eabe31250951462', '7SyqZb', 1000800006, 1);
INSERT INTO `tUser` VALUES (510, '', 'Miroslav', 'Krupský', '', 'KrupskyMiroslav', '4242fd6bcfabec87f51eea3a795a4f97', 'W9ZVVJ', 1000800007, 1);
INSERT INTO `tUser` VALUES (511, '', 'Anton', 'Mišák', '', 'MisakAnton', 'c5f9393fc1abf142b05c75a15f32fa61', 'iinsnn', 1000800008, 1);
INSERT INTO `tUser` VALUES (512, '', 'Michal', 'Vrana', '', 'VranaMichal', '233db366e7c1e240911003e92bca23a9', 'ERRjTg', 1000800009, 1);
INSERT INTO `tUser` VALUES (513, '', 'Veronika', 'Čolláková', '', 'CollakovaVeronika', 'be23189bf8f5f7ba73bc6789b132217f', 'v5DnSE', 1000001005, 1);
INSERT INTO `tUser` VALUES (514, '', 'Ladislav', 'Fuchs', '', 'FuchsLadislav', 'ddd62b7ee01605f6d0e064f92aa9f0ec', 'lPnJ7d', 1000001010, 1);
INSERT INTO `tUser` VALUES (515, '', 'Jana', 'Halgašová', '', 'HalgasovaJana', '1bbf1abbf001831f6f98c2dfda6a7209', 'LSbAEX', 1000001015, 1);
INSERT INTO `tUser` VALUES (516, '', 'Maroš', 'Komadel', '', 'KomadelMaros', '94773d3719405b103f6bfcc877b6d932', '0N6n7i', 1000001020, 1);
INSERT INTO `tUser` VALUES (517, '', 'Martina', 'Lobotková', '', 'LobotkovaMartina', '9977beb16cbcf61df867aab395dc06e9', 'BA1iKK', 1000001025, 1);
INSERT INTO `tUser` VALUES (518, '', 'Ondrej', 'Melicher', '', 'MelicherOndrej', '065cfd953be2ff1309a8d6b1bf2bdd91', 'p6ESjn', 1000001030, 1);
INSERT INTO `tUser` VALUES (519, '', 'Michal', 'Palacka', '', 'PalackaMichal', '9e236dbea8c6baec2ebbf84d55e36c11', 'mu3A5Y', 1000001035, 1);
INSERT INTO `tUser` VALUES (520, '', 'Vladimír', 'Rychtárik', '', 'RychtarikVladimir', 'c43de68227529a4124b72ee7b9d46ac3', 'DFGF7b', 1000001040, 1);
INSERT INTO `tUser` VALUES (521, '', 'Martin', 'Svorad', '', 'SvoradMartin', '39b633ee0661d173220e554333ef093c', 't7OpjK', 1000001045, 1);
INSERT INTO `tUser` VALUES (522, '', 'Monika', 'Vaneková', '', 'VanekovaMonika', '8eae9429bbe8a9960ca1a1a697e4fe84', 'xKboTM', 1000001050, 1);
INSERT INTO `tUser` VALUES (523, '', 'Zdenka', 'Zubáčová', '', 'ZubacovaZdenka', 'ef796ea7e271ab6f24545d5f62bece8b', 'Y9ItQR', 1000001055, 1);
INSERT INTO `tUser` VALUES (524, '', 'Vladimír', 'Balla', '', 'BallaVladimir', '24880e87f9c750b0fe86910eeb8c6ac5', 'G4byt7', 1000900005, 1);
INSERT INTO `tUser` VALUES (525, '', 'Zuzana', 'Boušková', '', 'BouskovaZuzana', 'ede4af92059af0003beadff526131254', 'nXCUty', 1000900010, 1);
INSERT INTO `tUser` VALUES (526, '', 'Miroslava', 'Englmanová', '', 'EnglmanovaMiroslava', '5aa2c9e6974f51780e5ef8fcdd79925f', 'VMuz2E', 1000900015, 1);
INSERT INTO `tUser` VALUES (527, '', 'Stanislav', 'Grom', '', 'GromStanislav', '05a4f7eee66a68122f10c0d25223b229', 'apebDY', 1000900020, 1);
INSERT INTO `tUser` VALUES (528, '', 'Alena', 'Hrabovská', '', 'HrabovskaAlena', '1f5506908e356a79afe0a68b7cdd72c0', 'NsWmMD', 1000900025, 1);
INSERT INTO `tUser` VALUES (529, '', 'Vladislav', 'Kaššovic', '', 'KassovicVladislav', '91bbb08e1ffe083ec64d3d875e9f35da', '4iw6HQ', 1000900030, 1);
INSERT INTO `tUser` VALUES (530, '', 'Peter', 'Kudla', '', 'KudlaPeter', '693ff4496065697702cf1c9607e1cfbd', '2VEtFX', 1000900035, 1);
INSERT INTO `tUser` VALUES (531, '', 'Zuzana', 'Lukašíková', '', 'LukasikovaZuzana', '676ae52481218b4c5eadc525b7851701', 'SqzdQq', 1000900040, 1);
INSERT INTO `tUser` VALUES (532, '', 'Juraj', 'Sedlák', '', 'SedlakJuraj', '2e3764f9592034cce584f125b6b49eed', 'HQGMSa', 1000900045, 1);
INSERT INTO `tUser` VALUES (533, '', 'Marian', 'Šimko', '', 'SimkoMarian', 'e9547ae7442c3fd0bf4b9dd9984632d5', 'AwsnI5', 1000900050, 1);
INSERT INTO `tUser` VALUES (534, '', 'Andrea', 'Tinajová', '', 'TinajovaAndrea', '4005b71ecf3e0f0d147a2b17ba80837d', 'QBddxL', 1000900055, 1);
INSERT INTO `tUser` VALUES (535, '', 'Branislav', 'Danko', '', 'DankoBranislav', 'bf108a35e48210fa14ecd2daea0bd81d', 'TownI3', 1000400005, 1);
INSERT INTO `tUser` VALUES (536, '', 'Pavel', 'Gurecký', '', 'GureckyPavel', '7cb8145cafeb447c3b0a133f05cf28be', 'bqiAuZ', 1000400010, 1);
INSERT INTO `tUser` VALUES (537, '', 'Michal', 'Hlodák', '', 'HlodakMichal', '54d9bebdb15ca96193ca9e47212da7ce', 'R2GnDo', 1000400015, 1);
INSERT INTO `tUser` VALUES (538, '', 'Jakub', 'Imriška', '', 'ImriskaJakub', 'eb22f5bd8f8d682a57c7f88e4f8e0aa8', 'n5KGhj', 1000400020, 1);
INSERT INTO `tUser` VALUES (539, '', 'Katarína', 'Košianová', '', 'KosianovaKatarina', '5f488e6ac877dfa067b3f1e2cdae0a97', 'BYLF29', 1000400025, 1);
INSERT INTO `tUser` VALUES (540, '', 'Richard', 'Krumpolec', '', 'KrumpolecRichard', 'e3abd19c18b34abbcc85194a4964920a', 'gLmDZV', 1000400030, 1);
INSERT INTO `tUser` VALUES (541, '', 'Veronika', 'Medvecká', '', 'MedveckaVeronika', 'ea6ae2001ca538da0d574f0dc9fe8084', 'v1bErv', 1000400035, 1);
INSERT INTO `tUser` VALUES (542, '', 'Andrej', 'Novotný', '', 'NovotnyAndrej', '544698a4d67b8a5998aca702037255f2', 't9nZmR', 1000400040, 1);
INSERT INTO `tUser` VALUES (543, '', 'František', 'Puškár', '', 'PuskarFrantisek', 'c7c1cefde6fa2c0573bae0912eac533d', 'eAMP7T', 1000400045, 1);
INSERT INTO `tUser` VALUES (544, '', 'Pavol', 'Stajanča', '', 'StajancaPavol', '14f5000b26b634e384ebe6c7587e6519', 'YyIz4A', 1000400050, 1);
INSERT INTO `tUser` VALUES (545, '', 'Lukáš', 'Tomek', '', 'TomekLukas', 'a9a819a3fd694a5371a63d18d38f3d34', 'xabKD2', 1000400055, 1);
INSERT INTO `tUser` VALUES (546, '', 'Pavel', 'Vnučko', '', 'VnuckoPavel', 'e41e438055da788e765b30de00031ec4', 'vZRxu0', 1000400060, 1);
INSERT INTO `tUser` VALUES (547, '', 'Lívia', 'Bresťáková', '', 'BrestakovaLivia', '3b027202b6d6c1d872edb19e7dd92ca1', 'TO87Ek', 1001700005, 1);
INSERT INTO `tUser` VALUES (548, '', 'Zuzana', 'Fischerová', '', 'FischerovaZuzana', 'abab2977a0076190660d4254fe1705cc', 'OIKqoG', 1001700010, 1);
INSERT INTO `tUser` VALUES (549, '', 'Ivana', 'Hrebíková', '', 'HrebikovaIvana', '0c46ec80a8005f08880f7490aaf77336', 'ac6ICY', 1001700015, 1);
INSERT INTO `tUser` VALUES (550, '', 'Gábor', 'Kiss', '', 'KissGabor', '25859c5e615cd144d3873c9e9b265b2e', '91YaAs', 1001700020, 1);
INSERT INTO `tUser` VALUES (551, '', 'Marek', 'Mikuš', '', 'MikusMarek', '933f5d28c6e0b566701090214eb1637a', '2WiJjC', 1001700025, 1);
INSERT INTO `tUser` VALUES (552, '', 'Iveta', 'Pavlova', '', 'PavlovaIveta', '904e2c8a2a24b8c680d4531eab11137e', 'I3hGZL', 1001700030, 1);
INSERT INTO `tUser` VALUES (553, '', 'Luciano', 'Rossi', '', 'RossiLuciano', 'efdb89db6ed7d18980982b4ae59666b6', 'QEkqUy', 1001700035, 1);
INSERT INTO `tUser` VALUES (554, '', 'Alena', 'Bujnová', '', 'BujnovaAlena', '29fd261deb23f870be5f8d2e3b0f372d', 'XUBSt5', 1004100005, 1);
INSERT INTO `tUser` VALUES (555, '', 'Ervín', 'Gürtler', '', 'GrtlerErvin', '45d63306564ea52e79dbe543c46469b2', 'HsUvsl', 1004100010, 1);
INSERT INTO `tUser` VALUES (556, '', 'Liliana', 'Hromadová', '', 'HromadovaLiliana', '839c25f3c93099c6e6c32c0ec07fd99b', 'Oj9WTh', 1004100015, 1);
INSERT INTO `tUser` VALUES (557, '', 'Lucia', 'Komendová', '', 'KomendovaLucia', 'c141b6bfa939f466fd5295cced64a48b', 'prawY1', 1004100020, 1);
INSERT INTO `tUser` VALUES (558, '', 'Jana', 'Kubincová', '', 'KubincovaJana', 'f5cc4f62d0513662cf5457b51c88e38a', '8EuiVe', 1004100025, 1);
INSERT INTO `tUser` VALUES (559, '', 'Lucia', 'Marťáková', '', 'MartakovaLucia', '86436595c0b01a5b3213e2f0cfb06746', 'GJZ9sj', 1004100030, 1);
INSERT INTO `tUser` VALUES (560, '', 'Ján', 'Páleník', '', 'PalenikJan', 'b80b2ea7fe44444b5b6b81e4b9aa3d15', '3ZBNkT', 1004100035, 1);
INSERT INTO `tUser` VALUES (561, '', 'Jozef', 'Sivek', '', 'SivekJozef', '07b9582bace60a9621eb79537b0d8777', 'ZZ4XLN', 1004100040, 1);
INSERT INTO `tUser` VALUES (562, '', 'Jakub', 'Šoltýs', '', 'SoltysJakub', '3a80cdd5e4b3e4597fa646aaa6d10283', '6256nS', 1004100045, 1);
INSERT INTO `tUser` VALUES (564, '', 'Viliam', 'Dillinger', '', 'DillingerViliam', '821b7c48d4716a9088cbda511160378f', 'l1HbZZ', 1000500010, 1);
INSERT INTO `tUser` VALUES (565, '', 'František', 'Ďuriš', '', 'DurisFrantisek', '21765f26c623dc7036949b0a105a373f', 'kRPMv1', 1000500015, 1);
INSERT INTO `tUser` VALUES (566, '', 'Peter', 'Hajdú', '', 'HajduPeter', '05cb8dc325b6feb7a768887fdd423525', 'vlPp9r', 1000500020, 1);
INSERT INTO `tUser` VALUES (567, '', 'Ján', 'Hlinčík', '', 'HlincikJan', '533c5bff529aa0f95191b2b55f60fe84', '34iXZw', 1000500025, 1);
INSERT INTO `tUser` VALUES (568, '', 'Michal', 'Kliment', '', 'KlimentMichal', '2e54107a288bf69e6979d9fadac8081f', 'GMHTS2', 1000500030, 1);
INSERT INTO `tUser` VALUES (569, '', 'Michal', 'Kováč', '', 'KovacMichal', '327ba924ade533fd14fe4c1d256db178', 'S5Sq6H', 1000500035, 1);
INSERT INTO `tUser` VALUES (570, '', 'Erik', 'Majsai', '', 'MajsaiErik', 'b13180bb039e21d4fd6b6b3a13fc418e', 'ggpVSK', 1000500040, 1);
INSERT INTO `tUser` VALUES (571, '', 'Marika', 'Mitrengová', '', 'MitrengovaMarika', '3bf143033c625f05f0c62956ec574b2f', 'LeVquU', 1000500045, 1);
INSERT INTO `tUser` VALUES (572, '', 'Pavol', 'Panák', '', 'PanakPavol', '07525ff5821c89782baab6065098d386', 'InOQaD', 1000500050, 1);
INSERT INTO `tUser` VALUES (573, '', 'Juraj', 'Popovič', '', 'PopovicJuraj', 'c50c7fda801e0f7df6abfffbc7fb6bae', 'dGfKqY', 1000500055, 1);
INSERT INTO `tUser` VALUES (574, '', 'Monika', 'Satúryová', '', 'SaturyovaMonika', '7c07aa8e20cad73639e4658a23a16e1f', 'C9TkpO', 1000500060, 1);
INSERT INTO `tUser` VALUES (575, '', 'Róbert', 'Vaško', '', 'VaskoRobert', 'bc60ca549c830940e2ea5c5c88080db1', 'SvV8gE', 1000500065, 1);
INSERT INTO `tUser` VALUES (576, '', 'Stanislav', 'Buštor', '', 'BustorStanislav', 'b9272d14d24fc02d4678390188fc86ad', 'ISIu03', 1002700005, 1);
INSERT INTO `tUser` VALUES (577, '', 'Hubert', 'Hargaš', '', 'HargasHubert', '14fd5b91d343f05c488e663de07c88e0', 'eHfSog', 1002700010, 1);
INSERT INTO `tUser` VALUES (578, '', 'Matej', 'Juračka', '', 'JurackaMatej', '7869c907163524a27ec12e7d5a4f5706', 'mrNs35', 1002700015, 1);
INSERT INTO `tUser` VALUES (579, '', 'Jozef', 'Králik', '', 'KralikJozef', '25cf0cf52edb82adf4fb7798e15b3643', 'hu41Fi', 1002700020, 1);
INSERT INTO `tUser` VALUES (580, '', 'Martin', 'Madaras', '', 'MadarasMartin', 'af9b287ecc86a88679d670102423a9e8', 'FnDrlK', 1002700025, 1);
INSERT INTO `tUser` VALUES (581, '', 'Jozef', 'Očkay', '', 'OckayJozef', 'be07e8879174c77e468ec7990e7adb7c', 'VTstdr', 1002700030, 1);
INSERT INTO `tUser` VALUES (582, '', 'Rudolf', 'Starovský', '', 'StarovskyRudolf', 'dd1a429b84a231cc0205de2d37d186dc', 'miZs2d', 1002700035, 1);
INSERT INTO `tUser` VALUES (583, '', 'Martin', 'Vlčák', '', 'VlcakMartin', 'bb1a75c22ba3790cfeac00e2eaa0534c', 'zeucwm', 1002700040, 1);
INSERT INTO `tUser` VALUES (584, '', 'Pavol', 'Beluško', '', 'BeluskoPavol', '8115730af6bef942a2f17b2fc0d8a01d', '8EH1ud', 1006200005, 1);
INSERT INTO `tUser` VALUES (585, '', 'František', 'Dulovič', '', 'DulovicFrantisek', 'd9181e44b04d964d2106d500020af9ec', '91qBhC', 1006200010, 1);
INSERT INTO `tUser` VALUES (586, '', 'Peter', 'Glaus', '', 'GlausPeter', 'a44f08cc7c8194e3bf57971fccad9b6f', 'c3lump', 1006200015, 1);
INSERT INTO `tUser` VALUES (587, '', 'Jana', 'Hlinková', '', 'HlinkovaJana', '9e5bbd1d41a8d3965245e577c15237f9', 'MzyBSp', 1006200020, 1);
INSERT INTO `tUser` VALUES (588, '', 'Michal', 'Kevický', '', 'KevickyMichal', '5e4c3fb9b12bbbf23a4ca25d70d9a731', 'EhtZkQ', 1006200025, 1);
INSERT INTO `tUser` VALUES (589, '', 'Mariana', 'Kuchyňárová', '', 'KuchynarovaMariana', '42a8cbf8f6c173d244600291e9c93882', 'bhlJ8G', 1006200030, 1);
INSERT INTO `tUser` VALUES (590, '', 'Miroslav', 'Mahdoň', '', 'MahdonMiroslav', '9e36ef5b5ed3246d4703151ebc98dda5', 'M6w4xE', 1006200035, 1);
INSERT INTO `tUser` VALUES (591, '', 'Juraj', 'Porubský', '', 'PorubskyJuraj', 'c473d37105e654e514b54257df86ed13', 'vzwHUJ', 1006200040, 1);
INSERT INTO `tUser` VALUES (592, '', 'Zuzana', 'Sekerková', '', 'SekerkovaZuzana', 'e518a73ea84e903cb147a0e595d4f899', 'Wx0lYR', 1006200045, 1);
INSERT INTO `tUser` VALUES (593, '', 'František', 'Šmitala', '', 'SmitalaFrantisek', 'b3d35b4da939209f4dea3d7a176434c9', 'AtZUi0', 1006200050, 1);
INSERT INTO `tUser` VALUES (594, '', 'Martin', 'Roško', '', 'RoskoMartin', '76bbdcafcf7c8acbcb6d6cfe7cf16eb7', 'BjhMSf', 1006200055, 1);
INSERT INTO `tUser` VALUES (595, '', 'Ondrej', 'Budáč', '', 'BudacOndrej', '1f765cb4bea1036e34e87a70b63617c6', 'juaFoy', 1000600005, 1);
INSERT INTO `tUser` VALUES (596, '', 'Viera', 'Hamarová', '', 'HamarovaViera', '62f7846e3441fef5a4e2bfe20db3f103', '0JYwgJ', 1000600010, 1);
INSERT INTO `tUser` VALUES (597, '', 'Alena', 'Hrušková', '', 'HruskovaAlena', 'dcbfe80927a4498930ea3c1a43da3cab', '7476eU', 1000600015, 1);
INSERT INTO `tUser` VALUES (598, '', 'Kristína', 'Kováčiková', '', 'KovacikovaKristina', '07f74e2c0c59a8d72d357cd5ccc23b29', 'MFdCql', 1000600020, 1);
INSERT INTO `tUser` VALUES (599, '', 'Lenka', 'Kyselová', '', 'KyselovaLenka', 'b25aa435a59e7b6bd4e906a9e25e2025', 'BSvJve', 1000600025, 1);
INSERT INTO `tUser` VALUES (600, '', 'Juraj', 'Majer', '', 'MajerJuraj', 'ee43e53d30fb6c74a3ca0f96e12d49c0', 'OEzP0N', 1000600030, 1);
INSERT INTO `tUser` VALUES (601, '', 'Tomáš', 'Miartuš', '', 'MiartusTomas', 'a9415c3a9f646df57e9e830c274f6dfe', 'd0m3wt', 1000600035, 1);
INSERT INTO `tUser` VALUES (602, '', 'Július', 'Pačuta', '', 'PacutaJulius', '532db28d5fa04c8f8a512d4748352e2f', 'Bsmxor', 1000600040, 1);
INSERT INTO `tUser` VALUES (603, '', 'Veronika', 'Piterková', '', 'PiterkovaVeronika', 'f96d1254c8ef66103d02d2245256fa04', 'i2Wltd', 1000600045, 1);
INSERT INTO `tUser` VALUES (604, '', 'Andrej', 'Slašťan', '', 'SlastanAndrej', '807c38f0dcfed7eab382f6161127682a', 'xVVSug', 1000600050, 1);
INSERT INTO `tUser` VALUES (605, '', 'Katarína', 'Škrovinová', '', 'SkrovinovaKatarina', '3f5ee426fac5901defc39eb9df27b755', 'W9KlNK', 1000600055, 1);
INSERT INTO `tUser` VALUES (606, '', 'Michal', 'Takács', '', 'TakacsMichal', 'd69c483e840d772309a88833d013f927', 'ZRKbK7', 1000600060, 1);
INSERT INTO `tUser` VALUES (607, '', 'Michaela', 'Vallová', '', 'VallovaMichaela', '7f54b3f17c8f59f8e53dc00bb4bf436e', 'ubpHyD', 1000600065, 1);
INSERT INTO `tUser` VALUES (608, '', 'Pavel', 'Zábudlý', '', 'ZabudlyPavel', 'df0c309fd2600bd06af513aeca34f981', 'YGuKSO', 1000600070, 1);
INSERT INTO `tUser` VALUES (609, '', 'Lucia', 'Cáková', '', 'CakovaLucia', '95fa59c8f5dec7b6b89dfe5cf65fecb6', 'OfzzYT', 1003700005, 1);
INSERT INTO `tUser` VALUES (610, '', 'Barbora', 'Gallusová', '', 'GallusovaBarbora', '36d4c9a3297f9080af449fc691b325a1', 'GLSgXw', 1003700010, 1);
INSERT INTO `tUser` VALUES (611, '', 'Tomáš', 'Janík', '', 'JanikTomas', '02096ba2ce541a64201fbdf2d54a65f3', 'RMerNO', 1003700015, 1);
INSERT INTO `tUser` VALUES (612, '', 'Veronika', 'Lacková', '', 'LackovaVeronika', 'fba63fd04d190370eed9a8823a58a4c5', 'n9PDFe', 1003700020, 1);
INSERT INTO `tUser` VALUES (613, '', 'Lenka', 'Mezeiová', '', 'MezeiovaLenka', '33fa9c70dad59fad3b16ce77ef0c377b', '8tLr5u', 1003700025, 1);
INSERT INTO `tUser` VALUES (614, '', 'Lukáš', 'Riško', '', 'RiskoLukas', 'e4eb5d6b186e5e44626dc4de7456310c', '7IAv9o', 1003700030, 1);
INSERT INTO `tUser` VALUES (615, '', 'Moni', 'Trenčanová', '', 'TrencanovaMoni', '49ba852299bc7eb63318f06dfa3aef5a', 'fEZXLN', 1003700035, 1);
INSERT INTO `tUser` VALUES (616, '', 'Jana', 'Dzuráková', '', 'DzurakovaJana', '7b28fc296ab6e1b2c955a031a3781e12', 'kspoJ3', 1006710005, 1);
INSERT INTO `tUser` VALUES (617, '', 'Mária', 'Gáborová', '', 'GaborovaMaria', 'b1219e58733d9b5186aed2eab988d02b', '3X2Irw', 1006710010, 1);
INSERT INTO `tUser` VALUES (618, '', 'Gabriel', 'Hreha-Hrej', '', 'Hreha-hrejGabriel', 'f61575ec4c53dd1cc33de38e4b1d9d7f', 'NoQoGL', 1006710015, 1);
INSERT INTO `tUser` VALUES (619, '', 'Katarína', 'Kováčová', '', 'KovacovaKatarina', '6695844e6117d55cd33b56e5539ef999', 'ICk0Xi', 1006710020, 1);
INSERT INTO `tUser` VALUES (620, '', 'Sámuel', 'Peres', '', 'PeresSamuel', '2928140bfc319105b87901c8c6fd161d', 'n3NdQo', 1006710025, 1);
INSERT INTO `tUser` VALUES (621, '', 'Michal', 'Šoltés', '', 'SoltesMichal', 'b5a3b59b87d6e592a5c647f07d716da5', 'Q1G6fg', 1006710030, 1);
INSERT INTO `tUser` VALUES (622, '', 'Zuza', 'Žiaková', '', 'ZiakovaZuza', '0197be9fa35ad263f0cf69459d0c08a0', 'Y84QGl', 1006710035, 1);
INSERT INTO `tUser` VALUES (623, '', 'Vladimír', 'Balla', '', 'BallaVladimir2', '7daa7cf2b11a1d918b7cf07a344b1f3c', 'Vqd6ac', 1000900005, 1);
INSERT INTO `tUser` VALUES (624, '', 'Andrej', 'Borsuk', '', 'BorsukAndrej', '16c64e82bdcf5e8ed4f4c62ba200eed3', 'qQnEzC', 1000500005, 1);
