gistfile1.sql

create table users (
	id int not null auto_increment primary key,
	name varchar(255) not null
);
create table photos (
	id int not null auto_increment primary key,
	user_id int not null references user (id),
	filename varchar(255) not null
);
insert into users (name) values ('cyan'), ('magenta'), ('yellow'), ('black');
insert into photos (user_id, filename) values
	(1, 'cat.jpg'),
	(1, 'cat2.jpg'),
	(2, 'homework.jpg'),
	(2, 'window.jpg'),
	(2, 'logo.png'),
	(3, 'lol.gif');