-- phpMyAdmin SQL Dump -- version 2.10.3deb1ubuntu0.2 -- http://www.phpmyadmin.net -- -- Počítač: localhost -- Vygenerováno: Čtvrtek 17. dubna 2008, 10:24 -- Verze MySQL: 5.0.45 -- Verze PHP: 5.2.3-1ubuntu6.3 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Databáze: `kiv` -- -- -------------------------------------------------------- -- -- Struktura tabulky `PERS_AKTIVITY` -- CREATE TABLE IF NOT EXISTS `PERS_AKTIVITY` ( `id` int(11) NOT NULL auto_increment, `nazev_cz` varchar(255) collate utf8_unicode_ci NOT NULL, `nazev_en` varchar(255) collate utf8_unicode_ci NOT NULL, `poradi` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Struktura tabulky `PERS_AKTIVITY_OSOB` -- CREATE TABLE IF NOT EXISTS `PERS_AKTIVITY_OSOB` ( `fk_osoba` int(11) NOT NULL, `fk_aktivita` int(11) NOT NULL, `do` date default NULL, `od` date default NULL, KEY `oa` (`fk_osoba`), KEY `ao` (`fk_aktivita`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `PERS_CLENSTVI` -- CREATE TABLE IF NOT EXISTS `PERS_CLENSTVI` ( `id` int(11) NOT NULL auto_increment, `nazev_cz` varchar(255) collate utf8_unicode_ci NOT NULL, `nazev_en` varchar(255) collate utf8_unicode_ci NOT NULL, `poradi` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Struktura tabulky `PERS_CLENSTVI_OSOB` -- CREATE TABLE IF NOT EXISTS `PERS_CLENSTVI_OSOB` ( `fk_osoba` int(11) default NULL, `fk_clenstvi` int(11) default NULL, `od` date default NULL, `do` date default NULL, KEY `co` (`fk_osoba`), KEY `pc` (`fk_clenstvi`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `PERS_FUNKCE` -- CREATE TABLE IF NOT EXISTS `PERS_FUNKCE` ( `fk_osoba` int(11) default NULL, `fk_pozice` int(11) default NULL, `od` date default NULL, `do` date default NULL, KEY `op` (`fk_osoba`), KEY `pp` (`fk_pozice`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `PERS_OSOBY` -- CREATE TABLE IF NOT EXISTS `PERS_OSOBY` ( `id` int(11) NOT NULL auto_increment, `login` varchar(20) collate utf8_unicode_ci NOT NULL, `jmeno` varchar(80) collate utf8_unicode_ci default NULL, `telefon_ext` varchar(20) collate utf8_unicode_ci default NULL, `tituly_za` varchar(40) collate utf8_unicode_ci default NULL, `tituly_pred` varchar(40) collate utf8_unicode_ci default NULL, `email` varchar(100) collate utf8_unicode_ci NOT NULL, `je_externi` int(11) default NULL, `ext_pracoviste_cz` varchar(255) collate utf8_unicode_ci default NULL, `ext_pracoviste_en` varchar(255) collate utf8_unicode_ci default NULL, `url` varchar(255) collate utf8_unicode_ci default NULL, `kancelar` varchar(10) collate utf8_unicode_ci default NULL, `telefon_zcu` int(11) NOT NULL, `uredni_hodiny` varchar(255) collate utf8_unicode_ci default NULL, `prijmeni` varchar(80) collate utf8_unicode_ci NOT NULL, `je_doktorand` int(11) 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, PRIMARY KEY (`id`), KEY `skolitel` (`dokt_fk_skolitel`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Struktura tabulky `PERS_POZICE` -- CREATE TABLE IF NOT EXISTS `PERS_POZICE` ( `id` int(11) NOT NULL auto_increment, `nazev_cz` varchar(255) collate utf8_unicode_ci NOT NULL, `poradi` int(11) default NULL, `popis_en` varchar(255) collate utf8_unicode_ci default NULL, `popis_cz` varchar(255) collate utf8_unicode_ci default NULL, `nazev_en` varchar(255) collate utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Struktura tabulky `PUBL_AUTORI` -- CREATE TABLE IF NOT EXISTS `PUBL_AUTORI` ( `fk_publikace` int(11) default NULL, `fk_osoba` int(11) default NULL, `je_hlavni_autor` tinyint(1) default NULL, KEY `aut` (`fk_osoba`), KEY `pub` (`fk_publikace`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `PUBL_CASOPISY` -- CREATE TABLE IF NOT EXISTS `PUBL_CASOPISY` ( `id` int(11) NOT NULL auto_increment, `casopis` varchar(255) collate utf8_unicode_ci default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Struktura tabulky `PUBL_CITACE` -- CREATE TABLE IF NOT EXISTS `PUBL_CITACE` ( `id` int(11) NOT NULL auto_increment, `autori` varchar(255) collate utf8_unicode_ci default NULL, `nazev` varchar(255) collate utf8_unicode_ci NOT NULL, `sbornik` varchar(255) collate utf8_unicode_ci default NULL, `vydavatel` varchar(255) collate utf8_unicode_ci default NULL, `rok` int(11) NOT NULL, `url` varchar(255) collate utf8_unicode_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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Struktura tabulky `PUBL_CLANEK` -- CREATE TABLE IF NOT EXISTS `PUBL_CLANEK` ( `fk_publ` int(11) NOT NULL, `cislo` int(11) default NULL, `svazek` int(11) default NULL, `stranky` varchar(10) collate utf8_unicode_ci default NULL, `fk_casopis` int(11) default NULL, KEY `pcl` (`fk_publ`), KEY `pca` (`fk_casopis`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `PUBL_KNIHA` -- CREATE TABLE IF NOT EXISTS `PUBL_KNIHA` ( `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_unicode_ci default NULL, `vydani` int(11) default NULL, KEY `pkn` (`fk_publ`), KEY `pvyk` (`fk_vydavatel`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `PUBL_PHD` -- CREATE TABLE IF NOT EXISTS `PUBL_PHD` ( `fk_publ` int(11) NOT NULL, `univerzita` varchar(255) collate utf8_unicode_ci default NULL, KEY `pth` (`fk_publ`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `PUBL_PRISPEVEK` -- CREATE TABLE IF NOT EXISTS `PUBL_PRISPEVEK` ( `fk_publ` int(11) NOT NULL, `sbornik` varchar(255) collate utf8_unicode_ci default NULL, `editor` varchar(100) collate utf8_unicode_ci default NULL, `stranky` varchar(10) collate utf8_unicode_ci default NULL, `fk_vydavatel` int(11) default NULL, KEY `ppr` (`fk_publ`), KEY `pvy` (`fk_vydavatel`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `PUBL_SOUBORY` -- CREATE TABLE IF NOT EXISTS `PUBL_SOUBORY` ( `id` int(11) NOT NULL auto_increment, `filename` varchar(255) collate utf8_unicode_ci default NULL, `pocet_stazeni` int(11) default NULL, `url_licence` varchar(255) collate utf8_unicode_ci default NULL, `popis_cz` text collate utf8_unicode_ci, `popis_en` text collate utf8_unicode_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, PRIMARY KEY (`id`), KEY `sou` (`fk_publikace`), KEY `ts` (`fk_tema`), KEY `sog` (`fk_grant`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Struktura tabulky `PUBL_TECHREPORT` -- CREATE TABLE IF NOT EXISTS `PUBL_TECHREPORT` ( `fk_publ` int(11) NOT NULL, `instituce` varchar(255) collate utf8_unicode_ci default NULL, `typ` varchar(100) collate utf8_unicode_ci default NULL, `cislo` varchar(100) collate utf8_unicode_ci default NULL, KEY `ptr` (`fk_publ`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `PUBL_TYPY` -- CREATE TABLE IF NOT EXISTS `PUBL_TYPY` ( `id` int(11) NOT NULL auto_increment, `typ` varchar(100) collate utf8_unicode_ci default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Struktura tabulky `PUBL_VYDAVATELE` -- CREATE TABLE IF NOT EXISTS `PUBL_VYDAVATELE` ( `id` int(11) NOT NULL auto_increment, `vydavatel` varchar(255) collate utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Struktura tabulky `PUBL_ZAZNAMY` -- CREATE TABLE IF NOT EXISTS `PUBL_ZAZNAMY` ( `id` int(11) NOT NULL default '0', `fk_grant` int(11) default NULL, `ext_autori` varchar(255) collate utf8_unicode_ci default NULL, `nazev` varchar(255) collate utf8_unicode_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` varchar(255) collate utf8_unicode_ci default NULL, `mesic` int(11) default NULL, `adresa` varchar(255) collate utf8_unicode_ci default NULL, `autori_komplet` varchar(255) collate utf8_unicode_ci default NULL, `fk_typ` int(11) default NULL, PRIMARY KEY (`id`), KEY `gp` (`fk_grant`), KEY `tyb` (`fk_typ`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `STUD_OBORY` -- CREATE TABLE IF NOT EXISTS `STUD_OBORY` ( `id` int(11) NOT NULL auto_increment, `fk_program` int(11) default NULL, `zkratka` varchar(10) collate utf8_unicode_ci NOT NULL, `nazev_cz` varchar(255) collate utf8_unicode_ci NOT NULL, `nazev_en` varchar(255) collate utf8_unicode_ci NOT NULL, `zaznam_datum` date default NULL, `zaznam_editor` int(11) default NULL, `zaznam_aktivni` tinyint(1) default NULL, PRIMARY KEY (`id`), KEY `pgo` (`fk_program`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Struktura tabulky `STUD_PREDMETY` -- CREATE TABLE IF NOT EXISTS `STUD_PREDMETY` ( `id` int(11) NOT NULL auto_increment, `zkratka` varchar(10) collate utf8_unicode_ci NOT NULL, `nazev_cz` varchar(255) collate utf8_unicode_ci NOT NULL, `katedra` varchar(10) collate utf8_unicode_ci NOT NULL default 'KIV', `url` varchar(255) collate utf8_unicode_ci default NULL, `rok_varianty` int(11) default NULL, `semestr` varchar(10) collate utf8_unicode_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_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Struktura tabulky `STUD_PREDM_OBOR` -- CREATE TABLE IF NOT EXISTS `STUD_PREDM_OBOR` ( `fk_predmet` int(11) default NULL, `fk_obor` int(11) default NULL, `status` varchar(1) collate utf8_unicode_ci default NULL, KEY `po` (`fk_predmet`), KEY `oo` (`fk_obor`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `STUD_PROGRAMY` -- CREATE TABLE IF NOT EXISTS `STUD_PROGRAMY` ( `id` int(11) NOT NULL auto_increment, `zkratka` varchar(10) collate utf8_unicode_ci NOT NULL, `nazev_cz` varchar(255) collate utf8_unicode_ci NOT NULL, `nazev_en` varchar(255) collate utf8_unicode_ci NOT NULL, `forma` varchar(1) collate utf8_unicode_ci default NULL, `zaznam_editor` int(11) default NULL, `zaznam_datum` date default NULL, `zaznam_aktivni` tinyint(1) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Struktura tabulky `STUD_TEMATA` -- CREATE TABLE IF NOT EXISTS `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_unicode_ci NOT NULL, `nazev_en` varchar(255) collate utf8_unicode_ci default NULL, `popis_cz` text collate utf8_unicode_ci, `popis_en` text collate utf8_unicode_ci, `url` varchar(255) collate utf8_unicode_ci default NULL, `je_externi` int(11) NOT NULL, `ext_vedouci` varchar(255) collate utf8_unicode_ci default NULL, `ext_organizace` varchar(255) collate utf8_unicode_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_unicode_ci default NULL, `zadano_email` varchar(100) collate utf8_unicode_ci default NULL, `kdy_vypsano` date default NULL, `zadano_jmeno` varchar(100) collate utf8_unicode_ci default NULL, `zadano_oscislo` varchar(10) collate utf8_unicode_ci default NULL, PRIMARY KEY (`id`), KEY `vypsal` (`fk_garant`), KEY `tt` (`fk_typ_prace`), KEY `tto` (`fk_obor`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Struktura tabulky `STUD_TEMATA_TYPY` -- CREATE TABLE IF NOT EXISTS `STUD_TEMATA_TYPY` ( `id` int(11) NOT NULL auto_increment, `zkratka` varchar(10) collate utf8_unicode_ci NOT NULL, `nazev_cz` varchar(255) collate utf8_unicode_ci NOT NULL, `nazev_en` varchar(255) collate utf8_unicode_ci NOT NULL, `je_zaverecna` tinyint(1) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Struktura tabulky `STUD_VYUCUJE` -- CREATE TABLE IF NOT EXISTS `STUD_VYUCUJE` ( `fk_osoba` int(11) default NULL, `fk_predmet` int(11) default NULL, `je_prednasejici` tinyint(1) default NULL, KEY `ov` (`fk_osoba`), KEY `vp` (`fk_predmet`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `STUD_ZAVERECNE_PRACE` -- CREATE TABLE IF NOT EXISTS `STUD_ZAVERECNE_PRACE` ( `fk_tema` int(11) NOT NULL, `datum_obhajeno` date NOT NULL, `zaznam_editor` int(11) default NULL, `zaznam_datum` date default NULL, `zaznam_aktivni` tinyint(1) default NULL, UNIQUE KEY `pk_zaverecna` (`fk_tema`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `UDALOSTI` -- CREATE TABLE IF NOT EXISTS `UDALOSTI` ( `id` int(11) NOT NULL auto_increment, `fk_kontaktni_osoba` int(11) NOT NULL, `nazev_en` varchar(100) collate utf8_unicode_ci NOT NULL, `nazev_cz` varchar(100) collate utf8_unicode_ci default NULL, `popis_en` varchar(255) collate utf8_unicode_ci default NULL, `popis_cz` varchar(255) collate utf8_unicode_ci default NULL, `datum_konec` date default NULL, `misto_cz` varchar(255) collate utf8_unicode_ci default NULL, `datum_zacatek` date default NULL, `je_stala` tinyint(1) default '0', `url` varchar(255) collate utf8_unicode_ci default NULL, `misto_en` varchar(255) collate utf8_unicode_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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Struktura tabulky `VYZK_GRANTY` -- CREATE TABLE IF NOT EXISTS `VYZK_GRANTY` ( `id` int(11) NOT NULL auto_increment, `fk_typ` int(11) NOT NULL, `nazev_cz` varchar(255) collate utf8_unicode_ci NOT NULL, `nazev_en` varchar(255) collate utf8_unicode_ci default NULL, `popis_cz` text collate utf8_unicode_ci NOT NULL, `popis_en` text collate utf8_unicode_ci, `info_cz` text collate utf8_unicode_ci, `info_en` text collate utf8_unicode_ci, `url` varchar(255) collate utf8_unicode_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_unicode_ci default NULL, `identifikacni_kod` varchar(100) collate utf8_unicode_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_unicode_ci default NULL, `vysledky_cz` text collate utf8_unicode_ci, `vysledky_en` text collate utf8_unicode_ci, PRIMARY KEY (`id`), KEY `gt` (`fk_typ`), KEY `gs` (`fk_skupina`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ; -- -------------------------------------------------------- -- -- Struktura tabulky `VYZK_GRANTY_OSOB` -- CREATE TABLE IF NOT EXISTS `VYZK_GRANTY_OSOB` ( `fk_osoba` int(11) NOT NULL, `fk_grant` int(11) NOT NULL, `je_vedoucim` tinyint(1) default '0', KEY `og` (`fk_osoba`), KEY `go` (`fk_grant`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `VYZK_GRANTY_TYPY` -- CREATE TABLE IF NOT EXISTS `VYZK_GRANTY_TYPY` ( `id` int(11) NOT NULL auto_increment, `nazev_cz` varchar(255) collate utf8_unicode_ci default NULL, `nazev_en` varchar(255) collate utf8_unicode_ci default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- Struktura tabulky `VYZK_SKUPINY` -- CREATE TABLE IF NOT EXISTS `VYZK_SKUPINY` ( `id` int(11) NOT NULL, `nazev_cz` varchar(255) collate utf8_unicode_ci NOT NULL, `nazev_en` varchar(255) collate utf8_unicode_ci default NULL, `popis_cz` text collate utf8_unicode_ci, `popis_en` text collate utf8_unicode_ci, `url` varchar(255) collate utf8_unicode_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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `VYZK_SKUPINY_OSOB` -- CREATE TABLE IF NOT EXISTS `VYZK_SKUPINY_OSOB` ( `fk_osoba` int(11) default NULL, `fk_skupina` int(11) default NULL, `je_vedoucim` tinyint(1) default NULL, KEY `os` (`fk_osoba`), KEY `so` (`fk_skupina`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Struktura tabulky `VYZK_SKUPINY_TYPY` -- CREATE TABLE IF NOT EXISTS `VYZK_SKUPINY_TYPY` ( `id` int(11) NOT NULL auto_increment, `nazev_cz` varchar(255) collate utf8_unicode_ci default NULL, `nazev_en` varchar(255) collate utf8_unicode_ci default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -- Omezení pro exportované tabulky -- -- -- Omezení pro tabulku `PERS_AKTIVITY_OSOB` -- ALTER TABLE `PERS_AKTIVITY_OSOB` ADD CONSTRAINT `ao` FOREIGN KEY (`fk_aktivita`) REFERENCES `PERS_AKTIVITY` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `oa` FOREIGN KEY (`fk_osoba`) REFERENCES `PERS_OSOBY` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Omezení pro tabulku `PERS_CLENSTVI_OSOB` -- ALTER TABLE `PERS_CLENSTVI_OSOB` ADD CONSTRAINT `co` FOREIGN KEY (`fk_osoba`) REFERENCES `PERS_OSOBY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `pc` FOREIGN KEY (`fk_clenstvi`) REFERENCES `PERS_CLENSTVI` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Omezení pro tabulku `PERS_FUNKCE` -- ALTER TABLE `PERS_FUNKCE` ADD CONSTRAINT `op` FOREIGN KEY (`fk_osoba`) REFERENCES `PERS_OSOBY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `pp` FOREIGN KEY (`fk_pozice`) REFERENCES `PERS_POZICE` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Omezení pro tabulku `PERS_OSOBY` -- ALTER TABLE `PERS_OSOBY` ADD CONSTRAINT `skolitel` FOREIGN KEY (`dokt_fk_skolitel`) REFERENCES `PERS_OSOBY` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Omezení pro tabulku `PUBL_AUTORI` -- ALTER TABLE `PUBL_AUTORI` ADD CONSTRAINT `aut` FOREIGN KEY (`fk_osoba`) REFERENCES `PERS_OSOBY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `pub` FOREIGN KEY (`fk_publikace`) REFERENCES `PUBL_ZAZNAMY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Omezení pro tabulku `PUBL_CITACE` -- ALTER TABLE `PUBL_CITACE` ADD CONSTRAINT `cit` FOREIGN KEY (`fk_publikace`) REFERENCES `PUBL_ZAZNAMY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `tyc` FOREIGN KEY (`fk_typ`) REFERENCES `PUBL_TYPY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Omezení pro tabulku `PUBL_CLANEK` -- ALTER TABLE `PUBL_CLANEK` ADD CONSTRAINT `pca` FOREIGN KEY (`fk_casopis`) REFERENCES `PUBL_CASOPISY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `pcl` FOREIGN KEY (`fk_publ`) REFERENCES `PUBL_ZAZNAMY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Omezení pro tabulku `PUBL_KNIHA` -- ALTER TABLE `PUBL_KNIHA` ADD CONSTRAINT `pkn` FOREIGN KEY (`fk_publ`) REFERENCES `PUBL_ZAZNAMY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `pvyk` FOREIGN KEY (`fk_vydavatel`) REFERENCES `PUBL_VYDAVATELE` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Omezení pro tabulku `PUBL_PHD` -- ALTER TABLE `PUBL_PHD` ADD CONSTRAINT `pth` FOREIGN KEY (`fk_publ`) REFERENCES `PUBL_ZAZNAMY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Omezení pro tabulku `PUBL_PRISPEVEK` -- ALTER TABLE `PUBL_PRISPEVEK` ADD CONSTRAINT `ppr` FOREIGN KEY (`fk_publ`) REFERENCES `PUBL_ZAZNAMY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `pvy` FOREIGN KEY (`fk_vydavatel`) REFERENCES `PUBL_VYDAVATELE` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Omezení pro tabulku `PUBL_SOUBORY` -- ALTER TABLE `PUBL_SOUBORY` ADD CONSTRAINT `sog` FOREIGN KEY (`fk_grant`) REFERENCES `VYZK_GRANTY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `sou` FOREIGN KEY (`fk_publikace`) REFERENCES `PUBL_ZAZNAMY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `ts` FOREIGN KEY (`fk_tema`) REFERENCES `STUD_TEMATA` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Omezení pro tabulku `PUBL_TECHREPORT` -- ALTER TABLE `PUBL_TECHREPORT` ADD CONSTRAINT `ptr` FOREIGN KEY (`fk_publ`) REFERENCES `PUBL_ZAZNAMY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Omezení pro tabulku `PUBL_ZAZNAMY` -- ALTER TABLE `PUBL_ZAZNAMY` ADD CONSTRAINT `gp` FOREIGN KEY (`fk_grant`) REFERENCES `VYZK_GRANTY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `tyb` FOREIGN KEY (`fk_typ`) REFERENCES `PUBL_TYPY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Omezení pro tabulku `STUD_OBORY` -- ALTER TABLE `STUD_OBORY` ADD CONSTRAINT `pgo` FOREIGN KEY (`fk_program`) REFERENCES `STUD_PROGRAMY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Omezení pro tabulku `STUD_PREDM_OBOR` -- ALTER TABLE `STUD_PREDM_OBOR` ADD CONSTRAINT `oo` FOREIGN KEY (`fk_obor`) REFERENCES `STUD_OBORY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `po` FOREIGN KEY (`fk_predmet`) REFERENCES `STUD_PREDMETY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Omezení pro tabulku `STUD_TEMATA` -- ALTER TABLE `STUD_TEMATA` ADD CONSTRAINT `tt` FOREIGN KEY (`fk_typ_prace`) REFERENCES `STUD_TEMATA_TYPY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `tto` FOREIGN KEY (`fk_obor`) REFERENCES `STUD_OBORY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `vypsal` FOREIGN KEY (`fk_garant`) REFERENCES `PERS_OSOBY` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Omezení pro tabulku `STUD_VYUCUJE` -- ALTER TABLE `STUD_VYUCUJE` ADD CONSTRAINT `ov` FOREIGN KEY (`fk_osoba`) REFERENCES `PERS_OSOBY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `vp` FOREIGN KEY (`fk_predmet`) REFERENCES `STUD_PREDMETY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Omezení pro tabulku `STUD_ZAVERECNE_PRACE` -- ALTER TABLE `STUD_ZAVERECNE_PRACE` ADD CONSTRAINT `tz` FOREIGN KEY (`fk_tema`) REFERENCES `STUD_TEMATA` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Omezení pro tabulku `UDALOSTI` -- ALTER TABLE `UDALOSTI` ADD CONSTRAINT `aud` FOREIGN KEY (`fk_kontaktni_osoba`) REFERENCES `PERS_OSOBY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Omezení pro tabulku `VYZK_GRANTY` -- ALTER TABLE `VYZK_GRANTY` ADD CONSTRAINT `gs` FOREIGN KEY (`fk_skupina`) REFERENCES `VYZK_SKUPINY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `gt` FOREIGN KEY (`fk_typ`) REFERENCES `VYZK_GRANTY_TYPY` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Omezení pro tabulku `VYZK_GRANTY_OSOB` -- ALTER TABLE `VYZK_GRANTY_OSOB` ADD CONSTRAINT `go` FOREIGN KEY (`fk_grant`) REFERENCES `VYZK_GRANTY` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `og` FOREIGN KEY (`fk_osoba`) REFERENCES `PERS_OSOBY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Omezení pro tabulku `VYZK_SKUPINY` -- ALTER TABLE `VYZK_SKUPINY` ADD CONSTRAINT `st` FOREIGN KEY (`fk_typ`) REFERENCES `VYZK_SKUPINY_TYPY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Omezení pro tabulku `VYZK_SKUPINY_OSOB` -- ALTER TABLE `VYZK_SKUPINY_OSOB` ADD CONSTRAINT `os` FOREIGN KEY (`fk_osoba`) REFERENCES `PERS_OSOBY` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `so` FOREIGN KEY (`fk_skupina`) REFERENCES `VYZK_SKUPINY` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;