| 1 | insert into business_type (id, created, modified, name)
|
|---|
| 2 | values (1, current_timestamp, current_timestamp, 'tailor'),
|
|---|
| 3 | (2, current_timestamp, current_timestamp, 'nail technician'),
|
|---|
| 4 | (3, current_timestamp, current_timestamp, 'masseuse'),
|
|---|
| 5 | (4, current_timestamp, current_timestamp, 'makeup artist'),
|
|---|
| 6 | (5, current_timestamp, current_timestamp, 'hairdresser'),
|
|---|
| 7 | (6, current_timestamp, current_timestamp, 'barber');
|
|---|
| 8 |
|
|---|
| 9 | insert into service_type (id, created, modified, name, business_type_id)
|
|---|
| 10 | values (nextval('hibernate_sequence'), current_timestamp, current_timestamp, 'haircut', 5),
|
|---|
| 11 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, 'beard shaving', 6),
|
|---|
| 12 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, 'eye brow plucking', 6),
|
|---|
| 13 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, 'waxing', 6),
|
|---|
| 14 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, 'nail extensions', 2),
|
|---|
| 15 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, 'dress sewing', 1),
|
|---|
| 16 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, 'pants shortening', 1);
|
|---|
| 17 |
|
|---|
| 18 | insert into stakeholder (id, created, phone_number, email, first_name, last_name, modified, password, stakeholder_type, username)
|
|---|
| 19 | values (nextval('hibernate_sequence'), current_timestamp, '075658123', 'admin@schedlr.com', 'admin', 'admin', current_timestamp, '$2a$10$DJyjt.Vj/U8MEuYX1PXL9ukQSMwXHVdhre3POlTqpYzNxHB5gu/MW','ADMIN', 'admin'),
|
|---|
| 20 | (50000, current_timestamp, '071658125', 'monika_taseva@outlook.com', 'Monika', 'Taseva', current_timestamp, '$2a$10$Zc28AcCpAgxB.e67UMF/2.FgchjH9QWB7z8nP0TdkrFneV4IHPXji','CUSTOMER', 'user'),
|
|---|
| 21 | (11111, current_timestamp, '078658523', 'c@c.com', 'Kliment', 'Nedelkovski', current_timestamp, '$2a$10$OratLSMKNsqd7Re.Md3I4.jrRHtTQNaLz/wUKo.I98..GufnD48uG','CUSTOMER', 'c'),
|
|---|
| 22 | (10000, current_timestamp, '071218123', 'q@c.com', 'Stefan', 'Petrovski', current_timestamp, '$2a$10$x10O8eLp1r1wHwxDGvyo5.TBL216p8h797JJjQYEfFTbj/1bnCMki','BUSINESS_OWNER', 'q'),
|
|---|
| 23 | (40000, current_timestamp, '072336472', 'marija_velkovska@gmail.com', 'Marija', 'Velkovska', current_timestamp, '$2a$10$gnU40aUg/JMVObDUWQBacuZFqyIO2zR05FkXq3vdvf9.FjwtUjRHC','BUSINESS_OWNER','q1');
|
|---|
| 24 |
|
|---|
| 25 |
|
|---|
| 26 |
|
|---|
| 27 | insert into business (id, business_status, company_name, created, modified, business_type_id, owner_id)
|
|---|
| 28 | values (10001, 'ACTIVE', 'krojach stefan', current_timestamp, current_timestamp, 1, 10000),
|
|---|
| 29 | (40001, 'ACTIVE', 'Manikir Marija', current_timestamp, current_timestamp, 2, 40000);
|
|---|
| 30 |
|
|---|
| 31 | insert into service (id, created, modified, service_status, duration, price, cumulated_rating, reviews_count, business_id, service_type_id, description)
|
|---|
| 32 | values (10002, current_timestamp, current_timestamp, 'ACTIVE', 60, 400, 0, 0, 10001, 6, 'Sewing dress with previously bought material.'),
|
|---|
| 33 | (10003, current_timestamp, current_timestamp, 'ACTIVE', 30, 200, 0, 0, 10001, 7, 'Shortening of pants and fixing pant''s edges.'),
|
|---|
| 34 | (40002, current_timestamp, current_timestamp, 'ACTIVE', 60, 600, 0, 0, 40001, 5, 'Removing old nail extensions and creating new ones.');
|
|---|
| 35 |
|
|---|
| 36 | insert into appointment (id, created, modified, start_time, end_time, stakeholder_id, service_id)
|
|---|
| 37 | values
|
|---|
| 38 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date + time '10:00:00', current_date + time '10:59:00', 11111, 10002),
|
|---|
| 39 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date + time '11:00:00', current_date + time '11:29:00', 11111, 10003),
|
|---|
| 40 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date + time '13:00:00', current_date + time '13:59:00', 11111, 10002),
|
|---|
| 41 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date + time '14:00:00', current_date + time '14:29:00', 11111, 10003),
|
|---|
| 42 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date + time '14:30:00', current_date + time '14:59:00', 11111, 10003),
|
|---|
| 43 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date + 1 + time '11:30:00', current_date + 1 + time '11:59:00', 11111, 10003),
|
|---|
| 44 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date + 1 + time '13:30:00', current_date + 1 + time '14:29:00', 11111, 10002),
|
|---|
| 45 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date + 1 + time '15:00:00', current_date + 1 + time '15:29:00', 11111, 10003),
|
|---|
| 46 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date + 1 + time '14:30:00', current_date + 1 + time '14:59:00', 11111, 10003),
|
|---|
| 47 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date - 1 + time '09:00:00', current_date - 1 + time '09:29:00', 11111, 10003),
|
|---|
| 48 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date - 1 + time '10:00:00', current_date - 1 + time '10:59:00', 11111, 10002),
|
|---|
| 49 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date - 1 + time '12:00:00', current_date - 1 + time '12:29:00', 11111, 10003),
|
|---|
| 50 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date - 1 + time '12:40:00', current_date - 1 + time '12:09:00', 11111, 10003),
|
|---|
| 51 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date - 2 + time '10:30:00', current_date - 2 + time '10:59:00', 11111, 10003),
|
|---|
| 52 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date - 2 + time '12:10:00', current_date - 2 + time '13:09:00', 11111, 10002),
|
|---|
| 53 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date - 2 + time '15:10:00', current_date - 2 + time '15:39:00', 11111, 10003),
|
|---|
| 54 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date - 2 + time '14:15:00', current_date - 2 + time '14:44:00', 11111, 10003),
|
|---|
| 55 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date - 3 + time '11:10:00', current_date - 3 + time '11:39:00', 11111, 10003),
|
|---|
| 56 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date - 3 + time '14:30:00', current_date - 3 + time '14:59:00', 11111, 10003),
|
|---|
| 57 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date - 3 + time '08:00:00', current_date - 3 + time '08:29:00', 11111, 10003),
|
|---|
| 58 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date + 2 + time '10:10:00', current_date + 2 + time '10:29:00', 11111, 10003),
|
|---|
| 59 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date + 2 + time '11:15:00', current_date + 2 + time '11:44:00', 11111, 10003),
|
|---|
| 60 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date + 2 + time '14:30:00', current_date + 2 + time '14:59:00', 11111, 10003),
|
|---|
| 61 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date + 3 + time '11:14:00', current_date + 3 + time '11:44:00', 11111, 10003),
|
|---|
| 62 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date + 3 + time '13:25:00', current_date + 3 + time '13:54:00', 11111, 10003),
|
|---|
| 63 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date + 3 + time '14:00:00', current_date + 3 + time '14:29:00', 11111, 10003),
|
|---|
| 64 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date - 2 + time '12:10:00', current_date - 2 + time '13:09:00', 50000, 40002),
|
|---|
| 65 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date - 2 + time '15:10:00', current_date - 2 + time '16:09:00', 50000, 40002),
|
|---|
| 66 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date - 2 + time '14:15:00', current_date - 2 + time '15:14:00', 50000, 40002),
|
|---|
| 67 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date - 3 + time '11:10:00', current_date - 3 + time '12:09:00', 50000, 40002),
|
|---|
| 68 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date - 3 + time '14:30:00', current_date - 3 + time '15:29:00', 50000, 40002),
|
|---|
| 69 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date - 3 + time '08:00:00', current_date - 3 + time '08:59:00', 50000, 40002),
|
|---|
| 70 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date + 2 + time '10:10:00', current_date + 2 + time '11:09:00', 50000, 40002),
|
|---|
| 71 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date + 2 + time '11:15:00', current_date + 2 + time '12:14:00', 50000, 40002),
|
|---|
| 72 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date + 2 + time '14:30:00', current_date + 2 + time '15:29:00', 50000, 40002),
|
|---|
| 73 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date + 3 + time '11:14:00', current_date + 3 + time '12:13:00', 50000, 40002),
|
|---|
| 74 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date + 3 + time '13:25:00', current_date + 3 + time '14:24:00', 50000, 40002),
|
|---|
| 75 | (nextval('hibernate_sequence'), current_timestamp, current_timestamp, current_date + 3 + time '14:00:00', current_date + 3 + time '14:59:00', 50000, 40002);
|
|---|
