on local at 2026-07-13 17:00:27
| 1 | CREATE TABLE `SERVERS` ( | |
| 2 | `server_id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| 3 | `server_name` varchar(120) NOT NULL, | |
| 4 | `hostname` varchar(255) DEFAULT NULL, | |
| 5 | `ip_address` varchar(45) DEFAULT NULL, | |
| 6 | `role` enum('central','agent','both') NOT NULL DEFAULT 'agent', | |
| 7 | `agent_version` varchar(40) DEFAULT NULL, | |
| 8 | `hmac_secret_last_rotated` timestamp NULL DEFAULT NULL, | |
| 9 | `last_heartbeat_at` timestamp NULL DEFAULT NULL, | |
| 10 | `status` enum('active','offline','disabled') NOT NULL DEFAULT 'active', | |
| 11 | `notes` varchar(500) DEFAULT NULL, | |
| 12 | `created_at` timestamp NULL DEFAULT NULL, | |
| 13 | `kind` enum('local','ssh_agent') NOT NULL DEFAULT 'local', | |
| 14 | `ssh_host` varchar(255) DEFAULT NULL, | |
| 15 | `ssh_user` varchar(64) DEFAULT NULL, | |
| 16 | `ssh_port` int(10) unsigned NOT NULL DEFAULT '22', | |
| 17 | `ssh_key_path` varchar(500) DEFAULT NULL, | |
| 18 | `ssh_options` varchar(500) DEFAULT NULL, | |
| 19 | `last_agent_scan_at` datetime DEFAULT NULL, | |
| 20 | `last_agent_error` varchar(500) DEFAULT NULL, | |
| 21 | `ssh_key_blob` text, | |
| 22 | `ssh_key_enc` varchar(40) DEFAULT NULL, | |
| 23 | PRIMARY KEY (`server_id`), | |
| 24 | UNIQUE KEY `uq_server_name` (`server_name`), | |
| 25 | KEY `idx_heartbeat` (`last_heartbeat_at`), | |
| 26 | KEY `idx_status` (`status`) | |
| 27 | ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 |