Diff -- drift_sense.ALERT_RULES
Diff
drift_sense.ALERT_RULES
on local at 2026-07-12 00:05:01
Added
+3
lines
Removed
-0
lines
Context
19
unchanged
Blobs
from 65784959e8b4
to bf5a4e0eeb32
to bf5a4e0eeb32
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_RULES` ( |
| 2 | 2 | `alert_rule_id` int(10) unsigned NOT NULL AUTO_INCREMENT, |
| 3 | 3 | `rule_name` varchar(200) NOT NULL, |
| 4 | 4 | `is_active` tinyint(1) NOT NULL DEFAULT '1', |
| 5 | 5 | `match_kind` enum('file','schema','either') NOT NULL DEFAULT 'either', |
| 6 | 6 | `match_path_glob` varchar(500) DEFAULT NULL, |
| 7 | 7 | `match_status_list` varchar(200) DEFAULT NULL, |
| 8 | 8 | `exclude_ts_only` tinyint(1) NOT NULL DEFAULT '1', |
| 9 | 9 | `delivery_kind` enum('slack','discord','generic_webhook','email') NOT NULL DEFAULT 'generic_webhook', |
| 10 | 10 | `delivery_url` varchar(2000) DEFAULT NULL, |
| 11 | 11 | `delivery_email` varchar(500) DEFAULT NULL, |
| 12 | 12 | `rate_limit_per_min` int(10) unsigned NOT NULL DEFAULT '0', |
| 13 | 13 | `coalesce_window_s` int(10) unsigned NOT NULL DEFAULT '0', |
| 14 | 14 | `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, |
| 15 | 15 | `last_fired_at` datetime DEFAULT NULL, |
| 16 | 16 | `fire_count` int(10) unsigned NOT NULL DEFAULT '0', |
| 17 | `frequency_threshold` int(10) unsigned NOT NULL DEFAULT '0', | |
| 18 | `frequency_window_min` int(10) unsigned NOT NULL DEFAULT '60', | |
| 19 | `last_frequency_fire_at` datetime DEFAULT NULL, | |
| 17 | 20 | PRIMARY KEY (`alert_rule_id`), |
| 18 | 21 | KEY `idx_active` (`is_active`) |
| 19 | 22 | ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 |