Diff -- drift_sense.ALERT_DELIVERIES
Diff
drift_sense.ALERT_DELIVERIES
on local at 2026-07-11 18:25:02
Added
+16
lines
Removed
-0
lines
Context
0
unchanged
Blobs
from
to aad6474a00eb
to aad6474a00eb
Unified diff
Naive LCS-based line diff. Additions in emerald, deletions in rose. Both sides decompressed live from BLOB_STORE.| 1 | CREATE TABLE `ALERT_DELIVERIES` ( | |
| 2 | `delivery_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, | |
| 3 | `alert_rule_id` int(10) unsigned NOT NULL, | |
| 4 | `fired_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, | |
| 5 | `source_kind` enum('file','schema') NOT NULL, | |
| 6 | `source_id` bigint(20) unsigned NOT NULL, | |
| 7 | `match_summary` varchar(500) DEFAULT NULL, | |
| 8 | `delivery_status` enum('pending','sent','failed','skipped') NOT NULL DEFAULT 'pending', | |
| 9 | `http_status` int(11) DEFAULT NULL, | |
| 10 | `http_response` text, | |
| 11 | `error_message` text, | |
| 12 | PRIMARY KEY (`delivery_id`), | |
| 13 | KEY `idx_rule` (`alert_rule_id`,`fired_at`), | |
| 14 | KEY `idx_fired` (`fired_at`), | |
| 15 | KEY `idx_source` (`source_kind`,`source_id`) | |
| 16 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 |