API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 24th, 2015
281
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 19.31 KB | None | 0 0
raw download clone embed print report
  1. --------------------------------------------------------
  2. --  File created - vasárnap-május-24-2015  
  3. --------------------------------------------------------
  4. --------------------------------------------------------
  5. --  DDL for Table AD
  6. --------------------------------------------------------
  7.  
  8.   CREATE TABLE "FARM_USER"."AD" ("ALLAT_ID" NUMBER, "TERMEK_ID" NUMBER, "MENNYIT" NUMBER, "MERTEK" VARCHAR2(20))
  9. --------------------------------------------------------
  10. --  DDL for Table ALKALMAZOTTAK
  11. --------------------------------------------------------
  12.  
  13.   CREATE TABLE "FARM_USER"."ALKALMAZOTTAK" ("ALK_ID" NUMBER, "ALK_NEV" VARCHAR2(50), "ALK_CIM" VARCHAR2(50), "ALK_FIZETES" NUMBER, "FARM_ID" NUMBER)
  14. --------------------------------------------------------
  15. --  DDL for Table ALKALMAZOTTAK1
  16. --------------------------------------------------------
  17.  
  18.   CREATE TABLE "FARM_USER"."ALKALMAZOTTAK1" ("ALK_ID" NUMBER, "ALK_NEV" VARCHAR2(50), "ALK_CIM" VARCHAR2(50), "ALK_FIZETES" NUMBER, "FARM_ID" NUMBER)
  19. --------------------------------------------------------
  20. --  DDL for Table ALLATOK
  21. --------------------------------------------------------
  22.  
  23.   CREATE TABLE "FARM_USER"."ALLATOK" ("ALLAT_ID" NUMBER, "ALLAT_NEV" VARCHAR2(30))
  24. --------------------------------------------------------
  25. --  DDL for Table ELTART
  26. --------------------------------------------------------
  27.  
  28.   CREATE TABLE "FARM_USER"."ELTART" ("FARM_ID" NUMBER, "ALLAT_ID" NUMBER, "DARAB_ALLAT" NUMBER)
  29. --------------------------------------------------------
  30. --  DDL for Table FARM
  31. --------------------------------------------------------
  32.  
  33.   CREATE TABLE "FARM_USER"."FARM" ("FARM_ID" NUMBER, "FARM_NEV" VARCHAR2(30), "FARM_TELSZAM" VARCHAR2(20), "FARM_CIM" VARCHAR2(50))
  34. --------------------------------------------------------
  35. --  DDL for Table MEGVESZ
  36. --------------------------------------------------------
  37.  
  38.   CREATE TABLE "FARM_USER"."MEGVESZ" ("VEVO_ID" NUMBER, "TERMEK_ID" NUMBER, "VEVES" NUMBER, "MERTEK" VARCHAR2(20))
  39. --------------------------------------------------------
  40. --  DDL for Table PENZUGYEK
  41. --------------------------------------------------------
  42.  
  43.   CREATE TABLE "FARM_USER"."PENZUGYEK" ("P_ID" NUMBER, "P_ERTEK" NUMBER, "P_TIPUS" VARCHAR2(30), "FARM_ID" NUMBER)
  44. --------------------------------------------------------
  45. --  DDL for Table TERMEK
  46. --------------------------------------------------------
  47.  
  48.   CREATE TABLE "FARM_USER"."TERMEK" ("TERMEK_ID" NUMBER, "TERMEK_NEV" VARCHAR2(30), "TERMEK_TIPUS" VARCHAR2(30), "TERMEK_AR" NUMBER)
  49. --------------------------------------------------------
  50. --  DDL for Table TULAJDONOSOK
  51. --------------------------------------------------------
  52.  
  53.   CREATE TABLE "FARM_USER"."TULAJDONOSOK" ("TULAJ_ID" NUMBER, "TULAJ_NEV" VARCHAR2(30), "TULAJ_CIM" VARCHAR2(50), "TULAJ_TELSZAM" VARCHAR2(20), "FARM_ID" NUMBER)
  54. --------------------------------------------------------
  55. --  DDL for Table VEVO
  56. --------------------------------------------------------
  57.  
  58.   CREATE TABLE "FARM_USER"."VEVO" ("VEVO_ID" NUMBER, "VEVO_TIPUS" VARCHAR2(30), "VEVO_NEV" VARCHAR2(30))
  59. REM INSERTING INTO FARM_USER.AD
  60. SET DEFINE OFF;
  61. INSERT INTO FARM_USER.AD (ALLAT_ID,TERMEK_ID,MENNYIT,MERTEK) VALUES ('1','6','5','db');
  62. INSERT INTO FARM_USER.AD (ALLAT_ID,TERMEK_ID,MENNYIT,MERTEK) VALUES ('2','3','10','l');
  63. INSERT INTO FARM_USER.AD (ALLAT_ID,TERMEK_ID,MENNYIT,MERTEK) VALUES ('4','4','13','l');
  64. INSERT INTO FARM_USER.AD (ALLAT_ID,TERMEK_ID,MENNYIT,MERTEK) VALUES ('5','1','20','l');
  65. INSERT INTO FARM_USER.AD (ALLAT_ID,TERMEK_ID,MENNYIT,MERTEK) VALUES ('7','7','4','db');
  66. INSERT INTO FARM_USER.AD (ALLAT_ID,TERMEK_ID,MENNYIT,MERTEK) VALUES ('8','8','3','db');
  67. INSERT INTO FARM_USER.AD (ALLAT_ID,TERMEK_ID,MENNYIT,MERTEK) VALUES ('9','9','4','db');
  68. INSERT INTO FARM_USER.AD (ALLAT_ID,TERMEK_ID,MENNYIT,MERTEK) VALUES ('10','2','25','l');
  69. INSERT INTO FARM_USER.AD (ALLAT_ID,TERMEK_ID,MENNYIT,MERTEK) VALUES ('11','10','4','db');
  70. INSERT INTO FARM_USER.AD (ALLAT_ID,TERMEK_ID,MENNYIT,MERTEK) VALUES ('12','11','3','db');
  71. INSERT INTO FARM_USER.AD (ALLAT_ID,TERMEK_ID,MENNYIT,MERTEK) VALUES ('13','12','3','db');
  72. INSERT INTO FARM_USER.AD (ALLAT_ID,TERMEK_ID,MENNYIT,MERTEK) VALUES ('14','5','13','l');
  73. REM INSERTING INTO FARM_USER.ALKALMAZOTTAK
  74. SET DEFINE OFF;
  75. REM INSERTING INTO FARM_USER.ALKALMAZOTTAK1
  76. SET DEFINE OFF;
  77. INSERT INTO FARM_USER.ALKALMAZOTTAK1 (ALK_ID,ALK_NEV,ALK_CIM,ALK_FIZETES,FARM_ID) VALUES ('1','Kerekes Peter','Hu, Szolnok, Orosz-utca, 67','12000','3');
  78. INSERT INTO FARM_USER.ALKALMAZOTTAK1 (ALK_ID,ALK_NEV,ALK_CIM,ALK_FIZETES,FARM_ID) VALUES ('2','Sukosd Marton','Ro, Gyulakuta, Paltos, 20','13000','4');
  79. REM INSERTING INTO FARM_USER.ALLATOK
  80. SET DEFINE OFF;
  81. INSERT INTO FARM_USER.ALLATOK (ALLAT_ID,ALLAT_NEV) VALUES ('1','baromfi');
  82. INSERT INTO FARM_USER.ALLATOK (ALLAT_ID,ALLAT_NEV) VALUES ('2','kecske');
  83. INSERT INTO FARM_USER.ALLATOK (ALLAT_ID,ALLAT_NEV) VALUES ('3','sertes');
  84. INSERT INTO FARM_USER.ALLATOK (ALLAT_ID,ALLAT_NEV) VALUES ('4','juh');
  85. INSERT INTO FARM_USER.ALLATOK (ALLAT_ID,ALLAT_NEV) VALUES ('5','tehen');
  86. INSERT INTO FARM_USER.ALLATOK (ALLAT_ID,ALLAT_NEV) VALUES ('6','meh');
  87. INSERT INTO FARM_USER.ALLATOK (ALLAT_ID,ALLAT_NEV) VALUES ('7','kacsa');
  88. INSERT INTO FARM_USER.ALLATOK (ALLAT_ID,ALLAT_NEV) VALUES ('8','liba');
  89. INSERT INTO FARM_USER.ALLATOK (ALLAT_ID,ALLAT_NEV) VALUES ('9','gyongytyuk');
  90. INSERT INTO FARM_USER.ALLATOK (ALLAT_ID,ALLAT_NEV) VALUES ('10','boleny');
  91. INSERT INTO FARM_USER.ALLATOK (ALLAT_ID,ALLAT_NEV) VALUES ('11','pulyka');
  92. INSERT INTO FARM_USER.ALLATOK (ALLAT_ID,ALLAT_NEV) VALUES ('12','furj');
  93. INSERT INTO FARM_USER.ALLATOK (ALLAT_ID,ALLAT_NEV) VALUES ('13','strucc');
  94. INSERT INTO FARM_USER.ALLATOK (ALLAT_ID,ALLAT_NEV) VALUES ('14','szamar');
  95. INSERT INTO FARM_USER.ALLATOK (ALLAT_ID,ALLAT_NEV) VALUES ('15','nyul');
  96. REM INSERTING INTO FARM_USER.ELTART
  97. SET DEFINE OFF;
  98. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('1','2','150');
  99. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('1','7','140');
  100. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('1','8','150');
  101. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('2','2','100');
  102. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('2','4','100');
  103. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('2','5','150');
  104. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('3','6','500');
  105. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('3','15','150');
  106. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('4','9','180');
  107. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('4','11','100');
  108. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('4','12','180');
  109. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('5','13','500');
  110. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('6','4','200');
  111. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('6','15','300');
  112. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('7','3','400');
  113. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('7','5','400');
  114. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('8','7','150');
  115. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('8','8','160');
  116. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('8','11','100');
  117. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('8','12','180');
  118. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('8','13','200');
  119. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('9','6','600');
  120. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('10','10','300');
  121. INSERT INTO FARM_USER.ELTART (FARM_ID,ALLAT_ID,DARAB_ALLAT) VALUES ('10','14','200');
  122. REM INSERTING INTO FARM_USER.FARM
  123. SET DEFINE OFF;
  124. INSERT INTO FARM_USER.FARM (FARM_ID,FARM_NEV,FARM_TELSZAM,FARM_CIM) VALUES ('1','Strawberry Mountain Meadow','0039100236781','Hu, Szaszhalombatta, Epres-utca, 23/1');
  125. INSERT INTO FARM_USER.FARM (FARM_ID,FARM_NEV,FARM_TELSZAM,FARM_CIM) VALUES ('2','Green River Gardens','0039899087222','Hu, Erd, Tokes-utca, 45');
  126. INSERT INTO FARM_USER.FARM (FARM_ID,FARM_NEV,FARM_TELSZAM,FARM_CIM) VALUES ('3','Moonlight Fields','0039997433922','Hu, Szolnok, Kemeny-utca, 23B');
  127. INSERT INTO FARM_USER.FARM (FARM_ID,FARM_NEV,FARM_TELSZAM,FARM_CIM) VALUES ('4','Gold Mine Pastures','0040333676674','Ro, Torda, Koves-utca, 120/4');
  128. INSERT INTO FARM_USER.FARM (FARM_ID,FARM_NEV,FARM_TELSZAM,FARM_CIM) VALUES ('5','Hollybrook Farmstead','0031557861233','Ne, Breda, Haagport, 20');
  129. INSERT INTO FARM_USER.FARM (FARM_ID,FARM_NEV,FARM_TELSZAM,FARM_CIM) VALUES ('6','Blue Moon Estate','0039212334111','Hu, Tatabanya, Rakoczi-utca, 10');
  130. INSERT INTO FARM_USER.FARM (FARM_ID,FARM_NEV,FARM_TELSZAM,FARM_CIM) VALUES ('7','Meadowland Fields','0031766789589','Ne, Zeewolde, Heuvel, 33');
  131. INSERT INTO FARM_USER.FARM (FARM_ID,FARM_NEV,FARM_TELSZAM,FARM_CIM) VALUES ('8','Big Bear Vineyard','0049000674990','Deu, Leipzig, Gohlis, 100');
  132. INSERT INTO FARM_USER.FARM (FARM_ID,FARM_NEV,FARM_TELSZAM,FARM_CIM) VALUES ('9','Tumbleweed Ranch','0043237334511','Aut, Gras, Lend, 30');
  133. INSERT INTO FARM_USER.FARM (FARM_ID,FARM_NEV,FARM_TELSZAM,FARM_CIM) VALUES ('10','Storm','0033039381110','Fr, Touluse, Av Crampel, 26');
  134. INSERT INTO FARM_USER.FARM (FARM_ID,FARM_NEV,FARM_TELSZAM,FARM_CIM) VALUES ('11','123','22','222');
  135. INSERT INTO FARM_USER.FARM (FARM_ID,FARM_NEV,FARM_TELSZAM,FARM_CIM) VALUES ('12','22','22','22');
  136. REM INSERTING INTO FARM_USER.MEGVESZ
  137. SET DEFINE OFF;
  138. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('1','1','1000','l');
  139. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('1','6','500','db');
  140. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('1','11','300','db');
  141. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('2','1','1000','l');
  142. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('2','3','700','l');
  143. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('2','6','400','db');
  144. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('3','1','1400','l');
  145. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('3','3','1000','l');
  146. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('3','4','900','l');
  147. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('4','1','1200','l');
  148. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('4','2','700','l');
  149. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('4','3','1400','l');
  150. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('5','12','300','kg');
  151. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('6','12','350','db');
  152. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('7','1','1300','l');
  153. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('7','3','1300','l');
  154. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('7','7','200','db');
  155. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('7','8','500','db');
  156. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('7','9','200','db');
  157. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('8','1','1000','l');
  158. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('8','3','1200','l');
  159. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('8','5','600','l');
  160. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('8','6','1300','db');
  161. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('8','7','350','db');
  162. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('8','8','800','db');
  163. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('8','9','300','db');
  164. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('8','10','200','db');
  165. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('11','1','1400','l');
  166. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('11','2','2000','l');
  167. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('11','3','1500','l');
  168. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('11','4','1500','l');
  169. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('12','2','2000','l');
  170. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('12','3','2000','l');
  171. INSERT INTO FARM_USER.MEGVESZ (VEVO_ID,TERMEK_ID,VEVES,MERTEK) VALUES ('12','5','2000','l');
  172. REM INSERTING INTO FARM_USER.PENZUGYEK
  173. SET DEFINE OFF;
  174. INSERT INTO FARM_USER.PENZUGYEK (P_ID,P_ERTEK,P_TIPUS,FARM_ID) VALUES ('1','5000','veszteseg','4');
  175. INSERT INTO FARM_USER.PENZUGYEK (P_ID,P_ERTEK,P_TIPUS,FARM_ID) VALUES ('2','12000','nyeresseg','7');
  176. INSERT INTO FARM_USER.PENZUGYEK (P_ID,P_ERTEK,P_TIPUS,FARM_ID) VALUES ('3','1000','nyeresseg','4');
  177. INSERT INTO FARM_USER.PENZUGYEK (P_ID,P_ERTEK,P_TIPUS,FARM_ID) VALUES ('4','3000','veszteseg','7');
  178. INSERT INTO FARM_USER.PENZUGYEK (P_ID,P_ERTEK,P_TIPUS,FARM_ID) VALUES ('5','20000','veszteseg','10');
  179. INSERT INTO FARM_USER.PENZUGYEK (P_ID,P_ERTEK,P_TIPUS,FARM_ID) VALUES ('6','3000','veszteseg','5');
  180. INSERT INTO FARM_USER.PENZUGYEK (P_ID,P_ERTEK,P_TIPUS,FARM_ID) VALUES ('7','40000','nyeresseg','9');
  181. INSERT INTO FARM_USER.PENZUGYEK (P_ID,P_ERTEK,P_TIPUS,FARM_ID) VALUES ('8','20000','veszteseg','9');
  182. INSERT INTO FARM_USER.PENZUGYEK (P_ID,P_ERTEK,P_TIPUS,FARM_ID) VALUES ('9','6000','nyeresseg','5');
  183. INSERT INTO FARM_USER.PENZUGYEK (P_ID,P_ERTEK,P_TIPUS,FARM_ID) VALUES ('10','10000','nyeresseg','10');
  184. INSERT INTO FARM_USER.PENZUGYEK (P_ID,P_ERTEK,P_TIPUS,FARM_ID) VALUES ('11','20000','nyeresseg','3');
  185. INSERT INTO FARM_USER.PENZUGYEK (P_ID,P_ERTEK,P_TIPUS,FARM_ID) VALUES ('12','25000','veszteseg','3');
  186. INSERT INTO FARM_USER.PENZUGYEK (P_ID,P_ERTEK,P_TIPUS,FARM_ID) VALUES ('13','50000','veszteseg','1');
  187. INSERT INTO FARM_USER.PENZUGYEK (P_ID,P_ERTEK,P_TIPUS,FARM_ID) VALUES ('14','30000','nyeresseg','1');
  188. INSERT INTO FARM_USER.PENZUGYEK (P_ID,P_ERTEK,P_TIPUS,FARM_ID) VALUES ('15','10000','nyeresseg','2');
  189. INSERT INTO FARM_USER.PENZUGYEK (P_ID,P_ERTEK,P_TIPUS,FARM_ID) VALUES ('16','15000','veszteseg','2');
  190. INSERT INTO FARM_USER.PENZUGYEK (P_ID,P_ERTEK,P_TIPUS,FARM_ID) VALUES ('17','50000','veszteseg','6');
  191. INSERT INTO FARM_USER.PENZUGYEK (P_ID,P_ERTEK,P_TIPUS,FARM_ID) VALUES ('18','75000','nyeresseg','6');
  192. INSERT INTO FARM_USER.PENZUGYEK (P_ID,P_ERTEK,P_TIPUS,FARM_ID) VALUES ('19','30000','veszteseg','8');
  193. INSERT INTO FARM_USER.PENZUGYEK (P_ID,P_ERTEK,P_TIPUS,FARM_ID) VALUES ('20','80000','nyeresseg','8');
  194. REM INSERTING INTO FARM_USER.TERMEK
  195. SET DEFINE OFF;
  196. INSERT INTO FARM_USER.TERMEK (TERMEK_ID,TERMEK_NEV,TERMEK_TIPUS,TERMEK_AR) VALUES ('1','tehen-tej','tej','10');
  197. INSERT INTO FARM_USER.TERMEK (TERMEK_ID,TERMEK_NEV,TERMEK_TIPUS,TERMEK_AR) VALUES ('2','boleny-tej','tej','15');
  198. INSERT INTO FARM_USER.TERMEK (TERMEK_ID,TERMEK_NEV,TERMEK_TIPUS,TERMEK_AR) VALUES ('3','kecske-tej','tej','12');
  199. INSERT INTO FARM_USER.TERMEK (TERMEK_ID,TERMEK_NEV,TERMEK_TIPUS,TERMEK_AR) VALUES ('4','juh-tej','tej','11');
  200. INSERT INTO FARM_USER.TERMEK (TERMEK_ID,TERMEK_NEV,TERMEK_TIPUS,TERMEK_AR) VALUES ('5','szamar-tej','tej','18');
  201. INSERT INTO FARM_USER.TERMEK (TERMEK_ID,TERMEK_NEV,TERMEK_TIPUS,TERMEK_AR) VALUES ('6','baromfi-tojas','tojas','4,5');
  202. INSERT INTO FARM_USER.TERMEK (TERMEK_ID,TERMEK_NEV,TERMEK_TIPUS,TERMEK_AR) VALUES ('7','kacsa-tojas','tojas','6');
  203. INSERT INTO FARM_USER.TERMEK (TERMEK_ID,TERMEK_NEV,TERMEK_TIPUS,TERMEK_AR) VALUES ('8','liba-tojas','tojas','7,5');
  204. INSERT INTO FARM_USER.TERMEK (TERMEK_ID,TERMEK_NEV,TERMEK_TIPUS,TERMEK_AR) VALUES ('9','gyongytyuk-tojas','tojas','10,5');
  205. INSERT INTO FARM_USER.TERMEK (TERMEK_ID,TERMEK_NEV,TERMEK_TIPUS,TERMEK_AR) VALUES ('10','pulyka-tojas','tojas','9');
  206. INSERT INTO FARM_USER.TERMEK (TERMEK_ID,TERMEK_NEV,TERMEK_TIPUS,TERMEK_AR) VALUES ('11','furj-tojas','tojas','13,5');
  207. INSERT INTO FARM_USER.TERMEK (TERMEK_ID,TERMEK_NEV,TERMEK_TIPUS,TERMEK_AR) VALUES ('12','strucc-tojas','tojas','12');
  208. REM INSERTING INTO FARM_USER.TULAJDONOSOK
  209. SET DEFINE OFF;
  210. INSERT INTO FARM_USER.TULAJDONOSOK (TULAJ_ID,TULAJ_NEV,TULAJ_CIM,TULAJ_TELSZAM,FARM_ID) VALUES ('1','Bocskai Csaba','Hu, Szolnok, Orosz-utca, 4','0039997435522','1');
  211. INSERT INTO FARM_USER.TULAJDONOSOK (TULAJ_ID,TULAJ_NEV,TULAJ_CIM,TULAJ_TELSZAM,FARM_ID) VALUES ('2','Erdesz Gergo','Ro, Cavnic, Eresz-utca, 23','0040333674574','3');
  212. INSERT INTO FARM_USER.TULAJDONOSOK (TULAJ_ID,TULAJ_NEV,TULAJ_CIM,TULAJ_TELSZAM,FARM_ID) VALUES ('3','Martin Schrauss','Deu, Lepipzig, Mours, 80','0031766789500','8');
  213. INSERT INTO FARM_USER.TULAJDONOSOK (TULAJ_ID,TULAJ_NEV,TULAJ_CIM,TULAJ_TELSZAM,FARM_ID) VALUES ('4','Erik van der Woodsen','Ne, Almere, Nick, 5','0031766789589','7');
  214. INSERT INTO FARM_USER.TULAJDONOSOK (TULAJ_ID,TULAJ_NEV,TULAJ_CIM,TULAJ_TELSZAM,FARM_ID) VALUES ('5','Kemeny Sandor','Hu, Erd, Karoly-utca, 89','0039899087222','6');
  215. INSERT INTO FARM_USER.TULAJDONOSOK (TULAJ_ID,TULAJ_NEV,TULAJ_CIM,TULAJ_TELSZAM,FARM_ID) VALUES ('6','Kiraly Elod','Hu, Szolnok, Kerekes, 80/A','0039944433922','4');
  216. INSERT INTO FARM_USER.TULAJDONOSOK (TULAJ_ID,TULAJ_NEV,TULAJ_CIM,TULAJ_TELSZAM,FARM_ID) VALUES ('7','Fohasz Gyula','Ro, Gyulakuta, Juhasz-utca, 30','0040333676600','2');
  217. INSERT INTO FARM_USER.TULAJDONOSOK (TULAJ_ID,TULAJ_NEV,TULAJ_CIM,TULAJ_TELSZAM,FARM_ID) VALUES ('8','Kelemen Elek','Ro, Mangalia, Paratlan-utca, 21/C','0040333676600','10');
  218. INSERT INTO FARM_USER.TULAJDONOSOK (TULAJ_ID,TULAJ_NEV,TULAJ_CIM,TULAJ_TELSZAM,FARM_ID) VALUES ('9','Steven Logan','Fr, Toolmas, Lapos, 10','0033039381340','10');
  219. INSERT INTO FARM_USER.TULAJDONOSOK (TULAJ_ID,TULAJ_NEV,TULAJ_CIM,TULAJ_TELSZAM,FARM_ID) VALUES ('10','Stephen Kourte','Aut, Gras, Pantos, 20','00432373345201','9');
  220. INSERT INTO FARM_USER.TULAJDONOSOK (TULAJ_ID,TULAJ_NEV,TULAJ_CIM,TULAJ_TELSZAM,FARM_ID) VALUES ('11','Pilaf Kant','Ne, Breda, Haagport, 50/A','0031557863330','5');
  221. INSERT INTO FARM_USER.TULAJDONOSOK (TULAJ_ID,TULAJ_NEV,TULAJ_CIM,TULAJ_TELSZAM,FARM_ID) VALUES ('12','Telepes Akos','Hu, Jeges, Koves-utca,44','0039100236991','8');
  222. REM INSERTING INTO FARM_USER.VEVO
  223. SET DEFINE OFF;
  224. INSERT INTO FARM_USER.VEVO (VEVO_ID,VEVO_TIPUS,VEVO_NEV) VALUES ('1','aruhaz','Darina');
  225. INSERT INTO FARM_USER.VEVO (VEVO_ID,VEVO_TIPUS,VEVO_NEV) VALUES ('2','aruhaz','Auchan');
  226. INSERT INTO FARM_USER.VEVO (VEVO_ID,VEVO_TIPUS,VEVO_NEV) VALUES ('3','ceg','Sanlacta');
  227. INSERT INTO FARM_USER.VEVO (VEVO_ID,VEVO_TIPUS,VEVO_NEV) VALUES ('4','ceg','Danone');
  228. INSERT INTO FARM_USER.VEVO (VEVO_ID,VEVO_TIPUS,VEVO_NEV) VALUES ('5','ceg','Caroli');
  229. INSERT INTO FARM_USER.VEVO (VEVO_ID,VEVO_TIPUS,VEVO_NEV) VALUES ('6','ceg','Fox');
  230. INSERT INTO FARM_USER.VEVO (VEVO_ID,VEVO_TIPUS,VEVO_NEV) VALUES ('7','aruhaz','Kaufland');
  231. INSERT INTO FARM_USER.VEVO (VEVO_ID,VEVO_TIPUS,VEVO_NEV) VALUES ('8','aruhaz','Lidl');
  232. INSERT INTO FARM_USER.VEVO (VEVO_ID,VEVO_TIPUS,VEVO_NEV) VALUES ('9','ceg','Tordai');
  233. INSERT INTO FARM_USER.VEVO (VEVO_ID,VEVO_TIPUS,VEVO_NEV) VALUES ('10','ceg-aruhaz','Kenvelo');
  234. INSERT INTO FARM_USER.VEVO (VEVO_ID,VEVO_TIPUS,VEVO_NEV) VALUES ('11','ceg','Pilos');
  235. INSERT INTO FARM_USER.VEVO (VEVO_ID,VEVO_TIPUS,VEVO_NEV) VALUES ('12','ceg','Delaco');
  236. INSERT INTO FARM_USER.VEVO (VEVO_ID,VEVO_TIPUS,VEVO_NEV) VALUES ('13','ceg-aruhaz','H es M');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!