insert into x_jazyk values
(1,'slovensky'),
(2,'cesky'),
(3,'anglicky'),
(4,'nemecky'),
(5,'francuzsky'),
(6,'taliansky')
(7,'latinsky')
(8,'spanielsky')

insert into x_autor values
(1,'Umberto','Eco'),
(2,'Lev','Bukovsky'),
(3,'Jan','Vinar'),
(4,'J.R.R.','Tolkien'),
(5,'Jorge Luis','Borges'),
(6,'Peter','Jaros'),
(7,'Joseph','Heller'),
(8,'Johann Valentin','Andreae'),
(9,'Ubertino','De Casale'),
(10,'Athanasius','Kircher'),
(11,'Milos','Zahradnik'),
(12,'Edsger','Dijkstra'),

insert into x_oddelenie values
(1,'sucasna beletria'),
(2,'vypoctova technika prakticka'),
(3,'vypoctova technika teoreticka'),
(4,'matematika'),
(5,'filozofia vychodna'),
(6,'filozofia zapadna'),
(7,'nabozenstvo krestanske')
(8,'sci-fi a fantasy')

insert into x_kategoria values
(1,'student SS',30),
(2,'student VS',90),
(3,'zamestnanec VS',120),
(4,'zamestnanec kniznice',180),
(5,'root',3600)

insert into x_mesto values
(1,'Kosice','04012'),
(2,'Bratislava','84545'),
(3,'Banska Bystrica','97587'),
(4,'Zilina','01001'),
(5,'Presov','08001'),
(6,'Poprad','05801'),
(7,'Svidnik','08901'),
(8,'Levoca','05401'),
(9,'Trnava','91818'),
(10,'Roznava','04801')

insert into x_kniha values
( 1, 1,'Meno ruze',2000,1,1),                    //Umberto Eco, sucasna beletria, SK
( 2, 1,'Il nome della rosa',1984,1,6),           //Umberto Eco, sucasna beletria, IT
( 3, 1,'Foucaultovo kyvadlo',1991,1,2),          //Umberto Eco, sucasna beletria, CZ
( 4, 2,'Mnoziny a vselico okolo nich',1986,4,1), //Lev Bukovsky, matematika, SK
( 5, 4,'Pan prstenov',2002,8,1),                 //J.R.R., fantasy, SK
( 6, 4,'Herr der Ringen',2001,8,4),              //J.R.R., fantasy, DE
( 7, 5,'Alef',1949,1,8),                         //Jorge Luis Borges, sucasna beletria, ES
( 8, 6,'Tisicrocna vcela',1979,1,1),             //Peter Jaros, sucasna beletria, SK
( 9, 7,'Hlava XXII',2000,1,1),                   //Joseph Heller, sucasna beletria, SK
(10, 8,'Die Chymische Hochzeit des C. Rosenkreutz',1616,4,6), //Johann Valentin Andreae
(11, 9,'Arbor vitae crucifixae Jesu Christi',1485,7,7), //Ubertino de Casale, nabozenstvo, lat.
(12,10,'Mundus Subterranus',1665,7,6),           //Athanasius Kircher, nabozenstvo, lat.
(13,11,'Pestujeme linearni algebru',1999,2,4),   //Zahradnik, matematika, CZ
(14,12,'Go To Considered Harmful',1968,3,3)     //Dijkstra, vyp. tech. teoret., EN

insert into x_citatel values
( 1, 'Ali','Baba','Serail 35',10,2002-04-01,1),                //Roznava, student
( 2, 'Peter','Vojtas','Peter','Jarnikova 1',1,1990-03-25,3),   //Kosice, zamestnanec VS
( 3, 'Lev','Bukovsky,'Temna 5',1,1995-08-16,3),                //Kosice, zamestnanec VS
( 4, 'Pavol','Dubrava','Konvalinkova 7',7,1999-12-24,1),       //Svidnik, student
( 5, 'Emil','Kamzik','Gerlachovska 2655',8,1998-8-8,2),        //Poprad, student VS
( 6, 'Jean','Carrefour','Slotova 15',4,1993-1-1,2),            //Zilina, student VS
( 7, 'Khaled','Al-Himmat','Chwarizmiho 0',8,2002-02-20,3),     //Levoca, zamestnanec VS
( 8, 'Malachi','von Hildesheim','Krizova 1',1,1960-01-01,4),   //Kosice, zamestnanec kniznice
( 9, 'Berengar','de Arundel','Krizova 2',1,1960-08-12,4),      //Kosice, zamestnanec kniznice
(10, 'Jorge','de Burgos','Finis Africae 1',1,1950-01-01,5)    //Kosice, root

insert into x_vyprez values
(1,3,'2001-02-28','v'),
(3,6,'2002-01-05','r'),
(4,10,'2002-04-11','v'),
(5,10,'2000-03-02','v'),
(6,3,'1979-05-05','r'),
(8,6,'2001-12-12','r'),
(9,3,'1998-10-15','v'),
(10,7,'1996-08-15','r'),
(11,9,'2002-03-01','v'),
(12,10,'2002-01-03','v');

insert into x_vrKnihy values
(1, 7),
(1, 4),
(1, 13),
(1, 14),
(3, 11),
(3, 2),
(4, 9),
(5, 5),
(6, 11),
(6, 7),
(8, 8),
(9, 2),
(10, 7),
(11, 1),
(11, 3),
(12, 5),
(12, 6),
(12, 7),
(12, 12);