Now Playing feature

1 files changed, 21 insertions, 0 deletions

diff --git a/migrations/20170613221502_np.sql b/migrations/20170613221502_np.sql
new file mode 100644
index 0000000..7659555
--- /dev/null
+++ b/migrations/20170613221502_np.sql
@@ -0,0 +1,21 @@
+
+-- +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;
+