on local at 2026-07-13 19:57:53
| 1 | CREATE TABLE `BLOB_INTEGRITY_LOG` ( | |
| 2 | `check_id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| 3 | `blob_sha` char(64) NOT NULL, | |
| 4 | `status` enum('ok','corrupt','missing') NOT NULL, | |
| 5 | `checked_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, | |
| 6 | `detail` varchar(500) DEFAULT NULL, | |
| 7 | PRIMARY KEY (`check_id`), | |
| 8 | KEY `sha_ix` (`blob_sha`), | |
| 9 | KEY `when_ix` (`checked_at`) | |
| 10 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 |