0003_password_tokens_postgres.up.sql
1ALTER TABLE users ADD COLUMN password TEXT;
2
3CREATE TABLE IF NOT EXISTS access_tokens (
4 id SERIAL PRIMARY KEY,
5 name text NOT NULL,
6 token TEXT NOT NULL UNIQUE,
7 user_id INTEGER NOT NULL,
8 expires_at TIMESTAMP,
9 created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
10 updated_at TIMESTAMP NOT NULL,
11 CONSTRAINT user_id_fk
12 FOREIGN KEY (user_id) REFERENCES users(id)
13 ON DELETE CASCADE
14 ON UPDATE CASCADE
15);