sql: migrations: Add 0003.sqlite3

This adds persistence for tokens.

1 files changed, 5 insertions, 0 deletions

diff --git a/main.go b/main.go
index 4cd1150..6f628a5 100644
--- a/main.go
+++ b/main.go
@@ -58,6 +58,11 @@ func run(
 	}
 	defer db.Close()
 
+	_, err = db.Exec(`PRAGMA foreign_keys = ON;`)
+	if err != nil {
+		log.Fatalf("Failed to enable foreign key support in database: %v", err)
+	}
+
 	err = MigrateToLatest(db)
 	if err != nil {
 		log.Fatalf("Failed to migrate SQLite3 database '%s': %v", dbPath, err)