on local at 2026-07-13 19:57:53
| 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 |