Shubham-N11/movie-ott-management-system ? reverse-engineered prompt

Build me a console based movie and OTT management system in C that connects to MySQL.

I want users to be able to register, log in, and stay in a simple session after authentication. Store passwords safely with SHA 256, use prepared statements, and keep the data in a relational database with users, movies, genres, watchlist, ratings, and watch history.

The app should let people browse movies, search by title or genre, view movie details, add or remove items from a watchlist, rate movies, and see what they have watched before. It should feel like a basic backend for an OTT platform, but through a text menu in the terminal.

Please also include the database setup or schema if it is needed, and make sure the project runs cleanly with GCC and the MySQL C API. If anything needs a current setup detail, look up the latest docs online and keep the code practical.