fix(module): prevent conflict with auth & security tools

[farnabaz]

🔗 Linked issue

resolves #3043
resovles #3243
resovles #3091

❓ Type of change

• 📖 Documentation (updates to the documentation or readme)
• 🐞 Bug fix (a non-breaking change that fixes an issue)
• 👌 Enhancement (improving an existing functionality like performance)
• ✨ New feature (a non-breaking change that adds functionality)
• ⚠️ Breaking change (fix or feature that would cause existing functionality to change)

📚 Description

• resolves [v3] Page not found on preview after generate #3043

Due to the behavior of the serve package, using the database.sql as filename for the database dump breaks the spa apps. Renaming the filename to sql_dump fixes the issue

• resolves Use database_sql instead of database.sql in the API route to avoid conflicts with server - side security configurations. #3243

Rename database.sql to sql_dump to prevent having conflict with security services.

• resovles [V3] Ability to specify api.baseUrl #3091

Instead of registering API routes under /api/content, module now registers APIs under /__nuxt_content prefix. By doing so, the module APIs will no longer conflict with user APIs and authentication.

📝 Checklist

• I have linked an issue or discussion.
• I have updated the documentation accordingly.

[pkg-pr-new]

npm i https://pkg.pr.new/@nuxt/content@3245

commit: 5fcc19a