From f9369f1bba2b0edcdcda3d1f104771309ecc4d23 Mon Sep 17 00:00:00 2001
From: Julien Dessaux
Date: Wed, 12 May 2021 22:57:49 +0200
Subject: Fixed sessions schema

---
 pkg/database/migrations.go | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/pkg/database/migrations.go b/pkg/database/migrations.go
index 7de255a..6a3d923 100644
--- a/pkg/database/migrations.go
+++ b/pkg/database/migrations.go
@@ -19,7 +19,7 @@ var allMigrations = []func(tx *sql.Tx) error{
 				last_login_at DATE DEFAULT NULL
 			);
 			CREATE TABLE sessions (
-				token TEXT NOT NULL UNIQUE,
+				token TEXT PRIMARY KEY,
 				user_id INTEGER NOT NULL,
 				created_at DATE DEFAULT (datetime('now')),
 				FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
-- 
cgit v1.2.3