text: BEGIN;
  INSERT INTO budget_monitor.users (username, password, email, currency) VALUES ('user', '$2a$08$mpzkObqUlVQ5OW1i8AyceecW5hhbtEfwGV61W3wa4i/yJQ3Mf/78y', 'user@domain.com', 'PLN');
  INSERT INTO budget_monitor.userRoles (username, rolename) VALUES ('user', 'USER');
  
  INSERT INTO budget_monitor.categories (idCategory, idSuperCategory, owner, name)
  VALUES (4, 2, 'user', 'Wynagrodzenie'),
         (5, 2, 'user', 'Prezenty'),
         (6, 3, 'user', 'Codzienne wydatki'),
         (7, 3, 'user', 'Transport'),
         (8, 3, 'user', 'Osobiste'),
         (9, 6, 'user', 'Zakupy'),
         (10, 6, 'user', 'Jedzenie poza domem'),
         (11, 9, 'user', 'Spożywcze'),
         (12, 9, 'user', 'Chemia'),
         (13, 9, 'user', 'Zdrowie'),
         (15, 10, 'user', 'Obiad'),
         (16, 10, 'user', 'Pizza'),
         (17, 11, 'user', 'Pieczywo'),
         (18, 11, 'user', 'Mięso'),
         (19, 11, 'user', 'Ryby'),
         (20, 11, 'user', 'Nabiał'),
         (21, 11, 'user', 'Napoje'),
         (22, 11, 'user', 'Słodycze'),
         (23, 7, 'user', 'Komunikacja miejska'),
         (24, 8, 'user', 'Edukacja'),
         (25, 8, 'user', 'Elektronika'),
         (26, 8, 'user', 'Odzież i obuwie'),
         (27, 8, 'user', 'Prezenty'),
         (28, 8, 'user', 'Fryzjer'),
         (29, 3, 'user', 'Rozrywka'),
         (30, 29, 'user', 'Alkohol'),
         (31, 29, 'user', 'Kino'),
         (32, 29, 'user', 'Książki'),
         (33, 29, 'user', 'Gry'),
         (34, 11, 'user', 'Pozostałe'),
         (35, 10, 'user', 'McDonald''s'),
         (36, 10, 'user', 'Burger King'),
         (38, 15, 'user', 'Spacja'),
         (39, 15, 'user', 'Bistro spacja'),
         (40, 15, 'user', 'Moja'),
         (41, 15, 'user', 'Tawo');
  
  INSERT INTO budget_monitor.entries (idEntry, owner, idCategory, description, value, date, dateOfAddition, dateOfLastModification, photo)
  VALUES (1, 'user', 16, 'Pizza Dominos: Double Bacon Burger, Quattro Cheese', -4298, '2018-01-19 10:42:00', '2018-12-28 16:29:47', '2018-12-28 16:29:47', null),
         (2, 'user', 16, 'Pizza Dominos: Double Bacon Burger, Pulled Pork', -4248, '2018-02-06 10:54:00', '2018-12-28 16:34:30', '2018-12-28 16:34:30', null),
         (3, 'user', 16, 'Pizza Dominos: Double Bacon Burger', -2998, '2018-02-15 15:30:00', '2018-12-28 16:35:52', '2018-12-28 16:35:52', null),
         (4, 'user', 16, 'Pizza Dominos: Double Bacon Burger, Pulled Pork', -5990, '2018-02-21 12:39:00', '2018-12-28 16:37:41', '2018-12-28 16:37:41', null),
         (5, 'user', 16, 'Pizza Dominos: Double Bacon Burger, Pulled Pork', -4248, '2018-03-09 11:31:00', '2018-12-28 16:38:43', '2018-12-28 16:38:43', null),
         (6, 'user', 16, 'Pizza Dominos: Double Bacon Burger, Tex-Mex', -4098, '2018-04-04 10:36:00', '2018-12-28 16:39:21', '2018-12-28 16:39:21', null),
         (7, 'user', 16, 'Pizza Dominos: Tex-Mex, Tex-Mex', -4198, '2018-04-27 15:13:00', '2018-12-28 16:40:08', '2018-12-28 16:40:08', null),
         (8, 'user', 16, 'Pizza Dominos: Tex-Mex, Veggie Supreme', -4348, '2018-05-01 09:26:00', '2018-12-28 16:40:50', '2018-12-28 16:40:50', null),
         (9, 'user', 16, 'Pizza Dominos: Tex-Mex, Veggie Supreme', -6046, '2018-05-11 11:08:00', '2018-12-28 16:42:38', '2018-12-28 16:48:12', null),
         (10, 'user', 16, 'Pizza Dominos: Double Bacon Burger, Tex-Mex', -4098, '2018-06-16 18:36:00', '2018-12-28 16:50:16', '2018-12-28 16:50:16', null),
         (11, 'user', 16, 'Pizza Dominos: Double Bacon Burger, Tex-Mex', -4896, '2018-06-27 15:05:00', '2018-12-28 16:51:03', '2018-12-28 16:51:03', null),
         (12, 'user', 16, 'Pizza Dominos: Tex-Mex, Tex-Mex', -4896, '2018-06-30 13:15:00', '2018-12-28 16:51:48', '2018-12-28 16:51:48', null),
         (13, 'user', 16, 'Pizza Dominos: Double Bacon Burger, Tex-Mex', -4198, '2018-07-24 14:50:00', '2018-12-28 16:52:31', '2018-12-28 16:52:44', null),
         (14, 'user', 16, 'Pizza Dominos: Double Bacon Burger, Chorizo', -4298, '2018-08-27 13:35:00', '2018-12-28 16:53:30', '2018-12-28 16:53:30', null),
         (15, 'user', 16, 'Pizza Dominos: Double Bacon Burger, Pulled Pork', -4248, '2018-09-13 12:48:00', '2018-12-28 16:54:00', '2018-12-28 16:54:00', null),
         (16, 'user', 16, 'Pizza Dominos: Double Bacon Burger, Pulled Pork', -4498, '2018-09-21 13:15:00', '2018-12-28 16:55:48', '2018-12-28 16:55:48', null),
         (17, 'user', 16, 'Pizza Dominos: Double Bacon Burger, Pulled Pork', -4498, '2018-09-27 11:05:00', '2018-12-28 16:56:37', '2018-12-28 16:56:37', null),
         (18, 'user', 16, 'Pizza Dominos: Double Bacon Burger, Pulled Pork', -4498, '2018-11-03 12:16:00', '2018-12-28 16:58:29', '2018-12-28 16:58:29', null),
         (19, 'user', 16, 'Pizza Dominos: Double Bacon Burger, New Yorker', -4298, '2018-11-21 17:38:00', '2018-12-28 17:00:20', '2018-12-28 17:00:20', null),
         (20, 'user', 16, 'Pizza Dominos: Double Bacon Burger, Texas BBQ', -4498, '2018-12-14 17:39:00', '2018-12-28 17:01:17', '2018-12-28 17:01:17', null),
         (21, 'user', 16, 'Pizza Dominos: Double Bacon Burger, Texas BBQ', -4498, '2018-12-20 14:25:00', '2018-12-28 17:01:51', '2018-12-28 17:01:51', null),
         (22, 'user', 23, 'Bilet ulgowy semestralny na wszystkie linie w strefie miejskiej ważny we wszystkie dni tygodnia', -14700, '2018-09-02 13:48:00', '2018-12-28 17:33:42', '2018-12-28 17:33:42', null),
         (23, 'user', 23, 'Bilet ulgowy semestralny na wszystkie linie w strefie miejskiej ważny we wszystkie dni tygodnia', -18400, '2018-04-03 20:04:00', '2018-12-28 17:34:23', '2018-12-28 17:34:23', null),
         (24, 'user', 40, 'Grillowana pierś z kurczaka ze szpinakiem, frytki', -2700, '2018-12-11 10:53:00', '2018-12-28 17:51:30', '2018-12-28 18:36:07', null),
         (25, 'user', 40, 'Tortilla z wołowiną, wyciskany sok jabłkowy', -2870, '2018-11-06 12:03:00', '2018-12-28 17:54:25', '2018-12-28 18:36:14', null),
         (26, 'user', 35, 'Burger, shake waniliowy', -2390, '2018-11-05 10:41:00', '2018-12-28 17:55:38', '2018-12-28 17:55:38', null),
         (27, 'user', 35, '2 x cheeseburger, frytki, lody czekoladowe, woda', -1700, '2018-12-03 10:39:00', '2018-12-28 17:57:22', '2018-12-28 17:57:22', null),
         (28, 'user', 36, 'Whopper, chicken burger', -1495, '2018-10-05 09:14:00', '2018-12-28 17:58:26', '2018-12-28 17:58:26', null),
         (29, 'user', 38, 'Kurczak, frytki', -1900, '2018-11-27 11:07:00', '2018-12-28 18:09:44', '2018-12-28 18:34:58', null),
         (30, 'user', 38, 'Kurczak, frytki', -1900, '2018-11-20 11:27:00', '2018-12-28 18:10:10', '2018-12-28 18:35:03', null),
         (31, 'user', 38, 'Kurczak, frytki', -1900, '2018-12-05 12:12:00', '2018-12-28 18:10:30', '2018-12-28 18:35:10', null),
         (32, 'user', 38, 'Kurczak, frytki', -1900, '2018-10-30 10:35:00', '2018-12-28 18:10:51', '2018-12-28 18:35:17', null),
         (33, 'user', 38, 'Zestaw dnia, dodatek, frytki', -2150, '2018-11-21 12:03:00', '2018-12-28 18:11:35', '2018-12-28 19:04:10', null),
         (34, 'user', 38, 'Zestaw dnia', -1400, '2018-12-10 10:38:00', '2018-12-28 18:11:55', '2018-12-28 18:35:32', null),
         (35, 'user', 38, 'Zestaw dnia', -1400, '2018-11-28 10:49:00', '2018-12-28 18:12:18', '2018-12-28 18:35:41', null),
         (36, 'user', 40, 'Dewolaj, frytki', -1305, '2018-12-12 10:45:00', '2018-12-28 18:38:47', '2018-12-28 18:38:47', null),
         (37, 'user', 39, 'Mała misa', -1900, '2018-11-07 14:04:00', '2018-12-28 18:41:10', '2018-12-28 18:41:10', null),
         (39, 'user', 39, 'Pizza prosciutto e funghi', -1700, '2018-11-26 10:35:00', '2018-12-28 18:44:17', '2018-12-28 18:44:17', null),
         (40, 'user', 41, 'Bitki wołowe w sosie', -1250, '2018-11-22 11:50:00', '2018-12-28 18:45:29', '2018-12-28 18:45:29', null),
         (41, 'user', 38, 'Frytki', -400, '2018-10-08 10:00:00', '2018-12-28 18:46:09', '2018-12-28 18:46:09', null),
         (42, 'user', 41, 'Danie dnia', -1480, '2018-10-11 10:45:00', '2018-12-28 18:48:15', '2018-12-28 18:48:15', null),
         (43, 'user', 36, 'Zestaw z kuponu', -1295, '2018-10-13 10:00:00', '2018-12-28 18:50:03', '2018-12-28 18:50:03', null),
         (44, 'user', 41, 'Danie dnia', -1450, '2018-10-18 10:55:00', '2018-12-28 18:50:58', '2018-12-28 18:50:58', null),
         (45, 'user', 38, 'Danie dnia', -1700, '2018-10-23 09:50:00', '2018-12-28 18:51:46', '2018-12-28 18:51:46', null),
         (46, 'user', 38, 'Danie dnia', -1400, '2018-10-24 10:15:00', '2018-12-28 18:52:50', '2018-12-28 18:52:50', null),
         (47, 'user', 41, 'Danie dnia', -1550, '2018-10-25 10:50:00', '2018-12-28 18:53:42', '2018-12-28 18:53:42', null),
         (48, 'user', 15, 'Kurczak po wietnamsku', -2050, '2018-11-30 10:23:00', '2018-12-28 19:02:27', '2018-12-28 19:02:27', null),
         (49, 'user', 15, 'Kurczak po wietnamsku', -2050, '2018-10-19 08:11:00', '2018-12-28 19:02:48', '2018-12-28 19:03:05', null),
         (50, 'user', 11, 'Buczek', -1490, '2018-11-29 11:34:00', '2018-12-28 19:06:29', '2018-12-28 19:06:29', null),
         (51, 'user', 17, 'Buczek', -1200, '2018-11-23 10:27:00', '2018-12-28 19:08:30', '2018-12-28 19:10:06', null),
         (52, 'user', 17, 'Buczek', -800, '2018-11-09 09:51:00', '2018-12-28 19:09:26', '2018-12-28 19:10:13', null),
         (53, 'user', 22, 'Żabka - baton knopers', -249, '2018-12-12 11:26:00', '2018-12-28 19:11:14', '2018-12-28 19:11:36', null),
         (54, 'user', 22, 'Żabka - baton snickers', -329, '2018-11-21 12:40:00', '2018-12-28 19:12:38', '2018-12-28 19:12:38', null),
         (55, 'user', 22, 'Żabka - baton snickers', -450, '2018-12-05 12:44:00', '2018-12-28 19:13:23', '2018-12-28 19:13:23', null),
         (56, 'user', 22, 'Czarnowiejska - baton snickers', -459, '2018-11-22 06:54:00', '2018-12-28 19:14:27', '2018-12-28 19:14:27', null),
         (57, 'user', 10, 'Lody', -4600, '2018-10-27 11:12:00', '2018-12-28 19:15:57', '2018-12-28 19:15:57', null),
         (58, 'user', 11, 'Lidl', -2918, '2018-11-03 18:03:00', '2018-12-28 19:19:37', '2018-12-28 19:19:37', null),
         (59, 'user', 11, 'Biedronka', -4462, '2018-12-05 17:41:00', '2018-12-28 19:22:49', '2018-12-28 19:22:49', null),
         (60, 'user', 9, 'Lidl', -7987, '2018-12-22 15:04:00', '2018-12-28 19:26:25', '2018-12-28 19:26:25', null),
         (61, 'user', 12, 'Rossmann', -2388, '2018-10-29 15:30:00', '2018-12-28 19:27:14', '2018-12-28 19:27:14', null),
         (62, 'user', 12, 'Mila', -998, '2018-11-23 09:49:00', '2018-12-28 19:28:10', '2018-12-28 19:28:10', null),
         (63, 'user', 9, 'Mila', -1433, '2018-10-02 12:23:00', '2018-12-28 19:30:01', '2018-12-28 19:30:23', null),
         (64, 'user', 11, 'Mila', -1178, '2018-10-12 08:41:00', '2018-12-28 19:32:05', '2018-12-28 19:32:05', null),
         (65, 'user', 9, 'Mila', -1979, '2018-10-26 09:20:00', '2018-12-28 19:34:30', '2018-12-28 19:34:30', null),
         (66, 'user', 10, 'Burger', -1400, '2018-11-30 22:25:00', '2018-12-28 19:37:49', '2018-12-28 19:37:49', null),
         (67, 'user', 30, 'Whiskey', -4500, '2018-11-30 19:00:00', '2018-12-28 19:39:06', '2018-12-28 19:39:06', null),
         (68, 'user', 17, 'Buczek', -1150, '2018-11-16 10:10:00', '2018-12-28 19:40:02', '2018-12-28 19:40:02', null),
         (69, 'user', 17, 'Buczek', -900, '2018-11-08 12:20:00', '2018-12-28 19:40:46', '2018-12-28 19:40:46', null),
         (70, 'user', 22, 'Żabka - baton snickers', -449, '2018-11-07 14:35:00', '2018-12-28 19:41:36', '2018-12-28 19:41:36', null),
         (71, 'user', 17, 'Buczek', -800, '2018-10-26 09:20:00', '2018-12-28 19:42:29', '2018-12-28 19:42:29', null),
         (72, 'user', 28, 'Fryzjer', -3800, '2018-10-22 16:00:00', '2018-12-28 19:43:32', '2018-12-28 19:43:32', null),
         (73, 'user', 38, 'Danie dnia', -1700, '2018-10-16 10:40:00', '2018-12-28 19:44:10', '2018-12-28 19:44:10', null),
         (74, 'user', 30, 'Whiskey', -5600, '2018-10-12 18:00:00', '2018-12-28 19:46:05', '2018-12-28 19:46:05', null),
         (75, 'user', 17, 'Buczek', -600, '2018-10-12 08:50:00', '2018-12-28 19:46:42', '2018-12-28 19:46:42', null);
  
  INSERT INTO budget_monitor.subEntries (idSubEntry, idEntry, idCategory, description, value)
  VALUES (2, 9, 16, 'Chicken & Spinach Wrap', -1698),
         (3, 50, 22, 'Pączek', -1200),
         (4, 50, 17, 'Chleb', -290),
         (5, 58, 34, '2 Chipsy Lays', -678),
         (6, 58, 21, '2 Kormorany', -1198),
         (7, 58, 21, '2 Mirosławy', -998),
         (8, 59, 22, 'Monte', -229),
         (9, 59, 20, 'Cheddar', -699),
         (10, 59, 18, 'Szynka', -599),
         (11, 59, 19, 'Łosoś wędzony', -1598),
         (12, 59, 22, 'Nutella', -999),
         (13, 59, 34, 'Pasta kanapkowa', -338),
         (14, 60, 17, 'Croissant', -995),
         (15, 60, 18, 'Szynka', -699),
         (16, 60, 18, 'Salami', -1099),
         (17, 60, 20, 'Roquefort', -699),
         (18, 60, 20, 'Cheddar', -799),
         (19, 60, 22, 'Czekolada', -699),
         (20, 60, 13, 'Aspiryna', -999),
         (21, 60, 22, 'Czekolada', -199),
         (22, 60, 12, 'Chemia', -1799),
         (26, 63, 12, 'Chusteczki', -295),
         (27, 63, 34, 'Płatki śniadaniowe', -899),
         (28, 63, 20, 'Mleko', -239),
         (29, 64, 34, 'Płatki śniadaniowe', -899),
         (30, 64, 20, 'Mleko', -279),
         (31, 65, 12, 'Chemia', -998),
         (32, 65, 34, 'Płatki śniadaniowe', -249),
         (33, 65, 20, 'Mleko', -279);
  
  COMMIT;