-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdata.sql
More file actions
90 lines (87 loc) · 11.4 KB
/
data.sql
File metadata and controls
90 lines (87 loc) · 11.4 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
INSERT INTO user_service.users (
id,
login,
password_salt,
password_hash,
first_name,
last_name,
email,
phone,
driver_license_number,
role,
created_at
) VALUES
('00000000-0000-0000-0000-000000000001', 'alice.driver', 'seed-salt-01', 'seed-hash-01', 'Alice', 'Driver', 'alice.driver@example.com', '+79000000001', 'DL-ALICE-001', 'CUSTOMER', '2026-01-10T08:00:00Z'),
('00000000-0000-0000-0000-000000000002', 'alex.wong', 'seed-salt-02', 'seed-hash-02', 'Alex', 'Wong', 'alex.wong@example.com', '+79000000002', 'DL-ALEX-002', 'CUSTOMER', '2026-01-11T08:00:00Z'),
('00000000-0000-0000-0000-000000000003', 'anna.lee', 'seed-salt-03', 'seed-hash-03', 'Anna', 'Lee', 'anna.lee@example.com', '+79000000003', 'DL-ANNA-003', 'CUSTOMER', '2026-01-12T08:00:00Z'),
('00000000-0000-0000-0000-000000000004', 'boris.kim', 'seed-salt-04', 'seed-hash-04', 'Boris', 'Kim', 'boris.kim@example.com', '+79000000004', 'DL-BORIS-004', 'CUSTOMER', '2026-01-13T08:00:00Z'),
('00000000-0000-0000-0000-000000000005', 'carla.ivanova', 'seed-salt-05', 'seed-hash-05', 'Carla', 'Ivanova', 'carla.ivanova@example.com', '+79000000005', 'DL-CARLA-005', 'CUSTOMER', '2026-01-14T08:00:00Z'),
('00000000-0000-0000-0000-000000000006', 'dmitry.sokolov', 'seed-salt-06', 'seed-hash-06', 'Dmitry', 'Sokolov', 'dmitry.sokolov@example.com', '+79000000006', 'DL-DMITRY-006', 'CUSTOMER', '2026-01-15T08:00:00Z'),
('00000000-0000-0000-0000-000000000007', 'elena.novik', 'seed-salt-07', 'seed-hash-07', 'Elena', 'Novik', 'elena.novik@example.com', '+79000000007', 'DL-ELENA-007', 'CUSTOMER', '2026-01-16T08:00:00Z'),
('00000000-0000-0000-0000-000000000008', 'farid.amin', 'seed-salt-08', 'seed-hash-08', 'Farid', 'Amin', 'farid.amin@example.com', '+79000000008', 'DL-FARID-008', 'CUSTOMER', '2026-01-17T08:00:00Z'),
('00000000-0000-0000-0000-000000000009', 'grace.cho', 'seed-salt-09', 'seed-hash-09', 'Grace', 'Cho', 'grace.cho@example.com', '+79000000009', 'DL-GRACE-009', 'CUSTOMER', '2026-01-18T08:00:00Z'),
('00000000-0000-0000-0000-000000000010', 'ivan.petrov', 'seed-salt-10', 'seed-hash-10', 'Ivan', 'Petrov', 'ivan.petrov@example.com', '+79000000010', 'DL-IVAN-010', 'CUSTOMER', '2026-01-19T08:00:00Z');
INSERT INTO fleet_service.cars (
id,
vin,
brand,
model,
class,
status,
price_per_day,
created_at
) VALUES
('10000000-0000-0000-0000-000000000001', 'WDB11111111111111', 'Toyota', 'Corolla', 'ECONOMY', 'IN_RENT', 55.00, '2026-02-01T09:00:00Z'),
('10000000-0000-0000-0000-000000000002', 'WDB22222222222222', 'Hyundai', 'Elantra', 'COMFORT', 'IN_RENT', 72.00, '2026-02-02T09:00:00Z'),
('10000000-0000-0000-0000-000000000003', 'WDB33333333333333', 'BMW', '320', 'BUSINESS', 'IN_RENT', 120.00, '2026-02-03T09:00:00Z'),
('10000000-0000-0000-0000-000000000004', 'WDB44444444444444', 'Toyota', 'RAV4', 'SUV', 'IN_RENT', 95.00, '2026-02-04T09:00:00Z'),
('10000000-0000-0000-0000-000000000005', 'WDB55555555555555', 'Mercedes-Benz', 'E200', 'BUSINESS', 'AVAILABLE', 140.00, '2026-02-05T09:00:00Z'),
('10000000-0000-0000-0000-000000000006', 'WDB66666666666666', 'Kia', 'Rio', 'ECONOMY', 'AVAILABLE', 49.00, '2026-02-06T09:00:00Z'),
('10000000-0000-0000-0000-000000000007', 'WDB77777777777777', 'Audi', 'A6', 'LUXURY', 'AVAILABLE', 180.00, '2026-02-07T09:00:00Z'),
('10000000-0000-0000-0000-000000000008', 'WDB88888888888888', 'Skoda', 'Octavia', 'COMFORT', 'AVAILABLE', 68.00, '2026-02-08T09:00:00Z'),
('10000000-0000-0000-0000-000000000009', 'WDB99999999999999', 'Volkswagen', 'Tiguan', 'SUV', 'AVAILABLE', 88.00, '2026-02-09T09:00:00Z'),
('10000000-0000-0000-0000-000000000010', 'WDBAAAAAAA1111111', 'Lexus', 'RX350', 'LUXURY', 'MAINTENANCE', 165.00, '2026-02-10T09:00:00Z');
INSERT INTO rental_service.rentals (
id,
user_id,
car_id,
start_at,
end_at,
status,
price_total,
created_at,
closed_at,
payment_reference
) VALUES
('20000000-0000-0000-0000-000000000001', '00000000-0000-0000-0000-000000000001', '10000000-0000-0000-0000-000000000001', '2026-04-10T09:00:00Z', '2026-04-14T09:00:00Z', 'ACTIVE', 220.00, '2026-04-10T08:40:00Z', NULL, 'pay-seed-001'),
('20000000-0000-0000-0000-000000000002', '00000000-0000-0000-0000-000000000002', '10000000-0000-0000-0000-000000000002', '2026-04-11T10:00:00Z', '2026-04-15T10:00:00Z', 'ACTIVE', 288.00, '2026-04-11T09:45:00Z', NULL, 'pay-seed-002'),
('20000000-0000-0000-0000-000000000003', '00000000-0000-0000-0000-000000000003', '10000000-0000-0000-0000-000000000003', '2026-04-12T11:00:00Z', '2026-04-16T11:00:00Z', 'ACTIVE', 480.00, '2026-04-12T10:50:00Z', NULL, 'pay-seed-003'),
('20000000-0000-0000-0000-000000000004', '00000000-0000-0000-0000-000000000004', '10000000-0000-0000-0000-000000000004', '2026-04-13T08:00:00Z', '2026-04-18T08:00:00Z', 'ACTIVE', 475.00, '2026-04-13T07:35:00Z', NULL, 'pay-seed-004'),
('20000000-0000-0000-0000-000000000005', '00000000-0000-0000-0000-000000000005', '10000000-0000-0000-0000-000000000005', '2026-03-01T09:00:00Z', '2026-03-05T09:00:00Z', 'COMPLETED', 560.00, '2026-03-01T08:20:00Z', '2026-03-05T09:05:00Z', 'pay-seed-005'),
('20000000-0000-0000-0000-000000000006', '00000000-0000-0000-0000-000000000006', '10000000-0000-0000-0000-000000000006', '2026-03-03T12:00:00Z', '2026-03-06T12:00:00Z', 'COMPLETED', 147.00, '2026-03-03T11:30:00Z', '2026-03-06T12:05:00Z', 'pay-seed-006'),
('20000000-0000-0000-0000-000000000007', '00000000-0000-0000-0000-000000000007', '10000000-0000-0000-0000-000000000007', '2026-03-07T07:00:00Z', '2026-03-10T07:00:00Z', 'COMPLETED', 540.00, '2026-03-07T06:20:00Z', '2026-03-10T07:15:00Z', 'pay-seed-007'),
('20000000-0000-0000-0000-000000000008', '00000000-0000-0000-0000-000000000008', '10000000-0000-0000-0000-000000000008', '2026-03-08T10:00:00Z', '2026-03-12T10:00:00Z', 'COMPLETED', 272.00, '2026-03-08T09:10:00Z', '2026-03-12T10:10:00Z', 'pay-seed-008'),
('20000000-0000-0000-0000-000000000009', '00000000-0000-0000-0000-000000000009', '10000000-0000-0000-0000-000000000009', '2026-03-09T14:00:00Z', '2026-03-11T14:00:00Z', 'CANCELLED', 176.00, '2026-03-09T13:00:00Z', '2026-03-09T18:00:00Z', 'pay-seed-009'),
('20000000-0000-0000-0000-000000000010', '00000000-0000-0000-0000-000000000010', '10000000-0000-0000-0000-000000000010', '2026-03-10T16:00:00Z', '2026-03-13T16:00:00Z', 'CANCELLED', 495.00, '2026-03-10T15:30:00Z', '2026-03-10T20:00:00Z', 'pay-seed-010');
INSERT INTO rental_service.outbox_events (
id,
aggregate_type,
aggregate_id,
event_type,
payload,
created_at
) VALUES
('30000000-0000-0000-0000-000000000001', 'rental', '20000000-0000-0000-0000-000000000001', 'RentalCreated', '{"eventId":"evt-001","rentalId":"20000000-0000-0000-0000-000000000001","userId":"00000000-0000-0000-0000-000000000001","carId":"10000000-0000-0000-0000-000000000001","status":"ACTIVE","createdAt":"2026-04-10T08:40:00Z"}', '2026-04-10T08:40:00Z'),
('30000000-0000-0000-0000-000000000002', 'rental', '20000000-0000-0000-0000-000000000002', 'RentalCreated', '{"eventId":"evt-002","rentalId":"20000000-0000-0000-0000-000000000002","userId":"00000000-0000-0000-0000-000000000002","carId":"10000000-0000-0000-0000-000000000002","status":"ACTIVE","createdAt":"2026-04-11T09:45:00Z"}', '2026-04-11T09:45:00Z'),
('30000000-0000-0000-0000-000000000003', 'rental', '20000000-0000-0000-0000-000000000003', 'RentalCreated', '{"eventId":"evt-003","rentalId":"20000000-0000-0000-0000-000000000003","userId":"00000000-0000-0000-0000-000000000003","carId":"10000000-0000-0000-0000-000000000003","status":"ACTIVE","createdAt":"2026-04-12T10:50:00Z"}', '2026-04-12T10:50:00Z'),
('30000000-0000-0000-0000-000000000004', 'rental', '20000000-0000-0000-0000-000000000004', 'RentalCreated', '{"eventId":"evt-004","rentalId":"20000000-0000-0000-0000-000000000004","userId":"00000000-0000-0000-0000-000000000004","carId":"10000000-0000-0000-0000-000000000004","status":"ACTIVE","createdAt":"2026-04-13T07:35:00Z"}', '2026-04-13T07:35:00Z'),
('30000000-0000-0000-0000-000000000005', 'rental', '20000000-0000-0000-0000-000000000005', 'RentalCreated', '{"eventId":"evt-005","rentalId":"20000000-0000-0000-0000-000000000005","userId":"00000000-0000-0000-0000-000000000005","carId":"10000000-0000-0000-0000-000000000005","status":"ACTIVE","createdAt":"2026-03-01T08:20:00Z"}', '2026-03-01T08:20:00Z'),
('30000000-0000-0000-0000-000000000006', 'rental', '20000000-0000-0000-0000-000000000006', 'RentalCreated', '{"eventId":"evt-006","rentalId":"20000000-0000-0000-0000-000000000006","userId":"00000000-0000-0000-0000-000000000006","carId":"10000000-0000-0000-0000-000000000006","status":"ACTIVE","createdAt":"2026-03-03T11:30:00Z"}', '2026-03-03T11:30:00Z'),
('30000000-0000-0000-0000-000000000007', 'rental', '20000000-0000-0000-0000-000000000007', 'RentalCreated', '{"eventId":"evt-007","rentalId":"20000000-0000-0000-0000-000000000007","userId":"00000000-0000-0000-0000-000000000007","carId":"10000000-0000-0000-0000-000000000007","status":"ACTIVE","createdAt":"2026-03-07T06:20:00Z"}', '2026-03-07T06:20:00Z'),
('30000000-0000-0000-0000-000000000008', 'rental', '20000000-0000-0000-0000-000000000008', 'RentalCreated', '{"eventId":"evt-008","rentalId":"20000000-0000-0000-0000-000000000008","userId":"00000000-0000-0000-0000-000000000008","carId":"10000000-0000-0000-0000-000000000008","status":"ACTIVE","createdAt":"2026-03-08T09:10:00Z"}', '2026-03-08T09:10:00Z'),
('30000000-0000-0000-0000-000000000009', 'rental', '20000000-0000-0000-0000-000000000009', 'RentalCreated', '{"eventId":"evt-009","rentalId":"20000000-0000-0000-0000-000000000009","userId":"00000000-0000-0000-0000-000000000009","carId":"10000000-0000-0000-0000-000000000009","status":"ACTIVE","createdAt":"2026-03-09T13:00:00Z"}', '2026-03-09T13:00:00Z'),
('30000000-0000-0000-0000-000000000010', 'rental', '20000000-0000-0000-0000-000000000010', 'RentalCreated', '{"eventId":"evt-010","rentalId":"20000000-0000-0000-0000-000000000010","userId":"00000000-0000-0000-0000-000000000010","carId":"10000000-0000-0000-0000-000000000010","status":"ACTIVE","createdAt":"2026-03-10T15:30:00Z"}', '2026-03-10T15:30:00Z'),
('30000000-0000-0000-0000-000000000011', 'rental', '20000000-0000-0000-0000-000000000005', 'RentalCompleted', '{"eventId":"evt-011","rentalId":"20000000-0000-0000-0000-000000000005","userId":"00000000-0000-0000-0000-000000000005","carId":"10000000-0000-0000-0000-000000000005","status":"COMPLETED","createdAt":"2026-03-05T09:05:00Z"}', '2026-03-05T09:05:00Z'),
('30000000-0000-0000-0000-000000000012', 'rental', '20000000-0000-0000-0000-000000000006', 'RentalCompleted', '{"eventId":"evt-012","rentalId":"20000000-0000-0000-0000-000000000006","userId":"00000000-0000-0000-0000-000000000006","carId":"10000000-0000-0000-0000-000000000006","status":"COMPLETED","createdAt":"2026-03-06T12:05:00Z"}', '2026-03-06T12:05:00Z'),
('30000000-0000-0000-0000-000000000013', 'rental', '20000000-0000-0000-0000-000000000007', 'RentalCompleted', '{"eventId":"evt-013","rentalId":"20000000-0000-0000-0000-000000000007","userId":"00000000-0000-0000-0000-000000000007","carId":"10000000-0000-0000-0000-000000000007","status":"COMPLETED","createdAt":"2026-03-10T07:15:00Z"}', '2026-03-10T07:15:00Z'),
('30000000-0000-0000-0000-000000000014', 'rental', '20000000-0000-0000-0000-000000000008', 'RentalCompleted', '{"eventId":"evt-014","rentalId":"20000000-0000-0000-0000-000000000008","userId":"00000000-0000-0000-0000-000000000008","carId":"10000000-0000-0000-0000-000000000008","status":"COMPLETED","createdAt":"2026-03-12T10:10:00Z"}', '2026-03-12T10:10:00Z');