Diff -- drift_sense.SERVERS
Diff
drift_sense.SERVERS
on local at 2026-07-10 22:20:22
Added
+17
lines
Removed
-0
lines
Context
0
unchanged
Blobs
from
to 194c117057c6
to 194c117057c6
Unified diff
Naive LCS-based line diff. Additions in emerald, deletions in rose. Both sides decompressed live from BLOB_STORE.| 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 | PRIMARY KEY (`server_id`), | |
| 14 | UNIQUE KEY `uq_server_name` (`server_name`), | |
| 15 | KEY `idx_heartbeat` (`last_heartbeat_at`), | |
| 16 | KEY `idx_status` (`status`) | |
| 17 | ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 |