go-music-player/music-player/pkg/db/migrations/000001_create_songs_table.up.sql

CREATE TABLE songs (
  id SERIAL PRIMARY KEY,
  title VARCHAR NOT NULL DEFAULT '',
  artist VARCHAR NOT NULL DEFAULT '',
  album VARCHAR NOT NULL DEFAULT '',
  duration INTEGER NULL,
  directory VARCHAR NOT NULL,
  relative_path VARCHAR NOT NULL
);