create database library
character set utf8
collate utf8_polish_ci;

use library;

create table author(
	id int primary key,
	first_name varchar(255),
	last_name varchar(255)
);

create table book(
	id int primary key,
	title varchar(255),
	author_id int,
	foreign key(author_id) references author(id)
);