-- -- 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 --