CREATE TABLE KIV_UDALOSTI (
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    fk_kontaktni_osoba INT NOT NULL,
    nazev_en VARCHAR(100) NOT NULL,
    nazev_cz VARCHAR(100),
    popis_en TEXT,
    popis_cz TEXT,
    datum_konec DATE,
    misto_cz VARCHAR(255),
    datum_zacatek DATE,
    je_stala BOOL,
    url VARCHAR(255),
    misto_en VARCHAR(255),
    zaznam_datum DATE,
    zaznam_editor INT,
    zaznam_aktivni BOOL
) ENGINE=InnoDB;
CREATE TABLE KIV_PERS_OSOBY (
    id INT NOT NULL,
    login VARCHAR(20) NOT NULL,
    jmeno VARCHAR(80),
    telefon_ext VARCHAR(20),
    tituly_za VARCHAR(40),
    tituly_pred VARCHAR(40),
    email VARCHAR(100) NOT NULL,
    je_externi INT,
    ext_pracoviste_cz VARCHAR(255),
    ext_pracoviste_en VARCHAR(255),
    url VARCHAR(255),
    kancelar VARCHAR(10),
    telefon_zcu INT NOT NULL,
    uredni_hodiny VARCHAR(255),
    prijmeni VARCHAR(80) NOT NULL,
    je_doktorand INT,
    dokt_fk_skolitel INT,
    dokt_rok_nastupu INT,
    zaznam_editor INT,
    zaznam_datum DATE,
    zaznam_aktivni BOOL
) ENGINE=InnoDB;
ALTER TABLE KIV_PERS_OSOBY ADD CONSTRAINT pk_osoba PRIMARY KEY(id);
CREATE TABLE KIV_STUD_TEMATA (
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    fk_garant INT NOT NULL,
    fk_typ_prace INT NOT NULL,
    fk_obor INT NOT NULL,
    nazev_cz VARCHAR(255) NOT NULL,
    nazev_en VARCHAR(255),
    popis_cz TEXT,
    popis_en TEXT,
    url VARCHAR(255),
    je_externi INT NOT NULL,
    ext_vedouci VARCHAR(255),
    ext_organizace VARCHAR(255),
    zaznam_editor INT,
    zaznam_datum DATE,
    zaznam_aktivni BOOL,
    kdy_rezervovano DATE,
    kdy_zverejnit DATE,
    pro_akad_rok VARCHAR(9),
    zadano_email VARCHAR(100),
    kdy_vypsano DATE,
    zadano_jmeno VARCHAR(100),
    zadano_osobni_cislo VARCHAR(10),
    kdy_odevzdano DATE,
    fk_stav INT NOT NULL,
    kdy_obhajeno DATE
) ENGINE=InnoDB;
CREATE TABLE KIV_PERS_AKTIVITY_OSOB (
    fk_osoba INT NOT NULL,
    fk_aktivita INT NOT NULL,
    do DATE,
    od DATE
) ENGINE=InnoDB;
ALTER TABLE KIV_PERS_AKTIVITY_OSOB ADD CONSTRAINT fk_osoba PRIMARY KEY(fk_osoba,fk_aktivita);
CREATE TABLE KIV_PERS_AKTIVITY (
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    nazev_cz VARCHAR(255) NOT NULL,
    nazev_en VARCHAR(255) NOT NULL,
    poradi INT,
    popis_cz TEXT,
    popis_en TEXT
) ENGINE=InnoDB;
CREATE TABLE KIV_VYZK_GRANTY (
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    fk_typ INT NOT NULL,
    nazev_cz VARCHAR(255) NOT NULL,
    nazev_en VARCHAR(255),
    popis_cz TEXT NOT NULL,
    popis_en TEXT NOT NULL,
    info_cz TEXT,
    info_en TEXT,
    url VARCHAR(255),
    datum_zahajeni DATE NOT NULL,
    datum_ukonceni DATE NOT NULL,
    dotace_castka BIGINT,
    dotace_mena VARCHAR(3),
    identifikacni_kod VARCHAR(100),
    je_ukoncen BOOL,
    je_kiv_hlavni_resitel BOOL,
    fk_skupina INT,
    zaznam_datum DATE,
    zaznam_editor INT,
    zaznam_aktivni BOOL,
    dotace_zdroj VARCHAR(255),
    vysledky_cz TEXT,
    vysledky_en TEXT
) ENGINE=InnoDB;
CREATE TABLE KIV_VYZK_GRANTY_OSOB (
    fk_osoba INT NOT NULL,
    fk_grant INT NOT NULL,
    je_vedoucim BOOL
) ENGINE=InnoDB;
ALTER TABLE KIV_VYZK_GRANTY_OSOB ADD CONSTRAINT fk_osoba PRIMARY KEY(fk_osoba,fk_grant);
CREATE TABLE KIV_VYZK_GRANTY_TYPY (
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    nazev_cz VARCHAR(255),
    nazev_en VARCHAR(255)
) ENGINE=InnoDB;
CREATE TABLE KIV_VYZK_SKUPINY (
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    nazev_cz VARCHAR(255) NOT NULL,
    nazev_en VARCHAR(255),
    popis_cz TEXT,
    popis_en TEXT,
    url VARCHAR(255),
    fk_typ INT,
    zaznam_aktivni BOOL,
    datum_zruseni DATE,
    zaznam_editor INT,
    zaznam_datum DATE,
    datum_zalozeni DATE
) ENGINE=InnoDB;
CREATE TABLE KIV_VYZK_SKUPINY_OSOB (
    fk_osoba INT,
    fk_skupina INT,
    je_vedoucim BOOL
) ENGINE=InnoDB;
ALTER TABLE KIV_VYZK_SKUPINY_OSOB ADD CONSTRAINT fk_osoba PRIMARY KEY(fk_osoba,fk_skupina);
CREATE TABLE KIV_VYZK_SKUPINY_TYPY (
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    nazev_cz VARCHAR(255),
    nazev_en VARCHAR(255)
) ENGINE=InnoDB;
CREATE TABLE KIV_PERS_CLENSTVI_OSOB (
    fk_osoba INT,
    fk_clenstvi INT,
    od DATE,
    do DATE
) ENGINE=InnoDB;
ALTER TABLE KIV_PERS_CLENSTVI_OSOB ADD CONSTRAINT fk_osoba_clenstvi PRIMARY KEY(fk_osoba,fk_clenstvi);
CREATE TABLE KIV_PERS_FUNKCE (
    fk_osoba INT,
    fk_pozice INT,
    od DATE,
    do DATE
) ENGINE=InnoDB;
ALTER TABLE KIV_PERS_FUNKCE ADD CONSTRAINT osoba_pozice PRIMARY KEY(fk_osoba,fk_pozice);
CREATE TABLE KIV_PERS_CLENSTVI (
    id INT PRIMARY KEY AUTO_INCREMENT,
    nazev_cz VARCHAR(255) NOT NULL,
    nazev_en VARCHAR(255) NOT NULL,
    poradi INT
) ENGINE=InnoDB;
CREATE TABLE KIV_PERS_POZICE (
    id INT PRIMARY KEY AUTO_INCREMENT,
    nazev_cz VARCHAR(255) NOT NULL,
    poradi INT,
    popis_en TEXT,
    popis_cz TEXT,
    nazev_en VARCHAR(255) NOT NULL,
    fk_kategorie INT
) ENGINE=InnoDB;
CREATE TABLE KIV_STUD_TEMATA_TYPY (
    id INT AUTO_INCREMENT PRIMARY KEY,
    zkratka VARCHAR(10) NOT NULL,
    nazev_cz VARCHAR(255) NOT NULL,
    nazev_en VARCHAR(255) NOT NULL,
    je_zaverecna BOOL
) ENGINE=InnoDB;
CREATE TABLE KIV_STUD_TEMATA_STAVY (
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    nazev_cz VARCHAR(20)
) ENGINE=InnoDB;
CREATE TABLE KIV_STUD_PREDMETY (
    id INT PRIMARY KEY AUTO_INCREMENT,
    zkratka VARCHAR(10) NOT NULL,
    nazev_cz VARCHAR(255) NOT NULL,
    katedra VARCHAR(10) NOT NULL DEFAULT 'KIV',
    url VARCHAR(255),
    rok_varianty INT,
    semestr VARCHAR(10),
    je_vyucovan BOOL,
    zaznam_aktivni BOOL,
    zaznam_editor INT,
    zaznam_datum DATE,
    nazev_en VARCHAR(255) NOT NULL
) ENGINE=InnoDB;
CREATE TABLE KIV_STUD_VYUCUJE (
    fk_osoba INT,
    fk_predmet INT,
    je_prednasejici BOOL
) ENGINE=InnoDB;
ALTER TABLE KIV_STUD_VYUCUJE ADD CONSTRAINT pk_vyucuje PRIMARY KEY(fk_osoba,fk_predmet);
CREATE TABLE KIV_STUD_OBORY (
    id INT PRIMARY KEY AUTO_INCREMENT,
    fk_program INT,
    zkratka VARCHAR(10) NOT NULL,
    nazev_cz VARCHAR(255) NOT NULL,
    nazev_en VARCHAR(255) NOT NULL,
    zaznam_datum DATE,
    zaznam_editor INT,
    zaznam_aktivni BOOL
) ENGINE=InnoDB;
CREATE TABLE KIV_STUD_PREDM_OBOR (
    fk_predmet INT,
    fk_obor INT,
    status VARCHAR(1)
) ENGINE=InnoDB;
ALTER TABLE KIV_STUD_PREDM_OBOR ADD CONSTRAINT pk_predm_obor PRIMARY KEY(fk_predmet,fk_obor);
CREATE TABLE KIV_STUD_PROGRAMY (
    id INT PRIMARY KEY AUTO_INCREMENT,
    zkratka VARCHAR(10) NOT NULL,
    nazev_cz VARCHAR(255) NOT NULL,
    nazev_en VARCHAR(255) NOT NULL,
    forma VARCHAR(1),
    zaznam_editor INT,
    zaznam_datum DATE,
    zaznam_aktivni BOOL
) ENGINE=InnoDB;
CREATE TABLE KIV_PUBL_ZAZNAMY (
    id INT PRIMARY KEY AUTO_INCREMENT,
    fk_grant INT,
    nazev VARCHAR(255) NOT NULL,
    zaznam_datum DATE,
    zaznam_aktivni BOOL,
    zaznam_editor INT,
    rok INT NOT NULL,
    poznamka VARCHAR(255),
    mesic INT,
    adresa VARCHAR(255),
    autori VARCHAR(255),
    fk_typ INT,
    url VARCHAR(255),
    RIV_anotace_en TEXT,
    RIV_nazev_en VARCHAR(255),
    RIV_anotace_cz TEXT,
    RIV_fk_jazyk VARCHAR(3),
    RIV_fk_obor INT,
    RIV_klicslova_cz VARCHAR(255),
    RIV_nazev_cz VARCHAR(255),
    abstrakt TEXT,
    RIV_klicslova_en VARCHAR(255),
    RIV_evidovano BOOL,
    klicslova VARCHAR(255)
) ENGINE=InnoDB;
CREATE TABLE KIV_PUBL_CITACE (
    id INT PRIMARY KEY AUTO_INCREMENT,
    autori VARCHAR(255),
    nazev VARCHAR(255) NOT NULL,
    sbornik VARCHAR(255),
    vydavatel VARCHAR(255),
    rok INT NOT NULL,
    url VARCHAR(255),
    fk_publikace INT NOT NULL,
    zaznam_datum DATE,
    zaznam_editor INT,
    zaznam_aktivni BOOL,
    fk_typ INT
) ENGINE=InnoDB;
CREATE TABLE KIV_PUBL_SOUBORY (
    id INT PRIMARY KEY AUTO_INCREMENT,
    resource_uri VARCHAR(255),
    pocet_stazeni INT,
    popis_cz TEXT,
    popis_en TEXT,
    fk_publikace INT,
    zaznam_datum DATE,
    zaznam_editor INT,
    zaznam_aktivni BOOL,
    fk_tema INT,
    fk_grant INT,
    fk_produkt INT,
    nazev_cz VARCHAR(255) NOT NULL,
    nazev_en VARCHAR(255) NOT NULL,
    typ VARCHAR(100),
    velikost INT
) ENGINE=InnoDB;
CREATE TABLE KIV_PUBL_AUTORI (
    fk_publikace INT,
    fk_osoba INT,
    je_hlavni_autor BOOL
) ENGINE=InnoDB;
ALTER TABLE KIV_PUBL_AUTORI ADD CONSTRAINT pk_publaut PRIMARY KEY(fk_publikace,fk_osoba);
CREATE TABLE KIV_PUBL_TECHREPORTY (
    fk_publ INT NOT NULL,
    cislo VARCHAR(7)
) ENGINE=InnoDB;
CREATE TABLE KIV_PUBL_PRISPEVKY (
    fk_publ INT NOT NULL,
    nazev_sborniku VARCHAR(255),
    editori VARCHAR(100),
    stranky VARCHAR(10),
    fk_vydavatel INT,
    RIV_edice VARCHAR(50),
    strana_do INT,
    misto VARCHAR(255),
    isbn VARCHAR(20),
    instituce VARCHAR(255),
    strana_od INT,
    RIV_fk_typ_akce INT,
    issn VARCHAR(9),
    RIV_kod_isi VARCHAR(255)
) ENGINE=InnoDB;
CREATE TABLE KIV_PUBL_VYDAVATELE (
    id INT PRIMARY KEY AUTO_INCREMENT,
    nazev VARCHAR(255) NOT NULL,
    zeme VARCHAR(100)
) ENGINE=InnoDB;
CREATE TABLE KIV_PUBL_CLANKY (
    fk_publ INT NOT NULL,
    cislo INT,
    svazek INT,
    fk_casopis INT,
    strana_do INT,
    strana_od INT,
    RIV_zeme VARCHAR(255),
    RIV_rocnik INT,
    RIV_kod_isi VARCHAR(255)
) ENGINE=InnoDB;
CREATE TABLE KIV_PUBL_CASOPISY (
    id INT PRIMARY KEY AUTO_INCREMENT,
    nazev VARCHAR(255),
    fk_vydavatel INT,
    issn VARCHAR(9)
) ENGINE=InnoDB;
CREATE TABLE KIV_PUBL_KNIHY (
    fk_publ INT,
    je_autor_editorem BOOL,
    fk_vydavatel INT,
    svazek INT,
    edicni_rada VARCHAR(100),
    vydani INT,
    isbn VARCHAR(20),
    pocet_stran INT
) ENGINE=InnoDB;
CREATE TABLE KIV_PUBL_DISERTACE (
    fk_publ INT NOT NULL,
    datum_obhajoby DATE
) ENGINE=InnoDB;
CREATE TABLE KIV_PUBL_TYPY (
    id INT PRIMARY KEY AUTO_INCREMENT,
    typ VARCHAR(10),
    poradi INT,
    nazev_en VARCHAR(255),
    nazev_cz VARCHAR(255)
) ENGINE=InnoDB;
CREATE TABLE KIV_PERS_KATEGORIE (
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    nazev_cz VARCHAR(40) NOT NULL,
    nazev_en VARCHAR(40) NOT NULL
) ENGINE=InnoDB;
CREATE TABLE KIV_PUBL_SBORNIKY (
    fk_vydavatel INT,
    fk_publ INT,
    instituce VARCHAR(255),
    isbn VARCHAR(20),
    issn VARCHAR(9)
) ENGINE=InnoDB;
CREATE TABLE KIV_PUBL_MISC (
    fk_publ INT NOT NULL,
    jak_publikovano VARCHAR(255)
) ENGINE=InnoDB;
CREATE TABLE KIV_PUBL_HABILITACNI (
    fk_publ INT NOT NULL,
    datum_obhajoby DATE
) ENGINE=InnoDB;
CREATE TABLE KIV_PUBL_RIV_CISELNIKY (
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    oblast VARCHAR(50),
    hodnota VARCHAR(255)
) ENGINE=InnoDB;
CREATE TABLE KIV_PROD_PRODUKTY (
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    nazev_cz VARCHAR(255) NOT NULL,
    nazev_en VARCHAR(255) NOT NULL,
    popis_cz TEXT,
    popis_en TEXT,
    stav VARCHAR(30),
    komentar_neschvaleno TEXT,
    pocet_stazeni INT,
    velikost INT,
    fk_licence INT NOT NULL,
    fk_grant INT,
    fk_osoba_autor INT NOT NULL,
    fk_osoba_schvalil INT NOT NULL,
    zaznam_editor INT,
    zaznam_datum DATE,
    zaznam_aktivni TINYINT
) ENGINE=InnoDB;
CREATE TABLE KIV_PROD_LICENCE (
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    nazev_cz VARCHAR(255) NOT NULL,
    nazev_en VARCHAR(255) NOT NULL,
    text TEXT,
    url VARCHAR(255),
    zkratka VARCHAR(10),
    zaznam_editor INT,
    zaznam_datum DATE,
    zaznam_aktivni TINYINT
) ENGINE=InnoDB;
CREATE TABLE KIV_PROD_LOG_STAHOVANI (
    kdy TIMESTAMP,
    ip4 VARCHAR(15),
    ip6 VARCHAR(39),
    user_agent VARCHAR(255),
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    fk_produkt INT NOT NULL
) ENGINE=InnoDB;
CREATE TABLE KIV_PUBL_EXTERNISTE (
    id INT NOT NULL auto_increment primary key,
    jmeno VARCHAR(255),
    prijmeni VARCHAR(255) NOT NULL,
    instituce VARCHAR(255)
) ENGINE=InnoDB;
CREATE TABLE KIV_PUBL_EXTAUTORI (
    fk_publikace INT NOT NULL,
    fk_extautor INT,
    je_hlavni_autor BOOL
) ENGINE=InnoDB;
ALTER TABLE KIV_PUBL_EXTAUTORI ADD CONSTRAINT pk_publ_extautori PRIMARY KEY(fk_publikace,fk_extautor);
ALTER TABLE KIV_UDALOSTI ADD CONSTRAINT aud FOREIGN KEY (fk_kontaktni_osoba) REFERENCES KIV_PERS_OSOBY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_STUD_TEMATA ADD CONSTRAINT vypsal FOREIGN KEY (fk_garant) REFERENCES KIV_PERS_OSOBY(id) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE KIV_PERS_OSOBY ADD CONSTRAINT skolitel FOREIGN KEY (dokt_fk_skolitel) REFERENCES KIV_PERS_OSOBY(id) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE KIV_VYZK_SKUPINY_OSOB ADD CONSTRAINT os FOREIGN KEY (fk_osoba) REFERENCES KIV_PERS_OSOBY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_VYZK_SKUPINY_OSOB ADD CONSTRAINT so FOREIGN KEY (fk_skupina) REFERENCES KIV_VYZK_SKUPINY(id) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE KIV_VYZK_GRANTY_OSOB ADD CONSTRAINT og FOREIGN KEY (fk_osoba) REFERENCES KIV_PERS_OSOBY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_VYZK_GRANTY_OSOB ADD CONSTRAINT go FOREIGN KEY (fk_grant) REFERENCES KIV_VYZK_GRANTY(id) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE KIV_PERS_AKTIVITY_OSOB ADD CONSTRAINT oa FOREIGN KEY (fk_osoba) REFERENCES KIV_PERS_OSOBY(id) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE KIV_PERS_AKTIVITY_OSOB ADD CONSTRAINT ao FOREIGN KEY (fk_aktivita) REFERENCES KIV_PERS_AKTIVITY(id) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE KIV_VYZK_GRANTY ADD CONSTRAINT gt FOREIGN KEY (fk_typ) REFERENCES KIV_VYZK_GRANTY_TYPY(id) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE KIV_VYZK_GRANTY ADD CONSTRAINT gs FOREIGN KEY (fk_skupina) REFERENCES KIV_VYZK_SKUPINY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_PERS_CLENSTVI_OSOB ADD CONSTRAINT co FOREIGN KEY (fk_osoba) REFERENCES KIV_PERS_OSOBY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_PERS_CLENSTVI_OSOB ADD CONSTRAINT pc FOREIGN KEY (fk_clenstvi) REFERENCES KIV_PERS_CLENSTVI(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_PERS_FUNKCE ADD CONSTRAINT op FOREIGN KEY (fk_osoba) REFERENCES KIV_PERS_OSOBY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_PERS_FUNKCE ADD CONSTRAINT pp FOREIGN KEY (fk_pozice) REFERENCES KIV_PERS_POZICE(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_STUD_TEMATA ADD CONSTRAINT tt FOREIGN KEY (fk_typ_prace) REFERENCES KIV_STUD_TEMATA_TYPY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_STUD_VYUCUJE ADD CONSTRAINT ov FOREIGN KEY (fk_osoba) REFERENCES KIV_PERS_OSOBY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_STUD_VYUCUJE ADD CONSTRAINT vp FOREIGN KEY (fk_predmet) REFERENCES KIV_STUD_PREDMETY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_STUD_PREDM_OBOR ADD CONSTRAINT po FOREIGN KEY (fk_predmet) REFERENCES KIV_STUD_PREDMETY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_STUD_PREDM_OBOR ADD CONSTRAINT oo FOREIGN KEY (fk_obor) REFERENCES KIV_STUD_OBORY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_STUD_OBORY ADD CONSTRAINT pgo FOREIGN KEY (fk_program) REFERENCES KIV_STUD_PROGRAMY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_STUD_TEMATA ADD CONSTRAINT temata_obory FOREIGN KEY (fk_obor) REFERENCES KIV_STUD_OBORY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_PUBL_AUTORI ADD CONSTRAINT aut FOREIGN KEY (fk_osoba) REFERENCES KIV_PERS_OSOBY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_PUBL_AUTORI ADD CONSTRAINT pub FOREIGN KEY (fk_publikace) REFERENCES KIV_PUBL_ZAZNAMY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_PUBL_CITACE ADD CONSTRAINT cit FOREIGN KEY (fk_publikace) REFERENCES KIV_PUBL_ZAZNAMY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_PUBL_SOUBORY ADD CONSTRAINT sou FOREIGN KEY (fk_publikace) REFERENCES KIV_PUBL_ZAZNAMY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_PUBL_ZAZNAMY ADD CONSTRAINT gp FOREIGN KEY (fk_grant) REFERENCES KIV_VYZK_GRANTY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_VYZK_SKUPINY ADD CONSTRAINT st FOREIGN KEY (fk_typ) REFERENCES KIV_VYZK_SKUPINY_TYPY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_PUBL_TECHREPORTY ADD CONSTRAINT ptr FOREIGN KEY (fk_publ) REFERENCES KIV_PUBL_ZAZNAMY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_PUBL_PRISPEVKY ADD CONSTRAINT ppr FOREIGN KEY (fk_publ) REFERENCES KIV_PUBL_ZAZNAMY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_PUBL_CLANKY ADD CONSTRAINT pcl FOREIGN KEY (fk_publ) REFERENCES KIV_PUBL_ZAZNAMY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_PUBL_PRISPEVKY ADD CONSTRAINT pvy FOREIGN KEY (fk_vydavatel) REFERENCES KIV_PUBL_VYDAVATELE(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_PUBL_CLANKY ADD CONSTRAINT pca FOREIGN KEY (fk_casopis) REFERENCES KIV_PUBL_CASOPISY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_PUBL_KNIHY ADD CONSTRAINT pkn FOREIGN KEY (fk_publ) REFERENCES KIV_PUBL_ZAZNAMY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_PUBL_KNIHY ADD CONSTRAINT pvyk FOREIGN KEY (fk_vydavatel) REFERENCES KIV_PUBL_VYDAVATELE(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_PUBL_DISERTACE ADD CONSTRAINT pth FOREIGN KEY (fk_publ) REFERENCES KIV_PUBL_ZAZNAMY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_PUBL_CITACE ADD CONSTRAINT tyc FOREIGN KEY (fk_typ) REFERENCES KIV_PUBL_TYPY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_PUBL_ZAZNAMY ADD CONSTRAINT tyb FOREIGN KEY (fk_typ) REFERENCES KIV_PUBL_TYPY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_PUBL_SOUBORY ADD CONSTRAINT ts FOREIGN KEY (fk_tema) REFERENCES KIV_STUD_TEMATA(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_PUBL_SOUBORY ADD CONSTRAINT sog FOREIGN KEY (fk_grant) REFERENCES KIV_VYZK_GRANTY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_STUD_TEMATA ADD CONSTRAINT tstav FOREIGN KEY (fk_stav) REFERENCES KIV_STUD_TEMATA_STAVY(id) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE KIV_PERS_POZICE ADD CONSTRAINT ppozkat FOREIGN KEY (fk_kategorie) REFERENCES KIV_PERS_KATEGORIE(id) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE KIV_PUBL_SBORNIKY ADD CONSTRAINT psb FOREIGN KEY (fk_publ) REFERENCES KIV_PUBL_ZAZNAMY(id) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE KIV_PUBL_MISC ADD CONSTRAINT pmiz FOREIGN KEY (fk_publ) REFERENCES KIV_PUBL_ZAZNAMY(id) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE KIV_PUBL_HABILITACNI ADD CONSTRAINT phza FOREIGN KEY (fk_publ) REFERENCES KIV_PUBL_ZAZNAMY(id) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE KIV_PUBL_SBORNIKY ADD CONSTRAINT psbv FOREIGN KEY (fk_vydavatel) REFERENCES KIV_PUBL_VYDAVATELE(id) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE KIV_PUBL_ZAZNAMY ADD CONSTRAINT pzario FOREIGN KEY (RIV_fk_obor) REFERENCES KIV_PUBL_RIV_CISELNIKY(id) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE KIV_PUBL_ZAZNAMY ADD CONSTRAINT pzarja FOREIGN KEY (RIV_fk_jazyk) REFERENCES KIV_PUBL_RIV_CISELNIKY(id) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE KIV_PUBL_CASOPISY ADD CONSTRAINT pcasvyd FOREIGN KEY (fk_vydavatel) REFERENCES KIV_PUBL_VYDAVATELE(id) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE KIV_PROD_PRODUKTY ADD CONSTRAINT licence_produktu FOREIGN KEY (fk_licence) REFERENCES KIV_PROD_LICENCE(id) ON DELETE SET NULL ON UPDATE SET NULL;
ALTER TABLE KIV_PUBL_SOUBORY ADD CONSTRAINT soubory_produktu FOREIGN KEY (fk_produkt) REFERENCES KIV_PROD_PRODUKTY(id) ON DELETE SET NULL ON UPDATE SET NULL;
ALTER TABLE KIV_PROD_LOG_STAHOVANI ADD CONSTRAINT produkt_log FOREIGN KEY (fk_produkt) REFERENCES KIV_PROD_PRODUKTY(id) ON DELETE SET NULL ON UPDATE SET NULL;
ALTER TABLE KIV_PROD_PRODUKTY ADD CONSTRAINT grant_produktu FOREIGN KEY (fk_grant) REFERENCES KIV_VYZK_GRANTY(id) ON DELETE SET NULL ON UPDATE SET NULL;
ALTER TABLE KIV_PROD_PRODUKTY ADD CONSTRAINT produkt_autor FOREIGN KEY (fk_osoba_autor) REFERENCES KIV_PERS_OSOBY(id) ON DELETE SET NULL ON UPDATE SET NULL;
ALTER TABLE KIV_PROD_PRODUKTY ADD CONSTRAINT produkt_schvalovatel FOREIGN KEY (fk_osoba_schvalil) REFERENCES KIV_PERS_OSOBY(id) ON DELETE SET NULL ON UPDATE SET NULL;
ALTER TABLE KIV_PUBL_EXTAUTORI ADD CONSTRAINT publ_extautor FOREIGN KEY (fk_publikace) REFERENCES KIV_PUBL_ZAZNAMY(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE KIV_PUBL_EXTAUTORI ADD CONSTRAINT extautor_publ FOREIGN KEY (fk_extautor) REFERENCES KIV_PUBL_EXTERNISTE(id) ON DELETE NO ACTION ON UPDATE NO ACTION;