1CREATE TABLE IF NOT EXISTS security_probes (2 bucket INTEGER NOT NULL,3 scanner_id TEXT NOT NULL,4 address INTEGER NOT NULL CHECK (address BETWEEN 0 AND 65535),5 vault_slot INTEGER NOT NULL CHECK (vault_slot BETWEEN 0 AND 15),6 is_live INTEGER NOT NULL CHECK (is_live IN (0, 1)),7 country TEXT,8 asn INTEGER,9 PRIMARY KEY (bucket, scanner_id, address)10);1112CREATE TABLE IF NOT EXISTS security_signals (13 bucket INTEGER NOT NULL,14 scanner_id TEXT NOT NULL,15 kind TEXT NOT NULL,16 PRIMARY KEY (bucket, scanner_id, kind)17);1819CREATE TABLE IF NOT EXISTS security_incidents (20 name TEXT PRIMARY KEY,21 status TEXT NOT NULL CHECK (status IN ('open', 'closed')),22 severity INTEGER NOT NULL,23 opened_at INTEGER NOT NULL,24 last_seen_at INTEGER NOT NULL,25 last_alerted_at INTEGER NOT NULL,26 quiet_windows INTEGER NOT NULL,27 peak_addresses INTEGER NOT NULL,28 total_addresses INTEGER NOT NULL,29 total_live_hits INTEGER NOT NULL,30 total_rate_limited INTEGER NOT NULL,31 vault_mask INTEGER NOT NULL32);