insert.sql

--------------------------------------------------------
--  File created - Pátek-dubna-27-2018   
--------------------------------------------------------

set autocommit on;

exec VYMAZ_DATA_VSECH_TABULEK;

exec VYPNI_CIZI_KLICE;




REM INSERTING into ADRESA
SET DEFINE OFF;
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('2','98','stitneho','zulova');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('4','47','Kejbaly','Mlecice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('6','162','Kohoutovicka','Liciborice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('8','34','Zabrdovicka','Horni Podluzi');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('10','120','Blanenska','Suchdol nad Luznici');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('12','125','Stredova','Sveradice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('14','95','stepanska','Libesice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('16','19','Otakara sevcika','Turkovice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('18','52','Druzstevni','Martinkovice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('20','92','Meznikova','Bychory');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('22','91','Vinicni','zizelice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('24','138','Komarovska','Chlum u Trebone');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('26','15','Milenova','ujezd u Brna');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('28','51','Hajkova','Vezna');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('30','76','Krizova','Mala upa');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('32','13','Sedlackova','zitkova');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('34','143','sromova','Kyjov');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('36','166','Schodova','Prackovice nad Labem');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('38','142','Kralovopolsky tunel','Detmarovice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('40','72','Krizova','Mnichovo Hradiste');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('42','42','Wurmova','Brezolupy');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('44','70','Potocni','Jamolice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('46','76','Rozmarynova','Duba');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('48','56','Kopecna','Majdalena');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('50','81','Marie Pujmanove','Tvrzice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('52','17','Psikalova','Putimov');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('54','35','K terminalu','Zamrsky');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('56','14','Olbrachtovo namesti','Neslovice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('58','97','Roviny','Chotilsko');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('60','86','Schwaigrova','Domasov nad Bystrici');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('62','186','Sousedni','Jarcova');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('64','197','Tuckova','cernovice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('66','103','Spacilova','Lhenice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('68','193','Blanenska','Praha');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('70','158','Bednarova','Slavnic');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('72','124','trida Kpt. Jarose','Vysoka Pec');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('74','72','Nad dedinou','Citov');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('76','193','Za Hasickou','Havran');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('78','108','Julianovske namesti','Jarohnevice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('80','67','Meznikova','Trutnov');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('82','62','Krivanky','Lesany');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('84','61','Amerlingova','Tucapy');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('86','80','zeleznicarska','Vicov');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('88','134','Nad kasnou','Horni Myslova');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('90','120','Prizova','Choryne');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('92','113','Sedlakova','Lisna');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('94','32','Na Padelkach','Uhrice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('96','41','Chochola','Zadni Treban');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('98','144','Miksickova','Blatec');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('100','135','Plachtova','cerna v Posumavi');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('102','64','Kapucinske namesti','Lobendava');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('104','154','Pompova','Drnovice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('106','144','Chrpova','Komna');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('108','26','Kartouzska','Mladonovice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('110','56','Listnata','Velka Polom');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('112','3','Koblizna','Nedakonice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('114','180','Widmannova','Krenovice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('116','30','ujezdy','Jicineves');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('118','101','Kostalova','Pavlovice u Kojetina');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('120','172','Stromovka','Planice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('122','102','Rolencova','Liberec');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('124','127','Ponavka','Semice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('126','49','U zbrojnice','Voznice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('128','149','Moravanske lany','Mnisek pod Brdy');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('130','130','Kmochova','Branany');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('132','9','Mysliveckova','Klucov');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('134','49','Kudrnova','Menin');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('136','27','Kroupova','Haje');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('138','41','Buresova','cernosin');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('140','29','Odbojarska','Velika Ves');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('142','55','Gogolova','Kunice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('144','44','Rysova','Frydlant');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('146','51','Spesna','Velke Losiny');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('148','167','Zakouti','Stracov');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('150','69','Na hrazi','Putim');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('152','128','Lovecka','Bohusov');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('154','84','Podolska','Velky Malahov');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('156','48','ceska','Hvozdec');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('158','19','Zezulova','Polna');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('160','182','Borky','Radkov');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('162','70','U lesicka','zelkovice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('164','170','V koutku','Tyniste nad Orlici');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('166','162','Farskeho','Jablonec nad Nisou');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('168','40','Svatoplukova','Bylany');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('170','76','Potacelova','Benesov');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('172','115','spitalka','Nove Hrady');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('174','38','cekankova','Brezany');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('176','20','Stredova','Liberec');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('178','38','Jehlicnata','Cerhenice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('180','93','upatni','Bor');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('182','8','Kosinova','Dalovice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('184','88','Novomoravanska','Havran');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('186','61','Antoninska','Banovice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('188','62','Kovarska','Vikantice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('190','16','Pod kopcem','Sazava');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('192','12','Vavrinecka','Mlade Buky');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('194','16','Jarni','Horni Kounice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('196','72','cechynska','Kozarovice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('198','32','Velka Klajdovka','Metylovice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('200','66','svedske valy','Zahori');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('202','95','Vyskovska','Milotice nad Becvou');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('204','4','Krivankovo namesti','Hruska');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('206','163','Neuzilova','Petrohrad');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('208','141','Hybesova','Vidlata Sec');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('210','96','Budovcova','Trhova Kamenice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('212','116','Bohunova','sabina');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('214','20','Chlumy','zampach');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('216','128','Zapadni','Jamne nad Orlici');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('218','157','Vltavska','Kaliste');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('220','142','Klacelova','Horusice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('222','41','Na Padelkach','Bednarecek');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('224','159','Zaleskeho','Suchdol nad Luznici');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('226','81','Gorkeho','Stremy');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('228','133','Klobasova','Zadni Stritez');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('230','71','Drinova','Teplice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('232','74','Bednarova','Louka');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('234','3','Uprkova','Cholenice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('236','8','Hlubocek','Vicov');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('238','85','Kratina','Branany');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('240','95','Kuldova','Nemcice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('244','118','sipkova','Polom');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('246','155','Krameriova','Vodice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('248','63','selepova','Kyje');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('250','42','Dufkovo nabrezi','Hradec Kralove');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('252','30','Branka','Topolany');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('254','124','Hlohova','ceska Kubice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('256','181','Rozhledova','Volec');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('258','178','Vyholec','Marenice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('260','55','Pellicova','Trnova');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('262','189','Rosicka','Horni Dvoriste');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('264','123','Pisniky','Voderady');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('268','125','Veslarska','Volfirov');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('270','24','Valcharska','Chotesov');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('274','74','Stara','Olesna');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('276','174','Na Nivach','Borohradek');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('278','120','Ledarenska','Velesin');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('280','142','Jetelova','Rosec');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('282','158','spilberk','Podhradi nad Dyji');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('284','103','Panenska','Jablonany');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('286','95','Pod Ostrou','Pisek');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('288','139','Sladkovskeho','Dolni Bukovsko');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('290','146','Kroupova','Sudislav nad Orlici');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('292','159','Bystrcka','Velka Bites');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('294','138','Hubrova','Pteni');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('296','130','Soukenicka','Krakovany');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('298','104','Zimni','Slatina');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('300','141','spackova','Mukarov');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('302','56','Mickova','Struharov');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('304','3','Pod kapli','Nova Ves nad Luznici');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('306','199','Slamova','Trebiz');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('308','55','Vcelickova','Kunratice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('310','175','K Bukovinam','Libchavy');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('312','44','Klicova','Prusice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('314','151','Jandaskova','Peruc');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('316','121','Za kostelem','Przno');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('318','142','U vlecky','Lazsko');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('320','107','Sobesicka','Jicineves');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('322','40','Prokofjevova','Horni Dubnany');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('324','155','Vyhlidalova','Kout na sumave');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('326','152','Hluboka','Labuty');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('328','50','stepankova','Bila Tremesna');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('330','15','U hriste','Jetrichov');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('332','119','Dornych','Jachymov');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('334','178','Generala Kadlece','Drahonin');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('336','75','Vesela','Moravsky Krumlov');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('338','87','Parkova','Milhostov');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('340','124','sestakova','ujezd');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('342','93','Bukova','Kosetice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('344','4','radova','Blansko');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('346','1','Drinova','Bohdalice-Pavlovice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('348','7','Sladovnicka','Buchlovice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('350','45','Souckova','Ivan');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('354','21','Vedlejsi','Krchleby');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('356','24','Horni','Drhovice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('358','149','Bohunova','Dalesice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('360','121','Mozartova','Troubky');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('362','102','zabovreska','Horni Cerekev');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('364','170','Zeleneho','Kamenna Lhota');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('366','15','Bidlaky','Chuderov');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('368','192','Lipska','Hurtova Lhota');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('370','50','Cyrilska','Breclav');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('372','180','Trybova','Otmice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('374','69','Zkratka','Osice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('376','151','Blatouchova','Moravany');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('378','66','Zajeci hora','Belec');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('380','32','Hrabalova','Kunkovice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('382','40','Karoliny Svetle','Ohnistany');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('384','187','Kladivova','zupanovice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('386','11','Svatoplukova','Podivin');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('388','184','Turanka','ujezd u Brna');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('390','51','Richarda Knose','Vsechovice');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('392','40','Rygle','Nyrsko');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('394','21','Ambrozova','Ondrejov');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('396','113','Bratislavska','Roznov pod Radhostem');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('398','200','Helencina','Vrdy');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('400','45','Rybizova','Domamil');
Insert into ADRESA (ADRESA_KEY,CISLO_POPISNE,ULICE,MESTO) values ('272','67','Ruzenec','Rovensko');
REM INSERTING into FAMFRPALOVY_TYM
SET DEFINE OFF;
Insert into FAMFRPALOVY_TYM (PREZDIVKA,KOLEJ_NAZEV_KOLEJE) values ('lvi','Nebelvir');
Insert into FAMFRPALOVY_TYM (PREZDIVKA,KOLEJ_NAZEV_KOLEJE) values ('hadi','Zmijozel');
Insert into FAMFRPALOVY_TYM (PREZDIVKA,KOLEJ_NAZEV_KOLEJE) values ('jezevci','Mrzimor');
Insert into FAMFRPALOVY_TYM (PREZDIVKA,KOLEJ_NAZEV_KOLEJE) values (null,'Havraspar');
REM INSERTING into FAMFRPALT
SET DEFINE OFF;
Insert into FAMFRPALT (PREZDIVKA,KOLEJ_NAZEV_KOLEJE) values ('lvi','Nebelvir');
Insert into FAMFRPALT (PREZDIVKA,KOLEJ_NAZEV_KOLEJE) values ('hadi','Zmijozel');
Insert into FAMFRPALT (PREZDIVKA,KOLEJ_NAZEV_KOLEJE) values ('jezevci','Mrzimor');
Insert into FAMFRPALT (PREZDIVKA,KOLEJ_NAZEV_KOLEJE) values (null,'Havraspar');
REM INSERTING into HRAC
SET DEFINE OFF;
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('1','strelec','j','1','Nebelvir');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('2','strelec','q','6','Nebelvir');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('3','strelec','i','11','Nebelvir');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('4','strelec','a','16','Zmijozel');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('5','strelec','h','21','Zmijozel');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('6','strelec','c','26','Zmijozel');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('7','strelec','q','31','Havraspar');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('8','strelec','v','36','Havraspar');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('9','strelec','f','41','Havraspar');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('10','strelec','v','46','Mrzimor');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('11','strelec','x','51','Mrzimor');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('12','strelec','l','56','Mrzimor');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('13','odrazec','k','61','Nebelvir');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('14','odrazec','r','66','Nebelvir');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('15','odrazec','k','71','Zmijozel');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('16','odrazec','m','76','Zmijozel');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('17','odrazec','k','81','Havraspar');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('18','odrazec','v','86','Havraspar');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('19','odrazec','d','91','Mrzimor');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('20','odrazec','q','96','Mrzimor');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('21','brankar','w','101','Nebelvir');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('22','brankar','w','106','Zmijozel');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('23','brankar','j','111','Havraspar');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('24','brankar','r','116','Mrzimor');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('25','chytac','j','121','Nebelvir');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('26','chytac','e','126','Zmijozel');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('27','chytac','s','131','Havraspar');
Insert into HRAC (CISLO,POZICE,KOSTE,STUDENT_ID_STUDENT,FAMFRPALT_KOLEJ_NAZEV_KOLEJE) values ('28','chytac','v','136','Mrzimor');
REM INSERTING into KOLEJ
SET DEFINE OFF;
Insert into KOLEJ (NAZEV_KOLEJE,BARVA,PATRON,ZKRATKA_KOLEJE,UCITEL_ID_ZAMESTNANEC) values ('Nebelvir','cervena','Godrik Nebelvir','NB','1');
Insert into KOLEJ (NAZEV_KOLEJE,BARVA,PATRON,ZKRATKA_KOLEJE,UCITEL_ID_ZAMESTNANEC) values ('Zmijozel','zelena','Salazar Zmijozel','ZM','4');
Insert into KOLEJ (NAZEV_KOLEJE,BARVA,PATRON,ZKRATKA_KOLEJE,UCITEL_ID_ZAMESTNANEC) values ('Havraspar','modra','Rowena z Havrasparu','HV','7');
Insert into KOLEJ (NAZEV_KOLEJE,BARVA,PATRON,ZKRATKA_KOLEJE,UCITEL_ID_ZAMESTNANEC) values ('Mrzimor','zluta','Helga z Mrzimoru','MZ','10');
REM INSERTING into OSTATNI
SET DEFINE OFF;
Insert into OSTATNI (POZICE,ZAMESTNANEC_ID_ZAMESTNANEC) values ('skolnik','13');
Insert into OSTATNI (POZICE,ZAMESTNANEC_ID_ZAMESTNANEC) values ('hajny','16');
Insert into OSTATNI (POZICE,ZAMESTNANEC_ID_ZAMESTNANEC) values ('knihovnik','19');
Insert into OSTATNI (POZICE,ZAMESTNANEC_ID_ZAMESTNANEC) values ('kuchar','22');
Insert into OSTATNI (POZICE,ZAMESTNANEC_ID_ZAMESTNANEC) values ('doktor','25');
Insert into OSTATNI (POZICE,ZAMESTNANEC_ID_ZAMESTNANEC) values ('zdravotni sestra','28');
Insert into OSTATNI (POZICE,ZAMESTNANEC_ID_ZAMESTNANEC) values ('zahradnik','31');
Insert into OSTATNI (POZICE,ZAMESTNANEC_ID_ZAMESTNANEC) values ('doktor','34');
Insert into OSTATNI (POZICE,ZAMESTNANEC_ID_ZAMESTNANEC) values ('zdravotni sestra','37');
Insert into OSTATNI (POZICE,ZAMESTNANEC_ID_ZAMESTNANEC) values ('kuchar','40');
REM INSERTING into POVINNE_VOLITELNY
SET DEFINE OFF;
Insert into POVINNE_VOLITELNY (NAZEV,ZKRATKA,POVINNE_VOLITELNY_TYPE) values ('jasnovidectvi','js','Povinne_volitelny');
Insert into POVINNE_VOLITELNY (NAZEV,ZKRATKA,POVINNE_VOLITELNY_TYPE) values ('pece o kouzelne tvory','pokt','Povinne_volitelny');
Insert into POVINNE_VOLITELNY (NAZEV,ZKRATKA,POVINNE_VOLITELNY_TYPE) values ('vesteni z cisel','vc','Povinne_volitelny');
Insert into POVINNE_VOLITELNY (NAZEV,ZKRATKA,POVINNE_VOLITELNY_TYPE) values ('studium mudlu','sm','Povinne_volitelny');
Insert into POVINNE_VOLITELNY (NAZEV,ZKRATKA,POVINNE_VOLITELNY_TYPE) values ('starodavne runy','sr','Povinne_volitelny');
REM INSERTING into POVINNY
SET DEFINE OFF;
Insert into POVINNY (NAZEV,PRUCHODNOST,POVINNY_TYPE) values ('premenovani','60','Povinny');
Insert into POVINNY (NAZEV,PRUCHODNOST,POVINNY_TYPE) values ('obrana proti cerne magii','75','Povinny');
Insert into POVINNY (NAZEV,PRUCHODNOST,POVINNY_TYPE) values ('bylinkarstvi','98','Povinny');
Insert into POVINNY (NAZEV,PRUCHODNOST,POVINNY_TYPE) values ('kouzelne formule','87','Povinny');
Insert into POVINNY (NAZEV,PRUCHODNOST,POVINNY_TYPE) values ('lektvary','50','Povinny');
Insert into POVINNY (NAZEV,PRUCHODNOST,POVINNY_TYPE) values ('dejiny car a kouzel','100','Povinny');
Insert into POVINNY (NAZEV,PRUCHODNOST,POVINNY_TYPE) values ('astronomie','99','Povinny');
Insert into POVINNY (NAZEV,PRUCHODNOST,POVINNY_TYPE) values ('letani na kosteti','100','Povinny');
Insert into POVINNY (NAZEV,PRUCHODNOST,POVINNY_TYPE) values ('premistovani','88','Povinny');
REM INSERTING into PREDMET
SET DEFINE OFF;
Insert into PREDMET (NAZEV,UCITEL_ZAMESTNANEC_ID_ZAM,PREDMET_TYPE) values ('premenovani','1','Povinny');
Insert into PREDMET (NAZEV,UCITEL_ZAMESTNANEC_ID_ZAM,PREDMET_TYPE) values ('obrana proti cerne magii','4','Povinny');
Insert into PREDMET (NAZEV,UCITEL_ZAMESTNANEC_ID_ZAM,PREDMET_TYPE) values ('bylinkarstvi','7','Povinny');
Insert into PREDMET (NAZEV,UCITEL_ZAMESTNANEC_ID_ZAM,PREDMET_TYPE) values ('kouzelne formule','10','Povinny');
Insert into PREDMET (NAZEV,UCITEL_ZAMESTNANEC_ID_ZAM,PREDMET_TYPE) values ('lektvary','43','Povinny');
Insert into PREDMET (NAZEV,UCITEL_ZAMESTNANEC_ID_ZAM,PREDMET_TYPE) values ('dejiny car a kouzel','46','Povinny');
Insert into PREDMET (NAZEV,UCITEL_ZAMESTNANEC_ID_ZAM,PREDMET_TYPE) values ('astronomie','49','Povinny');
Insert into PREDMET (NAZEV,UCITEL_ZAMESTNANEC_ID_ZAM,PREDMET_TYPE) values ('letani na kosteti','52','Povinny');
Insert into PREDMET (NAZEV,UCITEL_ZAMESTNANEC_ID_ZAM,PREDMET_TYPE) values ('premistovani','55','Povinny');
Insert into PREDMET (NAZEV,UCITEL_ZAMESTNANEC_ID_ZAM,PREDMET_TYPE) values ('jasnovidectvi','58','Povinne_volitelny');
Insert into PREDMET (NAZEV,UCITEL_ZAMESTNANEC_ID_ZAM,PREDMET_TYPE) values ('pece o kouzelne tvory','61','Povinne_volitelny');
Insert into PREDMET (NAZEV,UCITEL_ZAMESTNANEC_ID_ZAM,PREDMET_TYPE) values ('vesteni z cisel','64','Povinne_volitelny');
Insert into PREDMET (NAZEV,UCITEL_ZAMESTNANEC_ID_ZAM,PREDMET_TYPE) values ('studium mudlu','67','Povinne_volitelny');
Insert into PREDMET (NAZEV,UCITEL_ZAMESTNANEC_ID_ZAM,PREDMET_TYPE) values ('starodavne runy','70','Povinne_volitelny');
REM INSERTING into PREDMET_V_ROCNIKU
SET DEFINE OFF;
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('1','astronomie');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('1','bylinkarstvi');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('1','dejiny car a kouzel');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('1','kouzelne formule');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('1','lektvary');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('1','obrana proti cerne magii');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('2','astronomie');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('2','bylinkarstvi');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('2','dejiny car a kouzel');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('2','kouzelne formule');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('2','lektvary');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('2','obrana proti cerne magii');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('3','astronomie');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('3','bylinkarstvi');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('3','dejiny car a kouzel');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('3','kouzelne formule');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('3','lektvary');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('3','obrana proti cerne magii');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('4','astronomie');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('4','bylinkarstvi');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('4','dejiny car a kouzel');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('4','kouzelne formule');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('4','lektvary');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('4','obrana proti cerne magii');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('5','astronomie');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('5','bylinkarstvi');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('5','dejiny car a kouzel');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('5','kouzelne formule');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('5','lektvary');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('5','obrana proti cerne magii');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('6','astronomie');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('6','bylinkarstvi');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('6','dejiny car a kouzel');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('6','kouzelne formule');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('6','lektvary');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('6','obrana proti cerne magii');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('7','astronomie');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('7','bylinkarstvi');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('7','dejiny car a kouzel');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('7','kouzelne formule');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('7','lektvary');
Insert into PREDMET_V_ROCNIKU (ROCNIK_ID_ROCNIK,POVINNY_NAZEV) values ('7','obrana proti cerne magii');
REM INSERTING into PREFEKT
SET DEFINE OFF;
Insert into PREFEKT (PRUMER_ZNAMEK,STUDENT_ID_STUDENT) values ('1','126');
Insert into PREFEKT (PRUMER_ZNAMEK,STUDENT_ID_STUDENT) values ('1','131');
Insert into PREFEKT (PRUMER_ZNAMEK,STUDENT_ID_STUDENT) values ('1','136');
Insert into PREFEKT (PRUMER_ZNAMEK,STUDENT_ID_STUDENT) values ('1','141');
Insert into PREFEKT (PRUMER_ZNAMEK,STUDENT_ID_STUDENT) values ('1','151');
Insert into PREFEKT (PRUMER_ZNAMEK,STUDENT_ID_STUDENT) values ('1','156');
Insert into PREFEKT (PRUMER_ZNAMEK,STUDENT_ID_STUDENT) values ('1','121');
Insert into PREFEKT (PRUMER_ZNAMEK,STUDENT_ID_STUDENT) values ('1','146');
REM INSERTING into PRIMUS
SET DEFINE OFF;
Insert into PRIMUS (PREZDIVKA,PREFEKT_STUDENT_ID_STUDENT) values ('typek','156');
REM INSERTING into REDITEL
SET DEFINE OFF;
Insert into REDITEL (KOUZELNICKY_TITUL,ZAMESTNANEC_ID_ZAMESTNANEC) values ('Nejhlavnejsí hlavoun MezinarodniSdruzeniKouzelniku','73');
REM INSERTING into ROCNIK
SET DEFINE OFF;
Insert into ROCNIK (ID_ROCNIK) values ('1');
Insert into ROCNIK (ID_ROCNIK) values ('2');
Insert into ROCNIK (ID_ROCNIK) values ('3');
Insert into ROCNIK (ID_ROCNIK) values ('4');
Insert into ROCNIK (ID_ROCNIK) values ('5');
Insert into ROCNIK (ID_ROCNIK) values ('6');
Insert into ROCNIK (ID_ROCNIK) values ('7');
REM INSERTING into STUDENT
SET DEFINE OFF;
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('1','Dominik','Starek','2003','M','Synkova','78','2','Nebelvir');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('6','Ignac','Hampl','2005','F','Kubelikova','362','6','Nebelvir');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('16','Edita','Grossova','2007','R','cejkova','118','1','Zmijozel');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('21','Tomas','Soucek','2004','H','Frantiskanska','384','6','Zmijozel');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('26','Ferdinand','Petracek','2003','B','Dunajevskeho','24','5','Zmijozel');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('31','Jarmil','Koblizek','2002','P','Tisnovska','40','2','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('36','Marie','Pacakova','2004','S','stefackova','72','4','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('41','Valdemar','Zavadil','2004','R','Rybkova','134','7','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('46','Marta','Pekova','2005','U','Blazovicka','68','2','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('51','Oto','Pernica','2001','K','Ve vilkach','72','2','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('56','Eliska','Syrovatka','2007','L','Botanicka','92','3','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('61','Andela','Fukalova','2004','T','bratri Pelisku','340','2','Nebelvir');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('66','Andrea','Chmelova','2002','R','Videnska','372','6','Nebelvir');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('71','Milena','Ondrusova','2007','X','Olbrachtovo namesti','96','1','Zmijozel');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('76','Kristian','Hruby','2003','Y','Sevrena','184','3','Zmijozel');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('81','Ales','Metelka','2005','U','Mucednicka','8','7','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('86','Cyril','Macak','2007','L','Gargulakova','166','1','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('91','Olga','Niklova','2005','E','Dykova','10','3','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('96','Otylie','durisova','2001','O','Sabinova','348','2','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('106','Ludek','Lukac','2004','O','Voronezska','308','2','Zmijozel');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('111','Mikulas','Jurickova','2007','I','Divisova','392','1','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('116','Drahomira','Psenickova','2004','N','Zeiberlichova','304','3','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('126','Jiri','Docekal','2007','P','Habrova','196','5','Zmijozel');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('131','Jeronym','Pala','2005','M','cerneho','98','5','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('136','Ignac','Just','2001','C','Borodinova','382','5','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('141','Prokop','Davidek','2003','A','Holubova','32','5','Zmijozel');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('151','Eduard','Kos','2006','Y','Moravska','60','5','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('156','Oldrich','Vrbova','2003','L','Padeliky','328','5','Zmijozel');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('236','Svatopluk','Crha','2007','T','Olsi','56','5','Zmijozel');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('241','Milena','Novackova','2003','I','zivotskeho','286','1','Zmijozel');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('246','Veronika','Fricova','2006','L','Krizikova','318','5','Zmijozel');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('251','Horymir','Palka','2006','T','Tylova','12','1','Zmijozel');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('256','Karina','Dedkova','2005','W','Nezvalova','6','1','Zmijozel');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('261','Oliver','Danicek','2007','C','Hadecka','78','6','Zmijozel');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('266','Monika','Zatloukalova','2005','M','Jehnicka','302','4','Zmijozel');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('271','Svetlana','Zasterova','2006','W','zivneho','364','3','Zmijozel');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('276','sarlota','Manova','2004','M','Hlinecka','310','6','Zmijozel');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('281','Jonas','Nejezchleb','2003','R','Kartouzska','102','7','Zmijozel');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('286','Jarmila','zidkova','2007','H','Rohackova','60','5','Zmijozel');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('291','Servac','Chmelar','2006','Y','stastneho','192','3','Zmijozel');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('296','Jarmila','Drozdova','2001','C','Olsova','298','7','Zmijozel');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('301','Drahomira','Polivkova','2004','J','radova','66','6','Zmijozel');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('306','Mojmir','Kubista','2007','C','Drevarska','84','5','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('311','Blanka','Fidlerova','2007','L','Narozni','204','7','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('316','Ingrid','Hyblova','2004','L','cerveny kopec','176','5','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('321','Artur','Laska','2005','Y','Vrbovecka','38','5','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('326','Apolena','Kavanova','2007','M','Metodejova','12','3','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('331','Vlastimil','Cejnar','2007','N','Chodska','224','5','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('336','Liliana','Kubankova','2004','Z','Mutenicka','342','3','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('341','Samuel','Koudela','2002','N','Skandinavska','276','7','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('346','Jana','Dokulilova','2004','U','Jizni svahy','90','7','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('351','Tadeas','Visek','2002','J','zivneho','186','1','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('356','Oliver','skrabal','2004','K','Ponavka','168','7','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('366','Daniela','Kracikova','2007','G','Sedlakova','204','1','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('371','Radmila','smidlova','2005','W','Pahrbek','122','1','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('376','Vlastimil','Brazda','2007','H','namesti Vojtesky Matyasove','386','5','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('381','Julie','Prchlikova','2006','A','Hrazni','14','6','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('386','Ingrid','Madrova','2004','R','Hamry','172','4','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('391','Ludek','Janouch','2002','L','V rejich','88','3','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('396','Sobeslav','Linhart','2007','F','Pod zahradami','244','2','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('401','Rudolf','Hon','2005','U','Konopiska','374','6','Havraspar');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('406','Valerie','Vaclavkova','2004','Q','Okruzni','330','6','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('411','Frantisek','Mocek','2001','K','Modrinova','128','2','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('416','Zbysek','Jech','2003','D','Zatisi','350','5','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('421','Lubor','Vystrcil','2007','M','Zapadni','336','3','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('426','Radana','Januskova','2004','I','Koliste','322','2','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('431','Rostislav','Vondra','2003','Y','Koliste','190','2','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('436','Viola','Pivonkova','2002','P','Podlipna','318','7','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('441','Natasa','sustrova','2001','O','Fantova','192','6','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('446','Svatoslav','Pirek','2006','J','Kubelikova','126','6','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('451','Veroslav','Gaspar','2005','A','stursova','102','6','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('456','Stanislav','Kobylka','2005','X','Technicka','10','6','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('461','Samuel','curda','2006','T','Veslarska','118','2','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('466','Gabriel','Brzobohaty','2001','P','Brezova','206','3','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('471','Emilie','Frydlova','2001','R','ulice 1. kvetna','370','1','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('476','Miriam','Veverkova','2001','W','Ukrajinska','304','1','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('481','Dalibor','spicak','2007','O','Kovarska','122','1','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('486','Tatana','svehlova','2004','V','Prumyslova','210','3','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('491','Michaela','Huskova','2006','L','Kubanky','368','4','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('496','Ingrid','Ptakova','2004','Y','Plize','146','1','Mrzimor');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('121','Miloslav','sefl','2005','M','Klidna','4','5','Nebelvir');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('11','Horymir','Pustejovsky','2002','W','skolni','244','3','Nebelvir');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('101','Vaclav','Brunclik','2006','F','Potacelova','398','3','Nebelvir');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('146','Anna','Kamenicka','2007','N','Korenskeho','288','5','Nebelvir');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('161','Berta','Pecenkova','2006','T','Otevrena','126','5','Nebelvir');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('166','Anna','Syrovatkova','2004','V','Pricni','302','5','Nebelvir');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('171','Blazej','Gazda','2004','B','Rusky vrch','360','5','Nebelvir');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('176','Vojtech','Votava','2002','I','Vypadni','28','3','Nebelvir');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('181','Dagmar','Raszkova','2007','B','Klacelova','194','5','Nebelvir');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('186','Magdalena','cechurova','2004','W','Preslova','134','6','Nebelvir');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('191','stepanka','Holoubkova','2001','X','Kninicska','310','2','Nebelvir');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('196','Felix','Botek','2003','S','Lesni','60','1','Nebelvir');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('201','Stanislav','Erben','2007','W','Tuckova','10','1','Nebelvir');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('206','Albert','Smrz','2004','P','K Povodi','54','6','Nebelvir');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('211','Milos','Kupka','2002','T','Ruzenec','196','1','Nebelvir');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('216','Sara','Stara','2005','T','Hlinecka','162','1','Nebelvir');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('221','Jirina','Petranova','2001','H','Pod Komorou','64','6','Nebelvir');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('226','Radana','Kropackova','2001','K','Rysova','226','1','Nebelvir');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('231','Regina','Babicka','2007','U','Na Buble','86','1','Nebelvir');
Insert into STUDENT (ID_STUDENT,JMENO,PRIJMENI,ROK_NAROZENI,HULKA,SOVA,ADRESA_ADRESA_KEY,ROCNIK_ID_ROCNIK,KOLEJ_NAZEV_KOLEJE) values ('361','Bernard','siroky','2001','R','Jizni svahy','272','3','Havraspar');
REM INSERTING into STUDUJE
SET DEFINE OFF;
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','6');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','11');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','21');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','26');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','36');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','56');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','66');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','76');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','91');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','101');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','116');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','121');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','126');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','131');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','136');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','141');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','146');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','151');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','156');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','161');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','166');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','171');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','176');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','181');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','186');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','206');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','221');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','236');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','246');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','261');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','266');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','271');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','276');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','281');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','286');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','291');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','296');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','301');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','306');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','311');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','316');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','321');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','326');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','331');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','336');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','341');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','346');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','356');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','361');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','376');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','381');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','386');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','391');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','401');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','406');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','416');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','421');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','436');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','441');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','446');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','451');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','456');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','466');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','486');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('jasnovidectvi','491');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','6');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','26');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','36');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','41');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','56');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','66');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','76');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','81');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','91');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','101');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','116');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','121');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','126');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','131');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','136');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','141');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','146');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','151');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','156');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','161');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','166');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','171');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','176');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','181');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','186');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','206');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','221');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','236');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','246');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','261');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','266');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','271');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','276');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','281');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','286');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','291');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','296');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','301');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','306');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','311');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','316');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','321');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','326');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','331');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','336');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','341');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','346');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','356');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','361');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','376');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','381');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','386');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','391');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','401');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','406');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','416');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','421');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','436');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','441');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','446');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','451');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','456');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','466');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','486');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('pece o kouzelne tvory','491');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','21');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','26');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','36');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','41');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','56');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','66');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','76');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','81');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','91');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','101');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','116');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','121');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','126');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','131');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','136');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','141');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','146');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','151');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','156');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','161');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','166');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','171');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','176');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','181');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','186');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','206');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','221');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','236');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','246');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','261');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','266');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','271');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','276');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','281');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','286');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','291');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','296');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','301');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','306');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','311');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','316');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','321');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','326');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','331');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','336');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','341');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','346');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','356');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','361');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','376');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','381');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','386');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','391');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','401');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','406');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','416');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','421');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','436');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','441');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','446');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','451');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','456');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','466');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','486');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('starodavne runy','491');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','6');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','11');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','21');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','26');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','41');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','56');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','66');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','76');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','81');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','91');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','101');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','116');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','121');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','126');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','131');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','136');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','141');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','146');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','151');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','156');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','161');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','166');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','171');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','176');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','181');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','186');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','206');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','221');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','236');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','246');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','261');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','266');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','271');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','276');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','281');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','286');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','291');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','296');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','301');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','306');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','311');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','316');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','321');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','326');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','331');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','336');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','341');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','346');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','356');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','361');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','376');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','381');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','386');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','391');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','401');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','406');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','416');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','421');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','436');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','441');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','446');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','451');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','456');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','466');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','486');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('studium mudlu','491');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','6');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','21');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','36');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','41');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','56');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','66');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','76');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','91');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','101');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','116');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','121');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','126');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','131');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','136');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','141');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','146');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','151');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','156');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','161');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','166');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','171');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','176');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','181');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','186');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','206');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','221');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','236');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','246');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','261');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','266');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','271');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','276');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','281');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','286');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','291');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','296');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','301');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','306');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','311');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','316');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','321');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','326');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','331');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','336');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','341');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','346');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','356');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','361');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','376');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','381');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','386');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','391');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','401');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','406');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','416');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','421');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','436');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','441');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','446');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','451');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','456');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','466');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','486');
Insert into STUDUJE (POVINNE_VOLITELNY_NAZEV,STUDENT_ID_STUDENT) values ('vesteni z cisel','491');
REM INSERTING into UCITEL
SET DEFINE OFF;
Insert into UCITEL (KOUZELNICKY_TITUL,PREDMET_NAZEV,ZAMESTNANEC_ID_ZAMESTNANEC,ZASTUPCE_REDITELE) values ('PaedDr.','premenovani','1','1');
Insert into UCITEL (KOUZELNICKY_TITUL,PREDMET_NAZEV,ZAMESTNANEC_ID_ZAMESTNANEC,ZASTUPCE_REDITELE) values ('PhDr.','obrana proti cerne magii','4','0');
Insert into UCITEL (KOUZELNICKY_TITUL,PREDMET_NAZEV,ZAMESTNANEC_ID_ZAMESTNANEC,ZASTUPCE_REDITELE) values ('Ing. arch.','bylinkarstvi','7','0');
Insert into UCITEL (KOUZELNICKY_TITUL,PREDMET_NAZEV,ZAMESTNANEC_ID_ZAMESTNANEC,ZASTUPCE_REDITELE) values ('MgA.','kouzelne formule','10','0');
Insert into UCITEL (KOUZELNICKY_TITUL,PREDMET_NAZEV,ZAMESTNANEC_ID_ZAMESTNANEC,ZASTUPCE_REDITELE) values ('Ing. arch.','lektvary','43','0');
Insert into UCITEL (KOUZELNICKY_TITUL,PREDMET_NAZEV,ZAMESTNANEC_ID_ZAMESTNANEC,ZASTUPCE_REDITELE) values ('Ing. arch.','dejiny car a kouzel','46','0');
Insert into UCITEL (KOUZELNICKY_TITUL,PREDMET_NAZEV,ZAMESTNANEC_ID_ZAMESTNANEC,ZASTUPCE_REDITELE) values ('PaedDr.','astronomie','49','0');
Insert into UCITEL (KOUZELNICKY_TITUL,PREDMET_NAZEV,ZAMESTNANEC_ID_ZAMESTNANEC,ZASTUPCE_REDITELE) values ('PhDr.','letani na kosteti','52','0');
Insert into UCITEL (KOUZELNICKY_TITUL,PREDMET_NAZEV,ZAMESTNANEC_ID_ZAMESTNANEC,ZASTUPCE_REDITELE) values ('PhMr.','premistovani','55','0');
Insert into UCITEL (KOUZELNICKY_TITUL,PREDMET_NAZEV,ZAMESTNANEC_ID_ZAMESTNANEC,ZASTUPCE_REDITELE) values ('PhDr.','jasnovidectvi','58','0');
Insert into UCITEL (KOUZELNICKY_TITUL,PREDMET_NAZEV,ZAMESTNANEC_ID_ZAMESTNANEC,ZASTUPCE_REDITELE) values ('Ing. arch.','pece o kouzelne tvory','61','0');
Insert into UCITEL (KOUZELNICKY_TITUL,PREDMET_NAZEV,ZAMESTNANEC_ID_ZAMESTNANEC,ZASTUPCE_REDITELE) values ('Ing. arch.','vesteni z cisel','64','0');
Insert into UCITEL (KOUZELNICKY_TITUL,PREDMET_NAZEV,ZAMESTNANEC_ID_ZAMESTNANEC,ZASTUPCE_REDITELE) values ('RSDr.','studium mudlu','67','0');
Insert into UCITEL (KOUZELNICKY_TITUL,PREDMET_NAZEV,ZAMESTNANEC_ID_ZAMESTNANEC,ZASTUPCE_REDITELE) values ('PhMr.','starodavne runy','70','0');
REM INSERTING into ZAMESTNANEC
SET DEFINE OFF;
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('1','Oldriska','Novosadova','1982','23698','204');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('4','Severus','Snape','1971','27169','94');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('7','Nadezda','Krasova','1984','25183','30');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('10','Leona','Drapalova','1971','23805','362');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('13','Vladena','Stehlikova','1984','24728','324');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('16','Libuse','Petrzelkova','1970','20180','132');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('19','Vincenc','Vancura','1981','28042','16');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('22','Veroslav','Bouzek','1978','29279','94');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('25','Radana','Rezkova','1982','24323','94');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('28','Bohuslav','Sobek','1989','21510','182');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('31','Martina','Jakoubkova','1985','26282','254');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('34','Apolena','Jureckova','1976','28545','68');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('37','Tibor','Skacel','1975','21675','56');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('40','Zora','Pipkova','1990','22459','156');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('43','Kristyna','Fouskova','1983','27841','152');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('46','Kristian','Klaus','1989','25831','166');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('49','Vilma','Hruba','1974','27105','176');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('52','Andrea','Jandikova','1980','20909','286');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('55','Petra','Malisova','1980','27845','62');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('58','Veroslav','Macik','1990','26276','128');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('61','Svatoslav','Kryl','1974','23601','332');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('64','Mariana','Lanikova','1989','21532','320');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('67','Teodor','Vit','1987','25466','186');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('70','Martin','Zmizel','1972','27872','294');
Insert into ZAMESTNANEC (ID_ZAMESTNANEC,JMENO,PRIJMENI,ROK_NAROZENI,VYSE_PLATU,ADRESA_ADRESA_KEY) values ('73','Albus','Brumbal','1974','20272','360');



exec ZAPNI_CIZI_KLICE;