API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 21st, 2017
580
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.62 KB | None | 0 0
raw download clone embed print report
  1. INSERT INTO USER(EMAIL, PASSWORD, ROLE, NAME, SURNAME) VALUES ('kantagara@gmail.com', 'nikola123', 'ADMIN', 'Nikola', 'Garabandic');
  2. INSERT INTO USER(EMAIL, PASSWORD, ROLE, NAME, SURNAME) VALUES ('sysman', 'asdf', 'SYSTEM_MANAGER', 'sys ', 'manager');
  3. INSERT INTO USER(EMAIL, PASSWORD, ROLE, NAME, SURNAME) VALUES ('guest@gmail.com', 'asdf', 'GUEST', 'guest', 'guest');
  4.  
  5. INSERT INTO USER(EMAIL, PASSWORD,ROLE, NAME, SURNAME) VALUES ('vosmi@gmail.com', 'vosmi', 'GUEST','vosmi', 'vosmic');
  6. INSERT INTO USER(EMAIL, PASSWORD, ROLE, NAME, SURNAME) VALUES ('djokica@gmail.com', 'djokica', 'GUEST','djokica', 'djokica');
  7. INSERT INTO USER(EMAIL, PASSWORD,ROLE, NAME, SURNAME) VALUES ('patrik@gmail.com', 'patrik','GUEST', 'patrik', 'patrik');
  8. INSERT INTO USER(EMAIL, PASSWORD, ROLE, NAME, SURNAME) VALUES ('jugoslav@gmail.com', 'jugoslav', 'GUEST','jugoslav', 'jugoslav');
  9.  
  10. INSERT INTO RESTAURANT(NAME, DESCRIPTION, CITY, STREET, STREET_NUMBER) VALUES ('Rest1', '...', 'Novi Sad', 'Bulevar Oslobodjenja', '111a');
  11. INSERT INTO RESTAURANT(NAME, DESCRIPTION, CITY, STREET, STREET_NUMBER) VALUES ('Rest2', '...', 'Beograd', 'Bulevar Oslobodjenja', '111a');
  12.  
  13. INSERT INTO Area(RESTAURANT_ID, NAME) VALUES ('2', 'WHOLE RESTAURANT');
  14. INSERT INTO Area(RESTAURANT_ID, NAME) VALUES ('1', 'Smoking');
  15. INSERT INTO Area(RESTAURANT_ID, NAME) VALUES ('1', 'Non-smoking');
  16.  
  17. INSERT INTO SHIFT(RESTAURANT_ID, START_HOUR, END_HOUR) VALUES (1, '08:00:00', '16:00:00');
  18. INSERT INTO SHIFT(RESTAURANT_ID, START_HOUR, END_HOUR) VALUES (1, '16:00:00', '23:00:00');
  19.  
  20. INSERT INTO MENU(NAME, RESTAURANT_ID) VALUES ('Menu', '1');
  21. INSERT INTO DRINKCARD(NAME, RESTAURANT_ID) VALUES ('Drink Card', '1');
  22.  
  23. INSERT INTO MENU(NAME, RESTAURANT_ID) VALUES ('Menu', '2');
  24. INSERT INTO DRINKCARD(NAME, RESTAURANT_ID) VALUES ('Drink Card', '2');
  25.  
  26. INSERT Into MENU_ITEM(NAME, PRICE, DESCRIPTION, MENU_ID) VALUES ('pljeska', 235, 'ljuta', '1');
  27. INSERT Into DRINK_ITEM(NAME, PRICE, DESCRIPTION, DRINK_CARD_ID) VALUES ('Vino', 235, 'crno', '1');
  28. INSERT Into MENU_ITEM(NAME, PRICE, DESCRIPTION, MENU_ID) VALUES ('Karadjordjeva', 400.0, '-', '1');
  29. INSERT Into DRINK_ITEM(NAME, PRICE, DESCRIPTION, DRINK_CARD_ID) VALUES ('Vino', 235, 'belo', '1');
  30. INSERT Into MENU_ITEM(NAME, PRICE, DESCRIPTION, MENU_ID) VALUES ('Spagete', 560.0, 'bolonjeze', '1');
  31. INSERT Into DRINK_ITEM(NAME, PRICE, DESCRIPTION, DRINK_CARD_ID) VALUES ('Sprite', 120, '-', '1');
  32.  
  33.  
  34. INSERT Into MENU_ITEM(NAME, PRICE, DESCRIPTION, MENU_ID) VALUES ('palacinke', 235, 'slane', '2');
  35. INSERT Into DRINK_ITEM(NAME, PRICE, DESCRIPTION, DRINK_CARD_ID) VALUES ('Cola', 235, 'light', '2');
  36. INSERT Into MENU_ITEM(NAME, PRICE, DESCRIPTION, MENU_ID) VALUES ('palacinke', 400.0, 'slatke', '2');
  37. INSERT Into DRINK_ITEM(NAME, PRICE, DESCRIPTION, DRINK_CARD_ID) VALUES ('Somersby', 210, 'apple', '2');
  38. INSERT Into MENU_ITEM(NAME, PRICE, DESCRIPTION, MENU_ID) VALUES ('Spagete', 560.0, '', '2');
  39. INSERT Into DRINK_ITEM(NAME, PRICE, DESCRIPTION, DRINK_CARD_ID) VALUES ('Somersby', 210, 'pear', '2');
  40.  
  41.  
  42. INSERT INTO USER(EMAIL, PASSWORD, ROLE, NAME, SURNAME) VALUES ('restman', 'asdf', 'RESTAURANT_MANAGER', 'rest', 'man');
  43. INSERT INTO RESTAURANT_MANAGER(ID, RESTAURANT_ID) VALUES ('8','1');
  44.  
  45. INSERT INTO USER(EMAIL, PASSWORD, ROLE, NAME, SURNAME) VALUES ('restman2', 'asdf', 'RESTAURANT_MANAGER', 'rest', 'man');
  46. INSERT INTO RESTAURANT_MANAGER(ID, RESTAURANT_ID) VALUES ('9','2');
  47.  
  48. INSERT INTO USER(EMAIL, PASSWORD, ROLE, NAME, SURNAME) VALUES ('employee1', 'asdf', 'WAITER', 'veljo', 'man');
  49. INSERT INTO USER(EMAIL, PASSWORD, ROLE, NAME, SURNAME) VALUES ('employee2', 'asdf', 'CHEF', 'pero', 'man');
  50. INSERT INTO EMPLOYEE(ID, RESTAURANT_ID, CONFECTION_NUMBER, SHOE_NUMBER, PASSWORD_CHANGED) VALUES ('10', '2', 'XS', '36', FALSE );
  51. INSERT INTO EMPLOYEE(ID, RESTAURANT_ID, CONFECTION_NUMBER, SHOE_NUMBER, PASSWORD_CHANGED) VALUES ('11', '1', 'XL', '45', FALSE);
  52.  
  53. INSERT INTO USER(EMAIL, PASSWORD, ROLE, NAME, SURNAME) VALUES ('employee3', 'asdf', 'BARTENDER', 'krco', 'man');
  54. INSERT INTO USER(EMAIL, PASSWORD, ROLE, NAME, SURNAME) VALUES ('employee4', 'asdf', 'CHEF', 'raspo', 'man');
  55. INSERT INTO EMPLOYEE(ID, RESTAURANT_ID, CONFECTION_NUMBER, SHOE_NUMBER, PASSWORD_CHANGED) VALUES ('12', '1','XS', '36', TRUE );
  56. INSERT INTO EMPLOYEE(ID, RESTAURANT_ID, CONFECTION_NUMBER, SHOE_NUMBER, PASSWORD_CHANGED) VALUES ('13', '2', 'M', '44', FALSE);
  57.  
  58. INSERT INTO USER(EMAIL, PASSWORD, ROLE, NAME, SURNAME) VALUES ('employee5', 'asdf', 'BARTENDER', 'dila', 'man');
  59. INSERT INTO USER(EMAIL, PASSWORD, ROLE, NAME, SURNAME) VALUES ('employee6', 'asdf', 'WAITER', 'smrad', 'man');
  60. INSERT INTO EMPLOYEE(ID, RESTAURANT_ID, CONFECTION_NUMBER, SHOE_NUMBER, PASSWORD_CHANGED) VALUES ('14', '1', 'L', '40', FALSE);
  61. INSERT INTO EMPLOYEE(ID, RESTAURANT_ID, CONFECTION_NUMBER, SHOE_NUMBER, PASSWORD_CHANGED) VALUES ('15', '1', 'S', '36', TRUE);
  62.  
  63.  
  64. INSERT INTO FRIENDSHIP(FRIEND1,FRIEND2,CONFIRMED,SENDER) VALUES (5,6,true,5);
  65. INSERT INTO FRIENDSHIP(FRIEND1,FRIEND2,CONFIRMED,SENDER) VALUES (5,7,true,5);
  66. INSERT INTO FRIENDSHIP(FRIEND1,FRIEND2,CONFIRMED,SENDER) VALUES (5,4,true,5);
  67. INSERT INTO FRIENDSHIP(FRIEND1,FRIEND2,CONFIRMED,SENDER) VALUES (6,7,true,6);
  68. INSERT INTO FRIENDSHIP(FRIEND1,FRIEND2,CONFIRMED,SENDER) VALUES (6,4,true,6);
  69. INSERT INTO FRIENDSHIP(FRIEND1,FRIEND2,CONFIRMED,SENDER) VALUES (7,4,true,7);
  70.  
  71. INSERT INTO EMPLOYEE_SHIFT(START_DATE, END_DATE, SHIFT_ID, EMPLOYEE_ID, AREA_ID) VALUES ('2017-05-18', '2017-05-25', 1, 11, null);
  72. INSERT INTO EMPLOYEE_SHIFT(START_DATE, END_DATE, SHIFT_ID, EMPLOYEE_ID, AREA_ID) VALUES ('2017-05-20', '2017-06-29', 2, 15, 1);
  73. INSERT INTO EMPLOYEE_SHIFT(START_DATE, END_DATE, SHIFT_ID, EMPLOYEE_ID, AREA_ID) VALUES ('2017-05-20', '2017-05-29', 2, 12, null);
  74.  
  75. INSERT INTO USER(EMAIL, PASSWORD, ROLE, NAME, SURNAME) VALUES ('bidder1', 'asdf', 'BIDDER', 'bidder', 'man');
  76. INSERT INTO BIDDER(ID, PASSWORD_CHANGED)VALUES (16, TRUE );
  77. INSERT INTO RESTAURANT_BIDDER(RESTAURANT_ID, BIDDER_ID) VALUES (1, 16);
  78.  
  79. INSERT INTO USER(EMAIL, PASSWORD, ROLE, NAME, SURNAME) VALUES ('bidder2', 'asdf', 'BIDDER', 'bidder', 'man');
  80. INSERT INTO BIDDER(ID, PASSWORD_CHANGED)VALUES (17, TRUE );
  81. INSERT INTO RESTAURANT_BIDDER(RESTAURANT_ID, BIDDER_ID) VALUES (1, 17);
  82.  
  83. INSERT INTO USER(EMAIL, PASSWORD, ROLE, NAME, SURNAME) VALUES ('bidder3', 'asdf', 'BIDDER', 'bidder', 'man');
  84. INSERT INTO BIDDER(ID, PASSWORD_CHANGED)VALUES (18, TRUE );
  85. INSERT INTO RESTAURANT_BIDDER(RESTAURANT_ID, BIDDER_ID) VALUES (1, 18);
  86.  
  87. INSERT INTO USER(EMAIL, PASSWORD, ROLE, NAME, SURNAME) VALUES ('employee nov', 'asdf', 'WAITER', 'novi', 'man');
  88. INSERT INTO EMPLOYEE(ID, RESTAURANT_ID, CONFECTION_NUMBER, SHOE_NUMBER, PASSWORD_CHANGED) VALUES ('19', '1', 'L', '40', FALSE);
  89.  
  90.  
  91. INSERT INTO SUPPLIES(START_DATE, END_DATE, RESTAURANT_ID, NEEDED, ACCEPTED_OFFER) VALUES ('2017-05-11', '2017-06-30', 1, 'Slanna i jaja', false);
  92. INSERT INTO SUPPLIES(START_DATE, END_DATE, RESTAURANT_ID, NEEDED, ACCEPTED_OFFER) VALUES ('2017-05-11', '2017-06-25', 1, 'Crno vino 10l\n Belo vino 10l', false);
  93.  
  94. INSERT INTO BID(BIDDER_ID, SUPPLIES_ID, PRICE, GUARANTEE,DELIVERY_DEADLINE,CHOSEN) VALUES (16, 1,200,'da', '2017-07-11', null);
  95. INSERT INTO BID(BIDDER_ID, SUPPLIES_ID, PRICE, GUARANTEE,DELIVERY_DEADLINE,CHOSEN) VALUES (17, 1,500,'da', '2017-07-01', null);
  96. INSERT INTO BID(BIDDER_ID, SUPPLIES_ID, PRICE, GUARANTEE,DELIVERY_DEADLINE,CHOSEN) VALUES (18, 1,900,'da', '2017-06-30', null);
  97.  
  98. INSERT INTO RESTAURANT_TABLE(NUMBER, POSITIONX, POSITIONY, SEATS, AREA) VALUES (815, 193,286,1,2);
  99. INSERT INTO RESTAURANT_TABLE(NUMBER, POSITIONX, POSITIONY, SEATS, AREA) VALUES (228, 291,283,2,2);
  100. INSERT INTO RESTAURANT_TABLE(NUMBER, POSITIONX, POSITIONY, SEATS, AREA) VALUES (877, 376,176,14, 2);
  101. INSERT INTO RESTAURANT_TABLE(NUMBER, POSITIONX, POSITIONY, SEATS, AREA) VALUES (42, 291,175,4,2);
  102. INSERT INTO RESTAURANT_TABLE(NUMBER, POSITIONX, POSITIONY, SEATS, AREA) VALUES (9, 192,173,4,2);
  103. INSERT INTO RESTAURANT_TABLE(NUMBER, POSITIONX, POSITIONY, SEATS, AREA) VALUES (76, 376,176,14, 1);
  104.  
  105. INSERT INTO RESERVATION(RESTAURANTID, RESTAURANTNAME, USERID, TABLEID, DATE, TIME, LENGTH) VALUES (1, 'Rest1', 5, '1,2,3','2017-12-12',10,2);
  106. INSERT INTO RESERVATION(RESTAURANTID, RESTAURANTNAME, USERID, TABLEID, DATE, TIME, LENGTH) VALUES (1, 'Rest1', 5, '1,2,3','2017-10-12',10,2);
  107. INSERT INTO RESERVATION(RESTAURANTID, RESTAURANTNAME, USERID, TABLEID, DATE, TIME, LENGTH) VALUES (1, 'Rest1', 6, '1,2,3','2017-11-12',10,2);
  108. INSERT INTO RESERVATION(RESTAURANTID, RESTAURANTNAME, USERID, TABLEID, DATE, TIME, LENGTH) VALUES (1, 'Rest1', 6, '1,2,3','2017-05-12',10,2);
  109. INSERT INTO RESERVATION(RESTAURANTID, RESTAURANTNAME, USERID, TABLEID, DATE, TIME, LENGTH) VALUES (1, 'Rest1', 5, '1,2,3','2017-06-12',10,2);
  110. INSERT INTO RESERVATION(RESTAURANTID, RESTAURANTNAME, USERID, TABLEID, DATE, TIME, LENGTH) VALUES (1, 'Rest1', 6, '1,2,3','2018-04-12',10,2);
  111.  
  112. INSERT INTO INVITATION(USERID, FRIENDID, RESERVATIONID, CONFIRMED, FRIENDEMAIL, USEREMAIL) VALUES (5,6,1,TRUE, 'patrik@gmail.com' ,'djokica@gmail.com');
  113. INSERT INTO INVITATION(USERID, FRIENDID, RESERVATIONID, CONFIRMED, FRIENDEMAIL, USEREMAIL) VALUES (5,7,1,FALSE, 'jugoslav@gmail.com','djokica@gmail.com');
  114. INSERT INTO INVITATION(USERID, FRIENDID, RESERVATIONID, CONFIRMED, FRIENDEMAIL, USEREMAIL) VALUES (5,7,2,TRUE, 'jugoslav@gmail.com','djokica@gmail.com');
  115. INSERT INTO INVITATION(USERID, FRIENDID, RESERVATIONID, CONFIRMED, FRIENDEMAIL, USEREMAIL) VALUES (6,5,3,FALSE, 'djokica@gmail.com','patrik@gmail.com');
  116. INSERT INTO INVITATION(USERID, FRIENDID, RESERVATIONID, CONFIRMED, FRIENDEMAIL, USEREMAIL) VALUES (6,5,4,FALSE, 'djokica@gmail.com','patrik@gmail.com');
  117. INSERT INTO INVITATION(USERID, FRIENDID, RESERVATIONID, CONFIRMED, FRIENDEMAIL, USEREMAIL) VALUES (6,5,6,FALSE,'djokica@gmail.com','patrik@gmail.com');
  118. INSERT INTO INVITATION(USERID, FRIENDID, RESERVATIONID, CONFIRMED, FRIENDEMAIL, USEREMAIL) VALUES (6,7,6,FALSE,'jugoslav@gmail.com','patrik@gmail.com');
  119.  
  120.  
  121. INSERT INTO RESERVATION(DATE, LENGTH, RESTAURANTID, RESTAURANTNAME, TABLEID, TIME, USERID) VALUES
  122. (PARSEDATETIME('2017-06-22', 'yyyy-mm-dd'), 3, 1,'Rest1', 5, 11, 3);
  123. INSERT INTO RATE(RATE_FOOD, RATE_OVERALL, RATE_WAITER, RATED, RESERVATION_ID) VALUES (3, 3, 3, TRUE, 1);
  124. INSERT INTO EMPLOYEE_RATES(EMPLOYEE_ID, RATES) VALUES (19, 3);
  125. INSERT INTO RESTAURANT_RATES(RESTAURANT_ID, RATES) VALUES(1, 3);
  126.  
  127. INSERT INTO RESERVATION(DATE, LENGTH, RESTAURANTID, RESTAURANTNAME, TABLEID, TIME, USERID) VALUES
  128. (PARSEDATETIME('2017-05-22', 'yyyy-mm-dd'), 3, 1,'Rest1', 4, 11, 4);
  129. INSERT INTO RATE(RATE_FOOD, RATE_OVERALL, RATE_WAITER, RATED, RESERVATION_ID) VALUES (3, 1, 5, TRUE, 2);
  130. INSERT INTO EMPLOYEE_RATES(EMPLOYEE_ID, RATES) VALUES (19, 5);
  131. INSERT INTO RESTAURANT_RATES(RESTAURANT_ID, RATES) VALUES(1, 2);
  132.  
  133.  
  134. INSERT INTO RESERVATION(DATE, LENGTH, RESTAURANTID, RESTAURANTNAME, TABLEID, TIME, USERID) VALUES
  135. (PARSEDATETIME('2017-05-28', 'yyyy-mm-dd'), 3, 1,'Rest1', 5, 11, 3);
  136. INSERT INTO RATE(RATE_FOOD, RATE_OVERALL, RATE_WAITER, RATED, RESERVATION_ID) VALUES (3, 5, 1, TRUE, 3);
  137. INSERT INTO EMPLOYEE_RATES(EMPLOYEE_ID, RATES) VALUES (15, 1);
  138. INSERT INTO RESTAURANT_RATES(RESTAURANT_ID, RATES) VALUES(1, 5);
  139.  
  140. INSERT INTO RESERVATION(DATE, LENGTH, RESTAURANTID, RESTAURANTNAME, TABLEID, TIME, USERID) VALUES
  141. (PARSEDATETIME('2017-06-04', 'yyyy-mm-dd'), 3, 1,'Rest1', 4, 11, 4);
  142. INSERT INTO RATE(RATE_FOOD, RATE_OVERALL, RATE_WAITER, RATED, RESERVATION_ID) VALUES (3, 4, 3, TRUE, 4);
  143. INSERT INTO EMPLOYEE_RATES(EMPLOYEE_ID, RATES) VALUES (15, 3);
  144. INSERT INTO RESTAURANT_RATES(RESTAURANT_ID, RATES) VALUES(1, 4);
  145.  
  146.  
  147.  
  148.  
  149. INSERT INTO ORDERS(DATE_CREATED, FINISHED, PRICE, VERSION, RESERVATION_ID, RESTAURANT_ID, USER_ID)
  150. VALUES (PARSEDATETIME('2017-06-21', 'yyyy-mm-dd'), FALSE, 1175, 0, NULL , 1, 15);
  151.  
  152. INSERT INTO ORDER_ITEM(DESCRIPTION, NAME, ORDERSTATUS, ORDERTYPE, PRICE, VERSION, BILL_ID, RESTAURANT_ID, USER_ID)
  153. VALUES ('crno', 'Vino', 'RESERVED', 'DRINK', 235, 0, 1, 1, 15);
  154. INSERT INTO ORDER_ITEM(DESCRIPTION, NAME, ORDERSTATUS, ORDERTYPE, PRICE, VERSION, BILL_ID, RESTAURANT_ID, USER_ID)
  155. VALUES ('crno', 'Vino', 'RESERVED', 'DRINK', 235, 0, 1, 1, 15);
  156. INSERT INTO ORDER_ITEM(DESCRIPTION, NAME, ORDERSTATUS, ORDERTYPE, PRICE, VERSION, BILL_ID, RESTAURANT_ID, USER_ID)
  157. VALUES ('crno', 'Vino', 'RESERVED', 'DRINK', 235, 0, 1, 1, 15);
  158. INSERT INTO ORDER_ITEM(DESCRIPTION, NAME, ORDERSTATUS, ORDERTYPE, PRICE, VERSION, BILL_ID, RESTAURANT_ID, USER_ID)
  159. VALUES ('crno', 'Vino', 'RESERVED', 'DRINK', 235, 0, 1, 1, 15);
  160. INSERT INTO ORDER_ITEM(DESCRIPTION, NAME, ORDERSTATUS, ORDERTYPE, PRICE, VERSION, BILL_ID, RESTAURANT_ID, USER_ID)
  161. VALUES ('crno', 'Vino', 'RESERVED', 'DRINK', 235, 0, 1, 1, 15);
  162.  
  163.  
  164.  
  165. INSERT INTO ORDERS(DATE_CREATED, FINISHED, PRICE, VERSION, RESERVATION_ID, RESTAURANT_ID, USER_ID)
  166. VALUES (PARSEDATETIME('2017-06-20', 'yyyy-mm-dd'), FALSE, 1560, 0, NULL , 1, 15);
  167.  
  168. INSERT INTO ORDER_ITEM(DESCRIPTION, NAME, ORDERSTATUS, ORDERTYPE, PRICE, VERSION, BILL_ID, RESTAURANT_ID, USER_ID)
  169. VALUES ('crno', 'Vino', 'RESERVED', 'DRINK', 320, 0, 2, 1, 15);
  170. INSERT INTO ORDER_ITEM(DESCRIPTION, NAME, ORDERSTATUS, ORDERTYPE, PRICE, VERSION, BILL_ID, RESTAURANT_ID, USER_ID)
  171. VALUES ('crno', 'Vino', 'RESERVED', 'DRINK', 211, 0, 2, 1, 15);
  172. INSERT INTO ORDER_ITEM(DESCRIPTION, NAME, ORDERSTATUS, ORDERTYPE, PRICE, VERSION, BILL_ID, RESTAURANT_ID, USER_ID)
  173. VALUES ('crno', 'Vino', 'RESERVED', 'DRINK', 450, 0, 2, 1, 15);
  174. INSERT INTO ORDER_ITEM(DESCRIPTION, NAME, ORDERSTATUS, ORDERTYPE, PRICE, VERSION, BILL_ID, RESTAURANT_ID, USER_ID)
  175. VALUES ('crno', 'Vino', 'RESERVED', 'DRINK', 390, 0, 2, 1, 15);
  176. INSERT INTO ORDER_ITEM(DESCRIPTION, NAME, ORDERSTATUS, ORDERTYPE, PRICE, VERSION, BILL_ID, RESTAURANT_ID, USER_ID)
  177. VALUES ('crno', 'Vino', 'RESERVED', 'DRINK', 189, 0, 2, 1, 15);
  178.  
  179.  
  180.  
  181. INSERT INTO ORDERS(DATE_CREATED, FINISHED, PRICE, VERSION, RESERVATION_ID, RESTAURANT_ID, USER_ID)
  182. VALUES (PARSEDATETIME('2017-06-10', 'yyyy-mm-dd'), FALSE, 1560, 0, NULL , 1, 15);
  183.  
  184. INSERT INTO ORDER_ITEM(DESCRIPTION, NAME, ORDERSTATUS, ORDERTYPE, PRICE, VERSION, BILL_ID, RESTAURANT_ID, USER_ID)
  185. VALUES ('crno', 'Vino', 'RESERVED', 'DRINK', 320, 0, 3, 1, 15);
  186. INSERT INTO ORDER_ITEM(DESCRIPTION, NAME, ORDERSTATUS, ORDERTYPE, PRICE, VERSION, BILL_ID, RESTAURANT_ID, USER_ID)
  187. VALUES ('crno', 'Vino', 'RESERVED', 'DRINK', 211, 0, 3, 1, 15);
  188. INSERT INTO ORDER_ITEM(DESCRIPTION, NAME, ORDERSTATUS, ORDERTYPE, PRICE, VERSION, BILL_ID, RESTAURANT_ID, USER_ID)
  189. VALUES ('crno', 'Vino', 'RESERVED', 'DRINK', 450, 0, 3, 1, 15);
  190. INSERT INTO ORDER_ITEM(DESCRIPTION, NAME, ORDERSTATUS, ORDERTYPE, PRICE, VERSION, BILL_ID, RESTAURANT_ID, USER_ID)
  191. VALUES ('crno', 'Vino', 'RESERVED', 'DRINK', 390, 0, 3, 1, 15);
  192. INSERT INTO ORDER_ITEM(DESCRIPTION, NAME, ORDERSTATUS, ORDERTYPE, PRICE, VERSION, BILL_ID, RESTAURANT_ID, USER_ID)
  193. VALUES ('crno', 'Vino', 'RESERVED', 'DRINK', 189, 0, 3, 1, 15);
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!