on local at 2026-07-13 19:57:53
| 1 | CREATE TABLE `CONFIG_DRIFT_BASELINES` ( | |
| 2 | `baseline_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, | |
| 3 | `container_target_id` int(10) unsigned NOT NULL, | |
| 4 | `baseline_captured_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, | |
| 5 | `file_path` varchar(1000) NOT NULL, | |
| 6 | `baseline_blob_sha` char(64) NOT NULL, | |
| 7 | `is_drifted` tinyint(1) NOT NULL DEFAULT '0', | |
| 8 | `drift_first_seen_at` timestamp NULL DEFAULT NULL, | |
| 9 | PRIMARY KEY (`baseline_id`), | |
| 10 | KEY `idx_container_path` (`container_target_id`), | |
| 11 | KEY `idx_drifted` (`is_drifted`,`drift_first_seen_at`) | |
| 12 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 |