| 1 | INSERT INTO ApplicationUser (UserID, Name, Surname, Email, Password, PhoneNumber, DateJoined)
|
|---|
| 2 | VALUES
|
|---|
| 3 | (1, 'Alice', 'Johnson', 'alice.johnson@email.com', 'pass123', '1234567890', '2023-01-15'),
|
|---|
| 4 | (2, 'Bob', 'Smith', 'bob.smith@email.com', 'securepass', '0987654321', '2023-02-20');
|
|---|
| 5 |
|
|---|
| 6 | INSERT INTO Destination (DestinationID, Name, Country, Description, PopularAttraction, BestTimeToVisit)
|
|---|
| 7 | VALUES
|
|---|
| 8 | (1, 'Paris', 'France', 'City of Love and Lights', 'Eiffel Tower', 'Spring & Autumn'),
|
|---|
| 9 | (2, 'Tokyo', 'Japan', 'Blend of modern and traditional culture', 'Shibuya Crossing', 'March to May, September to November');
|
|---|
| 10 |
|
|---|
| 11 | INSERT INTO Airport (AirportID, Name, CityID, Country, Code)
|
|---|
| 12 | VALUES
|
|---|
| 13 | (1, 'Charles de Gaulle Airport', 1, 'France', 'CDG'),
|
|---|
| 14 | (2, 'Narita International Airport', 2, 'Japan', 'NRT');
|
|---|
| 15 |
|
|---|
| 16 | INSERT INTO Flight (FlightID, FlightNumber, DepartureAirport, ArrivalAirport, DepartureTime, ArrivalTime, Price, AvailableSeats)
|
|---|
| 17 | VALUES
|
|---|
| 18 | (1, 'AF123', 1, 2, '10:30:00', '23:45:00', 850.00, 150),
|
|---|
| 19 | (2, 'JL456', 2, 1, '15:00:00', '05:30:00', 900.00, 120);
|
|---|
| 20 |
|
|---|
| 21 | INSERT INTO Booking (BookingID, UserID, FlightID, BookingDate, PaymentStatus, TotalCost, SeatNumber)
|
|---|
| 22 | VALUES
|
|---|
| 23 | (1, 1, 1, '2024-02-10', 'Completed', 850.00, 12),
|
|---|
| 24 | (2, 2, 2, '2024-02-12', 'Pending', 900.00, 23);
|
|---|
| 25 |
|
|---|
| 26 | INSERT INTO Review (ReviewID, UserID, TargetID, ReviewComment, Rating, Date)
|
|---|
| 27 | VALUES
|
|---|
| 28 | (1, 1, 1, 'Amazing flight, very comfortable!', 5, '2024-02-15'),
|
|---|
| 29 | (2, 2, 2, 'Decent flight but could be better.', 3, '2024-02-18');
|
|---|
| 30 |
|
|---|
| 31 | INSERT INTO Payment (PaymentID, BookingID, UserID, PaymentMethod, Amount, TransactionDate, PaymentStatus)
|
|---|
| 32 | VALUES
|
|---|
| 33 | (1, 1, 1, 'Credit card', 850.00, '2024-02-10', 'Success'),
|
|---|
| 34 | (2, 2, 2, 'PayPal', 900.00, '2024-02-12', 'Processing');
|
|---|
| 35 |
|
|---|
| 36 | INSERT INTO Notification (NotificationID, UserID, Message, Type, DateSent)
|
|---|
| 37 | VALUES
|
|---|
| 38 | (1, 1, 'Your booking is confirmed!', 'Booking confirmation', '2024-02-10'),
|
|---|
| 39 | (2, 2, 'Your flight is delayed by 1 hour.', 'Flight delay', '2024-02-13');
|
|---|
| 40 |
|
|---|
| 41 | INSERT INTO Wishlist (WishlistID, UserID, TargetID, DateAdded)
|
|---|
| 42 | VALUES
|
|---|
| 43 | (1, 1, 1, '2024-02-05'),
|
|---|
| 44 | (2, 2, 2, '2024-02-07');
|
|---|
| 45 |
|
|---|
| 46 | INSERT INTO Administrator (AdminID, Email)
|
|---|
| 47 | VALUES
|
|---|
| 48 | (1, 'admin1@voyago.com'),
|
|---|
| 49 | (2, 'admin2@voyago.com');
|
|---|
| 50 |
|
|---|
| 51 | INSERT INTO SupportTicket (TicketID, UserID, Subject, Description, Status, DateCreated, DateResolved, AssignedTo)
|
|---|
| 52 | VALUES
|
|---|
| 53 | (1, 1, 'Refund Request', 'I need a refund for my flight.', 'Open', '2024-02-11', NULL, 1),
|
|---|
| 54 | (2, 2, 'Lost Baggage', 'My luggage was lost during transit.', 'In progress', '2024-02-14', NULL, 2);
|
|---|
