From 7629de5b888bd3d1cdb94dce3ba51cb1e1c2e625 Mon Sep 17 00:00:00 2001 From: Cara Salter Date: Thu, 6 Apr 2023 15:45:39 -0400 Subject: pg: Add postgres support Supports migrations Change-Id: Ifca8358d4f57a4b417f1d972e400e98767e01bb5 --- migrations/0001-init.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 migrations/0001-init.sql (limited to 'migrations/0001-init.sql') diff --git a/migrations/0001-init.sql b/migrations/0001-init.sql new file mode 100644 index 0000000..7a00ff0 --- /dev/null +++ b/migrations/0001-init.sql @@ -0,0 +1,7 @@ +CREATE TABLE IF NOT EXISTS spotify ( + id SERIAL PRIMARY KEY, + spotify_username TEXT NOT NULL, + spotify_token TEXT NOT NULL, + spotify_token_expires TIMESTAMP NOT NULL, + spotify_refresh_token TEXT NOT NULL +); \ No newline at end of file -- cgit v1.2.3