data.sql

INSERT INTO user_data(id, username, password)
VALUES(1, 'admin', '$2a$10$v2vDCQIL.iK9cyzs1Kzh3OB7TFvh9c7TS6tdJF.Uqj1Uj2ajHSrBq'); -- pass: 'admin'
INSERT INTO user_data_roles VALUES (1,'ADMIN');

INSERT INTO user_data(id, username, password)
VALUES(2, 'guide', '$2a$10$0nxMnPAz70olLnU1tytF8OhTFLKOHLEUoFsENZESUzow04ZR9cNT.'); -- pass: 'guide'
INSERT INTO user_data_roles VALUES (2,'GUIDE');
INSERT INTO guide_data VALUES (1, 'guidename', 'guidesurname', 2);

INSERT INTO user_data(id, username, password)
VALUES(3, 'user', '$2a$10$PpKEUs9byuNWib8pjaO5mOTRhhzE9XIoNEhlkoh4ameY1UmWWFDkW'); -- pass: 'user'
INSERT INTO user_data_roles VALUES (3,'USER');
INSERT INTO client_data (id, name, surname, passport_number, user_data_id)
VALUES(1, 'John', 'Doe', '2J1DP3K7', 3);

INSERT INTO user_data(id, username, password)
VALUES (4, 'user2', 'user2');
INSERT INTO user_data_roles VALUES (4,'USER');
INSERT INTO client_data (id, name, surname, passport_number, user_data_id)
VALUES(2, 'client1', 'client1', '4J2DP0K', 4);

INSERT INTO user_data(id, username, password)
VALUES (5, 'user3', 'user3');
INSERT INTO user_data_roles VALUES (5,'USER');
INSERT INTO client_data (id, name, surname, passport_number, user_data_id)
VALUES(3, 'client2', 'client2', '4J2DP0K', 5);

INSERT INTO user_data(id, username, password)
VALUES (6, 'user4', 'user4');
INSERT INTO user_data_roles VALUES (6,'USER');
INSERT INTO client_data (id, name, surname, passport_number, user_data_id)
VALUES(4, 'client3', 'client3', '4J2DP0K', 6);

INSERT INTO destination (id, name, description)
VALUES (1,'Warsaw','Very good looking place.');

INSERT INTO destination (id, name, description)
VALUES (2,'Barcelona','Very good looking place too.');

INSERT INTO destination (id, name, description)
VALUES (3,'New York','American place.');

INSERT INTO tour (id, destination_id, guide_id, start_date, end_date, initial_price )
VALUES (1,1,1,'2002-09-09','2022-09-09',1000);

INSERT INTO tour (id, destination_id, guide_id, start_date, end_date, initial_price )
VALUES (2,2,1,'2022-10-10','2022-10-17',1500);

INSERT INTO tour (id, destination_id, guide_id, start_date, end_date, initial_price )
VALUES (3,2,1,'2002-03-15','2022-04-07',1000);

INSERT INTO tour (id, destination_id, guide_id, start_date, end_date, initial_price )
VALUES (4,2,1,'2023-03-15','2024-04-07',1000);

INSERT INTO tour (id, destination_id, guide_id, start_date, end_date, initial_price )
VALUES (5,2,1,'2021-03-15','2021-04-07',1000);

INSERT INTO reservation (id, tour_id, client_id, actual_price)
VALUES (1,1,1,1000);

INSERT INTO reservation (id, tour_id, client_id, actual_price)
VALUES (2,1,1,1000);

INSERT INTO reservation (id, tour_id, client_id, actual_price)
VALUES (3,2,1,1000);

INSERT INTO reservation (id, tour_id, client_id, actual_price)
VALUES (4,4,3,1000);

INSERT INTO reservation (id, tour_id, client_id, actual_price)
VALUES (5,4,3,1000);