-- phpMyAdmin SQL Dump
-- version 2.9.1.1
-- http://www.phpmyadmin.net
-- 
-- Počítač: localhost:3306
-- Vygenerováno: Středa 12. března 2008, 15:16
-- Verze MySQL: 4.0.24
-- Verze PHP: 5.2.2
-- 
-- Databáze: `kiv`
-- 

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

-- 
-- Struktura tabulky `aktivity`
-- 

CREATE TABLE `aktivity` (
  `id` int(11) NOT NULL auto_increment,
  `osoba` int(11) NOT NULL default '0',
  `nazevCZ` varchar(255) default NULL,
  `nazevEN` varchar(255) default NULL,
  `popisCZ` text,
  `popisEN` text,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=114 ;

-- 
-- Vypisuji data pro tabulku `aktivity`
-- 

INSERT INTO `aktivity` (`id`, `osoba`, `nazevCZ`, `nazevEN`, `popisCZ`, `popisEN`) VALUES 
(2, 1, 'Spr?vce katedr?ln?ho WWW', 'Departmental webmaster', '', ''),
(3, 9, '?len fakultn? a univerzitn? komise pro zvy?ov?n? kvality v?uky.', 'Member of the faculty and university board for quality assurance in higher education.', 'P?ipravuji plo?nou p??pravu, sb?r a vyhodnocen? dotazn?k? vypl?ovan?ch studenty o kvalit? v?uky na cel? Z?U.', ''),
(106, 50, '?kolitel ACM Mezin?rodn? sout?e v kolektivn?m programov?n? ( od r.1997)', 'Faculty Advisor ACM International Collegiate Programming Contest', '', '');

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

-- 
-- Struktura tabulky `dp`
-- 

CREATE TABLE `dp` (
  `id` int(11) NOT NULL auto_increment,
  `rok` varchar(16) default NULL,
  `zamereni` int(11) default NULL,
  `nazevCZ` varchar(255) default NULL,
  `nazevEN` varchar(255) default NULL,
  `popisCZ` text,
  `popisEN` text,
  `diplomant` varchar(128) default NULL,
  `garant` varchar(128) default NULL,
  `disertacni` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=576 ;

-- 
-- Vypisuji data pro tabulku `dp`
-- 

INSERT INTO `dp` (`id`, `rok`, `zamereni`, `nazevCZ`, `nazevEN`, `popisCZ`, `popisEN`, `diplomant`, `garant`, `disertacni`) VALUES 
(4, '2000', 1, 'Vytvo?en? webovsk? aplikace pro dynamick? udr?ov?n? informac? o ECTS', 'The development of web application for dynamic maintenance of information about ECTS', NULL, NULL, 'Vladim?r Kraus', 'Dr. Ing. Jana Kle?kov?', 0),
(8, '2000', 5, 'Speci?ln? metody komprese sn?mk?', 'Special methods of image compression', NULL, NULL, 'Josef N?me?ek', 'Ing. Pavel Mautner, Ph.D.', 0),
(5, '2000', 1, 'Vytvo?en? webovsk? aplikace pro dynamick? udr?ov?n? informac? o mo?nostech ubytov?n? student? a mo?nostech brig?d pro studenty', 'Creating a web application for dynamic maintenance of information about student  accommodation and student voluntary work facilities', NULL, NULL, 'Jan Valenta', 'Dr. Ing. Jana Kle?kov?', 0),
(575, '2007', 1, 'Vyhled?v?n? vlastn?ch jmen v textu', 'Searching of Proper Names in Text Documents', NULL, NULL, 'Lalinsk? Ji??', 'Doc. Ing. Karel Je?ek, CSc. - Z?U, FAV, KIV', 0);

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

-- 
-- Struktura tabulky `jkurc_obory`
-- 

CREATE TABLE `jkurc_obory` (
  `id_obor` int(11) NOT NULL auto_increment,
  `obor_zkratka` varchar(50) default NULL,
  `obor_nazev_typu` varchar(100) default NULL,
  PRIMARY KEY  (`id_obor`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;

-- 
-- Vypisuji data pro tabulku `jkurc_obory`
-- 

INSERT INTO `jkurc_obory` (`id_obor`, `obor_zkratka`, `obor_nazev_typu`) VALUES 
(1, 'SWI', 'Softwarov? in?en?rstv?'),
(2, 'DSP', 'Distribuovan? syst?my  a po??ta?ov? s?t?'),
(3, 'IPS', 'Inteligentn? po??ta?ov? syst?my'),
(4, 'PGS', 'Po??ta?ov? grafika a v?po?etn? syst?my'),
(5, 'HW', '??slicov? syst?my'),
(6, 'bc-INF', 'Informatika (Bc)'),
(7, 'bc-VT', 'V?po?etn? technika (Bc)'),
(8, 'FI', 'Finan?n? informatika'),
(10, ' n/a', 'Ostatn? / Nespecifikov?no');

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

-- 
-- Struktura tabulky `jkurc_temata`
-- 

CREATE TABLE `jkurc_temata` (
  `id_tema` int(11) NOT NULL auto_increment,
  `id_zadavatel` int(11) default NULL,
  `je_externi` int(1) NOT NULL default '0',
  `ext_vedouci` varchar(255) NOT NULL default '',
  `nazev` varchar(100) NOT NULL default '0',
  `id_typ_prace` int(11) NOT NULL default '0',
  `popis_prace` text NOT NULL,
  `url` varchar(255) NOT NULL default '',
  `datum_vypsani` date NOT NULL default '0000-00-00',
  `datum_aktualizace` date NOT NULL default '0000-00-00',
  `datum_zverejneni` date NOT NULL default '0000-00-00',
  `komu_zadano` varchar(50) NOT NULL default '',
  `datum_dokonceno` date NOT NULL default '0000-00-00',
  `pro_akad_rok` varchar(9) default NULL,
  `id_obor` int(11) NOT NULL default '0',
  `datum_rezervace` date NOT NULL default '0000-00-00',
  `komu_zadano_oscislo` varchar(8) NOT NULL default '',
  `komu_zadano_email` varchar(40) NOT NULL default '',
  `je_prideleno` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id_tema`)
) TYPE=MyISAM AUTO_INCREMENT=1195 ;

-- 
-- Vypisuji data pro tabulku `jkurc_temata`
-- 

INSERT INTO `jkurc_temata` (`id_tema`, `id_zadavatel`, `je_externi`, `ext_vedouci`, `nazev`, `id_typ_prace`, `popis_prace`, `url`, `datum_vypsani`, `datum_aktualizace`, `datum_zverejneni`, `komu_zadano`, `datum_dokonceno`, `pro_akad_rok`, `id_obor`, `datum_rezervace`, `komu_zadano_oscislo`, `komu_zadano_email`, `je_prideleno`) VALUES 
(883, 28, 0, '', 'Simula?n? modely vestav?n?ch po??ta?ov?ch syst?m?', 3, '', '', '2007-04-10', '2007-05-02', '2007-04-10', 'H?ka Petr	', '0000-00-00', '2007/2008', 7, '0000-00-00', 'A05055	', 'p_haka@post.cz	', 1),
(884, 28, 0, '', 'Paralelizace v?po?tu fyzik?ln?ch pol?', 3, '', '', '2007-04-10', '2007-04-10', '2007-04-10', '', '0000-00-00', '2007/2008', 7, '0000-00-00', '', '', 0),
(1185, 23, 0, '', 'Finan?n? anal?za vod?rensk?ch spole?nost?', 3, '', 'http://www.kiv.zcu.cz/~novyp/dip/dip.html', '2008-02-12', '2008-02-12', '2008-02-12', 'Lucie Viktorov?', '0000-00-00', '2007/2008', 8, '0000-00-00', 'A05326', 'lucie.viktorova@seznam.cz', 1),
(1186, 1, 0, '', 'Roz???en? pro Eclipse - popis', 5, 'N?vod jak ps?t Eclipse plugins - dopln?n? a roz???en? info od P.Cvr?ka', 'http://www.kiv.zcu.cz/~brada/vyuka/dipl/', '2008-02-15', '2008-02-15', '2008-02-15', 'Zden?k ??ma', '0000-00-00', '2007/2008', 1, '0000-00-00', 'a', 'simazd@click.cz', 1);

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

-- 
-- Struktura tabulky `jkurc_typy`
-- 

CREATE TABLE `jkurc_typy` (
  `id_typ_prace` int(11) NOT NULL auto_increment,
  `zkratka` varchar(50) default NULL,
  `nazev_typu` varchar(100) default NULL,
  PRIMARY KEY  (`id_typ_prace`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

-- 
-- Vypisuji data pro tabulku `jkurc_typy`
-- 

INSERT INTO `jkurc_typy` (`id_typ_prace`, `zkratka`, `nazev_typu`) VALUES 
(1, 'BP', 'Bakal??sk? pr?ce'),
(2, 'DP', 'Diplomov? pr?ce'),
(3, 'PRJ5', 'Projekt 5'),
(5, 'OP', 'Oborov? projekt');

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

-- 
-- Struktura tabulky `osoby`
-- 

CREATE TABLE `osoby` (
  `id` int(11) NOT NULL auto_increment,
  `email` varchar(128) NOT NULL default '',
  `prefix` varchar(64) default NULL,
  `jmeno` varchar(64) default NULL,
  `prijmeni` varchar(64) default NULL,
  `postfix` varchar(64) default NULL,
  `titulCZ` varchar(128) default NULL,
  `titulEN` varchar(128) default NULL,
  `heslo` varchar(32) NOT NULL default '',
  `SMSemail` varchar(128) default NULL,
  `telefon` varchar(64) default NULL,
  `kancelar` varchar(64) default NULL,
  `www_odkaz` varchar(255) default NULL,
  `textCZ` text,
  `textEN` text,
  `uredni_hodiny` varchar(255) default NULL,
  `skupina` int(11) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=164 ;

-- 
-- Vypisuji data pro tabulku `osoby`
-- 

INSERT INTO `osoby` (`id`, `email`, `prefix`, `jmeno`, `prijmeni`, `postfix`, `titulCZ`, `titulEN`, `heslo`, `SMSemail`, `telefon`, `kancelar`, `www_odkaz`, `textCZ`, `textEN`, `uredni_hodiny`, `skupina`) VALUES 
(1, 'brada@kiv.zcu.cz', 'Ing.', 'P?emysl', 'Brada', 'MSc., Ph.D.', 'odborn? asistent', 'lecturer', 'NoNzvMyP0B54E', '', '+420 37763 2435', 'UK409', 'http://www.kiv.zcu.cz/~brada/', 'Po absolvov?n? Fakulty aplikovan?ch v?d Z?U v Plzni (1993) d?le studoval na univerzit? v Sheffieldu (Velk? Brit?nie), kde z?skal titul MSc. v oboru Software engineering se zvl?tn?m ocen?n?m za vynikaj?c? v?sledky studia. Doktorsk? titul v oblasti verzov?n? pro komponentov?-orientovan? syst?my z?skal v r.2004 na MFF UK Praha.\r\n\r\nPracuje jako odborn? asistent na kated?e informatiky a v?po?etn? techniky Z?U, kde p?edn?? p?edm?ty Pokro?il? softwarov? in?en?rstv? a Programov?n? Internetov?ch aplikac? a pod?l? se na v?uce dal??ch p?edm?t?. Pracuje ve strategick?m t?mu Fakulty aplikovan?ch v?d, je ?lenem Akademick?ho sen?tu Fakulty aplikovan?ch v?d, ?lenem komise pro st?tn? z?v?re?n? zkou?ky a rigor?zn? zkou?ky v oboru Informatika a v?po?etn? technika na Z?U. Je tak? spr?vcem informa?n?ho WWW serveru katedry.', 'Mr. Brada graduated from the Faculty of Applied Sciences, University of West Bohemia, in 1993. After that, he studied the\r\nAdvanced Software Engineering MSc. course at the University of Sheffield, UK, which he finished with Distinction in\r\n1995.  In 2003 finished PhD studies at the Charles University,\r\nPrague, in the field of versioning for component-oriented systems.\r\n\r\nAt present, he works as lecturer at the Department of Computer Science, University of West Bohemia in Pilsen, lecturing courses in Advanced Software Engineering and Programming Internet applications. Mr. Brada is a member of the departmental board for final examination in the study branch Computer Science\r\nand Engineering, and works as a member of the team for Faculty of Applied Sciences strategic planning. He is also the maintainer of the departmental WWW\r\nserver. ', 'st 14-15, ?t 11-12', 1),
(2, 'bokr@kiv.zcu.cz', 'Doc. Ing.', 'Josef', 'Bokr', 'CSc.', 'docent', 'senior lecturer', '', '', '+420 377632459', 'UK425', '', '', '', '', 3),
(4, 'kindlova@kiv.zcu.cz', '', 'Svatava', 'Kindlov?', '', '', '', 'No0DfGlTRfoJk', '', '+420 377632462, 377632401', 'UK419', '', '', '', '', 8),
(147, 'jhynek@kiv.zcu.cz', 'Ing.', 'Ji??', 'Hynek', 'Ph.D.', 'odborn? asistent', 'lecturer', '', '+420 603492837', '+420 377632455', 'UU407a', 'http://textmining.zcu.cz/', '', '', 'ST 13:00-14:00', 1);

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

-- 
-- Struktura tabulky `predmety`
-- 

CREATE TABLE `predmety` (
  `id` int(11) NOT NULL auto_increment,
  `osoba` int(11) NOT NULL default '0',
  `katedra` varchar(8) default NULL,
  `zkratka` varchar(8) default NULL,
  `nazev` varchar(255) default NULL,
  `www_odkaz` varchar(255) default NULL,
  `rok` varchar(16) default NULL,
  `semestr` char(2) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=254 ;

-- 
-- Vypisuji data pro tabulku `predmety`
-- 

INSERT INTO `predmety` (`id`, `osoba`, `katedra`, `zkratka`, `nazev`, `www_odkaz`, `rok`, `semestr`) VALUES 
(1, 1, 'KIV', 'ASWI', 'Pokro?il? softwarov? in?en?rstv?', 'http://moje.zcu.cz/wps/portal/predmety/kiv/aswi', '2005', NULL),
(4, 9, 'KIV', 'OOP', 'Objektov? orientovan? programov?n?', 'http://www.kiv.zcu.cz/~herout/vyuka/oop/index.html', '', NULL),
(5, 9, 'KIV', 'PPA1', 'Po??ta?e a programov?n? 1', 'http://www.kiv.zcu.cz/~netrvalo/vyuka/ppa1/index.html', '', NULL),
(13, 50, 'KIV', 'PPA1', 'Po??ta?e a programov?n? 1 - semin??e', 'http://www.kiv.zcu.cz/~netrvalo/vyuka.html', '2001', NULL),
(253, 150, 'KIV', 'ZIT', 'Z?klady informa?n?ch technologi?', 'http://amos.fav.zcu.cz/zit/', '2008', NULL);

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

-- 
-- Struktura tabulky `publikace`
-- 

CREATE TABLE `publikace` (
  `id` int(11) NOT NULL auto_increment,
  `osoba` int(11) NOT NULL default '0',
  `nazev` varchar(255) default NULL,
  `isbn` varchar(32) default NULL,
  `sbornik` varchar(255) default NULL,
  `autor` varchar(255) default NULL,
  `vydavatel` varchar(255) default NULL,
  `rok` varchar(16) default NULL,
  `www_odkaz` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=276 ;

-- 
-- Vypisuji data pro tabulku `publikace`
-- 

INSERT INTO `publikace` (`id`, `osoba`, `nazev`, `isbn`, `sbornik`, `autor`, `vydavatel`, `rok`, `www_odkaz`) VALUES 
(232, 1, 'Automated generating of OSGi component versions', '', 'Proceedings of ECI 2006', 'Luk? Valenta, P?emysl Brada, MSc', '', '2006', 'http://www.kiv.zcu.cz/~brada/research/'),
(213, 129, 'Simulation of Human Body Thermoregulation', '80-86840-21-2', 'Proceedings of MOSIS 2006, pp 123-128', 'H?jkov?, J., ?a?ek, M., Herout, P.', 'MARQ, Ostrava', '', ''),
(3, 9, 'U?ebnice jazyka Java', '80-7232-115-3', '', 'Herout, P.', 'nakladatelstv? KOPP, ?esk? Bud?jovice', '2000', 'http://proteus.fav.zcu.cz/~herout/java/ujj1/index.html'),
(274, 136, 'Extrakce N-gram? z rozs?hl?ch text? (In Czech)', '978-80-227-2827-0', 'In Proceedings of the 7th Annual Conference ZNALOSTI 2008, pp. 54-65, Bratislava, Slovakia', 'Ceska, Z., Hanak, I., Tesar, R.', '', '2008', ''),
(275, 151, 'nov? publikace', NULL, NULL, 'Ing. Jan Hejtm?nek', NULL, NULL, NULL);

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

-- 
-- Struktura tabulky `sekretariat`
-- 

CREATE TABLE `sekretariat` (
  `id_osoby` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id_osoby`)
) TYPE=MyISAM;

-- 
-- Vypisuji data pro tabulku `sekretariat`
-- 

INSERT INTO `sekretariat` (`id_osoby`) VALUES 
(1),
(4),
(48),
(66);

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

-- 
-- Struktura tabulky `skupiny`
-- 

CREATE TABLE `skupiny` (
  `id` int(11) NOT NULL auto_increment,
  `nazevCZ` varchar(128) default NULL,
  `nazevEN` varchar(128) default NULL,
  `poradi` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `poradi` (`poradi`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;

-- 
-- Vypisuji data pro tabulku `skupiny`
-- 

INSERT INTO `skupiny` (`id`, `nazevCZ`, `nazevEN`, `poradi`) VALUES 
(1, 'Odborn? asistenti', 'Lecturers', 3),
(2, 'Veden? katedry', 'Management of the Department', 1),
(3, 'Profeso?i a docenti', 'Professors and Senior Lecturers', 2),
(4, 'Asistenti', 'Teaching assistants', 4),
(5, 'Doktorandi', 'PhD students', 5),
(8, 'Servisn? skupina', 'Service group', 7),
(7, 'V?deckov?zkumn? pracovn?ci', 'Research assistants', 6),
(9, 'Externist?', 'Visiting Lecturers', 8),
(10, 'B?val? ?lenov?', 'former members', 0),
(11, 'nov? skupina', 'new group', 9);