create table artist (
        id              int     	not null auto_increment,
	name		varchar(255)	not null,
	notes		mediumtext,
	primary key (id)
);

create table genre (
        id              int     	not null auto_increment,
	name		varchar(255)	not null,
	primary key (id)
);

create table album (
        id              int     	not null auto_increment,
	artist		int		not null,
	genre		int,
	title		varchar(255)	not null,
	year		int,
	notes		mediumtext,
	primary key (id)
);

create table song (
        id              int     	not null auto_increment,
	album		int		not null,
	title		varchar(255)	not null,
	nr		int		not null,
	primary key (id)
);