sql: migrations: Add 0003.sqlite3

This adds persistence for tokens.

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