
-- +goose Up
-- SQL in section 'Up' is executed when this migration is applied
CREATE TABLE IF NOT EXISTS now_playing (
	artist text,
	album_artist text,
	track_name text,
	album text,
	track_number int,
	duration int,
	received timestamptz DEFAULT current_timestamp,
	mbid text,
	song_id int REFERENCES songs,
	session_key text REFERENCES scrobbling_sessions,
	user_id int UNIQUE REFERENCES users
);

-- +goose Down
-- SQL section 'Down' is executed when this migration is rolled back
DROP TABLE now_playing;

