Project Description
My current PHP site keeps everything in one large MySQL database. I now want to break that up so that all profile-related data lives in its own database while the rest of the application stays untouched. Concretely, I need:
• A migration script that copies existing profile content into the new database and updates references inside the codebase. The split must keep User information separate from User posts exactly as outlined.
• Support for every kind of post we allow—Text, Image and Video—so the script has to build the right tables, constraints and indexes for those.
• An update to the admin dashboard that lets me bulk-add content to each newly created section; it should feel native to the current UI.
• An AI-powered auto-tagging feature: when a user submits new profile content, the system should analyse it and suggest or assign relevant tags automatically. I’m open to the engine you prefer (OpenAI, TensorFlow, etc.) as long as accuracy is high and integration is clean.
Deliverables
1. Well-documented PHP migration/seed script.
2. Updated database schema (SQL files) for both the main and profile databases.
3. Modified dashboard modules for bulk upload with clear UX.
4. AI tagging module plus simple configuration panel.
5. A short README explaining setup, environment variables and roll-back steps.
I’ll test by running the migration on a staging copy; success means no missing data, correct key relationships and working auto-tag suggestions on new text, image and video posts. Let me know your approach, estimated timeline and any previous similar work.