go-music-player/gmus-backend/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,
  base_path VARCHAR NOT NULL,
  relative_path VARCHAR NOT NULL
);