aboutsummaryrefslogtreecommitdiffhomepage
path: root/pkgs/server/src/db/schema.ts
AgeCommit message (Collapse)Author
2025-12-04feat(auth): add refresh token endpointnsfisis
Implement refresh token functionality for authentication: - Add refresh_tokens table to database schema with user reference - Generate migration for the new table - Login endpoint now returns both access token and refresh token - Add POST /api/auth/refresh endpoint with token rotation - Refresh tokens are hashed (SHA256) before storage for security - Tokens expire after 7 days, access tokens after 15 minutes - Update tests to cover new functionality 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude <noreply@anthropic.com>
2025-12-04feat(db): add Drizzle ORM setupnsfisis
Add Drizzle ORM with PostgreSQL for database access. Includes: - Schema definitions for users, decks, cards, and review_logs tables - Database connection with node-postgres driver - Drizzle Kit configuration for migrations - npm scripts for db:generate, db:migrate, db:push, db:studio 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude <noreply@anthropic.com>