TEXT   57

insert.txt

Guest on 23rd November 2021 09:55:19 PM

  1. insert into xx_jazyk values
  2. (1,'slovensky'),
  3. (2,'cesky'),
  4. (3,'anglicky'),
  5. (4,'nemecky'),
  6. (5,'francuzsky'),
  7. (6,'taliansky'),
  8. (7,'latinsky'),
  9. (8,'spanielsky');
  10.  
  11. insert into xx_autor values
  12. (1,'Umberto','Eco'),
  13. (2,'Lev','Bukovsky'),
  14. (3,'Jan','Vinar'),
  15. (4,'J.R.R.','Tolkien'),
  16. (5,'Jorge Luis','Borges'),
  17. (6,'Peter','Jaros'),
  18. (7,'Joseph','Heller'),
  19. (8,'Johann Valentin','Andreae'),
  20. (9,'Ubertino','De Casale'),
  21. (10,'Athanasius','Kircher'),
  22. (11,'Milos','Zahradnik'),
  23. (12,'Edsger','Dijkstra');
  24.  
  25. insert into xx_oddelenie values
  26. (1,'sucasna beletria'),
  27. (2,'vypoctova technika prakticka'),
  28. (3,'vypoctova technika teoreticka'),
  29. (4,'matematika'),
  30. (5,'filozofia vychodna'),
  31. (6,'filozofia zapadna'),
  32. (7,'nabozenstvo krestanske'),
  33. (8,'sci-fi a fantasy');
  34.  
  35. insert into xx_kategoria values
  36. (1,'student SS',30),
  37. (2,'student VS',90),
  38. (3,'zamestnanec VS',120),
  39. (4,'zamestnanec kniznice',180),
  40. (5,'root',3600);
  41.  
  42. insert into xx_mesto values
  43. (1,'Kosice','04012'),
  44. (2,'Bratislava','84545'),
  45. (3,'Banska Bystrica','97587'),
  46. (4,'Zilina','01001'),
  47. (5,'Presov','08001'),
  48. (6,'Poprad','05801'),
  49. (7,'Svidnik','08901'),
  50. (8,'Levoca','05401'),
  51. (9,'Trnava','91818'),
  52. (10,'Roznava','04801');
  53.  
  54. insert into xx_kniha values
  55. ( 1, 1,'Meno ruze',2000,1,1),                    //Umberto Eco, sucasna beletria, SK
  56. ( 2, 1,'Il nome della rosa',1984,1,6),           //Umberto Eco, sucasna beletria, IT
  57. ( 3, 1,'Foucaultovo kyvadlo',1991,1,2),          //Umberto Eco, sucasna beletria, CZ
  58. ( 4, 2,'Mnoziny a vselico okolo nich',1986,4,1), //Lev Bukovsky, matematika, SK
  59. ( 5, 4,'Pan prstenov',2002,8,1),                 //J.R.R., fantasy, SK
  60. ( 6, 4,'Herr der Ringen',2001,8,4),              //J.R.R., fantasy, DE
  61. ( 7, 5,'Alef',1949,1,8),                         //Jorge Luis Borges, sucasna beletria, ES
  62. ( 8, 6,'Tisicrocna vcela',1979,1,1),             //Peter Jaros, sucasna beletria, SK
  63. ( 9, 7,'Hlava XXII',2000,1,1),                   //Joseph Heller, sucasna beletria, SK
  64. (10, 8,'Die Chymische Hochzeit des C. Rosenkreutz',1616,4,6), //Johann Valentin Andreae
  65. (11, 9,'Arbor vitae crucifixae Jesu Christi',1485,7,7), //Ubertino de Casale, nabozenstvo, lat.
  66. (12,10,'Mundus Subterranus',1665,7,6),           //Athanasius Kircher, nabozenstvo, lat.
  67. (13,11,'Pestujeme linearni algebru',1999,2,4),   //Zahradnik, matematika, CZ
  68. (14,12,'Go To Considered Harmful',1968,3,3)     //Dijkstra, vyp. tech. teoret., EN
  69.  
  70. insert into xx_citatel values
  71. ( 1, 'Ali','Baba','Serail 35',10,2002-04-01,1),                //Roznava, student
  72. ( 2, 'Peter','Vojtas','Jarnikova 1',1,1990-03-25,3),   //Kosice, zamestnanec VS
  73. ( 3, 'Lev','Bukovsky,'Temna 5',1,1995-08-16,3),                //Kosice, zamestnanec VS
  74. ( 4, 'Pavol','Dubrava','Konvalinkova 7',7,1999-12-24,1),       //Svidnik, student
  75. ( 5, 'Emil','Kamzik','Gerlachovska 2655',8,1998-8-8,2),        //Poprad, student VS
  76. ( 6, 'Jean','Carrefour','Slotova 15',4,1993-1-1,2),            //Zilina, student VS
  77. ( 7, 'Khaled','Al-Himmat','Chwarizmiho 0',8,2002-02-20,3),     //Levoca, zamestnanec VS
  78. ( 8, 'Malachi','von Hildesheim','Krizova 1',1,1960-01-01,4),   //Kosice, zamestnanec kniznice
  79. ( 9, 'Berengar','de Arundel','Krizova 2',1,1960-08-12,4),      //Kosice, zamestnanec kniznice
  80. (10, 'Jorge','de Burgos','Finis Africae 1',1,1950-01-01,5)    //Kosice, root
  81.  
  82. insert into xx_vyprez values
  83. (1,3,'2001-02-28','v'),
  84. (3,6,'2002-01-05','r'),
  85. (4,10,'2002-04-11','v'),
  86. (5,10,'2000-03-02','v'),
  87. (6,3,'1979-05-05','r'),
  88. (8,6,'2001-12-12','r'),
  89. (9,3,'1998-10-15','v'),
  90. (10,7,'1996-08-15','r'),
  91. (11,9,'2002-03-01','v'),
  92. (12,10,'2002-01-03','v');
  93.  
  94. insert into xx_vrKnihy values
  95. (1, 7),
  96. (1, 4),
  97. (1, 13),
  98. (1, 14),
  99. (3, 11),
  100. (3, 2),
  101. (4, 9),
  102. (5, 5),
  103. (6, 11),
  104. (6, 7),
  105. (8, 8),
  106. (9, 2),
  107. (10, 7),
  108. (11, 1),
  109. (11, 3),
  110. (12, 5),
  111. (12, 6),
  112. (12, 7),
  113. (12, 12);

Raw Paste


Login or Register to edit or fork this paste. It's free.