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