CREATE TABLE KIV_UDALOSTI ( id INT NOT NULL, fk_kontaktni_osoba INT NOT NULL, nazev_en VARCHAR(100) NOT NULL, nazev_cz VARCHAR(100), popis_en VARCHAR(255), popis_cz VARCHAR(255), datum_konec DATE, misto_cz VARCHAR(255), datum_zacatek DATE, je_stala BOOL DEFAULT false, url VARCHAR(255), misto_en VARCHAR(255), zaznam_datum DATE, zaznam_editor INT, zaznam_aktivni BOOL ) ENGINE=InnoDB; ALTER TABLE KIV_UDALOSTI ADD CONSTRAINT pk_udalost PRIMARY KEY(id); 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, 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_oscislo VARCHAR(10), kdy_dokonceno DATE, fk_stav INT NOT NULL, kdy_obhajeno DATE ) ENGINE=InnoDB; ALTER TABLE KIV_STUD_TEMATA ADD CONSTRAINT pk_temata PRIMARY KEY(id); 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, nazev_cz VARCHAR(255) NOT NULL, nazev_en VARCHAR(255) NOT NULL, poradi INT ) ENGINE=InnoDB; ALTER TABLE KIV_PERS_AKTIVITY ADD CONSTRAINT pk_id PRIMARY KEY(id); CREATE TABLE KIV_VYZK_GRANTY ( id INT NOT NULL, 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; ALTER TABLE KIV_VYZK_GRANTY ADD CONSTRAINT pk_id PRIMARY KEY(id); CREATE TABLE KIV_VYZK_GRANTY_OSOB ( fk_osoba INT NOT NULL, fk_grant INT NOT NULL, je_vedoucim BOOL DEFAULT false ) 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, nazev_cz VARCHAR(255), nazev_en VARCHAR(255) ) ENGINE=InnoDB; ALTER TABLE KIV_VYZK_GRANTY_TYPY ADD CONSTRAINT pk_id PRIMARY KEY(id); CREATE TABLE KIV_VYZK_SKUPINY ( id INT NOT NULL, 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; ALTER TABLE KIV_VYZK_SKUPINY ADD CONSTRAINT pk_id PRIMARY KEY(id); 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, nazev_cz VARCHAR(255), nazev_en VARCHAR(255) ) ENGINE=InnoDB; ALTER TABLE KIV_VYZK_SKUPINY_TYPY ADD CONSTRAINT pk_id PRIMARY KEY(id); 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, nazev_cz VARCHAR(255) NOT NULL, nazev_en VARCHAR(255) NOT NULL, poradi INT ) ENGINE=InnoDB; ALTER TABLE KIV_PERS_CLENSTVI ADD CONSTRAINT pk_clenstvi PRIMARY KEY(id); CREATE TABLE KIV_PERS_POZICE ( id INT, nazev_cz VARCHAR(255) NOT NULL, poradi INT, popis_en VARCHAR(255), popis_cz VARCHAR(255), nazev_en VARCHAR(255) NOT NULL, fk_kategorie INT ) ENGINE=InnoDB; ALTER TABLE KIV_PERS_POZICE ADD CONSTRAINT pk_pozice PRIMARY KEY(id); CREATE TABLE KIV_STUD_TEMATA_TYPY ( id INT, zkratka VARCHAR(10) NOT NULL, nazev_cz VARCHAR(255) NOT NULL, nazev_en VARCHAR(255) NOT NULL, je_zaverecna BOOL ) ENGINE=InnoDB; ALTER TABLE KIV_STUD_TEMATA_TYPY ADD CONSTRAINT pk_typ PRIMARY KEY(id); CREATE TABLE KIV_STUD_TEMATA_STAVY ( id INT NOT NULL, nazev_cz VARCHAR(20) ) ENGINE=InnoDB; ALTER TABLE KIV_STUD_TEMATA_STAVY ADD CONSTRAINT pk_stav PRIMARY KEY(id); CREATE TABLE KIV_STUD_PREDMETY ( id INT, 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; ALTER TABLE KIV_STUD_PREDMETY ADD CONSTRAINT pk_predmet PRIMARY KEY(id); 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, 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; ALTER TABLE KIV_STUD_OBORY ADD CONSTRAINT pk_obor PRIMARY KEY(id); 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, 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; ALTER TABLE KIV_STUD_PROGRAMY ADD CONSTRAINT pk_program PRIMARY KEY(id); CREATE TABLE KIV_PUBL_ZAZNAMY ( id INT, fk_grant INT, ext_autori VARCHAR(255), 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_komplet VARCHAR(255), fk_typ INT ) ENGINE=InnoDB; ALTER TABLE KIV_PUBL_ZAZNAMY ADD CONSTRAINT pk_publ PRIMARY KEY(id); CREATE TABLE KIV_PUBL_CITACE ( id INT, 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; ALTER TABLE KIV_PUBL_CITACE ADD CONSTRAINT pk_citace PRIMARY KEY(id); CREATE TABLE KIV_PUBL_SOUBORY ( id INT, filename VARCHAR(255), pocet_stazeni INT, url_licence VARCHAR(255), popis_cz TEXT, popis_en TEXT, fk_publikace INT, zaznam_datum DATE, zaznam_editor INT, zaznam_aktivni BOOL, fk_tema INT, fk_grant INT ) ENGINE=InnoDB; ALTER TABLE KIV_PUBL_SOUBORY ADD CONSTRAINT pk_soubor PRIMARY KEY(id); 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_TECHREPORT ( fk_publ INT NOT NULL, instituce VARCHAR(255), typ VARCHAR(100), cislo VARCHAR(100) ) ENGINE=InnoDB; CREATE TABLE KIV_PUBL_PRISPEVEK ( fk_publ INT NOT NULL, sbornik VARCHAR(255), editor VARCHAR(100), stranky VARCHAR(10), fk_vydavatel INT ) ENGINE=InnoDB; CREATE TABLE KIV_PUBL_VYDAVATELE ( id INT, vydavatel VARCHAR(255) NOT NULL ) ENGINE=InnoDB; ALTER TABLE KIV_PUBL_VYDAVATELE ADD CONSTRAINT pk_vyd PRIMARY KEY(id); CREATE TABLE KIV_PUBL_CLANEK ( fk_publ INT NOT NULL, cislo INT, svazek INT, stranky VARCHAR(10), fk_casopis INT ) ENGINE=InnoDB; CREATE TABLE KIV_PUBL_CASOPISY ( id INT, casopis VARCHAR(255) ) ENGINE=InnoDB; ALTER TABLE KIV_PUBL_CASOPISY ADD CONSTRAINT pk_cas PRIMARY KEY(id); CREATE TABLE KIV_PUBL_KNIHA ( fk_publ INT, je_autor_editorem BOOL, fk_vydavatel INT, svazek INT, edicni_rada VARCHAR(100), vydani INT ) ENGINE=InnoDB; CREATE TABLE KIV_PUBL_PHD ( fk_publ INT NOT NULL, univerzita VARCHAR(255) ) ENGINE=InnoDB; CREATE TABLE KIV_PUBL_TYPY ( id INT, typ VARCHAR(100) ) ENGINE=InnoDB; ALTER TABLE KIV_PUBL_TYPY ADD CONSTRAINT pk_typ PRIMARY KEY(id); CREATE TABLE KIV_PERS_KATEGORIE ( id INT NOT NULL, nazev_cz VARCHAR(40) NOT NULL, nazev_en VARCHAR(40) NOT NULL ) ENGINE=InnoDB; ALTER TABLE KIV_PERS_KATEGORIE ADD CONSTRAINT pk_kategorie PRIMARY KEY(id); 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 tob 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_TECHREPORT ADD CONSTRAINT ptr FOREIGN KEY (fk_publ) REFERENCES KIV_PUBL_ZAZNAMY(id) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE KIV_PUBL_PRISPEVEK ADD CONSTRAINT ppr FOREIGN KEY (fk_publ) REFERENCES KIV_PUBL_ZAZNAMY(id) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE KIV_PUBL_CLANEK ADD CONSTRAINT pcl FOREIGN KEY (fk_publ) REFERENCES KIV_PUBL_ZAZNAMY(id) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE KIV_PUBL_PRISPEVEK ADD CONSTRAINT pvy FOREIGN KEY (fk_vydavatel) REFERENCES KIV_PUBL_VYDAVATELE(id) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE KIV_PUBL_CLANEK ADD CONSTRAINT pca FOREIGN KEY (fk_casopis) REFERENCES KIV_PUBL_CASOPISY(id) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE KIV_PUBL_KNIHA ADD CONSTRAINT pkn FOREIGN KEY (fk_publ) REFERENCES KIV_PUBL_ZAZNAMY(id) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE KIV_PUBL_KNIHA ADD CONSTRAINT pvyk FOREIGN KEY (fk_vydavatel) REFERENCES KIV_PUBL_VYDAVATELE(id) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE KIV_PUBL_PHD 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;