add tokens table

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;