CREATE TABLE artists (
	id INTEGER PRIMARY KEY,
	name VARCHAR);

CREATE TABLE albums (
	id INTEGER PRIMARY KEY,
	artist_id INTEGER,
	name VARCHAR,
	tracks INTEGER);

CREATE TABLE tracks (
	id INTEGER PRIMARY KEY,
	artist_id INTEGER,
	album_id INTEGER,
	name VARCHAR,
	length INTEGER,
	num INTEGER,
	file_name VARCHAR,
	file_index INTEGER);
