From 060b315f74f437fe36175c4ddb52379d29808d64 Mon Sep 17 00:00:00 2001
From: Thibaut Horel <thibaut.horel@gmail.com>
Date: Wed, 14 Jun 2017 00:45:42 -0400
Subject: Now Playing feature

---
 migrations/20170613221502_np.sql | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)
 create mode 100644 migrations/20170613221502_np.sql

(limited to 'migrations/20170613221502_np.sql')

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;
+
-- 
cgit v1.2.3-70-g09d2

