mmm/table.sql

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