blob: 79f751670483637a6089aea7860af3b31e96cd82 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
PRAGMA user_version = 3;
CREATE TABLE tokens (
id INTEGER PRIMARY KEY,
user_id INTEGER NOT NULL,
token TEXT NOT NULL,
created_at DATETIME NOT NULL DEFAULT (datetime('now')),
FOREIGN KEY (user_id) REFERENCES users(id)
ON DELETE CASCADE
ON UPDATE CASCADE
);
|
