CREATE TABLE IF NOT EXISTS track ( id BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY, path TEXT UNIQUE, album_artist TEXT, title TEXT, album TEXT, disc INTEGER, year INTEGER, artist TEXT[], genre TEXT, lyrics TEXT, composer TEXT ); CREATE TABLE IF NOT EXISTS album ( id BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY, path TEXT UNIQUE ); CREATE TABLE IF NOT EXISTS artist ( id BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY, path TEXT UNIQUE );