# TODO: Replace Prisma with mysql2

## Files to Create:
- [x] lib/db.ts - MySQL connection utility
- [x] app/api/attendance/latest/route.ts - Latest attendance endpoint

## Files to Update:
- [x] app/api/attendance/summary/route.ts - Replace Prisma with mysql2
- [x] app/api/admin/route.ts - Replace Prisma with mysql2
- [ ] lib/user-service.ts - Replace Prisma with mysql2
- [ ] app/api/auth/signup/route.ts - Use updated user service
- [ ] app/api/auth/signin/route.ts - Replace Prisma with mysql2
- [ ] app/api/auth/profile/route.ts - Replace Prisma with mysql2
- [ ] app/api/employees/route.ts - Replace Prisma with mysql2
- [ ] app/api/attendance/clockin/route.ts - Replace Prisma with mysql2
- [ ] app/api/attendance/clockout/route.ts - Replace Prisma with mysql2
- [ ] app/api/attendance/route.ts - Replace Prisma with mysql2

## Installation:
- [ ] Run: npm install mysql2