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);