INSERT INTO Hotels (Name, Location)
VALUES ('Street Motel', 'Chicago');

INSERT INTO Hotels (Name, Location)
VALUES ('Mariott', 'Warshaw');

INSERT INTO Rooms (Capacity, PricePerDay, HotelId)
VALUES (2, 22.50, 1),(4, 40, 1);

INSERT INTO Rates (UserId, HotelId, Value)
VALUES (1, 1, 4);

INSERT INTO Reservations (UserId, RoomId, StartDate, EndDate)
VALUES (1, 1, '2022-11-11 10:00:00', '2022-11-14 10:00:00');

CREATE PROCEDURE `insert_reservation` (_UserId INT, _RoomId INT, _StartDate DATETIME, _EndDate DATETIME)
BEGIN
INSERT INTO Reservations SET UserId = _UserId, StartDate = _StartDate, EndDate = _EndDate, RoomId = _RoomId
ON DUPLICATE KEY UPDATE StartDate = _StartDate, EndDate = _EndDate;
END