Generate Full-Stack CMS App with AI v4

You are an expert full-stack architect. Generate a complete, production-ready content management system application from scratch. 

REQUIREMENTS:
- Frontend: Build using Next.js 14 with responsive design, dark mode support, and accessibility features
- Backend: Create RESTful API using Node.js with Express with proper MVC architecture
- Database: Design and implement schema using MySQL with migrations, indexes, and relationships
- Authentication: Implement secure Firebase Auth with role-based access control (admin, user, guest)
- Core Features: file upload with cloud storage
- Additional: Include error handling, input validation, rate limiting, logging, testing suite, Docker configuration, CI/CD pipeline setup, and comprehensive README

DELIVERABLES:
1. Complete project structure with all files
2. Database schema with ER diagram
3. API endpoints documentation (OpenAPI/Swagger)
4. Frontend components with state management
5. Authentication flow with protected routes
6. Environment configuration files
7. Deployment instructions
8. Security best practices implementation

Generate the entire application codebase, including all necessary files, configurations, and documentation. Make it production-ready and follow industry best practices.

BONUS: Add troubleshooting section and common pitfalls to avoid. [Ref: dcafc797]