--
-- PostgreSQL database dump
--

-- Dumped from database version 13.2
-- Dumped by pg_dump version 13.2

--
-- Name: multikina; Type: SCHEMA; Schema: -; Owner: valenta
--

CREATE SCHEMA multikina;

--
-- Name: rok_narozeni_dom; Type: DOMAIN; multikina: multikina; Owner: valenta
--

CREATE DOMAIN multikina.rok_narozeni_dom AS numeric
	CONSTRAINT rok_narozeni_dom_check CHECK (((VALUE >= (1900)::numeric) AND (VALUE <= (2099)::numeric)));


--
-- Name: filmy; Type: TABLE; Schema: multikina; Owner: valenta
--

CREATE TABLE multikina.filmy (
    id_rezisera numeric,
    id_filmu numeric NOT NULL,
    nazev character varying(200) NOT NULL,
    rok numeric NOT NULL
);



--
-- Name: filmy_zanry; Type: TABLE; Schema: multikina; Owner: valenta
--

CREATE TABLE multikina.filmy_zanry (
    id_filmu numeric NOT NULL,
    zanr_kod character varying(15) NOT NULL
);



--
-- Name: filmy_zeme; Type: TABLE; Schema: multikina; Owner: valenta
--

CREATE TABLE multikina.filmy_zeme (
    zeme_kod character varying(5) NOT NULL,
    id_filmu numeric NOT NULL
);



--
-- Name: herci; Type: TABLE; Schema: multikina; Owner: valenta
--

CREATE TABLE multikina.herci (
    id_herce numeric NOT NULL
);



--
-- Name: herec_role; Type: TABLE; Schema: multikina; Owner: valenta
--

CREATE TABLE multikina.herec_role (
    id_herce numeric,
    jmeno character varying(80),
    pocet_roli numeric
);



--
-- Name: kina; Type: TABLE; Schema: multikina; Owner: valenta
--

CREATE TABLE multikina.kina (
    id_kina numeric NOT NULL,
    nazev character varying(100) NOT NULL,
    mesto character varying(50) NOT NULL,
    ulice character varying(100),
    cislo_popisne numeric NOT NULL,
    cislo_orientacni numeric,
    psc numeric NOT NULL
);



--
-- Name: obsazeni; Type: TABLE; Schema: multikina; Owner: valenta
--

CREATE TABLE multikina.obsazeni (
    role character varying(30) NOT NULL,
    id_herce numeric NOT NULL,
    id_filmu numeric NOT NULL
);



--
-- Name: osoby; Type: TABLE; Schema: multikina; Owner: valenta
--

CREATE TABLE multikina.osoby (
    id_osoby numeric NOT NULL,
    plne_jmeno character varying(100) NOT NULL
);



--
-- Name: platove_tridy; Type: TABLE; Schema: multikina; Owner: valenta
--

CREATE TABLE multikina.platove_tridy (
    oznaceni character varying(30) NOT NULL,
    spodni_hranice numeric NOT NULL,
    horni_hranice numeric NOT NULL
);



--
-- Name: prac_pozice; Type: TABLE; Schema: multikina; Owner: valenta
--

CREATE TABLE multikina.prac_pozice (
    id_pozice character varying(10) NOT NULL,
    popis_pozice character varying(1000) NOT NULL,
    pozadavky character varying(2000)
);



--
-- Name: predstaveni; Type: TABLE; Schema: multikina; Owner: valenta
--

CREATE TABLE multikina.predstaveni (
    id_kina numeric NOT NULL,
    cislo numeric NOT NULL,
    id_filmu numeric NOT NULL,
    id_predstaveni numeric NOT NULL,
    datum_a_cas date NOT NULL
);



--
-- Name: reziseri; Type: TABLE; Schema: multikina; Owner: valenta
--

CREATE TABLE multikina.reziseri (
    id_rezisera numeric NOT NULL
);



--
-- Name: saly; Type: TABLE; Schema: multikina; Owner: valenta
--

CREATE TABLE multikina.saly (
    id_kina numeric NOT NULL,
    cislo numeric NOT NULL,
    kapacita numeric NOT NULL,
    vybaveni character varying(1000)
);



--
-- Name: umelci; Type: TABLE; Schema: multikina; Owner: -; Tablespace:
--

CREATE TABLE multikina.umelci (
    id_umelce numeric NOT NULL,
    jmeno_umelce character varying(80) NOT NULL,
    rok_narozeni multikina.rok_narozeni_dom,
    zeme_kod character varying(5)
);



--
-- Name: vstupenky; Type: TABLE; Schema: multikina; Owner: valenta
--

CREATE TABLE multikina.vstupenky (
    id_vstupenky numeric NOT NULL,
    plati_od date,
    plati_do numeric,
    pocet_predstaveni numeric,
    id_kina numeric NOT NULL,
    id_osoby numeric NOT NULL,
    sedadlo numeric,
    id_predstaveni numeric NOT NULL
);



--
-- Name: zam_historie; Type: TABLE; Schema: multikina; Owner: valenta
--

CREATE TABLE multikina.zam_historie (
    id_historie numeric NOT NULL,
    id_zam numeric,
    id_pozice character varying(10),
    datum_od date NOT NULL,
    datum_do date,
    plat double precision
);



--
-- Name: zamestnanci; Type: TABLE; Schema: multikina; Owner: valenta
--

CREATE TABLE multikina.zamestnanci (
    id_zam numeric NOT NULL,
    jmeno character varying(50) NOT NULL,
    prijmeni character varying(50) NOT NULL,
    tituly_pred character varying(30),
    tiluly_za character varying(30),
    dat_nar date,
    id_pozice character varying(10) NOT NULL,
    plat double precision,
    id_kina numeric,
    id_sefa numeric,
    rodne_cislo character varying(11),
    username character varying(10),
    nastoupil date DEFAULT now(),
    CONSTRAINT zamestnanci_plat_check CHECK ((plat > (5000)::double precision))
);



--
-- Name: zanry; Type: TABLE; Schema: multikina; Owner: valenta
--

CREATE TABLE multikina.zanry (
    zanr_kod character varying(15) NOT NULL,
    popis character varying(1000) NOT NULL
);



--
-- Name: zeme; Type: TABLE; Schema: multikina; Owner: valenta
--

CREATE TABLE multikina.zeme (
    zeme_kod character varying(5) NOT NULL,
    nazev character varying(100) NOT NULL
);

--
-- Name: filmy1; Type: VIEW; Schema: multikina; Owner: -
--

CREATE VIEW multikina.filmy1 AS
    SELECT multikina.filmy.nazev AS jmeno_f, multikina.umelci.jmeno_umelce AS reziser, multikina.filmy.rok FROM ((multikina.filmy JOIN multikina.reziseri USING (id_rezisera)) JOIN multikina.umelci ON ((filmy.id_rezisera = umelci.id_umelce))) WHERE ((filmy.rok >= (1978)::numeric) AND (filmy.rok <= (2002)::numeric));

--
-- Name: obsazeni1; Type: VIEW; Schema: multikina; Owner: -
--

CREATE VIEW multikina.obsazeni1 AS
    SELECT multikina.filmy.nazev AS jmeno_f, multikina.umelci.jmeno_umelce AS herec FROM ((multikina.filmy JOIN multikina.obsazeni USING (id_filmu)) JOIN multikina.umelci ON ((obsazeni.id_herce = multikina.umelci.id_umelce))) ORDER BY filmy.nazev, umelci.jmeno_umelce;

--
-- Name: filmy_s_machackem; Type: VIEW; Schema: multikina; Owner: -
--

CREATE VIEW multikina.filmy_s_machackem AS
    SELECT multikina.obsazeni1.jmeno_f, multikina.obsazeni1.herec FROM multikina.obsazeni1 WHERE ((obsazeni1.herec)::text = 'Jiří Macháček'::text);

--
-- TOC entry 159 (class 1259 OID 130915)
-- Dependencies: 1691 3
-- Name: predstaveni1; Type: VIEW; Schema: multikina; Owner: -
--

CREATE VIEW multikina.predstaveni1 AS
    SELECT multikina.kina.nazev AS nazev_k, multikina.filmy.nazev AS jmeno_f, multikina.predstaveni.datum_a_cas AS datum FROM ((multikina.kina JOIN multikina.predstaveni USING (id_kina)) JOIN multikina.filmy USING (id_filmu)) WHERE ((filmy.rok >= (1978)::numeric) AND (filmy.rok <= (2002)::numeric));

--
-- TOC entry 161 (class 1259 OID 130934)
-- Dependencies: 1693 3
-- Name: kina1; Type: VIEW; Schema: multikina; Owner: -
--

CREATE VIEW multikina.kina1 AS
    SELECT multikina.kina.nazev AS nazev_k, (((((multikina.kina.mesto)::text || ' '::text) || (multikina.kina.ulice)::text) || ' '::text) || multikina.kina.cislo_popisne) AS adresa FROM multikina.kina WHERE ((kina.nazev)::text IN (SELECT multikina.predstaveni1.nazev_k FROM multikina.predstaveni1));




--
-- Data for Name: filmy; Type: TABLE DATA; Schema: multikina; Owner: valenta
--

INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (1, 1, 'Havran', 2012);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (3, 2, 'Můj vysvlečenej deník ', 2012);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (1, 4, 'V jako Vendeta ', 2006);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (5, 3, 'Vrásky z lásky ', 2012);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (9, 5, 'Černá labuť', 2010);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (10, 6, 'Musíme si promluvit o Kevinovi', 2011);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (12, 7, 'Probudím se včera ', 2011);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (14, 8, 'Čtyři slunce ', 2012);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (14, 9, 'Venkovský učitel ', 2007);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (16, 10, 'Jeden musí z kola ven', 2011);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (19, 11, 'Pátý element', 1997);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (21, 12, 'Nebezpečná metoda', 2011);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (23, 13, 'Den zrady', 2011);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (24, 14, 'Lítám v tom', 2009);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (25, 15, 'Vrchní, prchni! ', 1980);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (27, 16, 'Na samotě u lesa', 1976);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (28, 17, 'Bůh masakru', 2011);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (31, 18, 'Věčný svit neposkvrněné mysli', 2004);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (33, 19, 'Králova řeč', 2010);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (34, 20, 'Válka Bohů', 2011);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (34, 21, 'Sněhurka', 2012);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (37, 22, 'Pretty Woman', 1990);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (39, 23, 'Půlnoc v Paříži', 2011);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (39, 24, 'Hollywood v koncích', 2002);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (41, 25, 'Kůže, kterou nosím', 2011);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (39, 26, 'Poznáš muže svých snů', 2010);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (43, 27, 'Muži v naději', 2011);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (45, 28, 'Samotáři', 2000);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (46, 29, 'Melancholia', 2011);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (46, 30, 'Antikrist', 2009);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (39, 31, 'Zlaté časy rádia', 1987);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (39, 32, 'September', 1987);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (39, 33, 'Povídky z New Yorku', 1989);
INSERT INTO multikina.filmy (id_rezisera, id_filmu, nazev, rok) VALUES (39, 34, 'Zločiny a poklesky', 1989);


--
-- Data for Name: filmy_zanry; Type: TABLE DATA; Schema: multikina; Owner: valenta
--

INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (1, 'THIL');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (2, 'KOM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (3, 'DRAM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (3, 'KOM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (4, 'AKCE');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (4, 'DRAM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (4, 'SCIFI');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (4, 'THIL');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (5, 'DRAM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (5, 'MYST');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (5, 'THIL');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (6, 'DRAM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (6, 'THIL');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (7, 'KOM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (7, 'SCIFI');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (8, 'DRAM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (8, 'KOM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (9, 'DRAM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (10, 'DRAM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (10, 'MYST');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (10, 'THIL');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (11, 'AKCE');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (11, 'KOM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (11, 'SCIFI');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (12, 'DRAM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (12, 'THIL');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (12, 'ŽIV');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (13, 'DRAM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (14, 'DRAM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (14, 'KOM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (14, 'ROM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (15, 'KOM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (16, 'KOM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (17, 'DRAM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (17, 'KOM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (18, 'DRAM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (18, 'ROM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (18, 'SCIFI');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (19, 'DRAM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (19, 'HIST');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (19, 'ŽIV');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (20, 'AKCE');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (20, 'DRAM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (20, 'FANT');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (21, 'DOBR');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (21, 'DRAM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (21, 'KOM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (22, 'KOM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (22, 'ROM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (23, 'FANT');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (23, 'KOM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (23, 'ROM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (24, 'DRAM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (24, 'KOM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (25, 'DRAM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (25, 'MYST');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (25, 'THIL');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (26, 'DRAM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (26, 'KOM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (26, 'ROM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (27, 'KOM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (28, 'KOM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (29, 'DRAM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (29, 'SCIFI');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (30, 'DRAM');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (30, 'HOROR');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (30, 'MYST');
INSERT INTO multikina.filmy_zanry (id_filmu, zanr_kod) VALUES (30, 'PSYCH');


--
-- Data for Name: filmy_zeme; Type: TABLE DATA; Schema: multikina; Owner: valenta
--

INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('CAN', 12);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('CHE', 12);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('CSR', 15);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('CSR', 16);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('CZE', 2);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('CZE', 3);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('CZE', 7);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('CZE', 8);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('CZE', 9);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('CZE', 27);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('CZE', 28);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('DEU', 4);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('DEU', 9);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('DEU', 10);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('DEU', 12);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('DEU', 17);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('DEU', 29);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('DEU', 30);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('DNK', 29);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('DNK', 30);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('ESP', 1);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('ESP', 23);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('ESP', 25);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('ESP', 26);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('FRA', 9);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('FRA', 10);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('FRA', 11);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('FRA', 17);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('FRA', 29);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('FRA', 30);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('GB', 4);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('GB', 6);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('GB', 10);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('GB', 12);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('GB', 19);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('HUN', 1);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('SWE', 29);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('SWE', 30);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('USA', 1);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('USA', 4);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('USA', 5);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('USA', 6);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('USA', 13);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('USA', 14);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('USA', 18);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('USA', 20);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('USA', 21);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('USA', 22);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('USA', 23);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('USA', 24);
INSERT INTO multikina.filmy_zeme (zeme_kod, id_filmu) VALUES ('USA', 26);


--
-- Data for Name: herci; Type: TABLE DATA; Schema: multikina; Owner: valenta
--

INSERT INTO multikina.herci (id_herce) VALUES (2);
INSERT INTO multikina.herci (id_herce) VALUES (4);
INSERT INTO multikina.herci (id_herce) VALUES (6);
INSERT INTO multikina.herci (id_herce) VALUES (7);
INSERT INTO multikina.herci (id_herce) VALUES (8);
INSERT INTO multikina.herci (id_herce) VALUES (11);
INSERT INTO multikina.herci (id_herce) VALUES (13);
INSERT INTO multikina.herci (id_herce) VALUES (15);
INSERT INTO multikina.herci (id_herce) VALUES (17);
INSERT INTO multikina.herci (id_herce) VALUES (18);
INSERT INTO multikina.herci (id_herce) VALUES (20);
INSERT INTO multikina.herci (id_herce) VALUES (22);
INSERT INTO multikina.herci (id_herce) VALUES (23);
INSERT INTO multikina.herci (id_herce) VALUES (25);
INSERT INTO multikina.herci (id_herce) VALUES (26);
INSERT INTO multikina.herci (id_herce) VALUES (29);
INSERT INTO multikina.herci (id_herce) VALUES (30);
INSERT INTO multikina.herci (id_herce) VALUES (32);
INSERT INTO multikina.herci (id_herce) VALUES (35);
INSERT INTO multikina.herci (id_herce) VALUES (36);
INSERT INTO multikina.herci (id_herce) VALUES (38);
INSERT INTO multikina.herci (id_herce) VALUES (39);
INSERT INTO multikina.herci (id_herce) VALUES (40);
INSERT INTO multikina.herci (id_herce) VALUES (42);
INSERT INTO multikina.herci (id_herce) VALUES (44);
INSERT INTO multikina.herci (id_herce) VALUES (47);
INSERT INTO multikina.herci (id_herce) VALUES (48);
INSERT INTO multikina.herci (id_herce) VALUES (49);


--
-- Data for Name: herec_role; Type: TABLE DATA; Schema: multikina; Owner: valenta
--

INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (32, 'Jim Carrey', 1);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (20, 'Bruce Willis', 1);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (8, 'Natalie Portman', 2);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (7, 'Jiřina Bohdalová', 1);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (25, 'Ladislav Smoljak', 1);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (15, 'Pavel Liška', 1);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (4, 'Simona Stašová', 1);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (17, 'Gary Oldman', 2);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (11, 'Tilda Swinton', 1);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (30, 'Jodie Foster', 1);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (38, 'Richard Gere', 1);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (35, 'Henry Cavill', 1);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (48, 'Charlotte Gainsbourg', 2);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (18, 'Colin Firth', 2);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (47, 'Kirsten Dunst', 1);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (2, 'John Cusack', 1);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (42, 'Antonio Banderas', 2);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (36, 'Julia Roberts', 2);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (13, 'Jiří Mádl', 2);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (29, 'Kate Winslet', 2);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (23, 'George Clooney', 2);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (40, 'Owen Wilson', 1);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (26, 'Zdeněk Svěrák', 2);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (22, 'Keira Knightley', 1);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (39, 'Woody Allen', 1);
INSERT INTO multikina.herec_role (id_herce, jmeno, pocet_roli) VALUES (39, 'Josef Kemr', 1);


--
-- Data for Name: kina; Type: TABLE DATA; Schema: multikina; Owner: valenta
--

INSERT INTO multikina.kina (id_kina, nazev, mesto, ulice, cislo_popisne, cislo_orientacni, psc) VALUES (1, 'CineStar Olomouc', 'Olomouc', 'Pražská ', 255, 44, 77900);
INSERT INTO multikina.kina (id_kina, nazev, mesto, ulice, cislo_popisne, cislo_orientacni, psc) VALUES (2, 'CineStar Plzeň', 'Plzeň', 'Písecká', 972, 1, 32600);
INSERT INTO multikina.kina (id_kina, nazev, mesto, ulice, cislo_popisne, cislo_orientacni, psc) VALUES (3, 'Palace Cinemas Olympia Centrum', 'Brno', 'U Dálnice ', 777, NULL, 66442);
INSERT INTO multikina.kina (id_kina, nazev, mesto, ulice, cislo_popisne, cislo_orientacni, psc) VALUES (4, 'Palace Cinemas Velký Špalíček', 'Brno', 'Mečová', 695, 2, 60200);
INSERT INTO multikina.kina (id_kina, nazev, mesto, ulice, cislo_popisne, cislo_orientacni, psc) VALUES (5, 'Cinema City Ústí nad Labem', 'Ústí nad Labem', 'Bílinská', 3490, 6, 40001);
INSERT INTO multikina.kina (id_kina, nazev, mesto, ulice, cislo_popisne, cislo_orientacni, psc) VALUES (6, 'Cinema City Pardubice', 'Pardubice', 'Masarykovo náměstí ', 2799, NULL, 53002);
INSERT INTO multikina.kina (id_kina, nazev, mesto, ulice, cislo_popisne, cislo_orientacni, psc) VALUES (7, 'Cinema City Liberec', 'Liberec', 'Soukenné náměstí', 669, 2, 46080);
INSERT INTO multikina.kina (id_kina, nazev, mesto, ulice, cislo_popisne, cislo_orientacni, psc) VALUES (8, 'Cinema City Flora', 'Praha ', 'Vinohradská', 2828, 151, 13000);
INSERT INTO multikina.kina (id_kina, nazev, mesto, ulice, cislo_popisne, cislo_orientacni, psc) VALUES (9, 'Cinema City Zličín', 'Praha ', 'Řevnická', 121, 1, 15521);
INSERT INTO multikina.kina (id_kina, nazev, mesto, ulice, cislo_popisne, cislo_orientacni, psc) VALUES (10, 'Palace Cinemas Slovanský dům', 'Praha ', 'Na příkopě', 859, 22, 11000);
INSERT INTO multikina.kina (id_kina, nazev, mesto, ulice, cislo_popisne, cislo_orientacni, psc) VALUES (11, 'Cinestar Černý Most', 'Praha ', 'Chlumecká', 712, 8, 19800);
INSERT INTO multikina.kina (id_kina, nazev, mesto, ulice, cislo_popisne, cislo_orientacni, psc) VALUES (12, 'Cinestar České Budějovice
', 'České Budějovice', 'Milady Horákové', 1498, NULL, 37005);
INSERT INTO multikina.kina (id_kina, nazev, mesto, ulice, cislo_popisne, cislo_orientacni, psc) VALUES (13, 'Cinestar Mladá Boleslav', 'Mladá Boleslav', 'třída Václava Klementa', 1459, NULL, 29301);
INSERT INTO multikina.kina (id_kina, nazev, mesto, ulice, cislo_popisne, cislo_orientacni, psc) VALUES (14, 'Cinema City Ostrava', 'Ostrava', 'Jantarová', 3344, 4, 70200);
INSERT INTO multikina.kina (id_kina, nazev, mesto, ulice, cislo_popisne, cislo_orientacni, psc) VALUES (15, 'Golden Apple Cinema', 'Zlín', 'nám. Míru', 174, NULL, 76001);


--
-- Data for Name: obsazeni; Type: TABLE DATA; Schema: multikina; Owner: valenta
--

INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Edgar Allan Poe', 2, 1);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Dr. Lichá', 4, 2);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Jana', 7, 3);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Evey', 8, 4);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Nina Sayers', 8, 5);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Eva Khatchadourian', 11, 6);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Petr', 13, 7);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Jerry', 13, 8);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Učitel', 15, 9);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('George Smiley', 17, 10);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Jean-Baptiste Emanuel Zorg', 17, 11);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Bill Haydon', 18, 10);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Král Jindřich VI.', 18, 19);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Korben Dallas', 20, 11);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Sabina Spielrein', 22, 12);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Governor Mike Morris', 23, 13);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Ryan Bingham', 23, 14);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Radim Zvon', 25, 16);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('soused Pařízek', 26, 15);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Oldřich Lavička', 26, 16);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Nancy Cowan', 29, 17);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Clementine Kruczynski', 29, 18);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Penelope Longstreet', 30, 17);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Joel Barish', 32, 18);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Theseus', 35, 20);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Královna', 36, 21);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Vivian Ward', 36, 22);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Edward Lewis', 38, 22);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Val', 39, 24);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Gil', 40, 23);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Robert Ledgard', 42, 25);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Alfie Shepridge', 42, 26);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Ondřej', 44, 27);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Jakub', 44, 28);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Justine', 47, 29);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Claire', 48, 29);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('Ona', 48, 30);
INSERT INTO multikina.obsazeni (role, id_herce, id_filmu) VALUES ('děda Komárek', 49, 16);


--
-- Data for Name: osoby; Type: TABLE DATA; Schema: multikina; Owner: valenta
--

INSERT INTO multikina.osoby (id_osoby, plne_jmeno) VALUES (1, 'Jana Smutná');
INSERT INTO multikina.osoby (id_osoby, plne_jmeno) VALUES (2, 'Jiří Loskot');
INSERT INTO multikina.osoby (id_osoby, plne_jmeno) VALUES (3, 'Jaroslav Krutina');
INSERT INTO multikina.osoby (id_osoby, plne_jmeno) VALUES (4, 'Petra Zahradníková');
INSERT INTO multikina.osoby (id_osoby, plne_jmeno) VALUES (5, 'František Janů');
INSERT INTO multikina.osoby (id_osoby, plne_jmeno) VALUES (6, 'Jana Thomson');
INSERT INTO multikina.osoby (id_osoby, plne_jmeno) VALUES (7, 'Petar Skala');
INSERT INTO multikina.osoby (id_osoby, plne_jmeno) VALUES (8, 'Karolína Světlá');
INSERT INTO multikina.osoby (id_osoby, plne_jmeno) VALUES (9, 'Pavel Koukl');
INSERT INTO multikina.osoby (id_osoby, plne_jmeno) VALUES (10, 'Kateřina Králová');
INSERT INTO multikina.osoby (id_osoby, plne_jmeno) VALUES (11, 'Michael Pressl');
INSERT INTO multikina.osoby (id_osoby, plne_jmeno) VALUES (12, 'Klára Burgess');
INSERT INTO multikina.osoby (id_osoby, plne_jmeno) VALUES (13, 'Andrea Schickerová');
INSERT INTO multikina.osoby (id_osoby, plne_jmeno) VALUES (14, 'Alžběta Tachecí');
INSERT INTO multikina.osoby (id_osoby, plne_jmeno) VALUES (15, 'Marek Polanský');
INSERT INTO multikina.osoby (id_osoby, plne_jmeno) VALUES (16, 'Marie Londinová');
INSERT INTO multikina.osoby (id_osoby, plne_jmeno) VALUES (17, 'Ondřej Grussmann');
INSERT INTO multikina.osoby (id_osoby, plne_jmeno) VALUES (18, 'Petr Charvát');
INSERT INTO multikina.osoby (id_osoby, plne_jmeno) VALUES (19, 'Eva Hříbalová');
INSERT INTO multikina.osoby (id_osoby, plne_jmeno) VALUES (20, 'Jan Červenka');


--
-- Data for Name: platove_tridy; Type: TABLE DATA; Schema: multikina; Owner: valenta
--

INSERT INTO multikina.platove_tridy (oznaceni, spodni_hranice, horni_hranice) VALUES ('1.třída ', 40000, 50000);
INSERT INTO multikina.platove_tridy (oznaceni, spodni_hranice, horni_hranice) VALUES ('2.třída', 32000, 39000);
INSERT INTO multikina.platove_tridy (oznaceni, spodni_hranice, horni_hranice) VALUES ('3.třída', 25000, 20000);
INSERT INTO multikina.platove_tridy (oznaceni, spodni_hranice, horni_hranice) VALUES ('4.třída', 16000, 19000);
INSERT INTO multikina.platove_tridy (oznaceni, spodni_hranice, horni_hranice) VALUES ('5.třída', 12000, 15000);
INSERT INTO multikina.platove_tridy (oznaceni, spodni_hranice, horni_hranice) VALUES ('6.třída', 8000, 11000);


--
-- Data for Name: prac_pozice; Type: TABLE DATA; Schema: multikina; Owner: valenta
--

INSERT INTO multikina.prac_pozice (id_pozice, popis_pozice, pozadavky) VALUES ('PROD', 'programový produkční', 'komunikační dovednosti, vysoké prac.nasazení, kulturní přehled, přehled o kinematografii');
INSERT INTO multikina.prac_pozice (id_pozice, popis_pozice, pozadavky) VALUES ('HL TECH', 'hlavní technik', NULL);
INSERT INTO multikina.prac_pozice (id_pozice, popis_pozice, pozadavky) VALUES ('HL POKL', 'hlavní pokladní', NULL);
INSERT INTO multikina.prac_pozice (id_pozice, popis_pozice, pozadavky) VALUES ('VED SM', 'vedoucí směny', NULL);
INSERT INTO multikina.prac_pozice (id_pozice, popis_pozice, pozadavky) VALUES ('AS VED', 'asisten vedoucího', NULL);
INSERT INTO multikina.prac_pozice (id_pozice, popis_pozice, pozadavky) VALUES ('UKL', 'uklízečka', NULL);
INSERT INTO multikina.prac_pozice (id_pozice, popis_pozice, pozadavky) VALUES ('VED ŘET', 'vedoucí řetězce kin', NULL);
INSERT INTO multikina.prac_pozice (id_pozice, popis_pozice, pozadavky) VALUES ('AS TECH', 'asistent technika', NULL);
INSERT INTO multikina.prac_pozice (id_pozice, popis_pozice, pozadavky) VALUES ('SPR', 'správce kina', NULL);
INSERT INTO multikina.prac_pozice (id_pozice, popis_pozice, pozadavky) VALUES ('UCT', 'účetní', NULL);
INSERT INTO multikina.prac_pozice (id_pozice, popis_pozice, pozadavky) VALUES ('UV', 'uvaděč', 'věk minimálně 17 let, dobré vystupování');
INSERT INTO multikina.prac_pozice (id_pozice, popis_pozice, pozadavky) VALUES ('POKL', 'pokladní', NULL);
INSERT INTO multikina.prac_pozice (id_pozice, popis_pozice, pozadavky) VALUES ('BAR', 'barman', 'věk minimálně 18 let');
INSERT INTO multikina.prac_pozice (id_pozice, popis_pozice, pozadavky) VALUES ('PROM', 'promítač', 'manuální zručnost, zodpovědnost, s technickým myšlením a zájmem o kinematografii. ');
INSERT INTO multikina.prac_pozice (id_pozice, popis_pozice, pozadavky) VALUES ('TECH', 'technik', NULL);
INSERT INTO multikina.prac_pozice (id_pozice, popis_pozice, pozadavky) VALUES ('VED', 'vedoucí kina', 'práce na PC(MS Office,Internet)kulturní přehled,schopnost vést kolektiv, komunikační dovednosti, vysoké prac.nasazení');
INSERT INTO multikina.prac_pozice (id_pozice, popis_pozice, pozadavky) VALUES ('OST', 'ostraha', NULL);


--
-- Data for Name: predstaveni; Type: TABLE DATA; Schema: multikina; Owner: valenta
--

INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (9, 2, 2, 2, '2012-05-01');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (8, 9, 1, 1, '2012-05-01');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (3, 4, 10, 3, '2012-06-01');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (7, 5, 4, 4, '2012-04-10');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (6, 5, 5, 5, '2012-04-11');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (5, 2, 6, 6, '2012-04-12');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (6, 6, 10, 7, '2012-04-13');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (7, 4, 8, 8, '2012-05-02');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (2, 1, 10, 9, '2012-04-20');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (9, 3, 28, 10, '2012-04-21');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (15, 6, 11, 11, '2012-04-24');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (4, 2, 12, 12, '2012-05-25');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (1, 1, 13, 13, '2012-04-26');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (8, 2, 14, 14, '2012-04-27');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (5, 2, 10, 15, '2012-05-27');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (4, 6, 10, 16, '2012-04-29');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (1, 4, 16, 17, '2012-04-28');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (9, 3, 18, 18, '2012-05-28');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (13, 1, 19, 19, '2012-04-30');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (10, 3, 20, 20, '2012-05-30');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (11, 5, 21, 21, '2012-05-30');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (9, 7, 22, 22, '2012-05-04');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (2, 5, 23, 23, '2012-04-05');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (4, 7, 24, 24, '2012-04-05');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (13, 4, 15, 25, '2012-04-05');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (14, 4, 26, 26, '2012-04-05');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (7, 1, 27, 27, '2012-06-06');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (12, 8, 10, 28, '2012-06-06');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (4, 2, 29, 29, '2012-06-09');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (14, 8, 30, 30, '2012-06-09');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (15, 4, 10, 31, '2012-04-28');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (14, 7, 17, 32, '2012-05-28');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (13, 2, 10, 33, '2012-04-30');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (12, 4, 19, 34, '2012-05-30');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (11, 6, 10, 35, '2012-04-04');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (10, 3, 21, 36, '2012-04-12');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (9, 6, 10, 37, '2012-06-07');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (8, 9, 10, 38, '2012-06-08');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (7, 3, 10, 39, '2012-05-29');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (6, 1, 25, 40, '2012-04-07');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (15, 3, 1, 41, '2012-05-25');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (14, 5, 10, 42, '2012-05-28');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (13, 3, 3, 43, '2012-04-27');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (12, 2, 4, 44, '2012-04-28');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (11, 4, 5, 45, '2012-05-28');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (10, 2, 6, 46, '2012-04-30');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (9, 2, 7, 47, '2012-05-30');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (10, 8, 10, 48, '2012-04-05');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (9, 8, 9, 49, '2012-06-09');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (1, 7, 10, 50, '2012-06-12');
INSERT INTO multikina.predstaveni (id_kina, cislo, id_filmu, id_predstaveni, datum_a_cas) VALUES (15, 6, 28, 51, '2012-05-06');


--
-- Data for Name: reziseri; Type: TABLE DATA; Schema: multikina; Owner: valenta
--

INSERT INTO multikina.reziseri (id_rezisera) VALUES (1);
INSERT INTO multikina.reziseri (id_rezisera) VALUES (3);
INSERT INTO multikina.reziseri (id_rezisera) VALUES (5);
INSERT INTO multikina.reziseri (id_rezisera) VALUES (9);
INSERT INTO multikina.reziseri (id_rezisera) VALUES (10);
INSERT INTO multikina.reziseri (id_rezisera) VALUES (12);
INSERT INTO multikina.reziseri (id_rezisera) VALUES (14);
INSERT INTO multikina.reziseri (id_rezisera) VALUES (16);
INSERT INTO multikina.reziseri (id_rezisera) VALUES (19);
INSERT INTO multikina.reziseri (id_rezisera) VALUES (21);
INSERT INTO multikina.reziseri (id_rezisera) VALUES (23);
INSERT INTO multikina.reziseri (id_rezisera) VALUES (24);
INSERT INTO multikina.reziseri (id_rezisera) VALUES (25);
INSERT INTO multikina.reziseri (id_rezisera) VALUES (27);
INSERT INTO multikina.reziseri (id_rezisera) VALUES (28);
INSERT INTO multikina.reziseri (id_rezisera) VALUES (31);
INSERT INTO multikina.reziseri (id_rezisera) VALUES (33);
INSERT INTO multikina.reziseri (id_rezisera) VALUES (34);
INSERT INTO multikina.reziseri (id_rezisera) VALUES (37);
INSERT INTO multikina.reziseri (id_rezisera) VALUES (39);
INSERT INTO multikina.reziseri (id_rezisera) VALUES (41);
INSERT INTO multikina.reziseri (id_rezisera) VALUES (43);
INSERT INTO multikina.reziseri (id_rezisera) VALUES (45);
INSERT INTO multikina.reziseri (id_rezisera) VALUES (46);


--
-- Data for Name: saly; Type: TABLE DATA; Schema: multikina; Owner: valenta
--

INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (4, 1, 212, 'Dolby audio systém');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (4, 2, 310, 'polohovatelná křesla se stolky a klimatizací');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (4, 3, 371, '3D projektor');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (4, 4, 88, 'Dolby audio systém');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (4, 5, 149, 'Dolby audio systém');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (4, 6, 164, 'Dolby audio systém');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (4, 7, 119, 'Dolby audio systém');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (5, 1, 121, 'Dolby audio systém');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (5, 2, 121, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (5, 3, 121, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (5, 4, 121, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (5, 5, 190, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (6, 1, 124, 'projekční technika KINOTON');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (6, 2, 124, 'polohovatelná křesla se stolky a klimatizací');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (6, 3, 226, 'polohovatelná křesla se stolky a klimatizací');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (6, 4, 103, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (6, 5, 103, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (6, 6, 91, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (7, 1, 82, 'Dolby Surround 7.1');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (7, 2, 82, 'Dolby Surround 7.1');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (7, 3, 137, 'Dolby Surround 7.1');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (7, 4, 96, 'Dolby audio systém');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (7, 5, 170, 'Dolby audio systém');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (7, 6, 96, 'Dolby audio systém');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (7, 7, 218, '3D projektor');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (7, 8, 368, '3D projektor');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (1, 1, 107, 'Dolby audio systém');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (1, 2, 90, 'digitální šestikanálový prostorový zvuk');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (1, 3, 133, 'digitální šestikanálový prostorový zvuk');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (1, 4, 90, 'digitální šestikanálový prostorový zvuk');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (1, 5, 107, 'Sedačky pro zamilované');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (1, 6, 191, '3D projektor');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (1, 7, 264, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (2, 1, 217, 'Imax');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (2, 2, 120, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (2, 3, 96, 'Videomix Edirol V-8 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (2, 4, 306, 'Dolby Digital Surround EX');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (2, 5, 143, 'Dolby Digital Surround EX');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (2, 6, 120, 'Dolby Digital Surround EX');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (2, 7, 96, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (2, 8, 416, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (3, 1, 113, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (3, 2, 113, 'Dolby audio systém');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (3, 3, 111, '3D projektor');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (3, 4, 147, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (3, 5, 153, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (3, 6, 313, 'Dolby Digital Surround EX');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (3, 7, 359, '3D projektor');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (3, 8, 285, 'Videomix Edirol V-8 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (3, 9, 415, 'Dolby Surround 7.1');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (3, 10, 239, 'Dolby Surround 7.1');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (8, 1, 400, 'Sedačky pro zamilované');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (8, 2, 290, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (8, 3, 143, 'Videomix Edirol V-8 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (8, 4, 128, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (8, 5, 286, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (8, 6, 356, 'Videomix Edirol V-8 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (8, 7, 224, 'Videomix Edirol V-8 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (8, 8, 153, 'Videomix Edirol V-8 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (8, 9, 160, 'Videomix Edirol V-8 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (9, 1, 167, 'Dolby Digital Surround EX');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (9, 2, 148, 'Dolby Digital Surround EX');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (9, 3, 179, 'Dolby Digital Surround EX');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (9, 4, 184, 'Dolby Digital Surround EX');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (9, 5, 276, 'Dolby Digital Surround EX');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (9, 6, 396, 'Dolby Digital Surround EX');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (9, 7, 98, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (9, 8, 119, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (9, 9, 96, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (9, 10, 178, 'Dolby Surround 7.1');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (10, 1, 307, 'Dolby Digital Surround EX');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (10, 2, 335, 'Dolby Surround 7.1');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (10, 3, 292, 'Dolby Digital Surround EX');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (10, 4, 167, 'projekční technika KINOTON');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (10, 5, 157, 'Dolby audio systém');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (10, 6, 136, 'Dolby audio systém');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (10, 7, 133, 'Dolby audio systém');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (10, 8, 119, 'projekční technika KINOTON');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (10, 9, 81, 'Sedačky pro zamilované');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (10, 10, 125, 'Dolby Surround 7.1');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (11, 1, 220, 'Dolby Surround 7.1');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (11, 2, 206, 'Dolby Surround 7.1');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (11, 3, 255, 'projekční technika KINOTON');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (11, 4, 364, 'projekční technika KINOTON');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (11, 5, 220, 'projekční technika KINOTON');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (11, 6, 158, 'Dolby Surround 7.1');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (11, 7, 158, 'Dolby Surround 7.1');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (11, 8, 295, 'projekční technika KINOTON');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (12, 1, 316, 'digitální šestikanálový prostorový zvuk');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (12, 2, 316, 'digitální šestikanálový prostorový zvuk');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (12, 3, 94, 'digitální šestikanálový prostorový zvuk');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (12, 4, 145, 'Videomix Edirol V-8 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (12, 5, 145, 'projekční technika KINOTON');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (12, 6, 145, 'projekční technika KINOTON');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (12, 7, 145, 'Dolby Surround 7.1');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (12, 8, 94, 'Dolby Surround 7.1');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (13, 1, 233, '3D projektor');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (13, 2, 140, 'projekční technika KINOTON');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (13, 3, 96, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (13, 4, 96, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (14, 1, 156, 'projekční technika KINOTON');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (14, 2, 172, 'projekční technika KINOTON');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (14, 3, 172, 'Dolby audio systém');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (14, 4, 156, 'Dolby audio systém');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (14, 5, 81, 'Videomix Edirol V-8 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (14, 6, 309, '3D projektor');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (14, 7, 70, 'Sedačky pro zamilované');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (14, 8, 79, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (15, 1, 440, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (15, 2, 122, 'Projektor Sony CineAlta 4K SRX-R220 ');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (15, 3, 112, 'digitální šestikanálový prostorový zvuk');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (15, 4, 95, '3D projektor');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (15, 5, 90, 'Dolby audio systém');
INSERT INTO multikina.saly (id_kina, cislo, kapacita, vybaveni) VALUES (15, 6, 90, 'Dolby audio systém');

--
-- Data for Name: herec_role; Type: TABLE DATA; Schema: multikina; Owner: valenta
--

Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (1,'James McTeigue',1967,'AUS');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (2,'John Cusack',1966,'USA');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (3,'Martin Dolenský',1970,'CSR');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (4,'Simona Stašová',1955,'CSR');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (5,'Jiří Strach',1973,'CSR');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (6,'Radoslav Brzobohatý',1932,'CSR');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (7,'Jiřina Bohdalová',1931,'CSR');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (8,'Natalie Portman',1981,'ISR');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (9,'Darren Aronofsky',1969,'USA');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (10,'Lynne Ramsay',1969,'GB');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (11,'Tilda Swinton',1960,'GB');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (12,'Miloslav Šmídmajer',1959,'CSR');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (13,'Jiří Mádl',1986,'CSR');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (14,'Bohdan Sláma',1967,'CSR');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (15,'Pavel Liška',1972,'CSR');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (16,'Tomas Alfredson',1965,'SWE');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (17,'Gary Oldman',1958,'GB');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (18,'Colin Firth',1960,'GB');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (19,'Luc Besson',1959,'FRA');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (20,'Bruce Willis',1955,'DEU');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (21,'David Cronenberg',1943,'CAN');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (22,'Keira Knightley',1985,'GB');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (23,'George Clooney',1961,'USA');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (24,'Jason Reitman',1977,'CAN');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (25,'Ladislav Smoljak',1931,'CSR');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (26,'Zdeněk Svěrák',1936,'CSR');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (27,'Jiří Menzel',1938,'CSR');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (28,'Roman Polanski',1933,'FRA');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (29,'Kate Winslet',1975,'GB');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (30,'Jodie Foster',1962,'USA');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (31,'Michel Gondry',1963,'FRA');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (32,'Jim Carrey',1962,'CAN');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (33,'Tom Hooper',1972,'GB');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (34,'Tarsem Singh',1961,'IND');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (35,'Henry Cavill',1983,'NO');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (36,'Julia Roberts',1967,'USA');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (37,'Garry Marshall',1934,'USA');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (38,'Richard Gere',1949,'USA');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (39,'Woody Allen',1935,'USA');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (40,'Owen Wilson',1968,'USA');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (41,'Pedro Almodóvar',1949,'ESP');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (42,'Antonio Banderas',1960,'ESP');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (43,'Jiří Vejdělek',1972,'CSR');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (44,'Jiří Macháček',1966,'CSR');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (45,'David Ondříček',1969,'CSR');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (46,'Lars von Trier',1956,'DNK');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (47,'Kirsten Dunst',1982,'USA');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (48,'Charlotte Gainsbourg',1971,'GB');
Insert into multikina.umelci (id_umelce,jmeno_umelce,rok_narozeni,zeme_kod) values (49,'Josef Kemr',1922,'CSR');

--
-- Data for Name: vstupenky; Type: TABLE DATA; Schema: multikina; Owner: valenta
--



--
-- Data for Name: zam_historie; Type: TABLE DATA; Schema: multikina; Owner: valenta
--

INSERT INTO multikina.zam_historie (id_historie, id_zam, id_pozice, datum_od, datum_do, plat) VALUES (1, 2, 'VED', '2010-08-01', NULL, 35800);
INSERT INTO multikina.zam_historie (id_historie, id_zam, id_pozice, datum_od, datum_do, plat) VALUES (2, 3, 'HL TECH', '2001-04-15', '2011-08-30', 25000);
INSERT INTO multikina.zam_historie (id_historie, id_zam, id_pozice, datum_od, datum_do, plat) VALUES (3, 4, 'TECH', '2012-02-02', NULL, 18500);
INSERT INTO multikina.zam_historie (id_historie, id_zam, id_pozice, datum_od, datum_do, plat) VALUES (4, 5, 'TECH', '2011-04-09', NULL, 20000);
INSERT INTO multikina.zam_historie (id_historie, id_zam, id_pozice, datum_od, datum_do, plat) VALUES (5, 12, 'AS VED', '2012-01-02', NULL, 20500);
INSERT INTO multikina.zam_historie (id_historie, id_zam, id_pozice, datum_od, datum_do, plat) VALUES (6, 30, 'UV', '2010-09-15', NULL, 10500);
INSERT INTO multikina.zam_historie (id_historie, id_zam, id_pozice, datum_od, datum_do, plat) VALUES (7, 29, 'UKL', '2008-04-01', NULL, 8350);
INSERT INTO multikina.zam_historie (id_historie, id_zam, id_pozice, datum_od, datum_do, plat) VALUES (8, 26, 'VED SM', '2004-05-01', '2011-12-06', 14000);
INSERT INTO multikina.zam_historie (id_historie, id_zam, id_pozice, datum_od, datum_do, plat) VALUES (9, 17, 'POKL', '2011-09-01', NULL, 13000);
INSERT INTO multikina.zam_historie (id_historie, id_zam, id_pozice, datum_od, datum_do, plat) VALUES (10, 9, 'VED ŘET', '2000-10-02', NULL, 48800);
INSERT INTO multikina.zam_historie (id_historie, id_zam, id_pozice, datum_od, datum_do, plat) VALUES (11, 23, 'VED', '2000-11-01', '2012-02-28', 38000);
INSERT INTO multikina.zam_historie (id_historie, id_zam, id_pozice, datum_od, datum_do, plat) VALUES (12, 1, 'UV', '2010-07-01', '2010-08-31', 10500);
INSERT INTO multikina.zam_historie (id_historie, id_zam, id_pozice, datum_od, datum_do, plat) VALUES (13, 11, 'PROD', '2011-08-01', NULL, 18000);
INSERT INTO multikina.zam_historie (id_historie, id_zam, id_pozice, datum_od, datum_do, plat) VALUES (14, 15, 'AS VED', '2011-04-10', '2011-12-05', 19800);
INSERT INTO multikina.zam_historie (id_historie, id_zam, id_pozice, datum_od, datum_do, plat) VALUES (15, 11, 'PROD', '2003-09-05', '2011-07-31', 17000);
INSERT INTO multikina.zam_historie (id_historie, id_zam, id_pozice, datum_od, datum_do, plat) VALUES (16, 17, 'POKL', '2010-09-01', '2011-06-30', 120000);
INSERT INTO multikina.zam_historie (id_historie, id_zam, id_pozice, datum_od, datum_do, plat) VALUES (17, 1, 'UV', '2011-07-01', '2011-08-31', 10000);
INSERT INTO multikina.zam_historie (id_historie, id_zam, id_pozice, datum_od, datum_do, plat) VALUES (18, 1, 'UV', '2009-07-01', '2009-08-31', 9500);
INSERT INTO multikina.zam_historie (id_historie, id_zam, id_pozice, datum_od, datum_do, plat) VALUES (19, 17, 'HL POKL', '2011-07-01', NULL, 17000);
INSERT INTO multikina.zam_historie (id_historie, id_zam, id_pozice, datum_od, datum_do, plat) VALUES (20, 24, 'UCT', '2012-04-02', NULL, 24000);


--
-- Data for Name: zamestnanci; Type: TABLE DATA; Schema: multikina; Owner: valenta
--

INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (1, 'Adéla ', 'Drábková', 'Bc.', NULL, '1987-05-03', 'UV', 8478.75, 14, 12, '870503/1234', 'drabkova', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (5, 'Petr', 'Hrabě', NULL, NULL, '1981-08-30', 'TECH', 22942.5, 5, 3, '810830/1234', 'hrabe', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (7, 'Markéta', 'Dorňáková', 'Ing.', NULL, '1983-07-06', 'SPR', 18952.5, 5, 9, '830706/1234', 'dornakova', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (8, 'Hana', 'Kubová', NULL, NULL, '1992-09-21', 'UKL', 8977.5, 6, 14, '920921/1234', 'kubova', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (12, 'Miloš', 'Suchánek', 'Mgr.', NULL, '1978-05-05', 'AS VED', 18952.5, 14, 2, '780505/1234', 'suchanek', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (16, 'Filip', 'Martínek', 'Ing.', NULL, '1977-10-06', 'HL POKL', 26932.5, 6, 15, '771006/1234', 'martinek', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (17, 'Helena', 'Zábranská', NULL, NULL, '2049-01-18', 'POKL', 15960, 6, 16, '490118/1234', 'zabranska', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (19, 'Karel ', 'Sýkora', NULL, NULL, '1982-04-27', 'PROM', 11970, 11, 21, '820427/1234', 'sykora2', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (24, 'Ivana', 'Holoubková', 'Ing.', NULL, '1968-12-29', 'UCT', 26932.5, 3, 23, '681229/1234', 'holoubkova', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (27, 'Štěpán ', 'Sláma', NULL, NULL, '1988-11-01', 'BAR', 10972.5, 3, 26, '881101/1234', 'slama', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (28, 'Vesna', 'Mičeva', NULL, NULL, '1971-12-24', 'UKL', 8977.5, 3, 26, NULL, 'miceva', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (30, 'Olga', 'Kralewska', '', NULL, '1990-04-07', 'UV', 7980, 12, NULL, '900407/1234', 'kralevska', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (29, 'Vesna', 'Mičeva', NULL, NULL, '1985-01-02', 'UKL', 8977.5, 4, NULL, NULL, 'miceva2', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (18, 'Karel ', 'Sýkora', NULL, NULL, '1964-06-11', 'PROM', 11970, 13, 20, '820427/1234', 'sykora', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (4, 'Martin', 'Petras', 'Bc.', NULL, '1989-12-03', 'TECH', 25935, 5, 3, NULL, 'petras', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (11, 'Martin', 'Ferenz', 'Mgr.', NULL, '1983-08-25', 'PROD', NULL, 7, 13, NULL, 'ferenz', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (3, 'Michal', 'Suk', 'Ing.', NULL, '1975-11-07', 'HL TECH', 24937.5, 5, 7, '751107/1234', 'suk', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (6, 'Aleš ', 'Metzner', NULL, NULL, '1993-02-28', 'AS TECH', 12967.5, 5, 5, '930228/1234', 'metzner', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (10, 'Eliška', 'Ripamonti', 'Mgr.', NULL, '1984-02-06', 'VED', 32917.5, 5, 9, '840206/1234', 'ripamonti', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (2, 'Agáta', 'Červinská', 'Mgr.', NULL, '1964-05-18', 'VED', 31920, 14, 9, '640518/1234', 'cervinska', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (9, 'David', 'Kadeřábek', 'Ing.', NULL, '1978-08-08', 'VED ŘET', 45885, NULL, NULL, '780808/1234', 'kaderabek', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (13, 'Jan ', 'Zelený', 'DiS.', NULL, '1979-01-02', 'VED', 31920, 7, 9, '790102/1234', 'zeleny', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (14, 'Marek', 'Drábek', NULL, NULL, '1980-10-31', 'VED SM', 21945, 6, 15, '801031/1234', 'drabek', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (15, 'Jaroslava', 'Hladíková', 'Bc.', NULL, '1966-12-09', 'AS VED', 19950, 6, NULL, '661209/1234', 'hladikova', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (20, 'Jana ', 'Staňková', 'MgA.', NULL, '1973-12-11', 'VED', 34912.5, 13, 22, '731211/1234', 'stankova', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (21, 'Ivan', 'Hošek', 'Mgr.', 'Ph.D.', '1972-05-08', 'VED', 37905, 11, 22, '720508/1234', 'hosek', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (22, 'Tomáš ', 'Kabát', NULL, NULL, '1974-02-17', 'VED ŘET', 41895, NULL, NULL, '740217/1234', 'kabat', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (23, 'Veronika', 'Hollarová', 'Ing.', NULL, '1981-07-03', 'VED', 33915, 3, NULL, '810703/1234', 'hollarova', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (25, 'Zuzana', 'Schramková', 'Bc.', NULL, '1982-03-13', 'AS VED', 19451.25, 3, 23, '820313/1234', 'schramkova', '2012-06-01');
INSERT INTO multikina.zamestnanci (id_zam, jmeno, prijmeni, tituly_pred, tiluly_za, dat_nar, id_pozice, plat, id_kina, id_sefa, rodne_cislo, username, nastoupil) VALUES (26, 'Terezie ', 'Kunftová', NULL, NULL, '1980-11-09', 'VED SM', 27930, 3, 25, '801109/1234', 'kunftova', '2012-06-01');


--
-- Data for Name: zanry; Type: TABLE DATA; Schema: multikina; Owner: valenta
--

INSERT INTO multikina.zanry (zanr_kod, popis) VALUES ('THIL', 'Thiller');
INSERT INTO multikina.zanry (zanr_kod, popis) VALUES ('KOM', 'Komedie');
INSERT INTO multikina.zanry (zanr_kod, popis) VALUES ('DRAM', 'Drama');
INSERT INTO multikina.zanry (zanr_kod, popis) VALUES ('AKCE', 'Akční');
INSERT INTO multikina.zanry (zanr_kod, popis) VALUES ('SCIFI', 'Sci-fi');
INSERT INTO multikina.zanry (zanr_kod, popis) VALUES ('MYST', 'Mysteriózní');
INSERT INTO multikina.zanry (zanr_kod, popis) VALUES ('ŽIV', 'Životopisný');
INSERT INTO multikina.zanry (zanr_kod, popis) VALUES ('ROM', 'Romantický');
INSERT INTO multikina.zanry (zanr_kod, popis) VALUES ('HIST', 'Historický');
INSERT INTO multikina.zanry (zanr_kod, popis) VALUES ('FANT', 'Fantasy');
INSERT INTO multikina.zanry (zanr_kod, popis) VALUES ('DOBR', 'Dobrodružný');
INSERT INTO multikina.zanry (zanr_kod, popis) VALUES ('HOROR', 'Horor');
INSERT INTO multikina.zanry (zanr_kod, popis) VALUES ('PSYCH', 'Psychologický');


--
-- Data for Name: zeme; Type: TABLE DATA; Schema: multikina; Owner: valenta
--

INSERT INTO multikina.zeme (zeme_kod, nazev) VALUES ('CZE', 'Česká republika');
INSERT INTO multikina.zeme (zeme_kod, nazev) VALUES ('GB', 'Velká Británíe');
INSERT INTO multikina.zeme (zeme_kod, nazev) VALUES ('AUS', 'Austrálie');
INSERT INTO multikina.zeme (zeme_kod, nazev) VALUES ('USA', 'USA');
INSERT INTO multikina.zeme (zeme_kod, nazev) VALUES ('CSR', 'Československo');
INSERT INTO multikina.zeme (zeme_kod, nazev) VALUES ('ISR', 'Izrael');
INSERT INTO multikina.zeme (zeme_kod, nazev) VALUES ('SWE', 'Švédsko');
INSERT INTO multikina.zeme (zeme_kod, nazev) VALUES ('FRA', 'Francie');
INSERT INTO multikina.zeme (zeme_kod, nazev) VALUES ('CAN', 'Kanada');
INSERT INTO multikina.zeme (zeme_kod, nazev) VALUES ('IND', 'Indie');
INSERT INTO multikina.zeme (zeme_kod, nazev) VALUES ('NO', 'Normanské ostrovy');
INSERT INTO multikina.zeme (zeme_kod, nazev) VALUES ('ESP', 'Španělsko');
INSERT INTO multikina.zeme (zeme_kod, nazev) VALUES ('DNK', 'Dánsko');
INSERT INTO multikina.zeme (zeme_kod, nazev) VALUES ('DEU', 'Německo');
INSERT INTO multikina.zeme (zeme_kod, nazev) VALUES ('HUN', 'Maďarsko');
INSERT INTO multikina.zeme (zeme_kod, nazev) VALUES ('CHE', 'Švýcarsko');


--
-- Name: filmy film_pk; Type: CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.filmy
    ADD CONSTRAINT film_pk PRIMARY KEY (id_filmu);


--
-- Name: filmy_zanry film_zanr__idx; Type: CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.filmy_zanry
    ADD CONSTRAINT film_zanr__idx PRIMARY KEY (id_filmu, zanr_kod);


--
-- Name: filmy_zeme film_zeme__idx; Type: CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.filmy_zeme
    ADD CONSTRAINT film_zeme__idx PRIMARY KEY (zeme_kod, id_filmu);


--
-- Name: kina kino_pk; Type: CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.kina
    ADD CONSTRAINT kino_pk PRIMARY KEY (id_kina);


--
-- Name: osoby osoba_pk; Type: CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.osoby
    ADD CONSTRAINT osoba_pk PRIMARY KEY (id_osoby);


--
-- Name: herci pk_herec; Type: CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.herci
    ADD CONSTRAINT pk_herec PRIMARY KEY (id_herce);


--
-- Name: obsazeni pk_hraje; Type: CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.obsazeni
    ADD CONSTRAINT pk_hraje PRIMARY KEY (id_herce, id_filmu, role);


--
-- Name: reziseri pk_reziser; Type: CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.reziseri
    ADD CONSTRAINT pk_reziser PRIMARY KEY (id_rezisera);


--
-- Name: saly pk_sal; Type: CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.saly
    ADD CONSTRAINT pk_sal PRIMARY KEY (id_kina, cislo);


--
-- Name: platove_tridy platova_trida_pk; Type: CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.platove_tridy
    ADD CONSTRAINT platova_trida_pk PRIMARY KEY (oznaceni);


--
-- Name: prac_pozice pozice_pk; Type: CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.prac_pozice
    ADD CONSTRAINT pozice_pk PRIMARY KEY (id_pozice);


--
-- Name: predstaveni predstaveni_pk; Type: CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.predstaveni
    ADD CONSTRAINT predstaveni_pk PRIMARY KEY (id_predstaveni);


--
-- Name: vstupenky vstupenka_pk; Type: CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.vstupenky
    ADD CONSTRAINT vstupenka_pk PRIMARY KEY (id_vstupenky);


--
-- Name: zam_historie zam_historie_pk; Type: CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.zam_historie
    ADD CONSTRAINT zam_historie_pk PRIMARY KEY (id_historie);


--
-- Name: zamestnanci zamestnanci_username_key; Type: CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.zamestnanci
    ADD CONSTRAINT zamestnanci_username_key UNIQUE (username);


--
-- Name: zamestnanci zamestnanec_pk; Type: CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.zamestnanci
    ADD CONSTRAINT zamestnanec_pk PRIMARY KEY (id_zam);


--
-- Name: zanry zanr_pk; Type: CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.zanry
    ADD CONSTRAINT zanr_pk PRIMARY KEY (zanr_kod);


--
-- Name: zeme zeme_pk; Type: CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.zeme
    ADD CONSTRAINT zeme_pk PRIMARY KEY (zeme_kod);


--
-- Name: obsazeni film_hraje; Type: FK CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.obsazeni
    ADD CONSTRAINT film_hraje FOREIGN KEY (id_filmu) REFERENCES multikina.filmy(id_filmu);


--
-- Name: predstaveni film_predstaveni; Type: FK CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.predstaveni
    ADD CONSTRAINT film_predstaveni FOREIGN KEY (id_filmu) REFERENCES multikina.filmy(id_filmu);


--
-- Name: filmy_zeme film_zame_zeme_fk; Type: FK CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.filmy_zeme
    ADD CONSTRAINT film_zame_zeme_fk FOREIGN KEY (zeme_kod) REFERENCES multikina.zeme(zeme_kod) ON DELETE CASCADE;


--
-- Name: filmy_zanry film_zanr_film_fk; Type: FK CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.filmy_zanry
    ADD CONSTRAINT film_zanr_film_fk FOREIGN KEY (zanr_kod) REFERENCES multikina.zanry(zanr_kod) ON DELETE CASCADE;


--
-- Name: filmy_zanry film_zanr_zanr_fk; Type: FK CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.filmy_zanry
    ADD CONSTRAINT film_zanr_zanr_fk FOREIGN KEY (id_filmu) REFERENCES multikina.filmy(id_filmu) ON DELETE CASCADE;


--
-- Name: filmy_zeme film_zeme_zeme_fk; Type: FK CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.filmy_zeme
    ADD CONSTRAINT film_zeme_zeme_fk FOREIGN KEY (id_filmu) REFERENCES multikina.filmy(id_filmu) ON DELETE CASCADE;


--
-- Name: obsazeni herec_hraje; Type: FK CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.obsazeni
    ADD CONSTRAINT herec_hraje FOREIGN KEY (id_herce) REFERENCES multikina.herci(id_herce);


--
-- Name: zamestnanci nadrizeny; Type: FK CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.zamestnanci
    ADD CONSTRAINT nadrizeny FOREIGN KEY (id_sefa) REFERENCES multikina.zamestnanci(id_zam) ON DELETE SET NULL;


--
-- Name: zam_historie pozice_historie; Type: FK CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.zam_historie
    ADD CONSTRAINT pozice_historie FOREIGN KEY (id_pozice) REFERENCES multikina.prac_pozice(id_pozice) ON DELETE SET NULL;


--
-- Name: zamestnanci pracuje; Type: FK CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.zamestnanci
    ADD CONSTRAINT pracuje FOREIGN KEY (id_kina) REFERENCES multikina.kina(id_kina) ON DELETE SET NULL;


--
-- Name: filmy reziruje; Type: FK CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.filmy
    ADD CONSTRAINT reziruje FOREIGN KEY (id_rezisera) REFERENCES multikina.reziseri(id_rezisera) ON DELETE SET NULL;


--
-- Name: predstaveni sal_predstavenii; Type: FK CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.predstaveni
    ADD CONSTRAINT sal_predstavenii FOREIGN KEY (id_kina, cislo) REFERENCES multikina.saly(id_kina, cislo);


--
-- Name: saly sal_v_kine; Type: FK CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.saly
    ADD CONSTRAINT sal_v_kine FOREIGN KEY (id_kina) REFERENCES multikina.kina(id_kina);


--
-- Name: vstupenky vip_osoba; Type: FK CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.vstupenky
    ADD CONSTRAINT vip_osoba FOREIGN KEY (id_osoby) REFERENCES multikina.osoby(id_osoby);


--
-- Name: vstupenky vip_vstupenka; Type: FK CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.vstupenky
    ADD CONSTRAINT vip_vstupenka FOREIGN KEY (id_kina) REFERENCES multikina.kina(id_kina);


--
-- Name: vstupenky volna_vstupenka; Type: FK CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.vstupenky
    ADD CONSTRAINT volna_vstupenka FOREIGN KEY (id_predstaveni) REFERENCES multikina.predstaveni(id_predstaveni);


--
-- Name: zam_historie zamestnanec_history; Type: FK CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.zam_historie
    ADD CONSTRAINT zamestnanec_history FOREIGN KEY (id_zam) REFERENCES multikina.zamestnanci(id_zam) ON DELETE SET NULL;


--
-- Name: zamestnanci zamestnanec_pozice; Type: FK CONSTRAINT; Schema: multikina; Owner: valenta
--

ALTER TABLE ONLY multikina.zamestnanci
    ADD CONSTRAINT zamestnanec_pozice FOREIGN KEY (id_pozice) REFERENCES multikina.prac_pozice(id_pozice);


--
-- Name: umelci_pk; Type: CONSTRAINT; Schema: multikina; Owner: -; Tablespace:
--

ALTER TABLE ONLY multikina.umelci
    ADD CONSTRAINT umelci_pk PRIMARY KEY (id_umelce);


--
-- PostgreSQL database dump complete
--


