Create `refresh_tokens` Table for Persistent Sessions #29

New issue

Closed

opened 2025-10-17 23:20:05 +00:00 by Rodrigo2003-PT · 1 comment

Rodrigo2003-PT commented

2025-10-17 23:20:05 +00:00

(Migrated from github.com)

Securely store and manage refresh tokens.
Tasks:

Define the refresh_tokens table schema:
- id (PK, UUID)
- user_id (FK to users.id, Not Null)
- token_hash (VARCHAR, Not Null, Unique)
- expires_at (TIMESTAMPZ, Not Null)
- is_revoked (BOOLEAN, default: false)
Create the database migration script.
Add a scheduled job to clean expired/revoked tokens.

Securely store and manage refresh tokens. Tasks: - Define the `refresh_tokens` table schema: - `id` (PK, UUID) - `user_id` (FK to `users.id`, Not Null) - `token_hash` (VARCHAR, Not Null, Unique) - `expires_at` (TIMESTAMPZ, Not Null) - `is_revoked` (BOOLEAN, default: false) - Create the database migration script. - Add a scheduled job to clean expired/revoked tokens.

Cordeir01 commented

2025-11-27 16:32:25 +00:00

(Migrated from github.com)

Refresh Tokens database logic done in the endpoints login/register issue

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

AndreFerreira5/starranja#29

No description provided.

Rows
Columns

Create refresh_tokens Table for Persistent Sessions #29

Create `refresh_tokens` Table for Persistent Sessions #29