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