Database Setup & Migration

Back to Dashboard

Database Status

Check the status of all required database tables and run migrations if needed.

Table Name	Status	Row Count
`system_types`	Exists	11
`systems`	Exists	30
`proxmox_clusters`	Exists	0
`proxmox_nodes`	Exists	0
`proxmox_vms`	Exists	0
`proxmox_storage`	Exists	0
`synology_nas`	Exists	0
`servers`	Exists	0
`services`	Exists	0
`opnsense_firewalls`	Exists	0
`ubiquiti_devices`	Exists	0
`clusters`	Exists	3
`cluster_nodes`	Exists	0
`metrics_history`	Exists	0
`alerts`	Exists	0
`credentials`	Exists	6
`system_credentials`	Exists	10
`credential_usage_log`	Exists	0

SQL Files

The following SQL files will be executed:

schema.sql Main Database Schema Found
credentials_schema.sql Credentials Schema Found

Safety Information

This script uses CREATE TABLE IF NOT EXISTS - safe to run multiple times
Existing data will not be modified or deleted
Only missing tables and structures will be created
Always backup your database before running migrations