Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement