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