aboutsummaryrefslogtreecommitdiff
path: root/migrations
diff options
context:
space:
mode:
authorCara Salter <cara@devcara.com>2023-04-06 15:45:39 -0400
committerCara Salter <cara@devcara.com>2023-04-06 17:11:52 -0400
commit7629de5b888bd3d1cdb94dce3ba51cb1e1c2e625 (patch)
tree0dd37a701fb242fa953c23f2b0a94252fa60762b /migrations
parentb66bf922cc2d8eb3a623d1f776ab6a144832f587 (diff)
download142bot-7629de5b888bd3d1cdb94dce3ba51cb1e1c2e625.tar.gz
142bot-7629de5b888bd3d1cdb94dce3ba51cb1e1c2e625.zip
pg: Add postgres support
Supports migrations Change-Id: Ifca8358d4f57a4b417f1d972e400e98767e01bb5
Diffstat (limited to 'migrations')
-rw-r--r--migrations/0001-init.sql7
1 files changed, 7 insertions, 0 deletions
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