Social Manager project pack manifest

SOURCE_SPEC.txt       Original supplied specification
schema.sql            Initial SQL schema extracted from specification
schema_v2.sql         Multi-tenant schema/backfill SQL extracted from specification
.env.example          Placeholder environment variables
snippets/             Extracted PHP/config/route snippets, including patch variants
mvp-upgrade/          Simple Laravel 11 add-on: dashboard, calendar, brand profiles, approvals, basic analytics, migration, routes, Blade views, and installation notes
README.md             Setup overview and limitations
IMPLEMENTATION_NOTES.md Review checklist and known integration risks

This is a starter implementation pack, not a complete tested Laravel repository. Review schema compatibility and merge routes/snippets intentionally before deployment.


MVP upgrade additions (multi-tenant provider keys):
- mvp-upgrade/INSTALL_API_SETTINGS.md — per-workspace API credential setup instructions
- mvp-upgrade/app/Http/Controllers/AiProviderSettingsController.php — owner/admin settings controller
- mvp-upgrade/app/Models/OrgAiProvider.php — encrypted credential model
- mvp-upgrade/resources/views/social-manager/ai-providers.blade.php — provider settings page
- mvp-upgrade/routes/ai-provider-settings.php — routes to merge
- mvp-upgrade/database/migrations/2026_10_10_000001_create_org_ai_providers_table.php — tenant-scoped provider settings table
- mvp-upgrade/config/ai.php.example — config example with no customer API keys in env


MVP upgrade additions (Oct 2026):
- Business registration and login views/controllers
- Environment-configured administrator login and business approval page
- Per-organization OAuth app credentials page/model/migration
- Installation notes: mvp-upgrade/INSTALL_MULTI_TENANT_AUTH_OAUTH.md

Additional files:
- mvp-upgrade/app/Services/OrganizationOAuthConfig.php
- mvp-upgrade/app/Http/Middleware/EnsureOrganizationApproved.php
- mvp-upgrade/patches/OAuthController-per-organization-credentials.txt
- mvp-upgrade/patches/Organization-model-registration.txt
- mvp-upgrade/config/admin.php.example

MVP username login update (2026-10-10): added globally unique lowercase business usernames, username/password login for businesses and the .env-configured administrator, migration to add/backfill usernames, and User model fillable guidance. See mvp-upgrade/INSTALL_MULTI_TENANT_AUTH_OAUTH.md.
