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);