Diff -- drift_sense.ALERT_RULES
Diff
drift_sense.ALERT_RULES
on local at 2026-07-11 18:25:02
Added
+19
lines
Removed
-0
lines
Context
0
unchanged
Blobs
from
to 54f419cc6a9b
to 54f419cc6a9b
Unified diff
Naive LCS-based line diff. Additions in emerald, deletions in rose. Both sides decompressed live from BLOB_STORE.| 1 | CREATE TABLE `ALERT_RULES` ( | |
| 2 | `alert_rule_id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| 3 | `rule_name` varchar(200) NOT NULL, | |
| 4 | `is_active` tinyint(1) NOT NULL DEFAULT '1', | |
| 5 | `match_kind` enum('file','schema','either') NOT NULL DEFAULT 'either', | |
| 6 | `match_path_glob` varchar(500) DEFAULT NULL, | |
| 7 | `match_status_list` varchar(200) DEFAULT NULL, | |
| 8 | `exclude_ts_only` tinyint(1) NOT NULL DEFAULT '1', | |
| 9 | `delivery_kind` enum('slack','discord','generic_webhook','email') NOT NULL DEFAULT 'generic_webhook', | |
| 10 | `delivery_url` varchar(2000) DEFAULT NULL, | |
| 11 | `delivery_email` varchar(500) DEFAULT NULL, | |
| 12 | `rate_limit_per_min` int(10) unsigned NOT NULL DEFAULT '0', | |
| 13 | `coalesce_window_s` int(10) unsigned NOT NULL DEFAULT '0', | |
| 14 | `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, | |
| 15 | `last_fired_at` datetime DEFAULT NULL, | |
| 16 | `fire_count` int(10) unsigned NOT NULL DEFAULT '0', | |
| 17 | PRIMARY KEY (`alert_rule_id`), | |
| 18 | KEY `idx_active` (`is_active`) | |
| 19 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 |