API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 21st, 2017
108
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 31.43 KB | None | 0 0
raw download clone embed print report
  1. CREATE USER IF NOT EXISTS SA SALT '3351e62c43ea5103' HASH '97e2a278d72469faa1d45234d4bddd747c3e03c53f1fbfd88b2f58da16ab75c7' ADMIN;
  2. CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_4FBC5CE9_4D9E_41DB_B096_21114380D898 START WITH 3 BELONGS_TO_TABLE;
  3. CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_7D68399A_B846_49FD_B686_10296742F666 START WITH 4 BELONGS_TO_TABLE;
  4. CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_628F8895_F6D1_4D53_BD36_4C3A8C777CE0 START WITH 7 BELONGS_TO_TABLE;
  5. CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_29C471E1_09DC_4BDD_BA27_ECBF2D7F9EAE START WITH 70 BELONGS_TO_TABLE;
  6. CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_78374564_06E2_4DB9_980D_B832D3518B43 START WITH 3 BELONGS_TO_TABLE;
  7. CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_C0595938_F63E_4F6B_B6F4_B43942A981FE START WITH 3 BELONGS_TO_TABLE;
  8. CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_7D2197AA_6327_4CE5_915B_3B618EB35B6C START WITH 17 BELONGS_TO_TABLE;
  9. CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_997FEDF7_384E_4AE8_B1FA_CC69BC9A6B69 START WITH 20 BELONGS_TO_TABLE;
  10. CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_1860FF04_E4C9_4D1A_A065_90C3C6A3E181 START WITH 9 BELONGS_TO_TABLE;
  11. CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_6B1DB9FD_7063_4786_8BA1_F8F87761FB7B START WITH 4 BELONGS_TO_TABLE;
  12. CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_3C6F3CD3_C1EF_4669_9056_95DBAFA87604 START WITH 7 BELONGS_TO_TABLE;
  13. CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_11992B67_D6F3_45EA_B8FD_84712786FD0D START WITH 11 BELONGS_TO_TABLE;
  14. CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_81F7C73B_1A05_4B36_B22B_FE7423EA6DFA START WITH 15 BELONGS_TO_TABLE;
  15. CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_32F6767E_CF87_4A25_A79D_132B01FF1A71 START WITH 3 BELONGS_TO_TABLE;
  16. CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_A780D494_60A0_4F96_BFD9_B1F4D1F809AC START WITH 4 BELONGS_TO_TABLE;
  17. CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_93FD0408_F21D_4807_B9B7_68893A4F7802 START WITH 7 BELONGS_TO_TABLE;
  18. CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_B0E67CE1_867D_4F41_B050_42F0D3C5B259 START WITH 7 BELONGS_TO_TABLE;
  19. CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_672FB7F9_48F2_4674_B5E2_CD8FA975D5C3 START WITH 3 BELONGS_TO_TABLE;
  20. CREATE MEMORY TABLE PUBLIC.AREA(
  21. AREA_ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_7D68399A_B846_49FD_B686_10296742F666) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_7D68399A_B846_49FD_B686_10296742F666,
  22. NAME VARCHAR(255),
  23. RESTAURANT_ID BIGINT NOT NULL
  24. );
  25. ALTER TABLE PUBLIC.AREA ADD CONSTRAINT PUBLIC.CONSTRAINT_1 PRIMARY KEY(AREA_ID);
  26. -- 3 +/- SELECT COUNT(*) FROM PUBLIC.AREA;
  27. INSERT INTO PUBLIC.AREA(AREA_ID, NAME, RESTAURANT_ID) VALUES
  28. (1, 'WHOLE RESTAURANT', 2),
  29. (2, 'Smoking', 1),
  30. (3, 'Non-smoking', 1);
  31. CREATE MEMORY TABLE PUBLIC.BID(
  32. BID_ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_6B1DB9FD_7063_4786_8BA1_F8F87761FB7B) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_6B1DB9FD_7063_4786_8BA1_F8F87761FB7B,
  33. CHOSEN VARCHAR(255),
  34. DELIVERY_DEADLINE TIMESTAMP,
  35. GUARANTEE VARCHAR(255),
  36. PRICE DOUBLE NOT NULL,
  37. VERSION INTEGER DEFAULT 0 NOT NULL,
  38. BIDDER_ID BIGINT NOT NULL,
  39. SUPPLIES_ID BIGINT NOT NULL
  40. );
  41. ALTER TABLE PUBLIC.BID ADD CONSTRAINT PUBLIC.CONSTRAINT_10 PRIMARY KEY(BID_ID);
  42. -- 3 +/- SELECT COUNT(*) FROM PUBLIC.BID;
  43. INSERT INTO PUBLIC.BID(BID_ID, CHOSEN, DELIVERY_DEADLINE, GUARANTEE, PRICE, VERSION, BIDDER_ID, SUPPLIES_ID) VALUES
  44. (1, NULL, TIMESTAMP '2017-07-11 00:00:00.0', 'da', 200.0, 0, 16, 1),
  45. (2, NULL, TIMESTAMP '2017-07-01 00:00:00.0', 'da', 500.0, 0, 17, 1),
  46. (3, NULL, TIMESTAMP '2017-06-30 00:00:00.0', 'da', 900.0, 0, 18, 1);
  47. CREATE MEMORY TABLE PUBLIC.BIDDER(
  48. PASSWORD_CHANGED BOOLEAN NOT NULL,
  49. ID BIGINT NOT NULL
  50. );
  51. ALTER TABLE PUBLIC.BIDDER ADD CONSTRAINT PUBLIC.CONSTRAINT_7 PRIMARY KEY(ID);
  52. -- 3 +/- SELECT COUNT(*) FROM PUBLIC.BIDDER;
  53. INSERT INTO PUBLIC.BIDDER(PASSWORD_CHANGED, ID) VALUES
  54. (TRUE, 16),
  55. (TRUE, 17),
  56. (TRUE, 18);
  57. CREATE MEMORY TABLE PUBLIC.DRINK_ITEM(
  58. ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_628F8895_F6D1_4D53_BD36_4C3A8C777CE0) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_628F8895_F6D1_4D53_BD36_4C3A8C777CE0,
  59. DESCRIPTION VARCHAR(255),
  60. NAME VARCHAR(255),
  61. PRICE DOUBLE NOT NULL,
  62. DRINK_CARD_ID BIGINT NOT NULL,
  63. FINALORDER_ID BIGINT
  64. );
  65. ALTER TABLE PUBLIC.DRINK_ITEM ADD CONSTRAINT PUBLIC.CONSTRAINT_A PRIMARY KEY(ID);
  66. -- 6 +/- SELECT COUNT(*) FROM PUBLIC.DRINK_ITEM;
  67. INSERT INTO PUBLIC.DRINK_ITEM(ID, DESCRIPTION, NAME, PRICE, DRINK_CARD_ID, FINALORDER_ID) VALUES
  68. (1, 'crno', 'Vino', 235.0, 1, NULL),
  69. (2, 'belo', 'Vino', 235.0, 1, NULL),
  70. (3, '-', 'Sprite', 120.0, 1, NULL),
  71. (4, 'light', 'Cola', 235.0, 2, NULL),
  72. (5, 'apple', 'Somersby', 210.0, 2, NULL),
  73. (6, 'pear', 'Somersby', 210.0, 2, NULL);
  74. CREATE MEMORY TABLE PUBLIC.DRINKCARD(
  75. DRINK_CARD_ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_672FB7F9_48F2_4674_B5E2_CD8FA975D5C3) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_672FB7F9_48F2_4674_B5E2_CD8FA975D5C3,
  76. NAME VARCHAR(255),
  77. RESTAURANT_ID BIGINT NOT NULL
  78. );
  79. ALTER TABLE PUBLIC.DRINKCARD ADD CONSTRAINT PUBLIC.CONSTRAINT_4 PRIMARY KEY(DRINK_CARD_ID);
  80. -- 2 +/- SELECT COUNT(*) FROM PUBLIC.DRINKCARD;
  81. INSERT INTO PUBLIC.DRINKCARD(DRINK_CARD_ID, NAME, RESTAURANT_ID) VALUES
  82. (1, 'Drink Card', 1),
  83. (2, 'Drink Card', 2);
  84. CREATE MEMORY TABLE PUBLIC.DRINKITEM_RATES(
  85. DRINKITEM_ID BIGINT NOT NULL,
  86. RATES DOUBLE
  87. );
  88. -- 3 +/- SELECT COUNT(*) FROM PUBLIC.DRINKITEM_RATES;
  89. INSERT INTO PUBLIC.DRINKITEM_RATES(DRINKITEM_ID, RATES) VALUES
  90. (1, 5.0),
  91. (2, 5.0),
  92. (3, 5.0);
  93. CREATE MEMORY TABLE PUBLIC.EMPLOYEE(
  94. BIRTH_DATE TIMESTAMP,
  95. CONFECTION_NUMBER VARCHAR(255) NOT NULL,
  96. PASSWORD_CHANGED BOOLEAN NOT NULL,
  97. SHOE_NUMBER VARCHAR(255) NOT NULL,
  98. ID BIGINT NOT NULL,
  99. RESTAURANT_ID BIGINT
  100. );
  101. ALTER TABLE PUBLIC.EMPLOYEE ADD CONSTRAINT PUBLIC.CONSTRAINT_75 PRIMARY KEY(ID);
  102. -- 7 +/- SELECT COUNT(*) FROM PUBLIC.EMPLOYEE;
  103. INSERT INTO PUBLIC.EMPLOYEE(BIRTH_DATE, CONFECTION_NUMBER, PASSWORD_CHANGED, SHOE_NUMBER, ID, RESTAURANT_ID) VALUES
  104. (NULL, 'XS', FALSE, '36', 10, 2),
  105. (NULL, 'XL', FALSE, '45', 11, 1),
  106. (NULL, 'XS', TRUE, '36', 12, 1),
  107. (NULL, 'M', FALSE, '44', 13, 2),
  108. (NULL, 'L', FALSE, '40', 14, 1),
  109. (NULL, 'S', TRUE, '36', 15, 1),
  110. (NULL, 'L', FALSE, '40', 19, 1);
  111. CREATE MEMORY TABLE PUBLIC.EMPLOYEE_RATES(
  112. EMPLOYEE_ID BIGINT NOT NULL,
  113. RATES DOUBLE
  114. );
  115. -- 4 +/- SELECT COUNT(*) FROM PUBLIC.EMPLOYEE_RATES;
  116. INSERT INTO PUBLIC.EMPLOYEE_RATES(EMPLOYEE_ID, RATES) VALUES
  117. (19, 3.0),
  118. (19, 5.0),
  119. (15, 1.0),
  120. (15, 3.0);
  121. CREATE MEMORY TABLE PUBLIC.EMPLOYEE_SHIFT(
  122. EMPLOYEE_SHIFT_ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_A780D494_60A0_4F96_BFD9_B1F4D1F809AC) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_A780D494_60A0_4F96_BFD9_B1F4D1F809AC,
  123. END_DATE TIMESTAMP,
  124. START_DATE TIMESTAMP,
  125. AREA_ID BIGINT,
  126. EMPLOYEE_ID BIGINT,
  127. SHIFT_ID BIGINT
  128. );
  129. ALTER TABLE PUBLIC.EMPLOYEE_SHIFT ADD CONSTRAINT PUBLIC.CONSTRAINT_109 PRIMARY KEY(EMPLOYEE_SHIFT_ID);
  130. -- 3 +/- SELECT COUNT(*) FROM PUBLIC.EMPLOYEE_SHIFT;
  131. INSERT INTO PUBLIC.EMPLOYEE_SHIFT(EMPLOYEE_SHIFT_ID, END_DATE, START_DATE, AREA_ID, EMPLOYEE_ID, SHIFT_ID) VALUES
  132. (1, TIMESTAMP '2017-05-25 00:00:00.0', TIMESTAMP '2017-05-18 00:00:00.0', NULL, 11, 1),
  133. (2, TIMESTAMP '2017-06-29 00:00:00.0', TIMESTAMP '2017-05-20 00:00:00.0', 1, 15, 2),
  134. (3, TIMESTAMP '2017-05-29 00:00:00.0', TIMESTAMP '2017-05-20 00:00:00.0', NULL, 12, 2);
  135. CREATE MEMORY TABLE PUBLIC.FRIENDSHIP(
  136. ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_93FD0408_F21D_4807_B9B7_68893A4F7802) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_93FD0408_F21D_4807_B9B7_68893A4F7802,
  137. CONFIRMED BOOLEAN,
  138. FRIEND1 BIGINT NOT NULL,
  139. FRIEND2 BIGINT NOT NULL,
  140. SENDER BIGINT
  141. );
  142. ALTER TABLE PUBLIC.FRIENDSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_B PRIMARY KEY(ID);
  143. -- 6 +/- SELECT COUNT(*) FROM PUBLIC.FRIENDSHIP;
  144. INSERT INTO PUBLIC.FRIENDSHIP(ID, CONFIRMED, FRIEND1, FRIEND2, SENDER) VALUES
  145. (1, TRUE, 5, 6, 5),
  146. (2, TRUE, 5, 7, 5),
  147. (3, TRUE, 5, 4, 5),
  148. (4, TRUE, 6, 7, 6),
  149. (5, TRUE, 6, 4, 6),
  150. (6, TRUE, 7, 4, 7);
  151. CREATE MEMORY TABLE PUBLIC.GUEST(
  152. ID BIGINT NOT NULL
  153. );
  154. ALTER TABLE PUBLIC.GUEST ADD CONSTRAINT PUBLIC.CONSTRAINT_41 PRIMARY KEY(ID);
  155. -- 0 +/- SELECT COUNT(*) FROM PUBLIC.GUEST;
  156. CREATE MEMORY TABLE PUBLIC.INVITATION(
  157. ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_7D2197AA_6327_4CE5_915B_3B618EB35B6C) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_7D2197AA_6327_4CE5_915B_3B618EB35B6C,
  158. CONFIRMED BOOLEAN,
  159. FRIENDEMAIL VARCHAR(255) NOT NULL,
  160. FRIENDID BIGINT NOT NULL,
  161. RESERVATIONID BIGINT NOT NULL,
  162. USERID BIGINT NOT NULL
  163. );
  164. ALTER TABLE PUBLIC.INVITATION ADD CONSTRAINT PUBLIC.CONSTRAINT_6 PRIMARY KEY(ID);
  165. -- 16 +/- SELECT COUNT(*) FROM PUBLIC.INVITATION;
  166. INSERT INTO PUBLIC.INVITATION(ID, CONFIRMED, FRIENDEMAIL, FRIENDID, RESERVATIONID, USERID) VALUES
  167. (1, TRUE, 'patrik@gmail.com', 6, 1, 5),
  168. (2, FALSE, 'jugoslav@gmail.com', 7, 1, 5),
  169. (3, TRUE, 'jugoslav@gmail.com', 7, 2, 5),
  170. (4, FALSE, 'djokica@gmail.com', 5, 3, 6),
  171. (5, FALSE, 'djokica@gmail.com', 5, 4, 6),
  172. (6, TRUE, 'patrik@gmail.com', 6, 6, 5),
  173. (7, FALSE, 'patrik@gmail.com', 6, 6, 5),
  174. (8, FALSE, 'djokica@gmail.com', 5, 11, 4),
  175. (9, FALSE, 'patrik@gmail.com', 6, 11, 4),
  176. (10, FALSE, 'jugoslav@gmail.com', 7, 12, 6),
  177. (11, FALSE, 'djokica@gmail.com', 5, 12, 6),
  178. (12, TRUE, 'vosmi@gmail.com', 4, 12, 6),
  179. (13, TRUE, 'djokica@gmail.com', 5, 13, 6),
  180. (14, TRUE, 'jugoslav@gmail.com', 7, 13, 6),
  181. (15, TRUE, 'vosmi@gmail.com', 4, 13, 6),
  182. (16, TRUE, 'djokica@gmail.com', 5, 14, 6);
  183. CREATE MEMORY TABLE PUBLIC.MENU(
  184. MENU_ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_78374564_06E2_4DB9_980D_B832D3518B43) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_78374564_06E2_4DB9_980D_B832D3518B43,
  185. NAME VARCHAR(255),
  186. RESTAURANT_ID BIGINT NOT NULL
  187. );
  188. ALTER TABLE PUBLIC.MENU ADD CONSTRAINT PUBLIC.CONSTRAINT_2 PRIMARY KEY(MENU_ID);
  189. -- 2 +/- SELECT COUNT(*) FROM PUBLIC.MENU;
  190. INSERT INTO PUBLIC.MENU(MENU_ID, NAME, RESTAURANT_ID) VALUES
  191. (1, 'Menu', 1),
  192. (2, 'Menu', 2);
  193. CREATE MEMORY TABLE PUBLIC.MENU_ITEM(
  194. ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_B0E67CE1_867D_4F41_B050_42F0D3C5B259) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_B0E67CE1_867D_4F41_B050_42F0D3C5B259,
  195. DESCRIPTION VARCHAR(255),
  196. NAME VARCHAR(255),
  197. PRICE DOUBLE NOT NULL,
  198. FINALORDER_ID BIGINT,
  199. MENU_ID BIGINT NOT NULL
  200. );
  201. ALTER TABLE PUBLIC.MENU_ITEM ADD CONSTRAINT PUBLIC.CONSTRAINT_4C PRIMARY KEY(ID);
  202. -- 6 +/- SELECT COUNT(*) FROM PUBLIC.MENU_ITEM;
  203. INSERT INTO PUBLIC.MENU_ITEM(ID, DESCRIPTION, NAME, PRICE, FINALORDER_ID, MENU_ID) VALUES
  204. (1, 'ljuta', 'pljeska', 235.0, NULL, 1),
  205. (2, '-', 'Karadjordjeva', 400.0, NULL, 1),
  206. (3, 'bolonjeze', 'Spagete', 560.0, NULL, 1),
  207. (4, 'slane', 'palacinke', 235.0, NULL, 2),
  208. (5, 'slatke', 'palacinke', 400.0, NULL, 2),
  209. (6, '', 'Spagete', 560.0, NULL, 2);
  210. CREATE MEMORY TABLE PUBLIC.MENUITEM_RATES(
  211. MENUITEM_ID BIGINT NOT NULL,
  212. RATES DOUBLE
  213. );
  214. -- 3 +/- SELECT COUNT(*) FROM PUBLIC.MENUITEM_RATES;
  215. INSERT INTO PUBLIC.MENUITEM_RATES(MENUITEM_ID, RATES) VALUES
  216. (1, 5.0),
  217. (2, 5.0),
  218. (3, 5.0);
  219. CREATE MEMORY TABLE PUBLIC.ORDER_ITEM(
  220. ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_29C471E1_09DC_4BDD_BA27_ECBF2D7F9EAE) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_29C471E1_09DC_4BDD_BA27_ECBF2D7F9EAE,
  221. DESCRIPTION VARCHAR(255),
  222. NAME VARCHAR(255) NOT NULL,
  223. ORDERSTATUS VARCHAR(255),
  224. ORDERTYPE VARCHAR(255) NOT NULL,
  225. PRICE DOUBLE NOT NULL,
  226. VERSION INTEGER DEFAULT 0 NOT NULL,
  227. BILL_ID BIGINT NOT NULL,
  228. RESTAURANT_ID BIGINT NOT NULL,
  229. USER_ID BIGINT NOT NULL
  230. );
  231. ALTER TABLE PUBLIC.ORDER_ITEM ADD CONSTRAINT PUBLIC.CONSTRAINT_4B PRIMARY KEY(ID);
  232. -- 69 +/- SELECT COUNT(*) FROM PUBLIC.ORDER_ITEM;
  233. INSERT INTO PUBLIC.ORDER_ITEM(ID, DESCRIPTION, NAME, ORDERSTATUS, ORDERTYPE, PRICE, VERSION, BILL_ID, RESTAURANT_ID, USER_ID) VALUES
  234. (1, 'crno', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 1, 1, 15),
  235. (2, 'crno', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 1, 1, 15),
  236. (3, 'crno', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 1, 1, 15),
  237. (4, 'crno', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 1, 1, 15),
  238. (5, 'crno', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 1, 1, 15),
  239. (6, 'crno', 'Vino', 'RESERVED', 'DRINK', 320.0, 0, 2, 1, 15),
  240. (7, 'crno', 'Vino', 'RESERVED', 'DRINK', 211.0, 0, 2, 1, 15),
  241. (8, 'crno', 'Vino', 'RESERVED', 'DRINK', 450.0, 0, 2, 1, 15),
  242. (9, 'crno', 'Vino', 'RESERVED', 'DRINK', 390.0, 0, 2, 1, 15),
  243. (10, 'crno', 'Vino', 'RESERVED', 'DRINK', 189.0, 0, 2, 1, 15),
  244. (11, 'crno', 'Vino', 'RESERVED', 'DRINK', 320.0, 0, 3, 1, 15),
  245. (12, 'crno', 'Vino', 'RESERVED', 'DRINK', 211.0, 0, 3, 1, 15),
  246. (13, 'crno', 'Vino', 'RESERVED', 'DRINK', 450.0, 0, 3, 1, 15),
  247. (14, 'crno', 'Vino', 'RESERVED', 'DRINK', 390.0, 0, 3, 1, 15),
  248. (15, 'crno', 'Vino', 'RESERVED', 'DRINK', 189.0, 0, 3, 1, 15),
  249. (16, 'crno', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 4, 1, 4),
  250. (17, 'belo', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 4, 1, 4),
  251. (18, '-', 'Sprite', 'RESERVED', 'DRINK', 120.0, 0, 4, 1, 4),
  252. (19, 'ljuta', 'pljeska', 'RESERVED', 'FOOD', 235.0, 0, 4, 1, 4),
  253. (20, '-', 'Karadjordjeva', 'RESERVED', 'FOOD', 400.0, 0, 4, 1, 4),
  254. (21, 'bolonjeze', 'Spagete', 'RESERVED', 'FOOD', 560.0, 0, 4, 1, 4),
  255. (22, 'crno', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 5, 1, 6),
  256. (23, 'belo', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 5, 1, 6),
  257. (24, '-', 'Sprite', 'RESERVED', 'DRINK', 120.0, 0, 5, 1, 6),
  258. (25, 'ljuta', 'pljeska', 'RESERVED', 'FOOD', 235.0, 0, 5, 1, 6),
  259. (26, '-', 'Karadjordjeva', 'RESERVED', 'FOOD', 400.0, 0, 5, 1, 6),
  260. (27, 'bolonjeze', 'Spagete', 'RESERVED', 'FOOD', 560.0, 0, 5, 1, 6),
  261. (28, 'crno', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 6, 1, 6),
  262. (29, 'crno', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 6, 1, 6),
  263. (30, 'belo', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 6, 1, 6),
  264. (31, 'belo', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 6, 1, 6),
  265. (32, '-', 'Sprite', 'RESERVED', 'DRINK', 120.0, 0, 6, 1, 6),
  266. (33, '-', 'Sprite', 'RESERVED', 'DRINK', 120.0, 0, 6, 1, 6),
  267. (34, 'ljuta', 'pljeska', 'RESERVED', 'FOOD', 235.0, 0, 6, 1, 6),
  268. (35, '-', 'Karadjordjeva', 'RESERVED', 'FOOD', 400.0, 0, 6, 1, 6),
  269. (36, '-', 'Karadjordjeva', 'RESERVED', 'FOOD', 400.0, 0, 6, 1, 6),
  270. (37, 'bolonjeze', 'Spagete', 'RESERVED', 'FOOD', 560.0, 0, 6, 1, 6),
  271. (38, 'bolonjeze', 'Spagete', 'RESERVED', 'FOOD', 560.0, 0, 6, 1, 6),
  272. (39, 'bolonjeze', 'Spagete', 'RESERVED', 'FOOD', 560.0, 0, 6, 1, 6),
  273. (40, 'crno', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 7, 1, 6),
  274. (41, 'belo', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 7, 1, 6),
  275. (42, '-', 'Sprite', 'RESERVED', 'DRINK', 120.0, 0, 7, 1, 6),
  276. (43, 'ljuta', 'pljeska', 'RESERVED', 'FOOD', 235.0, 0, 7, 1, 6),
  277. (44, 'ljuta', 'pljeska', 'RESERVED', 'FOOD', 235.0, 0, 7, 1, 6),
  278. (45, '-', 'Karadjordjeva', 'RESERVED', 'FOOD', 400.0, 0, 7, 1, 6),
  279. (46, 'bolonjeze', 'Spagete', 'RESERVED', 'FOOD', 560.0, 0, 7, 1, 6),
  280. (47, 'crno', 'Vino', 'UNFINISHED', 'DRINK', 235.0, 0, 8, 1, 15),
  281. (48, '-', 'Sprite', 'UNFINISHED', 'DRINK', 120.0, 0, 8, 1, 15),
  282. (49, 'belo', 'Vino', 'UNFINISHED', 'DRINK', 235.0, 0, 8, 1, 15),
  283. (50, 'crno', 'Vino', 'UNFINISHED', 'DRINK', 235.0, 0, 8, 1, 15),
  284. (51, 'bolonjeze', 'Spagete', 'UNFINISHED', 'FOOD', 560.0, 0, 8, 1, 15),
  285. (52, '-', 'Karadjordjeva', 'UNFINISHED', 'FOOD', 400.0, 0, 8, 1, 15),
  286. (53, 'ljuta', 'pljeska', 'UNFINISHED', 'FOOD', 235.0, 0, 8, 1, 15),
  287. (54, 'bolonjeze', 'Spagete', 'UNFINISHED', 'FOOD', 560.0, 0, 9, 1, 15),
  288. (55, 'ljuta', 'pljeska', 'UNFINISHED', 'FOOD', 235.0, 0, 9, 1, 15),
  289. (56, '-', 'Karadjordjeva', 'UNFINISHED', 'FOOD', 400.0, 0, 9, 1, 15),
  290. (57, '-', 'Sprite', 'UNFINISHED', 'DRINK', 120.0, 0, 9, 1, 15),
  291. (58, 'belo', 'Vino', 'UNFINISHED', 'DRINK', 235.0, 0, 9, 1, 15),
  292. (59, 'crno', 'Vino', 'UNFINISHED', 'DRINK', 235.0, 0, 9, 1, 15),
  293. (60, 'bolonjeze', 'Spagete', 'UNFINISHED', 'FOOD', 560.0, 0, 9, 1, 15),
  294. (61, '-', 'Karadjordjeva', 'UNFINISHED', 'FOOD', 400.0, 0, 9, 1, 15),
  295. (62, 'ljuta', 'pljeska', 'UNFINISHED', 'FOOD', 235.0, 0, 9, 1, 15);
  296. INSERT INTO PUBLIC.ORDER_ITEM(ID, DESCRIPTION, NAME, ORDERSTATUS, ORDERTYPE, PRICE, VERSION, BILL_ID, RESTAURANT_ID, USER_ID) VALUES
  297. (63, '-', 'Sprite', 'UNFINISHED', 'DRINK', 120.0, 0, 9, 1, 15),
  298. (64, '-', 'Sprite', 'UNFINISHED', 'DRINK', 120.0, 0, 10, 1, 15),
  299. (65, 'crno', 'Vino', 'UNFINISHED', 'DRINK', 235.0, 0, 10, 1, 15),
  300. (66, 'belo', 'Vino', 'UNFINISHED', 'DRINK', 235.0, 0, 10, 1, 15),
  301. (67, 'bolonjeze', 'Spagete', 'UNFINISHED', 'FOOD', 560.0, 0, 10, 1, 15),
  302. (68, '-', 'Karadjordjeva', 'UNFINISHED', 'FOOD', 400.0, 0, 10, 1, 15),
  303. (69, 'ljuta', 'pljeska', 'UNFINISHED', 'FOOD', 235.0, 0, 10, 1, 15);
  304. CREATE MEMORY TABLE PUBLIC.ORDERS(
  305. ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_11992B67_D6F3_45EA_B8FD_84712786FD0D) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_11992B67_D6F3_45EA_B8FD_84712786FD0D,
  306. DATE_CREATED TIMESTAMP,
  307. FINISHED BOOLEAN,
  308. PRICE DOUBLE,
  309. VERSION INTEGER DEFAULT 0 NOT NULL,
  310. RESERVATION_ID BIGINT,
  311. RESTAURANT_ID BIGINT NOT NULL,
  312. USER_ID BIGINT NOT NULL
  313. );
  314. ALTER TABLE PUBLIC.ORDERS ADD CONSTRAINT PUBLIC.CONSTRAINT_8 PRIMARY KEY(ID);
  315. -- 10 +/- SELECT COUNT(*) FROM PUBLIC.ORDERS;
  316. INSERT INTO PUBLIC.ORDERS(ID, DATE_CREATED, FINISHED, PRICE, VERSION, RESERVATION_ID, RESTAURANT_ID, USER_ID) VALUES
  317. (1, TIMESTAMP '2017-01-21 00:06:00.0', FALSE, 1175.0, 0, NULL, 1, 15),
  318. (2, TIMESTAMP '2017-01-20 00:06:00.0', FALSE, 1560.0, 0, NULL, 1, 15),
  319. (3, TIMESTAMP '2017-01-10 00:06:00.0', FALSE, 1560.0, 0, NULL, 1, 15),
  320. (4, TIMESTAMP '2017-06-22 11:00:00.0', FALSE, 1785.0, 0, 11, 1, 4),
  321. (5, TIMESTAMP '2017-05-22 11:30:00.0', FALSE, 1785.0, 0, 12, 1, 6),
  322. (6, TIMESTAMP '2017-06-23 11:30:00.0', FALSE, 3895.0, 0, 13, 1, 6),
  323. (7, TIMESTAMP '2017-04-30 11:30:00.0', FALSE, 2020.0, 0, 14, 1, 6),
  324. (8, TIMESTAMP '2017-03-21 00:00:00.0', FALSE, 2020.0, 0, NULL, 1, 15),
  325. (9, TIMESTAMP '2017-04-21 00:00:00.0', FALSE, 3100.0, 0, NULL, 1, 15),
  326. (10, TIMESTAMP '2017-06-21 00:00:00.0', FALSE, 1785.0, 0, NULL, 1, 15);
  327. CREATE MEMORY TABLE PUBLIC.RATE(
  328. RATE_ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_1860FF04_E4C9_4D1A_A065_90C3C6A3E181) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_1860FF04_E4C9_4D1A_A065_90C3C6A3E181,
  329. RATE_FOOD DOUBLE,
  330. RATE_OVERALL DOUBLE,
  331. RATE_WAITER DOUBLE,
  332. RESERVATION_ID BIGINT
  333. );
  334. ALTER TABLE PUBLIC.RATE ADD CONSTRAINT PUBLIC.CONSTRAINT_26 PRIMARY KEY(RATE_ID);
  335. -- 8 +/- SELECT COUNT(*) FROM PUBLIC.RATE;
  336. INSERT INTO PUBLIC.RATE(RATE_ID, RATE_FOOD, RATE_OVERALL, RATE_WAITER, RESERVATION_ID) VALUES
  337. (1, 3.0, 3.0, 3.0, 1),
  338. (2, 3.0, 1.0, 5.0, 2),
  339. (3, 3.0, 5.0, 1.0, 3),
  340. (4, 3.0, 4.0, 3.0, 4),
  341. (5, 5.0, 5.0, 5.0, 11),
  342. (6, 0.0, 0.0, 0.0, 12),
  343. (7, 0.0, 0.0, 0.0, 13),
  344. (8, 0.0, 0.0, 0.0, 14);
  345. CREATE MEMORY TABLE PUBLIC.RATE_INVITEDNOTRATED(
  346. RATE_RATE_ID BIGINT NOT NULL,
  347. INVITEDNOTRATED BIGINT
  348. );
  349. -- 3 +/- SELECT COUNT(*) FROM PUBLIC.RATE_INVITEDNOTRATED;
  350. INSERT INTO PUBLIC.RATE_INVITEDNOTRATED(RATE_RATE_ID, INVITEDNOTRATED) VALUES
  351. (6, 6),
  352. (7, 6),
  353. (8, 6);
  354. CREATE MEMORY TABLE PUBLIC.RESERVATION(
  355. ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_81F7C73B_1A05_4B36_B22B_FE7423EA6DFA) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_81F7C73B_1A05_4B36_B22B_FE7423EA6DFA,
  356. DATE TIMESTAMP NOT NULL,
  357. LENGTH INTEGER NOT NULL,
  358. RESTAURANTID BIGINT NOT NULL,
  359. RESTAURANTNAME VARCHAR(255) NOT NULL,
  360. TABLEID VARCHAR(255) NOT NULL,
  361. TIME INTEGER NOT NULL,
  362. USERID BIGINT NOT NULL
  363. );
  364. ALTER TABLE PUBLIC.RESERVATION ADD CONSTRAINT PUBLIC.CONSTRAINT_23 PRIMARY KEY(ID);
  365. -- 14 +/- SELECT COUNT(*) FROM PUBLIC.RESERVATION;
  366. INSERT INTO PUBLIC.RESERVATION(ID, DATE, LENGTH, RESTAURANTID, RESTAURANTNAME, TABLEID, TIME, USERID) VALUES
  367. (1, TIMESTAMP '2017-12-12 00:00:00.0', 2, 1, 'Rest1', '1,2,3', 10, 5),
  368. (2, TIMESTAMP '2017-10-12 00:00:00.0', 2, 1, 'Rest1', '1,2,3', 10, 5),
  369. (3, TIMESTAMP '2017-11-12 00:00:00.0', 2, 1, 'Rest1', '1,2,3', 10, 6),
  370. (4, TIMESTAMP '2017-05-12 00:00:00.0', 2, 1, 'Rest1', '1,2,3', 10, 6),
  371. (5, TIMESTAMP '2017-06-12 00:00:00.0', 2, 1, 'Rest1', '1,2,3', 10, 5),
  372. (6, TIMESTAMP '2017-04-12 00:00:00.0', 2, 1, 'Rest1', '1,2,3', 10, 6),
  373. (7, TIMESTAMP '2017-01-22 00:06:00.0', 3, 1, 'Rest1', '5', 11, 3),
  374. (8, TIMESTAMP '2017-05-22 00:05:00.0', 3, 1, 'Rest1', '4', 11, 4),
  375. (9, TIMESTAMP '2017-06-28 00:05:00.0', 3, 1, 'Rest1', '5', 11, 3),
  376. (10, TIMESTAMP '2017-03-04 00:06:00.0', 3, 1, 'Rest1', '4', 11, 4),
  377. (11, TIMESTAMP '2017-03-22 02:00:00.0', 3, 1, 'Rest1', '5', 11, 4),
  378. (12, TIMESTAMP '2017-04-22 02:00:00.0', 3, 1, 'Rest1', '4', 11, 6),
  379. (13, TIMESTAMP '2017-05-23 02:00:00.0', 5, 1, 'Rest1', '4', 11, 6),
  380. (14, TIMESTAMP '2017-06-30 02:00:00.0', 3, 1, 'Rest1', '4', 11, 6);
  381. CREATE MEMORY TABLE PUBLIC.RESTAURANT(
  382. ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_32F6767E_CF87_4A25_A79D_132B01FF1A71) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_32F6767E_CF87_4A25_A79D_132B01FF1A71,
  383. CITY VARCHAR(255),
  384. DESCRIPTION VARCHAR(255),
  385. NAME VARCHAR(255),
  386. STREET VARCHAR(255),
  387. STREET_NUMBER VARCHAR(255)
  388. );
  389. ALTER TABLE PUBLIC.RESTAURANT ADD CONSTRAINT PUBLIC.CONSTRAINT_B3 PRIMARY KEY(ID);
  390. -- 2 +/- SELECT COUNT(*) FROM PUBLIC.RESTAURANT;
  391. INSERT INTO PUBLIC.RESTAURANT(ID, CITY, DESCRIPTION, NAME, STREET, STREET_NUMBER) VALUES
  392. (1, 'Novi Sad', '...', 'Rest1', 'Bulevar Oslobodjenja', '111a'),
  393. (2, 'Beograd', '...', 'Rest2', 'Bulevar Oslobodjenja', '111a');
  394. CREATE MEMORY TABLE PUBLIC.RESTAURANT_BIDDER(
  395. BIDDER_ID BIGINT NOT NULL,
  396. RESTAURANT_ID BIGINT NOT NULL
  397. );
  398. -- 3 +/- SELECT COUNT(*) FROM PUBLIC.RESTAURANT_BIDDER;
  399. INSERT INTO PUBLIC.RESTAURANT_BIDDER(BIDDER_ID, RESTAURANT_ID) VALUES
  400. (16, 1),
  401. (17, 1),
  402. (18, 1);
  403. CREATE MEMORY TABLE PUBLIC.RESTAURANT_MANAGER(
  404. ID BIGINT NOT NULL,
  405. RESTAURANT_ID BIGINT
  406. );
  407. ALTER TABLE PUBLIC.RESTAURANT_MANAGER ADD CONSTRAINT PUBLIC.CONSTRAINT_20 PRIMARY KEY(ID);
  408. -- 2 +/- SELECT COUNT(*) FROM PUBLIC.RESTAURANT_MANAGER;
  409. INSERT INTO PUBLIC.RESTAURANT_MANAGER(ID, RESTAURANT_ID) VALUES
  410. (8, 1),
  411. (9, 2);
  412. CREATE MEMORY TABLE PUBLIC.RESTAURANT_RATES(
  413. RESTAURANT_ID BIGINT NOT NULL,
  414. RATES DOUBLE
  415. );
  416. -- 5 +/- SELECT COUNT(*) FROM PUBLIC.RESTAURANT_RATES;
  417. INSERT INTO PUBLIC.RESTAURANT_RATES(RESTAURANT_ID, RATES) VALUES
  418. (1, 3.0),
  419. (1, 2.0),
  420. (1, 5.0),
  421. (1, 4.0),
  422. (1, 5.0);
  423. CREATE MEMORY TABLE PUBLIC.RESTAURANT_TABLE(
  424. RESTAURANT_TABLE_ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_3C6F3CD3_C1EF_4669_9056_95DBAFA87604) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_3C6F3CD3_C1EF_4669_9056_95DBAFA87604,
  425. NUMBER INTEGER NOT NULL,
  426. POSITIONX INTEGER NOT NULL,
  427. POSITIONY INTEGER NOT NULL,
  428. SEATS INTEGER NOT NULL,
  429. AREA BIGINT NOT NULL
  430. );
  431. ALTER TABLE PUBLIC.RESTAURANT_TABLE ADD CONSTRAINT PUBLIC.CONSTRAINT_E PRIMARY KEY(RESTAURANT_TABLE_ID);
  432. -- 6 +/- SELECT COUNT(*) FROM PUBLIC.RESTAURANT_TABLE;
  433. INSERT INTO PUBLIC.RESTAURANT_TABLE(RESTAURANT_TABLE_ID, NUMBER, POSITIONX, POSITIONY, SEATS, AREA) VALUES
  434. (1, 815, 193, 286, 1, 2),
  435. (2, 228, 291, 283, 2, 2),
  436. (3, 877, 376, 176, 14, 2),
  437. (4, 42, 291, 175, 4, 2),
  438. (5, 9, 192, 173, 4, 2),
  439. (6, 76, 376, 176, 14, 1);
  440. CREATE MEMORY TABLE PUBLIC.SHIFT(
  441. SHIFT_ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_4FBC5CE9_4D9E_41DB_B096_21114380D898) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_4FBC5CE9_4D9E_41DB_B096_21114380D898,
  442. END_HOUR TIME NOT NULL,
  443. START_HOUR TIME NOT NULL,
  444. RESTAURANT_ID BIGINT NOT NULL
  445. );
  446. ALTER TABLE PUBLIC.SHIFT ADD CONSTRAINT PUBLIC.CONSTRAINT_4B3 PRIMARY KEY(SHIFT_ID);
  447. -- 2 +/- SELECT COUNT(*) FROM PUBLIC.SHIFT;
  448. INSERT INTO PUBLIC.SHIFT(SHIFT_ID, END_HOUR, START_HOUR, RESTAURANT_ID) VALUES
  449. (1, TIME '16:00:00', TIME '08:00:00', 1),
  450. (2, TIME '23:00:00', TIME '16:00:00', 1);
  451. CREATE MEMORY TABLE PUBLIC.SUPPLIES(
  452. SUPPLIES_ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_C0595938_F63E_4F6B_B6F4_B43942A981FE) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_C0595938_F63E_4F6B_B6F4_B43942A981FE,
  453. ACCEPTED_OFFER BOOLEAN,
  454. END_DATE TIMESTAMP,
  455. NEEDED VARCHAR(255),
  456. START_DATE TIMESTAMP,
  457. VERSION INTEGER DEFAULT 0 NOT NULL,
  458. RESTAURANT_ID BIGINT
  459. );
  460. ALTER TABLE PUBLIC.SUPPLIES ADD CONSTRAINT PUBLIC.CONSTRAINT_C PRIMARY KEY(SUPPLIES_ID);
  461. -- 2 +/- SELECT COUNT(*) FROM PUBLIC.SUPPLIES;
  462. INSERT INTO PUBLIC.SUPPLIES(SUPPLIES_ID, ACCEPTED_OFFER, END_DATE, NEEDED, START_DATE, VERSION, RESTAURANT_ID) VALUES
  463. (1, FALSE, TIMESTAMP '2017-06-30 00:00:00.0', 'Slanna i jaja', TIMESTAMP '2017-05-11 00:00:00.0', 0, 1),
  464. (2, FALSE, TIMESTAMP '2017-06-25 00:00:00.0', 'Crno vino 10l\n Belo vino 10l', TIMESTAMP '2017-05-11 00:00:00.0', 0, 1);
  465. CREATE MEMORY TABLE PUBLIC.USER(
  466. ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_997FEDF7_384E_4AE8_B1FA_CC69BC9A6B69) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_997FEDF7_384E_4AE8_B1FA_CC69BC9A6B69,
  467. EMAIL VARCHAR(255) NOT NULL,
  468. NAME VARCHAR(255),
  469. PASSWORD VARCHAR(255) NOT NULL,
  470. ROLE VARCHAR(255),
  471. SURNAME VARCHAR(255)
  472. );
  473. ALTER TABLE PUBLIC.USER ADD CONSTRAINT PUBLIC.CONSTRAINT_27 PRIMARY KEY(ID);
  474. -- 19 +/- SELECT COUNT(*) FROM PUBLIC.USER;
  475. INSERT INTO PUBLIC.USER(ID, EMAIL, NAME, PASSWORD, ROLE, SURNAME) VALUES
  476. (1, 'kantagara@gmail.com', 'Nikola', 'nikola123', 'ADMIN', 'Garabandic'),
  477. (2, 'sysman', 'sys ', 'asdf', 'SYSTEM_MANAGER', 'manager'),
  478. (3, 'guest@gmail.com', 'guest', 'asdf', 'GUEST', 'guest'),
  479. (4, 'vosmi@gmail.com', 'vosmi', 'vosmi', 'GUEST', 'vosmic'),
  480. (5, 'djokica@gmail.com', 'djokica', 'djokica', 'GUEST', 'djokica'),
  481. (6, 'patrik@gmail.com', 'patrik', 'patrik', 'GUEST', 'patrik'),
  482. (7, 'jugoslav@gmail.com', 'jugoslav', 'jugoslav', 'GUEST', 'jugoslav'),
  483. (8, 'restman', 'rest', 'asdf', 'RESTAURANT_MANAGER', 'man'),
  484. (9, 'restman2', 'rest', 'asdf', 'RESTAURANT_MANAGER', 'man'),
  485. (10, 'employee1', 'veljo', 'asdf', 'WAITER', 'man'),
  486. (11, 'employee2', 'pero', 'asdf', 'CHEF', 'man'),
  487. (12, 'employee3', 'krco', 'asdf', 'BARTENDER', 'man'),
  488. (13, 'employee4', 'raspo', 'asdf', 'CHEF', 'man'),
  489. (14, 'employee5', 'dila', 'asdf', 'BARTENDER', 'man'),
  490. (15, 'employee6', 'smrad', 'asdf', 'WAITER', 'man'),
  491. (16, 'bidder1', 'bidder', 'asdf', 'BIDDER', 'man'),
  492. (17, 'bidder2', 'bidder', 'asdf', 'BIDDER', 'man'),
  493. (18, 'bidder3', 'bidder', 'asdf', 'BIDDER', 'man'),
  494. (19, 'employee nov', 'novi', 'asdf', 'WAITER', 'man');
  495. ALTER TABLE PUBLIC.USER ADD CONSTRAINT PUBLIC.UK_GMRRM359QU7OGUSDU9R2QR637 UNIQUE(EMAIL);
  496. ALTER TABLE PUBLIC.SUPPLIES ADD CONSTRAINT PUBLIC.FKF6HQNY2QLKX67XW7OMVHQ2BGC FOREIGN KEY(RESTAURANT_ID) REFERENCES PUBLIC.RESTAURANT(ID) NOCHECK;
  497. ALTER TABLE PUBLIC.BID ADD CONSTRAINT PUBLIC.FK2TXYJW0R61TFXTYI4I0JNO0TL FOREIGN KEY(BIDDER_ID) REFERENCES PUBLIC.BIDDER(ID) NOCHECK;
  498. ALTER TABLE PUBLIC.ORDER_ITEM ADD CONSTRAINT PUBLIC.FKIVVJTN2W1F7PI280YI8KGDFSK FOREIGN KEY(USER_ID) REFERENCES PUBLIC.USER(ID) NOCHECK;
  499. ALTER TABLE PUBLIC.RATE ADD CONSTRAINT PUBLIC.FKT52FAH9K9IE0SV2PO3AAOQERD FOREIGN KEY(RESERVATION_ID) REFERENCES PUBLIC.RESERVATION(ID) NOCHECK;
  500. ALTER TABLE PUBLIC.DRINKITEM_RATES ADD CONSTRAINT PUBLIC.FK4RSV5D58OM0VXUSM84MW5HM17 FOREIGN KEY(DRINKITEM_ID) REFERENCES PUBLIC.DRINK_ITEM(ID) NOCHECK;
  501. ALTER TABLE PUBLIC.RATE_INVITEDNOTRATED ADD CONSTRAINT PUBLIC.FKI93CXNL6MRQPIPIHK6O9MR5GF FOREIGN KEY(RATE_RATE_ID) REFERENCES PUBLIC.RATE(RATE_ID) NOCHECK;
  502. ALTER TABLE PUBLIC.GUEST ADD CONSTRAINT PUBLIC.FKQQU48M8P6FPBUTEGH1NKGY54D FOREIGN KEY(ID) REFERENCES PUBLIC.USER(ID) NOCHECK;
  503. ALTER TABLE PUBLIC.EMPLOYEE_SHIFT ADD CONSTRAINT PUBLIC.FKDNSY9WDHMIEFEHNT3824DRU49 FOREIGN KEY(SHIFT_ID) REFERENCES PUBLIC.SHIFT(SHIFT_ID) NOCHECK;
  504. ALTER TABLE PUBLIC.EMPLOYEE ADD CONSTRAINT PUBLIC.FKCAME4TKE2U6K8ONEBU9JSKGYO FOREIGN KEY(RESTAURANT_ID) REFERENCES PUBLIC.RESTAURANT(ID) NOCHECK;
  505. ALTER TABLE PUBLIC.EMPLOYEE_SHIFT ADD CONSTRAINT PUBLIC.FKCTLLHOXEY2MBMSR070FUKV9QA FOREIGN KEY(AREA_ID) REFERENCES PUBLIC.AREA(AREA_ID) NOCHECK;
  506. ALTER TABLE PUBLIC.SHIFT ADD CONSTRAINT PUBLIC.FKCYIHQXNN5IK9LRY5AGM9978HL FOREIGN KEY(RESTAURANT_ID) REFERENCES PUBLIC.RESTAURANT(ID) NOCHECK;
  507. ALTER TABLE PUBLIC.EMPLOYEE_RATES ADD CONSTRAINT PUBLIC.FKIWDLE5E28XG94G7KRDJU6SRFB FOREIGN KEY(EMPLOYEE_ID) REFERENCES PUBLIC.EMPLOYEE(ID) NOCHECK;
  508. ALTER TABLE PUBLIC.EMPLOYEE ADD CONSTRAINT PUBLIC.FK2FAU84LPW6L6O3RPD2UQDTG84 FOREIGN KEY(ID) REFERENCES PUBLIC.USER(ID) NOCHECK;
  509. ALTER TABLE PUBLIC.ORDERS ADD CONSTRAINT PUBLIC.FKGKA1QCX3EHODL1TJHF0N11U4C FOREIGN KEY(RESERVATION_ID) REFERENCES PUBLIC.RESERVATION(ID) NOCHECK;
  510. ALTER TABLE PUBLIC.DRINK_ITEM ADD CONSTRAINT PUBLIC.FK627K0XP4WGBG19SLNBV1PM7CW FOREIGN KEY(FINALORDER_ID) REFERENCES PUBLIC.ORDERS(ID) NOCHECK;
  511. ALTER TABLE PUBLIC.ORDERS ADD CONSTRAINT PUBLIC.FK996XQT09WG74354FA2T7HOM58 FOREIGN KEY(USER_ID) REFERENCES PUBLIC.USER(ID) NOCHECK;
  512. ALTER TABLE PUBLIC.RESTAURANT_MANAGER ADD CONSTRAINT PUBLIC.FK8ISHXYNXNJRURJUO0MVLCRDNN FOREIGN KEY(RESTAURANT_ID) REFERENCES PUBLIC.RESTAURANT(ID) NOCHECK;
  513. ALTER TABLE PUBLIC.MENUITEM_RATES ADD CONSTRAINT PUBLIC.FK9H6G1O7DRSAE8XBBNHP8G55N5 FOREIGN KEY(MENUITEM_ID) REFERENCES PUBLIC.MENU_ITEM(ID) NOCHECK;
  514. ALTER TABLE PUBLIC.AREA ADD CONSTRAINT PUBLIC.FK3HL3MMBOU1TJF1TH07Y02AWTI FOREIGN KEY(RESTAURANT_ID) REFERENCES PUBLIC.RESTAURANT(ID) NOCHECK;
  515. ALTER TABLE PUBLIC.BID ADD CONSTRAINT PUBLIC.FKM1K1VHVA4KOVGSJFCDLPCDI5V FOREIGN KEY(SUPPLIES_ID) REFERENCES PUBLIC.SUPPLIES(SUPPLIES_ID) NOCHECK;
  516. ALTER TABLE PUBLIC.ORDER_ITEM ADD CONSTRAINT PUBLIC.FKT6BDYFC81HSP914AD0TUYH50I FOREIGN KEY(BILL_ID) REFERENCES PUBLIC.ORDERS(ID) NOCHECK;
  517. ALTER TABLE PUBLIC.ORDER_ITEM ADD CONSTRAINT PUBLIC.FK3PKJ02UEFM7HTSKIYHMBR88QR FOREIGN KEY(RESTAURANT_ID) REFERENCES PUBLIC.RESTAURANT(ID) NOCHECK;
  518. ALTER TABLE PUBLIC.RESTAURANT_RATES ADD CONSTRAINT PUBLIC.FKQ46SBB4D8TFX1YFPLHJYL5PF8 FOREIGN KEY(RESTAURANT_ID) REFERENCES PUBLIC.RESTAURANT(ID) NOCHECK;
  519. ALTER TABLE PUBLIC.BIDDER ADD CONSTRAINT PUBLIC.FK4UVMD18362EW864MTTUDQWDSM FOREIGN KEY(ID) REFERENCES PUBLIC.USER(ID) NOCHECK;
  520. ALTER TABLE PUBLIC.EMPLOYEE_SHIFT ADD CONSTRAINT PUBLIC.FKAMCFBP52GYX9JMH75CS3HFQU2 FOREIGN KEY(EMPLOYEE_ID) REFERENCES PUBLIC.EMPLOYEE(ID) NOCHECK;
  521. ALTER TABLE PUBLIC.ORDERS ADD CONSTRAINT PUBLIC.FKB09Y67YGQJ00O2LJ6HSH4QUWU FOREIGN KEY(RESTAURANT_ID) REFERENCES PUBLIC.RESTAURANT(ID) NOCHECK;
  522. ALTER TABLE PUBLIC.RESTAURANT_MANAGER ADD CONSTRAINT PUBLIC.FKP3VAT1G53O5M91RH3NGPT8WJ9 FOREIGN KEY(ID) REFERENCES PUBLIC.USER(ID) NOCHECK;
  523. ALTER TABLE PUBLIC.DRINK_ITEM ADD CONSTRAINT PUBLIC.FK8VXY0YX6HK5SWYT8WCSHYJ4UH FOREIGN KEY(DRINK_CARD_ID) REFERENCES PUBLIC.DRINKCARD(DRINK_CARD_ID) NOCHECK;
  524. ALTER TABLE PUBLIC.DRINKCARD ADD CONSTRAINT PUBLIC.FKTVAQI1AJ3VU9W4GT160L8QFM FOREIGN KEY(RESTAURANT_ID) REFERENCES PUBLIC.RESTAURANT(ID) NOCHECK;
  525. ALTER TABLE PUBLIC.RESTAURANT_BIDDER ADD CONSTRAINT PUBLIC.FKPLDBDR08KHMISM2YFNWMS3F4B FOREIGN KEY(BIDDER_ID) REFERENCES PUBLIC.BIDDER(ID) NOCHECK;
  526. ALTER TABLE PUBLIC.MENU_ITEM ADD CONSTRAINT PUBLIC.FKRXGNVKA3DA9DECJAEH848SSO4 FOREIGN KEY(FINALORDER_ID) REFERENCES PUBLIC.ORDERS(ID) NOCHECK;
  527. ALTER TABLE PUBLIC.MENU_ITEM ADD CONSTRAINT PUBLIC.FK48EHRRGKSEG1IMYKYS66CXWTU FOREIGN KEY(MENU_ID) REFERENCES PUBLIC.MENU(MENU_ID) NOCHECK;
  528. ALTER TABLE PUBLIC.MENU ADD CONSTRAINT PUBLIC.FK8K3H58SA22WM36705F3R5F0R3 FOREIGN KEY(RESTAURANT_ID) REFERENCES PUBLIC.RESTAURANT(ID) NOCHECK;
  529. ALTER TABLE PUBLIC.RESTAURANT_BIDDER ADD CONSTRAINT PUBLIC.FKDIG48L45M0GWYLVBX4FGJ1JY9 FOREIGN KEY(RESTAURANT_ID) REFERENCES PUBLIC.RESTAURANT(ID) NOCHECK;
  530. ALTER TABLE PUBLIC.RESTAURANT_TABLE ADD CONSTRAINT PUBLIC.FKJB9S1865BVSHJOXMVGWW3YEB7 FOREIGN KEY(AREA) REFERENCES PUBLIC.AREA(AREA_ID) NOCHECK;
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!