| Name | Business | Message | Status | Date | |
|---|---|---|---|---|---|
| Loading leads... | |||||
| Name | Category | Location | Rating | Status | Action |
|---|---|---|---|---|---|
| Loading... | |||||
| ID | Name | Slug | Industry |
|---|---|---|---|
| Loading... | |||
| ID | Industry | Slug |
|---|---|---|
| Loading... | ||
| Preview | Business | Type | Primary | Order |
|---|---|---|---|---|
| Loading... | ||||
| Name | Business | Message | Status | Date | |
|---|---|---|---|---|---|
| Loading... | |||||
Apply all pending SQL & PHP migration files from database/migrations/. Safe to run repeatedly — already-applied migrations are skipped automatically.
Preview which migrations are pending without applying them. Use before running against production to verify what will change.
PreviewView the raw JSON from the module status endpoint — shows which modules are active, their config, and current feature flags.
View JSONComplete registry with all fields including uninstalled modules. Useful for auditing what's available vs. what's currently enabled.
View JSONAdd ?ui=0 to any PHP page URL to bypass the UI layer and see the raw API output. Great for debugging what the server actually returns.
Add ?dev=1 to any PHP page to show a debug overlay with query count, total execution time, and the active module list for that request.
Export the selected scope from local and apply it non-destructively to production via INSERT IGNORE. Requires BWS_REMOTE_URL in api/admin/db-sync.php.
Fetch the selected scope from production and apply it non-destructively to local. Requires BWS_REMOTE_URL configured.
Download a SQL file of the selected scope from the current database. Use to manually transfer data between environments.
Upload a SQL export and apply it non-destructively using INSERT IGNORE — duplicate records are skipped. Safe to run without backing up first.
Download a full SQL backup of the current (local) database — CREATE TABLE + all data. Always do this before running any risky sync or restore.
Upload any SQL dump (including past migrations or backups). Creates missing tables, adds missing columns to existing tables, and inserts new rows with INSERT IGNORE — your members, leads, and edits are never overwritten.
Backs up the local DB, then sends it to production using the same smart merge — missing tables and columns are added, existing user data on the remote is left untouched.
Trigger a full backup of the production database and download the SQL. Requires BWS_REMOTE_URL configured.
Destructive. Upload a full backup SQL and apply it to the current database. Runs DROP TABLE + CREATE TABLE as-is. Always back up first.
View all database tables with row counts, storage sizes, and sync group assignments (content / users / other).
See
seed_bws_backend.md for the build sequence and priority.