-- MySQL dump 10.11
--
-- Host: localhost    Database: test
-- ------------------------------------------------------
-- Server version	5.0.45-community-nt

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `KIV_DB_VERSION`
--

DROP TABLE IF EXISTS `KIV_DB_VERSION`;
CREATE TABLE `KIV_DB_VERSION` (
  `autor` varchar(255) collate utf8_czech_ci NOT NULL default 'Premek Brada <brada@kiv.zcu.cz>',
  `verze` varchar(10) collate utf8_czech_ci NOT NULL default '2009-09-29'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PERS_AKTIVITY`
--

DROP TABLE IF EXISTS `KIV_PERS_AKTIVITY`;
CREATE TABLE `KIV_PERS_AKTIVITY` (
  `id` int(11) NOT NULL auto_increment,
  `nazev_cz` varchar(255) collate utf8_czech_ci NOT NULL,
  `nazev_en` varchar(255) collate utf8_czech_ci NOT NULL,
  `poradi` int(11) default NULL,
  `popis_cz` text collate utf8_czech_ci,
  `popis_en` text collate utf8_czech_ci,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PERS_AKTIVITY_OSOB`
--

DROP TABLE IF EXISTS `KIV_PERS_AKTIVITY_OSOB`;
CREATE TABLE `KIV_PERS_AKTIVITY_OSOB` (
  `fk_osoba` int(11) NOT NULL,
  `fk_aktivita` int(11) NOT NULL,
  `do` date default NULL,
  `od` date default NULL,
  PRIMARY KEY  (`fk_osoba`,`fk_aktivita`),
  KEY `ao` (`fk_aktivita`),
  CONSTRAINT `ao` FOREIGN KEY (`fk_aktivita`) REFERENCES `KIV_PERS_AKTIVITY` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `oa` FOREIGN KEY (`fk_osoba`) REFERENCES `KIV_PERS_OSOBY` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PERS_CLENSTVI`
--

DROP TABLE IF EXISTS `KIV_PERS_CLENSTVI`;
CREATE TABLE `KIV_PERS_CLENSTVI` (
  `id` int(11) NOT NULL auto_increment,
  `nazev_cz` varchar(255) collate utf8_czech_ci NOT NULL,
  `nazev_en` varchar(255) collate utf8_czech_ci NOT NULL,
  `poradi` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PERS_CLENSTVI_OSOB`
--

DROP TABLE IF EXISTS `KIV_PERS_CLENSTVI_OSOB`;
CREATE TABLE `KIV_PERS_CLENSTVI_OSOB` (
  `fk_osoba` int(11) NOT NULL default '0',
  `fk_clenstvi` int(11) NOT NULL default '0',
  `od` date default NULL,
  `do` date default NULL,
  PRIMARY KEY  (`fk_osoba`,`fk_clenstvi`),
  KEY `pc` (`fk_clenstvi`),
  CONSTRAINT `pc` FOREIGN KEY (`fk_clenstvi`) REFERENCES `KIV_PERS_CLENSTVI` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `co` FOREIGN KEY (`fk_osoba`) REFERENCES `KIV_PERS_OSOBY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PERS_FUNKCE`
--

DROP TABLE IF EXISTS `KIV_PERS_FUNKCE`;
CREATE TABLE `KIV_PERS_FUNKCE` (
  `fk_osoba` int(11) NOT NULL default '0',
  `fk_pozice` int(11) NOT NULL default '0',
  `od` date default NULL,
  `do` date default NULL,
  PRIMARY KEY  (`fk_osoba`,`fk_pozice`),
  KEY `pp` (`fk_pozice`),
  CONSTRAINT `pp` FOREIGN KEY (`fk_pozice`) REFERENCES `KIV_PERS_POZICE` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `op` FOREIGN KEY (`fk_osoba`) REFERENCES `KIV_PERS_OSOBY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PERS_KATEGORIE`
--

DROP TABLE IF EXISTS `KIV_PERS_KATEGORIE`;
CREATE TABLE `KIV_PERS_KATEGORIE` (
  `id` int(11) NOT NULL auto_increment,
  `nazev_cz` varchar(40) collate utf8_czech_ci NOT NULL,
  `nazev_en` varchar(40) collate utf8_czech_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PERS_OSOBY`
--

DROP TABLE IF EXISTS `KIV_PERS_OSOBY`;
CREATE TABLE `KIV_PERS_OSOBY` (
  `id` int(11) NOT NULL auto_increment,
  `login` varchar(20) collate utf8_czech_ci NOT NULL,
  `jmeno` varchar(80) collate utf8_czech_ci default NULL,
  `telefon_ext` varchar(20) collate utf8_czech_ci default NULL,
  `tituly_za` varchar(40) collate utf8_czech_ci default NULL,
  `tituly_pred` varchar(40) collate utf8_czech_ci default NULL,
  `email` varchar(100) collate utf8_czech_ci NOT NULL,
  `je_externi` tinyint(1) default NULL,
  `ext_pracoviste_cz` varchar(255) collate utf8_czech_ci default NULL,
  `ext_pracoviste_en` varchar(255) collate utf8_czech_ci default NULL,
  `url` varchar(255) collate utf8_czech_ci default NULL,
  `kancelar` varchar(10) collate utf8_czech_ci default NULL,
  `telefon_zcu` int(11) NOT NULL,
  `uredni_hodiny` varchar(255) collate utf8_czech_ci default NULL,
  `prijmeni` varchar(80) collate utf8_czech_ci NOT NULL,
  `je_doktorand` tinyint(1) default NULL,
  `dokt_fk_skolitel` int(11) default NULL,
  `dokt_rok_nastupu` int(11) default NULL,
  `zaznam_editor` int(11) default NULL,
  `zaznam_datum` date default NULL,
  `zaznam_aktivni` tinyint(1) default NULL,
  `zivotopis_cz` text collate utf8_czech_ci,
  `zivotopis_en` text collate utf8_czech_ci,
  `osobni_cislo` int(11) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `login` (`login`),
  UNIQUE KEY `login_osoby` (`login`),
  KEY `skolitel` (`dokt_fk_skolitel`),
  CONSTRAINT `skolitel` FOREIGN KEY (`dokt_fk_skolitel`) REFERENCES `KIV_PERS_OSOBY` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PERS_POZICE`
--

DROP TABLE IF EXISTS `KIV_PERS_POZICE`;
CREATE TABLE `KIV_PERS_POZICE` (
  `id` int(11) NOT NULL auto_increment,
  `nazev_cz` varchar(255) collate utf8_czech_ci NOT NULL,
  `poradi` int(11) default NULL,
  `popis_en` text collate utf8_czech_ci,
  `popis_cz` text collate utf8_czech_ci,
  `nazev_en` varchar(255) collate utf8_czech_ci NOT NULL,
  `fk_kategorie` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `ppozkat` (`fk_kategorie`),
  CONSTRAINT `ppozkat` FOREIGN KEY (`fk_kategorie`) REFERENCES `KIV_PERS_KATEGORIE` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PROD_LICENCE`
--

DROP TABLE IF EXISTS `KIV_PROD_LICENCE`;
CREATE TABLE `KIV_PROD_LICENCE` (
  `id` int(11) NOT NULL auto_increment,
  `nazev_cz` varchar(255) collate utf8_czech_ci NOT NULL,
  `nazev_en` varchar(255) collate utf8_czech_ci NOT NULL,
  `text` text collate utf8_czech_ci,
  `url` varchar(255) collate utf8_czech_ci default NULL,
  `zkratka` varchar(20) collate utf8_czech_ci default NULL,
  `zaznam_editor` int(11) default NULL,
  `zaznam_datum` date default NULL,
  `zaznam_aktivni` tinyint(4) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `zkratka` (`zkratka`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PROD_LOG_STAHOVANI`
--

DROP TABLE IF EXISTS `KIV_PROD_LOG_STAHOVANI`;
CREATE TABLE `KIV_PROD_LOG_STAHOVANI` (
  `kdy` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `ip4` varchar(15) collate utf8_czech_ci default NULL,
  `ip6` varchar(39) collate utf8_czech_ci default NULL,
  `user_agent` varchar(255) collate utf8_czech_ci default NULL,
  `id` int(11) NOT NULL auto_increment,
  `fk_produkt` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `produkt_log` (`fk_produkt`),
  CONSTRAINT `produkt_log` FOREIGN KEY (`fk_produkt`) REFERENCES `KIV_PROD_PRODUKTY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PROD_PRODUKTY`
--

DROP TABLE IF EXISTS `KIV_PROD_PRODUKTY`;
CREATE TABLE `KIV_PROD_PRODUKTY` (
  `id` int(11) NOT NULL auto_increment,
  `nazev_cz` varchar(255) collate utf8_czech_ci NOT NULL,
  `nazev_en` varchar(255) collate utf8_czech_ci NOT NULL,
  `popis_cz` text collate utf8_czech_ci,
  `popis_en` text collate utf8_czech_ci,
  `stav` varchar(30) collate utf8_czech_ci default NULL,
  `komentar_neschvaleno` text collate utf8_czech_ci,
  `pocet_stazeni` int(11) default NULL,
  `velikost` int(11) default NULL,
  `fk_licence` int(11) NOT NULL,
  `fk_grant` int(11) default NULL,
  `fk_osoba_autor` int(11) NOT NULL,
  `fk_osoba_schvalil` int(11) default NULL,
  `zaznam_editor` int(11) default NULL,
  `zaznam_datum` date default NULL,
  `zaznam_aktivni` tinyint(4) default NULL,
  `url` varchar(255) collate utf8_czech_ci default NULL,
  `verze_id` int(11) NOT NULL,
  `verze_nazev` varchar(255) collate utf8_czech_ci NOT NULL,
  `fk_produkt_verze_rodic` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `prodver` (`fk_produkt_verze_rodic`),
  KEY `licence_produktu` (`fk_licence`),
  KEY `grant_produktu` (`fk_grant`),
  KEY `produkt_autor` (`fk_osoba_autor`),
  KEY `produkt_schvalovatel` (`fk_osoba_schvalil`),
  CONSTRAINT `prodver` FOREIGN KEY (`fk_produkt_verze_rodic`) REFERENCES `KIV_PROD_PRODUKTY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `grant_produktu` FOREIGN KEY (`fk_grant`) REFERENCES `KIV_VYZK_GRANTY` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
  CONSTRAINT `licence_produktu` FOREIGN KEY (`fk_licence`) REFERENCES `KIV_PROD_LICENCE` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `produkt_autor` FOREIGN KEY (`fk_osoba_autor`) REFERENCES `KIV_PERS_OSOBY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `produkt_schvalovatel` FOREIGN KEY (`fk_osoba_schvalil`) REFERENCES `KIV_PERS_OSOBY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PUBL_AUTORI`
--

DROP TABLE IF EXISTS `KIV_PUBL_AUTORI`;
CREATE TABLE `KIV_PUBL_AUTORI` (
  `fk_publikace` int(11) NOT NULL default '0',
  `fk_osoba` int(11) NOT NULL default '0',
  `je_hlavni_autor` tinyint(1) default NULL,
  PRIMARY KEY  (`fk_publikace`,`fk_osoba`),
  KEY `aut` (`fk_osoba`),
  CONSTRAINT `pub` FOREIGN KEY (`fk_publikace`) REFERENCES `KIV_PUBL_ZAZNAMY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `aut` FOREIGN KEY (`fk_osoba`) REFERENCES `KIV_PERS_OSOBY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PUBL_CASOPISY`
--

DROP TABLE IF EXISTS `KIV_PUBL_CASOPISY`;
CREATE TABLE `KIV_PUBL_CASOPISY` (
  `id` int(11) NOT NULL auto_increment,
  `nazev` varchar(255) collate utf8_czech_ci NOT NULL,
  `fk_vydavatel` int(11) NOT NULL,
  `issn` varchar(9) collate utf8_czech_ci default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `issn` (`issn`),
  KEY `pcasvyd` (`fk_vydavatel`),
  CONSTRAINT `pcasvyd` FOREIGN KEY (`fk_vydavatel`) REFERENCES `KIV_PUBL_VYDAVATELE` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PUBL_CITACE`
--

DROP TABLE IF EXISTS `KIV_PUBL_CITACE`;
CREATE TABLE `KIV_PUBL_CITACE` (
  `id` int(11) NOT NULL auto_increment,
  `autori` varchar(255) collate utf8_czech_ci default NULL,
  `nazev` varchar(255) collate utf8_czech_ci NOT NULL,
  `sbornik` varchar(255) collate utf8_czech_ci default NULL,
  `vydavatel` varchar(255) collate utf8_czech_ci default NULL,
  `rok` int(11) NOT NULL,
  `url` varchar(255) collate utf8_czech_ci default NULL,
  `fk_publikace` int(11) NOT NULL,
  `zaznam_datum` date default NULL,
  `zaznam_editor` int(11) default NULL,
  `zaznam_aktivni` tinyint(1) default NULL,
  `fk_typ` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `cit` (`fk_publikace`),
  KEY `tyc` (`fk_typ`),
  CONSTRAINT `tyc` FOREIGN KEY (`fk_typ`) REFERENCES `KIV_PUBL_TYPY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `cit` FOREIGN KEY (`fk_publikace`) REFERENCES `KIV_PUBL_ZAZNAMY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PUBL_CLANKY`
--

DROP TABLE IF EXISTS `KIV_PUBL_CLANKY`;
CREATE TABLE `KIV_PUBL_CLANKY` (
  `fk_publ` int(11) NOT NULL,
  `cislo` int(11) NOT NULL,
  `svazek` int(11) NOT NULL,
  `fk_casopis` int(11) NOT NULL,
  `strana_do` int(11) default NULL,
  `strana_od` int(11) default NULL,
  `RIV_zeme` varchar(255) collate utf8_czech_ci default NULL,
  `RIV_rocnik` int(11) default NULL,
  `RIV_kod_isi` varchar(255) collate utf8_czech_ci default NULL,
  KEY `pcl` (`fk_publ`),
  KEY `pca` (`fk_casopis`),
  CONSTRAINT `pca` FOREIGN KEY (`fk_casopis`) REFERENCES `KIV_PUBL_CASOPISY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `pcl` FOREIGN KEY (`fk_publ`) REFERENCES `KIV_PUBL_ZAZNAMY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PUBL_DISERTACE`
--

DROP TABLE IF EXISTS `KIV_PUBL_DISERTACE`;
CREATE TABLE `KIV_PUBL_DISERTACE` (
  `fk_publ` int(11) NOT NULL,
  `datum_obhajoby` date default NULL,
  KEY `pth` (`fk_publ`),
  CONSTRAINT `pth` FOREIGN KEY (`fk_publ`) REFERENCES `KIV_PUBL_ZAZNAMY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PUBL_EXTAUTORI`
--

DROP TABLE IF EXISTS `KIV_PUBL_EXTAUTORI`;
CREATE TABLE `KIV_PUBL_EXTAUTORI` (
  `fk_publikace` int(11) NOT NULL,
  `fk_extautor` int(11) NOT NULL default '0',
  `je_hlavni_autor` tinyint(1) default NULL,
  PRIMARY KEY  (`fk_publikace`,`fk_extautor`),
  KEY `extautor_publ` (`fk_extautor`),
  CONSTRAINT `extautor_publ` FOREIGN KEY (`fk_extautor`) REFERENCES `KIV_PUBL_EXTERNISTE` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `publ_extautor` FOREIGN KEY (`fk_publikace`) REFERENCES `KIV_PUBL_ZAZNAMY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PUBL_EXTERNISTE`
--

DROP TABLE IF EXISTS `KIV_PUBL_EXTERNISTE`;
CREATE TABLE `KIV_PUBL_EXTERNISTE` (
  `id` int(11) NOT NULL auto_increment,
  `jmeno` varchar(255) collate utf8_czech_ci default NULL,
  `prijmeni` varchar(255) collate utf8_czech_ci NOT NULL,
  `instituce` varchar(255) collate utf8_czech_ci default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PUBL_HABILITACNI`
--

DROP TABLE IF EXISTS `KIV_PUBL_HABILITACNI`;
CREATE TABLE `KIV_PUBL_HABILITACNI` (
  `fk_publ` int(11) NOT NULL,
  `datum_obhajoby` date default NULL,
  KEY `phza` (`fk_publ`),
  CONSTRAINT `phza` FOREIGN KEY (`fk_publ`) REFERENCES `KIV_PUBL_ZAZNAMY` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PUBL_KAPITOLY`
--

DROP TABLE IF EXISTS `KIV_PUBL_KAPITOLY`;
CREATE TABLE `KIV_PUBL_KAPITOLY` (
  `fk_publ` int(11) NOT NULL,
  `edice` varchar(100) collate utf8_czech_ci default NULL,
  `nazev_knihy` varchar(255) collate utf8_czech_ci NOT NULL,
  `isbn` varchar(20) collate utf8_czech_ci default NULL,
  `editor` varchar(255) collate utf8_czech_ci default NULL,
  `fk_vydavatel` int(11) default NULL,
  `edicni_rada` varchar(100) collate utf8_czech_ci default NULL,
  `strana_do` int(11) default NULL,
  `strana_od` int(11) default NULL,
  `svazek` int(11) default NULL,
  KEY `publ_kapitola` (`fk_publ`),
  KEY `kapitola_vydavatel` (`fk_vydavatel`),
  CONSTRAINT `kapitola_vydavatel` FOREIGN KEY (`fk_vydavatel`) REFERENCES `KIV_PUBL_VYDAVATELE` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `publ_kapitola` FOREIGN KEY (`fk_publ`) REFERENCES `KIV_PUBL_ZAZNAMY` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PUBL_KNIHY`
--

DROP TABLE IF EXISTS `KIV_PUBL_KNIHY`;
CREATE TABLE `KIV_PUBL_KNIHY` (
  `fk_publ` int(11) default NULL,
  `je_autor_editorem` tinyint(1) default NULL,
  `fk_vydavatel` int(11) default NULL,
  `svazek` int(11) default NULL,
  `edicni_rada` varchar(100) collate utf8_czech_ci default NULL,
  `vydani` int(11) default NULL,
  `isbn` varchar(20) collate utf8_czech_ci default NULL,
  `pocet_stran` int(11) default NULL,
  `edice` varchar(255) collate utf8_czech_ci default NULL,
  UNIQUE KEY `isbn` (`isbn`),
  KEY `pkn` (`fk_publ`),
  KEY `pvyk` (`fk_vydavatel`),
  CONSTRAINT `pvyk` FOREIGN KEY (`fk_vydavatel`) REFERENCES `KIV_PUBL_VYDAVATELE` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `pkn` FOREIGN KEY (`fk_publ`) REFERENCES `KIV_PUBL_ZAZNAMY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PUBL_MISC`
--

DROP TABLE IF EXISTS `KIV_PUBL_MISC`;
CREATE TABLE `KIV_PUBL_MISC` (
  `fk_publ` int(11) NOT NULL,
  `jak_publikovano` varchar(255) collate utf8_czech_ci default NULL,
  KEY `pmiz` (`fk_publ`),
  CONSTRAINT `pmiz` FOREIGN KEY (`fk_publ`) REFERENCES `KIV_PUBL_ZAZNAMY` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PUBL_PRISPEVKY`
--

DROP TABLE IF EXISTS `KIV_PUBL_PRISPEVKY`;
CREATE TABLE `KIV_PUBL_PRISPEVKY` (
  `fk_publ` int(11) NOT NULL,
  `nazev_sborniku` varchar(255) collate utf8_czech_ci NOT NULL,
  `editori` varchar(100) collate utf8_czech_ci default NULL,
  `fk_vydavatel` int(11) default NULL,
  `RIV_edice` varchar(50) collate utf8_czech_ci default NULL,
  `strana_do` int(11) default NULL,
  `misto` varchar(255) collate utf8_czech_ci default NULL,
  `isbn` varchar(20) collate utf8_czech_ci default NULL,
  `instituce` varchar(255) collate utf8_czech_ci default NULL,
  `strana_od` int(11) default NULL,
  `RIV_fk_typ_akce` int(11) default NULL,
  `issn` varchar(9) collate utf8_czech_ci default NULL,
  `RIV_kod_isi` varchar(255) collate utf8_czech_ci default NULL,
  KEY `ppr` (`fk_publ`),
  KEY `pvy` (`fk_vydavatel`),
  CONSTRAINT `pvy` FOREIGN KEY (`fk_vydavatel`) REFERENCES `KIV_PUBL_VYDAVATELE` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `ppr` FOREIGN KEY (`fk_publ`) REFERENCES `KIV_PUBL_ZAZNAMY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PUBL_RIV_CISELNIKY`
--

DROP TABLE IF EXISTS `KIV_PUBL_RIV_CISELNIKY`;
CREATE TABLE `KIV_PUBL_RIV_CISELNIKY` (
  `id` int(11) NOT NULL auto_increment,
  `oblast` varchar(50) collate utf8_czech_ci default NULL,
  `hodnota` varchar(255) collate utf8_czech_ci default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PUBL_SBORNIKY`
--

DROP TABLE IF EXISTS `KIV_PUBL_SBORNIKY`;
CREATE TABLE `KIV_PUBL_SBORNIKY` (
  `fk_vydavatel` int(11) default NULL,
  `fk_publ` int(11) default NULL,
  `instituce` varchar(255) collate utf8_czech_ci default NULL,
  `isbn` varchar(20) collate utf8_czech_ci default NULL,
  `issn` varchar(9) collate utf8_czech_ci default NULL,
  UNIQUE KEY `isbn` (`isbn`),
  UNIQUE KEY `issn` (`issn`),
  KEY `psb` (`fk_publ`),
  KEY `psbv` (`fk_vydavatel`),
  CONSTRAINT `psbv` FOREIGN KEY (`fk_vydavatel`) REFERENCES `KIV_PUBL_VYDAVATELE` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `psb` FOREIGN KEY (`fk_publ`) REFERENCES `KIV_PUBL_ZAZNAMY` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PUBL_SOUBORY`
--

DROP TABLE IF EXISTS `KIV_PUBL_SOUBORY`;
CREATE TABLE `KIV_PUBL_SOUBORY` (
  `id` int(11) NOT NULL auto_increment,
  `resource_uri` varchar(255) collate utf8_czech_ci default NULL,
  `pocet_stazeni` int(11) default NULL,
  `popis_cz` text collate utf8_czech_ci,
  `popis_en` text collate utf8_czech_ci,
  `fk_publikace` int(11) default NULL,
  `zaznam_datum` date default NULL,
  `zaznam_editor` int(11) default NULL,
  `zaznam_aktivni` tinyint(1) default NULL,
  `fk_tema` int(11) default NULL,
  `fk_grant` int(11) default NULL,
  `fk_produkt` int(11) default NULL,
  `nazev_cz` varchar(255) collate utf8_czech_ci NOT NULL,
  `nazev_en` varchar(255) collate utf8_czech_ci NOT NULL,
  `typ` varchar(100) collate utf8_czech_ci default NULL,
  `velikost` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `sou` (`fk_publikace`),
  KEY `ts` (`fk_tema`),
  KEY `sog` (`fk_grant`),
  KEY `soubory_produktu` (`fk_produkt`),
  CONSTRAINT `soubory_produktu` FOREIGN KEY (`fk_produkt`) REFERENCES `KIV_PROD_PRODUKTY` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
  CONSTRAINT `sog` FOREIGN KEY (`fk_grant`) REFERENCES `KIV_VYZK_GRANTY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `sou` FOREIGN KEY (`fk_publikace`) REFERENCES `KIV_PUBL_ZAZNAMY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `ts` FOREIGN KEY (`fk_tema`) REFERENCES `KIV_STUD_TEMATA` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PUBL_TECHREPORTY`
--

DROP TABLE IF EXISTS `KIV_PUBL_TECHREPORTY`;
CREATE TABLE `KIV_PUBL_TECHREPORTY` (
  `fk_publ` int(11) NOT NULL,
  `cislo` varchar(20) collate utf8_czech_ci default NULL,
  UNIQUE KEY `cislo` (`cislo`),
  KEY `ptr` (`fk_publ`),
  CONSTRAINT `ptr` FOREIGN KEY (`fk_publ`) REFERENCES `KIV_PUBL_ZAZNAMY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PUBL_TYPY`
--

DROP TABLE IF EXISTS `KIV_PUBL_TYPY`;
CREATE TABLE `KIV_PUBL_TYPY` (
  `id` int(11) NOT NULL auto_increment,
  `zkratka` varchar(10) collate utf8_czech_ci default NULL,
  `poradi` int(11) default NULL,
  `nazev_en` varchar(255) collate utf8_czech_ci default NULL,
  `nazev_cz` varchar(255) collate utf8_czech_ci default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `zkratka` (`zkratka`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PUBL_VYDAVATELE`
--

DROP TABLE IF EXISTS `KIV_PUBL_VYDAVATELE`;
CREATE TABLE `KIV_PUBL_VYDAVATELE` (
  `id` int(11) NOT NULL auto_increment,
  `nazev` varchar(255) collate utf8_czech_ci NOT NULL,
  `zeme` varchar(100) collate utf8_czech_ci default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_PUBL_ZAZNAMY`
--

DROP TABLE IF EXISTS `KIV_PUBL_ZAZNAMY`;
CREATE TABLE `KIV_PUBL_ZAZNAMY` (
  `id` int(11) NOT NULL auto_increment,
  `fk_grant` int(11) default NULL,
  `nazev` varchar(255) collate utf8_czech_ci NOT NULL,
  `zaznam_datum` date default NULL,
  `zaznam_aktivni` tinyint(1) default NULL,
  `zaznam_editor` int(11) default NULL,
  `rok` int(11) NOT NULL,
  `poznamka` text collate utf8_czech_ci,
  `mesic` int(11) default NULL,
  `fk_typ` int(11) default NULL,
  `url` varchar(255) collate utf8_czech_ci default NULL,
  `RIV_anotace_en` text collate utf8_czech_ci,
  `RIV_nazev_en` varchar(255) collate utf8_czech_ci default NULL,
  `RIV_anotace_cz` text collate utf8_czech_ci,
  `RIV_fk_jazyk` int(11) default NULL,
  `RIV_fk_obor` int(11) default NULL,
  `RIV_klicslova_cz` varchar(255) collate utf8_czech_ci default NULL,
  `RIV_nazev_cz` varchar(255) collate utf8_czech_ci default NULL,
  `abstrakt` text collate utf8_czech_ci,
  `RIV_klicslova_en` varchar(255) collate utf8_czech_ci default NULL,
  `RIV_evidovano` tinyint(1) default NULL,
  `klicslova` varchar(255) collate utf8_czech_ci default NULL,
  `adresa` varchar(255) collate utf8_czech_ci default NULL,
  PRIMARY KEY  (`id`),
  KEY `gp` (`fk_grant`),
  KEY `tyb` (`fk_typ`),
  KEY `pzario` (`RIV_fk_obor`),
  KEY `pzarja` (`RIV_fk_jazyk`),
  CONSTRAINT `pzarja` FOREIGN KEY (`RIV_fk_jazyk`) REFERENCES `KIV_PUBL_RIV_CISELNIKY` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `gp` FOREIGN KEY (`fk_grant`) REFERENCES `KIV_VYZK_GRANTY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `pzario` FOREIGN KEY (`RIV_fk_obor`) REFERENCES `KIV_PUBL_RIV_CISELNIKY` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `tyb` FOREIGN KEY (`fk_typ`) REFERENCES `KIV_PUBL_TYPY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_STUD_OBORY`
--

DROP TABLE IF EXISTS `KIV_STUD_OBORY`;
CREATE TABLE `KIV_STUD_OBORY` (
  `id` int(11) NOT NULL auto_increment,
  `fk_program` int(11) default NULL,
  `zkratka` varchar(10) collate utf8_czech_ci NOT NULL,
  `nazev_cz` varchar(255) collate utf8_czech_ci NOT NULL,
  `nazev_en` varchar(255) collate utf8_czech_ci NOT NULL,
  `zaznam_datum` date default NULL,
  `zaznam_editor` int(11) default NULL,
  `zaznam_aktivni` tinyint(1) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `zkratka` (`zkratka`),
  KEY `pgo` (`fk_program`),
  CONSTRAINT `pgo` FOREIGN KEY (`fk_program`) REFERENCES `KIV_STUD_PROGRAMY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_STUD_PREDMETY`
--

DROP TABLE IF EXISTS `KIV_STUD_PREDMETY`;
CREATE TABLE `KIV_STUD_PREDMETY` (
  `id` int(11) NOT NULL auto_increment,
  `zkratka` varchar(10) collate utf8_czech_ci NOT NULL,
  `nazev_cz` varchar(255) collate utf8_czech_ci NOT NULL,
  `katedra` varchar(10) collate utf8_czech_ci NOT NULL default 'KIV',
  `url` varchar(255) collate utf8_czech_ci default NULL,
  `rok_varianty` int(11) default NULL,
  `semestr` varchar(10) collate utf8_czech_ci default NULL,
  `je_vyucovan` tinyint(1) default NULL,
  `zaznam_aktivni` tinyint(1) default NULL,
  `zaznam_editor` int(11) default NULL,
  `zaznam_datum` date default NULL,
  `nazev_en` varchar(255) collate utf8_czech_ci NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `katedra_zkratka` (`zkratka`,`katedra`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_STUD_PREDM_OBOR`
--

DROP TABLE IF EXISTS `KIV_STUD_PREDM_OBOR`;
CREATE TABLE `KIV_STUD_PREDM_OBOR` (
  `fk_predmet` int(11) NOT NULL default '0',
  `fk_obor` int(11) NOT NULL default '0',
  `status` varchar(1) collate utf8_czech_ci default NULL,
  PRIMARY KEY  (`fk_predmet`,`fk_obor`),
  KEY `oo` (`fk_obor`),
  CONSTRAINT `oo` FOREIGN KEY (`fk_obor`) REFERENCES `KIV_STUD_OBORY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `po` FOREIGN KEY (`fk_predmet`) REFERENCES `KIV_STUD_PREDMETY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_STUD_PROGRAMY`
--

DROP TABLE IF EXISTS `KIV_STUD_PROGRAMY`;
CREATE TABLE `KIV_STUD_PROGRAMY` (
  `id` int(11) NOT NULL auto_increment,
  `zkratka` varchar(10) collate utf8_czech_ci NOT NULL,
  `nazev_cz` varchar(255) collate utf8_czech_ci NOT NULL,
  `nazev_en` varchar(255) collate utf8_czech_ci NOT NULL,
  `forma` varchar(1) collate utf8_czech_ci default NULL,
  `zaznam_editor` int(11) default NULL,
  `zaznam_datum` date default NULL,
  `zaznam_aktivni` tinyint(1) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `zkratka` (`zkratka`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_STUD_TEMATA`
--

DROP TABLE IF EXISTS `KIV_STUD_TEMATA`;
CREATE TABLE `KIV_STUD_TEMATA` (
  `id` int(11) NOT NULL auto_increment,
  `fk_garant` int(11) NOT NULL,
  `fk_typ_prace` int(11) NOT NULL,
  `fk_obor` int(11) NOT NULL,
  `nazev_cz` varchar(255) collate utf8_czech_ci NOT NULL,
  `nazev_en` varchar(255) collate utf8_czech_ci default NULL,
  `popis_cz` text collate utf8_czech_ci,
  `popis_en` text collate utf8_czech_ci,
  `url` varchar(255) collate utf8_czech_ci default NULL,
  `je_externi` tinyint(1) NOT NULL,
  `ext_vedouci` varchar(255) collate utf8_czech_ci default NULL,
  `ext_organizace` varchar(255) collate utf8_czech_ci default NULL,
  `zaznam_editor` int(11) default NULL,
  `zaznam_datum` date default NULL,
  `zaznam_aktivni` tinyint(1) default NULL,
  `kdy_rezervovano` date default NULL,
  `kdy_zverejnit` date default NULL,
  `pro_akad_rok` varchar(9) collate utf8_czech_ci default NULL,
  `zadano_email` varchar(100) collate utf8_czech_ci default NULL,
  `kdy_vypsano` date default NULL,
  `zadano_jmeno` varchar(100) collate utf8_czech_ci default NULL,
  `zadano_osobni_cislo` varchar(10) collate utf8_czech_ci default NULL,
  `kdy_odevzdano` date default NULL,
  `fk_stav` int(11) NOT NULL,
  `kdy_obhajeno` date default NULL,
  PRIMARY KEY  (`id`),
  KEY `vypsal` (`fk_garant`),
  KEY `tt` (`fk_typ_prace`),
  KEY `temata_obory` (`fk_obor`),
  KEY `tstav` (`fk_stav`),
  CONSTRAINT `tstav` FOREIGN KEY (`fk_stav`) REFERENCES `KIV_STUD_TEMATA_STAVY` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `temata_obory` FOREIGN KEY (`fk_obor`) REFERENCES `KIV_STUD_OBORY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `tt` FOREIGN KEY (`fk_typ_prace`) REFERENCES `KIV_STUD_TEMATA_TYPY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `vypsal` FOREIGN KEY (`fk_garant`) REFERENCES `KIV_PERS_OSOBY` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_STUD_TEMATA_STAVY`
--

DROP TABLE IF EXISTS `KIV_STUD_TEMATA_STAVY`;
CREATE TABLE `KIV_STUD_TEMATA_STAVY` (
  `id` int(11) NOT NULL auto_increment,
  `nazev_cz` varchar(20) collate utf8_czech_ci default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_STUD_TEMATA_TYPY`
--

DROP TABLE IF EXISTS `KIV_STUD_TEMATA_TYPY`;
CREATE TABLE `KIV_STUD_TEMATA_TYPY` (
  `id` int(11) NOT NULL auto_increment,
  `zkratka` varchar(10) collate utf8_czech_ci NOT NULL,
  `nazev_cz` varchar(255) collate utf8_czech_ci NOT NULL,
  `nazev_en` varchar(255) collate utf8_czech_ci NOT NULL,
  `je_zaverecna` tinyint(1) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `zkratka` (`zkratka`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_STUD_VYUCUJE`
--

DROP TABLE IF EXISTS `KIV_STUD_VYUCUJE`;
CREATE TABLE `KIV_STUD_VYUCUJE` (
  `fk_osoba` int(11) NOT NULL default '0',
  `fk_predmet` int(11) NOT NULL default '0',
  `je_cvicici` tinyint(1) default NULL,
  `je_prednasejici` tinyint(1) default NULL,
  `je_seminarici` tinyint(1) default NULL,
  `je_garant` tinyint(1) default NULL,
  PRIMARY KEY  (`fk_osoba`,`fk_predmet`),
  KEY `vp` (`fk_predmet`),
  CONSTRAINT `vp` FOREIGN KEY (`fk_predmet`) REFERENCES `KIV_STUD_PREDMETY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `ov` FOREIGN KEY (`fk_osoba`) REFERENCES `KIV_PERS_OSOBY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_UDALOSTI`
--

DROP TABLE IF EXISTS `KIV_UDALOSTI`;
CREATE TABLE `KIV_UDALOSTI` (
  `id` int(11) NOT NULL auto_increment,
  `fk_kontaktni_osoba` int(11) NOT NULL,
  `nazev_en` varchar(100) collate utf8_czech_ci NOT NULL,
  `nazev_cz` varchar(100) collate utf8_czech_ci default NULL,
  `popis_en` text collate utf8_czech_ci,
  `popis_cz` text collate utf8_czech_ci,
  `datum_konec` date default NULL,
  `misto_cz` varchar(255) collate utf8_czech_ci default NULL,
  `datum_zacatek` date default NULL,
  `je_stala` tinyint(1) default NULL,
  `url` varchar(255) collate utf8_czech_ci default NULL,
  `misto_en` varchar(255) collate utf8_czech_ci default NULL,
  `zaznam_datum` date default NULL,
  `zaznam_editor` int(11) default NULL,
  `zaznam_aktivni` tinyint(1) default NULL,
  PRIMARY KEY  (`id`),
  KEY `aud` (`fk_kontaktni_osoba`),
  CONSTRAINT `aud` FOREIGN KEY (`fk_kontaktni_osoba`) REFERENCES `KIV_PERS_OSOBY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_VYZK_GRANTY`
--

DROP TABLE IF EXISTS `KIV_VYZK_GRANTY`;
CREATE TABLE `KIV_VYZK_GRANTY` (
  `id` int(11) NOT NULL auto_increment,
  `fk_typ` int(11) NOT NULL,
  `nazev_cz` varchar(255) collate utf8_czech_ci NOT NULL,
  `nazev_en` varchar(255) collate utf8_czech_ci default NULL,
  `popis_cz` text collate utf8_czech_ci NOT NULL,
  `popis_en` text collate utf8_czech_ci NOT NULL,
  `info_cz` text collate utf8_czech_ci,
  `info_en` text collate utf8_czech_ci,
  `url` varchar(255) collate utf8_czech_ci default NULL,
  `datum_zahajeni` date NOT NULL,
  `datum_ukonceni` date NOT NULL,
  `dotace_castka` bigint(20) default NULL,
  `dotace_mena` varchar(3) collate utf8_czech_ci default NULL,
  `identifikacni_kod` varchar(100) collate utf8_czech_ci default NULL,
  `je_ukoncen` tinyint(1) default NULL,
  `je_kiv_hlavni_resitel` tinyint(1) default NULL,
  `fk_skupina` int(11) default NULL,
  `zaznam_datum` date default NULL,
  `zaznam_editor` int(11) default NULL,
  `zaznam_aktivni` tinyint(1) default NULL,
  `dotace_zdroj` varchar(255) collate utf8_czech_ci default NULL,
  `vysledky_cz` text collate utf8_czech_ci,
  `vysledky_en` text collate utf8_czech_ci,
  PRIMARY KEY  (`id`),
  KEY `gt` (`fk_typ`),
  KEY `gs` (`fk_skupina`),
  CONSTRAINT `gs` FOREIGN KEY (`fk_skupina`) REFERENCES `KIV_VYZK_SKUPINY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `gt` FOREIGN KEY (`fk_typ`) REFERENCES `KIV_VYZK_GRANTY_TYPY` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_VYZK_GRANTY_OSOB`
--

DROP TABLE IF EXISTS `KIV_VYZK_GRANTY_OSOB`;
CREATE TABLE `KIV_VYZK_GRANTY_OSOB` (
  `fk_osoba` int(11) NOT NULL,
  `fk_grant` int(11) NOT NULL,
  `je_vedoucim` tinyint(1) default NULL,
  PRIMARY KEY  (`fk_osoba`,`fk_grant`),
  KEY `go` (`fk_grant`),
  CONSTRAINT `go` FOREIGN KEY (`fk_grant`) REFERENCES `KIV_VYZK_GRANTY` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `og` FOREIGN KEY (`fk_osoba`) REFERENCES `KIV_PERS_OSOBY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_VYZK_GRANTY_TYPY`
--

DROP TABLE IF EXISTS `KIV_VYZK_GRANTY_TYPY`;
CREATE TABLE `KIV_VYZK_GRANTY_TYPY` (
  `id` int(11) NOT NULL auto_increment,
  `nazev_cz` varchar(255) collate utf8_czech_ci default NULL,
  `nazev_en` varchar(255) collate utf8_czech_ci default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_VYZK_SKUPINY`
--

DROP TABLE IF EXISTS `KIV_VYZK_SKUPINY`;
CREATE TABLE `KIV_VYZK_SKUPINY` (
  `id` int(11) NOT NULL auto_increment,
  `nazev_cz` varchar(255) collate utf8_czech_ci NOT NULL,
  `nazev_en` varchar(255) collate utf8_czech_ci default NULL,
  `popis_cz` text collate utf8_czech_ci,
  `popis_en` text collate utf8_czech_ci,
  `url` varchar(255) collate utf8_czech_ci default NULL,
  `fk_typ` int(11) default NULL,
  `zaznam_aktivni` tinyint(1) default NULL,
  `datum_zruseni` date default NULL,
  `zaznam_editor` int(11) default NULL,
  `zaznam_datum` date default NULL,
  `datum_zalozeni` date default NULL,
  PRIMARY KEY  (`id`),
  KEY `st` (`fk_typ`),
  CONSTRAINT `st` FOREIGN KEY (`fk_typ`) REFERENCES `KIV_VYZK_SKUPINY_TYPY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_VYZK_SKUPINY_OSOB`
--

DROP TABLE IF EXISTS `KIV_VYZK_SKUPINY_OSOB`;
CREATE TABLE `KIV_VYZK_SKUPINY_OSOB` (
  `fk_osoba` int(11) NOT NULL default '0',
  `fk_skupina` int(11) NOT NULL default '0',
  `je_vedoucim` tinyint(1) default NULL,
  PRIMARY KEY  (`fk_osoba`,`fk_skupina`),
  KEY `so` (`fk_skupina`),
  CONSTRAINT `so` FOREIGN KEY (`fk_skupina`) REFERENCES `KIV_VYZK_SKUPINY` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `os` FOREIGN KEY (`fk_osoba`) REFERENCES `KIV_PERS_OSOBY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Table structure for table `KIV_VYZK_SKUPINY_TYPY`
--

DROP TABLE IF EXISTS `KIV_VYZK_SKUPINY_TYPY`;
CREATE TABLE `KIV_VYZK_SKUPINY_TYPY` (
  `id` int(11) NOT NULL auto_increment,
  `nazev_cz` varchar(255) collate utf8_czech_ci default NULL,
  `nazev_en` varchar(255) collate utf8_czech_ci default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2009-10-30 17:00:22