CREATE TABLE rides (
    id INT AUTO_INCREMENT PRIMARY KEY,
    from_location VARCHAR(255),
    to_location VARCHAR(255),
    departure_time DATETIME,
    price DECIMAL(10,2),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO rides
(from_location, to_location, departure_time, price)
VALUES
('Belgrade', 'Novi Sad', '2026-05-10 14:00:00', 15.00),
('Kovin', 'Pancevo', '2026-05-11 09:30:00', 7.50);