RelationalDesign : DML.sql

insert into project.users (username, email, surname, "name", phone_number, "password")
values ('anacvet', 'anastasijacvetkovska@gmail.com', 'Cvetkovska', 'Anastasija', '070000001', 'pass71'),
('viknik', 'viktornikolikj@gmail.com', 'Nikolikj', 'Viktor', '070000002', 'pas5s1'),
('andon', 'anaandonovska@gmail.com', 'Andonovska', 'Ana', '070000003', 'p3ass1'),
('gero5', 'andrejgerasimovikj@gmail.com', 'Gerasimovikj', 'Andrej', '070000004', 'pas2s1'),
('kozar', 'zarkoilievski@gmail.com', 'Ilievski', 'Zarko', '070000005', 'pass21'),
('ivce', 'ivananikolovska@gmail.com', 'Nikolovska', 'Ivana', '070000006', 'pas2s1'),
('milicka#', 'milastojkovska@gmail.com', 'Stojkovska', 'Mila', '070000007', 'pa3ss1'),
('petkoo', 'andrejpetkovikj@gmail.com', 'Petkovikj', 'Andrej', '070000008', 'pas3s1'),
('ris22', 'ivonaristikj@gmail.com', 'Ristikj', 'Ivona', '070000009', 'pas32s1'),
('oki45', 'oliverstevkovikj@gmail.com', 'Stevkovikj', 'Oliver', '070000010', 'pas4s1'),
('damcho', 'damjanstosevski@gmail.com', 'Stosevski', 'Damjan', '070000011', 'pa34ss1'),
('ceca31', 'svetlanastankovikj@gmail.com', 'Stankovikj', 'Svetlana', '070000012', 'pass1342'),
('sneze', 'snezanamilanovska@gmail.com', 'Milanovska', 'Snezana', '070000013', 'pass13r3');



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.users (username, email, surname, "name", phone_number, "password")
values
('mina1', 'minatr@yahoo.com', 'Trnova', 'Mina', '072032028', 'pas32sword28'),
('renat4', 'renir4@yahoo.com', 'Ristovska', 'Renata', '072240029', 'passw42ord29'),
('ina1', 'inatr@yahoo.com', 'Trnova', 'Ina', '072000028', 'password28'),
('renata34', 'renir@yahoo.com', 'Ristovska', 'Renata', '072000029', 'password29'),
('kole', 'kolevpetar@yahoo.com', 'Kolev', 'Petar', '072000030', 'password30'),
('met009', 'metod@yahoo.com', 'Veleski', 'Meto', '072000031', 'password31'),
('aleksandra', 'aleksandrad@yahoo.com', 'Dodeva', 'Aleksandra', '072000032', 'password32'),
('zarko', 'zareg@yahoo.com', 'Gelev', 'Zarko', '072000033', 'password33'),
('milena', 'smilnea@yahoo.com', 'Stojanovska', 'Milena', '072000034', 'password34'),
('Kristof', 'kriss@yahoo.com', 'Stojcevski', 'Kristofer', '072000035', 'password35'),
('galina', 'mtgalina@yahoo.com', 'Mitrovska', 'Galina', '072000036', 'password36'),
('daniela', 'daniC@yahoo.com', 'Cekovska', 'Daniela', '072000037', 'password37'),
('jana772', 'jana772@yahoo.com', 'Toshevska', 'Jana', '072000038', 'password38'),
('gorjan4', 'gorjanj@yahoo.com', 'Jakimovski', 'Gorjan', '072000039', 'password39'),
('anamare', 'anamarepe@yahoo.com', 'Peshevska', 'AnaMarija', '072000040', 'password40');

insert into project.users (username, email, surname, "name", phone_number, "password")
values
('marija', 'marijaf@yahoo.com', 'Firoska', 'Marija', '072342028', 'pa324rd28'),
('Angelina', 'ange3g@yahoo.com', 'Gerasimova', 'Angelina', '072323029', 'pa5ord29'),
('kole', 'kolevpetar@yahoo.com', 'Kolev', 'Petar', '072000030', 'password30'),
('lukaf7', 'lukaf7@yahoo.com', 'Filipovski', 'Luka', '072050031', 'passsfgord31'),
('anip13', 'anapet9@yahoo.com', 'Petkovska', 'Ana', '072000032', 'password32'),
('stefan23', 'stefi23@yahoo.com', 'Zarevski', 'Stefan', '072033033', 'pa033ord33'),
('tamarce', 'tamarce@yahoo.com', 'Miteva', 'Tamara', '075002034', 'pasfvword34'),
('nikce', 'nikce@yahoo.com', 'Nikolovski', 'Nikola', '072001435', 'pa43rd35'),
('kiki5', 'kiki5@yahoo.com', 'Kristovska', 'Kiki', '072023036', 'kiki5pas'),
('marge', 'Kdmarg@yahoo.com', 'Donevska', 'Marge', '072085337', 'pa68gs37'),
('Tinka', 'klimentinka@yahoo.com', 'Kocareva', 'Klimentina', '072011028', 'pa1sword281'),
('bilja', 'bilce@yahoo.com', 'Boshevska', 'Biljana', '072033329', 'pa33d29');


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);