Index: avtori_202609281557.sql
===================================================================
--- avtori_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
+++ avtori_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
@@ -0,0 +1,9 @@
+INSERT INTO project.avtori (ime,prezime,biografija) VALUES
+	 ('James','Clear','Avtor poznat po dela za naviki i licen razvoj.'),
+	 ('Paulo','Coelho','Brazilski pisatel i romanopisec.'),
+	 ('Hector','Garcia','Avtor i istrazuvac na japonskata kultura.'),
+	 ('Cal','Newport','Avtor na dela za produktivnost i fokus.'),
+	 ('Eckhart','Tolle','Avtor na dela za licen razvoj.'),
+	 ('Carol','Dweck','Psiholog i avtor na dela za nacinot na razmisluvanje.'),
+	 ('Antoine','de Saint-Exupery','Francuski pisatel i avijaticar.'),
+	 ('Napoleon','Hill','Avtor na dela za motivacija i uspeh.');
Index: ima_kategorija_202609281557.sql
===================================================================
--- ima_kategorija_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
+++ ima_kategorija_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
@@ -0,0 +1,9 @@
+INSERT INTO project.ima_kategorija (kniga_id,kategorija_id) VALUES
+	 (1,2),
+	 (2,3),
+	 (3,2),
+	 (4,4),
+	 (5,5),
+	 (6,2),
+	 (7,3),
+	 (8,1);
Index: ima_zhanr_202609281557.sql
===================================================================
--- ima_zhanr_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
+++ ima_zhanr_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
@@ -0,0 +1,15 @@
+INSERT INTO project.ima_zhanr (kniga_id,zhanr_id) VALUES
+	 (1,1),
+	 (1,2),
+	 (2,3),
+	 (2,5),
+	 (3,1),
+	 (3,5),
+	 (4,4),
+	 (5,1),
+	 (5,5),
+	 (6,1);
+INSERT INTO project.ima_zhanr (kniga_id,zhanr_id) VALUES
+	 (6,2),
+	 (7,3),
+	 (8,1);
Index: izbira_raspolozenie_202609281557.sql
===================================================================
--- izbira_raspolozenie_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
+++ izbira_raspolozenie_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
@@ -0,0 +1,7 @@
+INSERT INTO project.izbira_raspolozenie (korisnik_id,raspolozenie_id,datum_izbor) VALUES
+	 (1,1,'2026-04-01'),
+	 (1,5,'2026-04-08'),
+	 (2,4,'2026-05-10'),
+	 (2,3,'2026-05-12'),
+	 (3,2,'2026-06-15'),
+	 (3,3,'2026-06-18');
Index: kategorii_202609281557.sql
===================================================================
--- kategorii_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
+++ kategorii_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
@@ -0,0 +1,7 @@
+INSERT INTO project.kategorii (naziv,opis) VALUES
+	 ('Мотивација','Книги што мотивираат и инспирираат.'),
+	 ('Самопомош','Книги за подобрување на секојдневниот живот.'),
+	 ('Фикција','Книжевни и фикционални дела.'),
+	 ('Кариера','Книги за професионален развој.'),
+	 ('Mindfulness','Книги за смиреност и свесност.'),
+	 ('Едукација','Книги за учење, стекнување знаење и развој на нови вештини.');
Index: knigi_202609281557.sql
===================================================================
--- knigi_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
+++ knigi_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
@@ -0,0 +1,9 @@
+INSERT INTO project.knigi (naslov,isbn,opis,korica_url,godina_izdavanje,kolicina_na_zaliha,cena) VALUES
+	 ('Ikigai','9780143130727','Книга за пронаоѓање смисла, рамнотежа и задоволство во секојдневниот живот.','ikigai.jpg',2016,9,750.00),
+	 ('The Alchemist','9780061122415','Инспиративна приказна за следење на соништата и пронаоѓање на сопствениот пат.','the_alchemist.jpg',1988,15,650.00),
+	 ('The Power of Now','9781577314806','Книга за присутност, внатрешен мир и живеење во сегашниот момент.','power_of_now.jpg',1997,18,700.00),
+	 ('Mindset','9780345472328','Книга за личен развој, начинот на размислување и постигнување на целите.','mindset.jpg',2006,14,800.00),
+	 ('The Little Prince','9780156012195','Приказна за пријателството, љубовта и важните вредности во животот.','little_prince.jpg',1943,25,500.00),
+	 ('Deep Work','9781455586691','Книга за подобрување на фокусот, концентрацијата и продуктивноста.','deep_work.jpg',2016,7,850.00),
+	 ('Think and Grow Rich','9781585424337','Книга за мотивација, личен развој и остварување на поставените цели.','think_grow_rich.jpg',1937,10,720.00),
+	 ('Atomic Habits','9780735211292','Книга за градење добри навики и подобрување на секојдневниот живот.','atomic_habits.jpg',2018,12,950.00);
Index: korisnici_202609281557.sql
===================================================================
--- korisnici_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
+++ korisnici_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
@@ -0,0 +1,9 @@
+INSERT INTO project.korisnici (ime,prezime,email,lozinka,datum_registracija,uloga) VALUES
+	 ('Ana','Petrovska','ana.petrovska@email.com','ana123','2026-01-10','KORISNIK'),
+	 ('Marko','Stojanov','marko.stojanov@email.com','marko123','2026-02-05','KORISNIK'),
+	 ('Elena','Nikolovska','elena.nikolovska@email.com','elena123','2026-03-12','KORISNIK'),
+	 ('Ana','Petrovska','novkorisnik@example.com','lozinka123','2026-09-20','KORISNIK'),
+	 ('Ана','Петровска','ana.petrovska@bibliopremium.mk','ana123','2026-09-23','KUPUVAC'),
+	 ('Марко','Стојанов','marko.stojanov@bibliopremium.mk','marko123','2026-09-23','KUPUVAC'),
+	 ('Test','Korisnik','test@bibliopremium.mk','test123','2026-09-24','KUPUVAC'),
+	 ('Admin','BiblioPremium','admin@bibliopremium.mk','admin123','2026-01-01','ADMIN');
Index: napisana_od_202609281557.sql
===================================================================
--- napisana_od_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
+++ napisana_od_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
@@ -0,0 +1,9 @@
+INSERT INTO project.napisana_od (kniga_id,avtor_id) VALUES
+	 (1,1),
+	 (2,2),
+	 (3,3),
+	 (4,4),
+	 (5,5),
+	 (6,6),
+	 (7,7),
+	 (8,8);
Index: naracki_202609281557.sql
===================================================================
--- naracki_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
+++ naracki_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
@@ -0,0 +1,21 @@
+INSERT INTO project.naracki (datum,status,vkupna_cena,korisnik_id) VALUES
+	 ('2026-04-10 00:00:00','ZAVRSENA',1600.00,1),
+	 ('2026-05-15 00:00:00','ZAVRSENA',850.00,2),
+	 ('2026-06-20 00:00:00','ZAVRSENA',1450.00,3),
+	 ('2026-09-20 15:46:29.403716','VO_OBRABOTKA',950.00,1),
+	 ('2026-09-23 18:05:45.350326','ZAVRSENA',950.00,1),
+	 ('2026-09-23 18:31:06.453275','ZAVRSENA',950.00,1),
+	 ('2026-09-23 18:50:53.532264','ZAVRSENA',650.00,6),
+	 ('2026-09-23 18:50:55.447637','ZAVRSENA',650.00,6),
+	 ('2026-09-23 19:09:30.964582','ZAVRSENA',850.00,7),
+	 ('2026-09-24 02:20:26.086699','ZAVRSENA',950.00,8);
+INSERT INTO project.naracki (datum,status,vkupna_cena,korisnik_id) VALUES
+	 ('2026-09-24 17:01:12.467054','ZAVRSENA',950.00,8),
+	 ('2026-09-24 17:18:30.756789','ZAVRSENA',1900.00,8),
+	 ('2026-09-25 01:25:18.83748','ZAVRSENA',1700.00,8),
+	 ('2026-07-05 00:00:00','ZAVRSENA',720.00,1),
+	 ('2026-09-25 05:14:00.112206','ZAVRSENA',750.00,8),
+	 ('2026-09-25 14:21:46.53375','ZAVRSENA',950.00,8),
+	 ('2026-09-25 14:22:02.883371','ZAVRSENA',950.00,8),
+	 ('2026-09-25 14:22:22.783847','ZAVRSENA',750.00,8),
+	 ('2026-09-25 14:22:53.843643','ZAVRSENA',750.00,8);
Index: omileni_202609281557.sql
===================================================================
--- omileni_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
+++ omileni_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
@@ -0,0 +1,8 @@
+INSERT INTO project.omileni (korisnik_id,kniga_id,datum_dodavanje) VALUES
+	 (2,4,'2026-04-02'),
+	 (2,8,'2026-04-10'),
+	 (3,2,'2026-05-01'),
+	 (3,3,'2026-05-05'),
+	 (6,3,'2026-09-23'),
+	 (7,7,'2026-09-23'),
+	 (8,1,'2026-09-25');
Index: plakanja_202609281557.sql
===================================================================
--- plakanja_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
+++ plakanja_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
@@ -0,0 +1,21 @@
+INSERT INTO project.plakanja (datum,iznos,nacin_na_plakjanje,status,naracka_id) VALUES
+	 ('2026-04-10 00:00:00',1600.00,'KARTICKA','USPESNO',1),
+	 ('2026-05-15 00:00:00',850.00,'KARTICKA','USPESNO',2),
+	 ('2026-06-20 00:00:00',1450.00,'KARTICKA','USPESNO',3),
+	 ('2026-07-05 00:00:00',720.00,'KARTICKA','VO_OBRABOTKA',4),
+	 ('2026-09-20 15:49:29.654475',950.00,'KARTICKA','USPESNO',5),
+	 ('2026-09-23 18:05:45.350326',950.00,'KARTICKA','USPESNO',7),
+	 ('2026-09-23 18:31:06.453275',950.00,'KARTICKA','USPESNO',8),
+	 ('2026-09-23 18:50:53.532264',650.00,'KARTICKA','USPESNO',9),
+	 ('2026-09-23 18:50:55.447637',650.00,'KARTICKA','USPESNO',10),
+	 ('2026-09-23 19:09:30.964582',850.00,'KARTICKA','USPESNO',11);
+INSERT INTO project.plakanja (datum,iznos,nacin_na_plakjanje,status,naracka_id) VALUES
+	 ('2026-09-24 02:20:26.086699',950.00,'KARTICKA','USPESNO',12),
+	 ('2026-09-24 17:01:12.467054',950.00,'KARTICKA','USPESNO',13),
+	 ('2026-09-24 17:18:30.756789',1900.00,'KARTICKA','USPESNO',14),
+	 ('2026-09-25 01:25:18.83748',1700.00,'KARTICKA','USPESNO',15),
+	 ('2026-09-25 05:14:00.112206',750.00,'KARTICKA','USPESNO',16),
+	 ('2026-09-25 14:21:46.53375',950.00,'KARTICKA','USPESNO',17),
+	 ('2026-09-25 14:22:02.883371',950.00,'KARTICKA','USPESNO',18),
+	 ('2026-09-25 14:22:22.783847',750.00,'KARTICKA','USPESNO',19),
+	 ('2026-09-25 14:22:53.843643',750.00,'KARTICKA','USPESNO',20);
Index: povrzana_so_202609281557.sql
===================================================================
--- povrzana_so_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
+++ povrzana_so_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
@@ -0,0 +1,17 @@
+INSERT INTO project.povrzana_so (kniga_id,raspolozenie_id) VALUES
+	 (1,1),
+	 (1,5),
+	 (2,2),
+	 (2,3),
+	 (3,2),
+	 (3,5),
+	 (4,4),
+	 (5,2),
+	 (5,5),
+	 (6,1);
+INSERT INTO project.povrzana_so (kniga_id,raspolozenie_id) VALUES
+	 (6,5),
+	 (7,2),
+	 (7,3),
+	 (8,1),
+	 (8,3);
Index: preferira_kategorija_202609281557.sql
===================================================================
--- preferira_kategorija_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
+++ preferira_kategorija_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
@@ -0,0 +1,9 @@
+INSERT INTO project.preferira_kategorija (korisnik_id,kategorija_id,datum_dodavanje) VALUES
+	 (1,2,'2026-03-10'),
+	 (1,5,'2026-03-10'),
+	 (2,4,'2026-04-01'),
+	 (2,1,'2026-04-01'),
+	 (3,3,'2026-05-01'),
+	 (3,2,'2026-05-01'),
+	 (7,4,'2026-09-24'),
+	 (8,2,'2026-09-25');
Index: preferira_zhanr_202609281557.sql
===================================================================
--- preferira_zhanr_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
+++ preferira_zhanr_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
@@ -0,0 +1,9 @@
+INSERT INTO project.preferira_zhanr (korisnik_id,zhanr_id,datum_dodavanje) VALUES
+	 (1,2,'2026-03-10'),
+	 (2,4,'2026-04-01'),
+	 (2,1,'2026-04-01'),
+	 (3,3,'2026-05-01'),
+	 (3,5,'2026-05-01'),
+	 (1,1,'2026-03-10'),
+	 (7,4,'2026-09-24'),
+	 (8,4,'2026-09-25');
Index: raspolozenija_202609281557.sql
===================================================================
--- raspolozenija_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
+++ raspolozenija_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
@@ -0,0 +1,7 @@
+INSERT INTO project.raspolozenija (naziv,opis) VALUES
+	 ('Мотивација','За моменти кога ти треба мотивација и поттик.'),
+	 ('Релаксација','За моменти кога сакаш да се опуштиш и одмориш.'),
+	 ('Инспирација','За моменти кога бараш инспирација и нови идеи.'),
+	 ('Фокус','За моменти кога сакаш подобар фокус и концентрација.'),
+	 ('Личен развој','За моменти кога сакаш да работиш на себе и личниот развој.'),
+	 ('Енергија','За моменти кога ти треба повеќе енергија, мотивација и позитивен поттик.');
Index: sodrzi_202609281557.sql
===================================================================
--- sodrzi_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
+++ sodrzi_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
@@ -0,0 +1,24 @@
+INSERT INTO project.sodrzi (naracka_id,kniga_id,kolicina,edinechna_cena) VALUES
+	 (1,1,1,950.00),
+	 (1,2,1,650.00),
+	 (2,4,1,850.00),
+	 (3,3,1,750.00),
+	 (3,5,1,700.00),
+	 (4,8,1,720.00),
+	 (5,1,1,950.00),
+	 (7,1,1,950.00),
+	 (8,1,1,950.00),
+	 (9,2,1,650.00);
+INSERT INTO project.sodrzi (naracka_id,kniga_id,kolicina,edinechna_cena) VALUES
+	 (10,2,1,650.00),
+	 (11,4,1,850.00),
+	 (12,1,1,950.00),
+	 (13,1,1,950.00),
+	 (14,1,2,950.00),
+	 (15,4,2,850.00),
+	 (16,3,1,750.00),
+	 (17,1,1,950.00),
+	 (18,1,1,950.00),
+	 (19,3,1,750.00);
+INSERT INTO project.sodrzi (naracka_id,kniga_id,kolicina,edinechna_cena) VALUES
+	 (20,3,1,750.00);
Index: zhanrovi_202609281557.sql
===================================================================
--- zhanrovi_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
+++ zhanrovi_202609281557.sql	(revision 77b90d2ff0992adc0932dce4c9d3fe757bb1d692)
@@ -0,0 +1,7 @@
+INSERT INTO project.zhanrovi (naziv,opis) VALUES
+	 ('Личен развој','Книги наменети за личен напредок.'),
+	 ('Психологија','Книги поврзани со психологија и однесување.'),
+	 ('Роман','Белетристички дела и романи.'),
+	 ('Продуктивност','Книги за подобрување на фокусот и продуктивноста.'),
+	 ('Филозофија','Книги со филозофски и животни теми.'),
+	 ('Биографија','Книги за животот, искуствата и достигнувањата на познати личности.');