go-music-player/music-player/migrations/000003_song_file_modified_date.up.sql

ALTER TABLE songs ADD modified_date bigint;
UPDATE songs SET modified_date = 0;
ALTER TABLE songs ALTER COLUMN modified_date SET NOT NULL;

CREATE INDEX filename_timestamp ON songs (base_path, relative_path, modified_date);