aboutsummaryrefslogtreecommitdiffstats
path: root/migrations/20170625150613_token.sql
blob: fa56fa282709e52db2a2e1c37663d0a65de3db97 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
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;