aboutsummaryrefslogtreecommitdiffstats
path: root/migrations/20170625150613_token.sql
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/20170625150613_token.sql')
-rw-r--r--migrations/20170625150613_token.sql14
1 files changed, 14 insertions, 0 deletions
diff --git a/migrations/20170625150613_token.sql b/migrations/20170625150613_token.sql
new file mode 100644
index 0000000..fa56fa2
--- /dev/null
+++ b/migrations/20170625150613_token.sql
@@ -0,0 +1,14 @@
+
+-- +goose Up
+-- SQL in section 'Up' is executed when this migration is applied
+
+CREATE TABLE tokens(
+ token text PRIMARY KEY,
+ created timestamp WITH time zone DEFAULT now(),
+ user_id integer REFERENCES users(user_id)
+);
+
+
+-- +goose Down
+-- SQL section 'Down' is executed when this migration is rolled back
+DROP TABLE tokens;