Diff -- drift_sense.PIN_DRIFT_LOG

O Operator
Diff

drift_sense.PIN_DRIFT_LOG

on local at 2026-07-12 00:20:02

Added
+15
lines
Removed
-0
lines
Context
0
unchanged
Blobs
from
to 35219900dd22
Unified diff
Naive LCS-based line diff. Additions in emerald, deletions in rose. Both sides decompressed live from BLOB_STORE.
1CREATE TABLE `PIN_DRIFT_LOG` (
2 `drift_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3 `detected_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
4 `named_release_id` int(10) unsigned NOT NULL,
5 `pin_id` bigint(20) unsigned NOT NULL,
6 `file_name` varchar(1000) NOT NULL,
7 `pinned_sha` varchar(64) NOT NULL,
8 `current_sha` varchar(64) DEFAULT NULL,
9 `file_changes_id` bigint(20) unsigned DEFAULT NULL,
10 `notified` tinyint(1) NOT NULL DEFAULT '0',
11 PRIMARY KEY (`drift_id`),
12 KEY `idx_release` (`named_release_id`),
13 KEY `idx_pin` (`pin_id`),
14 KEY `idx_time` (`detected_at`)
15) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4