--
--

SET transaction_timeout = 0;
SELECT pg_catalog.set_config('search_path', '', false);


INSERT INTO synergymed.users VALUES (1, 'Иван', 'Петровски', 'ivan.petrovski', '$2a$12$4nkaobUd.oVHdb5RLcuEe.FyjoFotxXvfs8smAPi1EJskPY2YPBuu', 'ivan.petrovski@example.com', 'машки', '2023-02-15', '1990-03-14', true, true, true, true);
INSERT INTO synergymed.users VALUES (2, 'Ана', 'Петрова', 'ana.petrova', '$2a$12$MOTA1vYT5fRX64aUzP7b3ea2Dl7ifvFWrTtKpD9.5huRVposj0nNO', 'ana.petrova@example.com', 'женски', '2023-03-10', '1992-07-23', true, true, true, true);
INSERT INTO synergymed.users VALUES (3, 'Марко', 'Јовановски', 'marko.jovanovski', '$2a$12$j/tM9VZ4EVsqZ8rvdJmDLuEGq/ynFBRXEKB0ekRktFwoPCo1aoScW', 'marko.jovanovski@example.com', 'машки', '2023-05-21', '1988-11-05', true, true, true, true);
INSERT INTO synergymed.users VALUES (4, 'Марија', 'Јованова', 'marija.jovanova', '$2a$12$oN1vWyausLL.CUs0Yog1.u3J4ob3DgAu/tQDwjRMf9JN4TwAm3Ij.', 'marija.jovanova@example.com', 'женски', '2023-06-07', '1995-01-29', true, true, true, true);
INSERT INTO synergymed.users VALUES (5, 'Дамјан', 'Илиевски', 'damjan.ilievski', '$2a$12$wdXYGgKHX.lOAhiZTUKKsO.ftSUFWxt9aZoNb6N/fi45.O4geR6eO', 'damjan.ilievski@example.com', 'машки', '2023-08-30', '1991-09-12', true, true, true, true);
INSERT INTO synergymed.users VALUES (6, 'Елена', 'Николова', 'elena.nikolova', '$2a$12$gji9c7bwiAwCmPnViYeWUuMsq1HKOJwvoILnxLhcUCIWU7pL1yHIO', 'elena.nikolova@example.com', 'женски', '2023-11-12', '1993-04-08', true, true, true, true);
INSERT INTO synergymed.users VALUES (7, 'Горан', 'Димитров', 'goran.dimitrov', '$2a$12$pw9m/1iNHEg//uucnEOwbuD3PjvIoanz58CGRE20SsoFnWn8tWIHG', 'goran.dimitrov@example.com', 'машки', '2024-01-19', '1987-02-18', true, true, true, true);
INSERT INTO synergymed.users VALUES (8, 'Катарина', 'Стојанова', 'katarina.stojanova', '$2a$12$rwezKMPV4BZUrZPdk0ZEguyd/lw.cvycJla/Ck75tqvS3rCaL9W9C', 'katarina.stojanova@example.com', 'женски', '2024-04-03', '1994-10-02', true, true, true, true);
INSERT INTO synergymed.users VALUES (9, 'Александар', 'Николов', 'aleksandar.nikolov', '$2a$12$h5i3jCDonXHp9lpGC0rNlOUxOqsaxUZwl/8UKZDZyUNF8CBE2KDSK', 'aleksandar.nikolov@example.com', 'машки', '2024-06-25', '1989-07-07', true, true, true, true);
INSERT INTO synergymed.users VALUES (10, 'Теодора', 'Костова', 'teodora.kostova', '$2a$12$UxDgq0rE5zYgnID0Pwxcp.HtBaaEyKfWlH299MCrY5DE1ZGtd2.dq', 'teodora.kostova@example.com', 'женски', '2024-09-14', '1996-12-15', true, true, true, true);


INSERT INTO synergymed.admins VALUES (9);
INSERT INTO synergymed.admins VALUES (10);


INSERT INTO synergymed.client VALUES (2, false);
INSERT INTO synergymed.client VALUES (3, true);
INSERT INTO synergymed.client VALUES (4, false);
INSERT INTO synergymed.client VALUES (5, false);
INSERT INTO synergymed.client VALUES (1, true);
INSERT INTO synergymed.client VALUES (6, true);


INSERT INTO synergymed.healthprofile VALUES (1, 1, 'A+');
INSERT INTO synergymed.healthprofile VALUES (2, 2, 'O-');
INSERT INTO synergymed.healthprofile VALUES (3, 4, 'B+');
INSERT INTO synergymed.healthprofile VALUES (4, 3, 'B-');
INSERT INTO synergymed.healthprofile VALUES (5, 5, 'O-');


INSERT INTO synergymed.medicine VALUES (1, 'Парацетамол', 'Парацетамол');
INSERT INTO synergymed.medicine VALUES (2, 'Пропифеназон', 'Пропифеназон');
INSERT INTO synergymed.medicine VALUES (3, 'Кофеин', 'Кофеин');
INSERT INTO synergymed.medicine VALUES (4, 'Кодеин фосфат', 'Кодеин фосфат');
INSERT INTO synergymed.medicine VALUES (5, 'Ибупрофен', 'Ибупрофен');
INSERT INTO synergymed.medicine VALUES (6, 'Азитромицин', 'Азитромицин');
INSERT INTO synergymed.medicine VALUES (7, 'Бензидамин хидрохлорид', 'Бензидамин хидрохлорид');
INSERT INTO synergymed.medicine VALUES (8, 'Силденафил цитрат', 'Силденафил цитрат');


INSERT INTO synergymed.allergicreaction_healthprofile_medicine VALUES (1, 6, '2018-09-17', 'Алергија на азитромицин (осип).', 'лесна');
INSERT INTO synergymed.allergicreaction_healthprofile_medicine VALUES (2, 5, '2020-03-03', 'Неподносливост на НСАИЛ (ибупрофен) – гастроинтестинални симптоми.', 'умерена');


INSERT INTO synergymed.company VALUES (1, 'Алкалоид АД Скопје', 'Фармацевтска компанија со производство и дистрибуција на лекови, козметика и хемиски производи.', 'MK-ALK-1936');
INSERT INTO synergymed.company VALUES (2, 'Реплек АД Скопје', 'Производител на генерички лекови и производи за орална и топикална примена.', 'MK-REP-1945');
INSERT INTO synergymed.company VALUES (3, 'Зегин ДОО Скопје', 'Аптекарска мрежа и малопродажба на лекови и здравствени производи.', 'MK-ZEG-1990');
INSERT INTO synergymed.company VALUES (4, 'ЕЛС ДООЕЛ Скопје', 'Приватна пошта и логистика (Eco Logistic Service) со домашни и меѓународни услуги.', 'MK-ELS-2001');


INSERT INTO synergymed.manufacturer VALUES (1);
INSERT INTO synergymed.manufacturer VALUES (2);


INSERT INTO synergymed.brandedmedicine VALUES (1, 1, 180.00, 'Комбиниран аналгетик: парацетамол, пропифеназон, кофеин, кодеин.', 'таблета', 'Paracetamol 250 mg / Propyphenazone 210 mg / Caffeine 50 mg / Codeine 10 mg', 'С. Македонија', 'Кафетин');
INSERT INTO synergymed.brandedmedicine VALUES (2, 2, 120.00, 'НСАИЛ за болка и температура (ибупрофен).', 'обложена таблета', '200 mg или 400 mg', 'С. Македонија', 'Ибупрофен Актив');
INSERT INTO synergymed.brandedmedicine VALUES (3, 2, 360.00, 'Макролиден антибиотик (азитромицин).', 'филм-обложена таблета', '500 mg', 'С. Македонија', 'Азимед');
INSERT INTO synergymed.brandedmedicine VALUES (4, 2, 250.00, 'Орофарингеален спреј со бензидамин.', 'орален спреј', '1.5 mg/ml', 'С. Македонија', 'Оралсепт');


INSERT INTO synergymed.branded_medicine_instanceof_medicine VALUES (1, 1);
INSERT INTO synergymed.branded_medicine_instanceof_medicine VALUES (1, 2);
INSERT INTO synergymed.branded_medicine_instanceof_medicine VALUES (1, 3);
INSERT INTO synergymed.branded_medicine_instanceof_medicine VALUES (1, 4);
INSERT INTO synergymed.branded_medicine_instanceof_medicine VALUES (2, 5);
INSERT INTO synergymed.branded_medicine_instanceof_medicine VALUES (3, 6);
INSERT INTO synergymed.branded_medicine_instanceof_medicine VALUES (4, 7);


INSERT INTO synergymed.brandedmedicineimage VALUES (55, 1, '/uploads/images/branded_medicine/branded_medicine_1_1756942843570_001.png', true);
INSERT INTO synergymed.brandedmedicineimage VALUES (56, 1, '/uploads/images/branded_medicine/branded_medicine_1_1756942843570_002.jpg', false);
INSERT INTO synergymed.brandedmedicineimage VALUES (57, 2, '/uploads/images/branded_medicine/branded_medicine_2_1756942853345_001.png', true);
INSERT INTO synergymed.brandedmedicineimage VALUES (58, 2, '/uploads/images/branded_medicine/branded_medicine_2_1756942853345_002.png', false);
INSERT INTO synergymed.brandedmedicineimage VALUES (59, 3, '/uploads/images/branded_medicine/branded_medicine_3_1756942888851_001.jpg', true);
INSERT INTO synergymed.brandedmedicineimage VALUES (60, 3, '/uploads/images/branded_medicine/branded_medicine_3_1756942888851_002.jpg', false);
INSERT INTO synergymed.brandedmedicineimage VALUES (61, 4, '/uploads/images/branded_medicine/branded_medicine_4_1756942908650_001.jpg', false);
INSERT INTO synergymed.brandedmedicineimage VALUES (62, 4, '/uploads/images/branded_medicine/branded_medicine_4_1756942908650_002.jpg', true);
INSERT INTO synergymed.brandedmedicineimage VALUES (63, 1, '/uploads/images/branded_medicine/branded_medicine_1_1756985870285_001.png', false);
INSERT INTO synergymed.brandedmedicineimage VALUES (64, 1, '/uploads/images/branded_medicine/branded_medicine_1_1756985870285_002.png', false);


INSERT INTO synergymed.deliverycompany VALUES (4);


INSERT INTO synergymed.paymentmethod VALUES (1, 'готовина');
INSERT INTO synergymed.paymentmethod VALUES (2, 'картичка');


INSERT INTO synergymed.payment VALUES (1, 1, 2, '2025-02-02', 420, 'завршено');
INSERT INTO synergymed.payment VALUES (2, 2, 1, '2025-03-15', 250, 'завршено');
INSERT INTO synergymed.payment VALUES (3, 4, 1, '2025-05-09', 360, 'неуспешно');
INSERT INTO synergymed.payment VALUES (10, 1, 2, '2025-09-01', 960, 'завршено');
INSERT INTO synergymed.payment VALUES (11, 1, 2, '2025-09-01', 180, 'завршено');
INSERT INTO synergymed.payment VALUES (12, 1, 2, '2025-09-01', 240, 'завршено');
INSERT INTO synergymed.payment VALUES (13, 1, 2, '2025-09-01', 180, 'завршено');
INSERT INTO synergymed.payment VALUES (14, 1, 2, '2025-09-03', 1030, 'завршено');
INSERT INTO synergymed.payment VALUES (15, 1, 2, '2025-09-03', 1090, 'завршено');
INSERT INTO synergymed.payment VALUES (16, 1, 2, '2025-09-03', 4176, 'завршено');
INSERT INTO synergymed.payment VALUES (17, 1, 1, '2025-09-03', 162, 'завршено');
INSERT INTO synergymed.payment VALUES (18, 1, 2, '2025-09-03', 1612, 'завршено');
INSERT INTO synergymed.payment VALUES (21, 1, 2, '2025-09-03', 100, 'завршено');
INSERT INTO synergymed.payment VALUES (22, 1, 2, '2025-09-03', 2440, 'завршено');
INSERT INTO synergymed.payment VALUES (25, 1, 2, '2025-09-04', 0, 'завршено');
INSERT INTO synergymed.payment VALUES (26, 1, 2, '2025-09-04', 300, 'завршено');
INSERT INTO synergymed.payment VALUES (27, 1, 2, '2025-09-04', 430, 'завршено');
INSERT INTO synergymed.payment VALUES (28, 1, 2, '2025-09-04', 444, 'завршено');
INSERT INTO synergymed.payment VALUES (29, 1, 2, '2025-09-13', 398, 'завршено');


INSERT INTO synergymed.clientorder VALUES (1, 1, 4, 1, '2025-02-01', '2025-02-03', 'испорачана', 420);
INSERT INTO synergymed.clientorder VALUES (2, 2, 4, 2, '2025-03-14', '2025-03-16', 'испорачана', 250);
INSERT INTO synergymed.clientorder VALUES (3, 4, 4, 3, '2025-05-08', '2025-05-10', 'во тек', 360);
INSERT INTO synergymed.clientorder VALUES (10, 1, 4, 10, '2025-09-01', '2025-09-08', 'во тек', 960);
INSERT INTO synergymed.clientorder VALUES (11, 1, 4, 11, '2025-09-01', '2025-09-08', 'во тек', 180);
INSERT INTO synergymed.clientorder VALUES (12, 1, 4, 12, '2025-09-01', '2025-09-08', 'во тек', 240);
INSERT INTO synergymed.clientorder VALUES (13, 1, 4, 13, '2025-09-01', '2025-09-08', 'во тек', 180);
INSERT INTO synergymed.clientorder VALUES (14, 1, 4, 14, '2025-09-03', '2025-09-10', 'во тек', 1030);
INSERT INTO synergymed.clientorder VALUES (15, 1, 4, 15, '2025-09-03', '2025-09-10', 'во тек', 1090);
INSERT INTO synergymed.clientorder VALUES (16, 1, 4, 16, '2025-09-03', '2025-09-10', 'во тек', 4176);
INSERT INTO synergymed.clientorder VALUES (17, 1, 4, 17, '2025-09-03', '2025-09-10', 'во тек', 162);
INSERT INTO synergymed.clientorder VALUES (18, 1, 4, 18, '2025-09-03', '2025-09-10', 'во тек', 1612);
INSERT INTO synergymed.clientorder VALUES (21, 1, 4, 21, '2025-09-03', '2025-09-10', 'во тек', 100);
INSERT INTO synergymed.clientorder VALUES (22, 1, 4, 22, '2025-09-03', '2025-09-10', 'во тек', 2440);
INSERT INTO synergymed.clientorder VALUES (25, 1, 4, 25, '2025-09-04', '2025-09-11', 'во тек', 0);
INSERT INTO synergymed.clientorder VALUES (26, 1, 4, 26, '2025-09-04', '2025-09-11', 'во тек', 300);
INSERT INTO synergymed.clientorder VALUES (27, 1, 4, 27, '2025-09-04', '2025-09-11', 'во тек', 430);
INSERT INTO synergymed.clientorder VALUES (28, 1, 4, 28, '2025-09-04', '2025-09-11', 'во тек', 444);
INSERT INTO synergymed.clientorder VALUES (29, 1, 4, 29, '2025-09-13', '2025-09-20', 'во тек', 398);


INSERT INTO synergymed.clientorder_brandedmedicine VALUES (1, 1, 2);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (1, 2, 1);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (2, 4, 1);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (3, 3, 1);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (10, 3, 1);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (10, 2, 2);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (10, 1, 2);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (11, 1, 1);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (12, 1, 1);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (12, 2, 1);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (13, 2, 2);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (14, 3, 3);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (15, 2, 1);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (15, 4, 1);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (15, 3, 1);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (15, 1, 2);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (16, 4, 3);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (16, 2, 5);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (16, 3, 6);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (16, 1, 4);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (17, 2, 1);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (17, 4, 1);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (18, 2, 6);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (18, 1, 5);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (21, 1, 1);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (22, 3, 4);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (22, 4, 4);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (25, 2, 1);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (26, 2, 1);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (26, 1, 1);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (27, 4, 1);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (27, 1, 1);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (28, 2, 1);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (28, 1, 2);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (29, 2, 2);
INSERT INTO synergymed.clientorder_brandedmedicine VALUES (29, 1, 1);


INSERT INTO synergymed.clubcard VALUES (1, 1, 'Зегин Basic', 39);
INSERT INTO synergymed.clubcard VALUES (2, 2, 'Зегин Beonze', 90);
INSERT INTO synergymed.clubcard VALUES (3, 4, 'Зегин Silver', 45);


INSERT INTO synergymed.facility VALUES (1, 3, 'Зегин Буњаковец', 'ZEG-BUNJAKOVEC');
INSERT INTO synergymed.facility VALUES (2, 3, 'Зегин Аеродром', 'ZEG-AERODROM');
INSERT INTO synergymed.facility VALUES (3, 3, 'Зегин Чаир', 'ZEG-CHAIR');
INSERT INTO synergymed.facility VALUES (4, 1, 'Алкалоид Производствен Комплекс', 'ALK-PROD-1');
INSERT INTO synergymed.facility VALUES (5, 1, 'Алкалоид Централен Магацин', 'ALK-WH-1');
INSERT INTO synergymed.facility VALUES (6, 2, 'Реплек Производство Козле', 'REP-KOZLE');
INSERT INTO synergymed.facility VALUES (7, 2, 'Реплек Дистрибуција', 'REP-DIST-1');
INSERT INTO synergymed.facility VALUES (8, 4, 'ЕЛС Логистички Центар', 'ELS-LOG-1');


INSERT INTO synergymed.contactinformation VALUES (1, '02/3115-330', 'ул. „Аминта Трети" бр. 22, Центар, 1000 Скопје', NULL, 1);
INSERT INTO synergymed.contactinformation VALUES (2, '02/2458-650', 'бул. „Србија" бр. 12, Аеродром, 1000 Скопје', NULL, 2);
INSERT INTO synergymed.contactinformation VALUES (3, '02/2620-777', 'бул. „Џон Кенеди" бр. 25, Чаир, 1000 Скопје', NULL, 3);
INSERT INTO synergymed.contactinformation VALUES (4, '02/3104-000', 'бул. „Александар Македонски" бр. 12, 1000 Скопје', NULL, 4);
INSERT INTO synergymed.contactinformation VALUES (5, '02/3104-014', 'ул. „16-та Македонска Бригада" бр. 18, 1000 Скопје', NULL, 5);
INSERT INTO synergymed.contactinformation VALUES (6, '02/3099-200', 'ул. „Козле" бр. 188, Карпош, 1000 Скопје', NULL, 6);
INSERT INTO synergymed.contactinformation VALUES (7, '02/3099-250', 'ул. „Илинденска" бр. 2А, Карпош, 1000 Скопје', NULL, 7);
INSERT INTO synergymed.contactinformation VALUES (8, '13 990', 'ул. „Киро Глигоров" бр. 1, 1000 Скопје', NULL, 8);
INSERT INTO synergymed.contactinformation VALUES (10, '071/335-778', 'бул. „Св. Климент Охридски" бр. 54, Центар, 1000 Скопје', 2, NULL);
INSERT INTO synergymed.contactinformation VALUES (11, '072/990-224', 'ул. „Македонија" бр. 12, Центар, 1000 Скопје', 3, NULL);
INSERT INTO synergymed.contactinformation VALUES (12, '075/640-113', 'бул. „Јане Сандански" бр. 98, Аеродром, 1000 Скопје', 4, NULL);
INSERT INTO synergymed.contactinformation VALUES (13, '076/521-740', 'ул. „Методија Шаторов-Шарло" бр. 14, Кисела Вода, 1000 Скопје', 5, NULL);
INSERT INTO synergymed.contactinformation VALUES (14, '077/884-209', 'бул. „Партизански Одреди" бр. 73, Карпош, 1000 Скопје', 6, NULL);
INSERT INTO synergymed.contactinformation VALUES (17, '+389 078 236 371', 'ул. „Орце Николов" бр. 45, Центар, 1000 Куманово', 1, NULL);
INSERT INTO synergymed.contactinformation VALUES (26, '+38978326371', 'ул. „Орце Николов" бр. 45, Центар, 1000 Куманово', 7, NULL);


INSERT INTO synergymed.distributor VALUES (1);
INSERT INTO synergymed.distributor VALUES (2);


INSERT INTO synergymed.distributor_brandedmedicine VALUES (1, 1);
INSERT INTO synergymed.distributor_brandedmedicine VALUES (2, 2);
INSERT INTO synergymed.distributor_brandedmedicine VALUES (2, 3);
INSERT INTO synergymed.distributor_brandedmedicine VALUES (2, 4);


INSERT INTO synergymed.inventory VALUES (1, 1);
INSERT INTO synergymed.inventory VALUES (2, 2);
INSERT INTO synergymed.inventory VALUES (3, 3);
INSERT INTO synergymed.inventory VALUES (4, 4);
INSERT INTO synergymed.inventory VALUES (5, 5);
INSERT INTO synergymed.inventory VALUES (6, 6);
INSERT INTO synergymed.inventory VALUES (7, 7);
INSERT INTO synergymed.inventory VALUES (8, 8);


INSERT INTO synergymed.inventory_brandedmedicine VALUES (1, 1, 110, '2025-09-15');
INSERT INTO synergymed.inventory_brandedmedicine VALUES (1, 2, 176, '2025-09-15');
INSERT INTO synergymed.inventory_brandedmedicine VALUES (1, 3, 25, '2025-09-15');
INSERT INTO synergymed.inventory_brandedmedicine VALUES (1, 4, 4, '2025-09-15');
INSERT INTO synergymed.inventory_brandedmedicine VALUES (2, 2, 16, '2025-09-15');
INSERT INTO synergymed.inventory_brandedmedicine VALUES (2, 3, 63, '2025-09-15');
INSERT INTO synergymed.inventory_brandedmedicine VALUES (2, 4, 76, '2025-09-15');
INSERT INTO synergymed.inventory_brandedmedicine VALUES (3, 1, 110, '2025-09-15');
INSERT INTO synergymed.inventory_brandedmedicine VALUES (3, 2, 150, '2025-09-15');
INSERT INTO synergymed.inventory_brandedmedicine VALUES (4, 1, 5000, '2025-09-15');
INSERT INTO synergymed.inventory_brandedmedicine VALUES (5, 1, 8000, '2025-09-15');
INSERT INTO synergymed.inventory_brandedmedicine VALUES (6, 2, 7000, '2025-09-15');
INSERT INTO synergymed.inventory_brandedmedicine VALUES (6, 3, 4000, '2025-09-15');
INSERT INTO synergymed.inventory_brandedmedicine VALUES (6, 4, 2500, '2025-09-15');
INSERT INTO synergymed.inventory_brandedmedicine VALUES (7, 3, 5000, '2025-09-15');
INSERT INTO synergymed.inventory_brandedmedicine VALUES (7, 4, 3000, '2025-09-15');
INSERT INTO synergymed.inventory_brandedmedicine VALUES (7, 2, 8999, '2025-09-15');
INSERT INTO synergymed.inventory_brandedmedicine VALUES (8, 2, 300, '2025-09-15');
INSERT INTO synergymed.inventory_brandedmedicine VALUES (8, 3, 150, '2025-09-15');


INSERT INTO synergymed.medicineinteraction VALUES (1, 3, 'фармакодинамичка', 'Кофеинот може да ја потенцира аналгезијата на парацетамол и да ја забрза апсорпцијата; следење за несоница/нервоза.', 'ниска');
INSERT INTO synergymed.medicineinteraction VALUES (1, 4, 'фармакодинамичка', 'Комбинацијата ја засилува аналгезијата во споредба со парацетамол самостојно; очекувана е поспаност и запек.', 'ниска');
INSERT INTO synergymed.medicineinteraction VALUES (1, 5, 'фармакодинамичка', 'Адитивен аналгетски ефект при акутна болка; почитувајте максимални дози и интервали; минимален PK ефект.', 'ниска');
INSERT INTO synergymed.medicineinteraction VALUES (2, 3, 'фармакодинамичка', 'Кофеинот ја зголемува антиноцицептивната ефикасност на пропифеназон без значаен PK ефект.', 'ниска');
INSERT INTO synergymed.medicineinteraction VALUES (2, 5, 'фармакодинамичка', 'Комбинирање два НСАИЛ го зголемува ризикот за ГИ несакани ефекти/крварење; избегнувајте хронична ко-употреба.', 'умерена');
INSERT INTO synergymed.medicineinteraction VALUES (3, 4, 'фармакодинамичка', 'Потенцијално скромно подобрување на аналгезијата со кофеинот како адјуванс; следете за нервоза и тахикардија.', 'ниска');


INSERT INTO synergymed.pharmacist VALUES (7);
INSERT INTO synergymed.pharmacist VALUES (8);


INSERT INTO synergymed.pharmacy VALUES (3);


INSERT INTO synergymed.pharmacy_catalog VALUES (3, 1);
INSERT INTO synergymed.pharmacy_catalog VALUES (3, 2);
INSERT INTO synergymed.pharmacy_catalog VALUES (3, 3);
INSERT INTO synergymed.pharmacy_catalog VALUES (3, 4);


INSERT INTO synergymed.prescription VALUES (1, 1, 5, 'Д-р Петар Наумов', '2025-02-01', '2025-05-01', '1403990411230');
INSERT INTO synergymed.prescription VALUES (2, 2, 7, 'Д-р Весна Спасова', '2025-03-12', '2025-04-30', '2307992616231');
INSERT INTO synergymed.prescription VALUES (3, 4, 6, 'Д-р Александар Глигоров', '2025-05-07', '2025-08-07', '2901950415232');


INSERT INTO synergymed.sensitiveclientdata VALUES (1, 1, 7, '1403990411230', '/uploads/images/portraits/portrait_2_77a593bd-e156-415d-9571-c8f4a48183b1.png', 'верифицирано');
INSERT INTO synergymed.sensitiveclientdata VALUES (4, 4, 8, '2901950415232', '/uploads/images/portrait/portrait_15_e43ffa39-7d9f-49a1-9869-5c573661234d.png', 'oдбиено');
INSERT INTO synergymed.sensitiveclientdata VALUES (6, 6, 8, '0804932616236', '/uploads/images/portrait/portrait_16_9e22ab3b-5ef6-4c56-bdb0-df0e0bc92b02.png', 'верифицирано');


INSERT INTO synergymed.shoppingcart VALUES (1, 1);
INSERT INTO synergymed.shoppingcart VALUES (2, 2);
INSERT INTO synergymed.shoppingcart VALUES (3, 3);
INSERT INTO synergymed.shoppingcart VALUES (4, 4);
INSERT INTO synergymed.shoppingcart VALUES (5, 5);
INSERT INTO synergymed.shoppingcart VALUES (6, 6);


INSERT INTO synergymed.shoppingcart_brandedmedicine VALUES (1, 3, 1);
INSERT INTO synergymed.shoppingcart_brandedmedicine VALUES (3, 2, 1);
INSERT INTO synergymed.shoppingcart_brandedmedicine VALUES (4, 3, 1);
INSERT INTO synergymed.shoppingcart_brandedmedicine VALUES (5, 1, 2);
INSERT INTO synergymed.shoppingcart_brandedmedicine VALUES (6, 2, 1);


INSERT INTO synergymed.supplyorder VALUES (1, 2, 3, '2025-09-03', '2025-09-10', 'во тек', 1);
INSERT INTO synergymed.supplyorder VALUES (2, 1, 3, '2025-09-03', '2025-09-10', 'во тек', 3);
INSERT INTO synergymed.supplyorder VALUES (3, 2, 3, '2025-09-03', '2025-09-10', 'во тек', 1);
INSERT INTO synergymed.supplyorder VALUES (4, 2, 3, '2025-09-04', '2025-09-11', 'во тек', 2);
INSERT INTO synergymed.supplyorder VALUES (5, 2, 3, '2025-09-04', '2025-09-11', 'во тек', 2);
INSERT INTO synergymed.supplyorder VALUES (6, 2, 3, '2025-09-13', '2025-09-20', 'во тек', 2);


INSERT INTO synergymed.supplyorder_brandedmedicine VALUES (1, 2, 5);
INSERT INTO synergymed.supplyorder_brandedmedicine VALUES (1, 3, 5);
INSERT INTO synergymed.supplyorder_brandedmedicine VALUES (1, 4, 4);
INSERT INTO synergymed.supplyorder_brandedmedicine VALUES (2, 1, 50);
INSERT INTO synergymed.supplyorder_brandedmedicine VALUES (3, 3, 20);
INSERT INTO synergymed.supplyorder_brandedmedicine VALUES (4, 2, 1);
INSERT INTO synergymed.supplyorder_brandedmedicine VALUES (5, 2, 5);
INSERT INTO synergymed.supplyorder_brandedmedicine VALUES (5, 4, 10);
INSERT INTO synergymed.supplyorder_brandedmedicine VALUES (6, 2, 10);
INSERT INTO synergymed.supplyorder_brandedmedicine VALUES (6, 4, 30);
