| 1 | INSERT INTO ApplicationUser (Name,Surname,Email,Password,PhoneNumber,DateJoined)
|
|---|
| 2 | VALUES
|
|---|
| 3 | ('Stefani','Jovanoska','stefani@example.com','Password123','078123456','2025-01-01'),
|
|---|
| 4 | ('Marko','Petrov','marko@example.com','Password123','078654321','2025-02-01'),
|
|---|
| 5 | ('Ana','Stojanov','ana@example.com','Password123','078987654','2025-03-01');
|
|---|
| 6 |
|
|---|
| 7 | INSERT INTO Destination (Name,Country,Description,PopularAttraction,BestTimeToVisit)
|
|---|
| 8 | VALUES
|
|---|
| 9 | ('Skopje','Macedonia','Capital city','Old Bazaar','Spring'),
|
|---|
| 10 | ('Ohrid','Macedonia','Lake city','Lake Ohrid','Summer'),
|
|---|
| 11 | ('Bansko','Bulgaria','Ski resort','Ski slopes','Winter');
|
|---|
| 12 |
|
|---|
| 13 | INSERT INTO Airport (Name,Country,Code,DestinationID)
|
|---|
| 14 | VALUES
|
|---|
| 15 | ('Skopje','Macedonia','SKP',1),
|
|---|
| 16 | ('Ohrid','Macedonia','OHD',2),
|
|---|
| 17 | ('Bansko','Bulgaria','BAN',3);
|
|---|
| 18 |
|
|---|
| 19 | INSERT INTO Flight (FlightNumber,DepartureAirportID,ArrivalAirportID,departuredate,returndate,Price,AvailableSeats)
|
|---|
| 20 | VALUES
|
|---|
| 21 | ('MK101',1,2,'2025-05-01' ,'2025-05-01',150.00,100),
|
|---|
| 22 | ('MK102',2,1,'2025-05-02','2025-05-02',150.00,80),
|
|---|
| 23 | ('MK103',1,3,'2025-05-03','2025-05-03',200.00,50);
|
|---|
| 24 |
|
|---|
| 25 | INSERT INTO Booking (UserID,BookingDate,PaymentStatus,TotalCost)
|
|---|
| 26 | VALUES
|
|---|
| 27 | (1,'2025-05-01 10:00','Processing',150.00),
|
|---|
| 28 | (2,'2025-05-02 14:00','Success',150.00),
|
|---|
| 29 | (3,'2025-05-03 16:00','Failed',200.00);
|
|---|
| 30 |
|
|---|
| 31 | INSERT INTO BookingFlight (BookingID,FlightID,SeatNumber)
|
|---|
| 32 | VALUES
|
|---|
| 33 | (1,1,1),
|
|---|
| 34 | (2,2,2),
|
|---|
| 35 | (3,3,3);
|
|---|
| 36 |
|
|---|
| 37 | INSERT INTO Review (UserID,BookingID,TargetID,TargetType,ReviewComment,Rating,Date)
|
|---|
| 38 | VALUES
|
|---|
| 39 | (1,1,1,'Flight','Great flight',5,'2025-05-01'),
|
|---|
| 40 | (2,2,2,'Flight','On time',4,'2025-05-02'),
|
|---|
| 41 | (3,3,3,'Flight','Comfortable','5','2025-05-03');
|
|---|
| 42 |
|
|---|
| 43 | INSERT INTO Payment (BookingID,UserID,PaymentMethod,Amount,TransactionDate,PaymentStatus)
|
|---|
| 44 | VALUES
|
|---|
| 45 | (1,1,'Credit',150.00,'2025-05-01','Processing'),
|
|---|
| 46 | (2,2,'PayPal',150.00,'2025-05-02','Success'),
|
|---|
| 47 | (3,3,'Debit',200.00,'2025-05-03','Failed');
|
|---|
| 48 |
|
|---|
| 49 | INSERT INTO Notification (UserID,Message,Type,DateSent)
|
|---|
| 50 | VALUES
|
|---|
| 51 | (1,'Your flight is confirmed','BookingConfirmation','2025-05-01'),
|
|---|
| 52 | (2,'Flight delayed','FlightDelay','2025-05-02'),
|
|---|
| 53 | (3,'Welcome to TravelApp','GeneralUpdate','2025-05-03');
|
|---|
| 54 |
|
|---|
| 55 | INSERT INTO Wishlist (UserID,TargetID,TargetType,DateAdded)
|
|---|
| 56 | VALUES
|
|---|
| 57 | (1,2,'Destination','2025-05-01'),
|
|---|
| 58 | (2,3,'Flight','2025-05-02'),
|
|---|
| 59 | (3,1,'Destination','2025-05-03');
|
|---|
| 60 |
|
|---|
| 61 | INSERT INTO Administrator (Email)
|
|---|
| 62 | VALUES
|
|---|
| 63 | ('admin1@example.com'),
|
|---|
| 64 | ('admin2@example.com');
|
|---|
| 65 |
|
|---|
| 66 | INSERT INTO SupportTicket (UserID,Subject,Description,Status,DateCreated,AssignedTo)
|
|---|
| 67 | VALUES
|
|---|
| 68 | (1,'Issue with booking','Booking not confirmed','Open','2025-05-01',1),
|
|---|
| 69 | (2,'Flight delay inquiry','Delayed flight','InProgress','2025-05-02',2); |
|---|
