shreyansh-1607/LibraryManagementSystem — reverse-engineered prompt

Build me a command line Library Management System in Python that uses MySQL for storage. I want it to feel like a real library tool with login and different access for Admin and Librarian users. Admin should be able to manage system users and see overall records, while Librarian should be able to do day to day work like adding, updating, searching, viewing, and deleting books and members.

It should handle issuing and returning books, automatically update available book counts, keep track of which member has which book, and calculate overdue fines when a book is returned late. Please include basic validation for member details like phone and email, and make sure the data stays persistent in the database.

Set it up so the project can be started from a main file and include the SQL needed to create the database tables. Keep the flow simple and menu driven since this is meant to run in the terminal. If anything is unclear, check current docs online and make reasonable choices.