Diff -- drift_sense.CONTAINER_TARGETS
Diff
drift_sense.CONTAINER_TARGETS
on local at 2026-07-10 22:20:22
Added
+17
lines
Removed
-0
lines
Context
0
unchanged
Blobs
from
to 831ec9902905
to 831ec9902905
Unified diff
Naive LCS-based line diff. Additions in emerald, deletions in rose. Both sides decompressed live from BLOB_STORE.| 1 | CREATE TABLE `CONTAINER_TARGETS` ( | |
| 2 | `container_target_id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| 3 | `server_id` int(10) unsigned NOT NULL, | |
| 4 | `orchestrator` enum('docker','k8s','compose','other') NOT NULL DEFAULT 'docker', | |
| 5 | `container_id` varchar(80) NOT NULL, | |
| 6 | `container_name` varchar(200) DEFAULT NULL, | |
| 7 | `image` varchar(300) DEFAULT NULL, | |
| 8 | `started_at` timestamp NULL DEFAULT NULL, | |
| 9 | `stopped_at` timestamp NULL DEFAULT NULL, | |
| 10 | `overlay_upper_path` varchar(500) DEFAULT NULL, | |
| 11 | `is_monitored` tinyint(1) NOT NULL DEFAULT '1', | |
| 12 | `last_scanned_at` timestamp NULL DEFAULT NULL, | |
| 13 | PRIMARY KEY (`container_target_id`), | |
| 14 | UNIQUE KEY `uq_server_container` (`server_id`,`container_id`), | |
| 15 | KEY `idx_monitored` (`is_monitored`,`last_scanned_at`), | |
| 16 | KEY `idx_started` (`started_at`) | |
| 17 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 |