USE railway reservation;

 ALTER TABLE trains
 ADD COLUMN train_type VARCHAR(50) NOT NULL;
 CREATE TABLE IF NOT EXISTS seat_reservations (
    reservation_id INT PRIMARY KEY AUTO_INCREMENT,
train_id INT,
    seat number INT NOT NULL,
 is_reserved BOOLEAN NOT NULL DEFAULT FALSE,
FOREIGN KEY (train_id) REFERENCES trains (train_id)
);
 ALTER TABLE passengers
 ADD COLUMN age INT;
 UPDATE passengers
SET age =25

 WHERE passenger_id = 1 ;
DROP TABLE IF EXISTS reservations;