Our live store has inherited years of legacy tables, views, triggers and orphaned records from the previous site build. I will give you a full export of the current MySQL database; your brief is to pare it down so that it contains only the essentials for the new build: • products • product categories • product attributes • orders • customers Everything else—marketing add-ons, unused CMS tables, logs, plugins, and historical debris—needs to be removed by hand. Because I opted for a strictly manual approach, I expect you to work directly in MySQL (CLI or phpMyAdmin) rather than relying on auto-generated scripts. As you progress, please run integrity checks: confirm primary/foreign-key consistency, eliminate orphaned rows, and ensure data types and collation remain intact. When the pruning is complete, finish with basic optimisation (index review, ANALYZE/OPTIMIZE TABLE, and any obvious schema tweaks to improve query performance). A short report explaining each structural change and the validation steps you took will be the final deliverable alongside the cleaned .sql file. To finish and prove that you have read all the requirements. Say cheese before bid