diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/migrations/0003.sqlite3 | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/migrations/0003.sqlite3 b/sql/migrations/0003.sqlite3 new file mode 100644 index 0000000..79f7516 --- /dev/null +++ b/sql/migrations/0003.sqlite3 @@ -0,0 +1,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 +); |
