Diff -- drift_sense.ALERT_RULES

O Operator
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
Unified diff
Naive LCS-based line diff. Additions in emerald, deletions in rose. Both sides decompressed live from BLOB_STORE.
1CREATE 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