



insert into project.admins (id_user)
values (1),
(2),
(13);


insert into project.artist (id_user, type_of_artist, id_user_admin)
values (10, 'actor', 1),
(3, 'actress', 1),
(5, 'photographer', 2),
(7, 'artist', 2);


insert into project.customer (id_user, transaction_account)
values (12, '1234567898745612'),
(9, '1111222233334444'),
(7, '5555666677778888'),
(8, '9900110055007700');


insert into project.organizer (id_user)
values (4),
(6),
(11);


insert into project.events ("name", price, city, "date", phone_number, id_user_artist, id_user_organizer)
values ('Raboti za koi ne zboruvame', 750, 'Skopje', '2022-12-03 20:00:00', '070000013', 10, 4),
('Site sme ptici', 500, 'Bitola', '2023-01-30 19:00:00', '070000014', 3, 6),
('Karpino 2022', 450, 'Kumanovo', '2022-12-12 18:00:00', '070000015', 7, 11),
('Boite na Vkusot', 550, 'Ohrid', '2022-11-01 16:00:00', '070000016', 7, 6),
('Zad Kulisite', 450, 'Kriva Palanka', '2022-09-06 12:00:00', '070000017', 5, 4),
('Toronto Express', 600, 'Stip', '2022-12-05 19:00:00', '070000018', 5, 11),
('Zasolniste vo vremeto', 200, 'Veles', '2022-09-16 13:00:00', '070000019', 3, 4),
('Otpornost', 450, 'Kicevo', '2022-08-08 15:00:00', '070000020', 10, 11),
('I jas sum tuka', 350, 'Tetovo', '2022-04-26 16:00:00', '070000021', 10, 6);


insert into project.theatre (id_event, director, genre, duration)
values (1, 'Nela Vitoshevikj', 'Theatre in Education', 60),
(2, 'Slobodan Unkovski', 'Drama', 90),
(6, 'Jordan Simonov', 'Melodrama', 75);


insert into project.museum (id_event, history, department, workshop)
values (3, 'istorijat 3', 'Oddelenie 3', 'rabotilnica 3'),
(7, 'istorijat 2', 'Oddelenie 2', 'rabotilnica 2'),
(9, 'istorijat 1', 'Oddelenie 1', 'rabotilnica 1');


insert into project.gallery (id_event, "style")
values (4, 'Graphic Design'),
(5, 'Fine Art'),
(8, 'Photojournalism');


insert into project.seat (id_event, "number")
values (1, 40),
(2, 36),
(1, 18),
(2, 50),
(1, 44);


insert into project.cart (id_user_customer, total)
values (12, 1500),
(9, 1000),
(7, 900),
(8, 1100);


insert into project.review ("content", rating, created_at, id_user_artist, id_user_customer)
values ('loved it.', 8, '2022-04-30 16:23:43', 10, 12),
('very good.', 9, '2022-07-02 09:47:15', 3, 9),
('great!', 7, '2022-03-19 20:06:53', 5, 7),
('amazing!', 10, '2022-10-22 08:55:12', 7, 8);


insert into project.ticket (price, "date", "location", type_of_event, id_event, id_user_customer, id_seat, id_cart)
values (750, '2022-12-03 20:00:00', 'Skopje', 'Theatre in Education', 1, 12, 1, 1),
(500, '2023-01-30 19:00:00', 'Bitola', 'Drama', 2, 9, 2, 2),
(750, '2022-12-03 20:00:00', 'Skopje', 'Theatre in Education', 1, 7, 3, 3),
(500, '2023-01-30 19:00:00', 'Bitola', 'Drama', 2, 8, 4, 4);


insert into project.transactions (id_user_customer, id_cart, edited_at, "name", created_at)
values (12, 1, '2022-12-01 23:17:32', 'Transaction 1', '2022-12-01 18:35:12'),
(9, 2, '2022-11-30 13:12:15', 'Transaction 2', '2022-11-30 10:55:54'),
(7, 3, '2022-11-29 18:13:36', 'Transaction 3', '2022-11-29 08:03:26'),
(8, 4, '2022-11-26 23:48:02', 'Transaction 4', '2022-11-26 23:41:37');


insert into project.artist_acts_theatre (id_event_theatre, id_user_artist)
values (1, 10),
(2, 3),
(6, 5);


insert into project.artist_exhibits_gallery (id_event_gallery, id_user_artist)
values (4, 7),
(5, 5),
(8, 10);


insert into project.admins (id_user)
values (28),
(29),
(40);


insert into project.artist (id_user, type_of_artist, id_user_admin)
values (30, 'actor', 28),
(37, 'actress', 29),
(32, 'photographer', 40),
(34, 'artist', 40);


insert into project.customer (id_user, transaction_account)
values (39, '1234967998745992'),
(36, '1111299233334994'),
(34, '5555669999778888'),
(35, '4400110056507700');


insert into project.organizer (id_user)
values (31),
(33),
(38);


insert into project.events ("name", price, city, "date", phone_number, id_user_artist, id_user_organizer)
values ('Avanturite na Molier', 500, 'Kriva Palanka', '2023-08-03 20:00:00', '070000213', 37, 31),
('Samo glas', 600, 'Kumanovo', '2023-07-30 19:00:00', '070000214', 30, 33),
('Biletarnica', 300, 'Kavadarci', '2023-08-12 18:00:00', '070000215', 34, 38),
('Makbet', 350, 'Demir Kapija', '2023-08-01 16:00:00', '070002116', 34, 33),
('Galeb', 700, 'Resen', '2023-09-06 12:00:00', '070000217', 32, 31),
('Duh', 400, 'Delchevo', '2023-09-05 19:00:00', '070000218', 32, 38),
('Najkratkite drami', 250, 'Valandovo', '2023-09-16 13:00:00', '070000219', 30, 31),
('Gorclivi solzi', 750, 'Radovish', '2023-09-08 15:00:00', '070000220', 37, 38),
('Staklena kukja', 500, 'Makedonski Brod', '2023-07-26 16:00:00', '070000221', 24, 33);


insert into project.theatre (id_event, director, genre, duration)
values (19, 'Goran Mihajlo', 'Drama', 85),
(20, 'Vesna Smilkov', 'Melodrama', 60),
(24, 'Andrea Petru', 'Theatre in Education', 30);


insert into project.museum (id_event, history, department, workshop)
values (21, 'istorijat 9', 'Oddelenie 9', 'rabotilnica 9'),
(27, 'istorijat 8', 'Oddelenie 8', 'rabotilnica 8'),
(26, 'istorijat 7', 'Oddelenie 7', 'rabotilnica 7');


insert into project.gallery (id_event, "style")
values (22, 'Fine Art'),
(23, 'Graphic Design'),
(25, 'Photojournalism');


insert into project.seat (id_event, "number")
values (19,  28),
(20,  31),
(19, 17),
(20, 12),
(19,  42);


insert into project.cart (id_user_customer, total)
values (39, 1500),
(36, 2400),
(34, 2000),
(35, 1200);


insert into project.review ("content", rating, created_at, id_user_artist, id_user_customer)
values ('I really liked it!', 9, '2023-01-30 14:23:43', 37, 39),
('it was amazing.', 8, '2023-02-02 19:47:15', 30, 36),
('great!', 10, '2023-01-19 22:06:53', 32, 34),
('very nice.', 7, '2023-02-22 18:55:12', 34, 35);


insert into project.ticket (price, "date", "location", type_of_event, id_event, id_user_customer, id_cart)
values (500, '2023-08-03 20:00:00', 'Kriva Palanka', 'Drama', 19, 39, 5),
(600, '2023-07-30 19:00:00', 'Kumanovo', 'Melodrama', 20, 36, 6),
(500, '2023-08-03 20:00:00', 'Kriva Palanka', 'Drama', 19, 34, 7),
(600, '2023-07-30 19:00:00', 'Kumanovo', 'Melodrama', 20, 35, 8);


insert into project.transactions (id_user_customer, id_cart, edited_at, "name", created_at)
values (39, 5, '2023-03-22 13:14:42', 'Transaction 10', '2023-03-21 13:14:42'),
(36, 6, '2023-03-27 16:16:14', 'Transaction 11', '2023-03-26 16:16:14'),
(34, 7, '2023-04-24 10:15:26', 'Transaction 12', '2023-04-23 10:15:2'),
(35, 8, '2023-04-12 20:28:32', 'Transaction 13', '2023-04-11 20:28:32');


insert into project.artist_acts_theatre (id_event_theatre, id_user_artist)
values (19, 37),
(20, 30),
(24, 31);


insert into project.artist_exhibits_gallery (id_event_gallery, id_user_artist)
values (22, 34),
(23, 32),
(25, 37);