create table trips(
    trip_id INT NOT NULL AUTO_INCREMENT,
    user_id INT,
    trip_name VARCHAR(255) NOT NULL,
    trip_start_date DATE,
    trip_end_date DATE,
    trip_impressions VARCHAR(255) NOT NULL,
    photo_one mediumblob,
    photo_two mediumblob,
    trip_location_coordinates VARCHAR(255) NOT NULL,
        primary key(trip_id),
        foreign key(user_id) references users(user_id)
        );