Diff -- drift_sense.SERVERS
Diff
drift_sense.SERVERS
on local at 2026-07-11 23:20:01
Added
+2
lines
Removed
-0
lines
Context
25
unchanged
Blobs
from fc918276c030
to 764f415d0837
to 764f415d0837
Unified diff
Naive LCS-based line diff. Additions in emerald, deletions in rose. Both sides decompressed live from BLOB_STORE.| 1 | 1 | CREATE TABLE `SERVERS` ( |
| 2 | 2 | `server_id` int(10) unsigned NOT NULL AUTO_INCREMENT, |
| 3 | 3 | `server_name` varchar(120) NOT NULL, |
| 4 | 4 | `hostname` varchar(255) DEFAULT NULL, |
| 5 | 5 | `ip_address` varchar(45) DEFAULT NULL, |
| 6 | 6 | `role` enum('central','agent','both') NOT NULL DEFAULT 'agent', |
| 7 | 7 | `agent_version` varchar(40) DEFAULT NULL, |
| 8 | 8 | `hmac_secret_last_rotated` timestamp NULL DEFAULT NULL, |
| 9 | 9 | `last_heartbeat_at` timestamp NULL DEFAULT NULL, |
| 10 | 10 | `status` enum('active','offline','disabled') NOT NULL DEFAULT 'active', |
| 11 | 11 | `notes` varchar(500) DEFAULT NULL, |
| 12 | 12 | `created_at` timestamp NULL DEFAULT NULL, |
| 13 | 13 | `kind` enum('local','ssh_agent') NOT NULL DEFAULT 'local', |
| 14 | 14 | `ssh_host` varchar(255) DEFAULT NULL, |
| 15 | 15 | `ssh_user` varchar(64) DEFAULT NULL, |
| 16 | 16 | `ssh_port` int(10) unsigned NOT NULL DEFAULT '22', |
| 17 | 17 | `ssh_key_path` varchar(500) DEFAULT NULL, |
| 18 | 18 | `ssh_options` varchar(500) DEFAULT NULL, |
| 19 | 19 | `last_agent_scan_at` datetime DEFAULT NULL, |
| 20 | 20 | `last_agent_error` varchar(500) DEFAULT NULL, |
| 21 | `ssh_key_blob` text, | |
| 22 | `ssh_key_enc` varchar(40) DEFAULT NULL, | |
| 21 | 23 | PRIMARY KEY (`server_id`), |
| 22 | 24 | UNIQUE KEY `uq_server_name` (`server_name`), |
| 23 | 25 | KEY `idx_heartbeat` (`last_heartbeat_at`), |
| 24 | 26 | KEY `idx_status` (`status`) |
| 25 | 27 | ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 |