aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--pkg/database/migrations.go2
1 files changed, 1 insertions, 1 deletions
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