Diff -- drift_sense.RESTORE_LOG

O Operator
Diff

drift_sense.RESTORE_LOG

on local at 2026-07-11 23:35:02

Added
+15
lines
Removed
-0
lines
Context
0
unchanged
Blobs
from
to 0213e8ab68a0
Unified diff
Naive LCS-based line diff. Additions in emerald, deletions in rose. Both sides decompressed live from BLOB_STORE.
1CREATE TABLE `RESTORE_LOG` (
2 `restore_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3 `restored_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
4 `source_change_id` bigint(20) unsigned NOT NULL,
5 `server_id` int(10) unsigned NOT NULL,
6 `target_file` varchar(1000) NOT NULL,
7 `source_blob_sha` varchar(64) NOT NULL,
8 `backup_path` varchar(1000) DEFAULT NULL,
9 `status` enum('success','failed','dry_run') NOT NULL DEFAULT 'success',
10 `error_message` varchar(500) DEFAULT NULL,
11 `restored_by` varchar(120) NOT NULL DEFAULT 'operator',
12 PRIMARY KEY (`restore_id`),
13 KEY `idx_target` (`target_file`(191)),
14 KEY `idx_time` (`restored_at`)
15) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4