jimmyu2foru18/auctionbase ? reverse-engineered prompt

Build me a simple auction database project for an online auction site.

I want the database schema, the sample data, and the supporting SQL for views and stored procedures so I can manage users, items, bids, and completed auctions. Make it feel like a real small auction system, where people can list items, place bids, and see current winners and finished sales.

Please organize it so I can run the main SQL script first, then the views and stored procedures. If anything needs a small amount of setup or a specific database version, include that too. I’d also like the ER diagram to match the tables and relationships cleanly.

If you need to look up current SQL syntax or best practices, feel free to check the docs online.